Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

See how fast it is to import resources and roles into Primavera from Excel ( It’s free )

No replies
Mohammed Ali
User offline. Last seen 1 year 45 weeks ago. Offline
Joined: 16 Mar 2018
Posts: 72
Groups: None

These two videos illustrate how fast it is to prepare resources, roles and all of their information in Excel and export them as XER file directly to Primavera.

  • This is the first video to prepare the resources from completed projects and current projects.

https://youtu.be/Xn0v_ET0rAo

  • The second video is to prepare the resources as diagram in Excel and export them as XER file.

https://youtu.be/No07p4gId8U

  • To learn about the RSC Magic Tool this is the link:

https://www.facebook.com/P6.MagicTools/posts/140428694497822

  • To download the RSC Magic Tool for all Excel versions 32 bit from 2007 to 2019 this is the link;

http://www.mediafire.com/file/amyxfol2iawi65x/RSC_Magic_Tool.xlsm/file

 

Note :To run the tool on Excel you need to enable macros and check the trust box from excel options.