{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ЗА март 2019 Г "],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"ЗА март 2019 Г ","index":0,"n_rows":28,"n_cols":40,"rows_kept":28,"cut":false,"hidden":false,"merged":[[4,3,4,18],[1,3,1,18],[1,27,1,30],[2,3,3,21],[2,27,2,37],[3,27,3,36],[26,16,26,21],[8,1,8,5],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,37],[22,16,22,21],[22,22,22,35],[23,16,23,21],[24,16,24,21],[25,16,25,21]]}
[]
[null,null,null,"График работы сотрудников ГАУЗ детской городской  больницы г Магнитогорск",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Утверждаю"]
[null,null,null,"Структурное подразделение_____Отделение  анестезиологии-реанимации хирургии ________",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Главный врач__________________________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"М. В. Шеметова"]
[null,null,null,"за ____март____ 2019г."]
[]
["№п-п","Фамилия, имя, отчество                      ","Должность (профессия)","норма часов","подпись сотрудника","Числа месяца",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"вот так надо","а вот как считает"]
[null,null,null,null,null,"рабочая смена ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"итого отработанных дней","итого отработанных часов"]
[null,"ВРАЧИ:",null,null,null,null,"пт","сб","вс","пн","вт","ср","чт","пт","сб","вс","пн","вт","ср","чт","пт","сб","вс","пн","вт","ср","чт","пт","сб","вс","пн","вт","ср","чт","пт","сб","вс"]
[1,null,"Зав. отд.",143,null,"7 ч","08.00-15.00",null,null,"08.00-15.00","08.00-15.00","08.00-15.30","08.00-15.00",null,null,null,"08.00-15.00","08.00-15.30","08.00-15.30","08.00-15.00","08.00-15.00",null,null,"08.00-15.00","08.00-15.30","08.00-15.00","08.00-15.30","08.00-15.00",null,null,"08.00-15.00","08.00-15.00","08.00-15.30","08.00-15.00","08.00-15.00",null,null,{"$f":"COUNTA(G10:AK10)","v":20},143,{"$f":"SUM(IF(ISBLANK(G10:AK10),,RIGHTB(SUBSTITUTE(G10:AK10,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G10:AK10,\".\",\":\"),5)+(LEFTB(G10:AK10,2)-MID(G10:AK10,7,2)>0)+(LEFTB(G10:AK10,5)=RIGHTB(G10:AK10,5))))","v":5.9583333333333348}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"17 ч",null,"08.00-08.00",null,null,null,null,"15.00-08.00",null,null,"08.00-08.00",null,null,null,"15.00-08.00",null,null,null,null,null,"15.00-08.00",null,null,null,"08.00-08.00",null,null,null,null,null,null,null,6,123,{"$f":"SUM(IF(ISBLANK(G11:AK11),,RIGHTB(SUBSTITUTE(G11:AK11,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G11:AK11,\".\",\":\"),5)+(LEFTB(G11:AK11,2)-MID(G11:AK11,7,2)>0)+(LEFTB(G11:AK11,5)=RIGHTB(G11:AK11,5))))","v":5.1249999999999991}]
[2,null,"Вр. а/р",143,null,"12 ч",null,"08.00-08.00",null,"08.00-20.00",null,"08.00-20.00",null,null,null,"08.00-08.00",null,null,"08.00-19.00",null,null,null,null,"08.00-20.00",null,"08.00-20.00",null,"08.00-20.00",null,null,null,"08.00-20.00",null,null,"08.00-20.00",null,null,10,143,{"$f":"SUM(IF(ISBLANK(G12:AK12),,RIGHTB(SUBSTITUTE(G12:AK12,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G12:AK12,\".\",\":\"),5)+(LEFTB(G12:AK12,2)-MID(G12:AK12,7,2)>0)+(LEFTB(G12:AK12,5)=RIGHTB(G12:AK12,5))))","v":5.9583333333333339}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"12 ч",null,null,null,"20.00-08.00",null,"20.00-08.00",null,"08.00-08.00",null,null,null,null,"19.00-08.00",null,null,"08.00-08.00",null,"20.00-08.00",null,"20.00-08.00",null,"20.00-08.00",null,"08.00-08.00",null,"20.00-08.00",null,null,"20.00-08.00",null,"08.00-08.00",12,193,{"$f":"SUM(IF(ISBLANK(G13:AK13),,RIGHTB(SUBSTITUTE(G13:AK13,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G13:AK13,\".\",\":\"),5)+(LEFTB(G13:AK13,2)-MID(G13:AK13,7,2)>0)+(LEFTB(G13:AK13,5)=RIGHTB(G13:AK13,5))))","v":8.0416666666666679}]
[3,null,"Вр. а/р",143,null,"12 ч",null,null,"08.00-08.00",null,"08.00-20.00",null,null,null,"08.00-08.00",null,null,"08.00-20.00",null,null,"08.00-20.00",null,"08.00-08.00",null,null,null,null,"08.00-19.00",null,null,"08.00-20.00",null,null,"08.00-20.00",null,null,null,9,143,{"$f":"SUM(IF(ISBLANK(G14:AK14),,RIGHTB(SUBSTITUTE(G14:AK14,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G14:AK14,\".\",\":\"),5)+(LEFTB(G14:AK14,2)-MID(G14:AK14,7,2)>0)+(LEFTB(G14:AK14,5)=RIGHTB(G14:AK14,5))))","v":5.958333333333333}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"12 ч",null,null,null,null,"20.00-08.00",null,null,null,null,null,null,"20.00-08.00",null,null,"20.00-08.00",null,null,null,"08.00-08.00",null,null,"19.00-08.00",null,null,"20.00-08.00",null,null,"20.00-08.00",null,"08.00-08.00",null,8,121,{"$f":"SUM(IF(ISBLANK(G15:AK15),,RIGHTB(SUBSTITUTE(G15:AK15,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G15:AK15,\".\",\":\"),5)+(LEFTB(G15:AK15,2)-MID(G15:AK15,7,2)>0)+(LEFTB(G15:AK15,5)=RIGHTB(G15:AK15,5))))","v":5.041666666666667}]
[4,null,"Вр. а/р",143,null,"12 ч","08.00-15.00",null,null,"08.00-20.00","08.00-15.00","08.00-20.00","08.00-15.00",null,null,null,"08.00-20.00",null,null,"08.00-15.00","08.00-15.00",null,null,"08.00-15.00","08.00-11.00",null,null,null,null,null,null,null,null,null,null,null,null,null,143,{"$f":"SUM(IF(ISBLANK(G16:AK16),,RIGHTB(SUBSTITUTE(G16:AK16,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G16:AK16,\".\",\":\"),5)+(LEFTB(G16:AK16,2)-MID(G16:AK16,7,2)>0)+(LEFTB(G16:AK16,5)=RIGHTB(G16:AK16,5))))","v":3.3749999999999996}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"12 ч",null,null,null,"20.00-08.00",null,"20.00-08.00",null,"08.00-08.00",null,null,"20.00-08.00",null,"08.00-08.00",null,null,"08.00-08.00",null,null,"11.00-08.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G17:AK17),,RIGHTB(SUBSTITUTE(G17:AK17,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G17:AK17,\".\",\":\"),5)+(LEFTB(G17:AK17,2)-MID(G17:AK17,7,2)>0)+(LEFTB(G17:AK17,5)=RIGHTB(G17:AK17,5))))","v":5.375}]
[5,null,"Вр. а/р",143,null,"12 ч",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G18:AK18),,RIGHTB(SUBSTITUTE(G18:AK18,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G18:AK18,\".\",\":\"),5)+(LEFTB(G18:AK18,2)-MID(G18:AK18,7,2)>0)+(LEFTB(G18:AK18,5)=RIGHTB(G18:AK18,5))))","v":0}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"12 ч",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G19:AK19),,RIGHTB(SUBSTITUTE(G19:AK19,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G19:AK19,\".\",\":\"),5)+(LEFTB(G19:AK19,2)-MID(G19:AK19,7,2)>0)+(LEFTB(G19:AK19,5)=RIGHTB(G19:AK19,5))))","v":0}]
[6,null,"Вр.а/р ",143,null,"17 ч",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G20:AK20),,RIGHTB(SUBSTITUTE(G20:AK20,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G20:AK20,\".\",\":\"),5)+(LEFTB(G20:AK20,2)-MID(G20:AK20,7,2)>0)+(LEFTB(G20:AK20,5)=RIGHTB(G20:AK20,5))))","v":0}]
[null,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"17 ч",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G21:AK21),,RIGHTB(SUBSTITUTE(G21:AK21,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G21:AK21,\".\",\":\"),5)+(LEFTB(G21:AK21,2)-MID(G21:AK21,7,2)>0)+(LEFTB(G21:AK21,5)=RIGHTB(G21:AK21,5))))","v":0}]
[7,null,"Вр.а/р сов",{"$f":"143/2","v":71.5},null,"17 ч",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IF(ISBLANK(G22:AK22),,RIGHTB(SUBSTITUTE(G22:AK22,\".\",\":\"),5)-LEFTB(SUBSTITUTE(G22:AK22,\".\",\":\"),5)+(LEFTB(G22:AK22,2)-MID(G22:AK22,7,2)>0)+(LEFTB(G22:AK22,5)=RIGHTB(G22:AK22,5))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Профком:___________________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Зав отделением:___________________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ст м/с:___________________"]
[null,null,null,null,null,"                                                                                                                               ",null,null,null,null,null,null,null,null,null,null,"Главная  м/с: ________________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Экономист: _________________"]
[null,null,null,null,null,"                                                                                                                                                "]