{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cuenta de crédito","Instrucciones"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Cuenta de crédito","index":0,"n_rows":18,"n_cols":14,"rows_kept":18,"merged":[[1,1,1,2],[1,4,1,12],[2,4,2,5],[2,8,2,11],[3,4,3,5],[3,8,3,11],[4,4,4,5],[4,8,4,11],[5,4,5,5],[5,8,5,11],[6,4,6,5],[6,8,6,11],[7,4,7,5],[7,8,7,11],[8,4,8,5],[8,8,8,11],[9,4,9,5],[9,8,9,11],[13,2,13,3],[13,4,13,5],[13,6,13,7],[13,8,13,10],[13,11,13,13]]}
[]
[null,"Introducción de condiciones",null,null,"Resultado de la liquidación"]
[null,"Limite del crédito",{"v":5000,"d":"5,000 €"},null,"Intereses Deudores",null,{"$f":"-G8*C8*100/F12","v":{"v":0,"d":"0.00 €"}},null,"Sdo Medio Acreedor",{"$nulls":3},{"$f":"IF(M9<>0,+G10*100/M9,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Comisión saldo no dispuesto",{"v":0.01,"d":"1.00%"},null,"Intereses Excedidos",null,{"$f":"-G9*C10*100/F12","v":{"v":0,"d":"0.00 €"}},null,"Sdo. Medio Deudor",{"$nulls":3},{"$f":"IF(M9<>0,+G8*100/M9,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Comisión de estudio",{"v":0.01,"d":"1.00%"},null,"Intereses Acreedores",null,{"$f":"G10*C9*100/F12","v":{"v":0,"d":"0.00 €"}},null,"Sdo. Medio Excedido",{"$nulls":3},{"$f":"IF(M9<>0,+G9*100/M9,0)","v":{"v":0,"d":"0.00 €"}}]
[null,"Comisión de apertura",{"v":0.01,"d":"1.00%"},null,"Retención 21%",null,{"$f":"-G5*0.21","v":{"v":0,"d":"0.00 €"}},null,"Sdo. antes Liquidación",{"$nulls":3},{"$f":"SUM(F16:F200)-SUM(E16:E200)","v":{"v":-150,"d":"-150.00 €"}}]
[null,"Gastos de corretaje",{"v":50,"d":"50 €"},null,"Comisión S/ no Dispuesto",null,{"$f":"IF(D12-C12<90,-M10*C4*(D12-C12)/90,-M10*C4)","v":{"v":0,"d":"0.00 €"}},null,"Total gastos Liquidación",{"$nulls":3},{"$f":"G3+G4+G5+G7","v":{"v":0,"d":"0.00 €"}}]
[null,"Tipo de interés deudor",{"v":0.07,"d":"7.00%"},null,"Números Deudores",null,{"$f":"SUM('Cuenta de crédito'!L16:L133)","v":{"v":0,"d":"0.00"}},null,"Sdo. a Cuenta Nueva",{"$nulls":3},{"$f":"M6+M7+G6","v":{"v":-150,"d":"-150.00 €"}}]
[null,"Tipo de interés acreedor",{"v":1E-3,"d":"0.10%"},null,"Números Excedidos",null,{"$f":"SUM(M16:M200)","v":{"v":0,"d":"0.00"}},null,"Días periodo liquidación",{"$nulls":3},{"$f":"SUM(I16:I244)+SUM(K16:K244)","v":0}]
[null,"Tipo de interés s/ excedido",{"v":0.09,"d":"9.00%"},null,"Números Acreedores",null,{"$f":"SUM(N16:N200)","v":{"v":0,"d":"0.00"}},null,"S. Medio no Dispuesto",{"$nulls":3},{"$f":"IF(M9<>0,C3-M4,0)","v":{"v":0,"d":"0.00 €"}}]
[null,null,"Fecha inicio","Fecha cierre",null,"Base"]
[null,"PERIODO DE LIQUIDACION","2014-01-01","2014-03-31",null,366]
[]
[null,null,"FECHAS",null,"MOVIMIENTOS",null,"SALDO",null,"DIAS",null,null,"NUMEROS COMERCIALES"]
[null,"CONCEPTO","Operación","Valor","Debe","Haber","CAPITALES","D/H","D","E","A","Deudores","Excedidos","Acreedores"]
[null,"Comisión de estudio",{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"2014-01-01"},{"$f":"$C$16","v":"2014-01-01"},{"$f":"$C$3*C5","v":{"v":50,"d":"50.00 €"}},null,{"$f":"IF(AND(E16=\"\",F16<>\"\"),F16,-E16)","v":{"v":-50,"d":"-50.00 €"}},{"$f":"IF(G16=\"\",\"\",IF(G16>=0,\"H\",\"D\"))","v":"D"},{"$f":"IF(D17<>\"\",IF(AND(D17-D16<>0,H16=\"D\"),D17-D16,\"\"),\"\")","v":""},{"$f":"IF(D17<>\"\",IF(AND(AND(D17-D16<>0,ABS(G16)>$C$3),H16=\"D\"),D17-D16,\"\"),\"\")","v":""},{"$f":"IF(D17<>\"\",IF(AND(D17-D16<>0,H16=\"H\"),D17-D16,\"\"),\"\")","v":""},{"$f":"IF(I16<>\"\",IF(AND(H16=\"D\",ABS(G16)<$C$3),ABS(G16)*I16/100,$C$3*I16/100),\"\")","v":""},{"$f":"IF(J16<>\"\",(ABS(G16)-$C$3)*J16/100,\"\")","v":""},{"$f":"IF(K16<>\"\",G16*K16/100,\"\")","v":""}]
[null,"Comisión de apertura",{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"2014-01-01"},{"$f":"$C$16","v":"2014-01-01"},{"$f":"$C$3*C6","v":{"v":50,"d":"50.00 €"}},null,{"$f":"IF(AND(E17=\"\",F17=\"\"),\"\",+G16-E17+F17)","v":{"v":-100,"d":"-100.00 €"}},{"$f":"IF(G17=\"\",\"\",IF(G17>=0,\"H\",\"D\"))","v":"D"},{"$f":"IF(D18<>\"\",IF(AND(D18-D17<>0,H17=\"D\"),D18-D17,\"\"),\"\")","v":""},{"$f":"IF(D18<>\"\",IF(AND(AND(D18-D17<>0,ABS(G17)>$C$3),H17=\"D\"),D18-D17,\"\"),\"\")","v":""},{"$f":"IF(D18<>\"\",IF(AND(D18-D17<>0,H17=\"H\"),D18-D17,\"\"),\"\")","v":""},{"$f":"IF(I17<>\"\",IF(AND(H17=\"D\",ABS(G17)<$C$3),ABS(G17)*I17/100,$C$3*I17/100),\"\")","v":""},{"$f":"IF(J17<>\"\",(ABS(G17)-$C$3)*J17/100,\"\")","v":""},{"$f":"IF(K17<>\"\",G17*K17/100,\"\")","v":""}]
[null,"Corretaje",{"$f":"IF($C$12=\"\",\"\",$C$12)","v":"2014-01-01"},{"$f":"$C$16","v":"2014-01-01"},{"$f":"C7","v":{"v":50,"d":"50.00 €"}},null,{"$f":"IF(AND(E18=\"\",F18=\"\"),\"\",+G17-E18+F18)","v":{"v":-150,"d":"-150.00 €"}},{"$f":"IF(G18=\"\",\"\",IF(G18>=0,\"H\",\"D\"))","v":"D"},{"$f":"IF(D19<>\"\",IF(AND(D19-D18<>0,H18=\"D\"),D19-D18,\"\"),\"\")","v":""},{"$f":"IF(D19<>\"\",IF(AND(AND(D19-D18<>0,ABS(G18)>$C$3),H18=\"D\"),D19-D18,\"\"),\"\")","v":""},{"$f":"IF(D19<>\"\",IF(AND(D19-D18<>0,H18=\"H\"),D19-D18,\"\"),\"\")","v":""},{"$f":"IF(I18<>\"\",IF(AND(H18=\"D\",ABS(G18)<$C$3),ABS(G18)*I18/100,$C$3*I18/100),\"\")","v":""},{"$f":"IF(J18<>\"\",(ABS(G18)-$C$3)*J18/100,\"\")","v":""},{"$f":"IF(K18<>\"\",G18*K18/100,\"\")","v":""}]

{"sheet":"Instrucciones","index":1,"n_rows":0,"n_cols":0,"rows_kept":0}