National Academies Press: OpenBook

Estimating the Life-Cycle Cost of Intersection Designs (2016)

Chapter: Appendix B Microsoft Excel Updates

« Previous: Appendix A Public Agency Interviews
Page 110
Suggested Citation:"Appendix B Microsoft Excel Updates." National Academies of Sciences, Engineering, and Medicine. 2016. Estimating the Life-Cycle Cost of Intersection Designs. Washington, DC: The National Academies Press. doi: 10.17226/21928.
×
Page 110

Below is the uncorrected machine-read text of this chapter, intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text of each book. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.

NCHRP Project 03-110: Estimating the Life-Cycle Cost of Intersection Designs Final Report Appendix B – Microsoft Excel Updates Page B-1 APPENDIX B MICROSOFT EXCEL UPDATES For the Life-Cycle Cost Estimating Tool to function properly, users must have the most recent Microsoft Excel updates installed on their computer. There are specific Microsoft Excel patches that are required for some of the macros within the tool. Additional information regarding these updates and a link to access the updates is provided below: To install the required updates: • Go to the link below: http://support.microsoft.com/kb/3025036/EN-US • Scroll down the page. You will see two buttons labeled Fix it. • If you click on the first (top) button the problem file will be erased for the current user. • If you click on the second (bottom) button the problem will be fixed for all users on the computer. You need to have Administrator privileges to do this.

Next: Appendix C_Case Study Worksheets »
Estimating the Life-Cycle Cost of Intersection Designs Get This Book
×
 Estimating the Life-Cycle Cost of Intersection Designs
MyNAP members save 10% online.
Login or Register to save!
Download Free PDF

TRB’s National Cooperative Highway Research Program (NCHRP ) Web-Only Document 220: Estimating the Life-Cycle Cost of Intersection Designs describes the Life-Cycle Cost Estimation Tool (LCCET). The LCCET spreadsheet allows users to compare alternative intersection designs based on initial construction costs, ongoing maintenance and operations costs, operational efficiencies for a variety of modes, safety effects, and emissions. Alternative designs include roundabouts and traditional intersections using stop signs and traffic signals. Use of the tool is designed to help provide a consistent approach to these comparisons based on benefits and costs.

The Life-Cycle Cost Estimation Tool is available for download. Complementary products to the LCCET and Web-Only Document include the following:

Presentation that describes NCHRP Project 03-110, which developed the LCCET

• Case Studies demonstrating the LCCET

o CS1: Base Case of Signalized Intersections, Alternatives of Multilane Roundabout and Enhanced Signalized Intersection

o CS2: Base Case of Two-Way Stop, Alternatives of Roundabout and Offset T-Intersections

o CS3: Base Case of Offset T-Intersections, Alternatives of Roundabout and Signalized Intersection

o CS4: Base Case of Two-Way Stop, Alternative of Signalized Intersection

o CS5: Base Case of Signalized Intersection (Divided Highway), Alternative of Median U-Turn Intersection

o CS6: Base Case of All-Way Stop, Alternatives of Signalized Intersection and Roundabout Intersection

View a Ready Results summary on applying the Life-Cycle Cost Estimation Tool within a transportation agency.

Software/Excel Spreadsheet Disclaimer - This software is offered as is, without warranty or promise of support of any kind either expressed or implied. Under no circumstance will the National Academy of Sciences or the Transportation Research Board (collectively "TRB") be liable for any loss or damage caused by the installation or operation of this product. TRB makes no representation or warranty of any kind, expressed or implied, in fact or in law, including without limitation, the warranty of merchantability or the warranty of fitness for a particular purpose, and shall not in any case be liable for any consequential or special damages.

READ FREE ONLINE

  1. ×

    Welcome to OpenBook!

    You're looking at OpenBook, NAP.edu's online reading room since 1999. Based on feedback from you, our users, we've made some improvements that make it easier than ever to read thousands of publications on our website.

    Do you want to take a quick tour of the OpenBook's features?

    No Thanks Take a Tour »
  2. ×

    Show this book's table of contents, where you can jump to any chapter by name.

    « Back Next »
  3. ×

    ...or use these buttons to go back to the previous chapter or skip to the next one.

    « Back Next »
  4. ×

    Jump up to the previous page or down to the next one. Also, you can type in a page number and press Enter to go directly to that page in the book.

    « Back Next »
  5. ×

    To search the entire text of this book, type in your search term here and press Enter.

    « Back Next »
  6. ×

    Share a link to this book page on your preferred social network or via email.

    « Back Next »
  7. ×

    View our suggested citation for this chapter.

    « Back Next »
  8. ×

    Ready to take your reading offline? Click here to buy this book in print or download it as a free PDF, if available.

    « Back Next »
Stay Connected!