I want Quantity Estimation Xl sheet

Dnyan Deshmukh

Staff member
Kindly do write more clearly.

Quantity estimation sheet is not something fancy and different for all items.

Its single format simple sheet contains
Sr. No, Description , unit of measurement , number of items

Then Length, Width and height or depth

And finally a column showing total quantity and remark.

Do write specific on what you want so that one can help you in it.
 
  • Like
Reactions: Anoop Nimkande

Chetan Yadav

Staff member
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.
 
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.
its working.... THANK YOU SIR