{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Calculadora","Nomina","Resumen","Datos","Recibo","Plantilla","D-basicos","Hoja1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":48,"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":"Calculadora","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,4,2]
[1]
[2]
[]
[5]
["NIT: 12345"]
["carre 30 # 44-55 Medellin"]
[3345520]

{"sheet":"Nomina","index":1,"n_rows":65,"n_cols":88,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,53,2,60],[0,16376,1,16379],[1,15,1,16],[1,18,1,22],[1,25,1,34],[1,54,1,60],[2,25,2,34],[2,3,2,15],[2,17,2,22],[2,36,2,47],[2,49,2,52]]}
[null,null,null,null,{"$f":"'D-basicos'!$B$5","v":106454},{"$f":"'D-basicos'!$B$4","v":908526},{"$f":"'D-basicos'!$C$40","v":1.35},{"$f":"'D-basicos'!$C$46","v":2.1},{"$f":"'D-basicos'!$C$41","v":1.25},{"$f":"'D-basicos'!$C$42","v":1.75},{"$f":"'D-basicos'!C44","v":2},{"$f":"'D-basicos'!$C$45","v":2.5},{"$f":"'D-basicos'!$C$43","v":1.75},{"$f":"'D-basicos'!$C$43","v":1.75},null,null,{"$f":"'D-basicos'!$B$15","v":0.04},{"$f":"'D-basicos'!$B$16","v":0.04},{"$f":"'D-basicos'!$B$19","v":0.01},{"$f":"'D-basicos'!$B$20","v":1.2E-2},{"$f":"'D-basicos'!$B$21","v":1.4E-2},{"$f":"'D-basicos'!$B$22","v":1.6E-2},{"$f":"'D-basicos'!$B$23","v":1.7999999999999999E-2},{"$f":"'D-basicos'!$B$4","v":908526},{"$f":"'D-basicos'!$B$5","v":106454},{"$f":"'D-basicos'!$B$8","v":8.3299999999999999E-2},{"$f":"'D-basicos'!$B$9","v":8.3299999999999999E-2},{"$f":"'D-basicos'!$C$10","v":0.12},{"$f":"'D-basicos'!$C$15","v":8.5000000000000006E-2},{"$f":"'D-basicos'!$C$16","v":0.12},{"$f":"'D-basicos'!$B$49","v":0.02},{"$f":"'D-basicos'!$B$50","v":0.03},{"$f":"'D-basicos'!$B$51","v":0.04},{"$f":"'D-basicos'!$C$28","v":5.1999999999999998E-3},{"$f":"'D-basicos'!$B$11","v":4.1700000000000001E-2},{"$f":"Cesantias","v":386771.24},{"$f":"Prima","v":386771.24},{"$f":"Int","v":3867.7123999999994},{"$f":"Salud","v":359018.75},{"$f":"Pension","v":506850},{"$f":"Sena","v":84475},{"$f":"Icbf","v":126712.5},{"$f":"Caja","v":168950},{"$f":"Arp","v":21963.5},{"$f":"'D-basicos'!$C$15","v":8.5000000000000006E-2},null,{"$f":"SUM(AJ1:AL1)","v":777410.19239999994},{"$f":"$AO$1+$AP$1+$AQ$1","v":380137.5},{"$f":"SUM(AU1+AV1)","v":1157547.6924000001},{"$f":"Vaca","v":176130.38},{"$f":"SUM(AM1:AN1)+$AR$1","v":887832.25},{"$f":"SUM(AO1:AQ1)","v":380137.5},{"$f":"($AX$1+$AL$1+$AK$1+$AJ$1)","v":953540.57239999995},{"$f":"($BA$1+$AZ$1+AY1)","v":2221510.3223999999},{"$f":"'D-basicos'!$B$66","v":2684000},{"$f":"'D-basicos'!$C$30","v":31859},{"$f":"'D-basicos'!$C$70","v":0.16},{"$f":"'D-basicos'!$D$70","v":0.25},{"$f":"'D-basicos'!D72","v":0.3},{"$f":"'D-basicos'!$B$72","v":8500000},{"$f":"'D-basicos'!$B$66","v":2684000},{"$f":"'D-basicos'!$B$68","v":858912},{"$f":"'D-basicos'!$D$68","v":0.1},null,{"$f":"'D-basicos'!$B$73","v":6442000},{"$f":"'D-basicos'!$D$73","v":0.25},{"$f":"'D-basicos'!$D$75","v":0.08},{"$f":"'D-basicos'!$C$77","v":1100481},{"$f":"SUM(F6,F7:F66)","v":3950000},{"$f":"SUM(G6,G7:G65)","v":409940},{"$f":"SUM(BB6,BB7:BB66)","v":33750.000000000007},{"$f":"SUM(BC6:BC66)","v":240000},{"$f":"SUM(BI6:BI66)","v":83750},{"$f":"SUM(BL6:BL66)","v":0},{"$f":"SUM(P6:P66)","v":0},{"$f":"SUM(S6:S66)","v":168950},{"$f":"(BX1*2)","v":337900},{"$f":"SUM(U6:U66)","v":0},{"$f":"SUM(AO6:AO66)","v":0},{"$f":"SUM(AL6:AL66)","v":0},{"$f":"SUM(AM6:AM66)","v":0},{"$f":"SUM(AN6:AN66)","v":0},{"$f":"SUM(AP6:AP66)","v":0},{"$f":"SUM(AQ6:AQ66)","v":0},{"$f":"Calculadora!$A$7","v":"carre 30 # 44-55 Medellin"},null,{"$f":"Calculadora!$A$8","v":3345520},{"$f":"'D-basicos'!$C$83","v":3826000}]
[{"$f":"TODAY()","v":"2021-01-08"},{"$f":"Calculadora!$A$6","v":"NIT: 12345"},null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL NETO PAGADO",null,{"$f":"Neto","v":4305212},{"$f":"CONVIERTENUMLETRA(R2)","v":"CUATRO MILLONES TRESCIENTOS CINCO MIL DOSCIENTOS DOCE PESOS 00/100 M.N."},null,null,null,null,null,null,"PROYECCIÓN APORTES PARAFISCALES Y OTRAS APROPIACIONES"]
[null,null,null,"DEVENGADO",null,null,null,null,null,null,null,null,null,null,null,null,null,"DEDUCIONES",null,null,null,null,null,null,null,"APROPIACIONES",null,null,null,null,null,null,null,null,null,null,"CAMPOS VARIADOS",null,null,null,null,null,null,null,null,null,null,null,null,"BASE DE DATOS",null,null,null,"GENERICOS"]
[{"$f":"YEAR(A2)","v":2021},"EMPLEADO",null,"Sueldo Basico","Dias T","Basico","AT","RN","RNF","HED","HEN","HEFD","HEFN","HOF","Factor Salarial","No Constituyen Salario","Total Devengado ","Salud","Pension","Fondo de Solidaridad","RT","Otras Deduciones","Total Deducciones","Neto Pagado",null,"Cesantias","Prima de Servicios","Int. S/Cesantia","Salud","Pension","Sena","ICBF","Caja de Compensanción","ARP","Vacaciones","Laborados","CARGO","Genérico1","Genérico2","Genérico3","Genérico4","Genérico5","Genérico6","Faltas","Genérico7","Genérico8","Genérico10","Genérico11",1,"Nª","Numero","Salario","Generico 12","Generico 13","Generico 14","Generico 15","Generico 16","Generico 17","Generico 18","Generico 19","Generico 20","I.d","Antigüedad","CANTIDAH","EMPLEADOS",null,null,null,"C.C","CCID","Antigüedad","cc","id"," R","VACACIONES ","DIAS ","CESANTIAS ","Dias ","INT CESSANTIAS ","DIAS ","Prima","DIAS "]
[null,"Formulas ",null,0,0,{"$f":"ROUND(+D5/30*E5,3)","v":0},{"$f":"IF(D5=0,0,IF(D5<=2*'D-basicos'!$B$4,'D-basicos'!$B$5/30*Nomina!E5,0))","v":0},{"$f":"(D5/240)*(1 *'D-basicos'!$C$40)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$46)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$41)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$42)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$44)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$45)","v":0},{"$f":"(D5/240)*(1*'D-basicos'!$C$43)","v":0},0,0,{"$f":"SUM(F5:P5)","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$B$15","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$B$16","v":0},null,null,null,{"$f":"SUM(R5:V5)","v":0},{"$f":"Q5-W5","v":0},null,{"$f":"(Q5-P5)*'D-basicos'!$B$8","v":0},{"$f":"(Q5-P5)*'D-basicos'!$B$9","v":0},{"$f":"(Z5*E5*'D-basicos'!$C$10)/360","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$C$15","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$C$16","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$B$49","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$B$50","v":0},{"$f":"(Q5-P5-G5)*'D-basicos'!$B$51","v":0},{"$f":"(Q5-G5-P5)*'D-basicos'!$C$28","v":0},{"$f":"(Q5-G5-P5)*'D-basicos'!$B$11","v":0}," das laborados",null,"Aportes Adicionales Salud, UPC","Aportes voluntarios al Fondo de Pensiones","Descuento por Aportes AFC","Descuentos Por Prestamo","Descuentos Por Aportes a cooperativas ","Descuentos Por Embargos","Diás de descanso, Incapacidad, licencia y no trabajados","Excusa","RUTA","Prestación Económica por Incaoacidad  o Licencia ","Vacaciones ","D:\\Trabajos JEGE\\Aleja\\ALEJANDRA\\Articulos\\imagenes\\Imagen21.jpg",null,"UR","Salario Basico","CARGO","RN","Comisiones","Factor Salarial","1º faltas","2ºfaltas","3ºfaltas","4ºfaltas","Total HE",null,null,"Bonificaciones Y Primas",null,null,null,null,null,"cc","antigüedad",null,null,"RWCARGO NOCTURNO",null,null,null,null,null,null,null,null,null,null,"Aportes Parafiscales",30]
["Enero","Carolina Bargas ",null,950000,30,950000,100000,0,0,0,0,0,0,0,0,0,1050000,38000,38000,0,0,0,76000,974000,null,87465,87465,874.65,80750,114000,19000,28500,38000,4940,39615,30,"Analista ",0,0,0,0,0,0,0,null,"",null,null,"",1,"Yeny Bastidas",1000000,"Secretaria",{"$f":"SUM(H6:I6)","v":0},0,0,null,"/0/0","/0/0",null,{"$f":"SUM(H6:N6)","v":0},".01","2008-04-05",0,{"$f":"AY6","v":"Yeny Bastidas"},{"$f":"AZ6","v":1000000},{"$f":"BA6","v":"Secretaria"},{"$f":"BK6","v":"2008-04-05"},39567345,"CÉDULA DE CIUDADANÍA","02/02/2012","39256348","CÉDULA DE CIUDADANÍA",0,0,0,0,0,0,0,0,0]
["Enero","Yeny Bastidas",null,1000000,30,1000000,97032,0,0,0,50000,0,0,0,100000,0,1206454,44000,44000,0,0,0,88000,1118454,null,100497.62,100497.62,1004.9761999999997,93500,132000,22000,33000,44000,5720,45870,30,"Secretaria",0,0,0,0,0,0,0,null,"",null,null,"",2,null,null,null,{"$f":"SUM(H7:I7)","v":0},100000,0,null,"/0/0","/0/0",null,{"$f":"SUM(H7:N7)","v":50000},".02",null,0,{"$f":"AY7","v":0},0,0,{"$f":"BK7","v":"00:00:00"},null,null,"05/04/2008","39567345","CÉDULA DE CIUDADANÍA",0,0,0,0,0,0,0,0,0]
["Enero","Yeny Bastidas",null,1000000,30,1000000,106454,16875.000000000004,0,0,0,0,0,0,40000,0,1163329,42275,42275,0,0,0,84550,1078779,null,96905.31,96905.31,969.05309999999997,89834.375,126825,21137.5,31706.25,42275,5495.75,44071.69,30,"Secretaria",0,0,0,0,0,0,0,null,"",null,null,"",3,null,null,null,16875.000000000004,40000,0,null,"/0/0","/0/0",null,16875.000000000004,".03",null,0,null,0,0,"00:00:00",null,null,"05/04/2008","39567345","CÉDULA DE CIUDADANÍA",3,0,0,0,0,0,0,0,0]
["Enero","Yeny Bastidas",null,1000000,30,1000000,106454,16875.000000000004,0,0,0,0,0,0,100000,0,1223329,44675,44675,0,0,0,89350,1133979,null,101903.31,101903.31,1019.0330999999999,94934.375,134025,22337.5,33506.25,44675,5807.75,46573.69,30,"Secretaria",0,0,0,0,0,0,0,null,"",null,null,null,4,null,null,null,16875.000000000004,100000,0,null,"/0/0","/0/0",null,16875.000000000004,".04",null,0,0,0,0,"00:00:00",null,null,"05/04/2008","39567345","CÉDULA DE CIUDADANÍA",3,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,0,null,null,null,null,null,null,0,".05",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,0,null,null,null,null,null,null,0,".06",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,0,null,null,null,null,null,null,0,".07",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,0,null,null,null,null,null,null,0,".08",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,0,null,null,null,null,null,null,0,".09",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,0,null,null,null,null,null,null,0,".10",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,0,null,null,null,null,null,null,0,".11",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,0,null,null,null,null,null,null,0,".12",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,0,null,null,null,null,null,null,0,".13",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,0,null,null,null,null,null,null,0,".14",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,0,null,null,null,null,null,null,0,".15",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,0,null,null,null,null,null,null,0,".16",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,null,null,0,null,null,null,null,null,null,0,".17",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,null,0,null,null,null,null,null,null,0,".18",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,0,null,null,null,null,null,null,0,".19",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,0,null,null,null,null,null,null,0,".20",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,null,null,0,null,null,null,null,null,null,0,".21",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,null,null,null,0,null,null,null,null,null,null,0,".22",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,null,null,null,0,null,null,null,null,null,null,0,".23",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,null,0,null,null,null,null,null,null,0,".24",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,null,null,0,null,null,null,null,null,null,0,".25",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,null,null,null,0,null,null,null,null,null,null,0,".26",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,null,null,0,null,null,null,null,null,null,0,".27",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,null,null,null,0,null,null,null,null,null,null,0,".28",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,null,null,null,0,null,null,null,null,null,null,0,".29",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,null,null,0,null,null,null,null,null,null,0,".30",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,null,null,null,0,null,null,null,null,null,null,0,".31",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,null,null,null,{"$f":"SUM(H37:I37)","v":0},null,null,null,null,null,null,0,".32",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,null,null,0,null,null,null,null,null,null,0,".33",null,null,{"$f":"AY38","v":0},{"$f":"AZ38","v":0},{"$f":"BA38","v":0},"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,null,null,null,0,null,null,null,null,null,null,0,".34",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,null,null,null,0,null,null,null,null,null,null,0,".35",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,null,null,null,0,null,null,null,null,null,null,0,".36",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,null,null,null,0,null,null,null,null,null,null,0,".37",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,null,null,null,0,null,null,null,null,null,null,0,".38",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,null,null,null,0,null,null,null,null,null,null,0,".39",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,null,0,null,null,null,null,null,null,0,".40",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,null,null,null,0,null,null,null,null,null,null,0,".41",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,null,null,null,0,null,null,null,null,null,null,0,".42",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,null,null,null,0,null,null,null,null,null,null,0,".43",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,null,null,null,0,null,null,null,null,null,null,0,".44",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,null,null,null,0,null,null,null,null,null,null,0,".45",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46,null,null,null,0,null,null,null,null,null,null,0,".46",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47,null,null,null,0,null,null,null,null,null,null,0,".47",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,null,null,null,0,null,null,null,null,null,null,0,".48",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,null,null,null,0,null,null,null,null,null,null,0,".49",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,0,null,null,null,null,null,null,0,".50",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51,null,null,null,0,null,null,null,null,null,null,0,".51",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52,null,null,null,0,null,null,null,null,null,null,0,".52",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53,null,null,null,0,null,null,null,null,null,null,0,".53",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54,null,null,null,0,null,null,null,null,null,null,0,".54",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,null,null,null,0,null,null,null,null,null,null,0,".55",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,null,null,null,0,null,null,null,null,null,null,0,".56",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57,null,null,null,0,null,null,null,null,null,null,0,".57",null,null,0,0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58,null,null,null,0,null,null,null,null,null,null,0,".58"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59,null,null,null,0,null,null,null,null,null,null,0,".59",null,null,{"$f":"AY64","v":0},0,0,"00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,null,null,null,0,null,null,null,null,null,null,0,".60",null,null,0,0,0,"00:00:00"]

{"sheet":"Resumen","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[5,10,5,16],[3,188,3,189],[0,190,0,193],[1,190,1,193],[2,155,2,161],[2,162,2,169],[0,157,0,168]]}

{"sheet":"Datos","index":3,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,6,6,8],[13,12,13,15],[14,12,14,15],[4,20,4,21],[1,6,1,22],[23,6,23,8],[23,20,23,21],[2,9,2,13],[3,15,3,18],[3,9,3,13],[21,11,21,13],[21,15,21,17],[19,20,19,21],[12,20,12,21],[19,6,19,8],[12,6,12,8],[6,20,6,21]]}
[]
[null,null,null,null,{"$f":"Calculadora!$A$5","v":5}]
[null,null,null,null,null,"SELECIONAR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Periodo:",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!A6:A65)","v":"Enero"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NIT","v":"NIT: 12345"}]
[]
[null,null,null,null,1,"EMPLEADO","Empleados",null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor salarial",null,5]
[null,null,null,null,null,null,"Sueldo Basico",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!D6:D65)","v":950000},null,null,null,null,null,null,null,null,null,null,null,"Total Horas Extras",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BI6:BI65)","v":0}]
[null,null,null,null,null,null,"Salario diá",null,{"$f":"$I$10*8","v":31666.666666666668},null,null,null,null,null,null,null,null,null,null,null,"Total Recargos",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BB6:BB65)","v":0}]
[null,null,null,null,null,null,"Salario hora",null,{"$f":"$I$8/240","v":3958.3333333333335},null,null,null,null,null,null,null,null,null,null,null,"Comisones",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BC6:BC65)","v":0}]
[null,null,null,null,null,null,"Auxilio de T.",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!G6:G65)","v":100000},null,null,null,null,null,null,null,null,null,null,null,"Otros Valores",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BD6:BD65)","v":0}]
[]
[null,null,null,null,2,"Valor Horas Extras ","Valor Horas Extras",null,null,null,null,null,null,null,null,null,null,null,null,null,"Descuentos",null,6]
[null,null,null,null,null,null,"Ordinaria",null,{"$f":"$I$10*'D-basicos'!$C$41","v":4947.916666666667},null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!B6:B65)","v":"Carolina Bargas "},null,null,null,null,null,null,null,"Aportes AFC.",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AN6:AN65)","v":0}]
[null,null,null,null,null,null,"D. Ordinario",null,{"$f":"$I$10*'D-basicos'!$C$44","v":7916.666666666667},null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AK6:AK65)","v":"Analista "},null,null,null,null,null,null,null,"Prestamo",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AO6:AO65)","v":0}]
[null,null,null,null,null,null,"Nocturno",null,{"$f":"$I$10*'D-basicos'!$C$42","v":6927.0833333333339},null,null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AT6:AT65)","v":""},null,null,null,null,null,"Aportes a ccoperativas",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AP6:AP65)","v":0}]
[null,null,null,null,null,null,"D Y f Nocturno",null,{"$f":"$I$10*'D-basicos'!$C$45","v":9895.8333333333339},null,null,null,null,null,null,null,null,null,null,null,"Embargo",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AQ6:AQ65)","v":0}]
[null,null,null,null,null,{"$f":"Calculadora!$C$6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retencion en la fuente",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!U6:U65+Nomina!U6:U65)","v":0}]
[null,null,null,null,null,{"$f":"Calculadora!$C$6","v":0}]
[null,null,null,null,3,"Valor Dominical","Valor Dominical",null,null,null,null,null,null,null,null,null,null,null,null,null,"Aportes",null,7]
[null,null,null,null,null,null,"Ordinario",null,{"$f":"$I$10*'D-basicos'!$C$43","v":6927.0833333333339},null,null,null,null,null,null,null,null,null,null,null,"Salud (UPC)",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AL6:AL65)","v":0}]
[null,null,null,null,null,null,"Nocturno",null,{"$f":"$I$10*'D-basicos'!$C$46","v":8312.5},null,null,"Dias T.",null,null,null,"Faltas",null,null,null,null,"Fondo de Pensiones",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AM6:AM65)","v":0}]
[null,null,null,null,null,{"$f":"Calculadora!$C$6","v":0}]
[null,null,null,null,4,"Seguridad Social","Otras Apropiaciones",null,null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!E6:E65)","v":30},null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AJ6:AJ65)","v":30},null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AR6:AR65)","v":0},null,null,null,"Factor No Salarial",null,8]
[null,null,null,null,null,null,"Salud",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!R6:R65)","v":38000},null,null,null,null,null,null,null,null,null,null,null,"Total Valores",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!P6:P65)","v":0}]
[null,null,null,null,null,null,"Pension",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!R6:R65)","v":38000}]
[null,null,null,null,null,null,"Vacaciones",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AI6:AI65)","v":39615},null,null,null,null,null,{"$f":"Calculadora!$A$2","v":1},null,null,null,null,null,"Asistencia","Fecha",9]
[null,null,null,null,null,null,"ARP",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AH6:AH65)","v":4940},null,null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AS6:AS65)","v":0},null,null,null,null,null,"1º  Falta",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BF6:BF65)","v":"/0/0"}]
[null,null,null,null,null,null,"Prima de Servicios",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!AA6:AA65)","v":87465},null,null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BE6:BE65)","v":0},null,null,null,null,null,"2º Falta",{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BG6:BG65)","v":"/0/0"}]
[null,null,null,null,null,null,"Cesantias",null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!Z6:Z65)","v":87465}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!X6:X65)","v":974000}]

