The Tools
The AgileESM© Calculator is an Excel™ utility that takes either a file feed or manual input and produces AgileESM© results. It’s easy to use and is available today for a  free trial or for purchase.

There are just three steps to run the Calculator:

  1. Extract values from your release plan:
    • the cumulative Planned Value by sprint from the first sprint to the last sprint
    • the cumulative Earned Value by sprint from the first sprint to the last fully completed sprint.
  2. Either place the extracts into a file (.xls or .csv) or keep the data available for manual input
  3. Follow the Calculator’s prompts.

The AgileESM© Calculator performs the analysis and places the results in a separate Excel™ file. You can re-run the Calculator at any time. Once you save the Calculator file, your entries are preserved as the defaults for your next session.

Access to Excel 2003 or higher is required to run the AgileESM© Calculator. If file input is used rather than manual entry, the files must be either Excel or .csv.

Details on how to use the AgileESM© Calculator are currently available in the tool and will soon be published in a separate document. In general terms, you enter parameters through an initial screen (see below) and introduce Planned Value and Earned Value either manually or via a file feed (not shown here). The system generates the AgileESM© results into a separate Excel™ spreadsheet (see below). You then review the results and make the necessary adjustments to the release plan.

Your parameters drive the analysis: information about the sprints, the project start date, and the source of Planned Value and Earned Value input. If you choose the Manual entry option, you are presented with an additional window.

Based on the parameters you enter, the Calculator determines the AgileESM© results and places them in a separate Excel file™.  The report echoes the Planned Values and Earned Values provided for the relevant sprints. It then presents the Earned Schedule, Schedule Performance Analysis for time, the Estimate at Completion for time, and the estimated release date. A graph depicts the baseline schedule and the amount of schedule earned.



Full-sized Image