{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary Sheet","Grain Size Data Entry","Look-up Tables","Parameter Definition & Calculat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary Sheet","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,3,10,6],[5,3,5,7],[8,3,8,4],[9,3,9,4],[8,7,8,8],[9,7,9,8],[28,2,28,3],[25,2,25,3],[23,2,23,3],[24,2,24,3],[13,2,13,3],[14,2,14,3],[16,2,16,3],[19,2,19,3],[20,2,21,3]]}
[]
[]
[null,null,null,"New Jersey Department of Environmental Protection"]
[null,null,null,"Site Remediation and Waste Management Program"]
[]
[null,null,null,"Extractable Petroleum Hydrocarbon (EPH) Alternative Product Limit Concentration Calculator for Soil"]
[null,null,null,"Version 1.1, December 2019 Release Date"]
[]
[null,null,"Site Name:",null,null,"Program Interest (PI) Num."]
[null,null,"Area of Concern Name",null,null,"AOC No. (must correspond with CID)"]
[null,null,"Investigator's Name"]
[]
[null,null,"Type of Petroleum Product",null,null,"Default Product Indicator Concentration",{"$f":"'Look-up Tables'!$L$3","v":{"$error":"#N/A"}},"mg/kg EPH"]
[null,"μo","Dynamic Viscosity of the Petroleum Product (poise)",null,{"$f":"'Look-up Tables'!$I$3","v":{"$error":"#N/A"}},"poise"]
[null,"ρo","Density of the Petroleum Product  (gram/cm^3)",null,{"$f":"'Look-up Tables'!$J$3","v":{"$error":"#N/A"}},"gram/cm^3"]
[]
[null,null,"Select the number of Grain Size Samples that were \nanalyzed for this AOC.  \nClick the quantity of grain size samples: 3 samples or 4 samples.",null,8]
[null,null,1]
[null,null,null,null,"Sample 1","Sample 2","Sample 3","Sample 4"]
[null,null,"Sample Identification Name/Number"]
[null,null,"For each sample, click the bullet corresponding to source of D10 value."]
[]
[]
[null,"D10","Grain Size with 10% of Soil Passing through the Sieve (mm)",null,{"$f":"'Grain Size Data Entry'!$F$7","v":0},{"$f":"'Grain Size Data Entry'!L7","v":0},{"$f":"'Grain Size Data Entry'!Q7","v":0},{"$f":"'Grain Size Data Entry'!V7","v":0}]
[null,"k","Intrinsic Permeability (m2) -calculated based on D10",null,{"$f":"'Parameter Definition & Calculat'!$E$112","v":1.0999553129688145E-11},{"$f":"'Parameter Definition & Calculat'!$I$112","v":1.0999553129688145E-11},{"$f":"'Parameter Definition & Calculat'!$M$112","v":1.0999553129688145E-11},{"$f":"'Parameter Definition & Calculat'!$Q$112","v":1.0999553129688145E-11}]
[]
[null,null,"Calculated EPH Product Limit Concentration for each grain size sample.","    mg/kg of EPH",{"$f":"'Parameter Definition & Calculat'!$D$90","v":{"$error":"#N/A"}},{"$f":"'Parameter Definition & Calculat'!$H$90","v":{"$error":"#N/A"}},{"$f":"'Parameter Definition & Calculat'!$L$90","v":{"$error":"#N/A"}},{"$f":"'Parameter Definition & Calculat'!$P$90","v":{"$error":"#N/A"}}]
[null,null,"Maximum Allowable EPH Concentration in Soil (i.e., NJDEP Ceiling Limit)","    mg/kg of EPH",{"$f":"'Look-up Tables'!$K$3","v":{"$error":"#N/A"}},{"$f":"'Look-up Tables'!$K$3","v":{"$error":"#N/A"}},{"$f":"'Look-up Tables'!$K$3","v":{"$error":"#N/A"}},{"$f":"'Look-up Tables'!$K$3","v":{"$error":"#N/A"}}]
[null,null,"EPH Alternative Product Limit Concentration for Soil in this AOC",null,{"$f":"IF(H29>'Look-up Tables'!$K$3,'Look-up Tables'!$K$3,H29)","v":{"$error":"#N/A"}},"mg/kg EPH",null,{"$f":"IF($C$18=2,(MEDIAN($E$27,$F$27,$G$27,$H$27)),(MEDIAN($E$27,$F$27,$G$27)))","v":{"$error":"#N/A"}}]

