{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["DATOS","CALCULADORA"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":0,"defined_names":2,"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":"DATOS","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,1,1,2],[11,1,11,3],[17,1,17,4],[24,1,24,4],[1,4,1,5]]}
[]
[null,"DATOS",null,null,"COMPETENCIA"]
[null,false,false,5]
[null,"IMPORTE",{"$f":"CALCULADORA!F7","v":10000},null,"EMPRESA",{"$f":"CALCULADORA!F10","v":"Mercado Pago"}]
[null,{"$f":"IF(B3=TRUE,\"Importe anual\",\"Importe a cobrar\")","v":"Importe a cobrar"},{"$f":"IF(B3=TRUE,C4*12,C4)","v":10000},null,{"$f":"B5","v":"Importe a cobrar"},{"$f":"C5","v":10000}]
[null,"Monto a recibir",{"$f":"IF(C3=TRUE,C5-D16,C5-D16-F20)","v":9663.6},null,"Tasa de Comision",{"$f":"INDEX(Tabla3[[#All],[COMISION]],MATCH(F4,Tabla3[[#All],[EMPRESA]],0),1)","v":3.5000000000000003E-2}]
[null,"Meses sin intereses",{"$f":"IF(D3=5,\"Contado\",INDEX(Tabla2[PLAZO],MATCH(D3,Tabla2[numero de meses],0),1))","v":"Contado"},null,"Descuento",{"$f":"+F5*F6","v":350.00000000000006}]
[null,"Sobretasa",{"$f":"IF(D3=5,\"No aplica\",INDEX(Tabla2[SOBRETASA],MATCH(D3,Tabla2[numero de meses],0)))","v":"No aplica"},null,"IVA de comision",{"$f":"+F7*0.16","v":56.000000000000007}]
[null,"Importe sobretasa",{"$f":"IF(D3=5,\"NA\",$F$20)","v":"NA"},null,"Importe a recibir",{"$f":"+F5-F7-F8","v":9594}]
[null,"Descuento total",{"$f":"IF(D3=5,D16,D16+F20)","v":336.4},null,"Total de comision",{"$f":"+F7+F8","v":406.00000000000006}]
[null,null,null,null,{"$f":"+C5-D16","v":9663.6},{"$f":"+E11-F9","v":69.600000000000364}]
[null,"COMISION GETNET",null,null,null,{"$f":"((C5-D16)-F9)*12","v":835.20000000000437}]
[null,"GESTION","TASA","DESCUENTO",null,"en comisiones cada año"]
[null,"Comision ",2.9000000000000001E-2,{"$f":"+C14*C5","v":290}]
[null,"IVA",0.16,{"$f":"D14*C15","v":46.4}]
[null,null,"Total de comision",{"$f":"SUM(DATOS!$D$14:$D$15)","v":336.4}]
[]
[null,"SOBRETASA"]
[null,"PLAZO","SOBRETASA","DESCUENTO","TRASLADO","MONTO SOBRETASA","numero de meses"]
[null,"3 meses",3.5499999999999997E-2,{"$f":"$C$4*Tabla2[[#This Row],[SOBRETASA]]*1.16","v":411.7999999999999},{"$f":"(DATOS!$C$14+Tabla2[[#This Row],[SOBRETASA]])+0.01","v":7.4499999999999997E-2},{"$f":"IF(DATOS!D3=1,Tabla2[[#This Row],[DESCUENTO]],IF(DATOS!D3=2,D21,IF(DATOS!D3=3,D22,IF(DATOS!D3=4,D23,0))))","v":0},1]
[null,"6 meses",6.4000000000000001E-2,{"$f":"$C$4*Tabla2[[#This Row],[SOBRETASA]]*1.16","v":742.4},{"$f":"(DATOS!$C$14+Tabla2[[#This Row],[SOBRETASA]])+0.01","v":0.10299999999999999},{"$f":"IF(DATOS!C4=1,Tabla2[[#This Row],[DESCUENTO]],IF(DATOS!C4=2,D22,IF(DATOS!C4=3,D23,IF(DATOS!C4=4,D24,0))))","v":0},2]
[null,"9 meses",9.3299999999999994E-2,{"$f":"$C$4*Tabla2[[#This Row],[SOBRETASA]]*1.16","v":1082.2799999999997},{"$f":"(DATOS!$C$14+Tabla2[[#This Row],[SOBRETASA]])+0.01","v":0.1323},{"$f":"IF(DATOS!C5=1,Tabla2[[#This Row],[DESCUENTO]],IF(DATOS!C5=2,D23,IF(DATOS!C5=3,D24,IF(DATOS!C5=4,D25,0))))","v":0},3]
[null,"12 meses",0.1321,{"$f":"$C$4*Tabla2[[#This Row],[SOBRETASA]]*1.16","v":1532.36},{"$f":"(DATOS!$C$14+Tabla2[[#This Row],[SOBRETASA]])+0.01","v":0.1711},{"$f":"IF(DATOS!C7=1,Tabla2[[#This Row],[DESCUENTO]],IF(DATOS!C7=2,D24,IF(DATOS!C7=3,D25,IF(DATOS!C7=4,D26,0))))","v":0},4]
[]
[null,"LOGOS"]
[null,"EMPRESA","COMISION","LOGO","TASA"]
[null,"Clip",3.5999999999999997E-2,null,3.5999999999999997E-2]
[null,"Mercado Pago",3.5000000000000003E-2,null,3.5000000000000003E-2]

{"sheet":"CALCULADORA","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,5,9,6],[8,5,8,6],[6,5,6,6],[5,5,5,6],[13,5,16,12]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"IMPORTE MENSUAL"]
[null,null,null,null,null,10000]
[]
[null,null,null,null,null,"Comparado con:"]
[null,null,null,null,null,"Mercado Pago"]