This isn't a spreadsheet bout how about one step below.
This is a chart for 80/20 meat to fat. Just use the chart to figure out what you need to do.
80/20 makes the math simple and this chart is a simple mix and match to figure out the amount of fat for any weight of meat 1 pound or higher :)
How Much Fat Do I Need - 80% Meat, 20% Fat Chart
- 1 pound Meat, 0.25 pound Fat = 1.25 pound Mixed
- 2 pounds Meat, 0.5 pound Fat = 2.5 pounds mixed
- 4 pounds Meat, 1 pound Fat = 5 pounds mixed
- 8 pounds Meat, 2 pounds Fat = 10 pounds mixed
- 12 pound Meat, 3 pounds Fat = 15 pounds mixed
- 16 pounds Meat, 4 pounds Fat = 20 pounds mixed
- 20 pounds Meat, 5 pounds Fat = 25 pounds mixed
Lets use your 14 pounds of venison example.
Choose from the chart
the largest meat value that is Equal or as close to equal but NOT going over your amount of meat. Repeat until all of your meat is accounted for.
So, 12 and 2 from the chart will cover our 14 pounds of venison/meat.
Using the chart values now:
12 meat / 3 fat
+
2 meat / 0.5 fat
=
14 meat / 3.5 fat
You will need 3.5 pounds of Fat to go with 14 pounds of Venison/meat and the result will be 17.5 pounds of mix.
(14 meat + 3.5 fat = 17.5 mixed)
So even if you have an oddball number like 37 pounds of Venison you just use the chart and pick the meat values that add up to 37 pounds of meat:
20 meat (5 fat)
16 meat (4 fat)
1 meat (0.25 fat)
=
37 meat / 9.25 fat
(46.25 mixed)
I generally go the other route and try and figure out how much Mixed I want.
I then pull out the meat and the fat according to the chart below and then life is easy.
I do understand that with wild game sometimes you end up with an odd ball weight on scraps (6-7 pounds) so you want to use it up. That is why I have the chart above
Now you can use both charts and be well on your way to figuring out your mixes :)
Desired Mix 80% meat and 20% fat
- 1.25 pound Mixed = 1 pound Meat, 0.25 pound Fat
- 2.5 pounds mixed = 2 pounds Meat, 0.5 pound Fat
- 5 pounds mixed = 4 pounds Meat, 1 pound Fat
- 10 pounds mixed = 8 pounds Meat, 2 pounds Fat
- 15 pounds mixed = 12 pound Meat, 3 pounds Fat
- 20 pounds mixed = 16 pounds Meat, 4 pounds Fat
- 25 pounds mixed = 20 pounds Meat, 5 pounds Fat
And yeah.... it is a slow day at work for me so I have time to put all this stuff together in a post hahaha :D