PDA

View Full Version : Solved: Misbehaving spreadsheet



mdmackillop
10-31-2006, 07:31 AM
This is part of a large project which gets updated once a year, and this is the 4th year of use. The results being produced are nonsence, and I can't see the reason. Basically we write in angles and distances and use this to plot a chart. The angles are entered in degrees/minutes/seconds, and there is a simple function Dec to convert this to degreees and decimal. X and Y co-ordinates are created from the angle and distance.
Columns J & K have been added to show simple Cos and Sin functions applied to the angles. As can be seen from the yellow highlighted values, these are varying widely for similar angles.
Any thoughts?

lucas
10-31-2006, 07:42 AM
Not sure Malcolm but try this in cell J4:
=COS(RADIANS(C4))

lucas
10-31-2006, 07:56 AM
and this in K4:
=SIN(RADIANS(C4))*D4

mdmackillop
10-31-2006, 08:18 AM
Hi Steve,
That solution works, so I'll change my formulae accordingly, but I still wonder what's gone wrong with the original.

mdmackillop
10-31-2006, 10:30 AM
Problem solved.
Someone had changed PI()/180 to 180/PI()

Ken Puls
10-31-2006, 12:27 PM
LOL! The before picture seems much more interesting though. :)

mdmackillop
10-31-2006, 12:35 PM
I agree Ken, but as the plot of the layout of a gas pipeline, it was a little confusing.:SHOCKED:

johnske
10-31-2006, 01:12 PM
I agree Ken, but as the plot of the layout of a gas pipeline, it was a little confusing.:SHOCKED:I think it was much more interesting also. And you've gotta think of the economic advantages of doing it that way - i.e. the extra employment opportunities and, when it's finished it could quite easily become a tourist attraction :rofl:

Ken Puls
10-31-2006, 04:34 PM
And you've gotta think of the economic advantages of doing it that way...

Built in reserves, too. In case of times of crisis. :)