{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["проект"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":"проект","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,6],[1,7,1,10],[1,11,1,14]]}
[null,null,null,null,null,null,"Учет оплат  и  отгрузок",null,null,null,{"$f":"NOW()","v":"2019-05-08T10:50:33.280"}]
["ИСХОДНЫЕ  ДАННЫЕ",null,null,null,null,null,null,"ОПЛАТА",null,null,null,"ОТГРУЗКА"]
["ТМЦ","Покупатель","Дата счета","номер счета","Кол- во, т. ","Цена, за/тн.","Сумма","Оплачено, грн.","Оплачено,тн","Дата оплати","Долг, грн.","Факт. постав., т.","Дата отгрузки","№ транс. средства ","Статус отгрузки 1","Статус отгрузки 2"]
["Товар1","Покупатель2","2019-04-15","10",20,6000,{"$f":"E4*F4","v":120000},120000,20,"2019-04-13",{"$f":"L4*F4-H4","v":0},20,"15.04;   20.04","МАЗ АА2222ЕХ                             DAF АВ2222ВP  ",{"$f":"IF(A4=\"\",\"-\",IF(C4=\"\",\"запланировано\",IF(M4=\"\",\"не отгружено\",IF(I4>L4,\"частично отгружено\",IF(I4<L4,\"перегружено\",\"отгружено\")))))","v":"отгружено"},{"$f":"IF(A4=\"\",\"-\",IF(C4=\"\",\"запланировано\",IF(L4=\"\",\"не отгружено\",IF(I4>L4,\"частично отгружено\",IF(I4<L4,\"перегружено\",\"отгружено\")))))","v":"отгружено"}]
["Товар2","Покупатель3","2019-04-23",11,44,4000,176000,200000,44,null,-20000,45,"2019-04-23","Вольво ПР 3333 ПЕ",{"$f":"IF(A5=\"\",\"-\",IF(C5=\"\",\"запланировано\",IF(M5=\"\",\"не отгружено\",IF(I5>L5,\"частично отгружено\",IF(I5<L5,\"перегружено\",\"отгружено\")))))","v":"перегружено"},{"$f":"IF(A5=\"\",\"-\",IF(C5=\"\",\"запланировано\",IF(L5=\"\",\"не отгружено\",IF(I5>L5,\"частично отгружено\",IF(I5<L5,\"перегружено\",\"отгружено\")))))","v":"перегружено"}]
["Товар3","Покупатель3","2019-04-23","12",20,5000,100000,90000,null,"2019-04-22",{"$f":"L6*F6-H6","v":-90000},null,null,null,"не отгружено","не отгружено"]
["Товар2","Покупатель2","2019-04-26","14","10,00",6000,60000,60000,10,"2019-04-25",{"$f":"L7*F7-H7","v":0},10,"2019-04-25","ДАФ АН 3256 АМ ","отгружено","отгружено"]
["Товар1","Покупатель3","2019-04-27","15",2,7500,15000,15000,2,"2019-04-25",{"$f":"L8*F8-H8","v":-7500},1,"2019-04-25","ДАФ АН 3256 АМ ","частично отгружено","частично отгружено"]
["Товар4","Покупатель1","2019-05-07","18",22,3000,66000,33000,11,"2019-05-07",{"$f":"L9*F9-H9","v":0},11,"2019-05-07","Вольво ПР 3333 ПЕ","отгружено","отгружено"]
[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,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,null,null,null,null,null,null,null,9538.3050000000003,6682.0450000000001]