{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Window Film","Ref Tables","Irradiance","Help","Change Log"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":10,"comments":1,"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":"Window Film","index":0,"n_rows":52,"n_cols":49,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,1,7,2],[14,1,14,2],[15,1,15,2],[14,3,14,8],[13,3,13,5],[12,7,12,8],[12,1,12,6],[13,1,13,2],[13,6,13,8],[8,1,8,2],[11,3,11,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[8,3,8,4],[10,3,10,4],[1,46,1,47],[5,17,5,18],[7,16,7,18],[5,24,6,24],[2,42,2,44],[1,42,1,44],[2,24,4,24],[4,16,4,18],[6,17,6,18],[2,46,2,47],[2,25,9,26],[2,27,4,29],[7,28,7,29],[5,27,6,29],[7,27,9,27],[11,36,11,39],[12,38,12,39],[17,35,17,37],[16,35,16,37],[12,36,12,37],[43,31,43,32],[14,10,14,11],[18,35,18,37],[15,35,15,38],[17,31,17,32],[16,31,16,32],[20,15,21,18],[19,12,19,13],[19,10,19,11],[19,15,19,16],[17,10,17,11],[17,12,17,13],[17,1,17,8],[18,17,18,18],[16,15,16,17],[16,3,16,4],[15,3,15,8],[15,12,15,13],[15,10,15,11],[18,15,18,16],[15,17,15,18],[18,1,19,8],[18,10,18,11],[17,15,17,18],[18,12,18,13],[16,1,16,2],[19,17,19,18],[14,14,18,14],[10,13,10,14],[10,16,10,17],[1,3,2,16],[8,10,9,10],[7,11,7,12],[9,3,9,5],[9,13,9,18],[7,3,7,8],[11,10,12,10],[3,17,3,18],[8,14,8,15],[8,12,8,13],[9,7,9,8],[8,17,8,18],[10,5,10,7],[11,5,11,8],[10,10,10,12],[7,13,7,14],[8,11,9,11],[3,4,3,15],[6,14,6,15],[6,3,6,8],[5,3,5,8],[4,1,4,6],[13,17,13,18],[13,10,13,16],[15,15,15,16],[14,12,14,13],[16,10,16,11],[16,12,16,13],[14,17,14,18],[5,1,5,2],[6,1,6,2],[6,11,6,13],[5,11,5,14],[4,7,4,8]]}
[{"$f":"IF(G9=\"\",\"\",IF(G9=\"ID\",2,IF(OR(G9=\"WA\",G9=\"CA\"),1,3)))","v":""}]
[null,null,null,"Window Film Calculator ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glazing","Glass Tint",null,null,"Low E","Film"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"071116.1",null,null,null,1,"ID","RMP","Rate Lookups",null,"Simplified Rate Table For FinAnswer Express",null,null,"Ashrea 1997 Fundamentals","N","NE","E","SE","S","SW","W","NW","ADLH",null,{"$f":"IF($R$6=\"\",\"\",$R$6)","v":""},{"$f":"IF(OR($AP$3=\"\",$R$7=\"\"),\"\",VLOOKUP($R$7,$AR$4:$AS$10,2,0))","v":""},null,null,{"$f":"IF(OR($Q$8=\"\",$AQ$3=\"\"),\"\",$Q$8)","v":""},{"$f":"IF(#REF!=\"\",\"\",VLOOKUP(#REF!,$AU$4:$AV$12,2,0))","v":{"$error":"#REF!"}}]
[null,"Date",null,null,{"$f":"IF(AND(G9=\"\",C4=\"\"),\"Please enter the date the window film was purchased.\",IF(InstallState=\"\",\"Please enter the state where the window film was installed.\",IF(C4<VLOOKUP(InstallState,TariffDates,3,FALSE),\"This tool calculates incentives for window film purchased on or after \"&VLOOKUP(InstallState,TariffDates,2,FALSE)&\". Please contact us for assistance with installations prior to \"&VLOOKUP(InstallState,TariffDates,2,FALSE)&\".\",\"Calculations are in accordance with Tariff 140\"&\" effective \"&VLOOKUP(G9,TariffDates,2,FALSE))))","v":"Please enter the date the window film was purchased."},null,null,null,null,null,null,null,null,null,null,null,"Project #",null,null,null,null,null,2,"UT",null,null,null,null,null,null,"Summer Irradiance (btu/hr/ft^2)",{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AF$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AG$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AH$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AI$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AJ$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AK$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AL$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AM$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$4,MATCH($L$6,Irradiance!$C$4:$C$14,0)-1,MATCH('Window Film'!AN$3,Irradiance!$D$2:$AB$2,0)-1)","v":{"$error":"#N/A"}},1,"Single 1/8\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO4),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO4),'Ref Tables'!$G$3:$H$75,2,0))","v":"CLR"},{"$f":"IF(AQ4=\"\",\"\",VLOOKUP(AQ4,'Ref Tables'!$C$1:$D$7,2,0))","v":"Clear"},{"$f":"AQ4","v":"CLR"},{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO4),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO4),'Ref Tables'!$I$3:$J$75,2,0))","v":"Uncoated"},"Stainless Steel 8%",{"$f":"'Ref Tables'!#REF!","v":{"$error":"#REF!"}},"AC"]
[null,"Project/Customer Information",null,null,null,null,null,{"$f":"IF(OR(G9=\"\",I11=\"\"),FALSE,\"\")","v":false},null,null,"Project Information",null,null,null,null,null,{"$f":"IF(AF7=0,\"Invalid Window Type\",\"\")","v":"Invalid Window Type"},null,null,null,null,null,3,"WY",null,null,null,null,null,null,"Winter Irradiance (btu/hr/ft^2)",{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AF$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AG$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AH$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AI$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AJ$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AK$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AL$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AM$3,Irradiance!$D$2:$AA$2,0)-1)","v":{"$error":"#N/A"}},{"$f":"OFFSET(Irradiance!$D$15,MATCH($L$6,Irradiance!$C$15:$C$25,0)-1,MATCH('Window Film'!AN$3,Irradiance!$D$2:$AB$2,0)-1)","v":{"$error":"#N/A"}},2,"Single 1/4\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO5),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO5),'Ref Tables'!$G$3:$H$75,2,0))","v":"BRZ"},{"$f":"IF(AQ5=\"\",\"\",VLOOKUP(AQ5,'Ref Tables'!$C$1:$D$7,2,0))","v":"Bronze"},{"$f":"AQ5","v":"BRZ"},{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO5),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO5),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.2) on surface 2"},"Stainless Steel 14%",{"$f":"'Ref Tables'!#REF!","v":{"$error":"#REF!"}},"Evaporative Cooler or IDEC"]
[null,"Project Name",null,null,null,null,null,null,null,null,"City",null,null,null,null,null,"Glazing",null,null,null,null,null,4,"CA","PP",null,null,"Updated October 14, 2014 Ave Secondary rates except where noted",null,null,null,null,null,null,null,null,null,null,null,null,3,"Double 1/8\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO6),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO6),'Ref Tables'!$G$3:$H$75,2,0))","v":"GRN"},{"$f":"IF(AQ6=\"\",\"\",VLOOKUP(AQ6,'Ref Tables'!$C$1:$D$7,2,0))","v":"Green"},"GRN",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO6),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO6),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.2) on surface 3"},"Stainless Steel 20%",{"$f":"'Ref Tables'!#REF!","v":{"$error":"#REF!"}},"Chilled Water (Water Cooled)"]
[null,"Business Name",null,null,null,null,null,null,null,null,"Cooling",null,null,null,null,null,"Glass Tint",null,null,null,null,null,5,"WA",null,null,null,null,null,null,"SHGC Existing Windows",{"$f":"IF(ISERROR(MAX('Ref Tables'!$E$3:$E$75)),0,MAX('Ref Tables'!$E$3:$E$75))","v":0},null,null,null,null,null,null,null,null,4,"Double 1/4\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO7),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO7),'Ref Tables'!$G$3:$H$75,2,0))","v":"GRY"},{"$f":"IF(AQ7=\"\",\"\",VLOOKUP(AQ7,'Ref Tables'!$C$1:$D$7,2,0))","v":"Grey"},"GRY",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO7),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO7),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.1) on surface 2"},"Titanium 20%",{"$f":"'Ref Tables'!#REF!","v":{"$error":"#REF!"}},"Chilled Water (Air Cooled)"]
[null,"Address",null,null,null,null,null,null,null,null,"Heating",null,null,null,null,"Coating",null,null,null,null,null,null,6,"AK","All Filled out",null,null,"State","Cost",null,"SHGC New Windows",{"$f":"($S$11/$P$11)*AF7","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,5,"Triple 1/8\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO8),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO8),'Ref Tables'!$G$3:$H$75,2,0))","v":"BLUGRN"},{"$f":"IF(AQ8=\"\",\"\",VLOOKUP(AQ8,'Ref Tables'!$C$1:$D$7,2,0))","v":"Blue Green"},"BLUGRN",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO8),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO8),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.1) on surface 3"},"Titanium 30%",{"$f":"'Ref Tables'!#REF!","v":{"$error":"#REF!"}},"Electric "]
[null,"City",null,null,null,"State",null,"Zip",null,null,"Project Cost",null,"Film Manufacturer",null,null,null,"Film Model",null,null,null,null,null,7,"AL",{"$f":"IF(AND(H5,R14,Q5=\"\",ISNUMBER(SEARCH(\"effective as of\",$F$12))),TRUE,FALSE)","v":false},null,null,null,{"$f":"VLOOKUP($G$9&\" \"&$I$11,$AB$11:$AD$40,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($G$9&\" \"&$I$11,$AB$11:$AD$40,3,0)","v":{"$error":"#N/A"}},"Existing Window Summer Solar Heat Gain",{"$f":"SUMPRODUCT($AF$4:$AM$4,$L$13:$S$13)*$AF$7","v":{"$error":"#N/A"}},"Btu/hr",null,null,null,null,null,null,null,6,"Triple 1/4\" Glass",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO9),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO9),'Ref Tables'!$G$3:$H$75,2,0))","v":"HI-P GRN"},{"$f":"IF(AQ9=\"\",\"\",VLOOKUP(AQ9,'Ref Tables'!$C$1:$D$7,2,0))","v":"HI-Pass Green"},"HI-P GRN",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO9),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO9),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.05) on surface 2"},null,null,"Heat Pump"]
[null,"Contact Person",null,null,null,null,null,null,null,null,null,null,null,"Please visit WWW.NFRC.ORG to find Your Films SHGC Values",null,null,null,null,null,null,null,null,8,"AR",{"$f":"TODAY()","v":"2025-03-31"},null,null,null,"kWh","Demand","Existing Window Winter Solar Heat Gain",{"$f":"SUMPRODUCT($AF$5:$AM$5,$L$13:$S$13)*$AF$7","v":{"$error":"#N/A"}},"Btu/hr",null,null,null,null,null,null,null,7,null,{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO10),'Ref Tables'!$G$3:$H$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$G$3:$G$75,'Window Film'!$AO10),'Ref Tables'!$G$3:$H$75,2,0))","v":"BLU"},{"$f":"IF(AQ10=\"\",\"\",VLOOKUP(AQ10,'Ref Tables'!$C$1:$D$7,2,0))","v":"Blue"},"BLU",{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO10),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO10),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.2) on surface 5"},null,null,"Gas"]
[null,"Account Number",null,null,null,"Rate Schedule",null,null,null,null,null,null,null,"SHGC Without  Film",null,null,"SHGC With Film",null,null,null,null,null,9,"AZ",null,{"$f":"IF(ISERROR(MID(VLOOKUP(LARGE($AA$11:$AA$41,W3),$AA$11:$AB$40,2,),4,3)),\"\",MID(VLOOKUP(LARGE($AA$11:$AA$41,W3),$AA$11:$AB$40,2,),4,5))","v":""},{"$f":"IF(LEFT(AB11,2)=$G$9,W3,\"\")","v":""},"WY 212",6.6309999999999994E-2,null,"New Window Summer Solar Heat Gain",{"$f":"SUMPRODUCT($AF$4:$AM$4,$L$13:$S$13)*$AF$8","v":{"$error":"#N/A"}},"Btu/hr",null,null,null,null,null,null,null,8,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO11),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO11),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.1) on surface 2 and 5"},null,null,{"$f":"Irradiance!C4","v":"St. George, UT (Latitude 37°)"}]
[null,"Meter Number",null,null,null,{"$f":"IF(OR($G$9=\"\",$I$11=\"\"),\"\",IF(ISERROR(MATCH($I$11,$Z$11:$Z$19,0)),CONCATENATE($I$11,\" is not a valid rate for \",$G$9),CONCATENATE(\"Rate \",I11,\" effective as of \",VLOOKUP(G9,TariffDates,3,FALSE))))","v":""},null,null,null,null,"Window Size (FT2)","N","NE","E","SE","S","SW","W","NW",null,null,null,10,"CO",null,"",{"$f":"IF(LEFT(AB12,2)=$G$9,W4,\"\")","v":""},"WY 210",3.2439999999999997E-2,15.964,"New Window Winter Solar Heat Gain",{"$f":"SUMPRODUCT($AF$5:$AM$5,$L$13:$S$13)*$AF$8","v":{"$error":"#N/A"}},"Btu/hr",null,null,null,null,null,null,null,9,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO12),'Ref Tables'!$I$3:$J$75,2,0)),\"\",VLOOKUP(SMALL('Ref Tables'!$I$3:$I$75,'Window Film'!AO12),'Ref Tables'!$I$3:$J$75,2,0))","v":"Low-E(.05) on surface 2 and 4"},null,null,{"$f":"Irradiance!C5","v":"Price,  UT (Latitude 39°)"}]
[null,"Incentive Payee Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"CT",null,"","","WY 58",6.3240000000000005E-2,null,"Cooling Energy Savings",{"$f":"AF9-AF11","v":{"$error":"#N/A"}},"Btu/hr",{"$f":"AF13/3412/AI17","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C6","v":"Salt Lake City,  UT (Latitude 40°)"}]
[null,"Attention",null,null,null,null,null,null,null,null,"Energy and Cost Savings",null,null,null,null,null,null,{"$f":"IF(OR(L6=\"\",L7=\"\",L8=\"\",L9=\"\",O9=\"\",R6=\"\",R7=\"\",Q8=\"\",R9=\"\",P11=\"\",S11=\"\"),FALSE,IF(AND(L13=\"\",M13=\"\",N13=\"\",O13=\"\",P13=\"\",Q13=\"\",R13=\"\",S13=\"\"),FALSE,\"\"))","v":false},null,null,null,null,12,"DE",null,"","","WY 54",6.9940000000000002E-2,null,"Heating Energy Savings",{"$f":"AF12-AF10","v":{"$error":"#N/A"}},"Btu/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C7","v":"Rock Springs, WY (Latitude 41.5°)"}]
[null,"Business Name",null,null,null,null,null,null,null,null,"Avg. Monthly Savings",null,"Annual Savings",null,null,null,"Incentive",{"$f":"IFERROR(IF(C4<VLOOKUP(InstallState,TariffDates,3,FALSE),\"Incorrect Tool Used\",IF(Y9,$K$20*0.15,\"\")),\"\")","v":""},null,null,null,null,13,"FL",null,"","","WY 48T",3.1199999999999999E-2,17.579999999999998,"Cooling Day Light Hours Summer (6 months)",{"$f":"AN4","v":{"$error":"#N/A"}},"hrs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C8","v":"Yreka, CA (42°)"}]
[null,"Address",null,null,null,null,null,null,null,null,{"$f":"IF(Y9,$M$16/12,\"\")","v":""},null,{"$f":"IF(Y9,$K$20*AC9+AD9*M20*12,\"\")","v":""},null,null,"Net Project Cost",null,{"$f":"IF(Y9,$L$9-$R$15,\"\")","v":""},null,null,null,null,14,"GA",null,"","","WY 46",3.286E-2,20.440999999999999,"Heating Day Light Hours Winter (6 months)",{"$f":"AN5","v":{"$error":"#N/A"}},"hrs",null,"COP","Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C9","v":"Crescent City, CA (42°)"}]
[null,"City",null,null,null,"State",null,"Zip",null,null,"Cooling  Savings (kWh)",null,{"$f":"IF(L8=\"Gas\", \"Heating Penalty (Therms)\", \"Heating Penalty (kWh)\")","v":"Heating Penalty (kWh)"},null,null,"% Of Cost Paid By Incentive",null,null,{"$f":"IF(Y9,$R$15/$L$9,\"\")","v":""},null,null,null,15,"HI",null,"","","WY 40",5.2060000000000002E-2,7.8250000000000002,"Summer Energy savings",{"$f":"AF15*AF13","v":{"$error":"#N/A"}},null,"Btu",{"$f":"VLOOKUP(L7,'Ref Tables'!$A$2:$B$10,2,0)","v":{"$error":"#N/A"}},{"$f":"AF17/AI17","v":{"$error":"#N/A"}},null,null,"BTU",null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C10","v":"Pocatello,  ID (Latitude 42.5°)"}]
[null,"Note",null,null,null,null,null,null,null,null,{"$f":"IF(Y9,ROUND($AJ$17/3413,0),\"\")","v":""},null,{"$f":"IF(Y9,IF(L8=\"Gas\",ROUND($AJ$18/100000,0),ROUND($AJ$18/3413,0)),\"\")","v":""},null,null,{"$f":"IF(L8<>\"Gas\",\"Simple Payback (yrs)\",\"Simple Payback (yrs)*\")","v":"Simple Payback (yrs)"},null,null,null,null,null,null,16,"IA",null,"","","WY 33",3.1620000000000002E-2,null,"Winter Energy savings",{"$f":"AF16*AF14","v":{"$error":"#N/A"}},null,"Btu",{"$f":"VLOOKUP(L8,'Ref Tables'!$A$2:$B$10,2,0)","v":{"$error":"#N/A"}},{"$f":"AF18/AI18","v":{"$error":"#N/A"}},null,null,"BTU",null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C11","v":"Casper, WY (43°)"}]
[null,"All blue fields must be completed to calculate energy savings and incentives.  Incentive and energy savings are estimates only.  The actual incentive paid will be determined based on the results of a post-installation inspection and review of project invoices.",null,null,null,null,null,null,null,null,"Annual Energy (kWh)",null,"Avg. Demand (kW)",null,null,"Pre-incentive",null,"Post-incentive",null,null,null,null,17,"IL",null,"","","WY 28",3.6760000000000001E-2,16.923999999999999,null,null,null,null,null,{"$f":"SUM(AJ17:AL18)","v":{"$error":"#N/A"}},null,null,"Total BTU",null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C12","v":"Worland, WY (44°)"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y9,IF(L8<>\"Gas\",ROUND(AJ19/3413,0), ROUND(AJ17/3413,0)),\"\")","v":""},null,{"$f":"IF(Y9,IF(L8<>\"Gas\",($K$20/($AF$15+$AF$16))/12,($K$20/$AF$15)/12),\"\")","v":""},null,null,{"$f":"IF(Y9,IF(M16<0,\"NEVER\",$L$9/$M$16),\"\")","v":""},null,{"$f":"IF(Y9,IF(M16<0,\"NEVER\",$R$16/$M$16),\"\")","v":""},null,null,null,null,18,"IN",null,"","","WY 25",7.6499999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C13","v":"Walla Walla, WA (46°)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L8=\"Gas\",\"*Simple Payback does not include gas heating penalty.\",\"\")","v":""},null,null,null,null,null,null,19,"KS",null,"","","WA 48T",4.9200000000000001E-2,8.875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Irradiance!C14","v":"Yakima, WA (46.5°)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"KY",null,"","","WA 40",7.2620000000000004E-2,1.4830000000000001,null,"Tariff Dates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"LA",null,{"$f":"IF(ISERROR(MID(VLOOKUP(LARGE($AA$11:$AA$41,W16),$AA$11:$AB$40,2,),4,3)),\"\",MID(VLOOKUP(LARGE($AA$11:$AA$41,W16),$AA$11:$AB$40,2,),4,5))","v":""},{"$f":"IF(LEFT(AB23,2)=$G$9,W16,\"\")","v":""},"WA 36",5.5079999999999997E-2,6.81,null,"CA","May 1, 2015","2015-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"MA",null,"","","WA 24",6.5769999999999995E-2,4.6399999999999997,null,"ID","November 13, 2014","2014-11-13"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"MD",null,"","","UT 23",6.7500000000000004E-2,9.2149999999999999,null,"UT","July 1, 2013","2013-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"ME",null,"","","UT 10",5.7630000000000001E-2,7.7949999999999999,null,"WA","January 1, 2014","2014-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"MI",null,"","","UT 9",4.367E-2,14.808,null,"WY","December 1, 2014","2014-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"MN",null,"","","UT 9A",9.2310000000000003E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"MO",null,"","","UT 8",4.8140000000000002E-2,19.181999999999999,null,null,null,null,"50% incentive cap:",{"$f":"L9/2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"MS",null,"","","UT 6",3.925E-2,13.573,null,null,null,null,"1-year payback cap",{"$f":"L9-M16","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"MT",null,"","","ID 35",5.833E-2,16.893999999999998,null,null,null,null,"Potential incentive:",{"$f":"K20*0.08","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"NC",null,"","","ID 23",9.5689999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"ND",null,"","","ID 10",5.568E-2,6.141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"NE",null,"","","ID 9",4.7460000000000002E-2,9.2430000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"NH",null,"","","ID 6",4.5679999999999998E-2,13.438000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"NJ",null,"","","ID 6A",4.5679999999999998E-2,13.438000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"NM",null,"","","CA 48",9.819E-2,7.15,null,"Updated 07/07/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"NV",null,{"$f":"IF(ISERROR(MID(VLOOKUP(LARGE($AA$11:$AA$41,W31),$AA$11:$AB$40,2,),4,3)),\"\",MID(VLOOKUP(LARGE($AA$11:$AA$41,W31),$AA$11:$AB$40,2,),4,5))","v":""},{"$f":"IF(LEFT(AB38,2)=$G$9,W31,\"\")","v":""},"CA 36",0.11493,8.51,null,"Rates Effective as of:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"NY",null,"","","CA 32",0.14724000000000001,3.8,null,"CA","2015-08-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"OH",null,"","","CA 25",0.16464999999999999,null,null,"ID","2016-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"OK",null,"","","CA PA20",0.13489999999999999,3.9460000000000002,null,"UT","2016-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"OR",null,null,null,null,null,null,null,"WA","2015-03-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,"PA",null,null,null,null,null,null,null,"WY","2015-05-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,"RI",null,null,null,null,null,null,null,"Rates for Software 6-17-2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"SC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"SD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,"TN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,"TX"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,"VA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,"VT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"WI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"WV"]

{"sheet":"Ref Tables","index":1,"n_rows":75,"n_cols":18,"rows_kept":75,"cut":false,"hidden":true,"merged":[[0,15,1,15],[0,0,0,1],[6,0,6,1],[0,10,0,14],[0,4,0,9]]}
["HVAC COP",null,"CLR","Clear","Filter",null,null,null,null,null,"ASHRAE Fundamentals 2005, Sections 31.26 - 31.39",null,null,null,null,"Filter Ref"]
["Cooling Types","COP","BRZ","Bronze","SHGC","Unique Glazing","Unique Tint","Tint","Unique Coating","Coating","ASHRAE Ref","Glazing","Tint","Coating","SHGC",null,null,{"$f":"IF(AND(N3<>\"Reflective\",OR(N3='Window Film'!$AT$3,'Window Film'!$AT$3=\"\")),IF(OR(M3='Window Film'!$AQ$3,'Window Film'!$AQ$3=\"\"),IF(OR(L3='Window Film'!$AP$3,'Window Film'!$AP$3=\"\"), 'Ref Tables'!P3,\"\"),\"\"),\"\")","v":1}]
["AC",2.9,"GRY","Grey",{"$f":"IF(L3&M3&N3='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O3,\"\")","v":""},{"$f":"IF(AND(N3<>\"Reflective\",OR(L3='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P3,\"\")","v":1},{"$f":"IF(H3=\"\",\"\",F3)","v":1},{"$f":"IF(F3=\"\",\"\",IF(ISERROR(MATCH(M3,$H$2:H2,0)),M3,\"\"))","v":"CLR"},{"$f":"IF(J3=\"\",\"\",F3)","v":1},{"$f":"IF(F3=\"\",\"\",IF(ISERROR(MATCH(N3,$J$2:J2,0)),N3,\"\"))","v":"Uncoated"},"1a","Single 1/8\" Glass","CLR","Uncoated",0.86,1]
["Evaporative Cooler or IDEC",20,"GRN","Green",{"$f":"IF(L4&M4&N4='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O4,\"\")","v":""},{"$f":"IF(AND(N4<>\"Reflective\",OR(L4='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P4,\"\")","v":2},{"$f":"IF(H4=\"\",\"\",F4)","v":""},{"$f":"IF(F4=\"\",\"\",IF(ISERROR(MATCH(M4,$H$2:H3,0)),M4,\"\"))","v":""},{"$f":"IF(J4=\"\",\"\",F4)","v":""},{"$f":"IF(F4=\"\",\"\",IF(ISERROR(MATCH(N4,$J$2:J3,0)),N4,\"\"))","v":""},"1b","Single 1/4\" Glass","CLR","Uncoated",0.81,2]
["Chilled Water (Water Cooled)",4.2,"BLUGRN","Blue Green",{"$f":"IF(L5&M5&N5='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O5,\"\")","v":""},{"$f":"IF(AND(N5<>\"Reflective\",OR(L5='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P5,\"\")","v":3},3,{"$f":"IF(F5=\"\",\"\",IF(ISERROR(MATCH(M5,$H$2:H4,0)),M5,\"\"))","v":"BRZ"},"",{"$f":"IF(F5=\"\",\"\",IF(ISERROR(MATCH(N5,$J$2:J4,0)),N5,\"\"))","v":""},"1c","Single 1/8\" Glass","BRZ","Uncoated",0.73,3]
["Chilled Water (Air Cooled)",3.2,"BLU","Blue",{"$f":"IF(L6&M6&N6='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O6,\"\")","v":""},{"$f":"IF(AND(N6<>\"Reflective\",OR(L6='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P6,\"\")","v":4},"",{"$f":"IF(F6=\"\",\"\",IF(ISERROR(MATCH(M6,$H$2:H5,0)),M6,\"\"))","v":""},"",{"$f":"IF(F6=\"\",\"\",IF(ISERROR(MATCH(N6,$J$2:J5,0)),N6,\"\"))","v":""},"1d","Single 1/4\" Glass","BRZ","Uncoated",0.62,4]
["Heating Types",null,"HI-P GRN","HI-Pass Green",{"$f":"IF(L7&M7&N7='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O7,\"\")","v":""},{"$f":"IF(AND(N7<>\"Reflective\",OR(L7='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P7,\"\")","v":5},5,{"$f":"IF(F7=\"\",\"\",IF(ISERROR(MATCH(M7,$H$2:H6,0)),M7,\"\"))","v":"GRN"},"",{"$f":"IF(F7=\"\",\"\",IF(ISERROR(MATCH(N7,$J$2:J6,0)),N7,\"\"))","v":""},"1e","Single 1/8\" Glass","GRN","Uncoated",0.7,5]
["Electric ",1,null,null,{"$f":"IF(L8&M8&N8='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O8,\"\")","v":""},{"$f":"IF(AND(N8<>\"Reflective\",OR(L8='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P8,\"\")","v":6},"",{"$f":"IF(F8=\"\",\"\",IF(ISERROR(MATCH(M8,$H$2:H7,0)),M8,\"\"))","v":""},"",{"$f":"IF(F8=\"\",\"\",IF(ISERROR(MATCH(N8,$J$2:J7,0)),N8,\"\"))","v":""},"1f","Single 1/4\" Glass","GRN","Uncoated",0.6,6]
["Heat Pump",3.2,null,null,{"$f":"IF(L9&M9&N9='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O9,\"\")","v":""},{"$f":"IF(AND(N9<>\"Reflective\",OR(L9='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P9,\"\")","v":7},7,{"$f":"IF(F9=\"\",\"\",IF(ISERROR(MATCH(M9,$H$2:H8,0)),M9,\"\"))","v":"GRY"},"",{"$f":"IF(F9=\"\",\"\",IF(ISERROR(MATCH(N9,$J$2:J8,0)),N9,\"\"))","v":""},"1g","Single 1/8\" Glass","GRY","Uncoated",0.7,7]
["Gas",0.8,null,null,{"$f":"IF(L10&M10&N10='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O10,\"\")","v":""},{"$f":"IF(AND(N10<>\"Reflective\",OR(L10='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P10,\"\")","v":8},"",{"$f":"IF(F10=\"\",\"\",IF(ISERROR(MATCH(M10,$H$2:H9,0)),M10,\"\"))","v":""},"",{"$f":"IF(F10=\"\",\"\",IF(ISERROR(MATCH(N10,$J$2:J9,0)),N10,\"\"))","v":""},"1h","Single 1/4\" Glass","GRY","Uncoated",0.59,8]
[null,null,null,null,{"$f":"IF(L11&M11&N11='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O11,\"\")","v":""},{"$f":"IF(AND(N11<>\"Reflective\",OR(L11='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P11,\"\")","v":9},9,{"$f":"IF(F11=\"\",\"\",IF(ISERROR(MATCH(M11,$H$2:H10,0)),M11,\"\"))","v":"BLUGRN"},"",{"$f":"IF(F11=\"\",\"\",IF(ISERROR(MATCH(N11,$J$2:J10,0)),N11,\"\"))","v":""},"1i","Single 1/4\" Glass","BLUGRN","Uncoated",0.62,9]
[null,null,null,null,{"$f":"IF(L12&M12&N12='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O12,\"\")","v":""},{"$f":"IF(AND(N12<>\"Reflective\",OR(L12='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P12,\"\")","v":""},"",{"$f":"IF(F12=\"\",\"\",IF(ISERROR(MATCH(M12,$H$2:H11,0)),M12,\"\"))","v":""},"",{"$f":"IF(F12=\"\",\"\",IF(ISERROR(MATCH(N12,$J$2:J11,0)),N12,\"\"))","v":""},"1j","Single 1/4\" Glass","SS 14% CLR","Reflective",0.19,10]
[null,null,null,null,{"$f":"IF(L13&M13&N13='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O13,\"\")","v":""},{"$f":"IF(AND(N13<>\"Reflective\",OR(L13='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P13,\"\")","v":""},"",{"$f":"IF(F13=\"\",\"\",IF(ISERROR(MATCH(M13,$H$2:H12,0)),M13,\"\"))","v":""},"",{"$f":"IF(F13=\"\",\"\",IF(ISERROR(MATCH(N13,$J$2:J12,0)),N13,\"\"))","v":""},"1k","Single 1/4\" Glass","SS 20% CLR","Reflective",0.25,11]
[null,null,null,null,{"$f":"IF(L14&M14&N14='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O14,\"\")","v":""},{"$f":"IF(AND(N14<>\"Reflective\",OR(L14='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P14,\"\")","v":""},"",{"$f":"IF(F14=\"\",\"\",IF(ISERROR(MATCH(M14,$H$2:H13,0)),M14,\"\"))","v":""},"",{"$f":"IF(F14=\"\",\"\",IF(ISERROR(MATCH(N14,$J$2:J13,0)),N14,\"\"))","v":""},"1l","Single 1/4\" Glass","SS 8% CLR","Reflective",0.31,12]
[null,null,null,null,{"$f":"IF(L15&M15&N15='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O15,\"\")","v":""},{"$f":"IF(AND(N15<>\"Reflective\",OR(L15='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P15,\"\")","v":""},"",{"$f":"IF(F15=\"\",\"\",IF(ISERROR(MATCH(M15,$H$2:H14,0)),M15,\"\"))","v":""},"",{"$f":"IF(F15=\"\",\"\",IF(ISERROR(MATCH(N15,$J$2:J14,0)),N15,\"\"))","v":""},"1m","Single 1/4\" Glass","SS 14% GRN ","Reflective",0.25,13]
[null,null,null,null,{"$f":"IF(L16&M16&N16='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O16,\"\")","v":""},{"$f":"IF(AND(N16<>\"Reflective\",OR(L16='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P16,\"\")","v":""},"",{"$f":"IF(F16=\"\",\"\",IF(ISERROR(MATCH(M16,$H$2:H15,0)),M16,\"\"))","v":""},"",{"$f":"IF(F16=\"\",\"\",IF(ISERROR(MATCH(N16,$J$2:J15,0)),N16,\"\"))","v":""},"1n","Single 1/4\" Glass","TI 20% CLR ","Reflective",0.28999999999999998,14]
[null,null,null,null,{"$f":"IF(L17&M17&N17='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O17,\"\")","v":""},{"$f":"IF(AND(N17<>\"Reflective\",OR(L17='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P17,\"\")","v":""},"",{"$f":"IF(F17=\"\",\"\",IF(ISERROR(MATCH(M17,$H$2:H16,0)),M17,\"\"))","v":""},"",{"$f":"IF(F17=\"\",\"\",IF(ISERROR(MATCH(N17,$J$2:J16,0)),N17,\"\"))","v":""},"1o","Single 1/4\" Glass","TI 30% CLR ","Reflective",0.39,15]
[null,null,null,null,{"$f":"IF(L18&M18&N18='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O18,\"\")","v":""},{"$f":"IF(AND(N18<>\"Reflective\",OR(L18='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P18,\"\")","v":16},"",{"$f":"IF(F18=\"\",\"\",IF(ISERROR(MATCH(M18,$H$2:H17,0)),M18,\"\"))","v":""},"",{"$f":"IF(F18=\"\",\"\",IF(ISERROR(MATCH(N18,$J$2:J17,0)),N18,\"\"))","v":""},"5a","Double 1/8\" Glass","CLR","Uncoated",0.76,16]
[null,null,null,null,{"$f":"IF(L19&M19&N19='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O19,\"\")","v":""},{"$f":"IF(AND(N19<>\"Reflective\",OR(L19='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P19,\"\")","v":17},"",{"$f":"IF(F19=\"\",\"\",IF(ISERROR(MATCH(M19,$H$2:H18,0)),M19,\"\"))","v":""},"",{"$f":"IF(F19=\"\",\"\",IF(ISERROR(MATCH(N19,$J$2:J18,0)),N19,\"\"))","v":""},"5b","Double 1/4\" Glass","CLR","Uncoated",0.7,17]
[null,null,null,null,{"$f":"IF(L20&M20&N20='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O20,\"\")","v":""},{"$f":"IF(AND(N20<>\"Reflective\",OR(L20='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P20,\"\")","v":18},"",{"$f":"IF(F20=\"\",\"\",IF(ISERROR(MATCH(M20,$H$2:H19,0)),M20,\"\"))","v":""},"",{"$f":"IF(F20=\"\",\"\",IF(ISERROR(MATCH(N20,$J$2:J19,0)),N20,\"\"))","v":""},"5c","Double 1/8\" Glass","BRZ","Uncoated",0.62,18]
[null,null,null,null,{"$f":"IF(L21&M21&N21='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O21,\"\")","v":""},{"$f":"IF(AND(N21<>\"Reflective\",OR(L21='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P21,\"\")","v":19},"",{"$f":"IF(F21=\"\",\"\",IF(ISERROR(MATCH(M21,$H$2:H20,0)),M21,\"\"))","v":""},"",{"$f":"IF(F21=\"\",\"\",IF(ISERROR(MATCH(N21,$J$2:J20,0)),N21,\"\"))","v":""},"5d","Double 1/4\" Glass","BRZ","Uncoated",0.49,19]
[null,null,null,null,{"$f":"IF(L22&M22&N22='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O22,\"\")","v":""},{"$f":"IF(AND(N22<>\"Reflective\",OR(L22='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P22,\"\")","v":20},"",{"$f":"IF(F22=\"\",\"\",IF(ISERROR(MATCH(M22,$H$2:H21,0)),M22,\"\"))","v":""},"",{"$f":"IF(F22=\"\",\"\",IF(ISERROR(MATCH(N22,$J$2:J21,0)),N22,\"\"))","v":""},"5e","Double 1/8\" Glass","GRN","Uncoated",0.6,20]
[null,null,null,null,{"$f":"IF(L23&M23&N23='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O23,\"\")","v":""},{"$f":"IF(AND(N23<>\"Reflective\",OR(L23='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P23,\"\")","v":21},"",{"$f":"IF(F23=\"\",\"\",IF(ISERROR(MATCH(M23,$H$2:H22,0)),M23,\"\"))","v":""},"",{"$f":"IF(F23=\"\",\"\",IF(ISERROR(MATCH(N23,$J$2:J22,0)),N23,\"\"))","v":""},"5f","Double 1/4\" Glass","GRN","Uncoated",0.49,21]
[null,null,null,null,{"$f":"IF(L24&M24&N24='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O24,\"\")","v":""},{"$f":"IF(AND(N24<>\"Reflective\",OR(L24='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P24,\"\")","v":22},"",{"$f":"IF(F24=\"\",\"\",IF(ISERROR(MATCH(M24,$H$2:H23,0)),M24,\"\"))","v":""},"",{"$f":"IF(F24=\"\",\"\",IF(ISERROR(MATCH(N24,$J$2:J23,0)),N24,\"\"))","v":""},"5g","Double 1/8\" Glass","GRY","Uncoated",0.6,22]
[null,null,null,null,{"$f":"IF(L25&M25&N25='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O25,\"\")","v":""},{"$f":"IF(AND(N25<>\"Reflective\",OR(L25='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P25,\"\")","v":23},"",{"$f":"IF(F25=\"\",\"\",IF(ISERROR(MATCH(M25,$H$2:H24,0)),M25,\"\"))","v":""},"",{"$f":"IF(F25=\"\",\"\",IF(ISERROR(MATCH(N25,$J$2:J24,0)),N25,\"\"))","v":""},"5h","Double 1/4\" Glass","GRY","Uncoated",0.47,23]
[null,null,null,null,{"$f":"IF(L26&M26&N26='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O26,\"\")","v":""},{"$f":"IF(AND(N26<>\"Reflective\",OR(L26='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P26,\"\")","v":24},"",{"$f":"IF(F26=\"\",\"\",IF(ISERROR(MATCH(M26,$H$2:H25,0)),M26,\"\"))","v":""},"",{"$f":"IF(F26=\"\",\"\",IF(ISERROR(MATCH(N26,$J$2:J25,0)),N26,\"\"))","v":""},"5i","Double 1/4\" Glass","BLUGRN","Uncoated",0.5,24]
[null,null,null,null,{"$f":"IF(L27&M27&N27='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O27,\"\")","v":""},{"$f":"IF(AND(N27<>\"Reflective\",OR(L27='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P27,\"\")","v":25},25,{"$f":"IF(F27=\"\",\"\",IF(ISERROR(MATCH(M27,$H$2:H26,0)),M27,\"\"))","v":"HI-P GRN"},"",{"$f":"IF(F27=\"\",\"\",IF(ISERROR(MATCH(N27,$J$2:J26,0)),N27,\"\"))","v":""},"5j","Double 1/4\" Glass","HI-P GRN","Uncoated",0.39,25]
[null,null,null,null,{"$f":"IF(L28&M28&N28='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O28,\"\")","v":""},{"$f":"IF(AND(N28<>\"Reflective\",OR(L28='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P28,\"\")","v":""},"",{"$f":"IF(F28=\"\",\"\",IF(ISERROR(MATCH(M28,$H$2:H27,0)),M28,\"\"))","v":""},"",{"$f":"IF(F28=\"\",\"\",IF(ISERROR(MATCH(N28,$J$2:J27,0)),N28,\"\"))","v":""},"5k","Double 1/4\" Glass","SS 8% CLR  CLR","Reflective",0.13,26]
[null,null,null,null,{"$f":"IF(L29&M29&N29='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O29,\"\")","v":""},{"$f":"IF(AND(N29<>\"Reflective\",OR(L29='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P29,\"\")","v":""},"",{"$f":"IF(F29=\"\",\"\",IF(ISERROR(MATCH(M29,$H$2:H28,0)),M29,\"\"))","v":""},"",{"$f":"IF(F29=\"\",\"\",IF(ISERROR(MATCH(N29,$J$2:J28,0)),N29,\"\"))","v":""},"5l","Double 1/4\" Glass","SS 14% CLR  CLR","Reflective",0.17,27]
[null,null,null,null,{"$f":"IF(L30&M30&N30='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O30,\"\")","v":""},{"$f":"IF(AND(N30<>\"Reflective\",OR(L30='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P30,\"\")","v":""},"",{"$f":"IF(F30=\"\",\"\",IF(ISERROR(MATCH(M30,$H$2:H29,0)),M30,\"\"))","v":""},"",{"$f":"IF(F30=\"\",\"\",IF(ISERROR(MATCH(N30,$J$2:J29,0)),N30,\"\"))","v":""},"5m","Double 1/4\" Glass","SS 20% CLR  CLR","Reflective",0.22,28]
[null,null,null,null,{"$f":"IF(L31&M31&N31='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O31,\"\")","v":""},{"$f":"IF(AND(N31<>\"Reflective\",OR(L31='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P31,\"\")","v":""},"",{"$f":"IF(F31=\"\",\"\",IF(ISERROR(MATCH(M31,$H$2:H30,0)),M31,\"\"))","v":""},"",{"$f":"IF(F31=\"\",\"\",IF(ISERROR(MATCH(N31,$J$2:J30,0)),N31,\"\"))","v":""},"5n","Double 1/4\" Glass","SS 14% GRN  CLR","Reflective",0.16,29]
[null,null,null,null,{"$f":"IF(L32&M32&N32='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O32,\"\")","v":""},{"$f":"IF(AND(N32<>\"Reflective\",OR(L32='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P32,\"\")","v":""},"",{"$f":"IF(F32=\"\",\"\",IF(ISERROR(MATCH(M32,$H$2:H31,0)),M32,\"\"))","v":""},"",{"$f":"IF(F32=\"\",\"\",IF(ISERROR(MATCH(N32,$J$2:J31,0)),N32,\"\"))","v":""},"5o","Double 1/4\" Glass","TI 20% CLR  CLR","Reflective",0.21,30]
[null,null,null,null,{"$f":"IF(L33&M33&N33='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O33,\"\")","v":""},{"$f":"IF(AND(N33<>\"Reflective\",OR(L33='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P33,\"\")","v":""},"",{"$f":"IF(F33=\"\",\"\",IF(ISERROR(MATCH(M33,$H$2:H32,0)),M33,\"\"))","v":""},"",{"$f":"IF(F33=\"\",\"\",IF(ISERROR(MATCH(N33,$J$2:J32,0)),N33,\"\"))","v":""},"5p","Double 1/4\" Glass","TI 30% CLR  CLR","Reflective",0.28999999999999998,31]
[null,null,null,null,{"$f":"IF(L34&M34&N34='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O34,\"\")","v":""},{"$f":"IF(AND(N34<>\"Reflective\",OR(L34='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P34,\"\")","v":32},"",{"$f":"IF(F34=\"\",\"\",IF(ISERROR(MATCH(M34,$H$2:H33,0)),M34,\"\"))","v":""},32,{"$f":"IF(F34=\"\",\"\",IF(ISERROR(MATCH(N34,$J$2:J33,0)),N34,\"\"))","v":"Low-E(.2) on surface 2"},"17a","Double 1/8\" Glass","CLR","Low-E(.2) on surface 2",0.65,32]
[null,null,null,null,{"$f":"IF(L35&M35&N35='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O35,\"\")","v":""},{"$f":"IF(AND(N35<>\"Reflective\",OR(L35='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P35,\"\")","v":33},"",{"$f":"IF(F35=\"\",\"\",IF(ISERROR(MATCH(M35,$H$2:H34,0)),M35,\"\"))","v":""},"",{"$f":"IF(F35=\"\",\"\",IF(ISERROR(MATCH(N35,$J$2:J34,0)),N35,\"\"))","v":""},"17b","Double 1/4\" Glass","CLR","Low-E(.2) on surface 2",0.6,33]
[null,null,null,null,{"$f":"IF(L36&M36&N36='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O36,\"\")","v":""},{"$f":"IF(AND(N36<>\"Reflective\",OR(L36='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P36,\"\")","v":34},"",{"$f":"IF(F36=\"\",\"\",IF(ISERROR(MATCH(M36,$H$2:H35,0)),M36,\"\"))","v":""},34,{"$f":"IF(F36=\"\",\"\",IF(ISERROR(MATCH(N36,$J$2:J35,0)),N36,\"\"))","v":"Low-E(.2) on surface 3"},"17c","Double 1/8\" Glass","CLR","Low-E(.2) on surface 3",0.7,34]
[null,null,null,null,{"$f":"IF(L37&M37&N37='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O37,\"\")","v":""},{"$f":"IF(AND(N37<>\"Reflective\",OR(L37='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P37,\"\")","v":35},"",{"$f":"IF(F37=\"\",\"\",IF(ISERROR(MATCH(M37,$H$2:H36,0)),M37,\"\"))","v":""},"",{"$f":"IF(F37=\"\",\"\",IF(ISERROR(MATCH(N37,$J$2:J36,0)),N37,\"\"))","v":""},"17d","Double 1/4\" Glass","CLR","Low-E(.2) on surface 3",0.65,35]
[null,null,null,null,{"$f":"IF(L38&M38&N38='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O38,\"\")","v":""},{"$f":"IF(AND(N38<>\"Reflective\",OR(L38='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P38,\"\")","v":36},"",{"$f":"IF(F38=\"\",\"\",IF(ISERROR(MATCH(M38,$H$2:H37,0)),M38,\"\"))","v":""},"",{"$f":"IF(F38=\"\",\"\",IF(ISERROR(MATCH(N38,$J$2:J37,0)),N38,\"\"))","v":""},"17e","Double 1/8\" Glass","BRZ","Low-E(.2) on surface 3",0.56999999999999995,36]
[null,null,null,null,{"$f":"IF(L39&M39&N39='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O39,\"\")","v":""},{"$f":"IF(AND(N39<>\"Reflective\",OR(L39='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P39,\"\")","v":37},"",{"$f":"IF(F39=\"\",\"\",IF(ISERROR(MATCH(M39,$H$2:H38,0)),M39,\"\"))","v":""},"",{"$f":"IF(F39=\"\",\"\",IF(ISERROR(MATCH(N39,$J$2:J38,0)),N39,\"\"))","v":""},"17f","Double 1/4\" Glass","BRZ","Low-E(.2) on surface 3",0.45,37]
[null,null,null,null,{"$f":"IF(L40&M40&N40='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O40,\"\")","v":""},{"$f":"IF(AND(N40<>\"Reflective\",OR(L40='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P40,\"\")","v":38},"",{"$f":"IF(F40=\"\",\"\",IF(ISERROR(MATCH(M40,$H$2:H39,0)),M40,\"\"))","v":""},"",{"$f":"IF(F40=\"\",\"\",IF(ISERROR(MATCH(N40,$J$2:J39,0)),N40,\"\"))","v":""},"17g","Double 1/8\" Glass","GRN","Low-E(.2) on surface 3",0.55000000000000004,38]
[null,null,null,null,{"$f":"IF(L41&M41&N41='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O41,\"\")","v":""},{"$f":"IF(AND(N41<>\"Reflective\",OR(L41='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P41,\"\")","v":39},"",{"$f":"IF(F41=\"\",\"\",IF(ISERROR(MATCH(M41,$H$2:H40,0)),M41,\"\"))","v":""},"",{"$f":"IF(F41=\"\",\"\",IF(ISERROR(MATCH(N41,$J$2:J40,0)),N41,\"\"))","v":""},"17h","Double 1/4\" Glass","GRN","Low-E(.2) on surface 3",0.41,39]
[null,null,null,null,{"$f":"IF(L42&M42&N42='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O42,\"\")","v":""},{"$f":"IF(AND(N42<>\"Reflective\",OR(L42='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P42,\"\")","v":40},"",{"$f":"IF(F42=\"\",\"\",IF(ISERROR(MATCH(M42,$H$2:H41,0)),M42,\"\"))","v":""},"",{"$f":"IF(F42=\"\",\"\",IF(ISERROR(MATCH(N42,$J$2:J41,0)),N42,\"\"))","v":""},"17i","Double 1/8\" Glass","GRY","Low-E(.2) on surface 3",0.54,40]
[null,null,null,null,{"$f":"IF(L43&M43&N43='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O43,\"\")","v":""},{"$f":"IF(AND(N43<>\"Reflective\",OR(L43='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P43,\"\")","v":41},"",{"$f":"IF(F43=\"\",\"\",IF(ISERROR(MATCH(M43,$H$2:H42,0)),M43,\"\"))","v":""},"",{"$f":"IF(F43=\"\",\"\",IF(ISERROR(MATCH(N43,$J$2:J42,0)),N43,\"\"))","v":""},"17j","Double 1/4\" Glass","GRY","Low-E(.2) on surface 3",0.39,41]
[null,null,null,null,{"$f":"IF(L44&M44&N44='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O44,\"\")","v":""},{"$f":"IF(AND(N44<>\"Reflective\",OR(L44='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P44,\"\")","v":42},"",{"$f":"IF(F44=\"\",\"\",IF(ISERROR(MATCH(M44,$H$2:H43,0)),M44,\"\"))","v":""},"",{"$f":"IF(F44=\"\",\"\",IF(ISERROR(MATCH(N44,$J$2:J43,0)),N44,\"\"))","v":""},"17k","Double 1/4\" Glass","BLUGRN","Low-E(.2) on surface 3",0.45,42]
[null,null,null,null,{"$f":"IF(L45&M45&N45='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O45,\"\")","v":""},{"$f":"IF(AND(N45<>\"Reflective\",OR(L45='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P45,\"\")","v":43},"",{"$f":"IF(F45=\"\",\"\",IF(ISERROR(MATCH(M45,$H$2:H44,0)),M45,\"\"))","v":""},"",{"$f":"IF(F45=\"\",\"\",IF(ISERROR(MATCH(N45,$J$2:J44,0)),N45,\"\"))","v":""},"17l","Double 1/4\" Glass","HI-P GRN","Low-E(.2) on surface 3",0.34,43]
[null,null,null,null,{"$f":"IF(L46&M46&N46='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O46,\"\")","v":""},{"$f":"IF(AND(N46<>\"Reflective\",OR(L46='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P46,\"\")","v":44},"",{"$f":"IF(F46=\"\",\"\",IF(ISERROR(MATCH(M46,$H$2:H45,0)),M46,\"\"))","v":""},44,{"$f":"IF(F46=\"\",\"\",IF(ISERROR(MATCH(N46,$J$2:J45,0)),N46,\"\"))","v":"Low-E(.1) on surface 2"},"21a","Double 1/8\" Glass","CLR","Low-E(.1) on surface 2",0.65,44]
[null,null,null,null,{"$f":"IF(L47&M47&N47='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O47,\"\")","v":""},{"$f":"IF(AND(N47<>\"Reflective\",OR(L47='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P47,\"\")","v":45},"",{"$f":"IF(F47=\"\",\"\",IF(ISERROR(MATCH(M47,$H$2:H46,0)),M47,\"\"))","v":""},"",{"$f":"IF(F47=\"\",\"\",IF(ISERROR(MATCH(N47,$J$2:J46,0)),N47,\"\"))","v":""},"21b","Double 1/4\" Glass","CLR","Low-E(.1) on surface 2",0.6,45]
[null,null,null,null,{"$f":"IF(L48&M48&N48='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O48,\"\")","v":""},{"$f":"IF(AND(N48<>\"Reflective\",OR(L48='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P48,\"\")","v":46},"",{"$f":"IF(F48=\"\",\"\",IF(ISERROR(MATCH(M48,$H$2:H47,0)),M48,\"\"))","v":""},46,{"$f":"IF(F48=\"\",\"\",IF(ISERROR(MATCH(N48,$J$2:J47,0)),N48,\"\"))","v":"Low-E(.1) on surface 3"},"21c","Double 1/8\" Glass","CLR","Low-E(.1) on surface 3",0.6,46]
[null,null,null,null,{"$f":"IF(L49&M49&N49='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O49,\"\")","v":""},{"$f":"IF(AND(N49<>\"Reflective\",OR(L49='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P49,\"\")","v":47},"",{"$f":"IF(F49=\"\",\"\",IF(ISERROR(MATCH(M49,$H$2:H48,0)),M49,\"\"))","v":""},"",{"$f":"IF(F49=\"\",\"\",IF(ISERROR(MATCH(N49,$J$2:J48,0)),N49,\"\"))","v":""},"21d","Double 1/4\" Glass","CLR","Low-E(.1) on surface 3",0.56000000000000005,47]
[null,null,null,null,{"$f":"IF(L50&M50&N50='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O50,\"\")","v":""},{"$f":"IF(AND(N50<>\"Reflective\",OR(L50='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P50,\"\")","v":48},"",{"$f":"IF(F50=\"\",\"\",IF(ISERROR(MATCH(M50,$H$2:H49,0)),M50,\"\"))","v":""},"",{"$f":"IF(F50=\"\",\"\",IF(ISERROR(MATCH(N50,$J$2:J49,0)),N50,\"\"))","v":""},"21e","Double 1/8\" Glass","BRZ","Low-E(.1) on surface 3",0.48,48]
[null,null,null,null,{"$f":"IF(L51&M51&N51='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O51,\"\")","v":""},{"$f":"IF(AND(N51<>\"Reflective\",OR(L51='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P51,\"\")","v":49},"",{"$f":"IF(F51=\"\",\"\",IF(ISERROR(MATCH(M51,$H$2:H50,0)),M51,\"\"))","v":""},"",{"$f":"IF(F51=\"\",\"\",IF(ISERROR(MATCH(N51,$J$2:J50,0)),N51,\"\"))","v":""},"21f","Double 1/4\" Glass","BRZ","Low-E(.1) on surface 3",0.39,49]
[null,null,null,null,{"$f":"IF(L52&M52&N52='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O52,\"\")","v":""},{"$f":"IF(AND(N52<>\"Reflective\",OR(L52='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P52,\"\")","v":50},"",{"$f":"IF(F52=\"\",\"\",IF(ISERROR(MATCH(M52,$H$2:H51,0)),M52,\"\"))","v":""},"",{"$f":"IF(F52=\"\",\"\",IF(ISERROR(MATCH(N52,$J$2:J51,0)),N52,\"\"))","v":""},"21g","Double 1/8\" Glass","GRN","Low-E(.1) on surface 3",0.46,50]
[null,null,null,null,{"$f":"IF(L53&M53&N53='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O53,\"\")","v":""},{"$f":"IF(AND(N53<>\"Reflective\",OR(L53='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P53,\"\")","v":51},"",{"$f":"IF(F53=\"\",\"\",IF(ISERROR(MATCH(M53,$H$2:H52,0)),M53,\"\"))","v":""},"",{"$f":"IF(F53=\"\",\"\",IF(ISERROR(MATCH(N53,$J$2:J52,0)),N53,\"\"))","v":""},"21h","Double 1/4\" Glass","GRN","Low-E(.1) on surface 3",0.36,51]
[null,null,null,null,{"$f":"IF(L54&M54&N54='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O54,\"\")","v":""},{"$f":"IF(AND(N54<>\"Reflective\",OR(L54='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P54,\"\")","v":52},"",{"$f":"IF(F54=\"\",\"\",IF(ISERROR(MATCH(M54,$H$2:H53,0)),M54,\"\"))","v":""},"",{"$f":"IF(F54=\"\",\"\",IF(ISERROR(MATCH(N54,$J$2:J53,0)),N54,\"\"))","v":""},"21i","Double 1/8\" Glass","GRY","Low-E(.1) on surface 3",0.46,52]
[null,null,null,null,{"$f":"IF(L55&M55&N55='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O55,\"\")","v":""},{"$f":"IF(AND(N55<>\"Reflective\",OR(L55='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P55,\"\")","v":53},"",{"$f":"IF(F55=\"\",\"\",IF(ISERROR(MATCH(M55,$H$2:H54,0)),M55,\"\"))","v":""},"",{"$f":"IF(F55=\"\",\"\",IF(ISERROR(MATCH(N55,$J$2:J54,0)),N55,\"\"))","v":""},"21j","Double 1/4\" Glass","GRY","Low-E(.1) on surface 3",0.34,53]
[null,null,null,null,{"$f":"IF(L56&M56&N56='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O56,\"\")","v":""},{"$f":"IF(AND(N56<>\"Reflective\",OR(L56='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P56,\"\")","v":54},"",{"$f":"IF(F56=\"\",\"\",IF(ISERROR(MATCH(M56,$H$2:H55,0)),M56,\"\"))","v":""},"",{"$f":"IF(F56=\"\",\"\",IF(ISERROR(MATCH(N56,$J$2:J55,0)),N56,\"\"))","v":""},"21k","Double 1/4\" Glass","BLUGRN","Low-E(.1) on surface 3",0.39,54]
[null,null,null,null,{"$f":"IF(L57&M57&N57='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O57,\"\")","v":""},{"$f":"IF(AND(N57<>\"Reflective\",OR(L57='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P57,\"\")","v":55},"",{"$f":"IF(F57=\"\",\"\",IF(ISERROR(MATCH(M57,$H$2:H56,0)),M57,\"\"))","v":""},"",{"$f":"IF(F57=\"\",\"\",IF(ISERROR(MATCH(N57,$J$2:J56,0)),N57,\"\"))","v":""},"21l","Double 1/4\" Glass","HI-P GRN","Low-E(.1) on surface 3",0.31,55]
[null,null,null,null,{"$f":"IF(L58&M58&N58='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O58,\"\")","v":""},{"$f":"IF(AND(N58<>\"Reflective\",OR(L58='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P58,\"\")","v":56},"",{"$f":"IF(F58=\"\",\"\",IF(ISERROR(MATCH(M58,$H$2:H57,0)),M58,\"\"))","v":""},56,{"$f":"IF(F58=\"\",\"\",IF(ISERROR(MATCH(N58,$J$2:J57,0)),N58,\"\"))","v":"Low-E(.05) on surface 2"},"25a","Double 1/8\" Glass","CLR","Low-E(.05) on surface 2",0.41,56]
[null,null,null,null,{"$f":"IF(L59&M59&N59='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O59,\"\")","v":""},{"$f":"IF(AND(N59<>\"Reflective\",OR(L59='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P59,\"\")","v":57},"",{"$f":"IF(F59=\"\",\"\",IF(ISERROR(MATCH(M59,$H$2:H58,0)),M59,\"\"))","v":""},"",{"$f":"IF(F59=\"\",\"\",IF(ISERROR(MATCH(N59,$J$2:J58,0)),N59,\"\"))","v":""},"25b","Double 1/4\" Glass","CLR","Low-E(.05) on surface 2",0.37,57]
[null,null,null,null,{"$f":"IF(L60&M60&N60='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O60,\"\")","v":""},{"$f":"IF(AND(N60<>\"Reflective\",OR(L60='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P60,\"\")","v":58},"",{"$f":"IF(F60=\"\",\"\",IF(ISERROR(MATCH(M60,$H$2:H59,0)),M60,\"\"))","v":""},"",{"$f":"IF(F60=\"\",\"\",IF(ISERROR(MATCH(N60,$J$2:J59,0)),N60,\"\"))","v":""},"25c","Double 1/4\" Glass","BRZ","Low-E(.05) on surface 2",0.26,58]
[null,null,null,null,{"$f":"IF(L61&M61&N61='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O61,\"\")","v":""},{"$f":"IF(AND(N61<>\"Reflective\",OR(L61='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P61,\"\")","v":59},"",{"$f":"IF(F61=\"\",\"\",IF(ISERROR(MATCH(M61,$H$2:H60,0)),M61,\"\"))","v":""},"",{"$f":"IF(F61=\"\",\"\",IF(ISERROR(MATCH(N61,$J$2:J60,0)),N61,\"\"))","v":""},"25d","Double 1/4\" Glass","GRN","Low-E(.05) on surface 2",0.31,59]
[null,null,null,null,{"$f":"IF(L62&M62&N62='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O62,\"\")","v":""},{"$f":"IF(AND(N62<>\"Reflective\",OR(L62='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P62,\"\")","v":60},"",{"$f":"IF(F62=\"\",\"\",IF(ISERROR(MATCH(M62,$H$2:H61,0)),M62,\"\"))","v":""},"",{"$f":"IF(F62=\"\",\"\",IF(ISERROR(MATCH(N62,$J$2:J61,0)),N62,\"\"))","v":""},"25e","Double 1/4\" Glass","GRY","Low-E(.05) on surface 2",0.24,60]
[null,null,null,null,{"$f":"IF(L63&M63&N63='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O63,\"\")","v":""},{"$f":"IF(AND(N63<>\"Reflective\",OR(L63='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P63,\"\")","v":61},61,{"$f":"IF(F63=\"\",\"\",IF(ISERROR(MATCH(M63,$H$2:H62,0)),M63,\"\"))","v":"BLU"},"",{"$f":"IF(F63=\"\",\"\",IF(ISERROR(MATCH(N63,$J$2:J62,0)),N63,\"\"))","v":""},"25f","Double 1/4\" Glass","BLU","Low-E(.05) on surface 2",0.27,61]
[null,null,null,null,{"$f":"IF(L64&M64&N64='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O64,\"\")","v":""},{"$f":"IF(AND(N64<>\"Reflective\",OR(L64='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P64,\"\")","v":62},"",{"$f":"IF(F64=\"\",\"\",IF(ISERROR(MATCH(M64,$H$2:H63,0)),M64,\"\"))","v":""},"",{"$f":"IF(F64=\"\",\"\",IF(ISERROR(MATCH(N64,$J$2:J63,0)),N64,\"\"))","v":""},"25g","Double 1/4\" Glass","HI-P GRN","Low-E(.05) on surface 2",0.27,62]
[null,null,null,null,{"$f":"IF(L65&M65&N65='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O65,\"\")","v":""},{"$f":"IF(AND(N65<>\"Reflective\",OR(L65='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P65,\"\")","v":63},"",{"$f":"IF(F65=\"\",\"\",IF(ISERROR(MATCH(M65,$H$2:H64,0)),M65,\"\"))","v":""},"",{"$f":"IF(F65=\"\",\"\",IF(ISERROR(MATCH(N65,$J$2:J64,0)),N65,\"\"))","v":""},"29a","Triple 1/8\" Glass","CLR","Uncoated",0.68,63]
[null,null,null,null,{"$f":"IF(L66&M66&N66='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O66,\"\")","v":""},{"$f":"IF(AND(N66<>\"Reflective\",OR(L66='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P66,\"\")","v":64},"",{"$f":"IF(F66=\"\",\"\",IF(ISERROR(MATCH(M66,$H$2:H65,0)),M66,\"\"))","v":""},"",{"$f":"IF(F66=\"\",\"\",IF(ISERROR(MATCH(N66,$J$2:J65,0)),N66,\"\"))","v":""},"29b","Triple 1/4\" Glass","CLR","Uncoated",0.61,64]
[null,null,null,null,{"$f":"IF(L67&M67&N67='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O67,\"\")","v":""},{"$f":"IF(AND(N67<>\"Reflective\",OR(L67='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P67,\"\")","v":65},"",{"$f":"IF(F67=\"\",\"\",IF(ISERROR(MATCH(M67,$H$2:H66,0)),M67,\"\"))","v":""},"",{"$f":"IF(F67=\"\",\"\",IF(ISERROR(MATCH(N67,$J$2:J66,0)),N67,\"\"))","v":""},"29c","Triple 1/4\" Glass","HI-P GRN","Uncoated",0.32,65]
[null,null,null,null,{"$f":"IF(L68&M68&N68='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O68,\"\")","v":""},{"$f":"IF(AND(N68<>\"Reflective\",OR(L68='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P68,\"\")","v":66},{"$f":"IF(H68=\"\",\"\",F68)","v":""},{"$f":"IF(F68=\"\",\"\",IF(ISERROR(MATCH(M68,$H$2:H67,0)),M68,\"\"))","v":""},{"$f":"IF(J68=\"\",\"\",F68)","v":""},{"$f":"IF(F68=\"\",\"\",IF(ISERROR(MATCH(N68,$J$2:J67,0)),N68,\"\"))","v":""},"32a","Triple 1/8\" Glass","CLR","Low-E(.2) on surface 2",0.6,66]
[null,null,null,null,{"$f":"IF(L69&M69&N69='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O69,\"\")","v":""},{"$f":"IF(AND(N69<>\"Reflective\",OR(L69='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P69,\"\")","v":67},"",{"$f":"IF(F69=\"\",\"\",IF(ISERROR(MATCH(M69,$H$2:H68,0)),M69,\"\"))","v":""},"",{"$f":"IF(F69=\"\",\"\",IF(ISERROR(MATCH(N69,$J$2:J68,0)),N69,\"\"))","v":""},"32b","Triple 1/4\" Glass","CLR","Low-E(.2) on surface 2",0.53,67]
[null,null,null,null,{"$f":"IF(L70&M70&N70='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O70,\"\")","v":""},{"$f":"IF(AND(N70<>\"Reflective\",OR(L70='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P70,\"\")","v":68},"",{"$f":"IF(F70=\"\",\"\",IF(ISERROR(MATCH(M70,$H$2:H69,0)),M70,\"\"))","v":""},68,{"$f":"IF(F70=\"\",\"\",IF(ISERROR(MATCH(N70,$J$2:J69,0)),N70,\"\"))","v":"Low-E(.2) on surface 5"},"32c","Triple 1/8\" Glass","CLR","Low-E(.2) on surface 5",0.62,68]
[null,null,null,null,{"$f":"IF(L71&M71&N71='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O71,\"\")","v":""},{"$f":"IF(AND(N71<>\"Reflective\",OR(L71='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P71,\"\")","v":69},"",{"$f":"IF(F71=\"\",\"\",IF(ISERROR(MATCH(M71,$H$2:H70,0)),M71,\"\"))","v":""},"",{"$f":"IF(F71=\"\",\"\",IF(ISERROR(MATCH(N71,$J$2:J70,0)),N71,\"\"))","v":""},"32d","Triple 1/4\" Glass","CLR","Low-E(.2) on surface 5",0.56000000000000005,69]
[null,null,null,null,{"$f":"IF(L72&M72&N72='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O72,\"\")","v":""},{"$f":"IF(AND(N72<>\"Reflective\",OR(L72='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P72,\"\")","v":70},"",{"$f":"IF(F72=\"\",\"\",IF(ISERROR(MATCH(M72,$H$2:H71,0)),M72,\"\"))","v":""},70,{"$f":"IF(F72=\"\",\"\",IF(ISERROR(MATCH(N72,$J$2:J71,0)),N72,\"\"))","v":"Low-E(.1) on surface 2 and 5"},"40a","Triple 1/8\" Glass","CLR","Low-E(.1) on surface 2 and 5",0.41,70]
[null,null,null,null,{"$f":"IF(L73&M73&N73='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O73,\"\")","v":""},{"$f":"IF(AND(N73<>\"Reflective\",OR(L73='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P73,\"\")","v":71},"",{"$f":"IF(F73=\"\",\"\",IF(ISERROR(MATCH(M73,$H$2:H72,0)),M73,\"\"))","v":""},"",{"$f":"IF(F73=\"\",\"\",IF(ISERROR(MATCH(N73,$J$2:J72,0)),N73,\"\"))","v":""},"40b","Triple 1/4\" Glass","CLR","Low-E(.1) on surface 2 and 5",0.36,71]
[null,null,null,null,{"$f":"IF(L74&M74&N74='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O74,\"\")","v":""},{"$f":"IF(AND(N74<>\"Reflective\",OR(L74='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P74,\"\")","v":72},"",{"$f":"IF(F74=\"\",\"\",IF(ISERROR(MATCH(M74,$H$2:H73,0)),M74,\"\"))","v":""},72,{"$f":"IF(F74=\"\",\"\",IF(ISERROR(MATCH(N74,$J$2:J73,0)),N74,\"\"))","v":"Low-E(.05) on surface 2 and 4"},"40c","Triple 1/8\" Glass","CLR","Low-E(.05) on surface 2 and 4",0.27,72]
[null,null,null,null,{"$f":"IF(L75&M75&N75='Window Film'!$AP$3&'Window Film'!$AQ$3&'Window Film'!$AT$3,'Ref Tables'!O75,\"\")","v":""},{"$f":"IF(AND(N75<>\"Reflective\",OR(L75='Window Film'!$AP$3,'Window Film'!$AP$3=\"\")), 'Ref Tables'!P75,\"\")","v":73},"",{"$f":"IF(F75=\"\",\"\",IF(ISERROR(MATCH(M75,$H$2:H74,0)),M75,\"\"))","v":""},"",{"$f":"IF(F75=\"\",\"\",IF(ISERROR(MATCH(N75,$J$2:J74,0)),N75,\"\"))","v":""},"40d","Triple 1/4\" Glass","CLR","Low-E(.05) on surface 2 and 4",0.26,73]

{"sheet":"Irradiance","index":2,"n_rows":25,"n_cols":32,"rows_kept":25,"cut":false,"hidden":true,"merged":[[0,27,0,28],[3,1,12,1],[0,0,1,2],[2,0,2,2],[14,1,24,1],[0,3,0,26]]}
["Solar Irradiance and Average Day Light Hours ",null,null,"Solar Irradiance, Ed (Average Day Hour, SHGC=1.0)"]
[null,null,null,null,null,"N",null,null,"NE",null,null,"E",null,null,"SE",null,null,"S",null,null,"SW",null,null,"W",null,null,"NW","ADLH"]
["Source: Ashrae 1997 Fundamentals, Section 29, Table 15-Table21",null,null,"Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average","Morning","Afternoon","Average",null,null,"day light hours","heating and cooling degree days","Weighted irradiant hours"]
[1,"Summer","St. George, UT (Latitude 37°)",227,227,{"$f":"SUM(D4:E4)/12/0.86","v":43.992248062015506},707,174,{"$f":"SUM(G4:H4)/12/0.86","v":85.368217054263567},990,175.6,{"$f":"SUM(J4:K4)/12/0.86","v":112.94573643410853},830.7,193.6,{"$f":"SUM(M4:N4)/12/0.86","v":99.253875968992247},317.5,317.5,{"$f":"SUM(P4:Q4)/12/0.86","v":61.531007751937985},193.6,830.7,{"$f":"SUM(S4:T4)/12/0.86","v":99.253875968992247},175.6,990,{"$f":"SUM(V4:W4)/12/0.86","v":112.94573643410853},174,707,{"$f":"SUM(Y4:Z4)/12/0.86","v":85.368217054263567},{"$f":"AF4","v":1177.3854590482929},null,2456,2710,{"$f":"AD4*(AE4/(AE15+AE4))","v":1177.3854590482929}]
[2,null,"Price,  UT (Latitude 39°)",229,229,{"$f":"SUM(D5:E5)/12/0.86","v":44.379844961240309},709,174,{"$f":"SUM(G5:H5)/12/0.86","v":85.562015503875969},992,175.9,{"$f":"SUM(J5:K5)/12/0.86","v":113.16860465116279},864.2,197.9,{"$f":"SUM(M5:N5)/12/0.86","v":102.91666666666667},344.5,344.5,{"$f":"SUM(P5:Q5)/12/0.86","v":66.763565891472865},197.9,864.2,{"$f":"SUM(S5:T5)/12/0.86","v":102.91666666666667},175.9,992,{"$f":"SUM(V5:W5)/12/0.86","v":113.16860465116279},174,709,{"$f":"SUM(Y5:Z5)/12/0.86","v":85.562015503875969},{"$f":"AF5","v":205.93357320786049},null,2476,601,{"$f":"AD5*(AE5/(AE16+AE5))","v":205.93357320786049}]
[3,null,"Salt Lake City,  UT (Latitude 40°)",215,215,41.666666666666671,666,174,81.395348837209298,1024,176,116.27906976744187,881,200,104.74806201550388,358,358,69.379844961240309,200,881,104.74806201550388,176,1024,116.27906976744187,174,666,81.395348837209298,441.37801608579088,null,2484,1193,441.37801608579088]
[4,null,"Rock Springs, WY (Latitude 41.5°)",215,215,41.666666666666671,662.1,173.8,80.998062015503891,1031.7,175.6,116.98643410852713,904.6,204.7,107.49031007751938,381.4,381.4,73.914728682170534,204.7,904.6,107.49031007751938,175.6,1031.7,116.98643410852713,173.8,662.1,80.998062015503891,80.592592592592595,null,2496,272,80.592592592592595]
[5,null,"Yreka, CA (42°)",215,215,41.666666666666671,660.8,173.8,80.872093023255815,1034.2,175.5,117.21899224806202,912.5,206.2,108.40116279069768,389.2,389.2,75.426356589147275,206.2,912.5,108.40116279069768,175.5,1034.2,117.21899224806202,173.8,660.8,80.872093023255815,220.67560685791884,null,2500,520,220.67560685791884]
[6,null,"Crescent City, CA (42°)",215,215,41.666666666666671,660.8,173.8,80.872093023255815,1034.2,175.5,117.21899224806202,912.5,206.2,108.40116279069768,389.2,389.2,75.426356589147275,206.2,912.5,108.40116279069768,175.5,1034.2,117.21899224806202,173.8,660.8,80.872093023255815,0.54478099803878843,null,2500,1,0.54478099803878843]
[7,null,"Pocatello,  ID (Latitude 42.5°)",215,215,41.666666666666671,659.4,173.7,80.726744186046503,1036.8,175.5,117.47093023255813,920.4,207.8,109.32170542635659,397.1,397.1,76.957364341085281,207.8,920.4,109.32170542635659,175.5,1036.8,117.47093023255813,173.7,659.4,80.726744186046503,140.75342098202307,null,2504,419,140.75342098202307]
[8,null,"Casper, WY (43°)",215,215,41.666666666666671,658.1,173.6,80.591085271317837,1039.4000000000001,175.3,117.70348837209303,928.2,209.4,110.2325581395349,404.9,404.9,78.468992248062023,209.4,928.2,110.2325581395349,175.3,1039.4000000000001,117.70348837209303,173.6,658.1,80.591085271317837,150.51209213051823,null,2508,469,150.51209213051823]
[9,null,"Worland, WY (44°)",215,215,41.666666666666671,655.5,175,80.474806201550379,1044.5,175,118.16860465116279,944,212.5,112.06395348837209,420.5,420.5,81.492248062015506,212.5,944,112.06395348837209,175,1044.5,118.16860465116279,175,655.5,80.474806201550379,209.25673862666179,null,2512,683,209.25673862666179]
[10,null,"Walla Walla, WA (46°)",215,215,41.666666666666671,650.20000000000005,174.5,79.912790697674424,1054.8,174.5,119.11821705426357,975.5,218.8,115.7267441860465,451.8,451.8,87.558139534883722,218.8,975.5,115.7267441860465,174.5,1054.8,119.11821705426357,174.5,650.20000000000005,79.912790697674424,396.80996884735202,null,2514,912,396.80996884735202]
[11,null,"Yakima, WA (46.5°)",215,215,41.666666666666671,648.9,174.4,79.777131782945744,1057.3,174.4,119.35077519379846,983.4,220.3,116.63759689922482,459.6,459.6,89.069767441860478,220.3,983.4,116.63759689922482,174.4,1057.3,119.35077519379846,174.4,648.9,79.777131782945744,190.67951507615791,null,2514,488,190.67951507615791]
[12,"Winter",{"$f":"C4","v":"St. George, UT (Latitude 37°)"},69.375,69.375,13.444767441860465,87.4,69.400000000000006,15.193798449612405,488.5,69.8,54.098837209302324,927.9,266,115.68798449612405,813,813,157.55813953488374,266,927.9,115.68798449612405,69.8,488.5,54.098837209302324,69.400000000000006,87.4,15.193798449612405,1001.1301963559172,null,1923,2943,{"$f":"AD15*(AE15/(AE4+AE15))","v":1001.1301963559172}]
[13,null,"Price,  UT (Latitude 39°)",65.125,65.125,12.621124031007751,79.099999999999994,65.099999999999994,13.972868217054263,459.5,65.2,50.843023255813954,900.6,268,113.23643410852712,803,803,155.62015503875969,268,900.6,113.23643410852712,65.2,459.5,50.843023255813954,65.099999999999994,79.099999999999994,13.972868217054263,1744.7239136451701,null,1903,6625,{"$f":"AD16*(AE16/(AE5+AE16))","v":1744.7239136451701}]
[14,null,"Salt Lake City,  UT (Latitude 40°)",63,63,12.209302325581396,75,63,13.372093023255815,445,63,49.224806201550393,887,269,112.01550387596899,798,798,154.65116279069767,269,887,112.01550387596899,63,445,49.224806201550393,63,75,13.372093023255815,1554.333363121835,null,{"$f":"(39-37)/(42-37)*(AD22-AD16)+AD16","v":1890.2},5521,1554.333363121835]
[15,null,"Rock Springs, WY (Latitude 41.5°)",59.4,59.4,11.511627906976745,69.7,59.4,12.50968992248062,419.7,59.4,46.424418604651159,854.4,266.39999999999998,108.60465116279069,777,777,150.58139534883722,266.39999999999998,854.4,108.60465116279069,59.4,419.7,46.424418604651159,59.4,69.7,12.50968992248062,1822.2003798670466,null,1883,8152,1822.2003798670466]
[16,null,"Yreka, CA (42°)",58.2,58.2,11.279069767441863,68,58.2,12.228682170542637,411.2,58.25,45.489341085271313,843.5,265.5,107.46124031007753,770,770,149.22480620155039,265.5,843.5,107.46124031007753,58.25,411.2,45.489341085271313,58.2,68,12.228682170542637,1713.1402138855883,null,1879,5371,1713.1402138855883]
[17,null,"Crescent City, CA (42°)",58.2,58.2,11.279069767441863,68,58.2,12.228682170542637,411.2,58.3,45.494186046511629,843.5,265.5,107.46124031007753,770,770,149.22480620155039,265.5,843.5,107.46124031007753,58.3,411.2,45.494186046511629,58.2,68,12.228682170542637,1878.5905426018739,null,1879,4588,1878.5905426018739]
[18,null,"Pocatello,  ID (Latitude 42.5°)",57.1,57.1,11.065891472868218,66.2,57.1,11.947674418604652,402.8,57.1,44.5639534883721,832.6,264.60000000000002,106.31782945736435,763,763,147.86821705426357,264.60000000000002,832.6,106.31782945736435,57.1,402.8,44.5639534883721,57.1,66.2,11.947674418604652,1769.6035685537965,null,1875,7035,1769.6035685537965]
[19,null,"Casper, WY (43°)",55.9,55.9,10.833333333333334,64.5,55.9,11.666666666666666,394.4,55.9,43.633720930232556,821.8,263.8,105.19379844961239,756,756,146.51162790697674,263.8,821.8,105.19379844961239,55.9,394.4,43.633720930232556,55.9,64.5,11.666666666666666,1758.7160588611644,null,1871,7346,1758.7160588611644]
[20,null,"Worland, WY (44°)",53.5,53.5,10.368217054263566,61,53.5,11.094961240310077,377.5,53.5,41.763565891472865,800,262,102.90697674418605,742,742,143.79844961240312,262,800,102.90697674418605,53.5,377.5,41.763565891472865,53.5,61,11.094961240310077,1711.4735943407732,null,1867,7516,1711.4735943407732]
[21,null,"Walla Walla, WA (46°)",48.8,48.8,9.4573643410852704,54,48.8,9.9612403100775193,343.8,48.8,38.042635658914733,756.5,258.5,98.352713178294564,714,714,138.37209302325581,258.5,756.5,98.352713178294564,48.8,343.8,38.042635658914733,48.8,54,9.9612403100775193,1570.6282450674973,null,1865,4866,1570.6282450674973]
[22,null,"Yakima, WA (46.5°)",47.5,47.5,9.2054263565891485,52.2,47.6,9.6705426356589168,335.3,47.6,37.102713178294579,745.6,257.60000000000002,97.209302325581405,707,707,137.01550387596899,257.60000000000002,745.6,97.209302325581405,47.6,335.3,37.102713178294579,47.6,52.2,9.6705426356589168,1723.5452284737332,null,1865,5946,1723.5452284737332]

{"sheet":"Help","index":3,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[[11,0,11,15],[0,0,1,15],[3,0,3,14],[7,0,7,15],[9,0,9,5],[24,0,24,15],[38,0,38,15],[12,0,12,14],[13,1,13,15],[14,0,14,14],[15,0,15,14],[19,3,19,6],[20,3,20,5],[34,2,34,3],[33,2,33,3],[35,2,35,3],[32,2,32,3],[31,2,31,3],[36,2,36,3]]}
["Window Film Calculator Help"]
[]
[]
["Note:  This window film calculator is provided for the express use of wattsmart Business approved EEA Participants only.  Any other use of this window film calculator tool is unauthorized unless specifically approved otherwise by the wattsmart Business Program Administrator or Rocky Mountain Power/Pacific Power"]
[]
["When to Use this Window Film Calculator"]
[]
["This window film calculator is designed to be used for obtaining basic savings and incentive information for installation of window film"]
[]
["How to Help Customers Obtain Incentives for window film"]
[]
["1.  Verify that the facility at which the window film is installed is served by Rocky Mountain Power /Pacific Power under one of the rate schedules eligible for the wattsmart Business program."]
["2.  Obtain film performance specifications."]
[null,"PLEASE NOTE: You will need the following data to obtain correct savings and incentive calculations: Glazing type, Glass Tint Color, and Coating"]
["3.  Fill out the blue cells in the window film calculator with all the requested information."]
["4.  Retain a copy of the window film calculator for your files.  You will need this later when applying for incentives."]
["5.  Help the customer fill out and submit an application for incentives.  Attach a copy of the window film calculator to the application."]
[]
["        Applications can be found online as indicated below:"]
[null,"For ID, UT, & WY:",null,"rockymountainpower.net/wattsmart"]
[null,"For CA & WA:",null,"pacificpower.net/wattsmart"]
[]
["Rate Schedule"]
[]
["The customer utility rate schedule is necessary to calculate accurate estimates.  Therefore, obtain the correct rate schedule from the customer's current Rocky Mountain Power/Pacific Power  bill or call your Coordinator at (866) 415-9800 and request it."]
[]
["Incentive Levels"]
[]
["Incentive levels vary depending on the utility service territory in which the facility is located. Below is a summary of eligibility and available incentives by state:"]
[]
["This tool calculates incentives in accordance with tariffs effective as listed below."]
[null,"State","Tariff Effective Date",null,"Incentive Rate"]
[null,"California",{"$f":"VLOOKUP(LEFT(B33,2),'Window Film'!$AF$23:$AG$27,2,FALSE)","v":"May 1, 2015"},null,"$0.15/kWh"]
[null,"Idaho",{"$f":"VLOOKUP(LEFT(B34,2),'Window Film'!$AF$23:$AG$27,2,FALSE)","v":"November 13, 2014"},null,"$0.15/kWh"]
[null,"Utah",{"$f":"VLOOKUP(LEFT(B35,2),'Window Film'!$AF$23:$AG$27,2,FALSE)","v":"July 1, 2013"},null,"$0.15/kWh"]
[null,"Wyoming",{"$f":"VLOOKUP(LEFT(B36,2),'Window Film'!$AF$23:$AG$27,2,FALSE)","v":"December 1, 2014"},null,"$0.15/kWh"]
[null,"Washington",{"$f":"VLOOKUP(LEFT(B37,2),'Window Film'!$AF$23:$AG$27,2,FALSE)","v":"January 1, 2014"},null,"$0.15/kWh"]
[]
["Reflective window films must be professionally installed and the customer/contractor\nwill be required to submit the square footage of film installed, performance characteristics of the existing\nwindow, applied window film specifications, and the orientation of the window (i.e., North, East, South or\nWest). Incentives for window films are calculated based on square footage, window orientation and other\nsystem parameters at the $/kWh annual energy savings (as found in the table above) and are subject to approval by Rocky Mountain Power/Pacific Power.\nWindow films must be installed in a facility that is cooled with mechanical systems, and must meet all other\nprogram terms and conditions."]
[]
[]
["Additional Help"]
[]
["Contact your project Coordinator at (866) 415-9800 with any questions you may have."]

{"sheet":"Change Log","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Date","Change Description","Name","Previous Revision #","New Revision #"]
["2012-08-16","updated RMP rates (ID, UT, WY)","Troy Williams","071412","071412.2"]
["2013-12-27","Updated for new WA tariff incentive rate ($0.15/kWh for new tariff, $0.12/kWh A4 for the previous tariff)","Jake DeMann","070113.2","010114.1"]
["2014-01-07","Updated rates, using Rates for Software 1-1-2014","Jake DeMann",10114.1,10114.1]
["2014-10-15","Changes:\n-          ID incentive rate changed to $0.15/kWh (previously $0.12/kWh)\n-          Rate schedules updated to match Rates for Software 6-8-14\n-          ID tariff date updated\n-          Version number updated \n","Jake DeMann","010114.1",110114.1]
["2014-11-24","- Version # revised, beta version for testing, release version to be 120114.1\n- Wyoming tariff effective date revised to 12/01/2014\n- Wyoming incentive rate changed to $0.15/kWh (Only CA remains at $0.12/kWh)\n- Wyoming tariff messaging revised to schedule 140\n","Jake DeMann",110114.1,"beta 120114"]
["2014-12-15","Finalized tool, version number","Jake DeMann","beta 120114","120114.1"]
["2015-04-10","- Version # revised, beta version for testing, release version to be 050115.1\n- CA tariff effective date revised to 5/01/2015\n- CA incentive rate changed to $0.15/kWh \n- CA tariff messaging revised to schedule 140\n",null,"120114.1","beta 050115"]
["2015-05-22","Made corrections as noted in QC Review:\n-Corrected CA effective Date\n-Added functionality to inform user when the dates do not align with effective date\n-Corrected the CA incentive listed in the Help tab\n-Updated Rates to align with Rates for Software 5-1-2015\n-Finalized the version number","Joe Larsen","beta 050115",50115.1]
["2016-07-07","Updated rates, using Rates for Software 6-17-2016","Jake DeMann",50115.1,"071116.1"]