Nadya PopikPM Consultant| VMP GroupMorganville, Nj, United States
I need to keep track of 22 developers, using Google sheets. My manager also wants to have a visual display of each members load, how busy they are. I have access to Jira, Confluence. Any suggestions are welcome. Thank you. Saving Changes...
Are the developers tracking their time on tasks in Jira? Jira has dashboard widgets you can use to display their past workload (it's been a couple years, so I don't recall the specific widgets). If you want to forecast their future workload, they would have to include estimates for the tasks they will be performing. This gets to be burdensome and inaccurate. It can also be unnecessary, unless you work for an agency.
I'm guessing you're not using sprints. If you're not, you can ballpark the developer's availability by establishing the percentage of their time dedicated to each project they're on and how long each project is expected to last. If they're supporting production issues, just give "production issues" a percentage, as well. It's not a perfect approach, and if a project runs into issues, or there's a major production issue, it can change the demand on developer time, but if your forecast doesn't have to be exact it can work (and if it did have to be exact, it would most likely be wrong regardless of your approach and how much time you spent on it). Saving Changes...
Is there a reason why the developers aren't pulling work into their individual queues as their capacity frees up? With that approach, there is no need to check how busy they are.
Community Champion
