{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Instructions-Definitions","T1A - Site Summary","T1B - Site Performance Summary","T1C - Treatment Well Details","T1D - Process Summary","T1E - Maintenance Summary","T2 - GWR Performance","T3A - AS Performance","T3B - SVE Performance","T3C - MPX Performance","T4 - GW Elevation (FP)","T4A - GW Elevation (No FP)","T5 - GWR Analytical","T6 - MW Analytical ","T7 - SVE Analytical ","T8 - SVE-MPX Well","T9 - AS Well","T10 - GWR RW","T11 - System Influence"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions-Definitions","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,8],[1,0,1,8]]}
["General Instructions:","This RA Summary Report should be prepared and submitted for each site.  A Summary Report along with the milestone worksheet, text and graphs are required for a complete O&M Report.   "]
["milestone worksheet, text and graphs are required for a complete O&M Report.   "]
[]
["Instructions for Each Table:"]
[null,"Table Name","Instructions"]
["T1A","Site Summary","Assessment, remediation, and operation history of the site"]
["T1B","Site Performance Summary","Milestone and runtime summary"]
["T1C","Treatment Well Detail","Description of treatment wells grouped by depth, type, process"]
["T1D","Process Summary","Description of remediation equipment"]
["T1E","Maintenance Summary","Description, type, and date of maintenance performed"]
["T2","GWR System Performance","Runtime and recovery data for multi-phase or ground water recovery system"]
["T3A","AS Performance ","Runtime and operation data for an air sparge or bio-sparge system"]
["T3B","SVE Performance","Runtime and operation data for a soil vapor extraction system"]
["T3C","MPX Performance","Runtime and operation data for the vapor phase of a multi-phase system"]
["T4","GW Elevation (FP)","Used at sites where free product measurements are required"]
["T4A","GW Elevation (No FP)","Used at sites where no free product measurements are required"]
["T5","GWR Analytical Summary","Analytical data collected from recovered ground water "]
["T6","MW Analytical Summary","Analytical data from monitor wells and indentify key wells"]
["T7","Vapor Analytical Summary","Soil vapor extraction analytical data"]
["T8","SVE-MPX Well Data","Soil vapor or multi-phase extraction well flow and vacuum data"]
["T9","AS Well Data","Air sparge well flow and pressure data"]
["T10","GWR Well Data","GWR/MPX recovery data"]
["T11","System Influence","Dissolved oxygen, pressure, and vacuum data collected from"]
[null,null,"monitoring wells to determine influence of the system"]
["Definitions"]
[]
["Report Type:","Startup, Quarter 1, Annual, etc."]
["Lithology:","Indentify the lithology of the zone being treated: sand, sandy clay, clayey sand, clay, silt"]
["Product Types:","Unleaded, leaded, diesel, jet fuel, kerosene"]
["Treatment Process:","Air Sparging (AS), Soil Vapor Extraction (SVE), Bio-Sparging (BS), Multi-Phase Extraction (MPX)"]
[null,"Ground Water Recovery (GWR), Thermal Treatment (TT), Carbon Treatment (GAC), Heat Exchange (HX)"]
["System Type","List the combination of processes used: AS/SVE, AS/MPX, BS, SVE, GWR, GWR/SVE, etc."]
["Excavation Type:","Large Diameter Auger (LDA), Conventional Excavation (Conv), LDA/Conv.  "]
["System Size:","Small (S), Medium (M), Large (L)  "]
["Well Type","Vertical Well (VW), Horizontal Well (HW)"]
["Equipment Type","Rotary vane AC, Rotary screw AC, Regenerative Blower (RB), PD Blower, etc.  "]
["Process Vacuum","Use inches of mercury for MPX and inches of water for SVE"]
["Contaminant Groups","Benzene, TEX, Naps, MTBE, PAHs I, PAHs II, TRPH"]
["Cleanup Team","PCS1-6, LP01-58"]
["Well Material","Material used for treatment well: PVC, HDPE, Shuma, list any other material used"]
["Installation Method","List installation method, direct push (DP), hollow stem auger (HAS), mud rotary (MR),"]
[null,"directional drilling (DD), sonic, hand, other"]
["Predicted EAR Date","The predicted date of the end of active remediation (EAR)"]
["Enclosure Type:","Trailer, container, building, roof, none"]
["Run Time Reporting","Report run time for reporting period and cumulative run time since start-up for each system in Table 1B."]
[null,"Tables 3 A-C will calculate combined run time when multiple compressors or blowers are used."]
["Maintenance Type","Specify maintenance type in Table 1E, e.g., warranty repair (WR), routine maintenance (RM),      "]
[null,"component failure (CF)"]
["COC","Contaminant of Concern "]
["Notes:","Use this section to identify cluster sites and any other site information not listed."]

{"sheet":"T1A - Site Summary","index":1,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[50,0,50,8],[49,0,49,8],[24,4,24,6],[47,0,47,8],[48,0,48,8],[18,0,18,1],[18,2,18,3],[18,4,18,6],[18,7,18,8],[40,0,40,1],[46,0,46,8],[4,0,4,1],[7,0,7,1],[11,4,11,6],[6,4,6,6],[6,2,6,3],[5,7,5,8],[6,7,6,8],[10,0,10,1],[10,2,10,3],[32,0,32,1],[30,4,30,6],[25,4,25,6],[28,4,28,6],[13,0,13,1],[14,4,14,6],[15,4,15,6],[21,0,21,1],[21,2,21,3],[15,0,15,1],[13,2,13,3],[17,0,17,1],[13,4,13,6],[14,0,14,1],[34,7,34,8],[34,0,34,1],[35,2,35,3],[35,7,35,8],[35,4,35,6],[34,4,34,6],[40,2,40,3],[40,4,40,6],[40,7,40,8],[38,7,38,8],[39,0,39,1],[39,2,39,3],[39,4,39,6],[39,7,39,8],[38,0,38,1],[38,2,38,3],[38,4,38,6],[36,2,36,3],[35,0,35,1],[8,7,8,8],[9,7,9,8],[21,4,21,6],[22,4,22,6],[10,7,10,8],[22,7,22,8],[13,7,13,8],[10,4,10,6],[15,7,15,8],[17,7,17,8],[14,7,14,8],[17,4,17,6],[19,7,19,8],[21,7,21,8],[19,4,19,6],[8,4,8,6],[9,4,9,6],[11,7,11,8],[17,2,17,3],[19,2,19,3],[30,0,30,1],[26,2,26,3],[23,2,23,3],[24,2,24,3],[23,7,23,8],[29,7,29,8],[14,2,14,3],[25,7,25,8],[24,7,24,8],[11,0,11,1],[29,4,29,6],[22,2,22,3],[11,2,11,3],[15,2,15,3],[26,4,26,6],[30,7,30,8],[29,0,29,1],[26,0,26,1],[26,7,26,8],[29,2,29,3],[30,2,30,3],[42,7,42,8],[43,2,43,3],[43,4,43,6],[43,7,43,8],[44,4,44,6],[44,7,44,8],[42,0,42,1],[28,2,28,3],[32,7,32,8],[31,7,31,8],[28,7,28,8],[44,0,44,1],[43,0,43,1],[42,2,42,3],[44,2,44,3],[42,4,42,6],[32,2,32,3],[32,4,32,6],[31,4,31,6],[31,2,31,3],[36,7,36,8],[36,0,36,1],[36,4,36,6],[34,2,34,3],[2,0,2,1],[5,0,5,1],[6,0,6,1],[28,0,28,1],[23,0,23,1],[23,4,23,6],[25,2,25,3],[22,0,22,1],[8,2,8,3],[9,2,9,3],[2,2,2,8],[3,2,3,8],[5,2,5,3],[7,2,7,3],[4,4,4,6],[4,7,4,8],[7,4,7,6],[7,7,7,8],[4,2,4,3],[8,0,8,1],[9,0,9,1],[25,0,25,1],[24,0,24,1],[19,0,19,1]]}
[null,null,null,"TABLE 1A:  SITE SUMMARY",null,null,null,"RAI","Non-RAI"]
["Facility Information",null,null,null,null,null,null,"X",null,"Sand",null,"Startup","01 Alachua","PCS01"]
["Facility Name:",null,"DEP BMC",null,null,null,null,null,null,"Silty Sand",null,"Y1Q1","02 Baker","PCS02"]
["Facility Address:",null,"2600 Blairstone Road",null,null,null,null,null,null,"Clayey Sand",null,"Y1Q2","03 Bay","PCS03"]
["Facility City:",null,"Tallahassee",null,"Report Date (mm-dd-yy):",null,null,"2008-01-25",null,"Sandy Clay",null,"Y1Q3","04 Bradford","PCS04"]
["FDEP FAC ID:",null,123456789,null,"Report Period Start date:",null,null,null,null,"Clay",null,"Y1Q4","05 Brevard","PCS05"]
["County:",null,null,null,"Report Period End date:",null,null,null,null,"Limestone",null,"Y2Q1","06 Broward","PCS06"]
["Team/LP: ",null,null,null,"Report Period:",null,null,null,null,"Other",null,"Y2Q2","07 Calhoun","LP01 Alachua"]
["Team/LP PM:",null,null,null,"O&M Inspector:",null,null,null,null,null,null,"Y2Q3","08 Charlotte","LP05 Brevard"]
["Contractor:",null,null,null,"RA Specialist:",null,null,null,null,"Yes",null,"Y2Q4","09 Citrus","LP06 Broward"]
["Contractor PM:",null,null,null,"Program:",null,null,null,null,"No",null,"Y3Q1","10 Clay","LP13 Miami-Dade"]
["Telemetry Phone No.:",null,null,null,"Site Score:",null,null,null,null,null,null,"Y3Q2","11 Collier","LP16 Duval"]
["System Summary",null,null,null,null,null,null,null,null,0.9,null,"Y3Q3","12 Columbia","LP17 Escambia"]
["System Size (S,M,L):",null,null,null,"No. Treatment Points:",null,null,null,null,0.7,null,"Y3Q4","13 Miami-Dade","LP29 Hillsborough"]
["System Type:",null,null,null,null,null,null,null,null,"NAM",null,"Y4Q1","14 DeSoto","LP48 Orange"]
[null,null,null,null,null,null,null,null,null,"CTLs",null,"Y4Q2","15 Dixie","LP50 Palm Beach"]
["Milestone Summary",null,null,null,null,null,null,null,null," ",null,"Y4Q3","16 Duval","LP52 Pinellas"]
["Key Well Count:",null,null,null,"Goal (90%, 70% NAM, CTLs):",null,null,null,null,"AS/SVE",null,"Y4Q4","17 Escambia","LP53 Polk"]
["Key Well ID:",null,null,null,"Key Well Change (yes/no):",null,null,null,null,"AS/MPE",null,"Y5Q1","18 Flagler","LP58 Sarasota"]
["Baseline Sample Date:",null,null,null,"Milestone Change: (yes/no):",null,null,{"$f":"IF(H14=\"\",\"\",H14+H15)","v":""},null,"AS/MPE/SVE",null,"Y5Q2","19 Frankin","LP59 Seminole"]
["Critical Dates",null,null,null,null,null,null,null,null,"BS",null,"Y5Q3","20 Gadsden","LP64 Volusia"]
["RAP Approval Date:",null,null,null,"System Startup Date:",null,null,"2006-02-12",null,"BS/GWR",null,"Y5Q4","21 Gilchrist"]
["RAMP Approval Date:",null,null,null,"Cleanup Time (yrs.):",null,null,2.5,null,"BS/SVE",null,null,"22 Glades"]
["RAC Completion Date:",null,null,null,"Predicted EAR Date:",null,null,{"$f":"IF(H22=\"\",\"\",H22+H23*365)","v":"2008-08-12T12:00:00"},null,"BS/MPE",null,null,"23 Gulf"]
["Discharge Date:",null,null,null,"EAR Date Change (yes/no):",null,null,null,null,"GWR",null,null,"24 Hamilton"]
["Discharge Date:",null,null,null,"Date CTL's Reached:",null,null,null,null,"GWR/SVE",null,null,"25 Hardee"]
["PARM Start Date:",null,null,null,"SRCO Issue Date:",null,null,null,null,"MPE",null,null,"26 Hendry"]
["SA Summary",null,null,null,null,null,null,null,null,"MPE/SVE",null,null,"27 Hernando"]
["Lithology:",null,null,null,"DTW Max.:",null,null,null,null,"Other",null,null,"28 Highlands"]
["Contaminant Groups:",null,null,null,"DTW Min.:",null,null,null,null,null,null,null,"29 Hillsborough"]
["Product Type(s):",null,null,null,"Initial Plume Area (ft2):",null,null,null,null,"S",null,null,"30 Holmes"]
["Highest COC Name:",null,null,null,"Current Plume Area (ft2):",null,null,null,null,"M",null,null,"31 Indian River"]
["Highest COC (ug/l):",null,null,null,"Free Product (yes/no):",null,null,null,null,"L",null,null,"32 Jackson"]
["Remediation History",null,null,null,null,null,null,null,null,null,null,null,"33 Jefferson"]
["Previous System Type:",null,null,null,"Source Removal Date:",null,null,null,null,"LDA",null,null,"34 Lafayette"]
["Date Started:",null,null,null,"Source Removal Tons:",null,null,null,null,"Conventional",null,null,"35 Lake"]
["Date Ended:",null,null,null,"Source Removal Method: ",null,null,null,null,"LDA/Conv.",null,null,"36 Lee"]
["Facility History",null,null,null,null,null,null,null,null,null,null,null,"37 Leon"]
["Active Facility (yes/no)",null,null,null,"Tank Capacity:",null,null,null,null,null,null,null,"38 Levy"]
["Number of Tanks",null,null,null,"Date Installed:",null,null,null,null,null,null,null,"39 Liberty"]
[null,null,null,null,"Date Removed:",null,null,null,null,null,null,null,"40 Madison"]
["Cost Summary",null,null,null,null,null,null,null,null,null,null,null,"41 Manatee"]
["RAC Cost:",null,null,null,"Funding CAP Amount:",null,null,null,null,null,null,null,"42 Marion"]
["Equipment Cost:",null,null,null,"Source Removal Cost:",null,null,null,null,null,null,null,"43 Martin"]
["Annual O&M Cost:",null,null,null,null,null,null,null,null,null,null,null,"44 Monroe"]
["Notes:",null,null,null,null,null,null,null,null,null,null,null,"45 Nassau"]
[null,null,null,null,null,null,null,null,null,null,null,null,"46 Okaloosa"]
[null,null,null,null,null,null,null,null,null,null,null,null,"47 Okeechobee"]
[null,null,null,null,null,null,null,null,null,null,null,null,"48 Orange"]
[null,null,null,null,null,null,null,null,null,null,null,null,"49 Osceola"]
[null,null,null,null,null,null,null,null,null,null,null,null,"50 Palm Beach"]
[null,null,null,null,null,null,null,null,null,null,null,null,"51 Pasco"]
[null,null,null,null,null,null,null,null,null,null,null,null,"52 Pinellas"]
[null,null,null,null,null,null,null,null,null,null,null,null,"53 Polk"]
[null,null,null,null,null,null,null,null,null,null,null,null,"54 Putnam"]
[null,null,null,null,null,null,null,null,null,null,null,null,"55 St. Johns"]
[null,null,null,null,null,null,null,null,null,null,null,null,"56 St. Lucie"]
[null,null,null,null,null,null,null,null,null,null,null,null,"57 Santa Rosa"]
[null,null,null,null,null,null,null,null,null,null,null,null,"58 Sarasota"]
[null,null,null,null,null,null,null,null,null,null,null,null,"59 Seminole"]
[null,null,null,null,null,null,null,null,null,null,null,null,"60 Sumter"]
[null,null,null,null,null,null,null,null,null,null,null,null,"61 Suwannee"]
[null,null,null,null,null,null,null,null,null,null,null,null,"62 Taylor"]
[null,null,null,null,null,null,null,null,null,null,null,null,"63 Union"]
[null,null,null,null,null,null,null,null,null,null,null,null,"64 Volusia"]
[null,null,null,null,null,null,null,null,null,null,null,null,"65 Wakulla"]
[null,null,null,null,null,null,null,null,null,null,null,null,"66 Walton"]
[null,null,null,null,null,null,null,null,null,null,null,null,"67 Washington"]

