{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Results","Data Input","BOM Entry","Expert Data Input","Saved Scenarios","Material Flows","Use ","Recycling","ED - ES","LCA Calculations"],"not_rendered":{"charts":11,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"Results","index":0,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[1,1,1,5],[0,0,0,9]]}
["Results"]
[]
[]
[]
[]
[]
[null,null,null,"Baseline","Contender 1","Contender 2"]
[null,null,"Production",{"$f":"B25","v":8890.659807052094},{"$f":"B26","v":7986.8577438489929},{"$f":"B27","v":10894.384331309513}]
[null,2,{"$f":"B9*'Data Input'!$H$13/10","v":30000},{"$f":"$D$8+B9*$C$25/10","v":11365.705755834048},{"$f":"$E$8+B9*$C$26/10","v":10327.501700526092},{"$f":"$F$8+B9*$C$27/10","v":13192.019650513059}]
[null,4,{"$f":"B10*'Data Input'!$H$13/10","v":60000},{"$f":"$D$8+B10*$C$25/10","v":13840.751704616001},{"$f":"$E$8+B10*$C$26/10","v":12668.145657203191},{"$f":"$F$8+B10*$C$27/10","v":15489.654969716605}]
[null,6,{"$f":"B11*'Data Input'!$H$13/10","v":90000},{"$f":"$D$8+B11*$C$25/10","v":16315.797653397954},{"$f":"$E$8+B11*$C$26/10","v":15008.78961388029},{"$f":"$F$8+B11*$C$27/10","v":17787.29028892015}]
[null,8,{"$f":"B12*'Data Input'!$H$13/10","v":120000},{"$f":"$D$8+B12*$C$25/10","v":18790.843602179906},{"$f":"$E$8+B12*$C$26/10","v":17349.43357055739},{"$f":"$F$8+B12*$C$27/10","v":20084.925608123696}]
[null,10,{"$f":"B13*'Data Input'!$H$13/10","v":150000},{"$f":"$D$8+B13*$C$25/10","v":21265.88955096186},{"$f":"$E$8+B13*$C$26/10","v":19690.077527234487},{"$f":"$F$8+B13*$C$27/10","v":22382.560927327242}]
[null,null,"Total",{"$f":"E25","v":18064.368679354779},{"$f":"E26","v":16913.665991431382},{"$f":"E27","v":17843.212684752907}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["GHG Emissions (in kg CO2 eq)","Production","Use","End of Life","Total","Prod & EOL","Prod & Use"]
["Baseline",{"$f":"'LCA Calculations'!I118","v":8890.659807052094},{"$f":"'LCA Calculations'!J118","v":12375.229743909767},{"$f":"'LCA Calculations'!K118","v":-3201.5208716070797},{"$f":"B25+C25+D25","v":18064.368679354779},{"$f":"B25+D25","v":5689.1389354450148},{"$f":"B25+C25","v":21265.88955096186}]
["Contender 1",{"$f":"'LCA Calculations'!I119","v":7986.8577438489929},{"$f":"'LCA Calculations'!J119","v":11703.219783385495},{"$f":"'LCA Calculations'!K119","v":-2776.4115358031036},{"$f":"B26+C26+D26","v":16913.665991431382},{"$f":"B26+D26","v":5210.4462080458889},{"$f":"B26+C26","v":19690.077527234487}]
["Contender 2",{"$f":"'LCA Calculations'!I120","v":10894.384331309513},{"$f":"'LCA Calculations'!J120","v":11488.176596017729},{"$f":"'LCA Calculations'!K120","v":-4539.3482425743332},{"$f":"B27+C27+D27","v":17843.212684752907},{"$f":"B27+D27","v":6355.0360887351799},{"$f":"B27+C27","v":22382.560927327242}]
["Baseline - Contender Vehicle 1",{"$f":"B25-B26","v":903.80206320310117},672.00996052427217,-425.10933580397614,1150.7026879233963,478.69272739912594,1575.8120237273724]
["Baseline - Contender Vehicle 2",{"$f":"B25-B27","v":-2003.724524257419},887.0531478920384,1337.8273709672535,221.1559946018715,-665.89715329016508,-1116.6713763653825]
["Contender Vehicle 1 - Contender Vehicle 2",{"$f":"B26-B27","v":-2907.5265874605202},215.04318736776622,1762.9367067712296,-929.5466933215248,-1144.589880689291,-2692.4834000927549]
[]
[]
[]
[]
[null,null,null,"Baseline","Contender 1","Contender 2"]
[null,null,"Production",{"$f":"B53","v":128260.80149502995},{"$f":"B54","v":116117.33908649349},{"$f":"B55","v":149296.39035066636}]
[null,2,{"$f":"B37*'Data Input'!$H$13/10","v":30000},{"$f":"$D$36+B37*$C$53/10","v":169413.58449140447},{"$f":"$E$36+B37*$C$54/10","v":155035.40962506758},{"$f":"$F$36+B37*$C$55/10","v":187499.35290274431}]
[null,4,{"$f":"B38*'Data Input'!$H$13/10","v":60000},{"$f":"$D$36+B38*$C$53/10","v":210566.367487779},{"$f":"$E$36+B38*$C$54/10","v":193953.48016364168},{"$f":"$F$36+B38*$C$55/10","v":225702.31545482227}]
[null,6,{"$f":"B39*'Data Input'!$H$13/10","v":90000},251719.15048415351,232871.55070221575,263905.27800690022]
[null,8,{"$f":"B40*'Data Input'!$H$13/10","v":120000},292871.93348052801,271789.62124078983,302108.24055897817]
[null,10,{"$f":"B41*'Data Input'!$H$13/10","v":150000},334024.71647690254,310707.6917793639,340311.20311105612]
[null,null,"Total",{"$f":"E53","v":289719.41300278908},{"$f":"E54","v":271969.07748428528},{"$f":"E55","v":281559.06604217266}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Energy Requirements (in MJ)","Production","Use","End of Life","Total","Prod & EOL","Prod & Use"]
[{"$f":"A25","v":"Baseline"},{"$f":"'LCA Calculations'!I123","v":128260.80149502995},{"$f":"'LCA Calculations'!J123","v":205763.91498187257},{"$f":"'LCA Calculations'!K123","v":-44305.30347411344},{"$f":"B53+C53+D53","v":289719.41300278908},{"$f":"B53+D53","v":83955.498020916508},{"$f":"B53+C53","v":334024.71647690254}]
["Contender 1",{"$f":"'LCA Calculations'!I124","v":116117.33908649349},{"$f":"'LCA Calculations'!J124","v":194590.35269287042},{"$f":"'LCA Calculations'!K124","v":-38738.614295078638},{"$f":"B54+C54+D54","v":271969.07748428528},{"$f":"B54+D54","v":77378.724791414861},{"$f":"B54+C54","v":310707.6917793639}]
["Contender 2",{"$f":"'LCA Calculations'!I125","v":149296.39035066636},{"$f":"'LCA Calculations'!J125","v":191014.81276038976},{"$f":"'LCA Calculations'!K125","v":-58752.137068883443},{"$f":"B55+C55+D55","v":281559.06604217266},{"$f":"B55+D55","v":90544.25328178292},{"$f":"B55+C55","v":340311.20311105612}]
["Baseline - Contender Vehicle 1",{"$f":"B53-B54","v":12143.462408536463},11173.562289002148,-5566.6891790348018,{"$f":"E53-E54","v":17750.335518503794},{"$f":"F53-F54","v":6576.7732295016467},{"$f":"G53-G54","v":23317.02469753864}]
["Baseline - Contender Vehicle 2",{"$f":"B53-B55","v":-21035.588855636408},14749.102221482812,14446.833594770003,{"$f":"E53-E55","v":8160.3469606164144},{"$f":"F53-F55","v":-6588.7552608664118},{"$f":"G53-G55","v":-6286.4866341535817}]
["Contender Vehicle 1 - Contender Vehicle 2",{"$f":"B54-B55","v":-33179.051264172871},3575.539932480664,{"$f":"D54-D55","v":20013.522773804805},{"$f":"E54-E55","v":-9589.98855788738},{"$f":"F54-F55","v":-13165.528490368059},{"$f":"G54-G55","v":-29603.511331692222}]
[]
[]
[]
[]
[null,null,null,"Baseline","Contender 1","Contender 2"]
[null,null,"Production",{"$f":"B81","v":116877.84994805377},{"$f":"B82","v":105956.71634044989},{"$f":"B83","v":133471.96059284805}]
[null,2,{"$f":"B65*'Data Input'!$H$13/10","v":30000},{"$f":"$D$64+B65*$C$81/10","v":149110.81791073136},{"$f":"$E$64+B65*$C$82/10","v":136439.34301844635},{"$f":"$F$64+B65*$C$83/10","v":163394.47805974656}]
[null,4,{"$f":"B66*'Data Input'!$H$13/10","v":60000},{"$f":"$D$64+B66*$C$81/10","v":181343.78587340895},{"$f":"$E$64+B66*$C$82/10","v":166921.9696964428},{"$f":"$F$64+B66*$C$83/10","v":193316.99552664504}]
[null,6,{"$f":"B67*'Data Input'!$H$13/10","v":90000},213576.75383608651,197404.59637443925,223239.51299354355]
[null,8,{"$f":"B68*'Data Input'!$H$13/10","v":120000},245809.72179876411,227887.22305243573,253162.03046044207]
[null,10,{"$f":"B69*'Data Input'!$H$13/10","v":150000},278042.68976144167,258369.84973043215,283084.54792734055]
[null,null,"Total",{"$f":"E81","v":237214.98006872821},{"$f":"E82","v":222671.11605529516},{"$f":"E83","v":231245.15151476816}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fossil Energy Requirements (in MJ)","Production","Use","End of Life","Total","Prod & EOL","Prod & Use"]
[{"$f":"A25","v":"Baseline"},{"$f":"'LCA Calculations'!I128","v":116877.84994805377},{"$f":"'LCA Calculations'!J128","v":161164.83981338792},{"$f":"'LCA Calculations'!K128","v":-40827.709692713455},{"$f":"B81+C81+D81","v":237214.98006872821},{"$f":"B81+D81","v":76050.140255340317},{"$f":"B81+C81","v":278042.68976144167}]
["Contender 1",{"$f":"'LCA Calculations'!I129","v":105956.71634044989},{"$f":"'LCA Calculations'!J129","v":152413.13338998228},{"$f":"'LCA Calculations'!K129","v":-35698.733675136988},{"$f":"B82+C82+D82","v":222671.11605529516},{"$f":"B82+D82","v":70257.982665312898},{"$f":"B82+C82","v":258369.84973043215}]
["Contender 2",{"$f":"'LCA Calculations'!I130","v":133471.96059284805},{"$f":"'LCA Calculations'!J130","v":149612.58733449251},{"$f":"'LCA Calculations'!K130","v":-51839.396412572387},{"$f":"B83+C83+D83","v":231245.15151476816},{"$f":"B83+D83","v":81632.564180275658},{"$f":"B83+C83","v":283084.54792734055}]
["Baseline - Contender Vehicle 1",{"$f":"B81-B82","v":10921.133607603886},8751.7064234056452,-5128.9760175764677,{"$f":"E81-E82","v":14543.864013433049},{"$f":"F81-F82","v":5792.1575900274183},{"$f":"G81-G82","v":19672.840031009517}]
["Baseline - Contender Vehicle 2",{"$f":"B81-B83","v":-16594.110644794273},11552.252478895418,11011.686719858932,{"$f":"E81-E83","v":5969.8285539600474},{"$f":"F81-F83","v":-5582.4239249353413},{"$f":"G81-G83","v":-5041.8581658988842}]
["Contender Vehicle 1 - Contender Vehicle 2",{"$f":"B82-B83","v":-27515.244252398159},2800.5460554897727,16140.662737435399,{"$f":"E82-E83","v":-8574.0354594730015},{"$f":"F82-F83","v":-11374.58151496276},{"$f":"G82-G83","v":-24714.698196908401}]

{"sheet":"Data Input","index":1,"n_rows":111,"n_cols":27,"rows_kept":111,"cut":false,"hidden":false,"merged":[[9,15,9,16],[11,15,11,16],[0,1,0,17],[0,18,0,25],[8,15,8,16],[6,15,6,16],[5,15,5,16]]}
[null,"UCSB Automotive Energy and Greenhouse Gas Model",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 5.1 - Release Date 25 October 2024"]
[]
[null,"Powertrain, Vehicle Class,  & Driving Cycle"]
[null,"Power train",null,null,null,null,null,"BEV",null,"Biofuel Content"]
[null,"Vehicle class",null,null,null,null,null,null,null,null,null,null,null,"For ICEV-G, HEV, and PHEV only:",null,null,null,null,null,"Guide to Inputs/Outputs"]
[null,null,"ICEV, HEV, FCV: Compact, Mid-Size, SUV",null,null,null,null,"FSV A-Class",null,null,null,null,null,"Volumetric ethanol content",null,0]
[null,null,"BEV, PHEV: FSV A-Class, FSV C-Class",null,null,null,null,null,null,null,null,null,null,"Ethanol source",null,"Corn",null,null,null,null,"Blue: User inputs (used within the same and/or in other spreadsheets)"]
[null,"Driving cycle",null,null,null,null,null,"WLTP 3b",null,null,null,null,null,"For ICEV-D only:",null,null,null,null,null,null,"Light Blue: Model input data that should only be changed by expert users"]
[null,"Powertrain resize for equivalent performance?",null,null,null,null,null,"Yes",null,null,null,null,null,"Volumetric biodiesel content",null,0,null,null,null,null,"Green: Intermediate results used within the spreadsheet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Biodiesel source",null,"Soybeans",null,null,null,null,"Orange: Outputs that are used in another spreadsheet"]
[null,"Lifetime vehicle mileage TM",null,null,null,null,"km",200000,null,"Electricity Source",null,null,null,null,null,null,null,null,null,null,"Pink: Inputs that come from another spreadsheet"]
[null,null,null,null,null,null,"miles",{"$f":"H11/1.609","v":124300.80795525172},null,null,null,null,null," (for BEV and PHEV only):",null,"USA",null,null,null,null,"White: Data that is displayed for information only, and not used to calculate results"]
[null,null,null,null,null,"Suggested value for selected power train","km",{"$f":"IF(OR(H4=\"BEV\",H4=\"PHEV20\",H4=\"PHEV40\"),150000,200000)","v":150000}]
[null,null,null,null,null,null,"miles",{"$f":"H13/1.609","v":93225.605966438787}]
[]
[null,"Bill of Materials",null,null,null,null,null,"Material Replacement Coefficients (to mild steel)",null,null,null,null,null,null,null,null,"Final Material Composition"]
[null,"BOM-based data entry?",null,null,null,"No",null,null,null,"Contender Vehicle 1",null,null,"Contender Vehicle 2",null,null,null,null,null,"Baseline",null,null,"Contender 1",null,null,"Contender 2"]
[null,null,"If yes, only select use phase parameters",null,null,null,null,null,"AHSS  ks",0.75,"kg / kg",null,0.75,"kg / kg",null,null,null,"Material","kg","% of mass",null,"kg","% of mass",null,"kg","% of mass"]
[null,null,"and then go to BOM Entry spreadsheet.",null,null,null,null,null,"Aluminum  ka",0.67,"kg / kg",null,0.67,"kg / kg",null,null,null,"Flat carbon steel",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B5*CWminus)","v":325.82927564214719},{"$f":"IF(F$17=\"Yes\",\"-----n/a-----\",S19/$S$39)","v":0.4},null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S19-B35-$J$41*Sc*'Expert Data Input'!D6)","v":66.865887442147212},{"$f":"IF(F$17=\"Yes\",\"-----n/a-----\",V19/$V$39)","v":9.2440534138423694E-2},null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S19-B35-$M$41*Sc*'Expert Data Input'!D6)","v":64.844709778147219},{"$f":"IF(F$17=\"Yes\",\"-----n/a-----\",Y19/$Y$39)","v":9.3416705519124912E-2}]
[null,null,null,null,null,null,null,null,"FRP kc",0.55000000000000004,"kg / kg",null,0.55000000000000004,"kg / kg",null,null,null,"Long & special steel",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B6*CWminus)","v":122.1859783658052},0.15,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S20-B36-$J$41*Sc*'Expert Data Input'!D7)","v":89.903279565805207},0.12428919291693453,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S20-B36-$M$41*Sc*'Expert Data Input'!D7)","v":88.555827789805207},0.12757546012536014]
[null,"Baseline Vehicle Mass",null,null,null,null,null,null,"Magnesium km",0.5,"kg / kg",null,0.5,"kg / kg",null,null,null,"Cast iron and steel",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B7*CWminus)","v":81.457318910536799},0.1,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S21-B37-$J$41*Sc*'Expert Data Input'!D8)","v":81.457318910536799},0.11261284875773031,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S21-B37-$M$41*Sc*'Expert Data Input'!D8)","v":81.457318910536799},0.11734919315819757]
[null,{"$f":"B24","v":1063.33}," Vehicle mass VMb (in kg)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat AHSS",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B8*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S22+K26)","v":189.48540599999998},0.26195916650670553,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S22+N26)","v":0},0]
[null,{"$f":"CWc*2.20462262","v":2344.2413705245999}," Vehicle mass VMb (in lbs)",null,null,null,null,"Composition of replacing material",null,null,null,null,null,null,null,null,null,"Long & special AHSS",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B9*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S23+K27)","v":21.053933999999998},2.9106574056300613E-2,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S23+N27)","v":0},0]
[null,{"$f":"'ED - ES'!B52","v":1063.33}," Default VMb (in kg)",null,null,null,null,null,null,"Contender Vehicle 1",null,null,"Contender Vehicle 2",null,null,null,null,"Cast AHSS",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B10*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S24+K28)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S24+N28)","v":0},0]
[null,{"$f":"B24*2.20462262","v":2344.2413705245999}," Default VMb (in lbs)",null,null,null,null,null,null,"% of ∆M","kg",null,"% of ∆M","kg",null,null,null,"Rolled aluminum",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B11*CWminus)","v":8.1457318910536802},0.01,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S25+K29-$J$41*Sc*'Expert Data Input'!D9)","v":6.0403384910536797},8.350627470142969E-3,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S25+N29-$M$41*Sc*'Expert Data Input'!D9)","v":137.02387988305367},0.19739959481531827]
[null,null,null,null,null,null,null,null,"Flat AHSS",0.9,{"$f":"J26*($B$38*KSc)","v":189.48540599999998},null,0,{"$f":"M26*$B$38*M18","v":0},null,null,null,"Extruded aluminum",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B12*CWminus)","v":8.1457318910536802},0.01,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S26+K30-$J$41*Sc*'Expert Data Input'!D10)","v":6.0403384910536797},8.350627470142969E-3,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S26+N30-$M$41*Sc*'Expert Data Input'!D10)","v":61.791155723053684},8.9017688838699677E-2]
[null,"Mass of Removed Material",null,null,null,null,null,null,"Long & special AHSS",0.1,{"$f":"J27*($B$38*KSc)","v":21.053933999999998},null,0,{"$f":"M27*$B$38*M18","v":0},null,null,null,"Cast aluminum",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B13*CWminus)","v":40.728659455268399},0.05,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S27+K31-$J$41*Sc*'Expert Data Input'!D11)","v":34.412479255268401},4.7574452161974971E-2,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S27+N31-$M$41*Sc*'Expert Data Input'!D11)","v":32.391301591268402},4.6663616700346647E-2]
[null,{"$f":"B30","v":280.71911999999998}," Removed material ∆M (in kg)",null,null,null,null,null,"Cast AHSS",0,{"$f":"J28*($B$38*KSc/100)","v":0},null,0,{"$f":"M28*$B$38*M18","v":0},null,null,null,"Rolled magnesium",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B14*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S28+K32)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S28+N32)","v":0},0]
[null,{"$f":"DMc*2.20462262","v":618.87972181849432}," Removed material ∆M (in lbs)",null,null,null,null,null,"Rolled aluminum",0,{"$f":"J29*($B$38*KAc)","v":0},null,0.7,{"$f":"M29*$B$38*M19","v":131.65726727999999},null,null,null,"Cast magnesium",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B15*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S29+K33)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S29+N33)","v":0},0]
[null,{"$f":"'ED - ES'!B56","v":280.71911999999998}," Default body structure (in kg)",null,null,null,null,null,"Extruded aluminum",0,{"$f":"J30*($B$38*KAc)","v":0},null,0.3,{"$f":"M30*$B$38*M19","v":56.424543119999996},null,null,null,"SMC",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B16*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S30+K34)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S30+N34)","v":0},0]
[null,{"$f":"B30*2.20462262","v":618.87972181849432}," Default body structure (in lbs)",null,null,null,null,null,"Cast aluminum",0,{"$f":"J31*($B$38*KAc)","v":0},null,0,{"$f":"M31*$B$38*M19","v":0},null,null,null,"GFRP",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B17*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S31+K35)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S31+N35)","v":0},0]
[null,null,null,null,null,null,null,null,"Rolled magnesium",0,{"$f":"J32*($B$38*KMc)","v":0},null,0,{"$f":"M32*$B$38*M21","v":0},null,null,null,"CFRP",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B18*CWminus)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S32+K36)","v":0},0,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S32+N36)","v":0},0]
[null,"Composition of Removed Material",null,null,null,null,null,null,"Cast magnesium",0,{"$f":"J33*($B$38*KMc)","v":0},null,0,{"$f":"M33*$B$38*M21","v":0},null,null,null,"Plastic",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B19*CWminus)","v":97.748782692644156},0.12,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S33)","v":97.748782692644156},0.13513541850927638,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S33)","v":97.748782692644156},0.14081903178983707]
[null,"kg","% of ∆M",null,null,null,null,null,"SMC",0,{"$f":"J34*($B$38*KCc)","v":0},null,0,{"$f":"M34*$B$38*M20","v":0},null,null,null,"Rubber (excluding tires)",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B20*CWminus)","v":24.437195673161039},0.03,null,24.437195673161039,3.3783854627319095E-2,null,24.437195673161039,3.5204757947459267E-2]
[null,{"$f":"0.9*DMc","v":252.64720799999998},{"$f":"B35/DMc","v":0.9},"Flat carbon steel",null,null,null,null,"GFRP",0,{"$f":"J35*($B$38*KCc)","v":0},null,0,{"$f":"M35*$B$38*M20","v":0},null,null,null,"Glass",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B21*CWminus)","v":24.437195673161039},0.03,null,24.437195673161039,3.3783854627319095E-2,null,24.437195673161039,3.5204757947459267E-2]
[null,{"$f":"0.1*DMc","v":28.071911999999998},{"$f":"B36/DMc","v":0.1},"Long & special steel",null,null,null,null,"CFRP",0,{"$f":"J36*($B$38*KCc)","v":0},null,0,{"$f":"M36*$B$38*M20","v":0},null,null,null,"Copper",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B22*CWminus)","v":16.29146378210736},0.02,null,16.29146378210736,2.2522569751546064E-2,null,16.29146378210736,2.3469838631639515E-2]
[null,0,{"$f":"B37/DMc","v":0},"Cast iron and steel",null,null,null,null,"Totals",{"$f":"SUM(J26:J36)","v":1},{"$f":"SUM(K26:K36)","v":210.53933999999998},null,{"$f":"SUM(M26:M36)","v":1},{"$f":"SUM(N26:N36)","v":188.08181039999999},null,null,null,"Stainless steel",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B23*CWminus)","v":0},0,null,0,0,null,0,0]
[null,{"$f":"SUM(B35:B37)","v":280.71911999999998},{"$f":"SUM(C35:C37)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other",{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B24*CWminus)","v":65.165855128429314},7.9999999999999849E-2,null,65.165855128429314,9.0090279006184076E-2,null,65.165855128429314,9.3879354526557879E-2]
[null,null,null,null,null,null,null,"Primary Mass Savings",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",CW-SUM(S40:S43))","v":814.57318910536799},null,null,{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",SUM(V19:V38))","v":723.33947510536768},1,null,{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",SUM(Y19:Y38))","v":694.14468662536774},1]
[null,"Secondary Mass savings s",null,null,null,null,null,null,null,"Contender Vehicle 1",null,null,"Contender Vehicle 2",null,null,null,null,"Battery",{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",'ED - ES'!B61)","v":177.25681089463191},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",(SUM(V19:V38)+SUM(V41:V43))*'ED - ES'!B72)","v":159.00572578275643},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",(SUM(Y19:Y38)+SUM(Y41:Y43))*'ED - ES'!B72)","v":153.1653785469563}]
[null,0.3," of Primary Mass Savings",null,null,null,null,null,null,{"$f":"DMc-K37","v":70.179779999999994},"kg",null,{"$f":"DMc-N37","v":92.63730959999998},"kg",null,null,null,"Fuel cell",{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",0)","v":0},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S41)","v":0},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluids",{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",'Expert Data Input'!B73)","v":11.5},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S42)","v":11.5},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S42)","v":11.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tires",{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",4*'Expert Data Input'!D20)","v":60},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S43)","v":60},null,null,{"$f":"IF(BOM=\"Yes\",\"-----n/a-----\",S43)","v":60}]
[null," Scenario Recorder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle mass VM",{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",SUM(S39:S43))","v":1063.33},null,null,{"$f":"IF(B23=\"Yes\",\"-----n/a-----\",SUM(V39:V43))","v":953.84520088812405},null,null,{"$f":"IF(B29=\"Yes\",\"-----n/a-----\",SUM(Y39:Y43))","v":918.81006517232402}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",S44-V44)","v":109.48479911187587},{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",V45/B22)","v":0.10296408369168168},null,{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",S44-Y44)","v":144.51993482767591},{"$f":"IF(F17=\"Yes\",\"-----n/a-----\",Y45/B22)","v":0.1359125904730196}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FSV A-Class"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FSV C-Class"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compact"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mid-size"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUV"]

