{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Лист1","index":0,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,"должно быть","мероприятия","данные1","данные2","данные3","данные4"]
[null,{"$f":"MAX(INDEX(LEN(фор)-LEN(SUBSTITUTE(фор,\"+\",)),))+1","v":3},{"$f":"LOOKUP(,-MATCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E2:H2),),ROW($1:$9))","v":3},{"$f":"MAX(IFERROR(SEARCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E2:H2))*ROW($1:$9),))","v":3},{"$f":"7+2","v":9},1,{"$f":"1+1+2","v":4},{"$f":"5+2+3","v":10}]
[null,{"$f":"MAX(INDEX(LEN(фор)-LEN(SUBSTITUTE(фор,\"+\",)),))+1","v":2},{"$f":"LOOKUP(,-MATCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E3:H3),),ROW($1:$9))","v":2},{"$f":"MAX(IFERROR(SEARCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E3:H3))*ROW($1:$9),))","v":2},null,{"$f":"1+1","v":2},1,2]
[null,{"$f":"MAX(INDEX(LEN(фор)-LEN(SUBSTITUTE(фор,\"+\",)),))+1","v":4},4,{"$f":"MAX(IFERROR(SEARCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E4:H4))*ROW($1:$9),))","v":4},1,null,null,{"$f":"1+1+1+3","v":6}]
[null,{"$f":"MAX(INDEX(LEN(фор)-LEN(SUBSTITUTE(фор,\"+\",)),))+1","v":5},{"$f":"LOOKUP(,-MATCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E5:H5),),ROW($1:$9))","v":5},{"$f":"MAX(IFERROR(SEARCH(\"=*\"&REPT(\"+*\",ROW($1:$9)-1),_xlfn.FORMULATEXT(E5:H5))*ROW($1:$9),))","v":5},null,{"$f":"1+3","v":4},null,{"$f":"2+3+1+4+5","v":15},"формула в ячейке Н5 (=2+3+1+4+5) показывает 5 слагаемых (мероприятий). В ячейке F5 показано 2 мероприятия (=1+3), что меньше чем показанное в ячейке Н5 и не учитывается."]

{"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":[]}