I presume you are dealing with medicines or other temperature sensitive products and have you wondered at some point about the calculation of MKT? 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 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 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. Apr 4, 2014 - For all you math whizzes, for all you quadratic formula know-it-all's, the formula just may. Mean Kinetic Temperature Excel Sheet Calculator. Mix - Kaanta Laga - Baby Doll (2002) YouTube Pardesia yeh sach hai piya Feat Rakhi Sawant remix DJ Aqueel lyrics - Duration: 8:29. MisDeviated 10,693,313 views. Kaanta laga remix. ![]() 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. Sap abap programming training. A 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 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. (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. Contoh soal integral substitusi. 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.
0 Comments
Leave a Reply. |