{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[[20,4,22,4],[45,4,47,4]]}
[null,{"$f":"B2+B6","v":910}]
[null,{"$f":"SUM(B3:B5)","v":490}]
[1,{"$f":"90+$C$3","v":90}]
[1,{"$f":"100+$C$4","v":100}]
[1,{"$f":"300+$C$5","v":300}]
[null,{"$f":"SUM(B7:B9)","v":420}]
[1,{"$f":"70+$C$7","v":70}]
[1,{"$f":"200+$C$8","v":200}]
[1,{"$f":"150+$C$9","v":150}]
[null,{"$f":"B11+B15","v":270}]
[null,{"$f":"SUM(B12:B14)","v":140}]
[1,{"$f":"90+$C$12","v":90}]
[1,{"$f":"0+$C$13","v":0}]
[1,{"$f":"50+$C$14","v":50}]
[null,{"$f":"SUM(B16:B18)","v":130}]
[1,{"$f":"0+$C$16","v":0}]
[1,{"$f":"100+$C$17","v":100}]
[1,{"$f":"30+$C$18","v":30}]
[null,{"$f":"B1+B10","v":1180}]
[]
[null,null,null,null,"После применения 1-го макроса должно получиться так"]
[]
[]
[]
[]
[null,{"$f":"B27+B31","v":640},{"$f":"C27+C31","v":0}]
[null,{"$f":"SUM(B28:B30)","v":320},{"$f":"SUM(C28:C30)","v":0}]
[1,70]
[1,100]
[1,150]
[null,{"$f":"SUM(B32:B34)","v":320},{"$f":"SUM(C32:C34)","v":0}]
[1,70]
[1,100]
[1,150]
[null,{"$f":"B36+B40","v":200},{"$f":"C36+C40","v":0}]
[null,{"$f":"SUM(B37:B39)","v":110},{"$f":"SUM(C37:C39)","v":0}]
[1,60]
[1,0]
[1,50]
[null,{"$f":"SUM(B41:B43)","v":90},{"$f":"SUM(C41:C43)","v":0}]
[1,0]
[1,60]
[1,30]
[null,{"$f":"B26+B35","v":840},{"$f":"C26+C35","v":0}]
[]
[null,null,null,null,"После применения 2-го макроса должно получиться так"]
[]
[]
[]
[]
[null,{"$f":"B52+B56","v":640},{"$f":"C52+C56","v":0}]
[null,{"$f":"SUM(B53:B55)","v":320},{"$f":"SUM(C53:C55)","v":0}]
[1,{"$f":"70+C53","v":70}]
[1,{"$f":"100+C54","v":100}]
[1,{"$f":"150+C55","v":150}]
[null,{"$f":"SUM(B57:B59)","v":320},{"$f":"SUM(C57:C59)","v":0}]
[1,{"$f":"70+C57","v":70}]
[1,{"$f":"100+C58","v":100}]
[1,{"$f":"150+C59","v":150}]
[null,{"$f":"B61+B65","v":200},{"$f":"C61+C65","v":0}]
[null,{"$f":"SUM(B62:B64)","v":110},{"$f":"SUM(C62:C64)","v":0}]
[1,{"$f":"60+C62","v":60}]
[1,{"$f":"C63","v":0}]
[1,{"$f":"50+C64","v":50}]
[null,{"$f":"SUM(B66:B68)","v":90},{"$f":"SUM(C66:C68)","v":0}]
[1,{"$f":"C66","v":0}]
[1,{"$f":"60+C67","v":60}]
[1,{"$f":"30+C68","v":30}]
[null,{"$f":"B51+B60","v":840},{"$f":"C51+C60","v":0}]