ATTENTION! UPDATE FOR PLATINUM ON PAGE 3!
Today, I bring to you a group of useful Pokemon utilities made in Microsoft Excel. I have named this the "Pokemon Resource" because I have hopes of it becoming the ultimate Pokemon resource that no aspiring Trainer should be without.
This started as a pet project of mine. I was (and still am) not very good at recalling specific numbers in the heat of battle. I wanted to make something that would make it so that I wouldn't ever have to memorize particular numbers.
It all started with a table of Base Stats. I thought it would be a great idea to have the stats of all Pokemon at my fingertips. I was also compelled to allow customizable spreads for each Pokemon and organize those stats as I wished. For a long time in its development, this table also had columns for Dragontamer's Attack and Defense Tiers. I may decide to put those back in for a future release.
Then, I wanted a Stat calculator. Yes, the table of Base Stats could calculate stats, but that table is large and cumbersome for such a task. I wanted to be able to look at the stats of one Pokemon at a time. That's what the Stat Calculator enables you to do.
Finally, after deciding between several other useful functions to put in, I decided to take on the greatest challenge: my pride and joy, the damage calculator.
Metalkid's calculator is among the most user-friendly out there, but there is still more that it can do. I eventually got tired of memorizing the power of Grass Knot on particular Pokemon. Other moves in that calculator are also not functional.
Therefore, I wanted to make a calculator that had the user-friendliness of Metalkid's, but was also functionally better than Metalkid's. To have each and every single move worth accounting for fully functional; that was my dream. But I'm too old! I can't do it anymore! (Just kidding.)
I encountered many setbacks in the production of the damage calculator. I even had to redo the entire damage formula because of a few mistakes! (Believe me, the damage formula used to be over 8000 characters long! Even Excel 2007 couldn't handle the entire formula! I had to put it all in two cells!) Now, the damage calculator works great, and I have included with it the actual damage formula so that users can learn exactly how damage is calculated. It also makes it easier for me to make changes to the formula, if need be, and for you to check my work!
Well, I certainly drew that one out too long. Time for what you came here for.
I have included in this thread screenshots of the file itself so that you know what you're getting yourself into.
--Screenshots (from Excel 2007)
Base Stats Table (the main part of the resource)
Stat Calculator
Damage Calculator (part 1)
Damage Calculator (part 2 - damage display)
Damage Calculator (part 3 - damage formula)
Lookup Tables (part 1)
Lookup Tables (part 2 - move table)
Lookup Tables (part 3 - item table)
Lookup Tables (part 4 - type effectiveness chart)
Now for the file.
--Downloads
Pokemon Resource 1.0 (Excel 2007 version) - 236.58 KB (original version)
Link 1 (30 second wait)
Link 2 (no wait; file comes Zipped--used to, anyway)
Pokemon Resource 1.0 (Excel 2003 version) - 588.5 KB
Link 1 (c/o 2shared; download link will appear at the bottom of the page within seconds)
Link 2 (no wait; file comes Zipped--used to, anyway)
(Someone PLEASE check the functionality of this version! Excel 2003 is greatly limited in relation to 2007, thus I had to change around some things to make the damage formula work. I've had little time to test it.)
Anyway, a lot of stuff is explained in the instructions that come with the resource. If you have any other questions, please post here or PM me. (Contact information for the lurkers coming later.)
Enjoy!
File history:
(Coming later as needed)
NOTICE! (3/15 1:15 AM CDT) I just noticed that I forgot to factor in the ability Forecast into the Damage Calculator! It's not a problem, though, because if you need to use a Forecast Pokemon in your calculations, use the cell for Color Change to put in its type. It should still work in the same manner. Remember, the type of a Forecast Pokemon is:
Fire in the Sun.
Water in the Rain.
and
Ice in the Hail.
(No, its type does not change in Sandstorm.)
Otherwise, its type is the same as it usually is.
NOTICE! (3/16 5:32 PM CDT) Sandstorm is increasing the Defense of Rock types for PHYSICAL attacks! This is a simple fix, though. Just replace the contents of cell N85 (N87 in the 2003 version) in the Damage Calculator worksheet with the following (fix is Bolded):
=IF(AND(L28="Sandstorm",VLOOKUP(C26,Table2,3,FALSE)="Special",OR(VLOOKUP(M2,'Lookup Tables'!A3:D500,3,FALSE)="Rock",VLOOKUP(M2,'Lookup Tables'!A3:D500,4,FALSE)="Rock",AND(ISTEXT(M10),M10="Rock"))),1.5,1)
Table2 in the 2003 version is the cell range 'Lookup Tables'!$I$3:$N$280.
This will be fixed in the next update.
NOTICE! (3/28 3:51 PM CDT) There is an error in the formula for the move Facade. It's doubling in power when the OPPONENT has the required statuses. >< I'll have it fixed for the next update, which should be whenver I can get enough free time.
Today, I bring to you a group of useful Pokemon utilities made in Microsoft Excel. I have named this the "Pokemon Resource" because I have hopes of it becoming the ultimate Pokemon resource that no aspiring Trainer should be without.
This started as a pet project of mine. I was (and still am) not very good at recalling specific numbers in the heat of battle. I wanted to make something that would make it so that I wouldn't ever have to memorize particular numbers.
It all started with a table of Base Stats. I thought it would be a great idea to have the stats of all Pokemon at my fingertips. I was also compelled to allow customizable spreads for each Pokemon and organize those stats as I wished. For a long time in its development, this table also had columns for Dragontamer's Attack and Defense Tiers. I may decide to put those back in for a future release.
Then, I wanted a Stat calculator. Yes, the table of Base Stats could calculate stats, but that table is large and cumbersome for such a task. I wanted to be able to look at the stats of one Pokemon at a time. That's what the Stat Calculator enables you to do.
Finally, after deciding between several other useful functions to put in, I decided to take on the greatest challenge: my pride and joy, the damage calculator.
Metalkid's calculator is among the most user-friendly out there, but there is still more that it can do. I eventually got tired of memorizing the power of Grass Knot on particular Pokemon. Other moves in that calculator are also not functional.
Therefore, I wanted to make a calculator that had the user-friendliness of Metalkid's, but was also functionally better than Metalkid's. To have each and every single move worth accounting for fully functional; that was my dream. But I'm too old! I can't do it anymore! (Just kidding.)
I encountered many setbacks in the production of the damage calculator. I even had to redo the entire damage formula because of a few mistakes! (Believe me, the damage formula used to be over 8000 characters long! Even Excel 2007 couldn't handle the entire formula! I had to put it all in two cells!) Now, the damage calculator works great, and I have included with it the actual damage formula so that users can learn exactly how damage is calculated. It also makes it easier for me to make changes to the formula, if need be, and for you to check my work!
Well, I certainly drew that one out too long. Time for what you came here for.
I have included in this thread screenshots of the file itself so that you know what you're getting yourself into.
--Screenshots (from Excel 2007)
Base Stats Table (the main part of the resource)
Stat Calculator
Damage Calculator (part 1)
Damage Calculator (part 2 - damage display)
Damage Calculator (part 3 - damage formula)
Lookup Tables (part 1)
Lookup Tables (part 2 - move table)
Lookup Tables (part 3 - item table)
Lookup Tables (part 4 - type effectiveness chart)
Now for the file.
--Downloads
Pokemon Resource 1.0 (Excel 2007 version) - 236.58 KB (original version)
Link 1 (30 second wait)
Link 2 (no wait; file comes Zipped--used to, anyway)
Pokemon Resource 1.0 (Excel 2003 version) - 588.5 KB
Link 1 (c/o 2shared; download link will appear at the bottom of the page within seconds)
Link 2 (no wait; file comes Zipped--used to, anyway)
(Someone PLEASE check the functionality of this version! Excel 2003 is greatly limited in relation to 2007, thus I had to change around some things to make the damage formula work. I've had little time to test it.)
Anyway, a lot of stuff is explained in the instructions that come with the resource. If you have any other questions, please post here or PM me. (Contact information for the lurkers coming later.)
Enjoy!
File history:
(Coming later as needed)
NOTICE! (3/15 1:15 AM CDT) I just noticed that I forgot to factor in the ability Forecast into the Damage Calculator! It's not a problem, though, because if you need to use a Forecast Pokemon in your calculations, use the cell for Color Change to put in its type. It should still work in the same manner. Remember, the type of a Forecast Pokemon is:
Fire in the Sun.
Water in the Rain.
and
Ice in the Hail.
(No, its type does not change in Sandstorm.)
Otherwise, its type is the same as it usually is.
NOTICE! (3/16 5:32 PM CDT) Sandstorm is increasing the Defense of Rock types for PHYSICAL attacks! This is a simple fix, though. Just replace the contents of cell N85 (N87 in the 2003 version) in the Damage Calculator worksheet with the following (fix is Bolded):
=IF(AND(L28="Sandstorm",VLOOKUP(C26,Table2,3,FALSE)="Special",OR(VLOOKUP(M2,'Lookup Tables'!A3:D500,3,FALSE)="Rock",VLOOKUP(M2,'Lookup Tables'!A3:D500,4,FALSE)="Rock",AND(ISTEXT(M10),M10="Rock"))),1.5,1)
Table2 in the 2003 version is the cell range 'Lookup Tables'!$I$3:$N$280.
This will be fixed in the next update.
NOTICE! (3/28 3:51 PM CDT) There is an error in the formula for the move Facade. It's doubling in power when the OPPONENT has the required statuses. >< I'll have it fixed for the next update, which should be whenver I can get enough free time.