Quality Bonus Spreadsheet

Forum for alternative clients, mods & discussions on the same.

Quality Bonus Spreadsheet

Postby Strandmullen » Mon May 06, 2019 2:45 am

When crafting gear/gildings you often want to maximize the stat bonuses from items whilst minimizing the quality of materials you need to use. It is however bothersome to calculate the required quality for specific stat bonuses all the time. So I made a spreadsheet which shows the minimum quality you need for an item to get a stat bonus X from an item which has quality 10 bonus Y.

Say I want to craft a bear tooth talisman which has +3 strength bonus at quality 10. I have a string quality 100 and two bear teeth, one quality 110 and one quality 140. These would result in amulets of quality 105 or 120. The threshold for 8 strength is quality 100.28 and for 9 strength it's 122.50. This means both amulets would give the same 8 strength, so I might as well use the quality 110 tooth to not waste my higher quality one.

I don't know if anyone else actually bothers to do this optimization, but thought I'd share it.

The bonus formula is:
bonus = q10Bonus * sqrt(qItem / 10)

The bonus is rounded to the nearest integer, so the right hand side threshold is every value at x.5. This gives the required item quality formula:
qReq = 10 * ((bonus - 0.5) / q10Bonus)^2
User avatar
Posts: 452
Joined: Sat Mar 31, 2012 11:37 pm
Location: Sweden

Return to The Wizards' Tower

Who is online

Users browsing this forum: No registered users and 5 guests