{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Submission Template","Notes","Instructions"],"not_rendered":{"images":1,"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Submission Template","index":0,"n_rows":141,"n_cols":17,"rows_kept":141,"merged":[[1,0,1,17],[2,0,2,17],[3,0,3,17],[5,0,5,17],[6,0,6,17],[7,0,7,17],[11,4,11,8],[11,12,11,13],[12,4,12,8],[13,4,13,8],[14,4,14,8],[17,6,17,7],[18,6,18,7],[20,4,23,13],[25,4,28,13],[33,12,33,13],[34,15,36,15],[61,2,61,4]]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Nonroad Engine In-Use Testing Report"]
["(Large Spark Ignition Engines)"]
["Last Revision: August 2010    Version Number: 1.3"]
[]
["Basic Information",{"$nulls":14},"Submission Date"]
[]
[null,null,"     Manufacturer:",{"$nulls":7},"Engine Family:",{"$nulls":5},"OMB No. 2060-0338"]
[null,null,"     In-Use Test Contact:",{"$nulls":7},"Min. Tests Required:",{"$nulls":5},"Approval Expires on "]
[null,null,"     Email Address:",{"$nulls":13},"2022-01-31"]
[null,null,"     Phone #:",{"$nulls":13},"EPA Form  5900-93"]
[]
[null,null,"     FEL/ Emission Limit(s)"]
[{"$nulls":3},"HC+NOx",null,null,"HC+NOx Units"]
[{"$nulls":3},"CO",null,null,"CO Units"]
[]
[null,null,"     Comments:",null," "]
[]
[]
[]
[]
[null,null,"      Engines Disqualified"]
[null,null,"      and Reason:"]
[]
[]
[]
[]
["In-Use Engines Test Results"]
[]
[{"$nulls":12},"Interim Calculations"]
[{"$nulls":3},"Engine","Engine","Engine",null,null,"Diagnostic",{"$nulls":6},"If engine in noncompliant or if the test is invalid, explain why."]
[null,null,"Engine","Serial","Manufacture","Usage","Test","Test","System","Test","HC+NOx","CO","HC+NOx","CO"]
[null,null,"Model","Number","Date","Hours","Date","Time","Functioning?","Invalid?","Result","Result","Mean","Mean","Adjustments, Modifications, and Repairs",null,"Additional Comments"]
[]
[null,1,{"$nulls":10},{"$f":"IF(K39<>\"\",AVERAGE(K39),\"\")","v":""},{"$f":"IF(L39<>\"\",AVERAGE(L39),\"\")","v":""}]
[null,{"$f":"B39+1","v":2},{"$nulls":10},{"$f":"IF(K40<>\"\",AVERAGE(K$39:K40),\"\")","v":""},{"$f":"IF(L40<>\"\",AVERAGE(L$39:L40),\"\")","v":""}]
[null,3,{"$nulls":10},{"$f":"IF(K41<>\"\",AVERAGE(K$39:K41),\"\")","v":""},{"$f":"IF(L41<>\"\",AVERAGE(L$39:L41),\"\")","v":""}]
[null,4,{"$nulls":10},{"$f":"IF(K42<>\"\",AVERAGE(K$39:K42),\"\")","v":""},{"$f":"IF(L42<>\"\",AVERAGE(L$39:L42),\"\")","v":""}]
[null,5,{"$nulls":10},{"$f":"IF(K43<>\"\",AVERAGE(K$39:K43),\"\")","v":""},{"$f":"IF(L43<>\"\",AVERAGE(L$39:L43),\"\")","v":""}]
[null,6,{"$nulls":10},{"$f":"IF(K44<>\"\",AVERAGE(K$39:K44),\"\")","v":""},{"$f":"IF(L44<>\"\",AVERAGE(L$39:L44),\"\")","v":""}]
[null,7,{"$nulls":10},{"$f":"IF(K45<>\"\",AVERAGE(K$39:K45),\"\")","v":""},{"$f":"IF(L45<>\"\",AVERAGE(L$39:L45),\"\")","v":""}]
[null,8,{"$nulls":10},{"$f":"IF(K46<>\"\",AVERAGE(K$39:K46),\"\")","v":""},{"$f":"IF(L46<>\"\",AVERAGE(L$39:L46),\"\")","v":""}]
[null,9,{"$nulls":10},{"$f":"IF(K47<>\"\",AVERAGE(K$39:K47),\"\")","v":""},{"$f":"IF(L47<>\"\",AVERAGE(L$39:L47),\"\")","v":""}]
[null,10,{"$nulls":10},{"$f":"IF(K48<>\"\",AVERAGE(K$39:K48),\"\")","v":""},{"$f":"IF(L48<>\"\",AVERAGE(L$39:L48),\"\")","v":""}]
[null,11,{"$nulls":10},{"$f":"IF(K49<>\"\",AVERAGE(K$39:K49),\"\")","v":""},{"$f":"IF(L49<>\"\",AVERAGE(L$39:L49),\"\")","v":""}]
[null,12,{"$nulls":10},{"$f":"IF(K50<>\"\",AVERAGE(K$39:K50),\"\")","v":""},{"$f":"IF(L50<>\"\",AVERAGE(L$39:L50),\"\")","v":""}]
[null,13,{"$nulls":10},{"$f":"IF(K51<>\"\",AVERAGE(K$39:K51),\"\")","v":""},{"$f":"IF(L51<>\"\",AVERAGE(L$39:L51),\"\")","v":""}]
[null,14,{"$nulls":10},{"$f":"IF(K52<>\"\",AVERAGE(K$39:K52),\"\")","v":""},{"$f":"IF(L52<>\"\",AVERAGE(L$39:L52),\"\")","v":""}]
[null,15,{"$nulls":10},{"$f":"IF(K53<>\"\",AVERAGE(K$39:K53),\"\")","v":""},{"$f":"IF(L53<>\"\",AVERAGE(L$39:L53),\"\")","v":""}]
[]
[]
[null,null,"Current In-Use Test Status"]
[{"$nulls":8},"Average"]
[null,null,"     Number of HC+NOx Tests Performed:",null,null,{"$f":"SUM(D120:D134)","v":{"v":0,"d":"0 "}},null,"Pollutant","Result"]
[null,null,"     Number of CO Tests Performed:",null,null,{"$f":"SUM(E120:E134)","v":{"v":0,"d":"0 "}},null,"HC+NOx",{"$f":"IF(SUM(K39:K53)>0,AVERAGE(K39:K53),\"NA\")","v":"NA"},{"$f":"IF(AND(I59<>\"NA\",I59>$E$18), \"Average HC+NOx result exceeds FEL/Emission Limit.\",\"\")","v":""}]
[null,null,"     Number of Tests Required:",null,null,{"$f":"MIN(M13+2*SUM(C120:C134),10)","v":{"v":0,"d":"0 "}},null,"CO",{"$f":"IF(SUM(L39:L53)>0,AVERAGE(L39:L53),\"NA\")","v":"NA"},{"$f":"IF(AND(I60<>\"NA\",I60>$E$19), \"Average CO result exceeds FEL/Emission Limit.\",\"\")","v":""}]
[]
[null,null,"PASSING STATUS",null,null,{"$f":"IF(AND(E112=1,OR($E$18<>\"\",$E$19<>\"\")),\"PASS\",\"OPEN\")","v":"OPEN"}]
{"$rows_empty":30}
[null,null,"HIDDEN FIELDS"]
[]
[]
[null,null,"Yes","g/bhp-hr",4]
[null,null,"No","g/kW-hr",2]
[{"$nulls":4},1]
[]
[{"$nulls":3},"Large SI"]
[{"$nulls":3},"Small SI"]
[{"$nulls":3},"Marine SI"]
[]
[{"$nulls":3},"Testing","Sample","Average"]
[{"$nulls":3},"Required?","Met?","Passing?"]
[null,null,"HC+NOx",{"$f":"IF($E$18<>\"\",1,0)","v":0},{"$f":"IF(SUM(D120:D134)>=$F$60,1,0)","v":1},{"$f":"IF($I$59<=$E$18,1,0)","v":0}]
[null,null,"CO",{"$f":"IF(E19<>\"\",1,0)","v":0},{"$f":"IF(SUM(E120:E134)>=$F$60,1,0)","v":1},{"$f":"IF($I$60<=$E$19,1,0)","v":0}]
[]
[null,null,"HC+NOx Passing?",null,{"$f":"IF(OR(D106=0,AND(E106=1,F106=1)),1,0)","v":1}]
[null,null,"CO Passing?",null,{"$f":"IF(OR(D107=0,AND(E107=1,F107=1)),1,0)","v":1}]
[]
[null,null,"Overall Passing?",null,{"$f":"IF(AND($E$109=1,$E$110=1),1,0)","v":1}]
[]
[]
[]
[]
[{"$nulls":3},"HC+NOx","CO"]
[null,null,"Fail?","Count","Count"]
[]
[null,null,{"$f":"IF(OR(K39>$E$18,L39>$E$19),1,0)","v":0},{"$f":"IF(AND($K39<>\"\",$J39<>$C$96),1,\"\")","v":""},{"$f":"IF(AND($L39<>\"\",$J39<>$C$96),1,\"\")","v":""}]
[null,null,0,{"$f":"IF(AND($K40<>\"\",$J40<>$C$96),1,\"\")","v":""},{"$f":"IF(AND($L40<>\"\",$J40<>$C$96),1,\"\")","v":""}]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[null,null,0,"",""]
[]
[]
[]
[]
[null,null,"Average Values OK?"]
[null,null,{"$f":"IF(OR(I59<=$E$18,I59=\"NA\"),1,0)","v":1},"HC+NOx"]
[null,null,{"$f":"IF(OR(I60<=$E$19,I60=\"NA\"),1,0)","v":1},"CO"]

