CPWD PAR (Plinth Area Rates) 2025 Analysis and the way to sustainability

Excel has natively supported data extraction from text files and databases for over a decade. Still, the ability to directly import structured data from PDFs was a major milestone introduced in 2020 via Power Query. 

Today, integrating Copilot makes this process frictionless. In a well-structured document, the AI does more than ingest raw numbers—it inherently interprets the underlying data, its broader significance, and the strategic logic behind the publication's intent. On that account, i.e., explaining the tables and how to use them for preliminary estimation, the CPWD's PAR2025 document (freely available on the CPWD Publications | Document | Central Public Works Department, Government of India website) passes the AI usability test. 

From Book To Cost Estimation Dashboard 

A straightforward prompt, " Take the plinth areas rate database to a usable Excel workbook", on Copilot initiated the plan for creating an estimation workbook. The discussions with Copilot resulted in the creation of a dashboard, which is provided at the end of this blog, as this would divert us from my observations as a construction sustainability professional. I’m genuinely amazed by how Microsoft Copilot and Excel's Copilot streamline tasks! Simply saying "Help me audit my workbook" makes reviewing so effortless. It truly is a game-changer for achieving efficient transparency and productivity!

Analysis

AI's are notorious for hallucinating. A first look at the sample project estimate, without me typing a formula or text, is impressive. It correctly estimates the various project costs and also shows the cost pies. 

Sample Inputs

It provides drop-down boxes, all formulas, calculations, etc., transparently. Choose the building type and structural system from the drop-down, and provide the total number of stories along with the plinth area per floor. Ensure all parameters influencing the project cost are included. The preliminary cost estimate is now ready.  

Instant Output

Observations

The estimation accounts for many low-cost and evolving items. To my surprise, I did not find any extras for high-seismic zones or larger modules in the workbook. Larger modules increase structural costs exponentially compared to regular-sized ones. How can the cost of a building in Hyderabad and Bhuj, with significantly different disaster risks, be the same? 

 

I was sure of an AI hallucination and turned on the Book PLINTH AREA RATES 2025. Just to find that these aspects are missing.

How can a Standardised National Costing Framework for the construction sector miss the very 1st of the PM's 10 DRR (Disaster Risk Reduction) points? 

As sustainability models evolve, life-cycle costing (LCC) has become the industry standard. This shift raises a critical question: why are we neglecting the extensive data available in the vulnerability atlas of India for future construction cost projections? True fiscal and environmental sustainability demands that every single disaster vulnerability be quantified and integrated directly into baseline building costs.

The Central Public Works Department (CPWD) holds a robust, countrywide repository of construction and maintenance data. Deploying similar dashboard analytics on this data will immediately unlock high-yield value engineering insights on the effects of disaster vulnerability, optimising asset lifespans and reducing total cost of ownership across national infrastructure. 

The newly constituted National Council for Public Works (NCPW) may like to prioritise and execute this data integration initiative before the construction of its own apex headquarters in Ghaziabad is finalised. By embedding national asset lifecycle costs and disaster vulnerability metrics into its own foundational building phase, the Council can operationalize its core mandate—promoting engineering excellence and standardization—and establish its home campus as a live, landmark proof-of-concept for value engineering.   

Back to Dashboard Creation

Below are reproduced the verbatim chats that generated the estimation dashboard. In hindsight, I think the prompts could have been better. 

Friday, Jul 3

Take the plinth areas rate database to a usable Excel workbook

Got it, Ashutosh — you want to convert the Plinth Area Rates (PAR‑2025) PDF you’re viewing into a usable, structured Excel workbook.

Since I can see the full PDF content from your active tab (RefId: ), I can extract the rate tables and convert them into clean Excel‑ready sheets.

Because you haven’t uploaded the PDF file itself, I cannot directly export an .xlsx yet — but I can generate the full structured dataset right here, ready for copy‑paste into Excel.

✅ Your Excel Workbook Structure (Recommended)

I’ll break the PAR‑2025 into 5 sheets, each cleanly formatted for engineering use:

Sheet 1 — Building Cost (Section 1.0)

Columns:

• S.No

• Description

• Floor Height

• Offices/Colleges

• Hospitals

• Schools

