That's a fine suggestion.
Turns out you can already do this by creating a user-defined column for the TT&D report. It's probably easiest to use an existing Fuel Consumption column as a template, so you can start by copying and pasting that column to make a duplicate. Navigate to View: Preferences: Layout: TT&D Report: Report Columns.
If you're seeking gal/trip (or gal/veh), then copy the user-defined column labelled CMEM_VC4_TFC. Edit the duplicate report column:
- change the description to indicate gal/veh,
- choose any column symbol you like, as long as it's not already in use by another column,
- (on the Formula tab), click "Node along the Route" for the Calculate at Each setting, and
- set the formula to
- Code: Select all
CMEM_VC4_TFC
/735 // typical density of gasoline = 735 g/L
/3.785 // 1 gal = 3.785 L
If you're seeking gal/hr, then copy the user-defined column labelled CMEM_VC4_FC. Edit the duplicate report column:
- change the description to indicate gal/hr,
- choose any column symbol you like, as long as it's not already in use by another column, and
- (on the Formula tab), set the formula to
- Code: Select all
CMEM_VC4_TFC*TV
/735 // typical density of gasoline = 735 g/L
/3.785 // 1 gal = 3.785 L
In either case, you may wish to substitute a different value for the density of gasoline in the above. The density changes, for example, with seasonal formulations.
Also, you'll probably want to uncheck the box next to the no-longer-desired column giving the fuel consumption in grams, so your reports will have just one column for fuel consumption.
Regards.
Greg