Show correct %-Allocation in Resource Usage for a specific project when using Resource Pool

Thanks, I thought you were willing to share the macro if it is broken down by project it would be great, if not you can please share it, I am not a VBA expert, but I will see what I can do.

You are correct about NETWORKDAYS, it is a simplification, but INMO there is no other way to do it, because MS Project as we know now, doesn't calculate %-Allocation in certain scenarios, so we can not rely on this calculation. The only calculation we know is correct by projects is Work, so we can calculate a specific allocation, say %-Theoretical Allocation, since it doesn't consider the particular resource constraints such as vacation, local holidays, etc. That is what I meant. Export to Excel will do one portion of the work, exporting hours, then find a way to deduce from the hours %-Allocation. It is a pitty that MS Project doesn't provide %-Allocation in all cases. Thanks so much for your help.