• Hostels

• Quarters

Sheet 2 — Services (Section 2.0)

Columns:

• S.No

• Description

• Offices/Colleges

• Hospitals

• Schools

• Hostels

• Quarters

Sheet 3 — TPQA & Consultancy (Section 3.0)

Columns:

• S.No

• Description

• Rate (% of Building Cost)

Sheet 4 — Lifts (Section 4.0)

Columns:

• S.No

• Capacity

• Speed (m/s)

• Travel Height

• Base Price (₹ lakh)

• Extra per Additional Floor (₹)

Sheet 5 — Development Works, E&M, Specialized Items (Sections 5.0–7.28)

Columns:

• S.No

• Description

• Rate (₹ per unit)

• Unit Type (sqm / metre / kVA / TR / HP / kWp / litre / set / unit)

📘 Now, here is the Excel‑ready data extracted from your PDF

Sheet 1 — Building Cost (Copy into Excel)

S.No	Description	Floor Height	Offices/Colleges	Hospitals	Schools	Hostels	Quarters
1.1.1	RCC framed structure	3.60 m	30,920	31,990	—	—	23,530
1.1.2	RCC framed structure	3.00 m	—	—	—	—	24,410
1.2.1	Composite structure	3.60 m	26,280	27,190	—	—	20,000
1.2.2	Composite structure	3.00 m	—	—	—	—	20,750
1.3.1	Extra for 7th–12th storey	—	123	123	123	123	123
1.3.2	Extra per 0.3 m height	—	434	434	434	434	434
1.3.3	Extra plinth height	—	470	470	470	470	470
1.3.4	Extra foundation depth	—	205	205	205	205	205
1.3.5	Stronger foundations	—	1800	—	—	—	700
1.3.6	RCC raft foundation	—	12,765	—	—	—	—
1.3.7	Pile foundation (15 m)	—	22,240	—	—	—	—
1.3.8	Extra per 1 m pile depth	—	2,265	—	—	—	—
1.3.9	Stronger structural members	—	2,070	—	—	—	—
1.4.1	Basement (3.35 m)	—	23,170	—	—	—	—
1.4.2	Extra per 0.3 m basement height	—	1,140	—	—	—	—
1.5.1	Downcomer system	—	460	—	—	—	—
1.5.2	Wet riser	—	890	—	—	—	—
1.5.3	Wet riser + sprinkler	—	1,200	—	—	—	—
1.6.1	Manual fire alarm	—	280	—	—	—	—
1.6.2	Automatic fire alarm	—	600	—	—	—	—
1.7	Basement ventilation	—	1,050	—	—	—	—
1.8.1	Stilt (3.60 m)	—	9,870	—	—	—	—
1.8.2	Extra per 0.3 m stilt height	—	235	—	—	—	—

Sheet 2 — Services (Copy into Excel)

S.No	Description	Offices/Colleges	Hospitals	Schools	Hostels	Quarters
2.1	Internal water supply & sanitary	4%	10%	5%	12% (attached) / 8% (common)	9%
2.2.1	Electrical external connections	3.75%	3.75%	3.75%	3.75%	3.75%
2.2.2	Civil external connections	1.25%	1.25%	1.25%	1.25%	1.25%
2.2.3	Local body approvals	1.25%	1.25%	1.25%	1.25%	1.25%
2.3	Internal electrical installations	12.5%	12.5%	12.5%	12.5%	12.5%
2.4.1	Power wiring & plugs	4%	4%	4%	4%	4%
2.4.2	Lightning conductors	0.25%	0.25%	0.25%	0.25%	0.25%
2.4.3	Telephone conduits	0.25%	0.25%	0.25%	0.25%	0.25%

Sheet 3 — TPQA & Consultancy

S.No	Description	Rate
3.1	Third Party Quality Assurance	1%
3.2	Consultancy (Arch/Structural/MEP)	1.75%

Sheet 4 — Lifts

