

A temperature data logger is kept inside the box for recording the temperature continuously.
#EVALUATE FORMULA EXCEL FOR MAC 2017 SOFTWARE#
In layman’s language this is explained below:Īs an example, with Free Excel software for automatic calculation of MKT of multiple data loggers, we will consider that medicine which has to be maintained between 2-8 ☌ is transported for 10 hours. This is particularly important for the storage and transportation of medicine, vaccines etc.Įxample of application of Mean Kinetic Temperature The mean Kinetic value is slightly higher than the average value. The calculation is different from the Average value which is the sum total of the values divided by the count of the values. Have you wondered the difference between the Mathematical Average value and Mean Kinetic Value? You can simply place a temperature data logger and the reports will automatically indicate the MKT value. Nowadays we do not need to calculate MKT manually. A sample from our data logger in the image on the right side indicates the MKT value automatically generated in its report. Mean Kinetic Temperature is calculated for understanding the effects of variations in temperature for temperature-sensitive goods during storage and transportation. This is not the arithmetical average of the readings. This temperature value is what the stored goods effectively feel during the mentioned time. If you have a set of temperature readings across a certain period of time, the Mean Kinetic Temperature across this period means effective average thermal value fo r this period. What is Mean Kinetic Temperature in basic language? If you are dealing with medicines or other temperature-sensitive products you can calculate Mean Kinetic Temperature using this MKT calculation sheet.
