{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Пост1","Пост2","Пост3","Пост4","Бюджет","Груз в пути"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["№","Поставщи","Наименование","Кол-во, т","Дата загрузки по инвойсу","Сумма","Валюта","Incoterm","Дата оплаты","Дата прихода "]
[1,"Пост1","Грейпфрутовый концентрат",24,"2014-03-27",1.1254,"USD","FCA","2014-05-26","2014-04-02"]
[2,"Пост1","Ананасовый концентрат",12,"2014-04-02",1.1254,"USD","FCA","2014-06-01","2014-04-08"]
[3,"Пост1","Грейпфрутовый концентрат",12,"2014-04-02",1.1254,"USD","FCA","2014-06-01","2014-04-08"]
[4,"Пост1","Грейпфрутовый сок с клеткой",12,"2014-04-09",1.1254,"USD","FCA","2014-06-08","2014-04-15"]
[5,"Пост1","Кр.апельсин напиток",12,"2014-04-09",1.1254,"USD","FCA","2014-06-08","2014-04-15"]
[6,"Пост1","Грейпфрутовый концентрат",24,"2014-04-23",1.1254,"USD","FCA","2014-06-22","2014-04-29"]
[7,"Пост1","Грейпфрутовый концентрат",18,"2014-05-15",1.1254,"USD","FCA","2014-07-14","2014-05-21"]
[8,"Пост1","Кр.апельсин напиток",6,"2014-05-15",1.1254,"USD","FCA","2014-07-14","2014-05-21"]
[9,"Пост1","Грейпфрутовый концентрат",18,"2014-05-22",1.1254,"USD","FCA","2014-07-21","2014-05-28"]
[10,"Пост1","Кр.апельсин напиток",6,"2014-05-22",1.1254,"USD","FCA","2014-07-21","2014-05-28"]
[11,"Пост1","Грейпфрутовый концентрат",24,"2014-05-27",1.1254,"USD","FCA","2014-07-26","2014-06-04"]
[12,"Пост1","Красный виноград Премиум",6,"2014-06-11",1.1254,"USD","FCA","2014-08-10","2014-06-17"]
[13,"Пост1","Грейпфрутовый концентрат",12,"2014-06-11",1.1254,"USD","FCA","2014-08-10","2014-06-17"]
[14,"Пост1","Кр.апельсин напиток",6,"2014-06-11",1.1254,"USD","FCA","2014-08-10","2014-06-17"]
[15,"Пост1","Апельсиновый сок Премиум",4.1399999999999997,"2014-06-17",1.1254,"USD","FCA","2014-08-16","2014-06-23"]
[16,"Пост1","Грейпфрутовый сок с клеткой",12,"2014-06-26",1.1254,"USD","FCA","2014-08-25","2014-07-02"]
[17,"Пост1","Грейпфрутовый концентрат",12,"2014-06-26",1.1254,"USD","FCA","2014-08-25","2014-07-02"]
[18,"Пост1","Грейпфрутовый концентрат",12,"2014-07-09",1.1254,"USD","FCA","2014-09-07","2014-07-15"]
[19,"Пост1","Кр.апельсин напиток",12,"2014-07-09",1.1254,"USD","FCA","2014-09-07","2014-07-15"]
[20,"Пост1","Грейпфрутовый концентрат",24,"2014-08-07",1.1254,"EURO","FCA","2014-10-06","2014-08-11"]
[21,"Пост1","Грейпфрутовый концентрат",18,"2014-08-21",1.1254,"EURO","FCA","2014-10-20","2014-08-26"]
[22,"Пост1","Кр.апельсин напиток",6,"2014-08-21",1.1254,"EURO","FCA","2014-10-20","2014-08-26"]
[23,"Пост1","Грейпфрутовый концентрат",18,"2014-09-04",1.1254,"EURO","FCA","2014-11-03","2014-09-10"]
[24,"Пост1","Кр.апельсин напиток",4.75,"2014-09-04",1.1254,"EURO","FCA","2014-11-03","2014-09-10"]
[25,"Пост1","Мультивитамин нектар эксклюзив",5.04,"2014-09-18",1.1254,"EURO","FCA","2014-11-17","2014-09-22"]
[26,"Пост1","Грейпфрутовый концентрат",18,"2014-09-18",1.1254,"EURO","FCA","2014-11-17","2014-09-24"]
[27,"Пост1","Кр.апельсин напиток",6,"2014-09-18",1.1254,"EURO","FCA","2014-11-17","2014-09-24"]
[28,"Пост1","Грейпфрутовый концентрат",18,"2014-09-25",1.1254,"EURO","FCA","2014-11-24","2014-10-01"]
[29,"Пост1","Кр.апельсин напиток",6,"2014-09-25",1.1254,"EURO","FCA","2014-11-24","2014-10-01"]
[30,"Пост1","Грейпфрутовый сок с клеткой",6,"2014-10-09",1.1254,"EURO","FCA","2014-12-08","2014-10-15"]
[31,"Пост1","Грейпфрутовый концентрат",12,"2014-10-09",1.1254,"EURO","FCA","2014-12-08","2014-10-15"]
[32,"Пост1","Кр.апельсин напиток",6,"2014-10-09",1.1254,"EURO","FCA","2014-12-08","2014-10-15"]
[33,"Пост1","Ананасовый сок Прем. нов.",4.32,"2014-10-21",1.1254,"EURO","FCA","2014-12-20","2014-10-27"]
[34,"Пост1","Грейпфрутовый концентрат",24,"2014-10-22",1.1254,"EURO","FCA","2014-12-21","2014-10-28"]
[35,"Пост1","Грейпфрутовый концентрат",18,"2014-11-05",1.1254,"EURO","FCA","2015-01-04","2014-11-11"]
[36,"Пост1","Кр.апельсин напиток",6,"2014-11-05",1.1254,"EURO","FCA","2015-01-04","2014-11-11"]

{"sheet":"Пост2","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["№","Поставщик","Наименование","Кол-во, т","Дата загрузки по инвойсу","Сумма","Валюта","Incoterm","Дата оплаты","Дата прихода "]
[1,"Пост2","Апельсин 66",24,"2014-04-15",0.89,"EURO","FOB","2014-05-30","2014-04-21"]
[2,"Пост2","Апельсин 66",24,"2014-04-22",0.89,"USD","FOB","2014-06-06","2014-04-28"]
[3,"Пост2","Апельсин 66",12,"2014-04-29",0.89,"USD","FOB","2014-06-13","2014-05-05"]
[4,"Пост2","Апельсин 66",24,"2014-05-06",0.89,"USD","FOB","2014-06-20","2014-05-12"]
[5,"Пост2","Апельсин 66",24,"2014-05-13",0.89,"USD","FOB","2014-06-27","2014-05-19"]
[6,"Пост2","Апельсин 53 ",12,"2014-05-20",0.89,"USD","FOB","2014-07-04","2014-05-26"]
[7,"Пост2","Апельсин 66",12,"2014-05-20",0.89,"EURO","FOB","2014-07-04","2014-05-26"]
[8,"Пост2","Апельсин 66",24,"2014-05-27",0.89,"EURO","FOB","2014-07-11","2014-06-02"]
[9,"Пост2","Апельсин 66",12,"2014-06-03",0.89,"EURO","FOB","2014-07-18","2014-06-09"]
[10,"Пост2","Апельсин 66",24,"2014-06-10",0.89,"EURO","FOB","2014-07-25","2014-06-16"]
[11,"Пост2","Апельсин 53 ",12,"2014-06-17",0.89,"EURO","FOB","2014-08-01","2014-06-23"]
[12,"Пост2","Апельсин 66",24,"2014-06-17",0.89,"EURO","FOB","2014-08-01","2014-06-23"]
[13,"Пост2","Апельсин 66",12,"2014-06-25",0.89,"EURO","FOB","2014-08-09","2014-07-01"]
[14,"Пост2","Апельсин 66",12,"2014-07-08",0.89,"USD","FOB","2014-08-22","2014-07-14"]
[15,"Пост2","Апельсин 66",24,"2014-07-15",0.89,"USD","FOB","2014-08-29","2014-07-21"]
[16,"Пост2","Апельсин 66",12,"2014-08-05",0.89,"USD","FOB","2014-09-19","2014-08-11"]
[17,"Пост2","Апельсин 53 ",12,"2014-08-20",0.89,"USD","FOB","2014-10-04","2014-08-26"]
[18,"Пост2","Апельсин 66",12,"2014-08-20",0.89,"USD","FOB","2014-10-04","2014-08-26"]
[19,"Пост2","Апельсин 66",24,"2014-08-26",0.89,"EURO","FOB","2014-10-10","2014-09-01"]
[20,"Пост2","Апельсин 66",24,"2014-09-02",0.89,"EURO","FOB","2014-10-17","2014-09-08"]
[21,"Пост2","Апельсин 59",24,"2014-09-17",0.89,"EURO","FOB","2014-11-01","2014-09-23"]
[22,"Пост2","Апельсин 59",24,"2014-09-18",0.89,"EURO","FOB","2014-11-02","2014-09-24"]
[23,"Пост2","Апельсин 66",24,"2014-09-16",0.89,"EURO","FOB","2014-10-31","2014-09-22"]
[24,"Пост2","Апельсин 59",24,"2014-09-23",0.89,"EURO","FOB","2014-11-07","2014-09-29"]
[25,"Пост2","Апельсин 59",12,"2014-09-23",0.89,"EURO","FOB","2014-11-07","2014-09-29"]
[26,"Пост2","Апельсин 66",12,"2014-09-23",0.89,"USD","FOB","2014-11-07","2014-09-29"]
[27,"Пост2","Апельсин 59",24,"2014-09-30",0.89,"USD","FOB","2014-11-14","2014-10-06"]
[28,"Пост2","Апельсин 59",24,"2014-09-30",0.89,"USD","FOB","2014-11-14","2014-10-06"]
[29,"Пост2","Апельсин 59",24,"2014-10-01",0.89,"USD","FOB","2014-11-15","2014-10-07"]
[30,"Пост2","Апельсин 59",12,"2014-09-30",0.89,"USD","FOB","2014-11-14","2014-10-06"]
[31,"Пост2","Апельсин 66",12,"2014-09-30",0.89,"EURO","FOB","2014-11-14","2014-10-06"]
[32,"Пост2","Апельсин 59",24,"2014-10-07",0.89,"EURO","FOB","2014-11-21","2014-10-13"]
[33,"Пост2","Апельсин 59",24,"2014-10-07",0.89,"EURO","FOB","2014-11-21","2014-10-13"]
[34,"Пост2","Апельсин 53 ",12,"2014-10-08",0.89,"EURO","FOB","2014-11-22","2014-10-14"]
[35,"Пост2","Апельсин 66",12,"2014-10-08",0.89,"EURO","FOB","2014-11-22","2014-10-14"]
[36,"Пост2","Апельсин 59",24,"2014-10-14",0.89,"EURO","FOB","2014-11-28","2014-10-20"]
[37,"Пост2","Апельсин 59",24,"2014-10-14",0.89,"EURO","FOB","2014-11-28","2014-10-20"]
[38,"Пост2","Апельсин 59",24,"2014-10-14",0.89,"USD","FOB","2014-11-28","2014-10-20"]
[39,"Пост2","Апельсин 59",24,"2014-10-15",0.89,"USD","FOB","2014-11-29","2014-10-21"]
[40,"Пост2","Апельсин 59",24,"2014-10-21",0.89,"USD","FOB","2014-12-05","2014-10-27"]
[41,"Пост2","Апельсин 66",24,"2014-10-14",0.89,"USD","FOB","2014-11-28","2014-10-20"]
[42,"Пост2","Апельсин 59",24,"2014-10-21",0.89,"USD","FOB","2014-12-05","2014-10-27"]

{"sheet":"Пост3","index":2,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["№","Поставщик","Наименование","Кол-во, т","Дата загрузки по инвойсу","Сумма","Валюта","Incoterm","Дата оплаты","Дата прихода "]
[1,"Пост3","Белый виноград",12,"2014-02-12",0.57999999999999996,"EURO","CIF","2014-04-13","2014-02-18"]
[2,"Пост3","Красный виноград",12,"2014-02-12",0.57999999999999996,"EURO","CIF","2014-04-13","2014-02-18"]
[3,"Пост3","Белый виноград",24,"2014-02-18",0.57999999999999996,"EURO","CIF","2014-04-19","2014-02-24"]
[4,"Пост3","Красный виноград",24,"2014-02-18",0.57999999999999996,"EURO","CIF","2014-04-19","2014-02-24"]
[5,"Пост3","Белый виноград",24,"2014-03-04",0.57999999999999996,"EURO","CIF","2014-05-03","2014-03-10"]
[6,"Пост3","Красный виноград",24,"2014-03-04",0.57999999999999996,"EURO","CIF","2014-05-03","2014-03-10"]
[7,"Пост3","Белый виноград",24,"2014-03-19",0.57999999999999996,"EURO","CIF","2014-05-18","2014-03-24"]
[8,"Пост3","Красный виноград",24,"2014-03-27",0.57999999999999996,"EURO","CIF","2014-05-26","2014-04-02"]
[9,"Пост3","Белый виноград",24,"2014-04-08",0.57999999999999996,"EURO","CIF","2014-06-07","2014-04-14"]
[10,"Пост3","Белый виноград",24,"2014-04-15",0.57999999999999996,"EURO","CIF","2014-06-14","2014-04-21"]
[11,"Пост3","Белый виноград",24,"2014-04-29",0.57999999999999996,"EURO","CIF","2014-06-28","2014-05-05"]
[12,"Пост3","Красный виноград",24,"2014-04-29",0.57999999999999996,"EURO","CIF","2014-06-28","2014-05-05"]
[13,"Пост3","Белый виноград",24,"2014-05-13",0.57999999999999996,"EURO","CIF","2014-07-12","2014-05-19"]
[14,"Пост3","Белый виноград",24,"2014-05-20",0.57999999999999996,"EURO","CIF","2014-07-19","2014-05-26"]
[15,"Пост3","Красный виноград",24,"2014-05-20",0.57999999999999996,"EURO","CIF","2014-07-19","2014-05-26"]
[16,"Пост3","Белый виноград",24,"2014-06-04",0.57999999999999996,"EURO","CIF","2014-08-03","2014-06-10"]
[17,"Пост3","Белый виноград",19.079999999999998,"2014-06-12",0.57999999999999996,"EURO","CIF","2014-08-11","2014-06-18"]
[18,"Пост3","Красный виноград",19.079999999999998,"2014-06-12",0.57999999999999996,"EURO","CIF","2014-08-11","2014-06-18"]
[19,"Пост3","Белый виноград",19.079999999999998,"2014-07-02",0.57999999999999996,"EURO","CIF","2014-08-31","2014-07-07"]
[20,"Пост3","Красный виноград",19.079999999999998,"2014-07-02",0.57999999999999996,"EURO","CIF","2014-08-31","2014-07-07"]
[21,"Пост3","Белый виноград",19.079999999999998,"2014-07-17",0.57999999999999996,"EURO","CIF","2014-09-15","2014-07-25"]
[22,"Пост3","Белый виноград",19.079999999999998,"2014-08-27",0.57999999999999996,"EURO","CIF","2014-10-26","2014-09-02"]
[23,"Пост3","Белый виноград",19.079999999999998,"2014-09-09",0.57999999999999996,"EURO","CIF","2014-11-08","2014-09-15"]
[24,"Пост3","Красный виноград",19.079999999999998,"2014-09-02",0.57999999999999996,"EURO","CIF","2014-11-01","2014-09-08"]
[25,"Пост3","Белый виноград",19.079999999999998,"2014-09-11",0.57999999999999996,"EURO","CIF","2014-11-10","2014-09-17"]
[26,"Пост3","Красный виноград",19.079999999999998,"2014-09-09",0.57999999999999996,"EURO","CIF","2014-11-08","2014-09-15"]
[27,"Пост3","Белый виноград",19.079999999999998,"2014-09-16",0.57999999999999996,"EURO","CIF","2014-11-15","2014-09-22"]
[28,"Пост3","Красный виноград",19.079999999999998,"2014-09-16",0.57999999999999996,"EURO","CIF","2014-11-15","2014-09-22"]
[29,"Пост3","Белый виноград",19.079999999999998,"2014-10-20",0.57999999999999996,"EURO","CIF","2014-12-19","2014-10-27"]
[30,"Пост3","Белый виноград",19.079999999999998,"2014-10-20",0.57999999999999996,"EURO","CIF","2014-12-19","2014-10-27"]
[31,"Пост3","Белый виноград",19.079999999999998,"2014-11-04",0.57999999999999996,"EURO","CIF","2015-01-03","2014-11-10"]

{"sheet":"Пост4","index":3,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["№","Поставщик","Наименование","Кол-во, т","Дата загрузки по инвойсу","Сумма","Валюта","Incoterm","Дата оплаты","Дата прихода "]
[1,"Пост4","Яблоко",22,"2014-08-05",0.65,"ГРН","DDU","2014-09-20","2014-08-06"]
[2,"Пост4","Яблоко",22,"2014-08-13",0.65,"ГРН","DDU","2014-09-28","2014-08-14"]
[3,"Пост4","Яблоко",22,"2014-08-12",0.65,"ГРН","DDU","2014-09-27","2014-08-13"]
[4,"Пост4","Яблоко",22,"2014-08-14",0.65,"ГРН","DDU","2014-09-29","2014-08-15"]
[5,"Пост4","Яблоко неосветл",6,"2014-08-18",0.65,"ГРН","DDU","2014-10-03","2014-08-19"]
[6,"Пост4","Яблоко",16,"2014-08-18",0.65,"ГРН","DDU","2014-10-03","2014-08-19"]
[7,"Пост4","Яблоко",22,"2014-08-21",0.65,"ГРН","DDU","2014-10-06","2014-08-22"]
[8,"Пост4","Яблоко",22,"2014-08-20",0.65,"ГРН","DDU","2014-10-05","2014-08-21"]
[9,"Пост4","Яблоко",22,"2014-08-27",0.65,"ГРН","DDU","2014-10-12","2014-08-28"]
[10,"Пост4","Яблоко",22,"2014-08-28",0.65,"ГРН","DDU","2014-10-13","2014-08-29"]
[11,"Пост4","Яблоко",22,"2014-08-28",0.65,"ГРН","DDU","2014-10-13","2014-08-29"]
[12,"Пост4","Яблоко",22,"2014-09-04",0.65,"ГРН","DDU","2014-10-20","2014-09-05"]
[13,"Пост4","Яблоко",22,"2014-09-01",0.65,"ГРН","DDU","2014-10-17","2014-09-02"]
[14,"Пост4","Яблоко",22,"2014-09-04",0.65,"ГРН","DDU","2014-10-20","2014-09-05"]
[15,"Пост4","Яблоко",22,"2014-09-10",0.65,"ГРН","DDU","2014-10-26","2014-09-11"]
[16,"Пост4","Яблоко",22,"2014-09-11",0.65,"ГРН","DDU","2014-10-27","2014-09-12"]
[17,"Пост4","Яблоко",22,"2014-09-10",0.65,"ГРН","DDU","2014-10-26","2014-09-11"]
[18,"Пост4","Яблоко",22,"2014-09-11",0.65,"ГРН","DDU","2014-10-27","2014-09-12"]
[19,"Пост4","Яблоко",22,"2014-09-17",0.65,"ГРН","DDU","2014-11-02","2014-09-18"]
[20,"Пост4","Яблоко",22,"2014-09-15",0.65,"ГРН","DDU","2014-10-31","2014-09-16"]
[21,"Пост4","Яблоко",22,"2014-09-17",0.65,"ГРН","DDU","2014-11-02","2014-09-18"]
[22,"Пост4","Яблоко",22,"2014-09-25",0.65,"ГРН","DDU","2014-11-10","2014-09-26"]
[23,"Пост4","Яблоко",22,"2014-09-22",0.65,"ГРН","DDU","2014-11-07","2014-09-23"]
[24,"Пост4","Яблоко",22,"2014-09-22",0.65,"ГРН","DDU","2014-11-07","2014-09-23"]
[25,"Пост4","Яблоко",22,"2014-09-24",0.65,"ГРН","DDU","2014-11-09","2014-09-25"]
[26,"Пост4","Яблоко",22,"2014-10-01",0.65,"ГРН","DDU","2014-11-16","2014-10-02"]
[27,"Пост4","Яблоко",22,"2014-09-30",0.65,"ГРН","DDU","2014-11-15","2014-10-01"]
[28,"Пост4","Яблоко",22,"2014-10-02",0.65,"ГРН","DDU","2014-11-17","2014-10-03"]
[29,"Пост4","Яблоко",22,"2014-10-06",0.65,"ГРН","DDU","2014-11-21","2014-10-07"]
[30,"Пост4","Яблоко",22,"2014-10-09",0.65,"ГРН","DDU","2014-11-23","2014-10-09"]
[31,"Пост4","Яблоко",22,"2014-10-10",0.65,"ГРН","DDU","2014-11-24","2014-10-10"]
[32,"Пост4","Яблоко",22,"2014-10-15",0.65,"ГРН","DDU","2014-11-30","2014-10-16"]
[33,"Пост4","Яблоко",22,"2014-10-16",0.65,"ГРН","DDU","2014-12-01","2014-10-17"]
[34,"Пост4","Яблоко",22,"2014-10-22",0.65,"ГРН","DDU","2014-12-07","2014-10-23"]
[35,"Пост4","Яблоко",22,"2014-10-23",0.65,"ГРН","DDU","2014-12-08","2014-10-24"]
[36,"Пост4","Яблоко",22,"2014-10-20",0.65,"ГРН","DDU","2014-12-05","2014-10-21"]
[37,"Пост4","Яблоко",22,"2014-10-21",0.65,"ГРН","DDU","2014-12-06","2014-10-22"]

{"sheet":"Бюджет","index":4,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Бюджет на следующий месяц",null,null,null,null,null,null,"От:","2014-11-01","До:","2014-11-30"]
[]
["№ п/п","Поставщик","Наименование","Количество,кг","Сумма","Валюта"]
[]
[null,null,null,null,null,null,null,"Все строки которые:"]
[null,null,null,null,null,null,null,"Дата оплаты в диапозоне (Блок условий \"дата от\"-\"дата до\")"]

{"sheet":"Груз в пути","index":5,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Груз в пути",null,null,null,null,null,null,null,null,null,null,"Дата:","2014-10-01"]
[]
["Поставщик","Incoterm","Цена (т)","Валюта","Наименование","Количество, т","Дата загрузки","Дата прихода","Срок поставки в днях"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Все строки которые:"]
[null,null,null,null,null,null,null,null,null,null,null,"Дата загрузки < (Блок условий \"Дата\")< Дата прихода"]