Artifact Ranking

[pistolshrimp]

In the interest of optimizing space, ie what should I save/what should I trash, I wrote a python script which analyzed Artifacts and gave them value. I'm going to dump the data here in case anyone else is in a similar spot/ is the same level of OCD about organization.

Methodology

I used the table data on Artifacts on the wiki and removed items which gave Slots or Pockets. Next I added the Productivity value to the civilian bonuses and then deleted that column.

The table was then sorted and the top 10 of each bonus type were singled out (8 max slots plus two extras given the difficulty of finding some of the top level artifacts). These 10 were ranked and given a score based on exponential growth starting at 1 and totally a 100 points all together. (Rank 10 = 1 point , Rank 2= 2 points, 3 = 3 points, 4 points, 5 points, 8 points, 11 points, 15 points, 21 points, and finally Rank 1 = 30 points.) This means that the Rank 1 item is exponentially better than the Rank 10 item. Ties were preserved and given the same values so in some cases the total value of the top 10 of a particular bonus may not exactly equal 100 points.

After all top 10s of each bonus were valued they were put back together and similar Items were combined together again and the points added up. So for instance if Golden Fleece was rank 1 in Affluence and rank 2 in Impact Defense it would get a total of 51 points.

Info

25 Best Artifacts in the Game

Pinocchio's Nose 87
Arcane Amethyst 76
Golden Fleece 62
March Hare Tail 60
Unthrown Argo Branch 60
Pig Tail 59
Silver Platter 56
Bear Paw 54
Whispering Snake Skull 51
Bull Horn 50
Needle 49
Fine Leather 49
Gold Buttons 46
Lobster Claw 45
Yellow Rose 43
Runestone Shard 42
Chantilly Lace 42
Beaming-Proud Sunflower 38
Silver Buckle 38
Black Pearl 34
Gold Leaf Pin 33
Pearl 33
Glass Beadwork 30
Bear Claw 30
Shark Tooth 30

All Scored Artifacts

Pinocchio's Nose 87
Arcane Amethyst 76
Golden Fleece 62
March Hare Tail 60
Unthrown Argo Branch 60
Pig Tail 59
Silver Platter 56
Bear Paw 54
Whispering Snake Skull 51
Bull Horn 50
Needle 49
Fine Leather 49
Gold Buttons 46
Lobster Claw 45
Yellow Rose 43
Runestone Shard 42
Chantilly Lace 42
Beaming-Proud Sunflower 38
Silver Buckle 38
Black Pearl 34
Gold Leaf Pin 33
Pearl 33
Glass Beadwork 30
Bear Claw 30
Shark Tooth 30
Sterling Geode 30
Badge of Carnage 30
Blistersteel Buckle 29
Gold Buckle 27
Glass Buttons 27
Foul-Feathered Brooch 25
Embroidery 23
Studded Leather 22
Wool Quilting 22
Badge of Fyre 21
Orange Easter Egg 21
Etterfang 19
Antler Buttons 16
Polished Buttons 15
Polished Leather Beadwork 15
Rainbow Scales 15
Colored Flagstraps 15
Traces of the Lost Colony 15
Argopelter Beak 15
Badge of Ruin 15
Amber Pin 15
Lacy Edging 15
Cattail 15
Oddly Shaped Pinecone Scale 13
Feather Down 12
Polished Scale Pin 11
Rattle Rattler 11
Indian Feather 11
Badge of Plunder 11
Copper Buckle 11
Bone Beadwork 11
Spidersilk Weft 10
Starburst-Cut Uvarovite 10
Starburst-Cut Dravite 10
Majestic Acorn 8
Feathered Brooch 8
Buckskin Inlays 8
Cabochon-Cut Uvarovite 8
Square-Cut Dravite 8
Square-Cut Uvarovite 8
Lamb of Tartary 8
Cabochon-Cut Dravite 8
Pear-Cut Uvarovite 8
Pear-Cut Dravite 8
Badge of Intrusion 8
Nails 8
Starburst-Cut Phosphophyllite 6
Starburst-Cut Rubellite 6
Stringy Sinew 5
Badge of Battery 5
A Face in the Dross 5
Serrated Grimthorn 5
Abandoned Cobweb 5
Skullpin 4
Badge of Aggression 4
Iron Buckles 4
Indian Arrowhead 4
Pear-Cut Phosphophyllite 4
Pear-Cut Rubellite 4
Cabochon-Cut Phosphophyllite 4
Fine Beaver Teeth 4
Copper Buttons 4
Square-Cut Rubellite 4
Square-Cut Phosphophyllite 4
Cabochon-Cut Rubellite 4
Fluffy Stuffing 3
The Elusive Last Bone 3
Pottery Shard 3
Gnarly Old Crab Shield 3
Bone Buttons 1
Crab Claw 1

