Page 1 of 1

Emissions Output Tweak

PostPosted: Fri Sep 14, 2012 2:17 pm
by briniker
For Fuel Consumption, could the option be added to display the Emissions output in Gallons instead of Grams. We have researched a conversion formula that we could probably share with you. Thanks!

Re: Emissions Output Tweak

PostPosted: Sat Sep 15, 2012 4:30 am
by bullock
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:
  1. change the description to indicate gal/veh,
  2. choose any column symbol you like, as long as it's not already in use by another column,
  3. (on the Formula tab), click "Node along the Route" for the Calculate at Each setting, and
  4. 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:
  1. change the description to indicate gal/hr,
  2. choose any column symbol you like, as long as it's not already in use by another column, and
  3. (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