{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Start","1-Stove","2-Fuel Load","3.1-Run #1","3.2-Run #2","3.3-Run #3","3.4-Run #4"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":155,"n_cols":2,"rows_kept":155,"cut":false,"hidden":false,"merged":[[1,1,7,12],[154,1,154,12]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator"]
{"$rows_empty":152}
[null,"THIS INTEGRATED-DUTY-CYCLE (IDC) PROTOCOL FOR WOOD STOVES IS THE PROPERTY OF THE NEW YORK STATE ENERGY RESEARCH AND DEVELOPMENT AUTHORITY (NYSERDA) AND CAN BE USED TO TEST TECHNOLOGIES IN A LABORATORY SETTING. ANY DEVIATIONS OR CHANGES TO THIS IDC PROTOCOL FOR WOOD STOVES ARE NOT APPROVED OR SANCTIONED BY NYSERDA."]

{"sheet":"1-Stove","index":1,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,2,23,3],[24,2,24,3],[25,2,25,3],[29,1,29,3],[14,4,15,8],[16,5,23,8],[1,1,3,8],[31,2,31,3],[30,2,30,3],[6,1,6,3],[10,1,10,3],[7,2,7,3],[8,2,8,3],[17,1,17,3],[19,2,19,3],[18,2,18,3],[20,2,20,3],[22,2,22,3],[26,2,26,3],[21,2,21,3]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n1- Stove and Lab Information"]
[]
[]
[]
[]
[null,"1.1 Stove Information"]
[null,"Appliance manufacturer:"]
[null,"Appliance model:"]
[]
[null,"1.2 Firebox Information"]
[null,"Firebox width:",null,"in."]
[null,"Firebox depth:",null,"in."]
[null,"Firebox height:",null,"in."]
[null,"Volume adjustment:",null,"ft3","This number will be subtracted from LxWxH. If you enter a non-zero value, you should explain the reason here ↓↓↓"]
[null,"Firebox volume:",{"$f":"IF(C12*C13*C14*0.000578704-C15<=0,\"\",C12*C13*C14*0.000578704-C15)","v":""},"ft3"]
[]
[null,"1.3 Test Lab Information"]
[null,"Lab name:"]
[null,"Test lab location:"]
[null,"Primary testing staff name:"]
[null,"Test lab phone:"]
[null,"Test lab contact email:"]
[null,"Third party certifier:"]
[null,"Third party phone:"]
[null,"Third party email:"]
[null,"Other people present or participating either in person or remotely in the test:"]
[]
[]
[null,"These timestamps cannot be edited"]
[null,"Calculation Started at:","2020-12-18T15:13:25"]
[null,"Saved and Finished at:","Still in progress"]

{"sheet":"2-Fuel Load","index":2,"n_rows":29,"n_cols":22,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,1,3,7],[9,16,9,21],[24,16,24,21],[27,16,27,17],[28,16,28,17],[14,1,14,5],[6,1,6,3],[10,2,10,3],[7,2,7,3]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n2- Fuel Load Information"]
[]
[]
[]
[]
[null,"2.1 Fuel Load General Information"]
[null,"Wood species:","Oak"]
[null,"Wood density:",0.7,"103 kg/m3",{"$f":"\"= \"&TEXT(C9*0.062428*1000,\"0.0\")&\" lb/ft3\"","v":"= 43.7 lb/ft3"}]
[null,"Firebox Volume:",{"$f":"'1-Stove'!C16","v":""},"ft3",{"$nulls":12},"Poly curve fitting paramaters for calculating log characteristics"]
[null,"Loadind direction:",{"$f":"IF('1-Stove'!C12>=('1-Stove'!C13-2),\"East-West\",\"North-South\")","v":"East-West"},{"$nulls":14},"Firebox Volume, ft^3","Sm Pc. Low (in)","Sm pc Hi (in)","Lg Pc Low (in)","Lg Pc Hi (in)"]
[null,"Target log length:",{"$f":"_xlfn.IFNA(IF(OR('1-Stove'!C12=\"\",'1-Stove'!C13=\"\",'1-Stove'!C14=\"\"),\"\",INDEX({14,16,18,20,22},MATCH(MAX('1-Stove'!C12:C14),{14,16,18,20,22},1))),14)","v":""},"in.",{"$nulls":12},"\"Small\" Volume",0.8,2.2000000000000002,3.1,3.1,4.5]
[{"$nulls":16},"\"Medium\" Volume",2,2.8,4,4,5.3]
[{"$nulls":16},"\"Large\" Volume",3,3,4.4000000000000004,4.4000000000000004,6.3]
[null,"2.2 Load Piece Details",{"$nulls":16},"x2","x","c"]
[null,"Load","Total load weight (lb)","Min. piece weight (lb)","Max. piece weight (lb)","Number of pieces allowed per load",{"$nulls":10},"Poly Small Low",null,{"$f":"+LINEST(S12:S14,R12:R14^{1,2})","v":-0.13636363636363596},0.88181818181818006,1.5818181818181833]
[null,"L1 - Kindling",{"$f":"IF(C10<>\"\",C10*1,\"\")","v":""},{"$f":"IF(C10<>\"\",0.1,\"\")","v":""},{"$f":"IF(C10<>\"\",0.2,\"\")","v":""},{"$f":"IFERROR(ROUNDUP(C17/AVERAGE(D17:E17),0),\"\")","v":""},{"$nulls":10},"Poly Small Hi",null,{"$f":"+LINEST(T12:T14,R12:R14^{1,2})","v":-0.15909090909090851},1.1954545454545433,2.2454545454545469]
[null,"L1 - Starter",{"$f":"IF(C10<>\"\",C10*3,\"\")","v":""},{"$f":"IF(C10<>\"\",1,\"\")","v":""},{"$f":"IF(D19<>\"\",D19-D19*0.01,\"\")","v":""},{"$f":"IF(E18<>\"\",IFERROR(ROUNDUP(C18/AVERAGE(D18:E18),0),\"\"),\"\")","v":""},{"$nulls":10},"Poly Large Low",null,{"$f":"LINEST(U12:U14,R12:R14^{1,2})","v":-0.15909090909090851},1.1954545454545433,2.2454545454545469]
[null,"L2 - Small pieces",{"$f":"IF(C10<>\"\",C10*7,\"\")","v":""},{"$f":"IF(AND(C9<>\"\",C12<>\"\",S26<>\"\"),IFERROR(PI()*(S26^2)/4*C12*0.000578704*C9*1000/16.0185,\"\"),\"\")","v":""},{"$f":"IFERROR(MIN(IF(AND(C9<>\"\",C12<>\"\",S27<>\"\"),IFERROR(PI()*(S27^2)/4*C12*0.000578704*C9*1000/16.0185,\"\"),\"\"),D20-D20*0.01),\"\")","v":""},{"$f":"IFERROR(ROUNDUP(C19/AVERAGE(D19:E19),0),\"\")","v":""},{"$nulls":10},"Poly Large Hi",null,{"$f":"LINEST(V12:V14,R12:R14^{1,2})","v":0.15151515151515163},0.24242424242424188,4.2090909090909108]
[null,"L3 - Large pieces",{"$f":"IF(C10<>\"\",C10*5,\"\")","v":""},{"$f":"IF(AND(C9<>\"\",C12<>\"\",S28<>\"\"),IFERROR(PI()*(S28^2)/4*C12*0.000578704*C9*1000/16.0185,\"\"),\"\")","v":""},{"$f":"IF(AND(C9<>\"\",C12<>\"\",S29<>\"\"),IFERROR(PI()*(S29^2)/4*C12*0.000578704*C9*1000/16.0185,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(ROUNDUP(C20/AVERAGE(D20:E20),0)>3,3,ROUNDUP(C20/AVERAGE(D20:E20),0)),\"\")","v":""}]
[null,"L4 - Small pieces",{"$f":"IF(C10<>\"\",C10*4,\"\")","v":""},{"$f":"D19","v":""},{"$f":"E19","v":""},{"$f":"IFERROR(ROUNDUP(C21/AVERAGE(D21:E21),0),\"\")","v":""}]
[null,"L4 - Large pieces",{"$f":"IF(C10<>\"\",C10*8,\"\")","v":""},{"$f":"D20","v":""},{"$f":"E20","v":""},{"$f":"IFERROR(ROUNDUP(C22/AVERAGE(D22:E22),0),\"\")","v":""}]
[]
[]
[{"$nulls":16},"Range of the Log Diameters:"]
[{"$nulls":16},"Min. Small Log Diamter Target (in):",null,{"$f":"IFERROR(S16*C10^2+C10*T16+U16,\"\")","v":""}]
[{"$nulls":16},"Max. Small Log Diamter Target (in):",null,{"$f":"IFERROR(S17*C10^2+C10*T17+U17,\"\")","v":""}]
[{"$nulls":16},"Min. Large Log Diamter Target:",null,{"$f":"IFERROR(S18*C10^2+C10*T18+U18,\"\")","v":""}]
[{"$nulls":16},"Max. Large Log Diamter Target:",null,{"$f":"IFERROR(S19*C10^2+C10*T19+U19,\"\")","v":""}]

{"sheet":"3.1-Run #1","index":3,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[122,4,122,5],[106,2,106,7],[114,1,114,3],[116,1,116,3],[89,1,89,5],[97,1,97,5],[122,1,122,3],[113,1,113,5],[117,1,117,3],[119,1,119,3],[120,1,120,3],[111,2,111,7],[1,1,3,7],[9,1,9,5],[81,1,81,2],[81,4,81,7],[105,1,105,7],[76,2,76,6],[21,1,21,7],[23,3,23,7],[55,3,55,6],[57,1,57,7],[75,3,75,6],[67,1,67,7],[34,3,34,6],[36,1,36,7],[48,3,48,6],[65,3,65,6],[121,1,121,3],[49,2,49,6],[56,2,56,6],[118,4,118,5],[119,4,119,5],[120,4,120,5],[121,4,121,5],[66,2,66,6],[117,4,117,5],[118,1,118,3],[115,1,115,3],[107,2,107,7],[108,2,108,7],[109,2,109,7],[110,2,110,7],[5,1,6,7],[78,1,79,7],[114,4,114,5],[115,4,115,5],[116,4,116,5],[35,2,35,6],[50,1,50,7]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n3.1 Run #1 Details"]
[]
[]
[]
[null,"Detailed Fuel Information"]
[]
[]
[{"$nulls":5},"Enter the number of fuel pieces first, then enter the weight and MC details in Tables 3.2 through 3.6 ↓↓"]
[null,"3.1 Fuel Load Data"]
[null,null,"Target load (lb)","Actual weight (lb)","Allowed # of pieces","Actual # of pieces"]
[null,"L1 - Kindling weight ",{"$f":"IF('2-Fuel Load'!C17=\"\",\"\",TEXT('2-Fuel Load'!C17*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C17*1.05,\"0.00\"))","v":""},{"$f":"IF(C24=0,\"\",C24)","v":""},{"$f":"'2-Fuel Load'!F17","v":""},null,"Go to table"]
[null,"L1 - Starter",{"$f":"IF('2-Fuel Load'!C18=\"\",\"\",TEXT('2-Fuel Load'!C18*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C18*1.05,\"0.00\"))","v":""},{"$f":"IF(OR(C35=0,C24=0,SUM(C25:C34)=0),\"\",C35-C24)","v":""},{"$f":"'2-Fuel Load'!F18","v":""},null,"Go to table"]
[null,"L2 - Small pieces",{"$f":"IF('2-Fuel Load'!C19=\"\",\"\",TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\"))","v":""},{"$f":"IF(C49=0,\"\",C49)","v":""},{"$f":"'2-Fuel Load'!F19","v":""},null,"Go to table"]
[null,"L3 - Large pieces",{"$f":"IF('2-Fuel Load'!C20=\"\",\"\",TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\"))","v":""},{"$f":"IF(C56=0,\"\",C56)","v":""},{"$f":"'2-Fuel Load'!F20","v":""},null,"Go to table"]
[null,"L4 - Small pieces",{"$f":"IF('2-Fuel Load'!C21=\"\",\"\",TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$f":"'2-Fuel Load'!F21","v":""},null,"Go to table"]
[null,"L4 - Large pieces",{"$f":"IF('2-Fuel Load'!C22=\"\",\"\",TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$f":"'2-Fuel Load'!F22","v":""},null,"Go to table"]
[]
[]
[]
[]
[null,"3.2 Load 1 - Kindling and starter fuel"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Kindling total:",null,"Not applicable"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D25:G25),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D34:G34),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C24:C34)=0,\"\",SUM(C24:C34))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C25:C34)<>COUNTA(D25:G34)/4,\"\",IFERROR(SUMPRODUCT(C25:C34,H25:H34)/C35,\"\"))","v":""}]
[null,null,{"$f":"IF(OR('2-Fuel Load'!C17=\"\",'2-Fuel Load'!C18=\"\"),\"Target load is not defined yet.\",IF(OR(C35=\"\",C35<SUM('2-Fuel Load'!C17:C18)*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",IF(C35>SUM('2-Fuel Load'!C17:C18)*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.3 Load 2 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D39:G39),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D40:G40),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(COUNTA(C39:C48)=0,\"\",SUM(C39:C48))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C39:C48)<>COUNTA(D39:G48)/4,\"\",IFERROR(SUMPRODUCT(C39:C48,H39:H48)/C49,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C19=\"\",\"Target load is not defined yet.\",IF(OR(C49=\"\",C49<'2-Fuel Load'!C19*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",IF(C49>'2-Fuel Load'!C19*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.4 Load 3 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D53:G53),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D54:G54),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D55:G55),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C53:C55)=0,\"\",SUM(C53:C55))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C53:C55)<>COUNTA(D53:G55)/4,\"\",IFERROR(SUMPRODUCT(C53:C55,H53:H55)/C56,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C20=\"\",\"Target load is not defined yet.\",IF(OR(C56=\"\",C56<'2-Fuel Load'!C20*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",IF(C56>'2-Fuel Load'!C20*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.5 Load 4 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D60:G60),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C60:C65)<>COUNTA(D60:G65)/4,\"\",IFERROR(SUMPRODUCT(C60:C65,H60:H65)/C66,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C21=\"\",\"Target load is not defined yet.\",IF(OR(C66=\"\",C66<'2-Fuel Load'!C21*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",IF(C66>'2-Fuel Load'!C21*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.6 Load 4 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D70:G70),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C70:C75)<>COUNTA(D70:G75)/4,\"\",IFERROR(SUMPRODUCT(C70:C75,H70:H75)/C76,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C22=\"\",\"Target load is not defined yet.\",IF(OR(C76=\"\",C76<'2-Fuel Load'!C22*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",IF(C76>'2-Fuel Load'!C22*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[]
[null,"Other Testing Information"]
[]
[]
[null,"3.7 Run Information",null,null,"3.8 Test Lab Condition"]
[null,"Run date:",null,null,null,"pre-test","post-test"]
[null,"Run number:",null,null,"Temperature:",null,null,"F"]
[null,"Testing staff:",null,null,"Barometric pressure:",null,null,"in. Hg"]
[null,"Witnesses or others present for test:",null,null,"Relative humidity:",null,null,"%"]
[null,"Start time:"]
[null,"End time:"]
[]
[null,"3.9 Run Operation Data"]
[null,"Load","Actual weight at start of phase before loading (lb)","Actual weight at start of phase after loading (lb)","Target weight at end of phase (lb)","Actual Weight at end of phase (lb)"]
[null,"L1 (Fully Open)",null,null,{"$f":"IFERROR(D14*0.175,\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E92,\"0.00\")&\"–\"&TEXT(1.05*E92,\"0.00\"),\"\")","v":""}]
[null,"L2(A) (Fully Open)",null,null,{"$f":"IFERROR(F92+(D14/3),\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E93,\"0.00\")&\"–\"&TEXT(1.05*E93,\"0.00\"),\"\")","v":""}]
[null,"L2(B) (Fully Closed)",null,"Not applicable",{"$f":"IFERROR(F92+(D14*0.1),\"\")","v":""},null,""]
[null,"L3 (Fully Closed)",null,null,{"$f":"IFERROR(F94+(D15*0.1),\"\")","v":""},null,""]
[null,"L4 (Fully Closed)",null,null,{"$f":"IFERROR(F95+D16*0.1+D17*0.1,\"\")","v":""},null,""]
[]
[null,"3.10 Run Operation Data"]
[null,"Load","Start time","End time","Door open time","Door closed time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.11 Run Operation Data"]
[null,"Load","Notes on fuel adjustments/time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.12 Post Run Data Check"]
[null,"1) Any data points with filter temperatures outside the 80-90F?"]
[null,"If yes, how many and for how long"]
[null,"2) Did tunnel temperature exceed 40C during the test?"]
[null,"If yes, how many and for how long"]
[null,"3) Did tunnel humidity exceed 90%?"]
[null,"If yes, how many and for how long"]
[null,"4) Any tunnel dew point measurements within 2C of filter temp"]
[null,"If yes, how many and for how long"]
[null,"5) Tunnel flow for test? (dscf/min)"]

{"sheet":"3.2-Run #2","index":4,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[34,3,34,6],[1,1,3,7],[5,1,6,7],[9,1,9,5],[21,1,21,7],[23,3,23,7],[75,3,75,6],[35,2,35,6],[36,1,36,7],[48,3,48,6],[49,2,49,6],[50,1,50,7],[55,3,55,6],[56,2,56,6],[57,1,57,7],[65,3,65,6],[66,2,66,6],[67,1,67,7],[110,2,110,7],[76,2,76,6],[78,1,79,7],[81,1,81,2],[81,4,81,7],[89,1,89,5],[97,1,97,5],[105,1,105,7],[106,2,106,7],[107,2,107,7],[108,2,108,7],[109,2,109,7],[111,2,111,7],[113,1,113,5],[114,1,114,3],[114,4,114,5],[115,1,115,3],[115,4,115,5],[116,1,116,3],[116,4,116,5],[117,1,117,3],[117,4,117,5],[118,1,118,3],[118,4,118,5],[122,1,122,3],[122,4,122,5],[119,1,119,3],[119,4,119,5],[120,1,120,3],[120,4,120,5],[121,1,121,3],[121,4,121,5]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n3.2 Run #2 Details"]
[]
[]
[]
[null,"Detailed Fuel Information"]
[]
[]
[{"$nulls":5},"Enter the number of fuel pieces first, then enter the weight and MC details in Tables 3.2 through 3.6 ↓↓"]
[null,"3.1 Fuel Load Data"]
[null,null,"Target load (lb)","Actual weight (lb)","Allowed # of pieces","Actual # of pieces"]
[null,"L1 - Kindling weight ",{"$f":"IF('2-Fuel Load'!C17=\"\",\"\",TEXT('2-Fuel Load'!C17*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C17*1.05,\"0.00\"))","v":""},{"$f":"IF(C24=0,\"\",C24)","v":""},{"$f":"'2-Fuel Load'!F17","v":""},null,"Go to table"]
[null,"L1 - Starter",{"$f":"IF('2-Fuel Load'!C18=\"\",\"\",TEXT('2-Fuel Load'!C18*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C18*1.05,\"0.00\"))","v":""},{"$f":"IF(OR(C35=0,C24=0,SUM(C25:C34)=0),\"\",C35-C24)","v":""},{"$f":"'2-Fuel Load'!F18","v":""},null,"Go to table"]
[null,"L2 - Small pieces",{"$f":"IF('2-Fuel Load'!C19=\"\",\"\",TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\"))","v":""},{"$f":"IF(C49=0,\"\",C49)","v":""},{"$f":"'2-Fuel Load'!F19","v":""},null,"Go to table"]
[null,"L3 - Large pieces",{"$f":"IF('2-Fuel Load'!C20=\"\",\"\",TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\"))","v":""},{"$f":"IF(C56=0,\"\",C56)","v":""},{"$f":"'2-Fuel Load'!F20","v":""},null,"Go to table"]
[null,"L4 - Small pieces",{"$f":"IF('2-Fuel Load'!C21=\"\",\"\",TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$f":"'2-Fuel Load'!F21","v":""},null,"Go to table"]
[null,"L4 - Large pieces",{"$f":"IF('2-Fuel Load'!C22=\"\",\"\",TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$f":"'2-Fuel Load'!F22","v":""},null,"Go to table"]
[]
[]
[]
[]
[null,"3.2 Load 1 - Kindling and starter fuel"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Kindling total:",null,"Not applicable"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D25:G25),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D34:G34),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C24:C34)=0,\"\",SUM(C24:C34))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C25:C34)<>COUNTA(D25:G34)/4,\"\",IFERROR(SUMPRODUCT(C25:C34,H25:H34)/C35,\"\"))","v":""}]
[null,null,{"$f":"IF(OR('2-Fuel Load'!C17=\"\",'2-Fuel Load'!C18=\"\"),\"Target load is not defined yet.\",IF(OR(C35=\"\",C35<SUM('2-Fuel Load'!C17:C18)*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",IF(C35>SUM('2-Fuel Load'!C17:C18)*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.3 Load 2 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D39:G39),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D40:G40),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(COUNTA(C39:C48)=0,\"\",SUM(C39:C48))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C39:C48)<>COUNTA(D39:G48)/4,\"\",IFERROR(SUMPRODUCT(C39:C48,H39:H48)/C49,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C19=\"\",\"Target load is not defined yet.\",IF(OR(C49=\"\",C49<'2-Fuel Load'!C19*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",IF(C49>'2-Fuel Load'!C19*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.4 Load 3 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D53:G53),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D54:G54),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D55:G55),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C53:C55)=0,\"\",SUM(C53:C55))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C53:C55)<>COUNTA(D53:G55)/4,\"\",IFERROR(SUMPRODUCT(C53:C55,H53:H55)/C56,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C20=\"\",\"Target load is not defined yet.\",IF(OR(C56=\"\",C56<'2-Fuel Load'!C20*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",IF(C56>'2-Fuel Load'!C20*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.5 Load 4 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D60:G60),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C60:C65)<>COUNTA(D60:G65)/4,\"\",IFERROR(SUMPRODUCT(C60:C65,H60:H65)/C66,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C21=\"\",\"Target load is not defined yet.\",IF(OR(C66=\"\",C66<'2-Fuel Load'!C21*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",IF(C66>'2-Fuel Load'!C21*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.6 Load 4 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D70:G70),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C70:C75)<>COUNTA(D70:G75)/4,\"\",IFERROR(SUMPRODUCT(C70:C75,H70:H75)/C76,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C22=\"\",\"Target load is not defined yet.\",IF(OR(C76=\"\",C76<'2-Fuel Load'!C22*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",IF(C76>'2-Fuel Load'!C22*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[]
[null,"Other Testing Information"]
[]
[]
[null,"3.7 Run Information",null,null,"3.8 Test Lab Condition"]
[null,"Run date:",null,null,null,"pre-test","post-test"]
[null,"Run number:",null,null,"Temperature:",null,null,"F"]
[null,"Testing staff:",null,null,"Barometric pressure:",null,null,"in. Hg"]
[null,"Witnesses or others present for test:",null,null,"Relative humidity:",null,null,"%"]
[null,"Start time:"]
[null,"End time:"]
[]
[null,"3.9 Run Operation Data"]
[null,"Load","Actual weight at start of phase before loading (lb)","Actual weight at start of phase after loading (lb)","Target weight at end of phase (lb)","Actual Weight at end of phase (lb)"]
[null,"L1 (Fully Open)",null,null,{"$f":"IFERROR(D14*0.175,\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E92,\"0.00\")&\"–\"&TEXT(1.05*E92,\"0.00\"),\"\")","v":""}]
[null,"L2(A) (Fully Open)",null,null,{"$f":"IFERROR(F92+(D14/3),\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E93,\"0.00\")&\"–\"&TEXT(1.05*E93,\"0.00\"),\"\")","v":""}]
[null,"L2(B) (Fully Closed)",null,"Not applicable",{"$f":"IFERROR(F92+(D14*0.1),\"\")","v":""},null,""]
[null,"L3 (Fully Closed)",null,null,{"$f":"IFERROR(F94+(D15*0.1),\"\")","v":""},null,""]
[null,"L4 (Fully Closed)",null,null,{"$f":"IFERROR(F95+D16*0.1+D17*0.1,\"\")","v":""},null,""]
[]
[null,"3.10 Run Operation Data"]
[null,"Load","Start time","End time","Door open time","Door closed time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.11 Run Operation Data"]
[null,"Load","Notes on fuel adjustments/time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.12 Post Run Data Check"]
[null,"1) Any data points with filter temperatures outside the 80-90F?"]
[null,"If yes, how many and for how long"]
[null,"2) Did tunnel temperature exceed 40C during the test?"]
[null,"If yes, how many and for how long"]
[null,"3) Did tunnel humidity exceed 90%?"]
[null,"If yes, how many and for how long"]
[null,"4) Any tunnel dew point measurements within 2C of filter temp"]
[null,"If yes, how many and for how long"]
[null,"5) Tunnel flow for test? (dscf/min)"]

{"sheet":"3.3-Run #3","index":5,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[34,3,34,6],[1,1,3,7],[5,1,6,7],[9,1,9,5],[21,1,21,7],[23,3,23,7],[75,3,75,6],[35,2,35,6],[36,1,36,7],[48,3,48,6],[49,2,49,6],[50,1,50,7],[55,3,55,6],[56,2,56,6],[57,1,57,7],[65,3,65,6],[66,2,66,6],[67,1,67,7],[110,2,110,7],[76,2,76,6],[78,1,79,7],[81,1,81,2],[81,4,81,7],[89,1,89,5],[97,1,97,5],[105,1,105,7],[106,2,106,7],[107,2,107,7],[108,2,108,7],[109,2,109,7],[111,2,111,7],[113,1,113,5],[114,1,114,3],[114,4,114,5],[115,1,115,3],[115,4,115,5],[116,1,116,3],[116,4,116,5],[117,1,117,3],[117,4,117,5],[118,1,118,3],[118,4,118,5],[122,1,122,3],[122,4,122,5],[119,1,119,3],[119,4,119,5],[120,1,120,3],[120,4,120,5],[121,1,121,3],[121,4,121,5]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n3.3 Run #3 Details"]
[]
[]
[]
[null,"Detailed Fuel Information"]
[]
[]
[{"$nulls":5},"Enter the number of fuel pieces first, then enter the weight and MC details in Tables 3.2 through 3.6 ↓↓"]
[null,"3.1 Fuel Load Data"]
[null,null,"Target load (lb)","Actual weight (lb)","Allowed # of pieces","Actual # of pieces"]
[null,"L1 - Kindling weight ",{"$f":"IF('2-Fuel Load'!C17=\"\",\"\",TEXT('2-Fuel Load'!C17*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C17*1.05,\"0.00\"))","v":""},{"$f":"IF(C24=0,\"\",C24)","v":""},{"$f":"'2-Fuel Load'!F17","v":""},null,"Go to table"]
[null,"L1 - Starter",{"$f":"IF('2-Fuel Load'!C18=\"\",\"\",TEXT('2-Fuel Load'!C18*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C18*1.05,\"0.00\"))","v":""},{"$f":"IF(OR(C35=0,C24=0,SUM(C25:C34)=0),\"\",C35-C24)","v":""},{"$f":"'2-Fuel Load'!F18","v":""},null,"Go to table"]
[null,"L2 - Small pieces",{"$f":"IF('2-Fuel Load'!C19=\"\",\"\",TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\"))","v":""},{"$f":"IF(C49=0,\"\",C49)","v":""},{"$f":"'2-Fuel Load'!F19","v":""},null,"Go to table"]
[null,"L3 - Large pieces",{"$f":"IF('2-Fuel Load'!C20=\"\",\"\",TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\"))","v":""},{"$f":"IF(C56=0,\"\",C56)","v":""},{"$f":"'2-Fuel Load'!F20","v":""},null,"Go to table"]
[null,"L4 - Small pieces",{"$f":"IF('2-Fuel Load'!C21=\"\",\"\",TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$f":"'2-Fuel Load'!F21","v":""},null,"Go to table"]
[null,"L4 - Large pieces",{"$f":"IF('2-Fuel Load'!C22=\"\",\"\",TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$f":"'2-Fuel Load'!F22","v":""},null,"Go to table"]
[]
[]
[]
[]
[null,"3.2 Load 1 - Kindling and starter fuel"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Kindling total:",null,"Not applicable"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D25:G25),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D34:G34),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C24:C34)=0,\"\",SUM(C24:C34))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C25:C34)<>COUNTA(D25:G34)/4,\"\",IFERROR(SUMPRODUCT(C25:C34,H25:H34)/C35,\"\"))","v":""}]
[null,null,{"$f":"IF(OR('2-Fuel Load'!C17=\"\",'2-Fuel Load'!C18=\"\"),\"Target load is not defined yet.\",IF(OR(C35=\"\",C35<SUM('2-Fuel Load'!C17:C18)*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",IF(C35>SUM('2-Fuel Load'!C17:C18)*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.3 Load 2 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D39:G39),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D40:G40),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(COUNTA(C39:C48)=0,\"\",SUM(C39:C48))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C39:C48)<>COUNTA(D39:G48)/4,\"\",IFERROR(SUMPRODUCT(C39:C48,H39:H48)/C49,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C19=\"\",\"Target load is not defined yet.\",IF(OR(C49=\"\",C49<'2-Fuel Load'!C19*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",IF(C49>'2-Fuel Load'!C19*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.4 Load 3 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D53:G53),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D54:G54),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D55:G55),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C53:C55)=0,\"\",SUM(C53:C55))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C53:C55)<>COUNTA(D53:G55)/4,\"\",IFERROR(SUMPRODUCT(C53:C55,H53:H55)/C56,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C20=\"\",\"Target load is not defined yet.\",IF(OR(C56=\"\",C56<'2-Fuel Load'!C20*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",IF(C56>'2-Fuel Load'!C20*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.5 Load 4 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D60:G60),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C60:C65)<>COUNTA(D60:G65)/4,\"\",IFERROR(SUMPRODUCT(C60:C65,H60:H65)/C66,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C21=\"\",\"Target load is not defined yet.\",IF(OR(C66=\"\",C66<'2-Fuel Load'!C21*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",IF(C66>'2-Fuel Load'!C21*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.6 Load 4 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D70:G70),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C70:C75)<>COUNTA(D70:G75)/4,\"\",IFERROR(SUMPRODUCT(C70:C75,H70:H75)/C76,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C22=\"\",\"Target load is not defined yet.\",IF(OR(C76=\"\",C76<'2-Fuel Load'!C22*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",IF(C76>'2-Fuel Load'!C22*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[]
[null,"Other Testing Information"]
[]
[]
[null,"3.7 Run Information",null,null,"3.8 Test Lab Condition"]
[null,"Run date:",null,null,null,"pre-test","post-test"]
[null,"Run number:",null,null,"Temperature:",null,null,"F"]
[null,"Testing staff:",null,null,"Barometric pressure:",null,null,"in. Hg"]
[null,"Witnesses or others present for test:",null,null,"Relative humidity:",null,null,"%"]
[null,"Start time:"]
[null,"End time:"]
[]
[null,"3.9 Run Operation Data"]
[null,"Load","Actual weight at start of phase before loading (lb)","Actual weight at start of phase after loading (lb)","Target weight at end of phase (lb)","Actual Weight at end of phase (lb)"]
[null,"L1 (Fully Open)",null,null,{"$f":"IFERROR(D14*0.175,\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E92,\"0.00\")&\"–\"&TEXT(1.05*E92,\"0.00\"),\"\")","v":""}]
[null,"L2(A) (Fully Open)",null,null,{"$f":"IFERROR(F92+(D14/3),\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E93,\"0.00\")&\"–\"&TEXT(1.05*E93,\"0.00\"),\"\")","v":""}]
[null,"L2(B) (Fully Closed)",null,"Not applicable",{"$f":"IFERROR(F92+(D14*0.1),\"\")","v":""},null,""]
[null,"L3 (Fully Closed)",null,null,{"$f":"IFERROR(F94+(D15*0.1),\"\")","v":""},null,""]
[null,"L4 (Fully Closed)",null,null,{"$f":"IFERROR(F95+D16*0.1+D17*0.1,\"\")","v":""},null,""]
[]
[null,"3.10 Run Operation Data"]
[null,"Load","Start time","End time","Door open time","Door closed time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.11 Run Operation Data"]
[null,"Load","Notes on fuel adjustments/time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.12 Post Run Data Check"]
[null,"1) Any data points with filter temperatures outside the 80-90F?"]
[null,"If yes, how many and for how long"]
[null,"2) Did tunnel temperature exceed 40C during the test?"]
[null,"If yes, how many and for how long"]
[null,"3) Did tunnel humidity exceed 90%?"]
[null,"If yes, how many and for how long"]
[null,"4) Any tunnel dew point measurements within 2C of filter temp"]
[null,"If yes, how many and for how long"]
[null,"5) Tunnel flow for test? (dscf/min)"]

{"sheet":"3.4-Run #4","index":6,"n_rows":123,"n_cols":8,"rows_kept":123,"cut":false,"hidden":true,"merged":[[34,3,34,6],[1,1,3,7],[5,1,6,7],[9,1,9,5],[21,1,21,7],[23,3,23,7],[75,3,75,6],[35,2,35,6],[36,1,36,7],[48,3,48,6],[49,2,49,6],[50,1,50,7],[55,3,55,6],[56,2,56,6],[57,1,57,7],[65,3,65,6],[66,2,66,6],[67,1,67,7],[110,2,110,7],[76,2,76,6],[78,1,79,7],[81,1,81,2],[81,4,81,7],[89,1,89,5],[97,1,97,5],[105,1,105,7],[106,2,106,7],[107,2,107,7],[108,2,108,7],[109,2,109,7],[111,2,111,7],[113,1,113,5],[114,1,114,3],[114,4,114,5],[115,1,115,3],[115,4,115,5],[116,1,116,3],[116,4,116,5],[117,1,117,3],[117,4,117,5],[118,1,118,3],[118,4,118,5],[122,1,122,3],[122,4,122,5],[119,1,119,3],[119,4,119,5],[120,1,120,3],[120,4,120,5],[121,1,121,3],[121,4,121,5]]}
[]
[null,"Integrated Duty Cycle Fuel Calculator\n3.4 Run #4 Details"]
[]
[]
[]
[null,"Detailed Fuel Information"]
[]
[]
[{"$nulls":5},"Enter the number of fuel pieces first, then enter the weight and MC details in Tables 3.2 through 3.6 ↓↓"]
[null,"3.1 Fuel Load Data"]
[null,null,"Target load (lb)","Actual weight (lb)","Allowed # of pieces","Actual # of pieces"]
[null,"L1 - Kindling weight ",{"$f":"IF('2-Fuel Load'!C17=\"\",\"\",TEXT('2-Fuel Load'!C17*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C17*1.05,\"0.00\"))","v":""},{"$f":"IF(C24=0,\"\",C24)","v":""},{"$f":"'2-Fuel Load'!F17","v":""},null,"Go to table"]
[null,"L1 - Starter",{"$f":"IF('2-Fuel Load'!C18=\"\",\"\",TEXT('2-Fuel Load'!C18*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C18*1.05,\"0.00\"))","v":""},{"$f":"IF(OR(C35=0,C24=0,SUM(C25:C34)=0),\"\",C35-C24)","v":""},{"$f":"'2-Fuel Load'!F18","v":""},null,"Go to table"]
[null,"L2 - Small pieces",{"$f":"IF('2-Fuel Load'!C19=\"\",\"\",TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\"))","v":""},{"$f":"IF(C49=0,\"\",C49)","v":""},{"$f":"'2-Fuel Load'!F19","v":""},null,"Go to table"]
[null,"L3 - Large pieces",{"$f":"IF('2-Fuel Load'!C20=\"\",\"\",TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\"))","v":""},{"$f":"IF(C56=0,\"\",C56)","v":""},{"$f":"'2-Fuel Load'!F20","v":""},null,"Go to table"]
[null,"L4 - Small pieces",{"$f":"IF('2-Fuel Load'!C21=\"\",\"\",TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$f":"'2-Fuel Load'!F21","v":""},null,"Go to table"]
[null,"L4 - Large pieces",{"$f":"IF('2-Fuel Load'!C22=\"\",\"\",TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\" – \"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\"))","v":""},{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$f":"'2-Fuel Load'!F22","v":""},null,"Go to table"]
[]
[]
[]
[]
[null,"3.2 Load 1 - Kindling and starter fuel"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Kindling total:",null,"Not applicable"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D25:G25),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D34:G34),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C24:C34)=0,\"\",SUM(C24:C34))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C25:C34)<>COUNTA(D25:G34)/4,\"\",IFERROR(SUMPRODUCT(C25:C34,H25:H34)/C35,\"\"))","v":""}]
[null,null,{"$f":"IF(OR('2-Fuel Load'!C17=\"\",'2-Fuel Load'!C18=\"\"),\"Target load is not defined yet.\",IF(OR(C35=\"\",C35<SUM('2-Fuel Load'!C17:C18)*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",IF(C35>SUM('2-Fuel Load'!C17:C18)*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT(SUM('2-Fuel Load'!C17:C18)*0.95,\"0.00\")&\"–\"&TEXT(SUM('2-Fuel Load'!C17:C18)*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D18,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E18,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.3 Load 2 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D39:G39),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D40:G40),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Piece 7:",{"$nulls":5},""]
[null,"Piece 8:",{"$nulls":5},""]
[null,"Piece 9:",{"$nulls":5},""]
[null,"Piece 10:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(COUNTA(C39:C48)=0,\"\",SUM(C39:C48))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C39:C48)<>COUNTA(D39:G48)/4,\"\",IFERROR(SUMPRODUCT(C39:C48,H39:H48)/C49,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C19=\"\",\"Target load is not defined yet.\",IF(OR(C49=\"\",C49<'2-Fuel Load'!C19*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",IF(C49>'2-Fuel Load'!C19*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C19*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C19*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D19,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E19,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.4 Load 3 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D53:G53),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D54:G54),\"\")","v":""}]
[null,"Piece 3:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D55:G55),\"\")","v":""}]
[null,"Load total:",{"$f":"IF(COUNTA(C53:C55)=0,\"\",SUM(C53:C55))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C53:C55)<>COUNTA(D53:G55)/4,\"\",IFERROR(SUMPRODUCT(C53:C55,H53:H55)/C56,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C20=\"\",\"Target load is not defined yet.\",IF(OR(C56=\"\",C56<'2-Fuel Load'!C20*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",IF(C56>'2-Fuel Load'!C20*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C20*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C20*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D20,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E20,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.5 Load 4 - Small pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D60:G60),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C60:C65)=0,\"\",SUM(C60:C65))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C60:C65)<>COUNTA(D60:G65)/4,\"\",IFERROR(SUMPRODUCT(C60:C65,H60:H65)/C66,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C21=\"\",\"Target load is not defined yet.\",IF(OR(C66=\"\",C66<'2-Fuel Load'!C21*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",IF(C66>'2-Fuel Load'!C21*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C21*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C21*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D21,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E21,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[null,"3.6 Load 4 - Large pieces"]
[null,"set the # of logs","Weight (lb)","pin 1 (%)","pin 2 (%)","pin 3 (%)","pin 4 (%)","Avg moisture"]
[null,"Piece 1:",{"$nulls":5},{"$f":"IFERROR(AVERAGE(D70:G70),\"\")","v":""}]
[null,"Piece 2:",{"$nulls":5},""]
[null,"Piece 3:",{"$nulls":5},""]
[null,"Piece 4:",{"$nulls":5},""]
[null,"Piece 5:",{"$nulls":5},""]
[null,"Piece 6:",{"$nulls":5},""]
[null,"Load total:",{"$f":"IF(SUM(C70:C75)=0,\"\",SUM(C70:C75))","v":""},{"$nulls":4},{"$f":"IF(COUNTA(C70:C75)<>COUNTA(D70:G75)/4,\"\",IFERROR(SUMPRODUCT(C70:C75,H70:H75)/C76,\"\"))","v":""}]
[null,null,{"$f":"IF('2-Fuel Load'!C22=\"\",\"Target load is not defined yet.\",IF(OR(C76=\"\",C76<'2-Fuel Load'!C22*0.95),\"↑↑ Add more fuel pieces or use heavier logs to reach the target weight: \"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",IF(C76>'2-Fuel Load'!C22*1.05,\"↑↑ Remove some fuel pieces or use lighter logs to reach the target weight :\"&TEXT('2-Fuel Load'!C22*0.95,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!C22*1.05,\"0.00\")&\" lb\"&CHAR(10)&\"Allowed weight of each piece: \"&TEXT('2-Fuel Load'!D22,\"0.00\")&\"–\"&TEXT('2-Fuel Load'!E22,\"0.00\")&\" lb\",\"✓ Load weight is in the range\")))","v":"Target load is not defined yet."}]
[]
[null,"Other Testing Information"]
[]
[]
[null,"3.7 Run Information",null,null,"3.8 Test Lab Condition"]
[null,"Run date:",null,null,null,"pre-test","post-test"]
[null,"Run number:",null,null,"Temperature:",null,null,"F"]
[null,"Testing staff:",null,null,"Barometric pressure:",null,null,"in. Hg"]
[null,"Witnesses or others present for test:",null,null,"Relative humidity:",null,null,"%"]
[null,"Start time:"]
[null,"End time:"]
[]
[null,"3.9 Run Operation Data"]
[null,"Load","Actual weight at start of phase before loading (lb)","Actual weight at start of phase after loading (lb)","Target weight at end of phase (lb)","Actual Weight at end of phase (lb)"]
[null,"L1 (Fully Open)",null,null,{"$f":"IFERROR(D14*0.175,\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E92,\"0.00\")&\"–\"&TEXT(1.05*E92,\"0.00\"),\"\")","v":""}]
[null,"L2(A) (Fully Open)",null,null,{"$f":"IFERROR(F92+(D14/3),\"\")","v":""},null,{"$f":"IFERROR(\" Allowable range: \"&TEXT(0.95*E93,\"0.00\")&\"–\"&TEXT(1.05*E93,\"0.00\"),\"\")","v":""}]
[null,"L2(B) (Fully Closed)",null,"Not applicable",{"$f":"IFERROR(F92+(D14*0.1),\"\")","v":""},null,""]
[null,"L3 (Fully Closed)",null,null,{"$f":"IFERROR(F94+(D15*0.1),\"\")","v":""},null,""]
[null,"L4 (Fully Closed)",null,null,{"$f":"IFERROR(F95+D16*0.1+D17*0.1,\"\")","v":""},null,""]
[]
[null,"3.10 Run Operation Data"]
[null,"Load","Start time","End time","Door open time","Door closed time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.11 Run Operation Data"]
[null,"Load","Notes on fuel adjustments/time"]
[null,"L1 (Fully Open)"]
[null,"L2(A) (Fully Open)"]
[null,"L2(B) (Fully Closed)"]
[null,"L3 (Fully Closed)"]
[null,"L4 (Fully Closed)"]
[]
[null,"3.12 Post Run Data Check"]
[null,"1) Any data points with filter temperatures outside the 80-90F?"]
[null,"If yes, how many and for how long"]
[null,"2) Did tunnel temperature exceed 40C during the test?"]
[null,"If yes, how many and for how long"]
[null,"3) Did tunnel humidity exceed 90%?"]
[null,"If yes, how many and for how long"]
[null,"4) Any tunnel dew point measurements within 2C of filter temp"]
[null,"If yes, how many and for how long"]
[null,"5) Tunnel flow for test? (dscf/min)"]