There were 14 Artifacts that got 0 points in total.

Colored Marbles
Dead Silk Runner
Enforced Seam
Fractured Gemstone
Leather-Knot Detail
Questionably Effective Nails
Raggy Hem
Rough-Stitched Furpatch
Rustic Stuffing
Seashell buttons
Sharpened Stick
Simple Crucifix
Smooth Stone
Tree Trimmings

Top 10 of Each Category

Affluence

Item Bonus Points
Golden Fleece 110 30
Orange Easter Egg 100 21
Silver Platter 75 15
Yellow Rose 65 11
Black Pearl 50 8
Sterling Geode 45 5
Pearl 30 4
Gold Buckle 14 3
Starburst-Cut Dravite 13 2
Starburst-Cut Phosphophyllite 13 2
Starburst-Cut Rubellite 13 2
Starburst-Cut Uvarovite 13 2

Alloying

Item Bonus Points
Silver Buckle 34 30
Blistersteel Buckle 32 21
Gold Buckle 32 21
Copper Buckle 17 11
Arcane Amethyst 15 8
Pinocchio's Nose 10 5
Bear Paw 8 4
Chantilly Lace 8 4
Glass Beadwork 8 4
Gold Leaf Pin 8 4
Iron Buckles 8 4
Runestone Shard 8 4

Blunt Defense

Item Bonus Points
Gold Buttons 20 30
Glass Buttons 14 21
Polished Buttons 12 15
Antler Buttons 10 11
Fine Leather 10 11
March Hare Tail 10 11
Copper Buttons 8 4
Studded Leather 8 4
Wool Quilting 8 4
Bone Buttons 6 1
Feather Down 6 1
Rainbow Scales 6 1

Blunt Power

Item Bonus Points
Pinocchio's Nose 21 30
Unthrown Argo Branch 18 21
Sterling Geode 13 15
Rattle Rattler 11 11
Arcane Amethyst 10 8
A Face in the Dross 9 5
Bull Horn 8 4
Beaming-Proud Sunflower 7 3
Gnarly Old Crab Shield 7 3
Needle 7 3

Common Combat Defense

Item Bonus Points
Lobster Claw 22 30
Whispering Snake Skull 17 21
Black Pearl 16 15
Yellow Rose 11 11
Pearl 9 8
Bear Paw 7 5
Blistersteel Buckle 7 5
Chantilly Lace 7 5
Glass Beadwork 7 5
Gold Leaf Pin 7 5
Runestone Shard 7 5

Common Combat Power

Item Bonus Points
Whispering Snake Skull 12 30
Pearl 8 21
Lobster Claw 6 15
Black Pearl 4 11

Feasting

Item Bonus Points
Pig Tail 46 30
Bear Paw 43 21
Argopelter Beak 26 15
Bull Horn 25 11
Silver Platter 25 11
Stringy Sinew 16 5
Cabochon-Cut Rubellite 15 4
Pear-Cut Rubellite 15 4
Square-Cut Rubellite 15 4
Starburst-Cut Rubellite 15 4

Feral Defense

Item Bonus Points
Unthrown Argo Branch 27 30
Bear Paw 25 21
Bear Claw 16 15
March Hare Tail 14 11
Etterfang 10 8
Antler Buttons 9 5
Fine Beaver Teeth 8 4
Rainbow Scales 7 3
Spidersilk Weft 6 2
Crab Claw 4 1

Impact Defense

Item Bonus Points
March Hare Tail 20 30
Golden Fleece 18 21
Wool Quilting 14 15
Feather Down 12 11
Fine Leather 10 8
Gold Buttons 10 8
Spidersilk Weft 10 8
Fluffy Stuffing 8 3
Glass Buttons 8 3
Studded Leather 8 3

Impact Power

Item Bonus Points
Beaming-Proud Sunflower 18 30
Embroidery 13 21
Colored Flagstraps 11 15
Pinocchio's Nose 11 15
Feathered Brooch 9 8
Bull Horn 8 5
Foul-Feathered Brooch 7 4
Needle 7 4
Skullpin 7 4
Unthrown Argo Branch 7 4

Mining

Item Bonus Points
Arcane Amethyst 45 30
Glass Beadwork 43 21
Polished Leather Beadwork 26 15
Bone Beadwork 16 11
Sterling Geode 15 8
Pinocchio's Nose 10 5
Silver Buckle 10 5
Bear Paw 8 3
Blistersteel Buckle 8 3
Chantilly Lace 8 3
Gold Buckle 8 3
Gold Leaf Pin 8 3
Runestone Shard 8 3

