Damage Calculator (and other utilities)

Slipperjeans · Nov 1st, 2010, 2:47:55 PM

Jibaku said UT is the best place for this
If you argue with "you can't know the formula!!", I'll say I am using the gen 4 damage formula available on Smogon with the gen 5 alterations being placed in the most logical member of the equation. For example, the boost from Encourage is placed in the same place as the boost from Iron Fist, the BP mod, while the Multiscale deduction is placed together with the Solid Rock factor, in mod3.

All the features are:

Competitive Stuff

...

Informational Stuff

...

Download

Version 5.2B
Last update: 19/06/2011
Excel 2007+: http://www.mediafire.com/?jlcdjr6rac9q87h
Excel 2003: http://www.mediafire.com/?624448v305l64u5
Keep in mind that the version for 2003 is much heavier and Excel gave me more than 600 errors when I converted. Stuff may not work in it and I may not fix it if it's exclusive to the 2003 version.

This is it. Please appoint any bugs, errors or suggestions here. I'll do my best to fix them and add nice new features!

GtM · Nov 1st, 2010, 4:00:15 PM

Wow, this is basically the best thing ever. <3

One problem: I don't think Brazen is the official name for raising attack after kills, the general consensus is Overconfidence. Might want to edit that.

Other than that, beautiful.

Arc Tech · Nov 1st, 2010, 6:49:14 PM

Thanks! I've been hunting all over for something to calculate Gen V! I'll to you if I find any bugs.

Venser · Nov 1st, 2010, 7:49:31 PM

This is incredible, it has everything I need for competetive Pokemon teambuilding (almost) in one! No more hopping around to figure out type coverage/team weaknesses/w.e! Thanks!

Wombat Sky Forme · Nov 1st, 2010, 7:58:53 PM

Incredible. Thank you for all your hard work and effort in doing this. This tool will be an immensely useful utility during battles.

Slipperjeans · Nov 1st, 2010, 8:04:53 PM

