Hey all, first post, longtime reader.
I am working on creating my own version of the Beer Game (if you have never heard of it, Wikipedia has a good article on it). So far I'm doing well creating it, but I am having a hard time accounting for the two rounds of lead time required for the game rules.
How I have it set up is that each player has their own worksheet (Retailer, Wholesaler, Distributor, Factory). Each screen looks something like this:
All the information in white will be provided by the script which should help the user to make a decision on inventory to order, which is yellow.
The data gets stored in the "Data Storage" sheet so that it can be called upon by all of the modules I'm running (which feels like a ton).
Anyways, the main part of the question:
The professor wants us to have the ability to alter the lead time at the beginning of the game: 0 rounds, 1 round, 2 rounds. 0 rounds is pretty easy, but I'm having a hard time making a sub that would allow the game to account for variable lead times.
Hopefully that wasn't too convoluted. Let me know how else I can explain what is going on here.
Brad
I am working on creating my own version of the Beer Game (if you have never heard of it, Wikipedia has a good article on it). So far I'm doing well creating it, but I am having a hard time accounting for the two rounds of lead time required for the game rules.
How I have it set up is that each player has their own worksheet (Retailer, Wholesaler, Distributor, Factory). Each screen looks something like this:
All the information in white will be provided by the script which should help the user to make a decision on inventory to order, which is yellow.
The data gets stored in the "Data Storage" sheet so that it can be called upon by all of the modules I'm running (which feels like a ton).
Anyways, the main part of the question:
The professor wants us to have the ability to alter the lead time at the beginning of the game: 0 rounds, 1 round, 2 rounds. 0 rounds is pretty easy, but I'm having a hard time making a sub that would allow the game to account for variable lead times.
Hopefully that wasn't too convoluted. Let me know how else I can explain what is going on here.
Brad
