Post by: antiaverage on October 04, 2013, 11:17:35 pm
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)
Post by: BeefSupreme on October 07, 2013, 04:10:28 am
P.S. You should make that video x) So much to read D:
Post by: Blacksmith on October 21, 2013, 04:19:58 pm
thank you fro making this!
Post by: nireus on October 21, 2013, 10:14:14 pm
Post by: antiaverage on November 18, 2013, 05:46:50 am
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.
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>Post by: eljoemo on November 19, 2013, 04:48:59 am
Copy POST data's 'decka' to prompt. Copy output to Import. Never manually count againCode: [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>
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.
Post by: serprex on November 19, 2013, 06:27:02 am
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
Post by: antiaverage on November 19, 2013, 07:35:58 am
| 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.
Post by: BeefSupreme on November 19, 2013, 10:50:05 pm
Post by: antiaverage on November 20, 2013, 02:31:21 am
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.
Post by: eljoemo on November 20, 2013, 02:52:14 am
Seriously, good job!
Post by: antiaverage on November 22, 2013, 08:21:45 pm
There is also a new sheet to keep track of your score progress.
Enjoy!
Post by: antiaverage on November 22, 2013, 11:55:15 pm
Post by: antiaverage on November 23, 2013, 06:12:29 pm
Post by: antiaverage on December 10, 2013, 02:33:51 am
| 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) |
Post by: nireus on December 10, 2013, 10:01:31 am
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"?
Post by: antiaverage on December 10, 2013, 04:30:13 pm
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?
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)
Post by: Fippe94 on December 10, 2013, 06:36:49 pm
(http://gyazo.com/b652568adc2e96c4dbbfc415515df55c.png)
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)
Post by: Calambar on December 11, 2013, 01:44:17 am
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?
Post by: Akaya on December 14, 2013, 06:31:44 am
Post by: trashduke on July 01, 2014, 09:37:07 pm
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.
Post by: Submachine on July 16, 2014, 11:49:30 am
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.
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.
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:If you provided the code you try to add I can have a look at it.
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.
Post by: trashduke on December 08, 2014, 03:53:27 am
"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.
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*
Post by: antiaverage on January 08, 2015, 04:01:43 pm
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.
Post by: Sera on February 05, 2015, 07:01:39 am
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
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 :PWell, 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.
Post by: Savage on March 27, 2015, 07:30:24 am
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!
Post by: Savage on March 28, 2015, 04:29:01 am
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)
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.
Post by: Savage on March 28, 2015, 07:54:01 am
Post by: iancudorinmarian on March 29, 2015, 06:14:38 pm
No, it is correct, it added correctlyI really don't believe you have THAT many marks...
Post by: ddevans96 on March 29, 2015, 09:03:11 pm
Savage, Mark of Entropy means this:
. Marks are extremely rare cards that can only be obtained from winning tournaments and some other PvP events.
Post by: antiaverage on September 03, 2015, 10:11:29 am
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.
Post by: antiaverage on September 13, 2015, 07:46:18 am
http://dek.im/tracker
Post by: antiaverage on October 25, 2015, 06:17:38 pm
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
Post by: antiaverage on October 26, 2015, 03:55:28 am
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
Post by: kirbylover314 on December 07, 2016, 01:09:22 am
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?
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.
Post by: Leodip on July 02, 2018, 09:05:23 am
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?
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.
Post by: DoctorWho42 on March 31, 2019, 11:49:15 pm
Post by: antiaverage on October 19, 2019, 03:33:37 am
This tool is so cool! ;) Did you make this yourself? It's really impressive!
I started with a simpler sheet that someone else built and then slowly added more tools, features, and improvements. At this point it's been entirely reworked, but it would not have happened with the people I thanked in the original post.
Quote
Special thanks to suxerz for starting this sheet, serprex for bug reports and code, and CuCN for bug reports and code.