mean kinetic temperature calculator excel

The next step is to sum the numerator and denominator of the natural log portion of the MKT calculation. The desired time period can be as long or short as desired.Ĥ. This can be done by creating a capsule with the Custom Condition tool. At this point, the desired time period to perform the MKT calculation over must be selected. $TimeInterval*CONSTANT.E^(-$H/CONSTANT.R/$temp)ģ. For this example, delta H was set to 83.14 kJ/mol: Calculate the exponential relationship for each sample point (t*exp(-deltaH/RT n)) using Seeq Formula.

$temp.tocapsules().aggregate(totalduration(),$temp.tocapsules(),startkey()).tostep()Ģ. In many cases these are evenly spaced and the formula simplifies, but in case they are not, this can be calculated in Seeq Formula by creating capsules for each data point and then aggregating the duration of those capsules: Calculate the time intervals for each of the data points (t n). This formula can be inserted into Seeq through a couple of steps:ġ. To are time intervals at each of the sample points To are the temperatures at each of the sample points in kelvins Is the mean kinetic temperature in Kelvin The formula for mean kinetic temperature is: Therefore, the mean kinetic temperature takes into account the exponential reaction rate to determine the average temperature weighted by the kinetics of the reaction over time. In general, product stability follows an exponential trend with temperature as it is inherently a decomposition reaction of the desired product. Mean Kinetic Temperature is a non-linear weighted average temperature that is set up to provide an impact on product stability. In many industries (pharmaceuticals, food and beverage, etc.), mean kinetic temperature (MKT) is used to measure the temperature fluctuations of a material during storage and shipment.

Mean kinetic temperature calculator excel