Excel workbook
Baker's Percentage and Dough Scaling Workbook: Hydration, Batch Weights and Preferments in Excel
Keep your formulas as baker's percentages, then scale to any batch in grams, ounces and pounds and see the hydration at a glance.
$19 one time · example and blank copies · download link by email
Who it is for
Home and professional bakers, cottage-food sellers and bakery owners who scale formulas up and down.
Why it is different
- Everything scales from one flour weight, so changing batch size is one number.
- It splits a preferment out and shows overall hydration for the whole dough.
- A filled example with four formulas, and a blank copy with working formulas.
What is inside
- Start Here. What the workbook does and how to fill it in.
- Formulas. Up to eight formulas of fifteen ingredients each, with total percentage, hydration and a plain-English description of the dough.
- Scale. Pick a formula, enter the number of pieces and their weight and an allowance for dough loss, and get every ingredient weight in grams, ounces and pounds.
- Preferment. Split a poolish or similar preferment from the final dough and see the overall percentages.
- Conversions. Weight and temperature converters and a desired-dough-temperature water helper.
- Checks. Flour that is not flagged, negative percentages and a loss allowance out of range.
A look inside
Example data, real formulas
Get it
Baker's Percentage and Dough Scaling Workbook
Want every toolkit? The toolkit membership includes all of them, with a lower rate if you pay yearly.
Delivered as a zip of editable Word files and printable PDFs. For one business, your own use. General information and templates, not legal, tax or accounting advice. Liquids you flag count at 100 percent, so eggs and milk are not adjusted for their solids. The hydration descriptions are a general guide, not a standard. This is not a food-safety or labeling tool. Payment is handled by Stripe. If a file will not open or something looks wrong, reply to your order email and we will make it right.
Rather hand it off?
We can keep the books for you each month
If tracking this yourself is more than you want to take on, we do monthly bookkeeping in QuickBooks, Xero or Excel. Tell us what you use and what is behind, and we reply with a written quote after a short review of your books. No obligation.
Get a bookkeeping quote Free books health checkPrefer to keep it yourself but want a hand getting started? Book a 45 minute setup session ($65).
Buy it with the others