Why should we almost always use Excel for boring things like invoices, expense reports or plans? Why should we not try to entertain ourselves with such games as Yahtzee, for example?
That’s what I was thinking about when I watched my some people close to me playing the dice game Yahtzee on the lakeshore.
Click here to go directly to the download.
Today there is an Excel template for Yahtzee!
In addition, I’ll explain the rules, the probabilities of individual throwing combinations and refer you to sources where you can play Yahtzee online in the browser for free 🙂
But first preview the Excel template.
Update: Thanks to Laura, there is a new Yahtzee template with automatic calculation!
Take a Look at the Screenshot of the Yahtzee Excel Template
Excel template for Yahtzee
Download the Yahtzee Template for Free
Here you find this template in different file formats (XLSX & PDF).
New Excel-template with automatic calculation:
The Rules of Yahtzee
The aim of the game is to dice as many points as possible. You may roll with 5 dice. Each player has three attempts to reach his respective target. After the first roll the player may put aside those dice which he needs for the combination and continue playing with the remaining ones. After every roll the player may change the planned combination.
Example:
- The player rolls: 1 6 3 5 6.
- He puts two sixes aside and rolls the remaining three dice further.
- In the second roll, the player gets: 1 3 6.
- He puts the six aside and now has 3 sixes collected.
- In the third attempt, he rolls 2 and 5.
- Now he can enter 18 in the upper section in the “Sixes” row (3 x 6 = 18) or 25 in the “Three-of-a-Kind” area in the lower section (3 x 6 + 2 + 5).
In the upper section, you should note that there is a bonus when you have collected a total of 63 or more points. The 63 is selected on the following basis: when you have collected 3 numbers in each row, the final total will be 63. (3*1) + (3*2) + (3*3) + (3*4) + (3*5) + (3*6) = 63. So, beware when you reach a lower total with one number, you have to create 4 of the same value with another higher number again in order to get the bonus.
Three-of-a-Kind
Three dice of the same value should be rolled. As a result, all scores will be noted.
Four-of-a-Kind
Four dice of the same value should be rolled. As a result, all scores will be noted.
Full House
3 and 2 dice of the same value should be rolled. There are 25 points for it.
Small Straight
4 dice with consecutive numbers should be rolled (1, 2, 3, 4 or 2, 3, 4, 5 or 3, 4, 5, 6). There are 30 points for it.
Large Straight
5 dice with consecutive numbers should be rolled (1, 2, 3, 4, 5 or 2, 3, 4, 5, 6). There are 40 points for it.
Yahtzee
5 dice of the same value should be rolled. There are 50 points for it.
If you have rolled a second Yahtzee, you get 50 extra points, and you can use a joker in the lower section. Joker: If, for example, you do not have full house, you can record 25 points.
You may use other sources for playing Yahtzee online:
It’s a free source for playing Yahtzee online, just in your browser:
Here you may read about Yahtzee variations:
https://www.wikihow.com/Play-Yahtzee
Hi Philipp:
Great job on this Yahtzee Score Card template. I noticed that it was missing formulas to auto-calculate the values, so I updated it for my family and thought you might like to offer the template with this addition. I think I captured the data correctly, but I would defer to your expertise on the rules, as you have researched them more thoroughly that I have (I just updated the template based on the way I have always played the game).
I would be happy to send you the updated file and to coordinate with you on the finalized version, if you are interested. Please email me to get the file and collaborate!
Sincerely,
Laura
Hi Laura,
what a great idea!
Thanks so much – I write you an e-mail..
Best regards
Philipp