Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Rail Partner 2.O.II Tool:
Data Entry G u ide ^^^M^^
2011 Data Year - United States Version
Part3 ^
oEPA
United States
Environmental Protection
Agency
-------
Transport Partnership
U.S. ENVIRONMENTAL PROTECTION AGENCY
Rail Partner 2.O.II Tool:
Data Entry Guide
2011 Data Year - United States Version
Part3
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-12-057a
Agency
September 2012
-------
Part 3: DATA ENTRY GUIDE
This guide is Part 3 of a three-part series designed to help your company participate fully in the
SmartWay Transport Partnership.
In Part 3, you will learn how to enter the company and fleet/division data you collected using Part 2 into
the SmartWay Rail Carrier FLEET Tool. This guide covers:
1. Downloading and setting up to tool to run properly
2. Basic organization of the SmartWay Rail Carrier FLEET Tool
3. Entering your data
4. Data validation
5. Viewing fleet/division performance summary data
6. Submitting data to SmartWay
7. Troubleshooting the tool
/|\ WARNING!
Completing this tool requires a considerable amount of information about your company, the divisions
that are joining SmartWay, and the fleets within those divisions. There are many sections and screens to
complete for each fleet/division that you operate. 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 Part 1 to understand key
information about joining the partnership and use Part 2 of this series to learn about the data
requirements and gather your data BEFORE attempting to use Part 3 to complete the tool.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 3
-------
Downloading and Setting up the Tool
About Microsoft Excel
Microsoft Excel is an electronic spreadsheet program used for storing and manipulating data. The
SmartWay Rail Carrier FLEET Tool was built using Microsoft Excel Forms.
Downloading the SmartWav Rail Carrier FLEET Tool
The tool can be downloaded from the SmartWay website at:
http://epa.gov/smartway/partnership/rail.htm
Please save the tool in a folder on your hard drive; this folder will house copies of your data and future
updates.
Security Settings for the SmartWav Tools
The following instructions should appear on your screen //you need to change your security settings
before running the tool.
Security Settings for Excel 2003 Users
Before you begin, be
sure to set your Excel \*",*" ~ ^j^S^T *\
security setting level to
"Medium."
1. When using
Excel 2003, on
the menu bar,
select Tools ->
Macro
-^Security.
Figure 1: Macro Drop-Down Menu
2. When that window opens, select Medium.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 4
-------
Select
| Security Level I Trusted Publishers
O Very High. Only macros installed in trusted locations will be allowed
to run. All other signed and unsigned macros are disabled.
O High. Only signed macros From trusted sources will be allowed to
run. Unsigned macros are automatically disabled,
(*} Medium. Vou can choose whether or not to run potentially unsafe
macros.
O 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 Dialog Box
To run the tool:
1) Save the tool to your computer in a folder on your hard drive; and,
2) Double-click on the file to open the tool.
You will see a security warning box appear (Figure 3).
Security Warning
"C: \Data\truckTool.xls" contains macros,
Macros may contain viruses. It is usually safe to disable macros, but if the
macros are legitimate, you might lose some functionality,
! Disable Macros I Enable
L^^^^^^^^^^^^J
Macros
II
More Info I
Figure 3: Security Warning Box
3) Select the Enable Macros button in the security warning box. The following screen
(Figure 4) should appear:
Rail Carrier FLEET Tool Users Guide Part 3 I P. 5
-------
RailTool-BK-2012-Q7-Q6_EPA.xls [Compatibility Mode] - Microsoft Excel
Review View
"on o Conditional Format Cell insert Delete Format
Formatting as Table Styles -
6
7
3
9
JO
11
12
13
14
15
16
17
_1B
19
20
21
22
jn
24
25
26
27
28
29
JO^
31
32
33
34
35
36
37
33
39
40
41
42
43
44
45
< ซ
Excel
Workbook
Background
Welcome to the SmartWay Rail Tool (released on 07/06/2012). This version of the Rail Tool encompases rail
freight movements.
Far additional Information such as the tool user guide, technical manual or other support
materials, select the button below:
Of call the SmartWay Helpline at: (734) 214-1767
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.
Provides instructions tor completing each screen
Allows you to add notes or clarifications (button becomes yellow if a comment exists)
Checks your data input for missing or hvalid information
Enlarges the text on the screen
Sends an image of the screen to your default printer
Provides additional information about data entry fields
NOTE: 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.
JUT
Figure 4: Rail Carrier FLEET Tool Welcome Screen
The part of the tool that you fill out resides in the gray, blue, and dark green forms that appear on the
screen. The Excel workbook that remains in the background - and which normally appears as a light
green screen as in Figure 4- is where all of the data you enter is actually stored. However, for the
purpose of your data entry, please do not enter data in the background workbook.
Security Settings for Excel 2007 Users
The default settings for Excel 2007 should enable you to run the tool without any changes. To run the
tool:
1) Save the tool to your computer; and,
2) Open the file, and select the "Options..." button that appears after the Security Warning
just below the menu bar (Figure 5). Detailed instructions are also provided on the screen
itself.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 6
-------
Insert
^ A
J* ซ
ซ. y |B ,
Clipboard E|i
Q Security Warning
-12 IA" A" ป =!|?" IP General
D- L. 4,- A Sป. ฃ- , -% ,||T..iฐ8|
Font 5 i Alignment r- Number 5
Conditional Format Cell ,.,, Sort & Find Si
Formatting- as Table- Styles- .^JFormat- J_- Fjtter, selert-
Styles Ce4ls Editing
Some active content has been disabled. Options...
.ฃ Security Settings for the SmartWay Models
i [Security Settings for the SmartWay Models
B
In order to run this application, you must have macros enabled.
For Excel 2007 Users: (Ifyou are using Excel 2003, please scroll down.)
If an "Options..." button appears in the menu bar above, follow these instructions:
1. Click 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 click 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. Click the Office button. This button appears in the top left corner of the screen in Excel 2007.
2. Go to Excel Options. Click the 'Excel Options" button in the bottom right corner of the pull-down menu:
ซ ป u Security Settings ' J
Figure 5 Security Warning Screen
3) In the Microsoft Office Security Options dialog box (Figure 6), choose "Enable Macros"
and select OK.
Microsoft Office Security Options
Security Alert - Macro
Select
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
Fife Path: C:\SnartWayVlail.xls
(*> Help rjrotect me from unknown content (recommended)
^O Enable this content
Open tile Trust Center
OK Cancel
Figure 6 Security Options Dialogue Box
Rail Carrier FLEET Tool Users Guide Part 3 I P. 7
-------
If you reach this point and the tool does not open, please review the "Software and Hardware
Requirements" on Page 7 of Part 1 of the guidance series. Otherwise, you may have your security set too
high. To adjust your security settings, select the Office 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 7):
Figure 7 Excel Options Drop-Down Menu
On the Excel Options screen, select Trust Center in the left navigation bar (Figure 8):
Popular
Formulas
Proofing
Advanced
Cu5tomize
Add -Ins
Trust Center
^ Change the most popular options in Excel.
Top options for working with Excel
0 Enable Live Preview
n Show Developertab m the Ribbon
0 Always use ClearType
Color scheme: Blue v
ScieenTip style: Showfeature descriptions in ScreenTps v
When creating new workbooks
Use this fon.t: Body Font
Font size: 11 .v|
Default view for new sheets: Normal View v
Include this many sheets: \3 ฃ]
Personalize your copy of Microsoft Office
User name: iMMeyward
L-ฐ^ 1 1 """' ]
Figure 8 Excel Options Drop-Down Menu
Rail Carrier FLEET Tool Users Guide Part 3 I P. 8
-------
When the Trust Center options display opens, select Trust Center Settings in the bottom right portion of
the screen (Figure 9):
Trust Center
Resources
Popular
Formulas
Proofing
5ave
Advanced
Customize
Add-In s
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
Customer Experience Improvement Program
Security & more
Learn more about protecting your privacy and security from Microsoft Office Online.
Microsoft Windows Security Center
Microsoft Trustworthy Computing
Microsoft Office Excel Trust Center
The Trust Center contains security and privacy settings. These settings help keep your computer
secure. We recommend that you do not change these settings.
Irust Center Settings,.
Figure 9 Trust Center Settings Screen
Rail Carrier FLEET Tool Users Guide Part 3 I P. 9
-------
Choose the setting "Disable all macros with notification" (Figure 10) and select OK.
Trust Center
Trusted Publishers
Trusted Locations
Add-ins
ActiveX Settings
Macro Settings
Message Bar
External Content
Privacy Options
BE
Macro Settings
l-or macros in documents not in a trusted location: ff~~ ~~\
O Disable all macros without notification 1 Select
O .Enable all macros (not recommended; potentially dangerous code can run)
Developer Macro Settings
n Trust access to the VBA project object model
| OK | Cancel
Figure 10 Macro Settings Screen
Now return to the directions on page 3 of this guide.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 10
-------
Basic Organization of the SmartWay Rail Carrier FLEET Tool
Understanding the Tool Format and
Structure
The SmartWay Rail Carrier FLEET Tool is
organized around (1) information screens, (2)
forms or worksheets, and (3) reports/summaries
that guide you through the process of joining the
SmartWay Transport Partnership and/or
providing your annual update to maintain your
good standing with the program.
Each screen or form opens up within a Microsoft
Excel spreadsheet. The screens generally look like
the one shown here:
Or email the Helpline at: smartway_transporte)epa,gov
Tool Help and Navigation
Throughout the tool, you wll see
buttons.
g familiar with these button? will make
:oming far
lompleting the tool easier and faste
Provides instructions for completing each screen
Allows vou 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
Provides additional information about data
y fields
NOTE: 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.
The name of each form appears at the top left-
hand corner of the screen, in white text on the blue window bar.
Figure 11 Opening Screen of Rail Carrier FLEET Tool
SmartWay Introduction
Title of Screen/Form
SmartWay9
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Figure 12 Screenshot of Title of Screen/Form
Each screen contains text instructions or information about the program. Where applicable, the screen
will also include buttons to link to the SmartWay website or other sections of the tool (e.g., the various
data entry screens); these buttons are shown in green with white text.
Go To Rail Tool Page of the SmartWay Website
Figure 13 Screenshot of Button Link in the Tool
The screens also contain navigation buttons to direct you through the tool.
Figure 14 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.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 11
-------
Reviewing the Introductory Screens
Before you reach your data entry section of the tool, you will move through three introductory pages that
allow you to review the basics of participation in SmartWay for rail carriers:
The "SmartWay Introduction" Screen
The "SmartWay Partnership Annual Agreement" Screen
The "Required Information" Screen
The features of these three screens are described below.
The "SmartWay Introduction" Screen
The SmartWay Introduction screen is the first window that appears when the tool is opened (Figure 15).
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.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 12
-------
SmartWay Introduction
-SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Introduction
Welcome to the SmartWay Rail Tool (released on 07/06/2012). This version of the Rail Tool encompases rail
freight movements.
For additional Information such as the tool user guide, technical manual or other support
materials, select the button below:
Go To Rail Tool Page of the SmartWay Website
Or call the SmartWay Helpline at: (734) 214-4767
Or email the Helpline at: smartway_transport@epa.gov
ADD/VIEW
COMMENTS
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.
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
Provides additional information about data entry fields
NOTE: 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.
Figure 15: SmartWay Introduction Screen
For your convenience, links to key Rail Tool resources are included here:
General SmartWay information:
o http://epa.gov/smartway/index.htm
SmartWay Rail Tool information:
o http://www.epa.gov/smartway/partnership/rail.htm
Rail Carrier FLEET Tool Users Guide Part 3 I P. 13
-------
The "SmartWay Partnership Annual Agreement" Screen
Partnership 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 emissions performance of your company using EPA's SmartWay Tool.
(Existing companies 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 posted on the EPA SmartWay website/database.
3. Agree to submit supporting documentation to EPA for any data used to complete this tool and agree to EPA audit of this data upon
request by EPA.
In return, EPA commits to:
1. Promote company participation in the Partnership by posting Partner names on the EPA SmartWay Website and in related educational,
promotional, and media materials. EPA will obtain express written consent from the Partner before using the Partner's name other
than in the context of increasing public awareness of its participation as described here.
2, Provide companies with industry-wide performance benchmark data as this data becomes available to EPA.
3. Assist Partners in achieving emission and fuel usage reduction goals (subject to Federal Government Appropriations).
General Terms
1. If the Partner or EPA defaults upon this agreement at any point, the agreement shall be considered null and yoid.
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 organization.
6. Subrnittal 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).
II understand and agree to the terms of this agreement;
Figure 16: SmartWay Partner Agreement
After selecting the ^^^^^^ button on the SmartWay Introduction screen, the SmartWay
Partnership Annual Agreement will appear. This screen replicates the agreement language found in Part
1 of this users guide series.
Submitting a SmartWay Rail Carrier FLEET Tool to EPA constitutes agreement to all terms in the
Partnership Annual Agreement, so please review this screen or the text version in Part 1 of this users
guide series before sending your tool to EPA.
To reach the data entry sections of the tool, you must agree to this language to join the SmartWay
Transport Partnership by selecting the check box at the bottom left of the screen.
SmartWay Rail Carrier FLEET Tool submissions are due on an annual basis; therefore, when you submit
your tool each year, this will constitute your renewal of your partnership agreement. Failure to send
your annual tool update will constitute a violation of the terms of the agreement and will result in
immediate removal of your company name/fleet from the SmartWay partner list.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 14
-------
NOTE: While in the past, SmartWay supported a lengthy warning process for partners that were
delinquent submitting their partnership materials, due to the large number of partners currently joining
and submitting materials to SmartWay, this level of customized service can no longer be supported.
The "Required Information" Screen
This screen provides a summary listing of the information you will need to collect to complete the
SmartWay Rail Carrier FLEET Tool. Each of these items is discussed in detail later in this guide. Please
refer to Part 2 of this guide series for a further discussion of the process used to gather the necessary
data for the tool.
SmartWay Rail: Required Information
SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Following is a brief description of the information you will need to complete the SmartWay Rail Tool. For further details,
please consult the SmartWay Rail Tool User Guide.
Partner Information
Company 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
Partner and Fleet Characterization Information
Partner and Fleet Names, Contacts
Fleet Class (1, 2, 3)
Fleet-Level Operations Profile
Power Unit Information:
Activity (# of units or hours/year)
- By type (line haul vs. switcher)
- By engine tier level
- Data source description
Locomotive Unit Miles/Year
- Unit, way, and through trains
- Train and yard switching
Railcar Information:
Railcar miles/year
- Owned/leased vs, private
- Loaded vs. empty
Railcar volume by type (Box, Gondola, etc.)
Operations Information:
Gallons/year
- Freight, passenger, switching
- By fuel type (diesel, biodiesel, LNG, CNG, electric)
Ton-miles/year
- Gross, revenue, non-revenue
Figure 17: Summary of Required Information
Once you have navigated through the three introductory screens, you will be taken to the SmartWay Rail
Carrier FLEET Tool Home screen.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 15
-------
Navigating the "Home" Screen
Figure 18 displays the structure of the Home screen.
Smart Way Rail: Home
SmartWay
Please complete the following steps. For more information, select the 'Help* button.
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
r
2. Enter Contact Information:
Go To Contact Information Screen
Report
Vear:
12011
3. Characterize Your Fleets:
Do To Fleet Characterization Screen
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
5. View Vour Data Reports:
Qo To Reports Menu
6. Create Final Version:
Generate File to Send to EPA*
*Be fare to read carefuffy the directions that appear when you select this option.
Figure 18: Main Tool Navigation or "Home" Screen
Rail Carrier FLEET Tool Users Guide Part 3 I P. 16
-------
From the Home screen, you can:
1) Specify your Partner Name;
2) Fill out company contact information;
3) Characterize your fleet(s)/division(s) and create your blank data entry forms;
4) Enter the required data for each fleet/division;
5) View results of your data entry; and
6) Create final version to submit to EPA.
There are six sections on the Home screen. Each section links to additional screens or worksheets within
the tool which are described below:
1. Enter Partner Name: Specify your company's Partner Name, exactly as you want it to
appear on the SmartWay website.
2. Enter Contact Information
a. Go to Contact Information Screen: 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.
3. Characterize your Fleets
a. Go to Fleet Characterization Screen: On this screen you will define all the
fleets/divisions 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/division.
4. Select Fleet for Data Entry
These screens ask for data relating to the performance and fleet/division
composition information necessary to calculate efficiency metrics for your
fleet(s)/division(s).
5. View Your Data Reports: Here you can see final summaries of your data including all
data inputs, fleet/division performance summaries, and a summary of entered
comments.
6. Create Final Version
Generate File to Send to EPA: This button creates a version of the tool 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 tool to
EPA; you still need to submit it to EPA by attaching it in an e-mail.
Entering Your Data
The first four sections of the home screen must be completed in order, and comprise all the steps needed
to complete your SmartWay Rail Tool. After they are completed, you can review your output and/or
submit your tool to EPA.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 17
-------
Saving Your Data
At any stage of the process above, you can save the data you have entered by selecting the "Save" button
that appears at the bottom of all screens (including the Home screen). We recommend saving your data
frequently if you are entering information for large numbers of fleets/divisions.
Validating Your Data
The SmartWay carrier tools include a variety of range checks and other validation rules designed to help
identify potential data entry errors and/or unusual data values. In order to identify potential problems
with your data entry and ensure the highest quality in your data submission, we highly recommend
selecting the "Validate Screen" button at the bottom of each screen after completion of each data entry
screen. The tool will then identify any potential data problems on that screen for you to modify or to
provide a text explanation.
Reviewing Your Data
Each screen within the tool has a ^HS3lsiB button. If you need a hard copy of introductory screen text
you may select this button to send a copy to your default printer. Selecting the ^BS3SB button on
data entry screens will direct you to a specific report under the Reports Menu. The data reports
provided by the Rail Carrier FLEET Tool are discussed in detail in the View Your Data Reports section of
this guide.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 18
-------
Entering Your Data
You must complete the first four sections of the Home screen in order. The next four sections of this
guide explain how to enter your data on each of the required and optional screens.
Section 1 Data Entry: Enter Partner Name
Here you must specify your company's Partner Name, exactly as you want it to appear on the SmartWay
website. For example, if your company's name includes "Inc." or "Ltd.", you may choose not to include
that in your Partner Name. Please also pay special attention to proper capitalization, abbreviations, and
punctuation.
SmartWay Rail: Home
SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Please complete the following steps. For more information, select the 'Help' button.
1. Enter Partner Name (Exactly as it should appear on the Smart Way website):
|Rail 1, Inc.
2. Enter Contact Information
Go To Contact Information Screen
3. Characterize Vour Fleets:
Go To Fleet Characterization Screen
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
5. View Vour Data Reports:
Qo To Reports Menu
6. Create Final Version:
Generate File to Send to EPA*
"Before to read carefuSy the directions that appear when you select this option.
Figure 19: Enter Partner Name on "Home" Screen
Report
Vear:
12011
Rail Carrier FLEET Tool Users Guide Part 3 I P. 19
-------
Section 2 Data Entry: Enter Company and Contact Information
PLEASE REFER TO WORKHEET #1: Company Contact Information from Part 2 of this guidance to
complete this section of the Rail Carrier FLEET Tool.
From the Home screen, select the button that says "Go to Contact Information Screen".
Smart Way Rail: Ha
SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Please complete the following steps. For more information, select the 'Help1 button.
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
|Rail 1, Inc.
2. Enter Contact Information:
Report
Year:
12011
Do To Contact Information Screen
3. Characterize Your Fleets:
Go To Fleet Characterization Screen
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
Select Contact
Information
5. View Your Data Reports:
Go To Reports Menu
6. Create Final Version:
Generate File to Send to EPA*
' Be sure to read carefully the directions that appear when you select this option.
Figure 20: Select Contact Information Button on "Home" Screen
Rail Carrier FLEET Tool Users Guide Part 3 I P. 20
-------
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 21). On this screen you will provide the
following information:
1. Company Information
2. Primary Contact information
3. Executive Contact (Vice President or higher)
4. Other Contacts
Partner Name
from Home screen
Partner Name*
Addressl*
Address2
City*
Main Phone*
Web Site*
2. Primary Contact: ? |
Name | 3 First* f
Title*
State* | Zl ZIP* f
Toll Free: |
Country*
MI
:F
Use Partner Address
Addressl*
Address2
City*
Phone*
Email*
3. Executive Contact: ? I
Name*
4. Other Contacts: "H
State* | J ZIP*
Ext: F Cell:
Country
Fax:
Same as Primary Contact
I
? |
Add/Edit Executive Contact
Required
Add New Contact
Edit Selected Contact I Delete Selected Contact
Figure 21: 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.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 21
-------
Steps for Entering Contact Information:
Enter the Partner Information in section #1.
Enter the Primary Contact information in section #2.
The primary contact is the individual designated by the Executive Contact to directly interface
with SmartWay regarding specific tasks involved in the timely submission of the tool. The
Primary Contact is responsible for coordinating the assembly of information to complete/update
fleet/division 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/EPA to their preferred list of trusted
sources.)
If the Primary Contact shares the same address as the company, you may select the
I button to auto -populate the address section of this record.
Use Partner Address
Enter the Executive Contact information in section #3 by selecting the
jutton to the right; enter the required data.
Add/Edit Executive Contact I
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 the timely submission of the tool to SmartWay. The Executive
Contact also represents the company at awards/recognition events. This person should be a Vice
President or higher level representative for the company.
If the Primary Contact and Executive Contact are one in the same, simply check the
Same as Primary Contact box tQ auto.popu|ate the Executive Contact information.
Add New Contact
Enter Other Contacts (if applicable) in section #4 by selecting the
button. A new contact field will appear, labeled Other Contact Information (not pictured).
Enter the first Other Contact then select OK when done.
hlMOTE: In some cases, companies with multiple divisions/business units will gather
information from different sources within the company. You may find it useful to have
this additional contact information stored within the tool. Also, anyone who is the
Primary Contact for a particular fleet/division (who is not also either the Primary or Executive
Contact) will need to be entered as an Other Contact. This will be important in Step 3 (Fleet
Characterization).
Rail Carrier FLEET Tool Users Guide Part 3 I P. 22
-------
You can add more names to the Other Contacts box by repeating this process. If you wish to edit an
existing contact's information, highlight the name you wish to edit and then select the
Edit Selected Contact
button.
You can remove an existing contact by highlighting the contact and then selecting Delete Selected
Contact.
3. Executive ^ Same as Primary Contact _LJ
To make sure you have filled out all required
contact information, select
VALIDATE
SCREEN
Contact* [jack Small
at the 4- Other Contacts:
bottom of the screen. If any information is
missing, a dialogue box will appear informing you
what additional information is required.
Add New Contact
Edit Selected Contact
* - Required
When finished select the
button to return to the Home screen and go to Section 3.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 23
-------
Section 3 Data Entry: Characterize your Fleets
PLEASE REFER TO WORKHEET #2: Fleet/Division Characterization of Part 2 of this guidance to complete
this section of the Rail Carrier FLEET Tool.
Next, on the Home screen select ^^^^ II to display the Fleet
Characterization screens. This is the section where you will define the various components of your
fleets/divisions.
The Fleet Characterization screen is shown below:
SmartWay Rail: Fleet Characterization
SmartWay will list your company's fleet name(s) on the SmartWay website to indicate your participation in the SmartWay program. On the website, each
name will begin with your Partner Name, fallowed by your Fleet/Division Identifier.
In the first row below, edit the Partner Name so that it appears exactly as it you want it to show within each fleet name. For example, if your company's
name includes "Inc." or "Ltd.", you may choose not to include that in your fleet names. Next, name your fleet(s) exactly as you want them to appear on
the SmartWay website, recognizing that they will automatically receive your company name as a prefix. If your company has only one fleet, you may leave
the Fleet/Division Identifier field blank, in which case the fleet name will simply be the Partner name.
ONLV ENTER FLEETS IN VDUR COMPANY THAT A CUSTOMER WOULD HAVE DISCRETION TO HIRE. DO NOT INCLUDE INTERNAL DIVISIONS THAT ARE INVISIBLE
TO YOUR CUSTOMERS.
Select the Class for the fleet (1, 2, or 3) and the Fleet Contact person from the remaining drop-downs.
To add fleets, simply select the "Add Another Fleet" button at the bottom of the screen. Note that when you do this, the partner name portion carries
forward from the first row.
Delete Partner Name
F Pi"" Iftail 1, Inc.
Fleet/Division Identifier
SmartWay Website Fleet Name
Rail 1, Inc.
T Bruce Jenkins
Figure 22: Blank Fleet Characterization Screen
Steps for Completing Fleet Characterization Screen:
For each fleet/division, you will need to specify:
Partner Name: On the SmartWay website, each of your fleet/division names will begin with the
name of your company. This fleet/division "prefix" will be whatever you enter in the Partner
Name field on the tool screen. By default, this field is automatically populated with the first 50
characters of the Partner Name that is entered on the Home screen. You should specify the
name so that it appears EXACTLY as it you want it to show within each fleet/division name. (For
Rail Carrier FLEET Tool Users Guide Part 3 I P. 24
-------
example, if your company's name includes "Inc." or "Ltd.", you may choose not to include that in
your fleet/division names.) Please pay special attention to proper capitalization, abbreviations,
and punctuation.
Fleet/Division Identifier: Specify each fleet/division identifier exactly as you want it displayed on
the SmartWay website, including proper capitalization, any abbreviations, and punctuation.
Remember that it will automatically be combined with the Partner Name field.
Class: Enter the Class of the associated rail fleet/division (1, 2, or 3).
Fleet Contact: This contact should be one of the contacts you already identified in the Contact
Information section as the contact for each fleet/division. NOTE: A drop-down menu in the tool
will supply this information; if there is a contact for the fleet/division that is not already listed in
the Contacts worksheet, you will need to go back to that screen to add the required contact
information.
Adding Fleets/Divisions
To enter another fleet/division, select the "I button. To delete a fleet/division, select the
box next to the row you wish to delete, and then select the (JllJiiilllJiitfl button.
Once you have confirmed or modified the Partner Name and specified the Fleet/Division Identifier, the
full SmartWay Website Fleet Name will be displayed on the screen to the right, exactly how they will be
displayed on the SmartWay website.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 25
-------
SmartWay Rail: Fleet Characterization
n. On the website, each
Smart'
name will begin with your Partner Name, followed by your Fleet/Division Identifier.
In the first row below, edit the Partner Name so that it appears exactly as it you want it to show within each fleet name. For example, if your company's
name includes "Inc." or "Ltd.", you may choose not to include that in your fleet names. Next, name your fleet(s) exactly as you want them to appear on
the SmartWay website, recognizing that they will automatically receive your company name as a prefix. If your company has only one fleet, you may leave
the Fleet/Division Identifier field blank, in which case the fleet name will simply be the Partner name.
ONLY ENTER FLEETS IN YOUR COMPANY THAT A CUSTOMER WOULD HAVE DISCRETION TO HIRE. DO NOT INCLUDE INTERNAL DIVISIONS THAT ARE INVISIBLE
TO YOUR CUSTOMERS.
Select the Class for the fleet (1, 2, or 3) and the Fleet Contact person from the remaining drop-downs.
To add fleets, simply select the "Add Another Fleet" button at the bottom of the screen. Note that when you do this, the partner name portion carries
forward from the first row.
Delete Partner Name
*]
FT" |Rail 1, Inc,
ra i, inc.
Fleet/Division Identifier
SmartWay Website Fleet Name
Rail 1, Inc.: Eastern
T Bruce Jenkins
Rail 1, Inc.: Western
ruce Jenkins
Final Fleet Names
Figure 23: Example Fleet Name Definition
Remember to create separate fleets/divisions for each entity your customers have
discretion to hire.
Adding Comments/Notes
Creating useful 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.
Please note the
ADD
COMMENTS
I button located at the bottom of the screen. This allows you to
enter notes about the collection process, your assumptions and methods, data, or other information.
These details could prove useful for your reviewer when you or someone else fills out the tool next year.
If comments have been added for a particular screen, the
ADD
COMMENTS
I button will be highlighted in
Rail Carrier FLEET Tool Users Guide Part 3 I P. 26
-------
yellow on your screen and will now read
comments to be read.
VIEUI/EDIT
COMMENTS
to indicate to your reviewer that there are
A ^^^^^^* button is also available should you need assistance. You will also notice small gray icons
with question marks [?] displayed throughout the tool. When selected, these icons provide additional
information about specific items located on the screen.
If, at a point later in the data entry process, you realize that you need to add a new fleet/division or
delete an existing fleet/division, you can return to the Fleet Characterization screen. To add a new fleet,
follow all of the instructions on the screen regarding defining your fleets/divisions, including selecting the
CREATE
FLEET(S)
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) /division(s) you have added; the existing fleets will not be
affected.
If you need to delete an existing fleet/division, simply check the box next to the fleet/division and then
select the Delete Checked Rows button.
As on the other screens there is a
button as well as an
ADD
COMMENTS
button. Selecting
will take you back to the Home screen (see Figure 24).
Rail Carrier FLEET Tool Users Guide Part 3 I P. 27
-------
Reviewing Fleet/Division Status
On the Home screen, you will now see all the fleets/divisions you created listed in the window below
item # 4: Select Fleet for Data Entry.
Smart Way Rail: Home
SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Please complete the following steps. For more information, select the 'Help' button.
1. Enter Partner Name (Exactly as it should appear on the SmartWay website):
Rail 1, Inc.
2. Enter Contact Information:
Report
Year:
12011
Go To Contact Information Screen
3. Characterize Vour Fleets:
Do To Fleet Characterization Screen
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
Rail I, Inc.: Eastern - Not Checked
Rail \, Inc.: Western - Not Checked
Fleet/Division
File Status
Indicators
v /
5. View Vour Data Reports:
Go To Reports Menu
6. Create Final Version:
Generate File to Send to EPA"
"Be sure to readcarefuffy the directions that appear when you select this option.
Figure 24 Home Screen - Fleet/Division Status Prior to Activity and Fuel Data Entry
There will be a status message after each fleet/division, indicating whether or not the data entry for that
fleet/division is complete. The following information may appear beside a fleet/division name:
Not checked - Data has not been entered yet.
Incomplete - Some data is still missing and/or inconsistent.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 28
-------
Complete - All data requirements have been met and validation has occurred.
In addition to the status indicators above, you may also see an "Error" qualifier. Errors will prevent you
from generating the Internal Metrics Reports and must be addressed before you can submit your tool to
EPA.
To add data to a particular fleet/division file, highlight the fleet/division name and then double-click. You
will then proceed to the tool Data Entry Screens.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 29
-------
Section 4 Data Entry: Enter activity and fuel consumption information for each of
your fleets/divisions
Steps for Completing Power Units Screen
At this stage, you will be entering information about each fleet/division separately. For each
fleet/division you will first fill out the Power Units screen, shown below in Figure 25.
Rail Tool: Rail 1, Inc.: Eastern
Power Units
Cars
Operations
Please enter information on your power units. Select the data entry method (1 through 4) for part A, and then fill out the required information in the
boxes provided. Next fill out the part B data. Finally, describe the sources for all the data on this page in the text area below.
Part A: Power Unit Inventory
Select Data Input Method
<~ 1, # of total Power Units
r" 2. # Power units - line haul vs. switch
f" 3. hours per tier
* !-}, liuurs |jui l:iui jirnj li.juldinJ L.',".'iLi.ti.
Part B. Total Locomotive Unit Miles/Vear
7 Unit Trains
Way Trains
Through Trains
Subtotal
Engine Tier
Total Hours per Tier/Year
Line Haul Switch
j Train Switching
Yard Switching |~
Subtotal
Total
I
Describe the source of information used to generate the user input values
3000 characters remaining
Figure 25 Power Units Screen
PLEASE REFER TO WORKHEET #3: Power Units in Part 2 of this guidance to begin data entry for this
section of the Rail Carrier FLEET Tool. Use the instructions below if you have questions about filling in the
data. When using Methods 2, 3, or 4, it is recommended that you break out power units by year of
engine build or rebuild rather than locomotive model year, as using locomotive model year will likely
overstate your NOx and PM emissions.
NOTE: If you are a new SmartWay partner you should enter the most recent 12 months of data
into the tool. If you do not have a full year of operational data, please collect a minimum of
three months' data for input into the SmartWay tool. In your next update year, you will be
required to submit a full year's data.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 30
-------
First, select your Data Input Method. You may select from four input methods, depending upon the type
of data you have available. Methods 1 and 2 only require the input of the number of power units by
engine tier level. Under method 1 you may aggregate your fleet's line-haul and switch units together,
while method 2 requires that you report the unit type counts separately. Methods 3 and 4 are similar,
but require inputting hours of operation by tier, rather than unit counts. In general, method 4 will
provide the most accurate estimate for NOx and PM emissions.
After selecting your preferred Data Input Method, please enter the tier-level data in the cells at the
lower left of the screen. These data are used to estimate your fleet's NOx and PM emission performance
levels. (See the Rail Tool Technical Documentation for details regarding emission performance
calculations.) The different engine tier level definitions are provided in the ? help text to the left of the
cells.
Next, enter your fleet's Total Locomotive Unit Miles/Year data under Part B. Break out your unit miles
data by line haul and switching categories, as appropriate. Finally, enter a detailed description of the
data sources used to obtain your power unit data (e.g., R-l Form section and line numbers for Class 1
carriers).
You can select the
VALIDATE
SCREEN
button to make sure you have filled out everything on this screen
VALIDATE
FLEET
properly. You can also select to check your data entries across all screens for the given
fleet. Any data entry gaps or inconsistencies will be identified by the software. However, if validating the
fleet/division, note that you will receive additional validation errors unless you have completed the data
entry for all screens.
Once your Power Units data has been validated as complete and correct, select the ' button
or select the Cars tab at the top of the screen to proceed.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 31
-------
Steps for Completing Power Units Screen
PLEASE REFER TO WORKHEET #4 in Part 2 of this guidance to complete this section of the Rail Carrier
FLEET Tool.
Rail Tool: Rail 1, Inc.: Eastern
Power Units
Operations
Please enter information on railcar miles below. These data are identical to those provided in Rl report section 755. You may enter your company-
specific car volume data by selecting the Review/Update Volume Data button below.
Total Railcar Miles/ Year
Box - Plain 50'+
Box Equipped
Gondola Plain
Gondola Equipped
Hopper Covered
Hopper Open Top - General
Refrigerated Mechanical
Refrigerated Non-Mechanical
Flat TOFC/COFC
Flat Multi-Level
Flat General Service
Flat All Other
Tank Under 22,000 gallons
Tank Over 22,000 gallons
All Other Cars
Work Equip & Company Freight
No Payment Car-Miles
Owned and Leased
Loaded Empty
Empty
Review/Update
Volume Data
[Currently using Default
volume data]
Figure 26 Cars Screen
Enter your fleet's annual railcar miles for the reporting year on this screen, by car type (e.g., box,
gondola, etc.) and ownership type (Owned/Leased or Private). These data may be obtained from Rl
Report Section 755. If available you can also provide fleet-specific railcar volumes by car type, by
selecting the Review/Update Volume Data button (see Figure 27).
Rail Carrier FLEET Tool Users Guide Part 3 I P. 32
-------
Smart Way Data Volume by Car
Below are the default volume data by car type that will be used in
calculations. These values reflect national averages across Class 1 carriers -
see the Rail Tool Technical Documentation for details.
If you would like the Tool to use a different value, enter value(s) in the
Fleet-Specific column; the default value will be used for any car type where
an override value is not provided. Click OK to save and return or Cancel to
return without saving changes.
Default Values
(tuft)
Fleet-Specific
Values (cu ft)
Box - Plain 40'
Box - Plain 50'+
Box Equipped
Gondola Plain
Gondola Equipped
Hopper Covered
Hopper Oper Top - General Svc
Refrigerator Mechanical
Refrigerated Non-Mechanical
Flat TOFC/COFC
Flat Multi-Level
Flat General Service
Flat All Other
Tank Under 22,000 gallons
Tank Over 22,000 gallons
All Other Cars
Work Equip 8t Company Freight
No Payment Car-Miles
4,555
7,177
7,177
5,190
5,190
4,188
4,220
6,202
6,202
6,395
13,625
6,395
6,395
2,314
3,857
5,014
5,014
5,014
7,280
3,950
7,700|
Figure 27 Volume by Railcar Type
The Volume by Car screen shows the default (Class 1 national average) railcar volumes used in the Rail
Tool. (See the Rail Tool Technical Documentation for the sources of this data.) The railcar volume data
from this form will be used to estimate the grams per truck-equivalent mile performance metrics for your
fleet. You may enter your own fleet-specific volume data in the right hand column in order to override
the default values.
Once your Cars data has been validated as complete and correct, select the
select the Operations tab at the top of the screen to proceed.
' button or
Rail Carrier FLEET Tool Users Guide Part 3 I P. 33
-------
Steps for Completing the Operations Screen
PLEASE REFER TO WORKHEET #5 in Part 2 of this guidance to complete this section of the Rail Carrier
FLEET Tool.
Rail Tool: Rail 1, Inc.: Eastern
Power Units
Operations
Please fill out the required information below. The Ton Mile data are identical to those provided in Rl report section 755. Report line numbers are
referenced below.
All Freight
Fuel Used
Freight
Passenger
Switching
Total
Diesel ?
(gallons/year)
I I I
Biodiesel:B| ^?J
(gallons/year) |
I I I
LNG
(gallons/year)
I I I
CNG
| (cubic feet) JjJ |
I I I
Electric
(kWh/year) |
I I I
Gross Ton Miles/Year
Revenue Freight Ton Miles/Year
\
Non-Revenue Freight Ton Miles/Year [
Rl: 755-104
Rl: 755-110
Rl: 755-113
Figure 28 Operations Screen
You will enter your fleets annual fuel consumption and ton-mile data on this screen. First enter annual
fuel use per year by fuel type (diesel, biodiesel, LNG, CNG, and electric) and train category (freight,
passenger, and switch). Petroleum diesel, biodiesel, and LNG entries must be in gallons per year. Specify
your CNG units using the associated drop-down menu, indicating standard cubic feet or gasoline-
equivalent gallons per year. Electricity use is specified in kWh/year.
If you enter biodiesel consumption data, you must also specify the blend level (between 0 and 100) in the
cell to the left.
Next, enter your gross, revenue, and non-revenue ton-mile data at the bottom of the screen. The
corresponding Rl form section and line numbers for these data are indicated on the screen.
Once your Operations data has been validated as complete and correct you may return to the Home
screen.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 34
-------
Viewing Your Fleet Status
Once you have returned to the Home screen, notice that the fleet for which you provided data now
identifies its status as "Complete." You may now highlight the next fleet if you have another one to
complete. Fill out unfinished fleets in the same manner as the previous fleet.
Smart Way Rail: Home
SmartWay
Rail
United States Version: 2.0.11
Released on: 07/06/2012
Please complete the following steps. For more information, select the 'Help' button.
1. Enter Partner Name (Exactly as it should appear on the SrnartWay website):
|Rail I, Inc.|
2. Enter Contact Information:
Go To Contact Information Screen
Report
Vear:
I 2011
3. Characterize Vour Fleets:
Go To Fleet Characterization Screen
4. Select Fleet for Data Entry (Double-click the fleet name or select and hit Enter):
Rail lj Inc.: Eastern - Complete
Rail 1, Inc.: Western - Not Checl
Updated Fleet
Status
Indicator
5. View Vour Data Reports:
Go To Reports Menu
6. Create Final Version: ?
Generate File to Send to EPA*
1 Se sure to read carefully the directions that appear tvhen you select this option.
Figure 29 Home Screen after Data Entry for First Fleet
Rail Carrier FLEET Tool Users Guide Part 3 I P. 35
-------
Viewing Reports
Once you are ready to continue, select
which will take you to the following screen:
Go To Reports Menu
from the Home screen
SmartWay Rail: Reports
Please select the report you would like to view.
Internal Metrics Report
Fleet Summary Report
Power Units Report
Cars Report
Operations Report
Comments Report
The Internal Metrics Report presents your fleet-level
CO2, NOx, and PM performance, expressed in grams per
ton-mile (gross, revenue and non-revenue), and grams
per mile (railcar and truck-equivalent miles).
The Fleet Summary Report presents the name, Class
and contact for each fleet defined.
The Power Units Report displays all of the data you
entered in the Power Units Information section.
The Cars Report displays all of the data you entered in
the Cars section.
The Operations Report displays all of the data you
entered in the Operations section,
The Comments Report displays all of the comments that
have been entered throughout the tool.
Figure 30 View Fleet Reports Screen
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 Power Units, Cars, and
Operations Reports.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 36
-------
E: The Comments Report allows you to review any notes and comments made during the
compilation of the different data inputs throughout the tool. These comments can provide a
useful reference for documenting data sources and assumptions, as well as for preparation of
subsequent year submittals. In addition, you can use this report to view questions and
comments from your Partner Account Manager after they receive and return your tool.
Select the
Internal Metrics Report
button to review the performance of your fleet(s) in terms of
grams per ton-mile (gross, revenue and non-revenue), and grams per mile (railcar-mile and truck-
equivalent mile), by pollutant type.
If you have defined multiple fleets, a drop-down box will appear allowing you to select the desired fleet
for a given report type (see Figure 31 below).
SmartWay Rail: Reports
Choose the appropriate fleet from the drop-down and then select OK to run the report:
| Rail 1, Inc.: Eastern *[
FRaill,Inc."western
Figure 31 Fleet Selection Screen - Reports Menu
Rail Carrier FLEET Tool Users Guide Part 3 I P. 37
-------
Submitting Data to SmartWay
Congratulations! You are now ready to send your data to EPA.
Generate File to Send to EPA1
button, which will create a file with the following
Select the
naming convention:
PartnerName_ Year_Rail_VO.xls
For example, Rail 1_ 2012_Rail_VO.xls
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.
The system will display a message indicating that an Excel file will be created with your company's
name as part of the file name. The file will be saved to the same folder where the tool itself is currently
saved. You will need to locate the file and attach it in an e-mail to your Partner Account Manager
(PAM).
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.
The system will first display a message asking you to confirm your decision to save a copy of your tool on
your hard drive (Figure 32).
i j Select OK to automatically create a new Excel file with your company's name as part of the File name, which will enable EPA to better track and identify
ff your submitted data,
You will need to EMAIL this new file to EPA.
If you have any questions on this submission process, please contact the SmartWay Transport Partnership Call Center at (734) 214-4767 or email
smartway_transport@)epa. gov.
OK
Cancel
Figure 32 Data Saving Confirmation
Upon selecting OK, the file will be saved, and the following instructions will appear. Follow these
instructions for submitting your rail tool to SmartWay. Upon selecting I ^jjj||^J ^ a screen wj|| appear
allowing you to close the Rail Carrier FLEET tool or return to the Home screen.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 38
-------
Smart Way - Instructions for Submitting File
SmartWayฎ
Rail
United States Version: 2.0.11
Released on: 07/06/2012
A copy of this file called 'Rail_2Qll_Rail 1, Inc._VO.xls' has been created and is ready to be emailed to EPA,
The file was saved in a folder called: C:\SmartWay\
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.
Figure 33 Data Saving Confirmation
If you have any comments about the tool and/or User Guide, please submit these with your tool in a
separate document.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 39
-------
Troubleshooting the Tool
Although the SmartWay tools have been tested extensively, you may encounter errors. Intermittent
errors have been encountered when opening the tool directly from the SmartWay website, or from an e-
mail, rather than from a drive, or when multiple Excel files or other applications are open simultaneously.
If you encounter an error during use of the tool, please 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, please make a screen capture of the error message, and save the
tool at that point. (You can make a screen capture by pressing Alt-Print Screen, 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.
Rail Carrier FLEET Tool Users Guide Part 3 I P. 40
------- |