Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Truck Carrier Partner 2.O.I4Tool:
Data Entry and Troubleshooting Guide
2OI4 Data Year - United States Version
SEPA
United Stales

-------
Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Truck Carrier Partner 2.O.I4Tool:
Data Entry and Troubleshooting Guide
2OI4 Data Year - United States Version
Transportation and Climate Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
        :«J Stales                   Office ofTransportation and Air Quality
             PnotBdion                        EPA-420-B-15-003
                                          ,   „„._
                                          January 2015

-------
Table of Contents
  TABLE OF CONTENTS	3
  INTRODUCTION	5
PART 1: DOWNLOADING AND SETTING UP THE TOOL	6
  DOWNLOADING AND SETTING UP THE TOOL	7
     Software and Hardware Requirements	7
     Downloading the SmartWay Truck Carrier Tool	7
     How to Set Security Levels for the SmartWay Tools	7
        Security Settings For Excel 2003 Users	8
        Security Settings For Excel 2007 Users	9
        Security Settings For Excel 2010 and 2013 Users	15
PART 2: TOOL ORGANIZATION	19
  BASIC ORGANIZATION OF THE SMARTWAY TRUCK CARRIER TOOL	20
  REVIEWING THE INTRODUCTORY SCREENS	22
     SmartWay Introduction Screen	23
     SmartWay Partnership Annual Agreement Screen	24
     SmartWay Tool Selection Screen	25
     Required Information Screen	26
     SmartWay Partner Schedule Screen	26
     US/Canadian Operations Screen	27
  BASIC OVERVIEW OF How TO COMPLETE THE TOOL	29
     Sections of the Tool	30
     Entering Your Data	30
     Validating Your Data	31
     Saving Your Data	31
     Reviewing Your Data	31
     Partner Profile/Logo Info/Suggestions	31
     Submitting Data to SmartWay	31
PART 3: SECTION-BY-SECTION DATA ENTRY GUIDANCE	32
  PREPARING FOR DATA ENTRY	33
  SECTION 1 DATA ENTRY: ENTER PARTNER NAME	34
        Section 1 Overview	34
            Steps for Entering Partner Name	34
  SECTION 2 DATA ENTRY:  ENTER COMPANY AND CONTACT INFORMATION	35
        Section 2 Overview	35
  SECTION 3 DATA ENTRY:  CHARACTERIZE YOUR FLEETS	41
        "Identify Fleets" Screen Overview	42
            Steps for Completing "Identify  Fleets" Screen:	44
        "Fleet Details" Screen Overview	46
            Steps for Completing "Fleet Details" Screen	47
        "Operation Categories" Screen Overview	48
            Steps for Completing "Operation Categories" Screen:	49
        "Body Types" Screen Overview	50
            Steps for Completing "Body Types" Screen:	50
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 3

-------
      "SmartWay Category" Screen	51
SECTION 4: SELECT FLEET FOR DATA ENTRY (PROVIDING ACTIVITY AND FUEL CONSUMPTION INFORMATION FOR YOUR FLEETS)	52
      Fleet Status Review Overview	53
           Steps for Selecting a Fleet to Review:	54
      "General Information" Screen Overview	55
           Steps for Completing "General Information" Screen	57
      Fuel SECTION: "Engine Model Year & Class" Overview	58
           Steps for Completing the "Engine Model Year & Class" Screen	59
      Fuel SECTION: "Activity Information" Screen Overview	60
      Main Fuel Activity Data Points Overview	62
           Steps for Completing the Main Fuel Data Points on the "Activity Information" Screen	64
      "Fuel Allocator Worksheet" Overview	66
           Steps for Completing the "Fuel Allocator Worksheet"	68
      (OPTIONAL) "Biodiesel Blend Worksheet" Overview	69
           Steps for Completing the "Biodiesel Blend Worksheet "	69
      (OPTIONAL) "Ethanol Blend Worksheet" Overview	70
           Steps for Completing the "Ethanol Blend Worksheet "	70
      Payload and Capacity Overview on the "Activity Information" Screen	71
           Steps for Completing the Payload Section on the "Activity Information" Screen	77
      Average Capacity Volume (cubic feet) Worksheet Overview on the "Activity Information" Screen	78
           Steps for Completing Average Capacity Volume (cubic feet) Worksheet on the "Activity Information" Screen	80
      Percent (%) Capacity Utilization Section Overview on the "Activity Information" Screen	81
           Steps for Completing the % Capacity Utilization Section on the "Activity Information" Screen	81
      Road Type/Speed Category Section Overview on the "Activity Information" Screen	82
           Steps for Completing the Road Type / Speed Category Section on the "Activity Information" Screen	82
      Average Annual Idle Hours per Truck Section  Overview on the "Activity Information" Screen	83
           Steps for Completing the Average Annual Idle Hours per Truck Section on the "Activity Information" Screen	84
      "PM Reduction" Screen Overview	85
           Steps for Completing the "PM Reduction" Screen	86
VALIDATING YOUR DATA	87
VIEWING YEAR-TO-YEAR COMPARISON	93
PROVIDING ADDITIONAL INFORMATION	98
VIEWING REPORTS	101
SUBMITTING DATA TO SMARTWAY	104
TROUBLESHOOTING THE TOOL	107
APPENDIX A-PORT DRAY PROGRAM DATA REQUIREMENTS AND CALCULATIONS	Ill
APPENDIX B—RECOMMENDED DATASOURCES FOR ACTIVITY DATA	117
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 4

-------
Introduction
This guide is the second of two guides available to help your company participate fully in the SmartWay
Transport Partnership as a Truck Carrier Partner.

The first guide, the Truck Carrier Tool "Quick Start Guide/' provides a basic walk-through of the process
of identifying, gathering, preparing, and submitting your data using the SmartWay Truck Carrier Tool.
(From this point on, this guide will refer to the SmartWay Truck Carrier Tool as the "Truck Carrier Tool" or
simply, the "Tool," for brevity.)

The Quick Start Guide may be all you need to successfully complete the Truck Carrier Tool.

This guide, the Truck Carrier Tool "Data Entry and Troubleshooting Guide," is intended to supplement the
Quick Start Guide and provide more detailed information for completing your Tool submission.

The Table of Contents for this guide is designed so that you can find the relevant information on specific
topics without reading the entire guide.

In this guide, you will learn how to enter the fleet composition and activity data you collected (as
mentioned Quick Start Guide and the online data entry forms it references) into the Truck Carrier Tool.
This guide covers:
           Downloading and setting up the Tool to run properly
           Basic organization of the Truck Carrier Tool
           Entering your data
           Viewing fleet performance summary data
           Submitting data to SmartWay
           Troubleshooting the Tool
           Appendices
                                         WARNING!

  Completing this Tool requires a considerable amount of information about yourfleet(s). There are many
 sections and screens to complete for each fleet. While you will have the ability to save your Tool along the
    way and return to it at anytime, we STRONGLY ENCOURAGE you to review the Quick Start Guide to
    understand key information about joining the partnership and preparing the required data BEFORE
                                 attempting to complete the Tool.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 5

-------
PART 1:
DOWNLOADING AND
SETTING UP THE TOOL
         Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 6

-------
Downloading and Setting up the Tool
SOFTWARE AND HARDWARE REQUIREMENTS

The Truck Carrier Tool was designed in Microsoft Excel. Microsoft Excel is an electronic spreadsheet
program used for storing and manipulating data. Microsoft Excel Forms were used to enable the
functional capabilities of the Tool.

Completing the Truck Carrier Tool requires the following software and hardware:

       •     A 2003 or later version of Microsoft Excel
       •     Excel security level set at Medium or lower
       •     A PC running Windows XP or newer operating system, or a Mac that is running the
             Windows XP operating system The tool does not currently work using the Mac operating
             system
       •     At least 10 megabytes of available disk space (more disk space may be required based on
             the number of companies you define in your Tool).
       •     Adequate memory (RAM) to run Microsoft Office
       •     A monitor resolution of at least 1,024 x 768

Check with the user guides for your computer, online support, or your company's IT department to make
sure your system is set up to use the Truck Carrier Tool.

We encourage you to make sure that you virus software is up to date, and scan your PC before putting
data in the Truck Carrier Tool.


DOWNLOADING THE SMARTWAY TRUCK CARRIER TOOL

To download the Truck Carrier Tool, visit: http://www.epa.gov/smartway/forcarriers/index.htm.htm

Save the Tool in a folder on your hard drive; this folder will house copies of your data and future updates.

How TO SET SECURITY LEVELS FOR THE SMARTWAY TOOLS

The following instructions should appear on your screen //you need to change your security settings
before running the Tool. The instructions differ depending upon what version of Excel you use (Excel
2003,  2007, 2010 or  2013).
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 7

-------
SECURITY SETTINGS FOR EXCEL 2003 USERS

To use the Truck Carrier Tool in Microsoft Excel 2003, you will need to have your security levels set to
"Medium."
                                   Figure 1: Macro Setting Tabs in Excel 2003
Setting Security Levels to Medium  in Excel 2003

    1.  When using Excel 2003, on the menu bar, go to
        Tools -^ Macro -^Security Level.
    2.  When the "Security" window opens, select the
        "Medium" level, and select OK.
                                                                          Irusted Publishers
O Very High. Only macros installed in trusted locations will be allowed
  to run, All other signed and unsigned macros are disabled.

i...:1 High. Only signed macros from trusted sources will be allowed to
  run. Unsigned macros are automatically disabled.

© Medium. You can choose whether or not to run potentially unsafe
  macros,

0 Low (not recommended). You are not protected from potentially
  unsafe macros, Use this setting only if you have virus scanning
  software installed, or you have checked the safety of all documents
  you open.
                                                                                            OK
                                                                                                      Cancel
                                                           Figure 2: Security Level Setting Screen in Excel 2003
                                            Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 8

-------
Running the Tool in Microsoft Excel 2003

    1.  Save the Tool to your computer in a folder on your hard drive.

    2.  Go to that folder and double-click on the file to open the Tool.


    3.  You will see a security-warning box appear (Figure 3). Select the
       the security-warning box.
         Security Warning
         "S:\5martWay\5hipper.xls" contains macros,
                                                       Enable Macros
                                                                      ^button in
         Macros may contain viruses. It is usually safe to disable macros, but if the
         macros are legitimate, you might lose some functionality,.
             Disable Macros
                   Enable Macros
 More Info
                          Figure 3: Screen showing "Enable Macros" button



The Welcome Screen for the Truck Carrier Tool should then appear and you will be ready to begin

working on your tool.
SECURITY SETTINGS FOR EXCEL 2007 USERS

The default settings for Excel 2007 should enable you to run the Tool without any changes.

Running the Tool in Microsoft Excel 2007

       1)     Save the Tool to your computer.
       2)
Open the file, and select the
button that appears after the Security
              Warning just below the menu bar (Figure 4). Detailed instructions are also provided on

              the screen itself.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 9

-------
                                                 jrtTJan2c_clean,xis [Compatibility Mode] - Microsoft Excel
                 *•       jfe I In order to run this application, you must havf
   '  Security Settings for the SmartWay Tools
                                                                                                              E  I   F   I   G.
     In order to run this application, you must have macros enabled.
   3  For Excel 2QQ7 and Excel 2Q1Q Users:  (If you are using Excel 2003. please scroll down.)

     If an "Options.. " button appears in the menu bar above, follow these instructions'
      1. Select the Options button This button appears after the Security Warning in the Excel 2007 menu bar.
      2. Enable content In the Microsoft Office Security Options dialog box. choose "Enable this content" and select OK.

     If the "Options..." button does not appear, use the instructions below. [NOTE: If you do not have a round Office button (as
     shown in the picture below), you are probably using an earlier version of Excel, in which case you need to scroll to the
     instructions for Excel 2003 users.]
      1. Select the Office button. This button appears in the top left comer of the screen in Excel 2007/2010.
      2. Go to Excel Options Select the "Excel Options" button in the bottom right corner of the pull-down menu
      3 Go to the Trust Center. On the Excel Options screen, select on Trust Center in the left navigation bar
      4. Go to the Trust Center Settings. Select on Trust Center Settings in the bottom right portion of the screen.
      5. Change security settings. Choose the setting "Disable all macros with notification" and select OK.
      6. Reopen the file Close the Excel file and then re-open it.
     For Excel 2003 Users:
                                      n color-toH "Hic
                                           Figure 4:  Security Warning Screen


3)         In the Microsoft Office Security Options dialog box (Figure  5), choose  "Enable this
            content" and select  OK.
                           Microsoft Office Security Options
                                    Security Alert - Macro
                                Macros have been disabled. Macros might contain viruses or other security hazards. Do
                                not enable this content unless you trust the source of this file.

                                Warning: It is not possible to determine that this content came from a
                                trustworthy source. You should leave this content disabled unless the
                                content provides critical functionality and you trust its source.
                                More information

                                File Path:  C:fcmartwayChipper.xb

                                O Help protect me from unknown content (recommended)
                                   jp^rzy'z;::^;::;
                           Open the Trust Center
                                       Figure 5: Security Options Dialogue Box
                                                  Truck Carrier Tool Data  Entry and Troubleshooting Guide  |  P. 10

-------
The Welcome Screen for the Truck Carrier Tool should then appear and you will be ready to begin

working on your Tool.
Troubleshooting the Security Settings in Microsoft Excel 2007



If you reach this point and the Tool does NOT open, you may have your security set too high.
To adjust your security settings,  select the
                                         -*
                                            button (in the top left corner of the screen) and then
select the  ^ Exce ' °Ptions button in the bottom right corner of the pull-down menu (Figure 6A).
         J-

           -•
         II







         * —
                                    Click the "Enter

                                    Options Button"
                             Figure 6A: Excel Options Drop-Down Menu
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 11

-------
On the Excel Options screen, select Trust Center in the left navigation bar (Figure 6B):
Excel Options
Popular
Formulas
Proofing
Save
Advanced
Customize
Add -Ins ^f
Trust Center
Resources












@®
djj Change the most popular options in Excel.
Top options for working with Excel
•v
Click the "Trust
Center" button the Ribbo^
J
Color scheme: Blue v
ScreenTip style: Showfeature descriptions in ScreenTips v
Create lists for use in sorts and fill sequences: Edit Custom Lists...
When creating new workbooks

Use this font; Body Font
Font size: |ll v |
Default view for new sheets: Normal View v
Include this many .sheets: J3 	 £j
Personalize your copy of Microsoft Office

tJser name: MHeyward
Choose the languages you want to use with Microsoft Office: Language Settings...

[ OK ] Cancel

                              Figure 6B: Excel Options Drop-Down Menu
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 12

-------
When the Trust Center options display opens, select Trust Center Settings in the bottom right portion of
the screen (Figure 7):
Excel Options PnW

Popular
Formulas
Proofing
Save
Advanced
Customize
Add -Ins
Trust Center
Resources

\^ff Help keep your documents safe and your computer secure and healthy.
Protecting your privacy
Microsoft cares about your privacy. For more information about how Microsoft Office Excel helps to protect your privacy,
please see the privacy statements.
Show the Microsoft Office Excel privacy statement
Microsoft Office Online privacy statement

Security & more | Click the "TrUSt
Learn more about protecting your privacy and securityfrom Micro CGntGT bGttingS
Microsoft Windows Security Center huttOH
Microsoft Trustworthy ConiDutina K.
v vV
Microsoft Office Excel Trust Center ^B
secure. We recommend that you do not change these settings, Irust Center Settings... |

OK Cancel

                                 Figure 7: Trust Center Settings Screen
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 13

-------
Choose the setting "Disable all macros with notification" (Figure 8) and select OK.
Trust Center [?)(x]

Trusted Publishers
Trusted Locations
Add-ins
ActiveX Settings
Macro Settings
Message Bar
External Content
Privacy Options



For macros in documents not in a trusted location: CnOOSG DiS3ol6
O Disable aH macros without notification^
0 Disable all macros with notification "^^^™ a" HiacrOS WJth
O Disable all macros except dicj.it ally signed macros notification "
O Enable all macros (not recommended; potentially dangerl ,
Developer Macro Settings
HH Trust access to the VBA project object model
[ OK 1 Cancel

                                  Figure 8: Macro Settings Screen


Then run the Tool.

If, at this point, the Tool does not open, review the "Software and Hardware Requirements" on page 7.
If you after reviewing this section, you cannot determine how to correct the problem, contact your
SmartWay Partner Account Manager.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 14

-------
SECURITY SETTINGS FOR EXCEL 2010 AND 2013 USERS

The default settings for Excel 2010 and 2013 should enable you to run the tool without any changes. To
run the tool:

        1)      Save the Tool to your computer.

        2)      Open the file. Depending on your Office settings, you may receive an "Enable Editing"
               popup. If you do, simply select the                 button. This will allow you to enter
               data into the Tool. You may only receive this popup the very first time you open the
               Tool.
          Home    Insert    Page Layout    References    Mailings    Review    View    Developer    Add-Ins
     Protected View  This file originated as an e-mail attachment and might be unsafe. Click for more details.    Enable Editing
                                  Figure 9: The Enable Editing Button
        3)      Depending on your Excel macro security settings, you may receive a I

               popup. If you do, simply select the                   button. This will enable macros in
               the tool you just opened.
   Security Warning  Some active content has been disabled. Click for more details.   Enable Content
            Al            » '      fr  Security Settings forthe Tool
                                           A
 1  Security Settings for the Tool
 2  (Pour des instructions en frangais, faites defiler vers la droite.->)
   In f\rr\ar te\ run thie annli^atirvn unii miicf haua marrrtc anahlaH

                                   Figure 10: Security Warning Popup


If, at this point, the Tool does not open, review the "Software and Hardware Requirements" on page 7.


Otherwise, you may have your security set too high. To adjust your security settings, select the MIH
button (in the top left corner of the screen) and then select the  ^ Excel Options  button in the bottom
right corner of the pull-down menu (Figure 11):
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 15

-------
D Recent Documents
*•
~". fipen
u =-
^ -,„« >
CQj fnnt >

^
L






/
/
^3 Excel Options X Exit Excel
          Microsoft Excel

   View   Add-Ins   Nuance PDF

Wrap Tot

Merge & Center •
                                                                               -

                                                            $   % * 11'do '°SI  Conditional  F-I
                                                                           i'ng - 35 Table- Styles- ,              jL Filter- Sei.
                                                              Number            Styles            Cells          Editing
                                                                Select
                                 Figure 11:  Excel 2010/2013 Options Drop-Down Menu
