Similar to the Crafter's Mark of the Chained Isle, the Crafter's Mark of the First Ones creates an item that is Unique-Equipped, so only one piece with this Optional Reagent may be worn at any one time.
#SHADOWLANDS ALCHEMY PATCH#
I suggest joining me on discord where I can answer your questions and talk to you in a more informal and live manner.Upcoming Changes to Alchemy in Shadowlands Patch 9.2Īlchemy in Shadowlands 9.2 will see the following changes. It cannot currently find the different values of the different levels, as I can’t look at the output from the TSM API to tell how I would split them.Ĭontact me if you have any questions or need help. The sheet contains all the recipe ranks for Shadowlands base legendary items. They are located in the same space to the right of your API key.
#SHADOWLANDS ALCHEMY UPDATE#
Then you click the Get Pricing Data button or the UPDATE button.
For most of you it will be easiest to just use the default price. Examples:Īfter filling in the realm data and the API key you can choose your faction and set the price. spaces should be replaced by dashes (-) and special characters should be ignored. The realm name should be written in all lower caps. The region should be the two-letter abbreviation for your region, US or EU. If you do not have a TSM user you will have to register one to utilize the spreadsheet. The API key is found on your tradeskillmaster account page at /user. You need to add your API key to the white box. When you open it you should go to the Input worksheet. Any edit access requests will be ignored. You do so by clicking file and make a copy. To get your own you need to make a copy to your google drive. The link to the google sheets is view only as it needs to remain a master version that only I can edit. Let me know if you see any errors or I’ve missed any recipes! Getting the Google Sheet Without live data I can’t confirm that everything works, I’ll be updating it to make sure it works as soon as SL is live and we get live data from the TSM API. The spreadsheet is currently in beta for Shadowlands.
#SHADOWLANDS ALCHEMY CODE#
You can find the source code for the VBA macro here. The google sheets version relies on a script that downloads the pricing data. The Excel version uses a simple VBA macro to call the TSM API.
The API call is managed a bit different in the two versions. In the google sheets version you can currently only choose the weighting between dbmarket and minbuyout. You can combine two of them to make your own weighted price. The Excel version supports 4 different price sources (Dbmarket, minbuyout, dbhistorical and dbregionmarket). You can alter the price source in my spreadsheet. This gives us a weighted average of the market value and the current minimum price that weighs the current price higher than DBmarket does. The default price used in the calculations is 66%dbmarket+34%dbminbuyout. This gives us access to several TSM based price sources. The pricing data is downloaded from the Tradeskillmaster API. The main feature is automated calculation of crafting profits. The downloadable excel file has some additional features, but it does not work if you are not using Microsoft Office or if you are not on a Windows-based computer. There are two versions of my spreadsheet available depending on your preferences. The Spreadsheet contains all the crafting professions and their recipes. I have created a Spreadsheet that automatically calculates profits for the major crafts available in Shadowlands professions.
0 kommentar(er)
