Skip to Content

Register Login

工业业务领域支持中心

Technical Forum

Navigation

Sunrise Sunset PPCL - calculations using Excel and something isn't working

Created by: AutoGen_7210668 at: 3/25/2021 9:13 PM (1 Replies)

Rating (0)

Thanks 0

2 Entries

3/25/2021 9:13 PM	Rate (0)
AutoGen_7210668 Member Joined: 11/19/2019 Last visit: 8/5/2021 Posts: 2 Rating: (0)	Has anyone used this recently? I checked the calculations using Excel, and something isn't working. (I did make sure to convert to/from radians/degrees in Excel formulas, and the intermediate values calculate the same.) ------------------------------------------------------------------------------------------ Split from Sunrise Sunset PPCL.
	Last edited by: Jen_Moderator at: 03/26/2021 10:32:04 New subject after splitting
Suggestion To thank Quote Answer

3/26/2021 5:24 PM	Rate (0)
AutoGen_7210668 Member Joined: 11/19/2019 Last visit: 8/5/2021 Posts: 2 Rating: (0)	Found a promising algorithm written in Python, but it needs arc-sine and arc-cosine. Ended up using this, based on NOAA calculations for Houston: 100 IF("$DOY" .LE. 91) THEN GOTO 150 110 IF("$DOY" .LE. 182) THEN GOTO 180 120 IF("$DOY" .LE. 273) THEN GOTO 210 130 GOTO 240 140 C 150 TABLE("$DOY","$SUNRIS",1,7.267,16,7.267,31,7.167,46,6.983,61,6.733,76,6.433,91,6.133) 160 TABLE("$DOY","$SUNSET",1,17.517,16,17.717,31,17.933,46,18.133,61,18.317,76,18.483,91,18.633) 170 GOTO 270 180 TABLE("$DOY","$SUNRIS",92,6.117,107,5.833,122,5.583,137,5.417,152,5.317,167,5.3,182,5.367) 190 TABLE("$DOY","$SUNSET",92,18.65,107,18.8,122,18.967,137,19.117,152,19.267,167,19.367,182,19.417) 200 GOTO 270 210 TABLE("$DOY","$SUNRIS",183,5.383,198,5.5,213,5.65,228,5.8,243,5.933,258,6.067,273,6.217) 220 TABLE("$DOY","$SUNSET",183,19.417,198,19.35,213,19.217,228,19,243,18.717,258,18.417,273,18.1) 230 GOTO 270 240 TABLE("$DOY","$SUNRIS",274,6.217,289,6.367,304,6.55,319,6.75,334,6.95,349,7.133,365,7.25) 250 TABLE("$DOY","$SUNSET",274,18.083,289,17.783,304,17.55,319,17.383,334,17.317,349,17.367,365,17.5) 260 GOTO 270 270 C 280 "$SUNRIS" = "$SUNRIS" + "AHU01.DST" 290 "$SUNSET" = "$SUNSET" + "AHU01.DST"

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on