{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Наряд на сдельные работы","ФИО работников","Расценка"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,5],[3,1,3,2],[3,7,3,8],[3,3,3,5],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[5,4,5,5],[31,1,31,3],[31,4,31,5],[32,1,32,3],[32,4,32,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[30,4,30,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[30,1,30,3],[33,1,33,3],[33,4,33,5],[34,1,34,3],[34,4,34,5],[35,1,35,3],[35,4,35,5],[40,1,40,3],[40,4,40,5],[41,1,41,3],[41,4,41,5],[36,1,36,3],[36,4,36,5],[37,1,37,3],[37,4,37,5],[38,1,38,3],[38,4,38,5],[48,1,48,2],[1,6,1,7],[45,1,45,3],[45,4,45,5],[46,1,46,3],[46,4,46,5],[47,1,47,3],[47,4,47,5],[42,1,42,3],[42,4,42,5],[43,1,43,3],[43,4,43,5],[44,1,44,3],[44,4,44,5],[39,1,39,3],[39,4,39,5]]}
[null,"Осиповичский филиал"]
[null,"СП  \" МИЗ МедБелРос\" ООО",null,null,null,null,"Количество дней",null,30]
[null,"Наряд на сдельные работы за",null,null,null,null,"октябрь",2013,"год"]
[null,"Фамилия     И.О.",null,"Барышникова Т.В.",null,null,"профессия","укладчик-упаковщик"]
[]
["Дата","Наименование выполненных работ",null,null,"Единица измерения",null,"Выработано годных","Расценка         за единицу продукции","Сумма к оплате"]
["2013-01-01","№15 интим влажные салф",null,null,"шт",null,300,{"$f":"VLOOKUP(B7,Расценка!A:E,5,)","v":30},{"$f":"G7*H7","v":9000}]
["2013-10-02","упаковка скальпель №10, 11",null,null,"шт",null,900,{"$f":"VLOOKUP(B8,Расценка!A:E,5,)","v":{"$error":"#N/A"}},{"$f":"G8*H8","v":{"$error":"#N/A"}}]
["2013-10-03","простой",null,null,"час",null,2,{"$f":"VLOOKUP(B9,Расценка!A:E,5,)","v":8340},16680]
["2013-10-04","№20",null,null,"шт",null,320,{"$f":"VLOOKUP(B10,Расценка!A:E,5,)","v":30},9600]
["2013-10-05","Упаковка лезвий скальпелей",null,null,"шт",null,1000,{"$f":"VLOOKUP(B11,Расценка!A:E,5,)","v":15},15000]
["октяб",null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"G13*H13","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"G46*H46","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G47*H47","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"G48*H48","v":0}]
[null,null,null,null,null,null,null,"Итого:",{"$f":"SUM(I7:I48)","v":{"$error":"#N/A"}}]
[null,"Расчет составил:"]

{"sheet":"ФИО работников","index":1,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
[null,"Перечень работников Ф.И.О."]
[null,null,null,"среднемесячный",null,null,"простой"]
[1,"Барышникова Т.В.","укладчик-упаковщик",null,"январь"]
[{"$f":"A3+1","v":2},"Зайцева Е.Н.","укладчик-упаковщик",null,"февраль"]
[3,"Александрович В.А.","укладчик-упаковщик",null,"март"]
[4,"Гринько Н.Г","укладчик-упаковщик",null,"апрель"]
[5,"Анисимова О.В.","укладчик-упаковщик",null,"май"]
[6,"Касперович Т.С.","укладчик-упаковщик",null,"июнь"]
[7,"Хаткевич М.С.","укладчик-упаковщик",null,"июль"]
[8,"Гончарёнок М.А.","укладчик-упаковщик",null,"август"]
[9,"Ханевич О.П.","укладчик-упаковщик",null,"сентябь"]
[10,"Золкина Д.Н.","укладчик-упаковщик",null,"октябрь"]
[11,"Довнар С.М.","мойщик",null,"ноябрь"]
[null,null,null,null,"декабрь"]

{"sheet":"Расценка","index":2,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,2013,2014,null,2015,2016,2017]
["                                          Перечень работ",null,null,null,"расценка"]
["Освежаюшие №15",null,null,null,30,null,"шт"]
["№15 интим влажные салф",null,null,null,30,null,"кг"]
["№15 освежающие лимон",null,null,null,30,null,"час"]
["№20 череда и В5 ",null,null,null,30,null,"упак"]
["№20 зеленый чай",null,null,null,30]
["Освежаюшие №15",null,null,null,30]
["№15 интим влажные салф",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["№20 детские",null,null,null,30]
["№20",null,null,null,30]
["Освежаюшие №15",null,null,null,30]
["№15 интим влажные салф",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["Освежаюшие №15",null,null,null,30]
["№15 интим влажные салф",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["№20 детские",null,null,null,30]
["№20",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["№20 детские",null,null,null,30]
["№20",null,null,null,30]
["Освежаюшие №15",null,null,null,30]
["№15 интим влажные салф",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["Освежаюшие №15",null,null,null,30]
["№15 интим влажные салф",null,null,null,30]
["№15 освежающие лимон",null,null,null,30]
["№20 череда и В5 ",null,null,null,30]
["№20 зеленый чай",null,null,null,30]
["№20 детские",null,null,null,30]
["№20",null,null,null,30]
["№25",null,null,null,42]
["№28",null,null,null,42]
["№32",null,null,null,42]
["№38",null,null,null,42]
["№38-B",null,null,null,42]
["№38-N",null,null,null,50]
["№38-BN",null,null,null,50]
["Упаковка спирт. салфеток",null,null,"1 час",15000]
["Упаковка лезвий скальпелей",null,null,"1 шт",15]
["мойка скарификаторов",null,null,"1 час",15000]
["простой",null,null,"1 час",8340]
["упаковка скарификаторов",null,null,"1 шт",6.2]
["уборка  ( по среднему)",null,null,null,8340]
["упаковка скальпель №10",null,null,null,35]
["упаковка скальпель №11",null,null,null,35]
["упаковка скальпель №12",null,null,null,35]
["упаковка скальпель №12Д",null,null,null,35]
["упаковка скальпель №13",null,null,null,35]
["упаковка скальпель №15",null,null,null,41]
["упаковка скальпель №18",null,null,null,34]
["упаковка скальпель №19",null,null,null,34]
["упаковка скальпель №20",null,null,null,34]
["упаковка скальпель №21",null,null,null,34]
["упаковка скальпель №22",null,null,null,34]
["упаковка скальпель №23",null,null,null,34]
["упаковка скальпель №24",null,null,null,34]
["упаковка скальпель №25",null,null,null,34]
["упаковка скальпель №10",null,null,null,34]
["упаковка скальпель №10,11",null,null,null,34]
["упаковка скальпель №11,12,13",null,null,null,34]
["упаковка скальпель №12,12Д",null,null,null,34]
["упаковка скальпель №12Д,13",null,null,null,34]
["упаковка скальпель №13,15",null,null,null,35]
["упаковка скальпель №15,18",null,null,null,35]
["упаковка скальпель №18,19,20",null,null,null,35]
["упаковка скальпель №19,20,21",null,null,null,35]
["упаковка скальпель №20,21,22",null,null,null,35]
["упаковка скальпель №21,22,23",null,null,null,35]
["упаковка скальпель №22,23",null,null,null,35]
["упаковка скальпель №23,24",null,null,null,35]
["упаковка скальпель №23,24,25",null,null,null,35]
["упаковка скальпель №25,11",null,null,null,35]
["упаковка скальпель №10,24,25",null,null,null,35]