Solved: Misbehaving spreadsheet

[mdmackillop]

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]

Not sure Malcolm but try this in cell J4:
=COS(RADIANS(C4))

[lucas]

and this in K4:
=SIN(RADIANS(C4))*D4

[mdmackillop]

Hi Steve,
That solution works, so I'll change my formulae accordingly, but I still wonder what's gone wrong with the original.

[mdmackillop]

Problem solved.
Someone had changed PI()/180 to 180/PI()

[Ken Puls]

LOL! The before picture seems much more interesting though. :)

[mdmackillop]

I agree Ken, but as the plot of the layout of a gas pipeline, it was a little confusing.:SHOCKED:

[johnske]

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]

And you've gotta think of the economic advantages of doing it that way...

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