ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
3
How to use this spreadsheet:
4
5
Make a copy: Archive/Copy
6
7
The amount of pigments in based on what we received, milling 1000 herbs of each except for Anchor Weed (200 of those).
8
Everytime you mill herbs, you can change the amount of pigments received for that specific herb.
9
10
The amount of pigments needed to craft the Vessels (Inscription Off-Hand) is changed according the Pigments on the top.
11
12
All you need the do is change the Price/Herb in the bottem part of the Calculations according to your DBMarket, dbminbuyout or your Avgbuy price.
13
And change the price of the Veiled Crystal according to the DBMarket, dbminbuyout or what you want it to cost manually.
14
The spreadsheet will then calculate what will be profitable or not.
15
These value's are placed within light yellow fields in the spreadsheet.
16
17
You can also change the % rate of disenchanting by adding up the amount of epic items disenchanted with Tools of the Trade and the number of Veiled Crystals received.
18
19
Check out the video about this spreadsheet:
https://www.youtube.com/watch?v=ftGsUBHkZ70
https://youtu.be/DZsqZWtRlNk
20
Feel free to join us on Discord:
https://discord.gg/3Qz2b4b
21
22
23
Latest data used to define Pigment from Milling rate:
24
https://www.reddit.com/r/woweconomy/comments/98oyfb/bfa_milling_data_30k_anchor_weed_600k_common_herbs/
25
26
27
To change the LOCALE in the settings when you use '.' as a decimal delimiter, in order to use the spreadsheet correct:
28
29
30
31
32
33
34
35
36
37
38
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