The Wiki for Tale 4 is in read-only mode and is available for archival and reference purposes only. Please visit the current Tale 11 Wiki in the meantime.
If you have any issues with this Wiki, please post in #wiki-editing on Discord or contact Brad in-game.
Difference between revisions of "User:Aphenro/Vines/Tannin"
From A Tale in the Desert
< User:Aphenro | Vines
Jump to navigationJump to search| (44 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <i>This is a work in progress | + | <i>This is a work in progress. I'm still tracking the barrels and so far the numbers corroborate the formula.</i> |
<br> | <br> | ||
<br> | <br> | ||
| Line 8: | Line 8: | ||
[[Image:Tannin_Equation.GIF|Tannin Equation]] | [[Image:Tannin_Equation.GIF|Tannin Equation]] | ||
| − | + | Where:<br> | |
| + | T is the amount of tannin.<br> | ||
| + | C is the colour value of the grapes.<br> | ||
| + | K is the skin value of the grapes.<br> | ||
| + | ETD is the amount of Egypt time (in days) the wine has been in the barrel.<br> | ||
| − | Furthermore you won’t have to guess how long you have to wait for the tannin to develop. After | + | Alternate formula: |
| + | T=C*K/100*(1-2^(-ETD/21)) | ||
| + | |||
| + | From this you can see that the maximum tannin possible is the colour value multiplied by the skin value divided by 100. So when you pick with vines/grapes to use you must also look for a C phenome. Colour is just as important as skin! Having wine with a skin value of 300 but a colour value of 10 will only yield 30 tannin. But if you could <i>magically</i> take 100 points from skin and put them into colour the maximum tannin jumps to 220 (110 X 200 / 100). | ||
| + | |||
| + | Furthermore you won’t have to guess how long you have to wait for the tannin to develop. After 21 Egypt days (approximately a RL week) the wine in the barrel will have developed half its maximum tannin. If you can wait another 21 Egypt days that value will rise to 75% of maximum. | ||
| + | |||
| + | As you can see from the data below the formula predicts the actual very closely. The differences are probably attributable to some rounding issues between my spreadsheet and game. | ||
| + | <br> | ||
| + | <br> | ||
| + | |||
| + | ===Data=== | ||
| + | <br> | ||
| + | ====Test #1==== | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Vine !! Phenome !! Wine !! Hue !! Barrel | ||
| + | |- | ||
| + | | Tedra's Tannin|| align='center'| ACCKKKS|| Aphenro Tannin Test Alpha || align='center'| Red || align='center'| Alpha | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Acid !! Colour !! Grapes !! Quality !! Skin !! Sugar !! Vigor !! Max. Tannin !! | ||
| + | |- align='center' | ||
| + | | 55|| align='center'| 91|| align='center'| 37 || align='center'| 25 || align='center'| 132 || align='center'| 6 || align='center'| 1 || align='center'| 120.12 || <== Colour X Skin | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="2" cellspacing="1" | ||
| + | |- align='center' | ||
| + | ! Egypt Time !! Alcohol !! Sugar !! Tannin !! Acid !! Elapsed Time (ETD) !! Tannin Predicted !! Difference | ||
| + | |- align='center' | ||
| + | | Akhet IV-12 23:35|| align='center'| 0.0|| align='center'| 3.0 || align='center'| 0.0 || align='center'| 5.5 || align='center'| - || align='center'| - || align='center'| - | ||
| + | |- align='center' | ||
| + | | Akhet IV-14 04:50|| align='center'| 0.2|| align='center'| 2.9 || align='center'| 4.8 || align='center'| 5.5 || align='center'| 1.22 || align='center'| 4.7 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-15 12:35|| align='center'| 0.5|| align='center'| 2.7 || align='center'| 9.7 || align='center'| 5.5 || align='center'| 2.54 || align='center'| 9.7 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-17 02:40|| align='center'| 0.8|| align='center'| 2.6 || align='center'| 15.4 || align='center'| 5.5 || align='center'| 4.13 || align='center'| 15.3 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-18 02:30|| align='center'| 0.9|| align='center'| 2.5 || align='center'| 18.7 || align='center'| 5.5 || align='center'| 5.12 || align='center'| 18.7 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-20 16:05|| align='center'| 1.4|| align='center'| 2.3 || align='center'| 27.0 || align='center'| 5.5 || align='center'| 7.69 || align='center'| 26.9 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-23 15:10|| align='center'| 1.8|| align='center'| 2.1 || align='center'| 35.7 || align='center'| 5.5 || align='center'| 10.65 || align='center'| 35.6 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-26 06:10|| align='center'| 2.1|| align='center'| 1.9 || align='center'| 42.6 || align='center'| 5.5 || align='center'| 13.27 || align='center'| 42.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-29 00:26|| align='center'| 2.5|| align='center'| 1.7 || align='center'| 49.5 || align='center'| 5.5 || align='center'| 16.04 || align='center'| 49.4 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-5 09:55|| align='center'| 3.1|| align='center'| 1.4 || align='center'| 62.9 || align='center'| 5.5 || align='center'| 22.43 || align='center'| 62.8 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-9 16:15|| align='center'| 3.5|| align='center'| 1.2 || align='center'| 70.4 || align='center'| 5.5 || align='center'| 26.69 || align='center'| 70.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-12 07:40|| align='center'| 3.7|| align='center'| 1.1 || align='center'| 74.8 || align='center'| 5.5 || align='center'| 29.34 || align='center'| 74.5 || align='center'| 0.3 | ||
| + | |- align='center' | ||
| + | | Peret I-15 01:00|| align='center'| 3.9|| align='center'| 1.0 || align='center'| 78.6 || align='center'| 5.5 || align='center'| 32.06 || align='center'| 78.4 || align='center'| 0.2 | ||
| + | |- align='center' | ||
| + | | Peret I-17 13:20|| align='center'| 4.1|| align='center'| 0.9 || align='center'| 81.6 || align='center'| 5.5 || align='center'| 34.57 || align='center'| 81.7 || align='center'| -0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-22 23:10|| align='center'| 4.4|| align='center'| 0.8 || align='center'| 88.0 || align='center'| 5.5 || align='center'| 39.98 || align='center'| 88.0 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-25 11:10|| align='center'| 4.5|| align='center'| 0.7 || align='center'| 90.6 || align='center'| 5.5 || align='center'| 42.48 || align='center'| 90.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-28 09:05|| align='center'| 4.7|| align='center'| 0.6 || align='center'| 93.3 || align='center'| 5.5 || align='center'| 45.40 || align='center'| 93.3 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret II-1 01:05|| align='center'| 4.8|| align='center'| 0.6 || align='center'| 95.6 || align='center'| 5.5 || align='center'| 48.06 || align='center'| 95.5 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-3 17:30|| align='center'| 4.9|| align='center'| 0.5 || align='center'| 97.7 || align='center'| 5.5 || align='center'| 50.75 || align='center'| 97.6 || align='center'| 0.1 | ||
| + | |} | ||
| + | <br> | ||
| + | <br> | ||
| + | ====Test #2==== | ||
| + | {| border="1" cellpadding="2" cellspacing="1" | ||
| + | |- | ||
| + | ! Vine !! Phenome !! Wine !! Hue !! Barrel | ||
| + | |- | ||
| + | | Tedra's Tannin|| align='center'| ACCKKKS|| Aphenro Tannin Test Beta || align='center'| Red || align='center'| Beta | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Acid !! Colour !! Grapes !! Quality !! Skin !! Sugar !! Vigor !! Max. Tannin !! | ||
| + | |- align='center' | ||
| + | | 16|| align='center'| 32|| align='center'| 46 || align='center'| 16 || align='center'| 133 || align='center'| 11 || align='center'| 3 || align='center'| 42.56 || <== Colour X Skin | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="2" cellspacing="1" | ||
| + | |- align='center' | ||
| + | ! Egypt Time !! Alcohol !! Sugar !! Tannin !! Acid !! Elapsed Time (ETD) !! Tannin Predicted !! Difference | ||
| + | |- align='center' | ||
| + | | Akhet IV-12 23:50|| align='center'| 0.0|| align='center'| 5.5 || align='center'| 0.0 || align='center'| 1.6 || align='center'| - || align='center'| - || align='center'| - | ||
| + | |- align='center' | ||
| + | | Akhet IV-14 04:50|| align='center'| 0.4|| align='center'| 5.3 || align='center'| 1.7 || align='center'| 1.6 || align='center'| 1.21 || align='center'| 1.7 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-15 12:35|| align='center'| 0.9|| align='center'| 5.0 || align='center'| 3.4 || align='center'| 1.6 || align='center'| 2.53 || align='center'| 3.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-17 02:40|| align='center'| 1.4|| align='center'| 4.8 || align='center'| 5.4 || align='center'| 1.6 || align='center'| 4.12 || align='center'| 5.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-18 02:30|| align='center'| 1.7|| align='center'| 4.5 || align='center'| 6.6 || align='center'| 1.6 || align='center'| 5.11 || align='center'| 6.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-20 16:05|| align='center'| 2.5|| align='center'| 4.2 || align='center'| 9.5 || align='center'| 1.6 || align='center'| 7.68 || align='center'| 9.5 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-23 15:10|| align='center'| 3.3|| align='center'| 3.8 || align='center'| 12.6 || align='center'| 1.6 || align='center'| 10.64 || align='center'| 12.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-26 06:10|| align='center'| 3.9|| align='center'| 3.5 || align='center'| 15.1 || align='center'| 1.6 || align='center'| 13.26 || align='center'| 15.1 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-29 00:26|| align='center'| 4.5|| align='center'| 3.2 || align='center'| 17.5 || align='center'| 1.6 || align='center'| 16.03 || align='center'| 17.5 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-5 09:55|| align='center'| 5.8|| align='center'| 2.6 || align='center'| 22.3 || align='center'| 1.6 || align='center'| 22.42 || align='center'| 22.3 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-9 16:15|| align='center'| 6.4|| align='center'| 2.3 || align='center'| 24.9 || align='center'| 1.6 || align='center'| 26.68 || align='center'| 24.9 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-12 07:40|| align='center'| 6.8|| align='center'| 2.1 || align='center'| 26.4 || align='center'| 1.6 || align='center'| 29.33 || align='center'| 26.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-15 01:00|| align='center'| 7.2|| align='center'| 1.9 || align='center'| 27.8 || align='center'| 1.6 || align='center'| 32.05 || align='center'| 27.8 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-17 13:20|| align='center'| 7.5|| align='center'| 1.7 || align='center'| 29.0 || align='center'| 1.6 || align='center'| 34.56 || align='center'| 29.0 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-22 23:10|| align='center'| 8.1|| align='center'| 1.4 || align='center'| 31.2 || align='center'| 1.6 || align='center'| 39.97 || align='center'| 31.2 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-25 11:10|| align='center'| 8.3|| align='center'| 1.3 || align='center'| 32.1 || align='center'| 1.6 || align='center'| 42.47 || align='center'| 32.1 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-28 09:05|| align='center'| 8.5|| align='center'| 1.2 || align='center'| 33.1 || align='center'| 1.6 || align='center'| 45.39 || align='center'| 33.0 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-1 01:05|| align='center'| 8.8|| align='center'| 1.1 || align='center'| 33.9 || align='center'| 1.6 || align='center'| 48.05 || align='center'| 33.8 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-3 17:30|| align='center'| 8.9|| align='center'| 1.0 || align='center'| 34.6 || align='center'| 1.6 || align='center'| 50.74 || align='center'| 34.6 || align='center'| 0.0 | ||
| + | |} | ||
| + | <br> | ||
| + | <br> | ||
| + | |||
| + | ====Test #3==== | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Vine !! Phenome !! Wine !! Hue !! Barrel | ||
| + | |- | ||
| + | | Aphenro#4|| align='center'| KKKAC|| Aphenro Tannin Test Gamma || align='center'| Dark Red || align='center'| Gamma | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Acid !! Colour !! Grapes !! Quality !! Skin !! Sugar !! Vigor !! Max. Tannin !! | ||
| + | |- align='center' | ||
| + | | 75|| align='center'| 82|| align='center'| 51 || align='center'| 30 || align='center'| 229 || align='center'| 35 || align='center'| 2 || align='center'| 187.78 || <== Colour X Skin | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="2" cellspacing="1" | ||
| + | |- align='center' | ||
| + | ! Egypt Time !! Alcohol !! Sugar !! Tannin !! Acid !! Elapsed Time (ETD) !! Tannin Predicted !! Difference | ||
| + | |- align='center' | ||
| + | | Akhet IV-15 12:20|| align='center'| 0.0|| align='center'| 17.5 || align='center'| 0.0 || align='center'| 7.5 || align='center'| - || align='center'| - || align='center'| - | ||
| + | |- align='center' | ||
| + | | Akhet IV-17 02:40|| align='center'| 1.8|| align='center'| 16.6 || align='center'| 9.6 || align='center'| 7.5 || align='center'| 1.60 || align='center'| 9.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-18 02:30|| align='center'| 2.9|| align='center'| 16.0 || align='center'| 15.4 || align='center'| 7.5 || align='center'| 2.59 || align='center'| 15.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-20 16:05|| align='center'| 5.5|| align='center'| 14.7 || align='center'| 29.5 || align='center'| 7.5 || align='center'| 5.16 || align='center'| 29.4 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-23 15:10|| align='center'| 8.2|| align='center'| 13.4 || align='center'| 44.1 || align='center'| 7.5 || align='center'| 8.12 || align='center'| 44.1 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-26 06:10|| align='center'| 10.5|| align='center'| 12.2 || align='center'| 56.1 || align='center'| 7.5 || align='center'| 10.74 || align='center'| 56.1 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-29 00:26|| align='center'| 11.6|| align='center'| 11.7 || align='center'| 67.6 || align='center'| 7.5 || align='center'| 13.50 || align='center'| 67.5 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-5 09:55|| align='center'| 11.9|| align='center'| 11.5 || align='center'| 90.5 || align='center'| 7.5 || align='center'| 19.90 || align='center'| 90.4 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-9 16:15|| align='center'| 12.1|| align='center'| 11.4 || align='center'| 103.3 || align='center'| 7.5 || align='center'| 24.16 || align='center'| 103.2 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-12 07:40|| align='center'| 12.2|| align='center'| 11.4 || align='center'| 110.2 || align='center'| 7.5 || align='center'| 26.81 || align='center'| 110.3 || align='center'| -0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-15 01:00|| align='center'| 12.3|| align='center'| 11.3 || align='center'| 117.0 || align='center'| 7.5 || align='center'| 29.53 || align='center'| 116.9 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-17 13:20|| align='center'| 12.3|| align='center'| 11.3 || align='center'| 122.6 || align='center'| 7.5 || align='center'| 32.04 || align='center'| 122.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-22 23:10|| align='center'| 12.5|| align='center'| 11.2 || align='center'| 133.3 || align='center'| 7.5 || align='center'| 37.45 || align='center'| 133.2 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-25 11:10|| align='center'| 12.5|| align='center'| 11.2 || align='center'| 137.6 || align='center'| 7.5 || align='center'| 39.95 || align='center'| 137.6 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-28 09:05|| align='center'| 12.6|| align='center'| 11.2 || align='center'| 142.1 || align='center'| 7.5 || align='center'| 42.86 || align='center'| 142.2 || align='center'| -0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-1 01:05|| align='center'| 12.6|| align='center'| 11.2 || align='center'| 146.1 || align='center'| 7.5 || align='center'| 45.53 || align='center'| 146.0 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-3 17:30|| align='center'| 12.7|| align='center'| 11.1 || align='center'| 149.7 || align='center'| 7.5 || align='center'| 48.22 || align='center'| 149.5 || align='center'| 0.2 | ||
| + | |} | ||
| + | <br> | ||
| + | <br> | ||
| + | ====Test #4==== | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Vine !! Phenome !! Wine !! Hue !! Barrel | ||
| + | |- | ||
| + | | Aphenro's Q Ball|| align='center'| ACGKQQSV|| Aphenro Tannin Test Delta || align='center'| White || align='center'| Delta | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="5" cellspacing="1" | ||
| + | |- | ||
| + | ! Acid !! Colour !! Grapes !! Quality !! Skin !! Sugar !! Vigor !! Max. Tannin !! | ||
| + | |- align='center' | ||
| + | | 123|| align='center'| 98|| align='center'| 179 || align='center'| 190 || align='center'| 38 || align='center'| 103 || align='center'| 3 || align='center'| 37.24 || <== Colour X Skin | ||
| + | |} | ||
| + | <br> | ||
| + | {| border="1" cellpadding="2" cellspacing="1" | ||
| + | |- align='center' | ||
| + | ! Egypt Time !! Alcohol !! Sugar !! Tannin !! Acid !! Elapsed Time (ETD) !! Tannin Predicted !! Difference | ||
| + | |- align='center' | ||
| + | | Akhet IV-18 08:45|| align='center'| 0.0|| align='center'| 51.5 || align='center'| 0.0 || align='center'| 12.3 || align='center'| - || align='center'| - || align='center'| - | ||
| + | |- align='center' | ||
| + | | Akhet IV-20 16:05|| align='center'| 7.6|| align='center'| 47.7 || align='center'| 2.8 || align='center'| 12.3 || align='center'| 2.31 || align='center'| 2.7 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Akhet IV-23 15:10|| align='center'| 10.7|| align='center'| 46.1 || align='center'| 5.9 || align='center'| 12.3 || align='center'| 5.27 || align='center'| 5.9 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-26 06:10|| align='center'| 11.1|| align='center'| 45.9 || align='center'| 8.5 || align='center'| 12.3 || align='center'| 7.89 || align='center'| 8.5 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Akhet IV-29 00:26|| align='center'| 11.3|| align='center'| 45.8 || align='center'| 11.1 || align='center'| 12.3 || align='center'| 10.65 || align='center'| 11.0 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-5 09:55|| align='center'| 11.8|| align='center'| 45.6 || align='center'| 16.1 || align='center'| 12.3 || align='center'| 17.05 || align='center'| 16.0 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-9 16:15|| align='center'| 12.0|| align='center'| 45.5 || align='center'| 18.8 || align='center'| 12.3 || align='center'| 21.31 || align='center'| 18.8 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-12 07:40|| align='center'| 12.1|| align='center'| 45.4 || align='center'| 20.4 || align='center'| 12.3 || align='center'| 23.95 || align='center'| 20.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-15 01:00|| align='center'| 12.2|| align='center'| 45.4 || align='center'| 21.8 || align='center'| 12.3 || align='center'| 26.68 || align='center'| 21.8 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-17 13:20|| align='center'| 12.2|| align='center'| 45.4 || align='center'| 23.1 || align='center'| 12.3 || align='center'| 29.19 || align='center'| 23.0 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret I-22 23:10|| align='center'| 12.4|| align='center'| 45.3 || align='center'| 25.4 || align='center'| 12.3 || align='center'| 34.60 || align='center'| 25.4 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-25 11:10|| align='center'| 12.5|| align='center'| 45.2 || align='center'| 26.3 || align='center'| 12.3 || align='center'| 37.10 || align='center'| 26.3 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret I-28 09:05|| align='center'| 12.5|| align='center'| 45.2 || align='center'| 27.3 || align='center'| 12.3 || align='center'| 40.01 || align='center'| 27.3 || align='center'| 0.0 | ||
| + | |- align='center' | ||
| + | | Peret II-1 01:05|| align='center'| 12.6|| align='center'| 45.2 || align='center'| 28.2 || align='center'| 12.3 || align='center'| 42.68 || align='center'| 28.1 || align='center'| 0.1 | ||
| + | |- align='center' | ||
| + | | Peret II-3 17:30|| align='center'| 12.6|| align='center'| 45.2 || align='center'| 28.9 || align='center'| 12.3 || align='center'| 45.36 || align='center'| 28.9 || align='center'| 0.0 | ||
| + | |} | ||
| + | <br> | ||
| + | <br> | ||
| + | ===What's Next=== | ||
| + | Track the barrels for a longer period of time. Does the formula continue on or does it switch at some point?<BR> | ||
| + | How is sugar converted into alcohol?<br> | ||
| + | Now that we know how to maximize tannin, what does 110 vs 100 tannin mean in the alembic? Is the extra tannin worth the time? Are there break points or is it smooth continuous? | ||
Latest revision as of 03:28, 13 November 2009
This is a work in progress. I'm still tracking the barrels and so far the numbers corroborate the formula.
Understanding Tannin
You’re an aspiring chemist and you want/need to make some Wood, Worm or Grain spirits in an alembic. Surfing through the wiki you read that you need wine with high tannin. You’ve got your grapes; you load them into the barrel and wait. Periodically you siphon off a sample and check the tannin level. Unfortunately the levels are not going up very fast. Wouldn’t it be nice to be able to predict which grapes will give the most tannin. Well now we can. As it turns out tannin is developed in wine from three characteristics, colour (C), skin (K) and patience (time). In fact the formula is relatively straight forward.
Where:
T is the amount of tannin.
C is the colour value of the grapes.
K is the skin value of the grapes.
ETD is the amount of Egypt time (in days) the wine has been in the barrel.
Alternate formula: T=C*K/100*(1-2^(-ETD/21))
From this you can see that the maximum tannin possible is the colour value multiplied by the skin value divided by 100. So when you pick with vines/grapes to use you must also look for a C phenome. Colour is just as important as skin! Having wine with a skin value of 300 but a colour value of 10 will only yield 30 tannin. But if you could magically take 100 points from skin and put them into colour the maximum tannin jumps to 220 (110 X 200 / 100).
Furthermore you won’t have to guess how long you have to wait for the tannin to develop. After 21 Egypt days (approximately a RL week) the wine in the barrel will have developed half its maximum tannin. If you can wait another 21 Egypt days that value will rise to 75% of maximum.
As you can see from the data below the formula predicts the actual very closely. The differences are probably attributable to some rounding issues between my spreadsheet and game.
Data
Test #1
| Vine | Phenome | Wine | Hue | Barrel |
|---|---|---|---|---|
| Tedra's Tannin | ACCKKKS | Aphenro Tannin Test Alpha | Red | Alpha |
| Acid | Colour | Grapes | Quality | Skin | Sugar | Vigor | Max. Tannin | |
|---|---|---|---|---|---|---|---|---|
| 55 | 91 | 37 | 25 | 132 | 6 | 1 | 120.12 | <== Colour X Skin |
| Egypt Time | Alcohol | Sugar | Tannin | Acid | Elapsed Time (ETD) | Tannin Predicted | Difference |
|---|---|---|---|---|---|---|---|
| Akhet IV-12 23:35 | 0.0 | 3.0 | 0.0 | 5.5 | - | - | - |
| Akhet IV-14 04:50 | 0.2 | 2.9 | 4.8 | 5.5 | 1.22 | 4.7 | 0.1 |
| Akhet IV-15 12:35 | 0.5 | 2.7 | 9.7 | 5.5 | 2.54 | 9.7 | 0.0 |
| Akhet IV-17 02:40 | 0.8 | 2.6 | 15.4 | 5.5 | 4.13 | 15.3 | 0.1 |
| Akhet IV-18 02:30 | 0.9 | 2.5 | 18.7 | 5.5 | 5.12 | 18.7 | 0.0 |
| Akhet IV-20 16:05 | 1.4 | 2.3 | 27.0 | 5.5 | 7.69 | 26.9 | 0.1 |
| Akhet IV-23 15:10 | 1.8 | 2.1 | 35.7 | 5.5 | 10.65 | 35.6 | 0.1 |
| Akhet IV-26 06:10 | 2.1 | 1.9 | 42.6 | 5.5 | 13.27 | 42.6 | 0.0 |
| Akhet IV-29 00:26 | 2.5 | 1.7 | 49.5 | 5.5 | 16.04 | 49.4 | 0.1 |
| Peret I-5 09:55 | 3.1 | 1.4 | 62.9 | 5.5 | 22.43 | 62.8 | 0.1 |
| Peret I-9 16:15 | 3.5 | 1.2 | 70.4 | 5.5 | 26.69 | 70.4 | 0.0 |
| Peret I-12 07:40 | 3.7 | 1.1 | 74.8 | 5.5 | 29.34 | 74.5 | 0.3 |
| Peret I-15 01:00 | 3.9 | 1.0 | 78.6 | 5.5 | 32.06 | 78.4 | 0.2 |
| Peret I-17 13:20 | 4.1 | 0.9 | 81.6 | 5.5 | 34.57 | 81.7 | -0.1 |
| Peret I-22 23:10 | 4.4 | 0.8 | 88.0 | 5.5 | 39.98 | 88.0 | 0.0 |
| Peret I-25 11:10 | 4.5 | 0.7 | 90.6 | 5.5 | 42.48 | 90.6 | 0.0 |
| Peret I-28 09:05 | 4.7 | 0.6 | 93.3 | 5.5 | 45.40 | 93.3 | 0.0 |
| Peret II-1 01:05 | 4.8 | 0.6 | 95.6 | 5.5 | 48.06 | 95.5 | 0.1 |
| Peret II-3 17:30 | 4.9 | 0.5 | 97.7 | 5.5 | 50.75 | 97.6 | 0.1 |
Test #2
| Vine | Phenome | Wine | Hue | Barrel |
|---|---|---|---|---|
| Tedra's Tannin | ACCKKKS | Aphenro Tannin Test Beta | Red | Beta |
| Acid | Colour | Grapes | Quality | Skin | Sugar | Vigor | Max. Tannin | |
|---|---|---|---|---|---|---|---|---|
| 16 | 32 | 46 | 16 | 133 | 11 | 3 | 42.56 | <== Colour X Skin |
| Egypt Time | Alcohol | Sugar | Tannin | Acid | Elapsed Time (ETD) | Tannin Predicted | Difference |
|---|---|---|---|---|---|---|---|
| Akhet IV-12 23:50 | 0.0 | 5.5 | 0.0 | 1.6 | - | - | - |
| Akhet IV-14 04:50 | 0.4 | 5.3 | 1.7 | 1.6 | 1.21 | 1.7 | 0.0 |
| Akhet IV-15 12:35 | 0.9 | 5.0 | 3.4 | 1.6 | 2.53 | 3.4 | 0.0 |
| Akhet IV-17 02:40 | 1.4 | 4.8 | 5.4 | 1.6 | 4.12 | 5.4 | 0.0 |
| Akhet IV-18 02:30 | 1.7 | 4.5 | 6.6 | 1.6 | 5.11 | 6.6 | 0.0 |
| Akhet IV-20 16:05 | 2.5 | 4.2 | 9.5 | 1.6 | 7.68 | 9.5 | 0.0 |
| Akhet IV-23 15:10 | 3.3 | 3.8 | 12.6 | 1.6 | 10.64 | 12.6 | 0.0 |
| Akhet IV-26 06:10 | 3.9 | 3.5 | 15.1 | 1.6 | 13.26 | 15.1 | 0.0 |
| Akhet IV-29 00:26 | 4.5 | 3.2 | 17.5 | 1.6 | 16.03 | 17.5 | 0.0 |
| Peret I-5 09:55 | 5.8 | 2.6 | 22.3 | 1.6 | 22.42 | 22.3 | 0.0 |
| Peret I-9 16:15 | 6.4 | 2.3 | 24.9 | 1.6 | 26.68 | 24.9 | 0.0 |
| Peret I-12 07:40 | 6.8 | 2.1 | 26.4 | 1.6 | 29.33 | 26.4 | 0.0 |
| Peret I-15 01:00 | 7.2 | 1.9 | 27.8 | 1.6 | 32.05 | 27.8 | 0.0 |
| Peret I-17 13:20 | 7.5 | 1.7 | 29.0 | 1.6 | 34.56 | 29.0 | 0.0 |
| Peret I-22 23:10 | 8.1 | 1.4 | 31.2 | 1.6 | 39.97 | 31.2 | 0.0 |
| Peret I-25 11:10 | 8.3 | 1.3 | 32.1 | 1.6 | 42.47 | 32.1 | 0.0 |
| Peret I-28 09:05 | 8.5 | 1.2 | 33.1 | 1.6 | 45.39 | 33.0 | 0.1 |
| Peret II-1 01:05 | 8.8 | 1.1 | 33.9 | 1.6 | 48.05 | 33.8 | 0.1 |
| Peret II-3 17:30 | 8.9 | 1.0 | 34.6 | 1.6 | 50.74 | 34.6 | 0.0 |
Test #3
| Vine | Phenome | Wine | Hue | Barrel |
|---|---|---|---|---|
| Aphenro#4 | KKKAC | Aphenro Tannin Test Gamma | Dark Red | Gamma |
| Acid | Colour | Grapes | Quality | Skin | Sugar | Vigor | Max. Tannin | |
|---|---|---|---|---|---|---|---|---|
| 75 | 82 | 51 | 30 | 229 | 35 | 2 | 187.78 | <== Colour X Skin |
| Egypt Time | Alcohol | Sugar | Tannin | Acid | Elapsed Time (ETD) | Tannin Predicted | Difference |
|---|---|---|---|---|---|---|---|
| Akhet IV-15 12:20 | 0.0 | 17.5 | 0.0 | 7.5 | - | - | - |
| Akhet IV-17 02:40 | 1.8 | 16.6 | 9.6 | 7.5 | 1.60 | 9.6 | 0.0 |
| Akhet IV-18 02:30 | 2.9 | 16.0 | 15.4 | 7.5 | 2.59 | 15.4 | 0.0 |
| Akhet IV-20 16:05 | 5.5 | 14.7 | 29.5 | 7.5 | 5.16 | 29.4 | 0.1 |
| Akhet IV-23 15:10 | 8.2 | 13.4 | 44.1 | 7.5 | 8.12 | 44.1 | 0.0 |
| Akhet IV-26 06:10 | 10.5 | 12.2 | 56.1 | 7.5 | 10.74 | 56.1 | 0.0 |
| Akhet IV-29 00:26 | 11.6 | 11.7 | 67.6 | 7.5 | 13.50 | 67.5 | 0.1 |
| Peret I-5 09:55 | 11.9 | 11.5 | 90.5 | 7.5 | 19.90 | 90.4 | 0.1 |
| Peret I-9 16:15 | 12.1 | 11.4 | 103.3 | 7.5 | 24.16 | 103.2 | 0.1 |
| Peret I-12 07:40 | 12.2 | 11.4 | 110.2 | 7.5 | 26.81 | 110.3 | -0.1 |
| Peret I-15 01:00 | 12.3 | 11.3 | 117.0 | 7.5 | 29.53 | 116.9 | 0.1 |
| Peret I-17 13:20 | 12.3 | 11.3 | 122.6 | 7.5 | 32.04 | 122.6 | 0.0 |
| Peret I-22 23:10 | 12.5 | 11.2 | 133.3 | 7.5 | 37.45 | 133.2 | 0.1 |
| Peret I-25 11:10 | 12.5 | 11.2 | 137.6 | 7.5 | 39.95 | 137.6 | 0.0 |
| Peret I-28 09:05 | 12.6 | 11.2 | 142.1 | 7.5 | 42.86 | 142.2 | -0.1 |
| Peret II-1 01:05 | 12.6 | 11.2 | 146.1 | 7.5 | 45.53 | 146.0 | 0.1 |
| Peret II-3 17:30 | 12.7 | 11.1 | 149.7 | 7.5 | 48.22 | 149.5 | 0.2 |
Test #4
| Vine | Phenome | Wine | Hue | Barrel |
|---|---|---|---|---|
| Aphenro's Q Ball | ACGKQQSV | Aphenro Tannin Test Delta | White | Delta |
| Acid | Colour | Grapes | Quality | Skin | Sugar | Vigor | Max. Tannin | |
|---|---|---|---|---|---|---|---|---|
| 123 | 98 | 179 | 190 | 38 | 103 | 3 | 37.24 | <== Colour X Skin |
| Egypt Time | Alcohol | Sugar | Tannin | Acid | Elapsed Time (ETD) | Tannin Predicted | Difference |
|---|---|---|---|---|---|---|---|
| Akhet IV-18 08:45 | 0.0 | 51.5 | 0.0 | 12.3 | - | - | - |
| Akhet IV-20 16:05 | 7.6 | 47.7 | 2.8 | 12.3 | 2.31 | 2.7 | 0.1 |
| Akhet IV-23 15:10 | 10.7 | 46.1 | 5.9 | 12.3 | 5.27 | 5.9 | 0.0 |
| Akhet IV-26 06:10 | 11.1 | 45.9 | 8.5 | 12.3 | 7.89 | 8.5 | 0.0 |
| Akhet IV-29 00:26 | 11.3 | 45.8 | 11.1 | 12.3 | 10.65 | 11.0 | 0.1 |
| Peret I-5 09:55 | 11.8 | 45.6 | 16.1 | 12.3 | 17.05 | 16.0 | 0.1 |
| Peret I-9 16:15 | 12.0 | 45.5 | 18.8 | 12.3 | 21.31 | 18.8 | 0.0 |
| Peret I-12 07:40 | 12.1 | 45.4 | 20.4 | 12.3 | 23.95 | 20.4 | 0.0 |
| Peret I-15 01:00 | 12.2 | 45.4 | 21.8 | 12.3 | 26.68 | 21.8 | 0.0 |
| Peret I-17 13:20 | 12.2 | 45.4 | 23.1 | 12.3 | 29.19 | 23.0 | 0.1 |
| Peret I-22 23:10 | 12.4 | 45.3 | 25.4 | 12.3 | 34.60 | 25.4 | 0.0 |
| Peret I-25 11:10 | 12.5 | 45.2 | 26.3 | 12.3 | 37.10 | 26.3 | 0.0 |
| Peret I-28 09:05 | 12.5 | 45.2 | 27.3 | 12.3 | 40.01 | 27.3 | 0.0 |
| Peret II-1 01:05 | 12.6 | 45.2 | 28.2 | 12.3 | 42.68 | 28.1 | 0.1 |
| Peret II-3 17:30 | 12.6 | 45.2 | 28.9 | 12.3 | 45.36 | 28.9 | 0.0 |
What's Next
Track the barrels for a longer period of time. Does the formula continue on or does it switch at some point?
How is sugar converted into alcohol?
Now that we know how to maximize tannin, what does 110 vs 100 tannin mean in the alembic? Is the extra tannin worth the time? Are there break points or is it smooth continuous?
