{"text_format":"1","workbook":"xlsx","n_sheets":35,"sheets":["Title","Cover","Toc","Form-1","Form-2a","Form-2b","Form-3a","Form-3b (1)","Form-3b (2)","Form-4","Form-5a-(1)","Form-5a-(2)","Form-5b-(1)","Form-5b-(2)","Form-6","Form-7","Form-8","Form-9-(1)","Form-9-(2)","Form-10-(1)","Form-10-(2)","Form-10-(3)","Form-10-(4)","Form-10-(5)","Form-11a-(1)","Form-11a-(2)","Form-11a-(3)","Form-11b-(1)","Form-11b-(2)","Form-12","Form-13 (1)","Form-13 (2)","Print","Module1","Module2"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":90,"comments":13,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":33,"reason":"part_missing"},{"sheet":"Module2","index":34,"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":"Cover","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,3,16,4],[12,3,12,4],[13,3,13,4],[14,3,14,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"RBCA Tier 1 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,"PROGRAM NO.:"]
[null,null,null,"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":2,"n_rows":36,"n_cols":27,"rows_kept":36,"cut":false,"hidden":false,"merged":[[38,3,38,6],[2,2,2,7],[4,2,4,7],[5,6,5,7],[5,2,5,3],[37,3,37,6],[2,10,13,13],[6,2,6,7],[24,2,24,7],[25,3,25,6],[36,3,36,6]]}
[]
[]
[null,null,"DWEE RBCA TIER 1 REPORT FORMS",null,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.",null,"Description",null,"Check box if included"]
[null,null,"FORMS FOR USE BY RP/CONSULTANT"]
[null,null,null,"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,"2.","Basic Information:","2a.  Facility/File",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,"2b.  Consultant and Licensing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"3.","Release:","3a.  Characterization and History",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,"3b.  Source Area GPS Coordinates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"4.","Land Use",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,"5.","Water Use:","5a.  Ground Water and Surface Water Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,"5b.  Water Supply Well Location Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,"6.","Enclosed Spaces",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,"7.","Instructions for Investigation Narrative",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,"8.","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,false]
[null,null,null,"9.","Surface Soil (0-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,false]
[null,null,null,"10.","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,false]
[null,null,null,"11.","Ground Water","11a. Analytic Data Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,"11b. 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,false]
[null,null,null,"12.","Free Product",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,"13.","References and Protocols",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 borings and monitoring wells, and date of map, where appropriate."]
[null,null,null,"1.","Topographic Map"]
[null,null,null,"2.","Area Map"]
[null,null,null,"3.","Site Map"]
[null,null,null,"4.","Free Product Map"]
[null,null,null,"5.","Boring Logs"]
[null,null,null,"6.","Monitoring Well Schematics"]
[null,null,null,"7.","Laboratory Analysis Sheets and Chain-of-Custody Sheets"]
[null,null,null,"8.","Geologic Cross Sections"]
[null,null,null,"9.","Well Survey Documentation"]
[null,null,null,"OTHER ATTACHMENTS:"]

{"sheet":"Form-1","index":3,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":true,"merged":[[9,1,9,10],[20,7,20,9],[11,4,11,9],[13,4,13,9],[14,4,14,9],[12,4,12,9],[21,7,21,9],[23,7,23,9],[41,1,41,10],[30,4,30,5],[28,4,28,5],[29,7,29,9],[24,7,24,9],[34,2,38,9],[39,6,39,9],[26,4,26,5],[33,1,33,10],[22,7,22,9],[42,3,42,9],[25,4,25,5],[27,4,27,5],[29,4,29,5],[39,2,39,3]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,"Tier 1 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":"PROGRAM NO.:  "},null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"Is surface soil contamination present?",null,null,null,"Yes",null,"No"]
[null,"Are subsurface soils impacted?",null,null,null,"Yes",null,"No"]
[null,"Is ground water impacted?",null,null,null,"Yes",null,"No",null,"NA"]
[null,"Has the source(s) of release been identified?",null,null,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 plume fully delineated?",null,null,null,"Yes","No"]
[null,"Were vapors detected in any on-site subsurface structures?",null,null,null,"Yes","No"]
[null,"Has surface water been impacted by the release?",null,null,null,"Yes","No"]
[null,"Were emergency actions initiated?",null,null,null,"Yes","No"]
[null,"Average depth of contamination in subsurface soils:",null,null,null,null,"ft",{"$f":"IF(E26=\"\",\"               cm\",(E26*30.48) & \"    cm\")","v":"               cm"}]
[null,"Shallowest depth to ground water:",null,null,null,null,"ft","Not measured"]
[null,"Average depth to ground water:",null,null,null,null,"ft","Not measured"]
[null,"Distance to nearest drinking water supply well:",null,null,null,null,"ft          municipal",null,"domestic"]
[null,"Distance to nearest non-potable water supply well:",null,null,null,null,"ft                    type:"]
[null,"Distance to nearest downgradient water supply well:",null,null,null,null,"ft          municipal",null,"domestic"]
[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 1 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-2a","index":4,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":true,"merged":[[11,3,11,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[12,3,12,7],[16,3,16,7],[20,3,20,7],[19,3,19,7],[18,3,18,7],[17,3,17,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[30,3,30,7],[31,3,31,7],[34,2,34,7],[25,3,25,7],[26,3,26,7],[27,3,27,7],[28,3,28,7],[29,3,29,7]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,"Tier 1 Investigation Form - 2a  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"FACILITY/FILE  INFORMATION"]
[]
[null,null,"Facility or file name:"]
[null,null,"Facility address or site location:"]
[]
[]
[null,null,"County:"]
[null,null,"Legal Location (¼, ¼, ¼, Sec, T, R):"]
[null,null,"Responsible Party:"]
[null,null,"Responsible Party mailing address:"]
[]
[null,null,"Responsible Party phone number:"]
[null,null,"Property owner:"]
[null,null,"Property owner mailing address:"]
[]
[]
[null,null,"Property owner phone number:"]
[null,null,"Other contacts:"]
[]
[]
[]
[]
[]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Topographic map"]

{"sheet":"Form-2b","index":5,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[[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],[11,3,11,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[12,3,12,7],[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]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,"Tier 1 Investigation Form - 2b  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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-3a","index":6,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":true,"merged":[[25,11,25,13],[26,11,26,13],[28,3,28,7],[29,3,29,7],[28,11,28,13],[29,11,29,13],[46,2,46,13],[13,6,13,11],[14,6,14,11],[13,2,13,4],[14,2,14,4],[41,1,41,4],[42,11,42,13],[43,11,43,13],[33,11,33,13],[34,11,34,13],[35,11,35,13],[37,11,37,13],[36,11,36,13],[41,11,41,13],[38,11,38,13],[40,11,40,13]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 3a  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"RELEASE CHARACTERIZATION"]
[]
[null,"PETROLEUM RELEASE HISTORY"]
[null,null,"DWEE Spill Number",null,null,null,"Location/Source",null,null,null,null,null,null,"Product/Quantity"]
[]
[]
[]
[]
[null,null,"SOURCE(S) OF RELEASE (Check all that apply)",null,null,null,null,null,null,null,"SUBSTANCE(S) RELEASED (Check all that apply)"]
[null,null,null,"Surface Spills",null,null,null,null,null,null,null,"Gasoline"]
[null,null,null,"Load Out Racks (includes overfills)",null,null,null,null,null,null,null,"Diesel/#2 Fuel Oil"]
[null,null,null,"Piping",null,null,null,null,null,null,null,"Used Oil"]
[null,null,null,"Dispenser Islands (includes vessel overfills)",null,null,null,null,null,null,null,"AV Gas"]
[null,null,null,"USTs (includes UST overfills)",null,null,null,null,null,null,null,"Jet Fuel:","JP"]
[null,null,null,"ASTs (includes AST overfills)",null,null,null,null,null,null,null,"Kerosene"]
[null,null,null,"Transportation Vessels",null,null,null,null,null,null,null,"Other Fuel Oil/Heavy Distillate (specify)"]
[null,null,null,"Interstate/Intrastate Pipelines"]
[null,null,null,"Unknown"]
[null,null,null,"Other (specify)",null,null,null,null,null,null,null,"Other product (specify)"]
[]
[]
[]
[]
[null,"SUMMARY OF RELEASE"]
[null,null,null,null,null,null,null,null,null,null,null,"(Provide explanatory notes below)"]
[null,"Has the source(s) of release been identified?",null,null,null,null,null,"YES",null,"NO"]
[null,"Has the release been abated?",null,null,null,null,null,"YES",null,"NO"]
[null,"Were emergency actions initiated?",null,null,null,null,null,"YES",null,"NO"]
[null,"Are surface soils impacted?",null,null,null,null,null,"YES",null,"NO"]
[null,"Are subsurface soils impacted?",null,null,null,null,null,"YES",null,"NO"]
[null,"Is ground water impacted?",null,null,null,null,null,"YES",null,"NO",null,"Not sampled, drilled out of contamination"]
[null,"Were vapors detected in any utilities?",null,null,null,null,null,"YES",null,"NO"]
[null,"Were vapors detected in any on-site subsurface structures?",null,null,null,null,null,"YES",null,"NO"]
[null,"Is surface water impacted?",null,null,null,null,null,"YES",null,"NO"]
[null,"Has a sensitive habitat/resource been impacted?",null,null,null,null,null,"YES",null,"NO"]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  None."]

{"sheet":"Form-3b (1)","index":7,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":true,"merged":[[11,5,11,13],[13,2,13,3],[12,2,12,3],[11,2,11,4],[12,12,12,13],[44,2,44,13],[38,4,38,5],[39,4,39,5],[40,4,40,5],[38,9,38,12],[39,9,39,12],[40,9,40,12],[35,5,35,7],[36,5,36,7],[35,9,35,12],[36,9,36,12],[22,10,22,13],[34,5,34,7],[34,9,34,12],[29,5,29,7],[29,10,29,13],[30,5,30,7],[30,10,30,13],[23,5,23,7],[23,10,23,13],[28,5,28,7],[28,10,28,13],[24,5,24,7],[17,5,17,7],[17,10,17,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]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 3b  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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-3b (2)","index":8,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":true,"merged":[[26,5,26,7],[26,10,26,13],[27,5,27,7],[33,5,33,7],[33,9,33,12],[28,5,28,7],[28,10,28,13],[29,5,29,7],[29,10,29,13],[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],[43,2,43,13],[37,4,37,5],[38,4,38,5],[39,4,39,5],[37,9,37,12],[38,9,38,12],[39,9,39,12],[35,5,35,7],[34,9,34,12],[35,9,35,12],[11,5,11,13],[13,2,13,3],[12,2,12,3],[11,2,11,4],[12,12,12,13],[34,5,34,7],[19,5,19,7],[19,10,19,13],[20,5,20,7],[20,10,20,13],[17,5,17,7],[17,10,17,13],[18,5,18,7]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 3b  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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-4","index":9,"n_rows":45,"n_cols":15,"rows_kept":45,"cut":false,"hidden":true,"merged":[[42,2,42,13],[25,4,25,13],[26,4,26,13],[27,3,27,13],[30,3,30,13],[12,12,12,13],[31,3,31,13],[28,4,28,13],[29,4,29,13],[21,2,21,13],[24,3,24,13],[16,2,16,8],[16,11,16,13],[17,2,17,8],[18,2,18,8],[17,11,17,13],[18,11,18,13]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 4  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"LAND USE"]
[]
[]
[null,null,"Currently operating as a service station or petroleum bulk facility. If not, site currently used as:"]
[null,null,"Tanks temporarily out of service",null,null,null,null,"Tanks permanently out of service"]
[]
[]
[null,null,"Current On-site Land Use",null,null,null,null,null,null,null,null,"Future On-site Land Use"]
[null,null,"Residential",null,null,null,null,null,null,null,null,"Residential"]
[null,null,"Commercial",null,null,null,null,null,null,null,null,"Commercial"]
[]
[null,"Comments:  Justify the choice for future land use."]
[]
[]
[null,"Off-site Land Use (within 500 feet - at a minimum, state whether residential, agricultural, commercial, or sensitive population center)"]
[null,null,"North:"]
[null,null,null,"Northeast:"]
[null,null,null,"Northwest:"]
[null,null,"South:"]
[null,null,null,"Southeast:"]
[null,null,null,"Southwest:"]
[null,null,"West:"]
[null,null,"East:"]
[]
[null,"ADDITIONAL POINT OF EXPOSURE SURVEY"]
[null,null,null,null,null,null,null,null,null,null,null,"Distance (feet)",null,"Direction"]
[null,null,"Nearest residential site (£500 ft):"]
[null,null,"Nearest commercial site (£500 ft):"]
[null,null,"Nearest habitable building (£500 ft):"]
[null,null,"Nearest ecologically sensitive area, e.g., wetland (£1000 ft):"]
[null,null,"Nearest school, hospital, day care, retirement home, etc. (£500 ft):"]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Site map with detailed land use in the vicinity of the site, Area map."]

{"sheet":"Form-5a-(1)","index":10,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":true,"merged":[[11,14,11,15],[26,2,26,4],[26,6,26,9],[26,11,26,12],[26,14,26,15],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[14,6,14,9],[15,6,15,9],[16,6,16,9],[17,6,17,9],[18,6,18,9],[19,6,19,9],[7,1,7,27],[36,1,39,27],[19,23,19,26],[19,17,19,21],[30,17,30,21],[30,23,30,26],[12,2,12,4],[11,6,11,9],[11,2,11,4],[11,11,11,12],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[12,6,12,9],[13,6,13,9],[20,6,20,9],[21,6,21,9],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[21,11,21,12],[20,11,20,12],[21,14,21,15],[20,17,20,21],[21,17,21,21],[11,17,13,26],[14,17,14,20],[14,22,14,25],[20,14,20,15],[17,17,18,26],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[12,14,12,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[27,2,27,4],[27,6,27,9],[27,11,27,12],[27,14,27,15],[28,2,28,4],[28,11,28,12],[29,2,29,4],[30,2,30,4],[31,2,31,4],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[29,11,29,12],[30,11,30,12],[31,11,31,12],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[31,17,31,21],[31,23,31,26],[20,23,20,26],[21,23,21,26],[22,17,23,21],[22,23,23,26],[24,23,24,26],[24,17,24,21]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form 5a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\"))","v":"COMPLETION DATE:  00-Jan-00"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"GROUND WATER AND SURFACE WATER USE"]
[]
[null,null,"Ground Water - Current Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Water & Surface Water - Future Use"]
[]
[null,null,"Well Designation",null,null,null,"Well Type/Use",null,null,null,null,"Distance (ft)",null,null,"Direction",null,null,"Are the RP, current property owner (if different than RP), adjacent landowners, and/or local municipal authorities aware of potential future ground and/or surface water use development within the next five years?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Water",null,null,null,null,"Surface Water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,"Yes",null,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If yes, provide the following information.  Include contact information in Notes below and/or Form 5b."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location",null,null,null,null,null,"Type of New Use"]
[]
[]
[]
[]
[null,null,"Surface Water - Current Use"]
[]
[null,null,"Surface Water Type",null,null,null,"Beneficial Use",null,null,null,null,"Distance (ft)",null,null,"Direction"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NOTES:","  1)  Justify choice of future ground water use; also indicate if water supply well may have some influence over vertical migration of plume."]
[null,null,null,"  2)  Justify choice for future surface water use and type of water body."]
[]
[]
[]
[]
[null,"Recommended attachments:  Area map with well  and surface water locations."]

{"sheet":"Form-5a-(2)","index":11,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":true,"merged":[[11,17,13,26],[14,17,14,20],[14,22,14,25],[17,17,18,26],[31,17,31,21],[31,23,31,26],[20,23,20,26],[21,23,21,26],[22,17,23,21],[22,23,23,26],[24,23,24,26],[24,17,24,21],[20,17,20,21],[21,17,21,21],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[28,11,28,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[28,2,28,4],[29,2,29,4],[30,2,30,4],[31,2,31,4],[27,2,27,4],[27,6,27,9],[27,11,27,12],[27,14,27,15],[21,14,21,15],[21,11,21,12],[26,14,26,15],[20,14,20,15],[20,11,20,12],[12,14,12,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,6,20,9],[21,6,21,9],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[16,6,16,9],[17,6,17,9],[18,6,18,9],[19,6,19,9],[12,6,12,9],[13,6,13,9],[7,1,7,27],[36,1,39,27],[19,23,19,26],[19,17,19,21],[30,17,30,21],[30,23,30,26],[12,2,12,4],[11,6,11,9],[11,2,11,4],[11,11,11,12],[11,14,11,15],[26,2,26,4],[26,6,26,9],[26,11,26,12],[14,6,14,9],[15,6,15,9],[13,2,13,4],[14,2,14,4],[15,2,15,4],[20,2,20,4],[21,2,21,4],[18,2,18,4],[19,2,19,4],[16,2,16,4],[17,2,17,4]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form 5a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D27,\"  \",TEXT(Cover!E27,\"dd-mmm-yy\"))","v":"COMPLETION DATE:  00-Jan-00"},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"GROUND WATER AND SURFACE WATER USE"]
[]
[null,null,"Ground Water - Current Use",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Water & Surface Water - Future Use"]
[]
[null,null,"Well Designation",null,null,null,"Well Type/Use",null,null,null,null,"Distance (ft)",null,null,"Direction",null,null,"Are the RP, current property owner (if different than RP), adjacent landowners, and/or local municipal authorities aware of potential future ground and/or surface water use development within the next five years?"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ground Water",null,null,null,null,"Surface Water"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,null,"Yes",null,"No"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If yes, provide the following information.  Include contact information in Notes below and/or Form 5b."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Location",null,null,null,null,null,"Type of New Use"]
[]
[]
[]
[]
[null,null,"Surface Water - Current Use"]
[]
[null,null,"Surface Water Type",null,null,null,"Beneficial Use",null,null,null,null,"Distance (ft)",null,null,"Direction"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NOTES:","  1)  Justify choice of future ground water use; also indicate if water supply well may have some influence over vertical migration of plume."]
[null,null,null,"  2)  Justify choice for future surface water use and type of water body."]
[]
[]
[]
[]
[null,"Recommended attachments:  Area map with well  and surface water locations."]

{"sheet":"Form-5b-(1)","index":12,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":true,"merged":[[25,2,25,4],[25,12,25,15],[34,14,34,15],[27,13,27,14],[28,13,28,14],[25,6,25,7],[27,7,27,10],[28,7,28,10],[23,12,23,15],[24,12,24,15],[18,12,18,15],[19,12,19,15],[20,12,20,15],[21,12,21,15],[12,12,12,15],[13,12,13,15],[17,12,17,15],[22,12,22,15],[16,12,16,15],[15,12,15,15],[14,12,14,15],[22,2,22,4],[23,2,23,4],[24,2,24,4],[13,6,13,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[20,6,20,7],[21,6,21,7],[22,6,22,7],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[23,6,23,7],[24,6,24,7],[12,6,12,7],[12,2,12,4],[13,2,13,4],[17,2,17,4],[14,6,14,7],[15,6,15,7],[16,6,16,7],[16,2,16,4],[15,2,15,4],[14,2,14,4],[10,2,10,4],[10,12,10,15],[11,2,11,4],[11,12,11,15],[10,6,10,7],[11,6,11,7],[10,9,10,10],[11,9,11,10],[6,2,6,15],[9,2,9,4],[9,12,9,15],[8,2,8,15],[9,6,9,7],[9,9,9,10],[12,9,12,10],[13,9,13,10],[24,9,24,10],[25,9,25,10],[16,9,16,10],[15,9,15,10],[14,9,14,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10]]}
[null,null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 5b  "]
[]
[null,null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,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,null,"WATER SUPPLY WELL LOCATION INFORMATION"]
[]
[null,null,"List all wells located within the distances for the categories requested."]
[null,null,"Well Designation",null,null,null,"Physical Location/Address",null,null,"Well Owner",null,null,"Well Owner Mailing Address"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Municipal Water/Utilities Superintendent:",null,null,null,null,null,"Telephone Number:"]
[null,null,null,null,null,null,"Third Party Contact for Future Ground Water Use:",null,null,null,null,null,"Telephone Number:"]
[]
[null,null,"NOTES:"]
[null,null,null,"Provide location information of all water supply wells documented in Report Form 5a on area map."]
[null,null,null,"Well location may be street property address or legal description."]
[null,null,null,"Use well designation as map label. Include well locations on site map."]
[null,null,"Recommended Attachment(s): Well logs and installation information."]

{"sheet":"Form-5b-(2)","index":13,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":true,"merged":[[14,9,14,10],[15,9,15,10],[6,2,6,15],[9,2,9,4],[9,12,9,15],[8,2,8,15],[9,6,9,7],[9,9,9,10],[10,2,10,4],[10,12,10,15],[11,2,11,4],[11,12,11,15],[10,6,10,7],[11,6,11,7],[10,9,10,10],[11,9,11,10],[12,2,12,4],[13,2,13,4],[17,2,17,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[22,2,22,4],[13,6,13,7],[17,6,17,7],[18,6,18,7],[19,6,19,7],[12,12,12,15],[13,12,13,15],[17,12,17,15],[14,12,14,15],[12,6,12,7],[16,6,16,7],[15,6,15,7],[14,6,14,7],[12,9,12,10],[13,9,13,10],[17,9,17,10],[18,9,18,10],[25,2,25,4],[25,12,25,15],[21,9,21,10],[22,9,22,10],[23,9,23,10],[23,2,23,4],[24,2,24,4],[22,12,22,15],[23,12,23,15],[21,12,21,15],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[24,9,24,10],[25,9,25,10],[32,14,32,15],[25,6,25,7],[16,9,16,10],[16,12,16,15],[15,12,15,15],[24,12,24,15],[18,12,18,15],[19,12,19,15],[20,12,20,15],[20,6,20,7],[19,9,19,10],[20,9,20,10]]}
[null,null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 5b  "]
[]
[null,null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,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,null,"WATER SUPPLY WELL LOCATION INFORMATION"]
[]
[null,null,"List all wells located within the distances for the categories requested."]
[null,null,"Well Designation",null,null,null,"Physical Location/Address",null,null,"Well Owner",null,null,"Well Owner Mailing Address"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NOTES:"]
[null,null,null,"Provide location information of all water supply wells documented in Report Form 5a on area map."]
[null,null,null,"Well location may be street property address or legal description."]
[null,null,null,"Use well designation as map label. Include well locations on site map."]
[null,null,"Recommended Attachment(s): Well logs and installation information."]

{"sheet":"Form-6","index":14,"n_rows":57,"n_cols":26,"rows_kept":57,"cut":false,"hidden":true,"merged":[[53,21,53,24],[54,21,54,24],[44,16,44,19],[49,16,49,19],[44,21,44,24],[49,21,49,24],[51,21,51,24],[52,21,52,24],[51,16,51,19],[52,16,52,19],[53,2,53,6],[54,2,54,6],[53,8,53,14],[54,8,54,14],[53,16,53,19],[54,16,54,19],[39,6,39,7],[18,12,18,13],[44,8,44,14],[49,8,49,14],[51,8,51,14],[52,8,52,14],[44,2,44,6],[49,2,49,6],[51,2,51,6],[52,2,52,6],[43,2,43,6],[37,12,37,16],[38,6,38,7],[21,9,21,10],[22,9,22,10],[28,9,28,10],[35,9,35,10],[36,9,36,10],[43,21,43,24],[43,8,43,14],[43,16,43,19],[42,8,42,14],[42,16,42,19],[42,21,42,24],[42,2,42,6],[21,6,21,7],[22,6,22,7],[28,6,28,7],[35,6,35,7],[26,6,27,7],[21,3,21,4],[22,3,22,4],[29,2,29,4],[29,6,29,7],[31,2,31,4],[37,9,37,10],[37,18,37,21],[36,2,36,4],[37,2,37,4],[36,6,36,7],[37,6,37,7],[39,2,39,4],[19,20,19,21],[30,6,30,7],[38,2,38,4],[38,12,38,16],[28,12,28,16],[25,12,25,16],[35,12,35,16],[36,12,36,16],[21,12,21,13],[22,12,22,13],[35,18,35,21],[26,18,26,24],[21,15,21,18],[28,2,28,4],[35,2,35,4],[36,23,36,24],[36,18,36,21],[30,2,30,4],[31,6,31,7],[32,2,32,4],[32,6,32,7],[33,2,33,4],[33,6,33,7],[33,9,33,10],[18,9,18,10],[18,20,18,21],[17,6,17,7],[19,9,19,10],[18,6,18,7],[35,23,35,24],[17,23,17,24],[27,23,27,24],[15,23,15,24],[15,20,15,21],[16,9,16,10],[16,6,16,7],[22,20,22,21],[21,23,21,24],[22,23,22,24],[28,18,28,21],[25,18,25,24],[28,23,28,24],[21,20,21,21],[19,23,19,24],[27,18,27,21],[22,15,22,18],[19,12,19,13],[19,6,19,7],[32,9,32,10],[32,12,32,16],[32,18,32,21],[32,23,32,24],[10,1,10,25],[15,15,15,18],[15,12,15,13],[16,15,16,18],[16,12,16,13],[18,23,18,24],[15,9,15,10],[15,6,15,7],[17,20,17,21],[17,12,17,13],[14,15,14,18],[14,12,14,13],[16,23,16,24],[16,20,16,21],[14,9,14,10],[14,6,14,7],[14,23,14,24],[14,20,14,21],[12,2,12,24],[17,9,17,10],[29,9,29,10],[29,12,29,16],[29,18,29,21],[29,23,29,24],[30,9,30,10],[30,12,30,16],[30,18,30,21],[30,23,30,24],[31,9,31,10],[31,12,31,16],[31,18,31,21],[31,23,31,24],[33,23,33,24],[34,2,34,4],[34,6,34,7],[34,9,34,10],[34,12,34,16],[34,18,34,21],[34,23,34,24],[39,23,39,24],[38,9,38,10],[39,9,39,10],[38,18,38,21],[39,18,39,21],[39,12,39,16],[38,23,38,24],[37,23,37,24],[33,12,33,16],[33,18,33,21]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 6  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ENCLOSED SPACES"]
[null,"     NO ENCLOSED SPACES ASSOCIATED WITH RELEASE LOCATION"]
[null,"ON-SITE SUBSURFACE UTILITIES"]
[null,null,"Indicate which of the following utilities currently act as conduits or are potentially liable to become conduits under the columns entitled \"Impacted by release,\" and \"Potentially Impacted by Release,\" respectively."]
[null,null,null,null,null,null,"Depth [feet]",null,null,"Construction material",null,null,"Fill Material",null,null,"Flow direction",null,null,null,null,"Impacted by release",null,null,"Potentially impacted by release"]
[null,null,null,"Sanitary sewer"]
[null,null,null,"Covered storm sewer"]
[null,null,null,"Water line"]
[null,null,null,"Gas line"]
[null,null,null,"Electric line"]
[null,null,null,"Telephone line"]
[null,null,null,"Other:"]
[]
[]
[]
[null,"ON-SITE & ADJACENT PROPERTY (within 200 ft) BUILDINGS"]
[null,null,"Building Location",null,null,null,"Direction",null,null,"Distance from",null,null,"Use",null,null,null,null,null,"Basement or other subgrade present?"]
[null,null,null,null,null,null,"(Cross, Down, Upgradient)",null,null,"source area(s)",null,null,null,null,null,null,null,null,"(e.g. crawl space, daylight room)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type of structure",null,null,null,null,"Depth (ft bgl)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"VAPOR ASSESSMENT"]
[null,null,"Subsurface Structure Screened",null,null,null,null,null,"Location",null,null,null,null,null,null,null,"PID/FID (ppm)",null,null,null,null,"CGI (%LEL)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Recommended attachments:  Site map with locations of utilities, tanks and ancillary equipment, and vapor sampling locations."]

{"sheet":"Form-7","index":15,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":true,"merged":[[9,1,9,10],[11,2,11,10],[29,4,29,10]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 7  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,{"$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 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 1 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 and 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.","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-8","index":16,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":true,"merged":[[28,5,28,14],[32,2,32,5],[26,2,26,3],[28,2,28,3],[25,5,25,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[23,2,23,3],[13,5,13,8],[14,5,14,8],[15,5,15,8],[16,5,16,8],[13,10,13,14],[14,10,14,14],[15,10,15,14],[16,10,16,14],[24,2,24,3],[25,2,25,3],[21,5,21,14],[23,5,23,14],[22,5,22,14],[27,2,27,3],[26,5,26,14],[27,5,27,14],[24,5,24,14],[41,2,41,14],[31,6,31,14],[31,2,31,5],[38,12,38,13],[36,6,36,8],[37,6,37,8],[32,11,32,14],[35,11,35,14],[36,11,36,14],[32,6,32,8],[38,6,38,8],[33,6,33,8],[34,6,34,8],[35,6,35,8],[17,10,17,14],[17,5,17,8],[17,2,17,3],[19,5,19,14],[18,10,18,14],[18,5,18,8],[18,2,18,3]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 8  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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"]
[]
[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 SATURATED IMPACTED ZONE"]
[]
[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) [0.30 for sands, 0.35 for silts/clays]"]
[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 and soil boring logs."]

{"sheet":"Form-9-(1)","index":17,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[[28,11,28,12],[31,11,31,12],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[28,9,28,10],[28,7,28,8],[30,3,30,4],[30,5,30,6],[29,9,29,10],[30,9,30,10],[22,11,22,12],[26,3,26,4],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[23,3,23,4],[24,3,24,4],[22,3,22,4],[23,11,23,12],[24,11,24,12],[25,11,25,12],[26,11,26,12],[27,9,27,10],[17,3,17,4],[18,3,18,4],[19,7,19,8],[19,9,19,10],[25,3,25,4],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[22,9,22,10],[23,9,23,10],[24,9,24,10],[10,15,12,15],[17,9,17,10],[16,9,16,10],[15,11,15,12],[16,11,16,12],[17,11,17,12],[14,11,14,12],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[19,3,19,4],[19,5,19,6],[19,11,19,12],[15,3,15,4],[16,3,16,4],[18,9,18,10],[18,11,18,12],[14,9,14,10],[21,11,21,12],[15,9,15,10],[12,9,12,10],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[17,7,17,8],[16,7,16,8],[10,14,12,14],[17,5,17,6],[18,5,18,6],[26,5,26,6],[29,5,29,6],[14,3,14,4],[10,7,10,8],[14,5,14,6],[14,7,14,8],[15,5,15,6],[15,7,15,8],[12,7,12,8],[18,7,18,8],[27,3,27,4],[27,5,27,6],[27,7,27,8],[28,5,28,6],[28,3,28,4],[27,11,27,12],[25,9,25,10],[26,9,26,10],[7,1,7,16],[30,1,30,2],[31,1,31,2],[10,13,12,13],[28,1,28,2],[29,1,29,2],[29,11,29,12],[30,11,30,12],[29,7,29,8],[30,7,30,8],[10,16,12,16],[10,3,10,4],[10,9,10,10],[10,11,10,12],[12,11,12,12],[11,11,11,12],[12,3,12,4],[12,5,12,6],[29,3,29,4],[10,5,10,6],[16,5,16,6]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 9  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},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,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SURFACE SOIL (Soil sample depth between 0-3 feet bgl; All concentrations in mg/kg)"]
[null,null,null,null,null,null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,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,"Benzene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:M15,#REF!)=0,\"\",COUNT(D15:M15,#REF!))","v":""},{"$f":"IF(N15=\"\",\"\", AVERAGE(D15:M15,'Form-9-(2)'!D15:M15))","v":""},{"$f":"IF(N15=\"\",\"\",MAX(C15:M15,'Form-9-(2)'!C15:M15))","v":""},{"$f":"IF(OR((O15=\"\"),(P15=\"\")),\"\",P15/O15)","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C16:M16,#REF!)=0,\"\",COUNT(C16:M16,#REF!))","v":""},{"$f":"IF(N16=\"\",\"\", AVERAGE(D16:M16,'Form-9-(2)'!D16:M16))","v":""},{"$f":"IF(N16=\"\",\"\",MAX(C16:M16,'Form-9-(2)'!C16:M16))","v":""},""]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C17:M17,#REF!)=0,\"\",COUNT(C17:M17,#REF!))","v":""},{"$f":"IF(N17=\"\",\"\", AVERAGE(D17:M17,'Form-9-(2)'!D17:M17))","v":""},{"$f":"IF(N17=\"\",\"\",MAX(C17:M17,'Form-9-(2)'!C17:M17))","v":""},""]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C18:M18,#REF!)=0,\"\",COUNT(C18:M18,#REF!))","v":""},{"$f":"IF(N18=\"\",\"\", AVERAGE(D18:M18,'Form-9-(2)'!D18:M18))","v":""},{"$f":"IF(N18=\"\",\"\",MAX(C18:M18,'Form-9-(2)'!C18:M18))","v":""},""]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C19:M19,#REF!)=0,\"\",COUNT(C19:M19,#REF!))","v":""},{"$f":"IF(N19=\"\",\"\", AVERAGE(D19:M19,'Form-9-(2)'!D19:M19))","v":""},{"$f":"IF(N19=\"\",\"\",MAX(C19:M19,'Form-9-(2)'!C19:M19))","v":""},""]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C20:M20,#REF!)=0,\"\",COUNT(C20:M20,#REF!))","v":""},{"$f":"IF(N20=\"\",\"\", AVERAGE(D20:M20,'Form-9-(2)'!D20:M20))","v":""},{"$f":"IF(N20=\"\",\"\",MAX(C20:M20,'Form-9-(2)'!C20:M20))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C21:M21,#REF!)=0,\"\",COUNT(C21:M21,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:M22,#REF!)=0,\"\",COUNT(C22:M22,#REF!))","v":""},{"$f":"IF(N22=\"\",\"\", AVERAGE(D22:M22,'Form-9-(2)'!D22:M22))","v":""},{"$f":"IF(N22=\"\",\"\",MAX(C22:M22,'Form-9-(2)'!C22:M22))","v":""},""]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C23:M23,#REF!)=0,\"\",COUNT(C23:M23,#REF!))","v":""},{"$f":"IF(N23=\"\",\"\", AVERAGE(D23:M23,'Form-9-(2)'!D23:M23))","v":""},{"$f":"IF(N23=\"\",\"\",MAX(C23:M23,'Form-9-(2)'!C23:M23))","v":""},""]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C24:M24,#REF!)=0,\"\",COUNT(C24:M24,#REF!))","v":""},{"$f":"IF(N24=\"\",\"\", AVERAGE(D24:M24,'Form-9-(2)'!D24:M24))","v":""},{"$f":"IF(N24=\"\",\"\",MAX(C24:M24,'Form-9-(2)'!C24:M24))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C25:M25,#REF!)=0,\"\",COUNT(C25:M25,#REF!))","v":""},{"$f":"IF(N25=\"\",\"\", AVERAGE(D25:M25,'Form-9-(2)'!D25:M25))","v":""},{"$f":"IF(N25=\"\",\"\",MAX(C25:M25,'Form-9-(2)'!C25:M25))","v":""},""]
[" ","TEH as",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C26:M26,#REF!)=0,\"\",COUNT(C26:M26,#REF!))","v":""},{"$f":"IF(N26=\"\",\"\", AVERAGE(D26:M26,'Form-9-(2)'!D26:M26))","v":""},{"$f":"IF(N26=\"\",\"\",MAX(C26:M26,'Form-9-(2)'!C26:M26))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C27:M27,#REF!)=0,\"\",COUNT(C27:M27,#REF!))","v":""},{"$f":"IF(N27=\"\",\"\", AVERAGE(D27:M27,'Form-9-(2)'!D27:M27))","v":""},{"$f":"IF(N27=\"\",\"\",MAX(C27:M27,'Form-9-(2)'!C27:M27))","v":""},""]
[null,"OTHER ANALYTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C29:M29,#REF!)=0,\"\",COUNT(C29:M29,#REF!))","v":""},{"$f":"IF(N29=\"\",\"\", AVERAGE(D29:M29,'Form-9-(2)'!D29:M29))","v":""},{"$f":"IF(N29=\"\",\"\",MAX(C29:M29,'Form-9-(2)'!C29:M29))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C30:M30,#REF!)=0,\"\",COUNT(C30:M30,#REF!))","v":""},{"$f":"IF(N30=\"\",\"\", AVERAGE(D30:M30,'Form-9-(2)'!D30:M30))","v":""},{"$f":"IF(N30=\"\",\"\",MAX(C30:M30,'Form-9-(2)'!C30:M30))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C31:M31,#REF!)=0,\"\",COUNT(C31:M31,#REF!))","v":""},{"$f":"IF(N31=\"\",\"\", AVERAGE(D31:M31,'Form-9-(2)'!D31:M31))","v":""},{"$f":"IF(N31=\"\",\"\",MAX(C31:M31,'Form-9-(2)'!C31:M31))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C32:M32,#REF!)=0,\"\",COUNT(C32:M32,#REF!))","v":""},{"$f":"IF(N32=\"\",\"\", AVERAGE(D32:M32,'Form-9-(2)'!D32:M32))","v":""},{"$f":"IF(N32=\"\",\"\",MAX(C32:M32,'Form-9-(2)'!C32:M32))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C33:M33)=0,\"\",COUNT(C33:M33))","v":""},{"$f":"IF(COUNT(C33:M33)=0,\"\",AVERAGE(C33:M33))","v":""},{"$f":"IF(N33=\"\",\"\",MAX(C33:M33))","v":""},{"$f":"IF(OR((O33=\"\"),(P33=\"\")),\"\",P33/O33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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 surface soil sample(s), chemical concentration maps, laboratory analysis reports, and chain of custody."]

{"sheet":"Form-9-(2)","index":18,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[[30,1,30,2],[31,1,31,2],[10,13,12,13],[28,1,28,2],[29,1,29,2],[29,11,29,12],[30,11,30,12],[29,7,29,8],[30,7,30,8],[25,11,25,12],[26,11,26,12],[27,11,27,12],[25,9,25,10],[26,9,26,10],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[19,7,19,8],[27,9,27,10],[26,7,26,8],[19,9,19,10],[25,3,25,4],[26,3,26,4],[7,1,7,16],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[17,7,17,8],[18,9,18,10],[10,7,10,8],[12,9,12,10],[11,7,11,8],[11,9,11,10],[14,9,14,10],[18,7,18,8],[15,7,15,8],[12,7,12,8],[17,3,17,4],[14,3,14,4],[18,3,18,4],[14,7,14,8],[15,5,15,6],[16,9,16,10],[14,11,14,12],[10,16,12,16],[10,3,10,4],[10,9,10,10],[10,11,10,12],[12,11,12,12],[11,11,11,12],[12,3,12,4],[12,5,12,6],[10,5,10,6],[10,14,12,14],[11,3,11,4],[10,15,12,15],[19,5,19,6],[19,11,19,12],[15,3,15,4],[16,3,16,4],[19,3,19,4],[29,5,29,6],[11,5,11,6],[27,5,27,6],[28,5,28,6],[22,5,22,6],[14,5,14,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[16,7,16,8],[15,9,15,10],[17,9,17,10],[21,11,21,12],[22,9,22,10],[23,9,23,10],[24,9,24,10],[22,11,22,12],[23,5,23,6],[24,5,24,6],[29,3,29,4],[28,11,28,12],[23,11,23,12],[24,11,24,12],[25,5,25,6],[23,3,23,4],[24,3,24,4],[28,3,28,4],[27,3,27,4],[27,7,27,8],[26,5,26,6],[29,9,29,10],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[31,11,31,12],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[28,9,28,10],[28,7,28,8],[30,3,30,4],[22,3,22,4],[30,5,30,6],[30,9,30,10]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 9  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"FACILITY NO.:  "}]
[]
[null,{"$f":"CONCATENATE(Cover!D26,\"  \",Cover!E26)","v":"CONSULTANT:  "},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,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SURFACE SOIL (Soil sample depth between 0-3 feet bgl; All concentrations in mg/kg)"]
[null,null,null,null,null,null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Sample No.",null,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,"Benzene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D15:M15,#REF!)=0,\"\",COUNT(D15:M15,#REF!))","v":""},{"$f":"'Form-9-(1)'!O15","v":""},{"$f":"'Form-9-(1)'!P15","v":""},{"$f":"'Form-9-(1)'!Q15","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C16:M16,#REF!)=0,\"\",COUNT(C16:M16,#REF!))","v":""},{"$f":"'Form-9-(1)'!O16","v":""},{"$f":"'Form-9-(1)'!P16","v":""},{"$f":"'Form-9-(1)'!Q16","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C17:M17,#REF!)=0,\"\",COUNT(C17:M17,#REF!))","v":""},{"$f":"'Form-9-(1)'!O17","v":""},{"$f":"'Form-9-(1)'!P17","v":""},{"$f":"'Form-9-(1)'!Q17","v":""}]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C18:M18,#REF!)=0,\"\",COUNT(C18:M18,#REF!))","v":""},{"$f":"'Form-9-(1)'!O18","v":""},{"$f":"'Form-9-(1)'!P18","v":""},{"$f":"'Form-9-(1)'!Q18","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C19:M19,#REF!)=0,\"\",COUNT(C19:M19,#REF!))","v":""},{"$f":"'Form-9-(1)'!O19","v":""},{"$f":"'Form-9-(1)'!P19","v":""},{"$f":"'Form-9-(1)'!Q19","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C20:M20,#REF!)=0,\"\",COUNT(C20:M20,#REF!))","v":""},{"$f":"'Form-9-(1)'!O20","v":""},{"$f":"'Form-9-(1)'!P20","v":""},{"$f":"'Form-9-(1)'!Q20","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C21:M21,#REF!)=0,\"\",COUNT(C21:M21,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C22:M22,#REF!)=0,\"\",COUNT(C22:M22,#REF!))","v":""},{"$f":"'Form-9-(1)'!O22","v":""},{"$f":"'Form-9-(1)'!P22","v":""},{"$f":"'Form-9-(1)'!Q22","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C23:M23,#REF!)=0,\"\",COUNT(C23:M23,#REF!))","v":""},{"$f":"'Form-9-(1)'!O23","v":""},{"$f":"'Form-9-(1)'!P23","v":""},{"$f":"'Form-9-(1)'!Q23","v":""}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C24:M24,#REF!)=0,\"\",COUNT(C24:M24,#REF!))","v":""},{"$f":"'Form-9-(1)'!O24","v":""},{"$f":"'Form-9-(1)'!P24","v":""},{"$f":"'Form-9-(1)'!Q24","v":""}]
[null,"TEH as",{"$f":"IF('Form-9-(1)'!C25=\"\",\"\",'Form-9-(1)'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C25:M25,#REF!)=0,\"\",COUNT(C25:M25,#REF!))","v":""},{"$f":"'Form-9-(1)'!O25","v":""},{"$f":"'Form-9-(1)'!P25","v":""},{"$f":"'Form-9-(1)'!Q25","v":""}]
[" ","TEH as",{"$f":"IF('Form-9-(1)'!C26=\"\",\"\",'Form-9-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C26:M26,#REF!)=0,\"\",COUNT(C26:M26,#REF!))","v":""},{"$f":"'Form-9-(1)'!O26","v":""},{"$f":"'Form-9-(1)'!P26","v":""},{"$f":"'Form-9-(1)'!Q26","v":""}]
[null,"TEH as",{"$f":"IF('Form-9-(1)'!C27=\"\",\"\",'Form-9-(1)'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C27:M27,#REF!)=0,\"\",COUNT(C27:M27,#REF!))","v":""},{"$f":"'Form-9-(1)'!O27","v":""},{"$f":"'Form-9-(1)'!P27","v":""},{"$f":"'Form-9-(1)'!Q27","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-9-(1)'!B29=\"\",\"\",'Form-9-(1)'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C29:M29,#REF!)=0,\"\",COUNT(C29:M29,#REF!))","v":""},{"$f":"'Form-9-(1)'!O29","v":""},{"$f":"'Form-9-(1)'!P29","v":""},{"$f":"'Form-9-(1)'!Q29","v":""}]
[null,{"$f":"IF('Form-9-(1)'!B30=\"\",\"\",'Form-9-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C30:M30,#REF!)=0,\"\",COUNT(C30:M30,#REF!))","v":""},{"$f":"'Form-9-(1)'!O30","v":""},{"$f":"'Form-9-(1)'!P30","v":""},{"$f":"'Form-9-(1)'!Q30","v":""}]
[null,{"$f":"IF('Form-9-(1)'!B31=\"\",\"\",'Form-9-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C31:M31,#REF!)=0,\"\",COUNT(C31:M31,#REF!))","v":""},{"$f":"'Form-9-(1)'!O31","v":""},{"$f":"'Form-9-(1)'!P31","v":""},{"$f":"'Form-9-(1)'!Q31","v":""}]
[null,{"$f":"IF('Form-9-(1)'!B32=\"\",\"\",'Form-9-(1)'!B32)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C32:M32,#REF!)=0,\"\",COUNT(C32:M32,#REF!))","v":""},{"$f":"'Form-9-(1)'!O32","v":""},{"$f":"'Form-9-(1)'!P32","v":""},{"$f":"'Form-9-(1)'!Q32","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(C33:M33)=0,\"\",COUNT(C33:M33))","v":""},{"$f":"IF(COUNT(C33:M33)=0,\"\",AVERAGE(C33:M33))","v":""},{"$f":"IF(N33=\"\",\"\",MAX(C33:M33))","v":""},{"$f":"IF(OR((O33=\"\"),(P33=\"\")),\"\",P33/O33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","","",""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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 surface soil sample(s), chemical concentration maps, laboratory analysis reports, and chain of custody."]

{"sheet":"Form-10-(1)","index":19,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":true,"merged":[[9,16,11,16],[9,17,11,17],[9,18,11,18],[7,1,7,18],[10,3,10,5],[10,6,10,8],[10,9,10,11],[10,12,10,14],[9,3,9,5],[9,6,9,8],[29,1,29,2],[30,1,30,2],[9,9,9,11],[9,12,9,14],[27,1,27,2],[28,1,28,2]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 10  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Soil sample depth greater than 3 ft bgl;  All concentrations in mg/kg.)"]
[]
[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-10-(1)'!D14:O14,'Form-10-(2)'!D14:O14,'Form-10-(3)'!D14:O14,'Form-10-(4)'!D14:O14,'Form-10-(5)'!D14:O14)=0,\"\",COUNT('Form-10-(1)'!D14:O14,'Form-10-(2)'!D14:O14,'Form-10-(3)'!D14:O14,'Form-10-(4)'!D14:O14,'Form-10-(5)'!D14:O14))","v":""},{"$f":"IF(P14=\"\",\"\",AVERAGE(D14:O14,'Form-10-(2)'!D14:O14,'Form-10-(3)'!D14:O14,'Form-10-(4)'!D14:O14,'Form-10-(5)'!D14:O14))","v":""},{"$f":"IF(Q14=\"\",\"\",MAX(D14:O14,'Form-10-(2)'!D14:O14,'Form-10-(3)'!D14:O14,'Form-10-(4)'!D14:O14,'Form-10-(5)'!D14:O14))","v":""},{"$f":"IF(OR((Q14=\"\"),(R14=\"\")),\"\",R14/Q14)","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D15:O15,'Form-10-(2)'!D15:O15,'Form-10-(3)'!D15:O15,'Form-10-(4)'!D15:O15,'Form-10-(5)'!D15:O15)=0,\"\",COUNT('Form-10-(1)'!D15:O15,'Form-10-(2)'!D15:O15,'Form-10-(3)'!D15:O15,'Form-10-(4)'!D15:O15,'Form-10-(5)'!D15:O15))","v":""},{"$f":"IF(P15=\"\",\"\",AVERAGE(D15:O15,'Form-10-(2)'!D15:O15,'Form-10-(3)'!D15:O15,'Form-10-(4)'!D15:O15,'Form-10-(5)'!D15:O15))","v":""},{"$f":"IF(Q15=\"\",\"\",MAX(D15:O15,'Form-10-(2)'!D15:O15,'Form-10-(3)'!D15:O15,'Form-10-(4)'!D15:O15,'Form-10-(5)'!D15:O15))","v":""},{"$f":"IF(OR((Q15=\"\"),(R15=\"\")),\"\",R15/Q15)","v":""}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D16:O16,'Form-10-(2)'!D16:O16,'Form-10-(3)'!D16:O16,'Form-10-(4)'!D16:O16,'Form-10-(5)'!D16:O16)=0,\"\",COUNT('Form-10-(1)'!D16:O16,'Form-10-(2)'!D16:O16,'Form-10-(3)'!D16:O16,'Form-10-(4)'!D16:O16,'Form-10-(5)'!D16:O16))","v":""},{"$f":"IF(P16=\"\",\"\",AVERAGE(D16:O16,'Form-10-(2)'!D16:O16,'Form-10-(3)'!D16:O16,'Form-10-(4)'!D16:O16,'Form-10-(5)'!D16:O16))","v":""},{"$f":"IF(Q16=\"\",\"\",MAX(D16:O16,'Form-10-(2)'!D16:O16,'Form-10-(3)'!D16:O16,'Form-10-(4)'!D16:O16,'Form-10-(5)'!D16:O16))","v":""},""]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D17:O17,'Form-10-(2)'!D17:O17,'Form-10-(3)'!D17:O17,'Form-10-(4)'!D17:O17,'Form-10-(5)'!D17:O17)=0,\"\",COUNT('Form-10-(1)'!D17:O17,'Form-10-(2)'!D17:O17,'Form-10-(3)'!D17:O17,'Form-10-(4)'!D17:O17,'Form-10-(5)'!D17:O17))","v":""},{"$f":"IF(P17=\"\",\"\",AVERAGE(D17:O17,'Form-10-(2)'!D17:O17,'Form-10-(3)'!D17:O17,'Form-10-(4)'!D17:O17,'Form-10-(5)'!D17:O17))","v":""},{"$f":"IF(Q17=\"\",\"\",MAX(D17:O17,'Form-10-(2)'!D17:O17,'Form-10-(3)'!D17:O17,'Form-10-(4)'!D17:O17,'Form-10-(5)'!D17:O17))","v":""},""]
[null,"n-Hexane",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D18:O18,'Form-10-(2)'!D18:O18,'Form-10-(3)'!D18:O18,'Form-10-(4)'!D18:O18,'Form-10-(5)'!D18:O18)=0,\"\",COUNT('Form-10-(1)'!D18:O18,'Form-10-(2)'!D18:O18,'Form-10-(3)'!D18:O18,'Form-10-(4)'!D18:O18,'Form-10-(5)'!D18:O18))","v":""},{"$f":"IF(P18=\"\",\"\",AVERAGE(D18:O18,'Form-10-(2)'!D18:O18,'Form-10-(3)'!D18:O18,'Form-10-(4)'!D18:O18,'Form-10-(5)'!D18:O18))","v":""},{"$f":"IF(Q18=\"\",\"\",MAX(D18:O18,'Form-10-(2)'!D18:O18,'Form-10-(3)'!D18:O18,'Form-10-(4)'!D18:O18,'Form-10-(5)'!D18:O18))","v":""},""]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D19:O19,'Form-10-(2)'!D19:O19,'Form-10-(3)'!D19:O19,'Form-10-(4)'!D19:O19,'Form-10-(5)'!D19:O19)=0,\"\",COUNT('Form-10-(1)'!D19:O19,'Form-10-(2)'!D19:O19,'Form-10-(3)'!D19:O19,'Form-10-(4)'!D19:O19,'Form-10-(5)'!D19:O19))","v":""},{"$f":"IF(P19=\"\",\"\",AVERAGE(D19:O19,'Form-10-(2)'!D19:O19,'Form-10-(3)'!D19:O19,'Form-10-(4)'!D19:O19,'Form-10-(5)'!D19:O19))","v":""},{"$f":"IF(Q19=\"\",\"\",MAX(D19:O19,'Form-10-(2)'!D19:O19,'Form-10-(3)'!D19:O19,'Form-10-(4)'!D19:O19,'Form-10-(5)'!D19:O19))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D20:O20,'Form-10-(2)'!D20:O20,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D20:O20,'Form-10-(2)'!D20:O20,#REF!,#REF!))","v":""}]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D21:O21,'Form-10-(2)'!D21:O21,'Form-10-(3)'!D21:O21,'Form-10-(4)'!D21:O21,'Form-10-(5)'!D21:O21)=0,\"\",COUNT('Form-10-(1)'!D21:O21,'Form-10-(2)'!D21:O21,'Form-10-(3)'!D21:O21,'Form-10-(4)'!D21:O21,'Form-10-(5)'!D21:O21))","v":""},{"$f":"IF(P21=\"\",\"\",AVERAGE(D21:O21,'Form-10-(2)'!D21:O21,'Form-10-(3)'!D21:O21,'Form-10-(4)'!D21:O21,'Form-10-(5)'!D21:O21))","v":""},{"$f":"IF(Q21=\"\",\"\",MAX(D21:O21,'Form-10-(2)'!D21:O21,'Form-10-(3)'!D21:O21,'Form-10-(4)'!D21:O21,'Form-10-(5)'!D21:O21))","v":""},""]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D22:O22,'Form-10-(2)'!D22:O22,'Form-10-(3)'!D22:O22,'Form-10-(4)'!D22:O22,'Form-10-(5)'!D22:O22)=0,\"\",COUNT('Form-10-(1)'!D22:O22,'Form-10-(2)'!D22:O22,'Form-10-(3)'!D22:O22,'Form-10-(4)'!D22:O22,'Form-10-(5)'!D22:O22))","v":""},{"$f":"IF(P22=\"\",\"\",AVERAGE(D22:O22,'Form-10-(2)'!D22:O22,'Form-10-(3)'!D22:O22,'Form-10-(4)'!D22:O22,'Form-10-(5)'!D22:O22))","v":""},{"$f":"IF(Q22=\"\",\"\",MAX(D22:O22,'Form-10-(2)'!D22:O22,'Form-10-(3)'!D22:O22,'Form-10-(4)'!D22:O22,'Form-10-(5)'!D22:O22))","v":""},""]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D23:O23,'Form-10-(2)'!D23:O23,'Form-10-(3)'!D23:O23,'Form-10-(4)'!D23:O23,'Form-10-(5)'!D23:O23)=0,\"\",COUNT('Form-10-(1)'!D23:O23,'Form-10-(2)'!D23:O23,'Form-10-(3)'!D23:O23,'Form-10-(4)'!D23:O23,'Form-10-(5)'!D23:O23))","v":""},{"$f":"IF(P23=\"\",\"\",AVERAGE(D23:O23,'Form-10-(2)'!D23:O23,'Form-10-(3)'!D23:O23,'Form-10-(4)'!D23:O23,'Form-10-(5)'!D23:O23))","v":""},{"$f":"IF(Q23=\"\",\"\",MAX(D23:O23,'Form-10-(2)'!D23:O23,'Form-10-(3)'!D23:O23,'Form-10-(4)'!D23:O23,'Form-10-(5)'!D23:O23))","v":""},{"$f":"IF(OR((Q23=\"\"),(R23=\"\")),\"\",R23/Q23)","v":""}]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D24:O24,'Form-10-(2)'!D24:O24,'Form-10-(3)'!D24:O24,'Form-10-(4)'!D24:O24,'Form-10-(5)'!D24:O24)=0,\"\",COUNT('Form-10-(1)'!D24:O24,'Form-10-(2)'!D24:O24,'Form-10-(3)'!D24:O24,'Form-10-(4)'!D24:O24,'Form-10-(5)'!D24:O24))","v":""},{"$f":"IF(P24=\"\",\"\",AVERAGE(D24:O24,'Form-10-(2)'!D24:O24,'Form-10-(3)'!D24:O24,'Form-10-(4)'!D24:O24,'Form-10-(5)'!D24:O24))","v":""},{"$f":"IF(Q24=\"\",\"\",MAX(D24:O24,'Form-10-(2)'!D24:O24,'Form-10-(3)'!D24:O24,'Form-10-(4)'!D24:O24,'Form-10-(5)'!D24:O24))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D25:O25,'Form-10-(2)'!D25:O25,'Form-10-(3)'!D25:O25,'Form-10-(4)'!D25:O25,'Form-10-(5)'!D25:O25)=0,\"\",COUNT('Form-10-(1)'!D25:O25,'Form-10-(2)'!D25:O25,'Form-10-(3)'!D25:O25,'Form-10-(4)'!D25:O25,'Form-10-(5)'!D25:O25))","v":""},{"$f":"IF(P25=\"\",\"\",AVERAGE(D25:O25,'Form-10-(2)'!D25:O25,'Form-10-(3)'!D25:O25,'Form-10-(4)'!D25:O25,'Form-10-(5)'!D25:O25))","v":""},{"$f":"IF(Q25=\"\",\"\",MAX(D25:O25,'Form-10-(2)'!D25:O25,'Form-10-(3)'!D25:O25,'Form-10-(4)'!D25:O25,'Form-10-(5)'!D25:O25))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D26:O26,'Form-10-(2)'!D26:O26,'Form-10-(3)'!D26:O26,'Form-10-(4)'!D26:O26,'Form-10-(5)'!D26:O26)=0,\"\",COUNT('Form-10-(1)'!D26:O26,'Form-10-(2)'!D26:O26,'Form-10-(3)'!D26:O26,'Form-10-(4)'!D26:O26,'Form-10-(5)'!D26:O26))","v":""},{"$f":"IF(P26=\"\",\"\",AVERAGE(D26:O26,'Form-10-(2)'!D26:O26,'Form-10-(3)'!D26:O26,'Form-10-(4)'!D26:O26,'Form-10-(5)'!D26:O26))","v":""},{"$f":"IF(Q26=\"\",\"\",MAX(D26:O26,'Form-10-(2)'!D26:O26,'Form-10-(3)'!D26:O26,'Form-10-(4)'!D26:O26,'Form-10-(5)'!D26:O26))","v":""},""]
[null,"OTHER ANALYTES",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D27:O27,'Form-10-(2)'!D27:O27,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D27:O27,'Form-10-(2)'!D27:O27,#REF!,#REF!))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D28:O28,'Form-10-(2)'!D28:O28,'Form-10-(3)'!D28:O28,'Form-10-(4)'!D28:O28,'Form-10-(5)'!D28:O28)=0,\"\",COUNT('Form-10-(1)'!D28:O28,'Form-10-(2)'!D28:O28,'Form-10-(3)'!D28:O28,'Form-10-(4)'!D28:O28,'Form-10-(5)'!D28:O28))","v":""},{"$f":"IF(P28=\"\",\"\",AVERAGE(D28:O28,'Form-10-(2)'!D28:O28,'Form-10-(3)'!D28:O28,'Form-10-(4)'!D28:O28,'Form-10-(5)'!D28:O28))","v":""},{"$f":"IF(Q28=\"\",\"\",MAX(D28:O28,'Form-10-(2)'!D28:O28,'Form-10-(3)'!D28:O28,'Form-10-(4)'!D28:O28,'Form-10-(5)'!D28:O28))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D29:O29,'Form-10-(2)'!D29:O29,'Form-10-(3)'!D29:O29,'Form-10-(4)'!D29:O29,'Form-10-(5)'!D29:O29)=0,\"\",COUNT('Form-10-(1)'!D29:O29,'Form-10-(2)'!D29:O29,'Form-10-(3)'!D29:O29,'Form-10-(4)'!D29:O29,'Form-10-(5)'!D29:O29))","v":""},{"$f":"IF(P29=\"\",\"\",AVERAGE(D29:O29,'Form-10-(2)'!D29:O29,'Form-10-(3)'!D29:O29,'Form-10-(4)'!D29:O29,'Form-10-(5)'!D29:O29))","v":""},{"$f":"IF(Q29=\"\",\"\",MAX(D29:O29,'Form-10-(2)'!D29:O29,'Form-10-(3)'!D29:O29,'Form-10-(4)'!D29:O29,'Form-10-(5)'!D29:O29))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D30:O30,'Form-10-(2)'!D30:O30,'Form-10-(3)'!D30:O30,'Form-10-(4)'!D30:O30,'Form-10-(5)'!D30:O30)=0,\"\",COUNT('Form-10-(1)'!D30:O30,'Form-10-(2)'!D30:O30,'Form-10-(3)'!D30:O30,'Form-10-(4)'!D30:O30,'Form-10-(5)'!D30:O30))","v":""},{"$f":"IF(P30=\"\",\"\",AVERAGE(D30:O30,'Form-10-(2)'!D30:O30,'Form-10-(3)'!D30:O30,'Form-10-(4)'!D30:O30,'Form-10-(5)'!D30:O30))","v":""},{"$f":"IF(Q30=\"\",\"\",MAX(D30:O30,'Form-10-(2)'!D30:O30,'Form-10-(3)'!D30:O30,'Form-10-(4)'!D30:O30,'Form-10-(5)'!D30:O30))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D31:O31,'Form-10-(2)'!D31:O31,'Form-10-(3)'!D31:O31,'Form-10-(4)'!D31:O31,'Form-10-(5)'!D31:O31)=0,\"\",COUNT('Form-10-(1)'!D31:O31,'Form-10-(2)'!D31:O31,'Form-10-(3)'!D31:O31,'Form-10-(4)'!D31:O31,'Form-10-(5)'!D31:O31))","v":""},{"$f":"IF(P31=\"\",\"\",AVERAGE(D31:O31,'Form-10-(2)'!D31:O31,'Form-10-(3)'!D31:O31,'Form-10-(4)'!D31:O31,'Form-10-(5)'!D31:O31))","v":""},{"$f":"IF(Q31=\"\",\"\",MAX(D31:O31,'Form-10-(2)'!D31:O31,'Form-10-(3)'!D31:O31,'Form-10-(4)'!D31:O31,'Form-10-(5)'!D31:O31))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D32:O32,'Form-10-(2)'!D32:O32,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D32:O32,'Form-10-(2)'!D32:O32,#REF!,#REF!))","v":""},{"$f":"IF(P32=\"\",\"\",AVERAGE(D32:O32,'Form-10-(2)'!D32:O32,#REF!,#REF!))","v":""},{"$f":"IF(Q32=\"\",\"\",MAX(D32:O32,'Form-10-(2)'!D32:O32,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D33:O33,'Form-10-(2)'!D33:O33,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D33:O33,'Form-10-(2)'!D33:O33,#REF!,#REF!))","v":""},{"$f":"IF(P33=\"\",\"\",AVERAGE(D33:O33,'Form-10-(2)'!D33:O33,#REF!,#REF!))","v":""},{"$f":"IF(Q33=\"\",\"\",MAX(D33:O33,'Form-10-(2)'!D33:O33,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D34:O34,'Form-10-(2)'!D34:O34,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D34:O34,'Form-10-(2)'!D34:O34,#REF!,#REF!))","v":""},{"$f":"IF(P34=\"\",\"\",AVERAGE(D34:O34,'Form-10-(2)'!D34:O34,#REF!,#REF!))","v":""},{"$f":"IF(Q34=\"\",\"\",MAX(D34:O34,'Form-10-(2)'!D34:O34,#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-10-(1)'!D35:O35,'Form-10-(2)'!D35:O35,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D35:O35,'Form-10-(2)'!D35:O35,#REF!,#REF!))","v":""},{"$f":"IF(P35=\"\",\"\",AVERAGE(D35:O35,'Form-10-(2)'!D35:O35,#REF!,#REF!))","v":""},{"$f":"IF(Q35=\"\",\"\",MAX(D35:O35,'Form-10-(2)'!D35:O35,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D36:O36,'Form-10-(2)'!D36:O36,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D36:O36,'Form-10-(2)'!D36:O36,#REF!,#REF!))","v":""},{"$f":"IF(P36=\"\",\"\",AVERAGE(D36:O36,'Form-10-(2)'!D36:O36,#REF!,#REF!))","v":""},{"$f":"IF(Q36=\"\",\"\",MAX(D36:O36,'Form-10-(2)'!D36:O36,#REF!,#REF!))","v":""},{"$f":"IF(OR((Q36=\"\"),(R36=\"\")),\"\",R36/Q36)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D37:O37,'Form-10-(2)'!D37:O37,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D37:O37,'Form-10-(2)'!D37:O37,#REF!,#REF!))","v":""},{"$f":"IF(P37=\"\",\"\",AVERAGE(D37:O37,'Form-10-(2)'!D37:O37,#REF!,#REF!))","v":""},{"$f":"IF(Q37=\"\",\"\",MAX(D37:O37,'Form-10-(2)'!D37:O37,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D38:O38,'Form-10-(2)'!D38:O38,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D38:O38,'Form-10-(2)'!D38:O38,#REF!,#REF!))","v":""},{"$f":"IF(P38=\"\",\"\",AVERAGE(D38:O38,'Form-10-(2)'!D38:O38,#REF!,#REF!))","v":""},{"$f":"IF(Q38=\"\",\"\",MAX(D38:O38,'Form-10-(2)'!D38:O38,#REF!,#REF!))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT('Form-10-(1)'!D39:O39,'Form-10-(2)'!D39:O39,#REF!,#REF!)=0,\"\",COUNT('Form-10-(1)'!D39:O39,'Form-10-(2)'!D39:O39,#REF!,#REF!))","v":""},{"$f":"IF(P39=\"\",\"\",AVERAGE(D39:O39,'Form-10-(2)'!D39:O39,#REF!,#REF!))","v":""},{"$f":"IF(Q39=\"\",\"\",MAX(D39:O39,'Form-10-(2)'!D39:O39,#REF!,#REF!))","v":""},""]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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-10-(2)","index":20,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[[7,1,7,17],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,9,9,11],[9,12,9,14],[10,9,10,11],[10,12,10,14],[29,1,29,2],[30,1,30,2],[9,3,9,5],[9,6,9,8],[27,1,27,2],[28,1,28,2],[10,3,10,5],[10,6,10,8]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 10  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Soil sample depth greater than 3 ft bgl; All concentrations in mg/kg.)"]
[]
[null,{"$f":"IF('Form-10-(1)'!B10:C10=\"\",\"\",'Form-10-(1)'!B10:C10)","v":"MW / SB No. "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,{"$f":"IF('Form-10-(1)'!B11:C11=\"\",\"\",'Form-10-(1)'!B11:C11)","v":"Sampling Date"}]
[null,{"$f":"IF('Form-10-(1)'!B12:C12=\"\",\"\",'Form-10-(1)'!B12:C12)","v":"Sample Depth (ft)"}]
[null,{"$f":"IF('Form-10-(1)'!B13:C13=\"\",\"\",'Form-10-(1)'!B13:C13)","v":"VOLATILE ORGANIC CHEMICALS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B14:C14=\"\",\"\",'Form-10-(1)'!B14:C14)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q14","v":""},{"$f":"'Form-10-(1)'!R14","v":""},{"$f":"'Form-10-(1)'!S14","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B15:C15=\"\",\"\",'Form-10-(1)'!B15:C15)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q15","v":""},{"$f":"'Form-10-(1)'!R15","v":""},{"$f":"'Form-10-(1)'!S15","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B16:C16=\"\",\"\",'Form-10-(1)'!B16:C16)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q16","v":""},{"$f":"'Form-10-(1)'!R16","v":""},{"$f":"'Form-10-(1)'!S16","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B17:C17=\"\",\"\",'Form-10-(1)'!B17:C17)","v":"Xylenes (total)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q17","v":""},{"$f":"'Form-10-(1)'!R17","v":""},{"$f":"'Form-10-(1)'!S17","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B18:C18=\"\",\"\",'Form-10-(1)'!B18:C18)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q18","v":""},{"$f":"'Form-10-(1)'!R18","v":""},{"$f":"'Form-10-(1)'!S18","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B19:C19=\"\",\"\",'Form-10-(1)'!B19:C19)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q19","v":""},{"$f":"'Form-10-(1)'!R19","v":""},{"$f":"'Form-10-(1)'!S19","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B20:C20=\"\",\"\",'Form-10-(1)'!B20:C20)","v":"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B21:C21=\"\",\"\",'Form-10-(1)'!B21:C21)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q21","v":""},{"$f":"'Form-10-(1)'!R21","v":""},{"$f":"'Form-10-(1)'!S21","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B22:C22=\"\",\"\",'Form-10-(1)'!B22:C22)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q22","v":""},{"$f":"'Form-10-(1)'!R22","v":""},{"$f":"'Form-10-(1)'!S22","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B23:C23=\"\",\"\",'Form-10-(1)'!B23:C23)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q23","v":""},{"$f":"'Form-10-(1)'!R23","v":""},{"$f":"'Form-10-(1)'!S23","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B24=\"\",\"\",'Form-10-(1)'!B24)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C24=\"\",\"\",'Form-10-(1)'!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q24","v":""},{"$f":"'Form-10-(1)'!R24","v":""},{"$f":"'Form-10-(1)'!S24","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B25:C25=\"\",\"\",'Form-10-(1)'!B25:C25)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C25=\"\",\"\",'Form-10-(1)'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q25","v":""},{"$f":"'Form-10-(1)'!R25","v":""},{"$f":"'Form-10-(1)'!S25","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B26:C26=\"\",\"\",'Form-10-(1)'!B26:C26)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C26=\"\",\"\",'Form-10-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q26","v":""},{"$f":"'Form-10-(1)'!R26","v":""},{"$f":"'Form-10-(1)'!S26","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-10-(1)'!B28=\"\",\"\",'Form-10-(1)'!B28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q28","v":""},{"$f":"'Form-10-(1)'!R28","v":""},{"$f":"'Form-10-(1)'!S28","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B29=\"\",\"\",'Form-10-(1)'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q29","v":""},{"$f":"'Form-10-(1)'!R29","v":""},{"$f":"'Form-10-(1)'!S29","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B30=\"\",\"\",'Form-10-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q30","v":""},{"$f":"'Form-10-(1)'!R30","v":""},{"$f":"'Form-10-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B31=\"\",\"\",'Form-10-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q31","v":""},{"$f":"'Form-10-(1)'!R31","v":""},{"$f":"'Form-10-(1)'!S31","v":""}]
[null,"Cadmium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q32","v":""},{"$f":"'Form-10-(1)'!R32","v":""},{"$f":"'Form-10-(1)'!S32","v":""}]
[null,"Chromium III",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q33","v":""},{"$f":"'Form-10-(1)'!R33","v":""},{"$f":"'Form-10-(1)'!S33","v":""}]
[null,"Chromium IV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q34","v":""},{"$f":"'Form-10-(1)'!R34","v":""},{"$f":"'Form-10-(1)'!S34","v":""}]
[null,"Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q35","v":""},{"$f":"'Form-10-(1)'!R35","v":""},{"$f":"'Form-10-(1)'!S35","v":""}]
[null,"Tetraethyl Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q36","v":""},{"$f":"'Form-10-(1)'!R36","v":""},{"$f":"'Form-10-(1)'!S36","v":""}]
[null,"Mercury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q37","v":""},{"$f":"'Form-10-(1)'!R37","v":""},{"$f":"'Form-10-(1)'!S37","v":""}]
[null,"Selenium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q38","v":""},{"$f":"'Form-10-(1)'!R38","v":""},{"$f":"'Form-10-(1)'!S38","v":""}]
[null,"Silver",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q39","v":""},{"$f":"'Form-10-(1)'!R39","v":""},{"$f":"'Form-10-(1)'!S39","v":""}]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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-10-(3)","index":21,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[9,3,9,5],[9,6,9,8],[27,1,27,2],[28,1,28,2],[10,3,10,5],[10,6,10,8],[7,1,7,17],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,9,9,11],[9,12,9,14],[10,9,10,11],[10,12,10,14]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 10  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Soil sample depth greater than 3 ft bgl; All concentrations in mg/kg.)"]
[]
[null,{"$f":"IF('Form-10-(1)'!B10:C10=\"\",\"\",'Form-10-(1)'!B10:C10)","v":"MW / SB No. "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,{"$f":"IF('Form-10-(1)'!B11:C11=\"\",\"\",'Form-10-(1)'!B11:C11)","v":"Sampling Date"}]
[null,{"$f":"IF('Form-10-(1)'!B12:C12=\"\",\"\",'Form-10-(1)'!B12:C12)","v":"Sample Depth (ft)"}]
[null,{"$f":"IF('Form-10-(1)'!B13:C13=\"\",\"\",'Form-10-(1)'!B13:C13)","v":"VOLATILE ORGANIC CHEMICALS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B14:C14=\"\",\"\",'Form-10-(1)'!B14:C14)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q14","v":""},{"$f":"'Form-10-(1)'!R14","v":""},{"$f":"'Form-10-(1)'!S14","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B15:C15=\"\",\"\",'Form-10-(1)'!B15:C15)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q15","v":""},{"$f":"'Form-10-(1)'!R15","v":""},{"$f":"'Form-10-(1)'!S15","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B16:C16=\"\",\"\",'Form-10-(1)'!B16:C16)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q16","v":""},{"$f":"'Form-10-(1)'!R16","v":""},{"$f":"'Form-10-(1)'!S16","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B17:C17=\"\",\"\",'Form-10-(1)'!B17:C17)","v":"Xylenes (total)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q17","v":""},{"$f":"'Form-10-(1)'!R17","v":""},{"$f":"'Form-10-(1)'!S17","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B18:C18=\"\",\"\",'Form-10-(1)'!B18:C18)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q18","v":""},{"$f":"'Form-10-(1)'!R18","v":""},{"$f":"'Form-10-(1)'!S18","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B19:C19=\"\",\"\",'Form-10-(1)'!B19:C19)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q19","v":""},{"$f":"'Form-10-(1)'!R19","v":""},{"$f":"'Form-10-(1)'!S19","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B20:C20=\"\",\"\",'Form-10-(1)'!B20:C20)","v":"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B21:C21=\"\",\"\",'Form-10-(1)'!B21:C21)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q21","v":""},{"$f":"'Form-10-(1)'!R21","v":""},{"$f":"'Form-10-(1)'!S21","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B22:C22=\"\",\"\",'Form-10-(1)'!B22:C22)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q22","v":""},{"$f":"'Form-10-(1)'!R22","v":""},{"$f":"'Form-10-(1)'!S22","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B23:C23=\"\",\"\",'Form-10-(1)'!B23:C23)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q23","v":""},{"$f":"'Form-10-(1)'!R23","v":""},{"$f":"'Form-10-(1)'!S23","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B24=\"\",\"\",'Form-10-(1)'!B24)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C24=\"\",\"\",'Form-10-(1)'!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q24","v":""},{"$f":"'Form-10-(1)'!R24","v":""},{"$f":"'Form-10-(1)'!S24","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B25:C25=\"\",\"\",'Form-10-(1)'!B25:C25)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C25=\"\",\"\",'Form-10-(1)'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q25","v":""},{"$f":"'Form-10-(1)'!R25","v":""},{"$f":"'Form-10-(1)'!S25","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B26:C26=\"\",\"\",'Form-10-(1)'!B26:C26)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C26=\"\",\"\",'Form-10-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q26","v":""},{"$f":"'Form-10-(1)'!R26","v":""},{"$f":"'Form-10-(1)'!S26","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-10-(1)'!B28=\"\",\"\",'Form-10-(1)'!B28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q28","v":""},{"$f":"'Form-10-(1)'!R28","v":""},{"$f":"'Form-10-(1)'!S28","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B29=\"\",\"\",'Form-10-(1)'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q29","v":""},{"$f":"'Form-10-(1)'!R29","v":""},{"$f":"'Form-10-(1)'!S29","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B30=\"\",\"\",'Form-10-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q30","v":""},{"$f":"'Form-10-(1)'!R30","v":""},{"$f":"'Form-10-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B31=\"\",\"\",'Form-10-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q31","v":""},{"$f":"'Form-10-(1)'!R31","v":""},{"$f":"'Form-10-(1)'!S31","v":""}]
[null,"Cadmium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q32","v":""},{"$f":"'Form-10-(1)'!R32","v":""},{"$f":"'Form-10-(1)'!S32","v":""}]
[null,"Chromium III",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q33","v":""},{"$f":"'Form-10-(1)'!R33","v":""},{"$f":"'Form-10-(1)'!S33","v":""}]
[null,"Chromium IV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q34","v":""},{"$f":"'Form-10-(1)'!R34","v":""},{"$f":"'Form-10-(1)'!S34","v":""}]
[null,"Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q35","v":""},{"$f":"'Form-10-(1)'!R35","v":""},{"$f":"'Form-10-(1)'!S35","v":""}]
[null,"Tetraethyl Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q36","v":""},{"$f":"'Form-10-(1)'!R36","v":""},{"$f":"'Form-10-(1)'!S36","v":""}]
[null,"Mercury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q37","v":""},{"$f":"'Form-10-(1)'!R37","v":""},{"$f":"'Form-10-(1)'!S37","v":""}]
[null,"Selenium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q38","v":""},{"$f":"'Form-10-(1)'!R38","v":""},{"$f":"'Form-10-(1)'!S38","v":""}]
[null,"Silver",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q39","v":""},{"$f":"'Form-10-(1)'!R39","v":""},{"$f":"'Form-10-(1)'!S39","v":""}]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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-10-(4)","index":22,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[9,3,9,5],[9,6,9,8],[27,1,27,2],[28,1,28,2],[10,3,10,5],[10,6,10,8],[7,1,7,17],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,9,9,11],[9,12,9,14],[10,9,10,11],[10,12,10,14]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 10  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Soil sample depth greater than 3 ft bgl; All concentrations in mg/kg.)"]
[]
[null,{"$f":"IF('Form-10-(1)'!B10:C10=\"\",\"\",'Form-10-(1)'!B10:C10)","v":"MW / SB No. "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,{"$f":"IF('Form-10-(1)'!B11:C11=\"\",\"\",'Form-10-(1)'!B11:C11)","v":"Sampling Date"}]
[null,{"$f":"IF('Form-10-(1)'!B12:C12=\"\",\"\",'Form-10-(1)'!B12:C12)","v":"Sample Depth (ft)"}]
[null,{"$f":"IF('Form-10-(1)'!B13:C13=\"\",\"\",'Form-10-(1)'!B13:C13)","v":"VOLATILE ORGANIC CHEMICALS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B14:C14=\"\",\"\",'Form-10-(1)'!B14:C14)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q14","v":""},{"$f":"'Form-10-(1)'!R14","v":""},{"$f":"'Form-10-(1)'!S14","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B15:C15=\"\",\"\",'Form-10-(1)'!B15:C15)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q15","v":""},{"$f":"'Form-10-(1)'!R15","v":""},{"$f":"'Form-10-(1)'!S15","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B16:C16=\"\",\"\",'Form-10-(1)'!B16:C16)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q16","v":""},{"$f":"'Form-10-(1)'!R16","v":""},{"$f":"'Form-10-(1)'!S16","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B17:C17=\"\",\"\",'Form-10-(1)'!B17:C17)","v":"Xylenes (total)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q17","v":""},{"$f":"'Form-10-(1)'!R17","v":""},{"$f":"'Form-10-(1)'!S17","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B18:C18=\"\",\"\",'Form-10-(1)'!B18:C18)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q18","v":""},{"$f":"'Form-10-(1)'!R18","v":""},{"$f":"'Form-10-(1)'!S18","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B19:C19=\"\",\"\",'Form-10-(1)'!B19:C19)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q19","v":""},{"$f":"'Form-10-(1)'!R19","v":""},{"$f":"'Form-10-(1)'!S19","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B20:C20=\"\",\"\",'Form-10-(1)'!B20:C20)","v":"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B21:C21=\"\",\"\",'Form-10-(1)'!B21:C21)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q21","v":""},{"$f":"'Form-10-(1)'!R21","v":""},{"$f":"'Form-10-(1)'!S21","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B22:C22=\"\",\"\",'Form-10-(1)'!B22:C22)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q22","v":""},{"$f":"'Form-10-(1)'!R22","v":""},{"$f":"'Form-10-(1)'!S22","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B23:C23=\"\",\"\",'Form-10-(1)'!B23:C23)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q23","v":""},{"$f":"'Form-10-(1)'!R23","v":""},{"$f":"'Form-10-(1)'!S23","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B24=\"\",\"\",'Form-10-(1)'!B24)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C24=\"\",\"\",'Form-10-(1)'!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q24","v":""},{"$f":"'Form-10-(1)'!R24","v":""},{"$f":"'Form-10-(1)'!S24","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B25:C25=\"\",\"\",'Form-10-(1)'!B25:C25)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C25=\"\",\"\",'Form-10-(1)'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q25","v":""},{"$f":"'Form-10-(1)'!R25","v":""},{"$f":"'Form-10-(1)'!S25","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B26:C26=\"\",\"\",'Form-10-(1)'!B26:C26)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C26=\"\",\"\",'Form-10-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q26","v":""},{"$f":"'Form-10-(1)'!R26","v":""},{"$f":"'Form-10-(1)'!S26","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-10-(1)'!B28=\"\",\"\",'Form-10-(1)'!B28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q28","v":""},{"$f":"'Form-10-(1)'!R28","v":""},{"$f":"'Form-10-(1)'!S28","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B29=\"\",\"\",'Form-10-(1)'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q29","v":""},{"$f":"'Form-10-(1)'!R29","v":""},{"$f":"'Form-10-(1)'!S29","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B30=\"\",\"\",'Form-10-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q30","v":""},{"$f":"'Form-10-(1)'!R30","v":""},{"$f":"'Form-10-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B31=\"\",\"\",'Form-10-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q31","v":""},{"$f":"'Form-10-(1)'!R31","v":""},{"$f":"'Form-10-(1)'!S31","v":""}]
[null,"Cadmium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q32","v":""},{"$f":"'Form-10-(1)'!R32","v":""},{"$f":"'Form-10-(1)'!S32","v":""}]
[null,"Chromium III",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q33","v":""},{"$f":"'Form-10-(1)'!R33","v":""},{"$f":"'Form-10-(1)'!S33","v":""}]
[null,"Chromium IV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q34","v":""},{"$f":"'Form-10-(1)'!R34","v":""},{"$f":"'Form-10-(1)'!S34","v":""}]
[null,"Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q35","v":""},{"$f":"'Form-10-(1)'!R35","v":""},{"$f":"'Form-10-(1)'!S35","v":""}]
[null,"Tetraethyl Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q36","v":""},{"$f":"'Form-10-(1)'!R36","v":""},{"$f":"'Form-10-(1)'!S36","v":""}]
[null,"Mercury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q37","v":""},{"$f":"'Form-10-(1)'!R37","v":""},{"$f":"'Form-10-(1)'!S37","v":""}]
[null,"Selenium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q38","v":""},{"$f":"'Form-10-(1)'!R38","v":""},{"$f":"'Form-10-(1)'!S38","v":""}]
[null,"Silver",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q39","v":""},{"$f":"'Form-10-(1)'!R39","v":""},{"$f":"'Form-10-(1)'!S39","v":""}]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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-10-(5)","index":23,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":true,"merged":[[29,1,29,2],[30,1,30,2],[9,3,9,5],[9,6,9,8],[27,1,27,2],[28,1,28,2],[10,3,10,5],[10,6,10,8],[7,1,7,17],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,9,9,11],[9,12,9,14],[10,9,10,11],[10,12,10,14]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 10  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,null,null,null,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"ANALYTICAL DATA SUMMARY FOR SUBSURFACE SOIL (Soil sample depth greater than 3 ft bgl; All concentrations in mg/kg.)"]
[]
[null,{"$f":"IF('Form-10-(1)'!B10:C10=\"\",\"\",'Form-10-(1)'!B10:C10)","v":"MW / SB No. "},null,null,null,null,null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,{"$f":"IF('Form-10-(1)'!B11:C11=\"\",\"\",'Form-10-(1)'!B11:C11)","v":"Sampling Date"}]
[null,{"$f":"IF('Form-10-(1)'!B12:C12=\"\",\"\",'Form-10-(1)'!B12:C12)","v":"Sample Depth (ft)"}]
[null,{"$f":"IF('Form-10-(1)'!B13:C13=\"\",\"\",'Form-10-(1)'!B13:C13)","v":"VOLATILE ORGANIC CHEMICALS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B14:C14=\"\",\"\",'Form-10-(1)'!B14:C14)","v":"Benzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q14","v":""},{"$f":"'Form-10-(1)'!R14","v":""},{"$f":"'Form-10-(1)'!S14","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B15:C15=\"\",\"\",'Form-10-(1)'!B15:C15)","v":"Toluene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q15","v":""},{"$f":"'Form-10-(1)'!R15","v":""},{"$f":"'Form-10-(1)'!S15","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B16:C16=\"\",\"\",'Form-10-(1)'!B16:C16)","v":"Ethylbenzene"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q16","v":""},{"$f":"'Form-10-(1)'!R16","v":""},{"$f":"'Form-10-(1)'!S16","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B17:C17=\"\",\"\",'Form-10-(1)'!B17:C17)","v":"Xylenes (total)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q17","v":""},{"$f":"'Form-10-(1)'!R17","v":""},{"$f":"'Form-10-(1)'!S17","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B18:C18=\"\",\"\",'Form-10-(1)'!B18:C18)","v":"n-Hexane"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q18","v":""},{"$f":"'Form-10-(1)'!R18","v":""},{"$f":"'Form-10-(1)'!S18","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B19:C19=\"\",\"\",'Form-10-(1)'!B19:C19)","v":"Methyl-tert-butyl-ether (MTBE)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q19","v":""},{"$f":"'Form-10-(1)'!R19","v":""},{"$f":"'Form-10-(1)'!S19","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B20:C20=\"\",\"\",'Form-10-(1)'!B20:C20)","v":"TOTAL EXTRACTABLE HYDROCARBONS ANALYSES"}]
[null,{"$f":"IF('Form-10-(1)'!B21:C21=\"\",\"\",'Form-10-(1)'!B21:C21)","v":"TEH (as diesel)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q21","v":""},{"$f":"'Form-10-(1)'!R21","v":""},{"$f":"'Form-10-(1)'!S21","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B22:C22=\"\",\"\",'Form-10-(1)'!B22:C22)","v":"TEH (as waste oil)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q22","v":""},{"$f":"'Form-10-(1)'!R22","v":""},{"$f":"'Form-10-(1)'!S22","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B23:C23=\"\",\"\",'Form-10-(1)'!B23:C23)","v":"TEH (as kerosene)"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q23","v":""},{"$f":"'Form-10-(1)'!R23","v":""},{"$f":"'Form-10-(1)'!S23","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B24=\"\",\"\",'Form-10-(1)'!B24)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C24=\"\",\"\",'Form-10-(1)'!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q24","v":""},{"$f":"'Form-10-(1)'!R24","v":""},{"$f":"'Form-10-(1)'!S24","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B25:C25=\"\",\"\",'Form-10-(1)'!B25:C25)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C25=\"\",\"\",'Form-10-(1)'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q25","v":""},{"$f":"'Form-10-(1)'!R25","v":""},{"$f":"'Form-10-(1)'!S25","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B26:C26=\"\",\"\",'Form-10-(1)'!B26:C26)","v":"TEH as"},{"$f":"IF('Form-10-(1)'!C26=\"\",\"\",'Form-10-(1)'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q26","v":""},{"$f":"'Form-10-(1)'!R26","v":""},{"$f":"'Form-10-(1)'!S26","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-10-(1)'!B28=\"\",\"\",'Form-10-(1)'!B28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q28","v":""},{"$f":"'Form-10-(1)'!R28","v":""},{"$f":"'Form-10-(1)'!S28","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B29=\"\",\"\",'Form-10-(1)'!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q29","v":""},{"$f":"'Form-10-(1)'!R29","v":""},{"$f":"'Form-10-(1)'!S29","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B30=\"\",\"\",'Form-10-(1)'!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q30","v":""},{"$f":"'Form-10-(1)'!R30","v":""},{"$f":"'Form-10-(1)'!S30","v":""}]
[null,{"$f":"IF('Form-10-(1)'!B31=\"\",\"\",'Form-10-(1)'!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q31","v":""},{"$f":"'Form-10-(1)'!R31","v":""},{"$f":"'Form-10-(1)'!S31","v":""}]
[null,"Cadmium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q32","v":""},{"$f":"'Form-10-(1)'!R32","v":""},{"$f":"'Form-10-(1)'!S32","v":""}]
[null,"Chromium III",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q33","v":""},{"$f":"'Form-10-(1)'!R33","v":""},{"$f":"'Form-10-(1)'!S33","v":""}]
[null,"Chromium IV",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q34","v":""},{"$f":"'Form-10-(1)'!R34","v":""},{"$f":"'Form-10-(1)'!S34","v":""}]
[null,"Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q35","v":""},{"$f":"'Form-10-(1)'!R35","v":""},{"$f":"'Form-10-(1)'!S35","v":""}]
[null,"Tetraethyl Lead",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q36","v":""},{"$f":"'Form-10-(1)'!R36","v":""},{"$f":"'Form-10-(1)'!S36","v":""}]
[null,"Mercury",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q37","v":""},{"$f":"'Form-10-(1)'!R37","v":""},{"$f":"'Form-10-(1)'!S37","v":""}]
[null,"Selenium",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q38","v":""},{"$f":"'Form-10-(1)'!R38","v":""},{"$f":"'Form-10-(1)'!S38","v":""}]
[null,"Silver",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Form-10-(1)'!Q39","v":""},{"$f":"'Form-10-(1)'!R39","v":""},{"$f":"'Form-10-(1)'!S39","v":""}]
[null,"NOTE:"]
[null,"          Provide any laboratory analytical data sheets 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-11a-(1)","index":24,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":true,"merged":[[7,1,7,13],[10,11,14,11],[10,12,14,12],[10,13,14,13],[33,1,33,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 11a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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 (All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)",null,null,null,null,null,null,null,null,"Number"]
[null,"Last Sampling Event",null,null,null,null,null,null,null,null,"Detects"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D17:J17,'Form-11a-(2)'!D17:J17)=0,\"\",COUNT(D17:J17,'Form-11a-(2)'!D17:J17,'Form-11a-(3)'!D17:J17))","v":""},{"$f":"IF(K17=\"\",\"\",AVERAGE(D17:J17,'Form-11a-(2)'!D17:J17,'Form-11a-(3)'!D17:J17))","v":""},{"$f":"IF(K17=\"\",\"\",MAX(D17:J17,'Form-11a-(2)'!D17:J17,'Form-11a-(3)'!D17:J17))","v":""},{"$f":"IF(OR(L17=\"\",M17=\"\"),\"\",M17/L17)","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D18:J18,'Form-11a-(2)'!D18:J18)=0,\"\",COUNT(D18:J18,'Form-11a-(2)'!D18:J18,'Form-11a-(3)'!D18:J18))","v":""},{"$f":"IF(K18=\"\",\"\",AVERAGE(D18:J18,'Form-11a-(2)'!D18:J18,'Form-11a-(3)'!D18:J18))","v":""},{"$f":"IF(K18=\"\",\"\",MAX(D18:J18,'Form-11a-(2)'!D18:J18,'Form-11a-(3)'!D18:J18))","v":""},{"$f":"IF(OR(L18=\"\",M18=\"\"),\"\",M18/L18)","v":""},null,null,{"$f":"COUNTIF(D18:N18,\"fp\")","v":0},{"$f":"IF(Q18>0,ESOL1,IF(COUNT(D18:N18)=0,\"--\",MAX(D18:N18)))","v":"--"}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D19:J19,'Form-11a-(2)'!D19:J19)=0,\"\",COUNT(D19:J19,'Form-11a-(2)'!D19:J19,'Form-11a-(3)'!D19:J19))","v":""},{"$f":"IF(K19=\"\",\"\",AVERAGE(D19:J19,'Form-11a-(2)'!D19:J19,'Form-11a-(3)'!D19:J19))","v":""},{"$f":"IF(K19=\"\",\"\",MAX(D19:J19,'Form-11a-(2)'!D19:J19,'Form-11a-(3)'!D19:J19))","v":""},""]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D20:J20,'Form-11a-(2)'!D20:J20)=0,\"\",COUNT(D20:J20,'Form-11a-(2)'!D20:J20,'Form-11a-(3)'!D20:J20))","v":""},{"$f":"IF(K20=\"\",\"\",AVERAGE(D20:J20,'Form-11a-(2)'!D20:J20,'Form-11a-(3)'!D20:J20))","v":""},{"$f":"IF(K20=\"\",\"\",MAX(D20:J20,'Form-11a-(2)'!D20:J20,'Form-11a-(3)'!D20:J20))","v":""},""]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D21:J21,'Form-11a-(2)'!D21:J21)=0,\"\",COUNT(D21:J21,'Form-11a-(2)'!D21:J21,'Form-11a-(3)'!D21:J21))","v":""},{"$f":"IF(K21=\"\",\"\",AVERAGE(D21:J21,'Form-11a-(2)'!D21:J21,'Form-11a-(3)'!D21:J21))","v":""},{"$f":"IF(K21=\"\",\"\",MAX(D21:J21,'Form-11a-(2)'!D21:J21,'Form-11a-(3)'!D21:J21))","v":""},""]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D22:J22,'Form-11a-(2)'!D22:J22)=0,\"\",COUNT(D22:J22,'Form-11a-(2)'!D22:J22,'Form-11a-(3)'!D22:J22))","v":""},{"$f":"IF(K22=\"\",\"\",AVERAGE(D22:J22,'Form-11a-(2)'!D22:J22,'Form-11a-(3)'!D22:J22))","v":""},{"$f":"IF(K22=\"\",\"\",MAX(D22:J22,'Form-11a-(2)'!D22:J22,'Form-11a-(3)'!D22:J22))","v":""},""]
[null,"TOTAL EXTRACTABLE HYDROCARBON ANALYSIS"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D24:J24,'Form-11a-(2)'!D24:J24)=0,\"\",COUNT(D24:J24,'Form-11a-(2)'!D24:J24,'Form-11a-(3)'!D24:J24))","v":""},{"$f":"IF(K24=\"\",\"\",AVERAGE(D24:J24,'Form-11a-(2)'!D24:J24,'Form-11a-(3)'!D24:J24))","v":""},{"$f":"IF(K24=\"\",\"\",MAX(D24:J24,'Form-11a-(2)'!D24:J24,'Form-11a-(3)'!D24:J24))","v":""},""]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D25:J25,'Form-11a-(2)'!D25:J25)=0,\"\",COUNT(D25:J25,'Form-11a-(2)'!D25:J25,'Form-11a-(3)'!D25:J25))","v":""},{"$f":"IF(K25=\"\",\"\",AVERAGE(D25:J25,'Form-11a-(2)'!D25:J25,'Form-11a-(3)'!D25:J25))","v":""},{"$f":"IF(K25=\"\",\"\",MAX(D25:J25,'Form-11a-(2)'!D25:J25,'Form-11a-(3)'!D25:J25))","v":""},"",null,null,{"$f":"COUNTIF(D24:N24,\"fp\")","v":0},{"$f":"IF(Q25>0,ESOL3,IF(COUNT(D24:N24)=0,\"--\",MAX(D24:N24)))","v":"--"}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D26:J26,'Form-11a-(2)'!D26:J26)=0,\"\",COUNT(D26:J26,'Form-11a-(2)'!D26:J26,'Form-11a-(3)'!D26:J26))","v":""},{"$f":"IF(K26=\"\",\"\",AVERAGE(D26:J26,'Form-11a-(2)'!D26:J26,'Form-11a-(3)'!D26:J26))","v":""},{"$f":"IF(K26=\"\",\"\",MAX(D26:J26,'Form-11a-(2)'!D26:J26,'Form-11a-(3)'!D26:J26))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D27:J27,'Form-11a-(2)'!D27:J27)=0,\"\",COUNT(D27:J27,'Form-11a-(2)'!D27:J27,'Form-11a-(3)'!D27:J27))","v":""},{"$f":"IF(K27=\"\",\"\",AVERAGE(D27:J27,'Form-11a-(2)'!D27:J27,'Form-11a-(3)'!D27:J27))","v":""},{"$f":"IF(K27=\"\",\"\",MAX(D27:J27,'Form-11a-(2)'!D27:J27,'Form-11a-(3)'!D27:J27))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D28:J28,'Form-11a-(2)'!D28:J28)=0,\"\",COUNT(D28:J28,'Form-11a-(2)'!D28:J28,'Form-11a-(3)'!D28:J28))","v":""},{"$f":"IF(K28=\"\",\"\",AVERAGE(D28:J28,'Form-11a-(2)'!D28:J28,'Form-11a-(3)'!D28:J28))","v":""},{"$f":"IF(K28=\"\",\"\",MAX(D28:J28,'Form-11a-(2)'!D28:J28,'Form-11a-(3)'!D28:J28))","v":""},""]
[null,"TEH as",null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D29:J29,'Form-11a-(2)'!D29:J29)=0,\"\",COUNT(D29:J29,'Form-11a-(2)'!D29:J29,'Form-11a-(3)'!D29:J29))","v":""},{"$f":"IF(K29=\"\",\"\",AVERAGE(D29:J29,'Form-11a-(2)'!D29:J29,'Form-11a-(3)'!D29:J29))","v":""},{"$f":"IF(K29=\"\",\"\",MAX(D29:J29,'Form-11a-(2)'!D29:J29,'Form-11a-(3)'!D29:J29))","v":""},""]
[null,"OTHER ANALYTES"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D31:J31,'Form-11a-(2)'!D31:J31)=0,\"\",COUNT(D31:J31,'Form-11a-(2)'!D31:J31,'Form-11a-(3)'!D31:J31))","v":""},{"$f":"IF(K31=\"\",\"\",AVERAGE(D31:J31,'Form-11a-(2)'!D31:J31,'Form-11a-(3)'!D31:J31))","v":""},{"$f":"IF(K31=\"\",\"\",MAX(D31:J31,'Form-11a-(2)'!D31:J31,'Form-11a-(3)'!D31:J31))","v":""},"",null,null,{"$f":"COUNTIF(D31:N31,\"fp\")","v":0},{"$f":"IF(Q31>0,ESOL4,IF(COUNT(D31:N31)=0,\"--\",MAX(D31:N31)))","v":"--"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D32:J32,'Form-11a-(2)'!D32:J32)=0,\"\",COUNT(D32:J32,'Form-11a-(2)'!D32:J32,'Form-11a-(3)'!D32:J32))","v":""},{"$f":"IF(K32=\"\",\"\",AVERAGE(D32:J32,'Form-11a-(2)'!D32:J32,'Form-11a-(3)'!D32:J32))","v":""},{"$f":"IF(K32=\"\",\"\",MAX(D32:J32,'Form-11a-(2)'!D32:J32,'Form-11a-(3)'!D32:J32))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D33:J33,'Form-11a-(2)'!D33:J33)=0,\"\",COUNT(D33:J33,'Form-11a-(2)'!D33:J33,'Form-11a-(3)'!D33:J33))","v":""},{"$f":"IF(K33=\"\",\"\",AVERAGE(D33:J33,'Form-11a-(2)'!D33:J33,'Form-11a-(3)'!D33:J33))","v":""},{"$f":"IF(K33=\"\",\"\",MAX(D33:J33,'Form-11a-(2)'!D33:J33,'Form-11a-(3)'!D33:J33))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNT(D34:J34,'Form-11a-(2)'!D34:J34)=0,\"\",COUNT(D34:J34,'Form-11a-(2)'!D34:J34,'Form-11a-(3)'!D34:J34))","v":""},{"$f":"IF(K34=\"\",\"\",AVERAGE(D34:J34,'Form-11a-(2)'!D34:J34,'Form-11a-(3)'!D34:J34))","v":""},{"$f":"IF(K34=\"\",\"\",MAX(D34:J34,'Form-11a-(2)'!D34:J34,'Form-11a-(3)'!D34:J34))","v":""},""]
[null,"NOTE:   Provide any laboratory analytical data sheets 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, boring logs, and monitoring well schematics."]

