No Goblins Allowed
http://862838.jrbdt8wd.asia/

Deck Planner in G! Sheets
http://862838.jrbdt8wd.asia/viewtopic.php?f=38&t=11069		 Page 1 of 5
Author:  anthonli [ Wed Aug 12, 2015 1:46 am ]
Post subject:  Deck Planner in G! Sheets
Dear esteemed fellow forumners, :cool:

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

Being a spreadsheet junkie :blush:, 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 :teach:
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.

Open to see what (by Type) looks like


Open to see what (by CMC) looks like


Open to see what (by Color) looks like


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
Author:  Insert_Witty_Name [ Wed Aug 12, 2015 2:30 am ]
Post subject:  Re: Deck Planner in G! Sheets
Kudos mate. Looks decent and I appreciate your effort and initiative.
Author:  zzmorg82 [ Wed Aug 12, 2015 6:23 am ]
Post subject:  Re: Deck Planner in G! Sheets
Nicely done.
Author:  elk [ Wed Aug 12, 2015 1:38 pm ]
Post subject:  Re: Deck Planner in G! Sheets
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
Author:  anthonli [ Thu Aug 13, 2015 4:54 pm ]
Post subject:  Re: Deck Planner in G! Sheets
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:

"
ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters

A deck for Magic Duels.

60 Cards. 39 nonlands (23 :creature:, 16 :instant:). 21 :land: (4 7 ; 10 other).

Creature23 cards
■		Jace, Vryn’s Prodigy / Jace, Telepath Unbound0/2
■■		Abbot of Keral Keep2/1
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Thopter Engineer1/3
■■■		Chief of the Foundry2/3
■■■		Whirler Rogue2/2
■■		Pia and Kiran Nalaar2/2
■■■		Reclusive Artificer2/3
Spell16 cards
■■■■		Fiery Impulse
■■■		Fiery Conclussion
■■■■		Twin Bolt
■■■■		Artificer’s Epiphany
■■		Exquisite Firecraft
■■		Thopter Spy Network
Land21 cards
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
■■■■		Izzet Guildgate
■■		Sulfur Falls
4		Island
7		Mountain

"

cheers
Author:  DJ0045 [ Thu Aug 13, 2015 4:58 pm ]
Post subject:  Re: Deck Planner in G! Sheets
Ooooooooh this is gonna be great! Good job man!
Author:  Hakeem928 [ Thu Aug 13, 2015 5:03 pm ]
Post subject:  Re: Deck Planner in G! Sheets
Well I'll be damned.
Author:  anthonli [ Thu Aug 13, 2015 5:08 pm ]
Post subject:  Re: Deck Planner in G! Sheets
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
Author:  DJ0045 [ Thu Aug 13, 2015 5:13 pm ]
Post subject:  Re: Deck Planner in G! Sheets
anthonli wrote:
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, :P

Seriously, sorry for even asking, but could you do that too?
Author:  Black Barney [ Thu Aug 13, 2015 6:25 pm ]
Post subject:  Re: Deck Planner in G! Sheets
I heart anthonli

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

Thanks guy
Author:  anthonli [ Thu Aug 13, 2015 6:32 pm ]
Post subject:  Re: Deck Planner in G! Sheets
DJ0045 wrote:
anthonli wrote:
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, :P

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


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 :wha:
Some cards are not showing properly on autocard. The spelling's right. Can someone help with this?

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters

A deck for Magic Duels.

60 Cards. 39 nonlands (23 :creature:, 16 :instant:). 21 :land: (4 7 ; 10 other).

Color 8 cards
■		Jace, Vryn’s Prodigy / Jace, Telepath Unbound0/2
■■■■		Artificer’s Epiphany
■■■		Whirler Rogue2/2
■■		Thopter Spy Network
Color 18 cards
■■■■		Fiery Impulse
■■		Abbot of Keral Keep2/1
■■■		Fiery Conclussion
■■■■		Twin Bolt
■■■		Thopter Engineer1/3
■■		Exquisite Firecraft
■■		Pia and Kiran Nalaar2/2
Multicolored3 cards
■■■		Reclusive Artificer2/3
Colorless10 cards
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Chief of the Foundry2/3
Land21 cards
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
■■■■		Izzet Guildgate
■■		Sulfur Falls
4		Island
7		Mountain

this deck is generated by anthonli deck planner in Google Sheets. (Learn more)



Already updated opening post with new link: https://docs.google.com/spreadsheets/d/1EWnnzAIFuQk20aYJZEz8lBn8weG27PI6hCv2OHGxVXs/edit?usp=sharing
Author:  julianwelton [ Fri Aug 14, 2015 2:20 am ]
Post subject:  Re: Deck Planner in G! Sheets
anthonli wrote:
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:

