View Single Post
 
Old 04-28-2012, 04:27 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jamal,

You will get better results if you make all of the changes I have suggested. Even so, I think you have the wrong error values. In your worksheet, you display them as negative values:
Code:
Sum               540º00'25''
Count (n)                 5
Total Angles      540º00'00''
Total Error       -00º00'25''
Error/Angle       -00º00'05''
but the total error is really '00º00'25''', a positive value, since your included angle is too great. This amount, in total, has to be deducted from the other angles. A negative error would have to be added. You can get the correct result by changing C12 from:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9),"[hh]ºmm'ss''")
to:
=IF(C11<C9,"","-")&TEXT(ABS(C9-C11),"[hh]ºmm'ss''")
and changing C13 from:
=IF(C11>C9,"","-")&TEXT(ABS(C11-C9)/C10,"[hh]ºmm'ss''")
to:
=IF(C11<C9,"","-")&TEXT(ABS(C9-C11)/C10,"[hh]ºmm'ss''")
You will now get the correct values in column D also (00º00'05'').

Then, if you use the following formula in column E:
=C3-(C$9-C$11)/C$10
you will get the correct result for that column.

The formula in column I, for working with the corrected angles, should therefore be:
=MOD(I3+E4+7.5,15)

Similarly, the formulae in columns O & P, for calculation the distance corrections, should be:
=(H4/G$9)*M$10
and:
=(H4/G$9)*M11
and the formulae in columns Q & R, for calculating the correct distances, should be:
=M4-O4
and:
=N4-P4

See attached worksheet.
Attached Files
File Type: xlsx Angles.xlsx (14.9 KB, 57 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote