PDA

View Full Version : Crafting: Essence Deconstuction rates



Natean
06-05-2011, 08:32 AM
This Thread is about how much Essence you aquire from deconstructing Items and Shards. For those who do not know already, each level of deconstruction gives a different amount of Lesser and Greater Essence.

Links below for Raw Data
Item Data/Results
Shard Data/Results
Combined Data/Results

Notes

Deconstructing items should have a higher essence rate than shards due to the update where you get more essence for deconstructing higher leveled items. (Since Shards has no listed ML).
I do not expect these to be completely accurate, even from deconstructing hundreds of times, especially higher level deconstructions where the range of essence is much larger. I consider data for Level 1 to be the most accurate.
You can exhange 1 Greater Essence to 5 Lesser Essence, but not the other way around.
I have combined both Item and Shard deconstruction data to give a better sense in the overall average Essence aquired from deconstruction. This provides a better estimate as more numbers is more accurate.
The data also provides the number of times an essence has been produced at a specific number (i.e. Of 858 Level 1 deconstructed items, it produced 1 lesser essence 304 times).
Due to the nature of forums format, I have to use _ to make the Data more readable and easier to understand.
The data gives a good estimation in the returns you get from making a level 1 shard and deconstructing it to gain crafting exp.
The method I used to record this data was to write down how much essence was produced when deconstructing, I then put up the data in a table to make better sense of it. Therefore, there may be slight errors as some data may be lost/incorrect, quantity reduces errors.
I always try to maximise the level of deconstruction for every Item I deconstruct.
This is data aquired during U9.1
Deconstruction Level of clickies is Enchantment modifier of clicky -2

I stared this data collection after U9.1 where Items were updated to produce more essence depending on its ML. My original objective was to use this with the Market Price of essences to find if it was cheaper to buy essences from people or to buy items and deconstructing it (the latter holds true). By sharing this data to public, I forsee one/mixture of three things: Prices of essence falling (to match item price), Prices of items rising (to match essence price), no change.

To clarify: I consider data for Level 1 Deconstruction to be most accurate in determining the approximation for essence produced from deconstructing, as there over 1000 recordings. Every other is a close approximation, and could require some more data to solidify it.

How to use this data to your advantage:
Given a market price for Essence, say 140 ea for Lessers and 700 ea for Greaters (which is the current Market Price in Cannith). It is possible to buy Level 1 deconstructable items for less than 500pp and Level 5 deconstructable items for less than 5500pp, deconstruct them, and sell the essence and make a profit (as well as gaining deconstruction exp.)
i.e. Average Lesser recieved * Lesser Price + Average Greater recieved * Greater Price = Cost of Item to deconstruct

Basically by sharing this knowledge, I am litereally trying to crash the market for essence across all servers :D

Using combined data, this is what price you should buy these level of items and make profit
Market Price
if Lessers = 200pp, Greaters = 1000pp
Level 1 : 741 pp
Level 2 : 1294 pp
Level 3 : 2464 pp
Level 4 : 4429 pp
Level 5 : 8208 pp

if Lessers = 140pp, Greaters = 700pp
Level 1 : 518 pp
Level 2 : 906 pp
Level 3 : 1725 pp
Level 4 : 3100 pp
Level 5 : 5745 pp

if Lessers = 100pp, Greaters = 500pp
Level 1 : 370 pp
Level 2 : 647 pp
Level 3 : 1232 pp
Level 4 : 2214 pp
Level 5 : 4104 pp

Help/FAQ
If anyone were to put in thier own data (preferable in the hundreds of deconstructs) much appreciated.
FAQs to be updated

Edit: I may edit the shard deconstruction data as I am going thru the decon lvl 1 shard method to level crafting.

Natean
06-05-2011, 08:32 AM
Item Deconstruction Data

This is the data from deconstructing Items

Please be reminded that as from U9.1, Higher ML items give out more Essence for level level amounts

It is read as follows: (_ used for better readability)
Level of Item/Shard Deconstructed
Lesser Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired
Greater Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired

Raw Data

LVL 1
Lesser
1__ 2__ 3__ 4__ 5__
304 283 268 2__ 1__
Greater
0__ 1__
565 293

LVL 2
Lesser
1_ 2_ 3_ 4_ 5_ 6_ 7_ 8
0_ 9_ 66 75 60 34 10 1
Greater
0__ 1__ 2__ 3__
178 37_ 35_ 5__

LVL 3
Lesser
4_ 5_ 6_ 7_ 8_ 9_ 10 11 12 13 14 15 16
2_ 1_ 4_ 17 20 21 18 14 6_ 9_ 2_ 0_ 1_
Greater
0_ 1_ 2_ 3_ 4_
73 17 11 8_ 6_

