{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Datos","MENU","Enero","Total","Servicios","Empleados"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Enero",{"$f":"DATE(MENU!$D$9,ROW(Enero!C1),1)","v":"2019-01-01"},null,1]
[null,"Febrero",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}}]
[null,"Marzo",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"ENERO"]
[null,"Abril",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"FEBRERO"]
[null,"Mayo",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"MARZO"]
[null,"Junio",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"ABRIL"]
[null,"Julio",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"MAYO"]
[null,"Agosto",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"JUNIO"]
[null,"Septiembre",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"JULIO"]
[null,"Octubre",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"AGOSTO"]
[null,"Noviembre",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"SEPTIEMBRE"]
[null,"Diciembre",{"$f":"DATE(MENU!$D$9,ROW(#REF!),1)","v":{"$error":"#REF!"}},null,"OCTUBRE"]
[null,null,null,null,"NOVIEMBRE"]
[null,{"$f":"VLOOKUP(MENU!$G$9,B$2:$C$13,2,0)","v":"2019-01-01"},{"$f":"EOMONTH(B15,0)","v":"2019-01-31"},null,"DICIEMBRE"]

{"sheet":"MENU","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[11,5,11,7],[13,4,13,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,2019,null,null,"ENERO"]
[]
[]
[null,null,null,{"$f":"VLOOKUP(F12,Empleados!A2:D101,2,FALSE)","v":1},null,"Perico perez"]
[]
[null,null,null,null,{"$f":"VLOOKUP(F12,Empleados!A2:D101,3,FALSE)","v":"Vigilante"},null,null,{"$f":"VLOOKUP(F12,Empleados!A2:D101,4,FALSE)","v":"Completa"}]

{"sheet":"Enero","index":2,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,4,46,5],[42,5,42,6],[44,5,44,6],[4,6,5,7],[4,5,5,5],[4,4,5,4],[41,4,41,5],[7,4,7,6],[2,10,2,11],[1,6,1,7],[2,6,2,7],[1,1,2,5],[44,9,44,10],[41,10,41,11],[9,2,9,3],[42,9,42,10]]}
[]
[null,"CUADRANTE",null,null,null,null,"ENERO"]
[null,null,null,null,null,null,{"$f":"MENU!D9","v":2019}]
[]
[null,null,null,"  Unidad:",{"$f":"MENU!D12","v":1},"Categoría:",{"$f":"MENU!E14","v":"Vigilante"},null,"           Jornada:",{"$f":"MENU!H14","v":"Completa"}]
[]
[]
[null,null,null,"Nombre:",{"$f":"MENU!F12","v":"Perico perez"}]
[]
[null,"F","Fecha",null,"H. entrada","H. Salida","Servicio 1","Total H.","Servicio 2","H. Entrada","H. Salida","Total H."]
[null,null,{"$f":"IF($G$3>0,Datos!$B$15,\"\")","v":"2019-01-01"},{"$f":"PROPER(TEXT(C11,\"dddd\"))","v":"Martes"},null,null,"Aptos. Los Carmenes",{"$f":"MOD(F11-E11,1)*24","v":0},null,null,null,{"$f":"MOD(K11-J11,1)*24","v":0}]
[null,null,{"$f":"IF(C11<>\"\",C11+1,\"\")","v":"2019-01-02"},{"$f":"PROPER(TEXT(C12,\"dddd\"))","v":"Miércoles"},null,null,null,{"$f":"MOD(F12-E12,1)*24","v":0},null,null,null,{"$f":"MOD(K12-J12,1)*24","v":0}]
[null,null,{"$f":"IF(C12<>\"\",C12+1,\"\")","v":"2019-01-03"},"Jueves",null,null,null,0,null,null,null,0]
[null,null,"2019-01-04","Viernes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-05","Sábado",null,null,null,0,null,null,null,0]
[null,null,"2019-01-06","Domingo",null,null,null,0,null,null,null,0]
[null,null,"2019-01-07","Lunes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-08","Martes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-09","Miércoles",null,null,null,0,null,null,null,0]
[null,null,"2019-01-10","Jueves",null,null,null,0,null,null,null,0]
[null,null,"2019-01-11","Viernes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-12","Sábado",null,null,null,0,null,null,null,0]
[null,null,"2019-01-13","Domingo",null,null,null,0,null,null,null,0]
[null,null,"2019-01-14","Lunes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-15","Martes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-16","Miércoles",null,null,null,0,null,null,null,0]
[null,null,"2019-01-17","Jueves",null,null,null,0,null,null,null,0]
[null,null,"2019-01-18","Viernes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-19","Sábado",null,null,null,0,null,null,null,0]
[null,null,"2019-01-20","Domingo",null,null,null,0,null,null,null,0]
[null,null,"2019-01-21","Lunes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-22","Martes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-23","Miércoles",null,null,null,0,null,null,null,0]
[null,null,"2019-01-24","Jueves",null,null,null,0,null,null,null,0]
[null,null,"2019-01-25","Viernes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-26","Sábado",null,null,null,0,null,null,null,0]
[null,null,"2019-01-27","Domingo",null,null,null,0,null,null,null,0]
[null,null,"2019-01-28","Lunes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-29","Martes",null,null,null,0,null,null,null,0]
[null,null,"2019-01-30","Miércoles",null,null,null,0,null,null,null,0]
[null,null,"2019-01-31","Jueves",null,null,null,0,null,null,null,0]
[]
[null,null,"HORS","TOTAL",null,"Total Horas Servicio 1",null,{"$f":"SUM(H11:H41)","v":0},null,"Total Horas Servicio 2",null,{"$f":"SUM(L11:L41)","v":0}]
[null,null,"FEST"]
[null,null,"NOCT",null,null,"Total de Horas Mensuales",null,{"$f":"H43+L43","v":0},null,"COMPUTO MENSUAL",null,162]
[]
[null,null,null,null,"TOTAL HORAS EXTRA",null,{"$f":"H45-L45","v":-162}]

