It is currently Tue Aug 14, 2018 6:55 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 82 posts ]  Go to page 1, 2, 3, 4, 5  Next
Author Message
PostPosted: Wed Aug 12, 2015 1:46 am 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
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


Last edited by anthonli on Sat Jul 16, 2016 6:41 am, edited 11 times in total.

Like this post
Top
 Profile  
 
PostPosted: Wed Aug 12, 2015 2:30 am 
Offline
Member
User avatar

Joined: Nov 12, 2013
Posts: 1292
Kudos mate. Looks decent and I appreciate your effort and initiative.

_________________
Who needs good grades when you got SWAG?!?!


Like this post
Top
 Profile  
 
PostPosted: Wed Aug 12, 2015 6:23 am 
Offline
Member
User avatar

Joined: May 05, 2015
Posts: 2820
Location: zz
Identity: Nah.
Preferred Pronoun Set: ---
Nicely done.

_________________
GameCenter ID: zzmorg82_

Link to my smilies: https://imgur.com/a/HJMsX


Like this post
Top
 Profile  
 
PostPosted: Wed Aug 12, 2015 1:38 pm 
Offline
Member
User avatar

Joined: Jul 19, 2014
Posts: 1267
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

_________________
oh SHUT UP ELK


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 4:54 pm 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
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


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 4:58 pm 
Offline
Member
User avatar

Joined: Sep 06, 2014
Posts: 5975
Identity: ItsreallyDJ0045
Preferred Pronoun Set: I'm male, lol!
Ooooooooh this is gonna be great! Good job man!


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 5:03 pm 
Offline
Member
User avatar

Joined: Oct 31, 2013
Posts: 7344
Location: Newfoundland
Well I'll be damned.

_________________
Check me out on YouTube


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 5:08 pm 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
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


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 5:13 pm 
Offline
Member
User avatar

Joined: Sep 06, 2014
Posts: 5975
Identity: ItsreallyDJ0045
Preferred Pronoun Set: I'm male, lol!
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?


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 6:25 pm 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 9652
Location: Montreal, Quebec, Canada
I heart anthonli

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

Thanks guy

_________________
DCG-MTG wrote:
There's a limited amount of fun to be had in a single game, and this deck will ensure no one has any of it.


Like this post
Top
 Profile  
 
PostPosted: Thu Aug 13, 2015 6:32 pm 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
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


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


Last edited by anthonli on Fri Aug 14, 2015 5:09 am, edited 1 time in total.

Like this post
Top
 Profile  
 
PostPosted: Fri Aug 14, 2015 2:20 am 
Offline
Member
User avatar

Joined: Jul 12, 2015
Posts: 171
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.


Like this post
Top
 Profile  
 
PostPosted: Fri Aug 14, 2015 7:40 am 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4299
interesting that lnd gets listed as a zero mana spell but otherwise seems great


Like this post
Top
 Profile  
 
PostPosted: Fri Aug 14, 2015 10:31 am 
Offline
Member
User avatar

Joined: Jul 08, 2015
Posts: 203
Identity: Male
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

_________________
Steam handle: Rattleclaw_mystic


Like this post
Top
 Profile  
 
PostPosted: Sat Aug 15, 2015 12:51 am 
Offline
Member

Joined: Sep 14, 2014
Posts: 41

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


Like this post
Top
 Profile  
 
PostPosted: Sun Aug 16, 2015 7:21 pm 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4299
hmm small critisicm but is it possible to move the mana base down a line so the planner doesn't get so wide?


Like this post
Top
 Profile  
 
PostPosted: Mon Aug 17, 2015 6:48 am 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 9652
Location: Montreal, Quebec, Canada
It's too fat!!

_________________
DCG-MTG wrote:
There's a limited amount of fun to be had in a single game, and this deck will ensure no one has any of it.


Like this post
Top
 Profile  
 
PostPosted: Mon Aug 17, 2015 1:36 pm 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
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


Like this post
Top
 Profile  
 
PostPosted: Mon Aug 17, 2015 3:03 pm 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 9652
Location: Montreal, Quebec, Canada
Nice! The new Tracey Gold version! Love it

_________________
DCG-MTG wrote:
There's a limited amount of fun to be had in a single game, and this deck will ensure no one has any of it.


Like this post
Top
 Profile  
 
PostPosted: Mon Aug 17, 2015 4:21 pm 
Offline
Member
User avatar

Joined: Mar 31, 2014
Posts: 7
Location: Toronto, Canada
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!

_________________
Amateur dinosaur hunter and extreme weather enthusiast, whose interests include: spoken mime, armchair parkour, tactical gaslighting (for fun or for pay), conspicuous ninjutsu and Schröedinger's pentameter—of which this sentence may or may not be an example.


Like this post
Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 82 posts ]  Go to page 1, 2, 3, 4, 5  Next

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group