{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,0,2,5],[5,0,5,1],[5,2,5,5]]}
["This spreadsheet can be used to convert physical values for RH/T into the reduced data format, which is used to store the Alert limits. Only the grey shaded areas can be be changed."]
[]
[]
[]
[]
["physical values",null,"Limit for RH/T in the reduced data format"]
["RH (%)","T (°C)","bin","dec","hex","physical values after conversion into the reduced data format"]
[80,60,{"$f":"CONCATENATE(RIGHT(CONCATENATE(\"00000000\",DEC2BIN(MOD(D8/256,256))),8),\"  \",(RIGHT(CONCATENATE(\"00000000\",DEC2BIN(MOD(D8,256))),8)))","v":"11001101  00110011"},{"$f":"MIN(MAX(ROUND(65535/100*A8/2^(16-7),0),0),127)*2^9+MIN(MAX(ROUND(((B8+45)/175*65535)/2^(16-9),0),0),511)","v":52531},{"$f":"RIGHT(CONCATENATE(\"0000\",DEC2HEX(D8)),4)","v":"CD33"},{"$f":"CONCATENATE(\"RH = \", TEXT(ROUNDDOWN(D8/2^9,0)*2^9/65535*100,\"0.00\"),\"%RH, T = \",TEXT(MOD(D8,2^9)*2^(16-9)*175/65535-45,\"0.00\"))","v":"RH = 79.69%RH, T = 59.93"}]
[79,58,{"$f":"CONCATENATE(RIGHT(CONCATENATE(\"00000000\",DEC2BIN(MOD(D9/256,256))),8),\"  \",(RIGHT(CONCATENATE(\"00000000\",DEC2BIN(MOD(D9,256))),8)))","v":"11001011  00101101"},{"$f":"MIN(MAX(ROUND(65535/100*A9/2^(16-7),0),0),127)*2^9+MIN(MAX(ROUND(((B9+45)/175*65535)/2^(16-9),0),0),511)","v":52013},{"$f":"RIGHT(CONCATENATE(\"0000\",DEC2HEX(D9)),4)","v":"CB2D"},{"$f":"CONCATENATE(\"RH = \", TEXT(ROUNDDOWN(D9/2^9,0)*2^9/65535*100,\"0.00\"),\"%RH, T = \",TEXT(MOD(D9,2^9)*2^(16-9)*175/65535-45,\"0.00\"))","v":"RH = 78.91%RH, T = 57.88"}]
[22,-9,"00111000  01101001",14441,"3869","RH = 21.88%RH, T = -9.11"]
[20,-10,"00110100  01100110",13414,"3466","RH = 20.31%RH, T = -10.14"]