{"sheet":"T1B - Site Performance Summary","index":2,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,11,2,13],[3,11,3,13],[3,2,3,8],[2,2,2,8],[4,2,4,8]]}
[null,null,null,"TABLE 1B: SITE PERFORMANCE SUMMARY"]
[]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,null,"Startup Date:",null,{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"}]
["Facility Address:",null,{"$f":"CONCATENATE('T1A - Site Summary'!C4,\", \",'T1A - Site Summary'!C5)","v":"2600 Blairstone Road, Tallahassee"},null,null,null,null,null,null,"System Type:",null,{"$f":"'T1A - Site Summary'!C15","v":0}]
["FDEP FAC ID:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789}]
[]
["Key Wells Meeting All Milestones (yes/no)"]
[null,"Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10","Q11","Q12","Q13","Q14","Q15","Q16"]
["MW-1"]
["MW-2"]
["MW-3"]
["MW-4"]
["MW-5"]
["MW-6"]
["MW-7"]
["MW-8"]
["MW-9"]
["MW-10"]
[]
["Run Time Summary (%)"]
["Report Period","Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10","Q11","Q12","Q13","Q14","Q15","Q16"]
["AS"]
["SVE"]
["MPX"]
["BS"]
[]
[]
[]
["Cumulative"]
["AS"]
["SVE"]
["MPX"]
["BS"]

{"sheet":"T1C - Treatment Well Details","index":3,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[null,"TABLE 1C - TREATMENT WELL DETAILS"]
["Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,"FDEP FAC ID:",{"$f":"'T1A - Site Summary'!C6","v":123456789}]
["Facility Address:",{"$f":"CONCATENATE('T1A - Site Summary'!C4,\", \",'T1A - Site Summary'!C5)","v":"2600 Blairstone Road, Tallahassee"},null,"System Type:",{"$f":"'T1A - Site Summary'!C15","v":0}]
[]
["Process Type","AS","SVE","AS","GWR"]
["Well Count",10,15,10]
["Well Name"]
["Well Type (HW, VW)","HW","VW","VW"]
["Diameter (inches)",4,4,2]
["Well Depth (feet)",40,20,30]
["Screened Length (feet) ",100,2,2]
["Design Flow (gpm)",50,50,5]
["Design Flow (scfm)"]
["Startup (Optimal) Flow (gpm)",35,50,5]
["Startup (Optimal) Flow (scfm) "]
["Design Pressure (psi)",null,15,12]
["Startup (Optimal) Pressure (psi)",12,12,10]
["Design Vacuum (in. H2O)",15,null,{"$f":"-D19","v":0}]
["Startup (Optimal) Vacuum (in. H2O)"]
["Design Vacuum (in. Hg)",15]
["Startup (Optimal) Vacuum (in. Hg)"]
["Slot Size (inches)",0.01,null,0.02]
["Well Material (HDPE, PVC)","hdpe","PVC","PVC"]
["Installation Method (DP, HS, MR, DD, other)",null,null,"HA"]
[]
["Process Type","MPX"]
["Well Count",10]
["Well Name"]
["Well Type (HW, VW)","HW"]
["Diameter (inches)",4]
["Well Depth (feet)",40]
["Screened Length (feet) ",100]
["Design Flow Rate (gpm)",50]
["Design Flow Rate (scfm)"]
["Startup (Optimal) Flow (gpm)",35]
["Startup (Optimal) Flow (scfm)"]
["Design Pressure (psi)"]
["Startup (Optimal) Pressure (psi)",12]
["Design Vacuum (in. H2O)",15]
["Startup (Optimal) Vacuum (in. H2O)"]
["Design Vacuum (in. Hg)",15]
["Startup (Optimal) Vacuum (in. Hg)"]
["Slot Size (inches)",0.01]
["Well Material (HDPE, PVC)","hdpe"]
["Installation Method (DP, HS, MR, DD, other)"]

{"sheet":"T1D - Process Summary","index":4,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":false,"merged":[[29,2,29,3],[29,5,29,6],[31,2,31,3],[27,7,27,8],[31,7,31,8],[29,7,29,8],[4,5,4,6],[8,5,8,6],[6,5,6,6],[9,5,9,6],[14,2,14,3],[14,5,14,6],[11,5,11,6],[9,2,9,3],[13,2,13,3],[13,5,13,6],[8,2,8,3],[11,2,11,3],[10,5,10,6],[45,0,45,1],[45,2,45,3],[36,0,36,1],[36,2,36,3],[36,5,36,6],[37,2,37,3],[37,5,37,6],[40,2,40,3],[40,5,40,6],[37,0,37,1],[38,2,38,3],[38,5,38,6],[61,0,61,1],[61,2,61,3],[61,5,61,6],[62,0,62,1],[63,0,63,1],[55,0,55,1],[60,5,60,6],[60,2,60,3],[53,0,53,1],[53,2,53,3],[53,5,53,6],[58,2,58,3],[58,5,58,6],[59,0,59,1],[59,2,59,3],[59,5,59,6],[54,0,54,1],[54,2,54,3],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[9,7,9,8],[10,7,10,8],[64,2,64,3],[64,5,64,6],[1,2,1,3],[2,2,2,3],[1,7,1,8],[2,7,2,8],[64,7,64,8],[62,2,62,3],[62,5,62,6],[63,2,63,3],[55,5,55,6],[63,5,63,6],[44,2,44,3],[44,5,44,6],[52,2,52,3],[52,5,52,6],[47,2,47,3],[47,5,47,6],[61,7,61,8],[62,7,62,8],[63,7,63,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[58,7,58,8],[50,7,50,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[44,7,44,8],[45,7,45,8],[49,7,49,8],[46,7,46,8],[33,7,33,8],[34,7,34,8],[36,7,36,8],[41,7,41,8],[32,7,32,8],[59,7,59,8],[10,2,10,3],[10,0,10,1],[8,7,8,8],[5,5,5,6],[8,0,8,1],[18,7,18,8],[17,7,17,8],[15,0,15,1],[40,7,40,8],[37,7,37,8],[42,7,42,8],[11,7,11,8],[44,0,44,1],[52,0,52,1],[46,0,46,1],[45,5,45,6],[46,2,46,3],[46,5,46,6],[49,2,49,3],[49,5,49,6],[50,5,50,6],[50,0,50,1],[50,2,50,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[7,5,7,6],[19,0,19,1],[13,0,13,1],[18,0,18,1],[18,2,18,3],[18,5,18,6],[7,0,7,1],[14,0,14,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[9,0,9,1],[15,2,15,3],[15,5,15,6],[23,5,23,6],[23,7,23,8],[20,7,20,8],[19,2,19,3],[19,5,19,6],[19,7,19,8],[20,2,20,3],[20,5,20,6],[16,0,16,1],[16,2,16,3],[16,5,16,6],[16,7,16,8],[17,0,17,1],[17,2,17,3],[17,5,17,6],[24,0,24,1],[24,2,24,3],[24,7,24,8],[22,2,22,3],[22,5,22,6],[22,7,22,8],[23,0,23,1],[23,2,23,3],[22,0,22,1],[26,0,26,1],[28,0,28,1],[28,2,28,3],[28,5,28,6],[26,2,26,3],[26,5,26,6],[24,5,24,6],[26,7,26,8],[25,2,25,3],[25,5,25,6],[25,7,25,8],[25,0,25,1],[27,0,27,1],[27,2,27,3],[27,5,27,6],[43,5,43,6],[43,7,43,8],[41,5,41,6],[42,0,42,1],[42,2,42,3],[42,5,42,6],[28,7,28,8],[31,0,31,1],[35,0,35,1],[35,2,35,3],[35,5,35,6],[35,7,35,8],[31,5,31,6],[32,0,32,1],[32,2,32,3],[32,5,32,6],[41,0,41,1],[41,2,41,3],[33,0,33,1],[33,2,33,3],[33,5,33,6],[34,0,34,1],[34,2,34,3],[34,5,34,6],[2,5,2,6],[64,0,64,1],[65,2,65,3],[65,5,65,6],[65,7,65,8],[56,2,56,3],[56,5,56,6],[56,7,56,8],[58,0,58,1],[60,0,60,1],[60,7,60,8],[47,7,47,8],[49,0,49,1],[51,0,51,1],[51,2,51,3],[51,5,51,6],[51,7,51,8],[54,5,54,6],[55,2,55,3],[55,7,55,8],[38,7,38,8],[40,0,40,1],[43,0,43,1],[43,2,43,3]]}
[null,null,null,"TABLE 1D:  REMEDIAL PROCESS SUMMARY"]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,"FDEP FAC ID:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789}]
["Facility Address:",null,{"$f":"CONCATENATE('T1A - Site Summary'!C4,\", \",'T1A - Site Summary'!C5)","v":"2600 Blairstone Road, Tallahassee"},null,null,"System Type:",null,{"$f":"'T1A - Site Summary'!C15","v":0}]
[]
["Treatment Process 1:",null,"AS",null,null,"Serial Number:"]
["Equipment Type:",null,"rotary screw AC",null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 2:",null,"SVE",null,null,"Serial Number:"]
["Equipment Type:",null,"PD Bower",null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 3:",null,null,null,null,"Serial Number:"]
["Equipment Type:",null,null,null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 4:",null,null,null,null,"Serial Number:"]
["Equipment Type:",null,null,null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 5:",null,null,null,null,"Serial Number:"]
["Equipment Type:",null,null,null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 6:",null,null,null,null,"Serial Number:"]
["Equipment Type:",null,null,null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]
[]
["Treatment Process 7:",null,null,null,null,"Serial Number:"]
["Equipment Type:",null,null,null,null,"Property #"]
["Manufacturer:",null,null,null,null,"Enclosure Type:"]
["Model #",null,null,null,null,"Trailer Tag No."]
["Equipment HP:",null,null,null,null,"Process Flow (SCFM):"]
["Phase/Voltage:",null,null,null,null,"Process Pressure (psi):"]
["Warranty Exp. Date:",null,null,null,null,"Process Vacuum (in.H2O): "]
[null,null,null,null,null,"Process Vacuum (in.Hg): "]

{"sheet":"T1E - Maintenance Summary","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[15,2,15,6],[16,2,16,6],[7,2,7,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[8,2,8,6],[9,2,9,6],[30,2,30,6],[23,2,23,6],[24,2,24,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[31,2,31,6],[32,2,32,6],[33,2,33,6]]}
[]
["TABLE 1E:  REMEDIAL SYSTEM MAINTENANCE  SUMMARY"]
[]
["Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,"Report Date:",{"$f":"'T1A - Site Summary'!H5","v":"2008-01-25"}]
["Facility Address:",{"$f":"CONCATENATE('T1A - Site Summary'!C4,\", \",'T1A - Site Summary'!C5)","v":"2600 Blairstone Road, Tallahassee"},null,"Report Type:",{"$f":"'T1A - Site Summary'!H8","v":0}]
["FDEP#",{"$f":"'T1A - Site Summary'!C6","v":123456789},null,"Startup Date:",{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"}]
[]
["Date:","Type:","System Maintenance Description"]

{"sheet":"T2 - GWR Performance","index":6,"n_rows":65,"n_cols":16,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,7,3,8]]}
[]
["TABLE 2:  GROUND WATER RECOVERY SYSTEM PERFORMANCE SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,"Treatment Process Status Codes:",null,"Code","Arrive","Depart"]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,"Startup Date:",{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"},null,null,null,null,null,1,"on","on"]
["Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,null,null,null,null,2,"off","on"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3,"off","off"]
[null,"Design Flow:",5,"gpm",null,null,null,null,null,null,null,null,null,4,"on","off"]
[null,null,null,null,null,null,"Design Capacity Percentage = (Total Gallons Pumped/Design Flow)*(days/1440)"]
["Site Visit","Days Between","Days Since","Gallons","Instantaneous","Average","Total Gallons","Design Capacity","Design Capacity","Hour Meter","Daily operating design","% Runtime","% Runtime","Free Product",null,"Process "]
["Date","Site Visits","Startup","Pumped","Flow - GPM","GPM","Pumped","% (period)","% (total)","Reading","Runtime (hours)","(period)","(total)","Gals ","Total","Status"]
["2006-03-04",{"$f":"A11-A11","v":0},{"$f":"(A11-A$11)","v":0},null,null,0,{"$f":"D11","v":0},0,0,null,null,0,0,null,{"$f":"N11","v":0}]
["2006-03-06",{"$f":"IF(A12=\"\",\"\",(A12-A11))","v":2},{"$f":"IF(A12=\"\",\"\",(A12-A$11))","v":2},100,5,{"$f":"IF(A12=\"\",\"\",(D12/(1440*B12)))","v":3.4722222222222224E-2},{"$f":"IF($A12=\"\",\"\",SUM(G11+D12))","v":100},{"$f":"IF($A12=\"\",\"\",(D12/$C$7)/(B12*1440))","v":6.9444444444444441E-3},{"$f":"IF(A12=\"\",\"\",(G12/$C$7)/(C12*1440))","v":6.9444444444444441E-3},50,24,{"$f":"IF($A12=\"\",\"\",(J12-J11)/(B12*K12))","v":1.0416666666666667},{"$f":"IF($A12=\"\",\"\",(J12-$J$11)/(SUMPRODUCT($B$11:B12*$K$11:K12)))","v":1.0416666666666667},5,{"$f":"IF(A12=\"\",\"\",SUM(O11+N12))","v":5}]
["2006-03-08",{"$f":"IF(A13=\"\",\"\",(A13-A12))","v":2},{"$f":"IF(A13=\"\",\"\",(A13-A$11))","v":4},100,5,{"$f":"IF(A13=\"\",\"\",(D13/(1440*B13)))","v":3.4722222222222224E-2},{"$f":"IF($A13=\"\",\"\",SUM(G12+D13))","v":200},{"$f":"IF($A13=\"\",\"\",(D13/$C$7)/(B13*1440))","v":6.9444444444444441E-3},{"$f":"IF(A13=\"\",\"\",(G13/$C$7)/(C13*1440))","v":6.9444444444444441E-3},75,24,{"$f":"IF($A13=\"\",\"\",(J13-J12)/(B13*K13))","v":0.52083333333333337},{"$f":"IF($A13=\"\",\"\",(J13-$J$11)/(SUMPRODUCT($B$11:B13*$K$11:K13)))","v":0.78125},null,{"$f":"IF(A13=\"\",\"\",SUM(O12+N13))","v":5}]
["2006-03-10",{"$f":"IF(A14=\"\",\"\",(A14-A13))","v":2},{"$f":"IF(A14=\"\",\"\",(A14-A$11))","v":6},100,5,3.4722222222222224E-2,300,6.9444444444444441E-3,{"$f":"IF(A14=\"\",\"\",(G14/$C$7)/(C14*1440))","v":6.9444444444444441E-3},100,24,{"$f":"IF($A14=\"\",\"\",(J14-J13)/(B14*K14))","v":0.52083333333333337},{"$f":"IF($A14=\"\",\"\",(J14-$J$11)/(SUMPRODUCT($B$11:B14*$K$11:K14)))","v":0.69444444444444442},null,{"$f":"IF(A14=\"\",\"\",SUM(O13+N14))","v":5}]
[null,{"$f":"IF(A15=\"\",\"\",(A15-A14))","v":""},{"$f":"IF(A15=\"\",\"\",(A15-A$11))","v":""},null,null,"","","",{"$f":"IF(A15=\"\",\"\",(G15/$C$7)/(C15*1440))","v":""},null,null,{"$f":"IF($A15=\"\",\"\",(J15-J14)/(B15*K15))","v":""},{"$f":"IF($A15=\"\",\"\",(J15-$J$11)/(SUMPRODUCT($B$11:B15*$K$11:K15)))","v":""},null,{"$f":"IF(A15=\"\",\"\",SUM(O14+N15))","v":""}]
[null,{"$f":"IF(A16=\"\",\"\",(A16-A15))","v":""},{"$f":"IF(A16=\"\",\"\",(A16-A$11))","v":""},null,null,"","","",{"$f":"IF(A16=\"\",\"\",(G16/$C$7)/(C16*1440))","v":""},null,null,{"$f":"IF($A16=\"\",\"\",(J16-J15)/(B16*K16))","v":""},{"$f":"IF($A16=\"\",\"\",(J16-$J$11)/(SUMPRODUCT($B$11:B16*$K$11:K16)))","v":""},null,{"$f":"IF(A16=\"\",\"\",SUM(O15+N16))","v":""}]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A17=\"\",\"\",(J17-$J$11)/(SUMPRODUCT($B$11:B17*$K$11:K17)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A18=\"\",\"\",(J18-$J$11)/(SUMPRODUCT($B$11:B18*$K$11:K18)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A19=\"\",\"\",(J19-$J$11)/(SUMPRODUCT($B$11:B19*$K$11:K19)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A20=\"\",\"\",(J20-$J$11)/(SUMPRODUCT($B$11:B20*$K$11:K20)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A21=\"\",\"\",(J21-$J$11)/(SUMPRODUCT($B$11:B21*$K$11:K21)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A22=\"\",\"\",(J22-$J$11)/(SUMPRODUCT($B$11:B22*$K$11:K22)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A23=\"\",\"\",(J23-$J$11)/(SUMPRODUCT($B$11:B23*$K$11:K23)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A24=\"\",\"\",(J24-$J$11)/(SUMPRODUCT($B$11:B24*$K$11:K24)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A25=\"\",\"\",(J25-$J$11)/(SUMPRODUCT($B$11:B25*$K$11:K25)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A26=\"\",\"\",(J26-$J$11)/(SUMPRODUCT($B$11:B26*$K$11:K26)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A27=\"\",\"\",(J27-$J$11)/(SUMPRODUCT($B$11:B27*$K$11:K27)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A28=\"\",\"\",(J28-$J$11)/(SUMPRODUCT($B$11:B28*$K$11:K28)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A29=\"\",\"\",(J29-$J$11)/(SUMPRODUCT($B$11:B29*$K$11:K29)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A30=\"\",\"\",(J30-$J$11)/(SUMPRODUCT($B$11:B30*$K$11:K30)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A31=\"\",\"\",(J31-$J$11)/(SUMPRODUCT($B$11:B31*$K$11:K31)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A32=\"\",\"\",(J32-$J$11)/(SUMPRODUCT($B$11:B32*$K$11:K32)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A33=\"\",\"\",(J33-$J$11)/(SUMPRODUCT($B$11:B33*$K$11:K33)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A34=\"\",\"\",(J34-$J$11)/(SUMPRODUCT($B$11:B34*$K$11:K34)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A35=\"\",\"\",(J35-$J$11)/(SUMPRODUCT($B$11:B35*$K$11:K35)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A36=\"\",\"\",(J36-$J$11)/(SUMPRODUCT($B$11:B36*$K$11:K36)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A37=\"\",\"\",(J37-$J$11)/(SUMPRODUCT($B$11:B37*$K$11:K37)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A38=\"\",\"\",(J38-$J$11)/(SUMPRODUCT($B$11:B38*$K$11:K38)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A39=\"\",\"\",(J39-$J$11)/(SUMPRODUCT($B$11:B39*$K$11:K39)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A40=\"\",\"\",(J40-$J$11)/(SUMPRODUCT($B$11:B40*$K$11:K40)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A41=\"\",\"\",(J41-$J$11)/(SUMPRODUCT($B$11:B41*$K$11:K41)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A42=\"\",\"\",(J42-$J$11)/(SUMPRODUCT($B$11:B42*$K$11:K42)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A43=\"\",\"\",(J43-$J$11)/(SUMPRODUCT($B$11:B43*$K$11:K43)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A44=\"\",\"\",(J44-$J$11)/(SUMPRODUCT($B$11:B44*$K$11:K44)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A45=\"\",\"\",(J45-$J$11)/(SUMPRODUCT($B$11:B45*$K$11:K45)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A46=\"\",\"\",(J46-$J$11)/(SUMPRODUCT($B$11:B46*$K$11:K46)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A47=\"\",\"\",(J47-$J$11)/(SUMPRODUCT($B$11:B47*$K$11:K47)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A48=\"\",\"\",(J48-$J$11)/(SUMPRODUCT($B$11:B48*$K$11:K48)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A49=\"\",\"\",(J49-$J$11)/(SUMPRODUCT($B$11:B49*$K$11:K49)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A50=\"\",\"\",(J50-$J$11)/(SUMPRODUCT($B$11:B50*$K$11:K50)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A51=\"\",\"\",(J51-$J$11)/(SUMPRODUCT($B$11:B51*$K$11:K51)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A52=\"\",\"\",(J52-$J$11)/(SUMPRODUCT($B$11:B52*$K$11:K52)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A53=\"\",\"\",(J53-$J$11)/(SUMPRODUCT($B$11:B53*$K$11:K53)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A54=\"\",\"\",(J54-$J$11)/(SUMPRODUCT($B$11:B54*$K$11:K54)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A55=\"\",\"\",(J55-$J$11)/(SUMPRODUCT($B$11:B55*$K$11:K55)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A56=\"\",\"\",(J56-$J$11)/(SUMPRODUCT($B$11:B56*$K$11:K56)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A57=\"\",\"\",(J57-$J$11)/(SUMPRODUCT($B$11:B57*$K$11:K57)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A58=\"\",\"\",(J58-$J$11)/(SUMPRODUCT($B$11:B58*$K$11:K58)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A59=\"\",\"\",(J59-$J$11)/(SUMPRODUCT($B$11:B59*$K$11:K59)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A60=\"\",\"\",(J60-$J$11)/(SUMPRODUCT($B$11:B60*$K$11:K60)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A61=\"\",\"\",(J61-$J$11)/(SUMPRODUCT($B$11:B61*$K$11:K61)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A62=\"\",\"\",(J62-$J$11)/(SUMPRODUCT($B$11:B62*$K$11:K62)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A63=\"\",\"\",(J63-$J$11)/(SUMPRODUCT($B$11:B63*$K$11:K63)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A64=\"\",\"\",(J64-$J$11)/(SUMPRODUCT($B$11:B64*$K$11:K64)))","v":""},null,""]
[null,"","",null,null,"","","","",null,null,"",{"$f":"IF($A65=\"\",\"\",(J65-$J$11)/(SUMPRODUCT($B$11:B65*$K$11:K65)))","v":""},null,""]

{"sheet":"T3A - AS Performance","index":7,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,14],[4,2,4,7],[3,2,3,7],[10,14,11,14],[8,3,8,4],[8,5,8,6],[8,7,8,8]]}
[]
["TABLE 3A:  AIR SPARGING PERFORMANCE SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Code","Arrive","Depart"]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,"Startup Date:",null,{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"},null,1,"on","on"]
["Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,null,null,null,2,"off","on"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"off","off"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"on","off"]
[]
[null,null,null,"AS Compressor 1",null,"AS Compressor 2",null,"AS Compressor 3"]
["Site ","Days","Days","Hour","Daily","Hour","Daily","Hour","Daily","Hours of","Total Hours","Approved ","Percent","Percent","Process"]
["Visit","Between","Since","Meter","Designed Run","Meter","Designed Run","Meter","Designed Run","Operation","of Operation","Down Time","Run Time","Run Time","Status"]
["Date","Site Visits","Startup","Reading","Time (hours)","Reading","Time (hours)","Reading","Time (hours)","Period","Cumulative","(hours)","(period)","(cumulative)"]
["2008-01-01",{"$f":"(A13-A13)","v":0},{"$f":"IF(A13=\"\",\"\",(A13-A$13))","v":0},100,12,100,12,null,null,null,{"$f":"(H13-H$13)","v":0},null,0,0,0]
["2008-01-02",{"$f":"IF(A14=\"\",\"\",(A14-A13))","v":1},1,112,12,112,12,null,null,{"$f":"IF(A14=\"\",\"\",(((D14-D13)+(F14-F13)+(H14-H13))/((E14+G14+I14)/24)))","v":24},{"$f":"IF($A14=\"\",\"\",(J14-J$13)+K13)","v":24},null,{"$f":"IF(A14=\"\",\"\",(J14+SUMIF(L14,\">0\"))/B14/24)","v":1},{"$f":"IF($A14=\"\",\"\",(K14+SUMIF($L$13:L14,\">0\"))/C14/24)","v":1}]
["2008-01-03",1,2,123,12,123,12,null,null,22,{"$f":"IF($A15=\"\",\"\",(J15-J$13)+K14)","v":46},1,0.95833333333333337,{"$f":"IF($A15=\"\",\"\",(K15+SUMIF($L$13:L15,\">0\"))/C15/24)","v":0.97916666666666663}]
[null,"","",null,null,null,null,null,null,"",{"$f":"IF($A16=\"\",\"\",(J16-J$13)+K15)","v":""},null,"",{"$f":"IF($A16=\"\",\"\",(K16+SUMIF($L$13:L16,\">0\"))/C16/24)","v":""}]
[null,"","",null,null,null,null,null,null,"",{"$f":"IF($A17=\"\",\"\",(J17-J$13)+K16)","v":""},null,"",{"$f":"IF($A17=\"\",\"\",(K17+SUMIF($L$13:L17,\">0\"))/C17/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A18=\"\",\"\",(K18+SUMIF($L$13:L18,\">0\"))/C18/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A19=\"\",\"\",(K19+SUMIF($L$13:L19,\">0\"))/C19/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A20=\"\",\"\",(K20+SUMIF($L$13:L20,\">0\"))/C20/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A21=\"\",\"\",(K21+SUMIF($L$13:L21,\">0\"))/C21/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A22=\"\",\"\",(K22+SUMIF($L$13:L22,\">0\"))/C22/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A23=\"\",\"\",(K23+SUMIF($L$13:L23,\">0\"))/C23/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A24=\"\",\"\",(K24+SUMIF($L$13:L24,\">0\"))/C24/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A25=\"\",\"\",(K25+SUMIF($L$13:L25,\">0\"))/C25/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A26=\"\",\"\",(K26+SUMIF($L$13:L26,\">0\"))/C26/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A27=\"\",\"\",(K27+SUMIF($L$13:L27,\">0\"))/C27/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A28=\"\",\"\",(K28+SUMIF($L$13:L28,\">0\"))/C28/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A29=\"\",\"\",(K29+SUMIF($L$13:L29,\">0\"))/C29/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A30=\"\",\"\",(K30+SUMIF($L$13:L30,\">0\"))/C30/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A31=\"\",\"\",(K31+SUMIF($L$13:L31,\">0\"))/C31/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A32=\"\",\"\",(K32+SUMIF($L$13:L32,\">0\"))/C32/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A33=\"\",\"\",(K33+SUMIF($L$13:L33,\">0\"))/C33/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A34=\"\",\"\",(K34+SUMIF($L$13:L34,\">0\"))/C34/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A35=\"\",\"\",(K35+SUMIF($L$13:L35,\">0\"))/C35/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A36=\"\",\"\",(K36+SUMIF($L$13:L36,\">0\"))/C36/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A37=\"\",\"\",(K37+SUMIF($L$13:L37,\">0\"))/C37/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A38=\"\",\"\",(K38+SUMIF($L$13:L38,\">0\"))/C38/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A39=\"\",\"\",(K39+SUMIF($L$13:L39,\">0\"))/C39/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A40=\"\",\"\",(K40+SUMIF($L$13:L40,\">0\"))/C40/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A41=\"\",\"\",(K41+SUMIF($L$13:L41,\">0\"))/C41/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A42=\"\",\"\",(K42+SUMIF($L$13:L42,\">0\"))/C42/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A43=\"\",\"\",(K43+SUMIF($L$13:L43,\">0\"))/C43/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A44=\"\",\"\",(K44+SUMIF($L$13:L44,\">0\"))/C44/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A45=\"\",\"\",(K45+SUMIF($L$13:L45,\">0\"))/C45/24)","v":""}]
[null,{"$f":"IF(A46=\"\",\"\",(A46-A43))","v":""},"",null,null,null,null,null,null,{"$f":"IF(A46=\"\",\"\",(((D46-D43)+(F46-F43)+(H46-H43))/((E46+G46+I46)/24)))","v":""},"",null,"",{"$f":"IF($A46=\"\",\"\",(K46+SUMIF($L$13:L46,\">0\"))/C46/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A47=\"\",\"\",(K47+SUMIF($L$13:L47,\">0\"))/C47/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A48=\"\",\"\",(K48+SUMIF($L$13:L48,\">0\"))/C48/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A49=\"\",\"\",(K49+SUMIF($L$13:L49,\">0\"))/C49/24)","v":""}]

{"sheet":"T3B - SVE Performance","index":8,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,14,11,14],[1,0,1,14],[3,2,3,7],[4,2,4,7],[8,3,8,4],[8,5,8,6],[8,7,8,8]]}
[]
["TABLE 3B:  SOIL VAPOR EXTRACTION PERFORMANCE SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Code","Arrive","Depart"]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,"Startup Date:",null,{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"},null,1,"on","on"]
["Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,null,null,null,2,"off","on"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"off","off"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"on","off"]
[]
[null,null,null,"SVE Blower 1",null,"SVE Blower 2",null,"SVE Blower 3"]
["Site ","Days","Days","Hour","Daily","Hour","Daily","Hour","Daily","Hours of","Total Hours","Approved ","Percent","Percent","Process"]
["Visit","Between","Since","Meter","Designed Run","Meter","Designed Run","Meter","Designed Run","Operation","of Operation","Down Time","Run Time","Run Time","Status"]
["Date","Site Visits","Startup","Reading","Time (hours)","Reading","Time (hours)","Reading","Time (hours)","Period","Cumulative","(hours)","(period)","(cumulative)"]
[null,{"$f":"(A13-A13)","v":0},{"$f":"(A13-A$13)","v":0},null,null,null,null,null,null,null,{"$f":"(H13-H$13)","v":0},null,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A14=\"\",\"\",(((D14-D13)+(F14-F13)+(H14-H13))/((E14+G14+I14)/24)))","v":""},{"$f":"IF($A14=\"\",\"\",(J14-J$13)+K13)","v":""},null,{"$f":"IF(A14=\"\",\"\",(J14+SUMIF(L14,\">0\"))/B14/24)","v":""},{"$f":"IF($A14=\"\",\"\",(K14+SUMIF($L$13:L14,\">0\"))/C14/24)","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",(A15-A14))","v":""},{"$f":"IF(A15=\"\",\"\",(A15-A$13))","v":""},null,null,null,null,null,null,"",{"$f":"IF($A15=\"\",\"\",(J15-J$13)+K14)","v":""},null,"",{"$f":"IF($A15=\"\",\"\",(K15+SUMIF($L$13:L15,\">0\"))/C15/24)","v":""}]
[null,"",{"$f":"IF(A16=\"\",\"\",(A16-A$13))","v":""},null,null,null,null,null,null,"",{"$f":"IF($A16=\"\",\"\",(J16-J$13)+K15)","v":""},null,"",{"$f":"IF($A16=\"\",\"\",(K16+SUMIF($L$13:L16,\">0\"))/C16/24)","v":""}]
[null,"","",null,null,null,null,null,null,"",{"$f":"IF($A17=\"\",\"\",(J17-J$13)+K16)","v":""},null,"",{"$f":"IF($A17=\"\",\"\",(K17+SUMIF($L$13:L17,\">0\"))/C17/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A18=\"\",\"\",(K18+SUMIF($L$13:L18,\">0\"))/C18/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A19=\"\",\"\",(K19+SUMIF($L$13:L19,\">0\"))/C19/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A20=\"\",\"\",(K20+SUMIF($L$13:L20,\">0\"))/C20/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A21=\"\",\"\",(K21+SUMIF($L$13:L21,\">0\"))/C21/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A22=\"\",\"\",(K22+SUMIF($L$13:L22,\">0\"))/C22/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A23=\"\",\"\",(K23+SUMIF($L$13:L23,\">0\"))/C23/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A24=\"\",\"\",(K24+SUMIF($L$13:L24,\">0\"))/C24/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A25=\"\",\"\",(K25+SUMIF($L$13:L25,\">0\"))/C25/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A26=\"\",\"\",(K26+SUMIF($L$13:L26,\">0\"))/C26/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A27=\"\",\"\",(K27+SUMIF($L$13:L27,\">0\"))/C27/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A28=\"\",\"\",(K28+SUMIF($L$13:L28,\">0\"))/C28/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A29=\"\",\"\",(K29+SUMIF($L$13:L29,\">0\"))/C29/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A30=\"\",\"\",(K30+SUMIF($L$13:L30,\">0\"))/C30/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A31=\"\",\"\",(K31+SUMIF($L$13:L31,\">0\"))/C31/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A32=\"\",\"\",(K32+SUMIF($L$13:L32,\">0\"))/C32/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A33=\"\",\"\",(K33+SUMIF($L$13:L33,\">0\"))/C33/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A34=\"\",\"\",(K34+SUMIF($L$13:L34,\">0\"))/C34/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A35=\"\",\"\",(K35+SUMIF($L$13:L35,\">0\"))/C35/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A36=\"\",\"\",(K36+SUMIF($L$13:L36,\">0\"))/C36/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A37=\"\",\"\",(K37+SUMIF($L$13:L37,\">0\"))/C37/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A38=\"\",\"\",(K38+SUMIF($L$13:L38,\">0\"))/C38/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A39=\"\",\"\",(K39+SUMIF($L$13:L39,\">0\"))/C39/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A40=\"\",\"\",(K40+SUMIF($L$13:L40,\">0\"))/C40/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A41=\"\",\"\",(K41+SUMIF($L$13:L41,\">0\"))/C41/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A42=\"\",\"\",(K42+SUMIF($L$13:L42,\">0\"))/C42/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A43=\"\",\"\",(K43+SUMIF($L$13:L43,\">0\"))/C43/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A44=\"\",\"\",(K44+SUMIF($L$13:L44,\">0\"))/C44/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A45=\"\",\"\",(K45+SUMIF($L$13:L45,\">0\"))/C45/24)","v":""}]
[null,{"$f":"IF(A46=\"\",\"\",(A46-A43))","v":""},"",null,null,null,null,null,null,{"$f":"IF(A46=\"\",\"\",(((D46-D43)+(F46-F43)+(H46-H43))/((E46+G46+I46)/24)))","v":""},"",null,"",{"$f":"IF($A46=\"\",\"\",(K46+SUMIF($L$13:L46,\">0\"))/C46/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A47=\"\",\"\",(K47+SUMIF($L$13:L47,\">0\"))/C47/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A48=\"\",\"\",(K48+SUMIF($L$13:L48,\">0\"))/C48/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A49=\"\",\"\",(K49+SUMIF($L$13:L49,\">0\"))/C49/24)","v":""}]

{"sheet":"T3C - MPX Performance","index":9,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,14,11,14],[1,0,1,14],[3,2,3,7],[4,2,4,7],[8,3,8,4],[8,5,8,6],[8,7,8,8]]}
[]
["TABLE 3C:  MULTIPHASE EXTRACTION PERFORMANCE SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Code","Arrive","Depart"]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,"Startup Date:",null,{"$f":"'T1A - Site Summary'!H22","v":"2006-02-12"},null,1,"on","on"]
["Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,null,null,null,2,"off","on"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"off","off"]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"on","off"]
[]
[null,null,null,"MPX Pump 1",null,"MPX Pump 2",null,"MPX Pump 3"]
["Site ","Days","Days","Hour","Daily","Hour","Daily","Hour","Daily","Hours of","Total Hours","Approved ","Percent","Percent","Process"]
["Visit","Between","Since","Meter","Designed Run","Meter","Designed Run","Meter","Designed Run","Operation","of Operation","Down Time","Run Time","Run Time","Status"]
["Date","Site Visits","Startup","Reading","Time (hours)","Reading","Time (hours)","Reading","Time (hours)","Period","Cumulative","(hours)","(period)","(cumulative)"]
[null,{"$f":"(A13-A13)","v":0},{"$f":"(A13-A$13)","v":0},null,null,null,null,null,null,null,{"$f":"(H13-H$13)","v":0},null,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A14=\"\",\"\",(((D14-D13)+(F14-F13)+(H14-H13))/((E14+G14+I14)/24)))","v":""},{"$f":"IF($A14=\"\",\"\",(J14-J$13)+K13)","v":""},null,{"$f":"IF(A14=\"\",\"\",(J14+SUMIF(L14,\">0\"))/B14/24)","v":""},{"$f":"IF($A14=\"\",\"\",(K14+SUMIF($L$13:L14,\">0\"))/C14/24)","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",(A15-A14))","v":""},{"$f":"IF(A15=\"\",\"\",(A15-A$13))","v":""},null,null,null,null,null,null,"",{"$f":"IF($A15=\"\",\"\",(J15-J$13)+K14)","v":""},null,"",{"$f":"IF($A15=\"\",\"\",(K15+SUMIF($L$13:L15,\">0\"))/C15/24)","v":""}]
[null,"",{"$f":"IF(A16=\"\",\"\",(A16-A$13))","v":""},null,null,null,null,null,null,"",{"$f":"IF($A16=\"\",\"\",(J16-J$13)+K15)","v":""},null,"",{"$f":"IF($A16=\"\",\"\",(K16+SUMIF($L$13:L16,\">0\"))/C16/24)","v":""}]
[null,"","",null,null,null,null,null,null,"",{"$f":"IF($A17=\"\",\"\",(J17-J$13)+K16)","v":""},null,"",{"$f":"IF($A17=\"\",\"\",(K17+SUMIF($L$13:L17,\">0\"))/C17/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A18=\"\",\"\",(K18+SUMIF($L$13:L18,\">0\"))/C18/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A19=\"\",\"\",(K19+SUMIF($L$13:L19,\">0\"))/C19/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A20=\"\",\"\",(K20+SUMIF($L$13:L20,\">0\"))/C20/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A21=\"\",\"\",(K21+SUMIF($L$13:L21,\">0\"))/C21/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A22=\"\",\"\",(K22+SUMIF($L$13:L22,\">0\"))/C22/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A23=\"\",\"\",(K23+SUMIF($L$13:L23,\">0\"))/C23/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A24=\"\",\"\",(K24+SUMIF($L$13:L24,\">0\"))/C24/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A25=\"\",\"\",(K25+SUMIF($L$13:L25,\">0\"))/C25/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A26=\"\",\"\",(K26+SUMIF($L$13:L26,\">0\"))/C26/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A27=\"\",\"\",(K27+SUMIF($L$13:L27,\">0\"))/C27/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A28=\"\",\"\",(K28+SUMIF($L$13:L28,\">0\"))/C28/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A29=\"\",\"\",(K29+SUMIF($L$13:L29,\">0\"))/C29/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A30=\"\",\"\",(K30+SUMIF($L$13:L30,\">0\"))/C30/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A31=\"\",\"\",(K31+SUMIF($L$13:L31,\">0\"))/C31/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A32=\"\",\"\",(K32+SUMIF($L$13:L32,\">0\"))/C32/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A33=\"\",\"\",(K33+SUMIF($L$13:L33,\">0\"))/C33/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A34=\"\",\"\",(K34+SUMIF($L$13:L34,\">0\"))/C34/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A35=\"\",\"\",(K35+SUMIF($L$13:L35,\">0\"))/C35/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A36=\"\",\"\",(K36+SUMIF($L$13:L36,\">0\"))/C36/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A37=\"\",\"\",(K37+SUMIF($L$13:L37,\">0\"))/C37/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A38=\"\",\"\",(K38+SUMIF($L$13:L38,\">0\"))/C38/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A39=\"\",\"\",(K39+SUMIF($L$13:L39,\">0\"))/C39/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A40=\"\",\"\",(K40+SUMIF($L$13:L40,\">0\"))/C40/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A41=\"\",\"\",(K41+SUMIF($L$13:L41,\">0\"))/C41/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A42=\"\",\"\",(K42+SUMIF($L$13:L42,\">0\"))/C42/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A43=\"\",\"\",(K43+SUMIF($L$13:L43,\">0\"))/C43/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A44=\"\",\"\",(K44+SUMIF($L$13:L44,\">0\"))/C44/24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,{"$f":"IF($A45=\"\",\"\",(K45+SUMIF($L$13:L45,\">0\"))/C45/24)","v":""}]
[null,{"$f":"IF(A46=\"\",\"\",(A46-A43))","v":""},"",null,null,null,null,null,null,{"$f":"IF(A46=\"\",\"\",(((D46-D43)+(F46-F43)+(H46-H43))/((E46+G46+I46)/24)))","v":""},"",null,"",{"$f":"IF($A46=\"\",\"\",(K46+SUMIF($L$13:L46,\">0\"))/C46/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A47=\"\",\"\",(K47+SUMIF($L$13:L47,\">0\"))/C47/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A48=\"\",\"\",(K48+SUMIF($L$13:L48,\">0\"))/C48/24)","v":""}]
[null,"","",null,null,null,null,null,null,"","",null,"",{"$f":"IF($A49=\"\",\"\",(K49+SUMIF($L$13:L49,\">0\"))/C49/24)","v":""}]

{"sheet":"T4 - GW Elevation (FP)","index":10,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,10,3,12],[3,1,3,5],[6,2,6,3],[7,2,7,3],[6,6,6,7],[7,6,7,7],[6,10,6,11],[7,10,7,11],[7,14,7,15],[6,18,6,19],[7,18,7,19],[8,18,8,19],[9,18,9,19],[8,14,8,15],[9,14,9,15],[6,14,6,15],[10,18,10,19],[10,2,10,3],[9,2,9,3],[8,2,8,3],[8,6,8,7],[9,6,9,7],[10,6,10,7],[8,10,8,11],[9,10,9,11],[10,10,10,11],[10,14,10,15]]}
[]
["TABLE 4:  GROUNDWATER ELEVATION TABLE"]
[]
["Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,null,"Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,"All Measurements = Feet"]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Data = Blank"]
[]
["WELL NO."]
["DIAMETER (inches)"]
["WELL DEPTH"]
["SCREEN INTERVAL"]
["TOC ELEVATION"]
[]
["DATE","ELEV","DTW","Diff.","FP","ELEV","DTW","Diff.","FP","ELEV","DTW","Diff.","FP","ELEV","DTW","Diff.","FP","ELEV","DTW","Diff.","FP"]
[null,{"$f":"IF(C14=\"\",\"\",(C$11-C14))","v":""},null,null,null,{"$f":"IF(G14=\"\",\"\",(G$11-G14))","v":""},null,null,null,{"$f":"IF(K14=\"\",\"\",(K$11-K14))","v":""},null,null,null,{"$f":"IF(O14=\"\",\"\",(O$11-O14))","v":""},null,null,null,{"$f":"IF(S14=\"\",\"\",(S$11-S14))","v":""}]
[null,{"$f":"IF(C15=\"\",\"\",(C$11-C15))","v":""},null,{"$f":"IF(B15=\"\",\"\",A15-A14)","v":""},{"$f":"IF(C15=\"\",\"\",B15-B14)","v":""},{"$f":"IF(G15=\"\",\"\",(G$11-G15))","v":""},null,{"$f":"IF(F15=\"\",\"\",E15-E14)","v":""},{"$f":"IF(G15=\"\",\"\",F15-F14)","v":""},{"$f":"IF(K15=\"\",\"\",(K$11-K15))","v":""},null,{"$f":"IF(J15=\"\",\"\",I15-I14)","v":""},{"$f":"IF(K15=\"\",\"\",J15-J14)","v":""},{"$f":"IF(O15=\"\",\"\",(O$11-O15))","v":""},null,{"$f":"IF(N15=\"\",\"\",M15-M14)","v":""},{"$f":"IF(O15=\"\",\"\",N15-N14)","v":""},{"$f":"IF(S15=\"\",\"\",(S$11-S15))","v":""},null,{"$f":"IF(R15=\"\",\"\",Q15-Q14)","v":""},{"$f":"IF(S15=\"\",\"\",R15-R14)","v":""}]
[null,"",null,{"$f":"IF(B16=\"\",\"\",A16-A15)","v":""},"","",null,{"$f":"IF(F16=\"\",\"\",E16-E15)","v":""},{"$f":"IF(G16=\"\",\"\",F16-F15)","v":""},"",null,{"$f":"IF(J16=\"\",\"\",I16-I15)","v":""},{"$f":"IF(K16=\"\",\"\",J16-J15)","v":""},"",null,{"$f":"IF(N16=\"\",\"\",M16-M15)","v":""},{"$f":"IF(O16=\"\",\"\",N16-N15)","v":""},"",null,{"$f":"IF(R16=\"\",\"\",Q16-Q15)","v":""},{"$f":"IF(S16=\"\",\"\",R16-R15)","v":""}]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[null,"",null,"","","",null,"","","",null,"","","",null,"","","",null,"",""]
[]
[]
[]
[]
[null,"",null,{"$f":"IF(B39=\"\",\"\",A39-#REF!)","v":""},{"$f":"IF(C39=\"\",\"\",B39-#REF!)","v":""},"",null,{"$f":"IF(F39=\"\",\"\",E39-#REF!)","v":""},{"$f":"IF(G39=\"\",\"\",F39-#REF!)","v":""},"",null,{"$f":"IF(J39=\"\",\"\",I39-#REF!)","v":""},{"$f":"IF(K39=\"\",\"\",J39-#REF!)","v":""},"",null,{"$f":"IF(N39=\"\",\"\",M39-#REF!)","v":""},{"$f":"IF(O39=\"\",\"\",N39-#REF!)","v":""},"",null,{"$f":"IF(R39=\"\",\"\",Q39-#REF!)","v":""},{"$f":"IF(S39=\"\",\"\",R39-#REF!)","v":""}]

{"sheet":"T4A - GW Elevation (No FP)","index":11,"n_rows":38,"n_cols":19,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,9,2,10],[2,1,2,5]]}
["TABLE 4A:  GROUNDWATER ELEVATION TABLE (No FP)"]
[]
["Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,"Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,null,null,"All Measurements = Feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Data = Blank"]
[]
["WELL NO."]
["DIAMETER (inches)"]
["WELL DEPTH"]
["SCREEN INTERVAL"]
["TOC ELEVATION"]
[]
["DATE","ELEV","DTW","Diff.","ELEV","DTW","Diff.","ELEV","DTW","Diff.","ELEV","DTW","Diff.","ELEV","DTW","Diff.","ELEV","DTW","Diff."]
[null,{"$f":"IF(C13=\"\",\"\",(C$10-C13))","v":""},null,null,{"$f":"IF(F13=\"\",\"\",(F$10-F13))","v":""},null,null,{"$f":"IF(I13=\"\",\"\",(I$10-I13))","v":""},null,null,{"$f":"IF(L13=\"\",\"\",(L$10-L13))","v":""},null,null,{"$f":"IF(O13=\"\",\"\",(O$10-O13))","v":""},null,null,{"$f":"IF(R13=\"\",\"\",(R$10-R13))","v":""}]
[null,{"$f":"IF(C14=\"\",\"\",(C$10-C14))","v":""},null,{"$f":"IF(C14=\"\",\"\",B14-B13)","v":""},{"$f":"IF(F14=\"\",\"\",(F$10-F14))","v":""},null,{"$f":"IF(F14=\"\",\"\",E14-E13)","v":""},{"$f":"IF(I14=\"\",\"\",(I$10-I14))","v":""},null,{"$f":"IF(I14=\"\",\"\",H14-H13)","v":""},{"$f":"IF(L14=\"\",\"\",(L$10-L14))","v":""},null,{"$f":"IF(L14=\"\",\"\",K14-K13)","v":""},{"$f":"IF(O14=\"\",\"\",(O$10-O14))","v":""},null,{"$f":"IF(O14=\"\",\"\",N14-N13)","v":""},{"$f":"IF(R14=\"\",\"\",(R$10-R14))","v":""},null,{"$f":"IF(R14=\"\",\"\",Q14-Q13)","v":""}]
[null,{"$f":"IF(C15=\"\",\"\",(C$10-C15))","v":""},null,{"$f":"IF(C15=\"\",\"\",B15-B14)","v":""},{"$f":"IF(F15=\"\",\"\",(F$10-F15))","v":""},null,{"$f":"IF(F15=\"\",\"\",E15-E14)","v":""},{"$f":"IF(I15=\"\",\"\",(I$10-I15))","v":""},null,{"$f":"IF(I15=\"\",\"\",H15-H14)","v":""},{"$f":"IF(L15=\"\",\"\",(L$10-L15))","v":""},null,{"$f":"IF(L15=\"\",\"\",K15-K14)","v":""},{"$f":"IF(O15=\"\",\"\",(O$10-O15))","v":""},null,{"$f":"IF(O15=\"\",\"\",N15-N14)","v":""},{"$f":"IF(R15=\"\",\"\",(R$10-R15))","v":""},null,{"$f":"IF(R15=\"\",\"\",Q15-Q14)","v":""}]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]

{"sheet":"T5 - GWR Analytical","index":12,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,2,3,5]]}
[]
["TABLE 5:  GROUNDWATER  TREATMENT SYSTEM ANALYTICAL SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"If Non-Detect Use MDL \"U\""]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,"Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,"Not Sampled = NS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Analytical Results = µg/l"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mass Recovered = lbs"]
["Sample",null,"Hour","Instantaneous","  Total Gallons",null,null,"Ethyl","Total","Total",null,null,"Dissolved","Total",null," VOA Mass"]
["Location","Date","Meter","Flow - GPM","Pumped","Benzene","Toluene","Benzene","Xylenes","VOA","MTBE","EDB","Lead","Lead","TRPH","Recovered (lbs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B9=\"\",\"\",'T5 - GWR Analytical'!E9*J9*3.785*(1/1000000)*(1/1000)*2.2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10=\"\",\"\",(E10-E9)*((0.5*(J9+J10))*3.785*(1/1000000)*(1/1000)*2.2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",((E11-E10)*((0.5*(J10+J11))*3.785*(1/1000000)*(1/1000)*2.2))+P10)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"\",\"\",((E12-E11)*((0.5*(J11+J12))*3.785*(1/1000000)*(1/1000)*2.2))+P11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"T6 - MW Analytical ","index":13,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,2,3,6],[3,10,3,11]]}
[]
["TABLE 6:   GROUNDWATER MONITORING WELL ANALYTICAL SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If Non-Detect Use MDL \"U\""]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,"Facility ID#:",null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,"Not Sampled = NS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Analytical Results = µg/l"]
["B= Base Line",null,null,"NADC ",100,400,300,200,"NA",200,2,"NA",150,140,280,280,50000]
["K= Key Well",null,null,"CTL'S",1,40,30,20,"NA",20,0.02,"NA",15,14,28,28,5000]
["Location","Screen",null,null,null,null,"Ethyl","Total","Total",null,null,"Dissolved","Total","Naptha-","Methyl","Methyl"]
[null,"Int.","Date","DTW","Benzene","Toluene","Benzene","Xylenes","VOA","MTBE","EDB","Lead","Lead","lene","nap, 1","nap, 2","TRPH"]
["MW-1"]

