Data Mining

[Xcom]

So I decided to add some nifty features to the regular mining script I use to get some statistics. The miner basically digs nodes out by making sure it will stop digging into tiles that have no ore. By adding a simple counter I could calculate the amount of ore each tile gives. The features could give the count of how many tiles gave nothing at all and how much by average each ore tile can provide ore.



Below is a list of data summery of a few mining events.

Tiles are the total tiles mined.
Stone tiles are the tiles that ends up leaving a stone tile where the miner is mining.
Dub tiles basically give nothing, neither ore or stone.
Ore count is the total counted ore during the mining.

Code: Select all

Tiles : 1358   Stone Tiles: 160    Dub Count: 234    Total Ore Count: 3779
Tiles : 622   Stone Tiles: 74    Dub Count: 127    Total Ore Count: 1682
Tiles : 133   Stone Tiles: 8    Dub Count: 21    Total Ore Count: 435
Tiles : 1499   Stone Tiles: 119    Dub Count: 279    Total Ore Count: 4424
Tiles : 1911   Stone Tiles: 171    Dub Count: 335    Total Ore Count: 5630
Tiles : 1744   Stone Tiles: 150    Dub Count: 316    Total Ore Count: 5123
Tiles : 485   Stone Tiles: 69    Dub Count: 86    Total Ore Count: 1355

Summation
Tiles : 7752
Stone Tiles: 751
Dub Count: 1398
Total Ore Count: 22428

Math:

Ore tiles: 7752 - 751 - 1398 = 5603

Position stone to ore tiles: 751 / 5603 = 13.4%

Proportion dub tiles are stone: 0.13403533821167231840085668391933 * 1398 = 187 void tiles counted as stone tiles.

Proportion dub tiles are ore: 1398 - 187 = 1211 dub tiles counted as ore.

Total ore tiles: 5603 + 1211 = 6814

Ore per tile: 3.29

You get on average 3.3 ore per tile when mining a cast iron vain. Using this basic logic it means you need on average 1.51 tiles to get 1 bar of any metal, 3.79 tiles to get 1 wrought iron bar, 7.57 tiles per 1 gold nugget and 3.79 tiles for 1 silver nugget.

The basic math can be a bit off but it shows how much on average mining can provide.

Just to note. These experiments were done on cast iron and might differ on other types or ore or other levels. But more then likely the same line of code is used through all levels and all types of ore so the math should be the same throughout levels or ore types.

[Xcom]

I also did some more data on drying times for different items through haven.

These are items in herbalist tables.

First its the name of the item, second is the % and last is the time in seconds from when the test was started.

Code: Select all

Item: gfx/invobjs/herbs/windweed :  0% : 0
Item: gfx/invobjs/tea-fresh :  1% : 24
Item: gfx/invobjs/tea-fresh :  2% : 49
Item: gfx/invobjs/tea-fresh :  3% : 67
Item: gfx/invobjs/tea-fresh :  4% : 91
Item: gfx/invobjs/herbs/windweed :  1% : 91
Item: gfx/invobjs/tea-fresh :  5% : 116
Item: gfx/invobjs/tea-fresh :  6% : 140
Item: gfx/invobjs/tea-fresh :  7% : 165
Item: gfx/invobjs/tea-fresh :  8% : 189
Item: gfx/invobjs/herbs/windweed :  2% : 189
Item: gfx/invobjs/tea-fresh :  9% : 213
Item: gfx/invobjs/tea-fresh :  10% : 239
Item: gfx/invobjs/tea-fresh :  11% : 264
Item: gfx/invobjs/tea-fresh :  12% : 288
Item: gfx/invobjs/herbs/windweed :  3% : 288
Item: gfx/invobjs/tea-fresh :  13% : 313
Item: gfx/invobjs/tea-fresh :  14% : 331
Item: gfx/invobjs/tea-fresh :  15% : 355
Item: gfx/invobjs/tea-fresh :  16% : 380
Item: gfx/invobjs/herbs/windweed :  4% : 380
Item: gfx/invobjs/tea-fresh :  17% : 405
Item: gfx/invobjs/tea-fresh :  18% : 430
Item: gfx/invobjs/tea-fresh :  19% : 454
Item: gfx/invobjs/tea-fresh :  20% : 478
Item: gfx/invobjs/herbs/windweed :  5% : 478
Item: gfx/invobjs/tea-fresh :  21% : 503
Item: gfx/invobjs/tea-fresh :  22% : 527
Item: gfx/invobjs/tea-fresh :  23% : 552
Item: gfx/invobjs/tea-green :  1% : 576
Item: gfx/invobjs/tea-fresh :  24% : 576
Item: gfx/invobjs/seed-wheat :  1% : 576
Item: gfx/invobjs/grapes :  1% : 576

Above is some raw data but this is the interesting points.

Code: Select all

Item: gfx/invobjs/tobacco-fresh :  2% : 2881
Item: gfx/invobjs/seed-pepper-boiled :  2% : 2881
Item: gfx/invobjs/tea-green :  5% : 2881
Item: gfx/invobjs/hemp-fresh :  2% : 2881
Item: gfx/invobjs/seed-wheat :  5% : 2881
Item: gfx/invobjs/grapes :  5% : 2881
Item: gfx/invobjs/herbs/windweed :  30% : 2881

From that you can calculate the exact time each type takes to dry.

I did also make similar calculations on cheese types. The code below shows the time it took to get the percentages on Milben.

Code: Select all

Item: gfx/invobjs/cheese-tray-cheese :  1% : 8063
Item: gfx/invobjs/cheese-tray-cheese :  2% : 16127
Item: gfx/invobjs/cheese-tray-cheese :  3% : 24190

From that I have updated the wiki. 2 types of cheese haven't been updated yet though.
http://ringofbrodgar.com/wiki/Cheese#Maturation_time
http://ringofbrodgar.com/wiki/Herbalist_Table

Late on will be able to add them into the Apoc Lite client when time allows so the timers show up similar to curios, counting down that is.


Mods feel free to lock this thread as it was only intended for the wiki.

[kret1337]

Great job m8

[Xcom]

For science

[Zachary09]

Xcom you really deserve an audience reward for this kind of sacrifice for the entire community