TOPIC: Amorgen's Character Designer (Excel Spreadsheet)

Per Jeff, Ability Scores should be calculated accordingly:
Ability Scores: Ability Score Bonus (or penalty)
0 - 1: -5
2 - 3: -4
4 - 5: -3
6 - 7: -2
8 - 9: -1
10 - 11: 0
12 - 13: +1
14 - 15: +2
16 - 17: +3
18 - 19: +4
20 - 21: +5
etc.

In my opinion, if one rounds –.5 "down" to 0, one is actually rounding up.

Druegar wrote: Per Jeff, Ability Scores should be calculated accordingly:
Ability Scores: Ability Score Bonus (or penalty)
0 - 1: -5
2 - 3: -4
4 - 5: -3
6 - 7: -2
8 - 9: -1
10 - 11: 0
12 - 13: +1
14 - 15: +2
16 - 17: +3
18 - 19: +4
20 - 21: +5
etc.

In my opinion, if one rounds –.5 "down" to 0, one is actually rounding up.

Thank you very much for the clarification.

Just had to poke the bear didn't you. Ok, so the calculation has to change. My first thought was attribute bonuses will have to go to a table lookup, but then the light bulb went on. If we change the equation to:

bonus = (Integer of (Attribute / 2)) - 5

I think this will work, assuming your choice of the Integer function rounds down. I will look at adopting this in the next rev of the Character Generator. It still gets to be an issue if the attribute drops below 0, but then the character should be dead anyway.

In Excel you could use

=FLOOR.MATH(Attribute/2)-5

Cranston wrote: Just had to poke the bear didn't you. Ok, so the calculation has to change. My first thought was attribute bonuses will have to go to a table lookup, but then the light bulb went on. If we change the equation to:

bonus = (Integer of (Attribute / 2)) - 5

I think this will work, assuming your choice of the Integer function rounds down. I will look at adopting this in the next rev of the Character Generator. It still gets to be an issue if the attribute drops below 0, but then the character should be dead anyway.

Hahaha, whoops. I know some bears wont be happy about it.

How I calculate bonus is

int(Floor(((Attribute-10)/2)))

Of course your mileage may vary. I'm doing my programming in Python.

Joshua Long wrote: I know some bears won't be happy about it.

How does the otter feel about it?

Cranston wrote: Just had to poke the bear didn't you. Ok, so the calculation has to change. My first thought was attribute bonuses will have to go to a table lookup, but then the light bulb went on. If we change the equation to:

bonus = (Integer of (Attribute / 2)) - 5

I think this will work, assuming your choice of the Integer function rounds down. I will look at adopting this in the next rev of the Character Generator. It still gets to be an issue if the attribute drops below 0, but then the character should be dead anyway.

Bonus = Round((Attribute-1)/2) - 5 will work with the normal rounding where .5 rounds to 1, 1.5 to 2, etc. in case you need to avoid the floor function.

Druegar wrote: Per Jeff, Ability Scores should be calculated accordingly:
Ability Scores: Ability Score Bonus (or penalty)
0 - 1: -5
2 - 3: -4
4 - 5: -3
6 - 7: -2
8 - 9: -1
10 - 11: 0
12 - 13: +1
14 - 15: +2
16 - 17: +3
18 - 19: +4
20 - 21: +5
etc.

In my opinion, if one rounds –.5 "down" to 0, one is actually rounding up.

So I get to tell Excel it is wrong. Why why why couldn't we have let sleeping dogs lie.

Druegar wrote:

Joshua Long wrote: I know some bears won't be happy about it.

How does the otter feel about it?

Unfortunately I wouldn't know.

Amorgen Burke wrote: So I get to tell Excel it is wrong. Why why why couldn't we have let sleeping dogs lie.

Sorry, it is my fault.

Excel does some pretty weird things with ROUNDDOWN and FLOOR. However, doing =INT(((ATTRIBUTE-10)/2)) should produce the desired calculations.

Probably another unpopular observation...

Monk is able to equip an offhand (mostly flurry of blows compatible) weapon even when their mainhand does not have a flurry of blows compatible weapon equipped. (that is one handed)

This gives the impression one can equip and attack with two one handed weapons as a monk even when the mainhand is not flurry of blows compatible.

Druegar wrote:

Joshua Long wrote: I know some bears won't be happy about it.

How does the otter feel about it?

He otter have known better....

First version with 2017 tokens!!!

Version 2017.01 Notes

• Added 2017 new tokens including completion token Pants of Retrieval
• Fixed calculation for tokens that benefit from empty charm slots
• Changed ability score calculation so that rounding is different for scores less than 10
• Fixed Kris to be no longer a compound weapon
• Fixed name of the +2 Deadly Drow Blood Mace
• Fixed penalty of the Plate Armor of the Depths
• Added Token IDs to those missing them
• Fixed some missing effect tags
• Fixed Earcuff of Ramparts
• Fixed Dragonbane Surcoat
• Fixed Gloves of the Brute