Charting production over time

[Matthewp@sf.nsw.gov.au]

I have a sheet with the following fields

Job name, start date, duration(days), daily production


There are numerous jobs starting over time. some now() some into the future


I'd like to be able to produce a table that plots out each job over time and allocates a days production until the end date,

I can get a gant chart working but what im struggling with is to get the production summarised so i can see the total production from all the jobs at any point in time.


Ultimately the aim is to be able to plot the production over time (in days)

 

[Mike86]

Since each job is just on one line, does total production for that job equal duration*"Daily Production"?

 

[Matthewp@sf.nsw.gov.au]

Yes, that gives production for a single job but I'd like to see a summary of each days production against all jobs.


Job name. Start date. Duration. Daily production.

JobA. 01/10/2011. 20. 100

JobB. 15/10/2011. 20. 120

JobC. 17/10/2011. 15. 60


I'd like to be able to chart the total daily production over time. To ask questions like what is the total production on 16/10/2010

 

[NARAYANK991]

Hi Matty ,


Check out this worksheet :


https://skydrive.live.com/#!/view.aspx?cid=754467BA13646A3F&resid=754467BA13646A3F%21117


Narayan


P.S. Copy the entire address and paste it in your browser.