{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Resumen de presupuesto","Detalles del presupuesto"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Resumen de presupuesto","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"PRESUPUESTO TOTAL PARA LA BODA",{"v":20000,"d":"20,000 €"}]
[]
[null,"GASTOS","Asignación \n%","Presupuesto asignado","Estimado \nCostes","Real \nCostes"]
[null,"Recepción",{"v":0.5,"d":"50%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C6","v":{"v":10000,"d":"10,000 €"}},{"$f":"Table_Reception[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Reception[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Atuendo",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C7","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_Attire[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Attire[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Flores y decoración",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C8","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_FlowersAndDecorations[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Música",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C9","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_Music[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Music[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Fotografías y vídeo",{"v":0.1,"d":"10%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C10","v":{"v":2000,"d":"2,000 €"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_PhotographsAndVideo[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Detalles y regalos",{"v":0.03,"d":"3%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C11","v":{"v":600,"d":"600 €"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_FavorsAndGifts[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Ceremonia",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C12","v":{"v":400,"d":"400 €"}},{"$f":"Table_Ceremony[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Ceremony[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Papelería",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C13","v":{"v":400,"d":"400 €"}},{"$f":"Table_Stationery[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Stationery[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Alianzas",{"v":0.02,"d":"2%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C14","v":{"v":400,"d":"400 €"}},{"$f":"Table_WeddingRings[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_WeddingRings[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Transporte",{"v":0.01,"d":"1%"},{"$f":"Total_Wedding_Budget*'Resumen de presupuesto'!$C15","v":{"v":200,"d":"200 €"}},{"$f":"Table_Transportation[[#Totals],[Costes estimados]]","v":{"v":0,"d":"0 €"}},{"$f":"Table_Transportation[[#Totals],[Costes reales]]","v":{"v":0,"d":"0 €"}}]
[null,"Total",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"20,000 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[]
[null,"CONTRIBUCIONES"]
[null,"Origen de fondos","Contribución"]
[null,"Ahorros",{"v":10000,"d":"10,000 €"}]
[null,"Padre y madre de cónyuge 1",{"v":4000,"d":"4,000 €"}]
[null,"Abuelos del cónyuge 1",{"v":2000,"d":"2,000 €"}]
[null,"Padre y madre de cónyuge 2",{"v":4000,"d":"4,000 €"}]
[null,"Abuelos del cónyuge 2",{"v":4000,"d":"4,000 €"}]
[null,"Otras contribuciones",{"v":2000,"d":"2,000 €"}]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Contributions[Contribución])","v":{"v":26000,"d":"26,000 €"}}]
[]
[null,{"$f":"IF(Table_Contributions[[#Totals],[Contribución]]<Total_Wedding_Budget,\"Diferencia para compensar\",\"Fondos extras disponibles\")","v":"Fondos extras disponibles"},{"$f":"IF(Table_Contributions[[#Totals],[Contribución]]<Total_Wedding_Budget,Total_Wedding_Budget-Table_Contributions[[#Totals],[Contribución]],Table_Contributions[[#Totals],[Contribución]]-Total_Wedding_Budget)","v":{"v":6000,"d":"6,000 €"}}]

{"sheet":"Detalles del presupuesto","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"RECEPCIÓN","Costes estimados","Costes reales"]
[null,"Recinto y alquiler"]
[null,"Comidas y servicio"]
[null,"Bebidas"]
[null,"Tarta"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Reception[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Reception[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"ATUENDO","Costes estimados","Costes reales"]
[null,"Esmoquin, traje o vestidos"]
[null,"Arreglos"]
[null,"Tocado y velo"]
[null,"Accesorios"]
[null,"Peluquería y maquillaje"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Attire[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Attire[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FLORES Y ADORNOS","Costes estimados","Costes reales"]
[null,"Arreglos florales para la ceremonia"]
[null,"Flores y canastilla de la niña"]
[null,"Cojín para alianzas"]
[null,"Ramos"]
[null,"Flores para el ojal"]
[null,"Ramilletes"]
[null,"Decoración de recepción"]
[null,"Iluminación"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_FlowersAndDecorations[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"MÚSICA","Costes estimados","Costes reales"]
[null,"Músicos para la ceremonia"]
[null,"Músicos para el cóctel"]
[null,"Banda, DJ o entretenimiento para la recepción"]
[null,"Sistema de sonido o alquiler de pista de baile"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Music[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Music[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FOTOGRAFÍAS Y VÍDEO","Costes estimados","Costes reales"]
[null,"Fotografía"]
[null,"Vídeo"]
[null,"Copias adicionales y álbumes"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_PhotographsAndVideo[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"DETALLES Y REGALOS","Costes estimados","Costes reales"]
[null,"Regalos de bienvenida"]
[null,"Regalos de la fiesta"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_FavorsAndGifts[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"CEREMONIA","Costes estimados","Costes reales"]
[null,"Cuota de sitio"]
[null,"Honorarios del oficiante o donativo a iglesia"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Ceremony[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Ceremony[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"PAPELERÍA","Costes estimados","Costes reales"]
[null,"Tarjetas para reservar las fechas"]
[null,"Invitaciones y confirmaciones de asistencia"]
[null,"Programas"]
[null,"Tarjetas de asiento y colocación"]
[null,"Tarjetas de menú"]
[null,"Notas de agradecimiento"]
[null,"Gastos de envío"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Stationery[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Stationery[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"ALIANZAS","Costes estimados","Costes reales"]
[null,"Alianzas"]
[null,"Accesorios de anillos"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_WeddingRings[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_WeddingRings[Costes reales])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TRANSPORTE","Costes estimados","Costes reales"]
[null,"Alquiler de coche principal"]
[null,"Alquiler de coche para invitados"]
[null,"Transporte para invitados de fuera de la ciudad"]
[null,"Servicio de estacionamiento"]
[null,"Gastos varios"]
[null,"Total",{"$f":"SUBTOTAL(109,Table_Transportation[Costes estimados])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Table_Transportation[Costes reales])","v":{"v":0,"d":"0.00 €"}}]