{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ID-EPH-Cat2-Residential","ID-EPH-Cat2-Nonresidential","Sheet1"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ID-EPH-Cat2-Residential","index":0,"n_rows":109,"n_cols":79,"rows_kept":109,"cut":false,"hidden":false,"merged":[[14,1,14,2],[16,1,16,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,0,3,1],[2,2,3,5],[2,7,2,8],[3,7,3,8],[16,10,16,11],[17,1,17,2],[18,1,18,2],[15,1,15,2],[19,1,19,2],[19,7,19,8],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[24,1,24,2],[25,1,25,2],[26,1,26,2]]}
["EPH Category 2 Ingestion/Dermal Residential Calculator - Version 1.0, June 2019"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell"]
["Sample ID:",null,null,null,null,null,null,null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification"]
[]
[]
[null,"AL9-12\n(PHC Mixture)","AL12-16\n(PHC Mixture)","AL16-21\n(Mineral Oil)","AL21-40\n(Mineral Oil)","AR10-12\n(Naphthalene)","AR12-16\n(Acenaphthene)","AR16-21\n(Fluorene)","AR21-36\n(Fluoranthene)"]
["RfDo",0.1,0.1,2,2,4.1000000000000002E-2,0.06,0.04,0.04]
["RfDD",0.1,0.1,2,2,4.1000000000000002E-2,0.06,0.04,0.04]
["ABSd",0.1,0.1,0.1,0.1,0.13,0.13,0.13,0.13]
["Child ECFV",{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/B8)*$E$25)+((1/B9)*$E$26*$E$27*B10)))","v":6110.4910714285725},6110.4910714285725,122209.82142857143,122209.82142857143,2351.0159195643068,3440.5111018014245,2293.6740678676165,2293.6740678676165]
["Concentration of fraction (mg/kg)","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration"]
["f",{"$f":"IF(ISERROR(B12/$H$17),\"\",B12/$H$17)","v":""},"","","","","",{"$f":"IF(ISERROR(H12/$H$17),\"\",H12/$H$17)","v":""},""]
[]
["Parameter","Definition",null,"Units","Residential Scenario"]
["EV","Event Frequency",null,"events/day",1,null,null,"Total EPH in sample:"]
["THQ","Target Hazard Quotient",null,"unitless",1,null,null,{"$f":"IF(ISERROR(F12+G12+H12+I12+B12+C12+D12+E12),\"\",F12+G12+H12+I12+B12+C12+D12+E12)","v":""},"mg/kg"]
[null,"Conversion Factor",null,"days/year",365,null,null,"Allowable EPH in sample:"]
["EFc","Exposure Frequency - child",null,"days/year",350,null,null,{"$f":"C33","v":""},"mg/kg"]
["EDc and ATc","Exposure Duration and Averaging Time - child",null,"years",6,null,null,{"$f":"IF(H17=\"\",\"\",IF(H17<=H19, \"PASS\",\"FAIL\"))","v":""}]
["RfDo","Oral Reference Dose",null,"mg/kg-day","see above"]
["RfDD","Dermal Reference Dose",null,"mg/kg-day","see above"]
["ABSd","Dermal Absorption Fraction",null,"unitless","see above"]
["BWc","Body Weight - child",null,"kg",15]
["IRc","Soil Ingestion Rate - child",null,"mg/day",200]
["SAc","Skin Surface Area - child",null,"cm2/day",2800]
["AFc","Soil Adherence Factor - child",null,"mg/cm2",0.2]
["ECFV","Equivalent carbon fraction value",null,"mg/kg-day","see above"]
["f","EC Weight fraction =  fraction concentration/total concentration",null,"unitless","see above"]
["IDnc","Residential Non-carcinogenic Health-Based Soil Criterion (ingestion/dermal)",null,"mg/kg",{"$f":"IF(ISERROR(1/(F13/F11+G13/G11+H13/H11+I13/I11+B13/B11+C13/C11+D13/D11+E13/E11)),\"\",Round_to_Even(1/(F13/F11+G13/G11+H13/H11+I13/I11+B13/B11+C13/C11+D13/D11+E13/E11)))","v":""}]
[]
["EPH Category 2 Ingestion/Dermal Residential Soil Remediation Standard:"]
[null,null,{"$f":"E30","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"72-54-8"]

{"sheet":"ID-EPH-Cat2-Nonresidential","index":1,"n_rows":109,"n_cols":79,"rows_kept":109,"cut":false,"hidden":false,"merged":[[19,7,19,8],[16,10,16,11],[17,1,17,2],[18,1,18,2],[0,0,0,8],[1,0,1,1],[1,2,1,6],[2,0,3,1],[2,2,3,5],[2,7,2,8],[3,7,3,8],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[14,1,14,2],[16,1,16,2],[15,1,15,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[23,1,23,2],[24,1,24,2],[25,1,25,2]]}
["EPH Category 2 Ingestion/Dermal Nonresidential Calculator - Version 1.0, June 2019"]
["Site Name:",null,null,null,null,null,null,"Date:",null,null,null,"Calculated or locked cell"]
["Sample ID:",null,null,null,null,null,null,null,null,null,null,"Required data entry"]
[null,null,null,null,null,null,"Evaluated by:",null,null,null,null,"Optional data entry/modification"]
[]
[]
[null,"AL9-12\n(PHC Mixture)","AL12-16\n(PHC Mixture)","AL16-21\n(Mineral Oil)","AL21-40\n(Mineral Oil)","AR10-12\n(Naphthalene)","AR12-16\n(Acenaphthene)","AR16-21\n(Fluorene)","AR21-36\n(Fluoranthene)"]
["RfDo",0.1,0.1,2,2,4.1000000000000002E-2,0.06,0.04,0.04]
["RfDD",0.1,0.1,2,2,4.1000000000000002E-2,0.06,0.04,0.04]
["ABSd",0.1,0.1,0.1,0.1,0.13,0.13,0.13,0.13]
["Adult ECFV",{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/B8)*$E$25)+((1/B9)*$E$26*$E$27*B10)))","v":68406.961178045516},68406.961178045516,1368139.2235609104,1368139.2235609104,{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/F8)*$E$25)+((1/F9)*$E$26*$E$27*F10)))","v":25058.007415380933},{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/G8)*$E$25)+((1/G9)*$E$26*$E$27*G10)))","v":36670.254754216003},{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/H8)*$E$25)+((1/H9)*$E$26*$E$27*H10)))","v":24446.836502810667},{"$f":"($E$17*$E$18*$E$20*$E$24)/($E$19*$E$20*10^-6*(((1/I8)*$E$25)+((1/I9)*$E$26*$E$27*I10)))","v":24446.836502810667}]
["Concentration of fraction (mg/kg)","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration","Enter concentration"]
["f",{"$f":"IF(ISERROR(B12/$H$17),\"\",B12/$H$17)","v":""},"","","",{"$f":"IF(ISERROR(F12/$H$17),\"\",F12/$H$17)","v":""},{"$f":"IF(ISERROR(G12/$H$17),\"\",G12/$H$17)","v":""},{"$f":"IF(ISERROR(H12/$H$17),\"\",H12/$H$17)","v":""},{"$f":"IF(ISERROR(I12/$H$17),\"\",I12/$H$17)","v":""}]
[]
["Parameter","Definition",null,"Units","Nonresidential Scenario"]
["EV","Event Frequency",null,"events/day",1,null,null,"Total EPH in sample:"]
["THQ","Target Hazard Quotient",null,"unitless",1,null,null,{"$f":"IF(ISERROR(F12+G12+H12+I12+B12+C12+D12+E12),\"\",F12+G12+H12+I12+B12+C12+D12+E12)","v":""},"mg/kg"]
[null,"Conversion Factor",null,"days/year",365,null,null,"Allowable EPH in sample:"]
["EFa","Exposure Frequency - adult",null,"days/year",225,null,null,{"$f":"C33","v":""},"mg/kg"]
["EDa and ATa","Exposure Duration and Averaging Time - adult",null,"years",25,null,null,{"$f":"IF(H17=\"\",\"\",IF(H17<=H19, \"PASS\",\"FAIL\"))","v":""}]
["RfDo","Oral Reference Dose",null,"mg/kg-day","see above"]
["RfDD","Dermal Reference Dose",null,"mg/kg-day","see above"]
["ABSd","Dermal Absorption Fraction",null,"unitless","see above"]
["BWa","Body Weight - adult",null,"kg",70]
["IRa","Soil Ingestion Rate - adult",null,"mg/day",100]
["SAa","Skin Surface Area - adult",null,"cm2/day",3300]
["AFa","Soil Adherence Factor - adult",null,"mg/cm2",0.2]
["ECFV","Equivalent carbon fraction value",null,"mg/kg-day","see above"]
["f","EC Weight fraction =  fraction concentration/total concentration",null,"unitless","see above"]
["IDnc","Nonresidential Non-carcinogenic Health-Based Soil Criterion (ingestion/dermal)",null,"mg/kg",{"$f":"IF(ISERROR(1/(F13/F11+G13/G11+H13/H11+I13/I11+B13/B11+C13/C11+D13/D11+E13/E11)),\"\",Round_to_Even(1/(F13/F11+G13/G11+H13/H11+I13/I11+B13/B11+C13/C11+D13/D11+E13/E11)))","v":""}]
[]
["EPH Category 2 Ingestion/Dermal Nonresidential Soil Remediation Standard:"]
[null,null,{"$f":"E30","v":""},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"72-54-8"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}