{"sheet":"Recibo","index":4,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,2,1,2],[5,8,5,9],[3,3,3,7],[38,8,38,9],[10,7,10,9],[8,4,8,6],[8,1,8,3],[5,1,5,2],[6,4,6,6],[7,4,7,6],[7,1,7,3],[6,1,6,3],[9,4,9,6],[38,4,38,5],[2,1,2,2]]}
[null,null,{"$f":"CONCATENATE(\"RECIBO DE PAGO \",B10)","v":"RECIBO DE PAGO Carolina Bargas "}]
[]
[null,{"$f":"NIT","v":"NIT: 12345"}]
[null,{"$f":"CONCATENATE(\"Detalles del Pago\", Datos!M14)","v":"Detalles del PagoCarolina Bargas "}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"PERIODO CAUSADO"]
[null,"EMPRESA",null,null,"DIRECCIÓN",null,null,"TELEFONO","DEL ","Al "]
[null,"San  JorgePlus",null,null,{"$f":"Dirección","v":"carre 30 # 44-55 Medellin"},null,null,{"$f":"Telefono","v":3345520},"2021-12-01","2021-12-15"]
[null,"EMPLEADO",null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BU6:BU65)","v":"CÉDULA DE CIUDADANÍA"},null,null,"PUESTO","ANTIGÜEDAD","TOTAL DIÁS"]
[null,{"$f":"Datos!M$14","v":"Carolina Bargas "},null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BT6:BT65)","v":"39256348"},null,null,{"$f":"Datos!$M$15","v":"Analista "},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BS6:BS65)","v":"02/02/2012"},{"$f":"Datos!$M$24","v":30}]
[null,null,null,null,null,null,null,"Valor de la Operación"]
[null,"CANTIDAD",null,"CONCEPTO",null,null,null,"CANTIDAD","DEBITO","CREDITO"]
[null,25050505,"SALARIOS POR PAGAR",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"Datos!$I$8","v":950000},null,null,{"$f":"$I$13","v":950000},950000]
[null,25150505,"INTERESES A LA CESANTIAS POR PAGAR",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!CB6:CB65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!CA6:CA65)","v":0},null,null,{"$f":"$I$14","v":0},0]
[null,25056905,"APORTES E.P.S. ",null,null,null,null,{"$f":"$J$10","v":30},0,{"$f":"Datos!$I$25","v":38000},null,{"$f":"$J$15","v":38000},38000]
[null,23803005,"APORTES A FONDOS DE PENSION ",null,null,null,null,{"$f":"$J$10","v":30},0,{"$f":"Datos!$I$26","v":38000},null,{"$f":"$J$16","v":38000},38000]
[null,510527,"AUXILIO DE TRANSPORTE",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"Datos!$I$11","v":100000},null,null,{"$f":"$I$17","v":100000},106454]
[null,233520,"COMISIONES",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BC6:BC65)","v":0},null,null,{"$f":"$I$18","v":0},0]
[null,25200505,"PRIMA DE SERVICIOS",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!CD6:CD65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!CC6:CC65)","v":0},null,null,{"$f":"$I$19","v":0},0]
[null,253020,"BONIFICACIONES HABITUALES",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BD6:BD65)","v":0},null,null,{"$f":"$I$20","v":0},0]
[null,510515,"HORAS EXTRAS ",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BL6:BL65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BI6:BI65)","v":0},null,null,{"$f":"$I$21","v":0},0]
[null,25250505,"VACACIONES POR PAGAR",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BX6:BX65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BW6:BW65)","v":0},null,null,{"$f":"$H$22","v":0},0]
[null,236505,"RETEFUENTE SALARIOS",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"Datos!$V$18","v":0},null,null,{"$f":"$I$23","v":0},0]
[null,237045,"PRESTAMO",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"Datos!$V$15","v":0},null,null,{"$f":"$I$24","v":0},0]
[null,25100505,"CESANTIAS POR PAGAR",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BZ6:BZ65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BY6:BY65)","v":0},null,null,{"$f":"$I$25","v":0},0]
[null,237005,"APORTES SALUD (UPC)",null,null,null,null,{"$f":"$J$10","v":30},{"$f":"Datos!$V$21","v":0},null,null,{"$f":"$I$26","v":0},0]
[null,237005,"APORTES VOLUNTARIOS PENSION",null,null,null,null,30,{"$f":"Datos!$V$22","v":0},null,null,{"$f":"$I$27","v":0},0]
[null,237040,"APORTES A COOPERATIVA",null,null,null,null,30,{"$f":"Datos!$V$16","v":0},null,null,{"$f":"$I$28","v":0},0]
[null,237015,"APORTES AFC",null,null,null,null,30,{"$f":"Datos!$V$14","v":0},null,null,{"$f":"$I$29","v":0},0]
[null,237095,"OTRAS",null,null,null,null,30,{"$f":"Datos!$V$25","v":0},null,null,{"$f":"$I$30","v":0},0]
[null,237025,"EMBARGO",null,null,null,null,30,{"$f":"Datos!$V$17","v":0},null,null,{"$f":"$I$31","v":0},0]
[null,510515,"RECARGOS ",null,null,null,null,{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BV6:BV65)","v":0},{"$f":"LOOKUP(Nomina!AW4,Nomina!AX6:AX65,Nomina!BB6:BB65)","v":0},null,null,{"$f":"$I$32","v":0},0]
[null,11100502,"BANCO ",null,null,null,null,null,null,{"$f":"Datos!$O$32+I22+$I$25+$I$14+$I$19","v":974000}]
[null,null,null,null,null,null,null,"TOTALES",{"$f":"SUM(I13:I33)","v":1050000},{"$f":"SUM(J13:J33)","v":1050000}]
[]
[null,null,null,null,null,null,null,"A PAGAR",null,{"$f":"+J33","v":974000}]

{"sheet":"Plantilla","index":5,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,1,86,8],[73,10,73,13],[80,15,80,16],[68,12,68,13],[69,12,69,13],[79,10,79,16],[75,12,75,13],[70,12,70,13],[71,12,71,13],[72,12,72,13],[74,7,74,8],[69,7,69,8],[70,7,70,8],[79,5,79,8],[65,15,65,16],[77,10,77,13],[2,8,2,9],[3,6,3,7],[77,2,77,3],[67,4,67,8],[71,7,71,8],[72,7,72,8],[67,10,67,16],[73,7,73,8],[75,7,75,8],[68,7,68,8],[77,4,77,8],[2,6,2,7],[2,14,3,14]]}
[null,null,{"$f":"CONCATENATE(Nomina!A6,\" del \",Nomina!A4)","v":"Enero del 2021"}]
[null,null,{"$f":"NIT","v":"NIT: 12345"}]
[null,null,"San  JorgePlus",null,null,null,null,null,null,null,null,null,null,null,null,"Desde:","2021-02-01"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"Hasta:","2021-02-01"]
[null,"Nº","EMPLEADO                                            Nombre y Apellido","Salario  Base","Lab","Liq","                  Basico","Aux. Transporte","H.E","Comisiones"," Devengado","Salud","Pension","Otras "," Deduciones"," Pagado","(Firma y CC)",null,5]
[null,1,{"$f":"IF(Nomina!B6=\"\",0,Nomina!B6)","v":"Carolina Bargas "},{"$f":"IF(Nomina!D6=\"\",0,Nomina!D6)","v":950000},{"$f":"IF(Nomina!AJ6=\"\",0,Nomina!AJ6)","v":30},{"$f":"IF(Nomina!E6=\"\",0,Nomina!E6)","v":30},{"$f":"IF(Nomina!F6=\"\",0,Nomina!F6)","v":950000},{"$f":"IF(Nomina!G6=\"\",0,Nomina!G6)","v":100000},{"$f":"IF(Nomina!BI6=\"\",0,Nomina!BI6)","v":0},{"$f":"IF(Nomina!BC6=\"\",0,Nomina!BC6)","v":0},{"$f":"IF(Nomina!Q6=\"\",0,Nomina!Q6)","v":1050000},{"$f":"IF(Nomina!R6=\"\",0,Nomina!R6)","v":38000},{"$f":"IF(Nomina!R6=\"\",0,Nomina!S6)","v":38000},{"$f":"IF(Nomina!V6=\"\",0,Nomina!V6)","v":0},{"$f":"IF(Nomina!W6=\"\",0,Nomina!W6)","v":76000},{"$f":"IF(Nomina!X6=\"\",0,Nomina!X6)","v":974000}]
[null,2,{"$f":"IF(Nomina!B7=\"\",0,Nomina!B7)","v":"Yeny Bastidas"},{"$f":"IF(Nomina!D7=\"\",0,Nomina!D7)","v":1000000},{"$f":"IF(Nomina!AJ7=\"\",0,Nomina!AJ7)","v":30},{"$f":"IF(Nomina!E7=\"\",0,Nomina!E7)","v":30},{"$f":"IF(Nomina!F7=\"\",0,Nomina!F7)","v":1000000},{"$f":"IF(Nomina!G7=\"\",0,Nomina!G7)","v":97032},{"$f":"IF(Nomina!BI7=\"\",0,Nomina!BI7)","v":50000},{"$f":"IF(Nomina!BC7=\"\",0,Nomina!BC7)","v":100000},{"$f":"IF(Nomina!Q7=\"\",0,Nomina!Q7)","v":1206454},{"$f":"IF(Nomina!R7=\"\",0,Nomina!R7)","v":44000},{"$f":"IF(Nomina!R7=\"\",0,Nomina!S7)","v":44000},{"$f":"IF(Nomina!V7=\"\",0,Nomina!V7)","v":0},{"$f":"IF(Nomina!W7=\"\",0,Nomina!W7)","v":88000},{"$f":"IF(Nomina!X7=\"\",0,Nomina!X7)","v":1118454}]
[null,3,{"$f":"IF(Nomina!B8=\"\",0,Nomina!B8)","v":"Yeny Bastidas"},{"$f":"IF(Nomina!D8=\"\",0,Nomina!D8)","v":1000000},{"$f":"IF(Nomina!AJ8=\"\",0,Nomina!AJ8)","v":30},{"$f":"IF(Nomina!E8=\"\",0,Nomina!E8)","v":30},{"$f":"IF(Nomina!F8=\"\",0,Nomina!F8)","v":1000000},{"$f":"IF(Nomina!G8=\"\",0,Nomina!G8)","v":106454},{"$f":"IF(Nomina!BI8=\"\",0,Nomina!BI8)","v":16875.000000000004},{"$f":"IF(Nomina!BC8=\"\",0,Nomina!BC8)","v":40000},{"$f":"IF(Nomina!Q8=\"\",0,Nomina!Q8)","v":1163329},{"$f":"IF(Nomina!R8=\"\",0,Nomina!R8)","v":42275},{"$f":"IF(Nomina!R8=\"\",0,Nomina!S8)","v":42275},{"$f":"IF(Nomina!V8=\"\",0,Nomina!V8)","v":0},{"$f":"IF(Nomina!W8=\"\",0,Nomina!W8)","v":84550},{"$f":"IF(Nomina!X8=\"\",0,Nomina!X8)","v":1078779}]
[null,4,{"$f":"IF(Nomina!B9=\"\",0,Nomina!B9)","v":"Yeny Bastidas"},{"$f":"IF(Nomina!D9=\"\",0,Nomina!D9)","v":1000000},{"$f":"IF(Nomina!AJ9=\"\",0,Nomina!AJ9)","v":30},{"$f":"IF(Nomina!E9=\"\",0,Nomina!E9)","v":30},{"$f":"IF(Nomina!F9=\"\",0,Nomina!F9)","v":1000000},{"$f":"IF(Nomina!G9=\"\",0,Nomina!G9)","v":106454},{"$f":"IF(Nomina!BI9=\"\",0,Nomina!BI9)","v":16875.000000000004},{"$f":"IF(Nomina!BC9=\"\",0,Nomina!BC9)","v":100000},{"$f":"IF(Nomina!Q9=\"\",0,Nomina!Q9)","v":1223329},{"$f":"IF(Nomina!R9=\"\",0,Nomina!R9)","v":44675},{"$f":"IF(Nomina!R9=\"\",0,Nomina!S9)","v":44675},{"$f":"IF(Nomina!V9=\"\",0,Nomina!V9)","v":0},{"$f":"IF(Nomina!W9=\"\",0,Nomina!W9)","v":89350},{"$f":"IF(Nomina!X9=\"\",0,Nomina!X9)","v":1133979}]
[null,5,{"$f":"IF(Nomina!B10=\"\",0,Nomina!B10)","v":0},{"$f":"IF(Nomina!D10=\"\",0,Nomina!D10)","v":0},{"$f":"IF(Nomina!AJ10=\"\",0,Nomina!AJ10)","v":0},{"$f":"IF(Nomina!E10=\"\",0,Nomina!E10)","v":0},{"$f":"IF(Nomina!F10=\"\",0,Nomina!F10)","v":0},{"$f":"IF(Nomina!G10=\"\",0,Nomina!G10)","v":0},{"$f":"IF(Nomina!BI10=\"\",0,Nomina!BI10)","v":0},{"$f":"IF(Nomina!BC10=\"\",0,Nomina!BC10)","v":0},{"$f":"IF(Nomina!Q10=\"\",0,Nomina!Q10)","v":0},{"$f":"IF(Nomina!R10=\"\",0,Nomina!R10)","v":0},{"$f":"IF(Nomina!R10=\"\",0,Nomina!S10)","v":0},{"$f":"IF(Nomina!V10=\"\",0,Nomina!V10)","v":0},{"$f":"IF(Nomina!W10=\"\",0,Nomina!W10)","v":0},{"$f":"IF(Nomina!X10=\"\",0,Nomina!X10)","v":0}]
[null,6,{"$f":"IF(Nomina!B11=\"\",0,Nomina!B11)","v":0},{"$f":"IF(Nomina!D11=\"\",0,Nomina!D11)","v":0},{"$f":"IF(Nomina!AJ11=\"\",0,Nomina!AJ11)","v":0},{"$f":"IF(Nomina!E11=\"\",0,Nomina!E11)","v":0},{"$f":"IF(Nomina!F11=\"\",0,Nomina!F11)","v":0},{"$f":"IF(Nomina!G11=\"\",0,Nomina!G11)","v":0},{"$f":"IF(Nomina!BI11=\"\",0,Nomina!BI11)","v":0},{"$f":"IF(Nomina!BC11=\"\",0,Nomina!BC11)","v":0},{"$f":"IF(Nomina!Q11=\"\",0,Nomina!Q11)","v":0},{"$f":"IF(Nomina!R11=\"\",0,Nomina!R11)","v":0},{"$f":"IF(Nomina!R11=\"\",0,Nomina!S11)","v":0},{"$f":"IF(Nomina!V11=\"\",0,Nomina!V11)","v":0},{"$f":"IF(Nomina!W11=\"\",0,Nomina!W11)","v":0},{"$f":"IF(Nomina!X11=\"\",0,Nomina!X11)","v":0}]
[null,7,{"$f":"IF(Nomina!B12=\"\",0,Nomina!B12)","v":0},{"$f":"IF(Nomina!D12=\"\",0,Nomina!D12)","v":0},{"$f":"IF(Nomina!AJ12=\"\",0,Nomina!AJ12)","v":0},{"$f":"IF(Nomina!E12=\"\",0,Nomina!E12)","v":0},{"$f":"IF(Nomina!F12=\"\",0,Nomina!F12)","v":0},{"$f":"IF(Nomina!G12=\"\",0,Nomina!G12)","v":0},{"$f":"IF(Nomina!BI12=\"\",0,Nomina!BI12)","v":0},{"$f":"IF(Nomina!BC12=\"\",0,Nomina!BC12)","v":0},{"$f":"IF(Nomina!Q12=\"\",0,Nomina!Q12)","v":0},{"$f":"IF(Nomina!R12=\"\",0,Nomina!R12)","v":0},{"$f":"IF(Nomina!R12=\"\",0,Nomina!S12)","v":0},{"$f":"IF(Nomina!V12=\"\",0,Nomina!V12)","v":0},{"$f":"IF(Nomina!W12=\"\",0,Nomina!W12)","v":0},{"$f":"IF(Nomina!X12=\"\",0,Nomina!X12)","v":0}]
[null,8,{"$f":"IF(Nomina!B13=\"\",0,Nomina!B13)","v":0},{"$f":"IF(Nomina!D13=\"\",0,Nomina!D13)","v":0},{"$f":"IF(Nomina!AJ13=\"\",0,Nomina!AJ13)","v":0},{"$f":"IF(Nomina!E13=\"\",0,Nomina!E13)","v":0},{"$f":"IF(Nomina!F13=\"\",0,Nomina!F13)","v":0},{"$f":"IF(Nomina!G13=\"\",0,Nomina!G13)","v":0},{"$f":"IF(Nomina!BI13=\"\",0,Nomina!BI13)","v":0},{"$f":"IF(Nomina!BC13=\"\",0,Nomina!BC13)","v":0},{"$f":"IF(Nomina!Q13=\"\",0,Nomina!Q13)","v":0},{"$f":"IF(Nomina!R13=\"\",0,Nomina!R13)","v":0},{"$f":"IF(Nomina!R13=\"\",0,Nomina!S13)","v":0},{"$f":"IF(Nomina!V13=\"\",0,Nomina!V13)","v":0},{"$f":"IF(Nomina!W13=\"\",0,Nomina!W13)","v":0},{"$f":"IF(Nomina!X13=\"\",0,Nomina!X13)","v":0}]
[null,9,{"$f":"IF(Nomina!B14=\"\",0,Nomina!B14)","v":0},{"$f":"IF(Nomina!D14=\"\",0,Nomina!D14)","v":0},{"$f":"IF(Nomina!AJ14=\"\",0,Nomina!AJ14)","v":0},{"$f":"IF(Nomina!E14=\"\",0,Nomina!E14)","v":0},{"$f":"IF(Nomina!F14=\"\",0,Nomina!F14)","v":0},{"$f":"IF(Nomina!G14=\"\",0,Nomina!G14)","v":0},{"$f":"IF(Nomina!BI14=\"\",0,Nomina!BI14)","v":0},{"$f":"IF(Nomina!BC14=\"\",0,Nomina!BC14)","v":0},{"$f":"IF(Nomina!Q14=\"\",0,Nomina!Q14)","v":0},{"$f":"IF(Nomina!R14=\"\",0,Nomina!R14)","v":0},{"$f":"IF(Nomina!R14=\"\",0,Nomina!S14)","v":0},{"$f":"IF(Nomina!V14=\"\",0,Nomina!V14)","v":0},{"$f":"IF(Nomina!W14=\"\",0,Nomina!W14)","v":0},{"$f":"IF(Nomina!X14=\"\",0,Nomina!X14)","v":0}]
[null,10,{"$f":"IF(Nomina!B15=\"\",0,Nomina!B15)","v":0},{"$f":"IF(Nomina!D15=\"\",0,Nomina!D15)","v":0},{"$f":"IF(Nomina!AJ15=\"\",0,Nomina!AJ15)","v":0},{"$f":"IF(Nomina!E15=\"\",0,Nomina!E15)","v":0},{"$f":"IF(Nomina!F15=\"\",0,Nomina!F15)","v":0},{"$f":"IF(Nomina!G15=\"\",0,Nomina!G15)","v":0},{"$f":"IF(Nomina!BI15=\"\",0,Nomina!BI15)","v":0},{"$f":"IF(Nomina!BC15=\"\",0,Nomina!BC15)","v":0},{"$f":"IF(Nomina!Q15=\"\",0,Nomina!Q15)","v":0},{"$f":"IF(Nomina!R15=\"\",0,Nomina!R15)","v":0},{"$f":"IF(Nomina!R15=\"\",0,Nomina!S15)","v":0},{"$f":"IF(Nomina!V15=\"\",0,Nomina!V15)","v":0},{"$f":"IF(Nomina!W15=\"\",0,Nomina!W15)","v":0},{"$f":"IF(Nomina!X15=\"\",0,Nomina!X15)","v":0}]
[null,11,{"$f":"IF(Nomina!B16=\"\",0,Nomina!B16)","v":0},{"$f":"IF(Nomina!D16=\"\",0,Nomina!D16)","v":0},{"$f":"IF(Nomina!AJ16=\"\",0,Nomina!AJ16)","v":0},{"$f":"IF(Nomina!E16=\"\",0,Nomina!E16)","v":0},{"$f":"IF(Nomina!F16=\"\",0,Nomina!F16)","v":0},{"$f":"IF(Nomina!G16=\"\",0,Nomina!G16)","v":0},{"$f":"IF(Nomina!BI16=\"\",0,Nomina!BI16)","v":0},{"$f":"IF(Nomina!BC16=\"\",0,Nomina!BC16)","v":0},{"$f":"IF(Nomina!Q16=\"\",0,Nomina!Q16)","v":0},{"$f":"IF(Nomina!R16=\"\",0,Nomina!R16)","v":0},{"$f":"IF(Nomina!R16=\"\",0,Nomina!S16)","v":0},{"$f":"IF(Nomina!V16=\"\",0,Nomina!V16)","v":0},{"$f":"IF(Nomina!W16=\"\",0,Nomina!W16)","v":0},{"$f":"IF(Nomina!X16=\"\",0,Nomina!X16)","v":0}]
[null,12,{"$f":"IF(Nomina!B17=\"\",0,Nomina!B17)","v":0},{"$f":"IF(Nomina!D17=\"\",0,Nomina!D17)","v":0},{"$f":"IF(Nomina!AJ17=\"\",0,Nomina!AJ17)","v":0},{"$f":"IF(Nomina!E17=\"\",0,Nomina!E17)","v":0},{"$f":"IF(Nomina!F17=\"\",0,Nomina!F17)","v":0},{"$f":"IF(Nomina!G17=\"\",0,Nomina!G17)","v":0},{"$f":"IF(Nomina!BI17=\"\",0,Nomina!BI17)","v":0},{"$f":"IF(Nomina!BC17=\"\",0,Nomina!BC17)","v":0},{"$f":"IF(Nomina!Q17=\"\",0,Nomina!Q17)","v":0},{"$f":"IF(Nomina!R17=\"\",0,Nomina!R17)","v":0},{"$f":"IF(Nomina!R17=\"\",0,Nomina!S17)","v":0},{"$f":"IF(Nomina!V17=\"\",0,Nomina!V17)","v":0},{"$f":"IF(Nomina!W17=\"\",0,Nomina!W17)","v":0},{"$f":"IF(Nomina!X17=\"\",0,Nomina!X17)","v":0}]
[null,13,{"$f":"IF(Nomina!B18=\"\",0,Nomina!B18)","v":0},{"$f":"IF(Nomina!D18=\"\",0,Nomina!D18)","v":0},{"$f":"IF(Nomina!AJ18=\"\",0,Nomina!AJ18)","v":0},{"$f":"IF(Nomina!E18=\"\",0,Nomina!E18)","v":0},{"$f":"IF(Nomina!F18=\"\",0,Nomina!F18)","v":0},{"$f":"IF(Nomina!G18=\"\",0,Nomina!G18)","v":0},{"$f":"IF(Nomina!BI18=\"\",0,Nomina!BI18)","v":0},{"$f":"IF(Nomina!BC18=\"\",0,Nomina!BC18)","v":0},{"$f":"IF(Nomina!Q18=\"\",0,Nomina!Q18)","v":0},{"$f":"IF(Nomina!R18=\"\",0,Nomina!R18)","v":0},{"$f":"IF(Nomina!R18=\"\",0,Nomina!S18)","v":0},{"$f":"IF(Nomina!V18=\"\",0,Nomina!V18)","v":0},{"$f":"IF(Nomina!W18=\"\",0,Nomina!W18)","v":0},{"$f":"IF(Nomina!X18=\"\",0,Nomina!X18)","v":0}]
[null,14,{"$f":"IF(Nomina!B19=\"\",0,Nomina!B19)","v":0},{"$f":"IF(Nomina!D19=\"\",0,Nomina!D19)","v":0},{"$f":"IF(Nomina!AJ19=\"\",0,Nomina!AJ19)","v":0},{"$f":"IF(Nomina!E19=\"\",0,Nomina!E19)","v":0},{"$f":"IF(Nomina!F19=\"\",0,Nomina!F19)","v":0},{"$f":"IF(Nomina!G19=\"\",0,Nomina!G19)","v":0},{"$f":"IF(Nomina!BI19=\"\",0,Nomina!BI19)","v":0},{"$f":"IF(Nomina!BC19=\"\",0,Nomina!BC19)","v":0},{"$f":"IF(Nomina!Q19=\"\",0,Nomina!Q19)","v":0},{"$f":"IF(Nomina!R19=\"\",0,Nomina!R19)","v":0},{"$f":"IF(Nomina!R19=\"\",0,Nomina!S19)","v":0},{"$f":"IF(Nomina!V19=\"\",0,Nomina!V19)","v":0},{"$f":"IF(Nomina!W19=\"\",0,Nomina!W19)","v":0},{"$f":"IF(Nomina!X19=\"\",0,Nomina!X19)","v":0}]
[null,15,{"$f":"IF(Nomina!B20=\"\",0,Nomina!B20)","v":0},{"$f":"IF(Nomina!D20=\"\",0,Nomina!D20)","v":0},{"$f":"IF(Nomina!AJ20=\"\",0,Nomina!AJ20)","v":0},{"$f":"IF(Nomina!E20=\"\",0,Nomina!E20)","v":0},{"$f":"IF(Nomina!F20=\"\",0,Nomina!F20)","v":0},{"$f":"IF(Nomina!G20=\"\",0,Nomina!G20)","v":0},{"$f":"IF(Nomina!BI20=\"\",0,Nomina!BI20)","v":0},{"$f":"IF(Nomina!BC20=\"\",0,Nomina!BC20)","v":0},{"$f":"IF(Nomina!Q20=\"\",0,Nomina!Q20)","v":0},{"$f":"IF(Nomina!R20=\"\",0,Nomina!R20)","v":0},{"$f":"IF(Nomina!R20=\"\",0,Nomina!S20)","v":0},{"$f":"IF(Nomina!V20=\"\",0,Nomina!V20)","v":0},{"$f":"IF(Nomina!W20=\"\",0,Nomina!W20)","v":0},{"$f":"IF(Nomina!X20=\"\",0,Nomina!X20)","v":0}]
[null,16,{"$f":"IF(Nomina!B21=\"\",0,Nomina!B21)","v":0},{"$f":"IF(Nomina!D21=\"\",0,Nomina!D21)","v":0},{"$f":"IF(Nomina!AJ21=\"\",0,Nomina!AJ21)","v":0},{"$f":"IF(Nomina!E21=\"\",0,Nomina!E21)","v":0},{"$f":"IF(Nomina!F21=\"\",0,Nomina!F21)","v":0},{"$f":"IF(Nomina!G21=\"\",0,Nomina!G21)","v":0},{"$f":"IF(Nomina!BI21=\"\",0,Nomina!BI21)","v":0},{"$f":"IF(Nomina!BC21=\"\",0,Nomina!BC21)","v":0},{"$f":"IF(Nomina!Q21=\"\",0,Nomina!Q21)","v":0},{"$f":"IF(Nomina!R21=\"\",0,Nomina!R21)","v":0},{"$f":"IF(Nomina!R21=\"\",0,Nomina!S21)","v":0},{"$f":"IF(Nomina!V21=\"\",0,Nomina!V21)","v":0},{"$f":"IF(Nomina!W21=\"\",0,Nomina!W21)","v":0},{"$f":"IF(Nomina!X21=\"\",0,Nomina!X21)","v":0}]
[null,17,{"$f":"IF(Nomina!B22=\"\",0,Nomina!B22)","v":0},{"$f":"IF(Nomina!D22=\"\",0,Nomina!D22)","v":0},{"$f":"IF(Nomina!AJ22=\"\",0,Nomina!AJ22)","v":0},{"$f":"IF(Nomina!E22=\"\",0,Nomina!E22)","v":0},{"$f":"IF(Nomina!F22=\"\",0,Nomina!F22)","v":0},{"$f":"IF(Nomina!G22=\"\",0,Nomina!G22)","v":0},{"$f":"IF(Nomina!BI22=\"\",0,Nomina!BI22)","v":0},{"$f":"IF(Nomina!BC22=\"\",0,Nomina!BC22)","v":0},{"$f":"IF(Nomina!Q22=\"\",0,Nomina!Q22)","v":0},{"$f":"IF(Nomina!R22=\"\",0,Nomina!R22)","v":0},{"$f":"IF(Nomina!R22=\"\",0,Nomina!S22)","v":0},{"$f":"IF(Nomina!V22=\"\",0,Nomina!V22)","v":0},{"$f":"IF(Nomina!W22=\"\",0,Nomina!W22)","v":0},{"$f":"IF(Nomina!X22=\"\",0,Nomina!X22)","v":0}]
[null,18,{"$f":"IF(Nomina!B23=\"\",0,Nomina!B23)","v":0},{"$f":"IF(Nomina!D23=\"\",0,Nomina!D23)","v":0},{"$f":"IF(Nomina!AJ23=\"\",0,Nomina!AJ23)","v":0},{"$f":"IF(Nomina!E23=\"\",0,Nomina!E23)","v":0},{"$f":"IF(Nomina!F23=\"\",0,Nomina!F23)","v":0},{"$f":"IF(Nomina!G23=\"\",0,Nomina!G23)","v":0},{"$f":"IF(Nomina!BI23=\"\",0,Nomina!BI23)","v":0},{"$f":"IF(Nomina!BC23=\"\",0,Nomina!BC23)","v":0},{"$f":"IF(Nomina!Q23=\"\",0,Nomina!Q23)","v":0},{"$f":"IF(Nomina!R23=\"\",0,Nomina!R23)","v":0},{"$f":"IF(Nomina!R23=\"\",0,Nomina!S23)","v":0},{"$f":"IF(Nomina!V23=\"\",0,Nomina!V23)","v":0},{"$f":"IF(Nomina!W23=\"\",0,Nomina!W23)","v":0},{"$f":"IF(Nomina!X23=\"\",0,Nomina!X23)","v":0}]
[null,19,{"$f":"IF(Nomina!B24=\"\",0,Nomina!B24)","v":0},{"$f":"IF(Nomina!D24=\"\",0,Nomina!D24)","v":0},{"$f":"IF(Nomina!AJ24=\"\",0,Nomina!AJ24)","v":0},{"$f":"IF(Nomina!E24=\"\",0,Nomina!E24)","v":0},{"$f":"IF(Nomina!F24=\"\",0,Nomina!F24)","v":0},{"$f":"IF(Nomina!G24=\"\",0,Nomina!G24)","v":0},{"$f":"IF(Nomina!BI24=\"\",0,Nomina!BI24)","v":0},{"$f":"IF(Nomina!BC24=\"\",0,Nomina!BC24)","v":0},{"$f":"IF(Nomina!Q24=\"\",0,Nomina!Q24)","v":0},{"$f":"IF(Nomina!R24=\"\",0,Nomina!R24)","v":0},{"$f":"IF(Nomina!R24=\"\",0,Nomina!S24)","v":0},{"$f":"IF(Nomina!V24=\"\",0,Nomina!V24)","v":0},{"$f":"IF(Nomina!W24=\"\",0,Nomina!W24)","v":0},{"$f":"IF(Nomina!X24=\"\",0,Nomina!X24)","v":0}]
[null,20,{"$f":"IF(Nomina!B25=\"\",0,Nomina!B25)","v":0},{"$f":"IF(Nomina!D25=\"\",0,Nomina!D25)","v":0},{"$f":"IF(Nomina!AJ25=\"\",0,Nomina!AJ25)","v":0},{"$f":"IF(Nomina!E25=\"\",0,Nomina!E25)","v":0},{"$f":"IF(Nomina!F25=\"\",0,Nomina!F25)","v":0},{"$f":"IF(Nomina!G25=\"\",0,Nomina!G25)","v":0},{"$f":"IF(Nomina!BI25=\"\",0,Nomina!BI25)","v":0},{"$f":"IF(Nomina!BC25=\"\",0,Nomina!BC25)","v":0},{"$f":"IF(Nomina!Q25=\"\",0,Nomina!Q25)","v":0},{"$f":"IF(Nomina!R25=\"\",0,Nomina!R25)","v":0},{"$f":"IF(Nomina!R25=\"\",0,Nomina!S25)","v":0},{"$f":"IF(Nomina!V25=\"\",0,Nomina!V25)","v":0},{"$f":"IF(Nomina!W25=\"\",0,Nomina!W25)","v":0},{"$f":"IF(Nomina!X25=\"\",0,Nomina!X25)","v":0}]
[null,21,{"$f":"IF(Nomina!B26=\"\",0,Nomina!B26)","v":0},{"$f":"IF(Nomina!D26=\"\",0,Nomina!D26)","v":0},{"$f":"IF(Nomina!AJ26=\"\",0,Nomina!AJ26)","v":0},{"$f":"IF(Nomina!E26=\"\",0,Nomina!E26)","v":0},{"$f":"IF(Nomina!F26=\"\",0,Nomina!F26)","v":0},{"$f":"IF(Nomina!G26=\"\",0,Nomina!G26)","v":0},{"$f":"IF(Nomina!BI26=\"\",0,Nomina!BI26)","v":0},{"$f":"IF(Nomina!BC26=\"\",0,Nomina!BC26)","v":0},{"$f":"IF(Nomina!Q26=\"\",0,Nomina!Q26)","v":0},{"$f":"IF(Nomina!R26=\"\",0,Nomina!R26)","v":0},{"$f":"IF(Nomina!R26=\"\",0,Nomina!S26)","v":0},{"$f":"IF(Nomina!V26=\"\",0,Nomina!V26)","v":0},{"$f":"IF(Nomina!W26=\"\",0,Nomina!W26)","v":0},{"$f":"IF(Nomina!X26=\"\",0,Nomina!X26)","v":0}]
[null,22,{"$f":"IF(Nomina!B27=\"\",0,Nomina!B27)","v":0},{"$f":"IF(Nomina!D27=\"\",0,Nomina!D27)","v":0},{"$f":"IF(Nomina!AJ27=\"\",0,Nomina!AJ27)","v":0},{"$f":"IF(Nomina!E27=\"\",0,Nomina!E27)","v":0},{"$f":"IF(Nomina!F27=\"\",0,Nomina!F27)","v":0},{"$f":"IF(Nomina!G27=\"\",0,Nomina!G27)","v":0},{"$f":"IF(Nomina!BI27=\"\",0,Nomina!BI27)","v":0},{"$f":"IF(Nomina!BC27=\"\",0,Nomina!BC27)","v":0},{"$f":"IF(Nomina!Q27=\"\",0,Nomina!Q27)","v":0},{"$f":"IF(Nomina!R27=\"\",0,Nomina!R27)","v":0},{"$f":"IF(Nomina!R27=\"\",0,Nomina!S27)","v":0},{"$f":"IF(Nomina!V27=\"\",0,Nomina!V27)","v":0},{"$f":"IF(Nomina!W27=\"\",0,Nomina!W27)","v":0},{"$f":"IF(Nomina!X27=\"\",0,Nomina!X27)","v":0}]
[null,23,{"$f":"IF(Nomina!B28=\"\",0,Nomina!B28)","v":0},{"$f":"IF(Nomina!D28=\"\",0,Nomina!D28)","v":0},{"$f":"IF(Nomina!AJ28=\"\",0,Nomina!AJ28)","v":0},{"$f":"IF(Nomina!E28=\"\",0,Nomina!E28)","v":0},{"$f":"IF(Nomina!F28=\"\",0,Nomina!F28)","v":0},{"$f":"IF(Nomina!G28=\"\",0,Nomina!G28)","v":0},{"$f":"IF(Nomina!BI28=\"\",0,Nomina!BI28)","v":0},{"$f":"IF(Nomina!BC28=\"\",0,Nomina!BC28)","v":0},{"$f":"IF(Nomina!Q28=\"\",0,Nomina!Q28)","v":0},{"$f":"IF(Nomina!R28=\"\",0,Nomina!R28)","v":0},{"$f":"IF(Nomina!R28=\"\",0,Nomina!S28)","v":0},{"$f":"IF(Nomina!V28=\"\",0,Nomina!V28)","v":0},{"$f":"IF(Nomina!W28=\"\",0,Nomina!W28)","v":0},{"$f":"IF(Nomina!X28=\"\",0,Nomina!X28)","v":0}]
[null,24,{"$f":"IF(Nomina!B29=\"\",0,Nomina!B29)","v":0},{"$f":"IF(Nomina!D29=\"\",0,Nomina!D29)","v":0},{"$f":"IF(Nomina!AJ29=\"\",0,Nomina!AJ29)","v":0},{"$f":"IF(Nomina!E29=\"\",0,Nomina!E29)","v":0},{"$f":"IF(Nomina!F29=\"\",0,Nomina!F29)","v":0},{"$f":"IF(Nomina!G29=\"\",0,Nomina!G29)","v":0},{"$f":"IF(Nomina!BI29=\"\",0,Nomina!BI29)","v":0},{"$f":"IF(Nomina!BC29=\"\",0,Nomina!BC29)","v":0},{"$f":"IF(Nomina!Q29=\"\",0,Nomina!Q29)","v":0},{"$f":"IF(Nomina!R29=\"\",0,Nomina!R29)","v":0},{"$f":"IF(Nomina!R29=\"\",0,Nomina!S29)","v":0},{"$f":"IF(Nomina!V29=\"\",0,Nomina!V29)","v":0},{"$f":"IF(Nomina!W29=\"\",0,Nomina!W29)","v":0},{"$f":"IF(Nomina!X29=\"\",0,Nomina!X29)","v":0}]
[null,25,{"$f":"IF(Nomina!B30=\"\",0,Nomina!B30)","v":0},{"$f":"IF(Nomina!D30=\"\",0,Nomina!D30)","v":0},{"$f":"IF(Nomina!AJ30=\"\",0,Nomina!AJ30)","v":0},{"$f":"IF(Nomina!E30=\"\",0,Nomina!E30)","v":0},{"$f":"IF(Nomina!F30=\"\",0,Nomina!F30)","v":0},{"$f":"IF(Nomina!G30=\"\",0,Nomina!G30)","v":0},{"$f":"IF(Nomina!BI30=\"\",0,Nomina!BI30)","v":0},{"$f":"IF(Nomina!BC30=\"\",0,Nomina!BC30)","v":0},{"$f":"IF(Nomina!Q30=\"\",0,Nomina!Q30)","v":0},{"$f":"IF(Nomina!R30=\"\",0,Nomina!R30)","v":0},{"$f":"IF(Nomina!R30=\"\",0,Nomina!S30)","v":0},{"$f":"IF(Nomina!V30=\"\",0,Nomina!V30)","v":0},{"$f":"IF(Nomina!W30=\"\",0,Nomina!W30)","v":0},{"$f":"IF(Nomina!X30=\"\",0,Nomina!X30)","v":0}]
[null,26,{"$f":"IF(Nomina!B31=\"\",0,Nomina!B31)","v":0},{"$f":"IF(Nomina!D31=\"\",0,Nomina!D31)","v":0},{"$f":"IF(Nomina!AJ31=\"\",0,Nomina!AJ31)","v":0},{"$f":"IF(Nomina!E31=\"\",0,Nomina!E31)","v":0},{"$f":"IF(Nomina!F31=\"\",0,Nomina!F31)","v":0},{"$f":"IF(Nomina!G31=\"\",0,Nomina!G31)","v":0},{"$f":"IF(Nomina!BI31=\"\",0,Nomina!BI31)","v":0},{"$f":"IF(Nomina!BC31=\"\",0,Nomina!BC31)","v":0},{"$f":"IF(Nomina!Q31=\"\",0,Nomina!Q31)","v":0},{"$f":"IF(Nomina!R31=\"\",0,Nomina!R31)","v":0},{"$f":"IF(Nomina!R31=\"\",0,Nomina!S31)","v":0},{"$f":"IF(Nomina!V31=\"\",0,Nomina!V31)","v":0},{"$f":"IF(Nomina!W31=\"\",0,Nomina!W31)","v":0},{"$f":"IF(Nomina!X31=\"\",0,Nomina!X31)","v":0}]
[null,27,{"$f":"IF(Nomina!B32=\"\",0,Nomina!B32)","v":0},{"$f":"IF(Nomina!D32=\"\",0,Nomina!D32)","v":0},{"$f":"IF(Nomina!AJ32=\"\",0,Nomina!AJ32)","v":0},{"$f":"IF(Nomina!E32=\"\",0,Nomina!E32)","v":0},{"$f":"IF(Nomina!F32=\"\",0,Nomina!F32)","v":0},{"$f":"IF(Nomina!G32=\"\",0,Nomina!G32)","v":0},{"$f":"IF(Nomina!BI32=\"\",0,Nomina!BI32)","v":0},{"$f":"IF(Nomina!BC32=\"\",0,Nomina!BC32)","v":0},{"$f":"IF(Nomina!Q32=\"\",0,Nomina!Q32)","v":0},{"$f":"IF(Nomina!R32=\"\",0,Nomina!R32)","v":0},{"$f":"IF(Nomina!R32=\"\",0,Nomina!S32)","v":0},{"$f":"IF(Nomina!V32=\"\",0,Nomina!V32)","v":0},{"$f":"IF(Nomina!W32=\"\",0,Nomina!W32)","v":0},{"$f":"IF(Nomina!X32=\"\",0,Nomina!X32)","v":0}]
[null,28,{"$f":"IF(Nomina!B33=\"\",0,Nomina!B33)","v":0},{"$f":"IF(Nomina!D33=\"\",0,Nomina!D33)","v":0},{"$f":"IF(Nomina!AJ33=\"\",0,Nomina!AJ33)","v":0},{"$f":"IF(Nomina!E33=\"\",0,Nomina!E33)","v":0},{"$f":"IF(Nomina!F33=\"\",0,Nomina!F33)","v":0},{"$f":"IF(Nomina!G33=\"\",0,Nomina!G33)","v":0},{"$f":"IF(Nomina!BI33=\"\",0,Nomina!BI33)","v":0},{"$f":"IF(Nomina!BC33=\"\",0,Nomina!BC33)","v":0},{"$f":"IF(Nomina!Q33=\"\",0,Nomina!Q33)","v":0},{"$f":"IF(Nomina!R33=\"\",0,Nomina!R33)","v":0},{"$f":"IF(Nomina!R33=\"\",0,Nomina!S33)","v":0},{"$f":"IF(Nomina!V33=\"\",0,Nomina!V33)","v":0},{"$f":"IF(Nomina!W33=\"\",0,Nomina!W33)","v":0},{"$f":"IF(Nomina!X33=\"\",0,Nomina!X33)","v":0}]
[null,29,{"$f":"IF(Nomina!B34=\"\",0,Nomina!B34)","v":0},{"$f":"IF(Nomina!D34=\"\",0,Nomina!D34)","v":0},{"$f":"IF(Nomina!AJ34=\"\",0,Nomina!AJ34)","v":0},{"$f":"IF(Nomina!E34=\"\",0,Nomina!E34)","v":0},{"$f":"IF(Nomina!F34=\"\",0,Nomina!F34)","v":0},{"$f":"IF(Nomina!G34=\"\",0,Nomina!G34)","v":0},{"$f":"IF(Nomina!BI34=\"\",0,Nomina!BI34)","v":0},{"$f":"IF(Nomina!BC34=\"\",0,Nomina!BC34)","v":0},{"$f":"IF(Nomina!Q34=\"\",0,Nomina!Q34)","v":0},{"$f":"IF(Nomina!R34=\"\",0,Nomina!R34)","v":0},{"$f":"IF(Nomina!R34=\"\",0,Nomina!S34)","v":0},{"$f":"IF(Nomina!V34=\"\",0,Nomina!V34)","v":0},{"$f":"IF(Nomina!W34=\"\",0,Nomina!W34)","v":0},{"$f":"IF(Nomina!X34=\"\",0,Nomina!X34)","v":0}]
[null,30,{"$f":"IF(Nomina!B35=\"\",0,Nomina!B35)","v":0},{"$f":"IF(Nomina!D35=\"\",0,Nomina!D35)","v":0},{"$f":"IF(Nomina!AJ35=\"\",0,Nomina!AJ35)","v":0},{"$f":"IF(Nomina!E35=\"\",0,Nomina!E35)","v":0},{"$f":"IF(Nomina!F35=\"\",0,Nomina!F35)","v":0},{"$f":"IF(Nomina!G35=\"\",0,Nomina!G35)","v":0},{"$f":"IF(Nomina!BI35=\"\",0,Nomina!BI35)","v":0},{"$f":"IF(Nomina!BC35=\"\",0,Nomina!BC35)","v":0},{"$f":"IF(Nomina!Q35=\"\",0,Nomina!Q35)","v":0},{"$f":"IF(Nomina!R35=\"\",0,Nomina!R35)","v":0},{"$f":"IF(Nomina!R35=\"\",0,Nomina!S35)","v":0},{"$f":"IF(Nomina!V35=\"\",0,Nomina!V35)","v":0},{"$f":"IF(Nomina!W35=\"\",0,Nomina!W35)","v":0},{"$f":"IF(Nomina!X35=\"\",0,Nomina!X35)","v":0}]
[null,31,{"$f":"IF(Nomina!B36=\"\",0,Nomina!B36)","v":0},{"$f":"IF(Nomina!D36=\"\",0,Nomina!D36)","v":0},{"$f":"IF(Nomina!AJ36=\"\",0,Nomina!AJ36)","v":0},{"$f":"IF(Nomina!E36=\"\",0,Nomina!E36)","v":0},{"$f":"IF(Nomina!F36=\"\",0,Nomina!F36)","v":0},{"$f":"IF(Nomina!G36=\"\",0,Nomina!G36)","v":0},{"$f":"IF(Nomina!BI36=\"\",0,Nomina!BI36)","v":0},{"$f":"IF(Nomina!BC36=\"\",0,Nomina!BC36)","v":0},{"$f":"IF(Nomina!Q36=\"\",0,Nomina!Q36)","v":0},{"$f":"IF(Nomina!R36=\"\",0,Nomina!R36)","v":0},{"$f":"IF(Nomina!R36=\"\",0,Nomina!S36)","v":0},{"$f":"IF(Nomina!V36=\"\",0,Nomina!V36)","v":0},{"$f":"IF(Nomina!W36=\"\",0,Nomina!W36)","v":0},{"$f":"IF(Nomina!X36=\"\",0,Nomina!X36)","v":0}]
[null,32,{"$f":"IF(Nomina!B37=\"\",0,Nomina!B37)","v":0},{"$f":"IF(Nomina!D37=\"\",0,Nomina!D37)","v":0},{"$f":"IF(Nomina!AJ37=\"\",0,Nomina!AJ37)","v":0},{"$f":"IF(Nomina!E37=\"\",0,Nomina!E37)","v":0},{"$f":"IF(Nomina!F37=\"\",0,Nomina!F37)","v":0},{"$f":"IF(Nomina!G37=\"\",0,Nomina!G37)","v":0},{"$f":"IF(Nomina!BI37=\"\",0,Nomina!BI37)","v":0},{"$f":"IF(Nomina!BC37=\"\",0,Nomina!BC37)","v":0},{"$f":"IF(Nomina!Q37=\"\",0,Nomina!Q37)","v":0},{"$f":"IF(Nomina!R37=\"\",0,Nomina!R37)","v":0},{"$f":"IF(Nomina!R37=\"\",0,Nomina!S37)","v":0},{"$f":"IF(Nomina!V37=\"\",0,Nomina!V37)","v":0},{"$f":"IF(Nomina!W37=\"\",0,Nomina!W37)","v":0},{"$f":"IF(Nomina!X37=\"\",0,Nomina!X37)","v":0}]
[null,33,{"$f":"IF(Nomina!B38=\"\",0,Nomina!B38)","v":0},{"$f":"IF(Nomina!D38=\"\",0,Nomina!D38)","v":0},{"$f":"IF(Nomina!AJ38=\"\",0,Nomina!AJ38)","v":0},{"$f":"IF(Nomina!E38=\"\",0,Nomina!E38)","v":0},{"$f":"IF(Nomina!F38=\"\",0,Nomina!F38)","v":0},{"$f":"IF(Nomina!G38=\"\",0,Nomina!G38)","v":0},{"$f":"IF(Nomina!BI38=\"\",0,Nomina!BI38)","v":0},{"$f":"IF(Nomina!BC38=\"\",0,Nomina!BC38)","v":0},{"$f":"IF(Nomina!Q38=\"\",0,Nomina!Q38)","v":0},{"$f":"IF(Nomina!R38=\"\",0,Nomina!R38)","v":0},{"$f":"IF(Nomina!R38=\"\",0,Nomina!S38)","v":0},{"$f":"IF(Nomina!V38=\"\",0,Nomina!V38)","v":0},{"$f":"IF(Nomina!W38=\"\",0,Nomina!W38)","v":0},{"$f":"IF(Nomina!X38=\"\",0,Nomina!X38)","v":0}]
[null,34,{"$f":"IF(Nomina!B39=\"\",0,Nomina!B39)","v":0},{"$f":"IF(Nomina!D39=\"\",0,Nomina!D39)","v":0},{"$f":"IF(Nomina!AJ39=\"\",0,Nomina!AJ39)","v":0},{"$f":"IF(Nomina!E39=\"\",0,Nomina!E39)","v":0},{"$f":"IF(Nomina!F39=\"\",0,Nomina!F39)","v":0},{"$f":"IF(Nomina!G39=\"\",0,Nomina!G39)","v":0},{"$f":"IF(Nomina!BI39=\"\",0,Nomina!BI39)","v":0},{"$f":"IF(Nomina!BC39=\"\",0,Nomina!BC39)","v":0},{"$f":"IF(Nomina!Q39=\"\",0,Nomina!Q39)","v":0},{"$f":"IF(Nomina!R39=\"\",0,Nomina!R39)","v":0},{"$f":"IF(Nomina!R39=\"\",0,Nomina!S39)","v":0},{"$f":"IF(Nomina!V39=\"\",0,Nomina!V39)","v":0},{"$f":"IF(Nomina!W39=\"\",0,Nomina!W39)","v":0},{"$f":"IF(Nomina!X39=\"\",0,Nomina!X39)","v":0}]
[null,35,{"$f":"IF(Nomina!B40=\"\",0,Nomina!B40)","v":0},{"$f":"IF(Nomina!D40=\"\",0,Nomina!D40)","v":0},{"$f":"IF(Nomina!AJ40=\"\",0,Nomina!AJ40)","v":0},{"$f":"IF(Nomina!E40=\"\",0,Nomina!E40)","v":0},{"$f":"IF(Nomina!F40=\"\",0,Nomina!F40)","v":0},{"$f":"IF(Nomina!G40=\"\",0,Nomina!G40)","v":0},{"$f":"IF(Nomina!BI40=\"\",0,Nomina!BI40)","v":0},{"$f":"IF(Nomina!BC40=\"\",0,Nomina!BC40)","v":0},{"$f":"IF(Nomina!Q40=\"\",0,Nomina!Q40)","v":0},{"$f":"IF(Nomina!R40=\"\",0,Nomina!R40)","v":0},{"$f":"IF(Nomina!R40=\"\",0,Nomina!S40)","v":0},{"$f":"IF(Nomina!V40=\"\",0,Nomina!V40)","v":0},{"$f":"IF(Nomina!W40=\"\",0,Nomina!W40)","v":0},{"$f":"IF(Nomina!X40=\"\",0,Nomina!X40)","v":0}]
[null,36,{"$f":"IF(Nomina!B41=\"\",0,Nomina!B41)","v":0},{"$f":"IF(Nomina!D41=\"\",0,Nomina!D41)","v":0},{"$f":"IF(Nomina!AJ41=\"\",0,Nomina!AJ41)","v":0},{"$f":"IF(Nomina!E41=\"\",0,Nomina!E41)","v":0},{"$f":"IF(Nomina!F41=\"\",0,Nomina!F41)","v":0},{"$f":"IF(Nomina!G41=\"\",0,Nomina!G41)","v":0},{"$f":"IF(Nomina!BI41=\"\",0,Nomina!BI41)","v":0},{"$f":"IF(Nomina!BC41=\"\",0,Nomina!BC41)","v":0},{"$f":"IF(Nomina!Q41=\"\",0,Nomina!Q41)","v":0},{"$f":"IF(Nomina!R41=\"\",0,Nomina!R41)","v":0},{"$f":"IF(Nomina!R41=\"\",0,Nomina!S41)","v":0},{"$f":"IF(Nomina!V41=\"\",0,Nomina!V41)","v":0},{"$f":"IF(Nomina!W41=\"\",0,Nomina!W41)","v":0},{"$f":"IF(Nomina!X41=\"\",0,Nomina!X41)","v":0}]
[null,37,{"$f":"IF(Nomina!B42=\"\",0,Nomina!B42)","v":0},{"$f":"IF(Nomina!D42=\"\",0,Nomina!D42)","v":0},{"$f":"IF(Nomina!AJ42=\"\",0,Nomina!AJ42)","v":0},{"$f":"IF(Nomina!E42=\"\",0,Nomina!E42)","v":0},{"$f":"IF(Nomina!F42=\"\",0,Nomina!F42)","v":0},{"$f":"IF(Nomina!G42=\"\",0,Nomina!G42)","v":0},{"$f":"IF(Nomina!BI42=\"\",0,Nomina!BI42)","v":0},{"$f":"IF(Nomina!BC42=\"\",0,Nomina!BC42)","v":0},{"$f":"IF(Nomina!Q42=\"\",0,Nomina!Q42)","v":0},{"$f":"IF(Nomina!R42=\"\",0,Nomina!R42)","v":0},{"$f":"IF(Nomina!R42=\"\",0,Nomina!S42)","v":0},{"$f":"IF(Nomina!V42=\"\",0,Nomina!V42)","v":0},{"$f":"IF(Nomina!W42=\"\",0,Nomina!W42)","v":0},{"$f":"IF(Nomina!X42=\"\",0,Nomina!X42)","v":0}]
[null,38,{"$f":"IF(Nomina!B43=\"\",0,Nomina!B43)","v":0},{"$f":"IF(Nomina!D43=\"\",0,Nomina!D43)","v":0},{"$f":"IF(Nomina!AJ43=\"\",0,Nomina!AJ43)","v":0},{"$f":"IF(Nomina!E43=\"\",0,Nomina!E43)","v":0},{"$f":"IF(Nomina!F43=\"\",0,Nomina!F43)","v":0},{"$f":"IF(Nomina!G43=\"\",0,Nomina!G43)","v":0},{"$f":"IF(Nomina!BI43=\"\",0,Nomina!BI43)","v":0},{"$f":"IF(Nomina!BC43=\"\",0,Nomina!BC43)","v":0},{"$f":"IF(Nomina!Q43=\"\",0,Nomina!Q43)","v":0},{"$f":"IF(Nomina!R43=\"\",0,Nomina!R43)","v":0},{"$f":"IF(Nomina!R43=\"\",0,Nomina!S43)","v":0},{"$f":"IF(Nomina!V43=\"\",0,Nomina!V43)","v":0},{"$f":"IF(Nomina!W43=\"\",0,Nomina!W43)","v":0},{"$f":"IF(Nomina!X43=\"\",0,Nomina!X43)","v":0}]
[null,39,{"$f":"IF(Nomina!B44=\"\",0,Nomina!B44)","v":0},{"$f":"IF(Nomina!D44=\"\",0,Nomina!D44)","v":0},{"$f":"IF(Nomina!AJ44=\"\",0,Nomina!AJ44)","v":0},{"$f":"IF(Nomina!E44=\"\",0,Nomina!E44)","v":0},{"$f":"IF(Nomina!F44=\"\",0,Nomina!F44)","v":0},{"$f":"IF(Nomina!G44=\"\",0,Nomina!G44)","v":0},{"$f":"IF(Nomina!BI44=\"\",0,Nomina!BI44)","v":0},{"$f":"IF(Nomina!BC44=\"\",0,Nomina!BC44)","v":0},{"$f":"IF(Nomina!Q44=\"\",0,Nomina!Q44)","v":0},{"$f":"IF(Nomina!R44=\"\",0,Nomina!R44)","v":0},{"$f":"IF(Nomina!R44=\"\",0,Nomina!S44)","v":0},{"$f":"IF(Nomina!V44=\"\",0,Nomina!V44)","v":0},{"$f":"IF(Nomina!W44=\"\",0,Nomina!W44)","v":0},{"$f":"IF(Nomina!X44=\"\",0,Nomina!X44)","v":0}]
[null,40,{"$f":"IF(Nomina!B45=\"\",0,Nomina!B45)","v":0},{"$f":"IF(Nomina!D45=\"\",0,Nomina!D45)","v":0},{"$f":"IF(Nomina!AJ45=\"\",0,Nomina!AJ45)","v":0},{"$f":"IF(Nomina!E45=\"\",0,Nomina!E45)","v":0},{"$f":"IF(Nomina!F45=\"\",0,Nomina!F45)","v":0},{"$f":"IF(Nomina!G45=\"\",0,Nomina!G45)","v":0},{"$f":"IF(Nomina!BI45=\"\",0,Nomina!BI45)","v":0},{"$f":"IF(Nomina!BC45=\"\",0,Nomina!BC45)","v":0},{"$f":"IF(Nomina!Q45=\"\",0,Nomina!Q45)","v":0},{"$f":"IF(Nomina!R45=\"\",0,Nomina!R45)","v":0},{"$f":"IF(Nomina!R45=\"\",0,Nomina!S45)","v":0},{"$f":"IF(Nomina!V45=\"\",0,Nomina!V45)","v":0},{"$f":"IF(Nomina!W45=\"\",0,Nomina!W45)","v":0},{"$f":"IF(Nomina!X45=\"\",0,Nomina!X45)","v":0}]
[null,41,{"$f":"IF(Nomina!B46=\"\",0,Nomina!B46)","v":0},{"$f":"IF(Nomina!D46=\"\",0,Nomina!D46)","v":0},{"$f":"IF(Nomina!AJ46=\"\",0,Nomina!AJ46)","v":0},{"$f":"IF(Nomina!E46=\"\",0,Nomina!E46)","v":0},{"$f":"IF(Nomina!F46=\"\",0,Nomina!F46)","v":0},{"$f":"IF(Nomina!G46=\"\",0,Nomina!G46)","v":0},{"$f":"IF(Nomina!BI46=\"\",0,Nomina!BI46)","v":0},{"$f":"IF(Nomina!BC46=\"\",0,Nomina!BC46)","v":0},{"$f":"IF(Nomina!Q46=\"\",0,Nomina!Q46)","v":0},{"$f":"IF(Nomina!R46=\"\",0,Nomina!R46)","v":0},{"$f":"IF(Nomina!R46=\"\",0,Nomina!S46)","v":0},{"$f":"IF(Nomina!V46=\"\",0,Nomina!V46)","v":0},{"$f":"IF(Nomina!W46=\"\",0,Nomina!W46)","v":0},{"$f":"IF(Nomina!X46=\"\",0,Nomina!X46)","v":0}]
[null,42,{"$f":"IF(Nomina!B47=\"\",0,Nomina!B47)","v":0},{"$f":"IF(Nomina!D47=\"\",0,Nomina!D47)","v":0},{"$f":"IF(Nomina!AJ47=\"\",0,Nomina!AJ47)","v":0},{"$f":"IF(Nomina!E47=\"\",0,Nomina!E47)","v":0},{"$f":"IF(Nomina!F47=\"\",0,Nomina!F47)","v":0},{"$f":"IF(Nomina!G47=\"\",0,Nomina!G47)","v":0},{"$f":"IF(Nomina!BI47=\"\",0,Nomina!BI47)","v":0},{"$f":"IF(Nomina!BC47=\"\",0,Nomina!BC47)","v":0},{"$f":"IF(Nomina!Q47=\"\",0,Nomina!Q47)","v":0},{"$f":"IF(Nomina!R47=\"\",0,Nomina!R47)","v":0},{"$f":"IF(Nomina!R47=\"\",0,Nomina!S47)","v":0},{"$f":"IF(Nomina!V47=\"\",0,Nomina!V47)","v":0},{"$f":"IF(Nomina!W47=\"\",0,Nomina!W47)","v":0},{"$f":"IF(Nomina!X47=\"\",0,Nomina!X47)","v":0}]
[null,43,{"$f":"IF(Nomina!B48=\"\",0,Nomina!B48)","v":0},{"$f":"IF(Nomina!D48=\"\",0,Nomina!D48)","v":0},{"$f":"IF(Nomina!AJ48=\"\",0,Nomina!AJ48)","v":0},{"$f":"IF(Nomina!E48=\"\",0,Nomina!E48)","v":0},{"$f":"IF(Nomina!F48=\"\",0,Nomina!F48)","v":0},{"$f":"IF(Nomina!G48=\"\",0,Nomina!G48)","v":0},{"$f":"IF(Nomina!BI48=\"\",0,Nomina!BI48)","v":0},{"$f":"IF(Nomina!BC48=\"\",0,Nomina!BC48)","v":0},{"$f":"IF(Nomina!Q48=\"\",0,Nomina!Q48)","v":0},{"$f":"IF(Nomina!R48=\"\",0,Nomina!R48)","v":0},{"$f":"IF(Nomina!R48=\"\",0,Nomina!S48)","v":0},{"$f":"IF(Nomina!V48=\"\",0,Nomina!V48)","v":0},{"$f":"IF(Nomina!W48=\"\",0,Nomina!W48)","v":0},{"$f":"IF(Nomina!X48=\"\",0,Nomina!X48)","v":0}]
[null,44,{"$f":"IF(Nomina!B49=\"\",0,Nomina!B49)","v":0},{"$f":"IF(Nomina!D49=\"\",0,Nomina!D49)","v":0},{"$f":"IF(Nomina!AJ49=\"\",0,Nomina!AJ49)","v":0},{"$f":"IF(Nomina!E49=\"\",0,Nomina!E49)","v":0},{"$f":"IF(Nomina!F49=\"\",0,Nomina!F49)","v":0},{"$f":"IF(Nomina!G49=\"\",0,Nomina!G49)","v":0},{"$f":"IF(Nomina!BI49=\"\",0,Nomina!BI49)","v":0},{"$f":"IF(Nomina!BC49=\"\",0,Nomina!BC49)","v":0},{"$f":"IF(Nomina!Q49=\"\",0,Nomina!Q49)","v":0},{"$f":"IF(Nomina!R49=\"\",0,Nomina!R49)","v":0},{"$f":"IF(Nomina!R49=\"\",0,Nomina!S49)","v":0},{"$f":"IF(Nomina!V49=\"\",0,Nomina!V49)","v":0},{"$f":"IF(Nomina!W49=\"\",0,Nomina!W49)","v":0},{"$f":"IF(Nomina!X49=\"\",0,Nomina!X49)","v":0}]
[null,45,{"$f":"IF(Nomina!B50=\"\",0,Nomina!B50)","v":0},{"$f":"IF(Nomina!D50=\"\",0,Nomina!D50)","v":0},{"$f":"IF(Nomina!AJ50=\"\",0,Nomina!AJ50)","v":0},{"$f":"IF(Nomina!E50=\"\",0,Nomina!E50)","v":0},{"$f":"IF(Nomina!F50=\"\",0,Nomina!F50)","v":0},{"$f":"IF(Nomina!G50=\"\",0,Nomina!G50)","v":0},{"$f":"IF(Nomina!BI50=\"\",0,Nomina!BI50)","v":0},{"$f":"IF(Nomina!BC50=\"\",0,Nomina!BC50)","v":0},{"$f":"IF(Nomina!Q50=\"\",0,Nomina!Q50)","v":0},{"$f":"IF(Nomina!R50=\"\",0,Nomina!R50)","v":0},{"$f":"IF(Nomina!R50=\"\",0,Nomina!S50)","v":0},{"$f":"IF(Nomina!V50=\"\",0,Nomina!V50)","v":0},{"$f":"IF(Nomina!W50=\"\",0,Nomina!W50)","v":0},{"$f":"IF(Nomina!X50=\"\",0,Nomina!X50)","v":0}]
[null,46,{"$f":"IF(Nomina!B51=\"\",0,Nomina!B51)","v":0},{"$f":"IF(Nomina!D51=\"\",0,Nomina!D51)","v":0},{"$f":"IF(Nomina!AJ51=\"\",0,Nomina!AJ51)","v":0},{"$f":"IF(Nomina!E51=\"\",0,Nomina!E51)","v":0},{"$f":"IF(Nomina!F51=\"\",0,Nomina!F51)","v":0},{"$f":"IF(Nomina!G51=\"\",0,Nomina!G51)","v":0},{"$f":"IF(Nomina!BI51=\"\",0,Nomina!BI51)","v":0},{"$f":"IF(Nomina!BC51=\"\",0,Nomina!BC51)","v":0},{"$f":"IF(Nomina!Q51=\"\",0,Nomina!Q51)","v":0},{"$f":"IF(Nomina!R51=\"\",0,Nomina!R51)","v":0},{"$f":"IF(Nomina!R51=\"\",0,Nomina!S51)","v":0},{"$f":"IF(Nomina!V51=\"\",0,Nomina!V51)","v":0},{"$f":"IF(Nomina!W51=\"\",0,Nomina!W51)","v":0},{"$f":"IF(Nomina!X51=\"\",0,Nomina!X51)","v":0}]
[null,47,{"$f":"IF(Nomina!B52=\"\",0,Nomina!B52)","v":0},{"$f":"IF(Nomina!D52=\"\",0,Nomina!D52)","v":0},{"$f":"IF(Nomina!AJ52=\"\",0,Nomina!AJ52)","v":0},{"$f":"IF(Nomina!E52=\"\",0,Nomina!E52)","v":0},{"$f":"IF(Nomina!F52=\"\",0,Nomina!F52)","v":0},{"$f":"IF(Nomina!G52=\"\",0,Nomina!G52)","v":0},{"$f":"IF(Nomina!BI52=\"\",0,Nomina!BI52)","v":0},{"$f":"IF(Nomina!BC52=\"\",0,Nomina!BC52)","v":0},{"$f":"IF(Nomina!Q52=\"\",0,Nomina!Q52)","v":0},{"$f":"IF(Nomina!R52=\"\",0,Nomina!R52)","v":0},{"$f":"IF(Nomina!R52=\"\",0,Nomina!S52)","v":0},{"$f":"IF(Nomina!V52=\"\",0,Nomina!V52)","v":0},{"$f":"IF(Nomina!W52=\"\",0,Nomina!W52)","v":0},{"$f":"IF(Nomina!X52=\"\",0,Nomina!X52)","v":0}]
[null,48,{"$f":"IF(Nomina!B53=\"\",0,Nomina!B53)","v":0},{"$f":"IF(Nomina!D53=\"\",0,Nomina!D53)","v":0},{"$f":"IF(Nomina!AJ53=\"\",0,Nomina!AJ53)","v":0},{"$f":"IF(Nomina!E53=\"\",0,Nomina!E53)","v":0},{"$f":"IF(Nomina!F53=\"\",0,Nomina!F53)","v":0},{"$f":"IF(Nomina!G53=\"\",0,Nomina!G53)","v":0},{"$f":"IF(Nomina!BI53=\"\",0,Nomina!BI53)","v":0},{"$f":"IF(Nomina!BC53=\"\",0,Nomina!BC53)","v":0},{"$f":"IF(Nomina!Q53=\"\",0,Nomina!Q53)","v":0},{"$f":"IF(Nomina!R53=\"\",0,Nomina!R53)","v":0},{"$f":"IF(Nomina!R53=\"\",0,Nomina!S53)","v":0},{"$f":"IF(Nomina!V53=\"\",0,Nomina!V53)","v":0},{"$f":"IF(Nomina!W53=\"\",0,Nomina!W53)","v":0},{"$f":"IF(Nomina!X53=\"\",0,Nomina!X53)","v":0}]
[null,49,{"$f":"IF(Nomina!B54=\"\",0,Nomina!B54)","v":0},{"$f":"IF(Nomina!D54=\"\",0,Nomina!D54)","v":0},{"$f":"IF(Nomina!AJ54=\"\",0,Nomina!AJ54)","v":0},{"$f":"IF(Nomina!E54=\"\",0,Nomina!E54)","v":0},{"$f":"IF(Nomina!F54=\"\",0,Nomina!F54)","v":0},{"$f":"IF(Nomina!G54=\"\",0,Nomina!G54)","v":0},{"$f":"IF(Nomina!BI54=\"\",0,Nomina!BI54)","v":0},{"$f":"IF(Nomina!BC54=\"\",0,Nomina!BC54)","v":0},{"$f":"IF(Nomina!Q54=\"\",0,Nomina!Q54)","v":0},{"$f":"IF(Nomina!R54=\"\",0,Nomina!R54)","v":0},{"$f":"IF(Nomina!R54=\"\",0,Nomina!S54)","v":0},{"$f":"IF(Nomina!V54=\"\",0,Nomina!V54)","v":0},{"$f":"IF(Nomina!W54=\"\",0,Nomina!W54)","v":0},{"$f":"IF(Nomina!X54=\"\",0,Nomina!X54)","v":0}]
[null,50,{"$f":"IF(Nomina!B55=\"\",0,Nomina!B55)","v":0},{"$f":"IF(Nomina!D55=\"\",0,Nomina!D55)","v":0},{"$f":"IF(Nomina!AJ55=\"\",0,Nomina!AJ55)","v":0},{"$f":"IF(Nomina!E55=\"\",0,Nomina!E55)","v":0},{"$f":"IF(Nomina!F55=\"\",0,Nomina!F55)","v":0},{"$f":"IF(Nomina!G55=\"\",0,Nomina!G55)","v":0},{"$f":"IF(Nomina!BI55=\"\",0,Nomina!BI55)","v":0},{"$f":"IF(Nomina!BC55=\"\",0,Nomina!BC55)","v":0},{"$f":"IF(Nomina!Q55=\"\",0,Nomina!Q55)","v":0},{"$f":"IF(Nomina!R55=\"\",0,Nomina!R55)","v":0},{"$f":"IF(Nomina!R55=\"\",0,Nomina!S55)","v":0},{"$f":"IF(Nomina!V55=\"\",0,Nomina!V55)","v":0},{"$f":"IF(Nomina!W55=\"\",0,Nomina!W55)","v":0},{"$f":"IF(Nomina!X55=\"\",0,Nomina!X55)","v":0}]
[null,51,{"$f":"IF(Nomina!B56=\"\",0,Nomina!B56)","v":0},{"$f":"IF(Nomina!D56=\"\",0,Nomina!D56)","v":0},{"$f":"IF(Nomina!AJ56=\"\",0,Nomina!AJ56)","v":0},{"$f":"IF(Nomina!E56=\"\",0,Nomina!E56)","v":0},{"$f":"IF(Nomina!F56=\"\",0,Nomina!F56)","v":0},{"$f":"IF(Nomina!G56=\"\",0,Nomina!G56)","v":0},{"$f":"IF(Nomina!BI56=\"\",0,Nomina!BI56)","v":0},{"$f":"IF(Nomina!BC56=\"\",0,Nomina!BC56)","v":0},{"$f":"IF(Nomina!Q56=\"\",0,Nomina!Q56)","v":0},{"$f":"IF(Nomina!R56=\"\",0,Nomina!R56)","v":0},{"$f":"IF(Nomina!R56=\"\",0,Nomina!S56)","v":0},{"$f":"IF(Nomina!V56=\"\",0,Nomina!V56)","v":0},{"$f":"IF(Nomina!W56=\"\",0,Nomina!W56)","v":0},{"$f":"IF(Nomina!X56=\"\",0,Nomina!X56)","v":0}]
[null,52,{"$f":"IF(Nomina!B57=\"\",0,Nomina!B57)","v":0},{"$f":"IF(Nomina!D57=\"\",0,Nomina!D57)","v":0},{"$f":"IF(Nomina!AJ57=\"\",0,Nomina!AJ57)","v":0},{"$f":"IF(Nomina!E57=\"\",0,Nomina!E57)","v":0},{"$f":"IF(Nomina!F57=\"\",0,Nomina!F57)","v":0},{"$f":"IF(Nomina!G57=\"\",0,Nomina!G57)","v":0},{"$f":"IF(Nomina!BI57=\"\",0,Nomina!BI57)","v":0},{"$f":"IF(Nomina!BC57=\"\",0,Nomina!BC57)","v":0},{"$f":"IF(Nomina!Q57=\"\",0,Nomina!Q57)","v":0},{"$f":"IF(Nomina!R57=\"\",0,Nomina!R57)","v":0},{"$f":"IF(Nomina!R57=\"\",0,Nomina!S57)","v":0},{"$f":"IF(Nomina!V57=\"\",0,Nomina!V57)","v":0},{"$f":"IF(Nomina!W57=\"\",0,Nomina!W57)","v":0},{"$f":"IF(Nomina!X57=\"\",0,Nomina!X57)","v":0}]
[null,53,{"$f":"IF(Nomina!B58=\"\",0,Nomina!B58)","v":0},{"$f":"IF(Nomina!D58=\"\",0,Nomina!D58)","v":0},{"$f":"IF(Nomina!AJ58=\"\",0,Nomina!AJ58)","v":0},{"$f":"IF(Nomina!E58=\"\",0,Nomina!E58)","v":0},{"$f":"IF(Nomina!F58=\"\",0,Nomina!F58)","v":0},{"$f":"IF(Nomina!G58=\"\",0,Nomina!G58)","v":0},{"$f":"IF(Nomina!BI58=\"\",0,Nomina!BI58)","v":0},{"$f":"IF(Nomina!BC58=\"\",0,Nomina!BC58)","v":0},{"$f":"IF(Nomina!Q58=\"\",0,Nomina!Q58)","v":0},{"$f":"IF(Nomina!R58=\"\",0,Nomina!R58)","v":0},{"$f":"IF(Nomina!R58=\"\",0,Nomina!S58)","v":0},{"$f":"IF(Nomina!V58=\"\",0,Nomina!V58)","v":0},{"$f":"IF(Nomina!W58=\"\",0,Nomina!W58)","v":0},{"$f":"IF(Nomina!X58=\"\",0,Nomina!X58)","v":0}]
[null,54,{"$f":"IF(Nomina!B59=\"\",0,Nomina!B59)","v":0},{"$f":"IF(Nomina!D59=\"\",0,Nomina!D59)","v":0},{"$f":"IF(Nomina!AJ59=\"\",0,Nomina!AJ59)","v":0},{"$f":"IF(Nomina!E59=\"\",0,Nomina!E59)","v":0},{"$f":"IF(Nomina!F59=\"\",0,Nomina!F59)","v":0},{"$f":"IF(Nomina!G59=\"\",0,Nomina!G59)","v":0},{"$f":"IF(Nomina!BI59=\"\",0,Nomina!BI59)","v":0},{"$f":"IF(Nomina!BC59=\"\",0,Nomina!BC59)","v":0},{"$f":"IF(Nomina!Q59=\"\",0,Nomina!Q59)","v":0},{"$f":"IF(Nomina!R59=\"\",0,Nomina!R59)","v":0},{"$f":"IF(Nomina!R59=\"\",0,Nomina!S59)","v":0},{"$f":"IF(Nomina!V59=\"\",0,Nomina!V59)","v":0},{"$f":"IF(Nomina!W59=\"\",0,Nomina!W59)","v":0},{"$f":"IF(Nomina!X59=\"\",0,Nomina!X59)","v":0}]
[null,55,{"$f":"IF(Nomina!B60=\"\",0,Nomina!B60)","v":0},{"$f":"IF(Nomina!D60=\"\",0,Nomina!D60)","v":0},{"$f":"IF(Nomina!AJ60=\"\",0,Nomina!AJ60)","v":0},{"$f":"IF(Nomina!E60=\"\",0,Nomina!E60)","v":0},{"$f":"IF(Nomina!F60=\"\",0,Nomina!F60)","v":0},{"$f":"IF(Nomina!G60=\"\",0,Nomina!G60)","v":0},{"$f":"IF(Nomina!BI60=\"\",0,Nomina!BI60)","v":0},{"$f":"IF(Nomina!BC60=\"\",0,Nomina!BC60)","v":0},{"$f":"IF(Nomina!Q60=\"\",0,Nomina!Q60)","v":0},{"$f":"IF(Nomina!R60=\"\",0,Nomina!R60)","v":0},{"$f":"IF(Nomina!R60=\"\",0,Nomina!S60)","v":0},{"$f":"IF(Nomina!V60=\"\",0,Nomina!V60)","v":0},{"$f":"IF(Nomina!W60=\"\",0,Nomina!W60)","v":0},{"$f":"IF(Nomina!X60=\"\",0,Nomina!X60)","v":0}]
[null,56,{"$f":"IF(Nomina!B61=\"\",0,Nomina!B61)","v":0},{"$f":"IF(Nomina!D61=\"\",0,Nomina!D61)","v":0},{"$f":"IF(Nomina!AJ61=\"\",0,Nomina!AJ61)","v":0},{"$f":"IF(Nomina!E61=\"\",0,Nomina!E61)","v":0},{"$f":"IF(Nomina!F61=\"\",0,Nomina!F61)","v":0},{"$f":"IF(Nomina!G61=\"\",0,Nomina!G61)","v":0},{"$f":"IF(Nomina!BI61=\"\",0,Nomina!BI61)","v":0},{"$f":"IF(Nomina!BC61=\"\",0,Nomina!BC61)","v":0},{"$f":"IF(Nomina!Q61=\"\",0,Nomina!Q61)","v":0},{"$f":"IF(Nomina!R61=\"\",0,Nomina!R61)","v":0},{"$f":"IF(Nomina!R61=\"\",0,Nomina!S61)","v":0},{"$f":"IF(Nomina!V61=\"\",0,Nomina!V61)","v":0},{"$f":"IF(Nomina!W61=\"\",0,Nomina!W61)","v":0},{"$f":"IF(Nomina!X61=\"\",0,Nomina!X61)","v":0}]
[null,57,{"$f":"IF(Nomina!B62=\"\",0,Nomina!B62)","v":0},{"$f":"IF(Nomina!D62=\"\",0,Nomina!D62)","v":0},{"$f":"IF(Nomina!AJ62=\"\",0,Nomina!AJ62)","v":0},{"$f":"IF(Nomina!E62=\"\",0,Nomina!E62)","v":0},{"$f":"IF(Nomina!F62=\"\",0,Nomina!F62)","v":0},{"$f":"IF(Nomina!G62=\"\",0,Nomina!G62)","v":0},{"$f":"IF(Nomina!BI62=\"\",0,Nomina!BI62)","v":0},{"$f":"IF(Nomina!BC62=\"\",0,Nomina!BC62)","v":0},{"$f":"IF(Nomina!Q62=\"\",0,Nomina!Q62)","v":0},{"$f":"IF(Nomina!R62=\"\",0,Nomina!R62)","v":0},{"$f":"IF(Nomina!R62=\"\",0,Nomina!S62)","v":0},{"$f":"IF(Nomina!V62=\"\",0,Nomina!V62)","v":0},{"$f":"IF(Nomina!W62=\"\",0,Nomina!W62)","v":0},{"$f":"IF(Nomina!X62=\"\",0,Nomina!X62)","v":0}]
[null,58,{"$f":"IF(Nomina!B64=\"\",0,Nomina!B64)","v":0},{"$f":"IF(Nomina!D64=\"\",0,Nomina!D64)","v":0},{"$f":"IF(Nomina!AJ63=\"\",0,Nomina!AJ63)","v":0},{"$f":"IF(Nomina!E63=\"\",0,Nomina!E63)","v":0},{"$f":"IF(Nomina!F64=\"\",0,Nomina!F64)","v":0},{"$f":"IF(Nomina!G64=\"\",0,Nomina!G64)","v":0},{"$f":"IF(Nomina!BI63=\"\",0,Nomina!BI63)","v":0},{"$f":"IF(Nomina!BC63=\"\",0,Nomina!BC63)","v":0},{"$f":"IF(Nomina!Q64=\"\",0,Nomina!Q64)","v":0},{"$f":"IF(Nomina!R64=\"\",0,Nomina!R64)","v":0},{"$f":"IF(Nomina!R64=\"\",0,Nomina!S64)","v":0},{"$f":"IF(Nomina!V64=\"\",0,Nomina!V64)","v":0},{"$f":"IF(Nomina!W64=\"\",0,Nomina!W64)","v":0},{"$f":"IF(Nomina!X64=\"\",0,Nomina!X64)","v":0}]
[null,59,{"$f":"IF(Nomina!B65=\"\",0,Nomina!B65)","v":0},{"$f":"IF(Nomina!D65=\"\",0,Nomina!D65)","v":0},{"$f":"IF(Nomina!AJ64=\"\",0,Nomina!AJ64)","v":0},{"$f":"IF(Nomina!E64=\"\",0,Nomina!E64)","v":0},{"$f":"IF(Nomina!F65=\"\",0,Nomina!F65)","v":0},{"$f":"IF(Nomina!G65=\"\",0,Nomina!G65)","v":0},{"$f":"IF(Nomina!BI64=\"\",0,Nomina!BI64)","v":0},{"$f":"IF(Nomina!BC65=\"\",0,Nomina!BC65)","v":0},{"$f":"IF(Nomina!Q65=\"\",0,Nomina!Q65)","v":0},{"$f":"IF(Nomina!R65=\"\",0,Nomina!R65)","v":0},{"$f":"IF(Nomina!R65=\"\",0,Nomina!S65)","v":0},{"$f":"IF(Nomina!V65=\"\",0,Nomina!V65)","v":0},{"$f":"IF(Nomina!W65=\"\",0,Nomina!W65)","v":0},{"$f":"IF(Nomina!X65=\"\",0,Nomina!X65)","v":0}]
[null,60,{"$f":"IF(Nomina!B66=\"\",0,Nomina!B66)","v":0},{"$f":"IF(Nomina!D66=\"\",0,Nomina!D66)","v":0},{"$f":"IF(Nomina!AJ65=\"\",0,Nomina!AJ65)","v":0},{"$f":"IF(Nomina!E65=\"\",0,Nomina!E65)","v":0},{"$f":"IF(Nomina!F66=\"\",0,Nomina!F66)","v":0},{"$f":"IF(Nomina!G66=\"\",0,Nomina!G66)","v":0},{"$f":"IF(Nomina!BI65=\"\",0,Nomina!BI65)","v":0},{"$f":"IF(Nomina!BC66=\"\",0,Nomina!BC66)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(P6:P65)","v":4305212}]
[null,null,"TOTAL",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Nomina!$R$2","v":4305212}]
[null,null,"Devengado ",null,"Deducido",null,null,null,null,null,"Aportes y Prestaciones % (Valor)"]
[null,null,{"$f":"BonficacionesOcasionales","v":0},null,null,null,null,{"$f":"Embargo","v":0},null,null,"Salud",null,{"$f":"Salud","v":359018.75},null,"Caja de Compensación",null,{"$f":"Caja","v":168950}]
[null,null,{"$f":"T.Salrios","v":3950000},null,null,null,null,{"$f":"ISS","v":337900},null,null,"Prima de Servicios",null,{"$f":"Prima","v":386771.24},null,"ICBF",null,{"$f":"Icbf","v":126712.5}]
[null,null,{"$f":"AuxTransporte","v":409940},null,null,null,null,{"$f":"TRetefuente","v":0},null,null,"Cesantias",null,{"$f":"Cesantias","v":386771.24},null,"Sena",null,{"$f":"Sena","v":84475}]
[null,null,{"$f":"RNocturno","v":33750.000000000007},null,null,null,null,{"$f":"Prestamo","v":0},null,null,"Int. Sobre Cesantias",null,{"$f":"Int","v":3867.7123999999994},null,"Riesgos Profesionales",null,{"$f":"Arp","v":21963.5}]
[null,null,{"$f":"TComisiones","v":240000},null,null,null,null,{"$f":"AportesSalud","v":0},null,null,"Vacaciones",null,{"$f":"Vaca","v":176130.38},null,"Fondo de Pesnsiones",null,{"$f":"Pension","v":506850}]
[null,null,{"$f":"THorasExtras","v":83750},null,null,null,null,{"$f":"AportesPension","v":0},null,null,"TOTAL APROPIACIONES ",null,null,null,null,null,{"$f":"SUM(M69:N73,Q69:Q73)","v":2221510.3223999999}]
[null,null,{"$f":"SUM(boni)","v":0},null,null,null,null,{"$f":"AFC","v":0}]
[null,null,null,null,null,null,null,{"$f":"AportesCooperativa","v":0},null,null,"Percepciones",null,null,null,null,null,{"$f":"SUM(C69:C75)","v":4717440}]
[null,null,null,null,null,null,null,null,null,null,"Deduciones",null,null,null,null,null,{"$f":"SUM(H69:I76)","v":337900}]
[null,null,"Revisado por:",null,"Aprobado Por:",null,null,null,null,null,"Neto a Pagar",null,null,null,null,null,{"$f":"Q76-Q77","v":4379540}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONVIERTENUMLETRA(P66)","v":"CUATRO MILLONES TRESCIENTOS CINCO MIL DOSCIENTOS DOCE PESOS 00/100 M.N."}]
[]
[]
[]
[null,"Digitar  el auxilio de transporte  legal vigente . Actuañlizar la plantilla antes de ingresar los datos. Ver (D- Basicos)"]

{"sheet":"D-basicos","index":6,"n_rows":86,"n_cols":5,"rows_kept":86,"cut":false,"hidden":false,"merged":[[10,17,11,17],[12,17,12,18],[13,17,13,18],[0,0,0,22],[1,0,1,3],[2,0,2,3],[6,0,6,3],[12,0,12,3],[80,0,80,4],[84,0,85,0],[57,0,57,3],[60,0,60,3],[17,0,17,3],[26,0,26,3],[38,0,38,3],[47,0,47,3],[53,0,53,3]]}
[]
["DATOS BASICOS ACTUALES  NOMINA - 2021"]
["SALARIO MINIMO Y AUXILIO DE TRANSPORTE",null,null,null,1]
["Salario Minimo=",908526]
["Auxilio de Transporte=",106454]
[]
["CARGAS PRESTACIONALES",null,null,null,2]
["Cesantias=",8.3299999999999999E-2]
["Prima de Servicios=",8.3299999999999999E-2]
["Ints/Cesantias=",null,0.12]
["Vacaciones=",4.1700000000000001E-2]
[]
["SEGURIDAD SOCIAL Y PENSION",null,null,null,3]
[null,"Empleado","Empresa"]
["Salud=",0.04,8.5000000000000006E-2]
["Pension=",0.04,0.12]
[]
["FONDO DE SOLIDARIDAD PENSIONAL",null,null,null,4]
["Para >= 4 SMMLV",0.01,{"$f":"($B$4*4)","v":3634104},{"$f":"($B$4*16)","v":14536416}]
["Entre 16 SMMLV y 17 SMMLV",1.2E-2,{"$f":"($B$4*16)","v":14536416},{"$f":"($B$4*17)","v":15444942}]
["Entre 17 SMMLV y 18 SMMLV",1.4E-2,{"$f":"($B$4*17)","v":15444942},{"$f":"($B$4*18)","v":16353468}]
["Entre 18 SMMLV y 19 SMMLV",1.6E-2,{"$f":"($B$4*18)","v":16353468},{"$f":"($B$4*19)","v":17261994}]
["Entre 19 SMMLV y 20 SMMLV",1.7999999999999999E-2,{"$f":"($B$4*19)","v":17261994},{"$f":"($B$4*20)","v":18170520}]
["Mayor de 20SMMLV",0.02,{"$f":"($B$4*21)","v":19079046}]
[]
[]
["ADMINISTRADORA DE RIESGOS PROFESIONALES",null,null,null,5]
["Administradora de Riesgos Profesionales=",null,5.1999999999999998E-3]
[]
["Valor UVT para Calcular Retefuente=",null,31859]
[]
["Rangos en UVT",null,"Tarifa Marginal","Puntos adicionales",6]
["Desde","Hasta"]
["> 0",95,0]
[95,150,0.19]
[150,360,0.28000000000000003,10]
[360,"En adelante",0.33,69]
[]
["HORAS EXTRAS Y RECARGOS NOCTURNOS",null,null,null,7]
["Recargo Nocturno=",0.35,1.35,"R.N"]
["Hora Extra Diurna=",0.25,1.25,"HED"]
["Hora Extra Nocturna=",0.75,1.75,"HEN"]
["Hora Ordinaria Dominical o Festivo=",0.75,1.75,"HOF"]
["Hora Extra Diurna Dominical o Festivo=",1,2,"HEFD"]
["Hora Extra Nocturna Dominical o Festivo=",1.5,2.5,"HEFN"]
["Recargo Nocturno Dominical o Festivo=",1.1000000000000001,2.1,"RNF"]
[]
["PAGOS PARAFISCALES",null,null,null,8]
["Sena=",0.02]
["ICBF=",0.03]
["CAJA DE COMPENSACION=",0.04]
[]
[]
["OTROS",null,null,null,9]
["ESAP=",0.01]
["ESCUELAS INDUSTRIALES=",0.01]
[]
["IMPUESTO DE RENTA ",null,null,null,10]
["TARIFA NOMINAL ",0.25]
[]
["CONTRIBUCIÓN EMPRESARIAL PARA LA EQUIDAD  ",null,null,null,11]
["CREE",0.09]
[]
["CONCEPTO","DATOS RETENCION EN LA FUENTE",null,null,12]
["DEDUCCIONES ","Maximo ","Porcentaje"]
["Intereses Corrección Monetaria  (100 UVT)",2684000]
["Salud y Medicina Prepagada  (16 UVT)",429000,null,0.1]
["Deducción  por Dependientes  (10% ing y 32 UVT)",858912,null,0.1]
["RENTAS EXENTAS "]
["Aportes Obligarorios a Pensión ","Ing. Devengados (*)",0.16,0.25]
["Fondo de Solidaridad ","Ing. Devengados (*)",null,0.01]
["Subtotal Rentas Exentas (30% ing, y 316 UVT) ",8500000,null,0.3]
["Rentas Exentas (Numeral 10 del Articulo 206 de ET)",6442000,null,0.25]
["RETENCION  MINIMA "]
["Aportes Obligarorios a Salud y Pensiones del Trabajador",null,null,0.08]
["Empleados Asalariados  ( Aplica Retencion >)",4538914]
["Pagos por Concepto de Alimentación (>41UVT)","Valores mayores ",1100481]
["Aportes Obligatorios a Salud Efectuados por el Trabajador el Año Anterior."]
[]
[]
["RETENCIóN POR SALARIOS  2014"]
[]
["Sin deducción por dependientes ","ingreso laboral ",3826000]
["Con deducción por dependientes","Ingreso Laboral ",4300000]
["Deducciónes de renta con  tabla de retención minima  del art.  384 E.T"]
[null,"Ingreso laboral ",3896000]

{"sheet":"Hoja1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}