No Goblins Allowed
https://nogoblinsallowed.com/

Deck Planner in G! Sheets
https://nogoblinsallowed.com/viewtopic.php?f=38&t=11069
Page 4 of 5

Author:  Troklo [ Mon Dec 07, 2015 5:51 am ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  anthonli [ Wed Dec 09, 2015 8:53 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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:

Author:  Troklo [ Thu Dec 10, 2015 1:29 am ]
Post subject:  Re: Deck Planner in G! Sheets

you sir rock!

Author:  snwkill [ Fri Dec 11, 2015 12:02 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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:

Author:  chile125 [ Sun Dec 27, 2015 4:38 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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

"
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)

Author:  anthonli [ Sun Dec 27, 2015 6:39 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  hao [ Wed Dec 30, 2015 6:04 am ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  anthonli [ Thu Dec 31, 2015 10:49 am ]
Post subject:  Re: Deck Planner in G! Sheets

hao wrote:
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


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.

Author:  stahlster [ Wed Mar 23, 2016 10:48 am ]
Post subject:  Re: Deck Planner in G! Sheets

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
"

Author:  anthonli [ Sun Apr 03, 2016 3:43 am ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  stahlster [ Sun Apr 03, 2016 7:23 pm ]
Post subject:  Re: Deck Planner in G! Sheets

Thanks, looking forward to it

Author:  anthonli [ Thu Apr 07, 2016 11:13 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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
■■■
Topplegeist1/1
■■■■
Moorland Drifter2/2
Jace, Vryn's Prodigy0/2
■■
Rattlechains2/1
■■
Bygone Bishop2/3
■■■
Spectral Shepherd2/2
■■■
Reflector Mage2/3
■■■
Thunderclap Wyvern2/3
Archangel Avacyn4/4
Spell13 cards
■■■
Essence Flux
■■
Declaration in Stone
■■■
Nagging Thoughts
■■■
Broken Concentration
■■
Roil Spout
■■■■
Isolation Zone
Land25 cards
Westvale Abbey
■■
Glacial Fortress
■■
Prairie Stream
■■■■
Skyline Cascade
■■■■
Evolving Wilds
8
Plain
6
Island

Author:  Black Barney [ Fri Apr 08, 2016 7:04 am ]
Post subject:  Re: Deck Planner in G! Sheets

It's pretty, thanks !

Author:  chile125 [ Sun Apr 17, 2016 7:19 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  anthonli [ Mon Apr 18, 2016 12:06 am ]
Post subject:  Re: Deck Planner in G! Sheets

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)


Author:  Francesco Retardo [ Fri Jun 17, 2016 3:30 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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)


Author:  anthonli [ Sat Jul 16, 2016 6:59 am ]
Post subject:  Re: Deck Planner in G! Sheets

Ladies and Gentlemen,

The anthonli Duels Planner is now live with EMN cards at the following link :D
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.

Author:  BrewBrewBrewTheDeck [ Wed Sep 21, 2016 5:32 pm ]
Post subject:  Re: Deck Planner in G! Sheets

Trying it out right now:
Imma call my Superfriends build for this season something like that :D Maybe Hyperfriends?

Author:  Troklo [ Sun Dec 04, 2016 12:43 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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

Author:  anthonli [ Fri Dec 30, 2016 5:53 pm ]
Post subject:  Re: Deck Planner in G! Sheets

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

Page 4 of 5 All times are UTC - 6 hours [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/