{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sun Path","Solar Panel","Solar Irradiance","Custom","Equinox","Summer Solstice","Winter Solstice","Calculations"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sun Path","index":0,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,11,5,12],[8,11,8,12],[11,11,12,12],[0,2,25,10],[1,11,2,12],[3,12,4,12],[6,12,7,12],[15,0,15,1],[16,0,16,1],[1,0,2,1],[11,0,12,1],[9,0,10,1],[13,0,13,1],[14,0,14,1],[29,2,29,3],[29,4,29,6],[29,7,29,10],[27,4,27,6],[27,7,27,10],[28,2,28,10],[27,2,27,3]]}
[null,null,"SUN PATH DIAGRAM GRAPH"]
["Input Data",null,null,null,null,null,null,null,null,null,null,"Transition"]
[]
[null,null,null,null,null,null,null,null,null,null,null,2018]
["Date","2018-08-15",null,null,null,null,null,null,null,null,null,{"$f":"Calculations!AK18","v":"2018-02-05"}]
["Time","12:00:00"]
["Latitude",26.76,null,null,null,null,null,null,null,null,null,"24-Hour"]
["Longitude",75.78,null,null,null,null,null,null,null,null,null,{"$f":"Calculations!AJ12/1440","v":"09:14:00"}]
["Time Zone",5.5]
[{"$f":"IF(B6<Custom!D22, \"Time Below Sunrise : \" & TEXT(Custom!D22,\"H:MM\"), IF(B6>Custom!D23, \"Time Above Sunset : \" & TEXT(Custom!D23,\"H:MM\"), \"\"))","v":""}]
[]
["Select Data",null,null,null,null,null,null,null,null,null,null,"Output Data"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Altitude Angle",{"$f":"TEXT(Custom!H14, \"0.00\") & \"°\"","v":"75.07°"}]
[null,null,null,null,null,null,null,null,null,null,null,"Azimuth Angle",{"$f":"TEXT(Custom!H21,\"0.00\") & \"°\"","v":"148.79°"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Sunrise",{"$f":"Custom!D22","v":"06:03:11.183"}]
[null,null,null,null,null,null,null,null,null,null,null,"Sunset",{"$f":"Custom!D23","v":"19:00:02.048"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Developed by :",null,"HARSH SHARMA",null,null,"M.Tech. (Centre for Energy & Environment), MNIT"]
[]
[null,null,"Guided by :",null,"Dr. JYOTIRMAY  MATHUR",null,null,"Professor, Malviya National Institute of Technology"]

{"sheet":"Solar Panel","index":1,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,12,26,14],[27,12,28,14],[29,12,30,14],[0,23,35,25],[4,17,5,17],[4,22,5,22],[27,15,28,16],[0,11,3,16],[18,11,18,16],[20,11,20,12],[20,13,20,14],[20,15,20,16],[22,11,22,12],[22,13,22,14],[17,11,17,12],[17,13,17,14],[17,15,17,16],[23,11,23,12],[23,13,23,14],[23,15,23,16],[22,15,22,16],[21,11,21,16],[19,11,19,12],[19,13,19,14],[19,15,19,16],[11,11,11,16],[12,11,12,12],[12,13,12,14],[12,15,12,16],[8,14,8,16],[13,11,13,12],[13,13,13,14],[13,15,13,16],[15,11,15,16],[16,11,16,16],[14,11,14,12],[14,13,14,14],[14,15,14,16],[4,18,5,21],[0,17,3,22],[4,11,5,16],[8,12,8,13],[9,12,9,13],[9,15,9,16],[7,12,7,13],[7,15,7,16],[6,17,30,22],[32,12,32,13],[32,14,32,16],[34,12,34,13],[34,14,34,16],[34,17,34,22],[32,17,32,22],[33,12,33,22]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SOLAR PANEL ANGLES",null,null,null,null,null,null,"Horizontal Axis - Tilt Angle"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date","2018-08-15",null,"Time","09:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,"Latitude",26.912400000000002,null,{"$f":"IF(P8<'Solar Irradiance'!D22, \"Time Below Sunrise : \" & TEXT('Solar Irradiance'!D22,\"HH:MM\"), IF(P8>'Solar Irradiance'!D23, \"Time Above Sunset : \" & TEXT('Solar Irradiance'!D23,\"HH:MM\"), \"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Longitude",75.787300000000002,null,"Time Zone",5.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Vertical Axis - Tilt Angle"]
[null,null,null,null,null,null,null,null,null,null,null,"Ideal Case",null,"Season-wise",null,"Custom"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT('Solar Irradiance'!K8,\"0.00\") & \"°\"","v":"50.93°"},null,{"$f":"TEXT('Solar Irradiance'!L8,\"0.00\") & \"°\"","v":"0.72°"},null,30]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Horizontal Axis - Tilt Angle"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Solar Irradiance'!H6<0,AzimuthToCompassAngle(360-'Solar Irradiance'!H15),AzimuthToCompassAngle('Solar Irradiance'!H15))","v":"93.9° SE"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Angle of Incidence"]
[null,null,null,null,null,null,null,null,null,null,null,"Ideal Case",null,"Season-wise",null,"Custom"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT('Solar Irradiance'!K11,\"0.00\") & \"°\"","v":"0.00°"},null,{"$f":"TEXT('Solar Irradiance'!L11,\"0.00\") & \"°\"","v":"50.21°"},null,{"$f":"TEXT('Solar Irradiance'!M11,\"0.00\") & \"°\"","v":"20.93°"}]
[null,null,null,null,null,null,null,null,null,null,null,"Solar Irradiance (W/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"Ideal Case",null,"Season-wise",null,"Custom"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Solar Irradiance'!K14","v":1333.4187695462804},null,{"$f":"'Solar Irradiance'!L14","v":853.40134669731481},null,{"$f":"'Solar Irradiance'!M14","v":1245.447799644234}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Developed by :",null,"HARSH SHARMA",null,null,"M.Tech. (Centre for Energy & Environment), MNIT"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Guided by :",null,"Dr. JYOTIRMAY  MATHUR",null,null,"Professor, Malviya National Institute of Technology"]

{"sheet":"Solar Irradiance","index":2,"n_rows":47,"n_cols":21,"rows_kept":47,"cut":false,"hidden":true,"merged":[[10,11,11,11],[10,12,11,12],[12,10,12,12],[13,10,14,10],[13,11,14,11],[13,12,14,12],[23,2,46,2],[3,2,3,3],[3,6,3,7],[11,2,11,3],[11,6,11,7],[18,18,18,20],[1,2,2,12],[6,10,6,12],[9,10,9,12],[4,10,5,10],[17,2,18,8],[17,10,17,20],[18,10,18,12],[18,14,18,16],[3,10,3,12],[4,11,5,11],[4,12,5,12],[7,10,8,10],[7,11,8,11],[7,12,8,12],[10,10,11,10]]}
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS"]
[]
[null,null,"Data",null,null,null,"Basic Variables",null,null,null,"Solar Irradiance Variables"]
[null,null,"Date :",{"$f":"'Solar Panel'!M8","v":"2018-08-15"},null,null,"Declination Angle (δ)",{"$f":"IF(ISBLANK(D5),\"\",Declination(D13))","v":13.7835641662585},null,null,"Ideal Case","Season-wise","Custom"]
[null,null,"Time :",{"$f":"'Solar Panel'!P8","v":"09:00:00"},null,null,"Hour Angle (ω)",{"$f":"IF(ISBLANK(D9),\"\",HourAngle(H8))","v":52.895266000644611}]
[null,null,"Latitude (φ) :",{"$f":"'Solar Panel'!M9","v":26.912400000000002},null,null,"Equation of Time",{"$f":"IF(ISBLANK(D5),\"\",Eot(D14))","v":-4.7302640025784877},null,null,"Tilt Angle (β)"]
[null,null,"Longitude :",{"$f":"'Solar Panel'!M10","v":75.787300000000002},null,null,"Local Solar Time",{"$f":"IF(ISBLANK(D9),\"\",LST(D6,D10,D8,H7))","v":"08:28:25.136"},null,null,{"$f":"K21","v":50.928580409098075},{"$f":"IF(ISNA(K8), NA(), BetaAngle(D7,D13))","v":0.72116000000000113},{"$f":"'Solar Panel'!P14","v":30}]
[null,null,"Time Zone :",{"$f":"'Solar Panel'!P10","v":5.5}]
[null,null,"Std. Time Longt :",{"$f":"15*D9","v":82.5},null,null,null,null,null,null,"Incidence Angle (θi)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"L21","v":0},{"$f":"IF(ISNA(K11), NA(), IncidenceAngle(D7,H5,L8,H15,IF(H8>0.5, HourAngle(H8), HourAngleR(H8))))","v":50.207434821615536},{"$f":"IF(ISNA(K11), NA(), IF(ISBLANK(M8), \"\", IncidenceAngle(D7,H5,M8,H15,IF(H8>0.5, HourAngle(H8), HourAngleR(H8)))))","v":20.928646053694109}]
[null,null,"Day Number Calculation",null,null,null,"Derived Variables"]
[null,null,"nth Day",{"$f":"IF(ISBLANK(D5),\"\",D5-DATE(YEAR(D5),1,0))","v":227},null,null,"Zenith Angle (θz)",{"$f":"IF(ISBLANK(H6),\"\",Zenith(D7,H5,H6))","v":50.928580409098075},null,null,"Solar Irradiance (W/m2)"]
[null,null,"N",{"$f":"IF(ISBLANK(D5),\"\",(D13-1)*(360/365.25))","v":222.75154004106776},null,null,"Altitude Angle (α)",{"$f":"IF(ISBLANK(D9),\"\",(90 - H13))","v":39.071419590901925},null,null,{"$f":"M21","v":1333.4187695462804},{"$f":"IF(ISNA(K14), NA(), SolarConstant(D13)*COS(RADIANS(L11)))","v":853.40134669731481},{"$f":"IF(ISNA(K14), NA(), IF(ISBLANK(M8), \"\", SolarConstant(D13)*COS(RADIANS(M11))))","v":1245.447799644234}]
[null,null,null,null,null,null,"Solar Azimuth Angle (ϒs)",{"$f":"IF(ISBLANK(H6),\"\",Azimuth(H14,D7,H5,H6))","v":93.895482875625447}]
[]
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS",null,null,null,null,null,null,null,"SOLAR IRRADIANCE CALCULATIONS"]
[null,null,null,null,null,null,null,null,null,null,"Ideal Case",null,null,null,"Season-wise",null,null,null,"Custom"]
[null,null,null,"Time","Solar Time","Hour Angle","Altitude Angle","Azimuth Angle","Zenith Angle",null,"Tilt Angle","Incidence Angle","Solar Irradiance",null,"Tilt Angle","Incidence Angle","Solar Irradiance",null,"Tilt Angle","Incidence Angle","Solar Irradiance"]
[null,null,"Custom",{"$f":"D6","v":"09:00:00"},{"$f":"LST(D21,$D$10,$D$8,$H$7)","v":"08:28:25.136"},{"$f":"HourAngle(E21)","v":52.895266000644611},{"$f":"90 - Zenith($D$7,$H$5,F21)","v":39.071419590901925},{"$f":"Azimuth(G21,$D$7,$H$5,F21)","v":93.895482875625447},{"$f":"IF(G21<0, NA(), 90-G21)","v":50.928580409098075},null,{"$f":"IF(ISNA(I21), NA(), I21)","v":50.928580409098075},{"$f":"IF(ISNA(K21), NA(), IncidenceAngle($D$7,$H$5,K21,H21,IF(E21>0.5, HourAngle(E21), HourAngleR(E21))))","v":0},{"$f":"IF(ISNA(L21), NA(), SolarConstant($D$13)*COS(RADIANS(L21)))","v":1333.4187695462804},null,{"$f":"IF(ISNA(M21), NA(), BetaAngle($D$7,$D$13))","v":0.72116000000000113},{"$f":"IF(ISNA(O21), NA(), IncidenceAngle($D$7,$H$5,O21,H21,IF(E21>0.5, HourAngle(E21), HourAngleR(E21))))","v":50.207434821615536},{"$f":"IF(ISNA(P21), NA(), SolarConstant($D$13)*COS(RADIANS(P21)))","v":853.40134669731481},null,{"$f":"IF(ISNA(Q21), NA(), $M$8)","v":30},{"$f":"IF(ISNA(S21), NA(), IncidenceAngle($D$7,$H$5,S21,H21,IF(E21>0.5, HourAngle(E21), HourAngleR(E21))))","v":20.928646053694109},{"$f":"IF(ISNA(T21), NA(), SolarConstant($D$13)*COS(RADIANS(T21)))","v":1245.447799644234}]
[null,null,"Sun Rise",{"$f":"IF(ISBLANK(D9),\"\",Sunrise(D7,H5,D10,D8,H7))","v":"06:02:58.074"},{"$f":"LST(D22,$D$10,$D$8,$H$7)","v":"05:31:23.210"},{"$f":"HourAngle(E22)","v":97.153291704546419},{"$f":"90 - Zenith($D$7,$H$5,F22)","v":0},{"$f":"Azimuth(G22,$D$7,$H$5,F22)","v":74.502766006383254},90,null,90,{"$f":"IF(ISNA(K22), NA(), IncidenceAngle($D$7,$H$5,K22,H22,IF(E22>0.5, HourAngle(E22), HourAngleR(E22))))","v":0},{"$f":"IF(ISNA(L22), NA(), SolarConstant($D$13)*COS(RADIANS(L22)))","v":1333.4187695462804},null,{"$f":"IF(ISNA(M22), NA(), BetaAngle($D$7,$D$13))","v":0.72116000000000113},{"$f":"IF(ISNA(O22), NA(), IncidenceAngle($D$7,$H$5,O22,H22,IF(E22>0.5, HourAngle(E22), HourAngleR(E22))))","v":89.278856279110599},{"$f":"IF(ISNA(P22), NA(), SolarConstant($D$13)*COS(RADIANS(P22)))","v":16.782408633509444},null,{"$f":"IF(ISNA(Q22), NA(), $M$8)","v":30},{"$f":"IF(ISNA(S22), NA(), IncidenceAngle($D$7,$H$5,S22,H22,IF(E22>0.5, HourAngle(E22), HourAngleR(E22))))","v":59.999999999999993},{"$f":"IF(ISNA(T22), NA(), SolarConstant($D$13)*COS(RADIANS(T22)))","v":666.7093847731403}]
[null,null,"Sun Set",{"$f":"IF(ISBLANK(D9),\"\",Sunset(D7,H5,D10,D8,H7))","v":"19:00:11.654"},{"$f":"LST(D23,$D$10,$D$8,$H$7)","v":"18:28:36.790"},{"$f":"HourAngle(E23)","v":-97.153291704546461},{"$f":"90 - Zenith($D$7,$H$5,F23)","v":0},{"$f":"Azimuth(G23,$D$7,$H$5,F23)","v":74.502766006383226},90,null,90,{"$f":"IF(ISNA(K23), NA(), IncidenceAngle($D$7,$H$5,K23,H23,IF(E23>0.5, HourAngle(E23), HourAngleR(E23))))","v":0},{"$f":"IF(ISNA(L23), NA(), SolarConstant($D$13)*COS(RADIANS(L23)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O23), NA(), IncidenceAngle($D$7,$H$5,O23,H23,IF(E23>0.5, HourAngle(E23), HourAngleR(E23))))","v":89.278856279110599},{"$f":"IF(ISNA(P23), NA(), SolarConstant($D$13)*COS(RADIANS(P23)))","v":16.782408633509444},null,30,{"$f":"IF(ISNA(S23), NA(), IncidenceAngle($D$7,$H$5,S23,H23,IF(E23>0.5, HourAngle(E23), HourAngleR(E23))))","v":59.999999999999993},{"$f":"IF(ISNA(T23), NA(), SolarConstant($D$13)*COS(RADIANS(T23)))","v":666.7093847731403}]
[null,null,"24 Hour Time Sun Locations","01:00:00",{"$f":"LST(D24,$D$10,$D$8,$H$7)","v":"00:28:25.136"},{"$f":"HourAngle(E24)","v":172.89526600064463},{"$f":"90 - Zenith($D$7,$H$5,F24)","v":-48.723147863984764},{"$f":"Azimuth(G24,$D$7,$H$5,F24)","v":10.491280372739693},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K24), NA(), IncidenceAngle($D$7,$H$5,K24,H24,IF(E24>0.5, HourAngle(E24), HourAngleR(E24))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L24), NA(), SolarConstant($D$13)*COS(RADIANS(L24)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O24), NA(), IncidenceAngle($D$7,$H$5,O24,H24,IF(E24>0.5, HourAngle(E24), HourAngleR(E24))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P24), NA(), SolarConstant($D$13)*COS(RADIANS(P24)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S24), NA(), IncidenceAngle($D$7,$H$5,S24,H24,IF(E24>0.5, HourAngle(E24), HourAngleR(E24))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T24), NA(), SolarConstant($D$13)*COS(RADIANS(T24)))","v":{"$error":"#N/A"}}]
[null,null,null,"02:00:00",{"$f":"LST(D25,$D$10,$D$8,$H$7)","v":"01:28:25.136"},{"$f":"HourAngle(E25)","v":157.89526600064463},{"$f":"90 - Zenith($D$7,$H$5,F25)","v":-43.989425230494987},{"$f":"Azimuth(G25,$D$7,$H$5,F25)","v":30.528355144375382},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K25), NA(), IncidenceAngle($D$7,$H$5,K25,H25,IF(E25>0.5, HourAngle(E25), HourAngleR(E25))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L25), NA(), SolarConstant($D$13)*COS(RADIANS(L25)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O25), NA(), IncidenceAngle($D$7,$H$5,O25,H25,IF(E25>0.5, HourAngle(E25), HourAngleR(E25))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P25), NA(), SolarConstant($D$13)*COS(RADIANS(P25)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S25), NA(), IncidenceAngle($D$7,$H$5,S25,H25,IF(E25>0.5, HourAngle(E25), HourAngleR(E25))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T25), NA(), SolarConstant($D$13)*COS(RADIANS(T25)))","v":{"$error":"#N/A"}}]
[null,null,null,"03:00:00",{"$f":"LST(D26,$D$10,$D$8,$H$7)","v":"02:28:25.136"},{"$f":"HourAngle(E26)","v":142.89526600064463},{"$f":"90 - Zenith($D$7,$H$5,F26)","v":-35.650579423004118},{"$f":"Azimuth(G26,$D$7,$H$5,F26)","v":46.139779972580619},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K26), NA(), IncidenceAngle($D$7,$H$5,K26,H26,IF(E26>0.5, HourAngle(E26), HourAngleR(E26))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L26), NA(), SolarConstant($D$13)*COS(RADIANS(L26)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O26), NA(), IncidenceAngle($D$7,$H$5,O26,H26,IF(E26>0.5, HourAngle(E26), HourAngleR(E26))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P26), NA(), SolarConstant($D$13)*COS(RADIANS(P26)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S26), NA(), IncidenceAngle($D$7,$H$5,S26,H26,IF(E26>0.5, HourAngle(E26), HourAngleR(E26))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T26), NA(), SolarConstant($D$13)*COS(RADIANS(T26)))","v":{"$error":"#N/A"}}]
[null,null,null,"04:00:00",{"$f":"LST(D27,$D$10,$D$8,$H$7)","v":"03:28:25.136"},{"$f":"HourAngle(E27)","v":127.8952660006445},{"$f":"90 - Zenith($D$7,$H$5,F27)","v":-25.09286682016139},{"$f":"Azimuth(G27,$D$7,$H$5,F27)","v":57.809385964106987},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K27), NA(), IncidenceAngle($D$7,$H$5,K27,H27,IF(E27>0.5, HourAngle(E27), HourAngleR(E27))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L27), NA(), SolarConstant($D$13)*COS(RADIANS(L27)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O27), NA(), IncidenceAngle($D$7,$H$5,O27,H27,IF(E27>0.5, HourAngle(E27), HourAngleR(E27))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P27), NA(), SolarConstant($D$13)*COS(RADIANS(P27)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S27), NA(), IncidenceAngle($D$7,$H$5,S27,H27,IF(E27>0.5, HourAngle(E27), HourAngleR(E27))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T27), NA(), SolarConstant($D$13)*COS(RADIANS(T27)))","v":{"$error":"#N/A"}}]
[null,null,null,"05:00:00",{"$f":"LST(D28,$D$10,$D$8,$H$7)","v":"04:28:25.136"},{"$f":"HourAngle(E28)","v":112.89526600064474},{"$f":"90 - Zenith($D$7,$H$5,F28)","v":-13.243081383282288},{"$f":"Azimuth(G28,$D$7,$H$5,F28)","v":66.799437667837239},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K28), NA(), IncidenceAngle($D$7,$H$5,K28,H28,IF(E28>0.5, HourAngle(E28), HourAngleR(E28))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L28), NA(), SolarConstant($D$13)*COS(RADIANS(L28)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O28), NA(), IncidenceAngle($D$7,$H$5,O28,H28,IF(E28>0.5, HourAngle(E28), HourAngleR(E28))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P28), NA(), SolarConstant($D$13)*COS(RADIANS(P28)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S28), NA(), IncidenceAngle($D$7,$H$5,S28,H28,IF(E28>0.5, HourAngle(E28), HourAngleR(E28))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T28), NA(), SolarConstant($D$13)*COS(RADIANS(T28)))","v":{"$error":"#N/A"}}]
[null,null,null,"06:00:00",{"$f":"LST(D29,$D$10,$D$8,$H$7)","v":"05:28:25.136"},{"$f":"HourAngle(E29)","v":97.895266000644625},{"$f":"90 - Zenith($D$7,$H$5,F29)","v":-0.63704117835641227},{"$f":"Azimuth(G29,$D$7,$H$5,F29)","v":74.165930964122083},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K29), NA(), IncidenceAngle($D$7,$H$5,K29,H29,IF(E29>0.5, HourAngle(E29), HourAngleR(E29))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L29), NA(), SolarConstant($D$13)*COS(RADIANS(L29)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O29), NA(), IncidenceAngle($D$7,$H$5,O29,H29,IF(E29>0.5, HourAngle(E29), HourAngleR(E29))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P29), NA(), SolarConstant($D$13)*COS(RADIANS(P29)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S29), NA(), IncidenceAngle($D$7,$H$5,S29,H29,IF(E29>0.5, HourAngle(E29), HourAngleR(E29))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T29), NA(), SolarConstant($D$13)*COS(RADIANS(T29)))","v":{"$error":"#N/A"}}]
[null,null,null,"07:00:00",{"$f":"LST(D30,$D$10,$D$8,$H$7)","v":"06:28:25.136"},{"$f":"HourAngle(E30)","v":82.895266000644483},{"$f":"90 - Zenith($D$7,$H$5,F30)","v":12.412783770626788},{"$f":"Azimuth(G30,$D$7,$H$5,F30)","v":80.68483260907324},77.587216229373212,null,77.587216229373212,{"$f":"IF(ISNA(K30), NA(), IncidenceAngle($D$7,$H$5,K30,H30,IF(E30>0.5, HourAngle(E30), HourAngleR(E30))))","v":0},{"$f":"IF(ISNA(L30), NA(), SolarConstant($D$13)*COS(RADIANS(L30)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O30), NA(), IncidenceAngle($D$7,$H$5,O30,H30,IF(E30>0.5, HourAngle(E30), HourAngleR(E30))))","v":76.866072747510088},{"$f":"IF(ISNA(P30), NA(), SolarConstant($D$13)*COS(RADIANS(P30)))","v":302.99008016646241},null,30,{"$f":"IF(ISNA(S30), NA(), IncidenceAngle($D$7,$H$5,S30,H30,IF(E30>0.5, HourAngle(E30), HourAngleR(E30))))","v":47.587226638689643},{"$f":"IF(ISNA(T30), NA(), SolarConstant($D$13)*COS(RADIANS(T30)))","v":899.34695723957111}]
[null,null,null,"08:00:00",{"$f":"LST(D31,$D$10,$D$8,$H$7)","v":"07:28:25.136"},{"$f":"HourAngle(E31)","v":67.895266000644767},{"$f":"90 - Zenith($D$7,$H$5,F31)","v":25.704202175030019},{"$f":"Azimuth(G31,$D$7,$H$5,F31)","v":87.007932949927579},64.295797824969981,null,64.295797824969981,{"$f":"IF(ISNA(K31), NA(), IncidenceAngle($D$7,$H$5,K31,H31,IF(E31>0.5, HourAngle(E31), HourAngleR(E31))))","v":0},{"$f":"IF(ISNA(L31), NA(), SolarConstant($D$13)*COS(RADIANS(L31)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O31), NA(), IncidenceAngle($D$7,$H$5,O31,H31,IF(E31>0.5, HourAngle(E31), HourAngleR(E31))))","v":63.574613865441322},{"$f":"IF(ISNA(P31), NA(), SolarConstant($D$13)*COS(RADIANS(P31)))","v":593.41402184872027},null,30,{"$f":"IF(ISNA(S31), NA(), IncidenceAngle($D$7,$H$5,S31,H31,IF(E31>0.5, HourAngle(E31), HourAngleR(E31))))","v":34.295759416943973},{"$f":"IF(ISNA(T31), NA(), SolarConstant($D$13)*COS(RADIANS(T31)))","v":1101.590582272964}]
[null,null,null,"09:00:00",{"$f":"LST(D32,$D$10,$D$8,$H$7)","v":"08:28:25.136"},{"$f":"HourAngle(E32)","v":52.895266000644611},{"$f":"90 - Zenith($D$7,$H$5,F32)","v":39.071419590901925},{"$f":"Azimuth(G32,$D$7,$H$5,F32)","v":93.895482875625447},50.928580409098075,null,50.928580409098075,{"$f":"IF(ISNA(K32), NA(), IncidenceAngle($D$7,$H$5,K32,H32,IF(E32>0.5, HourAngle(E32), HourAngleR(E32))))","v":0},{"$f":"IF(ISNA(L32), NA(), SolarConstant($D$13)*COS(RADIANS(L32)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O32), NA(), IncidenceAngle($D$7,$H$5,O32,H32,IF(E32>0.5, HourAngle(E32), HourAngleR(E32))))","v":50.207434821615536},{"$f":"IF(ISNA(P32), NA(), SolarConstant($D$13)*COS(RADIANS(P32)))","v":853.40134669731481},null,30,{"$f":"IF(ISNA(S32), NA(), IncidenceAngle($D$7,$H$5,S32,H32,IF(E32>0.5, HourAngle(E32), HourAngleR(E32))))","v":20.928646053694109},{"$f":"IF(ISNA(T32), NA(), SolarConstant($D$13)*COS(RADIANS(T32)))","v":1245.447799644234}]
[null,null,null,"10:00:00",{"$f":"LST(D33,$D$10,$D$8,$H$7)","v":"09:28:25.136"},{"$f":"HourAngle(E33)","v":37.895266000644483},{"$f":"90 - Zenith($D$7,$H$5,F33)","v":52.30230283445831},{"$f":"Azimuth(G33,$D$7,$H$5,F33)","v":102.70111952880157},37.69769716554169,null,37.69769716554169,{"$f":"IF(ISNA(K33), NA(), IncidenceAngle($D$7,$H$5,K33,H33,IF(E33>0.5, HourAngle(E33), HourAngleR(E33))))","v":0},{"$f":"IF(ISNA(L33), NA(), SolarConstant($D$13)*COS(RADIANS(L33)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O33), NA(), IncidenceAngle($D$7,$H$5,O33,H33,IF(E33>0.5, HourAngle(E33), HourAngleR(E33))))","v":36.976526550520376},{"$f":"IF(ISNA(P33), NA(), SolarConstant($D$13)*COS(RADIANS(P33)))","v":1065.2442534526715},null,30,{"$f":"IF(ISNA(S33), NA(), IncidenceAngle($D$7,$H$5,S33,H33,IF(E33>0.5, HourAngle(E33), HourAngleR(E33))))","v":7.6975192585777377},{"$f":"IF(ISNA(T33), NA(), SolarConstant($D$13)*COS(RADIANS(T33)))","v":1321.4033330138989}]
[null,null,null,"11:00:00",{"$f":"LST(D34,$D$10,$D$8,$H$7)","v":"10:28:25.136"},{"$f":"HourAngle(E34)","v":22.895266000644767},{"$f":"90 - Zenith($D$7,$H$5,F34)","v":64.90887826260817},{"$f":"Azimuth(G34,$D$7,$H$5,F34)","v":116.99854891623052},25.09112173739183,null,25.09112173739183,{"$f":"IF(ISNA(K34), NA(), IncidenceAngle($D$7,$H$5,K34,H34,IF(E34>0.5, HourAngle(E34), HourAngleR(E34))))","v":0},{"$f":"IF(ISNA(L34), NA(), SolarConstant($D$13)*COS(RADIANS(L34)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O34), NA(), IncidenceAngle($D$7,$H$5,O34,H34,IF(E34>0.5, HourAngle(E34), HourAngleR(E34))))","v":24.369977357503796},{"$f":"IF(ISNA(P34), NA(), SolarConstant($D$13)*COS(RADIANS(P34)))","v":1214.6111571797071},null,30,{"$f":"IF(ISNA(S34), NA(), IncidenceAngle($D$7,$H$5,S34,H34,IF(E34>0.5, HourAngle(E34), HourAngleR(E34))))","v":4.9089107079491994},{"$f":"IF(ISNA(T34), NA(), SolarConstant($D$13)*COS(RADIANS(T34)))","v":1328.5277894995845}]
[null,null,null,"12:00:00",{"$f":"LST(D35,$D$10,$D$8,$H$7)","v":"11:28:25.136"},{"$f":"HourAngle(E35)","v":7.8952660006445976},{"$f":"90 - Zenith($D$7,$H$5,F35)","v":74.939634001209811},{"$f":"Azimuth(G35,$D$7,$H$5,F35)","v":149.10765260504567},15.060365998790189,null,15.060365998790189,{"$f":"IF(ISNA(K35), NA(), IncidenceAngle($D$7,$H$5,K35,H35,IF(E35>0.5, HourAngle(E35), HourAngleR(E35))))","v":0},{"$f":"IF(ISNA(L35), NA(), SolarConstant($D$13)*COS(RADIANS(L35)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O35), NA(), IncidenceAngle($D$7,$H$5,O35,H35,IF(E35>0.5, HourAngle(E35), HourAngleR(E35))))","v":14.339319268949883},{"$f":"IF(ISNA(P35), NA(), SolarConstant($D$13)*COS(RADIANS(P35)))","v":1291.8774411998356},null,30,{"$f":"IF(ISNA(S35), NA(), IncidenceAngle($D$7,$H$5,S35,H35,IF(E35>0.5, HourAngle(E35), HourAngleR(E35))))","v":14.939629135242003},{"$f":"IF(ISNA(T35), NA(), SolarConstant($D$13)*COS(RADIANS(T35)))","v":1288.3465482980771}]
[null,null,null,"13:00:00",{"$f":"LST(D36,$D$10,$D$8,$H$7)","v":"12:28:25.136"},{"$f":"HourAngle(E36)","v":-7.1047339993554033},{"$f":"90 - Zenith($D$7,$H$5,F36)","v":75.287467592669657},{"$f":"Azimuth(G36,$D$7,$H$5,F36)","v":151.7722921227917},14.712532407330343,null,14.712532407330343,{"$f":"IF(ISNA(K36), NA(), IncidenceAngle($D$7,$H$5,K36,H36,IF(E36>0.5, HourAngle(E36), HourAngleR(E36))))","v":0},{"$f":"IF(ISNA(L36), NA(), SolarConstant($D$13)*COS(RADIANS(L36)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O36), NA(), IncidenceAngle($D$7,$H$5,O36,H36,IF(E36>0.5, HourAngle(E36), HourAngleR(E36))))","v":13.991406496710908},{"$f":"IF(ISNA(P36), NA(), SolarConstant($D$13)*COS(RADIANS(P36)))","v":1293.8589014913814},null,30,{"$f":"IF(ISNA(S36), NA(), IncidenceAngle($D$7,$H$5,S36,H36,IF(E36>0.5, HourAngle(E36), HourAngleR(E36))))","v":15.287492105595494},{"$f":"IF(ISNA(T36), NA(), SolarConstant($D$13)*COS(RADIANS(T36)))","v":1286.2357463858852}]
[null,null,null,"14:00:00",{"$f":"LST(D37,$D$10,$D$8,$H$7)","v":"13:28:25.136"},{"$f":"HourAngle(E37)","v":-22.10473399935529},{"$f":"90 - Zenith($D$7,$H$5,F37)","v":65.533987139140308},{"$f":"Azimuth(G37,$D$7,$H$5,F37)","v":118.06222784199825},24.466012860859692,null,24.466012860859692,{"$f":"IF(ISNA(K37), NA(), IncidenceAngle($D$7,$H$5,K37,H37,IF(E37>0.5, HourAngle(E37), HourAngleR(E37))))","v":0},{"$f":"IF(ISNA(L37), NA(), SolarConstant($D$13)*COS(RADIANS(L37)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O37), NA(), IncidenceAngle($D$7,$H$5,O37,H37,IF(E37>0.5, HourAngle(E37), HourAngleR(E37))))","v":23.744803910161558},{"$f":"IF(ISNA(P37), NA(), SolarConstant($D$13)*COS(RADIANS(P37)))","v":1220.5422038666486},null,30,{"$f":"IF(ISNA(S37), NA(), IncidenceAngle($D$7,$H$5,S37,H37,IF(E37>0.5, HourAngle(E37), HourAngleR(E37))))","v":5.534087394517341},{"$f":"IF(ISNA(T37), NA(), SolarConstant($D$13)*COS(RADIANS(T37)))","v":1327.203704661425}]
[null,null,null,"15:00:00",{"$f":"LST(D38,$D$10,$D$8,$H$7)","v":"14:28:25.136"},{"$f":"HourAngle(E38)","v":-37.104733999355403},{"$f":"90 - Zenith($D$7,$H$5,F38)","v":52.989198236458513},{"$f":"Azimuth(G38,$D$7,$H$5,F38)","v":103.26643526999247},37.010801763541487,null,37.010801763541487,{"$f":"IF(ISNA(K38), NA(), IncidenceAngle($D$7,$H$5,K38,H38,IF(E38>0.5, HourAngle(E38), HourAngleR(E38))))","v":0},{"$f":"IF(ISNA(L38), NA(), SolarConstant($D$13)*COS(RADIANS(L38)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O38), NA(), IncidenceAngle($D$7,$H$5,O38,H38,IF(E38>0.5, HourAngle(E38), HourAngleR(E38))))","v":36.28967045424929},{"$f":"IF(ISNA(P38), NA(), SolarConstant($D$13)*COS(RADIANS(P38)))","v":1074.7821979112359},null,30,{"$f":"IF(ISNA(S38), NA(), IncidenceAngle($D$7,$H$5,S38,H38,IF(E38>0.5, HourAngle(E38), HourAngleR(E38))))","v":7.0108761295108382},{"$f":"IF(ISNA(T38), NA(), SolarConstant($D$13)*COS(RADIANS(T38)))","v":1323.4487974063829}]
[null,null,null,"16:00:00",{"$f":"LST(D39,$D$10,$D$8,$H$7)","v":"15:28:25.136"},{"$f":"HourAngle(E39)","v":-52.104733999355517},{"$f":"90 - Zenith($D$7,$H$5,F39)","v":39.774535887561882},{"$f":"Azimuth(G39,$D$7,$H$5,F39)","v":94.29468764402769},50.225464112438118,null,50.225464112438118,{"$f":"IF(ISNA(K39), NA(), IncidenceAngle($D$7,$H$5,K39,H39,IF(E39>0.5, HourAngle(E39), HourAngleR(E39))))","v":0},{"$f":"IF(ISNA(L39), NA(), SolarConstant($D$13)*COS(RADIANS(L39)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O39), NA(), IncidenceAngle($D$7,$H$5,O39,H39,IF(E39>0.5, HourAngle(E39), HourAngleR(E39))))","v":49.504298393206895},{"$f":"IF(ISNA(P39), NA(), SolarConstant($D$13)*COS(RADIANS(P39)))","v":865.91014817442863},null,30,{"$f":"IF(ISNA(S39), NA(), IncidenceAngle($D$7,$H$5,S39,H39,IF(E39>0.5, HourAngle(E39), HourAngleR(E39))))","v":20.22554172441993},{"$f":"IF(ISNA(T39), NA(), SolarConstant($D$13)*COS(RADIANS(T39)))","v":1251.1988347972872}]
[null,null,null,"17:00:00",{"$f":"LST(D40,$D$10,$D$8,$H$7)","v":"16:28:25.136"},{"$f":"HourAngle(E40)","v":-67.10473399935529},{"$f":"90 - Zenith($D$7,$H$5,F40)","v":26.408263493334033},{"$f":"Azimuth(G40,$D$7,$H$5,F40)","v":87.348786994194796},63.591736506665967,null,63.591736506665967,{"$f":"IF(ISNA(K40), NA(), IncidenceAngle($D$7,$H$5,K40,H40,IF(E40>0.5, HourAngle(E40), HourAngleR(E40))))","v":0},{"$f":"IF(ISNA(L40), NA(), SolarConstant($D$13)*COS(RADIANS(L40)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O40), NA(), IncidenceAngle($D$7,$H$5,O40,H40,IF(E40>0.5, HourAngle(E40), HourAngleR(E40))))","v":62.870576777855582},{"$f":"IF(ISNA(P40), NA(), SolarConstant($D$13)*COS(RADIANS(P40)))","v":608.04162575064299},null,30,{"$f":"IF(ISNA(S40), NA(), IncidenceAngle($D$7,$H$5,S40,H40,IF(E40>0.5, HourAngle(E40), HourAngleR(E40))))","v":33.591741170443328},{"$f":"IF(ISNA(T40), NA(), SolarConstant($D$13)*COS(RADIANS(T40)))","v":1110.7391684508211}]
[null,null,null,"18:00:00",{"$f":"LST(D41,$D$10,$D$8,$H$7)","v":"17:28:25.136"},{"$f":"HourAngle(E41)","v":-82.104733999355403},{"$f":"90 - Zenith($D$7,$H$5,F41)","v":13.108732219034337},{"$f":"Azimuth(G41,$D$7,$H$5,F41)","v":81.017269626945165},76.891267780965663,null,76.891267780965663,{"$f":"IF(ISNA(K41), NA(), IncidenceAngle($D$7,$H$5,K41,H41,IF(E41>0.5, HourAngle(E41), HourAngleR(E41))))","v":0},{"$f":"IF(ISNA(L41), NA(), SolarConstant($D$13)*COS(RADIANS(L41)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O41), NA(), IncidenceAngle($D$7,$H$5,O41,H41,IF(E41>0.5, HourAngle(E41), HourAngleR(E41))))","v":76.170112677310215},{"$f":"IF(ISNA(P41), NA(), SolarConstant($D$13)*COS(RADIANS(P41)))","v":318.74042267234279},null,30,{"$f":"IF(ISNA(S41), NA(), IncidenceAngle($D$7,$H$5,S41,H41,IF(E41>0.5, HourAngle(E41), HourAngleR(E41))))","v":46.891271456809214},{"$f":"IF(ISNA(T41), NA(), SolarConstant($D$13)*COS(RADIANS(T41)))","v":911.23838582638484}]
[null,null,null,"19:00:00",{"$f":"LST(D42,$D$10,$D$8,$H$7)","v":"18:28:25.136"},{"$f":"HourAngle(E42)","v":-97.104733999355517},{"$f":"90 - Zenith($D$7,$H$5,F42)","v":4.1726901267097105E-2},{"$f":"Azimuth(G42,$D$7,$H$5,F42)","v":74.524740360142488},89.958273098732903,null,89.958273098732903,{"$f":"IF(ISNA(K42), NA(), IncidenceAngle($D$7,$H$5,K42,H42,IF(E42>0.5, HourAngle(E42), HourAngleR(E42))))","v":0},{"$f":"IF(ISNA(L42), NA(), SolarConstant($D$13)*COS(RADIANS(L42)))","v":1333.4187695462804},null,0.72116000000000113,{"$f":"IF(ISNA(O42), NA(), IncidenceAngle($D$7,$H$5,O42,H42,IF(E42>0.5, HourAngle(E42), HourAngleR(E42))))","v":89.237141452716358},{"$f":"IF(ISNA(P42), NA(), SolarConstant($D$13)*COS(RADIANS(P42)))","v":17.753137497739246},null,30,{"$f":"IF(ISNA(S42), NA(), IncidenceAngle($D$7,$H$5,S42,H42,IF(E42>0.5, HourAngle(E42), HourAngleR(E42))))","v":59.958244587939134},{"$f":"IF(ISNA(T42), NA(), SolarConstant($D$13)*COS(RADIANS(T42)))","v":667.55077201672407}]
[null,null,null,"20:00:00",{"$f":"LST(D43,$D$10,$D$8,$H$7)","v":"19:28:25.136"},{"$f":"HourAngle(E43)","v":-112.10473399935529},{"$f":"90 - Zenith($D$7,$H$5,F43)","v":-12.594153814916098},{"$f":"Azimuth(G43,$D$7,$H$5,F43)","v":67.220410569037128},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K43), NA(), IncidenceAngle($D$7,$H$5,K43,H43,IF(E43>0.5, HourAngle(E43), HourAngleR(E43))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L43), NA(), SolarConstant($D$13)*COS(RADIANS(L43)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O43), NA(), IncidenceAngle($D$7,$H$5,O43,H43,IF(E43>0.5, HourAngle(E43), HourAngleR(E43))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P43), NA(), SolarConstant($D$13)*COS(RADIANS(P43)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S43), NA(), IncidenceAngle($D$7,$H$5,S43,H43,IF(E43>0.5, HourAngle(E43), HourAngleR(E43))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T43), NA(), SolarConstant($D$13)*COS(RADIANS(T43)))","v":{"$error":"#N/A"}}]
[null,null,null,"21:00:00",{"$f":"LST(D44,$D$10,$D$8,$H$7)","v":"20:28:25.136"},{"$f":"HourAngle(E44)","v":-127.10473399935539},{"$f":"90 - Zenith($D$7,$H$5,F44)","v":-24.494576904685587},{"$f":"Azimuth(G44,$D$7,$H$5,F44)","v":58.339404677636402},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K44), NA(), IncidenceAngle($D$7,$H$5,K44,H44,IF(E44>0.5, HourAngle(E44), HourAngleR(E44))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L44), NA(), SolarConstant($D$13)*COS(RADIANS(L44)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O44), NA(), IncidenceAngle($D$7,$H$5,O44,H44,IF(E44>0.5, HourAngle(E44), HourAngleR(E44))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P44), NA(), SolarConstant($D$13)*COS(RADIANS(P44)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S44), NA(), IncidenceAngle($D$7,$H$5,S44,H44,IF(E44>0.5, HourAngle(E44), HourAngleR(E44))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T44), NA(), SolarConstant($D$13)*COS(RADIANS(T44)))","v":{"$error":"#N/A"}}]
[null,null,null,"22:00:00",{"$f":"LST(D45,$D$10,$D$8,$H$7)","v":"21:28:25.136"},{"$f":"HourAngle(E45)","v":-142.10473399935552},{"$f":"90 - Zenith($D$7,$H$5,F45)","v":-35.139321428764788},{"$f":"Azimuth(G45,$D$7,$H$5,F45)","v":46.842434569013108},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K45), NA(), IncidenceAngle($D$7,$H$5,K45,H45,IF(E45>0.5, HourAngle(E45), HourAngleR(E45))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L45), NA(), SolarConstant($D$13)*COS(RADIANS(L45)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O45), NA(), IncidenceAngle($D$7,$H$5,O45,H45,IF(E45>0.5, HourAngle(E45), HourAngleR(E45))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P45), NA(), SolarConstant($D$13)*COS(RADIANS(P45)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S45), NA(), IncidenceAngle($D$7,$H$5,S45,H45,IF(E45>0.5, HourAngle(E45), HourAngleR(E45))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T45), NA(), SolarConstant($D$13)*COS(RADIANS(T45)))","v":{"$error":"#N/A"}}]
[null,null,null,"23:00:00",{"$f":"LST(D46,$D$10,$D$8,$H$7)","v":"22:28:25.136"},{"$f":"HourAngle(E46)","v":-157.10473399935529},{"$f":"90 - Zenith($D$7,$H$5,F46)","v":-43.626389501288571},{"$f":"Azimuth(G46,$D$7,$H$5,F46)","v":31.465800557997298},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K46), NA(), IncidenceAngle($D$7,$H$5,K46,H46,IF(E46>0.5, HourAngle(E46), HourAngleR(E46))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L46), NA(), SolarConstant($D$13)*COS(RADIANS(L46)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O46), NA(), IncidenceAngle($D$7,$H$5,O46,H46,IF(E46>0.5, HourAngle(E46), HourAngleR(E46))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P46), NA(), SolarConstant($D$13)*COS(RADIANS(P46)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S46), NA(), IncidenceAngle($D$7,$H$5,S46,H46,IF(E46>0.5, HourAngle(E46), HourAngleR(E46))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T46), NA(), SolarConstant($D$13)*COS(RADIANS(T46)))","v":{"$error":"#N/A"}}]
[null,null,null,1,{"$f":"LST(D47,$D$10,$D$8,$H$7)","v":"23:28:25.136"},{"$f":"HourAngle(E47)","v":-172.1047339993554},{"$f":"90 - Zenith($D$7,$H$5,F47)","v":-48.587874082545625},{"$f":"Azimuth(G47,$D$7,$H$5,F47)","v":11.635362674491791},{"$error":"#N/A"},null,{"$error":"#N/A"},{"$f":"IF(ISNA(K47), NA(), IncidenceAngle($D$7,$H$5,K47,H47,IF(E47>0.5, HourAngle(E47), HourAngleR(E47))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(L47), NA(), SolarConstant($D$13)*COS(RADIANS(L47)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(O47), NA(), IncidenceAngle($D$7,$H$5,O47,H47,IF(E47>0.5, HourAngle(E47), HourAngleR(E47))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(P47), NA(), SolarConstant($D$13)*COS(RADIANS(P47)))","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"IF(ISNA(S47), NA(), IncidenceAngle($D$7,$H$5,S47,H47,IF(E47>0.5, HourAngle(E47), HourAngleR(E47))))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(T47), NA(), SolarConstant($D$13)*COS(RADIANS(T47)))","v":{"$error":"#N/A"}}]

{"sheet":"Custom","index":3,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[[49,2,50,7],[55,2,78,2],[17,2,18,7],[1,2,2,7],[3,2,3,3],[3,6,3,7],[11,6,11,7],[23,2,46,2],[11,2,11,3]]}
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS"]
[]
[null,null,"Data",null,null,null,"Basic Variables"]
[null,null,"Date :",{"$f":"'Sun Path'!B5","v":"2018-08-15"},null,null,"Declination Angle (δ)",{"$f":"IF(ISBLANK('Sun Path'!B5),\"\",Declination(D13))","v":13.7835641662585}]
[null,null,"Time :",{"$f":"'Sun Path'!B6","v":"12:00:00"},null,null,"Hour Angle (ω)",{"$f":"IF(ISBLANK('Sun Path'!B9),\"\",HourAngle(H8))","v":7.9025660006446117}]
[null,null,"Latitude (φ) :",{"$f":"'Sun Path'!B7","v":26.76},null,null,"Equation of Time",{"$f":"IF(ISBLANK('Sun Path'!B5),\"\",Eot(D14))","v":-4.7302640025784877}]
[null,null,"Longitude :",{"$f":"'Sun Path'!B8","v":75.78},null,null,"Local Solar Time",{"$f":"IF(ISBLANK('Sun Path'!B9),\"\",LST(D6,D10,D8,H7))","v":"11:28:23.384"}]
[null,null,"Time Zone :",{"$f":"'Sun Path'!B9","v":5.5}]
[null,null,"Std. Time Longt :",{"$f":"15*D9","v":82.5}]
[]
[null,null,"Day Number Calculation",null,null,null,"Derived Variables"]
[null,null,"nth Day",{"$f":"IF(ISBLANK('Sun Path'!B5),\"\",'Sun Path'!B5-DATE(YEAR('Sun Path'!B5),1,0))","v":227},null,null,"Zenith Angle (θz)",{"$f":"IF(H6=\"\",\"\",Zenith(D7,H5,H6))","v":14.933163132126717}]
[null,null,"N",{"$f":"IF(ISBLANK('Sun Path'!B5),\"\",(D13-1)*(360/365.25))","v":222.75154004106776},null,null,"Altitude Angle (α)",{"$f":"IF(ISBLANK('Sun Path'!B9),\"\",(90 - H13))","v":75.066836867873278}]
[null,null,null,null,null,null,"Solar Azimuth Angle (ϒs)",{"$f":"IF(H6=\"\",\"\",Azimuth(H14,D7,H5,H6))","v":148.79008877701708}]
[]
[]
[null,null,"SUN PATH DIAGRAM CALCULATIONS"]
[]
[null,null,null,"Time","Solar Time","Hour Angle","Altitude Angle","Azimuth Angle"]
[null,null,"Custom",{"$f":"'Sun Path'!B6","v":"12:00:00"},{"$f":"LST(D21,$D$10,$D$8,$H$7)","v":"11:28:23.384"},{"$f":"HourAngle(E21)","v":7.9025660006446117},{"$f":"90 - Zenith($D$7,$H$5,F21)","v":75.066836867873278},{"$f":"IF(F21<0,360-Azimuth(G21,$D$7,$H$5,F21),Azimuth(G21,$D$7,$H$5,F21))","v":148.79008877701708}]
[null,null,"Sun Rise",{"$f":"IF(ISBLANK('Sun Path'!B9),\"\",Sunrise(D7,H5,D10,D8,H7))","v":"06:03:11.183"},{"$f":"LST(D22,$D$10,$D$8,$H$7)","v":"05:31:34.567"},{"$f":"HourAngle(E22)","v":97.105969400886536},{"$f":"90 - Zenith($D$7,$H$5,F22)","v":0},{"$f":"IF(F22<0,360-Azimuth(G22,$D$7,$H$5,F22),Azimuth(G22,$D$7,$H$5,F22))","v":74.52412927300233}]
[null,null,"Sun Set",{"$f":"IF(ISBLANK('Sun Path'!B9),\"\",Sunset(D7,H5,D10,D8,H7))","v":"19:00:02.048"},{"$f":"LST(D23,$D$10,$D$8,$H$7)","v":"18:28:25.433"},{"$f":"HourAngle(E23)","v":-97.105969400886522},{"$f":"90 - Zenith($D$7,$H$5,F23)","v":0},{"$f":"IF(F23<0,360-Azimuth(G23,$D$7,$H$5,F23),Azimuth(G23,$D$7,$H$5,F23))","v":285.47587072699764}]
[null,null,"24 Hour Time Sun Locations","01:00:00",{"$f":"LST(D24,$D$10,$D$8,$H$7)","v":"00:28:23.384"},{"$f":"HourAngle(E24)","v":172.90256600064461},{"$f":"90 - Zenith($D$7,$H$5,F24)","v":-48.874182276244511},{"$f":"IF(F24<0,360-Azimuth(G24,$D$7,$H$5,F24),Azimuth(G24,$D$7,$H$5,F24))","v":10.512397688354799}]
[null,null,null,"02:00:00",{"$f":"LST(D25,$D$10,$D$8,$H$7)","v":"01:28:23.384"},{"$f":"HourAngle(E25)","v":157.90256600064464},{"$f":"90 - Zenith($D$7,$H$5,F25)","v":-44.123966501972035},{"$f":"IF(F25<0,360-Azimuth(G25,$D$7,$H$5,F25),Azimuth(G25,$D$7,$H$5,F25))","v":30.594611721901991}]
[null,null,null,"03:00:00",{"$f":"LST(D26,$D$10,$D$8,$H$7)","v":"02:28:23.384"},{"$f":"HourAngle(E26)","v":142.90256600064461},{"$f":"90 - Zenith($D$7,$H$5,F26)","v":-35.760807630659954},{"$f":"IF(F26<0,360-Azimuth(G26,$D$7,$H$5,F26),Azimuth(G26,$D$7,$H$5,F26))","v":46.212267906655669}]
[null,null,null,"04:00:00",{"$f":"LST(D27,$D$10,$D$8,$H$7)","v":"03:28:23.384"},{"$f":"HourAngle(E27)","v":127.90256600064451},{"$f":"90 - Zenith($D$7,$H$5,F27)","v":-25.179507667050274},{"$f":"IF(F27<0,360-Azimuth(G27,$D$7,$H$5,F27),Azimuth(G27,$D$7,$H$5,F27))","v":57.8649967984855}]
[null,null,null,"05:00:00",{"$f":"LST(D28,$D$10,$D$8,$H$7)","v":"04:28:23.384"},{"$f":"HourAngle(E28)","v":112.90256600064474},{"$f":"90 - Zenith($D$7,$H$5,F28)","v":-13.309071589163366},{"$f":"IF(F28<0,360-Azimuth(G28,$D$7,$H$5,F28),Azimuth(G28,$D$7,$H$5,F28))","v":66.828591378968966}]
[null,null,null,"06:00:00",{"$f":"LST(D29,$D$10,$D$8,$H$7)","v":"05:28:23.384"},{"$f":"HourAngle(E29)","v":97.902566000644626},{"$f":"90 - Zenith($D$7,$H$5,F29)","v":-0.68489259281849968},{"$f":"IF(F29<0,360-Azimuth(G29,$D$7,$H$5,F29),Azimuth(G29,$D$7,$H$5,F29))","v":74.164306387757321}]
[null,null,null,"07:00:00",{"$f":"LST(D30,$D$10,$D$8,$H$7)","v":"06:28:23.384"},{"$f":"HourAngle(E30)","v":82.902566000644498},{"$f":"90 - Zenith($D$7,$H$5,F30)","v":12.381640548308994},{"$f":"IF(F30<0,360-Azimuth(G30,$D$7,$H$5,F30),Azimuth(G30,$D$7,$H$5,F30))","v":80.648713204072422}]
[null,null,null,"08:00:00",{"$f":"LST(D31,$D$10,$D$8,$H$7)","v":"07:28:23.384"},{"$f":"HourAngle(E31)","v":67.902566000644754},{"$f":"90 - Zenith($D$7,$H$5,F31)","v":25.689641128673571},{"$f":"IF(F31<0,360-Azimuth(G31,$D$7,$H$5,F31),Azimuth(G31,$D$7,$H$5,F31))","v":86.931570530684169}]
[null,null,null,"09:00:00",{"$f":"LST(D32,$D$10,$D$8,$H$7)","v":"08:28:23.384"},{"$f":"HourAngle(E32)","v":52.902566000644626},{"$f":"90 - Zenith($D$7,$H$5,F32)","v":39.075105243177568},{"$f":"IF(F32<0,360-Azimuth(G32,$D$7,$H$5,F32),Azimuth(G32,$D$7,$H$5,F32))","v":93.768376364435298}]
[null,null,null,"10:00:00",{"$f":"LST(D33,$D$10,$D$8,$H$7)","v":"09:28:23.384"},{"$f":"HourAngle(E33)","v":37.90256600064447},{"$f":"90 - Zenith($D$7,$H$5,F33)","v":52.329196971958098},{"$f":"IF(F33<0,360-Azimuth(G33,$D$7,$H$5,F33),Azimuth(G33,$D$7,$H$5,F33))","v":102.50344252581661}]
[null,null,null,"11:00:00",{"$f":"LST(D34,$D$10,$D$8,$H$7)","v":"10:28:23.384"},{"$f":"HourAngle(E34)","v":22.902566000644754},{"$f":"90 - Zenith($D$7,$H$5,F34)","v":64.971895375313636},{"$f":"IF(F34<0,360-Azimuth(G34,$D$7,$H$5,F34),Azimuth(G34,$D$7,$H$5,F34))","v":116.69815854766659}]
[null,null,null,"12:00:00",{"$f":"LST(D35,$D$10,$D$8,$H$7)","v":"11:28:23.384"},{"$f":"HourAngle(E35)","v":7.9025660006446117},{"$f":"90 - Zenith($D$7,$H$5,F35)","v":75.066836867873278},{"$f":"IF(F35<0,360-Azimuth(G35,$D$7,$H$5,F35),Azimuth(G35,$D$7,$H$5,F35))","v":148.79008877701708}]
[null,null,null,"13:00:00",{"$f":"LST(D36,$D$10,$D$8,$H$7)","v":"12:28:23.384"},{"$f":"HourAngle(E36)","v":-7.097433999355502},{"$f":"90 - Zenith($D$7,$H$5,F36)","v":75.424678543409939},{"$f":"IF(F36<0,360-Azimuth(G36,$D$7,$H$5,F36),Azimuth(G36,$D$7,$H$5,F36))","v":208.47946174713798}]
[null,null,null,"14:00:00",{"$f":"LST(D37,$D$10,$D$8,$H$7)","v":"13:28:23.384"},{"$f":"HourAngle(E37)","v":-22.097433999355303},{"$f":"90 - Zenith($D$7,$H$5,F37)","v":65.611100221601177},{"$f":"IF(F37<0,360-Azimuth(G37,$D$7,$H$5,F37),Azimuth(G37,$D$7,$H$5,F37))","v":242.22424570277457}]
[null,null,null,"15:00:00",{"$f":"LST(D38,$D$10,$D$8,$H$7)","v":"14:28:23.384"},{"$f":"HourAngle(E38)","v":-37.097433999355388},{"$f":"90 - Zenith($D$7,$H$5,F38)","v":53.030265239324606},{"$f":"IF(F38<0,360-Azimuth(G38,$D$7,$H$5,F38),Azimuth(G38,$D$7,$H$5,F38))","v":256.92529063721247}]
[null,null,null,"16:00:00",{"$f":"LST(D39,$D$10,$D$8,$H$7)","v":"15:28:23.384"},{"$f":"HourAngle(E39)","v":-52.097433999355502},{"$f":"90 - Zenith($D$7,$H$5,F39)","v":39.79228166089321},{"$f":"IF(F39<0,360-Azimuth(G39,$D$7,$H$5,F39),Azimuth(G39,$D$7,$H$5,F39))","v":265.8281704910745}]
[null,null,null,"17:00:00",{"$f":"LST(D40,$D$10,$D$8,$H$7)","v":"16:28:23.384"},{"$f":"HourAngle(E40)","v":-67.097433999355303},{"$f":"90 - Zenith($D$7,$H$5,F40)","v":26.407624478035338},{"$f":"IF(F40<0,360-Azimuth(G40,$D$7,$H$5,F40),Azimuth(G40,$D$7,$H$5,F40))","v":272.72366431614773}]
[null,null,null,"18:00:00",{"$f":"LST(D41,$D$10,$D$8,$H$7)","v":"17:28:23.384"},{"$f":"HourAngle(E41)","v":-82.09743399935536},{"$f":"90 - Zenith($D$7,$H$5,F41)","v":13.091328595580492},{"$f":"IF(F41<0,360-Azimuth(G41,$D$7,$H$5,F41),Azimuth(G41,$D$7,$H$5,F41))","v":279.01470013249633}]
[null,null,null,"19:00:00",{"$f":"LST(D42,$D$10,$D$8,$H$7)","v":"18:28:23.384"},{"$f":"HourAngle(E42)","v":-97.097433999355474},{"$f":"90 - Zenith($D$7,$H$5,F42)","v":7.3450065872719961E-3},{"$f":"IF(F42<0,360-Azimuth(G42,$D$7,$H$5,F42),Azimuth(G42,$D$7,$H$5,F42))","v":285.47202775618183}]
[null,null,null,"20:00:00",{"$f":"LST(D43,$D$10,$D$8,$H$7)","v":"19:28:23.384"},{"$f":"HourAngle(E43)","v":-112.09743399935525},{"$f":"90 - Zenith($D$7,$H$5,F43)","v":-12.647111343344264},{"$f":"IF(F43<0,360-Azimuth(G43,$D$7,$H$5,F43),Azimuth(G43,$D$7,$H$5,F43))","v":292.74426402630144}]
[null,null,null,"21:00:00",{"$f":"LST(D44,$D$10,$D$8,$H$7)","v":"20:28:23.384"},{"$f":"HourAngle(E44)","v":-127.09743399935536},{"$f":"90 - Zenith($D$7,$H$5,F44)","v":-24.568950809744862},{"$f":"IF(F44<0,360-Azimuth(G44,$D$7,$H$5,F44),Azimuth(G44,$D$7,$H$5,F44))","v":301.59651727896153}]
[null,null,null,"22:00:00",{"$f":"LST(D45,$D$10,$D$8,$H$7)","v":"21:28:23.384"},{"$f":"HourAngle(E45)","v":-142.09743399935547},{"$f":"90 - Zenith($D$7,$H$5,F45)","v":-35.238726828084026},{"$f":"IF(F45<0,360-Azimuth(G45,$D$7,$H$5,F45),Azimuth(G45,$D$7,$H$5,F45))","v":313.07268482138841}]
[null,null,null,"23:00:00",{"$f":"LST(D46,$D$10,$D$8,$H$7)","v":"22:28:23.384"},{"$f":"HourAngle(E46)","v":-157.09743399935525},{"$f":"90 - Zenith($D$7,$H$5,F46)","v":-43.752916359268198},{"$f":"IF(F46<0,360-Azimuth(G46,$D$7,$H$5,F46),Azimuth(G46,$D$7,$H$5,F46))","v":328.44951374598804}]
[null,null,null,1,{"$f":"LST(D47,$D$10,$D$8,$H$7)","v":"23:28:23.384"},{"$f":"HourAngle(E47)","v":-172.09743399935536},{"$f":"90 - Zenith($D$7,$H$5,F47)","v":-48.735813938081776},{"$f":"IF(F47<0,360-Azimuth(G47,$D$7,$H$5,F47),Azimuth(G47,$D$7,$H$5,F47))","v":348.31908295856232}]
[]
[]
[null,null,"Sun Path Graph Positions Calculations (Polar to Cartesian Co-ordinates)"]
[]
[null,null,null,"Time","Radius","Theta","Value X","Value Y"]
[null,null,"Custom",{"$f":"D21","v":"12:00:00"},{"$f":"90-G21","v":14.933163132126722},{"$f":"90-H21","v":-58.790088777017075},{"$f":"E53*COS(RADIANS(F53))","v":7.7379912908415482},{"$f":"IF(Calculations!$AJ$5=TRUE,E53*SIN(RADIANS(F53)), NA())","v":-12.771955680848924}]
[null,null,"Sun Rise",{"$f":"D22","v":"06:03:11.183"},90,15.47587072699767,86.736862013039584,{"$f":"IF(Calculations!$AJ$5=TRUE,E54*SIN(RADIANS(F54)), NA())","v":24.014928026769763}]
[null,null,"Sun Set",{"$f":"D23","v":"19:00:02.048"},90,-195.47587072699764,-86.736862013039598,{"$f":"IF(Calculations!$AJ$5=TRUE,E55*SIN(RADIANS(F55)), NA())","v":24.014928026769702}]
[null,null,"24 Hour Time Sun Locations","01:00:00",138.87418227624451,79.487602311645205,{"$f":"IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*COS(RADIANS(F56)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*SIN(RADIANS(F56))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"02:00:00",134.12396650197203,59.405388278098009,{"$f":"IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*COS(RADIANS(F57)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*SIN(RADIANS(F57))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"03:00:00",125.76080763065995,43.787732093344331,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D58)<HOUR($D$54), HOUR(D58)>HOUR($D$55)+1), NA(), E58*SIN(RADIANS(F58))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"04:00:00",115.17950766705027,32.1350032015145,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D59)<HOUR($D$54), HOUR(D59)>HOUR($D$55)+1), NA(), E59*SIN(RADIANS(F59))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"05:00:00",103.30907158916337,23.171408621031034,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D60)<HOUR($D$54), HOUR(D60)>HOUR($D$55)+1), NA(), E60*SIN(RADIANS(F60))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"06:00:00",90.6848925928185,15.835693612242679,87.243236245344676,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D61)<HOUR($D$54), HOUR(D61)>HOUR($D$55)+1), NA(), E61*SIN(RADIANS(F61))), NA())","v":24.746059767365097}]
[null,null,null,"07:00:00",77.618359451691006,9.3512867959275781,76.586863125034299,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D62)<HOUR($D$54), HOUR(D62)>HOUR($D$55)+1), NA(), E62*SIN(RADIANS(F62))), NA())","v":12.611983215940779}]
[null,null,null,"08:00:00",64.310358871326429,3.0684294693158307,64.218158183274753,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D63)<HOUR($D$54), HOUR(D63)>HOUR($D$55)+1), NA(), E63*SIN(RADIANS(F63))), NA())","v":3.4424435662325852}]
[null,null,null,"09:00:00",50.924894756822432,-3.7683763644352979,50.81478980236011,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D64)<HOUR($D$54), HOUR(D64)>HOUR($D$55)+1), NA(), E64*SIN(RADIANS(F64))), NA())","v":-3.3469453738296866}]
[null,null,null,"10:00:00",37.670803028041902,-12.50344252581661,36.777364627570634,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D65)<HOUR($D$54), HOUR(D65)>HOUR($D$55)+1), NA(), E65*SIN(RADIANS(F65))), NA())","v":-8.1556637883281695}]
[null,null,null,"11:00:00",25.028104624686364,-26.698158547666594,22.359753991222604,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D66)<HOUR($D$54), HOUR(D66)>HOUR($D$55)+1), NA(), E66*SIN(RADIANS(F66))), NA())","v":-11.244884283808874}]
[null,null,null,"12:00:00",14.933163132126722,-58.790088777017075,7.7379912908415482,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D67)<HOUR($D$54), HOUR(D67)>HOUR($D$55)+1), NA(), E67*SIN(RADIANS(F67))), NA())","v":-12.771955680848924}]
[null,null,null,"13:00:00",14.575321456590061,-118.47946174713798,-6.9501503389939465,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D68)<HOUR($D$54), HOUR(D68)>HOUR($D$55)+1), NA(), E68*SIN(RADIANS(F68))), NA())","v":-12.811534093476743}]
[null,null,null,"14:00:00",24.388899778398823,-152.22424570277457,-21.578768202015844,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D69)<HOUR($D$54), HOUR(D69)>HOUR($D$55)+1), NA(), E69*SIN(RADIANS(F69))), NA())","v":-11.36552661711951}]
[null,null,null,"15:00:00",36.969734760675394,-166.92529063721247,-36.011328302565254,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D70)<HOUR($D$54), HOUR(D70)>HOUR($D$55)+1), NA(), E70*SIN(RADIANS(F70))), NA())","v":-8.36334395798435}]
[null,null,null,"16:00:00",50.20771833910679,-175.8281704910745,-50.074686238627756,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D71)<HOUR($D$54), HOUR(D71)>HOUR($D$55)+1), NA(), E71*SIN(RADIANS(F71))), NA())","v":-3.652503103635155}]
[null,null,null,"17:00:00",63.592375521964662,-182.72366431614773,-63.520537367758344,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D72)<HOUR($D$54), HOUR(D72)>HOUR($D$55)+1), NA(), E72*SIN(RADIANS(F72))), NA())","v":3.021846627111628}]
[null,null,null,"18:00:00",76.908671404419508,-189.01470013249633,-75.958708751812168,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D73)<HOUR($D$54), HOUR(D73)>HOUR($D$55)+1), NA(), E73*SIN(RADIANS(F73))), NA())","v":12.050655664749039}]
[null,null,null,"19:00:00",89.992654993412728,-195.47202775618183,-86.731393729576837,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D74)<HOUR($D$54), HOUR(D74)>HOUR($D$55)+1), NA(), E74*SIN(RADIANS(F74))), NA())","v":24.00715090318992}]
[null,null,null,"20:00:00",102.64711134334426,-202.74426402630144,-94.665239252941873,{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D75)<HOUR($D$54), HOUR(D75)>HOUR($D$55)+1), NA(), E75*SIN(RADIANS(F75))), NA())","v":39.685286244604399}]
[null,null,null,"21:00:00",114.56895080974486,-211.59651727896153,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D76)<HOUR($D$54), HOUR(D76)>HOUR($D$55)+1), NA(), E76*SIN(RADIANS(F76))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"22:00:00",125.23872682808403,-223.07268482138841,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D77)<HOUR($D$54), HOUR(D77)>HOUR($D$55)+1), NA(), E77*SIN(RADIANS(F77))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"23:00:00",133.7529163592682,-238.44951374598804,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D78)<HOUR($D$54), HOUR(D78)>HOUR($D$55)+1), NA(), E78*SIN(RADIANS(F78))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,1,138.73581393808178,-258.31908295856232,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$5=TRUE,IF(OR(HOUR(D79)<HOUR($D$54), HOUR(D79)>HOUR($D$55)+1), NA(), E79*SIN(RADIANS(F79))), NA())","v":{"$error":"#N/A"}}]

