{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["SOW Template","Water Sampling","Soil-Air Sampling","SB-Well Installation","WA","O&M Parameters","RAC","SR","Analytical Lookup","Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":45,"comments":6,"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":"SOW Template","index":0,"n_rows":78,"n_cols":6,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[35,0,35,2],[40,0,40,2],[39,0,39,2],[38,0,38,2],[37,0,37,2],[36,0,36,2],[13,0,13,3],[7,0,7,1],[20,2,20,3],[22,2,22,3],[77,0,77,3],[70,0,70,3],[72,0,72,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[67,0,67,3],[68,0,68,3],[71,0,71,3],[73,0,73,3],[24,2,24,3],[26,2,26,3],[57,0,57,2],[58,0,58,2],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[34,0,34,3],[30,2,30,3],[41,0,41,2],[42,0,42,2],[43,0,43,2],[32,2,32,3],[49,0,49,2],[28,2,28,3],[65,0,65,2],[64,0,64,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[51,0,51,2],[59,0,59,2],[50,0,50,2],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2]]}
["Attachment A"]
["Petroleum Restoration Program"]
["Scope of Work"]
[]
[null,null,"9-Digit Facility ID Number:"]
[null,null,"STCM Facility Name:"]
[]
["SubPhase(s):",null,null,null,true]
[null,null,null,null,{"$f":"IF(C9<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"IF(C10<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,false]
[null,null,null,null,false]
[null,null,null,null,true]
["Specifications\nAll work must be performed in accordance with this Scope of Work (SOW) and any attachments, Chapters 62-160, 62-532, 62-777 and 62-780, F.A.C., all applicable FDEP and Water Management District guidance memoranda, standard industry procedures and as described in the Agency Term Contract (ATC).\nCopies of all referenced guidelines are available at: ",null,null,null,true]
["http://floridadep.gov/waste/petroleum-restoration",null,null,null,true]
["Reports must be submitted using the appropriate FDEP forms found at:",null,null,null,true]
["http://floridadep.gov/waste/petroleum-restoration/content/procedures-guidance-documents",null,null,null,true]
["All work must be conducted in accordance with PRP Standard Specification Details found at:",null,null,null,true]
["http://floridadep.gov/waste/petroleum-restoration/content/templates-forms-tools-and-guidance",null,null,null,true]
["The following tables are included as attachments to this SOW and further represent the details of the scope of work.",null,null,null,true]
[null,null," Water Sampling Table",null,{"$f":"IF(B21=\"P\",TRUE,FALSE)","v":false},"Water Sampling"]
[null,null,null,null,{"$f":"E21","v":false}]
[null,null," Soil and Air Sampling Table",null,{"$f":"IF(B23=\"P\",TRUE,FALSE)","v":false},"Soil-Air Sampling"]
[null,null,null,null,{"$f":"E23","v":false}]
[null,null," Soil Boring (SB) and Well Installation Table",null,{"$f":"IF(B25=\"P\",TRUE,FALSE)","v":false},"SB-Well Installation"]
[null,null,null,null,{"$f":"E25","v":false}]
[null,null," Well Abandonment Table",null,{"$f":"IF(B27=\"P\",TRUE,FALSE)","v":false},"WA"]
[null,null,null,null,{"$f":"E27","v":false}]
[null,null," O&M (System) Parameters Table",null,{"$f":"IF(B29=\"P\",TRUE,FALSE)","v":false},"O&M Parameters"]
[null,null,null,null,{"$f":"E29","v":false}]
[null,null," Remedial Action Construction Table",null,{"$f":"IF(B31=\"P\",TRUE,FALSE)","v":false},"RAC"]
[null,null,null,null,{"$f":"E31","v":false}]
[null,null," Source Removal Table",null,{"$f":"IF(B33=\"P\",TRUE,FALSE)","v":false},"SR"]
[null,null,null,null,{"$f":"E33","v":false}]
[null,null,null,null,true]
["Task 1 Description:",null,null,null,{"$f":"IF(OR(D36<>\"\",D37<>\"\",D38<>\"\"),TRUE,FALSE)","v":false}]
["Task 1 Deliverable:",null,null,null,{"$f":"E36","v":false}]
["Task 1 Deliverable Due Date:",null,null,null,{"$f":"E36","v":false}]
["Task 2 Description:",null,null,null,{"$f":"IF(OR(D39<>\"\",D40<>\"\",D41<>\"\"),TRUE,FALSE)","v":false}]
["Task 2 Deliverable:",null,null,null,{"$f":"E39","v":false}]
["Task 2 Deliverable Due Date:",null,null,null,{"$f":"E39","v":false}]
["Task 3 Description:",null,null,null,{"$f":"IF(OR(D42<>\"\",D43<>\"\",D44<>\"\"),TRUE,FALSE)","v":false}]
["Task 3 Deliverable:",null,null,null,{"$f":"E42","v":false}]
["Task 3 Deliverable Due Date:",null,null,null,{"$f":"E42","v":false}]
["Task 4 Description:",null,null,null,{"$f":"IF(OR(D45<>\"\",D46<>\"\",D47<>\"\"),TRUE,FALSE)","v":false}]
["Task 4 Deliverable:",null,null,null,{"$f":"E45","v":false}]
["Task 4 Deliverable Due Date:",null,null,null,{"$f":"E45","v":false}]
["Task 5 Description:",null,null,null,{"$f":"IF(OR(D48<>\"\",D49<>\"\",D50<>\"\"),TRUE,FALSE)","v":false}]
["Task 5 Deliverable:",null,null,null,{"$f":"E48","v":false}]
["Task 5 Deliverable Due Date:",null,null,null,{"$f":"E48","v":false}]
["Task 6 Description:",null,null,null,{"$f":"IF(OR(D51<>\"\",D52<>\"\",D53<>\"\"),TRUE,FALSE)","v":false}]
["Task 6 Deliverable:",null,null,null,{"$f":"E51","v":false}]
["Task 6 Deliverable Due Date:",null,null,null,{"$f":"E51","v":false}]
["Task 7 Description:",null,null,null,{"$f":"IF(OR(D54<>\"\",D55<>\"\",D56<>\"\"),TRUE,FALSE)","v":false}]
["Task 7 Deliverable:",null,null,null,{"$f":"E54","v":false}]
["Task 7 Deliverable Due Date:",null,null,null,{"$f":"E54","v":false}]
["Task 8 Description:",null,null,null,{"$f":"IF(OR(D57<>\"\",D58<>\"\",D59<>\"\"),TRUE,FALSE)","v":false}]
["Task 8 Deliverable:",null,null,null,{"$f":"E57","v":false}]
["Task 8 Deliverable Due Date:",null,null,null,{"$f":"E57","v":false}]
["Task 9 Description:",null,null,null,{"$f":"IF(OR(D60<>\"\",D61<>\"\",D62<>\"\"),TRUE,FALSE)","v":false}]
["Task 9 Deliverable:",null,null,null,{"$f":"E60","v":false}]
["Task 9 Deliverable Due Date:",null,null,null,{"$f":"E60","v":false}]
["Task 10 Description:",null,null,null,{"$f":"IF(OR(D63<>\"\",D64<>\"\",D65<>\"\"),TRUE,FALSE)","v":false}]
["Task 10 Deliverable:",null,null,null,{"$f":"E63","v":false}]
["Task 10 Deliverable Due Date:",null,null,null,{"$f":"E63","v":false}]
["PO End Date:  ",null,null,{"$f":"IF(AND(D65=\"\",D62=\"\",D59=\"\",D56=\"\",D53=\"\",D50=\"\",D47=\"\",D44=\"\",D41=\"\",D38=\"\"),\"\",WORKDAY(MAX(D65,D62,D59,D56,D53,D50,D47,D44,D41,D38)+59,1))","v":""},true]
[null,null,null,null,true]
["Schedule of Pay Items (SPI)\nAll unit rates and extended prices for all line item costs associated with this project are provided in the SPI [Attachment B to this Purchase Order (PO)] and shall not exceed the rates established in the ATC.",null,null,null,true]
["Requests for Change (RFC)\nAll requests for changes to the SOW must be submitted in writing and be approved in writing by the FDEP/LP using the RFC form in accordance with the ATC and can be found at: ",null,null,null,true]
["http://floridadep.gov/waste/petroleum-restoration/content/templates-forms-tools-and-guidance",null,null,null,true]
["Any change which results in an extension of the due dates, PO end date, or a change in quantities or costs, requires that a PO Change Order be formally issued prior to performance of the revised SOW. ",null,null,null,true]
["Performance Measures\nThe FDEP/LP Site Manager will review the submitted documentation to confirm that all work was performed in accordance with the Specifications referenced above. The FDEP/LP Site Manager will notify the Contractor of acceptance or any deficiencies in the work and/or deliverables. The Contractor will be given an opportunity to remedy deficiencies at no additional cost to the FDEP.",null,null,null,true]
["The FDEP/LP Site Manager will review the work and/or deliverables within the timeframes established in FDEP guidance documents. The Contractor will respond to any comments to complete the work and/or deliverables within the timeframe established in the comment letter or email correspondence.",null,null,null,true]
["Invoicing, Payments and Financial Consequences\nThe Contractor may submit an invoice for a Task upon written notification of acceptance of the work/deliverables by the FDEP/LP Site Manager. Upon receipt of FDEP/LP written approval of the required documentation for completed portions of each task, the Contractor must submit an invoice within thirty (30) days. Invoices for completed work may be submitted at any time for fully completed and approved tasks, but no more frequently than every thirty (30) days, for approved partial tasks. Each invoice request must contain all documentation of performance as specified in the ATC, this Purchase Order (PO), and its attachments.",null,null,null,true]
["Failure to provide all deliverables which are satisfactory or failure to meet the specified deliverable timetables, shall result in non-payment, loss of retainage, or other financial consequences, and/or termination of the PO, as specified in the ATC. If the deliverable due day occurs on a weekend, state holiday, or federal holiday the deliverable will be due the following business day.",null,null,null,true]
["Retainage shall be withheld in the amount of 5%, unless otherwise noted in the SPI, from each payment by the FDEP/LP until completion and approval of all Tasks. The Contractor shall submit a Release of Claims and request for retainage payment with the final invoice. Payment of retainage will be reduced by the amount of any assessed financial consequences.",null,null,null,true]
["Notice of Field Activities\nThe Contractor must provide written notification (emails are acceptable) of field activities at least seven (7) calendar days prior to the commencement of work to all applicable parties including the PRP site manager, PRP Inspector (PRP_Inspector@dep.state.fl.us), site operator, site owner, RP and affected off-site property owners.",null,null,null,true]
["Deliverables\nAll deliverables under this Purchase Order must be electronic.  Paper copies should not be submitted unless the deliverable requires a Professional Engineer (PE) or Professional Geologist (PG) signature and seal, and the electronic signature and seal does not meet the requirements in Chapters 61G15 or 61G16, Florida Administrative Code, as applicable.",null,null,null,true]

{"sheet":"Water Sampling","index":1,"n_rows":111,"n_cols":22,"rows_kept":111,"cut":false,"hidden":false,"merged":[[0,8,0,18],[110,0,110,3]]}
[null,"FDEP Facility ID#:  ",{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,null,null,null,"STCM Facility Name:  ",{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to the scope of work."]
["WATER SAMPLING TABLE"]
["Task #","Well #(s) or Water Sample Location","Frequency\n(if applicable)","Expedited Turnaround (TA)","Water Level/FP Gauging Only","# MWs\nSampled","BTEX + MTBE","PAHs","TRPH (FL-PRO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A7<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A71<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[1,null,null,"Task 1 Subtotal",{"$f":"SUMIF($A$6:$A$100,1,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(COUNTIF($A$6:$A$100,A101),TRUE,FALSE)","v":false}]
[2,null,null,"Task 2 Subtotal",{"$f":"SUMIF($A$6:$A$100,2,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(COUNTIF($A$6:$A$100,A102),TRUE,FALSE)","v":false}]
[3,null,null,"Task 3 Subtotal",{"$f":"SUMIF($A$6:$A$100,3,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[4,null,null,"Task 4 Subtotal",{"$f":"SUMIF($A$6:$A$100,4,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[5,null,null,"Task 5 Subtotal",{"$f":"SUMIF($A$6:$A$100,5,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[6,null,null,"Task 6 Subtotal",{"$f":"SUMIF($A$6:$A$100,6,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[7,null,null,"Task 7 Subtotal",{"$f":"SUMIF($A$6:$A$100,7,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[8,null,null,"Task 8 Subtotal",{"$f":"SUMIF($A$6:$A$100,8,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[9,null,null,"Task 9 Subtotal",{"$f":"SUMIF($A$6:$A$100,9,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[10,null,null,"Task 10 Subtotal",{"$f":"SUMIF($A$6:$A$100,10,E$6:E$100)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,false]
["GRAND TOTALS",null,null,null,{"$f":"SUM(E101:E110)","v":0},{"$f":"SUM(F101:F110)","v":0},{"$f":"SUM(G101:G110)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,true]

{"sheet":"Soil-Air Sampling","index":2,"n_rows":76,"n_cols":21,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,7,0,17],[75,0,75,4]]}
[null,"FDEP Facility ID#:  ",{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,null,null,"STCM Facility Name:  ",{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to the scope of work."]
["SOIL and AIR SAMPLING TABLE"]
["Task #","Soil /Air Sample Locations","Frequency\n(if applicable)","Expedited Turnaround (TA)","Depth Interval\n(if applicable)","BTEX + MTBE + VOHs","VOHs","TRPH (FL-PRO)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A40<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A47<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[1,null,null,null,"Task 1 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,1,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,1,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(COUNTIF($A$6:$A$65,A66),TRUE,FALSE)","v":false}]
[2,null,null,null,"Task 2 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,2,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,2,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[3,null,null,null,"Task 3 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,3,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,3,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[4,null,null,null,"Task 4 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,4,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,4,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[5,null,null,null,"Task 5 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,5,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,5,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[6,null,null,null,"Task 6 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,6,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,6,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[7,null,null,null,"Task 7 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,7,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,7,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[8,null,null,null,"Task 8 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,8,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,8,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[9,null,null,null,"Task 9 Subtotal  ",{"$f":"SUMIF($A$6:$A$65,9,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,9,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
[10,null,null,null,"Task 10 Subtotal ",{"$f":"SUMIF($A$6:$A$65,10,F$6:F$65)","v":0},{"$f":"SUMIF($A$6:$A$65,10,G$6:G$65)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,false]
["GRAND TOTALS",null,null,null,null,{"$f":"SUM(F66:F75)","v":0},{"$f":"SUM(G66:G75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,true]

{"sheet":"SB-Well Installation","index":3,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,8,0,16],[52,0,52,3],[4,5,4,7],[4,0,4,4],[4,8,4,17],[52,5,52,12],[52,14,52,15]]}
[null,"FDEP Facility ID#:  ",{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,null,null,null,"STCM Facility Name:  ",{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to the scope of work."]
["SOIL BORING (SB) and WELL INSTALLATION TABLE"]
["SOIL BORING DETAILS",null,null,null,null,"Screening/Split Spoon Intervals",null,null,"WELL INSTALLATION DETAILS  "]
["TASK #","Installation\nMethod","Quantity","Depth\n(ft bls)","Total\nBoring\nFootage\n(ft)","Screening\nDepth\nInterval 1\n& Spacing","Screening\nDepth\nInterval 2\n& Spacing","Screening\nDepth\nInterval 3\n& Spacing","Quantity","Well Type","Well Diameter (in)","Depth \n(ft bls)","Screen Interval\n(ft bls)","Total\nWell\nFootage\n(ft)","Surface Casing Diameter\n(in)","Surface Casing Depth\n(ft)","Total\nCasing\nFootage\n(ft)","Well\nCompletion\nType"]
[null,null,null,null,{"$f":"IF(A7>0,(C7*D7),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A7>0,(I7*L7),0)","v":0},null,null,{"$f":"IF(A7>0,(I7*P7),0)","v":0},null,{"$f":"IF(A7<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,{"$f":"IF(A8>0,(C8*D8),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(A8>0,(I8*L8),0)","v":0},null,null,{"$f":"IF(A8>0,(I8*P8),0)","v":0},null,{"$f":"IF(A8<>\"\",TRUE,FALSE)","v":false}]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,0,null,null,null,null,null,null,null,null,0,null,null,0,null,false]
[null,null,null,null,{"$f":"IF(A52>0,(C52*D52),0)","v":0},null,null,null,null,null,null,null,null,0,null,null,0,null,false]
["TOTALS",null,null,null,{"$f":"SUM(E7:E52)","v":0},null,null,null,null,null,null,null,null,{"$f":"SUM(N7:N52)","v":0},null,null,{"$f":"SUM(Q7:Q52)","v":0},null,true]

{"sheet":"WA","index":4,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[[0,5,0,7],[3,0,3,7],[102,0,102,3],[102,4,102,6],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4]]}
[null,"FDEP Facility ID#:  ",{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,"STCM Facility Name:",{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to this scope of work."]
["Well Abandonment Table"]
["TASK #","Well-ID","Quantity","Diameter (in)","Depth\n(ft bls)",null,"Completion Type to be Removed"]
[null,null,null,null,null,"Pad & Manhole","2' x 2' x 2'\n Vault","4' x 4' x 2'\nVault"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A7<>\"\",TRUE,FALSE)","v":false},{"$f":"IF(A7<>\"\",E7*C7,0)","v":0},{"$f":"IF(E7=\"\",F7,0)","v":0},{"$f":"IF(A7<>\"\",G7,0)","v":0},{"$f":"IF(A7<>\"\",H7,0)","v":0}]
[null,null,null,null,null,null,null,null,null,false,{"$f":"IF(A8<>\"\",E8*C8,0)","v":0},{"$f":"IF(E8=\"\",F8,0)","v":0},{"$f":"IF(A8<>\"\",G8,0)","v":0},{"$f":"IF(A8<>\"\",H8,0)","v":0}]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A39<>\"\",TRUE,FALSE)","v":false},0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(A71<>\"\",TRUE,FALSE)","v":false},0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,{"$f":"IF(A72<>\"\",E72*C72,0)","v":0},{"$f":"IF(E72=\"\",F72,0)","v":0},{"$f":"IF(A72<>\"\",G72,0)","v":0},{"$f":"IF(A72<>\"\",H72,0)","v":0}]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,false,0,0,0,0]
[null,null,null,null,null,null,null,null,null,true]
["Grout and Abandon Well",null,null,null,"Removal",null,null,null,null,true]
["SPI 7-1\nTotal feet \n(>0-2 in)","SPI 7-2\nTotal feet \n(>2-4 in)","SPI 7-3\nTotal feet \n(>4-6 in)","SPI 7-4\nTotal feet \n(>6 in)","SPI 7-7\nPad & Manhole * Only","SPI 7-5\n2' x 2' x 2'\n Vault","SPI 7-6\n4' x 4' x 2'\nVault",null,null,true]
[{"$f":"((SUMIFS(K7:K101,D7:D101,\">0\",D7:D101,\"<=2\")))","v":0},{"$f":"((SUMIFS(K7:K101,D7:D101, \">2\",D7:D101, \"<=4\")))","v":0},{"$f":"((SUMIFS(K7:K101,D7:D101, \">4\",D7:D101, \"<=6\")))","v":0},{"$f":"((SUMIFS(K7:K101,D7:D101, \">6\")))","v":0},{"$f":"SUM(L7:L101)","v":0},{"$f":"SUM(M7:M101)","v":0},{"$f":"SUM(N7:N101)","v":0},null,null,true]
["* Well Pad & Manhole Removal cost is included in SPI 7-1 thru 7-4.",null,null,null,null,null,null,null,null,true]
["SPI 7-7 is only applicable for payment when the well is not being abandoned.",null,null,null,null,null,null,null,null,true]

{"sheet":"O&M Parameters","index":5,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[3,0,3,10],[0,5,0,9]]}
[null,"FDEP Facility ID#:  ",{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,"STCM Facility Name:",{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to this scope of work."]
["O&M (System) Parameters Table"]
["TASK #(s)","Location\n(e.g., MW-X, Manifold, Influent, Effluent, etc.)","Frequency \n(if applicable)","Depth to Water (DTW)","Dissolved Oxygen (DO)","Pressure/ Vacuum","Flow","OVA","Hour Meter Reading","Observations"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A6<>\"\", TRUE, FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A7<>\"\", TRUE, FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"RAC","index":6,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[53,0,53,10],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[41,7,41,10],[42,7,42,10],[43,7,43,10],[44,7,44,10],[45,7,45,10],[27,0,27,6],[28,0,28,6],[29,0,29,6],[30,0,30,6],[31,0,31,10],[32,0,32,6],[3,0,3,10],[4,0,4,10],[5,0,5,10],[6,0,6,6],[0,7,0,10],[2,0,2,10],[0,0,0,1],[0,5,0,6],[0,3,0,4],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6],[17,0,17,6],[18,0,18,6],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,10],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6],[33,0,33,6],[34,0,34,6],[35,0,35,6],[36,0,36,6],[37,0,37,10],[38,0,38,6],[39,0,39,6],[40,0,40,6],[41,0,41,6],[42,0,42,6],[43,0,43,6],[44,0,44,6],[45,0,45,6],[46,0,46,10],[52,0,52,10],[47,0,47,6],[48,0,48,6],[49,0,49,6],[50,0,50,6],[51,0,51,6]]}
["FDEP Facility ID#:  ",null,{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,null,"STCM Facility Name:  ",null,{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to the scope of work."]
["Remedial Action Construction Table"]
["SPI Section 5 and 6"]
["Well Installation Specifications"]
["Process Type (AS, SVE, MPX, GWT, etc)"]
["Total System Well Count"]
["Existing Wells to be Used"]
["New System Wells",null,null,null,null,null,null,{"$f":"H8-H9","v":0},{"$f":"I8-I9","v":0},{"$f":"J8-J9","v":0},{"$f":"K8-K9","v":0}]
["Well Type (HW, VW, AW)"]
["Well Diameter (inches)"]
["Boring Length (feet)"]
["Well Length (feet)"]
["Screened Length (feet) "]
["Well Vaults"]
["Slot Size (inches)"]
["Well Material (HDPE, PVC)"]
["Installation Method (DPT, HSA, MR, Sonic, Open Trench)"]
["Boring Diameter (inches)"]
["Total Boring Length (feet)",null,null,null,null,null,null,{"$f":"H10*H13","v":0},{"$f":"I10*I13","v":0},0,0]
["Total Well Length (feet)",null,null,null,null,null,null,{"$f":"H10*H14","v":0},{"$f":"I10*I14","v":0},{"$f":"J10*J14","v":0},{"$f":"K10*K14","v":0}]
["SPI Section 12"]
["Surface Removal",null,null,null,null,null,null,"Quantity"]
["Concrete/Asphalt Removal (square feet)"]
["Additional removal of concrete > 4-inch (square feet)"]
["Transport & Disposal of Mixed Debris or Clean Concrete (ton)",null,null,null,null,null,null,{"$f":"ROUNDUP((((H25*0.333)+(H26*0.167))/27)*1.5, 0)","v":0}]
["Transport & Disposal of Petroleum Impacted Soil (Choose Container Method)",null,null,null,null,null,null,"Well Installation",null,"Trenching"]
["Transport Petroleum Impacted Soil (ton)",null,null,null,null,null,null,null,null,{"$f":"(0.5*H42*2)*2/27*1.4","v":0}]
["Disposal of Petroleum Impacted Soil (ton) ",null,null,null,null,null,null,null,null,{"$f":"J29","v":0}]
["Transport and Disposal of Petroleum Impacted Soil (included drum)",null,null,null,null,null,null,{"$f":"ROUNDUP(((H21*(H20/12/2)^2)+(I21*(I20/12/2)^2)+(J21*(J20/12/2)^2)+(K21*(K20/12/2)^2))*PI()/27*1.4/(0.448*0.75),0)","v":0}]
["SPI Section 13"]
["Resurfacing",null,null,null,null,null,null,"Quantity"]
["Asphalt Paving (square feet)"]
["Concrete Paving (square feet)"]
["Concrete Paving extra 1-inch (square feet) {calculation assumes 2\" additional}",null,null,null,null,null,null,{"$f":"H35*2","v":0}]
["Grass-Sod or Seed and Mulch (square feet)"]
["SPI Section 15"]
["Underground Piping Specifications",null,null,null,null,null,null,{"$f":"IF(H7<>\"\",H7,\"\")","v":""},{"$f":"IF(I7<>\"\",I7,\"\")","v":""},{"$f":"IF(J7<>\"\",J7,\"\")","v":""},{"$f":"IF(K7<>\"\",K7,\"\")","v":""}]
["Underground Piping Diameter (inches)"]
["Underground Piping Material (40/80 PVC, HDPE)"]
["Total footage of trench (feet)"]
["Trench Installation and Plumbing (linear feet, 1 to 10 lines)"]
["Trench Installation and Plumbing (linear feet, 11 to 20 lines)"]
["Trench Installation and Plumbing (linear feet, 21 to 30 lines)"]
["Trench Installation and Plumbing (linear feet, additional >30 lines)"]
["SPI Section 18"]
["Process Type",null,null,null,null,null,null,"SYSTEM 1","VAPOR TREATMENT","SYSTEM 2","VAPOR TREATMENT 2"]
["Remedial Action Equipment"]
["System Size (S, M, L)"]
["Estimated Usage (Months) <= 6 months or > 6 months"]
["Vapor Treatment Vessel Size (pounds)"]
["Notes:"]

{"sheet":"SR","index":7,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[9,0,9,5],[10,0,10,5],[4,0,4,9],[5,0,5,9],[6,0,6,5],[7,0,7,5],[8,0,8,5],[0,6,0,9],[0,0,0,1],[0,4,0,5],[2,0,2,9],[3,0,3,9],[16,0,16,5],[11,9,14,9],[17,9,21,9],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,0,20,5],[21,0,21,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[22,0,22,5],[23,0,23,9],[24,0,24,5],[25,0,25,5],[26,0,26,5],[32,0,32,9],[33,0,33,5],[34,0,34,5],[35,0,35,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[31,0,31,5],[36,0,36,5],[37,0,37,5],[38,0,38,5],[39,0,39,9],[40,0,40,9],[36,6,36,9],[37,6,37,9],[41,0,41,5],[42,0,42,5],[43,0,43,5],[44,0,44,5],[45,0,45,9],[46,0,46,5],[47,0,47,5],[48,0,48,5],[49,0,49,9],[50,0,50,9],[51,7,51,9],[53,7,53,9],[56,0,56,9],[58,0,58,9],[51,0,51,5],[52,0,52,5],[53,0,53,5],[54,0,54,5],[55,0,55,5],[57,0,57,9]]}
["FDEP Facility ID#:  ",null,{"$f":"IF('SOW Template'!D5=\"\",\"\",'SOW Template'!D5)","v":""},null,"STCM Facility Name:  ",null,{"$f":"IF('SOW Template'!D6=\"\",\"\",'SOW Template'!D6)","v":""}]
[]
["Any blank fields are not applicable to the scope of work."]
["Source Removal Table"]
["SPI Section 10"]
["Sheet Piling"]
["Sheet Piling Length (feet)"]
["Sheet Piling Depth (feet)"]
["Sheet Piling Area (square feet†)",null,null,null,null,null,{"$f":"ROUNDUP(G7*G8,0)","v":0}]
["Sheet Piling Duration (number of days/weeks/months)"]
["Conventional Excavation Volume",null,null,null,null,null,"Area 1","Area 2","Area 3","Total"]
["Excavation Length (feet)"]
["Excavation Width (feet)"]
["Excavation Area (square feet)",null,null,null,null,null,{"$f":"G12*G13","v":0},{"$f":"H12*H13","v":0},{"$f":"I12*I13","v":0}]
["Excavation Depth (feet)"]
["Maximum Excavation Volume (cubic yards†)",null,null,null,null,null,{"$f":"ROUNDUP(G14*G15/27, 0)","v":0},{"$f":"ROUNDUP(H14*H15/27,0)","v":0},{"$f":"ROUNDUP(I14*I15/27,0)","v":0},{"$f":"SUM(G16:I16)","v":0}]
["LDA Excavation Volume*",null,null,null,null,null,"Area 1","Area 2","Area 3","Total"]
["Diameter of LDA (feet)"]
["LDA boring area (square feet)",null,null,null,null,null,{"$f":"PI()*G18*G18/4","v":0},{"$f":"PI()*H18*H18/4","v":0},{"$f":"PI()*I18*I18/4","v":0}]
["LDA Depth (feet)"]
["One LDA boring volume - (cubic yards)",null,null,null,null,null,{"$f":"G19*G20/27","v":0},{"$f":"H19*H20/27","v":0},{"$f":"I19*I20/27","v":0}]
["Number of LDA borings"]
["Maximum Excavation Volume* (cubic yards†)",null,null,null,null,null,{"$f":"ROUNDUP(G22*G21,0)","v":0},{"$f":"ROUNDUP(H22*H21,0)","v":0},{"$f":"ROUNDUP(I22*I21,0)","v":0},{"$f":"ROUNDUP(SUM(G23:I23),0)","v":0}]
["Flowable Fill, Backfill, Clean Overburden, Pea Gravel, #57 Stone"]
["Flowable Fill Based on Maximum Volume (cubic yards)",null,null,null,null,null,{"$f":"J23","v":0}]
["Flowable Fill to allow for Contingency (10%) (cubic yards)",null,null,null,null,null,{"$f":"G25*0.1","v":0}]
["Maximum Clean Backfill Volume (cubic yards†) ",null,null,null,null,null,{"$f":"ROUNDUP(G25+G26,0)","v":0}]
["Clean Backfill based on Maximum Excavation (cubic yards)",null,null,null,null,null,{"$f":"J16","v":0}]
["Clean Backfill to allow for Compaction (20%) (cubic yards)",null,null,null,null,null,{"$f":"G28*0.2","v":0}]
["Clean Overburden for Reuse (cubic yards)"]
["Pea Gravel or #57 Stone (cubic yards)",null,null,null,null,null,null,{"$f":"\"(enter  \" & ROUNDUP(G31*1.2,0)","v":"(enter  0"},"tons† in SPI)"]
["Maximum Clean Backfill Volume (cubic yards†)",null,null,null,null,null,{"$f":"ROUNDUP(G28+G29-G30-G31,0)","v":0}]
["Dewatering"]
["Groundwater Treatment Technology"]
["Number of Dewatering Points"]
["Depth of Dewatering Points"]
["Point of Discharge"]
["Permits Required? (NPDES, Local, etc)"]
["Dewatering Duration (number of days/weeks/months)"]
["SPI Section 12"]
["Surface Removal"]
["Concrete Removal and Loading (square feet)"]
["Concrete Removal and Loading >4\" (square feet)"]
["Asphalt Removal and Loading (square feet)"]
["Mixed Debris for Transport and Disposal (tons†)",null,null,null,null,null,{"$f":"ROUNDUP(((((G42*0.33)+(G43*0.166))/27)*1.5)+(((G44*0.3333)/27)*2),0)","v":0}]
["Transport and Disposal"]
["Maximum Excavation Mass @ 1.4 tons/cy (tons)",null,null,null,null,null,{"$f":"(J23+J16-G30)*1.4","v":0}]
["Contingent Transport and Disposal  (10%) (tons)",null,null,null,null,null,{"$f":"0.1*G47","v":0}]
["Maximum Transport and Disposal (tons†)",null,null,null,null,null,{"$f":"ROUNDUP(G48+G47,0)","v":0}]
["SPI Section 13"]
["Resurfacing"]
["Asphalt Paving 2\" thickness (square feet).",null,null,null,null,null,{"$f":"G44*1.1","v":0},"(calculation includes 10% contingency)"]
["Asphalt Paving additional 1\" thickness (square feet)."]
["Concrete Paving 4\" thickness (square feet)",null,null,null,null,null,{"$f":"G42*1.1","v":0},"(calculation includes 10% contingency)"]
["Concrete Paving additional 1\" thickness (square feet)"]
["Grass - Sod or Seed and Mulch (square feet)"]
["Notes:"]
[" * LDA volumes for pay items 10-9 through 10-12.b are calculated and will be paid based on auger diameter and boring depth."]
["† Values are rounded up to the next whole number."]

{"sheet":"Analytical Lookup","index":8,"n_rows":93,"n_cols":8,"rows_kept":93,"cut":false,"hidden":false,"merged":[[12,0,12,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[24,0,24,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[36,0,36,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[48,0,48,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[60,0,60,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[72,0,72,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[84,0,84,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1]]}
["Analytical Pay Items from SPI",null,null,"Drop-down Text"]
["SOIL/SEDIMENT ANALYSIS",null,null,"SOIL/SEDIMENT ANALYSIS"]
["Soil, Used Oil/Unknown Product Group-Table D of Ch. 62-780, F.A.C., except for non-Priority Pollutant Organics (multiple methods)",null,null,"Table D Used Oil"]
["Soil, BTEX + MTBE (EPA 8021 or EPA 8260)",null,null,"BTEX + MTBE"]
["Soil, Volatile Organic Halocarbons (EPA 8021 or EPA 8260)",null,null,"VOHs"]
["Soil, BTEX + MTBE + VOHs (EPA 8021 or EPA 8260)",null,null,"BTEX + MTBE + VOHs"]
["Soil, Polycyclic Aromatic Hydrocarbons (EPA 8270 or EPA 8310)",null,null,"PAHs"]
["Soil, Priority Pollutant Volatile Organics (EPA 8260)",null,null,"Priority Pollutant Volatile Organics"]
["Soil, Priority Pollutant Extractable Organics-Base Neutral and Acid Extractables (EPA 8270 list [e.g., EPA 8081/8082 + EPA 8270])",null,null,"Priority Pollutant Extractable Organics"]
["Soil, Total Recoverable Petroleum Hydrocarbons (FL-PRO)",null,null,"TRPH (FL-PRO)"]
["Soil, TRPH Fractionation (MADEP-EPH/VPH Method or TPHCWG Direct Method)",null,null,"TRPH Fractionation"]
["Soil, PCBs [or Aroclors] (EPA 8082)",null,null,"PCBs [or Aroclors]"]
["Soil, 8 RCRA Metals (EPA 6010 or EPA 6020 [Arsenic, Barium, Cadmium, Chromium, Lead, Selenium, Silver] and EPA 6020 or EPA 7471 [Mercury])",null,null,"8 RCRA Metals"]
["Soil, Arsenic (EPA 6010 or EPA 6020)",null,null,"Arsenic"]
["Soil, Cadmium (EPA 6010 or EPA 6020)",null,null,"Cadmium"]
["Soil, Chromium (EPA 6010 or EPA 6020)",null,null,"Chromium"]
["Soil, Lead (EPA 6010 or EPA 6020)",null,null,"Lead"]
["Soil, Toxicity Characteristic Leaching Procedure-Extraction Only (EPA 1311)",null,null,"TCLP-Extraction Only"]
["Soil, Synthetic Precipitation Leaching Procedure-Extraction Only (EPA1312)",null,null,"SPLP-Extraction Only"]
["Soil, Organic Carbon, Total (EPA 9060 or Walkey-Black)",null,null,"Total Organic Carbon"]
["Soil, Dry Bulk Density (ASTM D1556-07, ASTM D2167-08, ASTM D2922-01, -04, -04e, -96e1 or ASTM D2937-10)",null,null,"Dry Bulk Density"]
["Soil, Moisture Content (ASTM D2216-10)",null,null,"Moisture Content"]
["Soil, Texture, (See Gee 7 Bauder [1966])",null,null,"Soil Texture"]
["Soil, GC/MS Full Scan, Alkanes, Isoalkanes, Cycloalkanes, Aromatics, Bicyclane, Sterane, and Terpane Biomarkers (ASTM D5739 High Resolution GC/MS)",null,null,"GC/MS Full Scan"]
["Soil, Gasoline Hydrocarbon Composition, Gasoline PIANO (paraffins, isoparaffins, aromatics, naphthenes and olefins) (EPA 8260Mod, High Resolution GC/MS)",null,null,"Gasoline Hydrocarbon Composition"]
["Soil, 5 Fuel Oxygenates, MTBE, DIPE, TAME, ETBE and TBA (EPA 8260Mod, High Resolution GC/MS)",null,null,"5 Fuel Oxygenates"]
["Soil, C10-C40 Alkane Fingerprint, N-Alkanes and Isoalkanes (ASTM D3328 GC/MS)",null,null," C10-C40 Alkane Fingerprint"]
["WATER ANALYSIS",null,null,"WATER ANALYSES"]
["Water, Gasoline/Kerosene Analytical Group-Table C of Ch. 62-780, F.A.C. (multiple methods)",null,null,"GAG/KEG - Table C"]
["Water, Used Oil/Unknown Product Group-Table D of Ch. 62-780, F.A.C., except for non-Priority Pollutant Organics (multiple methods)",null,null," Used Oil/Unknown Product Group-Table D"]
["Water, BTEX + MTBE (EPA 602, EPA 624, EPA 8021 or EPA 8260)",null,null,"BTEX + MTBE"]
["Water, Volatile Organic Halocarbons, except EDB (EPA 8021 or EPA 8260)",null,null,"Volatile Organic Halocarbons"]
["Water, BTEX + MTBE + VOHs (EPA 601/602, EPA 624, EPA 6021 or EPA 8260)",null,null," BTEX + MTBE + VOHs"]
["Water, Polycyclic Aromatic Hydrocarbons, including 1-methylnaphthalene + 2-methylnaphthalene (EPA 610 [HPLC], EPA 625, EPA 8270 or EPA 8310)",null,null," Polycyclic Aromatic Hydrocarbons"]
["Water, EDB [1,2-dibromoethane or ethylene dibromide] (EPA 504.1 or EPA 8011)",null,null," EDB (via 504.1 or 8011)"]
["Water, EDB [1,2-dibromoethane or ethylene dibromide] (EPA 8260 SIM)",null,null,"EDB (via 8260)"]
["Water, Priority Pollutant Volatile Organics [for NPDES purposes only] (EPA 624)",null,null,"Priority Pollutant Volatile Organics [for NPDES purposes only] (EPA 624)"]
["Water, Priority Pollutant Volatile Organics (EPA 8260)",null,null,"Priority Pollutant Volatile Organics (EPA 8260)"]
["Water, Priority Pollutant Extractable Organics-Base Neutral and Acid Extractables [for NPDES purposes only] (EPA 625 list [e.g., EPA 608 + EPA 625])",null,null,"Priority Pollutant Extractable Organics (EPA 625 list)"]
["Water, Priority Pollutant Extractable Organics-Base Neutral and Acid Extractables (EPA 8270 list [e.g., EPA 8081/8082 + EPA 8270 or EPA 608 + EPA 8270)",null,null,"Priority Pollutant Extractable Organics (EPA 8270 list)"]
["Water, Total Recoverable Petroleum Hydrocarbons (FL-PRO)",null,null,"TRPH (FL-PRO)"]
["Water, PCBs [or Aroclors] (EPA 608 or EPA 8082)",null,null,"PCBs"]
["Water, Arsenic, Total (EPA 200.7, EPA 200.8, EPA 6010 or EPA 6020)",null,null,"Arsenic, Total"]
["Water, Cadmium, Total (EPA 200.7, EPA 200.8, EPA 6010 or EPA 6020)",null,null,"Cadmium, Total"]
["Water, Chromium, Total (EPA 200.7, EPA 200.8, EPA 6010 or EPA 6020)",null,null,"Chromium, Total"]
["Water, Lead, Total (EPA 200.7, EPA 200.8, EPA 6010 or EPA 6020)",null,null,"Lead, Total"]
["Water, Dissolved Lead (includes filter appropriate to sample method - EPA 200.7, 200.9, 6010B, or 7380)",null,null,"Dissolved Lead"]
["Water, Mercury, Total (EPA 245.1, EPA 6020 or EPA 7470)",null,null,"Mercury, Total"]
["Water, Calcium, Total (EPA 200.7, EPA 6010 or EPA 6020)",null,null," Calcium, Total"]
["Water, Iron, Total (EPA 200.7, EPA 6010 or EPA 6020)",null,null,"Iron, Total"]
["Water, Dissolved Iron (includes filter appropriate to sample method - EPA 200.7, 200.9, 6010B, or 7380)",null,null," Dissolved Iron"]
["Water, Magnesium, Total (EPA 200.7, EPA 6010 or EPA 6020)",null,null,"Magnesium, Total"]
["Water, Manganese, Total (EPA 200.7, EPA 200.8, EPA 6010 or EPA 6020)",null,null,"Manganese, Total"]
["Water, Potassium, Total (EPA 200.7, EPA 6010 or EPA 6020)",null,null,"Potassium, Total"]
["Water, Sodium, Total (EPA 200.7, EPA 6010 or EPA 6020)",null,null,"Sodium, Total"]
["Water, Alkalinity [as CaCO3] (EPA 310.2 or SM 2320 B)",null,null,"Alkalinity [as CaCO3]"]
["Water, Ammonia [as N] (EPA 350.1, SM 4500-NH3 C, SM 4500-NH3 D, SM 4500-NH3 G or SM 4500-NH3 H)",null,null,"Ammonia [as N]"]
["Water, Chloride (EPA 300.0, EPA 9056, EPA 9251, EPA 9053, SM 4500CI B, SM 4500CI C or SM 4500CI E)",null,null,"Chloride"]
["Water, Hardness, Total [as CaCO3] (SM 2340 B or SM 2340 C)",null,null,"Hardness, Total [as CaCO3]"]
["Water, Nitrate [as N] (EPA 300.0 or EPA 353.2)",null,null,"Nitrate [as N]"]
["Water, Nitrate-Nitrite [as N] (EPA 300.0, EPA 353.2, SM 4500-NO3 E or SM 4500-NO3 F)",null,null,"Nitrate-Nitrite [as N]"]
["Water, Nitrite [as N] (EPA 300.0, EPA 300.1, SM 4500-NO2 B or SM 4500-NO3 F)",null,null,"Nitrite [as N]"]
["Water, Organic Carbon, Total (SM 5310 B, SM 5310 C or EPA 9060)",null,null,"Organic Carbon, Total"]
["Water, Orthophosphate [as P] (EPA 300.0, EPA 300.1, EPA 365.1, EPA 365.3, EPA 9056, SM 4500-PE or SM 4500-PF)",null,null,"Orthophosphate [as P]"]
["Water, Residue-filterable [Total Dissolved Solids] (SM 2540 C)",null,null,"Total Dissolved Solids"]
["Water, Residue-nonfilterable [Total Suspended Solids] (SM 2540 D)",null,null,"Total Suspended Solids"]
["Water, Sulfate (ASTM D516-02, ASTM D516-90, EPA 300.0, EPA 300.1, EPA 375.2, EPA 9038, EPA 9056 or SM 4500-SO4 C)",null,null," Sulfate"]
["Water, Heterotrophic Plate Count (SM 9215 B)",null,null,"Heterotrophic Plate Count"]
["Water, Acute Bioassay-96 Hour, Freshwater, Vertebrate/Invertebrate [Vertebrate: Pimephales promelas or Cyprinella leedsi/Invertebrate: Ceriodaphnia dubia] (EPA 2000.0/2002.0)",null,null,"Freashwater - Acute Bioassay-96 Hour"]
["Water, Acute Bioassay-96 Hour, Estuarine + Marine, Vertebrate/Invertebrate [Vertebrate: Menidia beryllina, Meridia menidia or Menida peninsulae/Invertebrate: Mysidopsis bahia] (EPA 2006.0/2007.0)",null,null,"Estuarine + Marine - Acute Bioassay-96 Hour"]
["Water, GC/MS Full Scan, Alkanes, Isoalkanes, Cycloalkanes, Aromatics, Bicyclane, Sterane, and Terpane Biomarkers (ASTM D5739 High Resolution GC/MS)",null,null,"GC/MS Full Scan"]
["Water, Gasoline Hydrocarbon Composition, Gasoline PIANO [paraffins, isoparaffins, aromatics, naphthenes and olefins] (EPA 8260Mod, High Resolution GC/MS)",null,null,"Gasoline Hydrocarbon Composition"]
["Water, 5 Fuel Oxygenates, MTBE, DIPE, TAME, ETBE and TBA (EPA 8260Mod, High Resolution GC/MS)",null,null,"5 Fuel Oxygenates"]
["Water, C10-C40 Alkane Fingerprint, N-Alkanes and Isoalkanes (ASTM D3328 GC/MS)",null,null,"C10-C40 Alkane Fingerprint"]
["Water, BTEX/MTBE + Naphthalene (EPA 8260)",null,null,"BTEX/MTBE + Naphthalene"]
["Water, EDC [1,2-dichloroethane] (EPA Method 8021 or 8260)",null,null,"EDC"]
["Water, Methane (EPA SOP RSK-175)",null,null,"Methane"]
["AIR ANALYSIS",null,null,"AIR ANALYSES"]
["Air, Total Petroleum Hydrocarbons (EPA Method 18 or TO-3)",null,null,"Total Petroleum Hydrocarbons (TO-3)"]
["Air, Volatile Organic Aromatics (EPA Method TO-15)",null,null,"Volatile Organic Aromatics (TO-15)"]
["Air, Polycyclic Aromatic Hydrocarbons (EPA Method TO-13)",null,null,"Polycyclic Aromatic Hydrocarbons (TO-13)"]
["Air, Volatile Organic Compounds (EPA Method TO-17)",null,null,"Volatile Organic Compounds (TO-17)"]
["PRODUCT ANALYSIS",null,null,"PRODUCT ANALYSIS"]
["Product, C3-C44 Hydrocarbon Fingerprint, Gasoline PIANO [paraffins, isoparaffins, aromatics, naphthenes and olefins], alkanes and isoalkanes (ASTM D3328 High Resolution GC/FID)",null,null,"Product, C3-C44 Hydrocarbon Fingerprint"]
["Product, GC/MS Full Scan, alkanes, isoalkanes, cycloalkanes, aromatics, bicyclane, sterane, and terpane biomarkers (ASTM D5739 High Resolution GC/MS)",null,null,"Product, GC/MS Full Scan"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Use drop-down list to select analyses or type directly in cell."]

{"sheet":"Sheet2","index":9,"n_rows":67,"n_cols":23,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Boringtype",null,"Completiontype",null,1,null,"Frequency3",null,"GroundwaterTreatment",null,"Process",null,"System",null,"Treatment2",null,"Size2",null,"Usage",null,"Material",null,"Turnaround"]
["Hand Auger",null,"8\" MH",null,2,null,"Once",null,"On-site Treatment",null,"AS",null,"AS",null,"Carbon",null,"Small",null,"<=6 months",null,"SCH 40",null,"1-day TA"]
["DPT",null,"12\" MH",null,3,null,"Daily",null,"Sanitary",null,"SVE",null,"AS/SVE",null,"Thermox",null,"Medium",null,">6 months",null,"SCH 80",null,"3-day TA"]
["HSA/MR",null,"2x2 Vault",null,4,null,"Weekly",null,"Off-site Disposal",null,"MPX",null,"AS/MPX",null,"Catox",null,"Large",null,null,null,"HDPE",null,"7-day TA"]
["Sonic",null,"4x4 Vault",null,5,null,"Monthly",null,null,null,"GWT",null,"MPX"]
[null,null,"Above Ground",null,6,null,"Quarterly",null,null,null,"Injection",null,"GWT"]
[null,null,"None",null,7,null,"Semi-Annually"]
[null,null,null,null,8,null,"Annually"]
[null,null,null,null,9]
[null,null,null,null,10]
[]
[]
[]
[]
["SOILAIR4",null,null,null,null,"WATER",null,null,null,null,null,null,"Duration",null,"WellType",null,"Install",null,"Grass",null,"Dewatering"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Days",null,"HW",null,"DPT",null,"Sod",null,"On-site"]
["Table D Used Oil",null,null,null,null,"GAG/KEG - Table C",null,null,null,null,null,null,"Week(s)",null,"VW",null,"HSA",null,"Seed & Mulch",null,"Off-site"]
["BTEX + MTBE",null,null,null,null,"Used Oil/Unknown Product Group-Table D",null,null,null,null,null,null,"Month(s)",null,"AW",null,"MR"]
["VOHs",null,null,null,null,"BTEX + MTBE",null,null,null,null,null,null,null,null,null,null,"Sonic"]
["BTEX + MTBE + VOHs",null,null,null,null,"VOHs",null,null,null,null,null,null,null,null,null,null,"Open Trench"]
["PAHs",null,null,null,null,"BTEX + MTBE + VOHs"]
["Priority Pollutant Volatile Organics",null,null,null,null,"PAHs"]
["Priority Pollutant Extractable Organics",null,null,null,null,"EDB (via 504.1 or 8011)"]
["TRPH (FL-PRO)",null,null,null,null,"EDB (via 8260)",null,null,null,null,null,null,"WellType2",null,null,"SubPhase2"]
["TRPH Fractionation",null,null,null,null,"Priority Pollutant Volatile Organics [for NPDES purposes only] (EPA 624)",null,null,null,null,null,null,null,null,null,"LSA"]
["PCBs [or Aroclors]",null,null,null,null,"Priority Pollutant Volatile Organics (EPA 8260)",null,null,null,null,null,null,"MW",null,null,"LSSI"]
["8 RCRA Metals",null,null,null,null,"Priority Pollutant Extractable Organics (EPA 625 list)",null,null,null,null,null,null,"IW",null,null,"NAM"]
["Arsenic",null,null,null,null,"Priority Pollutant Extractable Organics (EPA 8270 list)",null,null,null,null,null,null,"DW",null,null,"O&M"]
["Cadmium",null,null,null,null,"TRPH (FL-PRO)",null,null,null,null,null,null,"SVE",null,null,"PARM"]
["Chromium",null,null,null,null,"PCBs",null,null,null,null,null,null,"AS",null,null,"PT"]
["Lead",null,null,null,null,"Arsenic, Total",null,null,null,null,null,null,"MPX",null,null,"RAC"]
["TCLP-Extraction Only",null,null,null,null,"Cadmium, Total",null,null,null,null,null,null,"INJ",null,null,"RAP"]
["SPLP-Extraction Only",null,null,null,null,"Chromium, Total",null,null,null,null,null,null,"OW",null,null,"SA"]
["Total Organic Carbon",null,null,null,null,"Lead, Total",null,null,null,null,null,null,null,null,null,"SR"]
["Dry Bulk Density",null,null,null,null,"Dissolved Lead",null,null,null,null,null,null,null,null,null,"WASC"]
["Moisture Content",null,null,null,null,"Mercury, Total"]
["Soil Texture",null,null,null,null,"Calcium, Total"]
["GC/MS Full Scan",null,null,null,null,"Iron, Total"]
["Gasoline Hydrocarbon Composition",null,null,null,null,"Dissolved Iron"]
["5 Fuel Oxygenates",null,null,null,null,"Magnesium, Total"]
["C10-C40 Alkane Fingerprint",null,null,null,null,"Manganese, Total"]
["Air-Total Petroleum Hydrocarbons (TO-3)",null,null,null,null,"Potassium, Total"]
["Air-Volatile Organic Aromatics (TO-15)",null,null,null,null,"Sodium, Total"]
["Air-Polycyclic Aromatic Hydrocarbons (TO-13)",null,null,null,null,"Alkalinity [as CaCO3]"]
["Air-Volatile Organic Compounds (TO-17)",null,null,null,null,"Ammonia [as N]"]
["Encore Sampler",null,null,null,null,"Chloride"]
[null,null,null,null,null,"Hardness, Total [as CaCO3]"]
[null,null,null,null,null,"Nitrate [as N]"]
[null,null,null,null,null,"Nitrate-Nitrite [as N]"]
[null,null,null,null,null,"Nitrite [as N]"]
[null,null,null,null,null,"Organic Carbon, Total"]
[null,null,null,null,null,"Orthophosphate [as P]"]
[null,null,null,null,null,"Total Dissolved Solids"]
[null,null,null,null,null,"Total Suspended Solids"]
[null,null,null,null,null,"Sulfate"]
[null,null,null,null,null,"Heterotrophic Plate Count"]
[null,null,null,null,null,"Freashwater - Acute Bioassay-96 Hour"]
[null,null,null,null,null,"Estuarine + Marine - Acute Bioassay-96 Hour"]
[null,null,null,null,null,"GC/MS Full Scan"]
[null,null,null,null,null,"Gasoline Hydrocarbon Composition"]
[null,null,null,null,null,"5 Fuel Oxygenates"]
[null,null,null,null,null,"C10-C40 Alkane Fingerprint"]
[null,null,null,null,null,"Product, C3-C44 Hydrocarbon Fingerprint"]
[null,null,null,null,null,"Product, GC/MS Full Scan"]
[null,null,null,null,null,"BTEX/MTBE + Naphthalene"]
[null,null,null,null,null,"EDC"]
[null,null,null,null,null,"Methane"]

{"sheet":"Sheet1","index":10,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Daily"]
["Weekly"]
["Monthly"]
["Quarterly"]
["Semi-Annually"]
["Annually"]