{"sheet":"BOM Entry","index":2,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,5,1,6],[1,2,1,3]]}
["Material Composition of Contender Vehicles"]
[null,null,"Baseline Vehicle",null,null,"Contender Vehicle 1",null,null,"Contender Vehicle 2"]
[null,null,"kg","% of mass",null,"kg","% of mass",null,"kg","% of mass"]
["Flat carbon steel",null,620.5,{"$f":"C4/C$24","v":0.40003868222551742},null,288.39999999999998,{"$f":"F4/F$24","v":0.20110173628059413},null,285.8,{"$f":"I4/I$24","v":0.20462518794300855}]
["Long & special steel",null,232.7,{"$f":"C5/C$24","v":0.15002256463155181},null,191.3,{"$f":"F5/F$24","v":0.1333937661250959},null,189.6,{"$f":"I5/I$24","v":0.13574855015393428}]
["Cast iron",null,155.1,9.9993552962413773E-2,null,155.1,0.10815145387350954,null,155.1,0.11104746903415194]
["Flat AHSS",null,0,{"$f":"C7/C$24","v":0},null,243,{"$f":"F7/F$24","v":0.1694442507495991},null,0,{"$f":"I7/I$24","v":0}]
["Long & special AHSS",null,0,0,null,27,1.8827138972177675E-2,null,0,0]
["Cast AHSS",null,0,0,null,0,0,null,0,0]
["Rolled aluminum",null,15.5,9.9929082586551494E-3,null,12.8,8.9254584756990468E-3,null,180.8,0.12944798453497533]
["Extruded aluminum",null,15.5,9.9929082586551494E-3,null,12.8,8.9254584756990468E-3,null,84.3,6.0356554736163817E-2]
["Cast aluminum",null,77.599999999999994,5.0029011669138028E-2,null,69.5,4.8462450317272164E-2,null,66.900000000000006,4.7898618171404034E-2]
["Rolled magnesium",null,0,0,null,0,0,null,0,0]
["Cast magnesium",null,0,0,null,0,0,null,0,0]
["SMC",null,0,0,null,0,0,null,0,0]
["GFRP",null,0,0,null,0,0,null,0,0]
["CFRP",null,0,0,null,0,0,null,0,0]
["Plastic",null,186.1,0.11997936947972407,null,186.1,0.12976779861934318,null,186.1,0.13324264337366651]
["Rubber",null,46.5,2.9978724775965446E-2,null,46.5,3.242451711875044E-2,null,46.5,3.3292761509271858E-2]
["Glass",null,46.5,2.9978724775965446E-2,null,46.5,3.242451711875044E-2,null,46.5,3.3292761509271858E-2]
["Copper",null,31,1.9985816517310299E-2,null,31,2.161634474583363E-2,null,31,2.2195174339514574E-2]
["Stainless steel",null,0,0,null,0,0,null,0,0]
["Other",null,124.1,8.0007736445103478E-2,null,124.1,8.653510912767591E-2,null,124.1,8.8852294694637374E-2]
["VM w/o battery, fuel cell, fluids, and tires",null,{"$f":"SUM(C4:C23)","v":1551.1},{"$f":"SUM(D4:D23)","v":1},null,{"$f":"SUM(F4:F23)","v":1434.0999999999997},{"$f":"SUM(G4:G23)","v":1.0000000000000002},null,{"$f":"SUM(I4:I23)","v":1396.6999999999998},{"$f":"SUM(J4:J23)","v":1.0000000000000002}]
["Battery",null,0,null,null,0,null,null,0]
["Fuel cell",null,0,null,null,0,null,null,0]
["Fluids",null,28.8,null,null,28.8,null,null,28.8]
["Tires",null,60,null,null,60,null,null,60]
["Vehicle mass VM",null,{"$f":"SUM(C24:C28)","v":1639.8999999999999},null,null,{"$f":"SUM(F24:F28)","v":1522.8999999999996},null,null,{"$f":"SUM(I24:I28)","v":1485.4999999999998}]
["Total Mass Savings (in kg and % of VMb)",null,null,null,null,{"$f":"C29-F29","v":117.00000000000023},{"$f":"F30/C29","v":7.1345813769132405E-2},null,{"$f":"C29-I29","v":154.40000000000009},{"$f":"I30/C29","v":9.415208244405153E-2}]
[]
["        Important note 1: Make sure that the power train and vehicle class selections on the Data Input Spreadsheet matches the vehicle mass VM on this spreadsheet."]
[]
["        Important note 2: Don't forget to select the Vehicle Use parameters on the Data Input Spreadsheet."]

{"sheet":"Expert Data Input","index":3,"n_rows":97,"n_cols":13,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"EXPERT DATA INPUT"]
[]
[null,"Material Composition (in %)",null,"Composition of secondary savings",null,"Recycling methodology selection"]
["Flat carbon steel",0.4,null,"% of s(1-k)∆M",null,null,"α","alpha [0,1]: impact of scrap flows from and to the vehicle life cycles"]
["Long & special steel",0.15,"Flat carbon steel",0.3,"WSA","Flat carbon steel",0.9," on external scrap collection and recycling"]
["Cast iron and steel",0.1,"Long & special steel",0.2,"WSA","Long & special steel",0.9,"1 = external scrap collection is completely inelastic (avoided burden)"]
["Flat AHSS",0,"Cast iron",0,"WSA","Cast iron and steel",0.9,"0 = external recycling is completely inelastic (recycled content)"]
["Long & special AHSS",0,"Rolled aluminum",0.1,"WSA","Flat AHSS",0.9]
["Cast AHSS",0,"Extruded aluminum",0.1,"WSA","Long & special AHSS",0.9]
["Rolled aluminum",0.01,"Cast aluminum",0.3,"WSA","Cast AHSS",0.9]
["Extruded aluminum",0.01,"Totals",{"$f":"SUM(D6:D11)","v":1},null,"Rolled aluminum",0.9]
["Cast aluminum",0.05,null,{"$f":"IF(D12=1,\"\",\"Total must add up to 100%\")","v":""},null,"Extruded aluminum",0.9]
["Rolled magnesium",0,"Fraction of Mg by Pidgeon process",0.7,null,"Cast aluminum",0.9]
["Cast magnesium",0,"Primary aluminum source","Global",null,"Rolled magnesium",0.9]
["SMC",0,"Fraction of flat steel that is HRC",0.25,"WSA","Cast magnesium",0.9]
["GFRP",0,"Fraction of rubber compression molded",0.89,"GREET 2 2023","SMC",0.9]
["CFRP",0,null,null,null,"GFRP",0.9]
["Plastic",0.12,null,"Tires",null,"CFRP",0.9]
["Rubber (excluding tires)",0.03,"Mass of 1 tire",15,"kg","Stainless steel",0.9]
["Glass",0.03,"Change interval",70000,"km"]
["Copper",0.02,"# of tire sets",{"$f":"CEILING('Data Input'!H11/D21,1)","v":3}]
["Stainless steel",0,"% steel in tires",{"$f":"1/3","v":0.33333333333333331},"GREET 2 2023"]
["Other",{"$f":"1-SUM(B5:B23)","v":7.9999999999999849E-2}]
["TOTAL",{"$f":"SUM(B5:B24)","v":1}]
[]
[null,"Battery (for BEV and PHEV only)"]
["Energy density",0.17699999999999999,"KWh/kg (GREET 2 2023)"]
["Charging Efficiency",0.9]
["Battery life",150000,"km"]
["Number of batteries",{"$f":"CEILING('Data Input'!H11/B30,1)","v":2}]
[null,0.5,"% pyrometallurgically recycled"]
[]
[null,"For PHEV only"]
["Energy from electricity",0.5]
[]
[null,"Liquid Fuel Densities"]
[null,"MJ/liter"]
["Gasoline",{"$f":"42.5*0.75","v":31.875},"MJ/liter"]
["Bioethanol",21.1,"MJ/liter"]
["Diesel",{"$f":"42.8*0.84","v":35.951999999999998},"MJ/liter"]
["Biodiesel",32.64,"MJ/liter"]
[]
[null,null,null,null,"Blow Molding (HDPE)",null,"Compression Molding",null,"Extrusion (PVC)",null,"Injection Molding (HDPE)",null,"Injection Molding (PP)"]
["Polymer Production and Forming",null,null,"kgin/kgout",1.0003,1.1554,1,0.94589999999999996,1.0024,1.0018,1.0056,1.0306999999999999,1.1393]
[null,null,null,null,null,"Calendaring (PVC)",null,"Extrusion (HDPE)",null,"Extrusion (PP)",null,"Injection Molding (PVC)"]
[null,"kg resin produced / kg plastic in vehicle","w% content","kgin/kgout"]
["ABS",{"$f":"D48*C48","v":8.1494921599999992E-2},7.5999999999999998E-2,{"$f":"IF(SUMPRODUCT($E$45:$M$45,E48:M48)=0,1,SUMPRODUCT($E$45:$M$45,E48:M48))","v":1.0723015999999999},0,0,0.23799999999999999,0.17499999999999999,0,0,0,0,0.58699999999999997]
["EPDM",{"$f":"D49*C49","v":7.395915929999998E-2},7.0999999999999994E-2,1.0416782999999998,0,0,0.31900000000000001,0.27500000000000002,0,0,0,0,0.40599999999999992]
["Liquid Epoxy",{"$f":"D50*C50","v":0.107},0.107,1]
["GPPS",{"$f":"D51*C51","v":7.0000000000000001E-3},7.0000000000000001E-3,1]
["HDPE",{"$f":"D53*C53","v":7.0000000000000001E-3},1.4E-2,0.99871975000000002,0,0,0.24249999999999999,9.2499999999999999E-2,0,0,0.66500000000000004,0,0]
["HIPS",{"$f":"D52*C52","v":1.3982076500000001E-2},7.0000000000000001E-3,1]
["LDPE",{"$f":"D54*C54","v":1.3982076500000001E-2},1.4E-2,0.99871975000000002,0,0,0.24249999999999999,9.2499999999999999E-2,0,0,0.66500000000000004,0,0]
["LLDPE",1.3982076500000001E-2,1.4E-2,0.99871975000000002,0,0,0.24249999999999999,9.2499999999999999E-2,0,0,0.66500000000000004,0,0]
["Nylon 6",1.1280079799999999E-2,1.0999999999999999E-2,1.0254618,0.36399999999999999,0,0.45400000000000001,0,0,0,0,0,0.18199999999999994]
["Nylon 66",7.235854500000001E-2,7.0000000000000007E-2,1.0336935,0,0,0.34300000000000003,0.29899999999999999,0,0,0,0,0.35799999999999998]
["PC",3.8802890000000007E-2,3.5000000000000003E-2,1.108654,0,0,0.22,0,0,0,0,0,0.78]
["PET",1.818405E-2,1.7000000000000001E-2,1.06965,0,0,0.5,0,0,0,0,0,0.5]
["PP",0.19956061060999999,0.18099999999999999,1.1025448099999999,9.1999999999999998E-2,0,0.15329999999999999,0,0,1.9E-2,0,0,0.73570000000000002]
["PUR Flexible Foam",0.122,0.122,1]
["PUR Rigid Foam",0.11600000000000001,0.11600000000000001,1]
["PVC",0.14329214819999989,0.1379999999999999,1.0383488999999999,0,0.18099999999999999,1.4999999999999999E-2,0,0.51100000000000001,0,0,0.29299999999999998,0]
["Total",null,{"$f":"SUM(C48:C63)","v":1},{"$f":"SUMPRODUCT(C48:C63,D48:D63)","v":1.0398786340099997},null,null,null,null,null,null,null,"kg formed/kg plastic in vehicle"]
[null,null,null,null,null,null,"Source: GREET 2 2023",null,null,null,{"$f":"E44","v":"Blow Molding (HDPE)"},{"$f":"SUMPRODUCT($C$48:$C$63,E48:E63)","v":2.0656000000000001E-2}]
["Fluids of Chosen Vehicle Type and Size",null,null,"Change Interval",null,null,null,null,null,null,{"$f":"F46","v":"Calendaring (PVC)"},{"$f":"SUMPRODUCT($C$48:$C$63,F48:F63)","v":2.4977999999999983E-2}]
[null,"kg of fluids per vehicle","# of replacements","in km",null,null,null,null,null,null,{"$f":"G44","v":"Compression Molding"},{"$f":"SUMPRODUCT($C$48:$C$63,G48:G63)","v":0.12594329999999998}]
["Engine Oil",{"$f":"INDIRECT(ADDRESS(77+7*$F$73,2+$F$70))","v":0},{"$f":"INDIRECT(ADDRESS(77+7*$F$73,7))","v":33},6000,null,"Selected Parameters",null,null,null,null,{"$f":"H46","v":"Extrusion (HDPE)"},{"$f":"SUMPRODUCT($C$48:$C$63,H48:H63)","v":5.7639999999999997E-2}]
["Brake Fluid",{"$f":"INDIRECT(ADDRESS(78+7*$F$73,2+$F$70))","v":0.9},{"$f":"INDIRECT(ADDRESS(78+7*$F$73,7))","v":3},60000,null,"ICEV=0, HEV=1, FCV=2, PHEV=3, BEV=4",null,null,null,null,{"$f":"I44","v":"Extrusion (PVC)"},{"$f":"SUMPRODUCT($C$48:$C$63,I48:I63)","v":7.0517999999999956E-2}]
["Transmission Fluid",{"$f":"INDIRECT(ADDRESS(79+7*$F$73,2+$F$70))","v":0.8},{"$f":"INDIRECT(ADDRESS(79+7*$F$73,7))","v":1},null,null,{"$f":"IF('Data Input'!H4=\"ICEV-G\",0,IF('Data Input'!H4=\"HEV\",1,IF('Data Input'!H4=\"FCV\",2,IF('Data Input'!H4=\"ICEV-D\",0,IF('Data Input'!H4=\"BEV\",4,3)))))","v":4},null,null,null,null,{"$f":"J46","v":"Extrusion (PP)"},{"$f":"SUMPRODUCT($C$48:$C$63,J48:J63)","v":3.4389999999999998E-3}]
["Powertrain Coolant",{"$f":"INDIRECT(ADDRESS(80+7*$F$73,2+$F$70))","v":7.1},{"$f":"INDIRECT(ADDRESS(80+7*$F$73,7))","v":3},60000,null,null,null,null,null,null,{"$f":"K44","v":"Injection Molding (HDPE)"},{"$f":"SUMPRODUCT($C$48:$C$63,K48:K63)","v":2.7930000000000003E-2}]
["Windshield Fluid",{"$f":"INDIRECT(ADDRESS(81+7*$F$73,2+$F$70))","v":2.7},{"$f":"INDIRECT(ADDRESS(81+7*$F$73,7))","v":16},12000,null,"Compact / A=0,Midsize / C=1, SUV=2",null,null,null,null,{"$f":"L46","v":"Injection Molding (PVC)"},{"$f":"SUMPRODUCT($C$48:$C$63,L48:L63)","v":4.043399999999997E-2}]
["Total",{"$f":"INDIRECT(ADDRESS(82+7*$F$73,2+$F$70))","v":11.5},null,null,null,{"$f":"IF(OR('Data Input'!H6=\"Compact\",'Data Input'!H6=\"FSV A-Class\"),0,IF('Data Input'!H6=\"SUV\",2,IF(OR('Data Input'!H6=\"Mid-Size\",'Data Input'!H6=\"FSV C-Class\"),1,\"\")))","v":0},null,null,null,null,"Injection Molding (PP)",{"$f":"SUMPRODUCT($C$48:$C$63,M48:M63)","v":0.26946170000000003}]
[]
["Fluids Compact","    ICEVs","    HEVs","    FCVs","    PHEVs","    EVs","# of replacements"]
["in kg of fluids per vehicle"]
["Engine Oil",3.9,3.9,0,3.9,0,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D68,1)-1","v":33}]
["Brake Fluid",0.9,0.9,0.9,0.9,0.9,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D69,1)-1","v":3}]
["Transmission Fluid",10.9,0.8,0.8,0.8,0.8,1]
["Powertrain Coolant",10.4,10.4,7.1,10.4,7.1,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D71,1)-1","v":3}]
["Windshield Fluid",2.7,2.7,2.7,2.7,2.7,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D72,1)-1","v":16}]
["Total",{"$f":"SUM(B77:B81)","v":28.8},{"$f":"SUM(C77:C81)","v":18.7},{"$f":"SUM(D77:D81)","v":11.5},{"$f":"SUM(E77:E81)","v":18.7},{"$f":"SUM(F77:F81)","v":11.5}]
["Fluids Midsize"]
["Engine Oil",3.9,3.9,0,3.9,0,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D68,1)-1","v":33}]
["Brake Fluid",0.9,0.9,0.9,0.9,0.9,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D69,1)-1","v":3}]
["Transmission Fluid",10.9,0.8,0.8,0.8,0.8,1]
["Powertrain Coolant",10.4,10.4,7.1,10.4,7.1,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D71,1)-1","v":3}]
["Windshield Fluid",2.7,2.7,2.7,2.7,2.7,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D72,1)-1","v":16}]
["Total",{"$f":"SUM(B84:B88)","v":28.8},{"$f":"SUM(C84:C88)","v":18.7},{"$f":"SUM(D84:D88)","v":11.5},{"$f":"SUM(E84:E88)","v":18.7},{"$f":"SUM(F84:F88)","v":11.5}]
["Fluids SUV"]
["Engine Oil",4.9000000000000004,4.9000000000000004,0,4.9000000000000004,0,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D68,1)-1","v":33}]
["Brake Fluid",0.9,0.9,0.9,0.9,0.9,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D69,1)-1","v":3}]
["Transmission Fluid",14.3,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1]
["Powertrain Coolant",13.2,13.2,9.1,13.2,9.1,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D71,1)-1","v":3}]
["Windshield Fluid",4.8,4.8,4.8,4.8,4.8,{"$f":"CEILING('Data Input'!$H$11/'Expert Data Input'!D72,1)-1","v":16}]
["Total",{"$f":"SUM(B91:B95)","v":38.099999999999994},{"$f":"SUM(C91:C95)","v":24.900000000000002},{"$f":"SUM(D91:D95)","v":15.899999999999999},{"$f":"SUM(E91:E95)","v":24.900000000000002},{"$f":"SUM(F91:F95)","v":15.899999999999999}]
[null,null,null,null,null,null,"Source: GREET 2 2023"]

