I've been tasked with re-creating the attached spreadsheet image in SharePoint, and I'm kind of stuck on where to start. Basically, I need a way to add an employee to a list, attach multiple projects to that specific employee, the hours they're allotted every month for each individual project, as well as calculating their total monthly hours from all their projects. Additionally, a way to color-code the type of project an employee is working on - currently charged (green), future charged (yellow), and potential charged (red).
My programming background is beginner/amateur level, so if there is an easier, out-of-the-box solution, I'd love to hear it. I use Nintex Forms/Workflows regularly, so I'm looking into possibly integrating those as well. This is all on being done on SharePoint 2013.