Stede & Co's MoP Shuffling Spreadsheet

[aokkoa]

Thanks for the spreadsheet, and Unholy's elaboration on some specifics

[Stede]

What the hell is +450 Jewelry o.O

It's the ilvl 450 RIngs and Necks that can be made with Serpent's Eyes. Patterns are available from trainer in Jade Forest.

[Popocub]

It's the ilvl 450 RIngs and Necks that can be made with Serpent's Eyes. Patterns are available from trainer in Jade Forest.

Ah, thanks. Is the Spreadsheet assuming you sell them or DE them..?

[Unholyshaman]

Ah, thanks. Is the Spreadsheet assuming you sell them or DE them..?

You choose how to allocate the gems. See my mini-guide on the previous page.

[Popocub]

You choose how to allocate the gems. See my mini-guide on the previous page.

I mean if you allocate the +450 Jewelry--do we DE the jewelry or just try and sell them? What is the spreadsheet assuming for profit in this case?

[Drunkheals]

Hello, when I put my realm prices in the prices section, it ruins the shuffle section. With your realm I can see everything, but when I use my realm it cant find the value in the final items for sale

[Stede]

Ah, thanks. Is the Spreadsheet assuming you sell them or DE them..?

For the 450 Jewelry, it presumes you'll sell them. Stuff like Lionsfall Ring, Band of Blood - that sort of thing. I haven't yet seen many cases where DE'ing them into a shard is a better way to go, but if there's enough interest, I may try to squeeze the option in a future update.

[Stede]

Hello, when I put my realm prices in the prices section, it ruins the shuffle section. With your realm I can see everything, but when I use my realm it cant find the value in the final items for sale

Has your data copied over ok into the prices section? Sometimes it can give EU users trouble because of how periods and commas are treated differently.

If so, this is the fix, courtesy Mithrildar:

1. Select the whole column the data is in.
2. Go to the 5th tab in Excel, should be called something like "Data"
3. Click on "Text to Columns"
4. Select Seperated and click on Next
5. Now select comma
DONE!

(if there still is a problem you might have to switch the comma and dot around, US use comma for 1000s and dots for decimals, but like here in the NL we use it the other way around, this can be done at the end of the text to columns menu).

[Drunkheals]

I used the old spreadsheat, now that I'm using the new it kinda works.
It bugs with the function: CutGemPrice = Cut1 / Cut2

[TheKingCoop]

Thank you very much for this spreadsheet, this is the first time I am trying to shuffle snce ore prices are so low.

Questions:
1) When I fill in my gem allocations, the balance comes up as a negative. Is this correct? I start with 40 stacks of GIO, and then fill in the allocations. Once this is done, before I fill in the field for Serpent's Eye, the balance says -137, while all fields above say 0. According to Unholyshaman's guide, I am doing it right. I just don't want to invest into this, and have been doing it wrong the whole time.

2) If we farm all the ore ourselves, should we put the ore at 0g/stack ?

Thanks again for your time and effort!

[quietstrm07]

Thank you very much for this spreadsheet, this is the first time I am trying to shuffle snce ore prices are so low.

Questions:
1) When I fill in my gem allocations, the balance comes up as a negative. Is this correct? I start with 40 stacks of GIO, and then fill in the allocations. Once this is done, before I fill in the field for Serpent's Eye, the balance says -137, while all fields above say 0. According to Unholyshaman's guide, I am doing it right. I just don't want to invest into this, and have been doing it wrong the whole time.

2) If we farm all the ore ourselves, should we put the ore at 0g/stack ?

Thanks again for your time and effort!

1) Your first issue is you're probably putting most of the gems into rings, which require 6 serpent's eyes each. You have to take that into account when allocating your gems. I'd move some of the less profitable jewelry into other profitable things (or sell raw)

