(Programming) Pokemon Team Builder and Team Creator (Excel)

[Metroid345]

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:

Pokemon@Item
Nature
Ability
IV/IV/IV/IV/IV/IV
EV/EV/EV/EV/EV/EV--Total=???/510
Move1
Move2
Move3
Move4

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:


http://img199.imageshack.us/img199/5797/pb1l.png


http://img7.imageshack.us/img7/6946/pb2r.png


http://img7.imageshack.us/img7/6562/pb3.png

---
Pokemon Team Creator Screenshots:


http://img168.imageshack.us/img168/6430/pc1.png


http://img199.imageshack.us/img199/7418/pc2a.png


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

[mathioks]

thanks a lot man, this really helped me out, you did a really good job! :D


grtz : mathioks!

[RBG*]

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.

[Metroid345]

Originally Posted by Fat RB Golbat

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.

Thanks for the suggestion. I'll try to incorporate that into the Team Creator at some point.

[Blue_Tornado]

Q: How is this different than this?

[Metroid345]

Originally Posted by Fat Blue_Tornado

Q: How is this different than this?

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!

[Metroid345]

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.

[Crystal_]

Kakuna takes neutral damage from ice-types, I suppose. Look at the second and third images.