{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Resumen","FlujodeCaja","Indicadores"],"not_rendered":{"charts":4,"images":10,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Resumen","index":0,"n_rows":63,"n_cols":1,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,1,1],[19,0,20,1]]}
["Menú"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ingresos"]
["Egresos"]

{"sheet":"FlujodeCaja","index":1,"n_rows":49,"n_cols":19,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,0,1,1],[7,3,9,3]]}
["  Menú"]
[]
[]
[]
[]
[]
[null,null,null,"Ahorro prom (%)","Totales","Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic","Total","Promedio"]
[null,null,null,{"$f":"S10/S9","v":0.37745098039215685},"Ingresos",{"$f":"SUMIF($D$15:$D$59,\"Ingreso\",F15:F59)","v":760000},840000,755000,765000,750000,740000,764000,745000,800000,750000,760000,{"$f":"SUMIF($D$15:$D$59,\"Ingreso\",Q15:Q59)","v":844000},{"$f":"SUM(F8:Q8)","v":9273000},{"$f":"IF(R8=0,0,R8/COUNT(F8:Q8))","v":772750}]
[null,null,null,null,"Gastos",{"$f":"SUMIF($D15:$D60,\"Egreso\",F15:F60)","v":465000},{"$f":"SUMIF($D15:$D60,\"Egreso\",G15:G60)","v":446000},628000,603000,603000,596000,583000,550000,587000,564000,540000,567000,{"$f":"SUM(F9:Q9)","v":6732000},{"$f":"IF(R9=0,0,R9/COUNT(F9:Q9))","v":561000}]
[null,null,null,null,"Ahorro",{"$f":"F8-F9","v":295000},{"$f":"G8-G9","v":394000},127000,162000,147000,144000,181000,195000,213000,186000,220000,277000,{"$f":"R8-R9","v":2541000},{"$f":"IF(R10=0,0,R10/COUNT(F10:Q10))","v":211750}]
[null,null,null,"Mensual","Acumulado",{"$f":"F10","v":295000},{"$f":"G10+F11","v":689000},{"$f":"H10+G11","v":816000},{"$f":"I10+H11","v":978000},{"$f":"J10+I11","v":1125000},{"$f":"K10+J11","v":1269000},{"$f":"L10+K11","v":1450000},1645000,1858000,2044000,2264000,2541000,{"$f":"SUM(F10:Q10)","v":2541000},211750]
[]
[]
[null,null,null,"Tipo","Concepto","Ene","Feb","Mar","Abr","May","Jun","Jul","Ago","Sep","Oct","Nov","Dic","Total","Promedio"]
[null,null,null,"Ingreso","Sueldo",600000,600000,600000,600000,600000,600000,600000,600000,600000,600000,600000,600000,{"$f":"SUM(F15:Q15)","v":7200000},{"$f":"IF(R15=0,0,R15/COUNT(F15:Q15))","v":600000}]
[null,null,null,"Ingreso","Bono",null,100000,null,null,null,null,null,null,60000,null,null,60000,{"$f":"SUM(F16:Q16)","v":220000},{"$f":"IF(R16=0,0,R16/COUNT(F16:Q16))","v":73333.333333333328}]
[null,null,null,"Ingreso","Gratificación",null,null,null,null,null,null,4000,null,null,null,null,4000,8000,{"$f":"IF(R17=0,0,R17/COUNT(F17:Q17))","v":4000}]
[null,null,null,"Ingreso","Arriendos",130000,130000,130000,130000,130000,130000,130000,130000,130000,130000,130000,130000,{"$f":"SUM(F18:Q18)","v":1560000},{"$f":"IF(R18=0,0,R18/COUNT(F18:Q18))","v":130000}]
[null,null,null,"Ingreso","Negocio",30000,10000,25000,35000,20000,10000,30000,15000,10000,20000,30000,50000,285000,{"$f":"IF(R19=0,0,R19/COUNT(F19:Q19))","v":23750}]
[null,null,null,"Egreso","Arriendo",200000,200000,200000,200000,200000,200000,200000,200000,200000,200000,200000,200000,{"$f":"SUM(F20:Q20)","v":2400000},{"$f":"IF(R20=0,0,R20/COUNT(F20:Q20))","v":200000}]
[null,null,null,"Egreso","Préstamo",50000,50000,50000,50000,50000,50000,null,null,null,null,null,null,{"$f":"SUM(F21:Q21)","v":300000},{"$f":"IF(R21=0,0,R21/COUNT(F21:Q21))","v":50000}]
[null,null,null,"Egreso","Alimentos",90000,80000,100000,95000,90000,100000,110000,95000,125000,105000,100000,130000,1220000,101666.66666666667]
[null,null,null,"Egreso","Colegio Hijos",null,null,100000,60000,60000,60000,60000,60000,60000,60000,60000,60000,640000,64000]
[null,null,null,"Egreso","Movilidad Hijos",null,null,80000,80000,80000,80000,80000,80000,80000,80000,80000,80000,800000,80000]
[null,null,null,"Egreso","Agua",25000,23000,18000,17000,18000,19000,18000,19000,20000,19000,20000,22000,238000,19833.333333333332]
[null,null,null,"Egreso","Luz",35000,36000,35000,35000,37000,38000,45000,46000,40000,35000,34000,30000,446000,37166.666666666664]
[null,null,null,"Egreso","Gas",25000,22000,25000,26000,28000,29000,30000,30000,27000,25000,26000,25000,318000,26500]
[null,null,null,"Egreso","Tel/Int/Cel",20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,240000,20000]
[null,null,null,"Egreso","Comida Mascota",20000,null,null,20000,null,null,20000,null,null,20000,null,null,80000,20000]
[null,null,null,"Egreso","Salidas",null,15000,null,null,20000,null,null,null,15000,null,null,null,50000,16666.666666666668]
[null,null,null,"Egreso","Crédito hipotecario",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,"Egreso","Linea de credito",null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[null,null,"Tipo","Egreso"]
[]
[null,null,"Etiquetas de fila",".","Suma de Total2"]
[null,null,"Arriendo",1,2400000]
[null,null,"Alimentos",2,1220000]
[null,null,"Movilidad Hijos",3,800000]
[null,null,"Total general",null,4420000]

{"sheet":"Indicadores","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,1,1]]}
["Menú"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"INGRESO",null,null,null,null,"EGRESO"]
[null,null,null,"Sueldo",null,null,null,null,"Tel/Int/Cel"]
[null,null,null,"Bono",null,null,null,null,"Agua"]
[null,null,null,"Gratificación",null,null,null,null,"Préstamo"]
[null,null,null,"Arriendos",null,null,null,null,"Colegio Hijos"]
[null,null,null,"Negocio",null,null,null,null,"Comida Mascota"]
[null,null,null,null,null,null,null,null,"Luz"]
[null,null,null,null,null,null,null,null,"Gas"]
[null,null,null,null,null,null,null,null,"Pasajes"]
[null,null,null,"TIPO",null,null,null,null,"Alimentos"]
[null,null,null,"Ingreso",null,null,null,null,"Salidas"]
[null,null,null,"Egreso",null,null,null,null,"Movilidad Hijos"]
[null,null,null,null,null,null,null,null,"Arriendo"]
[null,null,null,null,null,null,null,null,"Crédito hipotecario"]
[null,null,null,null,null,null,null,null,"Linea de credito"]