{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Solar Gain Control","Tables"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Solar Gain Control","index":0,"n_rows":45,"n_cols":35,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,0,0,13],[1,0,1,13],[0,15,4,34],[14,5,14,12],[16,1,16,2],[15,1,15,2],[15,3,15,4],[8,0,8,4],[8,5,8,12],[4,0,4,13],[6,0,6,13],[3,0,3,3],[3,4,3,13],[15,5,15,12],[16,3,16,4],[16,5,16,12],[12,32,12,33],[5,0,5,13],[10,1,10,2],[10,3,10,4],[10,5,10,12],[9,1,9,2],[9,3,9,4],[9,5,9,12],[13,32,13,33],[11,1,11,2],[11,3,11,4],[11,5,11,12],[12,1,12,2],[19,1,19,2],[19,3,19,4],[19,5,19,12],[12,3,12,4],[12,5,12,12],[13,1,13,2],[13,3,13,4],[18,1,18,2],[13,5,13,12],[14,1,14,2],[17,1,17,2],[17,3,17,4],[17,5,17,12],[14,3,14,4],[17,24,17,25],[18,24,18,25],[19,24,19,25],[18,26,18,27],[16,26,16,27],[22,0,22,13],[20,3,20,4],[20,5,20,12],[18,21,18,22],[17,15,17,16],[18,15,18,16],[18,3,18,4],[18,5,18,12],[17,21,17,22],[19,15,19,16],[20,15,20,16],[21,15,21,16],[19,18,19,19],[20,18,20,19],[21,18,21,19],[17,18,17,19],[18,18,18,19],[20,1,20,2],[25,0,26,0],[25,1,26,4],[25,5,26,5],[25,6,26,9],[25,10,26,10],[25,13,26,13],[28,26,28,27],[28,29,28,30],[23,0,24,0],[23,10,24,10],[23,11,24,12],[23,13,24,13],[23,1,24,9],[29,0,30,0],[29,10,30,10],[29,11,30,12],[29,13,30,13],[28,6,28,9],[27,0,28,0],[27,1,28,4],[27,5,28,5],[27,6,27,9],[27,10,28,10],[27,11,28,12],[27,13,28,13],[29,1,30,9],[33,13,34,13],[31,0,32,0],[31,1,32,4],[31,5,32,5],[31,6,32,9],[31,10,32,10],[31,11,32,12],[31,13,32,13],[34,15,34,16],[33,5,34,5],[33,6,33,9],[33,10,34,10],[33,11,34,12],[39,11,40,12],[39,13,40,13],[39,0,40,0],[39,1,40,4],[39,5,40,5],[39,10,40,10],[37,0,38,0],[37,1,38,4],[37,5,38,5],[37,6,38,9],[37,10,38,10],[37,11,38,12],[37,13,38,13],[35,0,36,0],[35,1,36,4],[35,5,36,5],[35,10,36,10],[8,15,9,16],[7,15,7,34],[43,13,44,13],[42,0,42,7],[25,11,26,12],[35,6,36,9],[39,6,39,9],[40,6,40,9],[43,6,43,9],[44,6,44,9],[43,0,44,0],[43,1,44,4],[43,5,44,5],[43,10,44,10],[43,11,44,12],[35,11,36,12],[35,13,36,13],[34,6,34,9],[33,0,34,0],[33,1,34,4],[9,32,9,33],[9,26,9,27],[8,26,8,27],[9,24,9,25],[8,17,8,21],[8,22,8,23],[8,28,8,34],[9,18,9,19],[9,21,9,22],[8,24,8,25],[9,29,9,30],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,21,16,22],[16,15,16,16],[13,21,13,22],[14,21,14,22],[15,21,15,22],[16,18,16,19],[17,26,17,27],[10,24,10,25],[11,24,11,25],[12,24,12,25],[13,24,13,25],[14,24,14,25],[15,24,15,25],[16,24,16,25],[10,29,10,30],[11,29,11,30],[12,29,12,30],[13,29,13,30],[14,29,14,30],[15,29,15,30],[10,26,10,27],[11,26,11,27],[12,26,12,27],[13,26,13,27],[14,26,14,27],[15,26,15,27],[18,32,18,33],[19,32,19,33],[20,32,20,33],[21,32,21,33],[10,18,10,19],[11,18,11,19],[12,18,12,19],[13,18,13,19],[14,18,14,19],[15,18,15,19],[10,32,10,33],[11,32,11,33],[14,32,14,33],[15,32,15,33],[16,32,16,33],[17,32,17,33],[16,29,16,30],[17,29,17,30],[18,29,18,30],[19,29,19,30],[20,29,20,30],[10,21,10,22],[11,21,11,22],[12,21,12,22],[22,29,22,30],[22,32,22,33],[23,22,23,27],[23,29,23,30],[23,32,23,33],[22,22,22,27],[19,21,19,22],[20,21,20,22],[21,21,21,22],[21,29,21,30],[20,24,20,25],[21,24,21,25],[19,26,19,27],[20,26,20,27],[21,26,21,27],[28,32,28,33],[29,15,29,16],[29,18,29,19],[29,21,29,22],[29,24,29,25],[29,26,29,27],[29,29,29,30],[29,32,29,33],[26,15,26,34],[27,15,28,16],[27,17,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,34],[28,18,28,19],[28,21,28,22],[28,24,28,25],[30,32,30,33],[31,15,31,16],[31,18,31,19],[31,21,31,22],[31,24,31,25],[31,26,31,27],[31,29,31,30],[31,32,31,33],[30,15,30,16],[30,18,30,19],[30,21,30,22],[30,24,30,25],[30,26,30,27],[30,29,30,30],[32,32,32,33],[33,15,33,16],[33,18,33,19],[33,21,33,22],[33,24,33,25],[33,26,33,27],[33,29,33,30],[33,32,33,33],[32,15,32,16],[32,18,32,19],[32,21,32,22],[32,24,32,25],[32,26,32,27],[32,29,32,30],[34,26,34,27],[34,29,34,30],[34,32,34,33],[35,15,35,16],[35,18,35,19],[35,21,35,22],[35,24,35,25],[35,26,35,27],[35,29,35,30],[35,32,35,33],[34,18,34,19],[34,21,34,22],[34,24,34,25],[38,15,38,16],[38,18,38,19],[38,21,38,22],[38,24,38,25],[38,26,38,27],[38,29,38,30],[36,32,36,33],[37,15,37,16],[37,18,37,19],[37,21,37,22],[37,24,37,25],[37,26,37,27],[37,29,37,30],[37,32,37,33],[36,15,36,16],[36,18,36,19],[36,21,36,22],[36,24,36,25],[36,26,36,27],[36,29,36,30],[38,32,38,33],[42,22,42,27],[42,29,42,30],[42,32,42,33],[40,15,40,16],[40,18,40,19],[40,21,40,22],[40,24,40,25],[40,26,40,27],[40,29,40,30],[39,15,39,16],[39,18,39,19],[39,21,39,22],[39,24,39,25],[39,26,39,27],[39,29,39,30],[39,32,39,33],[40,32,40,33],[41,23,41,27],[41,29,41,30],[41,32,41,33]]}
["Window Solar Gain Control for Clear, Unshaded Windows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In the following tables, Table CL and Table HL, fill in all the cells that are shaded in a light yellow and do not fill in the cells shaded in gray. Cells have been shaded in gray based on the data given for A1-A5 on the previous page. The months used in Table CL and Table HL will vary with location and building. Table CL should be filled with data from months which are predominantly cooling months and Table HL should be filled with data from months which are predominantly heating months. Transition months in the spring and fall should be ignored."]
["(Electric Cooling and Electric or Gas Heating)"]
[]
["Description of UCRM:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table CL - Cooling Load"]
["Data needed for calculations",null,null,null,null,"Description",null,null,null,null,null,null,null,"Resource",null,"Month",null,"Daily Solar Heat Gain:",null,null,null,null,"Table 7",null,"% Sun",null,"Days",null,"Monthly Solar Heat Gain (Btu/ft2-mo)"]
["A1)",null,null,"ft2",null,"Glazing Area for North Orientation",null,null,null,null,null,null,null,null,null,null,null,"N","NE, NW",null,"E,W","SE, SW",null,"S","Table 8",null,"Month",null,"N","NE, NW",null,"E,W","SE, SW",null,"S"]
["A2)",null,null,"ft2",null,"Glazing Area for Northeast & Northwest Orientations",null,null,null,null,null,null,null,null,null,"Jan",null,null,null,null,null,null,null,null,null,null,31,null,{"$f":"R11*($Y11/100)*$AA11","v":0},{"$f":"S11*($Y11/100)*$AA11","v":0},null,{"$f":"U11*($Y11/100)*$AA11","v":0},{"$f":"V11*($Y11/100)*$AA11","v":0},null,{"$f":"X11*($Y11/100)*$AA11","v":0}]
["A3)",null,null,"ft2",null,"Glazing Area for East & West Orientations",null,null,null,null,null,null,null,null,null,"Feb",null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"R12*($Y12/100)*$AA12","v":0},{"$f":"S12*($Y12/100)*$AA12","v":0},null,{"$f":"U12*($Y12/100)*$AA12","v":0},{"$f":"V12*($Y12/100)*$AA12","v":0},null,{"$f":"X12*($Y12/100)*$AA12","v":0}]
["A4)",null,null,"ft2",null,"Glazing Area for Southeast & Southwest Orientations",null,null,null,null,null,null,null,null,null,"Mar",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["A5)",null,null,"ft2",null,"Glazing Area for South Orientation",null,null,null,null,null,null,null,null,null,"Apr",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
["A6)",{"$f":"SUM(B10:C14)","v":0},null,"ft2",null,"Total Glazing Area",null,null,null,null,null,null,null,null,null,"May",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["B)",null,null,null,null,"Shading Coefficient of New Shading Device",null,null,null,null,null,null,null,"Table 9",null,"Jun",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
["C)",null,null,"Btuh/Watt",null,"Performance of Cooling System",null,null,null,null,null,null,null,"Table 1",null,"Jul",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["D)",null,null,"$/kWh",null,"Electrical Energy Rate - Summer",null,null,null,null,null,null,null,null,null,"Aug",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["E)",null,null,"%",null,"Efficiency of Heating System",null,null,null,null,null,null,null,"Table 3",null,"Sep",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
["F)",null,null,"$/Mcf (or kWh)",null,"Natural Gas Rate (or $/kWh in winter if electrically heated)",null,null,null,null,null,null,null,null,null,"Oct",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["G)",null,null,"$/ft2",null,"Installed Cost of Window Treatment per Square Foot",null,null,null,null,null,null,null,null,null,"Nov",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dec",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals (Btu/ft2-yr):",null,null,null,null,null,{"$f":"SUM(AC11:AC22)","v":0},{"$f":"SUM(AD11:AE22)","v":0},null,{"$f":"SUM(AF11:AF22)","v":0},{"$f":"SUM(AG11:AH22)","v":0},null,0]
["H)","Total Cooling Season Solar Heat Gain (Sum of All Orientations)",null,null,null,null,null,null,null,null,"=",{"$f":"SUM(AC24:AI24)","v":0},null,"Btu/yr",null,null,null,null,null,null,null,null,"Total Solar Heat Gain (Btu/yr):",null,null,null,null,null,{"$f":"AC23*B10","v":0},{"$f":"AD23*B11","v":0},null,{"$f":"AF23*B12","v":0},{"$f":"AG23*B13","v":0},null,{"$f":"AI23*B14","v":0}]
[]
["I)","Reduction in Cooling Solar Gain",null,null,null,"=","H * (1 - B)",null,null,null,"=",{"$f":"L24*(1-B16)","v":0},null,"Btu/yr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table HL - Heating Load"]
["J)","Reduction in Cooling Energy",null,null,null,"=","I / C",null,null,null,"=",{"$f":"(L26/B17)/1000","v":{"$error":"#DIV/0!"}},null,"kWh/yr",null,"Month",null,"Daily Solar Heat Gain:",null,null,null,null,"Table 7",null,"% Sun",null,"Days",null,"Monthly Solar Heat Gain (Btu/ft2-mo)"]
[null,null,null,null,null,null,"1,000 W/kW",null,null,null,null,null,null,null,null,null,null,"N","NE, NW",null,"E,W","SE, SW",null,"S","Table 8",null,"Month",null,"N","NE, NW",null,"E,W","SE, SW",null,"S"]
["K)","Total Heating Season Solar Heat Gain (Sum of All Orientations)",null,null,null,null,null,null,null,null,"=",{"$f":"SUM(AC43:AI43)","v":0},null,"Btu/yr",null,"Jan",null,null,null,null,null,null,null,null,null,null,31,null,{"$f":"R30*($Y30/100)*$AA30","v":0},{"$f":"S30*($Y30/100)*$AA30","v":0},null,{"$f":"U30*($Y30/100)*$AA30","v":0},{"$f":"V30*($Y30/100)*$AA30","v":0},null,{"$f":"X30*($Y30/100)*$AA30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feb",null,null,null,null,null,null,null,null,null,null,28,null,{"$f":"R31*($Y31/100)*$AA31","v":0},{"$f":"S31*($Y31/100)*$AA31","v":0},null,{"$f":"U31*($Y31/100)*$AA31","v":0},{"$f":"V31*($Y31/100)*$AA31","v":0},null,{"$f":"X31*($Y31/100)*$AA31","v":0}]
["L)","Reduction in Heating Solar Gain",null,null,null,"=","K * (1 - B)",null,null,null,"=",{"$f":"L30*(1-B16)","v":0},null,"Btu/yr",null,"Mar",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apr",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
["ME)","Increase in Electrical Heating Energy1",null,null,null,"=","L",null,null,null,"=",{"$f":"IF(B20<1,L32/((B19/100)*1030000),\"\")","v":{"$error":"#DIV/0!"}},null,"Mcf/yr",null,"May",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,"E * 1,030,000 Btu/Mcf",null,null,null,null,null,null,null,null,"Jun",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
["N)","Annual Cost Savings",null,null,null,"=","J * D - M * F",null,null,null,"=",{"$f":"IF(B20<1,L28*B18-L34*B20,L28*B18-L44*B20)","v":{"$error":"#DIV/0!"}},null,"$/yr",null,"Jul",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aug",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["O)","Implementation Cost",null,null,null,"=","G * A6",null,null,null,"=",{"$f":"B21*B15","v":0},null,"$",null,"Sep",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oct",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
["P)","Simple Payback",null,null,null,"=","O",null,null,null,"=",{"$f":"L38/L36","v":{"$error":"#DIV/0!"}},null,"yrs",null,"Nov",null,null,null,null,null,null,null,null,null,null,30,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,"N",null,null,null,null,null,null,null,null,"Dec",null,null,null,null,null,null,null,null,null,null,31,null,0,0,null,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Totals (Btu/ft2-yr):",null,null,null,null,{"$f":"SUM(AC30:AC41)","v":0},{"$f":"SUM(AD30:AE41)","v":0},null,{"$f":"SUM(AF30:AF41)","v":0},{"$f":"SUM(AG30:AH41)","v":0},null,{"$f":"SUM(AI30:AI41)","v":0}]
["1Use MG for Gas Heating and ME for Electrical Heating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Solar Heat Gain (Btu/yr):",null,null,null,null,null,{"$f":"AC42*B10","v":0},{"$f":"AD42*B11","v":0},null,{"$f":"AF42*B12","v":0},{"$f":"AG42*B13","v":0},null,{"$f":"AI42*B14","v":0}]
["MG)","Increase in Gas Heating Energy",null,null,null,"=","L",null,null,null,"=",{"$f":"IF(B20<1,\"\",L32/(3413*(B19/100)))","v":""},null,"kWh/yr"]
[null,null,null,null,null,null,"3,413 Btuh/kW * E"]

{"sheet":"Tables","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}