{"text_format":"3","workbook":"xls","n_sheets":12,"sheets":["Instructions","Data Sheet 1","Data Sheet 2","Data Sheet 3","Data Sheet 4","Data Sheet 5","Data Sheet 6","Data Sheet 7","Data Sheet 8","Data Sheet 9","HeaderExport","Version"],"not_rendered":{"external_links":1,"defined_names":209,"comments":540},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"flags":["formulas_cached_only"]}
["ERT data entry spreadsheet"]
[]
["This workbook is designed for use during the collection of data with manual sampling methods.  It is not appropriate for use with instrumental methods. The workbook is composed of this instruction page, three data entry sheets, and a header export sheet.  The header export sheet is for agency use only."]
[]
["Each Data Sheet is composed of two sections, the header data section and the point data grid. The header data section has several subsections for entry of  the necessary data applying to a given run. The sections are:"]
[]
["The run identification section which contains data about the facility, the sampling location, method used and the testing operator. The fields labeled Plant, Sampling Location, and Method entered on Data Sheet 1 will be automatically copied into Data Sheet 2 and Data Sheet 3 and will not be editable there."]
[]
["The Equipment Identification section has fields to allow entry of the identification numbers for all equipment used during the run."]
[]
["The Filters section has fields to allow entry of the identification numbers for all filters used during the run."]
[]
["In the Calibration section the user should record the calibration values for the equipment used during the sampling."]
[]
["In the Ambient Conditions section the user should record the ambient pressures, temperatures and gas concentrations."]
[]
["Checks performed during the sampling should be recorded in the Checks section either as numeric values or Yes/No values as appropriate."]
[]
["The Impinger Water Weight, Vlc, will be calculated from the entered weights of the impingers and silica gel or it can be entered directly."]
[]
["All of the fields in the point data grid should be filled in for isokinetic methods with each row containing the data from a single point.. For non-isokinetic methods, only the fields with the green background shading should be filled in."]

