Re: [libreoffice-users] Formula returns incorrect result
On 9-6-2019 04:41, Carl 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" EoT9.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. 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.1488359093Can you tell me what the correct layout
of the format in calc is?Thank you,Peter
Count the '(' and the ')'
=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))
should be
=9.87*SIN(RADIANS(2*360*(3-81)/365))-7.67*SIN(RADIANS(360*(3-81)/365+78.7))
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
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
Re: [libreoffice-users] Formula returns incorrect result
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.1488359093 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: users+unsubscr...@global.libreoffice.org 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
[libreoffice-users] Formula returns incorrect result
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" EoT9.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. 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.1488359093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org 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
