I’m not sharing the Gamemaster rules and resources until after the first game finishes for obvious reasons. Of course I don’t want the players to have access to the bestiary but, more so, I’m still working through the math and want to keep formula edits behind the curtain.
But I wanted to share the most exciting tab in the Gamemaster Spreadsheet – Action Resolution. This is where all of the data from the rest of the spreadsheet is pulled together to determine the results of actions.
On the left, we have the player character primary stats pulled over from the Player Data tab.
On the right, we have the enemy stats (notice that they’re much simpler) from the specific Era’s NPC tab. I’m not linking to that data at this point – because there are a lot of NPCs – but just copying and pasting the relevant data into the right (which is why I didn’t include it in the screenshot).
And in the center are the formulas including random number generation. To generate new numbers I just need to click on the player character dropdown.
This is pretty basic currently but I plan to add more functionality as we go. It would be cool, for instance, to add conditionally formatting so that evasion displayed ‘Miss‘, ‘Hit‘, or ‘Critical‘ instead of the number. Then, of course, I could add If statements to the damage formula to show 0s on a miss and double damage on a critical.
This central column is also going to get very cluttered as Techs begin to get added below.
In play, this set-up is actually faster than dice for tabletop. Much faster. But the downside is that the Game Master has to enter all the unique formulas before play.
Chrono Trigger has surprisingly complicated damage formulas that, often, use the number 256. This was probably due to a limitation of the SNES chipset but it makes for some interesting math.
Something I love about using a spreadsheet for Action Resolution, instead of dice, is that it can actually emulate weird and complex game math. I’ll be nerding out about how this plays into the basic Attack formulas in future posts.