Deck Planner in G! Sheets

Board index » Magic: The Gathering » Magic Duels

All times are UTC - 6 hours [ DST ]

Moderators: GobO_Mastergear, GobO_Kheldar, GobO_Stasis

Page 4 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

Troklo

Post subject: Re: Deck Planner in G! Sheets

Posted: Mon Dec 07, 2015 5:51 am

Member

Joined: Feb 25, 2015
Posts: 40

Hi! I sent you a private message with a link to the gsheet. Hope you can help me out.

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Wed Dec 09, 2015 8:53 pm

Member

Joined: Sep 14, 2014
Posts: 41

Hi Troklo, I've sent you a pm and "fixed" your file. :fixed:

Seems like a problem with G Sheets which doesn't recognise empty cells in column B. I've simply tricked it by filling in all empty card slots with 0 cards and it did the magic. :huh:

After that, when I removed the zeroes, the file went back to normal again.

I'm posting this here in case others face the same problem and need a fix. :teach:

Thanks for raising this and let me know if you face other problems.

BFZ is releasing on iOS soon and I can't wait!!! :excite:

Top

Troklo

Post subject: Re: Deck Planner in G! Sheets

Posted: Thu Dec 10, 2015 1:29 am

Member

Joined: Feb 25, 2015
Posts: 40

you sir rock!

Top

snwkill

Post subject: Re: Deck Planner in G! Sheets

Posted: Fri Dec 11, 2015 12:02 pm

Member

Joined: Nov 22, 2015
Posts: 2

anthonli wrote:

snwkill wrote:

I really am liking your tool. My only suggestion would to have a colour icon starting at J11:JXX, I know you can do your initial search by color but if I want to start a deck from scratch and want to base it on lifelink it would be nice to know immediately what colors offer me the most lifelink cards.

Since you already have the color listed on the Card List tab you could do something like the following in cell J11

=vlookup(F26, 'Card List'!$A:$B,2,False)

That or even do it in a hidden cell and just change the font &/or cell colour of K11:KXX via conditional formatting that way you know as soon as you do you your search you can see which cards are which.

Here is an example, I did the vlookup in column V and then did a conditional format of K11:K80, I just did formatting for U and B for testing I left the conditional format window open. Not sure what to do about multi color cards though.

Hi snwkill! Thanks a lot for the feedback. You make it look easy to do, I'm adding it to my to-dos. :hand:

Unfortunately, I'm very busy with work these days and whatever free time not with my kids is spent coding the cards for BFZ now that they are out. :cry:

Please be patient! :blush:

Not an issue at all, these types of things are done with nothing but passion for the game and spreadsheets. :thumbsup:

Top

chile125

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Dec 27, 2015 4:38 pm

Member

Joined: Sep 29, 2015
Posts: 156

I keep getting this error.

Did not find value '8' in
VLOOKUP evaluation.

Anyone else getting this error?

EDIT:

Troklo wrote:

Hey man thanks for your work really appreciate it

I'm trying to post I deck I made using your planner but when I copy the box to be posted to NGA it doesn't seem to translate well over to the forum.

Look:

"

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Orzhov Life Gain
Life gain control

A deck for Magic Duels.

