"Weekly" Update Number 2

[Ualaa]

It was just a very simple spreadsheet.

Gem names in column A.
Current per 1 value in column B.
Chance to prospect that type of gem in column C (18% or 4%).
Column B x Column C (long term, prospect results) in column D.

Then a few cells which calculate off of values in column D.

Value per 5...
Sum (D8 through D13)
Sum (D15 through D20)
Sum (D8 through D20)
-- Which is basically Prospect Value of a 5-stack of Saronite, if you look at current prices for the Bloodstone-Sun Crystal gems or the Autumn's Glow-Twilight Opal Gems, or total value of all gems.

Then have six more calculations, all based off of the Per 5 calculations.
Per 20, is just x4 of the first set.
Each, is just /5 of the first set.



If you assume, prospecting Saronite with resale of everything except Scarlet Rubies (give them a value of 0 in the spreadsheet), then Scarlet Rubies are frequently free. Although the other gems don't always sell completely without a few listings.

Given 0 material cost for the gems component, the Cardinal Ruby cuts are suddenly very profitable. But paying 75g per Scarlet Ruby (server average), versus 6-9g per other transmute gem, and Cardinal Rubies are the least profitable transmute.

[Shodokan]

It was just a very simple spreadsheet.

Gem names in column A.
Current per 1 value in column B.
Chance to prospect that type of gem in column C (18% or 4%).
Column B x Column C (long term, prospect results) in column D.

Then a few cells which calculate off of values in column D.

Value per 5...
Sum (D8 through D13)
Sum (D15 through D20)
Sum (D8 through D20)
-- Which is basically Prospect Value of a 5-stack of Saronite, if you look at current prices for the Bloodstone-Sun Crystal gems or the Autumn's Glow-Twilight Opal Gems, or total value of all gems.

Then have six more calculations, all based off of the Per 5 calculations.
Per 20, is just x4 of the first set.
Each, is just /5 of the first set.



If you assume, prospecting Saronite with resale of everything except Scarlet Rubies (give them a value of 0 in the spreadsheet), then Scarlet Rubies are frequently free. Although the other gems don't always sell completely without a few listings.

Given 0 material cost for the gems component, the Cardinal Ruby cuts are suddenly very profitable. But paying 75g per Scarlet Ruby (server average), versus 6-9g per other transmute gem, and Cardinal Rubies are the least profitable transmute.

Why not just make the lesser gems, the overall profit is higher if you sell the scarlet rubies and make zircon/ambers.

What i've been doing is as follows.

Buy 100 stacks of ore
Prospect
Turn red/blue/orange/yellow into rings/amulets (green gems)
DE rings/amulets (only do this if the average value is > 3.14 gold)
Cut green/purple/ornage gems into anything for 4.5g each (instead of 3g to vendor or value on ah is about 4g)
Cut green/purple GREEN quality gems into anything and vendor (50 silver each, 1g per peftect)
Sell the scarlet rubies
Save the blue/yellow gems.

I sell/buy at the following prices.

Buy
Eternal life: 9-10g each
Eternal earth: 2-3g each
Eternal air: 8-9g each
Eternal fire: 10-12g each
Saronite: 12-13 gold per stack

Sell
Majestic Zircon: 155
King's Amber: 155
Cardinal Ruby: 180
Scarlet Ruby: 45-55g (depending on what is on the ah)

If you can sell everything to vendor and such, you end up making your three blue type of gems for about 9g each. If you sell the rubies the two other types are basically free. Then your cost per gem ends up being about 10g. For a 145g profit per. Finding buyers for blue/yellow gems is near impossible unless you cut them and wait. The blue/yellow gems sell for about 6g on the ah. So if you were to sell both it would average out the price of rubies to be the same, unless you cut them yourself and list them for the extra 20-30g profit per.