the angle format (º ‘ ‘’) and calculation?

macropod · #1 04-28-2012, 04:27 PM

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.

Jamal NUMAN · #2 05-01-2012, 01:36 AM

Quote:

Originally Posted by macropod

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.

Thank you very much Paul for your distinct effort in resolving this thread. Such creative solution reflects your massive experience and knowledge in how to overcome challenges innovatively.

I’ll see If i may encounter in more challenges regarding angles format!

Appreciated

Best

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Calculation	Lights	Excel	5	04-18-2012 04:31 AM
calculation of start date	ketanco	Project	1	02-29-2012 07:01 AM
Formula calculation	danbl	Excel	8	02-23-2012 04:35 AM
Calculation within Cells	manich1	Excel	2	12-07-2011 02:59 PM
Angle Bracket Problem, STYLEREF in Header of a Protected Document	wordjunkie	Word	0	06-18-2010 04:34 AM