Weird request - Excel formula (1 Viewer)

[Mesnik44]

Hi,

I'm in need a formula that will break out any number into a stack of chips. The excel just doesn't flow through me

If I enter 5125, I would like the formula to break out 5x1000, 1x100 and 1x25.

If any excel gurus are out there, I would really appreciate your formula and help!

Thank you in advance.

 

[Pokerdweebz]

go here https://www.jdoodle.com/online-java-compiler
copy paste this, make x your number, then click execute:

public class MyClass {
public static void main(String args[]) {
int x=5125;
int y = x%1000;
int z = y%100;

System.out.println("1k: " + (x/1000) + ", 100: " + (y/100) + ", 25: " + (z/25));
}
}

 

[bentax1978]

If you need to do the same thing @Pokerdweebz did above in excel, you can use the formula below.

=INT(A1/1000) & "x1000, " & INT(MOD(A1,1000)/100) & "x100, " & INT(MOD(INT(MOD(A1,1000)),100)/25) & "x25"

 

[abby99]

How about this?

@bentax1978: Thanks for another Excel function that I didn't know about. (y) :thumbsup:

 

[Mesnik44]

I LOVE YOU GUYS!

Thanks for the quick responses

 

[bentax1978]

If you want to get "fancy", you can paste this code into the VBA editor and create a custom function. The function allows you to specify the specific denoms you want to use. There's no error checking in there, so just make sure you enter the denoms from high to low.

Public Function breakdown(stack_size, ParamArray denoms())

For Each denom In denoms

chips = Int(stack_size / denom)
stack_size = stack_size Mod denom
breakdown = breakdown & chips & "x" & denom & " "​

Next denom​

If stack_size = 0 Then

breakdown = Trim(breakdown)​

Else

breakdown = breakdown & "(" & stack_size & ")"​

End If​

End Function


Here are some examples of the output:

 

[Mesnik44]

I want to thank everyone that replied.

The reason I wanted this, was for my multi-life games at my Christmas tournament. We play 3 games, and after each game you add up your chips to create a bonus pool for the main event.
I needed a way to quickly create the bonus stack at the end of the multi-life games. This is it. It will save me a lot of time, and I appreciate everything that you all have done.

 

[BGinGA]

If I enter 5125, I would like the formula to break out 5x1000, 1x100 and 1x25.

System.out.println("1k: " + (x/1000) + ", 100: " + (y/100) + ", 25: " + (z/25));

=INT(A1/1000) & "x1000, " & INT(MOD(A1,1000)/100) & "x100, " & INT(MOD(INT(MOD(A1,1000)),100)/25) & "x25"

How about this?

examples of the output:

Y U NO LUV 500?

Bigots.

 

[bentax1978]

Y U NO LUV 500?

Bigots.

 

[Poker Zombie]

I want to thank everyone that replied.

The reason I wanted this, was for my multi-life games at my Christmas tournament. We play 3 games, and after each game you add up your chips to create a bonus pool for the main event.
I needed a way to quickly create the bonus stack at the end of the multi-life games. This is it. It will save me a lot of time, and I appreciate everything that you all have done.


View attachment 139513

It seems to me you could run into serious change-making issues like that. If a player gets exactly T5000, they start with 1 stupid chip, and thus need change from blind one - and it might not even be available from any player!

Best to write the formula to give ample lower denoms (10-12) per player, and only go to the big chips as necessary to keep smaller denoms reasonable.

 

[Mesnik44]

It seems to me you could run into serious change-making issues like that. If a player gets exactly T5000, they start with 1 stupid chip, and thus need change from blind one - and it might not even be available from any player!

Best to write the formula to give ample lower denoms (10-12) per player, and only go to the big chips as necessary to keep smaller denoms reasonable.

Lower denoms are in the Main Event Stacks

These are the chips earned from buying in early

So, the less chips added later on the better.

 

[abby99]

Oops, you wanted to know how to calculate starting stacks given the total? Looks like I solved the wrong problem.

 

[Mesnik44]

No Abby99, you were correct. I needed the formula you gave me.