D
Dan Graham
Objective:
I would like to enter the task (painter), Mode (median,max.etc), start date and duration, to generate a number of painters every month that I will need to cook for.
Parameters:
I have a average understanding of statistics, but I don't get to practically use it that often. Twenty years ago in uni, yes, now, not so much.
Slightly above average (probably not for this workgroup) understanding of Excel.
I don't really need to feed painters, I just like to use simple language.
I know that I will have a peak (mode) of 100 painters on my job site.
I know their start date (Jan)and their duration on the job (end date)
Example
Information I will have:
Task Mode Start Dur(or end date)
Painters 100 Jan 2014 10 months
and information I would like
J F M A M J J A S O
10 30 50 75 100 100 75 50 30 10
So any ideas?
Thanks in advance
DG
I would like to enter the task (painter), Mode (median,max.etc), start date and duration, to generate a number of painters every month that I will need to cook for.
Parameters:
I have a average understanding of statistics, but I don't get to practically use it that often. Twenty years ago in uni, yes, now, not so much.
Slightly above average (probably not for this workgroup) understanding of Excel.
I don't really need to feed painters, I just like to use simple language.
I know that I will have a peak (mode) of 100 painters on my job site.
I know their start date (Jan)and their duration on the job (end date)
Example
Information I will have:
Task Mode Start Dur(or end date)
Painters 100 Jan 2014 10 months
and information I would like
J F M A M J J A S O
10 30 50 75 100 100 75 50 30 10
So any ideas?
Thanks in advance
DG