Chica and Jo Chica and Jo

DIY tutorials, party ideas, recipes, crafts, and tips for everyday life

Chica and Jo Chica and Jo

DIY tutorials, party ideas, recipes, crafts, and tips for everyday life

Chica and Jo Chica and Jo Facebook TikTok Pinterest Instagram

Kentucky Derby Betting Pool Spreadsheet (2024)

by: Chica
This page may contain affiliate links and we may be compensated if you make a purchase after clicking them. As an Amazon associate I earn from qualifying purchases.
Kentucky Derby Betting Pool Spreadsheet (2024)
Facebook Pinterest Email
share it

We live in Kentucky, so of course we love the Kentucky Derby! As usual, we're celebrating the first Saturday in May with a small party for friends to watch the race with us, and we love to host our own betting pool during the race. To make it easier to manage the Derby bets, we've come up with a downloadable betting pool spreadsheet that calculates odds and determines the payout for the winner.

Kentucky Derby betting pool spreadsheet

Our free downloadable betting pool spreadsheet is very simple to use. Just keep the spreadsheet open on your computer during the party, and every time somebody places a bet, add the dollar amount of that bet to the current total (in the "Wagers" column) for that horse. When the race is over, find the winner on the spreadsheet and it will give you the odds to pay out for each person who bet on the winning horse.

We went ahead and filled in the spreadsheet with the 2024 Kentucky Derby field, including horses, trainers, and jockeys. However, keep in mind that you might have to make some changes right before the party based on last-minute scratches or jockey changes.

Once you have downloaded our 2024 Kentucky Derby Betting Pool Spreadsheet and double-checked it against the latest news, you are ready to open your virtual betting window.

2024 Kentucky Derby betting pool spreadsheet

NOTE: You may need to click the "Enable Editing" and "Enable Content" buttons at the top of the Excel window to make this spreadsheet editable and activate the macros. Also, the pool odds won't compute properly until after you have entered a few bets but don't worry, they will work after that.

Kentucky Derby printable betting tickets

To make it easy to keep track of the winning bets, download our printable derby betting tickets. Print and cut them out, then hand one to each person who places a bet, to serve as a receipt and record of their wager. Be sure to write the person's name and amount of the bet on the ticket so there's no confusion later.

Betting pool spreadsheet for the 2020 Kentucky Derby

Kentucky Derby party ideas

Here are some of our ideas for decorations and food for your Kentucky Derby party:

Printable Kentucky Derby party decorations

Decorating for the Derby is so much easier with our huge collection of Kentucky Derby party printables, available on Etsy, with tons of printable pages to help you throw your party.

Kentucky Derby printable party decorations

Kentucky Derby Betting Pool Spreadsheet (2024)
Facebook Pinterest Email
share it

8 comments so far:

  • 1
    Genevieve 05/03/2022 at 2:30 pm

    Ladies, you are awesome. I love this betting pool spreadsheet. It makes my data loving heart soar! Thank you!

  • 2
    Chica 05/03/2022 at 2:46 pm

    Genevieve, we're so glad we could make your day! Enjoy the race.

  • 3
    Dar 05/03/2022 at 8:05 pm

    Thanks so much for updating for 2022. This makes my Derby party so much easier.

  • 4
    Chica 05/04/2022 at 8:18 am

    Dar, of course! Happy to help with your party.

  • 5
    Liz 05/05/2022 at 4:42 pm

    I love this but I need some help using it. How do I pay out the winners using the odds? Say 6 people put money on the winning horse and its odds were 7:1. What would each person win?

  • 6
    Chica 05/05/2022 at 8:34 pm

    Liz, to pay out the winners, just take the total amount bet and divide it equally among everyone who chose the winning horse. At that point, the odds don't really matter, nor do the number of bets placed. For example, if the entire pool is $60 and there are 6 winners, then each winner gets $10.

  • 7
    Kendal Reuther 03/10/2024 at 6:07 pm

    Will you have a 2024 Kentucky Derby betting pool sprradsheet?

  • 8
    Chica 03/12/2024 at 8:48 am

    Kendal, yes we will update this for 2024, but not until the field is set, which is usually a week or so before the Derby. Check back!

leave a comment:

submit comment

Chica and Jo

Hi there! We are Chica and Jo, best friends who love to create whenever we can. From fun DIY projects to elaborate parties to delicious recipes, you're sure to find ideas that will inspire you. Take a look around and follow us @chicaandjo to see what we're up to today.

shop our Favorites
buy us a cup of coffee

want to support us?

buy us a cup of coffee
Please visit Chica and Jo at http://www.chicaandjo.com for more DIY projects and clever ideas!