LVL 4
Lesser
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
1_ 1_ 0_ 7_ 7_ 6_ 22 9_ 17 17 15 7_ 6_ 9_ 3_ 1_ 1_
Greater
0_ 1_ 2_ 3_ 4_ 5
85 7_ 10 8_ 11 8

LVL 5
Lesser
24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
1_ 1_ 1_ 2_ 8_ 16 9_ 17 18 24 21 39 42 29 22 14 16 14 4_ 6_ 4_ 3_ 2_ 0_ 0_ 1_
Greater
0__ 1__ 2__ 3__ 4__ 5__ 6__ 7
204 24_ 19_ 23_ 11_ 21_ 11_ 1

Results

Level 1
# Deconstructed: 858
# Lesser Essence: 1687
# Greater Essence: 293
Lesser/Decon: 1.966200466
Greater/Decon: 0.341491841

Level 2
# Deconstructed: 255
# Lesser Essence: 1098
# Greater Essence: 122
Lesser/Decon: 4.305882353
Greater/Decon: 0.478431373

Level 3
# Deconstructed: 115
# Lesser Essence: 1072
# Greater Essence: 87
Lesser/Decon: 9.32173913
Greater/Decon: 0.756521739

Level 4
# Deconstructed: 129
# Lesser Essence: 2343
# Greater Essence: 135
Lesser/Decon: 18.1627907
Greater/Decon: 1.046511628

Level 5
# Deconstructed: 314
# Lesser Essence: 11120
# Greater Essence: 353
Lesser/Decon: 35.41401274
Greater/Decon: 1.124203822

Natean
06-05-2011, 08:33 AM
Shard Deconstruction Data

This is the data from deconstructing Shards

It is read as follows: (_ used for better readability)
Level of Item/Shard Deconstructed
Lesser Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired
Greater Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired

Raw Data

LVL 1
Lesser
1_ 2_ 3_
96 90 70
Greater
0__ 1
158 98

LVL 2
Lesser
1 2 3 4 5 6
0 2 3 3 0 2
Greater
0 1 2
5 1 4

LVL 3
Lesser
4_ 5_ 6_ 7_ 8_ 9_ 10 11 12
1_ 3_ 12 23 27 30 20 6_ 1_
Greater
0_ 1_ 2_ 3_
82 14 13 14

LVL 4
Lesser
10 11 12 13 14 15 16 17 18 19 20
0_ 1_ 4_ 1_ 8_ 6_ 4_ 3_ 2_ 4_ 3_
Greater
0_ 1_ 2_ 3_
26 6_ 3_ 1_

LVL 5
Lesser
24 25 26 27 28 29 30 31 32 33 34
0_ 0_ 0_ 1_ 0_ 0_ 2_ 0_ 0_ 0_ 1
Greater
0 1 2 3 4 5
2 0 0 0 1 1

Results

Level 1
# Deconstructed :256
# Lesser Essence :486
# Greater Essence :98
Lesser/Decon: 1.8984375
Greater/Decon: 0.3828125
Lesser Equivalent: 3.8125 (1 Greater = 5 Lesser)

Level 2 (insufficient Data)
# Deconstructed: 10
# Lesser Essence: 37
# Greater Essence: 9
Lesser/Decon: 3.7
Greater/Decon: 0.9

Level 3
# Deconstructed: 123
# Lesser Essence: 1016
# Greater Essence: 82
Lesser/Decon: 8.260162602
Greater/Decon: 0.666666667

Level 4 (insufficient Data)
# Deconstructed: 36
# Lesser Essence: 561
# Greater Essence: 15
Lesser/Decon: 15.58333333
Greater/Decon: 0.416666667

Level 5 (insufficient Data)
# Deconstructed: 4
# Lesser Essence: 121
# Greater Essence: 9
Lesser/Decon: 30.25
Greater/Decon: 2.25

Edit: Due to the time consuming factor in recording individual deconstructions, I have opted for a faster general method. Thus, this will not sure the % rate in deconstructing specific amounds of essence. This only applies to Level 1 Shards as I am doing that method to level my crafting.

Level 1
Deconstructed: 1761
Lesser Essence: 3474
Greater Essence: 610
Equivalent Lesser Essence Return rate: 3.7047

Natean
06-05-2011, 08:34 AM
Combined Deconstruction Data

This is the combined data from deconstructing Items and Shards

It is read as follows: (_ used for better readability)
Level of Item/Shard Deconstructed
Lesser Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired
Greater Essence
Number of Essence aquired from deconstructing such Level
Number of times this amount of essence was aquired

Raw Data

LVL 1
Lesser
1__ 2__ 3__ 4__ 5
400 373 338 2__ 1
Greater
0__ 1__
723 391

LVL 2
Lesser
1_ 2_ 3_ 4_ 5_ 6_ 7_ 8
0_ 11 69 78 60 36 10 1
Greater
0__ 1__ 2__
183 38_ 39_

