This is exactly something that I have been looking for. Excellent project in Excel for managing resources in multiple projects. Thanks for putting this together.
i dont get in your project sheet under weeks for a particular who is under multiple projects his requirement for every project we have to change everytime ? , in your video you have assumed some percentage for once initially
Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome
You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.
@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?
In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.
This is exactly something that I have been looking for. Excellent project in Excel for managing resources in multiple projects. Thanks for putting this together.
Thanks for the feedback!
Proper Explanation with easy steps. Thanks.
Thanks for the comment, please check your inbox!
This is such a great video. Working at an SME, I needed a template that's highly adaptable and customisable based on business need. Thanks so much!
Thank you!
excellent work. I enjoy your idea to use excel efficiently. thanks for your hard work and sharing your expertise. please keep it up.
Thank you for the feedback!
Brillant work
Thanks for the feedback!
Hi! I am struggling with my Xlookup formula. I do have it available but the result keep on saying #VALUE after i input formula.
Hello! It's hard for me to assess without seeing your formula. If you Google #value for Xlookup it might give you tips on why it fails...
i dont get in your project sheet under weeks for a particular who is under multiple projects his requirement for every project we have to change everytime ? , in your video you have assumed some percentage for once initially
I don't think I understand your question but you can allocate a different availability over time for a specific resource.
Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome
You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.
@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?
In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.