{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["PLEASE READ License Disclaimers","RBKC Resi Lead Tool ","Basic User Guide","Technical Basis for KC 3L-4L"],"not_rendered":{"charts":6,"images":4,"macros":1,"external_links":1,"defined_names":52,"comments":1,"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":"PLEASE READ License Disclaimers","index":0,"n_rows":81,"n_cols":24,"rows_kept":81,"cut":false,"hidden":false,"merged":[[35,14,73,22],[2,2,2,4],[3,2,3,4],[7,2,7,5],[13,2,42,10],[2,14,32,21],[44,2,66,10],[68,2,68,10],[5,2,5,5],[9,7,11,10]]}
[]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$2","v":"RBKC Lead (Pb) Tool: Published v1.0"},null,null,{"$f":"'RBKC Resi Lead Tool '!$G$12&\" / \"&'RBKC Resi Lead Tool '!$I$12","v":"Published v1.0 / CJD"},null,null,null,null,null,null,null,null,"IMPORTANT. Remember who this Tool is intended for:\n- The Pb-Tool is designed for Experienced Risk Assessors who are already familiar with using Excel-based Tools\n- Risk assessor users must be familiar with the CLEA Approach & Lead-Pb Modelling\n- Risk assessor users are responsible for justifying their use of the Pb-Tool & CSM Inputs\n- Any modelling using the Pb-Tool is entirely the ‘work’ of the Risk Assessor\n- Pb-Tool Modelling Outputs are not a ‘risk assessment’ or a 'risk evaluation'\n- RBKC welcomes the use of the Pb-Tool as a CLEA teaching / learning tool\n\nTHE KC4L & KC3L VALUES HAVE BEEN GENERATED FOR USE IN RBKC.  THEY SHOULD NOT BE USED AS GENERIC ASSESSMENT CRITERIA OUTSIDE OF RBKC.\n\nSITE-SPECIFIC ACCEPTABILITY CRITERIA WOULD NORMALLY BE EXPECTED TO BE SUPPORTED BY SITE BIOAVAILABILITY TESTING.\n\nRISK ASSESSORS MAY WISH TO CONSIDER THE KC-4L & KC-3L CSMS AND USE THE PB-TOOL AS PART OF THEIR DQRA WORK OUTSIDE OF RBKC.  \n\nTHE RESPONSIBILITY FOR USE OF THE PB-TOOL AND ASSOCIATED CSMS RESTS ENTIRELY WITH THE USER.\n\n… and the PB-Tool user guide is not intended to be a CLEA manual ..."]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$3","v":"Resi+HGP/Resi-HGP: Residential with/without Home Grown Produce"},null,null,{"$f":"'RBKC Resi Lead Tool '!$H$12","v":"2026-03-05"}]
[]
[null,null,"License information, Legal Status and Disclaimers"]
[]
[null,null,"Contains public sector information licensed under the Open Government Licence v3.0"]
[]
[null,null,null,null,null,null,null,"Users will need to check the tickbox to the left to access the Pb-Tool Modelling Sheet/Tab.  This resets to unchecked on file exit. If the Pb-Tool is not visible when checked, then uncheck & recheck the tickbox.  Also please read the 'Known Issues' at the bottom right of this page. \nMacros must be enabled to access the Pb-Tool tab"]
[]
[]
[]
[null,null,"The RBKC approach and Tool for Lead (Pb) (collectively referred to as RBKC Pb Tool) and the RBKC KC4L’s and KC3L’s have been developed using the following guidance: \n1) Science Report SC050021/SR2: Human health toxicological assessment of contaminants in soil. \n2) Science Report SC050021/SR3: Updated technical background to the CLEA model. \n3) Science Report SC050021/SR4: CLEA Software (Version 1.05) Handbook. \n4) CLEA Software version 1.071\n5) Final Project Report /SP1010: Development of Category 4 Screening Levels for Assessment of Land Affected by Contamination (Revision 2).\n6) Final Project Report /SP1010: Appendix H Provision C4SLS for Lead.\nThe RBKC Pb Tool includes the excel spread sheet, inputs and outputs and any guidance provided within the corresponding excel spreadsheet.  \nThe RBKC KC4L’s and KC3L’s include the inputs and outputs included within the excel spread sheet, as justified by the input tables.\nThe RBKC Pb Tool and RBKC KC4L’s and KC3L’s can help suitably qualified assessors to estimate the risk that a child may be exposed to a soil concentration on a given site over a long period of exposure that may be a cause for concern to human health. The RBKC Pb Tool and RBKC KC4L’s and KC3L’s do not cover other types of risk to humans, such as fire, suffocation or explosion, or short-term and acute exposures. Nor do they cover risks to the environment or the pollution of water. The RBKC Pb Tool and RBKC KC4L’s and KC3L’s are non-statutory. They do not purport to interpret the policies or procedures of the Royal Borough of Kensington and Chelsea, Environment Agency or other regulators and shall not operate as a statutory licence, waiver, consent or approval from the Royal Borough of Kensington and Chelsea, Environment Agency or any other authority. Nothing in the RBKC Pb Tool or RBKC KC4L’s and KC3L’s shall prejudice, conflict with or affect the exercise by the Royal Borough of Kensington and Chelsea, Environment Agency or other regulators of their statutory functions, powers, rights, duties, responsibilities, obligations or discretions arising or imposed under the Environment Act 1995 or any other legislative provision enactment, bye-law or regulation. The RBKC Pb Tool and RBKC KC4L’s and KC3L’s describe the soil concentrations above which, in the opinion of Royal Borough of Kensington and Chelsea, there may be concern that warrants further investigation and risk evaluation for lead in soil within Kensington and Chelsea. This includes the RBKC KC4L’s Category 4 levels, below which a ‘low’ risk may be considered to exist and above which a ‘not low risk’ may be considered to exist up to the RBKC KC3L’s Category 3 levels. The RBKC KC3L’s Category 3 levels provide an initial screening level above which, and with further refinement, it should be questioned whether the land could be determined as contaminated land.  These levels are a guide to help assessors at RBKC estimate risk. It does not provide a definitive test for telling when risks are significant. No one is under any obligation to use the RBKC Pb Tool or Category 4 or 3 levels. Where the RBKC Pb Tool or Category 4 or 3 levels are used by non-RBKC personal, the assessor must satisfy themselves that the equations, inputs and assumptions used or any guidance offered as part of the RBKC Pb Tool or Category 4 or 3 levels fully apply to the situation it is to be used for.  RBKC commissioned Peak Environmental Solutions as developer to implement the RBKC Lead conceptual models within a lead modelling tool within current (as of end 2025) Excel and AECOM to develop the RBKC KC4L’s."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Commentary on the Excel Workbook and System Requirements\nThe Pb-Tool has been built in Excel-2021 on a Windows-11 Desktop PC. The Pb-Tool is recommended to be run in a modern/current version of MS Excel.   Although the xlsm format was introduced in Excel 2007, the Pb-Tool has not been not checked in Excel versions older than 2021 as Microsoft no longer supports pre-2021 Office versions.  Likewise, Windows users are assumed to be using up to date version of Windows 11, especially as MS Windows 10 support will be withdrawn shortly.  At this time, Online/Web/Browser-based versions of MS-365 cannot run .xlms files.  The Pb-Tool has had some limited testing in Excel on a current Mac/Apple machine and appeared to function as intended.\n\nSome users may need permission from their IT department to run macro enabled .xlsm files.   Although the Pb-Tool it is not a VBA driven worksheet, there are a limited number of macro driven 'form-control' buttons that reset users values back to defaults.  Although the Pb-Tool can be run without these macro-driven controls, it is not recommended as it will remove core Pb-Tool functionality.  The worksheets are protected to only allow only input cells/areas to be changed.\n\nThe current MS VBA/Macros do not appear to run in current versions (as of late 2025) open-source LibreOffice/Calc.  Although the core functionality of the Pb-Tool does seem to work in LibreOffice/Calc, the Pb-Tool is not recommended to be used in other spreadsheet software.  The Pb-Tool has not been tested in Google-Sheets.\n\nPrinting\nThe main Pb-Tool spreadsheet area is designed to be printed across two A3 PDF pages.\nIt is suggested that users Print using a pdf 'Printer'/writer (e.g. 'Microsoft Print to PDF') with the 'Page Size' suggested at A3. If necessary, users can use the 'Page Break Review' and the Page Marks text in cells to set the Printing View.  The main Pb-Tool area is designed to fit onto Two A3 Pages for Printing.\n\nKnown Issues\nThere is a well recognised Excel cell/font scaling issue when screen Zooming spreadsheets below 100%.  This relates to Excels approach to Font Size rounding when Zooming below 100%, whereby Excel may adopt a rounded scaled Font Size that is too big for the cell at that zoom level and cell text overspill is observed.  Users may find it best not to use Zoom levels below 85%.  Sometimes cell scrolling has been noticed to become unresponsive/locked/erratic at certain zoom levels under 90%; this is usually resolved by increasing zoom above 90%.\n\nAll User Input Cells have Data Validation requirements to prevent users inputting non-compliant values.  If users input a non-compliant value, be aware that Excel may sometimes create a cell link formula in the cell (e.g. '=C35'). Pressing 'Esc' will usually exit from the cell without the cell x-reference being used.\n\nBalancing 'Row Height' and 'Column Width has been a challenge in trying to keep the main Pb-Tool on single worksheet and printable onto two A3 Pages, whilst maintaining a reasonably visually pleasing & useable layout.  A necessary compromise has had to be made in some areas of the main spreadsheet.\n\nSometimes on re-opening a previously used/saved Worksheet, the License Disclaimer checkbox on this page may be checked but with the Pb-Tool not visible.  if this occurs, then unchecking & rechecking the tickbox should resolve the issue."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disclaimer: Use of Macro-Enabled Excel Workbook.\nWarning: This file contains macros. Macros are a series of commands used to automate tasks and may contain executable code. While these macros are designed to enhance the functionality of this workbook, they can pose a security risk by potentially introducing viruses or malicious software to your computer if they were tampered with. \n\nBefore proceeding, you must consider the following:\n1. Source Trust: You should only enable macros if you trust the source of this file. If you received this file from an unknown or unverified sender, do not enable the content.\n2. Enabling Macros: If you choose to enable macros, you do so at your own risk. Microsoft Office disables macros by default, and you must explicitly enable them to use the full functionality of this workbook.\n3. Security Risks: RBKC & Peak Environmental Solution Limited accepts no responsibility for any loss or damage, including but not limited to data loss, system corruption, or financial loss, that may result from enabling macros in this file. The user assumes all risks associated with enabling active content.\n4. Purpose of Macros: The macros in this workbook are solely intended to enhance workbook functionality by allowing re-setting of default values to aid user experience in the generation Lead (Pb) values in soil. Any other use of this file or its macros is unauthorised. \n5. By enabling macros and using this spreadsheet: you acknowledge and agree to the terms of this disclaimer.\n\nSelected Government and Microsoft Guidance on macros is provided here:\nhttps://www.ncsc.gov.uk/guidance/macro-security-for-microsoft-office\nhttps://support.microsoft.com/en-gb/office/enable-or-disable-macros-in-microsoft-365-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CAUTION ADVISED: Although this workbook is supplied with Excel Password Protection it may have been modified from the original download by third parties."]
[]
[]
[null,null,"QA Change Log / Version Table"]
[null,null,"Version","Date","Author","Change Type","QA Check Performed","QA Reviewer","Status","Notes"]
[null,null,"Various beta versions","2025/2026","CJD","Beta testing by RBKC & volunteers","Ongoing during beta","RT","Ongoing during beta","-"]
[null,null,"Published v1.0","2026-03-06","CJD","Initial Release","Full model validation and formula audit","RT","Approved","-"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T&C Check"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"RBKC Resi Lead Tool ","index":1,"n_rows":164,"n_cols":66,"rows_kept":164,"cut":false,"hidden":true,"merged":[[1,2,1,4],[156,2,157,4],[124,13,125,19],[126,13,126,19],[127,13,127,19],[128,13,128,19],[129,13,129,19],[130,13,130,19],[131,13,131,19],[133,13,133,19],[132,13,132,19],[130,2,130,3],[7,16,7,19],[8,14,8,15],[8,16,8,19],[9,14,9,15],[75,40,79,40],[86,40,90,40],[4,3,4,4],[137,6,137,7],[138,6,138,7],[136,6,136,7],[120,15,120,19],[129,5,131,10],[59,35,64,36],[65,35,65,36],[66,35,66,36],[67,35,67,36],[57,35,57,36],[58,35,58,36],[124,5,126,10],[127,5,127,10],[9,16,9,19],[10,16,10,19],[10,14,10,15],[136,13,138,19],[139,13,140,19],[12,16,12,19],[12,14,12,15],[141,13,142,19],[31,16,31,19],[30,16,30,18],[134,13,135,19],[25,15,25,16],[10,23,10,34],[4,23,4,34],[5,23,5,34],[6,23,6,34],[7,23,7,34],[8,23,8,34],[8,3,8,4],[2,2,2,4],[10,2,10,4],[5,14,5,15],[7,14,7,15],[11,2,11,4],[9,23,9,34],[11,14,11,15],[3,23,3,34],[11,23,11,34],[6,16,6,19],[4,16,4,19],[4,14,4,15],[3,16,3,19],[3,14,3,15],[5,16,5,19],[6,3,6,4],[5,3,5,4],[6,14,6,15],[7,3,7,4],[9,3,9,4],[123,5,123,7],[14,7,14,9],[15,7,15,9],[12,2,12,4],[123,13,123,15],[31,14,31,15],[26,14,26,16],[38,14,38,18],[45,14,45,19],[65,6,66,6],[14,10,15,10],[56,10,57,10],[57,6,57,9]]}
[]
[null,null,{"$f":"\"RBKC Lead (Pb) Tool: \"&$G$12","v":"RBKC Lead (Pb) Tool: Published v1.0"},null,null,null,null,null,null,null,null,null,null,"4a. MAIN CSM JUSTIFICATION AREA",null,null,null,null,null,null,null,null,null,"4b. CSM / MODELLING ADDITIONAL NOTES"]
[null,null,"Resi+HGP/Resi-HGP: Residential with/without Home Grown Produce",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROVIDE ANY ADDITIONAL CSM JUSTIFICATION, COMMENTARY, NOTES OR OBSERVATIONS HERE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13. SPREADSHEET NAMES, ACRONYMS, INITIALISMS & ABBREVIATIONS",null,null,null,null,null,"THIS AREA IS FOR REFERENCE AND DOES NOT PRINT",null,null,null,null,null,null,null,null,null,null,null,"NOT IN USE RIGHT OF THIS LINE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MODELLING COMPONENT","Adopted CSM Approach",null,"Provide Main Justification / Commentary / Notes "]
[null,null,"1. PROJECT DETAILS","Enter Relevant Project Information Below",null,null,null,null,null,null,null,null,null,"Tox Criteria",{"$f":"$D$21","v":"KC-4L / C4SL-LLTC"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"List of Excel 'Names' used in Spreadsheet",null,null,null,null,null,"List of Acronyms, Initialisms & Abbreviations"]
[null,null,"Site",null,null,null,null,null,null,null,null,null,null,"SP-CF'S",{"$f":"$D$22","v":"SPCF C4SL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel 'Names' are Sheet-Specific in 'Scope'",null,null,null,null,null,"Generally In Alphabetical Order (selected important ones first)",null,null,null,null,"Formulas Used"]
[null,null,"Project Reference",null,null,null,null,null,null,null,null,null,null,"Indoor / Outdoor SIR Values",{"$f":"$F$25","v":"C4SL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DustACTable","='RBKC Resi Lead Tool '!$AW$51:$BB$55",null,null,null,null,"RBKC","Royal Borough of Kensington & Chelsea",null,null,null,"IF"]
[null,null,"Risk Assessor",null,null,null,null,null,null,null,null,null,null,"% SOIL / SOIL-DUST",{"$f":"IF($D$26=50,\"Default C4SL/SR3\",\"Site-Specfic\")","v":"Default C4SL/SR3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DustArea","='RBKC Resi Lead Tool '!$D$78",null,null,null,null,"KC-4L / KC4L","RBKC Category 4 Level",null,null,null,"IFS"]
[null,null,"Checked / Approved",null,null,null,null,null,null,null,null,null,null,"RBA",{"$f":"IF($D$28=60,\"Default C4SL for Lead (Pb)\",\"Site-Specfic\")","v":"Default C4SL for Lead (Pb)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DustHC","='RBKC Resi Lead Tool '!$D$79",null,null,null,null,"KC-3L / KC3L","RBKC Category 3 Level",null,null,null,"IFERROR"]
[null,null,"Date & Revision",null,null,null,null,null,null,null,null,null,null,"INGESTION EF: IND/OUT",{"$f":"$D$40&\" & \"&$E$40","v":"KC-4L/C4SL & C4SL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DustRBA","='RBKC Resi Lead Tool '!$D$80",null,null,null,null,"C4SL","Category 4 Screening Value",null,null,null,"AND"]
[null,null,"Excel's Cell/Font scaling becomes problematic below c. 80% Zoom Level",null,null,null,null,null,null,null,null,null,null,"Advanced HGP & Dust Settings",{"$f":"$G$61&\" & \"&$G$64","v":"C4SL-EF/CSM & C4SL-CSM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwGv","='RBKC Resi Lead Tool '!$G$69",null,null,null,null,"HGP","Home Grown Produce",null,null,null,"SUM"]
[null,null,"Print using pdf writer with page size set to A3,  Use Page Break Review and Page Marks in cells to Set Printing View.  Intended to fit onto Two Main Pages.",null,null,null,"Published v1.0","2026-03-05","CJD","Version Log on 1st Tab",null,null,null,"GENERAL COMMENTS","n/a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwHf","='RBKC Resi Lead Tool '!$G$72",null,null,null,null,"+HGP / -HGP"," with HGP / without HGP",null,null,null,"SUMPRODUCT"]
[null,null,"Acronyms, Initialisms & Abbreviations' & 'Spreadsheet Names' defined in Area-13: scroll right",null,null,null,null,null,null,null,null,null,null,null,"These cells update automatically",null,"Further notes can be added to right",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwRv","='RBKC Resi Lead Tool '!$G$70",null,null,null,null,"CLEA","Contaminated Land Exposure Assessment",null,null,null,"XLOOKUP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwSf","='RBKC Resi Lead Tool '!$G$73",null,null,null,null,"Gveg","Green Vegetables",null,null,null,"&"]
[null,null,null,null,null,null," ","Bright Yellow cells: Main User Inputs",null,null,"Non Default Inputs",null,null,null,null,null,null,null,null,null,null,null,null,"8. SAC GRAPH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwTf","='RBKC Resi Lead Tool '!$G$74",null,null,null,null,"Rveg","Root Vegetables",null,null,null,"+  -  /  *"]
[null,null,"2. MAIN INPUT AREA",null,null,null,null,"Light Yellow cells: Advanced User Inputs",null,null,null,null,null,"5. PATHWAY OUTPUTS",null,null,"Outputs displayed as rounded integer values",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DwTv","='RBKC Resi Lead Tool '!$G$71",null,null,null,null,"Tveg","Tuber Vegetables"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrGv","='RBKC Resi Lead Tool '!$D$69",null,null,null,null,"Hfr","Herbaceous Fruit"]
[null,null,null,null,null,null,null,null,"Default Values (adopted shaded Pink)",null,null,null,null,"Soil & Soil-Dust Ingestion by AC","Indoor Soil-Dust Pathway","Outdoor Soil Pathway","Combined Check-sum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrHf","='RBKC Resi Lead Tool '!$D$72",null,null,null,null,"Sfr","Shrub Fruit"]
[null,null,"Adopted Toxicological & SPCF Frameworks",null,null,null,null,"KC-4L","KC-3L","C4SL",null,null,null,"AC-1",{"$f":"_xlfn.IFS(IndEF1=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI38)","v":529.92592592592598},{"$f":"_xlfn.IFS(OutEF1=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI45)","v":529.92592592592598},{"$f":"IFERROR(1/(IFERROR(1/O19,0)+IFERROR(1/P19,0)),\"CSM FAIL\")","v":264.96296296296299},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrRv","='RBKC Resi Lead Tool '!$D$70",null,null,null,null,"Tfr","Tree Fruit"]
[null,null,"Adopted Tox Criteria",1.4,"ug-Pb/kg-bw/day"," 1.4 or 2.1 only",null,1.4,2.1,1.4,null,null,null,"AC-2",{"$f":"_xlfn.IFS(D35=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI39)","v":457.33333333333343},{"$f":"_xlfn.IFS(E35=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI46)","v":457.33333333333343},228.66666666666671,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrSf","='RBKC Resi Lead Tool '!$D$73",null,null,null,null,"AC","Assessment Criteria"]
[null,null,"Adopted Tox Framework",{"$f":"_xlfn.IFS(D20=\"\", \"CSM FAIL\",D20=1.4,\"KC-4L / C4SL-LLTC\",TRUE,\"KC-3L\")","v":"KC-4L / C4SL-LLTC"},"-",null,null,"LLTC","KC-3L","LLTC",null,null,null,"AC-3",{"$f":"_xlfn.IFS(D36=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI40)","v":592.66666666666663},{"$f":"_xlfn.IFS(E36=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI47)","v":592.66666666666663},296.33333333333331,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrTf","='RBKC Resi Lead Tool '!$D$74",null,null,null,null,"AC-1","Age Class (number) [Example]"]
[null,null,"HGP Soil-to-Plant CF Approach","SPCF C4SL","See Rows 43-54 Below",null,null,"NK Av/Max","NK Av/Max","EA GM",null,null,null,"AC-4",{"$f":"_xlfn.IFS(D37=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI41)","v":704.66666666666663},{"$f":"_xlfn.IFS(E37=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI48)","v":704.66666666666663},352.33333333333331,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FrTv","='RBKC Resi Lead Tool '!$D$71",null,null,null,null,"ADE","Average Daily Exposure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-5",{"$f":"_xlfn.IFS(D38=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI42)","v":788.66666666666652},{"$f":"_xlfn.IFS(E38=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI49)","v":788.66666666666652},394.33333333333326,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tox","='RBKC Resi Lead Tool '!$D$20",null,null,null,null,"AT","Averaging Time"]
[null,null,"Soil/Soil-Dust Ingestion Rate (SIR) for AC1-6 & RBA",null,null,"Framework",null,"KC-4L","KC-3L","C4SL",null,null,null,"AC-6",{"$f":"_xlfn.IFS(D39=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI43)","v":919.33333333333337},{"$f":"_xlfn.IFS(E39=\"\",\"CSM FAIL\",SIRdustPer=0,\"-\",TRUE,AI50)","v":919.33333333333337},459.66666666666669,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HGPEF1","='RBKC Resi Lead Tool '!$D$60",null,null,null,null,"BW","Body Weight"]
[null,null,"Combined SIR",100,"mg/day",{"$f":"IF(SIRvalue=$H$25,\"KC-4L/3L\",IF(SIRvalue=$J$25,\"C4SL\",\"Site-Specfic\"))","v":"C4SL"},null,80,80,100,null,null,null,"Indoor/Outdoor Ingestion",{"$f":"IFERROR(1/(SUMPRODUCT(1/O19:O24)/6),\"-\")","v":629.21096540874021},{"$f":"IFERROR(1/(SUMPRODUCT(1/P19:P24)/6),\"-\")","v":629.21096540874021},{"$f":"IFERROR(1/(SUMPRODUCT(1/Q19:Q24)/6),\"CSM FAIL\")","v":314.6054827043701},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HGPEF2to6","='RBKC Resi Lead Tool '!$D$61:$D$65",null,null,null,null,"CSM","Conceptual Site Model"]
[null,null,"% Soil (Outdoors) in SIR",50,"0% to 100%",{"$f":"IF(SIRperc=$H$26,\"Default\",\"Site-Specfic\")","v":"Default"},null,50,50,50,null,null,null,"Combined Soil/Soil-Dust Ingestion Pathway",{"$f":"IF($AK$37=\"CSM FAIL\",$AK$37,IFERROR(1/(IFERROR(1/O25,0)+IFERROR(1/P25,0)),\"CSM FAIL\"))","v":314.6054827043701},"all in mg/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IndEF1","='RBKC Resi Lead Tool '!$D$34",null,null,null,null,"DAF","Dermal Absorption Factor"]
[null,null,"% Indoor Soil-Dust in SIR",{"$f":"IF(SIRperc=\"\",\"CSM FAILS\",100-SIRperc)","v":50},"% (remaining)",{"$f":"IF($D$27=$H$27,\"Default\",\"Site-Specfic\")","v":"Default"},null,50,50,50,null,null,null,"Ingestion Approach",{"$f":"AW113&IF(Tox=1.4,\" & Tox = 1.4 (LLTC)\", \" & Tox = 2.1 (KC-3L)\")&\" & RBA = \"&RBAperc&\" %\"","v":"C4SL & Tox = 1.4 (LLTC) & RBA = 60 %"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IndEF2to6","='RBKC Resi Lead Tool '!$D$35:$D$39",null,null,null,null,"DW","Dry Weight"]
[null,null,"RBA-Oral % for Pb",60,"0.1% to 100% (2SF)",{"$f":"IF(RBAperc=$H$28,\"Default\",\"Site-Specfic\")","v":"Default"},null,60,60,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OutEF1","='RBKC Resi Lead Tool '!$E$34",null,null,null,null,"EA","Environment Agency"]
[null,null,"RBA-Oral as-Fraction",{"$f":"IF(RBAperc=\"\",\"CSM FAIL\",RBAperc/100)","v":0.6},"as Fraction ",null,null,0.6,0.6,0.6,null,null,null,"Indoor Dust Pathway",{"$f":"IF(DustHC=\"\",\"CSMFAIL\",(IFERROR(_xlfn.XLOOKUP(DustHC,INDdustAREA,_xlfn.XLOOKUP(DustArea,siteAREAtable,INDdustTable))*(Tox/$I$79)*($H$81/DustRBA),\"CSM FAIL\")))","v":132429.33962123175},"mg/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OutEF2to6","='RBKC Resi Lead Tool '!$E$35:$E$39",null,null,null,null,"ED","Exposure Duration"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Outdoor Dust Pathway",{"$f":"IFERROR(_xlfn.XLOOKUP(DustHC,OUTdustAREA,_xlfn.XLOOKUP(DustArea,siteAREAtable,OUTdustTable))*(Tox/$I$79)*($H$81/DustRBA),\"CSM FAIL\")","v":173715649.1624873},"mg/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PfFruit","='RBKC Resi Lead Tool '!$F$72:$F$74",null,null,null,null,"EF","Exposure Frequency"]
[null,null,"Soil Ingestion Occupancy by AC","EF Indoors","EF Outdoors",null,null,null,null,null,null,null,null,"Combined Dust Pathways",{"$f":"IFERROR(1/SUMPRODUCT(1/O29:O30),\"CSM FAIL\")","v":132328.46114075833},"mg/kg",{"$f":"\"Modelled area = \"&DustArea&\" Ha & \"&DustHC*100&\"% cover\"","v":"Modelled area = 0.01 Ha & 75% cover"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PfGv","='RBKC Resi Lead Tool '!$F$69",null,null,null,null,"FW","Fresh Weight"]
[null,null,"Split Soil Ingestion rate",{"$f":"IFERROR(SIRvalue*(SIRdustPer/100)&\" mg/day\",\"CSM FAIL\")","v":"50 mg/day"},{"$f":"SIRvalue*(SIRperc/100)&\" mg/day\"","v":"50 mg/day"},null,"Indoor / Outdoor Default Values",null,null,"Body Weight",null,null,null,"Dust Approach",{"$f":"$G$64&IF(Tox=1.4,\" & Tox = 1.4 (LLTC)\", \" & Tox = 2.1 (KC-3L)\")","v":"C4SL-CSM & Tox = 1.4 (LLTC)"},null,"As minor Pathway, there is no accounting for areas <100m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PfRvTv","='RBKC Resi Lead Tool '!$F$70:$F$71",null,null,null,null,"HG-F","Home Grown Fraction"]
[null,null,"CLEA Age Class","days/year","days/year",null,"KC-4L","KC-3L","C4SL","kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print_Area","='RBKC Resi Lead Tool '!$A$1:$AO$158",null,null,null,null,"Ind/Out","Indoor / Outdoor"]
[null,null,"AC-1",180,180,null,"180 / 144","144 / 84","180 / 180",5.6,null,null,null,"Garden Size",">60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2","RBKC CSM",null,null,null,"9. SOIL & SOIL-DUST INGESTION PATHWAYS CALCULATION AREA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RBAperc","='RBKC Resi Lead Tool '!$D$28",null,null,null,null,"LLTC","Low Level of Toxicological Concern"]
[null,null,"AC-2",365,365,null,"365 / 292","292 / 170","365 / 365",9.8000000000000007,null,null,null,"HGP Consumption Fractions","100% of HG-F","75%  of HG-F","50% HG-F","25% of HG-F","12.5% of HG-F","% Adopted HG-F",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ResetCheck","='RBKC Resi Lead Tool '!$AV$118",null,null,null,null,"NorthKen / NK","North Kensington"]
[null,null,"AC-3",365,365,null,"365 / 292","292 / 170","365 / 365",12.7,null,null,null,"HGP Main Pathway",{"$f":"IFERROR($Y$79,\"CSM FAIL\")","v":566.49691273187932},{"$f":"IFERROR($O$36/0.75,\"CSM FAIL\")","v":755.32921697583913},{"$f":"IFERROR($O$36/0.5,\"CSM FAIL\")","v":1132.9938254637586},{"$f":"IFERROR($O$36/0.25,\"CSM FAIL\")","v":2265.9876509275173},{"$f":"IFERROR($O$36/0.125,\"CSM FAIL\")","v":4531.9753018550346},"mg/kg",null,null,null,"CLEA Age Class","BodyW","Tox Criteria",{"$f":"\"Ing Rates at: \"&SIRdustPer&\" / \"&SIRperc&\" Ind/Out % Split\"","v":"Ing Rates at: 50 / 50 Ind/Out % Split"},null,"Av Total Daily Intake","RBA","Allowable Uptake","by-AC EF",null,null,"by-AC SAC",null,"CSM CHECK",null,null,null,null,null,null,null,null,null,null,"SIRdustPer","='RBKC Resi Lead Tool '!$D$27",null,null,null,null,"P90","90th Percentile"]
[null,null,"AC-4",365,365,null,"365 / 292","292 / 170","365 / 365",15.1,null,null,null,"HGP Soil Attached Pathway\n(RBA Dependant)",{"$f":"IFERROR($AG$79,\"CSM FAIL\")","v":37766.866163965875},{"$f":"IFERROR($O$37/0.75,\"CSM FAIL\")","v":50355.821551954497},{"$f":"IFERROR($O$37/0.5,\"CSM FAIL\")","v":75533.73232793175},{"$f":"IFERROR($O$37/0.25,\"CSM FAIL\")","v":151067.4646558635},{"$f":"IFERROR($O$37/0.125,\"CSM FAIL\")","v":302134.929311727},"mg/kg",null,null,null,"Indoors","kg","mg-Pb/kg-bw/day","mg-soil/day","Kg-soil/day","mg-Pb/day","Fraction","mg-Pb/day","days/year","SIR Factor to 1 kg","Inverse Calcs","mg/kg",null,{"$f":"IF(COUNTIF(O19:P24,\"CSM FAIL\"),\"CSM FAIL\",\"PASS\")","v":"PASS"},null,null,null,null,null,null,null,null,null,null,"SIRperc","='RBKC Resi Lead Tool '!$D$26",null,null,null,null,"PF","Preparation Factor"]
[null,null,"AC-5",365,365,null,"365 / 292","292 / 170","365 / 365",16.899999999999999,null,null,null,"Combined RES+HGP SAC",{"$f":"IFERROR(1/(1/O36+1/O37),\"CSM FAIL\")","v":558.12512569371484},{"$f":"IFERROR(1/(1/P36+1/P37),\"CSM FAIL\")","v":744.16683425828649},{"$f":"IFERROR(1/(1/Q36+1/Q37),\"CSM FAIL\")","v":1116.2502513874297},{"$f":"IFERROR(1/(1/R36+1/R37),\"CSM FAIL\")","v":2232.5005027748593},{"$f":"IFERROR(1/(1/S36+1/S37),\"CSM FAIL\")","v":4465.0010055497187},"mg/kg",null,null,null,"AC-1",{"$f":"J34","v":5.6},{"$f":"Tox/1000","v":1.4E-3},{"$f":"SIRvalue*(SIRdustPer/100)","v":50},{"$f":"$AA38/1000000","v":5.0000000000000002E-5},{"$f":"IFERROR($AE38/$AD38,\"CSM FAIL\")","v":2.6496296296296299E-2},{"$f":"IF(OR(RBAperc/100<=0,RBAperc/100>1),\"CSM FAIL\",RBAperc/100)","v":0.6},{"$f":"(($Y38*$Z38)/($AF38/365))","v":1.5897777777777778E-2},{"$f":"IF(IndEF1=\"\",\"CSM FAIL\",IndEF1)","v":180},{"$f":"IFERROR(1/AB38,\"-\")","v":20000},{"$f":"IFERROR(1/AI38,\"-\")","v":1.8870561923399495E-3},{"$f":"IFERROR(AC38*AG38,\"-\")","v":529.92592592592598},null,null,null,null,null,null,null,null,null,null,null,null,"SIRvalue","='RBKC Resi Lead Tool '!$D$25",null,null,null,null,"RBA","Relative Bioavailability value"]
[null,null,"AC-6",365,365,null,"365 / 292","292 / 170","365 / 365",19.7,null,null,null,"CSM / SPCF / Tox Approach",{"$f":"$G$61&\" & \"&$D$22&IF(Tox=1.4,\" & Tox = 1.4 (LLTC)\", \" & Tox = 2.1 (KC-3L)\")","v":"C4SL-EF/CSM & SPCF C4SL & Tox = 1.4 (LLTC)"},null,null,null,null,null,null,null,null,"AC-2",9.8000000000000007,1.4E-3,{"$f":"SIRvalue*(SIRdustPer/100)","v":50},5.0000000000000002E-5,2.2866666666666671E-2,0.6,1.3720000000000001E-2,{"$f":"D35","v":365},20000,2.1865889212827985E-3,457.33333333333343,null,null,null,null,null,null,null,null,null,null,null,null,"SLhgp","='RBKC Resi Lead Tool '!$E$69:$E$74",null,null,null,null,"SAC","Site Assessment Criteria"]
[null,null,"Ind/Out EF Framework",{"$f":"IF(AND(D34:D39=AV101:AV106),\"KC-4L/C4SL\",IF(AND(D34:D39=AY101:AY106),\"KC-3L\",\"Site-Specfic\"))","v":"KC-4L/C4SL"},{"$f":"IF(AND($E$34:$E$39=$AW$101:$AW$106),\"KC-4L\",IF(AND(E34:E39=AZ101:AZ106),\"KC-3L\",IF(AND(E34:E39=BC101:BC106),\"C4SL\",\"Site-Specfic\")))","v":"C4SL"},null,null,"Model assumes ED = AT = 6 years",null,"Via C4SL",null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-3",12.7,1.4E-3,50,5.0000000000000002E-5,2.9633333333333331E-2,0.6,1.7779999999999997E-2,{"$f":"D36","v":365},20000,1.6872890888638922E-3,592.66666666666663,null,null,null,null,null,null,null,null,null,null,null,null,"SPCF","='RBKC Resi Lead Tool '!$D$22",null,null,null,null,"SIR","Soil Ingestion Rate"]
[null,null,"Combined Ingestion EF Framework",{"$f":"IF(AND(D40=\"KC-4L/C4SL\",E40=\"KC-4L\"),\"KC-4L\",IF(AND(D40=\"KC-4L/C4SL\",E40=\"C4SL\"),\"C4SL\",IF(AND(D40=\"KC-3L\",E40=\"KC-3L\"),\"KC-3L\",\"Site-Specific\")))","v":"C4SL"},null,null,null,null,null,"used sheetwide",null,null,null,"6. SAC OUTPUTS",null,null,null,null,null,null,null,null,null,"AC-4",15.1,1.4E-3,50,5.0000000000000002E-5,3.5233333333333332E-2,0.6,2.1139999999999999E-2,{"$f":"D37","v":365},20000,1.4191106906338694E-3,704.66666666666663,null,null,null,null,null,null,null,null,null,null,null,null,"SPCFlookup","='RBKC Resi Lead Tool '!$AW$68:$BA$78",null,null,null,null,"SL","Soil Loading"]
[null,null,null,null,"Advanced Users",null,"Advanced Users",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-5",16.899999999999999,1.4E-3,50,5.0000000000000002E-5,3.9433333333333327E-2,0.6,2.3659999999999997E-2,{"$f":"D38","v":365},20000,1.2679628064243451E-3,788.66666666666652,"Combined SAC",null,null,null,null,null,null,null,null,null,null,null,"SPCFssF","='RBKC Resi Lead Tool '!$G$50:$G$52",null,null,null,null,"Soil-Plant CF","Soil to Plant  Correction factor"]
[null,null,"HGP SPCF Framework","KC 4L/3L","Alternative RBKC","SPCF C4SL","Site SPCF",null,null,null,null,null,null,"SAC +HGP OUTPUTS",null,null,null,null,null,null,null,null,null,"AC-6",19.7,1.4E-3,50,5.0000000000000002E-5,4.596666666666667E-2,0.6,2.758E-2,{"$f":"D39","v":365},20000,1.0877447425670776E-3,919.33333333333337,{"$f":"IFERROR(1/(SUMPRODUCT(1/AI38:AI43)/6),\"-\")","v":629.21096540874021},"mg/kg",null,null,null,null,null,null,null,null,null,null,"SPCFssV","='RBKC Resi Lead Tool '!$G$47:$G$49",null,null,null,null,"SPCF / SP-CF","Soil to Plant  Correction factor"]
[null,null,"Soil Plant Correction Factors (SPCF)","SPCF Av/Max","SPCF Max","SPCF C4SL","Input Site SPCF",null,null,null,null,null,null,"Garden Size",">60","40-60","20-40","10-20","<10","m2",null,null,null,"Outdoors","kg","mg-Pb/kg-bw/day","mg-soil/day","Kg-soil/day","mg-Pb/day","Fraction","mg-Pb/day","days/year","SIR Factor to 1 kg","Inverse Calcs","mg/kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tox","Toxicological criteria used in modelling"]
[null,null,"Technical Basis","NorthKen Av/Max","NorthKen Max","C4SL & EA","Site-Specific",null,null,null,null,null,null,"Combined RES+HGP SAC",{"$f":"IFERROR(1/(1/$O$26+1/$O$31+1/O$36+1/O$37),\"CSM FAIL\")","v":200.8897800889246},{"$f":"IFERROR(1/(1/$O$26+1/$O$31+1/P$36+1/P$37),\"CSM FAIL\")","v":220.75416813016415},{"$f":"IFERROR(1/(1/$O$26+1/$O$31+1/Q$36+1/Q$37),\"CSM FAIL\")","v":244.97809830844261},{"$f":"IFERROR(1/(1/$O$26+1/$O$31+1/R$36+1/R$37),\"CSM FAIL\")","v":275.17361636446816},{"$f":"IFERROR(1/(1/$O$26+1/$O$31+1/S$36+1/S$37),\"CSM FAIL\")","v":293.24608382185045},"mg/kg",null,null,null,"AC-1",{"$f":"J34","v":5.6},{"$f":"Tox/1000","v":1.4E-3},{"$f":"SIRvalue*(SIRperc/100)","v":50},{"$f":"$AA45/1000000","v":5.0000000000000002E-5},{"$f":"IFERROR($AE45/$AD45,\"CSM FAIL\")","v":2.6496296296296299E-2},{"$f":"IF(OR(RBAperc/100<=0,RBAperc/100>1),\"CSM FAIL\",RBAperc/100)","v":0.6},{"$f":"(($Y45*$Z45)/($AF45/365))","v":1.5897777777777778E-2},{"$f":"OutEF1","v":180},{"$f":"IFERROR(1/AB45,\"-\")","v":20000},{"$f":"IFERROR(1/AI45,\"-\")","v":1.8870561923399495E-3},{"$f":"IFERROR(AC45*AG45,\"-\")","v":529.92592592592598}]
[null,null,"Adopted Modelled Values",{"$f":"IF($D$22=$AW$108,TRUE,\"-\")","v":"-"},{"$f":"IF($D$22=$AW$109,TRUE,\"-\")","v":"-"},{"$f":"IF($D$22=$AW$110,TRUE,\"-\")","v":true},{"$f":"IF($D$22=$AW$111,TRUE,\"-\")","v":"-"},null,null,null,null,null,null,"Summary CSM Approach",{"$f":"\"Ing = \"&$AW$113&\" & HGP \" &$O$39&\" & ingRBA = \"&RBAperc&\" %\"","v":"Ing = C4SL & HGP C4SL-EF/CSM & SPCF C4SL & Tox = 1.4 (LLTC) & ingRBA = 60 %"},null,null,null,null,null,null,null,null,"AC-2",9.8000000000000007,1.4E-3,50,5.0000000000000002E-5,2.2866666666666671E-2,0.6,1.3720000000000001E-2,{"$f":"E35","v":365},20000,2.1865889212827985E-3,457.33333333333343]
[null,null,"Green Veg",6.8999999999999997E-4,4.5999999999999999E-3,4.1900000000000001E-3,0.01,null,"Background Lead (Pb) Intake ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-3",12.7,1.4E-3,50,5.0000000000000002E-5,2.9633333333333331E-2,0.6,1.7779999999999997E-2,{"$f":"E36","v":365},20000,1.6872890888638922E-3,592.66666666666663,null,null,null,null,null,null,null,null,null,null,null,null,"14. DATABASE / LOOKUP / CHART CONTROLS ",null,null,null,null,null,"THIS AREA USED BY SPREADSHEET AND DOES NOT PRINT"]
[null,null,"Root Veg",5.2999999999999998E-4,1.1000000000000001E-3,4.0200000000000001E-3,0.01,null,"not Modelled under C4SL CSM",null,null,null,null,"SAC -HGP OUTPUT",null,null,null,null,null,null,null,null,null,"AC-4",15.1,1.4E-3,50,5.0000000000000002E-5,3.5233333333333332E-2,0.6,2.1139999999999999E-2,{"$f":"E37","v":365},20000,1.4191106906338694E-3,704.66666666666663]
[null,null,"Tuber Veg",3.4000000000000002E-4,3.4000000000000002E-4,7.3099999999999997E-3,0.01,null,"Dermal Contact not Modelled",null,null,null,null,"Combined RES-HGP SAC",{"$f":"IFERROR(1/(1/$O$26+1/$O$31),\"CSM FAIL\")","v":313.85929511788572},"mg/kg",null,null,null,null,null,null,null,"AC-5",16.899999999999999,1.4E-3,50,5.0000000000000002E-5,3.9433333333333327E-2,0.6,2.3659999999999997E-2,{"$f":"E38","v":365},20000,1.2679628064243451E-3,788.66666666666652,"Combined SAC",null,null,null,null,null,null,null,null,null,null,null,"Area m2",100,500,5000,20000,50000,100000,null,null,null,"Chart-1 Controls"]
[null,null,"Herb Fruit",3.3000000000000003E-5,3.3000000000000003E-5,7.4899999999999999E-4,1E-3,null,"As C4SL Pb DAF = 0",null,null,null,null,"Summary CSM Approach",{"$f":"\"Ing = \"&AW113&\" & \"&(IF(D20=1.4,\"Tox = 1.4 (LLTC)\",\"Tox = 2.1 (KC-3L)\"))&\" & ingRBA = \"&D28&\" %\"","v":"Ing = C4SL & Tox = 1.4 (LLTC) & ingRBA = 60 %"},null,null,null,null,null,null,null,null,"AC-6",19.7,1.4E-3,50,5.0000000000000002E-5,4.596666666666667E-2,0.6,2.758E-2,{"$f":"E39","v":365},20000,1.0877447425670776E-3,919.33333333333337,{"$f":"IFERROR(1/(SUMPRODUCT(1/AI45:AI50)/6),\"-\")","v":629.21096540874021},"mg/kg",null,null,null,null,null,null,null,null,null,null,"Area Hectares",0.01,0.05,0.5,2,5,10,null,null,null,"AC / Ages","AC mg/kg","Combined","Ages"]
[null,null,"Shrub Fruit",1.1E-4,1.1E-4,2.05E-4,1E-3,null,"Impossible values >1,000,000 mg/kg are",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INDOOR DUST PATHWAY LOOK UP VALUES AT Tox=1.4: DERIVED FROM BENCHMARKED CLEA",null,null,null,null,null,null,null,null,null,{"$f":"$N19&$BI51","v":"AC-1 (0-1)"},{"$f":"$Q$19","v":264.96296296296299},{"$f":"$O$26","v":314.6054827043701}," (0-1)"]
[null,null,"Tree Fruit",1.1E-4,1.1E-4,2.2900000000000001E-4,1E-3,null,"shown to allow benchmark compliance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H/VC",0.75,132429.33962123175,124509.50654976723,100474.34749996754,84132.879109609101,68270.422881174702,58103.818655364761,"Uses double Xlookup",null,null,"AC-2 (1-2)",{"$f":"$Q$20","v":228.66666666666671},{"$f":"$BH$51","v":314.6054827043701}," (1-2)"]
[null,null,"mg-pb/g FW produce per mg-pb/g DW soil","Average NK Value","All NK Max Values","EA GeoMean","Select Site Specific",null," with EA-CLEA 1.071",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H/VC",0,126097.11482780533,101505.63808527325,57023.05884855632,39573.482027581595,27535.970102190582,21474.01981036914,"Uses double Xlookup",null,null,"AC-3 (2-3)",{"$f":"$Q$21","v":296.33333333333331},{"$f":"$BH$51","v":314.6054827043701}," (2-3)"]
[null,null,null,"Max NK Value",null,"Via C4SL","User Unput",null,null,null,null,null,null,"7. ADE & BASELINE TABLES",null,null,null,null,null,null,null,null,null,"10. HGP PATHWAYS CALCULATION AREA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTDOOR DUST PATHWAY LOOK UP VALUES AT Tox=1.4: DERIVED FROM BENCHMARKED CLEA",null,null,null,null,null,null,null,null,null,"AC-4 (3-4)",{"$f":"Q22","v":352.33333333333331},{"$f":"$BH$51","v":314.6054827043701}," (3-4)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H/VC",0.75,173715649.1624873,36190760.242184848,8685782.4581243638,4921943.3929371405,3040023.860343528,2243827.1350154611,"Uses double Xlookup",null,null,"AC-5 (4-5)",{"$f":"$Q$23","v":394.33333333333326},{"$f":"$BH$51","v":314.6054827043701}," (4-5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SAC ADE by Pathway",">60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2","RES-HGP",null,null,null,null,null,null,null,null,null,"Top-2: P90","Mean","Top-2: P90","Mean","Mean","Mean",null,null,null,null,null,null,null,null,null,null,null,"H/VC",0,43428912.290621825,9047690.0605462119,2171445.6145310909,1230485.8482342851,760005.965085882,560956.78375386528,"Uses double Xlookup",null,null,"AC-6 (5-6)",{"$f":"$Q$24","v":459.66666666666669},{"$f":"$BH$51","v":314.6054827043701}," (5-6)"]
[null,null,"3. ADVANCED HGP/DUST INPUTS",null,null,null,"Advanced Users Only: ! Here be Dragons !",null,null,null,"Non Default Inputs",null,null,{"$f":"\"SAC Outputs @ \"&RBAperc&\"% oral-RBA\"","v":"SAC Outputs @ 60% oral-RBA"},{"$f":"$O$45","v":200.8897800889246},{"$f":"$P$45","v":220.75416813016415},{"$f":"$Q$45","v":244.97809830844261},{"$f":"$R$45","v":275.17361636446816},{"$f":"$S$45","v":293.24608382185045},{"$f":"$O$49","v":313.85929511788572},null,null,null,null,null,null,null,null,null,"Gveg","Rveg","Tveg","Hfr","Sfr","Tfr"]
[null,null,null,null,null,null,"Light Yellow cells are Advanced User Values",null,null,null,null,null,null,"All Pathways ADE","100% ADE","100% ADE","100% ADE","100% ADE","100% ADE","100% ADE",null,null,null,"Shared Pathway Calcs",null,null,null,"Without RBA","HG-Fraction",{"$f":"$D$69","v":0.05},{"$f":"$D$70","v":0.06},{"$f":"$D$71","v":0.02},{"$f":"$D$72","v":0.06},{"$f":"$D$73","v":0.09},{"$f":"$D$74","v":0.04},"Fraction",null,null,null,null,null,null,null,null,null,null,null,"Combined Pathway Values at Tox = 1.4 Shown for Benchmarking.  Not used in calcs.  These are calculated in Cell 'O31'",null,null,null,null,null,null,null,null,null,"Chart-2 Controls"]
[null,null,"HGP Consumption by AC","EF days/year","EF Default",null,null,null,null,null,null,null,null,"Ind Soil Dust Ing Pathway",{"$f":"IFERROR(O$57/$O$25,\"CSM FAIL\")","v":0.31927253517971521},0.35084284964226675,0.38934174986811138,0.43733124737537482,0.46605367665732839,0.498814089983318,null,null,null,"Age Class","bw kg","Tox Criteria","HGP-EF","Allowable Average Daily Uptake","Adopted SP-CF",{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$47,$C$47:$C$52,$D$47:$G$52))","v":4.1900000000000001E-3},{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$48,$C$47:$C$52,$D$47:$G$52))","v":4.0200000000000001E-3},{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$49,$C$47:$C$52,$D$47:$G$52))","v":7.3099999999999997E-3},{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$50,$C$47:$C$52,$D$47:$G$52))","v":7.4899999999999999E-4},{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$51,$C$47:$C$52,$D$47:$G$52))","v":2.05E-4},{"$f":"_xlfn.XLOOKUP(TRUE,$D$46:$G$46,_xlfn.XLOOKUP($C$52,$C$47:$C$52,$D$47:$G$52))","v":2.2900000000000001E-4},"mg/gFW per mg/gDW-soil",null,null,null,null,null,null,null,null,null,null,null,"Ind/Out  H/VC =0.75",132328.46114075833,124082.61677781925,99325.383301802736,82718.929149078816,66770.934668128466,56637.200494228426,"For Ref",null,null,"Garden HGP","SAC"]
[null,null,"AC-1",180,180,null,"Overall Advanced HGP Framework",null,null,null,null,null,null,"Out Soil Ing Pathway",{"$f":"IFERROR(O$57/$P$25,\"CSM FAIL\")","v":0.31927253517971521},0.35084284964226675,0.38934174986811138,0.43733124737537482,0.46605367665732839,0.498814089983318,null,null,null,"AC-1",{"$f":"$J34","v":5.6},{"$f":"Tox/1000","v":1.4E-3},{"$f":"$D60","v":180},{"$f":"($Y60*$Z60)/($AA60/365)","v":1.5897777777777778E-2},"AC-1 ConSum",7.12,5.22,16.03,0.89,1.07,1.87,"Total Produce Mean/P90 Consumption rates all via C4SL.  Note: the C4SL P90 rates differ from the SR3 P90 Total Produce Consumption Rates",null,null,null,null,null,null,null,null,null,null,null,"H/VC = 0.00",125732.04815499439,100379.48504379448,55563.927168004324,38340.421144146785,26573.19007030865,20682.280218310854,"For Ref",null,null,">60m2",{"$f":"$O$45","v":200.8897800889246}]
[null,null,"AC-2",365,365,null,{"$f":"IF(AND(AND($D$66=AV123),AND($D$75:$G$75=$AV$124:$AY$124)),\"C4SL-EF/CSM\",\"Site-Specfic\")","v":"C4SL-EF/CSM"},null,null,null,null,null,null,"HGP Main Pathway",{"$f":"IFERROR(O$57/O$36,\"CSM FAIL\")","v":0.35461760792331964},{"$f":"IFERROR(P$57/P$36,\"CSM FAIL\")","v":0.29226218603592752},{"$f":"IFERROR(Q$57/Q$36,\"CSM FAIL\")","v":0.21622191825111475},{"$f":"IFERROR(R$57/R$36,\"CSM FAIL\")","v":0.12143650308589886},{"$f":"IFERROR(S$57/S$36,\"CSM FAIL\")","v":6.4706019845655063E-2},"-",null,null,null,"AC-2",9.8000000000000007,1.4E-3,365,1.3720000000000001E-2,"AC-2 ConSum",5.87,1.61,6.6,1.93,0.26,5.84,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"40-60m2",{"$f":"$P$45","v":220.75416813016415}]
[null,null,"AC-3",365,365,null,null,null,null,null,null,null,null,"HGP Soil Attached Pathway",{"$f":"IFERROR(O$57/O$37,\"CSM FAIL\")","v":5.3192070323430114E-3},{"$f":"IFERROR(P$57/P$37,\"CSM FAIL\")","v":4.3838857420368284E-3},{"$f":"IFERROR(Q$57/Q$37,\"CSM FAIL\")","v":3.2432939662621666E-3},{"$f":"IFERROR(R$57/R$37,\"CSM FAIL\")","v":1.8215279973839663E-3},{"$f":"IFERROR(S$57/S$37,\"CSM FAIL\")","v":9.7057988127977914E-4},"-",null,null,null,"AC-3",12.7,1.4E-3,365,1.7779999999999997E-2,"AC-3 ConSum",5.87,1.61,6.6,1.93,0.26,5.84,null,null,null,null,null,null,null,null,null,null,null,null,"Reference VALUES FOR Tox=2.1: DERIVED VIA SCALING FACTOR (2.1/1.4).  This table not used in calcs.",null,null,null,null,null,null,null,null,null,"20-40m2",{"$f":"$Q$45","v":244.97809830844261}]
[null,null,"AC-4",365,365,null,"Overall DUST Model Framework",null,null,null,null,null,null,"Dust Pathways (Ind/Out)",{"$f":"IFERROR(O$57/$O$29,\"CSM FAIL\")","v":1.5169582561047289E-3},1.6669581586796021E-3,1.8498778217056553E-3,2.0778901197537267E-3,2.2143588774253447E-3,2.370013291734079E-3,null,null,null,"AC-4",15.1,1.4E-3,365,2.1139999999999999E-2,"AC-4 ConSum",5.87,1.61,6.6,1.93,0.26,5.84,null,null,null,null,null,null,null,null,null,null,null,null,"Ind RBA 0.1",846855,794167,635648,529449,427306,362512,"For Ref",null,null,"10-20m2",{"$f":"$R$45","v":275.17361636446816}]
[null,null,"AC-5",365,365,null,{"$f":"D83","v":"C4SL-CSM"},null,null,null,null,null,null,"Check-Sum ADE",{"$f":"SUM(O59:O63)","v":0.99999884357119784},0.9999987292211775,0.99999858977530542,0.99999841595378614,0.999998311919017,0.99999819325837003,null,null,null,"AC-5",16.899999999999999,1.4E-3,365,2.3659999999999997E-2,"AC-5 ConSum",4.53,1.2,4.95,1.25,0.11,2.89,null,null,null,null,null,null,null,null,null,null,null,null,"Out RBA 0.1",1111780154.6399186,231620865.54998302,55589007.731995925,31500437.714797698,19456152.706198577,14360493.664098952,"For Ref",null,null,"<10m2",{"$f":"$S$45","v":293.24608382185045}]
[null,null,"AC-6",365,365,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AC-6",19.7,1.4E-3,365,2.758E-2,"AC-6 ConSum",4.53,1.2,4.95,1.25,0.11,2.89,null,null,null,null,null,null,null,null,null,null,null,null,"Hardcover List",0.75,0,null,null,null,null,null,null,null,"No HGP",{"$f":"$O$49","v":313.85929511788572}]
[null,null,"HGP EF Framework",{"$f":"IF(AND($D$60:$D$65=$E$60:$E$65),\"C4SL-EF\",\"Site-Specfic\")","v":"C4SL-EF"},"C4SL (ED = AT)",null,"Consult SR3 Table 7.1",null,null,null,null,null,null,"BASELINE REFERENCE OUTPUTS (mg/kg)",null,null,null,null,null,null,null,null,null,null,null,"mg-Pb/kg-bw/day",null,"mg-Pb/day","Soil Loading (SL)",{"$f":"$E$69","v":1E-3},{"$f":"$E$70","v":1E-3},{"$f":"$E$71","v":1E-3},{"$f":"$E$72","v":1E-3},{"$f":"$E$73","v":1E-3},{"$f":"$E$74","v":1E-3},"g-soil/g-dw-HGP"]
[null,null,null,null,null,null,null,null,"Default Values",null,null,null,null,"@ 60% oral-RBA",">60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2","RES-HGP",null,null,null,null,null,null,null,null,"Prep Factor (PF)",{"$f":"PfGv","v":0.2},{"$f":"$F$70","v":1},{"$f":"$F$71","v":1},{"$f":"$F$72","v":0.6},{"$f":"$F$73","v":0.6},{"$f":"$F$74","v":0.6},"Dimensionless",null,null,null,null,null,null,null,null,null,null,null,"VALUES Provided for Benchmarking Reference only; not used in model calcs"]
[null,null,"Advanced HGP Parameters","HG Fraction","SL g-soil/g-DW","PF Fraction","DW g/g","HG-F","SL","PF","DW",null,null,"BASELINE KC-4L",395.15092785261089,404.52365195713799,414.351808516304,424.66941916084824,430.02333978674511,435.51398069209057,null,null,null,null,null,null,null,null,"DW Conversion",{"$f":"DwGv","v":9.6000000000000002E-2},{"$f":"DwRv","v":0.10299999999999999},{"$f":"DwTv","v":0.21},{"$f":"DwHf","v":5.8000000000000003E-2},{"$f":"DwSf","v":0.16600000000000001},{"$f":"DwTf","v":0.157},"g-dw / g-fw",null,null,null,null,null,null,null,null,null,null,null,"VALUES USED in HGP GRAPHS to LEFT",null,null,null,null,null,null,null,null,null,"Chart-4 Controls"]
[null,null,"Gveg",0.05,1E-3,0.2,9.6000000000000002E-2,0.05,1E-3,0.2,9.6000000000000002E-2,null,null,"BASELINE KC-3L",810.08860222186161,836.5801747863411,864.86298287208308,895.12505568432073,911.06439968794325,927.58169368299593,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main HGP Pathways","Tox=1.4","Values provided by benchmarked CLEA Modelling",null,null,null,null,null,null,null,"Area Hectares","Ind/Out at 75% H/VC","Ind/Out at 0% H/VC"]
[null,null,"Rveg",0.06,1E-3,1,0.10299999999999999,0.06,1E-3,1,0.10299999999999999,null,null,"BASELINE C4SL",201,221,245,275,293,314,null,null,null,"Main HGP Pathway",null,null,null,null,null,null,null,"Soil Attached (Indirect) HGP Pathway",null,null,null,null,null,null,"RBA",null,null,null,null,null,null,null,null,"HGP C4SL Fraction",1,0.75,0.5,0.25,0.125,"% of C4SL HGP Fractions",null,null,null,0.01,132328.46114075833,125732.04815499439]
[null,null,"Tveg",0.02,1E-3,1,0.21,0.02,1E-3,1,0.21,null,null,"@ 25% oral-RBA",">60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2","RES-HGP",null,null,null,"Age Class","Gveg","Rveg","Tveg","Hfr","Sfr","Tfr",null,"Age Class","Gveg","Rveg","Tveg","Hfr","Sfr","Tfr","Fraction",null,null,null,null,null,null,null,null,"Garden Size",">60","40-60","20-40","10-20","<10","m2",null,null,null,0.05,124082.61677781925,100379.48504379448]
[null,null,"Hfr",0.06,1E-3,0.6,5.8000000000000003E-2,0.06,1E-3,0.6,5.8000000000000003E-2,null,null,"KC-4L @ 25% RBA",847.29417958846352,888.53049868415712,933.98595413694136,984.34298613859505,1011.6142149894753,1040.4396009187024,null,null,null,"AC-1",{"$f":"1000*($AB60/(AD$59*AD$58*AD60*$Y60))","v":1903.1997592508169},2254.761385353635,1211.3440210382246,70978.255373929016,143803.09950555375,165733.88651477528,null,"AC-1",{"$f":"(1000*(($AB60/(AD$66*AD$67))/(AD60*$Y60*AD$58*AD$68)))/$AM72","v":692222.82910251059},146668.94448416852,70277.180903090659,2546106.9576184307,493300.45847788686,671497.87706800329,{"$f":"IF(OR(RBAperc/100<=0,RBAperc/100>1),\"CSM FAIL\",RBAperc/100)","v":0.6},null,null,null,null,null,null,null,null,"HGP NK Av/Max SPCF",4806.2,6408.3,9612.5,19225,38449.9,"mg/kg",null,null,null,0.5,99325.383301802736,55563.927168004324]
[null,null,"Sfr",0.09,1E-3,0.6,0.16600000000000001,0.09,1E-3,0.6,0.16600000000000001,null,null,"KC-3L @ 25% RBA",1671.6840341697125,1780.3628208071168,1904.1549011249185,2046.448429977157,2125.8797109642701,2211.7261148723937,null,null,null,"AC-2",1138.4288868198396,3605.1625928329363,1450.8974837292212,16141.268380869369,291849.07233687723,26170.963689657234,null,"AC-2",414063.97879992431,234510.57642699685,84175.084175084179,579013.88971605152,1001155.6196295155,106035.92860812999,0.6,null,null,null,null,null,null,null,null,"HGP NK Max SPCF",1052.2,1402.9,2104.3000000000002,4208.7,8417.4,"mg/kg",null,null,null,2,82718.929149078816,38340.421144146785]
[null,null,"Tfr",0.04,1E-3,0.6,0.157,0.04,1E-3,0.6,0.157,null,null,"C4SL @ 25% RBA",321.72604177627858,375.3517421735562,450.42997581496979,563.05225517836072,643.50036189793047,750.76919900463645,null,null,null,"AC-3",1138.4288868198394,3605.1625928329363,1450.897483729221,16141.268380869367,291849.07233687717,26170.96368965723,null,"AC-3",414063.97879992425,234510.57642699685,84175.084175084179,579013.88971605164,1001155.6196295152,106035.92860813001,0.6,null,null,null,null,null,null,null,null,"HGP EA Geomean SPCF",566.5,755.3,1133,2266,4532,"mg/kg",null,null,null,5,66770.934668128466,26573.19007030865]
[null,null,"HGP Framework",{"$f":"IF(AND($D$69:$D$74=$H$69:$H$74),\"C4SL-HG\",\"Site-Specfic\")","v":"C4SL-HG"},{"$f":"IF(AND($E$69:$E$74=$I$69:$I$74),\"C4SL-DW\",\"Site-Specfic\")","v":"C4SL-DW"},{"$f":"IF(AND($F$69:$F$74=$J$69:$J$74),\"C4SL-PF\",\"Site-Specfic\")","v":"C4SL-PF"},{"$f":"IF(AND($G$69:$G$74=$K$69:$K$74),\"C4SL-DW\",\"Site-Specfic\")","v":"C4SL-DW"},"C4SL","C4SL","C4SL","C4SL",null,null,"@ 90% oral-RBA",">60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2","RES-HGP",null,null,null,"AC-4",1138.4288868198396,3605.1625928329363,1450.8974837292212,16141.268380869367,291849.07233687723,26170.963689657234,null,"AC-4",414063.97879992431,234510.57642699685,84175.084175084179,579013.88971605164,1001155.6196295152,106035.92860812999,0.6,null,null,null,null,null,null,null,null,"HGP Soil Attached RBA 60%",37766.9,50355.8,75533.7,151067.5,302134.90000000002,"mg/kg",null,null,null,10,56637.200494228426,20682.280218310854]
[null,null,null,"Both HGP Pathways","Attached Only","Attached Only","Attached Only",null,null,null,null,null,null,"KC-4L @ 90% RBA",271.13438148008032,275.76599039353812,280.55858675880091,285.52071253489538,288.06818503025738,290.66152487416252,null,null,null,"AC-5",1475.182685570079,4836.9264787175225,1934.5299783056278,24922.118380062304,689825.08006898256,52885.269186020152,null,"AC-5",536546.48025508958,314635.02337288746,112233.4455667789,893997.44572158367,2366367.8282152181,214273.29518044263,0.6,null,"Page-1 Right Side"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"KC-3L @ 90% RBA",561.86844518388068,575.21534595514083,589.21177366663665,603.9063246320535,611.53192500236355,619.3525669986783,null,null,null,"AC-6",1475.182685570079,4836.9264787175234,1934.529978305628,24922.118380062308,689825.08006898267,52885.269186020159,null,"AC-6",536546.48025508958,314635.02337288752,112233.4455667789,893997.44572158367,2366367.8282152181,214273.29518044263,0.6,null,null,null,null,null,null,null,null,"Main HGP Pathway","Tox=2.1","Values provided by benchmarked CLEA Modelling"]
[null,null,"Advanced Dust Pathway Options","Adopted Value","Framework ",null,null,"Default","Default Tox",null,null,null,null,"C4SL @ 90% RBA",151.96700435929736,163.15346448640165,176.12130918494719,191.32644403115214,199.95795955282816,209.40507596690821,null,null,null,"By-HGP AC",{"$f":"IFERROR(1/((SUMPRODUCT(1/Y$72:Y$77))/6),\"CSM FAIL\")","v":1328.4899777812652},{"$f":"IFERROR(1/((SUMPRODUCT(1/Z$72:Z$77))/6),\"CSM FAIL\")","v":3552.1210507243582},{"$f":"IFERROR(1/((SUMPRODUCT(1/AA$72:AA$77))/6),\"CSM FAIL\")","v":1527.8613591693195},{"$f":"IFERROR(1/((SUMPRODUCT(1/AB$72:AB$77))/6),\"CSM FAIL\")","v":21413.442684647303},{"$f":"IFERROR(1/((SUMPRODUCT(1/AC$72:AC$77))/6),\"CSM FAIL\")","v":298025.21841574233},{"$f":"IFERROR(1/((SUMPRODUCT(1/AD$72:AD$77))/6),\"CSM FAIL\")","v":37859.107713433863},null,"By-HGP AC",{"$f":"IFERROR(1/((SUMPRODUCT(1/AG$72:AG$77))/6),\"CSM FAIL\")","v":483192.10129370674},{"$f":"IFERROR(1/((SUMPRODUCT(1/AH$72:AH$77))/6),\"CSM FAIL\")","v":231060.30135779807},{"$f":"IFERROR(1/((SUMPRODUCT(1/AI$72:AI$77))/6),\"CSM FAIL\")","v":88640.210599426398},{"$f":"IFERROR(1/((SUMPRODUCT(1/AJ$72:AJ$77))/6),\"CSM FAIL\")","v":768135.4679502314},{"$f":"IFERROR(1/((SUMPRODUCT(1/AK$72:AK$77))/6),\"CSM FAIL\")","v":1022342.1983806421},{"$f":"IFERROR(1/((SUMPRODUCT(1/AL$72:AL$77))/6),\"CSM FAIL\")","v":153392.35078514431},"n/a",null,null,null,null,null,null,null,null,"HGP NK Av/Max SPCF",7209.4,9612.5,14418.7,28837.4,57674.9,"mg/kg"]
[null,null,"Dust Model Area (Hectares)",0.01,{"$f":"IF($D$79=$H$79,\"Default\",\"Site-Specfic\")","v":"Default"},"Six Options",null,0.01,1.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main HGP AC",{"$f":"IFERROR(1/((SUMPRODUCT(1/$Y$78:$AD$78))),\"CSM FAIL\")","v":566.49691273187932},"All mg/kg",null,null,null,null,null,"Attach HGP AC",{"$f":"IFERROR(1/((SUMPRODUCT(1/$AG$78:$AL$78))),\"CSM FAIL\")","v":37766.866163965875},"All mg/kg",null,null,null,null,"RBA Ratio to default @0.6",null,null,null,null,null,null,null,null,"HGP NK Max SPCF",1578.3,2104.3000000000002,3156.5,6313,12626.1,"mg/kg"]
[null,null,"Hard/Veg Cover Fraction (H/VC)",0.75,{"$f":"IF($D$80=$H$80,\"Default 0.75 H/VC\",\"No Hard/Veg Cover\")","v":"Default 0.75 H/VC"},"Two Options",null,0.75,null,null,null,null,null,null,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":"$J$28/$D$28","v":1},null,null,null,null,null,null,null,null,"HGP EA Geomean SPCF",849.7,1133,1699.5,3399,6798,"mg/kg"]
[null,null,"Dust Inhalation Pb RBA %",64,{"$f":"IF($D$81=$H$81,\"Default\",\"Site-Specific\")","v":"Default"},"1% to 100%",null,64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%ADE",{"$f":"IFERROR($Y$79/Y$78,\"CSM FAIL\")","v":0.42642166836515838},{"$f":"IFERROR($Y$79/Z$78,\"CSM FAIL\")","v":0.1594813083907593},0.37077769480332767,2.645520017843922E-2,1.900835492188522E-3,1.496329277012687E-2,null,"%ADE",{"$f":"IFERROR($AG$79/AG$78,\"CSM FAIL\")","v":7.8161182814967853E-2},{"$f":"IFERROR($AG$79/AH$78,\"CSM FAIL\")","v":0.16345025927012743},0.42606922872327052,4.9166934401228359E-2,3.6941511583682453E-2,0.24621088320672316,null,null,null,null,null,null,null,null,null,"HGP Soil Attached RBA 60%",56650.3,75533.7,113300.6,226601,453202,"mg/kg"]
[null,null,"RBA-Inhalation as-Fraction",{"$f":"DustRBA/100","v":0.64},"as Fraction ",null,null,0.64]
[null,null,null,{"$f":"IF(AND($D$79:$D$81=$H$79:$H$81),\"C4SL-CSM\",\"Site-Specfic\")","v":"C4SL-CSM"},null,null,null,"C4SL"]
[null,null,"Page-1 Bottom",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page-1 Bottom"]
[null,null,"Page-2 Top",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page-2 Top"]
[]
[null,null,"11. OPTIONAL - ADDITIONAL GRAPHS / INFORMATION AREA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12. OPTIONAL - USER WORKSPACE FOR FURTHER INFORMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page-2 Right Side",null,null,null,null,null,null,"15. OTHER WORKSHEET CONTROLS AREA",null,null,null,null,null,null,"THIS AREA USED BY SPREADSHEET AND DOES NOT PRINT",null,null,null,null,null,null,null,null,null,null,"NOT IN USE RIGHT OF THIS LINE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,"KC-4L Defaults",null,2.1,"KC-3L Defaults",null,1.4,"C4SL Defaults"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NK Av/Max SPCF",null,null,"NK Av/Max SPCF",null,null,"EA GM SPCF"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,null,null,80,null,null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,50,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"100-AV94","v":50},null,null,{"$f":"100-AY94","v":50},null,null,{"$f":"100-BB94","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,60,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AV96/100","v":0.6},null,null,{"$f":"AY96/100","v":0.6},null,null,{"$f":"BB96/100","v":0.6}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EF Indoors","EF Outdoors",null,"EF Indoors","EF Outdoors",null,"EF Indoors","EF Outdoors"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"days/year","days/year",null,"days/year","days/year",null,"days/year","days/year"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,144,null,144,84,null,180,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,292,null,292,170,null,365,365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,292,null,292,170,null,365,365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,292,null,292,170,null,365,365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,292,null,292,170,null,365,365]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,365,292,null,292,170,null,365,365]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HGP Soil-to-Plant CF Approach List","SPCF Av/Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPCF Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SPCF C4SL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site-Specific"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ingest Approach",{"$f":"IF(AND(D41=\"KC-4L\",F25=\"KC-4L/3L\"),\"KC-4L\",IF(AND(D41=\"KC-3L\",F25=\"KC-4L/3L\"),\"KC-3L\",IF(AND(D41=\"C4SL\",F25=\"C4SL\"),\"C4SL\",\"Site-Specfic\")))","v":"C4SL"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tox",1.4,"KC-4L & C4SL LLTC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,"KC-3L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ug-Pb/kg-bw/day"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reset CheckBoxCheck"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,"REFERENCE EXTRACTS",null,null,"ADDITIONAL GUIDANCE FOR REPLICATING KC 4L/3L & CRITERIA IN EA-CLEA 1.071",null,null,null,null,null,null,null,null,null,"This area is for Advanced Users and assumes a detailed understanding of the CLEA approach combined with a high level of CLEA 1.071 modelling experience.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linked Cell"]
[]
[null,null,null,null,null,"SHORTER METHOD FOR REPLICATING PB-TOOL CRITERIA IN EA-CLEA 1.071",null,null,null,null,null,null,null,"LONGER METHOD FOR REPLICATING ANY PB-TOOL CRITERIA IN EA-CLEA 1.071",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C4SL-EF"]
[null,null,null,null,null,"light Yellow cells are Advanced User Inputs",null,null,null,null,null,null,null,"light Yellow cells are Advanced User Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C4SL-HG","C4SL-DW","C4SL-PF","C4SL-DW"]
[null,null,null,null,null,"KC-4L.  In EA-CLEA set up the pathways in line with the KC-4L CSM.  For The Soil/Dust Ingestion Pathway, then use the Default C4SL EFs for AC-1-6 and input an adjusted AC1-6 SIR of 72.0 mg/day.  Please refer back to the AECOM KC-4L Methodology. ",null,null,null,null,null,null,null,"With split soil/soil-dust pathways it is also possible to calculate/benchmark the RBKC/Site-Specific criteria in EA-CLEA using the following Staged modelling process for non-identical soil/soil-dust EF CSMs; this avoids the SIR adjustment approach described on the left."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Set up EA CLEA with only the soil/dust ingestion pathway 'Active' in SSAC EA-CLEA Step-2."]
[null,null,null,null,null,"KC-3L. As above using the KC-3L CSM & an adjusted AC1-6 SIR of 50.64 mg/day",null,null,null,null,null,null,null,"2. Input the Indoor soil-dust ingestion CSM (EA CLEA Step-4 Advanced Settings), run model & record the pathway-AC at EA CLEA Step-5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT IN USE RIGHT OF THIS LINE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Repeat for the Outdoor soil ingestion CSM and record the pathway-AC."]
[null,null,null,null,null,"Other Criteria:  For CSMs where the Indoor / Outdoor ingestion EFs have been adjusted using a set AC1-6 %decrease based on the default CLEA/C4SL EFs, then the tool below can be used to calculate the adjusted SIR value to be used in EA- CLEA with the default CLEA/C4SL Ingestion EFs.",null,null,null,null,null,null,null,"6. Set up EA CLEA with only two Dust Inhalation pathways 'Active' in EA-CLEA Step-2."]
[null,null,"© Aecom Limited 2025.  Reproduced with permission.",null,null,null,null,null,null,null,null,null,null,"7. Input the Dust Inhalation pathway CSMs, run the model and record the combined two pathway-AC."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5. Input the HGP pathways CSMs (at >60m2), run the model and record the combined two pathway-AC."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: It is suggested to record the AC to at least 6 SF to get accurate benchmarking."]
[null,null,null,null,null,null,"TOOL FOR SIR CALCULATION FOR USE IN EA-CLEA",null,null,null,null,null,null,"6a. EITHER: use the 'SAC Calculator' tool below to generate the Final Combined SACs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6b. OR: manually calculate the Final Combined-SAC(s) using the recorded ACs and the standard CLEA pathway reciprocal approach.  Note: For HGP pathways outputs for garden areas <60m2, simply divide the >60m2 HGP output by the relevant %HG-F (0.75, 0.5, 0.25, 0.125); there is no need to run these smaller garden CSMs separately in EA-CLEA as they are simply prorata values of the >60m2 HGP output."]
[null,null,null,null,null,null,"Soil/Soil-Dust Ingestion"]
[null,null,null,null,null,null,"Global SIR",null,80,"mg/day",null,null,null,"Note-1: CSMs with Identical soil/soil-dust EFs CSMs can be run in EA-CLEA using a single Soil Ingestion pathway (along with other pathways) in the normal way.  For these identical EF CSMs, the SIR %-split becomes irrelevant as the combined result of the two pathways will always be the same, even if you change the %SIR split."]
[null,null,null,null,null,null,"% SIR Outdoors",null,50,"0% to 100%"]
[null,null,null,null,null,null,"% SIR Indoor",null,{"$f":"IF(I138=\"\",\"CSMFAIL\",100-$I$138)","v":50},"% (Indoor)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note-2: This Staged EA-CLEA approach removes the need to amend the SIR rate to get CLEA to work with the default ingestion AC-1@180 and AC2-6@/366"]
[null,null,null,null,null,null,null,null,"EF Indoors","EF Outdoors"]
[null,null,null,null,null,null,null," % Reduction from CLEA EF",0.2,0.53400000000000003,null,null,null,"Note-3: The Staged EA-CLEA approach also allows users to benchmark Pb-Tool criteria that have used with different %SIR split when dealing with non-identical EF soil/dust CSMs (i.e. it uses two sub-pathway CSMs, each with an independent soil ingestion rate)."]
[null,null,null,null,null,null,null,"KC-4L Reference at 50/50",0,0.2]
[null,null,null,null,null,null,null,"KC-3L Reference at 50/50",0.2,0.53400000000000003]
[null,null,null,null,null,null,null,"Effective Global Reduction",{"$f":"IFERROR($I$142*($I$139/100)+$J$142*($I$138/100),\"CSM FAIL\")","v":0.36699999999999999},null,null,null,null,"EA-CLEA COMBINED SAC CALCULATOR"]
[null,null,null,null,null,null,null,"Effective SIR in EA CLEA",{"$f":"IFERROR((1-$I$145)*$I$137,\"CSM FAIL\")","v":50.64},"Use this In EA CLEA"]
[null,null,null,null,null,null,null,"SIR Split",{"$f":"$I$139&\"%\"","v":"50%"},{"$f":"$I$138&\"%\"","v":"50%"},{"$f":"IFERROR($I$147+$J$147,\"CSM FAIL\")","v":1},null,null,"Pathways","EA-CLEA ACs"]
[null,null,null,null,null,null,null,"SIR Rate mg/day",{"$f":"IFERROR($I$137*$I$139/100,\"CSM FAIL\")","v":40},{"$f":"$I$137*($I$138/100)","v":40},{"$f":"IFERROR($I$148+$J$148,\"CSM FAIL\")","v":80},null,null,"Ind Soil-Dust Ing",787]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Out Soil Ing",983,{"$f":"IFERROR(1/(IFERROR(1/O148,0)+IFERROR(1/O149,0)),\"\")","v":437.07401129943503}]
[null,null,null,null,null,null,null,null,"Use in RBKC Pb Tool",null,null,null,null,"Dust Inh In/Out",132328.46,"40-60 m2","20-40 m2","10-20 m2","<10 m2"]
[null,null,null,null,null,null,null,"CLEA/C4SL","EF Indoors","EF Outdoors",null,null,null,"HGP >60m2",4264,{"$f":"$O$151/0.75","v":5685.333333333333},{"$f":"$O$151/0.5","v":8528},{"$f":"$O$151/0.25","v":17056},{"$f":"$O$151/0.125","v":34112}]
[null,null,null,null,null,null,"Age Class","days/year","days/year","days/year",null,null,null,"Final Criteria",">40-60 m2","40-60 m2","20-40 m2","10-20 m2","<10 m2"]
[null,null,null,null,null,null,"AC-1",180,{"$f":"$H153*(1-$I$142)","v":144},{"$f":"$H153*(1-$J$142)","v":83.88},null,null,null,"Final Res -HGP",{"$f":"IFERROR(1/(SUMPRODUCT(1/(O148:O151))),\"CSM FAIL\")","v":395.25370531710644},{"$f":"IFERROR(1/(1/P151+SUMPRODUCT(1/($O$148:$O$150))),\"CSM FAIL\")","v":404.6305656812043},{"$f":"IFERROR(1/(1/Q151+SUMPRODUCT(1/($O$148:$O$150))),\"CSM FAIL\")","v":414.46314403635449},{"$f":"IFERROR(1/(1/R151+SUMPRODUCT(1/($O$148:$O$150))),\"CSM FAIL\")","v":424.78548981795461},{"$f":"IFERROR(1/(1/S151+SUMPRODUCT(1/($O$148:$O$150))),\"CSM FAIL\")","v":430.14190515188909}]
[null,null,null,null,null,null,"AC-2",365,292,170.08999999999997,null,null,null,"Final Res +HGP",{"$f":"IFERROR(1/(SUMPRODUCT(1/($O$148:$O$150))),\"CSM FAIL\")","v":435.63513115048676}]
[null,null,null,null,null,null,"AC-3",365,292,170.08999999999997,null,null,null,"%ADE","Res+HGP>60m3","Res-HGP"]
[null,null,null,null,null,null,"AC-4",365,292,170.08999999999997,null,null,null,"Ind Soil-Dust Ing",{"$f":"$O$153/$O148","v":0.50222834220725088},{"$f":"$O$154/$O148","v":0.55353892141103778}]
[null,null,"U.S. Environmental Protection Agency (EPA). (2017) Update for Chapter 5 of the Exposure Factors Handbook 2011 Edition. National Center for Environmental Assessment, Washington, DC; EPA/600/R-17/384F  Available from the National Technical Information Service, Springfield, VA, and online at http://www.epa.gov/ncea/efh. ",null,null,null,"AC-5",365,292,170.08999999999997,null,null,null,"Out Soil Ing",{"$f":"$O$153/$O149","v":0.40208922209268205},{"$f":"$O$154/$O149","v":0.44316900422226524}]
[null,null,null,null,null,null,"AC-6",365,292,170.08999999999997,null,null,null,"Dust Inh In/Out",2.9869138151921849E-3,3.2920743666969808E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HGP >60m2",9.2695521884874871E-2,"n/a"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page-2 Bottom"]
[]
[]
[]
[null,null,"NOT IN USE BELOW THIS LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT IN USE BELOW THIS LINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOT IN USE BELOW THIS LINE"]

{"sheet":"Basic User Guide","index":2,"n_rows":85,"n_cols":14,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,13,32,20],[2,2,2,4],[3,2,3,4],[5,2,5,5],[34,13,72,21]]}
[]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$2","v":"RBKC Lead (Pb) Tool: Published v1.0"},null,null,{"$f":"'RBKC Resi Lead Tool '!G12&\" / \"&'RBKC Resi Lead Tool '!$I$12","v":"Published v1.0 / CJD"},null,null,null,null,null,null,null,"IMPORTANT. Remember who this Tool is intended for:\n- The Pb-Tool is designed for Experienced Risk Assessors who are already familar with using Excel-based Tools\n- Risk assessor users must be familiar with the CLEA Approach & Lead-Pb Modelling\n- Risk assessor users are responsible for justifying their use of the Pb-Tool & CSM Inputs\n- Any modelling using the Pb-Tool is entirely the ‘work’ of the Risk Assessor\n- Pb-Tool Modelling Outputs are not a ‘risk assessment’ or a 'risk evaluation'\n- RBKC welcomes the use of the Pb-Tool as a CLEA teaching / learning tool\n\nTHE KC4L & KC3L VALUES HAVE BEEN GENERATED FOR USE IN RBKC. THEY SHOULD NOT BE USED AS GENERIC ASSESSMENT CRITERIA OUTSIDE OF RBKC.\n\nSITE-SPECIFIC ACCEPTABILITY CRITERIA WOULD NORMALLY BE EXPECTED TO BE SUPPORTED BY SITE BIOAVAILABILITY TESTING.\n\nRISK ASSESSORS MAY WISH TO CONSIDER THE KC-4L & KC-3L CSMS AND USE THE PB-TOOL AS PART OF THEIR DQRA WORK OUTSIDE OF RBKC.  \n\nTHE RESPONSIBILITY FOR USE OF THE PB-TOOL AND ASSOCIATED CSMS RESTS ENTIRELY WITH THE USER.\n\n… and the PB-Tool user guide is not intended to be a CLEA manual ..."]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$3","v":"Resi+HGP/Resi-HGP: Residential with/without Home Grown Produce"},null,null,{"$f":"'RBKC Resi Lead Tool '!$H$12","v":"2026-03-05"}]
[]
[null,null,"Basic User Guide.  This is not a CLEA manual"]
[]
[]
[]
[null,null,"Preambles"]
[null,null,"All readers must read and familiarise themselves with the information provided in the sheets detailing the 'License & Disclaimers' and the 'Technical Basis' for the KC-L3/L4."]
[null,null,"Users will need to check the box on the 'License & Disclaimers' Tab to access the Pb-Tool Modelling Sheet/Tab"]
[null,null,"The main Pb-Tool worksheet is arranged into 15 Worksheet Areas and the User Guide provides a basic workflow and information for these 15 areas."]
[null,null,"The inputs required (and information provided) in each of the areas should be familiar to a suitably experienced human heath assessor and detailed explanation should not be necessary.  "]
[null,null,"Please refer to 'Who is this tool for' on the right hand side of this sheet."]
[]
[null,null,"Three Baseline Starting CSMs (C4SL, KC-4L & KC-3L) are provided for Residential with/without Home Grown Produce (Resi+HGP/Resi-HGP) using a C4SL AC-1-6 Receptor."]
[null,null,"The model then allows the User a high level of flexibility to generate their own CSMs."]
[null,null,"The model provides the calculations on a first principles basis for the soil/soil-dust ingestion pathways and the HGP pathways."]
[null,null,"The Pb-Tool has split the main ingestion pathway into outdoor soil ingestion and indoor soil/soil-dust ingestion, with separate ingestion rates and exposure frequencies."]
[null,null,"For indoor/outdoor dust inhalation, a look-up table approach has been adopted (as these are minor pathways for Lead-Pb) using selectable CSM options & values generated by CLEA-1.071. "]
[null,null,"Dermal Contact is not modelled by the Pb-Tool as under C4SL the lead-Pb DAF is zero."]
[]
[null,null,"Colour Coding: Yellow Shaded Cells are User Inputs.  These typically turn into Red Shading if the Inputs are outside of (C4SL, KC-4L, KC-3L) defaults."]
[null,null,"Other Cell Interlock: many Cells update automatically to Inform Users of the Adopted CSM Framework for that parameter (or set of parameters)."]
[null,null,"User Inputs have cell data validation controls to ensure only viable values are adopted."]
[null,null,"Where inputs are not compatible, the spreadsheet will report 'CSM-FAIL' in relevant cells/outputs."]
[null,null,"The spreadsheet uses minimal VBA/macros, with the Pb-Tool calculations all undertaken using standard/typical Excel functions/approaches (ie. without VBA/macros)."]
[null,null,"The limit of the working area of the Pb-Tool is marked by the horizontal and vertical Black Lines."]
[]
[null,null,"The PB-Tool also provides two approaches for benchmarking outputs with CLEA 1.071."]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!C5","v":"1. PROJECT DETAILS"}]
[null,null,"Relevant site/project details can be entered here."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Commentary on the Excel Workbook and System Requirements\nThe Pb-Tool has been built in Excel-2021 on a Windows-11 Desktop PC.  The Pb-Tool is recommended to be run in a modern/current version of MS Excel.   Although the xlsm format was introduced in Excel 2007, the Pb-Tool has not been not checked in Excel versions older than 2021 as Microsoft no longer supports pre-2021 Office versions.  Likewise, Windows users are assumed to be using up to date version of Windows 11, especially as MS Windows 10 support will be withdrawn shortly.  At this time, Online/Web/Browser-based versions of MS-365 cannot run .xlms files.  The Pb-Tool has had some limited testing in Excel on a current Mac/Apple machine and appeared to function as intended.\n\nSome users may need permission from their IT department to run macro enabled .xlsm files.   Although the Pb-Tool it is not a VBA driven worksheet, there are a limited number of macro driven 'form-control' buttons that reset users values back to defaults.  Although the Pb-Tool can be run without these macro-driven controls, it is not recommended as it will remove core Pb-Tool functionality.\n\nThe current MS VBA/Macros do not appear to run in current versions (as of late 2025) open-source LibreOffice/Calc.  Although the core functionality of the Pb-Tool does seem to work in LibreOffice/Calc, the Pb-Tool is not recommended to be used in other spreadsheet software.  The Pb-Tool has not been tested in Google-Sheets.\n\nPrinting\nThe main spreadsheet area is designed to be printed across two A3 PDF pages.\nIt is suggested that users Print using a pdf 'Printer'/writer (e.g. 'Microsoft Print to PDF') with the 'Page Size' suggested at A3. If necessary, users can use the 'Page Break Review' and the Page Marks text in cells to set the Printing View.  The main Pb-Tool area is designed to fit onto Two Pages for Printing.\n\nKnown Issues\nThere is a well recognised Excel cell/font scaling issue when screen Zooming spreadsheets below 100%.  This relates to Excels approach to Font Size rounding when Zooming below 100%, whereby Excel may adopt a rounded scaled Font Size that is too big for the cell at that zoom level and cell text overspill is observed.  Users may find it best not to use Zoom levels below 85%.  Sometimes cell scrolling has been noticed to become unresponsive/locked/erratic at certain zoom levels under 90%; this is usually resolved by increasing zoom above 90%.\n\nAll User Input Cells have Data Validation requirements to prevent users inputting non-compliant values.  If users input a non-compliant value, be aware that Excel may sometimes create a cell link formula in the cell (e.g. '=C35'). Pressing 'Esc' will usually exit from the cell without the cell x-reference being used.\n\nBalancing 'Row Height' and 'Column Width has been a challenge in trying to keep the main Pb-Tool on single worksheet and printable onto two A3 Pages, whilst maintaining a reasonably visually pleasing & useable layout.  A necessary compromise has had to be made in some areas of the main spreadsheet.\n\nSometimes on re-opening a previously used/saved Worksheet, the License Disclaimer checkbox may be checked but with the Pb-Tool not visible.  if this occurs, then unchecking & rechecking the tickbox should resolve the issue."]
[null,null,{"$f":"'RBKC Resi Lead Tool '!C16","v":"2. MAIN INPUT AREA"}]
[null,null,"This area provides the primary Residential CSM inputs that are expected to be of main interest for the majority of users."]
[null,null,"Three VBA Driven buttons are provided to allow users to easily move between (and reset to) the Three Baseline Starting CSMs (C4SL, KC-4L, KC-3L)."]
[null,null,"A forth VBA button is provided that just resets the Advanced CSM Settings in Area-4."]
[null,null,"A checkbox is also provided to disable these VBA buttons: for example if a User was working on a site-specific CSM and did not want to accidently reset all their CSM inputs."]
[]
[null,null,"The first set of Inputs allows selection of one of two TOX Criteria and one of four different options for the HGP Lead-Pb SPCFs (including site-specific). "]
[null,null,"The Technical Basis sheet provides further information on the SPCF options."]
[null,null,"The second set of Inputs provide the overall Soil Ingestion Rate (SIR), the indoor/outdoor SIR %split and the %-Oral-RBA."]
[null,null,"The third set of Inputs provide the indoor/outdoor soil/soil-dust exposure frequencies for each Age Class."]
[null,null,"The forth set of Inputs provide the site-specific SPCF should a user wish to use this option."]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!C57","v":"3. ADVANCED HGP/DUST INPUTS"}]
[null,null,"This area provides Residential CSM inputs that are expected to be of interest to advanced users."]
[null,null,"For the HGP pathways, these inputs allow users to amend many more of the HGP CSM parameters."]
[null,null,"For dust inhalation, the user is limited to outputs derived from the baseline C4SL residential CSM model, with six options for the dust generating area, two cover options & varying %-Inhalation-RBA."]
[null,null,"Users cannot amend the AC1-6 Body Weights or the overall HGP consumption rates (although the fraction of HGP could be used as a proxy for this)."]
[]
[null,null,"4a/b. CSM JUSTIFICATION AREAS"]
[null,null,"Comments and notes on the adopted CSM approach can be entered here."]
[null,null,"Cells in the range O4:P13 update automatically to inform users of their adopted CSM Frameworks."]
[]
[null,null,"5/6. PATHWAY AND SAC OUTPUTS"]
[null,null,"This area provides a detailed by-pathway (and some by-AC) breakdown (in mg/kg) of the modelling outputs."]
[null,null,"A by-AC graph for the combined Soil/Soil-dust ingestion pathways is also provided to give further insight into the modelling results/workings."]
[null,null,"The combined SACs across the relevant pathways are provided in Area-6."]
[null,null,"Some cells in each Area 5/6 table update automatically to remind users of their adopted CSM Frameworks."]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!N54","v":"7. ADE & BASELINE TABLES"}]
[null,null,{"$f":"'RBKC Resi Lead Tool '!X15","v":"8. SAC GRAPH"}]
[null,null,"These tables and graphs provide further visualisation and insight into the modelling outputs/workings and baseline values for reference."]
[]
[null,null,"9/10. PATHWAY CALCULATIONS AREAS"]
[null,null,"The tables in these areas provide detailed by-AC, by-HGP-type, by-pathway workings/calculations for the soil/soil-dust and HGP pathways (all from first principle calculations)."]
[null,null,"The calculations are provided in a staged long-hand form (rather than in complex single cell formula or hidden in VBA) to give further insight into the modelling results/workings."]
[]
[null,null,"11/12. ADDITIONAL GRAPHS, INFORMATION, BENCHMARKING AND USER AREA "]
[null,null,"Area 11 provides additional graphs to give further insight into the modelling results and some reference look up tables."]
[null,null,"Area 11 also provides two methods for benchmarking Pb-Tool outputs using CLEA 1.071.  Guidance/instructions for benchmarking are provided in Area 11."]
[null,null,"Area 12 is a user accessible area to provide further notes/commentary etc."]
[]
[null,null,"13-15 ADDITIONAL AREAS"]
[null,null,"Area-13 provides a list of Excel 'Names' and general formula used in the spreadsheet, along with Acronyms, Initialisms & Abbreviations."]
[null,null,"Area-14 provides the look-up tables for the Dust Inhalation pathways, further reference tables and the Excel Control cells used for the Charts."]
[null,null,"Area-15 provides other look-up tables and x-reference cells/lists used by the spreadsheet (shown for transparency)."]
[]
[null,null,"PRINTING"]
[null,null,"The main spreadsheet area is designed to be printed across two A3 PDF pages."]
[null,null,"It is suggested that users Print using a pdf 'Printer'/writer (e.g. 'Microsoft Print to PDF') with the 'Page Size' suggested at A3."]
[null,null,"If necessary, users can use the 'Page Break Review' and the Page Marks text in cells to set the Printing View.  The main Pb-Tool area is designed to fit onto Two Pages for Printing."]

{"sheet":"Technical Basis for KC 3L-4L","index":3,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[68,2,69,2],[68,3,69,3],[68,4,69,4],[68,5,69,5],[68,6,69,6],[53,6,58,6],[62,2,62,6],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[66,6,67,6],[2,2,2,4],[3,2,3,4],[5,2,5,5],[46,6,51,6],[8,2,8,6],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,6,14,6],[17,3,22,3],[17,6,22,6],[25,6,30,6],[32,6,37,6],[39,6,44,6]]}
[]
[]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$2","v":"RBKC Lead (Pb) Tool: Published v1.0"},null,null,{"$f":"'RBKC Resi Lead Tool '!G12&\" / \"&'RBKC Resi Lead Tool '!$I$12","v":"Published v1.0 / CJD"}]
[null,null,{"$f":"'RBKC Resi Lead Tool '!$C$3","v":"Resi+HGP/Resi-HGP: Residential with/without Home Grown Produce"},null,null,{"$f":"'RBKC Resi Lead Tool '!$H$12","v":"2026-03-05"}]
[]
[null,null,"Technical Basis for KC 3L-4L"]
[]
[null,null,"CLEA Input Parameters for the Royal Borough of Kensington and Chelsea Category 4 Levels (KC4L's)"]
[null,null,"The KC4L’s are screening levels below which land could be considered to be Category 4 land under Part 2A of the Environmental Protection Act 1990 (Part 2A), representative of a low risk. They represent chronic rather than acute risks.  They are a reference point that may be used to, for example, make informed judgments for development through planning or building control. Additional intrusive site investigation work and detailed quantitative risk assessment will allow more accurate site specific acceptability criteria to be generated. In particular, determining the relative bioavailability will allow a more realistic site specific KC4L to be calculated. "]
[]
[null,null,"Parameter ","Units ","C4SL value ","RBKC4AC value ","Discussion "]
[null,null,"Soil and \nsoil-dust ingestion rate ","mg/day ","100 ","80 ","The soil/soil-dust ingestion rate (SIR) for children of 100 mg/day that was adopted in the UK CLEA guidance was based on the recommendation from the US EPA 2006 Child-Specific Exposure Factors Handbook (USEPA, Child-Specific Exposure Factors Handbook (External Review Draft). Report EPA/600/R/06/096A, 2006).  The C4SL report provided a review of the more recent US EPA Exposure Factors Handbook from 2011 (USEPA, 2011), which continued to recommend a soil/soil-dust ingestion rate of 100 mg/day for children in a residential setting.  However, the C4SL report considered reducing the SIR for the derivation of C4SLs on the basis of apparent conservatism within the SIR estimates.  Ultimately however, the value of 100 mg/day originally adopted by the CLEA guidance was retained to maintain a precautionary approach given the uncertainty with this parameter.  Subsequent to the publication of the CLEA guidance and C4SL reports (excluding the 2021 and 2024 C4SLs ), the US EPA Exposure Factors Handbook guidance was updated in 2017 (US EPA, 2017).  The USEPA 2017 guidance provided a range for the central tendency estimates (CTEs) for SIR based on a variety of studies, and differing SIRs for different age groups.  For the age group 1 to <6 years, USEPA 2017 presented an SIR CTE of 80 mg/day (mid-point of a range from 60 to 100 mg/day).  For the purposes of deriving the RBKC4AC this updated SIR of 80 mg/day has been adopted for residential land-use scenarios. "]
[null,null,"Exposure frequency (outdoor soil/soil-dust ingestion, outdoor inhalation of dust and vapour) ","days/year ","AC 1: 180\nAC 2-6: 365 ","144\n292 ","Both SR3 and SP1010 acknowledge that the assumption that outdoor soil/soil-dust ingestion occurs every day of the year is unlikely to be true.  SP1010 adopted an outdoor dermal contact exposure frequency of 170 days/year and presented arguments that this exposure frequency could also be adopted for outdoor soil/soil-dust ingestion.  However to remain sufficiently precautionary, the outdoor soil/soil-dust ingestion exposure frequency was retained at 365 days/year for the C4SL derivation.  For the purposes of the RBKC4AC derivation, an outdoor exposure frequency of 144 days/year for Age Class 1 and 292 days/year for Age Classes 2-6 have been adopted.  This is a nominal 20% reduction in the outdoor exposure frequency of 365 days/year but can be equated to an AC-2-6 child using a garden 4 times per week between November and February, or, if a child was away from the home 14 days per year for visits and/or holidays, using a garden 3 times per week between November and February. For AC-1 at 144 days/year, the assumption is consistent with that described in SR3 in that infants are not afforded the same access and exposure to the garden area as older children in AC2-6. The garden is still assumed to be used 7 days/week for the remainder of the year (March to October).  This assumed exposure frequency remains higher than the value of 170 days/year considered (but ultimately not adopted) for the C4SLs. "]
[]
[]
[null,null,"Soil/soil-dust ingestion rate weighted for reduced exposure frequency ","mg/day ","100 ","72 ","Due to the way in which CLEA calculates assessment criteria, the reduced outdoor exposure frequency of 292 days for AC2-6 and 144 days/year for AC-1  cannot be directly input to the soil/soil-dust ingestion rate exposure frequency parameter field as this also includes indoor soil-dust ingestion, which must remain at 365 days / year for AC2-6 and 180 Days/year for AC-1.  Therefore to account for the reduced exposure frequency of outdoor soil/soil-dust ingestion only, the soil/soil-dust ingestion rate input parameter within CLEA has been reduced by 10% (from 80 mg/day to 72 mg/day).  This approach is based on the general rule that approximately half of ingestion exposure is accounted for by outdoor soil/soil-dust ingestion and approximately half by indoor soil-dust ingestion. Within the RBKC Lead model, there is no need to calculate a weighted soil/soil-dust ingestion rate as indoor and outdoor exposure frequencies can be individual specified.  "]
[null,null,"Soil to plant concentration factor "]
[null,null,"Green vegetables ","mg/g FW produce per mg/g DW soil ","4.19E-03 ","6.90E-04 ","The soil to plant concentration factor values adopted for the derivation of the C4SLs are based on geometric mean values from a literature review carried out by the Environment Agency in 2008, but which remains unpublished.  RBKC and AECOM consider that it is appropriate to replace these unpublished literature values with values obtained from the studies carried out as part of the Grenfell Environmental Checks.  The studies are presented in AECOM report 'Grenfell Investigation into Potential Land Contamination Impacts, 11 June 2021 https://www.gov.uk/guidance/grenfell-environmental-checks-stage-2-report.  The soil to plant concentration factors are based on sampling studies carried out predominantly within the north of RBKC, as well as within some land in neighbouring boroughs.  The results are therefore representative of conditions generally found in west central London.  An arithmetic mean of the results from the Grenfell investigation was used for green vegetables and root vegetables, rather than the geometric mean used from the unpublished EA data, so that the adopted values were not weighted towards the lower end of the range as they would be if the geometric mean were used.  This approach is slightly more conservative.  For the other four categories, the maximum values from the Grenfell studies were used due to smaller datasets. Within the RBKC Lead model, users are also provided with an option to select all maximum SPCF values from the Grenfell Studies."]
[null,null,"Root vegetables ",null,"4.02E-03 ","5.30E-04 "]
[null,null,"Tuber vegetables ",null,"7.31E-03 ","3.40E-04 "]
[null,null,"Herbaceous fruit ",null,"7.49E-03 ","3.30E-05 "]
[null,null,"Shrub fruit ",null,"2.05E-04 ","1.10E-04 "]
[null,null,"Tree fruit ",null,"2.29E-04 ","1.10E-04 "]
[null,null,"Homegrown produce diet fraction (average) ",null,null,"  ","Within Kensington & Chelsea, experience of dealing with residential properties through the planning process suggests that most gardens are small to medium size (less than 60m2) and incorporate a large proportion of hard surfacing, typically 50% or more.  These factors mean that the CLEA assumption of homegrown produce consumption based on a garden area 'as little as 20m2' is considered to be overly precautionary. \nRBKC4AC have been calculated for a range of garden sizes, with the homegrown produce diet fraction sequentially reduced to take into account the reduced ability / likelihood of growing 'average' quantities of produce as garden size decreases. When calculating the scaling factor for different sized gardens, a safety factor of 15% (for gardens <60m2), 10% (for gardens <40m2), 5% (for gardens <20m2) and 2.5% (for gardens <10m2) has been built in to help account for any uncertainty associated with the extent of a garden that may be used for home grown produce. This is greater for large gardens, where there is more opportunity to grow produce. "]
[null,null,"Garden 60m2+ ","  ","  ","  "]
[null,null,"Green vegetables ","  ","0.05 ","0.05 ","For gardens of 60m2 or larger within RBKC, no change to the homegrown produce diet fraction has been made. "]
[null,null,"Root vegetables ","  ","0.06 ","0.06 "]
[null,null,"Tuber vegetables ","  ","0.02 ","0.02 "]
[null,null,"Herbaceous fruit ","  ","0.06 ","0.06 "]
[null,null,"Shrub fruit ","  ","0.09 ","0.09 "]
[null,null,"Tree fruit ","  ","0.04 ","0.04 "]
[null,null,"Garden 40-60m2 ","  ","  ","  "]
[null,null,"Green vegetables ","  ","0.05 ","0.0375 ","For gardens between 40m2 and 60m2, the homegrown produce diet fraction has been reduced to 75% of the value adopted for the C4SLs. "]
[null,null,"Root vegetables ","  ","0.06 ","0.045 "]
[null,null,"Tuber vegetables ","  ","0.02 ","0.015 "]
[null,null,"Herbaceous fruit ","  ","0.06 ","0.045 "]
[null,null,"Shrub fruit ","  ","0.09 ","0.0675 "]
[null,null,"Tree fruit ","  ","0.04 ","0.03 "]
[null,null,"Garden 20-40m2 ","  ","  ","  "]
[null,null,"Green vegetables ","  ","0.05 ","0.025 ","For gardens between 20m2 and 40m2, the homegrown produce diet fraction has been reduced to 50% of the value adopted for the C4SLs. "]
[null,null,"Root vegetables ","  ","0.06 ","0.03 "]
[null,null,"Tuber vegetables ","  ","0.02 ","0.01 "]
[null,null,"Herbaceous fruit ","  ","0.06 ","0.03 "]
[null,null,"Shrub fruit ","  ","0.09 ","0.045 "]
[null,null,"Tree fruit ","  ","0.04 ","0.02 "]
[null,null,"Garden 10-20m2 ","  ","  ","  "]
[null,null,"Green vegetables ","  ","0.05 ","0.0125 ","For gardens between 10m2 and 20m2, the homegrown produce diet fraction has been reduced to 25% of the value adopted for the C4SLs. "]
[null,null,"Root vegetables ","  ","0.06 ","0.015 "]
[null,null,"Tuber vegetables ","  ","0.02 ","0.005 "]
[null,null,"Herbaceous fruit ","  ","0.06 ","0.015 "]
[null,null,"Shrub fruit ","  ","0.09 ","0.0225 "]
[null,null,"Tree fruit ","  ","0.04 ","0.01 "]
[null,null,"Garden <10m2 ","  ","  ","  "]
[null,null,"Green vegetables ","  ","0.05 ","0.00625 ","For gardens less than 10m2, the homegrown produce diet fraction has been reduced to 12.5% of the value adopted for the C4SLs. "]
[null,null,"Root vegetables ","  ","0.06 ","0.0075 "]
[null,null,"Tuber vegetables ","  ","0.02 ","0.0025 "]
[null,null,"Herbaceous fruit ","  ","0.06 ","0.0075 "]
[null,null,"Shrub fruit ","  ","0.09 ","0.01125 "]
[null,null,"Tree fruit ","  ","0.04 ","0.005 "]
[]
[]
[null,null,"CLEA Input Parameters for the Royal Borough of Kensington and Chelsea generic levels (KC3L's)"]
[null,null,"The KC3L’s are generic levels which will approach but not define the Category 2/3 boundary. They represent chronic rather than acute risks.  They are a reference point that may be used to, for example, make informed judgments about the significance of an exceedance of the KC4L's. Additional intrusive site investigation work and DQRA will be required to generate a criterion that represents the Category 2/3 boundary for individual sites, and above which land could be determinable as contaminated land under Part 2A of the Environmental Protection Act 1990."]
[]
[null,null,"Parameter","Units","C4SL/RBKC4AC","Proposed RBKC3AC ","Discussion "]
[null,null,"Health Criteria Value","μg/kg-bw/day",1.4,2.1,"5 μg/dL is the UKHSA concentration for triggering individual case intervention in England and so represents a point at which blood lead concentrations require medical treatment by health professional. The HCV calculated as part of the C4SL Research Project as being equivalent to a blood lead level of 5 μg/dL was    2.1 μg/kg-bw/day (child receptor)."]
[null,null,"Exposure frequency (outdoor soil/soil-dust ingestion, outdoor inhalation of dust and vapour)","Days/year","AC1 180/144\nAC2-6 365/292","84\n170","Both SR3 and SP1010 acknowledge that the assumption that outdoor soil and dust ingestion occurs every day of the year is unlikely to be true.  SP1010 suggested an outdoor dermal contact exposure frequency of 170 days/year and presented arguments that this exposure frequency could also be adopted for outdoor soil and dust ingestion.  However to remain sufficient precautionary, the outdoor soil and dust ingestion exposure frequency was retained at 365 days/year for the C4SL derivation.  For the purposes of the RBKC3AC derivation, an outdoor exposure frequency of 170 days/year for AC-2-6 has been adopted.  This reflects recommendations within SP1010 and can be roughly equated to a child using a garden 2 times per week between October and April and 4 times per week at other times.  For AC-1 at 84 days/year, the assumption is consistent with that described in SR3 in that infants are not afforded the same access and exposure to the garden area as older children in AC2-6."]
[]
[null,null,"Exposure frequency (indoor soil-dust ingestion, indoor inhalation of dust and vapour)","Days/year","AC1 180/180\nAC2-6 365/365","144\n292","The SP1010 conceptual model assumes that a proportion of contaminated soil may reasonably be tracked back from the garden into the home and that this contributes to exposure to contamination from the soil-derived fraction of indoor dust. It is also acknowledged that there is uncertainty associated with the proportion of dust derived from garden soils, due to factors such as patterns of use, whether shoes are removed and the use of door mats. A cited study found that between 20% and 80% of dust originates from local sources other than the garden, with an average of 50%. It is also indicated that the USEPA propose a default mass fraction of soil in indoor dust of 70% for modelling exposure to lead. Applying a nominal 20% reduction to each Age Class indoor Exposure frequency is therefore considered a pragmatic means of reflecting other non-site local sources of dust. This could potentially be reduced further with additional dustiness sampling and analyses."]
[]
[null,null,"Soil/soil-dust ingestion rate weighted for reduced exposure frequency","mg/day","100/72",50.63,"Due to the way in which CLEA calculates assessment criteria, the reduced exposure frequencies for outdoor soil and indoor soil derived dust and vapour cannot be directly input to the soil and dust ingestion rate exposure frequency parameter field due to the different indoor and outdoor soil/soil-dust ingestion contributions.  Therefore to account for the reduced exposure frequency of outdoor soil and dust ingestion only, the soil and soil-dust ingestion rate input parameter within CLEA has been reduced by 53% for the outdoor contribution and by 20% for the indoor contribution (from 80 mg/day to 47 mg/day).  This approach is based on the general rule that approximately half of ingestion exposure is accounted for by outdoor soil ingestion and approximately half by indoor soil-dust ingestion. Within the RBKC Lead model, there is no need to calculate a weighted soil ingestion rate as indoor and outdoor EF can be individual specified."]
[null,null,"Soil to plant concentration factor","mg/g FW produce per mg/g DW soil","See Cat4AC table","See Cat4AC table","See Cat4AC table"]