{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["REDONDEAR","ARRASTRAR FORMULA","CELDAS","OPERACIONES","ORDENAR","BUSCAR-V","SI CONDICIONAL LETRAS","SI CONDICIONAL NUMEROS","PORCENTAJES","PROMEDIO","SUMAY GRAFICO","GRÁFICOS","REFERENCIAS","SERIES","QUITAR DUPLICADOS","SUBTOTAL","TABLA DINAMICA 1","TABLA DINAMICA 2","SI Y","ATAJOS"],"not_rendered":{"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"REDONDEAR","index":0,"n_rows":43,"n_cols":10,"rows_kept":43,"merged":[[2,5,2,9],[11,1,11,2],[11,4,11,5],[11,7,11,8],[24,1,24,2],[24,4,24,5],[24,7,24,8],[36,1,36,2]]}
[]
[]
[{"$nulls":5},"REDONDEAR"]
[{"$nulls":3},"TRUNCAR","ENTERO","IMPAR","PAR",null,"MAS","MENOS"]
[null,"NUMERO",13.346248158,{"$f":"TRUNC(C5,2)","v":13.34},{"$f":"INT(C5)","v":13},{"$f":"ODD($C$5)","v":15},{"$f":"EVEN($C$5)","v":14},{"$f":"ROUND($C$5,2)","v":13.35},{"$f":"ROUNDUP(C5,2)","v":13.35},{"$f":"ROUNDDOWN(C5,2)","v":13.34}]
[]
[]
[null,"APLICAR LAS FORMULAS A CADA CUADRO"]
[]
[]
[]
[null,"Redondear",null,null,"Redondea.PAR",null,null,"Redondea.IMPAR"]
[null,20.54864,null,null,3.325,null,null,3.325]
[null,{"v":113.8394656,"d":"113.83947"},null,null,13.324,null,null,13.324]
[null,{"v":569.197328,"d":"569.19733"},null,null,6.2486,null,null,6.2486]
[null,{"v":2845.98664,"d":"2,845.98664"},null,null,10.6448,null,null,10.6448]
[null,{"v":14229.9332,"d":"14,229.93320"},null,null,9.654894,null,null,8.654894]
[null,{"v":71149.666,"d":"71,149.66600"},null,null,18.34841,null,null,18.34841]
[]
[]
[]
[]
[]
[]
[null,"Entero",null,null,"Redondear.MENOS 2 DECIMALES",null,null,"Redondear.MAS  2 DECIMALES"]
[null,20.54864,null,null,3.325,null,null,3.325]
[null,{"v":113.8394656,"d":"113.83947"},null,null,13.324,null,null,13.324]
[null,{"v":569.197328,"d":"569.19733"},null,null,6.2486,null,null,6.2486]
[null,{"v":2845.98664,"d":"2,845.98664"},null,null,10.6448,null,null,10.6448]
[null,{"v":14229.9332,"d":"14,229.93320"},null,null,9.654894,null,null,9.654894]
[null,{"v":71149.666,"d":"71,149.66600"},null,null,18.34841,null,null,18.34841]
[]
[]
[]
[]
[]
[null,"Truncar 2 DECIMALES"]
[null,3.325]
[null,13.324]
[null,6.2486]
[null,10.6448]
[null,9.654894]
[null,18.34841]

{"sheet":"ARRASTRAR FORMULA","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"merged":[[0,0,1,0],[2,0,2,4]]}
["EJERCICIO "]
[]
["Referencia mixta con la misma columna"]
["Datos A","Datos B","Datos C","Resultado de B+A","Resultado de C+A"]
[1,5,4]
[2,6,7]
[3,8,12]
[4,10,25]

{"sheet":"CELDAS","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[0,0,0,8],[9,0,14,0],[20,0,20,2],[21,0,21,2],[23,0,28,0],[34,0,34,2],[36,0,41,0]]}
["DISTRIBUCIÓN DE BEBIDAS"]
[]
["Una empresa de distribución de bebidas, ha encargado una hoja para calcular el pago de sus vendedores."]
["La paga de un vendedor es la suma de su sueldo base, sus comisiones por ventas y el importe de las horas extra."]
[]
[]
[]
[]
["MES","VENDEDOR","BEBIDAS","OTROS","TOTAL"]
["ENERO","David",{"v":90300,"d":"90,300.00"},{"v":134810,"d":"134,810.00"},"?"]
[null,"Daniel",{"v":112970,"d":"112,970.00"},{"v":176650,"d":"176,650.00"},"?"]
[null,"Juan",{"v":163740,"d":"163,740.00"},{"v":124700,"d":"124,700.00"},"?"]
[null,"Luis",{"v":1530550,"d":"1,530,550.00"},{"v":127690,"d":"127,690.00"},"?"]
[null,"Ricardo",{"v":1529720,"d":"1,529,720.00"},{"v":127740,"d":"127,740.00"},"?"]
[null,"Felipe",{"v":127490,"d":"127,490.00"},{"v":133670,"d":"133,670.00"},"?"]
[]
[]
[]
[]
[]
["COMISIÓN POR BEBIDAS",null,null,{"v":0.1,"d":"0.10"}]
["COMISIÓN OTROS PRODUCTOS",null,null,0.15]
["MES","VENDEDOR","COMISIÓN BEBIDAS","COMISIÓN OTROS","TOTAL"]
["ENERO","David","?","?","?"]
[null,"Daniel","?","?","?"]
[null,"Juan","?","?","?"]
[null,"Luis","?","?","?"]
[null,"Ricardo","?","?","?"]
[null,"Felipe","?","?","?"]
[]
[]
[]
[]
[]
["PRECIO HORA EXTRA",null,null,{"v":7210,"d":"7,210.00"}]
["MES","VENDEDOR","HORAS EXTRA","TOTAL HORAS EXTRA","TOTAL COMISIÓN","SUELDO","TOTAL"]
["ENERO","David",{"v":25,"d":"25.00"},"?","?",{"v":721210,"d":"721,210.00"},"?"]
[null,"Daniel",{"v":5,"d":"5.00"},"?","?",{"v":901520,"d":"901,520.00"},"?"]
[null,"Juan",{"v":10,"d":"10.00"},"?","?",{"v":570960,"d":"570,960.00"},"?"]
[null,"Luis",{"v":22,"d":"22.00"},"?","?",{"v":510860,"d":"510,860.00"},"?"]
[null,"Ricardo",{"v":60,"d":"60.00"},"?","?",{"v":1202020,"d":"1,202,020.00"},"?"]
[null,"Felipe",{"v":24,"d":"24.00"},"?","?",{"v":901520,"d":"901,520.00"},"?"]

{"sheet":"OPERACIONES","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"merged":[[0,0,1,0]]}
["EJERCICIO "]
[]
["TIPO","Unidades","Precio Unidad (€)","Total","Descuento","I.V.A.","Total a pagar","Pago adelantado","Debe"]
["Silla plegable",27,{"v":13,"d":"13.00"}]
["Armario empotrado",4,{"v":1300,"d":"1300.00"}]
["Mesa salón grande",9,{"v":680,"d":"680.00"}]
["Mesa salón pequeña",17,{"v":220,"d":"220.00"}]
["Mesita supletoria",42,{"v":95,"d":"95.00"}]
["Estantería ",8,{"v":460,"d":"460.00"}]

{"sheet":"ORDENAR","index":4,"n_rows":43,"n_cols":6,"rows_kept":43,"merged":[[1,5,2,5],[3,5,4,5]]}
["Apellido 1","Apellido 2","Nombre","Teléfono","NOMBRE UNIDO"]
["ÁLVAREZ","GONZÁLEZ","ALEJANDRA",666778899,null,"1. ORDENAR LOS DATOS POR PRIMER APELLIDO Y NOMBRE."]
["PRADOS","LOBATO","ALEJANDRA",666778833]
["CORDERO","GONZÁLEZ","ÁLVARO",666778844,null,"2. MEDIANTE LA FUNCION \"CONCATENAR\" UNIR EL NOMBRE POR 1 APELLIDO,2 APELLIDO  NOMBRE."]
["GONZÁLEZ","MÁRQUEZ","ÁLVARO",666778822]
["DÍAZ ZAPATA","ZAPATA","ANGEL",666337744]
["DOMÍNGUEZ","GÓMEZ","ANGEL",666224411]
["GIL","GIL","ANTONIO ALEJANDRO",666321321]
["CABELLO","RODRÍGUEZ","ANTONIO ALEJANDRO",666123123]
["JIMENEZ","DUARTE","CARLOS",666234234]
["JIMENEZ","AGUILERA","CARLOS",666432432]
["JIMENEZ","RODRÍGUEZ","CRISTINA",666345345]
["LAGUARTA","SUÁREZ","CRISTINA",666543543]
["LÁZARO","PRIDA","ESTEFANIA",666890890]
["LEÓN","OLALLA","ESTEFANIA",666098098]
["ZAPATERO","AZNAR","ESTEFANIA",666543543]
["LIMÓN","CEREZO","ESTEFANIA",666890890]
["LLEDÓ","IZQUIERDO","FELIPE",666098098]
["LÓPEZ","GARCÍA","FELIPE",666123456]
["LÓPEZ","PÉREZ","FELIPE",666654321]
["LUQUE","AGUILERA","FELIPE",666876543]
["LUQUE","NAZARET","FERNANDO",666456789]
["AGUILERA","ZAPATERO","FERNANDO",666778899]
["AGUILERA","PRADOS","IGNACIO",666778833]
["AZNAR","LUQUE","IGNACIO",666778844]
["CEREZO","LUQUE","IVÁN",666778822]
["DUARTE","LÓPEZ","IVÁN",666337744]
["GARCÍA","LÓPEZ","JULIAN",666224411]
["GIL","LLEDÓ","JULIAN",666321321]
["GÓMEZ","LIMÓN","JULIO",666123123]
["GONZÁLEZ","LEÓN","JULIO",666234234]
["GONZÁLEZ","LÁZARO","LAURA",666432432]
["IZQUIERDO","LAGUARTA","LAURA",666345345]
["LOBATO","JIMENEZ","MARIA DEL ROCÍO",666543543]
["MÁRQUEZ","JIMENEZ","MARIA DEL ROCÍO",666890890]
["NAZARET","JIMENEZ","MARÍA JOSÉ",666098098]
["OLALLA","GONZÁLEZ","MARÍA JOSÉ",666123456]
["PÉREZ","GIL","PEDRO",666654321]
["PRIDA","DOMÍNGUEZ","PEDRO",666234567]
["RODRÍGUEZ","DÍAZ ZAPATA","ROSARIO",666765432]
["RODRÍGUEZ","CORDERO","ROSARIO",666345678]
["SUÁREZ","CABELLO","SARA",666876543]
["ZAPATA","ÁLVAREZ","SARA",666456789]

{"sheet":"BUSCAR-V","index":5,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[0,0,0,2],[11,0,13,3]]}
["Ejemplo de uso de buscarV()",{"$nulls":3},"Codigo","Salario Bruto","Dpto","Apellido1","Apellido2","Nombre","NOMBRE COMPLETO","Años Lab.","Edades"]
[{"$nulls":4},965,{"v":200000,"d":"200,000.00"},"Contabilidad","Mora","Lopez","Minor",null,1,34]
[{"$nulls":4},965,{"v":200000,"d":"200,000.00"},"Contabilidad","Muñoz","Guillen","Emilia",null,5,15]
["Código a buscar: ",965,null,null,965,{"v":200000,"d":"200,000.00"},"Contabilidad","Castro","Guillen","Ana",null,6,54]
["NOMBRE",{"$nulls":3},257,{"v":543000,"d":"543,000.00"},"Informática","Lopez","Obando","Katia",null,1,34]
["EDAD",{"$nulls":3},123,{"v":189000,"d":"189,000.00"},"Producción","Guillen","Castro","Laura",null,0,14]
["DEPARTAMENTO",{"$nulls":3},257,{"v":543000,"d":"543,000.00"},"Informática","Obando","Jimenez","Susan",null,10,65]
["SALARIO BRUTO",{"$nulls":3},123,{"v":189000,"d":"189,000.00"},"Producción","Sanchez","Ramirez","Juan",null,4,15]
[{"$nulls":4},365,{"v":355000,"d":"355,000.00"},"Recursos Humanos","Muñoz","Castro","Pedro",null,16,54]
[{"$nulls":4},365,{"v":355000,"d":"355,000.00"},"Recursos Humanos","Mora","Lopez","Lourdes",null,15,34]
[{"$nulls":4},748,{"v":347250,"d":"347,250.00"},"Auditoría","Méndez","Rodríguez","Luisa",null,15,14]
["1. CONCATENEAR LA COLUMNA NOMBRE COMPLETO CON LAS COLUMNAS DE APELLIDO 1, APELLIDO 2 Y NOMBRE",{"$nulls":3},748,{"v":347250,"d":"347,250.00"},"Auditoría","Corrales","Jímenez","Jose",null,21,34]
[{"$nulls":4},123,{"v":189000,"d":"189,000.00"},"Producción","Mora","Ramirez","Juan",null,4,15]
[{"$nulls":4},257,{"v":543000,"d":"543,000.00"},"Informática","Mora","Hidalgo","Maria",null,12,54]
["2. APLICAR LAS FORMULA DE BUSCARV PARA ENCONTRAR LOS DATOS",{"$nulls":3},965,{"v":200000,"d":"200,000.00"},"Contabilidad","Obando","Castro","Hernan",null,2,34]
[{"$nulls":4},257,{"v":543000,"d":"543,000.00"},"Informática","Mora","Sanchez","Jaime",null,12,14]
[{"$nulls":4},123,{"v":189000,"d":"189,000.00"},"Producción","Moreira","Guillen","Rocio",null,9,65]
[{"$nulls":4},123,{"v":189000,"d":"189,000.00"},"Producción","Arias","Obando","Fermín",null,8,15]

{"sheet":"SI CONDICIONAL LETRAS","index":6,"n_rows":104,"n_cols":7,"rows_kept":104,"merged":[[0,0,1,0]]}
["DATOS DE UN HOTEL"]
[]
[]
["Clientes","Días de estancia","Tipo comida","Monto",null,"Tipo comida","Total"]
["Cliente1",6,"Comida+Cena",null,null,"Comida+Cena"]
["Cliente2",28,"Comida+Cena",null,null,"Desayuno"]
["Cliente3",24,"Comida+Cena"]
["Cliente4",14,"Desayuno"]
["Cliente5",31,"Comida+Cena"]
["Cliente6",29,"Comida+Cena"]
["Cliente7",31,"Comida+Cena"]
["Cliente8",8,"Comida+Cena"]
["Cliente9",13,"Comida+Cena"]
["Cliente10",21,"Desayuno"]
["Cliente11",13,"Desayuno"]
["Cliente12",21,"Comida+Cena"]
["Cliente13",27,"Comida+Cena"]
["Cliente14",17,"Comida+Cena"]
["Cliente15",12,"Comida+Cena"]
["Cliente16",24,"Comida+Cena"]
["Cliente17",6,"Desayuno"]
["Cliente18",2,"Comida+Cena"]
["Cliente19",2,"Desayuno"]
["Cliente20",31,"Comida+Cena"]
["Cliente21",31,"Comida+Cena"]
["Cliente22",2,"Desayuno"]
["Cliente23",12,"Comida+Cena"]
["Cliente24",3,"Desayuno"]
["Cliente25",17,"Comida+Cena"]
["Cliente26",5,"Comida+Cena"]
["Cliente27",1,"Desayuno"]
["Cliente28",8,"Comida+Cena"]
["Cliente29",20,"Comida+Cena"]
["Cliente30",10,"Desayuno"]
["Cliente31",8,"Comida+Cena"]
["Cliente32",1,"Desayuno"]
["Cliente33",7,"Comida+Cena"]
["Cliente34",15,"Comida+Cena"]
["Cliente35",21,"Comida+Cena"]
["Cliente36",11,"Comida+Cena"]
["Cliente37",26,"Comida+Cena"]
["Cliente38",20,"Comida+Cena"]
["Cliente39",13,"Comida+Cena"]
["Cliente40",21,"Desayuno"]
["Cliente41",9,"Desayuno"]
["Cliente42",26,"Desayuno"]
["Cliente43",16,"Comida+Cena"]
["Cliente44",19,"Comida+Cena"]
["Cliente45",14,"Comida+Cena"]
["Cliente46",30,"Desayuno"]
["Cliente47",4,"Desayuno"]
["Cliente48",12,"Comida+Cena"]
["Cliente49",6,"Desayuno"]
["Cliente50",24,"Desayuno"]
["Cliente51",8,"Desayuno"]
["Cliente52",7,"Comida+Cena"]
["Cliente53",17,"Comida+Cena"]
["Cliente54",20,"Comida+Cena"]
["Cliente55",6,"Desayuno"]
["Cliente56",11,"Desayuno"]
["Cliente57",9,"Desayuno"]
["Cliente58",30,"Desayuno"]
["Cliente59",11,"Comida+Cena"]
["Cliente60",25,"Desayuno"]
["Cliente61",17,"Comida+Cena"]
["Cliente62",22,"Desayuno"]
["Cliente63",1,"Comida+Cena"]
["Cliente64",13,"Desayuno"]
["Cliente65",22,"Comida+Cena"]
["Cliente66",7,"Comida+Cena"]
["Cliente67",23,"Comida+Cena"]
["Cliente68",27,"Desayuno"]
["Cliente69",19,"Comida+Cena"]
["Cliente70",23,"Comida+Cena"]
["Cliente71",19,"Desayuno"]
["Cliente72",6,"Comida+Cena"]
["Cliente73",6,"Desayuno"]
["Cliente74",18,"Desayuno"]
["Cliente75",23,"Comida+Cena"]
["Cliente76",14,"Comida+Cena"]
["Cliente77",20,"Comida+Cena"]
["Cliente78",5,"Desayuno"]
["Cliente79",26,"Comida+Cena"]
["Cliente80",18,"Comida+Cena"]
["Cliente81",24,"Comida+Cena"]
["Cliente82",27,"Desayuno"]
["Cliente83",28,"Comida+Cena"]
["Cliente84",27,"Comida+Cena"]
["Cliente85",27,"Comida+Cena"]
["Cliente86",5,"Comida+Cena"]
["Cliente87",3,"Desayuno"]
["Cliente88",27,"Desayuno"]
["Cliente89",10,"Comida+Cena"]
["Cliente90",25,"Desayuno"]
["Cliente91",19,"Desayuno"]
["Cliente92",16,"Comida+Cena"]
["Cliente93",27,"Comida+Cena"]
["Cliente94",15,"Comida+Cena"]
["Cliente95",6,"Desayuno"]
["Cliente96",21,"Desayuno"]
["Cliente97",9,"Desayuno"]
["Cliente98",21,"Comida+Cena"]
["Cliente99",22,"Comida+Cena"]
["Cliente100",8,"Comida+Cena"]

{"sheet":"SI CONDICIONAL NUMEROS","index":7,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[0,0,1,0],[19,1,20,1]]}
["EJERCICIO"]
[]
["NOMBRE","Práctica 1","Práctica 2","Exámen Final","Nota Final","Calificación"]
["Antonio",5,3,5]
["María",2,6,4]
["Paula",6,7,3]
["Álvaro",9,4,7]
["M. Carmen",1,3,2]
["Rocío",2,8,9]
["Aurora",4,3,5]
["Margarita",8,6,3]
["Manolo",10,5,10]
["Yesica",6,9,6]
[]
[]
[]
[]
[]
[]
[null,"CALIFICACIONES"]
[]
[null,"ALUMNOS","PRIMER EXAMEN","VER COMENTARIO","SEGUNDO EXAMEN","VER COMENTARIO"]
[null,"MIGUEL",4,null,2]
[null,"DIGNA",5,null,4]
[null,"ENRIQUE",6,null,6]
[null,"ÁNGELA",7,null,1]
[null,"NIEVES",3.6,null,4]
[null,"ROCÍO",2,null,8]
[null,"LAURA",9.5,null,7]
[null,"Mª LUZ",10,null,2]
[null,"ALEJANDRO",2,null,8]
[null,"IRENE",4,null,2]
[null,"PALOMA",5,null,5]
[null,"SERGIO",7.8,null,6]
[null,"Mª CARMEN",8,null,7]
[null,"VIRGINIA",9,null,3.6]
[null,"BORJA",2,null,2]
[null,"ELENA",4,null,9.5]
[null,"FÁTIMA",5,null,10]
[null,"FCO. JAVIER",7.8,null,2]
[null,"PILAR",7,null,4]
[null,"EMILIA",3.6,null,5]
[null,"ALEJANDRO",2,null,10]
[null,"ADAHIR",9.5,null,2]
[null,"EVA Mª",10,null,4]
[null,"JUAN LUIS",2,null,5]
[null,"SANTIAGO",4,null,7.8]
[null,"FCO. JOSÉ",6,null,9]
[null,"JAIME",7,null,2]
[null,"SAMUEL",3.6,null,4]
[null,"MARCOS",2,null,5]

{"sheet":"PORCENTAJES","index":8,"n_rows":7,"n_cols":10,"rows_kept":7,"merged":[[0,0,1,0],[2,0,2,9],[6,0,6,1]]}
["EJERCICIO "]
[]
["ELECCIONES EN UN PUEBLO"]
["Total electores","votantes","absten-ciones","PAC","PLN","PUSC","LDA","SAP","PIE","votos blanco"]
[34515,28758,5757,9814,5413,3210,2180,7214,312,615]
["PORCENTAJE SOBRE ELECTORES"]
["PORCENTAJE SOBRE VOTANTES"]

{"sheet":"PROMEDIO","index":9,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[0,0,1,0],[2,0,2,5]]}
["EJERCICIO "]
[]
["Tabla de temperaturas en Andalucía en enero"]
[null,"DIA1","DIA2","DIA3","DIA4","medias"]
["ALAJUELA",32,21,25,29]
["SAN JOSE",27,32,24,33]
["HEREDIA",30,21,33,35]
["CARTAGO",31,29,34,26]
["LIMON",33,33,21,27]
["GUANACASTE",20,35,35,27]
["PUNTARENAS",25,29,22,30]

{"sheet":"SUMAY GRAFICO","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[0,0,1,0],[2,0,2,2]]}
["EJERCICIO "]
[]
["Producción de vino y aceite"]
["PAISES","vino","aceite"]
["España",7151,10415]
["Portugal",5401,6014]
["Francia",10540,5400]
["Italia",6216,8512]
["Grecia",1224,7030]
["Totales"]

{"sheet":"GRÁFICOS","index":11,"n_rows":7,"n_cols":3,"rows_kept":7}
["ESPECIES","Número de individuos","Porcentajes"]
["Especie 1",1372.94]
["Especie 2",{"v":416.5,"d":"416.50"}]
["Especie 3",{"v":197.4,"d":"197.40"}]
["Especie 4",51.71]
["Especie 5",{"v":36.5,"d":"36.50"}]
["TOTAL"]

{"sheet":"REFERENCIAS","index":12,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,0,1,0]]}
["EJERCICIO 5"]
[]
[null,"Alumnos","Niños","Niñas","Porcentaje Niños","Porcentaje Niñas"]
["Clase A",400,231,169]
["Clase B",500,250,250]

{"sheet":"SERIES","index":13,"n_rows":5,"n_cols":6,"rows_kept":5,"merged":[[0,0,0,4]]}
["Introducción de datos en una celda (llenado automático)"]
[1,"lunes","2003-01-01"]
[{"$nulls":5},"1. En la 1a. Columna, introducir números consecutivos"]
[{"$nulls":5},"2. En la 2a. Columna, introducir dias de la semana"]
[{"$nulls":5},"3. En la 3a. Columna, introducir fechas consecutivas"]

{"sheet":"QUITAR DUPLICADOS","index":14,"n_rows":76,"n_cols":9,"rows_kept":76}
[]
[]
[]
[null,"Nombre","Apellido1","Apellido2","Zona Postal","Producto","Negocio"," Unid. Vendidas","Años"]
[null,"Rosa","Massino","Arce",401,"Mayonesa","Más por Menos",2,34]
[null,"Joaquín","Ramos","Garro",301,"Atún","Pali",89,15]
[null,"Jairo ","Fallas ","Rojas",101,"Mayonesa","Más por Menos",20,54]
[null,"Roberto","Cordero","Bogarin ",401,"Salsa ","Price Smart ",10,34]
[null,"Esteban ","Campos","Fallas ",301,"Escobas","Híper Mas",20,14]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30,65]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56,99]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45,51]
[null,"Heilin","Loria","Braña",501,"Atún","Híper Mas",45,15]
[null,"Carlos","Hernández ","Cruz",701,"Maní","Pali",69,67]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50,45]
[null,"Ernesto","Jiménez","Ramos",601,"Frijoles","Mega súper ",50,15]
[null,"Pedro","Ortiz ","Fallas ",101,"Aceite ","Price Smart ",43,23]
[null,"Ramiro ","Flores","Cordero",401,"Manteca","Híper Mas",60,34]
[null,"Gerardo ","Monge","Campos",301,"Maní","Mas por Menos",55,15]
[null,"Gilberto","Alvarado","Rivera ",501,"Arroz","Coopecompro",89,62]
[null,"Eliecer","Campos","Moreno",701,"Arroz","Mega súper ",2,24]
[null,"Efraín ","Ortiz ","Bonilla ",201,"Escobas","Price Smart ",89,15]
[null,"Zelmira ","Zúñiga","Loria",601,"Escobas","Híper Mas",5,25]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50,45]
[null,"Johan ","Quesada","Ureña",401,"Atún","Mega súper ",2,14]
[null,"William ","Abarca","Jiménez",201,"Maní","Mega súper ",44,15]
[null,"Cristina ","Porras","Ortiz ",601,"Arroz","Mega súper ",96,16]
[null,"Carlos","Picado","Moya",501,"Frijoles","Mega súper ",56,35]
[null,"Miguel","Ortiz ","Salinas ",701,"Aceite ","Price Smart ",45,31]
[null,"Antonio ","Sánchez","Chavarría",201,"Manteca","Híper Mas",45,32]
[null,"Sebastián","Dengo ","Centeno ",201,"Maní","Pali",69,15]
[null,"Roy ","Arias ","Cubero",101,"Arroz","Mega súper ",50,43]
[null,"Vanessa","Pérez","Arce",401,"Arroz","Mega súper ",50,27]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30,65]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56,99]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45,51]
[null,"Roció","Salinas ","Mesen ",101,"Mayonesa","Mega súper ",69,54]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50,45]
[null,"Sonia ","Centeno ","Campos",101,"Atún","Price Smart ",50,42]
[null,"Rosa","Cubero","Pérez",201,"Maní","Mega súper ",60,32]
[null,"Marta","Arce","Zúñiga",301,"Arroz","Price Smart ",55,15]
[null,"Aura","Garro","Nájera",501,"Escobas","Coopecompro",89,23]
[null,"Ruth ","Arias","Quesada",501,"Escobas","Mega súper ",2,55]
[null,"Roberto","Núñez","Abarca",701,"Mayonesa","Price Smart ",89,10]
[null,"Rodolfo","Mesen ","Porras",401,"Atún","Más por Menos",5,19]
[null,"Jefferson","Jiménez","Picado",501,"Maní","Coopecompro",6,15]
[null,"Miguel","Castro","García",501,"Arroz","Coopecompro",2,15]
[null,"Álvaro","Morales","Sánchez",201,"Arroz","Mega súper ",44,76]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30,65]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56,99]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45,51]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50,45]
[null,"Nancy ","Araya","Chavarría",101,"Mayonesa","Mega súper ",69,32]
[null,"Katia","Braña","Centeno ",301,"Atún","Price Smart ",55,15]
[null,"Hernán","Cruz","Cubero",101,"Mayonesa","Híper Mas",89,14]
[null,"Mainor","Lopez","Mora",601,"Maní","Híper Mas",56,28]
[null,"Emilia","Guillen","Muñoz",101,"Arroz","Más por Menos",45,15]
[null,"Ana","Guillen","Castro",401,"Frijoles","Mega súper ",45,23]
[null,"Katia","Obando","Lopez",201,"Aceite ","Mega súper ",69,54]
[null,"Laura","Castro","Guillen",601,"Manteca","Price Smart ",50,37]
[null,"Susan","Jimenez","Obando",501,"Maní","Mega súper ",50,42]
[null,"Juan","Ramirez","Sanchez",701,"Arroz","Price Smart ",60,32]
[null,"Pedro","Castro","Muñoz",201,"Arroz","Coopecompro",55,15]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30,65]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56,99]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45,51]
[null,"Juan","Ramirez","Mora",201,"Atún","Coopecompro",5,19]
[null,"Maria","Hidalgo","Mora",701,"Maní","Coopecompro",6,15]
[null,"Hernan","Castro","Obando",401,"Arroz","Mega súper ",2,15]
[null,"Jaime","Sanchez","Mora",101,"Frijoles","Pali",44,76]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50,45]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30,65]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56,99]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45,51]
[null,"Sonia","Obando","Lopez",501,"Arroz","Price Smart ",69,15]
[null,"Fernan","Arias","Mora",501,"Escobas","Híper Mas",55,23]

