{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Flujo de efectivo","Ingresos mensuales","Gastos mensuales","Datos del gráfico"],"not_rendered":{"charts":1,"images":2,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Flujo de efectivo","index":0,"n_rows":11,"n_cols":5,"rows_kept":11}
[]
[null,"Familia Torres | Febrero de 2023"]
[null,"PRESUPUESTO DEL HOGAR"]
[]
[null,"Análisis de flujo de efectivo"]
[]
[]
[null,"Presupuesto del hogar","Cantidad prevista","Reales","Desviación"]
[null,"Ingresos totales",{"$f":"Ingresos[[#Totals],[Cantidad prevista]]","v":{"v":5700,"d":"5,700 €"}},{"$f":"Ingresos[[#Totals],[Reales]]","v":{"v":6000,"d":"6,000 €"}},{"$f":"FlujoDeEfectivo[[#This Row],[Reales]]-FlujoDeEfectivo[[#This Row],[Cantidad prevista]]","v":{"v":300,"d":"300 €"}}]
[null,"Gastos totales",{"$f":"Gastos[[#Totals],[Cantidad prevista]]","v":{"v":3603,"d":"3,603 €"}},{"$f":"Gastos[[#Totals],[Reales]]","v":{"v":3655,"d":"3,655 €"}},{"$f":"FlujoDeEfectivo[[#This Row],[Cantidad prevista]]-FlujoDeEfectivo[[#This Row],[Reales]]","v":{"v":-52,"d":"-52 €"}}]
[null,"Efectivo total",{"$f":"C9-C10","v":{"v":2097,"d":"2,097 €"}},{"$f":"D9-D10","v":{"v":2345,"d":"2,345 €"}},{"$f":"SUBTOTAL(109,FlujoDeEfectivo[Desviación])","v":{"v":248,"d":"248 €"}}]

{"sheet":"Ingresos mensuales","index":1,"n_rows":9,"n_cols":6,"rows_kept":9,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Familia Torres | Febrero de 2023"]
[null,"INGRESOS MENSUALES"]
[]
[null," Ingresos mensuales","Cantidad prevista","Reales","Desviación"]
[null,"Ingreso 1",{"v":4000,"d":"4,000.00 €"},{"v":4000,"d":"4,000.00 €"},{"$f":"Ingresos[[#This Row],[Reales]]-Ingresos[[#This Row],[Cantidad prevista]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Ingreso 2",{"v":1400,"d":"1,400.00 €"},{"v":1500,"d":"1,500.00 €"},{"$f":"Ingresos[[#This Row],[Reales]]-Ingresos[[#This Row],[Cantidad prevista]]","v":{"v":100,"d":"100.00 €"}}]
[null,"Otros ingresos",{"v":300,"d":"300.00 €"},{"v":500,"d":"500.00 €"},{"$f":"Ingresos[[#This Row],[Reales]]-Ingresos[[#This Row],[Cantidad prevista]]","v":{"v":200,"d":"200.00 €"}}]
[null,"Ingresos totales",{"$f":"SUBTOTAL(109,Ingresos[Cantidad prevista])","v":{"v":5700,"d":"5,700.00 €"}},{"$f":"SUBTOTAL(109,Ingresos[Reales])","v":{"v":6000,"d":"6,000.00 €"}},{"$f":"SUBTOTAL(109,Ingresos[Desviación])","v":{"v":300,"d":"300.00 €"}}]

{"sheet":"Gastos mensuales","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[1,1,1,3],[2,1,2,3]]}
[{"$nulls":5}," "]
[null,"Familia Torres | Febrero de 2023"]
[null,"GASTOS MENSUALES"]
[]
[null," Gastos mensuales","Cantidad prevista","Reales","Desviación"]
[null,"Vivienda",{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Comestibles",{"v":250,"d":"250.00 €"},{"v":280,"d":"280.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":-30,"d":"-30.00 €"}}]
[null,"Teléfono",{"v":38,"d":"38.00 €"},{"v":38,"d":"38.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Luz/gas",{"v":65,"d":"65.00 €"},{"v":78,"d":"78.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":-13,"d":"-13.00 €"}}]
[null,"Agua/alcantarillado/basuras",{"v":25,"d":"25.00 €"},{"v":21,"d":"21.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":4,"d":"4.00 €"}}]
[null,"Televisión por cable",{"v":75,"d":"75.00 €"},{"v":83,"d":"83.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":-8,"d":"-8.00 €"}}]
[null,"Internet",{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Reparaciones y mantenimiento",{"v":0,"d":"0.00 €"},{"v":60,"d":"60.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":-60,"d":"-60.00 €"}}]
[null,"Guardería",{"v":180,"d":"180.00 €"},{"v":150,"d":"150.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":30,"d":"30.00 €"}}]
[null,"Matrícula",{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Mascotas",{"v":75,"d":"75.00 €"},{"v":80,"d":"80.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":-5,"d":"-5.00 €"}}]
[null,"Transporte",{"v":280,"d":"280.00 €"},{"v":260,"d":"260.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":20,"d":"20.00 €"}}]
[null,"Cuidado personal",{"v":75,"d":"75.00 €"},{"v":65,"d":"65.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":10,"d":"10.00 €"}}]
[null,"Seguro",{"v":255,"d":"255.00 €"},{"v":255,"d":"255.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Tarjetas de crédito",{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Préstamos",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Impuestos",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Regalos/Beneficencia",{"v":150,"d":"150.00 €"},{"v":150,"d":"150.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Ahorro",{"v":225,"d":"225.00 €"},{"v":225,"d":"225.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Otros",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"Gastos[[#This Row],[Cantidad prevista]]-Gastos[[#This Row],[Reales]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Gastos[Cantidad prevista])","v":{"v":3603,"d":"3,603.00 €"}},{"$f":"SUBTOTAL(109,Gastos[Reales])","v":{"v":3655,"d":"3,655.00 €"}},{"$f":"SUBTOTAL(109,Gastos[Desviación])","v":{"v":-52,"d":"-52.00 €"}}]

{"sheet":"Datos del gráfico","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"hidden":true}
[]
[null,"Datos del gráfico"]
[]
[null,null,"Cantidad prevista","Real"]
[null,"Ingresos mensuales",{"$f":"Ingresos[[#Totals],[Cantidad prevista]]","v":5700},{"$f":"Ingresos[[#Totals],[Reales]]","v":6000}]
[null,"Gastos mensuales",{"$f":"Gastos[[#Totals],[Cantidad prevista]]","v":3603},{"$f":"Gastos[[#Totals],[Reales]]","v":3655}]
[null,"Flujo de efectivo",{"$f":"FlujoDeEfectivo[[#Totals],[Cantidad prevista]]","v":2097},{"$f":"FlujoDeEfectivo[[#Totals],[Reales]]","v":2345}]