Hello Excel gurus I do not have a sample data set but here are the circumstances:
1. It take 90 minutes for each item to be built. (known)
2. I have 53 units to be built (variable)
3. I have only a 3 hour window 7a - 10a to build, some sites will all all day 7a - 5p (variable)
4. I have 2 builders available on start day, and 1 additional builder on day 9 and 2 additional builders on day 14 (variable)
2 builders on day 1 - 90 min each item to build - 180min off the 240min build window, continue to build until window closes
if the cycle is incomplete, deduct the completed units, and add another day to build cycle repeat until unit count is is zero
How do I formalize this so I can rerun this cycle build it will take to complete all 53 units? 95 units? 210 units? utilizing the variables as outlined
You guys have save bacon numerous times and I get those aha's and learning from this group!
Thank you all to take up this challenge.
1. It take 90 minutes for each item to be built. (known)
2. I have 53 units to be built (variable)
3. I have only a 3 hour window 7a - 10a to build, some sites will all all day 7a - 5p (variable)
4. I have 2 builders available on start day, and 1 additional builder on day 9 and 2 additional builders on day 14 (variable)
2 builders on day 1 - 90 min each item to build - 180min off the 240min build window, continue to build until window closes
if the cycle is incomplete, deduct the completed units, and add another day to build cycle repeat until unit count is is zero
How do I formalize this so I can rerun this cycle build it will take to complete all 53 units? 95 units? 210 units? utilizing the variables as outlined
You guys have save bacon numerous times and I get those aha's and learning from this group!
Thank you all to take up this challenge.