{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Principal","Tabla Filtro Macro I","S - Total Macro II","Texto Columna","Contar Sumar SI","Sumar SI Grafico","Contar-Sumar Si Conjunto","Funcion Logica SI","SI Anidado","Si Anidaddo Ad. Nombre","Parametros","Logica Option","Check","Check 2","Formato Y","Funcion Logica Y","Ejercicio Y Check","Funcion Logica O","Funcion Logica Y O"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Principal","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["MENU PRINCIPAL"]

{"sheet":"Tabla Filtro Macro I","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Menú Principal"]
[null,"RUT","NOMBRE","CARGO","CENTRO COSTO","RENTA","DESCUENTOS","LIQUIDO"]
[null,"04.308.131-4","Calderón Galaz Jose","SECRETARIA","FINANZAS",582400,{"$f":"F3*21%","v":122304},{"$f":"F3-G3","v":460096}]
[null,"05.334.664-2","Catalán Toro Armanda","ADMINISTRATIVO","RR.HH",458000,96180,361820]
[null,"06.565.470-9","Bacián Lavín Carlos","ADMINISTRATIVO","VENTAS",641000,134610,506390]
[null,"06.843.720-2","Alvarez Torres Erick","ADMINISTRATIVO","VENTAS",574000,120540,453460]
[null,"06.633.613-1","Castro Vásquez Bernardo","GERENTE","VENTAS",900000,189000,711000]
[null,"05.057.894-1","Chávez González Elsa","SECRETARIA","VENTAS",566000,118860,447140]
[null,"06.434.788-8","Belmar Hormazábal Rodrigo","SECRETARIA","VENTAS",528000,110880,417120]
[null,"03.903.946-K","Castro Córdova Silvia","VENDEDOR","VENTAS",457000,95970,361030]
[null,"05.299.873-5","Aranguiz Figueroa Emilio","VENDEDOR","VENTAS",550000,115500,434500]
[null,"06.633.876-2","Astudillo Pereira Verónica","VENDEDOR","VENTAS",557000,116970,440030]
[]
[null,null,null,"CARGO"]
[null,null,null,"VENDEDOR"]
[]
[null,"RUT","NOMBRE","CARGO","CENTRO COSTO","RENTA","DESCUENTOS","LIQUIDO"]
[null,"03.903.946-K","Castro Córdova Silvia","VENDEDOR","VENTAS",457000,95970,361030]
[null,"05.299.873-5","Aranguiz Figueroa Emilio","VENDEDOR","VENTAS",550000,115500,434500]
[null,"06.633.876-2","Astudillo Pereira Verónica","VENDEDOR","VENTAS",557000,116970,440030]

{"sheet":"S - Total Macro II","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"RUT","NOMBRE","CARGO","CENTRO COSTO","RENTA","DESCUENTOS","LIQUIDO"]
[null,"05.334.664-2","Catalán Toro Armanda","ADMINISTRATIVO","RR.HH",458000,{"$f":"F4*21%","v":96180},{"$f":"F4-G4","v":361820}]
[null,"06.565.470-9","Bacián Lavín Carlos","ADMINISTRATIVO","VENTAS",641000,{"$f":"F5*21%","v":134610},{"$f":"F5-G5","v":506390}]
[null,"06.843.720-2","Alvarez Torres Erick","ADMINISTRATIVO","VENTAS",574000,{"$f":"F6*21%","v":120540},{"$f":"F6-G6","v":453460}]
[null,"06.633.613-1","Castro Vásquez Bernardo","GERENTE","VENTAS",900000,{"$f":"F7*21%","v":189000},{"$f":"F7-G7","v":711000}]
[null,"04.308.131-4","Calderón Galaz Jose","SECRETARIA","FINANZAS",582400,{"$f":"F8*21%","v":122304},{"$f":"F8-G8","v":460096}]
[null,"05.057.894-1","Chávez González Elsa","SECRETARIA","VENTAS",566000,{"$f":"F9*21%","v":118860},{"$f":"F9-G9","v":447140}]
[null,"06.434.788-8","Belmar Hormazábal Rodrigo","SECRETARIA","VENTAS",528000,{"$f":"F10*21%","v":110880},{"$f":"F10-G10","v":417120}]
[null,"03.903.946-K","Castro Córdova Silvia","VENDEDOR","VENTAS",457000,{"$f":"F11*21%","v":95970},{"$f":"F11-G11","v":361030}]
[null,"05.299.873-5","Aranguiz Figueroa Emilio","VENDEDOR","VENTAS",550000,{"$f":"F12*21%","v":115500},{"$f":"F12-G12","v":434500}]
[null,"06.633.876-2","Astudillo Pereira Verónica","VENDEDOR","VENTAS",557000,{"$f":"F13*21%","v":116970},{"$f":"F13-G13","v":440030}]

{"sheet":"Texto Columna","index":3,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"1.- Concatenar ",null,"2.- &",null,"RUT","DV","RUT FINAL"]
[null,"NOMBRE",null,"PATERNO","MATERNO","NOMBRE",null,"NOMBRE",null,"NOMBRE",null,111111111,"K",{"$f":"L2 & \"- \" &M2","v":"111111111- K"}]
[null,"Calderón Galaz Jose",null,"Calderón","Galaz","Jose",null,{"$f":"_xlfn.CONCAT(F3,\" \",D3,\" \",E3)","v":"Jose Calderón Galaz"},null,{"$f":"F3 & \" \" &D3 & \" \" & E3","v":"Jose Calderón Galaz"}]
[null,"Catalán Toro Armanda",null,"Catalán","Toro","Armanda",null,{"$f":"_xlfn.CONCAT(F4,\" \",D4,\" \",E4)","v":"Armanda Catalán Toro"},null,{"$f":"F4 & \" \" &D4 & \" \" & E4","v":"Armanda Catalán Toro"}]
[null,"Bacián Lavín Carlos",null,"Bacián","Lavín","Carlos",null,"Carlos Bacián Lavín",null,"Carlos Bacián Lavín"]
[null,"Alvarez Torres Erick",null,"Alvarez","Torres","Erick",null,"Erick Alvarez Torres",null,"Erick Alvarez Torres"]
[null,"Castro Vásquez Bernardo",null,"Castro","Vásquez","Bernardo",null,"Bernardo Castro Vásquez",null,"Bernardo Castro Vásquez"]
[null,"Chávez González Elsa",null,"Chávez","González","Elsa",null,"Elsa Chávez González",null,"Elsa Chávez González"]
[null,"Belmar Hormazábal Rodrigo",null,"Belmar","Hormazábal","Rodrigo",null,"Rodrigo Belmar Hormazábal",null,"Rodrigo Belmar Hormazábal"]
[null,"Castro Córdova Silvia",null,"Castro","Córdova","Silvia",null,"Silvia Castro Córdova",null,"Silvia Castro Córdova"]
[null,"Aranguiz Figueroa Emilio",null,"Aranguiz","Figueroa","Emilio",null,"Emilio Aranguiz Figueroa",null,"Emilio Aranguiz Figueroa"]
[null,"Astudillo Pereira Verónica",null,"Astudillo","Pereira","Verónica",null,"Verónica Astudillo Pereira",null,"Verónica Astudillo Pereira"]

{"sheet":"Contar Sumar SI","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Contar.Si","Sumar.Si","Promedio.si"]
[null,"Vendedor","Zona","Enero","Febrero","Total",null,"Zona","N°","Total  $","Promedio"]
[null,"Chávez González Elsa","Norte",2000000,3761993,{"$f":"SUM(D3:E3)","v":5761993},null,"Norte",{"$f":"COUNTIF(Zona,H3)","v":7},{"$f":"SUMIF(Zona,H3,TotZ)","v":68893043},{"$f":"AVERAGEIF(Zona,H3,TotZ)","v":9841863.2857142854}]
[null,"Catalán Toro Armanda","Centro",2826258,5452833,{"$f":"SUM(D4:E4)","v":8279091},null,"Centro",{"$f":"COUNTIF(Zona,H4)","v":4},{"$f":"SUMIF(Zona,H4,TotZ)","v":31737452},{"$f":"AVERAGEIF(Zona,H4,TotZ)","v":7934363}]
[null,"Contreras Márquez Laura","Norte",7407818,3157745,10565563,null,"Sur",{"$f":"COUNTIF(Zona,H5)","v":3},{"$f":"SUMIF(Zona,H5,TotZ)","v":29854196},{"$f":"AVERAGEIF(Zona,H5,TotZ)","v":9951398.666666666}]
[null,"Acevedo Navarro José","Norte",4358000,8426000,12784000]
[null,"Calderón Galaz Jose","Sur",1130677,5067890,6198567]
[null,"Belmar Hormazábal Rodrigo","Norte",6906087,3885627,10791714]
[null,"Blanco Vera Washington","Centro",1990275,1632192,3622467]
[null,"Castro Córdova Silvia","Norte",2345876,5762571,8108447]
[null,"Astudillo Pereira Verónica","Sur",4297000,10052000,14349000]
[null,"Alarcón Casanova Sergio","Centro",5000000,4470000,9470000]
[null,"Armijo Lizama Leonardo","Norte",8731335,2453000,11184335]
[null,"Dinara Lopez","Centro",5877136,4488758,10365894]
[null,"Elisa Mota","Norte",1544000,8152991,9696991]
[null,"Alicia Perez","Sur",1557269,7749360,9306629]

{"sheet":"Sumar SI Grafico","index":5,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vendedor","Zona","Enero","Febrero","Total",null,"Zona","N°","Total  $"]
[null,"Chávez González Elsa","Norte",4108792,3761993,{"$f":"SUM(D3:E3)","v":7870785},null,"Norte"]
[null,"Catalán Toro Armanda","Sur",2826258,5452833,{"$f":"SUM(D4:E4)","v":8279091},null,"Centro"]
[null,"Contreras Márquez Laura","Norte",7407818,3157745,10565563,null,"Sur"]
[null,"Acevedo Navarro José","Norte",4358000,8426000,12784000]
[null,"Calderón Galaz Jose","Sur",1130677,5067890,6198567]
[null,"Belmar Hormazábal Rodrigo","Norte",6906087,3885627,10791714]
[null,"Blanco Vera Washington","Centro",1990275,1632192,3622467]
[null,"Castro Córdova Silvia","Norte",2345876,5762571,8108447]
[null,"Astudillo Pereira Verónica","Sur",4297000,10052000,14349000]
[null,"Alarcón Casanova Sergio","Centro",5000000,4470000,9470000]
[null,"Armijo Lizama Leonardo","Norte",8731335,2453000,11184335]
[null,"Dinara Lopez","Centro",5877136,4488758,10365894]
[null,"Elisa Mota","Norte",1544000,8152991,9696991]
[null,"Alicia Perez","Sur",1557269,7749360,9306629]

{"sheet":"Contar-Sumar Si Conjunto","index":6,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vendedor","Zona","Agencia","Enero","Febrero","Total","Comisión 4%",1,"Zona","Agencia","N°","Total $","Promedio $","Total Comis $"]
[null,"Chávez González Elsa","Norte","Arica",4108792,3761993,{"$f":"SUM(E3:F3)","v":7870785},{"$f":"G3*4%","v":314831.40000000002},null,"Norte","Antofagasta",{"$f":"COUNTIFS(C3:C16,J3,D3:D16,K3)","v":2},{"$f":"SUMIFS(G3:G16,C3:C16,J3,D3:D16,K3)","v":22480991},{"$f":"AVERAGEIFS(G3:G16,C3:C16,J3,D3:D16,K3)","v":11240495.5},{"$f":"SUMIFS(H3:H16,C3:C16,J3,D3:D16,K3)","v":899239.64}]
[null,"Catalán Toro Armanda","Sur","Temuco",2826258,5452833,{"$f":"SUM(E4:F4)","v":8279091},{"$f":"G4*4%","v":331163.64}]
[null,"Contreras Márquez Laura","Norte","Iquique",7407818,3157745,10565563,422622.52,2,"Zona","ENTRE","N°","Total  $"]
[null,"Acevedo Navarro José","Norte","Antofagasta",4358000,8426000,12784000,511360,null,"Norte",null,{"$f":"COUNTIFS(C3:C16,J6,G3:G16,\">=\" & K8,G3:G16,\"<=\" & K9)","v":4},{"$f":"SUMIFS(G3:G16,C3:C16,J6,G3:G16,\">=\" &K8,G3:G16,\"<=\" & K9)","v":39162715}]
[null,"Calderón Galaz Jose","Sur","Temuco",1130677,5067890,6198567,247942.68]
[null,"Belmar Hormazábal Rodrigo","Norte","Iquique",6906087,3885627,10791714,431668.56,null,"Valor Uno >=",8000000]
[null,"Blanco Vera Washington","Centro","Santiago",1990275,1632192,3622467,144898.68,null,"Valor Dos <=",11000000]
[null,"Castro Córdova Silvia","Norte","Arica",2345876,5762571,8108447,324337.88]
[null,"Astudillo Pereira Verónica","Sur","Temuco",4297000,10052000,14349000,573960]
[null,"Alarcón Casanova Sergio","Centro","Santiago",5000000,4470000,9470000,378800]
[null,"Armijo Lizama Leonardo","Norte","Arica",8731335,2453000,11184335,447373.4]
[null,"Dinara Lopez","Centro","Santiago",5877136,4488758,10365894,414635.76]
[null,"Elisa Mota","Norte","Antofagasta",1544000,8152991,9696991,387879.64]
[null,"Alicia Perez","Sur","Valdivia",1557269,7749360,9306629,372265.16000000003]

{"sheet":"Funcion Logica SI","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,6,3,8]]}
[]
[1,"RUT","NOMBRE","PROMEDIO","ESTADO",null,null,null,null,null,null,null,true]
[null,"03.903.946-K","Castro Córdova Silvia",5.5,{"$f":"IF(D3>=4,\"APROBADO\",\"REPROBADO\")","v":"APROBADO"},null,"PRUEBA LOGICA"]
[null,"04.308.131-4","Calderón Galaz Jose",4,{"$f":"IF(D4>=4,\"APROBADO\",\"REPROBADO\")","v":"APROBADO"}]
[null,"05.334.664-2","Catalán Toro Armanda",3,"REPROBADO",null,null,null,null,null,null,null,false]
[null,"05.512.105-2","Acevedo Navarro José",2,"REPROBADO"]
[null,"05.660.775-7","Aranguiz Figueroa Carlos",5,"APROBADO"]
[]
[]
[null,null,null,null,null,"Sol. Por Defecto","Control dos valores"]
[2,"RUT","NOMBRE","SECTOR","RENTA","BONO SECTOR","BONO SECTOR II","TOTAL $",null,null,null,"SECTOR","%"]
[null,"03.903.946-K","Castro Córdova Silvia","SUR",560000,{"$f":"IF(D12=\"SUR\",E12*$M$12%,E12*$M$13%)","v":61600},{"$f":"IF(D12=\"SUR\",E12*$M$12%,IF(D12=\"CENTRO\",E12*$M$13%,0))","v":61600},{"$f":"G12+E12","v":621600},null,null,null,"SUR",11]
[null,"04.308.131-4","Calderón Galaz Jose","EEE",590000,{"$f":"IF(D13=\"SUR\",E13*$M$12%,E13*$M$13%)","v":50150},{"$f":"IF(D13=\"SUR\",E13*$M$12%,IF(D13=\"CENTRO\",E13*$M$13%,0))","v":0},{"$f":"G13+E13","v":590000},null,null,null,"CENTRO",8.5]
[null,"05.334.664-2","Catalán Toro Armanda","SUR",560000,61600,61600,621600]
[null,"05.512.105-2","Acevedo Navarro José","CENTRO",590000,50150,50150,640150]
[null,"05.660.775-7","Aranguiz Figueroa Carlos","SUR",560000,61600,61600,621600]

{"sheet":"SI Anidado","index":8,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Zona","ADIC. %"]
[null,null,null,null,null,null,null,null,null,null,"Norte",0.125]
[null,"Nombre Profesional","Zona","Enero","Febrero","Total $","Adicional $","Total Final $",null,null,"Sur",0.13400000000000001]
[null,"Chávez González Elsa","Norte",1800000,1761993,{"$f":"SUM(D4:E4)","v":3561993},{"$f":"_xlfn.IFS(C4=\"Norte\",F4*$L$2,C4=\"Sur\",F4*$L$3,C4=\"Centro\",F4*$L$4,TRUE,0)","v":445249.125},{"$f":"F4+G4","v":4007242.125},null,null,"Centro",0.11550000000000001]
[null,"Catalán Toro Armanda","Sur",1450000,1452833,{"$f":"SUM(D5:E5)","v":2902833},{"$f":"_xlfn.IFS(C5=\"Norte\",F5*$L$2,C5=\"Sur\",F5*$L$3,C5=\"Centro\",F5*$L$4,TRUE,0)","v":388979.62200000003},{"$f":"F5+G5","v":3291812.622}]
[null,"Contreras Márquez Laura","Norte",1407818,1157745,2565563,{"$f":"_xlfn.IFS(C6=\"Norte\",F6*$L$2,C6=\"Sur\",F6*$L$3,C6=\"Centro\",F6*$L$4,TRUE,0)","v":320695.375},2886258.375]
[null,"Acevedo Navarro José","Sur",1358328,1426105,2784433,{"$f":"_xlfn.IFS(C7=\"Norte\",F7*$L$2,C7=\"Sur\",F7*$L$3,C7=\"Centro\",F7*$L$4,TRUE,0)","v":373114.022},3157547.0219999999]
[null,"Calderón Galaz Jose","Sur",1130123,1067634,2197757,{"$f":"_xlfn.IFS(C8=\"Norte\",F8*$L$2,C8=\"Sur\",F8*$L$3,C8=\"Centro\",F8*$L$4,TRUE,0)","v":294499.43800000002},2492256.4380000001]
[null,"Belmar Hormazábal Rodrigo","Poniente",1497557,1052172,2549729,{"$f":"_xlfn.IFS(C9=\"Norte\",F9*$L$2,C9=\"Sur\",F9*$L$3,C9=\"Centro\",F9*$L$4,TRUE,0)","v":0},2549729]
[null,"Blanco Vera Washington","Centro",1195385,1470321,2665706,{"$f":"_xlfn.IFS(C10=\"Norte\",F10*$L$2,C10=\"Sur\",F10*$L$3,C10=\"Centro\",F10*$L$4,TRUE,0)","v":307889.04300000001},2973595.0430000001]
[null,"Castro Córdova Silvia","Norte",1731335,1124654,2855989,{"$f":"_xlfn.IFS(C11=\"Norte\",F11*$L$2,C11=\"Sur\",F11*$L$3,C11=\"Centro\",F11*$L$4,TRUE,0)","v":356998.625},3212987.625]
[null,"Astudillo Pereira Verónica","Sur",1877136,1488758,3365894,{"$f":"_xlfn.IFS(C12=\"Norte\",F12*$L$2,C12=\"Sur\",F12*$L$3,C12=\"Centro\",F12*$L$4,TRUE,0)","v":451029.79600000003},3816923.7960000001]
[null,"Alarcón Casanova Sergio","Centro",1544048,1152991,2697039,{"$f":"_xlfn.IFS(C13=\"Norte\",F13*$L$2,C13=\"Sur\",F13*$L$3,C13=\"Centro\",F13*$L$4,TRUE,0)","v":311508.00450000004},3008547.0044999998]
[null,"Armijo Lizama Leonardo","Norte",1557269,1749360,3306629,{"$f":"_xlfn.IFS(C14=\"Norte\",F14*$L$2,C14=\"Sur\",F14*$L$3,C14=\"Centro\",F14*$L$4,TRUE,0)","v":413328.625},3719957.625]
[null,"Dinara Lopez","Centro",1877136,2488758,4365894,{"$f":"_xlfn.IFS(C15=\"Norte\",F15*$L$2,C15=\"Sur\",F15*$L$3,C15=\"Centro\",F15*$L$4,TRUE,0)","v":504260.75700000004},4870154.7570000002]
[null,"Elisa Mota","Norte",1544048,1152991,2697039,{"$f":"_xlfn.IFS(C16=\"Norte\",F16*$L$2,C16=\"Sur\",F16*$L$3,C16=\"Centro\",F16*$L$4,TRUE,0)","v":337129.875},3034168.875]
[null,"Alicia Perez","Sur",1557269,1749360,3306629,{"$f":"_xlfn.IFS(C17=\"Norte\",F17*$L$2,C17=\"Sur\",F17*$L$3,C17=\"Centro\",F17*$L$4,TRUE,0)","v":443088.28600000002},3749717.2859999998]

{"sheet":"Si Anidaddo Ad. Nombre","index":9,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Ad. Nombre"]
[null,"Nombre Profesional","Zona","Enero","Febrero","Total $","Adicional $","Total Final $"]
[null,"Chávez González Elsa","Norte",1800000,1761993,{"$f":"SUM(D4:E4)","v":3561993},{"$f":"_xlfn.IFS(C4=\"Norte\",F4*Nor,C4=\"Centro\",F4*Cen,C4=\"Sur\",F4*Su,TRUE,0)","v":445249.125},{"$f":"F4+G4","v":4007242.125}]
[null,"Catalán Toro Armanda","Sur",1450000,1452833,{"$f":"SUM(D5:E5)","v":2902833},{"$f":"_xlfn.IFS(C5=\"Norte\",F5*Nor,C5=\"Centro\",F5*Cen,C5=\"Sur\",F5*Su,TRUE,0)","v":388979.62200000003},{"$f":"F5+G5","v":3291812.622}]
[null,"Contreras Márquez Laura","Norte",1407818,1157745,2565563,{"$f":"_xlfn.IFS(C6=\"Norte\",F6*Nor,C6=\"Centro\",F6*Cen,C6=\"Sur\",F6*Su,TRUE,0)","v":320695.375},2886258.375]
[null,"Acevedo Navarro José","Sur",1358328,1426105,2784433,{"$f":"_xlfn.IFS(C7=\"Norte\",F7*Nor,C7=\"Centro\",F7*Cen,C7=\"Sur\",F7*Su,TRUE,0)","v":373114.022},3157547.0219999999]
[null,"Calderón Galaz Jose","Sur",1130123,1067634,2197757,{"$f":"_xlfn.IFS(C8=\"Norte\",F8*Nor,C8=\"Centro\",F8*Cen,C8=\"Sur\",F8*Su,TRUE,0)","v":294499.43800000002},2492256.4380000001]
[null,"Belmar Hormazábal Rodrigo","Norte",1497557,1052172,2549729,{"$f":"_xlfn.IFS(C9=\"Norte\",F9*Nor,C9=\"Centro\",F9*Cen,C9=\"Sur\",F9*Su,TRUE,0)","v":318716.125},2868445.125]
[null,"Blanco Vera Washington","Centro",1195385,1470321,2665706,{"$f":"_xlfn.IFS(C10=\"Norte\",F10*Nor,C10=\"Centro\",F10*Cen,C10=\"Sur\",F10*Su,TRUE,0)","v":307889.04300000001},2973595.0430000001]
[null,"Castro Córdova Silvia","Norte",1731335,1124654,2855989,{"$f":"_xlfn.IFS(C11=\"Norte\",F11*Nor,C11=\"Centro\",F11*Cen,C11=\"Sur\",F11*Su,TRUE,0)","v":356998.625},3212987.625]
[null,"Astudillo Pereira Verónica","Sur",1877136,1488758,3365894,{"$f":"_xlfn.IFS(C12=\"Norte\",F12*Nor,C12=\"Centro\",F12*Cen,C12=\"Sur\",F12*Su,TRUE,0)","v":451029.79600000003},3816923.7960000001]
[null,"Alarcón Casanova Sergio","Centro",1544048,1152991,2697039,{"$f":"_xlfn.IFS(C13=\"Norte\",F13*Nor,C13=\"Centro\",F13*Cen,C13=\"Sur\",F13*Su,TRUE,0)","v":311508.00450000004},3008547.0044999998]
[null,"Armijo Lizama Leonardo","Norte",1557269,1749360,3306629,{"$f":"_xlfn.IFS(C14=\"Norte\",F14*Nor,C14=\"Centro\",F14*Cen,C14=\"Sur\",F14*Su,TRUE,0)","v":413328.625},3719957.625]
[null,"Dinara Lopez","Centro",1877136,2488758,4365894,{"$f":"_xlfn.IFS(C15=\"Norte\",F15*Nor,C15=\"Centro\",F15*Cen,C15=\"Sur\",F15*Su,TRUE,0)","v":504260.75700000004},4870154.7570000002]
[null,"Elisa Mota","Norte",1544048,1152991,2697039,{"$f":"_xlfn.IFS(C16=\"Norte\",F16*Nor,C16=\"Centro\",F16*Cen,C16=\"Sur\",F16*Su,TRUE,0)","v":337129.875},3034168.875]
[null,"Alicia Perez","Sur",1557269,1749360,3306629,{"$f":"_xlfn.IFS(C17=\"Norte\",F17*Nor,C17=\"Centro\",F17*Cen,C17=\"Sur\",F17*Su,TRUE,0)","v":443088.28600000002},3749717.2859999998]

{"sheet":"Parametros","index":10,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Zona","ADIC. %"]
[null,"Norte",0.125]
[null,"Sur",0.13400000000000001]
[null,"Centro",0.11550000000000001]

{"sheet":"Logica Option","index":11,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[4]
[null,"NOMBRE","TRANSACCION","MARGEN %","TOTAL"]
[null,"Castro Córdova Silvia",457000,{"$f":"_xlfn.IFS($A$1=1,C3*5%,$A$1=2,C3*7%,$A$1=3,C3*11%,$A$1=4,0,TRUE,0)","v":0},{"$f":"C3+D3","v":457000}]
[null,"Calderón Galaz Jose",582400,{"$f":"_xlfn.IFS($A$1=1,C4*5%,$A$1=2,C4*7%,$A$1=3,C4*11%,$A$1=4,0,TRUE,0)","v":0},{"$f":"C4+D4","v":582400}]
[null,"Chávez González Elsa",566000,{"$f":"_xlfn.IFS($A$1=1,C5*5%,$A$1=2,C5*7%,$A$1=3,C5*11%,$A$1=4,0,TRUE,0)","v":0},566000]
[null,"Aranguiz Figueroa Emilio",550000,{"$f":"_xlfn.IFS($A$1=1,C6*5%,$A$1=2,C6*7%,$A$1=3,C6*11%,$A$1=4,0,TRUE,0)","v":0},550000]
[null,"Armijo Lizama Leonardo",556000,{"$f":"_xlfn.IFS($A$1=1,C7*5%,$A$1=2,C7*7%,$A$1=3,C7*11%,$A$1=4,0,TRUE,0)","v":0},556000]
[null,"Azócar Riffo Herminda",640000,{"$f":"_xlfn.IFS($A$1=1,C8*5%,$A$1=2,C8*7%,$A$1=3,C8*11%,$A$1=4,0,TRUE,0)","v":0},640000]
[null,"Blanco Vera Washington",528000,{"$f":"_xlfn.IFS($A$1=1,C9*5%,$A$1=2,C9*7%,$A$1=3,C9*11%,$A$1=4,0,TRUE,0)","v":0},528000]
[null,"Contreras Márquez Laura",457000,{"$f":"_xlfn.IFS($A$1=1,C10*5%,$A$1=2,C10*7%,$A$1=3,C10*11%,$A$1=4,0,TRUE,0)","v":0},457000]
[null,"Belmar Hormazábal Rodrigo",528000,{"$f":"_xlfn.IFS($A$1=1,C11*5%,$A$1=2,C11*7%,$A$1=3,C11*11%,$A$1=4,0,TRUE,0)","v":0},528000]
[null,"Bacián Lavín Carlos",641000,{"$f":"_xlfn.IFS($A$1=1,C12*5%,$A$1=2,C12*7%,$A$1=3,C12*11%,$A$1=4,0,TRUE,0)","v":0},641000]
[null,"Aguilera Cabrera Ivan",510000,{"$f":"_xlfn.IFS($A$1=1,C13*5%,$A$1=2,C13*7%,$A$1=3,C13*11%,$A$1=4,0,TRUE,0)","v":0},510000]
[null,"Castro Vásquez Bernardo",700000,{"$f":"_xlfn.IFS($A$1=1,C14*5%,$A$1=2,C14*7%,$A$1=3,C14*11%,$A$1=4,0,TRUE,0)","v":0},700000]
[null,"Astudillo Pereira Verónica",557000,{"$f":"_xlfn.IFS($A$1=1,C15*5%,$A$1=2,C15*7%,$A$1=3,C15*11%,$A$1=4,0,TRUE,0)","v":0},557000]
[null,"Alvarez Torres Erick",574000,{"$f":"_xlfn.IFS($A$1=1,C16*5%,$A$1=2,C16*7%,$A$1=3,C16*11%,$A$1=4,0,TRUE,0)","v":0},574000]

{"sheet":"Check","index":12,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Bono de 50.000",null,null,"Valores Lógicos"]
[null,"APLICA","RUT","NOMBRE","CARGO","RENTA","BONO GENERAL","TOTAL $"]
[null,null,"03.903.946-K","Castro Córdova Silvia","VENDEDOR",457000,{"$f":"IF(J4,50000,0)","v":50000},{"$f":"F4+G4","v":507000},null,true]
[null,null,"04.308.131-4","Calderón Galaz Jose","SECRETARIA",582400,{"$f":"IF(J5,50000,0)","v":50000},{"$f":"F5+G5","v":632400},null,true]
[null,null,"06.565.470-9","Bacián Lavín Carlos","ADMINISTRATIVO",641000,0,641000,null,false]
[null,null,"06.633.876-2","Astudillo Pereira Verónica","VENDEDOR",557000,0,557000,null,false]
[null,null,"06.843.720-2","Alvarez Torres Erick","ADMINISTRATIVO",574000,50000,624000,null,true]

{"sheet":"Check 2","index":13,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[true]
[null,null,null,null,67000]
[]
[null,null,"RUT","NOMBRE","CARGO","RENTA","BONO GENERAL","TOTAL $"]
[null,null,"03.903.946-K","Castro Córdova Silvia","VENDEDOR",457000,{"$f":"IF($A$1,$E$2,0)","v":67000},{"$f":"F5+G5","v":524000}]
[null,null,"04.308.131-4","Calderón Galaz Jose","SECRETARIA",582400,{"$f":"IF($A$1,$E$2,0)","v":67000},{"$f":"F6+G6","v":649400}]
[null,null,"05.057.894-1","Chávez González Elsa","SECRETARIA",566000,67000,633000]
[null,null,"06.388.776-5","Contreras Márquez Laura","ADMINISTRATIVO",457000,67000,524000]
[null,null,"06.434.788-8","Belmar Hormazábal Rodrigo","SECRETARIA",528000,67000,595000]
[null,null,"06.565.470-9","Bacián Lavín Carlos","ADMINISTRATIVO",641000,67000,708000]
[null,null,"06.597.566-1","Aguilera Cabrera Ivan","ADMINISTRATIVO",510000,67000,577000]
[null,null,"06.633.613-1","Castro Vásquez Bernardo","VENDEDOR",700000,67000,767000]
[null,null,"06.633.876-2","Astudillo Pereira Verónica","VENDEDOR",557000,67000,624000]
[null,null,"06.843.720-2","Alvarez Torres Erick","ADMINISTRATIVO",574000,67000,641000]

{"sheet":"Formato Y","index":14,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
[]
[null,"Estado Civil","Edad",null,"Si es casado y mayor 40 años == > 40.000"]
[null,"Casado",55]
[null,null,null,null,{"$f":"AND(B3=\"Casado\",C3>=40)","v":true}]
[null,null,null,null,{"$f":"IF(AND(B3=\"Casado\",C3>=40),40000,0)","v":40000}]

{"sheet":"Funcion Logica Y","index":15,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,9,1,10]]}
[]
[null,"Vendedor","Zona","Agencia","Enero","Febrero","Total","Comisión",null,"Bono Comisión"]
[null,"Chávez González Elsa","Norte","Arica",4108792,3761993,{"$f":"SUM(E3:F3)","v":7870785},null,null,"Zona","Total Ventas Mayor a"]
[null,"Catalán Toro Armanda","Sur","Temuco",2826258,5452833,8279091,null,null,"Norte",7000000,3.5000000000000003E-2]
[null,"Contreras Márquez Laura","Norte","Iquique",7407818,3157745,10565563,null,null,"Sur",10000000,3.6499999999999998E-2]
[null,"Acevedo Navarro José","Norte","Antofagasta",4358000,8426000,12784000]
[null,"Calderón Galaz Jose","Sur","Temuco",1130677,5067890,6198567]
[null,"Belmar Hormazábal Rodrigo","Norte","Iquique",6906087,3885627,10791714]
[null,"Blanco Vera Washington","Centro","Santiago",1990275,1632192,3622467]
[null,"Castro Córdova Silvia","Norte","Arica",2345876,5762571,8108447]
[null,"Astudillo Pereira Verónica","Sur","Temuco",4297000,10052000,14349000]
[null,"Alarcón Casanova Sergio","Centro","Santigo",5000000,4470000,9470000]
[null,"Armijo Lizama Leonardo","Norte","Arica",8731335,2453000,11184335]
[null,"Dinara Lopez","Centro","Santiago",5877136,4488758,10365894]
[null,"Elisa Mota","Norte","Antofagasta",1544000,8152991,9696991]
[null,"Alicia Perez","Sur","Valdivia",1557269,7749360,9306629]

{"sheet":"Ejercicio Y Check","index":16,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,9,1,10]]}
[]
[null,"Vendedor","Zona","Enero","Febrero","Total","Comisión Norte","Comisión Sur",null,"Bono Comisión"]
[null,"Chávez González Elsa","Norte",4108000,3761993,{"$f":"SUM(D3:E3)","v":7869993},null,null,null,"Zona","Ventas Mayor = a"]
[null,"Catalán Toro Armanda","Sur",2826258,5452833,8279091,null,null,null,null,7000000,3.5000000000000003E-2]
[null,"Contreras Márquez Laura","Norte",7407818,3157745,10565563,null,null,null,null,8000000,3.6499999999999998E-2]
[null,"Acevedo Navarro José","Norte",4358000,8426000,12784000]
[null,"Calderón Galaz Jose","Sur",1130677,5067890,6198567]
[null,"Belmar Hormazábal Rodrigo","Norte",6906087,3885627,10791714]
[null,"Blanco Vera Washington","Centro",1990275,1632192,3622467]
[null,"Castro Córdova Silvia","Norte",2345876,5762571,8108447]
[null,"Astudillo Pereira Verónica","Sur",4297000,10052000,14349000]
[null,"Alarcón Casanova Sergio","Centro",5000000,4470000,9470000]
[null,"Armijo Lizama Leonardo","Norte",8731335,2453000,11184335]
[null,"Dinara Lopez","Centro",5877136,4488758,10365894]
[null,"Elisa Mota","Norte",1544000,8152991,9696991]
[null,"Alicia Perez","Sur",1557269,7749360,9306629]

{"sheet":"Funcion Logica O","index":17,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ID empleado","Nombre","Zona","Venta","Comisión",null,"Comisiones"]
[null,1968,"Jeronimo Burgos","Norte",3200000,null,null,"Zona","%","Adicional"]
[null,1674,"Estefania Villegas","Sur",3200000,null,null,"Norte o Sur",9.5000000000000001E-2,0.02]
[null,1516,"Guillermo Fernandez","Norte",4500000]
[null,1330,"Eliana Ramirez","Sur",3200000]
[null,1949,"Paula Palacio","Sur",4100000]
[null,1329,"Julieth Osorio","Sur",3500000]
[null,1572,"Lina Villamizar","Oriente",3600000]
[null,1300,"Carlos Gomez","Norte",2300000]
[null,1303,"Dinara Lopez","Poniente",5600000]
[null,1302,"Elisa Mota","Norte",3800000]
[null,1334,"Alicia Perez","Poniente",1350000]
[null,1975,"Carlos Posada","Oriente",3200000]
[null,1759,"Mauricio Arango","Norte",4700000]
[null,1427,"David Jaramillo","Norte",3400000]

{"sheet":"Funcion Logica Y O","index":18,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,9,1,10]]}
[]
[null,"Vendedor","Zona","Agencia","Enero","Febrero","Total","Comisión",null,"Bono Comisión"]
[null,"Chávez González Elsa","Norte","Arica",4108792,3761993,{"$f":"SUM(E3:F3)","v":7870785},null,null,"Zona","Agencia"]
[null,"Catalán Toro Armanda","Sur","Temuco",2826258,5452833,8279091,null,null,"Norte","Arica o Iquique",3.5000000000000003E-2]
[null,"Contreras Márquez Laura","Norte","Iquique",7407818,3157745,10565563,null,null,"Sur","Temuco",3.6499999999999998E-2]
[null,"Acevedo Navarro José","Norte","Antofagasta",4358000,8426000,12784000]
[null,"Calderón Galaz Jose","Sur","Temuco",1130677,5067890,6198567]
[null,"Belmar Hormazábal Rodrigo","Norte","Iquique",6906087,3885627,10791714]
[null,"Blanco Vera Washington","Centro","Santiago",1990275,1632192,3622467]
[null,"Castro Córdova Silvia","Norte","Arica",2345876,5762571,8108447]
[null,"Astudillo Pereira Verónica","Sur","Temuco",4297000,10052000,14349000]
[null,"Alarcón Casanova Sergio","Centro","Santiago",5000000,4470000,9470000]
[null,"Armijo Lizama Leonardo","Norte","Arica",8731335,2453000,11184335]
[null,"Dinara Lopez","Centro","Santiago",5877136,4488758,10365894]
[null,"Elisa Mota","Norte","Antofagasta",1544000,8152991,9696991]
[null,"Alicia Perez","Sur","Valdivia",1557269,7749360,9306629]