{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Табель учета рабочего времен..."],"not_rendered":{"external_links":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Табель учета рабочего времен...","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"merged":[[0,1,0,7],[2,2,2,3],[2,6,2,7],[3,2,3,3],[3,6,3,7],[4,2,4,3],[5,2,5,3],[5,6,5,7],[6,2,6,3],[6,6,6,7],[26,3,26,6],[27,3,27,6],[28,3,28,6],[29,3,29,6]]}
[null,"Табель учета рабочего времени на две недели"]
[null,"Название компании"]
[null,"Почтовый адрес",{"$nulls":3},"Дата начала платежного периода:",{"$f":"TODAY()","v":"2017-08-15"}]
[null,"Вторая строка адреса",{"$nulls":3},"Дата окончания платежного периода:",{"$f":"IFERROR(IF($G$3=\"\",\"\",$G$3+13), \"\")","v":"2017-08-28"}]
[null,"Город, регион, почтовый индекс"]
[null,"Сотрудник:",{"$nulls":3},"Телефон сотрудника:"]
[null,"Руководитель:",{"$nulls":3},"Электронный адрес сотрудника:"]
[]
[null,"День недели","Дата","Обычные часы","Сверхурочные часы","Больничный","Отпуск","Итого"]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"вторник"},{"$f":"G3","v":"2017-08-15"},{"$nulls":4},{"$f":"IFERROR(SUM(D10:G10), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"среда"},{"$f":"IF($G$3=\"\",\"\",$G$3+1)","v":"2017-08-16"},{"$nulls":4},{"$f":"IFERROR(SUM(D11:G11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"четверг"},{"$f":"IF($G$3=\"\",\"\",$G$3+2)","v":"2017-08-17"},{"$nulls":4},{"$f":"IFERROR(SUM(D12:G12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"пятница"},{"$f":"IF($G$3=\"\",\"\",$G$3+3)","v":"2017-08-18"},{"$nulls":4},{"$f":"IFERROR(SUM(D13:G13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"суббота"},{"$f":"IF($G$3=\"\",\"\",$G$3+4)","v":"2017-08-19"},{"$nulls":4},{"$f":"IFERROR(SUM(D14:G14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"воскресенье"},{"$f":"IF($G$3=\"\",\"\",$G$3+5)","v":"2017-08-20"},{"$nulls":4},{"$f":"IFERROR(SUM(D15:G15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"понедельник"},{"$f":"IF($G$3=\"\",\"\",$G$3+6)","v":"2017-08-21"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"вторник"},{"$f":"IF($G$3=\"\",\"\",$G$3+7)","v":"2017-08-22"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"среда"},{"$f":"IF($G$3=\"\",\"\",$G$3+8)","v":"2017-08-23"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"четверг"},{"$f":"IF($G$3=\"\",\"\",$G$3+9)","v":"2017-08-24"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"пятница"},{"$f":"IF($G$3=\"\",\"\",$G$3+10)","v":"2017-08-25"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"суббота"},{"$f":"IF($G$3=\"\",\"\",$G$3+11)","v":"2017-08-26"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"воскресенье"},{"$f":"IF($G$3=\"\",\"\",$G$3+12)","v":"2017-08-27"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,{"$f":"IFERROR(TEXT(ТабельУчетаРабочегоВремени[[#This Row],[Дата]],\"aaaa\"), \"\")","v":"понедельник"},{"$f":"IF($G$3=\"\",\"\",$G$3+13)","v":"2017-08-28"},{"$nulls":4},{"v":0,"d":"0.00"}]
[null,null,"Всего часов",{"$f":"IFERROR(SUM(D10:D23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(E10:E23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(F10:F23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(G10:G23), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(H10:H23), \"\")","v":{"v":0,"d":"0.00"}}]
[null,null,"Почасовая ставка"]
[null,null,"Всего к оплате",{"$f":"IFERROR(D24*D25, \"\")","v":{"v":0,"d":"0 ₽"}},{"$f":"IFERROR(E24*E25, \"\")","v":{"v":0,"d":"0 ₽"}},{"$f":"IFERROR(F24*F25, \"\")","v":{"v":0,"d":"0 ₽"}},{"$f":"IFERROR(G24*G25, \"\")","v":{"v":0,"d":"0 ₽"}},{"$f":"IFERROR(SUM(D26:G26), \"\")","v":{"v":0,"d":"0 ₽"}}]
[]
[{"$nulls":3},"Подпись сотрудника",{"$nulls":3},"Дата"]
[]
[{"$nulls":3},"Подпись руководителя",{"$nulls":3},"Дата"]