Excel Formulas Poker
Formula challenges Excel Sudoku with formula-based validation list Combinations Excel formula challenges Poker challenge in Excel Excel Formula Challenge - Find the pattern Dartboard challenge solved - learn about matrices and circular series Combinatorics using Excel formulas Formula challenge: create a list of sheet names based on a prefix. Poker contains a lot of repetitive math, especially when studying poker hands away from the table. While you can use software to do a lot of this math, sometimes a good ‘ol fashioned spreadsheet is the best way to visualize and play with the numbers.
Excel — your friendly (and perhaps most dreaded) office tool. But it's not just for spreadsheets anymore.
Believe it or not, you can turn the
Balance sheet (Simple) Report on your assets and liabilities with this accessible balance sheet template; includes current assets, fixed assets, equity and current and long term liabilities. Excel treats 'Cleared' cells as part of the used range even though they're empty, and will size the scrolling bar accordingly. Using Rows.delete instead ensures that the scrolling bar will size itself based strictly on the data you add to the sheet. The formula you’re using is specific to the formatting I used in the example. The formula takes that and uses the “-” as the reference point to know what the big blind is. For the formula to work you either need to replace all your limits from 0.05/0.10 to 0.05-0.10 or you need to change all “-” in the formula to “/”.
1. 2048
You may have heard of the addicting game 2048 by Gabriele Cirulli. This is the same exact game, just in Excel format.
In 2048 two tiles of the same number can merge into a new tile that equals the total value of the two. The goal of the game is to have a tile value of 2,048.
The geniuses at Spreadsheet1.com built an Excel version that allows you to play the game, and track your moves to help analyze your strategy. Since the game is made entirely in Excel, you can resume the game at a later time by saving the workbook, and it can be played online or offline. It is available for Excel 2007 or later, and can be downloaded for free here.
But what if you want to play this game and be discrete at work? Reddit user Krzychu81 created a version of 2048 with 'highly advanced cloaking mechanisms to camouflage itself as financial statements.'
To download this sneaky version, click here.
2. Candy Number Crunch Saga
In four days, Canadian accountant Cary Walkin created Candy Number Crunch Saga. The game is a satirical take on the famous Candy Crush Saga game we all know and love, by King.com.
The description states that the game 'takes place in the not too distant future where King.com (KING) has had a successful IPO. The burden is on you, brave stock trader, to invest wisely and become richer beyond your wildest dreams!'
This creative game has more than 35 news events that can realistically affect stock price and includes a real-time stock ticker.
Candy Number Crunch Saga is available on PC Excel versions 2007, 2010 and 2013. To download it for free, click here.
3. Monopoly
Tumblr user Andrew Werner was playing the popular board game Monopoly with his wife and friend when he began to think of different strategies for the game.
After 12 to 14 hours of work, he created a Monopoly simulator in Excel using a programming language called Visual Basic for Applications (VBA). The game allows up to four players, and was updated in August 2011 with the option to choose 'human' or 'computer' players.
To download it for free, click here.
4. 3D Maze
Built into an Excel grid, 3D Maze was developed by Jordan Goldmeier from Option Explicit VBA. Goldmeier, a guest author on Walkin's blog, shared a step-by-step tutorial on how to create 3D mazes and posted this game.
Using the arrow buttons in the spreadsheet, you can easily move around the maze. Below the arrows, a map can also help you navigate the maze.
3D Maze is available on PC Excel versions 2007, 2010 and 2013. To download it for free, click here.
5. Arena.Xlsm
In addition to Candy Number Crunch Saga, Walkin designed a full-length role-playing game called Arena.Xlsm. The game took five months to make, and was released last March. It features more than 2,000 possible enemies, 1,000 possible item combinations, a storyline with four different endings and 31 spells.
Arena.Xlsm is available on PC versions of Excel 2007, 2010 and 2013. To download it for free, click here.
6. Writer's Block
Excel Formulas Percent
Kevin Lyman, a former Microsoft intern, built an original multiplayer word game that he describes as 'Scrabble meets Battleship.' Writer's Block, the name of the game, was built entirely in Excel using a combination of conditional formatting, Visual Basic for Applications (VBA) and images, Lyman tells Mashable.
Lyman is currently porting Writer's Block from Excel to mobile platforms, and plans to release it to Android, iOS and Windows Phone this coming November. The Excel version of Writer's Block is not available to the public, but will be once the mobile versions are out.
This page lists some spreadsheets and links for having some fun with Microsoft Excel. The spirograph is a very cool use of a chart and the Mine Blaster game uses some very fancy conditional formatting. Enjoy. :-)
Spirograph
The spirograph spreadsheet below was originally sent to me by Gary Stringham. He gave me permission to spruce it up a little and post it on this site. Thanks, Gary.
License: Personal Use Only
Description
This is a fun little spreadsheet that lets you create a spirograph. Try playing with the slider bar and modifying some of the parameters to change scaling and the number of 'spokes'.
Mine Blaster 1000
This game uses only formulas and formatting - no VBA. If you get caught playing it, say that you are trying to learn how to use conditional formatting, and that this game was created specifically to showcase an example of conditional formatting.
Mine Blaster 1000 ▶
Take a quick break to try a new game developed exclusively for Excel 2007/2010. Mine Blaster 1000 is similar to Minesweeper, but you are trying to blow up the mines, and your bombs cost money. Can you clear the mine field for under $1000?
Tournament Brackets and Office Competitions
NCAA Bracket and Pool Template ▶
Friendly office competitions related to March Madness and other sports tournaments can be a lot of fun. You can download our NCAA March Madness bracket and use the pool worksheet to track different players' picks, and the points earned for guessing correctly are calculated automatically.
Ghost in My Spreadsheet 👻
Excel Formulas Power Of 2
Other Fun Stuff with Excel
- Hot Key Excellence - Provides a fun way to learn keyboard shortcuts and other Excel tricks.
- 2048 game in Excel - A fun game by Spreadsheet1.com
- Sudoku Puzzles : Free printable grids for the avid puzzler.
- Easter Eggs - j-walk.com - A list of easter eggs for various versions of Excel.
- Space Invasion - A cool video, created one fram at a time, with Excel.
- Excel Art: 17 Awesome Drawings Made with Microsoft Excel via huffingtonpost.com
- Bingo Template by John MacDougall at howtoexcel.org
Excel Games
There are a bunch of games made for Excel. Most use VBA and some very basic graphics.
- Excel Treasure Hunt by Debra Dalgleish - A fun spreadsheet with an explanation of how it was created.
- Andrew's Games - AndrewsExcelTips.com - Andrew's blog listing the games he has created, including Mastermind, Battleship, Rocket, Excel Snake, and Morse Code.
- Excel Games - www.cpearson.com - X-Ray! is like Minesweeper (the VBA is unprotected - so you can take a look). Mine3D, xlCube, and Excel Bingo (provided by David Hager).