Batch Calculator

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!

Batch Calculator

Postby sausagemaker » Sat Apr 28, 2007 10:43 am

Hi All

I have just made a small batch calculator in excel for changing the recipes you find to the correct weights for your batch.

I hope you find it usefull
Thanks to Spuddy for suppling the hosting

Click below for the download
http://www.lartigiano.co.uk/Documents/BatchCalc.xls

Regards
Sausagemaker
Advice
Often sought, seldom taken
sausagemaker
Registered Member
 
Posts: 803
Joined: Wed Sep 01, 2004 9:52 am
Location: Cumbria

Postby Spuddy » Sat Apr 28, 2007 11:17 am

Nice one Richard. That is going to be SO useful.
Thanks a lot.
Draco dormiens nunquam titillandus.
User avatar
Spuddy
Site Admin
 
Posts: 1315
Joined: Thu Jul 22, 2004 6:00 pm
Location: Angmering, West Sussex, UK.

Postby akesingland » Sat Apr 28, 2007 2:13 pm

Hi,

Thanks for that. I just created something similar, mainly to scale down recipies using 3 kilos plus of meat. I often go to the butchers/shops to get my meat so it allows me to scale all the other ingredients down to fit what meat I have. So on my version it works the percentages out from the original recipie. It isn't too happy with spoon measures though!

Cheers
Adam
User avatar
akesingland
Registered Member
 
Posts: 126
Joined: Mon Jan 23, 2006 11:21 am
Location: Harrow, Middlesex, UK

Postby porker » Sun Apr 29, 2007 2:22 pm

Great piece of work...Thanks I'll be using that!

Regards,

:)
porker
Registered Member
 
Posts: 259
Joined: Thu Feb 02, 2006 7:29 pm

Postby Spuddy » Sat May 19, 2007 8:34 am

Just made this a "Sticky"
Draco dormiens nunquam titillandus.
User avatar
Spuddy
Site Admin
 
Posts: 1315
Joined: Thu Jul 22, 2004 6:00 pm
Location: Angmering, West Sussex, UK.

Postby aussieinor » Sun Jun 01, 2008 5:21 am

Hey Guys,

I've been using this calculator a few times and also reviewing it. I have a couple of questions regarding it that maybe someone can clear up for me.

When adding the seasoning as a % based on meat weight, this calculator seems to give incorrect amount of spices (if you have rusk, water or anything else) as it adds this to the overall finished product. Therefor, we are adding much more spices (seasonings) that what is needed.

i.e. If I want 25kgs of finished product for Pork Shoulder, Belly, Breadcrumbs and water; the total weight for meat is 20.5 kgs and water/rusk/seasonings is 4.5 kgs. The seasonings should be calculated at 20.5 kgs and not the total 25kgs.

Am I correct on adding the % of seasoning to finished meat weight or not?

Doing it this way, it also has you add seasoning (below part of calculator) to the seasoning weight (upper part of calculator).

I hope this makes sense to you guys as I think I've now confused myself.

Cheers guys.
aussieinor
Registered Member
 
Posts: 59
Joined: Wed Sep 13, 2006 12:52 pm

Postby sausagemaker » Sun Jun 01, 2008 11:19 am

Hi Aussienoir

The % of seasoning is based on finished product that is to say if you are using 2.5% seasoning then the remaining ingredients add up to 97.5%

In a 25 kg batch you would have 625 grms seasoning & 24.375 of meat water & rusk.

Regards
Sausagemaker
Advice
Often sought, seldom taken
sausagemaker
Registered Member
 
Posts: 803
Joined: Wed Sep 01, 2004 9:52 am
Location: Cumbria

Postby alesypalsy » Sun Aug 10, 2008 12:05 pm

Excellent stuff thanks, I shall be using and I am new to it.
cheers
alesypalsy
Registered Member
 
Posts: 22
Joined: Sat Aug 09, 2008 3:42 pm
Location: Philippines

weights to spoon converter

Postby DrAndy » Thu Oct 23, 2008 5:40 pm

Anyone know of a chart to convert weight of herbs and spices to spoon sizes?

Thanks in advance
DrAndy
Registered Member
 
Posts: 4
Joined: Thu Oct 23, 2008 2:29 pm

Postby sausagemaker » Thu Oct 23, 2008 6:26 pm

Hi DrAndy

Please see link below

http://forum.sausagemaking.org/viewtopi ... highlight=

Regards
Richard
Advice
Often sought, seldom taken
sausagemaker
Registered Member
 
Posts: 803
Joined: Wed Sep 01, 2004 9:52 am
Location: Cumbria

Postby DrAndy » Thu Oct 23, 2008 6:37 pm

many thanks
DrAndy
Registered Member
 
Posts: 4
Joined: Thu Oct 23, 2008 2:29 pm

Thanks

Postby spanner » Fri Oct 31, 2008 5:37 am

Great help, cheers. I've always calculated the seasoning against the weight of the meat, which explains why I've always had to test fry a few times until I got it right.

Not that there's anything wrong with test frying :mrgreen:
Hernia & Hobart should be next to each other in the dictionary, not 8 pages apart.
spanner
Registered Member
 
Posts: 17
Joined: Fri Oct 31, 2008 5:05 am
Location: Czech Rep.

Postby rocky » Sun Mar 08, 2009 8:37 pm

Thanks so much. We'll get some use out of that . Nice job. :!:
Rocky
User avatar
rocky
Registered Member
 
Posts: 5
Joined: Sun Jan 18, 2009 1:49 am
Location: Lecanto, Florida

thanks!

Postby Dazzajapan » Thu Jul 02, 2009 2:10 am

A great find for those of us who are mathematically incapacitated! :P
Dazzajapan
Registered Member
 
Posts: 37
Joined: Tue Jun 30, 2009 12:54 am
Location: Osaka,Japan

numbers arent fun

Postby spudeye » Sat Aug 22, 2009 12:04 am

Hi all
If I have a recipe or brain flash that is given in kg /lb I just add the total weight of everything , like EVERY thing up and use that as batch amount. Just not sure if I include the .02 gram of spicesetc as example to reach total batch for when I want to scale down or up a recipe.
Simple I guess for U experts but a brain snapper for a dumby LOL.
thanks Graham
Newbie but getting better.
spudeye
Registered Member
 
Posts: 78
Joined: Tue Jun 24, 2008 3:07 pm
Location: Perth , WA, Ozzie

Next

Return to Beginners

Who is online

Users browsing this forum: No registered users and 4 guests