Gem Cut Profit Values - Now A Little Awesomer!

[Zucabr]

Based on Possible Gem Worth of X to Y, multiplied by 1.25, 1.5, 1.75, 2, 2.3, 2.6, 3.5 and 5, rounded to the nearest, then subtracted by 10, 20, 35, 50, 75, 100, 250, 1000,

You're forgetting one component: What about the price on simply dumping it without cutting? You have to subtract that from the profit, too.

then further subtracted by X to Y (base gem worth), followed by the arithmetic mean of the values.

Bolded is the highest average (arithmetic mean) profit range, so it might well be the best cut for that type.

Aqua
Emerald Cut Profit: -8 to -5 , -6.5
Oval Cut Profit: -15 to -9 , -12
Pear Cut Profit: -28 to -19 , -23.5
Plumbbob Cut Profit: -41 to -29 , -35
Marquis Cut Profit: -63 to -48 , -55.5
Crystalball Cut Profit: -86 to -66 , -76
Brilliant Cut Profit: -227 to -197 , -212
Heart Cut Profit: -964 to -916 , -940
    
Smoky Quartz
Emerald Cut Profit: -6 to -4 , -5
Oval Cut Profit: -12 to -7 , -9.5
Pear Cut Profit: -24 to -16 , -20
Plumbbob Cut Profit: -35 to -25 , -30
Marquis Cut Profit: -55 to -42 , -48.5
Crystalball Cut Profit: -76 to -60 , -68
Brilliant Cut Profit: -212 to -187 , -199.5
Heart Cut Profit: -940 to -900 , -920
    
Emerald
Emerald Cut Profit: -5 to -2 , -3.5
Oval Cut Profit: -10 to -5 , -7.5
Pear Cut Profit: -20 to -12 , -16
Plumbbob Cut Profit: -30 to -20 , -25
Marquis Cut Profit: -49 to -36 , -42.5
Crystalball Cut Profit: -68 to -52 , -60
Brilliant Cut Profit: -200 to -175 , -187.5
Heart Cut Profit: -920 to -880 , -900
    
Ruby
Emerald Cut Profit: -4 to -1 , -2.5
Oval Cut Profit: -7 to -2 , -4.5
Pear Cut Profit: -16 to -9 , -12.5
Plumbbob Cut Profit: -25 to -15 , -20
Marquis Cut Profit: -42 to -29 , -35.5
Crystalball Cut Profit: -60 to -44 , -52
Brilliant Cut Profit: -187 to -162 , -174.5
Heart Cut Profit: -900 to -860 , -880
    
Yellow
Emerald Cut Profit: -1 to 5 , 2
Oval Cut Profit: -2 to 10 , 4
Pear Cut Profit: -9 to 10 , 0.5
Plumbbob Cut Profit: -15 to 10 , -2.5
Marquis Cut Profit: -29 to 3 , -13
Crystalball Cut Profit: -44 to -4 , -24
Brilliant Cut Profit: -162 to -100 , -131
Heart Cut Profit: -860 to -760 , -810
    
Tanzanite
Emerald Cut Profit: 6 to 14 , 10
Oval Cut Profit: 13 to 28 , 20.5
Pear Cut Profit: 14 to 36 , 25
Plumbbob Cut Profit: 15 to 45 , 30
Marquis Cut Profit: 10 to 49 , 29.5
Crystalball Cut Profit: 4 to 52 , 28
Brilliant Cut Profit: -87 to -12 , -49.5
Heart Cut Profit: -740 to -620 , -680
    
Diamond
Emerald Cut Profit: 15 to 40 , 27.5
Oval Cut Profit: 30 to 80 , 55
Pear Cut Profit: 40 to 115 , 77.5
Plumbbob Cut Profit: 50 to 150 , 100
Marquis Cut Profit: 55 to 185 , 120
Crystalball Cut Profit: 60 to 220 , 140
Brilliant Cut Profit: 0 to 250 , 125
Heart Cut Profit: -600 to -200 , -400
    