{"sheet":"T7 - SVE Analytical ","index":14,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,7,3,8],[3,2,3,4]]}
[]
["TABLE 7:  VAPOR TREATMENT SYSTEM ANALYTICAL SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,"If Non-Detect Use MDL \"U\""]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,"Facility ID#:",{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,"Not Sampled = NS"]
[null,null,null,null,null,null,null,null,null,null,"Analytical Results = mg/m3"]
[]
["Sample",null,"Hour","System Vacuum","Flow Rate","OVA",null,null,"Ethyl","Total","Total",null,"Emission","Total Mass"]
["Location","Date","Meter","(in of H20)","(scfm)","(ppm)","Benzene","Toluene","Benzene","Xylenes","VOA","TPH","Rate (lb/day)","Recovered (lbs)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L9=\"\",\"\",L9*E9*0.00008990535168)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L10=\"\",\"\",L10*E10*0.00008990535168)","v":""},{"$f":"IF(B10=\"\",\"\",(0.5*(M9+M10))*((C10-C9)/24))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(B11=\"\",\"\",N10+(0.5*(M10+M11))*((C11-C10)/24))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(B12=\"\",\"\",N11+(0.5*(M11+M12))*((C12-C11)/24))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"T8 - SVE-MPX Well","index":15,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,15],[3,2,3,5],[3,8,3,10],[14,15,15,15],[14,6,15,6],[14,8,14,9],[14,10,15,10],[14,11,15,11],[14,13,14,14],[14,1,15,1],[14,5,15,5],[14,3,14,4]]}
[]
["TABLE 8:  SVE/MPX WELL DATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"All Measurements = Feet"]
[null,"Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,null,{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,"No Data = Blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OVA Readings = ppm"]
[null,null,null,null,"Standard Temp = ",null,"°F",null,null,"Standard Pressure =",null,null,"Vacuum = in of H2O"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Flow = scfm"]
["WELL NO."]
["DIAMETER (inches)"]
["WELL DEPTH"]
["SCREEN INT."]
["DESIGN FLOW/VAC"]
["OPTIMAL FLOW/VAC"]
[]
[null,"Date","Flow","Vacuum",null,"OVA","Date","Flow","Vacuum",null,"OVA","Date","Flow","Vacuum",null,"OVA"]
[null,null,"Mani-fold","Mani-fold","Well-head",null,null,"Mani-fold","Mani-fold","Well-head",null,null,"Mani-fold","Mani-fold","Well-head"]

{"sheet":"T9 - AS Well","index":16,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,16],[14,11,14,12],[14,15,14,16],[14,1,15,1],[14,9,15,9],[14,13,15,13],[14,5,15,5],[14,3,14,4],[14,7,14,8],[3,2,3,5],[3,8,3,9]]}
[]
["TABLE 9:  AIR SPARGING WELL DATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All Measurements = Feet"]
[null,"Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,null,"Facility ID#:",{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,null,"No Data = Blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow = SCFM"]
[null,null,null,null,"Standard Temp = ",null,"°F",null,null,"Standard Pressure = ",null,null,null,"Pressure = PSI"]
[]
["WELL NO."]
["DIAMETER (inches)"]
["WELL DEPTH"]
["SCREEN INT."]
["DESIGN FLOW/PRESS"]
["OPTIMAL FLOW/PRESS"]
[]
[null,"Date","Flow","Pressure",null,"Date","Flow","Pressure",null,"Date","Flow","Pressure",null,"Date","Flow","Pressure"]
[" ",null,"Mani-fold","Mani-fold","Well-head",null,"Mani-fold","Mani-fold","Well-head",null,"Mani-fold","Mani-fold","Well-head",null,"Mani-fold","Mani-fold","Well-head"]

{"sheet":"T10 - GWR RW","index":17,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,12],[10,7,10,8],[6,1,6,2],[7,1,7,2],[6,3,6,4],[7,3,7,4],[8,1,8,2],[9,1,9,2],[10,1,10,2],[9,3,9,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[8,7,8,8],[9,7,9,8],[11,1,11,2],[10,3,10,4],[11,3,11,4],[11,5,11,6],[8,3,8,4],[10,11,10,12],[11,11,11,12],[3,2,3,3],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[11,7,11,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[6,7,6,8],[7,7,7,8]]}
[]
["TABLE 10:  GROUNDWATER RECOVERY WELL DATA"]
[null,null,null,null,null,null,null,null,null,null,"All Measurements = Feet"]
[null,"Facility Name:",{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,"Facility ID#:",{"$f":"'T1A - Site Summary'!C6","v":123456789},null,null,null,"No Data = Blank"]
[null,null,null,null,null,null,null,null,null,null,"Flow = GPM"]
[null,null," "]
["WELL NO."]
["DIAMETER (inches)"]
["WELL DEPTH"]
["SCREEN INT."]
["DESIGN FLOW"]
["OPTIMAL FLOW"]
[]
[null,"Date","Flow","Date","Flow","Date","Flow","Date","Flow","Date","Flow","Date","Flow"]

{"sheet":"T11 - System Influence","index":18,"n_rows":12,"n_cols":17,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,16],[4,8,4,9]]}
[]
["TABLE 11:   SYSTEM INFLUENCE MONITORING PARAMETERS "]
[]
[]
["Facility Name:",null,{"$f":"'T1A - Site Summary'!C3","v":"DEP BMC"},null,null,null,"Facility ID#:",null,123456789,null,null,"DTW = Feet",null,"Vac/Press = in of H2O"]
[null,null,null,null,null,null,null,null,null,null,null,"D.O. - mg/l",null,"Obs. - Visual Observations"]
[]
["WELL NO."]
["WELL DEPTH"]
["SCREEN INT."]
[]
["DATE","DTW","D.O.","Vac/Press","Obs.","DTW","D.O.","Vac/Press","Obs.","DTW","D.O.","Vac/Press","Obs.","DTW","D.O.","Vac/Press","Obs."]