{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":69,"n_cols":8,"rows_kept":69,"merged":[[2,6,2,8]]}
["Parameter","Method","Sample Type:          SW = Surface Water           GW = Ground Water","Approx # Samples/Event Including/Trip Blanks or QC","Approx # Equipment Blanks/Year","Approx # Samples/Year","Unit Cost Aqueous or *Non-Aqueous","Total Cost "]
[]
["Sub-contract Parameters",{"$nulls":5},"Fill in column G with unit prices"]
["Organics",{"$nulls":5},"↓"]
["Appendix I List Volatiles","8260B/624","SW",9,null,{"$f":"SUM(D5*12)+E5","v":108},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F5,G5)","v":{"v":0,"d":"$0.00"}}]
["EDB/DBCP (separated for lower MDLs)",8011,"SW",9,null,{"$f":"SUM(D6*12)+E6","v":108},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F6,G6)","v":{"v":0,"d":"$0.00"}}]
["601/602 List Volatiles","8260B/624","GW",3,4,{"$f":"SUM(D7*12)+E7","v":40},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F7,G7)","v":{"v":0,"d":"$0.00"}}]
["Xylenes","8260B/624","GW",3,4,{"$f":"SUM(D8*12)+E8","v":40},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F8,G8)","v":{"v":0,"d":"$0.00"}}]
[]
["General Chemistry"]
["Nitrogen, Unionized Ammonia ","350.1/SM 4500 NH3 H + Calc","SW",8,null,{"$f":"SUM(D11*12)+E11","v":96},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F11,G11)","v":{"v":0,"d":"$0.00"}}]
["Nitrogen, Ammonia ","350.1/SM 4500 NH3-H","GW",2,4,{"$f":"SUM(D12*12)+E12","v":28},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Carbonaceous (BOD5) ","405.1/SM 5210B","SW",8,null,{"$f":"SUM(D13*12)+E13","v":96},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Chemical Oxygen Demand (COD)","410.1/410.4/5220D","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Total Organic Carbon (TOC)","415.1/9060/SM 5310B","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Chlorides","300.0/325.1/325,2/9250/SM 4500 Cl-E","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Hydrogen Sulfide (as Sulfide)","376.1/SM 4500 S2-E","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Sulfides","376.1/SM 4500 S2-E","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Sulfate","300.0/375.4/9038","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Mercury","7470A/7471/254.1","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Low Level Mercury","1631E","SW",10,null,120,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Standard PDF Deliverables","PDF","SW & GW",2,null,24,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["WIN/ADaPT CSV (format only)","EDD WIN/ADaPT Format (see example)","SW & GW",2,null,24,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[null,"OR a 1 time fee to set up CSV format","SW & GW",1,null,1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
[{"$nulls":5},"Total Cost:",{"$f":"SUM(G5:G8,G11:G24)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(H5:H8,H11:H24)","v":{"v":0,"d":"$0.00"}}]
[]
["Backup Parameters"]
["Micro/General Chemistry"]
["Total coliforms/E. coli","SM 9223 B","SW",1,null,1,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F30,G30)","v":{"v":0,"d":"$0.00"}}]
["Enterococcus","SM 9230 D/ASTM D6503-99","SW",1,null,1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Total Suspended Solids (TSS)","160.2/SM 2540D","SW",8,null,{"$f":"SUM(D32*12)+E32","v":96},{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F32,G32)","v":{"v":0,"d":"$0.00"}}]
["Total Dissolved Solids (TDS)","160.1/SM 2540C","SW",8,null,96,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F33,G33)","v":{"v":0,"d":"$0.00"}}]
["Total Dissolved Solids (TDS)","160.1/SM 2540C","GW",2,4,16,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F34,G34)","v":{"v":0,"d":"$0.00"}}]
["Total Solids (TS)","160.3/SM 2540B","SW",1,null,1,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F35,G35)","v":{"v":0,"d":"$0.00"}}]
["Volatile Solids","160.4/SM 2540E","SW",1,null,1,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F36,G36)","v":{"v":0,"d":"$0.00"}}]
["Mineral (Fixed) Solids","Calculation","SW",1,null,1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Color","110.2/SM 2120B","SW",1,null,1,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F38,G38)","v":{"v":0,"d":"$0.00"}}]
["Ortho Phosphorus","300.0/365.1/365.2/365.3/365.4/SM 4500-P F","SW",1,null,1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Total Phosphorus","300.0/365.1/365.2/365.3/SM 4500-P F","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrate +Nitrite (NOx)","300.0/353.2/SM 4500 NO3-F","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrite","300.0/353.2/SM 4500 NO3-F","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrate (reported)","Calculation","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Total Kjeldahl ",351.2,"SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Total (reported)","Calculation","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrate +Nitrite (NOx)","300.0/353.2/SM 4500 NO3-F","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrite","300.0/353.2/SM 4500 NO3-F","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Nitrogen, Nitrate (reported)","Calculation","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
[]
["Metals (including Prep fee)"]
["Appendix I Metals (15 metals/sample)","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"$f":"PRODUCT(F51,G51)","v":{"v":0,"d":"$0.00"}}]
["Iron","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Aluminum","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Boron","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Calcium","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Magnesium","6010/6020A, 200.7/200.8","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Total Hardness (as mg/L CaCO3)","Calculation","SW",8,null,96,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Arsenic","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Aluminum","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Boron","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Cadmium","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Chromium","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Iron","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Lead","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Sodium","6010/6020A, 200.7/200.8","GW",2,4,28,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"}]
["Solid Matrix (% surcharge)","Solid Matrix","Solid",1,null,1,{"v":0,"d":"0.00%"}]
["Expedited TAT (% surcharge)","7 calendar days","SW & GW",1,null,1,{"v":0,"d":"0.00%"}]
[null,"3 calendar days","SW & GW",1,null,1,{"v":0,"d":"0.00%"}]
[null,"1 calendar day","SW & GW",1,null,1,{"v":0,"d":"0.00%"}]