Sausage recipe in Excel question

Beginners FAQ on sausage making, meat curing etc may often be found at the head of each relevant section, but here is the place to ask experienced users for advice if you are still stuck or need more information...we're here to help!

Sausage recipe in Excel question

Postby senorkevin » Tue Jun 24, 2014 3:11 am

I was entering some of my recipes into excel today and when I added up the percentages they came out at 100.37% and 100.9%.
Is this because I am adding too much spices into the meat weight?
An Englishman living in México.
There'e not such thing as a stupid question, just a stupid answer!
senorkevin
Registered Member
 
Posts: 354
Joined: Tue May 01, 2012 12:47 pm
Location: Mexico

Re: Sausage recipe in Excel question

Postby wheels » Tue Jun 24, 2014 12:10 pm

Any particular recipe?

Phil
User avatar
wheels
Global Moderator
 
Posts: 12177
Joined: Sat Sep 02, 2006 4:29 pm
Location: Leicestershire, UK

Re: Sausage recipe in Excel question

Postby senorkevin » Tue Jun 24, 2014 12:53 pm

I dont know where I got the recipe but one of them is sweet Italian N.Y.
I tuned it to the wife taste (less of that and more of this).
I assumed that everything will always add upto 100% but the meat percentage would go down.
An Englishman living in México.
There'e not such thing as a stupid question, just a stupid answer!
senorkevin
Registered Member
 
Posts: 354
Joined: Tue May 01, 2012 12:47 pm
Location: Mexico

Re: Sausage recipe in Excel question

Postby wheels » Tue Jun 24, 2014 1:28 pm

Sorry, is it me?

It stands to reason, if you alter the recipe, it won't add up to what it did before you altered it!
User avatar
wheels
Global Moderator
 
Posts: 12177
Joined: Sat Sep 02, 2006 4:29 pm
Location: Leicestershire, UK

Re: Sausage recipe in Excel question

Postby ped » Tue Jun 24, 2014 3:54 pm

Just adjust the percentage of what you like or don't like in the formula to make it come to 100% but don't mess with cure quantities (if any is included?),the amounts you quote are pretty nominal ?
ped
Registered Member
 
Posts: 386
Joined: Fri May 08, 2009 11:03 am
Location: Kent

Re: Sausage recipe in Excel question

Postby senorkevin » Thu Jun 26, 2014 10:56 pm

The amounts are low. As I said I would assume that it would still add upto 100% as the meat is calculated last
An Englishman living in México.
There'e not such thing as a stupid question, just a stupid answer!
senorkevin
Registered Member
 
Posts: 354
Joined: Tue May 01, 2012 12:47 pm
Location: Mexico

Re: Sausage recipe in Excel question

Postby wheels » Thu Jun 26, 2014 11:51 pm

Sorry, this is getting more bizarre with each post.

If you change quantities of ingredients, then re-calculate the percentages, if they don't add up to 100%, then it's a maths error on your part.

If you alter the amounts and still expect the recipe to add up to 100%, without re-calculating the percentages, then you need to do so.

Are you lot trying to wind me up?

Phil
User avatar
wheels
Global Moderator
 
Posts: 12177
Joined: Sat Sep 02, 2006 4:29 pm
Location: Leicestershire, UK

Re: Sausage recipe in Excel question

Postby ped » Fri Jun 27, 2014 5:38 am

Sorry Phil I see what you mean about my input!!, I was referring to the meat being 100% and then % thereof of salt, cure and spices, in the context of making salami :oops:
ped
Registered Member
 
Posts: 386
Joined: Fri May 08, 2009 11:03 am
Location: Kent

Re: Sausage recipe in Excel question

Postby wheels » Fri Jun 27, 2014 12:43 pm

No probs, but it all seemed to be getting more bizarre by the moment!

The original differences are very small and probably just from rounding the figures.

Here's how to set up the spread sheet formulas to show 100% - you can alter figures in column B and Column C will always add up to 100%:

Image

HTH

Phil
User avatar
wheels
Global Moderator
 
Posts: 12177
Joined: Sat Sep 02, 2006 4:29 pm
Location: Leicestershire, UK


Return to Beginners

Who is online

Users browsing this forum: wheels and 2 guests