^•vSmartVVay
Transport Partnership
U.S. Environmental Protection Agency
2018 SmartWay Rail Carrier
Partner Tool:
User Guide
U. S. Version 2.0.17 (Data Year 2017)
www.epa.gov/smartway
¦^sSmartWayn
United States
Environmental Protection
M * Agency

-------
"^^SmartWay
Transport Partnership
U.S. Environmental Protection Agency
2018 SmartWay Rail Carrier
Partner Tool:
User Guide
U. S. Version 2.0.17 (Data Year 2017)
Transportation and Climate Division
Office of Transportation and Air Quality
U.S. Environmental Protection Agency
United States
Environmental Protection
Agency
Office ofTransportation and Air Quality
EPA-420-B-18-006
February 2018

-------
Table of Contents
INTRODUCTION	2
HOW DO I SET THE SECURITY LEVEL WHEN OPENING SMARTWAY TOOLS?	2
Overview of Data Collection Requirements	12
Section 1: Specify Official Partner Name	12
Section 2: Enter Company Contact Information	12
Section 3: Fleet Description(s)	13
Section 4: Enter Activity and Fuel Information for Each of Your Fleets	14
Next Steps	16
APPENDIX: WORKSHEETS FOR DATA COLLECTION	17
WORKSHEET #1: CONTACT INFORMATION 	17
Worksheet #2: Fleet Characterization	18
Worksheet #3: Power Units Information	19
Worksheet #4: Car Data	20
Worksheet #5: Operations Data	22
1 | P a g e

-------
INTRODUCTION
This guide is designed to help rail companies participate in the SmartWay Transport Partnership. The guide
supplements the Rail Quick Start guide with additional information and data collection worksheets to
facilitate completion of the SmartWay Rail Carrier Tool.
In this guide you will learn about:
1.	The general organization of the SmartWay Rail Carrier Tool, and
2.	Data needs for each section of the Tool.
You can collect your data using our data collection worksheets in preparation for data entry.
Please review this guide carefully BEFORE attempting to use the Tool or enter data. Understanding the data
requirements and gathering all data in advance will save considerable time and frustration while completing
your Tool submission.
In the event that you have a question about any of the data collection activities, you can contact SmartWay
Email Support at smartwav transport(5)epa.gov and a member of our SmartWay Partner Support Team will
assist you.
WARNING!
Completing the Rail Tool requires a considerable amount of information about your company and
the fleets that are joining SmartWay. There are multiple sections and screens to complete for each
fleet that you operate.
While you will have the ability to save your Tool along the way and return to it at any time, we STRONGLY
ENCOURAGE you to review the Rail Tool Quick Start Guide to understand key information about joining the
Partnership. Then, the information in this guide allows you to learn about the data requirements and
gather your data BEFORE attempting to complete the Tool.
How DO I SET THE SECURITY LEVEL WHEN OPENING SMARTWAY TOOLS?
When you first open the Tool you may see a new "Protected View" security warning from Microsoft:
1*1
2016-09-21 _shipper - Copy-xls [Protected V
I Home Insert Page Layout Formulas Data Review View Developer
id H lJ ~ ' 0 - a EB # £1- Eg) [Sj .^1 #
•Si "
^ Protected View Office has detected a Droblem with this file,
Editina it mav harm vour computer. Click for more details,
AH19 - fx


[ Click for more details)
NOTE - THE SMARTWAY TOOL IS IN THE SAME FORMAT AS PRIOR YEARS AND IS SAFE
TO OPEN ON YOUR COMPUTER. FOLLOW THESE STEPS TO PROCEED.
1)	Select the "Click for more details" link at the end of the message in the menu bar shown above.
2)	In the Microsoft Office File menu, choose the large "Edit Anyway" button located on the left next to the
Protected View information section as shown below.
2 | P a g e

-------

