Like most RM/SM GMs with any knowledge of spreadsheets, I've made my own to facilitate the game... and of course *none* of the work on this happened during work time. Version 2 offers:
- All professions from PB, SpaMCo 1 & 2
- Automatic calculation of stat bonuses
- Automatic assignment of level bonuses by profession
- Calculation of stat gain results when levelling so you just have to record your results and copy/paste your new stats to the relevant area
- Every skill listed (except for some obscure break out skills like medical science specialisations - RM weapons also not there although all SM ones are. The players are muttering about playing Rolemaster so I may need to include those too)
- Automatic calculation of stat bonus
- Automatic calculation of skill rank bonus
- Automatic assignment of similar skills, extended from the RM similar skills rules to cover all SM ones too
- Automatic Skill bonus calculation
- Ability to mark how many ranks of which skill to improve at level up (with protection from entering more skill ranks than you can train)
- Automatic calculation of DP spent towards next level
- Automatic calculation of hit points
- Automatic calculation of movement speed, including gravity as well as encumbrance
- Automatic calculation of skill penalties in variant gravity fields
- Ability to assign weapon groups so that weapon costs propagate correctly
- Size of the character pages reduced from v.1 so almost all look up calculations are performed elsewhere, meaning you can keep track of a sheaf of PCs (and/or NPCs) without neeting Terabyte level storage
Unfortunately, it doesn't make the coffee or order in pizza. But it does make levelling up take about 90 seconds if you know what you're doing... so creating and levelling up NPCs with genuine stat blocks becomes a breeze, and also the players can level during play without it marking the end of the session.
v.2.1 to include some love for telepaths and DP spend on psion lists
Things to be included in V3 (if I ever get the time)
skill calculations - primarily for calculation attack roll - so all the player has to do is select the weapon and type in his roll, any special ammo used, penalties from the GM and AT... and it will do the lookup for the final result and tell you what kind of critical table to roll on. So someone using a conventional rifle (mk 4) with HEAPDUCIC ammunition against AT 12 (+1 mark, +10 vs AT 9-20, secondary internal disruption critical) might get a result that would say 12 hits, C puncture critical, C internal disruption critical. And so on. That is a quite daunting level of data entry though.
V3.1 to expand that to cover all skills - easy job that if weapons are cracked.
V4.0 will require me to remember how to do macros so I can do a "Level up" button that will do all that stuff for you.