{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Исходные данные","Дебиторка","Контроль"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Исходные данные","index":0,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Сегодня",{"$f":"TODAY()","v":"2021-09-14"}]
["ИСХОДНЫЕ ДАННЫЕ (ДАТА/СУММА ОПЛАТЫ) ДЛЯ АНАЛИЗА  ДЕБИТОРСКОЙ ЗАДОЛЖЕННОСТИ"]
[null,"ввод данных","ввод данных",null,null,null,null,null,"ввод данных","ввод данных"]
["Клиент","Дата отгрузки","Сумма отгрузки, руб","дата отсрочки","дата оплаты 1","сумма оплаты 1 ,  руб","дата оплаты 2","сумма оплаты 2 ,  руб","дата оплаты N","сумма оплаты N ,  руб","дата оплаты текущая","сумма оплаты нарастающим итогом ,  руб"]
[1,"2 -> [дебиторка]! 2","3 -> [дебиторка]! 3",4,5,6,7,8,9,10,"11 -> [дебиторка]! 5","12 -> [дебиторка]! 6"]
[null,"2021-02-04",25938822.239999998,{"$f":"B6+период_отсрочки","v":"2021-03-06"},"2021-03-21",0,"2021-03-24",0,"2021-09-09",null,{"$f":"I6","v":"2021-09-09"},{"$f":"F6+H6+J6","v":0}]
[null,"2021-02-08",29707567.850000001,"2021-03-10","2021-03-25",0,"2021-03-28",0,"2021-09-09",null,{"$f":"I7","v":"2021-09-09"},{"$f":"F7+H7+J7","v":0}]
[null,"2021-02-15",29615092.079999998,"2021-03-17","2021-04-01",0,"2021-04-04",0,"2021-09-09",null,"2021-09-09",{"$f":"F8+H8+J8","v":0}]
[null,"2021-02-26",25354420.699999999,"2021-03-28","2021-04-12",0,"2021-04-15",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-03-03",29601871.82,"2021-04-02","2021-04-17",0,"2021-04-20",0,"2021-09-09",1000000,"2021-09-09",1000000]
[null,"2021-03-12",null,"2021-04-11","2021-04-26",0,"2021-04-29",0,"2021-09-09",15000000,"2021-09-09",15000000]
[null,"2021-03-16",null,"2021-04-15","2021-04-30",0,"2021-05-03",0,"2021-09-09",15000000,"2021-09-09",15000000]
[null,"2021-03-19",29123331.550000001,"2021-04-18","2021-05-03",0,"2021-05-06",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-03-22",29227672.489999998,"2021-04-21","2021-05-06",0,"2021-05-09",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-03-23",null,"2021-04-22","2021-05-07",0,"2021-05-10",0,"2021-09-09",45000000,"2021-09-09",45000000]
[null,"2021-03-30",null,"2021-04-29","2021-05-14",0,"2021-05-17",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-03-31",null,"2021-04-30","2021-05-15",0,"2021-05-18",0,"2021-09-09",24615902.870000001,"2021-09-09",24615902.870000001]
[null,"2021-04-01",18203997.600000001,"2021-05-01","2021-05-16",0,"2021-05-19",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-04-06",null,"2021-05-06","2021-05-21",0,"2021-05-24",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-04-09",null,"2021-05-09","2021-05-24",0,"2021-05-27",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-04-13",null,"2021-05-13","2021-05-28",0,"2021-05-31",0,"2021-09-09",3000000,"2021-09-09",3000000]
[null,"2021-04-16",null,"2021-05-16","2021-05-31",0,"2021-06-03",0,"2021-09-09",5000000,"2021-09-09",5000000]
[null,"2021-04-20",null,"2021-05-20","2021-06-04",0,"2021-06-07",0,"2021-09-09",4000000,"2021-09-09",4000000]
[null,"2021-04-22",7213916.2999999998,"2021-05-22","2021-06-06",0,"2021-06-09",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-04-23",null,"2021-05-23","2021-06-07",0,"2021-06-10",0,"2021-09-09",20000000,"2021-09-09",20000000]
[null,"2021-04-29",null,"2021-05-29","2021-06-13",0,"2021-06-16",0,"2021-09-09",35952875.859999999,"2021-09-09",35952875.859999999]
[null,"2021-05-11",29582305.870000001,"2021-06-10","2021-06-25",0,"2021-06-28",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-06-08",null,"2021-07-08","2021-07-23",0,"2021-07-26",0,"2021-09-09",2000000,"2021-09-09",2000000]
[null,"2021-06-09",18932506.940000001,"2021-07-09","2021-07-24",0,"2021-07-27",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-06-11",null,"2021-07-11","2021-07-26",0,"2021-07-29",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-06-18",null,"2021-07-18","2021-08-02",0,"2021-08-05",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-06-22",null,"2021-07-22","2021-08-06",0,"2021-08-09",0,"2021-09-09",40000000,"2021-09-09",40000000]
[null,"2021-06-28",13806701.210000001,"2021-07-28","2021-08-12",0,"2021-08-15",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-06-29",null,"2021-07-29","2021-08-13",0,"2021-08-16",0,"2021-09-09",8000000,"2021-09-09",8000000]
[null,"2021-07-01",28592703.550000001,"2021-07-31","2021-08-15",0,"2021-08-18",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-07-02",null,"2021-08-01","2021-08-16",0,"2021-08-19",0,"2021-09-09",1000000,"2021-09-09",1000000]
[null,"2021-07-09",null,"2021-08-08","2021-08-23",0,"2021-08-26",0,"2021-09-09",3000000,"2021-09-09",3000000]
[null,"2021-07-13",null,"2021-08-12","2021-08-27",0,"2021-08-30",0,"2021-09-09",5000000,"2021-09-09",5000000]
[null,"2021-07-15",24757299.5,"2021-08-14","2021-08-29",0,"2021-09-01",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-07-27",28858860.239999998,"2021-08-26","2021-09-10",0,"2021-09-13",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-07-30",null,"2021-08-29","2021-09-13",0,"2021-09-16",0,"2021-09-09",8739427.9199999999,"2021-09-09",8739427.9199999999]
[null,"2021-08-03",24581658.960000001,"2021-09-02","2021-09-17",0,"2021-09-20",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-08-10",null,"2021-09-09","2021-09-24",0,"2021-09-27",0,"2021-09-09",20000000,"2021-09-09",20000000]
[null,"2021-08-20",null,"2021-09-19","2021-10-04",0,"2021-10-07",0,"2021-09-09",20000000,"2021-09-09",20000000]
[null,"2021-08-26",35550253.539999999,"2021-09-25","2021-10-10",0,"2021-10-13",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-08-31",6952888.0099999998,"2021-09-30","2021-10-15",0,"2021-10-18",0,"2021-09-09",10000000,"2021-09-09",10000000]
[null,"2021-09-03",6911768.3799999999,"2021-10-03","2021-10-18",0,"2021-10-21",0,"2021-09-09",null,"2021-09-09",0]
[null,"2021-09-07",null,"2021-10-07","2021-10-22",0,"2021-10-25",0,"2021-09-09",5000000,"2021-09-09",5000000]
[null,"2021-09-10",null,{"$f":"IF(F49>0,VALUE(#REF!),\"\")","v":""},null,null,null,null,"2021-09-09",25000000,"2021-09-09",25000000]
[null,null,null,{"$f":"IF(F50>0,VALUE(#REF!),\"\")","v":""}]
[null,null,{"$f":"SUM(C6:C50)","v":442513638.83000004},null,null,null,null,null,null,{"$f":"SUM(J6:J50)","v":366308206.65000004},null,{"$f":"SUM(L6:L50)","v":366308206.65000004}]

{"sheet":"Дебиторка","index":1,"n_rows":53,"n_cols":16,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,9,1,14]]}
["Сегодня",{"$f":"TODAY()","v":"2021-09-14"},null,null,"отсрочка, дней",30]
[null,null,null,null,null,null,null,null,null,"задолженность"]
["Клиент","Дата отгрузки","Сумма отгрузки, руб","Сумма отгрузки, нарастающим итогом, руб.","дата отсрочки","дата оплаты текущая?","число дней просрочки ","сумма оплаты ,  руб","сумма оплаты нарастающим итогом ,  руб","До 7 дней","От 8 до 15 дней","От 16 до 30 дней","От 31 до 60 дней","От 61 до 90 дней","Свыше 90 дней","Задолженность нарастающим итогом, итого, руб."]
[1,"2 = [исходные данные]! 2","3 = [исходные данные]! 3",4,5,"6 = [исходные данные]!11","7  = сегодня() - 2","8 = [исходные данные]!12",9,10,11,12,13,14,15,"16 =4 - 9"]
[null,null,null,null,null,null,null,null,null,"000-007","008-015","016-030","031-060","061-090","090-999"]
[null,{"$f":"'Исходные данные'!B6","v":"2021-02-04"},{"$f":"'Исходные данные'!C6","v":25938822.239999998},{"$f":"C6","v":25938822.239999998},{"$f":"B6+период_отсрочки","v":"2021-03-06"},{"$f":"'Исходные данные'!K6","v":"2021-09-09"},{"$f":"сего_дня-B6","v":222},{"$f":"'Исходные данные'!L6","v":0},{"$f":"H6","v":0},{"$f":"IFERROR(IF(AND($G6>=--LEFT(J$5,3),$G6<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G6>=--LEFT(K$5,3),$G6<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G6>=--LEFT(L$5,3),$G6<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G6>=--LEFT(M$5,3),$G6<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G6>=--LEFT(N$5,3),$G6<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G6>=--LEFT(O$5,3),$G6<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":25938822.239999998},{"$f":"IF(D6=\"\",\"\",D6-I6)","v":25938822.239999998}]
[null,{"$f":"'Исходные данные'!B7","v":"2021-02-08"},{"$f":"'Исходные данные'!C7","v":29707567.850000001},{"$f":"D6+C7","v":55646390.090000004},"2021-03-10",{"$f":"'Исходные данные'!K7","v":"2021-09-09"},{"$f":"сего_дня-B7","v":218},{"$f":"'Исходные данные'!L7","v":0},{"$f":"I6+H7","v":0},{"$f":"IFERROR(IF(AND($G7>=--LEFT(J$5,3),$G7<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G7>=--LEFT(K$5,3),$G7<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G7>=--LEFT(L$5,3),$G7<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G7>=--LEFT(M$5,3),$G7<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G7>=--LEFT(N$5,3),$G7<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G7>=--LEFT(O$5,3),$G7<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":55646390.090000004},{"$f":"IF(D7=\"\",\"\",D7-I7)","v":55646390.090000004}]
[null,{"$f":"'Исходные данные'!B8","v":"2021-02-15"},{"$f":"'Исходные данные'!C8","v":29615092.079999998},{"$f":"D7+C8","v":85261482.170000002},"2021-03-17",{"$f":"'Исходные данные'!K8","v":"2021-09-09"},{"$f":"сего_дня-B8","v":211},{"$f":"'Исходные данные'!L8","v":0},{"$f":"I7+H8","v":0},{"$f":"IFERROR(IF(AND($G8>=--LEFT(J$5,3),$G8<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G8>=--LEFT(K$5,3),$G8<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G8>=--LEFT(L$5,3),$G8<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G8>=--LEFT(M$5,3),$G8<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G8>=--LEFT(N$5,3),$G8<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G8>=--LEFT(O$5,3),$G8<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":85261482.170000002},{"$f":"IF(D8=\"\",\"\",D8-I8)","v":85261482.170000002}]
[null,{"$f":"'Исходные данные'!B9","v":"2021-02-26"},{"$f":"'Исходные данные'!C9","v":25354420.699999999},110615902.87,"2021-03-28",{"$f":"'Исходные данные'!K9","v":"2021-09-09"},{"$f":"сего_дня-B9","v":200},{"$f":"'Исходные данные'!L9","v":0},0,{"$f":"IFERROR(IF(AND($G9>=--LEFT(J$5,3),$G9<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G9>=--LEFT(K$5,3),$G9<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G9>=--LEFT(L$5,3),$G9<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G9>=--LEFT(M$5,3),$G9<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G9>=--LEFT(N$5,3),$G9<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G9>=--LEFT(O$5,3),$G9<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":110615902.87},{"$f":"IF(D9=\"\",\"\",D9-I9)","v":110615902.87}]
[null,{"$f":"'Исходные данные'!B10","v":"2021-03-03"},{"$f":"'Исходные данные'!C10","v":29601871.82},140217774.69,"2021-04-02",{"$f":"'Исходные данные'!K10","v":"2021-09-09"},{"$f":"сего_дня-B10","v":195},{"$f":"'Исходные данные'!L10","v":1000000},1000000,{"$f":"IFERROR(IF(AND($G10>=--LEFT(J$5,3),$G10<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G10>=--LEFT(K$5,3),$G10<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G10>=--LEFT(L$5,3),$G10<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G10>=--LEFT(M$5,3),$G10<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G10>=--LEFT(N$5,3),$G10<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G10>=--LEFT(O$5,3),$G10<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":139217774.69},{"$f":"IF(D10=\"\",\"\",D10-I10)","v":139217774.69}]
[null,{"$f":"'Исходные данные'!B11","v":"2021-03-12"},{"$f":"'Исходные данные'!C11","v":0},140217774.69,"2021-04-11",{"$f":"'Исходные данные'!K11","v":"2021-09-09"},{"$f":"сего_дня-B11","v":186},{"$f":"'Исходные данные'!L11","v":15000000},16000000,{"$f":"IFERROR(IF(AND($G11>=--LEFT(J$5,3),$G11<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G11>=--LEFT(K$5,3),$G11<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G11>=--LEFT(L$5,3),$G11<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G11>=--LEFT(M$5,3),$G11<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G11>=--LEFT(N$5,3),$G11<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G11>=--LEFT(O$5,3),$G11<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":124217774.69},{"$f":"IF(D11=\"\",\"\",D11-I11)","v":124217774.69}]
[null,{"$f":"'Исходные данные'!B12","v":"2021-03-16"},{"$f":"'Исходные данные'!C12","v":0},140217774.69,"2021-04-15",{"$f":"'Исходные данные'!K12","v":"2021-09-09"},{"$f":"сего_дня-B12","v":182},{"$f":"'Исходные данные'!L12","v":15000000},31000000,{"$f":"IFERROR(IF(AND($G12>=--LEFT(J$5,3),$G12<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G12>=--LEFT(K$5,3),$G12<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G12>=--LEFT(L$5,3),$G12<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G12>=--LEFT(M$5,3),$G12<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G12>=--LEFT(N$5,3),$G12<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G12>=--LEFT(O$5,3),$G12<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":109217774.69},{"$f":"IF(D12=\"\",\"\",D12-I12)","v":109217774.69}]
[null,{"$f":"'Исходные данные'!B13","v":"2021-03-19"},{"$f":"'Исходные данные'!C13","v":29123331.550000001},169341106.24000001,"2021-04-18",{"$f":"'Исходные данные'!K13","v":"2021-09-09"},{"$f":"сего_дня-B13","v":179},{"$f":"'Исходные данные'!L13","v":0},31000000,{"$f":"IFERROR(IF(AND($G13>=--LEFT(J$5,3),$G13<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G13>=--LEFT(K$5,3),$G13<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G13>=--LEFT(L$5,3),$G13<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G13>=--LEFT(M$5,3),$G13<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G13>=--LEFT(N$5,3),$G13<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G13>=--LEFT(O$5,3),$G13<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":138341106.24000001},{"$f":"IF(D13=\"\",\"\",D13-I13)","v":138341106.24000001}]
[null,{"$f":"'Исходные данные'!B14","v":"2021-03-22"},{"$f":"'Исходные данные'!C14","v":29227672.489999998},198568778.73000002,"2021-04-21",{"$f":"'Исходные данные'!K14","v":"2021-09-09"},{"$f":"сего_дня-B14","v":176},{"$f":"'Исходные данные'!L14","v":0},31000000,{"$f":"IFERROR(IF(AND($G14>=--LEFT(J$5,3),$G14<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G14>=--LEFT(K$5,3),$G14<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G14>=--LEFT(L$5,3),$G14<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G14>=--LEFT(M$5,3),$G14<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G14>=--LEFT(N$5,3),$G14<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G14>=--LEFT(O$5,3),$G14<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":167568778.73000002},{"$f":"IF(D14=\"\",\"\",D14-I14)","v":167568778.73000002}]
[null,{"$f":"'Исходные данные'!B15","v":"2021-03-23"},{"$f":"'Исходные данные'!C15","v":0},198568778.73000002,"2021-04-22",{"$f":"'Исходные данные'!K15","v":"2021-09-09"},{"$f":"сего_дня-B15","v":175},{"$f":"'Исходные данные'!L15","v":45000000},76000000,{"$f":"IFERROR(IF(AND($G15>=--LEFT(J$5,3),$G15<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G15>=--LEFT(K$5,3),$G15<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G15>=--LEFT(L$5,3),$G15<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G15>=--LEFT(M$5,3),$G15<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G15>=--LEFT(N$5,3),$G15<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G15>=--LEFT(O$5,3),$G15<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":122568778.73000002},{"$f":"IF(D15=\"\",\"\",D15-I15)","v":122568778.73000002}]
[null,{"$f":"'Исходные данные'!B16","v":"2021-03-30"},{"$f":"'Исходные данные'!C16","v":0},198568778.73000002,"2021-04-29",{"$f":"'Исходные данные'!K16","v":"2021-09-09"},{"$f":"сего_дня-B16","v":168},{"$f":"'Исходные данные'!L16","v":10000000},86000000,{"$f":"IFERROR(IF(AND($G16>=--LEFT(J$5,3),$G16<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G16>=--LEFT(K$5,3),$G16<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G16>=--LEFT(L$5,3),$G16<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G16>=--LEFT(M$5,3),$G16<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G16>=--LEFT(N$5,3),$G16<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G16>=--LEFT(O$5,3),$G16<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":112568778.73000002},{"$f":"IF(D16=\"\",\"\",D16-I16)","v":112568778.73000002}]
[null,{"$f":"'Исходные данные'!B17","v":"2021-03-31"},{"$f":"'Исходные данные'!C17","v":0},198568778.73000002,"2021-04-30",{"$f":"'Исходные данные'!K17","v":"2021-09-09"},{"$f":"сего_дня-B17","v":167},{"$f":"'Исходные данные'!L17","v":24615902.870000001},110615902.87,{"$f":"IFERROR(IF(AND($G17>=--LEFT(J$5,3),$G17<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G17>=--LEFT(K$5,3),$G17<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G17>=--LEFT(L$5,3),$G17<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G17>=--LEFT(M$5,3),$G17<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G17>=--LEFT(N$5,3),$G17<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G17>=--LEFT(O$5,3),$G17<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":87952875.860000014},{"$f":"IF(D17=\"\",\"\",D17-I17)","v":87952875.860000014}]
[null,{"$f":"'Исходные данные'!B18","v":"2021-04-01"},{"$f":"'Исходные данные'!C18","v":18203997.600000001},216772776.33000001,"2021-05-01",{"$f":"'Исходные данные'!K18","v":"2021-09-09"},{"$f":"сего_дня-B18","v":166},{"$f":"'Исходные данные'!L18","v":0},110615902.87,{"$f":"IFERROR(IF(AND($G18>=--LEFT(J$5,3),$G18<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G18>=--LEFT(K$5,3),$G18<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G18>=--LEFT(L$5,3),$G18<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G18>=--LEFT(M$5,3),$G18<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G18>=--LEFT(N$5,3),$G18<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G18>=--LEFT(O$5,3),$G18<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":106156873.46000001},{"$f":"IF(D18=\"\",\"\",D18-I18)","v":106156873.46000001}]
[null,{"$f":"'Исходные данные'!B19","v":"2021-04-06"},{"$f":"'Исходные данные'!C19","v":0},216772776.33000001,"2021-05-06",{"$f":"'Исходные данные'!K19","v":"2021-09-09"},{"$f":"сего_дня-B19","v":161},{"$f":"'Исходные данные'!L19","v":10000000},120615902.87,{"$f":"IFERROR(IF(AND($G19>=--LEFT(J$5,3),$G19<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G19>=--LEFT(K$5,3),$G19<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G19>=--LEFT(L$5,3),$G19<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G19>=--LEFT(M$5,3),$G19<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G19>=--LEFT(N$5,3),$G19<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G19>=--LEFT(O$5,3),$G19<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":96156873.460000008},{"$f":"IF(D19=\"\",\"\",D19-I19)","v":96156873.460000008}]
[null,{"$f":"'Исходные данные'!B20","v":"2021-04-09"},{"$f":"'Исходные данные'!C20","v":0},216772776.33000001,"2021-05-09",{"$f":"'Исходные данные'!K20","v":"2021-09-09"},{"$f":"сего_дня-B20","v":158},{"$f":"'Исходные данные'!L20","v":10000000},130615902.87,{"$f":"IFERROR(IF(AND($G20>=--LEFT(J$5,3),$G20<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G20>=--LEFT(K$5,3),$G20<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G20>=--LEFT(L$5,3),$G20<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G20>=--LEFT(M$5,3),$G20<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G20>=--LEFT(N$5,3),$G20<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G20>=--LEFT(O$5,3),$G20<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":86156873.460000008},{"$f":"IF(D20=\"\",\"\",D20-I20)","v":86156873.460000008}]
[null,{"$f":"'Исходные данные'!B21","v":"2021-04-13"},{"$f":"'Исходные данные'!C21","v":0},216772776.33000001,"2021-05-13",{"$f":"'Исходные данные'!K21","v":"2021-09-09"},{"$f":"сего_дня-B21","v":154},{"$f":"'Исходные данные'!L21","v":3000000},133615902.87,{"$f":"IFERROR(IF(AND($G21>=--LEFT(J$5,3),$G21<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G21>=--LEFT(K$5,3),$G21<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G21>=--LEFT(L$5,3),$G21<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G21>=--LEFT(M$5,3),$G21<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G21>=--LEFT(N$5,3),$G21<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G21>=--LEFT(O$5,3),$G21<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":83156873.460000008},{"$f":"IF(D21=\"\",\"\",D21-I21)","v":83156873.460000008}]
[null,{"$f":"'Исходные данные'!B22","v":"2021-04-16"},{"$f":"'Исходные данные'!C22","v":0},216772776.33000001,"2021-05-16",{"$f":"'Исходные данные'!K22","v":"2021-09-09"},{"$f":"сего_дня-B22","v":151},{"$f":"'Исходные данные'!L22","v":5000000},138615902.87,{"$f":"IFERROR(IF(AND($G22>=--LEFT(J$5,3),$G22<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G22>=--LEFT(K$5,3),$G22<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G22>=--LEFT(L$5,3),$G22<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G22>=--LEFT(M$5,3),$G22<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G22>=--LEFT(N$5,3),$G22<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G22>=--LEFT(O$5,3),$G22<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":78156873.460000008},{"$f":"IF(D22=\"\",\"\",D22-I22)","v":78156873.460000008}]
[null,{"$f":"'Исходные данные'!B23","v":"2021-04-20"},{"$f":"'Исходные данные'!C23","v":0},216772776.33000001,"2021-05-20",{"$f":"'Исходные данные'!K23","v":"2021-09-09"},{"$f":"сего_дня-B23","v":147},{"$f":"'Исходные данные'!L23","v":4000000},142615902.87,{"$f":"IFERROR(IF(AND($G23>=--LEFT(J$5,3),$G23<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G23>=--LEFT(K$5,3),$G23<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G23>=--LEFT(L$5,3),$G23<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G23>=--LEFT(M$5,3),$G23<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G23>=--LEFT(N$5,3),$G23<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G23>=--LEFT(O$5,3),$G23<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":74156873.460000008},{"$f":"IF(D23=\"\",\"\",D23-I23)","v":74156873.460000008}]
[null,{"$f":"'Исходные данные'!B24","v":"2021-04-22"},{"$f":"'Исходные данные'!C24","v":7213916.2999999998},223986692.63000003,"2021-05-22",{"$f":"'Исходные данные'!K24","v":"2021-09-09"},{"$f":"сего_дня-B24","v":145},{"$f":"'Исходные данные'!L24","v":0},142615902.87,{"$f":"IFERROR(IF(AND($G24>=--LEFT(J$5,3),$G24<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G24>=--LEFT(K$5,3),$G24<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G24>=--LEFT(L$5,3),$G24<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G24>=--LEFT(M$5,3),$G24<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G24>=--LEFT(N$5,3),$G24<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G24>=--LEFT(O$5,3),$G24<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":81370789.76000002},{"$f":"IF(D24=\"\",\"\",D24-I24)","v":81370789.76000002}]
[null,{"$f":"'Исходные данные'!B25","v":"2021-04-23"},{"$f":"'Исходные данные'!C25","v":0},223986692.63000003,"2021-05-23",{"$f":"'Исходные данные'!K25","v":"2021-09-09"},{"$f":"сего_дня-B25","v":144},{"$f":"'Исходные данные'!L25","v":20000000},162615902.87,{"$f":"IFERROR(IF(AND($G25>=--LEFT(J$5,3),$G25<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G25>=--LEFT(K$5,3),$G25<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G25>=--LEFT(L$5,3),$G25<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G25>=--LEFT(M$5,3),$G25<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G25>=--LEFT(N$5,3),$G25<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G25>=--LEFT(O$5,3),$G25<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":61370789.76000002},{"$f":"IF(D25=\"\",\"\",D25-I25)","v":61370789.76000002}]
[null,{"$f":"'Исходные данные'!B26","v":"2021-04-29"},{"$f":"'Исходные данные'!C26","v":0},223986692.63000003,"2021-05-29",{"$f":"'Исходные данные'!K26","v":"2021-09-09"},{"$f":"сего_дня-B26","v":138},{"$f":"'Исходные данные'!L26","v":35952875.859999999},198568778.73000002,{"$f":"IFERROR(IF(AND($G26>=--LEFT(J$5,3),$G26<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G26>=--LEFT(K$5,3),$G26<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G26>=--LEFT(L$5,3),$G26<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G26>=--LEFT(M$5,3),$G26<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G26>=--LEFT(N$5,3),$G26<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G26>=--LEFT(O$5,3),$G26<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":25417913.900000006},{"$f":"IF(D26=\"\",\"\",D26-I26)","v":25417913.900000006}]
[null,{"$f":"'Исходные данные'!B27","v":"2021-05-11"},{"$f":"'Исходные данные'!C27","v":29582305.870000001},253568998.50000003,"2021-06-10",{"$f":"'Исходные данные'!K27","v":"2021-09-09"},{"$f":"сего_дня-B27","v":126},{"$f":"'Исходные данные'!L27","v":0},198568778.73000002,{"$f":"IFERROR(IF(AND($G27>=--LEFT(J$5,3),$G27<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G27>=--LEFT(K$5,3),$G27<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G27>=--LEFT(L$5,3),$G27<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G27>=--LEFT(M$5,3),$G27<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G27>=--LEFT(N$5,3),$G27<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G27>=--LEFT(O$5,3),$G27<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":55000219.770000011},{"$f":"IF(D27=\"\",\"\",D27-I27)","v":55000219.770000011}]
[null,{"$f":"'Исходные данные'!B28","v":"2021-06-08"},{"$f":"'Исходные данные'!C28","v":0},253568998.50000003,"2021-07-08",{"$f":"'Исходные данные'!K28","v":"2021-09-09"},{"$f":"сего_дня-B28","v":98},{"$f":"'Исходные данные'!L28","v":2000000},200568778.73000002,{"$f":"IFERROR(IF(AND($G28>=--LEFT(J$5,3),$G28<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G28>=--LEFT(K$5,3),$G28<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G28>=--LEFT(L$5,3),$G28<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G28>=--LEFT(M$5,3),$G28<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G28>=--LEFT(N$5,3),$G28<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G28>=--LEFT(O$5,3),$G28<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":53000219.770000011},{"$f":"IF(D28=\"\",\"\",D28-I28)","v":53000219.770000011}]
[null,{"$f":"'Исходные данные'!B29","v":"2021-06-09"},{"$f":"'Исходные данные'!C29","v":18932506.940000001},272501505.44000006,"2021-07-09",{"$f":"'Исходные данные'!K29","v":"2021-09-09"},{"$f":"сего_дня-B29","v":97},{"$f":"'Исходные данные'!L29","v":0},200568778.73000002,{"$f":"IFERROR(IF(AND($G29>=--LEFT(J$5,3),$G29<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G29>=--LEFT(K$5,3),$G29<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G29>=--LEFT(L$5,3),$G29<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G29>=--LEFT(M$5,3),$G29<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G29>=--LEFT(N$5,3),$G29<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G29>=--LEFT(O$5,3),$G29<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":71932726.710000038},{"$f":"IF(D29=\"\",\"\",D29-I29)","v":71932726.710000038}]
[null,{"$f":"'Исходные данные'!B30","v":"2021-06-11"},{"$f":"'Исходные данные'!C30","v":0},272501505.44000006,"2021-07-11",{"$f":"'Исходные данные'!K30","v":"2021-09-09"},{"$f":"сего_дня-B30","v":95},{"$f":"'Исходные данные'!L30","v":10000000},210568778.73000002,{"$f":"IFERROR(IF(AND($G30>=--LEFT(J$5,3),$G30<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G30>=--LEFT(K$5,3),$G30<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G30>=--LEFT(L$5,3),$G30<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G30>=--LEFT(M$5,3),$G30<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G30>=--LEFT(N$5,3),$G30<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G30>=--LEFT(O$5,3),$G30<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":61932726.710000038},{"$f":"IF(D30=\"\",\"\",D30-I30)","v":61932726.710000038}]
[null,{"$f":"'Исходные данные'!B31","v":"2021-06-18"},{"$f":"'Исходные данные'!C31","v":0},272501505.44000006,"2021-07-18",{"$f":"'Исходные данные'!K31","v":"2021-09-09"},{"$f":"сего_дня-B31","v":88},{"$f":"'Исходные данные'!L31","v":10000000},220568778.73000002,{"$f":"IFERROR(IF(AND($G31>=--LEFT(J$5,3),$G31<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G31>=--LEFT(K$5,3),$G31<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G31>=--LEFT(L$5,3),$G31<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G31>=--LEFT(M$5,3),$G31<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G31>=--LEFT(N$5,3),$G31<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":51932726.710000038},{"$f":"IFERROR(IF(AND($G31>=--LEFT(O$5,3),$G31<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D31=\"\",\"\",D31-I31)","v":51932726.710000038}]
[null,{"$f":"'Исходные данные'!B32","v":"2021-06-22"},{"$f":"'Исходные данные'!C32","v":0},272501505.44000006,"2021-07-22",{"$f":"'Исходные данные'!K32","v":"2021-09-09"},{"$f":"сего_дня-B32","v":84},{"$f":"'Исходные данные'!L32","v":40000000},260568778.73000002,{"$f":"IFERROR(IF(AND($G32>=--LEFT(J$5,3),$G32<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G32>=--LEFT(K$5,3),$G32<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G32>=--LEFT(L$5,3),$G32<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G32>=--LEFT(M$5,3),$G32<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G32>=--LEFT(N$5,3),$G32<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":11932726.710000038},{"$f":"IFERROR(IF(AND($G32>=--LEFT(O$5,3),$G32<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D32=\"\",\"\",D32-I32)","v":11932726.710000038}]
[null,{"$f":"'Исходные данные'!B33","v":"2021-06-28"},{"$f":"'Исходные данные'!C33","v":13806701.210000001},286308206.65000004,"2021-07-28",{"$f":"'Исходные данные'!K33","v":"2021-09-09"},{"$f":"сего_дня-B33","v":78},{"$f":"'Исходные данные'!L33","v":0},260568778.73000002,{"$f":"IFERROR(IF(AND($G33>=--LEFT(J$5,3),$G33<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G33>=--LEFT(K$5,3),$G33<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G33>=--LEFT(L$5,3),$G33<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G33>=--LEFT(M$5,3),$G33<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G33>=--LEFT(N$5,3),$G33<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":25739427.920000017},{"$f":"IFERROR(IF(AND($G33>=--LEFT(O$5,3),$G33<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D33=\"\",\"\",D33-I33)","v":25739427.920000017}]
[null,{"$f":"'Исходные данные'!B34","v":"2021-06-29"},{"$f":"'Исходные данные'!C34","v":0},286308206.65000004,"2021-07-29",{"$f":"'Исходные данные'!K34","v":"2021-09-09"},{"$f":"сего_дня-B34","v":77},{"$f":"'Исходные данные'!L34","v":8000000},268568778.73000002,{"$f":"IFERROR(IF(AND($G34>=--LEFT(J$5,3),$G34<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G34>=--LEFT(K$5,3),$G34<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G34>=--LEFT(L$5,3),$G34<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G34>=--LEFT(M$5,3),$G34<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G34>=--LEFT(N$5,3),$G34<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":17739427.920000017},{"$f":"IFERROR(IF(AND($G34>=--LEFT(O$5,3),$G34<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D34=\"\",\"\",D34-I34)","v":17739427.920000017}]
[null,{"$f":"'Исходные данные'!B35","v":"2021-07-01"},{"$f":"'Исходные данные'!C35","v":28592703.550000001},314900910.20000005,"2021-07-31",{"$f":"'Исходные данные'!K35","v":"2021-09-09"},{"$f":"сего_дня-B35","v":75},{"$f":"'Исходные данные'!L35","v":0},268568778.73000002,{"$f":"IFERROR(IF(AND($G35>=--LEFT(J$5,3),$G35<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G35>=--LEFT(K$5,3),$G35<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G35>=--LEFT(L$5,3),$G35<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G35>=--LEFT(M$5,3),$G35<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G35>=--LEFT(N$5,3),$G35<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":46332131.470000029},{"$f":"IFERROR(IF(AND($G35>=--LEFT(O$5,3),$G35<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D35=\"\",\"\",D35-I35)","v":46332131.470000029}]
[null,{"$f":"'Исходные данные'!B36","v":"2021-07-02"},{"$f":"'Исходные данные'!C36","v":0},314900910.20000005,"2021-08-01",{"$f":"'Исходные данные'!K36","v":"2021-09-09"},{"$f":"сего_дня-B36","v":74},{"$f":"'Исходные данные'!L36","v":1000000},269568778.73000002,{"$f":"IFERROR(IF(AND($G36>=--LEFT(J$5,3),$G36<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G36>=--LEFT(K$5,3),$G36<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G36>=--LEFT(L$5,3),$G36<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G36>=--LEFT(M$5,3),$G36<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G36>=--LEFT(N$5,3),$G36<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":45332131.470000029},{"$f":"IFERROR(IF(AND($G36>=--LEFT(O$5,3),$G36<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D36=\"\",\"\",D36-I36)","v":45332131.470000029}]
[null,{"$f":"'Исходные данные'!B37","v":"2021-07-09"},{"$f":"'Исходные данные'!C37","v":0},314900910.20000005,"2021-08-08",{"$f":"'Исходные данные'!K37","v":"2021-09-09"},{"$f":"сего_дня-B37","v":67},{"$f":"'Исходные данные'!L37","v":3000000},272568778.73000002,{"$f":"IFERROR(IF(AND($G37>=--LEFT(J$5,3),$G37<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G37>=--LEFT(K$5,3),$G37<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G37>=--LEFT(L$5,3),$G37<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G37>=--LEFT(M$5,3),$G37<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G37>=--LEFT(N$5,3),$G37<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":42332131.470000029},{"$f":"IFERROR(IF(AND($G37>=--LEFT(O$5,3),$G37<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D37=\"\",\"\",D37-I37)","v":42332131.470000029}]
[null,{"$f":"'Исходные данные'!B38","v":"2021-07-13"},{"$f":"'Исходные данные'!C38","v":0},314900910.20000005,"2021-08-12",{"$f":"'Исходные данные'!K38","v":"2021-09-09"},{"$f":"сего_дня-B38","v":63},{"$f":"'Исходные данные'!L38","v":5000000},277568778.73000002,{"$f":"IFERROR(IF(AND($G38>=--LEFT(J$5,3),$G38<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G38>=--LEFT(K$5,3),$G38<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G38>=--LEFT(L$5,3),$G38<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G38>=--LEFT(M$5,3),$G38<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G38>=--LEFT(N$5,3),$G38<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":37332131.470000029},{"$f":"IFERROR(IF(AND($G38>=--LEFT(O$5,3),$G38<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D38=\"\",\"\",D38-I38)","v":37332131.470000029}]
[null,{"$f":"'Исходные данные'!B39","v":"2021-07-15"},{"$f":"'Исходные данные'!C39","v":24757299.5},339658209.70000005,"2021-08-14",{"$f":"'Исходные данные'!K39","v":"2021-09-09"},{"$f":"сего_дня-B39","v":61},{"$f":"'Исходные данные'!L39","v":0},277568778.73000002,{"$f":"IFERROR(IF(AND($G39>=--LEFT(J$5,3),$G39<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G39>=--LEFT(K$5,3),$G39<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G39>=--LEFT(L$5,3),$G39<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G39>=--LEFT(M$5,3),$G39<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G39>=--LEFT(N$5,3),$G39<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":62089430.970000029},{"$f":"IFERROR(IF(AND($G39>=--LEFT(O$5,3),$G39<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D39=\"\",\"\",D39-I39)","v":62089430.970000029}]
[null,{"$f":"'Исходные данные'!B40","v":"2021-07-27"},{"$f":"'Исходные данные'!C40","v":28858860.239999998},368517069.94000006,"2021-08-26",{"$f":"'Исходные данные'!K40","v":"2021-09-09"},{"$f":"сего_дня-B40","v":49},{"$f":"'Исходные данные'!L40","v":0},277568778.73000002,{"$f":"IFERROR(IF(AND($G40>=--LEFT(J$5,3),$G40<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G40>=--LEFT(K$5,3),$G40<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G40>=--LEFT(L$5,3),$G40<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G40>=--LEFT(M$5,3),$G40<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":90948291.210000038},{"$f":"IFERROR(IF(AND($G40>=--LEFT(N$5,3),$G40<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G40>=--LEFT(O$5,3),$G40<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D40=\"\",\"\",D40-I40)","v":90948291.210000038}]
[null,{"$f":"'Исходные данные'!B41","v":"2021-07-30"},{"$f":"'Исходные данные'!C41","v":0},368517069.94000006,"2021-08-29",{"$f":"'Исходные данные'!K41","v":"2021-09-09"},{"$f":"сего_дня-B41","v":46},{"$f":"'Исходные данные'!L41","v":8739427.9199999999},286308206.65000004,{"$f":"IFERROR(IF(AND($G41>=--LEFT(J$5,3),$G41<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G41>=--LEFT(K$5,3),$G41<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G41>=--LEFT(L$5,3),$G41<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G41>=--LEFT(M$5,3),$G41<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":82208863.290000021},{"$f":"IFERROR(IF(AND($G41>=--LEFT(N$5,3),$G41<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G41>=--LEFT(O$5,3),$G41<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D41=\"\",\"\",D41-I41)","v":82208863.290000021}]
[null,{"$f":"'Исходные данные'!B42","v":"2021-08-03"},{"$f":"'Исходные данные'!C42","v":24581658.960000001},393098728.90000004,"2021-09-02",{"$f":"'Исходные данные'!K42","v":"2021-09-09"},{"$f":"сего_дня-B42","v":42},{"$f":"'Исходные данные'!L42","v":0},286308206.65000004,{"$f":"IFERROR(IF(AND($G42>=--LEFT(J$5,3),$G42<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G42>=--LEFT(K$5,3),$G42<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G42>=--LEFT(L$5,3),$G42<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G42>=--LEFT(M$5,3),$G42<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":106790522.25},{"$f":"IFERROR(IF(AND($G42>=--LEFT(N$5,3),$G42<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G42>=--LEFT(O$5,3),$G42<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D42=\"\",\"\",D42-I42)","v":106790522.25}]
[null,{"$f":"'Исходные данные'!B43","v":"2021-08-10"},{"$f":"'Исходные данные'!C43","v":0},393098728.90000004,"2021-09-09",{"$f":"'Исходные данные'!K43","v":"2021-09-09"},{"$f":"сего_дня-B43","v":35},{"$f":"'Исходные данные'!L43","v":20000000},306308206.65000004,{"$f":"IFERROR(IF(AND($G43>=--LEFT(J$5,3),$G43<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G43>=--LEFT(K$5,3),$G43<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G43>=--LEFT(L$5,3),$G43<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G43>=--LEFT(M$5,3),$G43<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":86790522.25},{"$f":"IFERROR(IF(AND($G43>=--LEFT(N$5,3),$G43<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G43>=--LEFT(O$5,3),$G43<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D43=\"\",\"\",D43-I43)","v":86790522.25}]
[null,{"$f":"'Исходные данные'!B44","v":"2021-08-20"},{"$f":"'Исходные данные'!C44","v":0},393098728.90000004,"2021-09-19",{"$f":"'Исходные данные'!K44","v":"2021-09-09"},{"$f":"сего_дня-B44","v":25},{"$f":"'Исходные данные'!L44","v":20000000},326308206.65000004,{"$f":"IFERROR(IF(AND($G44>=--LEFT(J$5,3),$G44<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G44>=--LEFT(K$5,3),$G44<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G44>=--LEFT(L$5,3),$G44<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":66790522.25},{"$f":"IFERROR(IF(AND($G44>=--LEFT(M$5,3),$G44<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G44>=--LEFT(N$5,3),$G44<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G44>=--LEFT(O$5,3),$G44<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D44=\"\",\"\",D44-I44)","v":66790522.25}]
[null,{"$f":"'Исходные данные'!B45","v":"2021-08-26"},{"$f":"'Исходные данные'!C45","v":35550253.539999999},428648982.44000006,"2021-09-25",{"$f":"'Исходные данные'!K45","v":"2021-09-09"},{"$f":"сего_дня-B45","v":19},{"$f":"'Исходные данные'!L45","v":0},326308206.65000004,{"$f":"IFERROR(IF(AND($G45>=--LEFT(J$5,3),$G45<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G45>=--LEFT(K$5,3),$G45<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G45>=--LEFT(L$5,3),$G45<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":102340775.79000002},{"$f":"IFERROR(IF(AND($G45>=--LEFT(M$5,3),$G45<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G45>=--LEFT(N$5,3),$G45<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G45>=--LEFT(O$5,3),$G45<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D45=\"\",\"\",D45-I45)","v":102340775.79000002}]
[null,{"$f":"'Исходные данные'!B46","v":"2021-08-31"},{"$f":"'Исходные данные'!C46","v":6952888.0099999998},435601870.45000005,"2021-09-30",{"$f":"'Исходные данные'!K46","v":"2021-09-09"},{"$f":"сего_дня-B46","v":14},{"$f":"'Исходные данные'!L46","v":10000000},336308206.65000004,{"$f":"IFERROR(IF(AND($G46>=--LEFT(J$5,3),$G46<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G46>=--LEFT(K$5,3),$G46<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":99293663.800000012},{"$f":"IFERROR(IF(AND($G46>=--LEFT(L$5,3),$G46<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G46>=--LEFT(M$5,3),$G46<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G46>=--LEFT(N$5,3),$G46<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G46>=--LEFT(O$5,3),$G46<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D46=\"\",\"\",D46-I46)","v":99293663.800000012}]
[null,{"$f":"'Исходные данные'!B47","v":"2021-09-03"},{"$f":"'Исходные данные'!C47","v":6911768.3799999999},442513638.83000004,"2021-10-03",{"$f":"'Исходные данные'!K47","v":"2021-09-09"},{"$f":"сего_дня-B47","v":11},{"$f":"'Исходные данные'!L47","v":0},336308206.65000004,{"$f":"IFERROR(IF(AND($G47>=--LEFT(J$5,3),$G47<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G47>=--LEFT(K$5,3),$G47<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":106205432.18000001},{"$f":"IFERROR(IF(AND($G47>=--LEFT(L$5,3),$G47<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G47>=--LEFT(M$5,3),$G47<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G47>=--LEFT(N$5,3),$G47<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G47>=--LEFT(O$5,3),$G47<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D47=\"\",\"\",D47-I47)","v":106205432.18000001}]
[null,{"$f":"'Исходные данные'!B48","v":"2021-09-07"},{"$f":"'Исходные данные'!C48","v":0},442513638.83000004,"2021-10-07",{"$f":"'Исходные данные'!K48","v":"2021-09-09"},{"$f":"сего_дня-B48","v":7},{"$f":"'Исходные данные'!L48","v":5000000},341308206.65000004,{"$f":"IFERROR(IF(AND($G48>=--LEFT(J$5,3),$G48<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":101205432.18000001},{"$f":"IFERROR(IF(AND($G48>=--LEFT(K$5,3),$G48<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G48>=--LEFT(L$5,3),$G48<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G48>=--LEFT(M$5,3),$G48<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G48>=--LEFT(N$5,3),$G48<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G48>=--LEFT(O$5,3),$G48<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D48=\"\",\"\",D48-I48)","v":101205432.18000001}]
[null,{"$f":"'Исходные данные'!B49","v":"2021-09-10"},{"$f":"'Исходные данные'!C49","v":0},442513638.83000004,"2021-10-10",{"$f":"'Исходные данные'!K49","v":"2021-09-09"},{"$f":"сего_дня-B49","v":4},{"$f":"'Исходные данные'!L49","v":25000000},366308206.65000004,{"$f":"IFERROR(IF(AND($G49>=--LEFT(J$5,3),$G49<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":76205432.180000007},{"$f":"IFERROR(IF(AND($G49>=--LEFT(K$5,3),$G49<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G49>=--LEFT(L$5,3),$G49<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G49>=--LEFT(M$5,3),$G49<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G49>=--LEFT(N$5,3),$G49<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G49>=--LEFT(O$5,3),$G49<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D49=\"\",\"\",D49-I49)","v":76205432.180000007}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND($G50>=--LEFT(J$5,3),$G50<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":""},{"$f":"IFERROR(IF(AND($G50>=--LEFT(K$5,3),$G50<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G50>=--LEFT(L$5,3),$G50<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G50>=--LEFT(M$5,3),$G50<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G50>=--LEFT(N$5,3),$G50<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G50>=--LEFT(O$5,3),$G50<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D50=\"\",\"\",D50-I50)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(AND($G51>=--LEFT(J$5,3),$G51<=--RIGHT(J$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":""},{"$f":"IFERROR(IF(AND($G51>=--LEFT(K$5,3),$G51<=--RIGHT(K$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G51>=--LEFT(L$5,3),$G51<=--RIGHT(L$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G51>=--LEFT(M$5,3),$G51<=--RIGHT(M$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G51>=--LEFT(N$5,3),$G51<=--RIGHT(N$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IFERROR(IF(AND($G51>=--LEFT(O$5,3),$G51<=--RIGHT(O$5,3)),INDEX($A$6:$P$53,ROW()-5,COLUMN(задолженность)),\"-\"),\"\")","v":"-"},{"$f":"IF(D51=\"\",\"\",D51-I51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D52=\"\",\"\",D52-I52)","v":""}]
[null,null,{"$f":"SUM(C6:C51)","v":442513638.83000004},null,null,null,null,{"$f":"SUM(H6:H51)","v":366308206.65000004},null,{"$f":"SUM(J6:J51)","v":177410864.36000001},{"$f":"SUM(K6:K51)","v":205499095.98000002},169131298.04000002,366738199.00000006,340762266.11000025,2213082866.8700004,{"$f":"SUM(P6:P51)","v":3472624590.3600011}]

{"sheet":"Контроль","index":2,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,0,51,8]]}
[null,"Отгрузка","Дата оплаты","Оплата","Задолженность нарастающим итогом, итого, руб."]
[]
[null,442513638.82999998,null,366308206.64999998,76205432.180000007]
["2021-02-04",25938822.239999998,"2021-09-09",null,25938822.239999998]
["2021-02-08",29707567.850000001,"2021-09-09",null,55646390.090000004,"откуда это число?"]
["2021-02-15",29615092.079999998,"2021-09-09",null,85261482.170000002]
["2021-02-26",25354420.699999999,"2021-09-09",null,110615902.87]
["2021-03-03",29601871.82,"2021-09-09",1000000,139217774.69]
["2021-03-12",null,"2021-09-09",15000000,124217774.69]
["2021-03-16",null,"2021-09-09",15000000,109217774.69]
["2021-03-19",29123331.550000001,"2021-09-09",null,138341106.24000001]
["2021-03-22",29227672.489999998,"2021-09-09",null,167568778.72999999]
["2021-03-23",null,"2021-09-09",45000000,122568778.73]
["2021-03-30",null,"2021-09-09",10000000,112568778.73]
["2021-03-31",null,"2021-09-09",24615902.870000001,87952875.859999999]
["2021-04-01",18203997.600000001,"2021-09-09",null,106156873.45999999]
["2021-04-06",null,"2021-09-09",10000000,96156873.459999993]
["2021-04-09",null,"2021-09-09",10000000,86156873.459999993]
["2021-04-13",null,"2021-09-09",3000000,83156873.459999993]
["2021-04-16",null,"2021-09-09",5000000,78156873.459999993]
["2021-04-20",null,"2021-09-09",4000000,74156873.459999993]
["2021-04-22",7213916.2999999998,"2021-09-09",null,81370789.760000005]
["2021-04-23",null,"2021-09-09",20000000,61370789.759999998]
["2021-04-29",null,"2021-09-09",35952875.859999999,25417913.899999999]
["2021-05-11",29582305.870000001,"2021-09-09",null,55000219.770000003]
["2021-06-08",null,"2021-09-09",2000000,53000219.770000003]
["2021-06-09",18932506.940000001,"2021-09-09",null,71932726.709999993]
["2021-06-11",null,"2021-09-09",10000000,61932726.710000001]
["2021-06-18",null,"2021-09-09",10000000,51932726.710000001]
["2021-06-22",null,"2021-09-09",40000000,11932726.710000001]
["2021-06-28",13806701.210000001,"2021-09-09",null,25739427.920000002]
["2021-06-29",null,"2021-09-09",8000000,17739427.920000002]
["2021-07-01",28592703.550000001,"2021-09-09",null,46332131.469999999]
["2021-07-02",null,"2021-09-09",1000000,45332131.469999999]
["2021-07-09",null,"2021-09-09",3000000,42332131.469999999]
["2021-07-13",null,"2021-09-09",5000000,37332131.469999999]
["2021-07-15",24757299.5,"2021-09-09",null,62089430.969999999]
["2021-07-27",28858860.239999998,"2021-09-09",null,90948291.209999993]
["2021-07-30",null,"2021-09-09",8739427.9199999999,82208863.290000007]
["2021-08-03",24581658.960000001,"2021-09-09",null,106790522.25]
["2021-08-10",null,"2021-09-09",20000000,86790522.25]
["2021-08-20",null,"2021-09-09",20000000,66790522.25]
["2021-08-26",35550253.539999999,"2021-09-09",null,102340775.79000001]
["2021-08-31",6952888.0099999998,"2021-09-09",10000000,99293663.799999997]
["2021-09-03",6911768.3799999999,"2021-09-09",null,106205432.18000001]
["2021-09-07",null,"2021-09-09",5000000,101205432.18000001]
["2021-09-10",null,"2021-09-09",25000000,76205432.180000007]
["Итого",442513638.83000004,null,366308206.65000004,76205432.180000007]
[]
[]
[]
["отчет в 1с показывает такое распределение по срокам "]
["Покупатель","Общая задолженность",null,"Общая задолженность по срокам долга"]
[null,null,null,"До 7 дней","От 8 до 15 дней","От 16 до 30 дней","От 31 до 60 дней","От 61 до 90 дней","Свыше 90 дней"]
[null,"76 205 432",null,null,"13 864 656","35 550 254","26 790 522"]