Type Blancer Tool

[TwistedLogic]

I put together a spreadsheet to help people with type balancing their team and identifying any holes that they might have. There's a .ods and a .xls version, though I can't guarantee that the .xls version works. I hope this helps some people out!

~~EDIT~~
For some reason OpenOffice is deleting my formula in the .xls version when I save it.

The formula should be:

=INDEX(Sheet2!$C$2:$T$20,MATCH($A3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))*INDEX(Sheet2!$C$2:$T$20,MATCH($B3,Sheet2!$B$2:$B$20,0),COLUMN(A:A))

In case you don't have much experience with Excel, paste that into Sheet1, C3, then drag it to T3, then drag all of that down to row 8.

[Cataclyptic]

Oh, this is good! But that isn't what I meant in my last comment- I was referring to something like http://www.smogon.com/forums/threads/att...u.3545452/ that, but for this game.

[TwistedLogic]

Oh, man; that's really cool! I'd love to do this for Pokemon Uranium, but I may need to upgrade my excel-fu first. xD

*EDIT*
Upon looking further, pretty much all of the groundwork has been laid down already. Once I study this spreadsheet more, I may be able to — with permission of the creator — modify it to meet the needs of Pokemon Uranium (i.e. add in Nuclear type, new abilities, and replace the ORAS OU Pokemon with Uranium Pokemon). Usage stats will still be a problem because they don't exist, but it'll give us a temporary starting point until we get more tournaments going. I honestly like his ranking system far more than my crude one that I just sort of scribbled out in a couple hours.

[Cataclyptic]

Oh, man; that's really cool! I'd love to do this for Pokemon Uranium, but I may need to upgrade my excel-fu first. xD

*EDIT*
Upon looking further, pretty much all of the groundwork has been laid down already. Once I study this spreadsheet more, I may be able to — with permission of the creator — modify it to meet the needs of Pokemon Uranium (i.e. add in Nuclear type, new abilities, and replace the ORAS OU Pokemon with Uranium Pokemon). Usage stats will still be a problem because they don't exist, but it'll give us a temporary starting point until we get more tournaments going. I honestly like his ranking system far more than my crude one that I just sort of scribbled out in a couple hours.

Oh, yours is good too though! That being sad, if you could make a imilar sheet to that it would be extraordinarily helpful!

[TwistedLogic]

Oh, yours is good too though! That being sad, if you could make a imilar sheet to that it would be extraordinarily helpful!

Merry Christmas! With the permission of Ignus, I present to you: Uranium OU Type Analysis Linearize, by X-Act, Ignus, and QxC4Eva, edited with permission by TwistedLogic.

[Cataclyptic]

Oh, yours is good too though! That being sad, if you could make a imilar sheet to that it would be extraordinarily helpful!

Merry Christmas! With the permission of Ignus, I present to you: Uranium OU Type Analysis Linearize, by X-Act, Ignus, and QxC4Eva, edited with permission by TwistedLogic.

Ohohohoho... I applaud you, good sir!

[miau]

didnt work for me

[TwistedLogic]

The balancer tool or the Type Analysis spreadsheet?

[miau]

The balancer tool or the Type Analysis spreadsheet?

spreedsheet i pick a type and get n/a all over

[TwistedLogic]

spreedsheet i pick a type and get n/a all over

The .xls or the .ods? I haven't been able to test the .xls one because I don't actually have Excel, unfortunately.