TOPIC: Amorgen's Character Designer (Excel Spreadsheet)

Version 2014.35 Notes

• Corrected the name of the Coronet of the Arch-Druid from "Circlet"
• Corrected the name of "Figurine of Power: Owl" (the colon had been omitted)
• Although only for database completeness since you cannot slot the token, corrected the name of "1 Day's Hard Ration" which had been made plural (Rations) in error.
• Carried the display of Avg. Damage down so that any slot can show an average damage should it have a damage wheel (example: "Coronet of the Arch-Druid")

I've submitted for the programmers to fix the online character designer as it shows the Coronet as Circlet also (and was the source of the error on the Excel version).

Version 2014.4 Notes

• Corrected the name of the Bulette Chitin Armor (from "Chittin")
• Ring of Reflexes was showing up twice as a selection, now only once
• Added Minotaur Horn of Alert to the Special slot dropdown
• Fixed an issue where the AC vs. Ranged bonus would double if you selected Shield of Deflection for both Melee Offhand and Ranged Offhand

Version 2014.5 Notes

• Adding in additional infrastructure to support the Elemental Eldritch Set Bonus and the Rod of Seven Parts (Complete) caused a problem with the Viper Strike Set Bonus whereby relic or legendary level where not individually counted when 2 of the same where slotted in the melee slots. This has now been resolved.

I'm comparing the official character generator and the spreadsheet for a Level 5 Ranger and it looks like the spreadsheet gets one thing wrong. I'm using version 2014.5.

Sharpshooter gives +4 to damage with a bow, crossbow, or sling. If I equip the +2 Keen Longbow to the Ranger it doesn't give me the +4 damage for missile.

Secondly, how do I figure out what the base AC is for a Level 5 ranger? I don't see it on the character card and I'm not sure how to calculate it based on other stats. For some reason the AC in the Excel spreadsheet is 1 higher than the AC in the official tool and I'm not sure which is correct. For melee I have +12 to my AC and it shows me at 27 in Excel, but 26 in the official tool.

Thanks for the hard work on this, it is great!

Also I noticed the Lenses of Divine Sight are abasent - minor thing as it's just textual and dosent affect stats. I wouldnt have mentioned it unless I knew you were adding another thing...

Thanks as always!

Kirk Bauer wrote: Sharpshooter gives +4 to damage with a bow, crossbow, or sling. If I equip the +2 Keen Longbow to the Ranger it doesn't give me the +4 damage for missile.

Fixed in 2014.55 releasing shortly.

Kirk Bauer wrote: Secondly, how do I figure out what the base AC is for a Level 5 ranger? I don't see it on the character card and I'm not sure how to calculate it based on other stats. For some reason the AC in the Excel spreadsheet is 1 higher than the AC in the official tool and I'm not sure which is correct. For melee I have +12 to my AC and it shows me at 27 in Excel, but 26 in the official tool.

Without knowing your specific build, I can't say which is more accurate in your exact scenario (although I tend to consider the spreadsheet more reliable than the online version thanks to the having direct control and the awesome help from the forum to catch any oversights). Both are officially acceptable.

As for base, all but the Monk officially start at 10. When you take in consideration the base Dexterity for a Ranger, it will yield 13. Because the Ranger's 5th level attribute bump is in Dexterity, it rises to 14. Since the AC is actually computed from the final Dexterity plus any direct AC enhancers, the 27 should be correct unless there is an unidentified typo somewhere in the database for one of the pieces of your equipment.

If you want, you can send me your equipment list and I'll be happy to determine what is the correct value.

Fizzikx wrote: Also I noticed the Lenses of Divine Sight are abasent - minor thing as it's just textual and dosent affect stats. I wouldnt have mentioned it unless I knew you were adding another thing...

Thanks as always!

I checked and Lenses of Divine Sight are functioning properly. The only time it will show in the list of Eye slot tokens is if you are a Cleric or Druid with a wisdom of 20 or higher.

Version 2014.55 is now live

- Fixed Sharpshooter bonus for +2 Keen Longbow

Amorgen Burke wrote:

Fizzikx wrote: Also I noticed the Lenses of Divine Sight are abasent - minor thing as it's just textual and dosent affect stats. I wouldnt have mentioned it unless I knew you were adding another thing...

Thanks as always!

I checked and Lenses of Divine Sight are functioning properly. The only time it will show in the list of Eye slot tokens is if you are a Cleric or Druid with a wisdom of 20 or higher.

Ohhh yeah Forgot about that Wisdom hard Req.

Thanks Amorgen!

I can't find any other issues with the Character Generator, thank you! I am curious, though, about one thing. In the "official" online version, at least for several Level 5's (Fighter, Ranger, etc), it shows the base strength as one too low, but your spreadsheet matches the character card correctly. Also, in my case, your numbers are 1AC higher for my builds than the official online generator. I ran the math and yours seems to be correct in all cases.

I'm just curious if you know the reason for those differences. I suppose it could just be bugs in the other tool, but I was wondering if things changed in recent years or something. Is the other tool being actively used? I tend to like to use both of them side-by-side especially if I don't have the actual tokens in front of me.

Kirk Bauer wrote: I can't find any other issues with the Character Generator, thank you! I am curious, though, about one thing. In the "official" online version, at least for several Level 5's (Fighter, Ranger, etc), it shows the base strength as one too low, but your spreadsheet matches the character card correctly. Also, in my case, your numbers are 1AC higher for my builds than the official online generator. I ran the math and yours seems to be correct in all cases.

I'm just curious if you know the reason for those differences. I suppose it could just be bugs in the other tool, but I was wondering if things changed in recent years or something. Is the other tool being actively used? I tend to like to use both of them side-by-side especially if I don't have the actual tokens in front of me.

The last few years the online character builder has displayed a couple minor 1 off bugs for me as well - compared to both a manual calc and david's spreadsheet.

They made a few tweaks to the starting stats a year or two ago to make more classes have odd number stats for things like strength and dexterity. I wonder if the online wasn't updated to the new values. It would explain a lot.

There is another thread specifically for the online character designer. This should be raised on that thread with specifics of the issues. Ultimately, any errors would have to be fixed by the programmer of the online.