On the Excel Options screen, select Trust Center in the left navigation bar (Figure 12):
                                      -j& Criange tne most popular options in Excel.

                                     Top options for working with Excel


                                     0 Enable Live Preview •
                                     D Show Developertab in the Ribbon ••
                                     0 Always use ClearType
                                     Color scheme: | Blue v |

                                     ScreenTip style:
                                               Show feature descriptions in ScreenTips
                                     When creating new workbooks
                                                     d fill sequences: [Edit Custom Lists... ]
                                      Use this font;
                                      Font size:
                                      Default view for i
                                                                -

                                     Personalize your copy ol Microsoft Office
                                      Choose the languages you wantto use with Microsoft Office: [ Language Settings.
                                                                                          OK      Cam
                                 Figure 12: Excel 2010/2013 Options Drop-Down Menu
When the Trust Center options display opens, select Trust Center Settings in the bottom right portion of
the screen (FigurelS):
                                                 Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 16

-------
Excel Options 1 ? llxl

Popular
Formulas
Proofing
Save
Advanced
Customize
Add -Ins
1 Trust Center
Resources


\^a Help keep your documents safe and your computer secure and healthy.
Protecting your privacy
Microsoft cares about your privacy. For more information about how Microsoft Office Excel helps to protect your privacy,
please see the privacy statements.
Show the Microsoft Office E*cel privacy statement
Microsoft Office Online privacy statement
Customer Experience Improvement Pro a ram
Security & more
Learn more about protecting your privacy and securityfrom Microsoft Office Online.
Microsoft Windows Security Center
Microsoft Trustworthy Computing
Microsoft Office Excel Trust Center
secure, We recommend that you do not change these settings, 1 Irust Center Settings...
/
Select j'

OK Cancel

Figure 13: Trust Center Settings Screen
       Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 17

-------
Choose the setting "Disable all macros with notification" (Figure 14) and select OK.
Trust Center

Trusted Publishers
Trusted Locations
Add-ins
ActiveX Settings
Macro Settings
Message Bar
External Content
Privacy Options


P?K

Macro Settings

!-or macros in documents not in a trusted location; ff~~ ~~\
O Disable ail macros without notification • Select

O Enable all macros (not recommended; potentially dangerous code can run]
Developer Macro Settings
n Trust access to the VESA project object model
| OK | [ Cancel

                                   Figure 14. Macro Settings Screen
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 18

-------
PART 2:
TOOL ORGANIZATION
          Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 19

-------
Basic Organization  of the SmartWay Truck Carrier Tool

The Truck Carrier Tool is the basis of the SmartWay Partnership for Truck Carriers.  Completion and
submission of a Truck Carrier Tool is the first step to becoming a SmartWay Truck Carrier Partner.  Your
Tool submission must be approved  by EPA before you are officially a Partner.

The Truck Carrier Tool is organized around
          •    information screens
          •     forms or worksheets
          •     reports and summaries
Each screen or form opens up within a Microsoft Excel spreadsheet. The screens generally look like the
one shown here.
 La d
   J -^Copy-
     J Format Painter
    Clipboard	i
     Gray = Data
        Entry
ff
X
     Light Green =
     Background
 10
 11

 I
 14
 15
 18
 19
 20
 21
 22
 23
 24

 26
 27
 l< 4 »
 I S»rt If
      T

                          VSmartWay
                                              Report Year
                                                  2014
                                                                                                     Truck
                                                             Introduction
                                   Welcome to the SmartWay Truck Tool. This version of the Truck Tool encompasses ground truck movements.

                            For additional Information such as the Tool user guide, technical manual or other support materials, select the button below:
                                                    Or call the SmartWay Helpline at: (734] 214^767
                                                   Or emal the Helpline at: smartway_tra nsport@epa.gov
                                                          Tool Help and Navigation
                       Throughout the Tool, you will see numerous buttons, aecoming familiar with these buttons will make completing the Tool easier and raster. If a button contains
                             an underlined character, you can aba select that button using the keyboard by typing the {Alt) key along with the underlined character.
                                   Provides instructions for completing eacfi screen
                     you to add_ notes or danficatior
                 becomes yellow if a comment exists)
                                   Checks your data input for missing or invalid
                                   information
                                   Enlarges the text on the
                                                                            Proceed to the next screen
                                                                           Provides additional information about data entry
                                                                           fields
                                                                            LJnk to video instruction regarding Tool data entry
                                   Sends an image of the screen to your default
                                   printer

                      FILING FORMS WITH THE FEDERAL GOVERNMENT AND ESTIMATED REPORTING BURDEN: Respondents are not required to file or reply to any Federal collection of information unless it has a
                      valid OMB control number. Public reporting burden for this collection of information is estimated to average 5.82 hours per response for fnital registration, 2.66 hours for each annual update,
                      These estimates indude the time for reviewing instructions, searching existing data sources, gathering the data needed, and completing and reviewing the collection of information. Send
                      comments regarding this burden estimate or any other aspect of this collection of information including suggestions for reducing this burden to; SmartWay Transport Partnership, MOO
                      Traverwood, Ann Arbor, MI 46105, or the Office of Information and Regulatory Affairs, Office of Management and Budget, Washington D.C.
                                                                                                                      I = I a 1-sM
                                                                                                                      a Q =j @ ES
                                                                                                                             >B
                                                                                                                               I
                 Figure 15:  Screenshot of the Orientation of the Truck Carrier Tool in Microsoft Excel
                                                   Truck Carrier Tool Data  Entry and Troubleshooting Guide |  P. 20

-------
The gray screen is where you enter data. The light green background is the Excel workbook; this area
remains in the background is NOT used for data entry.  For the purposes of your Tool submission,
disregard the background workbook.

The name of each form appears at the top left-hand corner of the screen, in white text on the blue
window bar, and the reporting year for the Tool is prominently displayed at the top of the screen.
 SmartWay Introduction-^^
             Title of Screen/Form
         -SmartWay
Report Ye
    2014
                                                                                    Truck
Reporting Year
United States Version; 2,0.14
    Released on: 1/7/2015
                             Figure 16: Screenshot of Title of Screen/Form
Each screen contains text instructions or information about the program. Where applicable, the screen
will also include buttons linking to the SmartWay website or other sections of the Tool (e.g., the various
data entry screens); these buttons will be shown in green and clearly labeled, as seen in Figure 17.
                               Go To Truck Tool Page of the SmartWay Website
                            Figure 17: Screenshot of Button Link in the Tool
The screens also contain navigation buttons to direct you through the Tool.
                     Figure 18: Screenshot of Selected Navigation Buttons in the Tool
When new concept/topic is introduced on a screen, a small question mark ([?]) appears next to it. When
you select the question mark, you will find additional definitions of terms or instructions to help you
complete the screen properly. You may also find additional, detailed instructional material on how to
successfully navigate and complete the different data entry screens within the Tool by selecting the
  Screen
   Demo
            buttons at the bottom of selected screens.
Page numbers have also been added to the bottom right of all screens to facilitate navigation through the
Tool and communication with your Partner Account Manager regarding any questions.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 21

-------
Reviewing the Introductory Screens
Before you reach your data entry section of the Tool, you will move through six introductory pages that
allow you to review the basics of participation in SmartWay for truck carriers. These screens are:

          •  The "SmartWay Introduction" Screen
          •  The "SmartWay Partnership Annual Agreement" Screen
          •  The "SmartWay Tool Selection" Screen
          •  The "Required Information" Screen
          •  The "SmartWay Partner Schedule" Screen
          •  The "US/Canada Operations" Screen

The features of these screens are described below.
                                   Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 22

-------
SMARTWAY INTRODUCTION SCREEN

The SmartWay Introduction screen is the first window that appears when the Tool is opened (Figure 19).
This screen contains:

    •   a button linking to the SmartWay website where you can view and download additional
         information about the program, the Tool, and the technical basis for the calculations in the Tool

    •   descriptions of Tool Help and  Navigation buttons found throughout the Tool
 SmartWay Introduction
           SmartWay8
Report Year
    2014
OMB 2060-O663
Expiration Date O7/31/2017
(Revised 2O14)
             Truck
United States Version: 2.O.14
     Released on: 1/7/2015
                                                     Introduction

                     Welcome to the SmartWay Truck Tool. This version of the Truck Tool encompasses ground truck movements.


           For additional Information such as the Tool user guide, technical manual or other support materials, select the button below:
                                          Go To Trade Tool Page of the SmartWay Website
                                          Or call the SmartWay Helpline at:  (734) 214^767
                                        Or email the Helpline at: smartway_transport®epa.gov
                                                 Tool Help and Navigation

    Throughout the Tool, you will see numerous buttons.  Becoming familiar with these buttons will make completing the Tool easier and faster. If a button contains
            an underlined character, you can also select that button using the keyboard by typing the {Alt} key along with the underlined character.
                    Provides instructions for completing each screen
                    Allows you to add notes or clarifications (button
                    becomes yellow if a comment exists)
                    Checks your data input for missing or invalid
                    information
                    Enlarges the text on the screen
                    Sends an image of the screen to your default
                    printer
                                                              Screen
                                                              Demo
                                                                         Proceed to the next screen
                                     Return to the previous screen
                                     Provides additional information about data entry
                                     fields
                                     Link to video instruction regarding Tool data entry
                                     and use
   FILING FORME WITH THE FEDERAL GOVERNMENT AND ESTIMATED REPORTING BURDEN: Respondents are not required to file or reply to any Federal collection of information unless it has a
   valid OMB control number. Public reporting burden for this collection of information is estimated to average 5.32 hours per response for initial registration, 2.66 hours for each annual update.
   These estimates indude the time for reviewing instructions, searching existing data sources, gathering the data needed, and completing and reviewing the collection of information. Send
   comments regarding this burden estimate or any other aspect of this collection of information including suggestions for reducing this burden to: SmarW/ay Transport Partnership, 2000
   Traverwood, Ann Arbor, MI 48105, or the Office of Information and Regulatory Affairs, Office of Management and Budget, Washington D.C.
                                                                                                              Page T-l
                                      Figure 19: SmartWay Introduction Screen


Of special note is the small question mark ([?]), which appears next to new concepts when they are

introduced throughout the Tool.  Clicking the question mark will reveal additional definitions of terms or

instructions to help you complete the screen properly.
After selecting the   ^^^^^™ button on the SmartWay Introduction screen, the SmartWay
Partnership Annual Agreement will appear.

                                               Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 23

-------
SMARTWAY PARTNERSHIP ANNUAL AGREEMENT SCREEN
 SmartWay Partnership Annual Agreement
           SmartWay8
Report Year
     2014
             Truck
United States Version: 2.0.14
     Released on: 1/7/2O15
   Partnership Annual Agreement for Carriers

    With this annual agreement, your company joins EPA's SmartWay Transport Partnership and commits to:
  1. Measure and report to EPA on an annual basis the environmental performance of your fleet(s) using EPA's SmartWay Tool. (Existing fleets must report the 12
    months of data for the prior year ending December 31. Newly formed companies require a minimum of 3 months of operational data.)
  2. Have performance results and Tool submittal status posted on the EPA SmartWay website/database.
  3. Agree to submit supporting documentation to EPA for any data used to complete this Tool and agree to EPA audit of this data upon request by EPA.


    In return, EPA commits to:
  1. Promote company participation in the Partnership by posting Partner names on the EPA SmartWay Website and in related educational,
    promotional, and media materials. EPA will obtain express written consent from the Partner before using the Partner's name, other
    than in  the context of increasing public awareness of its participation as described here.
  2. Provide companies with industry-wide performance benchmark data as this data becomes available to EPA.
  3. Assist Partners in achieving emission and fuel usage reduction goals (subject to Federal Government Appropriations).


    General Terms
  1. If the Partner or EPA defaults upon this agreement at any point, the agreement shall be considered null and void.
  2. Either party can terminate the agreement at any time without prior notification or penalties or any further obligation.
  3. EPA agrees not to comment publicly regarding the withdrawal of specific Partners.
  4. EPA reserves the right to suspend or revoke Partner status for any Partner that fails to accomplish the specific actions to which it
    committed in the SmartWav Transport Partnership Agreement and subsequent annual agreements.
  5. The Partner agrees that it will not claim or imply that its participation in the SmartWay Transport Partnership constitutes EPA approval
    or endorsement of anything other than the Partner's commitment to the program. The Partner will not make statements or imply
    that EPA endorses the purchase or sale of the Partner's products and services or the views of the Partner.
  6. Submittal of this SmartWay Tool annually constitutes agreement to all terms in this Partnership Agreement.
    No separate agreement need be submitted.
  By checking the box below, I declare that the information submitted via this Tool PS, to the best of my knowledge, accurate. I understand that any
  person who, in the course of negotiating or performing under this Agreement, makes, presents or submits a false or misleading statement to the
  government, or any person who makes a material omission in the course of negotiating or performing under this Agreement, may be subject to
  liability under all applicable civil and criminal statutes including 18 U.S.C. 1001 (criminal liability for false statements), 31 U.S.C. 38O1 - 3812 (civil
  liability for false statements) and 31 U.S.C. 3729-33 (The False Claims Act).                              	
                                            [I understand and agree to the terms of this agreement.!
                                                        Click to accept
                                                         Agreement
                                                                                                                 PageT-2
                                 Figure 20: SmartWay Partnership Annual Agreement


Submitting a Truck Carrier Tool to  EPA constitutes agreement to all terms of the Partnership Agreement,

which is required for joining SmartWay and remaining a partner in good standing

All participants in SmartWay are strongly advised to read the agreement thoroughly.

This screen presents the agreement details; in addition, a text version of the agreement is included in the

Appendix of this guide and in the Quick Start Guide for your convenience.

If you have been assigned the responsibility for completing your tool submission but are not in the
position to approve the agreement, acquire any necessary approvals before trying to input data into the

Tool.

To move to next screen, you must check the box indicating that your company accepts the terms of the

agreement.
                                                Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 24

-------
   SMARTWAY TOOL SELECTION SCREEN

   SmartWay offers several tools tailored for different business models and fleets. Most truck carriers will
   use the Truck Carrier Tool; however, it is advisable to review this screen in the Truck Carrier Tool to make
   sure it is the best option for your operations.

   This screen provides basic information on three SmartWay tools (Truck, Logistics, and Multi-modal)
   appropriate for different types of trucking operations. Your choice of tool will depend primarily on your
   transport modes and the amount of business you contract to other companies.

   Follow the flow chart in Figure 21 to determine which tool is most appropriate for your fleet(s).
   Select the
             Click Here (or More
                Information
I button for further details.
SmartWay Tool Selection
        -SmartWay9
 Report Year
     2014
           Truck
United States Version: 2.0.14
    Released on: 1/7/2015
                                Is this the right SmartWay tool for me?
                        You operate your own managed fleet
                        (owned or leased) with less than 5% of
                        your freight contracted with outside
                        companies.
                                       NO
                        You contract out more than 5% of your
                        freight {i.e., you are a 3PL, broker, freight
                        forwarder or non-asset based carrier.
                                       NO
                        You operate your own managed fleet and:
                        Move 5% or more of your freight with a
                        third-party provider, or move more than
                        10% of your freight via rail, barge, and/or
                        air.
                                       NO
                                Select diis Button f
                                   elnf
                                                                                             PageT-3
                        Figure 21: Determining Which Tool is Appropriate for Your Fleets
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 25

-------
REQUIRED INFORMATION SCREEN

This next screen summarizes the information needed to complete the Truck Carrier Tool.
You may select
                       PRINT
                      SCREEN
Ito create a hard copy to reference as you complete the rest of the Tool.
 Smart Way Truck: Required Informatio
           SmartWay*
 Report Year
      2014
             Truck
United States Version: 2.0.14
     Released on: 1/7/2O15
        Following is a brief description of the information you will need to complete the SmartWay Truck Tool. For further details,
        consult the SmartWay Truck Tool User Guide.
         Partner Information
          Company Information:
          • US / Canada Operations Information
          • Company Name, Address, City, State, ZIP, Country, Main Phone, Website
          Working, Executive, and Other Contact Information:
          • Name, Title
          • Address, City, State, ZIP, Country
          • Phone, E-mail
          • SmartWay ID Number (for returning Partners)
         Operator and fleet Characterization Information (Fleet-Level Inputs)
          • Partner and Fleet Names, Contacts
          • Standard Carrier Alpha Codes (SCACs), Motor Carrier numbers, and/or DOT Numbers
          • Fleet Type (private, dedicated, and for-hire)
          • Percent Operational Control (greater than or less than 95%)
          • Fleet-Level Operational Category (by percent of operation): Truckload, Less-than-Truckload, Dray, Package Delivery, Expedited
          • Body Type (by percent of equipment) - Dry Van, Reefer, Flatbed, Tanker, Intermodal Chassis, Heavy/Bulk, Auto Carrier, Moving,
           Utility, Specialized Hauler
         Fleet-Level Operations Profile
          • Percent long-haul and percent short-haul
          • Fuel usage by truck cbss for each fuel type used (diesel/biodiesel, gasoline/ethanol, LPG, LNG, CNG, hybrid and battery electric)
          • Fuel usage by reefer units (diesel, gasoline, CNG)
          • Fraction of hauls cubing out
          • Commodity descriptions
          • Optional Port Dray Program Details (APU and SmartWay Tire use)
          • Number of trucks by engine model year and truck class (2b - 8b)
          • Total, Revenue, and Empty miles driven (by class)
          • Total conventional and biofuel use (by class)
          • Average payload, average  capacity volume, and percent capacity utilization (by class)
          • Percent highway/rural operation, urban speed distributions (by ctass)
          • Average idle hours per truck (by class)
          • Use of particulate matter control equipment by truck class and engine model year
          • Details regarding sources of data
                                                                                                             PageT-5
                                    Figure 22: Summary of Required Information


While this screen serves as a reminder of your data input needs, refer to the Truck Carrier Tool Quick
Start Guide for more tips and worksheets to help you gather your data for efficient and accurate Tool
completion.


SMARTWAY PARTNER SCHEDULE SCREEN

The SmartWay Partner Schedule screen shows the release dates and due dates for the various Partner
tools for the  2015 calendar year (Figure 23).  The screen also shows how the outputs from the various
carrier tools serve as inputs to other "downstream" tools such as Multi-modal, Logistics, and Shipper.
                                              Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 26

-------
 bmartway Partner Schedule
SmartWay*
                             ""SI"
                     — ,=—:
                        SmartWay Partner Schedule and Data Flow Diagram
                     Tool release and due dates for 2015 calendar year using 2014 data
Truck Tool
Available January 7
Group 1
Due March 4
Group 2
Due April 8
Group 3
Due May 6
                  Rail Tool
              Available February 3
                 Due May 6
                 Barge Tool
              Available February 3
                 Due May 6
                  Air Tool
               Available April 2
                 Due May 6
  Logistics Tool
  Available July 8

Accepts Truck, Rail, Barge,
  Air, and MM Data

 Due September 16
                                                                    Shipper Tool
                                                                  Available October 3

                                                                  Accepts Truck, Rail, Barge,
                                                                  Air, MM, and Logistics Data

                                                                   Due December 3
                                                                                          PageT-6
                          Figure 23: Screenshot of the Shipper Schedule Screen



US/CANADIAN OPERATIONS SCREEN

The last screen asks for information about any operations you have in both the US and Canada.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 27

-------
 SmartWay US/Canadian Operations
          SmartWay*
Report Year
    2014
            Truck
United States Version: 2.O.14
    Released on: 1/7/2015
   The SmartWay Transport Partnership is now being administered in the United States and Canada. The Partnership operates the same in both
   countries, allowing partners to submit one tool for all of their US-Canada operations. Partners will be recognized by both national programs and
   will be listed on both the US and Canadian SmartWay websites. The US and Canadian SmartWay tools produce the same output results, however
   the Canadian tools use metric rather than English measurements and are available in French as well as English.
   Partners should submit to the country where their headquarters is geographically located.

   If unsure about which country to which you should submit, please contact either national SmartWay Program for assistance.
                          United States:      http://www.epa.gov/smartwav/
                          Canada:           http://www.sinartwav.nrcan.ac.c
   To allow the United States and Canada to determine country-specific impacts for internal tracking purposes, please answer the following question
   about your freight operation. This answer is not used in any calculations regarding your score so therefore can be approximate.

   Please indicate the approximate percentage of your overall operations in the United States and Canada.  ? |
                            55 % Operation in the United States

                            45 % Operation in Canada
                                                                                                    PageT-7
                         Figure 24: Screenshot of the US/Canadian Operations Screen
The SmartWay Transport Partnership is now being administered in both the United States and Canada.
The Partnership operates the same way in both countries; however, data collection for Canadian Partners
is collected in metric units and there are French translations of all Tool screens and guidance.

If your company operates in  both the United States and Canada, note that you should ONLY SUBMIT ONE
TOOL. You may select either the US Tool or the Canadian Tool, and your partnership participation will be
recognized in both countries.

To allow the  United States and Canada to accurately determine the impacts of freight operations in each
country, you  are asked to complete a single screen (Figure 24) indicating the percent operation in the
U.S. and Canada.  Acceptable metrics include miles, fuel consumption, or any reasonable quantitative
means of allotting the approximate percentage of operations in the two countries.
Once you have navigated through the six introductory screens, you will be taken to the SmartWay Truck
Carrier Tool Home screen.
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 28

-------
Basic Overview of How to Complete the Tool
All data entry screens are reached by starting with the Home screen.

Figure 25 displays the structure of the Home screen.
 SmartWay Truck; Home
           SmartWay
Report Year
    2014
           Truck
United States Version: 2.0.14
    Released on: 1/7/2015
    Please complete the following steps. Check boxes on the left indicate successful completion of each step. For more
    information, select the 'Help' button.
       1. Enter Partner Name  (ExactV as it should appear on the SmartWay website):
                   Enter Contact Information
                    Characterize your Fleets
       4. Select Fleet for Data Entry  (Double-click the fleet name or select and hit Enter):
               Review Year-to-Year Comparison
             Partner ProHe / Logo Info / Suggestions
                   View Your Data Reports
          *After selecting this option, be sure to carefully read aff directions before proceeding.
                                                                                   Screen
                                                                                   Demo
                                                                                                  PageT-8
                             Figure 25: Main Tool Navigation or "Home" Screen
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 29

-------
SECTIONS OF THE TOOL

The Truck Carrier Tool Home screen contains eight sections. Each section links to additional screens or
worksheets within the Tool which are described below:

    Section 1:  Enter Partner Name (data field): Specify your company's Partner Name, exactly as you
              want it to appear on the SmartWay website.
    Section 2:  Enter Contact Information (button): This button takes you to a screen that asks for
              general company contact information, a working SmartWay contact, and an executive-
              level contact. Additional contacts may also be included.
    Section 3:  Characterize your Fleets (button): This button takes you to a screen that asks you to
              define all the fleets your company operates and provide information describing their
              operation. Once these parameters are defined, the software will enable you to generate
              blank data entry forms for each fleet.
    Section 4:  Select Field for Data Entry (list): This section allows you to select the fleet for which you
              will be entering performance and fleet composition information necessary to  calculate
              fleet efficiency metrics for your fleet; a list will indicate the fleet(s) defined and
              characterized in section 3.
    Section 5:  (Optional) Review Year-to-Year Comparison of Fleets (button): This optional step allows
              you to compare previous year data entries to one another or to the data entered for the
              current year. The comparison reports provide a useful tool for performing quality control
              of current data, as well as  a method for evaluating trends in operation changes, activity
              levels and fleet performance over time.
    Section 6:  (Optional) Partner Profile/Logo Info/Suggestions (button): Here you can provide
              information about your company's environmental accomplishments, learn about
              SmartWay Logo terms and requirements, and give EPA feedback about the SmartWay
              program.
    Section 7:   (Optional) View Your Data Reports (button): Here you can view final summaries of your
              data including all data inputs, fleet performance summaries, an "out of range" report
              (summarizing inputs that are higher or lower than expected values) and a summary of
              comments you have entered.
    Section 8:  Generate File to Send to EPA (button): This button creates  a version of the Tool (in XML
              format) for you to send as an attachment in an e-mail to your Partner Account Manager
              (PAM). Selecting the OK button on this screen does not automatically submit the file to
              EPA; you still need to submit it to EPA by attaching it in an e-mail.
ENTERING YOUR DATA

With the exception of Section 1, clicking on the buttons or list items in Sections 2 through 8 will take you
to additional screens and worksheets that comprise the data entry segments of the Tool.

The first four sections of the home screen are mandatory and MUST be completed in order. These
sections comprise all the data collection steps needed to complete your SmartWay Truck Carrier Tool.
After they are completed, you can review your output and/or submit your Tool to EPA.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 30

-------
Once you complete each mandatory step, a

VALIDATING YOUR DATA
      will appear on the left of the screen.
The Truck Carrier Tool includes range checks and other validation rules to help identify potential data
entry errors and/or unusual data values. To identify potential data problems and ensure a high quality
data submission, select the
                           VALIDATE
                            SCREEN
button before moving on to the next screen.
The Tool will identify any potential data problems on that screen and prompt you to modify the entry or
provide a text explanation for legitimate anomalies.

SAVING YOUR DATA
You can save the data you have entered at any time by selecting the  ^*^^^^  button that appears
at the bottom of all screens (including the Home screen).  EPA recommends saving your data frequently if
you are entering information for large numbers of fleets and/or vehicle classes.

REVIEWING YOUR DATA
Each screen within the Tool has a
                                  PRINT
                                 SCREEN
     button. To generate a hard copy of screen text or your
data inputs, select this button. The screen will be printed on your default printer.  Alternately, you can
return to the Home screen, select the
                                             i, identify
the report of interest using the Reports Menu, and print them out for review. The data reports provided
                                                          View Vour Data Reports
by the Truck Carrier Tool are discussed further in the
section of this guide.

PARTNER PROFILE/LOGO INFO/SUGGESTIONS

The Truck Carrier Tool includes an optional section that allows you to provide EPA with additional
information regarding your company's environmental stewardship, potential use of the SmartWay Logo,
and general feedback regarding the SmartWay program.

SUBMITTING DATA TO SMARTWAY

Detailed instructions on properly submitting your data to EPA is included in this guide on page 103.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 31

-------
PART 3:
SECTION-BY-SECTION
DATA ENTRY GUIDANCE
         Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 32

-------
Preparing for Data Entry
To participate in SmartWay, truck carriers need to gather the following essential information to complete
the Truck Carrier Tool:

   •   The official company name EXACTLY as you would  like it presented on the EPA website
   •   Company contact information
   •   Contact details for your Working Contact
   •   Contact details for an Executive Contact (cannot be the same as the Working Contact)
   •   Split between US/Canada operations
   •   Quarterly IFTA statements1 (for activity data) for the reporting calendar year
   •   Fleet details for all fleets you control:
           o   SCACs,  MCNs, and/or DOT number information
           o  Total inventory of vehicles in your fleet(s),  sorted by vehicle class and engine model year,
              body type, and operational category for the reporting calendar year
           o  Total miles, revenue miles and empty miles
           o  Total diesel, biodiesel and other fuel type use by class
           o  Reefer fuel use by class (if applicable)
           o  Average payload, average capacity volume, and percent capacity utilization by class
           o  Average idle hours per truck
           o  Use of particulate matter control equipment by truck class and engine model year (if
              applicable)
   •   Data sources for all data to be entered
   •   SmartWay ID number (if this is not your first Tool submission)

This data must be provided for all of your company's fleets. This data  reflects the amount of freight
carried by each carrier, the distance that freight is carried, and the fuel consumed to carry the freight.

The next four sections of this guide explain how to enter your data on each of the required and optional
screens. You must complete these first four sections of the Home screen in order.
1 If applicable - for Class 7, 8a and 8b trucks only.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 33

-------
Section 1  Data Entry: Enter Partner Name
SECTION 1 OVERVIEW

Section 1 of the Truck Carrier Tool asks you to "Enter Partner Name."
SmartWay Trucic Home
         SmartWay
      1. Enter Partner Name  (Exactly as it sh
       [ABC Trucking, Inc.
   Please complete the following steps. Check boxes on the left indicate successful completion <
   information, select the 'Help' button.
Enter your Partner Name
 precisely as you want it
  on the EPA website
               Figure 26: Field for Entry of Partner Name on Truck Carrier Tool Home Screen
 EPA publishes your company's official name on the EPA SmartWay website and in the SmartWay Carrier
Data File. This is how your customers will know that you are a SmartWay Partner, and how SmartWay
Shippers will be able to identify your fleets for their reporting purposes. The name that EPA lists is known
as your "Partner Name" and is defined within Section 1 of the Truck Carrier Tool.

Therefore, it is essential that you specify your company's Partner Name EXACTLY as you want it to appear
on the SmartWay website.

Pay special attention to proper capitalization, abbreviations, and punctuation, and remember that EPA
will use whatever you enter EXACTLY as reported.
Steps for Entering Partner Name

    1.  Type your Partner Name EXACTLY as you would like it to appear on the SmartWay website in the
       field as indicated.
    2.  Proceed to Section 2 to enter contact information.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 34

-------
Section 2 Data Entry:  Enter Company and Contact Information

SECTION 2 OVERVIEW

The Contact Information section is where you identify all points of contact between EPA and your
company that are related to your participation in SmartWay.

Section 2 asks you to click a green button labeled "Enter Contact Information."

   Please complete the following steps. Check boxes on the left indicate successful completion

7



1. Enter Partner Name (Exactly as it should appear on the Smart Way website):
JABC Trucking, Inc.
Enter Contact Information
r >,
Select "Enter
Contact

V >
                    Figure 27: Select Contact Information Button on "Home" Screen
You will then be taken to the Contact Information screens.  These screens will ask you to, provide the
following information:

1.      Company Information
2.      Working Contact information
3.      Executive Contact (Vice President or higher)
4.      Other Contacts
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 35

-------
                                        SmartWay: Contact Information

                                  Working Contact          Executive Contact
                                                         Other Contacts
         Addressl*

         Address!

         City*

         Main Phone*

         Web Site
                      545 Ocean Way
Suite 203
Austin
 State*
                                        ZIP*  78731
                                                        Country
                                                             .* USA
512-555-5555
Toll Free f
www.MMl.com
         There must be at least two different people that SmartWay can contact. The Working Contact is the person assigned to
         work directly with EPA regarding timely and accurate Tool submission, and maintaining direct communication with
         SmartWay.

         The Executive Contact is the company executive who is responsible for agreeing to the requirements in the SmartWay
         Partnership Annual Agreement and ensuring timely submission of the Tool to SmartWay. The Executive Contact should be
         a Vice President or higher-level representative for the company.

          Working Contact:  _^J

          Name         K zJ First* |Glenn

          Title*
                                MI
              r
                                           Last*
                                                Johnson
 |VP Operations
           Executive Contact: |_Ll

           Name         |Mr- _LJ   First*

           Titie*

          * - Required
                                 HI
               r
                                           Last*
jshephard
 | CEO
                            Figure 28: Entering Company and Contact Information
            Each field marked with an asterisk must be filled out. You will not be able to submit
                              the Tool to SmartWay without this information.
Steps for Entering Contact Information:

Under the Partner Information tab:

    1.   Enter the Company data.


    2.   Enter the Working Contact name and title.


        The Working Contact is the individual designated by the Executive Contact to directly interface
        with SmartWay regarding specific tasks involved in the timely submission of the Tool. The
        Working Contact is responsible for coordinating the assembly of information to complete/update
        fleet data; completing and updating the Tool itself; maintaining direct communication with
        SmartWay; and keeping interested parties within the company apprised of relevant
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 36

-------
       developments with SmartWay. (NOTE: To ensure that e-mails from SmartWay/EPA are not
       blocked, new contacts may need to add SmartWay/EPAto their preferred list of trusted sources.)

    3.  Enter the Executive Contact name and title

       The Executive Contact is the company executive who is responsible for agreeing to the
       requirements in the SmartWay Partnership Annual Agreement, overseeing the Working Contact
       (as appropriate), and ensuring the timely submission of the Tool to SmartWay. The Executive
       Contact also represents the company at awards/recognition events. This person should be a Vice
       President or higher level representative for the company.

Under the Working Contact tab:

                                      SmartWay: Contact Information
                                      Contact        Executive Contact       Other Contacts
              Please enter information about your Working Contact here.
Name
Glenn Johnson
• Use Partner Address •
Addressl*
Address2
City*
Phone*
Email*
645 Ocean Way

Suite 203
Austin State* |T* _^J
512^44^444 Ext) 212 Cell 512-7
glenn.johnson@mml.com
ZIP* 78731 County* JUSA
77-7777 Fax 1 512-888-8888
.
               Confirm Email*  |glenn.johnson@mml.com
               - Required
                            Figure 29. Working Contact Information Screen
       1. Enter the Working Contact information. If the Working Contact shares the same address as
                                            Use Partner Address
       the company, you may select the •   ^g^mjjj|f||g^g^    I button to auto-populate the
       address section of this record.  Enter the email address twice to confirm its accuracy. When
       confirmed a        will appear to the right.

Under the Executive Contact tab:
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 37

-------
              Please enter information about your Executive Contact here.
                Name


                Addressl*
                Address2
                City*
                Phone*
                Email*
|jack Shephard
     Use Partner Address
645 Ocean Way-
 Suite 203
Austin
 512-789-6789
State* |TX  jj        ZIP* J78731       Country* |USA
           CenP
jjack.shephard@mml.com
                Confirm Email*  |jack.shephard@mml.com
                 Required
                                                          Fax
                               Figure 30. Executive Contact Information Screen
        1.   Enter the Executive Contact information.  If the Working Contact shares the same address as

            the address section of this record.
Under the Other Contacts tab:
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 38

-------
          Partner Information
        artWay: Contact Information
Working Contact         Executive Contact
         Please enter information about your additional contacts here.

            Other Contacts:
                  Add Hew Contact
                                       Edit Selected Contact
                                                              Delete Selected Contact
                          Figure 31. Other Contact Information Screen
1.  Enter Other Contacts (if applicable) by selecting the
2.  Enter the first Other Contact then click OK when done.
                                                         Add New Contact
                                              I button.
       Note: You must supply at least two unique contacts on the contact screen to ensure
              EPA has access to at least two people for Tool submission follow-up.

       NOTE: In some cases, companies with multiple fleets will gather information from
       different sources within the company. You may find it useful to have this additional
                          contact information stored within the Tool.
    You can add more contacts to the Other Contacts box by repeating this process. If you wish to
    edit an existing contact's information, highlight the name you wish to edit and then select the
       Edit Selected Contact
                              button. You can remove an existing contact by highlighting the
    contact and then selecting
                                 Delete Selected Contact
                                   Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 39

-------
    To make sure you have filled out all required contact information, select
                                                                       VALIDATE
                                                                        SCREEN
                                                   . at the
    bottom of the screen on the Partner Information tab. If any information is missing or invalid, a
    dialogue box will appear informing you what additional information is required.
4.   Next select the
. button to return to the Home screen and go to Step 3.
                                  Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 40

-------
Section 3 Data Entry:  Characterize your Fleets
The third section of the Tool is the "Characterize your Fleets" section. This is the section where you will
define the various components of your fleets.

The Truck Carrier Tool allows you to assess your operations by defining multiple fleets. If a customer has
the ability to hire a specific fleet by name or type, you should add that fleet to the list of fleets that you
will characterize in the Truck Carrier Tool. Do not include internal company fleet definitions or
designations—only include separate fleets as they would be identified and hired by your customers.

There are five screens in the Fleet Characterization section of the Tool:

           •  Identify Fleets
           •  Fleet Details
           •  Operation Categories
           •  Body Types
           •  SmartWay Category

Each screen, and the steps required to complete it,  is described below.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 41

-------
"IDENTIFY FLEETS" SCREEN OVERVIEW
The Identify Fleets screen is shown below:
 SmartWay: Fleet Characterization - Truck
                   Fleet Details
                                   Operation
  List all your fleets that your customers can specifically hire. DO NOT list internal fleet designations that are invisible to your customers. Example: ABC
  Trucking Inc. has two divisions; ABC Truckload and ABC Interniodal. If shippers can hire "ABC Trucktoad division" separately from "ABC Intemiodal
  Division," then list them as separate fleets; otherwise simply list "ABC Trucking, Inc."

  Enter the Fleet Name Identifier. Fleets should be named EXACTLY as you want them to appear on the SmartWay website. The Fleet Name as it will be
  displayed on the SmartWay website will be listed to the right. Example: ABC Trucking Inc: ABC Truckload Division.

  To add fleets, select the "Add Another Fleet" button at the bottom of the screen. You may delete a fleet by selecting the Delete box to the left of the fleet
  name and then selecting the "Delete Checked Rows" button at the bottom of the screen. When you have added all your fleets, select the Fleet Details tab
  at the top of the screen or select the NEXT button to proceed.
   Delete
          Fleet (Partner Ma me)
                                       Fleet Identifier
                                                                    Fleet Name
                                                                    (exactly as it will appear on the SmartWay Website)
    F  H~ I ABC Trucking, Inc.
IABC Trucking, Inc.
                                   Delete Checked Rows
                                                                                                  Screen
                                                                                                  Demo
                                                                                                    PageT-13
                                       Figure 32: Identify Fleets Screen

You will be asked to establish a name for each fleet that a customer can hire. The Truck Carrier Tool
combines your Partner Name (as defined on the Home screen in Section 1) with a Fleet Identifier that
you provide on the Identify Fleets screen to establish your final Fleet Name.


Each of your Fleet Names will begin with the name of your company.  This fleet "prefix" will be

whatever you enter in the Fleet (Partner Name) field on the Identify Fleets screen. By default, this field is

automatically populated with the first 50 characters of the Partner Name that was entered on the Home

screen; however, you may change the prefix here by simply typing your desired prefix into the field below

the heading Fleet (Partner Name). You should specify the text so that it appears EXACTLY as it you want

it to show within each fleet  name. Pay special attention to proper capitalization, abbreviations,

punctuation, and other terms (such as Inc. or Ltd.) and adjust as necessary.


Remember that this prefix will be automatically inserted at the start of each of your Fleet Names in the

SmartWay Carrier Data File. Whatever you enter for Fleet prefix for the first fleet will automatically be
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 42

-------
used for any additional fleets you add.  Similarly, any edits you make to the Fleet prefix for the first fleet
will automatically be reflected on each subsequent fleet.

To define each fleet name, you will be required to enter the Fleet Identifier.  This should be an
identifier recognizable to your customers.  Again, make sure to specify each Fleet Identifier name
exactly as you want it displayed in the SmartWay Carrier Data File, including proper capitalization, any
abbreviations, and  punctuation.  Remember that it will automatically be combined with the Fleet prefix
(Partner Name) field.

Once you have added your Fleet Identifiers, the complete fleet name (with Partner Name and Fleet
Identifier combined) will appear  in the grayed-out box on the far right of the Identify Fleets screen.
  Delete
         Fleet (Partner Name) I
                                   Fleet Identifier
                                              Final Fleet Name
                                            Fleet Name
                                            (exactly as it will appear on the SmartWay Website)
ABC Trucking, Inc.
ABC Trucking, Inc.
1 Dry Van Fleet
|Dray Fleet
ABC Trucking, Inc.: Dry Van Fleet
ABC Trucking, Inc.: Dray Fleet
                           Figure 33: Example of final Fleet Name formating

NOTE: If you have only one fleet, you may leave the Fleet Identifier field blank, in which case your fleet
name will simply be presented as the "Partner Name" you entered.
If you have more than one fleet, you will need to add the fleets separately. To enter another fleet, select
Adding Comments assists SmartWay Tool reviewers in approving your Tool as quickly as possible. Your
comments help reviewers understand your business operations.  Any details that you can provide related
to your operations will speed up approval time.
The
        ADD
      COMMENTS
I button located at the bottom of the screen allows you to enter notes about the data
collection process, your assumptions and methods, or other information. These details could prove useful
for your reviewer when you or someone else completes the Tool next year.
        ADD
      COMMENTS
The
particular screen.
 button will be highlighted in yellow on your screen if comments have been added for a
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 43

-------
The button will then read
                          VIEW/EDIT
                          COMMENTS
                             to indicate to your reviewer that there are comments to be read.
If, at a point later in the data entry process, you realize that you need to add a new fleet or delete an
existing fleet, you can return to the Identify Fleets screen.

To add a new fleet, follow all of the instructions on the screen regarding defining your fleets, including
                CREATE
               FLEET(S)
selecting the  mMOmiSl^ button at the end of the process. When you select this button, the system
will create blank data entry forms only for the new fleet(s) you have added; the existing fleets will not be
affected.
If you need to delete an existing fleet, simply check the box next to the fleet and then select the
        Delete Checked Rows
                                I button.  And, as on the other tabs, there is a
                                                                               button
as well as an
                ADD
              COMMENTS
                  button. Selecting
                                   _ will take you back to the Home screen
STEPS FOR COMPLETING "IDENTIFY FLEETS" SCREEN:
i.


2.

3.
4.
On the Home screen, select the
Characterization screens.
                                      Characterize your fleets
                                             I button to display the Fleet
Confirm that the Fleet (Partner Name) that appears automatically is correct and appropriate for
your fleets. If not, make changes in the field under the heading "Fleet (Partner Name)."

Enter the "Fleet Identifier" for your first (or only) fleet.

Enter additional fleets as needed:
       a.

       b.



       c.
       To enter another fleet, select the
                                               Add Another Fleet
                                                              ! button.
       To delete a fleet, select the box next to the row you wish to delete, and then select the

                            button.
Delete Checked Rows
       Once you have confirmed or modified the Partner Name and specified the Fleet
       Identifiers, the full Fleet Names will be displayed on the screen to the right, exactly how
       they will be displayed on the SmartWay website.
5.


6.


7.
To proceed, select the Fleet Details tab at the top, or simply select the
the bottom of the screen.
                                                                  button at
Before moving on, a popup screen will appear asking you to verify that you are satisfied with your
fleet name(s).
Verify that the fleet name(s) show exactly what you want customers to find in the SmartWay
Carrier Data File.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 44

-------
8.   Select OK to proceed to the next screen. You may return to this screen later to revise your fleet
    name(s) if necessary.
                                  Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 45

-------
"FLEET DETAILS" SCREEN OVERVIEW

The Fleet Details Screen is shown below:
 SmartWay; Fleet Characterization - Truck ~"
    Identify Fleets       Fleet Details        Operation
                                                 Bodylypes
                                                             SmartWay Category
  This Tool should only be used by companies that "control" their own truck fleets. If you move 10% or more of your freight via rail, or have a logistics
  division, you should use the Multi-modal Tool. "Control" means that you own or lease, and route/maintain the trucks in your fleet for at least 95% of the
  miles that fleet travels. A 5% "non-control" allowance is made for contracting occasional overflow or seasonal scheduling. For each fleet, check the 95+%
  Control box to verify this status.
  Enter your SCAC, MCN and DOT information. Vour CUSTOMERS use this information to search for your fleet(s) in their own SmartWay Tools, and if they
  can't identify you, they may assume you are NOT a SmartWay partner, will become frustrated, and may contact you regarding your SmartWay status. If
  your fleets share any SCAC, MCN, and/or DOT information, make sure your Partner/Fleet name is descriptive enough for your CUSTOMERS to differentiate
  between your different fleets.
  Identify your Fleet type. If you are a private fleet, ideally your parent Shipper company should be a Smartway Partner. Identify your Fleet Contact.
  After completing the information on this screen, select the "Operation" tab above or select the NEXT button at the bottom of this screen.

   Partner/Fleet Name	c*on+trelJ-   SCACjs) JJ   HCN-Ll  POTjJ   Fleet Type-ll  Fleet ContactjJ

1: ABC Trucking, Inc. : Dry Van Fleet
2: ABC Trucking, Inc.; Dray Fleet
r~
r

r r r ~nr ~3
r r ~3r ~u
                                       Figure 34: Fleet Details Screen
The Truck Carrier Tool is designed only for fleets over which you have total control.  The Fleet Details
screen asks you to:
    1)  Verify and declare that you have control,
    2)  Add identifying information to help SmartWay Shippers and Logistics Company Partners find your
        fleets, and
    3)  Identify the contacts for each of the fleets you defined in the previous screen.

 "Control" means that you operate/route the vehicles,  regardless of ownership status.  Control includes
