Formula returns incorrect result

classic Classic list List threaded Threaded
4 messages Options
pda123 pda123
Reply | Threaded
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/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
pda123 pda123
Reply | Threaded
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/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Brian Barker Brian Barker
Reply | Threaded
Open this post in threaded view
|

Re: Formula returns incorrect result

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/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Luuk Luuk
Reply | Threaded
Open this post in threaded view
|

Re: Formula returns incorrect result

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/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
Windows10 / LibreOffice  (latest?)