60 Cards. 36 nonlands (17 :creature: , 19 :instant: ).
24 :land: (8

Land24 cards
	8	Plain
			Island
			8	Swamp
					Mountain
						Forest

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

"
Any Idea what I'm doing wrong?

Thanks once again for you hard work

ok, this is the same error I got ^^^ (or the result of said error)

_________________

Hakeem928 wrote:

Never tell a hungry person that you're yummy.

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Dec 27, 2015 6:39 pm

Member

Joined: Sep 14, 2014
Posts: 41

chile125 wrote:

I keep getting this error.

Did not find value '8' in
VLOOKUP evaluation.

Anyone else getting this error?

EDIT:

ok, this is the same error I got ^^^ (or the result of said error)

Try this:
Fill in all number of cards with 0, even for those where card name is blank.
Once done, the bbcode should work properly
Then you can remove all the zeros

If it's still not working, you can share your sheet with me and I'll help take a look

Top

hao

Post subject: Re: Deck Planner in G! Sheets

Posted: Wed Dec 30, 2015 6:04 am

Member

Joined: Dec 30, 2015
Posts: 16

Hello the link you posted only connects you to the "Step by Step Guide to using Magic Duels Deck Planner" and i can not find the excel table

Either i am stupid in finding the table inside the sheet or you gave a wrong link

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Thu Dec 31, 2015 10:49 am

Member

Joined: Sep 14, 2014
Posts: 41

hao wrote:

Hi Hao,

The link is here: https://docs.google.com/spreadsheets/d/1xsvKNKffAnlDSYFZdHfr0zgycVujhwhLKGBq47obmOo/edit?usp=sharing

This should bring you to Google Sheets. Follow the step-by-step guide to copy the file into a separate one that you'll own. At the bottom of the sheet, you'll see a "Deck" with a lock icon. Click on that and it'll bring you to the excel table. :teach:

Hope that helps. Let me know if you still run into issues.

Top

stahlster

Post subject: Re: Deck Planner in G! Sheets

Posted: Wed Mar 23, 2016 10:48 am

Member

Joined: Nov 18, 2013
Posts: 106

Hey there...trying to post my first decklist and I am getting the same error as some above...I tried the 0 thing and it didn't change it. Here is what it looks like

"

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Simic Mill
Control

A deck for Magic Duels.

60 Cards. 36 nonlands (13 :creature: , 23 :instant: ).
24 :land: (9 5 10 Others)

Land24 cards
	9	Island
		5	Forest

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

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Apr 03, 2016 3:43 am

Member

Joined: Sep 14, 2014
Posts: 41

stahlster wrote:

Hey there...trying to post my first decklist and I am getting the same error as some above...I tried the 0 thing and it didn't change it. Here is what it looks like

Hi Stahlster, sorry for my late reply.

There seems to be a bug which is breaking the bbcode generator. It's bad enough that I'm recreating the sheet again from ground up.

I suggest waiting for my next release after SOI, which will have all the new cards included as well.

Thanks for your patience and I'll keep you updated

Top

stahlster

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Apr 03, 2016 7:23 pm

Member

Joined: Nov 18, 2013
Posts: 106

Thanks, looking forward to it

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Thu Apr 07, 2016 11:13 pm

Member

Joined: Sep 14, 2014
Posts: 41

OGW and SOI cards are now included and Version 3 is alive!

Please feel free to make yourselves a copy of the file on this link

I've fixed the bug that's causing the problem where the bbcode is not generated properly. If you spot any further bugs or issues, do let me know. Hopefully, I'll have less problems than the game itself. :sweat:

I've also updated the opening post here.

A preview of what the decklist looks like in the forum:

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

WU Spirited

A deck for Magic Duels.

60 Cards. 35 nonlands (22 :creature: , 13 :instant: ).
25 :land: (8 6 11 Others)

Creature22 cards

■■■

Topplegeist

1/1

■■■■

Moorland Drifter

2/2

■

Jace, Vryn's Prodigy

0/2

■■

Rattlechains

2/1

■■

Bygone Bishop

2/3

■■■

Spectral Shepherd

2/2

■■■

Reflector Mage

2/3

■■■

Thunderclap Wyvern

2/3

■

Archangel Avacyn

4/4

Spell13 cards

■■■

■■

■■■■

■■■

■■■

■■■■

Land25 cards

■■

■■

■■

■■■■

■■■■

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

Top

Black Barney

Post subject: Re: Deck Planner in G! Sheets

Posted: Fri Apr 08, 2016 7:04 am

Member

Joined: Nov 10, 2013
Posts: 17748
Location: Montreal, Quebec, Canada

It's pretty, thanks !

Top

chile125

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Apr 17, 2016 7:19 pm

Member

Joined: Sep 29, 2015
Posts: 156

how about colorless symbols? (and, also the number 10)

_________________

Hakeem928 wrote:

Never tell a hungry person that you're yummy.

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Mon Apr 18, 2016 12:06 am

Member

Joined: Sep 14, 2014
Posts: 41

Hi Chile,

Thanks for pointing out.

I've corrected the error with display for CMC >9 but I'm not able to resolve the issue where

is not rendering correctly.

You can see below how it looks now. I'm using the same bbcode in the post as in the deck planner below, you can see that it is rendering properly in the deck stats, but not in the individual card lines.

Can the resident bbcode experts in the forum assist? I've no idea what is wrong here.

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

G Eldrazi Ramp

A deck for Magic Duels.

60 Cards. 35 nonlands (18 :creature: , 17 :instant: ).
25 :land: (9 9 7 Others)

Creature18 cards

■■■

Jaddi Offshoot

0/3

■■

Sylvan Advocate

2/3

■■

Eldrazi Mimic

2/1

■

Nissa, Vastwood Seer

2/2

■■

Matter Reshaper

3/2

■■■■

Warden of Geometries

2/3

■■

Thought-Knot Seer

4/4

■

Oblivion Sower

5/8

■

Ulamog, the Ceaseless Hunger

10/10

■

Kozilek, the Great Distortion

12/12

Spell17 cards

■■■

■■■

■■■■

■■■

■■

■■

Land25 cards

■■

■■■■

■■■

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

Top

Francesco Retardo

Post subject: Re: Deck Planner in G! Sheets

Posted: Fri Jun 17, 2016 3:30 pm

Member

Joined: Jun 17, 2016
Posts: 133
Location: Heidelberg, Germany

Awesome thanks!

Trying it out right now:

ColorlessWhiteBlueBlackRedGreenAzoriusOrzhovBorosSelesnyaDimirIzzetSimicRakdosGolgariGruulEsperJeskaiBantMarduAbzanNayaGrixisSultaiTemurJundGreenlessRedlessBlacklessBluelessWhitelessRainbow

Zysron's Ultrafriends

A deck for Magic Duels.

63 Cards. 40 nonlands (15 :creature: , 25 :instant: ).
23 :land: (5 2 2 2 10 2 0 Others)

Creature15 cards

■■■■

Sylvan Ranger

1/1

■

Liliana, Heretical Healer

2/3

■

Nissa, Vastwood Seer

2/2

■■■

Pilgrim's Eye

1/1

■

Greenwarden of Murasa

5/4

■

Oblivion Sower

5/8

■■

Emeria Shepherd

4/4

■

Ulamog, the Ceaseless Hunger

10/10

■

Kozilek, the Great Distortion

12/12

Spell25 cards

■■

■■

■■

■■

■■

■■■■

■

Nissa, Voice of Zendikar

■

Gideon, Ally of Zendikar

■

Arlinn Kord

■

Kiora, Master of the Depths

■

Nahiri, the Harbinger

■

Jace, Unraveler of Secrets

■

■■

■

■

Land23 cards

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

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Sat Jul 16, 2016 6:59 am

Member

Joined: Sep 14, 2014
Posts: 41

Ladies and Gentlemen,

The anthonli Duels Planner is now live with EMN cards at the following link

https://docs.google.com/spreadsheets/d/1qqdfC0DePaFGBixN1ddw0Wq28_QNgoy6Do6UDx_Us8g/edit?usp=sharing

Again, would appreciate reports of sightings of bugs or zombies or tentacles or other unexplained monstrosities that may be lurking in the festering depths of spreadsheet madness.

Top

BrewBrewBrewTheDeck

Post subject: Re: Deck Planner in G! Sheets

Posted: Wed Sep 21, 2016 5:32 pm

Member

Joined: May 19, 2016
Posts: 249
Location: Europe

Francesco Retardo wrote:

Trying it out right now:

Imma call my Superfriends build for this season something like that

Maybe Hyperfriends?

Top

Troklo

Post subject: Re: Deck Planner in G! Sheets

Posted: Sun Dec 04, 2016 12:43 pm

Member

Joined: Feb 25, 2015
Posts: 40

HI man thanks for keeping this alive. Are Kaladesh cards included?

Top

anthonli

Post subject: Re: Deck Planner in G! Sheets

Posted: Fri Dec 30, 2016 5:53 pm

Member

Joined: Sep 14, 2014
Posts: 41

Troklo wrote:

HI man thanks for keeping this alive. Are Kaladesh cards included?

Hi Troklo,

I'm so sorry for the late reply. Been caught up at work for the past few months. Kaladesh cards have been included the week it was released but I forgot to update the forum.

It's the same file as EMN one but link here for convenience:
https://docs.google.com/spreadsheets/d/1qqdfC0DePaFGBixN1ddw0Wq28_QNgoy6Do6UDx_Us8g

Have a Happy New Year and may you earn more coins for Aether Revolt Boosters!

Regards,

Anthony

Top

Page 4 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: