{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Parte de horas anual"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Parte de horas anual","index":0,"n_rows":140,"n_cols":12,"rows_kept":140,"merged":[[0,1,1,11],[2,6,2,7],[2,8,2,9],[5,1,5,11],[39,1,39,11],[73,1,73,11],[107,1,107,11]]}
[null,"Tarjeta de horas trabajadas del empleado"]
[]
[null,"Nombre del empleado:",null,"Correo electrónico:",null,null,"Totales del año hasta la fecha:"]
[null,"Director:",null,"Teléfono:",null,null,"Horas normales:",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"Horas extra:",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"Total:",{"$f":"SUM(H4:J4)","v":0}]
[]
[null,"Enero, Febrero, Marzo      Tarjeta de horas trabajadas del empleado: diaria, semanal, mensual y anual"]
[null,"Enero","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Enero[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Enero[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Enero[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Enero[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Enero[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Enero[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Enero[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Enero[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Enero[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Enero[[Horas extra    ]])","v":0}]
[null,"Total de enero: Horas normales",{"$f":"SUM(Enero[[#Totals],[Semana 1]],Enero[[#Totals],[Semana 2]],Enero[[#Totals],[Semana 3]],Enero[[#Totals],[Semana 4]],Enero[[#Totals],[Semana 5]])","v":0},"Total de enero: Horas extra",null,{"$f":"SUM(Enero[[#Totals],[Horas extra]],Enero[[#Totals],[Horas extra ]],Enero[[#Totals],[Horas extra  ]],Enero[[#Totals],[Horas extra   ]],Enero[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Febrero","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Febrero[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Febrero[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Febrero[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Febrero[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Febrero[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Febrero[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Febrero[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Febrero[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Febrero[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Febrero[[Horas extra    ]])","v":0}]
[null,"Total de febrero: Horas normales",{"$f":"SUM(Febrero[[#Totals],[Semana 1]],Febrero[[#Totals],[Semana 2]],Febrero[[#Totals],[Semana 3]],Febrero[[#Totals],[Semana 4]],Febrero[[#Totals],[Semana 5]])","v":0},"Total de febrero: Horas extra",null,{"$f":"SUM(Febrero[[#Totals],[Horas extra]],Febrero[[#Totals],[Horas extra ]],Febrero[[#Totals],[Horas extra  ]],Febrero[[#Totals],[Horas extra   ]],Febrero[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Marzo","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Marzo[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Marzo[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Marzo[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Marzo[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Marzo[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Marzo[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Marzo[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Marzo[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Marzo[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Marzo[[Horas extra    ]])","v":0}]
[null,"Total de marzo: Horas normales",{"$f":"SUM(Marzo[[#Totals],[Semana 1]],Marzo[[#Totals],[Semana 2]],Marzo[[#Totals],[Semana 3]],Marzo[[#Totals],[Semana 4]],Marzo[[#Totals],[Semana 5]])","v":0},"Total de marzo: Horas extra",null,{"$f":"SUM(Marzo[[#Totals],[Horas extra]],Marzo[[#Totals],[Horas extra ]],Marzo[[#Totals],[Horas extra  ]],Marzo[[#Totals],[Horas extra   ]],Marzo[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Abril, Mayo, Junio      Tarjeta de horas trabajadas del empleado: diaria, semanal, mensual y anual"]
[null,"Abril","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Abril[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Abril[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Abril[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Abril[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Abril[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Abril[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Abril[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Abril[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Abril[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Abril[[Horas extra    ]])","v":0}]
[null,"Total de abril: Horas normales",{"$f":"SUM(Abril[[#Totals],[Semana 1]],Abril[[#Totals],[Semana 2]],Abril[[#Totals],[Semana 3]],Abril[[#Totals],[Semana 4]],Abril[[#Totals],[Semana 5]])","v":0},"Total de abril: Horas extra",null,{"$f":"SUM(Abril[[#Totals],[Horas extra]],Abril[[#Totals],[Horas extra ]],Abril[[#Totals],[Horas extra  ]],Abril[[#Totals],[Horas extra   ]],Abril[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Mayo","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Mayo[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Mayo[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Mayo[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Mayo[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Mayo[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Mayo[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Mayo[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Mayo[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Mayo[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Mayo[[Horas extra    ]])","v":0}]
[null,"Total de mayo: Horas normales",{"$f":"SUM(Mayo[[#Totals],[Semana 1]],Mayo[[#Totals],[Semana 2]],Mayo[[#Totals],[Semana 3]],Mayo[[#Totals],[Semana 4]],Mayo[[#Totals],[Semana 5]])","v":0},"Total de mayo: Horas extra",null,{"$f":"SUM(Mayo[[#Totals],[Horas extra]],Mayo[[#Totals],[Horas extra ]],Mayo[[#Totals],[Horas extra  ]],Mayo[[#Totals],[Horas extra   ]],Mayo[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Junio","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Junio[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Junio[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Junio[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Junio[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Junio[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Junio[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Junio[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Junio[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Junio[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Junio[[Horas extra    ]])","v":0}]
[null,"Total de junio: Horas normales",{"$f":"SUM(Junio[[#Totals],[Semana 1]],Junio[[#Totals],[Semana 2]],Junio[[#Totals],[Semana 3]],Junio[[#Totals],[Semana 4]],Junio[[#Totals],[Semana 5]])","v":0},"Total de junio: Horas extra",null,{"$f":"SUM(Junio[[#Totals],[Horas extra]],Junio[[#Totals],[Horas extra ]],Junio[[#Totals],[Horas extra  ]],Junio[[#Totals],[Horas extra   ]],Junio[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Julio, Agosto, Septiembre      Tarjeta de horas trabajadas del empleado: diaria, semanal, mensual y anual"]
[null,"Julio","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Julio[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Julio[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Julio[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Julio[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Julio[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Julio[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Julio[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Julio[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Julio[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Julio[[Horas extra    ]])","v":0}]
[null,"Total de julio: Horas normales",{"$f":"SUM(Julio[[#Totals],[Semana 1]],Julio[[#Totals],[Semana 2]],Julio[[#Totals],[Semana 3]],Julio[[#Totals],[Semana 4]],Julio[[#Totals],[Semana 5]])","v":0},"Total de julio: Horas extra",null,{"$f":"SUM(Julio[[#Totals],[Horas extra]],Julio[[#Totals],[Horas extra ]],Julio[[#Totals],[Horas extra  ]],Julio[[#Totals],[Horas extra   ]],Julio[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Agosto","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Agosto[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Agosto[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Agosto[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Agosto[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Agosto[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Agosto[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Agosto[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Agosto[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Agosto[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Agosto[[Horas extra    ]])","v":0}]
[null,"Total de agosto: Horas normales",{"$f":"SUM(Agosto[[#Totals],[Semana 1]],Agosto[[#Totals],[Semana 2]],Agosto[[#Totals],[Semana 3]],Agosto[[#Totals],[Semana 4]],Agosto[[#Totals],[Semana 5]])","v":0},"Total de agosto: Horas extra",null,{"$f":"SUM(Agosto[[#Totals],[Horas extra]],Agosto[[#Totals],[Horas extra ]],Agosto[[#Totals],[Horas extra  ]],Agosto[[#Totals],[Horas extra   ]],Agosto[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Septiembre","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Septiembre[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Septiembre[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Septiembre[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Septiembre[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Septiembre[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Septiembre[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Septiembre[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Septiembre[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Septiembre[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Septiembre[[Horas extra    ]])","v":0}]
[null,"Total de septiembre: Horas normales",{"$f":"SUM(Septiembre[[#Totals],[Semana 1]],Septiembre[[#Totals],[Semana 2]],Septiembre[[#Totals],[Semana 3]],Septiembre[[#Totals],[Semana 4]],Septiembre[[#Totals],[Semana 5]])","v":0},"Total de septiembre: Horas extra",null,{"$f":"SUM(Septiembre[[#Totals],[Horas extra]],Septiembre[[#Totals],[Horas extra ]],Septiembre[[#Totals],[Horas extra  ]],Septiembre[[#Totals],[Horas extra   ]],Septiembre[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Octubre, Noviembre, Diciembre      Tarjeta de horas trabajadas del empleado: diaria, semanal, mensual y anual"]
[null,"Octubre","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Octubre[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Octubre[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Octubre[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Octubre[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Octubre[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Octubre[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Octubre[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Octubre[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Octubre[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Octubre[[Horas extra    ]])","v":0}]
[null,"Total de octubre: Horas normales",{"$f":"SUM(Octubre[[#Totals],[Semana 1]],Octubre[[#Totals],[Semana 2]],Octubre[[#Totals],[Semana 3]],Octubre[[#Totals],[Semana 4]],Octubre[[#Totals],[Semana 5]])","v":0},"Total de octubre: Horas extra",null,{"$f":"SUM(Octubre[[#Totals],[Horas extra]],Octubre[[#Totals],[Horas extra ]],Octubre[[#Totals],[Horas extra  ]],Octubre[[#Totals],[Horas extra   ]],Octubre[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Noviembre","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Noviembre[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Noviembre[Horas extra])","v":0},{"$f":"SUBTOTAL(109,Noviembre[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Noviembre[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Noviembre[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Noviembre[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Noviembre[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Noviembre[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Noviembre[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Noviembre[[Horas extra    ]])","v":0}]
[null,"Total de noviembre: Horas normales",{"$f":"SUM(Noviembre[[#Totals],[Semana 1]],Noviembre[[#Totals],[Semana 2]],Noviembre[[#Totals],[Semana 3]],Noviembre[[#Totals],[Semana 4]],Noviembre[[#Totals],[Semana 5]])","v":0},"Total de noviembre: Horas extra",null,{"$f":"SUM(Noviembre[[#Totals],[Horas extra]],Noviembre[[#Totals],[Horas extra ]],Noviembre[[#Totals],[Horas extra  ]],Noviembre[[#Totals],[Horas extra   ]],Noviembre[[#Totals],[Horas extra    ]])","v":0}]
[]
[null,"Diciembre","Semana 1","Horas extra","Semana 2","Horas extra ","Semana 3","Horas extra  ","Semana 4","Horas extra   ","Semana 5","Horas extra    "]
[null,"Lunes"]
[null,"Martes"]
[null,"Miércoles"]
[null,"Jueves"]
[null,"Viernes"]
[null,"Sábado"]
[null,"Domingo"]
[null,"Total semanal de horas",{"$f":"SUBTOTAL(109,Diciembre[Semana 1])","v":0},{"$f":"SUBTOTAL(109,Diciembre[Horas extra])","v":0},{"$f":"SUBTOTAL(105,Diciembre[Semana 2])","v":0},{"$f":"SUBTOTAL(109,Diciembre[[Horas extra ]])","v":0},{"$f":"SUBTOTAL(109,Diciembre[Semana 3])","v":0},{"$f":"SUBTOTAL(109,Diciembre[[Horas extra  ]])","v":0},{"$f":"SUBTOTAL(109,Diciembre[Semana 4])","v":0},{"$f":"SUBTOTAL(109,Diciembre[[Horas extra   ]])","v":0},{"$f":"SUBTOTAL(109,Diciembre[Semana 5])","v":0},{"$f":"SUBTOTAL(109,Diciembre[[Horas extra    ]])","v":0}]
[null,"Total de diciembre: Horas normales",{"$f":"SUM(Diciembre[[#Totals],[Semana 1]],Diciembre[[#Totals],[Semana 2]],Diciembre[[#Totals],[Semana 3]],Diciembre[[#Totals],[Semana 4]],Diciembre[[#Totals],[Semana 5]])","v":0},"Total de diciembre: Horas extra",null,{"$f":"SUM(Diciembre[[#Totals],[Horas extra]],Diciembre[[#Totals],[Horas extra ]],Diciembre[[#Totals],[Horas extra  ]],Diciembre[[#Totals],[Horas extra   ]],Diciembre[[#Totals],[Horas extra    ]])","v":0}]