"
ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters

A deck for Magic Duels.

60 Cards. 39 nonlands (23 :creature:, 16 :instant:). 21 :land: (4 7 ; 10 other).

Creature23 cards
■		Jace, Vryn’s Prodigy / Jace, Telepath Unbound0/2
■■		Abbot of Keral Keep2/1
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Thopter Engineer1/3
■■■		Chief of the Foundry2/3
■■■		Whirler Rogue2/2
■■		Pia and Kiran Nalaar2/2
■■■		Reclusive Artificer2/3
Spell16 cards
■■■■		Fiery Impulse
■■■		Fiery Conclussion
■■■■		Twin Bolt
■■■■		Artificer’s Epiphany
■■		Exquisite Firecraft
■■		Thopter Spy Network
Land21 cards
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
■■■■		Izzet Guildgate
■■		Sulfur Falls
4		Island
7		Mountain

"

cheers
Wow, really cool. Good job, man.
Author:  babassoonist [ Fri Aug 14, 2015 7:40 am ]
Post subject:  Re: Deck Planner in G! Sheets
interesting that lnd gets listed as a zero mana spell but otherwise seems great
Author:  Rattleclaw_mystic [ Fri Aug 14, 2015 10:31 am ]
Post subject:  Re: Deck Planner in G! Sheets
anthonli wrote:
Some cards are not showing properly on autocard. The spelling's right. Can someone help with this?


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. :D
Author:  anthonli [ Sat Aug 15, 2015 12:51 am ]
Post subject:  Re: Deck Planner in G! Sheets
Rattleclaw_mystic wrote:

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.


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.

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters

A deck for Magic Duels.

69 Cards. 40 nonlands (24 :creature:, 16 :instant:). 29 :land: (4 7 8 ; 10 other).

Color 1 cards
■		Kytheon, Hero of Akros2/1
Color 8 cards
■		Jace, Vryn's Prodigy0/2
■■■■		Artificer's Epiphany
■■■		Whirler Rogue2/2
■■		Thopter Spy Network
Color 18 cards
■■■■		Fiery Impulse
■■		Abbot of Keral Keep2/1
■■■		Fiery Conclusion
■■■■		Twin Bolt
■■■		Thopter Engineer1/3
■■		Exquisite Firecraft
■■		Pia and Kiran Nalaar2/2
Multicolored3 cards
■■■		Reclusive Artificer2/3
Colorless10 cards
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Chief of the Foundry2/3
Land29 cards
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
■■■■		Izzet Guildgate
■■		Sulfur Falls
4		Island
7		Mountain
8		Forest

this deck is generated by anthonli deck planner in Google Sheets. (Learn more)
Author:  babassoonist [ Sun Aug 16, 2015 7:21 pm ]
Post subject:  Re: Deck Planner in G! Sheets
hmm small critisicm but is it possible to move the mana base down a line so the planner doesn't get so wide?
Author:  Black Barney [ Mon Aug 17, 2015 6:48 am ]
Post subject:  Re: Deck Planner in G! Sheets
It's too fat!!
Author:  anthonli [ Mon Aug 17, 2015 1:36 pm ]
Post subject:  Re: Deck Planner in G! Sheets
like this?

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters

A deck for Magic Duels.

60 Cards. 39 nonlands (23 :creature:, 16 :instant:).
21 :land: (6 7 ; 8 other).

Color 12 cards
■■■■		Faerie Miscreant1/1
■		Jace, Vryn's Prodigy0/2
■■■■		Artificer's Epiphany
■■■		Whirler Rogue2/2
■■		Thopter Spy Network
Color 17 cards
■■■■		Fiery Impulse
■■■		Fiery Conclusion
■■■■		Twin Bolt
■		Chandra, Fire of Kaladesh2/2
■■■		Thopter Engineer1/3
■■		Exquisite Firecraft
■■		Pia and Kiran Nalaar2/2
Colorless10 cards
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Chief of the Foundry2/3
Land21 cards
■■■■		Izzet Guildgate
■■		Sulfur Falls
■■■		Foundry of the Consuls
6		Island
7		Mountain

this deck is generated by anthonli deck planner in Google Sheets. (Learn more)
Author:  Black Barney [ Mon Aug 17, 2015 3:03 pm ]
Post subject:  Re: Deck Planner in G! Sheets
Nice! The new Tracey Gold version! Love it
Author:  Eunomiac [ Mon Aug 17, 2015 4:21 pm ]
Post subject:  Re: Deck Planner in G! Sheets
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)?
Example


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!
Page 1 of 5 All times are UTC - 6 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/