@yiyi1991 shared an Excel document expressing the following requested changes, identified in the context of the NGFS project:
Rename
The names on the right should instead be output as the labels on the left:
Details
Energy Service|Transportation|Passenger ← Energy Service|Transportation|P
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle|Battery-Electric ← Energy Service|Transportation|P|Transport Vehicle Elc_100
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle|Fuel-Cell-Electric ← Energy Service|Transportation|P|Transport Vehicle Hfc_Ptrp
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle|Plug-in Hybrid ← Energy Service|Transportation|P|Transport Vehicle Phev_Ptrp
Energy Service|Transportation|Freight ← Energy Service|Transportation|F
Energy Service|Transportation|Freight|Truck ← Energy Service|Transportation|Truck
Final Energy|Transportation|Bus|Gases ← Final Energy|Transportation|Bus|Gas
Final Energy|Transportation|Bus|Gases|Hydrogen ← Final Energy|Transportation|Bus|Hydrogen
Final Energy|Transportation|Freight ← Final Energy|Transportation|F
Final Energy|Transportation|Freight|Electricity ← Final Energy|Transportation|F|Electricity
Final Energy|Transportation|Freight|Gases ← Final Energy|Transportation|F|Gas
Final Energy|Transportation|Freight|Liquids|Biomass ← Final Energy|Transportation|F|Liquids|Biomass
Final Energy|Transportation|Light-Duty Vehicle ← Final Energy|Transportation|LDV
Final Energy|Transportation|Light-Duty Vehicle|Electricity ← Final Energy|Transportation|LDV|Electricity
Final Energy|Transportation|Light-Duty Vehicle|Gases ← Final Energy|Transportation|LDV|Gas
Final Energy|Transportation|Light-Duty Vehicle|Hydrogen ← Final Energy|Transportation|LDV|Hydrogen
Final Energy|Transportation|Light-Duty Vehicle|Liquids|Biomass ← Final Energy|Transportation|LDV|Liquids|Biomass
Final Energy|Transportation|Light-Duty Vehicle|Liquids|Coal ← Final Energy|Transportation|LDV|Liquids|Coal
Final Energy|Transportation|Light-Duty Vehicle|Liquids|Oil ← Final Energy|Transportation|LDV|Liquids|Oil
Final Energy|Transportation|Passenger ← Final Energy|Transportation|P
Final Energy|Transportation|Passenger|Electricity ← Final Energy|Transportation|P|Electricity
Final Energy|Transportation|Passenger|Gases ← Final Energy|Transportation|P|Gas
Final Energy|Transportation|Passenger|Liquids|Hydrogen ← Final Energy|Transportation|P|Hydrogen
Final Energy|Transportation|Passenger|Liquids|Biomass ← Final Energy|Transportation|P|Liquids|Biomass
Final Energy|Transportation|Passenger|Liquids|Coal ← Final Energy|Transportation|P|Liquids|Coal
Final Energy|Transportation|Passenger|Liquids|Oil ← Final Energy|Transportation|P|Liquids|Oil
Final Energy|Transportation|Truck|Gases ← Final Energy|Transportation|Truck|Gas
Sales|Transportation|Light-Duty Vehicle|Battery-Electric ← CAP_NEW|Transport|Sales|Road|Passenger|LDV|BEV
Sales|Transportation|Light-Duty Vehicle|Fuel-Cell-Electric ← CAP_NEW|Transport|Sales|Road|Passenger|LDV|FCEV
Sales|Transportation|Light-Duty Vehicle|Plug-in Hybrid ← CAP_NEW|Transport|Sales|Road|Passenger|LDV|PHEV
Stocks|Transportation|Light-Duty Vehicle|Battery-Electric ← Transport|Stock|Road|Passenger|LDV|BEV
Stocks|Transportation|Light-Duty Vehicle|Fuel-Cell-Electric ← Transport|Stock|Road|Passenger|LDV|FCEV
Stocks|Transportation|Light-Duty Vehicle|Plug-in Hybrid ← Transport|Stock|Road|Passenger|LDV|PHEV
Compute sums
Values for the label at the top of each list should be the sum of the values for the labels in each list.
Some of these are computed outside of .model.transport.report, so probably will need to be addressed through the integration of transport and other reporting.
Details
Energy Service|Transportation|Passenger|Road
- Energy Service|Transportation|P|Transport Vehicle 2W
- Energy Service|Transportation|P|Transport Vehicle Bus
- Energy Service|Transportation|P|Transport Vehicle Elc_100
- Energy Service|Transportation|P|Transport Vehicle Hfc_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Phev_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Iahe_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Iahm_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Icae_Ffv
- Energy Service|Transportation|P|Transport Vehicle Icam_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Conv
- Energy Service|Transportation|P|Transport Vehicle Ice_L_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Nga
- Energy Service|Transportation|P|Transport Vehicle Ich_Chyb
- Energy Service|Transportation|P|Transport Vehicle Igh_Ghyb
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle
- Energy Service|Transportation|P|Transport Vehicle Elc_100
- Energy Service|Transportation|P|Transport Vehicle Hfc_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Phev_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Iahe_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Iahm_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Icae_Ffv
- Energy Service|Transportation|P|Transport Vehicle Icam_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Conv
- Energy Service|Transportation|P|Transport Vehicle Ice_L_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Nga
- Energy Service|Transportation|P|Transport Vehicle Ich_Chyb
- Energy Service|Transportation|P|Transport Vehicle Igh_Ghyb
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle|Internal Combustion
- Energy Service|Transportation|P|Transport Vehicle Iahe_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Iahm_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Icae_Ffv
- Energy Service|Transportation|P|Transport Vehicle Icam_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Conv
- Energy Service|Transportation|P|Transport Vehicle Ice_L_Ptrp
- Energy Service|Transportation|P|Transport Vehicle Ice_Nga
- Energy Service|Transportation|P|Transport Vehicle Ich_Chyb
- Energy Service|Transportation|P|Transport Vehicle Igh_Ghyb
Final Energy|Transportation
- Final Energy|Transportation|F
- Final Energy|Transportation|P
Final Energy|Transportation|Bus|Liquids
- Final Energy|Transportation|Bus|Liquids|Biomass
- Final Energy|Transportation|Bus|Liquids|Coal
- Final Energy|Transportation|Bus|Liquids|Oil
Final Energy|Transportation|Domestic Aviation|Liquids
- Final Energy|Transportation|Domestic Aviation|Liquids|Coal
- Final Energy|Transportation|Domestic Aviation|Liquids|Oil
- Final Energy|Transportation|Domestic Aviation|Liquids|Biomass
Final Energy|Transportation|Electricity
- Final Energy|Transportation|P|Electricity
- Final Energy|Transportation|F|Electricity
Final Energy|Transportation|Freight|Liquids
- Final Energy|Transportation|F|Liquids|Biomass
- Final Energy|Transportation|F|Liquids|Coal
- Final Energy|Transportation|F|Liquids|Oil
Final Energy|Transportation|Gases
- Final Energy|Transportation|F|Gas
- Final Energy|Transportation|P|Gas
Final Energy|Transportation|Hydrogen
- Final Energy|Transportation|P|Hydrogen
- Final Energy|Transportation|F|Hydrogen
Final Energy|Transportation|Light-Duty Vehicle|Liquids
- Final Energy|Transportation|LDV|Liquids|Biomass
- Final Energy|Transportation|LDV|Liquids|Coal
- Final Energy|Transportation|LDV|Liquids|Oil
Final Energy|Transportation|Liquids
- Final Energy|Transportation|F|Liquids|Biomass
- Final Energy|Transportation|F|Liquids|Coal
- Final Energy|Transportation|F|Liquids|Oil
- Final Energy|Transportation|P|Liquids|Biomass
- Final Energy|Transportation|P|Liquids|Coal
- Final Energy|Transportation|P|Liquids|Oil
Final Energy|Transportation|Liquids|Biomass
- Final Energy|Transportation|F|Liquids|Biomass
- Final Energy|Transportation|P|Liquids|Biomass
Final Energy|Transportation|Liquids|Coal
- Final Energy|Transportation|F|Liquids|Coal
- Final Energy|Transportation|P|Liquids|Coal
Final Energy|Transportation|Liquids|Oil
- Final Energy|Transportation|F|Liquids|Oil
- Final Energy|Transportation|P|Liquids|Oil
Final Energy|Transportation|Passenger|Liquids
- Final Energy|Transportation|P|Liquids|Biomass
- Final Energy|Transportation|P|Liquids|Coal
- Final Energy|Transportation|P|Liquids|Oil
Final Energy|Transportation|Truck|Liquids
- Final Energy|Transportation|Truck|Liquids|Biomass
- Final Energy|Transportation|Truck|Liquids|Coal
- Final Energy|Transportation|Truck|Liquids|Oil
Sales|Transportation|Light-Duty Vehicle
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|BEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|FCEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Biofuel ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Biofuel hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Gas ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Gas hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|ICEV (pre-2005)
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Methanol hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Synfuel ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|PHEV
Sales|Transportation|Light-Duty Vehicle|Internal Combustion
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Biofuel ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Biofuel hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Gas ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Gas hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|ICEV
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|ICEV (pre-2005)
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Methanol hybrid
- CAP_NEW|Transport|Sales|Road|Passenger|LDV|Synfuel ICEV
Stocks|Transportation|Light-Duty Vehicle
- Transport|Stock|Road|Passenger|LDV|BEV
- Transport|Stock|Road|Passenger|LDV|FCEV
- Transport|Stock|Road|Passenger|LDV|Biofuel ICEV
- Transport|Stock|Road|Passenger|LDV|Biofuel hybrid
- Transport|Stock|Road|Passenger|LDV|Gas ICEV
- Transport|Stock|Road|Passenger|LDV|Gas hybrid
- Transport|Stock|Road|Passenger|LDV|Hybrid
- Transport|Stock|Road|Passenger|LDV|ICEV
- Transport|Stock|Road|Passenger|LDV|ICEV (pre-2005)
- Transport|Stock|Road|Passenger|LDV|Methanol hybrid
- Transport|Stock|Road|Passenger|LDV|Synfuel ICEV
- Transport|Stock|Road|Passenger|LDV|PHEV
Stocks|Transportation|Light-Duty Vehicle|Internal Combustion
- Transport|Stock|Road|Passenger|LDV|Biofuel ICEV
- Transport|Stock|Road|Passenger|LDV|Biofuel hybrid
- Transport|Stock|Road|Passenger|LDV|Gas ICEV
- Transport|Stock|Road|Passenger|LDV|Gas hybrid
- Transport|Stock|Road|Passenger|LDV|Hybrid
- Transport|Stock|Road|Passenger|LDV|ICEV
- Transport|Stock|Road|Passenger|LDV|ICEV (pre-2005)
- Transport|Stock|Road|Passenger|LDV|Methanol hybrid
- Transport|Stock|Road|Passenger|LDV|Synfuel ICEV
Final Energy
- Final Energy|Industry
- Final Energy|Residential and Commercial
- Final Energy|Transportation|F
- Final Energy|Transportation|P
- Final Energy|Non-Energy Use
- Final Energy|Carbon Management
- Final Energy|Bunkers
Emissions|CO2|Energy|Demand
- Emissions|CO2|Energy|Demand|AFOFI
- Emissions|CO2|Energy|Demand|Bunkers
- Emissions|CO2|Energy|Demand|Industry
- Emissions|CO2|Energy|Demand|Other Sector
- Emissions|CO2|Energy|Demand|Residential and Commercial
- Emissions|CO2|Energy|Demand|Transportation
Emissions|CO2
- Emissions|CO2|Energy|Supply
- Emissions|CO2|Energy|Demand|AFOFI
- Emissions|CO2|Energy|Demand|Bunkers
- Emissions|CO2|Energy|Demand|Industry
- Emissions|CO2|Energy|Demand|Other Sector
- Emissions|CO2|Energy|Demand|Residential and Commercial
- Emissions|CO2|Energy|Demand|Transportation
- Emissions|CO2|AFOLU
- Emissions|CO2|Industrial Processes
- Emissions|CO2|Natural
- Emissions|CO2|Product Use
- Emissions|CO2|Waste
- Emissions|CO2|Capture and Removal
Discard/remove
Energy Service|Transportation|Passenger|Road
Energy Service|Transportation|Passenger|Road|Light-Duty Vehicle
Final Energy|Transportation
Final Energy|Transportation|Electricity
Final Energy|Transportation|Gases
Final Energy|Transportation|Hydrogen
Final Energy|Transportation|Liquids|Biomass
Final Energy|Transportation|Liquids|Coal
Final Energy|Transportation|Liquids|Oil
Final Energy|Transportation|Liquids
@yiyi1991 shared an Excel document expressing the following requested changes, identified in the context of the NGFS project:
Rename
The names on the right should instead be output as the labels on the left:
Details
Compute sums
Values for the label at the top of each list should be the sum of the values for the labels in each list.
Some of these are computed outside of
.model.transport.report, so probably will need to be addressed through the integration of transport and other reporting.Details
Discard/remove