Forum Discussion
Exporting resources to excel to create histogram
Chris_Mercer,
Wow, three duplicate postings, and three separate replies. My colleagues suggest a "simple" copy and paste of the Project Resource Usage data into an Excel Workbook and that will work fine, it just takes a few steps. I'm more about automation, particularly if you need to do the export on a regular basis.
You say "Budget Work Units" but I don't think that is really what you mean. The Budget Work field is only applicable to the Project Summary Task and the file you posted to OneDrive has no Budget Work.
As I mentioned, I have a few macros that export Project timescaled data to Excel. One in particular is very close to what you need. As currently configured, it produces three Work fields for each resource, but that is easy to reconfigure. Here is sample outut of the macro run on your file. If you are interested in an automated approach, let me know.
John
Chris_Mercer,
To answer your basic question, "is it possible?" Yes, the best way I have found to get data from Project to Excel is via VBA. Sometimes the methods you tried will work and I laud you for giving them a go.
I have a few different macros that export Project resource data to Excel. Specifically which fields would you like to export? And, are you looking for data on a daily, weekly, or monthly basis?
Would you be willing to send me your Project file? I find it easier to help someone when I have the actual file.
John
Hi John - Thanks for replying
VBA's are a bit beyond me at the moment (I need to learn but am struggling to find the time!)
I'm just looking to export Task Name/Duration/Start/Finish/Resource Name/Budget Work Units (with the work units data phased over time) so I can build a resource histogram in Excel showing the numbers of various site resources per week.
The .mpp file is here -https://1drv.ms/u/c/5b76311aac56837f/Eavsh25a-iVJpbFeszHsANMBgMHcWMXd9KN-VEbUrFUdKA?e=aPPUVu
Any issues, let me know
Thanks in advance!