{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Исходные данные","Дебиторка","Контроль","ДАТА отгрузка_оплата"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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"},null,{"$f":"сего_дня-B6","v":"1900-08-09"},{"$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":"-"},"-","-","-","-",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},{"$f":"B7+период_отсрочки","v":"2021-03-10"},null,{"$f":"сего_дня-B7","v":"1900-08-05"},{"$f":"'Исходные данные'!L7","v":0},{"$f":"I6+H7","v":0},"-","-","-","-","-",55646390.090000004,55646390.090000004]
[null,{"$f":"'Исходные данные'!B8","v":"2021-02-15"},{"$f":"'Исходные данные'!C8","v":29615092.079999998},{"$f":"D7+C8","v":85261482.170000002},{"$f":"B8+период_отсрочки","v":"2021-03-17"},null,{"$f":"сего_дня-B8","v":"1900-07-29"},{"$f":"'Исходные данные'!L8","v":0},{"$f":"I7+H8","v":0},"-","-","-","-","-",85261482.170000002,85261482.170000002]
[null,{"$f":"'Исходные данные'!B9","v":"2021-02-26"},{"$f":"'Исходные данные'!C9","v":25354420.699999999},{"$f":"D8+C9","v":110615902.87},{"$f":"B9+период_отсрочки","v":"2021-03-28"},null,{"$f":"сего_дня-B9","v":"1900-07-18"},{"$f":"'Исходные данные'!L9","v":0},0,"-","-","-","-","-",110615902.87,110615902.87]
[null,{"$f":"'Исходные данные'!B10","v":"2021-03-03"},{"$f":"'Исходные данные'!C10","v":29601871.82},{"$f":"D9+C10","v":140217774.69},{"$f":"B10+период_отсрочки","v":"2021-04-02"},"2021-03-03",{"$f":"сего_дня-B10","v":"1900-07-13"},{"$f":"'Исходные данные'!L10","v":1000000},{"$f":"I9+H10","v":1000000},"-","-","-","-","-",139217774.69,139217774.69]
[null,null,{"$f":"'Исходные данные'!C11","v":0},140217774.69,{"$f":"B11+период_отсрочки","v":"1900-01-30"},"2021-03-12",{"$f":"сего_дня-B11","v":"2021-09-14"},{"$f":"'Исходные данные'!L11","v":15000000},16000000,"-","-","-","-","-","-",124217774.69]
[null,null,{"$f":"'Исходные данные'!C12","v":0},140217774.69,{"$f":"B12+период_отсрочки","v":"1900-01-30"},"2021-03-16",{"$f":"сего_дня-B12","v":"2021-09-14"},{"$f":"'Исходные данные'!L12","v":15000000},31000000,"-","-","-","-","-","-",109217774.69]
[null,{"$f":"'Исходные данные'!B13","v":"2021-03-19"},{"$f":"'Исходные данные'!C13","v":29123331.550000001},169341106.24000001,"2021-04-18",null,{"$f":"сего_дня-B13","v":"1900-06-27"},{"$f":"'Исходные данные'!L13","v":0},31000000,"-","-","-","-","-",138341106.24000001,138341106.24000001]
[null,{"$f":"'Исходные данные'!B14","v":"2021-03-22"},{"$f":"'Исходные данные'!C14","v":29227672.489999998},198568778.73000002,"2021-04-21",null,{"$f":"сего_дня-B14","v":"1900-06-24"},{"$f":"'Исходные данные'!L14","v":0},31000000,"-","-","-","-","-",167568778.73000002,167568778.73000002]
[null,null,{"$f":"'Исходные данные'!C15","v":0},198568778.73000002,"1900-01-30","2021-03-23",{"$f":"сего_дня-B15","v":"2021-09-14"},{"$f":"'Исходные данные'!L15","v":45000000},76000000,"-","-","-","-","-","-",122568778.73000002]
[null,null,{"$f":"'Исходные данные'!C16","v":0},198568778.73000002,"1900-01-30","2021-03-30",{"$f":"сего_дня-B16","v":"2021-09-14"},{"$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":"-"},"-","-","-","-","-",112568778.73000002]
[null,null,{"$f":"'Исходные данные'!C17","v":0},198568778.73000002,"1900-01-30","2021-03-31",{"$f":"сего_дня-B17","v":"2021-09-14"},{"$f":"'Исходные данные'!L17","v":24615902.870000001},110615902.87,"-","-","-","-","-","-",87952875.860000014]
[null,{"$f":"'Исходные данные'!B18","v":"2021-04-01"},{"$f":"'Исходные данные'!C18","v":18203997.600000001},216772776.33000001,"2021-05-01",null,{"$f":"сего_дня-B18","v":"1900-06-14"},{"$f":"'Исходные данные'!L18","v":0},110615902.87,"-","-","-","-","-",106156873.46000001,106156873.46000001]
[null,null,{"$f":"'Исходные данные'!C19","v":0},216772776.33000001,"1900-01-30","2021-04-06",{"$f":"сего_дня-B19","v":"2021-09-14"},{"$f":"'Исходные данные'!L19","v":10000000},120615902.87,"-","-","-","-","-","-",96156873.460000008]
[null,null,{"$f":"'Исходные данные'!C20","v":0},216772776.33000001,"1900-01-30","2021-04-09",{"$f":"сего_дня-B20","v":"2021-09-14"},{"$f":"'Исходные данные'!L20","v":10000000},130615902.87,"-","-","-","-","-","-",86156873.460000008]
[null,null,{"$f":"'Исходные данные'!C21","v":0},216772776.33000001,"1900-01-30","2021-04-13",{"$f":"сего_дня-B21","v":"2021-09-14"},{"$f":"'Исходные данные'!L21","v":3000000},133615902.87,"-","-","-","-","-","-",83156873.460000008]
[null,null,{"$f":"'Исходные данные'!C22","v":0},216772776.33000001,"1900-01-30","2021-04-16",{"$f":"сего_дня-B22","v":"2021-09-14"},{"$f":"'Исходные данные'!L22","v":5000000},138615902.87,"-","-","-","-","-","-",78156873.460000008]
[null,null,{"$f":"'Исходные данные'!C23","v":0},216772776.33000001,"1900-01-30","2021-04-20",{"$f":"сего_дня-B23","v":"2021-09-14"},{"$f":"'Исходные данные'!L23","v":4000000},142615902.87,"-","-","-","-","-","-",74156873.460000008]
[null,{"$f":"'Исходные данные'!B24","v":"2021-04-22"},{"$f":"'Исходные данные'!C24","v":7213916.2999999998},223986692.63000003,null,null,{"$f":"сего_дня-B24","v":"1900-05-24"},{"$f":"'Исходные данные'!L24","v":0},142615902.87,"-","-","-","-","-",81370789.76000002,81370789.76000002]
[null,null,{"$f":"'Исходные данные'!C25","v":0},223986692.63000003,"1900-01-30","2021-04-23",{"$f":"сего_дня-B25","v":"2021-09-14"},{"$f":"'Исходные данные'!L25","v":20000000},162615902.87,"-","-","-","-","-","-",61370789.76000002]
[null,null,{"$f":"'Исходные данные'!C26","v":0},223986692.63000003,"1900-01-30","2021-04-29",{"$f":"сего_дня-B26","v":"2021-09-14"},{"$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":"-"},"-","-","-","-","-",25417913.900000006]
[null,{"$f":"'Исходные данные'!B27","v":"2021-05-11"},{"$f":"'Исходные данные'!C27","v":29582305.870000001},253568998.50000003,"2021-06-10",null,{"$f":"сего_дня-B27","v":"1900-05-05"},{"$f":"'Исходные данные'!L27","v":0},198568778.73000002,"-","-","-","-","-",55000219.770000011,55000219.770000011]
[null,null,{"$f":"'Исходные данные'!C28","v":0},253568998.50000003,"1900-01-30","2021-06-08",{"$f":"сего_дня-B28","v":"2021-09-14"},{"$f":"'Исходные данные'!L28","v":2000000},200568778.73000002,"-","-","-","-","-","-",53000219.770000011]
[null,{"$f":"'Исходные данные'!B29","v":"2021-06-09"},{"$f":"'Исходные данные'!C29","v":18932506.940000001},272501505.44000006,"2021-07-09",null,{"$f":"сего_дня-B29","v":"1900-04-06"},{"$f":"'Исходные данные'!L29","v":0},200568778.73000002,"-","-","-","-","-",71932726.710000038,71932726.710000038]
[null,null,{"$f":"'Исходные данные'!C30","v":0},272501505.44000006,"1900-01-30","2021-06-11",{"$f":"сего_дня-B30","v":"2021-09-14"},{"$f":"'Исходные данные'!L30","v":10000000},210568778.73000002,"-","-","-","-","-","-",61932726.710000038]
[null,null,{"$f":"'Исходные данные'!C31","v":0},272501505.44000006,"1900-01-30","2021-06-18",{"$f":"сего_дня-B31","v":"2021-09-14"},{"$f":"'Исходные данные'!L31","v":10000000},220568778.73000002,"-","-","-","-","-","-",51932726.710000038]
[null,null,{"$f":"'Исходные данные'!C32","v":0},272501505.44000006,"1900-01-30","2021-06-22",{"$f":"сего_дня-B32","v":"2021-09-14"},{"$f":"'Исходные данные'!L32","v":40000000},260568778.73000002,"-","-","-","-","-","-",11932726.710000038]
[null,{"$f":"'Исходные данные'!B33","v":"2021-06-28"},{"$f":"'Исходные данные'!C33","v":13806701.210000001},286308206.65000004,"2021-07-28",null,{"$f":"сего_дня-B33","v":"1900-03-18"},{"$f":"'Исходные данные'!L33","v":0},260568778.73000002,"-","-","-","-",25739427.920000017,"-",25739427.920000017]
[null,null,{"$f":"'Исходные данные'!C34","v":0},286308206.65000004,"1900-01-30","2021-06-29",{"$f":"сего_дня-B34","v":"2021-09-14"},{"$f":"'Исходные данные'!L34","v":8000000},268568778.73000002,"-","-","-","-","-","-",17739427.920000017]
[null,{"$f":"'Исходные данные'!B35","v":"2021-07-01"},{"$f":"'Исходные данные'!C35","v":28592703.550000001},314900910.20000005,"2021-07-31",null,{"$f":"сего_дня-B35","v":"1900-03-15"},{"$f":"'Исходные данные'!L35","v":0},268568778.73000002,"-","-","-","-",46332131.470000029,"-",46332131.470000029]
[null,null,{"$f":"'Исходные данные'!C36","v":0},314900910.20000005,"1900-01-30","2021-07-02",{"$f":"сего_дня-B36","v":"2021-09-14"},{"$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":"-"},"-","-","-","-","-",45332131.470000029]
[null,null,{"$f":"'Исходные данные'!C37","v":0},314900910.20000005,"1900-01-30","2021-07-09",{"$f":"сего_дня-B37","v":"2021-09-14"},{"$f":"'Исходные данные'!L37","v":3000000},272568778.73000002,"-","-","-","-","-","-",42332131.470000029]
[null,null,{"$f":"'Исходные данные'!C38","v":0},314900910.20000005,"1900-01-30","2021-07-13",{"$f":"сего_дня-B38","v":"2021-09-14"},{"$f":"'Исходные данные'!L38","v":5000000},277568778.73000002,"-","-","-","-","-","-",37332131.470000029]
[null,{"$f":"'Исходные данные'!B39","v":"2021-07-15"},{"$f":"'Исходные данные'!C39","v":24757299.5},339658209.70000005,"2021-08-14",null,{"$f":"сего_дня-B39","v":"1900-03-01"},{"$f":"'Исходные данные'!L39","v":0},277568778.73000002,"-","-","-","-",62089430.970000029,"-",62089430.970000029]
[null,{"$f":"'Исходные данные'!B40","v":"2021-07-27"},{"$f":"'Исходные данные'!C40","v":28858860.239999998},368517069.94000006,"2021-08-26",null,{"$f":"сего_дня-B40","v":"1900-02-18"},{"$f":"'Исходные данные'!L40","v":0},277568778.73000002,"-","-","-",90948291.210000038,"-","-",90948291.210000038]
[null,null,{"$f":"'Исходные данные'!C41","v":0},368517069.94000006,"1900-01-30","2021-07-30",{"$f":"сего_дня-B41","v":"2021-09-14"},{"$f":"'Исходные данные'!L41","v":8739427.9199999999},286308206.65000004,"-","-","-","-","-","-",82208863.290000021]
[null,{"$f":"'Исходные данные'!B42","v":"2021-08-03"},{"$f":"'Исходные данные'!C42","v":24581658.960000001},393098728.90000004,"2021-09-02",null,{"$f":"сего_дня-B42","v":"1900-02-11"},{"$f":"'Исходные данные'!L42","v":0},286308206.65000004,"-","-","-",106790522.25,"-","-",106790522.25]
[null,null,{"$f":"'Исходные данные'!C43","v":0},393098728.90000004,"1900-01-30","2021-08-10",{"$f":"сего_дня-B43","v":"2021-09-14"},{"$f":"'Исходные данные'!L43","v":20000000},306308206.65000004,"-","-","-","-","-","-",86790522.25]
[null,null,{"$f":"'Исходные данные'!C44","v":0},393098728.90000004,"1900-01-30","2021-08-20",{"$f":"сего_дня-B44","v":"2021-09-14"},{"$f":"'Исходные данные'!L44","v":20000000},326308206.65000004,"-","-","-","-","-","-",66790522.25]
[null,{"$f":"'Исходные данные'!B45","v":"2021-08-26"},{"$f":"'Исходные данные'!C45","v":35550253.539999999},428648982.44000006,"2021-09-25",null,{"$f":"сего_дня-B45","v":"1900-01-19"},{"$f":"'Исходные данные'!L45","v":0},326308206.65000004,"-","-",102340775.79000002,"-","-","-",102340775.79000002]
[null,{"$f":"'Исходные данные'!B46","v":"2021-08-31"},{"$f":"'Исходные данные'!C46","v":6952888.0099999998},435601870.45000005,"2021-09-30","2021-08-31",{"$f":"сего_дня-B46","v":"1900-01-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":"-"},99293663.800000012,"-","-","-","-",99293663.800000012]
[null,{"$f":"'Исходные данные'!B47","v":"2021-09-03"},{"$f":"'Исходные данные'!C47","v":6911768.3799999999},442513638.83000004,"2021-10-03",null,{"$f":"сего_дня-B47","v":"1900-01-11"},{"$f":"'Исходные данные'!L47","v":0},336308206.65000004,"-",106205432.18000001,"-","-","-","-",106205432.18000001]
[null,null,{"$f":"'Исходные данные'!C48","v":0},442513638.83000004,"1900-01-30","2021-09-07",{"$f":"сего_дня-B48","v":"2021-09-14"},{"$f":"'Исходные данные'!L48","v":5000000},341308206.65000004,"-","-","-","-","-","-",101205432.18000001]
[null,null,{"$f":"'Исходные данные'!C49","v":0},442513638.83000004,"1900-01-30","2021-09-10",{"$f":"сего_дня-B49","v":"2021-09-14"},{"$f":"'Исходные данные'!L49","v":25000000},366308206.65000004,"-","-","-","-","-","-",76205432.180000007]
[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,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":0},{"$f":"SUM(K6:K51)","v":205499095.98000002},102340775.79000002,197738813.46000004,134160990.36000007,1037050866.73,{"$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"]

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