{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Табель на неделю"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Табель на неделю","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"merged":[[0,1,0,10],[2,2,2,7],[3,2,3,7],[4,2,4,7],[5,2,5,7],[6,2,6,7],[7,2,7,7],[8,2,8,7],[22,5,22,9],[23,5,23,9],[24,5,24,9],[25,5,25,9]]}
[null,"Табель на неделю"]
[null,"First Up Consultants "]
[null,"Почтовый адрес:","ул. Ласточкина, д. 111",{"$nulls":6},"Окончание недели:",{"$f":"TODAY()","v":"2023-05-12"}]
[null,"Адрес 2:"]
[null,"Адрес 3:",{"$nulls":7},"Сотрудник:","Павел Безруков"]
[null,"Город, почтовый индекс:","Мытищи, Московская область 654321",{"$nulls":6},"Руководитель:","Марта Артемьева"]
[null,"Телефон:","(415) 555-0123",{"$nulls":6},"Телефон сотрудника:","(202) 555-0111"]
[null,"Факс:","(415) 555-0124",{"$nulls":6},"Эл. почта сотрудника:","miguel@firstupconsultants.com"]
[null,"Эл. почта:","first@firstupconsultants.com",{"$nulls":6},"ИНН:",123456789]
[]
[null,"День","Приход","Уход","Приход ","Уход ","Обычные часы","Сверхурочные часы","Больничные часы","Отпускные часы","Итог"]
[null,"Понедельник","08:00:00","11:00:00","12:00:00","18:00:00",{"$f":"IFERROR(IF((((D12-C12)+(F12-E12))*24)>8,8,((D12-C12)+(F12-E12))*24), \"\")","v":{"v":8,"d":"8.00"}},{"$f":"IFERROR(IF(((D12-C12)+(F12-E12))*24>8,((D12-C12)+(F12-E12))*24-8,0), \"\")","v":{"v":1,"d":"1.00"}},null,null,{"$f":"IFERROR(SUM(G12:J12), \"\")","v":{"v":9,"d":"9.00"}}]
[null,"Вторник",{"$nulls":4},{"$f":"IFERROR(IF((((D13-C13)+(F13-E13))*24)>8,8,((D13-C13)+(F13-E13))*24), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(((D13-C13)+(F13-E13))*24>8,((D13-C13)+(F13-E13))*24-8,0), \"\")","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"}]
[null,"Среда",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"Четверг",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"Пятница",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"Суббота",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[null,"Воскресенье",{"$nulls":4},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"}]
[{"$nulls":5},"Общее количество часов",{"$f":"SUM(G12:G18)","v":{"v":8,"d":"8.00"}},{"$f":"SUM(H12:H18)","v":{"v":1,"d":"1.00"}},{"$f":"SUM(I12:I18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(J12:J18)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(ТабельУчетаРабочегоВремени[Итог])","v":{"v":9,"d":"9.00"}}]
[{"$nulls":5},"Почасовая ставка",{"v":20,"d":"20.00 ₽"},{"v":30,"d":"30.00 ₽"}]
[{"$nulls":5},"Всего к оплате",{"$f":"G19*G20","v":{"v":160,"d":"160.00 ₽"}},{"$f":"H19*H20","v":{"v":30,"d":"30.00 ₽"}},{"$f":"I19*I20","v":{"v":0,"d":"0.00 ₽"}},{"$f":"J19*J20","v":{"v":0,"d":"0.00 ₽"}},{"$f":"SUM(G21:J21)","v":{"v":190,"d":"190.00 ₽"}}]
[]
[]
[{"$nulls":5},"Подпись сотрудника",{"$nulls":4},"Дата"]
[]
[{"$nulls":5},"Подпись руководителя",{"$nulls":4},"Дата"]