This is my ingredient testing data. The updated equations in the T3 Beer Spreadsheet are based on these numbers.
One of the things I discovered was that basing the equations on the actual "tick" number makes them much more accurate. The brewing cycle is divided up into 12 second "ticks" - making it easier to add ingredients at the same time, since you have 12 seconds in each "tick" to add them. While most recipes you see on the Wiki will use the T2 convention for entry times of 1180 and 20 (for beginning and end - also used in the T2 BeerCalc spreadsheet), my T3 BeerCalc spreadsheet uses the numbers that correspond to the actual ticks when the ingredients were entered.
My testing also confirmed that the game rounds to the nearest tick, so the window to enter ingredients is +/- 6 seconds around each tick. The first tick occurs at 1200 seconds (or, looking at it another way, at zero seconds because the system counts down from 1200), so 1200 to 1195 seconds is included in that tick (in other words the first tick is just 6 seconds long). 1194-1183 seconds corresponds to the second tick centered around the -12 tick at 1188. And 1182 to 1171 is centered around the third tick at 1176. So you can see that the old convention of using 1180 falls within that third tick, and I used 1176 for my ingredient testing to be absolutely sure that all my data resulted from adding ingredients at exactly the same time, and at a time that corresponded to the old data on the wiki.
Likewise, 24 seconds corresponds to the third tick from the end of the brewing phase, encompassing 30-19 seconds, centered around 24. And you can see that the old convention of using 20 seconds for this tick falls within that range. However, it is worth noting that 20 seconds comes awfully close to the end of that range, just as 1180 came awfully close to the start of the range for the third tick. This may have resulted in imprecise results for some prior tests and recipes, since people may have thought that a second ingredient added right after 20 seconds would fall within the same tick, but in reality they only had 1 second left to add another ingredient within that same tick.
| Added at 1176 | Added at 24 | |||||||||||||||
| Ingredient | Amount | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | |
| Honey | 200 | 169 | 2000 | 194.000 | 909 | 2000 | 2857 | |||||||||
| 100 | 84.500 | 1000 | 97.000 | 454.5 | 1000 | 1428.5 | ||||||||||
| 1 | 0.845 | 10.000 | 0.970 | 4.545 | 10.000 | 14.285 | ||||||||||
| Added at 1176 | Added at 24 | |||||||||||||||
| Ingredient | Amount | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | |
| Raw Malt | 100 | 98 | 1102 | 100 | 500 | 1180 | 590 | 1180 | 18 | 5909 | 100 | 500 | 220 | 110 | 220 | |
| 1 | 0.980 | 11.020 | 1.000 | 5.000 | 11.800 | 5.900 | 11.800 | 0.180 | 59.090 | 1.000 | 5.000 | 2.200 | 1.100 | 2.200 | ||
| Light Malt | 100 | 148 | 847 | 200 | 1000 | 590 | 295 | 148 | 28 | 4545 | 200 | 1000 | 110 | 55 | 28 | |
| 1 | 1.480 | 8.470 | 2.000 | 10.000 | 5.900 | 2.950 | 1.480 | 0.280 | 45.450 | 2.000 | 10.000 | 1.100 | 0.550 | 0.280 | ||
| Medium Malt | 100 | 295 | 593 | 200 | 1000 | 590 | 197 | 0 | 55 | 3182 | 200 | 1000 | 110 | 37 | 0 | |
| 1 | 2.950 | 5.930 | 2.000 | 10.000 | 5.900 | 1.970 | 0.000 | 0.550 | 31.820 | 2.000 | 10.000 | 1.100 | 0.370 | 0.000 | ||
| Dark Malt | 100 | 590 | 424 | 200 | 1000 | 590 | 148 | 0 | 110 | 2273 | 200 | 1000 | 110 | 28 | 0 | |
| 1 | 5.900 | 4.240 | 2.000 | 10.000 | 5.900 | 1.480 | 0.000 | 1.100 | 22.730 | 2.000 | 10.000 | 1.100 | 0.280 | 0.000 | ||
| Burnt Malt | 100 | 1180 | 0 | 0 | 200 | 0 | 0 | 0 | 220 | 0 | 0 | 200 | 0 | 0 | 0 | |
| 1 | 11.800 | 0.000 | 0.000 | 2.000 | 0.000 | 0.000 | 0.000 | 2.200 | 0.000 | 0.000 | 2.000 | 0.000 | 0.000 | 0.000 | ||
| Added at 1176 | Added at 24 | |||||||||||||||
| Ingredient | Amount | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | Color | Vitamins | Glucose | Maltose | Barley | Tannin | Honey | |
| Raw Wheat | 100 | 98 | 847 | 120 | 250 | 1180 | 590 | 1180 | 18 | 4545 | 120 | 250 | 220 | 110 | 220 | |
| 1 | 0.980 | 8.470 | 1.200 | 2.500 | 11.800 | 5.900 | 11.800 | 0.180 | 45.450 | 1.200 | 2.500 | 2.200 | 1.100 | 2.200 | ||
| Light Wheat | 100 | 148 | 763 | 240 | 500 | 590 | 295 | 148 | 28 | 4091 | 240 | 500 | 110 | 55 | 28 | |
| 1 | 1.480 | 7.630 | 2.400 | 5.000 | 5.900 | 2.950 | 1.480 | 0.280 | 40.910 | 2.400 | 5.000 | 1.100 | 0.550 | 0.280 | ||
| Medium Wheat | 100 | 295 | 678 | 240 | 500 | 590 | 197 | 0 | 55 | 3636 | 240 | 500 | 110 | 37 | 0 | |
| 1 | 2.950 | 6.780 | 2.400 | 5.000 | 5.900 | 1.970 | 0.000 | 0.550 | 36.360 | 2.400 | 5.000 | 1.100 | 0.370 | 0.000 | ||
| Dark Wheat | 100 | 590 | 593 | 240 | 500 | 590 | 148 | 0 | 110 | 3182 | 240 | 500 | 110 | 28 | 0 | |
| 1 | 5.900 | 5.930 | 2.400 | 5.000 | 5.900 | 1.480 | 0.000 | 1.100 | 31.820 | 2.400 | 5.000 | 1.100 | 0.280 | 0.000 | ||
| Burnt Wheat | 100 | 1180 | 0 | 0 | 100 | 0 | 0 | 0 | 220 | 0 | 0 | 100 | 0 | 0 | 0 | |
| 1 | 11.800 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 2.200 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | ||