{"text_format":"1","workbook":"xlsx","n_sheets":38,"sheets":["Title","Main-Menu","Cover","Toc","Form-1","Form-1a","Form-1b-(1)","Form-1b-(2)","Form-2","Form-3","Form-4","Form-5-(1)","Form-5-(2)","Form-5-(3)","Form-5-(4)","Form-5-(5)","Form-6a-(1)","Form-6a-(2)","Form-6a-(3)","Form-6a-(4)","Form-6a-(5)","Form-6a-(6)","Form-6b-(1)","Form-6b-(2)","Form-6b-(3)","Form-6b-(4)","Form-6b-(5)","Form-7-(1)","Form-7-(2)","Form-7-(3)","Form-7-(4)","Form-8-(1)","Form-8-(2)","Form-8-(3)","Print2","Module1","Module2","Module3"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":198,"comments":10,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":35,"reason":"part_missing"},{"sheet":"Module2","index":36,"reason":"part_missing"},{"sheet":"Module3","index":37,"reason":"part_missing"}],"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":"Title","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Main-Menu","index":1,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"(Version 5.0, revised July 2025)"]

{"sheet":"Cover","index":2,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,3,16,4],[10,2,10,5],[12,3,12,4],[13,3,13,4],[14,3,14,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"RBCA Tier 2 Site Investigation"]
[null,null,null,"Report Forms for Petroleum"]
[null,null,null,"Release Sites"]
[]
[null,null,null,"(For Use by Consultants)"]
[]
[]
[]
[null,null,null,"FACILITY NAME:"]
[null,null,null,"LOCATION:"]
[null,null,null,"DWEE PROGRAM NO.:"]
[null,null,null,"DWEE FACILITY NO.:"]
[null,null,null,"CONSULTANT PROJECT NO.:"]
[null,null,null,"CONSULTANT:"]
[null,null,null,"COMPLETION DATE:"]
[null,null,null,"PREPARED BY:"]
[null,null,null,"REVIEWED BY:"]

