{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","General Info & Test Results","Setup & Instrumentation","CTS Calibration","Photos","Test Sample Description","Sample U-factor Test","Energy Consumption","Comments","Report Sign-Off Block","Drop-Downs","Version Control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"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":53,"n_cols":3,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2],[35,1,35,2],[41,1,43,1],[41,2,43,2],[10,1,10,2],[36,1,38,2],[39,1,40,2],[12,1,12,2],[27,1,27,2],[28,1,29,1],[30,1,33,1]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"}]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Instructions"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[]
[]
[null,"Reference Test Procedure"]
[null,"10 CFR Part 431 Appendix A to Subpart R: Uniform test method for the measurement of energy consumption of the components of envelopes of walk-in coolers and walk-in freezers"]
[]
[null,"Table of Contents"]
[null,"Tab","Contents"]
[null,"Instructions","Instructions and table of contents"]
[null,"General Info & Test Results","Lab information, equipment information, and test results"]
[null,"Setup & Instrumentation","Instrumentation and calibration requirements and space for sensor placement descriptions"]
[null,"CTS Calibration","Calibration inputs and automated calculations"]
[null,"Photos","Inputs for photographs"]
[null,"Test Sample Description","Physical and material description of the test sample which includes electrical component characteristics"]
[null,"Sample U-factor Test","Measurement inputs and automated calculations for the U-factor test"]
[null,"Energy Consumption","Inputs and automated calculations based on U-factor and electrical characteristics"]
[null,"Comments","Inputs for report template user to provide comments"]
[null,"Report Sign-Off Block","Report review history"]
[null,"Drop Downs","Drop-downs used"]
[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","Setup & Instrumentation"]
[null,"Step 3","CTS Calibration"]
[null,"Step 4","Photos"]
[null,"Step 5","Test Sample Description"]
[null,"Step 6","Sample U-factor Test"]
[null,"Step 7","Energy Consumption"]
[null,"Step 8","Comments"]
[null,"Step 9","Report Sign-off Block"]

{"sheet":"General Info & Test Results","index":1,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,4,29,5],[1,1,1,2],[10,1,10,2],[21,1,21,2],[22,4,24,7],[28,4,28,5],[26,4,26,5],[27,4,27,5]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"},null,null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"}]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"General Info & Test Results"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Lab Information ",null,null,null,"Test results"]
[null,"Lab Name:",null,null,null,"Variable","Result","Units"]
[null,"Lab Location:",null,null,null,"Standardized U-factor (UST)",{"$f":"IF('Sample U-factor Test'!E71<>\"\",'Sample U-factor Test'!E71,\"Incomplete\")","v":"Incomplete"},"Btu/(h-ft2-°F)"]
[null,null,null,null,null,"Energy Consumption",{"$f":"IF(ISNUMBER('Energy Consumption'!C59)=FALSE,\"Incomplete\",'Energy Consumption'!C59)","v":"Incomplete"},"kWh/day"]
[null,"U-factor Test Information"]
[null,null,"Start Date/Time","End Date/Time"]
[null,"Date of Test","[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,"Test parameters were considered stable for two consecutive four hour test periods from: ","[MM/DD/YYYY] [hh:mm]","[MM/DD/YYYY] [hh:mm]"]
[null,"The thermal test results were derived from","[MM/DD/YYYY] [hh:mm]","[MM/DD/YYYY] [hh:mm]"]
[]
[null,null,null,null,"NOTE: This is only a copy; sign off is done in the Report Sign-Off Block tab"]
[null,"Product Information",null,null,"Test Report Sign-Off Block "]
[null,"Brand: ",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,"Manufacturer: "]
[null,"Manufacturer model number: "]
[null,"Serial number: ",null,null,"Role",null,"Date","Entity"]
[null,"Series/Model: ",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,"Equipment Class - Door",null,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,"Equipment Class - Temperature",null,null,"Report Reviewed 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,"Panels per Door",null,null,"Report Reviewed 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,"Configuration "]
[null,"Date of Manufacture (if available):","[MM/DD/YYYY]"]
[null,"Date Product Received:","[MM/DD/YYYY]"]
[null,"Condition as received:"]
[null,"Certified Surface Area (ft2)",100]
[null,"Overall Sample Dimensions"]
[null,"     Height (in)"]
[null,"     Width (in)"]

{"sheet":"Setup & Instrumentation","index":2,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[16,2,16,3],[20,2,20,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[6,1,6,2],[8,1,8,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[7,1,7,2]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},null,{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},null,{"$f":"'Version Control'!$C$4","v":"v1.2"},null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},null,{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},null,{"$f":"MID(CELL(\"filename\",B1), FIND(\"]\", CELL(\"filename\", B1))+ 1, 255)","v":"Setup & Instrumentation"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},null,{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,"Test Start Date:",null,{"$f":"'General Info & Test Results'!C17","v":"[MM/DD/YYYY]"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},null,{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,null,"Chamber Setup - Baffles",null,"Warm Side/Metering Chamber","Cold Side/Climate Chamber"]
[null,null,"Wind direction in relation to the test sample",null,"-"]
[null,null,"Baffle dimensions"]
[null,null,"Height (in)"]
[null,null,"Width (in)"]
[null,null,"Are the baffle thermocouples located at the center of equal-area surfaces?  If no, please provide a schematic diagram or image in the photos tab."]
[null,null,"Number of baffle thermocouples total"]
[null,null,"Number of thermocouples per row"]
[null,null,"Number of thermocouples per column"]
[null,null,"Baffle-to-sample spacing (in)"]
[]
[]
[null,null,"Setup (This table should include instrumentation, sensors, and all equipment used during testing)"]
[null,null,"Instrument Type","Brand","Model #","Sensor Location","Accuracy","Date of Last Calibration","Deadline for Next Calibration"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]
[null,null,null,null,null,null,null,"[MM/DD/YYYY]","[MM/DD/YYYY]"]

{"sheet":"CTS Calibration","index":3,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[25,10,25,11],[25,8,25,9],[21,2,21,3],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[24,8,24,9],[19,4,19,5],[22,8,22,9],[23,8,23,9],[69,2,69,4],[70,2,70,4],[74,2,74,3],[73,2,73,3],[67,2,67,4],[60,2,60,4],[71,2,71,4],[28,2,28,3],[27,4,27,5],[28,4,28,5],[29,4,29,5],[65,2,65,4],[66,2,66,4],[68,2,68,4],[37,2,37,4],[51,2,51,4],[64,2,64,4],[63,2,63,4],[33,4,33,5],[31,2,31,3],[32,2,32,3],[59,2,59,4],[27,2,27,3],[33,2,33,3],[62,2,62,4],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[20,4,20,5],[10,1,10,2],[11,1,11,2],[20,2,20,3],[18,2,18,3],[18,4,18,5],[15,1,15,13],[20,10,20,11],[32,4,32,5],[27,8,27,9],[30,4,30,5],[30,2,30,3],[31,4,31,5],[47,2,47,4],[56,2,56,4],[55,2,55,4],[18,8,18,11],[12,1,12,2],[13,1,13,2],[46,2,46,4],[17,2,17,6],[25,2,25,6],[23,4,23,5],[24,4,24,5],[24,2,24,3],[26,2,26,3],[21,4,21,5],[26,4,26,5],[22,2,22,3],[23,2,23,3],[22,4,22,5],[39,2,39,4],[40,2,40,4],[42,2,42,4],[43,2,43,4],[17,8,17,12],[19,2,19,3],[44,2,44,4],[61,2,61,4],[27,10,27,11],[19,8,19,9],[19,10,19,11],[26,8,26,9],[26,10,26,11],[35,2,35,4],[36,2,36,4],[49,2,49,4],[41,2,41,4],[38,2,38,4],[45,2,45,4],[20,8,20,9],[21,8,21,9],[58,2,58,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[48,2,48,4],[50,2,50,4],[29,2,29,3]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},null,{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},null,{"$f":"'Version Control'!$C$4","v":"v1.2"},null,null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},null,{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},null,{"$f":"MID(CELL(\"filename\",B1), FIND(\"]\", CELL(\"filename\", B1))+ 1, 255)","v":"CTS Calibration"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},null,{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},null,{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Constants",null,"Quantity","Units"]
[null,"Stefan-Boltzmann",null,{"$f":"0.000000001714","v":1.7140000000000001E-9},"Btu/(h-ft2-°R4)"]
[null,"Standardized Surface Heat Transfer Coefficient - Warm Side",null,1.36,"Btu/(h-ft2-°F)"]
[null,"Standardized Surface Heat Transfer Coefficient - Cold Side",null,5.3,"Btu/(h-ft2-°F)"]
[]
[null,"CTS Calibration - C1199 6.1.2"]
[]
[null,null,"Calibration Transfer Standard (CTS) Details",null,null,null,null,null,"Surround Panel Details"]
[null,null,"Date of purchase for the CTS materials and additional materials used for the conductance test",null,"[MM/YYYY]",null,"Units",null,"Include a diagram showing measurements & locations of thermocouples in \"Photos\" tab.  Conductance test should be done on a representative sample of material (i.e., same lot) to what is used in the surround panel and under representative conditions (i.e., temperature).",null,null,null,"Units"]
[null,null,"Material Description",null,null,null,"-",null,"Date of purchase for surround panel materials",null,"[MM/YYYY]",null,"-"]
[null,null,"Interior or exterior location of thermocouples",null,null,null,"-",null,"Material Description",null,null,null,"-"]
[null,null,"Are the CTS thermocouples located at the center of equally spaced areas?  If no, please provide a schematic diagram or image in the photos tab.",null,null,null,"-",null,"Number of Thermocouples",null,null,null,"-"]
[null,null,"Number of thermocouples total",null,null,null,"-",null,"Conductance Test Date",null,"[MM/DD/YYYY]",null,"-"]
[null,null,"Number of thermocouples per row",null,null,null,"-",null,"Conductance Test Location",null,null,null,"-"]
[null,null,"Number of thermocouples per column",null,null,null,"-",null,"Conductance Test Method",null,null,null,"-"]
[null,null,"Conductance test should be done under representative conditions (i.e., temperature).",null,null,null,null,null,"Thermal Conductance (Csp)",null,null,null,"Btu/(h-ft2-°F)"]
[null,null,"Conductance Test Date",null,"[MM/DD/YYYY]",null,"-",null,"Thickness",null,null,null,"in"]
[null,null,"Conductance Test Location",null,null,null,"-",null,"Area of surround panel (Asp)",null,null,null,"ft²"]
[null,null,"Conductance Test Method",null,null,null,"-"]
[null,null,"Thermal conductance (Cts[core] or Cts[assembly])",null,null,null,"Btu/(h-ft2-°F)"]
[null,null,"Thickness",null,null,null,"in"]
[null,null,"Width",null,null,null,"in"]
[null,null,"Height",null,null,null,"in"]
[null,null,"Area of CTS (As)",null,{"$f":"IF(AND(ISBLANK(E32),ISBLANK(E33)),\"\",E32*E33/144)","v":""},null,"ft²"]
[]
[null,null,"Calibration Transfer Standard (CTS) Measurements",null,null,"Quantity","Units"]
[null,null,"Date of test completion",null,null,"[MM/DD/YYYY]","-"]
[null,null,"Climate chamber average air velocity",null,null,null,"mph"]
[null,null,"Metering box wall thermopile output",null,null,null,"V"]
[null,null,"Metering box wall loss (Qmb)",null,null,null,"Btu/h"]
[null,null,"Flanking loss (Qfl)",null,null,null,"Btu/h"]
[null,null,"Total net metering box heat input (Q - heat and power input minus cooling)",null,null,null,"Btu/h"]
[null,null,"Average warm side CTS surface temperature (t1)",null,null,null,"°F"]
[null,null,"Average temperature of warm side glass/core interface of CTS (t1')",null,null,null,"°F"]
[null,null,"Average cold side CTS surface temperature (t2)",null,null,null,"°F"]
[null,null,"Average temperature of cold side glass/core interface of CTS (t2')",null,null,null,"°F"]
[null,null,"Warm side surround panel surface temperature (tsp1)",null,null,null,"°F"]
[null,null,"Cold side surround panel surface temperature (tsp2)",null,null,null,"°F"]
[null,null,"Warm side baffle surface temperature (tb1)",null,null,null,"°F"]
[null,null,"Cold side baffle surface temperature (tb2)",null,null,null,"°F"]
[null,null,"Average warm side air temperature (th)",null,null,null,"°F"]
[null,null,"Average cold side air temperature (tc)",null,null,null,"°F"]
[null,null,"Conductance of facing on each side of CTS glass (Cg)",null,null,null,"Btu/(h-ft2-°F)"]
[null,null,"Warm side emittance of glass (ε1)",null,null,null,"-"]
[null,null,"Cold side emittance of glass (ε2)",null,null,null,"-"]
[null,null,"Warm side baffle emittance (εb1)",null,null,null,"-"]
[null,null,"Cold side baffle emittance (εb2)",null,null,null,"-"]
[]
[null,null,"Calibration Transfer Standard (CTS) Calculations",null,null,"Quantity","Units","Reference Eqn. from C1199"]
[null,null,"CTS heat flow (QS) using conductance value",null,null,{"$f":"IF(E21=\"Interior\",E30*E34*(F44-F46),(IF(E21=\"Exterior\",E30*E34*(F43-F45),\"\")))","v":""},"Btu/h","(1) or (2)"]
[null,null,"CTS heat flow (QS) using energy balance",null,null,{"$f":"IF(AND(F42<>\"\",F41<>\"\",F40<>\"\",F63<>\"\"),(F42-F41-F40-F63),\"\")","v":""},"Btu/h","(1A,2A) from NFRC 100"]
[null,null,"Percent difference of CTS heat flow (Qs) using conductance vs. energy balance",null,null,{"$f":"IF(AND(F60=\"\",F61=\"\"),\"\",(F60-F61)/MIN(F61,F60))","v":""},"%","-"]
[null,null,"Surround panel heat flow (Qsp)",null,null,{"$f":"IF(AND(K28=\"\",K26=\"\",F47=\"\",F48=\"\"),\"\",K28*K26*(F47-F48))","v":""},"Btu/h","(3)"]
[null,null,"Warm Side Radiative Heat Flux of Test Specimen (qr1)",null,null,{"$f":"IF(AND(F49=\"\",F51=\"\"),\"\",IF(AND(F49<=(F51+2),F49>=(F51-2)),D12*(((F49+459.67)^4)-(IF(E21=\"Interior\",(F44+(E30*(F44-F46)/F53)),(IF(E21=\"Exterior\",F43,\"\")))+459.67)^4)/((1/F54)+(1/F56)-1),\"\"))","v":""},"Btu/(h-ft²)","(8)"]
[null,null,"Warm Side Radiative Test Specimen Heat Flow (Qr1)",null,null,{"$f":"IF(F64=\"\",\"\",F64*E34)","v":""},"Btu/h","(8)"]
[null,null,"Warm Side Convective Heat Flux of Test Specimen (qc1)",null,null,{"$f":"IF(F67=\"\",\"\",F67/E34)","v":""},"Btu/(h-ft²)","(10)"]
[null,null,"Warm Side Convective Test Specimen Heat Flow (Qc1)",null,null,{"$f":"IF(F65=\"\",\"\",F60-F65)","v":""},"Btu/h","(9)"]
[null,null,"Convection Coefficient (Kc)",null,null,{"$f":"IF(F66=\"\",\"\",F66/((F51-(IF(E21=\"Interior\",(F44+(E30*(F44-F46)/F53)),IF(E21=\"Exterior\",F43,\"\"))))^1.25))","v":""},"Btu/(h-ft2-°F1.25)","(11)"]
[null,null,"Cold Side Radiative Heat Flux of Test Specimen (qr2)",null,null,{"$f":"IF(AND(F57=\"\",F50=\"\"),\"\",D12*(((IF(E21=\"Interior\",(F46-(E30*(F44-F46)/F53)),IF(E21=\"Exterior\",F45,\"\")))+459.67)^4-(F50+459.67)^4)/((1/F55)+(1/F57)-1))","v":""},"Btu/(h-ft²)","(13)"]
[null,null,"Cold Side Radiative Test Specimen Heat Flow (Qr2)",null,null,{"$f":"IF(F69=\"\",\"\",F69*E34)","v":""},"Btu/h","(13)"]
[null,null,"Cold Side Convective Heat Flux of Test Specimen (qc2)",null,null,{"$f":"IF(F72=\"\",\"\",F72/E34)","v":""},"Btu/(h-ft²)","(15)"]
[null,null,"Cold Side Convective Test Specimen Heat Flow (Qc2)",null,null,{"$f":"IF(F70=\"\",\"\",F60-F70)","v":""},"Btu/h","(14)"]
[null,null,"Balance Checks",null,"Calculated Quantity","Comparison to Standardized Value","Units","Reference Eqn. from C1199"]
[null,null,"Measured Warm Side Surface Conductance (hh)",null,{"$f":"IF(F60=\"\",\"\",IF(AND(F49<=(F51+2),F49>=(F51-2)),(F60/E34/(F51-(IF(E21=\"Exterior\",F43,IF(E21=\"Interior\",(F44+(E30*(F44-F46)/F53)),\"\"))))),IF(OR(F49>(F51+2),F49<(F51-2)),((F64+F66)/(F51-(IF(E21=\"Exterior\",F43,IF(E21=\"Interior\",(F44+(E30*(F44-F46)/F53)),\"\"))))))))","v":""},{"$f":"IF(E74=\"\",\"\",(E74-D13)/D13)","v":""},"Btu/(h-ft2-°F)","(4) or (12)"]
[null,null,"Measured Cold Side Surface Conductance (hc)",null,{"$f":"IF(F60=\"\",\"\",IF(AND(F49<=(F51+2),F49>=(F51-2)),(F60/E34/((IF(E21=\"Exterior\",F45,IF(E21=\"Interior\",(F46-(E30*(F44-F46)/F53)),\"\")))-F52)),IF(OR(F49>(F51+2),F49<(F51-2)),((F69+F71)/((IF(E21=\"Exterior\",F45,IF(E21=\"Interior\",(F46-(E30*(F44-F46)/F53)),\"\")))-F52)))))","v":""},{"$f":"IF(E75=\"\",\"\",(E75-D14)/D14)","v":""},"Btu/(h-ft2-°F)","(6) or (16)"]

{"sheet":"Photos","index":4,"n_rows":179,"n_cols":10,"rows_kept":179,"cut":false,"hidden":false,"merged":[[67,9,92,25],[66,1,66,7],[66,9,66,25],[94,1,94,7],[94,9,94,25],[179,1,204,25],[178,1,178,25],[1,1,1,2],[122,1,122,25],[123,1,148,25],[38,1,38,25],[39,1,64,25],[67,1,92,7],[11,1,36,25],[10,1,10,25],[150,1,150,7],[150,9,150,25],[151,1,176,7],[151,9,176,25],[95,1,120,7],[95,9,120,25]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"},null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Photos"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"1. Nameplate(s) and/or label(s) of test sample showing model number and serial number"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Images of installation instructions, if provided with the test sample"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Cold side airflow apparatus and air temperature sensors",null,null,null,null,null,null,null,"4. Warm side convection assist fans (if used) and air temperature sensors"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"5. Cold side baffle and schematic of temperature sensor placement as viewed from the test sample (if used)",null,null,null,null,null,null,null,"6. Warm side baffle and schematic of temperature sensor placement as viewed from the test sample (if used)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7. Surround panel used for test, schematic of temperature sensor placement on surround panel(s) used for calibration and test, installation of surround panel used for test within wall, and installation of test sample assembled into the surround panel on both sides."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"8. Test sample full view with door open on cold side and warm side",null,null,null,null,null,null,null,"9. Close-up of door corners and frame corners on cold/warm side"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"10. Additional photos (if necessary)"]

{"sheet":"Test Sample Description","index":5,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,6,9,15],[10,6,62,15],[53,1,53,2],[56,1,56,2],[48,1,48,2],[46,1,46,2],[47,1,47,2],[42,1,42,2],[39,1,39,2],[55,1,55,2],[35,1,35,2],[36,1,36,2],[45,1,45,2],[25,1,25,2],[38,1,38,2],[52,1,52,2],[33,1,33,2],[40,1,40,2],[41,1,41,2],[54,1,54,2],[1,1,1,2],[27,1,27,2],[31,1,31,2],[34,1,34,2],[24,1,24,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[32,1,32,2],[26,1,26,2],[25,3,25,4],[32,3,32,4],[38,3,38,4],[44,3,44,4],[52,3,52,4],[27,3,27,4],[39,3,39,4],[46,3,46,4],[33,3,33,4],[45,3,45,4],[47,3,47,4],[26,3,26,4],[57,1,57,2],[58,1,58,2],[49,1,49,2],[50,1,50,2],[55,3,55,4],[54,3,54,4],[53,3,53,4]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"},null,null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"}]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Test Sample Description"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[null,"Summary",null,null,null,null,"Details (Include relevant material information, dimensions and descriptions of distinct sections)"]
[null,"Equipment Class",{"$f":"IF(ISBLANK('General Info & Test Results'!C28),\"\",'General Info & Test Results'!C28)","v":""},{"$f":"IF(ISBLANK('General Info & Test Results'!C29),\"\",'General Info & Test Results'!C29)","v":""}]
[null,null,"Height (in)","Width (in)"]
[null,"Overall Size",{"$f":"IF(ISBLANK('General Info & Test Results'!C37),\"\",'General Info & Test Results'!C37)","v":""},{"$f":"IF(ISBLANK('General Info & Test Results'!C38),\"\",'General Info & Test Results'!C38)","v":""}]
[]
[null,"Glazing","Thickness (in)","Description"]
[null,"Glazing ID","-"]
[null,"Layer 1"]
[null,"Gap 1"]
[null,"Layer 2"]
[null,"Gap 2"]
[null,"Layer 3"]
[]
[null,"Electrical Components",null,"From Nameplate*","Measured*"]
[null,"*Only one value is required, either from the nameplate or measured.  Leave blank if value was not measured or on the nameplate or if it does not apply."]
[null,"Lighting"]
[null,"Was electrical component measured?"]
[null,"Type of lighting"]
[null,"Timers, Controls, or Demand Based Control?"]
[null,"Voltage"]
[null,"Amperage"]
[null,"Wattage"]
[null,"Antisweat Heaters - Circuit 1"]
[null,"Was electrical component measured?"]
[null,"Timers, Controls, or Demand Based Control?"]
[null,"Voltage"]
[null,"Amperage"]
[null,"Wattage"]
[null,"Antisweat Heaters - Circuit 2 (if needed)"]
[null,"Was electrical component measured?"]
[null,"Timers, Controls, or Demand Based Control?"]
[null,"Voltage"]
[null,"Amperage"]
[null,"Wattage"]
[null,"Other (if necessary) - *If this alternate component is sited on both the interior and exterior of the door, it is considered interior."]
[null,"Was electrical component measured?"]
[null,"Description"]
[null,"Timers, Controls, or Demand Based Control?"]
[null,"Location (Interior is the cold side, exterior is the warm side)"]
[null,"Voltage"]
[null,"Amperage"]
[null,"Wattage"]
[null,"Other (if necessary) - *If this alternate component is sited on both the interior and exterior of the door, it is considered interior."]
[null,"Was electrical component measured?"]
[null,"Description"]
[null,"Timers, Controls, or Demand Based Control?"]
[null,"Location (Interior is the cold side, exterior is the warm side)"]
[null,"Voltage"]
[null,"Amperage"]
[null,"Wattage"]

{"sheet":"Sample U-factor Test","index":6,"n_rows":74,"n_cols":8,"rows_kept":74,"cut":false,"hidden":false,"merged":[[25,2,25,3],[18,1,18,2],[32,2,32,3],[33,2,33,3],[23,2,23,5],[19,1,19,2],[10,1,10,3],[11,1,11,3],[12,1,12,2],[13,1,13,2],[17,1,17,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[1,1,1,3],[4,1,4,2],[5,1,5,2],[7,1,7,2],[2,1,2,2],[3,1,3,2],[6,1,6,2],[74,1,80,7],[46,2,46,3],[21,1,21,7],[27,2,27,5],[73,1,73,7],[54,1,54,7],[29,2,29,3],[30,2,30,3],[31,2,31,3],[34,2,34,3],[35,2,35,3],[47,2,47,3],[43,2,43,3],[40,2,40,5],[42,2,42,3],[70,2,70,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[58,2,58,3],[59,2,59,3],[51,2,51,3],[45,2,45,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[68,2,68,3],[69,2,69,3]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},null,{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},null,{"$f":"'Version Control'!$C$4","v":"v1.2"},null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},null,{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},null,{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Sample U-factor Test"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},null,{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},null,{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Surround Panel Details"]
[null,"Include an image showing measurements & locations of thermocouples in \"Photos\" tab."]
[null,"Material Description"]
[null,"Number of Thermocouples"]
[null,"Conductance Test Date",null,"[MM/DD/YYYY]"]
[null,"Conductance Test Location"]
[null,"Conductance Test Method"]
[null,"Thermal Conductance (Btu/h-ft2-°F)"]
[null,"Thickness (in)"]
[null,"Area of surround panel (ft2)"]
[]
[null,"Measured Test Data"]
[]
[null,null,"Area"]
[null,null,null,null,"Quantity","Units"]
[null,null,"Test Specimen Area (As)",null,{"$f":"IF('Test Sample Description'!C13=\"\",\"\",'Test Sample Description'!C13*'Test Sample Description'!D13/144)","v":""},"ft²"]
[]
[null,null,"Test Conditions"]
[null,null,null,null,"Quantity","Units"]
[null,null,"Average Warm Side (Metering Room) Air Temperature (th)",null,null,"°F"]
[null,null,"Average Cold Side Air Temperature (tc)",null,null,"°F"]
[null,null,"Average Guard/Environmental Air Temperature (tguard)",null,null,"°F"]
[null,null,"Warm Side Surround Panel (tsp1)",null,null,"°F"]
[null,null,"Cold Side Surround Panel (tsp2)",null,null,"°F"]
[null,null,"Warm Side Average Relative Humidity",null,null,"%"]
[null,null,"Warm Side Maximum Relative Humidity",null,null,"%"]
[null,null,"Warm Side Minimum Relative Humidity",null,null,"%"]
[null,null,"Measured Cold Side Wind Velocity",null,null,"mph"]
[null,null,"Mesured Static Pressure Difference Across Test Specimen",null,null,"in. H2O"]
[]
[null,null,"Heat Flows"]
[null,null,null,null,"Quantity","Units"]
[null,null,"Total Measured Input into Metering Box (Qtotal)",null,null,"Btu/h"]
[null,null,"Surround Panel Heat Flow (Qsp)",null,{"$f":"IF(AND(D20=\"\",E33=\"\",E34=\"\",D18=\"\"),\"\",D18*D20*(E33-E34))","v":""},"Btu/h"]
[null,null,"Metering box wall thermopile output",null,null,"V"]
[null,null,"Metering Box Wall Heat Flow (Qmb)",null,null,"Btu/h"]
[null,null,"Flanking Loss Heat Flow (Qfl)",null,null,"Btu/h"]
[null,null,"Net Specimen Heat Flow Rate (Qs)",null,{"$f":"IF(AND(E43=\"\",E44=\"\",E46=\"\",E47=\"\"),\"\",(E43-E44-E47-E46))","v":""},"Btu/h"]
[]
[null,null,"Results"]
[null,null,null,null,"Quantity","Units"]
[null,null,"Thermal Transmittance of Test Specimen (US)",null,{"$f":"IF(AND(E26=\"\",E30=\"\",E31=\"\",E48=\"\"),\"\",E48/(E26*(E30-E31)))","v":""},"Btu/(h-ft2-°F)"]
[]
[]
[null,"Calculated Test Data"]
[]
[null,null,"CTS Method Results"]
[null,null,null,null,"Calculated Result","Units",null,"Calculated Result (rounded per significant figures conventions and instrumentation resolution)"]
[null,null,"Warm Side Sample Emittance (ε1)",null,null,"-"]
[null,null,"Cold Side Sample Emittance (ε2)",null,null,"-"]
[null,null,"Warm Side Baffle Emittance (εb1)",null,null,"-"]
[null,null,"Cold Side Baffle Emittance (εb2)",null,null,"-"]
[null,null,"Equivalent Warm Side Surface Temperature (t1)",null,null,"°F"]
[null,null,"Equivalent Cold Side Surface Temperature (t2)",null,{"$f":"IF(E48<>\"\",(E48/('CTS Calibration'!E75*E26)+E31),\"\")","v":""},"°F"]
[null,null,"Warm Side Baffle Surface Temperature (tb1)",null,null,"°F"]
[null,null,"Cold Side Baffle Surface Temperature (tb2)",null,null,"°F"]
[null,null,"Measured Warm Side Surface Conductance (hh)",null,{"$f":"IF(E63<>\"\",(E48/(E26*(E30-E63))),\"\")","v":""},"Btu/(h-ft2-°F)"]
[null,null,"Measured Cold Side Surface Conductance (hc)",null,{"$f":"IF(E64<>\"\",(E48/(E26*(E64-E31))),\"\")","v":""},"Btu/(h-ft2-°F)"]
[null,null,"Standardized Warm Side Surface Conductance (hSTh)",null,{"$f":"IF(E63=\"\",\"\",(0.3*((E30-E63)/('Test Sample Description'!C13/12))^0.25)+('CTS Calibration'!D12*E59*(((E30+459.67)^4-(E63+459.67)^4)/(E30-E63))))","v":""},"Btu/(h-ft2-°F)"]
[null,null,"Standardized Cold Side Surface Conductance (hSTc)",null,5.28,"Btu/(h-ft2-°F)"]
[null,null,"Standardized Thermal Transmittance of Test Speciment (UST)",null,{"$f":"IF(E52<>\"\",(1/((1/E52)+((1/E69)-(1/E67))+((1/E70)-(1/E68)))),\"\")","v":""},"Btu/(h-ft2-°F)"]
[]
[]
[null,"Notes/Comments: (Please clarify any pertinent details, unusual events, etc.)"]

{"sheet":"Energy Consumption","index":7,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[52,1,52,3],[56,1,56,3],[17,1,17,3],[10,1,10,3],[42,1,42,3],[36,1,36,3],[24,1,24,3],[19,1,19,3],[30,1,30,3],[7,2,7,4],[1,1,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"},null,null,null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Energy Consumption"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Conduction Through Display Door"]
[null,null,"Quantity","Units"]
[null,"Thermal Transmittance (U)",{"$f":"IF('Sample U-factor Test'!E71=\"\",\"Incomplete\",'Sample U-factor Test'!E71)","v":"Incomplete"},"Btu/(h-ft2-°F)"]
[null,"Surface Area (A)",{"$f":"IF('Sample U-factor Test'!E26=\"\",\"Incomplete\",IF(AND('Sample U-factor Test'!E26<=1.03*'General Info & Test Results'!C35,'Sample U-factor Test'!E26>=0.97*'General Info & Test Results'!C35),'General Info & Test Results'!C35,'Sample U-factor Test'!E26))","v":"Incomplete"},"ft²"]
[null,"Temperature Differential (ΔT)",{"$f":"IF('General Info & Test Results'!C29=\"Medium Temperature\",(75-35),IF('General Info & Test Results'!C29=\"Low Temperature\",(75+10),\"Incomplete\"))","v":"Incomplete"},"°F"]
[null,"Conduction Load (Qcond)",{"$f":"IF(C13=\"Incomplete\",\"Incomplete\",C13*C14*C15)","v":"Incomplete"},"Btu/h"]
[]
[null,"Direct Energy Consumption of Electrical Components"]
[null,null,"Quantity","Units"]
[null,"Lighting"]
[null,"Rated Power (Prated)",{"$f":"IF('Test Sample Description'!D26=\"Yes\",'Test Sample Description'!E31,IF('Test Sample Description'!D31<>\"\",'Test Sample Description'!D31,0))","v":0},"W"]
[null,"Percent Time Off (PTO)",{"$f":"IF('Test Sample Description'!D28=\"Yes\", 0.5, IF('Test Sample Description'!D28=\"No\", 0.25,\"\"))","v":""},"-"]
[null,"Number of lights (n)",null,"-"]
[null,"Power of Lighting Component",{"$f":"IF(C21=0,0,C21*(1-C22)*C23*24/1000)","v":0},"kWh/day"]
[null,"Antisweat Heaters - Circuit 1"]
[null,"Rated Power (Prated)",{"$f":"IF('Test Sample Description'!D33=\"Yes\",'Test Sample Description'!E31,IF('Test Sample Description'!D37<>\"\",'Test Sample Description'!D37,0))","v":0},"W"]
[null,"Percent Time Off (PTO)",{"$f":"IF('Test Sample Description'!D34=\"No\",0,IF(AND('Test Sample Description'!D34=\"Yes\",'General Info & Test Results'!C29=\"Low Temperature\"),0.5,IF(AND('Test Sample Description'!D34=\"Yes\",'General Info & Test Results'!C29=\"Medium Temperature\"),0.75,\"\")))","v":""},"-"]
[null,"Number of circuits (n)",null,"-"]
[null,"Power of Antisweat Circuit 1",{"$f":"IF(C26=0,0,C26*(1-C27)*C28*24/1000)","v":0},"kWh/day"]
[null,"Power per Area",{"$f":"IF(C26=0,0,C26/C14)","v":0},"W/ft²"]
[null,"Antisweat Heaters - Circuit 2"]
[null,"Rated Power (Prated)",{"$f":"IF('Test Sample Description'!D39=\"Yes\",'Test Sample Description'!E43,IF('Test Sample Description'!D43<>\"\",'Test Sample Description'!D43,0))","v":0},"W"]
[null,"Percent Time Off (PTO)",{"$f":"IF('Test Sample Description'!D40=\"No\",0,IF(AND('Test Sample Description'!D40=\"Yes\",'General Info & Test Results'!C29=\"Low Temperature\"),0.5,IF(AND('Test Sample Description'!D40=\"Yes\",'General Info & Test Results'!C29=\"Medium Temperature\"),0.75,\"\")))","v":""},"-"]
[null,"Number of circuits (n)",null,"-"]
[null,"Power of Antisweat Circuit 2",{"$f":"IF(C32=0,0,C32*(1-C33)*C34*24/1000)","v":0},"kWh/day"]
[null,"Power per Area",{"$f":"IF(C32=0,0,C32/C14)","v":0},"W/ft²"]
[null,"Other (if necessary)"]
[null,"Description",{"$f":"IF('Test Sample Description'!D46<>\"\",'Test Sample Description'!D46,\"\")","v":""},"-"]
[null,"Rated Power (Prated)",{"$f":"IF(C38=\"\",\"\",IF('Test Sample Description'!D45=\"Yes\",'Test Sample Description'!E51,IF('Test Sample Description'!D51<>\"\",'Test Sample Description'!D51,0)))","v":""},"W"]
[null,"Percent Time Off (PTO)",{"$f":"IF('Test Sample Description'!D47=\"Yes\", 0.5, IF('Test Sample Description'!D47=\"No\", 0.25,\"\"))","v":""},"-"]
[null,"Number of power consuming devices (n)",null,"-"]
[null,"Power of Other Component",{"$f":"IF(C39<>\"\",C39*(1-C40)*C41*24/1000,\"\")","v":""},"kWh/day"]
[null,"Other (if necessary)"]
[null,"Description",{"$f":"IF('Test Sample Description'!D54<>\"\",'Test Sample Description'!D54,\"\")","v":""},"-"]
[null,"Rated Power (Prated)",{"$f":"IF(C44=\"\",\"\",IF('Test Sample Description'!D53=\"Yes\",'Test Sample Description'!E59,IF('Test Sample Description'!D59<>\"\",'Test Sample Description'!D59,0)))","v":""},"W"]
[null,"Percent Time Off (PTO)",{"$f":"IF('Test Sample Description'!D55=\"Yes\", 0.5, IF('Test Sample Description'!D55=\"No\", 0.25,\"\"))","v":""},"-"]
[null,"Number of power consuming devices (n)",null,"-"]
[null,"Power of Other Component",{"$f":"IF(C45<>\"\",C45*(1-C46)*C47*24/1000,\"\")","v":""},"kWh/day"]
[null,"Total Interior Electrical Energy Usage",{"$f":"C24+(0.75*(C29+C35)+(IF('Test Sample Description'!D48=\"Interior\",C42,0))+(IF('Test Sample Description'!D56=\"Interior\",C48,0)))","v":0},"kWh/day"]
[null,"Total Exterior Electrical Energy Usage",{"$f":"(0.25*(C29+C35))+(IF('Test Sample Description'!D48=\"Exterior\",C42,0))+(IF('Test Sample Description'!D56=\"Exterior\",C48,0))","v":0},"kWh/day"]
[null,"Total Direct Electrical Energy Usage",{"$f":"C49+C50","v":0},"kWh/day"]
[]
[null,"Indirect Energy Consumption of Electrical Components"]
[null,"EER",{"$f":"IF('General Info & Test Results'!C29=\"Medium Temperature\",12.4,IF('General Info & Test Results'!C29=\"Low Temperature\",6.3,\"\"))","v":""},"Btu/(W-h)"]
[null,"Total Indirect Electrical Energy Use",{"$f":"IF(C49=0,0,C49*3.412/C54)","v":0},"kWh/day"]
[]
[null,"Total Display Door Energy Consumption"]
[null,"Energy Consumption due to Thermal Load",{"$f":"IF(C16=\"Incomplete\",\"Incomplete\",C16/C54*24/1000)","v":"Incomplete"},"kWh/day"]
[null,"Total Energy Consumption",{"$f":"IF(C58=\"Incomplete\",\"Incomplete\",C58+C55+C51)","v":"Incomplete"},"kWh/day"]
[null,"Maximum Energy Consumption per 10 CFR 431.306",{"$f":"IF(AND('General Info & Test Results'!C28=\"Display Door\",'General Info & Test Results'!C29=\"Medium Temperature\"),(0.04*'Sample U-factor Test'!E26+0.41),IF(AND('General Info & Test Results'!C28=\"Display Door\",'General Info & Test Results'!C29=\"Low Temperature\"),(0.15*'Sample U-factor Test'!E26+0.29),IF(AND('General Info & Test Results'!C28=\"Passage Door\",'General Info & Test Results'!C29=\"Medium Temperature\"),(0.05*'Sample U-factor Test'!E26+1.7),IF(AND('General Info & Test Results'!C28=\"Passage Door\",'General Info & Test Results'!C29=\"Low Temperature\"),(0.14*'Sample U-factor Test'!E26+4.8),IF(AND('General Info & Test Results'!C28=\"Freight Door\",'General Info & Test Results'!C29=\"Medium Temperature\"),(0.04*'Sample U-factor Test'!E26+1.9),IF(AND('General Info & Test Results'!C28=\"Freight Door\",'General Info & Test Results'!C29=\"Low Temperature\"),(0.12*'Sample U-factor Test'!E26+5.6),\"\"))))))","v":""},"kWh/day"]

{"sheet":"Comments","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[47,1,50,5],[1,1,1,2],[12,1,15,5],[10,1,10,5],[17,1,20,5],[22,1,25,5],[27,1,30,5],[32,1,35,5],[37,1,40,5],[42,1,45,5]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"},null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Comments"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Comments"]

{"sheet":"Report Sign-Off Block","index":9,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,1,17,2],[16,1,16,2],[15,1,15,2],[1,1,1,2],[11,1,12,4],[10,1,10,4],[13,1,13,2],[14,1,14,2]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"},null,"Back to Instructions tab"]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Report Sign-Off Block"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","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'!D17","v":"[MM/DD/YYYY]"},"[Test Lab Name]"]
[null,"Template Completion",null,"[MM/DD/YYYY]","[Test Lab Name]"]
[null,"Report Reviewed by Test Lab",null,"[MM/DD/YYYY]","[Test Lab Name]"]
[null,"Report Reviewed by Test Lab",null,"[MM/DD/YYYY]","[Test Lab Name]"]

{"sheet":"Drop-Downs","index":10,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,{"$f":"'Version Control'!$B$2","v":"Title Block"}]
[null,{"$f":"'Version Control'!$B$3","v":"Test Report Template Name:"},{"$f":"'Version Control'!$C$3","v":"Walk-In Doors"}]
[null,{"$f":"'Version Control'!$B$4","v":"Version Number:"},{"$f":"'Version Control'!$C$4","v":"v1.2"}]
[null,{"$f":"'Version Control'!$B$5","v":"Latest Template Revision: "},{"$f":"'Version Control'!$C$5","v":"2020-04-13"}]
[null,{"$f":"'Version Control'!$B$6","v":"Tab Name:"},{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Drop-Downs"}]
[null,{"$f":"'Version Control'!$B$7","v":"File Name:"},{"$f":"'Version Control'!$C$7","v":"Walk-In Doors - v1.2.xlsm"}]
[null,{"$f":"'Version Control'!$B$8","v":"Test Completion Date: "},{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Y_N","Temp_Sensors","Equipment_Type","Equipment_Temperature","Condition_Received","Number"]
[null,"Yes","Interior","Display Door","Low Temperature","Good",1]
[null,"No","Exterior","Passage Door","Medium Temperature","Fair",{"$f":"G12+1","v":2}]
[null,null,null,"Freight Door",null,"Poor",{"$f":"G13+1","v":3}]
[null,null,null,null,null,null,4]
[null,null,null,null,null,null,5]
[null,"Wind_Direction","Conductance_Test","Configuration","Lighting",null,6]
[null,"Parallel","ASTM C518","Swinging door","LED"]
[null,"Perpendicular","ASTM C177","Sliding door","Fluorescent"]

{"sheet":"Version Control","index":11,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[10,1,10,2]]}
[]
[null,"Title Block"]
[null,"Test Report Template Name:","Walk-In Doors"]
[null,"Version Number:",{"$f":"INDEX(B13:B61,COUNTA(B13:B61),1)","v":"v1.2"}]
[null,"Latest Template Revision: ",{"$f":"IF(MAX(B13:C103)=0,\"No Revisions Dates Entered\",MAX(C13:C103))","v":"2020-04-13"}]
[null,"Tab Name:",{"$f":"MID(CELL(\"filename\",A1), FIND(\"]\", CELL(\"filename\", A1))+ 1, 255)","v":"Version Control"}]
[null,"File Name:",{"$f":"MID(CELL(\"FILENAME\",A1),FIND(\"[\",CELL(\"FILENAME\",A1))+1,FIND(\"]\",CELL(\"FILENAME\",A1))-FIND(\"[\",CELL(\"FILENAME\",A1))-1)","v":"Walk-In Doors - v1.2.xlsm"}]
[null,"Test Completion Date: ",{"$f":"'General Info & Test Results'!D17","v":"[MM/DD/YYYY]"}]
[]
[]
[null,"Revisions List"]
[null,"Version","Date"]
[null,"v1.0","2020-04-01"]
[null,"v1.1","2020-04-06"]
[null,"v1.2","2020-04-13"]