{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TABLADINAM X CARGO","Hoja2","AMIGOS","Tablas","Hoja3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":2},"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":"TABLADINAM X CARGO","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["CARGOS","NETO PAGADO","FUNCIONARIOS"]
["Auxiliar Admin",2041000,3]
["Coordinador",3350000.0000000005,2]
["Gerente",2980000,1]
["Jefe  de Division",4538000,2]
["(en blanco)",0]
["Total general",12909000,8]

{"sheet":"Hoja2","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Etiquetas de fila","Suma de RET","Suma de Neto"]
["Abogado",46000,2284000]
["Estudiante",9000,2041000]
["Ingeniero",33333.333333333343,3350000.0000000005]
["Medico",106000,5234000]
["(en blanco)",{"$error":"#VALUE!"},0]
["Total general",{"$error":"#VALUE!"},12909000]

{"sheet":"AMIGOS","index":2,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[26,3,26,4],[32,3,32,7],[33,3,33,7]]}
["CODIGO","NOMBRES","APELLIDOS","NOMAPE","CIUDAD","Columna1","DEPARTAMENTIO","AuxT","NomApeCiud","PROFESION","CARGO","GENERO","NomGenero","Bonif","ESTADO CIVIL","IBCO","DT","SueldoMes","RET","Neto"]
[100,"Juan","Perez Prado",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Juan Perez Prado"},"Dosquebradas",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":30000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Juan Perez Prado   (Dosquebradas)"},"Medico","Gerente","F",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Femenino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":10000},"SOLTERO(A)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":3000000},30,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":3000000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":60000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":2980000}]
[101,"Adriana","Cardona Orozco",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Adriana Cardona Orozco"},"Dosquebradas",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":30000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Adriana Cardona Orozco   (Dosquebradas)"},"Estudiante","Auxiliar Admin","M",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Masculino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},"CASADO(A)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":900000},15,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":450000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":0},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":480000}]
[102,"Alvaro Andres","Linares Lopez",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Alvaro Andres Linares Lopez"},"Cartago",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Valle"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Valle"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":30000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Alvaro Andres Linares Lopez   (Cartago)"},"Estudiante","Auxiliar Admin","F",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Femenino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":10000},"VIUDO()",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":900000},30,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":900000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":9000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":931000}]
[103,"Carlos Alberto","Arias",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Carlos Alberto Arias"},"Pereira",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":0},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Carlos Alberto Arias   (Pereira)"},"Medico","Jefe  de Division","M",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Masculino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},"SOLTERO(A)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":2300000},30,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":2300000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":46000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":2254000}]
[104,"Juan Miguel","Diaz Parra",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Juan Miguel Diaz Parra"},"Pereira",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":0},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Juan Miguel Diaz Parra   (Pereira)"},"Ingeniero","Coordinador","M",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Masculino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},"SOLTERO(A)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":2000000},20,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":1333333.3333333335},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":13333.333333333336},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":1320000.0000000002}]
[105,"Oscar","Gutierrez Laverde",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Oscar Gutierrez Laverde"},"Armenia",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Quindio"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Quindio"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":50000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Oscar Gutierrez Laverde   (Armenia)"},"Ingeniero","Coordinador","M",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Masculino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},"Soltero(a)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":2000000},30,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":2000000.0000000002},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":20000.000000000004},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":2030000.0000000002}]
[106,"Nancy","Pulgarin Morales",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Nancy Pulgarin Morales"},"Pereira",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Risaralda"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":0},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Nancy Pulgarin Morales   (Pereira)"},"Estudiante","Auxiliar Admin","F",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Femenino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":30000},"Soltero(a)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":900000},20,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":600000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":0},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":630000}]
[107,"Orlando","Jimenez ",{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":"Orlando Jimenez "},"Cali",{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Valle"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":"Valle"},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":30000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":"Orlando Jimenez    (Cali)"},"Abogado","Jefe  de Division","m",{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":"Masculino"},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},"CASADO(A)",{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":2300000},30,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":2300000},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":46000},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":2284000}]
[108,null,null,{"$f":"CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]])","v":" "},null,{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":""},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CIUDAD]],RangoCiudadyDepto,2,FALSE))","v":""},{"$f":"IF(TblAmigos[[#This Row],[CIUDAD]]=\"Pereira\",0,IF(TblAmigos[[#This Row],[CIUDAD]]=\"Armenia\",50000,IF(TblAmigos[[#This Row],[CIUDAD]]=\"\",\"\",30000)))","v":""},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",CONCATENATE(TblAmigos[[#This Row],[NOMBRES]],\" \",TblAmigos[[#This Row],[APELLIDOS]],\"   (\",TblAmigos[[#This Row],[CIUDAD]],\")\"))","v":""},null,null,null,{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"M\",\"Masculino\",IF(TblAmigos[[#This Row],[GENERO]]=\"F\",\"Femenino\",IF(TblAmigos[[#This Row],[GENERO]]=\"\",\"\",\"NO VALIDO\")))","v":""},{"$f":"IF(TblAmigos[[#This Row],[GENERO]]=\"F\",IF(TblAmigos[[#This Row],[CIUDAD]]=\"PEREIRA\",30000,10000),0)","v":0},null,{"$f":"IF(TblAmigos[[#This Row],[CARGO]]=\"\",\"\",VLOOKUP(TblAmigos[[#This Row],[CARGO]],RangoCargosySueldo,2,FALSE))","v":""},null,{"$f":"(TblAmigos[[#This Row],[IBCO]]/30)*TblAmigos[[#This Row],[DT]]","v":{"$error":"#VALUE!"}},{"$f":"IF(TblAmigos[[#This Row],[SueldoMes]] <= 800000,0,IF(TblAmigos[[#This Row],[SueldoMes]]<=2000000,TblAmigos[[#This Row],[SueldoMes]]*1%,TblAmigos[[#This Row],[SueldoMes]]*2%))","v":{"$error":"#VALUE!"}},{"$f":"IF(TblAmigos[[#This Row],[NOMBRES]]=\"\",\"\",(TblAmigos[[#This Row],[AuxT]]+TblAmigos[[#This Row],[Bonif]]+TblAmigos[[#This Row],[SueldoMes]]-TblAmigos[[#This Row],[RET]]))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"REGLAS DEL NEGOCIO"]
[null,null,null,"SI ES MUJER TIENE BONIFICACION DE 10,000 PERO SI ES MUJER DE PEREIRA TIENE BONIF DE 30000"]
[null,null,null,"CALCULAR RETENCION SEGÚN TABLA"]
[null,null,null,"SUELDO MES ","RET %"]
[null,null,null,"0 - 800.000",0]
[null,null,null,"800.0001 - 2.000.000",0.01]
[null,null,null,"MAYOR A 2.000.0001",0.02]
[]
[null,null,null,"TIENE AUXILIO DE TRANSPORTE IGUAL A 50.000 SI LA PERSONA ES DE ARMENIA"]
[null,null,null,"SI ES DE PEREIRA NO TIENE AUX DE TRANSPORTE, SI LACIUDAD NO ES ARMENIA TIENE 30.000 DE AUX TRANSP"]

{"sheet":"Tablas","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Ciudades","Departamentos",null,"Ocupacion","Cargo","Sueldo","EstadoCivil"]
["Pereira","Risaralda",null,"Abogado","Secretaria",700000,"Estado Civil"]
["Armenia","Quindio",null,"Medico","Gerente",3000000,"Soltero(a)"]
["Manizales","Caldas",null,"Ingeniero","Coordinador",2000000,"Casado(a)"]
["Cartago","Valle",null,"Estudiante","Auxiliar Admin",900000,"Viudo(a)"]
["Dosquebradas","Risaralda",null,"Ama de casa","Jefe  de Division",2300000,"Divorciado"]
["Cali","Valle",null,null,null,null,"Union Libre"]

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