{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["2007-05-01",5000,3500,null,"2007-06-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H1,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H1,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":0},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G9995,H1,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 май"]
[null,{"$f":"B1-C1","v":1500},0]
[null,{"$f":"B2-C2","v":1500},1000]
[null,{"$f":"B3-C3","v":500},2000]
[null,{"$f":"B4-C4","v":-1500},1200]
[null,null,200]
[null,null,3000]
[null,null,260]
[]
["2007-06-01",null,null,null,"2007-07-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H10,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H10,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":569.44000000000005},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G9996,H10,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 июнь"]
["2007-07-01",null,null,null,"2007-08-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H11,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H11,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":71.8},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G9997,H11,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 июль"]
["2007-08-01",null,null,null,"2007-09-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H12,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H12,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":371.19},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G9998,H12,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 август"]
["2007-09-01",null,null,null,"2007-10-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H13,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H13,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":255.43},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G9999,H13,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 сентябрь"]
["2007-10-01",null,null,null,"2007-11-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H14,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H14,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":660.7},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10000,H14,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 октябрь"]
["2007-11-01",null,null,null,"2007-12-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H15,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H15,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":744.95},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10001,H15,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 ноябрь"]
["2007-12-01",null,null,null,"2008-01-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H16,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H16,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":80.38},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10002,H16,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2007 декабрь"]
["2008-01-01",null,null,null,"2008-02-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H17,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H17,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":212.37},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10003,H17,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 январь"]
["2008-02-01",null,null,null,"2008-03-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H18,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H18,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":5},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10004,H18,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 февраль"]
["2008-03-01",null,null,null,"2008-04-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H19,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H19,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":361.06},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10005,H19,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 март"]
["2008-04-01",null,null,null,"2008-05-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H20,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H20,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":346.22},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10006,H20,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 апрель"]
["2008-05-01",null,null,null,"2008-06-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H21,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H21,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":467.25},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10007,H21,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 май"]
["2008-06-01",null,null,null,"2008-07-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H22,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H22,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":1092.55},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10008,H22,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 июнь"]
["2008-07-01",null,null,null,"2008-08-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H23,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H23,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":2111.86},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10009,H23,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 июль"]
["2008-08-01",null,null,null,"2008-09-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H24,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H24,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":1844.57},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10010,H24,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 август"]
["2008-09-01",null,null,null,"2008-10-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H25,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H25,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":2001.48},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10011,H25,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 сентябрь"]
["2008-10-01",null,null,null,"2008-11-11",{"$f":"IF(ISNA(INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H26,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9)),,INDEX('[1]ReportAccountPaymentByPeriods '!$A$1:$Q$10000,MATCH(H26,'[1]ReportAccountPaymentByPeriods '!$G$1:$G$10000,0),9))","v":2085.0100000000002},{"$f":"SUMIF('[1]ReportAccountPaymentByPeriods '!$G$1:$G10012,H26,'[1]ReportAccountPaymentByPeriods '!$I$1:$I$10000)","v":{"$error":"#VALUE!"}},"2008 октябрь"]
[]
[]
[]
[]
[]
["Добрый день. Ребят каким должен быть код на VBA если нужно чтоб при записи в ячейку C1 числа меньшего  т.е C1<B1 то вставляется пустая строка ниже,  ячейка в которой под значением 5000 т.е в ячейке B2 имела уже разность значений B1-С1  и так далее пока число в пустой ячейке не запишется отрицательным. И еще момент если B1=C2 то строка не вставляется."]

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