Welcome!


This is a membership forum. As a guest, you can click around a bit. View 3 pages for free. If you would like to participate, please join.

[ Lost Username or Password | Pitmaster Club Information, | Join 30 Days Free | Contact Us ]

There are 2 page views remaining.

Announcement

Collapse

Meat-Up in Memphis 2021

Join us in Memphis for our Meat-Up! Space is limited to 400, secure your spot by booking early!
Click here for details. (https://amazingribs.com/memphis)
See more
See less

Baker's Percentage Formula Calculator (Excel Spreadsheet)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • MBMorgan
    Club Member
    • Sep 2015
    • 5945
    • Colorado
    • > Weber Genesis EP-330
      > Grilla Grills Original Grilla (OG) pellet smoker
      > Pit Barrel Cooker (gone to a new home)
      > WeberQ 2000 (on "loan" to a relative)
      > Old Smokey Electric (for chickens mostly - when it's too nasty out
      to fiddle with a more capable cooker)
      > Luhr Jensen Little Chief Electric - Top Loader circa 1990 (smoked fish & jerky)
      > Thermoworks Smoke
      > 3 Thermoworks Chef Alarms
      > Thermoworks Thermapen
      > Thermoworks IR-GUN-S
      > Anova sous vide circulator
      > Searzall torch
      > BBQ Guru Rib Ring

      > Favorite Beer: Guinness Extra Stout, Fat Tire, Anchor Steam, or Alaskan Amber
      > Favorite Wine: Klinker Brick Old Ghost Zinfandel or Matetic Corralillo Winemaker's Blend
      > Favorite Whiskey: Balvenie Double Wood Scotch or Jameson Irish

    Baker's Percentage Formula Calculator (Excel Spreadsheet)

    For the past couple of months, in collaboration with scottranda , I've been developing a comprehensive new spreadsheet intended to make the job of developing, scaling, and reverse-engineering bread formulas (recipes) faster and much easier. In it, you'll find several types of worksheets:

    The first is a Title/Documentation page. It contains sufficient (I hope) details to get you started understanding and using the rest of the spreadsheet:

    Click image for larger version  Name:	01 - Bakers Percentage Calculator - Title.jpg Views:	1 Size:	874.2 KB ID:	267613

    The second is a Bread Log (contributed entirely by Scott). It is intended to be a place to record the details of bread(s) that you have baked:

    Click image for larger version  Name:	02 - Bakers Percentage Calculator - Bread Log.jpg Views:	1 Size:	429.2 KB ID:	267614

    The third type is the Baker's Percentage Calculator itself. You'll find examples of three breads (Breadhead's 66% Hydration Sourdough, a 75% White Bread with Sourdough Poolish, and Breadhead's Brioche Hamburger Buns):

    Click image for larger version  Name:	03 - Bakers Percentage Calculator - Breadheads 66% Hyd Sourdough.jpg Views:	1 Size:	533.6 KB ID:	267615

    Thanks to Willy , there is now a fourth type ... his new spreadsheet that takes care of the math when you need to boost your flour protein level:

    Click image for larger version  Name:	03 - Bakers Toolkit - Boost Flour Protein Level.jpg Views:	1 Size:	313.0 KB ID:	271108

    I invite anyone here to download the spreadsheet using the link below and to use it however it suites you best. Scott and I are open to feedback, questions, suggestions for improvement, etc., and we'll do everything we can to provide help.

    Here is a link to the latest version:
    https://www.dropbox.com/s/83s63gf27n...0.2c.xlsx?dl=0
    DropBox can be a little fussy at times, so please let me know if the link gives you problems.

    Enjoy!
    Last edited by MBMorgan; March 22nd, 2017, 10:20 AM.
  • SMOG MAN
    Club Member
    • Jan 2016
    • 293
    • San Diego, California
    • Rec Tec 680
      Weber Performer
      Weber Rotisserie for kettle
      Weber Summit
      My old worn out Gasser for burgers

    #2
    I just downloaded and opened file without any problems so far, thanks!!

    Comment

    • RonB
      Club Member
      • Apr 2016
      • 11860
      • Near Richmond VA
      • Weber Performer Deluxe
        SNS
        Pizza insert
        Rotisserie
        Smokenator 1000
        Cookshack Smokette Elite
        2 Thermapens
        Chefalarm
        Dot
        lots of probes.
        CyberQ

      #3
      Thanx to both of you.

      Comment

      • EdF
        EdF
        Club Member
        • Jul 2016
        • 3174
        • Atlantic Highlands, NJ
        • Uuni Pro (new kid in town)
          Karubeque C-60
          Large BGE since 2002 + plate setter + pizza stone + upper grid + stainless paella pan for drippings (the best!)
          TEC Cherokee FR since 2014 (portable infrared grill - does a mighty sear)
          Polyscience Sous Vide Pro since 2012 (wasn't much else available in those days)
          Thermapen
          Thermapen Air
          ThermaQ (or its predecessor)
          Thermoworks Hi temp IR
          BBQ Dragon & Chimney of Insanity
          Various other stuff

        #4
        Awesome! Thank you both!

        Comment

        • Michael Brinton
          Club Member
          • May 2016
          • 265

          #5
          Fantastic! I've always tried to wing it, with less than desirable results. Using a tool such as this is a sure fire way to improve. Thanks guys!

          Comment

          • Willy
            Charter Member
            • Apr 2015
            • 1783
            • High Desert of the Great Southwest

            #6
            SWEET! Thanks for youse guys' work.

            Comment

            • tbob4
              Charter Member
              • Nov 2014
              • 2257
              • Chico, CA
              • BBQ's
                _____________________
                California Custom Smokers Intensive Cooking Unit
                California Custom Smokers Meat Locker
                Santa Maria Grill
                Vision Grill

                Beer
                _______________________
                Sierra Nevada IPA

                Wood
                _______________________
                Almond
                Oak
                Madrone
                Cherry
                Peach
                Apple

              #7
              Awesome job. While I do not do bread it is fantastic work and the type of resource that goes well beyond what someone would expect from "any old BBQ" site.

              Comment

              • scottranda
                Charter Member
                • May 2015
                • 1620
                • Charlotte, NC

                #8
                Excel geeks unite! We hope it serves as a useful tool to those experienced and beginners alike! It was fun to make a bread tool to help everyone!

                Comment

                • Willy
                  Charter Member
                  • Apr 2015
                  • 1783
                  • High Desert of the Great Southwest

                  #9
                  I just downloaded it too. My mistake was to click on the document in the post and not the link. DUH!

                  Comment

                  • MBMorgan
                    Club Member
                    • Sep 2015
                    • 5945
                    • Colorado
                    • > Weber Genesis EP-330
                      > Grilla Grills Original Grilla (OG) pellet smoker
                      > Pit Barrel Cooker (gone to a new home)
                      > WeberQ 2000 (on "loan" to a relative)
                      > Old Smokey Electric (for chickens mostly - when it's too nasty out
                      to fiddle with a more capable cooker)
                      > Luhr Jensen Little Chief Electric - Top Loader circa 1990 (smoked fish & jerky)
                      > Thermoworks Smoke
                      > 3 Thermoworks Chef Alarms
                      > Thermoworks Thermapen
                      > Thermoworks IR-GUN-S
                      > Anova sous vide circulator
                      > Searzall torch
                      > BBQ Guru Rib Ring

                      > Favorite Beer: Guinness Extra Stout, Fat Tire, Anchor Steam, or Alaskan Amber
                      > Favorite Wine: Klinker Brick Old Ghost Zinfandel or Matetic Corralillo Winemaker's Blend
                      > Favorite Whiskey: Balvenie Double Wood Scotch or Jameson Irish

                    #10
                    I just created an updated link to the latest version of the spreadsheet in my original post in this thread. It's grown in functionality since the first version so its name has been changed to the more generic "Baker's Toolkit".

                    In the latest version, you'll find the following:
                    1. An updated Intro sheet (formerly "Title") with a few edits and some additional information about new functionality.
                    2. The Bread Log (from scottranda ) is unchanged.
                    3. A new sheet from Willy labeled "Boost Flour Protein Level" which handles the math when you need to boost your flour protein level.
                    4. Two Blank Recipe Sheets:
                      1. Blank Recipe Sheet (by %) - This one is new. In it you enter ingredient amounts in Baker's % instead of weight.
                      2. Blank Recipe Sheet (by wt) - This is the original sheet in which you enter ingredient amounts by weight.
                    5. Five sheets with examples of how each is used for several bread formulas ... including two new ones showing how to use the new "Recipe Sheet (by %)" format.
                    6. The original "Common Ingredients" sheet is unchanged.

                    THE LINK TO THE LATEST VERSION IS IN THE FIRST POST IN THIS THREAD

                    Enjoy! (and feel free to ask questions or provide feedback or suggestions)
                    Last edited by MBMorgan; March 22nd, 2017, 10:22 AM.

                    Comment

                    • scottranda
                      Charter Member
                      • May 2015
                      • 1620
                      • Charlotte, NC

                      #11
                      This is some great stuff (if I do say so myself). I hope it serves our community. I have a few friends interested in bread making. This will be my go-to teaching tool.

                      Comment

                      • JCBBQ
                        Club Member
                        • Jan 2016
                        • 1068
                        • Jersey City, NJ
                        • Primo Oval XL Ceramic Cooker
                          Pit Barrel Cooker
                          2x Mavrick 732
                          Therma Pen Orange
                          Favorite Bourbon Blanton's
                          SF Giants

                          MCS wish list - Lone Star Grillz off set

                        #12
                        Way to go guys! Still haven't gotten around to making bread yet but I will eventually. So thanks in advance.

                        Comment

                        • Dr ROK
                          Charter Member
                          • Dec 2014
                          • 1349
                          • Morrill, Nebraska
                          • Retired high school teacher and principal
                            Dr ROK - Rider of Kawasaki &/or rock and roll fan
                            Yoder 640 on Husker themed comp cart
                            Cookshack Smokette smoker
                            Antique refrigerator smoker
                            Weber 22 1/2" kettle w/ GrillGrates AND Slow and Sear
                            Rec Tec Mini Portable Tailgater w/ GrillGrates
                            Plenty of GrillGrates
                            Uuni wood pellet oven, first generation
                            Roccbox Pizza Oven
                            Meater Block
                            "Go Big Red" Thermopen instant read thermometer
                            Ultrafast instant read thermometer
                            CDN quick read thermometer
                            Maverick ET-732 thermometer
                            Maverick ET-735 thermometer
                            Tru-Temp wireless thermometer
                            Infrared thermometer (Mainly use for pizza on the Uuni and Roccbox)

                            Beverages - Is there really anything other than Guinness? Oh yeah, I forgot about tequila!

                          #13
                          Thank you for your efforts!

                          Comment

                          • TheCountofQ
                            Former Member
                            • Apr 2015
                            • 503
                            • Tulsa, Oklahoma

                            #14
                            Thanks for fixing the link!! This thread is worthy of a "bump", I believe.

                            Comment

                            • scottranda
                              Charter Member
                              • May 2015
                              • 1620
                              • Charlotte, NC

                              #15
                              Thanks. A lot of thought went into this. If you're wanting to learn bread, you can't beat this excel file which is only found on the Pit.

                              Comment

                              Announcement

                              Collapse

                              Meat-Up in Memphis 2021

                              Join us in Memphis for our Meat-Up! Space is limited to 400, secure your spot by booking early!
                              Click here for details. (https://amazingribs.com/memphis)
                              See more
                              See less
                              Working...
                              X
                              Meat-Up in Memphis

                              T-Shirts & More T-Shirts & More
                              Order men's and women's T-Shirts, Sweatshirts, Aprons, Mugs, Caps, Tote Bags, Flasks, and more, all imprinted with the Pitmaster Club logo. There's even a spiral bound journal where you can make notes on your cooks.

                              Cool Embroidered Shirt Cool Embroidered Shirt
                              This beautifully embroidered shirt is the same one Meathead wears in public and on TV. It's wash and wear and doesn't need ironing (really!), but it is a soft cottonlike feel. Choice of four colors and both men's and women's.

                              Click here for more info.

                              Support ARC

                              Many merchants pay us a small referral fee when you click our links and purchase from them. On Amazon it works on everything from grills to diapers, they never tell us what you bought, and it has zero impact on the price you pay, but has a major impact on our ability to improve this site! And remember, we only recommend products we love. If you like AmazingRibs.com, please save this link and use it every time you go to Amazon.

                              https://tinyurl.com/amazingribs

                              BBQ Stars

                              Spotlight

                              These are not ads or paid placements. These Are Some Of Our Favorite Tools And Toys.

                              These are products we have tested, won our top awards, and are highly recommend. Click here to read how we test, about our medals, and what they mean.

                              Use our links when you buy things

                              Many merchants pay us a small referral fee when you click our links and purchase from them. On Amazon it works on everything from grills to diapers, they never tell us what you bought, it has zero impact on the price you pay, but has a major impact on our ability to improve this site! If you like AmazingRibs.com, please save this link and use it every time you go to Amazon

                              https://tinyurl.com/amazingribs

                               


                              Placeholder

                              Surely you know somebody who loves outdoor cooking who deserves a gift for the holidays, birthday, anniversary, or just for being wonderful. There he is, right in the mirror! Here are our selections of best ideas, all Platinum or Gold Medalists, listed by price.

                              Click here to see our list of Gold Medal Gifts


                              Digital Thermometers Are Your Most Valuable Tool And Here's A Great Buy!

                              maverick PT55 thermometer

                              A good digital thermometer keeps you from serving dry overcooked food or dangerously undercooked food. They are much faster and much more accurate than dial thermometers. YOU NEED ONE!

                              Click here for more info on the Maverick PT-55 Waterproof Instant-Read Thermometer Review shown above. It may be the best value in a thermometer out there


                              If you have a Weber Kettle, you need the Slow 'N' Sear

                              slow n sear

                              The Slow 'N' Sear turns your grill into a first class smoker and also creates an extremely hot sear zone you can use to create steakhouse steaks.

                              Click here for our article on this breakthrough tool


                              Bring The Heat With Broil King Signet's Dual Tube Burners

                              the good one grill

                              The Broil King Signet 320 is a modestly priced, 3-burner gas grill that packs a lot of value and power under the hood. Broil King's proprietary, dual-tube burners get hot fast and are able to achieve high, searing temps that rival most comparatively priced gas grills. The quality cast aluminum housing carries a Limited Lifetime Warranty.

                              Click here to read our complete review


                              The Good-One Is A Superb Grill And A Superb Smoker All In One

                              the good one grill

                              The Good-One Open Range is a charcoal grill with an offset smoke chamber attached. It is dramatically different from a traditional offset smoker. The grill sits low in front and doubles as a firebox for the smoke chamber which is spliced on above and behind so it can work like a horizontal offset smoker only better. By placing the heat source behind and under the smokebox instead of off to the side, Open Range produces even temperature from left to right, something almost impossible to achieve with a standard barrel shaped offset.

                              Click here to read our complete review


                              Pit Barrel Cooker Smoker

                              Griddle And Deep Fryer All In One

                              The flat top does the burgers and the fryer does the fries. Use the griddle for bacon, eggs, and home fries. Or pancakes, fajitas, grilled cheese, you name it. Why stink up the house deep frying and spatter all over? Do your fried chicken and calamari outside. Blackstone's Rangetop Combo With Deep Fryer does it all. Plus it has a built in cutting board, garbage bag holder, and paper towel holder. An additional work table on the left side provides plenty of counter space.

                              Click here to read our detailed review and to order


                              Pit Barrel Cooker Smoker

                              The Pit Barrel Cooker May Be Too Easy

                              The PBC has a rabid cult following for good reason. It is absolutely positively without a doubt the best bargain on a smoker in the world. Period. This baby will cook circles around the cheap offset sideways barrel smokers in the hardware stores because temperature control is so much easier. Best of all, it is only $299 delivered to your door!

                              Click here to read our detailed review and the raves from people who own them


                              The Undisputed Champion!

                              thermapen

                              The Thermoworks Thermapen MK4 is considered by the pros, and our team, to be the single best instant read thermometer. Don't accept cheap substitutes.  Click here to read our test results and comprehensive review and why it won our Platinum Medal .


                              Compact Powerful Sear Machine For Your Next Tailgater

                              Placeholder

                              Char-Broil's Grill2Go x200 is a super-portable, fun little sizzler made of heavy, rust-proof cast aluminum. The lid snaps shut. Grab the handle and you're off to the party! Char-Broil's TRU-Infrared design produces searing heat while reducing fuel consumption. A 16 ounce LP gas canister is enough to keep you flipping burgers for hours.

                              Click here to read our detailed review and to order


                              The Cool Kettle With The Hinged Hood We Always Wanted

                              NK-22-Ck Grill

                              Their NK22CK-C Charcoal Kettle Grill puts a few spins on the familiar kettle design. In fact, the hinged lid with a handle on the front, spins in a rotary motion 180 degrees. It's hard to beat a Weber kettle, but Napoleon holds its own and adds some unique features to make the NK22CK-C a viable alternative.

                              Click here for more about what makes this grill special


                              Placeholder

                              G&F Suede Welder's Gloves

                              Heat Resistant Gloves With Extra Long Sleeves Hold The Hot Stuff

                              If you're using oven mitts at the grill, it's time to trade up. Say hello to these suede welder's gloves. They're heat resistant enough to handle hot grill grates, and flexible enough to handle tongs. The extra long sleeves even let you reach deep into the firebox to move hot logs without getting burned. Our Fave.

                              Click here to read our detailed review

                              Click here to order from Amazon


                              GrillGrates Take Gas Grills To The Infrared Zone

                              grill grates

                              GrillGrates(TM) amplify heat, prevent flareups, make flipping foods easier, keep small foods from committing suicide, kill hotspots, are easier to clean, flip over to make a fine griddle, and can be easily removed and moved from one grill to another. You can even throw wood chips, pellets, or sawdust between the rails and deliver a quick burst of smoke to whatever is above. Every gas grill needs them.

                              Click here for more about what makes these grates so special


                              PK 360 grill

                              Is This Superb Charcoal Grill A Kamado Killer?

                              The PK-360, with 360 square inches of cooking space, this rust free, cast aluminum charcoal grill is durable and easy to use. Four-way venting means it's easy to set up for two zone cooking with more control than single vent Kamado grills. It is much easier to set up for 2-zone cooking than any round kamado. Beautifully designed and completely portable. Meathead says it is his preferrred grill.

                              Click here to read our detailed review of the PK 360

                              Click here to order it direct from PK and get a special deal for AmazingRibs.com readers only


                              kareubequ bbq smoker

                              Our Favorite Backyard Smoker

                              The amazing Karubecue is the most innovative smoker in the world. The quality of meat from this machine is astonishing. At its crux is a patented firebox that burns logs above the cooking chamber and sucks heat and extremely clean blue smoke into the thermostat controlled oven. It is our favorite smoker, period.

                              Click here for our review of this superb smoker


                              Masterbuilt MPS 340/G ThermoTemp XL Propane Smoker

                              masterbuilt gas smoker

                              The First Propane Smoker With A Thermostat Makes This Baby Foolproof

                              Set ThermoTemp's dial from 175° to 350°F and the thermostat inside will adjust the burner just like an indoor kitchen oven. All you need to do is add wood to the tray above the burner to start smokin'.

                              Click here to read our detailed review


                              Professional Steakhouse Knife Set

                              masterbuilt gas smoker

                              Our founder, Meathead, wanted the same steak knives used by steakhouses such as Peter Luger, Smith & Wollensky, Morton's, Kobe Club, Palm, and many others. So he located the manufacturer and had them stamp our name on some. They boast pointed, temper-ground, serrated, high-carbon stainless-steel, half-tang blades with excellent cutting edge ability. The beefy hardwood handle provides a comfortable grip secured by three hefty rivets. He has machine washed his more than 100 times. They have never rusted and they stay shiny without polishing. Please note that we do not make, sell, or distribute these knives, they just engrave them with our name.

                              Click here to read our detailed review and to order


                              Fireboard: The Ultimate Top Of The Line BBQ Thermometer

                              fireboard bbq thermometer

                              With the ability to monitor up to six temperatures simultaneously with either Bluetooth or Wifi on your mobile phone, tablet, or computer, Fireboard is the best digital thermometer we’ve tested.

                              Click here to read our detailed review


                              Finally, A Great Portable Pellet Smoker

                              Green Mountain Davey Crockett Grill

                              Green Mountain's portable Davy Crockett Pellet Smoker is one mean tailgating and picnic machine. But it's also gaining popularity with people who want to add a small, set it and forget it pellet smoker to their backyard arsenal. And with their WiFi capabilities you can control and monitor Davy Crocket from your smart phone or laptop.

                              Click here to read our detailed review and to order