At 22:41 08/06/2019 -0400, Carl "Peter" Winerich wrote:

>I'm trying to calculate the Equation of Time

>(EoT) to determine the difference between LAN

>(Local Apparent Noon) and GMT/UT-1 Greenwich

>Mean Time. Then I want to plot the EoT curve (a

>project for later, not now) The following is the

>formula I use on my calculator. The formula gives a "close enough" EoT

>9.87xsin(2x360(3-81)÷365)-7.67 x sin(360(3-81)÷365+78.7)

>=-4.584625249 (or.... -4 minutes 35.1 seconds...plus or minus)

>Calc doesn't give the same answer.

It does if you translate the formula correctly.

>Here's the formula in calc;

>=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))

>The answer it returns is: -2.14883666659093

>Can you tell me what the correct layout of the format in calc is?

You have failed to close one set of parentheses -

at the end of the first SIN() expression (perhaps

you forgot to close the first RADIANS()

expression, in fact) - but then added a spare

closing parenthesis at the end of your

expression. The effect is that the first SIN()

expression includes all of the second part of your formula.

Try:

=9.87*SIN(RADIANS(2*360*(3-81)/365))-7.67*SIN(RADIANS(360*(3-81)/365+78.7))

instead.

I trust this helps.

Brian Barker

--

To unsubscribe e-mail to:

[hidden email]
Problems?

https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more:

https://wiki.documentfoundation.org/NetiquetteList archive:

https://listarchives.libreoffice.org/global/users/Privacy Policy:

https://www.documentfoundation.org/privacy