ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
This ain't Kalimdor (woo),
3
Ain't no hold 'em (hey)
4
5
6
7
Looking to optimize your goblin time and profits in The War Within?
8
Asking"What should I make?"
9
"Where should I spend my skill points?"
10
11
You've come to the right place!
12
13
There are a few easy steps to start using this spreadsheet:
14
1.Fill in your Blizzard API credentials. (See below on how to get these.)
15
2.Fill in your TSM API credentials (this step is optional.)
16
3.Import your character's profession info using the Import Profession tab and the QueenBaeX addon from Curseforge:
17
https://www.curseforge.com/wow/addons/queenbaex
18
4.Update Blizzard (and Update TSM if you are using it) data.
19
5.See which crafts are profitable and the cheapest way to make them.
20
6.…
21
7.Profit!
22
23
For more detailed instructions, see below. You can also check out the Advanced Goblineering tab to take your goldmaking to the next level!
24
25
Discord server for questions, et al:
26
https://discord.gg/VbmHmNWmtG
27
28
This spreadsheet is built for Excel in Office 365. Earlier versions may have compatability issues.
29
30
31
Credit where credit is due
32
This spreadsheet is a consolidation of several people's work:
33
1.The Blizzard API capability was originally developed by reddit user /u/jmpcallpop. It is a beautiful thing.
34
2.The TSM API is provided by the TSM team.
35
3.Thanks to mech on Discord for help understanding some of the crafting behaviour.
36
4.Huge thanks to coco on Discord for working through the optimization algorithms with me during DF.
37
5.If there are mistakes in here that cause you to lose untold amounts of gold…uhm, make sure you double check your work before acting on what the spreadsheet tells you. Use this spreadsheet at your own risk.
38
39
To get started with the spreadsheet:
40
You need to choose your server information
41
1.Go to the "Start Here" tab
42
2.Choose your Region, then your Locale
43
3.Choose your Realm
44
45
To get your Blizzard credentials
46
To use the Blizzard API, you need some information from Blizzard (it only takes a few moments):
47
1.Go to: https://develop.battle.net/access/
48
2.Login and you will be taken to a "Manage Your Clients" page
49
3.Click on the "+ Create Client" button on the right-hand side of the page
50
4.Enter a "Client Name" (this can be anything), check the "I do not have a service URL for this client" box, and enter something in the "Intended Use" box (again, this can be anything)
51
5.Once your client is created, you will be taken to a page that has your Client ID and Client Secret (you must click SHOW SECRET)
52
6.Copy and paste your Client ID into the "Client ID" cell and your Client Secret into the "Client Secret" cell in the "Start Here" tab of this spreadsheet
53
54
To get your TSM credentials
55
To use the TSM API, you need some information from Tradeskillmaster.com:
56
1.Go to: https://tradeskillmaster.com/user
57
2.Login and you will be taken to your "My Account" page
58
3.Copy and paste the API Key near the bottom of the page into the "Client Secret" cell under TSMValues in the "Start Here" tab of this spreadsheet
59
4.Do not change the Client ID (the grey cell.)
60
Note to user: if you have not received a TSM API code prior to this they may no longer be providing them. It's okay, this spreadsheet works without TSM.
61
62
Get Auction House Data for your Realm and Region:
63
Click on the "Update Blizzard" button to load prices for your selected region and realm (AH data updated roughly once per hour by Blizzard - you can see when they last updated their data on this page)
64
If you are using the TSM API, also click on the "Update TSM" button to load prices from TSM
65
66
The spreadsheet uses connections, queries and custom functions so you will need to accept this in the security prompts. You can view the functions (Alt+F11) or the queries (Data menu, Queries & Connections) before doing this to assure yourself that they will not do anything on your computer that you don't want them to do
67
68
The access mode for both the Blizzard and TSM APIs should be "Anonymous" and "Privacy Level: None"
69
70
Because this spreadsheet uses complex custom functions, Excel does not always know how much to recalculate when you change values. It is recommended you regularly do a full spreadsheet recalculation with:
71
<ctrl+alt+F9 >
72
OR by clicking on one of the Recalc buttons on some pages
73
74
If you see "None" in a pricing column it is because that item was not seen on the AH in the most recent scan.
75
76
How to Read the Profession sheets:
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
Known Issues
95
1. Multicraft provides from 1% to 250% of the normal yield when it procs. However, it is not a linear distribution so this does not work out to the 1.255 average you might expect. Instead, we use an average based on testing of the different yields. YMMV.
96
97
2. Several Finishing Reagents (Frameworks, Mirror Powder, Preserving Embroidery Thread) are recursive - they use mats that themselves can be made using the same reagent - and this means they cannot be properly calculated by Excel. For these Finishing Reagents we always use the AH price and not the make-it-yourself price.
98
99
Discord server for questions, et al:
100
https://discord.gg/VbmHmNWmtG