{"sheet":"Form-11a-(2)","index":25,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":true,"merged":[[7,1,7,13],[10,11,14,11],[10,12,14,12],[10,13,14,13],[33,1,33,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 11a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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 (All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)",null,null,null,null,null,null,null,null,"Number"]
[null,"Last Sampling Event",null,null,null,null,null,null,null,null,"Detects"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K17","v":""},{"$f":"'Form-11a-(1)'!L17","v":""},{"$f":"'Form-11a-(1)'!M17","v":""},{"$f":"'Form-11a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K18","v":""},{"$f":"'Form-11a-(1)'!L18","v":""},{"$f":"'Form-11a-(1)'!M18","v":""},{"$f":"'Form-11a-(1)'!N18","v":""},null,null,{"$f":"COUNTIF(D18:N18,\"fp\")","v":0},{"$f":"IF(Q18>0,ESOL1,IF(COUNT(D18:N18)=0,\"--\",MAX(D18:N18)))","v":"--"}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K19","v":""},{"$f":"'Form-11a-(1)'!L19","v":""},{"$f":"'Form-11a-(1)'!M19","v":""},{"$f":"'Form-11a-(1)'!N19","v":""}]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K20","v":""},{"$f":"'Form-11a-(1)'!L20","v":""},{"$f":"'Form-11a-(1)'!M20","v":""},{"$f":"'Form-11a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K21","v":""},{"$f":"'Form-11a-(1)'!L21","v":""},{"$f":"'Form-11a-(1)'!M21","v":""},{"$f":"'Form-11a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K22","v":""},{"$f":"'Form-11a-(1)'!L22","v":""},{"$f":"'Form-11a-(1)'!M22","v":""},{"$f":"'Form-11a-(1)'!N22","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBON ANALYSIS"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K24","v":""},{"$f":"'Form-11a-(1)'!L24","v":""},{"$f":"'Form-11a-(1)'!M24","v":""},{"$f":"'Form-11a-(1)'!N24","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K25","v":""},{"$f":"'Form-11a-(1)'!L25","v":""},{"$f":"'Form-11a-(1)'!M25","v":""},{"$f":"'Form-11a-(1)'!N25","v":""},null,null,{"$f":"COUNTIF(D24:N24,\"fp\")","v":0},{"$f":"IF(Q25>0,ESOL3,IF(COUNT(D24:N24)=0,\"--\",MAX(D24:N24)))","v":"--"}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K26","v":""},{"$f":"'Form-11a-(1)'!L26","v":""},{"$f":"'Form-11a-(1)'!M26","v":""},{"$f":"'Form-11a-(1)'!N26","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C27=\"\",\"\",'Form-11a-(1)'!C27)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K27","v":""},{"$f":"'Form-11a-(1)'!L27","v":""},{"$f":"'Form-11a-(1)'!M27","v":""},{"$f":"'Form-11a-(1)'!N27","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C28=\"\",\"\",'Form-11a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K28","v":""},{"$f":"'Form-11a-(1)'!L28","v":""},{"$f":"'Form-11a-(1)'!M28","v":""},{"$f":"'Form-11a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C29=\"\",\"\",'Form-11a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K29","v":""},{"$f":"'Form-11a-(1)'!L29","v":""},{"$f":"'Form-11a-(1)'!M29","v":""},{"$f":"'Form-11a-(1)'!N29","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-11a-(1)'!B31:C31=\"\",\"\",'Form-11a-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K31","v":""},{"$f":"'Form-11a-(1)'!L31","v":""},{"$f":"'Form-11a-(1)'!M31","v":""},{"$f":"'Form-11a-(1)'!N31","v":""},null,null,{"$f":"COUNTIF(D31:N31,\"fp\")","v":0},{"$f":"IF(Q31>0,ESOL4,IF(COUNT(D31:N31)=0,\"--\",MAX(D31:N31)))","v":"--"}]
[null,{"$f":"IF('Form-11a-(1)'!B32:C32=\"\",\"\",'Form-11a-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K32","v":""},{"$f":"'Form-11a-(1)'!L32","v":""},{"$f":"'Form-11a-(1)'!M32","v":""},{"$f":"'Form-11a-(1)'!N32","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B33:C33=\"\",\"\",'Form-11a-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K33","v":""},{"$f":"'Form-11a-(1)'!L33","v":""},{"$f":"'Form-11a-(1)'!M33","v":""},{"$f":"'Form-11a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B34:C34=\"\",\"\",'Form-11a-(1)'!B34:C34)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K34","v":""},{"$f":"'Form-11a-(1)'!L34","v":""},{"$f":"'Form-11a-(1)'!M34","v":""},{"$f":"'Form-11a-(1)'!N34","v":""}]
[null,"NOTE:   Provide any laboratory analytical data sheets 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, boring logs, and monitoring well schematics."]