{"sheet":"Equinox","index":4,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[[23,2,46,2],[49,2,50,7],[55,2,78,2],[1,2,2,7],[3,2,3,3],[3,6,3,7],[11,6,11,7],[11,2,11,3],[17,2,18,7]]}
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS"]
[]
[null,null,"Data",null,null,null,"Basic Variables"]
[null,null,"Date :",{"$f":"DATE(YEAR('Sun Path'!B5),3,20)","v":"2018-03-20"},null,null,"Declination Angle (δ)",{"$f":"IF(ISBLANK(D5),\"\",Declination(D13))","v":-0.8071867925533891}]
[null,null,"Time :",{"$f":"'Sun Path'!B6","v":"12:00:00"},null,null,"Hour Angle (ω)",{"$f":"IF(ISBLANK(D9),\"\",HourAngle(H8))","v":9.279990788157221}]
[null,null,"Latitude (φ) :",{"$f":"'Sun Path'!B7","v":26.76},null,null,"Equation of Time",{"$f":"IF(ISBLANK(D5),\"\",Eot(D14))","v":-10.239963152628881}]
[null,null,"Longitude :",{"$f":"'Sun Path'!B8","v":75.78},null,null,"Local Solar Time",{"$f":"IF(ISBLANK(D9),\"\",LST(D6,D10,D8,H7))","v":"11:22:52.802"}]
[null,null,"Time Zone :",{"$f":"'Sun Path'!B9","v":5.5}]
[null,null,"Std. Time Longt :",{"$f":"Custom!D10","v":82.5}]
[]
[null,null,"Day Number Calculation",null,null,null,"Derived Variables"]
[null,null,"nth Day",{"$f":"IF(ISBLANK(D5),\"\",D5-DATE(YEAR(D5),1,0))","v":79},null,null,"Zenith Angle (θz)",{"$f":"IF(H6=\"\",\"\",Zenith(D7,H5,H6))","v":28.9806101062476}]
[null,null,"N",{"$f":"IF(ISBLANK(D5),\"\",(D13-1)*(360/365.25))","v":76.878850102669404},null,null,"Altitude Angle (α)",{"$f":"IF(ISBLANK(D9),\"\",(90 - H13))","v":61.019389893752404}]
[null,null,null,null,null,null,"Solar Azimuth Angle (ϒs)",{"$f":"IF(H6=\"\",\"\",Azimuth(H14,D7,H5,H6))","v":160.56155816076028}]
[]
[]
[null,null,"SUN PATH DIAGRAM CALCULATIONS"]
[]
[null,null,null,"Time","Solar Time","Hour Angle","Altitude Angle","Azimuth Angle"]
[null,null,"Custom",{"$f":"D6","v":"12:00:00"},{"$f":"LST(D21,$D$10,$D$8,$H$7)","v":"11:22:52.802"},{"$f":"HourAngle(E21)","v":9.279990788157221},{"$f":"90 - Zenith($D$7,$H$5,F21)","v":61.019389893752404},{"$f":"IF(F21<0,360-Azimuth(G21,$D$7,$H$5,F21),Azimuth(G21,$D$7,$H$5,F21))","v":160.56155816076028}]
[null,null,"Sun Rise",{"$f":"IF(ISBLANK(D9),\"\",Sunrise(D7,H5,D10,D8,H7))","v":"06:38:44.893"},{"$f":"LST(D22,$D$10,$D$8,$H$7)","v":"06:01:37.695"},{"$f":"HourAngle(E22)","v":89.592937319879923},{"$f":"90 - Zenith($D$7,$H$5,F22)","v":0},{"$f":"IF(F22<0,360-Azimuth(G22,$D$7,$H$5,F22),Azimuth(G22,$D$7,$H$5,F22))","v":90.904013042535865}]
[null,null,"Sun Set",{"$f":"IF(ISBLANK(D9),\"\",Sunset(D7,H5,D10,D8,H7))","v":"18:35:29.503"},{"$f":"LST(D23,$D$10,$D$8,$H$7)","v":"17:58:22.305"},{"$f":"HourAngle(E23)","v":-89.592937319879923},{"$f":"90 - Zenith($D$7,$H$5,F23)","v":0},{"$f":"IF(F23<0,360-Azimuth(G23,$D$7,$H$5,F23),Azimuth(G23,$D$7,$H$5,F23))","v":269.09598695746411}]
[null,null,"24 Hour Time Sun Locations","01:00:00",{"$f":"LST(D24,$D$10,$D$8,$H$7)","v":"00:22:52.802"},{"$f":"HourAngle(E24)","v":174.27999078815722},{"$f":"90 - Zenith($D$7,$H$5,F24)","v":-63.47111491409018},{"$f":"IF(F24<0,360-Azimuth(G24,$D$7,$H$5,F24),Azimuth(G24,$D$7,$H$5,F24))","v":12.892489397611644}]
[null,null,null,"02:00:00",{"$f":"LST(D25,$D$10,$D$8,$H$7)","v":"01:22:52.802"},{"$f":"HourAngle(E25)","v":159.27999078815725},{"$f":"90 - Zenith($D$7,$H$5,F25)","v":-57.289119790822156},{"$f":"IF(F25<0,360-Azimuth(G25,$D$7,$H$5,F25),Azimuth(G25,$D$7,$H$5,F25))","v":40.892199536507185}]
[null,null,null,"03:00:00",{"$f":"LST(D26,$D$10,$D$8,$H$7)","v":"02:22:52.802"},{"$f":"HourAngle(E26)","v":144.27999078815722},{"$f":"90 - Zenith($D$7,$H$5,F26)","v":-46.986983156086524},{"$f":"IF(F26<0,360-Azimuth(G26,$D$7,$H$5,F26),Azimuth(G26,$D$7,$H$5,F26))","v":58.843432986651557}]
[null,null,null,"04:00:00",{"$f":"LST(D27,$D$10,$D$8,$H$7)","v":"03:22:52.802"},{"$f":"HourAngle(E27)","v":129.27999078815711},{"$f":"90 - Zenith($D$7,$H$5,F27)","v":-34.861286561899789},{"$f":"IF(F27<0,360-Azimuth(G27,$D$7,$H$5,F27),Azimuth(G27,$D$7,$H$5,F27))","v":70.607201281976685}]
[null,null,null,"05:00:00",{"$f":"LST(D28,$D$10,$D$8,$H$7)","v":"04:22:52.802"},{"$f":"HourAngle(E28)","v":114.27999078815733},{"$f":"90 - Zenith($D$7,$H$5,F28)","v":-21.92939016200755},{"$f":"IF(F28<0,360-Azimuth(G28,$D$7,$H$5,F28),Azimuth(G28,$D$7,$H$5,F28))","v":79.280330229986504}]
[null,null,null,"06:00:00",{"$f":"LST(D29,$D$10,$D$8,$H$7)","v":"05:22:52.802"},{"$f":"HourAngle(E29)","v":99.279990788157221},{"$f":"90 - Zenith($D$7,$H$5,F29)","v":-8.645302920647552},{"$f":"IF(F29<0,360-Azimuth(G29,$D$7,$H$5,F29),Azimuth(G29,$D$7,$H$5,F29))","v":86.519351505603566}]
[null,null,null,"07:00:00",{"$f":"LST(D30,$D$10,$D$8,$H$7)","v":"06:22:52.802"},{"$f":"HourAngle(E30)","v":84.279990788157093},{"$f":"90 - Zenith($D$7,$H$5,F30)","v":4.7403916447995442},{"$f":"IF(F30<0,360-Azimuth(G30,$D$7,$H$5,F30),Azimuth(G30,$D$7,$H$5,F30))","v":93.304771340545898}]
[null,null,null,"08:00:00",{"$f":"LST(D31,$D$10,$D$8,$H$7)","v":"07:22:52.802"},{"$f":"HourAngle(E31)","v":69.279990788157335},{"$f":"90 - Zenith($D$7,$H$5,F31)","v":18.03121827881759},{"$f":"IF(F31<0,360-Azimuth(G31,$D$7,$H$5,F31),Azimuth(G31,$D$7,$H$5,F31))","v":100.41287564772061}]
[null,null,null,"09:00:00",{"$f":"LST(D32,$D$10,$D$8,$H$7)","v":"08:22:52.802"},{"$f":"HourAngle(E32)","v":54.279990788157221},{"$f":"90 - Zenith($D$7,$H$5,F32)","v":30.990946669777188},{"$f":"IF(F32<0,360-Azimuth(G32,$D$7,$H$5,F32),Azimuth(G32,$D$7,$H$5,F32))","v":108.74073934549965}]
[null,null,null,"10:00:00",{"$f":"LST(D33,$D$10,$D$8,$H$7)","v":"09:22:52.802"},{"$f":"HourAngle(E33)","v":39.279990788157079},{"$f":"90 - Zenith($D$7,$H$5,F33)","v":43.215798536694926},{"$f":"IF(F33<0,360-Azimuth(G33,$D$7,$H$5,F33),Azimuth(G33,$D$7,$H$5,F33))","v":119.69894936782548}]
[null,null,null,"11:00:00",{"$f":"LST(D34,$D$10,$D$8,$H$7)","v":"10:22:52.802"},{"$f":"HourAngle(E34)","v":24.279990788157363},{"$f":"90 - Zenith($D$7,$H$5,F34)","v":53.85208035976423},{"$f":"IF(F34<0,360-Azimuth(G34,$D$7,$H$5,F34),Azimuth(G34,$D$7,$H$5,F34))","v":135.8112273744872}]
[null,null,null,"12:00:00",{"$f":"LST(D35,$D$10,$D$8,$H$7)","v":"11:22:52.802"},{"$f":"HourAngle(E35)","v":9.279990788157221},{"$f":"90 - Zenith($D$7,$H$5,F35)","v":61.019389893752404},{"$f":"IF(F35<0,360-Azimuth(G35,$D$7,$H$5,F35),Azimuth(G35,$D$7,$H$5,F35))","v":160.56155816076028}]
[null,null,null,"13:00:00",{"$f":"LST(D36,$D$10,$D$8,$H$7)","v":"12:22:52.802"},{"$f":"HourAngle(E36)","v":-5.7200092118429211},{"$f":"90 - Zenith($D$7,$H$5,F36)","v":61.887403929419136},{"$f":"IF(F36<0,360-Azimuth(G36,$D$7,$H$5,F36),Azimuth(G36,$D$7,$H$5,F36))","v":192.2099379719227}]
[null,null,null,"14:00:00",{"$f":"LST(D37,$D$10,$D$8,$H$7)","v":"13:22:52.802"},{"$f":"HourAngle(E37)","v":-20.720009211842665},{"$f":"90 - Zenith($D$7,$H$5,F37)","v":55.967697052042496},{"$f":"IF(F37<0,360-Azimuth(G37,$D$7,$H$5,F37),Azimuth(G37,$D$7,$H$5,F37))","v":219.20591021925267}]
[null,null,null,"15:00:00",{"$f":"LST(D38,$D$10,$D$8,$H$7)","v":"14:22:52.802"},{"$f":"HourAngle(E38)","v":-35.720009211842751},{"$f":"90 - Zenith($D$7,$H$5,F38)","v":45.931825295197889},{"$f":"IF(F38<0,360-Azimuth(G38,$D$7,$H$5,F38),Azimuth(G38,$D$7,$H$5,F38))","v":237.06962496050585}]
[null,null,null,"16:00:00",{"$f":"LST(D39,$D$10,$D$8,$H$7)","v":"15:22:52.802"},{"$f":"HourAngle(E39)","v":-50.720009211842921},{"$f":"90 - Zenith($D$7,$H$5,F39)","v":33.980145013254258},{"$f":"IF(F39<0,360-Azimuth(G39,$D$7,$H$5,F39),Azimuth(G39,$D$7,$H$5,F39))","v":248.96733010889631}]
[null,null,null,"17:00:00",{"$f":"LST(D40,$D$10,$D$8,$H$7)","v":"16:22:52.802"},{"$f":"HourAngle(E40)","v":-65.720009211842665},{"$f":"90 - Zenith($D$7,$H$5,F40)","v":21.147962838463741},{"$f":"IF(F40<0,360-Azimuth(G40,$D$7,$H$5,F40),Azimuth(G40,$D$7,$H$5,F40))","v":257.76160852631898}]
[null,null,null,"18:00:00",{"$f":"LST(D41,$D$10,$D$8,$H$7)","v":"17:22:52.802"},{"$f":"HourAngle(E41)","v":-80.720009211842751},{"$f":"90 - Zenith($D$7,$H$5,F41)","v":7.910790492980027},{"$f":"IF(F41<0,360-Azimuth(G41,$D$7,$H$5,F41),Azimuth(G41,$D$7,$H$5,F41))","v":265.06660417071794}]
[null,null,null,"19:00:00",{"$f":"LST(D42,$D$10,$D$8,$H$7)","v":"18:22:52.802"},{"$f":"HourAngle(E42)","v":-95.720009211842864},{"$f":"90 - Zenith($D$7,$H$5,F42)","v":-5.4701461624453174},{"$f":"IF(F42<0,360-Azimuth(G42,$D$7,$H$5,F42),Azimuth(G42,$D$7,$H$5,F42))","v":271.85900457268878}]
[null,null,null,"20:00:00",{"$f":"LST(D43,$D$10,$D$8,$H$7)","v":"19:22:52.802"},{"$f":"HourAngle(E43)","v":-110.72000921184264},{"$f":"90 - Zenith($D$7,$H$5,F43)","v":-18.797303838733896},{"$f":"IF(F43<0,360-Azimuth(G43,$D$7,$H$5,F43),Azimuth(G43,$D$7,$H$5,F43))","v":278.91514372752442}]
[null,null,null,"21:00:00",{"$f":"LST(D44,$D$10,$D$8,$H$7)","v":"20:22:52.802"},{"$f":"HourAngle(E44)","v":-125.72000921184274},{"$f":"90 - Zenith($D$7,$H$5,F44)","v":-31.842672781054858},{"$f":"IF(F44<0,360-Azimuth(G44,$D$7,$H$5,F44),Azimuth(G44,$D$7,$H$5,F44))","v":287.13369447033307}]
[null,null,null,"22:00:00",{"$f":"LST(D45,$D$10,$D$8,$H$7)","v":"21:22:52.802"},{"$f":"HourAngle(E45)","v":-140.72000921184286},{"$f":"90 - Zenith($D$7,$H$5,F45)","v":-44.221501391080977},{"$f":"IF(F45<0,360-Azimuth(G45,$D$7,$H$5,F45),Azimuth(G45,$D$7,$H$5,F45))","v":297.95154396549287}]
[null,null,null,"23:00:00",{"$f":"LST(D46,$D$10,$D$8,$H$7)","v":"22:22:52.802"},{"$f":"HourAngle(E46)","v":-155.72000921184264},{"$f":"90 - Zenith($D$7,$H$5,F46)","v":-55.10309987084969},{"$f":"IF(F46<0,360-Azimuth(G46,$D$7,$H$5,F46),Azimuth(G46,$D$7,$H$5,F46))","v":314.05477761948669}]
[null,null,null,1,{"$f":"LST(D47,$D$10,$D$8,$H$7)","v":"23:22:52.802"},{"$f":"HourAngle(E47)","v":-170.72000921184275},{"$f":"90 - Zenith($D$7,$H$5,F47)","v":-62.556996485261237},{"$f":"IF(F47<0,360-Azimuth(G47,$D$7,$H$5,F47),Azimuth(G47,$D$7,$H$5,F47))","v":339.52063840326639}]
[]
[]
[null,null,"Sun Path Graph Positions Calculations (Polar to Cartesian Co-ordinates)"]
[]
[null,null,null,"Time","Radius","Theta","Value X","Value Y"]
[null,null,"Custom",{"$f":"D21","v":"12:00:00"},{"$f":"90-G21","v":28.980610106247596},{"$f":"90-H21","v":-70.561558160760285},{"$f":"E53*COS(RADIANS(F53))","v":9.644570254067192},{"$f":"IF(Calculations!$AJ$7=TRUE,E53*SIN(RADIANS(F53)), NA())","v":-27.328703349129146}]
[null,null,"Sun Rise",{"$f":"D22","v":"06:38:44.893"},90,-0.90401304253586545,89.988797688835831,{"$f":"IF(Calculations!$AJ$7=TRUE,E54*SIN(RADIANS(F54)), NA())","v":-1.4199614493973844}]
[null,null,"Sun Set",{"$f":"D23","v":"18:35:29.503"},90,-179.09598695746411,-89.988797688835831,{"$f":"IF(Calculations!$AJ$7=TRUE,E55*SIN(RADIANS(F55)), NA())","v":-1.419961449397424}]
[null,null,"24 Hour Time Sun Locations","01:00:00",153.47111491409018,77.107510602388359,{"$f":"IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*COS(RADIANS(F56)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*SIN(RADIANS(F56))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"02:00:00",147.28911979082216,49.107800463492815,{"$f":"IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*COS(RADIANS(F57)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*SIN(RADIANS(F57))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"03:00:00",136.98698315608652,31.156567013348443,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D58)<HOUR($D$54), HOUR(D58)>HOUR($D$55)+1), NA(), E58*SIN(RADIANS(F58))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"04:00:00",124.86128656189979,19.392798718023315,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D59)<HOUR($D$54), HOUR(D59)>HOUR($D$55)+1), NA(), E59*SIN(RADIANS(F59))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"05:00:00",111.92939016200755,10.719669770013496,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D60)<HOUR($D$54), HOUR(D60)>HOUR($D$55)+1), NA(), E60*SIN(RADIANS(F60))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"06:00:00",98.645302920647552,3.4806484943964335,98.463337896620132,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D61)<HOUR($D$54), HOUR(D61)>HOUR($D$55)+1), NA(), E61*SIN(RADIANS(F61))), NA())","v":5.9888962724634087}]
[null,null,null,"07:00:00",85.259608355200456,-3.3047713405458978,85.117823286796551,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D62)<HOUR($D$54), HOUR(D62)>HOUR($D$55)+1), NA(), E62*SIN(RADIANS(F62))), NA())","v":-4.9149746489522146}]
[null,null,null,"08:00:00",71.96878172118241,-10.412875647720611,70.783519166554896,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D63)<HOUR($D$54), HOUR(D63)>HOUR($D$55)+1), NA(), E63*SIN(RADIANS(F63))), NA())","v":-13.007649934909654}]
[null,null,null,"09:00:00",59.009053330222812,-18.740739345499648,55.880515532595936,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D64)<HOUR($D$54), HOUR(D64)>HOUR($D$55)+1), NA(), E64*SIN(RADIANS(F64))), NA())","v":-18.95880689126782}]
[null,null,null,"10:00:00",46.784201463305074,-29.698949367825477,40.638656806828656,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D65)<HOUR($D$54), HOUR(D65)>HOUR($D$55)+1), NA(), E65*SIN(RADIANS(F65))), NA())","v":-23.178892973908738}]
[null,null,null,"11:00:00",36.14791964023577,-45.811227374487203,25.195989499266528,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D66)<HOUR($D$54), HOUR(D66)>HOUR($D$55)+1), NA(), E66*SIN(RADIANS(F66))), NA())","v":-25.919764803519993}]
[null,null,null,"12:00:00",28.980610106247596,-70.561558160760285,9.644570254067192,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D67)<HOUR($D$54), HOUR(D67)>HOUR($D$55)+1), NA(), E67*SIN(RADIANS(F67))), NA())","v":-27.328703349129146}]
[null,null,null,"13:00:00",28.112596070580864,-102.2099379719227,-5.9456545689118361,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D68)<HOUR($D$54), HOUR(D68)>HOUR($D$55)+1), NA(), E68*SIN(RADIANS(F68))), NA())","v":-27.476667366600637}]
[null,null,null,"14:00:00",34.032302947957504,-129.20591021925267,-21.512133049267394,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D69)<HOUR($D$54), HOUR(D69)>HOUR($D$55)+1), NA(), E69*SIN(RADIANS(F69))), NA())","v":-26.370926711288977}]
[null,null,null,"15:00:00",44.068174704802111,-147.06962496050585,-36.98781976484188,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D70)<HOUR($D$54), HOUR(D70)>HOUR($D$55)+1), NA(), E70*SIN(RADIANS(F70))), NA())","v":-23.956318808542619}]
[null,null,null,"16:00:00",56.019854986745742,-158.96733010889631,-52.287584490627943,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D71)<HOUR($D$54), HOUR(D71)>HOUR($D$55)+1), NA(), E71*SIN(RADIANS(F71))), NA())","v":-20.10553806470908}]
[null,null,null,"17:00:00",68.852037161536259,-167.76160852631898,-67.287310934945467,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D72)<HOUR($D$54), HOUR(D72)>HOUR($D$55)+1), NA(), E72*SIN(RADIANS(F72))), NA())","v":-14.595232387239969}]
[null,null,null,"18:00:00",82.089209507019973,-175.06660417071794,-81.78509691472739,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D73)<HOUR($D$54), HOUR(D73)>HOUR($D$55)+1), NA(), E73*SIN(RADIANS(F73))), NA())","v":-7.0594787439347311}]
[null,null,null,"19:00:00",95.470146162445317,-181.85900457268878,-95.419898583262267,{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D74)<HOUR($D$54), HOUR(D74)>HOUR($D$55)+1), NA(), E74*SIN(RADIANS(F74))), NA())","v":3.0970570932120016}]
[null,null,null,"20:00:00",108.7973038387339,-188.91514372752442,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D75)<HOUR($D$54), HOUR(D75)>HOUR($D$55)+1), NA(), E75*SIN(RADIANS(F75))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"21:00:00",121.84267278105486,-197.13369447033307,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D76)<HOUR($D$54), HOUR(D76)>HOUR($D$55)+1), NA(), E76*SIN(RADIANS(F76))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"22:00:00",134.22150139108098,-207.95154396549287,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D77)<HOUR($D$54), HOUR(D77)>HOUR($D$55)+1), NA(), E77*SIN(RADIANS(F77))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"23:00:00",145.10309987084969,-224.05477761948669,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D78)<HOUR($D$54), HOUR(D78)>HOUR($D$55)+1), NA(), E78*SIN(RADIANS(F78))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,1,152.55699648526124,-249.52063840326639,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$7=TRUE,IF(OR(HOUR(D79)<HOUR($D$54), HOUR(D79)>HOUR($D$55)+1), NA(), E79*SIN(RADIANS(F79))), NA())","v":{"$error":"#N/A"}}]

