I presume you are dealing with medicines or other temperature sensitive products and have you wondered at some point about the calculation of MKT? Read on.

## What is Mean Kinetic Temperature in basic language?

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 for this period. This temperature value is what the stored goods effectively feel during the mentioned time. This is not the arithmetical average of the readings.

Mean Kinetic Temperature is calculated for understanding effects of variations in temperature for temperature-sensitive goods during storage and transportation.

A sample from our data logger in the image on the right side indicates the MKT value automatically generated in its report. Nowadays we do not need to calculate MKT manually. You can simply place a temperature data logger and the reports will automatically indicate the MKT value.

Have you wondered the difference between Mathematical Average value and Mean Kinetic Value?

The calculation is different from the Average value which is the sum total of the values divided by the count of the values. Mean Kinetic value is slightly higher than average value.

This is particularly important for storage and transportation of medicine, vaccines etc.

### Example of application of Mean Kinetic Temperature

In layman’s language this is explained below:

As an example, Free Excel software for automatic calculation of MKT of multiple data loggers we will consider that a medicine which has to be maintained between 2-8 °C is transported for 10 hours. A temperature data logger is kept inside the box for recording the temperature continuously. At the end of the transportation, the recorded temperature data is downloaded and verified. At this point suppose that the temperature has gone above 8 °C couple of times and below 2°C couple times. As the medicine is always to be kept between 2 and 8°C, you are not sure whether the medicine is acceptable or not since the temperature has gone above 8°C few times or below 2°C few times for different durations. In this case, you can check the MKT value of the 10 hours period and if the MKT value is within 2-8°C, the medicine is still considered to have retained all its properties.

Hence MKT for a substance can be defined as the calculated value derived from the complete recording over a specified period of time. If this value is within the permitted values, the substance is still considered to be safe.

## How to Manually calculate Mean Kinetic Temperature in Excel Sheet?

Would you be interested in the simplest way using an Excel sheet? All of you are familiar with Excel and hopefully, this will be the simplest calculation method.

You may download the free excel sheet which defines a function namely “MKT”. This function can be used similarly to any other function such as SUM, AVERAGE etc.

If you do not want to calculate manually, we encourage you to **Download the free Excel sheet**

### Manual calculation Step by Step

The step by step method of calculating MKT is as below:

- Convert °C to Kelvin by adding 273.15 to each reading.
- Calculate Delta H/(Gas Constant x Temperature Reading). Delta H =83.14472 kJ/mole & Gas Constant = 0.008314472 kJ/mole/degree.
- Calculate the sum of all results of Step 2.
- Divide the result of Step 3 by the number of readings.
- Calculate natural logarithm of the result in Step 4.
- Calculate the numerator Delta H divided by Gas Constant.
- Calculate result of Step 5 by result of Step 6.
- Convert Kelvin to Degree Centigrade. This gives the MKT value.

The detailed method of above steps are explained below:

First of all, you will download the data from the temperature data logger or temperature and humidity data logger. (MKT is applicable for Temperature only and not for Humidity) Assuming that the data is recorded at equal intervals, this is the formula for calculation of Mean Kinetic Temperature:

Delta H is the Activation Energy: 83.14472 kJ/mole

R is the Gas Constant: 0.008314472 kJ/mole/degree

Conversion of °C to K: Add 273.15

Now we’ll go step by step starting with the denominator, which is complex:

We have considered sample data with only six readings.

#### Step 1: Convert °C to Kelvin by adding 273.15 to each reading

The MKT value is always calculated in Degree Kelvin. If your readings are in°C or °F, the same has to be firstly converted to Kelvin. The resultant MKT value also will be in Kelvin, which then has to be converted back to your required units

#### Step 2: Calculate the following for each reading:

Delta H/(Gas Constant x Temperature Reading)

Both step 1 & 2 are detailed in the following:

Excel formula for above example for first reading

