Originally Posted by Aldriana
In order to handle unique gems, you would need to have two lists of gems: a list of which gems can be selected by the user while inputting their gear, and a list of which gems can be used by the spreadsheet while making socketing recommendations.
|
just 1 more column - something like "NotUnique" or "CanBeRecommended"
then multiply this and item value, making it 0 for unique gems (this might need 2nd column)