Itemized Construction Estimator

I need an Excel-based estimating template designed to capture construction costs line by line and organized according to CSI Divisions. The spreadsheet should allow me to enter individual cost items, including labor, materials, equipment, subcontractor costs, and any other project-related expenses. Each line item should automatically calculate the extended total based on quantity and unit price, with an overall project total that updates automatically as items are added or revised.
The template should focus on a detailed, itemized estimate rather than a high-level summary and should be structured in a professional format suitable for commercial construction estimating and proposal development.
I will provide an example template; however, the current version is more of a general contractor template. I need this revised into a more trade-specific estimating template for a drywall and painting contractor. The template should specifically support scopes including painting, drywall, metal framing, acoustic ceilings, power washing, general cleaning, floor protection, demolition, insulation, door/frame/hardware installation, and Division 10 specialties.
Deliverables:
One unlocked data-entry worksheet
Organized by CSI Divisions with clearly labeled sections
Trade-specific formatting tailored toward drywall and painting construction scopes
Columns for description, quantity, unit, unit price, markup, and calculated line total
Global markup cell that automatically adjusts all applicable pricing based on the entered percentage
Header section for project name, client, estimator, bid date, and revision date
Grand total cell that updates automatically as data is added or revised
Qualifications and exclusions section
Alternates section for value engineering or optional pricing
Color-coded prompts or conditional formatting to flag missing quantities or unit prices
Protected formulas and summary cells to prevent accidental edits while remaining transparent for review
Row grouping capability by trade, division, or phase without affecting calculations
Professional formatting suitable for client-facing proposals
Scope Categories / CSI Divisions to Include:
Demolition
Metal Framing
Drywall
Insulation
Acoustical Ceilings
Painting & Coatings
Power Washing
General Cleaning
Floor Protection
Doors, Frames & Hardware
Division 10 Specialties
Carpentry / Blocking as needed
Miscellaneous Repairs & Patching
Acceptance Criteria:
The file must open in Excel without compatibility issues.
Sample data must calculate correctly without requiring manual refresh.
Hiding or unhiding rows by CSI Division, trade, or phase must not break formulas or totals.
Markup adjustments must update all applicable pricing automatically.
All formulas must remain intact and protected while allowing editable input fields for estimating.
* Change up the "FINAL" sheet differently and make it look professional as this will be the proposal being sent to customers. *
I don't mind graphs or charts showing the profit, overhead, and construction cost, or subcost