{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Instructions","Max Input Data","Reduced Input Data","Optional Test Data","General Info & Test Results","Instrumentation","Test Conditions","Max Test","Reduced Test","Optional Jacket Loss Test","Draft Factor Tests","Photos","Test Data Inputs & Calculations","Comments","Report Sign-Off Block","Drop-Downs and Tables","Version Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":244,"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":"Instructions","index":0,"n_rows":71,"n_cols":3,"rows_kept":71,"cut":false,"hidden":false,"merged":[[41,1,43,2],[44,1,45,2],[46,1,47,1],[46,2,47,2],[1,1,1,2],[32,1,32,2],[33,1,34,1],[35,1,38,1],[10,1,10,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"}]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Instructions"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[null,"Reference Test Procedures"]
[null,"10 CFR 430 Subpart B Appendix N:  Uniform Test Method for Measuring the Energy Consumption of Furnaces and Boilers"]
[]
[null,"Table of Contents"]
[null,"Tab","Contents"]
[null,"Instructions","Instructions and Table of Contents"]
[null,"Max Input Data","Raw data for the Max Test"]
[null,"Reduced Input Data","Raw data for the Reduced Test"]
[null,"Optional Test Data","Raw data for the Optional Test"]
[null,"General Info & Test Results","Lab information, product information and test results"]
[null,"Instrumentation","Instrumentation requirements and space for sensor placement descriptions"]
[null,"Test Conditions","Table of test condition requirements for each test"]
[null,"Max Test","Calculates values at the maximum input rating"]
[null,"Reduced Test","Calculates values at the reduced input rating"]
[null,"Optional Jacket Loss Test","Calculates jacket loss factor, or allows user input"]
[null,"Draft Factor Test","Calculates off-cycle draft factor for flue gas flow and power burner draft factor"]
[null,"Photos","Inputs for photographs"]
[null,"Test Data Inputs & Calculations","Measurement inputs and automated calculations"]
[null,"Comments","Inputs for report template user to provide comments"]
[null,"Report Sign-Off Block","Report review history"]
[null,"Drop-Downs & Tables","Drop downs used and tables referenced"]
[null,"Version Control","Revision history"]
[]
[null,"LEGEND"]
[null,"Tabs","Tabs with input cells"]
[null,null,"Tabs with space to paste raw data"]
[null,"Cells","Input cell"]
[null,null,"Auto-populated cell"]
[null,null,"Provided data"]
[null,null,"NOT USED"]
[]
[null,"Instructions for Completing this Template"]
[null,"Follow the steps below, filling in all input cells (shaded light blue) in each tab you are instructed to complete. Using TAB to \"hop\" from input cell to input cell is useful, but does not ensure that all input cells are reached. To guarantee that you enter all required information, you must visually scan for light blue cells in the entire area bounded by yellow-shaded cells. "]
[]
[]
[null,"Important: Start with a clean (unused) template copy for each new report. Enter only data and information that are unique to the unit tested and the current test of that unit. All abbreviations and variable names should be consistent with the reference test procedure."]
[]
[null,"STEP:","FILL IN INPUT CELLS IN THIS TAB:"]
[]
[null,"Step 1","General Info & Test Results"]
[null,"Step 2","Instrumentation"]
[null,"Step 3","Import raw data into the appropriate data tabs (see instructions directly below)"]
[null,"Step 4","Test Conditions"]
[null,"Step 5","Max Test"]
[null,"Step 6","Reduced Test"]
[null,"Step 7","Optional Jacket Loss Test"]
[null,"Step 8","Draft Factor Test"]
[null,"Step 7","Photos"]
[null,"Step 8","Test Data Inputs & Calculations"]
[null,"Step 9","Comments"]
[null,"Step 10","Report Sign-off Block"]
[]
[null,"Raw Data Import Instructions"]
[null,"Input raw data from the efficient tests into the corresponding tabs located immediately after the Instructions tab."]
[null,"Include the following as a function of time for at least the duration of the steady state period and all test periods:"]
[null,"• Watts"]
[null,"• Watt-hours"]
[null,"• Volts"]
[null,"• Amps"]
[null,"• Temperatures from thermocouple grid"]
[null,"• Temperatures from jacket surface"]
[null,"• Temperatures from ambient thermocouples"]

{"sheet":"Max Input Data","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Title Block",null,null,null,null,null,null,null,"Input raw data from the max input efficiency tests into this tab."]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"},null,"Back to Instructions tab",null,null,null,null,"Include the following as a function of time for at least the duration of the steady state period and all test periods:"]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,null,null,"• Watts"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"},null,null,null,null,null,null,"• Watt-hours"]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Max Input Data"},null,null,null,null,null,null,"• Volts"]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"},null,null,null,null,null,null,"• Amps"]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"},null,null,null,null,null,null,"• Temperatures from thermocouple grid"]
[null,null,null,null,null,null,null,null,null,"• Temperatures from ambient thermocouples"]

{"sheet":"Reduced Input Data","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Title Block",null,null,null,null,null,null,null,"Input raw data from the reduced input efficiency tests into this tab."]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"},null,"Back to Instructions tab",null,null,null,null,"Include the following as a function of time for at least the duration of the steady state period and all test periods:"]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,null,null,"• Watts"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"},null,null,null,null,null,null,"• Watt-hours"]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Reduced Input Data"},null,null,null,null,null,null,"• Volts"]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"},null,null,null,null,null,null,"• Amps"]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"},null,null,null,null,null,null,"• Temperatures from thermocouple grid"]
[null,null,null,null,null,null,null,null,null,"• Temperatures from ambient thermocouples"]

{"sheet":"Optional Test Data","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Title Block",null,null,null,null,null,null,null,"Input raw data from optional jacket loss test and/or draft factor test"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"},null,"Back to Instructions tab",null,null,null,null,"Include the following as a function of time for at least the duration of the steady state period and all test periods:"]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,null,null,"• Surface Temperature"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"},null,null,null,null,null,null,"• Group Area"]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Optional Test Data"},null,null,null,null,null,null,"• Coefficient of Radiation"]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"},null,null,null,null,null,null,"• Coefficient of Convection"]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"},null,null,null,null,null,null,"• Room Temperature"]
[null,null,null,null,null,null,null,null,null,"• Hourly Heat Loss"]

