{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Hoja1","Info. general del presupuesto","Resumen de presupuesto","Gastos mensuales","Datos adicionales"],"not_rendered":{"charts":1,"defined_names":7,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"hidden":true}
["Campo calculado"]
["Orden de resolución","Campo","Fórmula"]
[]
["Elemento calculado"]
["Orden de resolución","Elemento","Fórmula"]
[]
[]
["Nota:","Cuando una celda es actualizada por más de una fórmula,"]
[null,"el valor se establece mediante la fórmula con el último orden de resolución."]
[]
[null,"Para cambiar el orden de resolución de varios elementos o campos calculados,"]
[null,"en la pestaña Opciones, en el grupo Cálculos, haga clic en Campos, Elementos y Conjuntos y, a continuación, haga clic en Orden de resolución."]

{"sheet":"Info. general del presupuesto","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[0,1,0,6],[1,1,1,2],[3,1,3,2],[4,1,4,2],[5,1,5,2]]}
[null,"PANORÁMICA DEL PRESUPUESTO",{"$nulls":5}," "]
[null,"Saldo"]
[]
[null,"Saldo previsto",null,{"$f":"Ingresos_Previstos-Gastos_Previstos","v":{"v":1585,"d":"1,585 €"}},null,"Cantidad prevista menos gastos"]
[null,"Saldo real ",null,{"$f":"Ingresos_Reales-Gastos_Reales","v":{"v":1740,"d":"1,740 €"}},null,"Cantidad real menos gastos"]
[null,"Diferencia",null,{"$f":"D5-D4","v":{"v":155,"d":"155 €"}},null,"Cantidad real menos cantidad prevista"]
[]
[null,"Ingresos",{"$nulls":3},"Gastos"]
[]
[null,null,"Estimado","Real",null,"Estimado","Real"]
[null,"Ingreso 1",{"v":6000,"d":"6,000 €"},{"v":5800,"d":"5,800 €"},null,{"$f":"SUM(Table_Gastos_Mensuales[[#All],[Costo previsto]])","v":{"v":7915,"d":"7,915 €"}},{"$f":"SUM(Table_Gastos_Mensuales[Costo real])","v":{"v":7860,"d":"7,860 €"}}]
[null,"Ingreso 2",{"v":1000,"d":"1,000 €"},{"v":2300,"d":"2,300 €"}]
[null,"Ingresos adicionales",{"v":2500,"d":"2,500 €"},{"v":1500,"d":"1,500 €"}]
[null,"Ingresos totales",{"$f":"SUM(C11:C13)","v":{"v":9500,"d":"9,500 €"}},{"$f":"SUM(D11:D13)","v":{"v":9600,"d":"9,600 €"}}]
[]
[null,"Desglose de gastos reales"]

{"sheet":"Resumen de presupuesto","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[0,1,0,4]]}
[null,"RESUMEN DE PRESUPUESTO",{"$nulls":4}," "]
[]
[null,"Row Labels","Costo previsto ","Costo real ","Diferencia "]
[null,"Niños",{"v":140,"d":"140 €"},{"v":140,"d":"140 €"},{"v":0,"d":"0 €"}]
[null,"Actividades extracurriculares",{"v":40,"d":"40 €"},{"v":40,"d":"40 €"},{"v":0,"d":"0 €"}]
[null,"Material escolar",null,null,{"v":0,"d":"0 €"}]
[null,"Matrícula escolar",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"v":0,"d":"0 €"}]
[null,"Salud",null,null,{"v":0,"d":"0 €"}]
[]
[null,"Entretenimiento",{"v":400,"d":"400 €"},{"v":358,"d":"358 €"},{"v":42,"d":"42 €"}]
[null,"Conciertos",{"v":50,"d":"50 €"},{"v":40,"d":"40 €"},{"v":10,"d":"10 €"}]
[null,"Eventos deportivos",{"v":0,"d":"0 €"},{"v":40,"d":"40 €"},{"v":-40,"d":"-40 €"}]
[null,"Música (CD, descargas, etc.)",{"v":50,"d":"50 €"},{"v":30,"d":"30 €"},{"v":20,"d":"20 €"}]
[null,"Películas",{"v":50,"d":"50 €"},{"v":28,"d":"28 €"},{"v":22,"d":"22 €"}]
[null,"Teatro en directo",{"v":200,"d":"200 €"},{"v":150,"d":"150 €"},{"v":50,"d":"50 €"}]
[null,"Vídeo/DVD (alquiler)",{"v":30,"d":"30 €"},{"v":20,"d":"20 €"},{"v":10,"d":"10 €"}]
[null,"Vídeo/DVD (compra)",{"v":20,"d":"20 €"},{"v":50,"d":"50 €"},{"v":-30,"d":"-30 €"}]
[]
[null,"Comida",{"v":1100,"d":"1,100 €"},{"v":1320,"d":"1,320 €"},{"v":-220,"d":"-220 €"}]
[]
[null,"Regalos y caridad",{"v":100,"d":"100 €"},{"v":125,"d":"125 €"},{"v":-25,"d":"-25 €"}]
[null,"Organización benéfica 1",{"v":75,"d":"75 €"},{"v":100,"d":"100 €"},{"v":-25,"d":"-25 €"}]
[null,"Organización benéfica 2",{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"v":0,"d":"0 €"}]
[null,"Regalo 1",null,null,{"v":0,"d":"0 €"}]
[null,"Regalo 2",null,null,{"v":0,"d":"0 €"}]
[]
[null,"Vivienda",{"v":2830,"d":"2,830 €"},{"v":2702,"d":"2,702 €"},{"v":-72,"d":"-72 €"}]
[]
[null,"Seguro",{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":0,"d":"0 €"}]
[]
[null,"Préstamos",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"v":0,"d":"0 €"}]
[]
[null,"Cuidado personal",{"v":150,"d":"150 €"},{"v":140,"d":"140 €"},{"v":10,"d":"10 €"}]
[]
[null,"Mascotas",{"v":170,"d":"170 €"},{"v":100,"d":"100 €"},{"v":70,"d":"70 €"}]
[]
[null,"Impuestos",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"v":0,"d":"0 €"}]
[]
[null,"Transporte",{"v":1425,"d":"1,425 €"},{"v":1375,"d":"1,375 €"},{"v":50,"d":"50 €"}]
[]
[null,"Ahorros",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"v":0,"d":"0 €"}]
[null,"Cuenta de inversión",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"v":0,"d":"0 €"}]
[null,"Cuenta de jubilación",null,null,{"v":0,"d":"0 €"}]
[]
[null,"Grand Total",{"v":7915,"d":"7,915 €"},{"v":7860,"d":"7,860 €"},{"v":-145,"d":"-145 €"}]

