{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Итоговый","Результат"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["№","Дата","Фамилия","Город","Склад","Комментарий","Примечание",1,2,3]
[1,"1 июля","Иванов","МСК","обувь",4,14,"да","нет","да"]
[2,"1 июля","Петров ","СПБ","одежда",5,15,"нет","нет","нет"]
[3,"2 июля","Иванов","МСК","косметика",6,16,"да","да","да"]
[4,"3 июля","Петров","СПБ","канцелярия",7,17,"нет","нет","да"]
[5,"3 июля","Иванов","СПБ","спорт",8,18,"да","нет","да"]
[6,"3 июля","Сидоров","МСК","строительство",9,19,"нет","да","нет"]
[7,"4 июля","Иванов, Петров","МСК","книги",10,20,"да","нет","да"]
[8,"4 июля","Сидоров","СПБ","аптека",11,21,"нет","нет","да"]
[9,"5 июля","Петров, Сидоров","СПб","продукты",12,22,"да","да","да"]
[10,"6 июля","Сидоров","МСК","детские товары",13,23,"нет","нет","нет"]
[]
[]
[]
[]
[]
[null,{"$f":"IFERROR(INDEX(E2:E11,SMALL(IF(Результат!B1=C2:C11,ROW(E2:E11)-1,\"\"),ROW()-3)),\"\")","v":""}]

{"sheet":"Итоговый","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Результат","index":2,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,1,0,4],[6,0,6,4]]}
["Фамилия","Иванов",null,null,null,1500,1.6]
["№","Дата","ФИО","Город","Склад","Инв","Коэф",0.2,0.3]
[1,"1 июля","Иванов","МСК","обувь",1,1.6,1,1]
[2,"2 июля","Иванов","МСК","косметика",1,1.6,1,0]
[3,"3 июля","Иванов","СПБ","спорт",1,1.6,1,1]
[4,"4 июля","Иванов","МСК","книги",1,1.6,1,1]
["Итого:",null,null,null,null,{"$f":"SUM(F3:F6)","v":4},null,{"$f":"SUM(H3:H6)","v":4},{"$f":"SUM(I3:I6)","v":3},{"$f":"F7*F1+H7*H2*G1+I7*I2*G1","v":6002.7199999999993}]