1. Welcome to Smogon Forums! Please take a minute to read the rules.
2. Click here to ensure that you never miss a new SmogonU video upload!

# BSR Calculator - Updated for BW2

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

1. ### bugmaniacbobWas fun while it lasted

Joined:
Sep 19, 2008
Messages:
2,305
So yeah I did this

https://docs.google.com/spreadsheet/pub?key=0An1TUM7m-kKIdDNmVlpMdlB2MTFUdVJGRVFkWURVQUE&output=xls

Yeah apparently I can't attach .xls files to my posts so this will have to do

Anyway so with nothing more than A-level statistics and a burning desire to procrastinate help the CAP Community, I have continued the works of a Maltese mathematics professor and an expert in programming magnetohydrodynamic simulators to update this stuff. And annoyingly, I got it all wrong first time around and had to start over. So I hope you're all happy.

Updates:
• Kyurem-B, Kyurem-W, Tornadus-T, Thundurus-T, and Landorus-T (all formes added in BW2) have been added to the formulae
• Mean and Standard Deviation of all ratings have been rejigged to accomodate this, so they are still 100 and 50 respectively (200 and 100 for BSR, respectively)
• Yeah tbh there's not all that much. But it took forever to do so...
New formulae:

Code:
```PT =((HP*2+141)*(Def*2+36) / (402.744996)) - 24.57966407

ST = ((HP*2+141)*(SpD*2+36) / (416.310724)) - 19.16575597

PS = ((((Atk*2+36)*((Atk*2+36)*(SF/672)+415)/((Atk*2+36)*(1-(SF/672))+415))/(1.92306)) - 3.576327284

SS = (((SpA*2+36)*((SpA*2+36)*(SF/672)+415)/((SpA*2+36)*(1-(SF/672))+415))/(1.980931)) + 4.9921912

BSR = (PT+ST+PS+SS)/(1.535645)) - 60.47703745```
New features:

• There are now 20 different spaces available to input values, so you can compare different spreads without repeatedly having to delete and re-enter your spreads
• There is a list of all the details and ratings for OU and CAP Pokemon, which allows easy comparison within the metagame we are designing for
• There is a list of all the details of every Pokemon in the entire game, including different formes, so you can easily ctrl+f search for an appropriate comparison.
• This was done in Excel 2007, so I can only do a maximum three colour changes for different rating ranges, so I chose to just omit them altogether. You can easily cross-reference with the ratings description chart to the right of the calculator.
• This no longer calculates ODB or PSB because they're pretty meaningless nowadays
• Oh and last but not least, this isn't user-locked, so you are free to fiddle about with whatever you want, or make any modifications you feel like, as well as save it under your own documents. I'm not particularly bothered if you steal my stuff, but please try to avoid claiming it as your own as that's not very nice. I haven't given credit, either to myself or anyone else as this is a community resource, but just know that the credits go to X-Act for the original formula, Rising_Dusk for the update to BW, and myself for the update to BW2.

Intriguingly, CAP4 is now nowhere near the limits given to it. The more you know...

Anyway, I didn't just add this to the Stat Ratings revamp I was doing because I'd like people to play around with this for a bit and let me know if the numbers don't look right, as it's perfectly possible I've made a mistake somewhere along the line. In point of fact, there really isn't much difference between these and the previous ones, only that everything pretty much is rated a little bit worse (thanks, egregiously inflated attacking stats).

Have fun.
2. ### bugmaniacbobWas fun while it lasted

Joined:
Sep 19, 2008
Messages:
2,305
Ah, whoops. I forgot to standardise the mean of BSR.

See updated link in OP.
3. ### jas61292used substituteModerator

Joined:
Sep 30, 2010
Messages:
3,423
First of all, bmb, this is great. Thanks for all the work you put into it.

That being said:
Well, in that case here it is with the changes I made.

https://docs.google.com/spreadsheet...shXdHNQZ3BGSl9BMTVCcW5XbW9CaFNiNkE&output=xls

(Hopefully the link works. Never uploaded something like this before)

While I messed with a lot of the coloration to make it look like I personally like, the major change here is that, like the older calc, the different calculated statistic will change color based on which rank they are. I did notice after I did this that the colors I used were almost the exact opposite of what Dusk had in the older one, with red being high and purple being low, but that is just my personal preference. Nothing of any importance there.

Oh, and yes, as I said on IRC, I did add in the CAP prevos on the all pokemon tab. True, most of them lack stats as of now, and they really are not important, but, no reason not to, I suppose.

EDIT: BMB pointed out to me that there was something off with the coloration between BSR and the other stat. Turns out, while the coloration was the same, the key was simply colored wrong. Anyways, it is fixed now.
4. ### bugmaniacbobWas fun while it lasted

Joined:
Sep 19, 2008
Messages:
2,305
Looks good to me, jas. Unfortunately I can't see the colour changes myself, but... I'm sure they work for everyone with an updated Excel program, heh.

I thought it might be a good idea to add a user manual to the "Calculator" tab, or else a list of instructions in case someone doesn't know what to do with it. I figured you'd be better off adding it to yours since, well, it's a bit better than mine... and it's always nice to go with the most up-to-date version.

I thought something like the following would work:

-----

Anyone have anything else to add?

Joined:
Sep 19, 2008
Messages:
2,305