dedicated fleets that you operate for other parties. If you can actively affect the fuel efficiency of the
truck and collect the data necessary on that truck to include in this Tool, you have control.

 SmartWay understands that there are many organizational/operational variations in the trucking
industry and there may be "gray" areas that need further clarification.  If you still have questions, you
may contact your assigned SmartWay Partner Account Manager or the SmartWay Help Line at 734-214-
4767.

NOTE:  If you contract out more than 5% of a fleet's operation, the SmartWay Logistics Tool should be
used for that fleet.

Once you have confirmed that you control the fleets you have identified, you will be asked to provide
further data that helps customers identify your fleets. The Truck Carrier Tool asks you to provide three
types of industry identifier codes for each your fleets.
    •   Standard Carrier Alpha Codes (SCACs) are unique 2-4 alphabetic character codes used by the
        transportation industry to identify transportation companies. SCACs are assigned by the National
        Motor Freight Traffic Association, Inc., (NMFTA). If you cannot remember your SCAC(s), contact
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 46

-------
       NMFTA before proceeding. You can find NMFTA contact information at
       http://www.nmfta.org/Pages/ContactUs.aspx.
    •   Motor Carrier Numbers (MCNs): are 5, 6 or 7 digit numbers provided by the Federal Motor Carrier
       Safety Administration.
    •   Department of Transportation (DOT) Numbers are carrier identification number issued to all
       carriers in the U.S. by the Federal Motor Carrier Safety Administration, and can be up to 7 digits
       in length.
Entering SCACs, MCNs, and DOT numbers is optional; however, if you have this information you are
encouraged to supply it to make sure that SmartWay Shippers and Logistics companies can find you.
You will also need to establish the Fleet Type for each of your fleets, which is defined as the service type
for your fleet. There are three options accepted by the Tool—"For-Hire", "Private" and "Dedicated." If
your company has only one fleet, your "Fleet Type" selection will reflect your company's operations as a
whole. If there are multiple fleets, each will have  its fleet type defined separately.
Finally, you will identify a Fleet Contact for each fleet. This contact should be one of the contacts
already identified in the Contact Information section as the contact for each fleet.

NOTE: A drop-down menu in the Tool will supply this information; if there is a contact for the fleet that
is not  already listed in the Contacts worksheet, you will need to go back to the Company and Contacts
screen to add the required contact information.

STEPS FOR COMPLETING "FLEET DETAILS" SCREEN

    1.  For each fleet, if you control over 95% of the operation of the vehicles (weighted by miles) check
       the box labeled "95+% Control."
    2.  Enter SCAC, MCN, and DOT identifiers (optional) for each fleet listed. If you have a single fleet
       that has multiple SCACs, enter all of them into the SCAC field, and separate them with commas.
      •       While it is not required to enter SCAC, MCN, or DOT information for each fleet, it will
              help shippers and logistics companies searching by those parameters in the SmartWay
              database to easily find your fleet for inclusion in their Tool.
    3.  Select your Fleet Type (either "For-Hire", "Private" or "Dedicated") for each fleet listed.
    4.  Select a Fleet Contact from the drop-down menu for each fleet listed.  If the appropriate fleet
       contact is not listed, go back to the Contact Information screen (see Section 2), and enter that
       name under "Other Contacts." Then return to this screen to add the name from the drop-down
       menu.
    5.  Click the            '  button or select the Operation Categories tab at the top to proceed to
       the next section.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 47

-------
"OPERATION CATEGORIES" SCREEN OVERVIEW

The Operation Categories Screen is shown below:
 SmartWay: Fleet Characterization - Truck
    Identify Fleets
                  Fleet Details
                                             Body Types    SmartWay Category
  For each fleet, enter the percentage of total miles driven that fall into each operation category. Percentages must sum to 100 percent for each fleet.
  When finished, select the 'Body Types" tab above or select the NEXT button at the bottom of this screen.
                                                 Less Than         Package
   Partner/Fleet Name                             Truckload Truckload  Drayage   Delivery  Expedited
   1: ABC Trucking, Inc.: Dry Van Fleet
   2: ABCTrucking, Inc.: Dray Fleet
                       Figure 35: Operation Categories Screen - Example Fleet Inputs
For each fleet, you are asked to estimate the percentage of total mileage that is operated in each of five
operation categories defined in the Tool. These Operational Categories are defined below:

        •      Truckload (TL) operations involve movement of large amounts  of homogeneous cargo,
               generally the amount necessary to fill an entire semi-trailer or intermodal container. A
               truckload carrier is a trucking company that generally contracts an entire trailer-load to a
               single customer.
        •      Less-than-truckload (LTL) operations involve collecting freight from various shippers and
               consolidating that freight onto enclosed trailers for linehaul to the delivering terminal or
               to a hub terminal where the freight will be further sorted and consolidated for additional
               linehauls.
        •      Drayage (Dray) operations are predominantly associated with port or
               railhead connections where freight is picked up and moved to a transfer facility
               or transport mode terminal. These moves are often short in nature, but can be longer
               depending on specific situations.
        •      Package delivery (PD) operations are characterized by residential or business package
               pickup/delivery consisting primarily of single  or small groups of packages. Package
               delivery does not include larger scale pickup/delivery operations that are more properly
               characterized as LTL operations.
        •      Expedited operations are time-sensitive freight shipments, with trucks typically waiting
               on stand-by.

You will be asked to enter the percent of each operational type based on approximate mileage. This
percentage calculation does not need to be exact; however, it should be a reasonable representation of
your fleet's operations.
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 48

-------
NOTE: You should define your fleet's operations based on your customers' ability to choose them. For
example:

    •   If a fleet is a mix of TL and LTL, you will indicate the percentages of each.
    •   If customers can choose to hire your TL fleet, your LTL fleet, or your dray fleet separately, then
       each should be regarded as a separate fleet.


STEPS FOR COMPLETING "OPERATION CATEGORIES"SCREEN:

       1.   For each fleet identified, estimate the percentage of mileage each fleet spends in the five
           defined operation categories and enter your estimates in the fields provided.  Leave the field
           blank if no mileage is associated with that operation category for that fleet.
       2.  Click the            ' button or select the Body Types tab at the top to proceed to the next
           section.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 49

-------
"BODY TYPES" SCREEN OVERVIEW

The Body Types screen is shown below:

 SmartWay: Fleet Characterization - Truck
    Identity Fleets
                   Fleet Details
                                   Operation
  For each fleet, enter the percentage of total vehicles by body type. Percentages must sum to 100 percent for each fleet.
  When finished, select the "SmartWay Category" tab above or select the NEXT button at the bottom of this screen.
                                                                 Body Type (<*)
                                        _,]    JrJ    JrJ
                                                                   Heavy/  Auto             Special
                                       Dry Van  Reefer Flatbed Tanker  Chassis  Bulk  Carrier  Moving  utility  Hauler
   Partner/Fleet Name
   1: ABC Trucking, Inc.: Dry Van Fleet
   2: ABC Trucking, Inc. : Dray Fleet
                                   Figure 36: Example for Body Types Screen


Body Type categories as defined in the Truck Carrier Tool are:

        •        Dry van
        •        Refrigerated (Reefer)2
        •        Flatbed
        •        Tanker
        •        Intermodal chassis containers (pooled and owned)
        •        Heavy/Bulk hauler
        •        Auto carriers
        •        Moving
        •        Utility3
        •        Special hauler (e.g., Hopper, Livestock, and other specialized carriers)

STEPS FOR COMPLETING "BODY TYPES" SCREEN:

For each fleet, enter an estimate of the percentage of fleet mileage associated with each body type. The
percentages specified can be approximate, based on vehicle populations. The percentages for each fleet
must sum to 100%.

                                                    Describe
NOTE: If you specify activity for Special  Haulers, a —     I button will appear next to the cell entry. You
must select this button and provide a text description of your specialty haulers.
  If you specify reefer body types in your fleet you must also provide your estimated reefer fuel use in the Activity section of the Tool.
  The utility category encompasses class 2b to 8b vehicles that do not carry typical commercial freight. Examples include garbage,
recycle, service, work, dump, landscape, cement, bucket, boom, ambulance, armored, fire, farm, wrecker, and other similar trucks.
Because these trucks do not carry traditional freight payload, the user should self-define their payloads so as to make the emissions
per payload efficiency useful to the user. SmartWay will not use the emissions per payload results for the utility category.  Users may
experience yellow or red warning labels on the Activity screen due to the unique nature of utility "payload." In the case of red alerts,
simply input text defining your special conditions in the required text boxes that appear.
                                           Truck Carrier Tool Data  Entry and Troubleshooting Guide | P. 50

-------
"SMARTWAY CATEGORY" SCREEN
The SmartWay Category screen is shown below:
 SmartWay: Fleet Characterization - Truck
    Identify Fleets
                  Fleet Details
                                Operation
