{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"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":"Лист1","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,2],[2,9,3,9],[25,0,25,1],[27,0,27,7],[28,0,28,2],[29,0,29,2],[30,0,30,2],[0,0,0,7],[0,8,1,9],[1,0,2,0],[1,1,2,1],[1,2,3,2],[1,3,1,6],[2,3,2,4],[2,5,2,6],[2,7,3,7],[2,8,3,8]]}
["Расчет сменной выработки",null,null,null,null,null,null,null,"Прочее"]
["Дата выработки",null,"1-если присутствует на работе","фасовка продукта",null,null,null,"отгрузка"]
[null,null,null,"метионин кормовой",null,"сульфат натрия",null,"палет т.               Биг-бег т.","этикетки","поддоны"]
["таб. Номер","Ф.И.О.",null,"мешки на палетах","биг-бег","биг-бег п\\п","содовоз"]
[27540,"Пичугин О.В.","a"]
[28494,"Алексеев А.П.","a"]
[27814,"Антюфеев А.Л."]
[192,"Козлов Б.Н.","a"]
[24227,"Кокоришев В.И."]
[27206,"Битюцкий В.Н.","a"]
[28649,"Змиевский Г.П."]
[null,"Панченко Р.Н.","a"]
[28644,"Никитин А.А.","a"]
[]
[28976,"Карпенко А.А."]
[27775,"Пирматов З.А."]
[577,"Калинин.И.В."]
[24851,"Перепелкин В.И."]
[null,"Сиротин.Р.С."]
[20297,"Иващенко С.В."]
[28609,"Бабкин А.И."]
[28608,"Прасолов С.В."]
[28666,"Погодин А.Н."]
[]
[]
["ИТОГО",null,6,{"$f":"SUM(D5:D25)","v":0},0,0,0,0]
[null,null,"Б"]
["расчет выработки за одну смену"]
["наименование продукта: ",null,null,"мешки на палетах","биг-бег (метионин)","биг-бег (сульфат)","содовоз","отгрузка (тонн)"]
["общий тоннаж",null,null,125,40,80,21.23,100]
["выработка средняя",null,null,{"$f":"IFERROR(INT(D30/C26),0)","v":20},{"$f":"IFERROR(INT(E30/C26),0)","v":6},{"$f":"IFERROR(INT(F30/C26),0)","v":13},{"$f":"IFERROR(INT(G30/C26),0)","v":3},{"$f":"IFERROR(INT(H30/C26),0)","v":16}]
["остаток от равного распределения",null,null,{"$f":"D30-C26*D31","v":5},{"$f":"E30-C26*E31","v":4},{"$f":"F30-C26*F31","v":2},{"$f":"G30-C26*G31","v":3.2300000000000004},{"$f":"H30-C26*H31","v":4}]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}