Thanks for the positive feedback :)
I uploaded a new version (4.8.6) that fixes some references to the wrong cell in the damage calculation cells (supposed to refer to ability, didn't, thus ability would have no effect) and added support for Venom Shock and Evil Eye double damage.
Changed all Earthquake Spiral and Brazen references to Overconfidence as suggested by GtM, although it has no effect in the damage calculator.

yiran · Nov 1st, 2010, 9:52:07 PM

Wow this is awesome thanks Slipperjeans!

Seth Vilo · Nov 2nd, 2010, 12:31:53 AM

Best thing ever! Who needs candy on Halloween when you wake up to this??

Wafflez · Nov 2nd, 2010, 3:15:16 AM

Awesome!@!!@ Thanks bro ^.^

Goldor · Nov 2nd, 2010, 3:42:52 AM

I love you <3

Thank you very much

thelaytonmobile · Nov 2nd, 2010, 5:00:52 AM

Will this work on OpenOffice Spreadsheet?

Aurabreloom · Nov 2nd, 2010, 5:11:45 AM

the scale of this thing is amazing, and all in one place!

thanks much!

yiran · Nov 2nd, 2010, 5:39:06 AM

It doesn't work on my mac because of the macros =/

Never fear, I have PCs at home.

Manxer · Nov 2nd, 2010, 5:50:06 AM

Can u fix those bugs in 2003 that u said there could be many, cuz i prefer 2003, it's much easier to use

yiran · Nov 2nd, 2010, 6:16:10 AM

Talk properly Manxer.

Anyways it isn't likely that he is going to fix the 2003 bugs for one person while you could easily update your microsoft.

BlackTailedMewtwo · Nov 2nd, 2010, 7:30:14 AM

This is freaking awesome! Exactly what I need.
Thx a lot

Genmagius · Nov 2nd, 2010, 7:37:15 AM

Great work, seems very usable.

One little thing I noticed in the stat calculator was that there's a difference in final stats when the EVs are 255 and 252 respectively.

As far as we all know, those 3 EV shouldn't make any difference at all. Might be a kinda meh thing. but just like to keep it looking perfect ;)

Edit: This happens in all the + Natures

Aeron Ee1 · Nov 2nd, 2010, 7:53:37 AM

Fuck. You, sir, are amazing! Never will I be unable to Theorymon when my Internet is down, ever again!

Dead Gardeviors · Nov 2nd, 2010, 8:08:08 AM

It lists Enbuoo's dream world ability as thick fat in the damage calculator, should be reckless

also is there a way to get the damage calculator to say the chance for 2HKOs or 3HKOs? I can't figure that out

Slipperjeans · Nov 2nd, 2010, 8:15:56 AM

Quote:

Originally Posted by Fat thelaytonmobile

Will this work on OpenOffice Spreadsheet?

I don't know. Ete has had success in running it so I think so. Maybe with some bugs...

Quote:

Originally Posted by Fat Groshi

It doesn't work on my mac because of the macros =/

Never fear, I have PCs at home.

Well, if I recall correctly, these are all the things that depend on macros:

Moveset Coverage Calculator
Exporting Tool in the Damage Calculator
All the buttons in Damage Calculator

You should be able to run it without macros and still have all the other features

Quote:

Originally Posted by Fat Manxer

Can u fix those bugs in 2003 that u said there could be many, cuz i prefer 2003, it's much easier to use

Well, around 500 of the 600 are due to formatting. The other 100 may be functional but I will never be sure if you never tell me what's going wrong.

Quote:

Originally Posted by Fat Genmagius

Great work, seems very usable.

One little thing I noticed in the stat calculator was that there's a difference in final stats when the EVs are 255 and 252 respectively.

As far as we all know, those 3 EV shouldn't make any difference at all. Might be a kinda meh thing. but just like to keep it looking perfect ;)

Edit: This happens in all the + Natures

Fixed. Thanks!

Quote:

Originally Posted by Fat Dead Gardeviors

It lists Enbuoo's dream world ability as thick fat in the damage calculator, should be reckless

also is there a way to get the damage calculator to say the chance for 2HKOs or 3HKOs? I can't figure that out

Thanks, fixed Enbuoo!

For the 2HKO or 3HKO, I may add in the future something that calculates multi-turn KOs involving things like Leftovers, Poison, Sandstorm and Leech Seed.

But for now, you could just deduct the average damage from the defender and then run another calculation.

---/---

Thanks for the positive feedback!
I uploaded a new version (4.8.7) which contains bug fixes and a few new Pokémon sets for Gen 5 Pokémon that are common.

***Mekkah***** · Nov 2nd, 2010, 8:26:02 AM

Hey, I might not use this, but this is definitely a lot of awesome work you did right here!

thelaytonmobile · Nov 2nd, 2010, 11:44:30 AM

Quote:

Originally Posted by Fat Slipperjeans

I don't know. Ete has had success in running it so I think so. Maybe with some bugs...

I had a go at both versions using OpenOffice.
The damage calculator (which is what I really want to work):
The Excel2007 version has "Error 511" or something in the damage boxes.
Excel2003 has "Error520".
So no luck, but I'll have another go.

EDIT: When I open it up, it says something like:
"This spreadsheet contains links to other files. Update these links?"
No matter whether I pick yes or no, I get the errors.

EDIT2: Here are what the error messages mean:
Err:511 Missing variable: The function requires more variables than are provided, e.g. AND() and OR() without parameter.
Err:520 Internal syntax error: The compiler created an unknown compiler code.

sax king · Nov 2nd, 2010, 12:23:19 PM

^^^^
What he said.
Also, If I click on a box such as the ability box, it doesn't give me a drop down menu, if just gives me a long line of numbers that won't go away and I have to restart the program.

wavedash · Nov 2nd, 2010, 12:36:11 PM

Works great in OpenOffice 3.2. Also, this is beautiful on so many levels.

SupremeDirt · Nov 2nd, 2010, 12:44:09 PM

It appears you're using the PO translations, correct? Perhaps mention that in the OP, to get rid of any confusion regarding that?

Nov 1st, 2010, 2:47:55 PM	#1
Slipperjeans Join Date: Jul 2010 Posts: 89	Damage Calculator (and other utilities) Jibaku said UT is the best place for this If you argue with "you can't know the formula!!", I'll say I am using the gen 4 damage formula available on Smogon with the gen 5 alterations being placed in the most logical member of the equation. For example, the boost from Encourage is placed in the same place as the boost from Iron Fist, the BP mod, while the Multiscale deduction is placed together with the Solid Rock factor, in mod3. All the features are: Competitive Stuff ... A damage calculator that includes Gen 5 Pokémon, moves, abilities and items ...with a tool to quickly export results into chats, posts etc (you can ctrl-c that) A team weaknesses calculator A moveset coverage calculator A team synergy calculator A stat calculator Informational Stuff ... A beautiful type chart ...which also has a tool for you lazy pricks to figure out dual-typing matchups A beautiful, organized Pokédex updated with Gen 5 Pokémon that contains relevant information. The information contained for each Poké is: number, name, type 1, type 2, base stats, matchups for each type, abilities (including DW), base exp, EV wield, catch rate, height, weight, species, color and habitat. A move list An ability list A nature list A TM/HM list for Black and White, complete with locations and prices Download Version 5.2B Last update: 19/06/2011 Excel 2007+: http://www.mediafire.com/?jlcdjr6rac9q87h Excel 2003: http://www.mediafire.com/?624448v305l64u5 Keep in mind that the version for 2003 is much heavier and Excel gave me more than 600 errors when I converted. Stuff may not work in it and I may not fix it if it's exclusive to the 2003 version. This is it. Please appoint any bugs, errors or suggestions here. I'll do my best to fix them and add nice new features! Last edited by Slipperjeans; Jun 19th, 2011 at 6:25:04 PM.

Nov 1st, 2010, 4:00:15 PM	#2
GtM Join Date: Jun 2009 Posts: 720 The Gastronomicon	Wow, this is basically the best thing ever. <3 One problem: I don't think Brazen is the official name for raising attack after kills, the general consensus is Overconfidence. Might want to edit that. Other than that, beautiful. __________________ Triple Double! Gyarados + Salamence RMT Red Skull's Army! Latias RMT I Burrascusi Italiani! Gyarados + Jolteon RMT "How does this team fare against Sun teams? I would give Scizor Aqua Jet over Bug Bite so he can pick off those fire pokemon."

Nov 1st, 2010, 7:49:31 PM	#4
Venser Join Date: Jun 2010 Posts: 1,592 #capasb	This is incredible, it has everything I need for competetive Pokemon teambuilding (almost) in one! No more hopping around to figure out type coverage/team weaknesses/w.e! Thanks! __________________ last.fm

Nov 1st, 2010, 9:52:07 PM	#7
yiran Join Date: Aug 2010 Posts: 282 :3	Wow this is awesome thanks Slipperjeans! __________________ 雪花凋零残冰飞落随波逝

Nov 2nd, 2010, 12:31:53 AM	#8
Seth Vilo Join Date: Mar 2009 Posts: 426 US East Coast	Best thing ever! Who needs candy on Halloween when you wake up to this?? __________________ This is a haiku. Sometimes haiku's do not rhyme. Refrigerator. Professional Lurker since March, 2009 (And it's Vilo: veye-low, like the i in pie) {Projects: How do I pronounce that Pokemon...?; ...}

