1. Welcome to Smogon Forums! Please take a minute to read the rules.
  2. New to the forums? Check out our Mentorship Program!
    Our mentors will answer your questions and help you become a part of the community!

Programming Pokemon Team Builder and Team Creator (Excel)

Discussion in 'Technical Projects' started by Metroid345, Sep 1, 2009.

  1. Metroid345

    Metroid345

    Joined:
    Jul 20, 2006
    Messages:
    9
    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=c...4e75f6e8ebb871


    EDIT (10-14-09):

    Some minor changes to the Pokemon Team Creator and I added some color to the Pokemon Team Builder. I also made it so that if the numbers in any cells in the 400% and 200% columns in the type chart are 2/3 (respectively) or higher, than those cells are highlighted in a darker color.

    Pokemon Team Creator 1.1:
    http://www.mediafire.com/download.php?kniyy5jmjmm

    Pokemon Team Builder 1.1:
    http://www.mediafire.com/download.php?hyziumjmwyx
  2. mathioks

    mathioks

    Joined:
    May 21, 2009
    Messages:
    13
    thanks a lot man, this really helped me out, you did a really good job! :D


    grtz : mathioks!
  3. RBG

    RBG It feels like a perfect night to dress up like hipsters
    is a Super Moderatoris a Smogon Media Contributoris a Site Staff Alumnusis a Smogon IRC AOp Alumnusis a Researcher Alumnusis a Tiering Contributor Alumnusis a Battle Server Moderator Alumnus
    Facebook Manager

    Joined:
    Jan 27, 2008
    Messages:
    3,328
    Somewhere on the team creator page it should show what the Pokemon's stats are with nature, IV, and EVs. Makes it easier to hit magic numbers.
  4. Metroid345

    Metroid345

    Joined:
    Jul 20, 2006
    Messages:
    9
    Thanks for the suggestion. I'll try to incorporate that into the Team Creator at some point.
  5. Blue_Tornado

    Blue_Tornado

    Joined:
    Apr 14, 2009
    Messages:
    3,286
    Q: How is this different than this?
  6. Metroid345

    Metroid345

    Joined:
    Jul 20, 2006
    Messages:
    9
    Exact same idea. In fact, I had the idea of making the Pokemon Team Builder in Excel from using Marriland's Pokemon Team Builder. The differences:

    -Mines is down loadable
    -Mine lacks color or images
    -Mine is an Excel file, not a program/app

    By the way. Pokemon Team Creator 1.1 added to the first post!
  7. Metroid345

    Metroid345

    Joined:
    Jul 20, 2006
    Messages:
    9
    EDIT

    Some minor changes. Pokemon Team Builder 1.1 added. It now features colored columns. And when you have 2/3 or more in a cell in the 400%/200% (respectively) columns, those cells will be highlighted in a darker color.
  8. Crystal_

    Crystal_
    is a Contributor to Smogonis a Past SPL Winner

    Joined:
    Dec 20, 2009
    Messages:
    871
    Kakuna takes neutral damage from ice-types, I suppose. Look at the second and third images.

Users Viewing Thread (Users: 0, Guests: 0)