Morning all I have a workbook which gathers live weather information from about 480 major cities and which I display in a workbook where the user selects 4 waypoints, Origin, Export Gateway, Import Gateway and final destination. I have now been asked to show the waypoints as mean kinetic temperatures (MKT) which I can barely understand, let alone the mathematical equation to do it. What I do (or hope I) understand is that in order to calculate the MKT I will need to add to the workbook a temperature parameter for the package contents, an expected transit time, and the temperature converted to Kelvin which I have attempted to do in the attached example spreadsheet.
TQSoft™ Interval Calculations library includes Mean Kinetic Temperature Calculate Max/Min Mean Kinetic Temperature with TQSoft™ on any selected group on any specified interval Apply limits and alarm actions for stability monitoring. MKT-calculation-simple-formula:Vacker UAE has developed this free Excel template for calculation of Mean Knetic Value (MKT) for temperature sensitive products such as medicine, vaccine etc.
Picture 1 shows the formula, picture 2 shows an example from an American pharma publication. Can anbody assist,me with this please so that I can show the MKT for the overall journey? Attachments MKT.jpg (19.54 KiB) Viewed 5318 times MKT1.jpg (15.52 KiB) Viewed 5318 times (16.5 KiB) Downloaded 1795 times. Does this help? Your example does not give what Activation energy they used, It appears to be about 83.14 so I assumed 83.11472 so it was related to the gas constant.
The equation is a little misleading in that it assumes equal time periods, but it is easier to calculate with weighted periods when you have sections of time time intervals (like the egg example). The attached shows the cals for the egg example as individual 7 time units (7 hours) and the weighted scheme 2, 4,1 hours. This makes it easier to calculate if you have periods of different duration. I included the range of temperatures (with a range of kinetic energies) and also show the calculation for the weighted mean temperature which is much lower than the MKT in this example. I put the numbers from your workbook example, but it only lists the time at origin (48 hours) so the MKT is the origin temp. You need to enter times for each period to calculate the MKT, otherwise you are indicating that it just spent 48 hours at one temperature and then you don't need the to average at all.
Steve Attachments (25 KiB) Downloaded 1520 times Post=30093 3StarLounger Posts: 392 Joined: 25 Jan 2010, 12:21. Sdckapr wrote:Does this help? Your example does not give what Activation energy they used, It appears to be about 83.14 so I assumed 83.11472 so it was related to the gas constant.
The equation is a little misleading in that it assumes equal time periods, but it is easier to calculate with weighted periods when you have sections of time time intervals (like the egg example). The attached shows the cals for the egg example as individual 7 time units (7 hours) and the weighted scheme 2, 4,1 hours. This makes it easier to calculate if you have periods of different duration. I included the range of temperatures (with a range of kinetic energies) and also show the calculation for the weighted mean temperature which is much lower than the MKT in this example.
![]()
I put the numbers from your workbook example, but it only lists the time at origin (48 hours) so the MKT is the origin temp. You need to enter times for each period to calculate the MKT, otherwise you are indicating that it just spent 48 hours at one temperature and then you don't need the to average at all. Steve I just posted a reply and it has gone the same thing happened the other day, so maybe 2 will turn up (like buses) Wow, thats great Steve If I understand what you have said above would it be more meaningful to add transit times to my waypoints, for example collection at origin to export gateway 5 hours at 20 degress, Flight to import gateway 12 hours at (a guess because I cannot find any cabin temperature at the moment) 25 degress, 5 hours to clear and deliver at say 25 degrees and the product (which has internal temperature controls) at say 5 degrees. Thanks for this great advice. What is the appropriate length of time to use when calculating MKT? For example, we have a refrigeration unit in which we store products that need to be kept at a temperature range of 35-45F. Several times over the past week, the temperature spiked to around 50F.
When calculating MKT for this temperature deviation, do we use only the temperature values (taken hourly) for the day of the spike, for the whole week, or for the entire length of time that the product is refrigerated in the unit? Obviously the greater the length of time, the less of an impact a temperature spike will have on the MKT so it seems very subjective. Lngorano wrote:What is the appropriate length of time to use when calculating MKT?
What length of time are you interested? Are you interested in the MKT for the short-time it is out of spec or the week, or whatever.
I am NOT an expert in this, but I would think that you would want to average it over the entire timeperiod that the material is stored. If a product is in the unit for 3 days of the week and you get hourly readings, you would do the MKT on the 72 hours to see its MKT. As noted earlier the MKT is not an average, nor is it a standard weighted average, it deals in rates, presuming there is some decomposition, so higher temperatures will have a larger impact.
The MKT is essentially an summay / equivalent value. Instead of looking at the 72 different temperatures to describe what happened, the MKT indicates what SINGLE temperature it would have had to be at have the same amount of degredation for the 3 days. Steve Post=100497 3StarLounger Posts: 392 Joined: 25 Jan 2010, 12:21.
Here's how you can calculate Mean Kinetic Temperature in Excel Sheet? First Download the Excel sheet: The MKT excel sheet will give you the mean kinetic value, maximum and minimum values and the average and can be used for temperature sensitive products.
The Mean Kinetic Calculation is widely used in pharmaceutical industries. You can calculate in Fahrenheit as well. This Video explains all the information regarding Kinetic Theory and temperature, kinetic interpretation of temperature, kinetic energy, mean temperature, how to calculate mean kinetic temperature, mkt calculation, how to calculate mkt in excel, what is mkt, mkt calculation for pharma industry, excel mkt calculation. Transcript This video explains how to calculate Mean Kinetic Temperature in Microsoft excel. Upon opening the Excel file, please Enable Macros. There are two sheets, one for Degree Centigrade and another one for Fahrenheit.
You have to simply insert the data into these rows. You can add or delete any number of rows or columns. Now copy the data from the data logger into these columns.
I have a sample data stored separately. Insert as many rows as you want. Copy the data into these columns. Delete any empty rows. Now you can see the Mean Kinetic Temperature value, Maximum and Minimum values and the average. You can do a similar method for data in Fahrenheit as well.
The formula used in =M K T ( ). Please go to our stores to download this MKT calculation tool. Also, contact us for Temperature mapping study, data loggers, construction of cold rooms, dehumidification solutions etc. For Cold Chain applications. Contact details: Vacker LLC 306, RKM Building, Ittihad Road, Hor Al Anz Deira, Dubai Tel: +971 42 66 11 44 Email: [email protected] Group websites.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |