In watching Omnipoke today and seeing how he’s starting to use an Excel file to track the matches he’s played, it dawned on me that I’ve never really shared the file that I use to record the data from my matches. I’ve tracked just about every match I’ve played for more than a year now, and here’s the file that I use:
This is an excel file that I put together. The first tab is the Entry Page. I like to build these kind of user interface pages to make recording your information easier than just typing it directly into a spreadsheet. To explain the entry boxes:
- My Deck – a dropdown that looks at the Dropdowns tab in column A. You can add the name of your deck here. You can write over names that I have in there already or insert cells. Just realize that if you add a name in cell A1 or below the lowest cell, you’ll have to adjust the range of the data validation in cells c2:e2 (you can do this by going to Data -> Data Validation -> and then in the pop up where it says source, just change the $A$8 to $A$9 or however further down the column you need to go).
- Result – simple just pick W or L (hopefully W!)
- Opp Meta Deck – something I started tracking with the new rotation, simply select Y or N
- Opponent’s Deck – here you do have to write out the names of the opponent’s Pokemon or the deck they are playing. I always write out the names of each Pokemon my opponent benches separated by commas, but if you just want to write down the deck or the feature Pokemon, no worries.
- There is a blank entry in cell C6 – this could be used for future reference but isn’t used track anything right now.
- Opponent’s deck SPE – again simply Y or N
- Ability – same Y or N
- Advantage – just select whoever has the advantage – I use the N/A when I’m battling a friend
- Hammers – again Y or N
- C11 through G11 is again another blank for future reference
- Notes – whatever you want to put here. Usually I write down a card that I think I might need or would have liked to have had. I also mention if I have draw support issues or something else that I might want to track the frequency of after ten or twenty matches.
It’s very easy to switch between PTCGO and this file by using ALT and Tab quickly in succession. By pressing those two tabs simultaneously, you’ll flip between the excel file and PTCGO. This makes it very easy to go back and forth while losing very little screen time on PTCGO.
You do not have to track all of this information as well – if you just want to track wins and losses and decks or even just makes notes, you can leave whatever fields you want blank, nothing is mandatory.
After you have completed entering that game’s data, click on the Run Macro button. After a brief moment, all of your information will be transferred over to the Data Page and the template will be cleared and ready for your next match.
A brief word on Microsoft Excel Macros: I always recommend that you save and close any other Excel files you have open. Excel isn’t always the most stable program, and, even though this is a very simple Macro and probably won’t cause your program to crash, it’s better to be safe than sorry.
The Current Standings tab has formulas that tie into the Data Page tab. You can see that it gives totals at the top of the standings. You can again just overwrite the decks that I have written in column A, or you can insert a row and copy the formulas down from the row above it. Just realize if you add a row below what’s already there, you’ll have to adjust the formulas in the top row.
The Notes tab is just somewhere that I can write down things I want to remember or ideas or other miscellaneous notes. The Decklists tab is where I paste my decklists from PTCGO. I usually put them from left to right, this way if I tweak a deck I know the prior versions are to the left.
Hope you find this helpful, feel free to comment below if you have any questions!