Sorry... I think my point in here was covered in a prior post.
Out of curiosity, M, what do you consider "clutter" on the spreadsheet? Most of the calculations there are fairly easy to perform because I've got named arrays on another sheet, so it works something like this:
1. Pick the first, second, and third attacks from the drop-down fields in columns B and D.
2. Enter your stats in B19:B24 and D19:D24. (These will eventually pull from item stats on another sheet.)
3. Enter whatever values you want to compare in the "Change" fields between F26 and P26.
Everything else is calculated by means of the INDEX and MATCH functions and a handful of named arrays. So it's probably messy by JS standards, but it's clean compared to spreadsheet that rely heavily on IF, LOOKUP, VLOOKUP, HLOOKUP, and hardcoded arrays. Just looking for more information, thanks! :)
the double attribute enchantment is solid, but the single attribute enchantments are not.
So I would not want a rare spirit stone with more than 100 dexterity or 100 vitality.
The following enchantments are must haves for an end game rare spirit stone:
6% Crit Chance
2.50 Spirit Regeneration for farming
1 Socket if not 100 Paragon
The following enchantments are very good for an end game rare spirit stone:
14% Sweeping Wind/Fist of Thunder
80 Resist All
1 Socket even if 100 Paragon
The remaining slots should be filled with the following enchantments:
60 Resist Element
397 Bonus Armor
63.9 Life per Spirit Spent
This seems to suggest that you are discounting the 100 dex & 100 vit stat, but you are also saying that 100 dex on its own, or 100 vit on its own is good - is that right? I would have thought that the 100 dex & 100 vit enchantment is better than having simply 100 dex or 100 vit. Or am I completely missing something?]
Threats of violence. We take these seriously and will alert the proper authorities.
Posts containing personal information about other players. This includes physical addresses, e-mail addresses, phone numbers, and inappropriate photos and/or videos.
Harassing or discriminatory language. This will not be tolerated.