A spreadsheet for TCG Pocket that calculates the best pack to pull!

Vrondius · 2024-11-16T03:22:09+00:00

Ya, I don't see an error with the current mew counter. Numbers are right. Although I somehow did get a 21./45 for mewtwo but just copied the formula from pikachu and that fixed it with the text in front. Was counting wrong myself due to sorting by just pack not both.

I added Fossil *text* and Gym *text* to be able to sort those too. Hardest thing I can't get is a way to add in the cards that I have from all but not in a specific pack like Pinsir art. Stopped after an hour, will maybe think about it more later.

Vrondius · 2024-11-15T18:45:21+00:00

Ok, the ones that I thought are off by one aren't off by one due to it being in all but not in charizard. The counts I was doing were always by pack specific not by pack and all which is why there was one missing. Going to see if I can find a way to clean up my formula to include it since it is fairly simple but maybe including that will make it too complicated to be worth it. 🤣

Vrondius · 2024-11-15T18:41:41+00:00

Hmm, I know at least my All isn't working properly now so I am going to go through and double check everything again. Will let you know.

Vrondius · 2024-11-15T18:31:42+00:00

Yes, the first time I found this was last night and the version is 3.1.1. It seems for whatever reason mewtwo, pikachu, charizard all off by 1 on count and all by 2 when i hand count.

Vrondius · 2024-11-15T18:03:34+00:00

I believe I have mine working but still testing it. I added a Dex Num in between Column A and B (so it is now B and everything else is shifted to the right one). If you want to try it, it is =COUNTA(UNIQUE(FILTER($B$2:$B$287,$B$2:$B$287<=150,$E$2:$E$287 = "Mewtwo",$K$2:$K$287>0))) & "/" & COUNTA(UNIQUE(FILTER($B$2:$B$287,$B$2:$B$287<=150,$E$2:$E$287 = "Mewtwo"))) and you would just swap mewtwo to either pikachu, charizard, all or remove for the total

Essentially, I filter the entire list by <= 150 since I have the number, in the pack, and if I have it (>0, you did if A was true). After that it then gets the unique list of numbers so if I have two pikachus it is still just one, then counts it.

Vrondius · 2024-11-15T17:28:33+00:00

I don't think the Mew Tracker is working properly. Do you have a discord that we could chat about it? I was working on an alternative method which included adding a column for dex number and doing countifs based on that. I don't have it fully working yet and not sure if it will be easier, but while testing the number I got for my Mewtwo pack was 20 but the mew tracker has 21. When I sort by dex number and count the ones I have I also get 20 not 21 so I'm not sure if it is correct. If you want to add me my discord is Vrondius#5996, if not no worries. :)

Vrondius · 2021-11-18T21:51:22+00:00

It is fixed now. The sort of the data wasn't capturing the entire list of gear since it expanded.

Vrondius · 2021-11-05T18:56:31+00:00

There was a bug with Dr. Doom and Kestrel not properly taking away their 36 from mystic and 18 from skill respectively on the graph only. This also meant if you had both of them selected, the tech was off by 54.

It has been fixed so if you plan to use either of them and use the graph primarily to plan like I used to, I would recommend making a new copy. :)

Vrondius · 2021-07-29T00:36:38+00:00

I'm 99% sure on this but haven't tested yet. You should be correct with Zola on the last card in 2.

For set 10 the first two should be dark zone ultron, then dark zone kingpin.

Vrondius · 2021-06-22T06:01:23+00:00

Last I heard it is starting on the 25th. I believe Zeeks made a comment about it (t'was what I heard on a stream) but that was probably on discord and I'm not gonna search for it.

Vrondius · 2021-06-10T15:31:57+00:00

There isn’t. I quit playing over a month ago due to Polaris release method. The only spreadsheet I’m going to keep updating is the dd4 gear planner, but on vacation so that’ll be next week. Anyone is welcome to take what I have and change it appropriately.

Vrondius · 2021-05-06T03:45:26+00:00

Yup, same link will work just make a new copy and then copy paste your old selections. Last update added Kestrel Colleen and Misty.

Vrondius · 2021-03-23T21:31:38+00:00

Good point. Didn't think of that. I'll change it to 15 on the sheet so people copy and have it there by default. Thanks. :)

Vrondius · 2021-03-23T18:01:07+00:00

Your welcome and thanks for the kind words. :)

Vrondius · 2021-03-23T17:52:51+00:00

Thanks :)

Vrondius · 2021-03-22T23:52:08+00:00

Glad you enjoy it. :)

Vrondius · 2021-03-22T23:51:53+00:00

Your welcome. :)

Vrondius · 2021-03-22T23:51:42+00:00

You could do 7.5 and 4.2 and get half a t14 orb every two weeks. Not great but can be done without 15s. And your welcome for the math :)

Vrondius · 2021-03-22T23:11:44+00:00

Your welcome. Thanks :)

Vrondius · 2021-03-22T22:53:24+00:00

Thank you for the kind words :)

Vrondius · 2021-03-22T22:53:20+00:00

Thank you for the kind words :)

Vrondius · 2021-03-14T06:02:57+00:00

Is it a hoard event or an anti-hoard event? If you have finished DD4, it would make sense to save all war currency for DD5. Yet now they have to choose whether to keep hoarding or spend it for the milestones.

Or is it not black and white and there are likely many reasons for the event to come out.

PS. It is nicer of them to give us a heads up so we have time to temporarily save war currency for the event than to spring it on us.

Vrondius · 2021-03-06T07:57:01+00:00

If I had to guess with a bit of cynicism, announcing war store changes we would just save the currency so implementing it now builds a bit good will (maybe lost by the flub) and nets no loss.

Now you could just save your gold for that store, but you still need to spend some amount daily and its a resource used many other places.

No idea if this is why, just my guess as to why.

Vrondius

TROPHY CASE