LVL 3
Lesser
4_ 5_ 6_ 7_ 8_ 9_ 10 11 12 13 14 15 16
3_ 4_ 16 40 47 51 38 20 7_ 9_ 2_ 0_ 1_
Greater
0__ 1__ 2__ 3__ 4
155 31_ 24_ 22_ 6

LVL 4
Lesser
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
1_ 2_ 4_ 8_ 15 12 26 12 19 21 18 7_ 6_ 9_ 3_ 1_ 1
Greater
0__ 1__ 2__ 3__ 4__ 5
111 13_ 13_ 9__ 11_ 8

LVL 5
Lesser
24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
1_ 1_ 1_ 3_ 8_ 16 11 17 18 24 22 39 42 29 22 14 16 14 4_ 6_ 4_ 3_ 2_ 0_ 0_ 1
Greater
0__ 1__ 2__ 3__ 4__ 5__ 6__ 7
206 24_ 19_ 23_ 12_ 22_ 11_ 1

Results

Level 1
# Deconstructed: 1114
# Lesser Essence: 2173
# Greater Essence: 391
Lesser/Decon: 1.950628366
Greater/Decon: 0.350987433
Lesser Equivalent: 3.70556553 (1 Greater = 5 Lesser)

Level 2
# Deconstructed: 265
# Lesser Essence: 1135
# Greater Essence: 116
Lesser/Decon: 4.283018868
Greater/Decon: 0.437735849

Level 3
# Deconstructed: 238
# Lesser Essence: 2088
# Greater Essence: 169
Lesser/Decon: 8.773109244
Greater/Decon: 0.710084034

Level 4
# Deconstructed: 165
# Lesser Essence: 2904
# Greater Essence: 150
Lesser/Decon: 17.6
Greater/Decon: 0.909090909

Level 5
# Deconstructed: 318
# Lesser Essence: 11241
# Greater Essence: 362
Lesser/Decon: 35.3490566
Greater/Decon: 1.13836478

Market Price
if Lessers = 200pp, Greaters = 1000pp
Level 1 : 741 pp
Level 2 : 1294 pp
Level 3 : 2464 pp
Level 4 : 4429 pp
Level 5 : 8208 pp

if Lessers = 140pp, Greaters = 700pp
Level 1 : 518 pp
Level 2 : 906 pp
Level 3 : 1725 pp
Level 4 : 3100 pp
Level 5 : 5745 pp

if Lessers = 100pp, Greaters = 500pp
Level 1 : 370 pp
Level 2 : 647 pp
Level 3 : 1232 pp
Level 4 : 2214 pp
Level 5 : 4104 pp

cdbd3rd
06-05-2011, 08:34 AM
/Waited patiently.


That's a lot of work for a system that is still in flux.
I have a feeling things are gonna change dramatically once this next update hits and stuff goes Unbound. That also will have a serious impact on the essences market.


/Props for your work so far. I'll be watching...

;)

Kinerd
06-05-2011, 07:41 PM
Very nice! If I may make a suggestion to save you some headache in the future, if you use "code" tags and copy/paste your data from Excel (or presumably any other spreadsheet), it will automatically make well-ordered rows and columns for you. This also makes it easy to copy/paste back into Excel, and no more fiddling with underscores!

Combining my data with yours, I now have the following for chance of producing a greater essence:
Item - 34.4% +/- 4.5%
Shard - 35.7% +/- 7.7%

The shard ranges of lessers all match the previously found values, which is nice because it gives us a way of looking at the item range of lessers.

Level 1: Clearly a range of 1-3 with a slim chance at 4 and 5. Also of interest is that there is no recording of 2 greaters. This could be simply because there are very few high-end items that have only a level 1 deconstruction and no level >1 deconstruction available. There could also be something esoteric like "there cannot be more greaters than lessers produced", but that seems like an odd thing to program in.

Level 2: Looking at this, my guess is that the "high-end" factor is an alteration of the underlying distribution, perhaps as simple as 2d3 + 1 instead of 2d3, and in extreme cases 2d3 + 2 (hence the 8). This would mean that for any given high-end deconstruction, the crafter is not guaranteed an abnormal return. I think there is something more at play than simply "high-end = +1 to deconstruction", however, as I have many recordings of the lower limit of the normal distribution being produced by minimum level 10 items, which are certainly high-end enough to generate abnormal results. More data will show the way.

Level 5: It's very interesting to me that 7 greaters are possible. This could imply that rather than a high-end factor z of the form xdy + z, we're looking at the form z * (xdy). Looking at the numbers a little, the value of 4/3 gives the following, using normal rounding:


Level Max_L Max_G
1 4 1
2 8 3
3 16 4
4 27 5
5 56 7


Needs some refining, to be sure, but it has interesting correlations with the observed data.

Thanks! :)