{"sheet":"SUBTOTAL","index":15,"n_rows":158,"n_cols":8,"rows_kept":158,"merged":[[1,1,1,6],[83,1,83,6]]}
[]
[null,"1. Realizar un subtotal por zona postal y negocio contando las unidades vendidas"]
[]
[]
[]
[]
[]
[]
[null,"Nombre","Apellido1","Apellido2","Zona Postal","Producto","Negocio"," Unid. Vendidas"]
[null,"William ","Abarca","Jiménez",201,"Maní","Mega súper ",44]
[null,"Gilberto","Alvarado","Rivera ",501,"Arroz","Coopecompro",89]
[null,"Nancy ","Araya","Chavarría",101,"Mayonesa","Mega súper ",69]
[null,"Marta","Arce","Zúñiga",301,"Arroz","Price Smart ",55]
[null,"Lucrecia","Arias","Rodríguez",201,"Maní","Coopecompro",45]
[null,"Fernan","Arias","Mora",501,"Escobas","Híper Mas",55]
[null,"Ana","Arias","Jímenez",301,"Arroz","Mega súper ",45]
[null,"Ruth ","Arias","Quesada",501,"Escobas","Mega súper ",2]
[null,"Roy ","Arias ","Cubero",101,"Arroz","Mega súper ",50]
[null,"Ángel","Arrieta","Moya",701,"Atún","Más por Menos",45]
[null,"Leda","Bogarin ","Dengo ",101,"Escobas","Pali",96]
[null,"Katia","Braña","Centeno ",301,"Atún","Price Smart ",55]
[null,"Esteban ","Campos","Fallas ",301,"Escobas","Híper Mas",20]
[null,"Eliecer","Campos","Moreno",701,"Arroz","Mega súper ",2]
[null,"Pedro","Castro","Muñoz",201,"Arroz","Coopecompro",55]
[null,"Miguel","Castro","García",501,"Arroz","Coopecompro",2]
[null,"Hernan","Castro","Obando",401,"Arroz","Mega súper ",2]
[null,"Laura","Castro","Guillen",601,"Manteca","Price Smart ",50]
[null,"Sonia ","Centeno ","Campos",101,"Atún","Price Smart ",50]
[null,"Roberto","Cordero","Bogarin ",401,"Salsa ","Price Smart ",10]
[null,"Hernán","Cruz","Cubero",101,"Mayonesa","Híper Mas",89]
[null,"Rosa","Cubero","Pérez",201,"Maní","Mega súper ",60]
[null,"Sebastián","Dengo ","Centeno ",201,"Maní","Pali",69]
[null,"Jairo ","Fallas ","Rojas",101,"Mayonesa","Más por Menos",20]
[null,"Iván","Fallas ","Arias ",301,"Escobas","Pali",56]
[null,"Ramiro ","Flores","Cordero",401,"Manteca","Híper Mas",60]
[null,"Aura","Garro","Nájera",501,"Escobas","Coopecompro",89]
[null,"Emilia","Guillen","Muñoz",101,"Arroz","Más por Menos",45]
[null,"Ana","Guillen","Castro",401,"Frijoles","Mega súper ",45]
[null,"Carlos","Hernández ","Cruz",701,"Maní","Pali",69]
[null,"Maria","Hidalgo","Mora",701,"Maní","Coopecompro",6]
[null,"Susan","Jimenez","Obando",501,"Maní","Mega súper ",50]
[null,"Jefferson","Jiménez","Picado",501,"Maní","Coopecompro",6]
[null,"Ernesto","Jiménez","Ramos",601,"Frijoles","Mega súper ",50]
[null,"Jose","Jímenez","Corrales",401,"Mayonesa","Más por Menos",89]
[null,"Mainor","Lopez","Mora",601,"Maní","Híper Mas",56]
[null,"Lourdes","Lopez","Mora",201,"Escobas","Mega súper ",89]
[null,"Heilin","Loria","Braña",501,"Atún","Híper Mas",45]
[null,"Rosa","Massino","Arce",401,"Mayonesa","Más por Menos",2]
[null,"Rodolfo","Mesen ","Porras",401,"Atún","Más por Menos",5]
[null,"Gerardo ","Monge","Campos",301,"Maní","Mas por Menos",55]
[null,"Álvaro","Morales","Sánchez",201,"Arroz","Mega súper ",44]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56]
[null,"Flor","Moya","Núñez",401,"Atún","Más por Menos",45]
[null,"Roberto","Núñez","Abarca",701,"Mayonesa","Price Smart ",89]
[null,"Fermín","Obando","Arias",101,"Manteca","Más por Menos",56]
[null,"Katia","Obando","Lopez",201,"Aceite ","Mega súper ",69]
[null,"Sonia","Obando","Lopez",501,"Arroz","Price Smart ",69]
[null,"Pedro","Ortiz ","Fallas ",101,"Aceite ","Price Smart ",43]
[null,"Miguel","Ortiz ","Salinas ",701,"Aceite ","Price Smart ",45]
[null,"Efraín ","Ortiz ","Bonilla ",201,"Escobas","Price Smart ",89]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45]
[null,"Vanessa","Pérez","Arce",401,"Arroz","Mega súper ",50]
[null,"Carlos","Picado","Moya",501,"Frijoles","Mega súper ",56]
[null,"Cristina ","Porras","Ortiz ",601,"Arroz","Mega súper ",96]
[null,"Johan ","Quesada","Ureña",401,"Atún","Mega súper ",2]
[null,"Juan","Ramirez","Mora",201,"Atún","Coopecompro",5]
[null,"Juan","Ramirez","Sanchez",701,"Arroz","Price Smart ",60]
[null,"Joaquín","Ramos","Garro",301,"Atún","Pali",89]
[null,"Catalina","Rivera ","Azofeifa",701,"Escobas","Híper Mas",45]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30]
[null,"Luisa","Rodríguez","Méndez",101,"Escobas","Price Smart ",2]
[null,"Viviana ","Saborío","Garro",201,"Escobas","Price Smart ",56]
[null,"Roció","Salinas ","Mesen ",101,"Mayonesa","Mega súper ",69]
[null,"Jaime","Sanchez","Mora",101,"Frijoles","Pali",44]
[null,"Antonio ","Sánchez","Chavarría",201,"Manteca","Híper Mas",45]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Zelmira ","Zúñiga","Loria",601,"Escobas","Híper Mas",5]
[]
[]
[null,"2. Realizar un subtotal por negocio y producto contando las unidades vendidas"]
[]
[null,"Nombre","Apellido1","Apellido2","Zona Postal","Producto","Negocio"," Unid. Vendidas"]
[null,"William ","Abarca","Jiménez",201,"Maní","Mega súper ",44]
[null,"Gilberto","Alvarado","Rivera ",501,"Arroz","Coopecompro",89]
[null,"Nancy ","Araya","Chavarría",101,"Mayonesa","Mega súper ",69]
[null,"Marta","Arce","Zúñiga",301,"Arroz","Price Smart ",55]
[null,"Lucrecia","Arias","Rodríguez",201,"Maní","Coopecompro",45]
[null,"Fernan","Arias","Mora",501,"Escobas","Híper Mas",55]
[null,"Ana","Arias","Jímenez",301,"Arroz","Mega súper ",45]
[null,"Ruth ","Arias","Quesada",501,"Escobas","Mega súper ",2]
[null,"Roy ","Arias ","Cubero",101,"Arroz","Mega súper ",50]
[null,"Ángel","Arrieta","Moya",701,"Atún","Más por Menos",45]
[null,"Leda","Bogarin ","Dengo ",101,"Escobas","Pali",96]
[null,"Katia","Braña","Centeno ",301,"Atún","Price Smart ",55]
[null,"Esteban ","Campos","Fallas ",301,"Escobas","Híper Mas",20]
[null,"Eliecer","Campos","Moreno",701,"Arroz","Mega súper ",2]
[null,"Pedro","Castro","Muñoz",201,"Arroz","Coopecompro",55]
[null,"Miguel","Castro","García",501,"Arroz","Coopecompro",2]
[null,"Hernan","Castro","Obando",401,"Arroz","Mega súper ",2]
[null,"Laura","Castro","Guillen",601,"Manteca","Price Smart ",50]
[null,"Sonia ","Centeno ","Campos",101,"Atún","Price Smart ",50]
[null,"Roberto","Cordero","Bogarin ",401,"Salsa ","Price Smart ",10]
[null,"Hernán","Cruz","Cubero",101,"Mayonesa","Híper Mas",89]
[null,"Rosa","Cubero","Pérez",201,"Maní","Mega súper ",60]
[null,"Sebastián","Dengo ","Centeno ",201,"Maní","Pali",69]
[null,"Jairo ","Fallas ","Rojas",101,"Mayonesa","Más por Menos",20]
[null,"Iván","Fallas ","Arias ",301,"Escobas","Pali",56]
[null,"Ramiro ","Flores","Cordero",401,"Manteca","Híper Mas",60]
[null,"Aura","Garro","Nájera",501,"Escobas","Coopecompro",89]
[null,"Emilia","Guillen","Muñoz",101,"Arroz","Más por Menos",45]
[null,"Ana","Guillen","Castro",401,"Frijoles","Mega súper ",45]
[null,"Carlos","Hernández ","Cruz",701,"Maní","Pali",69]
[null,"Maria","Hidalgo","Mora",701,"Maní","Coopecompro",6]
[null,"Susan","Jimenez","Obando",501,"Maní","Mega súper ",50]
[null,"Jefferson","Jiménez","Picado",501,"Maní","Coopecompro",6]
[null,"Ernesto","Jiménez","Ramos",601,"Frijoles","Mega súper ",50]
[null,"Jose","Jímenez","Corrales",401,"Mayonesa","Más por Menos",89]
[null,"Mainor","Lopez","Mora",601,"Maní","Híper Mas",56]
[null,"Lourdes","Lopez","Mora",201,"Escobas","Mega súper ",89]
[null,"Heilin","Loria","Braña",501,"Atún","Híper Mas",45]
[null,"Rosa","Massino","Arce",401,"Mayonesa","Más por Menos",2]
[null,"Rodolfo","Mesen ","Porras",401,"Atún","Más por Menos",5]
[null,"Gerardo ","Monge","Campos",301,"Maní","Mas por Menos",55]
[null,"Álvaro","Morales","Sánchez",201,"Arroz","Mega súper ",44]
[null,"Virginia","Moreno","Zumbado",201,"Mayonesa","Mega súper ",56]
[null,"Flor","Moya","Núñez",401,"Atún","Más por Menos",45]
[null,"Roberto","Núñez","Abarca",701,"Mayonesa","Price Smart ",89]
[null,"Fermín","Obando","Arias",101,"Manteca","Más por Menos",56]
[null,"Katia","Obando","Lopez",201,"Aceite ","Mega súper ",69]
[null,"Sonia","Obando","Lopez",501,"Arroz","Price Smart ",69]
[null,"Pedro","Ortiz ","Fallas ",101,"Aceite ","Price Smart ",43]
[null,"Miguel","Ortiz ","Salinas ",701,"Aceite ","Price Smart ",45]
[null,"Efraín ","Ortiz ","Bonilla ",201,"Escobas","Price Smart ",89]
[null,"Teresa ","Ortiz ","Araya",601,"Mayonesa","Price Smart ",45]
[null,"Vanessa","Pérez","Arce",401,"Arroz","Mega súper ",50]
[null,"Carlos","Picado","Moya",501,"Frijoles","Mega súper ",56]
[null,"Cristina ","Porras","Ortiz ",601,"Arroz","Mega súper ",96]
[null,"Johan ","Quesada","Ureña",401,"Atún","Mega súper ",2]
[null,"Juan","Ramirez","Mora",201,"Atún","Coopecompro",5]
[null,"Juan","Ramirez","Sanchez",701,"Arroz","Price Smart ",60]
[null,"Joaquín","Ramos","Garro",301,"Atún","Pali",89]
[null,"Catalina","Rivera ","Azofeifa",701,"Escobas","Híper Mas",45]
[null,"Laura","Rivera ","Arrieta",701,"Atún","Pali",30]
[null,"Luisa","Rodríguez","Méndez",101,"Escobas","Price Smart ",2]
[null,"Viviana ","Saborío","Garro",201,"Escobas","Price Smart ",56]
[null,"Roció","Salinas ","Mesen ",101,"Mayonesa","Mega súper ",69]
[null,"Jaime","Sanchez","Mora",101,"Frijoles","Pali",44]
[null,"Antonio ","Sánchez","Chavarría",201,"Manteca","Híper Mas",45]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Fabián ","Ureña","Massino",201,"Arroz","Mega súper ",50]
[null,"Zelmira ","Zúñiga","Loria",601,"Escobas","Híper Mas",5]

