{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Status","Сводная"],"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":"Status","index":0,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
["№ п.п.","Станция","Кластер №","Кластер №","Рекомендации выполнены"]
[]
[{"$f":"SUBTOTAL(3,A4:A99959)","v":162},162,162,162,{"$f":"SUBTOTAL(3,E4:E99959)","v":61}]
[1,950001,"cl 12","Недостаток1"]
[2,950012,"cl 12","Недостаток2","Выполнено"]
[3,950013,"cl 12","Недостаток3","Выполнено"]
[4,950014,"cl 12","Недостаток4","Выполнено"]
[5,950016,"cl 12","Недостаток5","Выполнено"]
[7,950017,"cl 12","Недостаток6","Выполнено"]
[8,950022,"cl 12","Недостаток7"]
[9,950023,"cl 12","Недостаток8","Выполнено"]
[10,950028,"cl 12","Недостаток9","Выполнено"]
[11,950029,"cl 12","Недостаток10","Выполнено"]
[12,950029,"cl 12","Недостаток11","Выполнено"]
[13,950031,"cl 12","Недостаток12","Выполнено"]
[14,950034,"cl 12","Недостаток13","Выполнено"]
[15,950041,"cl 8","Недостаток14","Выполнено"]
[16,950044,"cl 8","Недостаток15","Выполнено"]
[17,950045,"cl 8","Недостаток16","Выполнено"]
[18,950045,"cl 8","Недостаток17","Выполнено"]
[19,950046,"cl 8","Недостаток18","Выполнено"]
[20,950047,"cl 8","Недостаток19","Выполнено"]
[21,950051,"cl 8","Недостаток20","Выполнено"]
[23,950053,"cl 8","Недостаток21","Выполнено"]
[24,950053,"cl 8","Недостаток22","Выполнено"]
[25,950054,"cl 8","Недостаток23","Выполнено"]
[26,950055,"cl 8","Недостаток24","Выполнено"]
[27,950058,"cl 8","Недостаток25","Выполнено"]
[28,950060,"cl 3","Недостаток26","Выполнено"]
[29,950061,"cl 3","Недостаток27"]
[30,950061,"cl 3","Недостаток28","Выполнено"]
[31,950061,"cl 3","Недостаток29","Выполнено"]
[32,950061,"cl 3","Недостаток30","Выполнено"]
[37,950065,"cl 10","Недостаток31"]
[38,950066,"cl 10","Недостаток32"]
[39,950066,"cl 10","Недостаток33"]
[40,950068,"cl 10","Недостаток34"]
[41,950072,"cl 9","Недостаток35"]
[42,950072,"cl 9","Недостаток36"]
[43,950072,"cl 9","Недостаток37"]
[44,950078,"cl 4","Недостаток38"]
[45,950084,"cl 4","Недостаток39"]
[46,950089,"cl 4","Недостаток40"]
[47,950090,"cl 4","Недостаток41"]
[48,950095,"cl 6","Недостаток42","Выполнено"]
[49,950096,"cl 6","Недостаток43"]
[50,950096,"cl 6","Недостаток44"]
[51,950096,"cl 6","Недостаток45"]
[52,950096,"cl 6","Недостаток46"]
[53,950097,"cl 6","Недостаток47"]
[54,950097,"cl 6","Недостаток48"]
[58,950099,"cl 6","Недостаток49","Выполнено"]
[59,950101,"cl 11","Недостаток50"]
[60,950101,"cl 11","Недостаток51"]
[61,950102,"cl 11","Недостаток52"]
[62,950104,"cl 11","Недостаток53"]
[63,950104,"cl 11","Недостаток54"]
[64,950106,"cl 11","Недостаток55"]
[65,950108,"cl 11","Недостаток56"]
[66,950109,"cl 8","Недостаток57","Выполнено"]
[72,950118,"cl 7","Недостаток58"]
[73,950119,"cl 7","Недостаток59"]
[74,950119,"cl 7","Недостаток60"]
[78,950121,"cl 3","Недостаток61"]
[79,950122,"cl 5","Недостаток62","Выполнено"]
[80,950123,"cl 5","Недостаток63"]
[81,950123,"cl 5","Недостаток64"]
[82,950123,"cl 5","Недостаток65"]
[83,950124,"cl 10","Недостаток66"]
[84,950129,"cl 6","Недостаток67","Выполнено"]
[85,950129,"cl 6","Недостаток68","Выполнено"]
[86,950132,"cl 1","Недостаток69"]
[88,950133,"cl 1","Недостаток70"]
[89,950133,"cl 1","Недостаток71"]
[90,950133,"cl 1","Недостаток72"]
[92,950138,"cl 9","Недостаток73","Выполнено"]
[93,950139,"cl 9","Недостаток74","Выполнено"]
[94,950139,"cl 9","Недостаток75","Выполнено"]
[95,950139,"cl 9","Недостаток76"]
[96,950139,"cl 9","Недостаток77"]
[97,950140,"cl 9","Недостаток78"]
[98,950140,"cl 9","Недостаток79"]
[99,950142,"cl 9","Недостаток80"]
[100,950142,"cl 9","Недостаток81"]
[101,950142,"cl 9","Недостаток82"]
[102,950145,"cl 6","Недостаток83"]
[103,950149,"cl 5","Недостаток84","Выполнено"]
[104,950152,"cl 5","Недостаток85","Выполнено"]
[105,950154,"cl 5","Недостаток86"]
[106,950154,"cl 5","Недостаток87"]
[107,950155,"cl 5","Недостаток88","Выполнено"]
[108,950157,"cl 5","Недостаток89","Выполнено"]
[109,950158,"cl 5","Недостаток90","Выполнено"]
[110,950159,"cl 5","Недостаток91","Выполнено"]
[111,950160,"cl 5","Недостаток92"]
[112,950160,"cl 5","Недостаток93"]
[113,950162,"cl 5","Недостаток94"]
[115,950163,"cl 7","Недостаток95"]
[116,950163,"cl 7","Недостаток96"]
[118,950164,"cl 7","Недостаток97"]
[119,950166,"cl 7","Недостаток98"]
[120,950168,"cl 5","Недостаток99"]
[122,950169,"cl 2","Недостаток100"]
[123,950173,"cl 6","Недостаток101"]
[125,950174,"cl 6","Недостаток102"]
[126,950177,"cl 6","Недостаток103","Выполнено"]
[127,950177,"cl 6","Недостаток104","Выполнено"]
[129,950178,"cl 6","Недостаток105"]
[130,950178,"cl 6","Недостаток106"]
[131,950178,"cl 6","Недостаток107"]
[132,950178,"cl 6","Недостаток108"]
[133,950178,"cl 6","Недостаток109"]
[134,950179,"cl 6","Недостаток110"]
[135,950179,"cl 6","Недостаток111"]
[136,950180,"cl 7","Недостаток112"]
[137,950180,"cl 7","Недостаток113"]
[138,950180,"cl 7","Недостаток114","Выполнено"]
[139,950180,"cl 7","Недостаток115","Выполнено"]
[140,950181,"cl 7","Недостаток116"]
[141,950182,"cl 7","Недостаток117","Выполнено"]
[142,950182,"cl 7","Недостаток118","Выполнено"]
[143,950182,"cl 7","Недостаток119","Выполнено"]
[144,950182,"cl 7","Недостаток120","Выполнено"]
[146,950183,"cl 7","Недостаток121"]
[147,950183,"cl 7","Недостаток122"]
[148,950183,"cl 7","Недостаток123"]
[149,950184,"cl 7","Недостаток124"]
[150,950184,"cl 7","Недостаток125","Выполнено"]
[151,950185,"cl 7","Недостаток126"]
[152,950185,"cl 7","Недостаток127","Выполнено"]
[153,950186,"cl 7","Недостаток128"]
[154,950187,"cl 7","Недостаток129"]
[155,950187,"cl 7","Недостаток130"]
[157,950187,"cl 7","Недостаток131"]
[158,950187,"cl 7","Недостаток132","Выполнено"]
[159,950188,"cl 9","Недостаток133","Выполнено"]
[160,950188,"cl 9","Недостаток134","Выполнено"]
[162,950188,"cl 9","Недостаток135","Выполнено"]
[163,950190,"cl 8","Недостаток136","Выполнено"]
[164,950192,"cl 2","Недостаток137","Выполнено"]
[165,950192,"cl 2","Недостаток138","Выполнено"]
[166,950193,"cl 11","Недостаток139"]
[167,950193,"cl 11","Недостаток140"]
[168,950193,"cl 11","Недостаток141"]
[169,950193,"cl 11","Недостаток142"]
[173,950203,"cl 1","Недостаток143"]
[174,950203,"cl 1","Недостаток144"]
[175,950203,"cl 1","Недостаток145"]
[176,950203,"cl 1","Недостаток146"]
[178,950220,"cl 9","Недостаток147"]
[179,950220,"cl 9","Недостаток148"]
[180,950222,"cl 9","Недостаток149"]
[181,950223,"cl 9","Недостаток150"]
[182,950243,"cl 9","Недостаток151"]
[183,950299,"cl 8","Недостаток152","Выполнено"]
[184,950299,"cl 8","Недостаток153"]
[185,950312,"cl 1","Недостаток154","Выполнено"]
[186,950335,"cl 9","Недостаток155"]
[188,950400,"cl 11","Недостаток156"]
[189,950400,"cl 11","Недостаток157"]
[190,950400,"cl 11","Недостаток158"]
[191,950400,"cl 11","Недостаток159"]
[192,950285,"cl 11","Недостаток160"]
[193,950401,"cl 8","Недостаток161"]
[194,950401,"cl 8","Недостаток162"]

{"sheet":"Сводная","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Недостатков в кластере","Устранено\nнедостатков","% Устраненных недостатков\n в кластере","Станций в кластере с рекомендациями по устранению","Зачищено станций*","% Зачищенных станций\n в кластере",null,"*Должно считаться только, если выполнены все рекомендации для станции. Например: для cl 1, должно получиться 4, если выполнены 9 недостатков для этого cl 1.  Или станция 950133 считается зачищенной, если на ней устранены все 3 недостатка."]
["cl 1",{"$f":"COUNTIF(Status!C:C,A2)","v":9},{"$f":"COUNTIFS(Status!C:C, A2, Status!E:E, \">=\"\"\")","v":1},{"$f":"C2/B2","v":0.1111111111111111},{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A2, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":4},{"$f":"stat_protected(A2,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":1},{"$f":"F2/E2","v":0.25}]
["cl 2",{"$f":"COUNTIF(Status!C:C,A3)","v":3},{"$f":"COUNTIFS(Status!C:C, A3, Status!E:E, \">=\"\"\")","v":2},{"$f":"C3/B3","v":0.66666666666666663},{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A3, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":2},{"$f":"stat_protected(A3,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":1},{"$f":"F3/E3","v":0.5}]
["cl 3",{"$f":"COUNTIF(Status!C:C,A4)","v":6},{"$f":"COUNTIFS(Status!C:C, A4, Status!E:E, \">=\"\"\")","v":4},0.66666666666666663,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A4, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":3},{"$f":"stat_protected(A4,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":1},0.33333333333333331]
["cl 4",{"$f":"COUNTIF(Status!C:C,A5)","v":4},{"$f":"COUNTIFS(Status!C:C, A5, Status!E:E, \">=\"\"\")","v":0},0,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A5, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":4},{"$f":"stat_protected(A5,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":0},0]
["cl 5",{"$f":"COUNTIF(Status!C:C,A6)","v":16},{"$f":"COUNTIFS(Status!C:C, A6, Status!E:E, \">=\"\"\")","v":7},0.4375,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A6, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":12},{"$f":"stat_protected(A6,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":7},0.58333333333333337]
["cl 6",{"$f":"COUNTIF(Status!C:C,A7)","v":22},{"$f":"COUNTIFS(Status!C:C, A7, Status!E:E, \">=\"\"\")","v":6},0.27272727272727271,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A7, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":11},{"$f":"stat_protected(A7,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":4},0.36363636363636365]
["cl 7",{"$f":"COUNTIF(Status!C:C,A8)","v":28},{"$f":"COUNTIFS(Status!C:C, A8, Status!E:E, \">=\"\"\")","v":9},0.32142857142857145,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A8, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":13},{"$f":"stat_protected(A8,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":1},7.6923076923076927E-2]
["cl 8",{"$f":"COUNTIF(Status!C:C,A9)","v":18},{"$f":"COUNTIFS(Status!C:C, A9, Status!E:E, \">=\"\"\")","v":15},0.83333333333333337,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A9, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":14},{"$f":"stat_protected(A9,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":12},0.8571428571428571]
["cl 9",{"$f":"COUNTIF(Status!C:C,A10)","v":22},{"$f":"COUNTIFS(Status!C:C, A10, Status!E:E, \">=\"\"\")","v":6},0.27272727272727271,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A10, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":11},{"$f":"stat_protected(A10,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":2},0.18181818181818182]
["cl 10",{"$f":"COUNTIF(Status!C:C,A11)","v":5},{"$f":"COUNTIFS(Status!C:C, A11, Status!E:E, \">=\"\"\")","v":0},0,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A11, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":4},{"$f":"stat_protected(A11,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":0},0]
["cl 11",{"$f":"COUNTIF(Status!C:C,A12)","v":16},{"$f":"COUNTIFS(Status!C:C, A12, Status!E:E, \">=\"\"\")","v":0},0,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A12, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":8},{"$f":"stat_protected(A12,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":0},0]
["cl 12",{"$f":"COUNTIF(Status!C:C,A13)","v":13},{"$f":"COUNTIFS(Status!C:C, A13, Status!E:E, \">=\"\"\")","v":11},0.84615384615384615,{"$f":"SUM(IF(FREQUENCY(IF(Status!C4:C165=A13, MATCH(Status!B4:B165, Status!B4:B165, 0)), ROW(Status!B4:B165)-ROW(Status!$B$4)+1), 1))","v":12},{"$f":"stat_protected(A13,Status!$B$4:$B$165,Status!$C$4:$C$165,Status!$E$4:$E$165)","v":10},0.83333333333333337]
["Итого:",{"$f":"SUM(B2:B13)","v":162},{"$f":"SUM(C2:C13)","v":61},0.37654320987654322,{"$f":"SUM(E2:E13)","v":98},{"$f":"SUM(F2:F13)","v":39},0.39795918367346939]