Bodv Ivpes    [ SmartWay Category
  Based on your Operation and Body Type Information, this is how your fleets will be classified in SmartWay.
   Partner/Fleet Name
                                                 SmartWav Category
   1: ABC Trucking, Inc.: Dry Van Fleet
                                          |Truckload-DryVai
  2: ABC Trucking, Inc.: Dray Fleet
                                           Mixed
                             Figure 37: Example SmartWay Category Screen
The SmartWay Category designation for each of your fleets is shown on this screen, based on your
selections on the Operation and Body Type screens. Your fleet's performance will be measured against
other carriers with the same category designation, so please ensure you have characterized your fleet
correctly before proceeding.
                                                                         CREATE
                                                                        FLEET(S)
Once you are sure your information is input correctly, you may select the  mMOaiat^ button at the
bottom of the page. You will be prompted then to confirm that you have identified all of your fleets.
Return to the Identify Fleets screen if needed, otherwise select
be returned to the Home screen.
                          .and you will automatically
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 51

-------
Section 4: Select Fleet for Data Entry (providing activity and fuel
consumption information for your fleets)

In Section 4 of the Truck Carrier Tool, you will enter detailed activity and fuel consumption data for each
of the fleets you identified and characterized in Section 3.

All Truck Carriers should enter the most recent 12 months of data into the Tool. If you are submitting
for the first time and do not have a full year of operational data, you must collect a minimum of three
months' data for input to submit a tool and join SmartWay. You will be required to submit a full year's
data in the follow year's submission.

You will select and enter information about each fleet separately. To begin entering data for a fleet, you
must first review the fleet's status in the Section 4 status window.
                                   Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 52

-------
FLEET STATUS REVIEW OVERVIEW

Once you have returned to the Home screen, you will see all of your fleets listed in the window below
item # 4: Select Fleet for Data Entry.
 SmartWay Truck; Home
          SmartWay
Report Year
    2014
           Truck
United States Version: 2.0.14
    Released on: 1/7/2015
   Please complete the following steps. Check boxes on the left indicate successful completion of each step. For more
   information, select the 'Help' button.
       1. Enter Partner Hame  [Exactly as it should appear on the SmartWay website):
         |ABC Trucking, Inc.
                  Enter Contact Information
       4. Select Fleet for Data Entry  [Double-click the fleet name or select and hit Enter):
ABC Trucking, Inc, ; Dry Van Fleet - Not Checked
ABC Trucking, Inc. : Dray Fleet - Not Checked ^^^^
^***»


Fleet File
Status
Indicators



            JLl
               Review Year-to-Year Comparison
            Partner Profte / Logo Info / Suggestions
                  View Your Data Reports
                Generate Fie to Send to EPA'
          * After selecting this option, be sure to carefully read' aS'directions before proceeding.
                                                                                  Screen
                                                                                  Demo
                                                                                                 PageT-3
                  Figure 38: Home Screen - Fleet Status Prior to Activity and Fuel Data Entry
A status message appears after each fleet, indicating whether or not the data entry for that fleet is
complete. There are three possible status messages:
        •       Not checked - Data has not been entered yet.
        •       Incomplete - Some data is still missing and/or inconsistent.
        •       Complete - All data requirements have been met and validation has occurred.
                                         Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 53

-------
In addition to the status messages above, you may also see one of two qualifiers: "Errors" or "Warnings."

       •   Errors prevent you from generating internal metrics reports (under the "View Your Data
           Reports" section of the Tool), and must be addressed before you can submit your Tool to
           EPA.  However, with errors, you will be able to use the Year-to-Year Comparison Report to
           help identify missing data or otherwise clarify uncertainties by referring to previous year
           submissions.

       •   Warnings will still allow you to run internal metrics reports and submit your data to EPA.
           However, it is strongly recommended that you carefully review each warning message
           before sending your data to EPA so that you can anticipate questions that may come from a
           partner account manager (PAM) as a result of your data being outside the expected ranges.
           The method of addressing errors and warnings is described for the various input screens in
           the following sections.

To add data to a particular fleet file, highlight the fleet name and then double-click. You will then proceed
to the Tool data entry screens.

STEPS FOR SELECTING A FLEET TO REVIEW:

    1.  Using your mouse, select and highlight the name of the fleet for which you wish to enter  data.
    2.  Double click the name; you will then be taken to the General Information data entry screen for
       that fleet.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 54

-------
   "GENERAL INFORMATION" SCREEN OVERVIEW
   The General Information screen is shown below:
Truck: ABC Trucking, Inc.: Dry Van Fleet
General Information
 Please enter general Information for this fleet. To enter comments about this fleet, use the Comments button that appears near the bottom right corner
 of this and all subsequent screens.
 1. Short-haul vs. long-haul split: |_?J
       Short Haul    |     %

       Long Haul         %

 2. Fuel types found in this fleet (indicate all that apply): J?J

    l~ Diesel / Biodiesel     l~ LPG     F CNG    r Hybrid

    T Gasoline / Ethanol     F~ LNG     r Electric


 3. Participate Matter Reduction  J?J
   Check this box if you employ particulate matter reduction technologies for
   trucks with diesel engines that were built in 2006 or earlier.

    f~ PM Reduction

 4. "Cube Out" Percentage  J?J
   Enter the percentage of truckloads that utilize
   100% of available cargo capacity, while          o/0
   remaining under allowable weight limits (i.e.} cube
   out before weigh out).


 5. Commodities List
   Select the View/Select Commodities button to specify which
   commodities your fleet normally carries.
           View/Select Commodities
Current Status of this Fleet:
                          Incomplete (Errors)
                                                                                                      Page 16
                  Figure 39: Sample Data Entry Screen for First Example Fleet- General Information


   This screen asks you to provide information for six key indicators, including fuel types used.


   The first section asks you to determine your short haul split vs. long haul split.  This requires you to

   estimate the percentage of your fleet's operations that are short haul or long haul.  A short haul is

   defined as any haul less than 200 miles; a long haul is defined as any haul in excess of 200 miles.

   Percentages should be reasonable estimates.


   Next, you must select the fuel types found in this fleet. This requires you to define all fuels the fleet
   used from a list of:


               a.  Diesel/Biodiesel: petroleum diesel and/or biodiesel made from any renewable feedstock

               b.  Gasoline/Ethanol: conventional and reformulated gasoline, including blends of 10%
                   ethanol (E10) and 85% ethanol (E85)

               c.  Liquefied Petroleum Gas (LPG): also known as LP Gas,  Liquid Propane Gas, and propane

                                              Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 55

-------
           d.   Liquefied Natural Gas (LNG)
           e.   Compressed Natural Gas (CNG)
           f.   Electric: vehicles exclusively using batter electric power
           g.   Hybrid: vehicles with hybrid electric or hydraulic hybrid powertrains, using either
               gasoline or diesel

NOTE: Once you check these boxes, the appropriate fuel type tab (along the top of the screen next to the
General Information tab) will become active.

If you select the Diesel/Biodiesel box, the grayed-out Part 3: Particulate Matter Reduction section will
become active.

You will then be asked to determine whether you will need to enter data for Particulate Matter
Reduction. Check the Particulate Matter Reduction box only if you have truck engines that are 2006
model year or earlier and are equipped with diesel retrofit particulate matter control devices (i.e., diesel
oxidation catalysts (DOCs), particulate filters, or closed crankcase ventilation (CCV)).

Next you will be asked to determine what is known as your "Cube-Out" Percentage.  Your "cube out"
percentage is the percentage of trailers using 100% of their available cargo capacity while remaining
within allowable weight limits.  You must provide a reasonable estimate.
                                View/Select Commodities
Next you will go to the I                                           I button to view a list of
potential shipment types and select all of the ones that you move with this fleet.

You also have the option of choosing to participate in SmartWay's Port Dray Program.  This voluntary
program recognizes Partners for reducing diesel emissions from port drayage trucks.  If you have a fleet
(or fleets) with 75% or more of operation in the Dray Operation Type category, your fleet is eligible to
participate in SmartWay's Port Drayage Program. Appendix A to this document provides the data entry
requirements for participation in this program as well as details regarding Dray Program Scoring.
Once you have completed all of the General Information screen items, you can select the
button to make sure you have filled out everything on this screen properly. You can also select
                                                                                   VALIDATE
                                                                                    SCREEN
   VALIDATE
     FLEET
             -to check your data entries across all screens for the given fleet.  Any data entry gaps or
inconsistencies will be identified by the Tool.

However, if validating the fleet, note that you will receive additional validation errors unless you have
completed  the data entry for all screens.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 56

-------
STEPS FOR COMPLETING "GENERAL INFORMATION"SCREEN

1.  Enter your percentage short-haul vs. long-haul operations.

       •        Inputting a value in one cell automatically populates the other cell to add up to 100.
2.  Check the boxes for the fuel types you use.

       •      Once you check these boxes, the appropriate fuel type tab (along the top of the screen
              next to the General Information tab) will become active. If you select the
              Diesel/Biodiesel box, the grayed-out Part 3: Particulate Matter Reduction section will
              become active.
3.  Determine whether you will need to enter data for Particulate Matter Reduction; if yes, check the
    box.

       •      Check the Particulate Matter Reduction box only if you have truck engines that are model
              year 2006 or earlier and are equipped with diesel retrofit particulate matter control
              devices (i.e., diesel oxidation catalysts (DOCs), particulate filters, or closed crankcase
              ventilation (CCV)).
4.  Enter the percentage of trailers using 100% of available cargo capacity while remaining within
    allowable weight limits.

5.  Click the H^ififijijiUiUiiiMlH^Hbutton and select which commodity categories you typically
    carry.  Select all categories that apply to your fleets.
6.  FOR FLEETS WITH 75% OR MORE OF TRUCKS IN THE DRAYAGE OPERATIONS CATEGORY: Check the
    box if you wish to participate in the Port Dray Program.
                VALIDATE
                 SCREEN
7.  Select the  _       _ button to make sure you have filled out everything on this screen properly.


    You can also select  —        —to check your data entries across all screens for the given fleet.
8.  Click            '  or select the next available fuel tab at the top to begin entering fuel and activity
    data for this fleet.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 57

-------
FUEL SECTION: "ENGINE  MODEL YEAR & CLASS" OVERVIEW

This section looks at truck classes and engine model years. Under each fuel-type tab (Diesel, Gasoline,
LPG, LNG, CNG, Electric, and Hybrid) there are as many as four screens requiring data inputs:

    1.  The Engine Model Year & Class4 screen,
    2.  The Activity Information screen,
    3.  The PM Reduction screen will appear for diesel vehicles if you checked the
        Particulate Matter Reduction box on the General Information screen, and
    4.  The Port Dray Program  screen will also  appear for diesel vehicles if you checked the Port Dray
        Program box on the General Information screen.

The Diesel Fuel Types Screen is  shown below—this  screen defaults to the first available sub-tab, the
Engine Model Year & Class screen:
   Truck: ABC Trucking, Inc.: Dry Van Fleet
    General Information
                                                                                               Hybrid
       Engine Model Year & Class
                            Activity Information
    Select the checkbox for each class in your fleet, which will activate the data-entry columns for that class. Input the number of trucks you have by class and ENGINE
    model year (not vehicle model year). The number of trucks in each class should be a count as of Dec. 31 of the reporting year. Truck model year may be used as a
    surrogate if engine model year cannot be determined. If model year is used, provide an explanation in the Add Comments box. Truck class totals are automatically i—i
    calculated for you. If you operate certain trucks across multiple fleets, please apportion your vehicle counts across fleets to avoid double counting of your trucks.  | ? |
         Diesel

     Gross Vehicle Weight  -
       Rating (pounds)
    Note: The silhouettes
    represent examp/e truck
    types for each class, and
    are not ail-indusive,
                Total
               Trucks
                                                         Truck Classes
                      Class 2b      Class 3      Class 4      Class 5      Class 6      Class 7     Class 8a     Class 8b
                     8,501-10,000  10,001-14,000  14,001-16,000  16,001-19,500  19,501-26,000  26,001-33,000  33,001-60,000  60,001 S, above
                                                        rs
                                                                            r 7
                                                                                      r 8a
                                              f~ Hide Unchecked Classes
                                                                                                  PageT-23
                                 Figure 40: Engine Model Year & Class Screen

NOTE:  For each fuel type that you identified on the General Information screen, you will be required to
complete the Engine Model Year & Class screen AND the Activity Information screen. If you do not
complete these screens for any of the fuels, your fleet will be marked as Not Complete on the Home
screen and you will not be able to submit your Tool.
For Electric, this screen is known as the "Motor Model Year and Class" Screen.
                                         Truck Carrier Tool Data Entry and Troubleshooting Guide
                                                                                                      P. 58

-------
The first step on the Engine Model Year and Class tab is to identify the vehicles classes you have
represented in this fleet.  Begin by selecting the boxes at the top for each of the truck classes you
operate in this fleet (i.e., 2b, 3, 4, 5, 6, 7, 8a, 8b). Example truck types are shown in silhouette above the
boxes, and additional examples will be listed on the screen when placing the mouse over these images.

When a Truck Class box has been checked, the data column will activate.

Next you must enter the number of vehicles you  have in each class, specifying the corresponding engine
model years (rather than the vehicle (tractor) model years). Use the scroll bar to the right if you need to
enter information for model years earlier than 2005.

Totals for each truck class are calculated automatically for you and displayed along the top row.  Totals
by model year are shown in the left-hand column.

NOTE: If you defined multiple fleets on the Fleet Characterization screen, and if you operate certain
trucks across multiple fleets, apportion your vehicle counts across the fleets to avoid double counting of
your trucks. For example, if you operate the same 100 trucks across two fleets, with 20% of the truck
mileage for the first fleet, then enter 20 trucks for fleet #1, and 80 trucks for fleet #2.

STEPS FOR COMPLETING THE "ENGINE MODEL YEAR & CLASS" SCREEN

           ***NOTE: The following guidance will use the Diesel Fuel sections as an example.
                     Similar procedures are followed for all other fuel types.***

    1.   Select the boxes at the top (i.e., 2b, 3, 4, 5, 6, 7, 8a, 8b) for each of the truck classes you operate
        in this fleet.
    2.   Input the number of vehicles you have in each class, specifying the corresponding engine model
        years (rather than the tractor model years). Use the scroll bar to the right if you need to enter
        information for older model years.
    3.   Check the box at the bottom of the screen to hide any unused truck classes if you wish.
    4.   Select
or select the Activity Information tab at top of the screen to proceed to the
        next section.  Before leaving the Engine Model Year & Class screen, you will be prompted to
        confirm the accuracy of your model year and truck class selections (Figure 41). You may review
        previous years' selections by selecting the Year-to-Year Comparison Report on the Home screen.
    I \  Select OK to confirm your current truck class selection(s), Otherwise; select Cancel and revise your truck class selections.
    *J
        NOTE: IF you are a returning partner, be sure to run the Year-to-Year Comparison Report (accessed from the Home screen) and pay special attention
        to your truck class counts before submitting your tool to EPA, in order to verify the accuracy of your current year truck counts. View the help text on
        the Year-to-Year Comparison Report for additional details.
                                           OK   il    Cancel
                  Figure 41: Confirmation of Engine Model Year and Truck Class Selections


                                       Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 59

-------
  NOTE: Class 8a trucks are often mistaken for Class 8bs.  If you select to enter data for Class 8a trucks
  you will be asked to confirm your selection.  Please refer to the Gross Vehicle Weight Rating Definitions
  at the top of the screen before proceeding.
  FUEL SECTION: "ACTIVITY INFORMATION" SCREEN OVERVIEW
  The Activity Information screen is shown below:
Truck: ABC Trucking, Inc.: Dry Van Fleet
General Information
                                                            LNG
                                                                          CNG
                                                                                      Electric
                                                   PM Reduction
Select the "Add" buttons to identify your data sources. (After specifying your data sources, the button will read "Edit"; you may select "Edit" to make
changes as needed.) In the "By Truck Class" columns, enter your data for each truck class (only those classes selected on the "Engine Model Year & Class"
tab appear below). The "Overall Fleet" column will automatically display fleet-level information based on the data you enter for your truck classes.
           Diesel
                                    Overall Fleet & Data Source
                                   Overall Fleet UTjl  Data Source  ?
                                                                          31.
•?
?
?
Total Miles Driven (exact values) 0

Empty Miles Driven (exact values) 0
c

E
!£lj
m\

\
I
r r~
 7 I Gallons of Dies.
 -^ (exact values)
if Diesel Used, incl. Biodiesel & Reefer
     Refrigeration Unit Fuel Consumption
 ? Gallons of Biodiesel (B100 Equivalents)
 7 I Average Payload (tons) - Cargo Weight Only


^?J Average Capacity Volume (cubic feet)


 1\  Capacity Utilization (excluding empty miles)
 ? Road Type / Speed Categories
 * Indicates that default speed distributions were selected for urban road types.
 ? Average Annual Idle Hours per Truck
                                                                                                        Page 20
                                Figure 42: Diesel Vehicles Activity Information Screen


  The text at the top left-hand corner of this screen indicates the fuel type for which you are entering data.
  You will need to enter data for each fuel type you use within your fleet under separate screens, including:

           •       diesel and biodiesel, entered under the same tab
           •       gasoline and ethanol, entered under the same tab
           •       LPG, LNG, CNG, hybrids, and electric trucks each entered under separate tabs
                                              Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 60

-------
If you selected more than one fuel type for this fleet on the General Information screen, then you will
also need to enter data on the other fuel type tabs. For instance, if you operate gasoline vehicles, select
the Gasoline Vehicles tab on the main tab bar to enter your data.

                ***Aiert! Be careful to input data under the appropriate fuel tab!***

On each fuel type's Activity Information screen, you will see two main sections to input data:

           •   Overall Fleet & Data Source section (with a green header), and
           •   By Truck Class section (with a blue header).

The Overall Fleet data indicates the  sum or average (as appropriate) for the fleet across all truck classes
you have selected on the Engine Model Year and Class screen. This value is automatically tallied when
you enter data in the "By Truck Class" fields (the blue header section.)
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 61

-------
MAIN FUEL ACTIVITY DATA POINTS OVERVIEW

The first five activity data points are:

    •   Total Miles Driven (exact values): all miles driven collectively by all fleet vehicles in a specific
        class

    •   Revenue Miles Driven (exact values): all miles that were charged to a customer account.
           o   NOTE: If you have a private fleet that does not track revenue miles for internal cost
               accounting, set revenue miles equal to total miles - DO NOT SET REVENUE MILES EQUAL
               TO ZERO.
           o   This information is not used to calculate your SmartWay carbon score, but may be used
               determine an adjustment factor for shippers' carbon inventories.5

    •   Empty Miles Driven (exact values): the total number of empty miles traveled by your fleet.
           o   Empty is defined as zero cargo.
           o   NOTE: If you enter zero (0) empty miles, you must provide text explaining why you have
               no empty backhauls by double-clicking on the cell.
           o   The number of empty miles will not affect your SmartWay score. Companies in categories
               with high empty miles, such as tanker operations, will not be negatively affected by high
               empty-mile values.

    •   Gallons of Diesel Used, including biodiesel and reefer (exact values): all gallons of fuel used by
        your fleet in the past 12-month reporting period.
           o   This includes any gallons with biofuels (biodiesel for diesel vehicles, ethanol for gasoline
               vehicles).
           o   It also includes gallons used for refrigeration, bunk heaters, yard moves, or any other
               gallons directly attributable to transportation. Refrigeration (reefer) gallons must also be
               reported separately.
           o   It does NOT include gallons used in heating buildings, forklifts, or other non-
               transportation sources.
           o   NOTE:  If total gallons of diesel fuel used are known for the fleet  but not by class, the
               Fuel Allocator Worksheet will help you apportion your total fuel  use into class
               categories.

    •   OPTIONAL: Gallons of Biodiesel or Gallons of Ethanol (for diesel and gasoline fuel tabs,
        respectively): the B100 equivalents for biodiesel  or the E100 equivalents for ethanol used by the
        fleet
It should be noted here that all values for  mileage, gallons, and other inputs should reflect EXACT
values rather than rounded estimates. Failure to provide exact values will trigger warnings upon
validation, reminding you to input exact values.
5 Since shippers determine their carbon inventory based on revenue miles charged by their carriers, shippers collectively must also
include the non-revenue miles in their carbon inventory. Thus shippers will be charged the carbon for the non-revenue miles that
carriers have to travel. This value will be calculated on an industry basis, and will not affect individual carriers.

                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 62

-------
For each of these four data activity points, you must specify a data source.
To add data source information, select the ILLU button under the Overall Fleet & Data Source section
to specify where you obtained your data for each row.

Use the pull-down menus on the Data Source Description popup screens to specify the source of
information for each Data Type (listed in red at the top of the form).  Most of the data source information
you specify is assumed to apply across all vehicle classes in your fleet.

A helpful reference table with available sources is included in Appendix B.

In addition to the general data source, further detail must be provided regarding /?owthe particular data
was collected (e.g., via GPS or odometer readings).

After selecting from the "Data Source" and "Source Detail" drop-down menus, you may be required to
provide additional information regarding the way you collected your data and associated calculation
methods, as appropriate. You should provide enough detail to confirm data validity and reasonableness.
Once the data is entered, the |uUJ buttons will read Edit, allowing you to change your choices later.)

NOTE: "Data Source" descriptions for payload and volume information are specific to each truck class,
                                                                C alt Payload ••• Calc Volume
and are entered through the Payload and Volume Calculators (select maatmrnitttm^ anc|
to access; see Figure 43).
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 63

-------
 SmartWay Data Source Description
  Please provide details on the source of your data. If you are using different sources of data to characterize different
  body types, please select "Other — list all that apply" and describe each data source and calculation method in the text
  box provided.

  Data Type:    Average Payload (Diesel) for class 8b
  Data Source:   Based on bills of lading - electronic records (preferred)
  Source Detail:  Based on actual miles traveled by specific payloads*                                            _^j

  * - Please describe the methodology used to develop your estimate. Well-documented data will enhance the confidence and
  reputation of the SmartWay program. Additionally, this information will be useful for the person who completes this Tool nput year.
    Data pulled directly from bills of lading
                                                                                  2959 characters remaining
                            Figure 43: Example Data Source Description Screen
Once your data sources have been selected, you can then enter the requested activity information for
the reporting period for each truck class in the white empty cells to the right (under the blue heading "By
Truck Class."

STEPS FOR COMPLETING THE MAIN FUEL DATA POINTS ON THE "ACTIVITY INFORMATION" SCREEN
1)  Select the JiiiiiJI button under the Overall Fleet & Data Source section to specify where you
    obtained your data for each row. For each data type, specify the general type of data source.
2)  Enter the exact value for total miles driven collectively by this fleet by vehicle class.  Include all out-
    of-route, positioning, empty, and other miles driven.
3)  Enter the exact value for the revenue miles—the number of miles your fleet drove that were charged
    to a customer account.
4)  Enter the exact value for the total number of empty miles traveled by your fleet.
5)  Enter the exact value for all the gallons of fuel used by your fleet in the past 12-month reporting
    period, including any gallons with biofuels (biodiesel for diesel vehicles, ethanol for gasoline vehicles).
6)  If you specified any use of refrigerated body types under the Fleet Characterization section,  the
       Refrigeration Unit Fuel Cons-
                                      I button will appear underneath the Gallons of Fuel Used section.
    Select this button and provide your best estimate of your refrigerated fuel use in gallons for each
    truck class.  Diesel, LPG, and electric trucks are assumed to use diesel reefers, gasoline trucks to use
                                        Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 64

-------
    gasoline reefers, and CNG/LNG trucks to use CNG reefers. Enter zero for any truck classes/fuel types
    that do not utilize reefer units. If you do not know your reefer fuel use at the truck class level you
    may enter a total value which will be distributed across your truck classes proportional to your
    vehicle fuel consumption entries.
    Figure 44 below presents the Reefer Fuel Data Entry screen.  Enter your reefer fuel  consumption in
    gallons for each vehicle class if possible. If one or more vehicle classes do not include reefers, enter 0
    gallons. The Truck Tool assumes diesel fuel  is used for reefers associated with diesel, LPG, and
    electric trucks, while gasoline reefers are associated with gasoline trucks, and CNG reefers are
    associated with CNG and LNG trucks.

    If you do not know your reefer fuel consumption at the vehicle class level check the box and enter
    your total reefer fuel consumption in the Total cell. This total value will then be allocated across all
    vehicle classes proportional to the total vehicle class fuel consumption amounts.
 Refrigeration Unit Fuel Consumption
  You indicated that your fleet contains refrigeration unit fuel consumption (fuel used to refrigerate your load and
  not to move your truck) in the Fleet Characterization section. Please specify the annual fuel consumption for
  truck based refrigeration purposes below.
   Reefer Fuel Type: Diesel
                    By Truck Class
                             8b
    Amount (in
      Gallons)
        Total
