I showed off some of my spreadsheet in my previous post and some people on Twitter were looking for it. So I tinkered around with what I had and added some new things. So I’m happy to announce v1.0 of said spreadsheet.
- I used Office 2013 to make this spreadsheet due to Conditional Formatting, Formulas and Notes that I don’t know how much of it will work in older versions.
- Because the way this is constructed, it can be used for Tiny Leaders as well. I guess if you don’t mind writing the same card over and over again, then it can be used for any format if you want. There are up to 50 lines for each card type so it can work for most competitive decks as well.
- Can be used with mono-color, dual-color or tri-color decks. No four or five color decks at the moment.
In the spreadsheet I give you the basic template and a copy of my v0.9 of my Brion Stoutarm sheet as an example. There were some changes to the 1.0 version that I just didn’t clean up for the Brion version. The key here is to make the spreadsheet as automated and useful as possible. There are still things I want to do in here (Such as sort each color’s card type by CMC), but I wanted to get the basic functional spreadsheet out. I have notes attached to certain cells and those apply for all the logical cells, please read them so it makes understanding the sheet easier. It’s not completely user friendly, a problem I have when I design spreadsheets for myself, but I’ll be working towards a more elegant presentation.
The first screen that you see is the basic decklist, and where the info is presented, NOT where you start typing. If you scroll to the right, you can see the different categories of cards where you fill in the information. The other screen will populate automatically with the info that you put it. Since this isn’t hooked up to a database, you have to fill in the information properly (it’s your fault if you mess up). If you continue scrolling to the right, you see a bunch of extra information to make the whole sheet work. Since I’m still working around in Excel, I’m sure this could be better executed, but at the moment that’s what you get.
I have put in the note for the CMC where I found that formula: vorketh on the MTGCommander.net forum. Pretty awesome to have found it which makes this page a bit smaller.
There are some things that I want to do with future versions of this spreadsheet:
- Keep track of changes from set to set.
- More detailed information about the colors in your deck such has the P/T, CMC of each card type, Mana symbols.
- More land information (what type of color the land produces/how much mana it produces)
If you’re looking for a different type of spreadsheet, General Damage Control has one of their own which is nice if you’re looking for more category oriented sheet (Draw/Kill/Combo Pieces, etc). Since I am not really looking to do with this set up, I am passing that link to you if you prefer that for organizing your deck.
So download the template, explore it, wreck it, and change it to fit your needs. Follow the notes and you can operate this pretty easily. Take pieces of this and use it on your own spreadsheet, that’s perfectly okay as that’s part of what I did here. If you have any questions or comments, you can comment down below contact me on Twitter (@MTGColorPie), or email me (mtgcolorpie @ gmail)