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.