2) I highly recommend never setting anything you farm to 0 in anything you do. The reality is you have 2 choices: sell it raw (for AH price) or to shuffle it. If you farm it, you know you're making profit somehow, but the question is if you're going to make more profit shuffling the ore than just selling it as stacks. If it's not worth the effort, take the lazy way and make your gold by selling stacks of ore. To figure that out, I still have a tendency to put the ore price at near AH price

[Unholyshaman]

Thank you very much for this spreadsheet, this is the first time I am trying to shuffle snce ore prices are so low.

Questions:
1) When I fill in my gem allocations, the balance comes up as a negative. Is this correct? I start with 40 stacks of GIO, and then fill in the allocations. Once this is done, before I fill in the field for Serpent's Eye, the balance says -137, while all fields above say 0. According to Unholyshaman's guide, I am doing it right. I just don't want to invest into this, and have been doing it wrong the whole time.

2) If we farm all the ore ourselves, should we put the ore at 0g/stack ?

Thanks again for your time and effort!

As Quietstrm07 said on the last bit. NEVER assume that just because you farmed something, it's free.

Opportunity cost is a concept used to evaluate the cost of performing 1 action over another.

When you chose to farm ore, your opportunity cost is what could you have been doing in that time frame instead of farming ore? Was there something else more profitable to farm? Could you have been crafting and selling items for a greater profit? Etc.

When you chose to farm ore AND then use that ore in the shuffle, your opportunity cost increases. Not only is it what you missed out on as listed above, it's also the market price that the ore sells for. You could have farmed that ore and then sold it, for say 30g a stack. Therefore your opportunity cost is whatever you value your time as + the market price of the ore.

That market price is what you should factor into your calculations.

[Zerotime]

2) If we farm all the ore ourselves, should we put the ore at 0g/stack ?

If your time is worth zero, then you want to put zero in. Opportunity cost applies so you more than likely want to put the common price of ore up, since you could sell the ore for that. The spreadsheet also assumes you don't farm ore yourself, you buy it, because as we all know if you invest your own time collecting the materials it's obviously free.

[TheKingCoop]

1) Your first issue is you're probably putting most of the gems into rings, which require 6 serpent's eyes each. You have to take that into account when allocating your gems. I'd move some of the less profitable jewelry into other profitable things (or sell raw)

2) I highly recommend never setting anything you farm to 0 in anything you do. The reality is you have 2 choices: sell it raw (for AH price) or to shuffle it. If you farm it, you know you're making profit somehow, but the question is if you're going to make more profit shuffling the ore than just selling it as stacks. If it's not worth the effort, take the lazy way and make your gold by selling stacks of ore. To figure that out, I still have a tendency to put the ore price at near AH price

So are you and Unholyshaman saying that, if ore is at about 50g a stack, its better to farm like crazy? Because I was under the impression that, whether you buy it, or farm it, regardless of the time spent, you will make more through the shuffle. My current issue, on my server, is that I can see a declining trend in prices for all farmed goods. Thus, I am venturing to find more profitable methods, leading me to this ore shuffle. I will be farming ore regardless, so the time is not the issue.

(hope I didn't ramble and what i meant was conveyed,; obviously I think faster than I can type it all out. lol.)

[quietstrm07]

So are you and Unholyshaman saying that, if ore is at about 50g a stack, its better to farm like crazy? Because I was under the impression that, whether you buy it, or farm it, regardless of the time spent, you will make more through the shuffle. My current issue, on my server, is that I can see a declining trend in prices for all farmed goods. Thus, I am venturing to find more profitable methods, leading me to this ore shuffle. I will be farming ore regardless, so the time is not the issue.

(hope I didn't ramble and what i meant was conveyed,; obviously I think faster than I can type it all out. lol.)

The only way to know if it's profitable to sell the ore straight up or to shuffle it is by comparing the AH price of the ore to the possible amount you could get via the shuffle. On most servers, the shuffle is profitable, but you can never say whether it is or not for all servers at any given point in time. So basically, I would say you could use the spreadsheet to say whether you want to go through the effort of shuffling or not. As all goblins know, "Time is money, friend"