Estimating projects - Spreadsheet Development Life Cycle

Estimating projects - Spreadsheet Development Life Cycle

11 June 2016

Modeling involves more than just putting formulas in a spreadsheet. We need to do all steps in the Spreadsheet Development Life Cycle (SDLC). These steps are essential to successful projects and making sure our client's expectations are met.

The steps in the Spreadsheet Development Life Cycle, and the proportion of project time that they typically take, are:

  • Research (5%-15%).
  • Analysis (5%-15%).
  • Design (5%-15%).
  • Construction (25%-50%).
  • Testing (25%-50%).
  • Implementation (1%-20%)