{"sheet":"TABLA DINAMICA 1","index":16,"n_rows":77,"n_cols":9,"rows_kept":77,"merged":[[1,1,1,6],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,6],[7,1,7,6],[8,0,8,8]]}
[]
[null,"Construir varias mini tablas dinamica que le permita:"]
[null,"1. Mostrar el salario bruto mínimo de cada sucursal."]
[null,"2. Visualizar el salario bruto  maximo de cada sucursal."]
[null,"3. Visualizar el salario bruto total de cada sucursal."]
[null,"4. Mostrar los nombres de la personas con 5 años laborados"]
[null,"5. Mostrar los nombres de la personas que laboran en del Dpto de contabilidad"]
[null,"6. Mostrar los apellidos 2 de la personas que tienes el codigo  965"]
["Funcionarios de la Cia Baxter"]
["Sucursal","Dpto","Apellido1","Apellido2","Nombre","Codigo","Años Lab.","Salario Bruto","Edades"]
[401,"Contabilidad","Mora","Lopez","Minor",965,1,{"v":200000,"d":"₡200,000.00"},34]
[301,"Contabilidad","Muñoz","Guillen","Emilia",965,5,{"v":200000,"d":"₡200,000.00"},15]
[101,"Contabilidad","Castro","Guillen","Ana",965,6,{"v":200000,"d":"₡200,000.00"},54]
[401,"Informática","Lopez","Obando","Katia",257,1,{"v":543000,"d":"₡543,000.00"},34]
[301,"Producción","Guillen","Castro","Laura",123,0,{"v":189000,"d":"₡189,000.00"},14]
[701,"Informática","Obando","Jimenez","Susan",257,10,{"v":543000,"d":"₡543,000.00"},65]
[201,"Producción","Sanchez","Ramirez","Juan",123,4,{"v":189000,"d":"₡189,000.00"},15]
[601,"Recursos Humanos","Muñoz","Castro","Pedro",365,16,{"v":355000,"d":"₡355,000.00"},54]
[501,"Recursos Humanos","Mora","Lopez","Lourdes",365,15,{"v":355000,"d":"₡355,000.00"},34]
[701,"Auditoría","Méndez","Rodríguez","Luisa",748,15,{"v":347250,"d":"₡347,250.00"},14]
[201,"Auditoría","Corrales","Jímenez","Jose",748,21,{"v":347250,"d":"₡347,250.00"},34]
[601,"Producción","Mora","Ramirez","Juan",123,4,{"v":189000,"d":"₡189,000.00"},15]
[101,"Informática","Mora","Hidalgo","Maria",257,12,{"v":543000,"d":"₡543,000.00"},54]
[401,"Contabilidad","Obando","Castro","Hernan",965,2,{"v":200000,"d":"₡200,000.00"},34]
[301,"Informática","Mora","Sanchez","Jaime",257,12,{"v":543000,"d":"₡543,000.00"},14]
[501,"Producción","Moreira","Guillen","Rocio",123,9,{"v":189000,"d":"₡189,000.00"},65]
[701,"Producción","Arias","Obando","Fermín",123,8,{"v":189000,"d":"₡189,000.00"},15]
[201,"Recursos Humanos","Rodríguez","Arias","Lucrecia",365,15,{"v":355000,"d":"₡355,000.00"},54]
[601,"Finanzas","Jímenez","Arias","Ana",846,3,{"v":377000,"d":"₡377,000.00"},34]
[101,"Finanzas","Lopez","Obando","Sonia",846,26,{"v":377000,"d":"₡377,000.00"},14]
[401,"Informática","Mora","Arias","Fernan",257,3,{"v":543000,"d":"₡543,000.00"},34]
[201,"Contabilidad","Rosa","Massino","Arce",965,1,{"v":200000,"d":"₡200,000.00"},15]
[601,"Contabilidad","Joaquín","Ramos","Garro",965,5,{"v":200000,"d":"₡200,000.00"},54]
[501,"Contabilidad","Jairo ","Fallas ","Rojas",965,6,{"v":200000,"d":"₡200,000.00"},34]
[701,"Informática","Roberto","Cordero","Bogarin ",257,1,{"v":543000,"d":"₡543,000.00"},14]
[201,"Producción","Esteban ","Campos","Fallas ",123,0,{"v":189000,"d":"₡189,000.00"},65]
[201,"Informática","Laura","Rivera ","Arrieta",257,10,{"v":543000,"d":"₡543,000.00"},15]
[101,"Producción","Virginia","Moreno","Zumbado",123,4,{"v":189000,"d":"₡189,000.00"},54]
[401,"Recursos Humanos","Teresa ","Ortiz ","Araya",365,16,{"v":355000,"d":"₡355,000.00"},34]
[201,"Recursos Humanos","Heilin","Loria","Braña",365,15,{"v":355000,"d":"₡355,000.00"},14]
[701,"Auditoría","Carlos","Hernández ","Cruz",748,15,{"v":347250,"d":"₡347,250.00"},34]
[401,"Auditoría","Fabián ","Ureña","Massino",748,21,{"v":347250,"d":"₡347,250.00"},15]
[101,"Producción","Ernesto","Jiménez","Ramos",123,4,{"v":189000,"d":"₡189,000.00"},54]
[101,"Informática","Pedro","Ortiz ","Fallas ",257,12,{"v":543000,"d":"₡543,000.00"},34]
[101,"Contabilidad","Ramiro ","Flores","Cordero",965,2,{"v":200000,"d":"₡200,000.00"},14]
[201,"Informática","Gerardo ","Monge","Campos",257,12,{"v":543000,"d":"₡543,000.00"},65]
[301,"Producción","Gilberto","Alvarado","Rivera ",123,9,{"v":189000,"d":"₡189,000.00"},15]
[501,"Producción","Eliecer","Campos","Moreno",123,8,{"v":189000,"d":"₡189,000.00"},54]
[501,"Recursos Humanos","Efraín ","Ortiz ","Bonilla ",365,15,{"v":355000,"d":"₡355,000.00"},34]
[701,"Finanzas","Zelmira ","Zúñiga","Loria",846,3,{"v":377000,"d":"₡377,000.00"},14]
[401,"Finanzas","Xinia ","Nájera","Hernández ",846,26,{"v":377000,"d":"₡377,000.00"},34]
[501,"Informática","Johan ","Quesada","Ureña",257,3,{"v":543000,"d":"₡543,000.00"},15]
[501,"Contabilidad","William ","Abarca","Jiménez",965,1,{"v":200000,"d":"₡200,000.00"},54]
[201,"Contabilidad","Cristina ","Porras","Ortiz ",965,5,{"v":200000,"d":"₡200,000.00"},34]
[101,"Contabilidad","Carlos","Picado","Moya",965,6,{"v":200000,"d":"₡200,000.00"},14]
[301,"Informática","Miguel","Ortiz ","Salinas ",257,1,{"v":543000,"d":"₡543,000.00"},65]
[701,"Producción","Antonio ","Sánchez","Chavarría",123,0,{"v":189000,"d":"₡189,000.00"},15]
[501,"Informática","Sebastián","Dengo ","Centeno ",257,10,{"v":543000,"d":"₡543,000.00"},54]
[101,"Producción","Roy ","Arias ","Cubero",123,4,{"v":189000,"d":"₡189,000.00"},34]
[301,"Recursos Humanos","Vanessa","Pérez","Arce",365,16,{"v":355000,"d":"₡355,000.00"},14]
[101,"Recursos Humanos","Viviana ","Saborío","Garro",365,15,{"v":355000,"d":"₡355,000.00"},34]
[401,"Auditoría","Catalina","Rivera ","Azofeifa",748,15,{"v":347250,"d":"₡347,250.00"},15]
[301,"Auditoría","Flor","Moya","Núñez",748,21,{"v":347250,"d":"₡347,250.00"},54]
[101,"Producción","Roció","Salinas ","Mesen ",123,4,{"v":189000,"d":"₡189,000.00"},34]
[401,"Informática","Valentín","Chavarría","Jiménez",257,12,{"v":543000,"d":"₡543,000.00"},14]
[301,"Contabilidad","Sonia ","Centeno ","Campos",965,2,{"v":200000,"d":"₡200,000.00"},65]
[701,"Informática","Rosa","Cubero","Pérez",257,12,{"v":543000,"d":"₡543,000.00"},15]
[201,"Producción","Marta","Arce","Zúñiga",123,9,{"v":189000,"d":"₡189,000.00"},54]
[601,"Producción","Aura","Garro","Nájera",123,8,{"v":189000,"d":"₡189,000.00"},34]
[501,"Recursos Humanos","Ruth ","Arias","Quesada",365,15,{"v":355000,"d":"₡355,000.00"},14]
[701,"Finanzas","Roberto","Núñez","Abarca",846,3,{"v":377000,"d":"₡377,000.00"},34]
[201,"Finanzas","Rodolfo","Mesen ","Porras",846,26,{"v":377000,"d":"₡377,000.00"},15]
[601,"Informática","Jefferson","Jiménez","Picado",257,3,{"v":543000,"d":"₡543,000.00"},54]
[101,"Contabilidad","Miguel","Castro","García",965,21,{"v":200000,"d":"₡200,000.00"},34]
[401,"Contabilidad","Álvaro","Morales","Sánchez",965,4,{"v":200000,"d":"₡200,000.00"},14]
[301,"Contabilidad","Leda","Bogarin ","Dengo ",965,12,{"v":200000,"d":"₡200,000.00"},65]
[501,"Informática","Iván","Fallas ","Arias ",257,2,{"v":543000,"d":"₡543,000.00"},15]

