{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["control","Introduction","Infiltration System","Attenuation_unsatzone","Dilution","Attenuation_satzone","Summary","Simple calcs","Ammonium calculator","Porosity Calculator","Attenuation calc_sat_zone"],"not_rendered":{"charts":3,"images":2,"macros":0,"external_links":0,"defined_names":91,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"control","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"but your chains"]

{"sheet":"Introduction","index":1,"n_rows":50,"n_cols":5,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,0,6,12],[32,4,32,6],[28,1,28,3],[13,0,13,7],[15,0,15,6],[16,0,16,4],[8,0,8,1],[9,0,10,12],[49,0,49,9],[7,0,7,3],[42,0,42,9],[34,0,34,6],[17,0,20,8],[25,1,25,6],[26,1,26,6],[21,0,21,8]]}
[]
[]
[]
[]
[]
[]
["Groundwater risk assessment for treated effluent discharges to infiltration systems"]
["Infiltration Worksheet , Release v3.0"]
["Date of Workbook Issue: March 2022"]
["This worksheet has been produced in combination with the document: H1 Annex J5 User Manual version 2.0 (Environment Agency, 2014)."]
[]
[]
[]
["© Environment Agency, 2021"]
[]
[]
["All rights reserved. You will not modify, reverse compile or otherwise dis-assemble the worksheet."]
["Liability: The Environment Agency does not promise that the worksheet will provide any particular facilities or functions. You must ensure that the worksheet meets your needs and you remain solely responsible for the competent use of the worksheet. You are entirely responsible for the consequences of any use of the worksheet and the Agency provides no warranty about the fitness for purpose or performance of any part of the worksheet. We do not promise that the media will always be free from defects, computer viruses, software locks or other similar code or that the operation of the worksheet will be uninterrupted or error free. You should carry out all necessary virus checks prior to installing on your computing system."]
[]
[]
[]
["IMPORTANT: To enable MS Excel worksheet, click the Microsoft Office Button        click Excel Options, click Add-Ins. In the Manage box, select Excel Add-ins. Click Go. Select Analysis ToolPak and Analysis ToolPak-VBA (to calculate error functions)\n"]
[]
["Details to be completed for each assessment"]
[]
["Site Name:","Enter site name"]
["Site Address:","Enter site address"]
[]
["Completed by:","Enter user name"]
["Date:","Enter date",null,"Version:","x.xx"]
[]
["Substance"," "]
["Environmental Standard (CT)",null,"mg/l","Origin of CT:","Specify basis for standard (e.g. MRV, EQS, DWS)"]
[]
["This spreadsheet has been developed as a tool to assist groundwater risk assessment for effluent discharges to infiltration systems. The following worksheets are available:"]
["Infiltration System"]
["Attenuation_unsatzone"]
["Dilution"]
["Attenuation_satzone"]
["Summary"]
["Simple calcs"]
[]
["Site details entered on this page are automatically copied to each worksheet."]
["The worksheet uses the following colour coding:"]
[null,"Worksheet option with pull down menu"]
[null,"Data entry"]
[null,"Data origin / justification should be noted in cells coloured yellow and fully documented in subsequent reports."]
[null,"Data carried forward from an earlier worksheet"]
[null,"Calculation "]
["It is recommended that a copy of the original worksheet is saved (all data fields in the original copy are blank)."]

{"sheet":"Infiltration System","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[23,0,23,1],[1,1,1,4],[5,3,5,4],[11,2,11,4],[5,7,6,11],[18,0,18,1],[18,2,18,4]]}
[]
[null,"Infiltration Worksheet "]
[]
[null,"Infiltration System"]
[null,null,null,null,null,null,null,null,null,{"$f":"CHAR(32)","v":" "}]
[null,"Substance",null,{"$f":"Introduction!B32","v":" "},null,"From introduction sheet",null,"This sheet allows user to enter effluent concentration and details of infitration system"]
[null,"Compliance value or environmental standard","CT",{"$f":"Introduction!B33","v":0},"mg/l","From introduction sheet"]
[null,null,null,null,null,"Calculate for ionic organic chemicals (acids)",{"$f":"IF(SUM(H5:H7)>1,\"only one option can be selected\",\"\")","v":""}]
[null,"Input Parameters","Variable","Value","Unit","Source of parameter value",null,null,null,null,null,null,null,null,"Calc cells to be hidden"]
[null,"Standard entry"]
[null,"Concentration of substance in discharge (entering infiltration system)","Ce",null,"mg/l",null,null,null,null,null,null,null,null,null,{"$f":"IF($C$12=P11,1,0)","v":0},"Septic tank"]
[null,"Type of treatment plant","Package treatment plant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$12=P12,2,0)","v":2},"Package treatment plant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$12=P13,3,0)","v":0},"Treatment plant"]
[null,"Water use and percolation rate (for use only with septic tanls and package treatment plants)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$12=P14,4,0)","v":0},"Other"]
[null,"Number of persons","p",null," ",null,"Not valid for this treatment plant option",null,null,null,null,null,null,null,{"$f":"SUM(O11:O14)","v":2}]
[null,"Water use"," ",180,"litres/person/day",null,"Not valid for this treatment plant option"]
[null,"Percolation rate","Vp",null,"s/mm",null,"Not valid for this treatment plant option"]
[]
["Specify discharge (Q1) or calculate based on use (Q2)",null,"Specified discharge Q1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$19=P19,1,0)","v":1},"Specified discharge Q1",null,null,null,{"$f":"IF(O19=1,D20,D21)","v":0}]
[null,"Discharge rate","Q1",null,"m3/d",null,"Value calculated and not specified by user",null,null,null,null,null,null,null,{"$f":"IF(O15>2,0,IF($C$19=P20,1,0))","v":0},{"$f":"IF(O15<3,\"Calculated discharge Q2\",\"\")","v":"Calculated discharge Q2"}]
[null,"Calculated discharge","Q2",{"$f":"0.001*D15*D16","v":0},"m3/d",null,"Value specifed by user and not calculated"]
[null,null,null,{"$f":"IF(O19=1,\"\",IF(O15>2,\"Can only specify discharge for treatment or other discharges\",\"\"))","v":""}]
[null,"Area of drainage fied and hydraulic loading"]
["Specify area of drainage field or calculate based on percolation rate",null,null,"Calculate",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$24=P24,1,0)","v":0},"Specify"]
[null,"Enter area of drainage field","A",0,"m2",null,"Value calculated and not specified by user",null,null,null,null,null,null,null,{"$f":"IF(O15>2,0,IF($D$24=P25,1,0))","v":1},{"$f":"IF(O15<3,\"Calculate\",\"\")","v":"Calculate"}]
[null,"Calculated area of drainage field","A",{"$f":"IF(O11=1,0.25*D17*D15,0.2*D17*D15)","v":0},"m2",{"$f":"IF(O15>2,IF(O25=1,\"This option only applies to septic tanks and package treatment plants - specify area \",\" \"),\" \")","v":" "},"Value specifed by user and not calculated"]
[null,"Calculated infiltration rate","Inf",{"$f":"IF(O24=0,T19/D26,T19/D25)","v":{"$error":"#DIV/0!"}},"m/d"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,"Site being assessed:",null,{"$f":"Introduction!$B$26","v":"Enter site name"}]
[null,null,null,null,null,null,"Completed by:",null,{"$f":"Introduction!B29","v":"Enter user name"}]
[null,null,null,null,null,null,"Date:",null,{"$f":"Introduction!B30","v":"Enter date"}]
[null,null,null,null,null,null,"Version:",null,{"$f":"Introduction!E30","v":"x.xx"}]

