Ultimate Deck Building Toolset (v 1.75)

[suxerz]

..snip..
Deck code- It'd be nice to add a formula that would transpose a pasted deck code into the "card name" column of the DOG sheet.  It'd also need to be able to count the number of copies of each card code and input that information into the "number of cards" column.  Oh, and did I forget to mention that it would need to be able to do this without using the cells in those columns so that people can write in those values when they're making decks on the fly without the game client?
..snip..

I might be able to help with this since I did use something similar for the previous war, i.e. count cards in deck to check vault availability using deck codes. But, could you elaborate on the highlighted above? Do you want both functions to be available - deck codes and list of every card?

[Dragoon]

I guess what I'd like is for people to be able to paste their deck code or type in their card manually (names not code).  If you do just the deck code then they have to go back to the client to be able to do any adjustments to the deck and get new code.

So it'd be nice if we could figure out a way to take the information from the deck code and have it put in the Card Name and Card Count columns without actually having any code in those columns.  But this may be impossible.  In which case we'd need some kind of work around.  But even if you couldn't do this last part, I'd be interested in your formula for taking a deck code and changing it into card names and card counts.

[suxerz]

Yes, it seems to be impossible to do both. Another option is to create 2 separate sheets, but that is redundant and kinda sloppy. Maybe we could have a script embedded in radio buttons or something, but that is not I'm not really good at.
I'll send something to you soon but it may not anytime within this week.

[BluePriest]

Abbreviations....
http://elementswiki.co.cc/resources/elements-glossary/

http://elementscommunity.org/forum/index.php/topic,7429.msg88961#msg88961

The wiki looks nicer and seems more accurate to me though

[Dragoon]

Thanks BluePriest.  I'll take a look at that sometime and see if I can add it.


Also, any math whizzes out there know how you go about calculating the probabilities of drawing a combo of cards (ie the odds of drawing both a photon and immolation in a 30 card deck with 6 copies of each card)?

[Dragoon]

v 1.21 Update

• Fixed a bug where some elements' Pillars/Towers/Pendulums/U Pendulums weren't working in QET.  They should be working now.

[suxerz]

I believe there are few card codes that are wrong in your reference - namely White Nymph, Sundial, U Relic and Fire Nymph. Maybe it has to do with the cell's formatting. You need to set it to plain text.

Regarding the deck import codes, here (https://spreadsheets.google.com/ccc?key=0ApI-50p2LmlcdDVaaXAtZW96MDNhX3p6LW1DVkxETFE&hl=en&authkey=CIf-hRM) is an example that I made. After wasting so much time in MS excel, I've realized that Google doc has a neat function to find unique text in a string. I don't think I could do the same in MS excel without using any VB script. I didn't integrate this with any of your toolset because (1) so that you can customize your own layout, (2) I don't want to mess with other formulas and (3) I don't even understand the calculation.

As you can see, I couldn't figure out a smart way to amend the deck manually after importing deck codes without screwing the formula. An option that I could think of is to just edit/add/remove any card name and/or card numbers after(or even without) importing deck codes. Correct me if I'm wrong, but as far as I can tell, your DOG Engine only takes the card name and numbers in the formulas. So, I don't see any problem with this solution.

[Dragoon]

Regarding the deck import codes, here (https://spreadsheets.google.com/ccc?key=0ApI-50p2LmlcdDVaaXAtZW96MDNhX3p6LW1DVkxETFE&hl=en&authkey=CIf-hRM) is an example that I made. After wasting so much time in MS excel, I've realized that Google doc has a neat function to find unique text in a string. I don't think I could do the same in MS excel without using any VB script. I didn't integrate this with any of your toolset because (1) so that you can customize your own layout, (2) I don't want to mess with other formulas and (3) I don't even understand the calculation.

That looks awesome.  I'll try to implement it in v 1.3 or v 1.4.

I believe there are few card codes that are wrong in your reference - namely White Nymph, Sundial, U Relic and Fire Nymph. Maybe it has to do with the cell's formatting. You need to set it to plain text.

I believe you are right about the formatting.  But I'll double check those card codes as well.

As you can see, I couldn't figure out a smart way to amend the deck manually after importing deck codes without screwing the formula. An option that I could think of is to just edit/add/remove any card name and/or card numbers after(or even without) importing deck codes. Correct me if I'm wrong, but as far as I can tell, your DOG Engine only takes the card name and numbers in the formulas. So, I don't see any problem with this solution.

Yes, the DOG Engine only uses the name and numbers, not any code.  The QET Engine converts the card names to code for it to work.  Yeah, I'm still not sure how to do this yet either.  If we let them overwrite what's there, then the next person won't get the benefit of the formulas.  I might just have to make 3 sets of columns (manual, deck code, final).

[Dragoon]

v 1.5 Update
Big update here.

• I updated the QET Engine so that it now properly gives quanta for all pillars, towers, marks, U marks, Pendulums, U Pendulums, and Novas.  I didn't add Supernovas, Immolations, and Cremations because those require other factors to be played.  This was a huge pain in the neck.  But I'm glad it's done now.  Making monster 25x62 tables with element specific formulas for each element is tedious.  : P
• The Card Probability Calculator (CPC) has been updated with a partially working multi-card combo probability calculator.  I'm in the process of making it cumulative versus just exact.
• QET now automatically figures out your deck's QI for each element.  In this QI, recurring Q production and usage is not considered (i.e. Devourers, Brimstone Eaters, Owl's Eyes, Maxwell's Demon, etc.), but the Mark is considered (Mark is equal to 1 Pillar).
• DOG now will give you your deck code for cards that you manually type in.  This should make it easier to transfer your decks to the game client or forums.
• DOG also lets you import deck codes instead of typing in the cards manually.
• All the sections have gotten a facelift as well as data validation and drop-down menus where applicable.
• The OP has been redone to simplify and organize the explanations for each tool better.
• There are now new links for the tools.

[Dragoon]

v 1.51 Update

• Had the wrong card code for U Death Pendulum in all the QI Income cells.  It's fixed now.
• Updated the cost for Titanium and Diamond Shields.

[rowcla]

wow im sure ive had that hand loads of times, and luckily the average hand is a good hand, yay, thanks Dragoon

[Dragoon]

Well, well.  I didn't realize this, but Google Docs has a limit on spreadsheets . . . and I've hit it.   

You can only have 400k cells and a total of 40k cells with formulas.

It might take a while before another update comes out since I have to figure out how to get around these limitations.  : P