{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Resumen de escenario","tabla dinamica","Funcion Si y formato condiciona","ESCENARIOS","MACROS","subtotal","consultas por  h."],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Resumen de escenario","index":0,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Resumen de escenario"]
[null,null,null,"Valores actuales:","original ","pantalones","camisas"]
[null,null,null,null,"Creado por sena el 02/11/2012","Creado por sena el 02/11/2012","Creado por sena el 02/11/2012"]
[null,"Celdas cambiantes:"]
[null,null,{"$f":"'Funcion Si y formato condiciona'!I7","v":"Pantalones"},0.04,0.04,5.8500000000000003E-2,0.04]
[null,null,{"$f":"'Funcion Si y formato condiciona'!I8","v":"Camisas"},0.06,0.06,0.06,7.4999999999999997E-2]
[null,"Celdas de resultado:"]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A3","v":"CAMISAS"},233856,233856,233856,292320]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A4","v":"CAMISAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A5","v":"CAMISAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A6","v":"CAMISAS"},184800,184800,184800,231000]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A7","v":"CAMISAS"},887040,887040,887040,1108800]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A8","v":"CAMISAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A9","v":"CAMISAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A10","v":"CAMISAS"},665280,665280,665280,831600]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A11","v":"CHAQUETAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A12","v":"CHAQUETAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A13","v":"CHAQUETAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A14","v":"CHAQUETAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A15","v":"CHAQUETAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A16","v":"PANTALONES"},322560,322560,471744,322560]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A17","v":"PANTALONES"},7168000,7168000,10483200,7168000]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A18","v":"PANTALONES"},505344,505344,739065.6,505344]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A19","v":"PANTALONES"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A20","v":"PANTALONES"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A21","v":"PIJAMAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A22","v":"PIJAMAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A23","v":"PIJAMAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A24","v":"PIJAMAS"},0,0,0,0]
[null,null,{"$f":"'Funcion Si y formato condiciona'!A25","v":"PIJAMAS"},0,0,0,0]
[null,"Notas: La columna de valores actuales representa los valores de las celdas cambiantes"]
[null,"en el momento en que se creó el Informe resumen de escenario. Las celdas cambiantes de"]
[null,"cada escenario se muestran en gris."]

