Page 1 of 1

Sausage recipe in Excel question

PostPosted: Tue Jun 24, 2014 3:11 am
by senorkevin
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?

Re: Sausage recipe in Excel question

PostPosted: Tue Jun 24, 2014 12:10 pm
by wheels
Any particular recipe?

Phil

Re: Sausage recipe in Excel question

PostPosted: Tue Jun 24, 2014 12:53 pm
by senorkevin
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.

Re: Sausage recipe in Excel question

PostPosted: Tue Jun 24, 2014 1:28 pm
by wheels
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!

Re: Sausage recipe in Excel question

PostPosted: Tue Jun 24, 2014 3:54 pm
by ped
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 ?

Re: Sausage recipe in Excel question

PostPosted: Thu Jun 26, 2014 10:56 pm
by senorkevin
The amounts are low. As I said I would assume that it would still add upto 100% as the meat is calculated last

Re: Sausage recipe in Excel question

PostPosted: Thu Jun 26, 2014 11:51 pm
by wheels
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

Re: Sausage recipe in Excel question

PostPosted: Fri Jun 27, 2014 5:38 am
by ped
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:

Re: Sausage recipe in Excel question

PostPosted: Fri Jun 27, 2014 12:43 pm
by wheels
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