{"sheet":"Total","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,1,9,10],[8,3,8,6],[2,2,2,9],[7,1,7,10],[5,1,5,10],[8,7,8,10],[10,7,11,9],[13,7,14,9],[16,7,17,9],[19,7,20,9],[22,7,23,9]]}
[]
[]
[null,null,"TOTAL DE HORAS ANUALES"]
[]
[]
[]
[null,null,"Unidad:",{"$f":"MENU!D12","v":1},null,"Categoria:",{"$f":"MENU!E14","v":"Vigilante"},null,"Jornada:",{"$f":"MENU!H14","v":"Completa"}]
[]
[null,null,"Nombre:",{"$f":"MENU!F12","v":"Perico perez"}]
[]
[null,null,null,null,null,null,null,{"$f":"Enero!H45","v":0}]
[]
[]
[null,null,null,null,null,null,null,1782]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H11-H14","v":-1782}]
[]
[]
[null,null,null,null,null,null,null,80]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H17<=80,(H17),(H17-H20))","v":-1782}]

{"sheet":"Servicios","index":4,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["SERVICIOS"]
["Aptos. Los Carmenes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ENERO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"FEBRERO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MARZO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ABRIL"]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAYO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JUNIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"JULIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"AGOSTO"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SEPTIEMBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"OCTUBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NOVIEMBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"DICIEMBRE"]

{"sheet":"Empleados","index":5,"n_rows":124,"n_cols":9,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["NOMBRE","UNIDAD","CATEGORIA","JORNADA"]
["Perico perez",1,"Vigilante","Completa"]
["Camilo Cela",2,"Vigilante","Completa"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"ENERO"]
[null,null,null,null,null,null,null,null,"FEBRERO"]
[null,null,null,null,null,null,null,null,"MARZO"]
[null,null,null,null,null,null,null,null,"ABRIL"]
[null,null,null,null,null,null,null,null,"MAYO"]
[null,null,null,null,null,null,null,null,"JUNIO"]
[null,null,null,null,null,null,null,null,"JULIO"]
[null,null,null,null,null,null,null,null,"AGOSTO"]
[null,null,null,null,null,null,null,null,"SEPTIEMBRE"]
[null,null,null,null,null,null,null,null,"OCTUBRE"]
[null,null,null,null,null,null,null,null,"NOVIEMBRE"]
[null,null,null,null,null,null,null,null,"DICIEMBRE"]