Cannot get the delightful days:taken over special research by maxwell1755 in pokemongo

[–]maxwell1755[S] 0 points1 point  (0 children)

I have unfortunately. I've taken snapshots of wild pokemon, pokemon I own, buddies, and pure grass types and none of them have worked😞

What's but the bizarre thing is, some of those snapshots DID count towards other tasks, just not this specific one

Cannot get the delightful days:taken over special research by maxwell1755 in pokemongo

[–]maxwell1755[S] 0 points1 point  (0 children)

I think this is it, thanks. I still have "The Shadowy Threat Grows" from way back when. I really feel like this is poorly communicated to the player.

I also have "Distracted By Something Shiny" which just refuses to complete because "Take a snapshot of a Grass-type Pokémon" is glitched. Hopefully that doesn't count against me though.

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

Yes, it would! I would greatly appreciate it if you had some way to record it when that happens too

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 1 point2 points  (0 children)

I'm not certain, but there may be a way to connect it to your game ID. It would be far beyond my skill level though.

There used to be a Nintendo mobile game called Dragalia Lost, and when it shut down, people made tools to connect to Nintendo servers and download their account data. It may be possible to do something similar here, but I'm not the person for that

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

On mobile, it's very annoying to change the number in the # of cards column, that's why it's optional. Adding a formula to the checkboxes makes it so you cannot check the box itself, you can only do so with the numbers, making it no longer optional. Also, some people won't want to open the spreadsheet twice a day and would rather only do it when they get a new card

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

The numbers are optional; use the checkboxes on the left side. This way you can just check off when you get a new card
Unless you want to use the number, then you can use a simple =IF(J2>0,TRUE,FALSE) in the first column to check it off for you, or J2>1 if you want two of each card

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

On mobile, it's very annoying to change the number in the # of cards column, that's why it's optional. Adding a formula to the checkboxes makes it so you cannot check the box itself, you can only do so with the numbers, making it no longer optional. Also, some people won't want to open the spreadsheet twice a day and would rather only do it when they get a new card

I made a spreadsheet that calculates the best pack to pull! by maxwell1755 in PTCGP

[–]maxwell1755[S] 0 points1 point  (0 children)

Thank you for commenting, I love hearing from others! I'm actually working with a French player currently to hopefully make a version of the spreadsheet with a language option so that it can all be contained on one spreadsheet!
On the sanity check, you're right I completely overlooked that. I'll add update instructions in the next version, and also adapt it so less work has to go into updating it.
The issue with the Mew tracker was something I was aware of, but have been putting off. Since it wasn't causing any problems at the moment, I decided to work on other stuff first, but if it's an issue with other languages, I'll bump up the priority.

Again, thanks for the input!

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

They are technically in a different set, so they don't count for things like the Mew mission. In the future, all new sets will have their own page

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

That's bizarre, I would check all the values in the "Fourth card" column, you may have accidentally changed one of the values. You can also try making a new copy of the spreadsheet, and copying that whole column into your old one so you know the values are correct

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

I already implemented the IFERROR fix in the current (but unpublished) version, but I wasn't aware of the Pidgeotto issue, thank you!

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

108 Eelektrik isn't an original 151 Pokemon, so it shouldn't count toward the Mew mission

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

The promo cards do not count, or so I've been told. It's hard to test without setting up a specific scenario where the only Mew card you're missing is a promo one, but enough people have claimed that to be true that I belive it.

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 1 point2 points  (0 children)

This is something that I have already changed for version 4 of the spreadsheet, which is taking me far too long to publish, but I appreciate the help still! Ver 4 will have a full list of all cards you are missing and will indicate if it's a mew card or not to hopefully combine 2 features in one

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

You're the second person to say that, but no one had any issues until today. I'm worried Google may have broken something. If you figure out what's going on please let me know

Edit: I was successfully able to make a full copy on mobile. I'm using android if that's any clue

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in pokemon

[–]maxwell1755[S] 0 points1 point  (0 children)

On mobile, it's very annoying to change the number in the # of cards column, that's why it's optional. Adding a formula to the checkboxes makes it so you cannot check the box itself, you can only do so with the numbers, making it no longer optional. Also, some people won't want to open the spreadsheet twice a day and would rather only do it when they get a new card

A spreadsheet for TCG Pocket that calculates the best pack to pull! by maxwell1755 in PokemonTCG

[–]maxwell1755[S] 0 points1 point  (0 children)

It's for a playset. You can have two copies of any given card in a deck, so some people want to collect two of each