{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":"Лист1","index":0,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Доп стобец","Столбец1","кол-во","Номер"]
[{"$f":"IF(Лист1!$B2=\"Start\",ROW(),A1)","v":2},"Start",{"$f":"IF(B2=\"Start\",MATCH(\"end\",B2:$B$96,0)-2,\"\")","v":4},{"$f":"IF(OR(Лист1!$B2=\"Start\",Лист1!$B2=\"end\",B3=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B3=\"Start\",ROW(),A2)","v":2},1,{"$f":"IF(B3=\"Start\",MATCH(\"end\",B3:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B3=\"Start\",Лист1!$B3=\"end\",B4=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":1}]
[{"$f":"IF(Лист1!$B4=\"Start\",ROW(),A3)","v":2},2,{"$f":"IF(B4=\"Start\",MATCH(\"end\",B4:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B4=\"Start\",Лист1!$B4=\"end\",B5=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":2},null,null,"1. Кол-во строк от Start  до end(Блоков от Start до end приходится копировать много, на примере 3 блока)"]
[{"$f":"IF(Лист1!$B5=\"Start\",ROW(),A4)","v":2},3,{"$f":"IF(B5=\"Start\",MATCH(\"end\",B5:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B5=\"Start\",Лист1!$B5=\"end\",B6=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":3},null,null,"2. Порядковый номер от 1 до n; при вставлении строки автоматически обновляется нумерация"]
[{"$f":"IF(Лист1!$B6=\"Start\",ROW(),A5)","v":2},4,{"$f":"IF(B6=\"Start\",MATCH(\"end\",B6:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B6=\"Start\",Лист1!$B6=\"end\",B7=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":4}]
[{"$f":"IF(Лист1!$B7=\"Start\",ROW(),A6)","v":2},"end",{"$f":"IF(B7=\"Start\",MATCH(\"end\",B7:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B7=\"Start\",Лист1!$B7=\"end\",B8=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B8=\"Start\",ROW(),A7)","v":2},null,{"$f":"IF(B8=\"Start\",MATCH(\"end\",B8:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B8=\"Start\",Лист1!$B8=\"end\",B9=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B9=\"Start\",ROW(),A8)","v":9},"Start",{"$f":"IF(B9=\"Start\",MATCH(\"end\",B9:$B$96,0)-2,\"\")","v":2},{"$f":"IF(OR(Лист1!$B9=\"Start\",Лист1!$B9=\"end\",B10=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B10=\"Start\",ROW(),A9)","v":9},3,{"$f":"IF(B10=\"Start\",MATCH(\"end\",B10:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B10=\"Start\",Лист1!$B10=\"end\",B11=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":1}]
[{"$f":"IF(Лист1!$B11=\"Start\",ROW(),A10)","v":9},4,{"$f":"IF(B11=\"Start\",MATCH(\"end\",B11:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B11=\"Start\",Лист1!$B11=\"end\",B12=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":2}]
[{"$f":"IF(Лист1!$B12=\"Start\",ROW(),A11)","v":9},"end",{"$f":"IF(B12=\"Start\",MATCH(\"end\",B12:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B12=\"Start\",Лист1!$B12=\"end\",B13=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B13=\"Start\",ROW(),A12)","v":9},null,{"$f":"IF(B13=\"Start\",MATCH(\"end\",B13:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B13=\"Start\",Лист1!$B13=\"end\",B14=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B14=\"Start\",ROW(),A13)","v":14},"Start",{"$f":"IF(B14=\"Start\",MATCH(\"end\",B14:$B$96,0)-2,\"\")","v":6},{"$f":"IF(OR(Лист1!$B14=\"Start\",Лист1!$B14=\"end\",B15=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B15=\"Start\",ROW(),A14)","v":14},1,{"$f":"IF(B15=\"Start\",MATCH(\"end\",B15:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B15=\"Start\",Лист1!$B15=\"end\",B16=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":1}]
[{"$f":"IF(Лист1!$B16=\"Start\",ROW(),A15)","v":14},2,{"$f":"IF(B16=\"Start\",MATCH(\"end\",B16:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B16=\"Start\",Лист1!$B16=\"end\",B17=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":2}]
[{"$f":"IF(Лист1!$B17=\"Start\",ROW(),A16)","v":14},3,{"$f":"IF(B17=\"Start\",MATCH(\"end\",B17:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B17=\"Start\",Лист1!$B17=\"end\",B18=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":3}]
[{"$f":"IF(Лист1!$B18=\"Start\",ROW(),A17)","v":14},4,{"$f":"IF(B18=\"Start\",MATCH(\"end\",B18:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B18=\"Start\",Лист1!$B18=\"end\",B19=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":4}]
[{"$f":"IF(Лист1!$B19=\"Start\",ROW(),A18)","v":14},5,{"$f":"IF(B19=\"Start\",MATCH(\"end\",B19:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B19=\"Start\",Лист1!$B19=\"end\",B20=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":5}]
[{"$f":"IF(Лист1!$B20=\"Start\",ROW(),A19)","v":14},6,{"$f":"IF(B20=\"Start\",MATCH(\"end\",B20:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B20=\"Start\",Лист1!$B20=\"end\",B21=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":6}]
[{"$f":"IF(Лист1!$B21=\"Start\",ROW(),A20)","v":14},"end",{"$f":"IF(B21=\"Start\",MATCH(\"end\",B21:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B21=\"Start\",Лист1!$B21=\"end\",B22=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B22=\"Start\",ROW(),A21)","v":14},null,{"$f":"IF(B22=\"Start\",MATCH(\"end\",B22:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B22=\"Start\",Лист1!$B22=\"end\",B23=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B23=\"Start\",ROW(),A22)","v":23},"Start",{"$f":"IF(B23=\"Start\",MATCH(\"end\",B23:$B$96,0)-2,\"\")","v":3},{"$f":"IF(OR(Лист1!$B23=\"Start\",Лист1!$B23=\"end\",B24=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]
[{"$f":"IF(Лист1!$B24=\"Start\",ROW(),A23)","v":23},null,{"$f":"IF(B24=\"Start\",MATCH(\"end\",B24:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B24=\"Start\",Лист1!$B24=\"end\",B25=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":1}]
[{"$f":"IF(Лист1!$B25=\"Start\",ROW(),A24)","v":23},null,{"$f":"IF(B25=\"Start\",MATCH(\"end\",B25:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B25=\"Start\",Лист1!$B25=\"end\",B26=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":2}]
[{"$f":"IF(Лист1!$B26=\"Start\",ROW(),A25)","v":23},null,{"$f":"IF(B26=\"Start\",MATCH(\"end\",B26:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B26=\"Start\",Лист1!$B26=\"end\",B27=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":3}]
[{"$f":"IF(Лист1!$B27=\"Start\",ROW(),A26)","v":23},"end",{"$f":"IF(B27=\"Start\",MATCH(\"end\",B27:$B$96,0)-2,\"\")","v":""},{"$f":"IF(OR(Лист1!$B27=\"Start\",Лист1!$B27=\"end\",B28=\"Start\"),\"\",ROW()-Таблица2[[#This Row],[Доп стобец]])","v":""}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}