{"sheet":"Form-11a-(3)","index":26,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":true,"merged":[[7,1,7,13],[10,11,14,11],[10,12,14,12],[10,13,14,13],[33,1,33,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[8,1,8,13]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 11a  "]
[]
[null,{"$f":"CONCATENATE(Cover!D21,\"  \",Cover!E21)","v":"FACILITY NAME:  "},null,null,null,{"$f":"CONCATENATE(Cover!D23,\"  \",Cover!E23)","v":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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 (All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Monitoring Well Number",null,null,null,null,null,null,null,null,null,"Arithmetic Average","Maximum","Ratio \n(Max. / Avg) *"]
[null,"Installation Date "]
[null,"Screen Interval (feet below datum)"]
[null,"Water Level (feet below datum)",null,null,null,null,null,null,null,null,"Number"]
[null,"Last Sampling Event",null,null,null,null,null,null,null,null,"Detects"]
[null,"VOLATILE ORGANIC CHEMICALS ANALYSES"]
[null,"Benzene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K17","v":""},{"$f":"'Form-11a-(1)'!L17","v":""},{"$f":"'Form-11a-(1)'!M17","v":""},{"$f":"'Form-11a-(1)'!N17","v":""}]
[null,"Toluene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K18","v":""},{"$f":"'Form-11a-(1)'!L18","v":""},{"$f":"'Form-11a-(1)'!M18","v":""},{"$f":"'Form-11a-(1)'!N18","v":""},null,null,{"$f":"COUNTIF(D18:N18,\"fp\")","v":0},{"$f":"IF(Q18>0,ESOL1,IF(COUNT(D18:N18)=0,\"--\",MAX(D18:N18)))","v":"--"}]
[null,"Ethylbenzene",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K19","v":""},{"$f":"'Form-11a-(1)'!L19","v":""},{"$f":"'Form-11a-(1)'!M19","v":""},{"$f":"'Form-11a-(1)'!N19","v":""}]
[null,"Xylenes (total)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K20","v":""},{"$f":"'Form-11a-(1)'!L20","v":""},{"$f":"'Form-11a-(1)'!M20","v":""},{"$f":"'Form-11a-(1)'!N20","v":""}]
[null,"n-Hexane",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K21","v":""},{"$f":"'Form-11a-(1)'!L21","v":""},{"$f":"'Form-11a-(1)'!M21","v":""},{"$f":"'Form-11a-(1)'!N21","v":""}]
[null,"Methyl-tert-butyl-ether (MTBE)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K22","v":""},{"$f":"'Form-11a-(1)'!L22","v":""},{"$f":"'Form-11a-(1)'!M22","v":""},{"$f":"'Form-11a-(1)'!N22","v":""}]
[null,"TOTAL EXTRACTABLE HYDROCARBON ANALYSIS"]
[null,"TEH (as diesel)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K24","v":""},{"$f":"'Form-11a-(1)'!L24","v":""},{"$f":"'Form-11a-(1)'!M24","v":""},{"$f":"'Form-11a-(1)'!N24","v":""}]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K25","v":""},{"$f":"'Form-11a-(1)'!L25","v":""},{"$f":"'Form-11a-(1)'!M25","v":""},{"$f":"'Form-11a-(1)'!N25","v":""},null,null,{"$f":"COUNTIF(D24:N24,\"fp\")","v":0},{"$f":"IF(Q25>0,ESOL3,IF(COUNT(D24:N24)=0,\"--\",MAX(D24:N24)))","v":"--"}]
[null,"TEH (as kerosene)",null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K26","v":""},{"$f":"'Form-11a-(1)'!L26","v":""},{"$f":"'Form-11a-(1)'!M26","v":""},{"$f":"'Form-11a-(1)'!N26","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C27=\"\",\"\",'Form-11a-(1)'!C27)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K27","v":""},{"$f":"'Form-11a-(1)'!L27","v":""},{"$f":"'Form-11a-(1)'!M27","v":""},{"$f":"'Form-11a-(1)'!N27","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C28=\"\",\"\",'Form-11a-(1)'!C28)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K28","v":""},{"$f":"'Form-11a-(1)'!L28","v":""},{"$f":"'Form-11a-(1)'!M28","v":""},{"$f":"'Form-11a-(1)'!N28","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C29=\"\",\"\",'Form-11a-(1)'!C29)","v":""},null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K29","v":""},{"$f":"'Form-11a-(1)'!L29","v":""},{"$f":"'Form-11a-(1)'!M29","v":""},{"$f":"'Form-11a-(1)'!N29","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-11a-(1)'!B31:C31=\"\",\"\",'Form-11a-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K31","v":""},{"$f":"'Form-11a-(1)'!L31","v":""},{"$f":"'Form-11a-(1)'!M31","v":""},{"$f":"'Form-11a-(1)'!N31","v":""},null,null,{"$f":"COUNTIF(D31:N31,\"fp\")","v":0},{"$f":"IF(Q31>0,ESOL4,IF(COUNT(D31:N31)=0,\"--\",MAX(D31:N31)))","v":"--"}]
[null,{"$f":"IF('Form-11a-(1)'!B32:C32=\"\",\"\",'Form-11a-(1)'!B32:C32)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K32","v":""},{"$f":"'Form-11a-(1)'!L32","v":""},{"$f":"'Form-11a-(1)'!M32","v":""},{"$f":"'Form-11a-(1)'!N32","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B33:C33=\"\",\"\",'Form-11a-(1)'!B33:C33)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K33","v":""},{"$f":"'Form-11a-(1)'!L33","v":""},{"$f":"'Form-11a-(1)'!M33","v":""},{"$f":"'Form-11a-(1)'!N33","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B34:C34=\"\",\"\",'Form-11a-(1)'!B34:C34)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Form-11a-(1)'!K34","v":""},{"$f":"'Form-11a-(1)'!L34","v":""},{"$f":"'Form-11a-(1)'!M34","v":""},{"$f":"'Form-11a-(1)'!N34","v":""}]
[null,"NOTE:   Provide any laboratory analytical data sheets 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, boring logs, and monitoring well schematics."]

