Register
Page 1 of 6 123 ... Last
Results 1 to 10 of 59
  1. #1
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation

    GUIDE: Build a BASIC shuffler with TSM 2.0

    One of the most common questions we see around here about the JC shuffle is "How much should I pay for my ore?".

    Good news! TSM 2.0 Shopping Operations -> Max Price + TSM 2.0 Custom Pricing = Basic in-game shuffler. I know, right?

    Let's first take a look at our basic prospecting yields:

    Ghost Iron - 1 Uncommon / 0.17 Rare / 0.39 Serpent's
    Kyparite - 1 Uncommon / 0.25 Rare / 0.6 Serpent's
    Trillium - 0.67 Uncommon / 0.67 Rare / 0.6 Serpent's

    Given this, our starting max price for Ghost Iron Ore would look something like this:

    Code:
    90% ((RED UC VALUE) + (BLUE UC VALUE) + (YELLOW UC VALUE) + (PURPLE UC VALUE) + (ORANGE UC VALUE) + (GREEN UC VALUE) + ((RED RARE VALUE) * 0.17) + ((BLUE RARE VALUE) * 0.17) + ((YELLOW RARE VALUE) * 0.17) + ((PURPLE RARE VALUE) * 0.17) + ((ORANGE RARE VALUE) * 0.17) + ((GREEN RARE VALUE) * 0.17) + ((SE VALUE) * 0.39))) / 20
    NOTE: the 90% at the beginning is to ensure at least somewhat of a profit margin. Feel free to adjust accordingly.

    From there, we'll want to plug in actual values for each of those items. For a very BASIC shuffler, we'll just use the raw gem value:

    Code:
    90% ( (dbmarket(item:76136)) + (dbmarket(item:76133)) + (dbmarket(item:76134)) + (dbmarket(item:76135)) + (dbmarket(item:76130)) + (dbmarket(item:76137)) + ((dbmarket(item:76131)) * 0.17) + ((dbmarket(item:76138)) * 0.17) + ((dbmarket(item:76142)) * 0.17) + ((dbmarket(item:76141)) * 0.17) + 
     ((dbmarket(item:76140)) * 0.17) + ((dbmarket(item:76139)) * 0.17) + ((dbmarket(item:76734)) * 0.39) ) /20
    NOTE: dbmarket() is probably a decent figure to use if you're shuffling a large volume of ore, but with a smaller amount, dbminbuyout() probably gives a more effective "short term" valuation:
    Code:
    90% ( (dbminbuyout(item:76136)) + (dbminbuyout(item:76133)) + (dbminbuyout(item:76134)) + (dbminbuyout(item:76135)) + (dbminbuyout(item:76130)) +    (dbminbuyout(item:76137)) + ((dbminbuyout(item:76131)) * 0.17) + ((dbminbuyout(item:76138)) * 0.17) + ((dbminbuyout(item:76142)) * 0.17) + ((dbminbuyout(item:76141)) * 0.17) + ((dbminbuyout(item:76140)) * 0.17) + ((dbminbuyout(item:76139)) * 0.17) + ((dbminbuyout(item:76734)) * 0.39) ) /20
    So, if you plug each one of those into Shopping Operations (GIO - Market & GIO - MinBuyout, for example), you can then swap between each of them as necessary. You can also repeat the process for Kyparite Ore and the 2 Trillium Ores are well, just remember to adjust the yield %'s in the formula.

    To take it even further, you can take everything inside the (GEM VALUE) brackets() and replace them with whatever valuation you require. If instead of RAW gem value, we wanted to use an average value of CUT gems, we might replace our Primordial Ruby value with this:
    Code:
    ((dbmarket(item:76696) + dbmarket(item:76694) + dbmarket(item:76692) + dbmarket(item:76695) + dbmarket(item:76693)) / 5)
    This would give you the average value of ALL Red Rare Cuts. If you only know, or sell the big 3 - you can remove the ones you don't need and then adjust the "divide by" count accordingly.

    If you want to get REALLY crazy, you can obviously do whatever you like inside those VALUE brackets - DE yields, Jewelry ratios, Perfect Gem values, some sort of hybrid, "weighted" average. Sky's the limit, really.

    Let me know if you guys have any follow up questions about this, but hopefully this gives people a quick, effective way to purchase their ore for the shuffle now
    Last edited by Kathroman; August 21st, 2013 at 10:21 PM.
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  2. #2
    ShaddamV's Avatar
    Posts
    301
    Reputation
    66
    Tagged in
    94 Posts
    Add to this user's reputation
    Nice post, but the equations (both for dbmarket and dbminbuyout) give me unbalanced paranethesis errors, haven't found the culprit yet.

  3. #3
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    Quote Originally Posted by ShaddamV View Post
    Nice post, but the equations (both for dbmarket and dbminbuyout) give me unbalanced paranethesis errors, haven't found the culprit yet.
    Oh, sorry about that - looks like it's right at the end, the one that should close the 110% one

    EDIT: Updated the CODE blocks - try that instead
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  4. #4
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    Nope - I actually had an extra Open parentheses in front of each of the Rare gem valuations. Tested in-game this time and is now functional.

    Was trying to type/post at work when nobody was watching me this morning
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  5. #5
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    Lol - also had to add /20 to the end of the formula to calculate price per STACK instead of individual ore...
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  6. #6
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    And, here are the dbmarket and dbminbuyout formulas for Kyparite and Trillium, using raw gem values:

    Kyparite dbmarket:
    Code:
    90% ( (dbmarket(item:76136)) + (dbmarket(item:76133)) + (dbmarket(item:76134)) + (dbmarket(item:76135)) + (dbmarket(item:76130)) + (dbmarket(item:76137)) + 
    ((dbmarket(item:76131)) * 0.25) + ((dbmarket(item:76138)) * 0.25) + ((dbmarket(item:76142)) * 0.25) + ((dbmarket(item:76141)) * 0.25) + ((dbmarket(item:76140)) * 0.25) + ((dbmarket(item:76139)) * 0.25) + ((dbmarket(item:76734)) * 0.6) ) /20
    Kyparite dbminbuyout:
    Code:
    90% ( (dbminbuyout(item:76136)) + (dbminbuyout(item:76133)) + (dbminbuyout(item:76134)) + (dbminbuyout(item:76135)) + (dbminbuyout(item:76130)) + (dbminbuyout(item:76137)) + 
    ((dbminbuyout(item:76131)) * 0.25) + ((dbminbuyout(item:76138)) * 0.25) + ((dbminbuyout(item:76142)) * 0.25) + ((dbminbuyout(item:76141)) * 0.25) + ((dbminbuyout(item:76140)) * 0.25) + ((dbminbuyout(item:76139)) * 0.25) + ((dbminbuyout(item:76734)) * 0.6) ) /20
    Trillium dbmarket:
    Code:
    90% ( ((dbmarket(item:76136)) * 0.67) + ((dbmarket(item:76133)) * 0.67) + ((dbmarket(item:76134)) * 0.67) + ((dbmarket(item:76135)) * 0.67) + ((dbmarket(item:76130)) * 0.67) + ((dbmarket(item:76137)) * 0.67) + ((dbmarket(item:76131)) * 0.67) + ((dbmarket(item:76138)) * 0.67) + ((dbmarket(item:76142)) * 0.67) + ((dbmarket(item:76141)) * 0.67) + ((dbmarket(item:76140)) * 0.67) + ((dbmarket(item:76139)) * 0.67) + ((dbmarket(item:76734)) * 0.6) ) /20
    Trillium dbminbuyout:
    Code:
    90% ( ((dbminbuyout(item:76136)) * 0.67) + ((dbminbuyout(item:76133)) * 0.67) + ((dbminbuyout(item:76134)) * 0.67) + ((dbminbuyout(item:76135)) * 0.67) + ((dbminbuyout(item:76130)) * 0.67) + ((dbminbuyout(item:76137)) * 0.67) + ((dbminbuyout(item:76131)) * 0.67) + ((dbminbuyout(item:76138)) * 0.67) + ((dbminbuyout(item:76142)) * 0.67) + ((dbminbuyout(item:76141)) * 0.67) + ((dbminbuyout(item:76140)) * 0.67) + ((dbminbuyout(item:76139)) * 0.67) + ((dbminbuyout(item:76734)) * 0.6) ) /20
    Last edited by Kathroman; August 21st, 2013 at 10:21 PM.
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  7. #7
    Caitlyn's Avatar
    Posts
    1,190
    Reputation
    127
    Tagged in
    627 Posts
    Add to this user's reputation
    Nice! This is the kind of brief, accessible guide that is perfect for those who've started to feel more comfortable with most of the basics of TSM 2.0 and are ready to fine-tune things a bit.

  8. #8
    Thanks! this is just what I was looking for, perfect starting point. My next step is to work out replacing the UC cuts with enchanting mats.

  9. #9
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    Quote Originally Posted by Snicks View Post
    Thanks! this is just what I was looking for, perfect starting point. My next step is to work out replacing the UC cuts with enchanting mats.
    Here's a rough outline of what this might look like (EDIT: I was originally only going to post a rough outline and leave the specific numbers alone, but then I realised it was basically 90% done anyway, so I pretty much did the whole thing )

    Even if you want the flat-out enchanting value (IE. 100% of your uncommon gems are processed into jewelry), you still need to account for the Blue jewelry procs and what to do with THEM. So, your "jewelry" valuation would look something like this:
    Code:
    ( ((uncommon jewelry value) * 0.9) + ((rare jewelry value) * 0.1) - (SETTING COST) ) / 3
    Now, if you wanted to take the average of your raw gems and your jewelry value, you'd be looking at something like this:
    Code:
    ( ( (raw UC value) + ( ((uncommon jewelry value) * 0.9) + ((rare jewelry value) * 0.1) - (SETTING COST) ) / 3 ) / 2 )
    If you instead wanted to use a weighted value, say 25% raw, 75% jewelry, it would look like this:
    Code:
    ( ( (raw UC value) * 0.25) + ( ( ((uncommon jewelry value) * 0.9) + ((rare jewelry value) * 0.1) - (SETTING COST) ) / 3 * 0.75) )
    Next step is simply filling in those uncommon and rare jewelry values. Here, I think there's probably 2 choices for the rare jewelry - either sell as-is, or DE as well.

    for uncommon jewelry value, you'd be looking at something like this:
    Code:
    ( ((DUST VALUE) * 2.2) + ((ESSENCE VALUE) * 0.3)  )
    For rare jewelry value, you'd either plug in the price source for the actual piece of jewelry, or for a Small Heavenly Shard (or a reg. Heavenly Shard / 3, if you'd prefer to convert up, or a max() of both or a weighted average, if you want to optimize it)

    So, you'd then either plug that whole set of brackets into your UC Value () bracket, or add it into the straight or weighted average formulas and drop those whole functions in there instead.

    Make sense?

    If not, feel free to ask any specific questions, but at this point, it's really diverging into a case-by-case sort of customization, so it will make less sense to write out EVERY SINGLE possibility than it will be to troubleshoot individual scenarios, I'd say.
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

  10. #10
    Kathroman's Avatar
    Posts
    5,452
    Reputation
    286
    Blog Entries
    20
    Tagged in
    2157 Posts
    Add to this user's reputation
    Just a heads up - I'm working on expanding this formula to cover the ENTIRE shuffle. It's going to take some time, though. It's pushing nearly 400 LINES of code already and I've only covered the uncommon valuations and am about to tackle the rares...
    Like what you see? Become an Ethereal Contributor to help support the site and gain access to additional perks.

        

    Guides: Thunder Bluff Vendor Supply Route | Entry Level JC Strategy | Alternative DMF Guide

    TSM 2.0: TSM 2.0 Groups & Operations GUIDE | TSM 2.0 Basic JC Shuffler | TSM 2.0 ADVANCED JC Shuffler

 

 

Similar Threads

  1. Profession Beta Build
    By Tangster in forum Archive (Speculation)
    Replies: 2
    Last Post: May 9th, 2012, 01:21 AM
  2. Where Would You Build Your Castle?
    By Namssob in forum Off Topic
    Replies: 25
    Last Post: November 2nd, 2011, 10:39 PM
  3. Basic Toon/Spec Guides?
    By Faid in forum Archive (Powerleveling)
    Replies: 4
    Last Post: October 30th, 2011, 11:38 AM
  4. Have all professions. How to build on 120K
    By bankofburk in forum Archive (General)
    Replies: 5
    Last Post: September 29th, 2011, 02:46 PM