{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Gastos mensuales","Ingresos mensuales","Prev. gastos anuales","Prev. ingresos anuales"],"read":"whole","date_system":"1900"}

{"sheet":"Gastos mensuales","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[0,1,0,9]]}
[null,"GASTOS DOMÉSTICOS MENSUALES"]
[]
[null,"TOTAL GASTOS",{"$f":"D16+D27+D34+I11+I17+I23","v":{"v":2137,"d":"2,137 €"}}]
[]
[null,"Vivienda","Coste previsto","Coste real","Diferencia",null,"Niños","Coste previsto","Coste real","Diferencia"]
[null,"Hipoteca o alquiler",{"v":1000,"d":"1,000 €"},{"v":1000,"d":"1,000 €"},{"v":0,"d":"0.00 €"},null,"Ropa",null,{"v":150,"d":"150 €"},{"v":-150,"d":"-150.00 €"}]
[null,"2ª  hipoteca o alquiler",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0.00 €"},null,"Colegio",null,{"v":100,"d":"100 €"},{"v":-100,"d":"-100.00 €"}]
[null,"Teléfono",{"v":54,"d":"54 €"},{"v":100,"d":"100 €"},{"v":-46,"d":"-46.00 €"},null,"Material escolar",null,{"v":38,"d":"38 €"},{"v":-38,"d":"-38.00 €"}]
[null,"Electricidad",{"v":44,"d":"44 €"},{"v":56,"d":"56 €"},{"v":-12,"d":"-12.00 €"},null,"Juegos y juguetes",null,null,{"v":0,"d":"0.00 €"}]
[null,"Gas",{"v":22,"d":"22 €"},{"v":28,"d":"28 €"},{"v":-6,"d":"-6.00 €"},null,"Otros",null,null,{"v":0,"d":"0.00 €"}]
[null,"Agua y alcantarillado",{"v":8,"d":"8 €"},{"v":8,"d":"8 €"},{"v":0,"d":"0.00 €"},null,null,"TOTAL",{"$f":"SUM(I6:I10)","v":{"v":288,"d":"288 €"}}]
[null,"TV por cable",{"v":34,"d":"34 €"},{"v":34,"d":"34 €"},{"v":0,"d":"0.00 €"}]
[null,"Basura",{"v":10,"d":"10 €"},{"v":10,"d":"10 €"},{"v":0,"d":"0.00 €"},null,"Mascotas","Coste previsto","Coste real","Diferencia"]
[null,"Suministros",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0.00 €"},null,"Comida",null,{"v":50,"d":"50 €"},{"v":-50,"d":"-50.00 €"}]
[null,"Otros",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0.00 €"},null,"Médicos",null,null,{"v":0,"d":"0.00 €"}]
[null,null,"TOTAL",{"$f":"SUM(D6:D15)","v":{"v":1236,"d":"1,236 €"}},null,null,"Otros",null,null,{"v":0,"d":"0.00 €"}]
[{"$nulls":7},"TOTAL",{"$f":"SUM(I14:I16)","v":{"v":50,"d":"50 €"}}]
[null,"Transportes","Coste previsto","Coste real","Diferencia"]
[null,"Credito coche 1",null,{"v":230,"d":"230 €"},{"v":-230,"d":"-230.00 €"},null,"Otros / entretenimiento","Coste previsto","Coste real","Diferencia"]
[null,"Credito coche 2",null,null,{"v":0,"d":"0.00 €"},null,"Gimnasio",null,{"v":48,"d":"48 €"},{"v":-48,"d":"-48.00 €"}]
[null,"Gastos de taxi/autobús",null,{"v":55,"d":"55 €"},{"v":-55,"d":"-55.00 €"},null,"Peluquería",null,{"v":150,"d":"150 €"},{"v":-150,"d":"-150.00 €"}]
[null,"Seguro",null,null,{"v":0,"d":"0.00 €"},null,"Otros",null,null,{"v":0,"d":"0.00 €"}]
[null,"Permisos",null,null,{"v":0,"d":"0.00 €"},null,null,"TOTAL",{"$f":"SUM(I20:I22)","v":{"v":198,"d":"198 €"}}]
[null,"Gasolina",null,{"v":80,"d":"80 €"},{"v":-80,"d":"-80.00 €"}]
[null,"Revisiones coche",null,null,{"v":0,"d":"0.00 €"}]
[null,"Otros",null,null,{"v":0,"d":"0.00 €"}]
[null,null,"TOTAL",{"$f":"SUM(D19:D26)","v":{"v":365,"d":"365 €"}}]
[]
[null,"Seguros","Coste previsto","Coste real","Diferencia"]
[null,"Hogar",null,null,{"v":0,"d":"0.00 €"}]
[null,"Vida",null,null,{"v":0,"d":"0.00 €"}]
[null,"Salud",null,null,{"v":0,"d":"0.00 €"}]
[null,"Otros",null,null,{"v":0,"d":"0.00 €"}]
[null,null,"TOTAL",{"$f":"SUM(D30:D33)","v":{"v":0,"d":"0 €"}}]

{"sheet":"Ingresos mensuales","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"merged":[[0,1,0,4]]}
[null,"INGRESOS MENSUALES"]
[]
[null,"TOTAL INGRESOS",{"$f":"D9+D15","v":{"v":3000,"d":"3,000 €"}}]
[]
[null,"Conyuge 1","Ingreso previsto","Ingreso real","Diferencia"]
[null,"Nómina",{"v":1500,"d":"1,500 €"},{"v":1500,"d":"1,500 €"},{"v":0,"d":"0 €"}]
[null,"Comisiones",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"v":0,"d":"0 €"}]
[null,"Otros",null,null,{"v":0,"d":"0 €"}]
[null,null,"TOTAL",{"$f":"SUM(D6:D8)","v":{"v":1800,"d":"1,800 €"}}]
[]
[null,"Conyuge 2","Ingreso previsto","Ingreso real","Diferencia"]
[null,"Nómina",{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"v":0,"d":"0 €"}]
[null,"Comisiones",null,null,{"v":0,"d":"0 €"}]
[null,"Otros",null,null,{"v":0,"d":"0 €"}]
[null,null,"TOTAL",{"$f":"SUM(D12:D14)","v":{"v":1200,"d":"1,200 €"}}]

{"sheet":"Prev. gastos anuales","index":2,"n_rows":12,"n_cols":15,"rows_kept":12,"merged":[[0,1,1,14]]}
[null,"PREVISIÓN DE GASTOS ANUALES"]
[]
[]
[null,null,"ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","TOTAL"]
[null,"HIPOTECA",{"$f":"'Gastos mensuales'!D16","v":{"v":1236,"d":"1,236.0 €"}},{"$nulls":11},{"$f":"SUM(C5:N5)","v":{"v":1236,"d":"1,236.0 €"}}]
[null,"SEGUROS",{"$f":"'Gastos mensuales'!D34","v":{"v":0,"d":"0.0 €"}},{"$nulls":11},{"$f":"SUM(C6:N6)","v":{"v":0,"d":"0.0 €"}}]
[null,"TRANSPORTES",{"$f":"'Gastos mensuales'!D27","v":{"v":365,"d":"365.0 €"}},{"$nulls":11},{"v":365,"d":"365.0 €"}]
[null,"NIÑOS",{"$f":"'Gastos mensuales'!I11","v":{"v":288,"d":"288.0 €"}},{"$nulls":11},{"v":288,"d":"288.0 €"}]
[null,"MASCOTAS",{"$f":"'Gastos mensuales'!I17","v":{"v":50,"d":"50.0 €"}},{"$nulls":11},{"v":50,"d":"50.0 €"}]
[null,"ENTRETENIMIENTO",{"$f":"'Gastos mensuales'!I23","v":{"v":198,"d":"198.0 €"}},{"$nulls":11},{"v":198,"d":"198.0 €"}]
[null,"IMPREVISTOS",{"$f":"'Gastos mensuales'!D34","v":{"v":0,"d":"0.0 €"}},{"$nulls":11},{"v":0,"d":"0.0 €"}]
[null,null,{"$f":"SUM(C5:C11)","v":{"v":2137,"d":"2,137.0 €"}},{"$f":"SUM(D8:D11)","v":{"v":0,"d":"0.0 €"}},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"},{"v":0,"d":"0.0 €"}]

{"sheet":"Prev. ingresos anuales","index":3,"n_rows":9,"n_cols":17,"rows_kept":9,"merged":[[0,1,1,16],[3,15,3,16],[4,1,5,1],[4,16,5,16],[6,1,7,1],[6,16,7,16],[8,15,8,16]]}
[null,"PREVISIÓN DE INGRESOS ANUALES"]
[]
[]
[{"$nulls":3},"ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","TOTALES"]
[null,"CONYUGE1","NOMINA",{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":1500,"d":"1,500.0 €"},{"v":18000,"d":"18,000.0 €"},{"$f":"P5+P6","v":{"v":20300,"d":"20,300.0 €"}}]
[null,null,"COMISIONES / OTROS",null,{"v":300,"d":"300.0 €"},null,{"v":450,"d":"450.0 €"},{"v":200,"d":"200.0 €"},{"v":150,"d":"150.0 €"},{"v":200,"d":"200.0 €"},null,{"v":600,"d":"600.0 €"},{"v":200,"d":"200.0 €"},{"v":200,"d":"200.0 €"},null,{"v":2300,"d":"2,300.0 €"}]
[null,"CONYUGE 2","NOMINA",{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":1200,"d":"1,200.0 €"},{"v":14400,"d":"14,400.0 €"},{"$f":"P7+P8","v":{"v":16200,"d":"16,200.0 €"}}]
[null,null,"COMISIONES / OTROS",{"$nulls":6},{"v":900,"d":"900.0 €"},{"$nulls":4},{"v":900,"d":"900.0 €"},{"v":1800,"d":"1,800.0 €"}]
[null,null,"TOTAL",{"$f":"SUM(D5:D8)","v":{"v":2700,"d":"2,700.0 €"}},{"v":3000,"d":"3,000.0 €"},{"v":2700,"d":"2,700.0 €"},{"v":3150,"d":"3,150.0 €"},{"v":2900,"d":"2,900.0 €"},{"v":2850,"d":"2,850.0 €"},{"v":3800,"d":"3,800.0 €"},{"v":2700,"d":"2,700.0 €"},{"v":3300,"d":"3,300.0 €"},{"v":2900,"d":"2,900.0 €"},{"v":2900,"d":"2,900.0 €"},{"v":3600,"d":"3,600.0 €"},{"$f":"(Q5+Q7)","v":{"v":36500,"d":"36,500.0 €"}}]