Team Assignment via Reference-Books

Member for

21 years 7 months

My approach is to use multi-resources, I use reference books to transfer the multi-resources and make it available, then I assign the multiresources. Because in my job usually a team consists of a single mult-resource all I need to do is assign the-multiresource as if a single resource.

Multiresources-01



Multiresources-02



Multiresources-03

There's more than one way to skin a cat.

Best Regards

Rafael

 

Member for

21 years 7 months

Better if you figured it out yourself, that was fast!

Member for

13 years 2 months

Rafale,

this was not my question. I have 7 building, each building having it's own list of subcontractors. In total there are over 60 subcontractors. Resources are Subcontractor 1, No of people, productivity. Some activities have several subcontractors, each subcontractor having the works done at a certain floor. The BoQ has about 200 activities, without MEP...so 7 buildings x 200 activities = 1400 activities. Not many, but not a few. Creating resource assignment referece-book is easy.  But since plastering may have 5 subcontractors and there are many activities which have between 2 and 7 subcontractors I needed a quick way to assign multiple teams to an activity; each team having it's own subcontractor.

I have the answer to the question:

01. Teams reference-books. Minimum fields are: Activity Code, Team Code, Index. When activity is created it has Team 1, Code 1, Index 1. So you must create Team 2, Index 2, Team 3, Index 3; Team 2, Team 3 have the same activity code.

02. Transfer Teams reference-books.

03. Resource Assignments reference-books. Minimum fields are: Activity Code, Resource Code, Resource Quantity, Resource Workload, Index. Productivity you can assign if you intend to use it.

04. Transfer resource assigments reference-books.

It took me about 1 hour to create and transfer about 4200 resource assigments.

Reference-Books are of much value!!!

Best regards,

Bogdan 

Member for

21 years 7 months

Creating resource reference books shall be no issue. The issue can be what is the necessary transfer sequence. Say you want to transfer the resources but you do not have the calendars, then creating a calendars reference book and the calendar data transfer shall be done before transferring the resources. I suggest avoiding automatic resource codes in your schedules and use company calendar standards.

I do very basic reference books but cannot live without them.

Best Regards,

Rafael