It is currently Sun Jun 17, 2018 9:09 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 82 posts ]  Go to page Previous  1, 2, 3, 4, 5  Next
Author Message
PostPosted: Mon Dec 07, 2015 5:51 am 
Offline
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.


Like this post
Top
 Profile  
 
PostPosted: Wed Dec 09, 2015 8:53 pm 
Offline
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:


Like this post
Top
 Profile  
 
PostPosted: Thu Dec 10, 2015 1:29 am 
Offline
Member

Joined: Feb 25, 2015
Posts: 40
you sir rock!


Like this post
Top
 Profile  
 
PostPosted: Fri Dec 11, 2015 12:02 pm 
Offline
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:


Like this post
Top
 Profile  
 
PostPosted: Sun Dec 27, 2015 4:38 pm 
Offline
Member
User avatar

Joined: Sep 29, 2015
Posts: 148
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)

_________________
Hakeem928 wrote:
Never tell a hungry person that you're yummy.

Image


Like this post
Top
 Profile  
 
PostPosted: Sun Dec 27, 2015 6:39 pm 
Offline
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


Like this post
Top
 Profile  
 
PostPosted: Wed Dec 30, 2015 6:04 am 
Offline
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


Like this post
Top
 Profile  
 
PostPosted: Thu Dec 31, 2015 10:49 am 
Offline
Member

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


Like this post
Top
 Profile  
 
PostPosted: Wed Mar 23, 2016 10:48 am 
Offline
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
"


Like this post
Top
 Profile  
 
PostPosted: Sun Apr 03, 2016 3:43 am 
Offline
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


Like this post
Top
 Profile  
 
PostPosted: Sun Apr 03, 2016 7:23 pm 
Offline
Member

Joined: Nov 18, 2013
Posts: 106
Thanks, looking forward to it


Like this post
Top
 Profile  
 
PostPosted: Thu Apr 07, 2016 11:13 pm 
Offline
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
■■■
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


Like this post
Top
 Profile  
 
PostPosted: Fri Apr 08, 2016 7:04 am 
Offline
Member
User avatar

Joined: Nov 10, 2013
Posts: 9526
Location: Montreal, Quebec, Canada
It's pretty, thanks !

_________________
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: Sun Apr 17, 2016 7:19 pm 
Offline
Member
User avatar

Joined: Sep 29, 2015
Posts: 148
how about colorless symbols? (and, also the number 10)

_________________
Hakeem928 wrote:
Never tell a hungry person that you're yummy.

Image


Like this post
Top
 Profile  
 
PostPosted: Mon Apr 18, 2016 12:06 am 
Offline
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)



Like this post
Top
 Profile  
 
PostPosted: Fri Jun 17, 2016 3:30 pm 
Offline
Member
User avatar

Joined: Jun 17, 2016
Posts: 131
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)



Like this post
Top
 Profile  
 
PostPosted: Sat Jul 16, 2016 6:59 am 
Offline
Member

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


Like this post
Top
 Profile  
 
PostPosted: Wed Sep 21, 2016 5:32 pm 
Offline
Member
User avatar

Joined: May 19, 2016
Posts: 249
Location: Europe
Trying it out right now:
Imma call my Superfriends build for this season something like that :D Maybe Hyperfriends?


Like this post
Top
 Profile  
 
PostPosted: Sun Dec 04, 2016 12:43 pm 
Offline
Member

Joined: Feb 25, 2015
Posts: 40
HI man thanks for keeping this alive. Are Kaladesh cards included?


Like this post
Top
 Profile  
 
PostPosted: Fri Dec 30, 2016 5:53 pm 
Offline
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


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 6 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:  
Powered by phpBB® Forum Software © phpBB Group