1. Welcome to Smogon Forums! Please take a minute to read the rules.
  2. New to the forums? Check out our Mentorship Program!
    Our mentors will answer your questions and help you become a part of the community!

XY BSR Calculator + Movepool Builder

Discussion in 'Create-A-Pokémon Project' started by bugmaniacbob, Oct 24, 2013.

  1. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    Birkal said I could post this

    XY BSR Calculator (Download)
    XY Movepool Builder (Download)

    Here's what's been changed:

    Base Stat Ratings Calculator
    • Added the new Pokemon base stats, added Mega Evolution base stats, updated stats for previous Pokemon known to have had revisions.
    • As far as I'm aware, the calculation of stats from base stats hasn't changed, given the more or less identical stat ranges for existing Pokemon, so I'm assuming that the BSR formula does not need updating barring the traditional weighting for average and standard deviation (which has been done).
    • Also colours were changed. I think red suits "bad" better than "amazing". But do say if you find it too garish, or some other similarly inane critique.
    • We still need stats for Rebble, Bolderdash, Privatyke, Nohface, Monohm, Duohm, Colosshale, Protowatt and Voodoll (and yes this is a very trivial thing to be concerned about and no I don't know why it's annoying me so much either).
    • Hoopa, Diancie, and Volcanion are currently not filled in as they do not currently exist.
    Movepool Builder
    • For the 99% of you who don't know what this is, this was supposed to be a helpful tool to let people keep track of their RMs and such without having to repeatedly check with the lists or do re-counts. It's essentially just a hand-holding tool if you can't be bothered to use Notepad. Or to type out all the TM moves yourself.
    • Changed the word "VGM" to "RM" everywhere
    • 6th Gen RM lists have been implemented
    • New RM doubles have been added
    • Added type-move and move-move lists
    --------------

    So. The point of this thread is mainly to avoid any duplicated effort, in case anybody else wanted to update this as well - at the very least, you can use the above as a starting point for any further improvements you wish to make.

    Again, any comments you wish to make are appreciated. And, uh... nice to be back, I suppose. Sorry to those of you who expected a novel. Maybe next time.
    Last edited: Apr 8, 2014
    Ignus, Agile Turtle, Eagle4 and 9 others like this.
  2. Luigifan

    Luigifan

    Joined:
    Sep 5, 2010
    Messages:
    170
    Hey, kudos on the Base Stat Rating Calculator. It's great to have an updated model. I do miss the old Offense-Defense Balance and Physical-Special Balance ratings, though. (Sure, in most cases it's obvious, but then you have Pokémon like Snorlax and Ho-Oh (high Attack and Special Defense, relatively low Defense and Special Attack) that make it rather interesting.) I'm also perturbed by the removal of the data readouts for normalized HP, Attack, Defense, Special Attack, and Special Defense, but I have to say that the new Speed Factor is much better than the old Speed Rating; the latter was thrown off by anything faster than Deoxys-S, resulting in sweepiness ratings lower than they should have been. Anyways, is there any possibility of the Base Stat Rating calculator being updated to re-include those old features?
  3. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    Um

    I'm pretty certain the formulae haven't included the normalised stat values for... about four years now... the current formulae use the values for the stats at level 100, rather than the original normalised values. We've also used Speed Factors for a similar length of time... I'm not sure why you seem so familiar with those formulae when they predate your join date, but eh. I removed ODB and PSB (well I removed them more than a year ago now but for sake of argument) because they don't actually have any relevance to the stat spread submissions stage any longer and they tend to clog up the document. If more people wanted them then I could add them, sure, but there doesn't seem to be a colossal demand for them at present.

    So... yeah I'm really confused right now. In answer to your question, I very much doubt that these features will be included again, at least before the calculator accurately reflects XY in its entirety, unless there's significant demand for it.

    EDIT: Oh and since I posted, I'll just mention that I updated the calculator to reflect the most recent changes to the old Pokemon stats. I also fixed a typo with Pidgeotto's Speed that rather threw off the sweepiness ratings a tad.
    Last edited: Nov 7, 2013
  4. xyril

    xyril

    Joined:
    Nov 20, 2013
    Messages:
    3
    Thanks for the sweet spreadsheets! Just want to point out a typo that's throwing off the calculations for those with 150 base speed. On the Speed Factor worksheet in the BSR Calculator, cell F151 should be =COUNTIF($C$1:$C$1000,"<=150") and not =COUNTIF($C$1:$C$1000,"<=110").

    Edit--
    Found a few more: F71, F72, F171, F172, and F251.
    Last edited: Nov 20, 2013
  5. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    That was well spotted, thank you! I fixed all the above for errors, adjusted the formulae appropriately and checked for more errors, so hopefully that's all settled now.
  6. Luigifan

    Luigifan

    Joined:
    Sep 5, 2010
    Messages:
    170
    Have you updated the download link?
  7. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    It should update automatically whenever I make changes to it. I just checked and it seems to have done so.
  8. RP2865

    RP2865

    Joined:
    Jan 5, 2014
    Messages:
    143
    I have something that I would like to point out. Keep in mind I just saw this today, and am not an expert by any means.

    I think that the calculator values speed a bit too much for PS and SS, and should have more input from the defenses. To illustrate, I put in a Pokemon that had 300/300/300/300/300/1 stats, and it was only "Above Average" as a sweeper in both categories. (120.5 PS and 124 SS). Imagine Dragonite (which in the calc has as 176.7 PS and 136 SS, "Excellent" and "Good" respectively" with triple the HP and defenses, more than double the attack, and a special attack that equaled that (which would require multiplying it by about 3.5). The one flaw it had was less speed, and speed is a problem for Dragonite anyway as of now. You might say "but now Dragonite can't really use Dragon Dance because the speed boost won't make a difference, and Agility is pointless, while Dragonite can't use Swords Dance etc.!". With that base 300 attack, it has more than a Swords Dance with no setup! (I know the calc doesn't take movepools into effect, but imagine dragonite seriously using Fire Blast, Draco Meteor, Surf, Ice Beam, Thunderbolt, and more as strong as it's physical moves!) Yet in the calc, as mentioned, it is only "Above Average", worse than it is now, as sweeping! With those HP and defenses, it can take hits fine! Speed isn't the issue.
    Thanks again, for the calc.
    EDIT: A pokemon with 1 HP and 350 in both defenses is "Amazing". Lol
    EDIT2: I may have found an actual error. While you put speed as "1", the SF is zero, when you put it as "0", the SF is 28. And why is Shuckle only a "bad" special sweeper, when it is tied for the lowest speed and special attack stats in the game?
    Last edited: Apr 5, 2014
  9. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    The defensive stats don't have any input into PS/SS; all that PS/SS are telling you is how well the Pokemon throws around hits, which is essentially calculated from its raw base stat in Attack or Special Attack, while factoring in the number of Pokemon it can outrun, which is really all that "sweepiness" actually means. Conversely, "tankiness" refers to how well the Pokemon takes hits, and is calculated from HP and one of the defences. In that case, your hypothetical 300/300/1 sweeper is a terrible sweeper by these specifications, since it will always be outrun; the fact that it takes little damage is not taken into account, as that's what the overall BSR calculation is for.

    Remember that in the real game, Speed is the single most important stat - outrunning something is the only thing that can make a literal world of difference.

    The 1 HP and 350 defences Pokemon is pretty amazing, since 350 defence is impossible (the highest you can get is 255 in any stat, unless they changed it for XY; even so, no Pokemon can or probably ever will have a stat that high), and the calculator doesn't take into account that 1 HP base is like Shedinja - it assumes that that Pokemon has 143 HP, since that's the lowest it can go.

    That's weird - I get 0 for SF when I input Speed as 0. Not sure if you want to double-check that.

    Also, Shuckle is only a "Bad" special sweeper because of the way the calculations are set up - all of the stats are scaled so that the average for PS/PT/SS/ST across every single Pokemon in the game is exactly 100, and the standard deviation between them is 50. If your PS is above 100, you're immediately above average. Unfortunately, this means that because of where the average is for SS, it is impossible to get a Pokemon with a "Horrible" rating - even 1 SpA and 1 Spe still gets you just above 25.0, which is a shame but not really of any consequence for our purposes.

    Feel free to point out anything else you see; feedback and critique are always welcome.
  10. RP2865

    RP2865

    Joined:
    Jan 5, 2014
    Messages:
    143
    Well, that makes a lot of sense, thanks. But for the first paragraph, I understand what you mean, but wish that the BSR calc would be changed so that HP and defenses have some sort of an impact, but I am not sure if that would be reasonable. As for the part about putting 0 in the Speed and having the SF be 28... things got weird when I double checked it. The first time (I put 0 for speed), I got an arbitrary SF of 5. Subsequent times gave me 14. Maybe it's just my computer, but that's quite unusual...
    Wait, there's more. Now, it's 27. And 43. And 47. So confused...
    Better idea. Here is what the SF equals, when I put speed as zero, for every row.
    Row 1: 5
    2:5
    3:14
    4:14
    5:14
    6:14
    7:14
    8:27
    9:27
    10:28
    11:32
    12:33
    13:43
    14:43
    15:43
    16:47
    17:50
    18:83
    19:85
    20:89
  11. bugmaniacbob

    bugmaniacbob Floats like a Butterfree, stings like a Metapod
    is a Smogon Media Contributoris a Contributor to Smogonis an Artist Alumnusis a CAP Contributor Alumnus

    Joined:
    Sep 19, 2008
    Messages:
    2,275
    Ultimately there always needs to be some sort of concession made when making what is essentially a theoretical model; some types make inherently better defensive or offensive typings than others, for example. The BSR calculation in its entirety takes all stats into account; the PS/SS/PT/ST is simply a neat way of breaking it up to measure and weigh the most metagame-relevant parts of the stats themselves.

    Yes, as I said earlier, a Pokemon's Speed stat cannot be zero, so there is no "zero" entry in the table in question, so you're asking the spreadsheet to search another spreadsheet for an entry that doesn't exist. I thought that this would throw up either an error message or, in my case, simply zero, but apparently in your case it's returning the values from the table it's searching from the same row as the row you entered the zero in - in "row 1" of the calculator, you're inputting the 0 into row 14 of the spreadsheet, so it returns the value from the lookup table from row 14 (which is 5, or the number of Pokemon that a CAP with 13 base Speed would outrun or speed tie). The same is happening in the rest of the rows (as you can see if you look at the "Speed Factors" tab). I presume that you have a different version of Excel.

Users Viewing Thread (Users: 0, Guests: 0)