follow this link u get demo for that
Shailesh Sonar’s Estimate.
v Let us learn how to generate Bill of Quantity (BOQ) & Study its Market Rate Justification.
v Abstract sheet is summary of market rate Justification Statement which is final output.
v Detailed estimate sheet contains sub head wise Sum of DSR amount. It also resembles the summary of detail items which we will be entering.
v For the detail item sheet inputs are given from Sheets of DSR, Material, Labour, Tool & Plants & Carriage.
v DSR- includes all detail DSR rates item wise along with justified rates (justified rate means it is calculated from current Market Rates)
v Material- it includes all type of Material description along with unit & rate (Current Market Rate).
v Labour- it include all categories of Labour along with unit & rate (Current Market Rate).
v Tools & Plants- includes all type of hirable & non Hirable Services like crane, Pump etc. (Please Note: - Above hire - charges include cost of services of operating staff and supply of lubricating oil)
v Carriage- includes Mechanical loading, Unloading & Stacking all kind of Materials along with unit & rate (Current Market Rate). (Note: - These rates are exclusive of contractor’s profit and overhead charges)
v This was brief description about all sheets.
v Now we will proceed to prepare BOQ with efficient & in easy manner.
Steps to be followed:-
1) First go to detail item sheet, on top right corner you will see 8 tabs mentioning building work, compound wall work, retaining wall work, drainage work, water supply work, road work.
2) Just click on any 1 above mentioned tabs, you will get respective work general items which u can see in item description column directly.
3) Then you enter the quantities only in quantity column with respect to your drawing’s specification.
4) Now u can directly go to the Abstract sheet where you will see Market Rate Justification against DSR statement.
5) If we want assign subcontractor to do same work with his own rate then go to detail item sheet again, in Contractor Rate column just put the contractor rates.
6) Now again go to abstract sheet, you will see Market rate justification against contractor’s Rate.
7) If you want to give the contractor Material Advance payment then you should go to (M constant) sheet where all type of items material constants are available, just put the quantity you will get material requirement as desired & total amount of payment against Contractor’s requirement on directly shows in Abstract sheet.
Nice ..... do you know about AutoScan and AutoSteel plugin / add on for AutoCad developed by Newton Software Pvt Ltd, Pune. AutoScan help me out to get BOQ instantly in excel format as well as AutoSteel gives BOQ and BBS from AutoCad drawings with 100% accuracy. Its saving my time .
Dear Shailesh
Your file is not available, kindly reload the same
Regards
Ismail
Dear Shailesh
Your file is not available, kindly reload the same
Regards
Ismail
Link is still not visible so please provide the link. thanks
tarun
Hi! Sailesh,
The Link is not available anymore. can you pl. reload the same data ?
Vijay
Hi Shailesh,
I can't see your data.
Sudarshan
Hi Shailesh,
I can't see your data.
Sudarshan
Nice collection according to civil engineering very helpful.
Hi Shailiesh
Nobody outside India would know what 10 Lakh is or a Crore so use the numerals as 100,000.00 and they will understand better.
Best regards
Mike Testro