Skip to content

Resource Allocation

Shareef Abdul AzeezMember for 21 years
Created
6
1
0
Is there some way that resources could be allocated to activities fast.

The only way I know is to go to each activity one by one and enter the resources manually and then input the units per time period. This is pain staking on large projects.

Is there some other way???
I tried exporting but the export file types are lotus, Ascii etc. which I dont think the new versions of excel can deal with.

6 replies

Oldest first
  1. 0
    Anbin Ponnith ·
    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
  2. 0
    Shah. HB ·
    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
  3. 0
    Louie Corbeta ·
    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
  4. 0
    Nestor Quijano ·
    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
  5. 0
    Shah. HB ·
    you are correct Neastor
  6. 0
    Robin Reyes ·
    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

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?