1. We have moved to a new forum system. All your posts and data should have transferred over. Welcome, to the new Serebii Forums. Details here
    Dismiss Notice
  2. Be sure to join the discussion on our discord at: Discord.gg/serebii
    Dismiss Notice
  3. If you're still waiting for the e-mail, be sure to check your junk/spam e-mail folders
    Dismiss Notice

Pokemon Builder and Pokemon Creator (Excel)

Discussion in 'Past Pokémon Generations Discussion' started by Metroid345, Sep 1, 2009.

Thread Status:
Not open for further replies.
  1. Metroid345

    Metroid345 Active Member

    I wasn't exactly sure where to put this. This seemed like thee best place to place it. If there is a better place, I would very much appreciate it if a Mod moved this to a more fitting place. Thank you.

    TeamBuilder:

    http://www.mediafire.com/?wigmzjmtung

    TeamCreator:

    http://www.mediafire.com/?amznddgzdzy

    The Team Builder allows you to pick a team of six pokemon, and then it lists your teams overall weakness and strengths in a large chart above your pokemon team.

    The Creator allows you to create a team quickly and then when you switch to the "Formatted" worksheet, your team is made and you can easily copy and paste it. Your team will be formatted to be like this:

    Code:
    [I]Pokemon@Item
    Nature
    Ability
    IV/IV/IV/IV/IV/IV
    EV/EV/EV/EV/EV/EV--Total=???/510
    Move1
    Move2
    Move3
    Move4[/I]
    
    I'll try to post some pictures of these later.
    Please make me aware of any mistakes, or anything else I could do to make these files better.

    EDIT:
    Sorry for being very vague about the Team Builder.
    It lists type weaknesses. Like for example, it will list how many of your pokemon are 2x weak to Fire. Or it will list how many of your pokemon are only affected by Ghost by 1/4 damage. That sort of stuff. You can easily see all of it in the chart.

    By the way, forgot to mention this, but if anyone uses the data in the Team Builder for their own purposes, please give me credit. I filled in all that data by myself. It took me a very long time, so I would appreciate it the credit. Thank you.

    EDIT (screenshots):
    ---
    Pokemon Team Builder screenshots:

    [​IMG]
    http://img199.imageshack.us/img199/5797/pb1l.png

    [​IMG]
    http://img7.imageshack.us/img7/6946/pb2r.png

    [​IMG]
    http://img7.imageshack.us/img7/6562/pb3.png

    ---
    Pokemon Team Creator Screenshots:

    [​IMG]
    http://img168.imageshack.us/img168/6430/pc1.png

    [​IMG]
    http://img199.imageshack.us/img199/7418/pc2a.png

    [​IMG]
    http://img168.imageshack.us/img168/4645/pc3v.png

    ---
    For those of you who are still new of Microsoft Excel, here is a picture on how to navigate between worksheets:

    http://img168.imageshack.us/img168/6200/tabsg.png


    EDIT (09-06-09):

    Pokemon Creator Version 1.1:
    Thanks to a suggestion made by RB Golbat of Smogon.com, I have added a simple Stats calculator on the main page of the Pokemon creator. It's located right below where you type in the Pokemon's IV's and EV's. It's just one simple row in the Excel file that gives you a quick look at your final stats (at the level you've selected) of your pokemon in the order HP-Attack-Defense-Special Attack-Special Defense-Speed. Also added was the ability to select multiples of 4 in the cells meant for EV's through a dropw-down list. Base Stats of the pokemon are also shown, right above the pokemon's IV's.

    Pokemon Creator 1.1:
    http://www.mediafire.com/?sharekey=ca4ae0d2f271e39bd1014a7a667fa2b4e04e75f6e8ebb871
     
    Last edited: Oct 6, 2009
  2. oooo

    oooo Well-Known Member

    What kind of strenths and weaknesses does it list? Types, or actual threats to your team?
     
  3. Metroid345

    Metroid345 Active Member

    Sorry for being very vague about it.
    It lists type weaknesses. Like for example, it will list how many of your pokemon are 2x weak to Fire. Or it will list how many of your pokemon are only affected by Ghost by 1/4 damage. That sort of stuff. You can easily see all of it in the chart.

    By the way, forgot to mention this, but if anyone uses the data in the Team Builder for their own purposes, please give me credit. I filled in all that data by myself. It took me a very long time, so I would appreciate it the credit. Thank you.
     
  4. mattj

    mattj .

    We're you the one that posted this awesome tool on smogon too?
     
  5. Metroid345

    Metroid345 Active Member

    Yes, that would be me. Why do you ask?
     
  6. mattj

    mattj .

    No reason really. Just to say I saw it there too and think it's very useful!
     
  7. Metroid345

    Metroid345 Active Member

    Why thank you :) !
     
  8. Noctourniquet

    Noctourniquet ∆∆∆

    Looks great, but 2 Questions here;
    1. What is the difference between the two? I didnt really get it, sorry....
    2. If I open this in iWork's Numbers, will it get screwed up? >.< I kow it should be compatible, but yeah...
     
  9. Metroid345

    Metroid345 Active Member

    1. The Creator allows you to select your team (what pokemon you want, item, moves, etc.) you want (up to 6 pokemon). Then it automatically formats it for you like this:

    Code:
    [I]Pokemon@Item
    Nature
    Ability
    IV/IV/IV/IV/IV/IV
    EV/EV/EV/EV/EV/EV--Total=???/510
    Move1
    Move2
    Move3
    Move4[/I]
    The Pokemon Builder allows you to view the type weaknesses and strengths of your team. You enter your team (up to 6 pokemon) and it shows the amount of weaknesses and strengths.


    2. I googled your program really quickly, and it said it should be able to save and open Excel files (.xls). Of course I'm not sure what version you have and what it's limitations are.
     
  10. Metroid345

    Metroid345 Active Member

    EDIT

    Pokemon Team Creator version 1.1 added!

    It now contains a simple Stat Calculator, drop-down list for the EVs' cells, and Base Stats for all pokemon.
     
  11. emeraldellie

    emeraldellie Δ Staff Member Admin

    Don't make threads to advertise programs. If you really find it that useful, link to it in your signature.
     
Thread Status:
Not open for further replies.

Share This Page