{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SIMULAR CARGOS","HORAS EXTRAS","BASICOS","ADIC GRADO","ADIC CAPACITACION","ESTIMULO CAPACITACION"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SIMULAR CARGOS","index":0,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,19],[1,11,1,12]]}
[null,"SIMULADOR DE CALCULO PERSONAL NODOCENTE"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(B7>15,IF(O6=0,1,2),2)","v":1},null,null,"contratos","haberes"]
[null,"PERIODO","CATEGORIA","ANTIGÜEDAD","TITULO","FALLA DE CAJA / RIESGO","CARGA HORARIA SEMANAL","ADICIONAL  PERMANENCIA EN LA CATEGORIA\n(2 - 4 - 6 - 8 AÑOS)","BASICO","ANTIGÜEDAD","TITULO"," RIESGO /\nFALLA DE CAJA","PERMANENCIA",{"$f":"+IF(B7>15,IF(O6=0,\"ADICIONAL POR GRADO - RB\n( 72 )\",\"ADICIONAL POR GRADO - RNB\n( 3 )\"),\"ADICIONAL POR GRADO - RNB\n( 3 )\")","v":"ADICIONAL POR GRADO - RB\n( 72 )"},"ESTIMULO PARA CAPACITACION - NRNB\n( 163 )",{"$f":"+IF(B7>17,\"ADICIONAL CAPACITACION - RB\n( 173 )\",\"ADICIONAL CAPACITACION - RNB\n( 173 )\")","v":"ADICIONAL CAPACITACION - RB\n( 173 )"},"MONTO BRUTO A FACTURAR","BRUTO","NETO","GASTO TOTAL"]
[null,"Junio 2020","Categoria 1",10.0,"POSGRADO","NO TIENE",35.0,"SIN",{"$f":"VLOOKUP(C6,BRUTOS,B7,FALSE)/35*G6","v":92142.08},{"$f":"IF(B7>17,IF(C7<4,I6*D6/100*1.8,I6*D6/100*2),IF(C7<4,I6*D6/100*1.4,I6*D6/100*2))","v":16585.5744},{"$f":"(IF(E6=\"SECUNDARIO\",(INDEX(BASICOS!$A$3:$V$9,7,B7)*0.175/35*G6),VLOOKUP(C6,BASICOS!$A$3:$V$9,B7,FALSE)*VLOOKUP(E6,BASICOS!$N$22:$P$27,3,FALSE)/35*G6))","v":27642.624},{"$f":"ROUND((IF(F6=\"RIESGO\",I6*0.1,(IF(F6=\"FALLA CAJA\",VLOOKUP(\"Categoria 7\",BRUTOS,VLOOKUP(B6,ORDEN,2,FALSE),FALSE))*0.25)))/35*G6,2)","v":0},{"$f":"ROUND((+INDEX('SIMULAR CARGOS'!PERMANENCIA,'SIMULAR CARGOS'!C7,'SIMULAR CARGOS'!B7)*VLOOKUP(H6,PORCPERMA,2,FALSE))/35*G6,2)","v":0},{"$f":"(IF(B8=0,0,+INDEX(ADIC_GRADO,'SIMULAR CARGOS'!C7,'SIMULAR CARGOS'!B8)))/35*G6","v":5528.52},{"$f":"(IF(B9=0,0,+INDEX(ESTIM_CAPACITACION,'SIMULAR CARGOS'!C7,B9)))/35*G6","v":0},{"$f":"ROUND((+IF(B10=0,0,INDEX(ADICCAPACITACION,C7,B10)))/35*G6,2)","v":2764.26},{"$f":"+SUM(I6:P6)","v":144663.0584},{"$f":"+SUM(I6:P6)","v":144663.0584},{"$f":"+((R6-O6)*0.83)+O6","v":120070.3385},{"$f":"((R6-O6)*1.18)+O6","v":170702.4089}]
["ORDEN BASICO",{"$f":"+VLOOKUP(B6,BASICOS!$A$21:$B$56,2,FALSE)","v":22},{"$f":"+VLOOKUP(C6,BASICOS!$K$21:$L$28,2)","v":1},null,null,null,35.0]
["ORDEN GRADO",{"$f":"+VLOOKUP(B6,ORDEN,3,FALSE)","v":11},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(B7=18,1,0)","v":0}]
["ORDEN ESTIMULO",{"$f":"+VLOOKUP(B6,ORDEN,4,FALSE)","v":0}]
["ORDEN ADIC ESTIMULO",{"$f":"+VLOOKUP(B6,ORDEN,5,FALSE)","v":13}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión Instructivo de Liquidación 18/03/2020"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0.5]
[1.0]

{"sheet":"HORAS EXTRAS","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[[3,2,3,7]]}
[]
[null,null,"PERIODO","CATEGORIA","ANTIGÜEDAD","TITULO","FALLA DE CAJA / RIESGO","  PERMANENCIA"]
[null,null,{"$f":"+'SIMULAR CARGOS'!B6","v":"Junio 2020"},{"$f":"+'SIMULAR CARGOS'!C6","v":"Categoria 1"},{"$f":"+'SIMULAR CARGOS'!D6","v":10},{"$f":"+'SIMULAR CARGOS'!E6","v":"POSGRADO"},{"$f":"+'SIMULAR CARGOS'!F6","v":"NO TIENE"},{"$f":"+'SIMULAR CARGOS'!H6","v":"SIN"}]
[null,null,"CALCULADOR DE HORAS EXTRAS"]
[null,null,"BRUTO","DEDICACIÓN HORARIA","TIPO","CANTIDAD HORAS EXTRAS","VALOR P/HORA","MONTO HORAS EXTRAS"]
[{"$f":"+IF(+VLOOKUP('SIMULAR CARGOS'!B6,BASICOS!$A$21:$F$56,6,FALSE)=0,SUM('SIMULAR CARGOS'!I6:M6),IF('SIMULAR CARGOS'!B7=17,IF(VLOOKUP('SIMULAR CARGOS'!C6,BASICOS!$K$21:$L$28,2,0)>4,SUM('SIMULAR CARGOS'!I6:N6),SUM('SIMULAR CARGOS'!I6:M6)),SUM('SIMULAR CARGOS'!I6:N6)))","v":141898.7984},null,{"$f":"+IF('SIMULAR CARGOS'!B7>17,'HORAS EXTRAS'!A7,'HORAS EXTRAS'!A6)","v":144663.0584},{"$f":"+'SIMULAR CARGOS'!G6","v":35},0.5,0.0,{"$f":"+(C6/(D6/5*22))","v":939.3705091},{"$f":"+IF(E6=50%,G6*F6*1.5,G6*F6*2)","v":0}]
[{"$f":"+IF(+VLOOKUP('SIMULAR CARGOS'!B6,BASICOS!$A$21:$F$56,6,FALSE)=0,SUM('SIMULAR CARGOS'!I6:P6),IF('SIMULAR CARGOS'!B7=17,IF(VLOOKUP('SIMULAR CARGOS'!C6,BASICOS!$K$21:$L$28,2,0)>4,SUM('SIMULAR CARGOS'!I6:P6),SUM('SIMULAR CARGOS'!I6:P6)),SUM('SIMULAR CARGOS'!I6:P6)))","v":144663.0584},null,{"$f":"+IF('SIMULAR CARGOS'!B7>17,'HORAS EXTRAS'!A7,'HORAS EXTRAS'!A6)","v":144663.0584},{"$f":"+D6","v":35},1.0,0.0,939.3705091,{"$f":"G7*F7*2","v":0}]
[null,null,null,null,null,"MONTO BRUTO ",null,{"$f":"SUM(H6:H7)","v":0}]
[null,null,null,null,null,"MONTO NETO ",null,{"$f":"+H8*0.83","v":0}]

{"sheet":"BASICOS","index":2,"n_rows":134,"n_cols":24,"rows_kept":134,"cut":false,"hidden":true,"merged":[[29,9,29,10],[30,9,30,10],[31,13,31,14]]}
["ORDEN DE TABLA",2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0]
["Categoría","Básico Enero 2017","Básico Marzo 2017","Básico Junio 2017","Básico Septiembre 2017","Base cálculo 2018 Febrero","Básico Marzo 2018","Básico Mayo 2018","Básico Agosto 2018","Básico Septiembre 2018","Básico MARZO 2019","Básico ABRIL 2019","Básico JUNIO 2019","Básico SEPTIEMBRE 2019","Básico OCTUBRE 2019","Básico  NOVIEMBRE 2019","Básico DICIEMBRE 2019","Básico  ENERO 2020","Básico  MARZO 2020","Básico ABRIL 2020","Básico MAYO 2020","Básico JUNIO 2020"]
["Categoria 1",37860.3,39376.1,42526.1,46247.2,47476.8,48901.68,50325.984,52699.88,54598.98,56236.95,57874.92,60604.87,63334.82,68794.82,70432.82,70432.82,{"$f":"70432.82+9000","v":79432.82},87137.81,88726.46,90553.42,92142.08]
["Categoria 2",31550.0,32813.5,35438.5,38539.4,39563.8,40751.5,41938.45,43916.65,45499.25,46864.23,48229.21,50504.17,52779.13,57329.13,58694.13,58694.13,{"$f":"58694.13+7500","v":66194.13},72614.97,73938.85,75461.31,76785.2]
["Categoria 3",26248.5,27300.7,29484.8,32064.7,32915.6,33905.17,34892.72,36538.62,37855.32,38990.98,40126.64,42019.41,43912.18,47698.18,48834.18,48834.18,{"$f":"48834.18+6240","v":55074.18},60416.38,61517.86,62784.57,63886.05]
["Categoria 4",21832.5,22706.8,24523.4,26669.2,27377.9,28199.95,29021.3,30390.2,31485.3,32429.86,33374.42,34948.69,36522.96,39671.96,40616.96,40616.96,{"$f":"40616.96+5190","v":45806.96},50250.24,51166.38,52219.94,53136.08]
["Categoria 5",18165.8,18900.5,20412.6,22198.7,22779.9,23472.84,24156.49,25295.99,26207.59,26993.82,27780.05,29090.43,30400.81,33021.81,33807.81,{"$f":"33807.81+4320","v":38127.81},38127.81,41826.21,42588.77,43465.71,44228.26]
["Categoria 6",15143.599999999997,15750.4,17010.4,18498.8,18990.1,19560.57,20130.273,21079.77,21839.37,22494.55,23149.73,24241.7,25333.67,27517.67,28172.67,{"$f":"28172.67+3600","v":31772.67},31772.67,34854.62,35490.08,36220.85,36856.3]
["Categoria 7",12620.5,13125.3,14175.3,15415.7,15826.2,16300.51,16775.26,17566.56,18199.56,18745.55,19291.54,20201.52,21111.5,22931.5,23477.5,{"$f":"23477.5+3000","v":26477.5},26477.5,29045.82,29575.37,30184.35,30713.9]
[]
["PERMANENCIA DIFERENCIAS"]
["Categoria 1",{"$f":"+B3*0.37","v":14008.311},14569.157,15734.657,17111.464,17566.416,18093.6216,18620.61408,19498.9556,20201.6226,20807.6715,21413.7204,22423.8019,23433.8834,25454.0834,26060.1434,26060.1434,29390.1434,32240.9897,32828.7902,33504.7654,34092.5696]
["Categoria 2",{"$f":"+B3-B4","v":6310.3},6562.6,7087.6,7707.8,7913,8150.18,8387.534,8783.23,9099.73,9372.72,9645.71,10100.7,10555.69,11465.69,11738.69,11738.69,13238.69,14522.84,14787.61,15092.11,15356.88]
["Categoria 3",{"$f":"+B4-B5","v":5301.5},5512.8,5953.7,6474.7,6648.2,6846.33,7045.73,7378.03,7643.93,7873.25,8102.57,8484.76,8866.95,9630.95,9859.95,9859.95,11119.95,12198.59,12420.99,12676.74,12899.15]
["Categoria 4",{"$f":"+B5-B6","v":4416},4593.9,4961.4,5395.5,5537.7,5705.22,5871.42,6148.42,6370.02,6561.12,6752.22,7070.72,7389.22,8026.22,8217.22,8217.22,9267.22,10166.14,10351.48,10564.63,10749.97]
["Categoria 5",{"$f":"+B6-B7","v":3666.7},3806.3,4110.8,4470.5,4598,4727.11,4864.81,5094.21,5277.71,5436.04,5594.37,5858.26,6122.15,6650.15,6809.15,2489.15,7679.15,8424.03,8577.61,8754.23,8907.82]
["Categoria 6",{"$f":"+B7-B8","v":3022.2},3150.1,3402.2,3699.9,3789.8,3912.27,4026.217,4216.22,4368.22,4499.27,4630.32,4848.73,5067.14,5504.14,5635.14,6355.14,6355.14,6971.59,7098.69,7244.86,7371.96]
["Categoria 7",{"$f":"+B8-B9","v":2523.1},2625.1,2835.1,3083.1,3163.9,3260.06,3355.013,3513.21,3639.81,3749,3858.19,4040.18,4222.17,4586.17,4695.17,5295.17,5295.17,5808.8,5914.71,6036.5,6142.4]
[]
[]
["Columna1","ORDEN  BASICO","ORDEN GRADO","ORDEN ESTIMULO","ORDEN ADIC CAPACITACION","NUEVO GRADO",null,"ANTIG PERMANENCIA","%",null,"Categoría","ORDEN",null,"Porcentajes Vigentes Adicionales por Título"]
["Junio 2020",22.0,11.0,0.0,13.0,1.0,null,"8 AÑOS",0.7,null,"Categoria 1",1.0,null,"POSGRADO","POSG",0.3,"sobre categoria de revista"]
["Mayo 2020",21.0,10.0,0.0,12.0,1.0,null,"6 AÑOS",0.45,null,"Categoria 2",2.0,null,"UNIVERSITARIO","UNIV",0.25,"sobre categoria de revista"]
["Abril 2020",20.0,9.0,0.0,11.0,1.0,null,"4 AÑOS",0.25,null,"Categoria 3",3.0,null,"TEC GESTION UNIVERSITARIA","TGUN",0.2,"sobre categoria de revista"]
["Marzo 2020",19.0,8.0,0.0,10.0,1.0,null,"2 AÑOS",0.1,null,"Categoria 4",4.0,null,"TERCIARIO","TERC",0.1,"sobre categoria de revista"]
["Febrero 2020",18.0,7.0,0.0,9.0,1.0,null,"SIN",0.0,null,"Categoria 5",5.0,null,"SECUNDARIO","SECU",0.175,"sobre categoria 7"]
["Enero 2020",18.0,7.0,0.0,9.0,1.0,null,null,null,null,"Categoria 6",6.0,null,"PRIMARIO","PRIM",0.0]
["Diciembre 2019",17.0,6.0,4.0,8.0,1.0,null,null,null,null,"Categoria 7",7.0]
["Noviembre 2019",16.0,5.0,3.0,7.0]
["Octubre 2019",15.0,5.0,3.0,6.0,null,null,"FALLA CAJA",0.25,"sobre categoria 7"]
["Septiembre 2019",14.0,5.0,3.0,5.0,null,null,"RIESGO",0.1,"sobre categoria de revista"]
["Agosto 2019",13.0,5.0,3.0,4.0,null,null,"NO TIENE",0.0,null,null,null,null,"NUEVO GRADO"]
["Julio 2019",13.0,5.0,3.0,3.0,null,null,null,null,null,null,null,null,"Categoría","%"]
["Junio 2019",13.0,5.0,3.0,3.0,null,null,null,null,null,null,null,null,"Categoria 1",6.0]
["Mayo 2019",12.0,5.0,3.0,2.0,null,null,null,null,null,null,null,null,"Categoria 2",7.0]
["Abril 2019",12.0,5.0,3.0,2.0,null,null,null,null,null,null,null,null,"Categoria 3",8.0]
["Marzo 2019",11.0,5.0,3.0,null,null,null,null,null,null,null,null,null,"Categoria 4",11.0]
["Febrero 2019",10.0,5.0,3.0,null,null,null,null,null,null,null,null,null,"Categoria 5",14.0]
["Enero 2019",10.0,5.0,2.0,null,null,null,null,null,null,null,null,null,"Categoria 6",23.0]
["Diciembre 2018",10.0,5.0,null,null,null,null,null,null,null,null,null,null,"Categoria 7",27.0]
["Noviembre 2018",10.0,5.0]
["Octubre 2018",10.0,5.0]
["Septiembre 2018",10.0,4.0]
["Agosto 2018",9.0,3.0]
["Julio 2018",8.0,3.0]
["Junio 2018",8.0,3.0]
["Mayo 2018",8.0,2.0]
["Abril 2018",7.0,2.0]
["Marzo 2018",7.0,2.0]
["Febrero 2018",6.0,2.0]
["Enero 2018",5.0,2.0]
["Septiembre 2017",5.0,2.0]
["Junio 2017",4.0,2.0]
["Abril 2017",3.0,2.0,null,null,null,null,null,null,null,"AGENTE","DNI","SISTEMAS QUE ACCEDEN","TRAEN COMPU"]
["Marzo 2017",3.0,null,null,null,null,null,null,null,null,"NICOLAS GAETAN",2.296548E7,"CONVENIOS, PILAGA, MAPUCHE, DESIGNACIONES, COMDOC, ARCHIVOS COMPARTIDOS DEL SERVIDOR","si"]
["Enero 2017",2.0,null,null,null,null,null,null,null,null,"PABLO CASTAÑAREZ",2.529637E7,"MAPUCHE, DESIGNACIONES, COMDOC, ARCHIVOS COMPARTIDOS DEL SERVIDOR","no"]
[null,null,null,null,null,null,null,null,null,null,"DIEGO RIPOLL",2.9506475E7,"MAPUCHE, DESIGNACIONES, COMDOC, ARCHIVOS COMPARTIDOS DEL SERVIDOR","no"]
[null,null,null,null,null,null,null,null,null,null,"MALENA DIAZ",3.7184554E7,"MAPUCHE, DESIGNACIONES, COMDOC, ARCHIVOS COMPARTIDOS DEL SERVIDOR","no"]
[null,null,null,null,null,null,null,null,null,null,"BETIAN VOLPE",3.1826696E7,"CONVENIOS,  ARCHIVOS COMPARTIDOS DEL SERVIDOR","no"]
[]
[]
[]
[]
[0.0,35.0]
[1.0,34.5]
[2.0,34.0]
[3.0,33.5]
[4.0,33.0]
[5.0,32.5]
[6.0,32.0]
[7.0,31.5]
[8.0,31.0]
[9.0,30.5]
[10.0,30.0]
[11.0,29.5]
[12.0,29.0]
[13.0,28.5]
[14.0,28.0]
[15.0,27.5]
[16.0,27.0]
[17.0,26.5]
[18.0,26.0]
[19.0,25.5]
[20.0,25.0]
[21.0,24.5]
[22.0,24.0]
[23.0,23.5]
[24.0,23.0]
[25.0,22.5]
[26.0,22.0]
[27.0,21.5]
[28.0,21.0]
[29.0,20.5]
[30.0,20.0]
[31.0,19.5]
[32.0,19.0]
[33.0,18.5]
[34.0,18.0]
[35.0,17.5]
[36.0,17.0]
[37.0,16.5]
[38.0,16.0]
[39.0,15.5]
[40.0,15.0]
[41.0,14.5]
[42.0,14.0]
[43.0,13.5]
[44.0,13.0]
[45.0,12.5]
[46.0,12.0]
[47.0,11.5]
[48.0,11.0]
[49.0,10.5]
[50.0,10.0]
[null,9.5]
[null,9.0]
[null,8.5]
[null,8.0]
[null,7.5]
[null,7.0]
[null,6.5]
[null,6.0]
[null,5.5]
[null,5.0]
[null,4.5]
[null,4.0]
[null,3.5]
[null,3.0]
[null,2.5]
[null,2.0]
[null,1.5]
[null,1.0]
[null,0.5]
[null,0.0]

{"sheet":"ADIC GRADO","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0]
["Categoría","abril 2017","junio 2018","setiembre 2018","octubre 2018","diciembre 2019","enero 2020","marzo 2020","abril 2020","mayo 2020","junio 2020"]
["Categoria 1",null,null,null,4800.0,4800.0,{"$f":"FIXED(+BASICOS!R3*0.06,2)","v":"4.765,97"},{"$f":"FIXED(+BASICOS!S3*0.06,2)","v":"5.228,27"},{"$f":"FIXED(+BASICOS!T3*0.06,2)","v":"5.323,59"},{"$f":"FIXED(+BASICOS!U3*0.06,2)","v":"5.433,21"},{"$f":"FIXED(+BASICOS!V3*0.06,2)","v":"5.528,52"}]
["Categoria 2",null,null,null,4200.0,4200.0,{"$f":"FIXED(+BASICOS!R4*0.07,2)","v":"4.633,59"},{"$f":"FIXED(+BASICOS!S4*0.07,2)","v":"5.083,05"},{"$f":"FIXED(+BASICOS!T4*0.07,2)","v":"5.175,72"},{"$f":"FIXED(+BASICOS!U4*0.07,2)","v":"5.282,29"},{"$f":"FIXED(+BASICOS!V4*0.07,2)","v":"5.374,96"}]
["Categoria 3",null,null,null,3600.0,3600.0,{"$f":"FIXED(+BASICOS!R5*0.08,2)","v":"4.405,93"},{"$f":"FIXED(+BASICOS!S5*0.08,2)","v":"4.833,31"},{"$f":"FIXED(+BASICOS!T5*0.08,2)","v":"4.921,43"},{"$f":"FIXED(+BASICOS!U5*0.08,2)","v":"5.022,77"},{"$f":"FIXED(+BASICOS!V5*0.08,2)","v":"5.110,88"}]
["Categoria 4",null,null,null,3300.0,3300.0,{"$f":"FIXED(+BASICOS!R6*0.11,2)","v":"5.038,77"},{"$f":"FIXED(+BASICOS!S6*0.11,2)","v":"5.527,53"},{"$f":"FIXED(+BASICOS!T6*0.11,2)","v":"5.628,30"},{"$f":"FIXED(+BASICOS!U6*0.11,2)","v":"5.744,19"},{"$f":"FIXED(+BASICOS!V6*0.11,2)","v":"5.844,97"}]
["Categoria 5",null,500.0,1000.0,4000.0,5337.89,{"$f":"FIXED(+BASICOS!R7*0.14,2)","v":"5.337,89"},{"$f":"FIXED(+BASICOS!S7*0.14,2)","v":"5.855,67"},{"$f":"FIXED(+BASICOS!T7*0.14,2)","v":"5.962,43"},{"$f":"FIXED(+BASICOS!U7*0.14,2)","v":"6.085,20"},{"$f":"FIXED(+BASICOS!V7*0.14,2)","v":"6.191,96"}]
["Categoria 6",2000.0,2500.0,3000.0,5800.0,7307.71,{"$f":"FIXED(+BASICOS!R8*0.23,2)","v":"7.307,71"},{"$f":"FIXED(+BASICOS!S8*0.23,2)","v":"8.016,56"},{"$f":"FIXED(+BASICOS!T8*0.23,2)","v":"8.162,72"},{"$f":"FIXED(+BASICOS!U8*0.23,2)","v":"8.330,80"},{"$f":"FIXED(+BASICOS!V8*0.23,2)","v":"8.476,95"}]
["Categoria 7",2000.0,2500.0,3000.0,5500.0,7148.93,{"$f":"FIXED(+BASICOS!R9*0.27,2)","v":"7.148,93"},{"$f":"FIXED(+BASICOS!S9*0.27,2)","v":"7.842,37"},{"$f":"FIXED(+BASICOS!T9*0.27,2)","v":"7.985,35"},{"$f":"FIXED(+BASICOS!U9*0.27,2)","v":"8.149,77"},{"$f":"FIXED(+BASICOS!V9*0.27,2)","v":"8.292,75"}]

{"sheet":"ADIC CAPACITACION","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0]
["Categoría","Abril 2019","Junio 2019","Agosto 2019","Septiembre 2019","Octubre 2019","Noviembre 2019","Diciembre 2019","Enero 2020","Marzo 2020","Abril 2020","Mayo 2020","Junio 2020"]
["Categoria 1",{"$f":"0.015*BASICOS!L3","v":868.1238},{"$f":"0.015*BASICOS!M3","v":909.07305},{"$f":"+C3*2","v":1818.1461},{"$f":"(0.03*BASICOS!N3)","v":1900.0446},{"$f":"(0.03*BASICOS!O3)","v":2063.8446},{"$f":"(0.03*BASICOS!P3)","v":2112.9846},{"$f":"(0.03*BASICOS!Q3)","v":2112.9846},{"$f":"(0.03*BASICOS!R3)","v":2382.9846},{"$f":"(0.03*BASICOS!S3)","v":2614.1343},{"$f":"ROUND((0.03*BASICOS!T3),2)","v":2661.79},{"$f":"ROUND((0.03*BASICOS!U3),2)","v":2716.6},{"$f":"ROUND((0.03*BASICOS!V3),2)","v":2764.26}]
["Categoria 2",{"$f":"0.02*BASICOS!L4","v":964.5842},{"$f":"0.02*BASICOS!M4","v":1010.0834},2020.1668,{"$f":"(0.04*BASICOS!N4)","v":2111.1652},{"$f":"(0.04*BASICOS!O4)","v":2293.1652},{"$f":"(0.04*BASICOS!P4)","v":2347.7652},{"$f":"(0.04*BASICOS!Q4)","v":2347.7652},{"$f":"(0.04*BASICOS!R4)","v":2647.7652},{"$f":"(0.04*BASICOS!S4)","v":2904.5988},{"$f":"ROUND((0.04*BASICOS!T4),2)","v":2957.55},{"$f":"ROUND((0.04*BASICOS!U4),2)","v":3018.45},{"$f":"ROUND((0.04*BASICOS!V4),2)","v":3071.41}]
["Categoria 3",{"$f":"0.025*BASICOS!L5","v":1003.166},{"$f":"0.025*BASICOS!M5","v":1050.48525},2100.9705,{"$f":"(0.05*BASICOS!N5)","v":2195.609},{"$f":"(0.05*BASICOS!O5)","v":2384.909},{"$f":"(0.05*BASICOS!P5)","v":2441.709},{"$f":"(0.05*BASICOS!Q5)","v":2441.709},{"$f":"(0.05*BASICOS!R5)","v":2753.709},{"$f":"(0.05*BASICOS!S5)","v":3020.819},{"$f":"ROUND((0.05*BASICOS!T5),2)","v":3075.89},{"$f":"ROUND((0.05*BASICOS!U5),2)","v":3139.23},{"$f":"ROUND((0.05*BASICOS!V5),2)","v":3194.3}]
["Categoria 4",{"$f":"0.03*BASICOS!L6","v":1001.2326},{"$f":"0.03*BASICOS!M6","v":1048.4607},2096.9214,{"$f":"(0.06*BASICOS!N6)","v":2191.3776},{"$f":"(0.06*BASICOS!O6)","v":2380.3176},{"$f":"(0.06*BASICOS!P6)","v":2437.0176},{"$f":"(0.06*BASICOS!Q6)","v":2437.0176},{"$f":"(0.06*BASICOS!R6)","v":2748.4176},{"$f":"(0.06*BASICOS!S6)","v":3015.0144},{"$f":"ROUND((0.06*BASICOS!T6),2)","v":3069.98},{"$f":"ROUND((0.06*BASICOS!U6),2)","v":3133.2},{"$f":"ROUND((0.06*BASICOS!V6),2)","v":3188.16}]
["Categoria 5",{"$f":"0.035*BASICOS!L7","v":972.30175},{"$f":"0.035*BASICOS!M7","v":1018.16505},2036.3301,{"$f":"(0.07*BASICOS!N7)","v":2128.0567},{"$f":"(0.07*BASICOS!O7)","v":2311.5267},{"$f":"(0.07*BASICOS!P7)","v":2366.5467},{"$f":"(0.07*BASICOS!Q7)","v":2668.9467},{"$f":"(0.07*BASICOS!R7)","v":2668.9467},{"$f":"(0.07*BASICOS!S7)","v":2927.8347},{"$f":"ROUND((0.07*BASICOS!T7),2)","v":2981.21},{"$f":"ROUND((0.07*BASICOS!U7),2)","v":3042.6},{"$f":"ROUND((0.07*BASICOS!V7),2)","v":3095.98}]
["Categoria 6",{"$f":"0.04*BASICOS!L8","v":925.9892},{"$f":"0.04*BASICOS!M8","v":969.668},1939.336,{"$f":"(0.08*BASICOS!N8)","v":2026.6936},{"$f":"(0.08*BASICOS!O8)","v":2201.4136},{"$f":"(0.08*BASICOS!P8)","v":2253.8136},{"$f":"(0.08*BASICOS!Q8)","v":2541.8136},{"$f":"(0.08*BASICOS!R8)","v":2541.8136},{"$f":"(0.08*BASICOS!S8)","v":2788.3696},{"$f":"ROUND((0.08*BASICOS!T8),2)","v":2839.21},{"$f":"ROUND((0.08*BASICOS!U8),2)","v":2897.67},{"$f":"ROUND((0.08*BASICOS!V8),2)","v":2948.5}]
["Categoria 7",{"$f":"0.05*BASICOS!L9","v":964.577},{"$f":"0.05*BASICOS!M9","v":1010.076},2020.152,{"$f":"(0.1*BASICOS!N9)","v":2111.15},{"$f":"(0.1*BASICOS!O9)","v":2293.15},{"$f":"(0.1*BASICOS!P9)","v":2347.75},{"$f":"(0.1*BASICOS!Q9)","v":2647.75},{"$f":"(0.1*BASICOS!R9)","v":2647.75},{"$f":"(0.1*BASICOS!S9)","v":2904.582},{"$f":"ROUND((0.1*BASICOS!T9),2)","v":2957.54},{"$f":"ROUND((0.1*BASICOS!U9),2)","v":3018.44},{"$f":"ROUND((0.1*BASICOS!V9),2)","v":3071.39}]

{"sheet":"ESTIMULO CAPACITACION","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,2.0,3.0,4.0]
["Categoría","Enero 2019","Febrero 2019","Diciembre 2019"]
["Categoria 1",2400.0,4800.0,4800.0]
["Categoria 2",2200.0,4400.0,4400.0]
["Categoria 3",2000.0,4000.0,4000.0]
["Categoria 4",1800.0,3600.0,3600.0]
["Categoria 5",1600.0,3200.0]
["Categoria 6",1500.0,3000.0]
["Categoria 7",1500.0,3000.0]