My friends and I are working on something like this. It will be an at the table, on the laptop dealio...Plane Sailing said:One option would be to have a grid (or spreadsheet) with PC's along the top and modifiers down the side - a fat column for each PC with four sub-columns each (hit, damage, ac, saves).
In Excel, you can do MAX(ColumnA), so you only get the maximum value for any given bonus type. Of course, you just change that to SUM(ColumnB) for things like Dodge and circumstance bonuses that stack with each other. Our final version will have mini character sheets, with a "database" spreadsheet with spells and their effects. Then there will be a main sheet that we can reference that shows which spells/items/etc any given character has active at a time, and their total modifiers.
Jason