{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Registro de horas semanal"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Registro de horas semanal","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,1,2,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,3,5,4],[5,7,5,8],[6,3,6,4],[6,7,6,8],[7,3,7,4],[7,7,7,8],[21,1,21,6],[21,7,21,8],[22,1,22,6],[22,7,22,8],[23,1,23,6],[23,7,23,8],[24,1,24,6],[24,7,24,8]]}
[]
[]
[null,"REGISTRO DE HORAS SEMANAL"]
[null,"DISEÑO MODERNO CO"]
[]
[null,"EMPLEADO:",null,"Miguel Reyes",null,null,"TELÉFONO DEL EMPLEADO:","(805) 555-0123"]
[null,"DIRECTOR:",null,"Jyeshta Davgar",null,null,"CORREO ELECTRÓNICO DEL EMPLEADO:","miguel@example.com"]
[{"$nulls":6},"FIN DE SEMANA:",{"$f":"TODAY()","v":"2023-03-24"}]
[]
[null,"DÍA"," ","FECHA","HORAS NORMALES","HORAS EXTRAS","ENFERMO","VACACIONES","TOTAL"]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"sábado"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-6), \"\")","v":"2023-03-18"},{"$nulls":4},{"$f":"IFERROR(SUM(E11:H11), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"domingo"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-5), \"\")","v":"2023-03-19"},{"$nulls":4},{"$f":"IFERROR(SUM(E12:H12), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"lunes"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-4), \"\")","v":"2023-03-20"},{"$nulls":4},{"$f":"IFERROR(SUM(E13:H13), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"martes"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-3), \"\")","v":"2023-03-21"},{"$nulls":4},{"$f":"IFERROR(SUM(E14:H14), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"miércoles"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-2), \"\")","v":"2023-03-22"},{"$nulls":4},{"$f":"IFERROR(SUM(E15:H15), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"jueves"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8-1), \"\")","v":"2023-03-23"},{"$nulls":4},{"$f":"IFERROR(SUM(E16:H16), \"\")","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IFERROR(TEXT(PlanillaHorasTrabajadas[[#This Row],[FECHA]],\"dddd\"), \"\")","v":"viernes"},null,{"$f":"IFERROR(IF($H$8=0,\"\",$H$8), \"\")","v":"2023-03-24"},{"$nulls":4},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TOTAL DE HORAS",{"$f":"IFERROR(SUM(PlanillaHorasTrabajadas[HORAS NORMALES]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(PlanillaHorasTrabajadas[HORAS EXTRAS]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(PlanillaHorasTrabajadas[ENFERMO]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(PlanillaHorasTrabajadas[VACACIONES]), \"\")","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(SUM(PlanillaHorasTrabajadas[TOTAL]), \"\")","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TARIFA POR HORA"]
[{"$nulls":3},"SALARIO TOTAL",{"$f":"IFERROR(E18*E19, \"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(F18*F19, \"\")","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[]
[]
[null,"FIRMA DE EMPLEADO",{"$nulls":5},"FECHA"]
[]
[null,"FIRMA DEL DIRECTOR",{"$nulls":5},"FECHA"]