multilpy and additions in one line of lua

[Jay Ess 6]

Hi

 

I have this code in vba Etime = y * sin2l0 - 2# * e * sinm + 4# * e * y * sinm * cos2l0 - 0.5 * y * y * sin4l0 - 1.25 * e * e * sin2m

 

which returns 2.19286480758148

 

However when i run this lua as follows Etime = y * sin2l0 - 2 * e * sinm + 4 * e * y * sinm * cos2l0 - 0.5 * y * y * sin4l0 - 1.25 * e * e * sin2m

 

I get a different result of -23.475237189689

 

Can anyone please guide me what I am doing wrong please?

 

Many thanks for any help provided.

 

 

Here are the variables with the correct numbers in both vba and in lua

y = 4.3027925017093

e = 1.6699503037352

sin2l0 -0.16774718359489
sinm -0.9503036952014
cos2l0 0.98583004741993
sin4l0 -0.33074042791581
sin2m 0.5917054702608
 

Edited September 17, 2021 by Jay Ess

[SmartHomeEddy 1,005]

I wouldn't expect it, but could it be some missing ()  ?

[tinman 1,070]

6 hours ago, Jay Ess said:

Can anyone please guide me what I am doing wrong please?

 

no idea, i see same result in

Please login or register to see this link.

as in LUA

 

Please login or register to see this attachment.

 

 

 

[Jay Ess 6]

in lua i am getting the same results as you howver in a spreadsheet running this code i am getting 2.19286480758148E-02

[petergebruers 1,268]

6 hours ago, Jay Ess said:

I get a different result of -23.475237189689

 

I get that a same number  Python

 

Please login or register to see this code.

 

15 minutes ago, Jay Ess said:

howver in a spreadsheet running this code i am getting 2.19286480758148E-02

 

Since Lua test 1  (you), Lua test 2 and Vb test 2 (tinman) and Python (my test) agree that it is about -23.5 I would suggest that your spreadsheet is not calculating the same thing.

[tinman 1,070]

1 hour ago, Jay Ess said:

in lua i am getting the same results as you howver in a spreadsheet running this code i am getting 2.19286480758148E-02

 

legit S/N?

 

 

 

 

[Jay Ess 6]

yes i know i think i am loosing the plot here, i hvae enclosed the spreadsheet file i am working on as something is definetly wrong here

 

i am trying to replicate calcEquationOfTime(t)

and it gives me a different value then what you are getting and what i am getting something is very weird here if you replicate the Etime you end up getting a different value

Please login or register to see this attachment.