Elitist Jerks
Register
Blogs
Forums


Go Back   Elitist Jerks » Public Discussion » Public Discussion

Reply
 
LinkBack Thread Tools
Old 12/23/10, 5:10 PM   #136
flyinfungi
Piston Honda
 
flyinfungi's Avatar
 
Blood Elf Mage
 
Wyrmrest Accord
I have updated my jewel spreadsheet, It now includes elementium and pyrite as well as a small return on profit.

To Do Work:
  • Uncommon Gem --> Rare Gem Xmute
  • Crafted items -->disenchant
  • Uncommon Gems --> Fire Prism
  • Uncommon Gems --> Metagems
  • Uncut Rare Gem --> Cut Gem
  • Gems --> Rare Crafted Item

This sort of analysis is expandable to various other economic areas. Please provide feedback if I am missing anything or any other good area. I have had a few emails requesting access to the spreadsheet. You should be able to copy this into another Google Doc if you want to do your own analysis. If you need more we can talk.

Offline
Reply With Quote
Old 12/24/10, 10:05 PM   #137
Dragion
Glass Joe
 
Dragion's Avatar
 
Undead Rogue
 
Detheroc
I recently shared this spreadsheet with the readers of my site. Here is what one commenter said:

I open the spreadsheet, click file, click download as, and
choose excel. After opening my saved excel sheet it
doesn't look like any of the formulas are present except
for the G-J columns. Any advice from someone who has used the sheet
successful would be appreciated! Thanks.

Offline
Reply With Quote
Old 12/25/10, 1:48 AM   #138
flyinfungi
Piston Honda
 
flyinfungi's Avatar
 
Blood Elf Mage
 
Wyrmrest Accord
Spreadsheet updated. There was a failure in copying from Excel to Google Docs.

Offline
Reply With Quote
Old 12/26/10, 11:56 AM   #139
Voinic
Glass Joe
 
Human Paladin
 
Azuremyst
Originally Posted by flyinfungi View Post
I have updated my jewel spreadsheet, It now includes elementium and pyrite as well as a small return on profit.
Per Pyrite Prospecting Percentages and my experience prospecting about 20 stacks, you only get 1 uncommon gem per prospect, not 1.5 as for elementium and obsidium. Please update your spreadsheet.

Offline
Reply With Quote
Old 12/26/10, 7:52 PM   #140
royaljester
Piston Honda
 
Orc Death Knight
 
Kil'Jaeden
To be clear, is this the profit per prospect as gold, or as a percent of the cost?

United States Offline
Reply With Quote
Old 12/26/10, 8:54 PM   #141
Viruz-eu
Glass Joe
 
Draenei Shaman
 
Norgannon (EU)
There is also a method to farm embersilk cloth in tol barad.

In one area npc fights against enemies and bring them to ~25% of health. You can tag them and deal the last ~30k of hp. They will drop a lot of embersilk cloth.

With a potion of treasure finding u will also get some treasures. The treasures contain gold and in additional embersilk cloth oder any volatile element.

Offline
Reply With Quote
Old 12/27/10, 3:09 AM   #142
smoug
Banned
 
Undead Mage
 
Sunstrider (EU)
For earning gold with prospection you really have to watch the gem market.

In one night Nightstone dropped from 99g to <30g on my realm. Which will make prospecting almost unprofitable.

Offline
Reply With Quote
Old 12/27/10, 9:39 AM   #143
Njus
Glass Joe
 
Tauren Paladin
 
Drenden
Originally Posted by smoug View Post
For earning gold with prospection you really have to watch the gem market.

In one night Nightstone dropped from 99g to <30g on my realm. Which will make prospecting almost unprofitable.
I've seen similar behavior with Ocean Sapphire's as well, but those dips aren't a bad thing by any means. The only gem prices that I've seen (and expect to stay) low are the Amberjewel and the Dream Emerald. Every other gem swings from very cheap, back up to normal as people buy up the cheap stock. To take advantage of these downturns I'd do two things. 1) Buy them when they're that cheap because they're not going to stay that way. 2) Learn cuts of the cheap gems. I've made a killing on Zen Dream Emeralds (and Solid/Rigid Ocean Sapphires) simply because the base gem is so cheap during the price valleys. I actually prefer when the Dream Emeralds cost 20g because I can sell the cut version for 150. Also, don't be afraid to hold your stockpile. By waiting until the price comes back up, you maximize the value of the money you put into prospecting (if you insist on selling raw gems).

TLDR: When prices are that low, use the Jewelcrafting part of Jewelcrafting to make money, not the prospecting part to sell raw gems.

Offline
Reply With Quote
Old 12/27/10, 10:46 AM   #144
TrlstanC
Banned
 
None
Gnome Warlock
 
No WoW Account
Originally Posted by Sonrisa View Post
On my server the mats for [Lifebound Alchemist Stone] go for around 1000g, but you can disenchant it and get a [Maelstrom Crystal] which are currently priced at around 2500g (since they are so scarce). The catch for this is that you need to have both Alchemy and Enchanting, but it seems like quite the profittable deal for anyone with the professions.
If you have Alchemy and Enchanting definitely check the prices for the mats and for the crystals on your server. When I first checked the prices, the mats cost more than the crystals, and now everyone's figure it out and crystals are selling for barely more than the mats. But there was a week or so where a few of us were basically printing money. I'm sure the timing will be different on different servers, so keep your eyes open.

