I've created this spreadsheet for my own use, but I thought some users here might find it useful.
https://spreadsheets.google.com/spr...dyK3CdHdxRUczU0lZeGt0MElkdk5oZXd3YVE&hl=en_GB
If you list the Pokémon in your dex, it generates a detailed collection of statistics on their type distribution, and the distribution of Pokémon from each generation. I've also added capability for it to work with your own Fakémon on the fly, but I haven't tested it completely, so if it breaks down, please let me know; the forked Fakémon workaround is especially ugly, so please ask for help if you need it.
Feel free to play with the public version, but please make a copy of it if you want to use it so that your work doesn't get overwritten. If you want some info on how it works, unhide the "Data" sheet; I've added some notes there which might help, or they might baffle you even more.
I'm sure this is an inefficient way of doing things, but it seems to work. If you ignore most of the notes and just list your Pokémon, it should help you balance them.
https://spreadsheets.google.com/spr...dyK3CdHdxRUczU0lZeGt0MElkdk5oZXd3YVE&hl=en_GB
If you list the Pokémon in your dex, it generates a detailed collection of statistics on their type distribution, and the distribution of Pokémon from each generation. I've also added capability for it to work with your own Fakémon on the fly, but I haven't tested it completely, so if it breaks down, please let me know; the forked Fakémon workaround is especially ugly, so please ask for help if you need it.
Feel free to play with the public version, but please make a copy of it if you want to use it so that your work doesn't get overwritten. If you want some info on how it works, unhide the "Data" sheet; I've added some notes there which might help, or they might baffle you even more.
I'm sure this is an inefficient way of doing things, but it seems to work. If you ignore most of the notes and just list your Pokémon, it should help you balance them.