Reply to thread

Message

<blockquote data-quote="deleteme123456" data-source="post: 4364508" data-attributes="member: 65832">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 &quot;weapon&quot; 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. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile&nbsp; &nbsp; :)"&nbsp; data-smilie="1"data-shortname=":)" /></blockquote>

[QUOTE="deleteme123456, post: 4364508, member: 65832"] 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) [B]or if you did not choose a weapon for that attack bonus[/B], 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. :) [/QUOTE]

Verification