I've completed the latest major update to the gym simulator (now version 2.01). This release brings enhanced dodging options and real-life tests.
https://docs.google.com/spreadsheets/d/1TGMj8MK90hMYmvehzCLyEu4roXswLJlIC4h7-pmyj5I/edit?usp=sharing
For dodging, I've made several common dodging strategies available including dodge charge moves, and dodge all moves, and I've added the ability to specify different number of dodge attempts for quick moves versus charge moves.
In addition, thanks to gmb5127, I was able to compare real-life battle results to the simulator. The results were extremely satisfying as they were very close (generally within a few seconds and HP). That said, I'd love to have more data to continue to test and improve the simulator. Meanwhile, please feel free to copy and/or use and and provide comments here or within Google Sheets.
Thanks!
Great work, i tried it. The fact i like most is, that unlike pokebattler, a dodge can fail.
Because RNG is involved, it would be great to have the sheet start a series of simulations and give statistics of battles won, battles lost, time. Another thing i would really like is to restrict moves input to the pokemons possible moves.
I would really love to incorporate a stats/history page like you suggest, but I haven't figured out a way to do it using formulas (and avoiding scripts).
I appriciate how much you have already done without formulas.
You would surely need a sheet with pokemons and their moves. In another google-document, (i do not know who compiled it) there is a sheet with a list of all pokemons with all their movesets - more than 1500 lines.
I think, for doing statistics, it would be sufficient to have a field with a number (number of runs, initialized with 1) and you could add further lines under actual battle simulation to do more simulations.
I can definitely limit the moves to the appropriate pokemon. I just haven't done that to date since I haven't found a good source for the mapping, but I'm sure I could find it.
For the statistics, if you don't mind copying and pasting, I could add them to the Battle History sheet. It shouldn't be too hard to do once the data is there.
