Quantity Estimation excel sheet
Its easy to create
Go to excel, create new sheet, name it as whatever you want and add description like company name, project etc.
Create table with row headings as below
Sr. No. | Description | Unit of Measurement | Nos | Length | Widht | Height or Depth | Quantity | Remarks
Now put first item Excavation
If its single then directly fill rows in front of it, if its in blocks/ section then write in below row
Block1 or flat 1 or tower 1 north or any naming you want by marking it on drawing
Then put measurement
Say i have single measurement so
Excavation | Cum | 1 Nos | 10m | 10m | 1m | 100 | i just learn how to make estimation sheet.
Put the formula in excel to calculate quantity automatically
Which will be product of
Nos x L x B x H or D in case of cum
Nos x L x B in case of sqm
Nos x L in case of Rm
Its simple to do.