Dear esteemed fellow forumners,

Since our counterpart, the illustrious, yet MysteriousMrP announced that he will no longer be updating his fabulous planner for Magic Duels Origins , many of us have been left wanting for a tool we can use to share our decks with everyone.

Being a spreadsheet junkie , I have been using Excel to create and analyse my decks since Magic 2015 and for Magic Duels Origins, I thought to give Google Sheets a try. I have developed it to a point where I thought I may be worthwhile to share with everyone. I will continue to update this as long as I'm playing the game.

Please feel free to make yourselves a copy of the file on this link
I've included a few sample decks for your reference to see how it works. Please make sure it is version 3.0.06
I have received a few requests to share edit rights to the file. Unfortunately, how G! Sheets works is that you need to make a copy yourself and you'll get full edit rights. Unlike the original javascript (or any other app), G! Sheets does not create a separate instance for every individual accessing, so opening up to everyone just means no-one can use it.

I've created a guide in first tab to give a run through on how to use this file. Kudos to Auunj for starting on that.

Posting to the Forum
in Cell B69, you can select 3 options in how you want to post to the forum: (by Type), (by CMC) or (by Color)

When you copy and paste cell D62 into the forum, they will be in quote marks "" and have a chunk of blank space at the bottom which you'd need to manually remove, otherwise, it is very easy and straightforward. I'm still trying to figure out why they appear.







I've pretty much copied the marvelous magic that MysteriousMrP created and at this moment, grouping by purpose, rarity is not yet available. These are not commonly used, so have no intention of adding these yet.

That's it for now . If you do try the tool, please let me know if you spot any bugs or errors so that I can work on them when I have the time.

Edits
14 Aug 2015: Changed link for version 1.7.03; added new tables [NGA (by type), NGA (by CMC), NGA (by Color)] available in ver. 1.7.03; some other minor edits
15 Aug 2015: Updated link for version 1.7.05 which fixed autocard issues for flipwalkers and Artificer's Epiphany
16 Aug 2015: Updated version 1.7.06, which fixed sorting of cards, minor edits
18 Aug 2015: Updated version 1.7.08, with random color scheme and other minor fixes
19 Aug 2015: Corrected typo and added clarification on sharing
11 Sep 2015: Updated version 1.7.09 with new features and bug fixes
05 Dec 2015: Updated version 2 with BFZ cards and bug fixes. Removed Simple tables and Sortable tables as no longer supported. Removed guide as it's now included in Sheets
08 Apr 2016: Updated to version 3.0.06 with OGW and SOI cards included.
16 Jul 2016: UPdated to EMN release

Kudos mate. Looks decent and I appreciate your effort and initiative.

Nicely done.

We definitely need a planner. There was another thread going at one point to make one but I have no idea what's been happening there so it's great to have access to something like this.

Having said that, I don't seem to be able to use any of the filters etc. Either I'm missing something/ doing something incorrectly or it's locked/view only and won't allow me to make selections.


elk

Elk,

I've locked the sheet to prevent tampering. To use it, you'd need to go to "Files", "Make a Copy..."

Once you've made a copy. you'll be free to do whatever changes you want and would not affect the original.

Version 1.7.01 is live and will be up once I updated the original post. It will feature the original decklist bbcode:

""

cheers

Ooooooooh this is gonna be great! Good job man!

Well I'll be damned.

Ladies and Gentlemen,

At long last! The original post has been updated to the new link for version 1.7.01.

Please make sure to make a new copy and take advantage of the new, delicious NGA tables!

yours humbly

Awesome. And now for the entitled post of the year: please make a good looking one sorted by color. This is the way the deck planner in game sorts the decks. It's the easiest way for people to remake a list. Also,

Seriously, sorry for even asking, but could you do that too?

I heart anthonli

Is he Italian? Is he Asian? Who cares, he's awesome

Thanks guy

It's easier than I thought, managed to do it up today while waiting for a meeting to start. Hope it's not setting an awful precedent
Some cards are not showing properly on autocard. The spelling's right. Can someone help with this?



Already updated opening post with new link: https://docs.google.com/spreadsheets/d/1EWnnzAIFuQk20aYJZEz8lBn8weG27PI6hCv2OHGxVXs/edit?usp=sharing

Wow, really cool. Good job, man.

interesting that lnd gets listed as a zero mana spell but otherwise seems great

I see one typo already fiery conclussion should be fiery conclusion it's a simple error. I also don't think it recognizes Jace, Vryn's Prodigy / Jace, Telepath Unbound because each card has it's own entry in gatherer which is where the autocard gets the image from. I don't know how to get around that. You may need to stick with Jace, Vryn's Prodigy or Jace, Telepath Unbound.

Still, this looks great so far. Keep it up.

Thanks Mystic!

Have fixed spelling for fiery conclusion, also fixed issue for flipwalkers and Artificer's Epiphany. Also fixed issue where lands showing as costed spells, now show :Land: instead as it rightfully should.

For flipwalkers, the bbcode does not allow showing both cards in the same row, so used the front face instead.

Let me know if more cards not showing properly.

Updated original post with new deck planner url: https://docs.google.com/spreadsheets/d/1lfNrZ-GCzq5e5FNeEO_k3Hc8o4UEq0EdWep_EhiPl6A/edit?usp=sharing

Not a real deck below, adding Kytheon to show how other flipwalkers will be displayed.

hmm small critisicm but is it possible to move the mana base down a line so the planner doesn't get so wide?

It's too fat!!

like this?

Nice! The new Tracey Gold version! Love it

Absolutely awesome! That is a work of frakking art!

I have two humble suggestions/requests to submit for your consideration:

1) Manually tweaking the RGB values that determine the background and card highlighting results in some really nice variations on the colors; any chance of incorporating this into the sheet (even just as RGB fields we can fill in)?


2) Would it be possible to add an optional subtitle beneath the main title, with a font size and format somewhere between the main title and the "A deck for Magic Duels" line? It would allow weird people like me who enjoy naming their decks to include some useful information Perhaps something like:

Somnomancy
Aura Lockdown Control
A deck for Magic Duels

Again---absolutely floored at how gorgeous that planner is. Awesome work, and thanks for all your effort!