Tuesday, September 12, 2017

Ultimate Holdem Casino Excel Game

When I was originally creating this, the main purpose was to help some people learn the payouts for the Trips and Blind wager on a specific pay table.  The end result ended up just being something that people played more for fun than training, however.  

You can download the game here, and once you open it, you will see the screen below.

Your bankroll is listed in the upper left hand corner.  To play, you must post and Ante and Blind of equal value.  The Trips wager is an optional side wager, and the table max is $50 for Ante, Blind, and Trips.  You are allowed to wager 3x or 4x your Ante on the Play wager prior to any community cards being revealed.  After the first three cards are revealed you can play 2x, and after all five cards are revealed you are limited to 1x.

The pay table for this particular game is as follows:

  • Blind
    • Less than a flush - 1 to 1
    • Flush - 3 to 2
    • Full House - 3 to 1
    • Four of a Kind - 10 to 1
    • Straight Flush - 50 to 1
    • Royal Flush - 500 to 1
  • Trips
    • Less than trips - Loss
    • Trips - 3 to 1
    • Straight - 4 to 1
    • Flush - 7 to 1
    • Full House - 8 to 1
    • Four of a Kind - 30 to1
    • Straight Flush - 40 to 1
    • Royal Flush - 50 to 1

After the hand is played out, you will be prompted to enter what the Trips and Blind bet will payout.  This is 100% optional, and there is no penalty for just pressing "Deal" and skipping through it.  In the above example, the answer to both would be $0.

If you do decide you would like to practice this particular pay table, this is what the screen will look like when you write your answer and press "Deal."

*This particular game was never 100% completed, and as such, there are two instances in which the game will not behave as expected.  True five card ties will not be treated as a push, but as a loss for the player and a Royal Flush will not always play out correctly.  It is unlikely that I will delve back  into this game, although  I can't say it will never happen.

Monday, September 4, 2017

Double Deck S17 Excel Blackjack Game

Today I would like to share a S17 DAS Double Deck Excel game that I created.  Feel free to download and use this to practice tracking your running and true count, play long term to track a practice bankroll, or just as a fun game to play to pass the time.

The top row will show the dealer's cards, and the next row will show the player's.  You may split up to three times for a total of four hands.  You are given a $10,000 bankroll to begin.

Both the running count and the true count will be shown between hands, although there is a toggle to the left which allows you to hide these numbers until you want to check.  The Hi Lo count is the count used.  True count is calculated at quarter deck resolution, and then floored.  

The discard tray is placed in the upper right hand corner, and displays the math needed to convert your running count into your true count.  

If you Wong out at a certain count, you can use the shuffle button next to the discard tray to get a fresh shoe.  And if all else fails, there is an emergency clear button if you happen to run into a bug causing issues.  Enjoy!

Thursday, August 31, 2017

Double Deck H17 Excel Basic Strategy Trainer

For those looking to hone their skills while some of the more traditional options aren't available, I have created a few handy Excel projects that I will be releasing over the next few weeks.  This particular file is designed to help practice basic strategy for a DD H17 DAS RSA game.

Click here to download

To use, simply hit the button that corresponds to the correct action in each scenario.  In the above example, I would want to hit Stand.

As you can see, the program shows that I was correct, the rule is displayed, and the counter is increased by one.  To be dealt new cards, I simply press deal.  If I feel like I am struggling in a certain area, I have a couple options.

Across the bottom of the file there are separate tabs.  The "Main" tab uses a deck with a normal distribution of cards.  The "Soft Hands" tab has a deck packed with extra aces, and the "Hard Hands" tab has none.  The "Blank" tab can be ignored (and is truly only there for aesthetic purposes).  If you need to check a Basic Strategy chart, there is a tab for that also.   

To download the file, click this link and hit download.  You must use this in Excel as the Google Docs version will not do anything.  You must also click enable content and Macros when the options appear.  

If you ever run into any issues or have any questions, feel free to leave a comment and I'll try to get back to them as I see them.  Keep an eye out for some more programs I plan to release in the future.