{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Degree Centigrade","Degree Fahrenheit","Help","calculation method","Revision history"],"not_rendered":{"charts":0,"images":8,"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":91,"n_cols":30,"rows_kept":91,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[2,1,2,21],[9,1,10,1],[9,2,10,2],[3,1,3,21]]}
[null,null,null,null,null,"info@vackerglobal.com"]
[null,"Lite version"]
[null,"CALCULATION OF MEAN KINETIC TEMPERATURE (MKT)"]
[null,"Degree Centigrade"]
[]
[]
[null,"Please enable Macro while opening this Excel sheet (We certify that these Macros are safe-Please see the sheet 'calculation method' for details of the Macro)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"="]
[null,"Simply replace the readings in the following columns. Date & Time are optional. "]
[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,"Mean Kinetic Value (MKT)",null,{"$f":"MKTc(D12:D28)","v":2.4841240175987878E-14},2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14]
[null,"Pleae ensure that there are no empty rows."]
[]
[null,"Minimum",null,{"$f":"MIN(D12:D28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maximum",null,{"$f":"MAX(D12:D28)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Average",null,{"$f":"AVERAGE(D12:D28)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MKT Value",null,{"$f":"MKTc(D12:D28)","v":2.4841240175987878E-14},2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14,2.4841240175987878E-14]
[]
[null,"If you need to insert rows, column or sheets, please buy the full version from our stores for USD 9.99"]
[null,"https://store.vackerglobal.com/mean-kinetic-temperature-mkt-excel-sheet"]
[]
[]
[null,"Activation energy ΔH = 83.14472 kJ/mol"]
[null,"Gas Constant R = 0.008314472 KJ/mol/degree"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes"]
[null,"The above calculation method is as per the sheet 'calculation method' in this workbook. We will not be responsible for any variations of the method or consequential damages if any thereof."]
[null,"Our liabilities in any case are limited to the cost of this software sheet"]

{"sheet":"Degree Fahrenheit","index":1,"n_rows":88,"n_cols":22,"rows_kept":88,"cut":false,"hidden":false,"merged":[[40,1,40,2],[41,1,41,2],[42,1,42,2],[4,1,4,21],[5,1,5,21],[11,1,12,1],[11,2,12,2],[11,3,11,21],[39,1,39,2]]}
[null,null,null,null,null,"info@vackerglobal.com"]
[null,"Lite version"]
[]
[]
[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,"Mean Kinetic Value (MKT)",null,{"$f":"MKTf(D14:D36)","v":-4.8905324234738146E-14},-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14]
[]
[]
[null,"Minimum",null,{"$f":"MIN(D14:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Maximum",null,{"$f":"MAX(D14:D36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Average",null,{"$f":"AVERAGE(D14:D36)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MKT Value",null,{"$f":"MKTf(D14:D36)","v":-4.8905324234738146E-14},-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14,-4.8905324234738146E-14]
[]
[null,"If you need to insert rows, column or sheets, please buy the full version from our stores for USD 9.99"]
[null,"https://store.vackerglobal.com/mean-kinetic-temperature-mkt-excel-sheet"]
[]
[null,"Activation energy ΔH = 83.14472 kJ/mol"]
[null,"Gas Constant R = 0.008314472 KJ/mol/degree"]
[]
[null,"Copyright Notice: This entire Workbook is copyrighted to Vacker LLC. Any unauthorised distribution through online or offline media is not permitted without written approval from us."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes"]
[null,"The above calculation method is as per the sheet 'calculation method' in this workbook. We will not be responsible for any variations of the method or consequential damages if any thereof."]
[null,"Our liabilities in any case are limited to the cost of this software sheet"]

{"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. Pleae see the sheet 'calculation method' for details of the macro)"]
["2. Input the temperature readings in the column 'readings'"]
["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 formulae 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 calculate 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":95,"n_cols":2,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The Macros MKTC (For Degree Centigrade) and MKTF (for degree Fahrenheit) consist of the above calculation"]

{"sheet":"Revision history","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"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,"Intranet 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"]
[null,6,"2017-09-25","Major changes for increased functionality. The full version made available online"]
[null,7,"2018-01-20","Major changes for increased functionality. "]