Instagram AmazingRibs Facebook AmazingRibs X - Meathead Pinterest AmazingRibs Youtube AmazingRibs

Welcome!


This is a membership forum. Guests can view 5 pages for free. To participate, please join.

[ Pitmaster Club Information | Join Now | 30 Day Trial | Login | Contact Us ]

Only 4 free page views remaining.

Announcement

Collapse
No announcement yet.

I need help with a Sausage Spreadsheet

Collapse
X
 
  • 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.

    THE WRONG WAY
    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.

    THE RIGHT WAY
    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

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

    FORMULA FOR FATTY MEAT
    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.

    #2
    It is now called the "Ground Meat Calculator" and it as well as all our other calculators is on this page


    Bookmark it!

    Comment


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

      Comment


        #4


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

        Ya shoulda jus called..

        Comment


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

          Comment


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

            rob

            Comment


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

              Comment


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

                Comment

                Announcement

                Collapse
                No announcement yet.
                Working...
                X
                false
                0
                Guest
                Guest
                500
                ["membership","help","nojs","maintenance","shop","reset-password","authaau-alpha","ebooklogin-start","alpha","start"]
                false
                false
                Yes
                ["\/forum\/free-deep-dive-guide-ebook-downloads","\/forum\/free-deep-dive-guide-ebook-downloads\/1157845-paid-members-download-your-6-deep-dive-guide-ebooks-for-free-here","\/forum\/the-pitcast","\/forum\/national-barbecue-news-magazine","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2019-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2020-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2021-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/bbq-news-magazine-2022-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2023-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2024-issues","\/forum\/national-barbecue-news-magazine\/national-barbecue-news-magazine-aa\/current-2025-issues","\/forum\/bbq-stars","\/forum\/bbq-stars\/tuffy-stone","\/forum\/bbq-stars\/meathead","\/forum\/bbq-stars\/harry-soo","\/forum\/bbq-stars\/matt-pittman","\/forum\/bbq-stars\/kent-rollins","\/forum\/bbq-stars\/dean-fearing","\/forum\/bbq-stars\/tim-grandinetti","\/forum\/bbq-stars\/kent-phillips-brett-gallaway","\/forum\/bbq-stars\/david-bouska","\/forum\/bbq-stars\/ariane-daguin","\/forum\/bbq-stars\/jack-arnold","\/forum\/free-deep-dive-guide-ebook-downloads"]
                /forum/free-deep-dive-guide-ebook-downloads