{"sheet":"Summer Solstice","index":5,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[[23,2,46,2],[49,2,50,7],[55,2,78,2],[1,2,2,7],[3,2,3,3],[3,6,3,7],[11,6,11,7],[11,2,11,3],[17,2,18,7]]}
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS"]
[]
[null,null,"Data",null,null,null,"Basic Variables"]
[null,null,"Date :",{"$f":"DATE(YEAR('Sun Path'!B5),6,21)","v":"2018-06-21"},null,null,"Declination Angle (δ)",{"$f":"IF(ISBLANK(D5),\"\",Declination(D13))","v":23.449782846813658}]
[null,null,"Time :",{"$f":"'Sun Path'!B6","v":"12:00:00"},null,null,"Hour Angle (ω)",{"$f":"IF(ISBLANK(D9),\"\",HourAngle(H8))","v":6.5172037841358303}]
[null,null,"Latitude (φ) :",{"$f":"'Sun Path'!B7","v":26.76},null,null,"Equation of Time",{"$f":"IF(ISBLANK(D5),\"\",Eot(D14))","v":0.81118486345672958}]
[null,null,"Longitude :",{"$f":"'Sun Path'!B8","v":75.78},null,null,"Local Solar Time",{"$f":"IF(ISBLANK(D9),\"\",LST(D6,D10,D8,H7))","v":"11:33:55.871"}]
[null,null,"Time Zone :",{"$f":"'Sun Path'!B9","v":5.5}]
[null,null,"Std. Time Longt :",{"$f":"Custom!D10","v":82.5}]
[]
[null,null,"Day Number Calculation",null,null,null,"Derived Variables"]
[null,null,"nth Day",{"$f":"IF(ISBLANK(D5),\"\",D5-DATE(YEAR(D5),1,0))","v":172},null,null,"Zenith Angle (θz)",{"$f":"IF(H6=\"\",\"\",Zenith(D7,H5,H6))","v":6.7648263591214652}]
[null,null,"N",{"$f":"IF(ISBLANK(D5),\"\",(D13-1)*(360/365.25))","v":168.54209445585215},null,null,"Altitude Angle (α)",{"$f":"IF(ISBLANK(D9),\"\",(90 - H13))","v":83.235173640878529}]
[null,null,null,null,null,null,"Solar Azimuth Angle (ϒs)",{"$f":"IF(H6=\"\",\"\",Azimuth(H14,D7,H5,H6))","v":117.87426753675106}]
[]
[]
[null,null,"SUN PATH DIAGRAM CALCULATIONS"]
[]
[null,null,null,"Time","Solar Time","Hour Angle","Altitude Angle","Azimuth Angle"]
[null,null,"Custom",{"$f":"D6","v":"12:00:00"},{"$f":"LST(D21,$D$10,$D$8,$H$7)","v":"11:33:55.871"},{"$f":"HourAngle(E21)","v":6.5172037841358303},{"$f":"90 - Zenith($D$7,$H$5,F21)","v":83.235173640878529},{"$f":"IF(F21<0,360-Azimuth(G21,$D$7,$H$5,F21),Azimuth(G21,$D$7,$H$5,F21))","v":117.87426753675106}]
[null,null,"Sun Rise",{"$f":"IF(ISBLANK(D9),\"\",Sunrise(D7,H5,D10,D8,H7))","v":"05:35:31.814"},{"$f":"LST(D22,$D$10,$D$8,$H$7)","v":"05:09:27.685"},{"$f":"HourAngle(E22)","v":102.63464671242755},{"$f":"90 - Zenith($D$7,$H$5,F22)","v":0},{"$f":"IF(F22<0,360-Azimuth(G22,$D$7,$H$5,F22),Azimuth(G22,$D$7,$H$5,F22))","v":63.533339202486871}]
[null,null,"Sun Set",{"$f":"IF(ISBLANK(D9),\"\",Sunset(D7,H5,D10,D8,H7))","v":"19:16:36.444"},{"$f":"LST(D23,$D$10,$D$8,$H$7)","v":"18:50:32.315"},{"$f":"HourAngle(E23)","v":-102.63464671242753},{"$f":"90 - Zenith($D$7,$H$5,F23)","v":0},{"$f":"IF(F23<0,360-Azimuth(G23,$D$7,$H$5,F23),Azimuth(G23,$D$7,$H$5,F23))","v":296.4666607975131}]
[null,null,"24 Hour Time Sun Locations","01:00:00",{"$f":"LST(D24,$D$10,$D$8,$H$7)","v":"00:33:55.871"},{"$f":"HourAngle(E24)","v":171.5172037841358},{"$f":"90 - Zenith($D$7,$H$5,F24)","v":-39.125203691008011},{"$f":"IF(F24<0,360-Azimuth(G24,$D$7,$H$5,F24),Azimuth(G24,$D$7,$H$5,F24))","v":10.046381956392615}]
[null,null,null,"02:00:00",{"$f":"LST(D25,$D$10,$D$8,$H$7)","v":"01:33:55.871"},{"$f":"HourAngle(E25)","v":156.51720378413583},{"$f":"90 - Zenith($D$7,$H$5,F25)","v":-34.899303092098137},{"$f":"IF(F25<0,360-Azimuth(G25,$D$7,$H$5,F25),Azimuth(G25,$D$7,$H$5,F25))","v":26.469588025478501}]
[null,null,null,"03:00:00",{"$f":"LST(D26,$D$10,$D$8,$H$7)","v":"02:33:55.871"},{"$f":"HourAngle(E26)","v":141.5172037841358},{"$f":"90 - Zenith($D$7,$H$5,F26)","v":-27.519726483625888},{"$f":"IF(F26<0,360-Azimuth(G26,$D$7,$H$5,F26),Azimuth(G26,$D$7,$H$5,F26))","v":40.069841571303719}]
[null,null,null,"04:00:00",{"$f":"LST(D27,$D$10,$D$8,$H$7)","v":"03:33:55.871"},{"$f":"HourAngle(E27)","v":126.51720378413569},{"$f":"90 - Zenith($D$7,$H$5,F27)","v":-17.955199748974948},{"$f":"IF(F27<0,360-Azimuth(G27,$D$7,$H$5,F27),Azimuth(G27,$D$7,$H$5,F27))","v":50.809413637796787}]
[null,null,null,"05:00:00",{"$f":"LST(D28,$D$10,$D$8,$H$7)","v":"04:33:55.871"},{"$f":"HourAngle(E28)","v":111.51720378413593},{"$f":"90 - Zenith($D$7,$H$5,F28)","v":-6.965613783299716},{"$f":"IF(F28<0,360-Azimuth(G28,$D$7,$H$5,F28),Azimuth(G28,$D$7,$H$5,F28))","v":59.2962520816927}]
[null,null,null,"06:00:00",{"$f":"LST(D29,$D$10,$D$8,$H$7)","v":"05:33:55.871"},{"$f":"HourAngle(E29)","v":96.517203784135816},{"$f":"90 - Zenith($D$7,$H$5,F29)","v":4.9450995002657834},{"$f":"IF(F29<0,360-Azimuth(G29,$D$7,$H$5,F29),Azimuth(G29,$D$7,$H$5,F29))","v":66.189567809367588}]
[null,null,null,"07:00:00",{"$f":"LST(D30,$D$10,$D$8,$H$7)","v":"06:33:55.871"},{"$f":"HourAngle(E30)","v":81.517203784135688},{"$f":"90 - Zenith($D$7,$H$5,F30)","v":17.45832798453614},{"$f":"IF(F30<0,360-Azimuth(G30,$D$7,$H$5,F30),Azimuth(G30,$D$7,$H$5,F30))","v":72.024594030110705}]
[null,null,null,"08:00:00",{"$f":"LST(D31,$D$10,$D$8,$H$7)","v":"07:33:55.871"},{"$f":"HourAngle(E31)","v":66.517203784135944},{"$f":"90 - Zenith($D$7,$H$5,F31)","v":30.370408755352216},{"$f":"IF(F31<0,360-Azimuth(G31,$D$7,$H$5,F31),Azimuth(G31,$D$7,$H$5,F31))","v":77.228438138476832}]
[null,null,null,"09:00:00",{"$f":"LST(D32,$D$10,$D$8,$H$7)","v":"08:33:55.871"},{"$f":"HourAngle(E32)","v":51.51720378413583},{"$f":"90 - Zenith($D$7,$H$5,F32)","v":43.54467736612763},{"$f":"IF(F32<0,360-Azimuth(G32,$D$7,$H$5,F32),Azimuth(G32,$D$7,$H$5,F32))","v":82.207163701473263}]
[null,null,null,"10:00:00",{"$f":"LST(D33,$D$10,$D$8,$H$7)","v":"09:33:55.871"},{"$f":"HourAngle(E33)","v":36.517203784135688},{"$f":"90 - Zenith($D$7,$H$5,F33)","v":56.878482103815784},{"$f":"IF(F33<0,360-Azimuth(G33,$D$7,$H$5,F33),Azimuth(G33,$D$7,$H$5,F33))","v":87.550617301231199}]
[null,null,null,"11:00:00",{"$f":"LST(D34,$D$10,$D$8,$H$7)","v":"10:33:55.871"},{"$f":"HourAngle(E34)","v":21.517203784135972},{"$f":"90 - Zenith($D$7,$H$5,F34)","v":70.261285711169563},{"$f":"IF(F34<0,360-Azimuth(G34,$D$7,$H$5,F34),Azimuth(G34,$D$7,$H$5,F34))","v":94.918112391503911}]
[null,null,null,"12:00:00",{"$f":"LST(D35,$D$10,$D$8,$H$7)","v":"11:33:55.871"},{"$f":"HourAngle(E35)","v":6.5172037841358303},{"$f":"90 - Zenith($D$7,$H$5,F35)","v":83.235173640878529},{"$f":"IF(F35<0,360-Azimuth(G35,$D$7,$H$5,F35),Azimuth(G35,$D$7,$H$5,F35))","v":117.87426753675106}]
[null,null,null,"13:00:00",{"$f":"LST(D36,$D$10,$D$8,$H$7)","v":"12:33:55.871"},{"$f":"HourAngle(E36)","v":-8.4827962158642833},{"$f":"90 - Zenith($D$7,$H$5,F36)","v":81.638450201877816},{"$f":"IF(F36<0,360-Azimuth(G36,$D$7,$H$5,F36),Azimuth(G36,$D$7,$H$5,F36))","v":248.53095435802732}]
[null,null,null,"14:00:00",{"$f":"LST(D37,$D$10,$D$8,$H$7)","v":"13:33:55.871"},{"$f":"HourAngle(E37)","v":-23.482796215864028},{"$f":"90 - Zenith($D$7,$H$5,F37)","v":68.511157682518913},{"$f":"IF(F37<0,360-Azimuth(G37,$D$7,$H$5,F37),Azimuth(G37,$D$7,$H$5,F37))","v":266.31689071308551}]
[null,null,null,"15:00:00",{"$f":"LST(D38,$D$10,$D$8,$H$7)","v":"14:33:55.871"},{"$f":"HourAngle(E38)","v":-38.482796215864198},{"$f":"90 - Zenith($D$7,$H$5,F38)","v":55.12555691035989},{"$f":"IF(F38<0,360-Azimuth(G38,$D$7,$H$5,F38),Azimuth(G38,$D$7,$H$5,F38))","v":273.20608420793195}]
[null,null,null,"16:00:00",{"$f":"LST(D39,$D$10,$D$8,$H$7)","v":"15:33:55.871"},{"$f":"HourAngle(E39)","v":-53.482796215864283},{"$f":"90 - Zenith($D$7,$H$5,F39)","v":41.807210597868128},{"$f":"IF(F39<0,360-Azimuth(G39,$D$7,$H$5,F39),Azimuth(G39,$D$7,$H$5,F39))","v":278.44931395628106}]
[null,null,null,"17:00:00",{"$f":"LST(D40,$D$10,$D$8,$H$7)","v":"16:33:55.871"},{"$f":"HourAngle(E40)","v":-68.482796215864028},{"$f":"90 - Zenith($D$7,$H$5,F40)","v":28.661021874366327},{"$f":"IF(F40<0,360-Azimuth(G40,$D$7,$H$5,F40),Azimuth(G40,$D$7,$H$5,F40))","v":283.43140368243803}]
[null,null,null,"18:00:00",{"$f":"LST(D41,$D$10,$D$8,$H$7)","v":"17:33:55.871"},{"$f":"HourAngle(E41)","v":-83.482796215864141},{"$f":"90 - Zenith($D$7,$H$5,F41)","v":15.792355860929362},{"$f":"IF(F41<0,360-Azimuth(G41,$D$7,$H$5,F41),Azimuth(G41,$D$7,$H$5,F41))","v":288.69562200360383}]
[null,null,null,"19:00:00",{"$f":"LST(D42,$D$10,$D$8,$H$7)","v":"18:33:55.871"},{"$f":"HourAngle(E42)","v":-98.482796215864255},{"$f":"90 - Zenith($D$7,$H$5,F42)","v":3.3445897010904275},{"$f":"IF(F42<0,360-Azimuth(G42,$D$7,$H$5,F42),Azimuth(G42,$D$7,$H$5,F42))","v":294.643323213526}]
[null,null,null,"20:00:00",{"$f":"LST(D43,$D$10,$D$8,$H$7)","v":"19:33:55.871"},{"$f":"HourAngle(E43)","v":-113.48279621586403},{"$f":"90 - Zenith($D$7,$H$5,F43)","v":-8.4667370043888042},{"$f":"IF(F43<0,360-Azimuth(G43,$D$7,$H$5,F43),Azimuth(G43,$D$7,$H$5,F43))","v":301.71205708803643}]
[null,null,null,"21:00:00",{"$f":"LST(D44,$D$10,$D$8,$H$7)","v":"20:33:55.871"},{"$f":"HourAngle(E44)","v":-128.48279621586414},{"$f":"90 - Zenith($D$7,$H$5,F44)","v":-19.303191557303137},{"$f":"IF(F44<0,360-Azimuth(G44,$D$7,$H$5,F44),Azimuth(G44,$D$7,$H$5,F44))","v":310.45459534561968}]
[null,null,null,"22:00:00",{"$f":"LST(D45,$D$10,$D$8,$H$7)","v":"21:33:55.871"},{"$f":"HourAngle(E45)","v":-143.48279621586425},{"$f":"90 - Zenith($D$7,$H$5,F45)","v":-28.630589901021636},{"$f":"IF(F45<0,360-Azimuth(G45,$D$7,$H$5,F45),Azimuth(G45,$D$7,$H$5,F45))","v":321.5400897653879}]
[null,null,null,"23:00:00",{"$f":"LST(D46,$D$10,$D$8,$H$7)","v":"22:33:55.871"},{"$f":"HourAngle(E46)","v":-158.48279621586403},{"$f":"90 - Zenith($D$7,$H$5,F46)","v":-35.654034688624336},{"$f":"IF(F46<0,360-Azimuth(G46,$D$7,$H$5,F46),Azimuth(G46,$D$7,$H$5,F46))","v":335.53654680358977}]
[null,null,null,1,{"$f":"LST(D47,$D$10,$D$8,$H$7)","v":"23:33:55.871"},{"$f":"HourAngle(E47)","v":-173.48279621586414},{"$f":"90 - Zenith($D$7,$H$5,F47)","v":-39.396624244927523},{"$f":"IF(F47<0,360-Azimuth(G47,$D$7,$H$5,F47),Azimuth(G47,$D$7,$H$5,F47))","v":352.25610021597237}]
[]
[]
[null,null,"Sun Path Graph Positions Calculations (Polar to Cartesian Co-ordinates)"]
[]
[null,null,null,"Time","Radius","Theta","Value X","Value Y"]
[null,null,"Custom",{"$f":"D21","v":"12:00:00"},{"$f":"90-G21","v":6.7648263591214715},{"$f":"90-H21","v":-27.874267536751063},{"$f":"E53*COS(RADIANS(F53))","v":5.9799420878750658},{"$f":"IF(Calculations!$AJ$6=TRUE,E53*SIN(RADIANS(F53)), NA())","v":-3.1627785718771171}]
[null,null,"Sun Rise",{"$f":"D22","v":"05:35:31.814"},90,26.466660797513129,80.56744588390255,{"$f":"IF(Calculations!$AJ$6=TRUE,E54*SIN(RADIANS(F54)), NA())","v":40.110929479936424}]
[null,null,"Sun Set",{"$f":"D23","v":"19:16:36.444"},90,-206.4666607975131,-80.567445883902579,{"$f":"IF(Calculations!$AJ$6=TRUE,E55*SIN(RADIANS(F55)), NA())","v":40.110929479936374}]
[null,null,"24 Hour Time Sun Locations","01:00:00",129.12520369100801,79.953618043607378,{"$f":"IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*COS(RADIANS(F56)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*SIN(RADIANS(F56))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"02:00:00",124.89930309209814,63.530411974521499,{"$f":"IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*COS(RADIANS(F57)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*SIN(RADIANS(F57))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"03:00:00",117.51972648362589,49.930158428696281,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D58)<HOUR($D$54), HOUR(D58)>HOUR($D$55)+1), NA(), E58*SIN(RADIANS(F58))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"04:00:00",107.95519974897495,39.190586362203213,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D59)<HOUR($D$54), HOUR(D59)>HOUR($D$55)+1), NA(), E59*SIN(RADIANS(F59))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"05:00:00",96.965613783299716,30.7037479183073,83.37286479691403,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D60)<HOUR($D$54), HOUR(D60)>HOUR($D$55)+1), NA(), E60*SIN(RADIANS(F60))), NA())","v":49.51056121604298}]
[null,null,null,"06:00:00",85.054900499734217,23.810432190632412,77.815552731242235,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D61)<HOUR($D$54), HOUR(D61)>HOUR($D$55)+1), NA(), E61*SIN(RADIANS(F61))), NA())","v":34.337673947880432}]
[null,null,null,"07:00:00",72.54167201546386,17.975405969889295,69.000845774957284,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D62)<HOUR($D$54), HOUR(D62)>HOUR($D$55)+1), NA(), E62*SIN(RADIANS(F62))), NA())","v":22.38699312412658}]
[null,null,null,"08:00:00",59.629591244647784,12.771561861523168,58.154307297273931,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D63)<HOUR($D$54), HOUR(D63)>HOUR($D$55)+1), NA(), E63*SIN(RADIANS(F63))), NA())","v":13.181983719380304}]
[null,null,null,"09:00:00",46.45532263387237,7.792836298526737,46.026298497260612,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D64)<HOUR($D$54), HOUR(D64)>HOUR($D$55)+1), NA(), E64*SIN(RADIANS(F64))), NA())","v":6.2989560768622948}]
[null,null,null,"10:00:00",33.121517896184216,2.449382698768801,33.091256976654336,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D65)<HOUR($D$54), HOUR(D65)>HOUR($D$55)+1), NA(), E65*SIN(RADIANS(F65))), NA())","v":1.4155067828439341}]
[null,null,null,"11:00:00",19.738714288830437,-4.9181123915039109,19.666041165696573,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D66)<HOUR($D$54), HOUR(D66)>HOUR($D$55)+1), NA(), E66*SIN(RADIANS(F66))), NA())","v":-1.6922371716773812}]
[null,null,null,"12:00:00",6.7648263591214715,-27.874267536751063,5.9799420878750658,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D67)<HOUR($D$54), HOUR(D67)>HOUR($D$55)+1), NA(), E67*SIN(RADIANS(F67))), NA())","v":-3.1627785718771171}]
[null,null,null,"13:00:00",8.3615497981221836,-158.53095435802732,-7.7813873150283284,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D68)<HOUR($D$54), HOUR(D68)>HOUR($D$55)+1), NA(), E68*SIN(RADIANS(F68))), NA())","v":-3.060314768123265}]
[null,null,null,"14:00:00",21.488842317481087,-176.31689071308551,-21.444459239795282,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D69)<HOUR($D$54), HOUR(D69)>HOUR($D$55)+1), NA(), E69*SIN(RADIANS(F69))), NA())","v":-1.3804028608796022}]
[null,null,null,"15:00:00",34.87444308964011,-183.20608420793195,-34.819858688837691,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D70)<HOUR($D$54), HOUR(D70)>HOUR($D$55)+1), NA(), E70*SIN(RADIANS(F70))), NA())","v":1.9504414120708884}]
[null,null,null,"16:00:00",48.192789402131872,-188.44931395628106,-47.669716153851276,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D71)<HOUR($D$54), HOUR(D71)>HOUR($D$55)+1), NA(), E71*SIN(RADIANS(F71))), NA())","v":7.0811801396013676}]
[null,null,null,"17:00:00",61.338978125633673,-193.43140368243803,-59.661278045789452,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D72)<HOUR($D$54), HOUR(D72)>HOUR($D$55)+1), NA(), E72*SIN(RADIANS(F72))), NA())","v":14.247881928201382}]
[null,null,null,"18:00:00",74.207644139070638,-198.69562200360383,-70.292060963128407,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D73)<HOUR($D$54), HOUR(D73)>HOUR($D$55)+1), NA(), E73*SIN(RADIANS(F73))), NA())","v":23.786563733057029}]
[null,null,null,"19:00:00",86.655410298909572,-204.643323213526,-78.762929604434362,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D74)<HOUR($D$54), HOUR(D74)>HOUR($D$55)+1), NA(), E74*SIN(RADIANS(F74))), NA())","v":36.132548404441103}]
[null,null,null,"20:00:00",98.466737004388804,-211.71205708803643,-83.765703633332251,{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D75)<HOUR($D$54), HOUR(D75)>HOUR($D$55)+1), NA(), E75*SIN(RADIANS(F75))), NA())","v":51.759107325225578}]
[null,null,null,"21:00:00",109.30319155730314,-220.45459534561968,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D76)<HOUR($D$54), HOUR(D76)>HOUR($D$55)+1), NA(), E76*SIN(RADIANS(F76))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"22:00:00",118.63058990102164,-231.5400897653879,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D77)<HOUR($D$54), HOUR(D77)>HOUR($D$55)+1), NA(), E77*SIN(RADIANS(F77))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"23:00:00",125.65403468862434,-245.53654680358977,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D78)<HOUR($D$54), HOUR(D78)>HOUR($D$55)+1), NA(), E78*SIN(RADIANS(F78))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,1,129.39662424492752,-262.25610021597237,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$6=TRUE,IF(OR(HOUR(D79)<HOUR($D$54), HOUR(D79)>HOUR($D$55)+1), NA(), E79*SIN(RADIANS(F79))), NA())","v":{"$error":"#N/A"}}]