Piercing Defense

Fine Leather 20 30
Silver Platter 20 30
Studded Leather 14 15
Rainbow Scales 12 11
Buckskin Inlays 10 8
Gold Buttons 10 8
March Hare Tail 10 8
Glass Buttons 8 3
The Elusive Last Bone 8 3
Wool Quilting 8 3

Piercing Power

Item Bonus Points
Bull Horn 30 30
Needle 25 21
Bear Claw 18 15
Etterfang 13 11
Nails 10 8
Beaming-Proud Sunflower 7 5
Serrated Grimthorn 7 5
Unthrown Argo Branch 7 5
Embroidery 6 2
Sterling Geode 6 2

Rummaging

Item Bonus Points
Shark Tooth 9 30
Yellow Rose 8 21
Cattail 7 15
Oddly Shaped Pinecone Scale 5 11
Majestic Acorn 4 8
Pig Tail 4 8
Indian Arrowhead 2 4
Pottery Shard 1 3

Soil Digging

Item Bonus Points
Runestone Shard 43 30
Pig Tail 31 21
Traces of the Lost Colony 26 15
Indian Feather 16 11
Cabochon-Cut Dravite 15 8
Pear-Cut Dravite 15 8
Square-Cut Dravite 15 8
Starburst-Cut Dravite 15 8
Pinocchio's Nose 10 2
Silver Buckle 10 2

Spellpower

Item Bonus Points
Arcane Amethyst 20 30
Foul-Feathered Brooch 10 21

Weaving

Item Bonus Points
Chantilly Lace 43 30
Needle 30 21
Lacy Edging 26 15
Golden Fleece 25 11
Lamb of Tartary 21 8
Abandoned Cobweb 16 5
Cabochon-Cut Phosphophyllite 15 4
Pear-Cut Phosphophyllite 15 4
Square-Cut Phosphophyllite 15 4
Starburst-Cut Phosphophyllite 15 4

Woodworking

Item Bonus Points
Pinocchio's Nose 50 30
Gold Leaf Pin 43 21
Amber Pin 26 15
Polished Scale Pin 16 11
Cabochon-Cut Uvarovite 15 8
Pear-Cut Uvarovite 15 8
Square-Cut Uvarovite 15 8
Starburst-Cut Uvarovite 15 8
Oddly Shaped Pinecone Scale 12 2
Silver Buckle 10 1

Conclusions

This is just my personal opinion based on the data. You may have a different opionion here.

Buffs
I think of the 0 point items only Dead Silk Runner needed to be buffed, and then only slightly. Even tho they are low, I don't think Gnarly Old Crab Shield, and Crab Claw should really be above Dead Silk Runner which requires a greater effort to obtain.

Overall I think Gems should be buffed. For all the effort involved in them they are way lower in value then I'd expect. I get that the Affluence scales, but perhaps

Nerfs
Abandoned Cobweb, perphas switch its values with teh Dead Silk Runner. Bone Beadwork and Oddly Shaped Pinecone Scale seem a little high given their ease of obtaining

Code

Could be a lot cleaner, but bit really wanting to put in all that time.

Code: Select all

import numpy as np
import pandas as pd
import os

ProjectPath = os.path.dirname(os.path.abspath(__file__)) # Finds the path of the current file.
OutputPath = ProjectPath+"/Outputs/"
FinalPath = ProjectPath+"/Final/"


Input = pd.read_csv(ProjectPath+"/artifacts.csv") # Reads the csv.

ArtifactsList = ['Affluence', 'Alloying', 'Blunt Defence', 'Blunt Power', 'Common Combat Defence', 'Common Combat Power',
                 'Criminality', 'Feasting', 'Feral Defence', 'Impact Defence', 'Impact Power', 'Mining', 'Piercing Defence', 'Piercing Power', 
                 'Rummaging', 'Soil Digging', 'Spellpower', 'Weaving', 'Woodworking']

Bonuses = len(ArtifactsList) # Counts the length of the ArtifactsList.

