Brewin's Gamebook Combat Simulator!
Well this is something I put together for another gamebook system EDIT: which I can now announce is none other than J.H.Brennan's classic Sagas of the Demonspawn series, that is to be digitally released through Tin Man Games as announced HERE. An experience that is quite surreal for me since J.H. "Herbie" Brennan is my favourite gamebook author and a childhood idol: to say it's an honour is a massive understatement! ...So having done this work, it was a "relatively" simple thing to adapt it to other gamebook systems that I know others are/have writing/written for: namely the Fighting Fantasy and Gamebook Adventures systems. (The GA system involves quite a lot more calculation though, although from a player point of view, it's only slightly more complicated than the FF system).
So if you're ever writing for either of these systems, and want a tool to help you determine how hard a particular combat is, how long it will last for etc, then this is what you need... Or maybe you're just curious to know what your chances are of surviving a particular combat or series of them in XYZ gamebook. This tool will give you a pretty definitive answer... And yes, it also demonstrates points I've made before about how well balanced (or unbalanced) these gamebook systems can be.
I'll spare you the detailed analysis, as you're now able to crunch out the numbers yourself. With this tool, you can set Player and Enemy stats yourself, or use Max/Min/Average/Random Player stats, set a number of other variables for the combat, and then run 10, 100, 1000 or whatever number of trials you want and get a stats summary that can also be written out to a report as well if you wish.
Hopefully you can figure out how to use it (I've tried to make it a simple as possible). All you need is Excel 97 or later (maybe Open Office will work too, I haven't tried) and to enable macros...
Let me know what you think (and if you'd like additions)
Happy number crunching :)