Welcome, Guest
Username: Password: Remember me

TOPIC: Amorgen's Character Designer (Excel Spreadsheet)

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1057

Don't fall out of your chair. I have finally found the time and the method to resolve the issues caused by the 2020 tokens and changes. Since I did have to change some formulas, please let me know if I broke anything as charm and ioun stone slots are dynamically determined based on tokens equipped and whether a token is able to be equipped changed as well. I think I've caught everything up from the forum. Here are the notes:

Version 2020.01 Notes
  • Added 2020 tokens and any missing 2019 tokens (such as completion tokens)
  • Fixed Belt of Berserker (both name and class restrictions)
  • Updated method of determining active Charms and Ioun Stones and adjusted number of slots to match the stated maximums
  • Updated Ranged Damage so that a mighty or thrown weapon will reflect negative strength modifiers, not just positive ones
  • Changed the formulas that support whether a token can be equipped or not to better handle if more than one token has a stacking restriction.
  • Adjusted Polymorph damage field to add the melee damage bonus, for consistency

As a quick note, I did not implement any changes to the party card regarding spell to hit as this will need to be decided by TPTB. If they add it, I'll be happy to do so.

Please Log in or Create an account to join the conversation.

Last edit: by Amorgen Burke.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1058

SWEET!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Been waiting for this and will be loading builds before the super bowl!!

Thanks so much for all your work on this!!
"Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world." - Albert Einstein

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1059

Amorgen Burke wrote: Don't fall out of your chair. I have finally found the time and the method to resolve the issues caused by the 2020 tokens and changes. Since I did have to change some formulas, please let me know if I broke anything as charm and ioun stone slots are dynamically determined based on tokens equipped and whether a token is able to be equipped changed as well. I think I've caught everything up from the forum. Here are the notes:

Version 2020.01 Notes

  • Added 2020 tokens and any missing 2019 tokens (such as completion tokens)
  • Fixed Belt of Berserker (both name and class restrictions)
  • Updated method of determining active Charms and Ioun Stones and adjusted number of slots to match the stated maximums
  • Updated Ranged Damage so that a mighty or thrown weapon will reflect negative strength modifiers, not just positive ones
  • Changed the formulas that support whether a token can be equipped or not to better handle if more than one token has a stacking restriction.
  • Adjusted Polymorph damage field to add the melee damage bonus, for consistency

As a quick note, I did not implement any changes to the party card regarding spell to hit as this will need to be decided by TPTB. If they add it, I'll be happy to do so.


This message has an attachment image.
Please log in or register to see it.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1060

Ava's +5 Holy Avenger is not conveying +5 to hit (I think it's conveying +0).

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1061

Matthew Hayward wrote: Ava's +5 Holy Avenger is not conveying +5 to hit (I think it's conveying +0).


Noted for next update. I also discovered that I broke the Ring of Wonder which I'll also fix next update. I'll wait a day or two to process these in case more issues are found.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1062

Awesome, awesome, awesome!

Did I say AWESOME!

Thanks SO much!

Take a bonus out of petty cash. ;-)

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1063

I believe +1 Assassin's blade is missing some properties:

a. I am getting one less +1 to hit with it - not sure if it's not getting the +1, or if it's not interacting with Enchanter's Whetstone.

b. It doesn't seem to be monk FoB compatible.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1064

+1 Heavy Claymore and Enchanter's Whetstone don't seem to be interacting with one another.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 3 weeks ago #1065

+1 Large Wooden Shield is conveying +1 AC instead of +3 AC.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 2 weeks ago #1066

Version 2020.02 Notes
  • Reviewed all 2020 weapons and fixed any incorrect tagging (flurry of blows compatibility, to hits, material types, rarity).  These should properly work now (including the whetstone when applicable)
  • Fixed the +1 Large Wooden Shield to convey +3 AC
  • Added the ability to equip Flurry of Blows compatible weapons (not bracers) to be included as a thrown weapon in the Ranged Mainhand provided that the Benrow's is already equipped in the Neck Slot.  Also changed the +7 Sacred to be conditional on the weapon being Flurry of Blows compatible.
  • Added ability for a token to convey more than one damage type.  This was necessary due to being able to throw the Flaming Sword, for instance, and still get the Sacred damage from the Benrow's.
  • Fixed Ring of Wonder in such a way that it should stay working even after sorting the token list.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 2 weeks ago #1067

  • Kakitahan
  • Kakitahan 's Avatar
  • Offline
  • 8th Level
  • Supporter
  • Honored Monk of the Hidden Fist - Everquest
  • Posts: 647
I was attempting to equip a +2 flaming blade on my Monk on the off hand but it is not an option.

Please Log in or Create an account to join the conversation.

Amorgen's Character Designer (Excel Spreadsheet) 1 month 2 weeks ago #1068

  • jedibcg
  • jedibcg's Avatar
  • Away
  • 8th Level
  • Supporter
  • What is personal text?
  • Posts: 8012
Pendant of the Yew may be missing some of its extra text for token description. It doesn't mention the +6 to range damage. It adds it correctly but just doesn't mention it. It confused me at first because I forgot what it did exactly and it was throwing my numbers off and I couldn't figure out why. Not a biggie imo, but just something worth pointing out.
You either discover a star or you don't. You arrogant punk.

Please Log in or Create an account to join the conversation.

Last edit: by jedibcg.
Time to create page: 0.204 seconds