U.S. flag

An official website of the United States government

Dot gov

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Https

Secure .gov websites use HTTPS
A lock () or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Breadcrumb

  1. Home
  2. Tools
  3. Cost Analyst Spreadsheet Toolbox

Cost Analyst Spreadsheet Toolbox


Last Updated : 03/09/2021

​This is an EXCEL spreadsheet that lists EXCEL functions that are commonly used by Cost Analysts. There are videos on how to use the tools in the spreadsheet at the bottom of this page. It also shows some examples and provides discussion on how the Cost Analyst would employ these functions. DAU courses that may use this toolbox are BCE1000, BCE2000V, BCE3000 as well as pricing courses in the CON curriculum.

  1. Excel Basics
  2. Regression Review
  3. Outlier calcs
  4. Boeing Unit Curve Cumulative Progress Curves
  5. Student T distribution
  6. Normal Distribution
  7. F Distribution
  8. Sumproduct Examples
  9. Weighted Index Calculations
  10. EAC Calculations
  11. Learning Curve Examples
  12. CPIF Price Calculations

Tutorials

RATINGS

0 out of 5 | 0 Reviews
Rate this tool:

You Might Also Consider

Related Tools

Related Events