Daily Capacity Calculation
I'm trying to workout how to create a way to chart our capacity per day using a master sheet which shows the Stop Date and Release Date, to add complications each unit is of a different size and owner which are listed in different columns.
Currently I do it manually; an example of what I need to do -
Stop Date - 01/01/21
Release Date - 13/01/21
Size - 2
Owner - XX
Need an output of for everyday to be charted but this is done for more than 25 units everyday of various sizes and sorted by owners. Every day between 01/01/21 and 13/01/21 would be shown on a chart with 2 added to each day, sorted by owner. The total is usually between 38 to 48 each day once all the units are added up for the days they are stopped.
Hopefully that makes sense!
Help Article Resources
Check out the Formula Handbook template!