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: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