{"sheet":"Winter Solstice","index":6,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":true,"merged":[[23,2,46,2],[49,2,50,7],[55,2,78,2],[1,2,2,7],[3,2,3,3],[3,6,3,7],[11,6,11,7],[11,2,11,3],[17,2,18,7]]}
[]
[null,null,"SUN PATH VARIABLES CALCULATIONS"]
[]
[null,null,"Data",null,null,null,"Basic Variables"]
[null,null,"Date :",{"$f":"DATE(YEAR('Sun Path'!B5),12,22)","v":"2018-12-22"},null,null,"Declination Angle (δ)",{"$f":"IF(ISBLANK(D5),\"\",Declination(D13))","v":-23.444571371428442}]
[null,null,"Time :",{"$f":"'Sun Path'!B6","v":"12:00:00"},null,null,"Hour Angle (ω)",{"$f":"IF(ISBLANK(D9),\"\",HourAngle(H8))","v":5.7270417182294864}]
[null,null,"Latitude (φ) :",{"$f":"'Sun Path'!B7","v":26.76},null,null,"Equation of Time",{"$f":"IF(ISBLANK(D5),\"\",Eot(D14))","v":3.9718331270820388}]
[null,null,"Longitude :",{"$f":"'Sun Path'!B8","v":75.78},null,null,"Local Solar Time",{"$f":"IF(ISBLANK(D9),\"\",LST(D6,D10,D8,H7))","v":"11:37:05.510"}]
[null,null,"Time Zone :",{"$f":"'Sun Path'!B9","v":5.5}]
[null,null,"Std. Time Longt :",{"$f":"Custom!D10","v":82.5}]
[]
[null,null,"Day Number Calculation",null,null,null,"Derived Variables"]
[null,null,"nth Day",{"$f":"IF(ISBLANK(D5),\"\",D5-DATE(YEAR(D5),1,0))","v":356},null,null,"Zenith Angle (θz)",{"$f":"IF(H6=\"\",\"\",Zenith(D7,H5,H6))","v":50.508815248418912}]
[null,null,"N",{"$f":"IF(ISBLANK(D5),\"\",(D13-1)*(360/365.25))","v":349.89733059548252},null,null,"Altitude Angle (α)",{"$f":"IF(ISBLANK(D9),\"\",(90 - H13))","v":39.491184751581088}]
[null,null,null,null,null,null,"Solar Azimuth Angle (ϒs)",{"$f":"IF(H6=\"\",\"\",Azimuth(H14,D7,H5,H6))","v":173.1868177752014}]
[]
[]
[null,null,"SUN PATH DIAGRAM CALCULATIONS"]
[]
[null,null,null,"Time","Solar Time","Hour Angle","Altitude Angle","Azimuth Angle"]
[null,null,"Custom",{"$f":"D6","v":"12:00:00"},{"$f":"LST(D21,$D$10,$D$8,$H$7)","v":"11:37:05.510"},{"$f":"HourAngle(E21)","v":5.7270417182294864},{"$f":"90 - Zenith($D$7,$H$5,F21)","v":39.491184751581088},{"$f":"IF(F21<0,360-Azimuth(G21,$D$7,$H$5,F21),Azimuth(G21,$D$7,$H$5,F21))","v":173.1868177752014}]
[null,null,"Sun Rise",{"$f":"IF(ISBLANK(D9),\"\",Sunrise(D7,H5,D10,D8,H7))","v":"07:13:26.037"},{"$f":"LST(D22,$D$10,$D$8,$H$7)","v":"06:50:31.547"},{"$f":"HourAngle(E22)","v":77.368553033623201},{"$f":"90 - Zenith($D$7,$H$5,F22)","v":0},{"$f":"IF(F22<0,360-Azimuth(G22,$D$7,$H$5,F22),Azimuth(G22,$D$7,$H$5,F22))","v":116.46067942326761}]
[null,null,"Sun Set",{"$f":"IF(ISBLANK(D9),\"\",Sunset(D7,H5,D10,D8,H7))","v":"17:32:22.943"},{"$f":"LST(D23,$D$10,$D$8,$H$7)","v":"17:09:28.453"},{"$f":"HourAngle(E23)","v":-77.36855303362313},{"$f":"90 - Zenith($D$7,$H$5,F23)","v":0},{"$f":"IF(F23<0,360-Azimuth(G23,$D$7,$H$5,F23),Azimuth(G23,$D$7,$H$5,F23))","v":243.53932057673239}]
[null,null,"24 Hour Time Sun Locations","01:00:00",{"$f":"LST(D24,$D$10,$D$8,$H$7)","v":"00:37:05.510"},{"$f":"HourAngle(E24)","v":170.72704171822949},{"$f":"90 - Zenith($D$7,$H$5,F24)","v":-80.975383683213806},{"$f":"IF(F24<0,360-Azimuth(G24,$D$7,$H$5,F24),Azimuth(G24,$D$7,$H$5,F24))","v":70.471288668519378}]
[null,null,null,"02:00:00",{"$f":"LST(D25,$D$10,$D$8,$H$7)","v":"01:37:05.510"},{"$f":"HourAngle(E25)","v":155.72704171822951},{"$f":"90 - Zenith($D$7,$H$5,F25)","v":-67.805672180492252},{"$f":"IF(F25<0,360-Azimuth(G25,$D$7,$H$5,F25),Azimuth(G25,$D$7,$H$5,F25))","v":86.765263262692073}]
[null,null,null,"03:00:00",{"$f":"LST(D26,$D$10,$D$8,$H$7)","v":"02:37:05.510"},{"$f":"HourAngle(E26)","v":140.72704171822949},{"$f":"90 - Zenith($D$7,$H$5,F26)","v":-54.419994578771934},{"$f":"IF(F26<0,360-Azimuth(G26,$D$7,$H$5,F26),Azimuth(G26,$D$7,$H$5,F26))","v":93.494691050021089}]
[null,null,null,"04:00:00",{"$f":"LST(D27,$D$10,$D$8,$H$7)","v":"03:37:05.510"},{"$f":"HourAngle(E27)","v":125.72704171822937},{"$f":"90 - Zenith($D$7,$H$5,F27)","v":-41.108150403086597},{"$f":"IF(F27<0,360-Azimuth(G27,$D$7,$H$5,F27),Azimuth(G27,$D$7,$H$5,F27))","v":98.705440358539946}]
[null,null,null,"05:00:00",{"$f":"LST(D28,$D$10,$D$8,$H$7)","v":"04:37:05.510"},{"$f":"HourAngle(E28)","v":110.7270417182296},{"$f":"90 - Zenith($D$7,$H$5,F28)","v":-27.973471212688139},{"$f":"IF(F28<0,360-Azimuth(G28,$D$7,$H$5,F28),Azimuth(G28,$D$7,$H$5,F28))","v":103.69243255922589}]
[null,null,null,"06:00:00",{"$f":"LST(D29,$D$10,$D$8,$H$7)","v":"05:37:05.510"},{"$f":"HourAngle(E29)","v":95.727041718229486},{"$f":"90 - Zenith($D$7,$H$5,F29)","v":-15.122589113025271},{"$f":"IF(F29<0,360-Azimuth(G29,$D$7,$H$5,F29),Azimuth(G29,$D$7,$H$5,F29))","v":108.98341803225837}]
[null,null,null,"07:00:00",{"$f":"LST(D30,$D$10,$D$8,$H$7)","v":"06:37:05.510"},{"$f":"HourAngle(E30)","v":80.727041718229358},{"$f":"90 - Zenith($D$7,$H$5,F30)","v":-2.7017349628518303},{"$f":"IF(F30<0,360-Azimuth(G30,$D$7,$H$5,F30),Azimuth(G30,$D$7,$H$5,F30))","v":114.97885492950392}]
[null,null,null,"08:00:00",{"$f":"LST(D31,$D$10,$D$8,$H$7)","v":"07:37:05.510"},{"$f":"HourAngle(E31)","v":65.7270417182296},{"$f":"90 - Zenith($D$7,$H$5,F31)","v":9.0685473162455992},{"$f":"IF(F31<0,360-Azimuth(G31,$D$7,$H$5,F31),Azimuth(G31,$D$7,$H$5,F31))","v":122.12100831264701}]
[null,null,null,"09:00:00",{"$f":"LST(D32,$D$10,$D$8,$H$7)","v":"08:37:05.510"},{"$f":"HourAngle(E32)","v":50.727041718229486},{"$f":"90 - Zenith($D$7,$H$5,F32)","v":19.841505031853856},{"$f":"IF(F32<0,360-Azimuth(G32,$D$7,$H$5,F32),Azimuth(G32,$D$7,$H$5,F32))","v":130.9699122948054}]
[null,null,null,"10:00:00",{"$f":"LST(D33,$D$10,$D$8,$H$7)","v":"09:37:05.510"},{"$f":"HourAngle(E33)","v":35.727041718229344},{"$f":"90 - Zenith($D$7,$H$5,F33)","v":29.070400398213529},{"$f":"IF(F33<0,360-Azimuth(G33,$D$7,$H$5,F33),Azimuth(G33,$D$7,$H$5,F33))","v":142.19803390412318}]
[null,null,null,"11:00:00",{"$f":"LST(D34,$D$10,$D$8,$H$7)","v":"10:37:05.510"},{"$f":"HourAngle(E34)","v":20.727041718229628},{"$f":"90 - Zenith($D$7,$H$5,F34)","v":35.946403904866777},{"$f":"IF(F34<0,360-Azimuth(G34,$D$7,$H$5,F34),Azimuth(G34,$D$7,$H$5,F34))","v":156.35444543694271}]
[null,null,null,"12:00:00",{"$f":"LST(D35,$D$10,$D$8,$H$7)","v":"11:37:05.510"},{"$f":"HourAngle(E35)","v":5.7270417182294864},{"$f":"90 - Zenith($D$7,$H$5,F35)","v":39.491184751581088},{"$f":"IF(F35<0,360-Azimuth(G35,$D$7,$H$5,F35),Azimuth(G35,$D$7,$H$5,F35))","v":173.1868177752014}]
[null,null,null,"13:00:00",{"$f":"LST(D36,$D$10,$D$8,$H$7)","v":"12:37:05.510"},{"$f":"HourAngle(E36)","v":-9.2729582817706557},{"$f":"90 - Zenith($D$7,$H$5,F36)","v":39.001678652829682},{"$f":"IF(F36<0,360-Azimuth(G36,$D$7,$H$5,F36),Azimuth(G36,$D$7,$H$5,F36))","v":190.96638611551626}]
[null,null,null,"14:00:00",{"$f":"LST(D37,$D$10,$D$8,$H$7)","v":"13:37:05.510"},{"$f":"HourAngle(E37)","v":-24.2729582817704},{"$f":"90 - Zenith($D$7,$H$5,F37)","v":34.585130618591663},{"$f":"IF(F37<0,360-Azimuth(G37,$D$7,$H$5,F37),Azimuth(G37,$D$7,$H$5,F37))","v":207.26465050878832}]
[null,null,null,"15:00:00",{"$f":"LST(D38,$D$10,$D$8,$H$7)","v":"14:37:05.510"},{"$f":"HourAngle(E38)","v":-39.272958281770514},{"$f":"90 - Zenith($D$7,$H$5,F38)","v":27.066605564808555},{"$f":"IF(F38<0,360-Azimuth(G38,$D$7,$H$5,F38),Azimuth(G38,$D$7,$H$5,F38))","v":220.70660639390348}]
[null,null,null,"16:00:00",{"$f":"LST(D39,$D$10,$D$8,$H$7)","v":"15:37:05.510"},{"$f":"HourAngle(E39)","v":-54.272958281770656},{"$f":"90 - Zenith($D$7,$H$5,F39)","v":17.409833102289568},{"$f":"IF(F39<0,360-Azimuth(G39,$D$7,$H$5,F39),Azimuth(G39,$D$7,$H$5,F39))","v":231.31070295172785}]
[null,null,null,"17:00:00",{"$f":"LST(D40,$D$10,$D$8,$H$7)","v":"16:37:05.510"},{"$f":"HourAngle(E40)","v":-69.2729582817704},{"$f":"90 - Zenith($D$7,$H$5,F40)","v":6.3605586682210031},{"$f":"IF(F40<0,360-Azimuth(G40,$D$7,$H$5,F40),Azimuth(G40,$D$7,$H$5,F40))","v":239.69826591826566}]
[null,null,null,"18:00:00",{"$f":"LST(D41,$D$10,$D$8,$H$7)","v":"17:37:05.510"},{"$f":"HourAngle(E41)","v":-84.272958281770457},{"$f":"90 - Zenith($D$7,$H$5,F41)","v":-5.5890530643889207},{"$f":"IF(F41<0,360-Azimuth(G41,$D$7,$H$5,F41),Azimuth(G41,$D$7,$H$5,F41))","v":246.5239276843397}]
[null,null,null,"19:00:00",{"$f":"LST(D42,$D$10,$D$8,$H$7)","v":"18:37:05.510"},{"$f":"HourAngle(E42)","v":-99.27295828177057},{"$f":"90 - Zenith($D$7,$H$5,F42)","v":-18.128016878548721},{"$f":"IF(F42<0,360-Azimuth(G42,$D$7,$H$5,F42),Azimuth(G42,$D$7,$H$5,F42))","v":252.31611265770752}]
[null,null,null,"20:00:00",{"$f":"LST(D43,$D$10,$D$8,$H$7)","v":"19:37:05.510"},{"$f":"HourAngle(E43)","v":-114.27295828177034},{"$f":"90 - Zenith($D$7,$H$5,F43)","v":-31.057221888088705},{"$f":"IF(F43<0,360-Azimuth(G43,$D$7,$H$5,F43),Azimuth(G43,$D$7,$H$5,F43))","v":257.49827675628484}]
[null,null,null,"21:00:00",{"$f":"LST(D44,$D$10,$D$8,$H$7)","v":"20:37:05.510"},{"$f":"HourAngle(E44)","v":-129.27295828177046},{"$f":"90 - Zenith($D$7,$H$5,F44)","v":-44.242547559242354},{"$f":"IF(F44<0,360-Azimuth(G44,$D$7,$H$5,F44),Azimuth(G44,$D$7,$H$5,F44))","v":262.47947558729169}]
[null,null,null,"22:00:00",{"$f":"LST(D45,$D$10,$D$8,$H$7)","v":"21:37:05.510"},{"$f":"HourAngle(E45)","v":-144.27295828177057},{"$f":"90 - Zenith($D$7,$H$5,F45)","v":-57.582240123658835},{"$f":"IF(F45<0,360-Azimuth(G45,$D$7,$H$5,F45),Azimuth(G45,$D$7,$H$5,F45))","v":267.8719882826037}]
[null,null,null,"23:00:00",{"$f":"LST(D46,$D$10,$D$8,$H$7)","v":"22:37:05.510"},{"$f":"HourAngle(E46)","v":-159.27295828177034},{"$f":"90 - Zenith($D$7,$H$5,F46)","v":-70.962642027668011},{"$f":"IF(F46<0,360-Azimuth(G46,$D$7,$H$5,F46),Azimuth(G46,$D$7,$H$5,F46))","v":275.47061450381744}]
[null,null,null,1,{"$f":"LST(D47,$D$10,$D$8,$H$7)","v":"23:37:05.510"},{"$f":"HourAngle(E47)","v":-174.27295828177046},{"$f":"90 - Zenith($D$7,$H$5,F47)","v":-83.846012475926415},{"$f":"IF(F47<0,360-Azimuth(G47,$D$7,$H$5,F47),Azimuth(G47,$D$7,$H$5,F47))","v":301.34882980507052}]
[]
[]
[null,null,"Sun Path Graph Positions Calculations (Polar to Cartesian Co-ordinates)"]
[]
[null,null,null,"Time","Radius","Theta","Value X","Value Y"]
[null,null,"Custom",{"$f":"D21","v":"12:00:00"},{"$f":"90-G21","v":50.508815248418912},{"$f":"90-H21","v":-83.186817775201405},{"$f":"E53*COS(RADIANS(F53))","v":5.991982981623357},{"$f":"IF(Calculations!$AJ$8=TRUE,E53*SIN(RADIANS(F53)), NA())","v":-50.152134129534815}]
[null,null,"Sun Rise",{"$f":"D22","v":"07:13:26.037"},90,-26.460679423267607,80.571632812295007,{"$f":"IF(Calculations!$AJ$8=TRUE,E54*SIN(RADIANS(F54)), NA())","v":-40.102518449103727}]
[null,null,"Sun Set",{"$f":"D23","v":"17:32:22.943"},90,-153.53932057673239,-80.571632812295007,{"$f":"IF(Calculations!$AJ$8=TRUE,E55*SIN(RADIANS(F55)), NA())","v":-40.102518449103727}]
[null,null,"24 Hour Time Sun Locations","01:00:00",170.97538368321381,19.528711331480622,{"$f":"IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*COS(RADIANS(F56)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D56)<HOUR($D$54), HOUR(D56)>HOUR($D$55)+1), NA(), E56*SIN(RADIANS(F56))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"02:00:00",157.80567218049225,3.2347367373079265,{"$f":"IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*COS(RADIANS(F57)))","v":{"$error":"#N/A"}},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D57)<HOUR($D$54), HOUR(D57)>HOUR($D$55)+1), NA(), E57*SIN(RADIANS(F57))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"03:00:00",144.41999457877193,-3.494691050021089,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D58)<HOUR($D$54), HOUR(D58)>HOUR($D$55)+1), NA(), E58*SIN(RADIANS(F58))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"04:00:00",131.1081504030866,-8.7054403585399456,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D59)<HOUR($D$54), HOUR(D59)>HOUR($D$55)+1), NA(), E59*SIN(RADIANS(F59))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"05:00:00",117.97347121268814,-13.692432559225892,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D60)<HOUR($D$54), HOUR(D60)>HOUR($D$55)+1), NA(), E60*SIN(RADIANS(F60))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"06:00:00",105.12258911302527,-18.983418032258371,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D61)<HOUR($D$54), HOUR(D61)>HOUR($D$55)+1), NA(), E61*SIN(RADIANS(F61))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"07:00:00",92.70173496285183,-24.978854929503925,84.030757026458957,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D62)<HOUR($D$54), HOUR(D62)>HOUR($D$55)+1), NA(), E62*SIN(RADIANS(F62))), NA())","v":-39.146437113523419}]
[null,null,null,"08:00:00",80.931452683754401,-32.121008312647007,68.543034012783906,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D63)<HOUR($D$54), HOUR(D63)>HOUR($D$55)+1), NA(), E63*SIN(RADIANS(F63))), NA())","v":-43.031994165099142}]
[null,null,null,"09:00:00",70.158494968146144,-40.969912294805397,52.973451706141894,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D64)<HOUR($D$54), HOUR(D64)>HOUR($D$55)+1), NA(), E64*SIN(RADIANS(F64))), NA())","v":-46.000302504792728}]
[null,null,null,"10:00:00",60.929599601786471,-52.198033904123179,37.345833398283574,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D65)<HOUR($D$54), HOUR(D65)>HOUR($D$55)+1), NA(), E65*SIN(RADIANS(F65))), NA())","v":-48.142547039200835}]
[null,null,null,"11:00:00",54.053596095133223,-66.354445436942711,21.679680375706518,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D66)<HOUR($D$54), HOUR(D66)>HOUR($D$55)+1), NA(), E66*SIN(RADIANS(F66))), NA())","v":-49.515479495032736}]
[null,null,null,"12:00:00",50.508815248418912,-83.186817775201405,5.991982981623357,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D67)<HOUR($D$54), HOUR(D67)>HOUR($D$55)+1), NA(), E67*SIN(RADIANS(F67))), NA())","v":-50.152134129534815}]
[null,null,null,"13:00:00",50.998321347170318,-100.96638611551626,-9.701567155609526,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D68)<HOUR($D$54), HOUR(D68)>HOUR($D$55)+1), NA(), E68*SIN(RADIANS(F68))), NA())","v":-50.067038807527311}]
[null,null,null,"14:00:00",55.414869381408337,-117.26465050878832,-25.385619352180196,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D69)<HOUR($D$54), HOUR(D69)>HOUR($D$55)+1), NA(), E69*SIN(RADIANS(F69))), NA())","v":-49.258279290539178}]
[null,null,null,"15:00:00",62.933394435191445,-130.70660639390348,-41.044267134478815,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D70)<HOUR($D$54), HOUR(D70)>HOUR($D$55)+1), NA(), E70*SIN(RADIANS(F70))), NA())","v":-47.707234991444722}]
[null,null,null,"16:00:00",72.590166897710432,-141.31070295172785,-56.660050803935327,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D71)<HOUR($D$54), HOUR(D71)>HOUR($D$55)+1), NA(), E71*SIN(RADIANS(F71))), NA())","v":-45.375885370237384}]
[null,null,null,"17:00:00",83.639441331778997,-149.69826591826566,-72.212644314795895,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D72)<HOUR($D$54), HOUR(D72)>HOUR($D$55)+1), NA(), E72*SIN(RADIANS(F72))), NA())","v":-42.200594158813416}]
[null,null,null,"18:00:00",95.589053064388921,-156.5239276843397,-87.676814372915473,{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D73)<HOUR($D$54), HOUR(D73)>HOUR($D$55)+1), NA(), E73*SIN(RADIANS(F73))), NA())","v":-38.079433913385373}]
[null,null,null,"19:00:00",108.12801687854872,-162.31611265770752,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D74)<HOUR($D$54), HOUR(D74)>HOUR($D$55)+1), NA(), E74*SIN(RADIANS(F74))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"20:00:00",121.0572218880887,-167.49827675628484,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D75)<HOUR($D$54), HOUR(D75)>HOUR($D$55)+1), NA(), E75*SIN(RADIANS(F75))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"21:00:00",134.24254755924235,-172.47947558729169,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D76)<HOUR($D$54), HOUR(D76)>HOUR($D$55)+1), NA(), E76*SIN(RADIANS(F76))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"22:00:00",147.58224012365883,-177.8719882826037,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D77)<HOUR($D$54), HOUR(D77)>HOUR($D$55)+1), NA(), E77*SIN(RADIANS(F77))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,"23:00:00",160.96264202766801,-185.47061450381744,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D78)<HOUR($D$54), HOUR(D78)>HOUR($D$55)+1), NA(), E78*SIN(RADIANS(F78))), NA())","v":{"$error":"#N/A"}}]
[null,null,null,1,173.84601247592641,-211.34882980507052,{"$error":"#N/A"},{"$f":"IF(Calculations!$AJ$8=TRUE,IF(OR(HOUR(D79)<HOUR($D$54), HOUR(D79)>HOUR($D$55)+1), NA(), E79*SIN(RADIANS(F79))), NA())","v":{"$error":"#N/A"}}]