{"sheet":"Form-11b-(1)","index":27,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[[9,1,9,8],[10,1,10,8],[36,1,37,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[34,1,34,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,"Tier 1 Investigation Form - 11b  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"ANALYTICAL DATA SUMMARY FOR QA/QC WATER SAMPLES (All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,"Field Blanks",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,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D19:I19,\"fp\")","v":0},{"$f":"IF(L19>0,ESOL1,IF(COUNT(D19:I19)=0,\"--\",MAX(D19:I19)))","v":"--"}]
[null,"Ethylbenzene"]
[null,"Xylenes (total)"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"TOTAL EXTRACTABLE HYDROCARBON ANALYSIS"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:I25,\"fp\")","v":0},{"$f":"IF(L26>0,ESOL3,IF(COUNT(D25:I25)=0,\"--\",MAX(D25:I25)))","v":"--"}]
[null,"TEH (as kerosene)"]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C27=\"\",\"\",'Form-11a-(1)'!C27)","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C28=\"\",\"\",'Form-11a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C29=\"\",\"\",'Form-11a-(1)'!C29)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-11a-(1)'!B31:C31=\"\",\"\",'Form-11a-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D32:I32,\"fp\")","v":0},{"$f":"IF(L32>0,ESOL4,IF(COUNT(D32:I32)=0,\"--\",MAX(D32:I32)))","v":"--"}]
[null,{"$f":"IF('Form-11a-(1)'!B32:C32=\"\",\"\",'Form-11a-(1)'!B32:C32)","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B33:C33=\"\",\"\",'Form-11a-(1)'!B33:C33)","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B34:C34=\"\",\"\",'Form-11a-(1)'!B34:C34)","v":""}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical data sheets not previously submitted to the Department. "]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-11b-(2)","index":28,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[[9,1,9,8],[10,1,10,8],[36,1,37,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[34,1,34,2],[31,1,31,2],[32,1,32,2],[33,1,33,2]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,"Tier 1 Investigation Form - 11b  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,"ANALYTICAL DATA SUMMARY FOR QA/QC WATER SAMPLES (All concentrations in mg/L)"]
[null,"NOT APPLICABLE FOR THIS SITE"]
[]
[null,"Type of QA/QC Water Sample",null,"Blind Duplicates",null,"Field Blanks",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,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D19:I19,\"fp\")","v":0},{"$f":"IF(L19>0,ESOL1,IF(COUNT(D19:I19)=0,\"--\",MAX(D19:I19)))","v":"--"}]
[null,"Ethylbenzene"]
[null,"Xylenes (total)"]
[null,"n-Hexane"]
[null,"Methyl-tert-butyl-ether (MTBE)"]
[null,"TOTAL EXTRACTABLE HYDROCARBON ANALYSIS"]
[null,"TEH (as diesel)"]
[null,"TEH (as waste oil)",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D25:I25,\"fp\")","v":0},{"$f":"IF(L26>0,ESOL3,IF(COUNT(D25:I25)=0,\"--\",MAX(D25:I25)))","v":"--"}]
[null,"TEH (as kerosene)"]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C27=\"\",\"\",'Form-11a-(1)'!C27)","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C28=\"\",\"\",'Form-11a-(1)'!C28)","v":""}]
[null,"TEH as",{"$f":"IF('Form-11a-(1)'!C29=\"\",\"\",'Form-11a-(1)'!C29)","v":""}]
[null,"OTHER ANALYTES"]
[null,{"$f":"IF('Form-11a-(1)'!B31:C31=\"\",\"\",'Form-11a-(1)'!B31:C31)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(D32:I32,\"fp\")","v":0},{"$f":"IF(L32>0,ESOL4,IF(COUNT(D32:I32)=0,\"--\",MAX(D32:I32)))","v":"--"}]
[null,{"$f":"IF('Form-11a-(1)'!B32:C32=\"\",\"\",'Form-11a-(1)'!B32:C32)","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B33:C33=\"\",\"\",'Form-11a-(1)'!B33:C33)","v":""}]
[null,{"$f":"IF('Form-11a-(1)'!B34:C34=\"\",\"\",'Form-11a-(1)'!B34:C34)","v":""}]
[]
[null,"TEMPERATURE BLANKS",null,"Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp (oC)","Cooler ID","Pre-Delivery Temp. (oC)","Laboratory Temp (oC)"]
[]
[]
[null,"NOTE:   Provide any laboratory analytical data sheets not previously submitted to the Department. "]
[null,"Recommended Attachment:  Laboratory analysis report(s) and chain of custody."]

