{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["РМК","Перемещения","Склад"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"РМК","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,8,1,10],[2,0,3,1],[2,2,3,2],[2,8,2,9],[3,8,3,9],[14,0,14,2],[4,8,4,9],[5,0,5,1],[5,8,5,9],[6,0,6,1],[6,8,6,9],[7,0,7,1],[7,8,7,9],[8,0,8,1],[8,8,8,9],[9,0,9,1],[9,8,9,9],[11,0,12,2]]}
[{"$f":"TODAY()","v":"2020-07-15"}]
["Кассовый блок",null,null,null,null,null,null,null,"Продажи за день"]
["Касса",null,{"$f":"SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Движение],\"продажа\",[1]!Таблица1[Проверка],\"ОК!\")-SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Движение],\"возврат\",[1]!Таблица1[Проверка],\"ОК!\")+SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Наименование],\"Внесение\",[1]!Таблица1[Проверка],\"ОК!\")-SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Наименование],\"Изъятие\",[1]!Таблица1[Проверка],\"ОК!\")-C7-C10","v":0},null,null,null,null,null,"ФИО Продавца",null,"Сим-карты","Устройства","Услуги","Аксессуары","Премия"]
[null,null,null,null,null,null,null,null,{"$f":"[1]Сотрудники!B2","v":"Голубев А.В"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I4,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I4,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I4,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I4,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"P4","v":0},{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I4,$AJ$17:$AJ$1089)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"[1]Сотрудники!B3","v":"Голубев В.Б"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I5,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I5,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I5,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I5,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},0,{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I5,$AJ$17:$AJ$1089)","v":0}]
["Эквайринг",null,{"$f":"SUMIFS([1]!Таблица1[Карта],[1]!Таблица1[Движение],\"продажа\",[1]!Таблица1[Проверка],\"ОК!\")-SUMIFS([1]!Таблица1[Карта],[1]!Таблица1[Движение],\"возврат\",[1]!Таблица1[Проверка],\"ОК!\")","v":0},null,null,null,null,null,{"$f":"[1]Сотрудники!B4","v":"-"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I6,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I6,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I6,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I6,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},0,{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I6,$AJ$17:$AJ$1089)","v":0}]
["Инкассация",null,{"$f":"SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],$A$7,[1]!Таблица1[Проверка],\"ОК!\")","v":0},null,null,null,null,null,{"$f":"[1]Сотрудники!B5","v":"-"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I7,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I7,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I7,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I7,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},0,{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I7,$AJ$17:$AJ$1089)","v":0}]
["Изъятия",null,{"$f":"SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Наименование],\"Изъятие\",[1]!Таблица1[Проверка],\"ОК!\")","v":0},null,null,null,null,null,{"$f":"[1]Сотрудники!B6","v":"-"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I8,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I8,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I8,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I8,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},0,{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I8,$AJ$17:$AJ$1089)","v":0}]
["Внесения",null,{"$f":"SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Наименование],\"Внесение\",[1]!Таблица1[Проверка],\"ОК!\")","v":0},null,null,null,null,null,{"$f":"[1]Сотрудники!B7","v":"-"},null,{"$f":"SUMIFS($AE$17:$AE$1089,[1]!Таблица1[ФИО Продавца],$I9,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AF$17:$AF$1089,[1]!Таблица1[ФИО Продавца],$I9,[1]!Таблица1[Проверка],\"ОК!\")&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AG$17:$AG$1089,[1]!Таблица1[ФИО Продавца],$I9,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS($AI$17:$AI$1089,[1]!Таблица1[ФИО Продавца],$I9,[1]!Таблица1[Проверка],\"ОК!\")","v":{"$error":"#REF!"}},0,{"$f":"SUMIF([1]!Таблица1[ФИО Продавца],$I9,$AJ$17:$AJ$1089)","v":0}]
["Расходы",null,{"$f":"SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],\"канцелярия\",[1]!Таблица1[Проверка],\"ок!\")+SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],\"хоз. товары\",[1]!Таблица1[Проверка],\"ок!\")+SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],\"оборудование\",[1]!Таблица1[Проверка],\"ок!\")+SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],\"транспортные расходы\",[1]!Таблица1[Проверка],\"ок!\")+SUMIFS([1]!Таблица1[Наличные],[1]!Таблица1[Категория],\"услуги\",[1]!Таблица1[Проверка],\"ок!\")","v":0},null,null,null,null,null,"Итого",null,{"$f":"SUM(K4:K9)&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUM(L4:L9)&\" \"&\"шт.\"","v":{"$error":"#REF!"}},{"$f":"SUM(M4:M9)","v":{"$error":"#REF!"}},{"$f":"SUM(N4:N9)","v":{"$error":"#REF!"}},{"$f":"SUM(O4:O9)","v":0}]
[]
[{"$f":"AM17","v":0}]
[]
[]
["Рабочее место кассира"]
["Дата","ФИО Продавца","Движение","Код товара","Код операции","Наименование","Категория","СН/СЧ","Кол-во","Цена","Наличные","Карта","Сумма","Комментарий","Проверка"]
["2020-07-15","Голубев А.В","Продажа","1010-0001","-","Наушники HOCO 3.5mm вакумные (premium)","Аксессуары","29381887897",1,890,890,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,{"$f":"IF(Q17=0,\"ОК!\",\"ОШИБКА...\")","v":"ОК!"}]
["2020-07-15","Голубев А.В","Замена","1010-0001","-","Наушники HOCO 3.5mm вакумные (premium)","Аксессуары","29381887897",1,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},"Надлом провода","ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]
[null,null,null,"-","-","-","-",null,null,0,0,0,{"$f":"SUM([1]!Таблица1[[#This Row],[Цена]]*[1]!Таблица1[[#This Row],[Кол-во]])","v":0},null,"ОК!"]

{"sheet":"Перемещения","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Дата","ФИО Сотрудника","Код товара","Наимемнование","Категория","Серийный номер","Операция","Кол-во","Цена","Сумма","Комментарий"]
[{"$f":"NOW()","v":"2020-07-15T09:33:49.300"},"Голубев А.В","1010-0001","Наушники HOCO 3.5mm вакумные (premium)","Аксессуары",29381887897,"Приход",1,890,{"$f":"SUM(I2*H2)","v":890}]
[null,null,null,"-","-",null,null,null,0,{"$f":"SUM(I3*H3)","v":0}]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]
[null,null,null,"-","-",null,null,null,0,0]

{"sheet":"Склад","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Дата","ФИО Сотрудника","Код товара","Наимемнование","Категория","Серийный номер","Операция"]
["2020-07-15T09:33:33","Голубев А.В","1010-0001","Наушники HOCO 3.5mm вакумные (premium)","Аксессуары",29381887897,"Приход"]