Resource planning within large project

Question

I am in the middle of a project that consists of 2 different teams, one team does migration of websites while the other team does development of features.

My challenge is to maintain an overview of which ressources are allocated to which features at any time given.

Some of the features require 1 developer while others require 2-3 developers at the same time.

I am trying to get a spread sheet together where I can see what developer is allocated to what feature in order to plan when the next feature should be planned for development.

Any good templates out there, MS excel or Google Spreadsheet.

Answer 1

I wouldn't recommend using excel for managing tasks as it's not easily maintained, customized and developers don't find it user friendly most of the time (if they are going to use it to track their tasks).

I recommend using a tool to plan the whole thing (project road map, milestones and resource allocation).There are many tools that offer plan/see team workload feature like wrike,JIRA and droptask for an example.

You'd want to start with something as simple as wrike,then take it from there.