{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["PRACTICA","DESARROLLO","CALCULOS BÁSICOS","REFERENCIAS","Hoja11","FUNCION SI","NUMEROS"],"not_rendered":{"charts":0,"images":0,"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":"PRACTICA","index":0,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,11,1,14],[20,12,20,13],[25,12,25,13]]}
["CC / DNI","NOMBRE","AREA","SALARIO","VENTAS","% COMISION","VR. COMISION","AUX. TRANS","AP. A SALUD","A PAGAR",null,"RESUMEN"]
[1466,"MARIA FERNANDA","RECURSOS H",50000,10800,{"$f":"IFERROR(VLOOKUP(E2,$M$22:$N$24,2,TRUE),0)","v":0.05},{"$f":"IF(C2=\"CONTABILIDAD\",E2*F2,0)","v":0},{"$f":"IF(D2<=($N$28*4),$N$28,0)","v":0},{"$f":"D2*4%","v":2000},{"$f":"+D2+E2+G2+H2-I2","v":58800},null,null,null,null,null,null,1,"SUMA EL TOTAL DE VENTAS"]
[929,"JORGE CUBILLOS","VENTAS",41639,22037,{"$f":"IFERROR(VLOOKUP(E3,$M$22:$N$24,2,TRUE),0)","v":0.1},{"$f":"IF(C3=\"CONTABILIDAD\",E3*F3,0)","v":0},{"$f":"IF(D3<=($N$28*4),$N$28,0)","v":0},{"$f":"D3*4%","v":1665.56},{"$f":"+D3+E3+G3+H3-I3","v":62010.44},null,null,"CC / DNI:",1651,null,null,2,"CALCULA EL % DE COMISIÓN SEGÚN LAS VENTAS"]
[1055,"MERLY TRUJILLO","CONTABILIDAD",34537,21648,0.1,2164.8000000000002,{"$f":"IF(D4<=($N$28*4),$N$28,0)","v":0},1381.48,56968.32,null,null,null,null,null,null,3,"CALCULA LA COMISION PARA EL AREA DE CONTABILIDAD"]
[1443,"MARINA LOPEZ","RECURSOS H",55587,16686,0.05,0,0,2223.48,70049.52,null,null,"NOMBRE:",{"$f":"VLOOKUP(N3,A2:I20,2,FALSE)","v":"LUZ SALCEDO"},null,null,4,"CALCULA EL AUX. TRANSPORTE SOLO PARA QUIENES GANEN MENOS DE 4 SALARIOS MINIMOS"]
[1651,"LUZ SALCEDO","VENTAS",52545,10916,0.05,0,0,2101.8000000000002,61359.199999999997,null,null,null,null,null,null,5,"SUMA EL NETO A PAGAR"]
[1367,"ALEX APARICIO MENDEZ","BODEGA",45805,17195,0.05,0,0,1832.2,61167.8,null,null,"AREA:",{"$f":"INDEX($A$2:$I$20,MATCH($N$3,$A$2:$A$20,0),3)","v":"VENTAS"}]
[1521,"CAMILA ZUÑIGA","CONTABILIDAD",48713,5007,0,0,0,1948.52,51771.48]
[1809,"JOHANA VARGAS","RECURSOS H",38469,25605,0.1,0,0,1538.76,62535.24,null,null,"COMISION:",{"$f":"INDEX($A$2:$I$20,MATCH($N$3,$A$2:$A$20,0),4)","v":52545}]
[1080,"PIPE MENDEZ","VENTAS",26599,24799,0.1,0,8400,1063.96,58734.04]
[1728,"NATHALIA MURCIA","CONTABILIDAD",36453,26873,0.1,2687.3,0,1458.1200000000001,64555.18,null,null,"AUX TRANSPORTE:",{"$f":"INDEX($A$2:$I$20,MATCH($N$3,$A$2:$A$20,0),5)","v":10916}]
[1605,"ALEJANDRA COLORADO","BODEGA",40478,3369,0,0,0,1619.1200000000001,42227.88]
[986,"CAROLINA ROJAS","RECURSOS H",51794,26889,0.1,0,0,2071.7600000000002,76611.240000000005,null,null,"NETO A PAGAR:",{"$f":"INDEX($A$2:$J$20,MATCH($N$3,$A$2:$A$20,0),10)","v":61359.199999999997}]
[1009,"LUIS DEL CARMEN","CONTABILIDAD",31891,20840,0.1,2084,8400,1275.6400000000001,61939.360000000001]
[919,"KARLA MORA","BODEGA",30580,21249,0.1,0,8400,1223.2,59005.8]
[1257,"STEPHANIA SANCHEZ","BODEGA",52921,20107,0.1,0,0,2116.84,70911.16]
[1353,"MARIANA ARTEAGA","RECURSOS H",45592,18173,0.05,0,0,1823.68,61941.32]
[853,"SANTIAGO AMAYA","RECURSOS H",58145,12489,0.05,0,0,2325.8000000000002,68308.2]
[1750,"CRUZ DE LAS CASAS","BODEGA",50133,14333,0.05,0,0,2005.32,62460.68]
[927,"PAOLA CAMILA ESTUPIÑAN","VENTAS",42054,15463,0.05,0,0,1682.16,55834.84]
[null,null,null,null,null,null,null,null,null,null,null,null,"COMISIONES"]
[null,null,null,null,null,null,null,null,null,null,null,null,10000,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,20000,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,30000,0.17]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTROS PARAMETROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SALARIO MINIMO",42000]
[null,null,null,null,null,null,null,null,null,null,null,null,"AUX. DE TRANSPORTE",{"$f":"+N27*20%","v":8400}]

