You are viewing a single comment's thread from:

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

in #steemstem7 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.32
TRX 0.26
JST 0.040
BTC 97628.16
ETH 3611.02
USDT 1.00
SBD 3.42