{"sheet":"Saved Scenarios","index":4,"n_rows":139,"n_cols":17,"rows_kept":139,"cut":false,"hidden":false,"merged":[[139,0,139,4],[15,1,15,4],[15,7,15,10],[15,13,15,16],[0,1,0,4],[0,7,0,10],[0,13,0,16],[79,0,79,4]]}
[null,"Scenario 1",null,null,null,null,null,"Scenario 2",null,null,null,null,null,"Scenario 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Scenario 1",null,null,null,null,null,"Scenario 2",null,null,null,null,null,"Scenario 3"]
[null,"Production","Use","End of Life","Total",null,null,"Production","Use","End of Life","Total",null,null,"Production","Use","End of Life","Total"]
["Baseline",7684.0041159502016,11738.402297237033,-2306.1156440702507,17116.290769116986,null,null,7684.0041159502016,17827.487062374399,-2306.1156440702507,23205.375534254348,null,null,6775.8921832148262,33205.767088749133,-1614.1539216615106,38367.505350302446]
["Contender 1",7127.947366789137,11082.342185718366,-2039.632739699784,16170.65681280772,null,null,7127.947366789137,16831.107584650083,-2039.632739699784,21919.422211739435,null,null,6275.8358953226216,31709.026462979931,-1377.8746348566124,36606.987723445942]
["Contender 2",9645.4263258778064,10872.402950032401,-3545.6706510356244,16972.158624874584,null,null,9645.4263258778064,16512.266151778309,-3545.6706510356244,22612.02182662049,null,null,8650.5987105725399,31230.069462733787,-2670.6198488449645,37210.048324461364]
[]
["Material Replacement Coefficients (to mild steel)"]
[null,null,"C 1","C 2",null,null,null,null,"C 1","C 2",null,null,null,null,"C 1","C 2"]
["AHSS (ULSAB-AVC)  ks",null,0.75,0.75,"kg / kg",null,null,null,0.75,0.75,"kg / kg",null,null,null,0.75,0.75,"kg / kg"]
["Aluminum  ka",null,0.67,0.67,"kg / kg",null,null,null,0.67,0.67,"kg / kg",null,null,null,0.67,0.67,"kg / kg"]
["Fiber Reinforced Composite kc",null,0.55000000000000004,0.55000000000000004,"kg / kg",null,null,null,0.55000000000000004,0.55000000000000004,"kg / kg",null,null,null,0.55000000000000004,0.55000000000000004,"kg / kg"]
["Magnesium km",null,0.5,0.5,"kg / kg",null,null,null,0.5,0.5,"kg / kg",null,null,null,0.5,0.5,"kg / kg"]
[]
["Secondary mass savings",null,0.3,"of Primary Mass Savings",null,null,null,null,0.3,"of Primary Mass Savings",null,null,null,null,0.3,"of Primary Mass Savings"]
[]
["Lifetime driving distance",null,200000,"km",null,null,null,null,200000,"km",null,null,null,null,200000,"km"]
[]
[null,null,"α",null,null,null,null,null,"α",null,null,null,null,null,"α"]
["Flat carbon steel",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Long & special steel",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Cast iron and steel",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Stainless steel",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Flat AHSS",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Long & special AHSS",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Cast AHSS",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Rolled aluminum",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Extruded aluminum",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Cast aluminum",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Rolled magnesium",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["Cast magnesium",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["SMC",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["GFRP",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
["CFRP",null,0.1,null,null,null,null,null,0.1,null,null,null,null,null,0.1]
[]
[null,null,"in kg","in kg","in kg",null,null,null,"in kg","in kg","in kg",null,null,null,"in kg","in kg","in kg"]
["Flat carbon steel",null,660.48,291.48,288.60000000000002,null,null,null,660.48,291.48,288.60000000000002,null,null,null,468.48,136.38000000000002,133.78800000000001]
["Long & special steel",null,247.68,201.68,199.76000000000002,null,null,null,247.68,201.68,199.76000000000002,null,null,null,175.68,134.28,132.55200000000002]
["Cast iron and steel",null,165.12,165.12,165.12,null,null,null,165.12,165.12,165.12,null,null,null,117.12,117.12,117.12]
["Stainless steel",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Flat AHSS",null,0,270,0,null,null,null,0,270,0,null,null,null,0,243,0]
["Long & special AHSS",null,0,30,0,null,null,null,0,30,0,null,null,null,0,27,0]
["Cast AHSS",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Rolled aluminum",null,16.512,13.512,200.15200000000002,null,null,null,16.512,13.512,200.15200000000002,null,null,null,11.712000000000002,9.0120000000000005,176.988]
["Extruded aluminum",null,16.512,13.512,92.952000000000012,null,null,null,16.512,13.512,92.952000000000012,null,null,null,11.712000000000002,9.0120000000000005,80.50800000000001]
["Cast aluminum",null,82.56,73.56,70.680000000000007,null,null,null,82.56,73.56,70.680000000000007,null,null,null,58.56,50.46,47.868000000000002]
["Rolled magnesium",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Cast magnesium",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["SMC",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["GFRP",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["CFRP",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Plastic",null,198.14400000000001,198.14400000000001,198.14400000000001,null,null,null,198.14400000000001,198.14400000000001,198.14400000000001,null,null,null,140.54400000000001,140.54400000000001,140.54400000000001]
["Rubber",null,49.536000000000001,49.536000000000001,49.536000000000001,null,null,null,49.536000000000001,49.536000000000001,49.536000000000001,null,null,null,35.136000000000003,35.136000000000003,35.136000000000003]
["Glass",null,49.536000000000001,49.536000000000001,49.536000000000001,null,null,null,49.536000000000001,49.536000000000001,49.536000000000001,null,null,null,35.136000000000003,35.136000000000003,35.136000000000003]
["Copper",null,33.024000000000001,33.024000000000001,33.024000000000001,null,null,null,33.024000000000001,33.024000000000001,33.024000000000001,null,null,null,23.424000000000003,23.424000000000003,23.424000000000003]
["Other",null,132.09599999999975,132.09599999999975,132.09599999999975,null,null,null,132.09599999999975,132.09599999999975,132.09599999999975,null,null,null,93.695999999999827,93.695999999999827,93.695999999999827]
["Battery",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Fuel cell",null,0,0,0,null,null,null,0,0,0,null,null,null,0,0,0]
["Fluids",null,28.8,28.8,28.8,null,null,null,28.8,28.8,28.8,null,null,null,28.8,28.8,28.8]
["Tires",null,60,60,60,null,null,null,60,60,60,null,null,null,60,60,60]
["Total",null,1740,1609.9999999999995,1568.4,null,null,null,1740,1609.9999999999995,1568.4,null,null,null,1260,1142.9999999999995,1105.56]
[]
[]
[]
[]
["Scenario"]
[null,"Production","Use","End of Life","Total"]
["Baseline",{"$f":"Results!B25","v":8890.659807052094},{"$f":"Results!C25","v":12375.229743909767},{"$f":"Results!D25","v":-3201.5208716070797},{"$f":"Results!E25","v":18064.368679354779}]
["Contender 1",{"$f":"Results!B26","v":7986.8577438489929},{"$f":"Results!C26","v":11703.219783385495},{"$f":"Results!D26","v":-2776.4115358031036},{"$f":"Results!E26","v":16913.665991431382}]
["Contender 2",{"$f":"Results!B27","v":10894.384331309513},{"$f":"Results!C27","v":11488.176596017729},{"$f":"Results!D27","v":-4539.3482425743332},{"$f":"Results!E27","v":17843.212684752907}]
[]
["Material Replacement Coefficients (to mild steel)"]
[null,null,"C 1","C 2"]
["AHSS (ULSAB-AVC)  ks",null,{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",KSc)","v":0.75},{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",'Data Input'!M18)","v":0.75},"kg / kg"]
["Aluminum  ka",null,{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",KAc)","v":0.67},{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",'Data Input'!M19)","v":0.67},"kg / kg"]
["Fiber Reinforced Composite kc",null,{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",KCc)","v":0.55000000000000004},{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",'Data Input'!M20)","v":0.55000000000000004},"kg / kg"]
["Magnesium km",null,{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",KMc)","v":0.5},{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",'Data Input'!M21)","v":0.5},"kg / kg"]
[]
["Secondary mass savings",null,{"$f":"IF('Data Input'!F17=\"Yes\",\"-----n/a-----\",Sc)","v":0.3},"of Primary Mass Savings"]
[]
["Lifetime driving distance",null,{"$f":"'Data Input'!H11","v":200000},"km"]
[]
[null,null,"α"]
["Flat carbon steel",null,{"$f":"'Expert Data Input'!G6","v":0.9}]
["Long & special steel",null,{"$f":"'Expert Data Input'!G7","v":0.9}]
["Cast iron and steel",null,{"$f":"'Expert Data Input'!G8","v":0.9}]
["Flat AHSS",null,{"$f":"'Expert Data Input'!G9","v":0.9}]
["Long & special AHSS",null,{"$f":"'Expert Data Input'!G10","v":0.9}]
["Cast AHSS",null,{"$f":"'Expert Data Input'!G11","v":0.9}]
["Rolled aluminum",null,{"$f":"'Expert Data Input'!G12","v":0.9}]
["Extruded aluminum",null,{"$f":"'Expert Data Input'!G13","v":0.9}]
["Cast aluminum",null,{"$f":"'Expert Data Input'!G14","v":0.9}]
["Rolled magnesium",null,{"$f":"'Expert Data Input'!G15","v":0.9}]
["Cast magnesium",null,{"$f":"'Expert Data Input'!G16","v":0.9}]
["SMC",null,{"$f":"'Expert Data Input'!G17","v":0.9}]
["GFRP",null,{"$f":"'Expert Data Input'!G18","v":0.9}]
["CFRP",null,{"$f":"'Expert Data Input'!G19","v":0.9}]
["Stainless steel",null,{"$f":"'Expert Data Input'!G20","v":0.9}]
[]
[null,null,"in kg","in kg","in kg"]
["Flat carbon steel",null,{"$f":"'Material Flows'!F5","v":325.82927564214719},{"$f":"'Material Flows'!J5","v":66.865887442147212},{"$f":"'Material Flows'!N5","v":64.844709778147219}]
["Long & special steel",null,{"$f":"'Material Flows'!F6","v":122.1859783658052},{"$f":"'Material Flows'!J6","v":89.903279565805207},{"$f":"'Material Flows'!N6","v":88.555827789805207}]
["Cast iron and steel",null,{"$f":"'Material Flows'!F7","v":81.457318910536799},{"$f":"'Material Flows'!J7","v":81.457318910536799},{"$f":"'Material Flows'!N7","v":81.457318910536799}]
["Stainless steel",null,{"$f":"'Material Flows'!F23","v":0},{"$f":"'Material Flows'!J23","v":0},{"$f":"'Material Flows'!N23","v":0}]
["Flat AHSS",null,{"$f":"'Material Flows'!F8","v":0},{"$f":"'Material Flows'!J8","v":189.48540599999998},{"$f":"'Material Flows'!N8","v":0}]
["Long & special AHSS",null,{"$f":"'Material Flows'!F9","v":0},{"$f":"'Material Flows'!J9","v":21.053933999999998},{"$f":"'Material Flows'!N9","v":0}]
["Cast AHSS",null,{"$f":"'Material Flows'!F10","v":0},{"$f":"'Material Flows'!J10","v":0},{"$f":"'Material Flows'!N10","v":0}]
["Rolled aluminum",null,{"$f":"'Material Flows'!F11","v":8.1457318910536802},{"$f":"'Material Flows'!J11","v":6.0403384910536797},{"$f":"'Material Flows'!N11","v":137.02387988305367}]
["Extruded aluminum",null,{"$f":"'Material Flows'!F12","v":8.1457318910536802},{"$f":"'Material Flows'!J12","v":6.0403384910536797},{"$f":"'Material Flows'!N12","v":61.791155723053684}]
["Cast aluminum",null,{"$f":"'Material Flows'!F13","v":40.728659455268399},{"$f":"'Material Flows'!J13","v":34.412479255268401},{"$f":"'Material Flows'!N13","v":32.391301591268402}]
["Rolled magnesium",null,{"$f":"'Material Flows'!F14","v":0},{"$f":"'Material Flows'!J14","v":0},{"$f":"'Material Flows'!N14","v":0}]
["Cast magnesium",null,{"$f":"'Material Flows'!F15","v":0},{"$f":"'Material Flows'!J15","v":0},{"$f":"'Material Flows'!N15","v":0}]
["SMC",null,{"$f":"'Material Flows'!F16","v":0},{"$f":"'Material Flows'!J16","v":0},{"$f":"'Material Flows'!N16","v":0}]
["GFRP",null,{"$f":"'Material Flows'!F17","v":0},{"$f":"'Material Flows'!J17","v":0},{"$f":"'Material Flows'!N17","v":0}]
["CFRP",null,{"$f":"'Material Flows'!F18","v":0},{"$f":"'Material Flows'!J18","v":0},{"$f":"'Material Flows'!N18","v":0}]
["Plastic",null,{"$f":"'Material Flows'!F19","v":97.748782692644156},{"$f":"'Material Flows'!J19","v":97.748782692644156},{"$f":"'Material Flows'!N19","v":97.748782692644156}]
["Rubber",null,{"$f":"'Material Flows'!F20","v":24.437195673161039},{"$f":"'Material Flows'!J20","v":24.437195673161039},{"$f":"'Material Flows'!N20","v":24.437195673161039}]
["Glass",null,{"$f":"'Material Flows'!F21","v":24.437195673161039},{"$f":"'Material Flows'!J21","v":24.437195673161039},{"$f":"'Material Flows'!N21","v":24.437195673161039}]
["Copper",null,{"$f":"'Material Flows'!F22","v":16.29146378210736},{"$f":"'Material Flows'!J22","v":16.29146378210736},{"$f":"'Material Flows'!N22","v":16.29146378210736}]
["Other",null,{"$f":"'Material Flows'!F24","v":65.165855128429314},{"$f":"'Material Flows'!J24","v":65.165855128429314},{"$f":"'Material Flows'!N24","v":65.165855128429314}]
["Battery",null,{"$f":"'Material Flows'!F25","v":177.25681089463191},{"$f":"'Material Flows'!J25","v":159.00572578275643},{"$f":"'Material Flows'!N25","v":153.1653785469563}]
["Fuel cell",null,{"$f":"'Material Flows'!F26","v":0},{"$f":"'Material Flows'!J26","v":0},{"$f":"'Material Flows'!N26","v":0}]
["Fluids",null,{"$f":"'Material Flows'!F27","v":11.5},{"$f":"'Material Flows'!J27","v":11.5},{"$f":"'Material Flows'!N27","v":11.5}]
["Tires",null,{"$f":"'Material Flows'!F28","v":60},{"$f":"'Material Flows'!J28","v":60},{"$f":"'Material Flows'!N28","v":60}]
["Total",null,{"$f":"'Material Flows'!F29","v":1063.3299999999995},{"$f":"'Material Flows'!J29","v":953.84520088812405},{"$f":"'Material Flows'!N29","v":918.81006517232402}]

{"sheet":"Material Flows","index":5,"n_rows":117,"n_cols":20,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Baseline Vehicle",null,null,null,"Contender Vehicle 1",null,null,null,"Contender Vehicle 2"]
[]
[null,"All in kg",null,"Shipped Material",null,"Vehicle",null,"Shipped Material",null,"Vehicle",null,"Shipped Material",null,"Vehicle"]
[null,null,"Primary","Seconday","Total","Composition","Primary","Seconday","Total","Composition","Primary","Seconday","Total","Composition"]
[null,"Flat carbon steel",{"$f":"E5*(1-C38)","v":562.79602156370879},{"$f":"E5*C38","v":29.6208432401952},{"$f":"$F5/($E38)","v":592.41686480390399},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S19,'BOM Entry'!C4)","v":325.82927564214719},{"$f":"I5*(1-C38)","v":115.49562376370881},{"$f":"I5*C38","v":6.0787170401952011},{"$f":"$J5/(F38)","v":121.57434080390401},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V19,'BOM Entry'!F4)","v":66.865887442147212},{"$f":"M5*(1-C38)","v":112.00449870770882},{"$f":"M5*C38","v":5.8949736161952018},{"$f":"$N5/($G38)","v":117.89947232390402},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y19,'BOM Entry'!I4)","v":64.844709778147219}]
[null,"Long & special steel",24.437195673161042,138.47744214791254,162.9146378210736,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S20,'BOM Entry'!C5)","v":122.1859783658052},17.980655913161044,101.89038350791256,119.8710394210736,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V20,'BOM Entry'!F5)","v":89.903279565805207},17.711165557961046,100.36327149511257,118.07443705307361,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y20,'BOM Entry'!I5)","v":88.555827789805207}]
[null,"Cast iron and steel",0,101.821648638171,101.821648638171,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S21,'BOM Entry'!C6)","v":81.457318910536799},0,101.821648638171,101.821648638171,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V21,'BOM Entry'!F6)","v":81.457318910536799},0,101.821648638171,101.821648638171,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y21,'BOM Entry'!I6)","v":81.457318910536799}]
[null,"Flat AHSS",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S22,'BOM Entry'!C7)","v":0},327.2929739999999,17.225945999999997,344.51891999999992,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V22,'BOM Entry'!F7)","v":189.48540599999998},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y22,'BOM Entry'!I7)","v":0}]
[null,"Long & special AHSS",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S23,'BOM Entry'!C8)","v":0},4.2107868000000002,23.861125199999996,28.071911999999998,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V23,'BOM Entry'!F8)","v":21.053933999999998},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y23,'BOM Entry'!I8)","v":0}]
[null,"Cast AHSS",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S24,'BOM Entry'!C9)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V24,'BOM Entry'!F9)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y24,'BOM Entry'!I9)","v":0}]
[null,"Rolled aluminum",15.664869021257077,0,15.664869021257077,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S25,'BOM Entry'!C10)","v":8.1457318910536802},11.616035559718615,0,11.616035559718615,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V25,'BOM Entry'!F10)","v":6.0403384910536797},263.50746131356476,0,263.50746131356476,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y25,'BOM Entry'!I10)","v":137.02387988305367}]
[null,"Extruded aluminum",10.1821648638171,0,10.1821648638171,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S26,'BOM Entry'!C11)","v":8.1457318910536802},7.5504231138170992,0,7.5504231138170992,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V26,'BOM Entry'!F11)","v":6.0403384910536797},77.2389446538171,0,77.2389446538171,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y26,'BOM Entry'!I11)","v":61.791155723053684}]
[null,"Cast aluminum",7.6366236478628258,43.274200671222673,50.910824319085499,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S27,'BOM Entry'!C12)","v":40.728659455268399},6.4523398603628257,36.56325920872267,43.015599069085496,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V27,'BOM Entry'!F12)","v":34.412479255268401},6.0733690483628253,34.415757940722671,40.489126989085499,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y27,'BOM Entry'!I12)","v":32.391301591268402}]
[null,"Rolled magnesium",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S28,'BOM Entry'!C13)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V28,'BOM Entry'!F13)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y28,'BOM Entry'!I13)","v":0}]
[null,"Cast magnesium",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S29,'BOM Entry'!C14)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V29,'BOM Entry'!F14)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y29,'BOM Entry'!I14)","v":0}]
[null,"SMC",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S30,'BOM Entry'!C15)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V30,'BOM Entry'!F15)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y30,'BOM Entry'!I15)","v":0}]
[null,"GFRP",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S31,'BOM Entry'!C16)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V31,'BOM Entry'!F16)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y31,'BOM Entry'!I16)","v":0}]
[null,"CFRP",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S32,'BOM Entry'!C17)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V32,'BOM Entry'!F17)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y32,'BOM Entry'!I17)","v":0}]
[null,"Plastic",101.64687062256711,0,{"$f":"$F19/($E52)","v":101.64687062256711},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S33,'BOM Entry'!C18)","v":97.748782692644156},101.64687062256711,0,101.64687062256711,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V33,'BOM Entry'!F18)","v":97.748782692644156},101.64687062256711,0,101.64687062256711,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y33,'BOM Entry'!I18)","v":97.748782692644156}]
[null,"Rubber",24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S34,'BOM Entry'!C19)","v":24.437195673161039},24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V34,'BOM Entry'!F19)","v":24.437195673161039},24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y34,'BOM Entry'!I19)","v":24.437195673161039}]
[null,"Glass",24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S35,'BOM Entry'!C20)","v":24.437195673161039},24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V35,'BOM Entry'!F20)","v":24.437195673161039},24.437195673161039,0,24.437195673161039,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y35,'BOM Entry'!I20)","v":24.437195673161039}]
[null,"Copper",16.29146378210736,0,16.29146378210736,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S36,'BOM Entry'!C21)","v":16.29146378210736},16.29146378210736,0,16.29146378210736,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V36,'BOM Entry'!F21)","v":16.29146378210736},16.29146378210736,0,16.29146378210736,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y36,'BOM Entry'!I21)","v":16.29146378210736}]
[null,"Stainless steel",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S37,'BOM Entry'!C22)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V37,'BOM Entry'!F22)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y37,'BOM Entry'!I22)","v":0}]
[null,"Other",65.165855128429314,0,65.165855128429314,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S38,'BOM Entry'!C23)","v":65.165855128429314},65.165855128429314,0,65.165855128429314,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V38,'BOM Entry'!F23)","v":65.165855128429314},65.165855128429314,0,65.165855128429314,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y38,'BOM Entry'!I23)","v":65.165855128429314}]
[null,"Battery",354.51362178926382,0,354.51362178926382,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S40,'BOM Entry'!C25)","v":177.25681089463191},318.01145156551286,0,318.01145156551286,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V40,'BOM Entry'!F25)","v":159.00572578275643},306.33075709391261,0,306.33075709391261,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y40,'BOM Entry'!I25)","v":153.1653785469563}]
[null,"Fuel cell",0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S41,'BOM Entry'!C26)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V41,'BOM Entry'!F26)","v":0},0,0,0,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y41,'BOM Entry'!I26)","v":0}]
[null,"Fluids",11.5,0,11.5,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S42,'BOM Entry'!C27)","v":11.5},11.5,0,11.5,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V42,'BOM Entry'!F27)","v":11.5},11.5,0,11.5,{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y42,'BOM Entry'!I27)","v":11.5}]
[null,"Tires",180,0,{"$f":"$F28/($E61)","v":180},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!S43,'BOM Entry'!C28)","v":60},180,0,{"$f":"$J28/(F61)","v":180},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!V43,'BOM Entry'!F28)","v":60},180,0,{"$f":"$N28/($G61)","v":180},{"$f":"IF('Data Input'!$F$17=\"No\",'Data Input'!Y43,'BOM Entry'!I28)","v":60}]
[null,"Total",{"$f":"SUM(C5:C28)","v":1398.7090774384965},313.1941346975014,{"$f":"SUM(E5:E28)","v":1711.903212135998},{"$f":"SUM(F5:F28)","v":1063.3299999999995},{"$f":"SUM(G5:G28)","v":1232.0888714557068},287.44107959500144,{"$f":"SUM(I5:I28)","v":1519.5299510507084},{"$f":"SUM(J5:J28)","v":953.84520088812405},{"$f":"SUM(K5:K28)","v":1206.3447772547529},242.49565169020144,{"$f":"SUM(M5:M28)","v":1448.8404289449543},{"$f":"SUM(N5:N28)","v":918.81006517232402}]
[]
[null,"Material Flow Parameters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total material"]
[null,null,"Material Production",null,null,"Forming yields",null,null,"Prompt scrap",null,null,"End-of-life scrap",null,null,null,"recycling rate rcar"]
[null,null,"Material from","Scrap input",null,null,null,null,null,null,null,null,null,null,"Baseline","Contender","Contender"]
[null,null,"secondary","to primary","Baseline Vehicle","Contender","Contender","Collection","Material Recovery","Recycling","Collection","Shredder Recovery","Material","Recycling","Vehicle","Vehicle 1","Vehicle 2"]
[null,null,"production rcont","production sp","Vehicle","Vehicle 1","Vehicle 2",null,"Recovery","Rate",null,null,"Recovery","Rate",null,"in % of unfinished material (column E)"]
[null,null,"in % ","in kg scrap/kg out","in % ","in % ","in % ","in % ","in % ","in % ","in % ","in % ","in % ","in % "]
[null,"Flat carbon steel",0.05,0.11899999999999999,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.99,0.98,{"$f":"H38*I38","v":0.97019999999999995},0.97,0.98,0.95,{"$f":"K38*L38*M38","v":0.90306999999999993},{"$f":"(1-E38)*$J38+E38*$N38","v":0.9332784999999999},{"$f":"(1-F38)*$J38+F38*$N38","v":0.9332784999999999},{"$f":"(1-G38)*$J38+G38*$N38","v":0.9332784999999999}]
[null,"Long & special steel",0.85,0.11899999999999999,0.75,0.75,0.75,0.99,0.98,{"$f":"H39*I39","v":0.97019999999999995},0.97,0.98,0.95,{"$f":"K39*L39*M39","v":0.90306999999999993},0.91985249999999996,0.91985249999999996,0.91985249999999996]
[null,"Cast iron and steel",1,0.11899999999999999,0.8,0.8,0.8,0.99,0.98,0.97019999999999995,0.97,0.98,0.95,0.90306999999999993,0.91649599999999998,0.91649599999999998,0.91649599999999998]
[null,"Flat AHSS",0.05,0.11899999999999999,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.99,0.98,0.97019999999999995,0.97,0.98,0.95,0.90306999999999993,0.9332784999999999,0.9332784999999999,0.9332784999999999]
[null,"Long & special AHSS",0.85,0.11899999999999999,0.75,0.75,0.75,0.99,0.98,0.97019999999999995,0.97,0.98,0.95,0.90306999999999993,0.91985249999999996,0.91985249999999996,0.91985249999999996]
[null,"Cast AHSS",1,0.11899999999999999,0.8,0.8,0.8,0.99,0.98,0.97019999999999995,0.97,0.98,0.95,0.90306999999999993,0.91649599999999998,0.91649599999999998,0.91649599999999998]
[null,"Rolled aluminum",0,0,0.52,0.52,0.52,0.99,0.93,0.92070000000000007,0.97,0.9,0.9,0.78570000000000007,0.85050000000000003,0.85050000000000003,0.85050000000000003]
[null,"Extruded aluminum",0,0,0.8,0.8,0.8,0.99,0.93,0.92070000000000007,0.97,0.9,0.9,0.78570000000000007,0.81270000000000009,0.81270000000000009,0.81270000000000009]
[null,"Cast aluminum",0.85,0,0.8,0.8,0.8,0.99,0.93,0.92070000000000007,0.97,0.9,0.9,0.78570000000000007,0.81270000000000009,0.81270000000000009,0.81270000000000009]
[null,"Rolled magnesium",0,0,0.96,0.96,0.96,0.99,0.93,0.92070000000000007,0.97,0.9,0.9,0.78570000000000007,0.79110000000000014,0.79110000000000014,0.79110000000000014]
[null,"Cast magnesium",0,0,0.55000000000000004,0.55000000000000004,0.55000000000000004,0.99,0.93,0.92070000000000007,0.97,0.9,0.9,0.78570000000000007,0.84645000000000004,0.84645000000000004,0.84645000000000004]
[null,"SMC",0,0,0.5,0.5,0.5,0,0,0,null,null,null,0,0,0,0]
[null,"GFRP",0,0,0.5,0.5,0.5,0,0,0,null,null,null,0,0,0,0]
[null,"CFRP",0,0,0.5,0.5,0.5,0,0,0,null,null,null,0,0,0,0]
[null,"Plastic",0,0,{"$f":"1/'Expert Data Input'!D64","v":0.96165068431474643},{"$f":"1/'Expert Data Input'!D64","v":0.96165068431474643},{"$f":"1/'Expert Data Input'!D64","v":0.96165068431474643},0,0,0,null,null,null,0,0,0,0]
[null,"Rubber",0,0,1,1,1,0,0,0,null,null,null,0,0,0,0]
[null,"Glass",0,0,1,1,1,0,0,0,null,null,null,0,0,0,0]
[null,"Copper",0,0,1,1,1,0,0,0,null,null,null,0,0,0,0]
[null,"Stainless steel",1,1.7999999999999999E-2,0.62,0.62,0.62,0.99,0.98,0.97019999999999995,0.97,0.98,0.95,0.90306999999999993,0.92857939999999994,0.92857939999999994,0.92857939999999994]
[null,"Other",null,null,1,1,1,0,0,0,null,null,null,0]
[null,"Battery",0,0,{"$f":"1/'Expert Data Input'!B31","v":0.5},{"$f":"1/'Expert Data Input'!B31","v":0.5},{"$f":"1/'Expert Data Input'!B31","v":0.5},0,0,0,null,null,null,0]
[null,"Fuel cell",0,0,1,1,1,0,0,0,null,null,null,0]
[null,"Fluids",0,0,1,1,1,0,0,0,null,null,null,0,{"$f":"(1-E60)*$J60+E60*$N60","v":0},{"$f":"(1-F60)*$J60+F60*$N60","v":0},{"$f":"(1-G60)*$J60+G60*$N60","v":0}]
[null,"Tires",0,0,{"$f":"1/'Expert Data Input'!D22","v":0.33333333333333331},{"$f":"1/'Expert Data Input'!D22","v":0.33333333333333331},{"$f":"1/'Expert Data Input'!D22","v":0.33333333333333331},0,0,0,null,null,null,0]
[]
[null,null,null,"Collected prompt",null,null,"Collected end-of-life",null,null,"Total ",null,null,"Scrap input to",null,null,"Prompt scrap",null,null,"End-of-life scrap"]
[null,null,null,"scrap output sprompt",null,null,"scrap output seol",null,null,"scrap inputs sin",null,null,"secondary production ss",null,null,"displacement rate βprompt",null,null,"displacement rate βeol"]
[null,null,"Baseline","Contender","Contender","Baseline","Contender","Contender","Baseline","Contender","Contender","Baseline","Contender","Contender","Baseline","Contender","Contender","Baseline","Contender","Contender"]
[null,null,"Vehicle","Vehicle 1","Vehicle 2","Vehicle","Vehicle 1","Vehicle 2","Vehicle","Vehicle 1","Vehicle 2","Vehicle","Vehicle 1","Vehicle 2","Vehicle","Vehicle 1","Vehicle 2","Vehicle","Vehicle 1","Vehicle 2"]
[null,null,null,"in % of unfinished material (column E)",null,null,"in % of unfinished material (column E)",null,null,"in % of unfinished material (column E)",null,null,"in kg scrap/kg out",null,null,"in % of unfinished material (column E)",null,null,"in % of unfinished material (column E)"]
[]
[null,"Flat carbon steel",{"$f":"(1-E38)*$H38","v":0.44549999999999995},0.44549999999999995,0.44549999999999995,{"$f":"E38*$K38*$L38","v":0.52283000000000002},{"$f":"F38*$K38*$L38","v":0.52283000000000002},{"$f":"G38*$K38*$L38","v":0.52283000000000002},{"$f":"$D38*(1-$C38)+IF(O38=0,0,$C38*(C69+F69)/O38)","v":0.16492786925339006},{"$f":"$D38*(1-$C38)+IF(P38=0,0,$C38*(D69+G69)/P38)","v":0.16492786925339006},{"$f":"$D38*(1-$C38)+IF(Q38=0,0,$C38*(E69+H69)/Q38)","v":0.16492786925339006},{"$f":"IF(O38=0,0,(C69+F69)/O38)","v":1.0375573850678013},{"$f":"IF(P38=0,0,(D69+G69)/P38)","v":1.0375573850678013},{"$f":"IF(Q38=0,0,(E69+H69)/Q38)","v":1.0375573850678013},{"$f":"IF(L69-$D38=0,0,'Expert Data Input'!G6*(C69-I69)/(L69-$D38))","v":0.27490380217596327},{"$f":"IF(M69-$D38=0,0,'Expert Data Input'!G6*(D69-J69)/(M69-$D38))","v":0.27490380217596327},{"$f":"IF(N69-$D38=0,0,'Expert Data Input'!G6*(E69-K69)/(N69-$D38))","v":0.27490380217596327},{"$f":"IF(L69-$D38=0,0,'Expert Data Input'!G6*F69/(L69-$D38))","v":0.51226739629910834},{"$f":"IF(M69-$D38=0,0,'Expert Data Input'!G6*G69/(M69-$D38))","v":0.51226739629910834},{"$f":"IF(N69-$D38=0,0,'Expert Data Input'!G6*H69/(N69-$D38))","v":0.51226739629910834}]
[null,"Long & special steel",0.2475,0.2475,0.2475,{"$f":"E39*$K39*$L39","v":0.71294999999999997},{"$f":"F39*$K39*$L39","v":0.71294999999999997},0.71294999999999997,0.90536457434751771,0.90536457434751771,0.90536457434751771,1.0441347933500209,1.0441347933500209,1.0441347933500209,{"$f":"IF(L70-$D39=0,0,'Expert Data Input'!G7*(C70-I70)/(L70-$D39))","v":-0.63999118957442103},{"$f":"IF(M70-$D39=0,0,'Expert Data Input'!G7*(D70-J70)/(M70-$D39))","v":-0.63999118957442103},{"$f":"IF(N70-$D39=0,0,'Expert Data Input'!G7*(E70-K70)/(N70-$D39))","v":-0.63999118957442103},{"$f":"IF(L70-$D39=0,0,'Expert Data Input'!G7*F70/(L70-$D39))","v":0.69358001083981768},{"$f":"IF(M70-$D39=0,0,'Expert Data Input'!G7*G70/(M70-$D39))","v":0.69358001083981768},{"$f":"IF(N70-$D39=0,0,'Expert Data Input'!G7*H70/(N70-$D39))","v":0.69358001083981768}]
[null,"Cast iron and steel",{"$f":"(1-E40)*$H40","v":0.19799999999999995},{"$f":"(1-F40)*$H40","v":0.19799999999999995},{"$f":"(1-G40)*$H40","v":0.19799999999999995},{"$f":"E40*$K40*$L40","v":0.76048000000000004},0.76048000000000004,0.76048000000000004,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,{"$f":"IF(L71-$D40=0,0,'Expert Data Input'!G8*(C71-I71)/(L71-$D40))","v":-0.82328518567304931},{"$f":"IF(M71-$D40=0,0,'Expert Data Input'!G8*(D71-J71)/(M71-$D40))","v":-0.82328518567304931},{"$f":"IF(N71-$D40=0,0,'Expert Data Input'!G8*(E71-K71)/(N71-$D40))","v":-0.82328518567304931},{"$f":"IF(L71-$D40=0,0,'Expert Data Input'!G8*F71/(L71-$D40))","v":0.7384820506248041},{"$f":"IF(M71-$D40=0,0,'Expert Data Input'!G8*G71/(M71-$D40))","v":0.7384820506248041},{"$f":"IF(N71-$D40=0,0,'Expert Data Input'!G8*H71/(N71-$D40))","v":0.7384820506248041}]
[null,"Flat AHSS",{"$f":"(1-E41)*$H41","v":0.44549999999999995},{"$f":"(1-F41)*$H41","v":0.44549999999999995},{"$f":"(1-G41)*$H41","v":0.44549999999999995},{"$f":"E41*$K41*$L41","v":0.52283000000000002},{"$f":"F41*$K41*$L41","v":0.52283000000000002},{"$f":"G41*$K41*$L41","v":0.52283000000000002},0.16492786925339006,0.16492786925339006,0.16492786925339006,1.0375573850678013,1.0375573850678013,1.0375573850678013,{"$f":"IF(L72-$D41=0,0,'Expert Data Input'!G9*(C72-I72)/(L72-$D41))","v":0.27490380217596327},{"$f":"IF(M72-$D41=0,0,'Expert Data Input'!G9*(D72-J72)/(M72-$D41))","v":0.27490380217596327},{"$f":"IF(N72-$D41=0,0,'Expert Data Input'!G9*(E72-K72)/(N72-$D41))","v":0.27490380217596327},{"$f":"IF(L72-$D41=0,0,'Expert Data Input'!G9*F72/(L72-$D41))","v":0.51226739629910834},{"$f":"IF(M72-$D41=0,0,'Expert Data Input'!G9*G72/(M72-$D41))","v":0.51226739629910834},{"$f":"IF(N72-$D41=0,0,'Expert Data Input'!G9*H72/(N72-$D41))","v":0.51226739629910834}]
[null,"Long & special AHSS",0.2475,{"$f":"(1-F42)*$H42","v":0.2475},0.2475,0.71294999999999997,0.71294999999999997,0.71294999999999997,0.90536457434751771,0.90536457434751771,0.90536457434751771,1.0441347933500209,1.0441347933500209,1.0441347933500209,{"$f":"IF(L73-$D42=0,0,'Expert Data Input'!G10*(C73-I73)/(L73-$D42))","v":-0.63999118957442103},{"$f":"IF(M73-$D42=0,0,'Expert Data Input'!G10*(D73-J73)/(M73-$D42))","v":-0.63999118957442103},{"$f":"IF(N73-$D42=0,0,'Expert Data Input'!G10*(E73-K73)/(N73-$D42))","v":-0.63999118957442103},{"$f":"IF(L73-$D42=0,0,'Expert Data Input'!G10*F73/(L73-$D42))","v":0.69358001083981768},{"$f":"IF(M73-$D42=0,0,'Expert Data Input'!G10*G73/(M73-$D42))","v":0.69358001083981768},{"$f":"IF(N73-$D42=0,0,'Expert Data Input'!G10*H73/(N73-$D42))","v":0.69358001083981768}]
[null,"Cast AHSS",0.19799999999999995,0.19799999999999995,0.19799999999999995,0.76048000000000004,0.76048000000000004,0.76048000000000004,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,1.0458092561233219,{"$f":"IF(L74-$D43=0,0,'Expert Data Input'!G11*(C74-I74)/(L74-$D43))","v":-0.82328518567304931},{"$f":"IF(M74-$D43=0,0,'Expert Data Input'!G11*(D74-J74)/(M74-$D43))","v":-0.82328518567304931},{"$f":"IF(N74-$D43=0,0,'Expert Data Input'!G11*(E74-K74)/(N74-$D43))","v":-0.82328518567304931},{"$f":"IF(L74-$D43=0,0,'Expert Data Input'!G11*F74/(L74-$D43))","v":0.7384820506248041},{"$f":"IF(M74-$D43=0,0,'Expert Data Input'!G11*G74/(M74-$D43))","v":0.7384820506248041},{"$f":"IF(N74-$D43=0,0,'Expert Data Input'!G11*H74/(N74-$D43))","v":0.7384820506248041}]
[null,"Rolled aluminum",0.47519999999999996,0.47519999999999996,0.47519999999999996,0.45395999999999997,0.45395999999999997,0.45395999999999997,0,0,0,1.0924867724867724,1.0924867724867724,1.0924867724867724,{"$f":"IF(L75-$D44=0,0,'Expert Data Input'!G12*(C75-I75)/(L75-$D44))","v":0.39147384734598989},{"$f":"IF(M75-$D44=0,0,'Expert Data Input'!G12*(D75-J75)/(M75-$D44))","v":0.39147384734598989},{"$f":"IF(N75-$D44=0,0,'Expert Data Input'!G12*(E75-K75)/(N75-$D44))","v":0.39147384734598989},{"$f":"IF(L75-$D44=0,0,'Expert Data Input'!G12*F75/(L75-$D44))","v":0.37397615265401007},{"$f":"IF(M75-$D44=0,0,'Expert Data Input'!G12*G75/(M75-$D44))","v":0.37397615265401007},{"$f":"IF(N75-$D44=0,0,'Expert Data Input'!G12*H75/(N75-$D44))","v":0.37397615265401007}]
[null,"Extruded aluminum",0.19799999999999995,0.19799999999999995,0.19799999999999995,0.69840000000000002,0.69840000000000002,0.69840000000000002,0,0,0,1.1029900332225913,1.1029900332225913,1.1029900332225913,{"$f":"IF(L76-$D45=0,0,'Expert Data Input'!G13*(C76-I76)/(L76-$D45))","v":0.16156084337349397},{"$f":"IF(M76-$D45=0,0,'Expert Data Input'!G13*(D76-J76)/(M76-$D45))","v":0.16156084337349397},{"$f":"IF(N76-$D45=0,0,'Expert Data Input'!G13*(E76-K76)/(N76-$D45))","v":0.16156084337349397},{"$f":"IF(L76-$D45=0,0,'Expert Data Input'!G13*F76/(L76-$D45))","v":0.56986915662650606},{"$f":"IF(M76-$D45=0,0,'Expert Data Input'!G13*G76/(M76-$D45))","v":0.56986915662650606},{"$f":"IF(N76-$D45=0,0,'Expert Data Input'!G13*H76/(N76-$D45))","v":0.56986915662650606}]
[null,"Cast aluminum",0.19799999999999995,0.19799999999999995,0.19799999999999995,0.69840000000000002,0.69840000000000002,0.69840000000000002,0.93754152823920245,0.93754152823920245,0.93754152823920245,1.1029900332225913,1.1029900332225913,1.1029900332225913,{"$f":"IF(L77-$D46=0,0,'Expert Data Input'!G14*(C77-I77)/(L77-$D46))","v":-0.60343915662650593},{"$f":"IF(M77-$D46=0,0,'Expert Data Input'!G14*(D77-J77)/(M77-$D46))","v":-0.60343915662650593},{"$f":"IF(N77-$D46=0,0,'Expert Data Input'!G14*(E77-K77)/(N77-$D46))","v":-0.60343915662650593},{"$f":"IF(L77-$D46=0,0,'Expert Data Input'!G14*F77/(L77-$D46))","v":0.56986915662650606},{"$f":"IF(M77-$D46=0,0,'Expert Data Input'!G14*G77/(M77-$D46))","v":0.56986915662650606},{"$f":"IF(N77-$D46=0,0,'Expert Data Input'!G14*H77/(N77-$D46))","v":0.56986915662650606}]
[null,"Rolled magnesium",3.9600000000000038E-2,3.9600000000000038E-2,3.9600000000000038E-2,0.83807999999999994,0.83807999999999994,0.83807999999999994,0,0,0,1.109442548350398,1.109442548350398,1.109442548350398,{"$f":"IF(L78-$D47=0,0,'Expert Data Input'!G15*(C78-I78)/(L78-$D47))","v":3.2124241181296177E-2},{"$f":"IF(M78-$D47=0,0,'Expert Data Input'!G15*(D78-J78)/(M78-$D47))","v":3.2124241181296177E-2},{"$f":"IF(N78-$D47=0,0,'Expert Data Input'!G15*(E78-K78)/(N78-$D47))","v":3.2124241181296177E-2},{"$f":"IF(L78-$D47=0,0,'Expert Data Input'!G15*F78/(L78-$D47))","v":0.67986575881870392},{"$f":"IF(M78-$D47=0,0,'Expert Data Input'!G15*G78/(M78-$D47))","v":0.67986575881870392},{"$f":"IF(N78-$D47=0,0,'Expert Data Input'!G15*H78/(N78-$D47))","v":0.67986575881870392}]
[null,"Cast magnesium",0.44549999999999995,0.44549999999999995,0.44549999999999995,0.48014999999999997,0.48014999999999997,0.48014999999999997,0,0,0,1.0935672514619881,1.0935672514619881,1.0935672514619881,{"$f":"IF(L79-$D48=0,0,'Expert Data Input'!G16*(C79-I79)/(L79-$D48))","v":0.3666441176470589},{"$f":"IF(M79-$D48=0,0,'Expert Data Input'!G16*(D79-J79)/(M79-$D48))","v":0.3666441176470589},{"$f":"IF(N79-$D48=0,0,'Expert Data Input'!G16*(E79-K79)/(N79-$D48))","v":0.3666441176470589},{"$f":"IF(L79-$D48=0,0,'Expert Data Input'!G16*F79/(L79-$D48))","v":0.39516088235294128},{"$f":"IF(M79-$D48=0,0,'Expert Data Input'!G16*G79/(M79-$D48))","v":0.39516088235294128},{"$f":"IF(N79-$D48=0,0,'Expert Data Input'!G16*H79/(N79-$D48))","v":0.39516088235294128}]
[null,"SMC",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(L80-$D49=0,0,'Expert Data Input'!G17*(C80-I80)/(L80-$D49))","v":0},{"$f":"IF(M80-$D49=0,0,'Expert Data Input'!G17*(D80-J80)/(M80-$D49))","v":0},{"$f":"IF(N80-$D49=0,0,'Expert Data Input'!G17*(E80-K80)/(N80-$D49))","v":0},{"$f":"IF(L80-$D49=0,0,'Expert Data Input'!G17*F80/(L80-$D49))","v":0},{"$f":"IF(M80-$D49=0,0,'Expert Data Input'!G17*G80/(M80-$D49))","v":0},{"$f":"IF(N80-$D49=0,0,'Expert Data Input'!G17*H80/(N80-$D49))","v":0}]
[null,"GFRP",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(L81-$D50=0,0,'Expert Data Input'!G18*(C81-I81)/(L81-$D50))","v":0},{"$f":"IF(M81-$D50=0,0,'Expert Data Input'!G18*(D81-J81)/(M81-$D50))","v":0},{"$f":"IF(N81-$D50=0,0,'Expert Data Input'!G18*(E81-K81)/(N81-$D50))","v":0},{"$f":"IF(L81-$D50=0,0,'Expert Data Input'!G18*F81/(L81-$D50))","v":0},{"$f":"IF(M81-$D50=0,0,'Expert Data Input'!G18*G81/(M81-$D50))","v":0},{"$f":"IF(N81-$D50=0,0,'Expert Data Input'!G18*H81/(N81-$D50))","v":0}]
[null,"CFRP",0,{"$f":"(1-F51)*$H51","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(L82-$D51=0,0,'Expert Data Input'!G19*(C82-I82)/(L82-$D51))","v":0},{"$f":"IF(M82-$D51=0,0,'Expert Data Input'!G19*(D82-J82)/(M82-$D51))","v":0},{"$f":"IF(N82-$D51=0,0,'Expert Data Input'!G19*(E82-K82)/(N82-$D51))","v":0},{"$f":"IF(L82-$D51=0,0,'Expert Data Input'!G19*F82/(L82-$D51))","v":0},{"$f":"IF(M82-$D51=0,0,'Expert Data Input'!G19*G82/(M82-$D51))","v":0},{"$f":"IF(N82-$D51=0,0,'Expert Data Input'!G19*H82/(N82-$D51))","v":0}]
[null,"Plastic",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Rubber",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Glass",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Copper",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Stainless steel",0.37619999999999998,0.37619999999999998,0.37619999999999998,0.5893719999999999,0.5893719999999999,0.5893719999999999,1.0398378426228279,1.0398378426228279,1.0398378426228279,1.0398378426228279,1.0398378426228279,1.0398378426228279,{"$f":"IF(L87-$D56=0,0,'Expert Data Input'!G20*(C87-I87)/(L87-$D56))","v":-0.58450962906940007},{"$f":"IF(M87-$D56=0,0,'Expert Data Input'!G20*(D87-J87)/(M87-$D56))","v":-0.58450962906940007},{"$f":"IF(N87-$D56=0,0,'Expert Data Input'!G20*(E87-K87)/(N87-$D56))","v":-0.58450962906940007},{"$f":"IF(L87-$D56=0,0,'Expert Data Input'!G20*F87/(L87-$D56))","v":0.51909880205502379},{"$f":"IF(M87-$D56=0,0,'Expert Data Input'!G20*G87/(M87-$D56))","v":0.51909880205502379},{"$f":"IF(N87-$D56=0,0,'Expert Data Input'!G20*H87/(N87-$D56))","v":0.51909880205502379}]
[null,"Other"]
[null,"Battery",{"$f":"(1-E58)*$H58","v":0},{"$f":"(1-F58)*$H58","v":0},{"$f":"(1-G58)*$H58","v":0},{"$f":"E58*$K58*$L58","v":0},{"$f":"F58*$K58*$L58","v":0},{"$f":"$K58*$L58","v":0},{"$f":"$D58*(1-$C58)+IF(O58=0,0,$C58*(C89+F89)/O58)","v":0},{"$f":"$D58*(1-$C58)+IF(P58=0,0,$C58*(D89+G89)/P58)","v":0},{"$f":"$D58*(1-$C58)+IF(Q58=0,0,$C58*(E89+H89)/Q58)","v":0},{"$f":"IF(O58=0,0,(C89+F89)/O58)","v":0},{"$f":"IF(P58=0,0,(D89+G89)/P58)","v":0},{"$f":"IF(Q58=0,0,(E89+H89)/Q58)","v":0},null,null,null,1,1,1]
[null,"Fuel cell"]
[null,"Fluids",{"$f":"(1-E60)*$H60","v":0},{"$f":"(1-F60)*$H60","v":0},{"$f":"(1-G60)*$H60","v":0},{"$f":"E60*$K60*$L60","v":0},{"$f":"F60*$K60*$L60","v":0},{"$f":"G60*$K60*$L60","v":0},{"$f":"$D60*(1-$C60)+IF(O60=0,0,$C60*(C91+F91)/O60)","v":0},{"$f":"$D60*(1-$C60)+IF(P60=0,0,$C60*(D91+G91)/P60)","v":0},{"$f":"$D60*(1-$C60)+IF(Q60=0,0,$C60*(E91+H91)/Q60)","v":0},{"$f":"IF(O60=0,0,(C91+F91)/O60)","v":0},{"$f":"IF(P60=0,0,(D91+G91)/P60)","v":0},{"$f":"IF(Q60=0,0,(E91+H91)/Q60)","v":0},0,0,0,0,0,0]
[null,"Tires"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Use ","index":6,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Default","Baseline","Contender","Contender"]
[null,null,null,"Vehicle","Vehicle","Vehicle 1","Vehicle 2"]
[null,"Mass of the vehicle VM","kg",{"$f":"'ED - ES'!B52","v":1063.33},{"$f":"'Material Flows'!F29","v":1063.3299999999995},{"$f":"'Material Flows'!J29","v":953.84520088812405},{"$f":"'Material Flows'!N29","v":918.81006517232402},null,"Volumetric energy content"]
[null,"Total life of the vehicle TM","km",{"$f":"'Data Input'!H11","v":200000},{"$f":"'Data Input'!H11","v":200000},{"$f":"'Data Input'!H11","v":200000},{"$f":"'Data Input'!H11","v":200000},null,"Gasoline",{"$f":"'Expert Data Input'!B39","v":31.875},"MJ/liter"]
[null,"Charging efficiency of the battery CE","%",{"$f":"'Expert Data Input'!$B$29","v":0.9},{"$f":"'Expert Data Input'!$B$29","v":0.9},{"$f":"'Expert Data Input'!$B$29","v":0.9},{"$f":"'Expert Data Input'!$B$29","v":0.9},null,"Bioethanol",{"$f":"'Expert Data Input'!B40","v":21.1},"MJ/liter"]
[null,"Liquid fuel savings per mass savings ESf","MJ/100km100kg",null,{"$f":"'ED - ES'!B22","v":0},{"$f":"'ED - ES'!B22","v":0},{"$f":"'ED - ES'!B22","v":0},null,"Diesel",{"$f":"'Expert Data Input'!B41","v":35.951999999999998},"MJ/liter"]
[null,"Electricity savings per mass savings ESel","MJ/100km100kg",null,{"$f":"'ED - ES'!B23","v":2.2623214039321571},{"$f":"'ED - ES'!B23","v":2.2623214039321571},{"$f":"'ED - ES'!B23","v":2.2623214039321571},null,"Biodiesel",{"$f":"'Expert Data Input'!B42","v":32.64},"MJ/liter"]
[null,"Change in liquid fuel demand ΔEDf","MJ/100km",null,{"$f":"E6*($D$3-E3)/100","v":0},{"$f":"F6*($D$3-F3)/100","v":0},{"$f":"G6*($D$3-G3)/100","v":0},null,"Gasoline/bioethanol mix",{"$f":"'Data Input'!P6","v":0},"vol%"]
[null,"Change in electricity demand ΔEDel","MJ/100km",null,{"$f":"E7*($D$3-E3)/100","v":1.0287846652918947E-14},{"$f":"F7*($E$3-F3)/100","v":2.4768980443600821},{"$f":"G7*($E$3-G3)/100","v":3.2695054185553056},null,"Diesel/biodiesel mix",{"$f":"'Data Input'!P9","v":0},"vol%"]
[null,"Liquid fuel demand EDf","MJ/100km",{"$f":"'ED - ES'!B7","v":0},{"$f":"D10-E8","v":0},{"$f":"D10-F8","v":0},{"$f":"D10-G8","v":0},null,"Gasoline",{"$f":"(1-J8)*J4/((1-J8)*J4+J8*J5)","v":1},"MJ%"]
[null,"Electricity demand EDel","MJ/100km",{"$f":"'ED - ES'!B8","v":45.612690513223001},{"$f":"D11-E9","v":45.612690513222994},{"$f":"E11-F9","v":43.13579246886291},{"$f":"E11-G9","v":42.343185094667689},null,"Bioethanol",{"$f":"J8*J5/((1-J8)*J4+J8*J5)","v":0},"MJ%"]
[null,"Total fuel consumption ",null,null,null,null,null,null,"Diesel",{"$f":"(1-J9)*J6/((1-J9)*J6+J9*J7)","v":1},"MJ%"]
[null,"Gasoline","MJ",{"$f":"(1-$J$24)*$J$18*D10*D4/100","v":0},{"$f":"(1-$J$24)*$J$18*E10*E4/100","v":0},{"$f":"(1-$J$24)*$J$18*F10*F4/100","v":0},{"$f":"(1-$J$24)*$J$18*G10*G4/100","v":0},null,"Biodiesel",{"$f":"J9*J7/((1-J9)*J6+J9*J7)","v":0},"MJ%"]
[null,"Diesel","MJ",{"$f":"(1-$J$24)*$J$20*D10*D4/100","v":0},{"$f":"(1-$J$24)*$J$20*E10*E4/100","v":0},{"$f":"(1-$J$24)*$J$20*F10*F4/100","v":0},{"$f":"(1-$J$24)*$J$20*G10*G4/100","v":0},null,"Energy content of liquid fuel mix",{"$f":"IF(J15=1,J6*(1-J9)+J7*J9,J4*(1-J8)+J5*J8)","v":31.875},"MJ/liter"]
[null,"Corn ethanol","MJ",{"$f":"IF('Data Input'!$P$7=\"Corn\",(1-$J$24)*$J$19*D10*D4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Corn\",(1-$J$24)*$J$19*E10*E4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Corn\",(1-$J$24)*$J$19*F10*F4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Corn\",(1-$J$24)*$J$19*G10*G4/100,0)","v":0},null,"Selected vehicle type",{"$f":"'ED - ES'!A3","v":6}]
[null,"Cellulosic ethanol","MJ",{"$f":"IF('Data Input'!$P$7=\"Cellulose\",(1-$J$24)*$J$19*D10*D4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Cellulose\",(1-$J$24)*$J$19*E10*E4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Cellulose\",(1-$J$24)*$J$19*F10*F4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Cellulose\",(1-$J$24)*$J$19*G10*G4/100,0)","v":0},null,"ICEV-G=0, ICEV-D=1, HEV=2, FCV=3, PHEV20=4,PHEV40=5,BEV=6"]
[null,"Sugarcane ethanol","MJ",{"$f":"IF('Data Input'!$P$7=\"Sugarcane\",(1-$J$24)*$J$19*D10*D4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Sugarcane\",(1-$J$24)*$J$19*E10*E4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Sugarcane\",(1-$J$24)*$J$19*F10*F4/100,0)","v":0},{"$f":"IF('Data Input'!$P$7=\"Sugarcane\",(1-$J$24)*$J$19*G10*G4/100,0)","v":0},null,"Selected fuel mix"]
[null,"Soybean biodiesel","MJ",{"$f":"IF('Data Input'!$P$10=\"Soybeans\",(1-$J$24)*$J$21*D10*D4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Soybeans\",(1-$J$24)*$J$21*E10*E4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Soybeans\",(1-$J$24)*$J$21*F10*F4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Soybeans\",(1-$J$24)*$J$21*G10*G4/100,0)","v":0},null,"Gasoline",{"$f":"IF(OR(J15=1,J15=3),0,J10)","v":1},"MJ/MJ liquid fuel"]
[null,"Rapeseed biodiesel","MJ",{"$f":"IF('Data Input'!$P$10=\"Rapeseed\",(1-$J$24)*$J$21*D10*D4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Rapeseed\",(1-$J$24)*$J$21*E10*E4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Rapeseed\",(1-$J$24)*$J$21*F10*F4/100,0)","v":0},{"$f":"IF('Data Input'!$P$10=\"Rapeseed\",(1-$J$24)*$J$21*G10*G4/100,0)","v":0},null,"Bioethanol",{"$f":"IF(OR(J15=1,J15=3),0,J11)","v":0},"MJ/MJ liquid fuel"]
[null,"Hydrogen","MJ",{"$f":"$J$22*D10*D4/100","v":0},{"$f":"$J$22*E10*E4/100","v":0},{"$f":"$J$22*F10*F4/100","v":0},{"$f":"$J$22*G10*G4/100","v":0},null,"Diesel",{"$f":"IF(J15=1,J12,0)","v":0},"MJ/MJ liquid fuel"]
[null,"Electricity","MJ",{"$f":"$J$24*(D4/100)*D11/D5","v":101361.53447382888},{"$f":"$J$24*(E4/100)*E11/E5","v":101361.53447382887},{"$f":"$J$24*(F4/100)*F11/F5","v":95857.316597473124},{"$f":"$J$24*(G4/100)*G11/G5","v":94095.966877039304},null,"Biodiesel",{"$f":"IF(J15=1,J13,0)","v":0},"MJ/MJ liquid fuel"]
[null,null,null,null,null,null,null,null,"Hydrogen",{"$f":"IF(J15=3,1,0)","v":0},"MJ/MJ liquid fuel"]
[null,"Upstream GHG emissions per km","in gCO2eq/km",null,{"$f":"((SUM('LCA Calculations'!I94:I106))/E4)*1000","v":61.876148719548837},{"$f":"((SUM('LCA Calculations'!J94:J106))/F4)*1000","v":58.516098916927476},{"$f":"((SUM('LCA Calculations'!K94:K106))/G4)*1000","v":57.440882980088645}]
[null,"Tailpipe GHG emissions per km","in gCO2eq/km",null,{"$f":"(SUM('LCA Calculations'!I104:I108)*1000)/E4","v":61.876148719548837},{"$f":"(SUM('LCA Calculations'!J104:J108)*1000)/F4","v":58.516098916927476},{"$f":"(SUM('LCA Calculations'!K104:K108)*1000)/G4","v":57.440882980088645},null,"Energy from electricity",{"$f":"IF(OR(J15=4,J15=5),'Expert Data Input'!B35,IF(J15=6,\"100%\",\"0%\"))","v":"100%"},"Fraction"]
[null,"Use phase GHG emissions per km","in gCO2eq/km",null,{"$f":"SUM(E23:E24)","v":123.75229743909767},{"$f":"SUM(F23:F24)","v":117.03219783385495},{"$f":"SUM(G23:G24)","v":114.88176596017729}]
[null,"Liquid fuel savings per mass savings FS","l/100km100kg",null,{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(E6/J14))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(F6/J14))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(G6/J14))","v":"-----n/a-----"}]
[null,"Change in fuel economy ΔFE","l/100km",null,{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(E26*(($D$3-E3)/100)))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(F26*(($E$3-F3)/100)))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(G26*(($E$3-G3)/100)))","v":"-----n/a-----"}]
[null,"Mass elasticity of liquid fuel consumption","% / %",null,{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(E27*D3)/(D29*(D3-E3)))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(F27*E3)/(E29*(E3-F3)))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(G27*E3)/(E29*(E3-G3)))","v":"-----n/a-----"}]
[null,"Liquid fuel economy FE (mixed mode)","l/100km",{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",D10/J14)","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",E10/J14)","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",F10/J14)","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",G10/J14)","v":"-----n/a-----"}]
[null,"Liquid fuel economy FE (mixed mode)","mpg",{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(3.785*100)/(D29*1.609))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(3.785*100)/(E29*1.609))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(3.785*100)/(F29*1.609))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\",J24=1),\"-----n/a-----\",(3.785*100)/(G29*1.609))","v":"-----n/a-----"}]
[null,"Total liquid fuel consumption FE·TM","liters",{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(D29*D4/100))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(E29*E4/100))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(F29*F4/100))","v":"-----n/a-----"},{"$f":"IF(OR('Data Input'!H4=\"FCV\",'Data Input'!H4=\"BEV\"),\"-----n/a-----\",(G29*G4/100))","v":"-----n/a-----"}]
[null,"Mass elasticity of electricity consumption","% / %",null,null,{"$f":"IF(E11=0,\"-----n/a-----\",(E3*F9)/(E11*(E3-F3)))","v":0.52739581712370265},{"$f":"IF(E11=0,\"-----n/a-----\",(G9*E3)/(E11*(E3-G3)))","v":0.52739581712370243}]
[null,"Electricity demand EDel","kWh/100km",{"$f":"D11/3.6","v":12.67019180922861},{"$f":"E11/3.6","v":12.670191809228609},{"$f":"F11/3.6","v":11.982164574684141},{"$f":"G11/3.6","v":11.761995859629913}]
[null,"Total electricity consumption EDel·TM","kWh",{"$f":"D33*D4/100","v":25340.383618457221},{"$f":"E33*E4/100","v":25340.383618457214},{"$f":"F33*F4/100","v":23964.329149368285},{"$f":"G33*G4/100","v":23523.991719259826}]

