Sign In
wrench

Cost Analyst Spreadsheet Toolbox

Updated 3/9/2021

Launch Tool
Cost Analyst Spreadsheet Toolbox
4.3 stars out of 5 based on 3 user ratings.

​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. 

  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

Chat with DAU Assistant
Bot Image