{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Presupuesto familiar mensual"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"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":"Presupuesto familiar mensual","index":0,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[62,5,62,8],[2,0,2,1],[36,0,36,3],[42,0,42,3],[54,0,54,3],[61,0,61,3],[27,5,27,8],[37,5,37,8],[44,5,44,8],[54,5,54,8],[0,0,0,6],[2,5,2,6],[8,5,8,6],[18,0,18,3],[29,0,29,3]]}
["Presupuesto Familiar Mensual"]
[]
["Costo previsto total",null,"Costo real total","Diferencia",null,"Ingresos mensuales previstos"]
[null,{"$f":"Housing[[#Totals],[Costo previsto]]+Transportation[[#Totals],[Costo previsto]]+Insurance[[#Totals],[Costo previsto]]+Food[[#Totals],[Costo previsto]]+Children[[#Totals],[Costo previsto]]+Legal[[#Totals],[Costo previsto]]+Savings[[#Totals],[Costo previsto]]+Loans[[#Totals],[Costo previsto]]+Entertainment[[#Totals],[Costo previsto]]+Taxes[[#Totals],[Costo previsto]]+PersonalCare[[#Totals],[Costo previsto]]+Pets[[#Totals],[Costo previsto]]+Gifts[[#Totals],[Costo previsto]]","v":1203},{"$f":"Housing[[#Totals],[Costo real]]+Transportation[[#Totals],[Costo real]]+Insurance[[#Totals],[Costo real]]+Food[[#Totals],[Costo real]]+Children[[#Totals],[Costo real]]+Legal[[#Totals],[Costo real]]+Savings[[#Totals],[Costo real]]+Loans[[#Totals],[Costo real]]+Entertainment[[#Totals],[Costo real]]+Taxes[[#Totals],[Costo real]]+PersonalCare[[#Totals],[Costo real]]+Pets[[#Totals],[Costo real]]+Gifts[[#Totals],[Costo real]]","v":1317},{"$f":"Housing[[#Totals],[Diferencia]]+Transportation[[#Totals],[Diferencia]]+Insurance[[#Totals],[Diferencia]]+Food[[#Totals],[Diferencia]]+Children[[#Totals],[Diferencia]]+Legal[[#Totals],[Diferencia]]+Savings[[#Totals],[Diferencia]]+Loans[[#Totals],[Diferencia]]+Entertainment[[#Totals],[Diferencia]]+Taxes[[#Totals],[Diferencia]]+PersonalCare[[#Totals],[Diferencia]]+Pets[[#Totals],[Diferencia]]+Gifts[[#Totals],[Diferencia]]","v":-114},null,"Ingresos 1",4000]
[null,null,null,null,null,"Ingresos 2",1200]
["Vivienda","Costo previsto","Costo real","Diferencia",null,"Ingresos extra",300]
["Hipoteca o alquiler",1000,1000,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0},null,"Ingresos mensuales totales",{"$f":"SUM(G4:G6)","v":5500}]
["Segunda hipoteca o alquiler",0,0,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0}]
["Teléfono",62,100,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":-38},null,"Ingresos mensuales reales"]
["Electricidad",44,125,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":-81},null,"Ingresos 1",4000]
["Gasolina",22,35,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":-13},null,"Ingresos 2",1200]
["Agua y alcantarillado",8,8,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0},null,"Ingresos extra",300]
["TV por cable",34,39,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":-5},null,"Ingresos mensuales totales",{"$f":"SUM(G10:G12)","v":5500}]
["Basura",10,10,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0}]
["Mantenimiento o reparaciones",23,0,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":23},null,"Saldo previsto\n",{"$f":"SUM(G7-B4)","v":4297}]
["Otros artículos",0,0,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0},null,"Saldo real",{"$f":"SUM(G13-C4)","v":4183}]
["Otros",0,0,{"$f":"Housing[Costo previsto]-Housing[Costo real]","v":0},null,"Diferencia",{"$f":"SUM(G16-G15)","v":-114}]
["Total",{"$f":"SUBTOTAL(109,Housing[Costo previsto])","v":1203},{"$f":"SUBTOTAL(109,Housing[Costo real])","v":1317},{"$f":"SUBTOTAL(109,Housing[Diferencia])","v":-114}]
[]
["Transportes","Costo previsto","Costo real","Diferencia",null,"Préstamos","Costo previsto","Costo real","Diferencia"]
["Pago del vehículo 1",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Personal",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Pago del vehículo 2",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Estudiante",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Gastos de taxi/autobús",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Tarjeta de crédito",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Seguro",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Tarjeta de crédito",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Permisos",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Tarjeta de crédito",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Gasolina",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Otros",null,null,{"$f":"Loans[Costo previsto]-Loans[Costo real]","v":0}]
["Mantenimiento",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0},null,"Total",{"$f":"SUBTOTAL(109,Loans[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Loans[Costo real])","v":0},{"$f":"SUBTOTAL(109,Loans[Diferencia])","v":0}]
["Otros",null,null,{"$f":"Transportation[Costo previsto]-Transportation[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Transportation[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Transportation[Costo real])","v":0},{"$f":"SUBTOTAL(109,Transportation[Diferencia])","v":0},null,"Entretenimiento","Costo previsto","Costo real","Diferencia"]
[null,null,null,null,null,"Vídeo/DVD",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Seguro","Costo previsto","Costo real","Diferencia",null,"CD",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Inicio",null,null,{"$f":"Insurance[Costo previsto]-Insurance[Costo real]","v":0},null,"Películas",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Salud",null,null,{"$f":"Insurance[Costo previsto]-Insurance[Costo real]","v":0},null,"Conciertos",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Vida",null,null,{"$f":"Insurance[Costo previsto]-Insurance[Costo real]","v":0},null,"Acontecimientos deportivos",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Otros",null,null,{"$f":"Insurance[Costo previsto]-Insurance[Costo real]","v":0},null,"Teatro",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Insurance[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Insurance[Costo real])","v":0},{"$f":"SUBTOTAL(109,Insurance[Diferencia])","v":0},null,"Otros",null,null,{"$f":"Entertainment[Costo previsto]-Entertainment[Costo real]","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,Entertainment[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Costo real])","v":0},{"$f":"SUBTOTAL(109,Entertainment[Diferencia])","v":0}]
["Alimentos","Costo previsto","Costo real","Diferencia"]
["Alimentación",null,null,{"$f":"Food[Costo previsto]-Food[Costo real]","v":0},null,"Impuestos","Costo previsto","Costo real","Diferencia"]
["Cenar fuera",null,null,{"$f":"Food[Costo previsto]-Food[Costo real]","v":0},null,"Federales",null,null,{"$f":"Taxes[Costo previsto]-Taxes[Costo real]","v":0}]
["Otros",null,null,{"$f":"Food[Costo previsto]-Food[Costo real]","v":0},null,"Provincia/Estado",null,null,{"$f":"Taxes[Costo previsto]-Taxes[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Food[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Food[Costo real])","v":0},{"$f":"SUBTOTAL(109,Food[Diferencia])","v":0},null,"Locales",null,null,{"$f":"Taxes[Costo previsto]-Taxes[Costo real]","v":0}]
[null,null,null,null,null,"Otros",null,null,{"$f":"Taxes[Costo previsto]-Taxes[Costo real]","v":0}]
["Niños","Costo previsto","Costo real","Diferencia",null,"Total",{"$f":"SUBTOTAL(109,Taxes[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Taxes[Costo real])","v":0},{"$f":"SUBTOTAL(109,Taxes[Diferencia])","v":0}]
["Médicos",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0}]
["Ropa",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Cuidados personales","Costo previsto","Costo real","Diferencia"]
["Colegio",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Médicos",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Material escolar",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Cabello y uñas",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Tasas de la organización",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Ropa",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Dinero para comer",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Tintorería",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Cuidado de los niños",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Club de salud",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Juegos y juguetes",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Tasas o cuotas",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Otros",null,null,{"$f":"Children[Costo previsto]-Children[Costo real]","v":0},null,"Otros",null,null,{"$f":"PersonalCare[Costo previsto]-PersonalCare[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Children[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Children[Costo real])","v":0},{"$f":"SUBTOTAL(109,Children[Diferencia])","v":0},null,"Total",{"$f":"SUBTOTAL(109,PersonalCare[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Costo real])","v":0},{"$f":"SUBTOTAL(109,PersonalCare[Diferencia])","v":0}]
[]
["Asesoría jurídica","Costo previsto","Costo real","Diferencia",null,"Mascotas","Costo previsto","Costo real","Diferencia"]
["Abogado",null,null,{"$f":"Legal[Costo previsto]-Legal[Costo real]","v":0},null,"Alimentos",null,null,{"$f":"Pets[Costo previsto]-Pets[Costo real]","v":0}]
["Pensión alimenticia",null,null,{"$f":"Legal[Costo previsto]-Legal[Costo real]","v":0},null,"Médicos",null,null,{"$f":"Pets[Costo previsto]-Pets[Costo real]","v":0}]
["Pagos",null,null,{"$f":"Legal[Costo previsto]-Legal[Costo real]","v":0},null,"Cepillado",null,null,{"$f":"Pets[Costo previsto]-Pets[Costo real]","v":0}]
["Otros",null,null,{"$f":"Legal[Costo previsto]-Legal[Costo real]","v":0},null,"Juguetes",null,null,{"$f":"Pets[Costo previsto]-Pets[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Legal[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Legal[Costo real])","v":0},{"$f":"SUBTOTAL(109,Legal[Diferencia])","v":0},null,"Otros",null,null,{"$f":"Pets[Costo previsto]-Pets[Costo real]","v":0}]
[null,null,null,null,null,"Total",{"$f":"SUBTOTAL(109,Pets[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Pets[Costo real])","v":0},{"$f":"SUBTOTAL(109,Pets[Diferencia])","v":0}]
["Ahorros o inversiones","Costo previsto","Costo real","Diferencia"]
["Fondo de pensiones",null,null,{"$f":"Savings[Costo previsto]-Savings[Costo real]","v":0},null,"Regalos y donaciones","Costo previsto","Costo real","Diferencia"]
["Fondo de inversión",null,null,{"$f":"Savings[Costo previsto]-Savings[Costo real]","v":0},null,"Caridad 1",null,null,{"$f":"Gifts[Costo previsto]-Gifts[Costo real]","v":0}]
["Universidad",null,null,{"$f":"Savings[Costo previsto]-Savings[Costo real]","v":0},null,"Caridad 2",null,null,{"$f":"Gifts[Costo previsto]-Gifts[Costo real]","v":0}]
["Otros",null,null,{"$f":"Savings[Costo previsto]-Savings[Costo real]","v":0},null,"Caridad 3",null,null,{"$f":"Gifts[Costo previsto]-Gifts[Costo real]","v":0}]
["Total",{"$f":"SUBTOTAL(109,Savings[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Savings[Costo real])","v":0},{"$f":"SUBTOTAL(109,Savings[Diferencia])","v":0},null,"Total",{"$f":"SUBTOTAL(109,Gifts[Costo previsto])","v":0},{"$f":"SUBTOTAL(109,Gifts[Costo real])","v":0},{"$f":"SUBTOTAL(109,Gifts[Diferencia])","v":0}]