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

    Legion Shuffling Spreadsheet - Alpha Released!

    Alpha version released! https://drive.google.com/file/d/0B9G...ew?usp=sharing

    The goal right now is to brainstorm the shuffler's features. We also need data for disenchants, milling, prospecting, and obliterating!

    Here's what I have in mind so far;
    • Tailoring, Blacksmithing, Leatherworking, etc -> Disenchant -> Enchant
    • Tailoring, Blacksmithing, Leatherworking, etc -> Obliterate
    • Ore -> Gems -> Cut Gems
    • Herbs -> Pigment -> ?
    • Leylight -> Arkhana -> Enchant (probably as part of the above)
    • Crafts -> DE -> BoS -> Crafts
    • Your input here


    Looking forward to your thoughts!
    Last edited by Sterling; October 25th, 2016 at 07:37 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
    do you need any information and what addon can i use to gather the info. For instance it would be great to setup tsm with an epic proc % for crafted gear then you could have prices based on that part of the shuffle for the items it may effect.

  3. #3
    Sterling's Avatar
    Posts
    3,856
    Reputation
    379
    Blog Entries
    1
    Tagged in
    2134 Posts
    Add to this user's reputation
    I took the time to test the spreadsheet linked my @MagikMurlok in this post.

    Here were my results;

    4368 used to craft 273 rank 3 . Cost 22,400g.

    Yielded 49 , 3 and 8.68 which I liquidated for 800, 800 and 2450g respectively.

    For a grand total of 63,000g revenue and profit of 40,000g in 45 minutes!

    The yields fall in line with the spreadsheet's ratios, however my Chaos Crystal yield was 18% rather than 12%. More testing needed.
    Last edited by Sterling; September 29th, 2016 at 08:14 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.

  4. #4
    Hi sry to ask. but are you maybe going to make a "public" spreadsheet with the shuffle stuff ? so people will be able to see if it can make profit on their servers

  5. #5
    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 pingwel View Post
    Hi sry to ask. but are you maybe going to make a "public" spreadsheet with the shuffle stuff ? so people will be able to see if it can make profit on their servers
    Yes, just like this: Consortium Cataclysm Shuffling Spreadsheet v4.5
    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.

  6. #6
    Quote Originally Posted by Sterling View Post
    I took the time to test the spreadsheet linked my @MagikMurlok in this post.

    Here were my results;

    4368 used to craft 273 rank 3 . Cost 22,400g.

    Yielded 49 , 3 and 8.68 which I liquidated for 800, 800 and 2450g respectively.

    For a grand total of 63,000g revenue and profit of 40,000g in 45 minutes!

    The yields fall in line with the spreadsheet's ratios, however my Chaos Crystal yield was 18% rather than 12%. More testing needed.
    I've basically just been doing this as I've only got one character going in legion so far. I haven't been keeping track of anything but it seems like epic proc is about 15%, blood of sargeras from disenchant is about 5%. If you'd like me to I can start keeping track of what I've been getting. This is pretty much all I do as far as legion content goes at the moment.

  7. #7
    Cooking, Shoulder boon enchants, transmutes. These would be quite useful.

  8. #8
    glortard's Avatar
    Posts
    135
    Reputation
    2
    Blog Entries
    3
    Tagged in
    24 Posts
    Add to this user's reputation
    Sorry are you d/e them or using the forge or a mixture of both. Cost of cloth my realm would be around 52k to craft same amount right now

  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 che0522 View Post
    Cooking, Shoulder boon enchants, transmutes. These would be quite useful.
    These are straight crafts rather than shuffles, unless I'm missing something with cooking.

    Quote Originally Posted by glortard View Post
    Sorry are you d/e them or using the forge or a mixture of both. Cost of cloth my realm would be around 52k to craft same amount right now
    The yield is Chaos Crystals and Obliterum so I'm using both. Your cloth prices are ~60% higher but so are Chaos Crystals and Obliterum.
    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
    glortard's Avatar
    Posts
    135
    Reputation
    2
    Blog Entries
    3
    Tagged in
    24 Posts
    Add to this user's reputation
    Thanks Sterling. I will drop some gold this weekend and let you know the results.

 

 

Similar Threads

  1. [Gen] Online Legion Shuffling Calculator
    By TheHunter3151 in forum Tools, Programs, and Spreadsheets
    Replies: 3
    Last Post: October 19th, 2016, 10:02 PM
  2. Ore Shuffling Spreadsheet?
    By Hellsscope in forum Archive (General)
    Replies: 4
    Last Post: June 11th, 2013, 04:05 PM

Tags for this Thread