{"sheet":"Recycling","index":7,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,3,2,4],[2,6,2,7],[3,3,3,4],[3,6,3,7],[2,9,2,10],[3,9,3,10]]}
[null,null,"Baseline Vehicle",null,null,"Contender Vehicle 1",null,null,"Contender Vehicle 2",null,null,"Prompt",null,null,"EOL "]
[null,null,"Shipped","Prompt scrap","EOL scrap","Shipped","Prompt scrap","EOL scrap","Shipped","Prompt scrap","EOL scrap","Baseline","Contender 1","Contender 2","Baseline","Contender 1","Contender 2"]
[null,null,"Material","displacement rate δ",null,"Material","displacement rate δ",null,"Material","displacement rate δ"]
[null,null,"in kg","in % of unfinished material",null,"in kg","in % of unfinished material",null,"in kg","in % of unfinished material"]
[null,null,null,null,null,null,null,null,null,null,null,"Activity Level","Activity Level","Activity Level","Activity Level","Activity Level","Activity Level"]
[null,"Flat carbon steel",{"$f":"'Material Flows'!E5","v":592.41686480390399},{"$f":"'Material Flows'!O69","v":0.27490380217596327},{"$f":"'Material Flows'!R69","v":0.51226739629910834},{"$f":"'Material Flows'!I5","v":121.57434080390401},{"$f":"'Material Flows'!P69","v":0.27490380217596327},{"$f":"'Material Flows'!S69","v":0.51226739629910834},{"$f":"'Material Flows'!M5","v":117.89947232390402},{"$f":"'Material Flows'!Q69","v":0.27490380217596327},{"$f":"'Material Flows'!T69","v":0.51226739629910834},{"$f":"C6*D6","v":162.8576486077568},{"$f":"F6*G6","v":33.421248534029566},{"$f":"I6*J6","v":32.411013216380965},{"$f":"C6*E6","v":303.47584485677675},{"$f":"F6*H6","v":62.278571020396349},{"$f":"I6*K6","v":60.396055712405094}]
[null,"Long & special steel",{"$f":"'Material Flows'!E6","v":162.9146378210736},{"$f":"'Material Flows'!O70","v":-0.63999118957442103},{"$f":"'Material Flows'!R70","v":0.69358001083981768},{"$f":"'Material Flows'!I6","v":119.8710394210736},{"$f":"'Material Flows'!P70","v":-0.63999118957442103},{"$f":"'Material Flows'!S70","v":0.69358001083981768},{"$f":"'Material Flows'!M6","v":118.07443705307361},{"$f":"'Material Flows'!Q70","v":-0.63999118957442103},{"$f":"'Material Flows'!T70","v":0.69358001083981768},-104.26393285819485,-76.716409114615217,-75.566599427926676,112.9943362659052,83.14015682104845,81.894069331176169]
[null,"Cast iron and steel",{"$f":"'Material Flows'!E7","v":101.821648638171},{"$f":"'Material Flows'!O71","v":-0.82328518567304931},{"$f":"'Material Flows'!R71","v":0.7384820506248041},{"$f":"'Material Flows'!I7","v":101.821648638171},{"$f":"'Material Flows'!P71","v":-0.82328518567304931},{"$f":"'Material Flows'!S71","v":0.7384820506248041},{"$f":"'Material Flows'!M7","v":101.821648638171},{"$f":"'Material Flows'!Q71","v":-0.82328518567304931},{"$f":"'Material Flows'!T71","v":0.7384820506248041},-83.828254904612592,-83.828254904612592,-83.828254904612592,75.193459884314805,75.193459884314805,75.193459884314805]
[null,"Flat AHSS",{"$f":"'Material Flows'!E8","v":0},{"$f":"'Material Flows'!O72","v":0.27490380217596327},{"$f":"'Material Flows'!R72","v":0.51226739629910834},{"$f":"'Material Flows'!I8","v":344.51891999999992},{"$f":"'Material Flows'!P72","v":0.27490380217596327},{"$f":"'Material Flows'!S72","v":0.51226739629910834},{"$f":"'Material Flows'!M8","v":0},{"$f":"'Material Flows'!Q72","v":0.27490380217596327},{"$f":"'Material Flows'!T72","v":0.51226739629910834},0,94.709561029556497,0,0,176.48581012418077,0]
[null,"Long & special AHSS",{"$f":"'Material Flows'!E9","v":0},{"$f":"'Material Flows'!O73","v":-0.63999118957442103},{"$f":"'Material Flows'!R73","v":0.69358001083981768},{"$f":"'Material Flows'!I9","v":28.071911999999998},{"$f":"'Material Flows'!P73","v":-0.63999118957442103},{"$f":"'Material Flows'!S73","v":0.69358001083981768},{"$f":"'Material Flows'!M9","v":0},{"$f":"'Material Flows'!Q73","v":-0.63999118957442103},{"$f":"'Material Flows'!T73","v":0.69358001083981768},0,-17.965776354508463,0,0,19.470117029254407,0]
[null,"Cast AHSS",{"$f":"'Material Flows'!E10","v":0},{"$f":"'Material Flows'!O74","v":-0.82328518567304931},{"$f":"'Material Flows'!R74","v":0.7384820506248041},{"$f":"'Material Flows'!I10","v":0},{"$f":"'Material Flows'!P74","v":-0.82328518567304931},{"$f":"'Material Flows'!S74","v":0.7384820506248041},{"$f":"'Material Flows'!M10","v":0},{"$f":"'Material Flows'!Q74","v":-0.82328518567304931},{"$f":"'Material Flows'!T74","v":0.7384820506248041},0,0,0,0,0,0]
[null,"Rolled aluminum",{"$f":"'Material Flows'!E11","v":15.664869021257077},{"$f":"'Material Flows'!O75","v":0.39147384734598989},{"$f":"'Material Flows'!R75","v":0.37397615265401007},{"$f":"'Material Flows'!I11","v":11.616035559718615},{"$f":"'Material Flows'!P75","v":0.39147384734598989},{"$f":"'Material Flows'!S75","v":0.37397615265401007},{"$f":"'Material Flows'!M11","v":263.50746131356476},{"$f":"'Material Flows'!Q75","v":0.39147384734598989},{"$f":"'Material Flows'!T75","v":0.37397615265401007},6.1323865439225189,4.5473741314708755,103.15627968479579,5.85828744839871,4.3441202877157377,98.545506577672356]
[null,"Extruded aluminum",{"$f":"'Material Flows'!E12","v":10.1821648638171},{"$f":"'Material Flows'!O76","v":0.16156084337349397},{"$f":"'Material Flows'!R76","v":0.56986915662650606},{"$f":"'Material Flows'!I12","v":7.5504231138170992},{"$f":"'Material Flows'!P76","v":0.16156084337349397},{"$f":"'Material Flows'!S76","v":0.56986915662650606},{"$f":"'Material Flows'!M12","v":77.2389446538171},{"$f":"'Material Flows'!Q76","v":0.16156084337349397},{"$f":"'Material Flows'!T76","v":0.56986915662650606},1.6450391427662481,1.2198527260950129,12.478789039549314,5.8025017035754933,4.3027532520442282,44.01609224859213]
[null,"Cast aluminum",{"$f":"'Material Flows'!E13","v":50.910824319085499},{"$f":"'Material Flows'!O77","v":-0.60343915662650593},{"$f":"'Material Flows'!R77","v":0.56986915662650606},{"$f":"'Material Flows'!I13","v":43.015599069085496},{"$f":"'Material Flows'!P77","v":-0.60343915662650593},{"$f":"'Material Flows'!S77","v":0.56986915662650606},{"$f":"'Material Flows'!M13","v":40.489126989085499},{"$f":"'Material Flows'!Q77","v":-0.60343915662650593},{"$f":"'Material Flows'!T77","v":0.56986915662650606},-30.721584890269163,-25.957296824032866,-24.432724642837254,29.012508517877468,24.513263163283671,23.073504649813657]
[null,"Rolled magnesium",{"$f":"'Material Flows'!E14","v":0},{"$f":"'Material Flows'!O78","v":3.2124241181296177E-2},{"$f":"'Material Flows'!R78","v":0.67986575881870392},{"$f":"'Material Flows'!I14","v":0},{"$f":"'Material Flows'!P78","v":3.2124241181296177E-2},{"$f":"'Material Flows'!S78","v":0.67986575881870392},{"$f":"'Material Flows'!M14","v":0},{"$f":"'Material Flows'!Q78","v":3.2124241181296177E-2},{"$f":"'Material Flows'!T78","v":0.67986575881870392},0,0,0,0,0,0]
[null,"Cast magnesium",{"$f":"'Material Flows'!E15","v":0},{"$f":"'Material Flows'!O79","v":0.3666441176470589},{"$f":"'Material Flows'!R79","v":0.39516088235294128},{"$f":"'Material Flows'!I15","v":0},{"$f":"'Material Flows'!P79","v":0.3666441176470589},{"$f":"'Material Flows'!S79","v":0.39516088235294128},{"$f":"'Material Flows'!M15","v":0},{"$f":"'Material Flows'!Q79","v":0.3666441176470589},{"$f":"'Material Flows'!T79","v":0.39516088235294128},0,0,0,0,0,0]
[null,"SMC",{"$f":"'Material Flows'!E16","v":0},{"$f":"'Material Flows'!O80","v":0},{"$f":"'Material Flows'!R80","v":0},{"$f":"'Material Flows'!I16","v":0},{"$f":"'Material Flows'!P80","v":0},{"$f":"'Material Flows'!S80","v":0},{"$f":"'Material Flows'!M16","v":0},{"$f":"'Material Flows'!Q80","v":0},{"$f":"'Material Flows'!T80","v":0},0,0,0,0,0,0]
[null,"GFRP",{"$f":"'Material Flows'!E17","v":0},{"$f":"'Material Flows'!O81","v":0},{"$f":"'Material Flows'!R81","v":0},{"$f":"'Material Flows'!I17","v":0},{"$f":"'Material Flows'!P81","v":0},{"$f":"'Material Flows'!S81","v":0},{"$f":"'Material Flows'!M17","v":0},{"$f":"'Material Flows'!Q81","v":0},{"$f":"'Material Flows'!T81","v":0},0,0,0,0,0,0]
[null,"CFRP",{"$f":"'Material Flows'!E18","v":0},{"$f":"'Material Flows'!O82","v":0},{"$f":"'Material Flows'!R82","v":0},{"$f":"'Material Flows'!I18","v":0},{"$f":"'Material Flows'!P82","v":0},{"$f":"'Material Flows'!S82","v":0},{"$f":"'Material Flows'!M18","v":0},{"$f":"'Material Flows'!Q82","v":0},{"$f":"'Material Flows'!T82","v":0},0,0,0,0,0,0]
[null,"Plastic",{"$f":"'Material Flows'!E19","v":101.64687062256711},{"$f":"'Material Flows'!O83","v":0},{"$f":"'Material Flows'!R83","v":0},{"$f":"'Material Flows'!I19","v":101.64687062256711},{"$f":"'Material Flows'!P83","v":0},{"$f":"'Material Flows'!S83","v":0},{"$f":"'Material Flows'!M19","v":101.64687062256711},{"$f":"'Material Flows'!Q83","v":0},{"$f":"'Material Flows'!T83","v":0},0,0,0,0,0,0]
[null,"Rubber",{"$f":"'Material Flows'!E20","v":24.437195673161039},{"$f":"'Material Flows'!O84","v":0},{"$f":"'Material Flows'!R84","v":0},{"$f":"'Material Flows'!I20","v":24.437195673161039},{"$f":"'Material Flows'!P84","v":0},{"$f":"'Material Flows'!S84","v":0},{"$f":"'Material Flows'!M20","v":24.437195673161039},{"$f":"'Material Flows'!Q84","v":0},{"$f":"'Material Flows'!T84","v":0},0,0,0,0,0,0]
[null,"Glass",{"$f":"'Material Flows'!E21","v":24.437195673161039},{"$f":"'Material Flows'!O85","v":0},{"$f":"'Material Flows'!R85","v":0},{"$f":"'Material Flows'!I21","v":24.437195673161039},{"$f":"'Material Flows'!P85","v":0},{"$f":"'Material Flows'!S85","v":0},{"$f":"'Material Flows'!M21","v":24.437195673161039},{"$f":"'Material Flows'!Q85","v":0},{"$f":"'Material Flows'!T85","v":0},0,0,0,0,0,0]
[null,"Copper",{"$f":"'Material Flows'!E22","v":16.29146378210736},{"$f":"'Material Flows'!O86","v":0},{"$f":"'Material Flows'!R86","v":0},{"$f":"'Material Flows'!I22","v":16.29146378210736},{"$f":"'Material Flows'!P86","v":0},{"$f":"'Material Flows'!S86","v":0},{"$f":"'Material Flows'!M22","v":16.29146378210736},{"$f":"'Material Flows'!Q86","v":0},{"$f":"'Material Flows'!T86","v":0},0,0,0,0,0,0]
[null,"Stainless steel",{"$f":"'Material Flows'!E23","v":0},{"$f":"'Material Flows'!O87","v":-0.58450962906940007},{"$f":"'Material Flows'!R87","v":0.51909880205502379},{"$f":"'Material Flows'!I23","v":0},{"$f":"'Material Flows'!P87","v":-0.58450962906940007},{"$f":"'Material Flows'!S87","v":0.51909880205502379},{"$f":"'Material Flows'!M23","v":0},{"$f":"'Material Flows'!Q87","v":-0.58450962906940007},{"$f":"'Material Flows'!T87","v":0.51909880205502379},0,0,0,0,0,0]
[null,"Other",{"$f":"'Material Flows'!E24","v":65.165855128429314},null,null,{"$f":"'Material Flows'!I24","v":65.165855128429314},null,null,{"$f":"'Material Flows'!M24","v":65.165855128429314},{"$f":"'Material Flows'!Q88","v":0},{"$f":"'Material Flows'!T88","v":0},0,0,0,0,0,0]
[null,"Battery",{"$f":"'Material Flows'!E25","v":354.51362178926382},{"$f":"'Material Flows'!O89","v":0},{"$f":"'Material Flows'!R89","v":1},{"$f":"'Material Flows'!I25","v":318.01145156551286},{"$f":"'Material Flows'!P89","v":0},{"$f":"'Material Flows'!S89","v":1},{"$f":"'Material Flows'!M25","v":306.33075709391261},{"$f":"'Material Flows'!Q89","v":0},{"$f":"'Material Flows'!T89","v":1},0,0,0,354.51362178926382,318.01145156551286,306.33075709391261]
[null,"Fuel cell",{"$f":"'Material Flows'!E26","v":0},{"$f":"'Material Flows'!O90","v":0},{"$f":"'Material Flows'!R90","v":0},{"$f":"'Material Flows'!I26","v":0},{"$f":"'Material Flows'!P90","v":0},{"$f":"'Material Flows'!S90","v":0},{"$f":"'Material Flows'!M26","v":0},{"$f":"'Material Flows'!Q90","v":0},{"$f":"'Material Flows'!T90","v":0},0,0,0,0,0,0]
[null,"Fluids",{"$f":"'Material Flows'!E27","v":11.5},{"$f":"'Material Flows'!O91","v":0},{"$f":"'Material Flows'!R91","v":0},{"$f":"'Material Flows'!I27","v":11.5},{"$f":"'Material Flows'!P91","v":0},{"$f":"'Material Flows'!S91","v":0},{"$f":"'Material Flows'!M27","v":11.5},{"$f":"'Material Flows'!Q91","v":0},{"$f":"'Material Flows'!T91","v":0},0,0,0,0,0,0]
[null,"Tires",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]

