{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Движение товара","БД Движения товара"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":10,"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":39,"n_cols":15,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,8,1,10]]}
[]
[null,null,null,null,null,null,null,null,"КОНВЕРТАЦИЯ"]
[null,null,null,null,null,null,null,null,"Себестоимость за шт.,₽","Кол-во шт.","Сумма, ₽"]
[null,null,"Дата",{"$f":"TODAY()","v":"2020-11-27"},null,null,null,null,{"$f":"IFERROR(K4/J4,\"\")","v":""}]
[]
[]
[null,null,"Наименование","Тип","Приход, шт","Расход, шт.","Приход, кг.","Расход, кг.","Себестоимость за шт., ₽","Сумма Себестоимости, ₽","Комментарий"]
[null,"1.","Платы Кнопки","Платы",null,null,null,null,null,{"$f":"(I8*(E8+G8))-(I8*(F8+H8))","v":0}]
[null,"2.","Платы Смартфоны","Кнопки",null,null,null,null,null,{"$f":"(I9*(E9+G9))-(I9*(F9+H9))","v":0}]
[null,"3.",null,null,null,null,null,null,null,0]
[null,"4.",null,null,null,null,null,null,null,0]
[null,"5.",null,null,null,null,null,null,null,{"$f":"I12*(E12+F12+G12+H12)","v":0}]
[]
[]
[]
[]
[]
[null,"Дата","День","День недели","месяц","год","Наименование","Тип","Приход, шт","Расход, шт.","Приход, кг.","Расход, кг.","Себестоимость за шт., ₽","Сумма Себестоимости, ₽","Комментарий"]
[null,{"$f":"IF(Таблица22[[#This Row],[Наименование]]=$B$17,\"\",$D$4)","v":"2020-11-27"},{"$f":"IFERROR(DAY(Таблица22[[#This Row],[Дата]]),\"\")","v":27},{"$f":"IFERROR(TEXT(Таблица22[[#This Row],[Дата]],\"ДДДД\"),\"\")","v":"пятница"},{"$f":"IFERROR(MONTH(Таблица22[[#This Row],[Дата]]),\"\")","v":11},{"$f":"IFERROR(YEAR(Таблица22[[#This Row],[Дата]]),\"\")","v":2020},{"$f":"C8","v":"Платы Кнопки"},{"$f":"D8","v":"Платы"},{"$f":"E8","v":0},{"$f":"F8","v":0},{"$f":"G8","v":0},{"$f":"H8","v":0},{"$f":"I8","v":0},{"$f":"J8","v":0},{"$f":"K8","v":0}]
[null,{"$f":"IF(Таблица22[[#This Row],[Наименование]]=$B$17,\"\",$D$4)","v":"2020-11-27"},{"$f":"IFERROR(DAY(Таблица22[[#This Row],[Дата]]),\"\")","v":27},{"$f":"IFERROR(TEXT(Таблица22[[#This Row],[Дата]],\"ДДДД\"),\"\")","v":"пятница"},{"$f":"IFERROR(MONTH(Таблица22[[#This Row],[Дата]]),\"\")","v":11},{"$f":"IFERROR(YEAR(Таблица22[[#This Row],[Дата]]),\"\")","v":2020},{"$f":"C9","v":"Платы Смартфоны"},{"$f":"D9","v":"Кнопки"},{"$f":"E9","v":0},{"$f":"F9","v":0},{"$f":"G9","v":0},{"$f":"H9","v":0},{"$f":"I9","v":0},{"$f":"J9","v":0},{"$f":"K9","v":0}]
[null,{"$f":"IF(Таблица22[[#This Row],[Наименование]]=$B$17,\"\",$D$4)","v":""},{"$f":"IFERROR(DAY(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(TEXT(Таблица22[[#This Row],[Дата]],\"ДДДД\"),\"\")","v":""},{"$f":"IFERROR(MONTH(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(YEAR(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"C10","v":0},{"$f":"D10","v":0},{"$f":"E10","v":0},{"$f":"F10","v":0},{"$f":"G10","v":0},{"$f":"H10","v":0},{"$f":"I10","v":0},{"$f":"J10","v":0},{"$f":"K10","v":0}]
[null,{"$f":"IF(Таблица22[[#This Row],[Наименование]]=$B$17,\"\",$D$4)","v":""},{"$f":"IFERROR(DAY(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(TEXT(Таблица22[[#This Row],[Дата]],\"ДДДД\"),\"\")","v":""},{"$f":"IFERROR(MONTH(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(YEAR(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"C11","v":0},{"$f":"D11","v":0},{"$f":"E11","v":0},{"$f":"F11","v":0},{"$f":"G11","v":0},{"$f":"H11","v":0},{"$f":"I11","v":0},{"$f":"J11","v":0},{"$f":"K11","v":0}]
[null,{"$f":"IF(Таблица22[[#This Row],[Наименование]]=$B$17,\"\",$D$4)","v":""},{"$f":"IFERROR(DAY(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(TEXT(Таблица22[[#This Row],[Дата]],\"ДДДД\"),\"\")","v":""},{"$f":"IFERROR(MONTH(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"IFERROR(YEAR(Таблица22[[#This Row],[Дата]]),\"\")","v":""},{"$f":"C12","v":0},{"$f":"D12","v":0},{"$f":"E12","v":0},{"$f":"F12","v":0},{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12","v":0},{"$f":"J12","v":0},{"$f":"K12","v":0}]
[]
[null,null,"КОПИРУЕМ"]
[null,null,"НЕ КОПИРУЕМ"]
[]
[null,null,"Sub MovementoOfGoods()"]
[null,null,"    Application.ScreenUpdating = False"]
[null,null,"Application.EnableEvents = False"]
[null,null,"ActiveWorkbook.ActiveSheet.DisplayPageBreaks = False"]
[null,null,"    If Response = vbNo Then Exit Sub"]
[null,null,"    Worksheets(\"Движение товара\").Range(\"B19:O23\").Copy"]
[null,null,"    n = Worksheets(\"БД Движения товара\").Range(\"A100000\").End(xlUp).Row"]
[null,null,"    Worksheets(\"БД Движения товара\").Cells(n + 1, 1).PasteSpecial Paste:=xlPasteValues"]
[null,null,"    Worksheets(\"Движение товара\").Range(\"C8,C9,C10,C11,C12,D8,D9,D10,D11,D12,E8,E9,E10,E11,E12,F8,F9,F10,F11,F12,G8,G9,G10,G11,G12,H8,H9,H10,H11,H12,I8,I9,I10,I11,I12,K8,K9,K10,K11,K12,J4,K4\").ClearContents"]
[null,null,"    Application.ScreenUpdating = True"]
[null,null,"Application.EnableEvents = True"]
[null,null,"End Sub"]

{"sheet":"БД Движения товара","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Дата","День","День недели","месяц","год","Наименование","Тип","Приход, шт","Расход, шт.","Приход, кг.","Расход, кг.","Себестоимость за шт., ₽","Сумма Себестоимости, ₽","Комментарий"]
["2020-11-27",27,"пятница",11,2020,"Платы Смартфоны","Платы Смартфоны",10,9,10,10,12,12,"ывап"]
["2020-11-27",27,"пятница",11,2020,"Аффинаж Платы Смартфоны","Аффинаж Платы Смартфоны",1,2,1,1,12,-12,"ып"]
["2020-11-27",27,"пятница",11,2020,"Смартфоны Китай","Смартфоны Китай",1,1,2,1,12,12,"ып"]
["2020-11-27",27,"пятница",11,2020,"Платы Чипы","Платы Чипы",1,2,1,1,12,-12,"ып"]
["2020-11-27",27,"пятница",11,2020,"Смартфоны Лот","Смартфоны Лот",1,0,0,0,12,12,0]
["","","","","",0,0,0,0,0,0,0,0,0]
["","","","","",0,0,0,0,0,0,0,0,0]
["","","","","",0,0,0,0,0,0,0,0,0]
["","","","","",0,0,0,0,0,0,0,0,0]