According to PWD Standard Data (SDS), to excavate 100 cum of soft soil, the requirement might be:
is not just about tracking numbers; it's about unlocking operational intelligence. With the structured approach above—raw data tables, weighted formulas, dynamic dashboards, and conditional alerts—you can transform Excel from a simple spreadsheet into a real-time productivity command center. pwd rate analysis in excel format
| Machinery | Capacity | Hire Rate (₹/hour) | Fuel (₹/hour) | Operator (₹/hour) | Total ₹/hour | Usage hours per unit output | Cost per Unit (₹) | |-----------|----------|--------------------|---------------|--------------------|--------------|-------------------------------|-------------------| | Concrete mixer | 10/7 cft | 180 | 120 | 70 | 370 | 0.75 | 277.50 | | Vibrator | needle type | 50 | – | – | 50 | 0.50 | 25.00 | | Excavator | 1 cum bucket | 1,200 | 500 | 150 | 1,850 | 0.20 | 370.00 | | Hoist | 500 kg | 150 | 100 | 60 | 310 | 0.30 | 93.00 | According to PWD Standard Data (SDS), to excavate
To create a professional template, set up your columns as follows: Labor Wages The primary objective is to determine
: The quantity of cement, sand, or bricks required per unit of work, multiplied by their current market or PWD-sanctioned rates. Labor Wages
The primary objective is to determine the cost of a unit quantity (per cubic meter, per square meter, per metric ton, etc.) by analyzing: