Attachment 275321
Hi. How about this? It allows you to enter days and output on the left then on the right set the total days of production and the output. The second curve coordinates will be automatically generated based on teh curve first curve coordinates and the days and total output required. Depending on the relationship between the first and second curves you might get a little bit of error because in some instances it's producing fractions of products. Not sure if this is acceptable or whether only whole products can be produced.
I've allowed for up to about 100 days on both curves. I note that you might want to go to 120 days. If we're on teh right track here I'll tidy that up for you.
Give it a try and let me know if this is heading in the right direction.
Bookmarks