Register
Page 1 of 2 12 Last
Results 1 to 10 of 18
  1. #1
    Sterling's Avatar
    Posts
    3,856
    Reputation
    379
    Blog Entries
    1
    Tagged in
    2134 Posts
    Add to this user's reputation

    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!
    Last edited by Sterling; February 3rd, 2011 at 08:18 AM.
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Legion Mastery Series: Sniper | Cross-Faction Trading | Cooking | Blacksmithing, Leatherworking, Tailoring Master
    Old World: Smelting | Garrisons Part 1 - Buildings | Garrisons Part 2 - Followers | Profitable Alchemy Crafts
    Archived: Enchanting | Jewelcrafting | Toy Box Guide | Blacksmithing Transmog Guide
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  2. #2
    Unregistered
    Unregistered's Avatar
    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

  3. #3
    Sterling's Avatar
    Posts
    3,856
    Reputation
    379
    Blog Entries
    1
    Tagged in
    2134 Posts
    Add to this user's reputation
    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
    Last edited by Sterling; February 3rd, 2011 at 08:16 AM.

  4. #4
    Zoxy's Avatar
    Posts
    210
    Reputation
    26
    Tagged in
    6 Posts
    Add to this user's reputation
    Oh looks good will give it a go later on
    http://tradingwithzoxy.com/ Offering the Latest Gold making Tips and Addon Guides

    Check out My Addon Guides - Trade Skill Master Complete Guide - MySales

  5. #5
    Unregistered
    Unregistered's Avatar
    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

  6. #6
    Sterling's Avatar
    Posts
    3,856
    Reputation
    379
    Blog Entries
    1
    Tagged in
    2134 Posts
    Add to this user's reputation
    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.
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Legion Mastery Series: Sniper | Cross-Faction Trading | Cooking | Blacksmithing, Leatherworking, Tailoring Master
    Old World: Smelting | Garrisons Part 1 - Buildings | Garrisons Part 2 - Followers | Profitable Alchemy Crafts
    Archived: Enchanting | Jewelcrafting | Toy Box Guide | Blacksmithing Transmog Guide
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  7. #7
    Pliaksi's Avatar
    Posts
    173
    Reputation
    64
    Tagged in
    86 Posts
    Add to this user's reputation
    "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.

  8. #8
    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
    Last edited by lokeal; February 3rd, 2011 at 01:43 PM.

  9. #9
    Sterling's Avatar
    Posts
    3,856
    Reputation
    379
    Blog Entries
    1
    Tagged in
    2134 Posts
    Add to this user's reputation
    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.
    Must-See: Stormspire.net Survival Guide | How-to: Tooltips in your posts | Consortium Key Sender (CKS) | Phat Lewts' Learn TSM Series
    Legion Mastery Series: Sniper | Cross-Faction Trading | Cooking | Blacksmithing, Leatherworking, Tailoring Master
    Old World: Smelting | Garrisons Part 1 - Buildings | Garrisons Part 2 - Followers | Profitable Alchemy Crafts
    Archived: Enchanting | Jewelcrafting | Toy Box Guide | Blacksmithing Transmog Guide
    Want to get the most out of the site and support the community? Consider Premium Membership
    Find a post useful? Give the author rep! And above all, be respectful and friendly to everyone.

  10. #10
    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.

 

 

Similar Threads

  1. [General] Pliaksi's Goblin Crafter Spreadsheet - Development Thread
    By Pliaksi in forum Archive (Addons and Macros)
    Replies: 27
    Last Post: September 19th, 2011, 08:57 AM