Every year we have a pretty big golf tournament in St George Utah. There are a lot of games going on during the 5 days of golf. One of which I am responsible for. We have a game where we track Birdies, Pars in a row, Par 3 total and Par 5 total. Each member that wants to enter in pays $10 for each pot. Of course we get all dominations. We are also given some seed money to add to the pot which comes in other denominations. So the spreadsheet we have has everyone's name down the left and there total winnings on the next column. The hardest part of this process is paying people out without not knowing what to put in each envelope until you get close to the end and notice you don't have enough small bills to distribute. So what I am looking for is a way to optimize the currencies so that it figures what to put into each envelop for each entry.
Bookmarks