web analytics
Bakers percentage spreadsheet - Forno Bravo Forum: The Wood-Fired Oven Community

Announcement

Collapse

I'm Peter Reinhart! Ask Me Anything! Monday, February 15, 2016 7:00-8:00 pm EST

To kick off our AMA feature, we have invited author, chef and master bread maker and host of Pizza Quest, Peter Reinhart, to be our first host! Peter will be in the Forum on Monday, February 15th, from 7:00 - 8:00 pm EST. If you are unable to be online during the live session, you can post your questions in the sticky post. Peter will answer those questions during the live session on February 15th. You can view Peter's answers to your questions as well as what happened during the live session in the session thread.

Ask Me Anything New Forum Feature

You will notice a new forum at the top of the main page called, "Ask Me Anything". This forum will be used for live one hour "Ask Me Anything" (AMA) sessions hosted by people who are knowledgeable in different areas pertaining to wood fired ovens. How it works:
- Each AMA will have a "sticky" thread where the community can post questions they would like answered during the live session. This will allow everyone to participate even if you can't be online for the live session. These questions will not be answered by the host until the live AMA; if you need an answer quickly, you should post it in the appropriate Forum area for the community to respond.
- Another thread will be posted for the live AMA. Registered users who are logged in during the live session can interact with the host by asking questions and receiving responses.
- The live thread will remain in the AMA forum to view after the session.

We hope you enjoy this new feature! Please let us know if there is a topic that you'd like to have as an AMA and we'll look for a host!

Forno Bravo
See more
See less

Bakers percentage spreadsheet

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Bakers percentage spreadsheet

    Hi all, I have put together a little spreadsheet to work with bakers percentages - thought I'd post it in case others find it useful. There are 2 calculators here - the first one lets you enter weights and gives you the percentages of these ingredients compared to the main ingredient. The other calculator lets you enter bakers percentages from an existing recipe or the first calculator, and the final dough weight required, and tells you the actual weights you need.

    I use this to scale up or down recipes where I have either percentages or weight measurements. It has instructions and should be pretty straight forward!

    It uses macros so Excel may give you a warning. You may want to run this through a virus scanner before opening if you don't trust me - of course this should be standard practice with any spreadsheet
    Attached Files
    Last edited by Tim F; 08-08-2008, 04:06 AM.
    My oven: http://www.fornobravo.com/forum/21/t...html#post46599
    My blog: Live For Pizza

  • #2
    Re: Bakers percentage spreadsheet

    Great calculator - thanks for posting.

    Ross
    / Rossco

    Comment


    • #3
      Re: Bakers percentage spreadsheet

      Quick question ...

      Why does the flour and water amount vary so much when switching from dry to fresh yeast on this calculator? I'm sure that there is a simple explanation for this...

      TIA

      Rossco


      Base Recipe
      =========

      Flour 500.0 100.00%
      Other ingredients
      Salt 3.0 0.60%
      Yeast 9.0 1.80% (Fresh)
      Water 325.0 65.00%

      Baker's % - Fresh Yeast for 908 Grams Dough
      ==================================

      Flour 542.4 100.0%
      Salt 3.3 0.6%
      Yeast 9.8 1.8%
      Water 352.6 65.0%

      Baker's % - Instant Yeast for 908 Grams Dough
      ==================================

      Flour 546.3 100.0%
      Salt 3.3 0.6%
      Yeast 3.3 0.6%
      Water 355.1 65.0%
      / Rossco

      Comment


      • #4
        Re: Bakers percentage spreadsheet

        I don't want to necessarily answer for Tim but it is likely because there would be moisture in the cake fresh yeast that would have to be accounted for in the final recipe. It really is a great calculator. We use something similar done in excel also.
        Great work!
        Dutch
        "Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity. " Charles Mingus
        "Build at least two brick ovens...one to make all the mistakes on and the other to be just like you dreamed of!" Dutch

        Comment


        • #5
          Re: Bakers percentage spreadsheet

          Interesting - though this would suggest that there is some "logic" programmed into the spreadsheet. That is, it would need to understand that, for example, "Fresh Yeast" and "Instant Yeast" are distinct and would need to be weighted according to allow for different moisture contents etc.

          I certainly agree, this is a fantastic calculator and it keeps things simple! There are some other calculators around that require additional characteristics to be included which probably result in a more accurate end result, but they are beyond my needs so Tim's solution is fine.

          My question was posed more out of curiosity that anything else as I thought that there may have been some simple explanation that I was missing. I am always eager to learn more about this exciting topic!!!

          Rossco


          Originally posted by Dutchoven View Post
          I don't want to necessarily answer for Tim but it is likely because there would be moisture in the cake fresh yeast that would have to be accounted for in the final recipe. It really is a great calculator. We use something similar done in excel also.
          Great work!
          Dutch
          / Rossco

          Comment

          Working...
          X