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.

Budgeted Quantity (with Different Cost Category)

6 replies [Last post]
Tue, 2009-01-20 02:59
Jun Gallardo
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 12 Apr 2008
Posts: 22
Groups: Civil Engineering, Pinoy Planning Planet Community
Hello everyone.

I made a schedule that is resource loaded. My resources include Material and Manpower. Cost Categories are assigned with Material as M and Manpower as L. Normally, adding a new column for BUDGETED QUANTITY in the layout sum up both the quantities of the Material and Manpower resources. My problem is how to add a new column separating both the quantity of the material and that of the labor. I know this is possible in the tabular reports but I want it to be presented in the layout.

Regards.

JUN
Top

Replies

Thu, 2009-01-22 03:35
#1
Jun Gallardo
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 12 Apr 2008
Posts: 22
Groups: Civil Engineering, Pinoy Planning Planet Community
Dear Ferdinand,

Thank you. It worked.
Top
Wed, 2009-01-21 04:42
#2
Ferdinand U.
User offline. Last seen 6 years 34 weeks ago. Offline
Joined: 19 Jul 2007
Posts: 142
Groups: Pinoy Planning Planet Community
Create Data Custom: Assign BQL-Labor BQ & BQM-Mat’l BQ


for Manpower
if: CAT eq L

then: BQL eq BQ (or BC if Cost)

for Material
if: CAT eq M

then: BQM eq BQ (or BC if Cost)
Top
Wed, 2009-01-21 00:52
#3
Jun Gallardo
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 12 Apr 2008
Posts: 22
Groups: Civil Engineering, Pinoy Planning Planet Community
Mr. Iimos,

Yes, I know how to use the Global Change, but my main problem is how to provide logic to it applicable to what I need. I tried using the logic for Cost Category but failed. I even filtered first the schedule based on resources containing Cost Cat. of "M" and "L" but was unsuccessful. More help plss....
Top
Tue, 2009-01-20 04:22
#4
Anoon Iimos
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
first go to Data, Custom Data Items, create your items, then play with global change
Top
Tue, 2009-01-20 03:24
#5
Jun Gallardo
User offline. Last seen 8 years 11 weeks ago. Offline
Joined: 12 Apr 2008
Posts: 22
Groups: Civil Engineering, Pinoy Planning Planet Community
Anoon,

Maybe yes, but I tried doing the global change but was unsuccessful after a series of trials. Can you please provide me more details on how to execute your suggestion.

Regards.

Jun
Top
Tue, 2009-01-20 03:19
#6
Anoon Iimos
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
if I remember correctly, I think you can use custom data items and make some global changes to suit what you need.
Top