It is currently Thu Nov 28, 2024 5:36 am

Board index » Magic: The Gathering » Magic Duels

All times are UTC - 6 hours [ DST ]



Post new topic Reply to topic  Page 2 of 5
  [ 82 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next
  Print view Previous topic | Next topic | Search this topic 
Author Message
babassoonist
PostPosted: Mon Aug 17, 2015 4:23 pm 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4303
anthonli wrote:
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)




yup thats perfect


Like this post
Top
 Profile  
 
anthonli
PostPosted: Tue Aug 18, 2015 12:32 am 
Offline
Member

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


(2) is easy. Have done it up as below. It is linked to the Color / Archetype description (Cell G3), so you can fill that in and it will update automatically as below.

(1) is a lot more difficult as I'm not familiar with the bbcode for RGB. Currently, I just copied the code by MysteriousMrP, I only know that it is linked to the current date and time, as well as the name of the deck. So changing the name of the deck (how you spell, or even the spaces) will result in changes to the color scheme.

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Izzet Thopters
UR - Izzet / Disruption

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)



Like this post
Top
 Profile  
 
Eunomiac
PostPosted: Tue Aug 18, 2015 2:23 am 
Offline
Member
User avatar

Joined: Mar 31, 2014
Posts: 7
Location: Toronto, Canada
Beautiful! (And I agree, the "thinner" display really tightens things up, t'was a good suggestion :) )

As for the color changes, the BBCode changes are trivial, but I'm not sure how limited you are in editing the "magic cell" we use to cut&paste from---hypothetically, if I gave you three cells and pointed to exactly where they should replace the numbers in the Google Docs cut&paste cell, could you push them in?

_________________
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  
 
anthonli
PostPosted: Tue Aug 18, 2015 3:25 am 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
Eunomiac wrote:
Beautiful! (And I agree, the "thinner" display really tightens things up, t'was a good suggestion :) )

As for the color changes, the BBCode changes are trivial, but I'm not sure how limited you are in editing the "magic cell" we use to cut&paste from---hypothetically, if I gave you three cells and pointed to exactly where they should replace the numbers in the Google Docs cut&paste cell, could you push them in?


I've created 3 cells for color scheme which you can change and added notes for table, odd rows and even rows, so you know what you are changing.

For those who are adventurous, they can leave the color scheme to the RNG goddesses, which is the default, and for the experts like yourself, you can manually change the color scheme:

Updated the link in OP with new version below
https://docs.google.com/spreadsheets/d/1ssdyb36j98f00GMv8FhsaT36hx7pB7KzmmG3pMWyG1w/edit?usp=sharing

This is what the RNG color version looks like. If you don't like the color scheme, just keep recalculating.

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Thopters
- Izzet / Disruption

A deck for Magic Duels.

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

Cost 8 cards
■■■■		Faerie Miscreant1/1
■■■■		Fiery Impulse
Cost 13 cards
■		Jace, Vryn's Prodigy0/2
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Fiery Conclusion
■■■■		Twin Bolt
Cost 12 cards
■		Chandra, Fire of Kaladesh2/2
■■■		Thopter Engineer1/3
■■■		Chief of the Foundry2/3
■■■■		Artificer's Epiphany
■■		Exquisite Firecraft
Cost 6 cards
■■■		Whirler Rogue2/2
■■		Pia and Kiran Nalaar2/2
■■		Thopter Spy Network
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)



Like this post
Top
 Profile  
 
anthonli
PostPosted: Thu Sep 10, 2015 10:01 pm 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
Giving myself a shameless bump.

I've updated the Original post to Planner version 1.7.09.5

For convenience, here's the link

Squashed a few bugs, added some fancy shmancy stuff, nothing major. The Random Colour Scheme is now based on your devotion, so if you have a 3 colour deck, it'll look something like this:
ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Jeskai Thopters in Akros
- Jeskai / Mid Range

A deck for Magic Duels.

60 Cards. 34 nonlands (19 :creature:, 15 :instant:).
26 :land: (1 7 5 ; 13 other).

Creature19 cards
■■■■		Perilous Myr1/1
■■■		Runed Servitor2/2
■■■		Esperzoa4/3
■■■		Thopter Engineer1/3
■■■		Chief of the Foundry2/3
■■		Pia and Kiran Nalaar2/2
■■■		Thunderclap Wyvern2/3
■■		Soulblade Djinn4/3
Spell15 cards
■■■■		Fiery Impulse
■■■		Telling Time
■■■■		Alchemist's Vial
■■■		Valor In Akros
■■		Thopter Spy Network
Land26 cards
■■		Clifftop Retreat
■■		Glacial Fortress
■■		Sulfur Falls
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
1		Plain
7		Island
5		Mountain

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



A 2 colour deck will look like:
ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Golgari Evoleap
- Golgari / Mid Range

A deck for Magic Duels.

60 Cards. 35 nonlands (26 :creature:, 9 :instant:).
25 :land: (11 7 ; 7 other).

Creature26 cards
■■		Despoiler of Souls3/1
■■■		Dwynen's Elite2/2
■■■■		Elvish Visionary1/1
■■■■		Perilous Myr1/1
■		Liliana, Heretical Healer2/3
■■■■		Deadbridge Shaman3/1
■■■		Fleshbag Marauder3/1
■		Nissa, Vastwood Seer2/2
■■■		Shaman of the Pack3/2
■■		Gilt-Leaf Winnower4/3
■■		Priest of the Blood Rite2/2
Spell9 cards
■■■		Shadows of the Past
■■		Evolutionary Leap
■■■		Elemental Bond
■■■■		Wildsize
Land25 cards
■■■■		Golgari Guildgate
■■		Woodland Cemetery
■■■		Foundry of the Consuls
11		Swamp
7		Forest

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



Mono-coloured deck will be like:
ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

W Weenies
Mono- / Disruption

A deck for Magic Duels.

60 Cards. 38 nonlands (28 :creature:, 10 :instant:).
22 :land: (14 1 ; 7 other).

Creature28 cards
■■■		Anointer of Champions1/1
■■■		Elite Vanguard2/1
■		Kytheon, Hero of Akros2/1
■■■■		Suntail Hawk1/1
■■■		Consul's Lieutenant2/2
■■		Knight of the White Orchid2/2
■■■		Dauntless River Marshal2/1
■■■■		Kinsbaile Skirmisher2/2
■■		Relic Seeker2/2
■■■■		Topan Freeblade2/2
Spell10 cards
■■■■		Celestial Flare
■■■■		Grasp of the Hieromancer
■■■		Reprisal
■■■■		Kytheon's Tactics
■■■■		Strider Harness
Land22 cards
■■■■		Evolving Wilds
■■■		Foundry of the Consuls
■■■		Rogue's Passage
14		Plain
1		Island

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



Next update is when the new cards for BFZ expansion is available.


Last edited by anthonli on Fri Sep 11, 2015 5:06 am, edited 1 time in total.

Like this post
Top
 Profile  
 
babassoonist
PostPosted: Fri Sep 11, 2015 4:11 am 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4303
*adds planer to bookmarks*


Like this post
Top
 Profile  
 
licker
PostPosted: Fri Sep 11, 2015 9:05 pm 
Offline
Member
User avatar

Joined: Aug 10, 2015
Posts: 227
Hopefully this is a question with an obvious answer...

How do I update versions? Do I need to cut and paste my decks from an older version to the new one?


Like this post
Top
 Profile  
 
anthonli
PostPosted: Sat Sep 12, 2015 12:08 am 
Offline
Member

Joined: Sep 14, 2014
Posts: 41
licker wrote:
Hopefully this is a question with an obvious answer...

How do I update versions? Do I need to cut and paste my decks from an older version to the new one?


Unfortunately, yes. You need to copy and paste from the older version to the new one. :blush:

Doesn't help that the more tabs you have, the slower it becomes. :cry:

There isn't really a way to fix this because of the limitations of G! Sheets. If anyone has ideas to improve this like a script or something, I'll happily try it.


Like this post
Top
 Profile  
 
licker
PostPosted: Sat Sep 12, 2015 11:07 am 
Offline
Member
User avatar

Joined: Aug 10, 2015
Posts: 227
That's ok anthonli, your efforts are much appreciated :)


Like this post
Top
 Profile  
 
Black Barney
PostPosted: Sat Sep 12, 2015 5:31 pm 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 17748
Location: Montreal, Quebec, Canada
babassoonist wrote:
*adds planer to bookmarks*


You should also bookmark an online dictionary.


Like this post
Top
 Profile  
 
babassoonist
PostPosted: Sat Sep 12, 2015 6:05 pm 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4303
well sorry English is my second language :(


Like this post
Top
 Profile  
 
Black Barney
PostPosted: Sat Sep 12, 2015 6:58 pm 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 17748
Location: Montreal, Quebec, Canada
Ah nuts, now I sound like a jerk. Your English has been so flawless until now that I assumed you were anglophone.

I've brought dishonour to my house...
Time for Barney to try seppuku :(


Like this post
Top
 Profile  
 
Hakeem928
PostPosted: Sat Sep 12, 2015 7:06 pm 
Offline
Member
User avatar

Joined: Oct 31, 2013
Posts: 7350
Location: Newfoundland
There is no try. Do or do not.

_________________
Check me out on YouTube


Like this post
Top
 Profile  
 
Black Barney
PostPosted: Sat Sep 12, 2015 7:20 pm 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 17748
Location: Montreal, Quebec, Canada
Well I seem to have overcooked my innards. Made me wanna kill myself


Like this post
Top
 Profile  
 
babassoonist
PostPosted: Sat Sep 12, 2015 7:47 pm 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4303
heh it's okay barney I might as well be a natural english speaker :p lived in the US since I was 2 but didn't learn english till grade school (well anything that could be recognized as english I'm told that when we were 5 my brother and I spoke a weird mix of german, japanese, and english)


Like this post
Top
 Profile  
 
Auunj
PostPosted: Fri Sep 18, 2015 3:15 am 
Offline
Member
User avatar

Joined: Nov 09, 2013
Posts: 1648
Location: Wroclaw, Poland
Anthonli, as an everyday excel user I have to admit, that this spreadsheet is a work of art!:-)

Things I'd modify/add:
Remove a [/plB] before the spell list (seems like a leftover code)
Check if [a] isn't greater than avail. so you can't add fe. 4 Thopter Spy Networks or at least get an error or something.
Move the sum of cards added from the bottom to the top, so you can follow it all the time while theorycrafting a deck in the sheet.


Like this post
Top
 Profile  
 
-DarkShock-
PostPosted: Fri Sep 18, 2015 4:42 am 
Offline
Member
User avatar

Joined: Jan 30, 2015
Posts: 901
Location: London, England
Wow will def. check this badboy out when I get home, great work dude!

_________________
DARKSHOCK'S DUNGEON - http://forum.nogoblinsallowed.com/viewtopic.php?f=61&t=14407


Like this post
Top
 Profile  
 
Auunj
PostPosted: Mon Sep 21, 2015 3:08 am 
Offline
Member
User avatar

Joined: Nov 09, 2013
Posts: 1648
Location: Wroclaw, Poland
Why aren't people using the deck planner? Is it too complicated? Or is it laziness? I think that it's a magnificent tool.


Like this post
Top
 Profile  
 
babassoonist
PostPosted: Mon Sep 21, 2015 3:52 am 
Offline
Member
User avatar

Joined: Feb 13, 2015
Posts: 4303
haven't posted a deck in a while that's why :)

waiting for B4Z


Like this post
Top
 Profile  
 
licker
PostPosted: Mon Sep 21, 2015 9:41 am 
Offline
Member
User avatar

Joined: Aug 10, 2015
Posts: 227
Auunj wrote:
Why aren't people using the deck planner? Is it too complicated? Or is it laziness? I think that it's a magnificent tool.


I use it for my own decks.

For the tournament I'm just copying and pasting others stuff though, so I don't get the nice formatting.


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

Board index » Magic: The Gathering » Magic Duels

All times are UTC - 6 hours [ DST ]

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:  
Powered by phpBB® Forum Software © phpBB Group