{"sheet":"Grain Size Data Entry","index":1,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[7,2,7,6],[7,8,7,11],[7,13,7,16],[7,18,7,21],[29,1,29,21]]}
[]
[null,null,null,"New Jersey Department of Environmental Protection"]
[null,null,null,"Site Remediation and Waste Management Program"]
[]
[null,null,null,"Extractable Petroleum Hydrocarbon (EPH) Alternative Product Limit Concentration Calculator for Soil"]
[null,null,null,"Version 1.1, December 2019 Release Date"]
[null,1,null,null,null,{"$f":"IF(B7=1,E10,E28)","v":0},null,null,1,null,null,{"$f":"IF(I7=1,K10,K28)","v":0},null,1,null,null,{"$f":"IF(N7=1,P10,P28)","v":0},null,1,null,null,{"$f":"IF(S7=1,U10,U28)","v":0}]
[null,null,"Sample 1",null,null,null,null,null,"Sample 2",null,null,null,null,"Sample 3",null,null,null,null,"Sample 4"]
[null,null,null,"Lab Sample Name",{"$f":"'Summary Sheet'!$E$20","v":0},null,null,null,null,"Lab Sample Name",{"$f":"'Summary Sheet'!$F$20","v":0},null,null,null,"Lab Sample Name",{"$f":"'Summary Sheet'!$G$20","v":0},null,null,null,"Lab Sample Name",{"$f":"'Summary Sheet'!$H$20","v":0}]
[null,null,null,"Lab D10=",null,"mm",null,null,null,"Lab D10=",null,"mm",null,null,"Lab D10=",null,"mm",null,null,"Lab D10=",null,"mm"]
[null,null,null,null,"Grain Size from Sieve (mm of Sieve)","Percent of soil mass passing through the sieve","Percent of material mass retained on the sieve",null,null,"Grain Size from Sieve (mm of Sieve)","Percent of soil mass passing through the sieve","Percent of material mass retained on the sieve",null,null,"Grain Size from Sieve (mm of Sieve)","Percent of soil mass passing through the sieve","Percent of material mass retained on the sieve",null,null,"Grain Size from Sieve (mm of Sieve)","Percent of soil mass passing through the sieve","Percent of material mass retained on the sieve"]
[]
[null,null,null,null,null,null,{"$f":"1-F13","v":1},null,null,null,null,{"$f":"1-K13","v":1},null,null,null,null,{"$f":"1-P13","v":1},null,null,null,null,{"$f":"1-U13","v":1}]
[null,null,null,null,null,null,1,null,null,null,null,{"$f":"1-K14","v":1},null,null,null,null,{"$f":"1-P14","v":1},null,null,null,null,{"$f":"1-U14","v":1}]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,null,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,null,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,4.75,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,2.36,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,2,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,1.18,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,0.6,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,0.3,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,0.15,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,7.4999999999999997E-2,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,0.03,null,{"$f":"1-P25","v":1},null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,5.0000000000000001E-3,null,1,null,null,null,null,1]
[null,null,null,null,null,null,1,null,null,null,null,1,null,null,1.5E-3,null,1,null,null,null,null,1]
[null,null,null," Calc. D10=",{"$f":"+MAX(F32:F46)","v":1.5E-3},"mm",null,null,null," Calc. D10=",{"$f":"+MAX(K32:K46)","v":1.5E-3},"mm",null,null," Calc. D10=",{"$f":"+MAX(P32:P46)","v":1.5E-3},"mm",null,null," Calc. D10=",{"$f":"+MAX(U32:U46)","v":1.5E-3},"mm"]
[]
[null,"Data Points to be Hidden After Spreadsheet review Calculation of D10 from the Grain Size Data - "]
[null,null,null,null,{"$f":"E11","v":"Grain Size from Sieve (mm of Sieve)"},"D10 is the greatest of the values listed below",null,null,null,{"$f":"J11","v":"Grain Size from Sieve (mm of Sieve)"},"D10 is the greatest of the values listed below",null,null,null,{"$f":"O11","v":"Grain Size from Sieve (mm of Sieve)"},"D10 is the greatest of the values listed below",null,null,null,{"$f":"T11","v":"Grain Size from Sieve (mm of Sieve)"},"D10 is the greatest of the values listed below"]
[null,null,null,null,{"$f":"+IF(AND(F13>=10%,F14<=10%),E13,IF(AND(F13<=10%,F12>=10%),E13,0))","v":0},{"$f":"+IF(E32*E33>0,E13-(F13-10%)/(F13-F14)*(E13-E14),0)","v":0},null,null,null,{"$f":"+IF(AND(K13>=10%,K14<=10%),J13,IF(AND(K13<=10%,K12>=10%),J13,0))","v":0},{"$f":"+IF(J32*J33>0,J13-(K13-10%)/(K13-K14)*(J13-J14),0)","v":0},null,null,null,{"$f":"+IF(AND(P13>=10%,P14<=10%),O13,IF(AND(P13<=10%,P12>=10%),O13,0))","v":0},{"$f":"+IF(O32*O33>0,O13-(P13-10%)/(P13-P14)*(O13-O14),0)","v":0},null,null,null,{"$f":"+IF(AND(U13>10%,U14<10%),T13,IF(AND(U13<10%,U12>10%),T13,0))","v":0},{"$f":"+IF(T32*T33>0,T13-(U13-10%)/(U13-U14)*(T13-T14),0)","v":0}]
[null,null,null,null,{"$f":"+IF(AND(F14>=10%,F15<=10%),E14,IF(AND(F14<=10%,F13>=10%),E14,0))","v":0},0,null,null,null,{"$f":"+IF(AND(K14>=10%,K15<=10%),J14,IF(AND(K14<=10%,K13>=10%),J14,0))","v":0},{"$f":"+IF(J33*J34>0,J14-(K14-10%)/(K14-K15)*(J14-J15),0)","v":0},null,null,null,{"$f":"+IF(AND(P14>=10%,P15<=10%),O14,IF(AND(P14<=10%,P13>=10%),O14,0))","v":0},{"$f":"+IF(O33*O34>0,O14-(P14-10%)/(P14-P15)*(O14-O15),0)","v":0},null,null,null,0,{"$f":"+IF(T33*T34>0,T14-(U14-10%)/(U14-U15)*(T14-T15),0)","v":0}]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,{"$f":"+IF(O34*O35>0,O15-(P15-10%)/(P15-P16)*(O15-O16),0)","v":0},null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,{"$f":"+IF(E41*E42>0,E22-(F22-10%)/(F22-F23)*(E22-E23),0)","v":0},null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0,null,null,null,0,0]
[null,null,null,null,0,{"$f":"IF(SUM(F32:F45)>0,0,0.0015)","v":1.5E-3},null,null,null,{"$f":"+IF(AND(K27>10%,K31<10%),J27,IF(AND(K27<10%,K26>10%),J27,0))","v":0},{"$f":"IF(SUM(K32:K45)>0,0,0.0015)","v":1.5E-3},null,null,null,{"$f":"+IF(AND(P27>10%,P31<10%),O27,IF(AND(P27<10%,P26>10%),O27,0))","v":0},{"$f":"IF(SUM(P32:P45)>0,0,0.0015)","v":1.5E-3},null,null,null,{"$f":"+IF(AND(U27>10%,U31<10%),T27,IF(AND(U27<10%,U26>10%),T27,0))","v":0},{"$f":"IF(SUM(U32:U45)>0,0,0.0015)","v":1.5E-3}]

