Goldbeater is one impossible equation.

[Xcom]

0.5 L water from the caldron is used per goldbeater skin.

[Xcom]

I just couldn't let this go and made even more calculations and experiments on the matter. I might have gotten more then 20 or so different random data from the experiments. I also spent hours trying to understand why it goes wrong in the formula. But at this point I give up specially after the latest result I got.

I used Q78 water with Q82 caldron and as we all know caldron and water results in water+caldron/2 giving = 80Q CaW

Using:
Q80 CaW
Q80 Intest
Q80 Vinegar

Goldbeater result Q79

All I know is that enough data proves to the fact that the equation works. Its only because of bad coding in the sense of bad integer rounding in the wrong places that rounds it down.

Updating the wiki with this eqaution.

Goldbeater = (intest * 10 + Vinegar * 5 + CaW * 3) / 18

[MagicManICT]

I used Q78 water with Q82 caldron and as we all know caldron and water results in water+caldron/2 giving = 80Q CaW

Where you get that information at?

[Xcom]

Multiple experiments using the caldron. HL, mussles and ofcourse the goldbeater. I did one or two foods to but I didn't make more then a few samples on those. The caldron seems to work the same way as a herbalist table works on items placed in it. The water is affected in similar ways.

(Caldron + Water ) / 2

I think it rounds it down afterwards but I haven't confirmed it fooly.

[ApocalypsePlease]

I think it rounds it down afterwards but I haven't confirmed it fooly.

Everything always rounds down (except debuffs, which round up). Your numbers aren't even consistent with the example you gave, undoing your edit until you can prove this formula working with different variances in qualities of all aspects.

[Xcom]

Because of the unknown integer rounding it wont be exact. I have a very large sample set that proves the formula is approximate to Q1+ in the positive region. But you wont ever be able to get the exact number because of the very odd rounding that happens behind the code. I have gone through the stuff over 20 times and cant really find the correct way it integer rounds.

Although its not very very accurate its accurate enough for people to use to figure out roughly what Q they will get. I also added that its approximate and that it sometimes rounds it down.

Here is also a very large sample set to back it up. Let me just point out the few interesting results as well in this list.

All the calculations that have a even result always gets rounded down while other figures that have a bit higher Q in the decimal figures always stays the same. For a very long time it confused me till a friend that does a bit of programing suggested the idea of the game using rounded numbers to calculate the formula. If you use rounded multipliers in the equation most of these numbers line up. A few still stays offset. Its very much possible that there is a bad rounding event in the code that throws of everything off and rounds it down by 1. But the overall equation is correct if it wasn't it won't be possible to get 20+ samples to come out accurate enough by 1 Q.

By that I mean. It uses a approximate calculation.
CaW = 3/18 = 0.166666 > .166
Vinegar = 5/18 = .27777777 > .277
Intest = 10/18 = .55555555 > .555

Now you can sit here and nitpick the figures below till you find the exact rounded figures and have everything line up perfectly but I certainly will tell you right now that its a total waste of time as I haven't figured out the exact figure after spending hours on hours on this. 1Q in the plus region variance isn't very large to be complaining about.

Water Caldron CaW Vingegar Intestens Goldbeater Appximate Calc Offset
30 82 56 140 36 67 68.22 1
30 82 56 140 40 70 70.44 0
30 82 56 140 43 71 72.11 1
30 82 56 140 44 72 72.67 0
30 82 56 140 50 75 76.00 1
30 82 56 140 53 77 77.67 0

30 82 56 21 43 38 39.06 1
30 82 56 21 44 39 39.61 0
30 82 56 80 44 55 56.00 1

10 82 46 140 43 70 70.44 0
10 82 46 140 44 70 71.00 1
60 82 71 140 44 75 75.17 0

30 11 20 140 44 66 66.67 0

22 82 52 50 53 51 52.00 1

39 78 58 114 34 59 60.22 1