Offline
Reply With Quote
Old 12/27/10, 3:21 PM   #145
biefking
Glass Joe
 
Night Elf Druid
 
Garona
Originally Posted by smoug View Post
For earning gold with prospection you really have to watch the gem market.

In one night Nightstone dropped from 99g to <30g on my realm. Which will make prospecting almost unprofitable.
Only sell Nightstones on the day they are needed by the JC daily.

Offline
Reply With Quote
Old 12/29/10, 5:36 AM   #146
PsiVen
Don Flamenco
 
PsiVen's Avatar
 
Dwarf Paladin
 
Kilrogg
Originally Posted by Deadmoon View Post
This sounded great to me, so I two-manned Vortex Pinnacle normal up to the second boss, and got a total of 6 Volatile Airs, 4 from one mob before the first boss, and 2 from another between first and second bosses. Whether this is RNG or nerf remains to be seen. My partner is not interested in returning.
It's quite RNG, yes. Mobs typically drop either zero or several, so some runs net very little while others are insanely lucrative. Horribly dull though, so I don't know if I'd bring a partner, and I'd wager only well geared protection paladins can pull it off currently. Don't forget that the second boss can drop a fancy mount, even on normal mode.

The main advantage of Volatile Air farming is that it's almost impossible to farm efficiently otherwise, and alchemists on my server are still using their transmutes on Truegold for various reasons. Having bought many transmutes, one of the biggest reasons for this is general ignorance that you can force Life->Air by standing in Uldum.

Offline
Reply With Quote
Old 12/29/10, 2:33 PM   #147
savernon
Piston Honda
 
Night Elf Druid
 
Mannoroth
Originally Posted by PsiVen View Post
It's quite RNG, yes. Mobs typically drop either zero or several, so some runs net very little while others are insanely lucrative. Horribly dull though, so I don't know if I'd bring a partner, and I'd wager only well geared protection paladins can pull it off currently. Don't forget that the second boss can drop a fancy mount, even on normal mode.

The main advantage of Volatile Air farming is that it's almost impossible to farm efficiently otherwise, and alchemists on my server are still using their transmutes on Truegold for various reasons. Having bought many transmutes, one of the biggest reasons for this is general ignorance that you can force Life->Air by standing in Uldum.
A miner engineer is also a pretty decent way to farm volatile airs, with the condenser.

Also, nightmare tears have still been selling well for me, at easily 300g each. Don't understand who is using them, but since I go to dalaran each day with the ring anyways, its only a couple minutes to get the token.

Offline
Reply With Quote
Old 12/29/10, 8:41 PM   #148
Cybsled
Piston Honda
 
Gnome Warlock
 
Doomhammer
Even with a condenser, in my personal experience I was only getting 1-2 Volatile Airs in maybe 1 out of 10 mining nodes, if that. While it is an additional source for volatile airs, it's still very random and you're ultimately going to find yourself with far far more ore then air. It's especially difficult if you've quested a lot and have lost most of the mineral rich spots to phasing (the canyon area near Grim Batol being the most notable one).

Vortex Pinacle runs can be a quick way to get large stacks of it (I've looted stacks of 6-7 per air elemental mob in some cases), although it's still up to the RNG gods and you of course have to have looting rights for the lucky mob.

Offline
Reply With Quote
Old 01/01/11, 3:14 AM   #149
Lazare
Piston Honda
 
Human Priest
 
Lightbringer
Originally Posted by Gzz View Post
So, anyone have found which is the best ore to prospect for profit?
That's really not a useful question; it depends on the price of ore and the price of gems (either raw, cut, or processed into dust, depending on what's most valuable at the moment). That means checking dozens of different prices to actually figure out what the value of each ore is - and all of the prices vary significantly between servers and over time.

On my server, the value (ie, what it's worth to me after I process it) of Obsidium is currently 140g a stack (trending downwards as green gems become less valuable), Elementium is 180g a stack (trending fairly flat due to blue prices mostly staying high), and Pyrium is 340g a stack (trending downards as Volatile Earth prices fall). So the most profitable ore is "whichever one I can find a farmer selling cheaply", and there's no way of knowing what that will be without hanging out in /trade and seeing what's on offer. In the last week or so I've bought and prospected all kinds of ore; there isn't (and can't) be a single answer.

There's a link a few posts back to a decent spreadsheet for prospecting, although you can easily make your own with a couple of minutes looking at Wowhead tables. Plug in the prices of your outputs to find the value of your inputs, add a hefty margin for risk and profit, and then buy anything cheaper than that.

Offline
Reply With Quote
Old 01/01/11, 9:54 AM   #150
Cybsled
Piston Honda
 
Gnome Warlock
 
Doomhammer
Given what WOTLK eventually did with Titanium ore, I think it would be wise to not use the pyrite for prospecting right now anyways.

Offline
Reply With Quote
Reply

Go Back   Elitist Jerks » Public Discussion » Public Discussion

Thread Tools

Similar Threads
Thread Thread Starter Forum Replies Last Post
The icy art of making gold Thairne Public Discussion 2072 07/04/10 8:05 AM
The Art of Making Gold Dollar Public Discussion 2980 06/11/08 6:20 PM