Issues Trying To Export Resource Usage Info From Project To Excel

JBLT-77 

Is VBA required to extract Project data to Excel? No, but unless you are really good using Pivot tables and are willing to make some compromises, VBA gives the user much more functionality and freedom than an export using Project's Visual Reports.

I took a quick look at the file and right off the bat I noticed a couple of disturbing things. Foremost are the links on summary lines. That is bad practice and is going to cause you a ton of headaches. You should read this Wiki article:
https://social.technet.microsoft.com/wiki/contents/articles/29569.ms-project-linking-andor-assigning-resources-to-summary-tasks.aspx

The second thing I noticed is there are several resources that are overallocated and I don't remember from your previous posts if that is an issue you are trying to resolve. At least one resource (VEC developer) can be resolved by changing the leveling options from "day by day" to "month by month" but that may not be appropriate for your needs.

One other item I notice is that every task shows the Standard calendar as the Task Calendar. This is unnecessary since by default a "none" in the Task Calendar field means the task follows the Project calendar, which in your case is a modified Standard. And instead of directly editing the Standard calendar, best practice is to create a custom calendar, perhaps based on the Standard, when adding company/national holidays.

Okay, now that it may seem like I "crashed your party", what exactly would you like to see in Excel?

For reference, the screen shot below is the output (Excel) of your file using one of my existing macros. If you want to pursue this, it will be easier for us to work directly via e-mail. My contact info is below. Again, I will ask some questions.

John

jmacprojataticlouddotdotcom

(remove obvious redundancies)