Using the Worksheets

1) Save the Excel workbook into your own directory, then open it.

2) Click on the gray tabs along the bottom of your screen to access the various worksheets.

  1. SCC List: This is a simple list of the categories and line items. Categories 10 through 50 cover construction of fixed infrastructure.  Category 80, Professional Services, relates to the work in Cats. 10 - 50. Professional Services associated with Cats. 60 and 70, Real Estate and Vehicles, should be included in Cats. 60 and 70.
  2. SCC Definitions:  These are provided to establish consistency in the use of the worksheets. 
  3. TEAM Scopes and Activity Line Items:  This worksheet contains a “cross-walk” between the Standard Cost Categories and a new “14-Series” Scopes and ALIs for grant budgets in TEAM. 
  4. BUILD Main Worksheet:  This is the most important worksheet, as it includes a cost breakdown by category and line item, includes allocated contingencies (by specific line item), calculates line items as a percentage of construction and total project cost, displays Year of Expenditure (YOE) costs, and important dates. Typically, information that is entered on this sheet will automatically move onto other sheets. Enter information in the white cells. Note that all costs are in thousands (x 000).
  5. If you are not sure where to put a certain element of the project, rethink it in more general terms, using the SCC Definitions as a guide. The list of SCC categories and line items is relatively short, yet it is meant to accommodate all possible project elements. There is purposefully no “other” category. It is recognized that all of the worksheets, including the Main Worksheet, are “summary-level.”
  6. Inflation Worksheet:  This worksheet calculates the cost of inflation, or the difference between Base Year Dollars and the Year of Expenditure Dollars. Spread anticipated project costs in base year dollars according to your project/construction schedule. Insert the inflation rate you believe to be appropriate for each year of the project. Note that Finance Charges are to be entered in YOE dollars. The worksheet automatically deflates Finance Charges into Base Year dollars.
  7. Project Schedule: This is a simple bar chart schedule including activities in five phases – alternatives analysis, preliminary engineering, final design, construction, and revenue operations.
  8. Funding Sources by Category: This worksheet contains all sources of project funding and the amount attributable to each cost category.
  9. Funding Sources by Year: This worksheet shows the distribution of funds by source of funds across the project duration.
  10. BASELINE Main Worksheet: This is the project against which the BUILD alternative is compared.
  11. Annualized Cost, Build and Baseline: For each line item within the Standard Cost Categories, a useful life in years is identified. Base Year costs should automatically arrive from the Main Worksheet.  Spread Unallocated Contingency across the line items according to perceived risks.
  12. By-Segment and Project-Wide Worksheets:  The By-Segment and Project-Wide worksheets provide a format for documenting perceived risks and opportunities.  These two worksheets can be used during any phase but may be especially useful during alternatives analysis and early preliminary engineering.  Use the By-Segment for particular geographic areas or segments of a project based on topography or construction methodology.  The length between two points will have specific guideway and station cross-sections, as well as land use and real estate conditions. On both worksheets, document uncertainties in the columns for low and high costs.  Describe, comment and explain in the box at the bottom of the worksheet.  To build the cost estimate for an alignment, add together the “most likely” costs for each segment and place the category totals into the Main Worksheet, under Base Year Costs. In the same way, enter “most likely” project-wide costs.
  13. FFGA Attachments:  Use the worksheets FFGA A3T1 – A4.