# Formula returns incorrect result Classic List Threaded 4 messages Open this post in threaded view
|

## 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.14883666659093Can you tell me what the correct layout of the format in calc is?Thank you,Peter -- 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
Open this post in threaded view
|

## Fwd: Formula returns incorrect result No idea how this       gibberish got returned 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.14883666659093Can you tell me what the correct layout of the format in calc           is?Thank you,Peter -- 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 In reply to this post by pda123 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 In reply to this post by pda123 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.14883666659093Can 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: [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 Windows10 / LibreOffice  (latest?)