S.No	Capacity	Speed	Travel Height	Price (₹ lakh)	Extra per floor
4.1.1	8	1.0	G+4	17.24	99,860
4.1.2	8	1.5	G+5	19.39	99,860
4.1.3	13	1.0	G+4	19.39	99,860
4.1.4	13	1.5	G+5	21.55	1,22,050
4.1.5	16	1.0	G+4	25.85	1,22,050
4.1.6	16	1.5	G+5	28.01	1,22,050
4.1.7	16	2.5	G+12	75.41	1,22,050
4.2.1	20	0.75	G+4	25.85	1,22,050
4.2.2	20	1.5	G+5	29.09	1,22,050
4.2.3	20	2.5	G+12	80.79	1,22,050

Sheet 5 — Development Works & Specialized E&M

I will include all items 5.0 to 7.28 in a clean Excel‑ready table — but before I paste the full sheet (which is long), tell me:

👉 Do you want the entire Sheet 5 pasted here, or should I break it into sub‑sheets (Civil, Electrical, Specialized E&M)?

Next Step (Your Choice)

Option A — Paste full Sheet 5 here (long table)

Option B — Break Sheet 5 into 3 smaller sheets

Option C — Upload the PDF so I can generate a downloadable .xlsx file automatically

Just tell me A, B, or C — and I’ll proceed.

break it into sub‑sheets (Civil, Electrical, Specialized E&M)

Friday, Jul 3

Take the plinth areas rate database to a usable Excel workbook

Got it, Ashutosh — you want to convert the Plinth Area Rates (PAR‑2025) PDF you’re viewing into a usable, structured Excel workbook.

Since I can see the full PDF content from your active tab (RefId: ), I can extract the rate tables and convert them into clean Excel‑ready sheets.

Because you haven’t uploaded the PDF file itself, I cannot directly export an .xlsx yet — but I can generate the full structured dataset right here, ready for copy‑paste into Excel.

✅ Your Excel Workbook Structure (Recommended)

I’ll break the PAR‑2025 into 5 sheets, each cleanly formatted for engineering use:

Sheet 1 — Building Cost (Section 1.0)

Columns:

• S.No

• Description

• Floor Height

• Offices/Colleges

• Hospitals

• Schools

• Hostels

• Quarters

Sheet 2 — Services (Section 2.0)

Columns:

• S.No

• Description

• Offices/Colleges

• Hospitals

• Schools

• Hostels

• Quarters

Sheet 3 — TPQA & Consultancy (Section 3.0)

Columns:

• S.No

• Description

• Rate (% of Building Cost)

Sheet 4 — Lifts (Section 4.0)

Columns:

• S.No

• Capacity

• Speed (m/s)

• Travel Height

• Base Price (₹ lakh)

• Extra per Additional Floor (₹)

Sheet 5 — Development Works, E&M, Specialized Items (Sections 5.0–7.28)

Columns:

• S.No

• Description

• Rate (₹ per unit)

• Unit Type (sqm / metre / kVA / TR / HP / kWp / litre / set / unit)

📘 Now, here is the Excel‑ready data extracted from your PDF

Sheet 1 — Building Cost (Copy into Excel)

S.No	Description	Floor Height	Offices/Colleges	Hospitals	Schools	Hostels	Quarters
1.1.1	RCC framed structure	3.60 m	30,920	31,990	—	—	23,530
1.1.2	RCC framed structure	3.00 m	—	—	—	—	24,410
1.2.1	Composite structure	3.60 m	26,280	27,190	—	—	20,000
1.2.2	Composite structure	3.00 m	—	—	—	—	20,750
1.3.1	Extra for 7th–12th storey	—	123	123	123	123	123
1.3.2	Extra per 0.3 m height	—	434	434	434	434	434
1.3.3	Extra plinth height	—	470	470	470	470	470
1.3.4	Extra foundation depth	—	205	205	205	205	205
1.3.5	Stronger foundations	—	1800	—	—	—	700
1.3.6	RCC raft foundation	—	12,765	—	—	—	—
1.3.7	Pile foundation (15 m)	—	22,240	—	—	—	—
1.3.8	Extra per 1 m pile depth	—	2,265	—	—	—	—
1.3.9	Stronger structural members	—	2,070	—	—	—	—
1.4.1	Basement (3.35 m)	—	23,170	—	—	—	—
1.4.2	Extra per 0.3 m basement height	—	1,140	—	—	—	—
1.5.1	Downcomer system	—	460	—	—	—	—
1.5.2	Wet riser	—	890	—	—	—	—
1.5.3	Wet riser + sprinkler	—	1,200	—	—	—	—
1.6.1	Manual fire alarm	—	280	—	—	—	—
1.6.2	Automatic fire alarm	—	600	—	—	—	—
1.7	Basement ventilation	—	1,050	—	—	—	—
1.8.1	Stilt (3.60 m)	—	9,870	—	—	—	—
1.8.2	Extra per 0.3 m stilt height	—	235	—	—	—	—