{"sheet":"Attenuation_unsatzone","index":3,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[[47,2,47,4],[1,1,1,4],[5,3,5,4],[70,5,70,8],[42,2,42,4],[5,7,6,11],[17,2,17,4],[21,2,21,4]]}
[]
[null,"Infiltration Worksheet "]
[]
[null,"Attenuation unsaturated zone",null,null,null,null,null,null,null,null,null,null,null,null,"Calc cells to be hidden"]
[null,null,null,null,null,null,null,null,null,{"$f":"CHAR(32)","v":" "}]
[null,"Contaminant",null,{"$f":"Introduction!B32","v":" "},null,"From introduction sheet",null,"This sheet calculates attenuation factor for the unsaturated zone; concentration at base of unsaturated zone and discharge consent limit"]
[null,"Compliance value or environmental standard","CT",{"$f":"Introduction!B33","v":0},"mg/l","From introduction sheet"]
[null,"Concentration of substance in substance in discharge (entering infiltration system)","Ce",{"$f":"'Infiltration System'!$D$11","v":0},"mg/l","From infiltration sheet"]
[]
[null,"Input Parameters","Variable","Value","Unit","Source of parameter value"]
[null,"Standard entry"]
[null,"Drainage Layer"]
[null,"Infiltraton rate","Inf",{"$f":"'Infiltration System'!$D$27","v":{"$error":"#DIV/0!"}},"m/d","From infiltration sheet",null,null,null,null,null,null,null,null,{"$f":"IF($C$18=P13,1,0)","v":1},"No degradation occurs"]
[null,"Thickness of drainage layer","S1",null,"m",null,null,null,null,null,null,null,null,null,{"$f":"IF($C$18=P14,1,0)","v":0},"Degradation occurs - sorbed and dissolved phases"]
[null,"Water filled porosity","q1",null,"fraction",null,null,null,null,null,null,null,null,null,{"$f":"IF($C$18=P15,1,0)","v":0},"Degradation occurs dissolved phase only"]
[null,"Bulk density","r1",null,"g/cm3"]
[null,"Calculated dispersivity","D1",{"$f":"+D14*0.1","v":0},"m","calculated",null,null,null,null,null,null,null,null,{"$f":"1/10^99","v":1E-99}]
[null,"Option to select degradation ","No degradation occurs"]
["Determine remedial target based on assumed concentration","Half life for degradation of  substance","t1/2",{"$f":"10^100","v":1E+100},"days",null,"Half life not required - No degradation occuring"]
[null,"Calculated decay rate","l1",{"$f":"IF(O13=1,O17,IF(O14=1,0.693147/D19,0.693147/(D19*D31)))","v":1E-99},"days-1","calculated (very low value set if no degradation)",{"$f":"IF(O13=1,\"Default value of 1/10^99 used\",\"Calculated from half life (above)\")","v":"Default value of 1/10^99 used"},null,null,null,null,null,null,null,{"$f":"IF(C22=\"User specified value for partition coefficient\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$22=P21,1,0)","v":1},"User specified value for partition coefficient"]
[null,"Enter method of defining partition co-efficient (using pull down list)","User specified value for partition coefficient",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$22=P22,1,0)","v":0},"Calculate for non-polar organic chemicals"]
[null,"Entry if specify partition coefficient (option)"]
[null,"Soil water partition coefficient","Kd1",0,"l/kg"," ","Not valid - Calculated value used"]
[null,"Entry for organic chemicals (option)"]
[null,"Fraction of organic carbon (in soil)","foc1",0.01,"fraction",null,"Not valid - User specified value used"]
[null,"Organic carbon partition coefficient","Koc1",10,"l/kg",null,"Not valid - User specified value used"]
[]
[null,"Soil water partition coefficient used in assessment","Kd1",{"$f":"IF(O21=1,$D$24,D26*D27)","v":0},"l/kg",{"$f":"IF(O20=1,\"Specified value\",\"Calculated value\")","v":"Specified value"}]
[]
[null,"Retardation factor","Rfu1",{"$f":"1+(D29*D16)/D15","v":{"$error":"#DIV/0!"}}," "]
[null,"Unretarded travel time (no dispersion)","tu1",{"$f":"D15*D14/D13","v":{"$error":"#DIV/0!"}},"d"]
[null,"Unretarded travel time (with dispersion)","tu1",{"$f":"(D14-D17)*D15/D13","v":{"$error":"#DIV/0!"}},"d"]
[null,"Retarded travel time (with dispersion)","tr1",{"$f":"D33*D31","v":{"$error":"#DIV/0!"}},"d"]
[null,"Attenuation factor ","AFu1",{"$f":"1/EXP(0.5*D14/D17-(0.5*D14/D17*(1+(4*D17*D20/(D13/D15/D31)))^0.5))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Unsaturated Zone"]
[]
[null,"Thickness of unsaturated zone below drainage field","S2",null,"m"]
[null,"Water filled porosity","q2",null,"fraction"]
[null,"Bulk density of unsaturated zone","r2",null,"g/cm3"]
[null,"Calculated dispersivity","D2",{"$f":"+D39*0.1","v":0},"m","calculated",null,null,null,null,null,null,null,null,{"$f":"IF($C$43=P42,1,0)","v":0},"No degradation occurs"]
[null,"Option to select degradation ","Degradation occurs - sorbed and dissolved phases",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$43=P43,1,0)","v":1},"Degradation occurs - sorbed and dissolved phases"]
["Determine remedial target based on assumed concentration","Half life for degradation of  substance","t1/2",{"$f":"10^100","v":1E+100},"days",null,"Half life not required - No degradation occuring",null,null,null,null,null,null,null,{"$f":"IF($C$43=P44,1,0)","v":0},"Degradation occurs dissolved phase only"]
[null,"Calculated decay rate","l2",{"$f":"IF(O42=1,O46,IF(O43=1,0.693147/D44,0.693147/(D44*D57)))","v":6.931469999999999E-101},"days-1","calculated (very low value set if no degradation)",{"$f":"IF(O43=1,\"Default value of 1/10^99 used\",\"Calculated from half life (above)\")","v":"Default value of 1/10^99 used"}]
[null,"Fraction of rapid flow through unsaturated zone","B",0,"fraction",null,null,null,null,null,null,null,null,null,{"$f":"1/10^99","v":1E-99}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48=\"User specified value for partition coefficient\",1,0)","v":1}]
[null,"Enter method of defining partition co-efficient (using pull down list)","User specified value for partition coefficient",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$48=P48,1,0)","v":1},"User specified value for partition coefficient"]
[null,"Entry if specify partition coefficient (option)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$48=P49,1,0)","v":0},"Calculate for non-polar organic chemicals"]
[null,"Soil water partition coefficient","Kd2",0,"l/kg"," ","Not valid - Calculated value used"]
[null,"Entry for organic chemicals (option)"]
[null,"Fraction of organic carbon (in soil)","foc2",0.01,"fraction",null,"Not valid - User specified value used"]
[null,"Organic carbon partition coefficient","Koc2",10,"l/kg",null,"Not valid - User specified value used"]
[]
[null,"Soil water partition coefficient used in assessment","Kd2",{"$f":"IF(O48=1,$D$50,D52*D53)","v":0},"l/kg",{"$f":"IF(O20=1,\"Specified value\",\"Calculated value\")","v":"Specified value"}]
[]
[null,"Retardation factor","Rfu2",{"$f":"1+(D55*D41)/D40","v":{"$error":"#DIV/0!"}}," "]
[null,"Unretarded travel time (no dispersion)","tu2",{"$f":"D39*D40/D13","v":{"$error":"#DIV/0!"}},"d"]
[null,"Unretarded travel time (with dispersion)","tu2",{"$f":"(D39-D42)*D40/D13","v":{"$error":"#DIV/0!"}},"d"]
[null,"Retarded travel time (with dispersion)","tr2",{"$f":"D59*D57","v":{"$error":"#DIV/0!"}},"d"]
[null,"Attenuation factor ","AFu2",{"$f":"1/EXP(0.5*D39/D42-(0.5*D39/D42*(1+(4*D42*D45/(D13/D40/D57)))^0.5))","v":{"$error":"#DIV/0!"}}]
[null,"Total unretarded travel time ","tu1 + tu2",{"$f":"D32+D58","v":{"$error":"#DIV/0!"}},"d"]
[null,"Total retarded travel time ","tr1 + tr2",{"$f":"D31*D32+D57*D58","v":{"$error":"#DIV/0!"}},"d"]
[]
[null,"Attenuation factor and discharge consent limit"," ",null,null,null,"Site being assessed:",null,{"$f":"Introduction!$B$26","v":"Enter site name"}]
[null,"Drainage layer attenuation factor","AFu1",{"$f":"D35","v":{"$error":"#DIV/0!"}}," "]
[null,"Unsaturated zone attenuation factor","AFu2",{"$f":"D61","v":{"$error":"#DIV/0!"}}," "," ","Completed by:",null,{"$f":"Introduction!B29","v":"Enter user name"}]
[null,"Concentration at base of drainage layer","Cdl",{"$f":"D8/D66","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D68<D7,\"below compliance value\",\"\")","v":{"$error":"#DIV/0!"}},"Date:",null,{"$f":"Introduction!B30","v":"Enter date"}]
[null,"Concentration at base of unsaturated zone","Cwt",{"$f":"D68*D46+(1-D46)*D68/D61","v":{"$error":"#DIV/0!"}},"mg/l"]
[null,null,null,"and",null," ","Version:",null,{"$f":"Introduction!E30","v":"x.xx"}]
[null,"Environmental Permit limit value","EPL1",{"$f":"D7*D8/D69","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D71>D8,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"IF(D69>D7, \"Concentration at base of unsaturated zone exceeds target concentration\",\"Concentration at base of unsaturated zone below target concentration\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Dilution","index":4,"n_rows":105,"n_cols":18,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,4],[22,0,22,1],[20,5,20,7],[22,5,22,7],[21,5,21,7],[5,3,5,4],[5,7,9,12],[18,5,18,7],[19,5,19,7],[16,5,16,7],[17,5,17,7]]}
[" "]
[null,"Infiltration  Worksheet"]
[]
[null,"Dilution"]
[]
[null,"Substance",null,{"$f":"Introduction!B32","v":" "},null,"From introduction sheet",null,"This sheet calculates the dilution factor for groundwater dilution below the drainage field. Substance concentration in groundwater and discharge consent limit"]
[null,"Compliance value or environmental standard","CT",{"$f":"Introduction!B33","v":0},"mg/l","From introduction sheet"]
[null,"Source concentration","Ce",{"$f":"'Infiltration System'!$D$11","v":0},"mg/l","From infiltration sheet"]
[null,{"$f":"Attenuation_unsatzone!B68","v":"Concentration at base of drainage layer"},"Cwt",{"$f":"Attenuation_unsatzone!D69","v":{"$error":"#DIV/0!"}},"mg/l","From atten_unsatzone sheet"]
[]
[null,"Input Parameters","Variable","Value","Unit","Source of parameter value"]
[null,"Standard entry"]
[null,"Infiltration","Inf",{"$f":"'Infiltration System'!$D$27","v":{"$error":"#DIV/0!"}},"m/d","From infiltration sheet"]
[null,"Area of drainage field","A",{"$f":"IF('Infiltration System'!$O$25=1,'Infiltration System'!$D$26,'Infiltration System'!$D$25)","v":0},"m2","From infiltration sheet"]
[]
[null,"Entry for groundwater flow below site"]
[null,"Length of drainage field in direction of groundwater flow","L",null,"m",null,null,null,null,{"$f":"IF($D$23=K17,1,0)","v":1},"Calculate "]
[null,"Saturated aquifer thickness","da",null,"m"]
[null,"Hydraulic Conductivity of aquifer in which dilution occurs","K",null,"m/d"]
[null,"Hydraulic gradient of water table","i",null,"fraction"]
[null,"Width of drainage field perpendicular to groundwater flow","w",null,"m",null,null,null,null,null,null,null,null,null,null,null,"Calc cells to be hidden"]
[null,"Background concentration of substance in groundwater up-gradient of site","Cu",null,"mg/l",null,{"$f":"IF(D22>D$7,\"Note - background concentration exceeds target concentration\",CHAR(32))","v":" "}]
["Define mixing zone depth by specifying or calculating depth (using pull down list)",null,null,"Calculate ",null,null,{"$f":"IF(D22>D$7,\"This will give a negative dilution factor for this calculation\",CHAR(32))","v":" "},null,null,null,null,null,null,null,null,null,{"$f":"IF($D$23=R23,1,0)","v":0},"Specify "]
[null,"Enter mixing zone thickness","Mz",5,"m",null,null,"Not valid - Value calculated",null,null,null,null,null,null,null,null,{"$f":"IF($D$23=R24,1,0)","v":1},"Calculate "]
[null,"Calculated mixing zone thickness","Mz",{"$f":"IF((0.0112*D17^2)^0.5+D18*(1-EXP((-D17*D13)/(D19*D20*D18)))>D18,D18,(0.0112*D17^2)^0.5+D18*(1-EXP(-D17*D13/(D19*D20*D18))))","v":{"$error":"#DIV/0!"}},"m",null,null,"Not valid - Value specified"]
[null,null,null,{"$f":"IF(B102=D14,\"\",B101)","v":""}]
[null,"Groundwater flow (mixing zone) below drainage field","Gw",{"$f":"IF(Q23=1,D19*D20*D21*D24,D19*D20*D21*D25)","v":{"$error":"#DIV/0!"}},"m3/d"]
[null,null," "]
[null,"Dilution factor and discharge consent limit"]
[null,"Dilution Factor ","DF",{"$f":"1+(D27/(D13*D14))","v":{"$error":"#DIV/0!"}},null,null,null,null,"Site being assessed:",null,{"$f":"Introduction!$B$26","v":"Enter site name"}]
[null,"Headroom Factor ","HF",{"$f":"((D27+D13*D14)*D7-D27*D22)/(D13*D14*D7)","v":{"$error":"#DIV/0!"}},null,null,null,null,"Completed by:",null,{"$f":"Introduction!B29","v":"Enter user name"}]
[null,"Unsaturated zone attenuation factor","AFu",{"$f":"Attenuation_unsatzone!$D$67","v":{"$error":"#DIV/0!"}},null,"From infiltration sheet",null,null,"Date:",null,{"$f":"Introduction!B30","v":"Enter date"}]
[null,"Concentration in groundwater below drainage field","Cgw",{"$f":"((D9*D13*D14)+(D27*D22))/(D13*D14+D27)","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D33<D7,\"below compliance value\",\"\")","v":{"$error":"#DIV/0!"}},null,null,"Version:",null,{"$f":"Introduction!E30","v":"x.xx"}]
[null,null,null,"or"]
[null,"Environmental Permit limit value","EPL2",{"$f":"D31*Attenuation_unsatzone!$D$71","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D35>D8,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"IF(D33>D7, \"Concentration immediately downgradient of drainage field exceeds target concentration\",\"Concentration immediately downgradient of drainage field below target concentration\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B103&B102&B104&D14&B105","v":"w * L ( 0 ) does not equal area (A) of drainage field ( 0 ) - check parameters used (this may be OK if drainage field at angle to flow direction)"}]
[null,{"$f":"D21*D17","v":0}]
[null,"w * L ( "]
[null," ) does not equal area (A) of drainage field ( "]
[null," ) - check parameters used (this may be OK if drainage field at angle to flow direction)"]

{"sheet":"Attenuation_satzone","index":5,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":false,"merged":[[17,8,17,11],[0,1,0,4],[55,3,55,4],[5,7,5,10],[6,3,6,4],[50,5,50,9],[16,2,16,4],[1,7,2,12],[26,2,26,4]]}
[null,"Infiltration  Worksheet",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H$6=AA24,1,0)","v":1}]
[null,null,null,null,null,null,null,"This sheet calculates attenuation factor for the saturated zone; substance concentration at downgradient compliance point and discharge consent limit",null,null,null,null,null,null,null,{"$f":"IF($H$6=AA25,1,0)","v":0}]
[null,"Attenuation in saturated zone",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($H$6=Q3,1,0)","v":0}]
[]
[null,"Input Parameters","Variable","Value","Unit","Source",null,"Enter method of defining partition co-efficient (using pull down list)"]
[null,null,null,null,null,null,null,"User specified value for partition coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated concentrations for "]
[null,"Substance",null,{"$f":"Introduction!B32","v":" "},null,"From introduction sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"distance-concentration graph"]
[null,"Compliance value or environmental standard","CT",{"$f":"Introduction!B33","v":0},"mg/l","From introduction sheet",null,"Entry if specify partition coefficient (option)"]
[null,"Source concentration","Ce",{"$f":"'Infiltration System'!$D$11","v":0},"mg/l","From infiltration sheet",null,"Soil water partition coefficient",null,null,"Kd",null,"l/kg",null,null,{"$f":"CHAR(32)","v":" "}]
[null,"Dilution Factor","DF",{"$f":"Dilution!$D$30","v":{"$error":"#DIV/0!"}},null,"from dilution sheet",null,"Entry for organic chemicals (option)"]
[null,"Unsaturated zone attenuation factor","AFu",{"$f":"Dilution!$D$32","v":{"$error":"#DIV/0!"}},null,"From atten_unsatzone sheet",null,"Fraction of organic carbon in aquifer",null,null,"foc",0,"fraction"]
[null,null,null,null,null,null,null,"Organic carbon partition coefficient",null,null,"Koc",0,"l/kg",null,null,null,null,null,null,null,null,null,"From calculation sheet"]
[null,null,null,null,null,null,null,"Soil water partition coefficient",null,null,"Kd",{"$f":"IF(P1=1,$L$9,L$12*$L$11)","v":0},"l/kg",null,null,null,null,null,null,null,null,null,"Distance m"," Concentration mg/l",{"$f":"IF(C15=\"Soil leachate concentration as mg/l\",\"mg/l\",IF(C15=\"Soil concentration as mg/kg\",\"mg/l\",\"\"))","v":""}]
[null,null,"Variable","Value","Unit","Source of parameter value",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$D$16","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X14*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X14*$D$44/D$10,\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F6","v":0},{"$f":"'Attenuation calc_sat_zone'!Y6","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X15*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X15*$D$44/D$10,\"\"))","v":""}]
[null,"Concentration in groundwater below drainage field","Cgw",{"$f":"Dilution!$D$33","v":{"$error":"#DIV/0!"}},"mg/l","from dilution sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F7","v":0},{"$f":"'Attenuation calc_sat_zone'!Y7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X16*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X16*$D$44/D$10,\"\"))","v":""}]
[null,"Option to select degradation ","Degradation occurs - sorbed and dissolved phases",null,null,null,null,"Define dispersivity (click brown cell and use pull down list)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F8","v":0},{"$f":"'Attenuation calc_sat_zone'!Y8","v":{"$error":"#DIV/0!"}}]
[null,"Half life for degradation of  substance","t1/2",{"$f":"10^100","v":1E+100},"days",null,null,null,"Dispersivity based on Xu & Eckstein (1995)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F9","v":0},{"$f":"'Attenuation calc_sat_zone'!Y9","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X17*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X17*$D$44/D$10,\"\"))","v":""}]
[null,"Calculated decay rate","l ",{"$f":"IF(AA30=1,AA33,IF(AA31=1,0.693147/D18,0.693147/(D18*D39)))","v":6.931469999999999E-101},"days-1","calculated (very low value set if no degradation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F10","v":0},{"$f":"'Attenuation calc_sat_zone'!Y10","v":{"$error":"#DIV/0!"}},""]
[null,"Width of drainage field","w",{"$f":"Dilution!$D$21","v":0},"m","from dilution sheet",null,null,null,null,null,"Enter value","Calc value","Xu & Eckstein",null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F11","v":0},{"$f":"'Attenuation calc_sat_zone'!Y11","v":{"$error":"#DIV/0!"}},""]
[null,"Mixing zone thickness","Mz",{"$f":"IF(Dilution!D23=Dilution!$R$23,Dilution!D24,Dilution!D25)","v":{"$error":"#DIV/0!"}},"m","from dilution sheet",null,"Longitudinal dispersivity (m)",null,null,"ax",9.9999999999999998E-13,{"$f":"$D$26*0.1","v":0},{"$f":"0.83*(LOG(D26))^2.414","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F12","v":0},{"$f":"'Attenuation calc_sat_zone'!Y12","v":{"$error":"#DIV/0!"}},""]
[null,"Bulk density of aquifer materials","r",null,"g/cm3","  ",null,"Transverse dispersivity (m)",null,null,"az",9.9999999999999998E-13,{"$f":"$D$26*0.01","v":0},{"$f":"N21/10","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F13","v":0},{"$f":"'Attenuation calc_sat_zone'!Y13","v":{"$error":"#DIV/0!"}},"",null,"Calc cells to be hidden"]
[null,"Effective porosity of aquifer","n",null,"fraction",null,null,"Vertical dispersivity (m)",null,null,"ay",9.9999999999999998E-13,{"$f":"$D$26*0.001","v":0},{"$f":"N21/100","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F14","v":0},{"$f":"'Attenuation calc_sat_zone'!Y14","v":{"$error":"#DIV/0!"}},""]
[null,"Hydraulic gradient","icorr",{"$f":"D41","v":{"$error":"#DIV/0!"}},"fraction","from dilution sheet (adjusted)",null,"Note values of dispersivity must be > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F15","v":0},{"$f":"'Attenuation calc_sat_zone'!Y15","v":{"$error":"#DIV/0!"}},"",null,"User specified value for partition coefficient"]
[null,"Hydraulic conductivity of saturated aquifer","K",{"$f":"Dilution!$D$19","v":0},"m/d","from dilution sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F16","v":0},{"$f":"'Attenuation calc_sat_zone'!Y16","v":{"$error":"#DIV/0!"}},"",null,"Calculate for non-polar organic chemicals"]
[null,"Distance to compliance point","x",null,"m",null,null,"Xu & Eckstein (1995) report ax = 0.83(log10x)2.414 ; az = ax/10, ay = ax/100 are assumed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F17","v":0},{"$f":"'Attenuation calc_sat_zone'!Y17","v":{"$error":"#DIV/0!"}},""]
[null,"Option to select time","Use steady state (recommended)",null,null,null,null,"For calculated value, assumes ax = 0.1 *x, az = 0.01 * x, ay = 0.001 * x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F18","v":0},{"$f":"'Attenuation calc_sat_zone'!Y18","v":{"$error":"#DIV/0!"}}]
[null,"Enter time","t",100,"days","time variant options only",null,null,null,null,null,null,"User defined values for dispersivity",null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F19","v":0},{"$f":"'Attenuation calc_sat_zone'!Y19","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X26*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X26*$D$44/D$10,\"\"))","v":""}]
[null,"Time since pollutant entered groundwater","t",{"$f":"IF(AA35=1,1E+99,D28)","v":9.9999999999999997E+98},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F20","v":0},{"$f":"'Attenuation calc_sat_zone'!Y20","v":{"$error":"#DIV/0!"}}]
[{"$f":"Dilution!$J$13","v":0},"Parameters values determined from options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F21","v":0},{"$f":"'Attenuation calc_sat_zone'!Y21","v":{"$error":"#DIV/0!"}},{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X27*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X27*$D$44/D$10,\"\"))","v":""},null,{"$f":"IF($C$17=AB30,1,0)","v":0},"No degradation occurs"]
[null,"Partition coefficient","Kd",{"$f":"L13","v":0},"l/kg","see options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F22","v":0},{"$f":"'Attenuation calc_sat_zone'!Y22","v":{"$error":"#DIV/0!"}},"",null,{"$f":"IF($C$17=AB31,1,0)","v":1},"Degradation occurs - sorbed and dissolved phases"]
[null,"Longitudinal dispersivity","ax",{"$f":"IF($I$18=\"Dispersivity based on Xu & Eckstein (1995)\",N21,IF($I$18=\"Dispersivities 10%, 1%, 0.1% of pathway length\",M21,IF($I$18=\"User defined values for dispersivity\",L21)))","v":{"$error":"#NUM!"}},"m","see options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F23","v":0},{"$f":"'Attenuation calc_sat_zone'!Y23","v":{"$error":"#DIV/0!"}},"",null,{"$f":"IF($C$17=AB32,1,0)","v":0},"Degradation occurs dissolved phase only"]
[null,"Transverse dispersivity","az",{"$f":"IF($I$18=\"Dispersivity based on Xu & Eckstein (1995)\",N22,IF($I$18=\"Dispersivities 10%, 1%, 0.1% of pathway length\",M22,IF($I$18=\"User defined values for dispersivity\",L22)))","v":{"$error":"#NUM!"}},"m","see options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F24","v":0},{"$f":"'Attenuation calc_sat_zone'!Y24","v":{"$error":"#DIV/0!"}},"",null,{"$f":"1/10^99","v":1E-99}]
[null,"Vertical dispersivity","ay",{"$f":"IF($I$18=\"Dispersivity based on Xu & Eckstein (1995)\",N23,IF($I$18=\"Dispersivities 10%, 1%, 0.1% of pathway length\",M23,IF($I$18=\"User defined values for dispersivity\",L23)))","v":{"$error":"#NUM!"}},"m","see options",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Attenuation calc_sat_zone'!F25","v":0},{"$f":"'Attenuation calc_sat_zone'!Y25","v":{"$error":"#DIV/0!"}},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF($C$27=AB35,1,0)","v":1},"Use steady state (recommended)"]
[null,"Calculated Parameters","Variable","Value","Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C$15=\"Soil leachate concentration as mg/l\",X34*$D$44/D$10,IF(C$15=\"Soil concentration as mg/kg\",X34*$D$44/D$10,\"\"))","v":""},null,{"$f":"IF($C$27=AB36,1,0)","v":0},"Enter time (if validating model)"]
[]
[null,"Groundwater flow velocity","v",{"$f":"'Attenuation calc_sat_zone'!C29","v":{"$error":"#DIV/0!"}},"m/d"]
[null,"Retardation factor","Rf",{"$f":"1+(D31*D22)/D23","v":{"$error":"#DIV/0!"}},"fraction",null,null,null,null,null,null,null,null,null,"Site being assessed:",null,{"$f":"Introduction!$B$26","v":"Enter site name"}]
[null,"Decay rate used","l",{"$f":"D19","v":6.931469999999999E-101},"d-1",null,null,null,null,null,null,null,null,null,"Completed by:",null,{"$f":"Introduction!G37","v":0},null,null,null,null,null,null,null,null,null,"Dispersivity based on Xu & Eckstein (1995)"]
[null,"Hydraulic gradient used in aquifer flow down-gradient","icorr",{"$f":"Dilution!D20*(D10/(D10-1))","v":{"$error":"#DIV/0!"}},"fraction",null,null,null,null,null,null,null,null,null,"Date:",null,{"$f":"Introduction!G38","v":"00:00:00"},null,null,null,null,null,null,null,null,null,"Dispersivities 10%, 1%, 0.1% of pathway length"]
[null,"Rate of contaminant flow due to retardation","u",{"$f":"'Attenuation calc_sat_zone'!C31","v":{"$error":"#DIV/0!"}},"m/d",null,null,null,null,null,null,null,null,null,"Version:",null,{"$f":"Introduction!J38","v":0},null,null,null,null,null,null,null,null,null,"User defined values for dispersivity"]
[null,"Attenuation factor ","AFs",{"$f":"IF('Attenuation calc_sat_zone'!$X$25=0,10^99,1/'Attenuation calc_sat_zone'!$X$25)","v":{"$error":"#NUM!"}},"fraction",{"$f":"IF('Attenuation calc_sat_zone'!$X$25=0,\"No significant breakthrough at compliance point\",\"\")","v":{"$error":"#NUM!"}}]
[null,{"$f":"IF(C15=\"Soil leachate concentration as mg/l\",\"Soil leachate concentration\",IF(C15=\"Soil concentration as mg/kg\",\"Calculated soil leachate concentration\",\"\"))","v":""},{"$f":"IF(C15=\"Soil leachate concentration as mg/l\",\"Co\",IF(C15=\"Soil concentration as mg/kg\",\"Co\",\"\"))","v":""},{"$f":"IF(C15=\"Soil leachate concentration as mg/l\",D16,IF(C15=\"Soil concentration as mg/kg\",D16/#REF!,\"\"))","v":""},{"$f":"IF(C43=\"Soil leachate concentration as mg/l\",\"mg/l\",IF(C15=\"Soil concentration as mg/kg\",\"mg/l\",\"\"))","v":""}]
[null,"Attenuation and Dilution factors and discharge consent limit",null,null,null,null,null,null,null,null,null,"Domenico - Time Variant"]
[null,"Dilution Factor ","DF",{"$f":"D10","v":{"$error":"#DIV/0!"}}]
[null,"Unsaturated zone attenuation factor","AFu",{"$f":"Attenuation_unsatzone!$D$61","v":{"$error":"#DIV/0!"}}]
[null,"Saturated zone attenuation factor","AFs",{"$f":"D43","v":{"$error":"#NUM!"}}]
[null,"Concentration in groundwater at compliance point","Cdcp",{"$f":"Dilution!$D$22 + (D16-Dilution!$D$22)/D48","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D49<D8,\"below compliance value\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,"or"]
[null,"Environmental Permit limit value","EPL3",{"$f":"Dilution!$D$35*D48","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D51>D9,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Distance to compliance point",null,{"$f":"D26","v":0},"m"]
[]
[null,{"$f":"IF(D49>D8, \"Concentration at compliance point exceeds target concentration\",\"Concentration at compliance point below target concentration\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Summary","index":6,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,5,31,8],[0,0,0,12],[2,0,2,7],[27,5,27,8],[29,5,29,8],[6,3,6,4]]}
["Infiltration  Worksheet "]
[]
["Summary of calculations for concentration of substance in groundwater "]
["No input required,values taken from previous worksheets"]
[]
["Summary of compliance data, attenuation and dilution factors"]
[null,"Substance",null,{"$f":"Introduction!B32","v":" "}]
[null,"Effluent concentration","Ce",{"$f":"'Infiltration System'!$D$11","v":0},"mg/l"]
[]
[null,"Compliance value or environmental standard","CT",{"$f":"Attenuation_satzone!$D$8","v":0},"mg/l"]
[]
[null,"Distance to compliance point",null,{"$f":"Attenuation_satzone!$D$26","v":0},"m"]
[]
[null,"Attenuation factor - unsat zone","AFu",{"$f":"Attenuation_unsatzone!$D$67","v":{"$error":"#DIV/0!"}}]
[]
[null,{"$f":"Dilution!B30","v":"Dilution Factor "},{"$f":"Dilution!C30","v":"DF"},{"$f":"Dilution!D30","v":{"$error":"#DIV/0!"}}]
[]
[null,"Attenuation factor- sat zone",{"$f":"Attenuation_satzone!C43","v":"AFs"},{"$f":"Attenuation_satzone!D43","v":{"$error":"#NUM!"}}]
[]
["Predicted concentrations at compliance point based on proposed effluent concentration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calc cells to be hidden"]
[null,"Concentration at base of unsaturated zone","Cwt",{"$f":"Attenuation_unsatzone!$D$69","v":{"$error":"#DIV/0!"}},"mg/l","Attenuation in unsaturated zone only "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effluent",{"$f":"$D$8","v":0},{"$f":"$D$10","v":0}]
[null,"Concentration in groundwater below drainage field","Cgw",{"$f":"Dilution!$D$33","v":{"$error":"#DIV/0!"}},"mg/l","Dilution taken into account",null,null,null,null,null,null,null,null,null,null,null,null,"Base unsat zone",{"$f":"$D$21","v":{"$error":"#DIV/0!"}},{"$f":"$D$10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dilution",{"$f":"$D$23","v":{"$error":"#DIV/0!"}},{"$f":"$D$10","v":0}]
[null,"Concentration in groundwater at compliance point","Cdcp",{"$f":"Attenuation_satzone!$D$49","v":{"$error":"#DIV/0!"}},"mg/l","Attenuation in saturated zone taken into account",null,null,null,null,null,null,null,null,null,null,null,null,"Compliance borehole",{"$f":"$D$25","v":{"$error":"#DIV/0!"}},{"$f":"$D$10","v":0}]
[{"$f":"IF(D25>D10, \"Lower effluent concentration may be required - see below\", \"\")","v":{"$error":"#DIV/0!"}}]
["Provisional Environmental Permit limit values"]
[null,"Based on attenuation in unsaturated zone","EPL1",{"$f":"Attenuation_unsatzone!$D$71","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D28>D$8,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"Based on attenuation in unsaturated zone and dilution","EPL2",{"$f":"Dilution!$D$35","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D30>D$8,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]
[]
[null,"Based on dilution and attenuation in unsaturated and saturated zone","EPL3",{"$f":"Attenuation_satzone!$D$51","v":{"$error":"#DIV/0!"}},"mg/l",{"$f":"IF(D32>D$8,\"Discharge limit for discussion with Environment Agency\",\"\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"Simple calcs","index":7,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,6,6,9],[7,6,7,9],[8,6,8,9],[10,6,10,9],[15,6,15,9],[11,6,11,9],[12,6,12,9],[13,6,13,9],[14,6,14,9]]}
[]
["Simple hydrogeological calculations"]
["(These calculations are provided to allow additional hydrogeological calculations to be undertaken if required)"]
[]
[]
[null,"Parameter","symbol",null,"unit",null,"justification"]
[null,"Hydraulic conductivity","K",0,"m/d"]
[null,"Hydraulic gradient","i ",0,"unitless"]
[null,"Effective porosity of aquifer","n",0,"fraction"]
[]
[null,"Thickness of saturated aquifer","b",0,"m"]
[null,"Width of aquifer perpendicular to flow","w",0,"m"]
[null,"Distance to receptor","x",0,"m"]
[null,"Bulk density of aquifer materials","r",0,"g/cm3"]
[null,"Soil-water partition co-efficient","Kd",0,"l/kg"]
[null,"Retardation factor of pollutant","R",{"$f":"1+(D15*D14)/D9","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,"Groundwater flow velocity","v(GW)",{"$f":"(D7*D8)/(D9*86400)","v":{"$error":"#DIV/0!"}},"m/s",null,{"$f":"(D7*D8)/D9","v":{"$error":"#DIV/0!"}},"m/day",null,{"$f":"(365*D7*D8)/D9","v":{"$error":"#DIV/0!"}},"m/year"]
[null,"Time for groundwater to reach receptor","t(GW)",{"$f":"D13/D20","v":{"$error":"#DIV/0!"}},"seconds",null,{"$f":"D13/G20","v":{"$error":"#DIV/0!"}},"days",null,{"$f":"D13/J20","v":{"$error":"#DIV/0!"}},"years"]
[null,"Rate of groundwater flow through aquifer","Q",{"$f":"D7*D8*D11*D12/86400","v":0},"m3/s",null,{"$f":"D7*D8*D11*D12","v":0},"m3/day",null,{"$f":"D7*D8*D11*D12*365","v":0},"m3/year"]
[]
[null,"Contaminant flow velocity","v(contam)",{"$f":"(D7*D8)/(86400*D9*D16)","v":{"$error":"#DIV/0!"}},"m/s",null,{"$f":"(D7*D8)/(D9*D16)","v":{"$error":"#DIV/0!"}},"m/day",null,{"$f":"(365*D7*D8)/(D9*D16)","v":{"$error":"#DIV/0!"}},"m/year"]
[null,"Time for contaminant to reach receptor","t(contam)",{"$f":"D13/D24","v":{"$error":"#DIV/0!"}},"seconds",null,{"$f":"D13/G24","v":{"$error":"#DIV/0!"}},"days",null,{"$f":"D13/J24","v":{"$error":"#DIV/0!"}},"years"]

{"sheet":"Ammonium calculator","index":8,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Ammonium calculator"]
["This sheet allows the user to convert between different laboratory analysis for ammonium"]
["The ammonium ion (NH4) is typically the dominant ion at neutral pH , however in more alkaline water the ammonia (NH3) ion becomes increasingly dominant."]
["Laboratories may report the analysis for ammonium as (NH4) or as N (NH4-N). In some cases the laboratory may have reported the result as Total ammonia (as NH3) or as Total ammonoa as N. In this case total ammonia is likely to include ammonium (NH4) and ammonia (NH3)."]
["In this case NH4 may be been converted to NH3."]
[]
[]
[]
[]
[]
[]
[]
["Form of ammoniun (laboratory)","Ammonium (NH4) as N",null,null,null,null,null,null,null,null,null,null,"Ammonium (NH4) as N","Ammonium as NH4","Total Ammonia as NH3","Total Ammonia as N"]
[null,null,null,null,null,null,null,null,null,"Ammonium (NH4) as N","as N",4,1,{"$f":"18/14","v":1.2857142857142858},{"$f":"17/14","v":1.2142857142857142},1," "]
["Concentration (laboratory)",10,{"$f":"\"mg/l \"&J21","v":"mg/l as N"},null,null,null,null,null,null,"Ammonium as NH4","as NH4",5,{"$f":"14/18","v":0.77777777777777779},1,{"$f":"17/18","v":0.94444444444444442},{"$f":"14/18","v":0.77777777777777779}]
[null,null,null,null,null,null,null,null,null,"Total Ammonia as NH3","as NH3",6,{"$f":"14/17","v":0.82352941176470584},{"$f":"18/17","v":1.0588235294117647},1,{"$f":"14/17","v":0.82352941176470584}]
["Unit to convert to ","Ammonium as NH4",null,null,null,null,null,null,null,"Total Ammonia as N","as N",7,1,{"$f":"18/14","v":1.2857142857142858},{"$f":"17/14","v":1.2142857142857142},1]
[]
["Converted concentration",{"$f":"B16*J27","v":12.857142857142858},{"$f":"\"mg/l \"&J23","v":"mg/l as NH4"}]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B14,J15:K18,2,FALSE)","v":"as N"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B18,J15:K18,2,FALSE)","v":"as NH4"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B18,J15:L18,3,FALSE)","v":5}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B14,J15:P24,J25,FALSE)","v":1.2857142857142858}]

{"sheet":"Porosity Calculator","index":9,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,"Porosity Calculator"]
[null,"These results are not carried through to any of the other worksheets"]
[null,"DRY BULK DENSITY DATA"]
[]
[null,"Variable","Value","Unit","justification"]
[null,null," "]
[null,"Natural Moisture Content",0,"% wt"]
[null,"Particle Density",0,"tonnes/m3","(Change this number only if you have specific information)"]
[null,"Dry Bulk Density",0,"tonnes/m3"]
[]
[null,"Calculated Parameters"]
[null,"Voids Ratio",{"$f":"(C8/C9)-1","v":{"$error":"#DIV/0!"}},"fraction"]
[null,"Initial Saturation",{"$f":"C7*C8/C12","v":{"$error":"#DIV/0!"}},"%"]
[]
[null,"Total porosity",{"$f":"1-C9/C8","v":{"$error":"#DIV/0!"}},"fraction"]
[null,"Air Filled Porosity",{"$f":"IF(C13>100,0,((100-($C$13))*$C$15)/100)","v":{"$error":"#DIV/0!"}},"fraction"]
[null,"Water Filled Porosity",{"$f":"C15-C16","v":{"$error":"#DIV/0!"}},"fraction"]
[]
[]
[]
[null,"WET BULK DENSITY DATA"]
[]
[null,"Variable","Value","Unit"]
[null,"Moisture Content",0,"% wt"]
[null,"Particle Density",0,"tonnes/m3","(Change this number only if you have specific information)"]
[null,"Actual (wet) Bulk Density ( i.e. at natural MC)",0,"tonnes/m3"]
[]
[null,"Calculated Parameters"]
[null,"Voids Ratio",{"$f":"(C25/C30)-1","v":{"$error":"#DIV/0!"}},"fraction"]
[null,"dry bulk density",{"$f":"(100*C26)/(100+C24)","v":0},"tonnes/m3"]
[null,"Initial Saturation",{"$f":"C24*C25/C29","v":{"$error":"#DIV/0!"}},"%"]
[]
[null,"Total porosity",{"$f":"1-C30/C25","v":{"$error":"#DIV/0!"}},"fraction",{"$f":"IF(C31>100,\"ERROR, PERCENT SATURATION IN EXCESS OF 100%\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,"Air Filled Porosity",{"$f":"IF(C31>100,0,((100-(C31))*C33)/100)","v":{"$error":"#DIV/0!"}},"fraction"]
[null,"Water Filled Porosity",{"$f":"C33-C34","v":{"$error":"#DIV/0!"}},"fraction"]
[]
[]
[null,"Analytical solutions provided by David Hall, Golder Associates (UK) Ltd"]

{"sheet":"Attenuation calc_sat_zone","index":10,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Calculation sheet for attenuation in saturated zone"]
[null,null,null,null,null,"OGATA BANKS SOLUTION"]
[null,null,null,null,null,"Calculations for source located at top of aquifer (ie vertical dispersion in one direction) "]
[null,null,null,null,null,"X","Term 1","Term 2","EXP","Term 3","ERFC","Term 4","EXP","Term 5","ERFC","Term 6a","ERF","Term 6b","ERF","Term 7a","ERF","Term 7b","ERF","Relative Concentration ","Concentration"]
[null,"Input","Value","Units"]
[null,"CT",{"$f":"Attenuation_satzone!D8","v":0},"mg/l",1,{"$f":"$C$18/20*E6","v":0},{"$f":"0.125","v":0.125},{"$f":"$F6/(2*$C$22)*(1-(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$f":"EXP(H6)","v":{"$error":"#NUM!"}},{"$f":"1/(2*(SQRT($C$22*$C$31*$C$21)))*($F6-($C$31*$C$21)*(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$f":"IF(J6<-4,2,IF(J6>4,0,IF(J6>=0,ERFC(J6),1+ERF(-J6))))","v":{"$error":"#NUM!"}},{"$f":"$F6/(2*$C$22)*(1+(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$f":"IF(L6>700,EXP(700),EXP(L6))","v":{"$error":"#NUM!"}},{"$f":"1/(2*(SQRT($C$22*$C$31*$C$21)))*($F6+($C$31*$C$21)*(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$f":"IF(N6<-4,2,IF(N6>4,0,IF(N6>=0,ERFC(N6),1+ERF(-N6))))","v":{"$error":"#NUM!"}},{"$f":"(($C$19+0.5*$C$11)/(2*SQRT($C$23*$F6)))","v":{"$error":"#NUM!"}},{"$f":"IF(P6<0,IF(P6<-10,-1,-ERF(-P6)),IF(P6>10,1,ERF(P6)))","v":{"$error":"#NUM!"}},{"$f":"(($C$19-0.5*$C$11)/(2*SQRT($C$23*$F6)))","v":{"$error":"#NUM!"}},{"$f":"IF(R6<0,IF(R6<-10,-1,-ERF(-R6)),IF(R6>10,1,ERF(R6)))","v":{"$error":"#NUM!"}},{"$f":"(($C$20+$C$12)/(2*SQRT($C$24*$F6)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(T6<0,IF(T6<-10,-1,-ERF(-T6)),IF(T6>10,1,ERF(T6)))","v":{"$error":"#DIV/0!"}},{"$f":"(($C$20-$C$12)/(2*SQRT($C$24*$F6)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(V6<0,IF(V6<-10,-1,-ERF(-V6)),IF(V6>10,1,ERF(V6)))","v":{"$error":"#DIV/0!"}},{"$f":"G6*(I6*K6+M6*O6)*(Q6-S6)*(U6-W6)","v":{"$error":"#NUM!"}},{"$f":"C$25+(C$8-C$25)/(1/X6)","v":{"$error":"#DIV/0!"}}]
[null,"DF",{"$f":"Attenuation_satzone!D10","v":{"$error":"#DIV/0!"}},null,2,{"$f":"$C$18/20*E7","v":0},0.125,{"$error":"#NUM!"},{"$f":"EXP(H7)","v":{"$error":"#NUM!"}},{"$f":"1/(2*(SQRT($C$22*$C$31*$C$21)))*($F7-($C$31*$C$21)*(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"$F7/(2*$C$22)*(1+(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$f":"IF(L7>700,EXP(700),EXP(L7))","v":{"$error":"#NUM!"}},{"$f":"1/(2*(SQRT($C$22*$C$31*$C$21)))*($F7+($C$31*$C$21)*(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"(($C$19+0.5*$C$11)/(2*SQRT($C$23*$F7)))","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"(($C$19-0.5*$C$11)/(2*SQRT($C$23*$F7)))","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"(($C$20+$C$12)/(2*SQRT($C$24*$F7)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(($C$20-$C$12)/(2*SQRT($C$24*$F7)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"G7*(I7*K7+M7*O7)*(Q7-S7)*(U7-W7)","v":{"$error":"#NUM!"}},{"$f":"C$25+(C$8-C$25)/(1/X7)","v":{"$error":"#DIV/0!"}}]
[null,"Cgw",{"$f":"Attenuation_satzone!$D$16","v":{"$error":"#DIV/0!"}},null,3,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,null,null,null,4,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"l ",{"$f":"Attenuation_satzone!D40","v":6.931469999999999E-101},"days-1",5,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"Sz",{"$f":"Attenuation_satzone!D20","v":0},"m",6,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"Sy",{"$f":"IF(B35=1,#REF!,Attenuation_satzone!D21)","v":{"$error":"#DIV/0!"}},"m",7,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"Kd",{"$f":"Attenuation_satzone!L13","v":0},"l/kg",8,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"r",{"$f":"Attenuation_satzone!D22","v":0},"g/cm3",9,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"n",{"$f":"Attenuation_satzone!D23","v":0},null,10,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"i",{"$f":"Attenuation_satzone!D41","v":{"$error":"#DIV/0!"}},null,11,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"K",{"$f":"IF(B35=1,Dilution!D19,Attenuation_satzone!D25)","v":0},"m/d",12,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"x",{"$f":"Attenuation_satzone!D26","v":0},"m",13,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"z",0,"m",14,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"y",0,"m",15,0,0.125,{"$f":"$F20/(2*$C$22)*(1-(1+(4*$C$10*$C$22)/$C$31)^0.5)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"t",{"$f":"Attenuation_satzone!D29","v":9.9999999999999997E+98},"days",16,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"ax",{"$f":"Attenuation_satzone!D32","v":{"$error":"#NUM!"}},"m",17,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"az",{"$f":"Attenuation_satzone!D33","v":{"$error":"#NUM!"}},"m",18,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"ay",{"$f":"Attenuation_satzone!D34","v":{"$error":"#NUM!"}},"m",19,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[null,"Bgd",{"$f":"Dilution!D22","v":0},null,20,0,0.125,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NUM!"},{"$error":"#DIV/0!"}]
[]
[null,"Calc","Value"]
[]
[null,"v",{"$f":"(C17*C16)/C15","v":{"$error":"#DIV/0!"}},"m/d"]
[null,"Rc",{"$f":"Attenuation_satzone!D39","v":{"$error":"#DIV/0!"}}]
[null,"u",{"$f":"C29/C30","v":{"$error":"#DIV/0!"}},"m/d"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Date:",{"$f":"Introduction!B30","v":"Enter date"}]
[null,"Version:",{"$f":"Introduction!E30","v":"x.xx"}]