{"sheet":"Notes","index":1,"n_rows":68,"n_cols":12,"rows_kept":68,"merged":[[1,0,1,13],[2,0,2,13],[3,0,3,13],[5,0,5,13],[6,0,6,13],[7,0,7,13],[64,11,64,12],[65,11,65,12],[66,11,66,12],[67,11,67,12]]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Nonroad Engine In-Use Testing Report"]
["(Large Spark Ignition Engines)"]
["Last Revision: August 2010    Version Number: 1.3"]
[]
["Manufacturer Notes"]
{"$rows_empty":54}
[{"$nulls":11},"OMB No. 2060-0338"]
[{"$nulls":11},"Approval Expires on "]
[{"$nulls":11},"2022-01-31"]
[{"$nulls":11},"EPA Form  5900-93"]

{"sheet":"Instructions","index":2,"n_rows":10,"n_cols":1,"rows_kept":10,"merged":[[1,0,1,16],[2,0,2,16],[3,0,3,16],[5,0,5,16],[6,0,6,16],[7,0,7,16]]}
[]
["United States"]
["Environmental Protection Agency"]
["Office of Transportation and Air Quality"]
[]
["Nonroad Engine In-Use Testing Report"]
["(Large Spark Ignition Engines)"]
["Last Revision: August 2010    Version Number: 1.3"]
[]
["Manufacturer Data Submission Template -- INSTRUCTIONS "]