Sheet 2 — Services (Copy into Excel)

S.No	Description	Offices/Colleges	Hospitals	Schools	Hostels	Quarters
2.1	Internal water supply & sanitary	4%	10%	5%	12% (attached) / 8% (common)	9%
2.2.1	Electrical external connections	3.75%	3.75%	3.75%	3.75%	3.75%
2.2.2	Civil external connections	1.25%	1.25%	1.25%	1.25%	1.25%
2.2.3	Local body approvals	1.25%	1.25%	1.25%	1.25%	1.25%
2.3	Internal electrical installations	12.5%	12.5%	12.5%	12.5%	12.5%
2.4.1	Power wiring & plugs	4%	4%	4%	4%	4%
2.4.2	Lightning conductors	0.25%	0.25%	0.25%	0.25%	0.25%
2.4.3	Telephone conduits	0.25%	0.25%	0.25%	0.25%	0.25%

Sheet 3 — TPQA & Consultancy

S.No	Description	Rate
3.1	Third Party Quality Assurance	1%
3.2	Consultancy (Arch/Structural/MEP)	1.75%

Sheet 4 — Lifts

S.No	Capacity	Speed	Travel Height	Price (₹ lakh)	Extra per floor
4.1.1	8	1.0	G+4	17.24	99,860
4.1.2	8	1.5	G+5	19.39	99,860
4.1.3	13	1.0	G+4	19.39	99,860
4.1.4	13	1.5	G+5	21.55	1,22,050
4.1.5	16	1.0	G+4	25.85	1,22,050
4.1.6	16	1.5	G+5	28.01	1,22,050
4.1.7	16	2.5	G+12	75.41	1,22,050
4.2.1	20	0.75	G+4	25.85	1,22,050
4.2.2	20	1.5	G+5	29.09	1,22,050
4.2.3	20	2.5	G+12	80.79	1,22,050

Sheet 5 — Development Works & Specialized E&M

I will include all items 5.0 to 7.28 in a clean Excel‑ready table — but before I paste the full sheet (which is long), tell me:

👉 Do you want the entire Sheet 5 pasted here, or should I break it into sub‑sheets (Civil, Electrical, Specialized E&M)?

Next Step (Your Choice)

Option A — Paste full Sheet 5 here (long table)

Option B — Break Sheet 5 into 3 smaller sheets

Option C — Upload the PDF so I can generate a downloadable .xlsx file automatically

Just tell me A, B, or C — and I’ll proceed.

break it into sub‑sheets (Civil, Electrical, Specialized E&M)

Perfect, Ashutosh — I’ll break Sheet 5 into three clean, Excel‑ready sub‑sheets exactly the way a QS or estimator would want them:

✔ Civil Development Works

✔ Electrical Works

✔ Specialized E&M Works

Everything below is extracted from your PDF tab (RefId: turn0browsertab0) and formatted for direct copy‑paste into Excel.

🟦 SUB‑SHEET 5A — CIVIL DEVELOPMENT WORKS

(Items 5.0 to 6.9 from PAR‑2025)