{"sheet":"Gastos mensuales","index":3,"n_rows":61,"n_cols":8,"rows_kept":61}
[null,"GASTOS MENSUALES",{"$nulls":5}," "]
[null,"Descripción","Categoría","Costo previsto","Costo real","Diferencia","Panorámica del costo real"]
[null,"Actividades extracurriculares","Niños",{"v":40,"d":"40 €"},{"v":40,"d":"40 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":40,"d":"$40"}}]
[null,"Salud","Niños",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Material escolar","Niños",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Matrícula escolar","Niños",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}}]
[null,"Conciertos","Entretenimiento",{"v":50,"d":"50 €"},{"v":40,"d":"40 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":10,"d":"10 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":40,"d":"$40"}}]
[null,"Teatro en directo","Entretenimiento",{"v":200,"d":"200 €"},{"v":150,"d":"150 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":50,"d":"50 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":150,"d":"$150"}}]
[null,"Películas","Entretenimiento",{"v":50,"d":"50 €"},{"v":28,"d":"28 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":22,"d":"22 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":28,"d":"$28"}}]
[null,"Música (CD, descargas, etc.)","Entretenimiento",{"v":50,"d":"50 €"},{"v":30,"d":"30 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":20,"d":"20 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":30,"d":"$30"}}]
[null,"Eventos deportivos","Entretenimiento",{"v":0,"d":"0 €"},{"v":40,"d":"40 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-40,"d":"-40 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":40,"d":"$40"}}]
[null,"Vídeo/DVD (compra)","Entretenimiento",{"v":20,"d":"20 €"},{"v":50,"d":"50 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-30,"d":"-30 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":50,"d":"$50"}}]
[null,"Vídeo/DVD (alquiler)","Entretenimiento",{"v":30,"d":"30 €"},{"v":20,"d":"20 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":10,"d":"10 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":20,"d":"$20"}}]
[null,"Cenas en restaurantes","Comida",{"v":1000,"d":"1,000 €"},{"v":1200,"d":"1,200 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-200,"d":"-200 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":1200,"d":"$1,200"}}]
[null,"Alimentos","Comida",{"v":100,"d":"100 €"},{"v":120,"d":"120 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-20,"d":"-20 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":120,"d":"$120"}}]
[null,"Organización benéfica 1","Regalos y caridad",{"v":75,"d":"75 €"},{"v":100,"d":"100 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-25,"d":"-25 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}}]
[null,"Organización benéfica 2","Regalos y caridad",{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":25,"d":"$25"}}]
[null,"Regalo 1","Regalos y caridad",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Regalo 2","Regalos y caridad",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Cable/satélite","Vivienda",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}}]
[null,"Electricidad","Vivienda",{"v":45,"d":"45 €"},{"v":50,"d":"50 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-5,"d":"-5 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":50,"d":"$50"}}]
[null,"Gas","Vivienda",{"v":300,"d":"300 €"},{"v":400,"d":"400 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-100,"d":"-100 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":400,"d":"$400"}}]
[null,"Servicios de limpieza de la casa","Vivienda",{"v":200,"d":"200 €"},null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Mantenimiento","Vivienda",{"v":200,"d":"200 €"},{"v":150,"d":"150 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":50,"d":"50 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":150,"d":"$150"}}]
[null,"Hipoteca o alquiler","Vivienda",{"v":1700,"d":"1,700 €"},{"v":1700,"d":"1,700 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":1700,"d":"$1,700"}}]
[null,"Petróleo/gas natural","Vivienda",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Servicio de Internet","Vivienda",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}}]
[null,"Teléfono móvil","Vivienda",{"v":60,"d":"60 €"},{"v":60,"d":"60 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":60,"d":"$60"}}]
[null,"Teléfono particular","Vivienda",{"v":35,"d":"35 €"},{"v":39,"d":"39 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-4,"d":"-4 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":39,"d":"$39"}}]
[null,"Artículos de consumo","Vivienda",{"v":40,"d":"40 €"},{"v":55,"d":"55 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-15,"d":"-15 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":55,"d":"$55"}}]
[null,"Reciclaje y eliminación de residuos","Vivienda",{"v":25,"d":"25 €"},{"v":22,"d":"22 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":3,"d":"3 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":22,"d":"$22"}}]
[null,"Agua y alcantarillado","Vivienda",{"v":25,"d":"25 €"},{"v":26,"d":"26 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-1,"d":"-1 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":26,"d":"$26"}}]
[null,"Salud","Seguro",{"v":400,"d":"400 €"},{"v":400,"d":"400 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":400,"d":"$400"}}]
[null,"Hogar","Seguro",{"v":400,"d":"400 €"},{"v":400,"d":"400 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":400,"d":"$400"}}]
[null,"Vida","Seguro",{"v":100,"d":"100 €"},{"v":100,"d":"100 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}}]
[null,"Tarjeta de crédito 1","Préstamos",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":200,"d":"$200"}}]
[null,"Tarjeta de crédito 2","Préstamos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Tarjeta de crédito 3","Préstamos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Personal","Préstamos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Estudiante","Préstamos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Ropa","Cuidado personal",{"v":150,"d":"150 €"},{"v":140,"d":"140 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":10,"d":"10 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":140,"d":"$140"}}]
[null,"Tintorería","Cuidado personal",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Cabello/uñas","Cuidado personal",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Gimnasio","Cuidado personal",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Salud","Cuidado personal",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Comida","Mascotas",{"v":150,"d":"150 €"},{"v":75,"d":"75 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":75,"d":"75 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":75,"d":"$75"}}]
[null,"Aseo","Mascotas",{"v":20,"d":"20 €"},{"v":25,"d":"25 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-5,"d":"-5 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":25,"d":"$25"}}]
[null,"Medicinas","Mascotas",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Juguetes","Mascotas",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Cuenta de inversión","Ahorros",{"v":200,"d":"200 €"},{"v":200,"d":"200 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":200,"d":"$200"}}]
[null,"Cuenta de jubilación","Ahorros",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Federales","Impuestos",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":300,"d":"$300"}}]
[null,"Locales","Impuestos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Estado","Impuestos",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Bus y viajes compartidos","Transporte",{"v":100,"d":"100 €"},{"v":150,"d":"150 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":-50,"d":"-50 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":150,"d":"$150"}}]
[null,"Combustible","Transporte",{"v":450,"d":"450 €"},{"v":400,"d":"400 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":50,"d":"50 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":400,"d":"$400"}}]
[null,"Seguro","Transporte",{"v":300,"d":"300 €"},{"v":300,"d":"300 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":300,"d":"$300"}}]
[null,"Licencias ","Transporte",{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":25,"d":"$25"}}]
[null,"Mantenimiento","Transporte",{"v":100,"d":"100 €"},{"v":50,"d":"50 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":50,"d":"50 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":50,"d":"$50"}}]
[null,"Gastos de aparcamiento","Transporte",null,null,{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":""},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Pago del vehículo","Transporte",{"v":450,"d":"450 €"},{"v":450,"d":"450 €"},{"$f":"IF(OR(Table_Gastos_Mensuales[[#This Row],[Costo previsto]]=\"\",Table_Gastos_Mensuales[[#This Row],[Costo real]]=\"\"),\"\",Table_Gastos_Mensuales[[#This Row],[Costo previsto]]-Table_Gastos_Mensuales[[#This Row],[Costo real]])","v":{"v":0,"d":"0 €"}},{"$f":"Table_Gastos_Mensuales[[#This Row],[Costo real]]","v":{"v":450,"d":"$450"}}]

{"sheet":"Datos adicionales","index":4,"n_rows":17,"n_cols":9,"rows_kept":17}
[null,"DATOS ADICIONALES",{"$nulls":3}," "]
[null,"Tabla dinámica para el gráfico de presupuesto",null,null,"Lista de categorías"]
[]
[null,"Categorías","Costo ",null,"Para agregar una categoría, escriba debajo",{"$nulls":3},"`"]
[null,"Mascotas",{"v":100,"d":"100 €"},null,"Niños"]
[null,"Regalos y caridad",{"v":125,"d":"125 €"},null,"Entretenimiento"]
[null,"Niños",{"v":140,"d":"140 €"},null,"Comida"]
[null,"Cuidado personal",{"v":140,"d":"140 €"},null,"Regalos y caridad"]
[null,"Préstamos",{"v":200,"d":"200 €"},null,"Vivienda"]
[null,"Ahorros",{"v":200,"d":"200 €"},null,"Seguro"]
[null,"Impuestos",{"v":300,"d":"300 €"},null,"Préstamos"]
[null,"Entretenimiento",{"v":358,"d":"358 €"},null,"Cuidado personal"]
[null,"Seguro",{"v":900,"d":"900 €"},null,"Mascotas"]
[null,"Comida",{"v":1320,"d":"1,320 €"},null,"Ahorros"]
[null,"Transporte",{"v":1375,"d":"1,375 €"},null,"Impuestos"]
[null,"Vivienda",{"v":2702,"d":"2,702 €"},null,"Transporte"]
[null,"Grand Total",{"v":7860,"d":"7,860 €"}]