top of page
When Life Gives
You a Spreadsheet,
Flour & Water,
You Better Bake
Bakers Percent Re-Imagined
Spreadsheets & Baking Are Made For Each Other
.
However, figuring out the slightly complicated initial & overall Baker’s Percent can seem discouraging at first. Getting it onto a spreadsheet, maybe even more so.
What if Bakers Percent was re-imagined so that instead of dividing the weight of each ingredient by the weight of the flour & then multiplying the resulting decimal form by 100 to convert it to a percentage.
How about you enter only the weight of ingredients & allow a fully formulated spreadsheet to self-calculate all the percentages involved as a simpler way to reach the same goal.....?
Home Page
What's This All About Then?
A Detailed, Fully Formulated, Formatted, Self-Calculating Weight-To-Percentage Spreadsheet Complete With All The Functions Listed Below.
Ingredients
Separate ingredient sections for Soakers, Sourdough & Levain, Preferments (Pâte Fermentée, Biga, Poolish, Sponge, etc.). Main recipe with a variety of flours, wet & dry additions.
Formulas
Built-in formulas re-calculate each ingredient's weight, displayed adjacent to the original recipe.
Percentages are maintained throughout when increasing or decreasing Total Dough Weight. (TDW)
Viewing
View all recipes on one sheet with over 200 individual rows, giving the ability to add new, update old & compare numerous simultaneously. View both original & revised side-by-side.
Conversions
Conversion tables are incorporated for Yeast, Temperatures, Customary to Metric, Volumes, Bakeware, Recipe Ratios, Ingredient Water Content. Including a Preferment Ratio Generator.
Selection
Preloaded drop-down selection boxes for choosing recipes, bakers and bakeware used.
Self-sorting of bespoke user-defined entries incorporated in alphabetical order in drop-downs.
Download
Send, save or print to (tablet, pad, phone) in a recipe card format with workflow times & temperatures. Filter out "not included" ingredients and non-essential sections.
Annotate pdf's on the go!
How's It All Work?
What makes this sheet unlike others is that it self-calculates Bakers Percent from ingredient weights added in grams, not weights from percentages. An Effective Re-imagining!
Core formulas gather distributed individual flour types weights in each section to form the overall total flour (100%).
Each ingredient added to a section is calculated on that section's total flour as a percentage & the recipe card highlights these instantly as a running total as the recipe develops.
Pre Fermented Flour & Hydrations are calculated automatically then displayed in highlighted groups
The Revised Total Weight converts all displayed percentages to weight using in-built formulas, keeping the original Total Dough Weight in view
Changing a single ingredient in the recipe will redistribute all weights and percentages equally
The recipe card displays the percentage distribution of individual flours & all other ingredients used in the recipe.
The sheet collects information included in the additional features entered elsewhere & transfers it promptly to the recipe card.
Add in the baked weight & the sheet will calculate the percentage lost through evaporation during the whole process!
Additional Features
These include Built-in tables, Calculators, Converters & Automatic transfers along with Information & How-to guides in most sections
Calculators
-
Fresh, Active & Instant yeast converter
-
Preferment generator
-
Cup, Tablespoon & Teaspoon converters
-
Water content percentage tables
Transfers
-
Links to websites & documents
-
Star ratings
-
Workflow using real-time hours & minutes
-
Room, Dough & Oven temperatures
-
Recipe notes
-
Extra baking notes
A Recipe Reimagined!
A Complete, Detailed, Fully Formulated & Formatted, Self-Calculated Weight-To-Percentage pdf
Wholewheat & Rye Seeded Sourdough loaf
White & ww rye gallery
Extracted Elements
bottom of page