Smogon Community (Programming) Metagame Calculator
 Register FAQ Social Groups Calendar Search Today's Posts Mark Forums Read

Categories: HTML, Programming, Other
 May 4th, 2009, 3:06:35 AM #2 CardsOfTheHeart     Join Date: Aug 2007 Posts: 1,971 My Soul, Your Beats! After looking at this for a bit, I have to say: this looks like it took a lot of work. (This is why I'm not taking any time right now to revamp the Resource; too much work.) Right now, I see one little issue that you might want to look at: The actual damage calculations are inaccurate. Yup, your damage calculator is suffering from a case of MetalKid Syndrome; the damage is slightly inflated. Example: WishBliss vs the DDMence that you left in the analyzer Case 1 - 80 SpA Blissey Ice Beam vs 4 HP Naughty Salamence Libelldra's calculator: 206 Atk vs 176 Def & 332 HP (95 Base Power): 320 - 380 (96.39% - 114.46%) My calculator: 320 - 380 Your calculator: 324 - 381 Case 2 - +1 252 Atk Naughty Salamence Outrage vs 252 Def Blissey Libelldra's calculator: 607 Atk vs 119 Def & 651 HP (120 Base Power): 853 - 1005 (131.03% - 154.38%) My calculator: 853 - 1005 Your calculator: 856 - 1007 The problem is that there is no FLOOR function anywhere in the formula. Remember, there has to be a floor after EVERY operation. Of course, that could complicate things when you're trying to fix it; Excel 2003 won't allow that many functions in a single cell. I'm not sure if OpenOffice has similar limits. A couple of smaller issues I saw: - Mod1, Mod2, and Mod3 are consolidated to one cell for each. Each variable in each Mod needs to be accounted for separately. For example, if Mixed Sweeper Electivire attacked RestTalk Rhyperior with Cross Chop, Solid Rock would need to be factored in and the result floored before Expert Belt; it DOES make a difference. (Also, Solid Rock doesn't seem to be accounted for; when I tried the above example in your calculator, the result of Mod3 was 1.2.) - In the simple damage calculator, STAB isn't accounted for. The STAB cell is looking for if the move's type equals one of two cells in the Moves area of the Pokemon sheet; in other words, it will always be 1. That's all I found at a glance. I'd have to look at it further for more possible errors. All in all, this looks promising. I hope that my Resource ends up more like this. Now I just have to find time to do it... __________________ Creator of the DPP Pokemon Resource, the one thing no Trainer should be without! (eventually... maybe) My YouTube Channel My Blog (VERY, VERY small, ATM)
May 4th, 2009, 3:41:48 PM   #3
Seymor

Join Date: Apr 2009
Posts: 15

