{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Seguimiento de capital personal","Resumen mensual","Datos del gráfico"],"not_rendered":{"charts":3,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Seguimiento de capital personal","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[19,1,20,1],[21,1,23,1]]}
[null,"Seguimiento de capital personal"]
[]
[{"$nulls":3},"Resumen de efectivo"]
[{"$nulls":3},"Cuenta","Efectivo de inicio","Total de gastos","Efectivo restante"]
[{"$nulls":3},"Facturación",{"v":3000,"d":"3000.00"},{"$f":"SUMIF(Efectivo_gastado[Cuenta],\"=\" &Tabla_de_resumen_de_efectivo[[#This Row],[Cuenta]],Efectivo_gastado[Importe])","v":{"v":428,"d":"428.00"}},{"$f":"Tabla_de_resumen_de_efectivo[[#This Row],[Efectivo de inicio]]-Tabla_de_resumen_de_efectivo[[#This Row],[Total de gastos]]","v":{"v":2572,"d":"2572.00"}}]
[{"$nulls":3},"Ahorros",{"v":500,"d":"500.00"},{"$f":"SUMIF(Efectivo_gastado[Cuenta],\"=\" &Tabla_de_resumen_de_efectivo[[#This Row],[Cuenta]],Efectivo_gastado[Importe])","v":{"v":450,"d":"450.00"}},{"$f":"Tabla_de_resumen_de_efectivo[[#This Row],[Efectivo de inicio]]-Tabla_de_resumen_de_efectivo[[#This Row],[Total de gastos]]","v":{"v":50,"d":"50.00"}}]
[{"$nulls":3},"Otros",{"v":200,"d":"200.00"},{"$f":"SUMIF(Efectivo_gastado[Cuenta],\"=\" &Tabla_de_resumen_de_efectivo[[#This Row],[Cuenta]],Efectivo_gastado[Importe])","v":{"v":30,"d":"30.00"}},{"$f":"Tabla_de_resumen_de_efectivo[[#This Row],[Efectivo de inicio]]-Tabla_de_resumen_de_efectivo[[#This Row],[Total de gastos]]","v":{"v":170,"d":"170.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Tabla_de_resumen_de_efectivo[Efectivo de inicio])","v":{"v":3700,"d":"3700.00"}},{"$f":"SUBTOTAL(109,Tabla_de_resumen_de_efectivo[Total de gastos])","v":{"v":908,"d":"908.00"}},{"$f":"SUBTOTAL(109,Tabla_de_resumen_de_efectivo[Efectivo restante])","v":{"v":2792,"d":"2792.00"}}]
[]
[{"$nulls":3},"Efectivo que he gastado"]
[{"$nulls":3},"Fecha","Descripción","Importe","Cuenta"]
[{"$nulls":3},"2012-01-04","Retirada ATM",{"v":40,"d":"40.00"},"Facturación"]
[{"$nulls":3},"2012-01-05","Almuerzo",{"v":5,"d":"5.00"},"Facturación"]
[{"$nulls":3},"2012-01-06","Pago del coche",{"v":230,"d":"230.00"},"Ahorros"]
[{"$nulls":3},"2012-02-03","Pago de electricidad",{"v":70,"d":"70.00"},"Facturación"]
[{"$nulls":3},"2012-02-07","Cena",{"v":53,"d":"53.00"},"Facturación"]
[{"$nulls":3},"2012-03-01","Retirada de efectivo",{"v":100,"d":"100.00"},"Ahorros"]
[{"$nulls":3},"2012-03-06","Pago del coche",{"v":230,"d":"230.00"},"Facturación"]
[{"$nulls":3},"2012-04-06","Pago de electricidad",{"v":70,"d":"70.00"},"Ahorros"]
[null,"Efectivo restante:",null,"2012-04-20","Retirada ATM",{"v":30,"d":"30.00"},"Facturación"]
[{"$nulls":3},"2012-05-03","Retirada ATM",{"v":50,"d":"50.00"},"Ahorros"]
[null,{"$f":"Tabla_de_resumen_de_efectivo[[#Totals],[Efectivo restante]]/Tabla_de_resumen_de_efectivo[[#Totals],[Efectivo de inicio]]","v":{"v":0.7545945945945945,"d":"75%"}},null,"2012-05-10","Retirada ATM",{"v":30,"d":"30.00"},"Otros"]

{"sheet":"Resumen mensual","index":1,"n_rows":26,"n_cols":6,"rows_kept":26}
[null,"Resumen mensual"]
[null,"Resumen de cuenta"]
{"$rows_empty":13}
[null,"Resumen de gastos"]
[null,"Detalles"]
[null,null,"Ahorros","Facturación","Otros","Total general"]
[null,"ene",{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},null,{"v":275,"d":"275.00"}]
[null,"feb",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"mar",{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},null,{"v":330,"d":"330.00"}]
[null,"Pago del coche",null,{"v":230,"d":"230.00"},null,{"v":230,"d":"230.00"}]
[null,"Retirada de efectivo",{"v":100,"d":"100.00"},null,null,{"v":100,"d":"100.00"}]
[null,"abr",{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},null,{"v":100,"d":"100.00"}]
[null,"may",{"v":50,"d":"50.00"},null,{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Total general",{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]

{"sheet":"Datos del gráfico","index":2,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"Otros datos de la tabla dinámica"]
[null,"Esta tabla dinámica es el origen de datos de la tabla dinámica de Resumen de cuenta de la hoja Resumen mensual"]
[null,"Suma de Importe","Etiquetas de columna"]
[null,"Etiquetas de fila","Ahorros","Facturación","Otros","Total general"]
[null,"ene",{"v":230,"d":"230.00"},{"v":45,"d":"45.00"},null,{"v":275,"d":"275.00"}]
[null,"feb",null,{"v":123,"d":"123.00"},null,{"v":123,"d":"123.00"}]
[null,"mar",{"v":100,"d":"100.00"},{"v":230,"d":"230.00"},null,{"v":330,"d":"330.00"}]
[null,"abr",{"v":70,"d":"70.00"},{"v":30,"d":"30.00"},null,{"v":100,"d":"100.00"}]
[null,"may",{"v":50,"d":"50.00"},null,{"v":30,"d":"30.00"},{"v":80,"d":"80.00"}]
[null,"Total general",{"v":450,"d":"450.00"},{"v":428,"d":"428.00"},{"v":30,"d":"30.00"},{"v":908,"d":"908.00"}]