30 82 56 150 46 75 76.56 1
30 82 56 150 57 82 82.67 0
30 82 56 150 53 80 80.44 0
30 82 56 150 50 78 78.78 0
30 82 56 150 39 72 72.67 0
30 82 56 150 36 70 71.00 1
30 82 56 150 35 70 70.44 0
30 82 56 11 46 37 37.94 0
30 82 56 11 57 43 44.06 1
30 82 56 11 53 41 41.83 0
30 82 56 11 50 40 40.17 0
30 82 56 11 39 33 34.06 1
30 82 56 11 36 31 32.39 1
30 82 56 11 35 31 31.83 0
30 82 56 80 80 75 76.00 1
78 82 80 80 80 79 80.00 1
56 56 56 55 57 55 56.28 1
56 56 56 90 39 55 56.00 1

[mvgulik]

Now you can sit here and nitpick the figures below till you find the exact rounded figures and have everything line up perfectly but I certainly will tell you right now that its a total waste of time as I haven't figured out the exact figure after spending hours on hours on this. 1Q in the plus region variance isn't very large to be complaining about.

Sigh ... good way to kill your own topic in my view.
Anyway, there is still something that needs to be solved in relation to the clay(only?) cauldron. (getting the same odd results on boneglue items.)

[Xcom]

Now you can sit here and nitpick the figures below till you find the exact rounded figures and have everything line up perfectly but I certainly will tell you right now that its a total waste of time as I haven't figured out the exact figure after spending hours on hours on this. 1Q in the plus region variance isn't very large to be complaining about.

Sigh ... good way to kill your own topic in my view.
Anyway, there is still something that needs to be solved in relation to the clay(only?) cauldron. (getting the same odd results on boneglue items.)

Very true but the only person who can answer to how this formula works behind the seen is jorb himself. After looking at the results for hours I just have come to the conclusion that there is so many different variations of roundings that jorb could have taken that it makes it a endless task to figure out.

I have tried rounding it individually, grouping the materials, rounded them up and down, regular roundings, adding constants, doubted my results and wasted more resources to double check the outcomes and simply given up at the end after weeks of attempts. If what I have come up with isn't enough then please go ahead and try it out yourself. We wont have a formula for the goldbeater or any formula till the end of W6 or any world cause I am convinced it's just a waste of anyones time figuring out if the formula is 1Q higher then the end result 20% of the time. If Jorb wont answer this I don't think anyone will ever bother spending this much time as I have to figure it out.

I'm not a mathematician so if you are one please have a go at it. Until we get the exact figure of the exact formula I think the wiki should at least have the inaccurate equation as its all we have right now as its better then having nothing at all.

But one thing I'm sure of is that caldron and water are grouped together. I have data and can supply it if need be that the caldron and water behave as shown below.

Q56 water and Q56 caldron behave exactly the same way as Q30 water and Q82 caldron. I actually painstakingly built a caldron of that exact Q and mixed water to get that exact mixture to try several experiments to see if the 2 different caldrons and there respective waters gave the same results and they did.

( Water + Caldron ) / 2 = CaW
(56 + 56) / 2 = 56
(30 + 82) / 2 = 56

[mvgulik]

Until we get the exact figure of the exact formula I think the wiki should at least have the inaccurate equation as its all we have right now as its better then having nothing at all.

I have no problem with having a approximation formula on the wiki. But its place is on the talk page at best.

But one thing I'm sure of is that caldron and water are grouped together. I have data and can supply it if need be that the caldron and water behave as shown below.

I think its would be good idea to drop whatever data you like to share. (here, or on a wiki talk page or your personal wiki page.)
Not to personally proof something. But so others can take a look at it with a fresh mind and pick up where you ended. ... That's how the Grape-press got solved. With Rook picking up where I left off.

Q56 water and Q56 caldron behave exactly the same way as Q30 water and Q82 caldron. I actually painstakingly built a caldron of that exact Q and mixed water to get that exact mixture to try several experiments to see if the 2 different caldrons and there respective waters gave the same results and they did.

Thanks for that. I think that's useful information.

(Just remember that others can't see the effort you put into something based on just the final results. As such the background work that was put into something is always taken for granted. ...)

[Xcom]

I would gladly do a few experiments on the caldron and water for reassurance and see to that its 100% accurate. I guess I can do that next, its just that I always assumed that others knew this and I just took it for granted. It shouldn't be to hard.