Quote:
 Originally Posted by Fat CardsOfTheHeart After looking at this for a bit, I have to say: this looks like it took a lot of work. (This is why I'm not taking any time right now to revamp the Resource; too much work.) Right now, I see one little issue that you might want to look at: The actual damage calculations are inaccurate. Yup, your damage calculator is suffering from a case of MetalKid Syndrome; the damage is slightly inflated. Example: WishBliss vs the DDMence that you left in the analyzer Case 1 - 80 SpA Blissey Ice Beam vs 4 HP Naughty Salamence Libelldra's calculator: 206 Atk vs 176 Def & 332 HP (95 Base Power): 320 - 380 (96.39% - 114.46%) My calculator: 320 - 380 Your calculator: 324 - 381 Case 2 - +1 252 Atk Naughty Salamence Outrage vs 252 Def Blissey Libelldra's calculator: 607 Atk vs 119 Def & 651 HP (120 Base Power): 853 - 1005 (131.03% - 154.38%) My calculator: 853 - 1005 Your calculator: 856 - 1007 The problem is that there is no FLOOR function anywhere in the formula. Remember, there has to be a floor after EVERY operation. Of course, that could complicate things when you're trying to fix it; Excel 2003 won't allow that many functions in a single cell. I'm not sure if OpenOffice has similar limits.
I am aware of this. I'm going to have to think out how I can fix this a bit more than I had to think out the rest of the calculator.

Quote:
 Originally Posted by Fat CardsOfTheHeart A couple of smaller issues I saw: - Mod1, Mod2, and Mod3 are consolidated to one cell for each. Each variable in each Mod needs to be accounted for separately. For example, if Mixed Sweeper Electivire attacked RestTalk Rhyperior with Cross Chop, Solid Rock would need to be factored in and the result floored before Expert Belt; it DOES make a difference. (Also, Solid Rock doesn't seem to be accounted for; when I tried the above example in your calculator, the result of Mod3 was 1.2.)
I am semi-aware of this. Didn't know that Solid Rock was acting up.

Quote:
 Originally Posted by Fat CardsOfTheHeart - In the simple damage calculator, STAB isn't accounted for. The STAB cell is looking for if the move's type equals one of two cells in the Moves area of the Pokemon sheet; in other words, it will always be 1.
The simple damage calculator is, in general, more inaccurate than the metagame calculator. On multiple occasions Open office thought it knew better than I did and tried to reassign things that I didn't want to be assigned (This is, of course, really my fault).

The simple damage calculator is nowhere near done. Like I meantioned, I want the calculator to be able to account for 4 the next 4 moves on each side.

Attack Pokemon:Move ::: Defend Pokemon:Move

Azelf: Switch to Salamence ::: Blissey: Seismic Toss
Salamence: Dragon Dance ::: Blissey: Switch to Metagross
Salamence: Outrage ::: Metagross: Stone Edge
Salamence: Outrage ::: Metagross: Stone Edge

Quote:
 Originally Posted by Fat CardsOfTheHeart That's all I found at a glance. I'd have to look at it further for more possible errors. All in all, this looks promising. I hope that my Resource ends up more like this. Now I just have to find time to do it...

 May 8th, 2009, 8:29:42 PM #4 Seymor   Join Date: Apr 2009 Posts: 15 http://www.megaupload.com/?d=PZPMOOUT New metagame sheet version 32 File Size is 385.05 KB, No idea how the size went down but I'm cool with it. 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.0Damage calculator accuracy improved Support for upto 6 attacking moves and 7 defending moves 1800+ movesets from smogon have been added to the calculatorYou 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 I'm hoping to get some good feedback now. Seeing the feedback that I recieved last time, I think there might be a lack of interest in a metagame calculator. Barring me seeing any interest this will probably be the final version that I make since I am completely satisfied with the current state of the calculator.
 May 10th, 2009, 7:32:26 AM #5 Clocks     Join Date: Apr 2009 Posts: 24 I can't speak for anyone else, but I would be interested in seeing this project go on as the metagame continues to shift. (Especially with a huge shift likely when Heart Gold and Soul Silver are released.) I used the Metagame Calculator 2.0 quite a bit to help build an OU team to give me general estimates of how I wanted to place my EVs. (I used another calculator to finetune them, since it wasn't 100% accurate then.) With the damage calculator 100% accurate, this calculator will become that much more useful for developing spreads. As for the most recent update, I'm getting #NAME? for a ton of the readouts. I have no idea whatsoever why this is, so I really can't make any critiques at the moment. I'll edit this post if I solve this problem though.
 May 10th, 2009, 12:48:57 PM #6 Seymor   Join Date: Apr 2009 Posts: 15 Which readouts? Is it a calculating cell (light blue or conditionally formatted, if you click on them they have some sort of formula in the cell)? Is it a validity cell (light gray, when you click on it you get a drop down box)? The metagame calculator uses User Defined Functions now so that I can take into account a large amount of variables using code instead of using excel. This is my first time using them so I have no idea how it reacts when placed on other peoples computers. I can update everything in the spreadsheet for heartgold and soul silver in about 5-10 minutes assuming that the movesets are posted on smogon and the learnsets are posted somewhere.
 May 11th, 2009, 5:07:35 AM #7 Clocks     Join Date: Apr 2009 Posts: 24 It's actually both the calculating cells and validity cells. This is probably unnecessary but here's a link to a screenshot. http://i41.tinypic.com/2ev6hch.jpg It's good to hear that changing movesets isn't too time consuming of a process. I may add in some movesets from the Project Uber thread as well as other uber threats not in the analysis once I get this up and running.
May 11th, 2009, 12:50:44 PM   #8
Seymor

Join Date: Apr 2009
Posts: 15

Quote:
 Originally Posted by Fat Clocks It's actually both the calculating cells and validity cells. This is probably unnecessary but here's a link to a screenshot. http://i41.tinypic.com/2ev6hch.jpg It's good to hear that changing movesets isn't too time consuming of a process. I may add in some movesets from the Project Uber thread as well as other uber threats not in the analysis once I get this up and running.
I know exactly what the problem is. All of those cells have a UDF (User defined Function) in them. I am currently on another computer and I'm gonna see what is necessary to get the spreadsheet working on this computer then post the materials. I'll also post my latest version (v36).

Fixed.

Last edited by Seymor; May 11th, 2009 at 1:20:14 PM.

 May 13th, 2009, 3:36:39 AM #9 Clocks     Join Date: Apr 2009 Posts: 24 This version's definitely working just as needed. I haven't had the time to really mess with it yet, hence my not writing a reply yet. The only thing which I've immediately noticed is flash fire Pokemon taking damage from fire moves, volt absorb Pokemon taking damage from electric moves, and so on. However, this is not a critical problem. Also, the link in the first post to the most recent calculator currently hyperlinks to the old version when you click on it, despite the text reading the correct Megaupload link. I'll either edit this post or post again if I find more to add on about the metagame calculator.
May 13th, 2009, 9:20:53 PM   #10
Seymor

Join Date: Apr 2009
Posts: 15

Quote:
 Originally Posted by Fat Clocks This version's definitely working just as needed. I haven't had the time to really mess with it yet, hence my not writing a reply yet. The only thing which I've immediately noticed is flash fire Pokemon taking damage from fire moves, volt absorb Pokemon taking damage from electric moves, and so on. However, this is not a critical problem. Also, the link in the first post to the most recent calculator currently hyperlinks to the old version when you click on it, despite the text reading the correct Megaupload link. I'll either edit this post or post again if I find more to add on about the metagame calculator.
And that is why I list the file size.

Also, updated. Speed chart is awesome.

 May 13th, 2009, 9:30:39 PM #11 Mister Militia     Join Date: Jul 2008 Posts: 338 Behind a Substitute I'm DLing it. I wont have time to mess with it, but it sounds like if you can get this user friendly, It will be a lot of help for me as I never bother running calcs. Also I have a hard time knowing what pokemon can survive a + 1 Gyra, Kingdra, Tyranitar ect. This sounds like a great help. I'll let you know what I think when I sit down with it, but let it be known you have support! __________________ Check out my reviews on underrated games! Mario Tennis (GBA) Shadowrun (Xbox360/PC)
 May 21st, 2009, 8:16:26 PM #12 Clocks     Join Date: Apr 2009 Posts: 24 Something I've noticed when building an ubers team is that the metagame calculator always assumes that the opposing Pokemon will come in on a full three layers of spikes and stealth rock in regards to their health, even if you have put down that there are no stealth rocks and spikes. This usually isn't too important for OU and below, but it makes a significant impact in regard to Kyogres and water spout's maximum possible damage in ubers. (What's scary to note is that specs version is still doing an upwards of 70% to me.) I wish that I had more to say about this right now but I really haven't noticed much. It's really quite useful and I'm using it whenever I work on custom EV spreads and really want to take the time on them.
May 23rd, 2009, 12:43:36 AM   #13
Seymor

Join Date: Apr 2009
Posts: 15

Quote:
 Originally Posted by Fat Clocks Something I've noticed when building an ubers team is that the metagame calculator always assumes that the opposing Pokemon will come in on a full three layers of spikes and stealth rock in regards to their health, even if you have put down that there are no stealth rocks and spikes. This usually isn't too important for OU and below, but it makes a significant impact in regard to Kyogres and water spout's maximum possible damage in ubers. (What's scary to note is that specs version is still doing an upwards of 70% to me.) I wish that I had more to say about this right now but I really haven't noticed much. It's really quite useful and I'm using it whenever I work on custom EV spreads and really want to take the time on them.
Under defending pokemon, set spikes layers to 0 and stealth rock to false.

 May 25th, 2009, 4:16:35 AM #14 Seymor   Join Date: Apr 2009 Posts: 15 Update, Version 45 Updated the original post a bit. It's all very sloppy but it's 3:16 AM right now and I'm pretty lazy at the moment.
 Sep 3rd, 2009, 6:59:40 AM #15 simple1212   Join Date: Sep 2009 Posts: 1 superb post.. good thread.. Simple interest calculator calculation rates mortgage compound high interest savings account