{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Evaluador","Puntuacion"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Evaluador","index":0,"n_rows":503,"n_cols":12,"rows_kept":503,"cut":false,"hidden":false,"merged":[[1,9,1,10],[3,2,3,10],[1,2,1,8]]}
[1]
[null,null,"NIVEL 1",null,null,null,null,null,null,"Prueba ",null,{"$f":"A1","v":1}]
[null,1,null,null,null,null,null,null,null,null,null,"PUNTOS"]
[null,2,"NIVEL PRINCIPIANTE",null,null,null,null,null,null,null,null,{"$f":"(Puntuacion!T$37+Puntuacion!U$37+Puntuacion!V$37+Puntuacion!W$37)","v":0}]
[null,3]
[null,4]
[null,5]
[null,6,null,null,"Descripcion","Unidades Vendidas","Porcentaje","Precio de venta","Ventas "]
[null,7,null,null,"Articulo 1",150,null,5000]
[null,8,null,null,"Articulo 2",300,null,10000]
[null,9,null,null,"TOTAL",450]
[null,10]
[null,11,null,null,"1) calcula con una suma simple el total de unidades vendidas"]
[null,12,null,null,"2 ¿Cuánto representa la venta de unidades de cada articulo con respecto al total?"]
[null,13,null,null,"3) Con una formula simple calcula la venta de cada articulo y el total vendido."]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"LinK:"]

