Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Truck Carrier Partner 2.O.I3 Tool:
Data Entry and Troubleshooting Guide
2OI3 Data Year - United States Version
oEPA
United States
Environmental Protection
Agency
-------
Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Truck Carrier Partner 2.O.I3 Tool:
Data Entry and Troubleshooting Guide
2OI3 Data Year - United States Version
Transportation and Climate Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
United States Office ofTransportation and Air Quality
Environmental Protection EPA-420-B-14-002
Agency
January 2014
-------
Table of Contents
TABLE OF CONTENTS 3
INTRODUCTION 5
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 SMARTW AY TOOLS 7
Security Settings For Excel 2003 Users 8
Security Settings For Excel 2007 Users 9
Security Settings For Excel 2010 Users 15
BASIC ORGANIZATION OF THE SMARTWAY TRUCK CARRIER TOOL 20
REVIEWING THE INTRODUCTORY SCREENS 22
SMARTW AY INTRODUCTION SCREEN 23
SMARTW AY PARTNERSHIP ANNUAL AGREEMENT SCREEN 24
SMARTW AY TOOL SELECTION SCREEN 25
REQUIRED INFORMATION SCREEN 26
US/CANADIAN OPERATIONS SCREEN 26
BASIC OVERVIEW OF HOW TO COMPLETE THE TOOL 28
SECTIONS OF THE TOOL 29
ENTERING YOUR DATA 29
VALIDATING YOUR DATA 30
SAVING YOUR DATA 30
REVIEWING YOUR DATA 30
PARTNER PROFILE/LOGO INFO/SUGGESTIONS 30
SUBMITTING DATA TO SMARTW AY 30
PREPARING FOR DATA ENTRY 32
SECTION 1 DATA ENTRY: ENTER PARTNER NAME 33
Section 1 Overview 33
SECTION 2 DATA ENTRY: ENTER COMPANY AND CONTACT INFORMATION 34
Section 2 Overview 34
SECTION 3 DATA ENTRY: CHARACTERIZE YOUR FLEETS 37
"Identify Fleets" Screen Overview 38
"Fleet Details" Screen Overview 41
"Operation Categories" Screen Overview 43
"Body Types" Screen Overview 45
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 3
-------
SECTION 4: SELECT FLEET FOR DATA ENTRY (PROVIDING ACTIVITY AND FUEL CONSUMPTION INFORMATION FOR
YOUR FLEETS) 47
Fleet Status Review Overview 48
"General Information" Screen Overview 50
Fuel SECTION: "Engine Model Year & Class" Overview 53
Fuel SECTION: "Activity Information" Screen Overview 55
Main Fuel Activity Data Points Overview 57
"Fuel Allocator Worksheet" Overview 61
(OPTIONAL) "Biodiesel Blend Worksheet" Overview 64
(OPTIONAL) "Ethanol Blend Worksheet" Overview 65
Payload and Capacity Overview on the "Activity Information" Screen 66
Average Capacity Volume (cubic feet) Worksheet Overview on the "Activity Information"Screen 73
Percent (%) Capacity Utilization Section Overview on the "Activity Information" Screen 76
Road Type/Speed Category Section Overview on the "Activity Information" Screen 77
Average Annual Idle Hours per Truck Section Overview on the "Activity Information" Screen 78
"PM Reduction" Screen Overview 80
VALIDATING YOUR DATA 82
VIEWING YEAR-TO-YEAR COMPARISON 88
PROVIDING ADDITIONAL INFORMATION 93
VIEWING REPORTS 96
SUBMITTING DATA TO SMARTWAY 99
TROUBLESHOOTING THE TOOL 102
APPENDIX A-PORT DRAY PROGRAM DATA REQUIREMENTS AND CALCULATIONS 106
APPENDIX B—RECOMMENDED DATA SOURCES FOR ACTIVITY DATA 112
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 7681
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://epa.gov/smartway/partnership/trucks.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 or 2010).
1 The tool will also work at 800 x 600 resolution, but many of the screens will appear with scroll bars.
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."
a / u : i
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.
lasted Publishers
0 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 Settingsforthe SmartWay Tools
In order to run this application, you must have macros enabled.
3 For Excel 2QQ7 and Excel 2010 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:
iur cornritv cottinnc arp cot
E I F | G.
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
Rle Path: C:fcmartway Chipper, xb
O Help protect me from unknown content (recommended)
® |nab¥lhi? content]
Open the Trust Center
OK Cancel
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).
•
LI
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
@®
•S, Change the most popular options in Excel.
Top options for working with Excel
•v
Click the "Trust
Center" button the Ribbon >
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 Pnl^l
Popular
Formulas
Proofing
Save
Advanced
Customize
Add -Ins
Trust Center
Resources
\jfl 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 securityfram 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 USERS
The default settings for Excel 2010 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.
ilia *>- o IT
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 Sum: active content has been disabled. Click for more details. Enable Content
Al » ' ff 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 tt\ run thie anrtliratirm \it\n miicf haua marrrte anahloH
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 ^MH
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
-------
Q
'•
_
U
tel
a
ca
New
Save
Save A; t
Ennl >
Prepare >
- a >
Publish >
Ck»
/
/
£ Excel Options X Exit Excel
Microsoft Excel
View Add-Ins Nuance PDF
Merge & Center •
JL= I flf
•;
F;iru!3tting - as Table - Style:
Select
Figure 11: Excel 2010 Options Drop-Down Menu
On the Excel Options screen, select Trust Center in the left navigation bar (Figure 12):
-jSi Criange the 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 vj
ScreanTip style:
Show feature descriptions in ScreenTips
When creating new workbooks
sequences: [ Edit Custom Lists... ]
Use this font;
Font size:
Default view tor new sheets:
-
Personalize your copy at Microsoft Office
Choose the languages you want to use with Microsoft Office: [ Language Settings.
OK Cam
Figure 12: Excel 2010 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 I
Popular
Formulas
Proofing
Save
Advanced
Customize
Add -Ins
1 Trust Center
Resources
\j/ 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,
piease see the privacy statements.
Show the Microsoft Office E*cel privacy statement
Microsoft Office Online Drivacv 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 Iru!t 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
f?K
Macro Settings
!-or macros in documents not in a trusted location; ff~~ ~~\
O Disable aH 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.
•SmartWay9
Report Year
2013
Truck
Introduction
Welcome to the SrnartWay 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-4767
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
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
-------
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.
Truck
Introduction
Welcome to the SmartWay Truck Tool, This version of the Truck Tool encompasses ground truck movements.
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
buttons at the bottom of selected screens.
Screen
Demo
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 five 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 "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
SmartWay*
Report Year
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 Truck Tool Page or the SmartWay Website
Or call the SmartWay Helpline at: (734) 214-4767
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
Pagel
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
SmartWdy Partnership Annual Agreement
'SmartWay*
Report Year
2013
Truck
United States Version: 2.0.13
Released on: I/1/2014
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.i
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 SmartWay 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 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).
Click to accept
Agreement
* II understand and agree to the terms of this agreement. N
Page 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
•SmartWay
Report Year
2013
Truck
United States Version: 2.0.13
Released on: 1/1/2014
Is this the right SmanWay roo/ for me?
You operate your own managed fleet
(owned or leased) with less than 5% of
your freight contracted with outside
companies,
YES
NO
You contract out more than 5% of your
freight, i.e. you are a 3PL, broker, freight
forwarder or non-asset based carrier.
YES
NO
J
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
"YES
NO
Select this Button
for More
Information
PageS
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.
SmartWay Truck: Required Information
r~^t^^^^^^^^^H RenortYear Truck
%
LS^T^TVTOPa 2013 unit™dT
:ollowing is a brief description of the information you will need to complete the SmartWay Truck Tool. For further details, please
consult the SmartWay Truck Tool User Guide.
Company Information:
• US / Canada Operations Information
• Company Name, Address, City, State, ZIP, Country, Main Phone, Website
Primary, Executive, and Other Contact Information:
• Name, Title
• Address, City, State, ZIP, Country
• Phone, E-mail
• SmartWay ID Number (for returning Partners)
• Partner and Fleet Names, Contacts
• Standard Carrier Alpha Codes (SCACs), Motor Carrier numbers, and/or DOT Numbers
• Fleet Type
• 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
* Percent long-haul and percent short-haul
• Fuel usage by truck class 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 descript ons
• 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 class
• 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
n: 2.0.13
L/ 1/ 20 14
^^H
Pages
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.
Once you have navigated through the four introductory screens, you will be taken to the SmartWay Truck
Carrier Tool Home 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. 26
-------
SmartWay US / Canadian Operations
SmartWay9
Report Year
2013
Truck
United States Version: 2.0.13
Released on: 1/1/2014
The SmartWay Transport Partnership is now being administered in both the United States and Canada. The Partnership operates the same in both
countries, with the exception that in Canada the data is collected in metric and the tools are also offered in French.
PLEASE NOTE:
- Companies should only submit data to one country.
- Partners will be recognized in both the United States and Canada.
To allow the United States and Canada to determine geographic-based impacts, please answer the following questions about your freight
operations in both countries.
Please indicate the percentage of your fleet(s) that is made
up of United States-licensed vehicles versus Canadian-licensed
vehicles:
| J^T % licensed in the United States
o~ % licensed in Canada
Please indicate the approximate percentage of your total fuel
consumed by United States vehicles versus Canadian vehicles:
i nn % fuel consumed by US-licensed vehicles
n % fuel consumed by Canadian-licensed vehicles
What is your percentage of fuel consumed by licensed vehicles based
on?
'• As Reported to IFTA Form 441 for tax reporting (interstate)
l' As Reported to individual state for tax reporting (intrastate)
''" Determined using software
'" Vehicle-based data collection
'" Based on MPQ estimates
<* Other (please indicate):
Based on a combination of IFTA and internal records based on fuel purchase
recieptsl
Do your US-licensed vehicles and Canadian-licensed vehicles
generally operate using the same fuel mix?
<• Yes
c No (please describe):
<~ N/A
Page 6
Figure 23: 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 23) indicating:
• The percentage of your fleet(s) that utilizes vehicles licensed in the United States vehicles vs.
vehicles licensed in Canada.
• The approximate percentage of your total fuel consumption that is US-based vs. Canada-based
• The source of your total fuel consumption estimates
• The degree to which your Canadian fleets and US fleets use the same fuel mix
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 27
-------
Basic Overview of How to Complete the Tool
All data entry screens are reached by starting with the Home screen.
Figure 24 displays the structure of the Home screen.
Smart Way Truck: Home
SmartWay
Report Year
2013
Please complete the following steps. Check boxes on the left indicate successful completion
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
2.
3.
Enter Contact Information
Characterize your Fleets
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
5.
6.
?•
Review Vear-to-Year Comparison
Partner Profile / Logo Info / Suggestions
View Your Data Reports
* After sele ct/ng this option, be sure to carefuffy readoffdirections before proceeding.
Truck
United States Version: 2.0.13
Released on: 1/1/2014
Screen
Demo
Page?
Figure 24: Main Tool Navigation or "Home" Screen
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 28
-------
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 primary SmartWay point of 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. 29
-------
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 99.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 30
-------
PART 3:
SECTION-BY-SECTION
DATA ENTRY GUIDANCE
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 31
-------
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 Primary Contact
• Contact details for an Executive Contact (cannot be the same as the Primary Contact)
• Split between US/Canada operations
• Quarterly IFTA statements2 (for activity data) for the reporting calendar year
• Fleet details for all fleets you control:
o SCACs, MCNs, 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.
2 If applicable - for Class 7, 8a and 8b trucks only.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 32
-------
Section 1 Data Entry: Enter Partner Name
SECTION 1 OVERVIEW
Section 1 of the Truck Carrier Tool asks you to "Enter Partner Name."
SmartWay Truck: Home
SmartWay
Report Year
2013
ABC Trucking, Inc.
Please complete the following steps. Check boxes on the left indicate successful completion
1. Enter Partner Name (Exactly as it should appearj
Enter your Partner Name
precisely as you want it
on the EPA website
ruck
1/1/2014
Figure 25: 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. 33
-------
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^"
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
JABC Trucking, Inc.
Select "Enter
Contact
Information"
Figure 26: Select Contact Information Button on "Home" Screen
You will then be taken to the Contact Information Screen. The Partner Name entered on the Home
screen will appear automatically at the top (see arrow in Figure 27). On this screen you establish the
following details about your company:
1. Partner Information includes details about the company location, phone numbers, and web
address.
2. The Primary Contact is the person assigned to work directly with EPA regarding timely and
accurate Tool submission, and is responsible for assembling 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
developments with SmartWay. (NOTE: To ensure that e-mails from SmartWay/EPA are not
blocked, new Primary Contacts may need to add SmartWay/EPAto their preferred list of
trusted sources.)
3. The Executive Contact is the company executive who is responsible for agreeing to the
requirements in the SmartWay Partnership Annual Agreement, overseeing the Primary
Contact (as appropriate), and ensuring 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.
4. Other Contacts include any other company representatives that have a role in your
participation in SmartWay. These may include representatives from other business units,
media/public relations, staff, or anyone who has responsibility for specific fleets beyond the
person listed as the Primary Contact. This is especially important as you will be identifying
individual fleets in the Tool and will be assigning contacts to each fleet separately.
NOTE: The Primary and Executive Contact information is mandatory and these must be different
people. Duplicate contacts are not allowed to ensure EPA has access to at least two people for Tool
submission follow-up.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 34
-------
Partner Name: |ABC Trucking, Inc.
Addressl* F
Address2
City* j
Main Phone* |
Web Site*
Partner Name
from Home screen
State*
ZIP*
Country*
Toll Free: |
2. Primary Contact: Jj
Name: _3 First*
Title*
MI:
Last*
Use Partner Address
Addressl*
Address2
City*
Phone*
Email*
3. Executive Contact: ? I
Name*
State*
ZIP*
Ext:
Cell:
Country* |
Fax: F
Add/Edit Executive Contact
4. Other Contacts:
* - Required
Add New Contact
Edit Selected Contact
Delete Selected Contact
Screen
Demo
PageS
Figure 27: Blank Contact Information Screen
Each field marked with an asterisk must be filled out. You will not be able to submit the Tool to
SmartWay without this information.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 35
-------
STEPS FOR ENTERING CONTACT INFORMATION:
1. Enter the Partner Information details in Section 1 of the Contact Information screen.
2. Enter Primary Contact details in Section 2. If the Primary Contact's address is the same as the
company, you can select the ^fcjjafcjjmiimiiJB button to automatically fill in the address
section of this record.
3. Enter the Executive Contact details in Section #3 by selecting the
Add /Edit Executive Contact
I button to the right; enter the required data. Note that you MUST have at
least two different contacts on the Contact Information screen, and the Primary and Executive
Contacts must be different.
4. Enter Other Contacts (if applicable) in Section 4 by selecting the
Add New Contact
button.
A new contact field will appear, labeled Other Contact Information. Enter the first Other Contact
then select OK when done. You can add more contacts by selecting "Add New Contact" again. 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 the
Delete Selected Contact
button. Duplicate contacts are not allowed.
5. Select
VALIDATE
SCREEN
at the bottom of the screen. If any information is missing, a dialogue box will
appear informing you what additional information is required.
6. When finished, select the
Section 3.
button to return to the Home screen and proceed to
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 36
-------
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 four screens in the Fleet Characterization section of the Tool:
• Identify Fleets
• Fleet Details
• Operation Categories
• Body Types
Each screen, and the steps required to complete it, is described below.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 37
-------
"IDENTIFY FLEETS" SCREEN OVERVIEW
The Identify Fleets screen is shown below:
SniartWay: Fleet Characterization - Truck
Identify Fleets
Operation Categories
Body lypes
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 Intermodal. If shippers can hire "ABC Truckload division" separately from "ABC Intermodal"
Division," then list them as separate fleets; otherwise simply list "ABC Trucking, Inc."
Fleets should be named EXACTLY as you want them to appear on the SmartWay website. The Fleet Name (Partner Name) is carried over from step one on
the Home page. If appropriate, enter the Fleet Name Identifier. Example: Enter "ABC Truckload Division" in the Fleet Name Identifier space. 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. Double check that this is
how you want your fleet listed.
To add fleets, select the "Add Another Fleet" 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.
Fleet (Partner Name
,i
Fleet Identifier _LJ
Fleet Name
(exactly as it will appear on the SmartWay Website)
| ABC Trucking, Inc.
ABC Trucking, Inc.
Add Another Fleet
Page 11
Figure 28: 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
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.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 38
-------
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,
| Dry Van Fleet
ABC Trucking, Inc.: Dry Van Fleet
|ABC Trucking, Inc.
| Dray Fleet
ABC Trucking, Inc.: Dray Fleet
Figure 29: 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
the
Add Another Fleet
button.
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.
I button will be highlighted in yellow on your screen if comments have been added for a
The button will then read
VIEW/EDIT
COMMENTS
to indicate to your reviewer that there are comments to be read.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 39
-------
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 mammtst^ 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.
Add Another Fleet
To enter another fleet, select the HJHHJJJJIJJUIHH 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. To proceed, select the Fleet Details tab at the top, or simply select the
the bottom of the screen.
button at
6. Before moving on, a popup screen will appear asking you to verify that you are satisfied with your
fleet name(s).
7. Verify that the fleet name(s) show exactly what you want customers to find in the SmartWay
Carrier Data File.
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. 40
-------
"FLEET DETAILS" SCREEN OVERVIEW
The Fleet Details Screen is shown below:
SmartWay: Fleet Characterization - Truck
Identify Fleets Fleet Details Operation Categories Body lypes
This Tool should only he 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 Suite. "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
"Control" box and input SCAC, MCN, DOT, Fleet-type, and fleet contact information.
Vour customers may search for your company in the SmartWay Shipper and Logistics Tools and the Multi-modal Suite using this information, so double-
check that you have input it correctly. Additionally, if your truck fleet operates under the same ownership "umbrella" as a "non-SmartWay Partner", 3PL
or brokerage company with the same or similar name and with the same company identifiers (SCAC, MCN, and/or DOT number), this will create a carrier
identification difficulty for your customers when they enter your company into their SmartWay Shipper/Logistics Tools or the Multi-modal Suite as they
complete those tools later in the SmartWay Partner reporting cycle. If your company meets these conditions, please contact your SmartWay Partner
Account Manager to discuss corrective actions.
After completing the information on this screen, select the "Operation Categories" tab above or select the NEXT button at the bottom of this screen.
Fleet Name
1 : ABC Trucking, Inc. : Dry Van Fleet
2: ABC Trucking, Inc. : Dray Fleet
95+f*, ,
Control _LJ
r
r
scAC(s)JLJ McrnJiJ oorjJ
r r
r~ i
Fleet Type JLl
~E
3
Fleet Contact JLl
r ~E
3
Figure 30: 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
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 41
-------
Motor Freight Traffic Association, Inc., (NMFTA). If you cannot remember your SCAC(s), contact
NMFTA before proceeding. You can find NMFTA contact information at
http://www.nmfta.org/Pages/ContactUs.aspx.
• Motor Carrier Numbers (MCNs): are 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 number 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 two options accepted by the Tool—"For-Hire" and "Private/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" or "Private/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. 42
-------
"OPERATION CATEGORIES" SCREEN OVERVIEW
The Operation Categories Screen is shown below:
SmartWay: Flee.
Identify Fleets
Fleet Details Operation Categories Body Types
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.
Operation Category (to)
T] 1] _7] 7] T]
Less Than Package
Partner/Fleet Name Truckload Truckload Drayage Delivery Expedited Total
1: ABC Trucking, Inc.: Dry Van Fleet I 100 I 100
2: ABC Trucking, Inc.: Dray Fleet I 25 \ 75 I 100
Figure 31: 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. 43
-------
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. 44
-------
"BODY TYPES" SCREEN OVERVIEW
The Body Types screen is shown below:
SmartWay: Fleet Characterization - Truck
Identify Fleets
Fleet Details
Operation Categories
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 CREATE FLEET(S) button at the bottom of this screen to create the data entry forms for your fleets.
Body Type (%)
Partner/Fleet Name
Heavy/ Auto Special
Dry Van Reefer Flatbed Tanker Chassis Bulk Carrier Moving Utility Hauler Total
1 : ABC Trucking, Inc. : Dry Van Fleet
2: ABC Trucking, Inc.: Dray Fleet
Figure 32: Example for Body Types Screen
Body Type categories as defined in the Truck Carrier Tool are:
Dry van
Refrigerated (Reefer)3
Flatbed
Tanker
Intermodal chassis containers (pooled and owned)
Heavy/Bulk hauler
Auto carriers
Moving
Utility4
Special hauler (e.g., Hopper, Livestock, and other specialized carriers)
STEPS FOR COMPLETING "BODY TYPES" SCREEN:
1. 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%.
NOTE: If you specify activity for Special Haulers, a
Describe
button will appear next to the cell entry. You
must select this button and provide a text description of your specialty haulers.
CREATE
FLEET(S)
2. Once you are sure your information is input correctly, you may select the maaaatai^ button
at the bottom of the page. You will be prompted then to confirm that you have identified all of
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.
4
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. 45
-------
: Qi/ :
your fleets. Return to the Identify Fleets screen if needed, otherwise select l!=====Iand you
will automatically be returned to the Home screen.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 46
-------
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. 47
-------
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.
Smart Way Truck: Home
SmartWay
Report Year
2013
Please complete the following steps. Check boxes on the left indicate successful completion
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
|ABC Trucking, Inc.
2.
3.
Enter Contact Information
Characterize your Reels
4. Select Fleet for Data Entry (Double-click the fleet name or salart and hit Enterl:
»in'. •.•.•••••; "'.;: •:-.•'- :'*:'. : • • . ....
ABC Trucking, Inc.: Dray Fleet - Not Checked
Fleet File
Status
Indicators
5.
6.
Review Vear-to-Vear Comparison
Partner Profile / Logo Info / Suggestions
View Your Data Reports
* After selecting this option, be sure to carefully read off directions before proceeding.
Truck
United States Version: 2.0.13
Released on: 1/1/2014
Page?
Figure 33: 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. 48
-------
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. 49
-------
"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. Particulate 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 34: 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. 50
-------
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. 51
-------
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. 52
-------
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 & Class5 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
Activity Information
PM Reduction
Class 2b
8,501-10,000
Class 3
10,001-14,000
Class 4
14,001-16,000
-;
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 boK. Truck class totals are automatically r—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. ? I
Diesel
Gross Vehicle Weight 7
Rating (pounds) '
Atote; The sihousttes
represent example truck
types for Bach class, and
are not all-inclusive,
Total
Trucks
Class 5
16,001-19,500
Class 6
19,501-26,000
Class 7 Class aa Class 8b
26,001-33,000 33,001-60,000 60,001 Ik above
l~ Hide Unchecked Classes
Page 19
Figure 35: 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. 53
-------
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 36). 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 36: Confirmation of Engine Model Year and Truck Class Selections
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 54
-------
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 !?! Data Source ?
31.
•?
?
?
Total Miles Driven (exact values) 0
Empty Miles Driven (exact values) 0
c
C
!£lj
211
I
I
r r~
? I Gallons of Diesel Used, incl. Biodiesel & Reefer [
—' (exact values)
Refrigeration Unit Fuel Consumption
? Gallons of Biodiesel (B100 Equivalents)
7 I Average Payload (tons) - Cargo Weight Only
^?J Average Capacity Volume (cubic feet)
2\ % Capacity Utilization (excluding empty miles)
T_\ Road Type / Speed Categories
* Indicates that default speed distributions were selected for urban road types.
? Average Annual Idle Hours per Truck
Page 20
Figure 37: 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. 55
-------
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 and 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. 56
-------
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.6
• 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.
6 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. 57
-------
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 38).
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 58
-------
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 38: 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 Consumption
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 Carrier Tool Data Entry and Troubleshooting Guide | P. 59
-------
truck class. Diesel, LPG, and electric trucks are assumed to use diesel reefers, gasoline trucks to use
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 39 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
I unit fuel consumption by truck class (you only know • I
your total refrigeration Fuel consumption.)
Page 35
Figure 39: 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. 60
-------
"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 40 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 40: Fuel Allocator Worksheet
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 61
-------
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.7
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 41: 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. 62
-------
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, click
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 click
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 63
-------
(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 42. (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 42: 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. 64
-------
(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 43, 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 E100 equivalents
will be based on a percentage of the total gallons of gasoline you enter
on the Activity Information screen.
f Use national average for ethanol usage (9.05%)
<* Enter actual ethanol usage figures
Blend
Percentage
E10
ESS
Total
Gallons
E100
Equivalents
Total Gallons
Used
100,000
12,000|
112.000
20.200
ZOOM IN
Screen
Demo
Page 37
Figure 43: Ethanol Blend Worksheet
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 65
-------
STEPS FOR COMPLETING THE "ETHANOL BLEND WORKSHEET "
Input Ethanol
1. If this fleet has used ethanol, select the •••••••••I 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.
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.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 66
-------
The Payload Calculator displays up to three screens.
The first screen is labeled "Step 1: Getting Started." See Figure 44 below.
Smart Way 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
Select an allocation method, choose your preferred units, and indicate your data source:
Method: I * °f mi'es in this class
Data Source: (Electronic
Page 40
Figure 44: 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
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 67
-------
• # vehicles by class
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 45 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 Z: Body Type
Class Avg Payload:
Dry Van - Single
Dry Van • Double
Dry Van - Triple
Combination Reefer
Total: f
Total Entered on Main Entry Form: I 19,946,823 ^° Matcn
SCROLL FOR MORE
OPTIONS
Screen
Demo
Page 40
Figure 45: 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. 68
-------
If you specified the "Used ranges provided by the calculator" option under "Data Source" in Step 1, select
from pre-defined Ranges 1-5(1 being the lowest payload range values available and 5 being the
highest).8 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 5 (extreme high) values are selected, the value will be highlighte
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 4 (moderately high), the selection will be highlighted in
yellow and a warning will appear. Text explanations are optional for Ranges 2 and 4.
If an exact value entry falls outside the expected (Range 3) values, an explanation will be requested.
Figure 46 shows Step 2 of the Average Payload Calculator worksheet for Class 8b vehicles. (Similar
worksheets are provided for each truck class.)
Specific range values were determined based on reported industry payload distributions, and are discussed in detail in the Truck Tool Technical
Documentation.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 69
-------
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: 46: 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. 70
-------
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 payload 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 Payload from 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. 71
-------
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. Click 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. Click
7. Click the "Step 2: Body Types" tab or
8. Check 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. Click the I •jjfl | button to perform a final validation check and return to the Activity
Information screen.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 72
-------
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 47 shows an example worksheet for Class 8b vehicles.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 73
-------
SmartWay Average Capacity Volume Worksheet
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
f~ Number of Truckloads/Year
1 Number of Trailers
Percent Total
100
Data Source: [Records]
Estimated Average
Capacity Volume (cu ft):
mm
Box Trailers
Chassis
Tankers
28-foot
40-foot
42-foot
45-foot
46-foot
53-foot
57-foot
28+23
40+40
48+28
48+43
28+28+28
20-foot
40-foot
45-foot
48-foot
53-foot
Large (7500+ gallons)
Medium (3001-7499)
Small (3000 & under)
OTHER
100
Other Trailers (e.g., flatbed,
autocarrier, etc.)
Custom Size
Percent
Bulk Carriers
cuft:
Large (42'x 3.5'xl 1.5')
Medium (32' x 8' x 11')
Small (22' x 8' x 10.25')
Page 42
Figure 47: 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 use "Other" trailer types not specified, include both the average volume of the trailers in cubic
feet under "Custom Size/' as well as the reporting basis value. 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. NOTE:
If you operate flatbeds enter your trailer information here under the "Other" category.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 74
-------
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
1. Click the
Calc Volume
button to open the Capacity Volume Calculator screen.
2. Click — • 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 Kllfl I to return to the Activity Information Screen.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 75
-------
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
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. 76
-------
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,9 adjusted for the Highway/Rural Driving percentage specified.
(For further details, see the Truck Carrier Tool Technical Documentation available at
http://epa.gov/smartway/partnership/trucks.htm)
STEPS FOR COMPLETING THE ROAD TYPE/SPEED CATEGORY SECTION ON THE "ACTIVITY
INFORM A TION" SCREEN
1. Click lUUJ 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 BIB I to return to the Activity Information screen.
Enter Speeds
4. For each truck class, select •iMigyiftiaij 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 ••• to return to the Activity Information screen.
9 NOx and PM emission rates for diesel, gasoline and E10 vehicles are obtained from EPA's MOVES 2010b 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. 77
-------
AVERAGE ANNUAL IDLE HOURS PER TRUCK SECTION OVERVIEW ON THE
"ACTIVITY INFORMATION" SCREEN
The Average Annual Idle Hours per Truck10 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 48 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 48: 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.11 After you have entered long and short duration idling hours and
10
Idle hours are not applicable to hybrid or electric trucks, so the Idle Hour Calculator is not provided on those
screens.
11 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. 78
-------
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. Click IUUJ 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. Click I BiM • to return to the Activity Information Screen.
Calculate Idle Hours Per Truck (All Classes)
4. Click 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. Click I Bifl I to return to the Activity Information Screen.
7. You have now completed the Activity Information Screen for this fuel type.
8. Click the •SuSfc | 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. 79
-------
"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 49: 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. 80
-------
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
VALIDATE
SCREEN
to make sure you have filled out everything properly on this
screen.
5. Select the
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. 81
-------
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),
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://epa.gov/smartway/partnership/trucks.htm) 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 50: Validation Check Notification - No Errors
If missing or potentially erroneous inputs are identified, you will see the following message (Figure 51).
Select Yes to see a complete list of validation errors/warnings. An example Validation Check results
screen is provided in Figure 52.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 82
-------
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 51: 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 52: 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. 83
-------
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 53. 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
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 or Biodiesel (Binn Equivalents)
7 I Average Payload (tons) - Cargo Weight Only | 17.3
2] Average Capacity Volume (cubic Feet)
J?J ti> Capacity Utilization (excluding empty miles)
J? Road Type / Speed Categories | Collected
* Indicates that default speed distributions were selected for urban road types.
? Average Annual Idle Hours per Truck
Calculate Idle Hours Per Truck (All Classes)
Screen
Demo
Page 20
Figure 53: 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. 84
-------
• 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.
• "% 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 54. 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. 85
-------
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 54: 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. 86
-------
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.
Smart Way Truck: Home
SmartWay
Report Year
2013
Truck
United States Version: 2.0.13
Released on: 1/1/2014
Please complete the following steps. Check boxes on the left indicate successful completion
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
|ABC Trucking, Inc.
2.
3.
Enter Contact Information
Characterize your Fleets
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
.ABC^ruc^ng^Incj..^^^^^^^..-.^^^^.^^^^^^^ Warnings)..
Ali'_ lnj'Jjny, UK,; L'ray Heel - Nut Clieded
5.
6.
Updated fleet
status indicator
Review Year-to-Year Comparison
Partner Profile / Logo Info / Suggestions
View Your Data Reports
* After felecting this option, be fare to carefully read ail directions before proceeding.
Screen
Demo
Page?
Figure 55: 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. 87
-------
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 56 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 57.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 88
-------
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.)
Finally, select RUN REPORT to generate the report.
1. Load Data from Prior Year:
Year 1: 2013
Year 2: 2012
2. Select Units For Displaying Fuel-Related Information:
? I Display Fuel in: | Actual U.S. Gallons
Load Data
Diesel Gallon Equivalents
asoline Gallpn Eguiyalents
3
3. Choose Comparison Level:
(• Partner-Level
T Fleet-Level
Select a fleet from each of the lists below that you would 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 Year 1:
Fleets for Year 2:
Page 45
Figure 56: Year-to-Year Comparison Report Input Screen
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 89
-------
SmartWay: Load Data
Use the Browse button to navigate to your 2012 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) 214-4767.
Year: \2012
Truck Tool:
Browse..
Figure 57: 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 58.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 90
-------
•SmartWay
|Comparison 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
COi grfutilized 1000 cuft-mile
Change
V.
•7.054
4.854
•14.254
•4.854
•4.854
-1.554
-4.154
22.354
-0.454
4.2X
0.0/i
100.0K
O.OX
50.0K
•?.OJi
-10.6X
-13.4X
8.9/i
•14.7X
•15.3X
30.1K
30.154
•7.854
•14.754
-4.6X
B.3K
23%
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
DrayageH Mined
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 t Mixed
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
S6K
5.71
101,235
13.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
98
729
811
' Diesel Gallon Equivalents
Figure 58: Example Year-to-Year Comparison Report
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 91
-------
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. 92
-------
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 59).
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 59: 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 603 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. 93
-------
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 InformationABC Trucking, Inc
Partner Information
Suggestions
The SmartWay Partner Logo is available to all Partners in good standing within the SmartWay program. To he 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. If your company is interested in obtaining the
tractor and/or trailer logo for your trucks, you must obtain approval from the SmartWay Brand Manager Joann Jackson-Stephens (713-214-4276;
Jackson-Stephens. joann@Epa .go v)
SmartWay Partner Logo Information
Partner Name: ABC Trucking, Inc.
SmartWay Partnership Logo
The SmartWay PARTNER Logo is provided at the company level.
:! h.Y/f 11 •.id the -m.-n tVvViy I n.jo i ise Guidelines: webpage
f~ I have read the SmartWay Logo Graphics Standards and Usage Guide (on webpage)
I I agree to SmartWay's PARTNER Logo use guidelines (on webpage)
Partners that submit their annual updates on time will be able to download
the SmartWay Logo digital files in the SmartWay partner portal at:
http://www/SmartWayLogoWebSite.com
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)
F My website
T Marketing materials
l~~ Internal company materials
l~~ Business Cards
P Advertising
SmartWay TRACTOR Logo
View the SmartWav Designated Tractor specifications
p IF my tractors meet the SmartWay designated specifications., send me the digital
TRACTOR Logo files.
p If my tractors meet the SmartWay designated specifications, I agree to SmartWays
TRACTOR Logo use guidelines, (on web page)
r~ 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
View the SmartWav Designated Trailer specifications
|— If my trailers meet the SmartWay designated specifications, send me the digital
TRAILER Logo files.
p If my trailers meet the SmartWay designated specifications, I agree to SmartWay's
TRAILER Logo use guidelines, (on web page)
Page 50
Figure 60: Logo Qualification Screen
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 94
-------
Figure 61 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 InformationABC 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 61: 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. 95
-------
Viewing Reports
Once you are ready to continue, select
the following screen:
Smart Way Reports
View Your Data Reports
to go to
Please select the report you would like to view.
Internal Metrics Report
Fleet Characterization Report
General Information Report
Truck Counts Report
Activity Information Report
Reefer Fuel Consumption Report
PM Reduction Report
Port Dray_ Program Report
Comments Report
Out of Range Report
Data Source Report
Partner Information Report
US / Canadian Operations Report
Estimates the CO2, NOx, and PM emissions for your fleets, You can view these estimates
based on truck class, fuel type, or fleet.
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.
Displays 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.
If you elected to participate in the Port Dray Program, this option will allow you to print out
a summary of your inputs and results.
Displays all of the comments that have been entered throughout the Tool.
Displays all of the the values throughout the Tool that were not within the expected range,
Displays all of the data source information you provided throughout the Tool,
Displays the partner information, logo qualification and suggestions you provided in Step 6.
Displays all of the data you entered in the US / Canadian Operations section.
Page 46
Figure 62: 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.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 96
-------
Internal Metrics Report
Select the 1^ ••"••"'••'•'•••••ggg I 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 63.
Smart Way Reports
Select the level of detail you wish to display
f* Display only totals
f Display details for each Fleet
(" Display details For each Truck Class
f Display details for each Fleet and Truck Class combination
f~" Display details for each Fuel Type
f~" Display details for each Fleet and Fuel Type combination
Page 47
Figure 63: 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 64 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. 97
-------
'SmartWay
Tool: True*
atpay option *1: Totals Onty
ft port Year: 2013
Partner: A EC Truer, ing. me
- 101:
CCS
TottTois
r: :a. vi '. :?5
Oriro perM lie
(Total
Grams, per
AMsras* Ply b ad
Tor-Mlle
(Total)
8ivnsper
Thousand Cubic
(Tolali
:• ra- : per
T l»L'M.n3 LrtlllEH
CublDF«lMlks,
(Total)
-•:sa<: V is
Owns »rMt»
(Loamd)
Grams t*r
-»-r;;: =: :::
TOE-M»
(LoadaS)
FOOtNlttS
(Lsanad)
Ooms par
T:*isace J [ME
->,f^~ .: V M
O^spe^MI^
":•?-! [HT
Avsras* =^ lose
Orjns p»r
-DK.V1II«
Oians par
TtoLicr: _-;lll=
ToUTons
(•10 rt
OrwBperMlte
ijot.1
Qr«ni per
swasffl Fay bad
TOB-MIH
(Tol*
Cli6 It FOOt-M Its
(Toted
FaotMBI
IJ-MiiM?
j T - : par
Tkoism Lt li*
jt!-[*
OnnperMlfe
(Tstal
Or«n& per
A«Fi-35 Pay b sJ
Ten-Mile
(T
OHHIS per Mile
Oonts per
wac* Pay toad
ToMlle
Owns per
O ens per
Ttjisir: -:!ll=-
Cublb F.M1-MIW
FWI
Tot* Tons
(Jfcor*
Tolll V !lK
CrinsperMlle
(Total
Qrtms- per
AV5H-5S Pay bad
Ten-Mile
fjotan
Onmsper
T hons-ird CublD
FeolMlles.
(Tolan
:- ra- : per
T rsjuniKl mills*)
(TotaD
...: sc« V ! :
Onni »rM e
(Loadad?
Orams p*r
•- .-K K
Orams p#r
FnUliki
C«Ule Fool-WK
T sv-- .; v .'M
OBBIS per Mile
Onns per
A vwa^* Pay load
Tot-MIe
Owns per
Fo«!JWIIes
Oomsper
Tl-jisir: _:!ll=-
Ctbls F»i.Mlles
Figure 64: Example of Completed Report
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 98
-------
Submitting Data to SmartWay
Congratulations! You are now ready to send your data to EPA.
Select the
Generate File to Send to EPA*
button, which will open the following screen.
Create submission file for EPA
SmartWay*
Report Year
2013
Truck
United States Version: 2.0.13
Released on: 1/1/2014
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 IB 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).
l"~ I understand and agree to the terms of this agreement
Page 52
Figure 65: 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 so, you must then
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.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 99
-------
Create submission file for EPA
SmartWay*
Report Year
2013
United States Version: 2.0.13
Released on: 1/1/2014
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. 3B01 - 3B12 (civil liability for false statements) and 31 U.S.C. 3729-33 (The False Claims Act).
W 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.
Are you an existing Partner in SmartWay?
Did you submit data last year?
Yes
(t
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 i—
were either the designated Primary Contact or Executive Contact in last year's submission, you can use the link below to NB34KD98
have your SmartWay ID emailed to you.
If you can't find your SmartWay ID, you can use the link below to have your SmartWay ID emailed to you providing that you are either the
Primary Contact or Executive Contact on record and that your email address hasn't changed. If you were designated as either the Primary
Contact or Executive Contact in last year's submission, you are probably a contact on record.
Email me my SmartWay ID
Vou are now ready to create your submission file. Please select the NEXT button below.
Screen
Demo
Page 52
Figure 66: Completed Submission File Screen
When ready, select NEXT to create a file with the following naming convention:
Truck_PartnerName_Year_ VO.xml 12
For example, Truck_ABCompany_ 2013 _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.
12
If you create the XML file multiple times the file name will increment each time (e.g., Truck_ABCompany_2013_V1.XMLforthe
second iteration, etc.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 100
-------
SmartWay*
Your Smart Way Submission File has been created. The fully qualified name is
C:\smartway\Truck_ABC Trucking, Inc_2013_VO,XML
The file is ready to be emailed to EPA.
YOU MUST RETRIEVE THE FILE FROM THIS FOLDER AND EMAIL IT TO EPA IN ORDER TO COMPLETE YOUR
SUBMISSION.
Please open a new email message, attach this new file, and send it to smartway_transport@epa,govj or to your
Partner Account Manager (PAM) if your company is an existing Smart Way Partner.
If you have any questions on this submission process, please contact the SmartWay Transport Partnership Call
Center at (734) 214-4767 or email smart way _transport@epa. go v.
PRINT
SCREEN
Figure 67: Instructions for Submitting xml File to EPA
Follow these instructions for submitting your .xml file 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 FILE.
NOTE: DO NOT DELETE YOUR EXCEL (XLS) TOOL-SAVE THIS FILE FOR YOUR REFERENCE.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 101
-------
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 2007).
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.
Si a "
Home Insert Page layo
-^ <£-
I
Formulas
>ata Review View Developer
,
Insert AutoSurn Recently Financial Logical Text Date & Lookup & Math More Name
Function * Used' * Time" Reference" & Trig" Functions" Manager^
Function Library D
1
2
Al
A
t
B
'
C
A
D
E
F
G
H
1
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 102
-------
Bookl - Microsoft Excel
'Trace Precedents jjjjShow Formulas
• Trace Dependents ^> Error Checking '
Watch
Remove Arrows * ^ Evaluate Formula window
Formula Auditing ^^9 \
^ ^
L
M
<
0
Cal
Of
*
r
.
culation
>tions -
[ZD
/
H Calculate Now
i^J Calculate Sheet
Automatic
Automatic Except for Data Tables
Manual
T
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.
btttopMm ME-im
PapuU*
kFOWtf
Proofing
SMt
Trust Cwt«r
a
• Jft CKangt opjions lelated 1o lor muia cakulabon pcrtormanu and MTW handling.
(C^Cj*CLii*barv oflti&nij
• "7"
'i\crtbg-M ^ jityUlon Eiublt {ttfHtnrc uKulttian
* iutoBJitft ^ti»lmu(n RHivtiani- LOO
AlltCHMtK CttCpt 1C' Jjjl J 1 Jf%i :-i checkuiQ
MMMMwMta
V C*|lM4rtt*ift«ftfl*4ilMVl*1 th#t H(1yfl in jtfi *«r«f V FaimuIJi-. rt^mriflttirt t*-lll n irr^nm
V UM«njistifvt t*ku)*ita co*j»ft ftHHAiU in tioiei •/ Unloved celli carUitantn^ rormuftti
V Ceils canliinmg %tan ftpiesenttd is J di^i F-Dimylds rel«nir-g ic pre^edMl tip an >/ &•(• trv)er«4 tn j la&i* it mgakd
[ w ] | mmO
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 103
-------
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".
D Microsoft Excel - Bookl
:Sj File Edit View Insert Format
KB ^ f*
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A
B
C
Tools | Data Window Help
V
Spelling... F7
Research... Alt+Click
Error Checking.,,
Shar
Shar
Prate
Onlin
;d Workspace
3 Workbook. .
ction
e Collaborate
>n ^
Formula Auditing t
Macro
Customize...
1
Options...
V
- & E - Si *l ! fll <> 100% , ,$
G
H
1
J
Options
Color International
View 1 Calculation !
1 0 Automatic
tj1 Automatic except tables
HH Iteration
Maximum iterations; IOC
Workbook options
@ Update remote reference
CH Precision as displayed
CH 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
is 0 Save external [ink values
Q Accept labels in formulas
OK Cancel
Office 2013 Text Display
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 104
-------
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.
G oa I fo r S ma rtWay pa rticipatto n: (3 0 0 0 cha ra cte rs 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. 105
-------
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. 106
-------
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 / Biodiesel 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 participate 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. 107
-------
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 recognize 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. 108
-------
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.13 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.
13
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. 109
-------
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.
See http://www.epa.gov/smartwav/partnership/drayage.htm for additional details regarding the
program. 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 Vehicle
CNG 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
198B- 1994- 2003- 2007-
1993 2002 2006 2009
Post-
2009
Total
Emissions (Short Tons)
C02 PM NOx
Untreated
DOC and CCV
Flow Through Filter
Diesel Particulate (PM Trap) [
Total Trucks
0 T 0 0 | 30
0 | 0 | 0 | 4
0 | 0 | 0 | 0
0 | 0 | 0 0 | 15 | 6 |
0 | 0 | 0 | 34 | 15 | 6 |
Reductions from APUs: 1
Reductions from SmartWay Tires: \
Reductions from LNG: 1
Total Emissions:
Baseline Emissions:
Total Change:
Percent Change:
30
4
0
21
55
10
15
0
1,338.6 0.9227 12.84
245.1 | 0.0861 | 1.71
0,0 | 0.0000 | 0.00
1,287.0 0.0025 3.51
3,370.7 1.0113 | 18.07
-67.4 | -0.0147 | -0.36
-18.4 0.0000 -0.10
0.0 0.0000 0.00
3,284.9 0.9966 17.61
3,370.7 2.8802 62.80
-85.8 -1.8835 -45.19
-2.5% | -65,4% | -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.
Truck Carrier Tool Data Entry and Troubleshooting Guide | P. 110
-------
4. Flow Thru Filter: Number of trucks retrofitted is obtained from the PM Reduction screen.
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. Ill
-------
Appendix B—Recommended Data Sources for Activity Data
Table 1 summarizes the standard Data Source categories available for selection for each data type.
Table 1: 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. 112
-------
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. 113
-------
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. 114
-------
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. 115
-------
|