Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

BOQ & schedule

17 replies [Last post]
Fri, 2009-12-18 09:16
Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
The client ask to relate program activities to the items mentioned in the project BOQ and that include many cases
1- Many activties related to one itme of BOQ
2- One activity related to one item of BOQ
3- One activity related to many items of BOQ
Please what is the suitable method to make the relation
Regards,
Top

Replies

Sun, 2013-01-20 15:00
#1
mimoune djouallah
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team

Hi all

 

i wrote a blog post how to link schedule and BOQ with different level of details.

http://www.plannertuts.com/primavera-p6-tutorials/link-the-schedule-to-t...

 

hope you find it useful.

 

regards

mimoune

Top
Thu, 2012-03-29 13:57
#2
reem fayez
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 9 Dec 2011
Posts: 3
Groups: None

Hi osama,how are you 

am new to planning,actually am training to learn it by myself,i bought paul harris book.

I have two questions:

1-do you think i can learn it by myself?

2- can you explain to me more about the def of  the  EPS exactly and what is the responsible manager in promavera means?

Top
Thu, 2012-03-29 13:57
#3
reem fayez
User offline. Last seen 12 years 3 weeks ago. Offline
Joined: 9 Dec 2011
Posts: 3
Groups: None

Hi osama,how are you 

am new to planning,actually am training to learn it by myself,i bought paul harris book.

I have two questions:

1-do you think i can learn it by myself?

2- can you explain to me more about the def of  the  EPS exactly and what is the responsible manager in promavera means?

Top
Mon, 2012-03-26 08:19
#4
Shailesh Sonar
User offline. Last seen 7 years 38 weeks ago. Offline
Joined: 10 Oct 2011
Posts: 7
Groups: Building Information Modelling, GPC Qatar

dear all,

I developed Programme for Making BOQ & Its Market Rate Justification, it is very useful for Earn Value analysis you can see it on following link

http://www.youtube.com/watch?v=6TdsII1Nud0

Thanks & Regards

Shailesh

Top
Mon, 2009-12-21 10:05
#5
Bo Johnsen
User offline. Last seen 8 years 7 weeks ago. Offline
Joined: 28 Feb 2006
Posts: 119
Groups: Building Information Modelling, Civil Engineering
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

Top
Mon, 2009-12-21 08:30
#6
Rafael Davila
User offline. Last seen 3 hours 15 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Please download sample Excel file from the following link.

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

Best regards,
Rafael
Top
Mon, 2009-12-21 00:27
#7
Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
Please
Could you privide sample excel sheet or lotus file to my e-mail ausamawared@yahoo.com
Regards,
Top
Sun, 2009-12-20 11:09
#8
Rafael Davila
User offline. Last seen 3 hours 15 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
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
Top
Sun, 2009-12-20 05:16
#9
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
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
Top
Sun, 2009-12-20 04:15
#10
Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
It is freindly use like axcel
Top
Sun, 2009-12-20 03:28
#11
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
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
Top
Sat, 2009-12-19 13:09
#12
Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
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.
Top
Sat, 2009-12-19 11:58
#13
Rafael Davila
User offline. Last seen 3 hours 15 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
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...

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
Top
Sat, 2009-12-19 09:15
#14
Mike Testro
User offline. Last seen 4 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418
Groups: Building Information Modelling, Content Moderators, GPCCAR Editors
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
Top
Sat, 2009-12-19 05:32
#15
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
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
Top
Sat, 2009-12-19 05:00
#16
Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
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,
Top
Sat, 2009-12-19 03:14
#17
Vladimir Liberzon
User offline. Last seen 16 weeks 3 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
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
Top