Another way is to organize the activities by resources.
Then, put a column for budgeted quantities. There, you can easily input the activities in the column provided and you can also use the Fill Cell feature if there are many similar quantities.
in addition to Shahul, 1st multi select the activities you want to add resources using ctrl+click or u can use ctrl+A to select all the activities then click Insert and Resource Assignment.
nes
Member for
18 years 7 months
Member for18 years7 months
Submitted by Louie Corbeta on Wed, 2010-03-31 01:13
We are on the same boat when dealing with the latest version of Excel which it doesn’t support any of the output files of P3. Hence, we cannot utilize the import/export facility of P3 which is surely the quickest and easiest way to load resources. This is the reason I am still using MS Excel 2003 (its crude though)until now because it works both with P3 as well as with P6.
My suggestion: stick with MS Excel 2003 when using P3 to save a lot of headache.
There is a way if the activities have same resources you could use insert option , select resource assignment ,choose resource you want to enter followed by units per day or budgeted quantity . which is very easy step
Member for
16 years 4 months
Member for16 years5 months
Submitted by Anbin Ponnith on Sun, 2010-03-28 05:48
Member for
19 years 1 monthRE: Resource Allocation
Another way is to organize the activities by resources.
Then, put a column for budgeted quantities. There, you can easily input the activities in the column provided and you can also use the Fill Cell feature if there are many similar quantities.
Good luck
Member for
16 years 11 monthsRE: Resource Allocation
you are correct Neastor
Member for
17 years 11 monthsRE: Resource Allocation
hi shareff,
in addition to Shahul, 1st multi select the activities you want to add resources using ctrl+click or u can use ctrl+A to select all the activities then click Insert and Resource Assignment.
nes
Member for
18 years 7 monthsRE: Resource Allocation
Hi Shareef,
We are on the same boat when dealing with the latest version of Excel which it doesn’t support any of the output files of P3. Hence, we cannot utilize the import/export facility of P3 which is surely the quickest and easiest way to load resources. This is the reason I am still using MS Excel 2003 (its crude though)until now because it works both with P3 as well as with P6.
My suggestion: stick with MS Excel 2003 when using P3 to save a lot of headache.
Regards,
Louie
Member for
16 years 11 monthsRE: Resource Allocation
Hi shareef
There is a way if the activities have same resources you could use insert option , select resource assignment ,choose resource you want to enter followed by units per day or budgeted quantity . which is very easy step
Member for
16 years 4 monthsRE: Resource Allocation
Hai Shareef
Option 1
U Can Use RA Application Activity.Xls(U Can Find it in P3 Installtion CD) Which Will Work in New & Old Version
Option 2
If u Save the Export File in .DBF it Will work in Excel 2003
Regards
Anbin