{"sheet":"TABLA DINAMICA 2","index":17,"n_rows":32,"n_cols":9,"rows_kept":32,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,5]]}
["Construya las tablas dinamicas que se le piden a continuacion"]
["1.Visualizar los nombre de los empeados y los Años laborados."]
["2. Visualizar los montos totales de Salario Bruto de cada sucursal."]
["3. Visualizar el monto maximo de cada salario bruto de cada sucursal."]
["4. Mostrar el promedio del salario bruto de las sucursales."]
["5. Mostrar el monto mínimo de cada sucursal."]
[]
[]
[]
[]
[null,"Sucursal","Departamento","Nombre","Apellido 1","Apellido 2","Cedula","Años Lab.","Salario Bruto"]
[null,"Heredia","Contabilidad","Mainor","Lopez","Mora","1-258-965",1,{"v":200000,"d":"₡200,000.00"}]
[null,"Heredia","Contabilidad","Emilia","Guillen","Muñoz","1-365-874",5,{"v":105000,"d":"₡105,000.00"}]
[null,"San Jose","Contabilidad","Ana","Guillen","Castro","2-587-987",6,{"v":97000,"d":"₡97,000.00"}]
[null,"Alajuela","Informática","Katia","Obando","Lopez","3-698-257",1,{"v":43000,"d":"₡43,000.00"}]
[null,"Cartago","Producción","Laura","Castro","Guillen","2-412-897",0,{"v":89000,"d":"₡89,000.00"}]
[null,"San Jose","Informática","Susan","Jimenez","Obando","6-587-987",10,{"v":76500,"d":"₡76,500.00"}]
[null,"Alajuela","Producción","Juan","Ramirez","Sanchez","3-654-123",4,{"v":355000,"d":"₡355,000.00"}]
[null,"Cartago","Recursos Humanos","Pedro","Castro","Muñoz","2-879-365",16,{"v":50000,"d":"₡50,000.00"}]
[null,"San Jose","Recursos Humanos","Lourdes","Lopez","Mora","6-587-954",15,{"v":92700,"d":"₡92,700.00"}]
[null,"Alajuela","Auditoría","Luisa","Rodríguez","Méndez","2-869-748",15,{"v":222000,"d":"₡222,000.00"}]
[null,"Cartago","Auditoría","Jose","Jímenez","Corrales","1-258-998",21,{"v":347250,"d":"₡347,250.00"}]
[null,"Cartago","Producción","Juan","Ramirez","Mora","1-336-777",4,{"v":124000,"d":"₡124,000.00"}]
[null,"Heredia","Informática","Maria","Hidalgo","Mora","2-334-789",12,{"v":233250,"d":"₡233,250.00"}]
[null,"San Jose","Contabilidad","Hernan","Castro","Obando","3-555-893",2,{"v":123500,"d":"₡123,500.00"}]
[null,"Puntarenas","Informática","Jaime","Sanchez","Mora","2-456-890",12,{"v":450000,"d":"₡450,000.00"}]
[null,"Alajuela","Producción","Rocio","Guillen","Moreira","1-457-987",9,{"v":500000,"d":"₡500,000.00"}]
[null,"San Jose","Producción","Fermín","Obando","Arias","5-658-789",8,{"v":50000,"d":"₡50,000.00"}]
[null,"Puntarenas","Recursos Humanos","Lucrecia","Arias","Rodríguez","3-654-781",15,{"v":77000,"d":"₡77,000.00"}]
[null,"Cartago","Finanzas","Ana","Arias","Jímenez","2-587-846",3,{"v":377000,"d":"₡377,000.00"}]
[null,"San Jose","Finanzas","Sonia","Obando","Lopez","7-895-574",26,{"v":87300.5,"d":"₡87,300.50"}]
[null,"San Jose","Informática","Fernan","Arias","Mora","4-567-332",3,{"v":166000,"d":"₡166,000.00"}]

