{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["лист"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":28,"n_cols":19,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,1,4],[1,8,1,10],[1,12,1,14],[1,16,1,18]]}
[null,null,null,null,"Условие 1","Условие 2","Условие 3"]
["Таблица основная",null,null,null,null,null,null,null,"Таблица по 1 условию",null,null,null,"Таблица по 2-м условиям",null,null,null,"Таблица по 3-м условиям"]
["номер","адрес/название","время","сумма",null,null,null,null,"п/н","Адресс","Сумма",null,"п/н","Адресс","Сумма",null,"п/н","Адресс","Сумма"]
[1,"Данные 1",null,1,"Условие 1",null,null,null,1,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A1))),\"\")","v":"Данные 1"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A1))),\"\")","v":1},null,1,null,null,null,1]
[2,"Данные 2",null,2,"Условие 1",null,null,null,2,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A2))),\"\")","v":"Данные 2"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A2))),\"\")","v":2},null,2,null,null,null,2]
[3,"Данные 3",null,3,null,null,null,null,3,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A3))),\"\")","v":"Данные 4"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A3))),\"\")","v":4},null,3,null,null,null,3]
[4,"Данные 4",null,4,"Условие 1","Условие 2","Условие 3",null,4,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A4))),\"\")","v":"Данные 5"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A4))),\"\")","v":5},null,4,null,null,null,4]
[5,"Данные 5",null,5,"Условие 1","Условие 2",null,null,5,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A5))),\"\")","v":"Данные 7"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A5))),\"\")","v":7},null,5,null,null,null,5]
[6,"Данные 6",null,6,null,null,null,null,6,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A6))),\"\")","v":"Данные 9"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A6))),\"\")","v":9},null,6,null,null,null,6]
[7,"Данные 7",null,7,"Условие 1",null,null,null,7,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A7))),\"\")","v":"Данные 12"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A7))),\"\")","v":12},null,7,null,null,null,7]
[8,"Данные 8",null,8,null,null,null,null,8,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A8))),\"\")","v":"Данные 13"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A8))),\"\")","v":13},null,8,null,null,null,8]
[9,"Данные 9",null,9,"Условие 1","Условие 2","Условие 3",null,9,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A9))),\"\")","v":"Данные 14"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A9))),\"\")","v":14},null,9,null,null,null,9]
[10,"Данные 10",null,10,null,null,null,null,10,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A10))),\"\")","v":"Данные 17"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A10))),\"\")","v":17},null,10,null,null,null,10]
[11,"Данные 11",null,11,null,null,null,null,11,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A11))),\"\")","v":"Данные 19"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A11))),\"\")","v":19},null,11,null,null,null,11]
[12,"Данные 12",null,12,"Условие 1","Условие 2",null,null,12,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A12))),\"\")","v":"Данные 20"},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A12))),\"\")","v":20},null,12,null,null,null,12]
[13,"Данные 13",null,13,"Условие 1","Условие 2","Условие 3",null,13,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A13))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A13))),\"\")","v":""},null,13,null,null,null,13]
[14,"Данные 14",null,14,"Условие 1",null,null,null,14,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A14))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A14))),\"\")","v":""},null,14,null,null,null,14]
[15,"Данные 15",null,15,null,null,null,null,15,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A15))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A15))),\"\")","v":""},null,15,null,null,null,15]
[16,"Данные 16",null,16,null,null,null,null,16,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A16))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A16))),\"\")","v":""},null,16,null,null,null,16]
[17,"Данные 17",null,17,"Условие 1","Условие 2",null,null,17,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A17))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A17))),\"\")","v":""},null,17,null,null,null,17]
[18,"Данные 18",null,18,null,null,null,null,18,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A18))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A18))),\"\")","v":""},null,18,null,null,null,18]
[19,"Данные 19",null,19,"Условие 1",null,null,null,19,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A19))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A19))),\"\")","v":""},null,19,null,null,null,19]
[20,"Данные 20",null,20,"Условие 1","Условие 2","Условие 3",null,20,{"$f":"IFERROR(INDEX($B$4:$B$23,SMALL(IF($E$4:$E$23=$E$1,ROW($B$4:$B$23)-3),ROW(A20))),\"\")","v":""},{"$f":"IFERROR(INDEX($D$4:$D$23,SMALL(IF($E$4:$E$23=$E$1,ROW($D$4:$D$23)-3),ROW(A20))),\"\")","v":""},null,20,null,null,null,20]
[]
[]
[]
["Нужно чтобы из Таблица основная данные автоматически заполнялись без промежуточных пустых строк. Без макросов!"]
["офис 2013"]