Michi_chan:
Hello, I'm Michi, relatively new player.
Also, this may be a random question but on the spreadsheet, certain cards like: Mind Funeral, Diabolic Tutor and Nemesis of Reason are listed as "Modern Illegal" despite them not being illegal in modern?
Welcome Michi.
With regards to the cards you have identified, the way in which my spreadsheet works out legality is tricky.. I used to pull it from magiccards.info, and have massive lookups for each card name. However to try to pull those lists from that website each time a new set was released was a) a real pain, b) not 100% accurate due to mistakes on magiccards.info, c) more prone to me making mistakes and d) time consuming.
SO, instead, I went to
http://magic.wizards.com/en/gameinfo/gameplay/formats and decided to simply get a list of edition names instead that were legal... Sounds like a much easier solution!
However, that in itself has raised a different problem. Many cards appear in different editions. IF we use Mind Funeral as an example, it appears in Modern Masters and Alara Reborn. The list of editions that are Modern includes Alara Reborn, but NOT Modern Masters. Alara Reborn was released in Apr 2009. Modern Masters was Jul '13. As you can imagine, my spreadsheet includes many duplicate cards since many cards are re-released in later editions....
So, in the case of Mind Funeral - the Modern Masters version is illegal in Modern, and the Alara Reborn one is legal.
I have a column that indicates whether a card is a duplicate or not - and when I populate that column, I make the assumption that the one we want to display will be the latest edition, not the oldest... So the Alara Reborn card is marked as a Duplicate, and when you do a search on the All Cards tab, the one you actually find first is the Modern Masters version - which is therefore showing as illegal.
Now the easy fix for this, could be to simply add Modern Masters to the list of cards that should be legal in Modern, but that would probably make a whole bunch of other cards that shouldn't be legal in Modern legal.
Similarly, if we look at Diabolic Tutor, the card appears in lots of editions:
- Magic 2014 Core Set
- Magic 2012
- Commander
- Magic 2011
- Magic 2010
- Tenth Edition
- Ninth Edition
- Eighth Edition
- Odyssey
Listed in reverse order of release date...
And the latest one - Magic 2014 Core Set - is not one of the editions listed in Modern format! "
Aaarrrggghhh!"
So... I've applied my thinking hat, and I think I've come up with a solution - essentially I have reworked my formula to look up if a card is legal in any edition and then it will re-mark them all legal in all editions.
I'll hopefully get around to uploading a new version in the near future... But for now, I will need to get off to work shortly!