Distributing an amount of hours from a start date

Hi guys, I'm having some trouble working on a schedule for some of my team members. The idea behind this schedule is that I have a list of people, a list of projects and a start date (an end date as well, but I'm interested in that). What I need to do is create a calendar with the days on columns and the names on the rows. Then, if one person is allocated to a project, then the cells for the respective days should be filled with a maximum of 7 hours. I'll attach an example so you can figure out better what I'm talking about. I hope I can find a solution for this, a macro of some sort. The file already has a macro for hidding the days until today. Thanks!