{"sheet":"Toc","index":3,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":false,"merged":[[34,3,34,4],[18,3,18,4],[19,5,19,6],[2,2,2,6],[3,2,3,6],[17,2,17,6],[5,2,5,6],[4,5,4,6],[2,9,12,12],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4]]}
[]
[]
[null,null,"DWEE RBCA TIER 2 REPORT FORMS",null,null,null,null,null,null,"Use the checkboxes to display the forms you want to fill out. Once the forms are displayed, you can use the NEXT and PREVIOUS buttons to move through them, or click on a tab to go directly to a specific form."]
[null,null,"TABLE OF CONTENTS"]
[null,null,"Form No.","Description",null,"Check box if included"]
[null,null,"FORMS FOR USE BY RP/CONSULTANT"]
[null,null,"1.","Basic Information:","1.  Executive Summary",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,"1a.  Consultant and Licensing",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,"1b.  GPS Locations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"2.","Instructions for Tier 2 Investigation Narrative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"3.","Site Stratigraphy and Hydrogeology",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"4.","Site-Specific Vadose Zone Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"5.","Subsurface Soil (>3 ft bgl) Analytical Data Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"6.","Ground Water:","6a.  Analytical Data Summary",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,"6b.  QA/QC Sample Data Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"7.","Soil Gas Analytical Data Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"8.","References and Protocols",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"ATTACHMENTS"]
[null,null,null,"All maps submitted must include a bar scale, legend, north arrow, location of all known soil boring and monitoring wells, and date of map, where appropriate."]
[null,null,"Attachment No.","Description",null,"Check box if included"]
[null,null,"1.","Area Map"]
[null,null,"2.","Site Map"]
[null,null,"3.","Contaminant Plume Maps"]
[null,null,"4.","Free Product Map"]
[null,null,"5.","Boring Logs"]
[null,null,"6.","Monitoring Well Schematics"]
[null,null,"7.","Laboratory Analysis Sheets and Chain-of-Custody Sheets"]
[null,null,"8.","Geologic cross-sections"]
[null,null,"9.","Well Survey Documentation"]
[null,null,null,"OTHER ATTACHMENTS:"]

{"sheet":"Form-1","index":4,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":true,"merged":[[43,3,43,9],[26,4,26,5],[28,4,28,5],[30,4,30,5],[40,2,40,3],[40,6,40,9],[42,1,42,10],[31,4,31,5],[29,4,29,5],[24,7,24,9],[23,7,23,9],[35,2,39,9],[27,4,27,5],[34,1,34,10],[25,7,25,9],[9,1,9,10],[22,7,22,9],[11,4,11,9],[13,4,13,9],[14,4,14,9],[12,4,12,9]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 1  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"EXECUTIVE SUMMARY"]
[]
[null,"Facility or file name:"]
[null,"Current facility name (if different from above):"]
[null,"Facility address or site location:"]
[]
[null,"Status of fuel storage/distribution:",null,null,null,"Active",null,"Inactive",null,"NA"]
[null,"Was surface soil remediated after the Tier 1 investigation?",null,null,null,"Yes",null,"No"]
[null,"This Tier 2 investigation pertains to:"]
[null,null,null,"Ground Water Ingestion Pathway",null,"Yes",null,"No"]
[null,null,null,"Soil Leaching to Ground Water Pathway",null,"Yes",null,"No"]
[null,null,null,"Enclosed Space Inhalation from Soils Pathway",null,"Yes",null,"No"]
[null,null,null,"Enclosed Space Inhalation from Gound Water Pathway",null,"Yes",null,"No"]
[null,"Was free product detected during the Tier 1 investigation?",null,null,null,"Yes","No"]
[null,"If yes, was the free product removed prior to Tier 2 investigation?",null,null,null,"Yes","No"]
[null,"Were vapors detected in any utilities?",null,null,null,"Yes","No"]
[null,"Has surface water been impacted by the release?",null,null,null,"Yes","No"]
[null,"Average depth of contamination in subsurface soils:",null,null,null,null,"ft",{"$f":"IF(E27=\"\",\"               cm\",(E27*30.48) & \"    cm\")","v":"               cm"},null,"NA"]
[null,"Shallowest depth to ground water:",null,null,null,null,"ft","Not measured","NA"]
[null,"Average depth to ground water:",null,null,null,null,"ft","Not measured","NA"]
[null,"Distance to nearest drinking water supply well:",null,null,null,null,"ft",null,"NA"]
[null,"Distance to nearest non-potable water supply well:",null,null,null,null,"ft",null,"NA"]
[null,"Distance to nearest downgradient water supply well:",null,null,null,null,"ft",null,"NA"]
[null,"Is there evidence of vertical migration of the contaminant plume?",null,null,null,"Yes","No           ",null,"NA"]
[]
[null,"Statement of Completion & Responsible Party/Consultant Signature Block"]
[null,null,"The consultant representative acknowledges that this report meets the minimum requirements for a Tier 2 investigation at this petroleum release site, as specified in the Department's Risk-Based Corrective Action (RBCA) at Petroleum Release Sites: Tier 1/Tier 2 Assessments and Reports Guidance Document. Any procedures that differ from the guidance document specifications are noted in the report, were approved by the Department and are accompanied by appropriate documentation. The responsible party acknowledges that they have read (or discussed with their consultant), this site investigation report and are aware of their responsibility for the timely submission to the Department."]
[]
[]
[]
[]
[]
[null,null,"Consultant Representative Signature                                       Date",null,null,null,"Responsible Party Signature                           Date"]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  None."]

{"sheet":"Form-1a","index":5,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[32,4,32,6],[17,3,17,7],[20,4,20,6],[21,4,21,6],[39,2,39,7],[33,4,33,6],[34,4,34,6],[35,4,35,6],[36,4,36,6],[11,3,11,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[12,3,12,7],[16,3,16,7],[25,4,25,6],[31,4,31,6],[21,2,31,2],[22,4,22,6],[23,4,23,6],[24,4,24,6]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,"Tier 2 Investigation Form - 1a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"CONSULTANT AND LICENSING  INFORMATION"]
[]
[null,null,"Consulting Firm:"]
[null,null,"Consulting Firm mailing address:"]
[]
[null,null,"Consulting Firm Project Manager:"]
[null,null,"Consultant phone numbers:"]
[]
[]
[]
[null,null,"Nebraska Department of Water, Energy, and Environment Water Well Licenses"]
[null,null,null,"License No.","License Type",null,null,"Personnel/Subcontractor Name"]
[null,null,"List all personnel and subcontractors involved in installing or sampling wells during this investigation."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ADDITIONAL NOTES"]

{"sheet":"Form-1b-(1)","index":6,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":true,"merged":[[30,5,30,7],[30,10,30,13],[23,10,23,13],[24,5,24,7],[28,5,28,7],[28,10,28,13],[29,5,29,7],[29,10,29,13],[44,2,44,13],[35,9,35,12],[36,9,36,12],[38,4,38,5],[38,9,38,12],[39,4,39,5],[39,9,39,12],[40,4,40,5],[40,9,40,12],[13,2,13,3],[12,2,12,3],[11,2,11,4],[12,12,12,13],[17,5,17,7],[17,10,17,13],[34,5,34,7],[34,9,34,12],[35,5,35,7],[36,5,36,7],[11,5,11,13],[18,5,18,7],[18,10,18,13],[19,5,19,7],[19,10,19,13],[20,5,20,7],[20,10,20,13],[21,5,21,7],[21,10,21,13],[22,5,22,7],[22,10,22,13],[23,5,23,7]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 1b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"GPS LOCATIONS"]
[]
[null,null,"GPS Manufacturer & Model:"]
[null,null,"Reference Datum:"]
[null,null,"WAAS Status:"]
[]
[null,null,"Source Area Locations:"]
[null,null,"Take readings as near as possible to the point of highest contamination in each identified source area."]
[null,null,null,"Latitude","Longitude","Accuracy",null,null,"(ft)","(m)","Point Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"General Facility Locations:"]
[null,null,"Preferred locations are the intersection of the facility driveway and closest public street and/or  the facility office entrance."]
[null,null,null,"Latitude","Longitude","Accuracy",null,null,"(ft)","(m)","Point Description"]
[]
[]
[]
[null,null,"Coordinate Converters"]
[null,null,null,"These are provided for your convenience.  Enter only readings in decimal degrees in the tables above."]
[null,null,null,"Degrees","Minutes","Seconds",null,null,null,"Decimal Degrees"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D36<0,-D36+(E36/60)+(F36/3600),IF(D36>0,D36+(E36/60)+(F36/3600),\"- - - - -\"))","v":"- - - - -"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D37<0,-D37+(E37/60)+(F37/3600),IF(D37>0,D37+(E37/60)+(F37/3600),\"- - - - -\"))","v":"- - - - -"}]
[]
[null,null,null,"Degrees","Decimal Minutes",null,null,null,null,"Decimal Degrees"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D40<0,-D40+(E40/60),IF(D40>0,D40+(E40/60),\"- - - - -\"))","v":"- - - - -"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D41<0,-D41+(E41/60),IF(D41>0,D41+(E41/60),\"- - - - -\"))","v":"- - - - -"}]
[]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Show GPS reading locations on Site Map."]

{"sheet":"Form-1b-(2)","index":7,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":true,"merged":[[33,5,33,7],[33,9,33,12],[19,5,19,7],[19,10,19,13],[11,5,11,13],[13,2,13,3],[12,2,12,3],[11,2,11,4],[12,12,12,13],[43,2,43,13],[34,9,34,12],[35,9,35,12],[37,4,37,5],[37,9,37,12],[38,4,38,5],[38,9,38,12],[39,4,39,5],[39,9,39,12],[34,5,34,7],[35,5,35,7],[20,5,20,7],[20,10,20,13],[17,5,17,7],[17,10,17,13],[18,5,18,7],[18,10,18,13],[21,5,21,7],[21,10,21,13],[25,5,25,7],[25,10,25,13],[22,5,22,7],[23,5,23,7],[24,5,24,7],[29,5,29,7],[29,10,29,13],[26,5,26,7],[26,10,26,13],[27,5,27,7],[28,5,28,7],[28,10,28,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 1b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"GPS LOCATIONS"]
[]
[null,null,"GPS Manufacturer & Model:"]
[null,null,"Reference Datum:"]
[null,null,"WAAS Status:"]
[]
[null,null,"Monitoring Well Locations (Optional):"]
[null,null,"The use of GPS units with sub-meter accuracy is recommended for determining monitoring well locations."]
[null,null,null,"Latitude","Longitude","Accuracy",null,null,"(ft)","(m)","Point Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Coordinate Converters"]
[null,null,null,"These are provided for your convenience.  Enter only readings in decimal degrees in the tables above."]
[null,null,null,"Degrees","Minutes","Seconds",null,null,null,"Decimal Degrees"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D35<0,-D35+(E35/60)+(F35/3600),IF(D35>0,D35+(E35/60)+(F35/3600),\"- - - - -\"))","v":"- - - - -"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D36<0,-D36+(E36/60)+(F36/3600),IF(D36>0,D36+(E36/60)+(F36/3600),\"- - - - -\"))","v":"- - - - -"}]
[]
[null,null,null,"Degrees","Decimal Minutes",null,null,null,null,"Decimal Degrees"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D39<0,-D39+(E39/60),IF(D39>0,D39+(E39/60),\"- - - - -\"))","v":"- - - - -"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D40<0,-D40+(E40/60),IF(D40>0,D40+(E40/60),\"- - - - -\"))","v":"- - - - -"}]
[]
[]
[null,"ADDITIONAL NOTES"]

{"sheet":"Form-2","index":8,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[[9,1,9,10],[11,2,11,10],[28,4,28,10]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 2  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\"))","v":"COMPLETION DATE:  00-Jan-00"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"INSTRUCTIONS FOR INVESTIGATION NARRATIVE"]
[]
[null,"Note:","The reporter may use a format of their choosing for the following narrative information, with the provision that all the minimum information requirements listed below, as it pertains to the exposure pathways investigated, are provided under the following headings and in the order outlined.  Place the narrative behind a copy of this investigation form in the Tier 1 report."]
[null,"I.","Brief history of any abatement/remedial actions taken prior to initiating the Tier 2 investigation"]
[null,"II.","Summary of site characteristics"]
[null,null,"A.","Site Location"]
[null,null,"B.","General site topography, geology, and hydrogeology"]
[null,"III.","Summary of drilling activities"]
[null,null,"A.","Date/method/equipment"]
[null,null,"B.","Drilling order of boreholes"]
[null,null,"C.","Drilling complications (e.g., auger failure or refusal, site recently modified), if any"]
[null,null,"D.","Description of materials drilled through and evidence of contamination"]
[null,null,"E.","Monitoring well installation"]
[null,null,null,"-","depth of wells",null,"-","filter pack and grout materials"]
[null,null,null,"-","screened interval",null,"-","type of well head protection"]
[null,null,null,"-","well development methodology, duration, estimated water removed"]
[null,null,null,"-","other information"]
[null,null,"F.","Monitoring well location information"]
[null,null,null,"-","nature & location of permanent benchmark to which wells are referenced (designate on site map)"]
[null,null,null,"-","method (e.g., stadia, measuring wheel, tape) and measurements (in tabular format) used to reference wells to benchmark"]
[null,null,"G.","Other information related to drilling activities (e.g., start/stop times for drilling & well installation)"]
[null,"IV.","Direct push technologies"]
[null,null,"A.","Date/method/equipment"]
[null,null,"B.","Order of probe locations"]
[null,null,"C.","Description of materials drilled through and evidence of contamination"]
[null,null,"D.","Other information related to direct push activities (e.g., start/stop times, media investigated)"]
[null,"V.","Summary of sampling activities"]
[null,null,"A.","Soil sampling"]
[null,null,null,"-","method of sample collection"]
[null,null,null,"-","method/protocol used for head space analysis"]
[null,null,null,"-","method/protocol used for laboratory sample preparation"]
[null,null,"B.","Ground water sampling"]
[null,null,null,"-","purging method/protocol/criteria (includes rationale for not purging, if applicable)"]
[null,null,null,"-","sample collection method/protocol"]
[null,null,null,"-","order of well sampling (Note: sample least contaminated to most contaminated)"]
[null,null,"C.","Drinking water supply well/system sampling"]
[null,null,null,"-","location of sampling point (e.g., directly from well, outdoor tap, indoor tap)"]
[null,null,null,"-","purging method/protocol/criteria"]
[null,null,null,"-","sample collection method/protocol"]
[null,null,"D.","Soil vapor sampling"]
[null,null,null,"-","sample point installation (e.g., probe rod, vapor monitoring well)"]
[null,null,null,"-","purging method/protocol/criteria"]
[null,null,null,"-","sample collection method/protocol"]
[null,null,"E.","QA/QC considerations"]
[null,null,null,"-","steps taken to limit cross-contamination between sampling locations"]
[null,null,null,"-","number/type/location of duplicates/blanks"]
[null,null,null,"-","decontamination protocol and other measures taken to minimize cross-contamination"]
[null,"VI.","Other information"]
[null,null,"A.","Rationale for variances from approved work plan or RBCA guidance document"]
[null,null,"B.","Contact information (i.e., names, phone numbers, affiliations) for people providing information "]
[null,null,null,"gathered during investigation"]

{"sheet":"Form-3","index":9,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[[13,10,13,14],[14,10,14,14],[15,10,15,14],[16,10,16,14],[13,2,13,3],[14,2,14,3],[13,5,13,8],[14,5,14,8],[41,2,41,14],[15,5,15,8],[26,2,26,3],[24,5,24,14],[25,5,25,14],[16,2,16,3],[27,2,27,3],[15,2,15,3],[16,5,16,8],[17,10,17,14],[36,6,36,8],[36,11,36,14],[17,5,17,8],[18,2,18,3],[23,2,23,3],[25,2,25,3],[35,6,35,8],[17,2,17,3],[23,5,23,14],[34,6,34,8],[24,2,24,3],[37,6,37,8],[18,5,18,8],[38,6,38,8],[27,5,27,14],[18,10,18,14],[19,5,19,14],[38,12,38,13],[32,6,32,8],[32,11,32,14],[33,6,33,8],[35,11,35,14],[26,5,26,14]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 3  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"SITE STRATIGRAPHY AND HYDROGEOLOGY (Based on Tier 2 investigation)"]
[]
[null,"STRATIGRAPHY OF THE SITE"]
[null,null,"Depth [feet]",null,null,"Unified Soil Classification",null,null,null,null,"Type of Soil"]
[]
[]
[]
[]
[]
[]
[null,null,"Predominant soil type:"]
[]
[null,null,"Depth",null,null,"Type of Bedrock & Geological Formation (where applicable)"]
[null,null,"[feet]",null,null,"(discuss rock properties and features, e.g. fractures)"]
[]
[]
[]
[]
[]
[]
[null,"HYDROGEOLOGY OF THE IMPACTED SATURATED ZONE"]
[]
[null,null,"Type of aquifer? (Justify under \"Additional Notes\")",null,null,null,null,"Confined",null,null,"Unconfined",null,"Perched"]
[null,null,"Range of ground water fluctuation, (if known):",null,null,null,null,null,null,"ft","Source:"]
[null,null,"Average depth to water table/static water level:",null,null,null,null,null,null,"ft"]
[null,null,"Flow direction:"]
[null,null,"Hydraulic gradient (i):",null,null,null,null,null,null,"ft/ft     MWs used:"]
[null,null,"Hydraulic conductivity (K):",null,null,null,null,null,null,"ft/day           for:"]
[null,null,"Porosity (n):"]
[null,null,"Seepage velocity (K x i/n) [calculated]:",null,null,null,{"$f":"IF(OR(i=\"\",K=\"\",n=\"\"),\"\",K*i/n)","v":""},null,null,"ft/day",null,null,{"$f":"IF(G39=\"\",\"\",G39*365*2.54*12)","v":""},null,"cm/year"]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Relevant cross-sections, soil boring logs, and laboratory/field sheets providing vadose zone characteristics."]

{"sheet":"Form-4","index":10,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[[36,12,36,14],[37,12,37,14],[38,12,38,14],[36,2,36,3],[37,2,37,3],[38,2,38,3],[36,7,36,10],[37,7,37,10],[38,7,38,10],[31,2,31,3],[30,7,30,10],[31,7,31,10],[34,7,34,10],[35,12,35,14],[31,12,31,14],[28,2,28,3],[28,12,28,14],[28,7,28,10],[29,7,29,10],[34,2,34,3],[35,7,35,10],[12,2,12,3],[12,7,12,10],[12,12,12,14],[13,2,13,3],[13,7,13,10],[13,12,13,14],[14,2,14,3],[14,7,14,10],[14,12,14,14],[15,2,15,3],[15,7,15,10],[15,12,15,14],[20,2,20,3],[20,7,20,10],[21,2,21,3],[21,7,21,10],[16,2,16,3],[16,7,16,10],[19,1,19,15],[16,12,16,14],[41,2,41,14],[22,2,22,3],[23,2,23,3],[24,2,24,3],[22,7,22,10],[23,7,23,10],[24,7,24,10],[27,2,27,3],[27,7,27,10],[27,12,27,14],[34,12,34,14],[29,2,29,3],[30,2,30,3],[29,12,29,14],[30,12,30,14],[35,2,35,3]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 4  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"SITE-SPECIFIC VADOSE ZONE PARAMETERS (Based on Tier 2 investigation)"]
[]
[null,"DRY BULK DENSITY"]
[null,null,"Unit Interval [ft bgl]",null,null,"Sediment Type",null,"Value [g/cm3]",null,null,null,null,"ASTM Test Method"]
[]
[]
[]
[]
[]
[null,"POROSITY"]
[null,"NOTE:  Values for porosity may be estimated using Table 6-2 of the DWEE RBCA Guidance Document."]
[null,null,"Unit Interval [ft bgl]",null,null,"Sediment Type",null,"Value [cm3/cm3]"]
[]
[]
[]
[]
[]
[null,"VOLUMETRIC WATER CONTENT"]
[null,null,"Unit Interval [ft bgl]",null,null,"Sediment Type",null,"Value [cm3/cm3]",null,null,null,null,"ASTM Test Method"]
[]
[]
[]
[]
[]
[null,"FRACTIONAL ORGANIC CARBON CONTENT"]
[null,null,"Unit Interval (ft bgl)",null,null,"Sediment Type",null,"Value [g-C/g-soil]",null,null,null,null,"ASTM Test Method"]
[]
[]
[]
[]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Relevant cross-sections, soil boring logs, and laboratory/field sheets providing vadose zone characteristics."]

{"sheet":"Form-5-(1)","index":11,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[8,1,8,18],[30,1,30,2],[7,1,7,18],[10,18,12,18],[10,9,10,11],[11,9,11,11],[10,12,10,14],[11,12,11,14],[10,16,12,16],[10,17,12,17],[10,3,10,5],[10,6,10,8],[31,1,31,2],[32,1,32,2],[11,3,11,5],[11,6,11,8],[29,1,29,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 5  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Based on Tier 2 investigation; soil sample depth greater than 3 feet bgl.   All concentrations in mg/kg)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"MW / SB No. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of      ","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Detection (s)"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D15:O15,'Form-5-(2)'!D15:O15,'Form-5-(3)'!D15:O15,'Form-5-(4)'!D15:O15,'Form-5-(5)'!D15:O15)=0,\"\",COUNT('Form-5-(1)'!D15:O15,'Form-5-(2)'!D15:O15,'Form-5-(3)'!D5:O15,'Form-5-(4)'!D15:O15,'Form-5-(5)'!D15:O15))","v":""},{"$f":"IF(P15=\"\",\"\",AVERAGE(D15:O15,'Form-5-(2)'!D15:O15,'Form-5-(3)'!D15:O15,'Form-5-(4)'!D15:O15,'Form-5-(5)'!D15:O15))","v":""},{"$f":"IF(Q15=\"\",\"\",MAX(D15:O15,'Form-5-(2)'!D15:O15,'Form-5-(3)'!D15:O15,'Form-5-(4)'!D15:O15,'Form-5-(5)'!D15:O15))","v":""},{"$f":"IF(OR((Q15=\"\"),(R15=\"\")),\"\",R15/Q15)","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D16:O16,'Form-5-(2)'!D16:O16,'Form-5-(3)'!D16:O16,'Form-5-(4)'!D16:O16,'Form-5-(5)'!D16:O16)=0,\"\",COUNT('Form-5-(1)'!D16:O16,'Form-5-(2)'!D16:O16,'Form-5-(3)'!D6:O16,'Form-5-(4)'!D16:O16,'Form-5-(5)'!D16:O16))","v":""},{"$f":"IF(P16=\"\",\"\",AVERAGE(D16:O16,'Form-5-(2)'!D16:O16,'Form-5-(3)'!D16:O16,'Form-5-(4)'!D16:O16,'Form-5-(5)'!D16:O16))","v":""},{"$f":"IF(Q16=\"\",\"\",MAX(D16:O16,'Form-5-(2)'!D16:O16,'Form-5-(3)'!D16:O16,'Form-5-(4)'!D16:O16,'Form-5-(5)'!D16:O16))","v":""},{"$f":"IF(OR((Q16=\"\"),(R16=\"\")),\"\",R16/Q16)","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D17:O17,'Form-5-(2)'!D17:O17,'Form-5-(3)'!D17:O17,'Form-5-(4)'!D17:O17,'Form-5-(5)'!D17:O17)=0,\"\",COUNT('Form-5-(1)'!D17:O17,'Form-5-(2)'!D17:O17,'Form-5-(3)'!D7:O17,'Form-5-(4)'!D17:O17,'Form-5-(5)'!D17:O17))","v":""},{"$f":"IF(P17=\"\",\"\",AVERAGE(D17:O17,'Form-5-(2)'!D17:O17,'Form-5-(3)'!D17:O17,'Form-5-(4)'!D17:O17,'Form-5-(5)'!D17:O17))","v":""},{"$f":"IF(Q17=\"\",\"\",MAX(D17:O17,'Form-5-(2)'!D17:O17,'Form-5-(3)'!D17:O17,'Form-5-(4)'!D17:O17,'Form-5-(5)'!D17:O17))","v":""},""]
[null,"Xylenes (mixed)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D18:O18,'Form-5-(2)'!D18:O18,'Form-5-(3)'!D18:O18,'Form-5-(4)'!D18:O18,'Form-5-(5)'!D18:O18)=0,\"\",COUNT('Form-5-(1)'!D18:O18,'Form-5-(2)'!D18:O18,'Form-5-(3)'!D8:O18,'Form-5-(4)'!D18:O18,'Form-5-(5)'!D18:O18))","v":""},{"$f":"IF(P18=\"\",\"\",AVERAGE(D18:O18,'Form-5-(2)'!D18:O18,'Form-5-(3)'!D18:O18,'Form-5-(4)'!D18:O18,'Form-5-(5)'!D18:O18))","v":""},{"$f":"IF(Q18=\"\",\"\",MAX(D18:O18,'Form-5-(2)'!D18:O18,'Form-5-(3)'!D18:O18,'Form-5-(4)'!D18:O18,'Form-5-(5)'!D18:O18))","v":""},""]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D19:O19,'Form-5-(2)'!D19:O19,'Form-5-(3)'!D19:O19,'Form-5-(4)'!D19:O19,'Form-5-(5)'!D19:O19)=0,\"\",COUNT('Form-5-(1)'!D19:O19,'Form-5-(2)'!D19:O19,'Form-5-(3)'!D9:O19,'Form-5-(4)'!D19:O19,'Form-5-(5)'!D19:O19))","v":""},{"$f":"IF(P19=\"\",\"\",AVERAGE(D19:O19,'Form-5-(2)'!D19:O19,'Form-5-(3)'!D19:O19,'Form-5-(4)'!D19:O19,'Form-5-(5)'!D19:O19))","v":""},{"$f":"IF(Q19=\"\",\"\",MAX(D19:O19,'Form-5-(2)'!D19:O19,'Form-5-(3)'!D19:O19,'Form-5-(4)'!D19:O19,'Form-5-(5)'!D19:O19))","v":""},""]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D20:O20,'Form-5-(2)'!D20:O20,'Form-5-(3)'!D20:O20,'Form-5-(4)'!D20:O20,'Form-5-(5)'!D20:O20)=0,\"\",COUNT('Form-5-(1)'!D20:O20,'Form-5-(2)'!D20:O20,'Form-5-(3)'!D10:O20,'Form-5-(4)'!D20:O20,'Form-5-(5)'!D20:O20))","v":""},{"$f":"IF(P20=\"\",\"\",AVERAGE(D20:O20,'Form-5-(2)'!D20:O20,'Form-5-(3)'!D20:O20,'Form-5-(4)'!D20:O20,'Form-5-(5)'!D20:O20))","v":""},{"$f":"IF(Q20=\"\",\"\",MAX(D20:O20,'Form-5-(2)'!D20:O20,'Form-5-(3)'!D20:O20,'Form-5-(4)'!D20:O20,'Form-5-(5)'!D20:O20))","v":""},""]
[null,"Naphthalene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D21:O21,'Form-5-(2)'!D21:O21,'Form-5-(3)'!D21:O21,'Form-5-(4)'!D21:O21,'Form-5-(5)'!D21:O21)=0,\"\",COUNT('Form-5-(1)'!D21:O21,'Form-5-(2)'!D21:O21,'Form-5-(3)'!D11:O21,'Form-5-(4)'!D21:O21,'Form-5-(5)'!D21:O21))","v":""},{"$f":"IF(P21=\"\",\"\",AVERAGE(D21:O21,'Form-5-(2)'!D21:O21,'Form-5-(3)'!D21:O21,'Form-5-(4)'!D21:O21,'Form-5-(5)'!D21:O21))","v":""},{"$f":"IF(Q21=\"\",\"\",MAX(D21:O21,'Form-5-(2)'!D21:O21,'Form-5-(3)'!D21:O21,'Form-5-(4)'!D21:O21,'Form-5-(5)'!D21:O21))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D22:O22,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D22:O22,#REF!,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D23:O23,'Form-5-(2)'!D23:O23,'Form-5-(3)'!D23:O23,'Form-5-(4)'!D23:O23,'Form-5-(5)'!D23:O23)=0,\"\",COUNT('Form-5-(1)'!D23:O23,'Form-5-(2)'!D23:O23,'Form-5-(3)'!D13:O23,'Form-5-(4)'!D23:O23,'Form-5-(5)'!D23:O23))","v":""},{"$f":"IF(P23=\"\",\"\",AVERAGE(D23:O23,'Form-5-(2)'!D23:O23,'Form-5-(3)'!D23:O23,'Form-5-(4)'!D23:O23,'Form-5-(5)'!D23:O23))","v":""},{"$f":"IF(Q23=\"\",\"\",MAX(D23:O23,'Form-5-(2)'!D23:O23,'Form-5-(3)'!D23:O23,'Form-5-(4)'!D23:O23,'Form-5-(5)'!D23:O23))","v":""},{"$f":"IF(OR((Q23=\"\"),(R23=\"\")),\"\",R23/Q23)","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D24:O24,'Form-5-(2)'!D24:O24,'Form-5-(3)'!D24:O24,'Form-5-(4)'!D24:O24,'Form-5-(5)'!D24:O24)=0,\"\",COUNT('Form-5-(1)'!D24:O24,'Form-5-(2)'!D24:O24,'Form-5-(3)'!D14:O24,'Form-5-(4)'!D24:O24,'Form-5-(5)'!D24:O24))","v":""},{"$f":"IF(P24=\"\",\"\",AVERAGE(D24:O24,'Form-5-(2)'!D24:O24,'Form-5-(3)'!D24:O24,'Form-5-(4)'!D24:O24,'Form-5-(5)'!D24:O24))","v":""},{"$f":"IF(Q24=\"\",\"\",MAX(D24:O24,'Form-5-(2)'!D24:O24,'Form-5-(3)'!D24:O24,'Form-5-(4)'!D24:O24,'Form-5-(5)'!D24:O24))","v":""},""]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D25:O25,'Form-5-(2)'!D25:O25,'Form-5-(3)'!D25:O25,'Form-5-(4)'!D25:O25,'Form-5-(5)'!D25:O25)=0,\"\",COUNT('Form-5-(1)'!D25:O25,'Form-5-(2)'!D25:O25,'Form-5-(3)'!D15:O25,'Form-5-(4)'!D25:O25,'Form-5-(5)'!D25:O25))","v":""},{"$f":"IF(P25=\"\",\"\",AVERAGE(D25:O25,'Form-5-(2)'!D25:O25,'Form-5-(3)'!D25:O25,'Form-5-(4)'!D25:O25,'Form-5-(5)'!D25:O25))","v":""},{"$f":"IF(Q25=\"\",\"\",MAX(D25:O25,'Form-5-(2)'!D25:O25,'Form-5-(3)'!D25:O25,'Form-5-(4)'!D25:O25,'Form-5-(5)'!D25:O25))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D26:O26,'Form-5-(2)'!D26:O26,'Form-5-(3)'!D26:O26,'Form-5-(4)'!D26:O26,'Form-5-(5)'!D26:O26)=0,\"\",COUNT('Form-5-(1)'!D26:O26,'Form-5-(2)'!D26:O26,'Form-5-(3)'!D16:O26,'Form-5-(4)'!D26:O26,'Form-5-(5)'!D26:O26))","v":""},{"$f":"IF(P26=\"\",\"\",AVERAGE(D26:O26,'Form-5-(2)'!D26:O26,'Form-5-(3)'!D26:O26,'Form-5-(4)'!D26:O26,'Form-5-(5)'!D26:O26))","v":""},{"$f":"IF(Q26=\"\",\"\",MAX(D26:O26,'Form-5-(2)'!D26:O26,'Form-5-(3)'!D26:O26,'Form-5-(4)'!D26:O26,'Form-5-(5)'!D26:O26))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D27:O27,'Form-5-(2)'!D27:O27,'Form-5-(3)'!D27:O27,'Form-5-(4)'!D27:O27,'Form-5-(5)'!D27:O27)=0,\"\",COUNT('Form-5-(1)'!D27:O27,'Form-5-(2)'!D27:O27,'Form-5-(3)'!D17:O27,'Form-5-(4)'!D27:O27,'Form-5-(5)'!D27:O27))","v":""},{"$f":"IF(P27=\"\",\"\",AVERAGE(D27:O27,'Form-5-(2)'!D27:O27,'Form-5-(3)'!D27:O27,'Form-5-(4)'!D27:O27,'Form-5-(5)'!D27:O27))","v":""},{"$f":"IF(Q27=\"\",\"\",MAX(D27:O27,'Form-5-(2)'!D27:O27,'Form-5-(3)'!D27:O27,'Form-5-(4)'!D27:O27,'Form-5-(5)'!D27:O27))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D28:O28,'Form-5-(2)'!D28:O28,'Form-5-(3)'!D28:O28,'Form-5-(4)'!D28:O28,'Form-5-(5)'!D28:O28)=0,\"\",COUNT('Form-5-(1)'!D28:O28,'Form-5-(2)'!D28:O28,'Form-5-(3)'!D18:O28,'Form-5-(4)'!D28:O28,'Form-5-(5)'!D28:O28))","v":""},{"$f":"IF(P28=\"\",\"\",AVERAGE(D28:O28,'Form-5-(2)'!D28:O28,'Form-5-(3)'!D28:O28,'Form-5-(4)'!D28:O28,'Form-5-(5)'!D28:O28))","v":""},{"$f":"IF(Q28=\"\",\"\",MAX(D28:O28,'Form-5-(2)'!D28:O28,'Form-5-(3)'!D28:O28,'Form-5-(4)'!D28:O28,'Form-5-(5)'!D28:O28))","v":""},""]
[null,"OTHER ANALYTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D30:O30,'Form-5-(2)'!D30:O30,'Form-5-(3)'!D30:O30,'Form-5-(4)'!D30:O30,'Form-5-(5)'!D30:O30)=0,\"\",COUNT('Form-5-(1)'!D30:O30,'Form-5-(2)'!D30:O30,'Form-5-(3)'!D20:O30,'Form-5-(4)'!D30:O30,'Form-5-(5)'!D30:O30))","v":""},{"$f":"IF(P30=\"\",\"\",AVERAGE(D30:O30,'Form-5-(2)'!D30:O30,'Form-5-(3)'!D30:O30,'Form-5-(4)'!D30:O30,'Form-5-(5)'!D30:O30))","v":""},{"$f":"IF(Q30=\"\",\"\",MAX(D30:O30,'Form-5-(2)'!D30:O30,'Form-5-(3)'!D30:O30,'Form-5-(4)'!D30:O30,'Form-5-(5)'!D30:O30))","v":""},{"$f":"IF(OR((Q30=\"\"),(R30=\"\")),\"\",R30/Q30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D31:O31,'Form-5-(2)'!D31:O31,'Form-5-(3)'!D31:O31,'Form-5-(4)'!D31:O31,'Form-5-(5)'!D31:O31)=0,\"\",COUNT('Form-5-(1)'!D31:O31,'Form-5-(2)'!D31:O31,'Form-5-(3)'!D21:O31,'Form-5-(4)'!D31:O31,'Form-5-(5)'!D31:O31))","v":""},{"$f":"IF(P31=\"\",\"\",AVERAGE(D31:O31,'Form-5-(2)'!D31:O31,'Form-5-(3)'!D31:O31,'Form-5-(4)'!D31:O31,'Form-5-(5)'!D31:O31))","v":""},{"$f":"IF(Q31=\"\",\"\",MAX(D31:O31,'Form-5-(2)'!D31:O31,'Form-5-(3)'!D31:O31,'Form-5-(4)'!D31:O31,'Form-5-(5)'!D31:O31))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D32:O32,'Form-5-(2)'!D32:O32,'Form-5-(3)'!D32:O32,'Form-5-(4)'!D32:O32,'Form-5-(5)'!D32:O32)=0,\"\",COUNT('Form-5-(1)'!D32:O32,'Form-5-(2)'!D32:O32,'Form-5-(3)'!D22:O32,'Form-5-(4)'!D32:O32,'Form-5-(5)'!D32:O32))","v":""},{"$f":"IF(P32=\"\",\"\",AVERAGE(D32:O32,'Form-5-(2)'!D32:O32,'Form-5-(3)'!D32:O32,'Form-5-(4)'!D32:O32,'Form-5-(5)'!D32:O32))","v":""},{"$f":"IF(Q32=\"\",\"\",MAX(D32:O32,'Form-5-(2)'!D32:O32,'Form-5-(3)'!D32:O32,'Form-5-(4)'!D32:O32,'Form-5-(5)'!D32:O32))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D33:O33,'Form-5-(2)'!D33:O33,'Form-5-(3)'!D33:O33,'Form-5-(4)'!D33:O33,'Form-5-(5)'!D33:O33)=0,\"\",COUNT('Form-5-(1)'!D33:O33,'Form-5-(2)'!D33:O33,'Form-5-(3)'!D23:O33,'Form-5-(4)'!D33:O33,'Form-5-(5)'!D33:O33))","v":""},{"$f":"IF(P33=\"\",\"\",AVERAGE(D33:O33,'Form-5-(2)'!D33:O33,'Form-5-(3)'!D33:O33,'Form-5-(4)'!D33:O33,'Form-5-(5)'!D33:O33))","v":""},{"$f":"IF(Q33=\"\",\"\",MAX(D33:O33,'Form-5-(2)'!D33:O33,'Form-5-(3)'!D33:O33,'Form-5-(4)'!D33:O33,'Form-5-(5)'!D33:O33))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D34:O34,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D35:O35,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D36:O36,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D37:O37,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D38:O38,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D39:O39,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D40:O40,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P40=\"\",\"\",AVERAGE(D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q40=\"\",\"\",MAX(D40:O40,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(1)'!D41:O41,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(1)'!D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P41=\"\",\"\",AVERAGE(D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q41=\"\",\"\",MAX(D41:O41,#REF!,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of subsurface soil sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-5-(2)","index":12,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[11,3,11,5],[11,6,11,8],[29,1,29,2],[8,1,8,18],[30,1,30,2],[7,1,7,18],[10,18,12,18],[10,9,10,11],[11,9,11,11],[10,12,10,14],[11,12,11,14],[10,16,12,16],[10,17,12,17],[10,3,10,5],[10,6,10,8]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 5  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Based on Tier 2 investigation; soil sample depth greater than 3 feet bgl.   All concentrations in mg/kg)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"MW / SB No. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of      ","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Detection (s)"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D15:O15,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D15:O15,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q15","v":""},{"$f":"'Form-5-(1)'!R15","v":""},{"$f":"'Form-5-(1)'!S15","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D16:O16,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D16:O16,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q16","v":""},{"$f":"'Form-5-(1)'!R16","v":""},{"$f":"'Form-5-(1)'!S16","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D17:O17,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D17:O17,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q17","v":""},{"$f":"'Form-5-(1)'!R17","v":""},{"$f":"'Form-5-(1)'!S17","v":""}]
[null,"Xylenes (mixed)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D18:O18,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D18:O18,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q18","v":""},{"$f":"'Form-5-(1)'!R18","v":""},{"$f":"'Form-5-(1)'!S18","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D19:O19,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D19:O19,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q19","v":""},{"$f":"'Form-5-(1)'!R19","v":""},{"$f":"'Form-5-(1)'!S19","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D20:O20,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D20:O20,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q20","v":""},{"$f":"'Form-5-(1)'!R20","v":""},{"$f":"'Form-5-(1)'!S20","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D21:O21,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D21:O21,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q21","v":""},{"$f":"'Form-5-(1)'!R21","v":""},{"$f":"'Form-5-(1)'!S21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D22:O22,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D22:O22,#REF!,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D23:O23,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D23:O23,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q23","v":""},{"$f":"'Form-5-(1)'!R23","v":""},{"$f":"'Form-5-(1)'!S23","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D24:O24,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D24:O24,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q24","v":""},{"$f":"'Form-5-(1)'!R24","v":""},{"$f":"'Form-5-(1)'!S24","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D25:O25,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D25:O25,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q25","v":""},{"$f":"'Form-5-(1)'!R25","v":""},{"$f":"'Form-5-(1)'!S25","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C26=\"\",\"\",'Form-5-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D26:O26,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D26:O26,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q26","v":""},{"$f":"'Form-5-(1)'!R26","v":""},{"$f":"'Form-5-(1)'!S26","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C27=\"\",\"\",'Form-5-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D27:O27,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D27:O27,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q27","v":""},{"$f":"'Form-5-(1)'!R27","v":""},{"$f":"'Form-5-(1)'!S27","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C28=\"\",\"\",'Form-5-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D28:O28,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D28:O28,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q28","v":""},{"$f":"'Form-5-(1)'!R28","v":""},{"$f":"'Form-5-(1)'!S28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-5-(1)'!B30:C30=\"\",\"\",'Form-5-(1)'!B30:C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D30:O30,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D30:O30,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q30","v":""},{"$f":"'Form-5-(1)'!R30","v":""},{"$f":"'Form-5-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B31:C31=\"\",\"\",'Form-5-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D31:O31,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D31:O31,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q31","v":""},{"$f":"'Form-5-(1)'!R31","v":""},{"$f":"'Form-5-(1)'!S31","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B32:C32=\"\",\"\",'Form-5-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D32:O32,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D32:O32,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q32","v":""},{"$f":"'Form-5-(1)'!R32","v":""},{"$f":"'Form-5-(1)'!S32","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B33:C33=\"\",\"\",'Form-5-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D33:O33,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D33:O33,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q33","v":""},{"$f":"'Form-5-(1)'!R33","v":""},{"$f":"'Form-5-(1)'!S33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D34:O34,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(OR((Q34=\"\"),(R34=\"\")),\"\",R34/Q34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D35:O35,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D36:O36,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D37:O37,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D38:O38,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D39:O39,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D40:O40,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P40=\"\",\"\",AVERAGE(D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q40=\"\",\"\",MAX(D40:O40,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(2)'!D41:O41,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(2)'!D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P41=\"\",\"\",AVERAGE(D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q41=\"\",\"\",MAX(D41:O41,#REF!,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of subsurface soil sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-5-(3)","index":13,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[8,1,8,18],[30,1,30,2],[7,1,7,18],[10,18,12,18],[10,9,10,11],[11,9,11,11],[10,12,10,14],[11,12,11,14],[10,16,12,16],[10,17,12,17],[10,3,10,5],[10,6,10,8],[31,1,31,2],[32,1,32,2],[11,3,11,5],[11,6,11,8],[29,1,29,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 5  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Based on Tier 2 investigation; soil sample depth greater than 3 feet bgl.   All concentrations in mg/kg)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"MW / SB No. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of      ","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Detection (s)"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D15:O15,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D15:O15,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q15","v":""},{"$f":"'Form-5-(1)'!R15","v":""},{"$f":"'Form-5-(1)'!S15","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D16:O16,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D16:O16,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q16","v":""},{"$f":"'Form-5-(1)'!R16","v":""},{"$f":"'Form-5-(1)'!S16","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D17:O17,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D17:O17,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q17","v":""},{"$f":"'Form-5-(1)'!R17","v":""},{"$f":"'Form-5-(1)'!S17","v":""}]
[null,"Xylenes (mixed)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D18:O18,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D18:O18,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q18","v":""},{"$f":"'Form-5-(1)'!R18","v":""},{"$f":"'Form-5-(1)'!S18","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D19:O19,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D19:O19,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q19","v":""},{"$f":"'Form-5-(1)'!R19","v":""},{"$f":"'Form-5-(1)'!S19","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D20:O20,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D20:O20,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q20","v":""},{"$f":"'Form-5-(1)'!R20","v":""},{"$f":"'Form-5-(1)'!S20","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D21:O21,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D21:O21,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q21","v":""},{"$f":"'Form-5-(1)'!R21","v":""},{"$f":"'Form-5-(1)'!S21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D22:O22,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D22:O22,#REF!,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D23:O23,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D23:O23,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q23","v":""},{"$f":"'Form-5-(1)'!R23","v":""},{"$f":"'Form-5-(1)'!S23","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D24:O24,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D24:O24,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q24","v":""},{"$f":"'Form-5-(1)'!R24","v":""},{"$f":"'Form-5-(1)'!S24","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D25:O25,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D25:O25,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q25","v":""},{"$f":"'Form-5-(1)'!R25","v":""},{"$f":"'Form-5-(1)'!S25","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C26=\"\",\"\",'Form-5-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D26:O26,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D26:O26,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q26","v":""},{"$f":"'Form-5-(1)'!R26","v":""},{"$f":"'Form-5-(1)'!S26","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C27=\"\",\"\",'Form-5-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D27:O27,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D27:O27,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q27","v":""},{"$f":"'Form-5-(1)'!R27","v":""},{"$f":"'Form-5-(1)'!S27","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C28=\"\",\"\",'Form-5-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D28:O28,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D28:O28,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q28","v":""},{"$f":"'Form-5-(1)'!R28","v":""},{"$f":"'Form-5-(1)'!S28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-5-(1)'!B30:C30=\"\",\"\",'Form-5-(1)'!B30:C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D30:O30,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D30:O30,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q30","v":""},{"$f":"'Form-5-(1)'!R30","v":""},{"$f":"'Form-5-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B31:C31=\"\",\"\",'Form-5-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D31:O31,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D31:O31,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q31","v":""},{"$f":"'Form-5-(1)'!R31","v":""},{"$f":"'Form-5-(1)'!S31","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B32:C32=\"\",\"\",'Form-5-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D32:O32,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D32:O32,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q32","v":""},{"$f":"'Form-5-(1)'!R32","v":""},{"$f":"'Form-5-(1)'!S32","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B33:C33=\"\",\"\",'Form-5-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D33:O33,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D33:O33,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q33","v":""},{"$f":"'Form-5-(1)'!R33","v":""},{"$f":"'Form-5-(1)'!S33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D34:O34,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(OR((Q34=\"\"),(R34=\"\")),\"\",R34/Q34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D35:O35,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D36:O36,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D37:O37,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D38:O38,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D39:O39,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D40:O40,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P40=\"\",\"\",AVERAGE(D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q40=\"\",\"\",MAX(D40:O40,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(3)'!D41:O41,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(3)'!D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P41=\"\",\"\",AVERAGE(D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q41=\"\",\"\",MAX(D41:O41,#REF!,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of subsurface soil sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-5-(4)","index":14,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[11,3,11,5],[11,6,11,8],[29,1,29,2],[8,1,8,18],[30,1,30,2],[7,1,7,18],[10,18,12,18],[10,9,10,11],[11,9,11,11],[10,12,10,14],[11,12,11,14],[10,16,12,16],[10,17,12,17],[10,3,10,5],[10,6,10,8]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 5  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Based on Tier 2 investigation; soil sample depth greater than 3 feet bgl.   All concentrations in mg/kg)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"MW / SB No. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of      ","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Detection (s)"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D15:O15,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D15:O15,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q15","v":""},{"$f":"'Form-5-(1)'!R15","v":""},{"$f":"'Form-5-(1)'!S15","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D16:O16,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D16:O16,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q16","v":""},{"$f":"'Form-5-(1)'!R16","v":""},{"$f":"'Form-5-(1)'!S16","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D17:O17,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D17:O17,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q17","v":""},{"$f":"'Form-5-(1)'!R17","v":""},{"$f":"'Form-5-(1)'!S17","v":""}]
[null,"Xylenes (mixed)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D18:O18,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D18:O18,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q18","v":""},{"$f":"'Form-5-(1)'!R18","v":""},{"$f":"'Form-5-(1)'!S18","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D19:O19,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D19:O19,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q19","v":""},{"$f":"'Form-5-(1)'!R19","v":""},{"$f":"'Form-5-(1)'!S19","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D20:O20,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D20:O20,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q20","v":""},{"$f":"'Form-5-(1)'!R20","v":""},{"$f":"'Form-5-(1)'!S20","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D21:O21,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D21:O21,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q21","v":""},{"$f":"'Form-5-(1)'!R21","v":""},{"$f":"'Form-5-(1)'!S21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D22:O22,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D22:O22,#REF!,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D23:O23,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D23:O23,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q23","v":""},{"$f":"'Form-5-(1)'!R23","v":""},{"$f":"'Form-5-(1)'!S23","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D24:O24,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D24:O24,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q24","v":""},{"$f":"'Form-5-(1)'!R24","v":""},{"$f":"'Form-5-(1)'!S24","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D25:O25,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D25:O25,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q25","v":""},{"$f":"'Form-5-(1)'!R25","v":""},{"$f":"'Form-5-(1)'!S25","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C26=\"\",\"\",'Form-5-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D26:O26,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D26:O26,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q26","v":""},{"$f":"'Form-5-(1)'!R26","v":""},{"$f":"'Form-5-(1)'!S26","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C27=\"\",\"\",'Form-5-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D27:O27,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D27:O27,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q27","v":""},{"$f":"'Form-5-(1)'!R27","v":""},{"$f":"'Form-5-(1)'!S27","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C28=\"\",\"\",'Form-5-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D28:O28,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D28:O28,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q28","v":""},{"$f":"'Form-5-(1)'!R28","v":""},{"$f":"'Form-5-(1)'!S28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-5-(1)'!B30:C30=\"\",\"\",'Form-5-(1)'!B30:C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D30:O30,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D30:O30,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q30","v":""},{"$f":"'Form-5-(1)'!R30","v":""},{"$f":"'Form-5-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B31:C31=\"\",\"\",'Form-5-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D31:O31,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D31:O31,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q31","v":""},{"$f":"'Form-5-(1)'!R31","v":""},{"$f":"'Form-5-(1)'!S31","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B32:C32=\"\",\"\",'Form-5-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D32:O32,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D32:O32,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q32","v":""},{"$f":"'Form-5-(1)'!R32","v":""},{"$f":"'Form-5-(1)'!S32","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B33:C33=\"\",\"\",'Form-5-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D33:O33,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D33:O33,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q33","v":""},{"$f":"'Form-5-(1)'!R33","v":""},{"$f":"'Form-5-(1)'!S33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D34:O34,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(OR((Q34=\"\"),(R34=\"\")),\"\",R34/Q34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D35:O35,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D36:O36,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D37:O37,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D38:O38,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D39:O39,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D40:O40,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P40=\"\",\"\",AVERAGE(D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q40=\"\",\"\",MAX(D40:O40,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(4)'!D41:O41,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(4)'!D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P41=\"\",\"\",AVERAGE(D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q41=\"\",\"\",MAX(D41:O41,#REF!,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of subsurface soil sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-5-(5)","index":15,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":true,"merged":[[8,1,8,18],[30,1,30,2],[7,1,7,18],[10,18,12,18],[10,9,10,11],[11,9,11,11],[10,12,10,14],[11,12,11,14],[10,16,12,16],[10,17,12,17],[10,3,10,5],[10,6,10,8],[31,1,31,2],[32,1,32,2],[11,3,11,5],[11,6,11,8],[29,1,29,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 5  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Based on Tier 2 investigation; soil sample depth greater than 3 feet bgl.   All concentrations in mg/kg)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"MW / SB No. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of      ","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date",null,null,null,null,null,null,null,null,null,null,null,null,null,"Detection (s)"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D15:O15,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D15:O15,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q15","v":""},{"$f":"'Form-5-(1)'!R15","v":""},{"$f":"'Form-5-(1)'!S15","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D16:O16,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D16:O16,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q16","v":""},{"$f":"'Form-5-(1)'!R16","v":""},{"$f":"'Form-5-(1)'!S16","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D17:O17,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D17:O17,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q17","v":""},{"$f":"'Form-5-(1)'!R17","v":""},{"$f":"'Form-5-(1)'!S17","v":""}]
[null,"Xylenes (mixed)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D18:O18,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D18:O18,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q18","v":""},{"$f":"'Form-5-(1)'!R18","v":""},{"$f":"'Form-5-(1)'!S18","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D19:O19,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D19:O19,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q19","v":""},{"$f":"'Form-5-(1)'!R19","v":""},{"$f":"'Form-5-(1)'!S19","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D20:O20,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D20:O20,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q20","v":""},{"$f":"'Form-5-(1)'!R20","v":""},{"$f":"'Form-5-(1)'!S20","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D21:O21,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D21:O21,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q21","v":""},{"$f":"'Form-5-(1)'!R21","v":""},{"$f":"'Form-5-(1)'!S21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D22:O22,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D22:O22,#REF!,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D23:O23,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D23:O23,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q23","v":""},{"$f":"'Form-5-(1)'!R23","v":""},{"$f":"'Form-5-(1)'!S23","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D24:O24,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D24:O24,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q24","v":""},{"$f":"'Form-5-(1)'!R24","v":""},{"$f":"'Form-5-(1)'!S24","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D25:O25,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D25:O25,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q25","v":""},{"$f":"'Form-5-(1)'!R25","v":""},{"$f":"'Form-5-(1)'!S25","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C26=\"\",\"\",'Form-5-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D26:O26,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D26:O26,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q26","v":""},{"$f":"'Form-5-(1)'!R26","v":""},{"$f":"'Form-5-(1)'!S26","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C27=\"\",\"\",'Form-5-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D27:O27,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D27:O27,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q27","v":""},{"$f":"'Form-5-(1)'!R27","v":""},{"$f":"'Form-5-(1)'!S27","v":""}]
[null,"TEH as",{"$f":"IF('Form-5-(1)'!C28=\"\",\"\",'Form-5-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D28:O28,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D28:O28,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q28","v":""},{"$f":"'Form-5-(1)'!R28","v":""},{"$f":"'Form-5-(1)'!S28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-5-(1)'!B30:C30=\"\",\"\",'Form-5-(1)'!B30:C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D30:O30,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D30:O30,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q30","v":""},{"$f":"'Form-5-(1)'!R30","v":""},{"$f":"'Form-5-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B31:C31=\"\",\"\",'Form-5-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D31:O31,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D31:O31,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q31","v":""},{"$f":"'Form-5-(1)'!R31","v":""},{"$f":"'Form-5-(1)'!S31","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B32:C32=\"\",\"\",'Form-5-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D32:O32,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D32:O32,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q32","v":""},{"$f":"'Form-5-(1)'!R32","v":""},{"$f":"'Form-5-(1)'!S32","v":""}]
[null,{"$f":"IF('Form-5-(1)'!B33:C33=\"\",\"\",'Form-5-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D33:O33,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D33:O33,#REF!,#REF!,#REF!,#REF!))","v":""},{"$f":"'Form-5-(1)'!Q33","v":""},{"$f":"'Form-5-(1)'!R33","v":""},{"$f":"'Form-5-(1)'!S33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D34:O34,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(OR((Q34=\"\"),(R34=\"\")),\"\",R34/Q34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D35:O35,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D36:O36,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D37:O37,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D38:O38,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D39:O39,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D40:O40,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P40=\"\",\"\",AVERAGE(D40:O40,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q40=\"\",\"\",MAX(D40:O40,#REF!,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-5-(5)'!D41:O41,#REF!,#REF!,#REF!)=0,\"\",COUNT('Form-5-(5)'!D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(P41=\"\",\"\",AVERAGE(D41:O41,#REF!,#REF!,#REF!))","v":""},{"$f":"IF(Q41=\"\",\"\",MAX(D41:O41,#REF!,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of subsurface soil sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(1)","index":16,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,'Form-6a-(2)'!D17:J17,'Form-6a-(3)'!D17:J17,'Form-6a-(4)'!D17:J17,'Form-6a-(5)'!D17:J17,'Form-6a-(6)'!D17:J17)=0,\"\",COUNT(D17:J17,'Form-6a-(2)'!D17:J17,'Form-6a-(3)'!D17:J17,'Form-6a-(4)'!D17:J17,'Form-6a-(5)'!D17:J17,'Form-6a-(6)'!D17:J17))","v":""},{"$f":"IF(K17=\"\",\"\",AVERAGE(D17:J17,'Form-6a-(2)'!D17:J17,'Form-6a-(3)'!D17:J17,'Form-6a-(4)'!D17:J17,'Form-6a-(5)'!D17:J17,'Form-6a-(6)'!D17:J17))","v":""},{"$f":"IF(K17=\"\",\"\",MAX(D17:J17,'Form-6a-(2)'!D17:J17,'Form-6a-(3)'!D17:J17,'Form-6a-(4)'!D17:J17,'Form-6a-(5)'!D17:J17,'Form-6a-(6)'!D17:J17))","v":""},{"$f":"IF(K17=\"\",\"\",M17/L17)","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,'Form-6a-(2)'!D18:J18,'Form-6a-(3)'!D18:J18,'Form-6a-(4)'!D18:J18,'Form-6a-(5)'!D18:J18,'Form-6a-(6)'!D18:J18)=0,\"\",COUNT(D18:J18,'Form-6a-(2)'!D18:J18,'Form-6a-(3)'!D18:J18,'Form-6a-(4)'!D18:J18,'Form-6a-(5)'!D18:J18,'Form-6a-(6)'!D18:J18))","v":""},{"$f":"IF(K18=\"\",\"\",AVERAGE(D18:J18,'Form-6a-(2)'!D18:J18,'Form-6a-(3)'!D18:J18,'Form-6a-(4)'!D18:J18,'Form-6a-(5)'!D18:J18,'Form-6a-(6)'!D18:J18))","v":""},{"$f":"IF(K18=\"\",\"\",MAX(D18:J18,'Form-6a-(2)'!D18:J18,'Form-6a-(3)'!D18:J18,'Form-6a-(4)'!D18:J18,'Form-6a-(5)'!D18:J18,'Form-6a-(6)'!D18:J18))","v":""},{"$f":"IF(K18=\"\",\"\",M18/L18)","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,'Form-6a-(2)'!D19:J19,'Form-6a-(3)'!D19:J19,'Form-6a-(4)'!D19:J19,'Form-6a-(5)'!D19:J19,'Form-6a-(6)'!D19:J19)=0,\"\",COUNT(D19:J19,'Form-6a-(2)'!D19:J19,'Form-6a-(3)'!D19:J19,'Form-6a-(4)'!D19:J19,'Form-6a-(5)'!D19:J19,'Form-6a-(6)'!D19:J19))","v":""},{"$f":"IF(K19=\"\",\"\",AVERAGE(D19:J19,'Form-6a-(2)'!D19:J19,'Form-6a-(3)'!D19:J19,'Form-6a-(4)'!D19:J19,'Form-6a-(5)'!D19:J19,'Form-6a-(6)'!D19:J19))","v":""},{"$f":"IF(K19=\"\",\"\",MAX(D19:J19,'Form-6a-(2)'!D19:J19,'Form-6a-(3)'!D19:J19,'Form-6a-(4)'!D19:J19,'Form-6a-(5)'!D19:J19,'Form-6a-(6)'!D19:J19))","v":""},"",null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,'Form-6a-(2)'!D20:J20,'Form-6a-(3)'!D20:J20,'Form-6a-(4)'!D20:J20,'Form-6a-(5)'!D20:J20,'Form-6a-(6)'!D20:J20)=0,\"\",COUNT(D20:J20,'Form-6a-(2)'!D20:J20,'Form-6a-(3)'!D20:J20,'Form-6a-(4)'!D20:J20,'Form-6a-(5)'!D20:J20,'Form-6a-(6)'!D20:J20))","v":""},{"$f":"IF(K20=\"\",\"\",AVERAGE(D20:J20,'Form-6a-(2)'!D20:J20,'Form-6a-(3)'!D20:J20,'Form-6a-(4)'!D20:J20,'Form-6a-(5)'!D20:J20,'Form-6a-(6)'!D20:J20))","v":""},{"$f":"IF(K20=\"\",\"\",MAX(D20:J20,'Form-6a-(2)'!D20:J20,'Form-6a-(3)'!D20:J20,'Form-6a-(4)'!D20:J20,'Form-6a-(5)'!D20:J20,'Form-6a-(6)'!D20:J20))","v":""},""]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,'Form-6a-(2)'!D21:J21,'Form-6a-(3)'!D21:J21,'Form-6a-(4)'!D21:J21,'Form-6a-(5)'!D21:J21,'Form-6a-(6)'!D21:J21)=0,\"\",COUNT(D21:J21,'Form-6a-(2)'!D21:J21,'Form-6a-(3)'!D21:J21,'Form-6a-(4)'!D21:J21,'Form-6a-(5)'!D21:J21,'Form-6a-(6)'!D21:J21))","v":""},{"$f":"IF(K21=\"\",\"\",AVERAGE(D21:J21,'Form-6a-(2)'!D21:J21,'Form-6a-(3)'!D21:J21,'Form-6a-(4)'!D21:J21,'Form-6a-(5)'!D21:J21,'Form-6a-(6)'!D21:J21))","v":""},{"$f":"IF(K21=\"\",\"\",MAX(D21:J21,'Form-6a-(2)'!D21:J21,'Form-6a-(3)'!D21:J21,'Form-6a-(4)'!D21:J21,'Form-6a-(5)'!D21:J21,'Form-6a-(6)'!D21:J21))","v":""},""]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,'Form-6a-(2)'!D22:J22,'Form-6a-(3)'!D22:J22,'Form-6a-(4)'!D22:J22,'Form-6a-(5)'!D22:J22,'Form-6a-(6)'!D22:J22)=0,\"\",COUNT(D22:J22,'Form-6a-(2)'!D22:J22,'Form-6a-(3)'!D22:J22,'Form-6a-(4)'!D22:J22,'Form-6a-(5)'!D22:J22,'Form-6a-(6)'!D22:J22))","v":""},{"$f":"IF(K22=\"\",\"\",AVERAGE(D22:J22,'Form-6a-(2)'!D22:J22,'Form-6a-(3)'!D22:J22,'Form-6a-(4)'!D22:J22,'Form-6a-(5)'!D22:J22,'Form-6a-(6)'!D22:J22))","v":""},{"$f":"IF(K22=\"\",\"\",MAX(D22:J22,'Form-6a-(2)'!D22:J22,'Form-6a-(3)'!D22:J22,'Form-6a-(4)'!D22:J22,'Form-6a-(5)'!D22:J22,'Form-6a-(6)'!D22:J22))","v":""},""]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,'Form-6a-(2)'!D23:J23,'Form-6a-(3)'!D23:J23,'Form-6a-(4)'!D23:J23,'Form-6a-(5)'!D23:J23,'Form-6a-(6)'!D23:J23)=0,\"\",COUNT(D23:J23,'Form-6a-(2)'!D23:J23,'Form-6a-(3)'!D23:J23,'Form-6a-(4)'!D23:J23,'Form-6a-(5)'!D23:J23,'Form-6a-(6)'!D23:J23))","v":""},{"$f":"IF(K23=\"\",\"\",AVERAGE(D23:J23,'Form-6a-(2)'!D23:J23,'Form-6a-(3)'!D23:J23,'Form-6a-(4)'!D23:J23,'Form-6a-(5)'!D23:J23,'Form-6a-(6)'!D23:J23))","v":""},{"$f":"IF(K23=\"\",\"\",MAX(D23:J23,'Form-6a-(2)'!D23:J23,'Form-6a-(3)'!D23:J23,'Form-6a-(4)'!D23:J23,'Form-6a-(5)'!D23:J23,'Form-6a-(6)'!D23:J23))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,'Form-6a-(2)'!D25:J25,'Form-6a-(3)'!D25:J25,'Form-6a-(4)'!D25:J25,'Form-6a-(5)'!D25:J25,'Form-6a-(6)'!D25:J25)=0,\"\",COUNT(D25:J25,'Form-6a-(2)'!D25:J25,'Form-6a-(3)'!D25:J25,'Form-6a-(4)'!D25:J25,'Form-6a-(5)'!D25:J25,'Form-6a-(6)'!D25:J25))","v":""},{"$f":"IF(K25=\"\",\"\",AVERAGE(D25:J25,'Form-6a-(2)'!D25:J25,'Form-6a-(3)'!D25:J25,'Form-6a-(4)'!D25:J25,'Form-6a-(5)'!D25:J25,'Form-6a-(6)'!D25:J25))","v":""},{"$f":"IF(K25=\"\",\"\",MAX(D25:J25,'Form-6a-(2)'!D25:J25,'Form-6a-(3)'!D25:J25,'Form-6a-(4)'!D25:J25,'Form-6a-(5)'!D25:J25,'Form-6a-(6)'!D25:J25))","v":""},{"$f":"IF(K25=\"\",\"\",M25/L25)","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,'Form-6a-(2)'!D26:J26,'Form-6a-(3)'!D26:J26,'Form-6a-(4)'!D26:J26,'Form-6a-(5)'!D26:J26,'Form-6a-(6)'!D26:J26)=0,\"\",COUNT(D26:J26,'Form-6a-(2)'!D26:J26,'Form-6a-(3)'!D26:J26,'Form-6a-(4)'!D26:J26,'Form-6a-(5)'!D26:J26,'Form-6a-(6)'!D26:J26))","v":""},{"$f":"IF(K26=\"\",\"\",AVERAGE(D26:J26,'Form-6a-(2)'!D26:J26,'Form-6a-(3)'!D26:J26,'Form-6a-(4)'!D26:J26,'Form-6a-(5)'!D26:J26,'Form-6a-(6)'!D26:J26))","v":""},{"$f":"IF(K26=\"\",\"\",MAX(D26:J26,'Form-6a-(2)'!D26:J26,'Form-6a-(3)'!D26:J26,'Form-6a-(4)'!D26:J26,'Form-6a-(5)'!D26:J26,'Form-6a-(6)'!D26:J26))","v":""},""]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,'Form-6a-(2)'!D27:J27,'Form-6a-(3)'!D27:J27,'Form-6a-(4)'!D27:J27,'Form-6a-(5)'!D27:J27,'Form-6a-(6)'!D27:J27)=0,\"\",COUNT(D27:J27,'Form-6a-(2)'!D27:J27,'Form-6a-(3)'!D27:J27,'Form-6a-(4)'!D27:J27,'Form-6a-(5)'!D27:J27,'Form-6a-(6)'!D27:J27))","v":""},{"$f":"IF(K27=\"\",\"\",AVERAGE(D27:J27,'Form-6a-(2)'!D27:J27,'Form-6a-(3)'!D27:J27,'Form-6a-(4)'!D27:J27,'Form-6a-(5)'!D27:J27,'Form-6a-(6)'!D27:J27))","v":""},{"$f":"IF(K27=\"\",\"\",MAX(D27:J27,'Form-6a-(2)'!D27:J27,'Form-6a-(3)'!D27:J27,'Form-6a-(4)'!D27:J27,'Form-6a-(5)'!D27:J27,'Form-6a-(6)'!D27:J27))","v":""},"",null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,'Form-6a-(2)'!D28:J28,'Form-6a-(3)'!D28:J28,'Form-6a-(4)'!D28:J28,'Form-6a-(5)'!D28:J28,'Form-6a-(6)'!D28:J28)=0,\"\",COUNT(D28:J28,'Form-6a-(2)'!D28:J28,'Form-6a-(3)'!D28:J28,'Form-6a-(4)'!D28:J28,'Form-6a-(5)'!D28:J28,'Form-6a-(6)'!D28:J28))","v":""},{"$f":"IF(K28=\"\",\"\",AVERAGE(D28:J28,'Form-6a-(2)'!D28:J28,'Form-6a-(3)'!D28:J28,'Form-6a-(4)'!D28:J28,'Form-6a-(5)'!D28:J28,'Form-6a-(6)'!D28:J28))","v":""},{"$f":"IF(K28=\"\",\"\",MAX(D28:J28,'Form-6a-(2)'!D28:J28,'Form-6a-(3)'!D28:J28,'Form-6a-(4)'!D28:J28,'Form-6a-(5)'!D28:J28,'Form-6a-(6)'!D28:J28))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,'Form-6a-(2)'!D29:J29,'Form-6a-(3)'!D29:J29,'Form-6a-(4)'!D29:J29,'Form-6a-(5)'!D29:J29,'Form-6a-(6)'!D29:J29)=0,\"\",COUNT(D29:J29,'Form-6a-(2)'!D29:J29,'Form-6a-(3)'!D29:J29,'Form-6a-(4)'!D29:J29,'Form-6a-(5)'!D29:J29,'Form-6a-(6)'!D29:J29))","v":""},{"$f":"IF(K29=\"\",\"\",AVERAGE(D29:J29,'Form-6a-(2)'!D29:J29,'Form-6a-(3)'!D29:J29,'Form-6a-(4)'!D29:J29,'Form-6a-(5)'!D29:J29,'Form-6a-(6)'!D29:J29))","v":""},{"$f":"IF(K29=\"\",\"\",MAX(D29:J29,'Form-6a-(2)'!D29:J29,'Form-6a-(3)'!D29:J29,'Form-6a-(4)'!D29:J29,'Form-6a-(5)'!D29:J29,'Form-6a-(6)'!D29:J29))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,'Form-6a-(2)'!D30:J30,'Form-6a-(3)'!D30:J30,'Form-6a-(4)'!D30:J30,'Form-6a-(5)'!D30:J30,'Form-6a-(6)'!D30:J30)=0,\"\",COUNT(D30:J30,'Form-6a-(2)'!D30:J30,'Form-6a-(3)'!D30:J30,'Form-6a-(4)'!D30:J30,'Form-6a-(5)'!D30:J30,'Form-6a-(6)'!D30:J30))","v":""},{"$f":"IF(K30=\"\",\"\",AVERAGE(D30:J30,'Form-6a-(2)'!D30:J30,'Form-6a-(3)'!D30:J30,'Form-6a-(4)'!D30:J30,'Form-6a-(5)'!D30:J30,'Form-6a-(6)'!D30:J30))","v":""},{"$f":"IF(K30=\"\",\"\",MAX(D30:J30,'Form-6a-(2)'!D30:J30,'Form-6a-(3)'!D30:J30,'Form-6a-(4)'!D30:J30,'Form-6a-(5)'!D30:J30,'Form-6a-(6)'!D30:J30))","v":""},""]
[null,"OTHER ANALYTES"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,'Form-6a-(2)'!D32:J32,'Form-6a-(3)'!D32:J32,'Form-6a-(4)'!D32:J32,'Form-6a-(5)'!D32:J32,'Form-6a-(6)'!D32:J32)=0,\"\",COUNT(D32:J32,'Form-6a-(2)'!D32:J32,'Form-6a-(3)'!D32:J32,'Form-6a-(4)'!D32:J32,'Form-6a-(5)'!D32:J32,'Form-6a-(6)'!D32:J32))","v":""},{"$f":"IF(K32=\"\",\"\",AVERAGE(D32:J32,'Form-6a-(2)'!D32:J32,'Form-6a-(3)'!D32:J32,'Form-6a-(4)'!D32:J32,'Form-6a-(5)'!D32:J32,'Form-6a-(6)'!D32:J32))","v":""},{"$f":"IF(K32=\"\",\"\",MAX(D32:J32,'Form-6a-(2)'!D32:J32,'Form-6a-(3)'!D32:J32,'Form-6a-(4)'!D32:J32,'Form-6a-(5)'!D32:J32,'Form-6a-(6)'!D32:J32))","v":""},{"$f":"IF(K32=\"\",\"\",M32/L32)","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,'Form-6a-(2)'!D33:J33,'Form-6a-(3)'!D33:J33,'Form-6a-(4)'!D33:J33,'Form-6a-(5)'!D33:J33,'Form-6a-(6)'!D33:J33)=0,\"\",COUNT(D33:J33,'Form-6a-(2)'!D33:J33,'Form-6a-(3)'!D33:J33,'Form-6a-(4)'!D33:J33,'Form-6a-(5)'!D33:J33,'Form-6a-(6)'!D33:J33))","v":""},{"$f":"IF(K33=\"\",\"\",AVERAGE(D33:J33,'Form-6a-(2)'!D33:J33,'Form-6a-(3)'!D33:J33,'Form-6a-(4)'!D33:J33,'Form-6a-(5)'!D33:J33,'Form-6a-(6)'!D33:J33))","v":""},{"$f":"IF(K33=\"\",\"\",MAX(D33:J33,'Form-6a-(2)'!D33:J33,'Form-6a-(3)'!D33:J33,'Form-6a-(4)'!D33:J33,'Form-6a-(5)'!D33:J33,'Form-6a-(6)'!D33:J33))","v":""},{"$f":"IF(K33=\"\",\"\",M33/L33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,'Form-6a-(2)'!D34:J34,'Form-6a-(3)'!D34:J34,'Form-6a-(4)'!D34:J34,'Form-6a-(5)'!D34:J34,'Form-6a-(6)'!D34:J34)=0,\"\",COUNT(D34:J34,'Form-6a-(2)'!D34:J34,'Form-6a-(3)'!D34:J34,'Form-6a-(4)'!D34:J34,'Form-6a-(5)'!D34:J34,'Form-6a-(6)'!D34:J34))","v":""},{"$f":"IF(K34=\"\",\"\",AVERAGE(D34:J34,'Form-6a-(2)'!D34:J34,'Form-6a-(3)'!D34:J34,'Form-6a-(4)'!D34:J34,'Form-6a-(5)'!D34:J34,'Form-6a-(6)'!D34:J34))","v":""},{"$f":"IF(K34=\"\",\"\",MAX(D34:J34,'Form-6a-(2)'!D34:J34,'Form-6a-(3)'!D34:J34,'Form-6a-(4)'!D34:J34,'Form-6a-(5)'!D34:J34,'Form-6a-(6)'!D34:J34))","v":""},{"$f":"IF(K34=\"\",\"\",M34/L34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,'Form-6a-(2)'!D35:J35,'Form-6a-(3)'!D35:J35,'Form-6a-(4)'!D35:J35,'Form-6a-(5)'!D35:J35,'Form-6a-(6)'!D35:J35)=0,\"\",COUNT(D35:J35,'Form-6a-(2)'!D35:J35,'Form-6a-(3)'!D35:J35,'Form-6a-(4)'!D35:J35,'Form-6a-(5)'!D35:J35,'Form-6a-(6)'!D35:J35))","v":""},{"$f":"IF(K35=\"\",\"\",AVERAGE(D35:J35,'Form-6a-(2)'!D35:J35,'Form-6a-(3)'!D35:J35,'Form-6a-(4)'!D35:J35,'Form-6a-(5)'!D35:J35,'Form-6a-(6)'!D35:J35))","v":""},{"$f":"IF(K35=\"\",\"\",MAX(D35:J35,'Form-6a-(2)'!D35:J35,'Form-6a-(3)'!D35:J35,'Form-6a-(4)'!D35:J35,'Form-6a-(5)'!D35:J35,'Form-6a-(6)'!D35:J35))","v":""},{"$f":"IF(K35=\"\",\"\",M35/L35)","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(2)","index":17,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,#REF!)=0,\"\",COUNT(D17:J17,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L17","v":""},{"$f":"'Form-6a-(1)'!M17","v":""},{"$f":"'Form-6a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,#REF!)=0,\"\",COUNT(D18:J18,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L18","v":""},{"$f":"'Form-6a-(1)'!M18","v":""},{"$f":"'Form-6a-(1)'!N18","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,#REF!)=0,\"\",COUNT(D19:J19,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L19","v":""},{"$f":"'Form-6a-(1)'!M19","v":""},{"$f":"'Form-6a-(1)'!N19","v":""},null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,#REF!)=0,\"\",COUNT(D20:J20,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L20","v":""},{"$f":"'Form-6a-(1)'!M20","v":""},{"$f":"'Form-6a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,#REF!)=0,\"\",COUNT(D21:J21,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L21","v":""},{"$f":"'Form-6a-(1)'!M21","v":""},{"$f":"'Form-6a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,#REF!)=0,\"\",COUNT(D22:J22,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L22","v":""},{"$f":"'Form-6a-(1)'!M22","v":""},{"$f":"'Form-6a-(1)'!N22","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,#REF!)=0,\"\",COUNT(D23:J23,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L23","v":""},{"$f":"'Form-6a-(1)'!M23","v":""},{"$f":"'Form-6a-(1)'!N23","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,#REF!)=0,\"\",COUNT(D25:J25,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L25","v":""},{"$f":"'Form-6a-(1)'!M25","v":""},{"$f":"'Form-6a-(1)'!N25","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,#REF!)=0,\"\",COUNT(D26:J26,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L26","v":""},{"$f":"'Form-6a-(1)'!M26","v":""},{"$f":"'Form-6a-(1)'!N26","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,#REF!)=0,\"\",COUNT(D27:J27,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L27","v":""},{"$f":"'Form-6a-(1)'!M27","v":""},{"$f":"'Form-6a-(1)'!N27","v":""},null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,#REF!)=0,\"\",COUNT(D28:J28,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L28","v":""},{"$f":"'Form-6a-(1)'!M28","v":""},{"$f":"'Form-6a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,#REF!)=0,\"\",COUNT(D29:J29,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L29","v":""},{"$f":"'Form-6a-(1)'!M29","v":""},{"$f":"'Form-6a-(1)'!N29","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,#REF!)=0,\"\",COUNT(D30:J30,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L30","v":""},{"$f":"'Form-6a-(1)'!M30","v":""},{"$f":"'Form-6a-(1)'!N30","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,#REF!)=0,\"\",COUNT(D32:J32,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L32","v":""},{"$f":"'Form-6a-(1)'!M32","v":""},{"$f":"'Form-6a-(1)'!N32","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,#REF!)=0,\"\",COUNT(D33:J33,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L33","v":""},{"$f":"'Form-6a-(1)'!M33","v":""},{"$f":"'Form-6a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,#REF!)=0,\"\",COUNT(D34:J34,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L34","v":""},{"$f":"'Form-6a-(1)'!M34","v":""},{"$f":"'Form-6a-(1)'!N34","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,#REF!)=0,\"\",COUNT(D35:J35,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L35","v":""},{"$f":"'Form-6a-(1)'!M35","v":""},{"$f":"'Form-6a-(1)'!N35","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(3)","index":18,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,#REF!)=0,\"\",COUNT(D17:J17,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L17","v":""},{"$f":"'Form-6a-(1)'!M17","v":""},{"$f":"'Form-6a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,#REF!)=0,\"\",COUNT(D18:J18,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L18","v":""},{"$f":"'Form-6a-(1)'!M18","v":""},{"$f":"'Form-6a-(1)'!N18","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,#REF!)=0,\"\",COUNT(D19:J19,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L19","v":""},{"$f":"'Form-6a-(1)'!M19","v":""},{"$f":"'Form-6a-(1)'!N19","v":""},null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,#REF!)=0,\"\",COUNT(D20:J20,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L20","v":""},{"$f":"'Form-6a-(1)'!M20","v":""},{"$f":"'Form-6a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,#REF!)=0,\"\",COUNT(D21:J21,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L21","v":""},{"$f":"'Form-6a-(1)'!M21","v":""},{"$f":"'Form-6a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,#REF!)=0,\"\",COUNT(D22:J22,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L22","v":""},{"$f":"'Form-6a-(1)'!M22","v":""},{"$f":"'Form-6a-(1)'!N22","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,#REF!)=0,\"\",COUNT(D23:J23,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L23","v":""},{"$f":"'Form-6a-(1)'!M23","v":""},{"$f":"'Form-6a-(1)'!N23","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,#REF!)=0,\"\",COUNT(D25:J25,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L25","v":""},{"$f":"'Form-6a-(1)'!M25","v":""},{"$f":"'Form-6a-(1)'!N25","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,#REF!)=0,\"\",COUNT(D26:J26,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L26","v":""},{"$f":"'Form-6a-(1)'!M26","v":""},{"$f":"'Form-6a-(1)'!N26","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,#REF!)=0,\"\",COUNT(D27:J27,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L27","v":""},{"$f":"'Form-6a-(1)'!M27","v":""},{"$f":"'Form-6a-(1)'!N27","v":""},null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,#REF!)=0,\"\",COUNT(D28:J28,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L28","v":""},{"$f":"'Form-6a-(1)'!M28","v":""},{"$f":"'Form-6a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,#REF!)=0,\"\",COUNT(D29:J29,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L29","v":""},{"$f":"'Form-6a-(1)'!M29","v":""},{"$f":"'Form-6a-(1)'!N29","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,#REF!)=0,\"\",COUNT(D30:J30,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L30","v":""},{"$f":"'Form-6a-(1)'!M30","v":""},{"$f":"'Form-6a-(1)'!N30","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,#REF!)=0,\"\",COUNT(D32:J32,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L32","v":""},{"$f":"'Form-6a-(1)'!M32","v":""},{"$f":"'Form-6a-(1)'!N32","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,#REF!)=0,\"\",COUNT(D33:J33,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L33","v":""},{"$f":"'Form-6a-(1)'!M33","v":""},{"$f":"'Form-6a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,#REF!)=0,\"\",COUNT(D34:J34,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L34","v":""},{"$f":"'Form-6a-(1)'!M34","v":""},{"$f":"'Form-6a-(1)'!N34","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,#REF!)=0,\"\",COUNT(D35:J35,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L35","v":""},{"$f":"'Form-6a-(1)'!M35","v":""},{"$f":"'Form-6a-(1)'!N35","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(4)","index":19,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,#REF!)=0,\"\",COUNT(D17:J17,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L17","v":""},{"$f":"'Form-6a-(1)'!M17","v":""},{"$f":"'Form-6a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,#REF!)=0,\"\",COUNT(D18:J18,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L18","v":""},{"$f":"'Form-6a-(1)'!M18","v":""},{"$f":"'Form-6a-(1)'!N18","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,#REF!)=0,\"\",COUNT(D19:J19,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L19","v":""},{"$f":"'Form-6a-(1)'!M19","v":""},{"$f":"'Form-6a-(1)'!N19","v":""},null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,#REF!)=0,\"\",COUNT(D20:J20,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L20","v":""},{"$f":"'Form-6a-(1)'!M20","v":""},{"$f":"'Form-6a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,#REF!)=0,\"\",COUNT(D21:J21,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L21","v":""},{"$f":"'Form-6a-(1)'!M21","v":""},{"$f":"'Form-6a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,#REF!)=0,\"\",COUNT(D22:J22,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L22","v":""},{"$f":"'Form-6a-(1)'!M22","v":""},{"$f":"'Form-6a-(1)'!N22","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,#REF!)=0,\"\",COUNT(D23:J23,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L23","v":""},{"$f":"'Form-6a-(1)'!M23","v":""},{"$f":"'Form-6a-(1)'!N23","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,#REF!)=0,\"\",COUNT(D25:J25,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L25","v":""},{"$f":"'Form-6a-(1)'!M25","v":""},{"$f":"'Form-6a-(1)'!N25","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,#REF!)=0,\"\",COUNT(D26:J26,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L26","v":""},{"$f":"'Form-6a-(1)'!M26","v":""},{"$f":"'Form-6a-(1)'!N26","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,#REF!)=0,\"\",COUNT(D27:J27,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L27","v":""},{"$f":"'Form-6a-(1)'!M27","v":""},{"$f":"'Form-6a-(1)'!N27","v":""},null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,#REF!)=0,\"\",COUNT(D28:J28,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L28","v":""},{"$f":"'Form-6a-(1)'!M28","v":""},{"$f":"'Form-6a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,#REF!)=0,\"\",COUNT(D29:J29,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L29","v":""},{"$f":"'Form-6a-(1)'!M29","v":""},{"$f":"'Form-6a-(1)'!N29","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,#REF!)=0,\"\",COUNT(D30:J30,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L30","v":""},{"$f":"'Form-6a-(1)'!M30","v":""},{"$f":"'Form-6a-(1)'!N30","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,#REF!)=0,\"\",COUNT(D32:J32,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L32","v":""},{"$f":"'Form-6a-(1)'!M32","v":""},{"$f":"'Form-6a-(1)'!N32","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,#REF!)=0,\"\",COUNT(D33:J33,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L33","v":""},{"$f":"'Form-6a-(1)'!M33","v":""},{"$f":"'Form-6a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,#REF!)=0,\"\",COUNT(D34:J34,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L34","v":""},{"$f":"'Form-6a-(1)'!M34","v":""},{"$f":"'Form-6a-(1)'!N34","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,#REF!)=0,\"\",COUNT(D35:J35,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L35","v":""},{"$f":"'Form-6a-(1)'!M35","v":""},{"$f":"'Form-6a-(1)'!N35","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(5)","index":20,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,#REF!)=0,\"\",COUNT(D17:J17,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L17","v":""},{"$f":"'Form-6a-(1)'!M17","v":""},{"$f":"'Form-6a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,#REF!)=0,\"\",COUNT(D18:J18,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L18","v":""},{"$f":"'Form-6a-(1)'!M18","v":""},{"$f":"'Form-6a-(1)'!N18","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,#REF!)=0,\"\",COUNT(D19:J19,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L19","v":""},{"$f":"'Form-6a-(1)'!M19","v":""},{"$f":"'Form-6a-(1)'!N19","v":""},null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,#REF!)=0,\"\",COUNT(D20:J20,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L20","v":""},{"$f":"'Form-6a-(1)'!M20","v":""},{"$f":"'Form-6a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,#REF!)=0,\"\",COUNT(D21:J21,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L21","v":""},{"$f":"'Form-6a-(1)'!M21","v":""},{"$f":"'Form-6a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,#REF!)=0,\"\",COUNT(D22:J22,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L22","v":""},{"$f":"'Form-6a-(1)'!M22","v":""},{"$f":"'Form-6a-(1)'!N22","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,#REF!)=0,\"\",COUNT(D23:J23,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L23","v":""},{"$f":"'Form-6a-(1)'!M23","v":""},{"$f":"'Form-6a-(1)'!N23","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,#REF!)=0,\"\",COUNT(D25:J25,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L25","v":""},{"$f":"'Form-6a-(1)'!M25","v":""},{"$f":"'Form-6a-(1)'!N25","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,#REF!)=0,\"\",COUNT(D26:J26,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L26","v":""},{"$f":"'Form-6a-(1)'!M26","v":""},{"$f":"'Form-6a-(1)'!N26","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,#REF!)=0,\"\",COUNT(D27:J27,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L27","v":""},{"$f":"'Form-6a-(1)'!M27","v":""},{"$f":"'Form-6a-(1)'!N27","v":""},null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,#REF!)=0,\"\",COUNT(D28:J28,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L28","v":""},{"$f":"'Form-6a-(1)'!M28","v":""},{"$f":"'Form-6a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,#REF!)=0,\"\",COUNT(D29:J29,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L29","v":""},{"$f":"'Form-6a-(1)'!M29","v":""},{"$f":"'Form-6a-(1)'!N29","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,#REF!)=0,\"\",COUNT(D30:J30,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L30","v":""},{"$f":"'Form-6a-(1)'!M30","v":""},{"$f":"'Form-6a-(1)'!N30","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,#REF!)=0,\"\",COUNT(D32:J32,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L32","v":""},{"$f":"'Form-6a-(1)'!M32","v":""},{"$f":"'Form-6a-(1)'!N32","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,#REF!)=0,\"\",COUNT(D33:J33,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L33","v":""},{"$f":"'Form-6a-(1)'!M33","v":""},{"$f":"'Form-6a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,#REF!)=0,\"\",COUNT(D34:J34,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L34","v":""},{"$f":"'Form-6a-(1)'!M34","v":""},{"$f":"'Form-6a-(1)'!N34","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,#REF!)=0,\"\",COUNT(D35:J35,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L35","v":""},{"$f":"'Form-6a-(1)'!M35","v":""},{"$f":"'Form-6a-(1)'!N35","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6a-(6)","index":21,"n_rows":40,"n_cols":18,"rows_kept":40,"cut":false,"hidden":true,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[7,1,7,13],[10,13,14,13],[10,10,14,10],[10,11,14,11],[10,12,14,12],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR GROUND WATER (Based on Tier 2 investigation;   All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,"Number of Detects","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)"]
[null,"Last Sampling Event"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,#REF!)=0,\"\",COUNT(D17:J17,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L17","v":""},{"$f":"'Form-6a-(1)'!M17","v":""},{"$f":"'Form-6a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,#REF!)=0,\"\",COUNT(D18:J18,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L18","v":""},{"$f":"'Form-6a-(1)'!M18","v":""},{"$f":"'Form-6a-(1)'!N18","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,#REF!)=0,\"\",COUNT(D19:J19,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L19","v":""},{"$f":"'Form-6a-(1)'!M19","v":""},{"$f":"'Form-6a-(1)'!N19","v":""},null,null,{"$f":"COUNTIF(D19:N19,\"fp\")","v":0},{"$f":"IF(Q19>0,ESOL1,IF(COUNT(D19:N19)=0,\"--\",MAX(D19:N19)))","v":"--"}]
[null,"Xylenes",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,#REF!)=0,\"\",COUNT(D20:J20,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L20","v":""},{"$f":"'Form-6a-(1)'!M20","v":""},{"$f":"'Form-6a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,#REF!)=0,\"\",COUNT(D21:J21,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L21","v":""},{"$f":"'Form-6a-(1)'!M21","v":""},{"$f":"'Form-6a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,#REF!)=0,\"\",COUNT(D22:J22,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L22","v":""},{"$f":"'Form-6a-(1)'!M22","v":""},{"$f":"'Form-6a-(1)'!N22","v":""}]
[null,"Naphthalene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:J23,#REF!)=0,\"\",COUNT(D23:J23,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L23","v":""},{"$f":"'Form-6a-(1)'!M23","v":""},{"$f":"'Form-6a-(1)'!N23","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,#REF!)=0,\"\",COUNT(D25:J25,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L25","v":""},{"$f":"'Form-6a-(1)'!M25","v":""},{"$f":"'Form-6a-(1)'!N25","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,#REF!)=0,\"\",COUNT(D26:J26,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L26","v":""},{"$f":"'Form-6a-(1)'!M26","v":""},{"$f":"'Form-6a-(1)'!N26","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,#REF!)=0,\"\",COUNT(D27:J27,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L27","v":""},{"$f":"'Form-6a-(1)'!M27","v":""},{"$f":"'Form-6a-(1)'!N27","v":""},null,null,{"$f":"COUNTIF(D26:N26,\"fp\")","v":0},{"$f":"IF(Q27>0,ESOL3,IF(COUNT(D26:N26)=0,\"--\",MAX(D26:N26)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,#REF!)=0,\"\",COUNT(D28:J28,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L28","v":""},{"$f":"'Form-6a-(1)'!M28","v":""},{"$f":"'Form-6a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,#REF!)=0,\"\",COUNT(D29:J29,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L29","v":""},{"$f":"'Form-6a-(1)'!M29","v":""},{"$f":"'Form-6a-(1)'!N29","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:J30,#REF!)=0,\"\",COUNT(D30:J30,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L30","v":""},{"$f":"'Form-6a-(1)'!M30","v":""},{"$f":"'Form-6a-(1)'!N30","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,#REF!)=0,\"\",COUNT(D32:J32,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L32","v":""},{"$f":"'Form-6a-(1)'!M32","v":""},{"$f":"'Form-6a-(1)'!N32","v":""},null,null,{"$f":"COUNTIF(D32:N32,\"fp\")","v":0},{"$f":"IF(Q32>0,ESOL4,IF(COUNT(D32:N32)=0,\"--\",MAX(D32:N32)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,#REF!)=0,\"\",COUNT(D33:J33,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L33","v":""},{"$f":"'Form-6a-(1)'!M33","v":""},{"$f":"'Form-6a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,#REF!)=0,\"\",COUNT(D34:J34,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L34","v":""},{"$f":"'Form-6a-(1)'!M34","v":""},{"$f":"'Form-6a-(1)'!N34","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "},null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D35:J35,#REF!)=0,\"\",COUNT(D35:J35,#REF!,#REF!))","v":""},{"$f":"'Form-6a-(1)'!L35","v":""},{"$f":"'Form-6a-(1)'!M35","v":""},{"$f":"'Form-6a-(1)'!N35","v":""}]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachment:  Site map showing location(s) of monitoring well(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-6b-(1)","index":22,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,36,2],[7,1,7,11],[8,1,8,11],[10,3,10,5],[10,6,10,8],[10,9,10,11],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR WATER QA/QC SAMPLES (Based on Tier 2 investigation;  All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,null,"Field Blanks",null,null,"Trip Blanks"]
[null,"Sample Designation"]
[null,"Sample Date"]
[null,"Field Blank Exposure Time (min)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene"]
[null,"Toluene"]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D18:L18,\"fp\")","v":0},{"$f":"IF(O18>0,ESOL1,IF(COUNT(D18:L18)=0,\"--\",MAX(D18:L18)))","v":"--"}]
[null,"Xylenes"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"Naphthalene"]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)"]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:L25,\"fp\")","v":0},{"$f":"IF(O26>0,ESOL3,IF(COUNT(D25:L25)=0,\"--\",MAX(D25:L25)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D31:L31,\"fp\")","v":0},{"$f":"IF(O31>0,ESOL4,IF(COUNT(D31:L31)=0,\"--\",MAX(D31:L31)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-6b-(2)","index":23,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,36,2],[7,1,7,11],[8,1,8,11],[10,3,10,5],[10,6,10,8],[10,9,10,11],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR WATER QA/QC SAMPLES (Based on Tier 2 investigation;  All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,null,"Field Blanks",null,null,"Trip Blanks"]
[null,"Sample Designation"]
[null,"Sample Date"]
[null,"Field Blank Exposure Time (min)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene"]
[null,"Toluene"]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D18:L18,\"fp\")","v":0},{"$f":"IF(O18>0,ESOL1,IF(COUNT(D18:L18)=0,\"--\",MAX(D18:L18)))","v":"--"}]
[null,"Xylenes"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"Naphthalene"]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)"]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:L25,\"fp\")","v":0},{"$f":"IF(O26>0,ESOL3,IF(COUNT(D25:L25)=0,\"--\",MAX(D25:L25)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D31:L31,\"fp\")","v":0},{"$f":"IF(O31>0,ESOL4,IF(COUNT(D31:L31)=0,\"--\",MAX(D31:L31)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-6b-(3)","index":24,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,36,2],[7,1,7,11],[8,1,8,11],[10,3,10,5],[10,6,10,8],[10,9,10,11],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR WATER QA/QC SAMPLES (Based on Tier 2 investigation;  All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,null,"Field Blanks",null,null,"Trip Blanks"]
[null,"Sample Designation"]
[null,"Sample Date"]
[null,"Field Blank Exposure Time (min)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene"]
[null,"Toluene"]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D18:L18,\"fp\")","v":0},{"$f":"IF(O18>0,ESOL1,IF(COUNT(D18:L18)=0,\"--\",MAX(D18:L18)))","v":"--"}]
[null,"Xylenes"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"Naphthalene"]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)"]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:L25,\"fp\")","v":0},{"$f":"IF(O26>0,ESOL3,IF(COUNT(D25:L25)=0,\"--\",MAX(D25:L25)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D31:L31,\"fp\")","v":0},{"$f":"IF(O31>0,ESOL4,IF(COUNT(D31:L31)=0,\"--\",MAX(D31:L31)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-6b-(4)","index":25,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,36,2],[7,1,7,11],[8,1,8,11],[10,3,10,5],[10,6,10,8],[10,9,10,11],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR WATER QA/QC SAMPLES (Based on Tier 2 investigation;  All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,null,"Field Blanks",null,null,"Trip Blanks"]
[null,"Sample Designation"]
[null,"Sample Date"]
[null,"Field Blank Exposure Time (min)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene"]
[null,"Toluene"]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D18:L18,\"fp\")","v":0},{"$f":"IF(O18>0,ESOL1,IF(COUNT(D18:L18)=0,\"--\",MAX(D18:L18)))","v":"--"}]
[null,"Xylenes"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"Naphthalene"]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)"]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:L25,\"fp\")","v":0},{"$f":"IF(O26>0,ESOL3,IF(COUNT(D25:L25)=0,\"--\",MAX(D25:L25)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D31:L31,\"fp\")","v":0},{"$f":"IF(O31>0,ESOL4,IF(COUNT(D31:L31)=0,\"--\",MAX(D31:L31)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-6b-(5)","index":26,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[33,1,33,2],[35,1,36,2],[7,1,7,11],[8,1,8,11],[10,3,10,5],[10,6,10,8],[10,9,10,11],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 6b  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR WATER QA/QC SAMPLES (Based on Tier 2 investigation;  All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,null,"Field Blanks",null,null,"Trip Blanks"]
[null,"Sample Designation"]
[null,"Sample Date"]
[null,"Field Blank Exposure Time (min)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene"]
[null,"Toluene"]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D18:L18,\"fp\")","v":0},{"$f":"IF(O18>0,ESOL1,IF(COUNT(D18:L18)=0,\"--\",MAX(D18:L18)))","v":"--"}]
[null,"Xylenes"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"Naphthalene"]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)"]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:L25,\"fp\")","v":0},{"$f":"IF(O26>0,ESOL3,IF(COUNT(D25:L25)=0,\"--\",MAX(D25:L25)))","v":"--"}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C28=\"\",\"\",'Form-6a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C29=\"\",\"\",'Form-6a-(1)'!C29)","v":""}]
[null,"TEH as",{"$f":"IF('Form-6a-(1)'!C30=\"\",\"\",'Form-6a-(1)'!C30)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-6a-(1)'!B32:C32=\"\",\"  \",'Form-6a-(1)'!B32:C32)","v":"  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D31:L31,\"fp\")","v":0},{"$f":"IF(O31>0,ESOL4,IF(COUNT(D31:L31)=0,\"--\",MAX(D31:L31)))","v":"--"}]
[null,{"$f":"IF('Form-6a-(1)'!B33:C33=\"\",\"  \",'Form-6a-(1)'!B33:C33)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B34:C34=\"\",\"  \",'Form-6a-(1)'!B34:C34)","v":"  "}]
[null,{"$f":"IF('Form-6a-(1)'!B35:C35=\"\",\"  \",'Form-6a-(1)'!B35:C35)","v":"  "}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp. (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical datasheets not previously submitted to the Department.  Add additional sheets as needed."]
[]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-7-(1)","index":27,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[32,1,32,2],[30,1,30,2],[31,1,31,2],[29,1,29,2],[7,1,7,15],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,12,12,12],[8,1,8,15]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 7  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SOIL GAS SAMPLES (Based on Tier 2 investigation;   All concentrations in mg/m3)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,null,null,null,null,null,null,null,null,null,"No. of      Detection (s)","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,{"$f":"IF('Form-6a-(1)'!B17=\"\",\"\",'Form-6a-(1)'!B17)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:L15,'Form-7-(2)'!D15:L15,'Form-7-(3)'!D15:L15,'Form-7-(4)'!D15:L15)=0,\"\",COUNT(D15:L15,'Form-7-(2)'!D15:L15,'Form-7-(3)'!D15:L15,'Form-7-(4)'!D15:L15))","v":""},{"$f":"IF(M15=\"\",\"\",AVERAGE(D15:L15,'Form-7-(2)'!D15:L15,'Form-7-(3)'!D15:L15,'Form-7-(4)'!D15:L15))","v":""},{"$f":"IF(M15=\"\",\"\",MAX(D15:L15,'Form-7-(2)'!D15:L15,'Form-7-(3)'!D15:L15,'Form-7-(4)'!D15:L15))","v":""},{"$f":"IF(OR((N15=\"\"),(O15=\"\")),\"\",O15/N15)","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B18=\"\",\"\",'Form-6a-(1)'!B18)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D16:L16,'Form-7-(2)'!D16:L16,'Form-7-(3)'!D16:L16,'Form-7-(4)'!D16:L16)=0,\"\",COUNT(D16:L16,'Form-7-(2)'!D16:L16,'Form-7-(3)'!D16:L16,'Form-7-(4)'!D16:L16))","v":""},{"$f":"IF(M16=\"\",\"\",AVERAGE(D16:L16,'Form-7-(2)'!D16:L16,'Form-7-(3)'!D16:L16,'Form-7-(4)'!D16:L16))","v":""},{"$f":"IF(M16=\"\",\"\",MAX(D16:L16,'Form-7-(2)'!D16:L16,'Form-7-(3)'!D16:L16,'Form-7-(4)'!D16:L16))","v":""},{"$f":"IF(OR((N16=\"\"),(O16=\"\")),\"\",O16/N16)","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B19=\"\",\"\",'Form-6a-(1)'!B19)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:L17,'Form-7-(2)'!D17:L17,'Form-7-(3)'!D17:L17,'Form-7-(4)'!D17:L17)=0,\"\",COUNT(D17:L17,'Form-7-(2)'!D17:L17,'Form-7-(3)'!D17:L17,'Form-7-(4)'!D17:L17))","v":""},{"$f":"IF(M17=\"\",\"\",AVERAGE(D17:L17,'Form-7-(2)'!D17:L17,'Form-7-(3)'!D17:L17,'Form-7-(4)'!D17:L17))","v":""},{"$f":"IF(M17=\"\",\"\",MAX(D17:L17,'Form-7-(2)'!D17:L17,'Form-7-(3)'!D17:L17,'Form-7-(4)'!D17:L17))","v":""},""]
[null,{"$f":"IF('Form-6a-(1)'!B20=\"\",\"\",'Form-6a-(1)'!B20)","v":"Xylenes"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:L18,'Form-7-(2)'!D18:L18,'Form-7-(3)'!D18:L18,'Form-7-(4)'!D18:L18)=0,\"\",COUNT(D18:L18,'Form-7-(2)'!D18:L18,'Form-7-(3)'!D18:L18,'Form-7-(4)'!D18:L18))","v":""},{"$f":"IF(M18=\"\",\"\",AVERAGE(D18:L18,'Form-7-(2)'!D18:L18,'Form-7-(3)'!D18:L18,'Form-7-(4)'!D18:L18))","v":""},{"$f":"IF(M18=\"\",\"\",MAX(D18:L18,'Form-7-(2)'!D18:L18,'Form-7-(3)'!D18:L18,'Form-7-(4)'!D18:L18))","v":""},""]
[null,{"$f":"IF('Form-6a-(1)'!B21=\"\",\"\",'Form-6a-(1)'!B21)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:L19,'Form-7-(2)'!D19:L19,'Form-7-(3)'!D19:L19,'Form-7-(4)'!D19:L19)=0,\"\",COUNT(D19:L19,'Form-7-(2)'!D19:L19,'Form-7-(3)'!D19:L19,'Form-7-(4)'!D19:L19))","v":""},{"$f":"IF(M19=\"\",\"\",AVERAGE(D19:L19,'Form-7-(2)'!D19:L19,'Form-7-(3)'!D19:L19,'Form-7-(4)'!D19:L19))","v":""},{"$f":"IF(M19=\"\",\"\",MAX(D19:L19,'Form-7-(2)'!D19:L19,'Form-7-(3)'!D19:L19,'Form-7-(4)'!D19:L19))","v":""},""]
[null,{"$f":"IF('Form-6a-(1)'!B22=\"\",\"\",'Form-6a-(1)'!B22)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:L20,'Form-7-(2)'!D20:L20,'Form-7-(3)'!D20:L20,'Form-7-(4)'!D20:L20)=0,\"\",COUNT(D20:L20,'Form-7-(2)'!D20:L20,'Form-7-(3)'!D20:L20,'Form-7-(4)'!D20:L20))","v":""},{"$f":"IF(M20=\"\",\"\",AVERAGE(D20:L20,'Form-7-(2)'!D20:L20,'Form-7-(3)'!D20:L20,'Form-7-(4)'!D20:L20))","v":""},{"$f":"IF(M20=\"\",\"\",MAX(D20:L20,'Form-7-(2)'!D20:L20,'Form-7-(3)'!D20:L20,'Form-7-(4)'!D20:L20))","v":""},""]
[null,{"$f":"IF('Form-6a-(1)'!B23=\"\",\"\",'Form-6a-(1)'!B23)","v":"Naphthalene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:L21,'Form-7-(2)'!D21:L21,'Form-7-(3)'!D21:L21,'Form-7-(4)'!D21:L21)=0,\"\",COUNT(D21:L21,'Form-7-(2)'!D21:L21,'Form-7-(3)'!D21:L21,'Form-7-(4)'!D21:L21))","v":""},{"$f":"IF(M21=\"\",\"\",AVERAGE(D21:L21,'Form-7-(2)'!D21:L21,'Form-7-(3)'!D21:L21,'Form-7-(4)'!D21:L21))","v":""},{"$f":"IF(M21=\"\",\"\",MAX(D21:L21,'Form-7-(2)'!D21:L21,'Form-7-(3)'!D21:L21,'Form-7-(4)'!D21:L21))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"]
[null,{"$f":"IF('Form-6a-(1)'!B25=\"\",\"\",'Form-6a-(1)'!B25)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:L23,'Form-7-(2)'!D23:L23,'Form-7-(3)'!D23:L23,'Form-7-(4)'!D23:L23)=0,\"\",COUNT(D23:L23,'Form-7-(2)'!D23:L23,'Form-7-(3)'!D23:L23,'Form-7-(4)'!D23:L23))","v":""},{"$f":"IF(M23=\"\",\"\",AVERAGE(D23:L23,'Form-7-(2)'!D23:L23,'Form-7-(3)'!D23:L23,'Form-7-(4)'!D23:L23))","v":""},{"$f":"IF(M23=\"\",\"\",MAX(D23:L23,'Form-7-(2)'!D23:L23,'Form-7-(3)'!D23:L23,'Form-7-(4)'!D23:L23))","v":""},{"$f":"IF(OR((N23=\"\"),(O23=\"\")),\"\",O23/N23)","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B26=\"\",\"\",'Form-6a-(1)'!B26)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D24:L24,'Form-7-(2)'!D24:L24,'Form-7-(3)'!D24:L24,'Form-7-(4)'!D24:L24)=0,\"\",COUNT(D24:L24,'Form-7-(2)'!D24:L24,'Form-7-(3)'!D24:L24,'Form-7-(4)'!D24:L24))","v":""},{"$f":"IF(M24=\"\",\"\",AVERAGE(D24:L24,'Form-7-(2)'!D24:L24,'Form-7-(3)'!D24:L24,'Form-7-(4)'!D24:L24))","v":""},{"$f":"IF(M24=\"\",\"\",MAX(D24:L24,'Form-7-(2)'!D24:L24,'Form-7-(3)'!D24:L24,'Form-7-(4)'!D24:L24))","v":""},""]
[null,{"$f":"IF('Form-6a-(1)'!B27=\"\",\"\",'Form-6a-(1)'!B27)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:L25,'Form-7-(2)'!D25:L25,'Form-7-(3)'!D25:L25,'Form-7-(4)'!D25:L25)=0,\"\",COUNT(D25:L25,'Form-7-(2)'!D25:L25,'Form-7-(3)'!D25:L25,'Form-7-(4)'!D25:L25))","v":""},{"$f":"IF(M25=\"\",\"\",AVERAGE(D25:L25,'Form-7-(2)'!D25:L25,'Form-7-(3)'!D25:L25,'Form-7-(4)'!D25:L25))","v":""},{"$f":"IF(M25=\"\",\"\",MAX(D25:L25,'Form-7-(2)'!D25:L25,'Form-7-(3)'!D25:L25,'Form-7-(4)'!D25:L25))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:L26,'Form-7-(2)'!D26:L26,'Form-7-(3)'!D26:L26,'Form-7-(4)'!D26:L26)=0,\"\",COUNT(D26:L26,'Form-7-(2)'!D26:L26,'Form-7-(3)'!D26:L26,'Form-7-(4)'!D26:L26))","v":""},{"$f":"IF(M26=\"\",\"\",AVERAGE(D26:L26,'Form-7-(2)'!D26:L26,'Form-7-(3)'!D26:L26,'Form-7-(4)'!D26:L26))","v":""},{"$f":"IF(M26=\"\",\"\",MAX(D26:L26,'Form-7-(2)'!D26:L26,'Form-7-(3)'!D26:L26,'Form-7-(4)'!D26:L26))","v":""},""]
[" ","TEH as",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:L27,'Form-7-(2)'!D27:L27,'Form-7-(3)'!D27:L27,'Form-7-(4)'!D27:L27)=0,\"\",COUNT(D27:L27,'Form-7-(2)'!D27:L27,'Form-7-(3)'!D27:L27,'Form-7-(4)'!D27:L27))","v":""},{"$f":"IF(M27=\"\",\"\",AVERAGE(D27:L27,'Form-7-(2)'!D27:L27,'Form-7-(3)'!D27:L27,'Form-7-(4)'!D27:L27))","v":""},{"$f":"IF(M27=\"\",\"\",MAX(D27:L27,'Form-7-(2)'!D27:L27,'Form-7-(3)'!D27:L27,'Form-7-(4)'!D27:L27))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:L28,'Form-7-(2)'!D28:L28,'Form-7-(3)'!D28:L28,'Form-7-(4)'!D28:L28)=0,\"\",COUNT(D28:L28,'Form-7-(2)'!D28:L28,'Form-7-(3)'!D28:L28,'Form-7-(4)'!D28:L28))","v":""},{"$f":"IF(M28=\"\",\"\",AVERAGE(D28:L28,'Form-7-(2)'!D28:L28,'Form-7-(3)'!D28:L28,'Form-7-(4)'!D28:L28))","v":""},{"$f":"IF(M28=\"\",\"\",MAX(D28:L28,'Form-7-(2)'!D28:L28,'Form-7-(3)'!D28:L28,'Form-7-(4)'!D28:L28))","v":""},""]
[null,"OTHER ANALYTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:L30,'Form-7-(2)'!D30:L30,'Form-7-(3)'!D30:L30,'Form-7-(4)'!D30:L30)=0,\"\",COUNT(D30:L30,'Form-7-(2)'!D30:L30,'Form-7-(3)'!D30:L30,'Form-7-(4)'!D30:L30))","v":""},{"$f":"IF(M30=\"\",\"\",AVERAGE(D30:L30,'Form-7-(2)'!D30:L30,'Form-7-(3)'!D30:L30,'Form-7-(4)'!D30:L30))","v":""},{"$f":"IF(M30=\"\",\"\",MAX(D30:L30,'Form-7-(2)'!D30:L30,'Form-7-(3)'!D30:L30,'Form-7-(4)'!D30:L30))","v":""},{"$f":"IF(OR((N30=\"\"),(O30=\"\")),\"\",O30/N30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D31:L31,'Form-7-(2)'!D31:L31,'Form-7-(3)'!D31:L31,'Form-7-(4)'!D31:L31)=0,\"\",COUNT(D31:L31,'Form-7-(2)'!D31:L31,'Form-7-(3)'!D31:L31,'Form-7-(4)'!D31:L31))","v":""},{"$f":"IF(M31=\"\",\"\",AVERAGE(D31:L31,'Form-7-(2)'!D31:L31,'Form-7-(3)'!D31:L31,'Form-7-(4)'!D31:L31))","v":""},{"$f":"IF(M31=\"\",\"\",MAX(D31:L31,'Form-7-(2)'!D31:L31,'Form-7-(3)'!D31:L31,'Form-7-(4)'!D31:L31))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:L32,'Form-7-(2)'!D32:L32,'Form-7-(3)'!D32:L32,'Form-7-(4)'!D32:L32)=0,\"\",COUNT(D32:L32,'Form-7-(2)'!D32:L32,'Form-7-(3)'!D32:L32,'Form-7-(4)'!D32:L32))","v":""},{"$f":"IF(M32=\"\",\"\",AVERAGE(D32:L32,'Form-7-(2)'!D32:L32,'Form-7-(3)'!D32:L32,'Form-7-(4)'!D32:L32))","v":""},{"$f":"IF(M32=\"\",\"\",MAX(D32:L32,'Form-7-(2)'!D32:L32,'Form-7-(3)'!D32:L32,'Form-7-(4)'!D32:L32))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:L33,'Form-7-(2)'!D33:L33,'Form-7-(3)'!D33:L33,'Form-7-(4)'!D33:L33)=0,\"\",COUNT(D33:L33,'Form-7-(2)'!D33:L33,'Form-7-(3)'!D33:L33,'Form-7-(4)'!D33:L33))","v":""},{"$f":"IF(M33=\"\",\"\",AVERAGE(D33:L33,'Form-7-(2)'!D33:L33,'Form-7-(3)'!D33:L33,'Form-7-(4)'!D33:L33))","v":""},{"$f":"IF(M33=\"\",\"\",MAX(D33:L33,'Form-7-(2)'!D33:L33,'Form-7-(3)'!D33:L33,'Form-7-(4)'!D33:L33))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C34:L34)=0,\"\",COUNT(C34:L34))","v":""},{"$f":"IF(COUNT(C34:L34)=0,\"\",AVERAGE(C34:L34))","v":""},{"$f":"IF(M34=\"\",\"\",MAX(C34:L34))","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,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of soil gas sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-7-(2)","index":28,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[32,1,32,2],[30,1,30,2],[31,1,31,2],[29,1,29,2],[7,1,7,15],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,12,12,12],[8,1,8,15]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 7  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SOIL GAS SAMPLES (Based on Tier 2 investigation;   All concentrations in mg/m3)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,null,null,null,null,null,null,null,null,null,"No. of      Detection (s)","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,{"$f":"IF('Form-6a-(1)'!B17=\"\",\"\",'Form-6a-(1)'!B17)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:L15,#REF!)=0,\"\",COUNT(D15:L15,#REF!))","v":""},{"$f":"'Form-7-(1)'!N15","v":""},{"$f":"'Form-7-(1)'!O15","v":""},{"$f":"'Form-7-(1)'!P15","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B18=\"\",\"\",'Form-6a-(1)'!B18)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D16:L16,#REF!)=0,\"\",COUNT(D16:L16,#REF!))","v":""},{"$f":"'Form-7-(1)'!N16","v":""},{"$f":"'Form-7-(1)'!O16","v":""},{"$f":"'Form-7-(1)'!P16","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B19=\"\",\"\",'Form-6a-(1)'!B19)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:L17,#REF!)=0,\"\",COUNT(D17:L17,#REF!))","v":""},{"$f":"'Form-7-(1)'!N17","v":""},{"$f":"'Form-7-(1)'!O17","v":""},{"$f":"'Form-7-(1)'!P17","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B20=\"\",\"\",'Form-6a-(1)'!B20)","v":"Xylenes"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:L18,#REF!)=0,\"\",COUNT(D18:L18,#REF!))","v":""},{"$f":"'Form-7-(1)'!N18","v":""},{"$f":"'Form-7-(1)'!O18","v":""},{"$f":"'Form-7-(1)'!P18","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B21=\"\",\"\",'Form-6a-(1)'!B21)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:L19,#REF!)=0,\"\",COUNT(D19:L19,#REF!))","v":""},{"$f":"'Form-7-(1)'!N19","v":""},{"$f":"'Form-7-(1)'!O19","v":""},{"$f":"'Form-7-(1)'!P19","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B22=\"\",\"\",'Form-6a-(1)'!B22)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:L20,#REF!)=0,\"\",COUNT(D20:L20,#REF!))","v":""},{"$f":"'Form-7-(1)'!N20","v":""},{"$f":"'Form-7-(1)'!O20","v":""},{"$f":"'Form-7-(1)'!P20","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B23=\"\",\"\",'Form-6a-(1)'!B23)","v":"Naphthalene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:L21,#REF!)=0,\"\",COUNT(D21:L21,#REF!))","v":""},{"$f":"'Form-7-(1)'!N21","v":""},{"$f":"'Form-7-(1)'!O21","v":""},{"$f":"'Form-7-(1)'!P21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:L22,#REF!)=0,\"\",COUNT(C22:L22,#REF!))","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B25=\"\",\"\",'Form-6a-(1)'!B25)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:L23,#REF!)=0,\"\",COUNT(D23:L23,#REF!))","v":""},{"$f":"'Form-7-(1)'!N23","v":""},{"$f":"'Form-7-(1)'!O23","v":""},{"$f":"'Form-7-(1)'!P23","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B26=\"\",\"\",'Form-6a-(1)'!B26)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D24:L24,#REF!)=0,\"\",COUNT(D24:L24,#REF!))","v":""},{"$f":"'Form-7-(1)'!N24","v":""},{"$f":"'Form-7-(1)'!O24","v":""},{"$f":"'Form-7-(1)'!P24","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B27=\"\",\"\",'Form-6a-(1)'!B27)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:L25,#REF!)=0,\"\",COUNT(D25:L25,#REF!))","v":""},{"$f":"'Form-7-(1)'!N25","v":""},{"$f":"'Form-7-(1)'!O25","v":""},{"$f":"'Form-7-(1)'!P25","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C26=\"\",\"\",'Form-7-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:L26,#REF!)=0,\"\",COUNT(D26:L26,#REF!))","v":""},{"$f":"'Form-7-(1)'!N26","v":""},{"$f":"'Form-7-(1)'!O26","v":""},{"$f":"'Form-7-(1)'!P26","v":""}]
[" ","TEH as",{"$f":"IF('Form-7-(1)'!C27=\"\",\"\",'Form-7-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:L27,#REF!)=0,\"\",COUNT(D27:L27,#REF!))","v":""},{"$f":"'Form-7-(1)'!N27","v":""},{"$f":"'Form-7-(1)'!O27","v":""},{"$f":"'Form-7-(1)'!P27","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C28=\"\",\"\",'Form-7-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:L28,#REF!)=0,\"\",COUNT(D28:L28,#REF!))","v":""},{"$f":"'Form-7-(1)'!N28","v":""},{"$f":"'Form-7-(1)'!O28","v":""},{"$f":"'Form-7-(1)'!P28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-7-(1)'!B30=\"\",\"\",'Form-7-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:L30,#REF!)=0,\"\",COUNT(D30:L30,#REF!))","v":""},{"$f":"'Form-7-(1)'!N30","v":""},{"$f":"'Form-7-(1)'!O30","v":""},{"$f":"'Form-7-(1)'!P30","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B31=\"\",\"\",'Form-7-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D31:L31,#REF!)=0,\"\",COUNT(D31:L31,#REF!))","v":""},{"$f":"'Form-7-(1)'!N31","v":""},{"$f":"'Form-7-(1)'!O31","v":""},{"$f":"'Form-7-(1)'!P31","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B32=\"\",\"\",'Form-7-(1)'!B32)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:L32,#REF!)=0,\"\",COUNT(D32:L32,#REF!))","v":""},{"$f":"'Form-7-(1)'!N32","v":""},{"$f":"'Form-7-(1)'!O32","v":""},{"$f":"'Form-7-(1)'!P32","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B33=\"\",\"\",'Form-7-(1)'!B33)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:L33,#REF!)=0,\"\",COUNT(D33:L33,#REF!))","v":""},{"$f":"'Form-7-(1)'!N33","v":""},{"$f":"'Form-7-(1)'!O33","v":""},{"$f":"'Form-7-(1)'!P33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C34:L34)=0,\"\",COUNT(C34:L34))","v":""},{"$f":"IF(COUNT(C34:L34)=0,\"\",AVERAGE(C34:L34))","v":""},{"$f":"IF(M34=\"\",\"\",MAX(C34:L34))","v":""},{"$f":"IF(OR((N34=\"\"),(O34=\"\")),\"\",O34/N34)","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,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of soil gas sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-7-(3)","index":29,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[32,1,32,2],[30,1,30,2],[31,1,31,2],[29,1,29,2],[7,1,7,15],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,12,12,12],[8,1,8,15]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 7  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SOIL GAS SAMPLES (Based on Tier 2 investigation;   All concentrations in mg/m3)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,null,null,null,null,null,null,null,null,null,"No. of      Detection (s)","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,{"$f":"IF('Form-6a-(1)'!B17=\"\",\"\",'Form-6a-(1)'!B17)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:L15,#REF!)=0,\"\",COUNT(D15:L15,#REF!))","v":""},{"$f":"'Form-7-(1)'!N15","v":""},{"$f":"'Form-7-(1)'!O15","v":""},{"$f":"'Form-7-(1)'!P15","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B18=\"\",\"\",'Form-6a-(1)'!B18)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D16:L16,#REF!)=0,\"\",COUNT(D16:L16,#REF!))","v":""},{"$f":"'Form-7-(1)'!N16","v":""},{"$f":"'Form-7-(1)'!O16","v":""},{"$f":"'Form-7-(1)'!P16","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B19=\"\",\"\",'Form-6a-(1)'!B19)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:L17,#REF!)=0,\"\",COUNT(D17:L17,#REF!))","v":""},{"$f":"'Form-7-(1)'!N17","v":""},{"$f":"'Form-7-(1)'!O17","v":""},{"$f":"'Form-7-(1)'!P17","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B20=\"\",\"\",'Form-6a-(1)'!B20)","v":"Xylenes"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:L18,#REF!)=0,\"\",COUNT(D18:L18,#REF!))","v":""},{"$f":"'Form-7-(1)'!N18","v":""},{"$f":"'Form-7-(1)'!O18","v":""},{"$f":"'Form-7-(1)'!P18","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B21=\"\",\"\",'Form-6a-(1)'!B21)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:L19,#REF!)=0,\"\",COUNT(D19:L19,#REF!))","v":""},{"$f":"'Form-7-(1)'!N19","v":""},{"$f":"'Form-7-(1)'!O19","v":""},{"$f":"'Form-7-(1)'!P19","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B22=\"\",\"\",'Form-6a-(1)'!B22)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:L20,#REF!)=0,\"\",COUNT(D20:L20,#REF!))","v":""},{"$f":"'Form-7-(1)'!N20","v":""},{"$f":"'Form-7-(1)'!O20","v":""},{"$f":"'Form-7-(1)'!P20","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B23=\"\",\"\",'Form-6a-(1)'!B23)","v":"Naphthalene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:L21,#REF!)=0,\"\",COUNT(D21:L21,#REF!))","v":""},{"$f":"'Form-7-(1)'!N21","v":""},{"$f":"'Form-7-(1)'!O21","v":""},{"$f":"'Form-7-(1)'!P21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:L22,#REF!)=0,\"\",COUNT(C22:L22,#REF!))","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B25=\"\",\"\",'Form-6a-(1)'!B25)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:L23,#REF!)=0,\"\",COUNT(D23:L23,#REF!))","v":""},{"$f":"'Form-7-(1)'!N23","v":""},{"$f":"'Form-7-(1)'!O23","v":""},{"$f":"'Form-7-(1)'!P23","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B26=\"\",\"\",'Form-6a-(1)'!B26)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D24:L24,#REF!)=0,\"\",COUNT(D24:L24,#REF!))","v":""},{"$f":"'Form-7-(1)'!N24","v":""},{"$f":"'Form-7-(1)'!O24","v":""},{"$f":"'Form-7-(1)'!P24","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B27=\"\",\"\",'Form-6a-(1)'!B27)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:L25,#REF!)=0,\"\",COUNT(D25:L25,#REF!))","v":""},{"$f":"'Form-7-(1)'!N25","v":""},{"$f":"'Form-7-(1)'!O25","v":""},{"$f":"'Form-7-(1)'!P25","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C26=\"\",\"\",'Form-7-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:L26,#REF!)=0,\"\",COUNT(D26:L26,#REF!))","v":""},{"$f":"'Form-7-(1)'!N26","v":""},{"$f":"'Form-7-(1)'!O26","v":""},{"$f":"'Form-7-(1)'!P26","v":""}]
[" ","TEH as",{"$f":"IF('Form-7-(1)'!C27=\"\",\"\",'Form-7-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:L27,#REF!)=0,\"\",COUNT(D27:L27,#REF!))","v":""},{"$f":"'Form-7-(1)'!N27","v":""},{"$f":"'Form-7-(1)'!O27","v":""},{"$f":"'Form-7-(1)'!P27","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C28=\"\",\"\",'Form-7-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:L28,#REF!)=0,\"\",COUNT(D28:L28,#REF!))","v":""},{"$f":"'Form-7-(1)'!N28","v":""},{"$f":"'Form-7-(1)'!O28","v":""},{"$f":"'Form-7-(1)'!P28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-7-(1)'!B30=\"\",\"\",'Form-7-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:L30,#REF!)=0,\"\",COUNT(D30:L30,#REF!))","v":""},{"$f":"'Form-7-(1)'!N30","v":""},{"$f":"'Form-7-(1)'!O30","v":""},{"$f":"'Form-7-(1)'!P30","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B31=\"\",\"\",'Form-7-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D31:L31,#REF!)=0,\"\",COUNT(D31:L31,#REF!))","v":""},{"$f":"'Form-7-(1)'!N31","v":""},{"$f":"'Form-7-(1)'!O31","v":""},{"$f":"'Form-7-(1)'!P31","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B32=\"\",\"\",'Form-7-(1)'!B32)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:L32,#REF!)=0,\"\",COUNT(D32:L32,#REF!))","v":""},{"$f":"'Form-7-(1)'!N32","v":""},{"$f":"'Form-7-(1)'!O32","v":""},{"$f":"'Form-7-(1)'!P32","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B33=\"\",\"\",'Form-7-(1)'!B33)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:L33,#REF!)=0,\"\",COUNT(D33:L33,#REF!))","v":""},{"$f":"'Form-7-(1)'!N33","v":""},{"$f":"'Form-7-(1)'!O33","v":""},{"$f":"'Form-7-(1)'!P33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C34:L34)=0,\"\",COUNT(C34:L34))","v":""},{"$f":"IF(COUNT(C34:L34)=0,\"\",AVERAGE(C34:L34))","v":""},{"$f":"IF(M34=\"\",\"\",MAX(C34:L34))","v":""},{"$f":"IF(OR((N34=\"\"),(O34=\"\")),\"\",O34/N34)","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,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of soil gas sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-7-(4)","index":30,"n_rows":46,"n_cols":16,"rows_kept":46,"cut":false,"hidden":true,"merged":[[32,1,32,2],[30,1,30,2],[31,1,31,2],[29,1,29,2],[7,1,7,15],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,12,12,12],[8,1,8,15]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 2 Investigation Form - 7  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SOIL GAS SAMPLES (Based on Tier 2 investigation;   All concentrations in mg/m3)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,null,null,null,null,null,null,null,null,null,"No. of      Detection (s)","Arithmetic Average","Maximum","Ratio \n(Max. / Avg.) *"]
[null,"Sampling Date"]
[null,"Sample Depth (ft)"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,{"$f":"IF('Form-6a-(1)'!B17=\"\",\"\",'Form-6a-(1)'!B17)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:L15,#REF!)=0,\"\",COUNT(D15:L15,#REF!))","v":""},{"$f":"'Form-7-(1)'!N15","v":""},{"$f":"'Form-7-(1)'!O15","v":""},{"$f":"'Form-7-(1)'!P15","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B18=\"\",\"\",'Form-6a-(1)'!B18)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D16:L16,#REF!)=0,\"\",COUNT(D16:L16,#REF!))","v":""},{"$f":"'Form-7-(1)'!N16","v":""},{"$f":"'Form-7-(1)'!O16","v":""},{"$f":"'Form-7-(1)'!P16","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B19=\"\",\"\",'Form-6a-(1)'!B19)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:L17,#REF!)=0,\"\",COUNT(D17:L17,#REF!))","v":""},{"$f":"'Form-7-(1)'!N17","v":""},{"$f":"'Form-7-(1)'!O17","v":""},{"$f":"'Form-7-(1)'!P17","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B20=\"\",\"\",'Form-6a-(1)'!B20)","v":"Xylenes"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:L18,#REF!)=0,\"\",COUNT(D18:L18,#REF!))","v":""},{"$f":"'Form-7-(1)'!N18","v":""},{"$f":"'Form-7-(1)'!O18","v":""},{"$f":"'Form-7-(1)'!P18","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B21=\"\",\"\",'Form-6a-(1)'!B21)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:L19,#REF!)=0,\"\",COUNT(D19:L19,#REF!))","v":""},{"$f":"'Form-7-(1)'!N19","v":""},{"$f":"'Form-7-(1)'!O19","v":""},{"$f":"'Form-7-(1)'!P19","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B22=\"\",\"\",'Form-6a-(1)'!B22)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:L20,#REF!)=0,\"\",COUNT(D20:L20,#REF!))","v":""},{"$f":"'Form-7-(1)'!N20","v":""},{"$f":"'Form-7-(1)'!O20","v":""},{"$f":"'Form-7-(1)'!P20","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B23=\"\",\"\",'Form-6a-(1)'!B23)","v":"Naphthalene"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:L21,#REF!)=0,\"\",COUNT(D21:L21,#REF!))","v":""},{"$f":"'Form-7-(1)'!N21","v":""},{"$f":"'Form-7-(1)'!O21","v":""},{"$f":"'Form-7-(1)'!P21","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:L22,#REF!)=0,\"\",COUNT(C22:L22,#REF!))","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B25=\"\",\"\",'Form-6a-(1)'!B25)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D23:L23,#REF!)=0,\"\",COUNT(D23:L23,#REF!))","v":""},{"$f":"'Form-7-(1)'!N23","v":""},{"$f":"'Form-7-(1)'!O23","v":""},{"$f":"'Form-7-(1)'!P23","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B26=\"\",\"\",'Form-6a-(1)'!B26)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D24:L24,#REF!)=0,\"\",COUNT(D24:L24,#REF!))","v":""},{"$f":"'Form-7-(1)'!N24","v":""},{"$f":"'Form-7-(1)'!O24","v":""},{"$f":"'Form-7-(1)'!P24","v":""}]
[null,{"$f":"IF('Form-6a-(1)'!B27=\"\",\"\",'Form-6a-(1)'!B27)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:L25,#REF!)=0,\"\",COUNT(D25:L25,#REF!))","v":""},{"$f":"'Form-7-(1)'!N25","v":""},{"$f":"'Form-7-(1)'!O25","v":""},{"$f":"'Form-7-(1)'!P25","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C26=\"\",\"\",'Form-7-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:L26,#REF!)=0,\"\",COUNT(D26:L26,#REF!))","v":""},{"$f":"'Form-7-(1)'!N26","v":""},{"$f":"'Form-7-(1)'!O26","v":""},{"$f":"'Form-7-(1)'!P26","v":""}]
[" ","TEH as",{"$f":"IF('Form-7-(1)'!C27=\"\",\"\",'Form-7-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:L27,#REF!)=0,\"\",COUNT(D27:L27,#REF!))","v":""},{"$f":"'Form-7-(1)'!N27","v":""},{"$f":"'Form-7-(1)'!O27","v":""},{"$f":"'Form-7-(1)'!P27","v":""}]
[null,"TEH as",{"$f":"IF('Form-7-(1)'!C28=\"\",\"\",'Form-7-(1)'!C28)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:L28,#REF!)=0,\"\",COUNT(D28:L28,#REF!))","v":""},{"$f":"'Form-7-(1)'!N28","v":""},{"$f":"'Form-7-(1)'!O28","v":""},{"$f":"'Form-7-(1)'!P28","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-7-(1)'!B30=\"\",\"\",'Form-7-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D30:L30,#REF!)=0,\"\",COUNT(D30:L30,#REF!))","v":""},{"$f":"'Form-7-(1)'!N30","v":""},{"$f":"'Form-7-(1)'!O30","v":""},{"$f":"'Form-7-(1)'!P30","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B31=\"\",\"\",'Form-7-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D31:L31,#REF!)=0,\"\",COUNT(D31:L31,#REF!))","v":""},{"$f":"'Form-7-(1)'!N31","v":""},{"$f":"'Form-7-(1)'!O31","v":""},{"$f":"'Form-7-(1)'!P31","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B32=\"\",\"\",'Form-7-(1)'!B32)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:L32,#REF!)=0,\"\",COUNT(D32:L32,#REF!))","v":""},{"$f":"'Form-7-(1)'!N32","v":""},{"$f":"'Form-7-(1)'!O32","v":""},{"$f":"'Form-7-(1)'!P32","v":""}]
[null,{"$f":"IF('Form-7-(1)'!B33=\"\",\"\",'Form-7-(1)'!B33)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:L33,#REF!)=0,\"\",COUNT(D33:L33,#REF!))","v":""},{"$f":"'Form-7-(1)'!N33","v":""},{"$f":"'Form-7-(1)'!O33","v":""},{"$f":"'Form-7-(1)'!P33","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C34:L34)=0,\"\",COUNT(C34:L34))","v":""},{"$f":"IF(COUNT(C34:L34)=0,\"\",AVERAGE(C34:L34))","v":""},{"$f":"IF(M34=\"\",\"\",MAX(C34:L34))","v":""},{"$f":"IF(OR((N34=\"\"),(O34=\"\")),\"\",O34/N34)","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,"NOTE:"]
[null,"          Provide any laboratory analytical datasheets not previously submitted to the Department."]
[null,"          Non-detects can be expressed as ND, BDL, etc."]
[null,"*  :   If the ratio is high (for example >10) there may be a \"hot spot\" and additional investigation/evaluation may be warranted.  In such circumstances, contact the Department."]
[null,"Recommended Attachments:  Site map showing location(s) of soil gas sample(s), chemical concentration maps, laboratory analysis report(s), chain of custody, and boring logs."]

{"sheet":"Form-8-(1)","index":31,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[[17,1,18,1],[17,2,18,6],[13,2,14,6],[13,1,14,1],[9,1,9,6],[11,1,12,1],[11,2,12,6],[15,1,16,1],[15,2,16,6],[23,1,24,1],[23,2,24,6],[25,1,26,1],[25,2,26,6],[19,1,20,1],[19,2,20,6],[21,1,22,1],[21,2,22,6]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,"Tier 2 Investigation Form - 8  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"REFERENCES AND PROTOCOLS"]

{"sheet":"Form-8-(2)","index":32,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[[15,1,16,1],[15,2,16,6],[23,1,24,1],[23,2,24,6],[25,1,26,1],[25,2,26,6],[17,1,18,1],[17,2,18,6],[19,1,20,1],[19,2,20,6],[21,1,22,1],[21,2,22,6],[13,2,14,6],[13,1,14,1],[9,1,9,6],[11,1,12,1],[11,2,12,6]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,"Tier 2 Investigation Form - 8  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"REFERENCES AND PROTOCOLS"]

{"sheet":"Form-8-(3)","index":33,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[[17,1,18,1],[17,2,18,6],[13,2,14,6],[13,1,14,1],[9,1,9,6],[11,1,12,1],[11,2,12,6],[15,1,16,1],[15,2,16,6],[23,1,24,1],[23,2,24,6],[25,1,26,1],[25,2,26,6],[19,1,20,1],[19,2,20,6],[21,1,22,1],[21,2,22,6]]}
[]
[null,"DWEE RBCA TIER 2 REPORT",null,null,null,null,"Tier 2 Investigation Form - 8  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"DWEE PROGRAM NO.:  "},null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"DWEE FACILITY NO.:  "}]
[]
[null,{"$f":"IF(Cover!E27=\"\",Cover!D27,CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\")))","v":"COMPLETION DATE:"},null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"REFERENCES AND PROTOCOLS"]

{"sheet":"Print2","index":34,"n_rows":15,"n_cols":15,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[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,false]
[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,false]
[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,false]
[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,false]
[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,false]
[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,false]
[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,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]