{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"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":"Лист1","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Дата","Наименование\nфирмы","Кол-во\nтовар 1","Кол-во\nтовар 2","Всего\nтовар 1","Всего\nтовар 2","Приход\nтовар 1","Приход\nтовар2"]
["НОЯБРЬ 2018"]
["Остаток",null,null,null,20,10]
["18.11.2018","Фирма 1",15,null,{"$f":"IF(C4=0,\"\",E$3+SUM(G$3:G4)-SUM(C$3:C4))","v":305},{"$f":"IF(D4=0,\"\",F$3+SUM(H$3:H4)-SUM(D$3:D4))","v":""},300]
["19.11.2018","Фирма 2",200,null,{"$f":"IF(C5=0,\"\",E$3+SUM(G$3:G5)-SUM(C$3:C5))","v":105},{"$f":"IF(D5=0,\"\",F$3+SUM(H$3:H5)-SUM(D$3:D5))","v":""},null,200]
["19.11.2018","Фирма 3",45,null,{"$f":"IF(C6=0,\"\",E$3+SUM(G$3:G6)-SUM(C$3:C6))","v":1260},{"$f":"IF(D6=0,\"\",F$3+SUM(H$3:H6)-SUM(D$3:D6))","v":""},1200]
["2018-11-19","Фирма 4",125,null,{"$f":"IF(C7=0,\"\",E$3+SUM(G$3:G7)-SUM(C$3:C7))","v":1135},{"$f":"IF(D7=0,\"\",F$3+SUM(H$3:H7)-SUM(D$3:D7))","v":""}]
["21.11.2018","Фирма 5",null,22,{"$f":"IF(C8=0,\"\",E$3+SUM(G$3:G8)-SUM(C$3:C8))","v":""},{"$f":"IF(D8=0,\"\",F$3+SUM(H$3:H8)-SUM(D$3:D8))","v":188}]
["23.11.2018","Фирма 6",16,null,{"$f":"IF(C9=0,\"\",E$3+SUM(G$3:G9)-SUM(C$3:C9))","v":1119},{"$f":"IF(D9=0,\"\",F$3+SUM(H$3:H9)-SUM(D$3:D9))","v":""}]
["23.11.2018","Фирма 7",12,null,{"$f":"IF(C10=0,\"\",E$3+SUM(G$3:G10)-SUM(C$3:C10))","v":1107},{"$f":"IF(D10=0,\"\",F$3+SUM(H$3:H10)-SUM(D$3:D10))","v":""}]
["2018-11-25","Фирма 8",null,12,{"$f":"IF(C11=0,\"\",E$3+SUM(G$3:G11)-SUM(C$3:C11))","v":""},{"$f":"IF(D11=0,\"\",F$3+SUM(H$3:H11)-SUM(D$3:D11))","v":176}]
["2018-11-26","Фирма 9",147,null,{"$f":"IF(C12=0,\"\",E$3+SUM(G$3:G12)-SUM(C$3:C12))","v":960},{"$f":"IF(D12=0,\"\",F$3+SUM(H$3:H12)-SUM(D$3:D12))","v":""}]
["2018-11-30","Фирма 10",89,null,{"$f":"IF(C13=0,\"\",E$3+SUM(G$3:G13)-SUM(C$3:C13))","v":871},{"$f":"IF(D13=0,\"\",F$3+SUM(H$3:H13)-SUM(D$3:D13))","v":""}]
["2018-12-01","Фирма 11",210,null,{"$f":"IF(C14=0,\"\",E$3+SUM(G$3:G14)-SUM(C$3:C14))","v":661},{"$f":"IF(D14=0,\"\",F$3+SUM(H$3:H14)-SUM(D$3:D14))","v":""}]
[null,null,null,null,{"$f":"IF(C15=0,\"\",E$3+SUM(G$3:G15)-SUM(C$3:C15))","v":""},{"$f":"IF(D15=0,\"\",F$3+SUM(H$3:H15)-SUM(D$3:D15))","v":""}]
[null,null,null,null,{"$f":"IF(C16=0,\"\",E$3+SUM(G$3:G16)-SUM(C$3:C16))","v":""},{"$f":"IF(D16=0,\"\",F$3+SUM(H$3:H16)-SUM(D$3:D16))","v":""}]
[null,null,null,null,{"$f":"IF(C17=0,\"\",E$3+SUM(G$3:G17)-SUM(C$3:C17))","v":""},{"$f":"IF(D17=0,\"\",F$3+SUM(H$3:H17)-SUM(D$3:D17))","v":""}]
[null,null,null,null,{"$f":"IF(C18=0,\"\",E$3+SUM(G$3:G18)-SUM(C$3:C18))","v":""},{"$f":"IF(D18=0,\"\",F$3+SUM(H$3:H18)-SUM(D$3:D18))","v":""}]
[null,null,null,null,{"$f":"IF(AND(H19=0,C19=0),\"\",E18+C19)","v":""},{"$f":"IF(AND(H19=0,D19=0),\"\",F18+D19)","v":""}]
[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,"",""]