• Just a reminder that providing specifics on, sharing links to, or naming websites where ROMs can be accessed is against the rules. If your post has any of this information it will be removed.
  • Ever thought it'd be cool to have your art, writing, or challenge runs featured on PokéCommunity? Click here for info - we'd love to spotlight your work!
  • PokéCommunity's Easter Egg Hunt is now on! If you're interested in looking for some eggs and earning badges, click here!
  • Our weekly protagonist poll is now up! Vote for your favorite Conquest protagonist in the poll by clicking here.
  • Welcome to PokéCommunity! Register now and join one of the best fan communities on the 'net to talk Pokémon and more! We are not affiliated with The Pokémon Company or Nintendo.
    Register

Dex Balancing Spreadsheet

NikNaks

    • 485
    Posts
    15
    Years
    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.
     
    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.
     
    ... 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.
     
    Minezumi said:
    Yeah! They'll love this! I know I did!

    Amazing, bro.
    Click to expand...

    Thanks! :3

    Agent_0042 said:
    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.
    Click to expand...

    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)?

    cruciFICTION said:
    ... 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.
    Click to expand...

    Haha, thanks! :3 I'd be interested to see yours, though, if you think you have any interesting parts I could use.
     
    NikNaks said:
    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)?
    Click to expand...

    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.
     
    You must log in or register to reply here.
    Back
    Top