Tally = 0
while Tally < Bonuses: # Sets the while loop to the number bonuses in the ArtifactsList.
    Bonus = (ArtifactsList[Tally])  # Sets the bonus type.
         
    Top10 = Input.nlargest(10, Bonus, keep='all') # Sorts the 10 highest values, keeping ties.
 
    Reduced = Top10[['Item', Bonus]] # Just prints the item name and the bonus.
    Reduced = Reduced.reset_index(drop=True) # Reset the index for adding in points.   
    Reduced = Reduced[(Reduced[['Item', Bonus]] != 0).all(axis=1)] # Drop the 0 values.
   
    Reduced['Rank'] = Reduced[Bonus].rank(method='min', ascending=False) # Ranks the values.
   
    Points = pd.Series([]) # Empty data series.
   
    for i in range(len(Reduced)): # Values the ranks.
        if Reduced["Rank"][i] == 1.0:
            Points[i]=30
     
        elif Reduced["Rank"][i] == 2.0:
            Points[i]=21
           
        elif Reduced["Rank"][i] == 3.0:
            Points[i]=15
           
        elif Reduced["Rank"][i] == 4.0:
            Points[i]=11
           
        elif Reduced["Rank"][i] == 5.0:
            Points[i]=8
           
        elif Reduced["Rank"][i] == 6.0:
            Points[i]=5
       
        elif Reduced["Rank"][i] == 7.0:
            Points[i]=4 
         
        elif Reduced["Rank"][i] == 8.0:
            Points[i]=3
       
        elif Reduced["Rank"][i] == 9.0:
            Points[i]=2
           
        elif Reduced["Rank"][i] == 10.0:
            Points[i]=1             
                                       
    Reduced.insert(2, "Points", Points)  # Inserts new column with values from Points. 
   
    Valued = Reduced[['Item', Bonus, 'Points']] # Combines everything together.
       
    Valued.to_csv(OutputPath+Bonus+".csv", index = None, header=True) # Exports csv.
   
    Tally += 1 # Moves the Tally loop forward.


AllValuedItems = pd.DataFrame() # Creates an empty dataframe.

Count = 0
while Count < Bonuses:  # Sets the while loop to the number bonuses in the ArtifactsList.
    Bonus = (ArtifactsList[Count])  # Sets the bonus type.
   
    InputFilePath = OutputPath+Bonus+".csv" # Sets the input path.
   
    Fields = ['Item', 'Points'] # Sets the fields pandas will look for.
    BonusInput = pd.read_csv(InputFilePath, usecols=Fields) # Reads the csv.
   
    AllValuedItems = AllValuedItems.append(BonusInput) # Adds to the empty dataframe.
   
    Count += 1 # Moves the Count loop forward.
   
Alphabetical = AllValuedItems.sort_values('Item') # Sort Items alphabetically.

Field = {'Points': 'sum'} # Aggregate function.
Combined = Alphabetical.groupby(Alphabetical['Item']).aggregate(Field) # Combines like names and adds points together.

# Combined.to_csv(FinalPath+"Check.csv", header=True)

Sorted = Combined.sort_values('Points', ascending=False) # Sort Points numerically.

Sorted.to_csv(FinalPath+"AllSorted.csv", header=True) # Exports csv.

[Icon]

Very nice work. TY for sharing

[Taipion]

Nicely done!

I do not fully agree on the gems though, they are far too common if you do mining, they are really cheap to get from other players or stalls,
if one were to buff them, they'd need to be more rare, or have their stats and not only their affluence tied to the carat value.

[pistolshrimp]

I do not fully agree on the gems though, they are far too common if you do mining, they are really cheap to get from other players or stalls,
if one were to buff them, they'd need to be more rare, or have their stats and not only their affluence tied to the carat value.

Hmmm, I really didn't think anyone would read the conclusions. I appreciate the responses tho. Let me better articulate my argument.

Elaborate Gemcutting requires an investment of 8300 Arts & Crafts, 16700 Law & Lore, and 21500 Mines & Mountains. I don't have the math off hand but that's a heck of a lot of inspiration. Starburst-Cut is only the 9th highest artifact in Affluence meaning it's a backup item at best. The other stats the Starburst-Cut offers are the same even at the Cabochon-Cut. So if you have access to the other Affluence items there is little reason to use anything but the most basic cut.

It is important for me to note that at .2 carrots the Starburst-Cut becomes the 8th best Artifact (15 vs Gold Buckle's 14) for min-maxing Affluence, but in order to become 7th best it would have to be an a whopping 1.8 carats.

This seems to be less than ideal, and while I could see lowering gemstone find rates to slightly compensate, I think overall there should be a greater difference between the different cuts in terms of the other bonuses and Affluence should be higher or at least should ramp up faster with carats rather than the current .1 for 1 addition Affluence.

[Taipion]

Yea, I see the problem at hand here, the higher cuts have only minimal value.
215 MnM and 167 LnL is no issue though, especially as you do not need to have that yourself, you can buy all the cuts in stalls or ask in trade chat, people tend to have ...a lot of them, that's why they are so cheap.
([edit:] Actually, there are some occasions where you need all 4 different cuts to make a "perfectly slotted" item, and "just" using 4 gems is a pretty cheap alternative also.)

I agree there should be more depth to that, but then again that's not terribly high on the importance list compared to other things, and then again we'd need JC back first to start with...^^