{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["README","Local Assessment","HiddenSheet","Database"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"README","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[18,0,18,1],[19,0,19,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[12,0,12,1]]}
[]
["Petrorisk 8.02: GES Scaling Tool"]
[]
["INTRODUCTION"]
["The developed tool allows Registrants and Downstream Users (DU) to assess whether a Generic Exposure Scenario (GES), generated via PetroRisk 8.01, covers their specific Expsoure Scenario. Alternatively, the Scaling Tool can be used to support the generation of a DU Exposure Scenario (DU ES), by 'down-scaling' the GES to DU specific Operational Conditions (OC) and Risk Management Measures (RMM). However, the user should consider to use PetroRisk 8.01, rather than the Scaling Tool, when generating DU ESs."]
["Where Registrants or DUs find themselves operating outside of the applicability of the Generic Exposure Scenario, please contact admin@super-sief.eu for potential refinement of the GES."]
["The scaling tool is relevant to registrations of industrial uses. The scaling tool is not applicable to Professional and Consumer uses."]
[]
["DISCLAIMER"]
["The Petrorisk Scaling Tool has been prepared in good faith, based on information and guidance currently available. The tool may need to be updated in light of further guidance to be issued by the European Chemicals Agency (ECHA)."]
["No recipient of Petrorisk Scaling Tool shall: (i) copyright or patent it in any form; (ii) redistribute it to others without Concawe’s prior written authorization; (iii) make a monetary charge for it."]
["Neither Concawe nor any of its Member Companies can accept any liability arising from the use of the tool. It is to be relied upon at the user's own risk."]
["No representations or warranties are made with regards to its completeness or accuracy and no liability will be accepted for damages of any nature whatsoever resulting from the use of, or reliance on, the tool. The preceding disclaimer shall apply whether or not liability results, or is claimed to result, from negligence or other circumstances."]
[]
["MANUAL"]
["1. In the 'Local Assessment' worksheet of the provided PetroRisk 8.02 output file, the user should identify the column relevant to his/her industrial use of interest. "]
["2. Copy the entire column."]
["3. Paste-special the copied column values onto Column B (or 2) of the 'Local Assessment'worksheet of the Scaling Tool."]
["4. Provide the site-specific OCs and RMMs in the yellow cells in column C (or 3). If left blank, the Scaling Tool will populate cells with generic values."]
["5. Scroll down to the bottom of the 'Local Assessment' worksheet: the site-specific OCs and RMMs can be considered 'safe' if none of the RCRs are above a value of 1. "]
["6. Please press the button \"Recalculate Applied Onsite Air & Wastewater Treatment Efficiencies\" if you wish to calculate and implement the minimal set of air and wastewater treatment efficiencies that can be considered 'safe. "]
["7. Please carefully review the scaled values in column D (or 4). The Scaling Tool will highlight typical inconsistencies by a light red fill and a dark red text."]
["8. When considering generating a DU ES, column D (or 4) can be copied and its values pasted special onto the appropriate column of the  PetroRisk 8.02 output file."]
[]
["IMPORTANT NOTICE"]
["In PetroRisk 8.02, changing wastewater treatment efficiency will change the relative composition of the effluent. When the treatment efficiency is increased, the effluent will be relatively enriched with hydrocarbons which are less easily removed from the wastewater: less volatile, less biodegradable but more water soluble and generally more toxic hydrocarbons. As a consequence, related risks do not scale linearly, but rather exponentially with wastewater treatment efficiency, with the equation parameters depending on the predicted influent concentration and removal efficiency of each hydrocarbon. The PetroRisk Scaling Tool however performs an approximative linear scaling: it will underestimate risks when the applied onsite wastewater removal efficiency is increased, but will conservatively, generally slightly, overestimate risks when the removal efficiency is decreased. Therefore, the Scaling Tool should only be used for conservatively 'down-scaling' the GES."]
[]
["DATE"]
["2025-02-21"]

{"sheet":"Local Assessment","index":1,"n_rows":111,"n_cols":5,"rows_kept":111,"cut":false,"hidden":false,"merged":[[22,4,24,4],[103,4,105,4],[98,4,101,4]]}
["Property","1","DU EXPOSURE SCENARIO",{"$f":"B1","v":"1"},"Comment"]
["USE DESCRIPTION AND CONDITIONS","","",""]
["Use Name","Manufacture of substance",null,{"$f":"B3","v":"Manufacture of substance"}]
["Sector of Use","Industrial",null,{"$f":"B4","v":"Industrial"}]
["Specific Environmental Release Category","ESVOC SPERC 1.1.v3",null,{"$f":"B5","v":"ESVOC SPERC 1.1.v3"}]
["(Generic) Environmental Release Category","ERC 1",null,{"$f":"B6","v":"ERC 1"}]
["Regional Fraction (%)","100.0",null,{"$f":"D9/(B9+B8)*100","v":100}]
["Annual Continental Tonnage (T/y)","0.0",null,{"$f":"B8","v":"0.0"}]
["Annual Regional Tonnage (T/y)","2395000.0",null,{"$f":"IF(D12*D11>B9,D12*D11,B9)","v":"2395000.0"}]
["Local Fraction (%)","48.3",null,{"$f":"D12*D11/D9*100","v":48.313152400835072}]
["Release Days","300.0",null,{"$f":"IF(C11=\"\",B11,C11)","v":"300.0"}]
["Daily Site Tonnage (T/d)","3857.0",null,{"$f":"IF(C12=\"\",B12,C12)","v":"3857.0"}]
["Release to Air, before RMMs (%)","5",null,{"$f":"IF(C13=\"\",B13,C13)*1","v":5}]
["Release to Water, before RMMs (%)","0.02",null,{"$f":"IF(C33<>\"\",IF(C23<>\"\",100*C33*D20*0.000000001/D12/(1-D23/100),IF(C14<>\"\",C14,B14)),IF(C14<>\"\",C14,B14))*1","v":0.02}]
["Release to Soil (%)","0.001",null,{"$f":"B15","v":"0.001"}]
["Release to Waste, before RMMs (%)","0.2",null,{"$f":"IF(C16=\"\",B16,C16)*1","v":0.2}]
["Default Onsite Air Treatment","Generic treatment",null,{"$f":"B17","v":"Generic treatment"}]
["Default Onsite Air Treatment Efficiency (%)","90.0",null,{"$f":"B18*1","v":90}]
["Applied Onsite Air Treatment Efficiency (%)","69.75",null,{"$f":"IF(C19=\"\",B19,C19)*1","v":69.75}]
["Wastewater Flow (L/d)","4297000.0",null,{"$f":"IF(C20=\"\",B20,C20)","v":"4297000.0"}]
["Default Onsite Wastewater Treatment","Biological treatment with primary oil-water separation",null,{"$f":"B21","v":"Biological treatment with primary oil-water separation"}]
["Default Onsite Wastewater Treatment Efficiency (%)","97.4",null,{"$f":"B22*1","v":97.4}]
["Applied Onsite Wastewater Treatment Efficiency (%)","99.65",null,{"$f":"IF(C23<>\"\",C23*1,IF(C33<>\"\",1-C33*D20*0.000000001/(D12*D14/100),B23*1))","v":99.65},"If site wastewater is not treated: set to 0. Please note that it is not appropriate to increase the DU Applied Wastewater Treatment Efficiency (cell D23) above the Generic Value (cell B23). Please contact admin@super-sief.eu if the Generic Exposure Scenario does not adequately cover your site conditions."]
["Release to Air, after RMMs (%)","1.51",null,{"$f":"D13*(1-D19/100)+IF(OR(B14*1=0,B23*1=0),0,D14*(D23/100)*(B24-B13*(1-B19/100))/B14/(B23/100))","v":1.51}]
["Release to Water, after RMMs (%)","0.0000701",null,{"$f":"D14/100*(1-D23/100)*100","v":6.9999999999998964E-5}]
["Release to Waste, after RMMs (%)","0.401",null,{"$f":"D16+D13*D19/100+IF(B23*1=0,0,(B26-B16-B13*B19/100)*D23/B23)","v":0.40100000000000025}]
["Municipal Sewage Treatment (STP)","None",null,{"$f":"B27","v":"None"},"PetroRisk assumes no connection to municipal wastewater treatment for industrial uses"]
["STP Efficiency (%)","0.0",null,{"$f":"B28","v":"0.0"},"Current Scaling Tool does not allow to assign municipal wastewater treatment to industrial uses"]
["Application of STP Sludge on Agricultural Soil","No",null,{"$f":"B29","v":"No"}]
["Riverine Dilution Factor (unitless)","10.0",null,{"$f":"IF(C30=\"\",B30,IF(C30*1=0,\"N/A\",C30))","v":"10.0"},"If site is not emitting to fresh water: set to 0 or \"N/A\""]
["Marine Dilution Factor (unitless)","730.0",null,{"$f":"IF(C31=\"\",B31,IF(C31*1=0,\"N/A\",C31))","v":"730.0"},"If site is not emitting to seawater: set to 0 or \"N/A\""]
["PREDICTED LOCAL CONCENTRATIONS",""]
["Site Effluent Concentration (mg/L)","0.629",null,{"$f":"IF(C33=\"\",D12*D25/100/D20*1000000000,C33)","v":0.62832208517569466},"Represents average effluent concentration during emission episode"]
["Concentration in Municipal STP (mg/L)","0",null,{"$f":"IF(D27=\"None\",0,D33*(1-D28/100))","v":0}]
["Dissolved Concentration in Freshwater (mg/L)","0.0629",null,{"$f":"IF(OR(D30=0,D30=\"N/A\",B33*1=0),0,IF(D34=0,D33/D30/(B33/B30),D34/D30/(B34/B30)))*B35","v":6.283220851756946E-2}]
["Concentration in Sediment (mg/kg dry weight)","0.450",null,{"$f":"IF(B35*1=0,0,D35*B36/B35)","v":0.44951500529262733}]
["Dissolved Concentration in Seawater (mg/L)","0.000861",null,{"$f":"IF(OR(D31=0,D31=\"N/A\",B33*1=0),0,IF(D34=0,D33/D31/(B33/B31),D34/D31/(B34/B31)))*B37","v":8.600720434598937E-4}]
["Concentration in Marine Sediment (mg/kg dry weight)","0.00617",null,{"$f":"IF(OR(D31=0,D31=\"N/A\",B37*1=0),0,D37*B38/B37)","v":6.163350183678913E-3}]
["Concentration in Air (mg/m³)","16.3",null,{"$f":"D12*D24/(B12*B24)*B39","v":16.3}]
["Concentration in Agricultural Soil, 30-day average (mg/kg dry weight)","0.0989",null,{"$f":"D39*B40/B39","v":9.8900000000000002E-2}]
["Concentration in Agricultural Soil, 180-day average (mg/kg dry weight)","0.0989",null,{"$f":"D39*B41/B39","v":9.8900000000000002E-2}]
["Concentration in Freshwater Fish (mg/kg wet weight)","0.0503",null,{"$f":"IF(B35*1=0,0,D35*B42/B35)","v":5.0245788369375897E-2}]
["Concentration in Marine Fish (mg/kg wet weight)","0.000689",null,{"$f":"IF(OR(D31=0,D31=\"N/A\",B37*1=0),0,D37*B43/B37)","v":6.8825741921471173E-4}]
["Concentration in Marine Predators (mg/kg wet weight)","0.00000656",null,{"$f":"IF(OR(D31=0,D31=\"N/A\",B43*1=0),0,D43*B44/B43)","v":6.5529298549325236E-6}]
["Concentration in Terrestrial Worms (mg/kg wet weight)","0.289",null,{"$f":"D39*B45/B39","v":0.28899999999999998}]
["PREDICTED ENVIRONMENTAL CONCENTRATIONS","",null,{"$f":"IF(C46=\"\",B46,C46)","v":""}]
["PEC Freshwater, dissolved (mg/L)","0.0629",null,{"$f":"D35+B47-B35","v":6.2832208517569446E-2}]
["PEC Sediment (mg/kg dry weight)","0.451",null,{"$f":"D36+B48-B36","v":0.45051500529262739}]
["PEC Seawater, dissolved (mg/L)","0.000863",null,{"$f":"D37+B49-B37","v":8.6207204345989364E-4}]
["PEC Marine Sediment (mg/kg dry weight)","0.00618",null,{"$f":"D38+B50-B38","v":6.1733501836789117E-3}]
["PEC Air (mg/m³)","16.3",null,{"$f":"D39+B51-B39","v":16.3}]
["PEC Agricultural Soil, 30-day average (mg/kg dry weight)","0.0989",null,{"$f":"D40+B52-B40","v":9.8900000000000002E-2}]
["PEC Agricultural Soil, 180-day average (mg/kg dry weight)","0.0989",null,{"$f":"D41+B53-B41","v":9.8900000000000002E-2}]
["PEC Freshwater Fish (mg/kg wet weight)","0.0504",null,{"$f":"D42+B54-B42","v":5.0345788369375907E-2}]
["PEC Marine Fish (mg/kg wet weight)","0.000696",null,{"$f":"D43+B55-B43","v":6.9525741921471179E-4}]
["PEC Marine Predators (mg/kg wet weight)","0.00000691",null,{"$f":"D44+B56-B44","v":6.9029298549325245E-6}]
["PEC Terrestrial Worms (mg/kg wet weight)","0.289",null,{"$f":"D45+B57-B45","v":0.28899999999999998}]
["INDIRECT HUMAN EXPOSURE (MAN VIA ENVIRONMENT)","",null,{"$f":"IF(C58=\"\",B58,C58)","v":""}]
["Local Concentration in Fish (mg/kg ww)","2.76",null,"N/A"]
["Local Concentration in Root Crops (mg/kg ww)","0.0414",null,"N/A"]
["Local Concentration in Potato (mg/kg ww)","0.0110",null,"N/A"]
["Local Concentration in (Other) Leafy vegetables (mg/kg ww)","0.122",null,"N/A"]
["Local Concentration in Lettuce (mg/kg ww)","0.192",null,"N/A"]
["Local Concentration in Fruit (mg/kg ww)","0.0457",null,"N/A"]
["Local Concentration in Cereals (mg/kg ww)","0.185",null,"N/A"]
["Local Concentration in Meat (mg/kg ww)","0.198",null,"N/A"]
["Local Concentration in Milk (mg/kg ww)","0.0658",null,"N/A"]
["Local Concentration in Drinking Water (mg/L)","0.0256",null,"N/A"]
["Local Concentration in Air, annual (mg/m³)","13.4",null,{"$f":"D39*D11/365","v":13.397260273972602}]
["PEC Fish (mg/kg ww)","2.77",null,"N/A"]
["PEC Root (mg/kg ww)","0.0414",null,"N/A"]
["PEC Potato (mg/kg ww)","0.0110",null,"N/A"]
["PEC Leaf (mg/kg ww)","0.122",null,"N/A"]
["PEC Lettuce (mg/kg ww)","0.192",null,"N/A"]
["PEC Fruit (mg/kg ww)","0.0457",null,"N/A"]
["PEC Cereal (mg/kg ww)","0.185",null,"N/A"]
["PEC Meat (mg/kg ww)","0.198",null,"N/A"]
["PEC Milk (mg/kg ww)","0.0658",null,"N/A"]
["PEC Drinking Water (mg/L)","0.0256",null,"N/A"]
["PEC Air, annual (mg/m³)","13.4",null,{"$f":"D69+B80-B69","v":13.397260273972604}]
["Daily Intake of Fish (kg ww/d)","0.00164286",null,{"$f":"B81","v":"0.00164286"}]
["Daily Intake of Root (kg ww/d)","0.0127143",null,{"$f":"B82","v":"0.0127143"}]
["Daily Intake of Potato (kg ww/d)","0.00282857",null,"0.00282857"]
["Daily Intake of Leaf (kg ww/d)","3.0E-4",null,"3.0E-4"]
["Daily Intake of Lettuce (kg ww/d)","2.57143E-4",null,"2.57143E-4"]
["Daily Intake of Fruit (kg ww/d)","0.00454286",null,"0.00454286"]
["Daily Intake of Cereal (kg ww/d)","0.00441429",null,"0.00441429"]
["Daily Intake of Meat (kg ww/d)","0.00237143",null,"0.00237143"]
["Daily Intake of Milk (kg ww/d)","0.0107714",null,"0.0107714"]
["Daily Intake of Drinking Water (L/d)","0.0285714",null,"0.0285714"]
["Daily Intake of Soil (kg ww/d)","0.00428571",null,"0.00428571"]
["Daily Intake of Air (m³/d)","0.548571",null,"0.548571"]
["Intake Dose via Ingestion (mg/kg bw/d)","0.00855",null,{"$f":"B93-B94-B95+D94+D95","v":8.5442820682753266E-3}]
["Ingestion Dose resulting from Local Air Emissions (mg/kg bw/d)","0.00324",null,{"$f":"IF(B13*1=0,0,D12*D13*(1-D19/100)*B94/(B12*B13*(1-B19/100)))","v":3.2399999999999998E-3},"Does not include air emission resulting from wastewater treatment"]
["Ingestion Dose resulting from Local Wastewater Emissions (mg/kg bw/d)","0.00530",null,{"$f":"IF(B35*1=0,0,D35/B35*(B95-((B24/100-B13*(1-B19/100)/100)*B12)*(B94/B12/B13*100/(1-B19/100))))+IF(B13*1=0,0,((D24/100-D13*(1-D19/100)/100)*D12)*(B94/B12/B13*100/(1-B19/100)))","v":5.2942820682753263E-3},"Includes contribution from wastewater treatment via effluent and air"]
["Intake Dose via Inhalation (mg/kg bw/d)","7.34",null,{"$f":"D80*B96/B80","v":7.3384992843999184},"Includes contribution from direct air emission and from wastewater treatment"]
["RISK CHARACTERIZATION","",null,{"$f":"IF(C97=\"\",B97,C97)","v":""}]
["RCR STP Micro-organisms (unitless)","0",null,{"$f":"ROUND(IF(B34*1=0,0,D34*B98/B34),4)","v":0}]
["RCR Freshwater Organisms (unitless)","0.533",null,{"$f":"ROUND(D47*B99/B47,4)","v":0.53239999999999998}]
["RCR Sediment Organisms (unitless)","0.610",null,{"$f":"ROUND(D48*B100/B48,4)","v":0.60929999999999995}]
["RCR Seawater Organisms (unitless)","0.00733",null,{"$f":"ROUND(D49*B101/B49,4)","v":7.3000000000000001E-3}]
["RCR Marine Sediment Organisms (unitless)","0.00837",null,{"$f":"ROUND(D50*B102/B50,4)","v":8.3999999999999995E-3}]
["RCR Agricultural Soil Organisms (unitless)","0.932",null,{"$f":"ROUND(D52*B103/B52,4)","v":0.93200000000000005}]
["RCR Freshwater (Fish-eating) Predators (unitless)","0.00575",null,{"$f":"ROUND(D54*B104/B54,4)","v":5.7000000000000002E-3}]
["RCR Marine (Fish-eating) Predators (unitless)","0.0000793",null,{"$f":"ROUND(D55*B105/B55,4)","v":1E-4}]
["RCR Marine Top Predators (unitless)","7.88E-7",null,{"$f":"ROUND(D56*B106/B56,4)","v":0}]
["RCR Terrestrial (Worm-eating) Predators (unitless)","0.0329",null,{"$f":"ROUND(D57*B107/B57,4)","v":3.2899999999999999E-2}]
["RCR Human Ingestion (unitless)","0.0000855",null,{"$f":"ROUND(D93*B108/B93,4)","v":1E-4}]
["RCR Human Inhalation (unitless)","0.229",null,{"$f":"ROUND(D96*B109/B96,4)","v":0.22900000000000001}]
["RCR Human Exposure (unitless)","0.230",null,{"$f":"ROUND(D108+D109,4)","v":0.2291}]
["MSafe (kg/d)","4.14E+6",null,{"$f":"D12*1000/MAX(D$98:D$110)","v":4138412.0171673819}]

{"sheet":"HiddenSheet","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,1,"Riverine"]
[null,2,"Marine/Estuary"]

{"sheet":"Database","index":3,"n_rows":23,"n_cols":46,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Max","           Emission Factors         ",null,null,"           Local Default Operating Conditions        ",null,null,null,null,null,"PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","PEC","RCR","RCR","RCR","RCR","RCR","RCR","RCR","RCR","RCR","HI","HI","Total HI","HI - RCR","HI - RCR","HI - RCR","DNEL"]
[null,null,"Local Site Tonnage","Air EF","Water EF","Soil EF","Duration of Site Operation","Wastewater flow","Dilution Factor","Dilution Factor","Sludge","Default removal efficiency","Effluent","Fresh Water","Fresh Water Sediment","Marine Water","Marine Sediment","Natural Soil","Air","Sludge","Ground water","Fish","Leaf","Root","Meat","Milk","Drinking Water","fish.oral","predator.oral","worm.oral","Effluent","Fresh Water","Fresh Water Sediment","Marine Water","Marine Sediment","Natural Soil","fish.oral","predator.oral","worm.oral","Inhalation","Indirect Dose","Total","Inhalation","Indirect Dose","Total","DNEL"]
[null,"Substance","T/yr","%","%","%","days","m3/d","River","Marine","Application","(%)","mg/L","mg/L","mg/kgw","mg/L","mg/kgw","mg/kgw","mg/m3","mg/kgw","mg/L","mg/kgw","mg/kgw","mg/kgw","mg/kgw","mg/kgw","mg/L","mg/kgw","mg/kgw","mg/kgw","--","--","--","--","--","--","--","--","--","ug/kg/d","ug/kg/d","ug/kg/d","--","--","--","ug/kg/d"]
[1,"1   Naphtha",600000,4.9019607843137261E-2,5.3373962081293781E-2,0.01,300,10000,10,100,"N",95.450607185566298,4.9554257271216979,0.49578696948173484,2.5801821761757533,4.9568860421783746E-2,0.25796551318597821,8.4957659779242483E-4,0.24616365171185667,4677.103461071878,2.0942183262792917E-4,10.378663637310867,9.2695480561774386E-4,1.0775406666109694E-3,1.1668590683971132E-3,5.552837631987948E-4,0.20384531876961276,5.1938514522977206,0.1058342377523513,6.0503053562635967E-4,0.50728753059766929,0.79215093546833926,0.90909093838912358,7.9197937778931443E-2,9.0889411477335647E-2,1.4427274471045142E-3,0,0,0,70.332443784684571,22.906083085477668,93.238526870162246,0.70332443784684573,0.22906083085477669,0.93238526870162242,100]
[2,"2   Straight Run Gas Oil",600000,0.1,3.0000000000000001E-3,0.01,300,10000,10,100,"N",94.077257535617903,0.38293997541850161,3.8192515473317645E-2,1.904109131800664,3.8186892724442756E-3,0.19039248920629792,4.7022035150207121E-3,0.45835421765381701,1140.553233973654,4.0280505550815163E-4,4.8153268959705535,1.9851088758347228E-2,1.1099802691063174E-2,8.9519080753384966E-2,2.8356059984810049E-2,1.9098102617425002E-2,3.0603803537870062,0.17878532097459102,7.2636136567566728E-3,0.57154147012675638,0.84388234003811013,0.95523996526153321,8.4380109898890998E-2,9.5514795078026488E-2,9.9065438121593331E-3,0,0,0,130.95829551775142,9.4699345996156801,140.42823011736709,0.10073715039827033,7.2845650766274464E-3,0.10802171547489778,1300]
[3,"3   Cracked Gas Oil",279634.7,0.1,4.4778080175111442E-3,0.01,300,10000,10,100,"N",92.335455721892714,0.34498590149526281,3.4405639676779412E-2,1.6964840648832313,3.4402044556042111E-3,0.16963194041240476,2.9719309395527605E-3,0.21370660572937156,1028.8820693895784,4.5114607448899649E-4,4.9654981232009794,4.7538812895289606E-2,6.6546366476603587E-3,3.8568555438866156E-2,1.2237451589043196E-2,2.0482844675964725E-2,2.6310845370105698,7.7909570452993848E-2,4.1250803538355552E-3,0.53075266091116724,0.80298427944300854,0.90909310268219501,8.0291194594138263E-2,9.0901119670302191E-2,3.9158997926170237E-3,0.15476967864768057,4.5829159089996385E-3,2.4265178551973853E-4,61.059005784779771,9.8582039285091838,70.917209713288955,6.1059005784779768E-2,9.8582039285091839E-3,7.0917209713288951E-2,1000]
[4,"4   Vacuum Gas Oil",600000,0.1,3.0000000000000001E-3,0.01,300,10000,10,100,"N",94.109481144367948,0.36447367953869569,3.6379685681127705E-2,1.4070570244116487,3.6374302102119708E-3,0.14068764179344745,5.6448309813646571E-3,0.45833547298431804,1279.3832884095348,3.7022092539639655E-4,3.9744562222363973,2.6444922661005663E-2,1.435599321346518E-2,0.11895084473172449,3.7641512884357763E-2,1.7457029588243751E-2,2.3402747080421613,0.11202816762641586,9.5049139657524522E-3,0.36018130291349193,0.53521441808855297,0.60605247000104068,5.3515102669763011E-2,6.0598066269429242E-2,1.380472494120683E-2,0,0,0,130.95293990003691,86.136493095290959,217.08943299532785,0.10073303069233608,6.6258840842531516E-2,0.16699187153486761,1300]
[5,"5   Other Gas Oil",600000,0.1,3.0000000000000001E-3,0.01,300,10000,10,100,"N",94.270546286888518,0.35233720773550709,3.5167285670995717E-2,1.3813160132723599,3.5161989482829243E-3,0.13811318936565134,5.4503536796724926E-3,0.45836071808576517,1263.7920435682618,4.0431014256950114E-4,3.737915775194832,2.5881188348591495E-2,1.3443389865135857E-2,0.10759218519584665,3.405193499927376E-2,1.6202465411955025E-2,2.269897532337279,0.11706002322049454,8.8319185896211291E-3,0.33510888701914282,0.4955066071722406,0.56105563657294821,4.9544639834223005E-2,5.6098743850849606E-2,1.2212514675706233E-2,0.13352338425513405,6.8858837188526196E-3,5.1952462291888991E-4,130.96015278327931,7.8567616568054044,138.81691444008473,0.10073857906406102,6.0436628129272342E-3,0.10678224187698825,1300]
[6,"6   Kerosene",600000,0.1,1.1969296205581794E-2,0.01,300,10000,10,100,"N",94.690823152348884,1.2840431496280618,0.12835428220460521,2.2808687169092536,1.2833160613743618E-2,0.22804369892364496,4.4548275044344957E-3,0.4618771404973166,3350.9948230078967,3.4640486964591179E-4,8.3544166168218599,1.1362558153824736E-2,1.047443496561971E-2,6.3347042775773924E-2,2.006992432402542E-2,5.6926320102166229E-2,4.2251954644314402,9.2047405449750874E-2,6.7627338127961003E-3,0.5235336978398617,0.80115534534206756,0.90909138523152244,8.0100547141153486E-2,9.0892135757434961E-2,1.0947217720502509E-2,0,0,0,131.96484449898873,16.037064162450292,148.00190866143902,7.0194066222866343E-3,8.5303532778990918E-4,7.8724419500765426E-3,18800]
[7,"7   MK-1",348754.1,0.1,1E-3,0.01,300,10000,10,100,"N",95.275039497029084,5.4973814639515978E-2,5.4781287376560192E-3,0.37487895768492241,5.4770610233171755E-4,3.7480958474895881E-2,4.8467526178717557E-3,0.26608027716640775,472.44235243639957,8.6094731684358358E-5,1.0152277502945899,5.7413154785989863E-3,1.3825093108941573E-2,0.11903967573861383,3.7640428542706786E-2,2.23759335256557E-3,0.60328843136560784,2.9516572227821263E-2,9.4229021027367049E-3,0.18549351644847711,0.27663754774957811,0.31309172302671129,2.7657882058117811E-2,3.1302525817193505E-2,1.621740871606956E-2,0,0,0,76.022905924084853,2.7196002160991788,78.742506140184034,4.043771591706641E-3,1.4465958596272227E-4,4.188431177669363E-3,18800]
[8,"8   Lubricant Base Oil",1300,1E-3,1E-3,0.01,100,10000,10,100,"N",93.93006118826149,8.8045023051145277E-4,8.7447591257570808E-5,9.6112513396201249E-3,8.7434692818603899E-6,9.6107388777629172E-4,1.9703776569474044E-7,1.0657861265053706E-5,2.8602820531020599,4.2442767380431488E-8,5.637290385127728E-3,6.2027291040099311E-6,7.7326926660250054E-7,2.8480966426832331E-5,9.0109519424298279E-6,1.2760417190421049E-5,5.4775801317270426E-3,7.9448614345413015E-4,7.5130579457844437E-7,2.6969064776158872E-3,3.796764580863015E-3,4.2945986083566057E-3,3.7964972420950142E-4,4.2942960493874254E-4,1.901619792519759E-7,5.8709326170707855E-4,8.5153927487045027E-5,8.0525808636489218E-8,3.045102000545483E-3,2.7504268587057377E-2,3.0549370587602862E-2,4.3501457150649759E-6,3.9291812267224822E-5,4.36419579822898E-5,700]
[9,"9   Unrefined/Acid Treated Oil",5127,0.01,1E-3,0.01,100,10000,10,100,"N",93.617691203444892,3.9150896285746056E-3,3.8773455608719234E-4,5.934190898403801E-2,3.8768228120232548E-5,5.9342669650582248E-3,4.3036640500853663E-6,3.9436206212687194E-4,12.513139868517742,2.9506252131232697E-7,3.134077660969662E-2,2.7284383052802709E-5,9.4058787527903089E-6,9.0205065654405857E-5,2.8537156540361489E-5,6.1736470714784621E-5,3.3224975167964903E-2,6.4749631959682263E-3,7.4597257279230539E-6,1.8689695965384136E-2,2.5845405880708612E-2,2.9228159253198039E-2,2.5844613403665055E-3,2.9227261847495291E-3,6.466935666834099E-6,3.5610905860626904E-3,6.9399391167933831E-4,7.9954187866270673E-7,0.11267482982344185,0.21401647719609462,0.32669130701953647,1.6096404260491692E-4,3.0573782456584946E-4,4.6670186717076638E-4,700]
[10,"10   Distillate Aromatic Extr",78295.8,0.01,1E-3,0.01,300,10000,10,100,"N",81.092358534861816,5.929563438222072E-2,5.8905224070371093E-3,0.61649680375181337,5.8900724867296396E-4,6.1648198685736816E-2,6.9149839790850356E-5,5.9967275388736014E-3,132.11329233865328,3.9553039363387826E-6,1.7089398194118199,7.4340413437093205E-4,1.4865522123327739E-4,1.214870165994265E-3,3.8422314428937705E-4,3.7012506037477988E-3,1.1018937065820784,6.9525470620315902E-2,1.1506740811871494E-4,0.16830286100314409,0.24595527350655808,0.27825384368945316,2.459445266694029E-2,2.7824167839824342E-2,9.8771837849979588E-5,0.11810221935499232,7.4518189303661199E-3,1.2333055532552513E-5,1.713350040052166,2.9351567729994876,4.6485068130516538,2.4476429143602371E-3,4.1930811042849821E-3,6.6407240186452197E-3,700]
[11,"11   Treated DAE",5071.8999999999996,1E-3,1E-3,0.01,100,10000,10,100,"N",71.047540626897046,1.5470106056227197E-2,1.5385985537760254E-3,0.13422696272052029,1.5384911442470491E-4,1.3421808953163764E-2,5.7770395328908762E-7,3.9611157177706279E-5,31.381822530334293,2.6645763037130698E-8,0.14668462940941021,2.6195033835421141E-5,1.2889593314271168E-6,1.2699835339402508E-5,4.0162491836370967E-6,3.3161137071472871E-4,7.4138732838018223E-2,1.6334966610585101E-3,1.4975191835587763E-6,3.4423079577103839E-2,5.258184750855717E-2,5.9498734760352737E-2,5.2578277463503813E-3,5.949469496844338E-3,7.6593993646486224E-7,7.9462736160791237E-3,1.7508002798054771E-4,1.6050580745538867E-7,1.1317468952355204E-2,0.25099942701037981,0.262316895962735,1.6167812789078862E-5,3.5857061001482831E-4,3.7473842280390718E-4,700]
[12,"12   Residual Aromatic Extr",4286.3999999999996,0.01,1E-3,0.01,100,10000,10,100,"N",76.31944897362412,1.1284931303360345E-2,1.1224213997309558E-3,9.726626874064831E-2,1.1223387818731393E-4,9.7259800039155384E-3,3.3491994879651161E-6,3.2801631332427092E-4,24.642809012743502,1.0758998023741623E-7,0.1062170731628263,2.3784319522185004E-5,7.1682856782785802E-6,1.9244769499615947E-5,6.0860329180207066E-6,2.3878893486212912E-4,5.4076559822316773E-2,1.2683342380724507E-3,4.9594121920070876E-6,2.5180779565380226E-2,3.8420958245111256E-2,4.3475655290581249E-2,3.8418250741895539E-3,4.3472591327661436E-3,6.7501326654744996E-6,0,0,0,9.3718909176498527E-2,0.18190060040946818,0.2756195095859667,1.802286714932664E-5,3.4980884694128496E-5,5.3003751843455136E-5,5200]
[13,"13   Heavy Fuel Oil",600000,1E-3,5.5012587165910118E-4,0.01,300,10000,10,100,"N",88.838313015227214,0.12943003325489238,1.2836729972149991E-2,1.6623197603803543,1.2835427437928254E-3,0.16622301181059504,1.3696383671510747E-4,4.6822609708086814E-3,486.27616995777953,5.6800564502754689E-6,3.3418775124844835,9.1058255272242657E-3,3.7804975971432816E-4,1.2589873871483774E-2,3.980747008137356E-3,7.6423225705915749E-3,2.4445521249750888,0.19157840438606299,3.2835766000293039E-4,0.55505588755638746,0.80370355686010009,0.90909105982269811,8.0365605863495546E-2,9.0903731063879958E-2,1.7989761504268509E-4,3.664995689617824E-2,2.8722399458180358E-3,4.9229034483197953E-6,1.3377883136869377,5.952792456059715,7.2905807697466525,6.6889415684346892E-2,0.29763962280298573,0.36452903848733265,20]
[]
[]
[]
[null,null,{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21},{"$f":"COLUMN()","v":22},{"$f":"COLUMN()","v":23},{"$f":"COLUMN()","v":24},{"$f":"COLUMN()","v":25},{"$f":"COLUMN()","v":26},{"$f":"COLUMN()","v":27},{"$f":"COLUMN()","v":28},{"$f":"COLUMN()","v":29},{"$f":"COLUMN()","v":30},{"$f":"COLUMN()","v":31},{"$f":"COLUMN()","v":32},{"$f":"COLUMN()","v":33},{"$f":"COLUMN()","v":34},{"$f":"COLUMN()","v":35},{"$f":"COLUMN()","v":36},{"$f":"COLUMN()","v":37},{"$f":"COLUMN()","v":38},{"$f":"COLUMN()","v":39},{"$f":"COLUMN()","v":40},{"$f":"COLUMN()","v":41},{"$f":"COLUMN()","v":42},{"$f":"COLUMN()","v":43},{"$f":"COLUMN()","v":44},{"$f":"COLUMN()","v":45},46]
[null,"Working Output",{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,C$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,D$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,E$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,F$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,G$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,H$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,I$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,J$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,K$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,L$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,M$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,N$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,O$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,P$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,Q$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,R$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,S$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,T$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,U$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,V$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,W$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,X$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,Y$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,Z$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AA$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AB$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AC$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AD$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AE$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AF$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AG$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AH$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AI$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AJ$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AK$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AL$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AM$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AN$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AO$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AP$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AQ$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AR$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AS$22,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(#REF!,Database!$A$6:$AT$18,AT$22,FALSE)","v":{"$error":"#REF!"}}]