• Our software update is now concluded. You will need to reset your password to log in. In order to do this, you will have to click "Log in" in the top right corner and then "Forgot your password?".
  • 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
14
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.
     

    Agent_0042

    6
    Posts
    13
    Years
    • Seen May 8, 2013
    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

    A Cruciform Kaleidoscope
    91
    Posts
    12
    Years
    • ... 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

    485
    Posts
    14
    Years
    • 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.
     

    Agent_0042

    6
    Posts
    13
    Years
    • Seen May 8, 2013
    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