• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Resource load template

P

poten

New Member
Hello I have downloaded resource load sheet, but would like to have changed the numbers to hours instead of number of tasks, as it gives a better overview of the workload. However, I can not get it to succeed and are therefore looking for a some help ..


some have proposed, I would appreciate it ..


Note: maximum working hours per week is 37 hours
 
Hi Dan,


Ofcause I wiil share it, but I need help to make it :) It will give a better overview of the work load with man hours instead of tasks..


But i can find out how to do it, and can´t see in the formula how og why it´s like it is..


Help will be greatly appriciated


Best ragards
 
It´s the resource and timesheet templates Chandoo has maded Í would like to have modified.. It´s so productive, if someone manage to make my requested changes..
 
Actually I was hoping to get some respond, because i thought I should use the template tommorow..


Still hope someone come up with a solution.. I´ll be greatfull
 
Looking at step 4 under "Create a Resource Loading Chart", Chandoo decribes what the formulas are. I'm assuming you went here:

http://chandoo.org/wp/2009/08/05/excel-time-sheets-project-management/


Trying to guess where you're going with the template, you have a section somewhere with names and weeks, and # of hours spent on a task? Your SUMPRODUCT formula then will take the form of:

=SUMPRODUCT(--(ListOfNames=Name_I_Want),--(ListOfWeeks=Week_I_Want),(Hours_Spent))
 
Hello Luke M


Many thanks for your good answers.


Yes I have been on the page you refer to. is also much wiser, but without arriving at a solution.


It is true that I have added a column of Spent man-hours, and I want those hours into the heat fields in the 'Resource Loading Chart "on the right week and the right people. I want it to count hours worked instead of duties. This is because the load from the task's duration can vary, and if I have 4 tasks of eg 10 minutes, so it lights the red, as I am overloaded. This can be misleading.


I've tried your formula, but it fails. Can you possibly. organized the current clean template and send me?


Best regards
 
I'm afraid I don't actually have access to the file. =(

Can you elaborate on how the "formula fails"? Wrong value, gives error, etc.


It should looks something like:

=SUMPRODUCT(--(Data!$A$2:$A$10=$A2),--(Data!$B$2:$B$10=B$2),Data!$C$2:$C$10)

Where each range is the list of names, weeks, and hours, respectively.
 
Hello Luke M


After the hard struggle I manage to solve the problem with the formula you sent ..


I am so happy and super happy with your answers and understanding of the problem ..


Many thanks for your help ...


Dan_I how shall I send you the sheet?
 
You must log in or register to reply here.
Back
Top