{"sheet":"Look-up Tables","index":2,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["7:26E Table 2-1","Type of Petroleum Product Source Material","EPH Category","Viscosity (poise)","Oil Density (gm/cm^3)",null,"Type of LNAPL Source Material","EPH Category","Viscosity (poise)","Oil Density (gram/ cm^3)","Selected Ceiling Value","Default Product Indicator Concentration (mg/kg)"]
["No. 2 Heating Oil","No. 2 Heating Oil","Category 1",0.02,0.82450000000000001,null,{"$f":"'Summary Sheet'!$D$13","v":0},{"$f":"VLOOKUP(G3,B3:C16,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G3,B3:D16,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G3,B3:E16,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H3,B19:C21,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(H3,B19:D21,3,FALSE)","v":{"$error":"#N/A"}}]
["Diesel Fuel","Diesel Fuel","Category 1",0.02,0.82450000000000001]
["No. 4 Heating Oil","No. 4 Heating Oil","Category 2",0.23,0.92500000000000004]
["No. 6 Heating Oil","No. 6 Heating Oil","Category 2",403.4,0.9879]
["Hydraulic Oil","Hydraulic Oil","Category 2",1.02,0.87270000000000003]
["Cutting Oil","Cutting Oil","Eqivalent Category 1",0.02,0.82450000000000001]
["Lubricating Oil","Lubricating Oil","Category 2",1.4217,0.8498]
["Waste Oil","Waste Oil- Known Source Material","See Instruction","Use Source Material","Use Source Material"]
["Unknown Petroleum Hydrocarbons","Unknown Petroleum Hydrocarbon","Eqivalent Category 1",0.02,0.82450000000000001]
["Waste Vehicular Crankcase Oil","Waste Vehicular Crankcase Oil","Category 2",1.75,0.88480000000000003]
["Mineral Oil","Mineral Oil","Category 2",0.19,0.86729999999999996]
["Dielectric Fluid, Dielectric Mineral Oil, Transformer Oil","Dielectric Fluid, Dielectric Mineral Oil, Transformer Oil","Category 2",0.19,0.86729999999999996]
[null,"Crude Oil","Contact DEP","Contact DEP","Not App."]
[null,"Manufactured Gas Plant (MGP)","Contact DEP","Contact DEP","Not App."]
[]
[null,"Ceiling Values",null,"Default Product Indicator Concentration (mg/kg)"]
[null,"Category 1",30000,8000]
[null,"Category 2",30000,17000]
[null,"Eqivalent Category 1",30000,8000]
[]
[null,null,null,null,null,"Minutes/ day"]
["  Velocity Conversion of Units Calculations - Meters/second to Feet/Year",null,null,null,"days/year",1440,"Seconds / Minute"]
[null,1E-10,"m/s",null,365,null,60,{"$f":"B25*E25*F24*F24","v":7.5686400000000001E-2},"m/year"]
[null,3.35,"ft/m"]
[null,{"$f":"B25*B26","v":3.3500000000000003E-10},"ft/s"]
[null,60,"s/min"]
[null,1440,"min/day"]
[null,365,"day/yr"]
[null,{"$f":"B27*B28*B29*B30","v":1.0564560000000001E-2},"ft/yr"]
[null,{"$f":"B31*100","v":1.0564560000000001},"Ft/100 years"]

{"sheet":"Parameter Definition & Calculat","index":3,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":true,"merged":[[1,0,1,2],[94,3,94,5],[94,7,94,9],[94,11,94,13],[66,3,66,5],[66,7,66,9],[66,11,66,13],[66,15,66,17],[23,0,23,2],[62,0,62,2],[95,2,96,2],[92,0,92,2],[94,15,94,17],[95,3,95,5],[95,7,95,9],[95,11,95,13],[95,15,95,17]]}
[]
["Input Parameters"]
[null,"Mathematic Symbol","Physical Parameter / Physical Variable","Standard Unit of Measure","Alternate Unit of Measure","Low ","Probable","High"]
[null,"C","Concentration of oil per dry soil (Alternative EPH Free Product Limit concentration per dry soil)","mg/kg"]
[null,"Mo","Mass of petroleum hydrocarbon","mg"]
[null,"Ms","Mass of dry soil","kg"]
[null,"ϴo","Ratio of Petroleum Hydrocarbon Volume per sample volume at Residual Saturation","Dimensionless"]
[null,"ρo","Petroleum hydrocarbon liquid density","g/cm3",null,null,0.84,null,"Petroleum Product Specific Parameter"]
[null,"ρs","Grain density","g/cm3",null,null,2.54,null,"Soil Specific"]
[null,"ρb","Bulk soil density","g/cm3",null,null,1.5,null,"Soil Specific"]
[null,"Ø","Soil Porosity","Dimensionless",null,0.41,0.41,0.41,"Soil Specific"]
[null,"S","Petroleum Product (NAPL) Saturation ratio","Dimensionless",null,null,null,null,"Calculated-Soil specific value"]
[null,"Sr","Residual Saturation of oil - Percent of effective porosity","Dimensionless",null,0.02,0.02,0.02,"Selected by Committee"]
[null,"Se","Effective petroleum hydrocarbon saturation ratio ","Dimensionless",null,null,null,null,"Calculated-Soil specific value"]
[null,"kr","Relative permeability to petroleum hydrocarbon","Dimensionless"]
[null,"q","Darcy Flux (lowest value where NAPL is considered mobile)","m/s",null,null,9.6649999999999997E-11,null,"Selected by the NJDEP.  Equivalent to 1 foot in 100 years"]
[null,"K","Hydraulic conductivity","m/s",null,null,{"$f":"G16*G18","v":9.6649999999999997E-11},null,"Calculated based on q and i",null,null,"cm/s =",{"$f":"G17*100","v":9.6649999999999992E-9}]
[null,"i","Assumed Hydraulic Gradient","m/m",null,null,1]
[null,"g","Gravitational acceleration","m/s2",null,9.81,9.81,9.81,"constant"]
[null,"k","Intrinsic permeability","m2",null,null,1.0999550000000001E-9,null,"Default value is set by the DEP.  The calculated value is from the site specific soil D10"]
[null,"μ","Dynamic viscosity of fluid @ 15°C","Poise",null,0.02,0.02,1.75,"Petroleum product type"]
[null,"D10","Grain size diameter where 10% soil passes","mm",null,null,null,null,"Calculated from laboratory grain size distribution"]
[]
["DERIVATION OF THE EQUATION"]
[null,"C","= Mo / Ms","= (ϴo * ρo) / ((1- Ø) * ρs)",null,null,null,"=(Site Variable * Oil Constant ) / (Soil Constant * Soil Constant)"]
[]
[null,"ϴo","= Equivalent to NAPL Saturation * Porosity"," = S * Ø"]
[]
[null,"C"," = (ϴo * ρo) / ((1- Ø) * ρs)","= ( S * Ø * ρo) / ((1- Ø) * ρs)",null,null,null,"=(Site Variable* Soil Constant * Oil Constant ) / (Soil Constant * Soil Constant)"]
[]
[null,"S","= Eqivalent to residual hydrocarbon saturation and Effective Petroleum Saturation","= ((1-Sr)*Se) + Sr"]
[]
[null,"C","= ( S * Ø * ρo) / ((1- Ø) * ρs)","= ( ((1-Sr)*Se) + Sr)* Ø * ρo) / ((1- Ø) * ρs)",null,null,null,"=Oil Constant * * Soil Constant * Oil Constant ) / (Soil Constant * Soil Constant)"]
[]
[null,"Se","Effective petroleum hydrocarbon saturation ratio ","= 1.1349 * kr^0.3095"]
[]
[null,"C","= ( ((1-Sr)*Se) + Sr)* Ø * ρo) / ((1- Ø) * ρs)","= ( ((1-Sr)*( 1.1349 * kr^0.3095)) + Sr)* Ø * ρo) / ((1- Ø) * ρs)"]
[]
[null,"kr","Relative soil permeability to petroleum oil.   It is the ratio of effective permeability to the intrinsic permeability of the soil.","= (K * μ) / (k * ρo * g)"]
[]
[null,"Se","Effective petroleum hydrocarbon saturation ratio ","= 1.1349 * ( (K * μ) / (k * ρo * g)  )^0.3095"]
[]
[null,"C","= ( ((1-Sr)*( 1.1349 * kr0.3095)) + Sr)* Ø * ρo) / ((1- Ø) * ρs)","= ( ((1-Sr)*( 1.1349 * (((K * μ) / (k * ρo * g))^0.3095))) + Sr)* Ø * ρo) / ((1- Ø) * ρs)"]
[]
[null,null,"= (1-Sr)",{"$f":"1-$G$13","v":0.98},"Dimensionless"]
[null,null,"= 1.1349",1.1349,"constant"]
[null,null,"= (1-Sr)*1.1348",{"$f":"$D$45*$D$46","v":1.1122019999999999},"Dimensionless"]
[null,null,"=(K * μ)",{"$f":"$G$17*$G$21","v":1.9329999999999999E-12},"m * g/cm-s2"]
[null,null,"=(k * ρo * g)",{"$f":"G20*$G$8*$G$19","v":9.0640691820000005E-9},"100 g2 * s2 /cm2"]
[null,null,"=Conversion cm2/ m2",1,"cm2/m2"]
[null,"kr","=(K * μ) / (k * ρo * g)",{"$f":"D48/(D49*D50)","v":2.1325962558170597E-4},"Dimensionless"]
[null,null,"=((K * μ) / (k * ρo * g))^0.3095",{"$f":"D51^0.3095","v":7.3079778912849905E-2}]
[null,"Se","= 1.1349* [((K * μ) / (k * ρo * g))0.3095]",{"$f":"D52*1.1349","v":8.2938241088193365E-2},"Dimensionless"]
[null,"S","= ((1-Sr)*Se) + Sr",{"$f":"(D45*D53)+G13","v":0.1012794762664295},"Dimensionless"]
[null,"ϴo"," = S * Ø",{"$f":"D54*$G$11","v":4.1524585269236094E-2},"Dimensionless"]
[null,"Mo","= (ϴo * ρo)",{"$f":"D55*$G$8","v":3.4880651626158318E-2},"mg"]
[]
[null,"Ms","= ((1- Ø) * ρs)",{"$f":"(1-$G$11)*$G$9","v":1.4986000000000002},"g/cm3"]
[null,"Ms","Units Conversion",{"$f":"D58/1000","v":1.4986000000000001E-3},"kg/cm3"]
[]
[null,"Coil","= Mo / Ms",{"$f":"(D56/D58)*1000000","v":23275.491542878895},"mg/kg"]
[]
["Calculation of EPH Indicator for 4 Samples"]
[]
[null,"C =","= ( ((1-Sr)*( 1.1349 * kr0.3095)) + Sr)* Ø * ρo) / ((1- Ø) * ρs)","= ( ((1-Sr)*( 1.1349 * (((K * μ) / (k * ρo * g))^0.3095))) + Sr)* Ø * ρo) / ((1- Ø) * ρs)"]
[]
[null,null,null,"Sample #1",null,null,null,"Sample #2",null,null,null,"Sample #3",null,null,null,"Sample #4"]
[null," μ",{"$f":"'Summary Sheet'!$C$14","v":"Dynamic Viscosity of the Petroleum Product (poise)"},{"$f":"'Summary Sheet'!$E$14","v":{"$error":"#N/A"}},"poise","kg/ (m sec)",null,{"$f":"'Summary Sheet'!$E$14","v":{"$error":"#N/A"}},"poise",null,null,{"$f":"'Summary Sheet'!$E$14","v":{"$error":"#N/A"}},"poise",null,null,{"$f":"'Summary Sheet'!$E$14","v":{"$error":"#N/A"}},"poise"]
[null,"ρo",{"$f":"'Summary Sheet'!$C$15","v":"Density of the Petroleum Product  (gram/cm^3)"},{"$f":"'Summary Sheet'!$E$15*1000","v":{"$error":"#N/A"}},"kg/m^3",null,null,{"$f":"'Summary Sheet'!$E$15*1000","v":{"$error":"#N/A"}},{"$f":"'Summary Sheet'!D15","v":0},null,null,{"$f":"'Summary Sheet'!$E$15*1000","v":{"$error":"#N/A"}},{"$f":"'Summary Sheet'!D15","v":0},null,null,{"$f":"'Summary Sheet'!$E$15*1000","v":{"$error":"#N/A"}},{"$f":"'Summary Sheet'!D15","v":0}]
[null,"D10",{"$f":"'Summary Sheet'!$C$24","v":"Grain Size with 10% of Soil Passing through the Sieve (mm)"},{"$f":"'Grain Size Data Entry'!$F$7","v":0},"mm",null,null,{"$f":"'Grain Size Data Entry'!L7","v":0},"mm",null,null,{"$f":"'Grain Size Data Entry'!Q7","v":0},"mm",null,null,{"$f":"'Grain Size Data Entry'!V7","v":0},"mm"]
[null,"K","Hydraulic Conductivity based on 0.01 feet/year mobility",{"$f":"G17","v":9.6649999999999997E-11},"m/second",null,null,{"$f":"G17","v":9.6649999999999997E-11},"m/second",null,null,{"$f":"G17","v":9.6649999999999997E-11},"m/second",null,null,{"$f":"G17","v":9.6649999999999997E-11},"m/second"]
[null,"k",{"$f":"'Summary Sheet'!$C$25","v":"Intrinsic Permeability (m2) -calculated based on D10"},{"$f":"'Summary Sheet'!$E$25","v":1.0999553129688145E-11},"m^2",null,null,{"$f":"'Summary Sheet'!$F$25","v":1.0999553129688145E-11},"calculated m^2",null,null,{"$f":"'Summary Sheet'!$G$25","v":1.0999553129688145E-11},"calculated m^2",null,null,{"$f":"'Summary Sheet'!$H$25","v":1.0999553129688145E-11},"calculated m^2"]
[null,"ρs",{"$f":"'Summary Sheet'!$C$14","v":"Dynamic Viscosity of the Petroleum Product (poise)"},{"$f":"$G$9*1000","v":2540},"kg/m^3",null,null,{"$f":"$G$9*1000","v":2540},"kg/m^3",null,null,{"$f":"$G$9*1000","v":2540},"kg/m^3",null,null,{"$f":"$G$9*1000","v":2540},"kg/m^3"]
[]
[null,null,"= (1-Sr)",{"$f":"1-$G$13","v":0.98},"Dimensionless",null,null,{"$f":"1-$G$13","v":0.98},"Dimensionless",null,null,{"$f":"1-$G$13","v":0.98},"Dimensionless",null,null,{"$f":"1-$G$13","v":0.98},"Dimensionless"]
[null,null,"= 1.1349",1.1349,"constant",null,null,1.1349,"constant",null,null,1.1349,"constant",null,null,1.1349,"constant"]
[null,null,"= (1-Sr)*1.1348",{"$f":"$D$45*$D$46","v":1.1122019999999999},"Dimensionless",null,null,{"$f":"$D$45*$D$46","v":1.1122019999999999},"Dimensionless",null,null,{"$f":"$D$45*$D$46","v":1.1122019999999999},"Dimensionless",null,null,{"$f":"$D$45*$D$46","v":1.1122019999999999},"Dimensionless"]
[null,null,"=(K * μ)",{"$f":"$G$17*$D$68","v":{"$error":"#N/A"}},"meter * gram / cm- sec^2",null,null,{"$f":"$G$17*H68","v":{"$error":"#N/A"}},"meter * gram / cm- sec^2",null,null,{"$f":"$G$17*L68","v":{"$error":"#N/A"}},"meter * gram / cm- sec^2",null,null,{"$f":"$G$17*P68","v":{"$error":"#N/A"}},"meter * gram / cm- sec^2"]
[null,null,"=(k * ρo * g)",{"$f":"$D$72*$D$69*$G$19","v":{"$error":"#N/A"}},"100 gram^2 * Sec^2 / cm^2",null,null,{"$f":"H72*H69*$G$19","v":{"$error":"#N/A"}},"100 gram^2 * Sec^2 / cm^2",null,null,{"$f":"L72*L69*$G$19","v":{"$error":"#N/A"}},"100 gram^2 * Sec^2 / cm^2",null,null,{"$f":"P72*P69*$G$19","v":{"$error":"#N/A"}},"100 gram^2 * Sec^2 / cm^2"]
[null,"kr","=(K * μ) / (k * ρo * g)",{"$f":"$D$78/($D$79)","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"H78/(H79)","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"L78/(L79)","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"P78/(P79)","v":{"$error":"#N/A"}},"Dimensionless"]
[null,null,"=((K * μ) / (k * ρo * g))0.3095",{"$f":"$D$80^0.3095","v":{"$error":"#N/A"}},null,null,null,{"$f":"H80^0.3095","v":{"$error":"#N/A"}},null,null,null,{"$f":"L80^0.3095","v":{"$error":"#N/A"}},null,null,null,{"$f":"P80^0.3095","v":{"$error":"#N/A"}}]
[null,"Se","= 1.1349* [((K * μ) / (k * ρo * g))0.3095]",{"$f":"$D$81*1.1349","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"H81*1.1349","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"L81*1.1349","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"P81*1.1349","v":{"$error":"#N/A"}},"Dimensionless"]
[null,"S","= ((1-Sr)*Se) + Sr",{"$f":"($D$75*$D$82)+$G$13","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"(H75*H82)+$G$13","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"(L75*L82)+$G$13","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"(P75*P82)+$G$13","v":{"$error":"#N/A"}},"Dimensionless"]
[null,"ϴo"," = S * Ø",{"$f":"D83*$G$11","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"H83*$G$11","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"L83*$G$11","v":{"$error":"#N/A"}},"Dimensionless",null,null,{"$f":"P83*$G$11","v":{"$error":"#N/A"}},"Dimensionless"]
[null,"Mo","= (ϴo * ρo)",{"$f":"$D$84*$D$69","v":{"$error":"#N/A"}},"mg",null,null,{"$f":"H84*H69","v":{"$error":"#N/A"}},"mg",null,null,{"$f":"L84*L69","v":{"$error":"#N/A"}},"mg",null,null,{"$f":"P84*P69","v":{"$error":"#N/A"}},"mg"]
[]
[null,"Ms","= ((1- Ø) * ρs)",{"$f":"(1-$G$11)*$D$73","v":1498.6000000000001},"g/cm3",null,null,{"$f":"(1-$G$11)*H73","v":1498.6000000000001},"gram/cm^3",null,null,{"$f":"(1-$G$11)*L73","v":1498.6000000000001},"gram/cm^3",null,null,{"$f":"(1-$G$11)*P73","v":1498.6000000000001},"gram/cm^3"]
[null,"Ms","Units Conversion",{"$f":"$D$87/1000","v":1.4986000000000002},"kg/ cm3",null,null,{"$f":"H87/1000","v":1.4986000000000002},"Kgram/ cm^3",null,null,{"$f":"L87/1000","v":1.4986000000000002},"Kgram/ cm^3",null,null,{"$f":"P87/1000","v":1.4986000000000002},"Kgram/ cm^3"]
[]
[null,"Coil","= Mo / Ms",{"$f":"(D85/D87)*1000000","v":{"$error":"#N/A"}},"mg/kg",null,null,{"$f":"(H85/H87)*1000000","v":{"$error":"#N/A"}},"mg/kg",null,null,{"$f":"(L85/L87)*1000000","v":{"$error":"#N/A"}},"mg/kg",null,null,{"$f":"(P85/P87)*1000000","v":{"$error":"#N/A"}},"mg/kg"]
[]
[]
["GRAIN SIZE TO CALCULATION OF INTRINSIC PERMEABILITY OF THE SOIL"]
[]
[null,null,"k = [φ3 * D102 mm2]  / [ 180 * (1-φ)2]","Baseline Calculation",null,null,null,"Baseline Calculation",null,null,null,"Baseline Calculation",null,null,null,"Baseline Calculation"]
[null,null,"Parameter","Sample #1",null,null,null,"Sample #2",null,null,null,"Sample #3",null,null,null,"Sample #4"]
[null,null,null,"Constant/ Value","Calculated Value","Unit of Measure",null,"Constant/ Value","Calculated Value","Unit of Measure",null,"Constant/ Value","Calculated Value","Unit of Measure",null,"Constant/ Value","Calculated Value","Unit of Measure"]
[null,null,"φ porosity",0.41,null,null,null,{"$f":"'Parameter Definition & Calculat'!$G$11","v":0.41},null,null,null,{"$f":"'Parameter Definition & Calculat'!$G$11","v":0.41},null,null,null,{"$f":"'Parameter Definition & Calculat'!$G$11","v":0.41}]
[null,null,"φ3",null,{"$f":"D98^3","v":6.8920999999999982E-2},null,null,null,{"$f":"H98^3","v":6.8920999999999982E-2},null,null,null,{"$f":"L98^3","v":6.8920999999999982E-2},null,null,null,{"$f":"P98^3","v":6.8920999999999982E-2}]
[null,null,"D10  sieve diam (mm) retaining 90% of dry sample mass = very fine sand",{"$f":"$D$70","v":0},null,null,null,{"$f":"$H$70","v":0},null,null,null,{"$f":"$L$70","v":0},null,null,null,{"$f":"$P$70","v":0}]
[null,null,null,{"$f":"IF(D100=0,0.1,D100)","v":0.1},null,null,null,{"$f":"IF(H100=0,0.1,H100)","v":0.1},null,null,null,{"$f":"IF(L100=0,0.1,L100)","v":0.1},null,null,null,{"$f":"IF(P100=0,0.1,P100)","v":0.1}]
[null,null,"D102 mm2",null,{"$f":"D101^2","v":1.0000000000000002E-2},null,null,null,{"$f":"H101^2","v":1.0000000000000002E-2},null,null,null,{"$f":"L101^2","v":1.0000000000000002E-2},null,null,null,{"$f":"P101^2","v":1.0000000000000002E-2}]
[null,null,"Constant",180,null,null,null,180,null,null,null,180,null,null,null,180]
[null,null,"1-φ",null,{"$f":"1-D98","v":0.59000000000000008},null,null,null,{"$f":"1-H98","v":0.59000000000000008},null,null,null,{"$f":"1-L98","v":0.59000000000000008},null,null,null,{"$f":"1-P98","v":0.59000000000000008}]
[null,null,"(1-φ)2",null,{"$f":"E104^2","v":0.34810000000000008},null,null,null,{"$f":"I104^2","v":0.34810000000000008},null,null,null,{"$f":"M104^2","v":0.34810000000000008},null,null,null,{"$f":"Q104^2","v":0.34810000000000008}]
[null,null,"Numerator =  φ3 * D102 mm2",null,{"$f":"E99*E102","v":6.8921E-4},null,null,null,{"$f":"I99*I102","v":6.8921E-4},null,null,null,{"$f":"M99*M102","v":6.8921E-4},null,null,null,{"$f":"Q99*Q102","v":6.8921E-4}]
[]
[null,null,"Denominator = 180 * (1-φ)2",null,{"$f":"D103*E105","v":62.658000000000015},null,null,null,{"$f":"H103*I105","v":62.658000000000015},null,null,null,{"$f":"L103*M105","v":62.658000000000015},null,null,null,{"$f":"P103*Q105","v":62.658000000000015}]
[null,null,"Intrinsic Permeability k (mm2)",null,{"$f":"E106/E108","v":1.0999553129688146E-5},null,null,null,{"$f":"I106/I108","v":1.0999553129688146E-5},null,null,null,{"$f":"M106/M108","v":1.0999553129688146E-5},null,null,null,{"$f":"Q106/Q108","v":1.0999553129688146E-5}]
[null,null,"Convert  to sq meters:  1 m2 per 106 mm2",1000000,null,null,null,1000000,null,null,null,1000000,null,null,null,1000000]
[]
[null,null,"Intrinsic Permeability k in m2",null,{"$f":"E109/D110","v":1.0999553129688145E-11},"m^2",null,null,{"$f":"I109/H110","v":1.0999553129688145E-11},"m^2",null,null,{"$f":"M109/L110","v":1.0999553129688145E-11},"m^2",null,null,{"$f":"Q109/P110","v":1.0999553129688145E-11},"m^2"]