{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["сахар","показания"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"сахар","index":0,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Соответствие гликированного гемоглобина HbA1c "]
[null,null,null,null,null,null,"среднесуточным показателям глюкозы плазмы"]
[]
[null,null,null,null,null,null,"показаний глюкометра",null,null,null,"записать","19:08:00",null,"2019-06-21",null,9.9]
[null,null,null,null,null,null,null,null,null,null,null,"время",null,"дата",null,"показатель"]
[null,null,null,null,null,null,"показания глюкометра «А» за 14 дней",null,null,null,null,null,null,"2019-06-21",null,{"$f":"(SUMIF(показания!A:A,\"<\"&N7+1,показания!B:B)-SUMIF(показания!A:A,\"<\"&N7-14,показания!B:B))/(COUNTIF(показания!A:A,\"<\"&N7+1)-COUNTIF(показания!A:A,\"<\"&N7-14))","v":7.303846153846175}]
[]
[null,null,null,null,null,null,"гликемический профиль за 10 дней на",null,null,null,null,null,null,"2019-06-21",null,{"$f":"(SUMIF(показания!A:A,\"<\"&N9+1,показания!B:B)-SUMIF(показания!A:A,\"<\"&N9-10,показания!B:B))/(COUNTIF(показания!A:A,\"<\"&N9+1)-COUNTIF(показания!A:A,\"<\"&N9-10))","v":7.5047619047619225}]
[]
[null,null,null,null,null,null,"гликемический профиль (суточный)",null,null,null,null,null,null,"2019-06-21",null,{"$f":"IF(OR((SUMIF(показания!A:A,\"<\"&N11+1,показания!B:B)-SUMIF(показания!A:A,\"<\"&N11,показания!B:B))=0,(COUNTIF(показания!A:A,\"<\"&N11+1)-COUNTIF(показания!A:A,\"<\"&N11))=0),0,(SUMIF(показания!A:A,\"<\"&N11+1,показания!B:B)-SUMIF(показания!A:A,\"<\"&N11,показания!B:B))/(COUNTIF(показания!A:A,\"<\"&N11+1)-COUNTIF(показания!A:A,\"<\"&N11)))","v":7.75}]
[]
[null,null,null,null,null,null,"06:00:00","1-й анализ","утром, на голодный желудок;"]
[null,null,null,null,null,null,"08:00:00","2-й анализ","завтрак - до приема пищи"]
[null,null,null,null,null,null,"09:30:00","3-й анализ","через 1,5 часа после завтрака"]
[null,null,null,null,null,null,"12:30:00","4-й анализ","обед - до приема пищи"]
[null,null,null,null,null,null,"14:00:00","5-й анализ","через 1,5 часа после обеда"]
[null,null,null,null,null,null,"17:00:00","6-й анализ","ужин - до приема пищи"]
[null,null,null,null,null,null,"18:30:00","7-й анализ","через 1,5 часа после ужина"]
[null,null,null,null,null,null,"22:00:00","8-й анализ","перед сном"]
[null,null,null,null,null,null,"00:00:00","9-й анализ","в 00:00 пополуночи"]
[null,null,null,null,null,null,"03:30:00","10-й анализ","в 3:30 ночи"]
[null,null,null,null,null,null,"Гликированный гемоглобин HbA1c",null,null,null,null,null,null,"за 1 день",null,{"$f":"IF(N23=\"за 14 дней\",P7/1.307086614,IF(N23=\"за 10 дней\",P9/1.307086614,IF(N23=\"за 1 день\",P11/1.307086614,\"нет данных\")))","v":5.9292168682556801},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,"2,2 - 3,3 ммоль/л",null,"для только родившихся"]
[null,null,null,null,null,null,"3,0 - 5,5 ммоль/л",null,"для детей до года"]
[null,null,null,null,null,null,"3,3 - 5,5 ммоль/л",null,"для взрослых и детей от года при Диабете 2типа"]
[null,null,null,null,null,null,"4,5 - 6,4 ммоль/л",null,"для людей преклонного возраста"]
[]
[null,null,null,null,null,null,"ниже 0,6 ммоль/л",null,"смертельно опасно, можно скончаться от последствий гипогликемии"]
[null,null,null,null,null,null,"от 5,0 до 7,2 ммоль/л",null,"до приема пищи"]
[null,null,null,null,null,null,"от 7,2 до 10 ммоль/л",null,"после приема пищи "]
[null,null,null,null,null,null,"до 12–15 ммоль/л",null,"является отклонением от нормы, но для жизни неопасно"]
[null,null,null,null,null,null,"> 30 ммоль/л",null,"значительное ухудшение состояния, вплоть до летального исхода"]
[]
[null,null,null,null,null,null,"6,1 ммоль/л.",null,null,"значение не должно превышать"]
[null,null,null,null,null,null,"7,8 ммоль/л.",null,null,"после приёма пищи (через 2ч), не более"]
[null,null,null,null,null,null,"5,6 - 6,9 ммоль/л",null,null,"на голодный желудок, не больше"]
[null,null,null,null,null,null,"содержание сахара в моче - ",null,null,"недопустимо"]

{"sheet":"показания","index":1,"n_rows":268,"n_cols":3,"rows_kept":268,"cut":false,"hidden":false,"merged":[]}
["дата","mmol/l"]
["2018-08-28T06:54:00",9.4]
["2018-08-29T07:31:00",11.6]
["2018-08-30T06:00:00",11.1]
["2018-09-01T16:37:00",4.5999999999999996]
["2018-09-01T20:51:00",10.6]
["2018-09-02T06:59:00",12.1]
["2018-09-02T07:24:00",14.2]
["2018-09-02T17:07:00",18.3]
["2018-09-03T08:23:00",14.4]
["2018-09-04T07:06:00",21.1]
["2018-09-05T07:29:00",14.8]
["2018-09-08T17:57:00",25.8]
["2018-09-08T21:31:00",25.4]
["2018-09-09T06:21:00",13.7]
["2018-09-09T12:19:00",15.8]
["2018-09-09T20:55:00",11.8]
["2018-09-10T07:06:00",11.7]
["2018-09-10T11:03:00",15.8]
["2018-09-10T19:13:00",21.3]
["2018-09-11T09:52:00",13.1]
["2018-09-11T14:58:00",13.6]
["2018-09-13T07:01:00",15.7]
["2018-09-16T12:06:00",10.3]
["2018-09-16T13:13:00",11.6]
["2018-09-16T17:05:00",15.6]
["2018-09-16T20:34:00",13.9]
["2018-09-18T13:04:00",6.8]
["2018-09-18T21:18:00",16.2]
["2018-09-19T06:09:00",10]
["2018-09-19T10:47:00",8.6]
["2018-09-20T13:47:00",9.1999999999999993]
["2018-09-24T06:34:00",12.4]
["2018-09-25T11:24:00",12.2]
["2018-09-26T19:59:00",7.6]
["2018-09-27T12:09:00",10.3]
["2018-09-27T17:03:00",13.9]
["2018-09-27T18:34:00",9.3000000000000007]
["2018-09-29T16:00:00",16.899999999999999]
["2018-09-29T18:33:00",12.4]
["2018-09-30T12:33:00",11]
["2018-09-30T21:09:00",18.600000000000001]
["2018-10-01T00:04:00",13.4]
["2018-10-01T07:35:00",12.8]
["2018-10-01T20:05:00",6.2]
["2018-10-02T07:18:00",10.3]
["2018-10-02T19:15:00",7.5]
["2018-10-02T23:17:00",16.3]
["2018-10-03T11:53:00",10.6]
["2018-10-04T09:01:00",11.4]
["2018-10-05T11:48:00",16.399999999999999]
["2018-10-06T13:09:00",12.1]
["2018-10-06T23:40:00",16.600000000000001]
["2018-10-07T11:57:00",12.9]
["2018-10-07T17:12:00",9.8000000000000007]
["2018-10-08T10:00:00",11.8]
["2018-10-09T21:50:00",15.8]
["2018-10-10T17:47:00",9.3000000000000007]
["2018-10-11T09:40:00",7.8]
["2018-10-11T19:14:00",5.2]
["2018-10-12T07:12:00",7.2]
["2018-10-13T09:00:00",11.5]
["2018-10-14T08:52:00",13.3]
["2018-10-14T10:10:00",6.9]
["2018-10-14T18:19:00",13.5]
["2018-10-16T10:51:00",6.1]
["2018-10-16T20:46:00",7.2]
["2018-10-17T12:47:00",8.1]
["2018-10-18T07:41:00",11.5]
["2018-10-18T18:51:00",9.9]
["2018-10-18T19:28:00",10.8]
["2018-10-20T22:53:00",7.6]
["2018-10-21T08:46:00",8.4]
["2018-10-22T23:31:00",11.7]
["2018-10-23T18:18:00",8.5]
["2018-10-24T22:19:00",18.2]
["2018-10-24T23:34:00",17]
["2018-10-25T08:00:00",9.3000000000000007]
["2018-10-26T13:12:00",5.8]
["2018-10-26T14:34:00",4.3]
["2018-10-27T12:53:00",4.3]
["2018-10-28T09:46:00",9]
["2018-10-30T10:11:00",16.2]
["2018-10-30T11:09:00",7.4]
["2018-10-31T07:11:00",7.8]
["2018-12-10T05:22:00",9.6]
["2018-12-11T23:32:00",7.9]
["2018-12-12T11:39:00",6.7]
["2018-12-12T19:00:00",9.1999999999999993]
["2018-12-12T23:56:00",13.4]
["2018-12-13T03:56:00",9.6999999999999993]
["2018-12-13T07:10:00",11.6]
["2018-12-13T17:45:00",10.4]
["2018-12-14T05:08:00",9.8000000000000007]
["2018-12-14T18:27:00",8.6]
["2018-12-15T03:48:00",10.9]
["2018-12-15T17:29:00",13.3]
["2018-12-16T02:59:00",10.8]
["2018-12-16T05:30:00",7.3]
["2018-12-16T19:41:00",8.5]
["2018-12-18T06:25:00",9.3000000000000007]
["2018-12-21T00:46:00",8.4]
["2018-12-21T15:15:00",8.1]
["2018-12-22T15:06:00",9.6]
["2018-12-23T09:15:00",14.2]
["2018-12-24T08:52:00",0.9]
["2018-12-24T08:53:00",11.4]
["2018-12-24T11:00:00",4.5999999999999996]
["2018-12-26T10:56:00",7.6]
["2018-12-27T12:24:00",8.4]
["2018-12-28T03:45:00",10.8]
["2018-12-28T10:39:00",7.2]
["2018-12-31T03:43:00",10.199999999999999]
["2018-12-31T22:39:00",13.8]
["2018-12-31T23:28:00",13.1]
["2019-01-01T00:24:00",12.7]
["2019-01-01T10:13:00",13.6]
["2019-01-02T10:04:00",15.2]
["2019-01-02T21:04:00",6.8]
["2019-01-04T04:22:00",7]
["2019-01-04T04:31:00",6.3]
["2019-01-04T14:38:00",3.9]
["2019-01-06T01:53:00",6.9]
["2019-01-06T09:56:00",9.3000000000000007]
["2019-01-06T13:58:00",8.1]
["2019-01-10T05:51:00",7.5]
["2019-01-12T12:36:00",8.6999999999999993]
["2019-01-13T10:32:00",8.4]
["2019-01-13T13:15:00",11.6]
["2019-01-13T21:27:00",9.6999999999999993]
["2019-01-13T23:15:00",13.7]
["2019-01-14T00:17:00",11.8]
["2019-01-14T02:43:00",8.3000000000000007]
["2019-01-15T09:40:00",13.5]
["2019-01-16T10:36:00",6.5]
["2019-01-16T19:50:00",4.9000000000000004]
["2019-01-17T10:34:00",10.8]
["2019-01-18T10:33:00",9.4]
["2019-01-19T12:26:00",6.6]
["2019-01-19T13:08:00",10.199999999999999]
["2019-01-19T16:44:00",6.7]
["2019-01-20T05:54:00",6.4]
["2019-01-20T06:44:00",8.8000000000000007]
["2019-01-21T02:44:00",8.3000000000000007]
["2019-01-21T07:26:00",8.6]
["2019-01-24T10:05:00",6.9]
["2019-01-24T23:18:00",7.8]
["2019-01-26T03:14:00",6.1]
["2019-01-26T03:15:00",7]
["2019-01-27T16:29:00",6.8]
["2019-01-27T20:36:00",9.6999999999999993]
["2019-01-28T08:02:00",8.1999999999999993]
["2019-01-28T10:12:00",7.4]
["2019-01-30T05:08:00",8.1]
["2019-01-31T10:18:00",7.9]
["2019-02-01T00:44:00",12]
["2019-02-02T08:55:00",9]
["2019-02-03T08:04:00",12.7]
["2019-02-03T15:28:00",8.8000000000000007]
["2019-02-05T10:17:00",10.7]
["2019-02-07T12:21:00",8.4]
["2019-02-09T22:48:00",15.6]
["2019-02-09T23:46:00",13.2]
["2019-02-12T10:56:00",6.5]
["2019-02-13T18:50:00",7.7]
["2019-02-14T12:35:00",8.4]
["2019-02-17T03:28:00",6.6]
["2019-02-17T10:36:00",8.3000000000000007]
["2019-02-24T13:49:00",13.2]
["2019-02-25T10:01:00",9.1999999999999993]
["2019-02-27T19:48:00",8.6999999999999993]
["2019-03-02T01:54:00",10.6]
["2019-03-02T03:24:00",7.9]
["2019-03-09T21:35:00",14.1]
["2019-03-10T00:28:00",13.9]
["2019-03-10T10:20:00",9.1999999999999993]
["2019-03-14T13:31:00",12.9]
["2019-03-16T21:30:00",15.6]
["2019-03-17T07:54:00",12.1]
["2019-03-23T13:58:00",15]
["2019-03-24T01:28:00",12.8]
["2019-03-24T02:21:00",12.1]
["2019-03-24T16:11:00",10.7]
["2019-03-29T22:54:00",13.1]
["2019-03-30T16:22:00",10.5]
["2019-04-11T20:48:00",2.7]
["2019-04-12T12:43:00",5.9]
["2019-04-13T07:54:00",7.7]
["2019-04-13T22:20:00",7.5]
["2019-04-27T00:27:00",13.2]
["2019-04-27T15:10:00",13.8]
["2019-04-27T16:34:00",12.4]
["2019-04-28T14:58:00",9.6999999999999993]
["2019-04-28T17:22:00",23.4]
["2019-04-28T17:43:00",9.3000000000000007]
["2019-05-01T02:30:00",9.8000000000000007]
["2019-05-01T18:57:00",3.2]
["2019-05-02T00:53:00",8.6]
["2019-05-02T12:25:00",12.3]
["2019-05-02T16:38:00",12.1]
["2019-05-02T17:04:00",12.8]
["2019-05-03T17:57:00",13.4]
["2019-05-04T03:14:00",8.1]
["2019-05-04T18:29:00",9.1]
["2019-05-10T14:50:00",12.4]
["2019-05-10T15:20:00",12.9]
["2019-05-11T04:23:00",6.9]
["2019-05-11T12:01:00",8.4]
["2019-05-12T23:52:00",8.1999999999999993]
["2019-05-13T03:11:00",10.8]
["2019-05-15T00:41:00",10.1]
["2019-05-16T10:28:00",6.7]
["2019-05-16T22:20:00",12.7]
["2019-05-16T23:06:00",13.6]
["2019-05-17T23:06:00"]
["2019-05-18T23:06:00"]
["2019-05-18T23:06:00"]
["2019-05-19T02:33:00",6.1]
["2019-05-20T11:35:00",10.199999999999999]
["2019-05-21T14:34:00",8.4]
["2019-05-21T14:37:00",8.3000000000000007]
["2019-05-21T17:09:00",18.100000000000001]
["2019-05-22T03:28:00",5.9]
["2019-05-22T12:19:00",6.3]
["2019-05-22T23:00:00",12.8]
["2019-05-23T03:44:00",9.6]
["2019-05-24T20:29:00",7.7]
["2019-05-25T02:42:00",8.8000000000000007]
["2019-05-25T12:06:00",7.8]
["2019-05-26T19:17:00",4.7]
["2019-05-27T19:16:59.995"]
["2019-05-28T03:02:00",5.3]
["2019-05-29T15:22:00",11.4]
["2019-05-29T18:39:00",3.5]
["2019-05-30T18:39:00"]
["2019-05-31T18:39:00"]
["2019-06-01T14:23:00"]
["2019-06-02T14:23:00",6.1]
["2019-06-02T14:27:00",7.2]
["2019-06-03T21:07:00",11.1]
["2019-06-04T04:40:00",8.9]
["2019-06-05T17:38:00",5.0999999999999996]
["2019-06-07T11:35:00"]
["2019-06-09T18:53:00",9.3000000000000007]
["2019-06-09T19:49:00",9.1]
["2019-06-10T01:18:00",7.6]
["2019-06-10T06:45:00",6.3]
["2019-06-11T06:45:00",6.3]
["2019-06-11T06:45:00"]
["2019-06-13T12:57:00",7.8]
["2019-06-14T14:33:00",11.2]
["2019-06-15T08:44:00",8.1]
["2019-06-16T09:59:00",7.5]
["2019-06-16T20:20:00",11.7]
["2019-06-17T20:19:59.995"]
["2019-06-17T20:20:00"]
["2019-06-18T12:54:00",10.4]
["2019-06-18T18:24:00",11.9]
["2019-06-18T19:43:00",11]
["2019-06-19T10:30:00",8.8000000000000007]
["2019-06-19T15:59:00",6.8]
["2019-06-19T16:43:00",5.3,8.8000000000000007]
["2019-06-19T18:25:00",4.3,8.6]
["2019-06-20T00:35:00",8.6]
["2019-06-20T11:37:00",11.2,8.9]
["2019-06-20T20:04:00",11.2,9]
["2019-06-21T14:13:00",5.6,8.9]
["2019-06-21T19:08:00",9.9,8.9]