Nov 1st, 2010, 6:49:14 PM	#3
Arc Tech Join Date: Jan 2009 Posts: 661	Thanks! I've been hunting all over for something to calculate Gen V! I'll to you if I find any bugs.

Nov 1st, 2010, 8:04:53 PM	#6
Slipperjeans Join Date: Jul 2010 Posts: 89	Thanks for the positive feedback :) I uploaded a new version (4.8.6) that fixes some references to the wrong cell in the damage calculation cells (supposed to refer to ability, didn't, thus ability would have no effect) and added support for Venom Shock and Evil Eye double damage. Changed all Earthquake Spiral and Brazen references to Overconfidence as suggested by GtM, although it has no effect in the damage calculator.

Nov 2nd, 2010, 3:15:16 AM	#9
Wafflez Join Date: Apr 2010 Posts: 414	Awesome!@!!@ Thanks bro ^.^

Nov 2nd, 2010, 3:42:52 AM	#10
Goldor Join Date: Oct 2010 Posts: 10	I love you <3 Thank you very much __________________ HG FC: 0904 4920 1950 White FC: 5070 9557 0745 I use legal Hacks (510 Evs / 31 Ivs). If the battle is nice, i m able to post it on YouTube. Send me a PM if you don't want.

Nov 2nd, 2010, 5:00:52 AM	#11
thelaytonmobile Join Date: Jan 2010 Posts: 208 The UK	Will this work on OpenOffice Spreadsheet? __________________ My art thread!

Nov 2nd, 2010, 5:39:06 AM	#13
yiran Join Date: Aug 2010 Posts: 282 :3	It doesn't work on my mac because of the macros =/ Never fear, I have PCs at home. __________________ 雪花凋零残冰飞落随波逝

Nov 2nd, 2010, 5:50:06 AM	#14
Manxer Join Date: Oct 2010 Posts: 49 Cambridge, UK	Can u fix those bugs in 2003 that u said there could be many, cuz i prefer 2003, it's much easier to use

Nov 2nd, 2010, 6:16:10 AM	#15
yiran Join Date: Aug 2010 Posts: 282 :3	Talk properly Manxer. Anyways it isn't likely that he is going to fix the 2003 bugs for one person while you could easily update your microsoft. __________________ 雪花凋零残冰飞落随波逝

Nov 2nd, 2010, 7:30:14 AM	#16
BlackTailedMewtwo Join Date: Jan 2010 Posts: 5	This is freaking awesome! Exactly what I need. Thx a lot

Nov 2nd, 2010, 7:37:15 AM	#17
Genmagius Join Date: Feb 2010 Posts: 33 Peru	Great work, seems very usable. One little thing I noticed in the stat calculator was that there's a difference in final stats when the EVs are 255 and 252 respectively. As far as we all know, those 3 EV shouldn't make any difference at all. Might be a kinda meh thing. but just like to keep it looking perfect ;) Edit: This happens in all the + Natures __________________ *"Sin riesgos en la lucha, no hay gloria en la victoria"* 1.Platinum FC: 2450 0650 5601 2.Soul Silver FC: 3911 0113 2469 3.Pearl FC: 0387 5847 8712 4.Diamond FC: 1205 3227 6872

