{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Лист1","Лист2","Таблица","Справочник Движение"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,15,3,15],[2,4,3,4],[2,3,3,3],[2,2,3,2],[2,1,3,1],[2,6,2,8],[2,9,2,10],[2,11,2,12],[2,5,3,5],[1,1,1,7],[2,13,3,13],[2,14,3,14],[2,0,3,0]]}
[]
[null,"Таблица в исходном состоянии. (фактически имеет около 500 позиций)"]
["№ п/п","№ кондуктора","Наименование","Изделие","Кол-во ","В наличии","Место хранения",null,null,"Выдано",null,"Возврат",null,"Участок","Кому выдано","Примечание"]
[{"$f":"A3","v":"№ п/п"},"№ кондуктора","Наименование","Изделие","Кол-во ","В наличии","склад","стеллаж","полка","Дата","Кол-во","Дата","Кол-во",{"$f":"N3","v":"Участок"},{"$f":"O3","v":"Кому выдано"},{"$f":"P3","v":"Примечание"}]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"$E$5-SUM($K5:K$5)+SUM($M5:M$5)","v":10},2,1,7,{"$f":"IF(ISBLANK(K5),\"\",TODAY())","v":""},null,{"$f":"IF(ISBLANK(M5),\"\",TODAY())","v":""},null,"Металлоконструкции","Семешкин"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"$E$6-SUM($K$6:K6)+SUM($M$6:M6)","v":5},1,4,0,"",null,"",null,"Механосборочный","Иванов"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"$E$7-SUM($K$7:K7)+SUM($M$7:M7)","v":6},6,0,0,"",null,"",null,"Монтажный","Петров"]
[4,3370000,"Кондуктор4","ОПАГ2 .01. 0011",7,{"$f":"$E$8-SUM($K$8:K8)+SUM($M$8:M8)","v":7},1,3,3,"",null,"",null,"Металлоконструкции","Сидоров"]
[5,4370000,"Кондуктор5","ОПАГ2 .01. 0012",8,{"$f":"$E$9-SUM($K$9:K9)+SUM($M$9:M9)","v":8},2,2,4,"",null,"",null,"Механосборочный","Семешкин"]
[6,5370000,"Кондуктор6","ОПАГ2 .01. 0013",9,{"$f":"$E$10-SUM($K$10:K10)+SUM($M$10:M10)","v":9},3,3,3,"",null,"",null,"Монтажный","Иванов"]
[7,6370000,"Кондуктор7","ОПАГ2 .01. 0014",10,{"$f":"$E$11-SUM($K$11:K11)+SUM($M$11:M11)","v":10},5,5,0,"",null,"",null,"Металлоконструкции","Петров"]
[8,7370000,"Кондуктор8","ОПАГ2 .01. 0015",10,{"$f":"$E$12-SUM($K$12:K12)+SUM($M$12:M12)","v":10},5,0,5,"",null,"",null,"Механосборочный","Сидоров"]
[9,8370000,"Кондуктор9","ОПАГ2 .01. 0016",10,{"$f":"$E$13-SUM($K$13:K13)+SUM($M$13:M13)","v":10},5,0,5,"",null,"",null,"Монтажный","Семешкин"]
[10,9370000,"Кондуктор10","ОПАГ2 .01. 0017",10,{"$f":"$E$14-SUM($K$14:K14)+SUM($M$14:M14)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Иванов"]
[11,10370000,"Кондуктор11","ОПАГ2 .01. 0018",10,{"$f":"$E$15-SUM($K$15:K15)+SUM($M$15:M15)","v":10},5,0,5,"",null,"",null,"Механосборочный","Петров"]
[12,11370000,"Кондуктор12","ОПАГ2 .01. 0019",10,{"$f":"$E$16-SUM($K$16:K16)+SUM($M$16:M16)","v":10},5,0,5,"",null,"",null,"Монтажный","Сидоров"]
[13,12370000,"Кондуктор13","ОПАГ2 .01. 0020",10,{"$f":"$E$17-SUM($K$17:K17)+SUM($M$17:M17)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Семешкин"]
[14,13370000,"Кондуктор14","ОПАГ2 .01. 0021",10,{"$f":"$E$18-SUM($K$18:K18)+SUM($M$18:M18)","v":10},5,0,5,"",null,"",null,"Механосборочный","Иванов"]
[15,14370000,"Кондуктор15","ОПАГ2 .01. 0022",10,{"$f":"$E$19-SUM($K$19:K19)+SUM($M$19:M19)","v":10},5,0,5,"",null,"",null,"Монтажный","Петров"]
[16,15370000,"Кондуктор16","ОПАГ2 .01. 0023",10,{"$f":"$E$20-SUM($K$20:K20)+SUM($M$20:M20)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Сидоров"]
[17,16370000,"Кондуктор17","ОПАГ2 .01. 0024",10,{"$f":"$E$21-SUM($K$21:K21)+SUM($M$21:M21)","v":10},5,0,5,"",null,"",null,"Механосборочный","Семешкин"]
[18,17370000,"Кондуктор18","ОПАГ2 .01. 0025",10,{"$f":"$E$22-SUM($K$22:K22)+SUM($M$22:M22)","v":10},5,0,5,"",null,"",null,"Монтажный","Иванов"]
[19,18370000,"Кондуктор19","ОПАГ2 .01. 0026",10,{"$f":"$E$23-SUM($K$23:K23)+SUM($M$23:M23)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Семешкин"]

{"sheet":"Лист2","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,13,3,13],[1,0,1,15],[2,14,3,14],[2,0,3,0],[2,15,3,15],[2,4,3,4],[2,3,3,3],[2,2,3,2],[2,1,3,1],[2,6,2,8],[2,9,2,10],[2,11,2,12],[2,5,3,5]]}
[]
["Таблица в \"заполненом состоянии\". Т.е. по каждой позиции мы имеем информацию когда и кому выдана. Собственно большего я от таблицы и не хочу).              Выполнение дополнительных переносов и двойных действий не предполагается) . Ну если не считать заполнение столбцов G-I, но тут без человека не обойтись)."]
["№ п/п","№ кондуктора","Наименование","Изделие","Кол-во ","В наличии","Место хранения",null,null,"Выдано",null,"Возврат",null,"Участок","Кому выдано","Примечание"]
[{"$f":"A3","v":"№ п/п"},"№ кондуктора","Наименование","Изделие","Кол-во ","В наличии","склад","стеллаж","полка","Дата","Кол-во","Дата","Кол-во",{"$f":"N3","v":"Участок"},{"$f":"O3","v":"Кому выдано"},{"$f":"P3","v":"Примечание"}]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"$E$5-SUM($K$5:K5)+SUM($M$5:M5)","v":5},0,5,0,{"$f":"IF(ISBLANK(K5),\"\",TODAY())","v":"2013-05-21"},5,{"$f":"IF(ISBLANK(M5),\"\",TODAY())","v":""},null,"Металлоконструкции","Семешкин"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K6)+SUM($M$5:M6)","v":10},3,5,2,"",null,"2013-05-21",5,"Монтажный","Петров"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K7)+SUM($M$5:M7)","v":0},0,0,0,"2013-05-21",10,"",null,"Механосборочный","Сидоров"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K8)+SUM($M$5:M8)","v":3},0,3,0,"",null,"2013-05-21",3,"Механосборочный","Семешкин"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K9)+SUM($M$5:M9)","v":10},0,3,7,"",null,"2013-05-21",7,"Механосборочный","Семешкин"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K10)+SUM($M$5:M10)","v":8},0,3,5,"2013-05-21",2,"",null,"Механосборочный","Семешкин"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K11)+SUM($M$5:M11)","v":7},0,2,5,"2013-05-21",1,"",null,"Механосборочный","Семешкин"]
[null,null,null,null,null,{"$f":"$E$5-SUM($K$5:K12)+SUM($M$5:M12)","v":2},0,2,0,"2013-05-21",5,"",null,"Механосборочный","Семешкин"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"$E$13-SUM($K$13:K13)+SUM($M$13:M13)","v":3},1,4,0,"2013-05-21",2,"",null,"Механосборочный","Иванов"]
[null,null,null,null,null,{"$f":"$E$13-SUM($K$13:K14)+SUM($M$13:M14)","v":0},0,0,0,"2013-05-21",3,"",null,"Механосборочный","Иванов"]
[null,null,null,null,null,{"$f":"$E$13-SUM($K$13:K15)+SUM($M$13:M15)","v":3},3,0,0,"",null,"2013-05-21",3,"Механосборочный","Иванов"]
[null,null,null,null,null,{"$f":"$E$13-SUM($K$13:K16)+SUM($M$13:M16)","v":5},5,0,0,"",null,"2013-05-21",2,"Механосборочный","Иванов"]
[null,null,null,null,null,{"$f":"$E$13-SUM($K$13:K17)+SUM($M$13:M17)","v":0},0,0,0,"2013-05-21",5,"",null,"Механосборочный","Иванов"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"$E$18-SUM($K$18:K18)+SUM($M$18:M18)","v":0},0,0,0,"2013-05-21",6,"",null,"Монтажный","Петров"]
[null,null,null,null,null,{"$f":"$E$18-SUM($K$18:K19)+SUM($M$18:M19)","v":6},6,0,0,"",null,"2013-05-21",6,"Монтажный","Петров"]
[null,null,null,null,null,{"$f":"$E$18-SUM($K$18:K20)+SUM($M$18:M20)","v":3},3,0,0,"2013-05-21",3,"",null,"Монтажный","Петров"]
[null,null,null,null,null,{"$f":"$E$18-SUM($K$18:K21)+SUM($M$18:M21)","v":6},3,0,3,"",null,"2013-05-21",3,"Монтажный","Петров"]
[4,3370000,"Кондуктор4","ОПАГ2 .01. 0011",7,{"$f":"$E$22-SUM($K$22:K22)+SUM($M$22:M22)","v":7},1,3,3,"",null,"",null,"Металлоконструкции","Сидоров"]
[5,4370000,"Кондуктор5","ОПАГ2 .01. 0012",8,{"$f":"$E$23-SUM($K$23:K23)+SUM($M$23:M23)","v":8},2,2,4,"",null,"",null,"Механосборочный","Семешкин"]
[6,5370000,"Кондуктор6","ОПАГ2 .01. 0013",9,{"$f":"$E$24-SUM($K$24:K24)+SUM($M$24:M24)","v":9},3,3,3,"",null,"",null,"Монтажный","Иванов"]
[7,6370000,"Кондуктор7","ОПАГ2 .01. 0014",10,{"$f":"$E$25-SUM($K$25:K25)+SUM($M$25:M25)","v":10},5,5,0,"",null,"",null,"Металлоконструкции","Петров"]
[8,7370000,"Кондуктор8","ОПАГ2 .01. 0015",10,{"$f":"$E$26-SUM($K$26:K26)+SUM($M$26:M26)","v":10},5,0,5,"",null,"",null,"Механосборочный","Сидоров"]
[9,8370000,"Кондуктор9","ОПАГ2 .01. 0016",10,{"$f":"$E$27-SUM($K$27:K27)+SUM($M$27:M27)","v":10},5,0,5,"",null,"",null,"Монтажный","Семешкин"]
[10,9370000,"Кондуктор10","ОПАГ2 .01. 0017",10,{"$f":"$E$28-SUM($K$28:K28)+SUM($M$28:M28)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Иванов"]
[11,10370000,"Кондуктор11","ОПАГ2 .01. 0018",10,{"$f":"$E$29-SUM($K$29:K29)+SUM($M$29:M29)","v":10},5,0,5,"",null,"",null,"Механосборочный","Петров"]
[12,11370000,"Кондуктор12","ОПАГ2 .01. 0019",10,{"$f":"$E$30-SUM($K$30:K30)+SUM($M$30:M30)","v":10},5,0,5,"",null,"",null,"Монтажный","Сидоров"]
[13,12370000,"Кондуктор13","ОПАГ2 .01. 0020",10,{"$f":"$E$31-SUM($K$31:K31)+SUM($M$31:M31)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Семешкин"]
[14,13370000,"Кондуктор14","ОПАГ2 .01. 0021",10,{"$f":"$E$32-SUM($K$32:K32)+SUM($M$32:M32)","v":10},5,0,5,"",null,"",null,"Механосборочный","Иванов"]
[15,14370000,"Кондуктор15","ОПАГ2 .01. 0022",10,{"$f":"$E$33-SUM($K$33:K33)+SUM($M$33:M33)","v":10},5,0,5,"",null,"",null,"Монтажный","Петров"]
[16,15370000,"Кондуктор16","ОПАГ2 .01. 0023",10,{"$f":"$E$34-SUM($K$34:K34)+SUM($M$34:M34)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Сидоров"]
[17,16370000,"Кондуктор17","ОПАГ2 .01. 0024",10,{"$f":"$E$35-SUM($K$35:K35)+SUM($M$35:M35)","v":10},5,0,5,"",null,"",null,"Механосборочный","Семешкин"]
[18,17370000,"Кондуктор18","ОПАГ2 .01. 0025",10,{"$f":"$E$36-SUM($K$36:K36)+SUM($M$36:M36)","v":10},5,0,5,"",null,"",null,"Монтажный","Иванов"]
[19,18370000,"Кондуктор19","ОПАГ2 .01. 0026",10,{"$f":"$E$37-SUM($K$37:K37)+SUM($M$37:M37)","v":10},5,0,5,"",null,"",null,"Металлоконструкции","Семешкин"]

{"sheet":"Таблица","index":2,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["№ п/п","№ кондуктора","Наименование","Изделие","Кол-во ","В наличии","Место хранения",null,null,"Движение",null,null,"Участок","Кому выдано","Примечание"]
["№ п/п","№ кондуктора","Наименование","Изделие","Кол-во","В наличии","склад","стеллаж","полка","Дата","Кол-во2","Направление","Участок","Кому выдано","Примечание"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K3,D$3:D3,Таблица1[[#This Row],[Изделие]],L$3:L3,Выдано)+SUMIFS(K$3:K3,D$3:D3,Таблица1[[#This Row],[Изделие]],L$3:L3,Возврат)","v":13},0,3,0,{"$f":"IF(ISBLANK(K3),\"\",TODAY())","v":"2013-05-21"},3,"Возврат<--","Механосборочный","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K4,D$3:D4,Таблица1[[#This Row],[Изделие]],L$3:L4,Выдано)+SUMIFS(K$3:K4,D$3:D4,Таблица1[[#This Row],[Изделие]],L$3:L4,Возврат)","v":20},0,3,7,"2013-05-21",7,"Возврат<--","Механосборочный","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K5,D$3:D5,Таблица1[[#This Row],[Изделие]],L$3:L5,Выдано)+SUMIFS(K$3:K5,D$3:D5,Таблица1[[#This Row],[Изделие]],L$3:L5,Возврат)","v":25},3,5,2,"2013-05-21",5,"Возврат<--","Монтажный","Петров"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K6,D$3:D6,Таблица1[[#This Row],[Изделие]],L$3:L6,Выдано)+SUMIFS(K$3:K6,D$3:D6,Таблица1[[#This Row],[Изделие]],L$3:L6,Возврат)","v":20},0,5,0,"2013-05-21",5,"Выдано-->","Металлоконструкции","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K7,D$3:D7,Таблица1[[#This Row],[Изделие]],L$3:L7,Выдано)+SUMIFS(K$3:K7,D$3:D7,Таблица1[[#This Row],[Изделие]],L$3:L7,Возврат)","v":18},0,3,5,"2013-05-21",2,"Выдано-->","Механосборочный","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K8,D$3:D8,Таблица1[[#This Row],[Изделие]],L$3:L8,Выдано)+SUMIFS(K$3:K8,D$3:D8,Таблица1[[#This Row],[Изделие]],L$3:L8,Возврат)","v":17},0,2,5,"2013-05-21",1,"Выдано-->","Механосборочный","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K9,D$3:D9,Таблица1[[#This Row],[Изделие]],L$3:L9,Выдано)+SUMIFS(K$3:K9,D$3:D9,Таблица1[[#This Row],[Изделие]],L$3:L9,Возврат)","v":12},0,2,0,"2013-05-21",5,"Выдано-->","Механосборочный","Семешкин"]
[1,1265000,"Кондуктор1","ОПА -02 .01. 300",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K10,D$3:D10,Таблица1[[#This Row],[Изделие]],L$3:L10,Выдано)+SUMIFS(K$3:K10,D$3:D10,Таблица1[[#This Row],[Изделие]],L$3:L10,Возврат)","v":2},0,0,0,"2013-05-21",10,"Выдано-->","Механосборочный","Сидоров"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K11,D$3:D11,Таблица1[[#This Row],[Изделие]],L$3:L11,Выдано)+SUMIFS(K$3:K11,D$3:D11,Таблица1[[#This Row],[Изделие]],L$3:L11,Возврат)","v":8},3,0,0,"2013-05-21",3,"Возврат<--","Механосборочный","Иванов"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K12,D$3:D12,Таблица1[[#This Row],[Изделие]],L$3:L12,Выдано)+SUMIFS(K$3:K12,D$3:D12,Таблица1[[#This Row],[Изделие]],L$3:L12,Возврат)","v":10},5,0,0,"2013-05-21",2,"Возврат<--","Механосборочный","Иванов"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K13,D$3:D13,Таблица1[[#This Row],[Изделие]],L$3:L13,Выдано)+SUMIFS(K$3:K13,D$3:D13,Таблица1[[#This Row],[Изделие]],L$3:L13,Возврат)","v":8},1,4,0,"2013-05-21",2,"Выдано-->","Механосборочный","Иванов"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K14,D$3:D14,Таблица1[[#This Row],[Изделие]],L$3:L14,Выдано)+SUMIFS(K$3:K14,D$3:D14,Таблица1[[#This Row],[Изделие]],L$3:L14,Возврат)","v":5},0,0,0,"2013-05-21",3,"Выдано-->","Механосборочный","Иванов"]
[2,1370000,"Кондуктор2","ОПАГ2 .01. 0009 ",5,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K15,D$3:D15,Таблица1[[#This Row],[Изделие]],L$3:L15,Выдано)+SUMIFS(K$3:K15,D$3:D15,Таблица1[[#This Row],[Изделие]],L$3:L15,Возврат)","v":0},0,0,0,"2013-05-21",5,"Выдано-->","Механосборочный","Иванов"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K16,D$3:D16,Таблица1[[#This Row],[Изделие]],L$3:L16,Выдано)+SUMIFS(K$3:K16,D$3:D16,Таблица1[[#This Row],[Изделие]],L$3:L16,Возврат)","v":12},6,0,0,"2013-05-21",6,"Возврат<--","Монтажный","Петров"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K17,D$3:D17,Таблица1[[#This Row],[Изделие]],L$3:L17,Выдано)+SUMIFS(K$3:K17,D$3:D17,Таблица1[[#This Row],[Изделие]],L$3:L17,Возврат)","v":15},3,0,3,"2013-05-21",3,"Возврат<--","Монтажный","Петров"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K18,D$3:D18,Таблица1[[#This Row],[Изделие]],L$3:L18,Выдано)+SUMIFS(K$3:K18,D$3:D18,Таблица1[[#This Row],[Изделие]],L$3:L18,Возврат)","v":9},0,0,0,"2013-05-21",6,"Выдано-->","Монтажный","Петров"]
[3,2370000,"Кондуктор3","ОПАГ2 .01. 0010",6,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K19,D$3:D19,Таблица1[[#This Row],[Изделие]],L$3:L19,Выдано)+SUMIFS(K$3:K19,D$3:D19,Таблица1[[#This Row],[Изделие]],L$3:L19,Возврат)","v":6},3,0,0,"2013-05-21",3,"Выдано-->","Монтажный","Петров"]
[4,3370000,"Кондуктор4","ОПАГ2 .01. 0011",7,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K20,D$3:D20,Таблица1[[#This Row],[Изделие]],L$3:L20,Выдано)+SUMIFS(K$3:K20,D$3:D20,Таблица1[[#This Row],[Изделие]],L$3:L20,Возврат)","v":7},1,3,3,"",null,null,"Металлоконструкции","Сидоров"]
[5,4370000,"Кондуктор5","ОПАГ2 .01. 0012",8,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K21,D$3:D21,Таблица1[[#This Row],[Изделие]],L$3:L21,Выдано)+SUMIFS(K$3:K21,D$3:D21,Таблица1[[#This Row],[Изделие]],L$3:L21,Возврат)","v":8},2,2,4,"",null,null,"Механосборочный","Семешкин"]
[6,5370000,"Кондуктор6","ОПАГ2 .01. 0013",9,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K22,D$3:D22,Таблица1[[#This Row],[Изделие]],L$3:L22,Выдано)+SUMIFS(K$3:K22,D$3:D22,Таблица1[[#This Row],[Изделие]],L$3:L22,Возврат)","v":9},3,3,3,"",null,null,"Монтажный","Иванов"]
[7,6370000,"Кондуктор7","ОПАГ2 .01. 0014",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K23,D$3:D23,Таблица1[[#This Row],[Изделие]],L$3:L23,Выдано)+SUMIFS(K$3:K23,D$3:D23,Таблица1[[#This Row],[Изделие]],L$3:L23,Возврат)","v":10},5,5,0,"",null,null,"Металлоконструкции","Петров"]
[8,7370000,"Кондуктор8","ОПАГ2 .01. 0015",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K24,D$3:D24,Таблица1[[#This Row],[Изделие]],L$3:L24,Выдано)+SUMIFS(K$3:K24,D$3:D24,Таблица1[[#This Row],[Изделие]],L$3:L24,Возврат)","v":10},5,0,5,"",null,null,"Механосборочный","Сидоров"]
[9,8370000,"Кондуктор9","ОПАГ2 .01. 0016",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K25,D$3:D25,Таблица1[[#This Row],[Изделие]],L$3:L25,Выдано)+SUMIFS(K$3:K25,D$3:D25,Таблица1[[#This Row],[Изделие]],L$3:L25,Возврат)","v":10},5,0,5,"",null,null,"Монтажный","Семешкин"]
[10,9370000,"Кондуктор10","ОПАГ2 .01. 0017",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K26,D$3:D26,Таблица1[[#This Row],[Изделие]],L$3:L26,Выдано)+SUMIFS(K$3:K26,D$3:D26,Таблица1[[#This Row],[Изделие]],L$3:L26,Возврат)","v":10},5,0,5,"",null,null,"Металлоконструкции","Иванов"]
[11,10370000,"Кондуктор11","ОПАГ2 .01. 0018",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K27,D$3:D27,Таблица1[[#This Row],[Изделие]],L$3:L27,Выдано)+SUMIFS(K$3:K27,D$3:D27,Таблица1[[#This Row],[Изделие]],L$3:L27,Возврат)","v":10},5,0,5,"",null,null,"Механосборочный","Петров"]
[12,11370000,"Кондуктор12","ОПАГ2 .01. 0019",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K28,D$3:D28,Таблица1[[#This Row],[Изделие]],L$3:L28,Выдано)+SUMIFS(K$3:K28,D$3:D28,Таблица1[[#This Row],[Изделие]],L$3:L28,Возврат)","v":10},5,0,5,"",null,null,"Монтажный","Сидоров"]
[13,12370000,"Кондуктор13","ОПАГ2 .01. 0020",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K29,D$3:D29,Таблица1[[#This Row],[Изделие]],L$3:L29,Выдано)+SUMIFS(K$3:K29,D$3:D29,Таблица1[[#This Row],[Изделие]],L$3:L29,Возврат)","v":10},5,0,5,"",null,null,"Металлоконструкции","Семешкин"]
[14,13370000,"Кондуктор14","ОПАГ2 .01. 0021",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K30,D$3:D30,Таблица1[[#This Row],[Изделие]],L$3:L30,Выдано)+SUMIFS(K$3:K30,D$3:D30,Таблица1[[#This Row],[Изделие]],L$3:L30,Возврат)","v":10},5,0,5,"",null,null,"Механосборочный","Иванов"]
[15,14370000,"Кондуктор15","ОПАГ2 .01. 0022",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K31,D$3:D31,Таблица1[[#This Row],[Изделие]],L$3:L31,Выдано)+SUMIFS(K$3:K31,D$3:D31,Таблица1[[#This Row],[Изделие]],L$3:L31,Возврат)","v":10},5,0,5,"",null,null,"Монтажный","Петров"]
[16,15370000,"Кондуктор16","ОПАГ2 .01. 0023",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K32,D$3:D32,Таблица1[[#This Row],[Изделие]],L$3:L32,Выдано)+SUMIFS(K$3:K32,D$3:D32,Таблица1[[#This Row],[Изделие]],L$3:L32,Возврат)","v":10},5,0,5,"",null,null,"Металлоконструкции","Сидоров"]
[17,16370000,"Кондуктор17","ОПАГ2 .01. 0024",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K33,D$3:D33,Таблица1[[#This Row],[Изделие]],L$3:L33,Выдано)+SUMIFS(K$3:K33,D$3:D33,Таблица1[[#This Row],[Изделие]],L$3:L33,Возврат)","v":10},5,0,5,"",null,null,"Механосборочный","Семешкин"]
[18,17370000,"Кондуктор18","ОПАГ2 .01. 0025",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K34,D$3:D34,Таблица1[[#This Row],[Изделие]],L$3:L34,Выдано)+SUMIFS(K$3:K34,D$3:D34,Таблица1[[#This Row],[Изделие]],L$3:L34,Возврат)","v":10},5,0,5,"",null,null,"Монтажный","Иванов"]
[19,18370000,"Кондуктор19","ОПАГ2 .01. 0026",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K35,D$3:D35,Таблица1[[#This Row],[Изделие]],L$3:L35,Выдано)+SUMIFS(K$3:K35,D$3:D35,Таблица1[[#This Row],[Изделие]],L$3:L35,Возврат)","v":5},5,0,5,"2013-05-21",5,"Выдано-->","Монтажный","Иванов"]
[19,18370000,"Кондуктор19","ОПАГ2 .01. 0026",10,{"$f":"Таблица1[[#This Row],[Кол-во]]-SUMIFS(K$3:K36,D$3:D36,Таблица1[[#This Row],[Изделие]],L$3:L36,Выдано)+SUMIFS(K$3:K36,D$3:D36,Таблица1[[#This Row],[Изделие]],L$3:L36,Возврат)","v":5},5,0,5,"",null,null,"Металлоконструкции","Семешкин"]

{"sheet":"Справочник Движение","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Выдано-->"]
["Возврат<--"]