Register
Results 1 to 3 of 3
  1. #1

    Lvl 85 Blue Proc crafted gear threshold pricing

    For awhile now I have been selling the lvl 85 ilvl415 blue gear that you get from crafting the lvl 85 gear from various professions, and making some nice coin off of them. However when I started selling them I had to create a spreadsheet to keep track of my costs for the blue procs as there is no easy (blanket) way of applying an operation to all of them. This is due to the variances in crafting cost, as well as the differences in the vendor sell price of the green, and the disenchant values of the items.

    Now that TSM 2.0 is out, and we were given the amazing ability to use custom pricing with a wide array of different price sources to pull from, as well as the basic arithmetic, and the awesome functions (ie. max(), min(), first()).

    First, before we get into the maths too much, we need to understand that the blue gear procs at a rate of ~10%. This means that a lazy way of determining the value for these items is to just multiply the crafting cost of the item it procs from and multiply it by 10. However I find this solution in-elegant and cumbersome, do to the sheer number of operations you would need to setup, so my goal was to create some formulas that would be able to cover as many items as possible while still being as accurate as possible for those items.

    To accomplish this I decided that taking the average crafting cost of all the green crafts for that particular set of gear (there are 4, 2 for LW 1 for BS, and 1 for Tailoring), then multiplying that by 10. Now while this is a fine place to stop if you wish, I decided to take it a step further and subtract the average value of the max value of either the vendor sale or disenchant value of the green crafted gear for that set.

    Which provides us with a basic formula looking like this: (avg crafting cost * 10)-(avg of max(vendor/de value) * 9)

    I believe this provides a much more accurate threshold for me, since it takes into account the cost of crafting the item, as well as the minimum amount of gold I would get back from vendoring/disenchanting the items, though I also sell some of the green crafted gear as well, which further covers any more costs, but trying to figure that into the formula turned out to be way to unreliable of numbers.

    So, with out further ado, here are the complete formulas for each set of lvl 85 Blue Proc crafted gear (these formulas are designed to be used in the auctioning operation thresholds):

    Ghost-Forged Set (BS):
    Code:
    (((crafting(item:82903)+crafting(item:82904)+crafting(item:82905)+crafting(item:82906)+crafting(item:82907)+crafting(item:82908)+crafting(item:82909)+crafting(item:82910))/8)*10)-(((max(disenchant(item:82903),vendorsell(item:82903))+max(disenchant(item:82904),vendorsell(item:82904))+max(disenchant(item:82905),vendorsell(item:82905))+max(disenchant(item:82906),vendorsell(item:82906))+max(disenchant(item:82907),vendorsell(item:82907))+max(disenchant(item:82908),vendorsell(item:82908))+max(disenchant(item:82909),vendorsell(item:82909))+max(disenchant(item:82910),vendorsell(item:82910)))/8)*9)
    Misthide Set (LW - Leather):
    Code:
    (((crafting(item:85832)+crafting(item:85833)+crafting(item:85834)+crafting(item:85835)+crafting(item:85836)+crafting(item:85837)+crafting(item:85838)+crafting(item:85839))/8)*10)-(((max(disenchant(item:85832),vendorsell(item:85832))+max(disenchant(item:85833),vendorsell(item:85833))+max(disenchant(item:85834),vendorsell(item:85834))+max(disenchant(item:85835),vendorsell(item:85835))+max(disenchant(item:85836),vendorsell(item:85836))+max(disenchant(item:85837),vendorsell(item:85837))+max(disenchant(item:85838),vendorsell(item:85838))+max(disenchant(item:85839),vendorsell(item:85839)))/8)*9)
    Stormscale Set (LW - Mail):
    Code:
    (((crafting(item:85841)+crafting(item:85842)+crafting(item:85843)+crafting(item:85844)+crafting(item:85845)+crafting(item:85846)+crafting(item:85847)+crafting(item:85848))/8)*10)-(((max(disenchant(item:85841),vendorsell(item:85841))+max(disenchant(item:85842),vendorsell(item:85842))+max(disenchant(item:85843),vendorsell(item:85843))+max(disenchant(item:85844),vendorsell(item:85844))+max(disenchant(item:85845),vendorsell(item:85845))+max(disenchant(item:85846),vendorsell(item:85846))+max(disenchant(item:85847),vendorsell(item:85847))+max(disenchant(item:85848),vendorsell(item:85848)))/8)*9)
    Windwool Set (Tailoring):
    Code:
    (((crafting(item:82398)+crafting(item:82397)+crafting(item:82399)+crafting(item:82400)+crafting(item:82401)+crafting(item:82402)+crafting(item:82403)+crafting(item:82404))/8)*10)-(((max(disenchant(item:82397),vendorsell(item:82397))+max(disenchant(item:82398),vendorsell(item:82398))+max(disenchant(item:82399),vendorsell(item:82399))+max(disenchant(item:82400),vendorsell(item:82400))+max(disenchant(item:82401),vendorsell(item:82401))+max(disenchant(item:82402),vendorsell(item:82402))+max(disenchant(item:82403),vendorsell(item:82403))+max(disenchant(item:82404),vendorsell(item:82404)))/8)*9)

  2. #2
    ShaddamV's Avatar
    Posts
    301
    Reputation
    66
    Tagged in
    94 Posts
    Add to this user's reputation
    Great post. I'll +rep when I can.

  3. #3
    Where do you add the formulas?
    In the auctioning operations threshold or in the crafting minimum price?

 

 

Similar Threads

  1. Crafted costs not registering (threshold (0))
    By Khas in forum General TradeSkillMaster Discussion
    Replies: 10
    Last Post: June 6th, 2013, 07:00 AM
  2. Crafted Gear
    By felthunn in forum Archive (Professions)
    Replies: 4
    Last Post: April 13th, 2013, 03:13 PM
  3. Crafted 496 gear
    By Diablous in forum Archive (Professions)
    Replies: 2
    Last Post: October 29th, 2012, 08:53 AM
  4. Blue JC Ring/Neck Proc for PvP
    By MarthiusIT in forum Archive (Professions)
    Replies: 8
    Last Post: September 18th, 2011, 10:16 AM
  5. Blue PvP Gear
    By Mugsley in forum Archive (Professions)
    Replies: 5
    Last Post: February 25th, 2011, 09:51 AM