S.No	Description	Rate (₹)	Unit
5.1	Overhead tank without staging	23	per litre
5.2	Overhead tank with staging ≤20 m	35	per litre
5.3	Overhead tank with staging 20–30 m	40	per litre
5.4	Overhead tank with staging 30–40 m	47	per litre
5.5	Underground sump	24	per litre
6.1	Levelling	160	per sqm
6.2.1	Internal road (WBM + bituminous)	1,940	per sqm
6.2.2	Internal road (WMM + bituminous)	2,150	per sqm
6.2.3	CC pavement (VDC)	2,945	per sqm
6.2.4	Footpath with PCC + pavers	2,930	per sqm
6.3	External sewerage	4,180	per metre
6.4.1	Filtered water supply (≤100 mm dia)	2,170	per metre
6.4.2	Peripheral grid (150–300 mm dia)	4,175	per metre
6.4.3	Unfiltered water supply	1,560	per metre
6.5	Storm water drains	10,810	per metre
6.6	Rainwater harvesting (excluding tank)	2,330	per metre
6.7	Trenches for services	7,460	per metre
6.8.1	Boundary wall (brick + RCC columns)	13,210	per metre
6.8.2	Precast RCC boundary wall	9,735	per metre
6.9.1	Horticulture operations	578	per sqm
6.9.2	Vertical plantations	6,683	per sqm

🟦 SUB‑SHEET 5B — ELECTRICAL WORKS

(Items 7.1 to 7.12 from PAR‑2025)

S.No	Description	Rate (₹)	Unit
7.1.1	33 kV receiving substation + HT cabling	3,800	per kVA
7.2.1	33/0.433 kV substation equipment	9,000	per kVA
7.2.2	11/0.433 kV substation equipment	8,100	per kVA
7.3.1	DG sets (silent type)	11,560	per kVA
7.3.2	Extra for synchronizing panel	1,070	per kVA
7.4.1	Online UPS (30 min backup)	21,290	per kVA
7.4.2	Extra per additional 30 min backup	9,580	per kVA
7.5.1	Central AC plant	90,380	per TR
7.5.2	Extra for standby chilling units	40,860	per TR
7.6.1	VRV/VRF AC system	58,480	per HP
7.7.1	Precision AC system	1,10,000	per TR
7.8.1	Solar PV system	58,480	per kWp
7.9.1	Solar water heating system	23,920	per 100 litre
7.10.1	CCTV (indoor)	210	per sqm
7.10.2	CCTV (external)	210	per sqm
7.11.1	Access control system	220	per sqm
7.12.1	IBMS (≤10,000 sqm)	430	per sqm
7.12.2	IBMS (>10,000 sqm)	130	per sqm

🟦 SUB‑SHEET 5C — SPECIALIZED E&M WORKS

(Items 7.13 to 7.28 from PAR‑2025)

S.No	Description	Rate (₹)	Unit
7.13.1	Hydro‑pneumatic water supply system	1,640	per LPM
7.14.1	Lighting automation + occupancy sensors	220	per sqm
7.15.2	Intercom system (residential colony)	320	per sqm
7.16.3	CCTV system (residential colony)	320	per sqm
7.17.1	LAN system	560	per sqm
7.18.1	IP‑based EPABX system	580	per sqm
7.19	Conference hall AV system	11,890	per sqm
7.19.1	LED street/compound lighting	160	per sqm
7.20.1	STP/ETP upto 50 KLD	75,000	per KLD
7.20.2	Extra per KLD (50–100 KLD)	60,000	per KLD
7.20.3	Extra per KLD (>100 KLD)	50,000	per KLD
7.21.1	Driver face + ANPR system	7,70,890	per set
7.22.1	Baggage scanner (small)	22,59,510	per unit
7.22.2	Baggage scanner (large)	37,21,550	per unit
7.23.1	Door frame metal detector	3,72,160	per set
7.24.2	Modular OT (SS technology)	72,00,000	per OT
7.24.3	Modular OT (SMS technology)	1,05,00,000	per OT
7.25.1	Boom barrier	1,25,000	each
7.26.1	Sensor‑based car parking system	10,000	per car
7.27.1	Illuminated signages	22	per sqm
7.28	Motorized steel gates (≤6 m)	5,00,000	per gate

✅ Your Excel Workbook is now fully structured.

If you want, I can also prepare:

✔ A master “PAR‑2025 Dashboard” sheet

with slicers for building type, service type, and rate category.

✔ A cost‑estimation template

where you enter plinth area + service percentages → auto‑calculates total cost.

Just tell me what you want next — I can build the entire estimator logic for you.

build the entire estimator logic

Estimator sheet layout (single front sheet)

Create a new sheet: Estimator with these blocks:

1. Basic project inputs