2016-09-21_shipper-Copyjcls [Protected View] - Microsoft Excel
Insert Page Layout
Review View
liJ Save
Save As
& Open
pi1 Close
E
Recent
New
Print
Help
Options
0 Exit
Information about 2016-09-21_shipper - Copy
R:\ECON\brielle.bkm\SmartWay\Shipper\2016\2016-09-21_shipper - Copy.xls
Edit
Anyway
Protected View
Office has detected a problem with this file. Editing it may be dangerous. To help
keep your computer safe this file has been opened in Protected View.
You should only enable editing if you trust the contents of the file.
Protected View Settings
Learn more about Protected View
Properties T

Size
12.9MB
Title
None
Tags
None
Categories

Related Dates

Last Modified
Today, 11:12 AM
Created
4/16/2015 11:16AM
Last Printed
9/19/2016 8:51 AM
Related People

Author
BMeade
Last Modified By
BMeade
Related Documents
i Open File Location
Show All Properties
Next, the following instructions should appear on your screen //you need to change additional
security settings before running the Tool. The instructions differ depending upon what version of
Excel you use (Excel 2003, 2007, 2010, or 2013).
Security Settings for Excel 2003 Users
To use the Rail Tool in Microsoft Excel 2003, you will need to have your security levels set to
"Medium."
3 | P a g e

-------
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.
Security
Security Level j 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.
0 High. Only signed macros from trusted sources will be allowed to
run. Unsigned macros are automatically disabled.
0 Medium. You 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.
Macro Setting Tabs in Excel 2003
OK
Cancel
Security Level Setting Screen in Excel 2003
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. Select the
warning box.
Security Warning
Enable Macros
"5:\5martWay\5hipper.xls" contains macros,
button in the security-

Macros may contain viruses. It is usually safe to disable macroSj but if the
macros are legitimate; you might lose some functionality,

Disable Macros
Enable Macros
More Info
Screen showing "Enable Macros" button
The Welcome Screen for the Rail Tool should then appear and you will be ready to begin working on
your tool.
4 | P a g e

-------
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
Options..
button that appears after the Security
Warning just below the menu bar. Detailed instructions are also provided on the
screen itself.
Home . Insert Page layout Formulas Data Review
Cio
Paste J B
^ppertoo^de^efsior^T-l^i^^ompa^bil^Mode^MiaosofrtodJ

* )
In order to run this application, you must have macros enabled.
For Excel 2007. Excel 2010. and Excel 2013 Users: (If you 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/2010.
2. Go to Excel Options. Click the "Excel Options" button in the bottom right corner of the pull-down menu:
W




3. Go to the Trust Center. On the Excel Options screen, click on Trust Center in the left navigation bar.
4 Go to the Trust Center Settings. Click 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 click OK.
6.	Reopen the file. Close the Excel file and then re-open it.
For Excel 2003 Users:
Security Warning Screen
5 | P a g e

-------
3) In the Microsoft Office Security Options dialog box, choose "Enable this content" and
select OK.
Mic rosoft Office Sec u rity Options [?] fx]
1 j Security Alert - Macro

Macro


Macros have been disabled. Macros might contain viruses or other security hazards. Do
not enable this content unless you trust the source of this file.


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


More information


File Path: C:\smartway\Shipper.xls


O Help protect me from unknown content (recommended)


0 jEnable this content]

