Investment Estimate Comparison Table Generator

Problem

Feasibility-stage investment estimates often change between the review draft and revised draft, especially in cost scope, subitem names, and serial numbers. Manual line-by-line review can miss canceled items or new items, and may incorrectly pair similar names as the same subitem. investment-estimate-comparison is designed to turn an Excel “review draft vs revised draft” diff into a reviewable comparison table.

How It Works

• It first identifies the workbook structure: total project cost, construction cost, supporting service cost, and top-level group rows.
• It performs cost closure validation by checking that construction cost, service cost, and total cost reconcile, and flags possible extraction gaps when they do not.
• It matches rows within top-level groups, prioritizing name matching while using serial numbers only for placement and ordering; inconsistent names are treated as canceled plus new items.
• It outputs a Sheet1 overall comparison and Sheet2~N detail sheets for each top-level group, with change amount, change rate, matching method, and notes.

Boundaries

It fits project estimate workbooks that follow a “total investment estimate” structure. If templates, sheet names, or cost hierarchy differ significantly, structure-detection rules should be adjusted first. Duplicate serial numbers, identical serials across groups, and zero-fee new items are handled by the skill’s rules, but the source workbook should still be reviewed.