I made the changes I described above to accomodate changing attribute values. I also updated the sheet to allow [W] in a damage dice expression. This works as follows:
1: You must have a weapon associated with the chosen attack bonus (see also point 3 below).
2: That weapon must be one listed in the PHB with its correct damage value. (This wouldn't be that hard to change later to allow custom weapons.)
3: The Damage Dice row in the Attacks sheet is parsed for x[W] and multiplies that out, so for example, 4[W] where [W] is 2d6 becomes 8d6. If the "weapon" you have chosen for that attack is something without damage (like a Holy Symbol)
or if you did not choose a weapon for that attack bonus, the expression will come through as x[W] instead with no replacement, allowing you to do the math.
4: If the Damage Dice row contains an expression like 2d4 (say, for Magic Missile), then no replacement is done because there is no weapon.
I have not tested this in OpenOffice. In fact, the only testing I've done is on Excel 2003.
I can't just give you the formula to place in the damage row because it was getting so ugly and complicated that I needed to do intermediate calculations in another sheet (to the author: I used Transport Attack for this).
So have at it. To the author: I retain no rights to this work and provide it freely to you. Enjoy.
