Elements the Game Forum - Free Online Fantasy Card Game

Other Topics => Elements Portal => Elements Tools => Topic started by: antiaverage on October 04, 2013, 11:17:35 PM

Title: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on October 04, 2013, 11:17:35 PM
I have updated the Google Documents spreadsheet for Elements Card Tracking to 1.327 and made some improvements. Special thanks to suxerz for starting this sheet, serprex for bug reports and code, and CuCN for bug reports and code.

I am tempted to just make a short video explaining the sheet. Please let me know if this is needed.

You can always find the latest version of the spreadsheet here:
http://dek.im/tracker

You can import your card data by using this:
http://dek.im/import (http://dek.im/import)

(http://i.imgur.com/BdONrah.png)

Why Google Docs?
Pro: Anyone can use it, available from any computer with an Internet connection
Con: Can be a bit slow, not as advanced as Excel (although not a problem for card tracking)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: BeefSupreme on October 07, 2013, 04:10:28 AM
Thank you so much! I've been waiting for this to be updated for a while x)

P.S. You should make that video x) So much to read D:
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Blacksmith on October 21, 2013, 04:19:58 PM
I like it, I like it a lot!

thank you fro making this!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: nireus on October 21, 2013, 10:14:14 PM
Great job! This tool is really useful, especially if you've lost count of your cards  ;D
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 18, 2013, 05:46:50 AM
Updated a couple bugs. As usual, you can get the latest version here:
http://dek.im/tracker