{"sheet":"Calculations","index":7,"n_rows":90,"n_cols":46,"rows_kept":90,"cut":false,"hidden":true,"merged":[[27,34,27,36],[27,38,27,40],[23,38,23,40],[23,34,23,36],[31,34,31,36],[31,38,31,40],[87,34,87,36],[36,34,36,36],[40,34,40,36],[43,34,43,36],[35,38,35,40],[72,34,72,36],[80,34,80,36],[84,35,84,36],[47,34,47,36],[55,34,55,36],[61,34,61,36],[59,35,59,36],[67,34,67,36],[2,1,3,11],[2,13,3,18],[2,20,3,25],[2,27,3,32],[12,27,13,32],[21,45,22,45],[19,27,20,32],[9,34,10,36],[2,34,3,36],[15,34,16,36],[21,34,22,40],[21,44,22,44],[21,42,22,43]]}
[]
[]
[null,"Altitude Lines Calculations",null,null,null,null,null,null,null,null,null,null,null,"Azimuth Label Calculations",null,null,null,null,null,null,"Altitude Label Calculations",null,null,null,null,null,null,"Azimuth N,E,W,S Labels",null,null,null,null,null,null,"Graph Checkbox Calculations"]
[]
[null,null,90,{"$f":"C5-10","v":80},70,60,50,40,30,20,10,0,null,null,"R","Theta","X","Y","Label",null,null,"R","Theta","X","Y","Label",null,null,"R","Theta","X","Y","Label",null,"Custom",true]
[null,0,1,1,1,1,1,1,1,1,1,1,null,0,90,{"$f":"90-Calculations!B6","v":90},{"$f":"O6*COS(RADIANS(P6))","v":5.51316804708879E-15},{"$f":"O6*SIN(RADIANS(P6))","v":90},0,null,0,{"$f":"U6","v":0},90,{"$f":"V6*COS(RADIANS(W6))","v":0},{"$f":"V6*SIN(RADIANS(W6))","v":0},{"$f":"90-U6","v":90},null,0,90,{"$f":"90-AB6","v":90},{"$f":"AC6*COS(RADIANS(AD6))","v":5.51316804708879E-15},{"$f":"AC6*SIN(RADIANS(AD6))","v":90},"N",null,"Summer Solstice",true]
[null,30,1,1,1,1,1,1,1,1,1,1,null,30,90,{"$f":"90-Calculations!B7","v":60},45.000000000000007,77.94228634059948,{"$f":"Calculations!B7","v":30},null,{"$f":"U6+10","v":10},10,90,6.1257422745431001E-16,10,80,null,90,90,{"$f":"90-AB7","v":0},{"$f":"AC7*COS(RADIANS(AD7))","v":90},{"$f":"AC7*SIN(RADIANS(AD7))","v":0},"E",null,"Equinox",true]
[null,{"$f":"B7+30","v":60},1,1,1,1,1,1,1,1,1,1,null,{"$f":"N7+30","v":60},90,{"$f":"90-Calculations!B8","v":30},77.94228634059948,44.999999999999993,{"$f":"Calculations!B8","v":60},null,20,20,90,1.22514845490862E-15,20,70,null,180,90,{"$f":"90-AB8","v":-90},{"$f":"AC8*COS(RADIANS(AD8))","v":5.51316804708879E-15},{"$f":"AC8*SIN(RADIANS(AD8))","v":-90},"S",null,"Winter Solstice",true]
[null,90,1,1,1,1,1,1,1,1,1,1,null,90,90,{"$f":"90-Calculations!B9","v":0},90,0,90,null,30,30,90,1.83772268236293E-15,30,60,null,270,90,{"$f":"90-AB9","v":-180},{"$f":"AC9*COS(RADIANS(AD9))","v":-90},{"$f":"AC9*SIN(RADIANS(AD9))","v":-1.102633609417758E-14},"W"]
[null,120,1,1,1,1,1,1,1,1,1,1,null,120,90,{"$f":"90-Calculations!B10","v":-30},77.94228634059948,-44.999999999999993,{"$f":"Calculations!B10","v":120},null,40,40,90,2.45029690981724E-15,40,50,null,null,null,null,null,null,null,null,"Graph Custom Time (in Minutes)"]
[null,150,1,1,1,1,1,1,1,1,1,1,null,150,90,{"$f":"90-Calculations!B11","v":-60},45.000000000000007,-77.94228634059948,{"$f":"Calculations!B11","v":150},null,50,50,90,3.06287113727155E-15,50,40]
[null,180,1,1,1,1,1,1,1,1,1,1,null,180,90,{"$f":"90-Calculations!B12","v":-90},5.51316804708879E-15,-90,180,null,60,60,90,3.67544536472586E-15,60,30,null,null,null,null,null,null,null,null,"Time",554]
[null,210,1,1,1,1,1,1,1,1,1,1,null,210,90,{"$f":"90-Calculations!B13","v":-120},-44.999999999999979,-77.94228634059948,{"$f":"Calculations!B13","v":210},null,70,70,90,4.28801959218017E-15,70,20,null,"Custom Azimuth Line Calculations",null,null,null,null,null,null,"Sunrise",{"$f":"Custom!D22*1440","v":363.18638639903236}]
[null,240,1,1,1,1,1,1,1,1,1,1,null,240,90,{"$f":"90-Calculations!B14","v":-150},-77.94228634059948,-44.999999999999993,{"$f":"Calculations!B14","v":240},null,80,80,90,4.90059381963448E-15,80,10,null,null,null,null,null,null,null,null,"Sunset",{"$f":"Custom!D23*1440","v":1140.0341416061244}]
[null,270,1,1,1,1,1,1,1,1,1,1,null,270,90,{"$f":"90-Calculations!B15","v":-180},-90,-1.102633609417758E-14,270,null,90,90,90,5.51316804708879E-15,90,0,null,null,"R","Theta","X","Y","Label"]
[null,300,1,1,1,1,1,1,1,1,1,1,null,300,90,{"$f":"90-Calculations!B16","v":-210},-77.94228634059948,45.000000000000007,{"$f":"Calculations!B16","v":300},null,null,null,null,null,null,null,null,"Origin",0,0,{"$f":"IF(Calculations!$AJ$5=TRUE,AC16*COS(RADIANS(AD16)), NA())","v":0},{"$f":"IF(Calculations!$AJ$5=TRUE,AC16*SIN(RADIANS(AD16)),NA())","v":0},"Start",null,"Graph Custom Date (in Numbers)"]
[null,330,1,1,1,1,1,1,1,1,1,1,null,330,90,{"$f":"90-Calculations!B17","v":-240},-45.000000000000043,77.942286340599452,{"$f":"Calculations!B17","v":330},null,null,null,null,null,null,null,null,"Edge",90,{"$f":"Custom!F53","v":-58.790088777017075},{"$f":"IF(Calculations!$AJ$5=TRUE,AC17*COS(RADIANS(AD17)), NA())","v":46.635746895276704},{"$f":"IF(Calculations!$AJ$5=TRUE,AC17*SIN(RADIANS(AD17)),NA())","v":-76.974717352645655},"End"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom",36,{"$f":"DATE('Sun Path'!L4,1,Calculations!AJ18)","v":43136}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start",1,{"$f":"DATE('Sun Path'!L4,1,Calculations!AJ19)","v":43101}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Altitude Dot Calculations",null,null,null,null,null,null,"End",365,{"$f":"DATE('Sun Path'!L4,1,Calculations!AJ20)","v":43465}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","Y",null,null,"Solar Irradiance Animation Calculations",null,null,null,null,null,null,null,"Irradiance Graph",null,3,{"$f":"IF(Calculations!AS22=1, 'Solar Irradiance'!K8, IF(Calculations!AS22=2, 'Solar Irradiance'!L8, 'Solar Irradiance'!M8))","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Altitude",{"$f":"Custom!E53","v":14.933163132126722},90,{"$f":"IF(Calculations!$AJ$5=TRUE,AC23*COS(RADIANS(AD23)),NA())","v":9.1476708691117115E-16},{"$f":"IF(Calculations!$AJ$5=TRUE,AC23*SIN(RADIANS(AD23)),NA())","v":14.933163132126722},"Between"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",null,null,null,"Solar Cell",null,null,null,"Ideal Case","Season-wise","Custom"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle","X","Y",null,"Point A",{"$f":"10*COS(RADIANS(180-AT22))","v":-8.6602540378443873},{"$f":"10*SIN(RADIANS(180-AT22))","v":4.9999999999999991},null,1,2,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"90-'Solar Irradiance'!K8","v":39.071419590901925},{"$f":"100*COS(RADIANS(AI26))","v":77.636090562334431},{"$f":"100*SIN(RADIANS(AI26))","v":63.02886197764488},null,"Point B",{"$f":"-10*COS(RADIANS(180-AT22))","v":8.6602540378443873},{"$f":"-10*SIN(RADIANS(180-AT22))","v":-4.9999999999999991}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semi Circle",null,null,null,"Line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarter","Visible",25,null,"Sun",{"$f":"96*COS(RADIANS(AI26))","v":74.530646939841048},{"$f":"96*SIN(RADIANS(AI26))","v":60.507707498539084}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rest","Invisible",75,null,"Centre",0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal to panel",null,null,null,"Animation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle","X","Y",null,"Sunrise",{"$f":"'Solar Irradiance'!D22","v":"06:02:58.074"},{"$f":"AN33*24*60","v":362.96789718439283}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"90-AT22","v":60},{"$f":"99*COS(RADIANS(AI34))","v":49.500000000000014},{"$f":"99*SIN(RADIANS(AI34))","v":85.736514974659414},null,"Sunset",{"$f":"'Solar Irradiance'!D23","v":"19:00:11.654"},{"$f":"AN34*24*60","v":1140.1942308207642}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-5*COS(RADIANS(AI34))","v":-2.5000000000000004},{"$f":"-5*SIN(RADIANS(AI34))","v":-4.3301270189221928}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra Sun Rays"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compass Sun - Center Line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Solar Irradiance'!H6<0,90-(360-'Solar Irradiance'!H15),90-('Solar Irradiance'!H15))","v":-3.8954828756254472},{"$f":"90*COS(RADIANS(AI38))","v":89.792067417448564},{"$f":"90*SIN(RADIANS(AI38))","v":-6.1142970896393241},null,"Sun",{"$f":"98*COS(RADIANS(AI26))","v":76.083368751087733},{"$f":"98*SIN(RADIANS(AI26))","v":61.768284738091978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"Sky",{"$f":"80*COS(RADIANS(AI26+10))","v":52.409421501205074},{"$f":"80*SIN(RADIANS(AI26+10))","v":60.442142069164149}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compass Sun Marker",null,null,null,"Sun",{"$f":"AN38","v":76.083368751087733},{"$f":"AO38","v":61.768284738091978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI38","v":-3.8954828756254472},{"$f":"87.5*COS(RADIANS(AI42))","v":87.297843322519427},{"$f":"87.5*SIN(RADIANS(AI42))","v":-5.9444555038160098},null,"Sky",{"$f":"80*COS(RADIANS(AI26+5))","v":57.477867614853508},{"$f":"80*SIN(RADIANS(AI26+5))","v":55.644359412696758}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Another Panel for Compass",null,null,null,"Sun",{"$f":"AN38","v":76.083368751087733},{"$f":"AO38","v":61.768284738091978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI42+90","v":86.104517124374553},{"$f":"10*COS(RADIANS(AI45))","v":0.67936634329325785},{"$f":"10*SIN(RADIANS(AI45))","v":9.9768963797165071},null,"Sky",{"$f":"80*COS(RADIANS(AI26-5))","v":66.267191263175548},{"$f":"80*SIN(RADIANS(AI26-5))","v":44.818069593521216}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-10*COS(RADIANS(AI45))","v":-0.67936634329325785},{"$f":"-10*SIN(RADIANS(AI45))","v":-9.9768963797165071}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sun",{"$f":"AN38","v":76.083368751087733},{"$f":"AO38","v":61.768284738091978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle Arc Points",null,null,null,"Sky",{"$f":"80*COS(RADIANS(AI26-10))","v":69.921176737746691},{"$f":"80*SIN(RADIANS(AI26-10))","v":38.871957033429524}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Angle","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"90-AT22","v":60},{"$f":"AH50*COS(RADIANS(AI50))","v":10.000000000000002},{"$f":"AH50*SIN(RADIANS(AI50))","v":17.320508075688771}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI50>AI52, ((AI50-AI52)/2) + AI52, ((AI52-AI50)/2) + AI50)","v":54.767854897725485},{"$f":"AH50*COS(RADIANS(AI51))","v":11.53781349323161},{"$f":"AH50*SIN(RADIANS(AI51))","v":16.336427387755336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI50>AI54, ((AI50-AI54)/2) + AI54, ((AI54-AI50)/2) + AI50)","v":49.535709795450963},{"$f":"AH50*COS(RADIANS(AI52))","v":12.979479930791038},{"$f":"AH50*SIN(RADIANS(AI52))","v":15.216211773177735}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI52>AI54, ((AI52-AI54)/2) + AI54, ((AI54-AI52)/2) + AI52)","v":44.30356469317644},{"$f":"AH50*COS(RADIANS(AI53))","v":14.312985599394212},{"$f":"AH50*SIN(RADIANS(AI53))","v":13.969196227111061}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"90-'Solar Irradiance'!K8","v":39.071419590901925},{"$f":"AH50*COS(RADIANS(AI54))","v":15.527218112466885},{"$f":"AH50*SIN(RADIANS(AI54))","v":12.605772395528977}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle Point"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Mid Point","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"AI52","v":49.535709795450963},{"$f":"AH58*COS(RADIANS(AI58))","v":19.469219896186559},{"$f":"AH58*SIN(RADIANS(AI58))","v":22.824317659766603}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle Value",{"$f":"TEXT(IF(AI50>AI54, AI50-AI54, AI54-AI50), \"0.00\") & \"°\"","v":"20.93°"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surface"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Angle","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,0,{"$f":"AH64*COS(RADIANS(AI64))","v":110},{"$f":"AH64*SIN(RADIANS(AI64))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-60,null,{"$f":"AH65*COS(RADIANS(AI64))","v":-60},{"$f":"AH65*SIN(RADIANS(AI64))","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Solar Cell Line Extended"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"Point A",{"$f":"AH69*COS(RADIANS(180-AT22))","v":-69.282032302755098},{"$f":"AH69*SIN(RADIANS(180-AT22))","v":39.999999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-60,"Point B",{"$f":"AH70*COS(RADIANS(180-AT22))","v":51.96152422706632},{"$f":"AH70*SIN(RADIANS(180-AT22))","v":-29.999999999999996}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Panel Angle Arc Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Angle","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"180-AT22","v":150},{"$f":"AH75*COS(RADIANS(AI75))","v":-17.320508075688775},{"$f":"AH75*SIN(RADIANS(AI75))","v":9.9999999999999982}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI75>AI77, ((AI75-AI77)/2) + AI77, ((AI77-AI75)/2) + AI75)","v":157.5},{"$f":"AH75*COS(RADIANS(AI76))","v":-18.477590650225736},{"$f":"AH75*SIN(RADIANS(AI76))","v":7.6536686473017976}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI75>AI79, ((AI75-AI79)/2) + AI79, ((AI79-AI75)/2) + AI75)","v":165},{"$f":"AH75*COS(RADIANS(AI77))","v":-19.318516525781362},{"$f":"AH75*SIN(RADIANS(AI77))","v":5.1763809020504201}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AI77>AI79, ((AI77-AI79)/2) + AI79, ((AI79-AI77)/2) + AI77)","v":172.5},{"$f":"AH75*COS(RADIANS(AI78))","v":-19.828897227476208},{"$f":"AH75*SIN(RADIANS(AI78))","v":2.6105238444010315}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,{"$f":"AH75*COS(RADIANS(AI79))","v":-20},{"$f":"AH75*SIN(RADIANS(AI79))","v":2.45029690981724E-15}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solar Panel Angle Point"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Mid Point","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,{"$f":"AI77","v":165},{"$f":"AH83*COS(RADIANS(AI77))","v":-28.977774788672047},{"$f":"AH83*SIN(RADIANS(AI77))","v":7.7645713530756302}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle Value",{"$f":"TEXT(AT22, \"0.00\") & \"°\"","v":"30.00°"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compass Angle Point"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length","Angle","X","Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,90,{"$f":"AH90*COS(RADIANS(AI90))","v":1.22514845490862E-15},{"$f":"AH90*SIN(RADIANS(AI90))","v":20}]