Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Estimation, Rate Analysis, BOQ, DSR,

9 replies [Last post]
Shailesh Sonar
User offline. Last seen 3 years 7 weeks ago. Offline
Joined: 10 Oct 2011
Posts: 7

 

follow this link u get demo for that

http://bit.ly/HZzSyf

 

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.

Replies

Praveen Palkhade
User offline. Last seen 3 years 47 weeks ago. Offline
Joined: 17 Oct 2015
Posts: 2
Groups: None

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 .

Ismail Awad
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 20 Dec 2009
Posts: 12

Dear Shailesh

Your file is not available, kindly reload the same

 

Regards

 

Ismail

Ismail Awad
User offline. Last seen 3 years 29 weeks ago. Offline
Joined: 20 Dec 2009
Posts: 12

Dear Shailesh

Your file is not available, kindly reload the same

 

Regards

 

Ismail

Tarun Chopra
User offline. Last seen 4 years 17 weeks ago. Offline
Joined: 13 May 2014
Posts: 2
Groups: None

Link is still not visible so please provide the link. thanks

 

tarun

Vijayasarathi Ravi
User offline. Last seen 1 year 6 days ago. Offline
Joined: 2 Aug 2012
Posts: 8

Hi! Sailesh,

The Link is not available anymore. can you pl. reload the same data ?

Vijay

sudarshan singh
User offline. Last seen 3 years 42 weeks ago. Offline
Joined: 20 May 2011
Posts: 19
Groups: None

Hi Shailesh,

I can't see your data.

 

Sudarshan

sudarshan singh
User offline. Last seen 3 years 42 weeks ago. Offline
Joined: 20 May 2011
Posts: 19
Groups: None

Hi Shailesh,

I can't see your data.

 

Sudarshan

waqas ur rehman
User offline. Last seen 5 years 25 weeks ago. Offline
Joined: 23 Jul 2012
Posts: 2

Nice collection according to civil engineering  very helpful.

Mike Testro
User offline. Last seen 4 days 3 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4393

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