{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Datos_Jornada_Libre","Datos_Jornada_Asistente","Datos_Trabajadores","Datos_Empresa","Datos_Generales","Instrucciones"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Datos_Jornada_Libre","index":0,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[[10,19,10,25],[12,19,12,21],[13,19,13,21],[5,1,5,2],[5,3,5,4],[5,6,5,8],[6,0,7,1],[0,0,0,8],[1,0,1,4],[2,0,2,4],[3,1,3,4],[4,1,4,4],[2,6,2,8],[3,6,3,8],[4,6,4,8],[1,5,1,8],[43,6,43,8],[43,2,43,4],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,2,6,3],[6,4,6,5],[40,1,41,8]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO"]
["EMPRESA",null,null,null,null,"TRABAJADOR"]
[{"$f":"Datos_Empresa!B3","v":"Empresa Prueba"},null,null,null,null,"Nombre:","ROMERO MALLENT, RAFAEL",null,null,null,null,null,"Primer dia del mes",{"$f":"CONCATENATE(\"01/\",D6,\"/\",Datos_Generales!A2)","v":"01/Enero/2017"}]
["CIF:",{"$f":"Datos_Empresa!B4","v":"B123456789"},null,null,null,"NIF:",{"$f":"VLOOKUP(G3,Datos_Trabajadores!A2:F29,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,"Cardinal Mes",{"$f":"MONTH(N3)","v":1}]
["C.C.C.:",{"$f":"Datos_Empresa!B5","v":"28/12345678-00"},null,null,null,"NAF:",{"$f":"VLOOKUP(G3,Datos_Trabajadores!A2:F29,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,"Ultimo día del mes",{"$f":"CONCATENATE(1,\"/\",N4+1,\"/\",Datos_Generales!A2)-1","v":"2017-01-31"}]
[null,"Período de liquidación:",null,"Enero",null,"Fecha:",{"$f":"N5","v":"2017-01-31"}]
["Día del mes",null,"Horario Mañana",null,"Hora Tarde",null,"Total Horas\nJornada","Horas\nOrdinarias","Horas\nExtras"]
[null,null,"Inicio","Fin","Inicio","Fin",null,null,null,null,null,null,"Día del Mes","Dia Mes completo","Diferencia Dias","Es día no valido","Dias de la semana"]
[{"$f":"IF(P9,\" \",M9)","v":1},{"$f":"Q9","v":"1900-01-01"},null,null,null,null,{"$f":"D9-C9+F9-E9","v":"00:00:00"},{"$f":"G9","v":"00:00:00"},null,null,null,null,1,{"$f":"CONCATENATE(M9,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"1/1/2017"},{"$f":"$N$5-N9","v":30},{"$f":"ISERROR(O9)","v":false},{"$f":"IF(P9,\" \",WEEKDAY(N9))","v":"1900-01-01"}]
[{"$f":"IF(P10,\" \",M10)","v":2},{"$f":"Q10","v":"1900-01-02"},null,null,null,null,{"$f":"D10-C10+F10-E10","v":"00:00:00"},{"$f":"G10","v":"00:00:00"},null,null,null,null,{"$f":"M9+1","v":2},{"$f":"CONCATENATE(M10,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"2/1/2017"},29,{"$f":"ISERROR(O10)","v":false},{"$f":"IF(P10,\" \",WEEKDAY(N10))","v":"1900-01-02"}]
[{"$f":"IF(P11,\" \",M11)","v":3},{"$f":"Q11","v":"1900-01-03"},null,null,null,null,"00:00:00","00:00:00",null,null,null,null,{"$f":"M10+1","v":3},{"$f":"CONCATENATE(M11,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"3/1/2017"},28,false,"1900-01-03",null,null,"Manual de usuario en al pestaña \"Instrucciones\""]
[{"$f":"IF(P12,\" \",M12)","v":4},"1900-01-04",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,4,{"$f":"CONCATENATE(M12,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"4/1/2017"},27,false,"1900-01-04"]
[{"$f":"IF(P13,\" \",M13)","v":5},"1900-01-05",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,5,{"$f":"CONCATENATE(M13,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"5/1/2017"},26,false,"1900-01-05",null,null,"Propiedad"]
[6,"1900-01-06",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,6,{"$f":"CONCATENATE(M14,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"6/1/2017"},25,false,"1900-01-06",null,null,"www.grupobelmar.onored.com"]
[7,"1900-01-07",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,7,{"$f":"CONCATENATE(M15,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"7/1/2017"},24,false,"1900-01-07"]
[8,"1900-01-01",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,8,{"$f":"CONCATENATE(M16,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"8/1/2017"},23,false,"1900-01-01"]
[9,"1900-01-02",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,9,{"$f":"CONCATENATE(M17,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"9/1/2017"},22,false,"1900-01-02"]
[10,"1900-01-03",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,10,{"$f":"CONCATENATE(M18,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"10/1/2017"},21,false,"1900-01-03"]
[11,"1900-01-04",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,11,{"$f":"CONCATENATE(M19,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"11/1/2017"},20,false,"1900-01-04"]
[12,"1900-01-05",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,12,{"$f":"CONCATENATE(M20,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"12/1/2017"},19,false,"1900-01-05"]
[13,"1900-01-06",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,13,{"$f":"CONCATENATE(M21,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"13/1/2017"},18,false,"1900-01-06"]
[14,"1900-01-07",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,14,{"$f":"CONCATENATE(M22,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"14/1/2017"},17,false,"1900-01-07"]
[15,"1900-01-01",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,15,{"$f":"CONCATENATE(M23,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"15/1/2017"},16,false,"1900-01-01"]
[16,"1900-01-02",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,16,{"$f":"CONCATENATE(M24,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"16/1/2017"},15,false,"1900-01-02"]
[17,"1900-01-03",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,17,{"$f":"CONCATENATE(M25,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"17/1/2017"},14,false,"1900-01-03"]
[18,"1900-01-04",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,18,{"$f":"CONCATENATE(M26,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"18/1/2017"},13,false,"1900-01-04"]
[19,"1900-01-05",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,19,{"$f":"CONCATENATE(M27,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"19/1/2017"},12,false,"1900-01-05"]
[20,"1900-01-06",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,20,{"$f":"CONCATENATE(M28,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"20/1/2017"},11,false,"1900-01-06"]
[21,"1900-01-07",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,21,{"$f":"CONCATENATE(M29,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"21/1/2017"},10,false,"1900-01-07"]
[22,"1900-01-01",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,22,{"$f":"CONCATENATE(M30,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"22/1/2017"},9,false,"1900-01-01"]
[23,"1900-01-02",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,23,{"$f":"CONCATENATE(M31,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"23/1/2017"},8,false,"1900-01-02"]
[24,"1900-01-03",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,24,{"$f":"CONCATENATE(M32,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"24/1/2017"},7,false,"1900-01-03"]
[25,"1900-01-04",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,25,{"$f":"CONCATENATE(M33,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"25/1/2017"},6,false,"1900-01-04"]
[26,"1900-01-05",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,26,{"$f":"CONCATENATE(M34,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"26/1/2017"},5,false,"1900-01-05"]
[27,"1900-01-06",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,27,{"$f":"CONCATENATE(M35,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"27/1/2017"},4,false,"1900-01-06"]
[28,"1900-01-07",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,28,{"$f":"CONCATENATE(M36,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"28/1/2017"},3,false,"1900-01-07"]
[29,"1900-01-01",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,29,{"$f":"CONCATENATE(M37,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"29/1/2017"},2,false,"1900-01-01"]
[30,"1900-01-02",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,30,{"$f":"CONCATENATE(M38,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"30/1/2017"},1,false,"1900-01-02"]
[31,"1900-01-03",null,null,null,null,"00:00:00","00:00:00",null,null,null,null,31,{"$f":"CONCATENATE(M39,\"/\",$N$4,\"/\",Datos_Generales!$A$2)","v":"31/1/2017"},0,false,"1900-01-03"]
[{"$f":"IF(P68,M40,\" \")","v":" "},"Total Mes",null,null,null,null,{"$f":"SUM(G9:G39)","v":"00:00:00"},{"$f":"SUM(H9:H39)","v":"00:00:00"},{"$f":"SUM(I9:I39)","v":"00:00:00"}]
[{"$f":"IF(P69,M41,\" \")","v":" "},"En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores"]
[{"$f":"IF(P70,M42,\" \")","v":" "}]
[]
[null,null,"Firma de la Empresa",null,null,null,"Firma del Trabajador"]

{"sheet":"Datos_Jornada_Asistente","index":1,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[19,10,19,12],[6,8,7,8],[40,1,41,8],[43,2,43,4],[43,6,43,8],[6,0,7,1],[6,2,6,3],[6,4,6,5],[6,6,7,6],[6,7,7,7],[4,1,4,4],[4,6,4,8],[5,1,5,2],[5,3,5,4],[5,6,5,8],[3,1,3,4],[3,6,3,8],[0,0,0,8],[1,0,1,4],[1,5,1,8],[2,0,2,4],[2,6,2,8],[5,12,5,15],[6,12,6,15],[7,12,7,15],[0,12,0,15],[1,12,1,15],[2,12,2,15],[3,12,3,15],[4,12,4,15]]}
["REGISTRO DIARIO DE JORNADA EN TRABAJADORES A TIEMPO COMPLETO",null,null,null,null,null,null,null,null,null,"Hasta que día trabaja",null,"Si se deja en blanco, se considera que trabaja todo el mes"]
["EMPRESA",null,null,null,null,"TRABAJADOR",null,null,null,null,"Vacaciones Dia Inicio",null,"Si se deja en blanco, se considera que no ha tenido vacaciones"]
[{"$f":"Datos_Empresa!B3","v":"Empresa Prueba"},null,null,null,null,"Nombre:","CEREZO ROMERO, VICENTE",null,null,null,"Vacaciones Dia Fin",null,"Si se deja en blanco, se considera que no ha tenido vacaciones",null,null,null,"Primer dia del mes",{"$f":"CONCATENATE(\"01/\",D6,\"/\",Datos_Generales!A2)","v":"01/Enero/2017"}]
["CIF:",{"$f":"Datos_Empresa!B4","v":"B123456789"},null,null,null,"NIF:",{"$f":"VLOOKUP(G3,Datos_Trabajadores!A2:F29,4,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Día Descanso 1","1900-01-02","No se puede dejar en blanco",null,null,null,"Cardinal Mes",{"$f":"MONTH(R3)","v":1}]
["C.C.C.:",{"$f":"Datos_Empresa!B5","v":"28/12345678-00"},null,null,null,"NAF:",{"$f":"VLOOKUP(G3,Datos_Trabajadores!A2:F29,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,"Día Descanso 2",null,"Se puede dejar en blanco según caso",null,null,null,"Ultimo día del mes",{"$f":"CONCATENATE(1,\"/\",R4+1,\"/\",Datos_Generales!A2)-1","v":"2017-01-31"}]
[null,"Período de liquidación:",null,"Enero",null,"Fecha:",{"$f":"R5","v":"2017-01-31"},null,null,null,"Hora Inicio Mañana","06:00:00","No se puede dejar en blanco"]
["Día del mes",null,"Horario Mañana",null,"Hora Tarde",null,"Total Horas\nJornada","Horas\nOrdinarias","Horas\nExtras",null,"Hora Fin Mañana",null,"Se puede dejar en blanco, si jornada continua"]
[null,null,"Inicio","Fin","Inicio","Fin",null,null,null,null,"Hora Inicio Tarde",null,"Obligatorio, si tiene jornada partida",null,null,null,"Día del Mes","Dia Mes completo","Diferencia Dias","Es día no valido","Dias de la semana"]
[{"$f":"IF(T9,\" \",Q9)","v":1},{"$f":"U9","v":"1900-01-01"},"06:00:00","13:00:00",null,null,{"$f":"IF(ISBLANK(C9),\"\",D9-C9+F9-E9)","v":"07:00:00"},{"$f":"G9","v":"07:00:00"},null,null,null,null,null,null,null,null,1,{"$f":"CONCATENATE(Q9,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"1/1/2017"},{"$f":"$R$5-R9","v":30},{"$f":"ISERROR(S9)","v":false},{"$f":"IF(T9,\" \",WEEKDAY(R9))","v":"1900-01-01"}]
[{"$f":"IF(T10,\" \",Q10)","v":2},{"$f":"U10","v":"1900-01-02"},null,null,null,null,{"$f":"IF(ISBLANK(C10),\"\",D10-C10+F10-E10)","v":""},{"$f":"G10","v":""},null,null,null,null,null,null,null,null,{"$f":"Q9+1","v":2},{"$f":"CONCATENATE(Q10,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"2/1/2017"},29,{"$f":"ISERROR(S10)","v":false},{"$f":"IF(T10,\" \",WEEKDAY(R10))","v":"1900-01-02"}]
[{"$f":"IF(T11,\" \",Q11)","v":3},{"$f":"U11","v":"1900-01-03"},"06:00:00","11:00:00",null,null,"05:00:00","05:00:00",null,null,null,null,null,null,null,null,{"$f":"Q10+1","v":3},{"$f":"CONCATENATE(Q11,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"3/1/2017"},28,false,"1900-01-03"]
[{"$f":"IF(T12,\" \",Q12)","v":4},"1900-01-04","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,4,{"$f":"CONCATENATE(Q12,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"4/1/2017"},27,false,"1900-01-04"]
[{"$f":"IF(T13,\" \",Q13)","v":5},"1900-01-05","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,5,{"$f":"CONCATENATE(Q13,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"5/1/2017"},26,false,"1900-01-05"]
[6,"1900-01-06","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,6,{"$f":"CONCATENATE(Q14,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"6/1/2017"},25,false,"1900-01-06"]
[7,"1900-01-07","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,7,{"$f":"CONCATENATE(Q15,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"7/1/2017"},24,false,"1900-01-07"]
[8,"1900-01-01","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,8,{"$f":"CONCATENATE(Q16,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"8/1/2017"},23,false,"1900-01-01"]
[9,"1900-01-02",null,null,null,null,"","",null,null,null,null,null,null,null,null,9,{"$f":"CONCATENATE(Q17,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"9/1/2017"},22,false,"1900-01-02"]
[10,"1900-01-03","06:00:00","11:00:00",null,null,"05:00:00","05:00:00",null,null,null,null,null,null,null,null,10,{"$f":"CONCATENATE(Q18,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"10/1/2017"},21,false,"1900-01-03"]
[11,"1900-01-04","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,11,{"$f":"CONCATENATE(Q19,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"11/1/2017"},20,false,"1900-01-04"]
[12,"1900-01-05","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,"Manual de usuario en al pestaña \"Instrucciones\"",null,null,null,null,null,12,{"$f":"CONCATENATE(Q20,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"12/1/2017"},19,false,"1900-01-05"]
[13,"1900-01-06","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,13,{"$f":"CONCATENATE(Q21,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"13/1/2017"},18,false,"1900-01-06"]
[14,"1900-01-07","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,"Propiedad","Versión: 15.0",null,null,null,null,14,{"$f":"CONCATENATE(Q22,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"14/1/2017"},17,false,"1900-01-07"]
[15,"1900-01-01","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,"www.grupobelmar.onored.com",null,null,null,null,null,15,{"$f":"CONCATENATE(Q23,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"15/1/2017"},16,false,"1900-01-01"]
[16,"1900-01-02",null,null,null,null,"","",null,null,null,null,null,null,null,null,16,{"$f":"CONCATENATE(Q24,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"16/1/2017"},15,false,"1900-01-02"]
[17,"1900-01-03","06:00:00","11:00:00",null,null,"05:00:00","05:00:00",null,null,"Si desea cambios en la configuación del Asistente que no estén permitidos, pongase en contacto con nosotros.",null,null,null,null,null,17,{"$f":"CONCATENATE(Q25,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"17/1/2017"},14,false,"1900-01-03"]
[18,"1900-01-04","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,18,{"$f":"CONCATENATE(Q26,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"18/1/2017"},13,false,"1900-01-04"]
[19,"1900-01-05","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,19,{"$f":"CONCATENATE(Q27,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"19/1/2017"},12,false,"1900-01-05"]
[20,"1900-01-06","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,20,{"$f":"CONCATENATE(Q28,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"20/1/2017"},11,false,"1900-01-06"]
[21,"1900-01-07","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,21,{"$f":"CONCATENATE(Q29,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"21/1/2017"},10,false,"1900-01-07"]
[22,"1900-01-01","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,22,{"$f":"CONCATENATE(Q30,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"22/1/2017"},9,false,"1900-01-01"]
[23,"1900-01-02",null,null,null,null,"","",null,null,null,null,null,null,null,null,23,{"$f":"CONCATENATE(Q31,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"23/1/2017"},8,false,"1900-01-02"]
[24,"1900-01-03","06:00:00","11:00:00",null,null,"05:00:00","05:00:00",null,null,null,null,null,null,null,null,24,{"$f":"CONCATENATE(Q32,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"24/1/2017"},7,false,"1900-01-03"]
[25,"1900-01-04","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,25,{"$f":"CONCATENATE(Q33,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"25/1/2017"},6,false,"1900-01-04"]
[26,"1900-01-05","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,26,{"$f":"CONCATENATE(Q34,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"26/1/2017"},5,false,"1900-01-05"]
[27,"1900-01-06","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,27,{"$f":"CONCATENATE(Q35,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"27/1/2017"},4,false,"1900-01-06"]
[28,"1900-01-07","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,28,{"$f":"CONCATENATE(Q36,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"28/1/2017"},3,false,"1900-01-07"]
[29,"1900-01-01","06:00:00","13:00:00",null,null,"07:00:00","07:00:00",null,null,null,null,null,null,null,null,29,{"$f":"CONCATENATE(Q37,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"29/1/2017"},2,false,"1900-01-01"]
[30,"1900-01-02",null,null,null,null,"","",null,null,null,null,null,null,null,null,30,{"$f":"CONCATENATE(Q38,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"30/1/2017"},1,false,"1900-01-02"]
[31,"1900-01-03","06:00:00","11:00:00",null,null,"05:00:00","05:00:00",null,null,null,null,null,null,null,null,31,{"$f":"CONCATENATE(Q39,\"/\",$R$4,\"/\",Datos_Generales!$A$2)","v":"31/1/2017"},0,false,"1900-01-03"]
[{"$f":"IF(T68,Q40,\" \")","v":" "},"Total Mes"]
[{"$f":"IF(T69,Q41,\" \")","v":" "},"En cumplimiento de la obligación establecida en el Art. 35.5  del Real Decreto Legislativo 2/2015 de 23 de Octubre, por el que se aprueba el texto refundido del la Ley del Estatuto de los Trabajadores"]
[{"$f":"IF(T70,Q42,\" \")","v":" "}]
[]
[null,null,"Firma de la Empresa",null,null,null,"Firma del Trabajador"]

{"sheet":"Datos_Trabajadores","index":2,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Apellidos, Nombre","Apellidos","Nombre","NIF:","NAF:","Día Descanso 1","Día Descanso 2 (Opcional)","Hora Inicio Mañana","Hora Fin Mañana (opcional)","Hora Inicio Tarde (opcional)"]
[{"$f":"IF(B2=\"\",\" \",CONCATENATE(B2,\", \",C2))","v":"Apellido1 Apellido2, Nombre"},"Apellido1 Apellido2","Nombre","45852369X","28/00000000-03","1900-01-02",null,"06:00:00"]
[{"$f":"IF(B3=\"\",\" \",CONCATENATE(B3,\", \",C3))","v":" "}]
[{"$f":"IF(B4=\"\",\" \",CONCATENATE(B4,\", \",C4))","v":" "}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Datos_Empresa","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Nombre o Razón Social:","Empresa Prueba"]
["CIF:","B123456789"]
["C.C.C.:","28/12345678-00"]

{"sheet":"Datos_Generales","index":4,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Año","Meses","Mes Número","Estado","Dias de la Semana","Dias de la Semana","Horas Mañana",null,"Horas Tarde",null,null,null,null,null,null,"Hay que activar Desarrollador -> Complementos -> Herramientas para análisis "]
[2017,"Enero",1,"Activo","1900-01-07",{"$f":"E2","v":"1900-01-07"},"06:00:00","00:30:00","15:00:00","00:30:00"]
[null,"Febrero",{"$f":"C2+1","v":2},"Desactivo","1900-01-01",{"$f":"E3","v":"1900-01-01"},{"$f":"G2+H2","v":"06:30:00"},"00:30:00",{"$f":"I2+J2","v":"15:30:00"},"00:30:00"]
[null,"Marzo",{"$f":"C3+1","v":3},null,"1900-01-02","1900-01-02",{"$f":"G3+H3","v":"07:00:00"},"00:30:00",{"$f":"I3+J3","v":"16:00:00"},"00:30:00"]
[null,"Abril",4,null,"1900-01-03","1900-01-03",{"$f":"G4+H4","v":"07:30:00"},"00:30:00",{"$f":"I4+J4","v":"16:30:00"},"00:30:00"]
[null,"Mayo",5,null,"1900-01-04","1900-01-04","08:00:00","00:30:00","17:00:00","00:30:00"]
[null,"Junio",6,null,"1900-01-05","1900-01-05","08:30:00","00:30:00","17:30:00","00:30:00"]
[null,"Julio",7,null,"1900-01-06","1900-01-06","09:00:00","00:30:00","18:00:00","00:30:00"]
[null,"Agosto",8,null,null,null,"09:30:00","00:30:00","18:30:00","00:30:00"]
[null,"Septiembre",9,null,null,null,"10:00:00","00:30:00","19:00:00","00:30:00"]
[null,"Octubre",10,null,null,null,"10:30:00","00:30:00","19:30:00","00:30:00"]
[null,"Noviembre",11,null,null,null,"11:00:00","00:30:00","20:00:00","00:30:00"]
[null,"Diciembre",12,null,null,null,"11:30:00","00:30:00","20:30:00","00:30:00"]
[null,null,null,null,null,null,"12:00:00","00:30:00","21:00:00","00:30:00"]
[null,null,null,null,null,null,"12:30:00","00:30:00","21:30:00","00:30:00"]
[null,null,null,null,null,null,"13:00:00","00:30:00","22:00:00","00:30:00"]
[null,null,null,null,null,null,{"$f":"G16+H16","v":"13:30:00"},"00:30:00",{"$f":"I16+J16","v":"22:30:00"},"00:30:00"]
[null,null,null,null,null,null,"14:00:00","00:30:00",{"$f":"I17+J17","v":"23:00:00"},"00:30:00"]
[null,null,null,null,null,null,"14:30:00","00:30:00","23:30:00","00:30:00"]
[null,null,null,null,null,null,"15:00:00","00:30:00"]
[null,null,null,null,null,null,{"$f":"G20+H20","v":"15:30:00"},"00:30:00"]
[null,null,null,null,null,null,"16:00:00","00:30:00"]
[null,null,null,null,null,null,"16:30:00","00:30:00"]
[null,null,null,null,null,null,"17:00:00","00:30:00"]

{"sheet":"Instrucciones","index":5,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[23,6,23,7],[25,6,25,7],[44,6,44,7],[46,6,46,7]]}
[]
[null,"Manual de instrucciones del libro Excel Registro Jornada a Tiempo Completo"]
[]
[null,"Esta hoja excel es un asistente autómatico para poder rellenar un alto porcentage de la casuística existente con la configuración de muy pocos parámetros"]
[]
[null,"Pestaña \"Datos Generales\""]
[null,null,"Habrá que indicar en la el año en el queremos trabajar para rellenar la hora de Registro de Jornada. Este parametro cada año habrá que cambiarlo al que corresponda"]
[null,"Pestaña \"Datos_Empresa\""]
[null,null,"Habrá que indicar en la información de la Empresa."]
[null,"Pestaña \"Datos_Trabajadores\""]
[null,null,"Habrá que indicar los datos de los trabajadores. Esta información se utilizará para rellenar la hora de Registro de Jornada"]
[null,null,"Los datos indicados en la columnas "]
[]
[null,null,null,null,"Día Descanso 1"]
[null,null,null,null,"Día Descanso 2"]
[null,null,null,null,"Hora Inicio Mañana"]
[null,null,null,null,"Hora Fin Mañana"]
[null,null,null,null,"Hora Inicio Tarde"]
[]
[null,null,"se trasladará a los campos correspondiente en la pestaña \"Datos_Jornada_Asistente\", cuando se selecciona al Trabajador"]
[]
[null,"Pestaña \"Datos_Jornada_Asistente\""]
[]
[null,null,"Habrá que seleccionar el mes en el campo ",null,null,null,"Período de liquidación"]
[]
[null,null,"Habrá que seleccionar el trabajador",null,null,null,"TRABAJADOR",null,null,"y rellena automáticamente el contenido de los campos",null,null,null,null,"Día Descanso 1",null,null,"según el contenido indicado en la Pestaña \"Datos de Trabajador\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Día Descanso 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora Inicio Mañana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora Fin Mañana"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora Inicio Tarde"]
[]
[null,null,"Configurar para el mes actual los campos que se indicar a continuación, según la parametrización que corresponda",null,null,null,null,null,null,null,null,null,"Hasta que día trabaja"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vacaciones Dia Inicio"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Vacaciones Dia Fin"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Día Descanso 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Día Descanso 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hora Inicio Mañana"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hora Fin Mañana"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hora Inicio Tarde"]
[]
[null,null,"Pulsar el botón \"Rellenar Registro\" para que la hoja de Registro de Jornada sea completada."]
[]
[null,"Pestaña \"Datos_Jornada_Libre\""]
[]
[null,null,"Habrá que seleccionar el mes en el campo ",null,null,null,"Período de liquidación"]
[]
[null,null,"Habrá que seleccionar el trabajador",null,null,null,"TRABAJADOR"]
[]
[null,null,"Cuando el caso a rellenar no pueda ser contemplado por el asistente, el usuario podrá rellenar a mano el registro de horas."]