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

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TSM API Key
Found at www.tradeskillmaster.com/user
Update data
2
RegionEUUS or EU
3
Servertwilights-hammerNo 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
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.
8
The newest version of the spreadsheet can always be found at www.thelazygoldmaker.com/spreadsheet
9
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.
10
The prospecting rates are shown in the prospecting rates and values sheet.
11
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.
12
For calculating the value of the uncommon gem shuffle it is assumed that you have all rank 3 uncommong gem ring recipes.
13
14
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.
15
16
17
18
19
20
21
22
23
24
25
Version History
26
0.9.2Added Tailoring
27
28
0.9.3Added Alchemy
29
Added Shuffle pricing for Leylight and Arkhana
30
0.9.4Added Blacksmithing3/5/2017
31
32
0.9.5Fixed ancient potion crafting costs
33
Revamped Jewelcrafting sheet
34
Set the recipe rows in the enchanting sheet to hidden
35
0.9.6Fixed Imbued silkweave recipe crafting cost
36
Added Inscription
37
0.9.6.1ADded Milling profit in percent
38
Fixed obliterum profits in the enchanting sheet
39
1Added Engineering
40
Added all Patch 7.3 Recipes
41
Added Solaris's Script for grabbing prices
42
1.0.1
Fixed mistake in Tailoring Other Crafts crafting cost
43
1.0.2Added Primal Sargerite Valuation
44
Added Obliterum profit for epic gems
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
Alchemy Recipes
Alchemy Prices
Blacksmithing
Blacksmithing recipes
Cooking
Enchanting
Jewelcrafting
Cooking recipes
Inscription
Inscription-recipes
Leatherworking
Engineering Recipes
Engineering
LW-Prices
Tailoring Price
Tailoring-Recipes
Tailoring
LW-Materials
Background stuff
Prospecting rates and values
Sheet1
Crafting comparisons
BoS and Primal Sarg
Data