{"sheet":"SI Y","index":18,"n_rows":58,"n_cols":6,"rows_kept":58}
{"$rows_empty":21}
[null,"Aspirante","Matemáticas","Estadística","Resultado","Resultado"]
[null,1325,80,60,null,{"$f":"+IF(AND(C23>70,D23>70),\"AC\",IF(AND(C23<70,D23>70),\"M\",IF(AND(C23>70,D23<70),\"E\",IF(AND(C23<70,D23<70),\"NA\"))))","v":"E"}]
[null,1326,10,119,null,"M"]
[null,1327,48,116,null,"M"]
[null,1328,169,43,null,"E"]
[null,1329,32,106,null,"M"]
[null,1330,46,127,null,"M"]
[null,1331,133,131,null,"AC"]
[null,1332,26,35,null,"NA"]
[null,1333,23,36,null,"NA"]
[null,1334,49,51,null,"NA"]
[null,1335,38,109,null,"M"]
[null,1336,124,99,null,"AC"]
[null,1337,100,20,null,"E"]
[null,1338,121,96,null,"AC"]
[null,1339,13,65,null,"NA"]
[null,1340,141,58,null,"E"]
[null,1341,116,38,null,"E"]
[null,1342,138,45,null,"E"]
[null,1343,102,159,null,"AC"]
[null,1344,124,63,null,"E"]
[null,1345,68,97,null,"M"]
[null,1346,137,49,null,"E"]
[null,1347,90,136,null,"AC"]
[null,1348,94,104,null,"AC"]
[null,1349,139,87,null,"AC"]
[null,1350,10,34,null,"NA"]
[null,1351,26,113,null,"M"]
[null,1352,153,61,null,"E"]
[null,1353,106,79,null,"AC"]
[null,1354,68,134,null,"M"]
[null,1355,140,62,null,"E"]
[null,1356,36,67,null,"NA"]
[null,1357,102,10,null,"E"]
[null,1358,52,83,null,"M"]
[null,1359,168,78,null,"AC"]
[null,1360,118,27,null,"E"]

