{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Instructions","Max Input Data","Reduced Input Data","Optional Test Data","General Info & Test Results","Instrumentation","Test Conditions","Max Test","Reduced Test","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":0,"defined_names":29,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":67,"n_cols":3,"rows_kept":67,"cut":false,"hidden":false,"merged":[[39,1,41,2],[42,1,43,2],[44,1,45,1],[44,2,45,2],[1,1,1,2],[30,1,30,2],[31,1,32,1],[33,1,36,1],[10,1,10,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"}]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Instructions"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Residential Condensing Gas Furnace - v1.6.xlsm"}]
[]
[]
[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,"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","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":"Residential Condensing Gas 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":"v1.6"},null,null,null,null,null,null,"• Watts"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"},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":"Residential Condensing Gas Furnace - v1.6.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":"Residential Condensing Gas 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":"v1.6"},null,null,null,null,null,null,"• Watts"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"},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":"Residential Condensing Gas Furnace - v1.6.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":"Residential Condensing Gas 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":"v1.6"},null,null,null,null,null,null,"• Surface Temperature"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"},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":"Residential Condensing Gas Furnace - v1.6.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":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[[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":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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(C49=\"Single Stage\",'Test Data Inputs & Calculations'!H36,IF(C49=\"Two-Stage Modulating\",'Test Data Inputs & Calculations'!H51,IF(C49=\"Step Modulating\",'Test Data Inputs & Calculations'!H52,\"\")))","v":""},"% (0-100)"]
[null,null,null,null,"Heating Seasonal Efficiency",{"$f":"IF(C49=\"Single Stage\",'Test Data Inputs & Calculations'!G134,IF(C49=\"Two-Stage Modulating\",'Test Data Inputs & Calculations'!G135,IF(C49=\"Step Modulating\",'Test Data Inputs & Calculations'!G136,\"\")))","v":""},"% (0-100)"]
[null,"Test Information",null,null,"Annual Fuel Utilization Efficiency",{"$f":"IF(C49=\"Single Stage\",AFUEONE_round,IF(C49=\"Two-Stage Modulating\",AFUETWO_round,IF(C49=\"Step Modulating\",AFUEMOD_round,\"\")))","v":""},"% (0-100)"]
[null,"Date Test Started:","[MM/DD/YYYY]",null,"Furnace Fan Efficiency",{"$f":"IF('Test Data Inputs & Calculations'!G147<>\"\",'Test Data Inputs & Calculations'!G147*100,\"\")","v":""},"% (0-100)"]
[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:","[MM/DD/YYYY]",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,"Product Type: ","Condensing Gas Furnace",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 Voltage (V):"]
[null,"Nameplate Maximum Input (Btu/h):"]
[null,"Nameplate Reduced Input (Btu/h):"]
[null,"Outer Dimensions (in):"]
[null,"     Height"]
[null,"     Width"]
[null,"     Depth"]
[]
[null,"Product Characteristics"]
[null,"System Number:"]
[null,"Heating Medium:"]
[null,"Circulation Type:"]
[null,"Heating Energy Source:"]
[null,"Burner Type:"]
[null,"Ignition Type:"]
[null,"Draft Equipment:"]
[null,"Off Cycle Devices:"]
[null,"Installation:"]
[null,"Flue Gas Type:"]
[null,"Control Type:"]
[null,"Reduced Test Required?",{"$f":"IF(C49=\"\",\"\",IF(OR(C49=\"Two-Stage Modulating\",C49=\"Step Modulating\"),\"Yes\",\"No\"))","v":""}]
[null,"Type of Gas Used:"]

{"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":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Instrumentation"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Residential Condensing Gas Furnace - v1.6.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":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[[1,1,1,2],[54,1,54,4],[11,1,11,3],[46,1,46,3],[19,1,19,2],[25,1,25,2],[32,1,32,3],[39,1,39,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'Version Control'!C8","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"1. Gas Supply Pressure"]
[null,"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":"IF('General Info & Test Results'!C51=\"Natural Gas\",'Drop-Downs and Tables'!E20,IF('General Info & Test Results'!C51=\"Manufactured Gas\",'Drop-Downs and Tables'!E21,IF('General Info & Test Results'!C51=\"Butane\",'Drop-Downs and Tables'!E22,IF('General Info & Test Results'!C51=\"Propane\",'Drop-Downs and Tables'!E23,\"\"))))","v":""},{"$f":"IF('General Info & Test Results'!C51=\"Natural Gas\",'Drop-Downs and Tables'!F20,IF('General Info & Test Results'!C51=\"Manufactured Gas\",'Drop-Downs and Tables'!F21,IF('General Info & Test Results'!C51=\"Butane\",'Drop-Downs and Tables'!F22,IF('General Info & Test Results'!C51=\"Propane\",'Drop-Downs and Tables'!F23,\"\"))))","v":""}]
[null,null,"Maximum Test","Reduced Test"]
[null,"Measured Test Pressure (in. water)"]
[null,"Condition Met?",{"$f":"IF(OR(C16=\"\"),\"\",IF(AND(C16>=C14,C16<=D14),\"Yes\",\"No\"))","v":""},{"$f":"IF(OR(D16=\"\"),\"\",IF(AND(D16>=C14,D16<=D14),\"Yes\",\"No\"))","v":""}]
[]
[null,"2. Higher Heating Value"]
[null,"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/lb)",{"$f":"IF('Test Data Inputs & Calculations'!C13=\"\",\"\",'Test Data Inputs & Calculations'!C13)","v":""}]
[null,"Measured HHV (Btu/lb)"]
[null,"Condition Met?",{"$f":"IF(C22=\"\",\"\",IF(ISNUMBER(C21),IF(ABS(C21-C22)/C21<=0.05,\"Yes\",\"No\"),\"Select Gas Type\"))","v":""}]
[]
[null,"3. 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."]
[null,"Nameplate Voltage (V)",{"$f":"IF('General Info & Test Results'!C30=\"\",\"\",'General Info & Test Results'!C30)","v":""}]
[null,"Minimum Voltage (V)"]
[null,"Maximum Voltage (V)"]
[null,"Condition Met?",{"$f":"IF(OR(C28=\"\",C29=\"\"),\"\",IF(AND(ABS(C27-C28)/C27<=0.01,ABS(C27-C29)/C27<=0.01),\"Yes\",\"No\"))","v":""}]
[]
[null,"4. Gas Supply Input Rate"]
[null,"Adjust burner to within ± 2% of the hourly Btu nameplate maximum and reduced input rates."]
[null,null,"Maximum Test","Reduced Test"]
[null,"Nameplate Rate (Btu/h)",{"$f":"IF('General Info & Test Results'!C31=\"\",\"\",'General Info & Test Results'!C31)","v":""},{"$f":"IF('General Info & Test Results'!C32=\"\",\"\",'General Info & Test Results'!C32)","v":""}]
[null,"Measured Rate (Btu/h)"]
[null,"Condition Met?",{"$f":"IF(C36=\"\",\"\",IF(ABS(C35-C36)/C35<=0.02,\"Yes\",\"No\"))","v":""},{"$f":"IF(D36=\"\",\"\",IF(ABS(D35-D36)/D35<=0.02,\"Yes\",\"No\"))","v":""}]
[]
[null,"5. Static Pressure Measurement"]
[null,"The minimum external static pressure shall be obtained by symmetrically restricting the outlet of the test duct to the required values."]
[null,null,"Maximum Test"]
[null,"Required Static Pressure (in. water)",{"$f":"IF(SUMIF('Drop-Downs and Tables'!E28:E32,\"=Yes\",'Drop-Downs and Tables'!D28:D32)=0,\"\", SUMIF('Drop-Downs and Tables'!E28:E32,\"=Yes\",'Drop-Downs and Tables'!D28:D32))","v":""}]
[null,"Measured Static Pressure (in. water)"]
[null,"Condition Met?",{"$f":"IF(C43=\"\",\"\",IF(C43>=C42,\"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(C49=\"\",C50=\"\",C51=\"\"),\"\",IF(AND(ABS(C50-C49)<=5,ABS(C49-C51)<=5),\"Yes\",\"No\"))","v":""},{"$f":"IF(OR(D49=\"\",D50=\"\",D51=\"\"),\"\",IF(AND(ABS(D50-D49)<=5,ABS(D49-D51)<=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(C58=\"\",\"\",IF(C57=\"No\",IF(C58<10,\"Yes\",\"No\"),IF(C58<20,\"Yes\",\"No\")))","v":""},"-","-"]
[null,"Jacket Loss Factor Determination Method",null,"-","-"]
[null,"Summation of Hourly Heat Loss Through Jacket",null,"Btu","HS"]
[null,"Jacket Loss Factor",{"$f":"IF(C60=\"Default Value\",1,IF(C60=\"Optional Test\",(C61/'Max Test'!C21)*100,\"\"))","v":""},"% (0-100)","LJ"]
[]
[null,"8. Tracer Gas Draft Factors"]
[null,"Measurements","Value","Variable"]
[null,"Optional Tracer Gas Procedure Used?",null,"-"]
[null,"Power Burner Draft Factor",null,"DP"]
[null,"Off-Cycle Draft Factor for Flue Gas Flow",{"$f":"IF(C66=\"No\",0.4,IF(C66=\"Yes\",C67,\"\"))","v":""},"DF"]
[]
[null,"9. \"Standby\" and \"Off\" Power Measurement"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Standby Power Measurement",null,"W","PW,SB"]
[null,"Off Mode Power Measurement",null,"W","PW,OFF"]

{"sheet":"Max Test","index":7,"n_rows":79,"n_cols":6,"rows_kept":79,"cut":false,"hidden":false,"merged":[[11,1,11,2],[49,1,49,4],[18,1,18,4],[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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]
[null,15]
[null,30]
[]
[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('General Info & Test Results'!C31=\"\",\"\",'General Info & Test Results'!C31)","v":""},"Btu/h","QIN"]
[null,"Steady State Electrical Power to Burner",null,"kW","PE"]
[null,"Steady State Electrical Power to Conditioned Air Blowers",null,"kW","BE"]
[null,"Room Temperature",null,"°F","TRA"]
[null,"Steady State Flue Gas Temperature",{"$f":"IF(ISERROR(AVERAGE(C14:C16)),\"\", AVERAGE(C14:C16))","v":""},"°F","TF,SS"]
[null,"Concentration by Volume of CO2",null,"% (0-100)","XCO2F"]
[]
[null,"Measurement of Steady-State Condensate"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Steady-State Test",null,"% (0-100)","-"]
[null,"Humidity Condition Met?",{"$f":"IF(C30=\"\",\"\",IF(C30>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Fuel Higher Heating Value",{"$f":"IF('Test Conditions'!C22=\"\", \"\",'Test Conditions'!C22)","v":""},"Btu/lb","HHV"]
[null,"Condensing Fuel Energy Input at Steady-State Operation",null,"Btu","QC,SS"]
[null,"Total Container and Condensate Weight",null,"lb","-"]
[null,"Tare Container Weight",null,"lb","-"]
[null,"Mass of Condensate for the Steady-State Test",{"$f":"IF(C34-C35=0,\"\",C34-C35)","v":""},"lb","MC,SS"]
[]
[null,"Flue Temperature Measurements Cool-Down Test"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Is Post Purge Time Less Than or Equal to 30 seconds?",null,"-","-"]
[null,"Post Purge Time (Enter \"N/A\" if less than or equal to  30 seconds)",null,"sec","tp"]
[null,"Temperature at Purge",null,"°F","TF,OFF(tp)"]
[null,"Temperature 1.5 minutes after Purge",null,"°F","TF,OFF(t3)"]
[null,"Temperature 9 minutes after Purge",null,"°F","TF,OFF(t4)"]
[null,"Off Period Minimum Flue Gas Temperature (Equilibrium)",null,"°F","TF,OFF(t5)"]
[null,"Burner and Blower Off Time Delay",null,"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,"Blower Start Time Delay",null,"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(C58=\"\",\"\",IF(C58>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(C60=\"\",C61=\"\"),\"\", IF(ABS(C60-C61)<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(C66=\"\",C68=\"\",C70=\"\"),\"\",IF(STDEV(C66,C68,C70)<(0.2*AVERAGE(C66,C68,C70)),\"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(C65,C67,C69,C72,C74,C76)=0,\"\",SUM(C65,C67,C69,C72,C74,C76))","v":""},"Btu","QC"]
[null,"Total Condensate Collected",{"$f":"IF(SUM(C66,C68,C70,C73,C75,C77)=0,\"\",SUM(C66,C68,C70,C73,C75,C77))","v":""},"lb","MC"]

{"sheet":"Reduced Test","index":8,"n_rows":78,"n_cols":6,"rows_kept":78,"cut":false,"hidden":false,"merged":[[18,1,18,4],[48,1,48,4],[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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]
[null,15]
[null,30]
[]
[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('General Info & Test Results'!C32=\"\",\"\",'General Info & Test Results'!C32)","v":""},"Btu/h","QIN"]
[null,"Steady State Electrical Power to Burner",null,"kW","PE"]
[null,"Steady State Electrical Power to Conditioned Air Blowers",null,"kW","BE"]
[null,"Room Temperature",null,"°F","TRA"]
[null,"Steady State Flue Gas Temperature",{"$f":"IF(ISERROR(AVERAGE(C14:C16)),\"\", AVERAGE(C14:C16))","v":""},"°F","TF,SS"]
[null,"Concentration by Volume of CO2",null,"% (0-100)","XCO2F"]
[]
[null,"Measurement of Steady-State Condensate"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Maximum Humidity During Steady-State Test",null,"% (0-100)","-"]
[null,"Humidity Condition Met?",{"$f":"IF(C30=\"\",\"\",IF(C30>80, \"No\",\"Yes\"))","v":""},"-","-"]
[null,"Fuel Higher Heating Value",{"$f":"IF('Test Conditions'!C22=\"\", \"\",'Test Conditions'!C22)","v":""},"Btu/lb","HHV"]
[null,"Condensing Fuel Energy Input at Steady-State Operation",null,"Btu","QC,SS"]
[null,"Total Container and Condensate Weight",null,"lb","-"]
[null,"Tare Container Weight",null,"lb","-"]
[null,"Mass of Condensate for the Steady-State Test",{"$f":"IF(C34-C35=0,\"\",C34-C35)","v":""},"lb","MC,SS"]
[]
[null,"Flue Temperature Measurements Cool-Down Test"]
[null,"Measurements","Value","Unit","Variable"]
[null,"Is Post Purge Time Less Than or Equal to 30 seconds?",null,"-","-"]
[null,"Post Purge Time (Enter \"N/A\" if less than or equal to  30 seconds)",null,"sec","tp"]
[null,"Temperature 1.5 minutes after Purge",null,"°F","TF,OFF(t3)"]
[null,"Temperature 9 minutes after Purge",null,"°F","TF,OFF(t4)"]
[null,"Off Period Minimum Flue Gas Temperature (Equilibrium)",null,"°F","TF,OFF(t5)"]
[null,"Burner and Blower Off Time Delay",null,"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,"Blower Start Time Delay",null,"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(C57=\"\",\"\",IF(C57>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(C59=\"\",C60=\"\"),\"\", IF(ABS(C59-C60)<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(C65=\"\",C67=\"\",C69=\"\"),\"\",IF(STDEV(C65,C67,C69)<(0.2*AVERAGE(C65,C67,C69)),\"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(C64,C66,C68,C71,C73,C75)=0,\"\",SUM(C64,C66,C68,C71,C73,C75))","v":""},"Btu","QC"]
[null,"Total Condensate Collected",{"$f":"IF(SUM(C65,C67,C69,C72,C74,C76)=0,\"\",SUM(C65,C67,C69,C72,C74,C76))","v":""},"lb","MC"]

{"sheet":"Photos","index":9,"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":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Photos"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Residential Condensing Gas Furnace - v1.6.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":10,"n_rows":149,"n_cols":12,"rows_kept":149,"cut":false,"hidden":false,"merged":[[2,3,2,4],[142,1,148,1],[3,6,3,7],[10,1,10,11],[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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('General Info & Test Results'!C51=\"\",\"\", 'General Info & Test Results'!C51)","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!C36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!C37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!C38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!C39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!D36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!D37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!D38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!D39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!E36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!E37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!E38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!E39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!F36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!F37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!F38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!F39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!G36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!G37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!G38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!G39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!H36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!H37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!H38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!H39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!I36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!I37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!I38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!I39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!J36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!J37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!J38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!J39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!K36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!K37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!K38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!K39)))))","v":""},{"$f":"IF($B$13=\"\",\"\",IF($B$13='Drop-Downs and Tables'!$B$36,'Drop-Downs and Tables'!L36,IF($B$13='Drop-Downs and Tables'!$B$37,'Drop-Downs and Tables'!L37,IF($B$13='Drop-Downs and Tables'!$B$38,'Drop-Downs and Tables'!L38,IF($B$13='Drop-Downs and Tables'!$B$39,'Drop-Downs and Tables'!L39)))))","v":""}]
[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,null,null,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","Calculated Result (rounded per significant figures conventions and instrumentation resolution)","Unit"]
[null,"11.5.1","System Number",null,"-","11.2.1",{"$f":"'General Info & Test Results'!C39","v":0},null,"-"]
[null,"11.5.2","Ratio of Combustion Air to Stoichiometric Air (Max)",null,"RT,F","11.2.2",{"$f":"F13+(G13/'Max Test'!C26)","v":{"$error":"#VALUE!"}},null,"Ratio"]
[null,"11.5.2","Ratio of Combustion Air to Stoichiometric Air (Reduced)",null,"RT,F,R","11.2.2",{"$f":"F13+(G13/'Reduced Test'!C26)","v":{"$error":"#VALUE!"}},null,"Ratio"]
[null,"11.5.3","Not Applicable"]
[null,"11.5.4","Average Ratio of Stack gas Mass Flow rate to Flue gas Mass flow rate",null,"S/F","11.2.4",1,null,"Ratio"]
[null,"11.5.5","Steady State Flue Temperature Rise (Max)",null,"ΔTF,SS","11.2.5",{"$f":"'Max Test'!C25-'Max Test'!C24","v":{"$error":"#VALUE!"}},null,"°F"]
[null,"11.5.5","Steady State Flue Temperature Rise (Reduced)",null,"ΔTF,SS,R","11.2.5",{"$f":"'Reduced Test'!C25-'Reduced Test'!C24","v":{"$error":"#VALUE!"}},null,"°F"]
[null,"11.5.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/C13 * (SUM( ((1+D13) * (CFi) + D13 * (G22-1) * (CAi)) * ((TFSSH + 460)^i - (TRAH + 460)^i)))","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.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/C13 * (SUM( ((1+D13) * (CFi) + D13 * (G23-1) * (CAi)) * ((TFSSR + 460)^i- (TRAR + 460)^i)))","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.6","Average Latent heat loss of test fuel used (Max)",null,"LL,A","Table 7",{"$f":"$E$13","v":""},null,"% (0-100)"]
[null,"11.5.6","Average Latent heat loss of test fuel used (Reduced)",null,"LL,A,R","Table 7",{"$f":"$E$13","v":""},null,"% (0-100)"]
[null,"11.5.7.1","Latent Heat Gain Due to Condensation Under Steady State Conditions (MAX)",null,"LG,SS,H","11.3.7.1",{"$f":"(100*(1053.3)*'Max Test'!$C$36)/'Max Test'!$C$33","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.7.1","Latent Heat Gain Due to Condensation Under Steady State Conditions (Reduced)",null,"LG,SS,R","11.3.7.1",{"$f":"(100*(1053.3)*'Reduced Test'!$C$36)/'Reduced Test'!$C$33","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.7.2","Steady-State Heat Loss due to Hot condensate Going Down the Drain (Max)",null,"LC,SS,H","11.3.7.2",{"$f":"($G$32*(1*(TFSSH-70)-0.45*(TFSSH-'Drop-Downs and Tables'!$E$62)))/1053.3","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.7.2","Steady-State Heat Loss due to Hot condensate Going Down the Drain (Reduced)",null,"LC,SS,R","11.3.7.2",{"$f":"($G$33*(1*(TFSSR-70)-0.45*(TFSSR-'Drop-Downs and Tables'!$E$62)))/1053.3","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.7.3","Steady State Efficiency (Max)",null,"EffySS,H","11.3.7.3",{"$f":"100-(G30+G28-G32+G34)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.7.3","Steady State Efficiency (Reduced)",null,"EffySS,R","11.3.7.3",{"$f":"100-(G31+G29-G33+G35)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[]
[null,"Weighted-Average Steady State Efficiency"]
[null,"ANSI/ASHRAE Section","Variable Name","Equation / Instructions","Variable","Equation Section","Value","Calculated Result (rounded per significant figures conventions and instrumentation resolution)","Unit"]
[null,"11.5.8.1.1","Maximum Fuel Input Rate Heating Capacity",null,"QOUT","11.4.8.1",{"$f":"ROUND(('Max Test'!C21*(G36-('Drop-Downs and Tables'!$E$61*'Test Conditions'!$C$62)))/100,-3)","v":{"$error":"#VALUE!"}},null,"Btu/h"]
[null,"11.5.8.1.2","Reduced Fuel Input rate Heating Capacity",null,"QOUT,R","11.4.8.1",{"$f":"ROUND(('Reduced Test'!C21*(G37-'Drop-Downs and Tables'!$E$61*'Test Conditions'!$C$62))/100,-3)","v":{"$error":"#VALUE!"}},null,"Btu/h"]
[null,"11.5.8.2","Design Heating Requirement","Use Table 8 (Multiply KDHR by 1000)","DHR","11.4.8.2",null,null,"Btu/h"]
[null,"11.5.8.3","Oversize Factor ",null,"α","11.4.8.3",{"$f":"IF(Reduced_Test_Required=\"No\",0.7,(G41/G43)-1)","v":{"$error":"#VALUE!"}},null,"Factor"]
[null,"11.5.8.5","Balance-Point Temperature",null,"TC","11.4.8.5",{"$f":"IF(65-((60)*(1+G44)*(G42/G41))<0,0,65-((60)*(1+G44)*(G42/G41)))","v":{"$error":"#VALUE!"}},null,"°F"]
[null,"11.5.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",null,null,"°F"]
[null,"11.5.8.4","Average Outdoor Temperature (Reduced)","Use Figure 23 or Table 10","TOA,R","11.4.8.4",null,null,"°F"]
[null,"11.5.8.6","Fraction of Heating Load at Maximum Fuel Input Rate Operating Mode","Use Figure 24 or Table 10","XH","11.4.8.6",null,null,"Ratio"]
[null,"11.5.8.7","Fraction of Heating Load at Reduced Fuel input Rate Operating Mode","Use Figure 24 or Table 10","XR","11.4.8.7",null,null,"Ratio"]
[null,"11.5.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":"IF(G42>G43,G37,((G43-G42)/(G41-G42))*((G45-G46)/(G45-5))*(G36-G37)+G37)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.8.9","Weighted-Average Steady-State Efficiency (Two-Stage)",null,"EffySS,W","11.4.8.9",{"$f":"(G48)*(G36)+(G49)*(G37)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.8.9","Weighted-Average Steady-State Efficiency (Step Modulating)",null,"EffySS,W","11.4.8.9",{"$f":"(G48)*(G50)+(G49)*(G37)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.8.9","Weighted-Average Steady-State Efficiency",null,"EffySS,W","11.4.8.9",{"$f":"IF('General Info & Test Results'!C49=\"Two-Stage Modulating\",'Test Data Inputs & Calculations'!G51,IF('General Info & Test Results'!C49=\"Step Modulating\",'Test Data Inputs & Calculations'!G52,\"\"))","v":""},null,"% (0-100)"]
[null,"11.5.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":"(G43-G41)*((G45-G46)/(G45-5))+G42","v":{"$error":"#VALUE!"}},null,"Btu/h"]
[]
[null,"Calculations Not Affected by Outside Air"]
[null,"ANSI/ASHRAE Section","Variable Name","Equation / Instructions","Variable","Equation Section","Value","Unit"]
[null,"11.5.9.1","Multiplication Factor For Sensible Heat Loss During Burner On-Cycle (Max)",null,"KS,ON,H","11.2.9.1",{"$f":"(100*'Drop-Downs and Tables'!E63*(1+(G22)*($D$13)))/$C$13","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.9.1","Multiplication Factor For Sensible Heat Loss During Burner On-Cycle (Reduced)",null,"KS,ON,R","11.2.9.1",{"$f":"(100*'Drop-Downs and Tables'!E63*(1+(G23)*($D$13)))/$C$13","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.9.2","Multiplication Factor for Infiltration Loss During Burner On-Cycle (Max)",null,"KI,ON,H","11.2.9.2",{"$f":"IF(OR('General Info & Test Results'!C39=10,'General Info & Test Results'!C39=9),0,0.7*$G$25*G58)","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.9.2","Multiplication Factor for Infiltration Loss During Burner On-Cycle (Reduced)",null,"KI,ON,R","11.2.9.2",{"$f":"IF(OR('General Info & Test Results'!C39=10,'General Info & Test Results'!C39=9),0,0.7*$G$25*G59)","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.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":"((G61)*(70-G47)+(G60)*(70-G46))/2","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.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":"G50-'Test Conditions'!C62*'Drop-Downs and Tables'!E73","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.9.3","Not Applicable"]
[null,"11.5.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'!C53>='Max Test'!C25,TFSSH-0.2,IF('Max Test'!C53>=G66,G66-0.1,'Max Test'!C53))","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.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'!C54>='Max Test'!C25,'Max Test'!C25-0.1,'Max Test'!C54)","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.9.4","On-Cycle Time Constant (Max)",null,"τON,H","11.2.9.4",{"$f":"('Drop-Downs and Tables'!$E$66-'Drop-Downs and Tables'!$E$65)/(LN(('Max Test'!C25-'Test Data Inputs & Calculations'!G65)/('Max Test'!C25-'Test Data Inputs & Calculations'!G66)))","v":{"$error":"#VALUE!"}},"min"]
[null,"11.5.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'!C52>='Reduced Test'!C25,IF('Reduced Test'!C52>=G66,G66-0.1,'Reduced Test'!C25-0.2),'Reduced Test'!C52)","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.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'!C53>='Reduced Test'!C25,'Reduced Test'!C25-0.1,'Reduced Test'!C53)","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.9.4","On-Cycle Time Constant (Reduced)",null,"τON,R","11.2.9.4",{"$f":"('Drop-Downs and Tables'!$E$66-'Drop-Downs and Tables'!$E$65)/(LN(('Reduced Test'!C25-'Test Data Inputs & Calculations'!G68)/('Reduced Test'!C25-'Test Data Inputs & Calculations'!G69)))","v":{"$error":"#VALUE!"}},"min"]
[null,"11.5.9.5","Effective Flue Gas Temperature Difference at Start-Up (Max)",null,"θF,O,X,H","11.2.9.5",{"$f":"(TFSSH-G65)*EXP('Drop-Downs and Tables'!E65/G67)","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.9.5","Effective Flue Gas Temperature Difference at Start-Up (Reduced)",null,"θF,O,X,R","11.2.9.5",{"$f":"(TFSSR-G68)*EXP('Drop-Downs and Tables'!E65/G70)","v":{"$error":"#VALUE!"}},"°F"]
[null,"11.5.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":"'Max Test'!C43","v":0},"°F"]
[null,"11.5.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":"'Max Test'!C44","v":0},"°F"]
[null,"11.5.9.6","Minimum Flue gas Temperature for Furnaces",null,"TF,OFF(t5),H",9.5,{"$f":"'Max Test'!C45","v":0},"°F"]
[null,"11.5.9.6","Off-Cycle Time Constant (MAX)",null,"τOFF, H","11.2.9.6",{"$f":"('Drop-Downs and Tables'!$E$68-'Drop-Downs and Tables'!$E$67)/LN((G73-G75)/(G74-G75))","v":{"$error":"#DIV/0!"}},"min"]
[null,"11.5.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":"'Reduced Test'!C42","v":0},"°F"]
[null,"11.5.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":"'Reduced Test'!C43","v":0},"°F"]
[null,"11.5.9.6","Minimum Flue gas Temperature for Furnaces",null,"TF,OFF(t5),R",9.5,{"$f":"'Reduced Test'!C44","v":0},"°F"]
[null,"11.5.9.6","Off-Cycle Time Constant (Reduced)",null,"τOFF,R","11.2.9.6",{"$f":"('Drop-Downs and Tables'!$E$68-'Drop-Downs and Tables'!$E$67)/LN((G77-G79)/(G78-G79))","v":{"$error":"#DIV/0!"}},"min"]
[null,"11.5.9.7","Effective Flue Gas Temperature at Shutdown (MAX)",null,"ψF,O,X,H","11.2.9.7",{"$f":"(G73-G75)*EXP('Drop-Downs and Tables'!E67/G76)","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.9.7","Effective Flue Gas Temperature at Shutdown (Reduced)",null,"ψF,O,X,R","11.2.9.7",{"$f":"(G77-G79)*EXP('Drop-Downs and Tables'!E67/G80)","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.9.8","Minimum Flue Gas Temperature Difference Above Room Temperature (Max)",null,"ψF,∞,X,H","11.2.9.8",{"$f":"G75-'Max Test'!C24","v":0},"°F"]
[null,"11.5.9.8","Minimum Flue Gas Temperature Difference Above Room Temperature (Reduced)",null,"ψF,∞,X,R","11.2.9.8",{"$f":"G79-'Reduced Test'!C24","v":0},"°F"]
[null,"11.5.9.9","Minimum Stack Gas Temperature Difference Above Room Temperature (Max)",null,"ψS,∞,X,H","11.2.9.9",{"$f":"G83","v":0},"°F"]
[null,"11.5.9.9","Minimum Stack Gas Temperature Difference Above Room Temperature (Reduced)",null,"ψS,∞,X,R","11.2.9.9",{"$f":"G84","v":0},"°F"]
[null,"11.5.9.10","Not Applicable"]
[null,"11.5.9.11","Ratio of Average Burner On-Time per cycle to On-Cycle Time Constant (Max)",null,"RON,H","11.2.9.11",{"$f":"'Drop-Downs and Tables'!$E$74/G67","v":{"$error":"#VALUE!"}},"ratio"]
[null,"11.5.9.11","Ratio of Average Burner On-Time per cycle to On-Cycle Time Constant (Reduced)",null,"RON,R","11.2.9.11",{"$f":"'Drop-Downs and Tables'!$E$74/G70","v":{"$error":"#VALUE!"}},"ratio"]
[null,"11.5.9.12","Ratio of Average Burner Off-Time per cycle to Off-Cycle Time Constant (Max)",null,"ROFF,H","11.2.9.12",{"$f":"'Drop-Downs and Tables'!$E$75/G76","v":{"$error":"#DIV/0!"}},"ratio"]
[null,"11.5.9.12","Ratio of Average Burner Off-Time per cycle to Off-Cycle Time Constant (Reduced)",null,"ROFF,R","11.2.9.12",{"$f":"'Drop-Downs and Tables'!$E$75/G80","v":{"$error":"#DIV/0!"}},"ratio"]
[null,"11.5.9.13","Start-Up Burner Cycling Effect Correction Factor (Max)",null,"CT,ON,H","11.2.9.13",{"$f":"((1-((G81)*EXP(-G90))/('Max Test'!C25-G75))/(1-((G71)*(G81)*(EXP(-1*(G88+G90))))/('Max Test'!C25-G75)^2))","v":{"$error":"#DIV/0!"}},"Factor"]
[null,"11.5.9.13","Start-Up Burner Cycling Effect Correction Factor (Reduced)",null,"CT,ON,R","11.2.9.13",{"$f":"(((1-((G82)*EXP(-G91))/('Reduced Test'!C25-G79))/(1-((G72)*(G82)*(EXP(-1*(G89+G91))))/('Reduced Test'!C25-G79)^2)))","v":{"$error":"#DIV/0!"}},"Factor"]
[null,"11.5.9.14","Shutdown  Burner Cycling Effect Correction Factor (Max)",null,"CT,OFF,H","11.2.9.14",{"$f":"('Drop-Downs and Tables'!$E$71)*((1-((G71*EXP(-G88))/(TFSSH-G75)))/(1-(G71*G81*EXP(-1*(G88+G90)))/(TFSSH-G75)^2 ))","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.9.14","Shutdown  Burner Cycling Effect Correction Factor (Reduced)",null,"CT,OFF,R","11.2.9.14",{"$f":"('Drop-Downs and Tables'!$E$71)*((1-(G72*EXP(-G89))/(TFSSR-G79))/(1-((G72*G82*EXP(-1*(G89+G91)))/(TFSSR-G79)^2 ) ))","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.9.15","Effective Flue Gas temperature Difference at Burner Shutdown (Max)",null,"ψF,O,H","11.2.9.15",{"$f":"G81*G94*'Drop-Downs and Tables'!$E$72","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.9.15","Effective Flue Gas temperature Difference at Burner Shutdown (Reduced)",null,"ψF,O,R","11.2.9.15",{"$f":"G82*G95*'Drop-Downs and Tables'!$E$72","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.9.16","Minimum Effective Flue Gas Temperature Difference Above Room Temperature",null,"ψF,∞, H","11.2.9.16",{"$f":"G83*'Drop-Downs and Tables'!$E$72","v":0},"°F"]
[null,"11.5.9.16","Minimum Effective Flue Gas Temperature Difference Above Room Temperature",null,"ψF,∞, R","11.2.9.16",{"$f":"G84*'Drop-Downs and Tables'!$E$72","v":0},"°F"]
[null,"11.5.9.17","Not Applicable"]
[null,"11.5.9.18","Off-Cycle Stack Gas Draft Factor",null,"DS","11.2.9.18",0.4,"Factor"]
[null,"11.5.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(G96, G90)","v":{"$error":"#NAME?"}},"Factor"]
[null,"11.5.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(G96, G90)","v":{"$error":"#NAME?"}},"Factor"]
[null,"11.5.9.19","Off-Cycle Sensible Heat Loss Integration Factor F5","Use Figure 16 and ψF,O and ROFF","F5R","11.2.9.19",{"$f":"Int_F5(G97, G91)","v":{"$error":"#NAME?"}},"Factor"]
[null,"11.5.9.19","Off-Cycle Sensible Heat Loss Integration Factor F6","Use Figure 17 and ψF,O and ROFF","F6R","11.2.9.19",{"$f":"Int_F6(G97, G91)","v":{"$error":"#NAME?"}},"Factor"]
[]
[null,"Calculations Affected by Outside Air"]
[null,"ANSI/ASHRAE Section","Variable Name","Variable","Equation Section","Value","Unit"]
[null,"11.5.10.1","Correction Factor That Corrects for the Use of Outside Air for Combustion","CS,H","11.3.10.1",{"$f":"(TFSSH-G46)/(TFSSH-TRAH)","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.10.1","Correction Factor That Corrects for the Use of Outside Air for Combustion","CS,R","11.3.10.1",{"$f":"(TFSSR-G47)/(TFSSR-TRAR)","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.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":"G92*F109*G71","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.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":"G93*F110*G72","v":{"$error":"#DIV/0!"}},"°F"]
[null,"11.5.10.3","Multiplication Factor for Sensible Heat Loss During the Burner Off-Cycle (Max)","KS,OFF,H","11.2.10.3",{"$f":"((TFSSH-TRAH+530)^(1.19)*('Test Conditions'!$C$68*G58))/(TFSSH-TRAH+70-G46)^0.56","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.10.3","Multiplication Factor for Sensible Heat Loss During the Burner Off-Cycle (Reduced)","KS,OFF,R","11.2.10.3",{"$f":"((TFSSR-TRAR+530)^(1.19)*('Test Conditions'!$C$68*G59))/(TFSSR-TRAR+70-G47)^0.56","v":{"$error":"#VALUE!"}},"Factor"]
[null,"11.5.10.4","Multiplication Factor for Infiltration Loss During the Burner Off-Cycle (Max)","KI,OFF,H","11.2.10.4",0,"Factor"]
[null,"11.5.10.4","Multiplication Factor for Infiltration Loss During the Burner Off-Cycle (Reduced)","KI,OFF,R","11.2.10.4",0,"Factor"]
[null,"11.5.10.5","On-Cycle Sensible Heat Loss (Max)","LS,ON,H","11.2.10.5",{"$f":"F109*G28-(G58*F111)*((1/G88)*(1-EXP(-G88)))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.10.5","On-Cycle Sensible Heat Loss (Reduced)","LS,ON,R","11.2.10.5",{"$f":"F110*G29-(G59*F112)*((1/G89)*(1-EXP(-G89)))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.10.6","Off-Cycle Sensible Heat Loss (Max)","LS,OFF,H","11.2.10.6",{"$f":"(F113)*('Drop-Downs and Tables'!$E$75/'Drop-Downs and Tables'!$E$74)*((G102)+(G98)*(G103))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.10.6","Off-Cycle Sensible Heat Loss (Reduced)","LS,OFF,R","11.2.10.6",{"$f":"(F114)*('Drop-Downs and Tables'!$E$75/'Drop-Downs and Tables'!$E$74)*((G104)+(G99)*(G105))","v":{"$error":"#VALUE!"}},"% (0-100)"]
[null,"11.5.10.7","On-Cycle Infiltration Heat Loss (Max)","LI,ON,H","11.2.10.7",0,"% (0-100)"]
[null,"11.5.10.7","On-Cycle Infiltration Heat Loss (Reduced)","LI,ON,R","11.2.10.7",0,"% (0-100)"]
[null,"11.5.10.8","Off-Cycle Infiltration Heat Loss (Max)","LI,OFF,H","11.2.10.8",0,"% (0-100)"]
[null,"11.5.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","Calculated Result (rounded per significant figures conventions and instrumentation resolution)","Unit"]
[null,"11.5.11.1","Latent Heat Gain Under Part-Load Conditions (MAX)","LG,H","11.3.11.1",{"$f":"(100*(1053.3)*'Max Test'!C79)/'Max Test'!C78","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.1","Latent Heat Gain Under Part-Load Conditions (Reduced)","LG,R","11.3.11.1",{"$f":"(100*(1053.3)*'Reduced Test'!C78)/'Reduced Test'!C77","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.1","Part-Load Heat Loss Due to Condensate Going Down the Drain (MAX)","LC,H","11.3.11.2",{"$f":"F128*(1*(TFSSH-70)-0.45*(TFSSH-G46))/1053.3","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.1","Part-Load Heat Loss Due to Condensate Going Down the Drain (Reduced)","LC,R","11.3.11.2",{"$f":"F129*(1*(TFSSR-70)-0.45*(TFSSR-G47))/1053.3","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.2","Part-Load Efficiency at Maximum Fuel Input Rate (MAX)","EFFyU,H","11.5.11.2",{"$f":"100-G30+F128-F130-('Drop-Downs and Tables'!$E$73*'Test Conditions'!$C$62)-(('Drop-Downs and Tables'!$E$74)/('Drop-Downs and Tables'!$E$74+('Max Test'!C47/'General Info & Test Results'!C31)*'Drop-Downs and Tables'!E75))*(F117+F119+F121+F123)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.1","Part-Load Efficiency at Reduced Fuel Input Rate (Reduced)","EFFyU,R","11.5.11.1",{"$f":"100-G31+F129-F131-('Drop-Downs and Tables'!$E$73*'Test Conditions'!$C$62)-(('Drop-Downs and Tables'!$E$74)/('Drop-Downs and Tables'!$E$74+('Reduced Test'!C46/'General Info & Test Results'!C32)*'Drop-Downs and Tables'!E75))*(F118+F120+F122+F124)","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.3","Heating Seasonal Efficiency (Single Stage)","EFFyHS","11.5.11.3",{"$f":"F132","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.3","Heating Seasonal Efficiency (Two Stage)","EFFyHS","11.5.11.3",{"$f":"$G$48*F132+$G$49*F133","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.3","Heating Seasonal Efficiency (Modulating)","EFFyHS","11.5.11.3",{"$f":"$G$48*G63+$G$49*F133","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.3.12","Annual Fuel Utilization Efficiency (Single Stage)","AFUE","11.2.12",{"$f":"(5200*G36*F134)/(5200*G36+(2.5*(1+G44)*(4600)*(F134)*('Max Test'!C47/'General Info & Test Results'!C31)))","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.4","Annual Fuel Utilization Efficiency (Two Stage)","AFUE","11.4.12",{"$f":"(5200*G53*F135)/(5200*G53+2.5*(1+G44)*(4600)*(F135)*('Max Test'!C47/'General Info & Test Results'!C31))","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[null,"11.5.11.4","Annual Fuel Utilization Efficiency (Modulating)","AFUE","11.4.12",{"$f":"(5200*G53*F136)/(5200*G53+2.5*(1+G44)*(4600)*(F136)*('Max Test'!C47/'General Info & Test Results'!C31))","v":{"$error":"#VALUE!"}},null,"% (0-100)"]
[]
[null,"Furnace Fan Efficiency Calculation"]
[null,"ENERGY STAR Section","Variable Name","Variable","Equation Number","Value","Calculated Result (rounded per significant figures conventions and instrumentation resolution)","Unit"]
[null,3,"Burner Operating Hours for Furnaces Equipped with Single Stage Controls","BOHSS","-",null,null,"Hours"]
[null,null,"Average Annual Auxiliary Electrical Energy Consumption Minus the Average Annual Electric Standby and Off Mode Energy Consumption","EAE - ESO","-",null,null,"kWh"]
[null,null,"Average Annual Energy Use During the Heating Season","EM","-",{"$f":"('Max Test'!C21-'Max Test'!C47) * F143 + ('Drop-Downs and Tables'!E77-'Drop-Downs and Tables'!E78) * 'Max Test'!C47","v":{"$error":"#VALUE!"}},null,"Btu"]
[null,null,"Annual Electricity Use of the Advanced Main Circulating Fan","Efan","(1)",{"$f":"F147*F148","v":{"$error":"#VALUE!"}},null,"kWh"]
[null,null,"Furnace Fan Electrical Consumption Ratio","e","(2) & (5)",{"$f":"IF(F148<>\"\",(F149 * 'Drop-Downs and Tables'!E76) / (F149 * 'Drop-Downs and Tables'!E76 + F148),\"\")","v":""},null,"Ratio"]
[null,null,"Average Annual Fuel Energy Consumption","EF","(3) & (6)",{"$f":"IF('General Info & Test Results'!C49=\"Single Stage\",F143*('Max Test'!C21-'Max Test'!C47)+'Drop-Downs and Tables'!E77*'Max Test'!C47,IF(OR('General Info & Test Results'!C49=\"Two-Stage Modulating\",'General Info & Test Results'!C49=\"Step Modulating\"),F145+'Drop-Downs and Tables'!E78*'Max Test'!C47,\"\"))","v":""},null,"Btu"]
[null,null,"Average Annual Auxiliary Electrical Energy Consumption Excluding Standby and Off Modes","EFurnace","(4) & (7)",{"$f":"F144","v":0},null,"kWh"]

{"sheet":"Comments","index":11,"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":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Comments"}]
[null,"File Name:",{"$f":"'Version Control'!C7","v":"Residential Condensing Gas Furnace - v1.6.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":12,"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":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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":13,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[[75,3,77,3],[59,9,60,9],[41,3,42,3],[58,1,58,5],[59,7,59,8],[25,3,26,3],[24,1,24,4],[25,4,26,4],[25,1,25,2],[33,1,33,11],[1,1,1,2],[17,4,17,5],[17,1,18,1],[17,2,18,2],[17,3,18,3]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:",{"$f":"'Version Control'!C3","v":"Residential Condensing Gas Furnace"}]
[null,"Version Number:",{"$f":"'Version Control'!C4","v":"v1.6"},null,null,null,null,"Back to Instructions tab"]
[null,"Latest Template Revision: ",{"$f":"'Version Control'!C5","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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","Flue_Gas","Control","System_Number","Fuel_Used","Yes_No","Jacket_Loss"]
[]
[null,"Air","Forced","Gas","Power (Induced Draft)","Intermittent","None","None","Isolated Combustion System","Condensing","Single Stage",10,"Natural Gas","Yes","Default Value"]
[null,null,null,null,null,null,null,null,null,null,"Two-Stage Modulating",null,"Manufactured Gas","No","Optional Test"]
[null,"Tables",null,null,null,null,null,null,null,null,"Step Modulating",null,"Butane"]
[null,"Table 1: (from 8.2.1.3)",null,null,null,null,null,null,null,null,null,null,"Propane"]
[null,"Type","Heating Value (Btu/SCF)","Sp. Gr. (Air = 1)","Test Pressure (in. Water)"]
[null,null,null,null,"Normal","Increased"]
[null,"Natural",1025,0.65,7,10.5]
[null,"Manufactured",535,0.38,3.5,5.25]
[null,"Butane",3175,2,11,13]
[null,"Propane",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)","Max Input Falls in range?"]
[null,"Low","High"]
[null,0,55000,0.18,{"$f":"IF('Test Conditions'!$C$35=MEDIAN(B28,'Test Conditions'!$C$35,C28),\"Yes\",\"No\")","v":"No"}]
[null,55001,80000,0.2,{"$f":"IF('Test Conditions'!$C$35=MEDIAN(B29,'Test Conditions'!$C$35,C29),\"Yes\",\"No\")","v":"No"}]
[null,80001,100000,0.23,{"$f":"IF('Test Conditions'!$C$35=MEDIAN(B30,'Test Conditions'!$C$35,C30),\"Yes\",\"No\")","v":"No"}]
[null,100001,200000,0.28000000000000003,{"$f":"IF('Test Conditions'!$C$35=MEDIAN(B31,'Test Conditions'!$C$35,C31),\"Yes\",\"No\")","v":"No"}]
[null,200001,300000,0.33,{"$f":"IF('Test Conditions'!$C$35=MEDIAN(B32,'Test Conditions'!$C$35,C32),\"Yes\",\"No\")","v":"No"}]
[]
[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,"Natural Gas",20120,14.45,9.5500000000000007,9.1939999999999994E-2,10.96,0.25949477999999998,-4.9475802E-6,1.3886838E-8,-2.8059994E-12,3.7662440000000003E-17]
[null,"Manufactured Gas",18500,11.81,10.14,9.6460000000000004E-2,10.1,0.26984419999999998,-7.7661435000000007E-6,1.5833852000000001E-8,-3.4194210000000002E-12,1.2158977E-17]
[null,"Propane",21500,15.58,7.99,8.4099999999999994E-2,12.6,0.25163638999999999,-6.4144603999999997E-6,1.1315072999999999E-8,-2.0856792E-12,-5.4897330000000002E-17]
[null,"Butane",20890,15.38,7.79,8.0799999999999997E-2,12.93,0.25011246999999998,-1.7737005999999999E-6,1.0820337E-8,-1.9220640999999999E-12,-7.3013273999999997E-17]
[]
[null,"Table 8: Output Capacity (Btu/h) DHR (kBtu/h) "]
[null,"Range",null,"DHR"]
[null,"Low","High"]
[null,5000,10000,5]
[null,11000,16000,10]
[null,17000,25000,15]
[null,26000,42000,20]
[null,43000,59000,30]
[null,60000,76000,40]
[null,77000,93000,50]
[null,94000,110000,60]
[null,111000,127000,70]
[null,127000,144000,80]
[null,145000,161000,90]
[null,162000,178000,100]
[null,179000,195000,110]
[null,196000,"+",130]
[]
[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'!C44=\"Continuous\",1,IF('General Info & Test Results'!C44=\"Intermittent\",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",1.7,"Factor",null,162000,178000,100]
[null,"On-Time Per Cycle","tON","11.2.9.11/11.4.9.11",{"$f":"IF('General Info & Test Results'!C49=\"Single Stage\", 3.87,10)","v":10},"min",null,179000,195000,110]
[null,"Off-Time Per Cycle","tOFF","11.2.9.12/11.4.9.12",{"$f":"IF('General Info & Test Results'!C49=\"Single Stage\", 13.3,10)","v":10},"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,"Average Non-Heating Season Hours Per Year","-",null,8760,"Hours"]
[null,"Total Number of Hours Per Year","-",null,4600,"Hours"]

{"sheet":"Version Control","index":14,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:","Residential Condensing Gas Furnace"]
[null,"Version Number:",{"$f":"INDEX(B13:B62,COUNTA(B13:B62),1)","v":"v1.6"}]
[null,"Latest Template Revision: ",{"$f":"IF(MAX(B13:C104)=0,\"No Revisions Dates Entered\",MAX(C13:C104))","v":"2017-07-06"}]
[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":"Residential Condensing Gas Furnace - v1.6.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"]