ZBB Project Management Excel Question

[godowolff]

Greetings,

I am working on allocating engineers from our branch to assigned tasks (That way I can show the higher ups if we need to hire more people for the coming year). Lets say I have 3 engineers. Each one has 50 work weeks available. If I have X projects and each one takes Y amount of time, I know that I can do a simple =Sheet1!A1-Sheet2!A1 to show how many weeks left they have. What I am having trouble with is showing what project the engineers are tasked with when I am looking at the weeks left. I want to show which projects they are working on when I see the weeks left. (I am looking for a formula that’s quick and painless, rather than manual entry). Any Ideas? Let me know if this doesn't make sense. Also, if there is a software that would be useful please feel free to share. Thanks for taking a look at this post!

 

[RedBeard]

Gantt chart maybe?

 

[godowolff]

Any tips or software for it? I use Smartsheet for my Gantt charts but its doesn't have the feature I am looking for.

 

[RedBeard]

If the built-in Excel ones aren't up to scratch, I've used https://www.teamgantt.com/ in the past.

 

[katty81]

You can try Procore. They have this feature. Have a look here: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>https://www.procore.com/en-gb/project-management/punch-list

 

[Michael M]

Might also pay to have a browse here....
https://peltiertech.com/Excel/Charts/index.html