_ Select this box if you don't know your refrigeration      I
l~ unit fuel consumption by truck class (you only know    • I
  your total refrigeration fuel consumption.)
                                                                    F™*
                                                                     Screen
                                                                    I  Demo
                                                                                         Page 35
                 Figure 44: Example Refrigeration Unit Fuel Consumption Data Entry Screen
7)  NOTE:  On the Electric Vehicle Activity screen, "fuel inputs" are expressed in kWhrs rather than
    gallons.
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 65

-------
"FUEL ALLOCATOR WORKSHEET" OVERVIEW

The Truck Carrier Tool asks you to enter Gallons of Diesel Used by truck class.  This information may be
entered directly if you have it.  However, if you do not, but you do know total fuel use and MPG by truck
class, the Fuel Allocator will assist you in apportioning your fuel use across truck classes.
To use the Fuel Allocator Worksheet, you will select the
                                                            Allocate Diesel Using class MPG
                                                           button
on the Activity Information screen beneath the data entry cells for the "Gallons of Diesel Used, incl.

Biodiesel & Reefer (exact values)" section.


Figure 45 shows the Fuel Allocator Worksheet. Note that you must enter total miles for each truck class

on the Activity Information screen before you can open this worksheet.
                    SmartWay Fuel Allocator Worksheet
                     Enter your fleet's total annual fuel use along with the average MPG for
                     each truck class. Using the annual mileage estimates you've already
                     entered, the Fuel Allocator will calculate fuel use for each class.

                     If the sum of the calculated class-level fuel consumption differs from the
                     value for "Total Gallons Used for Entire Fleet" by more than 2%, "No
                     Match" will appear in red at the bottom right of the screen, and you will
                     need to revise your MPG and/ or class mileage inputs to be consistent
                     with your total fuel input.
                            Total Gallons Used for Entire Fleet*: [    4,783,686|
                         Class
                                 Total Miles    Approximate    Calculated
                                   Driven       Class MPG    Gallons Used
                               r
4,007,215
                          8b        19,946,823


                         Total
598,092
                         4,155,588
                                    23,954,038
                         4,753,680  Match
                                      ADD
                                   COMMENTS
                                      Screen
                                      Demo
                     * - "Total Gallons Used For Entire Fleet" will appear on the main Activity tab and will be used For
                     calculating fleet performance metrics, rather than the sum oF the class Fuel estimates.

                                                                             Page 39
                                    Figure 45: Fuel Allocator Worksheet


                                         Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 66

-------
The Fuel Allocator Worksheet requires you to estimate:

    •   total fuel consumption for your entire fleet across all vehicle classes, and
    •   MPG for each truck class (the worksheet for electric vehicles uses miles/kWhr in lieu of MPG).

Only truck classes selected on the Engine Model Year & Class screen will be displayed on the Fuel
Allocator Worksheet. Class-specific fuel consumption levels are estimated using the annual mileage
estimates entered on the Activity Information screen.

If the sum of the class level estimates is within 2% of the total fuel consumption level entered at the top
of the form, then a "Match" is indicated on the right side of the worksheet, and you may go back to the
Activity Information screen by pressing OK.6

Before returning to the Activity Information screen, you will see a popup:
    i  j   Based on the information you've provided; your calculated fuel total is within 2% of the total fuel you entered,
         However, the two numbers do not match exactly. Prior to writing these values to the Activity Information sheet, this calculator will adjust your class
         fuel amounts so that the sum matches your entered fleet total.
         5elect OK to have these adjustments made. Otherwise, select Cancel to return to the calculator.
                                             OK        Cancel
                               Figure 46: Popup Indicating Fuel Total Match
This popup indicates that the total gallons of diesel you entered and the MPG by truck class that you
entered produced a calculated total fuel use that is slightly different. If you select OK, this calculator will
adjust the by class fuel amounts to a sum matches your entered fleet total.

 If "No Match" is indicated, you must adjust your total fuel consumption estimate and/or your class level
MPG estimates until a "Match" is obtained.

Once you complete the Fuel Allocator Worksheet, total gallons will be summed and displayed in the
Overall Fleet column on the Activity Information screen.

There are two other sections within the "Gallons of Diesel Used, incl. Biodiesel &  Reefer (exact values)"
section, MPG and Miles/Truck, described below.

MPG:  If you used the Fuel Allocator Worksheet to determine your fuel usage, the MPG fields will show
the MPG estimates that you entered into that form. If, instead, you entered gallons of fuel used by class,
the Tool will generate MPG estimates for you. This field is provided as a useful validation check for users.
If the Tool finds an  out-of-range MPG value during its routine validations, the MPG field may be
 Although the calculated and total fuel consumption values are within 2%, the values may not match exactly. Prior to writing the fuel
consumption values to the Activity Information screen, the calculator will proportionally adjust your class level fuel consumption estimates to
match your entered fleet total value.
                                        Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 67

-------
highlighted, in which case you may be instructed to double-click on this cell to provide an explanation for
high/low values.

 Miles/Truck: Once Total Miles are entered for a given truck class, this value will be combined with the
truck count values entered on the Engine Model Year and Class screen to provide a Miles/Truck value,
which is displayed below the MPG value on the Activity Information screen. This field is provided as a
useful validation check for users, and is checked by the Tool's validation routines for reasonableness. If
the Tool finds an out-of-range miles-per-truck value during its routine validations, the field may be
highlighted, in which case you may be instructed to double-click on this cell to provide an explanation for
high/low values.

These two fields do not involve direct data entry; they are populated as a result of Tool calculations and
are based on your entries for total miles by truck class and total gallons by truck class (either directly
entered or  allocated using the Fuel Allocator Worksheet).

STEPS FOR COMPLETING THE "FUEL ALLOCATOR WORKSHEET"
                      Allocate Diesel Using class MPG
    1.  Select the —                                  " button on the Activity Information screen.
    2.  Enter total gallons of diesel for all truck classes.
    3.  Enter MPG estimates for each truck class.
    4.  If "Match" appears in blue next to the "Calculated Gallons Used" field, select
    5.  If "No Match" appears in red next to the "Calculated Gallons Used" field, adjust the MPG values
       as necessary to get a match, and then select
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 68

-------
(OPTIONAL) "BIODIESEL BLEND WORKSHEET" OVERVIEW

If your fleet consumed any amount of biodiesel during the reporting period, you will have access to a
Biodiesel Blend Worksheet, shown in Figure 47. (A similar worksheet is available for ethanol use under
the Gasoline tab - see below.)

The Biodiesel Blend Worksheet asks you to specify the biodiesel volume used by your fleet in gallons by
blend level (e.g., B20 = 20% biodiesel / 80% conventional diesel), for the reporting period. The calculator
will automatically display total gallons, the weighted average blend value  (across all blends), and the
BlOO-equivalent volume at the bottom of the screen, based on your entries.

The Truck Carrier Tool will assume that these gallons are allocated proportionally across all vehicle
classes (weighted by gallons of diesel used) in order to calculate emissions.
                  SmartWay Biodiesel Blend Worksheet
                  For each of the blends used by your fleet, enter the appropriate number of gallons used. The BIQQ-equivalents
                  value will be written automatically to the Activity Information tab.
                   Blend Gallons Used  Blend Gallons Used   Blend Gallons Used
                                                        Blend Gallons Used   Blend Gallons Used
                   Total Gallons of Biodiesel
                         (All Blends)
                                 Figure 47: Biodiesel Blend Worksheet

STEPS FOR COMPLETING THE "BIODIESEL BLEND WORKSHEET "


    1.   If this fleet has used biodiesel, select the lUiiiilJMUdidBI  button and specify your biodiesel
        volumes by blend level in the Biodiesel Blend Worksheet.
    2.   For each of the blends used by your fleet, enter the appropriate number of gallons used.
    3.   Select OK.
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 69

-------
(OPTIONAL) "ETHANOL BLEND WORKSHEET" OVERVIEW


If your fleet consumed any amount of ethanol during the reporting period, you can use the Ethanol Blend
Worksheet, shown in Figure 48, to determine your ethanol usage figures.


If you know the volume of ethanol used by your fleet, specify the volume in gallons for each blend level

(E10 and/or E85), ensuring that the total volume specified does not exceed the gasoline gallon data entry

provided on the Activity Information screen.  (Enter zero for both values if your fleet does not use one of

these blends.)


Alternatively, if you do not know the volume of ethanol used by your fleet, select "Use national average

for ethanol usage (9.05%)." In either case, the total volume of ethanol at each blend level will be

allocated across the different truck classes in your fleet in proportion to the total gallons of gasoline used.
                 SmartWay Ethanol Blend Worksheet
                 Indicate below whether you'd like to use the national average for
                 ethanol usage or if you'd prefer to enter your actual usage.

                 If you select the second option, enter the number of gallons of each
                 blend of ethanol used by your fleet. (Enter zero if your fleet does not
                 use one of the specified blends.) The calculated E100 equivalent value
                 will automatically be written to the main data entry page.

                 If you choose to use the national average instead, your E10Q equivalents
                 will be based on a percentage of the total gallons of gasoline you enter
                 on the Activity Information screen.

                           <~ Use national average for ethanol usage (9.05%)

                            * Enter actual ethanol usage figures
                                  Blend
                                Percentage

                                   E10

                                   E85

                                  Total
                                 Gallons

                                  E100
                                Equivalents
Total Gallons
   Used

     100,000

      12,000|
    112.000
     20.200
                                                                 Screen
                                                                 Demo
                                                                          Page 37
                                 Figure 48: Ethanol Blend Worksheet

STEPS FOR COMPLETING THE "ETHANOL BLEND WORKSHEET "
    1.  If this fleet has used ethanol, select the
                                             Input Ethanol
                button and specify your ethanol
       volumes by blend level (E10 or E85) in the Ethanol Blend Worksheet.

    2.  For each of the blends used by your fleet, enter the appropriate number of gallons used.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 70

-------
    3.  Select OK.
PAYLOAD AND CAPACITY OVERVIEW ON THE "ACTIVITY INFORMATION" SCREEN

This section of the Activity Information screen asks to calculate your average payload by truck class using
an internal payload calculator.

Average payload calculations are made on a "by truck class" basis.  Within a given truck class, you may
have many different body types.

For each body type within a truck class, you will need to choose:
   •   which of the four available allocation methods you will use to distribute your trucks' activity to
       calculate a weighted average payload value by truck class:
           o   # miles by class
           o   Strips by class
           o   %  of operation by class
           o   # vehicles by class
   •   whether you are interested in looking at your payload in units of short tons (=2,000 pounds) or in
       pounds
   •   whether to either directly calculate an average payload for this body type (using bill of lading
       data collected by your company) or to select one of five average payload ranges provided in the
       Tool (which reflect typical industry payload ranges).

The values entered for each body type provide the basis for calculating a weighted average payload for
the class as a whole. For example, by specifying the mileage associated with each body type, the
respective miles per year will be used to weight your payload estimates to calculate an average by truck
class.

Ideally, you should calculate your average payload data by using payload data from your company's bills
of lading records.  Note that, when calculating average payload, your payload data should represent the
average cargo weight per LOADED trip; empty backhauls should be excluded from the calculation.

For truck classes where you have precise payload data, select either electronic or manual bills of lading
(with data based on actual miles traveled or trip-weighted), or another data source (for which you must
provide a text description).

For truck classes for which you DO NOT have precise payload data, select the "Used ranges provided by
the calculator" as your data source.

The Payload Calculator displays up to three screens.

The first screen  is labeled "Step 1: Getting Started." See Figure 49 below.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 71

-------
 SmartWay Average Payload Calculator
  This form is designed to help you determine your average payload. To begin, select an allocation method for determining the amount each body
  type contributes to your overall truck class total.  Four allocation methods are provided in order of preference, with the most preferred method
  listed first. Then select your preferred units for entering your data (tons or pounds).  Next, specify the data source(s) used to develop your
  payload estimates.

  If you do not have precise payload estimates, you may select "Used ranges provided by calculator", and you may choose from different payload
  ranges representative of industry averages. If you know the payload for a given body type, select the data source used to develop your estimates
  and enter the precise values below. If you use different sources to develop the data for different body types, select "Other - list all that apply"
  and provide a detailed description of each.



  Class 8b Vehicles GVWR = 60,001 and above


             1: Getting Started                  Step 2: Body Types
               Select an allocation method, choose your preferred units, and indicate your data source:
                         Allocation
                         Method:  I * °f mi'es in this class
                               its:|tons
                       Data Source: (Electronic
                                                                                                               Page 40
                                       Figure 49: Step 1 of Payload Calculator

On this screen, you will be asked to make three selections:
     •   Allocation Method
     •   Units
     •   Data Source
The first choice you will make is the payload allocation method. The method selected will be used to
allocate your payloads across multiple truck body types within a given truck class. This allocation allows
the Tool to calculate a weighted average payload value by truck class.
There are four payload allocation methods available:
     •   # miles by class
     •   Strips by class
         % of operation by class
         # vehicles by class
                                               Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 72

-------
Next you must choose between either short tons (2,000 pounds) or pounds as your preferred weight

metric or "Unit."


Next you will choose your Data Source(s) for your payload entries.


At this point you will proceed to the next tab,  labeled "Step 2: Body Types" to enter payload information

specific to  each  body type for the given truck class.


Figure 50 presents the "Step 2: Body Types" tab of the Average Payload Calculator.
 SmartWay Average Payload Calculator
  This form is designed to help you determine your average payload. To begin, select an allocation method for determining the amount each body
  type contributes to your overall truck class total. Four allocation methods are provided in order of preference, with the most preferred method
  listed first.  Then select your preferred units for entering your data (tons or pounds). Next, specify the data source(s) used to develop your
  payload estimates.

  If you do not have precise payload estimates, you may select "Used ranges provided by calculator", and you may choose from different payload
  ranges representative of industry averages. If you know the payload for a given body type, select the data source used to develop your estimates
  and enter the precise values below. If you use different sources to develop the data for different body types, select "Other - list all that apply"
  and provide a detailed description of each.
  Class 8b Vehicles GVWR = 60,001 and above


         Step 1: Getting Started                Step 2: Body Types
                                   Class Avg Payload:
    1
          Dry Van - Single
          Dry Van - Double
          Dry Van - Triple
         Combination Reefer
          Total: [
Total Entered on Main Entry Form: j~   ^g 945 323  No Match
SCROLL FOR MORE
      OPTIONS
                                                                                                       Screen
                                                                                                        Demo
                                                                                                           Page 40
                                      Figure 50: Step 2 of Payload Calculator


Use this screen to select the applicable body types for the truck class, specify the payload allocation

information for each body type (e.g., number of miles traveled), and the average payload information.
                                             Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 73

-------
If you specified the "Used ranges provided by the calculator" option under "Data Source" in Step 1, select
from pre-defined ranges (e.g., 1-7 with 1 being the lowest payload range values available and 7 being
the highest).7 Use the scroll bar to the right to display other body types.

If you need to use pre-defined ranges for some body types and precise values for other body types,
select the "Other - list all that apply" Data Source option in Step 1.

If Range 1 (extreme low) or Range 7 (extreme high) values are selected, the value will be highlighted in
red, and explanations must be provided in the text box to the right  summarizing the reasons for the
unusual payload value (e.g., you may explain that a flatbed fleet is  regularly used to transport heavy
construction equipment).

If you select Range 2 (moderately low) or Range 6  (moderately high), the selection will be highlighted in
yellow and a warning will appear. Text explanations are optional for Ranges 2 and 6.

If an exact value entry falls outside the expected (Ranges 3-5) values, an explanation will be requested.

Figure 51 shows Step 2 of the Average Payload Calculator worksheet for Class 8b vehicles.  (Similar
worksheets are provided for each truck class.)
7 Certain truck classes have five rather than 7 payload categories, depending upon observed distributions. Specific range values were determined
based on reported industry payload distributions, and are discussed in detail in the Truck Tool Technical Documentation
http://www.epa.gov/smartway/forpartners/documents/trucks/tool-guide/420bl5002.pdf).


                                       Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 74

-------
 SmartWay Average Payload Calculator
  This form is designed to help you determine your average payload. To begin, select an allocation method for determining the amount each body
  type contributes to your overall truck class total.  Four allocation methods are provided in order of preference, with the most preferred method
  listed first. Then select your preferred units for entering your data (tons or pounds). Next, specify the data source(s) used to develop your
  payload estimates.
  If you do not have precise payload estimates, you may select "Used ranges provided by calculator", and you may choose from different payload
  ranges representative of industry averages. If you know the payload for a given body type, select the data source used to develop your estimates
  and enter the precise values below. If you use different sources to develop the data for different body types, select "Other - list all that apply"
  and provide a detailed  description of each.
  Class 8b Vehicles GVWR = 60,001 and above

         Step 1: Getting Started                 Step 2: Body Types
                                   Class Avg Payload:
          Dry Van - Single
                       # Of miles
                       # of miles
                                      Average Payload
                                      Average Payload
                                                                   Explanation for input value
                                                                    We carry predominantly light-weight products like potato chips in
                                                                    dry vans. Based on our records we confirmed this is a
                                                                   Explanation for input value
                        6,879,451  |Range2: 1,1 to 14.4 tons    Tj
          Dry Van - Double
          Dry Van - Triple
                       # of miles
                                      Average Payload
                                                       Exact Payload
                        7,748,421   I know exactly
         Combination Reefer
          Total: |     20,272,416
Total Entered on Main Entry Form:    jg 9^ 323 Match
SCROLL FOR MORE
      OPTIONS
                                                                                                          Page 40
           Figure 51: Step 2 of Payload Calculator Worksheet - Class 8b Vehicles Data with Explanations
Once the mileage and payload ranges or values are entered for each body type, the worksheet validates
the entries.  If the sum of the by-body type values is within 2% of the class level mileage totals from the
Activity Information screen, a "Match" is indicated and the user may proceed with the rest of the data
entry.  Otherwise "No Match" is indicated and the mileage values must be revised until "Match" is
indicated.  A validation is also performed if "# of "was selected  in Step  1 as the allocation method,
although in this case the match must be exact.  Independent matching is not performed for "# of trips" or
"% of operation allocation  methods."

If any of the values entered in the Average Payload Calculator received Red or Yellow warnings, the
weighted class average payload value shown in the Activity Information screen will be highlighted in
yellow as a reminder.

Once specified for each class, the fleet-average payload will be  calculated (weighted by the number of
miles per class) and displayed in the Overall Fleet column on the Activity  Information screen.
                                            Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 75

-------
EXAMPLE:

ABC Trucking, Inc. has a fleet with Class 8b trucks. This fleet consists of three body types: dry van
single trailer, dry van double trailer, and reefer.

In "Step 1: Getting Started/' ABC Trucking, Inc. chooses "# of miles by class" as the allocation method
and "short tons" as the unit.

Under "Data Source," ABC Trucking, Inc. selected "Other." This allows the company to use ranges for
some data and exact average pay load calculations for others.

ABC Trucking proceeds to "Step 2: Body Types," and selects the checkboxes next to the three body
types present in the Class 8b truck fleet (dry van single trailer, dry van double trailer, and reefer).

ABC Trucking, Inc. enters the total number of miles driven with loads (excluding empty miles) for
each body type.

Next, the company selects the Average Payloadfrom the drop-down lists.

In the case of the dry vans with single trailers, Range 1 is selected. Because this is considered an
unusual result, the Tool highlights this payload, in red and ABC Trucking, Inc. MUST enter an
explanation  to proceed.

In the case of the dry vans with double trailers, Range 2 is selected.  Because this is considered
somewhat unusual, the Tool highlights this payload in yellow, and ABC Trucking, Inc. has the OPTION
of entering an explanation to proceed.

In the case of the combination reefers, ABC Trucking, Inc. knows EXACTLY what the average payload
value is and  enters it in the field provided.
                                   Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 76

-------
STEPS FOR COMPLETING THE PAYLOAD SECTION ON THE "ACTIVITY INFORMATION" SCREEN
    1.  Enter your average payloads into the Tool for each truck class by selecting the
       button.
                                                                              Calc Payload
    2.  Under the "Step 1: Getting Started Tab/' select your activity Allocation Method.
    3.   Select your Units, from the drop-down.
    4.  Select the -        " button next to "Data Source." A Data Source Description box will appear.
    5.   Using the drop-down menus, select your data source and details and enter any comments about
       your data source.
    6.  Select
    7.  Select the "Step 2: Body Types" tab or
    8.  Select the box(es) next to the body types used in this Truck Class.
    9.  For each body type selected, enter the activity associated with this body type.
    10. For each body type selected, use the drop-down to select a range OR enter the exact payload if
       available.  Make sure to include any pallet and packaging weight in your payload estimates.
    11. Validate the screen to determine if there are any errors to correct; if yes, correct the errors
       and/or enter comments using the HJMiilafclH button to explain your data inputs.
    12. Select the I  HIM   | button to perform a final validation check and return to the Activity
       Information screen.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 77

-------
AVERAGE CAPACITY VOLUME (CUBIC FEET) WORKSHEET OVERVIEW ON THE

"ACTIVITY INFORMATION" SCREEN

Volume refers to the total cargo-carrying capacity of your vehicles, not the utilized space on the
vehicles.

Volumes are specific to each major body type/configuration, and can be expressed in cubic feet or
twenty-foot equivalent units (TED).

The volume calculator worksheet for truck classes 2b through 7 follow the same format as the average
payload calculators, with various body type selections available.

Similar to payload data entry, you  may enter your calculated volume capacity information by selecting
the "Determined using company records" for the "Data Source" drop-down option within the Average
Capacity Volume Worksheet.

Alternatively, you may select default values for each body type by selecting the "Used defaults provided
by calculator" for the "Data Source" drop-down option.

Finally, if you need to use different sources of data to characterize different body types, select the "Other
- list all that apply" for the "Data Source" drop-down option within the calculator.

The volume calculator worksheet for classes 8a and 8b reflect a range of different, standard trailer and
container configurations.  Figure 52 shows an example worksheet for Class 8b vehicles.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 78

-------
  SmartWay Average Capacity Volume Worksheet
                                                                                                      BB1
   This worksheet will assist you in estimating the average capacity volume of your fleet. First provide data source information using the
   "Add/Edit" button. Next, select the appropriate reporting basis. After entering the information below, select "OK" to transfer the
   estimated volume to the Activity screen.
Truck Class:

   8b
Please indicate your data source and specify your reporting basis

                          (• Percent Usage

                          '" Number of Truckktads/Year

                          r Number of Trailers
                  Data Source:
                                                                              Percent Total

                                                                               Estimated Average
                                                                             Capacity Volume (cu ft):
        Box Trailers, Reefer, or Standard Flatbed

                                                       Tankers
                                                                    |     |
                                                                                       Chassis
28-foot

40-foot

42-foot

45-foot

48-foot

53-foot

57-foot

28+23

48+28

40+40

48+43

28+28+28
                    Box
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                     r
                             Reefer  Flatbed
                               r     r
              r
              r
              r
              r
              r
              r
              r
              r
              r
              r
              r
r
r
r
r
r
r
r
r
r
r
r
                             Large (7500+ gallons)

                             Medium (3001-7499)

                             Small (3000 & under)
                                       20-foot

                                       40-foot

                                       45-foot
                                                                            53-tbot
                                                      Bulk Carriers
Large (42'x 8. ?x 11.50

Medium (32'x 8'x 11')

Small (22'x 8'X 10,25')
                                                                                    Other Trailers
                                                                            Custom Size
                                                                            (Length x Width x Height)
                                                                                     ojft:
                                                      Auto Carriers
                                                Percent
                                                             Avg, # Vehicles
                                                                                f""1
                                                                                 Screen
                                                                                |  Demo

                         Figure 52: Screenshot of Average Capacity Volume Worksheet

First you must select the "Data Source" for your volume capacity data and then specify your reporting
basis from the three available choices (Percent Use, Number of Truckloads per year, Number of Trailers).
Next you will specify the relative distribution of your trailer/container sizes for your truck class as a
whole.

 If you select "Percent Usage" as your reporting basis, the values entered on this screen must sum to
100. A running total is provided on the upper right of the screen.

If you select "Box Trailers, Reefers, or Standard Flatbed" trailers, enter the appropriate number on the
left, and then specify which of these three categories you operate using  one or more of the checkboxes
to the right.

If you use "Other" trailer types not specified, include both the average volume of the trailers in cubic
feet under "Custom Size" (length x width x height), as well as the reporting basis value. "Other" trailers
include drop-deck flatbeds, low-boys, articulated/multi-trailers and any other configurations not listed
separately.
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 79

-------
Once complete, the estimated average volume weighted across all trailer/container types will be
displayed in the upper right of the screen in cubic feet. This value will be written to the Activity
Information screen for the specific truck class.

Make sure trailer/container type selections are consistent with the body types specified in the Payload
Calculator and Fleet Characterization screens; inconsistencies will be flagged during validation.

Once specified for each class, the fleet-average capacity volume will be calculated (weighted by the
number of miles per class) and displayed in the Overall Fleet column on the Activity Information screen.

STEPS FOR COMPLETING AVERAGE CAPACITY VOLUME (CUBIC FEET) WORKSHEET ON THE "ACTIVITY
INFORM A TION" SCREEN
                   Calc Volume
    1.  Select the »Bita*iUU«|  button to open the Capacity Volume Calculator screen.
    2.  Select  -         'to enter your data source for average capacity volume data.
    3.  Select one of the three reporting basis options using the radio check boxes.
    4.  Enter the requested metrics for the trailers, containers, tankers, bulk carrier, or other trailers
       used in this truck class.

    5.  Select  I  BJJB I to return to the Activity Information Screen.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 80

-------
PERCENT (%) CAPACITY UTILIZATION SECTION OVERVIEW ON THE "ACTIVITY

INFORMATION" SCREEN

Percent capacity utilization refers to the percentage of trailer capacity that is used for all hauls in a given
fleet.

Percent capacity utilization applies only to loaded (non-empty) miles. For most carriers, this will reflect
your loaded volumetric fill rate.

However, there are a few exceptions:
    •   LTL carriers should estimate the weighted-average fill rate over the span of operations.
    •   Flatbed haulers should estimate fill rate based on deck area covered.
    •   Auto carriers should estimate based on percent of car slots filled.
    •   Drayage operations may select the data source "Unknown to dray carriers - use industry average"
       option, in which case the industry average capacity utilization value will be auto-populated for
       you.
                ***Do not factor in empty miles for percent capacity utilization.
                                                                         ***
Once specified for each class, the fleet-average percent capacity utilization will be calculated (weighted
by the number of miles per class) and displayed in the Overall Fleet column.

STEPS FOR COMPLETING THE % CAPACITY UTILIZATION SECTION ON THE "ACTIVITY INFORMATION"
SCREEN
    1.  Next to the "% Capacity Utilization (excluding empty miles)" data entry box, click the ItilL
       button.  A Data Source Description box will appear.
    2.  Using the drop-down menus, select your data source and details and enter any comments about
       your data source.
    3.  Click  I  HH I to return to the Activity Information screen.
    4.  Enter your "% capacity utilization" for each truck class.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 81

-------
ROAD TYPE/SPEED CATEGORY SECTION OVERVIEW ON THE "ACTIVITY
INFORMATION" SCREEN

"Road Type/Speed Category" is a ratio of total mileage by class allocated to highway/rural driving, and to
urban driving less than 25 mph, 25-50 mph, and over 50 mph.

Data for completing this screen should be available from your vehicles' electronic control modules (ECM).

NOTE:  If you do not know your speed distribution for urban areas, you may check the box labeled
"Populate the urban driving fields with default values/' and default percentages will be calculated based
on data from EPA's MOVES model,8 adjusted for the Highway/Rural Driving percentage specified.

(For further details, see the Truck Carrier Tool Technical Documentation available at
http://www.epa.gov/smartway/forpartners/documents/trucks/tool-guide/420bl5002.pdf)

STEPS FOR COMPLETING THE ROAD TYPE/SPEED CATEGORY SECTION ON THE "ACTIVITY
INFORM A TION" SCREEN
    1.  Click |UUJ next to the data entry box next to "Road Type/Speed Categories." A Data Source
       Description box will appear.

    2.   Using the drop-down menus, select your data source and details and enter any comments about
       your data source.

    3.  Click  I  ••• I to return to the Activity Information screen.
                                  Enter Speeds
    4.  For each truck class, select  *"***"**"""*^ to open the ""Road Type/Speed Categories" box.

    5.  Enter the requested metrics for Highway or Rural Driving and Urban Driving for each of the
       speeds listed (if applicable). If you only know Highway or Rural driving, you can select the box
       next to "Populate the urban driving fields with default values" to complete the screen.
    6.  Click  I  Bm • to return to the Activity Information screen.
 NOx and PM emission rates for diesel, gasoline and E10 vehicles are obtained from EPA's MOVES 2014 emissions
model, expressed in grams/mile. Emission rates for LPG, CNG, and LNG are adjusted from gasoline values. Hybrid
vehicle emissions are set equal to their corresponding conventional gasoline and diesel counterparts, less the idle
emissions component. Finally, electric vehicle CO2, NOx and PM emission rates are based on national average
electricity generation unit estimates (in grams per kWhr). See the Truck Tool Technical Documentation for
additional details on emission rate estimation.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 82

-------
AVERAGE ANNUAL IDLE HOURS PER TRUCK SECTION OVERVIEW ON THE

"ACTIVITY INFORMATION" SCREEN

The Average Annual Idle Hours per Truck9 is calculated using the Idle Hours Calculator. To calculate
idling hours, you will need to enter the number of hours your trucks idle per truck per day on average,
along with the average number of days each truck is in service, on average, per year.

Figure 53 shows the Idle Hours Calculator screen.
 SmartWay Idle Hours Calculator
  Use this calculator to estimate your average annual idle time per truck.

  Enter the number of hours your trucks idle per truck per DAY on AVERAGE, along with the average number of days in service per
  truck. Specify both Long* and Rhi iri '  Duration idle hours, entering 0 if applicable.

  The calculated Average Annual Idle Hours per Truck will automatically populate the average idle hours fields in the "Activity
  Information" section of the main entry form.
              Daily Long
             Duration Idle
              Hours per
       Class     Truck*
        5   I        ~~^
 Daily Short
Duration Idle
 Hours per
  TruckA
Average Days in  Average Annual
  Service per    Idle Hours per
    Year         Truck
                                  °
       8a
                      °
    Long Duration includes overnight, or continuous For more than 15 minutes.
    Short Duration includes loading/unloading, traffic, waiting in line, or other, under 15 minutes.
                                                                                                 Page 44
                            Figure 53: Screenshot of Blank Idle Hours Calculator

Separate values should be input for short-duration (less than 15 consecutive minutes) and long-duration
(greater than 15 minutes) idling.10 After you have entered long and short duration idling hours and
  Idle hours are not applicable to hybrid or electric trucks, so the Idle Hour Calculator is not provided on those
screens.
10 NOx and PM emission rates are different for short and long-duration idling, reflecting the varying engine loads
and operating temperatures for these events.  The SmartWay emission calculations distinguish between these
events for Class 8b trucks using MOVES model outputs, although different emission factors may be integrated in
future versions of the model for all truck classes.
                                         Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 83

-------
average days in service for each truck class, and the calculator will present idle hours for each class will
be presented on the Activity Information screen.

 In addition, fleet-average idle hours across all truck classes are then calculated (weighted by vehicle
counts) and displayed in the Overall Fleet column.

STEPS FOR COMPLETING THE AVERAGE ANNUAL IDLE HOURS PER TRUCK SECTION ON THE
"ACTIVITY INFORMA TION" SCREEN
    1.  Select IIUUJ next to the data entry box next to "Average Annual Idle Hours per Truck." A Data
       Source Description box will appear.
    2.   Using the drop-down menus, select your data source and details and enter any comments about
       your data source.
    3.  Select  I   HHfl I to return to the Activity Information Screen.
                       Calculate Idle Hours Per Truck (AH Classes)
    4.  Select the <=                                           =*  button to open the Idle Hours
       Calculator.
    5.  Enter daily long-duration idling hours per truck, daily short-duration idle hours per truck, and
       average days in service per year for each vehicle class represented in this fleet.
    6.  Select  I   BjjH  I to return to the Activity Information Screen.

    7.  You have now completed the Activity Information Screen for this fuel type.
    8.  Select the •HSSfc |  button to verify that you have completed the screen properly.

    9.  After completing the Activity Information screen, if you are using PM reduction equipment select
       the PM Reduction tab at the top of the screen to proceed to the next section.
                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 84

-------
"PM REDUCTION" SCREEN OVERVIEW

The PM Reduction screen is for fleets that have installed retrofit equipment on pre-2007 engines. You
are provided with radio button to select the type of device (DOC, CCV, or PM trap) you have used for your
fleet. You are then asked to enter the number of trucks equipped with the device by engine (not vehicle)
model year.

To enter data for multiple devices, select the radio button for the next type of device after completing
data entry for the initial device, and fill out the new blank fields that appear.
 Truck: ABC Trucking, Inc.: Dry Van Fleet
 General Information
                              Gasoline
    Engine Model Year & Class
                          Activity Information
                                                PM Reduction
 Please enter the number of trucks in this fleet by class and engine (not vehicle) model year for which you are using each of the
 PM retrofit control strategies listed below.
     Diesel Oxidation
     Catalyst (DOC)
                         ?  • Diisei Oxidation Catalyst (DOC)]   (Not Used)

                        _?j r closed Crankcase Ventilation (CCV) (Not Used)

                         7 I '•  Participate Matter Trap        (Not Used)
                          Total
                         Trucks
                               L
PM Retrofits by Truck Class
                                       8b
   /Vote: Be sure to
   use E:\lOIiVE
   model year, not
   vehicle model
   year.
                                                                                              Screen
                                                                                              Demo
                                                                                                 Page 21
                              Figure 54: Diesel Vehicles PM Reduction Screen
Totals for any given model year cannot exceed the totals specified on the Engine Model Year & Class
screen. While CCVs may be installed in combination with either DOCs or PM traps, it is assumed that
DOC and PM trap applications are mutually exclusive.  As such, the sum of DOC and PM trap trucks
cannot exceed the totals specified on the Engine Model Year & Class screen.
                                        Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 85

-------
  STEPS FOR COMPLETING THE "PM REDUCTION" SCREEN

  1.  Select the radio button next to a device (DOC, CCV, or PM trap) you have used for your fleet.
  2.  Enter the number of trucks equipped with the device by engine (not vehicle) model year.
  3.  If other devices have been used with this fleet, select the radio box(es) next to each device and enter
     the number of trucks equipped with the device by engine  (not vehicle) model year.
  4.  When done, select
  5.  Select the
                        VALIDATE
                         SCREEN
                                   to make sure you have filled out everything properly on this screen.
                           button to return to the Home screen.
                                         Next Steps

          *** If you are using PM reduction equipment on model year 2006 or earlier trucks,
            select the PM Reduction tab at the top of the screen to proceed to this section.
                     Instructions for data entry are provided above this box.  ***

If you have finished entering data for this fuel type, select the tab for the next fuel type and complete all
screens as indicated above.
                                                                           button to return to
If you have finished inputting data for all of your fuel types, select the
the Home screen.

                                        REMEMBER:

                      *** If additional fuel types are represented in this fleet,
  you must complete the Engine Model Year & Class and Activity Information screens for each of the fuel
                                      types you operate.

Select the tab for the next fuel type and complete the Engine Model Year & Class and Activity Information
screens as indicated above—the steps will be the same or similar to those for the Diesel Tab. Do NOT move
on if you have not completed the data input for each of your fuel types. ***
Once finished entering data for all of your fuel types, select the
screen and follow the instructions to submit your tool to EPA.
                                                                   button to return to the Home
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 86

-------
Validating Your Data
The Truck Carrier Tool has validation checks embedded at different points in the Tool to ensure data
quality. For example, checks on total mileage or number of vehicles are made before exiting the Payload
and Volume Calculators. However, additional validation checks are made before exiting other data entry
screens throughout the Tool. Critical checks are made regarding calculated miles per gallon (by class),
reefer fuel consumption, annual miles per truck, and a number of other inputs, to help ensure the
reasonableness and quality of Partner data.

 In most instances the validation ranges are based on Truck Partner data distributions from the 2011
calendar year. (Refer to the Truck Carrier Tool Technical Documentation (found on the website at
http://www.epa.gov/smartway/forpartners/documents/trucks/tool-guide/420bl5002.pdf) for a detailed
discussion of all validation criteria used within the Tool.)
                              VALIDATE
                               SCREEN
At any time, you can select the '           '  button at the bottom of the screens to make sure you have
filled out everything properly before proceeding to the next screen.

Any time you leave a particular screen, the Tool will automatically perform a screen validation.

Any time you return to the Home screen, the Tool will automatically perform a fleet-level validation.
 If you select the
                  VALIDATE
                   SCREEN
button and no potential errors are identified, the following message will
be displayed. Select OK to proceed.
                                  SmartWay Validation Check  |X
                                   No errors found on this screen.
                                              OK
                          Figure 55: Validation Check Notification - No Errors
If missing or potentially erroneous inputs are identified, you will see the following message (Figure 56).

Select Yes to see a complete list of validation errors/warnings. An example Validation Check results
screen is provided in Figure 57.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 87

-------
    Smart Way - Error
            There are errors and/or warnings on this screen that have been highlighted for your attention, Red indicates errors (which must be addressed);
            yellow indicates warnings,

            NOTE: If you are confident that the information you have provided is correctj double-click on the highlighted field and provide text explaining the
            reasons for the out-of-range value, Doing so will cause the error to be changed to a yellow-flagged warning instead,

            Do you want to see a list describing the problems with these items?
                                                  Yes
                         Figure 56: Validation Check Notification -with Errors/Warnings
  SmartWay Validation
     Below are the errors/warnings that have been detected.
      - Errors must be addressed before you can submit your data.
      - Warnings should be reviewed but will not prevent you from submitting your data.
     ERROR [Diesel - Activity Information]: For Empty Miles Driven under truck class 6, your value 3,001,584 is substantially
     above industry averages (1,602,886). NOTE: If you are confident that the information you have provided is correct,
     double-click on the highlighted field and provide text explaining the reasons for the out-of-range value,  Doing so will
     cause the error to be changed to a yellow-flagged warning instead.

     WARNING [Diesel - Activity Information]: For MPG under truck class 8b, your value (4.8) is below typical industry
     averages (5.0 - 6,6), If your MPG values accurately reflect above average performance for your fleet, please provide
     text describing the reasons for your excellent fuel efficiency,  Otherwise please review your mileage and fuel estimates
     and modify your inputs as needed.

     ERROR [Diesel - Activity Information]: For % Capacity Utilization, the field under class 8b is blank.
             Why can't I make corrections?
       Show my errors/warnings as a spreadsheet.
                              Figure 57: Validation Check Screen - Example Results
The
               Why can't I make corrections?
land
         Show my errors/warnings as a spreadsheet.
buttons at the bottom of this screen provide additional information to assist you in correcting any errors.
Specific information is also provided regarding any values that are unusually high or low compared to
industry averages (e.g., see the second entry). In this case, three possible data entry problems were
identified for correction: one involving a suspiciously high "average empty miles per year" value, one for
                                            Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 88

-------
a low MPG value, and one for a missing value. Two of the three messages involve errors that must be
addressed through modification of the data entry (message #3), or by providing a text justification of the
value by double-clicking on the highlighted cell (message #1).  Both of these items must be addressed
before the Tool may be submitted to EPA. The remaining item (#2) is listed as a warning, and does not
have to be addressed before submittal to EPA, although you may provide documentation for this value by
double-clicking on this cell if you wish.

Once you  close the Validation check screen, you will see warnings and errors highlighted in a  red or
yellow on the Activity Information screen, as shown in  Figure 58.  Entering new data in a highlighted cell
will cause the colored shading to disappear, even if the new value is  still invalid.  To check the validity of
your newly entered data, select the
as necessary.
                                         VALIDATE
                                          SCREEN
'button again and repeat the procedure described above
 Truck: ABC Trucking, Inc.: Dry Van Fleet
  General Information
                                 Gasoline
                                                              LNG
                                                                           CNG
                                                                                                     Hybrid
    Engine Model Year & Class
                            Activity Information
                                                     PM Reduction
  Select the "Add" buttons to identify your data sources. (After specifying your data sources, the button will read "Edit"; you may select "Edit" to make
  changes as needed.) In the "By Truck Class" columns, enter your data for each truck class (only those classes selected on the "Engine Model Vear & Class"
  tab appear below). The "Overall Fleet" column will automatically display fleet-level information based on the data you enter for your truck classes.
            Diesel
                                     Overall Fleet & Data Source
                                     Overall Fleet  ?   Data Source ?
    Total Miles Driven (exact values)
    Revenue Miles Driven (exact values)
    Empty Miles Driven (exact values)
  •/ I Gallons of Diesel Used, incl. Biodiesel & Reefer
  -^J (exact ^
        I values)
      Refrigeration Unit Fuel Consumption
  J?J Gallons of Biodiesel (B100 Equivalents)
  7 I Average Payload (tons) - Cargo Weight Only            17.3


  2] Average Capacity Volume (cubic Feet)


  J?J  Capacity Utilization (excluding empty miles)
_?J Road Type / Speed Categories                       | Collected   BffJ [47/39/14/0*
 * Indicates that default speed distributions were selected for urban road types.

 ? Average Annual Idle Hours per Truck
                                                                         10/8/2/80*
                                           1,221| ECM
   "mil
                                                                Calculate Idle Hours Per Truck (All Classes)
                                                                                                      Screen
                                                                                                       Demo
                                                                                                         Page 20
                            Figure 58: Validation Check- Highlighted Activity Screen
Follow these steps to check the different types of validation warnings/errors.

    •    First ensure that any highlighted blank cells are completed and that all standard range checks are
         satisfied (e.g., all percentages must be between 0 and 100, etc.).

                                            Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 89

-------
•   If "Total Miles Driven" entries are highlighted for any truck class, this means that the expected
    annual miles per truck have been exceeded. Calculated annual mileage values are shown on the
    Activity Information screen below the calculated  MPG values.  You may revise these values by
    adjusting either "Total Miles Driven" OR the "Total Trucks" (on the Engine Model Year & Class
    screen). Unless the calculated mileage value is greater than the absolute maximum allowed, you
    may leave these values as they are, and simply enter a text explanation (for "red" warning
    values). In this case your fleet will be flagged "Complete with Warnings" on the Home screen.

•   If "Revenue Miles" or "Empty Miles" are highlighted, check their values relative to "Total Miles
    Driven" and to one another.  For example, explanations are generally required if "Revenue Miles"
    are roughly less than 50% of "Total Miles Driven," or if "Empty  Miles" are greater than
    approximately 50% of "Total Miles Driven", although specific validation cutoffs vary depending
    upon truck class, body type and operational category.

•   If reefer fuel  consumption is flagged, confirm the ratio of reefer gallons to total fuel consumption
    are accurate for your fleet.

•   "% Capacity Utilization" values of less than ~40-70% must be explained.

•   "Average Idle Hours per Truck" outside typical partner values must be explained.

•   If any calculated MPG values are highlighted, you  may revise these values  by changing either
    "Total Miles Driven" or the number of gallons of the fuel type used. You may also double-click on
    the highlighted MPG cell to obtain a popup screen with additional information, as shown in
    Figure 59.  This form presents the expected MPG range based on typical SmartWay Partner
    performance, as well as the calculated value for your truck class, and the "Severity" of the error
    identified.  (Level 1 Severity indicates the value is significantly different from partner averages,
    while Level 2 Severity indicates a moderately out of range value.) If you believe this value is
    accurate, enter a brief summary in the text box explaining the reasons for the high/low MPG
    value and select OK to return to the Activity Information screen. (In this case your fleet will be
    flagged "Complete with Warnings" on the Home screen.) Otherwise select CANCEL to revise your
    total  miles and/or gallons used.

•   If payload, volume, and/or idle hour values are highlighted on the Activity screen, warnings
    and/or explanations can be viewed by opening the appropriate calculator(s).

•   Possible rounding errors for miles and/or gallons are not highlighted on the Activity screen  but
    are described in the detailed Validation list popup screen.
                                  Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 90

-------
         Smart Way Range Validation Form
           Data you provided is outside the expected range. If you are confident that the information
           you entered is correct, please provide supporting details in the space below. Otherwise, select
           Cancel to return to the form, so you may re-enter a new value for this field.
           Field Name:
                              Class 8b mpg
           Out of
           Range
           Message:
WARMING [Diesel - Activity Information]: For MPG under truck class 8b, your value (4.8) is
below typical industry averages (5.0 - 6.6). If your MPG values accurately reflect above
average performance for your fleet, please provide text describing the reasons for your
excellent fuel efficiency. Otherwise please review your mileage and fuel estimates and
modify your inputs as needed.
           Value Vou Provided:  4.u
           Severity of Error:

           Explanation:
           Level 2*
           * Level 1 indicates that the value is significantly out oF expected range. Level 2 indicates that the value is moderately out oFexpected range.
                     Figure 59: Validation Check- Example MPG Range Validation Form
Other checks are made regarding absolute minimum and maximum inputs for miles per truck, MPG,
payload, volume, and idle hours, as well as checks regarding implicit cargo density based on payload,
volume, and capacity utilization inputs. When absolute minimum or maximum values are exceeded, the
Partner must revise the associated input values before proceeding (i.e., these values cannot be
"explained away").

The Truck Carrier Tool also utilizes a number of "logical" validation checks to ensure the reasonableness
of various inputs and category selections. For example, checks are applied regarding the consistency
between body types specified in the Fleet Characterization section and those selected in the payload and
volume calculators. If inconsistencies are found, in most instances a simple warning is indicated, and text
explanations are not required.  For a complete listing of all validation checks used in the Tool, refer to the
Truck Carrier Tool Technical Documentation.
Once all potential validation errors have been corrected or otherwise verified, select
proceed to the next step.
                                         Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 91

-------
Once you have returned to the Home screen, notice that the fleet that you filled out and validated now
identifies its status as "Complete." You may now highlight the next fleet if you have another one to
complete.  In the example below, the fleet listed as "Example Dray Fleet" remains to be finished. Fill out
unfinished fleets in the same manner as the previous fleet.
  SftiartWay Truck: Home
           SmartWay
Report Year
    2014
           Truck
United States Version: 2.0.14
    Released on: 1/7/2015
    Please complete the following steps. Check boxes on the left indicate successful completion of each step. For more
    information, select the 'Help' button.
        1. Enter Partner Name  (Exact!/ as it should appear on the SmartWay website):
          ABC Trucking, Inc.
                   Enter Contact Information
                    Characterize your Fleets
        4. Select Fleet for Data Entry   (Double-click the fleet name or select and hit Enter):
        5.
           ..       ........i.••......15.Q.".J!=£JL: - : jig:.t.:;,;.;;;• '.•'•.
           ABC Trucking, Inc.: Dray Fleet • Incomplete (Errors)
                Review Year-to-Year Comparison
             Partner Profile / Logo Info / Suggestions
                   View Your Data Reports
                 Generate File to Send to EPA
           * After selecting this option, be sure to carefully read atdirections before proceeding.
                                                                  Updated fleet
                                                                 status indicator
                                                                                                    Page T-8
          Figure 60: Home Screen - After Completing the Data Entry/Modification Process for First Fleet
Once you have filled out information for all your fleets, be sure that all fleets show "Complete" or
"Complete with Warnings" beside the name. If, and only if, all fleets are marked as such, you can move
on to the next step. If one or more fleets are not marked as such, review the data you entered for errors
or omissions.
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 92

-------
Viewing Year-to-Year Comparison
The Year-to-Year Comparison Report allows the user to compare the fleet characteristics and activity
values, as well as CO2 performance metrics for the current reporting year with the previous year. This
report is particularly helpful in identifying any changes that may have occurred since your last reporting
period, determining trends in activity and performance over multiple years, and performing general
quality assurance of the inputs used for your current Tool. You can access this report by selecting
         Review Year-to-Year Comparison
                                                  under item #5 on the Home screen.
Figure 61 shows the data entry screen for the comparison report. Note that your most recent year's data
is already "loaded," including the data you have entered for your current fleet(s). In order to load data
                                    Load Data
for the previous year fleets, select the
the location of your prior year file, using the
                                         Browse—
button. A screen will appear allowing you to specify

    button as shown in Figure 62.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 93

-------
SmartWay Truck Year-to-Year Comparison
 In order to run a comparison report, you must have a completed Truck Tool from the previous year.
 Select the "Load Data" button to import the data from the prior year's tool that you would like to compare into this
 Tool.
 Next, choose the units in which you would like the fuel-related components of the report to  be expressed.
 Choose whether you would like to see the comparison at the Partner (Company) level or the fleet level. If you
 choose the fleet level, select the fleet(s) from each list that you would like to  compare. (Note that the report will
 combine all of the selected fleets from each list.)
 Final!/, select RUN REPORT to generate the report.
   1. Load Data from Prior Year
2. Select Units for Displaying Fuel-Related Information:
       Year 1:   2014
       Year 2:   2013
                                                    Display Fuel in:
                           Load Data
                     Actual U.S. Gallons
                                                                     Diesel Gallon Equivalents
                                                                    ..!5.a..iiQjJn.s..S.a.|.!.on.E.£i!Lijyalents.	
   3. Choose Comparison Level:
       (*" Partner-Level
       C Fleet-Level
          Select a fleet from each of the lists below that you v.'ould like to compare. You may choose multiple fleets/
          divisions from each list, but the comparison report will combine all of the selected fleets from each list.
           Fleets for Yea rl:
          Fleets for Year 2:
                                                                                                   Page T-49
                           Figure 61: Year-to-Year Comparison Report Input Screen
                                          Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 94

-------
  SmartWay: Load Data
   Use the Browse button to navigate to your 2013 Truck Tool file.  Select LOAD to import that data into
   this Tool.

   NOTE: If you experience problems while attempting to load a prior year Truck Tool, please take note of any error
        messages and then contact a PAM or the SmartWay Helpline at; (734) Z14-4767.
   Year
12013
   Truck Tool:
                                                                                     Browse,.
                     Figure 62: Data Load Screen for Year-to-Year Comparison Report
Once your prior year data loaded into the Truck Carrier Tool, you should specify how to display your fuel
information: in diesel gallon equivalents, gasoline gallon equivalents, or simply in actual U.S. gallons.
Specifying diesel or gasoline gallon equivalents is useful for comparing miles per gallon metrics when a
fleet contains multiple fuel types.

Next you can specify whether you want to compare one or more individual fleets (select "Fleet-Level") or
if instead the comparison should aggregate all fleets (select "Company-Level"). Once specified, select the
"RUN REPORT" button to view the  line-item data entry comparisons.  An example report is presented in
Figure 63.
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 95

-------
        •SmartWay
IComparison Report  [Reporting Years: 2011 & 2010
Tool: Truck         Partner: ABC Trucking
Display Option:	Fleeti'Division-Level Comparison
December 21, 2011

FleetOvision Name(s)
Primary Contact(s)
Contact Phone(s)
SCAC(s)
MCN(s)
Fleet Type(s)
Operation 1 Body Type
Operation Type
Body Type
Commodities
Average Cube Out
Miles Per Gallon (DGE)'
Miles Per Truck
Average Payload (tons)
Average Volume (cu Ft)
Average Capacitu Utilization
Percent Highway Driuing
Percent Urban Driving (0-25)
Percent Urban Driving (25-50)
Percent Urban Driving (50«)
Average Idle Hours Per Truck
Total Trucks
Class 2b
Class 3
Class 4
Class 5
Class 6
Class?
Class 3a
Class 3b
Total Miles Driven
Revenue Miles Driven
Empty Miles Driven
Total Gallons of Fuel (DGE)'
Diesel (DGE)'
Biodiesel(DGE)'
Gasoline (DGE)'
Ethanol (DGE)'
Other (DGE)'
Tons of COi
COi gfmile
COj gKon-mile
COS gMOOO cuft-mile
COj grfutilized 1000 cuft-mile
Change
V.










•7.054
4.854
•14.254
•4.854
•4.854
-1.554

-4.154

22.354
-0.4K
4.2X
0.0/i
100.0K
O.OX
50.0K



-1SSK
-10.6X
-13.4X
8.9/i
•14.7X
•15.3X

30.1K
30.154
•7.854
•14.754
-4.6X

B.3K
2.3X
Change
Amount









X
-ex
0.27
-14.351
-0.9
-119
J54

-1X

154
-5
3
0
5
0
2



-4
-772,500
-854,500
32,000
-137,369
-136,638

2,504
140
•3.344
-2,097
-32

2
19
2011
ABC Trucking: North America
Cookie Monster
(555)555-5555
COOK
#555555
For-Hire
Drayage/ Mixed
TL(1054) 1 LTL(IOX) 1 Drayage(80x)
DryVan(35K) 1 Reefer(15K) 1 ChassisjSOX)
Cereal Grains; Milled Grain and Bakery
Products; Other Prepared Foodstuffs;
Refrigerated Food and Frozen Food; Miced
Freiaht
30^
5.93
86,933
17.1
2,310
83K
74*
CM
11K
»,•/.
1,191
75
2
10
4
6
-
-

53
6.520.000
5,515.000
1,005,000
1,090,236
1,033,332

10,830
604
45,470
12,127
1.6S7
99
730
830
2010
ABC Trucking: Worth America
Cookie Monster
(555) 555-5555
COOK
#555555
For-Hire
Drayage i Mined
TL(1054) 1 LTL(10X) 1 Drayage(30K)
DryVan(35K) 1 Reefer(15x) 1 Chassis(50x)
Cereal Grains; Milled Grain and Bakery
Products; Other Prepared Foodstuffs;
Refrigerated Food and Frozen Food
66X
5.71
101,235
18.0
2,429
89X
74K
m
\\y.
3x
1,196
72
2
5
4
4



57
7,292.500
6,369,500
923,000
1,278,104
1,220,000

8,327
464
49,314
14,224
1.763
93
729
811
' Diesel Gallon Equivalents
                   Figure 63: Example Year-to-Year Comparison Report
                               Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 96

-------
The example above indicates that a change in commodities has occurred over a year, with no other
changes in basic contact and fleet characteristic information.  Comparisons are also shown for a number
of activity parameters including:

    •  average payload
    •  average volume
    •  average capacity utilization
    •  percent driving by road type and speed bin
    •  average idle hours per truck
    •  number of trucks by class
    •  total, revenue, and empty miles driven
    •  total gallons of fuel used (in this case, in diesel gallon  equivalents (DGE))


A variety of calculated annual performance metrics are also shown, including:

    •  miles per gallon (here, in diesel gallon equivalents)
    •  miles per truck
    •  tons of CO2
    •  grams CO2 per mile
    •  grams CO2 per ton-mile
    •  grams CO2 per 1,000 cubic foot-miles
    •  grams CO2 per utilized 1,000 cubic foot-miles


Percentage changes are also indicated for each of these items, relative to the earlier year baseline values.
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 97

-------
Providing Additional Information
After completing Steps 1 - 4 on the Home screen, you may provide EPA with additional information
regarding your company, potential use of the SmartWay Logo, and general feedback regarding the
SmartWay program.  This information is optional and is not required in order to submit your Truck Carrier
Tool data to EPA.  Selecting the
                                   Partner Profile / Logo Info / Suggestions
jutton on the Home screen
will open the Partner Information form (see Figure 64).
 SmartWay Additional InformationABC Trucking, Inc.
       Partner Information
                               Logo Qualification
                                                        Suggestions
  Providing your information on THIS PAGE is OPTIONAL. SmartWay will use the information you submit via this page to make a PUBLIC partner company
  page on the SmartWay website. Please limit your responses to the specific questions asked as SmartWay will review your submission for appropriateness.
  SmartWay will not edit the data for spelling or grammar so please make sure it appears below EXACTLY as you want it displayed.
   Partner Name: ABC Trucking, Inc.
    Link to your company's environmental or SmartWay web page:
      http://
    Executive Officer's quote on your SmartWay participation: (500 characters max)
    Description of your best investment in emissions or fuel saving technology: (3000 characters max)
    Goal for SmartWay participation: (3000 characters max)
    My company encourages other companies to join SmartWay to improve their efficiency by: (1000 characters max)
                                                                                                 Page 49
                                  Figure 64: Partner Information Screen
Use this page to provide information you would like to share publicly. Information should be entered in
the text boxes displayed. Use the scroll bar to the right to display additional questions. SmartWay will
use this information to create a SmartWay Partner profile page for your company on the SmartWay
website. You do not need to complete every question.  SmartWay will NOT edit for spelling or grammar,
so make sure the text is exactly as you wish it to appear.  If your company contains public relations
functions, you may want them to review this information before submittal, however, keep your
SmartWay due date in mind. SmartWay WILL review this data for appropriate content. Information
provided should be informational in nature, and speak to the question.

Figure 65 shows the Logo Qualification screen. The SmartWay Partner Logo is provided at the company
level to Partners in good standing in the SmartWay program. To be in good standing you must submit
                                        Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 98

-------
your SmartWay materials by the appropriate due date.  Due dates are posted on the EPA website at
epa.gov/smartway.. Tractor and Trailer Logos require the approval of the SmartWay Brand Manager
(Jackson-Stephens.ioann@epa.gov).  Tractor and trailer logos may be placed directly on your equipment
to display your fleet's qualification.  Use this screen to provide  information regarding your qualification
for, and planned use of, the Partner, Truck and Trailer Logos.  Use the scroll bars to display more
questions and input fields.  Additional information on Logo qualification and use can be found by
                  SmartWay Partner Logo Information
selecting the

 View the SmartWav Designated Trailer specifications
hllttnn nr thp View the SmartWav Designated Tractor specifications  anfj
                                       links.
  SmartWay Additional Information: ABC Trucking, Inc.
         Partner Information
    The SmartWay Partner Logo is available to all Partners in good standing within the SmartWay program. To be in good standing you must submit your
    SmartWay materials by the appropriate due date.  Due dates are posted on the SmartWay website at epa.gov/smartway. The SmartWay Logo use
    guidelines and Logo graphic files are accessible online - please select the button below for information.
     Partner Name: ABC Trucking, Inc.
    SmartWay Partnership Logo

     P I have read the SmartWay Logo Use Guidelines webpage.

     l~ I have read the SmartWay Logo Graphics Standards and Usage Guide (on webpage).

     P I agree to abide by SmartWay's logo use guidelines should I earn the right to use the SmartWay Partner Logo.


    If I qualify for the SmartWay Partner Logo, I intend to use it on the following: (does not constitute a commitment to actually do it)

     r My website

     P Marketing materials
    SmartWay TRACTOR Logo

     View the SmartWav Designated Tractor specifications

   j— If my tractors meet the SmartWav designated specifications, send me the digital TRACTOR
     Logo files.
   p If my tractors meet the SmartWay designated specifications, I agree to SmartWay's
     TRACTOR Logo use guidelines (on web page).

   P I intend to use the SmartWay Truck Logo on my tractors.

          ~~ Based on the guidelines, I intend to use the TRACTOR Logo on this number of
            eligible tractors.
              SmartWay TRAILER Logo

                 yigw_ths_SrnartW3v Designated Trailer specifications

               r— If my trailers meet the SmartWay designated specifications, send me the digital TRAILER
                 Logo files.
               r— If my trailers meet the SmartWay designated specifications, I agree to SmartWay's TRAILER
                 Logo use guidelines (on web page),

               P I intend to use the SmartWay Truck Logo on my trailers.

                     ~ Based on the guidelines, I intend to use the TRAILER Logo on this number of
                       eligible tractors.
                                                                                                      Screen
                                                                                                       Demo
                                                                                                                      PageT-54
                                            Figure 65: Logo Qualification Screen
                                                  Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 99

-------
Figure 66 displays the Suggestions screen. You may respond to some or all of these questions in order to
provide feedback regarding the various aspects of the SmartWay program.  SmartWay values your
feedback. Any information you provide will be used to improve the program, and will be kept
confidential.  Use the scroll bar to the right to display additional questions.
 SmartWay Additional Information ABC Trucking, Inc.
        Partner Information
                                    Logo Qualification
                                                                 Suggestions
   OPTIONAL SMARTWAY SATISFACTION AND FEEDBACK SURVEY
    We are always trying to improve the SmartWay program and provide better service to our partners. By filling out this optional survey, you can help us improve the
    program. Thank you,

    Partner Name: ABC Trucking, Inc.
     Please answer Yes or No
       Do you read the Tool User Guides?
       Do you read the Tool Technical Documentation?
       Do you regularly visit the SmartWay website?

     On a scale of 1 to 10, 10 being the best:
       How do you rate the SmartWay Tool?
       How do you rate the SmartWay User Guide?
       How do you rate the SmartWay Technical Document?
       How do you rate the SmartWay Website?
       How do you rate SmartWay support materials?

     On a scale of 1 to 10, 10 meaning strongly agree:
       I understand the goals of the SmartWay program
       I understand how to participate in the program
       I understand and know how to find information on the SmartWay website
       I understand the SmartWay Tools
       I understand the SmartWay emission factor  ranking system
       I understand the SmartWay Partnership logo guidelines
Yes
 r
 r
 r
No
r
r
r
                                                                                                                Page 51
                                            Figure 66: Suggestions Screen
Once you have completed these three screens, select the
screen.
                              button to return to the Home
                                             Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 100

-------
Viewing Reports
Once you are ready to continue, select

the following screen:
                                                            View Your Data Reports
                                                                                     to go to
 SmartWay Reports
    Internal Metrics Report
    Fleet Cha ra ct eriza tion
         Report
                    Please select the report you would like to view.

Estimates the C02r NQx, and PM emissions for your
fleets. You can view these estimates based on truck
class, fuel type, or fleet.
Port Drax Program
    Report
     Truck Counts Report
     Activity Information
         Report
        Reefer Fuel
     Consumption Report
     PM Reduction Report
Displays all of the data you entered in the Fleet
Characterization section.
                     Displays all of the data you entered in the General
                     Information section.
                     Displays all of the data you entered in the Engine
                     Model & Year section.
Displays all of the data you entered in the Activity
Information section.
Dispbys all of the data you entered in the Reefer
Fuel screen in the Activity Info section.
                     Displays all of the data you entered in the PM
                     Reduction section.
Comments Report
                                        Out of Ra ng e Report
                                                              Data Source Report
  US/Can
Operations Report
If you elected to participate in the Port Dray
Program, ths option will allow you to print out a
summary of your inputs and results.
                Dteprays all of the comments that have been entered
                throughout the Tool.
                                                         Displays all of the values throughout the Tool that
                                                         were not within the expected range.
                                                         Displays all of the data source information you
                                                         provided throughout the Tool.
                Dispbysthe partner information, logo qualification
                and suggestions you provided in Step 6.
Displays all of the data you entered in the US /
Canadian Operations section.
                                                                                                            PageT-50
                                           Figure 67: View Reports Menu
Selecting any of the green buttons on this screen will display the indicated data.  Several reports

summarize the data you entered on specific data input screens, such as the Truck Counts Report

(corresponding to the Engine Model Year & Class screen) and the Activity Information Report

(corresponding to the Activity Information screen).  The Out  of Range Report may be particularly useful

in identifying and addressing those inputs flagged as potentially erroneous during fleet validation.


Select the Internal Metrics Report button to review the performance of your fleets in terms of grams per

mile and grams per ton-mile,  by pollutant type. After selecting this button you will be asked to  specify

the level of detail/aggregation you wish to display as shown in Figure 68.
                                            Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 101

-------
 Smart Way Reports
              Select the level of detail you wish to display
               S" Display only totals
               f~ Display details for each Fleet
               f Display details for each Truck Class
               f~ Display details for each Fleet and Truck Class combination
               <~ Display details for each Fuel Type
               f~ Display details for each Fleet and Fuel Type combination
                                                                                                  Page 47
                             Figure 68: Internal Metrics Report Selection Menu

Selecting any of the summary report types will take you to a screen allowing you to preview and print
your reports. Figure 69 shows one of many sample reports that the Tool can generate for you; in this
case summarizing emission reductions in tons and assorted performance metrics at the Partner Total
level (including all fleets). These reports will prove useful for your company's evaluation and
improvement efforts.
                                        Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 102

-------
       'SmartWay
MMMIMMI
Tool: True*
atpay option *1: Totals Onty
fb port Year: 2013
Partner: A EC Truer, infl. me
CCS
TOMTOM
T::a vii-K
OrmB perM lie
(Total
Grams, per
Awns* Pay b ad
Tor.Mlle
(Total)
Oorn&pw
nwuMnd Cubic
rj.^a(l
:• m par
T h^L'S-SH-d L*fll1s3
Cub It FooUM IfrS
(Total)
-•:sctc V -»s
Grans perM l»
Orami t*r
-.-r;;: =;T :::
F.:ot4W.bi
: T - s iw
rt.:.ts-sc JtiBMC
->,rv^' .: V K
OornsperMlifr
Otvni oar
Avsras* ?^ lose
Tar-flU
Grans p*r
ThoLS-ar: Ittt
CtVfrl& p«^MIt»
'sntT&a 5Ji=C 1CS3 117 3B3 SS 1367 1J6 TCI SOI llii 1SC 541 "5
HOI
l-'WII»
(To.*
: loss
Grvns per
TmnMUtaM
(Totan
T::a ', M
Grins perM lie
(Total
Orvns par
Awn^s Pay b -ad
TOR-Mlto
Onmspar
ThoLnrrf CublD
FOflUMIte
(Tfft*
Grams per
T IKJUMIKI UUIIaK)
Coble Foo 1*1 in
(TotaQ
_-:3c*: V ^:
Grans »rHlft
lLamiHB
Orarns 194 r
Toi^Mifr
!:-; - s :; r
T»ots«d afrta
i^-oaii«i^
Qams pw
Tt oisa-J UHzod
g-oaUfl
'I ' -I :
...: sc« V a :
Grans »r*,e
OT3RS : : :
T C-i-M !ft
-. ;K K
Orams p#r
FWUI..K
C«feltFOOl4HK
-•-v»-i; ', K
OHFTISPWMH*
j r?~s par
A>BTiC*P«lMd
ToMHto
Orrns p*r
ThaiJS-srcCLbfc.
Oivnspar

^^tTL*_H!l«
Onmsp*rM!t*
Oorns- par
A vwa^* P-v iMd
TotvJMIa
Oraris pa>r
i; *«r isi
':-?-;:;-
Tt-jLHr: _:iu=-
Ctbis P=oMWII«
                                                   Figure 69: Example of Completed Report

-------
Submitting Data  to SmartWay
Congratulations! You are now ready to send your data to EPA.
Select the
                Generate File to Send to EPA*
                  I button, which will open the following screen.
 Create submission file for EPA
         SmartWay*
Report Year
    2014
           Truck
United States Version: 2.0.14
    Released on: 1/7/2015
  By checking the box below, I declare that the information submitted via this Tool is, to the best of my knowledge, accurate. I understand
  that any person who, in the course of negotiating or performing under this Agreement, makes, presents or submits a false or misleading
  statement to the government, or any person who makes a material omission in the course of negotiating or performing under this
  Agreement, may be subject to liability under all applicable civil and criminal statutes including 18 U.S.C. 1001 (criminal liability for false
  statements), 31 U.S.C. 3801 -  3812 (civil liability for false statements) and 31 U.S.C. 3729-33 (The False Claims Act).

                            P I understand and agree to the terms of this agreement.
                                                                                            PageT-56
                               Figure 70: Creating Submission File for EPA
Select the checkbox to indicate you understand the terms of the SmartWay Partnership Agreement once
again. Next, a question will appear asking if you are an existing SmartWay Partner (Y/N).  If you are, a
question will appear asking if you submitted your data the previous reporting year.  If you have ever been
a SmartWay Partner you you can enter your Annual Submission ID, which has been  sent to you by your
SmartWay PAM via email.  If you cannot locate your submission ID  you can select the Email me my
SmartWay ID button to have your ID sent to you.  Submission of the SmartWay ID is optional.

-------
 Create submission file for EPA
           SmartWay9
Report Year
     2014
             Truck
United States Version: 2.0.14
     Released on: 1/7/2015
  By checking the box below, I declare that the information submitted via this Tool is, to the best of my knowledge, accurate. I understand
  that any person who. In the course of negotiating or performing under this Agreement, makes, presents or submits a false or misleading
  statement to the government, or any person who makes a material omission in the course of negotiating or performing under this
  Agreement, may be subject to liability under all applicable civil and criminal statutes including 18  U.S.C. 1001 (criminal liability for false
  statements), 31 U.S.C. 3801 - 3812 (civil liability for false statements) and 31 U.S.C. 3729-33 (The False Claims Act).

                                B* I understand and agree to the terms of this agreement.


  Please answer the question that appears below. Depending on your answer(s), additional questions may appear that also requires an answer. Your answers
  will allow EPA to better process your submission.
                                           Yes
          Are you an existing Partner in SmartWay?     <•'

                  Did you submit data last year?     ff
                                                                                         No
                                                                                         r
       Please enter your SmartWay ID that your PAM sent you in an email.  If you do not have your SmartWay ID and you           —p
       were either the designated Working Contact or Executive Contact in last year's submission, you can use the link below  I  NB34KD98]
       to have your SmartWay ID emailed to you.
           Email me my SmartWay ID
  You are now ready to create your .xml file. The tool will also automatically save your .xls file at: C:\Users\Owner\Downloads\2014-ll-25_Tnjck-cleanjcls unless
  you designate another location.
                                                                                                         PageT-56
                                   Figure 71: Completed Submission File Screen

When ready, select NEXT to create a file with the following naming convention:

Truck_PartnerName_Year_ VO.xml n

For example, Truck_ABCompany_ 2014 _VO.xml

where PartnerName is your company's name as entered for Step 1 on the Home screen, and Year
indicates the year for which you are submitting your data.

Next specify the folder where you would like to save the. xml file, and the following screen will appear.
11
   If you create the XML file multiple times the file name will increment each time (e.g., Truck_ABCompany_2014_V1.XMLfor the
second iteration, etc.
                                            Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 105

-------
  SmartWay - Instructions for Submitting File
             •SmartWay8
               Truck
United States Version: 2.0.14
     Released on: 1/7/2015
   CONGRATULATIONS!  Your SmartWay submission files are now located at:

   Excel File
    C:\Users\Qwner\Documents\Truck_ABC Trucking, Inc_2014_VO.xls
   XML File
   |C:\U-sers\Owner\Documents\Truck_ABC Trucking, Inc_2014_VO.XML


   The .xls file is the file that you can view in MS Excel to look at your data reports, or view year-to-year comparison, etc.
   Please make sure you keep this file in a safe place within your company so that you may refer to it when you complete
   your SmartWay submission next year.

   The .xml file is a file that copies JUST the data you input into the tool into a much smaller file. If you open this file it will
   look like a big string of data and will not be useful for your own viewing. SmartWay created this function because some
   partners had mailbox size limitations and thus couldn't mail the large .xls Excel file.

   If you can, please email both files to SmartWay.  If your mailbox can't send the .xls file, you may send the .xml data file
   only. YOUMUST RETRIEVE THIS FILE(s) FROM THIS FOLDER AND EMAIL THE FILE(S) TO SMARTWAY IN  ORDER TO
   COMPLETE YOUR SUBMISSION. Please open an  email message, attach the newfile(s) and send to
   snrBrtway_transport@epa.gov, or to your Partner Account Manager (PAM) if your company has an existing SmartWay
   Partner.

   If you have any questions on this submission process, please contact your PAM, or the SmartWay Call Center at (734)
   214^4767 or email smartway_transport@epa.gov. Once SmartWay has received your file, it will be reviewed and you will
   receive an acknowledgement of acceptance.
                            Figure 72: Instructions for Submitting xml File to EPA


Follow these instructions for submitting your .xml and .xls files to SmartWay. Note that the .xml file is

approximately 10 times smaller than the .xls file itself. Upon selecting NEXT, a screen will appear that

allows you to close the Truck Carrier Tool or return to the Home screen.


NOTE: DO NOT ZIP the File. Send it to EPA as a normal file attached in an e-mail. EPA security will not

allow zipped files through the EPA firewall.


NOTE: DO NOT CHANGE THE NAME OF THE XML OR XLS FILES.


NOTE: DO NOT DELETE YOUR EXCEL  (XLS) TOOL-SAVE THIS FILE FOR YOUR REFERENCE.
                                       Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 106

-------
Troubleshooting the Tool
Although the SmartWay tools have been tested extensively, you may encounter errors. Intermittent
errors have been encountered when opening the Tool from an e-mail rather than from a drive. In
addition, note that you will not be able to open the Tool successfully directly from the SmartWay
website, so save the Tool to your hard drive before opening. If you encounter an error during use of the
Tool, try restarting the Tool directly from a disk drive, with all other Excel files and applications closed.  In
addition, make sure that your computer is using a system  and application version validated for use with
the SmartWay tools (Windows XP or later operating system, and Excel Office 2003 or later version).

If you continue to encounter problems,  make a screen capture of the error message, and save the Tool at
that point.  (You can make a screen capture by pressing the keys Alt and Print Screen at the same time,
and then pasting the image into a document such as MS Word.) Then send the screenshot, along with
the saved Tool to your Partner Account  Manager for further assistance.

Proper Calculation Setting

By default, Microsoft Excel is set to automatically calculate formulas. If values within your Tool are not
calculating automatically, then your Excel  may be set to "Manual". Follow these instructions to change
your Excel Calculation setting.

Office 2010
Choose the "Formulas" tab. Select the "Calculation  Options" button in the "Calculation" section to view
the drop-down list of options. Choose "Automatic" from the list of options to switch to automatic
calculation.
A
      Home    Insert     Page iayou
               X
                                         Formulas
)ata    Review     View     Developer
                                                              >
                                 i
                                 i
  Insert    AutoSum Recently Financial Logical   Text  Date &  Lookup &  Math    More      Name
 Function     -    Used*     •                 Time* Reference* & Trig* Functions *  Manager ^
                                Function Library                                        D

A
1
Al
A

-( f*
B
C

D

2


E
F
G
H
1






                                    Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 107

-------
Bookl -  Microsoft Excel
'Trace Precedents
•Trace Dependents
 Remove Arrows T
                   Show Formulas
                   Error Checking *
                                    Wat*
                  ^Evaluate Formula  window
Cal
nr
,.

culation
ition< »•
             Calculate Now
                                                      ^Calculate Sheet
             Formula Auditing
             M
[ / ]  Automatic
     Automatic Except for Data Tables
     Manual
Office 2007
Select the Office button at the top left. Then select the Excel Options button and the Excel Options dialog
box will appear. Select the Formulas tab and the Formulas options will appear in the right pane. Select
the "Automatic" radio button in the Calculation options section.
E^iOpniom
Pap--jlir
k— «
PlOflftCrfl
tut
""*
J r «.
'M
- :
• . e«Tt«r
1 *noim«




&m*
*
J'f Chang* opiior-s felated 10 lormub uloilatMfi pedsrmant* and tact handling.

(^"cjtiJMMn oobonT^}
W«>l»i)«l fiKaulian tdiolt {tnttnt Li-culition
• tuto»at»c Mi|imumlMiilioflt 100 !
MrteoitK occpt «K daU UMii
Mu«um£lun«tt tool
WMMAgnMllMMlM
BtCl ref[»*tir*
V Eflr*MU Aul^amplflf
V U-;* ^blc riAiMi in FoiTiuUs
v Use Gee£wcrtQjt>rijrutiDntfarnvo4TAble itf*trncei
IMraNdMng
/ Erubl* feicVfliound «/i»i civdcino
&MJKrt*tn«S Ut*lQth.ItQlQf '* - ftri*tianoerO (i'PH
EnwtfwMngnAii
V C*|lM6«i*tfiift«*4r*wi»l tft*lf*lMflin w**r*r V; F«imuU$ wttt* jmn ulH-^ * rtfliftri
i/. Iru«njiittfvt cikularttd ofifeitwi lofifojU in tiale-i / Unload tciu conlAAmf fannutoi
V Cells [grAaming ^ f ii s FtptcsentHl s ; 2 c^; :•• FD(my4j: reltntrg 1o *mpt> cclli
v Numb«n far»jiiei]iM<«twprM*4tdHrwi ^ tWi «rfler*tfir» jlaWe innt»i»d
apc^lrophi
y FomUfls i£»nmtertt wrth C^NET romwi-ii in th? «?gi?n
L « J 1 ~«««~ 1
                                      Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 108

-------
Office 2003
From the tools menu, select "Options". When the Options dialog box is displayed, select the "Calculation"
tab. Under the Calculation section, select the "Automatic" radio button and then select "OK".
 E Microsoft Excel - Bookl
:Sj File Edit View Insert Format
KB T £

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A
B
C















































Tools | Data Window Help
^ Spelling... F7
Q Research... Alt+Click
"^ Error Checking. . .

Shar
Shar
Prate
Onlin
;d Workspace
3 Workbook. .
ction
e Collaborate
t>
>n ^
Formula Auditing t
Macro
Customize...
I
Options...
V





- ^E-zJjUiiQi'^ 10u% T '^


G
H
1
J
































































Options

Color International
View 1 Calculation !


1 0 Automatic
tj' Automatic except tables


HH Iteration
Maximum iterations; 100
Workbook options
0 Update remote reference
CH Precision as displayed
C] 1904 date system



	 . 	

Save Error Checking Spelling Security
Edit General | Transition || Custom Lists Chart


O Manual | Ca|c rjow (F9)
jlate before save
Calc Sheet


Maximum change : 0,001
s 0 Save external [ink values
Q Accept labels in formulas

OK Cancel

                                     Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 109

-------
Office 2013 Text Display

Users of MS Office 2013 may encounter problems displaying text entries. The example below shows how
the information typed into the "Goal for SmartWay participation" text box is barely visible. This is due to
a bug in the MS Office system itself.
          I
        Goal for SmartWay participation:   (3000  characters max)
EPA has corrected the display problem in certain locations within the Tool, but if you encounter this
problem we recommend opening a different word processor such as MS Word, typing the desired entry
in the word processor, then cutting and pasting the entry back into the text box within the Tool. This
should allow you to view your entry properly within the Tool.
                                  Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 110

-------
Appendix A- Port Dray Program Data Requirements and Calculations

EPA's SmartWay Drayage Program recognizes Partners for reducing diesel emissions from port drayage
trucks. Drayage is the short distance transport of containerized freight goods between marine (or rail)
terminals and local distribution centers. The following provides an overview of the program and the
associated data input requirements for the Truck Carrier Tool.

The Partnership Elements: EPA has developed an emissions calculator to help port truck carriers
measure their particulate matter (PM), oxides of nitrogen (NOx), and carbon dioxide (CO2); identify
strategies to reduce harmful diesel emissions and track emissions performance on an annual basis. To
participate, drayage carrier partners sign a partnership agreement and commit to track emissions,
replace older dirtier trucks with cleaner, newer ones, and achieve at least a 50% reduction in PM and 25%
reduction in NOx, below the industry average, within three years. Shippers who are already members of
SmartWay commit to ship 75% of their port cargo with SmartWay dray carriers within three years. New
Shipper Partners must sign the SmartWay Shipper partnership agreement and the drayage addendum.

Business-to-Business Advantage: SmartWay drayage carriers are preferred by SmartWay Shippers, and
they want to ship their goods with participating SmartWay drayage partners. Shipper Partners are
already giving business priority to SmartWay drayage carriers.

Technical Support: EPA will assist SmartWay drayage partners in developing and meeting goals.

Recognition of Existing Environmental Improvements: A dray carrier fleet's existing age and emissions
strategies, coupled with  continued improvements, determine status in the Partnership. Full credit is
provided for fleet improvements made to date.

Promotional Opportunities and Public Recognition: The SmartWay Transport Partner brand of
excellence is awarded to qualifying Partners as a visible cue to business customers and the public, to use
in their advertising and other promotional media. The SmartWay brand sends a message that
participating dray carriers are champions of environmental stewardship. The SmartWay brand also helps
customers and consumers to make educated choices about SmartWay recognized products and services.
Visible exposure through national and regional events, advertisements, articles, and special recognition
are just a few ways that EPA commits to recognize dray carrier partner achievements.

Truck Carrier Tool Data Input Requirements: Those fleets with 75% or more of their operation in the
Dray Operation Category are eligible to participate in SmartWay's Port Drayage Program. These fleets
have the Step 6 - Port Dray Program option displayed on the General Information screen (see Figure A-
1).
                                   Truck Carrier Tool Data Entry and Troubleshooting Guide | P. Ill

-------
 Truck: ABC Trucking, Inc.: Dry Van Fleet
                       Diesel
   Please enter general information for this fleet. To enter comments about this fleet, use the Comments button that appears near the bottom right corner
   of this and all subsequent screens.
   1. Short-haul vs. long-haul split: |I?J|
         Short Haul     |    ii~ %

         Long Haul     |    ^f %

   2. Fuel types found in this fleet (indicate all that apply): J?J

      I* Diesel / Biodesel      T LPG      F CNG     T Hybrid

      T Gasoline / Ethanol      l~ LNG      r Electric


   3. Particulate Matter Reduction  J?J
     Check this box if you employ particulate matter reduction technologies for
     trucks with diesei engines that were built in 2006 or earlier.

      T PM Reduction

   4. "Cube Out" Percentage J?J
     Enter the percentage of truckloads that utilize
     100% of available cargo capacity, while        I  go o/0
     remaining under allowable weight limits (i.e., cube  '
     out before weigh out).


   5. Commodities List
     Select the View/Select Commodities button to specify which
     commodities your fleet normally carries.
              View/Select Commodities
Current Status of this Fleet:
                              Complete (with Warnings)
    6. Port Dray Program t \
      Check this box if you wish to participate in the EPA Port Dray Program.


          Port Dray Program
  Port Dray Program
   Selection Option

      Displayed
                                                                                                                        Page 16
                        Figure A-l: General Information Screen with Port Dray Program Option


Checking the Port Dray Program box will activate the Port Dray Program Agreement screen shown in

Figure A-2.  Select the box on this screen indicating you understand and agree to the terms described

therein, and select OK to return to the General Information screen.
                                                 Truck Carrier Tool Data Entry and Troubleshooting Guide  | P. 112

-------
 SmartWay Port Dray Program Agreement
  EPA's SmartWay Drayage Program recognizes Partners for reducing diesel emissions from port drayage trucks. Drayage is the
  short distance transport of containerized freight goods between marine (or rail) terminals and local distribution centers.

  The Partnership Elements: EPA has developed an emissions calculator to help port truck carriers measure their particulate
  matter (PM), oxides of nitrogen (NOx), and carbon dioxide (CO2); identify strategies to reduce harmful diesel emissions and
  track emissions performance on an annual basis. To participate, Drayage Carrier Partners select the box below and commit to
  track emissions, replace older dirtier trucks with cleaner, newer ones, and achieve at least a 50% reduction in PM and 25%
  reduction in NOx, below the industry average, within three years. Shippers  who are already members of SmartWay commit to
  ship 75% of their port cargo with SmartWay Dray Carriers within three years. New Shipper Partners must sign the SmartWay
  Shipper Partnership agreement.
                             l~~ il.understand and agree to the terms of this agreement:.!


  Business-to-Business Advantage: SmartWay Drayage Carriers are preferred by SmartWay Transport Shippers; and they want to ship their
  goods with participating SmartWay Drayage Partners. Shipper Partners are already giving business priority to SmartWay Drayage Carriers.

  Technical Support: EPA will assist SmartWay Drayage Partners in developing and meeting goals.

  Recognition of Existing Environmental Improvements: A dray carrier fleet's existing age and emissions strategies, coupled with continued
  improvements, determine status in the Partnership. Full credit is provided for fleet improvements made thus far.

  Promotional opportunities and public recognition: The SmartWay Transport Partner brand of excellence is awarded to qualifying Partners as a
  visible cue to business customers and the public, to use in their advertising and other promotional media. The SmartWay brand sends a
  message that participating Dray Carriers are champions of environmental stewardship, The SmartWay brand also helps customers and
  consumers to make educated choices about SmartWay recognized products and services. Visible exposure through national and regional
  events, advertisements, articles, and special recognition are just a  few ways that EPA commits to recogniee Dray Carrier Partner
  achievements.
                                                                                                                Page 18
                                      Figure A-2: Port Dray Program Agreement
Upon returning to the General Information screen you will see additional  information and data input

cells associated with the Port Dray Program (see Figure A-3).
                                              Truck Carrier Tool Data  Entry and Troubleshooting Guide  | P. 113

-------
 Truck: ABC Trucking, Inc.: Dry Van Fleet
                     Diesel
   Please enter general information for this fleet. To enter comments about this fleet, use the Comments button that appears near the bottom right corner
   of this and all subsequent screens.
   1. Short-haul vs. long-haul split: Jj
        Short Haul     |   55" %
        Long Haul        ^~ %
   2. Fuel types found in this fleet (indicate all that apply): _?j
     P Diesel / Biodiesel      l~ LPG     l~ CNG    F Hybrid
     r Gasoline / Ethanol      l~ LNG     l~ Electric
                                                       Current Status of this Fleet:
                                                        Complete (with Warnings)
                                 6. Port Dray Program  ? |
                                  Check this box if you wish to participate in the EPA Port Dray Program.

                                    W Port Dray Program
   3. Particulate Matter Reduction
Jd
                                                             As a participant in the Port Dray Program, you will need to provide the
                                                             information below:
    Check this box if you employ particulate matter reduction technologies for
    trucks with diesel engines that were built in 2006 or earlier.
     I? PM Reduction
   4. "Cube Out" Percen
    Enter the percentage of truckload:
    100% of available cargo capacity,
    remaining under allowable weight limits (i.e.,
    out before weigh out).
   5. Commodities List
    Select the View/Select Commodities button to spei
    commodities your fleet normally carries.
                                   Port Dray Program
                                       Selected
                                     1. Trucks equipped with Auxiliary ?
                                      Power Units (APU);

                                     2, Trucks equipped with  ? I
                                      SmartWay Tires:
                                     3. LNG Vehicles:
                                        Use the "LNG Vehicles" tab above to provide information on your LNG
                                        trucks (if applicable).

                                     4. Particulate Matter Reduction:
                                        Use the "Diesel Vehicles" tab above to provide information on your
                                        PM reduction efforts. The PM Reduction is a separate sub-tab on the
                                        Diesel tab.
                                                             Once you have provided information on the four items listed above, select
                                                             the "Port Dray Program" tab (found on the Diesel Vehicles tab) for a
                                                             summary of the results.
                                                                                                           Page 16
        Figure A-3: General Information Screen with Port Dray Program Information and Inputs Activated

In order to participate in the program, first enter the number of auxiliary power units (APUs) installed on
your fleet's trucks. An APU is a small diesel fuel-powered generator mounted outside the cab that
provides the operator heat, air conditioning, and/or electrical  power to run in-cab appliances.  Next,
input the number of trucks equipped with SmartWay Tires. Options include both dual tires and single
wide tires (single wide tires replace the double tire on each end of a drive or trailer axle, in effect turning
an 18-wheeler into a 10-wheeler). Low rolling  resistance tires can be used with lower-weight aluminum
wheels to further improve fuel savings.  Enter  zero in each of these cells if these strategies are not used
on your vehicles.  Otherwise, make sure that the number of trucks specified does not exceed the total
number entered on the Engine Model Year &  Class screen.

If your fleet includes LNG vehicles, make sure to characterize those vehicles on the LNG screen.12  In
addition,  note that the PM Reduction box on the General Information screen is automatically checked
upon selection of the Port Dray Program checkbox (see Figure A-3).  Make  sure to characterize your dray
fleet's PM reduction strategies on this screen.
12
   Port Dray Program participants operating only LNG trucks must still select the Diesel/Biodiesel checkbox
in order to view their Port Dray Program score (displayed as a subtab under Diesel).
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide |  P. 114

-------
After entering the required data regarding your dray fleet, the Truck Carrier Tool will calculate your
fleet's Environmental Performance Score consistent with the Port Dray Program evaluation guidance.
Information regarding how the Environmental Performance Score is calculated is presented in the Truck
Carrier Tool Technical Documentation. You can view a summary of your Dray Program inputs and the
associated Environmental Performance Score on the Port Dray Program screen under the Diesel
Vehicles section, adjacent to the PM Reduction tab (see Figure A-4), or by reviewing the Port Dray
Program Report on the Reports Menu screen.
 Truck Tool: ABC Trucking, Inc.: Example Dry Van Fleet
 General Information
   Model Year & Class  Activity Information
                              Gasoline Vehicles
                                PM Reduction
                                            Port Dray Program
 Following is a summary of the information you entered as part of the Port Dray Program. For a description of the various fields and screens that were used
 to determine each data item below, select the Help button in the bottom right corner of this screen. For a print-out of the information on this screen, go
 to the reprort menu found on the Home screen.
      Truck Counts
Pre-  1988- 1994- 2003- 2007- Post-
1988   1993  2002  2006 2009  2009
    Emissions (Short Tons)
CO2       PM       NOx
Untreated
DOC and CCV
Flow Through Filter
Diesel Particulate (PM Trap) [

Total Trucks







0 | 0 | 0 | 30
0 | 0 | 0 | 4
0 | 0 | 0 | 0
o | o| o| o | is | 6 |

0 | 0 | 0 | 34 | 15 | 6 |
Reductions from APUs: 1
Reductions from SmartWay Tires: 1
Reductions from LNG: 1
Total Emissions:
Baseline Emissions:
Total Change:
Percent Change:
30
4
0
21

55
10
15
0




1,838,6 0,9227
245.1 0.0361
0.0 0.0000
1,287.0 0.0025

3,370.7 1.0113
-67.4 -0.0147
-18.4 | 0.0000
0,0 | 0,0000
3,284.9 0.9966
3,370,7 | 2,8802
-85.8 -1.8335
-2.5% -65.4%
12,84
1,71
0.00
3.51

18.07
-0.36
-0.10
0,00
17,61
62,80
-45.19
-72.0%
                                        Environmental Performance:
                                          Average Miles Per Truck:
                                                                         Very Good
                                                                  33,028
                             Figure A-4: Port Dray Program Information Screen

The information summarized on the screen above is derived from the following screens within the Truck
Carrier Tool. Fields not specifically mentioned below are calculated fields:

1. Average Miles per Truck: Represents "Total Miles Driven" on the Activity Information screen divided
by "Total Trucks" on the Engine Model Year & Class screen for diesel vehicles.

2. Average Gallons of Fuel per Truck: Represents "Gallons of Diesel Used" on the Activity Information
screen divided by "Total Trucks" on the Engine Model Year & Class screen for diesel vehicles.

3. DOC and CCV: Number of trucks retrofitted is obtained from the PM Reduction screen.

4. Flow Thru Filter: Number of trucks retrofitted is obtained from the PM Reduction screen.

                                       Truck Carrier Tool  Data  Entry and Troubleshooting Guide |  P. 115

-------
5. Diesel Particulate (PM Trap): Number of trucks retrofitted is obtained from the PM Reduction screen.

6. Untreated: Represents vehicle count totals from the Engine Model Year & Class screen for diesel
vehicles, minus truck count totals from the PM Reduction screen (i.e., the number of trucks without
retrofits).

7. Reductions from APUs: Number of trucks equipped from the Port Dray Program field on the General
Information screen.

8. Reductions from SmartWay Tires: Number of trucks equipped from the Port Dray Program field on the
General Information screen.

9. Reductions from LNG: Represents "Total Trucks" on the Engine Model Year & Class screen for LNG
vehicles.
                                    Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 116

-------
Appendix B—Recommended Data Sources for Activity Data



  Table B-l summarizes the standard Data Source categories available for selection for each data type.
                      Table B-l:  Data Source Detail Selection Options
Data Type
Total Miles Driven
Revenue Miles Driven
Data Source
As reported to IFTA Form 441
for tax reporting (interstate) —
for Class 7 ', 8a and 8b trucks
only
As reported to individual
states for tax reporting
(intrastate)
Determined using software
Vehicle-based data collection
As used in Federal tax
reporting
Financial data
Data Source Detail
Collected via fleet-wide GPS reporting software
Collected via odometer readings
Collected via maintenance records
Collected via driver trip sheets
Collected via standard mileage routes, e.g. PC Miler,
Household Goods Guide
Collected via fleet-wide GPS reporting software
Collected via odometer readings
Collected via maintenance records
Collected via driver trip sheets
Collected via standard mileage routes, e.g. PC Miler,
Household Goods Guide
Dispatching Software*
Transportation Management System (TMS)*
Determined via Electronic Control Module (ECM)
data recorder/logger*
Collected via electronic Transportation Management
System (TMS)
Collected via GPS-enabled TMS
Collected via manual input into company database
with driver trips sheets
Collected via non-electronic company records
Accounting/billing software*
Tax reports/IRS and State*
                               Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 117

-------
Data Type
Revenue Miles Driven
(cont'd)
Empty Miles Driven
Gallons of Fuel UsedA
Data Sou rce
Determined using software
Based on total mileage
Collected automatically/
electronically / manually
Financial Data
Determined using software
Based on total mileage
As reported to IFTA Form 441
for tax reporting (interstate) —
for Class 7 ', 8a and 8b trucks
only
As reported to individual state
for tax reporting (intrastate)
Data Source Detail
Dispatching Software*
Transportation Management System (IMS)*
Equal to total miles
Total miles less empty miles
Calculated as a percentage of total miles*
Collected via electronic Transportation Management
System (TMS)
Collected via GPS-enabled TMS
Collected via manual input into company database
Collected via non-electronic company records
Collected via odometer readings
Collected via driver trip sheets
Accounting/billing software*
Tax reports/IRS and State*
Dispatching Software*
Transportation Management System (TMS)*
Total miles less revenue miles
Calculated as a percentage of total miles*
Collected via electronic fuel receipt
Collected via paper fuel receipt
Collected via driver trip sheets
Collected via electronic expenditure data
Collected via paper expenditure data
Collected via electronic fuel receipt
Collected via paper fuel receipt
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 118

-------
Data Type
Gallons of Fuel Used
(cont'd)
Average Payload
Average Volume
Capacity Utilization
Road Type / Speed
Categories
Data Sou rce

Determined using software
Vehicle-based data collection
Based on MPG estimates*
Bills of Lading - electronic
records (preferred)
Bills of Lading - manual
records
Ranges provided by calculator
Determined using company
records*
Defaults from calculator
Collected automatically/
electronically / manually
Determined using software
Collected automatically/
electronically
Transportation Management
Data Source Detail
Collected via driver trip sheets
Collected via electronic expenditure data
Collected via paper expenditure data
Dispatching Software*
Transportation Management System (TMS)*
Determined via Electronic Control Module (ECM)
data recorder/logger*
User-provided
Based on actual miles traveled by specific payloads*
Trip-weighted (total payload weights /total trips)*
Based on actual miles traveled by specific payloads*
Trip-weighted (total payload weights /total trips)*
N/A (calculator)
User-provided
N/A (calculator)
Collected through load volume information
Dispatching Software*
Transportation Management System (TMS)*
Driver trip sheets*
Governed speed*
Determined via GPS
Determined via Electronic Control Module (ECM)
data recorder/logger*
Driver trip sheets*
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 119

-------
Data Type

Average Annual Idle
Hours per Truck
Data Sou rce
System (IMS)
Vehicle-based data collection
Driver trip reports*
Idle reduction strategy
Determined using software
Data Source Detail
Governed speed*
Determined via GPS
Determined via Electronic Control Module (ECM)
data recorder/logger*
Determined via Electronic Control Module (ECM)
data recorder/logger*
User-provided
Company "No Idle" policy in place*
Local/State idle regulation in place*
Dispatching Software*
Transportation Management System (TMS)*
* User must provide additional description regarding data collection system and calculation method.

A For electric vehicles, in lieu of gallons, use kWhrs. Common data sources for kWhrs include metering at charging dock, vehicle
data acquisition units, and smart-meter applications.
                                           Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 120

-------