{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["FRA. DTO. COMERCIAL","CONDICIONES BANCARIAS","TIMBRES","ASIENTOS CONTABLES"],"not_rendered":{"macros":1,"defined_names":20,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"FRA. DTO. COMERCIAL","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"merged":[[3,9,3,11]]}
[]
[]
[]
[{"$nulls":8},"BANCO","BCO4 (SABADELL)"]
[]
[{"$nulls":4},"FECHA ACTUAL",{"$nulls":3},"COSTE EFECTIVO EN % ANUAL",null,null,{"$f":"IF(D10=0,\"\",((1+L7)^(360/F10))-1)","v":{"v":0.19457152917805498,"d":"19.46%"}}]
[null,"FECHA DE NEGOCIACIÓN",null,"2014-01-15",{"$f":"TODAY()","v":"2014-08-15"},{"$nulls":3},"TAE VTO MEDIO",null,null,{"$f":"IF(D10=\"\",\"\",(D10/E10)-1)","v":{"v":0.06297685092320515,"d":"6.30%"}}]
[]
[null,"EFECTOS",null," TOTAL NEGOCIADO","EFECTIVO NEGOCIACIÓN","VENCIMIENTO MEDIO","T.A.E."," INTERESES","TIPO MEDIO DE COMISION","COMISION EFECTO","CORREO","TIMBRES","TOTAL GASTOS"]
[null,{"$f":"COUNT(B14:B28)","v":3},null,{"$f":"SUM(D14:D28)","v":{"v":6000,"d":"6,000.00 €"}},{"$f":"D10-H10-J10-L10-K10","v":{"v":5644.525555555556,"d":"5,644.53 €"}},{"$f":"IF(D10=0,\"\",SUMPRODUCT(D14:D28,F14:F28)/D10)","v":{"v":123.66666666666667,"d":"123.67 días"}},{"$f":"(M10/F10*360)/E10","v":{"v":0.18332883826701254,"d":"18.33%"}},{"$f":"SUM(H14:H28)","v":{"v":82.44444444444444,"d":"82.44 €"}},{"$f":"IF(D10=0,\"\",J10/D10)","v":{"v":0.04,"d":"4.000%"}},{"$f":"SUM(J14:J28)","v":{"v":240,"d":"240.00 €"}},{"$f":"SUM(K14:K28)","v":{"v":12,"d":"12.00 €"}},{"$f":"SUM(L14:L28)","v":{"v":21.03,"d":"21.03 €"}},{"$f":"H10+J10+L10+K10","v":{"v":355.47444444444443,"d":"355.47 €"}}]
[]
[]
[null,"Nº","TIPO DE EFECTO","NOMINAL","VENCIMIENTO","DÍAS","TIPO INTERÉS","INTERESES","T.Comisión","COMISIÓN","CORREO","TIMBRE","TOTAL"]
[null,{"$f":"IF(COUNTA(C14:E14)=0,\"\",MAX(B$13:B13)+1)","v":1},"d",{"v":1000,"d":"1,000.00 €"},"2014-02-28",{"$f":"IF(E14=\"\",\"\",E14-$D$7)","v":44},{"$f":"IF(E14=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F14)),F14),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":{"v":0.04,"d":"4.00%"}},{"$f":"IF(G14=\"\",\"\",(D14*G14*F14)/360)","v":{"v":4.888888888888889,"d":"4.89 €"}},{"$f":"IF(E14=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C14),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":{"v":0.04,"d":"4.000%"}},{"$f":"IF(I14=\"\",\"\",MAX(D14*I14,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":{"v":40,"d":"40.00 €"}},{"$f":"IF(E14=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":{"v":4,"d":"4.00 €"}},{"$f":"IF(E14=\"\",\"\",VLOOKUP(D14,TIMBRES,2))","v":{"v":4.21,"d":"4.21 €"}},{"$f":"IF(E14=\"\",\"\",SUM(H14,J14,K14,L14))","v":{"v":53.09888888888889,"d":"53.10 €"}}]
[null,2,"dna",{"v":2000,"d":"2,000.00 €"},"2014-04-28",103,{"$f":"IF(E15=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F15)),F15),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":{"v":0.04,"d":"4.00%"}},{"$f":"IF(G15=\"\",\"\",(D15*G15*F15)/360)","v":{"v":22.88888888888889,"d":"22.89 €"}},{"$f":"IF(E15=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C15),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":{"v":0.04,"d":"4.000%"}},{"$f":"IF(I15=\"\",\"\",MAX(D15*I15,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":{"v":80,"d":"80.00 €"}},{"$f":"IF(E15=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":{"v":4,"d":"4.00 €"}},{"v":8.41,"d":"8.41 €"},{"$f":"IF(E15=\"\",\"\",SUM(H15,J15,K15,L15))","v":{"v":115.29888888888888,"d":"115.30 €"}}]
[null,3,"nd",{"v":3000,"d":"3,000.00 €"},"2014-06-28",164,{"$f":"IF(E16=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F16)),F16),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":{"v":0.04,"d":"4.00%"}},{"v":54.666666666666664,"d":"54.67 €"},{"$f":"IF(E16=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C16),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":{"v":0.04,"d":"4.000%"}},{"$f":"IF(I16=\"\",\"\",MAX(D16*I16,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":{"v":120,"d":"120.00 €"}},{"$f":"IF(E16=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":{"v":4,"d":"4.00 €"}},{"v":8.41,"d":"8.41 €"},{"v":187.07666666666665,"d":"187.08 €"}]
[null,{"$f":"IF(COUNTA(C17:E17)=0,\"\",MAX(B$13:B16)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E17=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F17)),F17),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E17=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C17),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I17=\"\",\"\",MAX(D17*I17,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E17=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C18:E18)=0,\"\",MAX(B$13:B17)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E18=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F18)),F18),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E18=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C18),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I18=\"\",\"\",MAX(D18*I18,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E18=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C19:E19)=0,\"\",MAX(B$13:B18)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E19=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F19)),F19),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E19=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C19),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I19=\"\",\"\",MAX(D19*I19,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E19=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C20:E20)=0,\"\",MAX(B$13:B19)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E20=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F20)),F20),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E20=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C20),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I20=\"\",\"\",MAX(D20*I20,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E20=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C21:E21)=0,\"\",MAX(B$13:B20)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E21=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F21)),F21),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E21=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C21),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I21=\"\",\"\",MAX(D21*I21,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E21=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C22:E22)=0,\"\",MAX(B$13:B21)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E22=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F22)),F22),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E22=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C22),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I22=\"\",\"\",MAX(D22*I22,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E22=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C23:E23)=0,\"\",MAX(B$13:B22)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E23=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F23)),F23),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E23=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C23),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I23=\"\",\"\",MAX(D23*I23,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E23=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C24:E24)=0,\"\",MAX(B$13:B23)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E24=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F24)),F24),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E24=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C24),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I24=\"\",\"\",MAX(D24*I24,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E24=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C25:E25)=0,\"\",MAX(B$13:B24)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E25=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F25)),F25),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E25=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C25),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I25=\"\",\"\",MAX(D25*I25,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E25=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C26:E26)=0,\"\",MAX(B$13:B25)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E26=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F26)),F26),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E26=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C26),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I26=\"\",\"\",MAX(D26*I26,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E26=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C27:E27)=0,\"\",MAX(B$13:B26)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E27=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F27)),F27),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E27=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C27),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I27=\"\",\"\",MAX(D27*I27,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E27=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]
[null,{"$f":"IF(COUNTA(C28:E28)=0,\"\",MAX(B$13:B27)+1)","v":""},{"$nulls":3},"",{"$f":"IF(E28=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",REPT(\"0\",3-LEN(F28)),F28),'CONDICIONES BANCARIAS'!$B$63:$E$112,4,1))","v":""},"",{"$f":"IF(E28=\"\",\"\",VLOOKUP(CONCATENATE($J$4,\"-\",C28),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0))","v":""},{"$f":"IF(I28=\"\",\"\",MAX(D28*I28,VLOOKUP(CONCATENATE($J$4,\"-\",\"Mínimo\"),'CONDICIONES BANCARIAS'!$B$19:$E$58,4,0)))","v":""},{"$f":"IF(E28=\"\",\"\",VLOOKUP($J$4,'CONDICIONES BANCARIAS'!$B$117:$D$126,3,0))","v":""},"",""]

{"sheet":"CONDICIONES BANCARIAS","index":1,"n_rows":126,"n_cols":7,"rows_kept":126}
[]
[null,"CONDICIONES BANCARIAS"]
[]
[null,"ENTIDADES BANCARIAS"]
[null,null,"ENTIDAD"]
[null,null,"BCO1 (CAIXA POPULAR)"]
[null,null,"BCO2 (POPULAR)"]
[null,null,"BCO3 (BANKINTER)"]
[null,null,"BCO4 (SABADELL)"]
[null,null,"BCO5 (SANTANDER)"]
[null,null,"BCO6 (BBVA)"]
[null,null,"BCO7 (IBERCAJA)"]
[null,null,"BCO8 (MARCH)"]
[null,null,"BCO9 (CAIXABANK)"]
[]
[]
[null,"COMISIONES"]
[null,"CLAVE","ENTIDAD","CODIGO","PORCENTAJE"]
[null,{"$f":"IF(C19=\"\",\"Z\",CONCATENATE(C19,\"-\",D19))","v":"BCO1 (CAIXA POPULAR)-d"},"BCO1 (CAIXA POPULAR)","d",{"v":0.01,"d":"1.00%"},null,"d=domiciliado"]
[null,{"$f":"IF(C20=\"\",\"Z\",CONCATENATE(C20,\"-\",D20))","v":"BCO1 (CAIXA POPULAR)-dna"},"BCO1 (CAIXA POPULAR)","dna",{"v":0.01,"d":"1.00%"},null,"dna=domiciliado no aceptado"]
[null,"BCO1 (CAIXA POPULAR)-nd","BCO1 (CAIXA POPULAR)","nd",{"v":0.01,"d":"1.000%"},null,"nd=no domiciliado"]
[null,"BCO1 (CAIXA POPULAR)-Mínimo","BCO1 (CAIXA POPULAR)","Mínimo",{"v":1,"d":"1.00"}]
[null,"BCO2 (POPULAR)-d","BCO2 (POPULAR)","d",{"v":0.02,"d":"2.000%"}]
[null,"BCO2 (POPULAR)-dna","BCO2 (POPULAR)","dna",{"v":0.02,"d":"2.00%"}]
[null,"BCO2 (POPULAR)-nd","BCO2 (POPULAR)","nd",{"v":0.02,"d":"2.000%"}]
[null,"BCO2 (POPULAR)-Mínimo","BCO2 (POPULAR)","Mínimo",{"v":2,"d":"2.00"}]
[null,"BCO3 (BANKINTER)-d","BCO3 (BANKINTER)","d",{"v":0.03,"d":"3.000%"}]
[null,"BCO3 (BANKINTER)-dna","BCO3 (BANKINTER)","dna",{"v":0.03,"d":"3.000%"}]
[null,"BCO3 (BANKINTER)-nd","BCO3 (BANKINTER)","nd",{"v":0.03,"d":"3.000%"}]
[null,"BCO3 (BANKINTER)-Mínimo","BCO3 (BANKINTER)","Mínimo",{"v":3,"d":"3.00"}]
[null,"BCO4 (SABADELL)-d","BCO4 (SABADELL)","d",{"v":0.04,"d":"4.000%"}]
[null,"BCO4 (SABADELL)-dna","BCO4 (SABADELL)","dna",{"v":0.04,"d":"4.000%"}]
[null,"BCO4 (SABADELL)-nd","BCO4 (SABADELL)","nd",{"v":0.04,"d":"4.000%"}]
[null,"BCO4 (SABADELL)-Mínimo","BCO4 (SABADELL)","Mínimo",{"v":4,"d":"4.00"}]
[null,"BCO5 (SANTANDER)-d","BCO5 (SANTANDER)","d",{"v":0.05,"d":"5.000%"}]
[null,"BCO5 (SANTANDER)-dna","BCO5 (SANTANDER)","dna",{"v":0.05,"d":"5.000%"}]
[null,"BCO5 (SANTANDER)-nd","BCO5 (SANTANDER)","nd",{"v":0.05,"d":"5.000%"}]
[null,"BCO5 (SANTANDER)-Mínimo","BCO5 (SANTANDER)","Mínimo",{"v":5,"d":"5.00"}]
[null,"BCO6 (BBVA)-d","BCO6 (BBVA)","d",{"v":0.06,"d":"6.000%"}]
[null,"BCO6 (BBVA)-dna","BCO6 (BBVA)","dna",{"v":0.06,"d":"6.000%"}]
[null,"BCO6 (BBVA)-nd","BCO6 (BBVA)","nd",{"v":0.06,"d":"6.000%"}]
[null,"BCO6 (BBVA)-Mínimo","BCO6 (BBVA)","Mínimo",{"v":6,"d":"6.00"}]
[null,"BCO7 (IBERCAJA)-d","BCO7 (IBERCAJA)","d",{"v":0.07,"d":"7.000%"}]
[null,"BCO7 (IBERCAJA)-dna","BCO7 (IBERCAJA)","dna",{"v":0.07,"d":"7.000%"}]
[null,"BCO7 (IBERCAJA)-nd","BCO7 (IBERCAJA)","nd",{"v":0.07,"d":"7.000%"}]
[null,"BCO7 (IBERCAJA)-Mínimo","BCO7 (IBERCAJA)","Mínimo",{"v":7,"d":"7.00"}]
[null,"BCO8 (MARCH)-d","BCO8 (MARCH)","d",{"v":0.08,"d":"8.000%"}]
[null,"BCO8 (MARCH)-dna","BCO8 (MARCH)","dna",{"v":0.08,"d":"8.000%"}]
[null,"BCO8 (MARCH)-nd","BCO8 (MARCH)","nd",{"v":0.08,"d":"8.000%"}]
[null,"BCO8 (MARCH)-Mínimo","BCO8 (MARCH)","Mínimo",{"v":8,"d":"8.00"}]
[null,"BCO9 (CAIXABANK)-d","BCO9 (CAIXABANK)","d",{"v":0.09,"d":"9.000%"}]
[null,"BCO9 (CAIXABANK)-dna","BCO9 (CAIXABANK)","dna",{"v":0.09,"d":"9.000%"}]
[null,"BCO9 (CAIXABANK)-nd","BCO9 (CAIXABANK)","nd",{"v":0.09,"d":"9.000%"}]
[null,"BCO9 (CAIXABANK)-Mínimo","BCO9 (CAIXABANK)","Mínimo",{"v":9,"d":"9.00"}]
[null,"Z"]
[null,"Z"]
[null,"Z"]
[null,"Z"]
[]
[]
[null,"TIPO DE DESCUENTO"]
[null,"CLAVE","ENTIDAD","DÍAS","TIPO"]
[null,{"$f":"IF(C63=\"\",\"Z\",CONCATENATE(C63,\"-\",REPT(\"0\",3-LEN(D63)),D63))","v":"BCO1 (CAIXA POPULAR)-000"},"BCO1 (CAIXA POPULAR)",0,{"v":0.01,"d":"1.00%"}]
[null,"BCO1 (CAIXA POPULAR)-061","BCO1 (CAIXA POPULAR)",61,{"v":0.01,"d":"1.00%"}]
[null,"BCO1 (CAIXA POPULAR)-091","BCO1 (CAIXA POPULAR)",91,{"v":0.01,"d":"1.00%"}]
[null,"BCO1 (CAIXA POPULAR)-121","BCO1 (CAIXA POPULAR)",121,{"v":0.01,"d":"1.00%"}]
[null,"BCO1 (CAIXA POPULAR)-151","BCO1 (CAIXA POPULAR)",151,{"v":0.01,"d":"1.00%"}]
[null,"BCO2 (POPULAR)-000","BCO2 (POPULAR)",0,{"v":0.02,"d":"2.00%"}]
[null,"BCO2 (POPULAR)-061","BCO2 (POPULAR)",61,{"v":0.02,"d":"2.00%"}]
[null,"BCO2 (POPULAR)-091","BCO2 (POPULAR)",91,{"v":0.02,"d":"2.00%"}]
[null,"BCO2 (POPULAR)-121","BCO2 (POPULAR)",121,{"v":0.02,"d":"2.00%"}]
[null,"BCO2 (POPULAR)-151","BCO2 (POPULAR)",151,{"v":0.02,"d":"2.00%"}]
[null,"BCO3 (BANKINTER)-000","BCO3 (BANKINTER)","0",{"v":0.03,"d":"3.00%"}]
[null,"BCO3 (BANKINTER)-061","BCO3 (BANKINTER)","61",{"v":0.03,"d":"3.00%"}]
[null,"BCO3 (BANKINTER)-091","BCO3 (BANKINTER)","91",{"v":0.03,"d":"3.00%"}]
[null,"BCO3 (BANKINTER)-121","BCO3 (BANKINTER)","121",{"v":0.03,"d":"3.00%"}]
[null,"BCO3 (BANKINTER)-151","BCO3 (BANKINTER)","151",{"v":0.03,"d":"3.00%"}]
[null,{"$f":"IF(C78=\"\",\"Z\",CONCATENATE(C78,\"-\",REPT(\"0\",3-LEN(D78)),D78))","v":"BCO4 (SABADELL)-000"},"BCO4 (SABADELL)","0",{"v":0.04,"d":"4.00%"}]
[null,"BCO4 (SABADELL)-061","BCO4 (SABADELL)","61",{"v":0.04,"d":"4.00%"}]
[null,"BCO4 (SABADELL)-091","BCO4 (SABADELL)","91",{"v":0.04,"d":"4.00%"}]
[null,"BCO4 (SABADELL)-121","BCO4 (SABADELL)","121",{"v":0.04,"d":"4.00%"}]
[null,"BCO4 (SABADELL)-151","BCO4 (SABADELL)","151",{"v":0.04,"d":"4.00%"}]
[null,"BCO5 (SANTANDER)-000","BCO5 (SANTANDER)","0",{"v":0.05,"d":"5.00%"}]
[null,"BCO5 (SANTANDER)-061","BCO5 (SANTANDER)","61",{"v":0.05,"d":"5.00%"}]
[null,"BCO5 (SANTANDER)-091","BCO5 (SANTANDER)","91",{"v":0.05,"d":"5.00%"}]
[null,"BCO5 (SANTANDER)-121","BCO5 (SANTANDER)","121",{"v":0.05,"d":"5.00%"}]
[null,"BCO5 (SANTANDER)-151","BCO5 (SANTANDER)","151",{"v":0.05,"d":"5.00%"}]
[null,"BCO6 (BBVA)-000","BCO6 (BBVA)","0",{"v":0.06,"d":"6.00%"}]
[null,"BCO6 (BBVA)-061","BCO6 (BBVA)","61",{"v":0.06,"d":"6.00%"}]
[null,"BCO6 (BBVA)-091","BCO6 (BBVA)","91",{"v":0.06,"d":"6.00%"}]
[null,"BCO6 (BBVA)-121","BCO6 (BBVA)","121",{"v":0.06,"d":"6.00%"}]
[null,"BCO6 (BBVA)-151","BCO6 (BBVA)","151",{"v":0.06,"d":"6.00%"}]
[null,"BCO7 (IBERCAJA)-000","BCO7 (IBERCAJA)","0",{"v":0.07,"d":"7.00%"}]
[null,"BCO7 (IBERCAJA)-061","BCO7 (IBERCAJA)","61",{"v":0.07,"d":"7.00%"}]
[null,"BCO7 (IBERCAJA)-091","BCO7 (IBERCAJA)","91",{"v":0.07,"d":"7.00%"}]
[null,"BCO7 (IBERCAJA)-121","BCO7 (IBERCAJA)","121",{"v":0.07,"d":"7.00%"}]
[null,"BCO7 (IBERCAJA)-151","BCO7 (IBERCAJA)","151",{"v":0.07,"d":"7.00%"}]
[null,"BCO8 (MARCH)-000","BCO8 (MARCH)","0",{"v":0.08,"d":"8.00%"}]
[null,"BCO8 (MARCH)-061","BCO8 (MARCH)","61",{"v":0.08,"d":"8.00%"}]
[null,"BCO8 (MARCH)-091","BCO8 (MARCH)","91",{"v":0.08,"d":"8.00%"}]
[null,"BCO8 (MARCH)-121","BCO8 (MARCH)","121",{"v":0.08,"d":"8.00%"}]
[null,"BCO8 (MARCH)-151","BCO8 (MARCH)","151",{"v":0.08,"d":"8.00%"}]
[null,{"$f":"IF(C103=\"\",\"Z\",CONCATENATE(C103,\"-\",REPT(\"0\",3-LEN(D103)),D103))","v":"BCO9 (CAIXABANK)-000"},"BCO9 (CAIXABANK)","0",{"v":0.09,"d":"9.00%"}]
[null,{"$f":"IF(C104=\"\",\"Z\",CONCATENATE(C104,\"-\",REPT(\"0\",3-LEN(D104)),D104))","v":"BCO9 (CAIXABANK)-061"},"BCO9 (CAIXABANK)","61",{"v":0.09,"d":"9.00%"}]
[null,{"$f":"IF(C105=\"\",\"Z\",CONCATENATE(C105,\"-\",REPT(\"0\",3-LEN(D105)),D105))","v":"BCO9 (CAIXABANK)-091"},"BCO9 (CAIXABANK)","91",{"v":0.09,"d":"9.00%"}]
[null,{"$f":"IF(C106=\"\",\"Z\",CONCATENATE(C106,\"-\",REPT(\"0\",3-LEN(D106)),D106))","v":"BCO9 (CAIXABANK)-121"},"BCO9 (CAIXABANK)","121",{"v":0.09,"d":"9.00%"}]
[null,{"$f":"IF(C107=\"\",\"Z\",CONCATENATE(C107,\"-\",REPT(\"0\",3-LEN(D107)),D107))","v":"BCO9 (CAIXABANK)-151"},"BCO9 (CAIXABANK)","151",{"v":0.09,"d":"9.00%"}]
[null,"Z"]
[null,"Z"]
[null,"Z"]
[null,"Z"]
[null,"Z"]
[]
[]
[null,"CORREO"]
[null,"CLAVE","ENTIDAD","   CORREO"]
[null,{"$f":"IF(C117=\"\",\"Z\",CONCATENATE(C117))","v":"BCO1 (CAIXA POPULAR)"},"BCO1 (CAIXA POPULAR)",{"v":1,"d":"1.00 €"}]
[null,{"$f":"IF(C118=\"\",\"Z\",CONCATENATE(C118))","v":"BCO2 (POPULAR)"},"BCO2 (POPULAR)",{"v":2,"d":"2.00 €"}]
[null,"BCO3 (BANKINTER)","BCO3 (BANKINTER)",{"v":3,"d":"3.00 €"}]
[null,"BCO4 (SABADELL)","BCO4 (SABADELL)",{"v":4,"d":"4.00 €"}]
[null,"BCO5 (SANTANDER)","BCO5 (SANTANDER)",{"v":5,"d":"5.00 €"}]
[null,"BCO6 (BBVA)","BCO6 (BBVA)",{"v":6,"d":"6.00 €"}]
[null,"BCO7 (IBERCAJA)","BCO7 (IBERCAJA)",{"v":7,"d":"7.00 €"}]
[null,"BCO8 (MARCH)","BCO8 (MARCH)",{"v":8,"d":"8.00 €"}]
[null,"BCO9 (CAIXABANK)","BCO9 (CAIXABANK)",{"v":9,"d":"9.00 €"}]
[null,"Z"]

{"sheet":"TIMBRES","index":2,"n_rows":20,"n_cols":3,"rows_kept":20}
[]
[null,"TIMBRES"]
[]
[null,"ESCALA DEL TIMBRE DEL IAJD"]
[null,"NOMINAL","TIMBRE"]
[null,0,{"v":0.06,"d":"0.06 €"}]
[null,{"v":24.05,"d":"24.05 €"},{"v":0.12,"d":"0.12 €"}]
[null,{"v":48.09,"d":"48.09 €"},{"v":0.24,"d":"0.24 €"}]
[null,{"v":90.16,"d":"90.16 €"},{"v":0.48,"d":"0.48 €"}]
[null,{"v":180.31,"d":"180.31 €"},{"v":0.96,"d":"0.96 €"}]
[null,{"v":360.62,"d":"360.62 €"},{"v":1.98,"d":"1.98 €"}]
[null,{"v":751.28,"d":"751.28 €"},{"v":4.21,"d":"4.21 €"}]
[null,{"v":1502.54,"d":"1,502.54 €"},{"v":8.41,"d":"8.41 €"}]
[null,{"v":3005.07,"d":"3,005.07 €"},{"v":16.83,"d":"16.83 €"}]
[null,{"v":6010.13,"d":"6,010.13 €"},{"v":33.66,"d":"33.66 €"}]
[null,{"v":12020.25,"d":"12,020.25 €"},{"v":67.31,"d":"67.31 €"}]
[null,{"v":24040.49,"d":"24,040.49 €"},{"v":134.63,"d":"134.63 €"}]
[null,{"v":48080.98,"d":"48,080.98 €"},{"v":269.25,"d":"269.25 €"}]
[null,{"v":96161.95,"d":"96,161.95 €"},{"v":538.51,"d":"538.51 €"}]
[null,{"v":192323.88,"d":"192,323.88 €"},"EXCESO*"]

{"sheet":"ASIENTOS CONTABLES","index":3,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,1,0,7],[1,1,1,7],[7,1,7,7]]}
[null,"ASIENTOS CONTABLES DE LA NEGOCIACIÓN"]
[null,"ASIENTO DE RECLASIFICACIÓN DE LOS EFECTOS"]
[null,"Nº","Fecha","Código","Cuenta","Concepto","Debe","Haber"]
[null,1,{"$f":"FN","v":"2014-01-15"},4311,"Efectos comerciales descontados","Reclasificación efectos",{"$f":"TOTAL_NEGOCIADO","v":{"v":6000,"d":"6,000.00 "}}]
[null,1,{"$f":"FN","v":"2014-01-15"},4310,"Efectos comerciales en cartera","Reclasificación efectos",null,{"$f":"G4","v":{"v":6000,"d":"6,000.00 "}}]
[]
[]
[null,"ASIENTO DE CONTABILIZACIÓN DE LA NEGOCIACIÓN"]
[null,"Nº","Fecha","Código","Cuenta","Concepto","Debe","Haber"]
[null,2,{"$f":"$C$4","v":"2014-01-15"},572,"Bancos c/c","Descuento n/remesa nº",{"$f":"'FRA. DTO. COMERCIAL'!E10","v":{"v":5644.525555555556,"d":"5,644.53 "}}]
[null,2,{"$f":"$C$4","v":"2014-01-15"},665,"Intereses por descuento de efectos","Descuento n/remesa nº",{"$f":"'FRA. DTO. COMERCIAL'!H10","v":{"v":82.44444444444444,"d":"82.44 "}}]
[null,2,"2014-01-15",626,"Servicios bancarios","Descuento n/remesa nº",{"$f":"'FRA. DTO. COMERCIAL'!J10+'FRA. DTO. COMERCIAL'!K10","v":{"v":252,"d":"252.00 "}}]
[null,2,"2014-01-15",631,"Otros tributos","Descuento n/remesa nº",{"$f":"'FRA. DTO. COMERCIAL'!L10","v":{"v":21.03,"d":"21.03 "}}]
[null,2,"2014-01-15",5208,"Deudas por efectos descontados","Descuento n/remesa nº",null,{"$f":"SUM(G10:G13)","v":{"v":6000,"d":"6,000.00 "}}]