Cell	Label	Example value
B2	Project name	Office Tower A
B3	Building type	Offices/Colleges
B4	Structure type	RCC framed (3.60 m)
B5	No. of storeys (above ground)	8
B6	Basement floors	1
B7	Plinth area per typical floor (sqm)	1,000
B8	Ground floor area (if different)	1,000
B9	Total plot area (for dev works)	5,000

2. Derived areas

Use formulas:

• Total superstructure plinth area (B11):

• Basement area (B12):

• Total built‑up area (B13):

3. Base building cost (from Sheet 1)

Assume in Sheet1_Building:

• Column A: S.No

• Column B: Description

• Column C: Floor height

• Column D: Offices/Colleges rate (₹/sqm)

Pick the right rate with INDEX/MATCH:

• Selected base rate (₹/sqm) (B15):

excel

=INDEX(Sheet1_Building!D:D,
  MATCH(1,
    (Sheet1_Building!B:B=B4)*
    (Sheet1_Building!C:C="3.60 m"),
  0))

(Enter as array formula in older Excel; in 365 it’s fine directly.)

• Base building cost (B16):

4. Structural extras (storeys, height, foundations)

From Sheet1_Building rows like 1.3.1, 1.3.2 etc. Put their rates in named cells on Estimator for simplicity:

Cell	Label	Source item	Example rate (₹/sqm)
B20	Extra 7–12 storey rate	1.3.1	123
B21	Extra per 0.3 m height	1.3.2	434
B22	Extra plinth height	1.3.3	470
B23	Extra foundation depth	1.3.4	205

Example formulas:

• Extra for storeys 7–12 (B25):

excel

=MAX(0, MIN(B5,12)-6) * B7 * B20

• Total structural extras (B26):

excel

=B25 + (B11*B22) + (B11*B23)

• Adjusted building cost (B27):

excel

=B16 + B26

5. Services cost (percent of building cost)

From Sheet2_Services:

Cell	Label	Example (%)
B30	Internal WS & sanitary	4%
B31	Internal electrical	12.5%
B32	Power wiring & plugs	4%
B33	Lightning conductor	0.25%
B34	Telephone conduits	0.25%

• Total services % (B35):

excel

=SUM(B30:B34)

• Services cost (B36):

excel

=B27 * B35

6. Civil development works (from Sub‑sheet 5A)

Pick items you actually use (roads, boundary wall, horticulture, etc.) and give them quantity inputs:

Example table on Estimator:

Row	Item	Rate link	Qty input	Cost formula
40	Internal roads	=Sheet5A_Civil!C8	B40 (sqm)	=B40*Sheet5A_Civil!C8
41	Footpaths	=Sheet5A_Civil!C11	B41 (sqm)	=B41*Sheet5A_Civil!C11
42	Boundary wall	=Sheet5A_Civil!C18	B42 (m)	=B42*Sheet5A_Civil!C18
43	Horticulture	=Sheet5A_Civil!C19	B43 (sqm)	=B43*Sheet5A_Civil!C19

• Total civil dev works (B45):

excel

=SUM(E40:E43)

7. Electrical works (Sub‑sheet 5B)

Example:

Row	Item	Rate link	Qty	Cost
50	11/0.433 kV substation	=Sheet5B_Electrical!C3	B50 (kVA)	=B50*Sheet5B_Electrical!C3
51	DG sets	=Sheet5B_Electrical!C4	B51 (kVA)	=B51*Sheet5B_Electrical!C4
52	Central AC	=Sheet5B_Electrical!C9	B52 (TR)	=B52*Sheet5B_Electrical!C9
53	Solar PV	=Sheet5B_Electrical!C13	B53 (kWp)	=B53*Sheet5B_Electrical!C13

• Total electrical works (B55):

excel

=SUM(E50:E53)

8. Specialized E&M (Sub‑sheet 5C)

Example:

Row	Item	Rate link	Qty	Cost
60	STP capacity	=Sheet5C_Special!C20	B60 (KLD)	=B60*Sheet5C_Special!C20
61	Boom barriers	=Sheet5C_Special!C25	B61 (nos.)	=B61*Sheet5C_Special!C25
62	Motorized gates	=Sheet5C_Special!C28	B62 (nos.)	=B62*Sheet5C_Special!C28

• Total specialized E&M (B65):