Nov 2nd, 2010, 8:08:08 AM	#19
Dead Gardeviors Join Date: Oct 2010 Posts: 2	It lists Enbuoo's dream world ability as thick fat in the damage calculator, should be reckless also is there a way to get the damage calculator to say the chance for 2HKOs or 3HKOs? I can't figure that out Last edited by Dead Gardeviors; Nov 2nd, 2010 at 8:13:37 AM. Reason: second feature suggestion

Nov 2nd, 2010, 8:26:02 AM	#21
*Mekkah* pfbwowbfobwobwobfwowbf Administrator** Join Date: Feb 2005 Posts: 13,835 Most of them are good	Hey, I might not use this, but this is definitely a lot of awesome work you did right here! __________________ onions videos cameras models steroids dinoturtlethings

Nov 2nd, 2010, 12:23:19 PM	#23
sax king Join Date: Mar 2010 Posts: 767 I'm not sick, but I'm not well	^^^^ What he said. Also, If I click on a box such as the ability box, it doesn't give me a drop down menu, if just gives me a long line of numbers that won't go away and I have to restart the program. __________________ The 90's were awesome

Nov 2nd, 2010, 12:36:11 PM	#24
wavedash Join Date: Mar 2009 Posts: 337	Works great in OpenOffice 3.2. Also, this is beautiful on so many levels.

Nov 2nd, 2010, 12:44:09 PM	#25
SupremeDirt Join Date: Apr 2009 Posts: 552	It appears you're using the PO translations, correct? Perhaps mention that in the OP, to get rid of any confusion regarding that?