+- Pokemon Uranium (https://pokemonuranium.co/forum)
+-- Forum: Pokemon Uranium (https://pokemonuranium.co/forum/forumdisplay.php?fid=1)
+--- Forum: General Chat (https://pokemonuranium.co/forum/forumdisplay.php?fid=3)
+--- Thread: Type Blancer Tool (/showthread.php?tid=43)
Pages:
1
2
Type Blancer Tool - TwistedLogic - 09-17-2016
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.
RE: Type Blancer Tool - Cataclyptic - 09-28-2016
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/attacking-type-effectiveness-for-oras-ou.3545452/ that, but for this game.
RE: Type Blancer Tool - TwistedLogic - 09-29-2016
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.
RE: Type Blancer Tool - Cataclyptic - 09-29-2016
(09-29-2016, 01:34 AM)TwistedLogic Wrote: 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!
RE: Type Blancer Tool - TwistedLogic - 10-02-2016
(09-29-2016, 10:18 PM)Cataclyptic Wrote: 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.
RE: Type Blancer Tool - Cataclyptic - 10-02-2016
(10-02-2016, 03:16 PM)TwistedLogic Wrote:(09-29-2016, 10:18 PM)Cataclyptic Wrote: 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!
RE: Type Blancer Tool - miau - 10-02-2016
didnt work for me
RE: Type Blancer Tool - TwistedLogic - 10-02-2016
The balancer tool or the Type Analysis spreadsheet?
RE: Type Blancer Tool - miau - 10-02-2016
(10-02-2016, 07:08 PM)TwistedLogic Wrote: The balancer tool or the Type Analysis spreadsheet?
spreedsheet i pick a type and get n/a all over
RE: Type Blancer Tool - TwistedLogic - 10-02-2016
(10-02-2016, 10:08 PM)miau Wrote: spreedsheet i pick a type and get n/a all overThe .xls or the .ods? I haven't been able to test the .xls one because I don't actually have Excel, unfortunately.