{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["НКУ","остальные сборочки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":16,"n_cols":31,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["КодKKS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"здесь в реальной таблице текстовые данные большой длины (до 100-200 символов)",null,null,null,null,null,null,{"$f":"COUNTA('остальные сборочки'!W:W)","v":15},"как хотелось бы, чтобы было в столбце 30"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W3,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":""},{"$f":"IF(COUNTIF('остальные сборочки'!W:W,НКУ!W3)>0,1,\"\")","v":""}]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W4,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":8},8]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W5,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":11},11]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W6,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":10},10]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W7,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":1},1]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W8,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":""}]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W9,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":7},7]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W10,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":3},3]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W11,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":12},12]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W12,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":5},5]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W13,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":4},4]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W14,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":6},6]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W15,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":9},9]
[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,{"$f":"IFERROR(INDEX('остальные сборочки'!$AD:$AD,MATCH($W16,'остальные сборочки'!$W$1:INDEX('остальные сборочки'!$W:$W,$AD$1),0)),\"\")","v":2},2]

{"sheet":"остальные сборочки","index":1,"n_rows":15,"n_cols":31,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["КодKKS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"здесь в реальной таблице текстовые данные большой длины (до 100-200 символов)",null,null,null,null,null,null,null,"как хотелось бы, чтобы было в столбце 30"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W3)>0,MAX($AE$2:$AE2)+1,\"\")","v":1},1]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W4)>0,MAX($AE$2:$AE3)+1,\"\")","v":2},2]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W5)>0,MAX($AE$2:$AE4)+1,\"\")","v":3},3]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W6)>0,MAX($AE$2:$AE5)+1,\"\")","v":4},4]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W7)>0,MAX($AE$2:$AE6)+1,\"\")","v":5},5]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W8)>0,MAX($AE$2:$AE7)+1,\"\")","v":""},""]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W9)>0,MAX($AE$2:$AE8)+1,\"\")","v":6},6]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W10)>0,MAX($AE$2:$AE9)+1,\"\")","v":7},7]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W11)>0,MAX($AE$2:$AE10)+1,\"\")","v":8},8]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W12)>0,MAX($AE$2:$AE11)+1,\"\")","v":9},9]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W13)>0,MAX($AE$2:$AE12)+1,\"\")","v":10},10]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W14)>0,MAX($AE$2:$AE13)+1,\"\")","v":11},11]
[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,{"$f":"IF(COUNTIF(НКУ!$W:$W,$W15)>0,MAX($AE$2:$AE14)+1,\"\")","v":12},12]