| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Fuel Consumption | ='Lifetime Cost Calculator'!C21 [gespeicherter Wert: 0] | | | | | | | | |
| Energy Content | =INDEX(D39:D48,'Lifetime Cost Calculator'!L54) [gespeicherter Wert: 3.6] | | | | | | | | |
| Energy Consumption (MJ/km) | =((C4/100)*C5) [gespeicherter Wert: 0] | | | | | | | | |
| Cost for reference fuel per litre (€/l) | ='Lifetime Cost Calculator'!C37 [gespeicherter Wert: 0] | | | | | | | | |
| Energy content of reference fuel | =IF('Lifetime Cost Calculator'!K70=1,'Calculation Sheet'!D39,IF('Lifetime Cost Calculator'!K70=2,'Calculation Sheet'!D40,"INCORRECT")) [gespeicherter Wert: 32] | | | | | | | | |
| Cost per unit of energy (€/MJ) | =(C7/C8) [gespeicherter Wert: 0] | | | | | | | | |
| Lifetime mileage (km) | =IF('Lifetime Cost Calculator'!K71=1,'Lifetime Cost Calculator'!D44,IF('Lifetime Cost Calculator'!K71=2,"200000",IF('Lifetime Cost Calculator'!K71=3,"250000",IF('Lifetime Cost Calculator'!K71=4,1000000,IF('Lifetime Cost Calculator'!K71=5,800000,"INCORRECT"))))) [gespeicherter Wert: 200000] | | | | | | | | |
| Lifetime cost of energy consumption (€) | =(C6*C9*C10) [gespeicherter Wert: 0] | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Cost of CO2 (€/t) | =IF('Lifetime Cost Calculator'!C40>0,'Lifetime Cost Calculator'!C40,30) [gespeicherter Wert: 30] | | | | | | | | |
| CO2 Emissions (g/km) | ='Lifetime Cost Calculator'!C25 [gespeicherter Wert: 0] | | | | | | | | |
| Lifetime cost of CO2 emissions (€) | =(C15*(C14/1000000)*C10) [gespeicherter Wert: 0] | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Nox Emissions (g/km) | =IF('Lifetime Cost Calculator'!K67=1,'Lifetime Cost Calculator'!C30,IF('Lifetime Cost Calculator'!K67=2,'Calculation Sheet'!B56,"INCORRECT")) [gespeicherter Wert: INCORRECT] | | | | | | | | |
| Lifetime Nox Emissions (g) | =C19*C10 [gespeicherter Wert: #VALUE!] | | | | | | | | |
| Lifetime cost of NOx emissions (€) | =C20*B51 [gespeicherter Wert: #VALUE!] | | | | | | | | |
| PM Emissions (g/km) | =IF('Lifetime Cost Calculator'!K68=1,'Lifetime Cost Calculator'!C31,IF('Lifetime Cost Calculator'!K68=2,'Calculation Sheet'!B57,"INCORRECT")) [gespeicherter Wert: INCORRECT] | | | | | | | | |
| Lifetime PM Emissions (g) | =C22*C10 [gespeicherter Wert: #VALUE!] | | | | | | | | |
| Lifetime cost of PM emissions (€) | =C23*B52 [gespeicherter Wert: #VALUE!] | | | | | | | | |
| NMHC Emissions (g/km) | =IF('Lifetime Cost Calculator'!K69=1,'Lifetime Cost Calculator'!C32,IF('Lifetime Cost Calculator'!K69=2,'Calculation Sheet'!B58,"INCORRECT")) [gespeicherter Wert: INCORRECT] | | | | | | | | |
| Lifetime NMHC Emissions (g) | =(C25*C10) [gespeicherter Wert: #VALUE!] | | | | | | | | |
| Lifetime cost of NMHC emissions (€) | =C26*B53 [gespeicherter Wert: #VALUE!] | | | | | | | | |
| Lifetime cost of pollutant emissions (€) | =SUM(C27+C24+C21) [gespeicherter Wert: #VALUE!] | | | | | | | | |
| | | | | | | | | | |
| Lifetime Costs: | =SUM(C11+C16+C28) [gespeicherter Wert: #VALUE!] | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Fuel Type | | Energy Content | Unit Energy Content | Unit fuel consumption | | | | | |
| Diesel | | 36 | MJ/l | l/100km | | | | | |
| Petrol | | 32 | MJ/l | l/100km | | | | | |
| Natural Gas/Biogas | | ='Lifetime Cost Calculator'!E7 [gespeicherter Wert: 0] | MJ/Nm3 | Nm3/100km | | | | | |
| LPG | | 24 | MJ/l | l/100km | | | | | |
| Ethanol | | 21 | MJ/l | l/100km | | | | | |
| Biodiesel | | 33 | MJ/l | l/100km | | | | | |
| Emulsion Fuel | | 32 | MJ/l | l/100km | | | | | |
| Hydrogen (gas) | | 11 | MJ/Nm3 | Nm3/100km | | | | | |
| Hydrogen (liquid) | | =IF('Lifetime Cost Calculator'!K66=1,"8,46",IF('Lifetime Cost Calculator'!K66=3,"120","INCORRECT")) [gespeicherter Wert: INCORRECT] | MJ/l or MJ/kg | l/100km or kg/100km | | | | | |
| Electricity | | 3.6 | MJ/kWh | kWh/100km | | | | | |
| | | | | | | | | | |
| Emissions | Cost per unit €/g | | | | | | | | | |
| Nox Emissions | 0.0044 | | | | | | | | | |
| PM Emissions | 0.087 | | | | | | | | | |
| NMHC Emissions | 0.001 | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| Nox if in g/kWhr | =('Lifetime Cost Calculator'!C30/3.6)*'Calculation Sheet'!C6 [gespeicherter Wert: 0] | | | | | | | | | |
| PM if in g/kWh | =('Lifetime Cost Calculator'!C31/3.6)*'Calculation Sheet'!C6 [gespeicherter Wert: 0] | | | | | | | | | |
| NMHC if in g/kWh | =('Lifetime Cost Calculator'!C32/3.6)*'Calculation Sheet'!C6 [gespeicherter Wert: 0] | | | | | | | | | |
| | | | | | | | | | |
| Energy content | | | | | | | | | |
| Hydrogen Liquid | 8.46 | MJ/l | | | | | | | | |
| 33.33 | MJ/kg | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |
| | | | | | | | | | |