Advanced National Pokedex Tracker Spreadsheet

Started by Rourke November 16th, 2015 4:55 AM
  • 54170 views
  • 10 replies
Male
Seen May 29th, 2016
Posted November 27th, 2015
11 posts
7.5 Years
Major update. Click here for more details!

Throughout the last few weeks I've spend many hours on crafting this spreadsheet to keep track of all my Pokemon caught. My demands are high and you'll see that in the spreadsheet. It is *loosely* based on this spreadsheet from Zifendale on Reddit. I say loosely because I stripped most information and only kept that which I thought would be necessary for a fast but enjoyable completion.

This spreadsheet aims to be a tool for people with Pokemon OR/AS, and access to Pokemon X or Y. These games can almost catch every Pokemon.

Find it here! Click here to make a copy for yourself.



Features:
  • Using color indication and sprites to process and go through all the data faster. I made it look appealing which I consider just as important as functionality.
  • Rows are green. If marked as caught the row turns grey. Green/red for the Yes/No columns for OR/AS and X/Y.
  • Direct links to Bulbapedia.
  • Dropdown menu's for all relevant Yes/No options.
  • Statistics! I consider this a great feature. It has Progress Data, Evolving data, an Evolve Items Breakdown, lots of other information, and much more.
  • Predefined filter lists
  • Forms tracker (work in progress)
  • A sidebar with a generations jump list and a search function
  • A special tools menu to reset all data, jump to a specific pokemon number etc.
  • Some basic settings

I'm planning to make an import/export function that also supports pokechecklist.com. This allows to easily update to a new version and just transfer all your data to the new version.

If you use this spreadsheet I'd like to know you do. Feel free to drop a comment, or give me some feedback I can work on.

Blueredemption

Never stop exploring!

Age 24
Male
Seen October 5th, 2022
Posted January 4th, 2021
478 posts
9.7 Years
Alright this thing is awesome, full props to you man! I wish I had this when I was going through the blunt of my quest. It would have been so much easier. I mean, there is a link of how I kept track in my description, if you need a reference of how to do it the neanderthal way :3

The statistics page is what makes the cake though, like the triple flavor frosted cherry on top :D

Edit: according to this I am 98% done, pshh.
Male
Seen May 29th, 2016
Posted November 27th, 2015
11 posts
7.5 Years
Alright, here is a major update.

First of all I added a Transfer column.
If you catch Pokémon in X/Y you want to transfer to Pokémon OR/AS can mark these Pokémon as transferable. Why? You can use a new filter to see which Pokémon need to be transfered, and it prevents catching the same Pokémon twice in multiple games.

Forms

Still work in a progress, but you get the idea. It's for the ultimate collectors amongst us ;)
Ofcourse this will be included in the statistics tab. Keep in mind this is still work in progress since it takes a lot of time to make this tab.

More statistics
Because why not? I'll let the images speak for themselves :)



Pokédex Tools menu

These contain some handy functions. Use the reset option if you just made a copy and want to start with a clean sheet.

Sidebar
This is something I put a lot of hours in and consider one of the most awesome features. You can jump straight to generations or search Pokémon. You can easily change Caught or Transfer status by clicking the individual options.




Settings
Some basic settings. Planning to expand them in the future to give it more flexibility.


If you use this spreadsheet I'd like to know you do. Feel free to drop a comment, or give me some feedback I can work on.
Age 41
Male
UK
Seen July 9th, 2021
Posted November 20th, 2019
750 posts
8.6 Years
Brilliant spreadsheet, mine was pretty basic on Google Docs this is at another level.

Thanks very much
Pokemon Breeder (2000+ Eggs and counting)
3DS Living National Pokedex: 807/807
Main Series : Gen 1: R/B/Y/Y-VC, Gen 4: SS, Gen 5: W/B2, Gen 6: X/Y/OR Gen 7: Su/Mo/USu
2DS XL Friend code: 3325 - 8383 - 2146 IGN: Nick

Flowerchild

> let's go shopping!

Age 24
She/Her
Hyperspace
Seen 5 Days Ago
Posted July 7th, 2022
8,699 posts
13 Years
Hey, very nice work!
I can't even compare it with my basic two-column spreadsheet!
Thanks for sharing, it's very useful.

Are you per chance working or planning to do a Sun & Moon Update? That would be awesome.

Thanks again!
Hi, please don't revive threads from over 2 months ago. Check the date before you post, okay?
(\__/)
(='.'=)
('')_('')
This Is Bunny. Copy And Paste Bunny Into
Your Signature To Help Him Gain World Domination!!!!
PairFamilyPalArt