This is what I've been using to figure my tournament set. I've figured everything for an 8-max tournament but I don't see why it wouldn't work for 9 and 10-max tables too. This morning I cleaned it up and annotated it for public consumption.
You input starting stacks, chip colors and values, etc and the spreadsheet boils it all down to two very important cells on the first sheet, "Number of rebuys each at max participation".
There's a blind schedule sheet that allows you to see M based on some variables you pick.
There's a payout sheet so you can see approx how much money may be in your prize pool and three different prize structures to compare.
And, of course, the inventory sheet shows you your totals!
I've made an assumption that I'll have the 10 Gray and an additional 10 Orange to bring my set up to what's in the spreadsheet right now... it's a done deal, the carrier would have to lose them or something, so I'm just going to assume for my set.
Unless you know what you're doing, ONLY CHANGE VALUES THAT ARE BOLD AND HAVE A BLUE BACKGROUND! Changing anything else will totally screw up EVERYTHING! But... you can always just revert back to the original
Have fun with it and critique welcome...
Made with openoffice, saved as excel. Please notify of bugs.
I'm already planning on adding a "wish list" sheet so you can see what happens to the whole thing when you add X number of Y color and W number of Z color... ya know, what we all wonder while daydreaming
I'll probably throw on a "what if I added N number of a plaque worth H?" line too.
Download v. 0.7.1
Requires a little Turing test and then "submit" at the bottom.
Linear Mode
