Some preliminary findings:
This is why I was able to "predict" the results after the fact, by changing the alcohol contributed by each yeast in the spreadsheet until the flavor numbers added up to more or less the observed results. In other words, I don't yet know the rules that would allow me to predict the results before I make the beer, but I can make the spreadsheet numbers match the finished beer results pretty closely afterwards by playing with the alcohol that each yeast contributes until the flavors match.
Note: You may notice that my estimates for the flavor amounts generated by each yeast don't always add up exactly to the numbers on the "Totals:" line. This is partly because the numbers were taken directly from my spreadsheet and sometimes they round up or down. Rounding issues with the yeast stats (and perhaps imprecise yeast stats) probably also affect how closely my estimates match the actual beer results. Given these limitations, I got as close to an accurate estimate of the alcohol contribution by each yeast as I could.
Recipe: 140 Honey @ 24; 35 Light Malt @ 1176
| Location: | 878, -3376 | Yeasts: | Y8 / Y51 | Sealed at: | 550 | ||
| Y8 MaxAlc: | 992 | Glucose Floor: | 13 | Maltose Floor: | 12 | VitFloor: | 71 |
| Y51 MaxAlc: | 755 | Glucose Floor: | 3 | Maltose Floor: | 173 | VitFloor: | 171 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 755 | 8 | 56 | 11 | 27 | 8 | 8 | 58 | ||||||||
| 2nd Yeast (estimated): | 129 | 39 | 1 | 2 | 2 | 5 | 3 | 2 | ||||||||
| Totals: | 884 | 52 | 494 | 586 | 350 | 207 | 47 | 57 | 13 | 30 | 2018 | 14 | 11 | 103 | 62 | 60 |
| Actual Results: | 884 | 52 | 495 | 586 | 350 | 207 | 47 | 56 | 12 | 29 | 2018 | 14 | 10 | 103 | 61 | 59 |
Recipe: 35 Honey @ 1176; 50 Light Malt @ 1176; 20 Medium Malt @ 24
| Location: | 878, -3376 | Yeasts: | Y8 / Y51 | Sealed at: | 550 | ||
| Y8 MaxAlc: | 992 | Glucose Floor: | 13 | Maltose Floor: | 12 | VitFloor: | 71 |
| Y51 MaxAlc: | 755 | Glucose Floor: | 3 | Maltose Floor: | 173 | VitFloor: | 171 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 755 | 8 | 56 | 11 | 27 | 8 | 8 | 58 | ||||||||
| 2nd Yeast (estimated): | 129 | 39 | 1 | 2 | 2 | 5 | 3 | 2 | ||||||||
| Totals: | 884 | 85 | 651 | 3 | 303 | 317 | 47 | 57 | 13 | 30 | 52 | 14 | 11 | 155 | 84 | 60 |
| Actual Results: | 884 | 85 | 652 | 3 | 303 | 317 | 47 | 56 | 12 | 29 | 52 | 14 | 10 | 155 | 83 | 59 |
Recipe: 35 Honey @ 1176; 50 Light Malt @ 1176; 20 Medium Malt @ 24
| Location: | 878, -3376 | Yeasts: | Y8 / Y51 | Sealed at: | 544 | ||
| Y8 MaxAlc: | 992 | Glucose Floor: | 13 | Maltose Floor: | 12 | VitFloor: | 66 |
| Y51 MaxAlc: | 755 | Glucose Floor: | 3 | Maltose Floor: | 173 | VitFloor: | 171 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 757 | 8 | 56 | 11 | 27 | 8 | 8 | 58 | ||||||||
| 2nd Yeast (estimated): | 127 | 38 | 1 | 2 | 2 | 5 | 3 | 2 | ||||||||
| Totals: | 884 | 85 | 650 | 3 | 303 | 317 | 47 | 57 | 13 | 30 | 51 | 14 | 11 | 155 | 84 | 60 |
| Actual Results: | 884 | 85 | 652 | 3 | 303 | 317 | 47 | 56 | 12 | 29 | 52 | 14 | 10 | 155 | 83 | 59 |
Recipe: 80 Honey, 30 Medium Malt @ 1176
| Location: | 1012, -3269 | Yeasts: | Y75 / Y58 | Sealed at: | 1300 | ||
| Y75 MaxAlc: | 1421 | Glucose Floor: | 13 | Maltose Floor: | 192 | VitFloor: | 88 |
| Y58 MaxAlc: | 866 | Glucose Floor: | 6 | Maltose Floor: | 228 | VitFloor: | 4 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Banana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| Y75 (estimated): | 955 | 27 | 30 | 14 | 14 | 25 | 30 | 19 | ||||||||
| Y58 (estimated): | 7 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||||
| Total Predicted: | 962 | 89 | 58 | 6 | 192 | 177 | 27 | 30 | 14 | 14 | 92 | 25 | 30 | 59 | 96 | 19 |
| Actual Results: | 962 | 89 | 59 | 6 | 192 | 177 | 28 | 30 | 14 | 14 | 92 | 25 | 30 | 59 | 96 | 19 |
Recipe: 70 Honey, 40 Dark Malt @ 1176
| Location: | 1012, -3720 | Yeasts: | Y75 / Y58 | Sealed at: | 1400 | ||
| Y75 MaxAlc: | 1421 | Glucose Floor: | 13 | Maltose Floor: | 192 | VitFloor: | 88 |
| Y58 MaxAlc: | 866 | Glucose Floor: | 6 | Maltose Floor: | 228 | VitFloor: | 4 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Banana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| Y75 (estimated): | 719 | 20 | 22 | 10 | 10 | 19 | 22 | 14 | ||||||||
| Y58 (estimated): | 227 | 20 | 10 | 7 | 6 | 18 | 3 | 7 | ||||||||
| Total Predicted: | 946 | 236 | 62 | 6 | 228 | 236 | 40 | 32 | 18 | 16 | 86 | 37 | 25 | 59 | 75 | 21 |
| Actual Results: | 946 | 236 | 64 | 6 | 228 | 236 | 42 | 33 | 17 | 16 | 85 | 36 | 24 | 59 | 74 | 21 |
Recipe: 60 Honey @ 1176; 10 Light Malt @ 24; 40 Dark Malt @ 1176
| Location: | 1012, -3269 | Yeasts: | Y75 / Y58 | Sealed at: | 1200 | ||
| Y75 MaxAlc: | 980 | Glucose Floor: | 13 | Maltose Floor: | 192 | VitFloor: | 87 |
| Y58 MaxAlc: | 1026 | Glucose Floor: | 6 | Maltose Floor: | 25 | VitFloor: | 55 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 980 | 26 | 30 | 14 | 14 | 25 | 30 | 20 | ||||||||
| 2nd Yeast (estimated): | 22 | 2 | 1 | 1 | 1 | 2 | 0 | 1 | ||||||||
| Totals: | 1002 | 239 | 483 | 6 | 192 | 247 | 28 | 31 | 14 | 14 | 74 | 26 | 31 | 65 | 101 | 20 |
| Actual Results: | 1002 | 239 | 480 | 6 | 192 | 247 | 29 | 31 | 14 | 14 | 72 | 26 | 31 | 65 | 103 | 20 |
Recipe: 70 Honey @ 1176; 40 Dark Malt @ 1176
| Location: | 1012, -3269 | Yeasts: | Y75 / Y58 | Sealed at: | 1174 | ||
| Y75 MaxAlc: | 980 | Glucose Floor: | 13 | Maltose Floor: | 192 | VitFloor: | 87 |
| Y58 MaxAlc: | 1026 | Glucose Floor: | 6 | Maltose Floor: | 25 | VitFloor: | 55 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 699 | 19 | 22 | 10 | 10 | 17 | 22 | 14 | ||||||||
| 2nd Yeast (estimated): | 247 | 22 | 11 | 8 | 7 | 20 | 3 | 8 | ||||||||
| Totals: | 946 | 236 | 70 | 6 | 228 | 236 | 41 | 33 | 18 | 16 | 86 | 37 | 25 | 59 | 73 | 22 |
| Actual Results: | 946 | 236 | 64 | 6 | 228 | 236 | 42 | 33 | 17 | 16 | 85 | 36 | 24 | 59 | 74 | 21 |
The data for these two tests comes from Hatnofret's excellent page. Notice that while the recipes for these two tests are different, the total alcohol generated by these two yeasts remains the same. Notice also that in both cases I have basically assumed that the first yeast reached it's MaxAlc first, and this gave a reasonably good approximation of the observed flavor numbers.
Recipe: 50 Honey @ 1176; 50 Honey @ 24; 20 Light Malt @ 24; 45 Burnt Malt @ 1176
| Location: | 1265,-3827 | Yeasts: | Y96 / Y49 | Sealed at: | 1300 | ||
| Y96 MaxAlc: | 573 | Glucose Floor: | 2 | Maltose Floor: | 116 | VitFloor: | 172 |
| Y49 MaxAlc: | 1198 | Glucose Floor: | 12 | Maltose Floor: | 82 | VitFloor: | 108 |
| Estimates: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 573 | 860 | 6 | 17 | 43 | 8 | 44 | 13 | ||||||||
| 2nd Yeast (estimated): | 629 | 203 | 8 | 13 | 320 | 13 | 15 | 11 | ||||||||
| Estimate Totals: | 1202 | 537 | 472 | 12 | 116 | 22 | 1062 | 14 | 30 | 363 | 784 | 21 | 59 | 11 | 55 | 24 |
| Actual Results: | 1202 | 537 | 486 | 12 | 116 | 22 | 1070 | 13 | 33 | 365 | 786 | 21 | 58 | 11 | 56 | 23 |
Recipe: 50 Honey @ 1176; 50 Honey @ 24; 15 Light Malt @ 24; 15 Medium Malt @ 1176
| Location: | 1265,-3827 | Yeasts: | Y96 / Y49 | Sealed at: | 1300 | ||
| Y96 MaxAlc: | 573 | Glucose Floor: | 2 | Maltose Floor: | 116 | VitFloor: | 172 |
| Y49 MaxAlc: | 1198 | Glucose Floor: | 12 | Maltose Floor: | 82 | VitFloor: | 108 |
| Estimates: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 573 | 862 | 5 | 19 | 44 | 7 | 43 | 13 | ||||||||
| 2nd Yeast (estimated): | 629 | 209 | 8 | 13 | 321 | 13 | 15 | 11 | ||||||||
| Estimate Totals: | 1202 | 48 | 388 | 12 | 146 | 105 | 1072 | 13 | 33 | 364 | 784 | 21 | 58 | 38 | 54 | 23 |
| Actual Results: | 1202 | 48 | 348 | 12 | 146 | 106 | 1070 | 13 | 33 | 365 | 768 | 21 | 58 | 38 | 54 | 23 |
Recipe: 112 Honey @ 1176; 8 Raw Malt @ 12
| Location: | 1021, 3585 | Yeasts: | Y48 / Y40 | Sealed at: | 2200 | ||
| Y48 MaxAlc: | 1026 | Glucose Floor: | 5 | Maltose Floor: | 43 | VitFloor: | 150 |
| Y40 MaxAlc: | 971 | Glucose Floor: | 3 | Maltose Floor: | 124 | VitFloor: | 16 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 519 | 5 | 131 | 6 | 42 | 14 | 25 | 20 | ||||||||
| 2nd Yeast (estimated): | 482 | 13 | 31 | 9 | 9 | 11 | 482 | 40 | ||||||||
| Total Predicted: | 1001 | 1 | 220 | 127 | 40 | 17 | 19 | 162 | 15 | 50 | 118 | 24 | 507 | 8 | 42 | 60 |
| Actual Results: | 1001 | 1 | 262 | 127 | 40 | 17 | 20 | 162 | 15 | 50 | 122 | 25 | 507 | 8 | 41 | 58 |
Recipe: 107 Honey @ 1176; 8 Raw Malt @ 12
| Location: | 1021, 3585 | Yeasts: | Y48 / Y40 | Sealed at: | 2200 | ||
| Y48 MaxAlc: | 1026 | Glucose Floor: | 5 | Maltose Floor: | 43 | VitFloor: | 150 |
| Y40 MaxAlc: | 971 | Glucose Floor: | 3 | Maltose Floor: | 124 | VitFloor: | 16 |
| Predicted Results: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 519 | 5 | 131 | 6 | 42 | 14 | 25 | 20 | ||||||||
| 2nd Yeast (estimated): | 482 | 13 | 31 | 9 | 9 | 11 | 482 | 40 | ||||||||
| Total Predicted: | 1001 | 1 | 216 | 77 | 40 | 17 | 19 | 162 | 15 | 50 | 113 | 24 | 507 | 8 | 42 | 60 |
| Actual Results: | 1001 | 1 | 258 | 77 | 40 | 17 | 20 | 162 | 15 | 50 | 117 | 25 | 507 | 8 | 41 | 58 |
This data also comes from Hatnofret's excellent page. However, in this case, I have to confess I am baffled. Notice that the predicted Date flavor is much less than the actual flavor in the beer. Even if we estimate that all the alcohol came from the 2nd yeast, which has a much higher Date stat, I still only get a total calculated Date flavor of 134. Not sure how to interpret this. For now I have assumed that the first yeast reached its MaxAlc number, like the other tests above where the first yeast has a low MaxAlc. I may need to do additional testing on the yeast stats for both yeasts to make sense of this.
Recipe: 10 Honey @ 1176; 20 Honey @ 24; 40 Light Malt @ 1176
| Location: | 1250, -3880 | Yeasts: | Y83 / Y73 | Sealed at: | 1200 | ||
| Y83 MaxAlc: | 385 | Glucose Floor: | 4 | Maltose Floor: | 100 | VitFloor: | 26 |
| Y73 MaxAlc: | 573 | Glucose Floor: | 14 | Maltose Floor: | 194 | VitFloor: | 169 |
| Estimates: | Alcohol | Color | Vitamin | Glucose | Maltose | Barley | Orange | Bannana | Cherry | Date | Honey | Nutmeg | Cinnam | Tannin | Grassy | Nasty |
| 1st Yeast (estimated): | 385 | 18 | 22 | 6 | 6 | 4 | 5 | 30 | ||||||||
| 2nd Yeast (estimated): | 62 | 1 | 1 | 1 | 19 | 1 | 2 | 1 | ||||||||
| Estimate Totals: | 447 | 59 | 337 | 4 | 329 | 236 | 19 | 23 | 7 | 25 | 313 | 4 | 7 | 118 | 64 | 31 |
| Actual Results: | 447 | 59 | 337 | 4 | 329 | 236 | 18 | 22 | 6 | 192 | 313 | 4 | 6 | 118 | 63 | 30 |
I have pulled some of the data together into a single table so that it can be viewed side-by-side. I left out test results where I simply used a different seal time and I also left out Test 12 because I am so unsure of what is going on there.
The "Unused Glucose", "Unused Maltose", and "Unused Vitamins" correspond to the amounts left over in the finished beer. This table attempts to show that, although there are nutrients left over above the floors of both yeasts, not all of the alcohol that could be produced is being produced.
| Test Name | Yeasts | Max Alc Potential | Estimated Alc in Beer from each Yeast | Estimated % of MaxAlc Potential | Unused Glucose | Glucose Floor | Glucose Above Floors | Unused Maltose | Maltose Floor | Maltose Above Floors | Unused Vitamins | Vitamin Floor | Vitamins Above Floors |
| Test 1 | Y8 | 992 | 755 | 76% | 586 | 13 | 573 | 350 | 12 | 338 | 495 | 71 | 424 |
| Y51 | 755 | 129 | 17% | 586 | 3 | 583 | 350 | 173 | 177 | 495 | 171 | 324 | |
| Totals: | 1747 | 884 | 51% | ||||||||||
| Test 2 | Y8 | 992 | 755 | 76% | 3 | 13 | 0 | 303 | 12 | 291 | 651 | 71 | 580 |
| Y51 | 755 | 129 | 17% | 3 | 3 | 0 | 303 | 173 | 130 | 651 | 171 | 480 | |
| Totals: | 1747 | 884 | 51% | ||||||||||
| Test 4 | Y75 | 980 | 955 | 97% | 6 | 13 | 0 | 192 | 192 | 0 | 60 | 87 | 0 |
| Y58 | 1026 | 7 | 1% | 6 | 6 | 0 | 192 | 25 | 167 | 60 | 55 | 5 | |
| Totals: | 2006 | 962 | 48% | ||||||||||
| Test 5 | Y75 | 980 | 980 | 100% | 6 | 13 | 0 | 192 | 192 | 0 | 480 | 87 | 393 |
| Y58 | 1026 | 22 | 2% | 6 | 6 | 0 | 192 | 25 | 167 | 480 | 55 | 425 | |
| Totals: | 2006 | 1002 | 50% | ||||||||||
| Test 7 | Y75 | 980 | 699 | 71% | 6 | 13 | 0 | 228 | 192 | 36 | 64 | 87 | 0 |
| Y58 | 1026 | 247 | 24% | 6 | 6 | 0 | 228 | 25 | 203 | 64 | 55 | 9 | |
| Totals: | 2006 | 946 | 47% | ||||||||||
| Test 8 | Y96 | 573 | 573 | 100% | 12 | 2 | 10 | 116 | 116 | 0 | 486 | 172 | 314 |
| Y49 | 1198 | 629 | 53% | 12 | 12 | 0 | 116 | 82 | 34 | 486 | 108 | 378 | |
| Totals: | 1771 | 1202 | 68% | ||||||||||
| Test 9 | Y96 | 573 | 573 | 100% | 12 | 2 | 10 | 146 | 116 | 30 | 348 | 172 | 176 |
| Y49 | 1198 | 629 | 53% | 12 | 12 | 0 | 146 | 82 | 64 | 348 | 108 | 240 | |
| Totals: | 1771 | 1202 | 68% | ||||||||||
| Test 10 | Y48 | 1026 | 519 | 51% | 127 | 5 | 122 | 40 | 43 | 0 | 262 | 150 | 112 |
| Y40 | 971 | 482 | 50% | 127 | 3 | 124 | 40 | 124 | 0 | 262 | 16 | 246 | |
| Totals: | 1997 | 1001 | 50% | ||||||||||
| Test 11 | Y48 | 1026 | 519 | 51% | 77 | 5 | 72 | 40 | 43 | 0 | 258 | 150 | 108 |
| Y40 | 971 | 482 | 50% | 77 | 3 | 74 | 40 | 124 | 0 | 258 | 16 | 242 | |
| Totals: | 1997 | 1001 | 50% | ||||||||||
These are tentative observations, conclusions and speculations based on the results summarized above.