{"sheet":"ATAJOS","index":19,"n_rows":33,"n_cols":2,"rows_kept":33}
[]
[]
[null,"Atajos de teclado básicos en Excel"]
[]
[null,"Ctrl+A Muestra el cuadro de diálogo Abrir."]
[null,"Ctrl+B Muestra el cuadro de diálogo Buscar."]
[null,"Ctrl+C Copia las celdas seleccionadas."]
[null,"Ctrl+D Copia una fórmula hacia la derecha sobre el rango seleccionado."]
[null,"Ctrl+E Selecciona todas las celdas de la hoja actual."]
[null,"Ctrl+G Guarda el libro de trabajo."]
[null,"Ctrl+I Muestra el cuadro de diálogo Ir a."]
[null,"Ctrl+J Copia una fórmula hacia abajo sobre el rango seleccionado."]
[null,"Ctrl+K Aplica formato de cursiva al texto seleccionado."]
[null,"Ctrl+L Muestra el cuadro de diálogo Reemplazar."]
[null,"Ctrl+N Aplica formato de negrita al texto seleccionado."]
[null,"Ctrl+P Muestra el cuadro de diálogo Imprimir."]
[null,"Ctrl+R Cierra el libro de trabajo."]
[null,"Ctrl+S Subraya el texto seleccionado."]
[null,"Ctrl+T Muestra el cuadro de diálogo Crear tabla."]
[null,"Ctrl+U Nuevo libro de trabajo."]
[null,"Ctrl+V Pega el contenido del portapapeles."]
[null,"Ctrl+X Corta las celdas seleccionadas."]
[null,"Ctrl+Y Rehace la última acción deshecha."]
[null,"Ctrl+Z Deshace la última acción."]
[null,"Ctrl+1 Muestra el cuadro de diálogo Formato de celdas."]
[null,"Ctrl+2 Aplica formato de negrita al texto seleccionado."]
[null,"Ctrl+3 Aplica formato de cursiva al texto seleccionado."]
[null,"Ctrl+4 Subraya el texto seleccionado."]
[null,"Ctrl+5 Aplica el efecto de tachado al texto."]
[null,"Ctrl+6 Oculta o muestra los objetos de la hoja."]
[null,"Ctrl+8 Muestra los símbolos de esquema en la hoja."]
[null,"Ctrl+9 Oculta las filas seleccionadas."]
[null,"Ctrl+0 Oculta las columnas seleccionadas."]