{"sheet":"Data Sheet 1","index":1,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[124,3,124,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",{"$nulls":5},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:","Sarah",null,null,"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 2","index":2,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[124,3,124,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:",0]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 3","index":3,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[124,3,124,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:",0]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]
[]
[]
[{"$nulls":3}," "]

{"sheet":"Data Sheet 4","index":4,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[124,3,124,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 5","index":5,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[85,3,85,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 6","index":6,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[85,3,85,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 7","index":7,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[85,3,85,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 8","index":8,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[85,3,85,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"Data Sheet 9","index":9,"n_rows":23,"n_cols":18,"rows_kept":23,"merged":[[1,2,1,13],[3,1,3,2],[3,3,3,5],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,9,4,11],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,9,5,12],[6,9,6,11],[7,1,7,4],[7,9,7,11],[8,1,8,2],[8,3,8,4],[8,5,8,7],[8,9,8,11],[9,1,9,2],[9,3,9,4],[9,5,9,7],[9,9,9,11],[10,1,10,2],[10,3,10,4],[10,5,10,7],[11,1,11,2],[11,3,11,4],[11,5,11,7],[12,1,12,2],[12,3,12,4],[12,13,12,15],[13,1,13,2],[13,3,13,4],[13,9,13,10],[13,13,13,15],[14,1,14,2],[14,3,14,4],[14,5,14,6],[14,9,14,10],[15,5,15,6],[15,9,15,10],[16,5,16,6],[16,9,16,10],[17,1,17,2],[17,3,17,4],[17,9,17,10],[18,1,18,2],[18,3,18,4],[18,5,18,6],[18,9,18,10],[19,1,19,2],[19,3,19,4],[19,5,19,6],[19,9,19,10],[19,13,19,15],[21,1,22,1],[21,2,21,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,21,8],[21,9,22,9],[21,10,22,10],[21,11,21,12],[21,13,22,13],[21,14,21,15],[21,16,22,16],[21,17,22,17],[85,3,85,7]],"flags":["formulas_cached_only"]}
[]
[null,"Plant:"]
[]
[null,"Sampling Location:",null,0,{"$nulls":3},"Method:"," ","Checks",null,null,"Pre","Mid","Post"]
[null,"Run No.:",{"$nulls":3},"Testing Operator:",{"$nulls":3},"Vacuum (in Hg):"]
[null,"Run Date:",{"$nulls":3},"Job Number:",{"$nulls":3},"Leak Check Total Volume (ft3):"]
[{"$nulls":9},"Leak Rate (cfm):"]
[null,"Equipment Identification",{"$nulls":3},"Calibration",{"$nulls":3},"Pitot (Yes/No):"]
[null,"Reagent Box:",{"$nulls":3},"Meter Box Correction Factor, Y:",{"$nulls":3},"Nozzle (Yes/No):"]
[null,"Unbilical Line:",{"$nulls":3},"Meter Box pressure differential, ΔH@ (in H2O):",{"$nulls":3},"Stack Thermocouple (Yes/No):"]
[null,"Stack Thermocouple ID: ",{"$nulls":3},"Pitot tube coefficient, Cp:"]
[null,"Tedlar Bags:",{"$nulls":3},"Nozzle diameter, Dn (in):"]
[null,"Orsat Pump:",{"$nulls":7},"Moisture in:","ml H2O","Initial","Final","Micro-manometer Used?"]
[null,"Probe Length/Type:",{"$nulls":3},"Ambient Conditions",{"$nulls":3},"Impinger 1:",{"$nulls":3},"Sensitivity (in. H2O)"]
[null,"Nozzle ID:",{"$nulls":3},"Pbar (in. Hg):",{"$nulls":3},"Impinger 2:"]
[{"$nulls":5},"Temperature:",{"$nulls":3},"Impinger 3:"]
[null,"Filters",{"$nulls":3},"Pg (in. H2O):",{"$nulls":3},"Impinger 4:"]
[null,"Filter No. 1:",{"$nulls":3},"Concentrations",{"$nulls":3},"Impinger 5:"]
[null,"Filter No. 2:",{"$nulls":3},"O2 Concentration:",{"$nulls":3},"Impinger 6:"]
[null,"Filter No. 3:",{"$nulls":3},"CO2 Concentration:",{"$nulls":3},"Silica Gel.:",{"$nulls":3},"Impinger Water Weight, Vlc:",null,null,{"v":0,"d":"0.000"}]
[]
[null,"Traverse Point No.","Sampling Time (min)",null,"Clock Time 24 hr","Dry Gas Meter Reading (Vm,ft3)","Velocity Head\n(ΔP in H2O)","Orfice Pressure Differential (ΔH, in H20)",null,"Stack Temperature °F","Probe Temperature °F","Filter Temperature °F",null,"Final exit Temperature °F","Dry Gas Meter Temperature °F",null,"Pump Vacuum (in. Hg)","Sample Rate"]
[null,null,"Begin","End",{"$nulls":3},"Desired","Actual",null,null,"Inlet","Outlet",null," Inlet"," Outlet"]

{"sheet":"HeaderExport","index":10,"n_rows":10,"n_cols":59,"rows_kept":10,"flags":["formulas_cached_only"]}
["RunNumber","RunDate","JobNumber","Method","PbHDR","PgHDR","FilterNum1","FilterNum2","FilterNum3","ReagBox","Umbical","StackTC","TedlarBag","OrasatPump","SampBox","MeterBox","TCReadOut","Pitot","Nozzle","VlcHDR","YHDR","DH@HDR","CpHDR","DnHDR","PercCO2HDR","PercO2HDR","VacCkPre","VacCkPost","InitDGM","FinalDGM","LeakRtPre","LeakRtPost","PitotCkPre","PitotCkMid","PitotCkPost","NozzleCkPre","NozzleCkMid","NozzleCkPost","StackTCCKPre","StackTCCKMid","StackTCCKPost","Personnel","Location","Impinit1","Impinit2","Impinit3","Impinit4","Impinit5","Impinit6","Silicainit","Impfin1","Impfin2","Impfin3","Impfin4","Impfin5","Impfin6","Silicafin","Manused","Mansense"]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,null,0,0,null,0,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Version","index":11,"n_rows":4,"n_cols":2,"rows_kept":4,"flags":["formulas_cached_only"]}
[]
["Version Date:","Comments"]
["2011-12-21","- fixed format rounding in run data fields for all 3 runs"]
["2012-03-26","- now has nine runs"]