{"sheet":"tabla dinamica","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Etiquetas de fila","Suma de CANTIDAD PRODUCIDA","Suma de COSTO UNITARIO","Suma de BONIFICACION","Suma de UTILIDAD","Suma de UTILIDAD UNITARIA","Suma de Campo1"]
["CAMISAS",1719,183000,1737120.0000000002,40953480.000000007,2478480.0000000051,39399360.100000009]
["CARMEN ESCOBAR",100,22000,0,2442000.0000000005,264000.00000000047,2464000.1000000006]
[2464000.0000000005,100,22000,0,2442000.0000000005,264000.00000000047,2464000.1000000006]
["DANIELA JIMEMEZ",600,22000,887040.00000000012,15649040.000000002,2471040.0000000019,14784000.100000001]
[14784000.000000002,600,22000,887040.00000000012,15649040.000000002,2471040.0000000019,14784000.100000001]
["DIONICIA PUERTA",450,22000,665280.00000000012,11731280.000000002,1853280.0000000019,11088000.100000001]
[11088000.000000002,450,22000,665280.00000000012,11731280.000000002,1853280.0000000019,11088000.100000001]
["LUCIA JIMEMEZ",100,22000,0,2442000.0000000005,264000.00000000047,2464000.1000000006]
[2464000.0000000005,100,22000,0,2442000.0000000005,264000.00000000047,2464000.1000000006]
["MARIELA PUERTA",120,29000,0,-29000,-3480000,0.1]
["(en blanco)",120,29000,0,-29000,-3480000,0.1]
["PATRICIA ESCOBAR",125,22000,184800.00000000003,3242800.0000000005,514800.00000000047,3080000.1000000006]
[3080000.0000000005,125,22000,184800.00000000003,3242800.0000000005,514800.00000000047,3080000.1000000006]
["ROCIO QUIROZ",114,22000,0,2786960.0000000005,300960.00000000047,2808960.1000000006]
[2808960.0000000005,114,22000,0,2786960.0000000005,300960.00000000047,2808960.1000000006]
["SAMIRA RESTREPO",110,22000,0,2688400.0000000005,290400.00000000047,2710400.1000000006]
[2710400.0000000005,110,22000,0,2688400.0000000005,290400.00000000047,2710400.1000000006]
["CHAQUETAS",1481,149000,0,46357320.000000007,4982820.0000000075,46506320.100000009]
["CLEOTILDE QUINTERO",109,18500,0,2239980.0000000005,241980.00000000047,2258480.1000000006]
[2258480.0000000005,109,18500,0,2239980.0000000005,241980.00000000047,2258480.1000000006]
["DIANA JIMEMEZ",300,18500,0,6197500.0000000009,666000.00000000093,6216000.1000000006]
[6216000.0000000009,300,18500,0,6197500.0000000009,666000.00000000093,6216000.1000000006]
["ELSA QUINTERO",320,18500,0,6611900.0000000009,710400.00000000093,6630400.1000000006]
[6630400.0000000009,320,18500,0,6611900.0000000009,710400.00000000093,6630400.1000000006]
["GLORIA QUINTERO",250,75000,0,20925000.000000004,2250000.0000000037,21000000.100000005]
[21000000.000000004,250,75000,0,20925000.000000004,2250000.0000000037,21000000.100000005]
["MARTA QUIROZ",502,18500,0,10382940.000000002,1114440.0000000019,10401440.100000001]
[10401440.000000002,502,18500,0,10382940.000000002,1114440.0000000019,10401440.100000001]
["PANTALONES",9444,100000,7995904.0000000009,219441504.00000003,30661504.00000003,211545600.10000002]
["DEYANIRA ACEVEDO",220,20000,0,4908000.0000000009,528000.00000000093,4928000.1000000006]
[4928000.0000000009,220,20000,0,4908000.0000000009,528000.00000000093,4928000.1000000006]
["GLADYS QUINTERO",8000,20000,7168000.0000000009,186348000.00000003,26368000.00000003,179200000.10000002]
[179200000.00000003,8000,20000,7168000.0000000009,186348000.00000003,26368000.00000003,179200000.10000002]
["MIRIAM QUIROZ",564,20000,505344.00000000006,13118944.000000002,1858944.0000000019,12633600.100000001]
[12633600.000000002,564,20000,505344.00000000006,13118944.000000002,1858944.0000000019,12633600.100000001]
["MONICA PRIETO",300,20000,0,6700000.0000000009,720000.00000000093,6720000.1000000006]
[6720000.0000000009,300,20000,0,6700000.0000000009,720000.00000000093,6720000.1000000006]
["PABLO ESCOBAR",360,20000,322560.00000000006,8366560.0000000009,1186560.0000000009,8064000.1000000006]
[8064000.0000000009,360,20000,322560.00000000006,8366560.0000000009,1186560.0000000009,8064000.1000000006]
["PIJAMAS",1830,119000,0,48298600.000000007,5187600.0000000084,48417600.100000009]
["CLAUDIA PUERTA",465,25000,0,12995000.000000002,1395000.0000000019,13020000.100000001]
[13020000.000000002,465,25000,0,12995000.000000002,1395000.0000000019,13020000.100000001]
["DIANA JIMEMEZ",420,19000,0,8918600.0000000019,957600.00000000186,8937600.1000000015]
[8937600.0000000019,420,19000,0,8918600.0000000019,957600.00000000186,8937600.1000000015]
["GLORIA QUINTERO",200,25000,0,5575000.0000000009,600000.00000000093,5600000.1000000006]
[5600000.0000000009,200,25000,0,5575000.0000000009,600000.00000000093,5600000.1000000006]
["LAURA JIMEMEZ",45,25000,0,1235000.0000000002,135000.00000000023,1260000.1000000003]
[1260000.0000000002,45,25000,0,1235000.0000000002,135000.00000000023,1260000.1000000003]
["TERESA QUINTERO",700,25000,0,19575000.000000004,2100000.0000000037,19600000.100000005]
[19600000.000000004,700,25000,0,19575000.000000004,2100000.0000000037,19600000.100000005]
["Total general",14474,551000,9733024.0000000019,355050904.00000006,43310404.000000045,345868880.10000008]