Luminorous
Emerald Cut Profit: 28 to 78 , 53
Oval Cut Profit: 55 to 155 , 105
Pear Cut Profit: 78 to 228 , 153
Plumbbob Cut Profit: 100 to 300 , 200
Marquis Cut Profit: 120 to 380 , 250
Crystalball Cut Profit: 140 to 460 , 300
Brilliant Cut Profit: 125 to 625 , 375
Heart Cut Profit: -400 to 400 , 0
    
Rainbow
Emerald Cut Profit: 103 to 165 , 134
Oval Cut Profit: 205 to 330 , 267.5
Pear Cut Profit: 303 to 490 , 396.5
Plumbbob Cut Profit: 400 to 650 , 525
Marquis Cut Profit: 510 to 835 , 672.5
Crystalball Cut Profit: 620 to 1020 , 820
Brilliant Cut Profit: 875 to 1500 , 1187.5
Heart Cut Profit: 800 to 1800 , 1300
    
Pink
Emerald Cut Profit: 290 to 403 , 346.5
Oval Cut Profit: 580 to 805 , 692.5
Pear Cut Profit: 865 to 1203 , 1034
Plumbbob Cut Profit: 1150 to 1600 , 1375
Marquis Cut Profit: 1485 to 2070 , 1777.5
Crystalball Cut Profit: 1820 to 2540 , 2180
Brilliant Cut Profit: 2750 to 3875 , 3312.5
Heart Cut Profit: 3800 to 5600 , 4700

[Euphemism]

Holy shiz. Extremely useful. Thank you.

*puts paper in printer*

[J. M. Pescado]

You're forgetting one component: What about the price on simply dumping it without cutting? You have to subtract that from the profit, too.

[LVRugger]

This is the one page on sims.wikia.com that I have bookmarked. http://sims.wikia.com/wiki/Collecting_(The_Sims_3)

About halfway down the page is a table of gem cuts, and it lists the cut, cost, increase in value, break-even point and better profit point. I usually collect a bunch of rocks and then send them all to be cut at the same time. I pick the best cut for each rock based on initial value. Anything under $40 to start I just sell the rock outright.

[Aaroc]

When deciding to cut or smelt or not you also have to take into account the chance to get a gnome back instead of the cut/smelted gem/ore. A gnome can be sold for $1000, which means, even not taking into account the amount of money returned from selling the cut gem or smelted ore, you would need to cut 50 100 emerald cut gems without any gnome returns in order to take a loss, or 25 smelted irons before taking a loss with gnome returns. I have found with one of my sims that gnome returns seem to be rather high.

While collecting, I was under the impression that she needed to get the highest cut available on her gems in order to unlock the next cut, so she was sending in even blue topaz to get the highest available cut and still made a tidy profit from the gnome returns. If I remember correctly, she had $40,000 with which to build a new house once she moved out of her parents' house and within only a few sim weeks, with gem collecting as her only source of income, she had well over $100,000 net worth.

Editted math for emerald cut gems, I thought they were $20, but I was mistaken, they are $10.

[Sadie]

That's only after they've been sending them off for a while, I've noticed. Also, once the metal challenge is complete you get extra ingots back, so smelting iron and silver could be worth doing after that.

The trick, of course, is finding that last elusive metal... xP

[Larku]

Now if only my printer would let me print it in a nice manner...
It keeps trying to half print across pages instead of it all nice and tidy.

Oh well...

[fairiefire]

Try this, for your printer:

Aqua   - Emerald Cut
Smoky Quartz - Emerald Cut
Emerald - Emerald Cut
Ruby - Emerald Cut
Yellow - Oval Cut
Tanzanite - Plumbob Cut
Diamond - Crystal Ball Cut
Luminorous - Brilliant Cut
Rainbow - Heart Cut
Pink - Heart Cut

[J. M. Pescado]

AwesomeMod's "Sell & Refine" command automatically performs the calculations dynamically, sending any gems found off to their optimal cuts.

[HazelEyes]

What about using non-optimal cuts to unlock the more expensive cuts?

[J. M. Pescado]

You can do that yourself. The ones that can't be properly cut are simply saved for later, but you can waste them if you are impatient.