Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements (2011) / Chapter Skim
Currently Skimming:
Pages 209-234
The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.
From page 209... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-1
|
From page 210... ...
C-2 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements Objective To assist in assessments of alternative fuel buses for 2010 and beyond by updating and expanding TCRP Report 38 (1998) Guidebook Cost-model spreadsheet (FuelCost )
|
From page 211... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-3 The Guide and Spreadsheet tool calculates lifecycle costs of 40-ft bus purchase options: Powertrains Conventional Hybrid Electric All-Electric (battery) Catenary electric (trolleybus)
|
From page 212... ...
C-4 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements Sheets for cursory comparisons INPUT Basic OUTPUT Graphs For more detailed assessments INPUT Detail For advanced use Default Data Fuel Economy Calculations 6 7 Worksheets 7 Microsoft Excel 2000, 2003, 2007, or 2010 Security settings must be set to allow operation of macros FuelCost2 Use Requirements
|
From page 213... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-5 1. Click on the "INPUT Basic" sheet (one of the tabs at the bottom of the screen)
|
From page 214... ...
C-6 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 10 If Excel Security settings are High or Very High, one of the following pop-up boxes may appear. Click "OK" Excel Security Settings: Pre-2007 11To adjust Excel Security settings in Excel 2000 or 2003, click "Tools", "Options" .
|
From page 215... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-7 12 Select the "Security" tab, Click "Macro Security" .
|
From page 216... ...
C-8 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 14 Excel Security Settings: 2007 & Up 15 Excel Security Settings: 2007 & Up
|
From page 217... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-9 16 If you don't see the "Security Warning" Ribbon, Click the "Developer Tab" Then click "Macro Security". E x c e l S e c u r i t y S e t t i n g s : 2 0 0 7 & U p 17 Select "Disable all macros with notification." Click "OK" Close Excel (you don't need to "save" the file )
|
From page 218... ...
C-10 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 18 If you don't see the Security Warning Ribbon and you don't see the "Developer" Tab: Click the "Office Button", then Click "Excel Options" E x c e l S e c u r i t y S e t t i n g s : 2 0 0 7 & U p 19 S e c u r i t y S e t t i n g s : E x c e l Select "Show Developer .
|
From page 219... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-11 20 Initial Input: Agency ownership type, labor rate, rate of return For each option (A,B,C) : Bus length, Mileage, Tax rate, Powertrain INPUT Basic Sheet 21 When powertrain isn't all-electric, select on-board fuel, next questions vary with selection.
|
From page 220... ...
C-12 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 22 When powertrain isn't all-electric, select on-board fuel, next questions vary with selection. INPUT Basic Sheet 23 INPUT Basic Sheet
|
From page 221... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-13 INPUT Basic Sheet 24 Enter fuel economy and fuel price INPUT Basic Sheet 25 Enter fuel economy and fuel price
|
From page 222... ...
C-14 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 26 Enter project schedule and financing I N P U T B a s i c S h e e t 27 Enter project schedule and financing I N P U T B a s i c S h e e t
|
From page 223... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-15 View cursory comparisons (up to 3 options) > Lifecycle costs > Lifecycle emissions Based on use default data > Key Limitation!
|
From page 224... ...
C-16 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 3 0 Default data provided for each selected option Four Ways to Account for Subsidies 1. Adjust price to include subsidy 2.
|
From page 225... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-17 32 Output 33 Output
|
From page 226... ...
C-18 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 34 Quick version of "Key Assumptions" prints on same page as the summary output tables Click here to save results in a file Output 35 Lower rows of OUTPUT sheet display all input data – these print on a second page, and can be used to fully compare and re-create the modeled scenarios. Output
|
From page 227... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-19 36 Project Life: Total Cash Outflow Project Life: Other Costs Project Life: Total Cash Outflows Project Life: Capital Costs Graphs Graphs 37 Project Life: Offsets (Cost reductions) Year 6 O&M Costs Project Life: Exhaust Emissions
|
From page 228... ...
C-20 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements Password-protected sheets to prevent accidental change s 38 Sheets that allow greater tailoring Default Dat a Calculations Fuel Econom y The password is "test" A d v a n c e d U s e o f F u e l C o s t 2 39 D e f a u l t D a t a S h e e t Row Headers (Column D) – m ust include cells with identical headers to "Input Detail", Column D
|
From page 229... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-21 40 F u e l E c o n o m y S h e e t Fuel Economy Estimates for All-Electric (i.e., battery electric and catenary – t rolleybus) are based on previous-generation technology, and are only adjusted by hotel load months (no adjustment based on speed)
|
From page 230... ...
C-22 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements Array equations on the "Calculations " s heet Array equations have outer curly brackets { } If you click on an array cell as for editing the contents, you must exit the cell by either : Press "Esc", or pressing together: "Ctrl", "Shift", "Enter" (this key combination tells Excel this is an "array" and { } is automatically added.
|
From page 231... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-23 44 Default Data Calcula - tions Fuel Economy INPUT Detail OUTPUT (tables) Graphs INPUT Basic Bus lengt h Data (entries or default)
|
From page 232... ...
C-24 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements On the INPUT Basic Sheet: 1. Select Columns P:R (they should be highlighted)
|
From page 233... ...
Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements C-25 DefaultValues Sheet – C olumns F to AH Makes another vehicle type replace the current standard (i.e.,40-ft bus data) Consider : (to help assure appropriate relative values)
|
From page 234... ...
C-26 Guidebook for Evaluating Fuel Choices for Post-2010 Transit Bus Procurements 3. FuelEconomy Sheet Adjustments Adjust fuel economy calculations for the new vehicle length .
|
Key Terms
This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More
information on Chapter Skim is available.