{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Итоговый","Исходный"],"not_rendered":{"charts":0,"images":0,"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":"Итоговый","index":0,"n_rows":27,"n_cols":28,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["hat 1","hat 2","hat 3","hat 4","hat 5","hat 6","hat 7","hat 8","hat 9","hat 10","hat 11","hat 12","hat 13","hat 14","hat 15","hat 16","hat 17","hat 18","hat 19","hat 20","hat 21","hat 22","hat 23","hat 24","hat 25","hat 26","hat 27","hat 28"]
[null,null,null,null,null,null,null,null,null,"2013-06-12T16:06:13","S",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-17T20:46:15","T",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-21T23:21:21","S",3,6,6,15,15,15,0,5,3,3,3,5,3,5,5,3,95]
[null,null,null,null,null,null,null,null,null,"2013-06-22T11:25:53","A",3,3.6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,97.6]
[null,null,null,null,null,null,null,null,null,"2013-06-10T19:31:19","S",3,6,3.6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,96.4]
[null,null,null,null,null,null,null,null,null,"2013-06-18T16:09:05","T",3,0,6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,92.8]
[null,null,null,null,null,null,null,null,null,"2013-06-26T18:49:30","A",3,6,3.6,15,15,15,3,5,3,3,3,5,1.8,5,5,5,96.399999999999991]
[null,null,null,null,null,null,null,null,null,"2013-06-11T14:33:23","T",3,3.6,6,15,15,15,3,3,3,3,3,5,3,5,5,5,95.6]
[null,null,null,null,null,null,null,null,null,"2013-06-13T20:47:18","S",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-26T17:37:37","A",3,3.6,6,15,15,15,3,5,1.8,3,3,5,3,5,5,5,96.399999999999991]
[null,null,null,null,null,null,null,null,null,"2013-06-05T20:34:57","S",3,6,6,15,9,9,3,5,3,3,3,5,3,5,5,5,88]
[null,null,null,null,null,null,null,null,null,"2013-06-11T10:37:02","T",3,6,6,15,15,9,3,5,3,3,1.8,5,3,5,5,5,92.8]
[null,null,null,null,null,null,null,null,null,"2013-06-29T15:28:26","A",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-18T17:41:54","T",3,6,6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,98.8]
[null,null,null,null,null,null,null,null,null,"2013-06-03T09:08:01","S",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-11T18:07:10","A",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-14T14:28:45","S",3,3.6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,97.6]
[]
[null,null,null,null,null,null,null,null,null,"Середнє значення",null,{"$f":"AVERAGE(L2:L18)","v":3},{"$f":"AVERAGE(M2:M18)","v":5.0823529411764712},5.7176470588235295,15,14.647058823529411,13.235294117647058,2.611764705882353,4.882352941176471,2.9294117647058822,3,2.9294117647058822,5,2.9294117647058822,5,5,4.882352941176471,95.847058823529395]
[null,null,null,null,null,null,null,null,null,"Кіль-ть \"0\"",null,{"$f":"COUNTIF(L2:L18,0)","v":0},{"$f":"COUNTIF(M2:M18,0)","v":1},0,0,0,0,1,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"% нульових значень",null,{"$f":"L21/(COUNTA($K:$K)-1)","v":0},{"$f":"M21/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"N21/(COUNTA($K:$K)-1)","v":0},{"$f":"O21/(COUNTA($K:$K)-1)","v":0},{"$f":"P21/(COUNTA($K:$K)-1)","v":0},{"$f":"Q21/(COUNTA($K:$K)-1)","v":0},{"$f":"R21/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"S21/(COUNTA($K:$K)-1)","v":0},{"$f":"T21/(COUNTA($K:$K)-1)","v":0},{"$f":"U21/(COUNTA($K:$K)-1)","v":0},{"$f":"V21/(COUNTA($K:$K)-1)","v":0},{"$f":"W21/(COUNTA($K:$K)-1)","v":0},{"$f":"X21/(COUNTA($K:$K)-1)","v":0},{"$f":"Y21/(COUNTA($K:$K)-1)","v":0},{"$f":"Z21/(COUNTA($K:$K)-1)","v":0},{"$f":"AA21/(COUNTA($K:$K)-1)","v":0}]
[null,null,null,null,null,null,null,null,null,"Кіль-ть \"1/2\"",null,{"$f":"COUNTIF(L2:L18,1.8)","v":0},{"$f":"COUNTIF(M2:M18,1.8)","v":0},0,0,0,0,3,0,1,0,1,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,"Відсоток 1/2 значень",null,{"$f":"L23/(COUNTA($K:$K)-1)","v":0},{"$f":"M23/(COUNTA($K:$K)-1)","v":0},{"$f":"N23/(COUNTA($K:$K)-1)","v":0},{"$f":"O23/(COUNTA($K:$K)-1)","v":0},{"$f":"P23/(COUNTA($K:$K)-1)","v":0},{"$f":"Q23/(COUNTA($K:$K)-1)","v":0},{"$f":"R23/(COUNTA($K:$K)-1)","v":0.17647058823529413},{"$f":"S23/(COUNTA($K:$K)-1)","v":0},{"$f":"T23/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"U23/(COUNTA($K:$K)-1)","v":0},{"$f":"V23/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"W23/(COUNTA($K:$K)-1)","v":0},{"$f":"X23/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"Y23/(COUNTA($K:$K)-1)","v":0},{"$f":"Z23/(COUNTA($K:$K)-1)","v":0},{"$f":"AA23/(COUNTA($K:$K)-1)","v":0}]
[null,null,null,null,null,null,null,null,null,"Кількісний показник невиконання пункту",null,{"$f":"COUNTIF(L2:L18,0)+COUNTIF(L2:L18,1.8)","v":0},{"$f":"COUNTIF(M2:M18,0)+COUNTIF(M2:M18,1.8)","v":1},0,0,0,0,4,0,1,0,1,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,"Відсоток невиконання пункту",null,{"$f":"L25/(COUNTA($K:$K)-1)","v":0},{"$f":"M25/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"N25/(COUNTA($K:$K)-1)","v":0},{"$f":"O25/(COUNTA($K:$K)-1)","v":0},{"$f":"P25/(COUNTA($K:$K)-1)","v":0},{"$f":"Q25/(COUNTA($K:$K)-1)","v":0},{"$f":"R25/(COUNTA($K:$K)-1)","v":0.23529411764705882},{"$f":"S25/(COUNTA($K:$K)-1)","v":0},{"$f":"T25/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"U25/(COUNTA($K:$K)-1)","v":0},{"$f":"V25/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"W25/(COUNTA($K:$K)-1)","v":0},{"$f":"X25/(COUNTA($K:$K)-1)","v":5.8823529411764705E-2},{"$f":"Y25/(COUNTA($K:$K)-1)","v":0},{"$f":"Z25/(COUNTA($K:$K)-1)","v":0},{"$f":"AA25/(COUNTA($K:$K)-1)","v":0}]
[null,null,null,null,null,null,null,null,null,"К-ть втрачених балів",null,{"$f":"3-AVERAGE(L2:L18)","v":0},{"$f":"3-AVERAGE(M2:M18)","v":-2.0823529411764712},-2.7176470588235295,-12,-11.647058823529411,-10.235294117647058,0.38823529411764701,-1.882352941176471,7.058823529411784E-2,0,7.058823529411784E-2,-2,7.058823529411784E-2,-2,-2,-1.882352941176471]

{"sheet":"Исходный","index":1,"n_rows":18,"n_cols":28,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["hat 1","hat 2","hat 3","hat 4","hat 5","hat 6","hat 7","hat 8","hat 9","hat 10","hat 11","hat 12","hat 13","hat 14","hat 15","hat 16","hat 17","hat 18","hat 19","hat 20","hat 21","hat 22","hat 23","hat 24","hat 25","hat 26","hat 27","hat 28"]
[null,null,null,null,null,null,null,null,null,"2013-06-12T16:06:13","S",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-17T20:46:15","T",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-21T23:21:21","S",3,6,6,15,15,15,0,5,3,3,3,5,3,5,5,3,95]
[null,null,null,null,null,null,null,null,null,"2013-06-22T11:25:53","A",3,3.6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,97.6]
[null,null,null,null,null,null,null,null,null,"2013-06-10T19:31:19","S",3,6,3.6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,96.4]
[null,null,null,null,null,null,null,null,null,"2013-06-18T16:09:05","T",3,0,6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,92.8]
[null,null,null,null,null,null,null,null,null,"2013-06-26T18:49:30","A",3,6,3.6,15,15,15,3,5,3,3,3,5,1.8,5,5,5,96.399999999999991]
[null,null,null,null,null,null,null,null,null,"2013-06-11T14:33:23","T",3,3.6,6,15,15,15,3,3,3,3,3,5,3,5,5,5,95.6]
[null,null,null,null,null,null,null,null,null,"2013-06-13T20:47:18","S",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-26T17:37:37","A",3,3.6,6,15,15,15,3,5,1.8,3,3,5,3,5,5,5,96.399999999999991]
[null,null,null,null,null,null,null,null,null,"2013-06-05T20:34:57","S",3,6,6,15,9,9,3,5,3,3,3,5,3,5,5,5,88]
[null,null,null,null,null,null,null,null,null,"2013-06-11T10:37:02","T",3,6,6,15,15,9,3,5,3,3,1.8,5,3,5,5,5,92.8]
[null,null,null,null,null,null,null,null,null,"2013-06-29T15:28:26","A",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-18T17:41:54","T",3,6,6,15,15,15,1.8,5,3,3,3,5,3,5,5,5,98.8]
[null,null,null,null,null,null,null,null,null,"2013-06-03T09:08:01","S",3,6,6,15,15,9,3,5,3,3,3,5,3,5,5,5,94]
[null,null,null,null,null,null,null,null,null,"2013-06-11T18:07:10","A",3,6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,100]
[null,null,null,null,null,null,null,null,null,"2013-06-14T14:28:45","S",3,3.6,6,15,15,15,3,5,3,3,3,5,3,5,5,5,97.6]