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...
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...