{"sheet":"General Info & Test Results","index":4,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[34,1,34,2],[1,1,1,2],[29,4,29,5],[21,4,23,7],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[20,4,20,7]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"General Info & Test Results"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Lab Information ",null,null,"Test Results"]
[null,"Lab Name:",null,null,"Variable","Result","Units"]
[null,"Lab Location:",null,null,"Steady State Efficiency",{"$f":"IF(Energy_Source=\"Electricity\",\"N/A\",IF(Control_Stages=\"Single Stage\",ROUND(EFFY_ss,1), IF(Control_Stages=\"Two-Stage Modulating\",ROUND(EFFY_SS_W_2S,1),IF(Control_Stages=\"Step Modulating\",ROUND(EFFY_SS_W_MOD,1),\"\"))))","v":""},"% (0-100)"]
[null,null,null,null,"Heating Seasonal Efficiency",{"$f":"IF(Energy_Source=\"Electricity\",ROUND(EFFY_HS_Electric,1),IF(Control_Stages=\"Single Stage\",ROUND(EFFY_HS_SingleStage,1),IF(Control_Stages=\"Two-Stage Modulating\",ROUND(EFFY_HS_TwoStage,1),IF(Control_Stages=\"Step Modulating\",ROUND(EFFY_HS_Modulating,1),\"\"))))","v":""},"% (0-100)"]
[null,"Test Information",null,null,"Annual Fuel Utilization Efficiency",{"$f":"IF(Energy_Source=\"Electricity\",ROUND(AFUE_Electric,1),IF(Control_Stages=\"Single Stage\",ROUND(AFUEONE,1),IF(Control_Stages=\"Two-Stage Modulating\",ROUND(AFUETWO,1),IF(Control_Stages=\"Step Modulating\",ROUND(AFUEMOD,1),\"\"))))","v":""},"% (0-100)"]
[null,"Date Test Started:","[MM/DD/YYYY]"]
[null,"Date Test Finished:","[MM/DD/YYYY]"]
[]
[null,"Product Information"]
[null,"Brand: ",null,null,"NOTE: This is only a copy; sign off is done in the Report Sign-Off Block tab"]
[null,"Manufacturer: ",null,null,"Test Report Sign-Off Block "]
[null,"Manufacturer model number: ",null,null,"We certify that the information and data in this report: (1) were obtained from the specific test unit under test; (2) were obtained during the specific test being reported; (3) were not copied from any other source, except where instructed to do so; and (4) were not altered or modified in any way. "]
[null,"Serial number: "]
[null,"Date of Manufacture (if available):","[MM/DD/YYYY]"]
[null,"Date Product Received:","[MM/DD/YYYY]",null,"Role",null,"Date","Entity"]
[null,"Test Performed by (name):",null,null,"Test Completion",null,{"$f":"'Report Sign-Off Block'!D15","v":"[MM/DD/YYYY]"},{"$f":"IF('Report Sign-Off Block'!E15<>0,'Report Sign-Off Block'!E15,\"\")","v":"[Test Lab Name]"}]
[null,"Test Start Date:","[MM/DD/YYYY]",null,"Template Completion",null,{"$f":"'Report Sign-Off Block'!D16","v":"[MM/DD/YYYY]"},{"$f":"IF('Report Sign-Off Block'!E16<>0,'Report Sign-Off Block'!E16,\"\")","v":"[Test Lab Name]"}]
[null,"Condition as received:",null,null,"Report Review by Test Lab",null,{"$f":"'Report Sign-Off Block'!D17","v":"[MM/DD/YYYY]"},{"$f":"IF('Report Sign-Off Block'!E17<>0,'Report Sign-Off Block'!E17,\"\")","v":"[Test Lab Name]"}]
[null,"Nameplate Voltage (V):",null,null,"Report Review by Test Lab",null,{"$f":"'Report Sign-Off Block'!D18","v":"[MM/DD/YYYY]"},{"$f":"IF('Report Sign-Off Block'!E18<>0,'Report Sign-Off Block'!E18,\"\")","v":"[Test Lab Name]"}]
[null,"Nameplate Maximum Input (Btu/h):"]
[null,"Nameplate Reduced Input (Btu/h):"]
[null,"Nameplate Maximum Temperature Rise (°F)"]
[null,"Namplate Minimum Temperature Rise (°F)"]
[null,"Nameplate Delivered Airflow (SCFM)"]
[null,"Outer Dimensions (in):"]
[null,"     Height"]
[null,"     Width"]
[null,"     Depth"]
[]
[null,"Product Characteristics"]
[null,"Heating Medium:"]
[null,"Circulation Type:"]
[null,"Heating Energy Source:",{"$f":"IF(Fuel_Type=\"Electric\",\"Electricity\",IF(OR(Fuel_Type=\"No. 1 Oil\",Fuel_Type=\"No. 2 Oil\"),\"Oil\",IF(Fuel_Type=\"\",\"\",\"Gas\")))","v":""}]
[null,"Specific Fuel Type:"]
[null,"Burner Type:"]
[null,"Ignition Type:"]
[null,"Installation Location:"]
[null,"Mobile Home Product:"]
[null,"Paried with Cooling Coil:"]
[null,"Tested with Filter:"]
[null,"Inlet Air Source:"]
[null,"Draft Equipment:"]
[null,"Off Cycle Devices:"]
[null,"Flue Gas Type:"]
[null,"Control Type:"]
[null,"System Number:"]
[null,"Calculation Method:",{"$f":"IFERROR(\nIF(AND(Condensing_Flue=\"Non-Condensing\",Control_Stages=\"Single Stage\"),\"ASHRAE 103 § 11.2\",\nIF(AND(Condensing_Flue=\"Condensing\",Control_Stages=\"Single Stage\"),\"ASHRAE 103 § 11.3\",\nIF(AND(Condensing_Flue=\"Non-Condensing\",OR(Control_Stages=\"Two-Stage Modulating\",Control_Stages=\"Step Modulating\")),\"ASHRAE 103 § 11.4\",\nIF(AND(Condensing_Flue=\"Condensing\",OR(Control_Stages=\"Two-Stage Modulating\",Control_Stages=\"Step Modulating\")),\"ASHRAE 103 § 11.5\",\"\")))),\"\")","v":""}]
[null,"Reduced Test Required?",{"$f":"IF(Control_Stages=\"\",\"\",IF(OR(Control_Stages=\"Two-Stage Modulating\",Control_Stages=\"Step Modulating\"),\"Yes\",\"No\"))","v":""}]

{"sheet":"Instrumentation","index":5,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[34,1,37,7],[40,1,44,7],[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Instrumentation"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Setup (This table should include instrumentation, sensors, and all equipment used during testing)"]
[null,"Instrument Type","Brand","Model #","Sensor Location","Accuracy","Date of Last Calibration","Deadline for Next Calibration"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Describe placement of thermocouple grid:"]
[]
[]
[]
[]
[]
[null,"If additional sensors were used, describe placement:"]

{"sheet":"Test Conditions","index":6,"n_rows":85,"n_cols":7,"rows_kept":85,"cut":false,"hidden":false,"merged":[[1,1,1,2],[63,1,63,4],[11,1,11,3],[55,1,55,3],[32,1,32,2],[25,1,25,3],[47,1,47,2],[17,1,17,3],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,3],[22,1,22,2],[23,1,23,2],[42,1,42,2],[44,1,44,2],[43,1,43,2],[24,1,24,2],[39,1,39,3],[40,1,40,2],[41,1,41,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Test Conditions"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"1. Gas Supply Characteristics"]
[null,"Gas Pressure - Maintain gas supply pressure between the normal and increased values shown in Table 1 of ASHRAE 103"]
[null,null,"Normal","Increased"]
[null,"Required Test Pressure Range (in. water)",{"$f":"IFERROR(INDEX(Table1_Test_Gases[Normal Test Pressure (in. Water)],MATCH(Fuel_Type,Table1_Test_Gases[Type],0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Table1_Test_Gases[Increased Test Pressure (in. Water)],MATCH(Fuel_Type,Table1_Test_Gases[Type],0)),\"\")","v":""}]
[null,null,"Maximum Test","Reduced Test"]
[null,"Measured Test Pressure (in. water)"]
[null,"Condition Met?",{"$f":"IF(C16=\"\",\"\",IF(AND(C16>=C14,C16<=D14),\"Yes\",\"No\"))","v":""},{"$f":"IF(D16=\"\",\"\",IF(AND(D16>=C14,D16<=D14),\"Yes\",\"No\"))","v":""}]
[null,"Higher Heating Value - Use a gas having a higher heating value withing +/- 5% of the higher heating value shown in Table 1 of ASHRAE 103-1993. Determine the actual Higher Heating Value (HHV) in Btu per lb for  the gas to be used in the test with an error no greater than 1%"]
[null,"Required HHV (Btu/ft3)",null,{"$f":"INDEX(Table7_Fuel_Characteristics[HHVA],MATCH(Fuel_Type,Table7_Fuel_Characteristics[Fuel],0))","v":{"$error":"#N/A"}}]
[null,"Measured HHV (Btu/ft3)"]
[null,"Condition Met?",null,{"$f":"IF(HHV=\"\",\"\",IF(ISNUMBER(D19),IF(ABS(D19-HHV)/D19<=0.05,\"Yes\",\"No\"),\"Select Gas Type\"))","v":""}]
[null,"Specific Graviy - Use a gas having a specific gravity as shown in Table 1 of ASHRAE 103-1993."]
[null,"Required specific gravity (Air = 1)",null,{"$f":"INDEX(Table1_Test_Gases[Sp. Gr. (Air = 1)],MATCH(Fuel_Type,Table1_Test_Gases[Type],0))","v":{"$error":"#N/A"}}]
[null,"Measured specific gravity"]
[null,"Condition Met?",null,{"$f":"IF(ISBLANK(D24),\"\",IF(D23=D24,\"Yes\",\"No\"))","v":""}]
[null,"Input Rate - Adjust burner to the maximum Btu input rating at the normal test pressure. Correct the burner input rate to reflect gas characteristics at a temeprateur of 60 °F and atmospheric pressure of 30 in of Hg and adjust down to within ± 2% of the hourly Btu nameplate input rating specified by the manufacturer. For gas-fired furnaces equipped with modulating-type controls, adjust the controls to operate the unit at the nameplate minimum input rate. If the modulating control is of  a  non-automatic type, adjust the control to the setting recommended in the I&O manual. In the absence of such recommendation, the midpoint setting of the non-automatic control shall be used as the setting for determining the reduced fuel input rate. "]
[null,null,"Maximum Test","Reduced Test"]
[null,"Nameplate Rate (Btu/h)",{"$f":"Heating_Input","v":0},{"$f":"Reduced_Heating_Input","v":0}]
[null,"Measured Rate (Btu/h)"]
[null,"Condition Met?",{"$f":"IF(C29=\"\",\"\",IF(ABS(C28-C29)/C28<=0.02,\"Yes\",\"No\"))","v":""},{"$f":"IF(D29=\"\",\"\",IF(ABS(D28-D29)/D28<=0.02,\"Yes\",\"No\"))","v":""}]
[]
[null,"2. Input Voltage"]
[null,"Maintain the electrical supply to an auxiliary electric component of a furnace within 1 % of the nameplate voltage for the duration of the test. If a dual voltage is used for nameplate voltage, maintain the electrical supply within 1% of the higher voltage."]
[null,"Nameplate Voltage (V)",{"$f":"IF(Voltage=\"\",\"\",Voltage)","v":""}]
[null,"Minimum Voltage (V)"]
[null,"Maximum Voltage (V)"]
[null,"Condition Met?",{"$f":"IF(OR(C35=\"\",C36=\"\"),\"\",IF(AND(ABS(C34-C35)/C34<=0.01,ABS(C34-C36)/C34<=0.01),\"Yes\",\"No\"))","v":""}]
[]
[null,"3. Air Throughput"]
[null,"Adjust air throughputs to achieve a temperature rise that is the higher of (a) and (b), unless (c) applies. A tolerance of +/- 2 °F is permited. \n(a) 15  °F less than the nameplate maximum temperature rise in the I&O manual or \n(b) 15 °F  higher than the minimum temperature rise in the I&O manual. \n(c) a furnace with a non-adustable air temperature rise range and an automatically controlled airflow that does not permit a temperature rise range of 30  °F or more must be tested at the midpoint of the rise range."]
[null,"Nameplate Maximum Temperature Rise (°F)",null,{"$f":"IF(TempRise_Max_Nameplate=0,\"\",TempRise_Max_Nameplate)","v":""}]
[null,"Nameplate Minimum Temperature Rise  (°F)",null,{"$f":"IF(TempRise_Min_Nameplate=0,\"\",TempRise_Min_Nameplate)","v":""}]
[null,"Temperature Rise Adjustable? (Yes/No)"]
[null,"Measured Temperature Rise  (°F)"]
[null,"Condition Met?",null,{"$f":"IF(ISBLANK(D44),\"\",IF(D43=\"No\",IF(AND(D44<=AVERAGE(D41,D42)+2,D44>=AVERAGE(D41,D42)-2),\"Yes\",\"No\"),IF((D41-15)>=(D42+15),IF(AND((D41-13)>=D44,(D41-17)<=D44),\"Yes\",\"No\"),IF(AND((D42+13)<=D44,(D42+17)>=D44),\"Yes\",\"No\"))))","v":""}]
[]
[null,"4. Static Pressure"]
[null,"The air temperature rise must be established by adjusting the circulating ariflow by symmetrically restricting the outlet air duct and varying the blower speed selction to obtain the desired temeprature rise and minmum external static pressure as specified in Table 4 of ASHRAE 103-1993.  (Note, if the required temperature rise cannot be obtained at the minimum specified external static pressure by adjusting blower speed selection and duct outlet restriction, make adjustments specified in section 7.7 of App. N)"]
[null,"Condition","Maximum Test ESP"]
[null,"Static Pressure Adjustment (in. water)\nFor Oil & Gas Furnaces: ASHRAE 103-1993 § 8.4.2.1.3\nFor Electrical Furnaces: ASHRAE 103-1993 § 8.4.2.4",{"$f":"IF(AND(Energy_Source=\"Electricity\",Filter=\"No\",Cooling_Coil=\"Intended for Pairing with External Cooling Coil\"),0.38,\nIF(AND(Energy_Source=\"Electricity\",Filter=\"Yes\",Cooling_Coil=\"Intended for Pairing with External Cooling Coil\"),0.3,\nIF(AND(Energy_Source=\"Electricity\",Filter=\"No\"),0.08,\nIF(AND(Energy_Source<>\"Electricity\",Cooling_Coil=\"Combination Unit with Included Cooling Coil\"),0.05,0))))","v":0}]
[null,"Required Static Pressure (in. water)",{"$f":"$C$50+IF(Energy_Source=\"Gas\",\nINDEX(Table4_ESP_Reqs_Gas_Oil[Gas Furnace],MATCH(1,(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[Low])*(Heating_Input<=Table4_ESP_Reqs_Gas_Oil[High]),0)),\n\nIF(AND(Energy_Source=\"Oil\",TempRise_Measured<=65),\nINDEX(Table4_ESP_Reqs_Gas_Oil[Oil Furnace with a Temperature Rise Less Than or Equal to 65F],MATCH(1,(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[Low])*(Heating_Input<=Table4_ESP_Reqs_Gas_Oil[High]),0)),\n\nIF(AND(Energy_Source=\"Oil\",TempRise_Measured>65),\nINDEX(Table4_ESP_Reqs_Gas_Oil[Oil Furnace with a Temperature Rise Greater Than 65F],MATCH(1,(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[Low])*(Heating_Input<=Table4_ESP_Reqs_Gas_Oil[High]),0)),\n\nIF(AND(Energy_Source=\"Electricity\", Cooling_Coil=\"None\"),\nINDEX(Table5_ESP_Reqs_Electric[Minimum ESP, in. water],MATCH(1,(SCFM_Nameplate>=Table5_ESP_Reqs_Electric[Minimum Standard Air Quantity, SCFM])*(SCFM_Nameplate<=Table5_ESP_Reqs_Electric[Maximum Standard Air Quantity, SCFM]),0)),INDEX(Table5_ESP_Reqs_Electric[Minimum ESP, in. water],MATCH(1,(SCFM_Nameplate>=Table5_ESP_Reqs_Electric[Minimum Standard Air Quantity, SCFM])*(SCFM_Nameplate<=Table5_ESP_Reqs_Electric[Maximum Standard Air Quantity, SCFM]),0)+0.3)))))","v":0.12}]
[null,"Measured Static Pressure (in. water)"]
[null,"Condition Met?",{"$f":"IF(C52=\"\",\"\",IF(C52>=ESP_Req_Total,\"Yes\",\"No\"))","v":""}]
[]
[null,"6. Room Temperature Measurement"]
[null,"During test, maintain the room temperature to ±5 °F of the temperature measured at the conclusion of the steady state period.  Room temperature shall not fall below 65 °F or exceed 85 °F."]
[null,null,"Maximum Test","Reduced Test"]
[null,"Average Steady State Temperature (°F)"]
[null,"Maximum Test Temperature (°F)"]
[null,"Minimum Test Temperature (°F)"]
[null,"Condition Met?",{"$f":"IF(OR(C58=\"\",C59=\"\",C60=\"\"),\"\",IF(AND(ABS(C59-C58)<=5,ABS(C58-C60)<=5),\"Yes\",\"No\"))","v":""},{"$f":"IF(OR(D58=\"\",D59=\"\",D60=\"\"),\"\",IF(AND(ABS(D59-D58)<=5,ABS(D58-D60)<=5),\"Yes\",\"No\"))","v":""}]
[]
[null,"7. Jacket Loss Measurement"]
[null,"During test, the temperature differential of the 36-inch square-inch areas is less than 10 °F for temperature up to 100 °F above room temperature and less than 20 °F for temperature more than 100 °F above room temperature."]
[null,"Measurements","Maximum Test","Unit","Variable"]
[null,"Are Surface Temperatures More Than 100 °F Above Room Temperature?",null,"-","-"]
[null,"Maximum Differential (°F)",null,"°F","-"]
[null,"Variation Condition Met?",{"$f":"IF(C67=\"\",\"\",IF(C66=\"No\",IF(C67<10,\"Yes\",\"No\"),IF(C67<20,\"Yes\",\"No\")))","v":""},"-","-"]
[null,"Jacket Loss Factor Determination Method","User Input Value","-","-"]
[null,"Jacket Loss Factor",{"$f":"IF(C69=\"Optional Test\",Lj_Measured*100,\nIF(C69=\"User Input Value\",Lj_User_Input*100,0.01*100))","v":0},"% (0-100)","LJ"]
[]
[null,"8. \"Standby\" and \"Off\" Power Measurement"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Standby Power Measurement\nSee 10 CFR 430 Subpart B Appendix N § 8.11.1",null,"W","PW,SB"]
[null,"Off Mode Power Measurement\nSee 10 CFR 430 Subpart B Appendix N § 8.11.2",null,"W","PW,OFF"]
[]
[null,"9. Option to Skip Cool-Down and/or Heat-Up Tests"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Is this an electric furnace? If so, skip both tests",{"$f":"IF(Energy_Source=\"Electricity\",\"Yes\",\"No\")","v":"No"},{"$f":"\"-\"","v":"-"}]
[null,"Is furnace installed with stack damper? If yes, skip cool-down test",{"$f":"IF(Off_Cycle_Device=\"Stack Damper\",\"Yes\",\"No\")","v":"No"}]
[null,"Is this a modulating-control furnace with a balance point temperature < 5°F ? If yes, skip heat-up test",{"$f":"IFERROR(IF(AND(Control_Stages=\"Step-Modulating\",T_C<5),\"Yes\",\"No\"),\"\")","v":""}]
[null,"Is post purge time <5 seconds? AND Was optional tracer gas test performed that indicates no flow through the combustion chamber and heat exchanger when the burner is off?",null,"-","-"]
[null,"If the answer to the two above questions is \"Yes\" for both, the cool-down test for determining draft factors is not required",{"$f":"IF($C$82=\"Yes\",\"Yes\",\"No\")","v":"No"},{"$f":"\"-\"","v":"-"}]
[null,"Can cool-down test be skipped entirely?",{"$f":"IF(OR($C$79=\"Yes\",$C$80=\"Yes\",$C$83=\"Yes\"),\"Yes\",\"No\")","v":"No"}]
[null,"Can heat-up test be skipped entirely?",{"$f":"IFERROR(IF(OR($C$79=\"Yes\",$C$81=\"Yes\"),\"Yes\",\"No\"),\"\")","v":"No"}]

{"sheet":"Max Test","index":7,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[[11,1,11,2],[66,1,66,4],[28,1,28,4],[1,1,1,2],[20,1,20,2],[52,1,52,4]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Max Test"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Steady State Temperature Requirement - ASHRAE 103 § 9.1.2"]
[null,"Operate the burner and the circulation air blower or water pump until steady-state conditions are attained."]
[null,"Time (Minutes)",{"$f":"IF(Draft_Equipment=\"Integral Draft Diverters\",\"Stack Gas Temperature (°F)\",\"Flue Gas Temperature (°F)\")","v":"Flue Gas Temperature (°F)"}]
[null,0]
[null,15]
[null,30]
[null,"Steady State Condition Met?",{"$f":"IF(Condensing_Flue=\"Condensing\", IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=1, \"Yes\", \"No\"), IF(Draft_Equipment=\"Integral Draft Diverter\", IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=3, \"Yes\", \"No\"), IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=5, \"Yes\", \"No\")))","v":"Yes"}]
[null,{"$f":"IF(Draft_Equipment=\"Integral Draft Diverters\", \"Steady State Stack Gas Temperature\", \"Steady State Flue Gas Temperature\")","v":"Steady State Flue Gas Temperature"},{"$f":"IF(ISERROR(AVERAGE(C14:C16)),\"\", AVERAGE(C14:C16))","v":""},"°F",{"$f":"IF(Draft_Equipment=\"Integral Draft Diverters\",\"T_S,ss\",\"T_F,ss\")","v":"T_F,ss"}]
[]
[null,"Steady State Temperature Requirement - ASHRAE 103 § 9.1.2"]
[null,"Operate the burner and the circulation air blower or water pump until steady-state conditions are attained."]
[null,"Time (Minutes)","Rated Power Input (W)"]
[null,25]
[null,35]
[null,45]
[null,"Rated Power Input",{"$f":"IF(ISERROR(AVERAGE(C23:C25)),\"\", AVERAGE(C23:C25))","v":""},"Watts","Ein"]
[]
[null,"Steady State Conditions"]
[null,"Measure and record the steady-state fuel input rate, including pilot gas, corrected to standard conditions of 60F and 30 in HG. Use measured values of gas temperature and pressure at the meter and barometric pressure to correct the metered gas flow rate to the above standard conditions.  Measure the steady-state electric power to the burner (PE) on units so equipped, and measure the steady-state electrical power to the conditioned air blowers (BE). For burners equipped with an interrupted ignition device repord the nameplate electric power used by the ignition device (PEIG), or record that PEIG = 0.4 kW if no nameplate power input is provided. Record the nameplate ignition device on-time interval, tIG, or, if the nameplate does not provide the ignition device on-time interval, measure the on-time interval with a stopwatch at the beginning of the test, starting when the burner is turned on. Set tIG = 0 and PEIG = 0 if the device on-time interval is less than or equal to 5 seconds after the burner is on."]
[null,"Measurements","Value","Unit","Variable"]
[null,"Nameplate Gas or Oil Input Rate",{"$f":"IF(Heating_Input=\"\",\"\",Heating_Input)","v":""},"Btu/h","Qin"]
[null,"Steady State Electrical Power to Burner (all electrical power related to burner operation, including ignition device if operating, gas valve, and draft inducer)",null,"kW","PE"]
[null,"Steady State Electrical Power to Conditioned Air Blowers",null,"kW","BE"]
[null,"Electrical Power Input to Interrupted Ignition Device",null,"kW","PEIG"]
[null,"Nameplate Ignition Device On-time Interval",null,"s","tIG"]
[null,"Room Temperature",null,"°F","TRA"]
[null,"Concentration by Volume of CO2 Present in the Dry Flue Gas",null,"% ","XCO2F"]
[null,"Concentration by Volume of CO2 Present in the Dry Stack Gas",null,"% ","XCO2S"]
[]
[null,"Measurement of Steady-State Condensate"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Steady-State Condensate Collection",null,"%","-"]
[null,"Humidity Condition Met?",{"$f":"IF(Max_Test_Humidity=\"\",\"\",IF(Max_Test_Humidity>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Fuel Higher Heating Value",{"$f":"IF('Test Conditions'!D20=\"\", \"\",'Test Conditions'!D20)","v":""},"Btu/ft3","HHV"]
[null,"Fuel Energy Input During Steady State Condensate Collection Period",null,"Btu","QC,SS"]
[null,"Total Container and Condensate Weight",null,"lb","-"]
[null,"Tare Container Weight",null,"lb","-"]
[null,"Mass of Condensate Collected During Steady State Condensate Collection Period",{"$f":"IF(C46-C47=0,\"\",C46-C47)","v":""},"lb","MC,SS"]
[]
[]
[]
[null,"Flue Temperature Measurements Cool-Down Test - Do not conduct for units with stack damper"]
[null,"Keep the main bumer(s) off until equilibrium conditions are attained, as indicated by variations in the flue gas temperature of not more than 3°F between three successive readings taken 15 minutes apart. For units employing a continuously burning pilot light and not employing a stack damper, take a third flue gas temperature measurement and determine the off-period minimum flue gas temperature (TF,oF1/J5)). For units not employing a continuously burning pilot light, set (TF,OF~t5)) equal to the room temperature, TRA. During the cool-down test, measure the energy input rate to the pilot light (Qp),"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Does the Furnace Employ A Post Purge?"]
[null,"Post Purge Time (Enter 0 if less than or equal to 30 seconds and 180 if greater than or equal to 180 seconds)",null,"sec","tp"]
[null,"Temperature at the end of the post-purge period",null,"°F","TF,OFF(tp)"]
[null,"Temperature 1.5 minutes after end of post-purge period",null,"°F","TF,OFF(t3)"]
[null,"Temperature 9 minutes after the end of the post-purge period",null,"°F","TF,OFF(t4)"]
[null,"Off Period Minimum Flue Gas Temperature (Equilibrium)",null,"°F","TF,OFF(t5)"]
[null,"Does the Furnace have adjustable fan control that allows for manual start/stop?",null,{"$f":"\"-\"","v":"-"}]
[null,"If no adjustable fan control, measure the time delay resulting from normal fan operation",null,"min"]
[null,"Time delay between burner shutdown and blower shutdown",{"$f":"IF($C$61=\"No\",$C$62,IF(Condensing_Flue=\"Non-Condensing\",3,IF(Condensing_Flue=\"Condensing\",1.5)))","v":false},"min","t+"]
[null,"Fuel Energy Input Rate to Pilot Light",null,"Btu/h","QP"]
[]
[null,"Flue Temperature Measurements Heat-up Test"]
[null,"Record the flue gas temperatures during the heat-up test"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Does furnace meet any of the following?:\n(a) Have a single motor that drives both power burner and indoor air blower?\n(b) A time delay of 1.5 minutes would trip the temp-limit switch?\n(c) Have a constant time delay?",null,{"$f":"\"-\"","v":"-"}]
[null,"If yes to any of the above, enter blower start time delay used in test",null,"min"]
[null,"Blower Start Time Delay",{"$f":"IF($C$69=\"Yes\",$C$70,1.5)","v":1.5},"min","t-"]
[null,"Flue Gas Temperature at 0.5 minutes",null,"°F","TF,ON(t1)"]
[null,"Flue Gas Temperature at 2.5 minutes",null,"°F","TF,ON(t2)"]
[]
[null,"Condensate Heat Loss Measurement Under Cyclic Conditions"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Test",null,"% (0-100)","-"]
[null,"Humidity Condition Met?",{"$f":"IF(C77=\"\",\"\",IF(C77>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Flue Gas Temperature (Cycle 1)",null,"°F","-"]
[null,"Flue Gas Temperature (Cycle 2)",null,"°F","-"]
[null,"Flue Gas Temperature Condition Met?",{"$f":"IF(OR(C79=\"\",C80=\"\"),\"\", IF(ABS(C79-C80)<5,\"Yes\",\"No\"))","v":""},"-","-"]
[null,"Room Air Temperature",null,"°F","-"]
[null,"Fuel Higher Heating Value",null,"Btu/lb","HHV"]
[null,"Fuel Energy Input During Cycle 1",null,"Btu","QC1"]
[null,"Mass of Condensate Cycle 1",null,"lb","MC1"]
[null,"Fuel Energy Input During Cycle 2",null,"Btu","QC2"]
[null,"Mass of Condensate Cycle 2",null,"lb","MC2"]
[null,"Fuel Energy Input During Cycle 3",null,"Btu","QC3"]
[null,"Mass of Condensate Cycle 3",null,"lb","MC3"]
[null,"Condensate Mass Condition Met?",{"$f":"IF(OR(C85=\"\",C87=\"\",C89=\"\"),\"\",IF(_xlfn.STDEV.S(C85,C87,C89)<(0.2*AVERAGE(C85,C87,C89)),\"Yes\",\"No Conduct 3 More Cycles\"))","v":""},"-","-"]
[null,"Fuel Energy Input During Cycle 4",null,"Btu","QC4"]
[null,"Mass of Condensate Cycle 4",null,"lb","MC4"]
[null,"Fuel Energy Input During Cycle 5",null,"Btu","QC5"]
[null,"Mass of Condensate Cycle 5",null,"lb","MC5"]
[null,"Fuel Energy Input During Cycle 6",null,"Btu","QC6"]
[null,"Mass of Condensate Cycle 6",null,"lb","MC6"]
[null,"Fuel Energy Input",{"$f":"IF(SUM(C84,C86,C88,C91,C93,C95)=0,\"\",SUM(C84,C86,C88,C91,C93,C95))","v":""},"Btu","QC"]
[null,"Total Condensate Collected",{"$f":"IF(SUM(C85,C87,C89,C92,C94,C96)=0,\"\",SUM(C85,C87,C89,C92,C94,C96))","v":""},"lb","MC"]

{"sheet":"Reduced Test","index":8,"n_rows":96,"n_cols":6,"rows_kept":96,"cut":false,"hidden":false,"merged":[[28,1,28,4],[64,1,64,4],[1,1,1,2],[20,1,20,2],[50,1,50,4]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Reduced Test"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Steady State Temperature Requirement"]
[null,"Operate the burner and the circulation air blower or water pump until steady-state conditions are attained."]
[null,"Time (Minutes)","Flue Gas Temperature (°F)"]
[null,0,277.5]
[null,15,277.5]
[null,30,277.5]
[null,"Steady State Condition Met?",{"$f":"IF(Condensing_Flue=\"Condensing\", IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=1, \"Yes\", \"No\"), IF(Draft_Equipment=\"Integral Draft Diverter\", IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=3, \"Yes\", \"No\"), IF(MAX($C$14:$C$16)-MIN($C$14:$C$16)<=5, \"Yes\", \"No\")))","v":"Yes"}]
[null,{"$f":"IF(Draft_Equipment=\"Integral Draft Diverters\", \"Steady State Stack Gas Temperature\", \"Steady State Flue Gas Temperature\")","v":"Steady State Flue Gas Temperature"},{"$f":"IF(ISERROR(AVERAGE(C14:C16)),\"\", AVERAGE(C14:C16))","v":277.5},"°F",{"$f":"IF(Draft_Equipment=\"Integral Draft Diverters\",\"T_s,ss\",\"T_F,ss\")","v":"T_F,ss"}]
[]
[null,"Steady State Temperature Requirement - ASHRAE 103 § 9.1.2"]
[null,"Operate the burner and the circulation air blower or water pump until steady-state conditions are attained."]
[null,"Time (Minutes)","Power Input (W)"]
[null,25]
[null,35]
[null,45]
[null,"Rated Power Input",{"$f":"IF(ISERROR(AVERAGE(C23:C25)),\"\", AVERAGE(C23:C25))","v":""},"Watts","Ein"]
[]
[null,"Steady State Conditions"]
[null,"Measure and record the steady-state gas input rate, including pilot gas, corrected to standard conditions of 60F and 30 in HG. Use measured values of gas temperature and pressure at the meter and barometric pressure to correct the metered gas flow rate to the above standard conditions.  Measure the steady-state electric power to the burner (PE) on units so equipped, and measure the steady-state electrical power to the conditioned air blowers (BE)"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Nameplate Gas Input Rate",{"$f":"IF(Reduced_Heating_Input=\"\",\"\",Reduced_Heating_Input)","v":""},"Btu/h","Heating_Input"]
[null,"Steady State Electrical Power to Burner (all electrical power related to burner operation, including ignition device if operating, gas valve, and draft inducer)",6.8000000000000005E-2,"kW","PE"]
[null,"Steady State Electrical Power to Conditioned Air Blowers",0.436,"kW","BE"]
[null,"Room Temperature",69.599999999999994,"°F","TRA"]
[null,"Concentration by Volume of CO2 Present in the Dry Flue Gas",5.41,"% ","XCO2F"]
[null,"Concentration by Volume of CO2 Present in the Dry Stack Gas",null,"% ","XCO2S"]
[]
[null,"Measurement of Steady-State Condensate"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Steady-State Condensate Collection",null,"% (0-100)","-"]
[null,"Humidity Condition Met?",{"$f":"IF(C40=\"\",\"\",IF(C40>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Fuel Higher Heating Value",{"$f":"IF('Test Conditions'!D20=\"\", \"\",'Test Conditions'!D20)","v":""},"Btu/lb","HHV"]
[null,"Fuel Energy Input During Steady State Condesnate Collection Period",null,"Btu","QC,SS"]
[null,"Total Container and Condensate Weight",null,"lb","-"]
[null,"Tare Container Weight",null,"lb","-"]
[null,"Mass of Condensate Collected During Steady State Condensate Collection Period",{"$f":"IF(C44-C45=0,\"\",C44-C45)","v":""},"lb","MC,SS"]
[]
[]
[]
[null,"Flue Temperature Measurements Cool-Down Test"]
[null,"Keep the main bumer(s) off until equilibrium conditions are attained, as indicated by variations in the flue gas temperature of not more than 3°F between three successive readings taken 15 minutes apart. For units employing a continuously burning pilot light and not employing a stack damper, take a third flue gas temperature measurement and determine the off-period minimum flue gas temperature (TF,oF1/J5)). For units not employing a continuously burning pilot light, set (TF,OF~t5)) equal to the room temperature, TRA. During the cool-down test, measure the energy input rate to the pilot light (Qp),"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Does the Furnace Employ A Post Purge?"]
[null,"Post Purge Time (Enter 0 if less than or equal to 30 seconds and 180 if greater than or equal to 180 seconds)",null,"sec","tp"]
[null,"Temperature at the end of the post-purge period",null,"°F","TF,OFF(tP)"]
[null,"Temperature 1.5 minutes after end of post-purge period",null,"°F","TF,OFF(t3)"]
[null,"Temperature 9 minutes after the end of the post-purge period",null,"°F","TF,OFF(t4)"]
[null,"Off Period Minimum Flue Gas Temperature (Equilibrium)",null,"°F","TF,OFF(t5)"]
[null,"Does the Furnace have adjustable fan control that allows for manual start/stop?"]
[null,"If no adjustable fan control, measure the time delay resulting from normal fan operation"]
[null,"Time delay between burner shutdown and blower shutdown",{"$f":"IF($C$59=\"No\",$C$60,IF(Condensing_Flue=\"Non-Condensing\",3,IF(Condensing_Flue=\"Condensing\",1.5)))","v":false},"min","t+"]
[null,"Fuel Energy Input Rate to Pilot Light",0,"Btu/h","QP"]
[]
[null,"Flue Temperature Measurements Heat-up Test"]
[null,"Record the flue gas temperatures during the heat-up test"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Does furnace meet any of the following?:\n(a) Have a single motor that drives both power burner and indoor air blower?\n(b) A time delay of 1.5 minutes would trip the temp-limit switch?\n(c) Have a constant time delay?",null,{"$f":"\"-\"","v":"-"}]
[null,"If yes to any of the above, enter blower start time delay used in test",null,"min"]
[null,"Blower Start Time Delay",{"$f":"IF($C$67=\"Yes\",$C$68,1.5)","v":1.5},"min","t-"]
[null,"Flue Gas Temperature at 0.5 minutes",null,"°F","TF,ON(t1)"]
[null,"Flue Gas Temperature at 2.5 minutes",null,"°F","TF,ON(t2)"]
[]
[null,"Condensate Heat Loss Measurement Under Cyclic Conditions"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Test",null,"% (0-100)","-"]
[null,"Humidity Condition Met?",{"$f":"IF(C75=\"\",\"\",IF(C75>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Flue Gas Temperature at end of On-cycle (Cycle 1)",null,"°F","-"]
[null,"Flue Gas Temperature at end of On-cycle (Cycle 2)",null,"°F","-"]
[null,"Flue Gas Temperature Condition Met?",{"$f":"IF(OR(C77=\"\",C78=\"\"),\"\", IF(ABS(C77-C78)<5,\"Yes\",\"No\"))","v":""},"-","-"]
[null,"Room Air Temperature",null,"°F","-"]
[null,"Fuel Higher Heating Value",null,"Btu/lb","HHV"]
[null,"Fuel Energy Input During Cycle 1",null,"Btu","QC1"]
[null,"Mass of Condensate Cycle 1",null,"lb","MC1"]
[null,"Fuel Energy Input During Cycle 2",null,"Btu","QC2"]
[null,"Mass of Condensate Cycle 2",null,"lb","MC2"]
[null,"Fuel Energy Input During Cycle 3",null,"Btu","QC3"]
[null,"Mass of Condensate Cycle 3",null,"lb","MC3"]
[null,"Condensate Mass Condition Met?",{"$f":"IF(OR(C83=\"\",C85=\"\",C87=\"\"),\"\",IF(_xlfn.STDEV.S(C83,C85,C87)<(0.2*AVERAGE(C83,C85,C87)),\"Yes\",\"No Conduct 3 more cycles\"))","v":""},"-","-"]
[null,"Fuel Energy Input During Cycle 4",null,"Btu","QC4"]
[null,"Mass of Condensate Cycle 4",null,"lb","MC4"]
[null,"Fuel Energy Input During Cycle 5",null,"Btu","QC5"]
[null,"Mass of Condensate Cycle 5",null,"lb","MC5"]
[null,"Fuel Energy Input During Cycle 6",null,"Btu","QC6"]
[null,"Mass of Condensate Cycle 6",null,"lb","MC6"]
[null,"Fuel Energy Input",{"$f":"IF(SUM(C82,C84,C86,C89,C91,C93)=0,\"\",SUM(C82,C84,C86,C89,C91,C93))","v":""},"Btu","QC"]
[null,"Total Condensate Collected",{"$f":"IF(SUM(C83,C85,C87,C90,C92,C94)=0,\"\",SUM(C83,C85,C87,C90,C92,C94))","v":""},"lb","MC"]

{"sheet":"Optional Jacket Loss Test","index":9,"n_rows":337,"n_cols":10,"rows_kept":337,"cut":false,"hidden":false,"merged":[[336,1,336,8],[336,9,336,10],[3,9,3,10],[333,1,333,2],[333,3,333,4],[333,5,333,6],[333,7,333,8],[333,9,333,10],[334,1,334,2],[334,3,334,4],[334,5,334,6],[334,7,334,8],[334,9,334,10],[331,1,331,2],[331,3,331,4],[331,5,331,6],[331,7,331,8],[331,9,331,10],[332,1,332,2],[332,3,332,4],[332,5,332,6],[332,7,332,8],[332,9,332,10],[329,1,329,2],[329,3,329,4],[329,5,329,6],[329,7,329,8],[329,9,329,10],[330,1,330,2],[330,3,330,4],[330,5,330,6],[330,7,330,8],[330,9,330,10],[327,1,327,2],[327,3,327,4],[327,5,327,6],[327,7,327,8],[327,9,327,10],[328,1,328,2],[328,3,328,4],[328,5,328,6],[328,7,328,8],[328,9,328,10],[325,1,325,2],[325,3,325,4],[325,5,325,6],[325,7,325,8],[325,9,325,10],[326,1,326,2],[326,3,326,4],[326,5,326,6],[326,7,326,8],[326,9,326,10],[323,1,323,2],[323,3,323,4],[323,5,323,6],[323,7,323,8],[323,9,323,10],[324,1,324,2],[324,3,324,4],[324,5,324,6],[324,7,324,8],[324,9,324,10],[321,1,321,2],[321,3,321,4],[321,5,321,6],[321,7,321,8],[321,9,321,10],[322,1,322,2],[322,3,322,4],[322,5,322,6],[322,7,322,8],[322,9,322,10],[319,1,319,2],[319,3,319,4],[319,5,319,6],[319,7,319,8],[319,9,319,10],[320,1,320,2],[320,3,320,4],[320,5,320,6],[320,7,320,8],[320,9,320,10],[317,1,317,2],[317,3,317,4],[317,5,317,6],[317,7,317,8],[317,9,317,10],[318,1,318,2],[318,3,318,4],[318,5,318,6],[318,7,318,8],[318,9,318,10],[315,1,315,2],[315,3,315,4],[315,5,315,6],[315,7,315,8],[315,9,315,10],[316,1,316,2],[316,3,316,4],[316,5,316,6],[316,7,316,8],[316,9,316,10],[313,1,313,2],[313,3,313,4],[313,5,313,6],[313,7,313,8],[313,9,313,10],[314,1,314,2],[314,3,314,4],[314,5,314,6],[314,7,314,8],[314,9,314,10],[311,1,311,2],[311,3,311,4],[311,5,311,6],[311,7,311,8],[311,9,311,10],[312,1,312,2],[312,3,312,4],[312,5,312,6],[312,7,312,8],[312,9,312,10],[309,1,309,2],[309,3,309,4],[309,5,309,6],[309,7,309,8],[309,9,309,10],[310,1,310,2],[310,3,310,4],[310,5,310,6],[310,7,310,8],[310,9,310,10],[307,1,307,2],[307,3,307,4],[307,5,307,6],[307,7,307,8],[307,9,307,10],[308,1,308,2],[308,3,308,4],[308,5,308,6],[308,7,308,8],[308,9,308,10],[305,1,305,2],[305,3,305,4],[305,5,305,6],[305,7,305,8],[305,9,305,10],[306,1,306,2],[306,3,306,4],[306,5,306,6],[306,7,306,8],[306,9,306,10],[303,1,303,2],[303,3,303,4],[303,5,303,6],[303,7,303,8],[303,9,303,10],[304,1,304,2],[304,3,304,4],[304,5,304,6],[304,7,304,8],[304,9,304,10],[301,1,301,2],[301,3,301,4],[301,5,301,6],[301,7,301,8],[301,9,301,10],[302,1,302,2],[302,3,302,4],[302,5,302,6],[302,7,302,8],[302,9,302,10],[299,1,299,2],[299,3,299,4],[299,5,299,6],[299,7,299,8],[299,9,299,10],[300,1,300,2],[300,3,300,4],[300,5,300,6],[300,7,300,8],[300,9,300,10],[297,1,297,2],[297,3,297,4],[297,5,297,6],[297,7,297,8],[297,9,297,10],[298,1,298,2],[298,3,298,4],[298,5,298,6],[298,7,298,8],[298,9,298,10],[295,1,295,2],[295,3,295,4],[295,5,295,6],[295,7,295,8],[295,9,295,10],[296,1,296,2],[296,3,296,4],[296,5,296,6],[296,7,296,8],[296,9,296,10],[293,1,293,2],[293,3,293,4],[293,5,293,6],[293,7,293,8],[293,9,293,10],[294,1,294,2],[294,3,294,4],[294,5,294,6],[294,7,294,8],[294,9,294,10],[291,1,291,2],[291,3,291,4],[291,5,291,6],[291,7,291,8],[291,9,291,10],[292,1,292,2],[292,3,292,4],[292,5,292,6],[292,7,292,8],[292,9,292,10],[289,1,289,2],[289,3,289,4],[289,5,289,6],[289,7,289,8],[289,9,289,10],[290,1,290,2],[290,3,290,4],[290,5,290,6],[290,7,290,8],[290,9,290,10],[287,1,287,2],[287,3,287,4],[287,5,287,6],[287,7,287,8],[287,9,287,10],[288,1,288,2],[288,3,288,4],[288,5,288,6],[288,7,288,8],[288,9,288,10],[285,1,285,2],[285,3,285,4],[285,5,285,6],[285,7,285,8],[285,9,285,10],[286,1,286,2],[286,3,286,4],[286,5,286,6],[286,7,286,8],[286,9,286,10],[283,1,283,2],[283,3,283,4],[283,5,283,6],[283,7,283,8],[283,9,283,10],[284,1,284,2],[284,3,284,4],[284,5,284,6],[284,7,284,8],[284,9,284,10],[281,1,281,2],[281,3,281,4],[281,5,281,6],[281,7,281,8],[281,9,281,10],[282,1,282,2],[282,3,282,4],[282,5,282,6],[282,7,282,8],[282,9,282,10],[279,1,279,2],[279,3,279,4],[279,5,279,6],[279,7,279,8],[279,9,279,10],[280,1,280,2],[280,3,280,4],[280,5,280,6],[280,7,280,8],[280,9,280,10],[277,1,277,2],[277,3,277,4],[277,5,277,6],[277,7,277,8],[277,9,277,10],[278,1,278,2],[278,3,278,4],[278,5,278,6],[278,7,278,8],[278,9,278,10],[275,1,275,2],[275,3,275,4],[275,5,275,6],[275,7,275,8],[275,9,275,10],[276,1,276,2],[276,3,276,4],[276,5,276,6],[276,7,276,8],[276,9,276,10],[273,1,273,2],[273,3,273,4],[273,5,273,6],[273,7,273,8],[273,9,273,10],[274,1,274,2],[274,3,274,4],[274,5,274,6],[274,7,274,8],[274,9,274,10],[271,1,271,2],[271,3,271,4],[271,5,271,6],[271,7,271,8],[271,9,271,10],[272,1,272,2],[272,3,272,4],[272,5,272,6],[272,7,272,8],[272,9,272,10],[269,1,269,2],[269,3,269,4],[269,5,269,6],[269,7,269,8],[269,9,269,10],[270,1,270,2],[270,3,270,4],[270,5,270,6],[270,7,270,8],[270,9,270,10],[267,1,267,2],[267,3,267,4],[267,5,267,6],[267,7,267,8],[267,9,267,10],[268,1,268,2],[268,3,268,4],[268,5,268,6],[268,7,268,8],[268,9,268,10],[265,1,265,2],[265,3,265,4],[265,5,265,6],[265,7,265,8],[265,9,265,10],[266,1,266,2],[266,3,266,4],[266,5,266,6],[266,7,266,8],[266,9,266,10],[263,1,263,2],[263,3,263,4],[263,5,263,6],[263,7,263,8],[263,9,263,10],[264,1,264,2],[264,3,264,4],[264,5,264,6],[264,7,264,8],[264,9,264,10],[261,1,261,2],[261,3,261,4],[261,5,261,6],[261,7,261,8],[261,9,261,10],[262,1,262,2],[262,3,262,4],[262,5,262,6],[262,7,262,8],[262,9,262,10],[259,1,259,2],[259,3,259,4],[259,5,259,6],[259,7,259,8],[259,9,259,10],[260,1,260,2],[260,3,260,4],[260,5,260,6],[260,7,260,8],[260,9,260,10],[257,1,257,2],[257,3,257,4],[257,5,257,6],[257,7,257,8],[257,9,257,10],[258,1,258,2],[258,3,258,4],[258,5,258,6],[258,7,258,8],[258,9,258,10],[255,1,255,2],[255,3,255,4],[255,5,255,6],[255,7,255,8],[255,9,255,10],[256,1,256,2],[256,3,256,4],[256,5,256,6],[256,7,256,8],[256,9,256,10],[253,1,253,2],[253,3,253,4],[253,5,253,6],[253,7,253,8],[253,9,253,10],[254,1,254,2],[254,3,254,4],[254,5,254,6],[254,7,254,8],[254,9,254,10],[251,1,251,2],[251,3,251,4],[251,5,251,6],[251,7,251,8],[251,9,251,10],[252,1,252,2],[252,3,252,4],[252,5,252,6],[252,7,252,8],[252,9,252,10],[249,1,249,2],[249,3,249,4],[249,5,249,6],[249,7,249,8],[249,9,249,10],[250,1,250,2],[250,3,250,4],[250,5,250,6],[250,7,250,8],[250,9,250,10],[247,1,247,2],[247,3,247,4],[247,5,247,6],[247,7,247,8],[247,9,247,10],[248,1,248,2],[248,3,248,4],[248,5,248,6],[248,7,248,8],[248,9,248,10],[245,1,245,2],[245,3,245,4],[245,5,245,6],[245,7,245,8],[245,9,245,10],[246,1,246,2],[246,3,246,4],[246,5,246,6],[246,7,246,8],[246,9,246,10],[243,1,243,2],[243,3,243,4],[243,5,243,6],[243,7,243,8],[243,9,243,10],[244,1,244,2],[244,3,244,4],[244,5,244,6],[244,7,244,8],[244,9,244,10],[241,1,241,2],[241,3,241,4],[241,5,241,6],[241,7,241,8],[241,9,241,10],[242,1,242,2],[242,3,242,4],[242,5,242,6],[242,7,242,8],[242,9,242,10],[239,1,239,2],[239,3,239,4],[239,5,239,6],[239,7,239,8],[239,9,239,10],[240,1,240,2],[240,3,240,4],[240,5,240,6],[240,7,240,8],[240,9,240,10],[237,1,237,2],[237,3,237,4],[237,5,237,6],[237,7,237,8],[237,9,237,10],[238,1,238,2],[238,3,238,4],[238,5,238,6],[238,7,238,8],[238,9,238,10],[235,1,235,2],[235,3,235,4],[235,5,235,6],[235,7,235,8],[235,9,235,10],[236,1,236,2],[236,3,236,4],[236,5,236,6],[236,7,236,8],[236,9,236,10],[231,1,231,8],[231,9,231,10],[233,3,233,10],[234,1,234,2],[234,3,234,4],[234,5,234,6],[234,7,234,8],[234,9,234,10],[228,1,228,2],[228,3,228,4],[228,5,228,6],[228,7,228,8],[228,9,228,10],[229,1,229,2],[229,3,229,4],[229,5,229,6],[229,7,229,8],[229,9,229,10],[226,1,226,2],[226,3,226,4],[226,5,226,6],[226,7,226,8],[226,9,226,10],[227,1,227,2],[227,3,227,4],[227,5,227,6],[227,7,227,8],[227,9,227,10],[224,1,224,2],[224,3,224,4],[224,5,224,6],[224,7,224,8],[224,9,224,10],[225,1,225,2],[225,3,225,4],[225,5,225,6],[225,7,225,8],[225,9,225,10],[222,1,222,2],[222,3,222,4],[222,5,222,6],[222,7,222,8],[222,9,222,10],[223,1,223,2],[223,3,223,4],[223,5,223,6],[223,7,223,8],[223,9,223,10],[220,1,220,2],[220,3,220,4],[220,5,220,6],[220,7,220,8],[220,9,220,10],[221,1,221,2],[221,3,221,4],[221,5,221,6],[221,7,221,8],[221,9,221,10],[218,1,218,2],[218,3,218,4],[218,5,218,6],[218,7,218,8],[218,9,218,10],[219,1,219,2],[219,3,219,4],[219,5,219,6],[219,7,219,8],[219,9,219,10],[216,1,216,2],[216,3,216,4],[216,5,216,6],[216,7,216,8],[216,9,216,10],[217,1,217,2],[217,3,217,4],[217,5,217,6],[217,7,217,8],[217,9,217,10],[214,1,214,2],[214,3,214,4],[214,5,214,6],[214,7,214,8],[214,9,214,10],[215,1,215,2],[215,3,215,4],[215,5,215,6],[215,7,215,8],[215,9,215,10],[212,1,212,2],[212,3,212,4],[212,5,212,6],[212,7,212,8],[212,9,212,10],[213,1,213,2],[213,3,213,4],[213,5,213,6],[213,7,213,8],[213,9,213,10],[210,1,210,2],[210,3,210,4],[210,5,210,6],[210,7,210,8],[210,9,210,10],[211,1,211,2],[211,3,211,4],[211,5,211,6],[211,7,211,8],[211,9,211,10],[208,1,208,2],[208,3,208,4],[208,5,208,6],[208,7,208,8],[208,9,208,10],[209,1,209,2],[209,3,209,4],[209,5,209,6],[209,7,209,8],[209,9,209,10],[206,1,206,2],[206,3,206,4],[206,5,206,6],[206,7,206,8],[206,9,206,10],[207,1,207,2],[207,3,207,4],[207,5,207,6],[207,7,207,8],[207,9,207,10],[204,1,204,2],[204,3,204,4],[204,5,204,6],[204,7,204,8],[204,9,204,10],[205,1,205,2],[205,3,205,4],[205,5,205,6],[205,7,205,8],[205,9,205,10],[202,1,202,2],[202,3,202,4],[202,5,202,6],[202,7,202,8],[202,9,202,10],[203,1,203,2],[203,3,203,4],[203,5,203,6],[203,7,203,8],[203,9,203,10],[200,1,200,2],[200,3,200,4],[200,5,200,6],[200,7,200,8],[200,9,200,10],[201,1,201,2],[201,3,201,4],[201,5,201,6],[201,7,201,8],[201,9,201,10],[198,1,198,2],[198,3,198,4],[198,5,198,6],[198,7,198,8],[198,9,198,10],[199,1,199,2],[199,3,199,4],[199,5,199,6],[199,7,199,8],[199,9,199,10],[196,1,196,2],[196,3,196,4],[196,5,196,6],[196,7,196,8],[196,9,196,10],[197,1,197,2],[197,3,197,4],[197,5,197,6],[197,7,197,8],[197,9,197,10],[194,1,194,2],[194,3,194,4],[194,5,194,6],[194,7,194,8],[194,9,194,10],[195,1,195,2],[195,3,195,4],[195,5,195,6],[195,7,195,8],[195,9,195,10],[192,1,192,2],[192,3,192,4],[192,5,192,6],[192,7,192,8],[192,9,192,10],[193,1,193,2],[193,3,193,4],[193,5,193,6],[193,7,193,8],[193,9,193,10],[190,1,190,2],[190,3,190,4],[190,5,190,6],[190,7,190,8],[190,9,190,10],[191,1,191,2],[191,3,191,4],[191,5,191,6],[191,7,191,8],[191,9,191,10],[188,1,188,2],[188,3,188,4],[188,5,188,6],[188,7,188,8],[188,9,188,10],[189,1,189,2],[189,3,189,4],[189,5,189,6],[189,7,189,8],[189,9,189,10],[186,1,186,2],[186,3,186,4],[186,5,186,6],[186,7,186,8],[186,9,186,10],[187,1,187,2],[187,3,187,4],[187,5,187,6],[187,7,187,8],[187,9,187,10],[184,1,184,2],[184,3,184,4],[184,5,184,6],[184,7,184,8],[184,9,184,10],[185,1,185,2],[185,3,185,4],[185,5,185,6],[185,7,185,8],[185,9,185,10],[182,1,182,2],[182,3,182,4],[182,5,182,6],[182,7,182,8],[182,9,182,10],[183,1,183,2],[183,3,183,4],[183,5,183,6],[183,7,183,8],[183,9,183,10],[180,1,180,2],[180,3,180,4],[180,5,180,6],[180,7,180,8],[180,9,180,10],[181,1,181,2],[181,3,181,4],[181,5,181,6],[181,7,181,8],[181,9,181,10],[178,1,178,2],[178,3,178,4],[178,5,178,6],[178,7,178,8],[178,9,178,10],[179,1,179,2],[179,3,179,4],[179,5,179,6],[179,7,179,8],[179,9,179,10],[176,1,176,2],[176,3,176,4],[176,5,176,6],[176,7,176,8],[176,9,176,10],[177,1,177,2],[177,3,177,4],[177,5,177,6],[177,7,177,8],[177,9,177,10],[174,1,174,2],[174,3,174,4],[174,5,174,6],[174,7,174,8],[174,9,174,10],[175,1,175,2],[175,3,175,4],[175,5,175,6],[175,7,175,8],[175,9,175,10],[172,1,172,2],[172,3,172,4],[172,5,172,6],[172,7,172,8],[172,9,172,10],[173,1,173,2],[173,3,173,4],[173,5,173,6],[173,7,173,8],[173,9,173,10],[170,1,170,2],[170,3,170,4],[170,5,170,6],[170,7,170,8],[170,9,170,10],[171,1,171,2],[171,3,171,4],[171,5,171,6],[171,7,171,8],[171,9,171,10],[168,1,168,2],[168,3,168,4],[168,5,168,6],[168,7,168,8],[168,9,168,10],[169,1,169,2],[169,3,169,4],[169,5,169,6],[169,7,169,8],[169,9,169,10],[166,1,166,2],[166,3,166,4],[166,5,166,6],[166,7,166,8],[166,9,166,10],[167,1,167,2],[167,3,167,4],[167,5,167,6],[167,7,167,8],[167,9,167,10],[164,1,164,2],[164,3,164,4],[164,5,164,6],[164,7,164,8],[164,9,164,10],[165,1,165,2],[165,3,165,4],[165,5,165,6],[165,7,165,8],[165,9,165,10],[162,1,162,2],[162,3,162,4],[162,5,162,6],[162,7,162,8],[162,9,162,10],[163,1,163,2],[163,3,163,4],[163,5,163,6],[163,7,163,8],[163,9,163,10],[160,1,160,2],[160,3,160,4],[160,5,160,6],[160,7,160,8],[160,9,160,10],[161,1,161,2],[161,3,161,4],[161,5,161,6],[161,7,161,8],[161,9,161,10],[158,1,158,2],[158,3,158,4],[158,5,158,6],[158,7,158,8],[158,9,158,10],[159,1,159,2],[159,3,159,4],[159,5,159,6],[159,7,159,8],[159,9,159,10],[156,1,156,2],[156,3,156,4],[156,5,156,6],[156,7,156,8],[156,9,156,10],[157,1,157,2],[157,3,157,4],[157,5,157,6],[157,7,157,8],[157,9,157,10],[154,1,154,2],[154,3,154,4],[154,5,154,6],[154,7,154,8],[154,9,154,10],[155,1,155,2],[155,3,155,4],[155,5,155,6],[155,7,155,8],[155,9,155,10],[152,1,152,2],[152,3,152,4],[152,5,152,6],[152,7,152,8],[152,9,152,10],[153,1,153,2],[153,3,153,4],[153,5,153,6],[153,7,153,8],[153,9,153,10],[150,1,150,2],[150,3,150,4],[150,5,150,6],[150,7,150,8],[150,9,150,10],[151,1,151,2],[151,3,151,4],[151,5,151,6],[151,7,151,8],[151,9,151,10],[148,1,148,2],[148,3,148,4],[148,5,148,6],[148,7,148,8],[148,9,148,10],[149,1,149,2],[149,3,149,4],[149,5,149,6],[149,7,149,8],[149,9,149,10],[146,1,146,2],[146,3,146,4],[146,5,146,6],[146,7,146,8],[146,9,146,10],[147,1,147,2],[147,3,147,4],[147,5,147,6],[147,7,147,8],[147,9,147,10],[144,1,144,2],[144,3,144,4],[144,5,144,6],[144,7,144,8],[144,9,144,10],[145,1,145,2],[145,3,145,4],[145,5,145,6],[145,7,145,8],[145,9,145,10],[142,1,142,2],[142,3,142,4],[142,5,142,6],[142,7,142,8],[142,9,142,10],[143,1,143,2],[143,3,143,4],[143,5,143,6],[143,7,143,8],[143,9,143,10],[140,1,140,2],[140,3,140,4],[140,5,140,6],[140,7,140,8],[140,9,140,10],[141,1,141,2],[141,3,141,4],[141,5,141,6],[141,7,141,8],[141,9,141,10],[138,1,138,2],[138,3,138,4],[138,5,138,6],[138,7,138,8],[138,9,138,10],[139,1,139,2],[139,3,139,4],[139,5,139,6],[139,7,139,8],[139,9,139,10],[136,1,136,2],[136,3,136,4],[136,5,136,6],[136,7,136,8],[136,9,136,10],[137,1,137,2],[137,3,137,4],[137,5,137,6],[137,7,137,8],[137,9,137,10],[134,1,134,2],[134,3,134,4],[134,5,134,6],[134,7,134,8],[134,9,134,10],[135,1,135,2],[135,3,135,4],[135,5,135,6],[135,7,135,8],[135,9,135,10],[132,1,132,2],[132,3,132,4],[132,5,132,6],[132,7,132,8],[132,9,132,10],[133,1,133,2],[133,3,133,4],[133,5,133,6],[133,7,133,8]],"merged_total":1549,"flags":["merged_cut"]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"},null,null,null,null,null,"User Input Jacket Loss"]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,null,"Calculated Jacket Loss",{"$f":"SUM($J$127,$J$232,$J$337)/Heating_Input","v":{"$error":"#DIV/0!"}}]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Optional Jacket Loss Test"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Jacket Loss Test"]
[null,"For floor furnaces, conduct jacket loss test in accordance with Section 3.2 of CFR Appendix O"]
[]
[]
[null,"Top Coefficient of Convection (hc) (Btu/hr*sqft*F)"]
[null,"Bottom Coefficient of Convection (hc) (Btu/hr*sqft*F)"]
[null,"Side Coefficient of Convection (hc) (Btu/hr*sqft*F)"]
[null,"Coefficient of Radiation, ε=1.0 (hri) (Btu/hr*sqft*F)"]
[null,"Emissivity"]
[null,"Coefficient of Radiation, surface (Hrs) (Btu/hr*sqft*F)",null,null,null,null,null,null,null,{"$f":"$J$18*$J$17","v":0}]
[]
[null,"Room Temperature (°F)"]
[]
[null,null,null,"Top Surface"]
[null,null,null,"Group Area (sq ft)",null,"Surface Temp (°F)",null,"Surface",null,"Area Temp Difference (sq ft * °F)"]
[null,"Area 1",null,null,null,null,null,"Top",null,{"$f":"D26*(F26-$J$22)","v":0}]
[null,"Area 2",null,null,null,null,null,"Top",null,0]
[null,"Area 3",null,null,null,null,null,"Top",null,0]
[null,"Area 4",null,null,null,null,null,"Top",null,0]
[null,"Area 5",null,null,null,null,null,"Top",null,0]
[null,"Area 6",null,null,null,null,null,"Top",null,0]
[null,"Area 7",null,null,null,null,null,"Top",null,0]
[null,"Area 8",null,null,null,null,null,"Top",null,0]
[null,"Area 9",null,null,null,null,null,"Top",null,0]
[null,"Area 10",null,null,null,null,null,"Top",null,0]
[null,"Area 11",null,null,null,null,null,"Top",null,0]
[null,"Area 12",null,null,null,null,null,"Top",null,0]
[null,"Area 13",null,null,null,null,null,"Top",null,0]
[null,"Area 14",null,null,null,null,null,"Top",null,0]
[null,"Area 15",null,null,null,null,null,"Top",null,0]
[null,"Area 16",null,null,null,null,null,"Top",null,0]
[null,"Area 17",null,null,null,null,null,"Top",null,0]
[null,"Area 18",null,null,null,null,null,"Top",null,0]
[null,"Area 19",null,null,null,null,null,"Top",null,0]
[null,"Area 20",null,null,null,null,null,"Top",null,0]
[null,"Area 21",null,null,null,null,null,"Top",null,0]
[null,"Area 22",null,null,null,null,null,"Top",null,0]
[null,"Area 23",null,null,null,null,null,"Top",null,0]
[null,"Area 24",null,null,null,null,null,"Top",null,0]
[null,"Area 25",null,null,null,null,null,"Top",null,0]
[null,"Area 26",null,null,null,null,null,"Top",null,0]
[null,"Area 27",null,null,null,null,null,"Top",null,0]
[null,"Area 28",null,null,null,null,null,"Top",null,0]
[null,"Area 29",null,null,null,null,null,"Top",null,0]
[null,"Area 30",null,null,null,null,null,"Top",null,0]
[null,"Area 31",null,null,null,null,null,"Top",null,0]
[null,"Area 32",null,null,null,null,null,"Top",null,0]
[null,"Area 33",null,null,null,null,null,"Top",null,{"$f":"D58*(F58-$J$22)","v":0}]
[null,"Area 34",null,null,null,null,null,"Top",null,0]
[null,"Area 35",null,null,null,null,null,"Top",null,0]
[null,"Area 36",null,null,null,null,null,"Top",null,0]
[null,"Area 37",null,null,null,null,null,"Top",null,0]
[null,"Area 38",null,null,null,null,null,"Top",null,0]
[null,"Area 39",null,null,null,null,null,"Top",null,0]
[null,"Area 40",null,null,null,null,null,"Top",null,0]
[null,"Area 41",null,null,null,null,null,"Top",null,0]
[null,"Area 42",null,null,null,null,null,"Top",null,0]
[null,"Area 43",null,null,null,null,null,"Top",null,0]
[null,"Area 44",null,null,null,null,null,"Top",null,0]
[null,"Area 45",null,null,null,null,null,"Top",null,0]
[null,"Area 46",null,null,null,null,null,"Top",null,0]
[null,"Area 47",null,null,null,null,null,"Top",null,0]
[null,"Area 48",null,null,null,null,null,"Top",null,0]
[null,"Area 49",null,null,null,null,null,"Top",null,0]
[null,"Area 50",null,null,null,null,null,"Top",null,0]
[null,"Area 51",null,null,null,null,null,"Top",null,0]
[null,"Area 52",null,null,null,null,null,"Top",null,0]
[null,"Area 53",null,null,null,null,null,"Top",null,0]
[null,"Area 54",null,null,null,null,null,"Top",null,0]
[null,"Area 55",null,null,null,null,null,"Top",null,0]
[null,"Area 56",null,null,null,null,null,"Top",null,0]
[null,"Area 57",null,null,null,null,null,"Top",null,0]
[null,"Area 58",null,null,null,null,null,"Top",null,0]
[null,"Area 59",null,null,null,null,null,"Top",null,0]
[null,"Area 60",null,null,null,null,null,"Top",null,0]
[null,"Area 61",null,null,null,null,null,"Top",null,0]
[null,"Area 62",null,null,null,null,null,"Top",null,0]
[null,"Area 63",null,null,null,null,null,"Top",null,0]
[null,"Area 64",null,null,null,null,null,"Top",null,0]
[null,"Area 65",null,null,null,null,null,"Top",null,{"$f":"D90*(F90-$J$22)","v":0}]
[null,"Area 66",null,null,null,null,null,"Top",null,0]
[null,"Area 67",null,null,null,null,null,"Top",null,0]
[null,"Area 68",null,null,null,null,null,"Top",null,0]
[null,"Area 69",null,null,null,null,null,"Top",null,0]
[null,"Area 70",null,null,null,null,null,"Top",null,0]
[null,"Area 71",null,null,null,null,null,"Top",null,0]
[null,"Area 72",null,null,null,null,null,"Top",null,0]
[null,"Area 73",null,null,null,null,null,"Top",null,0]
[null,"Area 74",null,null,null,null,null,"Top",null,0]
[null,"Area 75",null,null,null,null,null,"Top",null,0]
[null,"Area 76",null,null,null,null,null,"Top",null,0]
[null,"Area 77",null,null,null,null,null,"Top",null,0]
[null,"Area 78",null,null,null,null,null,"Top",null,0]
[null,"Area 79",null,null,null,null,null,"Top",null,0]
[null,"Area 80",null,null,null,null,null,"Top",null,0]
[null,"Area 81",null,null,null,null,null,"Top",null,0]
[null,"Area 82",null,null,null,null,null,"Top",null,0]
[null,"Area 83",null,null,null,null,null,"Top",null,0]
[null,"Area 84",null,null,null,null,null,"Top",null,0]
[null,"Area 85",null,null,null,null,null,"Top",null,0]
[null,"Area 86",null,null,null,null,null,"Top",null,0]
[null,"Area 87",null,null,null,null,null,"Top",null,0]
[null,"Area 88",null,null,null,null,null,"Top",null,0]
[null,"Area 89",null,null,null,null,null,"Top",null,0]
[null,"Area 90",null,null,null,null,null,"Top",null,0]
[null,"Area 91",null,null,null,null,null,"Top",null,0]
[null,"Area 92",null,null,null,null,null,"Top",null,0]
[null,"Area 93",null,null,null,null,null,"Top",null,0]
[null,"Area 94",null,null,null,null,null,"Top",null,0]
[null,"Area 95",null,null,null,null,null,"Top",null,0]
[null,"Area 96",null,null,null,null,null,"Top",null,0]
[null,"Area 97",null,null,null,null,null,"Top",null,0]
[null,"Area 98",null,null,null,null,null,"Top",null,0]
[null,"Area 99",null,null,null,null,null,"Top",null,0]
[null,"Area 100",null,null,null,null,null,"Top",null,0]
[]
[null,"Top Surface Hourly Heat Loss (Btu/hr)",null,null,null,null,null,null,null,{"$f":"(h_rs+hc_top)*SUM(J26:K125)","v":0}]
[]
[null,null,null,"Bottom Surface"]
[null,null,null,"Group Area (sq ft)",null,"Surface Temp (°F)",null,"Surface",null,"Area Temp Difference (sq ft * °F)"]
[null,"Area 1",null,null,null,null,null,"Bottom",null,{"$f":"D131*(F131-$J$22)","v":0}]
[null,"Area 2",null,null,null,null,null,"Bottom",null,0]
[null,"Area 3",null,null,null,null,null,"Bottom",null,0]
[null,"Area 4",null,null,null,null,null,"Bottom",null,0]
[null,"Area 5",null,null,null,null,null,"Bottom",null,0]
[null,"Area 6",null,null,null,null,null,"Bottom",null,0]
[null,"Area 7",null,null,null,null,null,"Bottom",null,0]
[null,"Area 8",null,null,null,null,null,"Bottom",null,0]
[null,"Area 9",null,null,null,null,null,"Bottom",null,0]
[null,"Area 10",null,null,null,null,null,"Bottom",null,0]
[null,"Area 11",null,null,null,null,null,"Bottom",null,0]
[null,"Area 12",null,null,null,null,null,"Bottom",null,0]
[null,"Area 13",null,null,null,null,null,"Bottom",null,0]
[null,"Area 14",null,null,null,null,null,"Bottom",null,0]
[null,"Area 15",null,null,null,null,null,"Bottom",null,0]
[null,"Area 16",null,null,null,null,null,"Bottom",null,0]
[null,"Area 17",null,null,null,null,null,"Bottom",null,0]
[null,"Area 18",null,null,null,null,null,"Bottom",null,0]
[null,"Area 19",null,null,null,null,null,"Bottom",null,0]
[null,"Area 20",null,null,null,null,null,"Bottom",null,0]
[null,"Area 21",null,null,null,null,null,"Bottom",null,0]
[null,"Area 22",null,null,null,null,null,"Bottom",null,0]
[null,"Area 23",null,null,null,null,null,"Bottom",null,0]
[null,"Area 24",null,null,null,null,null,"Bottom",null,0]
[null,"Area 25",null,null,null,null,null,"Bottom",null,0]
[null,"Area 26",null,null,null,null,null,"Bottom",null,0]
[null,"Area 27",null,null,null,null,null,"Bottom",null,0]
[null,"Area 28",null,null,null,null,null,"Bottom",null,0]
[null,"Area 29",null,null,null,null,null,"Bottom",null,0]
[null,"Area 30",null,null,null,null,null,"Bottom",null,0]
[null,"Area 31",null,null,null,null,null,"Bottom",null,0]
[null,"Area 32",null,null,null,null,null,"Bottom",null,0]
[null,"Area 33",null,null,null,null,null,"Bottom",null,{"$f":"D163*(F163-$J$22)","v":0}]
[null,"Area 34",null,null,null,null,null,"Bottom",null,0]
[null,"Area 35",null,null,null,null,null,"Bottom",null,0]
[null,"Area 36",null,null,null,null,null,"Bottom",null,0]
[null,"Area 37",null,null,null,null,null,"Bottom",null,0]
[null,"Area 38",null,null,null,null,null,"Bottom",null,0]
[null,"Area 39",null,null,null,null,null,"Bottom",null,0]
[null,"Area 40",null,null,null,null,null,"Bottom",null,0]
[null,"Area 41",null,null,null,null,null,"Bottom",null,0]
[null,"Area 42",null,null,null,null,null,"Bottom",null,0]
[null,"Area 43",null,null,null,null,null,"Bottom",null,0]
[null,"Area 44",null,null,null,null,null,"Bottom",null,0]
[null,"Area 45",null,null,null,null,null,"Bottom",null,0]
[null,"Area 46",null,null,null,null,null,"Bottom",null,0]
[null,"Area 47",null,null,null,null,null,"Bottom",null,0]
[null,"Area 48",null,null,null,null,null,"Bottom",null,0]
[null,"Area 49",null,null,null,null,null,"Bottom",null,0]
[null,"Area 50",null,null,null,null,null,"Bottom",null,0]
[null,"Area 51",null,null,null,null,null,"Bottom",null,0]
[null,"Area 52",null,null,null,null,null,"Bottom",null,0]
[null,"Area 53",null,null,null,null,null,"Bottom",null,0]
[null,"Area 54",null,null,null,null,null,"Bottom",null,0]
[null,"Area 55",null,null,null,null,null,"Bottom",null,0]
[null,"Area 56",null,null,null,null,null,"Bottom",null,0]
[null,"Area 57",null,null,null,null,null,"Bottom",null,0]
[null,"Area 58",null,null,null,null,null,"Bottom",null,0]
[null,"Area 59",null,null,null,null,null,"Bottom",null,0]
[null,"Area 60",null,null,null,null,null,"Bottom",null,0]
[null,"Area 61",null,null,null,null,null,"Bottom",null,0]
[null,"Area 62",null,null,null,null,null,"Bottom",null,0]
[null,"Area 63",null,null,null,null,null,"Bottom",null,0]
[null,"Area 64",null,null,null,null,null,"Bottom",null,0]
[null,"Area 65",null,null,null,null,null,"Bottom",null,{"$f":"D195*(F195-$J$22)","v":0}]
[null,"Area 66",null,null,null,null,null,"Bottom",null,0]
[null,"Area 67",null,null,null,null,null,"Bottom",null,0]
[null,"Area 68",null,null,null,null,null,"Bottom",null,0]
[null,"Area 69",null,null,null,null,null,"Bottom",null,0]
[null,"Area 70",null,null,null,null,null,"Bottom",null,0]
[null,"Area 71",null,null,null,null,null,"Bottom",null,0]
[null,"Area 72",null,null,null,null,null,"Bottom",null,0]
[null,"Area 73",null,null,null,null,null,"Bottom",null,0]
[null,"Area 74",null,null,null,null,null,"Bottom",null,0]
[null,"Area 75",null,null,null,null,null,"Bottom",null,0]
[null,"Area 76",null,null,null,null,null,"Bottom",null,0]
[null,"Area 77",null,null,null,null,null,"Bottom",null,0]
[null,"Area 78",null,null,null,null,null,"Bottom",null,0]
[null,"Area 79",null,null,null,null,null,"Bottom",null,0]
[null,"Area 80",null,null,null,null,null,"Bottom",null,0]
[null,"Area 81",null,null,null,null,null,"Bottom",null,0]
[null,"Area 82",null,null,null,null,null,"Bottom",null,0]
[null,"Area 83",null,null,null,null,null,"Bottom",null,0]
[null,"Area 84",null,null,null,null,null,"Bottom",null,0]
[null,"Area 85",null,null,null,null,null,"Bottom",null,0]
[null,"Area 86",null,null,null,null,null,"Bottom",null,0]
[null,"Area 87",null,null,null,null,null,"Bottom",null,0]
[null,"Area 88",null,null,null,null,null,"Bottom",null,0]
[null,"Area 89",null,null,null,null,null,"Bottom",null,0]
[null,"Area 90",null,null,null,null,null,"Bottom",null,0]
[null,"Area 91",null,null,null,null,null,"Bottom",null,0]
[null,"Area 92",null,null,null,null,null,"Bottom",null,0]
[null,"Area 93",null,null,null,null,null,"Bottom",null,0]
[null,"Area 94",null,null,null,null,null,"Bottom",null,0]
[null,"Area 95",null,null,null,null,null,"Bottom",null,0]
[null,"Area 96",null,null,null,null,null,"Bottom",null,0]
[null,"Area 97",null,null,null,null,null,"Bottom",null,0]
[null,"Area 98",null,null,null,null,null,"Bottom",null,0]
[null,"Area 99",null,null,null,null,null,"Bottom",null,0]
[null,"Area 100",null,null,null,null,null,"Bottom",null,0]
[]
[null,"Bottom Surface Hourly Heat Loss (Btu/hr)",null,null,null,null,null,null,null,{"$f":"(h_rs+hc_bottom)*SUM(J131:K230)","v":0}]
[]
[null,null,null,"Side Surfaces"]
[null,null,null,"Group Area (sq ft)",null,"Surface Temp (°F)",null,"Surface",null,"Area Temp Difference (sq ft * °F)"]
[null,"Area 1",null,null,null,null,null,"Sides",null,{"$f":"D236*(F236-$J$22)","v":0}]
[null,"Area 2",null,null,null,null,null,"Sides",null,0]
[null,"Area 3",null,null,null,null,null,"Sides",null,0]
[null,"Area 4",null,null,null,null,null,"Sides",null,0]
[null,"Area 5",null,null,null,null,null,"Sides",null,0]
[null,"Area 6",null,null,null,null,null,"Sides",null,0]
[null,"Area 7",null,null,null,null,null,"Sides",null,0]
[null,"Area 8",null,null,null,null,null,"Sides",null,0]
[null,"Area 9",null,null,null,null,null,"Sides",null,0]
[null,"Area 10",null,null,null,null,null,"Sides",null,0]
[null,"Area 11",null,null,null,null,null,"Sides",null,0]
[null,"Area 12",null,null,null,null,null,"Sides",null,0]
[null,"Area 13",null,null,null,null,null,"Sides",null,0]
[null,"Area 14",null,null,null,null,null,"Sides",null,0]
[null,"Area 15",null,null,null,null,null,"Sides",null,0]
[null,"Area 16",null,null,null,null,null,"Sides",null,0]
[null,"Area 17",null,null,null,null,null,"Sides",null,0]
[null,"Area 18",null,null,null,null,null,"Sides",null,0]
[null,"Area 19",null,null,null,null,null,"Sides",null,0]
[null,"Area 20",null,null,null,null,null,"Sides",null,0]
[null,"Area 21",null,null,null,null,null,"Sides",null,0]
[null,"Area 22",null,null,null,null,null,"Sides",null,0]
[null,"Area 23",null,null,null,null,null,"Sides",null,0]
[null,"Area 24",null,null,null,null,null,"Sides",null,0]
[null,"Area 25",null,null,null,null,null,"Sides",null,0]
[null,"Area 26",null,null,null,null,null,"Sides",null,0]
[null,"Area 27",null,null,null,null,null,"Sides",null,0]
[null,"Area 28",null,null,null,null,null,"Sides",null,0]
[null,"Area 29",null,null,null,null,null,"Sides",null,0]
[null,"Area 30",null,null,null,null,null,"Sides",null,0]
[null,"Area 31",null,null,null,null,null,"Sides",null,0]
[null,"Area 32",null,null,null,null,null,"Sides",null,0]
[null,"Area 33",null,null,null,null,null,"Sides",null,{"$f":"D268*(F268-$J$22)","v":0}]
[null,"Area 34",null,null,null,null,null,"Sides",null,0]
[null,"Area 35",null,null,null,null,null,"Sides",null,0]
[null,"Area 36",null,null,null,null,null,"Sides",null,0]
[null,"Area 37",null,null,null,null,null,"Sides",null,0]
[null,"Area 38",null,null,null,null,null,"Sides",null,0]
[null,"Area 39",null,null,null,null,null,"Sides",null,0]
[null,"Area 40",null,null,null,null,null,"Sides",null,0]
[null,"Area 41",null,null,null,null,null,"Sides",null,0]
[null,"Area 42",null,null,null,null,null,"Sides",null,0]
[null,"Area 43",null,null,null,null,null,"Sides",null,0]
[null,"Area 44",null,null,null,null,null,"Sides",null,0]
[null,"Area 45",null,null,null,null,null,"Sides",null,0]
[null,"Area 46",null,null,null,null,null,"Sides",null,0]
[null,"Area 47",null,null,null,null,null,"Sides",null,0]
[null,"Area 48",null,null,null,null,null,"Sides",null,0]
[null,"Area 49",null,null,null,null,null,"Sides",null,0]
[null,"Area 50",null,null,null,null,null,"Sides",null,0]
[null,"Area 51",null,null,null,null,null,"Sides",null,0]
[null,"Area 52",null,null,null,null,null,"Sides",null,0]
[null,"Area 53",null,null,null,null,null,"Sides",null,0]
[null,"Area 54",null,null,null,null,null,"Sides",null,0]
[null,"Area 55",null,null,null,null,null,"Sides",null,0]
[null,"Area 56",null,null,null,null,null,"Sides",null,0]
[null,"Area 57",null,null,null,null,null,"Sides",null,0]
[null,"Area 58",null,null,null,null,null,"Sides",null,0]
[null,"Area 59",null,null,null,null,null,"Sides",null,0]
[null,"Area 60",null,null,null,null,null,"Sides",null,0]
[null,"Area 61",null,null,null,null,null,"Sides",null,0]
[null,"Area 62",null,null,null,null,null,"Sides",null,0]
[null,"Area 63",null,null,null,null,null,"Sides",null,0]
[null,"Area 64",null,null,null,null,null,"Sides",null,0]
[null,"Area 65",null,null,null,null,null,"Sides",null,{"$f":"D300*(F300-$J$22)","v":0}]
[null,"Area 66",null,null,null,null,null,"Sides",null,0]
[null,"Area 67",null,null,null,null,null,"Sides",null,0]
[null,"Area 68",null,null,null,null,null,"Sides",null,0]
[null,"Area 69",null,null,null,null,null,"Sides",null,0]
[null,"Area 70",null,null,null,null,null,"Sides",null,0]
[null,"Area 71",null,null,null,null,null,"Sides",null,0]
[null,"Area 72",null,null,null,null,null,"Sides",null,0]
[null,"Area 73",null,null,null,null,null,"Sides",null,0]
[null,"Area 74",null,null,null,null,null,"Sides",null,0]
[null,"Area 75",null,null,null,null,null,"Sides",null,0]
[null,"Area 76",null,null,null,null,null,"Sides",null,0]
[null,"Area 77",null,null,null,null,null,"Sides",null,0]
[null,"Area 78",null,null,null,null,null,"Sides",null,0]
[null,"Area 79",null,null,null,null,null,"Sides",null,0]
[null,"Area 80",null,null,null,null,null,"Sides",null,0]
[null,"Area 81",null,null,null,null,null,"Sides",null,0]
[null,"Area 82",null,null,null,null,null,"Sides",null,0]
[null,"Area 83",null,null,null,null,null,"Sides",null,0]
[null,"Area 84",null,null,null,null,null,"Sides",null,0]
[null,"Area 85",null,null,null,null,null,"Sides",null,0]
[null,"Area 86",null,null,null,null,null,"Sides",null,0]
[null,"Area 87",null,null,null,null,null,"Sides",null,0]
[null,"Area 88",null,null,null,null,null,"Sides",null,0]
[null,"Area 89",null,null,null,null,null,"Sides",null,0]
[null,"Area 90",null,null,null,null,null,"Sides",null,0]
[null,"Area 91",null,null,null,null,null,"Sides",null,0]
[null,"Area 92",null,null,null,null,null,"Sides",null,0]
[null,"Area 93",null,null,null,null,null,"Sides",null,0]
[null,"Area 94",null,null,null,null,null,"Sides",null,0]
[null,"Area 95",null,null,null,null,null,"Sides",null,0]
[null,"Area 96",null,null,null,null,null,"Sides",null,0]
[null,"Area 97",null,null,null,null,null,"Sides",null,0]
[null,"Area 98",null,null,null,null,null,"Sides",null,0]
[null,"Area 99",null,null,null,null,null,"Sides",null,0]
[null,"Area 100",null,null,null,null,null,"Sides",null,0]
[]
[null,"Side Surfaces Hourly Heat Loss (Btu/hr)",null,null,null,null,null,null,null,{"$f":"(h_rs+hc_side)*SUM(J236:K335)","v":0}]

{"sheet":"Draft Factor Tests","index":10,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,1,26,4],[26,5,26,8],[27,1,27,4],[27,5,27,8],[28,1,28,4],[28,5,28,8],[23,1,23,4],[23,5,23,8],[24,1,24,4],[24,5,24,8],[25,1,25,4],[25,5,25,8],[1,1,1,2],[22,1,22,8],[9,1,9,8],[10,1,10,8],[11,1,11,4],[11,5,11,8],[12,1,12,4],[12,5,12,8],[21,1,21,8],[13,1,13,4],[13,5,13,8],[17,1,17,2],[18,1,18,2],[19,1,19,2],[16,1,16,3],[40,1,40,4],[40,5,40,8],[39,1,39,4],[39,5,39,8],[37,1,37,4],[37,5,37,8],[38,1,38,4],[38,5,38,8],[35,1,35,4],[35,5,35,8],[36,1,36,4],[34,1,34,4],[34,5,34,8],[36,5,36,8],[29,1,29,4],[29,5,29,8],[33,1,33,4],[33,5,33,8],[32,1,32,8]]}
[]
[null,"Title Block",null,null,"Variable","Description","Value"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"},null,"DF","Off-Cycle Draft Factor for Flue Gas Flow",{"$f":"IFERROR(IF($F$14=\"Yes\",0.05,MIN(D_F_Lookup,D_F_Calc)),\"\")","v":0}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,"DP","Power Burner Draft Factor",{"$f":"IFERROR(IF($F$14=\"Yes\",0.05, D_P_Calc),\"\")","v":""}]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Draft Factor Tests"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[null,"Procedure for determining (DF and DP) of vented home heating equipment with no measurable airflow. "]
[null,"7.10   Additional optional method of testing for determining DP and DF for furnaces and boilers. On units whose design is such that there is no measurable airflow through the combustion chamber and heat exchanger when the burner(s) is (are) off as determined by the optional test procedure in section 7.10.1 of this appendix, DF and DP may be set equal to 0.05."]
[null,"Was the visual assessment test performed? (Per 7.10.1.1 through 7.10.1.4)"]
[null,"Was any smoke drawn into the combustion air intake? (Per 7.10.1.5)"]
[null,"Meets the requirements to allow use of the minimum default draft factor pursuant to section 8.8.3 and/or section 9.10 of ASHRAE 103-1993?",null,null,null,{"$f":"IF(AND($F$12=\"Yes\",$F$13=\"No\"),\"Yes\",\"No\")","v":"No"}]
[]
[]
[null,"Methods for determining Draft Factors DP, DF, and DS for units not eligible for the default draft factor."]
[null,"Use Table 6 to determine DF and DS? (See § 8.8.1)"]
[null,"DF Lookup from Table 6",null,{"$f":"IF(AND($D$18=\"Yes\",System_Number=9),1,\nIF(AND($D$18=\"Yes\",System_Number=10),0.4,\"\"))","v":""}]
[null,"Calculated DF per § 8.8.2.1",null,{"$f":"IF(AND($F$14=\"No\",$D$18=\"No\"), D_P_Calc,\"\")","v":""}]
[]
[null,"Draft Factor Test- Max Input Rate"]
[]
[null,"Tracer Gas Vol. Flow Rate,VT (CFM)"]
[null,"Flue Gas Temp., 5-6 min. After Shut-Off, TF,OFF (°F):"]
[null,"Vol. Concentration Active Tracer Gas in Flue Gas, CT (%)"]
[null,"Vol. Concentration Active Tracer Gas in Mixture, CTm (%)\n(100 when tracer gas is a single component gas)"]
[null,"Tracer Gas Temp., TT (°F):"]
[null,"Barometric Pressure, PB (in. Hg)"]
[null,"Imposed draft maintained (oil-fueled)?"]
[]
[]
[null,"Draft Factor Test- Reduced Input Rate"]
[null,"Tracer Gas Vol. Flow Rate,VT (CFM)"]
[null,"Flue Gas Temp., 5-6 min. After Shut-Off, TF,OFF (°F):"]
[null,"Vol. Concentration Active Tracer Gas in Flue Gas, CT (%)"]
[null,"Vol. Concentration Active Tracer Gas in Mixture, CTm (%)\n(100 when tracer gas is a single component gas)"]
[null,"Tracer Gas Temp., TT (°F):"]
[null,"Barometric Pressure, PB (in. Hg)"]
[null,"Imposed draft maintained (oil-fueled)?"]

{"sheet":"Photos","index":11,"n_rows":176,"n_cols":9,"rows_kept":176,"cut":false,"hidden":false,"merged":[[1,1,1,2],[176,1,197,14],[35,1,56,14],[107,1,127,6],[107,8,127,14],[59,1,80,14],[83,1,104,14],[130,1,150,6],[130,8,150,14],[3,7,3,9],[2,3,2,5],[11,1,32,14],[153,1,173,6],[153,8,173,14]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Photos"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"1. Nameplate showing model number and serial number (if applicable)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. FTC EnergyGuide and ENERGY STAR labels (if present)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Photos of test unit from all sides (including photo of control panel)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Exact placement of all sensors on, in, or around the device"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Pictures of Ducts and Plenums",null,null,null,null,null,null,"6. Pictures of Stack and Thermocouple Grid in Flue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7. Pictures of Ambient Temperature Sensors",null,null,null,null,null,null,"8. Pictures of Burner"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"9.  Picture of Controls at Maximum Input",null,null,null,null,null,null,"10.  Picture of Controls at Reduced Input"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"11. Additional Photos (if necessary)"]

{"sheet":"Test Data Inputs & Calculations","index":12,"n_rows":161,"n_cols":12,"rows_kept":161,"cut":false,"hidden":false,"merged":[[2,3,2,4],[3,6,3,7],[10,1,10,11],[1,1,1,2],[89,2,91,7],[146,1,146,6],[153,1,153,6],[104,2,105,7],[18,1,18,7],[42,1,42,7],[59,1,59,7],[131,1,131,6]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Test Data Inputs & Calculations"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Table 7: Fuel Characteristics and Parameters for Calculating Steady-State Sensible Heat Loss{LS,SS} and Steady-State Efficiency {EffySS}"]
[null,"Fuel","HHVA","A/F","LL,A","A","B","CF(1)","CF(2)","CF(3)","CF(4)","CF(5)"]
[null,{"$f":"IF(Fuel_Type=\"\",\"\", Fuel_Type)","v":""},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,2, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,3, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,4, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,5, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,6, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,7, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,8, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,9, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,10, FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$13,'Drop-Downs and Tables'!$B$75:$L$80,11, FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"CA(1)","CA(2)","CA(3)","CA(4)","CA(5)"]
[null,null,null,null,null,null,null,0.25462120999999999,-3.0260126E-5,2.7608571000000001E-8,-7.4253321000000006E-12,6.4307377000000003E-16]
[null,null,null,null,null,null,null,"i"]
[null,"Applicable Calulation Section",{"$f":"VALUE(TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100)))","v":{"$error":"#VALUE!"}},null,null,null,null,1,2,3,4,5]
[]
[null,"Steady State Efficiency Calculation"]
[null,"ANSI/ASHRAE Section","Variable Name","Equation / Instructions","Variable","Equation Section","Value","Unit"]
[null,{"$f":"11.1","v":11.1},"Heating Seasonal Efficiency (Electric)",null,"EffyHS-E",11.1,{"$f":"IFERROR(IF(Energy_Source<>\"Electricity\", \"N/A\", ROUND(IF(Installation_Type=\"Outdoor\", 100-3.3*L_J, IF(Installation_Type=\"Indoor/Isolated Combustion System\", 100-1.7*L_J, \"\")), 1)),\"\")","v":"N/A"},"%"]
[null,null,"Annual Fuel Utilization Efficiency (Electric)",null,"AFUE",11.1,{"$f":"G21","v":"N/A"},"%"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".1\"","v":".1"},"System Number",null,"-","11.2.1",{"$f":"'General Info & Test Results'!C56","v":0},"-"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".2\"","v":".2"},"Ratio of Combustion Air to Stoichiometric Air (Max)",null,"RT,F","11.2.2",{"$f":"A+(B/X_CO2F_M)","v":{"$error":"#N/A"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".2\"","v":".2"},"Ratio of Combustion Air to Stoichiometric Air (Reduced)",null,"RT,F,R","11.2.2",{"$f":"A+(B/X_CO2F_R)","v":{"$error":"#N/A"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".3\"","v":".3"},"Ratio of Combustion and Relief Air to Stoichiometric Air (Max)",null,"RT,S,H","11.2.3",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), \"N/A\", A+(B/X_CO2S_M))","v":{"$error":"#VALUE!"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".3\"","v":".3"},"Ratio of Combustion and Relief Air to Stoichiometric Air (Reduced)",null,"RT,S,R","11.2.3",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), \"N/A\", A+(B/X_CO2S_R))","v":{"$error":"#VALUE!"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".4\"","v":".4"},"Average Ratio of Stack gas Mass Flow rate to Flue gas Mass flow rate (Max)",null,"S/FF","11.2.4",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), 1,IF(Draft_Equipment=\"None - Direct Exhaust\", 1, IF(Draft_Equipment=\"Barometric Draft Control\", 1.4, 1.3*(R_TS/R_TF))))","v":{"$error":"#VALUE!"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".4\"","v":".4"},"Average Ratio of Stack gas Mass Flow rate to Flue gas Mass flow rate (Reduced)",null,"S/FR","11.2.4",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), 1,IF(Draft_Equipment=\"None - Direct Exhaust\", 1, IF(Draft_Equipment=\"Barometric Draft Control\", 1.4,  1.3*(R_TS_R/R_TF_R))))","v":{"$error":"#VALUE!"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".5\"","v":".5"},"Steady State Flue Temperature Rise (Max)",null,"ΔTF,SS","11.2.5",{"$f":"TFSSH-TRAH","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".5\"","v":".5"},"Steady State Flue Temperature Rise (Reduced)",null,"ΔTF,SS,R","11.2.5",{"$f":"TFSSR-TRAR","v":207.9},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".6\"","v":".6"},"Average Sensible Heat Loss at Steady-State Operation (Max)","Use RT,F and ΔTF,SS in Figure 13","LS,SS","11.2.6",{"$f":"100/HHV_A * (SUM( ((1+A_F) * (CFi) + A_F * (R_TF-1) * (CAi)) * ((TFSSH + 460)^i - (TRAH + 460)^i)))","v":{"$error":"#N/A"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".6\"","v":".6"},"Average Sensible Heat Loss at Steady-State Operation (Reduced)","Use RT,F,R and ΔTF,SS,R in Figure 13","LS,SS,R","11.2.6",{"$f":"100/HHV_A * (SUM( ((1+A_F) * (CFi) + A_F* (R_TF_R-1) * (CAi)) * ((TFSSR + 460)^i- (TRAR + 460)^i)))","v":{"$error":"#N/A"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8\"","v":".8"},"Average Latent heat loss of test fuel used (Max)",null,"LL,A","Table 7",{"$f":"L_LA","v":{"$error":"#N/A"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9\"","v":".9"},"Average Latent heat loss of test fuel used (Reduced)",null,"LL,A,R","Table 7",{"$f":"L_LA","v":{"$error":"#N/A"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.1\"","v":".7.1"},"Latent Heat Gain Due to Condensation Under Steady State Conditions (MAX)",null,"LG,SS,H","11.3.7.1",{"$f":"IFERROR((100*(1053.3)*M_CSS)/Q_CSS,\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.1\"","v":".7.1"},"Latent Heat Gain Due to Condensation Under Steady State Conditions (Reduced)",null,"LG,SS,R","11.3.7.1",{"$f":"IFERROR((100*(1053.3)*M_CSS_R)/Q_CSS_R,\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.2\"","v":".7.2"},"Steady-State Heat Loss due to Hot condensate Going Down the Drain (Max)",null,"LC,SS,H","11.3.7.2",{"$f":"IFERROR(IF(Calculation_Section=11.5,(L_GSS*(1*(TFSSH-70)-0.45*(TFSSH-0)))/1053.3,(L_GSS*(1*(TFSSH-70)-0.45*(TFSSH-T_OA_H)))/1053.3),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.2\"","v":".7.2"},"Steady-State Heat Loss due to Hot condensate Going Down the Drain (Reduced)",null,"LC,SS,R","11.3.7.2",{"$f":"IFERROR(IF(Calculation_Section=11.5,(L_GSS_R*(1*(TFSSR-70)-0.45*(TFSSR-40.5)))/1053.3,(L_GSS_R*(1*(TFSSR-70)-0.45*(TFSSR-T_OA_R)))/1053.3),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.3\"","v":".7.3"},"Steady State Efficiency (Max)",null,"EffySS,H","11.3.7.3",{"$f":"ROUND(IF(OR(Calculation_Section=11.2,Calculation_Section=11.4),100-(L_LA+L_S_SS),100-(L_LA+L_S_SS-L_GSS+LCSSH)),1)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".7.3\"","v":".7.3"},"Steady State Efficiency (Reduced)",null,"EffySS,R","11.3.7.3",{"$f":"IF(OR(Calculation_Section=11.2,Calculation_Section=11.4),100-(L_LA+L_S_SS_R),100-(L_LA+L_S_SS_R-L_GSS_R+LCSSR))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[]
[null,"Weighted-Average Steady State Efficiency"]
[null,"ANSI/ASHRAE Section","Variable Name","Equation / Instructions","Variable","Equation Section","Value","Unit"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.1.\"","v":".8.1."},"Jacket Loss Adjustment Factor",null,"K",null,{"$f":"IF(Installation_Type=\"Outdoor\", 3.3, IF(Installation_Type=\"Indoor/Isolated Combustion System\", 1.7))","v":false}]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.1.1\"","v":".8.1.1"},"Maximum Fuel Input Rate Heating Capacity",null,"QOUT","11.2.8",{"$f":"ROUND((Q_in*(EFFY_ss-(K*L_J)))/100,-3)","v":{"$error":"#VALUE!"}},"Btu/h"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.1.2\"","v":".8.1.2"},"Reduced Fuel Input rate Heating Capacity",null,"QOUT,R","11.4.8.1",{"$f":"ROUND((Q_in_R*(EFFY_ss_R-K*L_J))/100,-3)","v":{"$error":"#VALUE!"}},"Btu/h"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.2\"","v":".8.2"},"Design Heating Requirement (Max)","Use Table 8 (Multiply KDHR by 1000)","DHR","11.2.8.2",{"$f":"IF(OR(Calculation_Section=11.5,Calculation_Section=11.4), 1000*AVERAGEIFS('Drop-Downs and Tables'!$E$86:$E$99,'Drop-Downs and Tables'!$B$86:$B$99, \"<=\"&Q_Out, 'Drop-Downs and Tables'!$C$86:$C$99, \">=\"&Q_Out),1000*AVERAGEIFS('Drop-Downs and Tables'!$D$86:$D$99,'Drop-Downs and Tables'!$B$86:$B$99, \"<=\"&Q_Out, 'Drop-Downs and Tables'!$C$86:$C$99, \">=\"&Q_Out))","v":{"$error":"#VALUE!"}},"Btu/h"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.3\"","v":".8.3"},"Oversize Factor ",null,"α","11.4.8.3",{"$f":"IF(Reduced_Test_Required=\"No\",0.7,(Q_Out/DHR)-1)","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.5\"","v":".8.5"},"Balance-Point Temperature",null,"TC","11.4.8.5",{"$f":"IF(65-((60)*(1+alpha)*(Q_Out_R/Q_Out))<0,0,65-((60)*(1+alpha)*(Q_Out_R/Q_Out)))","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.4\"","v":".8.4"},"Average Outdoor Temperature (Max)","Use Figure 23 or Table 10 (For single stage units, use 42 °F)","TOA,H","11.4.8.4",{"$f":"IF(OR(Calculation_Section=11.2,Calculation_Section=11.3), 42, IF(T_C=\"\",\"\",IF(T_C<6,0,\nOFFSET('Drop-Downs and Tables'!G104,COUNTIF('Drop-Downs and Tables'!B105:B121,\"<=\"&T_C),0))))","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.4\"","v":".8.4"},"Average Outdoor Temperature (Reduced)","Use Figure 23 or Table 10","TOA,R","11.4.8.4",{"$f":"IF(T_C=\"\",\"\",IF(T_C<6,40.5,\nOFFSET('Drop-Downs and Tables'!F104,COUNTIF('Drop-Downs and Tables'!B105:B121,\"<=\" & T_C),0)))","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.6\"","v":".8.6"},"Fraction of Heating Load at Maximum Fuel Input Rate Operating Mode","Use Figure 24 or Table 10","XH","11.4.8.6",{"$f":"IF(T_C<6,0,OFFSET('Drop-Downs and Tables'!E104,COUNTIF('Drop-Downs and Tables'!B105:B121,\"<=\"&T_C),0))","v":{"$error":"#VALUE!"}},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.7\"","v":".8.7"},"Fraction of Heating Load at Reduced Fuel input Rate Operating Mode","Use Figure 24 or Table 10","XR","11.4.8.7",{"$f":"IFERROR(1-X_H,\"\")","v":""},"Ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.8\"","v":".8.8"},"Average Steady-State Efficiency for the Modulating Mode for Furnaces and Boilers Equipped with Step Modulating Controls",null,"EffySS,M","11.4.8.8",{"$f":"IFERROR(IF(Q_Out_R>DHR,EFFY_ss_R,((DHR-Q_Out_R)/(Q_Out-Q_Out_R))*((T_C-T_OA_H)/(T_C-5))*(EFFY_ss-EFFY_ss_R)+EFFY_ss_R),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.9\"","v":".8.9"},"Weighted-Average Steady-State Efficiency (Two-Stage)",null,"EffySS,W","11.4.8.9",{"$f":"ROUND((X_H)*(EFFY_ss)+(X_R)*(EFFY_ss_R),1)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.9\"","v":".8.9"},"Weighted-Average Steady-State Efficiency (Step Modulating)",null,"EffySS,W","11.4.8.9",{"$f":"IFERROR(ROUND((X_H)*(EFFY_ss_M)+(X_R)*(EFFY_ss_R),1),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".8.10\"","v":".8.10"},"Average Heat Output Rate for the Modulating Mode for Furnaces and Boilers Equipped with Step Modulating Controls",null,"QOUT,M","11.4.8.10",{"$f":"IFERROR((DHR-Q_Out_R)*((T_C-T_OA_H)/(T_C-5))+Q_Out_R,\"\")","v":""},"Btu/h"]
[]
[null,"Calculations Not Affected by Outside Air"]
[null,"ANSI/ASHRAE Section","Variable Name","Equation / Instructions","Variable","Equation Section","Value","Unit"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.1\"","v":".9.1"},"Multiplication Factor For Sensible Heat Loss During Burner On-Cycle (Max)",null,"KS,ON,H","11.2.9.1",{"$f":"(100*C_p*(1+(R_TF)*(A_F)))/HHV_A","v":{"$error":"#N/A"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.1\"","v":".9.1"},"Multiplication Factor For Sensible Heat Loss During Burner On-Cycle (Reduced)",null,"KS,ON,R","11.2.9.1",{"$f":"(100*C_p*(1+(R_TF_R)*(A_F)))/HHV_A","v":{"$error":"#N/A"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.2\"","v":".9.2"},"Multiplication Factor for Infiltration Loss During Burner On-Cycle (Max)",null,"KI,ON,H","11.2.9.2",{"$f":"0","v":0},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.2\"","v":".9.2"},"Multiplication Factor for Infiltration Loss During Burner On-Cycle (Reduced)",null,"KI,ON,R","11.2.9.2",{"$f":"0","v":0},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.2.2\"","v":".9.2.2"},"Average On-Cycle Infiltration Heat Loss for the Modulating Mode for Furnaces and Boilers Equipped with Step Modulating Controls",null,"LI,ON,M","11.4.9.2.2",{"$f":"IFERROR(((K_I_ON_R)*(70-T_OA_R)+(K_I_ON)*(70-T_OA_H))/2,\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.2.3\"","v":".9.2.3"},"Average Part-Load Efficiency for the Modulating Mode for Furnaces and Boilers Equipped with Step Modulating Controls",null,"EFFyU,M","11.4.9.2.3",{"$f":"IFERROR(EFFY_ss_M-C_J*L_J,\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.3\"","v":".9.3"},"Equivalent Field Stack Gas Temperature at Full-Load Steady-State Operation (Max)",null,"Ts,ss","11.2.9.3",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5),\"N/A\",(1/S_F)*(TFSSH-TRAH)+TRAH)","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.3\"","v":".9.3"},"Equivalent Field Stack Gas Temperature at Full-Load Steady-State Operation (Reduced)",null,"Ts,ss R","11.2.9.3",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5),\"N/A\",(1/S_F)*(TFSSR-TRAR)+TRAR)","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"Flue Gas Temperature measured at time (t1) from start-up of the system burner",null,"TF,ON(t1),H",9.6,{"$f":"IF('Max Test'!C72>=TFSSH,TFSSH-0.2,IF('Max Test'!C72>=G71,G71-0.1,'Max Test'!C72))","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"Flue Gas Temperature measured at time (t2) from start-up of the system burner",null,"TF,ON(t2),H",9.6,{"$f":"IF('Max Test'!C73>=TFSSH,TFSSH-0.1,'Max Test'!C73)","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"On-Cycle Time Constant (Max)",null,"τON,H","11.2.9.4",{"$f":"(t_2-t_1)/(LN((TFSSH-T_F_ON_t1)/(TFSSH-T_F_ON_t2)))","v":{"$error":"#VALUE!"}},"min"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"Flue Gas Temperature measured at time (t1) from start-up of the system burner",null,"TF,ON(t1),R",9.6,{"$f":"IF('Reduced Test'!C70>=TFSSR,IF('Reduced Test'!C70>=G71,G71-0.1,'Reduced Test'!#REF!-0.2),'Reduced Test'!C70)","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"Flue Gas Temperature measured at time (t2) from start-up of the system burner",null,"TF,ON(t2),R",9.6,{"$f":"IF('Reduced Test'!C71>=TFSSR,'Reduced Test'!#REF!-0.1,'Reduced Test'!C71)","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.4\"","v":".9.4"},"On-Cycle Time Constant (Reduced)",null,"τON,R","11.2.9.4",{"$f":"(t_2-t_1)/(LN((TFSSR-T_F_On_t1_R)/(TFSSR-T_F_On_t2_R)))","v":{"$error":"#DIV/0!"}},"min"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.5\"","v":".9.5"},"Effective Flue Gas Temperature Difference at Start-Up (Max)",null,"θF,O,X,H","11.2.9.5",{"$f":"(TFSSH-T_F_ON_t1)*EXP(t_1/tau_ON)","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.5\"","v":".9.5"},"Effective Flue Gas Temperature Difference at Start-Up (Reduced)",null,"θF,O,X,R","11.2.9.5",{"$f":"(TFSSR-T_F_On_t1_R)*EXP(t_1/tau_ON_R)","v":{"$error":"#DIV/0!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Flue Gas Temperature measured at time (t3) after shutdown from steady-state operation of the system burner",null,"TF,OFF(t3),H",9.5,{"$f":"IF('Max Test'!C58<='Max Test'!C60, 'Max Test'!C60+0.2, IF('Max Test'!C58<='Max Test'!C59, 'Max Test'!C59+0.1, 'Max Test'!C58))","v":0.2},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Flue Gas Temperature measured at time (t4) after shutdown from steady-state operation of the system burner",null,"TF,OFF(t4),H",9.5,{"$f":"IF('Max Test'!C59<='Max Test'!C60,'Max Test'!C60 +0.1, 'Max Test'!C59)","v":0.1},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Minimum Flue gas Temperature for Furnaces",null,"TF,OFF(t5),H",9.5,{"$f":"'Max Test'!C60","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Off-Cycle Time Constant (MAX)",null,"τOFF, H","11.2.9.6",{"$f":"IF(Off_Cycle_Device=\"Stack Damper\", 7.5/LN(2),(t_4-t_3)/LN((T_F_OFF_t3-T_F_OFF_t5)/(T_F_OFF_t4-T_F_OFF_t5)))","v":10.820212806667225},"min"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Flue Gas Temperature measured at time (t3) after shutdown from steady-state operation of the system burner",null,"TF,OFF(t3),R",9.5,{"$f":"IF('Reduced Test'!C56<='Reduced Test'!C58, 'Reduced Test'!C58+0.2, IF('Reduced Test'!C56<='Reduced Test'!C57, 'Reduced Test'!C57+0.1,'Reduced Test'!C56))","v":0.2},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Flue Gas Temperature measured at time (t4) after shutdown from steady-state operation of the system burner",null,"TF,OFF(t4),R",9.5,{"$f":"IF('Reduced Test'!C57<='Reduced Test'!C58,'Reduced Test'!C58+0.1,'Reduced Test'!C57)","v":0.1},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Minimum Flue gas Temperature for Furnaces",null,"TF,OFF(t5),R",9.5,{"$f":"'Reduced Test'!$C$58","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.6\"","v":".9.6"},"Off-Cycle Time Constant (Reduced)",null,"τOFF,R","11.2.9.6",{"$f":"IF(Off_Cycle_Device=\"Stack Damper\",7.5/LN(2),(t_4-t_3)/LN((T_F_OFF_t3_R-T_F_OFF_t5_R)/(T_F_OFF_t4_R-T_F_OFF_t5_R)))","v":10.820212806667225},"min"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.7\"","v":".9.7"},"Effective Flue Gas Temperature at Shutdown (MAX)",null,"ψF,O,X,H","11.2.9.7",{"$f":"(T_F_OFF_t3-T_F_OFF_t5)*EXP(t_3/tau_off)","v":0.22973967099940704},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.7\"","v":".9.7"},"Effective Flue Gas Temperature at Shutdown (Reduced)",null,"ψF,O,X,R","11.2.9.7",{"$f":"(T_F_OFF_t3_R-T_F_OFF_t5_R)*EXP(t_3/tau_off_R)","v":0.22973967099940704},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.8\"","v":".9.8"},"Minimum Flue Gas Temperature Difference Above Room Temperature (Max)",null,"ψF,∞,X,H","11.2.9.8",{"$f":"T_F_OFF_t5-TRAH","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.8\"","v":".9.8"},"Minimum Flue Gas Temperature Difference Above Room Temperature (Reduced)",null,"ψF,∞,X,R","11.2.9.8",{"$f":"T_F_OFF_t5_R-TRAR","v":-69.599999999999994},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.9\"","v":".9.9"},"Not Applicable"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.9\"","v":".9.9"}]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.10\"","v":".9.10"}]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.11\"","v":".9.11"},"Ratio of Average Burner On-Time per cycle to On-Cycle Time Constant (Max)",null,"RON,H","11.2.9.11",{"$f":"IF(OR(Calculation_Section= 11.4, Calculation_Section=11.5),  10/tau_ON, t_ON/tau_ON)","v":{"$error":"#VALUE!"}},"ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.11\"","v":".9.11"},"Ratio of Average Burner On-Time per cycle to On-Cycle Time Constant (Reduced)",null,"RON,R","11.2.9.11",{"$f":"IF(OR(Calculation_Section= 11.4, Calculation_Section=11.5),  10/tau_ON_R, t_ON/tau_ON_R)","v":{"$error":"#VALUE!"}},"ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.12\"","v":".9.12"},"Ratio of Average Burner Off-Time per cycle to Off-Cycle Time Constant (Max)",null,"ROFF,H","11.2.9.12",{"$f":"IF(OR(Calculation_Section= 11.4, Calculation_Section=11.5),  10/tau_off, t_OFF/tau_off)","v":{"$error":"#VALUE!"}},"ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.12\"","v":".9.12"},"Ratio of Average Burner Off-Time per cycle to Off-Cycle Time Constant (Reduced)",null,"ROFF,R","11.2.9.12",{"$f":"IF(OR(Calculation_Section= 11.4, Calculation_Section=11.5),  10/tau_off_R, t_OFF/tau_off_R)","v":{"$error":"#VALUE!"}},"ratio"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.13\"","v":".9.13"},"Start-Up Burner Cycling Effect Correction Factor (Max)",null,"CT,ON,H","11.2.9.13",{"$f":"((1-((PSI_FOX)*EXP(-R_OFF))/(TFSSH-T_F_OFF_t5))/(1-((Theta_FOX)*(PSI_FOX)*(EXP(-1*(R_ON+R_OFF))))/(TFSSH-T_F_OFF_t5)^2))","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.13\"","v":".9.13"},"Start-Up Burner Cycling Effect Correction Factor (Reduced)",null,"CT,ON,R","11.2.9.13",{"$f":"(((1-((PSI_FOX_R)*EXP(-R_OFF_R))/(TFSSR-T_F_OFF_t5_R))/(1-((Theta_FOX_R)*(PSI_FOX_R)*(EXP(-1*(R_ON_R+R_OFF_R))))/(TFSSR-T_F_OFF_t5_R)^2)))","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.14\"","v":".9.14"},"Shutdown  Burner Cycling Effect Correction Factor (Max)",null,"CT,OFF,H","11.2.9.14",{"$f":"(C_IID)*(1-((Theta_FOX*EXP(-R_ON))/(TFSSH-T_F_OFF_t5)))/(1-(Theta_FOX*PSI_FOX*EXP(-1*(R_ON+R_OFF)))/(TFSSH-T_F_OFF_t5)^2 )","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.14\"","v":".9.14"},"Shutdown  Burner Cycling Effect Correction Factor (Reduced)",null,"CT,OFF,R","11.2.9.14",{"$f":"(C_IID)*((1-(Theta_FOX_R*EXP(-R_ON_R))/(TFSSR-T_F_OFF_t5_R))/(1-((Theta_FOX_R*PSI_FOX_R*EXP(-1*(R_ON_R+R_OFF_R)))/(TFSSR-T_F_OFF_t5_R)^2 ) ))","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.15\"","v":".9.15"},"Effective Flue Gas temperature Difference at Burner Shutdown (Max)",null,"ψF,O,H","11.2.9.15",{"$f":"PSI_FOX*C_T_OFF*C_S","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.15\"","v":".9.15"},"Effective Flue Gas temperature Difference at Burner Shutdown (Reduced)",null,"ψF,O,R","11.2.9.15",{"$f":"PSI_FOX_R*C_T_OFF_R*C_S","v":{"$error":"#VALUE!"}},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.16\"","v":".9.16"},"Minimum Effective Flue Gas Temperature Difference Above Room Temperature",null,"ψF,∞, H","11.2.9.16",{"$f":"PSI_FIX*C_S","v":0},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.16\"","v":".9.16"},"Minimum Effective Flue Gas Temperature Difference Above Room Temperature",null,"ψF,∞, R","11.2.9.16",{"$f":"PSI_FIX_R*C_S","v":-84.911999999999992},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.17\"","v":".9.17"},"Not Applicable"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.18\"","v":".9.18"}]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.19\"","v":".9.19"},"Off-Cycle Sensible Heat Loss Integration Factor F5","Use Figure 16 and ψF,O and ROFF","F5H","11.2.9.19",{"$f":"Int_F5(Psi_FO, R_OFF)","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.19\"","v":".9.19"},"Off-Cycle Sensible Heat Loss Integration Factor F6","Use Figure 17 and ψF,O and ROFF","F6H","11.2.9.19",{"$f":"Int_F6(Psi_FO, R_OFF)","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.19\"","v":".9.19"},"Off-Cycle Sensible Heat Loss Integration Factor F5 (Reduced)","Use Figure 16 and ψF,O and ROFF","F5R","11.2.9.19",{"$f":"Int_F5(PSI_FO_R, R_OFF_R)","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.19\"","v":".9.19"},"Off-Cycle Sensible Heat Loss Integration Factor F6 (Reduced)","Use Figure 17 and ψF,O and ROFF","F6R","11.2.9.19",{"$f":"Int_F6(PSI_FO_R, R_OFF_R)","v":{"$error":"#VALUE!"}},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".9.20\"","v":".9.20"},"Not Applicable"]
[]
[null,"Calculations Affected by Outside Air"]
[null,"ANSI/ASHRAE Section","Variable Name","Variable","Equation Section","Value","Unit"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.1\"","v":".10.1"},"Correction Factor That Corrects for the Use of Outside Air for Combustion","CS,H",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5),\"11.3.10.1\",\"11.2.10.1\")","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), (TFSSH-T_OA_H)/(TFSSH-TRAH),1+(((70-T_OA_H)*EFFY_ss)/((TFSSH-TRAH)*100))),\"\")","v":""},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.1\"","v":".10.1"},"Correction Factor That Corrects for the Use of Outside Air for Combustion","CS,R",{"$f":"IF(OR(Calculation_Section=11.3,Calculation_Section=11.5),\"11.3.10.1\",\"11.2.10.1\")","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(OR(Calculation_Section=11.3,Calculation_Section=11.5), (TFSSR-T_OA_R)/(TFSSR-TRAR), 1+(((70-T_OA_R)*EFFY_ss_R)/((TFSSR-TRAR)*100))),\"\")","v":""},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.2\"","v":".10.2"},"Effective Flue Gas Temperature Difference at Burner Start-Up (Corrected for Burner Cycling Effect) (Max)","θF,O,H","11.2.10.2",{"$f":"IFERROR(C_T_ON*C_SH*Theta_FOX,\"\")","v":""},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.2\"","v":".10.2"},"Effective Flue Gas Temperature Difference at Burner Start-Up (Corrected for Burner Cycling Effect) (Reduced)","θF,O,R","11.2.10.2",{"$f":"IFERROR(C_T_ON_R*C_SR*Theta_FOX_R,\"\")","v":""},"°F"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.3\"","v":".10.3"},"Multiplication Factor for Sensible Heat Loss During the Burner Off-Cycle (Max)","KS,OFF,H","11.2.10.3",{"$f":"IFERROR(((TFSSH-TRAH+530)^(1.19)*(D_F*K_S_ON))/(TFSSH-TRAH+70-T_OA_H)^0.56,\"\")","v":""},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.3\"","v":".10.3"},"Multiplication Factor for Sensible Heat Loss During the Burner Off-Cycle (Reduced)","KS,OFF,R","11.2.10.3",{"$f":"IFERROR(((TFSSR-TRAR+530)^(1.19)*(D_F*K_S_ON_R))/(TFSSR-TRAR+70-T_OA_R)^0.56,\"\")","v":""},"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.4\"","v":".10.4"},"Multiplication Factor for Infiltration Loss During the Burner Off-Cycle (Max)","KI,OFF,H","11.2.10.4",0,"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.4\"","v":".10.4"},"Multiplication Factor for Infiltration Loss During the Burner Off-Cycle (Reduced)","KI,OFF,R","11.2.10.4",0,"Factor"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.5\"","v":".10.5"},"On-Cycle Sensible Heat Loss (Max)","LS,ON,H","11.2.10.5",{"$f":"IFERROR(C_SH*L_S_SS-(K_S_ON*Theta_FO)*((1/R_ON)*(1-EXP(-R_ON))),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.5\"","v":".10.5"},"On-Cycle Sensible Heat Loss (Reduced)","LS,ON,R","11.2.10.5",{"$f":"IFERROR(C_SR*L_S_SS_R-(K_S_ON_R*Theta_FO_R)*((1/R_ON_R)*(1-EXP(-R_ON_R))),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.6\"","v":".10.6"},"Off-Cycle Sensible Heat Loss (Max)","LS,OFF,H","11.2.10.6",{"$f":"IFERROR((K_S_OFF)*(t_OFF/t_ON)*((F5_H)+(Psi_FI)*(F6_H)),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.6\"","v":".10.6"},"Off-Cycle Sensible Heat Loss (Reduced)","LS,OFF,R","11.2.10.6",{"$f":"IFERROR((K_S_OFF_R)*(t_OFF/t_ON)*((F5_R)+(Psi_FI_R)*(F6_R)),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.7\"","v":".10.7"},"On-Cycle Infiltration Heat Loss (Max)","LI,ON,H","11.2.10.7",0,"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.7\"","v":".10.7"},"On-Cycle Infiltration Heat Loss (Reduced)","LI,ON,R","11.2.10.7",0,"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.8\"","v":".10.8"},"Off-Cycle Infiltration Heat Loss (Max)","LI,OFF,H","11.2.10.8",0,"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".10.8\"","v":".10.8"},"Off-Cycle Infiltration Heat Loss (Reduced)","LI,OFF,R","11.2.10.8",0,"% (0-100)"]
[]
[null,"Average Part-Load Efficiency Calculation"]
[null,"ANSI/ASHRAE Section","Variable Name","Variable","Equation Section","Value","Unit"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.1\"","v":".11.1"},"Latent Heat Gain Under Part-Load Conditions (MAX)","LG,H","11.3.11.1",{"$f":"IF(OR(Calculation_Section=11.2, Calculation_Section=11.4), \"N/A\", (100*(1053.3)*M_C)/Q_C)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.1\"","v":".11.1"},"Latent Heat Gain Under Part-Load Conditions (Reduced)","LG,R","11.3.11.1",{"$f":"IF(OR(Calculation_Section=11.2, Calculation_Section=11.4), \"N/A\", (100*(1053.3)*M_C_R)/Q_C_R)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.1\"","v":".11.1"},"Part-Load Heat Loss Due to Condensate Going Down the Drain (MAX)","LC,H","11.3.11.2",{"$f":"IF(OR(Calculation_Section=11.2, Calculation_Section=11.4), \"N/A\",L_G*(1*(TFSSH-70)-0.45*(TFSSH-T_OA_H))/1053.3)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.1\"","v":".11.1"},"Part-Load Heat Loss Due to Condensate Going Down the Drain (Reduced)","LC,R","11.3.11.2",{"$f":"IF(OR(Calculation_Section=11.2, Calculation_Section=11.4), \"N/A\",L_G_R*(1*(TFSSR-70)-0.45*(TFSSR-T_OA_R))/1053.3)","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.2\"","v":".11.2"},"Part-Load Efficiency at Maximum Fuel Input Rate (MAX)","EFFyU,H","11.4.11.2",{"$f":"IFERROR(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\",\nIF(Calculation_Section=11.4, 100-L_LA-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON+L_S_OFF+L_I_ON+L_I_OFF),\nIF(Heatup_Skip=\"No\", 100-L_LA+L_G-L_C-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON+L_S_OFF+L_I_ON+L_I_OFF),\n100-L_LA+L_G-L_C-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(C_SH*L_S_SS)))),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.1\"","v":".11.1"},"Part-Load Efficiency at Reduced Fuel Input Rate (Reduced)","EFFyU,R","11.4.11.1",{"$f":"IFERROR(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\",\nIF(Calculation_Section=11.4, 100-L_LA-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON_R+L_S_OFF_R+L_I_ON_R+L_I_OFF_R),\nIF(Heatup_Skip=\"No\", 100-L_LA+L_G_R-L_C_R-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON_R+L_S_OFF_R+L_I_ON_R+L_I_OFF_R),\n100-L_LA+L_G_R-L_C_R-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(C_SR*L_S_SS_R)))),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.3\"","v":".11.3"},"Heating Seasonal Efficiency (Single Stage)","EFFyHS","11.2.11",{"$f":"IF(OR(Calculation_Section=11.4, Calculation_Section=11.5), \"N/A\",\nIF(Calculation_Section=11.2, 100-L_LA-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON+L_S_OFF+L_I_ON+L_I_OFF),\n 100-L_LA+L_G-L_C-C_J*L_J-(t_ON/(t_ON+(Q_P/Q_in)*t_OFF))*(L_S_ON+L_S_OFF+L_I_ON+L_I_OFF)))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.3\"","v":".11.3"},"Heating Seasonal Efficiency (Two Stage)","EFFyHS","11.5.11.3",{"$f":"IFERROR(ROUND(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\",X_H*EFFY_UH+X_R*EFFY_UR),1),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".11.3\"","v":".11.3"},"Heating Seasonal Efficiency (Modulating)","EFFyHS","11.5.11.3",{"$f":"IFERROR(ROUND(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\", X_H*EFFY_UM+X_R*EFFY_UR),1),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".12\"","v":".12"},"Annual Fuel Utilization Efficiency (Single Stage)","AFUE","11.2.12",{"$f":"IF(OR(Calculation_Section=11.4, Calculation_Section=11.5), \"N/A\",(5200*EFFY_ss*EFFY_HS_SingleStage)/(5200*EFFY_ss+2.5*(1+alpha)*4600*EFFY_HS_SingleStage*(Q_P/Q_in)))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".12\"","v":".12"},"Annual Fuel Utilization Efficiency (Two Stage)","AFUE","11.4.12",{"$f":"IFERROR(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\",(5200*EFFY_SS_W_2S*EFFY_HS_TwoStage)/(5200*EFFY_SS_W_2S+2.5*(1+alpha)*4600*EFFY_HS_TwoStage*(Q_P/Q_in))),\"\")","v":""},"% (0-100)"]
[null,{"$f":"TRIM(RIGHT(SUBSTITUTE('General Info & Test Results'!$C$57,\" \",REPT(\" \",100)),100))&\".12\"","v":".12"},"Annual Fuel Utilization Efficiency (Modulating)","AFUE","11.4.12",{"$f":"IFERROR(IF(OR(Calculation_Section=11.2, Calculation_Section=11.3), \"N/A\", (5200*EFFY_SS_W_MOD*EFFY_HS_Modulating)/(5200*EFFY_SS_W_MOD+2.5*(1+alpha)*4600*EFFY_HS_Modulating*(Q_P/Q_in))),\"\")","v":""},"% (0-100)"]
[]
[null,"Draft Factor Calculation when Optional Tracer Gas Test is Performed"]
[null,"ANSI/ASHRAE Section","Variable Name","Variable","Equation Section","Value","Unit"]
[null,"11.6.1","Flue gas mass flow rate during the on-period","MF,ON","11.6.1",{"$f":"(R_TF*A_F+1)*(Q_in/(HHV_A*60))","v":{"$error":"#N/A"}},"% (0-100)"]
[null,"11.6.2","Flue gas mass flow rate at the time of sampling","MF,M","11.6.2",{"$f":"((C_Tm-C_T)*V_T*(1.325*P_B/(T_T+460)))/C_T","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[null,"11.6.3","Flue gass mass flow rate during the off-period","MF,OFF","11.6.3",{"$f":"IF(Imposed_Draft=\"Yes\", M_F_M, M_F_M*((TFSSH-TRAH)/(T_F_OFF-TRAH))^0.56*((T_F_OFF+460)/(TFSSH+460))^1.19)","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[null,"11.6.4","Flue draft factor","DP","11.6.4",{"$f":"IF('Test Conditions'!$C$82=\"Yes\",0.05,IF('Test Conditions'!$C$82=\"No\",\"N/A\",IF(M_F_OFF/M_F_ON<0.1,0.05,M_F_OFF/M_F_ON)))","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[]
[null,"Draft Factor Calculation when Optional Tracer Gas Test is Performed"]
[null,"ANSI/ASHRAE Section","Variable Name","Variable","Equation Section","Value","Unit"]
[null,"11.6.1","Flue gas mass flow rate during the on-period","MF,ON,R","11.6.1",{"$f":"(R_TF_R*A_F+1)*(Q_in_R/(HHV_A*60))","v":{"$error":"#N/A"}},"% (0-100)"]
[null,"11.6.2","Flue gas mass flow rate at the time of sampling","MF,M,R","11.6.2",{"$f":"((C_Tm_R-C_T_R)*V_T_R*(1.325*P_B_R/(T_T_R+460)))/C_T_R","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[null,"11.6.3","Flue gass mass flow rate during the off-period","MF,OFF,R","11.6.3",{"$f":"IF(Imposed_Draft=\"Yes\", M_F_M_R, M_F_M_R*((TFSSR-TRAR)/(T_F_OFF_R-TRAR))^0.56*((T_F_OFF_R+460)/(TFSSR+460))^1.19)","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[null,"11.6.4","Flue draft factor","DP,R","11.6.4",{"$f":"IF('Test Conditions'!$C$82=\"Yes\",0.05,IF('Test Conditions'!$C$82=\"No\",\"N/A\",IF(M_F_OFF_R/M_F_ON_R<0.1,0.05,M_F_OFF_R/M_F_ON_R)))","v":{"$error":"#DIV/0!"}},"% (0-100)"]
[]
[null,"11.6.4","Draft Factor Used","DP, Calc","11.6.4",{"$f":"IF(Control_Stages=\"Step Modulating\", D_P_R, F152)","v":{"$error":"#DIV/0!"}},"% (0-100)"]

{"sheet":"Comments","index":13,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[47,1,50,11],[10,1,10,11],[12,1,15,11],[17,1,20,11],[22,1,25,11],[27,1,30,11],[2,3,2,5],[3,7,3,9],[32,1,35,11],[37,1,40,11],[42,1,45,11]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Comments"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Enter all anomalies with the test."]

{"sheet":"Report Sign-Off Block","index":14,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,2],[17,1,17,2],[10,1,10,4],[11,1,12,4],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Report Sign-Off Block"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Test Report Sign-Off Block "]
[null,"By signing in the space below, we certify that the information and data in this report: (1) were obtained from the specific test unit under test; (2) were obtained during the specific test being reported; (3) were not copied from any other source, except where instructed to do so; and (4) were not altered or modified in any way. "]
[]
[null,"Role",null,"Date","Entity"]
[null,"Test Completion",null,{"$f":"'General Info & Test Results'!C17","v":"[MM/DD/YYYY]"},"[Test Lab Name]"]
[null,"Template Completion",null,"[MM/DD/YYYY]","[Test Lab Name]"]
[null,"Report Review by Test Lab",null,"[MM/DD/YYYY]","[Test Lab Name]"]
[null,"Report Review by Test Lab",null,"[MM/DD/YYYY]","[Test Lab Name]"]

{"sheet":"Drop-Downs and Tables","index":15,"n_rows":143,"n_cols":17,"rows_kept":143,"cut":false,"hidden":false,"merged":[[140,3,142,3],[124,9,125,9],[83,3,84,3],[123,1,123,5],[124,7,124,8],[101,1,101,2],[101,3,101,4],[101,5,101,6],[102,1,102,2],[83,4,84,8],[9,1,9,16],[1,1,1,2],[42,1,42,3],[72,1,72,11],[31,3,31,5],[30,1,30,5],[31,1,31,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Consumer Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v2.0"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Drop-Downs and Tables"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[null,"Drop Downs"]
[null,"Heating_Medium","Circulation","Energy_Source","Burner_Type","Ignition","Draft_Equipment","Off_Cycle_Devices","Installation","Inlet_Air","Flue_Gas","Control","Fuel_Used","Yes_No","Jacket_Loss","Cooling_Coil","System_Number"]
[]
[null,"Air","Gravity","Gas","Atmospheric","Continuous Pilot","None - Direct Exhaust","Stack Damper","Outdoor","From Heated Space","Condensing","Single Stage","Natural Gas","Yes","Default Value","None",9]
[null,"Water","Forced Fan","Oil","Power (Natural Draft)","Intermittent or Interrupted Pilot","Integral Draft Diverter","Electromechanical Inlet Damper","Indoor/Isolated Combustion System","Direct Vent from Outdoor with Heat Exchange","Non-Condensing","Two-Stage Modulating","Manufactured Gas","No","Optional Test","Intended for Pairing with External Cooling Coil",10]
[null,"Steam",null,"Electricity","Power (Induced Draft)",null,"Draft Hood","Electromechanical Flue Damper",null,"Direct Vent from Outdoor without Heat Exchange",null,"Step Modulating","Butane Gas",null,"User Input Value","Combination Unit with Included Cooling Coil"]
[null,null,null,null,"Power (Forced Draft)",null,"Barometric Draft Control","None",null,null,null,null,"Propane Gas"]
[null,null,null,null,"Power (Pulse Combustion)",null,null,null,null,null,null,null,"No. 1 Oil"]
[null,null,null,null,null,null,null,null,null,null,null,null,"No. 2 Oil"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Electric"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[null,"Tables"]
[null,"Table 1: Characteristics and Pressures of Test Gases (from 8.2.1.3)"]
[null,"Type","Heating Value (Btu/SCF)","Sp. Gr. (Air = 1)","Normal Test Pressure (in. Water)","Increased Test Pressure (in. Water)"]
[null,"Natural Gas",1025,0.65,7,10.5]
[null,"Manufactured Gas",535,0.38,3.5,5.25]
[null,"Butane Gas",3175,2,11,13]
[null,"Propane Gas",2500,1.53,11,13]
[]
[]
[null,"Table 4: Relation of Furnace input to Minimum External Static Pressure* for Performance and Rating Test Purposes (All tests preformed without a filter)"]
[null,"Input to Furnace Range",null,"External Static Pressure (in. water)"]
[null,"Low","High","Oil Furnace with a Temperature Rise Less Than or Equal to 65F","Oil Furnace with a Temperature Rise Greater Than 65F","Gas Furnace","Highlight Flag 1"]
[null,0,55000,0.38,0.18,0.18,{"$f":"IF(AND(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[[#This Row],[Low]],Heating_Input<=Table4_ESP_Reqs_Gas_Oil[[#This Row],[High]]),\"X\",\"\")","v":"X"}]
[null,55001,80000,0.38,0.2,0.2,{"$f":"IF(AND(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[[#This Row],[Low]],Heating_Input<=Table4_ESP_Reqs_Gas_Oil[[#This Row],[High]]),\"X\",\"\")","v":""}]
[null,80001,100000,0.38,0.23,0.23,{"$f":"IF(AND(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[[#This Row],[Low]],Heating_Input<=Table4_ESP_Reqs_Gas_Oil[[#This Row],[High]]),\"X\",\"\")","v":""}]
[null,100001,200000,0.48,0.28000000000000003,0.28000000000000003,{"$f":"IF(AND(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[[#This Row],[Low]],Heating_Input<=Table4_ESP_Reqs_Gas_Oil[[#This Row],[High]]),\"X\",\"\")","v":""}]
[null,200001,300000,0.57999999999999996,0.33,0.33,{"$f":"IF(AND(Heating_Input>=Table4_ESP_Reqs_Gas_Oil[[#This Row],[Low]],Heating_Input<=Table4_ESP_Reqs_Gas_Oil[[#This Row],[High]]),\"X\",\"\")","v":""}]
[null,"* These static pressures apply for operation at maximum rated input only."]
[null,null,"Highlight Flag 2",{"$f":"IF(AND(Energy_Source=\"Oil\",TempRise_Measured<=65),\"X\",\"\")","v":""},{"$f":"IF(AND(Energy_Source=\"Oil\",TempRise_Measured>65),\"X\",\"\")","v":""},{"$f":"IF(Energy_Source=\"Gas\",\"X\",\"\")","v":""}]
[]
[]
[null,"Table 5: Minimum External Static Pressure for Electrical Central Furnaces"]
[null,"Minimum Standard Air Quantity, SCFM","Maximum Standard Air Quantity, SCFM","Minimum ESP, in. water"]
[null,0,849,0.12]
[null,850,1599,0.15]
[null,1600,2599,0.2]
[null,2600,3999,0.25]
[]
[]
[null,"Table 6: System Numbers"]
[null,"Locate the column where all the characteristics arc applicable to the equipment under test.",null,null,null,null,null,null,null,null,null,"System Number"]
[null,"Characteristics",1,2,3,4,5,6,8,9,10,{"$f":"\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"X\",L58=\"\",L59=\"\",L60=\"X\",L61=\"\",L62=\"X\"),1,\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"X\",L58=\"\",L59=\"\",L60=\"\",L61=\"X\",L62=\"X\"),2,\nIF(AND(L54=\"X\",L55=\"\",L56=\"X\",L57=\"\",L58=\"\",L59=\"\",L60=\"\",L61=\"X\",L62=\"X\"),3,\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"\",L58=\"X\",L59=\"\",L60=\"\",L61=\"X\",L62=\"X\"),4,\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"X\",L58=\"\",L59=\"X\",L60=\"X\",L61=\"\",L62=\"\"),5,\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"X\",L58=\"\",L59=\"X\",L60=\"\",L61=\"X\",L62=\"\"),6,\nIF(AND(L54=\"X\",L55=\"\",L56=\"\",L57=\"\",L58=\"X\",L59=\"X\",L60=\"\",L61=\"X\",L62=\"\"),8,\nIF(AND(L54=\"\",L55=\"X\",L59=\"\",L60=\"X\",L61=\"\",L62=\"X\"),9,\nIF(AND(L54=\"\",L55=\"X\",L59=\"\",L60=\"\",L61=\"X\",L62=\"X\"),10,\n\"Product Characteristics not filled in correctly\")))))))))","v":"Product Characteristics not filled in correctly"}]
[null,"Indoor Combustion Air","X","X","X","X","X","X","X",null,null,{"$f":"IF(L55=\"X\",\"\",\"X\")","v":"X"}]
[null,"Outdoor, Direct Vent or Isolated Combust. System",null,null,null,null,null,null,null,"X","X",{"$f":"IF(OR(Installation_Type=\"Outdoor\",Installation_Type=\"Indoor/Isolated Combustion System\",\nInlet_Air=\"Direct Vent from Outdoor with Heat Exchange\",Inlet_Air=\"Direct Vent from Outdoor Without Heat Exchange.\"),\n\"X\",\"\")","v":""}]
[null,"Direct Exhaust",null,null,"X",null,null,null,null,"(May or may not be present. Does not affect the results.)",null,{"$f":"IF(Draft_Equipment=\"\",\"Fill in General Info\",IF(Draft_Equipment=\"None - Direct Exhaust\",\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Draft Hood or Draft Diverter","X","X",null,null,"X","X",null,null,null,{"$f":"IF(Draft_Equipment=\"\",\"Fill in General Info\",\nIF(OR(Draft_Equipment=\"Draft Hood\",Draft_Equipment=\"Integral Draft Diverter\"),\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Barometric Draft Control",null,null,null,"X",null,null,"X",null,null,{"$f":"IF(Draft_Equipment=\"\",\"Fill in General Info\",IF(Draft_Equipment=\"Barometric Draft Control\",\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Electrical/Mechanical Stack Damper",null,null,null,null,"X","X","X",null,null,{"$f":"IF(Off_Cycle_Device=\"\",\"Fill in General Info\",IF(Off_Cycle_Device=\"Stack Damper\",\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Atmospheric Burner","X",null,null,null,"X",null,null,"X",null,{"$f":"IF(Burner_Type=\"\",\"Fill in General Info\",IF(Burner_Type=\"Atmospheric\",\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Power Burner",null,"X","X","X",null,"X","X",null,"X",{"$f":"IF(Burner_Type=\"\",\"Fill in General Info\",IF(ISNUMBER(FIND(\"Power\",Burner_Type)),\"X\",\"\"))","v":"Fill in General Info"}]
[null,"Burner Inlet Damper or Flue Damper**","X","X","X","X",null,null,null,"X","X",{"$f":"IF(OR(Off_Cycle_Device=\"Electromechanical Inlet Damper\",Off_Cycle_Device=\"Electromechanical Flue Damper\"),\"X\",\"\")","v":""}]
[null,"DF (Constant)",1,0.4,0.4,0.4,1,0.4,0.4,1,0.4]
[null,"DF (Based on DP)","DP","DP","DP","DP",null,"DP","DP","DP*","DP"]
[null,"DS",1,1,"DF","0.85 or \n(0.79+DP)/1.4","DO","DO","0.85xDO or \n(0.79+DP)/1.4xDO"]
[null,"S/F","*","*",1,"1.4 or test#","*","*","1.4 or test#"]
[null,"* Calculated from CO2 values."]
[null,"* For direct vent or atmospheric burner w/bumer inlet damper or flue damper that closes within 10 seconds after the burner shuts off."]
[null,"** Power burner may or may not have electro-mechanical inlet or flue damper."]
[null,"`+ For atmospheric burner w/burner inlet damper or flue damper that closes within 10 seconds after the burner shuts off."]
[null,"Note: System 7 was intentionally omitted."]
[]
[null,"Table 7: Fuel Characteristics and Parameters for Calculating Steady-State Sensible Heat Loss{LS,SS} and Steady-State Efficiency {EffySS}"]
[null,"Fuel","HHVA","A/F","LL,A","A","B","CF(1)","CF(2)","CF(3)","CF(4)","CF(5)"]
[null,"No. 1 Oil",19800,14.56,6.55,6.7900000000000002E-2,14.22,0.24416834000000001,3.3711449E-6,8.8906304999999997E-9,-1.3619019E-12,-1.436741E-16]
[null,"No. 2 Oil",19500,14.49,6.5,6.6680000000000003E-2,14.34,0.24361163,3.6702685999999998E-6,8.7098896999999995E-9,-1.3094378000000001E-12,1.5029208999999999E-16]
[null,"Natural Gas",20120,14.45,9.5500000000000007,9.1939999999999994E-2,10.96,0.25949477999999998,-4.9475802E-6,1.3885838000000001E-8,-2.8059994E-12,3.7682440000000001E-17]
[null,"Manufactured Gas",18500,11.81,10.14,9.6460000000000004E-2,10.1,0.26598442,-7.7561435000000008E-6,1.5833852000000001E-8,-3.4194210000000002E-12,1.2158977000000001E-16]
[null,"Propane Gas",21500,15.58,7.99,8.4099999999999994E-2,12.6,0.25163638999999999,-6.4144603999999997E-6,1.1315072999999999E-8,-2.0656792000000001E-12,-5.4897330000000002E-17]
[null,"Butane Gas",20890,15.36,7.79,8.0799999999999997E-2,12.93,0.25011246999999998,1.7737005E-6,1.0820337E-8,-1.9220640999999999E-12,-7.3013273999999997E-17]
[null,"Air",null,null,null,null,null,0.25462120999999999,-3.0260126E-5,2.7608571000000001E-8,-7.4253321000000006E-12,6.4307377000000003E-16]
[]
[null,"Table 8: Output Capacity (Btu/h) DHR (kBtu/h) "]
[null,"Range",null,"Average DHR","Typical DHR"]
[null,"Low","High"]
[null,5000,10000,5,5]
[null,11000,16000,10,5,10]
[null,17000,25000,15,10,15]
[null,26000,42000,20,15,20,25]
[null,43000,59000,30,25,30,35,40]
[null,60000,76000,40,35,40,45,50]
[null,77000,93000,50,40,45,50,60]
[null,94000,110000,60,50,60,70,80]
[null,111000,127000,70,60,70,80,90]
[null,127000,144000,80,70,80,90,100]
[null,145000,161000,90,80,90,100,110,120]
[null,162000,178000,100,90,100,110,120,130]
[null,179000,195000,110,100,110,120,130,140]
[null,196000,999999999,130,120,130,140,150,160]
[]
[null,"Table 10: Fractional Heating Loads and Average Outdoor Temperatures for Furnaces and Boilers Equipped with Modulating Controls"]
[null,"Balance Point Temperature Range (F)",null,"Fractional Heating Load",null,"Average Outdoor Temperature (F)"]
[null,"TC",null,"Reduced Rate","Modulating or Maximum Rate","Reduced Rate","Modulating or Maximum Rate"]
[null,"Low","High","XR","XH","TOA,R","TOA,H"]
[null,6,15,0.95,5.0000000000000044E-2,41,9]
[null,16,20,0.9,9.9999999999999978E-2,42,14]
[null,21,25,0.84,0.16000000000000003,43,18]
[null,26,28,0.77,0.22999999999999998,44,22]
[null,29,31,0.7,0.30000000000000004,45,24]
[null,32,33,0.66,0.33999999999999997,46,26]
[null,34,35,0.6,0.4,47,27]
[null,36,37,0.54,0.45999999999999996,48,28]
[null,38,39,0.48,0.52,48,30]
[null,40,41,0.42,0.58000000000000007,49,31]
[null,42,43,0.35,0.65,50,32]
[null,44,45,0.28999999999999998,0.71,51,33]
[null,46,47,0.23,0.77,52,35]
[null,48,49,0.18,0.82000000000000006,54,36]
[null,50,52,0.12,0.88,55,37]
[null,53,57,7.0000000000000007E-2,0.92999999999999994,58,39]
[null,58,62,0.02,0.98,61,40]
[null,"NOTE: This table is based on national average 5,200 degree-days."]
[]
[null,"Table of Constants and Parameters",null,null,null,null,null,"Output Capacity (Btu/h) DHR (kBtu/h) Table 8"]
[null,"Name","Constant or Parameter","ANSI/ASHRAE Section","Value","Unit",null,"Range",null,"DHR"]
[null,"Factor That Adjusts Jacket Losses Measured","K","11.2.8.1",1.7,"Factor",null,"Low","High"]
[null,"Average Outdoor Temperature","TOA","11.2.8.4",42,"°F",null,5000,10000,5]
[null,"Specific Heat of Air","CP","11.2.9.1",0.24,"Btu/(lb·°F)",null,11000,16000,10]
[null,"Infiltration Parameter","φ","11.2.9.2",0.7,"Factor",null,17000,25000,15]
[null,"Time One","t1","11.2.9.4",0.5,"min",null,26000,42000,20]
[null,"Time Two","t2","11.2.9.4",2.5,"min",null,43000,59000,30]
[null,"Time Three","t3","11.2.9.6",1.5,"min",null,60000,76000,40]
[null,"Time Four","t4","11.2.9.7",9,"min",null,77000,93000,50]
[null,"Time Five","t5","11.2.9.8","∞","min",null,94000,110000,60]
[null,"Off-Cycle Draft Factor for Stack Gas Flow Without Stack Damper","Ds°","11.2.9.9",0.4,"Factor",null,111000,127000,70]
[null,"Correction Factor for Units Using Intermittent or Interrupted Ignition Devices","CIID","11.2.9.14",{"$f":"IF('General Info & Test Results'!C46=\"Continuous Pilot\",1,IF('General Info & Test Results'!C46=\"Intermittent or Interrupted Pilot\",0.9,\"\"))","v":""},"Factor",null,127000,144000,80]
[null,"Outdoor Air Correction Factor","C'S","11.2.9.15",1.22,"Factor",null,145000,161000,90]
[null,"Jacket Loss Factor","CJ","11.4.9.2.3",{"$f":"IF(Installation_Type=\"Indoor/Isolated Combustion System\", 1.7, 3.3)","v":3.3},"Factor",null,162000,178000,100]
[null,"On-Time Per Cycle","tON","11.2.9.11/11.4.9.11",{"$f":"IF(OR(Calculation_Section=11.2,Calculation_Section=11.3), 3.87, 10)","v":{"$error":"#VALUE!"}},"min",null,179000,195000,110]
[null,"Off-Time Per Cycle","tOFF","11.2.9.12/11.4.9.12",{"$f":"IF(OR(Calculation_Section=11.2,Calculation_Section=11.3), 13.3, 10)","v":{"$error":"#VALUE!"}},"min",null,196000,"+",130]
[null,"Conversion to Express Energy in Terms of kWh Instead of Btu","-","Table 1 of ENERGY STAR Interim Approach for Determining Furnace Fan Energy use",3412,"-"]
[null,"Total Number of Hours Per Year","-",null,8760,"Hours"]
[null,"Average Non-Heating Season Hours Per Year","-",null,4600,"Hours"]

{"sheet":"Version Control","index":16,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:","Consumer Furnace"]
[null,"Version Number:",{"$f":"INDEX(B13:B62,COUNTA(B13:B62),1)","v":"v2.0"}]
[null,"Latest Template Revision: ",{"$f":"IF(MAX(B13:C104)=0,\"No Revisions Dates Entered\",MAX(C13:C104))","v":"2019-08-22"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Version Control"}]
[null,"File Name:",{"$f":"MID(CELL(\"FILENAME\",F16),FIND(\"[\",CELL(\"FILENAME\",F16))+1,FIND(\"]\",CELL(\"FILENAME\",F16))-FIND(\"[\",CELL(\"FILENAME\",F16))-1)","v":"Consumer Furnaces - v2.0.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'General Info & Test Results'!C17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Revisions List"]
[null,"Version","Date"]
[null,1,"2012-08-20"]
[null,1.1000000000000001,"2013-01-07"]
[null,1.2,"2013-03-01"]
[null,"1.5_draft3","2013-06-07"]
[null,"1.5_draft4","2013-08-01"]
[null,"1.5_draft5","2013-08-05"]
[null,"v1.5_draft6","2015-06-05"]
[null,"v1.6","2017-07-06"]
[null,"v2.0","2019-08-22"]