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
Jump to navigationJump to search
(New page: <p class=MsoNormal>You’re an aspiring chemist and you want/need to make some <span lang=EN style='mso-ansi-language:EN'>Wood, Worm or Grain spirits in an alembic. Surfing through the wik...)
 
 
(55 intermediate revisions by the same user not shown)
Line 1: Line 1:
<p class=MsoNormal>You’re an aspiring chemist and you want/need to make some <span
+
<i>This is a work in progress. I'm still tracking the barrels and so far the numbers corroborate the formula.</i>
lang=EN style='mso-ansi-language:EN'>Wood, Worm or Grain spirits in an alembic.
+
<br>
Surfing through the wiki you read that you need wine with high tannin. You’ve
+
<br>
got your grapes; you load them into the barrel and wait.<span
+
==Understanding Tannin==
style='mso-spacerun:yes'>  </span>Periodically you siphon off a sample and
 
check the tannin level. Unfortunately the levels are not going up very
 
fast.<span style='mso-spacerun:yes'>  </span>Wouldn’t it be nice to be able to
 
predict which grapes will give the most <span class=GramE>tannin.</span> 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 <i style='mso-bidi-font-style:normal'>relatively</i> straight forward.<o:p></o:p></span></p>
 
  
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><o:p>&nbsp;</o:p></span></p>
+
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 <i>relatively</i> straight forward.
  
<p class=MsoNormal><span style='font-size:14.0pt'><sub><!--[if gte vml 1]><v:shapetype
+
[[Image:Tannin_Equation.GIF|Tannin Equation]]
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
 
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 
<v:stroke joinstyle="miter"/>
 
<v:formulas>
 
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
 
  <v:f eqn="sum @0 1 0"/>
 
  <v:f eqn="sum 0 0 @1"/>
 
  <v:f eqn="prod @2 1 2"/>
 
  <v:f eqn="prod @3 21600 pixelWidth"/>
 
  <v:f eqn="prod @3 21600 pixelHeight"/>
 
  <v:f eqn="sum @0 0 1"/>
 
  <v:f eqn="prod @6 1 2"/>
 
  <v:f eqn="prod @7 21600 pixelWidth"/>
 
  <v:f eqn="sum @8 21600 0"/>
 
  <v:f eqn="prod @7 21600 pixelHeight"/>
 
  <v:f eqn="sum @10 21600 0"/>
 
</v:formulas>
 
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 
<o:lock v:ext="edit" aspectratio="t"/>
 
</v:shapetype><v:shape id="_x0000_i1048" type="#_x0000_t75" style='width:129.75pt;
 
height:46.5pt' o:ole="">
 
<v:imagedata src="Understanding%20Tannin_files/image001.wmz" o:title=""/>
 
</v:shape><![endif]--><![if !vml]><img width=173 height=62
 
src="Understanding%20Tannin_files/image002.gif" v:shapes="_x0000_i1048"><![endif]></sub><!--[if gte mso 9]><xml>
 
<o:OLEObject Type="Embed" ProgID="Equation.3" ShapeID="_x0000_i1048"
 
  DrawAspect="Content" ObjectID="_1317107464">
 
</o:OLEObject>
 
</xml><![endif]--></span></p>
 
  
<p class=MsoNormal>Where:</p>
+
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>
  
<p class=MsoNormal>T is the amount of tannin.</p>
+
Alternate formula:
 +
T=C*K/100*(1-2^(-ETD/21))
  
<p class=MsoNormal>C is the colour value of the grapes.</p>
+
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).
  
<p class=MsoNormal>K is the skin value of the grapes.</p>
+
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.
  
<p class=MsoNormal>ETD is the amount of <st1:place w:st="on"><st1:country-region
+
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.
w:st="on">Egypt</st1:country-region></st1:place> time (in days) the wine has
+
<br>
been in the barrel.</p>
+
<br>  
  
<p class=MsoNormal><o:p>&nbsp;</o:p></p>
+
===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 !! &nbsp;
 +
|- 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 !! &nbsp;
 +
|- 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>
  
<p class=MsoNormal>From this you can see that the maximum tannin possible is
+
====Test #3====
the colour value multiplied by the skin value divided by 100.<span
+
{| border="1" cellpadding="5" cellspacing="1"
style='mso-spacerun:yes'>  </span>So when you pick with vines to use you must
+
|-
also look for a C <span class=SpellE>phenome</span>. Colour is just as
+
! Vine !! Phenome !! Wine !! Hue !! Barrel
important as skin! Having wine with a skin value of 300 but a colour value of
+
|-
10 will only yield <span class=GramE>30 tannin</span>. But if you could take
+
| Aphenro#4|| align='center'| KKKAC|| Aphenro Tannin Test Gamma || align='center'| Dark Red || align='center'| Gamma
100 points from skin and put that into colour the maximum tannin jumps to 220
+
|}
(110 X 200 / 100). </p>
+
<br>
 +
{| border="1" cellpadding="5" cellspacing="1"
 +
|-
 +
! Acid !! Colour !! Grapes !! Quality !! Skin !! Sugar !! Vigor !! Max. Tannin !! &nbsp;
 +
|- 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 !! &nbsp;
 +
|- 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.

Tannin Equation

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?