Import Resources & Quantity

A
Alaa Al haj 👤 Member for 18 years 7 months
A
Arnold Puy 👤 Member for 19 years 1 month

Hi Alaa,



Assign first the resources into your activities in Primavera window. When done, export the activities with Resource ID to Excel.



In Excel sheet you can assign the quantity by using the vlookup function with a Lookup_value equal to your Activity ID.



If ever, you cannot follow my steps, email me at [email protected]



Regards,



Arnold

A
Alaa Al haj 👤 Member for 18 years 7 months



Thanks Arnold,



I try this solution but the problem is I have 3000 activities and I can’t assign resources to all activities in primavera (it will take me very long time) so I just want to ask if it is possible to export activities and resources as table (matrix)



Like

AD RESOURCE 01

RESOURCE 02 RESOURCE 03 RESOURCE 04 RESOURCE 05

A1000 20 25 17

A1001 7 33 40

A1002 60 20 5

A1003 30 30 60



THIS IS ASAMPLE OF WHAT I WANT THE PRIMAVERA to DO (OF COURSE AFTER CREATING RESOURCES IDs





Thanks

Alaa

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts