{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Listas y Controles","Asignación de Turnos","Registro de Turnos","Consulta de Turnos por Cédula"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":2,"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":"Listas y Controles","index":0,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
["Horas","Minutos","Jornada Ordinaria",null,"Jornada",null,null,null,null,"Valor Hora Ordinaria","Recargo Hora Nocturna","Recargo Hora Extra Diurna","Recargo Hora Extra Nocturna",null,"Límite Horas Extras X Día"]
["00","00",1,null,"IJD",6,0,{"$f":"((F2*60)+G2)/60","v":6},null,3000,0.35,0.25,0.75,null,2]
["01","05",2,null,"FJD",21,59,{"$f":"((F3*60)+G3)/60","v":21.983333333333334}]
["02","10",3]
["03",15,4]
["04",20,5]
["05",25,6]
["06",30,7]
["07",35,8]
["08",40,9]
["09",45,10]
["10",50,11]
["11",55,12]
["12",59,13]
["13","00",14]
["14","N/A",15]
["15",null,16]
["16",null,17]
["17",null,18]
["18",null,19]
["19",null,20]
["20",null,21]
["21",null,22]
["22",null,23]
["23",null,24]
["00"]
["N/A"]

{"sheet":"Asignación de Turnos","index":1,"n_rows":105,"n_cols":53,"rows_kept":105,"cut":false,"hidden":false,"merged":[[0,50,1,50],[0,48,1,48],[0,51,1,51],[31,4,31,6],[0,42,0,47],[0,27,0,32],[0,33,0,35],[0,20,1,20],[0,19,1,19],[0,52,1,52],[0,2,1,2],[0,1,1,1],[0,0,1,0],[0,36,0,41],[0,13,0,15],[0,21,0,23],[0,24,0,26],[0,3,1,3],[0,16,1,16],[0,17,1,17],[0,18,1,18],[0,7,0,9],[0,10,0,12],[0,4,0,6],[0,49,1,49]]}
["CEDULA","NOMBRE","APELLIDOS","JORNADA ORDINARIA","HORA DE INGRESO",null,null,"HORA DE DESCANSO",null,null,"HORA DE REGRESO",null,null,"HORA DE SALIDA",null,null,"I","D","R","S","Total horas Laboradas","Horas Ordinarias Laboradas",null,null,"Horas Extras Laboradas",null,null,"Ingreso a Descanso",null,null,null,null,null,"Descanso a Regreso",null,null,"Regreso a Salida",null,null,null,null,null,"Ingreso a Salida (Para turnos sin descanso)",null,null,null,null,null,"$ trabajo nocturno","$ trabajo extra diurno","$ trabajo extra nocturno","Valor total del trabajo extra y/o nocturno","Mensaje"]
[null,null,null,null,"hh",null,"mm","hh",null,"mm","hh",null,"mm","hh",null,"mm",null,null,null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas","Descanzadas","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas","Laboradas","Diurnas","Nocturnas","Extras","Diurnas","Nocturnas"]
[12345678,"Jaime","Barragan",8,"08",":","00","12",":","00","14",":","00","18",":","00",{"$f":"((IF(VALUE(LEFT(E3,1))=0,VALUE(RIGHT(E3,1)),VALUE(E3))*60)+IF(VALUE(LEFT(G3,1))=0,VALUE(RIGHT(G3,1)),VALUE(G3)))/60","v":8},{"$f":"((IF(VALUE(LEFT(H3,1))=0,VALUE(RIGHT(H3,1)),VALUE(H3))*60)+IF(VALUE(LEFT(J3,1))=0,VALUE(RIGHT(J3,1)),VALUE(J3)))/60","v":12},{"$f":"((IF(VALUE(LEFT(K3,1))=0,VALUE(RIGHT(K3,1)),VALUE(K3))*60)+IF(VALUE(LEFT(M3,1))=0,VALUE(RIGHT(M3,1)),VALUE(M3)))/60","v":14},{"$f":"((IF(VALUE(LEFT(N3,1))=0,VALUE(RIGHT(N3,1)),VALUE(N3))*60)+IF(VALUE(LEFT(P3,1))=0,VALUE(RIGHT(P3,1)),VALUE(P3)))/60","v":18},{"$f":"V3+Y3","v":8},{"$f":"W3+X3","v":8},{"$f":"ROUND(AC3-AF3+AL3-AO3+AR3-AU3,1)","v":8},{"$f":"ROUND(AD3-AG3+AM3-AP3+AS3-AV3,1)","v":0},{"$f":"Z3+AA3","v":0},{"$f":"ROUND(AF3+AO3+AU3,1)","v":0},{"$f":"ROUND(AG3+AP3+AV3,1)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(H3>E3,H3-E3,IF(H3<E3,24-E3+H3)),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(R3>Q3,IF(AND(Q3>=IJD,R3<=FJD),R3-Q3,IF(AND(Q3<IJD,R3>FJD),FJD-IJD,IF(AND(Q3>=IJD,Q3<FJD,R3<24),FJD-Q3,IF(AND(Q3<IJD,R3>IJD,R3<FJD),R3-IJD,0)))),IF(R3<Q3,IF(AND(Q3>IJD,Q3<FJD,R3>=IJD,R3<FJD),FJD-Q3+R3-IJD,IF(AND(Q3>=IJD,Q3<FJD,R3<IJD),FJD-Q3,IF(AND(Q3>FJD,R3>IJD,R3<FJD),R3-IJD,IF(AND(Q3>FJD,R3>FJD),16,IF(AND(Q3<IJD,R3<IJD),16,0))))))),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AB3-AC3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AB3>$D3,AB3-$D3,0),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AE3=0,0,IF(R3>IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,R3<=FJD),R3-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3>FJD),FJD-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3<24),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3>IJD,R3<FJD),R3-IJD,0)))),IF(R3<IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3>=IJD,R3<FJD),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)+R3-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>=IJD,IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<FJD,R3<IJD),FJD-IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3),IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>FJD,R3>IJD,R3<FJD),R3-IJD,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)>FJD,R3>FJD),16,IF(AND(IF(Q3+AB3-AE3>24,(Q3+AB3-AE3)-24,Q3+AB3-AE3)<IJD,R3<IJD),16,0)))))))),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AE3-AF3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(S3>R3,S3-R3,IF(S3<R3,24-R3+S3)),0)","v":2},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(S3>R3,IF(AND(R3>=IJD,S3<FJD),S3-R3,IF(AND(R3>=IJD,S3>FJD),IF(R3>FJD,R3-FJD,FJD-R3),IF(AND(R3<IJD,S3>=IJD,S3>FJD),S3-IJD-(S3-FJD),IF(AND(R3<IJD,S3>=IJD),S3-IJD,IF(AND(R3<IJD,S3<IJD),0))))),IF(S3<R3,IF(AND(R3>=FJD,S3<=IJD),0,IF(AND(R3<FJD,S3<=IJD),FJD-R3,IF(AND(R3>FJD,S3>IJD),S3-IJD,IF(AND(R3<FJD,S3>IJD),FJD-R3+S3-IJD)))))),0)","v":2},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AH3-AI3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(T3>S3,T3-S3,IF(T3<S3,24-S3+T3)),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(T3>S3,IF(AND(S3>=IJD,T3<=FJD),T3-S3,IF(AND(S3<IJD,T3>FJD),FJD-IJD,IF(AND(S3>=IJD,S3<FJD,T3<24),FJD-S3,IF(AND(S3<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<S3,IF(AND(S3>IJD,S3<FJD,T3>=IJD,T3<FJD),FJD-S3+T3-IJD,IF(AND(S3>=IJD,S3<FJD,T3<IJD),FJD-S3,IF(AND(S3>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(S3>FJD,T3>FJD),16,IF(AND(S3<IJD,T3<IJD),16,0))))))),0)","v":4},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AK3-AL3,0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AE3>0,AK3,IF(AK3+AB3>$D3,AK3+AB3-$D3,0)),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),IF(AN3=0,0,IF(T3>IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,T3<=FJD),T3-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3>FJD),FJD-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3<24),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3>=IJD,T3<FJD),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)+T3-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>=IJD,IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<FJD,T3<IJD),FJD-IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3),IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)>FJD,T3>FJD),16,IF(AND(IF(S3+AK3-AN3>24,(S3+AK3-AN3)-24,S3+AK3-AN3)<IJD,T3<IJD),16,0)))))))),0)","v":0},{"$f":"IF(AND(H3<>\"N/A\",K3<>\"N/A\"),AN3-AO3,0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(T3>Q3,T3-Q3,IF(T3<Q3,24-Q3+T3)),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(T3>Q3,IF(AND(Q3>=IJD,T3<=FJD),T3-Q3,IF(AND(Q3<IJD,T3>FJD),FJD-IJD,IF(AND(Q3>=IJD,Q3<FJD,T3<24),FJD-Q3,IF(AND(Q3<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<Q3,IF(AND(Q3>IJD,Q3<FJD,T3>=IJD,T3<FJD),FJD-Q3+T3-IJD,IF(AND(Q3>=IJD,Q3<FJD,T3<IJD),FJD-Q3,IF(AND(Q3>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(Q3>FJD,T3>FJD),16,IF(AND(Q3<IJD,T3<IJD),16,0))))))),0)","v":0},{"$f":"AQ3-AR3","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(AQ3>$D3,AQ3-$D3,0),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),IF(AT3=0,0,IF(T3>IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,T3<=FJD),T3-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3>FJD),FJD-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3<24),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3>IJD,T3<FJD),T3-IJD,0)))),IF(T3<IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3>=IJD,T3<FJD),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)+T3-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>=IJD,IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<FJD,T3<IJD),FJD-IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3),IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>FJD,T3>IJD,T3<FJD),T3-IJD,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)>FJD,T3>FJD),16,IF(AND(IF(Q3+AQ3-AT3>24,(Q3+AQ3-AT3)-24,Q3+AQ3-AT3)<IJD,T3<IJD),16,0)))))))),0)","v":0},{"$f":"IF(AND(H3=\"N/A\",K3=\"N/A\"),AT3-AU3,0)","v":0},{"$f":"X3*((1+RECARGONOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"Z3*((1+RECARGOEXTRADIURNA)*VALORHORAORDINARIA)","v":0},{"$f":"AA3*((1+RECARGOEXTRANOCTURNA)*VALORHORAORDINARIA)","v":0},{"$f":"SUM(AW3:AY3)","v":0},{"$f":"IF(Y3>2,\"Excedio el límite de horas Extras en \" & Y3-LIMITEHORASEXTRAXDIA,\"\")","v":""}]
[92408250,"Pedro","Cano",8,"08",":","00","12",":","00","14",":","00","20",":","00",{"$f":"((IF(VALUE(LEFT(E4,1))=0,VALUE(RIGHT(E4,1)),VALUE(E4))*60)+IF(VALUE(LEFT(G4,1))=0,VALUE(RIGHT(G4,1)),VALUE(G4)))/60","v":8},{"$f":"((IF(VALUE(LEFT(H4,1))=0,VALUE(RIGHT(H4,1)),VALUE(H4))*60)+IF(VALUE(LEFT(J4,1))=0,VALUE(RIGHT(J4,1)),VALUE(J4)))/60","v":12},{"$f":"((IF(VALUE(LEFT(K4,1))=0,VALUE(RIGHT(K4,1)),VALUE(K4))*60)+IF(VALUE(LEFT(M4,1))=0,VALUE(RIGHT(M4,1)),VALUE(M4)))/60","v":14},{"$f":"((IF(VALUE(LEFT(N4,1))=0,VALUE(RIGHT(N4,1)),VALUE(N4))*60)+IF(VALUE(LEFT(P4,1))=0,VALUE(RIGHT(P4,1)),VALUE(P4)))/60","v":20},{"$f":"V4+Y4","v":10},8,8,0,2,2,0,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(H4>E4,H4-E4,IF(H4<E4,24-E4+H4)),0)","v":4},4,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),AB4-AC4,0)","v":0},{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(AB4>$D4,AB4-$D4,0),0)","v":0},0,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),AE4-AF4,0)","v":0},{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(S4>R4,S4-R4,IF(S4<R4,24-R4+S4)),0)","v":2},2,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),AH4-AI4,0)","v":0},{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(T4>S4,T4-S4,IF(T4<S4,24-S4+T4)),0)","v":6},6,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),AK4-AL4,0)","v":0},{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),IF(AE4>0,AK4,IF(AK4+AB4>$D4,AK4+AB4-$D4,0)),0)","v":2},2,{"$f":"IF(AND(H4<>\"N/A\",K4<>\"N/A\"),AN4-AO4,0)","v":0},{"$f":"IF(AND(H4=\"N/A\",K4=\"N/A\"),IF(T4>Q4,T4-Q4,IF(T4<Q4,24-Q4+T4)),0)","v":0},0,{"$f":"AQ4-AR4","v":0},{"$f":"IF(AND(H4=\"N/A\",K4=\"N/A\"),IF(AQ4>$D4,AQ4-$D4,0),0)","v":0},0,{"$f":"IF(AND(H4=\"N/A\",K4=\"N/A\"),AT4-AU4,0)","v":0},0,7500,0,{"$f":"SUM(AW4:AY4)","v":7500},""]
[90963745,"Samuel","Lopez",8,"14",":","00","18",":","00","19",":","00","02",":","00",14,18,19,2,11,{"$f":"W5+X5","v":8},{"$f":"ROUND(AC5-AF5+AL5-AO5+AR5-AU5,1)","v":7},{"$f":"ROUND(AD5-AG5+AM5-AP5+AS5-AV5,1)","v":1},{"$f":"Z5+AA5","v":3},{"$f":"ROUND(AF5+AO5+AU5,1)","v":0},{"$f":"ROUND(AG5+AP5+AV5,1)","v":3},4,4,0,0,0,0,1,1,0,7,2.9833333333333343,4.0166666666666657,3,0,3,0,0,0,0,0,0,4050.0000000000005,0,15750,{"$f":"SUM(AW5:AY5)","v":19800},"Excedio el límite de horas Extras en 1"]
[96097193,"Camilo","Cifuentes",8,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,{"$f":"V6+Y6","v":12},{"$f":"W6+X6","v":8},{"$f":"ROUND(AC6-AF6+AL6-AO6+AR6-AU6,1)","v":8},{"$f":"ROUND(AD6-AG6+AM6-AP6+AS6-AV6,1)","v":0},{"$f":"Z6+AA6","v":4},{"$f":"ROUND(AF6+AO6+AU6,1)","v":3},{"$f":"ROUND(AG6+AP6+AV6,1)","v":1},4,4,0,0,0,0,3,3,0,8,6.9833333333333343,1.0166666666666657,4,2.9833333333333343,1.0166666666666657,0,0,0,0,0,0,0,11250,5250,16500,"Excedio el límite de horas Extras en 2"]
[93638537,"Jhon","Berrio",8,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},2,8,8,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,3.9833333333333343,4.0166666666666657,0,0,0,16200.000000000002,0,0,16200.000000000002,""]
[98702520,"Esteban","Mira",8,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},8,10,8,0,8,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2,8,2,2,0,32400.000000000004,7500,0,39900,""]
[95721889,"Johana","Aristizabal",8,"08",":","00","12",":","00","14",":","00","18",":","00",8,12,14,18,8,8,8,0,0,0,0,4,4,0,0,0,0,2,2,0,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,""]
[92722045,"Jose","Contreras",8,"08",":","00","12",":","00","14",":","00","20",":","00",8,12,14,20,10,8,8,0,2,2,0,4,4,0,0,0,0,2,2,0,6,6,0,2,2,0,0,0,0,0,0,0,0,7500,0,7500,""]
[97527365,"Mauricio","Gutierrez",8,"14",":","00","18",":","00","19",":","00","00",":","00",14,18,19,0,9,8,7,1,1,0,1,4,4,0,0,0,0,1,1,0,5,2.9833333333333343,2.0166666666666657,1,0,1,0,0,0,0,0,0,4050.0000000000005,0,5250,9300,""]
[97070960,"Maryi","Alvarez",8,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,12,8,8,0,4,3,1,4,4,0,0,0,0,3,3,0,8,6.9833333333333343,1.0166666666666657,4,2.9833333333333343,1.0166666666666657,0,0,0,0,0,0,0,11250,5250,16500,"Excedio el límite de horas Extras en 2"]
[94144851,"Diana","Escobar",8,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},2,8,8,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,3.9833333333333343,4.0166666666666657,0,0,0,16200.000000000002,0,0,16200.000000000002,""]
[92931162,"Andres","Lopez",8,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},8,10,8,0,8,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2,8,2,2,0,32400.000000000004,7500,0,39900,""]
[96554557,"David","Bedoya",8,"08",":","00","12",":","00","14",":","00","18",":","00",8,12,14,18,8,8,8,0,0,0,0,4,4,0,0,0,0,2,2,0,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,""]
[92456336,"Cindi","Lopera",8,"08",":","00","12",":","00","14",":","00","20",":","00",8,12,14,20,10,8,8,0,2,2,0,4,4,0,0,0,0,2,2,0,6,6,0,2,2,0,0,0,0,0,0,0,0,7500,0,7500,""]
[95807147,"Gladys","Ospina",8,"14",":","00","18",":","00","19",":","00","00",":","00",14,18,19,0,9,8,7,1,1,0,1,4,4,0,0,0,0,1,1,0,5,2.9833333333333343,2.0166666666666657,1,0,1,0,0,0,0,0,0,4050.0000000000005,0,5250,9300,""]
[92963879,"Laura","Zapata",8,"08",":","00","12",":","00","15",":","00","23",":","00",8,12,15,23,12,8,8,0,4,3,1,4,4,0,0,0,0,3,3,0,8,6.9833333333333343,1.0166666666666657,4,2.9833333333333343,1.0166666666666657,0,0,0,0,0,0,0,11250,5250,16500,"Excedio el límite de horas Extras en 2"]
[94180411,"Carlos","Muñoz",8,"18",":","00","N/A",":","N/A","N/A",":","N/A","02",":","00",18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},2,8,8,4,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,3.9833333333333343,4.0166666666666657,0,0,0,16200.000000000002,0,0,16200.000000000002,""]
[91666050,"Gonzalo","Munera",8,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},8,{"$f":"V20+Y20","v":10},8,0,8,2,2,0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(H20>E20,H20-E20,IF(H20<E20,24-E20+H20)),0)","v":0},0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),AB20-AC20,0)","v":0},{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(AB20>$D20,AB20-$D20,0),0)","v":0},0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),AE20-AF20,0)","v":0},{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(S20>R20,S20-R20,IF(S20<R20,24-R20+S20)),0)","v":0},0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),AH20-AI20,0)","v":0},{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(T20>S20,T20-S20,IF(T20<S20,24-S20+T20)),0)","v":0},0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),AK20-AL20,0)","v":0},{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),IF(AE20>0,AK20,IF(AK20+AB20>$D20,AK20+AB20-$D20,0)),0)","v":0},0,{"$f":"IF(AND(H20<>\"N/A\",K20<>\"N/A\"),AN20-AO20,0)","v":0},{"$f":"IF(AND(H20=\"N/A\",K20=\"N/A\"),IF(T20>Q20,T20-Q20,IF(T20<Q20,24-Q20+T20)),0)","v":10},2,{"$f":"AQ20-AR20","v":8},{"$f":"IF(AND(H20=\"N/A\",K20=\"N/A\"),IF(AQ20>$D20,AQ20-$D20,0),0)","v":2},2,{"$f":"IF(AND(H20=\"N/A\",K20=\"N/A\"),AT20-AU20,0)","v":0},32400.000000000004,7500,0,39900,""]
[99166507,"German","Lara",8,"22",":","00","N/A",":","N/A","N/A",":","N/A","08",":","00",22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},8,{"$f":"V21+Y21","v":10},8,0,8,2,2,0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(H21>E21,H21-E21,IF(H21<E21,24-E21+H21)),0)","v":0},0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),AB21-AC21,0)","v":0},{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(AB21>$D21,AB21-$D21,0),0)","v":0},0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),AE21-AF21,0)","v":0},{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(S21>R21,S21-R21,IF(S21<R21,24-R21+S21)),0)","v":0},0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),AH21-AI21,0)","v":0},{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(T21>S21,T21-S21,IF(T21<S21,24-S21+T21)),0)","v":0},0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),AK21-AL21,0)","v":0},{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),IF(AE21>0,AK21,IF(AK21+AB21>$D21,AK21+AB21-$D21,0)),0)","v":0},0,{"$f":"IF(AND(H21<>\"N/A\",K21<>\"N/A\"),AN21-AO21,0)","v":0},{"$f":"IF(AND(H21=\"N/A\",K21=\"N/A\"),IF(T21>Q21,T21-Q21,IF(T21<Q21,24-Q21+T21)),0)","v":10},2,{"$f":"AQ21-AR21","v":8},{"$f":"IF(AND(H21=\"N/A\",K21=\"N/A\"),IF(AQ21>$D21,AQ21-$D21,0),0)","v":2},2,{"$f":"IF(AND(H21=\"N/A\",K21=\"N/A\"),AT21-AU21,0)","v":0},32400.000000000004,7500,0,39900,""]
[86987512,"Aminta","Perez",4,"08",":","00","12",":","00","14",":","00","16",":","00",{"$f":"((IF(VALUE(LEFT(E22,1))=0,VALUE(RIGHT(E22,1)),VALUE(E22))*60)+IF(VALUE(LEFT(G22,1))=0,VALUE(RIGHT(G22,1)),VALUE(G22)))/60","v":8},{"$f":"((IF(VALUE(LEFT(H22,1))=0,VALUE(RIGHT(H22,1)),VALUE(H22))*60)+IF(VALUE(LEFT(J22,1))=0,VALUE(RIGHT(J22,1)),VALUE(J22)))/60","v":12},{"$f":"((IF(VALUE(LEFT(K22,1))=0,VALUE(RIGHT(K22,1)),VALUE(K22))*60)+IF(VALUE(LEFT(M22,1))=0,VALUE(RIGHT(M22,1)),VALUE(M22)))/60","v":14},{"$f":"((IF(VALUE(LEFT(N22,1))=0,VALUE(RIGHT(N22,1)),VALUE(N22))*60)+IF(VALUE(LEFT(P22,1))=0,VALUE(RIGHT(P22,1)),VALUE(P22)))/60","v":16},6,4,4,0,2,2,0,4,4,0,0,0,0,2,2,0,2,2,0,2,2,0,0,0,0,0,0,0,0,7500,0,7500,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((IF(VALUE(LEFT(E86,1))=0,VALUE(RIGHT(E86,1)),VALUE(E86))*60)+IF(VALUE(LEFT(G86,1))=0,VALUE(RIGHT(G86,1)),VALUE(G86)))/60","v":{"$error":"#VALUE!"}},{"$f":"((IF(VALUE(LEFT(H86,1))=0,VALUE(RIGHT(H86,1)),VALUE(H86))*60)+IF(VALUE(LEFT(J86,1))=0,VALUE(RIGHT(J86,1)),VALUE(J86)))/60","v":{"$error":"#VALUE!"}},{"$f":"((IF(VALUE(LEFT(K86,1))=0,VALUE(RIGHT(K86,1)),VALUE(K86))*60)+IF(VALUE(LEFT(M86,1))=0,VALUE(RIGHT(M86,1)),VALUE(M86)))/60","v":{"$error":"#VALUE!"}},{"$f":"((IF(VALUE(LEFT(N86,1))=0,VALUE(RIGHT(N86,1)),VALUE(N86))*60)+IF(VALUE(LEFT(P86,1))=0,VALUE(RIGHT(P86,1)),VALUE(P86)))/60","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Registro de Turnos","index":2,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":true,"merged":[[2,3,3,3],[2,4,2,6],[2,7,2,9],[2,1,3,1],[2,2,3,2]]}
[]
[]
[null,"CEDULA","Fecha","Total Laboradas","Ordinarias Laboradas",null,null,"Extras Laboradas"]
[null,null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas"]
[null,12345678,"2011-12-23",8,8,8,0,0,0,0]
[null,92408250,"2011-12-23",10,8,8,0,2,2,0]
[null,90963745,"2011-12-23",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,96097193,"2011-12-23",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,93638537,"2011-12-23",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,98702520,"2011-12-23",10,8,0,8,2,2,0]
[null,95721889,"2011-12-23",8,8,8,0,0,0,0]
[null,92722045,"2011-12-23",10,8,8,0,2,2,0]
[null,97527365,"2011-12-23",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,97070960,"2011-12-23",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94144851,"2011-12-23",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,92931162,"2011-12-23",10,8,0,8,2,2,0]
[null,96554557,"2011-12-23",8,8,8,0,0,0,0]
[null,92456336,"2011-12-23",10,8,8,0,2,2,0]
[null,95807147,"2011-12-23",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,92963879,"2011-12-23",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94180411,"2011-12-23",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,91666050,"2011-12-23",10,8,0,8,2,2,0]
[null,99166507,"2011-12-23",10,8,0,8,2,2,0]
[null,12345678,"2011-12-26",8,8,8,0,0,0,0]
[null,92408250,"2011-12-26",10,8,8,0,2,2,0]
[null,90963745,"2011-12-26",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,96097193,"2011-12-26",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,93638537,"2011-12-26",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,98702520,"2011-12-26",10,8,0,8,2,2,0]
[null,95721889,"2011-12-26",8,8,8,0,0,0,0]
[null,92722045,"2011-12-26",10,8,8,0,2,2,0]
[null,97527365,"2011-12-26",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,97070960,"2011-12-26",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94144851,"2011-12-26",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,92931162,"2011-12-26",10,8,0,8,2,2,0]
[null,96554557,"2011-12-26",8,8,8,0,0,0,0]
[null,92456336,"2011-12-26",10,8,8,0,2,2,0]
[null,95807147,"2011-12-26",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,92963879,"2011-12-26",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94180411,"2011-12-26",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,91666050,"2011-12-26",10,8,0,8,2,2,0]
[null,99166507,"2011-12-26",10,8,0,8,2,2,0]
[null,12345678,{"$f":"TODAY()","v":"2015-03-06"},8,8,8,0,0,0,0]
[null,92408250,{"$f":"TODAY()","v":"2015-03-06"},10,8,8,0,2,2,0]
[null,90963745,"2015-03-06",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,96097193,"2015-03-06",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,93638537,"2015-03-06",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,98702520,"2015-03-06",10,8,0,8,2,2,0]
[null,95721889,"2015-03-06",8,8,8,0,0,0,0]
[null,92722045,"2015-03-06",10,8,8,0,2,2,0]
[null,97527365,"2015-03-06",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,97070960,"2015-03-06",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94144851,"2015-03-06",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,92931162,"2015-03-06",10,8,0,8,2,2,0]
[null,96554557,"2015-03-06",8,8,8,0,0,0,0]
[null,92456336,"2015-03-06",10,8,8,0,2,2,0]
[null,95807147,"2015-03-06",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,92963879,"2015-03-06",12,8,8,0,4,2.9833333333333343,1.0166666666666657]
[null,94180411,"2015-03-06",8,8,3.9833333333333343,4.0166666666666657,0,0,0]
[null,91666050,"2015-03-06",10,8,0,8,2,2,0]
[null,99166507,"2015-03-06",10,8,0,8,2,2,0]

{"sheet":"Consulta de Turnos por Cédula","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":true,"merged":[[3,1,4,1],[3,2,4,2],[3,3,3,5],[3,6,3,8]]}
[]
[null,"CEDULA",83234777]
[]
[null,"Fecha","Total Laboradas","Ordinarias Laboradas",null,null,"Extras Laboradas"]
[null,null,null,"Total","Diurnas","Nocturnas","Total","Diurnas","Nocturnas"]
[null,"2011-12-23",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,"2011-12-26",9,8,6.9833333333333343,1.0166666666666657,1,0,1]
[null,"2011-12-27",9,8,6.9833333333333343,1.0166666666666657,1,0,1]