{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["start here","AC","HP","Instruction - AC","Instruction - HP","Air_Conditioner","Heat_Pump","AC_Data","HP_Data","Solar_Data"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"start here","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,1,6,4],[9,1,9,4]]}
[{"$nulls":7},"2013-02-13"]
[]
[]
[]
[]
[]
["Step 1.","Select which region of the country you live in from the drop-down list at right:",null,null,null,"Region III",null,"(see maps, below)"]
[]
[]
["Step 2.","Select whether calculation is for an Air Conditioner or a Heat Pump:"]
[]
["Region I","Region II","Region III","Region IV","Region V","Region VI"]

{"sheet":"AC","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Step 3. Select:","Number of Solar Modules",0,"     (nominal 255 W DC, each)"]
["Step 4. Input:","Unit SEER"]
["Step 5. Input:","Unit Capacity at 95°",null,"     (BTUH)"]
[]
[]
["Step 6. Push \"Calculate\" Button:"]
["Equivalent SEER Required:"]
[]
["How to interpret this information:","This is the SEER required from a hypothetical competitor's air conditioner"]
[null,"in order to match the energy and operating cost savings of the Lennox"]
[null,"Sunsource Home Energy System represented by the input data."]
[null,"An equivalent SEER of infinite means that the solar production exceeds"]
[null,"the annual energy consumption of the system. "]

{"sheet":"HP","index":2,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Step 3.  Select:","Number of Solar Modules",0,"     (nominal 255 W DC, each)"]
["Step 4.  Input:","Unit SEER"]
["Step 5.  Input:","Unit Capacity at 95°",null,"     (BTUH)"]
["Step 6.  Input:","Unit Nominal HSPF",null,"     (DOE Region IV)"]
["Step 7.  Input:","Unit Heating Capacity at 47°",null,"     (BTUH)"]
["Step 8. Push \"Calculate\" Button:"]
[]
["Equivalent SEER Required:"]
["Equiv. (Region IV) HSPF Required:"]
["How to interpret this information:","This is the SEER and HSPF (region IV) required from a hypothetical competitor's heat"]
[null,"pump in order to match the energy and operating cost savings of the Lennox"]
[null,"Sunsource Home Energy System represented by the input data."]
[null,"An equivalent SEER or HSPF of infinite means that the solar production exceeds"]
[null,"the annual energy consumption of the system in cooling or heating, repectively. "]

{"sheet":"Instruction - AC","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instruction - HP","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Air_Conditioner","index":5,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Air Conditioner Calculations"]
[]
[]
["# of Solar Modules",{"$f":"AC!C3","v":0}]
["SEER",{"$f":"AC!C4","v":0}]
["Q_95",{"$f":"AC!C5","v":0}]
["Region",{"$f":"'start here'!$F$7","v":"Region III"}]
[]
["Regional Data"]
[null,"Region I","Region II","Region III","Region IV","Region V","Region VI"]
[]
[]
[]
["CLH",2400,1800,1200,800,400,200]
[]
["Solar Module Output",{"$f":"Solar_Data!B19","v":342.1},{"$f":"Solar_Data!C19","v":383},{"$f":"Solar_Data!D19","v":365.3},{"$f":"Solar_Data!E19","v":358.7},{"$f":"Solar_Data!F19","v":350.9},{"$f":"Solar_Data!G19","v":278.10000000000002}]
[]
[]
["Outputs:"]
["Annual Cooling kWh",{"$f":"(B14*$B$6)/($B$5*1000)","v":{"$error":"#DIV/0!"}},{"$f":"(C14*$B$6)/($B$5*1000)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["Total Solar kWh",{"$f":"B16*$B$4","v":0},0,0,0,0,0]
["% Heating and Cooling Offset of Solar",{"$f":"(B22/(B20))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
["First IF",{"$f":"IF(B22>(B20),\"Y\",\"N\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
["SEER Equation:",{"$f":"IF(B25=\"Y\",\"infinite\",$B$5*(B22+B20)/B20)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SEER Value",{"$f":"VLOOKUP(LEFT($A28,4)&\" Equation:\",$10:$28,MATCH($B$7,$10:$10,0),FALSE)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Heat_Pump","index":6,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Heat Pump Calculations"]
[]
["Region",{"$f":"'start here'!$F$7","v":"Region III"}]
["# of Solar Modules",{"$f":"HP!C3","v":0},null,null,"Constants:"]
["SEER",{"$f":"HP!C4","v":0},null,null,"C",0.77]
["Q_95",{"$f":"HP!C5","v":0}]
["HSPF (Region IV)",{"$f":"HP!C6","v":0}]
["Q_47",{"$f":"HP!C7","v":0}]
[]
["Regional Data"]
[null,"Region I","Region II","Region III","Region IV","Region V","Region VI"]
["HSPF",{"$f":"1.22601240300335*$B$7","v":0},{"$f":"1.15968391419054*$B$7","v":0},{"$f":"1.10140557994131*$B$7","v":0},{"$f":"1*$B$7","v":0},{"$f":"0.872255947789458*$B$7","v":0},{"$f":"1.18660259759129*$B$7","v":0}]
["DHRmin_raw",{"$f":"$B$8*((65-B18)/60)","v":0},{"$f":"$B$8*((65-C18)/60)","v":0},{"$f":"$B$8*((65-D18)/60)","v":0},{"$f":"$B$8*((65-E18)/60)","v":0},{"$f":"$B$8","v":0},{"$f":"$B$8*((65-G18)/60)","v":0}]
["DHRmin_rounded",{"$f":"IF(B13<40000,MROUND(B13,5000),MROUND(B13,10000))","v":0},0,0,0,0,0]
["CLH",2400,1800,1200,800,400,200]
["HLH",750,1250,1750,2250,2750,2750]
["Solar Module Output",{"$f":"Solar_Data!B19","v":342.1},{"$f":"Solar_Data!C19","v":383},{"$f":"Solar_Data!D19","v":365.3},{"$f":"Solar_Data!E19","v":358.7},{"$f":"Solar_Data!F19","v":350.9},{"$f":"Solar_Data!G19","v":278.10000000000002}]
["Tod (Htg. Design Temp °F)",37,27,17,5,-10,30]
[]
["Outputs:"]
["Annual Cooling kWh",{"$f":"(B15*$B$6)/($B$5*1000)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Annual Heating kWh",{"$f":"(B16*B14*$F$5)/(B12*1000)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Total Solar kWh",{"$f":"B17*$B$4","v":0},0,0,0,0,0]
["% Heating and Cooling Offset of Solar",{"$f":"(B23/(B22+B21))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["ratio HLH to total Hours",{"$f":"B16/(B15+B16)","v":0.23809523809523808},0.4098360655737705,0.59322033898305082,0.73770491803278693,0.87301587301587302,0.93220338983050843,"  this row defines a variable: HLH/(HLH+CLH)"]
["First IF",{"$f":"IF(B23>(B21+B22),\"Y\",\"N\")","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Second IF",{"$f":"IF(B26=\"Y\",1,IF(B25*B23>B22,2,\"N\"))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Third IF",{"$f":"IF(B27<>\"N\",B27,IF((1-B25)*B23>B21,3,4))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},"<-- The \"case numbers\" revealed"]
["SEER Equation",{"$f":"IF(ISODD(B28),\"infinite\",IF(B28=2,$B$5/B21*(B21+B23-B22),$B$5/B21*((1-B25)*B23+B21)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["HSPF Equation",{"$f":"IF(B28<3,\"infinite\",IF(ISODD(B28),B12/B22*(B22+B23-B21),B12/B22*(B25*B23+B22)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["SEER (Value)",{"$f":"VLOOKUP(LEFT($A31,4)&\" Equation\",$A$11:$G$30,MATCH($B$3,$11:$11,0),FALSE)","v":{"$error":"#DIV/0!"}}]
["HSPF (Value)",{"$f":"VLOOKUP(LEFT($A32,4)&\" Equation\",$A$11:$G$30,MATCH($E$11,$11:$11,0),FALSE)","v":{"$error":"#DIV/0!"}}]

{"sheet":"AC_Data","index":7,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["AHRI Certified Ref #","Model Status","Manufacturer Type","Trade/Brand Name","Outdoor Unit Manufacturer","Outdoor Unit Model","Indoor Unit Manufacturer(Mix-Match)","Indoor Unit Model","Furnace Model","Cooling Capacity (BTUH)","Cooling EER","Cooling SEER","Phase","ARI Type","HSVTC","Est. National Avg. Annual Operating Cooling Cost ($)","Eligible for Federal Tax Credit"]
[3232458,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-018-230*10",null,"C33-25*+TDR",null,18300,11.5,13.5,1,"RCU-A-C","Yes",158]
[3665942,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-018-230*11",null,"C33-25*+TDR",null,18300,11.5,13.5,1,"RCU-A-C","Yes",158]
[3208682,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-018-230-10",null,"CX34-25+TDR",null,18500,12,14.2,1,"RCU-A-C","Yes",152]
[3664837,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-018-230-11",null,"CX34-25+TDR",null,18500,12,14.2,1,"RCU-A-C","Yes",152]
[3232467,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-024-230*10",null,"C33-31*",null,24200,12,14,1,"RCU-A-C","Yes",201]
[3665951,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-024-230*11",null,"C33-31*",null,24200,12,14,1,"RCU-A-C","Yes",201]
[3206071,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-024-230-10",null,"CX34-31+TDR",null,24000,12,14.25,1,"RCU-A-C","Yes",196]
[3664875,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-024-230-11",null,"CX34-31+TDR",null,24000,12,14.25,1,"RCU-A-C","Yes",196]
[3232548,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-030-230*10",null,"C33-31*",null,28000,11.5,13.5,1,"RCU-A-C","Yes",242]
[3666033,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-030-230*11",null,"C33-31*",null,28000,11.5,13.5,1,"RCU-A-C","Yes",242]
[3208709,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-030-230-10",null,"CX34-31+TDR",null,28000,12,14.2,1,"RCU-A-C","Yes",230]
[3665035,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-030-230-11",null,"CX34-31+TDR",null,28000,12,14.2,1,"RCU-A-C","Yes",230]
[3232638,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-036-230*10",null,"C33-38",null,33400,11.5,13.5,1,"RCU-A-C","Yes",288]
[3666123,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-036-230*11",null,"C33-38",null,33400,11.5,13.5,1,"RCU-A-C","Yes",288]
[3208859,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-036-230-10",null,"CX34-38+TDR",null,34000,12,14.3,1,"RCU-A-C","Yes",277]
[3665194,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-036-230-11",null,"CX34-38+TDR",null,34000,12,14.3,1,"RCU-A-C","Yes",277]
[4718677,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-036-230-13",null,"CX34-38+TDR",null,34600,12,14.3,1,"RCU-A-C","Yes",282]
[3869121,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-041-230*",null,"CX34-49+TDR",null,39000,12.5,14.5,1,"RCU-A-C","Yes",313]
[4632446,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-042-230*12",null,"C33-49*",null,41000,11.5,13.5,1,"RCU-A-C","Yes",354]
[4632511,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-042-230-12",null,"CX34-49+TDR",null,41500,12,14,1,"RCU-A-C","Yes",345]
[3869197,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-047-230*",null,"CX34-62C+TDR",null,47000,12.5,14.5,1,"RCU-A-C","Yes",378]
[4632816,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-048-230*12",null,"C33-62C",null,49000,11.5,14,1,"RCU-A-C","Yes",408]
[4632885,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-048-230-12",null,"CX34-62C+TDR",null,49000,12,14,1,"RCU-A-C","Yes",408]
[4633222,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-059-230-02",null,"CX34-62C+TDR",null,57000,12,14.5,1,"RCU-A-C","Yes",458]
[5052833,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-059-230-04",null,"CX34-62C+TDR",null,57500,12.2,14.7,1,"RCU-A-C","Yes",456]
[4633224,"Active","Systems","14ACX SERIES - RFC","LENNOX INDUSTRIES, INC.","14ACX-060-230*12",null,"C33-62C",null,57500,11.5,14,1,"RCU-A-C","Yes",478]
[4633252,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-060-230-12",null,"CX34-62C+TDR",null,58000,12,14,1,"RCU-A-C","Yes",483]
[4718871,"Active","Systems","14ACX SERIES","LENNOX INDUSTRIES, INC.","14ACX-060-230-13",null,"CX34-62C+TDR",null,59500,12,14.2,1,"RCU-A-C","Yes",488]
[3843996,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-024-230*",null,"CX34-31+TDR",null,23800,12.7,15.2,1,"RCU-A-C","Yes",182]
[3844141,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-030-230*",null,"CX34-31+TDR",null,27800,12.2,15,1,"RCU-A-C","Yes",216]
[3844344,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-036-230*",null,"CX34-38+TDR",null,34600,12.7,15,1,"RCU-A-C","Yes",269]
[3844606,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-042-230*",null,"CX34-50/60C+TDR",null,39000,12,14.5,1,"RCU-A-C","Yes",313]
[3844921,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-048-230*",null,"CX34-50/60C+TDR",null,47000,12,14.5,1,"RCU-A-C","Yes",378]
[4096565,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-060-230-03",null,"CX34-62D+TDR",null,58000,12.5,15.2,1,"RCU-A-C","Yes",445]
[5010694,"Active","Systems","XC17 SERIES","LENNOX INDUSTRIES, INC.","XC17-060-230-04",null,"CX34-62D+TDR",null,58000,12.5,15.2,1,"RCU-A-C","Yes",445]
[4260831,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-024-230-06",null,"CX34-31+TDR","SL280UH090V36B*",26200,14.5,20,1,"RCU-A-CB","Yes",153,"Yes"]
[5010881,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-024-230-07",null,"CX34-31+TDR","SL280UH090V36B*",26200,14.5,20,1,"RCU-A-CB","Yes",153,"Yes"]
[4261187,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-036-230-06",null,"CX34-49+TDR","SL28UH090V60C*",37400,13.7,19.7,1,"RCU-A-CB","Yes",221,"Yes"]
[5012030,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-036-230-07",null,"CX34-49+TDR","SL28UH090V60C*",37400,13.7,19.7,1,"RCU-A-CB","Yes",221,"Yes"]
[4261411,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-048-230-06",null,"CX34-49+TDR","SL280UH090V60C*",49500,13.2,17.7,1,"RCU-A-CB","Yes",326,"Yes"]
[5012176,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-048-230-07",null,"CX34-49+TDR","SL280UH090V60C*",49500,13.2,17.7,1,"RCU-A-CB","Yes",326,"Yes"]
[4261763,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-060-230-06",null,"CX34-62D+TDR","SL280UH135V60D*",59000,12.2,16.2,1,"RCU-A-CB","Yes",424]
[5010435,"Active","Systems","XC21 SERIES","LENNOX INDUSTRIES, INC.","XC21-060-230-07",null,"CX34-62D+TDR","SL280UH135V60D*",59000,12.2,16.2,1,"RCU-A-CB","Yes",424]

{"sheet":"HP_Data","index":8,"n_rows":25,"n_cols":28,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["AHRI Certified Ref #","Model Status","Manufacturer Type","Trade/Brand Name","Outdoor Unit Manufacturer","Outdoor Unit Model","Indoor Unit Manufacturer(Mix-Match)","Indoor Unit Model","Furnace Model","Cooling Capacity (BTUH)","Cooling EER","Cooling SEER","High Heating 47 F Capacity (Btuh)","High Heating 47 F HSPF","Low Heating 17 F Capacity (Btuh)","Phase","ARI Type","HSVTC","Est. National Avg. Annual Operating Cooling Cost ($)","Est. National Avg. Annual Operating Heating Cost ($)","Eligible for Federal Tax Credit","NIST Region I HSPF","NIST Region II HSPF","NIST Region III HSPF","NIST Region IV HSPF","NIST Region V  HSPF","NIST Region VI  HSPF","Normalizing Factor"]
[4636738,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-018-230-13",null,"CBX27UH-018-230*+TDR",null,19000,12.5,15,16700,8,10000,1,"HRCU-A-CB","Yes",148,350,{"$nulls":7},{"$f":"N2/Y2","v":{"$error":"#DIV/0!"}}]
[4680381,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-018-230-17",null,"CBX27UH-018-230*+TDR",null,19900,12.7,15,17100,8,10600,1,"HRCU-A-CB","Yes",155,350,{"$nulls":7},{"$error":"#DIV/0!"}]
[4636851,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-024-230-13",null,"CBX26UH-024*+TDR",null,23200,12,14,22600,8.1999999999999993,14700,1,"HRCU-A-CB","Yes",193,569,{"$nulls":7},{"$error":"#DIV/0!"}]
[4680420,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-024-230-17",null,"CBX26UH-024*+TDR",null,23200,11.7,14,22200,8.1999999999999993,14000,1,"HRCU-A-CB","Yes",193,455,{"$nulls":7},{"$error":"#DIV/0!"}]
[4636926,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-030-230-13",null,"CBX26UH-030*+TDR",null,28200,12,14,28200,8.1999999999999993,17100,1,"HRCU-A-CB","Yes",235,683,{"$nulls":7},{"$error":"#DIV/0!"}]
[4681561,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-030-230-17",null,"CBX26UH-030*+TDR",null,28200,12,14,26400,8.1999999999999993,17100,1,"HRCU-A-CB","Yes",235,569,{"$nulls":7},{"$error":"#DIV/0!"}]
[4637231,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-036-230-12",null,"CBX26UH-037*+TDR",null,34600,12,14,35200,8.1999999999999993,21400,1,"HRCU-A-CB","Yes",288,796,{"$nulls":7},{"$error":"#DIV/0!"}]
[4682825,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-036-230-17",null,"CBX26UH-036*+TDR",null,34600,12,14,34800,8.1999999999999993,21400,1,"HRCU-A-CB","Yes",288,796,{"$nulls":7},{"$error":"#DIV/0!"}]
[4637490,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-042-230-12",null,"CBX26UH-042*+TDR",null,42500,12,14,45500,8.5,28200,1,"HRCU-A-CB","Yes",354,1098,{"$nulls":7},{"$error":"#DIV/0!"}]
[4684267,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-042-230-17",null,"CBX26UH-042*+TDR",null,42500,12,14,45500,8.1999999999999993,28200,1,"HRCU-A-CB","Yes",354,1138,{"$nulls":7},{"$error":"#DIV/0!"}]
[4637782,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-048-230-12",null,"CBX26UH-048*+TDR",null,49000,12,14,47000,8.1999999999999993,30200,1,"HRCU-A-CB","Yes",408,1138,{"$nulls":7},{"$error":"#DIV/0!"}]
[4684606,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-048-230-17",null,"CBX26UH-048*+TDR",null,49000,12,14,47000,8.1999999999999993,30200,1,"HRCU-A-CB","Yes",408,1138,{"$nulls":7},{"$error":"#DIV/0!"}]
[4637942,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-060-230-12",null,"CBX26UH-060*+TDR",null,58500,12,14,55000,8.1999999999999993,35800,1,"HRCU-A-CB","Yes",487,1365,{"$nulls":7},{"$error":"#DIV/0!"}]
[4684652,"Active","Systems","14HPX SERIES","LENNOX INDUSTRIES, INC.","14HPX-060-230-17",null,"CBX26UH-060*+TDR",null,58500,12,14,55500,8.1999999999999993,35800,1,"HRCU-A-CB","Yes",487,1365,{"$nulls":7},{"$error":"#DIV/0!"}]
[3839707,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-024-230*",null,"CBX32MV-024/030*+TDR",null,25000,14.5,17.5,22200,9.5,14400,1,"HRCU-A-CB","Yes",166,393,"Yes",11.78,11.2,10.58,9.6,8.2100000000000009,11.52,0.98958333333333337]
[3839761,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-030-230*",null,"CBX32MV-024/030*+TDR",null,29000,13.5,16.2,26800,9,17300,1,"HRCU-A-CB","Yes",209,518,"Yes",11.79,10.89,10.3,9.57,8.48,11.24,0.94043887147335425]
[3839843,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-036-230*",null,"CBX32MV-048*+TDR",null,37000,13.5,16.5,32600,9.1999999999999993,20400,1,"HRCU-A-CB","Yes",261,710,"Yes",11.38,10.8,10.31,9.31,8.15,11.05,0.98818474758324371]
[3840015,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-042-230*",null,"CBX32MV-048*+TDR",null,40000,12.7,15.7,36200,9.1999999999999993,22600,1,"HRCU-A-CB","Yes",297,710,"Yes",11.7,10.93,10.28,9.34,8.1300000000000008,11.24,0.98501070663811552]
[3840286,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-048-230*",null,"CBX32MV-060*+TDR",null,48000,12.7,15.2,46000,9,31000,1,"HRCU-A-CB","Yes",368,1037,"Yes",11.02,10.49,10.07,9.32,8.4,10.68,0.96566523605150212]
[3840331,"Active","Systems","XP17 SERIES","LENNOX INDUSTRIES, INC.","XP17-060-230*",null,"CBX32MV-060*+TDR",null,56000,12.5,15,52500,9,36000,1,"HRCU-A-CB","Yes",435,1037,"Yes",10.86,10.26,9.7899999999999991,9.1,8.16,10.49,0.98901098901098905]
[4016213,"Active","Systems","XP21 SERIES","LENNOX INDUSTRIES, INC.","XP21-024-230*",null,"CBX32MV-036*+TDR",null,25600,13.5,19,24000,9.1999999999999993,14300,1,"HRCU-A-CB","Yes",157,507,"Yes",11.46,10.98,10.43,9.2799999999999994,7.92,11.26,{"$f":"N22/Y22","v":0.99137931034482762}]
[4016307,"Active","Systems","XP21 SERIES","LENNOX INDUSTRIES, INC.","XP21-036-230*",null,"CBX32MV-048*+TDR",null,36600,12.7,18.2,33000,9.6999999999999993,21000,1,"HRCU-A-CB","Yes",234,673,"Yes",12.32,11.6,10.99,9.7899999999999991,8.39,11.79,{"$f":"N23/Y23","v":0.99080694586312568}]
[4016572,"Active","Systems","XP21 SERIES","LENNOX INDUSTRIES, INC.","XP21-048-230*",null,"CBX32MV-060*+TDR",null,48500,12.5,17.5,46000,9.1999999999999993,28800,1,"HRCU-A-CB","Yes",323,1014,"Yes",11.27,10.79,10.3,9.2100000000000009,7.99,10.95,{"$f":"N24/Y24","v":0.99891422366992377}]
[4028009,"Active","Systems","XP21 SERIES","LENNOX INDUSTRIES, INC.","XP21-060-230*",null,"CBX32MV-060*+TDR",null,57000,12.5,16.5,54000,9.1999999999999993,33400,1,"HRCU-A-CB","Yes",402,1014,"Yes",11.58,10.98,10.39,9.39,8.07,11.23,{"$f":"N25/Y25","v":0.9797657082002128}]

{"sheet":"Solar_Data","index":9,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":10},"Number of Solar Modules (M190 - 240)","Number of Solar Modules (M215-240)"]
[{"$nulls":10},0,0]
[{"$nulls":10},1,1]
[{"$nulls":10},2,2]
[{"$nulls":10},3,3]
[{"$nulls":10},4,4]
[{"$nulls":10},5,5]
[{"$nulls":10},6,6]
[{"$nulls":10},7,7]
[{"$nulls":10},8,8]
["Regional Data",{"$nulls":9},9,9]
[null,"Region I","Region II","Region III","Region IV","Region V","Region VI",null,null,null,10,10]
[{"$nulls":10},11,11]
[{"$nulls":10},12,12]
[{"$nulls":10},13,13]
[{"$nulls":10},14,14]
["Solar Module Output",{"$nulls":9},15,15]
["190W module:",253.7,284,270.89999999999998,266,260.2,206.2,"  (<-- this is kwh/yr/module)",null,null,null,16]
["255W module:",342.1,383,365.3,358.7,350.9,278.10000000000002,{"$nulls":4},17]