{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Presupuesto mensual personal"],"read":"whole","date_system":"1900"}

{"sheet":"Presupuesto mensual personal","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"merged":[[0,1,0,9],[2,1,4,1],[2,2,2,3],[2,7,2,8],[3,2,3,3],[3,7,3,8],[4,2,4,3],[4,6,4,8],[5,1,7,1],[5,2,5,3],[5,7,5,8],[6,2,6,3],[6,7,6,8],[7,2,7,3],[7,6,7,8],[20,6,20,9],[21,1,21,4],[29,6,29,9],[31,1,31,4],[36,6,36,9],[38,1,38,4],[42,6,42,9],[44,1,44,4],[48,6,48,9],[52,1,52,4],[55,6,55,9]]}
[null,"Presupuesto mensual personal"]
[]
[null,"INGRESOS MENSUALES PREVISTOS","Ingresos 1",null,{"v":2500,"d":"2,500 €"},null,"GASTOS PREVISTOS TOTALES ","(Ingresos previstos menos gastos)",null,{"$f":"SUM(C21,C31,C38,C44,C52,C62,H20,H29,H36,H42,H48,H55)","v":{"v":2060,"d":"2,060 €"}}]
[null,null,"Ingresos adicionales",null,{"v":500,"d":"500 €"},null,"GASTOS REALES TOTALES ","(Ingresos reales menos gastos)",null,{"$f":"SUM(D21,D31,D38,D44,D52,D62,I20,I29,I36,I42,I48,I55)","v":{"v":2040,"d":"2,040 €"}}]
[null,null,"Total de ingresos mensuales",null,{"$f":"SUM(E3:E4)","v":{"v":3000,"d":"3,000 €"}},null,"Diferencia total de los gastos",null,null,{"$f":"SUM(E21,E31,E38,E44,E52,E62,J20,J29,J36,J42,J48,J55)","v":{"v":20,"d":"20 €"}}]
[null,"INGRESOS MENSUALES REALES","Ingresos 1",null,{"v":2500,"d":"2,500 €"},null,"SALDO PREVISTO","(Ingresos previstos menos gastos)",null,{"$f":"E5-J3","v":{"v":940,"d":"940 €"}}]
[null,null,"Ingresos adicionales",null,{"v":500,"d":"500 €"},null,"SALDO REAL","(Ingresos reales menos gastos)",null,{"$f":"E8-J4","v":{"v":960,"d":"960 €"}}]
[null,null,"Total de ingresos mensuales",null,{"$f":"SUM(E6:E7)","v":{"v":3000,"d":"3,000 €"}},null,"DIFERENCIA DEL SALDO (real menos previsto)",null,null,{"$f":"J7-J6","v":{"v":20,"d":"20 €"}}]
[]
[null,"ALOJAMIENTO","Costo previsto","Costo real","Diferencia",null,"ENTRETENIMIENTO","Costo previsto","Costo real","Diferencia"]
[null,"Hipoteca o arrendamiento",{"v":1500,"d":"$1,500"},{"v":1400,"d":"$1,400"},{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":100,"d":"$100"}},null,"Video y DVD",{"v":0,"d":"$0"},{"v":50,"d":"$50"},{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":-50,"d":"-$50"}}]
[null,"Teléfono",{"v":60,"d":"$60"},{"v":100,"d":"$100"},{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":-40,"d":"-$40"}},null,"CD",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Electricidad",{"v":50,"d":"$50"},{"v":60,"d":"$60"},{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":-10,"d":"-$10"}},null,"Películas",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Combustible",{"v":200,"d":"$200"},{"v":180,"d":"$180"},{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":20,"d":"$20"}},null,"Conciertos",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Agua y drenaje",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Eventos deportivos",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Televisión por cable",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Teatro",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Eliminación de residuos",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Mantenimiento o reparaciones",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Suministros",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"Entretenimiento[[#This Row],[Costo previsto]]-Entretenimiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Otros",null,null,{"$f":"Alojamiento[[#This Row],[Costo previsto]]-Alojamiento[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Entretenimiento[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Entretenimiento[Costo real])","v":{"v":50,"d":"$50"}},{"$f":"SUBTOTAL(109,Entretenimiento[Diferencia])","v":{"v":-50,"d":"-$50"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Alojamiento[Costo previsto])","v":{"v":1810,"d":"$1,810"}},{"$f":"SUBTOTAL(109,Alojamiento[Costo real])","v":{"v":1740,"d":"$1,740"}},{"$f":"SUBTOTAL(109,Alojamiento[Diferencia])","v":{"v":70,"d":"$70"}}]
[{"$nulls":6},"PRÉSTAMOS","Costo previsto","Costo real","Diferencia"]
[null,"TRANSPORTE","Costo previsto","Costo real","Diferencia",null,"Personal",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Pago del vehículo",{"v":250,"d":"$250"},{"v":250,"d":"$250"},{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Estudiante",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Gastos de autobús y taxi",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Tarjeta de crédito",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Seguro",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Tarjeta de crédito",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Licencias",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Tarjeta de crédito",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Combustible",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"Préstamos[[#This Row],[Costo previsto]]-Préstamos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Mantenimiento",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Préstamos[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Préstamos[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Préstamos[Diferencia])","v":{"v":0,"d":"$0"}}]
[null,"Otros",null,null,{"$f":"Transporte[[#This Row],[Costo previsto]]-Transporte[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Transporte[Costo previsto])","v":{"v":250,"d":"$250"}},{"$f":"SUBTOTAL(109,Transporte[Costo real])","v":{"v":250,"d":"$250"}},{"$f":"SUBTOTAL(109,Transporte[Diferencia])","v":{"v":0,"d":"$0"}},null,"IMPUESTOS","Costo previsto","Costo real","Diferencia"]
[{"$nulls":6},"Federales",null,null,{"$f":"Impuestos[[#This Row],[Costo previsto]]-Impuestos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"SEGURO","Costo previsto","Costo real","Diferencia",null,"Estatales",null,null,{"$f":"Impuestos[[#This Row],[Costo previsto]]-Impuestos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Hogar",null,null,{"$f":"Seguro[[#This Row],[Costo previsto]]-Seguro[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Locales",null,null,{"$f":"Impuestos[[#This Row],[Costo previsto]]-Impuestos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Salud",null,null,{"$f":"Seguro[[#This Row],[Costo previsto]]-Seguro[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"Impuestos[[#This Row],[Costo previsto]]-Impuestos[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Vida",null,null,{"$f":"Seguro[[#This Row],[Costo previsto]]-Seguro[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Impuestos[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Impuestos[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Impuestos[Diferencia])","v":{"v":0,"d":"$0"}}]
[null,"Otros",null,null,{"$f":"Seguro[[#This Row],[Costo previsto]]-Seguro[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Seguro[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Seguro[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Seguro[Diferencia])","v":{"v":0,"d":"$0"}},null,"AHORROS O INVERSIONES","Costo previsto","Costo real","Diferencia"]
[{"$nulls":6},"Cuenta de jubilación",null,null,{"$f":"AhorrosOInversiones[[#This Row],[Costo previsto]]-AhorrosOInversiones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"COMIDA","Costo previsto","Costo real","Diferencia",null,"Cuenta de inversión",null,null,{"$f":"AhorrosOInversiones[[#This Row],[Costo previsto]]-AhorrosOInversiones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Alimentos",null,null,{"$f":"Comida[[#This Row],[Costo previsto]]-Comida[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Otros",null,null,{"$f":"AhorrosOInversiones[[#This Row],[Costo previsto]]-AhorrosOInversiones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Restaurantes",null,null,{"$f":"Comida[[#This Row],[Costo previsto]]-Comida[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,AhorrosOInversiones[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,AhorrosOInversiones[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,AhorrosOInversiones[Diferencia])","v":{"v":0,"d":"$0"}}]
[null,"Otros",null,null,{"$f":"Comida[[#This Row],[Costo previsto]]-Comida[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Comida[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Comida[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Comida[Diferencia])","v":{"v":0,"d":"$0"}},null,"REGALOS Y DONACIONES","Costo previsto","Costo real","Diferencia"]
[{"$nulls":6},"Organización benéfica 1",null,null,{"$f":"RegalosYDonaciones[[#This Row],[Costo previsto]]-RegalosYDonaciones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"MASCOTAS","Costo previsto","Costo real","Diferencia",null,"Organización benéfica 2",null,null,{"$f":"RegalosYDonaciones[[#This Row],[Costo previsto]]-RegalosYDonaciones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Comida",null,null,{"$f":"Mascotas[[#This Row],[Costo previsto]]-Mascotas[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Organización benéfica 3",null,null,{"$f":"RegalosYDonaciones[[#This Row],[Costo previsto]]-RegalosYDonaciones[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Médicos",null,null,{"$f":"Mascotas[[#This Row],[Costo previsto]]-Mascotas[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,RegalosYDonaciones[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,RegalosYDonaciones[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,RegalosYDonaciones[Diferencia])","v":{"v":0,"d":"$0"}}]
[null,"Limpieza",null,null,{"$f":"Mascotas[[#This Row],[Costo previsto]]-Mascotas[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Juguetes",null,null,{"$f":"Mascotas[[#This Row],[Costo previsto]]-Mascotas[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"LEGAL","Costo previsto","Costo real","Diferencia"]
[null,"Otros",null,null,{"$f":"Mascotas[[#This Row],[Costo previsto]]-Mascotas[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Abogados",null,null,{"$f":"Legal[[#This Row],[Costo previsto]]-Legal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Mascotas[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Mascotas[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Mascotas[Diferencia])","v":{"v":0,"d":"$0"}},null,"Pensión alimenticia",null,null,{"$f":"Legal[[#This Row],[Costo previsto]]-Legal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[{"$nulls":6},"Pagos por retención o fallo",null,null,{"$f":"Legal[[#This Row],[Costo previsto]]-Legal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"CUIDADO PERSONAL","Costo previsto","Costo real","Diferencia",null,"Otros",null,null,{"$f":"Legal[[#This Row],[Costo previsto]]-Legal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Médicos",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}},null,"Total",{"$f":"SUBTOTAL(109,Legal[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Legal[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,Legal[Diferencia])","v":{"v":0,"d":"$0"}}]
[null,"Cabello y uñas",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Ropa",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Tintorería",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Gimnasio",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Tasas o cuotas de la organización",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Otros",null,null,{"$f":"CuidadoPersonal[[#This Row],[Costo previsto]]-CuidadoPersonal[[#This Row],[Costo real]]","v":{"v":0,"d":"$0"}}]
[null,"Total",{"$f":"SUBTOTAL(109,CuidadoPersonal[Costo previsto])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,CuidadoPersonal[Costo real])","v":{"v":0,"d":"$0"}},{"$f":"SUBTOTAL(109,CuidadoPersonal[Diferencia])","v":{"v":0,"d":"$0"}}]