I took the printable spoiler from the link on the spoiler page and edited it in Word to bring it to 12 pages. I've made a few changes (removing much of the reminder text and as far as I can tell all of the flavor text, artist credits, and collector numbers), however the content is mostly unchanged.
If anyone can improve on it, by all means. Personally, I think it'd be awesome if it was in Excel, and therefore sortable and searchable. I'm not quite up to that, though.
In any case, this should be pretty good for "studying" for prereleases and such. Enjoy!
That had to have kept you busy for quite some time! Lots of thanks!
It was actually pretty easy. I'm an editor by trade, so I can put off real work by doing Magic-related stuff like this *grin*
Something to pay attention to: minor changes in the spoiler. For example, apparently there is one extra red common listed, which should be an uncommon (it is currently unknown which). Also, perhaps other small wording changes will crop up in the next few days. Be sure to incorporate any of these changes into your version of the spoiler!
While I was on shift last night I decided to start on doing up the spoiler in Excel before I even noticed this thread. Finished it this morning. Using Excel 2000, but if there's enough call I can convert it into something lower. Here ya go.
I took the printable spoiler from the link on the spoiler page and edited it in Word to bring it to 12 pages. I've made a few changes (removing much of the reminder text and as far as I can tell all of the flavor text, artist credits, and collector numbers), however the content is mostly unchanged.
If anyone can improve on it, by all means. Personally, I think it'd be awesome if it was in Excel, and therefore sortable and searchable. I'm not quite up to that, though.
In any case, this should be pretty good for "studying" for prereleases and such. Enjoy!
Quite handy actually, now I can easily proxy them buy just printing them out instead of writing everything down.
Private Mod Note
():
Rollback Post to RevisionRollBack
hey i have managed to evolve my axolotls by feeding them thyroid glands the thyroxine contained in these gland is enough to change these water dwelling creatures into land based creatures
Posted by: Tay Collins | January 20, 2010 6:45 AM
Tay, that's not evolution. It's metamorphosis. Evolution means descent with heritable modification – individuals cannot evolve, unless they're Pokemon.
Posted by: David Marjanović | January 20, 2010 8:55 AM
I'm attaching a spreadsheet spoiler I made.
It has separated fields for types/subtypes and p/t as well as a field for color, to make sorting easier. Also, all the abilities are in one field.
Hope it's useful to someone else.
ATTACHMENTS
Lorwyn
Private Mod Note
():
Rollback Post to RevisionRollBack
Decks: Standard - Rally, Modern - Kikichord, Legacy - Elves
Commmander - Eight-and-a-Half Tails; Kiki-Jiki, Mirror Breaker; Prime Speaker Zegana; Alesha, Who Smiles at Death; Daxos the Returned; Mazirek, Kraul Death Priest; Patron of the Moonfolk; Animar, Soul of Elements
I appreciate what you did for your spoiler, but there's one little hitch for trying to put all the abilities on one line. A perfect example is Warp World. Trying to fit the Oracle or card text of that card on one line is next to impossible. Granted, this isn't the case with all cards, or even most of them, but you're going to need to assume at least two lines for abilities. Fortunately, with Lorwyn, for the most part the biggest reason for carrying an ability over to the second line is the reminder text for Clash.
That being said, I like the idea of having a separate field for subtypes. I changed P/T to Size for one reason: to account for Planeswalkers as well. Otherwise, I would have gone with P/T and easily could have made that two fields.
One other thing I could add would be a column for the CMC of a card. I have a formula I came up with that would figure it out (it would have been simpler in a programming structure, but setting it up as an Excel formula is a pain..!!) and it accounts for just about everything including things like Decree of Justice (probably the most complex mana cost in the game) and Lands (which it lists as such instead of giving CMC 0). I can toss it up here if anyone is interested. It's long but effective.
Mindstab, one possible "solution" to the "all abilities in one field" problem you may see is to simply select the column with the Abilities data, widen it a bit (to your tastes), go to Format --> Cells, then click the "Alignment" tab, and check the box marked "wrap text." I've found this to be fairly helpful in reading the abilities.
To everyone who took the time to make additional versions of printable spoilers, thanks! They all have their uses, strengths, weaknesses, etc.
Updated spreadsheet; still wants card number and such but divided again based on Kaldare's ideas. Gives you CMC, colour, types, supertypes, and subtypes. Columns D through H are for 'Does this card have this colour in its mana cost?' and are hidden; column I, also hidden, gives a sum of the colour codes for sorting purposes. For example, code 1 is monowhite, code 2 is monoblue, code 3 is white/blue, code 4 is monoblack, code 6 is blue/black, etc. Numbers assigned are based on binary math. With a lil fiddling you can probably get it to hand you all the cards in a given colour combination.
Props to Kaldare for the ideas (I haven't seen his spreadsheet, but went by his descriptions). Hope it's useful
Here's my corrected version of the spoiler, taken from the card images. It's in my patented format - sorted by colour, rarity, and casting cost. Enjoy!
Very impressive Orange Mage. Your spoiler won my vote and the rights to my printer
Private Mod Note
():
Rollback Post to RevisionRollBack
To post a comment, please login or register a new account.
If anyone can improve on it, by all means. Personally, I think it'd be awesome if it was in Excel, and therefore sortable and searchable. I'm not quite up to that, though.
In any case, this should be pretty good for "studying" for prereleases and such. Enjoy!
It was actually pretty easy. I'm an editor by trade, so I can put off real work by doing Magic-related stuff like this *grin*
Something to pay attention to: minor changes in the spoiler. For example, apparently there is one extra red common listed, which should be an uncommon (it is currently unknown which). Also, perhaps other small wording changes will crop up in the next few days. Be sure to incorporate any of these changes into your version of the spoiler!
While I was on shift last night I decided to start on doing up the spoiler in Excel before I even noticed this thread. Finished it this morning. Using Excel 2000, but if there's enough call I can convert it into something lower. Here ya go.
Awesome sauce. Thanks.
**
Posted by: Tay Collins | January 20, 2010 6:45 AM
Tay, that's not evolution. It's metamorphosis. Evolution means descent with heritable modification – individuals cannot evolve, unless they're Pokemon.
Posted by: David Marjanović | January 20, 2010 8:55 AM
It has separated fields for types/subtypes and p/t as well as a field for color, to make sorting easier. Also, all the abilities are in one field.
Hope it's useful to someone else.
Commmander - Eight-and-a-Half Tails; Kiki-Jiki, Mirror Breaker; Prime Speaker Zegana; Alesha, Who Smiles at Death; Daxos the Returned; Mazirek, Kraul Death Priest; Patron of the Moonfolk; Animar, Soul of Elements
I appreciate what you did for your spoiler, but there's one little hitch for trying to put all the abilities on one line. A perfect example is Warp World. Trying to fit the Oracle or card text of that card on one line is next to impossible. Granted, this isn't the case with all cards, or even most of them, but you're going to need to assume at least two lines for abilities. Fortunately, with Lorwyn, for the most part the biggest reason for carrying an ability over to the second line is the reminder text for Clash.
That being said, I like the idea of having a separate field for subtypes. I changed P/T to Size for one reason: to account for Planeswalkers as well. Otherwise, I would have gone with P/T and easily could have made that two fields.
One other thing I could add would be a column for the CMC of a card. I have a formula I came up with that would figure it out (it would have been simpler in a programming structure, but setting it up as an Excel formula is a pain..!!) and it accounts for just about everything including things like Decree of Justice (probably the most complex mana cost in the game) and Lands (which it lists as such instead of giving CMC 0). I can toss it up here if anyone is interested. It's long but effective.
To everyone who took the time to make additional versions of printable spoilers, thanks! They all have their uses, strengths, weaknesses, etc.
Please re-read the card you mentioned ...
WUBRGWBGURW
UBRGWURWBGU
BRGWUBGURWB
RGWUBRWBGUR
GWUBRGURWBG
Props to Kaldare for the ideas (I haven't seen his spreadsheet, but went by his descriptions). Hope it's useful
Very impressive Orange Mage. Your spoiler won my vote and the rights to my printer