{"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":0,"comments":1,"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":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[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,null,null,null,null,null,null,1,"Формулу Суммы до следующей цифры в столбце А (округление думаю сам прикручу)"]
[1,null,5,null,null,{"$f":"ROUND(SUMPRODUCT(OFFSET($A5,,5,MATCH($A4+1,$A5:$A500)-1)),4)","v":20.788900000000002},{"$f":"ROUND(SUMPRODUCT(OFFSET($A5,,6,MATCH($A4+1,$A5:$A500)-1)),4)","v":3.3611},{"$f":"ROUND(SUMPRODUCT(OFFSET($A5,,7,MATCH($A4+1,$A5:$A500)-1)),4)","v":2.1486999999999998},{"$f":"ROUND(SUMPRODUCT(OFFSET($A5,,8,MATCH($A4+1,$A5:$A500)-1)),4)","v":5.0713999999999997},{"$f":"ROUND(SUMPRODUCT(OFFSET($A5,,9,MATCH($A4+1,$A5:$A500)-1)),4)","v":2.0139},{"$f":"F4*$C$4","v":103.94450000000001},{"$f":"G4*$C$4","v":16.805499999999999},10.743499999999999,25.356999999999999,10.0695,null,null,2,"Макросом \"скопировать\" формулы из F4:O4 в соответствующие ячейки 12 и 18 и тд строки (критерий цифра в столбце А)"]
[null,null,null,null,null,1,null,0.22222,1.3334699999999999,0.235987,null,null,null,null,null,null,null,3]
[null,null,null,null,null,0.22222,0.235987,0.235987,0.35698000000000002,1.3334699999999999]
[null,null,null,null,null,3,1.3334699999999999,1.3334699999999999,1.3334699999999999,0.22222]
[null,null,null,null,null,5,0.22222,0.35698000000000002,0.35698000000000002]
[null,null,null,null,null,0.566666,null,null,1.3334699999999999,0.22222]
[null,null,null,null,null,6,0.235987,null,0.35698000000000002]
[null,null,null,null,null,5,1.3334699999999999]
[2,null,3,null,null,{"$f":"SUMPRODUCT(OFFSET(A13,,5,MATCH(A12+1,A13:A$34)-1))","v":16.788885999999998},{"$f":"ROUND(SUM(G13:G17),4)","v":0},0,0,0,{"$f":"F12*$C$12","v":50.366657999999994},{"$f":"G12*$C$12","v":0},0,0,0]
[null,null,null,null,null,0.22222]
[null,null,null,null,null,3]
[null,null,null,null,null,5]
[null,null,null,null,null,0.566666]
[null,null,null,null,null,8]
[3,null,1,null,null,{"$f":"ROUND(SUM(F19:F33),4)","v":51.577800000000003},{"$f":"ROUND(SUM(G19:G33),4)","v":0},0,0,0,{"$f":"F18*$C$18","v":51.577800000000003},{"$f":"G18*$C$18","v":0},0,0,0]
[null,null,null,null,null,5]
[null,null,null,null,null,4]
[null,null,null,null,null,8]
[null,null,null,null,null,0.22222]
[null,null,null,null,null,3]
[null,null,null,null,null,5]
[null,null,null,null,null,0.566666]
[null,null,null,null,null,4]
[null,null,null,null,null,0.22222]
[null,null,null,null,null,3]
[null,null,null,null,null,5]
[null,null,null,null,null,0.566666]
[null,null,null,null,null,5]
[null,null,null,null,null,4]
[null,null,null,null,null,4]
["и т.д"]

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