Crescent Capital Advisors

Modernization Estimate Worksheet in AI Era

This worksheet lists the 33 items a modernization estimate should cover. For each item, enter what you counted, how many days each one takes, your low and high figures, and where the numbers came from. The worksheet adds up the effort, the cost and the minimum schedule, and it lists the gaps to fix before you submit the estimate.

No checklist covers every system. If yours needs an item this list does not have, add it in the notes of the closest item, or use the AI prompt in the article to build a version that fits your environment.

Each item should have a number, a discovery task, or a written reason it does not apply. Hover over or press any button to see what a field means.

Example figures. The numbers loaded now only show how the worksheet works. They are not a benchmark. Replace every example value with evidence from your own program.
Effort0range
Minimum schedule0before dependencies and calendar dates
Cost$0range
Monthly running costnot setnew system after retirement
Addressed0/0have a status other than not reviewed
Estimated0/0have effort entered
Gaps to fix0listed below

Team and running costs

The minimum schedule divides the effort by the time people have. It assumes everyone can work on anything. The delivery date may be later once work that must happen in order, scarce specialists and customer dates are included.

Gaps to fix before you submit

Save or share

You can paste the CSV into Excel or Google Sheets. This page keeps your entries only in this browser, where the browser allows it. Copy or download the CSV before you close the page if you need to keep or share your estimate.