Downloads:

(NOTE: You will need to ensure that the "Analysis Toolpak" Add-in is loaded in Excel for it to work properly. If you don't know what I am talking about, go to the tools menu in Excel, and look for "Add-ins..." Make sure you check the box on the "Analysis Toolpak" option. The spreadsheet needs these so it can use the function "Randbetween()".)

• Download 2nd Edition Wizard Spellbook Generator (version 2.92) (1.4Mb) (UPDATED 3RD SEPTEMBER 2007)
• Download 2nd Edition Easy Character Sheet (version 2.5) (55kb)
• Download 3.5 Edition Easy Character Sheet (version 8) (880k) - NOT ZIPPED - in Excel format
  (NOTE - I don't really use this any more - not since I found Hero-forge.)
• Download MTG online deck spreadsheet (version 7.4) (11.04Mb unzipped) - Click here for zipped version (3.00Mb) - created in Excel 2002 format. (Updated 2nd February 2012)
  
• Update History:
  Version 1.0: Initial Creation - basic macro to draw a card from a deck. All the details needed to be entered onto the deck.
  Version 2.0: Now included formulae to look up all the details - only card name needed. Database also now included links.
  Version 3.0: Many new macros to perform various functions - much neater looking version.
  - Version 3.1: Corrected minor errors.
  - Version 3.2: Included this hideable instructions page.
  - Version 3.3: Database updated to include the English Worldwake cards. 145 additional card details added.
  - Version 3.4: Mill card macro amended to correctly handle previously scryed cards. Template sheets hidden to force new users to create new table and deck sheets to use.
  Analysis ToolPak add-in automatically checked for and added if necessary each time a new table/deck is created.
  Version 4.0: Amended the draw macro to clean up the hand. Created new macro to clean up unused lines in other sections.Improved Error Handling and ability to
  handle cards put on the bottom of the deck properly.
  - Version 4.1: Corrected formula that confirms deck legality, Database updated to include Rise of the Eldrazi cards. Wrote macros to rename deck and archive decks, to make table management easier.
  - Version 4.2: Added formula to check for duplicate cards (to help prevent accidentally forgetting to delete cards when you move them around between hand/field etc. Also added Macro to copy the sample post below onto the clip-board ready for pasting into RPOL when a new game starts.
  - Version 4.3: Removed trailing space in card names from the Rise of the Eldrazi set.
  Version 5.0 Added in an Event Macro to put an image of the card into a comment field on the number field and to assist in the process of moving cards around the table - simply type the number in the new location and it deletes it from the old.
  - Version 5.1 Corrected a couple of bugs!
  - Version 5.2 Corrected another bug.
  - Version 5.3 Corrected yet another bug in the Code to put in pictures. Added an error checking routine to handle some errors.
  - Version 5.4 Corrected some minor formatting stuff. Improved the "Initial Template post. Database updated to include the M11 cards. Deck Renaming routine improved.
  - Version 5.5 Database updated to include the Scars of Morrodin cards. Also fixed a bug with the rename deck and improved deck archiving with deck legality and new tab for notes.
  - Version 5.6 Corrected bug in "clean section" macros that deleted the cards rather than just cleaning the lines.
  - Version 5.7 Cleaned up the database by removing some duplicates - added back in the M11 cards that seemed to have gone missing!
  - Version 5.8 Reinstated the missing data that was causing the name-deck macro to fail. Corrected a minor data error in the card database on Linvala, Keeper of Silence
  - Version 5.9 Database updated to include the Mirrodin Besieged cards. Added in a couple of macros for sorting the All Cards database to make searching for cards easier.
  Version 6.0 Database completely revamped - now includes ALL cards from ALL editions todate, (including Scars of Mirrodin which had got lost somehow). Also includes new fields for Flavour text, Artist and links to each and every version of cards issued in different editions - just because it was there. The Table/Deck worksheets do not use these extra fields - but they are there in case you are interested.
  - Version 6.1 Database updated to include the New Phryexia cards. Tweaked some macros to make things neater, corrected some typos in the database.
  - Version 6.2 Database updated to include the Commander cards. Added a macro to filter out the Unhinged/Unglued cards, corrected some more typos in the database.
  - Version 6.3 Database updated to include the Magic 2012 cards. Protected the sheets to make it harder for people to screw it up accidentally. Added the ability to track the number of Mythic Rares and Rares used within a deck. Added some more help comments to help people to use the custom filters on the All Cards tab.
  - Version 6.4 Tried to correct a bug whereby the formulae still pointed toward the blankdeck rather than a newly created deck.
  - Version 6.5 Corrected a few database errors, improved speed of creating new decks and made the decks leaner so that formulae to look up cards only exist on lines with card names
  - Version 6.6 Tweaked Lock and Unlock macros to ease problems with protection. Added in buttons to sort hand/land.
  - Version 6.7 Database updated to include the Innistrad cards and card rarity changed on some cards to reflect the lowest denominator. Tweaked a macro to automatically add a new blank line when the last slot in a section on the table tab is filled.
  Version 7.0 Database has been revamped to correct legality. Commander Legality also introduced with appropriate macros and formula to support.
  Pictures support has been fixed, since it had become broken. Sort buttons added into the Deck sheet to allow you to sort your deck by different criteria when developing it.
  - Version 7.1: Corrected a minor error - the letter "G" is now allowable again in Table and Deck names. I've also opened up the plus (+), minus (-) and underbar (_) characters as well.
  - Version 7.2: Corrected a minor error - the formula looking up the number of Rares/Mythic rares was looking in the wrong column.
  - Version 7.3: Checked database and added missing cards, added in Planeswalker section on tables deck, expand and contract macros for the tables, corrected bug in the Sort macros on the database, corrected the Commander legality issue, generally cleaned up a lot of the macros.
  - Version 7.4: Corrected definition of the AllCards range. Database updated to include the Dark Ascension cards. Corrected positioning of a expand triangle so it doesn't get copied if you copy the first row of a deck.

Return to Home Page