The Lazy Goldmakers Legion Spreadsheet v0.9.3
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TSM API Key
Found at www.tradeskillmaster.com/user
Refresh by changing the
RED cell to the right:
2
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.2
Added Tailoring
36
37
0.9.3
Added Alchemy
38
Added Shuffle pricing for Leylight and Arkhana
39
40
41
42
43
44
45
46
47
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
Loading...
 
 
 
Inputs
Alchemy
Cooking
Enchanting
Jewelcrafting
Leatherworking
Tailoring
Blood Of Sargeras
LW-Prices
LW-Materials
Background stuff
Prospecting rates and values
Crafting comparisons
Data
Tailoring Price
Tailoring-Recipes
Alchemy Prices
Alchemy Recipes
Cooking Recipes