{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Реестр счетов","Отгрузки"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Поставщик","Склад отгрузки","ТМЦ","Покупатель","Дата счета","№ счета","кол-во, тн","Предприятие- Хранитель товара","Факт поставки, тн","Должно быть"]
["Ромашка, ООО","склад 1","Товар1","Сигнет Центр, ООО","2024-02-21",81,44,null,{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F3,Отгрузки!C$3:C$127,\"расход\")","v":40}]
["Берега, ЧП","склад 2","Товар2","Изумруд, ЧП","2024-02-22",82,24,"Галагро,ООО",{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F4,Отгрузки!C$3:C$127,\"расход\")","v":24}]
["Ромашка, ООО","склад 1","Товар3","Агросектор, ООО","2024-02-23",83,22,null,{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F5,Отгрузки!C$3:C$127,\"расход\")","v":20}]
["Берега, ЧП","склад 1","Товар2","Изумруд, ЧП","2024-02-23",84,5,"Галагро,ООО",{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F6,Отгрузки!C$3:C$127,\"расход\")","v":14},5]
["Берега, ЧП","склад 6","Товар2","Изумруд, ЧП","2024-02-23",84,9,"Галагро,ООО",{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F7,Отгрузки!C$3:C$127,\"расход\")","v":14},9]
["Берега, ЧП","склад 3","Товар5","Феникс, ООО","2024-02-24",85,110,null,{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F8,Отгрузки!C$3:C$127,\"расход\")","v":69}]
["Берега, ЧП","склад 3","Товар5","Феникс, ООО","2024-02-26",86,10,null,{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F9,Отгрузки!C$3:C$127,\"расход\")","v":25},10]
["Берега, ЧП","склад 4","Товар5","Феникс, ООО","2024-02-26",86,25,null,{"$f":"SUMIFS(Отгрузки!G$3:G$127,Отгрузки!H$3:H$127,F10,Отгрузки!C$3:C$127,\"расход\")","v":25},25]

{"sheet":"Отгрузки","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Дата  отгрузки","ТМЦ","Операция","Склад отгрузки","Поставщик","Предприятие Хранитель товара- товар хранится на ответственном хранении","Кол-во, тн","Счет","Покупатель"]
["2024-02-21","Товар2","расход","склад 2","Берега, ЧП","Галагро,ООО",5,82,"Изумруд, ЧП"]
["2024-02-21","Товар2","расход с хранения","склад 2","Берега, ЧП","Галагро,ООО",5,82,"Изумруд, ЧП"]
["2024-02-22","Товар1","расход","склад 1","Ромашка, ООО",null,20,81,"Сигнет Центр, ООО"]
["2024-02-23","Товар2","расход","склад 2","Берега, ЧП","Галагро,ООО",10,82,"Изумруд, ЧП"]
["2024-02-23","Товар2","расход с хранения","склад 2","Берега, ЧП","Галагро,ООО",10,82,"Изумруд, ЧП"]
["2024-02-26","Товар5","расход","склад 1","Ромашка, ООО",null,20,81,"Сигнет Центр, ООО"]
["2024-02-26","Товар3","расход","склад 1","Ромашка, ООО",null,20,83,"Агросектор, ООО"]
["2024-02-26","Товар5","расход","склад 3","Берега, ЧП",null,25,85,"Феникс, ООО"]
["2024-02-27","Товар5","расход","склад 3","Берега, ЧП",null,44,85,"Феникс, ООО"]
["2024-02-27","Товар2","расход","склад 2","Берега, ЧП","Галагро,ООО",9,82,"Изумруд, ЧП"]
["2024-02-27","Товар2","расход с хранения","склад 2","Берега, ЧП","Галагро,ООО",9,82,"Изумруд, ЧП"]
["2024-02-27","Товар2","расход","склад 1","Берега, ЧП","Галагро,ООО",5,84,"Изумруд, ЧП"]
["2024-02-27","Товар2","расход","склад 6","Берега, ЧП","Галагро,ООО",9,84,"Изумруд, ЧП"]
["2024-02-27","Товар5","расход","склад 3","Феникс, ООО",null,10,86,"Феникс, ООО"]
["2024-02-27","Товар5","расход","склад 4","Феникс, ООО",null,15,86,"Феникс, ООО"]