KeiruaProd

Pokemon Go is a weird game. The fights are not very interesting, finding Pokemon is not that fun, the daily quests are a bore. And yet, years after the release, I was still playing it because completing the Pokedex is a never ending task and for some reasons I liked that.

When you have caught most of the Pokemons, all that remains is to keep track of the remaining pokemons, and walk in order to gain enough candies in order to make them evolve. You probably won’t meet some of them for a while, and the cycles can be pretty long. In certain cases (many, in fact!) that’s the only option.

Sure, that’s not very fun, but I’ve found it’s not a bad way to ensure I walk ~30km every week.

I use an excel sheet in order to keep track of what I still need to do in the game. I have a list of the Pokemons I need to find (Niantic adds new ones occasionnaly, and some events change the encounter probabilities).

More importantly and way less random, I know how many kilometers I need to walk for the pokemons I have.

The key piece of code is here:

=IF(ISBLANK(F12);"";E12*(D12-F12))

The isblank part is what lets me have a simple spreadsheet where I only fill what I need.

I also color code the results using conditionnal formatting :

• dark green: you still need to walk (walk distance > 0)
• light green: you are done (walk distance <= 0))

My limit is 50km : no more than 2 weeks should be necessary to get a particular Pokemon. Some pokemons require way more, and that’s how I ended-up stopping to play the game.