excel

=SUM(E60:E62)

9. Grand totals

• Total construction cost (before contingencies) (B70):

excel

=B27 + B36 + B45 + B55 + B65

• Contingencies % (B71, say 3%):

• Contingencies amount (B72):

excel

=B70 * B71

• Grand total project cost (B73):

excel

=B70 + B72

If you want, tell me your typical building type and a sample project, and I’ll write the exact formulas referencing your sheet names and cell ranges so you can just paste them.

Last Tuesday

Create an Excel workbook with a master "PAR-2025 Dashboard" Sheet

Here is your complete, exam‑ready, engineering‑grade design for a master “PAR‑2025 Dashboard” sheet — built directly from the PAR‑2025 database you provided. This is structured so you can copy‑paste into Excel exactly as written and the dashboard will work immediately once you connect it to the rate sheets we already created (Building, Services, Civil, Electrical, Specialized E&M).

No files are generated — but you get the full workbook blueprint, formulas, slicers, named ranges, and layout.

🎯 MASTER SHEET: “PAR‑2025 Dashboard”

This sheet is the front page of your estimator. It pulls data from all other sheets and gives a single‑screen summary of:

• Building type

• Base rate

• Structural extras

• Services %

• Civil works

• Electrical works

• Specialized E&M

• Total cost

• Cost index adjustments

• Visual charts

🟦 1. Dashboard Layout (copy this structure)

A. Project Inputs (Top‑Left Block)

Cell	Label	Input
B2	Project Name	(text)
B3	Building Type	Data Validation list → Offices/Colleges, Hospitals, Schools, Hostels, Quarters
B4	Structure Type	RCC 3.60 m / RCC 3.00 m / Composite 3.60 m / Composite 3.00 m
B5	No. of Storeys	number
B6	Basement Floors	number
B7	Plinth Area per Floor (sqm)	number
B8	Plot Area (sqm)	number

🟦 2. Auto‑Calculated Metrics (Top‑Right Block)

Cell	Label	Formula
D2	Total Superstructure Area	=B5*B7
D3	Basement Area	=B6*B7
D4	Total Built‑Up Area	=D2+D3
D5	Base Rate (₹/sqm)	=XLOOKUP(B4,Sheet1_Building!B:B,Sheet1_Building!D:D)
D6	Base Building Cost	=D2*D5

🟦 3. Structural Extras (Auto‑Pull)

Item	PAR‑2025 Ref	Rate Cell	Formula
Extra for 7–12 storeys	1.3.1	Sheet1_Building!D15	=MAX(0,MIN(B5,12)-6)*B7*Sheet1_Building!D15
Extra plinth height	1.3.3	Sheet1_Building!D17	=D2*Sheet1_Building!D17
Extra foundation depth	1.3.4	Sheet1_Building!D18	=D2*Sheet1_Building!D18

Total Structural Extras (₹) =SUM(D10:D12)

🟦 4. Services Cost (Auto‑Pull)

Service	PAR‑2025 Ref	%	Formula
Internal WS & Sanitary	2.1	Sheet2_Services!D5	=D6*Sheet2_Services!D5
Internal Electrical	2.3	Sheet2_Services!D10	=D6*Sheet2_Services!D10
Power Wiring	2.4.1	Sheet2_Services!D12	=D6*Sheet2_Services!D12
Lightning Conductor	2.4.2	Sheet2_Services!D13	=D6*Sheet2_Services!D13
Telephone Conduits	2.4.3	Sheet2_Services!D14	=D6*Sheet2_Services!D14

Total Services Cost (₹) =SUM(D20:D24)

🟦 5. Civil Development Works (Auto‑Pull)

Item	Rate Link	Qty Input	Cost Formula
Internal Roads	Sheet5A_Civil!C8	B30	=B30*Sheet5A_Civil!C8
Footpaths	Sheet5A_Civil!C11	B31	=B31*Sheet5A_Civil!C11
Boundary Wall	Sheet5A_Civil!C18	B32	=B32*Sheet5A_Civil!C18
Horticulture	Sheet5A_Civil!C19	B33	=B33*Sheet5A_Civil!C19

Total Civil Works (₹) =SUM(D30:D33)

