YogiPWD

Estimate Calculation Tool (SSR 2022-23)

Yogendra May 05, 2026
PWD SSR Estimate Tool

Estimate Calculation Tool (SSR 2022-23)

Initializing connection to Google Sheets...
Item No Description Unit Qty SSR Rate Net Rate Lead Final Rate Amount Actions

Project Abstract

Total Cost calculations will appear here.

Material Consumption Summary

Enter items to see consumption...

Functioning of this tool

  • SSR-based estimation
  • Material consumption analysis
  • Lead charge calculations
  • BOQ preparation
  • GST and abstract generation
  • Project storage and retrieval

1. Purpose of the System

The software behaves like a digital estimation office used in:

  • PWD Departments
  • MoRTH Projects
  • Irrigation Works
  • Building Construction
  • Road Projects
  • Bridge Works
Engineering Activity Code Function
SSR Item Selection addItem()
Lead Charge Calculation interpolateLead()
Rate Analysis recalculateAll()
Estimate Abstract updateSummaries()
Project Saving saveToDB()

2. Database Initialization

const request = indexedDB.open("PWDEstimateDB", 1);

This creates a local browser database for storing projects.

Equivalent Civil Engineering Meaning:
  • Digital Estimate Register
  • DPR File Storage
  • Tender Estimate Archive

Each project is saved using: 

db.createObjectStore("projects", { keyPath: "name" });

Example Project Names:

  • Construction of CC Road
  • Bridge Repair Estimate
  • Road Widening Work

3. SSR and Lead Data Loading

const SSR_CSV = "...";
const LEAD_CSV = "...";

The software loads:

  • SSR Schedule of Rates
  • Lead Charge Tables

SSR Sheet Contains

  • Item Codes
  • Descriptions
  • Units
  • SSR Rates
  • Material Consumption Factors

Lead Sheet Contains

  • Murum Lead Rates
  • Sand Transportation Rates
  • Metal Lead Charges
  • Cement Transportation Costs

4. Material Mapping Logic

const materialMapping = {
    "Murum": 'D',
    "Natural Sand": 'J'
}

This maps materials to their corresponding lead-rate columns.

Engineering Meaning:

If Murum transportation rates are stored in Column D, the software automatically fetches transportation charges from Column D.

5. Material Consumption Factors

const matColumns = {
    "Cement": 'K',
    "Steel": 'P'
}

Every SSR item consumes materials. The software extracts these automatically.

SSR Item Cement Sand Aggregate
PCC 1:4:8 1.5 Bags 0.45 m³ 0.90 m³
This enables:
  • Material Statements
  • Quarry Planning
  • Lead Analysis
  • Royalty Estimation
  • Transport Logistics

6. Initialization Function

async function init()

This initializes the entire estimating system.

It:

  • Downloads SSR Data
  • Downloads Lead Data
  • Parses Spreadsheets
  • Activates Estimation Engine

7. Column Letter Conversion

function letterToIdx(letter)

Converts spreadsheet columns:

  • A → 0
  • B → 1
  • AA → 26

This bridges spreadsheet engineering data with software calculations.

8. Lead Charge Interpolation

function interpolateLead(dist, colLetter)

This is the most important engineering calculation in the software.

Engineering Principle

Lead rates are available at fixed intervals.

Distance Lead Rate
5 km ₹120
10 km ₹180

If actual lead distance is 7 km, the software calculates intermediate transportation rate automatically.

Interpolation Formula:

y = y1 + ((x - x1) × (y2 - y1) / (x2 - x1))
Used In:
  • Earthwork
  • Road Construction
  • Canal Excavation
  • Bridge Works
  • Embankment Projects

9. Adding SSR Items

function addItem()

This acts like BOQ entry software.

Engineer enters:

  • SSR Item Code
  • Quantity

The system:

  • Searches SSR Database
  • Retrieves Rates
  • Adds Item to Estimate

10. Quantity Editing & Deletion

editItem()
deleteItem()

Equivalent to:

  • BOQ Revision
  • Quantity Corrections
  • Variation Statement Modifications

11. Project Saving

saveToDB()

Stores:

  • Estimate Items
  • Lead Distances
  • Cess Settings
Equivalent Civil Engineering Meaning:
  • Saving DPR Files
  • Tender Estimate Storage
  • Project Archive

12. Recalculation Engine

function recalculateAll()

This is the core estimation engine.

Step 1 – Material Consumption

matTotals[m] += factor * item.inputQty;

Example:

  • PCC requires 2 cement bags/m³
  • Quantity = 10 m³
  • Total Cement = 20 Bags

13. Net SSR Rate Calculation

const netRate = ssrRate - (ssrRate * cessFact);

This deducts:

  • Labour Cess
  • Department Recoveries
  • Royalty Adjustments

14. Lead Charge Calculation

itemLeadCost += (factor * leadRate);

Calculates transportation cost of each material.

Material Consumption Lead Rate Lead Cost
Cement 5 Bags ₹12/Bag ₹60

15. Final Rate Derivation

finalRate = netRate + itemLeadCost

Final item rate includes:

  • Net SSR Rate
  • Transportation Escalation

16. Amount Calculation

amount = finalRate × quantity
Amount = Rate × Quantity

Equivalent to standard BOQ calculations.

17. Material Summary

updateSummaries()

Generates:

  • Material Statements
  • Lead Statements
  • Consumption Abstracts
Material Quantity Lead Charges
Cement 250 Bags 40 km ₹15,000
Sand 18 m³ 12 km ₹7,200

18. GST Calculation

const gst = grandTotal * 0.18;

Adds 18% GST to estimate.

19. Estimate Abstract

Final Estimate:

Grand Total = Civil Cost + Lead Charges + GST

Equivalent to:

  • Administrative Approval Abstract
  • Tender Schedule Amount
  • DPR Cost Summary

20. Dynamic Material Leads

updateLeadDist(material, val)

Allows separate lead distances for each material.

Material Lead Distance
Murum 8 km
Sand 35 km
Cement 120 km
Very useful for:
  • Hill Roads
  • Remote Villages
  • Bridge Projects
  • Irrigation Works

21. JSON Export/Import

exportJSON()
importJSON()

Equivalent to:

  • Estimate File Backup
  • Project Sharing
  • DPR Transfer Between Offices

22. Engineering Strengths

  • Automated Rate Analysis
  • Dynamic Material Consumption
  • Material-wise Lead Calculation
  • Offline Project Storage
  • Reusable SSR Database
  • Fast Quantity Revisions

23. Practical Civil Engineering Applications

  • PWD Estimates
  • MoRTH Road Projects
  • Bridge Works
  • Irrigation Estimates
  • Building BOQs
  • Tender Costing
  • Contractor Billing
  • DPR Preparation

24. Equivalent Commercial Software

This code partially replicates features of:

  • PWD Estimate Software
  • CivilMantra
  • Candy
  • CostX
  • Excel-based DPR Systems

25. Final Engineering Interpretation

This software is a browser-based SSR-driven civil estimation engine integrating:
  • Material Consumption Analysis
  • Lead Charge Interpolation
  • Transportation Costing
  • Abstract Preparation
  • Persistent Project Management

In practical civil engineering terms, it automates the complete workflow from SSR item selection to final estimate abstract generation with realistic material transportation logistics.

Tags:

Post a Comment

0 Comments

If you have any doubts, suggestions , corrections etc. let me know