{"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,{"$f":"IF(COUNTA(E4:G4),H3+1,H3)","v":1},1,{"$f":"IFERROR(INDEX(B:B,MATCH($I4,$H:$H,)),\"\")","v":"Данные 1"},{"$f":"IFERROR(INDEX(D:D,MATCH($I4,$H:$H,)),\"\")","v":1},null,1,null,null,null,1]
[2,"Данные 2",null,2,"Условие 1",null,null,{"$f":"IF(COUNTA(E5:G5),H4+1,H4)","v":2},2,{"$f":"IFERROR(INDEX(B:B,MATCH($I5,$H:$H,)),\"\")","v":"Данные 2"},{"$f":"IFERROR(INDEX(D:D,MATCH($I5,$H:$H,)),\"\")","v":2},null,2,null,null,null,2]
[3,"Данные 3",null,3,null,null,null,2,3,"Данные 4",4,null,3,null,null,null,3]
[4,"Данные 4",null,4,"Условие 1","Условие 2","Условие 3",3,4,"Данные 5",5,null,4,null,null,null,4]
[5,"Данные 5",null,5,"Условие 1","Условие 2",null,4,5,"Данные 7",7,null,5,null,null,null,5]
[6,"Данные 6",null,6,null,null,null,4,6,"Данные 9",9,null,6,null,null,null,6]
[7,"Данные 7",null,7,"Условие 1",null,null,5,7,"Данные 12",12,null,7,null,null,null,7]
[8,"Данные 8",null,8,null,null,null,5,8,"Данные 13",13,null,8,null,null,null,8]
[9,"Данные 9",null,9,"Условие 1","Условие 2","Условие 3",6,9,"Данные 14",14,null,9,null,null,null,9]
[10,"Данные 10",null,10,null,null,null,6,10,"Данные 17",17,null,10,null,null,null,10]
[11,"Данные 11",null,11,null,null,null,6,11,"Данные 19",19,null,11,null,null,null,11]
[12,"Данные 12",null,12,"Условие 1","Условие 2",null,7,12,"Данные 20",20,null,12,null,null,null,12]
[13,"Данные 13",null,13,"Условие 1","Условие 2","Условие 3",8,13,"","",null,13,null,null,null,13]
[14,"Данные 14",null,14,"Условие 1",null,null,9,14,"","",null,14,null,null,null,14]
[15,"Данные 15",null,15,null,null,null,9,15,"","",null,15,null,null,null,15]
[16,"Данные 16",null,16,null,null,null,9,16,"","",null,16,null,null,null,16]
[17,"Данные 17",null,17,"Условие 1","Условие 2",null,10,17,"","",null,17,null,null,null,17]
[18,"Данные 18",null,18,null,null,null,10,18,"","",null,18,null,null,null,18]
[19,"Данные 19",null,19,"Условие 1",null,null,11,19,"","",null,19,null,null,null,19]
[20,"Данные 20",null,20,"Условие 1","Условие 2","Условие 3",12,20,"","",null,20,null,null,null,20]
[]
[]
[]
["Нужно чтобы из Таблица основная данные автоматически заполнялись без промежуточных пустых строк. Без макросов!"]
["офис 2013"]