{"sheet":"Funcion Si y formato condiciona","index":2,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,0,66,6],[57,0,61,6],[0,0,0,7],[41,0,44,6],[46,0,48,6],[28,0,30,5],[37,1,37,5],[38,1,38,5],[39,1,39,5],[32,0,33,5],[35,0,35,4],[50,0,52,6],[54,0,55,6]]}
["CONFECCIONES LA GRAN ESTAFA"]
["ARTICULO","PRODUCTOR","CANTIDAD PRODUCIDA","COSTO UNITARIO","PRECIO DE VENTA","BONIFICACION","UTILIDAD","UTILIDAD UNITARIA"]
["CAMISAS","MARIELA PUERTA",120,29000,null,{"$f":"IF(A3=$I$8,IF(C3>$J$8,E3*$K$8,0),IF(A3=$I$7,IF(C3>$J$7,E3*$K$7,0),0))","v":0},{"$f":"(E3+F3)-D3","v":-29000},{"$f":"(E3+F3)-(D3*C3)","v":-3480000},null,1.1200000000000001]
["CAMISAS","ROCIO QUIROZ",114,22000,{"$f":"(D4*$J$3)*C4","v":2808960.0000000005},{"$f":"IF(A4=$I$8,IF(C4>$J$8,E4*$K$8,0),IF(A4=$I$7,IF(C4>$J$7,E4*$K$7,0),0))","v":0},{"$f":"(E4+F4)-D4","v":2786960.0000000005},{"$f":"(E4+F4)-(D4*C4)","v":300960.00000000047}]
["CAMISAS","LUCIA JIMEMEZ",100,22000,2464000.0000000005,0,2442000.0000000005,264000.00000000047]
["CAMISAS","PATRICIA ESCOBAR",125,22000,3080000.0000000005,184800.00000000003,3242800.0000000005,514800.00000000047]
["CAMISAS","DANIELA JIMEMEZ",600,22000,14784000.000000002,887040.00000000012,15649040.000000002,2471040.0000000019,"Pantalones",300,0.04]
["CAMISAS","CARMEN ESCOBAR",100,22000,2464000.0000000005,0,2442000.0000000005,264000.00000000047,"Camisas",115,0.06]
["CAMISAS","SAMIRA RESTREPO",110,22000,2710400.0000000005,0,2688400.0000000005,290400.00000000047," "]
["CAMISAS","DIONICIA PUERTA",450,22000,11088000.000000002,665280.00000000012,11731280.000000002,1853280.0000000019]
["CHAQUETAS","GLORIA QUINTERO",250,75000,21000000.000000004,0,20925000.000000004,2250000.0000000037]
["CHAQUETAS","DIANA JIMEMEZ",300,18500,6216000.0000000009,0,6197500.0000000009,666000.00000000093]
["CHAQUETAS","MARTA QUIROZ",502,18500,10401440.000000002,0,10382940.000000002,1114440.0000000019]
["CHAQUETAS","ELSA QUINTERO",320,18500,6630400.0000000009,0,6611900.0000000009,710400.00000000093]
["CHAQUETAS","CLEOTILDE QUINTERO",109,18500,2258480.0000000005,0,2239980.0000000005,241980.00000000047]
["PANTALONES","PABLO ESCOBAR",360,20000,8064000.0000000009,322560.00000000006,8366560.0000000009,1186560.0000000009]
["PANTALONES","GLADYS QUINTERO",8000,20000,179200000.00000003,7168000.0000000009,186348000.00000003,26368000.00000003,null,null,{"$f":"E3+F3","v":0}]
["PANTALONES","MIRIAM QUIROZ",564,20000,12633600.000000002,505344.00000000006,13118944.000000002,1858944.0000000019,null,null,{"$f":"K17-D3","v":-29000}]
["PANTALONES","DEYANIRA ACEVEDO",220,20000,4928000.0000000009,0,4908000.0000000009,528000.00000000093,null,null,{"$f":"D3*C3","v":3480000}]
["PANTALONES","MONICA PRIETO",300,20000,6720000.0000000009,0,6700000.0000000009,720000.00000000093]
["PIJAMAS","DIANA JIMEMEZ",420,19000,8937600.0000000019,0,8918600.0000000019,957600.00000000186,null,null,{"$f":"K17-K19","v":-3480000}]
["PIJAMAS","GLORIA QUINTERO",200,25000,5600000.0000000009,0,5575000.0000000009,600000.00000000093]
["PIJAMAS","CLAUDIA PUERTA",465,25000,13020000.000000002,0,12995000.000000002,1395000.0000000019]
["PIJAMAS","LAURA JIMEMEZ",45,25000,1260000.0000000002,0,1235000.0000000002,135000.00000000023]
["PIJAMAS","TERESA QUINTERO",700,25000,19600000.000000004,0,19575000.000000004,2100000.0000000037]
[]
["BONIFICACION"]
[]
["El precio de venta sera el 12% del costo unitario mas el costo unitario.  Si la cantidad de PANTALONES es superior a 300, hagale una bonificacion del 4% sobre el EXCEDENTE por el costo.  "]
[]
[]
[]
["si la cantidad de CAMISAS es superior a 115, hagale una bonificacion del 6% sobre el EXCEDENTE por el costo."]
[]
[]
["Al resultado del ejercicio apliquele formato condicional, de la siguiente forma:"]
[]
[null," Color Azul para los articulos que no recibieron bonificacion"]
[null," Color Rojo para los articulos que recibieron bonificacion del 6%"]
[null," Color Amarillo para los articulos que recibieron bonificacion del 4%"]
[]
["Aplique escenarios aquí para ver cual seria la bonificacion con incremetos de 7,5% para quienes producen CAMISAS, Y DEL 5,85% para quienes producen PANTALONES. Este ejercicio lo hara en una hoja nueva a la cual le dara el nombre de escenarios. Los datos para realizar este ejercicio son los que se encuentran en la parte superior."]
[]
[]
[]
[]
["Aplique SUBTOTALES por ARTICULO y PRODUCTOR; subtotales de suma, maximo, promedios y contar.  Este ejercicio lo hara en una hoja nueva a la cual le dara el nombre de subtotales. Los datos para realizar este ejercicio son los que se encuentran en la parte superior."]
[]
[]
[]
["Genere una macro que haga el calculo de las bonificaciones con los parametros de PANTALONES del 6% y CAMISAS DEL 4%, luego realice un grafico de tipo circular, el numero 4, con las columnas PRODUCTOR y BONIFICACION."]
[]
[]
[]
["Luego intente hacer una macro que borre todo lo realizado anteriormente.  Por ultimo genere los botones para dichas macros, con los nombres de CALCULAR y LIMPIAR"]
[]
[]
["Inserte una hoja, la cual llamara consultas que por medio de la herramienta BuscarV permita hacer consultas por cada uno de los productores, es decir qalseleccionar de unalista desplegable el nombre del productor, muestre toda la informacion que le corresponde a dicho productor.  Por ultimo genere una tabla dinamica que muestre los articulos y las cantidades, ademas generara un campo calculado que le adicione a las cantidades el 10% de las cantidades reales."]
[]
[]
[]
[]
[]
["Cada uno de los ejercicios los hara en una hoja nueva, la cual tendra el nombre de la funcion que se realiza, por ultimo creara una hoja nueva, esta tendra el nombre de menu; en la cual tendra un botones que permitan ir a cada una de las hojas realizadas y por su puesto en cada hoja tambien habra un boton que permita retornar al menu, al finalizar guarde el archivo con su nombre"]