{"sheet":"DESARROLLO","index":1,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,11,1,14],[20,12,20,13],[25,12,25,13]]}
["CC / DNI","NOMBRE","AREA","SALARIO","VENTAS","% COMISION","VR. COMISION","AUX. TRANS","AP. A SALUD","A PAGAR",null,"RESUMEN"]
[1466,"MARIA FERNANDA","RECURSOS H",32075,10800,{"$f":"VLOOKUP(E2,$M$22:$N$24,2,1)","v":0.05},{"$f":"IF(C2=\"CONTABILIDAD\",F2*E2,0)","v":0},null,null,{"$f":"+D2+E2+G2+H2-I2","v":42875},null,null,null,null,null,null,1,"SUMA EL TOTAL DE VENTAS"]
[929,"JORGE CUBILLOS","VENTAS",41639,22037,{"$f":"VLOOKUP(E3,$M$22:$N$24,2,1)","v":0.1},{"$f":"IF(C3=\"CONTABILIDAD\",F3*E3,0)","v":0},null,null,{"$f":"+D3+E3+G3+H3-I3","v":63676},null,null,"CC / DNI:",929,null,null,2,"CALCULA EL % DE COMISIÓN"]
[1055,"MERLY TRUJILLO","CONTABILIDAD",34537,21648,0.1,2164.8000000000002,null,null,58349.8,null,null,null,null,null,null,3,"CALCULA LA COMISION POR VENTAS"]
[1443,"MARINA LOPEZ","RECURSOS H",55587,16686,0.05,0,null,null,72273,null,null,"NOMBRE:",{"$f":"VLOOKUP($N$3,$A$2:$J$20,2,FALSE)","v":"JORGE CUBILLOS"},null,null,4,"CALCULA LA COMISION PARA EL AREA DE CONTABILIDAD"]
[1651,"LUZ SALCEDO","VENTAS",52545,10916,0.05,0,null,null,63461,null,null,null,null,null,null,5,"CALCULA EL AUX. TRANSPORTE SOLO PARA QUIENES GANEN MENOS DE 4 SALARIOS MINIMOS"]
[1367,"ALEX APARICIO MENDEZ","BODEGA",45805,17195,0.05,0,null,null,63000,null,null,"AREA:",{"$f":"VLOOKUP($N$3,$A$2:$J$20,3,FALSE)","v":"VENTAS"},null,null,6,"SUMA EL NETO A PAGAR"]
[1521,"CAMILA ZUÑIGA","CONTABILIDAD",48713,5007,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$error":"#N/A"}]
[1809,"JOHANA VARGAS","RECURSOS H",38469,25605,0.1,0,null,null,64074,null,null,"COMISION:",{"$f":"VLOOKUP($N$3,$A$2:$J$20,7,FALSE)","v":0}]
[1080,"PIPE MENDEZ","VENTAS",26599,24799,0.1,0,null,null,51398]
[1728,"NATHALIA MURCIA","CONTABILIDAD",36453,26873,0.1,2687.3,null,null,66013.3,null,null,"AUX TRANSPORTE:",{"$f":"VLOOKUP($N$3,$A$2:$J$20,8,FALSE)","v":0}]
[1605,"ALEJANDRA COLORADO","BODEGA",40478,3369,{"$error":"#N/A"},0,null,null,43847]
[986,"CAROLINA ROJAS","RECURSOS H",51794,26889,0.1,0,null,null,78683,null,null,"NETO A PAGAR:",{"$f":"VLOOKUP($N$3,$A$2:$J$20,10,FALSE)","v":63676}]
[1009,"LUIS DEL CARMEN","CONTABILIDAD",31891,20840,0.1,2084,null,null,54815]
[919,"KARLA MORA","BODEGA",30580,21249,0.1,0,null,null,51829]
[1257,"STEPHANIA SANCHEZ","BODEGA",52921,20107,0.1,0,null,null,73028]
[1353,"MARIANA ARTEAGA","RECURSOS H",45592,18173,0.05,0,null,null,63765]
[853,"SANTIAGO AMAYA","RECURSOS H",58145,12489,0.05,0,null,null,70634]
[1750,"CRUZ DE LAS CASAS","BODEGA",50133,14333,0.05,0,null,null,64466]
[927,"PAOLA CAMILA ESTUPIÑAN","VENTAS",42054,15463,0.05,0,null,null,57517]
[null,null,null,null,{"$f":"SUM(E2:E20)","v":334478},null,null,null,null,null,null,null,"COMISIONES"]
[null,null,null,null,null,null,null,null,null,null,null,null,10000,0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,20000,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,30000,0.17]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"OTROS PARAMETROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"SALARIO MINIMO",42000]
[null,null,null,null,null,null,null,null,null,null,null,null,"AUX. DE TRANSPORTE",{"$f":"+N27*20%","v":8400}]

{"sheet":"CALCULOS BÁSICOS","index":2,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["VENTAS DEL MES",null,null,null,null,"DESCUENTO",0.15]
["CANTIDAD","VALOR UNITARIO","VALOR TOTAL","DESCUENTO","NETO"]
[14,1950,{"$f":"A3*B3","v":27300},{"$f":"C3*15%","v":4095},{"$f":"C3-D3","v":23205}]
[45,2606,{"$f":"+A4*B4","v":117270},{"$f":"C4*15%","v":17590.5},{"$f":"C4-D4","v":99679.5}]
[27,1132,{"$f":"+A5*B5","v":30564},4584.5999999999995,25979.4]
[18,3745,67410,10111.5,57298.5]
[3,2843,8529,1279.3499999999999,7249.65]
[41,2160,88560,13284,75276]
[12,2266,27192,4078.7999999999997,23113.200000000001]
[43,2498,107414,16112.099999999999,91301.9]

{"sheet":"REFERENCIAS","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,4]]}
["VENTAS DEL MES",null,null,null,null,"DESCUENTO",0.15]
[]
["CANTIDAD","VALOR UNITARIO","VALOR TOTAL","DESCUENTO","NETO"]
[14,1950,{"$f":"+A4*B4","v":27300},{"$f":"C4*$G$1","v":4095}]
[45,2606,{"$f":"+A5*B5","v":117270},{"$f":"C5*$G$1","v":17590.5}]
[27,1132,30564,{"$f":"$C$6*$G$1","v":4584.5999999999995}]
[18,3745,67410,{"$f":"$C$6*$G$1","v":4584.5999999999995}]
[3,2843,8529,4584.5999999999995,null,null,null,{"$f":"$C$6*$G$1","v":4584.5999999999995}]
[41,2160,88560,4584.5999999999995]
[12,2266,27192,4584.5999999999995,null,null,null,null,{"$f":"$C$6*$G$1","v":4584.5999999999995}]
[43,2498,107414,4584.5999999999995]
[null,null,null,null,null,null,null,null,{"$f":"$C$6*$G$1","v":4584.5999999999995}]

{"sheet":"Hoja11","index":4,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["FUNCIONES SIN PARAMETROS"]
[{"$f":"TODAY()","v":"2021-03-06"}]
[{"$f":"NOW()","v":"2021-03-06T03:30:52.440"}]
[]
["FUNCIONES CON PARAMETROS"]
[{"$f":"SUM(4,5,6,7)","v":22}]

{"sheet":"FUNCION SI","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["VENTAS DEL MES",null,null,null,null,null,"DESCUENTO",0.15]
[]
["CANTIDAD","VALOR UNITARIO","VALOR TOTAL","MES","%DESCUENTO","DESCUENTO","NETO",null,"EL DESCUENTO APLICA SOLO PARA EL MES DE ENERO Y ABRIL"]
[14,1950,{"$f":"+A4*B4","v":27300},"ENERO"]
[45,2606,{"$f":"+A5*B5","v":117270},"FEBRERO"]
[27,1132,30564,"MARZO"]
[18,3745,67410,"ABRIL"]
[3,2843,8529,"ENERO"]
[41,2160,88560,"DICIEMBRE"]
[12,2266,27192,"AGOSTO"]
[43,2498,107414,"ENERO"]

{"sheet":"NUMEROS","index":6,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["VALORES"]
["29,020.20"]
[86183]
[92626]
["82,390.32"]
[29278]
[54991]
[84999]
[25808]
[55813]
[89898]
[95121]
[10819]
[18346]
[60205]
[18015]
[88417]
[26419]
[11411]
[46957]