{"sheet":"Form-12","index":29,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":true,"merged":[[11,2,11,4],[12,2,12,4],[22,1,22,12],[18,2,18,4],[11,9,11,11],[14,9,14,11],[15,5,15,11],[16,5,16,11],[13,9,13,11],[35,2,35,11],[31,6,31,11],[32,6,32,11],[28,6,28,11],[29,6,29,11],[30,6,30,11],[23,2,23,11],[14,2,14,4],[27,6,27,11],[18,5,18,11],[20,5,20,8],[17,5,17,11]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,null,null,null,null,null,null,null,"Tier 1 Investigation Form - 12  "]
[]
[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":"PROGRAM NO.:  "},null,null,null,null,null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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,{"$f":"CONCATENATE(Cover!D28,\"  \",Cover!E28)","v":"PREPARED BY:  "}]
[]
[null,"FREE PRODUCT"]
[]
[null,null,"Is free product present at the site?",null,null,"YES",null,"NO"]
[null,null,"(Note if NO, proceed to the next report form)"]
[null,null,"Has free product been found in any utility?",null,null,"YES",null,"NO"]
[null,null,"Has the free product plume been delineated?",null,null,"YES",null,"NO"]
[null,null,"Shallowest depth to free product:"]
[null,null,"Type of free product released:"]
[null,null,"Number of monitoring wells currently at the site:"]
[null,null,"List the monitoring wells containing free product:"]
[null,null,"Specify the well ID and  maximum free product thickness:"]
[null,null,null,null,null,null,null,null,null,"feet","Date:"]
[]
[null,"VAPOR ASSESSMENT"]
[null,null,"Place vapor assessment information in Tier 1 Investigation Form - 6."]
[]
[null,"REMEDIATION"]
[null,null,"Has free product removal been initiated?",null,null,null,null,"YES",null,"NO"]
[null,null,"If YES, specify method of removal (bailer, pump, etc.)?"]
[null,null,"Frequency of removal (continuously, weekly, etc.):"]
[null,null,"Total number of recovery events to date:"]
[null,null,"Total amount of purge-water recovered:"]
[null,null,"Total amount of free product recovered:"]
[null,null,"Date of latest free product report submittal:"]
[]
[null,"ADDITIONAL NOTES"]
[]
[]
[null,"Recommended attachments:  Free product thickness maps as appropriate.  Place narrative detailing free product effort in Form - 7."]

{"sheet":"Form-13 (1)","index":30,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[[23,1,24,1],[23,2,24,5],[19,1,20,1],[19,2,20,5],[21,1,22,1],[21,2,22,5],[15,1,16,1],[15,2,16,5],[17,1,18,1],[17,2,18,5],[9,1,9,5],[11,1,12,1],[11,2,12,5],[13,1,14,1],[13,2,14,5]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,"Tier 1 Investigation Form - 13  "]
[]
[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":"PROGRAM NO.:  "},null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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-13 (2)","index":31,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[[9,1,9,5],[11,1,12,1],[11,2,12,5],[13,1,14,1],[13,2,14,5],[15,1,16,1],[15,2,16,5],[17,1,18,1],[17,2,18,5],[23,1,24,1],[23,2,24,5],[19,1,20,1],[19,2,20,5],[21,1,22,1],[21,2,22,5]]}
[]
[null,"DWEE RBCA TIER 1 REPORT",null,null,null,"Tier 1 Investigation Form - 13  "]
[]
[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":"PROGRAM NO.:  "},null,{"$f":"CONCATENATE(Cover!D24,\"  \",Cover!E24)","v":"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":"Print","index":32,"n_rows":19,"n_cols":27,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]