1 flnpn thpTructrpntpr 1 0K 1 [ Cancel |

¦_	¦_!*
Security Options Dialogue Box
The Welcome Screen for the Rail 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.
M
To adjust your security settings, select the	button (in the top left corner of the screen) and then
select the	button in the bottom right corner of the pull-down menu.

J_
Select the "Excel
Options" button
/
J I M*.	'X l|lt»
Excel Options Drop-Down Menu
On the Excel Options screen, select Trust Center in the left navigation bar:
6 | P a g e

-------
' Popular
Change the most popular options in Excel.
Top options for working with Excel
Proofing
P/l Show Mini Toolbar on selection ¦
-Type
Create lists for use in sorts and fill sequences:
When creating new workbooks
Body Font
Include this many sheets:
Personalize your copy of Microsoft Office
User name: jMHeyward
Choose the languages you want to use with Microsoft Office: Language Settings...
Select the
"Trust Center'
screen up style: Show feature descriptions in ScreenTips
Excel Options
Excel Options Drop-Down Menu
When the Trust Center options display opens, select Trust Center Settings in the bottom right portion
of the screen;
Excel Options
Popular

Formulas

Proofing

Save

Advanced

Customize

Add-Ins

Trust Center
-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,
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 Mi
Microsoft Windows Security Center
Micro soft Trustworthy Computing
Microsoft Office Excel Trust Center
The Trust Center contains security and privacy settings, These seffc
secure. We recommend that you do not change these settings,
Select the "Trust
Center Settings"
button
|lrust Center Settings,., j
Trust Center Settings Screen
7 | P a g e

-------
Choose the setting "Disable all macros with notification" and select OK.
Trust Center
Trusted Publishers
Trusted Locations
Add-ins
ActiveX Settings
Macro Settings
Message Bar
External Content
Privacy Options
Macro Settings
For macros in documents not in a trusted location:
O Disable aN macros without notification
0 Disable all macros with notification
O Disable all macros except digitally signed macros
O Enable all macros (not recommended; potentially darlv
Select "Disable all macros
with notification."
Developer Macro Settings
I I Trust access to the VBA project object model
Macro Settings Screen
Then run the Tool.
If, at this point, the Tool does not open, review the "Software and Hardware Requirements". If you
after reviewing this section, you cannot determine how to correct the problem, contact your
SmartWay Partner Account Manager.
Security Settings for Excel 2010 and newer Users
The default settings for Excel 2010 and newer Excel versions 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.
8 | P a g e

-------
|W|I id
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
The Enable Editing Button
3) Depending on your Excel macro security settings, you may receive a	popup,
if you do, simply select the	button. This will enable macros in the tool you
just opened.
! Security Warning Some active content has been disabled. Click for more details. Enable Content
fx Security Settings for the Tool
A
1 | Security Settings for the Tool
2 (Pour des instructions en fran$ais. faites defiler vers la droite.->)
lr» nrrlar frt ri in fhie annliratinn wmi mnet hairo marrrve anahlaH
Security Warning Popup
If you reach this point and the Tool does MOT open, you may have your security set too high.
To adjust your security settings, select the File tab from the menu bar	(in the top left corner
of the screen) and then select the
J Options
button in the bottom left-hand menu of the tab.
m	Bookl - Microsoft Excel
I Home Insert Page Layout Formulas Data Review View Developer
~ X
Q CD |ap S3
3 Save
M Save As
i3 Open
~J Close
Info
Recent Workbooks
To browse for a file^ click Open.
Recent Places
Save & Send
rj Options
Select the "Options"
button
Excel 2010 and Newer Options Drop-Down Menu
On the Excel Options screen, select Trust Center in the left navigation bar:
9 | P a g e

-------
Excel Options
Popular
Change the most popular options in Excel.
0 Show Mini Toolbar on selection •
PI Enable Live Preview \
l~l Show Developer tab in the Ribbon j
[•/I Always use ClearType
ScreenTip style: Show feature descriptions in ScreenTips
|Body Fo
["'Ml
Font size:
Select "Trust Center'
User name: MHeyward
Choose the languages you want to
Language Settings.,.
Excel 2010 and Newer Options Drop-Down Menu
When the Trust Center options display opens, select Trust Center Settings in the bottom right portion
of the screen:
ExcelOptions	[?] [x]
Popular
Formulas

Help keep your documents safe and your computer secure and healthy.
Proofing

Protecting your privacy
Save
Advanced

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
Customize
Add-Ins

Microsoft Office Online privacy statement
Customer Experience Improvement Proaram

Trust Center

Security & more
Resources

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 i			<
secure. We recommend that you do not change these settings. 1 Jrust Center Settings... |



f >
Select the "Trust Center Settings"
button






OK ] [ Cancel
Trust Center Settings Screen
10 | P a g e

-------
Choose the setting "Disable all macros with notification" and select OK.
Trust Center	| ? |[X [
Trusted Publishers
Trusted Locations
Add-ins
ActiveX Settings
Macro Settings
Message Bar
External Content
Privacy Options
Macro Settings
For macros in documents not in a trusted location:
O Disable ail macros without notification
0 Disable all macros with notification ^ ""
O Disable all macros except digitally signed macros
O Enable all macros (not recommended; potentially dangerous code can n
Developer Macro Settings
I"! Trust access to the VBA project object model
Select "Disable all
macros with
notification"
| OK 1 | Cancel
Macro Settings Screen
11 | P a g e

-------
Overview of Data Collection Requirements
The SmartWay Rail Tool is the data collection and calculation system for rail carriers that join the SmartWay
Transport Partnership. There are four sections of the SmartWay Rail Tool that require data about your
company's operations:
1.	Specify Official Partner Name
2.	Enter Company Contact Information
3.	Characterize Your Fleets
4.	Enter Activity and Fuel Information for Each of Your Fleets
This guide will explore the data required for completing these four sections.
Section 1: Specify Official Partner Name
To begin, 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.
Section 2: Enter Company Contact Information
SmartWay needs complete contact information for correspondence, web posting, press releases, and awards
and recognition (where applicable). The SmartWay Rail Tool asks for:
•	General company information (e.g., location, web address, etc.)
•	A Working Contact1 for any questions about your company's participation and Tool submissions
•	An Executive Contact2 for participation in awards and recognition events
•	A Sustainabilitv Contact (optional)-for information on company sustainability programs and
outreach
•	Other contacts (optional): Other contacts may include anyone who is not the Working, Executive, or
Sustainability contact but may be involved with SmartWay (e.g., press/media contact, fleet manager,
etc.).
Please use Worksheet #1 in this guide to prepare for filling out the Contact Information Screen in the Rail
Tool.
1	The Working Contact is the individual designated by the Executive Contact to directly interface with SmartWay regarding specific tasks
involved in the timely submission of the Tool. The Working Contact is responsible for coordinating the assembly of information to
complete/update fleet/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 emails from SmartWay/EPA
are not blocked, new Primary Contacts may need to add SmartWay/EPA to their preferred list of trusted sources.)
2	The Executive Contact is the company executive who is responsible for agreeing to the requirements in the SmartWay Partnership
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.
3	The Sustainability Contact may be the same as the Working or Executive Contact, but not the same as any Other Contacts.
12 | P a g e

-------
Section 3: Fleet Description(s)
The SmartWay Rail Tool allows you to characterize your operations at the fleet level. In the Rail Tool, a fleet is
defined as any business unit that a customer has discretion to hire.
•	If you are a small company (e.g., Class 3) you will only have one fleet
•	If you are a large rail company (e.g., Class 1), you may have several fleets
NOTE: You may enter multiple fleets into a single Tool submission.
SmartWay highly recommends developing your list of fleets offline using a company organization chart or
perhaps a customer interface webpage. The best strategy is to have a clear idea of how to define your fleets
before filling out the Tool.
Your company's name and your fleet name(s) will be listed on the SmartWay website to indicate your
participation in the SmartWay Transport Partnership.
It is critical that you identify your company and fleet(s) in the Tool as you would have them appear
on the SmartWay website.
The data requirements for the "Characterize Your Fleets" section are described below.
Please use the Worksheet #2 provided in this guide to prepare for filling out the Characterize Fleets section
in the Rail Tool.
NOTE: You may wish to print multiple copies of Worksheet #2 if you have multiple fleets.
Data Requirements for "Fleet Description(s)" Screen
For each fleet, you will need to specify:
•	Partner Name: On the SmartWay website, each of your fleet names will begin with the name of your
company. This fleet "prefix" will be whatever you enter in the Partner Name field on the Fleet
Description 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 name. (For example, if your company's name
includes "Inc." or "Ltd.", you may choose not to include that in your fleet names.) Please pay special
attention to proper capitalization, abbreviations, and punctuation.
•	Fleet Name: Specify each fleet 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 (1, 2, or 3).
13 | P a g e

-------
Section 4: Enter Activity and Fuel Information for Each of Your Fleets
Once you have identified and characterized your fleets, you will be asked to provide additional information
for EACH fleet separately. Much of this information will be directly available for Class 1 rail carriers from their
most recent R-l report data.
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.
Data Requirements for "Power Units" Screen
Please use the Worksheet #3 provided in this guide to prepare for filling out the Power Units section in the
Rail Tool (make one copy for each fleet).
You will need to provide power unit information about the selected fleet.
•	Specify the number of power units or hours per year operated during the reporting period, by engine
tier level. Depending up the Data Input Method selected, this information may be broken out by
line-haul and switch engines. 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.4 For Class
1 operators, please refer to R-l form, Schedule 710 for details. The different engine tier level
definitions are provided below:
o	Non-tier - manufactured before 1972
o	Tier 0 - manufactured between 1972 and 2001
o	Tier 0+ - manufactured between 1972 and 2001, and remanufactured after 2010
o	Tier 1 - manufactured between 2002 and 2004
o	Tier 1+ - manufactured between 2002 and 2004 and remanufactured after 2010
o	Tier 2 - manufactured between 2005 and 2011
o	Tier 2+ - manufactured between 2005 and 2011 and remanufactured after 2013
o	Tier 3 - manufactured between 2012 and 2014
o	Tier 4 - manufactured after 2014
•	Next, Class 1 operators must 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. This data is
available in the R-l forms for Class 1 railroads (see lines 8-14 of Schedule 755). Class 2 and 3
operators do not enter this information.
•	Finally, you will need to provide a detailed description of the data sources used to obtain your power
unit data (e.g., R-l Form section and line numbers).
4 In general, method 4 will provide the most accurate estimate for NOx and PM emissions.
14 | P a g e

-------
Data Requirements for "Cars" Screen
Please use the Worksheet #4 provided in this guide to prepare for filling out the Cars section in the Rail Tool
(make one copy for each fleet).
Class 1 operators will need to provide power unit information about the selected fleet. (Class 2 and 3
operators do not enter this information.)
•	Specify your fleet's annual railcar miles for the reporting year, by car type (e.g., box, gondola, etc.)
and ownership type (Owned/Leased or Private). These data may be obtained from R-l Report
Section 755 (see lines 15 - 84).
•	If available, also provide your fleet-specific railcar volumes by car type.
NOTE: All car-mile data should be entered as actual miles, NOT 1,000s of miles (as presented in the R-l
Report).
Data Requirements for "Operations" Screen
Please use the Worksheet #5 provided in this guide to prepare for filling out the Operations section in the
Rail Tool (make one copy for each fleet).
You will need to provide power unit information about the selected fleet:
•	Specify your fleet's annual fuel consumption and ton-mile data. Record 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 CNG units
indicating standard cubic feet or gasoline-equivalent gallons per year. Electricity use is specified in
kWh/year. If you indicate biodiesel consumption data, you must also specify the fleet average fuel
blend level (between 0 and 100). For Class 1 operators, please refer to R-l form, Schedule 750, lines 1
- 3 for details.
•	Specify your gross, revenue, and non-revenue ton-mile data. This data is available for Class 1
operators from R-l Report Section 755, lines 104, 110, and 113, respectively.
NOTE: All ton-mile data should be entered as actual ton-miles, NOT 1,000s of ton-miles (as presented in the
R-l Report).
15 | P a g e

-------
Next Steps
Now that you understand the data collection requirements for the SmartWay Rail Tool, use the worksheets in
the attached appendix to collect the data you need, then download the Tool and begin the data entry
process. Please visit https://www.epa.gov/smartwav/smartwav-rail-carrier-tools-and-resources to download
the SmartWay Rail Tool if you haven't already.
16 |

-------
APPENDIX: WORKSHEETS FOR DATA COLLECTION
Worksheet #1: Com a ct Inform a tion
ttl. Enter your Contact Information:
General Company Contact Information
Company Name

Headquarters
Mailing Address

City

State/Province

Zip Country
Main Phone
Number
Toll-free Number

Cell
number
Web Address
Working Contact Information
Working Contact Name

Working Contact Mailing
Address

City

State/Province

Zip

Country

Working Contact Phone
Number

Email
Address

Executive Contact Information
Executive Contact Name

Executive Contact Mailing
Address

City

State/Province

Zip

Country

Executive Contact Phone
Number

Email
Address

Sustainability Contact Information
Sustainability Contact
Name

Sustainability Contact
Address

City

State/Province

Zip

Country

Sustainability Contact
Number

Email
Address

Other Contact Information
Other Contact Name

Other Contact Mailing
Address

City
State/Province

Zip Country
Other Contact Phone Number

Email
Address

Contact's role in program

17 |

-------
Worksheet #2: Fleet Characterization
Complete this worksheet for each fleet vou will be submitting in the Rail Tool.
Specify Partner / Fleet Name (exactly as it should appear on the SmartWay website):
Partner Name	
Fleet Identifier	
Railroad Class (1, 2, 3)	
18 |

-------
Worksheet #3: Power Units Information
Complete this worksheet for each fleet vou will be submitting in the Rail Tool.
Specify Power Unit Inventory by Engine Tier
Inventory Basis (circle one): # Units	Hours/Yr
Engine Tier Line Haul	Switch	Total*
non-Tier 	 			
0		 			
0+		 			
1		 			
1+		 			
2		 			
2+		 			
3		 			
4		 			
* If you cannot differentiate line-haul and switch inventories, enter # Units or Hours/Yr for Totals only
Total Locomotive Unit Miles/Year (Class 1 Operators Only):
Unit Trains		
Way Trains
Through Trains
Train Switching
Yard Switching
Describe the data source used to develop the above data:
19 |

-------
Worksheet §4: Car Data
Complete this worksheet for each fleet vou will be submitting in the Rail Tool.
Fleet Name:	
Railcar Miles/Year (Class 1 Operators only):

Owned and Leased
Private

Loaded
Empty
Loaded
Empty
Box - Plain 40'




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 Equipment and Company Freight




No Payment Car-Miles




20 | P a g e

-------
For each fleet, enter the fleet-specific volume in cubic feet for each car type. If you do not have this data, the
Rail Tool will apply national average volume estimates.
Car Type
Volume (cu ft)
Box - Plain 40'

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 Equipment and Company Freight

No Payment Car-Miles

21 |

-------
Worksheet #5: Operations Data
Complete this worksheet for each fleet vou will be submitting in the Rail Carrier Tool.
Enter Fuel Use/Yr:
Fuel Type
Units
Freight
Passenger
Switching
Diesel
gal/yr



BiodieselA
gal/yr



LNG
gal/yr



CNG
gal/yr cu ft/yr *



Electricity
kWh/yr



* circle one
A Biodiesel blend % (if applicable):
Gross Ton-Miles/Yr
(R-l.
Schedule 755,
line
104)
Revenue Freight Ton-Miles/Yr
(R-l.
Schedule 755,
line
110)
Non-Revenue Freight Ton-Miles/Yr
(R-l.
Schedule 755,
line
113)
22 |

-------