Register
  • Guide: Pliaksi's Goblin Crafter Spreadsheet



    *The development thread can be found here, and you may contact Pliaksi directly by PM as well. If you appreciate Pliaksi's work, click anywhere on this sentence to leave him rep!

    >> Consortium Hosted Download Link <<

    Our very own Wind Trader, Pliaksi, has been hard at work behind the scenes developing one of the most powerful goblin spreadsheets I have ever seen. The word “Spreadsheet” does the tool little justice, seeing that it’s backed by so much coding and programming (yes, you can do this in excel). In a nutshell, the tool helps you maximize profits from professions. Pliaksi’s Goblin Crafting Spreadsheet has helped me find profitable crafts that I wasn’t even aware of. If you’re the type to frequent the Consortium, the spreadsheet can probably help you too! How does one operate this intricate machine? Read on.



    In terms of features, the spreadsheet does not disappoint. Unlike most excel spreadsheets, this one pulls item pricing data from auctioneer’s scan database. It then spits out a list of crafts ranked from most profitable to least profitable. This list is fully customizable, and can be sorted by several powerful and flexible filters. Accompanying the crafting list is also a disenchanting, milling, prospecting and cooldowns tab, which indicates the profits in all transmutes, Fire Prism, Dreamcloths, Prospecting, Milling and Darkmoon deck assemblies. Of course, the latter list is also customizable using the aforementioned filters.

    Ever bust a vein trying to figure out whether to purchase Hardened Elementium directly from the AH, or to buy the components and smelt it yourself? The spreadsheet includes a chart that calculates the most profitable path to create any given item. This process even includes conversions such as Savage Leather Scraps -> Savage Leather -> Heavy Savage Leather -> Pristine Hide. No more busted veins.



    Let’s walk through the whole process and get a good feel for the sheet’s mechanics. At a later stage, you should really consider checking the Detailed tips box at least once, and then examine all sheets with the tips turned on, in order to understand all that is going on. First, click on Import File and find your Auc-ScanData.lua file. It should be located within World of Warcraft -> WTF -> SavedVariables. The item price data is then loaded into the spreadsheet:





    Under Masteries check the boxes appropriate to you. I checked transmute master. Next, we tell the spreadsheet which recipes we can make. Click the Crafting Recipes tab.



    The spreadsheet first assumes that you can craft every item available (after all, most goblins have all professions maxed). If this is not the case, you need to flag items that you cannot craft as “false” under Can Craft. The easiest way to do this is to mark the entire Can Craft column as false, then uncheck professions you wish to ignore under Profession. Then, re-check all items under Can Craft as “true”.

    I’m in the mood for some Blacksmithing, Engineering and Leatherworking, so I check those professions (also keep Trade checked). You will notice that there are two additional filters, namely [i]Bulk craft[i] and Watch list. Unlike Can craft (which is used to determine routing (we get to this later), they are “pure” filters. You can use them to define the scope you wish to examine throughout the entire spreadsheet. What’s more, you can specify different values (other than TRUE/FALSE) to those two filters, potentially providing you with unlimited number of pre-defined lists for easy navigation.

    Next, we examine the most profitable crafts available. Click on the Crafting tab. Expand the filters list by clicking the “+” button at the top left corner. I’m going to use 3 filters:
    • Able to craft the item: this removes items that I cannot yet craft.
    • Available mats for at least one: this removes items that cannot be made from AH materials.
    • Suitable for bulk craft: this removes items that are mass-manufactured like flasks, potions, gems, etc(as already mentioned, you can define those yourself in the Crafting Recipes tab).

    Keep in mind, you must hit the Refresh button on the Controls tab to put filters in effect. The spreadsheet now returns several results for profitable crafts. For me, Dragonkiller Tunic is the most profitable craft available given the data I have fed the spreadsheet so far.





    Switch back to the Controls tab. Under Routing, you may type in up to 4 items to craft, or use pre-defined item sets. Pick whichever options is most attractive. If you’re wondering, Routed takes into consideration all paths to craft an item, such as trading up from Heavy Savage Leather to Pristine Hide.



    Once you’re happy with the list of items, hit Generate routing data. The spreadsheet then determines the most profitable path to create all items, and outputs a graphical representation of this under the Chart Sheet tab;



    Take a look at the above route for . On the left, we have the route produced when mining (smelting) is not available. Had I checked mining (and subsequently, Obsidium Bar) under the Crafting Recipes tab, the route generated would include the more profitable Ore -> Bar conversion. Nifty, isn’t it!

    Finally, we have the DE|Mill|Prospect|CD tab. Again, it can be filtered just like the Crafting tab. This tab gives a quick glance of profits that can be made from prospecting, milling, disenchanting, transmuting, and using cooldowns. I find it very handy for determining which transmute cooldown to use.
    Also keep in mind, that all sheets are initially in compact form, giving you only the most immediate data. Should you ever consider, you want to dig in details, click the expand [+] buttons on top of each sheet. You will find plenty of additional data there, such as profit calculations under different conditions, trends and much, much more.

    As you can tell, this tool can prove to be invaluable for any goblin. I've only really scratched the surface here, given that the spreadsheet is driven by some serious coding that you don't get to see (actually, if you'd like to toy with the code you can ask Pliaksi himself).

    Really looking forward to others trying this out. If you find success in the use of this spreadsheet, remember to +rep Pliaksi and report your triumphs here!
    This article was originally published in forum thread: Guide: Pliaksi's Goblin Crafter Spreadsheet started by Sterling View original post
    Comments 17 Comments
    1. Unregistered's Avatar
      Unregistered -
      Apologies for such a basic question .

      I've downloaded the zip file and unzipped it.I've now got alot of files and folders, but cant actually see which one I need to open in excel.

      Told you, basic question, sorry
    1. Sterling's Avatar
      Sterling -
      The download link points to an xlsx file, not sure why you're getting a zipped file (for the Consortium link anyway).

      http://www.stormspire.net/Crafting Helper v 1.02.xlsm
    1. Zoxy's Avatar
      Zoxy -
      Oh looks good will give it a go later on
    1. Unregistered's Avatar
      Unregistered -
      I'm using the link at the begining of the post, still getting a zip file, which when unzipped contains lots and lots of XML files and some BIN files but no xlxs file
    1. Sterling's Avatar
      Sterling -
      Quote Originally Posted by Unregistered View Post
      I'm using the link at the begining of the post, still getting a zip file, which when unzipped contains lots and lots of XML files and some BIN files but no xlxs file
      Anyone else? I'm clicking it from 2-3 different computers and it's downloading an excel file.
    1. Pliaksi's Avatar
      Pliaksi -
      "The mistake is correct" is the best sutable explanation here . Excel 2007+ files are essentially zipped bulk of XML files. In short... if you do not have Excel 2007+ or some of your file associations are broken, your computer will count it as a package file. One solution is to download it as a zip and change the extension to xlsm.
    1. lokeal's Avatar
      lokeal -
      anybody having luck with open office? it tries to open gets to about 90% then hangs

      update: it opens but i lose the macro buttons, i'll try with regular office
    1. Sterling's Avatar
      Sterling -
      Quote Originally Posted by lokeal View Post
      anybody having luck with open office? it tries to open gets to about 90% then hangs

      update: it opens but i lose the macro buttons, i'll try with regular office
      I'd be very surprised if openoffice worked.
    1. Azz's Avatar
      Azz -
      I am having the same problem as "unregistered" above even though I am running Excel 2007. I went to the Development Thread linked at the beginning of the post and was able to download v 1.02, hopefully that is the current version. I will try and test it later.

      One question though, would it work if I copied the lua file to another computer (that doesn't run wow) and import? While I play the AH, I run WOW on one machine and spreadsheets/research on another right next to it.

      Thanks, and I look forward to trying it out later.
    1. calianna's Avatar
      calianna -
      I think it should work if you move the correct lua files. I was thinking of doing the same myself.
    1. Sterling's Avatar
      Sterling -
      Quote Originally Posted by Azz View Post
      I am having the same problem as "unregistered" above even though I am running Excel 2007. I went to the Development Thread linked at the beginning of the post and was able to download v 1.02, hopefully that is the current version. I will try and test it later.

      One question though, would it work if I copied the lua file to another computer (that doesn't run wow) and import? While I play the AH, I run WOW on one machine and spreadsheets/research on another right next to it.

      Thanks, and I look forward to trying it out later.
      Yes, you can use the LUA file on another computer. I do so myself. Just remember to bring fresh LUA files and keep updating the data you feed to the spreadsheet.
    1. Kammler's Avatar
      Kammler -
      This is very impressive. It could prove to be a huge time savings for me and help to target specific gold making opportunities. Given that time saved is gold earned, this could yield a significant gold increase just in time savings alone.

      I have installed the file and imported my .lua file. I have used the data to run the report the first time. Following your instructions above, I have the following questions.

      * Is there an easier way to program the known recipes? I do not dual box and do not have a PC w/ Excel 2007 available while I play. Thus I have to make a list in game, exit and the update the known list.

      * I don't understand the comments on "bulk craft" and "watch list". Could you give more instruction on how to use those?

      * I can't figure out how to make the spreadsheet show crafting results for only one profession. I eliminated all professions other than Enchanting, and marked the "produced can craft" column as all true. I then clicked on the "controls" tab and selected "refresh". But under the "crafting" tab I have plate, cloth, etc. No enchanting items show up at all.

      * Please confirm the process for de-selecting the recipe that is not known. Clicking the cell doesn't do it--so I had to select the cell and the hit "delete" key to blank it out.

      * Is there a way to have the program pull from inventory and/or bank (or even guild bank) so show what is craftable based on more than what can be purchased from the AH? It would be great to show what items I could craft based on mats already in my possession--and then generate a "buy list" or "needed list" to show what I should be shopping for.

      * Can you explain more about the routing data? Why only 4 items in that list? If I have 24 items I want to queue up do I have to copy/paste the cell from the "crafting recipes" tab (to ensure exact spelling, spaces, etc.) and then run this 8 times? Print the routing page?

      * Probably the biggest question: do you have plans to create an in-game version of this as an addon? Having this utility available as I stand at my mailbox or in front of the AH would be incredible.

      Again, I love the tool and think this could be a great resource. I just need to get a bit more info on how to use it. Maybe an instruction video would help, or a more detailed guide?

      Your answers are greatly appreciated.
    1. Sterling's Avatar
      Sterling -
      Pliaksi can probably answer your questions better but I'll do what I can for now.

      Quote Originally Posted by Kammler View Post
      * Is there an easier way to program the known recipes? I do not dual box and do not have a PC w/ Excel 2007 available while I play. Thus I have to make a list in game, exit and the update the known list.
      As per the development thread Pliaksi is working on a way to import crafting lists from other addons, possibly gnomeworks (I think).

      Quote Originally Posted by Kammler View Post
      * I don't understand the comments on "bulk craft" and "watch list". Could you give more instruction on how to use those?
      Bulk craft flags items that can be mass-produced. Flasks, potions, gems, etc. Pliaksi can probably answer the watch list question, as I'm not 100% sure about it myself.

      Quote Originally Posted by Kammler View Post
      * I can't figure out how to make the spreadsheet show crafting results for only one profession. I eliminated all professions other than Enchanting, and marked the "produced can craft" column as all true. I then clicked on the "controls" tab and selected "refresh". But under the "crafting" tab I have plate, cloth, etc. No enchanting items show up at all.
      Did you flag all other crafts as false? Even if they're hidden, other crafts will still show unless you label them as false.

      Quote Originally Posted by Kammler View Post
      * Please confirm the process for de-selecting the recipe that is not known. Clicking the cell doesn't do it--so I had to select the cell and the hit "delete" key to blank it out.
      I'm not sure what you mean. To flag a recipe as not known, type FALSE in the "can craft" column.

      Quote Originally Posted by Kammler View Post
      * Is there a way to have the program pull from inventory and/or bank (or even guild bank) so show what is craftable based on more than what can be purchased from the AH? It would be great to show what items I could craft based on mats already in my possession--and then generate a "buy list" or "needed list" to show what I should be shopping for.
      This would be pretty awesome.
    1. Pliaksi's Avatar
      Pliaksi -
      While Sterling is on spot for most things, I thought you might want to hear form me as well.

      Quote Originally Posted by Kammler View Post
      * Is there an easier way to program the known recipes? I do not dual box and do not have a PC w/ Excel 2007 available while I play. Thus I have to make a list in game, exit and the update the known list.
      Currently not, but It is on my "todo" list. I am feeling a bit uncomfortable with asking users for imput from several different addons, thus currently I am exporing different options such as sites or using a single addon (will be looking if TSM has all the needed data).

      Quote Originally Posted by Kammler View Post
      * I don't understand the comments on "bulk craft" and "watch list". Could you give more instruction on how to use those?
      Essentially you can view those as filters. After you set values to them and refresh form the options menu you can then filter most of the output tables by those values. Lets give an example : You want to show only crafted companion pets, so you find them in the recipies sheet, mark them in the "watch list" column (as TRUE and everything else as FALSE, or maybe you mark them as COMPANION or whatever), then you hit the "Refresh" button in the controls list. After that when you go to the crafting sheet, you will find that each of the tables under the filter "Item exists in the watch list" has your value and you can filter the list by it. The idea of "bulk craft" is what Sterling said - a filter that marks items that you can mass produce, so you can filter by them, in practice however you can assign whatever values to that filter and use it like the previous one - it's your call.

      Quote Originally Posted by Kammler View Post
      * I can't figure out how to make the spreadsheet show crafting results for only one profession. I eliminated all professions other than Enchanting, and marked the "produced can craft" column as all true. I then clicked on the "controls" tab and selected "refresh". But under the "crafting" tab I have plate, cloth, etc. No enchanting items show up at all.
      My suggestion here is related to the previous asnwer.
      If you want to just limit the display of other professions ,follow thease steps:
      1. Go to the recipies sheet and filter it by "Enchanting".
      2. In the watch list column, change the value to "Ench" or something like that.
      3. Refresh from the controls sheet.
      4. Go to the crafting sheet and unhide the filters (form the first [+] in top to the right).
      5. Change the value of the "Item exists in the watch list" filter from "All" to "Ench".

      If you want to limit all the calculations in the spreadsheet to just the Enchanting recipes, follow the aforementioned steps, with these differences.
      2. Change the values in the "Can craft" column to TRUE, and for all other professions to FALSE.
      5. Change the value of the "Able to craft the item" filter from "All" to "TRUE".

      Quote Originally Posted by Kammler View Post
      * Please confirm the process for de-selecting the recipe that is not known. Clicking the cell doesn't do it--so I had to select the cell and the hit "delete" key to blank it out.
      I am not 100% sure what you mean here. If you are asking how to mark a recipe as "not known", then go to the recipes sheet and under the "Can craft" column, mark it as FALSE. Important : the only thing performed by this action is that you tell the spreadsheet not to "route" through this recipe (which can be further overridden by the "route only known" option in the controls sheet) ! It does not automatically exclude it form the lists, if you want to do that, just mark the "Able to craft the item" filter, in the respective table, from "All" to "TRUE".

      Quote Originally Posted by Kammler View Post
      * Is there a way to have the program pull from inventory and/or bank (or even guild bank) so show what is craftable based on more than what can be purchased from the AH? It would be great to show what items I could craft based on mats already in my possession--and then generate a "buy list" or "needed list" to show what I should be shopping for.
      A few very interesting questions here, will try to address all of them from all sides:
      1. If an addon collects that data - then yes it can be done, however as I already mentioned I'd really like to avoid requiring data from too many addons.
      2. A workaround to this, could potentially be, displaying crafting data for all items which, regardless if materials are available on the AH, based on historical material data. While this is a completely viable option it starts to contradict with the purpose of the spreadsheet which is mentioned in the development thread, and that is "to be fast, understandable and easy-to use", as I feel I am already lacking on the easy-to-use part.
      3. The shopping list is a great idea, if I can solve the previous two points in an acceptable manner. To take this one step further, if I am generating a shopping list, I'd likely generate is as ready-to-use by some in-game addon.

      Quote Originally Posted by Kammler View Post
      * Can you explain more about the routing data? Why only 4 items in that list? If I have 24 items I want to queue up do I have to copy/paste the cell from the "crafting recipes" tab (to ensure exact spelling, spaces, etc.) and then run this 8 times? Print the routing page?
      I am not sure if you are asking me to explain what routing is in general, but since I am under the impression that you understand how it works, I will answer to the other question.
      Essentially routing is more of a "fun" utility than a practical one. In practice you should always consider your profit based off the AH price of the immediate materials and you are always better off buying all your materials form the AH (thus rising their price), then crafting both the produced item and the said materials and listing all of them on the AH. There are very few exceptions to this rule, and that is either when there is a material listed at way over it's natural market value or when there is a missing material. And, I will be pretty honest here, I was way too happy with how the crafting trees were generated and how it looked, in order not to include it at all.

      Quote Originally Posted by Kammler View Post
      * Probably the biggest question: do you have plans to create an in-game version of this as an addon? Having this utility available as I stand at my mailbox or in front of the AH would be incredible.
      I would absolutely love to do that. There are two restrictions to that, and one of them being a major one:
      1. I don't know LUA - it would naturally take some time to learn it, but it should be not that big of an issue, as I have good understanding of object oriented languages and XML.
      2. My spare time for development is at work, and I can't get WoW installed here in order to test the code - as you can imagine this would be a major setback.

      Quote Originally Posted by Kammler View Post
      Again, I love the tool and think this could be a great resource. I just need to get a bit more info on how to use it. Maybe an instruction video would help, or a more detailed guide?
      Have you tried enabling the detailed tips and reading through all of them? I am aware that this is not as comprehensive as a guide, but I am hoping that they should explain most of the functionalities. About the video guide - I don't want to get mocked all over the internet for my accent . When I get some more spare time at my hands, however, I will do an "advanced" guide on how to add your own recipes (pre Cata ones) to the sheet.

      Pease, if you have any additional questions, don't hesitate to ask. This gives me a very good idea on what is potentially needed for implementation or what functionality is not easy to use.
    1. vdh's Avatar
      vdh -
      I'm using excel 2011 on mac, when I'm clicking on import data it opens a debugging mode and I can't import the auctioneer data file.
      its says compile error, user-type not defined. Someone has a clue about the problem?
    1. MrBlah's Avatar
      MrBlah -
      pretty sure it's windows office only, mac's not supported, microsoft does not offer the same scripting between the two versions, gg microsoft
    1. lessgravity's Avatar
      lessgravity -
      I think this is an awesome spreadsheet, hats of to you for doing something like this on excel

      that said, i seem to have some problem, it does not show me the prices for crafts
      Ive enabled BS and LW and set all values of items to TRUE. imported the auc file as said, but no price update.

      Also clicking on the generate route options gives some VB error