http://www.megaupload.com/?d=I0K1U1C9
File size should be 944.04 KB; Don't trust anything else.
Important Notes::
I am reaching the excel barrier. Working on the sheet is starting to be slow due to the large amount of calculations that are being done. The pokemon damage calculation has to occur at least 200 times every time the file recalculates. Due to this, I am declaring that all of the major changes to the file have been completed. Minor updates and bug fixes might come later but as of now, this is mostly done.
New metagame sheet version 45
Changes::
Changes::
Changes::
Changes::
Bugs::
The metagame calculator is currently in .ods format. Ods is the format for OpenOffice.org, which is free, open source etc. As soon as I figure out a way to convert the spreadsheet into excel format without breaking it, I will.
The background color of the cells are semi-meaningful. Anything that is light gray is meant to be an option. These can be changed either by directly typing in the value or using a drop down menu, if applicable. Anything that is light blue is a calculation. You can check them out to see whats happening in the cell, but it might be unwise to mess with them if you do not know what you are doing.
Anything on the charts can be changed and, in fact, the calculator allows you to create your own pokemon or moves if you want (Although any novel mechanism, or really any advanced mechanism, will not be implemented).
The background is black because I think it's cool.
Many of the tables are currently taken from the Pokemon Resource by CardOfTheHearts. I am in the process of modifying them for my own needs.
Furthermore, I encourage people to make corrections to the spreadsheet. Many of the attacks that are in the game are not in the spreadsheet due to me simply forgetting about them (Actually because the description of what they do is too long and the script I ran to get the data didn't account for it). I will upload and credit anybody who makes significant improvements to the spreadsheet.
Conclusion::
I am eager to hear some feedback on this. For now, enjoy beating the metagame.
File size should be 944.04 KB; Don't trust anything else.
Important Notes::
I am reaching the excel barrier. Working on the sheet is starting to be slow due to the large amount of calculations that are being done. The pokemon damage calculation has to occur at least 200 times every time the file recalculates. Due to this, I am declaring that all of the major changes to the file have been completed. Minor updates and bug fixes might come later but as of now, this is mostly done.
New metagame sheet version 45
Changes::
- Random fixes which I have forgotten about
- New Damage Tier Sheet
- This is the last mass calculator that I will be doing. You can use a specific attack from a specific pokemon and see how much damage it will do to all of the pokemon that are used in your metagame under various conditions.
- Those numbers for Lickylicky exploding should be correct. Essentially, ghosts and double resists are the only things that survive. Deoxy-A faints 25 times from it.
Changes::
- Random fixes which I have forgotten about
- SPEED CHART!
- There is now a speed chart that will tell you the speed of all of the pokemon in any given tier
- Curse, Dragon Dance, Agility included
- Choice Scarf included
- Minimum, Half and Maximum EV support
- Minimum/Maximum IV support
- Nature Support
- I have outlined the probable combinations of speed boosts, nature boosts, ev boosts etc on top and then ordered them so that the lowest speeds are on the left and the highest speeds are on the right (For mew.. some pokemon can be out of order, like Shuckle, Deoxy-S and Ninjask due to their outlandish speeds)
- I have taken the liberty of highlighting important speed points for the overused metagame. I don't know any speed points for the underused, uber, neverused metagames.
- There is now a speed chart that will tell you the speed of all of the pokemon in any given tier
Changes::
- Fixed the sheet
- The sheet will now complain about macros being run because of the user defined functions that I use to calculate things such as variable base power moves and to do the cascade flooring.
- Goto Tools -> Options -> OpenOffice.org -> Security -> Macro Security and set the security level to Medium or Low.
- Alternatively; Tools -> Options -> OpenOffice.org -> Security -> Macro Security Click the Trusted Sources Tab and add in the folder that you downloaded the spreadsheet as a trusted source
- Changes the look of the spreadsheet a bit
- Deleted the Your Pokemon v2 Sheet.
- This sheet is nothing like what I wanted it to be at this time. Therefore, I removed it. There are plenty of damage calculators which do the exact same thing as this did. Later, when I have more time, I will add it back in as I originally intended it to be.
- Type Effects are now conditionally formatted
- Vertically condensed the spreadsheet.
- Hidden Powers are now added to the attack chart
- Type in Hidden Power <Element> as an attack if you wish to use it. The movesets that are already in the sheet should already have that.
- Hidden Fun Stuff
Changes::
- The Your pokemon damage calculator has been completely redone and is now Your Pokemon Version 2.0
- The Metagame damage Calculator has been completely redone and is now Metagame Damage Calculator 3.0
- Damage calculator accuracy improved
- Support for upto 6 attacking moves and 7 defending moves
- 1800+ movesets from smogon have been added to the calculator
- You no longer have to input stats. You only need to imput the pokemon and the pokemon movesets name
- The percent damage will now be red (OHKO) if over 100% and be yellow (2HKO) if over 50%
- Calculator should be 100% accurate and takes into account quite a few moves that have variable base power.
- Stealth Rock and Spikes damage is now calculated
- Speed Calculations should be 100% accurate
- There is now a sheet to store your team information as you test your team out
- Other changes were made that I can't think of on top of the my head. We'll call these general improvements
Bugs::
- Inform me.
The metagame calculator is currently in .ods format. Ods is the format for OpenOffice.org, which is free, open source etc. As soon as I figure out a way to convert the spreadsheet into excel format without breaking it, I will.
The background color of the cells are semi-meaningful. Anything that is light gray is meant to be an option. These can be changed either by directly typing in the value or using a drop down menu, if applicable. Anything that is light blue is a calculation. You can check them out to see whats happening in the cell, but it might be unwise to mess with them if you do not know what you are doing.
Anything on the charts can be changed and, in fact, the calculator allows you to create your own pokemon or moves if you want (Although any novel mechanism, or really any advanced mechanism, will not be implemented).
The background is black because I think it's cool.
Many of the tables are currently taken from the Pokemon Resource by CardOfTheHearts. I am in the process of modifying them for my own needs.
Furthermore, I encourage people to make corrections to the spreadsheet. Many of the attacks that are in the game are not in the spreadsheet due to me simply forgetting about them (Actually because the description of what they do is too long and the script I ran to get the data didn't account for it). I will upload and credit anybody who makes significant improvements to the spreadsheet.
Conclusion::
I am eager to hear some feedback on this. For now, enjoy beating the metagame.