{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Degree Centigrade","Degree Fahrenheit","Help","calculation method","convert °C to °F","convert °F to °C","Revision history"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Degree Centigrade","index":0,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[4,1,4,21],[11,1,12,1],[11,2,12,2],[11,3,11,21],[5,1,5,21]]}
[null,null,null,null,null,"info@vackerglobal.com"]
[null,"Cold Chain Experts"]
[]
[]
[null,"CALCULATION OF MEAN KINETIC TEMPERATURE (MKT)"]
[null,"Degree Centigrade"]
[]
[]
[null,"Please enable Macro while opening this Excel sheet "]
[]
[null,"Simply replace the readings in the following columns. Date & Time are optional. Add rows as required"]
[null,"Date (Optional)","Time (Optional)","Readings  °C"]
[null,null,null,"Refirgerator 1","Cold Room 1","Warehouse 1","Cool Box 1","Data Logger 1","Data Logger 2","Data Logger 3","Data Logger 4","Data Logger 5","Data Logger 6","Data Logger 7","Data Logger 8","DL 13","DL 14","DL 15","DL 16","DL 17","DL 18","DL 19"]
[null,"21/05/2014","12:37:06",20.100000000000001,19.3,19.5,19.5,19.100000000000001,18.8,20.2,19.8,19.8,20.5,19.600000000000001,20,20.2,19.2,18.7,20.7,20.3,19.5,20.100000000000001]
[null,"21/05/2014","12:40:06",20.2,19.8,19.8,20.2,20.7,19.3,20.7,20.100000000000001,20,20.8,19.7,19.8,20.6,19.3,19,20.7,20.3,19.600000000000001,20.3]
[null,"21/05/2014","12:43:06",20.6,20.2,20,20.8,20,19.600000000000001,21.2,20.2,20.100000000000001,21.2,19.8,20,21.1,19.7,19.3,21,20.3,19.7,20.6]
[null,"21/05/2014","12:46:06",21.4,20.5,20,21.5,20.3,20,21.6,20.5,20.2,21.6,20,20.100000000000001,21.6,20,19.7,21.2,20.6,20,21]
[null,"21/05/2014","12:49:06",21.3,20.7,20.100000000000001,21.7,20.5,20.2,22.1,20.7,20.3,22,20.2,20.2,21.8,20.3,20,21.6,20.7,20.2,21.3]
[null,"21/05/2014","12:52:06",21.5,20.6,20.100000000000001,21.2,20.2,20,22,20.7,20.5,22.1,20.3,20.5,21.7,20.6,20.2,21.8,21,20.3,21.6]
[null,"21/05/2014","12:55:06",21.3,20.5,19.8,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","12:58:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:01:06",22.4,20.100000000000001,19.7,20.100000000000001,19.5,19.5,21.3,20.6,20.5,21.7,20.3,20.7,21.2,20.3,19.7,21.7,21.1,20.3,21.2]
[null,"21/05/2014","13:04:06",21.3,20.3,19.600000000000001,20,19.2,19.2,21.2,20.6,20.5,21.6,20.3,20.7,21.1,20.2,19.600000000000001,21.7,21.1,20.2,21.1]
[null,"21/05/2014","13:07:06",20.7,20,19.600000000000001,19.7,19.2,19.100000000000001,21.1,20.5,20.5,21.5,20.3,20.7,21,20.100000000000001,19.5,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:10:06",19.5,19.8,19.5,19.600000000000001,19.100000000000001,19.100000000000001,21,20.5,20.3,21.3,20.3,20.6,20.8,20.100000000000001,19.3,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:13:06",19.5,19.7,19.5,19.600000000000001,19,19,21,20.3,20.3,21.2,20.3,20.6,20.7,20,19.2,21.5,20.8,20,20.8]
[null,"21/05/2014","13:16:06",19.5,19.7,19.5,19.600000000000001,19,19,20.8,20.3,20.3,21.2,20.3,20.6,20.7,19.8,19.100000000000001,21.3,20.8,19.8,20.8]
[null,"21/05/2014","13:19:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:22:06",21.4,20.5,20,21.5,20.3,20,21.6,20.5,20.2,21.6,20,20.100000000000001,21.6,20,19.7,21.2,20.6,20,21]
[null,"21/05/2014","13:25:06",21.3,20.7,20.100000000000001,21.7,20.5,20.2,22.1,20.7,20.3,22,20.2,20.2,21.8,20.3,20,21.6,20.7,20.2,21.3]
[null,"21/05/2014","13:28:06",21.5,20.6,20.100000000000001,21.2,20.2,20,22,20.7,20.5,22.1,20.3,20.5,21.7,20.6,20.2,21.8,21,20.3,21.6]
[null,"21/05/2014","13:31:06",21.3,20.5,19.8,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","13:34:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:37:06",22.4,20.100000000000001,19.7,20.100000000000001,19.5,19.5,21.3,20.6,20.5,21.7,20.3,20.7,21.2,20.3,19.7,21.7,21.1,20.3,21.2]
[null,"21/05/2014","13:40:06",21.3,20,19.600000000000001,20,19.2,19.2,21.2,20.6,20.5,21.6,20.3,20.7,21.1,20.2,19.600000000000001,21.7,21.1,20.2,21.1]
[null,"21/05/2014","13:43:06",20.7,19.100000000000001,21.1,19.7,19.2,19.100000000000001,21.1,20.5,20.5,21.5,20.3,20.7,21,20.100000000000001,19.5,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:46:06",21.3,19.7,21.7,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","13:49:06",21.1,19.600000000000001,21.5,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"Mean Kinetic Value (MKT)",null,{"$f":"MKTc(D14:D38)","v":20.994132909621793},20.115383626627338,19.974874052084392,20.482416408386179,19.723105482386373,19.531487602194968,21.383330208441894,20.531829163642485,20.399852545167079,21.615477193983271,20.195861823342479,20.463759043166441,21.267412509533301,20.195520891475361,19.65950546807959,21.543636277569462,20.887752841839767,20.11981747675884,21.107550657354718]
[]
[]
[null,"Minimum",null,{"$f":"MIN(D14:D38)","v":19.5},{"$f":"MIN(E14:E36)","v":19.100000000000001},{"$f":"MIN(F14:F37)","v":19.5},{"$f":"MIN(G14:G38)","v":19.5},19,18.8,20.2,19.8,19.8,20.5,19.600000000000001,19.8,20.2,19.2,18.7,20.7,20.3,19.5,20.100000000000001]
[null,"Maximum",null,{"$f":"MAX(D14:D38)","v":22.4},{"$f":"MAX(E14:E36)","v":20.7},{"$f":"MAX(F14:F37)","v":21.7},{"$f":"MAX(G14:G38)","v":21.7},20.7,20.2,22.1,20.7,20.6,22.1,20.3,20.7,21.8,20.6,20.2,21.8,21.1,20.3,21.6]
[null,"Average",null,{"$f":"AVERAGE(D14:D38)","v":20.995999999999999},{"$f":"AVERAGE(E14:E36)","v":20.156521739130437},{"$f":"AVERAGE(F14:F37)","v":19.912500000000001},{"$f":"AVERAGE(G14:G38)","v":20.484000000000002},19.724,19.532,21.384,20.531999999999996,20.400000000000006,21.616,20.196000000000005,20.464000000000002,21.268000000000001,20.196000000000005,19.660000000000004,21.544,20.888000000000005,20.120000000000005,21.108000000000001]
[null,"MKT Value",null,{"$f":"MKTc(D14:D38)","v":20.994132909621793},20.115383626627338,19.974874052084392,20.482416408386179,19.723105482386373,19.531487602194968,21.383330208441894,20.531829163642485,20.399852545167079,21.615477193983271,20.195861823342479,20.463759043166441,21.267412509533301,20.195520891475361,19.65950546807959,21.543636277569462,20.887752841839767,20.11981747675884,21.107550657354718]
[]
[null,"Activation energy ΔH = 83.14472 kJ/mol"]
[null,"Gas Constant R = 8.314472 J/mol/degree"]
[]
[null,"For full version of this software, please contact us at info@vackerglobal.com"]

{"sheet":"Degree Fahrenheit","index":1,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[42,1,42,2],[43,1,43,2],[44,1,44,2],[4,1,4,21],[5,1,5,21],[11,1,12,1],[11,2,12,2],[11,3,11,21],[41,1,41,2]]}
[null,null,null,null,null,"info@vackerglobal.com"]
[null,"Cold Chain Experts"]
[]
[]
[null,"CALCULATION OF MEAN KINETIC TEMPERATURE (MKT)"]
[null,"Degree Fahrenheit"]
[]
[]
[null,"Please enable Macro while opening this Excel sheet "]
[]
[null,"Simply replace the readings in the following columns. Date & Time are optional. Add rows as required"]
[null,"Date (Optional)","Time (Optional)","Readings  °F"]
[null,null,null,"Refirgerator 1","Cold Room 1","Warehouse 1","Cool Box 1","Data Logger 1","Data Logger 2","Data Logger 3","Data Logger 4","Data Logger 5","Data Logger 6","Data Logger 7","Data Logger 8","DL 13","DL 14","DL 15","DL 16","DL 17","DL 18","DL 19"]
[null,"21/05/2014","12:37:06",20.100000000000001,19.3,19.5,19.5,19.100000000000001,18.8,20.2,19.8,19.8,20.5,19.600000000000001,20,20.2,19.2,18.7,20.7,20.3,19.5,20.100000000000001]
[null,"21/05/2014","12:40:06",20.2,19.8,19.8,20.2,20.7,19.3,20.7,20.100000000000001,20,20.8,19.7,19.8,20.6,19.3,19,20.7,20.3,19.600000000000001,20.3]
[null,"21/05/2014","12:43:06",20.6,20.2,20,20.8,20,19.600000000000001,21.2,20.2,20.100000000000001,21.2,19.8,20,21.1,19.7,19.3,21,20.3,19.7,20.6]
[null,"21/05/2014","12:46:06",21.4,20.5,20,21.5,20.3,20,21.6,20.5,20.2,21.6,20,20.100000000000001,21.6,20,19.7,21.2,20.6,20,21]
[null,"21/05/2014","12:49:06",21.3,20.7,20.100000000000001,21.7,20.5,20.2,22.1,20.7,20.3,22,20.2,20.2,21.8,20.3,20,21.6,20.7,20.2,21.3]
[null,"21/05/2014","12:52:06",21.5,20.6,20.100000000000001,21.2,20.2,20,22,20.7,20.5,22.1,20.3,20.5,21.7,20.6,20.2,21.8,21,20.3,21.6]
[null,"21/05/2014","12:55:06",21.3,20.5,19.8,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","12:58:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:01:06",22.4,20.100000000000001,19.7,20.100000000000001,19.5,19.5,21.3,20.6,20.5,21.7,20.3,20.7,21.2,20.3,19.7,21.7,21.1,20.3,21.2]
[null,"21/05/2014","13:04:06",21.3,20,19.600000000000001,20,19.2,19.2,21.2,20.6,20.5,21.6,20.3,20.7,21.1,20.2,19.600000000000001,21.7,21.1,20.2,21.1]
[null,"21/05/2014","13:07:06",20.7,20,19.600000000000001,19.7,19.2,19.100000000000001,21.1,20.5,20.5,21.5,20.3,20.7,21,20.100000000000001,19.5,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:10:06",19.5,19.8,19.5,19.600000000000001,19.100000000000001,19.100000000000001,21,20.5,20.3,21.3,20.3,20.6,20.8,20.100000000000001,19.3,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:13:06",19.5,19.7,19.5,19.600000000000001,19,19,21,20.3,20.3,21.2,20.3,20.6,20.7,20,19.2,21.5,20.8,20,20.8]
[null,"21/05/2014","13:16:06",19.5,19.7,19.5,19.600000000000001,19,19,20.8,20.3,20.3,21.2,20.3,20.6,20.7,19.8,19.100000000000001,21.3,20.8,19.8,20.8]
[null,"21/05/2014","13:19:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:22:06",21.4,20.5,20,21.5,20.3,20,21.6,20.5,20.2,21.6,20,20.100000000000001,21.6,20,19.7,21.2,20.6,20,21]
[null,"21/05/2014","13:25:06",21.3,20.7,20.100000000000001,21.7,20.5,20.2,22.1,20.7,20.3,22,20.2,20.2,21.8,20.3,20,21.6,20.7,20.2,21.3]
[null,"21/05/2014","13:28:06",21.3,20.6,20.100000000000001,21.2,20.2,20,22,20.7,20.5,22.1,20.3,20.5,21.7,20.6,20.2,21.8,21,20.3,21.6]
[null,"21/05/2014","13:31:06",21.3,20.5,19.8,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","13:34:06",21.1,20.3,19.7,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"21/05/2014","13:37:06",22.4,20.100000000000001,19.7,20.100000000000001,19.5,19.5,21.3,20.6,20.5,21.7,20.3,20.7,21.2,20.3,19.7,21.7,21.1,20.3,21.2]
[null,"21/05/2014","13:40:06",21.3,20,19.600000000000001,20,19.2,19.2,21.2,20.6,20.5,21.6,20.3,20.7,21.1,20.2,19.600000000000001,21.7,21.1,20.2,21.1]
[null,"21/05/2014","13:43:06",20.7,19.100000000000001,21.1,19.7,19.2,19.100000000000001,21.1,20.5,20.5,21.5,20.3,20.7,21,20.100000000000001,19.5,21.6,21,20.100000000000001,21]
[null,"21/05/2014","13:46:06",21.3,19.7,21.7,20.8,20,19.7,21.7,20.7,20.6,22,20.3,20.6,21.6,20.6,20.100000000000001,21.8,21.1,20.3,21.5]
[null,"21/05/2014","13:49:06",21.1,19.600000000000001,21.5,20.5,19.600000000000001,19.600000000000001,21.5,20.7,20.6,21.8,20.3,20.6,21.5,20.5,19.8,21.8,21.1,20.3,21.3]
[null,"Mean Kinetic Value (MKT)",null,{"$f":"MKTf(D14:D38)","v":20.986873344939305},20.103626003340807,19.975312098255461,20.483033027167515,19.723454388622848,19.531687583829683,21.383590741831732,20.531895753798722,20.399910020792063,21.615680545882601,20.195915720301993,20.463852961764392,21.267641129605309,20.195707784552184,19.659698521799417,21.543777787999066,20.887849096741192,20.11988867279069,21.107725602275401]
[]
[]
[null,"Minimum",null,{"$f":"MIN(D14:D38)","v":19.5},{"$f":"MIN(E14:E36)","v":19.100000000000001},{"$f":"MIN(F14:F37)","v":19.5},{"$f":"MIN(G14:G38)","v":19.5},19,18.8,20.2,19.8,19.8,20.5,19.600000000000001,19.8,20.2,19.2,18.7,20.7,20.3,19.5,20.100000000000001]
[null,"Maximum",null,{"$f":"MAX(D14:D38)","v":22.4},{"$f":"MAX(E14:E36)","v":20.7},{"$f":"MAX(F14:F37)","v":21.7},{"$f":"MAX(G14:G38)","v":21.7},20.7,20.2,22.1,20.7,20.6,22.1,20.3,20.7,21.8,20.6,20.2,21.8,21.1,20.3,21.6]
[null,"Average",null,{"$f":"AVERAGE(D14:D38)","v":20.988000000000003},{"$f":"AVERAGE(E14:E36)","v":20.143478260869568},{"$f":"AVERAGE(F14:F37)","v":19.912500000000001},{"$f":"AVERAGE(G14:G38)","v":20.484000000000002},19.724,19.532,21.384,20.531999999999996,20.400000000000006,21.616,20.196000000000005,20.464000000000002,21.268000000000001,20.196000000000005,19.660000000000004,21.544,20.888000000000005,20.120000000000005,21.108000000000001]
[null,"MKT Value",null,{"$f":"MKTf(D14:D38)","v":20.986873344939305},{"$f":"MKTf(E14:E38)","v":20.103626003340807},19.975312098255461,20.483033027167515,19.723454388622848,19.531687583829683,21.383590741831732,20.531895753798722,20.399910020792063,21.615680545882601,20.195915720301993,20.463852961764392,21.267641129605309,20.195707784552184,19.659698521799417,21.543777787999066,20.887849096741192,20.11988867279069,21.107725602275401]
[]
[null,"Activation energy ΔH = 83.14472 kJ/mol"]
[null,"Gas Constant R = 8.314472 J/mol/degree"]
[]
[null,"For full version of this software, please contact us at info@vackerglobal.com"]

{"sheet":"Help","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
["How to use"]
["1. Please enable macros (We certify that the macros are safe)"]
["2. Change the values in the columns marked Refrigerator 1, Cold room 1 etc. These headings are just given as samples and you can use any column"]
["3. At the end of the data table, you can see Maximum, Minimum, Average and MKT values calculated"]
["4. The MKT formula is similar to other formula in excel. "]
["For Degree Centigrade, use =MKTC(C1:Cn)"]
["For Degree Fahrenheit, use =MKTF(C1:Cn)"]
["5. Please ensure that there are no empty cells left between the formula range. Empty cells also are counted in the calculation"]
[]
[]
["Notes:"]
["1. We developed this as a free service for the Healthcare fraternity since we faced serious difficulty when we wanted to find out MKT"]
["2. The Macros used in this workbook are completely done by us and  are safe. We undertake 100% responsibility for this original version (without any legal implications), unless modified by the user"]
["3. We have undertaken every effort to ensure that the calculation methods and results are correct."]
["4. If you liked this Excel sheet, please keep us motivated by sharing the same on this icon"]
["5. Please contact us at info@vackerglobal.com if you have any queries"]
[]
["6. If you want to see exact manual calculation, click:",null,null,null,null,null,"http://bit.ly/MKT-calculation "]
[]
[]
["If you like this worksheet, please encourage us by sharing this worksheet "]

{"sheet":"calculation method","index":3,"n_rows":100,"n_cols":2,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In a fully functional Worksheet (free of charge), you can insert any number of rows "]
[null,"If you require the full version please share our web page online by clicking these buttons"]
[null,"Or please contact us at info@vackerglobal.com"]

{"sheet":"convert °C to °F","index":4,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[8,2,8,3],[6,2,6,3],[5,2,5,3]]}
[]
[]
[]
[]
[]
[null,null,"For General Use"]
[null,null,"Convert °C to °F"]
[]
[null,null,"Temperature"]
[null,null,"°C","°F"]
[null,null,null,{"$f":"C11*1.8+32","v":32}]
[null,null,null,{"$f":"C12*1.8+32","v":32}]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[null,null,null,32]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Notes:"]
["1. We developed this as a free service for the Healthcare fraternity since we faced serious difficulty when we wanted to find out MKT"]
["2. The Macros used in this workbook are completely done by us and are are safe. We undertake 100% responsibility for this original version (without any legal implications), unless modified by the user"]
["3. We have undertaken every effort to ensure that the calculation methods and results are correct."]
["4. We do not undertake any direct or indirect liabilities for the results and usage of the same"]
["5. If you liked this Excel sheet, please share the same by clicking on this icon"]

{"sheet":"convert °F to °C","index":5,"n_rows":74,"n_cols":4,"rows_kept":74,"cut":false,"hidden":false,"merged":[[8,2,8,3],[6,2,6,3],[5,2,5,3]]}
[]
[]
[]
[]
[]
[null,null,"For General Use"]
[null,null,"Convert °F to °C"]
[]
[null,null,"Temperature"]
[null,null,"°F","°C"]
[null,null,null,{"$f":"(C11-32)/1.8","v":-17.777777777777779}]
[null,null,null,{"$f":"(C12-32)/1.8","v":-17.777777777777779}]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[null,null,null,-17.777777777777779]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Notes:"]
["1. We developed this as a free service for the Healthcare fraternity since we faced serious difficulty when we wanted to find out MKT"]
["2. The Macros used in this workbook are completely done by us and are are safe. We undertake 100% responsibility for this original version (without any legal implications), unless modified by the user"]
["3. We have undertaken every effort to ensure that the calculation methods and results are correct."]
["4. We do not undertake any direct or indirect liabilities for the results and usage of the same"]
["5. If you liked this Excel sheet, please share the same by clicking on this icon"]

{"sheet":"Revision history","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
["Doc no:VAC-QR-T-014"]
["Doc name: Excel Sheet for MKT calculation"]
["Controlled:","NO. Latest version to be downloaded from either of the following locations:"]
[null,"Internet:","http://www.temperaturemonitoringuae.com/how-to-calculate-mean-kinetic-temperature-mkt-in-excel/ "]
[null,"Server:","J:QA\\QP\\standardforms\\QRT014"]
[]
[]
[null,"Details of Revision"]
[null,"Rev No.","Date","Descirption"]
[null,0,"2014-02-17","Original version"]
[null,1,"2014-10-13","Separate sheet added for Fahrenheit & published online"]
[null,2,"2015-02-23","ΔH & R defned in the first two sheets"]
[null,3,"2015-03-09","Formatting changes only"]
[null,4,"2015-05-15","Formatting changes only"]
[null,5,"2015-06-25","Formatting changes only"]