{"sheet":"ESCENARIOS","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,11,6]]}
["ARTICULO","PRODUCTOR","CANTIDAD PRODUCIDA","COSTO UNITARIO","BONIFICACION","PRECIO DE VENTA","UTILIDAD"]
["CAMISAS","MARIELA PUERTA",120,29000,null,{"$f":"(D2*C2)","v":3480000},{"$f":"(F2*C2)-(D2*C2)+E2","v":414120000}]
["CAMISAS","ROCIO QUIROZ",114,22000,null,{"$f":"(D3*C3)","v":2508000},{"$f":"(F3*C3)-(D3*C3)+E3","v":283404000}]
["CHAQUETAS","GLORIA QUINTERO",250,75000,null,18750000,4668750000]
["CHAQUETAS","DIANA JIMEMEZ",300,18500,null,5550000,1659450000]
["PANTALONES","PABLO ESCOBAR",360,20000,null,7200000,2584800000]
["PIJAMAS","DIANA JIMEMEZ",420,19000,null,7980000,3343620000]
["PIJAMAS","GLORIA QUINTERO",200,25000,null,5000000,995000000]
[]
[]
["Aplique escenarios aquí para ver cual seria la bonificacion con incremetos de 7,5% para quienes producen CAMISAS, Y DEL 5,85% para quienes producen PANTALONES."]

{"sheet":"MACROS","index":4,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,12,6],[14,0,15,6]]}
[]
["ARTICULO","PRODUCTOR","CANTIDAD PRODUCIDA","COSTO UNITARIO","PRECIO DE VENTA","Bonificacion","UTILIDAD"]
["CHAQUETAS","GLORIA QUINTERO",250,75000,{"$f":"(D3*$J$3)*C3","v":21000000.000000004},{"$f":"IF(A3=$I$8,IF(C3>$J$8,E3*$K$8,0),IF(A3=$I$7,IF(C3>$J$7,E3*$K$7,0),0))","v":0},{"$f":"(E3+F3)-D3","v":20925000.000000004},null,null,1.1200000000000001]
["CAMISAS","MARIELA PUERTA",120,29000,{"$f":"(D4*$J$3)*C4","v":3897600.0000000005},{"$f":"IF(A4=$I$8,IF(C4>$J$8,E4*$K$8,0),IF(A4=$I$7,IF(C4>$J$7,E4*$K$7,0),0))","v":155904.00000000003},{"$f":"(E4+F4)-D4","v":4024504.0000000005}]
["PANTALONES","PABLO ESCOBAR",360,20000,8064000.0000000009,483840.00000000006,8527840.0000000019]
["PIJAMAS","DIANA JIMEMEZ",420,19000,8937600.0000000019,0,8918600.0000000019]
["CAMISAS","ROCIO QUIROZ",114,22000,2808960.0000000005,0,2786960.0000000005,null,"Pantalones",300,0.06]
["PIJAMAS","GLORIA QUINTERO",200,25000,5600000.0000000009,0,5575000.0000000009,null,"Camisas",115,0.04]
["CHAQUETAS","DIANA JIMEMEZ",300,18500,6216000.0000000009,0,6197500.0000000009]
[]
["Genere una macro que haga el calculo de las bonificaciones con los parametros de PANTALONES del 6% y CAMISAS DEL 4%, luego realice un grafico de tipo circular, el numero 4, con las columnas PRODUCTOR y BONIFICACION."]
[]
[]
[]
["Luego intente hacer una macro que borre todo lo realizado anteriormente.  Por ultimo genere los botones para dichas macros, con los nombres de CALCULAR y LIMPIAR"]

