{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sin pagos a cta","Con pagos a cta","Guia pagos varios"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"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":"Sin pagos a cta","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DATOS"]
["DEUDA"]
["TASA %",1.2]
["F. DE VENCIMTO.","2015-05-15"]
["F. DE PAGO","2015-07-13"]
["IMPORTE",2000]
[]
["ACTUALIZACIÓN DE DEUDA"]
["IMPORTE",{"$f":"B6","v":2000}]
["INTERESES",{"$f":"IF(AND(B4>0,B5>0),B9*((B5-(B4+1))*(B3/30))%,0)","v":46.4}]
["IMPORTE ACTUALIZADO",{"$f":"SUM(B9:B10)","v":2046.4}]

{"sheet":"Con pagos a cta","index":1,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DATOS",null,null,"ACTUALIZACIÓN DE DEUDA",null,null,null,{"$f":"IF(AND(G7>0,H7>0,I7=0),1,0)","v":0},0,{"$f":"IF(AND(I7>0,J7>0,K7=0),1,0)","v":1},{"$f":"IF(AND(J7>0,K7>0,L7=0),1,0)","v":0},0,0,0,0,0,0]
["DEUDA",null,null,"IMPORTE",{"$f":"HLOOKUP(1,PAGOSACUENTA,7,0)","v":146},null,"FV",{"$f":"B4","v":"2015-05-15"},{"$f":"IF(H3>0,H3,\"\")","v":"2015-06-15"},{"$f":"IF(I3>0,I3,\"\")","v":"2015-07-08"},{"$f":"IF(J3>0,J3,\"\")","v":"2015-07-13"},"2015-07-13","2015-07-13","2015-07-13","2015-07-13","2015-07-13","2015-07-13"]
["TASA %",1.2,null,"INTERESES",{"$f":"HLOOKUP(1,PAGOSACUENTA,8,0)","v":0},null,"FP",{"$f":"IF(AND(B10>0,A10>0),B10,B5)","v":"2015-06-15"},{"$f":"IF(AND(B11>0,A11>0),B11,B5)","v":"2015-07-08"},{"$f":"IF(AND(B12>0,A12>0),B12,B5)","v":"2015-07-13"},{"$f":"IF(AND(B13>0,A13>0),B13,B5)","v":"2015-07-13"},{"$f":"IF(AND(B14>0,A14>0),B14,B5)","v":"2015-07-13"},{"$f":"IF(AND(B15>0,A15>0),B15,B5)","v":"2015-07-13"},{"$f":"IF(AND(B16>0,A16>0),B16,B5)","v":"2015-07-13"},{"$f":"IF(AND(B17>0,A17>0),B17,B5)","v":"2015-07-13"},{"$f":"IF(AND(B18>0,A18>0),B18,B5)","v":"2015-07-13"},{"$f":"IF(AND(B19>0,A19>0),B19,B5)","v":"2015-07-13"}]
["F. DE VENCIMTO.","2015-05-15",null,"IMPORTE ACTUALIZADO",{"$f":"HLOOKUP(1,PAGOSACUENTA,11,0)","v":146},null,"DIAS",{"$f":"IF(AND(H2>0,H3>0,H3>H2),H3-(H2+1),0)","v":30},{"$f":"IF(AND(I2>0,I3>0,I3>I2),I3-(I2+1),0)","v":22},4,0,0,0,0,0,0,0]
["F. DE PAGO","2015-07-13",null,null,null,null,"INTERES",{"$f":"($B$3/30)*H4","v":1.2},0.88,0.16,0,0,0,0,0,0,0]
["IMPORTE",635]
[null,null,null,null,null,null,"DEUDA",{"$f":"B6","v":635},{"$f":"IF(AND(H11>0,I4>0),H11,0)","v":293},{"$f":"IF(AND(I11>0,J4>0),I11,0)","v":146},0,0,0,0,0,0,0]
["PAGOS A CUENTA",null,null,null,null,null,"INTERES",{"$f":"ROUND(H7*H5%,0)","v":8},{"$f":"ROUND(I7*I5%,0)","v":3},0,0,0,0,0,0,0,0]
["IMPORTE","F. DE PAGO",null,null,null,null,"DEUDA ACTUALIZADA",{"$f":"SUM(H7:H8)","v":643},{"$f":"SUM(I7:I8)","v":296},146,0,0,0,0,0,0,0]
[350,"2015-06-15",null,null,null,null,"PAGO PARCIAL",{"$f":"A10*-1","v":-350},{"$f":"A11*-1","v":-150},{"$f":"A12*-1","v":0},{"$f":"A13*-1","v":0},{"$f":"A14*-1","v":0},{"$f":"A15*-1","v":0},{"$f":"A16*-1","v":0},{"$f":"A17*-1","v":0},{"$f":"A18*-1","v":0},{"$f":"A19*-1","v":0}]
[150,"2015-07-08",null,null,null,null,"TOTAL DEUDA",{"$f":"SUM(H9:H10)","v":293},{"$f":"SUM(I9:I10)","v":146},146,0,0,0,0,0,0,0]

{"sheet":"Guia pagos varios","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[[17,7,17,9],[28,5,28,7],[28,12,28,13],[20,6,21,8],[15,6,15,10],[23,6,24,9],[18,7,18,9]]}
[]
[]
[]
[]
[]
[]
[null,null,"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,20123456789]
[]
[null,null,null,null,null,null,"Mes","Año"]
[null,null,null,null,null,null,12,2012]
[]
[null,null,null,null,null,null,1011]
[]
[]
[null,null,null,null,null,null,1200]
[]
[]
[]
[]
[null,null,null,null,null,1011,null,null,null,null,null,null,1234567890192920]