{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Averaging Calculator","Insulation Derate Calculator","Equipment Efficiency Calculator","Insul_calcs","Eff_Calcs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":24,"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":"Averaging Calculator","index":0,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,11],[22,13,22,17],[26,5,27,5],[26,11,27,11],[26,17,27,17],[3,1,3,5],[3,7,3,11],[7,5,8,5],[7,11,8,11],[22,1,22,6],[22,7,22,11]]}
[]
[null,null,null,"Enter values in the salmon colored fields to calculate the weighted average of up to 3 components."]
[]
[null,"R-Value - Weighted Average",null,null,null,null,null,"Ceiling Height - Weighted Average"]
[null,"Column A","Column B",null,null,null,null,"Column A","Column B"]
[null,"Building Component 1\nR-value","Building Component 1\nArea","Building Component 1\nUA",null,null,null,"1st Ceiling Height","Floor Area","Building Area 1 Volume"]
[null,17,957,{"$f":"C7/IF(B7=0,1,B7)","v":56.294117647058826},null,"Assembly R-Value",null,8,1000,{"$f":"I7*H7","v":8000},null,"Ceiling Height Average"]
[null,null,null,null,null,{"$f":"ROUND(1/F13,0)","v":13},null,null,null,null,null,{"$f":"ROUND(L13,0)","v":9}]
[null,"Building Component 2\nR-value","Building Component 2\nArea","Building Component 2\nUA",null,null,null,"2nd Ceiling Height","Floor Area","Building Area 2 Volume"]
[null,0,18,{"$f":"C10/IF(B10=0,1,B10)","v":18},null,null,null,10,400,{"$f":"I10*H10","v":4000}]
[]
[null,"Building Component 3\nR-value","Building Component 3\nArea","Building Component 3\nUA",null,"Assembly U-Factor",null,"3rd Ceiling Height","Floor Area","Building Area 3 Volume",null,"Average Ceiling Height"]
[null,null,null,{"$f":"C13/IF(B13=0,1,B13)","v":0},null,{"$f":"(IF(D7=0,0,D7)+IF(D10=0,0,D10)+IF(D13=0,0,D13))/(IF(D7=0,0,C7)+IF(D10=0,0,C10)+IF(D13=0,0,C13))","v":7.6199095022624438E-2},null,null,null,{"$f":"I13*H13","v":0},null,{"$f":"(IF(J7=0,0,J7)+IF(J10=0,0,J10)+IF(J13=0,0,J13))/(IF(J7=0,0,I7)+IF(J10=0,0,I10)+IF(J13=0,0,I13))","v":8.5714285714285712}]
[]
[null,"Instructions - R-value",null,null,null,null,null,"Instructions - Ceiling Height"]
[null,"Use the Insulation De-rate calculator to determine batt insulation R-values to use above",null,null,null,null,null,"Enter Ceiling Height of each space in column A"]
[null,"Use cavity insulation R-values",null,null,null,null,null,"Enter the floor area corresponding to each ceiling height in column B"]
[null,"Enter the R-value for each building component in column A ",null,null,null,null,null,"Enter the \"Ceiling Height Average\" in the Home Energy Scoring Tool"]
[null,"Enter the area of the corresponding space with that R-value in colum B"]
[null,"Enter the \"Assembly R-value\" in the Home Energy Scoring Tool"]
[null,"Follow rules for choosing the appropriate value from the drop down lists in the Tool"]
[]
[null,"AFUE - Weighted Average",null,null,null,null,null,"HSPF/SEER - Weighted Average ",null,null,null,null,null,"Energy Factor - Weighted Average"]
[null,"Column A","Column B",null,null,null,null,"Column A","Column B",null,null,null,null,"Column A","Column B"]
[null,"HVAC System 1 Input","HVAC System 1 Efficiency","System Weighted Efficiency",null,null,null,"HVAC System 1 Output ","HVAC System 1 Efficiency","System Weighted Efficiency",null,null,null,"DHW System 1 Input","DHW System 1 Energy Factor","System Weighted Energy Factor"]
[null,100000,0.85,{"$f":"C26*B26","v":85000},null,"Combustion System Efficiency",null,36000,7.5,{"$f":"I26*H26","v":270000},null,"Heat Pump/AC Efficiency",null,4500,0.87,{"$f":"O26*N26","v":3915},null,"Energy Factor"]
[null,null,null,null,null,{"$f":"(IF(D26=0,0,D26)+IF(D29=0,0,D29)+IF(D32=0,0,D32))/(IF(D26=0,0,B26)+IF(D29=0,0,B29)+IF(D32=0,0,B32))","v":0.86875000000000002},null,null,null,null,null,{"$f":"(IF(J26=0,0,J26)+IF(J29=0,0,J29)+IF(J32=0,0,J32))/(IF(J26=0,0,H26)+IF(J29=0,0,H29)+IF(J32=0,0,H32))","v":7.78},null,null,null,null,null,{"$f":"(IF(P26=0,0,P26)+IF(P29=0,0,P29)+IF(P32=0,0,P32))/(IF(P26=0,0,N26)+IF(P29=0,0,N29)+IF(P32=0,0,N32))","v":0.66325842696629211}]
[null,"HVAC System 2 Input ","HVAC System 2 Efficiency","System Weighted Efficiency",null,{"$f":"(D26+D29+D32)/(B26+B29+B32)","v":0.86875000000000002},null,"HVAC System 2 Output ","HVAC System 2 Efficiency","System Weighted Efficiency",null,{"$f":"(J26+J29+J32)/(H26+H29+H32)","v":7.78},null,"DHW System 2 Input ","DHW System 2 Energy Factor","System Weighted Energy Factor",null,{"$f":"(P26+P29+P32)/(N26+N29+N32)","v":0.66325842696629211}]
[null,60000,0.9,{"$f":"C29*B29","v":54000},null,null,null,24000,8.1999999999999993,{"$f":"I29*H29","v":196799.99999999997},null,null,null,40000,0.64,{"$f":"O29*N29","v":25600}]
[]
[null,"HVAC System 3 Input","HVAC System 3 Efficiency","System Weighted Efficiency",null,null,null,"HVAC System 3 Output ","HVAC System 3 Efficiency","System Weighted Efficiency",null,null,null,"HVAC System 3 Input ","DHW System 3 Energy Factor","System Weighted Energy Factor"]
[null,null,null,{"$f":"C32*B32","v":0},null,null,null,null,null,{"$f":"I32*H32","v":0},null,null,null,null,null,{"$f":"O32*N32","v":0}]
[]
[null,"Instructions - AFUE",null,null,null,null,null,"Instructions - HSPF/SEER",null,null,null,null,null,"Instructions - Energy Factor"]
[null,"Use the Equipment Efficiency Calculator to determine intial values to enter above",null,null,null,null,null,"Use the Equipment Efficiency Calculator to determine intial values to enter above",null,null,null,null,null,"Use the Equipment Efficiency Calculator to determine intial values to enter above"]
[null,"Enter Combustion Heating System Fuel Input (on the equipment in btus or gallons) in column A",null,null,null,null,null,"Enter Heat Pump/AC size (in BTUs on the equipment) in column A",null,null,null,null,null,"Enter Water Heater System Input (on the equipment) in column A"]
[null,"Enter the Combustion Heating System AFUE in column B",null,null,null,null,null,"Enter the HSPF or SEER in column B",null,null,null,null,null,"System Input can be BTU's or kWh but cannot be mixed"]
[null,"Enter the \"Combustion System Efficiency\" in Home Energy Scoring Tool",null,null,null,null,null,"Enter the \"Heat Pump/AC Efficiency\" in the Home Energy Scoring Tool",null,null,null,null,null,"Enter the Energy Factor in column B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter the \"Energy Factor\" in the Home Energy Scoring Tool"]

{"sheet":"Insulation Derate Calculator","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[[17,5,17,6],[33,1,33,5],[0,0,1,1],[17,0,17,1],[10,0,11,7],[12,0,12,7],[13,0,14,7],[15,0,15,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Good","Fair","Poor"]
[null,null,null,null,null,null,null,null,null,"Measured Batt Thickness","Effective R-value (2.5 per inch)","Effective R-value (1.8 per inch)","Effective R-value (0.7 per inch)"]
["Choose Insulation","Fiberglass",{"$f":"INDEX(Insul_calcs!$J$3:$J$12,MATCH(B4,Insul_calcs!$I$3:$I$12,0))","v":2.5},{"$f":"OR(B4=\"fiberglass\",B4=\"cellulose\",B4=\"rockwool\")","v":true},null,"<= click cells to choose values",null,null,null,0,0,0,0]
["Choose Type","Batt",null,{"$f":"IF(B5=\"Batt\",TRUE,FALSE)","v":true},null,null,null,null,null,1,3,2,1]
["Installation Quality","Fair",{"$f":"IF(D6=TRUE,0,IF(B6=\"\",1,INDEX(Insul_calcs!$P$4:$P$6,MATCH(B6,batt,0))))","v":0.72},{"$f":"AND(B5=\"batt\",B6=\"\")","v":false},null,null,null,null,null,2,5,4,1.5]
["Enter Depth (inches)",6,null,null,null,null,null,null,null,3,8,5,2]
[null,null,null,null,null,null,null,null,null,4,10,7,3]
["De-Rated R-value",{"$f":"ROUND(C4*C6*B7,0)","v":11},null,null,null,null,null,null,null,5,13,9,3.5]
[null,null,null,null,null,null,null,null,null,6,15,11,4]
["If the cells above are green, a value must be entered.  Red means, skip that cell.  The colors may change as you change preceding cell values.",null,null,null,null,null,null,null,null,7,18,13,5]
[null,null,null,null,null,null,null,null,null,8,20,14,5.5]
["Use the diagrams below to qualify the installation quality.",null,null,null,null,null,null,null,null,9,23,16,6]
["If there are multiple insulation depths, e.g. the blown insulation was not evenly applied or there are mulitple spaces with different amounts, use the Averaging Calculator to determine R-value",null,null,null,null,null,null,null,null,10,25,18,7]
[null,null,null,null,null,null,null,null,null,11,28,20,8]
["If you cannot see the insulation, e.g. wall cavity, assume installation quality = poor",null,null,null,null,null,null,null,null,12,30,22,8.5]
[null,null,null,null,null,null,null,null,null,"R-values based on fiberglass "]
["Good",null,null,null,null,"Fair"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Poor"]

{"sheet":"Equipment Efficiency Calculator","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,1,26,2],[26,4,26,5],[10,4,11,5],[8,4,9,5],[18,1,18,2],[14,1,14,5],[18,4,18,5],[15,1,15,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Choose System Type",null,null,"Enter This Efficiency into Home Energy Score for System Type Chosen"]
[null,"Is the HVAC system well maintained?"]
[null,"Enter system age (years)",6,null,{"$f":"IF(ISBLANK(C12),\"#N/A\",VLOOKUP('Equipment Efficiency Calculator'!C11,INDIRECT(Eff_Calcs!AB7),Eff_Calcs!AD5,FALSE))","v":6.8725464082031236}]
[null,"Enter installed efficiency (see tables)",8]
[]
[]
[null,"Starting Efficiencies"]
[null,"Use the starting efficiencies listed below if you do not know the equipment efficiency. "]
[]
[null,"Air Condioners",null,null,"Heat Pump"]
[null,"Installed Efficiency unless other data available",null,null,"Installed Efficiency unless other data available"]
[null,"Current Energy Star",14.5,null,"Current Energy Star",8.1999999999999993]
[null,"2006 or newer",13,null,"2006 or newer",8]
[null,"1996 to 2005",10,null,"1996 to 2005",7.1]
[null,"Prior to 1996",8,null,"Prior to 1996",6.6]
[]
[]
[null,"Gas/Propane Furnace or Boiler",null,null,"Oil Furnace or Boiler"]
[null,"Installed Efficiency unless other data available",null,null,"Installed Efficiency unless other data available"]
[null,"Condensing",0.9,null,"Condensing ",0.9]
[null,"Induced Draft",0.82,null,"Retention Head Burner",0.8]
[null,"Natural Draft",0.78,null,"Conventional Burner",0.72]
[]
[]
[null,"Default values for additional equipment - if efficiency is unknown - do no use calculator to derate these efficiencies"]
[]
[null,"Electric Resistance Heating",null,null,"Water Heater"]
[null,"Electric Furnace",0.99,null,"Gas - storage tank",0.55000000000000004]
[null,"Baseboard Electric",0.99,null,"Electric - storage tank",0.87]
[null,null,null,null,"Oil - storage tank",0.53]
[null,"Window A/C",9,null,"Gas - instananeous",0.8]
[null,null,null,null,"Electric instantaneous",1]

{"sheet":"Insul_calcs","index":3,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,null,"Good","Fair","Poor"]
[null,"Measured Batt Thickness","Effective R-value (2.5 per inch)","Effective R-value (1.8 per inch)","Effective R-value (0.7 per inch)",null,null,null,"Insulation","R-value",null,"Insulation Type",null,null,"Installation Quality","Multiplier"]
[null,0,0,0,0,null,null,1,"Select",0,null,"Select",null,1,"Select",null,null,"Blown"]
[null,1,3,2,1,null,null,2,"Cellulose",3.4,null,"Batt",1,2,"Good",1]
[null,2,5,4,1.5,null,null,3,"Fiberglass",2.5,null,"Blown ",null,3,"Fair",0.72]
[null,3,8,5,2,null,null,4,"Rockwool",3.1,null,"Foam",null,4,"Poor",0.28000000000000003]
[null,4,10,7,3,null,null,5,"Perlite",2.5,null,"Pour"]
[null,5,13,9,3.5,null,null,6,"Vermiculite",2.2000000000000002,null,"Chosen Type",4,null,"Chosen Quality",3]
[null,6,15,11,4,null,null,7,"Polystyrene-large curd",4]
[null,7,18,13,5,null,null,8,"Polystyrene-small curd",5,null,null,null,null,null,"Multiplier"]
[null,8,20,14,5.5,null,null,9,"Polyurethane",6,null,null,null,null,null,{"$f":"INDEX(P3:P6,MATCH(P8,N3:N6,0))","v":0.72}]
[null,9,23,16,6,null,null,10,"Polyisocyanurate",6]
[null,10,25,18,7,null,null,null,null,null,"Rvalue/inch"]
[null,11,28,20,8]
[null,12,30,22,8.5]
[]
[]
[]
[null,"Cellulose","Fiberglass","Rockwool",null,null,null,null,null,null,null,"Choose Insulation","Rockwool",{"$f":"INDEX(Insul_calcs!$J$3:$J$12,MATCH(M19,Insul_calcs!$I$3:$I$12,0))","v":3.1}]
[null,"Blown ","Blown ","Batt",null,null,null,null,null,null,null,"Choose Type","Batt"]
[null,"Batt","Batt",null,null,null,null,null,null,null,null,"Installation Quality","Good",{"$f":"IF(M21=\"N/A\",1,INDEX(Insul_calcs!$P$4:$P$6,MATCH(M21,batt,0)))","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"Enter Depth (inches)",10]
[null,"Vermiculite","Perlite"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N19*N21*M22","v":31}]
[]
[null,"Pour","Blown"]
[null,"N/A"]

{"sheet":"Eff_Calcs","index":4,"n_rows":52,"n_cols":32,"rows_kept":52,"cut":false,"hidden":true,"merged":[[2,1,2,10],[2,13,2,22],[27,1,27,10],[27,13,27,22],[31,1,31,2],[31,13,31,14],[6,1,6,2],[6,13,6,14]]}
[]
[null,2,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Natural Gas or Propane Furnace or Boiler",null,null,null,null,null,null,null,null,null,null,null,"Oil Furnace or Boiler"]
[null,null,null,"Equipment Age","Routinely Maintained",null,"Efficiency, if Routinely Maintained",null,"Rarely Maintained",null,"Efficiency, if Rarely Maintained",null,null,null,null,"Equipment Age","Routinely Maintained",null,"Efficiency, if Routinely Maintained",null,"Rarely Maintained","Efficiency, if Rarely Maintained","Efficiency, if Rarely Maintained",null,null,null,null,"Equipment Type",3]
[null,"Enter Installed Efficiency here ===>",{"$f":"'Equipment Efficiency Calculator'!C12","v":8},1,{"$f":"(1-0.005)^D5","v":0.995},{"$f":"$C$5*E5","v":7.96},{"$f":"IF(F5>=0.65,F5,0.65)","v":7.96},null,{"$f":"(1-0.015)^D5","v":0.98499999999999999},{"$f":"$C$5*I5","v":7.88},{"$f":"IF(J5>=0.65,J5,0.65)","v":7.88},null,null,"Enter Installed Efficiency here ===>",{"$f":"'Equipment Efficiency Calculator'!C12","v":8},1,{"$f":"(1-0.01)^P5","v":0.99},{"$f":"$O$5*Q5","v":7.92},{"$f":"IF(R5>=0.65,R5,0.65)","v":7.92},null,{"$f":"(1-0.025)^P5","v":0.97499999999999998},{"$f":"$O$5*U5","v":7.8},{"$f":"IF(V5>=0.65,V5,0.65)","v":7.8},null,null,null,null,"Maintained",3,{"$f":"IF(AC5=2,4,8)","v":8}]
[null,null,null,2,0.99002500000000004,7.9202000000000004,7.9202000000000004,null,0.970225,7.7618,7.7618,null,null,null,null,2,0.98009999999999997,7.8407999999999998,7.8407999999999998,null,0.95062499999999994,7.6049999999999995,7.6049999999999995]
[null,"Installed Efficiency unless other data available",null,3,0.98507487500000002,7.8805990000000001,7.8805990000000001,null,0.95567162500000002,7.6453730000000002,7.6453730000000002,null,null,"Installed Efficiency unless other data available",null,3,0.97029899999999991,7.7623919999999993,7.7623919999999993,null,0.92685937499999993,7.4148749999999994,7.4148749999999994,null,null,null,null,{"$f":"INDEX(AC12:AC15,MATCH(AC4,AB12:AB15,0))","v":"hp_table"}]
[null,"Condensing Furnace",0.9,4,0.98014950062500006,7.8411960050000005,7.8411960050000005,null,0.94133655062499999,7.5306924049999999,7.5306924049999999,null,null,"Retention Head Burner",0.8,4,0.96059600999999994,7.6847680799999996,7.6847680799999996,null,0.90368789062499988,7.229503124999999,7.229503124999999]
[null,"Induced Draft Furnace",0.82,5,0.97524875312187509,7.8019900249750007,7.8019900249750007,null,0.92721650236562503,7.4177320189250002,7.4177320189250002,null,null,"Conventional Burner",0.72,5,0.95099004989999991,7.6079203991999993,7.6079203991999993,null,0.88109569335937488,7.048765546874999,7.048765546874999]
[null,"Natural Draft Furnace",0.78,6,0.97037250935626573,7.7629800748501259,7.7629800748501259,null,0.91330825483014066,7.3064660386411253,7.3064660386411253,null,null,null,null,6,0.94148014940099989,7.5318411952079991,7.5318411952079991,null,0.85906830102539045,6.8725464082031236,6.8725464082031236]
[null,null,null,7,0.96552064680948435,7.7241651744758748,7.7241651744758748,null,0.89960863100768851,7.1968690480615081,7.1968690480615081,null,null,null,null,7,0.93206534790698992,7.4565227832559193,7.4565227832559193,null,0.83759159349975565,6.7007327479980452,6.7007327479980452,null,null,null,"System Type",1,null,null,"Yes",1]
[null,null,null,8,0.96069304357543694,7.6855443486034956,7.6855443486034956,null,0.88611450154257321,7.0889160123405857,7.0889160123405857,null,null,null,null,8,0.92274469442791995,7.3819575554233596,7.3819575554233596,null,0.81665180366226175,6.533214429298094,6.533214429298094,null,null,null,"Air Conditioner",2,"ac_table",null,"No",2]
[null,null,null,9,0.95588957835755972,7.6471166268604778,7.6471166268604778,null,0.87282278401943458,6.9825822721554767,6.9825822721554767,null,null,null,null,9,0.91351724748364072,7.3081379798691257,7.3081379798691257,null,0.79623550857070524,6.3698840685656419,6.3698840685656419,null,null,null,"Heat Pump",3,"hp_table"]
[null,null,null,10,0.95111013046577197,7.6088810437261758,7.6088810437261758,null,0.85973044225914308,6.8778435380731446,6.8778435380731446,null,null,null,null,10,0.9043820750088043,7.2350566000704344,7.2350566000704344,null,0.77632962085643753,6.2106369668515002,6.2106369668515002,null,null,null,"Gas",4,"gas_table"]
[null,null,null,11,0.94635457981344306,7.5708366385075445,7.5708366385075445,null,0.84683448562525598,6.7746758850020479,6.7746758850020479,null,null,null,null,11,0.89533825425871627,7.1627060340697302,7.1627060340697302,null,0.75692138033502654,6.0553710426802123,6.0553710426802123,null,null,null,"Oil",5,"oil_table"]
[null,null,null,12,0.94162280691437594,7.5329824553150075,7.5329824553150075,null,0.83413196834087711,6.6730557467270168,6.6730557467270168,null,null,null,null,12,0.88638487171612912,7.091078973729033,7.091078973729033,null,0.73799834582665091,5.9039867666132073,5.9039867666132073]
[null,null,null,13,0.93691469287980411,7.4953175430384329,7.4953175430384329,null,0.82161998881576392,6.5729599105261114,6.5729599105261114,null,null,null,null,13,0.87752102299896773,7.0201681839917418,7.0201681839917418,null,0.71954838718098457,5.7563870974478766,5.7563870974478766]
[null,null,null,14,0.93223011941540512,7.457840955323241,7.457840955323241,null,0.80929568898352755,6.4743655118682204,6.4743655118682204,null,null,null,null,14,0.86874581276897811,6.9499665021518249,6.9499665021518249,null,0.70155967750145998,5.6124774200116798,5.6124774200116798]
[null,null,null,15,0.92756896881832807,7.4205517505466245,7.4205517505466245,null,0.79715625364877452,6.3772500291901961,6.3772500291901961,null,null,null,null,15,0.86005835464128833,6.8804668371303066,6.8804668371303066,null,0.68402068556392337,5.472165484511387,5.472165484511387]
[null,null,null,16,0.92293112397423638,7.383448991793891,7.383448991793891,null,0.78519890984404295,6.2815912787523436,6.2815912787523436,null,null,null,null,16,0.85145777109487542,6.8116621687590033,6.8116621687590033,null,0.66692016842482538,5.335361347398603,5.335361347398603]
[null,null,null,17,0.9183164683543652,7.3465317468349216,7.3465317468349216,null,0.77342092619638225,6.187367409571058,6.187367409571058,null,null,null,null,17,0.84294319338392665,6.7435455470714132,6.7435455470714132,null,0.6502471642142047,5.2019773137136376,5.2019773137136376]
[null,null,null,18,0.91372488601259338,7.3097990881007471,7.3097990881007471,null,0.76181961230343653,6.0945568984274923,6.0945568984274923,null,null,null,null,18,0.83451376145008738,6.676110091600699,6.676110091600699,null,0.63399098510884955,5.0719278808707964,5.0719278808707964]
[null,null,null,19,0.90915626158253038,7.273250092660243,7.273250092660243,null,0.75039231811888507,6.0031385449510806,6.0031385449510806,null,null,null,null,19,0.82616862383558642,6.6093489906846914,6.6093489906846914,null,0.61814121048112836,4.9451296838490268,4.9451296838490268]
[null,null,null,20,0.90461048027461777,7.2368838421969421,7.2368838421969421,null,0.73913643334710177,5.9130914667768142,5.9130914667768142,null,null,null,null,20,0.81790693759723065,6.5432555007778452,6.5432555007778452,null,0.60268768021910013,4.821501441752801,4.821501441752801]
[]
[]
[null,4,null,null,null,null,null,null,null,null,null,null,null,5]
[null,"Air Conditioner",null,null,null,null,null,null,null,null,null,null,null,"Heat Pump"]
[null,null,null,"Equipment Age","Routinely Maintained",null,"Efficiency, if Routinely Maintained",null,"Rarely Maintained",null,"Efficiency, if Rarely Maintained",null,null,null,null,"Equipment Age","Routinely Maintained",null,"Efficiency, if Routinely Maintained",null,"Rarely Maintained","Efficiency, if Rarely Maintained","Efficiency, if Rarely Maintained"]
[null,"Enter Installed Efficiency here ===>",{"$f":"'Equipment Efficiency Calculator'!C12","v":8},1,{"$f":"(1-0.01)^D30","v":0.99},{"$f":"$C$30*E30","v":7.92},{"$f":"IF(F30>=6.5,F30,7)","v":7.92},null,{"$f":"(1-0.025)^D30","v":0.97499999999999998},{"$f":"$C$30*I30","v":7.8},{"$f":"IF(J30>=7,J30,7)","v":7.8},null,null,"Enter Installed Efficiency here ===>",{"$f":"'Equipment Efficiency Calculator'!C12","v":8},1,{"$f":"(1-0.01)^P30","v":0.99},{"$f":"$O$30*Q30","v":7.92},{"$f":"IF(R30>=6.5,R30,6.5)","v":7.92},null,{"$f":"(1-0.025)^P30","v":0.97499999999999998},{"$f":"$O$30*U30","v":7.8},{"$f":"IF(V30>=6,V30,6)","v":7.8}]
[null,null,null,2,0.98009999999999997,7.8407999999999998,7.8407999999999998,null,0.95062499999999994,7.6049999999999995,7.6049999999999995,null,null,null,null,2,0.98009999999999997,7.8407999999999998,7.8407999999999998,null,0.95062499999999994,7.6049999999999995,7.6049999999999995]
[null,"Installed Efficiency unless other data available",null,3,0.97029899999999991,7.7623919999999993,7.7623919999999993,null,0.92685937499999993,7.4148749999999994,7.4148749999999994,null,null,"Installed Efficiency unless other data available",null,3,0.97029899999999991,7.7623919999999993,7.7623919999999993,null,0.92685937499999993,7.4148749999999994,7.4148749999999994]
[null,"Current Energy Star",14.5,4,0.96059600999999994,7.6847680799999996,7.6847680799999996,null,0.90368789062499988,7.229503124999999,7.229503124999999,null,null,"Current Energy Star",8.1999999999999993,4,0.96059600999999994,7.6847680799999996,7.6847680799999996,null,0.90368789062499988,7.229503124999999,7.229503124999999]
[null,"2006 or newer",13,5,0.95099004989999991,7.6079203991999993,7.6079203991999993,null,0.88109569335937488,7.048765546874999,7.048765546874999,null,null,"2006 or newer",8,5,0.95099004989999991,7.6079203991999993,7.6079203991999993,null,0.88109569335937488,7.048765546874999,7.048765546874999]
[null,"1996 to 2006",10,6,0.94148014940099989,7.5318411952079991,7.5318411952079991,null,0.85906830102539045,6.8725464082031236,7,null,null,"1996 to 2006",7.1,6,0.94148014940099989,7.5318411952079991,7.5318411952079991,null,0.85906830102539045,6.8725464082031236,6.8725464082031236]
[null,"Prior to 1996",8,7,0.93206534790698992,7.4565227832559193,7.4565227832559193,null,0.83759159349975565,6.7007327479980452,7,null,null,"Prior to 1996",6.6,7,0.93206534790698992,7.4565227832559193,7.4565227832559193,null,0.83759159349975565,6.7007327479980452,6.7007327479980452]
[null,null,null,8,0.92274469442791995,7.3819575554233596,7.3819575554233596,null,0.81665180366226175,6.533214429298094,7,null,null,null,null,8,0.92274469442791995,7.3819575554233596,7.3819575554233596,null,0.81665180366226175,6.533214429298094,6.533214429298094]
[null,null,null,9,0.91351724748364072,7.3081379798691257,7.3081379798691257,null,0.79623550857070524,6.3698840685656419,7,null,null,null,null,9,0.91351724748364072,7.3081379798691257,7.3081379798691257,null,0.79623550857070524,6.3698840685656419,6.3698840685656419]
[null,null,null,10,0.9043820750088043,7.2350566000704344,7.2350566000704344,null,0.77632962085643753,6.2106369668515002,7,null,null,null,null,10,0.9043820750088043,7.2350566000704344,7.2350566000704344,null,0.77632962085643753,6.2106369668515002,6.2106369668515002]
[null,null,null,11,0.89533825425871627,7.1627060340697302,7.1627060340697302,null,0.75692138033502654,6.0553710426802123,7,null,null,null,null,11,0.89533825425871627,7.1627060340697302,7.1627060340697302,null,0.75692138033502654,6.0553710426802123,6.0553710426802123]
[null,null,null,12,0.88638487171612912,7.091078973729033,7.091078973729033,null,0.73799834582665091,5.9039867666132073,7,null,null,null,null,12,0.88638487171612912,7.091078973729033,7.091078973729033,null,0.73799834582665091,5.9039867666132073,6]
[null,null,null,13,0.87752102299896773,7.0201681839917418,7.0201681839917418,null,0.71954838718098457,5.7563870974478766,7,null,null,null,null,13,0.87752102299896773,7.0201681839917418,7.0201681839917418,null,0.71954838718098457,5.7563870974478766,6]
[null,null,null,14,0.86874581276897811,6.9499665021518249,6.9499665021518249,null,0.70155967750145998,5.6124774200116798,7,null,null,null,null,14,0.86874581276897811,6.9499665021518249,6.9499665021518249,null,0.70155967750145998,5.6124774200116798,6]
[null,null,null,15,0.86005835464128833,6.8804668371303066,6.8804668371303066,null,0.68402068556392337,5.472165484511387,7,null,null,null,null,15,0.86005835464128833,6.8804668371303066,6.8804668371303066,null,0.68402068556392337,5.472165484511387,6]
[null,null,null,16,0.85145777109487542,6.8116621687590033,6.8116621687590033,null,0.66692016842482538,5.335361347398603,7,null,null,null,null,16,0.85145777109487542,6.8116621687590033,6.8116621687590033,null,0.66692016842482538,5.335361347398603,6]
[null,null,null,17,0.84294319338392665,6.7435455470714132,6.7435455470714132,null,0.6502471642142047,5.2019773137136376,7,null,null,null,null,17,0.84294319338392665,6.7435455470714132,6.7435455470714132,null,0.6502471642142047,5.2019773137136376,6]
[null,null,null,18,0.83451376145008738,6.676110091600699,6.676110091600699,null,0.63399098510884955,5.0719278808707964,7,null,null,null,null,18,0.83451376145008738,6.676110091600699,6.676110091600699,null,0.63399098510884955,5.0719278808707964,6]
[null,null,null,19,0.82616862383558642,6.6093489906846914,6.6093489906846914,null,0.61814121048112836,4.9451296838490268,7,null,null,null,null,19,0.82616862383558642,6.6093489906846914,6.6093489906846914,null,0.61814121048112836,4.9451296838490268,6]
[null,null,null,20,0.81790693759723065,6.5432555007778452,6.5432555007778452,null,0.60268768021910013,4.821501441752801,7,null,null,null,null,20,0.81790693759723065,6.5432555007778452,6.5432555007778452,null,0.60268768021910013,4.821501441752801,6]
[]
[]
[null,"Building America House Simulation Protocols October 2010"]