I have to remove the resourse assignment & reassign the same resourse again which is very boring and time consuming task.
I am not sure the above is an absolute requirement, perhaps you just have to make available the column for units/time in the resource assigment tab of your activity(es), then you shall be able to modify it directly (not sure but nothing is lost if you try) not a big step but a step in the right direction if it works.
I would not give up on the idea that what you are doing manually can be done with a global change as it is a simple request, just time consuming for hundreds of assigments, and vey boring indeed.
Beste regards,
Rafael
Member for
20 years 1 month
Member for20 years1 month
Submitted by Shareef Abdul Azeez on Thu, 2012-01-19 16:19
Run a Global change to change the Duration Type of the activities containing the resource to "Fixed Units".
Then
Run another Global Change to Change the Budgeted Units/time to the new production rate. This will change your durations as required.
Units = Units/ time * Durations
You have to fix one of the variables to get a result.
**--"Drive Activity Date" option for the resource to be ticked(checked ON)
PS: The procedure become complex for activties with actuals statused and would not yield required results as changing form one duration type to another overwrites the actuals and can not handle the scenarios suggested by Vladimir and Raphael
Regards
Shareef
Member for
20 years 1 month
Member for20 years1 month
Submitted by Shareef Abdul Azeez on Thu, 2012-01-19 16:02
I had the suspicion P6 cannot mimic in any way, not even with SDK,some of the most basic functionality of Spider Reference Books. But your requirement is so elemental that you should be able to mimic what you already are doing in P6 with simple filters and global changes.
I tried Vladimir suggestion and it came out that if filter and formulas are easy the use of Reference Books for such simple requirement is even easier. I can generate as many scenarios and save them under separate reference book versions or I can use a single reference book and modify it using filters within the reference books but also can transfer the data to selected multiple jobs. Some bad habits learned from other software where options are limited are difficult to change.
Best regards,
Rafael
Member for
24 years 9 months
Member for24 years9 months
Submitted by Vladimir Liberzon on Thu, 2012-01-19 11:35
what you want to achieve can be easlily done in Spider Project. If you will change resource assignment productivity for certain type of work in one place (reference-book) everywhere where this resource is assigned to activities of this type its productivity will change and new activity durations will be calculated.
Potential workaround - to create the schedule based on amounts of work to be done and assigned resource productivities in Spider Project and expost the resulting schedule to P6 if this is client requirement.
P6 has no necessary functionality.
Best Regards,
Vladimir
Member for
16 years 3 months
Member for16 years4 months
Submitted by Nilkamal Parikh on Thu, 2012-01-19 06:10
Thanks for your reply. The idea you gave is fine but it will not work exactly because when you delete the assignments from related activities, the durations will stay there and when you re-assign the resource with changed production rate, the duration needs to be corrected manually for all items one by one.
Thanks
Nilkamal
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Thu, 2012-01-19 01:52
I use Spider Project and not P6 but used it before for a limited time.
Now I believe I understand your question. From what you say I am understanding P6 applies the current default value to newly created activities and that same as in Spider you can change the value individually or in groups. That you are looking for a way to apply the change to the selected group.
In Spider I would use UDF [user defined field] to identify and filter the assignments in question and then with a formula I would change the value to the selected activities assignments. This I can perform while in the assignments Gantt instead of using the activity Gantt. Note in your software different name apply to the views and tables and maybe there are differences on the close equivalent you call "Global Change".
Once you have identified the activities you can re-apply the formula [or global change] to change the value as many times as you want with a single click of the mouse.
Maybe you can mimic my suggestion within P6 but it is up to you and how P6 works, perhaps others can help with the idea to see if it works in P6.
Wish you good luck.
Rafael
Member for
20 years 1 month
Member for20 years1 month
Submitted by Shareef Abdul Azeez on Wed, 2012-01-18 08:28
The easiest way would be to use SDK. The other way I could think of is... delete the said resource from the resource list which will inturn delete all its assignments on the 50 activities which you have mentioned. Then create the same resource again with the new production rate and select all the 50 activities and assign the resource to all the 50 activities with one click.
Regards
Shareef
Member for
15 years 11 months
Member for15 years11 months
Submitted by Raymund de Laza on Wed, 2012-01-18 08:20
The Max Units/Time from the resource library is the same as the limit of resources per time for the entire project and not for individual activity. Say if you assign the same resource to multiple activities with different budget units, the total units per time for that resource will be compared to that max units/time, which means that you may know that the resource is over allocated or below limit. The limit may be usefull too when performing levelling of resources.
Use the Global Change to change the units/time of the activities affected.
Hope this will help.
Member for
16 years 3 months
Member for16 years4 months
Submitted by Nilkamal Parikh on Wed, 2012-01-18 04:31
Thanks for your reply. What you have mentioned is not 100% I need. Let me put it in much simpler way. I have assigned a resourse which works 35 units/day to 50 items. So for each item, the resource usage is 35units x durations.
Now if I want to change that 35 units/day to 27 units/day and this should reflect to eash items as well. i.e the resource usage for each items must be 27 units x durations.
My problem is if I go to the resource library and edit Default units/Time from 35 to 27, it do not change to the items. I have to go to each item and remove the assigned resource and add again the same one to give effect of the change. I do not want to do it for all 50 items. I am sure there must be some way to do it with single click.
Please mention if any settings I need to change.
Thanks
Nilkamal
Member for
21 years 8 months
Member for21 years8 months
Submitted by Rafael Davila on Wed, 2012-01-18 03:59
To be able to define different production rates (productivity) to a single resource and being able to drive activity duration with production resources of different resources each with its own production rate so that if you change the resource productivity the activity duration is adjusted accordingly?
after adjusting productivity on Activity 2 resources as shown we get
Note that resource A can produce different things say CMU installation and SY of cement plaster at different production rates. The following link will show you the video for you to see the change as it happens.
The idea is not to merely change productivity manually but also to be able to use skills so that depending on the availability and priorities the software assign the available resource and adjust the activity duration depending on the available resource(s) individual production rates.
Material resources represent consumable resources so if you have 50cm of gravel it will be consumed until depletion while installation of 50cm of gravel is done by regular resources [labor/equipment] and the 50cm in this case represent volume of work.
Best regards,
Rafael
Member for
16 years 3 months
Member for16 years4 months
Submitted by Nilkamal Parikh on Wed, 2012-01-18 03:08
Thanks for your reply. But I am still not much clear with what you mentioned. If you do not have budgeted quantity for your programmed activity then how do you derive the durations for the activities? I allocate the budgeted quantity for my items and then assign the estimated team which will perform the task at certain rate. So I can get the durations and assign all the resources for that much time.
Am I doing something wrong here?
Please comment.
Thanks
Nilkamal
Member for
16 years 3 months
Member for16 years4 months
Submitted by Nilkamal Parikh on Wed, 2012-01-18 03:08
Thanks for your reply. But I am still not much clear with what you mentioned. If you do not have budgeted quantity for your programmed activity then how do you derive the durations for the activities? I allocate the budgeted quantity for my items and then assign the estimated team which will perform the task at certain rate. So I can get the durations and assign all the resources for that much time.
Am I doing something wrong here?
Please comment.
Thanks
Nilkamal
Member for
24 years 9 months
Member for24 years9 months
Submitted by Vladimir Liberzon on Wed, 2012-01-18 02:11
Activity duration does not depend on material requirements per work hour. If activity will be longer of shorter the volume of work will become larger or smaller than 50,000m3 and that"s all.
Best Regards,
Vladimir
Member for
16 years 3 months
Member for16 years4 months
Submitted by Nilkamal Parikh on Tue, 2012-01-17 23:21
Thanks for your reply. Rather then usign the word productivity I should use budgeted units/day. So at the moment I am creating such thing using a material resourse which represent particular team with specific operation. Let me write a little example to explain bit mor clearly:
As I am working for the tenders for the job which has large earthworks, road works, drainages, etc. No say for example the earthwork will be happening with different machines like Scrapers or Trucks. So I use the term Scraper Fleet which is made up of all the plants & operators. But there will be one additional resourse which is a material type with predefined estimated units/day i.e say Scraper Crew - 5,000m3/d. Which can be achieve using 3-Scrapers, 2-Dozers, (3+2) Operators & 2-Labours.
Now when I assign this material resource of Scraper Crew to some particular activity which has budgeted quantity of 50,000m3, in this case with this scraper crew I need to work for 10 days (50,000m3/5,000m3=10 day). And all the related resources will be occupied for those 10 days.
I use this method to load the budgeted work and resource assignment too. So From resource assignment I gan get all the loading of quantity and usage of my plants over time.
Is this something wrong what I am doing here? Can you please comment?
Nilkamal
Member for
19 years 10 months
Member for19 years11 months
Submitted by Tanveer Ahmad Niazi on Tue, 2012-01-17 12:41
I am also new in planning and working on P6v7. Would you please tell me where did you enter/set the production rate, coz I didn’t find any column or tab for this,
Thanx & Cheers
Tanveer
Member for
19 years 10 months
Member for19 years11 months
Submitted by Tanveer Ahmad Niazi on Tue, 2012-01-17 12:39
My friend my concept is very much clear, I didn't about PRODUCTIVITY I asked Nilkamal where and how did he enter/set the "PRODUCTION RATE". Coz I didn't find any column, field or tab for this.
Better make your concepts clear because I have not found anything like productivity in Primavera P6 yet.You first enter resource,assin its cost/Unit,assign calenders if any,assign max units per time,assign effective dates and shift calenders if any..... and after that you assign that resource to your activity.There you put the required resources in Remaining unit/Time column.This was a summary and there are reference mannuals easily available if you goole it. Check this one
In Spider Project you can define activity physical volume (amount) of work and assigned renewable (people, machines) resource productivities. Activity duration and the speed of work and material consumption will depend on total productivity of assigned renewable resources. There is not such thing as material resource profuction rate, it depends on assigned people and/or machines production rate.
I don't know about productivities in P6. There is no such field at all.
Member for
16 years 3 monthsThank you very much to all
Thank you very much to all for the valuable guide for me as this is my very first post.
Much appreciated.
Thanks to Planning Planet too.......!!!
Nilkamal
Member for
21 years 8 monthsGreat !!!
Great !!!
Member for
16 years 3 monthsThanks Rafael, I can do it
Thanks Rafael,
I can do it now with your idea. Just go to resource assignment and bring the units/time column and change them all with fill down command.
Thanks a ton.
Nilkamal
Member for
21 years 8 monthsI have to remove the
I have to remove the resourse assignment & reassign the same resourse again which is very boring and time consuming task.
I am not sure the above is an absolute requirement, perhaps you just have to make available the column for units/time in the resource assigment tab of your activity(es), then you shall be able to modify it directly (not sure but nothing is lost if you try) not a big step but a step in the right direction if it works.
I would not give up on the idea that what you are doing manually can be done with a global change as it is a simple request, just time consuming for hundreds of assigments, and vey boring indeed.
Beste regards,
Rafael
Member for
20 years 1 monthHi NilKamalRun a Global
Hi NilKamal
Run a Global change to change the Duration Type of the activities containing the resource to "Fixed Units".
Then
Run another Global Change to Change the Budgeted Units/time to the new production rate. This will change your durations as required.
Units = Units/ time * Durations
You have to fix one of the variables to get a result.
**--"Drive Activity Date" option for the resource to be ticked(checked ON)
PS: The procedure become complex for activties with actuals statused and would not yield required results as changing form one duration type to another overwrites the actuals and can not handle the scenarios suggested by Vladimir and Raphael
Regards
Shareef
Member for
20 years 1 monthX
X
Member for
21 years 8 monthsNikamal,In the following link
Nikamal,
In the following link you will find a video of how in Spider Project I would do it using filers and formulas.
http://www.youtube.com/watch?v=yRFsNaDljtk
I had the suspicion P6 cannot mimic in any way, not even with SDK,some of the most basic functionality of Spider Reference Books. But your requirement is so elemental that you should be able to mimic what you already are doing in P6 with simple filters and global changes.
I tried Vladimir suggestion and it came out that if filter and formulas are easy the use of Reference Books for such simple requirement is even easier. I can generate as many scenarios and save them under separate reference book versions or I can use a single reference book and modify it using filters within the reference books but also can transfer the data to selected multiple jobs. Some bad habits learned from other software where options are limited are difficult to change.
Best regards,
Rafael
Member for
24 years 9 monthsHi Nikamal,what you want to
Hi Nikamal,
what you want to achieve can be easlily done in Spider Project. If you will change resource assignment productivity for certain type of work in one place (reference-book) everywhere where this resource is assigned to activities of this type its productivity will change and new activity durations will be calculated.
Potential workaround - to create the schedule based on amounts of work to be done and assigned resource productivities in Spider Project and expost the resulting schedule to P6 if this is client requirement.
P6 has no necessary functionality.
Best Regards,
Vladimir
Member for
16 years 3 monthsHi Shareef, Thanks for your
Hi Shareef,
Thanks for your reply. The idea you gave is fine but it will not work exactly because when you delete the assignments from related activities, the durations will stay there and when you re-assign the resource with changed production rate, the duration needs to be corrected manually for all items one by one.
Thanks
Nilkamal
Member for
21 years 8 monthsNikamal,I use Spider Project
Nikamal,
I use Spider Project and not P6 but used it before for a limited time.
Now I believe I understand your question. From what you say I am understanding P6 applies the current default value to newly created activities and that same as in Spider you can change the value individually or in groups. That you are looking for a way to apply the change to the selected group.
In Spider I would use UDF [user defined field] to identify and filter the assignments in question and then with a formula I would change the value to the selected activities assignments. This I can perform while in the assignments Gantt instead of using the activity Gantt. Note in your software different name apply to the views and tables and maybe there are differences on the close equivalent you call "Global Change".
Once you have identified the activities you can re-apply the formula [or global change] to change the value as many times as you want with a single click of the mouse.
Maybe you can mimic my suggestion within P6 but it is up to you and how P6 works, perhaps others can help with the idea to see if it works in P6.
Wish you good luck.
Rafael
Member for
20 years 1 monthHi NilkamalThe easiest way
Hi Nilkamal
The easiest way would be to use SDK. The other way I could think of is... delete the said resource from the resource list which will inturn delete all its assignments on the 50 activities which you have mentioned. Then create the same resource again with the new production rate and select all the 50 activities and assign the resource to all the 50 activities with one click.
Regards
Shareef
Member for
15 years 11 monthsNikamal, The Max Units/Time
Nikamal,
The Max Units/Time from the resource library is the same as the limit of resources per time for the entire project and not for individual activity. Say if you assign the same resource to multiple activities with different budget units, the total units per time for that resource will be compared to that max units/time, which means that you may know that the resource is over allocated or below limit. The limit may be usefull too when performing levelling of resources.
Use the Global Change to change the units/time of the activities affected.
Hope this will help.
Member for
16 years 3 monthsHi Rafael, Thanks for your
Hi Rafael,
Thanks for your reply. What you have mentioned is not 100% I need. Let me put it in much simpler way. I have assigned a resourse which works 35 units/day to 50 items. So for each item, the resource usage is 35units x durations.
Now if I want to change that 35 units/day to 27 units/day and this should reflect to eash items as well. i.e the resource usage for each items must be 27 units x durations.
My problem is if I go to the resource library and edit Default units/Time from 35 to 27, it do not change to the items. I have to go to each item and remove the assigned resource and add again the same one to give effect of the change. I do not want to do it for all 50 items. I am sure there must be some way to do it with single click.
Please mention if any settings I need to change.
Thanks
Nilkamal
Member for
21 years 8 monthsNilkamal,Is this what you are
Nilkamal,
Is this what you are looking?
To be able to define different production rates (productivity) to a single resource and being able to drive activity duration with production resources of different resources each with its own production rate so that if you change the resource productivity the activity duration is adjusted accordingly?
after adjusting productivity on Activity 2 resources as shown we get
Note that resource A can produce different things say CMU installation and SY of cement plaster at different production rates. The following link will show you the video for you to see the change as it happens.
http://youtu.be/YU5E-ijy_kY
The idea is not to merely change productivity manually but also to be able to use skills so that depending on the availability and priorities the software assign the available resource and adjust the activity duration depending on the available resource(s) individual production rates.
Material resources represent consumable resources so if you have 50cm of gravel it will be consumed until depletion while installation of 50cm of gravel is done by regular resources [labor/equipment] and the 50cm in this case represent volume of work.
Best regards,
Rafael
Member for
16 years 3 monthsHi Vladimir, Thanks for your
Hi Vladimir,
Thanks for your reply. But I am still not much clear with what you mentioned. If you do not have budgeted quantity for your programmed activity then how do you derive the durations for the activities? I allocate the budgeted quantity for my items and then assign the estimated team which will perform the task at certain rate. So I can get the durations and assign all the resources for that much time.
Am I doing something wrong here?
Please comment.
Thanks
Nilkamal
Member for
16 years 3 monthsHi Vladimir, Thanks for your
Hi Vladimir,
Thanks for your reply. But I am still not much clear with what you mentioned. If you do not have budgeted quantity for your programmed activity then how do you derive the durations for the activities? I allocate the budgeted quantity for my items and then assign the estimated team which will perform the task at certain rate. So I can get the durations and assign all the resources for that much time.
Am I doing something wrong here?
Please comment.
Thanks
Nilkamal
Member for
24 years 9 monthsHi Nikamal,what is the
Hi Nikamal,
what is the purpose of this assignment?
Activity duration does not depend on material requirements per work hour. If activity will be longer of shorter the volume of work will become larger or smaller than 50,000m3 and that"s all.
Best Regards,
Vladimir
Member for
16 years 3 monthsHi SM PUM, Thanks for your
Hi SM PUM,
Thanks for your reply. Rather then usign the word productivity I should use budgeted units/day. So at the moment I am creating such thing using a material resourse which represent particular team with specific operation. Let me write a little example to explain bit mor clearly:
As I am working for the tenders for the job which has large earthworks, road works, drainages, etc. No say for example the earthwork will be happening with different machines like Scrapers or Trucks. So I use the term Scraper Fleet which is made up of all the plants & operators. But there will be one additional resourse which is a material type with predefined estimated units/day i.e say Scraper Crew - 5,000m3/d. Which can be achieve using 3-Scrapers, 2-Dozers, (3+2) Operators & 2-Labours.
Now when I assign this material resource of Scraper Crew to some particular activity which has budgeted quantity of 50,000m3, in this case with this scraper crew I need to work for 10 days (50,000m3/5,000m3=10 day). And all the related resources will be occupied for those 10 days.
I use this method to load the budgeted work and resource assignment too. So From resource assignment I gan get all the loading of quantity and usage of my plants over time.
Is this something wrong what I am doing here? Can you please comment?
Nilkamal
Member for
19 years 10 monthsHi, Nilkamal, I am also new
Hi, Nilkamal,
I am also new in planning and working on P6v7. Would you please tell me where did you enter/set the production rate, coz I didn’t find any column or tab for this,
Thanx & Cheers
Tanveer
Member for
19 years 10 monthsMy friend my concept is very
My friend my concept is very much clear, I didn't about PRODUCTIVITY I asked Nilkamal where and how did he enter/set the "PRODUCTION RATE". Coz I didn't find any column, field or tab for this.
Thanx & Cheers
Tanveer
Member for
13 years 11 monthsNilkamal ParikhBetter make
Nilkamal Parikh
Better make your concepts clear because I have not found anything like productivity in Primavera P6 yet.You first enter resource,assin its cost/Unit,assign calenders if any,assign max units per time,assign effective dates and shift calenders if any..... and after that you assign that resource to your activity.There you put the required resources in Remaining unit/Time column.This was a summary and there are reference mannuals easily available if you goole it. Check this one
http://www.ce.metu.edu.tr/~ce736/P6ReferenceManual.pdf
Regards
Member for
24 years 9 monthsIn Spider Project you can
In Spider Project you can define activity physical volume (amount) of work and assigned renewable (people, machines) resource productivities. Activity duration and the speed of work and material consumption will depend on total productivity of assigned renewable resources. There is not such thing as material resource profuction rate, it depends on assigned people and/or machines production rate.
I don't know about productivities in P6. There is no such field at all.