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.

Resouce Based Durations

7 replies [Last post]
Vishnu Kant Mishra
User offline. Last seen 13 years 4 weeks ago. Offline
Joined: 14 Feb 2009
Posts: 34
Groups: None

Hello everybody as we know and always talk about that:

Activity Duration = Work/ Output

Now I put up a question like this in a road construction program i take one activity say earthworks:

Activity     Unit   Qty

Earthwork Cum    10000

Now I calculate the Output of Team as 100 Cum/Hours (say) considering Grader as driving resource.

Total Duration in hours:

EW = 100000/100 = 1000 Hours....assuming 8 hours standard shift (default shift taken by MS Project / Primavera) no. of working days = 1000/8 = 125 say 125 days....BUT I know the work will be spread over 6 months which mean the duration of the activity will be 180 days becoz of its links with predeccessor and successor activities ..How to establish that???  I mean how to make it logical one way...

Replies

Satish Kumar
User offline. Last seen 7 years 6 weeks ago. Offline
Joined: 8 Feb 2010
Posts: 56

Hi Vishnu,

The no of working days is 125. If you incorporate the holidays, grader maintenance days and 'weather effect' in calendar, I think you can achieve 180 days.

Earthwork is the critical, i mean more time consuming activity in roads than its predeccesors (Clearing & Grubbing), therefore once Earthworks start it should continuosly progress till completion, without any other time gaps between sections of the project, except if there are land acquisition problems or land handing over constraints in the contract.

Generating gaps inbetween would seem meaningless.

Hope this helps to a certain extent,

Regards,

K.

 

 

Rafael Davila
User offline. Last seen 14 hours 16 min ago. Offline
Joined: 1 Mar 2004
Posts: 5228

maqeel

You can download from Spider site their demo, is free and for unlimited time, but only works for 40 activities. They also have a free reader that can read any size schedule but cannot edit it. Both you can distribute to anyone for free. If you have a high speed Internet downloading shall take 2 minutes, for full version 2 minutes also, for installation less than 2 minutes, updates takes one click of the mouse new single user installation perhaps 2 clicks of the mouse. This is serious stuff, takes some time to master as if learning to fly a fighter jet.

http://www.spiderproject.ru/enter.php?ver=prof&lang=eng

Although you can distribute for free the reader, I believe only registered users can download from the site the latest version, then thereafter anyone can distribute that copy.

For P6 I am still looking for a full working demo and a viewer, if you know about them please let me know.

For a comparison table of features you can download a comparison table from the following link.

http://www.spiderproject.ru/library/eng/compare_e.xls

But it only tells you half the story, it is not just about numbering functionalities but also about how good each is.

Each vendor and most users will tell you their particular software is the best, is what they know, this time I will limit my comments to ask you first try for yourself both and compare and second I will say that schedulers that are resource loading their schedules activity by activity with multiple resources on each activity, with multiple crews working on the same activity they are nuts, and this is just a scratch on the surface. In Spider Project you can copy your crews by using multi resources, you can copy an activity with all resources but by changing volume of work duration will be adjusted according to resource productivity you copied or you adjusted after the copy and paste, dig it yourself and you will be amazed.

I have no economical interest with Spider Project team, I am just another scheduler interested on the advancement of our tools for our own benefit.

Count on me to help you start working with Spider, it will also be a learning experience for me.

Regards,

Rafael

Muhammad Aqeel
User offline. Last seen 13 years 6 weeks ago. Offline
Joined: 18 Apr 2009
Posts: 30
Groups: None

Dear Mr. Rafael,

Can you tell me what is the  Difference between if Spider project and P6? and may i know that spider have trail version or know? becoze i like to check how it is working?

 

thanks for your quick answer pls

 

maqeel

Rafael Davila
User offline. Last seen 14 hours 16 min ago. Offline
Joined: 1 Mar 2004
Posts: 5228

Vishnu,

The duration of your activity is driven by other activities, it is not a resource-based duration, it is a Hammock activity, then as it expands it means the resource assignment percent will be reduced, just let the software know by how much.

In Spider Project this can be done by using "Calculate Work Loads". This calculation is used for activities of Duration and Hammock types. It calculates resource assignments work load so that, with productivities given, activity volume will be completely performed during given activity duration. If this is not achievable (resulting work load exceeds 100 %), the corresponding error message will appear. If workload can be calculated, its amount will be entered in the corresponding activity assignment field.

In Spider Project, you can also solve the issue with a simple formula that will adjust workload as the duration of your hammock activity changes. The following illustration shows how resource assignment is changed by the formula and how you get the same total of resource hours per hammock activity. This will allow for idle resources be used by other activities if resource leveling calls them.

Work Loads

If using other software please do not come with the crazy idea of using fractions of your resources as a substitute to partial assigments, would result in wrong modeling. Perhaps the formula method can be of help if using other software.

Best regards,

Rafael

Hatem Smadi
User offline. Last seen 13 years 23 weeks ago. Offline
Joined: 19 Oct 2010
Posts: 3
Groups: None

dear all ,

 

in special cases , like roads you have to prepare a programme  by stations ,

and you have to respect two things :

1. the mass haul diagram

2. available working hours .

Vishnu Kant Mishra
User offline. Last seen 13 years 4 weeks ago. Offline
Joined: 14 Feb 2009
Posts: 34
Groups: None

Hi Mike ..

1. I our case We have sub-Contracted the work of dumping the material to SITE so i need not plan the haulage..and it is not driving i assume the material dumped at site...

2. Detailed program shall be made once the complete drawings are ready I am at a stage wehere we have a tendering BoQ and moreover we have to cubmit the contractual program...with few section ,...

Mike Testro
User offline. Last seen 1 week 3 days ago. Offline
Joined: 14 Dec 2005
Posts: 4418

Hi Vishnu

For a start your driving resource on any mass excavation is the haulage disposal - not the excavation.

If your activity is split by intervening tasks that create gaps in production then there is no point in trying to resource model the whole thing.

Split your task into the relative sections and model each section using the applicable volume and output - thus giving a duration for each section.

Now put the sections under a summary bar and add a shadow resource to the summary - non modelled of course - and you will get an indication of the expected down time.

Check this against the estimate to see how much money will be lost - or may be recovered.

Best regards

Mike Testro