This is a membership forum. As a guest, you can click around a bit. View 5 pages for free. If you are a member you must log in now. If you would like to participate, please join.

[ Pitmaster Club Information | Join Now | Login | Contact Us ]

There are 4 page views remaining.


No announcement yet.

I need help with a Sausage Spreadsheet

  • Filter
  • Time
  • Show
Clear All
new posts

    I need help with a Sausage Spreadsheet

    Calculating how much fat you need to make sausage is not as simple as you might think. I have tried to write formulae that will help, but I am not good at this and I need someone who is to help by taking my formulae below and making them clearer and easier. FEEL FREE TO EDIT AS MUCH AS YOU WANT! Then I need someone to put this into a spreadsheet that is user friendly, something a home cook could use easily.

    This is the way most people calculate how much fat is needed and it is wrong: Let’s say I have 10 pounds of lean ground muscle, like beef rump or pork loin, and I want to make a sausage that is 30% fat. If I just add 3 pounds of ground fat to the ground meat I will get 13 pounds of sausage. But that is not 30%!

    If I divide the 3 pounds of fat by the 13 pounds of meat, I get 23% fat, not 30%! To get the right ratio you need this formula. I have rounded weights to one decimal.

    First a definition of terms
    MEAT = Weight of meat (let’s say 16 pounds)
    TARGET = % of fat desired (let’s say 30% fat, my favorite target)
    X = Variable to be calculated
    FAT = Weight of fat needed to achieve Target
    MARBLING = (% of fat in the Meat * Meat) = 1.6 pounds
    MUSCLE = Meat – (Meat * Marbling) = 16 – 1.6 = 14.4 pounds
    TOTAL = Final quantity of sausage

    So first we need to calculate the variable, X
    X = 100% - TARGET
    X = 100% - 30% = 70%
    X = 1 – 0.3 = 0.7

    (MEAT ÷ X) – MEAT = FAT
    (16 ÷ 0.7) – 16 = 6.9 pounds of FAT

    Now all this is fine if your meat is very lean like pork loin or beef rump, but if you are using a pork butt or beef chuck, you need to look at it and guestimate what the fat content is before you start grinding. It can be substantial, PERHAPS 20%, especially if there are large veins of fat. If it is about 20%, then subtract that from the weight of the MEAT to get the amount of MUSCLE. and from the amount of FAT you need to add. So here’s the formula:

    (MUSCLE ÷ X) – MUSCLE = TOTAL = (14.4 ÷ 0.7) – 14.4 = 6.2 total pounds of FAT needed
    6.2 pounds of FAT – 3.2 or 20% of 16 pounds = 3 pounds of added FAT needed
    Last edited by Meathead; February 15, 2021, 11:09 AM.

    It is now called the "Ground Meat Calculator" and it as well as all our other calculators is on this page
    Here are some very useful weights, measures, and equivalents that come in handy in the kitchen. You'll find an online conversion calculator for metric, imperial, volume, weight, length, and temperature, plus various handy food equivalents for salt, fat, sugar, and many other ingredients.

    Bookmark it!


      Nice work! I'll be using it for sure!



        Feb was busy, week afore my Birthday, an all...missed this, sry

        Ya shoulda jus called..


          Nice. Works good. The one at the bottom of the page just above the Related Articles does not work though.


            I think Sausage Spreadsheet would be a great name for a band.



              FYI for me the Ground Meat Calculator shows up twice, just above "Other" and again at the bottom.


                Jimmy Dean sausage,---Goodbye.
                The main problem is now I will have to try and make my own sausage.



                No announcement yet.


                These are not paid ads, they are a curated selection of products we love.

                All of the products below have been tested and are highly recommended. Click here to read more about our review process.

                Use Our Links To Help Keep Us Alive

                Many merchants pay us a small referral fee when you click our “buy now” links. This has zero impact on the price you pay but helps support the site.

                BBQ And Grilling Gifts For Every Occasion

                Looking for the perfect gift for the BBQ and grilling enthusiasts in your life? Here’s our suggestion for platinum and gold medal-winning products at a variety of price points. Click here to see our list of Gold Medal Gifts.

                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. It is beautifully designed, completely portable, and much easier to set up for 2-zone cooking than any round kamado. Click here to read our detailed review of the PK 360 and get a special AmazingRibs.com price!

                Grilla Proves That Good Things Come In Small Packages

                The small 31.5″ x 29.5″ footprint of the Grilla Pellet Smoker makes it ideal for use where BBQ space is limited, including on a condo patio. Click here for our review on this unique smoker.

                A Propane Smoker That Performs Under Pressure

                The Masterbuilt MPS 340/G ThermoTemp XL Propane Smoker is the first propane smoker with a thermostat, making this baby foolproof. All you need to do is add wood to the tray above the burner to start smokin’. Click here to read our detailed review.