Developing the spreadsheet only took a couple of hours. I started with a basic D&D character sheet on the first page. It has the basic character information: name, race, class level, xp, traits (i.e. Strength, Wisdom, etc.) and abilities. I thought of adding feats and merits and flaws, but I thought that keeping it simple was the way to go.
The next step was to define some of the rules of the system. Some of these rules come straight out of D&D. The six basic traits are the same as the D&D ones with the bonuses that come from them calculated the same as well. Abilities are a set of skills that will garner bonus XP for activities. Each one has a trait that goes with it (i.e. the Aerobic ability goes with the Constitution trait) that gives a bonus (or detriment if your trait is low enough). Rather than using abilities to determine whether or not an action was successful, they instead award bonus XP when you complete an activity. This way, you can increase the amount of XP you gain for certain activities as a way to motivate yourself to gain levels faster.
The next thing that I did was to start making a list of activities. Each activity has an ability that goes with it (i.e. Jogging goes with the Aerobic ability) and a rate at which it awards XP (i.e. Jogging gives 5 points per 10 minutes). Once I had a decent list of activities and a pretty complete list of abilities, I went on to define the races and classes. I knew that your chosen race would adjust your trait scores (similar to D&D), but I didn’t quite know what a class would do for you. In D&D, your class effects your combat ability, the amount of abilities you get and a number of irrelevant items. I wanted the system to be fair, so I didn’t want a rogue to get more abilities than a barbarian (like in traditional D&D) because then a rogue would get XP so much faster. I looked back at what Ken Denmead (see my last post) did in his system, and thought that I could use a similar idea. He gave each class two bonus skills tags (I won’t explain tags, I didn’t employ that idea), so I thought that I could give each class two bonus abilities instead. This would help differentiate each class and would help someone specialize their character in two abilities to gain more XP in those two areas.
Right about now I was feeling pretty good about the completeness of the system. I entered the day’s activities as a way of testing the system and after a few minor adjustments I called my work complete. I tracked the next couple of days until I got home from my business trip. I showed the system to my wife and she was on board. We discussed the goal (level 10) and the Major Prize ™ and settled on something we could both agree upon. We also made a couple of minor changes to the system and added a bunch of activities that she thought of that I hadn’t. The game was afoot!
We weighed in and started tracking our activities, I started over in order to be fair (I had amassed some XP in my testing days). It hasn’t been too long, but she is leading by about 10%. I’m not too worried about the deficit. I think that I can bridge the gap and the game has just begun anyways. I would like to mention that my mother-in-law and my wife have also begun a separate challenge between the two of them. They aren’t using the same D&D style system, but their system is points based as well. I’m not privy to all of the details of their challenge, but I know that their activity list is different and I’m sure that the point values are too.
I plan to post an update in perhaps a month to let you all know how the system is working out. If you are interested in having the spreadsheet, please leave a comment with your email (or contact me privately if you know me personally) and I’ll send it out to you.
I’ll post some screenshots in the space below, so keep reading if you’d like to see them.
Favorite song of the moment: Supercommuter – Itty Bitty Pigeons
None of these screenshots show the inner workings of the spreadsheet, if you want these details contact me and I will send you the sheet. It works pretty much on formulas and lookups without the use of macros.
This is the generic info for a character. The race and class boxes are drop downs for easy entry. The XP boxes will also automatically fill themselves out based on your activities and level.
These are the character's traits. All you have to do is enter the score you have and the bonuses will be automatically calculated. The zero at the bottom is the number of traits you have left to distribute among the six options. Instead of rolling, I chose to allow manual distribution starting with each score at a 10 (then modifying for race) and giving 18 points for distribution. Also, at every third level you get an additional point (i.e. the zero will change to a one automatically at level three).
This is the list of abilities for a character. You start with six abilities to apply in the ranks column and you will get six at each level. The number in the bottom row will update when a level is made showing how many ranks are left to assign.
This is a sample of entering activities in the sheet. The activity boxes are all drop downs allowing for easy data entry. The types then are automatically filled out based on the activity and the points will be automatically calculated when a volume is entered for the activity. The bonus is also automatic as is the total. One issue is that if you add ranks to a skill, the total will automatically adjust, hence the banked points column. You must hand enter this and it will update the XP on the character sheet.