=Exp(-83.14472/(0.008314472 x 292.95)

Result =1.49714 E-15 for first reading.

#### Step 3: Calculate sum of all results of Step 2

This is simple! Simply sum up all values in column G.

Excel Formula in the above example for step 3:

=SUM(G11: G16)

Result = 1.00339E-14

#### Step 4: Divide the result of Step 3 by number of readings

In this example, a total number of readings is 6. So divide the above results by 6.

Excel Formula in the above example for step 4:

=SUM(G11: G16)/6

Result = 1.67232E-15

#### Step 5: Calculate natural logarithm of result in Step 4

Excel formula in the above step is

=(LN(SUM(G11:G16)/6)) x -1

Result =34.0246

#### Step 6: Calculate numerator

The numerator is Delta H divided by Gas Constant.

#### Step 7 : Calculate numerator by denominator

=10/34.0246

Result = 293.903

#### Step 8: Convert Kelvin to Degree Centigrade

Excel calculation method:

=293.903-273.15

Result= 20.7530 °C

Hence the MKT value is 20.7530 °C.

## Free Excel Template Sheet for calculating MKT

**Download the free Excel sheet **here

All the data has to be listed vertically. At the end of the last cell simply insert the formula =MKT(B1: B100). This will produce MKT value of the range of values from B1 to B100. There is no limitation to the range and you may include any number of data. Simply replace the range B1: excelB100 with your corresponding range.

This excel sheet also calculates Minimum, Maximum, Average values of the range of temperature values.

Should you require any clarification on the same you may please contact us.

## Explanation of formula for Mean Kinetic Temperature (MKT)

The calculation method is a bit complicated as below. Look puzzled? Go to Excel sheet above and do it by simple means.

The calculation formula for MKT is explained below. This formula is already incorporated in the Excel sheet above.

### Short form of the formula for MKT

### Detailed formula for calculation of MKT

Do you find the above calculation to be tough? Please feel free toDownload the free Excel sheet!!

### Temperature Dataloggers with inbuilt MKT value calculation

We supply various types of data loggers which have an inbuilt calculation of Mean Kinetic Temperature. Our Temperature data loggers, as well as Temperature and Humidity Data Loggers, give the MKT value of the complete readings as part of the report. The MKT value is calculated from the first reading to the last reading. So when you receive a box of medicines, you can download the data from the temperature data logger and check individual values as well as the MKT value. A sample report of one such data logger is given in this image.

#### How to use data loggers for calculating MKT?

We will consider few examples of calculation of MKT using data loggers.

- For transporting a box containing a medicine, you have to keep a temperature data logger inside the box. As soon as you keep the medicine inside the box, start the data logger and keep inside the box. Then you can dispatch the box. When the user receives the box, he will take the data logger and download the data. Then generate the pdf report. The report will show the MKT value as in this image to the right side.
- If you want to find out the MKT inside a cold room, you may keep Temperature and Humidity data loggers at the hot and cold points. If you want weekly data, you can start the data logger at the beginning of the week. You may keep a start delay of 10 minutes so that the recording settles down. At the end of the week, download the data and you may see the MKT value in the report.
- Another application is for finding out MKT inside refrigerators (medical fridges). If you want monthly data calculation, you can keep the data logger inside the refrigerator after starting at the beginning of the month. At the end of the month, download the data and see the automatically generated report to see the individual readings and the MKT value.

###### How to use our Excel Calculation Sheet?

The entire calculation explained above is programmed in the excel sheet. If the readings are in Degree Centigrade, you have to simply use the function =MKTc after marketing the desired range. This function is exactly similar to the usage of =SUM in Microsoft Excel. If your readings are in Degree Fahrenheit, you have to use the function =MKTf. It is that simple.

###### Please fill up the form to instantly receive the calculation sheet. If you do not receive download link, please send us email at contact.en@vackerglobal.com.

###### Revision history of this Excel calculation tool:

- Rev 0, 17-Feb-2014: Original version
- Rev 1, 13-Oct-2014: Separate sheet added for Fahrenheit & published online
- Rev 2, 23-Feb-2015: ΔH & R defined in the first two sheets
- Rev 3, 09-Mar-2015: Formatting changes only
- Rev 4, 15-May-2015: Formatting changes only
- Rev 5, 25-Jun-2015: Formatting changes only
- Rev 6, 25-Sep-2017: Major changes for increased functionality. The full & free version now made available online.
- Rev 7, 06-Feb-2018: Formatting changes only

**Also please see our article: Is MKT still relevant for Pharmaceuticals? How will MKT misguide you?**

Please visit our online data logger store for all types of data loggers.

As a biomedical engineer, is very important to have a knowledge of how the temperature affects to the products, and this is an important tool.

Thanks

looking for a spreadsheet

You can download from this webpage

Request a copy of the spreadsheet to calculate mean kinetic temperature.

We will forward a copy to your email

Please send to my email:

tiyas986@yahoo.com

Now it is available at : https://store.vackerglobal.com/documents/mean-kinetic-temperature-mkt-excel-sheet

looking for a spreadsheet to calculate mkt

You can download from this webpage

Thank you

Thanks

thx

Free?

Yes

Muchas gracias por el archivo

You are welcome.

i like Excel… lol

Thanks

merci

You are welcome

thank you in advance

Thank you

Thanks

The excel sheet is protected and i cant insert a lot of data on the excel sheet pleas can you help?

Please send a mail to our email sales at vackerglobal.com with your company details.

thanks

Thanks!

We appreciate your support

how do you calculate MKT for multiple set of readings within specified period, but without equal interval between those records….?

Will you please send your query to our email indicated at the top, so that our technical team will take care.

Please give the clarity about Delta H value

How you are taking the Delta H as 83.144

Is it constant or any calculation is there

It is a constant

Hi. Your units don’t match. Either EA needs to be in J/mol or R needs to be in KJ/mol*K. Other than that, great explanation of the concept. Very helpful.

Hi. Your units don’t match. Either EA needs to be changed to J/mol or R needs to be changed to KJ/mol*K. Other than that, great explanation of the concept. Very useful.

We will check and revert

It was a typo in the writeup, which is now corrected. The excel sheet calculates it correctly.

I have download the Excel sheet it is a great, however, I amcan advise not able to insert more row. Hope you can help.

We will forward complete spread sheet

Thank you SO much for this spreadsheet. It saved my report!

Do you have a spreadsheet for Mean Kinetic Relative Humidity?

Much respect to you for making this, you are very smart!

Thanks. For relative humidity, there is no Kinetic value. Please send your detailed requirement to sales.uae@vackerglobal.com and one of our team members will help.

je demande une feuille Excel pour le calcul de MKT

Nous vous enverrons

Excellent detailed explanation about MKT

Thanks you very much, it helped me more.

You are welcome

Thank you

You are welcome. Please share the page with your friends on linkedin

I have downloaded the excel spreadsheet but it is protected and can not add more rows to do teh calculation

Could you help me?

Please send an email to sales.en@vackerglobal.com from your official email id

The excel sheet is protected and i cant insert a lot of data on the excel sheet pleas can you help?

The full version is made available for companies. Please send an email from your official email id.

Opened this to receive free spreadsheet download – will comment once I try it

Thanks. Please revert if you need any assistance.

Hi, I am not able to unlock the free download.

I sign with google plus but nothing is happening..

Could you please help?

thanks in advance

We will forward the excel file. Please send an email to our email id sales at vackerglobal.com

Excelente !!

Hi.

Please, send me MKT calculation free Excel Sheet.

Thank you.

Please send an email to our office sales.en@vackerglobal.com

thanks

Por favor cómo puedo descargarme el excel ??

Enviaremos a su correo electrónico

wonder if you have native version of spreadsheet to add more rows of data.

Yes we provide the same free of charge. We will forward the same to you

Would greatly appreciate being sent the excel MKT spreadsheet

We will forward the same. I request you to send us an email to sales.en@vackerglobal.com

Thank you so much for your free Excel spreadsheet! We were able to use it to determine if our pharmaceutical inventory storage spaces were affected by the Northern California fires.

We are glad that we could be of assistance during your stressful times.

I have been trying to download the Excel worksheet to calculate MKT. I keep getting a link to the same page and have requested the spreadsheet many times without success. can anyone help?

The download link had a temporary problem. We will send you by email within today.

Thank you for sharing clear steps of MKT calculation. It helped me alot.

If someone is following the written instructions to cross-check the calculation, the mathematical terms are wrong.

numerator = upper part of the fraction

denominator = lower part of the fraction

Thanks. The Typo is now corrected.

May I get a copy of the spreadsheet, don’t seem to work when downloading it. Many thanks.

Hi Ati,

In order to receive the spreadsheet, please fill in the form on the same page (https://www.temperaturemonitoringuae.com/how-to-calculate-mean-kinetic-temperature-mkt-in-excel/#signup), following which an email would be sent to you containing the download link.

Did you receive it? We will send you a free copy through email too.

excel file do not arrive!

Hi Fernando de la Rosa,

In order to receive the spreadsheet, please fill in the form on the same page (https://www.temperaturemonitoringuae.com/how-to-calculate-mean-kinetic-temperature-mkt-in-excel/#signup), following which an email would be sent to you containing the download link.

Hi,

Could you please sent me the excel MKT spreadsheet ?

Thank you in advance

Céline De Schrijver

You can buy the same at https://store.vackerglobal.com/documents/mean-kinetic-temperature-mkt-excel-sheet

I have been done the rough calculation of MKT and observed value is 5.586. I am looking for, how can I correlate with this MKT value to temperature excursions. Refrigerator temperature is 2- 8°C and some times it went upside upto 12°C. It may happen during operation time or some other conditions. Excursion is actually a deviation and how can I address this excursions in SOP and avoid deviation.

Your query is not clear. However, I will try to answer. Suppose you kept a medicine yesterday morning at 10.00 am and are checking taking it out today morning at 10.00 am. The refrigerators might have experienced few excursions during this 24 hours. Assuming that you have a data logger with data recording for this 24 hours, you will find out the MKT for this 24 hours. If the MKT value is within 2 to 8, then the medicine is acceptable. (This example is to explain the usage of MKT, without any commitments from our side whatsoever)