Arte SheetsLearn. Try. Understand.

Commercial Baking & Cereal Chemistry, Baker’s Percentages, Hydration & Strike Water DDT

Baker’s Percentage Dough Scaling & Strike Water Temp Formula

Calculate Total Baker’s Formula Percentage (>100%), Scaled Total Flour Mass (kg), Hydration Water Mass (kg), and 3-Factor Strike Water Temperature for Desired Dough Temp (°C).

In baker’s math percentages sum to 183%, NOT 100%—and missing Desired Dough Temperature by 3 °C ruins bulk fermentation timing

Commercial artisan bakeries express every ingredient relative to Total Flour Weight = 100.0% (Baker’s Percentage): a 72% hydration country sourdough with 2.2% sea salt and 8.8% inoculated levain/inclusions sums to Total Formula Percentage Ptot = 100 + H% + S% + O% = 183.0%. To scale a batch to Target Total Bowl Weight Mdough (kg), divide by Ptot / 100 for Required Flour Mflour = Mdough / (Ptot / 100) (kg) and **Hydration Water Mwater = Mflour * (H% / 100) (kg). Simultaneously, wild-yeast and Lactobacillus fermentation doubles in speed every ~6–8 °C, so bakers hit Desired Dough Temperature DDT (24–26 °C) using the 3-Factor Strike-Water Rule: Twater = 3 * DDT - (Troom + Tflour + Delta_Tfriction)** (°C, where spiral-mixer mechanical shear adds Delta_Tfriction ≈ 6–12 °C).

Verify on a 45.0 kg Spiral-Mixer Country Loaf Batch—Target_Total_Dough = 45.0 kg (B2), Hydration_Water = 72.0% (B3), Sea_Salt = 2.2% (B4), Starter_&_Additions = 8.8% (B5 -> Total Baker’s Formula = 183.0% in E2), Desired_Dough_Temp DDT = 25.0 °C (B6), Combined_Room_+_Flour_Temp = 43.0 °C (22 °C bakery + 21 °C silo flour, B7), and Spiral_Mixer_Friction = 8.0 °C (B8): Flour Weight equals 24.59 kg (E3), Water Weight equals 17.70 kg (E4), and Required Strike Water equals 24.0 °C (E5).

Commercial Bakery Scaling KPI (45 kg Dough, 72% Hydr, DDT=25 °C, Friction=8 °C)FormulaVerified Output
Total Baker’s Formula (%)100 + Hydration% + Salt% + Other%183.0% (flour anchored at 100%)
Scaled Total Flour Mass (kg)Target_Dough_kg / (Total_Formula_Pct / 100)24.59 kg
Scaled Hydration Water (kg)Scaled_Flour_kg * (Hydration_Pct / 100)17.70 kg
Required Strike Water Temp (°C)3 * DDT_C - (Room_Plus_Flour_C + Friction_C)24.0 °C (11.0 °C chilled water in summer)

Baker’s Percentage Inverse Bowl Scaling & 3-Factor Strike-Water DDT Formula

Validate Target_Dough > 0.5 kg, Hydration in [45%, 110%], Salt in [0%, 5%], Other >= 0%, DDT in [18, 32] °C, Room+Flour in [20, 80] °C, and Mixer_Friction >= 0 °C. On a shared production schedule sheet, night-shift lead bakers can upload .csv flour-delivery specs as safe read-only excerpts or leave cell suggestions on B7 when seasonal mill temperatures rise.

=LET(md_k, B2, hy_p, B3, sl_p, B4, ot_p, B5, dd_c, B6, rf_c, B7, fr_c, B8, IF(OR(md_k <= 0.5, hy_p < 45, hy_p > 110, sl_p < 0, sl_p > 5, ot_p < 0, dd_c < 18, dd_c > 32, rf_c < 20, rf_c > 80, fr_c < 0), "Invalid Dough Formula", ROUND(3 * dd_c - (rf_c + fr_c), 1)))

August Heatwave 29 °C Bakery + 27 °C Flour Chiller-Water Check (Set Room+Flour Temp B7 = 56.0 °C)

Run the identical 45 kg mix during a summer heatwave (Troom + Tflour B7 = 56.0 °C): Strike Water Temp E5 plunges from 24.0 °C down to 11.0 °C—signaling the water-meter chiller (or flaked ice substitution if Twater < 2 °C) so dough never exits the spiral bowl at a runaway 31 °C.

=IF(ISTEXT(E5), E5, LET(tp_f, 100 + B3 + B4 + B5, ROUND(B2 / (tp_f / 100), 2)))

Try the example

Use the original values or change them to test your understanding.

Further reading