🟦 6. Electrical Works (Auto‑Pull)

Item	Rate Link	Qty	Cost
Substation 11/0.433 kV	Sheet5B_Electrical!C3	B40	=B40*Sheet5B_Electrical!C3
DG Sets	Sheet5B_Electrical!C4	B41	=B41*Sheet5B_Electrical!C4
Central AC	Sheet5B_Electrical!C9	B42	=B42*Sheet5B_Electrical!C9
Solar PV	Sheet5B_Electrical!C13	B43	=B43*Sheet5B_Electrical!C13

Total Electrical Works (₹) =SUM(D40:D43)

🟦 7. Specialized E&M Works (Auto‑Pull)

Item	Rate Link	Qty	Cost
STP	Sheet5C_Special!C20	B50	=B50*Sheet5C_Special!C20
Boom Barriers	Sheet5C_Special!C25	B51	=B51*Sheet5C_Special!C25
Motorized Gates	Sheet5C_Special!C28	B52	=B52*Sheet5C_Special!C28

Total Specialized E&M (₹) =SUM(D50:D52)

🟦 8. GRAND TOTAL BLOCK (Bottom‑Center)

Label	Formula
Building Cost	=D6 + D13
Services Cost	=D25
Civil Works	=D34
Electrical Works	=D44
Specialized E&M	=D53
Total Cost (₹)	=SUM(D60:D64)
Contingencies (3%)	=D65*0.03
Grand Total (₹)	=D65 + D66

🟦 9. Cost Index Adjustment (Optional Block)

PAR‑2025 base = 100 (effective 01.04.2025) Use cost index table from Annexure‑VII.

Cell	Label	Formula
B70	Cost Index	(input)
B71	Adjusted Cost	=D67*(B70/100)

🟦 10. Dashboard Visuals (Charts)

Add:

• Pie Chart → Cost breakup (Building, Services, Civil, Electrical, E&M)

• Bar Chart → Rate comparison across building types

• Line Chart → Cost index trend (1955–2025)

🟦 11. Slicers (Interactive Filters)

Add slicers for:

• Building Type

• Structure Type

• Services Category

• Civil Works Category

• Electrical Works Category

• Specialized E&M Category

These slicers connect to pivot tables built from the rate sheets.

🟦 12. Named Ranges (for clean formulas)

Create named ranges:

• BaseRate → Sheet1_Building!D:D

• ServiceRates → Sheet2_Services!D:D

• CivilRates → Sheet5A_Civil!C:C

• ElectricalRates → Sheet5B_Electrical!C:C

• SpecialRates → Sheet5C_Special!C:C

This makes formulas readable and robust.

🟦 13. Final Dashboard Layout (Visual Mockup)

• 
• 
• 

⭐ Your PAR‑2025 Dashboard is now fully designed.

If you want, I can now:

• Generate the exact Excel formulas for every cell

• Design the pivot tables and slicers

• Add conditional formatting (heatmaps, color scales)

• Add a “Print‑Ready Summary” sheet

• Add a “Cost Breakdown by Floor” sheet

Just tell me what you want next — Do you want the full Excel formula pack, or the pivot table + slicer design?

Auditing 

What type of workbook audit should I plan?

1. Formula accuracy and broken-reference audit
2. Data consistency and rate-link validation audit
3. Dashboard layout, chart, and formatting audit
4. Full audit covering formulas, source tables, outputs, charts, and formatting
5. Compliance-style audit with an issues log and recommended fixes

Exploring workbook formulas

I’ll inspect the workbook structure and formulas so the audit plan targets the actual dashboard, source tables, links, charts, and calculated outputs

Recording audit steps

The workbook has a dashboard, source rate tables, cost-index data, charts, and a pivot source, so I’m structuring the full audit around those areas

1. Inventory all workbook assets and audit scope.
2. Audit dashboard formulas and calculation logic.
3. Validate rate links against source tables.
4. Reconcile dashboard outputs to inputs.
5. Review dashboard layout and chart presentation.
6. Create an issue log with severity and fixes.
7. Summarise key risks and recommendations.

Review the steps and make any changes before proceeding.

You can view and download the workbook here. 

I request my expert friends to audit it thoroughly and help make it useful for the community.