Hi Everyone,
I've put together some tools in excel that I find useful for doing various calculations. Things like calculating the PSI I end up with when I pile on different weights, or for determining how much weight I need for a given PSI. I also use a page for keeping track of the temperature rise during those long slow periods of "raise temperature from 30 to 35 degrees over 45 minutes" type of things. Basically, you just enter your temperatures every so often and it plots what you have against where you should be. This lets you know if you're on the correct heat tragecotry (i.e. do you have to warm things more or less). Also, I put together a tool for determining the time to cut based upon the floc method (i.e. enter the time you added the rennet, the time your milk gelled, and the floc multiplier, and it gives you the time to cut the curd!). There's also a tool for calculating how much rennet of a new strength you should use to get similar results to your old rennet. So if you go from a single strength IMCU rennet of 180 to some microbial rennet with a strength of IMCU 750, how much should you use as a starting point?
Anyway, I thought others might find these useful. The work book is in Excel 97 format and created on a PC. If anyone finds any errors or bugs in the calculations, please let me know and I'll try to fix them. They seem ok to me.
- Jeff
P.S. I found a mistake in these versions on the PSI page (the tool that reports the required kilo's to obtain a given PSI is incorrect; it converts the pounds to kilos by multiplying the pounds when it should divide, so it tells you too much weight). I've attached a corrected version a few posts down, and also explain how you can fix the formula if you have downloaded one of these versions already.