PDA

View Full Version : Dex Balancing Spreadsheet


NikNaks
August 15th, 2011, 06:48 AM
I've created this spreadsheet for my own use, but I thought some users here might find it useful.

https://spreadsheets.google.com/spreadsheet/ccc?key=0AsfrGMVdyK3CdHdxRUczU0lZeGt0MElkdk5oZXd3YVE&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.

Minezumi
August 15th, 2011, 07:06 AM
Yeah! They'll love this! I know I did!

Amazing, bro.

Agent_0042
August 15th, 2011, 09:50 AM
This is incredibly useful. It would be nice if the sheet could also keep track of the types of all fully-evolved 'mons, though I don't know how difficult this would be to implement.

cruciFICTION
August 15th, 2011, 11:18 AM
... Creepy. I've made one of these myself and was thinking about refining it and uploading it. 0.0

Yours is a lot nicer than mine, though.

NikNaks
August 16th, 2011, 03:34 AM
Yeah! They'll love this! I know I did!

Amazing, bro.

Thanks! :3

This is incredibly useful. It would be nice if the sheet could also keep track of the types of all fully-evolved 'mons, though I don't know how difficult this would be to implement.

How do you mean? Ignore lower evolutions and just use the final one? That'd be tricky, certainly, and I'm not sure a spreadsheet is built for something like that - the way I've handled evolutionary lines is incredibly suspect as it is. xD I'll give it a go, though. Maybe I can do some trickery. Would you expect forked evolutions to all count (Gallade and Gardevoir both appearing, for instance)?

... Creepy. I've made one of these myself and was thinking about refining it and uploading it. 0.0

Yours is a lot nicer than mine, though.

Haha, thanks! :3 I'd be interested to see yours, though, if you think you have any interesting parts I could use.

Agent_0042
August 16th, 2011, 09:04 AM
How do you mean? Ignore lower evolutions and just use the final one? That'd be tricky, certainly, and I'm not sure a spreadsheet is built for something like that - the way I've handled evolutionary lines is incredibly suspect as it is. xD I'll give it a go, though. Maybe I can do some trickery. Would you expect forked evolutions to all count (Gallade and Gardevoir both appearing, for instance)?

Pretty much. An easy but ham-handed way to do it would be to add an IsFullyEvolved column to the 'mon listings, but I'm not really sure if there's a more elegant solution.

NikNaks
August 16th, 2011, 09:11 AM
Pretty much. An easy but ham-handed way to do it would be to add an IsFullyEvolved column to the 'mon listings, but I'm not really sure if there's a more elegant solution.

That's what I was thinking. I'll add it later. :D

NikNaks
August 22nd, 2011, 04:16 AM
I haven't added that functionality yet, but has anyone else been trying it out?