ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TSM API Key
kov_pMoGNB2_GdXdS1uf6PQvgyDQwswY
Found at www.tradeskillmaster.com/userRefresh by pushing the Update button to the right2
2
RegionEUUS or EU
3
ServersylvanasNo special characters e.g. Vek'Nilash = veknilash
Spaces should be replaced with dashes
e.g.: Shattered Hand = shattered-hand
4
Set Blood of Sargeras to trader value?Yes
5
Manual blood value (If above is set to "no")150
6
Explanation
7
IMPORTANT NOTE: the IMPORTDATA() function used to download pricing data will update automatically in the background. I strongly suggest deleting your TSM key when you are finished with the spreadsheet and re-entering it the next time you open it
8
To download Pricing Data input your TSM API key, region and realm name above. After inputing the values you can force a data update by changing the value in the red cell above.
9
The newest version of the spreadsheet can always be found at www.thelazygoldmaker.com/spreadsheet
10
The spreadsheet currently contains Jewelcrafting, enchanting and Leatherworking recipes. It is meant as a help to make better decisions about what to craft by giving easy side by side comparisons of all relevant recipes.
11
The prospecting rates are shown in the prospecting rates and values sheet.
12
You can choose whether you want to use the value of Blood of Sargeras from the trader or if you want to set a manual value by setting B4 to either Yes or No. If it is set to yes the value of one blood is set to the maximum value at the trader. See the Blood of Sargeras Sheet to see what the best exchange for your blood is.
13
For calculating the value of the uncommon gem shuffle it is assumed that you have all rank 3 uncommong gem ring recipes.
14
15
16
17
18
19
At the bottom of the input sheet there are three variables that you can set to yes or no depending on if you have access to them. Obliterum forge, disenchanting and Saber's eye. Obviously having access to all of them makes the shuffle more profitable.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
Version History
35
0.9.2Added Tailoring
36
37
0.9.3Added Alchemy
38
Added Shuffle pricing for Leylight and Arkhana
39
0.9.4Added Blacksmithing3/5/2017
40
41
0.9.5Fixed ancient potion crafting costs
42
Revamped Jewelcrafting sheet
43
Set the recipe rows in the enchanting sheet to hidden
44
0.9.6Fixed Imbued silkweave recipe crafting cost
45
Added Inscription
46
0.9.6.1ADded Milling profit in percent
47
Fixed obliterum profits in the enchanting sheet
48
49
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