BOQ & schedule

Hi Osama,
usually we relate BOQ items to activities and not vice versa.
All cases that you mentioned can exist in one schedule.
Best Regards,
Vladimir

Thanks
NOw for case No. 1 how the many activities will reflect the amount of single itme in BOQ.
and the same for the case No. 3

Regards,

If you create the construction model you will have many activities for concreting, each for certain amount (volume).
If your model is not very detailed then you may choose to set one activity that includes both concreting and reinforcement. This activity will consume both concrete and metal.
The total quantitiy is the sum of amounts on separate activities.

Regards,
Vladimir

Hi Osama

I assume that the purpose of the clients request is to make the triangular link between time - scope and money.

First you must extract the labour resources from the BOQ and set them down on a spreadsheet. I keep things simple by using one resource called "Hours" or "Days" depending on the level of detail required.

On another sheet copy paste the programme activities and put a code number agaist each one.

Go back to the BOQ sheet and put the chart line code against against each entry.

Then

1- Many activties related to one itme of BOQ -

Sort and total the relevant resources and add to the chart task.

2- One activity related to one item of BOQ

Just add the resource to the task

3- One activity related to many items of BOQ

Copy the BOQ item for each task number then allocate the total resource to the the activities pro rata to respective durations.

If you are modelling durations by the resources then you will have to put a realistic gang size into the formula.

Best regards

Mike Testro

Osama,

Once I modeled BOQ within SureTrak because the Owner insisted on it, you can get some ideas from the following PP topic, explore it as a curiosity.

http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=1&Top=66157&page=1

For practical purposes I do not recommend it, Mikes approach is by far easier and less error prone, I suspect is what most are doing. I have not found a better way yet.

If using a spreadsheet you can use the filter functionality in combination of the subtotals formula that will display subtotals for filtered values only. The totals function will always display all values within a range, including those hidden after running a filter.

Best regards,
Rafael

Thanks for all
Actually all mentioned concept i aware of it. but how to acheive it by P3 this is the point.
Simply I make resouce related to the code of each item in the BOQ with budgeted cost = item amount.
Up to now it is work but I don’t know if this will continue or not.

Hi Osama

Using P3 your job takes much longer as each resource has to be typed in.

Other types of software allow a copy paste function directly from the spreadsheet.

The spreadsheet I use is Lotus 123 where the
@dsum(range,field,#criteria#) function gives you totals of all BOQ items with the same line code. This does not work so well in excell.

Buy Lotus 123 from IBM or Ebay and your spreadsheets will work much better.

Best regards

Mike Testro

It is freindly use like axcel

Hi Osama

Excell copied Lotus so the commands are similar.

Its just that Lotus can do so much more than excell - particularly in data management.

Best regards

Mike Testro

Osama,

Pivot Tables are more powerful than individual formulas for this purpose. I use subtotal formulas in my spreadsheets as a complement to the Pivot Tables.

Lotus 123 dsum formula is also available in Excel and is another option if you are not used to pivot tables.

The advantage of pivot tables is that no matter how many new BOQ items you add into the range they will automatically be included in the table, no need to manually add extra formulas.

Best regards,
Rafael

Please
Could you privide sample excel sheet or lotus file to my e-mail ausamawared@yahoo.com
Regards,

Please download sample Excel file from the following link.

http://rapidshare.com/files/323899306/Sample_BOQ_Pivot_Table.xlsx

Best regards,
Rafael

Osama,

If you want to have both the BQ and the schedule combined in same package I can recommend CANDY (www.ccssa.com). They are quite "big" in UAE. Package purely developed for the construction industry by construction people.

You have the chance (i.e. optional) to fully link the schedule and the BQ with all the options you have asked about. At all times you’ll know exactly how much of one BQ-item have been allocated to which activities (and vice versa), what is missing of the BQ-items yet to be allocated (both resources and materials), if BQ-item over-allocated, etc. Furthermore, it contains some other neat features.

As you have also done your estimation for the project in CANDY based on the BQ, you basically have most of the info you need to do the time schedule with, such as man-hours, unit rates, etc. Actually, CANDY can automatically do a quick schedule for you based on the above, even though I’ve never used that. In addition, you can do cash-flow, EVA, valuations, etc. in CANDY.

This is not an add for CANDY and I haven’t used it myself for a couple of years now, however, for your info it is out as an option.

Regards,

Bo