Thread: Project Burden Rate

Hi, I have to do a list in excel regarding how much burden each project causes every employee of a company.

I have a list of employees and a list of how many hours each employee spends per month on each project. there's a total of 26 projects.

The problem is that the number of employees in the company will increase from time to time.

what is the best way to allocate how much burden each project causes each on employe that works on it, and how can I then calculate total burden per project.
thanks a lot

Give an actual example...we're not mind readers.