{"sheet":"subtotal","index":5,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["ARTICULO","PRODUCTOR","CANTIDAD PRODUCIDA","COSTO UNITARIO","PRECIO DE VENTA","BONIFICACION","UTILIDAD","UTILIDAD UNITARIA"]
["CAMISAS","MARIELA PUERTA",120,29000,{"$f":"(D3*$J$3)*C3","v":3897600.0000000005},{"$f":"IF(A3=$I$8,IF(C3>$J$8,E3*$K$8,0),IF(A3=$I$7,IF(C3>$J$7,E3*$K$7,0),0))","v":233856.00000000003},{"$f":"(E3+F3)-D3","v":4102456.0000000005},{"$f":"(E3+F3)-(D3*C3)","v":651456.00000000047},null,1.1200000000000001]
["CAMISAS","ROCIO QUIROZ",114,22000,{"$f":"(D4*$J$3)*C4","v":2808960.0000000005},{"$f":"IF(A4=$I$8,IF(C4>$J$8,E4*$K$8,0),IF(A4=$I$7,IF(C4>$J$7,E4*$K$7,0),0))","v":0},{"$f":"(E4+F4)-D4","v":2786960.0000000005},{"$f":"(E4+F4)-(D4*C4)","v":300960.00000000047}]
["CAMISAS","LUCIA JIMEMEZ",100,22000,2464000.0000000005,0,2442000.0000000005,264000.00000000047]
["CAMISAS","PATRICIA ESCOBAR",125,22000,3080000.0000000005,184800.00000000003,3242800.0000000005,514800.00000000047]
["CAMISAS","DANIELA JIMEMEZ",600,22000,14784000.000000002,887040.00000000012,15649040.000000002,2471040.0000000019,"Pantalones",300,0.04]
["CAMISAS","CARMEN ESCOBAR",100,22000,2464000.0000000005,0,2442000.0000000005,264000.00000000047,"Camisas",115,0.06]
["CAMISAS","SAMIRA RESTREPO",110,22000,2710400.0000000005,0,2688400.0000000005,290400.00000000047," "]
["CAMISAS","DIONICIA PUERTA",450,22000,11088000.000000002,665280.00000000012,11731280.000000002,1853280.0000000019]
["CHAQUETAS","GLORIA QUINTERO",250,75000,21000000.000000004,0,20925000.000000004,2250000.0000000037]
["CHAQUETAS","DIANA JIMEMEZ",300,18500,6216000.0000000009,0,6197500.0000000009,666000.00000000093]
["CHAQUETAS","MARTA QUIROZ",502,18500,10401440.000000002,0,10382940.000000002,1114440.0000000019]
["CHAQUETAS","ELSA QUINTERO",320,18500,6630400.0000000009,0,6611900.0000000009,710400.00000000093]
["CHAQUETAS","CLEOTILDE QUINTERO",109,18500,2258480.0000000005,0,2239980.0000000005,241980.00000000047]
["PANTALONES","PABLO ESCOBAR",360,20000,8064000.0000000009,322560.00000000006,8366560.0000000009,1186560.0000000009]
["PANTALONES","GLADYS QUINTERO",8000,20000,179200000.00000003,7168000.0000000009,186348000.00000003,26368000.00000003,null,null,{"$f":"E3+F3","v":4131456.0000000005}]
["PANTALONES","MIRIAM QUIROZ",564,20000,12633600.000000002,505344.00000000006,13118944.000000002,1858944.0000000019,null,null,{"$f":"K17-D3","v":4102456.0000000005}]
["PANTALONES","DEYANIRA ACEVEDO",220,20000,4928000.0000000009,0,4908000.0000000009,528000.00000000093,null,null,{"$f":"D3*C3","v":3480000}]
["PANTALONES","MONICA PRIETO",300,20000,6720000.0000000009,0,6700000.0000000009,720000.00000000093]
["PIJAMAS","DIANA JIMEMEZ",420,19000,8937600.0000000019,0,8918600.0000000019,957600.00000000186,null,null,{"$f":"K17-K19","v":651456.00000000047}]
["PIJAMAS","GLORIA QUINTERO",200,25000,5600000.0000000009,0,5575000.0000000009,600000.00000000093]
["PIJAMAS","CLAUDIA PUERTA",465,25000,13020000.000000002,0,12995000.000000002,1395000.0000000019]
["PIJAMAS","LAURA JIMEMEZ",45,25000,1260000.0000000002,0,1235000.0000000002,135000.00000000023]
["PIJAMAS","TERESA QUINTERO",700,25000,19600000.000000004,0,19575000.000000004,2100000.0000000037]
[]
["suma",null,{"$f":"SUBTOTAL(9,C3:C25)","v":14474},551000,349766480.00000006,9966880.0000000019,359182360.00000006,47441860.000000045]
[]
["maximo",null,{"$f":"SUBTOTAL(4,C3:C25)","v":8000},75000,179200000.00000003,7168000.0000000009,186348000.00000003,26368000.00000003]
[]
["promedio",null,{"$f":"SUBTOTAL(1,C3:C25)","v":629.304347826087},{"$f":"SUBTOTAL(1,D3:D25)","v":23956.521739130436},15207238.260869568,433342.60869565228,15616624.34782609,2062689.5652173932]
[]
["conteo",null,{"$f":"SUBTOTAL(2,C3:C25)","v":23},{"$f":"SUBTOTAL(2,D3:D25)","v":23},23,23,23,23]

{"sheet":"consultas por  h.","index":6,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ARTICULO","PRODUCTOR","CANTIDAD PRODUCIDA","COSTO UNITARIO","PRECIO DE VENTA","BONIFICACION","UTILIDAD"]
["PRECIO DE VENTA",{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A3:H25,2)","v":"TERESA QUINTERO"},{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A2:H25,3)","v":700},{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A3:H25,4)","v":25000},{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A3:H25,5)","v":19600000.000000004},{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A3:H25,6)","v":0},{"$f":"VLOOKUP($A$3,'Funcion Si y formato condiciona'!A3:H25,7)","v":19575000.000000004}]