{"sheet":"Puntuacion","index":1,"n_rows":550,"n_cols":31,"rows_kept":550,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.asesoriasmipyme.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Principiante","Basico","Intermedio","Avanzado"," Puntos Aprobados","Total Puntos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(X20/X38)+(X21/X38)+(X22/X38)+(X23/X38)","v":0},{"$f":"(Y20/Y38)+(Y21/Y38)+(Y22/Y38)+(Y23/Y38)+(Y24/Y38)","v":0},{"$f":"(Z20/Z38)+(Z21/Z38)+(Z22/Z38)+(Z23/Z38)+(Z24/Z38)+(Z25/Z38)+(Z26/Z38)+(Z27/Z38)+(Z28/Z38)","v":0},{"$f":"(AA20/AA38)+(AA21/AA38)+(AA22/AA38)+(AA23/AA38)+(AA24/AA38)+(AA25/AA38)+(AA26/AA38)+(AA27/AA38)+(AA28/AA38)+(AA29/AA38)+(AA30/AA38)+(AA31/AA38)+(AA32/AA38)+(AA33/AA38)+(AA34/AA38)+(AA35/AA38)","v":0},{"$f":"X37+Y37+Z37+AA37","v":0},195]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Principiante","Basico","Intermedio","Avanzado","Principiante","Basico","Intermedio","Avanzado"," Puntos Aprobados","Total Puntos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.2,0.3,0.4,"Supérate todos los días  y cada día tus sueños estarán más cerca de ser alcanzados."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Principiante",{"$f":"T20+T21+T22+T23","v":0},{"$f":"IF(Evaluador!G9=0.333333333333333,5,0)","v":0},{"$f":"IF(Evaluador!H22=789763.73,5,0)","v":0},{"$f":"IF(Evaluador!J64=3.26,25,0)","v":0},{"$f":"IF(Evaluador!J64=5,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"basico",{"$f":"U20","v":0},{"$f":"IF(Evaluador!G10=0.666666666666667,5,0)","v":0},{"$f":"IF(Evaluador!J9=7.83333333333333,5,0)","v":0},{"$f":"IF(Evaluador!I64=3.81666666666667,5,0)","v":0},{"$f":"IF(Evaluador!J65=10,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermedio",{"$f":"V20","v":0},{"$f":"IF(Evaluador!H11=15000,5,0)","v":0},{"$f":"IF(Evaluador!J12=20,5,0)","v":0},{"$f":"IF(Evaluador!I65=3.57,5,0)","v":0},{"$f":"IF(Evaluador!J63=29,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermedio",{"$f":"V21","v":0},{"$f":"IF(Evaluador!I11=3750000,5,0)","v":0},{"$f":"IF(Evaluador!J16=3,5,0)","v":0},{"$f":"IF(Evaluador!I66=3.7,5,0)","v":0},{"$f":"IF(Evaluador!J9=0.17,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermedio",{"$f":"V25","v":0},null,{"$f":"IF(Evaluador!J19=2,5,0)","v":0},{"$f":"IF(Evaluador!I67=3,5,0)","v":0},{"$f":"IF(Evaluador!J10=0.55,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermedio",{"$f":"V25","v":0},null,null,{"$f":"IF(Evaluador!H64=5,10,0)","v":0},{"$f":"IF(Evaluador!J11=0.17,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avanzado",{"$f":"W20","v":0},null,null,{"$f":"IF(R31=\"30\",5,0)","v":0},{"$f":"IF(Evaluador!J12=0.15,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avanzado",{"$f":"W22","v":0},null,null,{"$f":"IF(R32=\"6\",5,0)","v":0},{"$f":"IF(Evaluador!J13=0.17,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avanzado",{"$f":"(W23+W24+W25+W26+W27+W28+W29+W30+W31)/2","v":0},null,null,{"$f":"IF(R33=\"20\",5,0)","v":0},{"$f":"IF(Evaluador!J14=0.1,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avanzado",{"$f":"W32+W33+W34+W35","v":0},null,null,null,{"$f":"IF(Evaluador!J17=0.12,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acanzado",{"$f":"S28+S29","v":0},null,null,null,{"$f":"IF(Evaluador!J16=0.1,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Evaluador!G20","v":0},null,null,null,null,{"$f":"IF(Evaluador!J17=0.12,5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Evaluador!H21","v":0},null,null,null,null,{"$f":"IF(Evaluador!I9=\"Ingenieria Civil Distancia\",5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Evaluador!I23","v":0},null,null,null,null,{"$f":"IF(Evaluador!I47=\"Especialización Diseño y Construcción de Vias y Aeropistas\",5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INTERMEDIO",{"$f":"V28+V27+V26","v":0},null,null,null,{"$f":"IF(Evaluador!I14=\"Ingenieria Civil Distancia\",5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Evaluador!I42=\"Maestria en Gestion de Riesgo y Desarrollo\",5,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T35)","v":0},{"$f":"SUM(U20:U35)","v":0},{"$f":"SUM(V20:V35)","v":0},0,{"$f":"SUM(X20:X36)","v":0},{"$f":"SUM(Y20:Y36)","v":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,20,25,70,80]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"DESCRIPCIÓN","UNIDADES","COSTO","IVA","TOTAL",null,"Promedio de UND."]
[null,null,null,"Llavero P.V.C. -5 Tintas Total",4,7969]
[null,null,null,"Llavero Alto Relieve -3 Tintas",12,5969]
[null,null,null,"Llavero Alto Relieve Doble Cara -3 Tintas",10,3969,null,null,null,"Maximo UND"]
[null,null,null,"Llavero Correa Alto Relieve -3 Tintas",14,2969]
[null,null,null,"Llavero Alto Relieve Mosquetón -3 Tintas ",20,9969]
[null,null,null,"Llavero Pasta (Rectangular uno, Ovalo) - 1Tinta",5,3969]
[null,null,null,"Llavero Antiestres  Full Color",5,8969,null,null,null,"Minimo UND"]
[null,null,null,"Llavero Capsula Rectangular – Full Color",8,10969]
[null,null,null,"Llavero Candado – 1 Tinta",3,6000]
[null,null,null,"Llavero Termoformado Alto Relieve 1 Tinta",5,5899,null,null,null,"UND > 12"]
[null,null,null,"Llavero  Inflado    2 tintas por cara",3,4865]
[null,null,null,"Llavero Destapador Anillo - 1 Tinta",5,12999,null,null,null,"IVA "]
[null,null,null,null,null,null,null,null,null,0.19]
[null,null,null,"SUMA"]
[null,null,null,"Calcula los siguientes datos:"]
[null,null,null,"IVA= COSTO*IVA (emplea referencias absolutas) ."]
[null,null,null,"TOTAL= COSTO+IVA"]
[null,null,null,"Calcular = Promedio, Max.UND, Min  UND y Und >12"]
[]
[null,null,null,"Numero","Codigo carrera","Nombre","Salario","Promedio semestral","Genero","Numero de hijos"]
[null,null,null,1,40,"ABELLA HERRERA WILLIAM EFRAIN",331389,3.1,"f",3]
[null,null,null,2,40,"ACOSTA FAUSTO JOSE",1381508,2.9,"m",1]
[null,null,null,3,60,"ACOSTA PEREGRINO",571675,4.0999999999999996,"m",1]
[null,null,null,4,50,"ACOSTA ARAGON MARIA AMPARO",999364,3.4,"m",0]
[null,null,null,5,60,"AGREDO MENDEZ GUEFRY LEIDER",453679,4.5,"m",1]
[null,null,null,6,50,"AGREDO TOBAR XIMENA LUCIA",1090965,5,"F",3]
[null,null,null,7,80,"AGREDO TORRES GUILLERMO ALEJA",944250,3.7,"f",3]
[null,null,null,8,30,"AGUDELO DE LOPEZ NORA ELENA",684934,3.4,"f",2]
[null,null,null,9,30,"AGUIRRE GARCIA JUAN CARLOS",537773,4.8,"f",2]
[null,null,null,10,50,"10 10537683 ALBAN LOPEZ NOE",531230,4,"f",1]
[null,null,null,11,10,"ALEGRIA FERNANDEZ DIEGO ALONSO",531562,5,"f",1]
[null,null,null,12,60,"ALEGRIA VELASQUEZ CARLOS ALBERTO",835521,5,"f",2]
[null,null,null,13,20,"ALVAREZ JARAMILLO LUIS EVELIO",805670,4.5999999999999996,"f",2]
[null,null,null,14,60,"ALVAREZ VEJARANO MARIA CECILIA",562376,3.1,"m",1]
[null,null,null,15,60,"ALVEAR ORTEGA LUIS GERARDO",494508,2.2999999999999998,"m",2]
[null,null,null,16,90,"ALZATE CAMAYO MARY LUZ",1018238,3.8,"f",2]
[null,null,null,17,10,"ANAYA CABRERA LUIS ALFONSO",1351223,2.5,"m",3]
[null,null,null,18,70,"ANAYA HIDALGO CARLOS ALBERTO",974562,3.1,"f",2]
[null,null,null,19,20,"ANDRADE DE VALENCIA LUZ AMPARO",789229,2.4,"f",0]
[null,null,null,20,70,"ANDRADE G GERARDO MESIAS",1224732,3.6,"F",1]
[null,null,null,21,70,"ANDRADE REINOSO ESPERANZA",502095,3.5,"m",3]
[null,null,null,22,40,"ANDRADE SOSSA CAMILO ERNESTO",595322,3.4,"f",2]
[null,null,null,23,70,"ARANGO GAVIRIA IRMA PIEDAD",1420885,2.9,"f",1]
[null,null,null,24,70,"ARANGO QUINTANA MILTON",480100,3.1,"f",1]
[null,null,null,25,30,"ARBOLEDA V CARLOS ALBERTO",1441190,4.2,"f",2]
[null,null,null,26,10,"ARCINIEGAS MOLINA LUCIA INES",731312,2.6,"f",0]
[null,null,null,27,90,"ARCOS ARCOS VICTOR ANDRES",308607,2.9,"f",2]
[null,null,null,28,30,"ARCOS DE CHILITO MA ELENA",780117,5,"f",2]
[null,null,null,29,20,"ARCOS LEGARDA YOLANDA DEL CARMEN",387661,2.6,"f",1]
[null,null,null,30,30,"ARENAS DE ESCOBAR MA MARGOTH",416475,4.3,"f",1]
[null,null,null,31,60,"ARENAS LOZANO HUGO LEON",1145220,3,"f",2]
[null,null,null,32,60,"AREVALO SANDOVAL MARTHA EUGENIA",1461895,3.7,"M",2]
[null,null,null,33,20,"ARIAS SARAY LUZ ANGELICA",480070,3.6,"f",1]
[null,null,null,34,50,"ARISTIZABAL MAGNOLIA",380424,5,"f",0]
[null,null,null,35,90,"ARTEAGA FLOREZ JOSE ORLANDO",587651,2.6,"f",2]
[null,null,null,36,10,"ASTAIZA PERAFAN ELIZABET",395252,3.7,"m",1]
[null,null,null,37,30,"ASTAIZA SALAZAR ANTONIO JOSE EV",1393725,4,"f",2]
[null,null,null,38,70,"ASTUDILLO HORACIO",1416278,3.6,"F",1]
[null,null,null,39,60,"ASTUDILLO FERNANDEZ MARIA DEL PILAR",424262,2.9,"m",2]
[null,null,null,40,20,"ASTUDILLO MOSQUERA EDGAR OSWALDO",524695,4.5,"m",0]
[null,null,null,41,60,"ASTUDILLO MUNOZ FABIO ALDEMAR",342501,3.9,"m",1]
[null,null,null,42,10,"ASTUDILLO PEREZ MARIA YENSI",306975,5,"m",1]
[null,null,null,43,50,"ASTUDILLO SALAZAR FERNANDO ENRIQUE",607280,3.8,"m",3]
[null,null,null,44,10,"AVENDANO CUERVO SILVIO",393148,4.0999999999999996,"F",1]
[null,null,null,45,60,"AVILA GONZALEZ GLORIA INES",1499273,3.2,"f",0]
[null,null,null,46,20,"AYALA CARLOS HUGO",1152856,3.7,"f",1]
[null,null,null,47,50,"AYALA CALDAS JORGE ENRIQUE",1057688,4.0999999999999996,"f",2]
[null,null,null,48,30,"BARRAGAN RAMIREZ JESUS ALBERTO",518346,4.5999999999999996,"m",0]
[null,null,null,49,90,"BARRETO SUAREZ LUIS",1475243,2.7,"f",2]
[null,null,null,50,30," BASTIDAS ESCOBAR HENRY GIOVANNI",854588,3.5,"m",1]
[]
[null,null,null,"Codigo carrera","Nombre Carrera",null,"1. Calcular el promedio del promedio semestral "]
[null,null,null,10,"Ing. Industrial",null,"de las mujeres que estudian Economia"]
[null,null,null,20,"Administración"]
[null,null,null,30,"Contaduria",null,null,"Genero","Cod. Carrera","Promedio"]
[null,null,null,40,"Veterinaria",null,null,"f",{"$f":"D155","v":70}]
[null,null,null,50,"Zootecnia"]
[null,null,null,60,"Ing. Electronica"]
[null,null,null,70,"Economia"]
[null,null,null,80,"Ing. Civil"]
[null,null,null,90,"Ing. Ambiental "]
[]
[]
[null,null,null,null,"Numero","Codigo carrera","Nombre","Salario","Promedio semestral","Genero","Numero de hijos"]
[null,null,null,null,1,40,"ABELLA HERRERA WILLIAM EFRAIN",331389,3.1,"f",3]
[null,null,null,null,2,40,"ACOSTA FAUSTO JOSE",1381508,2.9,"m",1]
[null,null,null,null,3,60,"ACOSTA PEREGRINO",571675,4.0999999999999996,"m",1]
[null,null,null,null,4,50,"ACOSTA ARAGON MARIA AMPARO",999364,3.4,"m",0]
[null,null,null,null,5,60,"AGREDO MENDEZ GUEFRY LEIDER",453679,4.5,"m",1]
[null,null,null,null,6,50,"AGREDO TOBAR XIMENA LUCIA",1090965,5,"F",3]
[null,null,null,null,7,80,"AGREDO TORRES GUILLERMO ALEJA",944250,3.7,"f",3]
[null,null,null,null,8,30,"AGUDELO DE LOPEZ NORA ELENA",684934,3.4,"f",2]
[null,null,null,null,9,30,"AGUIRRE GARCIA JUAN CARLOS",537773,4.8,"f",2]
[null,null,null,null,10,50,"10 10537683 ALBAN LOPEZ NOE",531230,4,"f",1]
[null,null,null,null,11,10,"ALEGRIA FERNANDEZ DIEGO ALONSO",531562,5,"f",1]
[null,null,null,null,12,60,"ALEGRIA VELASQUEZ CARLOS ALBERTO",835521,5,"f",2]
[null,null,null,null,13,20,"ALVAREZ JARAMILLO LUIS EVELIO",805670,4.5999999999999996,"f",2]
[null,null,null,null,14,60,"ALVAREZ VEJARANO MARIA CECILIA",562376,3.1,"m",1]
[null,null,null,null,15,60,"ALVEAR ORTEGA LUIS GERARDO",494508,2.2999999999999998,"m",2]
[null,null,null,null,16,90,"ALZATE CAMAYO MARY LUZ",1018238,3.8,"f",2]
[null,null,null,null,17,10,"ANAYA CABRERA LUIS ALFONSO",1351223,2.5,"m",3]
[null,null,null,null,18,70,"ANAYA HIDALGO CARLOS ALBERTO",974562,3.1,"f",2]
[null,null,null,null,19,20,"ANDRADE DE VALENCIA LUZ AMPARO",789229,2.4,"f",0]
[null,null,null,null,20,70,"ANDRADE G GERARDO MESIAS",1224732,3.6,"F",1]
[null,null,null,null,21,70,"ANDRADE REINOSO ESPERANZA",502095,3.5,"m",3]
[null,null,null,null,22,40,"ANDRADE SOSSA CAMILO ERNESTO",595322,3.4,"f",2]
[null,null,null,null,23,70,"ARANGO GAVIRIA IRMA PIEDAD",1420885,2.9,"f",1]
[null,null,null,null,24,70,"ARANGO QUINTANA MILTON",480100,3.1,"f",1]
[null,null,null,null,25,30,"ARBOLEDA V CARLOS ALBERTO",1441190,4.2,"f",2]
[null,null,null,null,26,10,"ARCINIEGAS MOLINA LUCIA INES",731312,2.6,"f",0]
[null,null,null,null,27,90,"ARCOS ARCOS VICTOR ANDRES",308607,2.9,"f",2]
[null,null,null,null,28,30,"ARCOS DE CHILITO MA ELENA",780117,5,"f",2]
[null,null,null,null,29,20,"ARCOS LEGARDA YOLANDA DEL CARMEN",387661,2.6,"f",1]
[null,null,null,null,30,30,"ARENAS DE ESCOBAR MA MARGOTH",416475,4.3,"f",1]
[null,null,null,null,31,60,"ARENAS LOZANO HUGO LEON",1145220,3,"f",2]
[null,null,null,null,32,60,"AREVALO SANDOVAL MARTHA EUGENIA",1461895,3.7,"M",2]
[null,null,null,null,33,20,"ARIAS SARAY LUZ ANGELICA",480070,3.6,"f",1]
[null,null,null,null,34,50,"ARISTIZABAL MAGNOLIA",380424,5,"f",0]
[null,null,null,null,35,90,"ARTEAGA FLOREZ JOSE ORLANDO",587651,2.6,"f",2]
[null,null,null,null,36,10,"ASTAIZA PERAFAN ELIZABET",395252,3.7,"m",1]
[null,null,null,null,37,30,"ASTAIZA SALAZAR ANTONIO JOSE EV",1393725,4,"f",2]
[null,null,null,null,38,70,"ASTUDILLO HORACIO",1416278,3.6,"F",1]
[null,null,null,null,39,60,"ASTUDILLO FERNANDEZ MARIA DEL PILAR",424262,2.9,"m",2]
[null,null,null,null,40,20,"ASTUDILLO MOSQUERA EDGAR OSWALDO",524695,4.5,"m",0]
[null,null,null,null,41,60,"ASTUDILLO MUNOZ FABIO ALDEMAR",342501,3.9,"m",1]
[null,null,null,null,42,10,"ASTUDILLO PEREZ MARIA YENSI",306975,5,"m",1]
[null,null,null,null,43,50,"ASTUDILLO SALAZAR FERNANDO ENRIQUE",607280,3.8,"m",3]
[null,null,null,null,44,10,"AVENDANO CUERVO SILVIO",393148,4.0999999999999996,"F",1]
[null,null,null,null,45,60,"AVILA GONZALEZ GLORIA INES",1499273,3.2,"f",0]
[null,null,null,null,46,20,"AYALA CARLOS HUGO",1152856,3.7,"f",1]
[null,null,null,null,47,50,"AYALA CALDAS JORGE ENRIQUE",1057688,4.0999999999999996,"f",2]
[null,null,null,null,48,30,"BARRAGAN RAMIREZ JESUS ALBERTO",518346,4.5999999999999996,"m",0]
[null,null,null,null,49,90,"BARRETO SUAREZ LUIS",1475243,2.7,"f",2]
[null,null,null,null,50,30," BASTIDAS ESCOBAR HENRY GIOVANNI",854588,3.5,"m",1]
[]
[null,null,null,null,"Codigo carrera","Nombre Carrera",null,"2. Calcular el promedio del promedio semestral de los estudiantes "]
[null,null,null,null,10,"Ing. Industrial",null,"de ingenieria"]
[null,null,null,null,20,"Administración"]
[null,null,null,null,30,"Contaduria",null,null,"cod. Carrera","Promedio"]
[null,null,null,null,40,"Veterinaria",null,null,{"$f":"E213","v":10}]
[null,null,null,null,50,"Zootecnia",null,null,{"$f":"E218","v":60}]
[null,null,null,null,60,"Ing. Electronica",null,null,{"$f":"E220","v":80}]
[null,null,null,null,70,"Economia",null,null,{"$f":"E221","v":90}]
[null,null,null,null,80,"Ing. Civil"]
[null,null,null,null,90,"Ing. Ambiental "]
[]
[]
[]
[null,null,null,null,null,"Descripcion","Unidades Vendidas","Porcentaje","Precio de venta","Ventas "]
[null,null,null,null,null,"Articulo 1",150,null,5000]
[null,null,null,null,null,"Articulo 2",300,null,10000]
[null,null,null,null,null,"TOTAL",450]
[]
[null,null,null,null,null,"1) calcula con una suma simple el total de unidades vendidas"]
[null,null,null,null,null,"2 ¿Cuánto representa la venta de unidades de cada articulo con respecto al total?"]
[null,null,null,null,null,"3) Con una formula simple calcula la venta de cada articulo y el total vendido."]
[]
[]
[null,null,null,null,"Numero","Codigo carrera","Nombre","Salario","Promedio semestral","Genero","Numero de hijos"]
[null,null,null,null,1,40,"ABELLA HERRERA WILLIAM EFRAIN",331389,3.1,"f",3]
[null,null,null,null,2,40,"ACOSTA FAUSTO JOSE",1381508,2.9,"m",1]
[null,null,null,null,3,60,"ACOSTA PEREGRINO",571675,4.0999999999999996,"m",1]
[null,null,null,null,4,50,"ACOSTA ARAGON MARIA AMPARO",999364,3.4,"m",0]
[null,null,null,null,5,60,"AGREDO MENDEZ GUEFRY LEIDER",453679,4.5,"m",1]
[null,null,null,null,6,50,"AGREDO TOBAR XIMENA LUCIA",1090965,5,"f",3]
[null,null,null,null,7,80,"AGREDO TORRES GUILLERMO ALEJA",944250,3.7,"f",3]
[null,null,null,null,8,30,"AGUDELO DE LOPEZ NORA ELENA",684934,3.4,"f",2]
[null,null,null,null,9,30,"AGUIRRE GARCIA JUAN CARLOS",537773,4.8,"f",2]
[null,null,null,null,10,50,"10 10537683 ALBAN LOPEZ NOE",531230,4,"f",1]
[null,null,null,null,11,10,"ALEGRIA FERNANDEZ DIEGO ALONSO",531562,5,"f",1]
[null,null,null,null,12,60,"ALEGRIA VELASQUEZ CARLOS ALBERTO",835521,5,"f",2]
[null,null,null,null,13,20,"ALVAREZ JARAMILLO LUIS EVELIO",805670,4.5999999999999996,"f",2]
[null,null,null,null,14,60,"ALVAREZ VEJARANO MARIA CECILIA",562376,3.1,"m",1]
[null,null,null,null,15,60,"ALVEAR ORTEGA LUIS GERARDO",494508,2.2999999999999998,"m",2]
[null,null,null,null,16,90,"ALZATE CAMAYO MARY LUZ",1018238,3.8,"f",2]
[null,null,null,null,17,10,"ANAYA CABRERA LUIS ALFONSO",1351223,2.5,"m",3]
[null,null,null,null,18,70,"ANAYA HIDALGO CARLOS ALBERTO",974562,3.1,"f",2]
[null,null,null,null,19,20,"ANDRADE DE VALENCIA LUZ AMPARO",789229,2.4,"f",0]
[null,null,null,null,20,70,"ANDRADE G GERARDO MESIAS",1224732,3.6,"f",1]
[null,null,null,null,21,70,"ANDRADE REINOSO ESPERANZA",502095,3.5,"m",3]
[null,null,null,null,22,40,"ANDRADE SOSSA CAMILO ERNESTO",595322,3.4,"f",2]
[null,null,null,null,23,70,"ARANGO GAVIRIA IRMA PIEDAD",1420885,2.9,"f",1]
[null,null,null,null,24,70,"ARANGO QUINTANA MILTON",480100,3.1,"f",1]
[null,null,null,null,25,30,"ARBOLEDA V CARLOS ALBERTO",1441190,4.2,"f",2]
[null,null,null,null,26,10,"ARCINIEGAS MOLINA LUCIA INES",731312,2.6,"f",0]
[null,null,null,null,27,90,"ARCOS ARCOS VICTOR ANDRES",308607,2.9,"f",2]
[null,null,null,null,28,30,"ARCOS DE CHILITO MA ELENA",780117,5,"f",2]
[null,null,null,null,29,20,"ARCOS LEGARDA YOLANDA DEL CARMEN",387661,2.6,"f",1]
[null,null,null,null,30,30,"ARENAS DE ESCOBAR MA MARGOTH",416475,4.3,"f",1]
[null,null,null,null,31,60,"ARENAS LOZANO HUGO LEON",1145220,3,"f",2]
[null,null,null,null,32,60,"AREVALO SANDOVAL MARTHA EUGENIA",1461895,3.7,"m",2]
[null,null,null,null,33,20,"ARIAS SARAY LUZ ANGELICA",480070,3.6,"f",1]
[null,null,null,null,34,50,"ARISTIZABAL MAGNOLIA",380424,5,"f",0]
[null,null,null,null,35,90,"ARTEAGA FLOREZ JOSE ORLANDO",587651,2.6,"f",2]
[null,null,null,null,36,10,"ASTAIZA PERAFAN ELIZABET",395252,3.7,"m",1]
[null,null,null,null,37,30,"ASTAIZA SALAZAR ANTONIO JOSE EV",1393725,4,"f",2]
[null,null,null,null,38,70,"ASTUDILLO HORACIO",1416278,3.6,"F",1]
[null,null,null,null,39,60,"ASTUDILLO FERNANDEZ MARIA DEL PILAR",424262,2.9,"m",2]
[null,null,null,null,40,20,"ASTUDILLO MOSQUERA EDGAR OSWALDO",524695,4.5,"m",0]
[null,null,null,null,41,60,"ASTUDILLO MUNOZ FABIO ALDEMAR",342501,3.9,"m",1]
[null,null,null,null,42,10,"ASTUDILLO PEREZ MARIA YENSI",306975,5,"m",1]
[null,null,null,null,43,50,"ASTUDILLO SALAZAR FERNANDO ENRIQUE",607280,3.8,"m",3]
[null,null,null,null,44,10,"AVENDANO CUERVO SILVIO",393148,4.0999999999999996,"f",1]
[null,null,null,null,45,60,"AVILA GONZALEZ GLORIA INES",1499273,3.2,"f",0]
[null,null,null,null,46,20,"AYALA CARLOS HUGO",1152856,3.7,"f",1]
[null,null,null,null,47,50,"AYALA CALDAS JORGE ENRIQUE",1057688,4.0999999999999996,"f",2]
[null,null,null,null,48,30,"BARRAGAN RAMIREZ JESUS ALBERTO",518346,4.5999999999999996,"m",0]
[null,null,null,null,49,90,"BARRETO SUAREZ LUIS",1475243,2.7,"f",2]
[null,null,null,null,50,30," BASTIDAS ESCOBAR HENRY GIOVANNI",854588,3.5,"m",1]
[]
[]
[null,null,null,null,null,"3. Calcule el maximo promedio semestral de las mujeres y hombres con hijos"]
[]
[null,null,null,null,null,null,null,"Condicion","Max. Promedio"]
[null,null,null,null,null,null,null," > 0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Numero","Codigo carrera","Nombre","Salario","Promedio semestral","Genero","Numero de hijos"]
[null,null,null,null,1,40,"ABELLA HERRERA WILLIAM EFRAIN",331389,3.1,"f",3]
[null,null,null,null,2,40,"ACOSTA FAUSTO JOSE",1381508,2.9,"m",1]
[null,null,null,null,3,60,"ACOSTA PEREGRINO",571675,4.0999999999999996,"m",1]
[null,null,null,null,4,50,"ACOSTA ARAGON MARIA AMPARO",999364,3.4,"m",0]
[null,null,null,null,5,60,"AGREDO MENDEZ GUEFRY LEIDER",453679,4.5,"m",1]
[null,null,null,null,6,50,"AGREDO TOBAR XIMENA LUCIA",1090965,5,"F",3]
[null,null,null,null,7,80,"AGREDO TORRES GUILLERMO ALEJA",944250,3.7,"f",3]
[null,null,null,null,8,30,"AGUDELO DE LOPEZ NORA ELENA",684934,3.4,"f",2]
[null,null,null,null,9,30,"AGUIRRE GARCIA JUAN CARLOS",537773,4.8,"f",2]
[null,null,null,null,10,50,"10 10537683 ALBAN LOPEZ NOE",531230,4,"f",1]
[null,null,null,null,11,10,"ALEGRIA FERNANDEZ DIEGO ALONSO",531562,5,"f",1]
[null,null,null,null,12,60,"ALEGRIA VELASQUEZ CARLOS ALBERTO",835521,5,"f",2]
[null,null,null,null,13,20,"ALVAREZ JARAMILLO LUIS EVELIO",805670,4.5999999999999996,"f",2]
[null,null,null,null,14,60,"ALVAREZ VEJARANO MARIA CECILIA",562376,3.1,"m",1]
[null,null,null,null,15,60,"ALVEAR ORTEGA LUIS GERARDO",494508,2.2999999999999998,"m",2]
[null,null,null,null,16,90,"ALZATE CAMAYO MARY LUZ",1018238,3.8,"f",2]
[null,null,null,null,17,10,"ANAYA CABRERA LUIS ALFONSO",1351223,2.5,"m",3]
[null,null,null,null,18,70,"ANAYA HIDALGO CARLOS ALBERTO",974562,3.1,"f",2]
[null,null,null,null,19,20,"ANDRADE DE VALENCIA LUZ AMPARO",789229,2.4,"f",0]
[null,null,null,null,20,70,"ANDRADE G GERARDO MESIAS",1224732,3.6,"F",1]
[null,null,null,null,21,70,"ANDRADE REINOSO ESPERANZA",502095,3.5,"m",3]
[null,null,null,null,22,40,"ANDRADE SOSSA CAMILO ERNESTO",595322,3.4,"f",2]
[null,null,null,null,23,70,"ARANGO GAVIRIA IRMA PIEDAD",1420885,2.9,"f",1]
[null,null,null,null,24,70,"ARANGO QUINTANA MILTON",480100,3.1,"f",1]
[null,null,null,null,25,30,"ARBOLEDA V CARLOS ALBERTO",1441190,4.2,"f",2]
[null,null,null,null,26,10,"ARCINIEGAS MOLINA LUCIA INES",731312,2.6,"f",0]
[null,null,null,null,27,90,"ARCOS ARCOS VICTOR ANDRES",308607,2.9,"f",2]
[null,null,null,null,28,30,"ARCOS DE CHILITO MA ELENA",780117,5,"f",2]
[null,null,null,null,29,20,"ARCOS LEGARDA YOLANDA DEL CARMEN",387661,2.6,"f",1]
[null,null,null,null,30,30,"ARENAS DE ESCOBAR MA MARGOTH",416475,4.3,"f",1]
[null,null,null,null,31,60,"ARENAS LOZANO HUGO LEON",1145220,3,"f",2]
[null,null,null,null,32,60,"AREVALO SANDOVAL MARTHA EUGENIA",1461895,3.7,"M",2]
[null,null,null,null,33,20,"ARIAS SARAY LUZ ANGELICA",480070,3.6,"f",1]
[null,null,null,null,34,50,"ARISTIZABAL MAGNOLIA",380424,5,"f",0]
[null,null,null,null,35,90,"ARTEAGA FLOREZ JOSE ORLANDO",587651,2.6,"f",2]
[null,null,null,null,36,10,"ASTAIZA PERAFAN ELIZABET",395252,3.7,"m",1]
[null,null,null,null,37,30,"ASTAIZA SALAZAR ANTONIO JOSE EV",1393725,4,"f",2]
[null,null,null,null,38,70,"ASTUDILLO HORACIO",1416278,3.6,"F",1]
[null,null,null,null,39,60,"ASTUDILLO FERNANDEZ MARIA DEL PILAR",424262,2.9,"m",2]
[null,null,null,null,40,20,"ASTUDILLO MOSQUERA EDGAR OSWALDO",524695,4.5,"m",0]
[null,null,null,null,41,60,"ASTUDILLO MUNOZ FABIO ALDEMAR",342501,3.9,"m",1]
[null,null,null,null,42,10,"ASTUDILLO PEREZ MARIA YENSI",306975,5,"m",1]
[null,null,null,null,43,50,"ASTUDILLO SALAZAR FERNANDO ENRIQUE",607280,3.8,"m",3]
[null,null,null,null,44,10,"AVENDANO CUERVO SILVIO",393148,4.0999999999999996,"F",1]
[null,null,null,null,45,60,"AVILA GONZALEZ GLORIA INES",1499273,3.2,"f",0]
[null,null,null,null,46,20,"AYALA CARLOS HUGO",1152856,3.7,"f",1]
[null,null,null,null,47,50,"AYALA CALDAS JORGE ENRIQUE",1057688,4.0999999999999996,"f",2]
[null,null,null,null,48,30,"BARRAGAN RAMIREZ JESUS ALBERTO",518346,4.5999999999999996,"m",0]
[null,null,null,null,49,90,"BARRETO SUAREZ LUIS",1475243,2.7,"f",2]
[null,null,null,null,50,30," BASTIDAS ESCOBAR HENRY GIOVANNI",854588,3.5,"m",1]
[]
[null,null,null,null,null,null,null,null,"4. Sumatoria de hijos de estudiantes hombres de "]
[null,null,null,null,null,"Codigo carrera","Nombre Carrera",null,"ingenierias"]
[null,null,null,null,null,10,"Ing. Industrial"]
[null,null,null,null,null,20,"Administración",null,"Genero","cod. Carrera","Sumatoria"]
[null,null,null,null,null,30,"Contaduria",null,"m",10]
[null,null,null,null,null,40,"Veterinaria",null,"m",60]
[null,null,null,null,null,50,"Zootecnia",null,"m",80]
[null,null,null,null,null,60,"Ing. Electronica",null,"m",90]
[null,null,null,null,null,70,"Economia",null,null,"Sumatoria total"]
[null,null,null,null,null,80,"Ing. Civil"]
[null,null,null,null,null,90,"Ing. Ambiental "]
[]
[]
[]
[null,null,null,null,"Numero","Codigo carrera","Nombre","Salario","Promedio semestral","Genero","Numero de hijos"]
[null,null,null,null,1,40,"ABELLA HERRERA WILLIAM EFRAIN",331389,3.1,"f",3]
[null,null,null,null,2,40,"ACOSTA FAUSTO JOSE",1381508,2.9,"m",1]
[null,null,null,null,3,60,"ACOSTA PEREGRINO",571675,4.0999999999999996,"m",1]
[null,null,null,null,4,50,"ACOSTA ARAGON MARIA AMPARO",999364,3.4,"m",0]
[null,null,null,null,5,60,"AGREDO MENDEZ GUEFRY LEIDER",453679,4.5,"m",1]
[null,null,null,null,6,50,"AGREDO TOBAR XIMENA LUCIA",1090965,5,"F",3]
[null,null,null,null,7,80,"AGREDO TORRES GUILLERMO ALEJA",944250,3.7,"f",3]
[null,null,null,null,8,30,"AGUDELO DE LOPEZ NORA ELENA",684934,3.4,"f",2]
[null,null,null,null,9,30,"AGUIRRE GARCIA JUAN CARLOS",537773,4.8,"f",2]
[null,null,null,null,10,50,"10 10537683 ALBAN LOPEZ NOE",531230,4,"f",1]
[null,null,null,null,11,10,"ALEGRIA FERNANDEZ DIEGO ALONSO",531562,5,"f",1]
[null,null,null,null,12,60,"ALEGRIA VELASQUEZ CARLOS ALBERTO",835521,5,"f",2]
[null,null,null,null,13,20,"ALVAREZ JARAMILLO LUIS EVELIO",805670,4.5999999999999996,"f",2]
[null,null,null,null,14,60,"ALVAREZ VEJARANO MARIA CECILIA",562376,3.1,"m",1]
[null,null,null,null,15,60,"ALVEAR ORTEGA LUIS GERARDO",494508,2.2999999999999998,"m",2]
[null,null,null,null,16,90,"ALZATE CAMAYO MARY LUZ",1018238,3.8,"f",2]
[null,null,null,null,17,10,"ANAYA CABRERA LUIS ALFONSO",1351223,2.5,"m",3]
[null,null,null,null,18,70,"ANAYA HIDALGO CARLOS ALBERTO",974562,3.1,"f",2]
[null,null,null,null,19,20,"ANDRADE DE VALENCIA LUZ AMPARO",789229,2.4,"f",0]
[null,null,null,null,20,70,"ANDRADE G GERARDO MESIAS",1224732,3.6,"F",1]
[null,null,null,null,21,70,"ANDRADE REINOSO ESPERANZA",502095,3.5,"m",3]
[null,null,null,null,22,40,"ANDRADE SOSSA CAMILO ERNESTO",595322,3.4,"f",2]
[null,null,null,null,23,70,"ARANGO GAVIRIA IRMA PIEDAD",1420885,2.9,"f",1]
[null,null,null,null,24,70,"ARANGO QUINTANA MILTON",480100,3.1,"f",1]
[null,null,null,null,25,30,"ARBOLEDA V CARLOS ALBERTO",1441190,4.2,"f",2]
[null,null,null,null,26,10,"ARCINIEGAS MOLINA LUCIA INES",731312,2.6,"f",0]
[null,null,null,null,27,90,"ARCOS ARCOS VICTOR ANDRES",308607,2.9,"f",2]
[null,null,null,null,28,30,"ARCOS DE CHILITO MA ELENA",780117,5,"f",2]
[null,null,null,null,29,20,"ARCOS LEGARDA YOLANDA DEL CARMEN",387661,2.6,"f",1]
[null,null,null,null,30,30,"ARENAS DE ESCOBAR MA MARGOTH",416475,4.3,"f",1]
[null,null,null,null,31,60,"ARENAS LOZANO HUGO LEON",1145220,3,"f",2]
[null,null,null,null,32,60,"AREVALO SANDOVAL MARTHA EUGENIA",1461895,3.7,"M",2]
[null,null,null,null,33,20,"ARIAS SARAY LUZ ANGELICA",480070,3.6,"f",1]
[null,null,null,null,34,50,"ARISTIZABAL MAGNOLIA",380424,5,"f",0]
[null,null,null,null,35,90,"ARTEAGA FLOREZ JOSE ORLANDO",587651,2.6,"f",2]
[null,null,null,null,36,10,"ASTAIZA PERAFAN ELIZABET",395252,3.7,"m",1]
[null,null,null,null,37,30,"ASTAIZA SALAZAR ANTONIO JOSE EV",1393725,4,"f",2]
[null,null,null,null,38,70,"ASTUDILLO HORACIO",1416278,3.6,"F",1]
[null,null,null,null,39,60,"ASTUDILLO FERNANDEZ MARIA DEL PILAR",424262,2.9,"m",2]
[null,null,null,null,40,20,"ASTUDILLO MOSQUERA EDGAR OSWALDO",524695,4.5,"m",0]
[null,null,null,null,41,60,"ASTUDILLO MUNOZ FABIO ALDEMAR",342501,3.9,"m",1]
[null,null,null,null,42,10,"ASTUDILLO PEREZ MARIA YENSI",306975,5,"m",1]
[null,null,null,null,43,50,"ASTUDILLO SALAZAR FERNANDO ENRIQUE",607280,3.8,"m",3]
[null,null,null,null,44,10,"AVENDANO CUERVO SILVIO",393148,4.0999999999999996,"F",1]
[null,null,null,null,45,60,"AVILA GONZALEZ GLORIA INES",1499273,3.2,"f",0]
[null,null,null,null,46,20,"AYALA CARLOS HUGO",1152856,3.7,"f",1]
[null,null,null,null,47,50,"AYALA CALDAS JORGE ENRIQUE",1057688,4.0999999999999996,"f",2]
[null,null,null,null,48,30,"BARRAGAN RAMIREZ JESUS ALBERTO",518346,4.5999999999999996,"m",0]
[null,null,null,null,49,90,"BARRETO SUAREZ LUIS",1475243,2.7,"f",2]
[null,null,null,null,50,30," BASTIDAS ESCOBAR HENRY GIOVANNI",854588,3.5,"m",1]
[]
[null,null,null,null,null,"Codigo carrera","Nombre Carrera",null,"5. Contar las mujeres con hijos"]
[null,null,null,null,null,10,"Ing. Industrial"]
[null,null,null,null,null,20,"Administración",null,"Genero","Numero hijos","Conteo"]
[null,null,null,null,null,30,"Contaduria",null,"f",">0"]
[null,null,null,null,null,40,"Veterinaria"]
[null,null,null,null,null,50,"Zootecnia"]
[null,null,null,null,null,60,"Ing. Electronica"]
[null,null,null,null,null,70,"Economia"]
[null,null,null,null,null,80,"Ing. Civil"]
[null,null,null,null,null,90,"Ing. Ambiental "]
[]
[]
[]
[null,null,null,null,null,"Codigo","Codigo carrera","Nombre","Genero","Numero de Hijos","Nombre carrera en una sola formula)","Descuento por genero e hijos"]
[null,null,null,null,null,110253,10,"ABELLA HERRERA WILLIAM EFRAIN","F",2]
[null,null,null,null,null,650137,50,"ACOSTA FAUSTO JOSE","F",0]
[null,null,null,null,null,730155,30,"ACOSTA PEREGRINO","F",3]
[null,null,null,null,null,1040156,40,"ACOSTA ARAGON MARIA AMPARO","F",1]
[null,null,null,null,null,1150131,50,"AGREDO MENDEZ GUEFRY LEIDER","F",2]
[null,null,null,null,null,910150,10,"AGREDO TOBAR XIMENA LUCIA","M",1]
[null,null,null,null,null,20114,20,"AGREDO TORRES GUILLERMO ALEJA","M",4]
[null,null,null,null,null,150257,50,"AGUDELO DE LOPEZ NORA ELENA","M",1]
[null,null,null,null,null,1220218,20,"AGUIRRE GARCIA JUAN CARLOS","M",3]
[null,null,null,null,null,1110239,10,"10 10537683 ALBAN LOPEZ NOE","F",0]
[null,null,null,null,null,940104,40,"ALEGRIA FERNANDEZ DIEGO ALONSO","F",3]
[null,null,null,null,null,1230228,30,"ALEGRIA VELASQUEZ CARLOS ALBERTO","F",4]
[null,null,null,null,null,1330154,30,"ALVAREZ JARAMILLO LUIS EVELIO","F",0]
[null,null,null,null,null,1340112,40,"ALVAREZ VEJARANO MARIA CECILIA","F",2]
[null,null,null,null,null,130120,30,"ALVEAR ORTEGA LUIS GERARDO","F",2]
[null,null,null,null,null,820147,20,"ALZATE CAMAYO MARY LUZ","M",0]
[null,null,null,null,null,830249,30,"ANAYA CABRERA LUIS ALFONSO","M",1]
[null,null,null,null,null,220237,20,"ANAYA HIDALGO CARLOS ALBERTO","M",4]
[null,null,null,null,null,20115,20,"ANDRADE DE VALENCIA LUZ AMPARO","M",3]
[null,null,null,null,null,150252,50,"ANDRADE G GERARDO MESIAS","F",0]
[null,null,null,null,null,1240152,40,"ANDRADE REINOSO ESPERANZA","F",0]
[null,null,null,null,null,1150101,50,"ANDRADE SOSSA CAMILO ERNESTO","F",0]
[null,null,null,null,null,1010139,10,"ARANGO GAVIRIA IRMA PIEDAD","M",3]
[null,null,null,null,null,50238,50,"ARANGO QUINTANA MILTON","F",0]
[null,null,null,null,null,920210,20,"ARBOLEDA V CARLOS ALBERTO","M",4]
[null,null,null,null,null,350144,50,"ARCINIEGAS MOLINA LUCIA INES","F",3]
[null,null,null,null,null,720206,20,"ARCOS ARCOS VICTOR ANDRES","M",2]
[null,null,null,null,null,1210237,10,"ARCOS DE CHILITO MA ELENA","F",3]
[null,null,null,null,null,1250229,50,"ARCOS LEGARDA YOLANDA DEL CARMEN","M",2]
[null,null,null,null,null,710255,10,"ARENAS DE ESCOBAR MA MARGOTH","F",0]
[null,null,null,null,null,810113,10,"ARENAS LOZANO HUGO LEON","M",1]
[null,null,null,null,null,910128,10,"AREVALO SANDOVAL MARTHA EUGENIA","M",0]
[null,null,null,null,null,810107,10,"ARIAS SARAY LUZ ANGELICA","F",4]
[null,null,null,null,null,1140225,40,"ARISTIZABAL MAGNOLIA","F",4]
[null,null,null,null,null,1250242,50,"ARTEAGA FLOREZ JOSE ORLANDO","F",4]
[null,null,null,null,null,1050205,50,"ASTAIZA PERAFAN ELIZABET","M",2]
[null,null,null,null,null,130244,30,"ASTAIZA SALAZAR ANTONIO JOSE EV","F",3]
[null,null,null,null,null,940201,40,"ASTUDILLO HORACIO","F",2]
[null,null,null,null,null,120107,20,"ASTUDILLO FERNANDEZ MARIA DEL PILAR","F",1]
[]
[]
[null,null,null,null,null,"Explicacion del codigo",null,null,null,"COMPLETAR LA TABLA"]
[null,null,null,null,null,"Las dos primeras posiciones son el año de ingreso"]
[null,null,null,null,null,"Las dos siguientes posiciones son el codigo de la carrera"]
[null,null,null,null,null,"La siguiente posicion es el semestre del año",null,null,null,"1) Utiliza la formula buscar para encontrar la carrera "]
[null,null,null,null,null,"las dos ultimas posiciones son un consecutivo",null,null,null,"de cada estudiante."]
[]
[null,null,null,null,null,10,"Ingenieria Civil Distancia"]
[null,null,null,null,null,20,"Especialización Diseño y Construcción de Vias y Aeropistas",null,null,"2) Calcula el descuento por genero e hijos"]
[null,null,null,null,null,30,"Especialización tecnologica en Explosivos"]
[null,null,null,null,null,40,"Maestria en Gestion de Riesgo y Desarrollo"]
[null,null,null,null,null,50,"Especializacion en Gerencia Integral de Obras"]
[]
[]
[null,null,null,null,null,"Descuento"]
[null,null,null,null,null,"Si no tiene hijos"]
[null,null,null,null,null,null,"si es hombre 3%"]
[null,null,null,null,null,null,"si es mujer 55%"]
[null,null,null,null,null,"Si tiene al menos un hijo"]
[null,null,null,null,null,null,"si es hombre 10%"]
[null,null,null,null,null,null,"si es mujer 15%"]
[null,null,null,null,null,"Si tiene mas de un hijo"]
[null,null,null,null,null,null,"si es hombre 12%"]
[null,null,null,null,null,null,"si es mujer 17%"]
[]
[]
[]
[null,null,null,null,null,"Super has finalizado la prueba. Ecribanos en los comentarios como te ha parecido. :)"]
[]
[]
[]
[null,null,null,null,null,"Codigo","Nombre",null,"Carrera","Semestre","Consecutivo"]
[null,null,null,null,null,110253,"ABELLA HERRERA WILLIAM EFRAIN"]
[null,null,null,null,null,650137,"ACOSTA FAUSTO JOSE"]
[null,null,null,null,null,730355,"ACOSTA PEREGRINO"]
[null,null,null,null,null,1040156,"ACOSTA ARAGON MARIA AMPARO"]
[null,null,null,null,null,1150431,"AGREDO MENDEZ GUEFRY LEIDER"]
[null,null,null,null,null,910150,"AGREDO TOBAR XIMENA LUCIA"]
[null,null,null,null,null,20114,"AGREDO TORRES GUILLERMO ALEJA"]
[null,null,null,null,null,150257,"AGUDELO DE LOPEZ NORA ELENA"]
[null,null,null,null,null,1220218,"AGUIRRE GARCIA JUAN CARLOS"]
[null,null,null,null,null,1110239,"10 10537683 ALBAN LOPEZ NOE"]
[null,null,null,null,null,940104,"ALEGRIA FERNANDEZ DIEGO ALONSO"]
[null,null,null,null,null,1230228,"ALEGRIA VELASQUEZ CARLOS ALBERTO"]
[null,null,null,null,null,1330654,"ALVAREZ JARAMILLO LUIS EVELIO"]
[null,null,null,null,null,1340112,"ALVAREZ VEJARANO MARIA CECILIA"]
[null,null,null,null,null,130120,"ALVEAR ORTEGA LUIS GERARDO"]
[null,null,null,null,null,820147,"ALZATE CAMAYO MARY LUZ"]
[null,null,null,null,null,830249,"ANAYA CABRERA LUIS ALFONSO"]
[null,null,null,null,null,220237,"ANAYA HIDALGO CARLOS ALBERTO"]
[null,null,null,null,null,20115,"ANDRADE DE VALENCIA LUZ AMPARO"]
[null,null,null,null,null,150252,"ANDRADE G GERARDO MESIAS"]
[null,null,null,null,null,1240152,"ANDRADE REINOSO ESPERANZA"]
[null,null,null,null,null,1150101,"ANDRADE SOSSA CAMILO ERNESTO"]
[null,null,null,null,null,1010139,"ARANGO GAVIRIA IRMA PIEDAD"]
[null,null,null,null,null,50238,"ARANGO QUINTANA MILTON"]
[null,null,null,null,null,920210,"ARBOLEDA V CARLOS ALBERTO"]
[null,null,null,null,null,350144,"ARCINIEGAS MOLINA LUCIA INES"]
[null,null,null,null,null,720206,"ARCOS ARCOS VICTOR ANDRES"]
[null,null,null,null,null,1210237,"ARCOS DE CHILITO MA ELENA"]
[null,null,null,null,null,1250229,"ARCOS LEGARDA YOLANDA DEL CARMEN"]
[null,null,null,null,null,710255,"ARENAS DE ESCOBAR MA MARGOTH"]
[null,null,null,null,null,810113,"ARENAS LOZANO HUGO LEON"]
[null,null,null,null,null,910128,"AREVALO SANDOVAL MARTHA EUGENIA"]
[null,null,null,null,null,810307,"ARIAS SARAY LUZ ANGELICA"]
[null,null,null,null,null,1140225,"ARISTIZABAL MAGNOLIA"]
[null,null,null,null,null,1250242,"ARTEAGA FLOREZ JOSE ORLANDO"]
[null,null,null,null,null,1050205,"ASTAIZA PERAFAN ELIZABET"]
[null,null,null,null,null,130244,"ASTAIZA SALAZAR ANTONIO JOSE EV"]
[null,null,null,null,null,940201,"ASTUDILLO HORACIO"]
[null,null,null,null,null,120107,"ASTUDILLO FERNANDEZ MARIA DEL PILAR"]
[]
[null,null,null,null,null,"Explicacion de la celda Codigo"]
[null,null,null,null,null,"Las dos primeras posiciones son el año de ingreso",null,null,null,"1) Completar la tabla con la informacion del codigo"]
[null,null,null,null,null,"Las dos siguientes posiciones son el codigo de la carrera"]
[null,null,null,null,null,"La siguiente posicion es el semestre del año"]
[null,null,null,null,null,"las dos ultimas posiciones son un consecutivo"]