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,
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
Hi John, thanks for the reply
Not sure what is going on with all the posts! everything seems to go through for moderation and then sends an invalid error, so inevitably I try again and at some point it then posts everything!!
I managed to copy and paste the Resource Usage data into excel as you suggest above, just need to clean it up on Monday morning & graph it now.
I'm definitely interested in the macros - anything to make it easier in the future!
Cheers
Chris_Mercer,
This forum has some quirks. The owners of the forum went through some "tweaks" some months back and in my view (as per usual), it wasn't broken but they fixed it anyway. For example, a posting or reply does show the date but it no longer shows the time and threads aren't displayed in chronological order, so it's harder to follow.
Anyway, if you are interested in a VBA solution I'd like to work with you one-on-one via email. You can contact me at the address below. I will ask some question.
John
jmacprojataticlouddotdotcom
(remove obvious redundanices)