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.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: users+unsubscribe@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