Pokemon (HS Minions) Battle Calculator

conner#5457

I made an excel calculator that finds the best pokemon to use in a battle. With my 2k strength pokemon, I'm able to get up to about 900 score (beating pokemon with 2.5 - 3k strength). I figured I'd make it available if anyone wants to use it.

Click link and then download & open with MS Excel.
https://drive.google.com/open?id=0B9gCKptGZ_OJRjNYckJ6ZlJPSFU

Brief Instructions:
1: Fill out the roster sheet with your available pokemon. If it's not tan-colored, don't touch it.
2: For each battle, fill out the information about the opponent's pokemon in the tan-colored box at top left on Battle sheet. Results will be displayed at top left.

I didn't design it to be used by other people, so some of the instructions may be a little light. Let me know if you have any questions.

Now compatible with Excel 2007 - 2016​​

asterelle

I was wondering if anyone else was doing this...
What exactly are you using to determine best commander to use? I couldn't really tell.
I made a similar calculator that gives me the flank combo against possible enemy configurations under 4 criteria: Best Average Performance, Best Winning %, Highest Minimum Performance, Highest Maximum Performance

Which flank combo I go with depends on the relative tradeoffs between those options (like I'd choose the option that wins 16 out of 20 times over one that performs 1.5k worse on average but wins 17/20).

After that though I have to take a best guess at the race of the enemy commander based off of what minions are missing. Like If I see someone with Molten Core, Earth Kirin, and Fireburst Rhino out the enemy commander is very likely to be Sentu Huay so I use something that can snipe Skykeen.
I'm thinking about training a neural network though for this prediction part because it's too stressful.​​