Tourney Pinning down the elusive "perfect chip set" (spoiler: it doesn't seem to exist). (1 Viewer)

[TheSourPatchKid]

I've been working on this spreadsheet to help me figure out how many chips I'd need to buy for a desired game format. I want it to be flexible so that I can tweak the important variables like the number of players, re-buys, add-ons, and starting chips.

The idea/hope is that I can punch in different values in the gold colored cells, and then get busy with the fun part which is to go shopping for whatever shows up in the green cells (pretty much everything else is calculated).

I've read several existing threads on the subject (by the way, thank you to all of you who have replied in those past threads -- it's been very helpful). I think I have a pretty good spreadsheet for what I wanted to achieve, but was hoping to get some final guidance/confirmation on the color-up denomination choices. Based off of previous comments that I read:

In the T25/10K tournament I have it calculate coloring up the T25 and T100 chips using T1000, and then coloring up the T500 chips with T5000.

In the T5/2K tournament, I have it calculate coloring up the T5 and T25 chips using T500, and then coloring up the T100 chips with T1000.

Re-buys and add-ons are all added as T5000 chips.

I know there are a gazillion ways to do it, and a lot depends on individual preference, but does what I've done so far make decent sense?

Notes:
Ignore the T1/1K section unless anyone has thoughts/suggestions on color-up decisions there -- it seems to be not a very popular format. I just threw it in there in case there's a particularly nice looking set of chips where the $1 denom look awesome. Plus some people might find it useful if that's what they like.

Also, the %stack and %value columns are not important, I just thought they were interesting to have in there.

p.s. I tried to attach the actual spreadsheet in case others would find it useful to mess with, but it would only let me choose/attach images and text files, other file types were grayed out (probably for security).

 

[trigs]

#moarisbetter

 

[BGinGA]

I calculate color-ups using the round-up method, so my T1000 total would be 10 chips for a 6-player T25-base T10k stack set (my spreadsheet uses the ROUND function on both the T25 and T100 color-ups independently and then adds them together).

Also,

#moarisbetter

Always good to have extra T1000 chips. Using two T5000 chips for early re-buys can be problematic, especially in small fields where there may not be any stacks large enough to break one of them down into useable change.

 

[inca911]

The ultimately-flexible tournament set equation has been solved (imho). You can go very big if you want!

• T25 = 320
• T100 = 320
• T500 = 200
• T1K = 300
• T5K = 200
• T25K = 100

 

[TheSourPatchKid]

I calculate color-ups using the round-up method, so my T1000 total would be 10 chips for a 6-player T25-base T10k stack set (my spreadsheet uses the ROUND function on both the T25 and T100 color-ups independently and then adds them together).

Also,

Always good to have extra T1000 chips. Using two T5000 chips for early re-buys can be problematic, especially in small fields where there may not be any stacks large enough to break one of them down into useable change.

Nice catch, I thought that's what I was doing, but I was calculating them at the same time with:
=ROUNDUP(((A4*F4)+(A5*F5))/A7,0)
and coming up with 9

I changed it to this:
=SUM(ROUNDUP((A4*F4)/A7,0)+ROUNDUP((A5*F5)/A7,0))
which calculates them independently (as you said) and then sums them. Now I also come up with 10. It's a minor change but that's the kind of tweaking I'm looking for to get it right. Thanks.

As for the T5000 being too big early on, that's a really good point. Should I skip them altogether? Or maybe take the total of what I calculate for re-buys and add-ons and then split it up somehow (50/50?) so I end up with fewer T5000 and more T1000?

I do agreed with @trigs that #moarisbetter I just want to get an accurate starting point. I'm looking to buy nicer chips than what I currently have and that means moar$$$ so I'd like to figure out the best way to buy what I need (with a little padding of course). Probably no more than 6 people I figure.

 

[TheSourPatchKid]

The ultimately-flexible tournament set equation has been solved (imho). You can go very big if you want!

• T25 = 320
• T100 = 320
• T500 = 200
• T1K = 300
• T5K = 200
• T25K = 100

View attachment 382555

View attachment 382554

Now that's a lotta damage!