Two Excel Spread Sheets That Will Help
Two Excel Spread Sheets That Will Help
A friend of mine made these spread sheets and I find them very useful.
Here is a base excel spread sheet that will recalculate your spices for different batch sizes.
It will allow you to change sausage batch sizes and all the spices are recalculated for you, including the cure weights.
Just down load it from google docs. and put in your own recipe.
https://docs.google.com/file/d/0B1ttuCf ... UxQkk/edit
And here is a excel spread sheet for a spice conversion file. It is to change everything to grams.
https://docs.google.com/file/d/0B1ttuCf ... dHNkk/edit
You will have to have a gram scale but they are rather cheap and you will have to convert your recipes to grams but I have provided a conversion chart for that. Converting things to weights allows the sheet to recalculate the spice weights as you change batch sizes. Just remember you need to go to FILE in the upper left hand corner and hit DOWNLOAD.
Here is a base excel spread sheet that will recalculate your spices for different batch sizes.
It will allow you to change sausage batch sizes and all the spices are recalculated for you, including the cure weights.
Just down load it from google docs. and put in your own recipe.
https://docs.google.com/file/d/0B1ttuCf ... UxQkk/edit
And here is a excel spread sheet for a spice conversion file. It is to change everything to grams.
https://docs.google.com/file/d/0B1ttuCf ... dHNkk/edit
You will have to have a gram scale but they are rather cheap and you will have to convert your recipes to grams but I have provided a conversion chart for that. Converting things to weights allows the sheet to recalculate the spice weights as you change batch sizes. Just remember you need to go to FILE in the upper left hand corner and hit DOWNLOAD.
Because I keep a note book with one page for each batch of sausage that I make It is easy to determine the ratio of the new batch to the one kilogram standard recipe. When I know the ratio then it is a simple matter of multiplying the ratio times the weight of each spice ingredient in the one kilogram recipe and writing it in the book. The when I weigh the ingredient I place a check mark next to that item.
For example, since I don't have a metric scale for large loads, my meats weights are always in pound and ounces. So a 3 pound 7 ounce piece of meat becomes 3&7/16 pounds or 3.44 pounds. one kilogram is 2.2 pounds so 3.44/2.2=1.56 and that is the ratio of my batch to the book recipe. Therefore I enter 1.56 in the memory on my calculator and use that as the multiplier for each ingredient.
For example, since I don't have a metric scale for large loads, my meats weights are always in pound and ounces. So a 3 pound 7 ounce piece of meat becomes 3&7/16 pounds or 3.44 pounds. one kilogram is 2.2 pounds so 3.44/2.2=1.56 and that is the ratio of my batch to the book recipe. Therefore I enter 1.56 in the memory on my calculator and use that as the multiplier for each ingredient.
Ross- tightwad home cook
Well good for you Ross, you seem to be a very talented person. That excel sheet is for people who are not as talented as you are. This is a good way for someone just starting out not to make mistakes. There are programs on the market that charge an arm and a leg that do the same thing and all I'm doing is giving the beginners and the old ones who have brain f*rt something easy as pie to keep track of there recipes for free. This can be printed out for fast reference and you can check off your spices as you go along also.
ssorllih wrote:Because I keep a note book with one page for each batch of sausage that I make It is easy to determine the ratio of the new batch to the one kilogram standard recipe. When I know the ratio then it is a simple matter of multiplying the ratio times the weight of each spice ingredient in the one kilogram recipe and writing it in the book. The when I weigh the ingredient I place a check mark next to that item.
For example, since I don't have a metric scale for large loads, my meats weights are always in pound and ounces. So a 3 pound 7 ounce piece of meat becomes 3&7/16 pounds or 3.44 pounds. one kilogram is 2.2 pounds so 3.44/2.2=1.56 and that is the ratio of my batch to the book recipe. Therefore I enter 1.56 in the memory on my calculator and use that as the multiplier for each ingredient.
- Baconologist
- Passionate
- Posts: 385
- Joined: Fri Apr 06, 2012 00:37
- Location: Oxford, New Jersey
- Chuckwagon
- Veteran
- Posts: 4494
- Joined: Tue Apr 06, 2010 04:51
- Location: Rocky Mountains