![]() ![]() Go into your Data menu -> Get Data -> Query Options -> Current Workbook | Privacy and set it to "Ignore the Privacy Levels." If you get errors related to refreshing the "Query - Auction House Data" it is probably an issue with privacy levels.It works best with Office 365 although I've had some reported success with Excel 2016 It requires Excel, there is no Google spreadsheet version. ![]() I've taken his base and added onto it a fairly complete set of crafting calculations, comparing the AH pricing with the crafting cost for each recipe by ilvl where applicable. I can't fix the TSM API for you but reddit user /u/jmpcallpop created a spreadsheet and related queries that will download data directly from the Blizzard API and provides that context for the ilvl of items listed. The loss of the TSM web api only compounds this issue. Most of our current data sources do not distinguish between ilvls from the same base crafted gear (whether this is due to Crafter's Marks or Leggo ranks.) This creates problems knowing what to craft and how profitable it will be. One of the biggest problems that Shadowlands introduced for goblins is the way ilvl of leggos and Crafter's Marks are implemented.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |