You are viewing a single comment's thread from:

RE: Kill Time At Work With Recreational Math: Calculate Sunset and Sunrise Times

in #steemstem8 years ago (edited)

Thanks. I found the problem: I had originally set the Western calendar date in cell C9 to start at 12 noon in order to emulate the Julian calendar pattern of starting the day at noon. I should not have done that.

The equation in cell C21 for J_transit also does this. I guess the person developing the system of equations was already compensating for this.

So there was a double compensation for the Julian calendar quirkiness of starting the day at noon which gave me the error of being off by 12 hours.

I have now adjusted cell C9 to start at midnight (12:00:01 am) and set cell C21 back to the form of the equation in Wikipedia and everything works.

Coin Marketplace

STEEM 0.06
TRX 0.31
JST 0.059
BTC 68904.51
ETH 2061.20
USDT 1.00
SBD 0.50