{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"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":"Лист1","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,0,33,2],[25,0,25,1],[27,0,27,7],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[0,0,0,9],[1,0,2,0],[1,1,2,1],[1,2,3,2],[1,3,1,6],[1,8,3,8],[1,9,3,9],[2,3,2,4],[2,5,2,6],[2,7,3,7]]}
["Расчет сменной выработки"]
["Дата","2018-10-01","a","фасовка продукта",null,null,null,"отгрузка","выгрузка паллет\nшт.","наклейка \nэтикеток\nт."]
[null,null,null,"метионин кормовой",null,"сульфат натрия",null,"паллет т. биг-бег т."]
["таб №","Ф.И.О.",null,"мешки на палетах т.","биг-бег т.","биг-бег п\\п т.","автоцистерна т."]
[27540,"Пичугин О.В."]
[28494,"Алексеев А.П."]
[27814,"Антюфеев А.Л."]
[23570,"Акимжанов Т.К."]
[30153,"Каратаев Н.Н."]
[27206,"Битюцкий В.Н."]
[28649,"Змиевский Г.П."]
[29236,"Панченко Р.Н."]
[28644,"Никитин А.А."]
[]
[28976,"Карпенко А.А.","a",13,0,18,0,18]
[27775,"Пирматов З.А.","a",13,0,17,0,17]
[577,"Калинин И.В.","a",13,0,17,0,17]
[29095,"Фроленков П.С.","a",13,0,17,0,17]
[29349,"Сиротин.Р.С.","a",12,0,17,0,17]
[20297,"Иващенко С.В.","a",12,0,17,0,17]
[28609,"Бабкин А.И."]
[28608,"Прасолов С.В."]
[28666,"Погодин А.Н.","a",12,0,17,0,17]
[]
[]
["ИТОГО",null,{"$f":"COUNTIF(C5:C23,\"a\")","v":7},{"$f":"SUM(D5:D25)","v":88},0,120,0,120,{"$f":"SUM(I5:I25)","v":0},0]
[null,null,"А"]
["расчет выработки за одну смену"]
["наименование продукта: ",null,null,"мешки на палетах","биг-бег (метионин)","биг-бег (сульфат)","содовоз","отгрузка (тонн)"]
["общий тоннаж",null,null,88,null,120,null,120]
["выработка средняя",null,null,{"$f":"IFERROR(INT(D30/C26),0)","v":12},{"$f":"IFERROR(INT(E30/C26),0)","v":0},{"$f":"IFERROR(INT(F30/C26),0)","v":17},{"$f":"IFERROR(INT(G30/C26),0)","v":0},{"$f":"IFERROR(INT(H30/C26),0)","v":17}]
["остаток от равного распределения",null,null,{"$f":"D30-C26*D31","v":4},{"$f":"E30-C26*E31","v":0},{"$f":"F30-C26*F31","v":1},{"$f":"G30-C26*G31","v":0},{"$f":"H30-C26*H31","v":1}]
[]
["Фасовка с начала месяца:",null,null,{"$f":"D30","v":88},{"$f":"E30","v":0},120,0,120]