ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Material Costs and ValuesEstimated Costs/Ichor Value
Copy Spreadsheet and edit to try your own values
3
Sierra Powder200Straight Extraction124,322,473
Input a silver value of 0 for things you think are basically free
4
Silver Ichor Kit2,000,000Straight Extraction w/ Silver Kits151,817,027
5
Golden Ichor Kit5,000,000100% Transmutation153,208,600
6
Golden Ichor Kit Extraction126,443,400
7
Extraction Kit100,000Extraction into Transmutation159,697,178
8
Transmutation Kit3,000,000Extraction into Transmutation w/ Silver Kits189,494,484
9
10
Equip Cost75,000,000
11
Item Potential8
12
Fodder Potential8
13
Fodder Cost500,000
14
15
Sierra Count - Extraction143
16
Sierra Count - Transmutation1043
17
18
Straight Extraction CalculationsSilver Extraction Kit Alternative
19
1-Item Success Rate61.26%1-Item Success Rate61.26%
20
Average Attempt Count1.63Average Attempt Count1.63
21
Cost per Extraction128,600Cost per Extraction2,000,000
22
Total Extraction Cost per Item1,157,400Total Extraction Cost per Item18000000
23
Total Cost of Attempting an Item76,157,400Total Cost of Attempting an Item93,000,000
24
Estimated Ichor Value124,322,473Estimated Ichor Value151,817,027
25
26
100% Transmutation Calculations
27
Total Cost of Equips150,000,000
28
Transmutation Cost3,208,600
29
Estimated Ichor Value153,208,600
30
31
Golden Ichor Kit Calculation
32
Total Cost of Equip75,000,000
33
Cost of Failing Through All Potential1,157,400
34
Sierra Powder Cost per Attempt28,600
35
Total Cost per Attempt5,028,600
36
Cost of 20 Attempts50,286,000
37
Estimated Ichor Value126,443,400
38
39
Extraction into Transmutation CalculationsSilver Extraction Kit Alternative
40
Extraction Success Rate33.66%Extraction Success Rate33.66%
41
Transmutation Success Rate50.00%Transmutation Success Rate50.00%
42
Correct Ichor Chances50.00%Correct Ichor Chances50.00%
43
Overall 1-Item Success Rate50.24%Overall 1-Item Success Rate50.24%
44
Average Attempt Count1.99Average Attempt Count1.99
45
Cost per Extraction128,600Cost per Extraction2,000,000
46
Total Extraction Cost per Item1,028,800Total Extraction Cost per Item16,000,000
47
Transmutation Cost4,208,600Transmutation Cost4,208,600
48
Total Cost of Attempting an Item80,237,400Total Cost of Attempting an Item95,208,600
49
Estimated Ichor Value159,697,178Estimated Ichor Value189,494,484
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100