Hi there. I wrote this spreadsheet up a while back and since then
turskain has pinned it to the channel, so I figured I may as well post it here if the big man himself thinks it's worth pinning:
LINK
This spreadsheet is different from
Skewtr's in the sense that it doesn't show a trainer's entire team, only the Pokemon that you specify in the relevant boxes. It also presents significantly less data than his; for example, out of the 6 stats, it only shows the Pokemon's speed, and even then it always assumes an IV of 31, since it's built for post-50 play. Here's some documentation, in case anyone wants to use it:
Features:
- Two species slots, in case you're playing Doubles and need to account for those two different Pokemon on the field at the same time.
- Use whatever capitalisation you want, I coded to account for that (e.g. 'hydreigon' or 'HYDREIGON' or even 'hYdReIgOn' will produce the same results).
- Copy/paste function, in case you want to laugh or complain about that set you're facing in the Discord server, or want to quickly insert it into your post.
- Set the Trainer name to 'All' to see all possible sets for a Pokemon.
- Automatic bullshit detector: warns you about problematic moves (OHKO, Evasion) and items (Bright Powder, Lax Incense) in
red.
- Automatic annoyance detector: warns you about potentially annoying moves (Protect, Detect, Spiky Shield, Baneful Bunker) and items (Focus Sash) in
orange.
Known bugs:
- If the selected trainer has both the Alolan and regular version of a Pokemon, searching for the regular version of the Pokemon will show the regular Pokemon's data, but twice. If there are more than 4 sets which would be picked up this way, only the first 4 will be shown. For example, searching for Dugtrio with 'All' as a trainer only shows Dugtrio-1 twice and Dugtrio-2 twice. I have no idea how to fix it for now, sorry. (fixed)
- Some abilities may not show correctly. Let me know if this happens and I'll do my best to fix it, time permitting.
I've personally used this spreadsheet for 400~500 Doubles battles so far and it's provided accurate data every time, so it's not bad, I guess. Thanks to
Team Rocket Elite for the data dump, and
Skewtr for a bunch of the data used. Hope this helps you all; thanks for your time, and good luck with the Tree!