A tip for how to calculate the required amounts to mix for a target temperature with the prerequisite that you have two water supplies of known temperature (or one container with a known temperature that you wish to change)

No changes required for either Excel or OpenOffice Calc

How it looks when done; cells with Tempertatures and Target amount are for numbers you need to adapt for YOUR calculation.

Mix waterbath from cold and warm supplies
T/ºC Amount Liter
Warm 45 11.700
Cold 25 6.300
Target 38 18

… and here it is with the formulas visible, copy the dark area, paste it in cell A1:

Mix waterbath from cold and warm supplies
T/ºC Amount Liter
Warm 45 =(C5*ABS(B5-B4))/(ABS(B5-B4)+ABS(B5-B3))
Cold 25 =(C5*ABS(B5-B3))/(ABS(B5-B4)+ABS(B5-B3))
Target 38 18
Advertisements