Be sure to read the instructions (http://elementscommunity.org/forum/elements-tools/elements-card-tracking-spreadsheet-1-324/msg1100826/#msg1100826) under II. Extras 1. Importing card count data for easy upgrading.

Special thanks to serprex and CuCN for pointing out issues. If you catch any issues, please let me know and I'll be happy to include fixes. Linking me to your commented sheet is also incredibly helpful.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: serprex on November 19, 2013, 01:47:25 AM
Code: [Select]
<body>
<script type="text/javascript">
var carddb = (function(){ /*
4sa 6qq
4sj 6r3
4sk 6r4
4sl 6r5
4sm 6r6
4sn 6r7
4so 6r8
4sp 6r9
4sq 6ra
4sr 6rb
4ss 6rc
4st 6rd
4su 6re
4t3 6rj
4t4 6rk
4t5 6rl
4t9 6rp
4tb 6rr
4tc 6rs
4vc 6ts
4vd 6tt
4ve 6tu
4vf 6tv
4vg 6u0
4vh 6u1
4vi 6u2
4vj 6u3
4vk 6u4
4vl 6u5
4vm 6u6
4vn 6u7
4vo 6u8
4vp 6u9
4vq 6ua
500 6ug
50a 6uq
50u 6ve
52g 710
52h 711
52i 712
52j 713
52k 714
52l 715
52m 716
52n 717
52o 718
52p 719
52q 71a
52r 71b
52s 71c
52t 71d
52u 71e
52v 71f
534 71k
53e 71u
542 72i
55k 744
55l 745
55m 746
55n 747
55o 748
55p 749
55q 74a
55r 74b
55s 74c
55t 74d
55u 74e
55v 74f
560 74g
561 74h
562 74i
563 74j
568 74o
56i 752
56s 75c
576 75m
58o 778
58p 779
58q 77a
58r 77b
58s 77c
58t 77d
58u 77e
58v 77f
590 77g
591 77h
592 77i
593 77j
594 77k
595 77l
596 77m
59c 77s
59m 786
5aa 78q
5bs 7ac
5bt 7ad
5bu 7ae
5bv 7af
5c0 7ag
5c1 7ah
5c2 7ai
5c3 7aj
5c4 7ak
5c5 7al
5c6 7am
5c7 7an
5c8 7ao
5c9 7ap
5cg 7b0
5cq 7ba
5de 7bu
5f0 7dg
5f1 7dh
5f2 7di
5f3 7dj
5f4 7dk
5f5 7dl
5f6 7dm
5f7 7dn
5f8 7do
5f9 7dp
5fa 7dq
5fb 7dr
5fc 7ds
5fe 7du
5fk 7e4
5fu 7ee
5gi 7f2
5i4 7gk
5i5 7gl
5i6 7gm
5i7 7gn
5i8 7go
5i9 7gp
5ia 7gq
5ib 7gr
5ic 7gs
5id 7gt
5ie 7gu
5if 7gv
5ig 7h0
5ih 7h1
5ii 7h2
5ij 7h3
5io 7h8
5j2 7hi
5jm 7i6
5l8 7jo
5l9 7jp
5la 7jq
5lb 7jr
5lc 7js
5ld 7jt
5le 7ju
5lf 7jv
5lg 7k0
5lh 7k1
5li 7k2
5lj 7k3
5lk 7k4
5ll 7k5
5lm 7k6
5ls 7kc
5m6 7km
5mq 7la
5oc 7ms
5od 7mt
5oe 7mu
5of 7mv
5og 7n0
5oh 7n1
5oi 7n2
5oj 7n3
5ok 7n4
5ol 7n5
5om 7n6
5on 7n7
5oo 7n8
5op 7n9
5p0 7ng
5pa 7nq
5pu 7oe
5rg 7q0
5rh 7q1
5ri 7q2
5rj 7q3
5rk 7q4
5rl 7q5
5rm 7q6
5rn 7q7
5ro 7q8
5rp 7q9
5rq 7qa
5rr 7qb
5rs 7qc
5rt 7qd
5ru 7qe
5s4 7qk
5se 7qu
5t2 7ri
5uk 7t4
5ul 7t5
5um 7t6
5un 7t7
5uo 7t8
5up 7t9
5uq 7ta
5ur 7tb
5us 7tc
5ut 7td
5uu 7te
5uv 7tf
5v0 7tg
5v1 7th
5v2 7ti
5v8 7to
5vi 7u2
606 7um
61o 808
61p 809
61q 80a
61r 80b
61s 80c
61t 80d
61u 80e
61v 80f
620 80g
621 80h
622 80i
623 80j
624 80k
625 80l
626 80m
62c 80s
62m 816
63a 81q
*/}).toString().split('\n').slice(1, -1);
function code324(x){
return parseInt(x,32)-5000;
}
var cards=prompt("","");
if (cards != null){
var coro = {};
for(var i=0;i<carddb.length;i++){
codes = carddb[i].split('\t');
coro[code324(codes[0])]=[i,0];
coro[code324(codes[1])]=[i,1];
}
var arr = new Array(236);
for(var i=0;i<236;i++)arr[i]=[0,0];
for(var i=1;i<cards.length;i+=7){
var cardloc=coro[parseInt(cards.substring(i,i+4),10)];
if(cardloc == undefined)alert(cards.substring(i,i+4));
arr[cardloc[0]][cardloc[1]] += parseInt(cards.substring(i+4,i+7),10);
}
var out="";
for(var i=0;i<236;i++)out+=arr[i][0]+"\t"+arr[i][1]+"\n";
document.body.innerHTML = "<pre>" + out + "</pre>";
}
</script>
</body>
Copy POST data's 'decka' to prompt. Copy output to Import. Never manually count again
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: eljoemo on November 19, 2013, 04:48:59 AM
Code: [Select]
<body>
<script type="text/javascript">
var carddb = (function(){ /*
4sa 6qq
4sj 6r3
4sk 6r4
4sl 6r5
4sm 6r6
4sn 6r7
4so 6r8
4sp 6r9
4sq 6ra
4sr 6rb
4ss 6rc
4st 6rd
4su 6re
4t3 6rj
4t4 6rk
4t5 6rl
4t9 6rp
4tb 6rr
4tc 6rs
4vc 6ts
4vd 6tt
4ve 6tu
4vf 6tv
4vg 6u0
4vh 6u1
4vi 6u2
4vj 6u3
4vk 6u4
4vl 6u5
4vm 6u6
4vn 6u7
4vo 6u8
4vp 6u9
4vq 6ua
500 6ug
50a 6uq
50u 6ve
52g 710
52h 711
52i 712
52j 713
52k 714
52l 715
52m 716
52n 717
52o 718
52p 719
52q 71a
52r 71b
52s 71c
52t 71d
52u 71e
52v 71f
534 71k
53e 71u
542 72i
55k 744
55l 745
55m 746
55n 747
55o 748
55p 749
55q 74a
55r 74b
55s 74c
55t 74d
55u 74e
55v 74f
560 74g
561 74h
562 74i
563 74j
568 74o
56i 752
56s 75c
576 75m
58o 778
58p 779
58q 77a
58r 77b
58s 77c
58t 77d
58u 77e
58v 77f
590 77g
591 77h
592 77i
593 77j
594 77k
595 77l
596 77m
59c 77s
59m 786
5aa 78q
5bs 7ac
5bt 7ad
5bu 7ae
5bv 7af
5c0 7ag
5c1 7ah
5c2 7ai
5c3 7aj
5c4 7ak
5c5 7al
5c6 7am
5c7 7an
5c8 7ao
5c9 7ap
5cg 7b0
5cq 7ba
5de 7bu
5f0 7dg
5f1 7dh
5f2 7di
5f3 7dj
5f4 7dk
5f5 7dl
5f6 7dm
5f7 7dn
5f8 7do
5f9 7dp
5fa 7dq
5fb 7dr
5fc 7ds
5fe 7du
5fk 7e4
5fu 7ee
5gi 7f2
5i4 7gk
5i5 7gl
5i6 7gm
5i7 7gn
5i8 7go
5i9 7gp
5ia 7gq
5ib 7gr
5ic 7gs
5id 7gt
5ie 7gu
5if 7gv
5ig 7h0
5ih 7h1
5ii 7h2
5ij 7h3
5io 7h8
5j2 7hi
5jm 7i6
5l8 7jo
5l9 7jp
5la 7jq
5lb 7jr
5lc 7js
5ld 7jt
5le 7ju
5lf 7jv
5lg 7k0
5lh 7k1
5li 7k2
5lj 7k3
5lk 7k4
5ll 7k5
5lm 7k6
5ls 7kc
5m6 7km
5mq 7la
5oc 7ms
5od 7mt
5oe 7mu
5of 7mv
5og 7n0
5oh 7n1
5oi 7n2
5oj 7n3
5ok 7n4
5ol 7n5
5om 7n6
5on 7n7
5oo 7n8
5op 7n9
5p0 7ng
5pa 7nq
5pu 7oe
5rg 7q0
5rh 7q1
5ri 7q2
5rj 7q3
5rk 7q4
5rl 7q5
5rm 7q6
5rn 7q7
5ro 7q8
5rp 7q9
5rq 7qa
5rr 7qb
5rs 7qc
5rt 7qd
5ru 7qe
5s4 7qk
5se 7qu
5t2 7ri
5uk 7t4
5ul 7t5
5um 7t6
5un 7t7
5uo 7t8
5up 7t9
5uq 7ta
5ur 7tb
5us 7tc
5ut 7td
5uu 7te
5uv 7tf
5v0 7tg
5v1 7th
5v2 7ti
5v8 7to
5vi 7u2
606 7um
61o 808
61p 809
61q 80a
61r 80b
61s 80c
61t 80d
61u 80e
61v 80f
620 80g
621 80h
622 80i
623 80j
624 80k
625 80l
626 80m
62c 80s
62m 816
63a 81q
*/}).toString().split('\n').slice(1, -1);
function code324(x){
return parseInt(x,32)-5000;
}
var cards=prompt("","");
if (cards != null){
var coro = {};
for(var i=0;i<carddb.length;i++){
codes = carddb[i].split('\t');
coro[code324(codes[0])]=[i,0];
coro[code324(codes[1])]=[i,1];
}
var arr = new Array(236);
for(var i=0;i<236;i++)arr[i]=[0,0];
for(var i=1;i<cards.length;i+=7){
var cardloc=coro[parseInt(cards.substring(i,i+4),10)];
if(cardloc == undefined)alert(cards.substring(i,i+4));
arr[cardloc[0]][cardloc[1]] += parseInt(cards.substring(i+4,i+7),10);
}
var out="";
for(var i=0;i<236;i++)out+=arr[i][0]+"\t"+arr[i][1]+"\n";
document.body.innerHTML = "<pre>" + out + "</pre>";
}
</script>
</body>
Copy POST data's 'decka' to prompt. Copy output to Import. Never manually count again

For those of us who have absolutely no idea about anything you just said, could you please explain in a I-know-nothing-about-anything kind of way? Counting cards truly is a pain.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: serprex on November 19, 2013, 06:27:02 AM
I hesitated to post due to my inability to explain, nevermind with ELI5 requirements. Preferably anti would be around and come up with a great way to give concise yet clear instructions on how to use Firefox's and Chrome's web dev tools to view POST requests. I'll now fail to do so for Firefox, the browser I'm currently using

Login to EtG. Open "File > Web Developer > Network". Open your deck. Close your deck. You should see a POST request to dev7.php in the network monitor. You want to see Params, not Headers. Specifically, you want the value of 'decka'. It's the longest thing, since it's your card pool in RLE form (I'm straying, apologies). Copy/Paste the value of 'decka' into the prompt that appears when you browse to an html file whose content is that of the snippet I posted earlier. The page will finish loading as the Import table you need to Copy/Paste into the Import spreadsheet. NB the import values are overwritten when you update cells, so you'll need to do this on a fresh sheet

If I only served to rewrite what I previously posted in a longer and more confusing mess, then, well, damn

Mozilla's explanation: https://hacks.mozilla.org/2013/06/network-monitor-now-in-firefox-beta
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 19, 2013, 07:35:58 AM
You can ignore this post and just click this:
http://dek.im/import (http://dek.im/import)

Before the above edit, this is the wall of text you could have read...

In chrome, you would open Elements via the elementsthegame.com or Kongregate. Let the page finish loading, but don't login to your account just yet. Open: View > Developer > Developer Tools. Select the Network tab. Go ahead and login to Elements. You'll see requests start to populate the left column. Watch for dev7.php and single-click on it when you see it. Select the Headers tab and scroll down to Form Data. In the Form Data section, look for decka, it's massive. That is your card data. You can use the script serprex wrote above to convert it to something useful for import into the sheet. At some point we'll probably make this a bit more user friendly. I'm looking into automating it with a Chrome extension using chrome.webRequest: http://developer.chrome.com/extensions/webRequest.html

I put up serprex's script on jsfiddle and I added instructions so you can use it easily:
http://jsfiddle.net/AsLLt/9/embedded/result/

Just make sure you copied your decka data using the instructions I just explained, then paste it into the prompt on that jsfiddle. His script will spit out a list of values that you can copy into the Import sheet in order to sync your card tracking.

If you clicked "cancel" on the prompt that came up but didn't get a chance to paste in your decka data, that's okay. Just refresh the jsfiddle page and the prompt will pop back up.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: BeefSupreme on November 19, 2013, 10:50:05 PM
That is just absolutely fantastic. I actually stopped using Spreadsheet because it was so hard to maintain, but that just makes everything about this 10x easier. Thanks a billion!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 20, 2013, 02:31:21 AM
The sheet is now hosted as template. This allows the increment script to be bundled properly and also smooths the user flow. Unfortunately, Google's preview of the template looks awful, and there isn't much I can do about that. However, once you click the "Use this template" button, it copies over to your Drive and looks great again.

To get the latest sheet, just go to http://dek.im/tracker as usual. For easy upgrade/import, just go to http://dek.im/import and learn how easy it is now.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: eljoemo on November 20, 2013, 02:52:14 AM
Thanks a bunch to serprex and antiaverage for doing this. This has seriously made card counting so much easier and much more do-able :D In the off chance I do have a family at some point, I'll name my children after you two!

Seriously, good job!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 22, 2013, 08:21:45 PM
Thanks to CuCN for porting serprex's script into Google Script. I then modified the script and streamlined the process, so between the three of us it is now even simpler to import your card data. Grab the new sheet at http://dek.im/tracker as usual and follow the instructions on http://dek.im/import for copying your decka data. Paste that data into the decka slot on the Cards sheet, and all your card data will be automatically populated.

There is also a new sheet to keep track of your score progress.

Enjoy!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 22, 2013, 11:55:15 PM
I have added instructions for Safari and Internet Explorer to http://dek.im/import so that more of you can directly import your card count data into the card tracking spreadsheet. Let me know if any of it is confusing. Happy to help via PM, etc.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on November 23, 2013, 06:12:29 PM
The function for cleaning up the Cards sheet just wasn't perfect enough, so CuCN submitted an improved function that has been put in the latest version. Thanks CuCN!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on December 10, 2013, 02:33:51 AM
New version released today:
http://dek.im/tracker (http://dek.im/tracker)



Remember, you can easily import your whole card collection fresh from the game with little effort by using:
http://dek.im/import (http://dek.im/import)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: nireus on December 10, 2013, 10:01:31 AM
Well, that's really amazing... My hat's off to you! Excellent job, congrats!!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: rob77dp on December 10, 2013, 04:10:06 PM
New version released today:
http://dek.im/tracker (http://dek.im/tracker)


  • Score sheet for tracking your Arena Deck Level progress
  • Sell sheet added to give you a clean list of what extra cards you can sell and related stats
  • Collections sheet polished to help you track your progress for different sub-collections of cards
  • Deck Cost improved with new stats and improved layout
  • Colors and functions tweaked

Remember, you can easily import your whole card collection fresh from the game with little effort by using:
http://dek.im/import (http://dek.im/import)

This seems now advanced enough to warrant my effort (read:  it is now little enough effort from me ;) ) of switching from my self-modified version of an older version of your tracker, aa.  Thanks for the efforts you're putting in to this (also, I made sure to rate the template file on Google Drive).

Edit:  If I had to guess, I would peg you as a Canadian type, aa.

Edit2:  Also, your Chrome instructions work for Comodo Dragon too.  May I suggest revising "8. Starting from the 'x'" to "8. Starting with the 'x'" for clarity?

Edit3:  Lesser suggestion here - change "Sell" tab to "Can Sell" or "Suggested Sell"?
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on December 10, 2013, 04:30:13 PM
Thank you, Rob! Let me know if there is anything you need on the sheet.

Edit:  If I had to guess, I would peg you as a Canadian type, aa.

Edit2:  Also, your Chrome instructions work for Comodo Dragon too.  May I suggest revising "8. Starting from the 'x'" to "8. Starting with the 'x'" for clarity?

Edit3:  Lesser suggestion here - change "Sell" tab to "Can Sell" or "Suggested Sell"?

Re: Edit: Heh, I'm not Canadian. I live in Boston.

Re: Edit2: Awesome, good news. That's a good revision, I will implement it.

Re: Edit3: Is Sell too ambiguous? I wanted to keep the tab names short, but is that causing confusion?
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: rob77dp on December 10, 2013, 05:21:10 PM
Thank you, Rob! Let me know if there is anything you need on the sheet.

Edit:  If I had to guess, I would peg you as a Canadian type, aa.

Edit2:  Also, your Chrome instructions work for Comodo Dragon too.  May I suggest revising "8. Starting from the 'x'" to "8. Starting with the 'x'" for clarity?

Edit3:  Lesser suggestion here - change "Sell" tab to "Can Sell" or "Suggested Sell"?

Re: Edit: Heh, I'm not Canadian. I live in Boston.

Re: Edit2: Awesome, good news. That's a good revision, I will implement it.

Re: Edit3: Is Sell too ambiguous? I wanted to keep the tab names short, but is that causing confusion?

This item 3 was much more just "take it or leave it" and I really wouldn't expect any issues from it.  However... http://en.wikipedia.org/wiki/Liebeck_v._McDonald's_Restaurants (http://en.wikipedia.org/wiki/Liebeck_v._McDonald's_Restaurants)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Fippe94 on December 10, 2013, 06:36:49 PM
I assume the Sell tab is supposed to show a list of each card you need to sell? Well, it does not for me:
(http://gyazo.com/b652568adc2e96c4dbbfc415515df55c.png)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: rob77dp on December 10, 2013, 07:37:34 PM
I assume the Sell tab is supposed to show a list of each card you need to sell? Well, it does not for me:
(http://gyazo.com/b652568adc2e96c4dbbfc415515df55c.png)

As an example that is "working" properly, here is a screen shot of my "Sell" tab...
(http://i.imgur.com/DveaOrC.png)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Calambar on December 11, 2013, 01:44:17 AM
Thanks a lot :) It;s pure genius :) I appreciate your work, very helpful tool.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on December 11, 2013, 04:21:09 AM
I assume the Sell tab is supposed to show a list of each card you need to sell? Well, it does not for me

Could you try modifying any empty cell on the Cards sheet (like, type a letter into the top left cell or something) and then viewing the Sell sheet?
Title: love it
Post by: Akaya on December 14, 2013, 06:31:44 AM
Awesome work! Thanks for this!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: trashduke on July 01, 2014, 09:37:07 PM
This is pretty awesome - thanks so much for putting it together + rep!

Update - I just want to reiterate how nice this spreadsheet is, very cool way to see progress towards the Basic Edition.  If I could add rep twice I would.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Submachine on July 16, 2014, 11:49:30 AM
I tried to import my decka code but everytime i paste it in the box, i get this message:

Error: Your input was malformed.
See the JavaScript console for more information.

In the console I only found a long list of:

Error: Can't find card "xxxx"          (index):301
Where xxxx is always a different 4-digit number between 0000-9999.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: theelkspeaks on July 16, 2014, 01:38:33 PM
I tried to import my decka code but everytime i paste it in the box, i get this message:

Error: Your input was malformed.
See the JavaScript console for more information.

In the console I only found a long list of:

Error: Can't find card "xxxx"          (index):301
Where xxxx is always a different 4-digit number between 0000-9999.

Not sure what's happening to you, I import using decka multiple times a week and haven't had any problems. 
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Blacksmith on July 16, 2014, 06:12:17 PM
I tried to import my decka code but everytime i paste it in the box, i get this message:

Error: Your input was malformed.
See the JavaScript console for more information.

In the console I only found a long list of:

Error: Can't find card "xxxx"          (index):301
Where xxxx is always a different 4-digit number between 0000-9999.
If you provided the code you try to add I can have a look at it.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: trashduke on December 08, 2014, 03:53:27 AM
I used this before and was loving it, but now it's not working.  I'm not sure if there was an update that is crashing things, but every time I try to paste a decka code, I get

"Error: 2040"
Using Safari.

Anyone else having any trouble?

12/8 edit: Nevermind - I forgot that you had to include the "x" before all of the data...  it's working now.


Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: dacomb on January 05, 2015, 04:07:55 AM
I used this before and was loving it, but now it's not working.  I'm not sure if there was an update that is crashing things, but every time I try to paste a decka code, I get

"Error: 2040"
Using Safari.

Anyone else having any trouble?

12/8 edit: Nevermind - I forgot that you had to include the "x" before all of the data...  it's working now.




I've been using this for the last week with Google Chrome. I haven't had any trouble with it.
It could be an issue with Safari and Google Docs... Can you try it in Chrome and see if it works for you?

EDIT:
Clearly I missed the last comment you wrote... *facepalm*
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: antiaverage on January 08, 2015, 04:01:43 PM
serprex reported to me that the Sell tab has a small bug.

Quote from: serprex
Sell tab includes excess upped copies in count of how many unupped copies to sell

eg If I have 7/7 SoFr, it'll say I should sell 2 unupped sofrs & 1 upped sofr

So, take care if you are using the Sell tab. I will post here when this is fixed.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Sera on February 05, 2015, 07:01:39 AM
Something seems to be wrong with Owl's Eye. I have 74 copies of the unupped and 1 copy of the upped, and my unupgraded Air completion rate currently shows 104.63%. If I remove the excess unupped or set unupped to 6 while retaining the excess unupped, it goes back to the normal 100%. This doesn't happen with my other excess rares.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Zawadx on February 05, 2015, 07:33:32 AM
Something seems to be wrong with Owl's Eye. I have 74 copies of the unupped and 1 copy of the upped, and my unupgraded Air completion rate currently shows 104.63%. If I remove the excess unupped or set unupped to 6 while retaining the excess unupped, it goes back to the normal 100%. This doesn't happen with my other excess rares.

I'd personally be more concerned with the fact that you had 74 unupped Owl's Eyes :P
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Sera on February 06, 2015, 01:11:01 AM
I'd personally be more concerned with the fact that you had 74 unupped Owl's Eyes :P
Well, I don't sell unupped rares, for collection :p
And the error is still there even when I set unupped Owl's Eyes to less than 12.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Savage on March 27, 2015, 07:30:24 AM
Hi, so I am using a google chrome browser and finally found the developer tools to import cards. The next part of instructions make no sense to me. Is there anyone that can help please. (After getting into developer tools, giving a detailed list as to the next steps as I don't see how I can do them from anywhere)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: kirbylover314 on March 28, 2015, 03:15:01 AM
Hi, so I am using a google chrome browser and finally found the developer tools to import cards. The next part of instructions make no sense to me. Is there anyone that can help please. (After getting into developer tools, giving a detailed list as to the next steps as I don't see how I can do them from anywhere)

After opening dev tools, do the following:

1. Go to the deck editor in the game.Then, click "Menu"
2. Go to dev tools. There is a tab called "Network" Click it once.
3. There will be an item called "dev7.php". Click it once.
4. After doing that, there will be a tab called "Headers". It is under "Disable cache". Click it once.
5. Look for "decka". After it, there will be a string of numbers followed by "x", so the sting will look something like this:
x01070060309001070600108080012309002241300626300053112003320000432030030002025002700800280090029006003301100350060036006010001601010070102011010301201040080105007010600901080080109006011000601110110112009011300801140090120002013000801500140200015020101202020060203007020400802050090206012020700802080060209007021000802110090212007021301202140070215009022000202300020250007030001603010090302009030300703040080305009030601003070100308008030900503100080311011031200603130080314007031500603300100350013040000904010070402005040300904040070405006040600604070120408006040900804100060411009041200704130060414008042000204300030450019050002005010070502008050300805040080505008050601205070080508008050901105100120511012051201105130120530011055001306000140601009060201206030120604011060500606060060607010060801206090060610010061100706120080614007063000106500150700015070101107020070703006070400707050070706006070700907080080709006071001007110080712010071301207140090715010073000607500150800015080100608020080803007080400608050090806006080701008080050809006081000508110090812011081300608140100830006085001209000180901008090201209030090904006090500609060060907010090800609090060910011091101009120080913007092000109300090950012100001110010081002011100300810040101005006100601010070091008007100900610100071011006101201010130061014012103000810500131100014110101011020121103007110400811050091106006110701011080081109012111000911110071112006111301211140081130006115001912000171201007120201212030091204012120500612060101207012120800612090081210007121100712120091213012121400712200011230012125001220020052033001210200121050012107006210900221300022150006220000622030052208006221000422110012214002223000622500082301001230200123080012310001231100123300012400006240200224060062408006250900126000012604001260600626070022609006261000126110022612004263000127010012702002270700127080012710001271200127300022800001280100628020012803001280500128060012807001280900628100062814002283000128500012901004290600629070012909006291000129110022912001293000330000053001001300500630070013008005300900630300013050003310500331070013108001311200132000043205006320600132080033210005
6. Copypaste your decka string into cell U1 of the "Cards" sheet of the card tracking spreadsheet.
6.1. Alternatively, you can go to jsfiddle.net/AsLLt/27/embedded/result/ (http://jsfiddle.net/AsLLt/27/embedded/result/) and put the decka string into the text box. There will be a table after you do that. Copypaste that into cell A1 of the "Import" sheet the card tracking spreadsheet. it does the same thing, but it's a bit more work.
7. Wait for the spreadsheet to do stuff. It should work now.

I hope this helps!
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Savage on March 28, 2015, 04:29:01 AM
Kirby thank you so much for your help.

Here are links to see screenshots of my current card collection:

http://imagizer.imageshack.com/img540/8664/9mneym.png (http://imagizer.imageshack.com/img540/8664/9mneym.png)
http://imagizer.imageshack.com/img540/3259/6YuKQp.png (http://imagizer.imageshack.com/img540/3259/6YuKQp.png)
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: rob77dp on March 28, 2015, 05:42:51 AM
Kirby thank you so much for your help.

Here are links to see screenshots of my current card collection:

http://imagizer.imageshack.com/img540/8664/9mneym.png (http://imagizer.imageshack.com/img540/8664/9mneym.png)
http://imagizer.imageshack.com/img540/3259/6YuKQp.png (http://imagizer.imageshack.com/img540/3259/6YuKQp.png)

Ummmmm, I think your first screenshot may have errors in the import or tracking... several hundreds of the Marks??  0.o Does not seem realistic.
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: Savage on March 28, 2015, 07:54:01 AM
No, it is correct, it added correctly
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: iancudorinmarian on March 29, 2015, 06:14:38 PM
No, it is correct, it added correctly
I really don't believe you have THAT many marks...
Title: Re: Elements Card Tracking Spreadsheet 1.324
Post by: ddevans96 on March 29, 2015, 09:03:11 PM
He interpreted 'Mark of Entropy' as 'Total Entropy Cards', and same for the other elements. Notice how the totals all match.

Savage, Mark of Entropy means this: . Marks are extremely rare cards that can only be obtained from winning tournaments and some other PvP events.
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on September 03, 2015, 10:11:29 AM
Updated the tracking sheet :)

The Sell tab used to take ages to calculate by relying on some slow scripts to run. That has been totally revamped and is lightning fast now thanks to Google finally allowing 12+ conditional formatting rules for cels. The Score sheet includes some bug fixes. A few more tweaks have also been made and the sheet should be current with 1.327 completely.

Grab the latest sheet from here:
http://dek.im/tracker

And remember, it's very easy to get the sheet filled in with all your information using:
http://dek.im/import

Thanks for your support everyone! Be sure to vote for the tracking sheet and let me know if you run into any issues.
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on September 13, 2015, 07:46:18 AM
Fixed the Deck Cost tool
http://dek.im/tracker
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on October 25, 2015, 06:17:38 PM
Sell tab fixed to give proper sell values for unupgraded cads when you have more than 6 upgraded cards
Score tab fixed to show a max of 99% to next level when score value is very close to the next level

Grab the latest sheet from here:
http://dek.im/tracker

And remember, it's very easy to get the sheet filled in with all your information using:
http://dek.im/import
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on October 26, 2015, 03:55:28 AM
Score tab upgraded to now show levels past 80, intelligently changing as you progress farther past 81, etc.
Currently this maxes out at 107 for no particular reason, but since that would be 44,689,020 score this shouldn't be a problem
Percentages on the Score tab now show 1 decimal point

Grab the latest sheet from here:
http://dek.im/tracker

And remember, it's very easy to get the sheet filled in with all your information using:
http://dek.im/import
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: kirbylover314 on December 07, 2016, 01:09:22 AM
Is there a way to make the Sell tab ignore Relics? I like stashing them
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: antiaverage on December 07, 2016, 02:23:32 AM
Is there a way to make the Sell tab ignore Relics? I like stashing them

I mean the Sell tab is just recommending what to sell, doesn't mean you have to. Any reason simply ignoring that line by yourself isn't sufficient?
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: kirbylover314 on December 07, 2016, 03:00:27 AM
Is there a way to make the Sell tab ignore Relics? I like stashing them

I mean the Sell tab is just recommending what to sell, doesn't mean you have to. Any reason simply ignoring that line by yourself isn't sufficient?

Not really, just thought it would be nice since Relics are the only "common" card that gets listed in the Sell tab.
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: Leodip on July 02, 2018, 09:05:23 AM
I cannot import my collection anymore with the import function, for some reason. I think it's because of having recently gotten 2 Holy Cows (from Plat). How can I solve this?

I was thinking of removing manually Holy Cow from the decka when I import it: does someone know how data is stored in the decka?
Title: Re: Elements Card Tracking Spreadsheet 1.327
Post by: Naii_the_Baf on July 02, 2018, 03:12:00 PM
I cannot import my collection anymore with the import function, for some reason. I think it's because of having recently gotten 2 Holy Cows (from Plat). How can I solve this?

I was thinking of removing manually Holy Cow from the decka when I import it: does someone know how data is stored in the decka?

Data in the decka is stored like this:

There are seven digits by card. The first four are an ID, and the following three are the amount you have. The ID is generated by converting the card code, in Base32, to Base10, and then substracting 5000 from the resulting number.}

For Holy Cow, the code is 5lt, which is converted to 5821. As such, Holy Cow's ID is 0821. Since you said that you have 2 Holy Cows, the other three numbers should be 002.

You should look up 0821002(only 0821 is really needed, but I added 002 for reference, since you also need to delete the next three digits after the ID) and remove it. Your decka should be free of Holy Cows now.
blarg: suxerz,serprex,CuCN,antiaverage