{"sheet":"ED - ES","index":8,"n_rows":77,"n_cols":23,"rows_kept":77,"cut":false,"hidden":false,"merged":[[17,17,18,18],[17,19,18,20],[17,21,18,22]]}
["Selected Parameters"]
["ICEV-G=0, ICEV-D=1, HEV=2, FCV=3, PHEV20=4,PHEV40=5,BEV=6",null,null,null,null,"Resize: No=0, Yes =1",null,"Hyzem=0, NEDC=1, US Combined=2, WLTP 3b=3",null,null,"Compact / A=0,Midsize / C=1, SUV=2"]
[{"$f":"IF('Data Input'!H4=\"ICEV-G\",0,IF('Data Input'!H4=\"HEV\",2,IF('Data Input'!H4=\"FCV\",3,IF('Data Input'!H4=\"ICEV-D\",1,IF('Data Input'!H4=\"BEV\",6,IF('Data Input'!H4=\"PHEV20\",4,IF('Data Input'!H4=\"PHEV40\",5)))))))","v":6},null,null,null,null,{"$f":"IF('Data Input'!H9=\"yes\",1,0)","v":1},null,{"$f":"IF('Data Input'!H8=\"Hyzem\",0,IF('Data Input'!H8=\"NEDC\",1,IF('Data Input'!H8=\"US Combined\",2,3)))","v":3},null,null,{"$f":"IF(OR('Data Input'!H6=\"Compact\",'Data Input'!H6=\"FSV A-Class\"),0,IF('Data Input'!H6=\"SUV\",2,IF(OR('Data Input'!H6=\"Mid-Size\",'Data Input'!H6=\"FSV C-Class\"),1,\"\")))","v":0}]
[]
[null,null,null,"Default fuel energy demand (EDf in MJf/100km)",null,null,null,null,null,null,"Baseline electricity demand (EDel in MJel/100km)"]
["Single Mode ED",null,null,"ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","PHEV20","PHEV40","BEV"]
["100% x EDf=",{"$f":"INDIRECT(ADDRESS(7+K3+3*H3,4+A3))","v":0},"Hyzem: Compact",184.75018780832232,171.1163523345611,169.86568592132028,104.30821132434126,182.64225783184582,191.66356678886112,0,58.62101982869256,61.754825790870413,58.73,"Hyzem: FSV A-Class"]
["100% x EDel=",{"$f":"IF(OR('Data Input'!H4=\"BEV\",'Data Input'!H4=\"PHEV-20\",'Data Input'!H4=\"PHEV-40\"),INDIRECT(ADDRESS(7+K3+3*H3,7+A3)),\"0\")","v":45.612690513223001},"Hyzem: Midsize",223.67417214785442,193.43636493603148,210.14139588417535,103.64428316724482,214.87996852931624,222.5195697173632,0,69.411956271524176,71.695984977491918,68.95,"Hyzem: FSV C-Class"]
[null,null,"Hyzem: SUV",331.92487821809618,274.87058892036708,323.29576098049182,150.67482579166949,"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"NEDC: Compact",163.53296711907504,161.56162291248287,122.33334166018507,79.250712631134135,116.93989084175467,125.58806053939482,0,38.052662454224617,40.782736309520594,37.74,"NEDC: FSV A-Class"]
[null,null,"NEDC: Midsize",233.97296034984456,194.75519424072715,160.92807546397228,88.940947822863293,142.45390860893272,150.30898781448533,0,46.353968525258864,48.807232237255171,45.92,"NEDC: FSV C-Class"]
[null,null,"NEDC: SUV",324.9913513562675,263.53118164319028,251.35139530069691,120.65631438890571,"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"US Combined: Compact",148.61417190119533,141.863825820448,121.19662356930971,71.264207079537741,107.9879984201301,115.64815265591349,0,35.156049876521394,37.568804403064348,34.78,"SAE J1711: FSV A-Class"]
[null,null,"US Combined: Midsize",198.23899228330407,169.14124347603794,163.39370568934436,79.453230891456741,132.80413404135481,139.78121111709672,0,43.234633087917473,45.408784342536265,42.83,"SAE J1711: FSV C-Class"]
[null,null,"US Combined: SUV",285.11353050073473,231.23113190463445,247.92107872486002,109.26922577180083,"n/a","n/a","n/a","n/a","n/a","n/a"]
[null,null,"WLTP 3b: Compact",167.5986801418841,143.66152579661517,null,null,142.39702293233685,149.80230684168765,0,46.615973263693306,48.744574460272808,45.612690513223001,"WLTP 3b: FSV A-Class"]
[null,null,"WLTP 3b: Midsize",220.27481286302435,169.07325730397551,null,null,170.3416435666937,177.05748089479792,0,55.76384088881457,57.614598300706731,54.495050899936579,"WLTP 3b: FSV C-Class"]
[null,null,"WLTP 3b: SUV",326.19840408963807,232.51502628325434,null,null,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,null,"Energy Savings (MJ/100km/100kg)",null,"Fuel Reduction Value (l/100km/100kg)",null,"GHG Reduction Value (gCO2e/km/100kg)"]
[null,null,null,null,null,null,null,null,null,null,"Electricity savings (ESel in MJel/100km·100kg)"]
[null,null,null,"Energy savings (ESf in MJf/100km·100kg) without powertrain resizing",null,null,null,null,null,null,"without powertrain resizing",null,null,null,null,null,null,"ICEV-G","ICEV-D","ICEV-G","ICEV-D","ICEV-G","ICEV-D"]
["Single Mode ES",null,null,"ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","PHEV20","PHEV40","BEV",null,null,null,"No Powertrain Resizing"]
["100% x ESf=",{"$f":"INDIRECT(ADDRESS(22+K3+3*H3+15*F3,4+A3))","v":0},"Hyzem: Compact / A",5.4952155770030098,4.7719620158335054,3.4492222268524655,3.3502646192258765,4.6596213824348274,4.8536603121879827,0,1.4562946897284228,1.5299236076751219,1.4500000000000002,"Hyzem: FSV A-Class",null,null,"Hyzem: Compact / A",5.5,4.7699999999999996,{"$f":"R22/'Use '!J$4","v":0.17254901960784313},{"$f":"S22/'Use '!J$6","v":0.1326769025367156},{"$f":"R22*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.9491403527833873},{"$f":"S22*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.3540113109122016}]
["100% x ESel=",{"$f":"IF(OR('Data Input'!H4=\"BEV\",'Data Input'!H4=\"PHEV-20\",'Data Input'!H4=\"PHEV-40\"),INDIRECT(ADDRESS(22+K3+3*H3+15*F3,7+A3)),\"0\")","v":2.2623214039321571},"Hyzem: Midsize / C",5.3527940878099329,4.6119856841499063,4.0863279712259155,2.6894073521179247,5.0457931343021958,4.9947839147885427,0,1.7159168869381696,1.5778562862666656,1.5582329317269115,"Hyzem: FSV C-Class",null,null,"Hyzem: Midsize / C",5.35,4.6100000000000003,{"$f":"R23/'Use '!J$4","v":0.16784313725490194},{"$f":"S23/'Use '!J$6","v":0.12822652425456166},{"$f":"R23*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.8141637977074767},{"$f":"S23*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.207964809917244}]
[null,null,"Hyzem: SUV",4.8993764644071014,4.6493837404121647,2.655751875350536,2.6396676854040848,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"Hyzem: SUV",4.9000000000000004,4.6500000000000004,{"$f":"R24/'Use '!J$4","v":0.15372549019607845},{"$f":"S24/'Use '!J$6","v":0.12933911882510016},{"$f":"R24*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.409234132479745},{"$f":"S24*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.2444764351659838}]
[null,null,"NEDC: Compact / A",5.6846053376713073,4.9379305859460123,2.5748082330104838,2.6298949566048226,4.9063075229439432,4.9166034226073778,0,1.5964627034463705,1.596818673867999,1.5937500000000027,"NEDC: FSV A-Class",null,null,"NEDC: Compact / A",5.68,4.9400000000000004,{"$f":"R25/'Use '!J$4","v":0.17819607843137253},{"$f":"S25/'Use '!J$6","v":0.13740542946150425},{"$f":"R25*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":5.1111122188744798},{"$f":"S25*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.5091857182193458}]
[null,null,"NEDC: Midsize / C",4.6367337062923406,5.108351022127974,3.1655486252554041,2.1371266035626033,5.1105406475347284,5.0429071220343227,0,1.6627637425563346,1.6365903081074347,1.6546184738955843,"NEDC: FSV C-Class",null,null,"NEDC: Midsize / C",4.6399999999999997,5.1100000000000003,{"$f":"R26/'Use '!J$4","v":0.14556862745098037},{"$f":"S26/'Use '!J$6","v":0.14213395638629286},{"$f":"R26*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.1752747703481665},{"$f":"S26*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.664360125526489}]
[null,null,"NEDC: SUV",5.3079174296138429,5.145311185073111,2.6471608852290078,2.0690835845599658,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"NEDC: SUV",5.31,5.15,{"$f":"R27/'Use '!J$4","v":0.16658823529411765},{"$f":"S27/'Use '!J$6","v":0.14324655095683134},{"$f":"R27*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.7781700496872332},{"$f":"S27*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.7008717507752298}]
[null,null,"US Combined: Compact",4.9923299392430565,4.339604430749878,2.9939992163156863,2.4725053507735,4.2826193002584629,4.2979321169867921,0,1.3939571109101274,1.3956749749852693,1.392812499999998,"SAE J1711: FSV A-Class",null,null,"SAE J1711: Compact / A",4.99,4.34,{"$f":"R28/'Use '!J$4","v":0.15654901960784315},{"$f":"S28/'Use '!J$6","v":0.12071651090342679},{"$f":"R28*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.4902200655252917},{"$f":"S28*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":3.9615113394882515}]
[null,null,"US Combined: Midsize",4.6349518318354637,4.4700205508231656,3.3287294017594764,1.9532229966839108,4.4476928082816229,4.4253489991873698,0,1.4411383183283371,1.4373270829872378,1.4463855421686753,"SAE J1711: FSV C-Class",null,null,"SAE J1711: Midsize / C",4.63,4.47,{"$f":"R29/'Use '!J$4","v":0.14525490196078431},{"$f":"S29/'Use '!J$6","v":0.12433244325767691},{"$f":"R29*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.1662763333431059},{"$f":"S29*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":4.0801741215466549}]
[null,null,"US Combined: SUV",4.7753108754861104,4.3111314239888898,2.9267350239855539,1.9059518682726833,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"SAE J1711: SUV",4.78,4.3099999999999996,{"$f":"R30/'Use '!J$4","v":0.1499607843137255},{"$f":"S30/'Use '!J$6","v":0.11988206497552291},{"$f":"R30*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":4.3012528884190173},{"$f":"S30*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":3.934127620551696}]
[null,null,"WLTP 3b: Compact",5.8229401596280308,4.4039642670499539,null,null,4.4643831366553215,4.50744987934769,0,1.8829791276155254,1.4667156768063441,1.4654826049257386,"WLTP 3b: FSV A-Class",null,null,"WLTP 3b: Compact",6.49,5.64,{"$f":"R31/'Use '!J$4","v":0.20360784313725491},{"$f":"S31/'Use '!J$6","v":0.1568758344459279},{"$f":"R31*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":5.8399856162843973},{"$f":"S31*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":5.1481391600722892}]
[null,null,"WLTP 3b: Midsize",5.2331218831584572,4.4877592643603839,null,null,4.8949368623028553,4.9172721904098822,0,1.8840053379407462,1.5848259127557369,1.6002680441498212,"WLTP 3b: FSV C-Class",null,null,"WLTP 3b: Midsize",6.04,5.79,{"$f":"R32/'Use '!J$4","v":0.18949019607843137},{"$f":"S32/'Use '!J$6","v":0.16104806408544728},{"$f":"R32*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":5.4350559510566656},{"$f":"S32*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":5.285057754755063}]
[null,null,"WLTP 3b: SUV",5.2657984108067444,4.4530989343674312,null,null,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"WLTP 3b: SUV",6.25,5.71,{"$f":"R33/'Use '!J$4","v":0.19607843137254902},{"$f":"S33/'Use '!J$6","v":0.15882287494437028},{"$f":"R33*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":5.6240231281629409},{"$f":"S33*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":5.2120345042575842}]
[null,null,null,null,null,null,null,null,null,null,"Electricity savings ((ESel in MJel/100km·100kg)",null,null,null,null,null,"With Powertrain Resizing"]
[null,null,null,"Energy savings (ESf in MJf/100km·100kg) with powertrain resizing",null,null,null,null,null,null,"with powertrain resizing"]
[null,null,null,"ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","PHEV20","PHEV40","BEV"]
[null,null,"Hyzem: Compact / A",7.1175750673799776,7.0139075367319172,5.7277136271832827,1.738567168645315,7.8624914368946408,7.8056361391023632,0,2.5005157705244305,2.4916748079405293,2.487499999999998,"Hyzem: FSV A-Class",null,null,"Hyzem: Compact / A",7.12,7.01,{"$f":"R37/'Use '!J$4","v":0.22337254901960785},{"$f":"S37/'Use '!J$6","v":0.1949821984868714},{"$f":"R37*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":6.4068871476032214},{"$f":"S37*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.3986623248416219}]
[null,null,"Hyzem: Midsize / C",8.9655197838325567,6.7874378963815083,6.5694656181572633,2.7043801565779795,7.8828248566233459,7.6654261185862582,0,2.6405708501059002,2.4480888401661143,2.4939759036144582,"Hyzem: FSV C-Class",null,null,"Hyzem: Midsize / C",8.9700000000000006,6.79,{"$f":"R38/'Use '!J$4","v":0.28141176470588236},{"$f":"S38/'Use '!J$6","v":0.18886292834890966},{"$f":"R38*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":8.0715979935394522},{"$f":"S38*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.1978483859735549}]
[null,null,"Hyzem: SUV",9.2306734118262845,6.9184889496704054,5.5213090363938635,2.6221238381073664,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"Hyzem: SUV",9.23,6.92,{"$f":"R39/'Use '!J$4","v":0.28956862745098039},{"$f":"S39/'Use '!J$6","v":0.19247886070315978},{"$f":"R39*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":8.3055573556710307},{"$f":"S39*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.3165111680319583}]
[null,null,"NEDC: Compact / A",8.1156802151676555,8.2975542182483952,4.752453975019546,2.6092716505511038,6.9371327717728946,6.7140722340502501,0,2.257429625426377,2.1807286150094511,2.2500000000000009,"NEDC: FSV A-Class",null,null,"NEDC: Compact / A",8.1199999999999992,8.3000000000000007,{"$f":"R40/'Use '!J$4","v":0.25474509803921569},{"$f":"S40/'Use '!J$6","v":0.2308633733867379},{"$f":"R40*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":7.3067308481092912},{"$f":"S40*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":7.5761622391134766}]
[null,null,"NEDC: Midsize / C",10.851271476664202,8.3527013749405903,5.2291474308542121,2.9077247678932272,7.0478919755419644,6.8815959651035135,0,2.2933213404468624,2.2340624600791572,2.2811244979919678,"NEDC: FSV C-Class",null,null,"NEDC: Midsize / C",10.85,8.35,{"$f":"R41/'Use '!J$4","v":0.3403921568627451},{"$f":"S41/'Use '!J$6","v":0.23225411659991099},{"$f":"R41*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":9.763304150490864},{"$f":"S41*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":7.6218017706744003}]
[null,null,"NEDC: SUV",11.955268563990963,8.2830248591529934,5.4396134975141619,2.914462338715186,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"NEDC: SUV",11.96,8.2799999999999994,{"$f":"R42/'Use '!J$4","v":0.37521568627450985},{"$f":"S42/'Use '!J$6","v":0.23030707610146861},{"$f":"R42*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":10.762130658052603},{"$f":"S42*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":7.5579064264891054}]
[null,null,"US Combined: Compact",7.2024002252589669,6.957878978467126,4.9981494543730545,2.6113130071957276,6.0422794662045263,5.903606023562153,0,1.9667434336067013,1.917413210670682,1.9646874999999973,"SAE J1711: FSV A-Class",null,null,"SAE J1711: Compact / A",7.2,6.96,{"$f":"R43/'Use '!J$4","v":0.22588235294117648},{"$f":"S43/'Use '!J$6","v":0.19359145527369828},{"$f":"R43*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":6.4788746436437066},{"$f":"S43*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.3530227932806973}]
[null,null,"US Combined: Midsize",8.7280366631279698,7.2717813291805076,6.3244993784964301,2.6552141258172459,6.3949111368118334,6.2037843410991602,0,2.0815935559809997,2.0149600287032809,2.0785140562248996,"SAE J1711: FSV C-Class",null,null,"SAE J1711: Midsize / C",8.73,7.27,{"$f":"R44/'Use '!J$4","v":0.27388235294117647},{"$f":"S44/'Use '!J$6","v":0.20221406319537161},{"$f":"R44*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":7.8556355054179949},{"$f":"S44*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.6359878889584296}]
[null,null,"US Combined: SUV",9.766175098571642,7.1118875600460374,6.4087239163672374,2.687497873054876,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"SAE J1711: SUV",9.77,7.11,{"$f":"R45/'Use '!J$4","v":0.30650980392156862},{"$f":"S45/'Use '!J$6","v":0.19776368491321764},{"$f":"R45*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":8.7914729539443073},{"$f":"S45*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":6.489941387963472}]
[null,null,"WLTP 3b: Compact",7.7683498644051676,6.7835332648476587,null,null,7.0019885184360309,6.7640370542680976,0,2.2921883190070358,2.2010331042297122,2.2623214039321571,"WLTP 3b: FSV A-Class",null,null,"WLTP 3b: Compact",9,8.85,{"$f":"R46/'Use '!J$4","v":0.28235294117647058},{"$f":"S46/'Use '!J$6","v":0.2461615487316422},{"$f":"R46*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":8.0985933045546332},{"$f":"S46*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":8.0781970862836445}]
[null,null,"WLTP 3b: Midsize",9.3283925662283043,7.0375720497993361,null,null,7.1481375876664979,7.0150108143363559,0,2.3399219301665384,2.2829036140400101,2.3253730716310561,"WLTP 3b: FSV C-Class",null,null,"WLTP 3b: Midsize",10.65,9.2200000000000006,{"$f":"R47/'Use '!J$4","v":0.33411764705882352},{"$f":"S47/'Use '!J$6","v":0.25645304850912332},{"$f":"R47*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":9.5833354103896493},{"$f":"S47*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":8.415929619834488}]
[null,null,"WLTP 3b: SUV",10.263601311188408,6.8275396292711141,null,null,"n/a","n/a","n/a","n/a","n/a","n/a",null,null,null,"WLTP 3b: SUV",11.91,8.94,{"$f":"R48/'Use '!J$4","v":0.37364705882352944},{"$f":"S48/'Use '!J$6","v":0.24866488651535382},{"$f":"R48*('LCA Calculations'!E$95+'LCA Calculations'!E$106)/100","v":10.717138473027298},{"$f":"S48*('LCA Calculations'!E$91+'LCA Calculations'!E$104)/100","v":8.1603482430933099}]
[]
[null,null,null,"Default Vehicle Mass VMb in kg"]
["Value from look-up table to the right",null,null,"Vehicle","ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","Vehicle"]
["Default VM=",{"$f":"INDIRECT(ADDRESS(52+K3,5+A3))","v":1063.33},null,"Compact",1260,1350,1335,1335,{"$f":"1107-3.6*1.3","v":1102.32},{"$f":"1268-8.3*1.3","v":1257.21},{"$f":"1097-25.9*1.3","v":1063.33},"FSV A-Class"]
["VMb=",{"$f":"CW","v":1063.33},null,"Mid-Size",1640,1740,1752,1752,{"$f":"1349-5.1*1.3","v":1342.37},{"$f":"1512-11*1.3","v":1497.7},{"$f":"1334-42.2*1.3","v":1279.1400000000001},"FSV C-Class"]
[null,null,null,"SUV",2195,2320,2345,2345]
["Value from look-up table to the right"]
["Default  ∆M=",{"$f":"INDIRECT(ADDRESS(58+K3,5+A3))","v":280.71911999999998},null,"Removed Mass ∆M in kg"]
[null,null,null,"Vehicle","ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","Vehicle"]
["Baseline Battery Size in kWh",null,null,"Compact",360,360,360,360,{"$f":"I52*0.262","v":288.80784},{"$f":"J52*0.229","v":287.90109000000001},{"$f":"K52*0.264","v":280.71911999999998},"FSV A-Class"]
["BSb=",{"$f":"0.0623*IF(K3=0,2.03,2.26)*B53*IF(A3=6,145,IF(A3=5,40,IF(A3=4,20,0)))*1.609/1000","v":31.374455528349849},null,"Mid-Size",400,400,400,400,{"$f":"I53*0.267","v":358.41278999999997},{"$f":"J53*0.238","v":356.45260000000002},{"$f":"K53*0.27","v":345.36780000000005},"FSV C-Class"]
["Battery Mass in kg",null,null,"SUV",540,540,540,540]
["BMb=",{"$f":"B59/B70","v":177.25681089463191}]
[null,null,null,"Default Battery Size BSb in kWh"]
["Frontal Area in m2",null,null,"Vehicle","ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","Vehicle"]
["FA=",{"$f":"INDIRECT(ADDRESS(70+K3,5+A3))","v":2.0299999999999998},null,"Compact",0,0,0,0,{"$f":"14*331/1000","v":4.6340000000000003},{"$f":"31*331/1000","v":10.260999999999999},{"$f":"95*331/1000","v":31.445},"FSV A-Class"]
["Battery Constant in Wh/kg•km",null,null,"Mid-Size",0,0,0,0,{"$f":"17*331/1000","v":5.6269999999999998},{"$f":"36*331/1000","v":11.916},{"$f":"117*331/1000","v":38.726999999999997},"FSV C-Class"]
["BC=",{"$f":"0.0623*B64","v":0.126469},null,"SUV",0,0,0,0]
["Battery Range in km"]
["BR=",{"$f":"1000*B59/(B66*B53)","v":233.30500000000001},null,"Frontal Area FA in m2"]
["Battery Energy Density in kWh/kg",null,null,"Vehicle","ICEV-G","ICEV-D","HEV","FCV","PHEV20","PHEV40","BEV","Vehicle"]
["BED=",{"$f":"'Expert Data Input'!B28","v":0.17699999999999999},null,"Compact",2.16,2.16,2.16,2.16,2.0299999999999998,2.0299999999999998,2.0299999999999998,"FSV A-Class"]
["Battery Mass Reduction Factor",null,null,"Mid-Size",2.2400000000000002,2.2400000000000002,2.2400000000000002,2.2400000000000002,2.2599999999999998,2.2599999999999998,2.2599999999999998,"FSV C-Class"]
["BMRF=",{"$f":"(B66*B68)/(1000*B70-B66*B68)","v":0.20004759547414008},null,"SUV",2.78,2.78,2.78,2.78]
[]
["Data Sources:"]
["Malen & Geyer ICEV Powertrain Model 2016",null,null,"Hyzem, NEDC, SAE J1711, WLTP 3b for ICEV-G, ICEV-D, PHEV20, PHEV40, BEV"]
["FKA Spreadsheet 11cc0042",null,null,"Hyzem, NEDC for HEV, FCV"]
["FKA Spreadsheet 11cc0022",null,null,"UDDS/HFEDS for HEV,FCV"]

{"sheet":"LCA Calculations","index":9,"n_rows":130,"n_cols":18,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
[null,"Unit","Total energy","Fossil energy","GHG emissions","Baseline","Contender 1","Contender 2","Baseline","Contender 1","Contender 2","Baseline","Contender 1","Contender 2","Baseline","Contender 1","Contender 2"]
[null,null,"MJ/unit","MJ/unit"," kgCO2eq/unit","Activity level","Activity level","Activity level","kgCO2eq","kgCO2eq","kgCO2eq","Total MJ","Total MJ","Total MJ","Fossil MJ","Fossil MJ","Fossil MJ","Source"]
["Aluminum, primary ingot, RoW","kg",169.52399098097453,121.33818570095471,12.303463498672031,{"$f":"IF('Expert Data Input'!D15=\"Global\",0,SUM('Material Flows'!C11:C13))","v":0},{"$f":"IF('Expert Data Input'!D15=\"Global\",0,SUM('Material Flows'!G11:G13))","v":0},{"$f":"IF('Expert Data Input'!D15=\"Global\",0,SUM('Material Flows'!K11:K13))","v":0},{"$f":"$E3*F3","v":0},{"$f":"$E3*G3","v":0},{"$f":"$E3*H3","v":0},{"$f":"$C3*F3","v":0},{"$f":"$C3*G3","v":0},0,{"$f":"$D3*F3","v":0},{"$f":"$D3*G3","v":0},0,"IAI 2019 Report; GREET 2 2023: Primary Aluminum: Production in Various Geographies"]
["Aluminum, primary ingot, GLO","kg",191.07855476956811,161.63999999999999,16.8,{"$f":"IF('Expert Data Input'!D15=\"Global\",SUM('Material Flows'!C11:C13),0)","v":33.483657532937002},{"$f":"IF('Expert Data Input'!D15=\"Global\",SUM('Material Flows'!G11:G13),0)","v":25.618798533898541},{"$f":"IF('Expert Data Input'!D15=\"Global\",SUM('Material Flows'!K11:K13),0)","v":346.81977501574471},{"$f":"$E4*F4","v":562.52544655334168},{"$f":"$E4*G4","v":430.39581536949549},{"$f":"$E4*H4","v":5826.5722202645111},{"$f":"$C4*F4","v":6398.0088897927653},{"$f":"$C4*G4","v":4895.2029987900642},{"$f":"$C4*H4","v":66269.821375515268},{"$f":"$D4*F4","v":5412.2984036239368},{"$f":"$D4*G4","v":4141.0225950193599},{"$f":"$D4*H4","v":56059.948433544967},"IAI 2019 Report; GREET 2 2023: Primary Aluminum: Production in Various Geographies"]
["Aluminum, secondary ingot","kg",8.4132986413241664,7.8572010706997757,0.5275633106191342,{"$f":"SUM('Material Flows'!D11:D13)","v":43.274200671222673},{"$f":"SUM('Material Flows'!H11:H13)","v":36.56325920872267},{"$f":"SUM('Material Flows'!L11:L13)","v":34.415757940722671},{"$f":"$E5*F5","v":22.829880570506994},19.289434075179276,18.156491196674409,{"$f":"$C5*F5","v":364.07877371158702},{"$f":"$C5*G5","v":307.61761902312975},{"$f":"$C5*H5","v":289.55004952282343},{"$f":"$D5*F5","v":340.01409584760773},{"$f":"$D5*G5","v":287.28487940304922},{"$f":"$D5*H5","v":270.41153014079049},"GREET 2 2023: 100% Recycled Al"]
["Battery","kg",172.02019338948639,154.80179792362364,11.938634526053546,{"$f":"'Material Flows'!C25","v":354.51362178926382},{"$f":"'Material Flows'!G25","v":318.01145156551286},{"$f":"'Material Flows'!K25","v":306.33075709391261},{"$f":"$E6*F6","v":4232.4085650495936},{"$f":"$E6*G6","v":3796.6224953404367},{"$f":"$E6*H6","v":3657.1709530335074},{"$f":"$C6*F6","v":60983.5017793964},54704.391398370804,52695.07607644263,54879.346041393554,49228.744462642746,47420.551957442498,"GREET 2 2023: EV: Conventional Material, Li-Ion"]
["CFRP, primary","kg",404.88968267835082,358.01766877396716,18.790617137179236,{"$f":"'Material Flows'!C18","v":0},{"$f":"'Material Flows'!G18","v":0},{"$f":"'Material Flows'!K18","v":0},{"$f":"$E7*F7","v":0},0,0,0,0,0,0,0,0,"GREET 2 2023: Carbon Fiber"]
["CFRP, secondary","kg",null,null,null,{"$f":"'Material Flows'!D18","v":0},{"$f":"'Material Flows'!H18","v":0},{"$f":"'Material Flows'!L18","v":0},0,0,0,0,0,0,0,0,0]
["Copper","kg",37.079477013878517,29.444481437543189,2.3265843390176331,{"$f":"'Material Flows'!C22","v":16.29146378210736},{"$f":"'Material Flows'!G22","v":16.29146378210736},{"$f":"'Material Flows'!K22","v":16.29146378210736},37.903464495123963,37.903464495123963,37.903464495123963,604.07895683108427,604.07895683108427,604.07895683108427,479.69370292266734,479.69370292266734,479.69370292266734,"GREET 2 2023: Final Copper Product - US Consumption Mix"]
["GFRP, primary","kg",85.658642220036157,79.745915336635349,4.6368260130450283,{"$f":"'Material Flows'!C17","v":0},{"$f":"'Material Flows'!G17","v":0},{"$f":"'Material Flows'!K17","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Final Glass Fiber-Reinforced Plastic Product: Combined"]
["GFRP, secondary","kg",null,null,null,{"$f":"'Material Flows'!D17","v":0},{"$f":"'Material Flows'!H17","v":0},{"$f":"'Material Flows'!L17","v":0},0,0,0,0,0,0,0,0,0]
["Glass","kg",14.94973702020336,13.908169339150708,1.2268853509114888,{"$f":"'Material Flows'!C21","v":24.437195673161039},{"$f":"'Material Flows'!G21","v":24.437195673161039},{"$f":"'Material Flows'!K21","v":24.437195673161039},{"$f":"$E12*F12","v":29.981637388758895},29.981637388758895,29.981637388758895,365.32964882500892,365.32964882500892,365.32964882500892,339.87665559628471,339.87665559628471,339.87665559628471,"GREET 2 2023: Final Flat Glass Product"]
["Magnesium, electrolytic","kg",243.59701197629965,217.45523111581915,18.110793565527143,{"$f":"(1-'Expert Data Input'!D14)*SUM('Material Flows'!C14:C15)","v":0},{"$f":"(1-'Expert Data Input'!D14)*SUM('Material Flows'!G14:G15)","v":0},{"$f":"(1-'Expert Data Input'!D14)*SUM('Material Flows'!K14:K15)","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Magnesium via Electrolytic production"]
["Magnesium, Pidgeon","kg",322.7904131070228,303.32785068214503,30.214906121737201,{"$f":"'Expert Data Input'!D14*SUM('Material Flows'!C14:C15)","v":0},{"$f":"'Expert Data Input'!D14*SUM('Material Flows'!G14:G15)","v":0},{"$f":"'Expert Data Input'!D14*SUM('Material Flows'!K14:K15)","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Magnesium via Thermal production"]
["Magnesium, secondary","kg",3.3403172436372843,3.2846488167687617,6.0408497920334359,{"$f":"SUM('Material Flows'!D14:D15)","v":0},{"$f":"SUM('Material Flows'!H14:H15)","v":0},{"$f":"SUM('Material Flows'!L14:L15)","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Recycled Magnesium"]
["Rubber","kg",54.765344673877784,53.341966027509102,3.8635866117588171,{"$f":"'Material Flows'!C20","v":24.437195673161039},{"$f":"'Material Flows'!G20","v":24.437195673161039},{"$f":"'Material Flows'!K20","v":24.437195673161039},94.415222031755491,94.415222031755491,94.415222031755491,1338.3114439036592,1338.3114439036592,1338.3114439036592,1303.5280614053486,1303.5280614053486,1303.5280614053486,"GREET 2 2023: Final Average Rubber Product: Combined"]
["SMC, primary","kg",59.706556915022198,56.116249565199212,3.1976105494248417,{"$f":"'Material Flows'!C16","v":0},{"$f":"'Material Flows'!G16","v":0},{"$f":"'Material Flows'!K16","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Final Glass Fiber-Reinforced    Plastic Product: SMC"]
["SMC, secondary","kg",null,null,null,{"$f":"'Material Flows'!D16","v":0},{"$f":"'Material Flows'!H16","v":0},{"$f":"'Material Flows'!L16","v":0},0,0,0,0,0,0,0,0,0]
["Stainless steel, EAF","kg",4.4122534826225994,3.6311289412002608,0.28656048589006217,{"$f":"'Material Flows'!D23","v":0},{"$f":"'Material Flows'!H23","v":0},{"$f":"'Material Flows'!L23","v":0},0,0,0,0,0,0,0,0,0,"Eurofer 2019: Cold rolled coil - 430 Stab. (without recycling potential)"]
["Steel, BF/BOF slab","kg",23.72,22.89,2.13,{"$f":"SUM('Material Flows'!C5:C10)","v":587.23321723686979},{"$f":"SUM('Material Flows'!G5:G10)","v":464.98004047686976},{"$f":"SUM('Material Flows'!K5:K10)","v":129.71566426566986},1250.8067527145326,990.40748621573255,276.2943648858768,13929.17191285855,11029.326560111351,3076.855556381689,13441.76834255195,10643.39312651555,2969.1915550411832,"WSA 2024"]
["Steel, EAF slab","kg",7.48,5.98,0.44,{"$f":"SUM('Material Flows'!D5:D10)","v":269.91993402627872},{"$f":"SUM('Material Flows'!H5:H10)","v":250.87782038627876},{"$f":"SUM('Material Flows'!L5:L10)","v":208.07989374947877},118.76477097156264,110.38624096996266,91.555153249770655,2019.001106516565,1876.5660964893652,1556.4376052461014,1614.121205477147,1500.2493659099471,1244.317764621883,"WSA 2024"]
["Tires, rubber","kg",{"$f":"C16","v":54.765344673877784},{"$f":"D16","v":53.341966027509102},{"$f":"E16","v":3.8635866117588171},{"$f":"(1-'Expert Data Input'!D23)*'Material Flows'!C28","v":120.00000000000001},{"$f":"(1-'Expert Data Input'!D23)*'Material Flows'!G28","v":120.00000000000001},{"$f":"(1-'Expert Data Input'!D23)*'Material Flows'!K28","v":120.00000000000001},463.63039341105809,463.63039341105809,463.63039341105809,6571.8413608653345,6571.8413608653345,6571.8413608653345,6401.0359233010931,6401.0359233010931,6401.0359233010931,"NA"]
["Tires, steel","kg",{"$f":"C20","v":23.72},{"$f":"D20","v":22.89},{"$f":"E20","v":2.13},{"$f":"'Expert Data Input'!D23*'Material Flows'!C28","v":60},{"$f":"'Expert Data Input'!D23*'Material Flows'!G28","v":60},{"$f":"'Expert Data Input'!D23*'Material Flows'!K28","v":60},127.8,127.8,127.8,1423.1999999999998,1423.1999999999998,1423.1999999999998,1373.4,1373.4,{"$f":"$D23*H23","v":1373.4},"NA"]
["MATERIALS PRODUCTION",null,null,null,null,null,null,null,{"$f":"SUM(I3:I23)","v":6941.0661331862357},6100.8321892975027,10623.479899957036,93996.523872700942,83115.866083209796,134190.5020735336,85585.082432119598,75698.228772716044,117861.9555840167]
["Aluminum casting","kg",12.655950000000001,11.25822,0.67723,{"$f":"'Material Flows'!E13","v":50.910824319085499},{"$f":"'Material Flows'!I13","v":43.015599069085496},{"$f":"'Material Flows'!M13","v":40.489126989085499},{"$f":"$E25*F25","v":34.478337553614274},{"$f":"$E25*G25","v":29.131454157556771},{"$f":"$E25*H25","v":27.420451470818371},{"$f":"$C25*F25","v":644.32484704113017},{"$f":"$C25*G25","v":544.40327103839263},512.42836671751661,{"$f":"$D25*F25","v":573.16526056561474},{"$f":"$D25*G25","v":484.27907775155973},455.83549925106212,"AA (North America), Life Cycle Assessment Report (January 2022): Die casting"]
["Aluminum extrusion","kg",13.91347,12.737350000000001,0.75212999999999997,{"$f":"'Material Flows'!E12","v":10.1821648638171},{"$f":"'Material Flows'!I12","v":7.5504231138170992},{"$f":"'Material Flows'!M12","v":77.2389446538171},7.6583116590227549,5.6788997365952545,58.093727442475455,{"$f":"$C26*F26","v":141.6692453677733},{"$f":"$C26*G26","v":105.0525854814008},{"$f":"$C26*H26","v":1074.6617392725445},{"$f":"$D26*F26","v":129.69379762814074},{"$f":"$D26*G26","v":96.17238184877823},{"$f":"$D26*H26","v":983.81947168629733},"AA (North America), Life Cycle Assessment Report (January 2022): Automotive extrusion"]
["aluminum rolling","kg",11.711049999999998,10.695469999999998,0.62278999999999995,{"$f":"'Material Flows'!E11","v":15.664869021257077},{"$f":"'Material Flows'!I11","v":11.616035559718615},{"$f":"'Material Flows'!M11","v":263.50746131356476},9.7559237777486949,7.2343507862371554,164.10981183147499,183.45206435139266,136.03597324164267,3085.9490548162221,167.54313667078441,124.23895984790363,2818.336147255392,"AA (North America), Life Cycle Assessment Report (January 2022): Automotive sheet"]
["CFRP finishing","kg",0,0,0,{"$f":"'Material Flows'!E18","v":0},{"$f":"'Material Flows'!I18","v":0},{"$f":"'Material Flows'!M18","v":0},0,0,0,0,0,0,0,0,0]
["Copper finishing","kg",0,0,0,{"$f":"'Material Flows'!E22","v":16.29146378210736},{"$f":"'Material Flows'!I22","v":16.29146378210736},{"$f":"'Material Flows'!M22","v":16.29146378210736},0,0,0,0,0,0,0,0,0]
["GFRP finishing","kg",0,0,0,{"$f":"'Material Flows'!E17","v":0},{"$f":"'Material Flows'!I17","v":0},{"$f":"'Material Flows'!M17","v":0},0,0,0,0,0,0,0,0,0]
["Glass finishing","kg",0,0,0,{"$f":"'Material Flows'!E21","v":24.437195673161039},{"$f":"'Material Flows'!I21","v":24.437195673161039},{"$f":"'Material Flows'!M21","v":24.437195673161039},0,0,0,0,0,0,0,0,0]
["Magnesium casting","kg",12.59225759061991,11.009488267737147,6.6024723666813188,{"$f":"'Material Flows'!E15","v":0},{"$f":"'Material Flows'!I15","v":0},{"$f":"'Material Flows'!M15","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Magnesium Casting and Molding"]
["Magnesium rolling","kg",11.711049999999998,10.695469999999998,0.62278999999999995,{"$f":"'Material Flows'!E14","v":0},{"$f":"'Material Flows'!I14","v":0},{"$f":"'Material Flows'!M14","v":0},0,0,0,0,0,0,0,0,0,"AA (North America), Life Cycle Assessment Report (January 2022): Automotive sheet"]
["Rubber compression molding","kg",10.277618356423401,9.2370988172842186,0.63004004181015039,{"$f":"'Expert Data Input'!D17*'Material Flows'!E20","v":21.749104149113325},{"$f":"'Expert Data Input'!D17*'Material Flows'!I20","v":21.749104149113325},{"$f":"'Expert Data Input'!D17*'Material Flows'!M20","v":21.749104149113325},13.702806487440675,13.702806487440675,13.702806487440675,223.52899203869148,223.52899203869148,223.52899203869148,200.89862421276598,200.89862421276598,200.89862421276598,"GREET 2 2023: Rubber Compression Molding"]
["Rubber injection molding","kg",8.9663647372403137,7.0256586901822518,0.53996308434657536,{"$f":"(1-'Expert Data Input'!D17)*'Material Flows'!E20","v":2.6880915240477141},{"$f":"(1-'Expert Data Input'!D17)*'Material Flows'!I20","v":2.6880915240477141},{"$f":"(1-'Expert Data Input'!D17)*'Material Flows'!M20","v":2.6880915240477141},1.4514701903306901,1.4514701903306901,1.4514701903306901,24.102409051695997,24.102409051695997,24.102409051695997,18.885613575931075,18.885613575931075,18.885613575931075,"GREET 2 2023: Rubber Injection Molding"]
["SMC finishing","kg",0,0,0,{"$f":"'Material Flows'!E16","v":0},{"$f":"'Material Flows'!I16","v":0},{"$f":"'Material Flows'!M16","v":0},0,0,0,0,0,0,0,0,0]
["Stainless mill and machining","kg",6.6010286638582212,5.7743687601676408,0.40317094793267594,{"$f":"'Material Flows'!E23","v":0},{"$f":"'Material Flows'!I23","v":0},{"$f":"'Material Flows'!M23","v":0},0,0,0,0,0,0,0,0,0,"GREET 2 2023: Stainless Steel Rod and Bar Mill, Machining"]
["Steel casting","kg",2,1.96,0.13500000000000001,{"$f":"'Material Flows'!E7+'Material Flows'!E10","v":101.821648638171},{"$f":"'Material Flows'!I7+'Material Flows'!I10","v":101.821648638171},{"$f":"'Material Flows'!M7+'Material Flows'!M10","v":101.821648638171},13.745922566153085,13.745922566153085,13.745922566153085,203.643297276342,203.643297276342,203.643297276342,199.57043133081515,199.57043133081515,199.57043133081515,"WSA 2010"]
["Steel HDG","kg",8.8855827994249807,7.7785270628423504,0.45951962602916741,{"$f":"(1-'Expert Data Input'!D16)*('Material Flows'!E5+'Material Flows'!E8)","v":444.31264860292799},{"$f":"(1-'Expert Data Input'!D16)*('Material Flows'!I5+'Material Flows'!I8)","v":349.56994560292799},{"$f":"(1-'Expert Data Input'!D16)*('Material Flows'!M5+'Material Flows'!M8)","v":88.424604242928012},204.17038212604635,160.63425067449387,40.632841073487413,3947.9768279931327,3106.1326958453033,785.70414250692227,3456.097961521039,2719.1392822287035,687.81317712474004,"WSA 2022"]
["Steel HRC","kg",3.1346564102046308,2.8988133001227538,0.15996408212508229,{"$f":"'Expert Data Input'!D16*('Material Flows'!E5+'Material Flows'!E8)","v":148.104216200976},{"$f":"'Expert Data Input'!D16*('Material Flows'!I5+'Material Flows'!I8)","v":116.52331520097599},{"$f":"'Expert Data Input'!D16*('Material Flows'!M5+'Material Flows'!M8)","v":29.474868080976005},23.691355003443867,18.639545162295772,4.714920218331212,464.25583069272193,365.26055693303408,92.393584169967298,429.32647172764507,337.77933587898502,85.442139612496874,"WSA 2022"]
["Steel long","kg",2.891508515727029,2.7875487791682545,0.18780595490934493,{"$f":"('Material Flows'!E6+'Material Flows'!E9)","v":162.9146378210736},{"$f":"('Material Flows'!I6+'Material Flows'!I9)","v":147.94295142107359},{"$f":"('Material Flows'!M6+'Material Flows'!M9)","v":118.07443705307361},30.596339124696808,27.784567263741554,22.175082401135828,471.06906259621906,427.77830387582446,341.41324022863739,454.13249976677207,412.39819362036206,329.13825285827426,"WSA 2022"]
["Tires (long steel/rubber molding)","kg",{"$f":"'Expert Data Input'!$D$23*C41+(1-'Expert Data Input'!$D$23)*('Expert Data Input'!D17*C34+(1-'Expert Data Input'!D17)*C35)","v":7.7194231441178518},{"$f":"'Expert Data Input'!$D$23*D41+(1-'Expert Data Input'!$D$23)*('Expert Data Input'!D17*D34+(1-'Expert Data Input'!D17)*D35)","v":6.9250765285914202},{"$f":"'Expert Data Input'!$D$23*E41+(1-'Expert Data Input'!$D$23)*('Expert Data Input'!D17*E34+(1-'Expert Data Input'!D17)*E35)","v":0.47602303596255308},{"$f":"'Material Flows'!E28","v":180},{"$f":"'Material Flows'!I28","v":180},{"$f":"'Material Flows'!M28","v":180},85.68414647325956,85.68414647325956,85.68414647325956,1389.4961659412133,1389.4961659412133,1389.4961659412133,1246.5137751464556,1246.5137751464556,1246.5137751464556,"NA"]
["MATERIALS FINISHING",null,null,null,null,null,null,null,{"$f":"SUM(I25:I42)","v":424.93499496175673},{"$f":"SUM(J25:J42)","v":363.68741349810438},{"$f":"SUM(K25:K42)","v":431.73118015490724},{"$f":"SUM(L25:L42)","v":7693.5187423503121},6525.4342507235415,7733.3209920197532,6875.8275721459631,5839.8756754422593,7026.2531320542303]
["ABS Resin","kg",90.549048520121644,88.648013802570816,3.3509921676611709,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B48","v":7.9660293820324712},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B48","v":7.9660293820324712},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B48","v":7.9660293820324712},{"$f":"$E44*F44","v":26.694102066549569},{"$f":"$E44*G44","v":26.694102066549569},{"$f":"$E44*H44","v":26.694102066549569},{"$f":"$C44*F44","v":721.31638102637282},{"$f":"$C44*G44","v":721.31638102637282},721.31638102637282,{"$f":"$D44*F44","v":706.17268261009917},{"$f":"$D44*G44","v":706.17268261009917},706.17268261009917,"GREET 2 2023: ABS Resin"]
["EPDM Resin","kg",73.622231181964679,73.217311706800359,1.7898005007444522,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B49","v":7.2294177905463499},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B49","v":7.2294177905463499},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B49","v":7.2294177905463499},{"$f":"$E45*F45","v":12.939215581610709},12.939215581610709,12.939215581610709,{"$f":"$C45*F45","v":532.24586788661168},{"$f":"$C45*G45","v":532.24586788661168},{"$f":"$C45*H45","v":532.24586788661168},{"$f":"$D45*F45","v":529.31853582912004},{"$f":"$D45*G45","v":529.31853582912004},{"$f":"$D45*H45","v":529.31853582912004},"GREET 2 2023: EPDM Resin"]
["Liquid Epoxy Resin","kg",125.99982499934362,122.48566470187984,6.1882885518595119,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B50","v":10.459119748112924},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B50","v":10.459119748112924},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B50","v":10.459119748112924},64.724050999774946,64.724050999774946,64.724050999774946,1317.8472579094073,1317.8472579094073,1317.8472579094073,1281.0922345441695,1281.0922345441695,1281.0922345441695,"GREET 2 2023: Liquid Epoxy Resin"]
["GPPS Resin","kg",84.740214269978054,83.780014753324622,3.0775798254916618,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B51","v":0.68424147884850905},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B51","v":0.68424147884850905},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B51","v":0.68424147884850905},2.1058077710687511,2.1058077710687511,2.1058077710687511,57.982769530029316,57.982769530029316,57.982769530029316,57.325761192764745,57.325761192764745,57.325761192764745,"GREET 2 2023: GPPS Resin"]
["HDPE Resin","kg",65.682445744254338,65.137181309321079,1.2916837464670765,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B53","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B53","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B53","v":1.3667309573904267},1.7653841634546006,1.7653841634546006,1.7653841634546006,89.770231955789484,89.770231955789484,89.770231955789484,89.025002172602214,89.025002172602214,89.025002172602214,"GREET 2 2023: HDPE Resin"]
["HIPS Resin","kg",85.103503167386975,84.131119072212741,3.0576985806152774,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B52","v":0.68424147884850905},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B52","v":0.68424147884850905},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B52","v":0.68424147884850905},2.0922041986731843,2.0922041986731843,2.0922041986731843,58.23134686244164,58.23134686244164,58.23134686244164,57.566001331150851,57.566001331150851,57.566001331150851,"GREET 2 2023: HIPS Resin"]
["LDPE Resin","kg",71.989615228158016,70.856879618596807,1.6245923925178416,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B54","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B54","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B54","v":1.3667309573904267},2.2203807159951134,2.2203807159951134,2.2203807159951134,98.390435742948853,98.390435742948853,98.390435742948853,96.842290918823025,96.842290918823025,96.842290918823025,"GREET 2 2023: LDPE Resin"]
["LLDPE Resin","kg",68.385958066381136,67.83856315006399,2.0714640385469716,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B55","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B55","v":1.3667309573904267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B55","v":1.3667309573904267},2.8311340286031421,2.8311340286031421,2.8311340286031421,93.465205940126665,93.465205940126665,93.465205940126665,92.717064362077878,92.717064362077878,92.717064362077878,"GREET 2 2023: LLDPE Resin"]
["Nylon 6 Resin","kg",110.67924770023598,108.46429922047538,8.7852526009895495,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B56","v":1.1026140691258848},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B56","v":1.1026140691258848},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B56","v":1.1026140691258848},9.6867431186758495,9.6867431186758495,9.6867431186758495,122.03649567454892,122.03649567454892,122.03649567454892,119.5942623183759,119.5942623183759,119.5942623183759,"GREET 2 2023: Nylon 6 Resin"]
["Nylon 66 Resin","kg",124.49164917808358,120.73882656981257,6.5284909500828654,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B57","v":7.0729596911609143},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B57","v":7.0729596911609143},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B57","v":7.0729596911609143},46.175753334044927,46.175753334044927,46.175753334044927,880.52441652273092,880.52441652273092,880.52441652273092,853.98085348635277,853.98085348635277,853.98085348635277,"GREET 2 2023: Nylon 66 Resin"]
["PC Resin","kg",97.68752362719512,94.565704531557174,4.3140503921857896,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B58","v":3.7929352624565755},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B58","v":3.7929352624565755},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B58","v":3.7929352624565755},16.3629138565361,16.3629138565361,16.3629138565361,370.52245306764826,370.52245306764826,370.52245306764826,358.68159533679278,358.68159533679278,358.68159533679278,"GREET 2 2023: PC Resin"]
["PET Resin","kg",62.461955578938976,60.629790650482768,1.7481584465644651,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B59","v":1.7774687519221759},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B59","v":1.7774687519221759},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B59","v":1.7774687519221759},3.1072970121771495,3.1072970121771495,3.1072970121771495,111.02417422551505,111.02417422551505,111.02417422551505,107.76755831681642,107.76755831681642,107.76755831681642,"GREET 2 2023: PET Resin"]
["PP Resin","kg",61.554049343368654,61.053900724689278,1.1247063272713589,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B60","v":19.506806760528267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B60","v":19.506806760528267},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B60","v":19.506806760528267},21.93942898842586,21.93942898842586,21.93942898842586,1200.7229458691143,1200.7229458691143,1200.7229458691143,1190.9666434129904,1190.9666434129904,1190.9666434129904,"GREET 2 2023: PP Resin"]
["PUR Flexible Foam","kg",74.373486677180281,71.921120928230309,3.371001581737862,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B61","v":11.925351488502587},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B61","v":11.925351488502587},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B61","v":11.925351488502587},40.200378730522189,40.200378730522189,40.200378730522189,886.92997005083919,886.92997005083919,886.92997005083919,857.68464651624583,857.68464651624583,857.68464651624583,"GREET 2 2023: PUR Flexible Foam"]
["PUR Rigid Foam","kg",71.017192584583697,68.806737856491978,3.1571359565175263,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B62","v":11.338858792346723},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B62","v":11.338858792346723},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B62","v":11.338858792346723},35.798318799192735,35.798318799192735,35.798318799192735,805.25391854548741,805.25391854548741,805.25391854548741,780.18988451678024,780.18988451678024,780.18988451678024,"GREET 2 2023: PUR Rigid Foam"]
["PVC Resin","kg",51.084397746738532,49.714161030442305,2.2140791947434004,{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B63","v":14.006633055963951},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B63","v":14.006633055963951},{"$f":"'Material Flows'!$F$19*'Expert Data Input'!$B63","v":14.006633055963951},31.011794837614957,31.011794837614957,31.011794837614957,715.5204141234783,715.5204141234783,715.5204141234783,696.32801123850811,696.32801123850811,696.32801123850811,"GREET 2 2023: PVC Resin"]
["PLASTICS PRODUCTION",null,null,null,null,null,null,null,{"$f":"SUM(I44:I59)","v":319.65490820291978},{"$f":"SUM(J44:J59)","v":319.65490820291978},{"$f":"SUM(K44:K59)","v":319.65490820291978},{"$f":"SUM(L44:L59)","v":8061.7842849330891},8061.7842849330891,8061.7842849330891,7875.2530281036716,7875.2530281036716,7875.2530281036716]
["Blow Molding (HDPE)","kg",12.501653202543018,9.8033272823923649,0.75322797434822497,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L65","v":2.0996177595797461},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L65","v":2.0996177595797461},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L65","v":2.0996177595797461},{"$f":"$E61*F61","v":1.5814908319538106},{"$f":"$E61*G61","v":1.5814908319538106},{"$f":"$E61*H61","v":1.5814908319538106},{"$f":"$C61*F61","v":26.248693088166331},{"$f":"$C61*G61","v":26.248693088166331},26.248693088166331,{"$f":"$D61*F61","v":20.583240065083658},{"$f":"$D61*G61","v":20.583240065083658},20.583240065083658,"GREET 2 2023: Blow Molding (HPDE)"]
["Calendaring (PVC)","kg",4.2391595576013898,3.3216235406120664,0.2552862544452123,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L66","v":2.5389355344104794},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L66","v":2.5389355344104794},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L66","v":2.5389355344104794},0.64815534285750476,0.64815534285750476,0.64815534285750476,{"$f":"$C62*F62","v":10.762952836829976},{"$f":"$C62*G62","v":10.762952836829976},{"$f":"$C62*H62","v":10.762952836829976},{"$f":"$D62*F62","v":8.433388039194325},{"$f":"$D62*G62","v":8.433388039194325},{"$f":"$D62*H62","v":8.433388039194325},"GREET 2 2023: Calendaring (PVC)"]
["Compression Molding","kg",10.2776183564234,9.2370988172842203,0.6300400418101505,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L67","v":12.801742320879153},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L67","v":12.801742320879153},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L67","v":12.801742320879153},8.0656102670894754,8.0656102670894754,8.0656102670894754,131.57142187126988,131.57142187126988,131.57142187126988,118.25095885137017,118.25095885137017,118.25095885137017,"GREET 2 2023: Compression Molding"]
["Extrusion (HDPE)","kg",3.9963156007421339,3.131341435671553,0.24066195844529195,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L68","v":5.8589256226847679},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L68","v":5.8589256226847679},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L68","v":5.8589256226847679},1.410020514740618,1.410020514740618,1.410020514740618,23.414115869522959,23.414115869522959,23.414115869522959,18.346296570830567,18.346296570830567,18.346296570830567,"GREET 2 2023: Extrusion (HDPE)"]
["Extrusion (PP)","kg",5.1115116356394958,4.005161199136241,0.30782013327987789,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L70","v":0.34956358807100824},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L70","v":0.34956358807100824},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L70","v":0.34956358807100824},0.1076027102698101,0.1076027102698101,0.1076027102698101,1.7867983478208502,1.7867983478208502,1.7867983478208502,1.4000585195728463,1.4000585195728463,1.4000585195728463,"GREET 2 2023: Extrusion (PVC)"]
["Extrusion (PVC)","kg",3.8501376849627755,3.0168026928918268,0.23185898415407766,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L69","v":7.167934022562183},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L69","v":7.167934022562183},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L69","v":7.167934022562183},1.6619499009547194,1.6619499009547194,1.6619499009547194,27.597532903593478,27.597532903593478,27.597532903593478,21.624242661736538,21.624242661736538,21.624242661736538,"GREET 2 2023: Extrusion (PP)"]
["Injection Molding (HDPE)","kg",14.582425953150496,11.426163291816257,0.87816767727677303,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L71","v":2.8389970964882996},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L71","v":2.8389970964882996},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L71","v":2.8389970964882996},2.4931154860186329,2.4931154860186329,2.4931154860186329,41.39946494074988,41.39946494074988,41.39946494074988,32.438844409467542,32.438844409467542,32.438844409467542,"GREET 2 2023: Injection Molding (HDPE)"]
["Injection Molding (PP)","kg",5.8329703812601998,4.5704653167265041,0.3512670709107093,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L73","v":27.389938557636995},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L73","v":27.389938557636995},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L73","v":27.389938557636995},9.6211834895654444,9.6211834895654444,9.6211834895654444,159.7647003512333,159.7647003512333,159.7647003512333,125.18476420494986,125.18476420494986,125.18476420494986,"GREET 2 2023: Injection Molding (PP)"]
["Injection Molding (PVC)","kg",8.9663647372403137,7.0256586901822518,0.53996308434657536,{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L72","v":4.1099895667528754},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L72","v":4.1099895667528754},{"$f":"'Material Flows'!$E$19*'Expert Data Input'!$L72","v":4.1099895667528754},2.2192426430961274,2.2192426430961274,2.2192426430961274,36.851665521758576,36.851665521758576,{"$f":"$C69*H69","v":36.851665521758576},28.875383916215728,28.875383916215728,28.875383916215728,"GREET 2 2023: Injection Molding (PVC)"]
["PLASTICS FORMING",null,null,null,null,null,null,null,{"$f":"SUM(I61:I69)","v":27.808371186546143},{"$f":"SUM(J61:J69)","v":27.808371186546143},{"$f":"SUM(K61:K69)","v":27.808371186546143},{"$f":"SUM(L61:L69)","v":459.39734573094529},459.39734573094529,459.39734573094529,375.1371772384212,375.1371772384212,375.1371772384212]
["Brake Fluid","kg",53.323165404322758,53.033426233372467,0.84173115383690211,{"$f":"'Expert Data Input'!B69*('Expert Data Input'!C69+1)","v":3.6},{"$f":"F71","v":3.6},{"$f":"F71","v":3.6},{"$f":"$E71*F71","v":3.0302321538128476},3.0302321538128476,3.0302321538128476,{"$f":"$C71*F71","v":191.96339545556194},{"$f":"$C71*G71","v":191.96339545556194},191.96339545556194,{"$f":"$D71*F71","v":190.92033444014089},{"$f":"$D71*G71","v":190.92033444014089},190.92033444014089,"GREET 2 2023: Brake Fluid"]
["Powertrain Coolant","kg",23.117180490413912,22.792944335270171,0.60209656278685286,{"$f":"'Expert Data Input'!B71*('Expert Data Input'!C71+1)","v":28.4},{"$f":"F72","v":28.4},{"$f":"F72","v":28.4},17.09954238314662,17.09954238314662,17.09954238314662,{"$f":"$C72*F72","v":656.52792592775506},{"$f":"$C72*G72","v":656.52792592775506},{"$f":"$C72*H72","v":656.52792592775506},{"$f":"$D72*F72","v":647.31961912167287},{"$f":"$D72*G72","v":647.31961912167287},{"$f":"$D72*H72","v":647.31961912167287},"GREET 2 2023: Powertrain Coolant"]
["Engine Oil","kg",53.323165404322758,53.033426233372467,0.84173115383690211,{"$f":"'Expert Data Input'!B68*('Expert Data Input'!C68+1)","v":0},0,0,0,0,0,0,0,0,0,0,0,"GREET 2 2023: Engine Oil"]
["Transmission Fluid","kg",53.323165404322758,53.033426233372467,0.84173115383690211,{"$f":"'Expert Data Input'!B70*('Expert Data Input'!C70+1)","v":1.6},1.6,1.6,1.3467698461390434,1.3467698461390434,1.3467698461390434,85.317064646916421,85.317064646916421,85.317064646916421,84.853481973395958,84.853481973395958,84.853481973395958,"GREET 2 2023: Transmission Fluid"]
["Windshield Fluid","kg",15.424692364750216,15.227741292193425,0.2430507775955022,{"$f":"'Expert Data Input'!B72*('Expert Data Input'!C72+1)","v":45.900000000000006},45.900000000000006,45.900000000000006,11.156030691633552,11.156030691633552,11.156030691633552,707.99337954203497,707.99337954203497,707.99337954203497,698.95332531167833,698.95332531167833,698.95332531167833,"GREET 2 2023: Windshield Fluid"]
["FLUIDS PRODUCTION",null,null,null,null,null,null,null,{"$f":"SUM(I71:I75)","v":32.63257507473206},{"$f":"SUM(J71:J75)","v":32.63257507473206},{"$f":"SUM(K71:K75)","v":32.63257507473206},{"$f":"SUM(L71:L75)","v":1641.8017655722683},1641.8017655722683,1641.8017655722683,1622.046760846888,1622.046760846888,1622.046760846888]
["Paint Production","car",613.89278868794634,481.02004904756427,36.967110140188282,1,1,1,{"$f":"$E77*F77","v":36.967110140188282},36.967110140188282,36.967110140188282,{"$f":"$C77*F77","v":613.89278868794634},{"$f":"$C77*G77","v":613.89278868794634},613.89278868794634,{"$f":"$D77*F77","v":481.02004904756427},{"$f":"$D77*G77","v":481.02004904756427},481.02004904756427,"GREET 2 2023: Paint Production"]
["Painting","car",3679.3632768174843,3465.7624033851152,232.05321793211809,1,1,1,232.05321793211809,232.05321793211809,232.05321793211809,{"$f":"$C78*F78","v":3679.3632768174843},{"$f":"$C78*G78","v":3679.3632768174843},{"$f":"$C78*H78","v":3679.3632768174843},{"$f":"$D78*F78","v":3465.7624033851152},{"$f":"$D78*G78","v":3465.7624033851152},{"$f":"$D78*H78","v":3465.7624033851152},"GREET 2 2023: Vehicle Assembly - Painting"]
["VAC and Lighting","car",2117.609271083857,1659.2677650072778,127.51720919437771,1,1,1,127.51720919437771,127.51720919437771,127.51720919437771,2117.609271083857,2117.609271083857,2117.609271083857,1659.2677650072778,1659.2677650072778,1659.2677650072778,"GREET 2 2023: Vehicle Assembly - HVAC & Lighting"]
["Heating","car",3498.7081667852822,3496.6828053166073,217.77127074215537,1,1,1,217.77127074215537,217.77127074215537,217.77127074215537,3498.7081667852822,3498.7081667852822,3498.7081667852822,3496.6828053166073,3496.6828053166073,3496.6828053166073,"GREET 2 2023: Vehicle Assembly - Heating"]
["Material Handling","car",438.49484906281884,343.58574931968877,26.405078671563057,1,1,1,26.405078671563057,26.405078671563057,26.405078671563057,438.49484906281884,438.49484906281884,438.49484906281884,343.58574931968877,343.58574931968877,343.58574931968877,"GREET 2 2023: Vehicle Assembly - Material Handling"]
["Welding","car",583.94679899585151,457.55565641109786,35.163836474813252,1,1,1,35.163836474813252,35.163836474813252,35.163836474813252,583.94679899585151,583.94679899585151,583.94679899585151,457.55565641109786,457.55565641109786,457.55565641109786,"GREET 2 2023: Vehicle Assembly - Welding"]
["Compressed Air","car",874.85069886191661,685.49547059391568,52.681352081313619,1,1,1,52.681352081313619,52.681352081313619,52.681352081313619,874.85069886191661,874.85069886191661,874.85069886191661,685.49547059391568,685.49547059391568,685.49547059391568,"GREET 2 2023: Vehicle Assembly - Compressed Air"]
["ASSEMBLY",null,null,null,null,null,null,null,{"$f":"SUM(I77:I83)","v":728.55907523652934},{"$f":"SUM(J77:J83)","v":728.55907523652934},{"$f":"SUM(K77:K83)","v":728.55907523652934},{"$f":"SUM(L77:L83)","v":11806.865850295158},11806.865850295158,11806.865850295158,10589.369899081268,10589.369899081268,10589.369899081268]
["Aluminum","kg",{"$f":"C5-IF('Expert Data Input'!$D15=\"Global\",'LCA Calculations'!C4,'LCA Calculations'!C3)","v":-182.66525612824395},{"$f":"D5-IF('Expert Data Input'!$D15=\"Global\",'LCA Calculations'!D4,'LCA Calculations'!D3)","v":-153.78279892930021},{"$f":"E5-IF('Expert Data Input'!$D15=\"Global\",'LCA Calculations'!E4,'LCA Calculations'!E3)","v":-16.272436689380868},{"$f":"SUM(Recycling!L12:L14)","v":-22.944159203580398},{"$f":"SUM(Recycling!M12:M14)","v":-20.190069966466979},{"$f":"SUM(Recycling!N12:N14)","v":91.202344081507846},{"$f":"$E85*F85","v":373.35737803133736},328.54163528350404,-1484.0843699894663,{"$f":"$C85*F85","v":4191.1007175692193},{"$f":"$C85*G85","v":3688.0243016718564},-16659.499541144865,{"$f":"$D85*F85","v":3528.4170214060573},{"$f":"$D85*G85","v":3104.8854700216943},-14025.351741767374,"NA"]
["Magnesium","kg",{"$f":"C15-((1-'Expert Data Input'!$D14)*C13+'Expert Data Input'!$D14*C14)","v":-295.69207552416856},{"$f":"D15-((1-'Expert Data Input'!$D14)*D13+'Expert Data Input'!$D14*D14)","v":-274.28141599547848},{"$f":"E15-((1-'Expert Data Input'!$D14)*E13+'Expert Data Input'!$D14*E14)","v":-20.542822562840747},{"$f":"SUM(Recycling!L15:L16)","v":0},{"$f":"SUM(Recycling!M15:M16)","v":0},{"$f":"SUM(Recycling!N15:N16)","v":0},0,0,0,{"$f":"$C86*F86","v":0},{"$f":"$C86*G86","v":0},{"$f":"$C86*H86","v":0},{"$f":"$D86*F86","v":0},{"$f":"$D86*G86","v":0},{"$f":"$D86*H86","v":0},"NA"]
["Steel","kg",{"$f":"C21-C20","v":-16.239999999999998},-16.91,{"$f":"E21-E20","v":-1.69},{"$f":"SUM(Recycling!L6:L8)+SUM(Recycling!L9:L11)","v":-25.234539155050641},{"$f":"SUM(Recycling!M6:M8)+SUM(Recycling!M9:M11)","v":-50.379630810150218},{"$f":"SUM(Recycling!N6:N8)+SUM(Recycling!N9:N11)","v":-126.9838411161583},42.646371172035579,85.141576069153871,214.60269148630752,409.80891587802239,{"$f":"$C87*G87","v":818.16520435683947},{"$f":"$C87*H87","v":2062.2175797264108},{"$f":"$D87*F87","v":426.71605711190631},851.91955699964024,{"$f":"$D87*H87","v":2147.2967532742368},"NA"]
["PROMPT RECYCLING",null,null,null,null,null,null,null,{"$f":"SUM(I85:I87)","v":416.00374920337293},{"$f":"SUM(J85:J87)","v":413.68321135265791},{"$f":"SUM(K85:K87)","v":-1269.4816785031587},{"$f":"SUM(L85:L87)","v":4600.9096334472415},4506.1895060286961,-14597.281961418455,3955.1330785179634,3956.8050270213344,-11878.054988493137]
["Biodiesel production, rapeseed (EU)","MJ",0.48403465287431408,0.29993867371808153,-45.110121417284518,{"$f":"'Use '!E19","v":0},{"$f":"'Use '!F19","v":0},{"$f":"'Use '!G19","v":0},{"$f":"$E89*F89/1000","v":0},{"$f":"$E89*G89/1000","v":0},{"$f":"$E89*H89/1000","v":0},{"$f":"$C89*F89","v":0},{"$f":"$C89*G89","v":0},{"$f":"$C89*H89","v":0},{"$f":"$D89*F89","v":0},{"$f":"$D89*G89","v":0},{"$f":"$D89*H89","v":0},"GREET 1 2023: CIDI Vehicle: Canola-based BD100"]
["Biodiesel production, soybean (US)","MJ",0.49290170269306188,0.2267663880166528,-44.784452004114634,{"$f":"'Use '!E18","v":0},{"$f":"'Use '!F18","v":0},{"$f":"'Use '!G18","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: CIDI Vehicle: Soybean-based BD100"]
["Diesel production","MJ",0.18064422514299217,0.1747207202276341,15.279063121849104,{"$f":"'Use '!E14","v":0},{"$f":"'Use '!F14","v":0},{"$f":"'Use '!G14","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Conv. Diesel"]
["Bioethanol production, cellulose (US)","MJ",2.218534210217217,0.10038690247141345,-48.395369667641305,{"$f":"'Use '!E16","v":0},{"$f":"'Use '!F16","v":0},{"$f":"'Use '!G16","v":0},0,0,0,0,0,0,0,0,0,"GREET 1: EtOH FFV: E100, Switchgrass"]
["Bioethanol production, corn (US)","MJ",0.70607388050784592,0.66924037566118211,-16.653774919467295,{"$f":"'Use '!E15","v":0},{"$f":"'Use '!F15","v":0},{"$f":"'Use '!G15","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: EtOH FFV: E100, Corn"]
["Bioethanol production, sugar (Brazil)","MJ",2.6877295994201642,0.23972807049804429,-34.428204792525491,{"$f":"'Use '!E17","v":0},{"$f":"'Use '!F17","v":0},{"$f":"'Use '!G17","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: EtOH FFV: E100, Sugarcane"]
["Gasoline production","MJ",0.27047203562037575,0.242200734918188,16.984370050607041,{"$f":"'Use '!E13","v":0},{"$f":"'Use '!F13","v":0},{"$f":"'Use '!G13","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Gasoline"]
["Compr. hydr. production","MJ",1.9276253101755592,1.4902047834399608,109.09572676819269,{"$f":"'Use '!E20","v":0},{"$f":"'Use '!F20","v":0},{"$f":"'Use '!G20","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Electricity Mix for Hydrogen Pathways"]
["Electricity production, China","MJ",2.434857064176275,1.9840362808672394,194.21059765935561,{"$f":"IF('Data Input'!$P$12=\"China\",'Use '!E21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"China\",'Use '!F21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"China\",'Use '!G21,0)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: China Average"]
["Electricity production, coal","MJ",3.11,3.11,309.01,{"$f":"IF('Data Input'!$P$12=\"Coal\",'Use '!E21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Coal\",'Use '!F21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Coal\",'Use '!G21,0)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Coal-Fired Power Plant"]
["Electricity production, Europe","MJ",2.064175157298036,1.2002678295397819,99.94156649522867,{"$f":"IF('Data Input'!$P$12=\"Europe\",'Use '!E21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Europe\",'Use '!F21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Europe\",'Use '!G21,0)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Europe Average"]
["Electricity production, India","MJ",2.6099259351684019,2.2979043403224364,224.53391143808406,{"$f":"IF('Data Input'!$P$12=\"India\",'Use '!E21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"India\",'Use '!F21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"India\",'Use '!G21,0)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: India Average"]
["Electricity production, Japan","MJ",2.5231546806198861,2.0657463699302303,166.97176274569318,{"$f":"IF('Data Input'!$P$12=\"Japan\",'Use '!E21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Japan\",'Use '!F21,0)","v":0},{"$f":"IF('Data Input'!$P$12=\"Japan\",'Use '!G21,0)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: Japan Average"]
["Electricity production, USA","MJ",2.0299999999999998,1.59,122.09,{"$f":"IF('Data Input'!$P$12=\"USA\",'Use '!E21,0)","v":101361.53447382887},{"$f":"IF('Data Input'!$P$12=\"USA\",'Use '!F21,0)","v":95857.316597473124},{"$f":"IF('Data Input'!$P$12=\"USA\",'Use '!G21,0)","v":94095.966877039304},12375.229743909767,11703.219783385495,11488.176596017729,205763.91498187257,194590.35269287042,191014.81276038976,161164.83981338792,152413.13338998228,149612.58733449251,"GREET 1 2023: Stationary Use: U.S. Mix"]
["Biodiesel combustion","MJ",1,0,76,{"$f":"SUM(F89:F90)","v":0},{"$f":"SUM(G89:G90)","v":0},{"$f":"SUM(H89:H90)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: CIDI Vehicle: Soybean-based BD100"]
["Diesel combustion","MJ",1,1,76,{"$f":"F91","v":0},{"$f":"G91","v":0},{"$f":"H91","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: CIDI Vehicle: Conventional and LS Diesel"]
["Bioethanol combustion","MJ",1,0,70,{"$f":"SUM(F92:F94)","v":0},{"$f":"SUM(G92:G94)","v":0},{"$f":"SUM(H92:H94)","v":0},0,0,0,0,0,0,0,0,0,"GREET 1 2023: EtOH FFV: E100, Corn"]
["Gasoline combustion","MJ",1,1,73,{"$f":"F95","v":0},0,0,0,0,0,0,0,0,0,0,0,"GREET 1 2023: Gasoline Vehicle: Gasoline"]
["Hydrogen use","MJ",1,1,0,0,0,0,{"$f":"E107*F107","v":0},{"$f":"E107*G107","v":0},{"$f":"E107*H107","v":0},0,0,0,0,0,0,"N/A"]
["USE",null,null,null,null,null,null,null,{"$f":"SUM(I89:I107)","v":12375.229743909767},11703.219783385495,11488.176596017729,205763.91498187257,194590.35269287042,191014.81276038976,161164.83981338792,152413.13338998228,149612.58733449251]
["Aluminum","kg",{"$f":"C85","v":-182.66525612824395},{"$f":"D85","v":-153.78279892930021},{"$f":"E85","v":-16.272436689380868},{"$f":"SUM(Recycling!O12:O14)","v":40.673297669851671},{"$f":"SUM(Recycling!P12:P14)","v":33.160136703043634},{"$f":"SUM(Recycling!Q12:Q14)","v":165.63510347607814},{"$f":"$E109*F109","v":-661.85366128100372},-539.59622511149234,-2695.2867348535306,{"$f":"$C109*F109","v":-7429.5983364437634},-6057.2048641090487,-30255.778600286005,{"$f":"$D109*F109","v":-6254.8535573543741},-5099.4586350722675,-25471.829813495558,"NA"]
["Battery recycling, pyrometallurgical","kg",-131.63999999999999,-121.83,-7.51,{"$f":"'Expert Data Input'!B32*Recycling!O26","v":177.25681089463191},{"$f":"'Expert Data Input'!B32*Recycling!P26","v":159.00572578275643},{"$f":"'Expert Data Input'!B32*Recycling!Q26","v":153.1653785469563},-1331.1986498186857,-1194.1330006285007,-1150.2719928876418,-23334.086586169342,-20931.513742042054,-20162.690431921324,-21595.197271293004,-19371.667572113216,-18660.138068375687,"Ecoinvent"]
["Battery recycling, hydrometallurigical","kg",-31.35,-26.31,-2.13,{"$f":"(1-'Expert Data Input'!B32)*Recycling!O26","v":177.25681089463191},{"$f":"(1-'Expert Data Input'!B32)*Recycling!P26","v":159.00572578275643},{"$f":"(1-'Expert Data Input'!B32)*Recycling!Q26","v":153.1653785469563},-377.55700720556598,-338.6821959172712,-326.24225630501689,-5557.0010215467109,-4984.8295032894139,-4801.7346174470804,-4663.6266946377655,-4183.4406453443216,-4029.7811095704201,"Ecoinvent"]
["Magnesium","kg",{"$f":"C86","v":-295.69207552416856},-274.28141599547848,-20.542822562840747,{"$f":"SUM(Recycling!O15:O16)","v":0},{"$f":"SUM(Recycling!P15:P16)","v":0},{"$f":"SUM(Recycling!Q15:Q16)","v":0},0,0,0,0,0,0,0,0,0,"NA"]
["Steel","kg",-16.239999999999998,-16.91,-1.69,{"$f":"SUM(Recycling!O6:O8)+SUM(Recycling!O9:O11)","v":491.66364100699673},{"$f":"SUM(Recycling!P6:P8)+SUM(Recycling!P9:P11)","v":416.56811487919481},{"$f":"SUM(Recycling!Q6:Q8)+SUM(Recycling!Q9:Q11)","v":217.48358492789606},-830.91155330182448,-704.00011414583923,{"$f":"$E113*H113","v":-367.54725852814431},-7984.6175299536262,-6765.066185638123,-3531.9334192290316,-8314.0321694283139,-7044.1668226071843,-3677.6474211307223,"NA"]
["EOL RECYCLING",null,null,null,null,null,null,null,{"$f":"SUM(I109:I113)","v":-3201.5208716070797},{"$f":"SUM(J109:J113)","v":-2776.4115358031036},{"$f":"SUM(K109:K113)","v":-4539.3482425743332},-44305.30347411344,-38738.614295078638,-58752.137068883443,-40827.709692713455,-35698.733675136988,-51839.396412572387]
[]
[]
[null,null,null,null,null,null,null,"GHG Emissions (in kg CO2 eq)","Production","Use","End of Life"]
[null,null,null,null,null,null,null,"Baseline",{"$f":"I24+I43+I60+I70+I76+I84+I88","v":8890.659807052094},{"$f":"I108","v":12375.229743909767},{"$f":"I114","v":-3201.5208716070797}]
[null,null,null,null,null,null,null,"Contender 1",{"$f":"J24+J43+J60+J70+J76+J84+J88","v":7986.8577438489929},{"$f":"J108","v":11703.219783385495},{"$f":"J114","v":-2776.4115358031036}]
[null,null,null,null,null,null,null,"Contender 2",{"$f":"K24+K43+K60+K70+K76+K84+K88","v":10894.384331309513},{"$f":"K108","v":11488.176596017729},{"$f":"K114","v":-4539.3482425743332}]
[]
[null,null,null,null,null,null,null,"Total Energy Requirements (in MJ)","Production","Use","End of Life"]
[null,null,null,null,null,null,null,"Baseline",{"$f":"L24+L43+L60+L70+L76+L84+L88","v":128260.80149502995},{"$f":"L108","v":205763.91498187257},{"$f":"L114","v":-44305.30347411344}]
[null,null,null,null,null,null,null,"Contender 1",{"$f":"M24+M43+M60+M70+M76+M84+M88","v":116117.33908649349},{"$f":"M108","v":194590.35269287042},{"$f":"M114","v":-38738.614295078638}]
[null,null,null,null,null,null,null,"Contender 2",{"$f":"N24+N43+N60+N70+N76+N84+N88","v":149296.39035066636},{"$f":"N108","v":191014.81276038976},{"$f":"N114","v":-58752.137068883443}]
[]
[null,null,null,null,null,null,null,"Fossil Energy Requirements (in MJ)","Production","Use","End of Life"]
[null,null,null,null,null,null,null,"Baseline",{"$f":"O24+O43+O60+O70+O76+O84+O88","v":116877.84994805377},{"$f":"O108","v":161164.83981338792},{"$f":"O114","v":-40827.709692713455}]
[null,null,null,null,null,null,null,"Contender 1",{"$f":"P24+P43+P60+P70+P76+P84+P88","v":105956.71634044989},{"$f":"P108","v":152413.13338998228},{"$f":"P114","v":-35698.733675136988}]
[null,null,null,null,null,null,null,"Contender 2",{"$f":"Q24+Q43+Q60+Q70+Q76+Q84+Q88","v":133471.96059284805},{"$f":"Q108","v":149612.58733449251},{"$f":"Q114","v":-51839.396412572387}]