Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2016, 03:38 AM
Guloluseus Guloluseus is offline Multiple resource assignment Windows 7 64bit Multiple resource assignment Office 2010 32bit
Competent Performer
Multiple resource assignment
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default Multiple resource assignment

I have been assigned the wonderful task of compiling a full resource listing for all of our works that can be added to our standard Project layout.

We have a number of resources available that need inserting as a group- for example surfacing requires a paver, roller, supervisor and 7 general operatives. Excavation requires excavator, dumper, supervisor, machine operator, general operative, or may be amended to large excavator for other works.

If I have resources that cover the above separately, (so resources would be general operative, machine operator, paver, excavator etc), can I set up resourcing so that a set of resources can be added? Grouping is already being used (this defines the subcontractor) but that could be amended if necessary.



thanks
Reply With Quote
  #2  
Old 03-12-2016, 11:38 AM
JulieS JulieS is offline Multiple resource assignment Windows 7 64bit Multiple resource assignment Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You can certainly create a resource names "paving resource" but if the supervisor in the paving crew is the same supervisor in the in the excavation crew - you won't be able to keep track of hem
Reply With Quote
  #3  
Old 03-13-2016, 06:14 PM
Guloluseus Guloluseus is offline Multiple resource assignment Windows 7 64bit Multiple resource assignment Office 2010 32bit
Competent Performer
Multiple resource assignment
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Gangs for separate activites would be separate, so a paving op wouldnt be used drainage. reading my first post again, I think I missed out the important bit.
I get progs from other planners, who are a bit shy on resourcing. the best I am likely to get is "drainage gang", "surfacing gang" or similar. I need to replace this with a more detailed breakdown as one of our major clients requires it this way.
I could go through the programme and filter by resource name, then paste in new resources, but it would be preferable if I could use a global setting that would do this for me.

Sorry if I ama bit disjointed, too late really for me, probably look at this tomorrow and wonder what i was trying to say
Reply With Quote
  #4  
Old 03-21-2016, 07:00 AM
JulieS JulieS is offline Multiple resource assignment Windows 7 64bit Multiple resource assignment Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm not sure what 'global' setting you are expecting. You can replace a resource with another using the Assign resources dialog.
Reply With Quote
  #5  
Old 03-21-2016, 05:33 PM
Guloluseus Guloluseus is offline Multiple resource assignment Windows 7 64bit Multiple resource assignment Office 2010 32bit
Competent Performer
Multiple resource assignment
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

Reading my last post, I should have gone for the sleep option first!
In the progs I receive, resourcing is put in as "drainage gang", "paving gang", etc.

A drainage gang (for example) consists of 1 drainage ganger, 1 drainage machine op, 1 drainage operative, 1 drainage dumper, and 1 drainage excavator. What I need to do is for every instance of "drainage gang", replace it with the 5 separate resources listed. Work done will remain the same, even though the number of resources id 5 times greater (in work hours).

The only way I can see to do this is set all activities to be time based, replace the initial resource with the detailed breakdown (filter and cut/paste) then set tasks back to work based. What I would prefer to do is be able to use either an inbuilt Project function (dont know of one yet) or if a macro or VB would do it.

The reason for this is to be able to view total resources by manpower/ plant in a visual report, as opposed to just gang numbers, as one of our main clients wants to see this. Our resourcing is bot as detailed, as its not needed at that depth.

thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple resource assignment resource assignment for multiple tasks Yaroslav Project 1 01-25-2015 11:49 AM
Multiple resource assignment Resource assignment with resource calendars joday48 Project 6 08-19-2014 05:49 AM
Resource Assignment Summary Line Not Adding Up Correctly PeteS Project 2 07-18-2014 06:24 AM
Multiple resource Dependencies / Mapping Sherry Project 3 04-03-2014 08:03 AM
Master Schedule and Multiple Resource Pools calebhuzzah Project 1 06-23-2013 10:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft