{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Presupuesto para la boda","Detalles del presupuesto"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Presupuesto para la boda","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"CARLOTA + FEDERICO\nENLACE MATRIMONIAL"]
[]
[]
[null,"CATEGORÍA","COSTE ESTIMADO","COSTE REAL","VARIANZA","PRESUPUESTO %",{"$nulls":3},"Sin ordenar","Costes estimados","Costes reales","Coste estimado - valor de rango","Rango","N.º","Ordenado"]
[null,{"$f":"P6","v":"Recepción"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"14,500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"12,800 €"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":{"v":1700,"d":"1,700 €"}},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Recepción",{"$f":"TBL_Reception[[#Totals],[ESTIMADO]]","v":14500},{"$f":"TBL_Reception[[#Totals],[REAL]]","v":12800},{"$f":"K6-O6/100","v":14499.99},{"$f":"_xlfn.RANK.AVG(M6,$M$6:$M$15)","v":1},1,{"$f":"INDEX(TBL_RankingData,MATCH(O6,$N$6:$N$15,0),1)","v":"Recepción"}]
[null,{"$f":"P7","v":"Atuendo"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"4,000 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"2,900 €"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":{"v":1100,"d":"1,100 €"}},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Atuendo",{"$f":"TBL_Attire[[#Totals],[ESTIMADO]]","v":4000},{"$f":"TBL_Attire[[#Totals],[REAL]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Atuendo"]
[null,"Flores y decoración",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"3,000 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Flores y decoración",{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMADO]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[REAL]]","v":0},2999.97,3,3,"Flores y decoración"]
[null,"Fotografías y vídeo",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"2,500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Música",{"$f":"TBL_Music[[#Totals],[ESTIMADO]]","v":1800},{"$f":"TBL_Music[[#Totals],[REAL]]","v":0},1799.96,5,4,"Fotografías y vídeo"]
[null,"Música",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"1,800 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Fotografías y vídeo",{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMADO]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[REAL]]","v":0},2499.95,4,5,"Música"]
[null,"Detalles y regalos",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Detalles y regalos",{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMADO]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[REAL]]","v":0},1099.94,6,6,"Detalles y regalos"]
[null,{"$f":"P12","v":"Anillos de boda"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Ceremonia",{"$f":"TBL_Ceremony[[#Totals],[ESTIMADO]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[REAL]]","v":0},799.93,8,7,"Anillos de boda"]
[null,{"$f":"P13","v":"Ceremonia"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"800 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Papelería",{"$f":"TBL_Stationery[[#Totals],[ESTIMADO]]","v":500},{"$f":"TBL_Stationery[[#Totals],[REAL]]","v":0},499.92,9,8,"Ceremonia"]
[null,{"$f":"P14","v":"Papelería"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Anillos de boda",{"$f":"TBL_WeddingRings[[#Totals],[ESTIMADO]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[REAL]]","v":0},1099.91,7,9,"Papelería"]
[null,{"$f":"P15","v":"Transporte"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"450 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORÍA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[COSTE ESTIMADO]]=\"\",TBL_Summary[[#This Row],[COSTE REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[COSTE ESTIMADO]]-TBL_Summary[[#This Row],[COSTE REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[COSTE ESTIMADO]]/SUM(TBL_Summary[COSTE ESTIMADO])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Transporte",{"$f":"TBL_Transportation[[#Totals],[ESTIMADO]]","v":450},{"$f":"TBL_Transportation[[#Totals],[REAL]]","v":0},449.9,10,10,"Transporte"]
[null,"Total",{"$f":"SUBTOTAL(109,TBL_Summary[COSTE ESTIMADO])","v":{"v":29750,"d":"29,750 €"}},{"$f":"SUBTOTAL(109,TBL_Summary[COSTE REAL])","v":{"v":15700,"d":"15,700 €"}},{"$f":"TBL_Summary[[#Totals],[COSTE ESTIMADO]]-TBL_Summary[[#Totals],[COSTE REAL]]","v":{"v":14050,"d":"14,050 €"}},{"$f":"SUBTOTAL(109,TBL_Summary[PRESUPUESTO %])","v":{"v":1,"d":"100%"}}]

{"sheet":"Detalles del presupuesto","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"DETALLES DEL PRESUPUESTO"]
[]
[null,"RECEPCIÓN","ESTIMADO","REAL","VARIANZA"]
[null,"Recinto y alquiler",{"v":8000,"d":"8,000.00 €"},{"v":7800,"d":"7,800.00 €"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMADO]]=\"\",TBL_Reception[[#This Row],[REAL]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMADO]]-TBL_Reception[[#This Row],[REAL]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Comidas y servicio",{"v":4000,"d":"4,000.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMADO]]=\"\",TBL_Reception[[#This Row],[REAL]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMADO]]-TBL_Reception[[#This Row],[REAL]])","v":{"v":-200,"d":"-200.00 €"}}]
[null,"Bebidas",{"v":1000,"d":"1,000.00 €"},{"v":800,"d":"800.00 €"},{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMADO]]=\"\",TBL_Reception[[#This Row],[REAL]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMADO]]-TBL_Reception[[#This Row],[REAL]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Tarta",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMADO]]=\"\",TBL_Reception[[#This Row],[REAL]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMADO]]-TBL_Reception[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Reception[[#This Row],[ESTIMADO]]=\"\",TBL_Reception[[#This Row],[REAL]]=\"\"),\"\",TBL_Reception[[#This Row],[ESTIMADO]]-TBL_Reception[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE RECEPCIÓN",{"$f":"SUBTOTAL(109,TBL_Reception[ESTIMADO])","v":{"v":14500,"d":"14,500.00 €"}},{"$f":"SUBTOTAL(109,TBL_Reception[REAL])","v":{"v":12800,"d":"12,800.00 €"}},{"$f":"TBL_Reception[[#Totals],[ESTIMADO]]-TBL_Reception[[#Totals],[REAL]]","v":{"v":1700,"d":"1,700.00 €"}}]
[]
[]
[null,"ATUENDO","ESTIMADO","REAL","VARIANZA"]
[null,"Esmoquin, traje o vestidos",{"v":3000,"d":"3,000.00 €"},{"v":2900,"d":"2,900.00 €"},{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":{"v":100,"d":"100.00 €"}}]
[null,"Arreglos",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":""}]
[null,"Tocado y velo",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":""}]
[null,"Accesorios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":""}]
[null,"Peluquería y maquillaje",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Attire[[#This Row],[ESTIMADO]]=\"\",TBL_Attire[[#This Row],[REAL]]=\"\"),\"\",TBL_Attire[[#This Row],[ESTIMADO]]-TBL_Attire[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE ATUENDO",{"$f":"SUBTOTAL(109,TBL_Attire[ESTIMADO])","v":{"v":4000,"d":"4,000.00 €"}},{"$f":"SUBTOTAL(109,TBL_Attire[REAL])","v":{"v":2900,"d":"2,900.00 €"}},{"$f":"TBL_Attire[[#Totals],[ESTIMADO]]-TBL_Attire[[#Totals],[REAL]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"FLORES & DECORACIÓN","ESTIMADO","REAL","VARIANZA"]
[null,"Arreglos florales para la ceremonia",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Flores y canastilla de la niña",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Cojín para alianzas",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Ramos",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Flores para el ojal",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Ramilletes",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Decoración de recepción",{"v":300,"d":"300.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Iluminación",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]=\"\",TBL_FlowersAndDecor[[#This Row],[REAL]]=\"\"),\"\",TBL_FlowersAndDecor[[#This Row],[ESTIMADO]]-TBL_FlowersAndDecor[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE FLORES & DECORACIÓN",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[ESTIMADO])","v":{"v":3000,"d":"3,000.00 €"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMADO]]-TBL_FlowersAndDecor[[#Totals],[REAL]]","v":{"v":3000,"d":"3,000.00 €"}}]
[]
[]
[null,"MÚSICA","ESTIMADO","REAL","VARIANZA"]
[null,"Músicos para la ceremonia",{"v":700,"d":"700.00 €"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMADO]]=\"\",TBL_Music[[#This Row],[REAL]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMADO]]-TBL_Music[[#This Row],[REAL]])","v":""}]
[null,"Músicos para el cóctel",{"v":300,"d":"300.00 €"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMADO]]=\"\",TBL_Music[[#This Row],[REAL]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMADO]]-TBL_Music[[#This Row],[REAL]])","v":""}]
[null,"Banda, DJ o entretenimiento para la recepción",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMADO]]=\"\",TBL_Music[[#This Row],[REAL]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMADO]]-TBL_Music[[#This Row],[REAL]])","v":""}]
[null,"Sistema de sonido o alquiler de pista de baile",{"v":400,"d":"400.00 €"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMADO]]=\"\",TBL_Music[[#This Row],[REAL]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMADO]]-TBL_Music[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Music[[#This Row],[ESTIMADO]]=\"\",TBL_Music[[#This Row],[REAL]]=\"\"),\"\",TBL_Music[[#This Row],[ESTIMADO]]-TBL_Music[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE MÚSICA",{"$f":"SUBTOTAL(109,TBL_Music[ESTIMADO])","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"SUBTOTAL(109,TBL_Music[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Music[[#Totals],[ESTIMADO]]-TBL_Music[[#Totals],[REAL]]","v":{"v":1800,"d":"1,800.00 €"}}]
[]
[]
[null,"VÍDEO & FOTOGRAFÍA","ESTIMADO","REAL","VARIANZA"]
[null,"Fotografía",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]=\"\",TBL_PhotographsAndVideo[[#This Row],[REAL]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]-TBL_PhotographsAndVideo[[#This Row],[REAL]])","v":""}]
[null,"Vídeo",{"v":800,"d":"800.00 €"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]=\"\",TBL_PhotographsAndVideo[[#This Row],[REAL]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]-TBL_PhotographsAndVideo[[#This Row],[REAL]])","v":""}]
[null,"Copias adicionales y álbumes",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]=\"\",TBL_PhotographsAndVideo[[#This Row],[REAL]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]-TBL_PhotographsAndVideo[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]=\"\",TBL_PhotographsAndVideo[[#This Row],[REAL]]=\"\"),\"\",TBL_PhotographsAndVideo[[#This Row],[ESTIMADO]]-TBL_PhotographsAndVideo[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE VÍDEO & FOTOGRAFÍA",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[ESTIMADO])","v":{"v":2500,"d":"2,500.00 €"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMADO]]-TBL_PhotographsAndVideo[[#Totals],[REAL]]","v":{"v":2500,"d":"2,500.00 €"}}]
[]
[]
[null,"RECUERDOS & REGALOS","ESTIMADO","REAL","VARIANZA"]
[null,"Regalos de bienvenida",{"v":700,"d":"700.00 €"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]=\"\",TBL_FavorsAndGifts[[#This Row],[REAL]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]-TBL_FavorsAndGifts[[#This Row],[REAL]])","v":""}]
[null,"Regalos de la fiesta",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]=\"\",TBL_FavorsAndGifts[[#This Row],[REAL]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]-TBL_FavorsAndGifts[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]=\"\",TBL_FavorsAndGifts[[#This Row],[REAL]]=\"\"),\"\",TBL_FavorsAndGifts[[#This Row],[ESTIMADO]]-TBL_FavorsAndGifts[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE RECUERDOS & REGALOS",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[ESTIMADO])","v":{"v":1100,"d":"1,100.00 €"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMADO]]-TBL_FavorsAndGifts[[#Totals],[REAL]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"CEREMONIA","ESTIMADO","REAL","VARIANZA"]
[null,"Cuota de sitio",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMADO]]=\"\",TBL_Ceremony[[#This Row],[REAL]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMADO]]-TBL_Ceremony[[#This Row],[REAL]])","v":""}]
[null,"Honorarios del oficiante o donativo a iglesia",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMADO]]=\"\",TBL_Ceremony[[#This Row],[REAL]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMADO]]-TBL_Ceremony[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Ceremony[[#This Row],[ESTIMADO]]=\"\",TBL_Ceremony[[#This Row],[REAL]]=\"\"),\"\",TBL_Ceremony[[#This Row],[ESTIMADO]]-TBL_Ceremony[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE LA CEREMONIA",{"$f":"SUBTOTAL(109,TBL_Ceremony[ESTIMADO])","v":{"v":800,"d":"800.00 €"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Ceremony[[#Totals],[ESTIMADO]]-TBL_Ceremony[[#Totals],[REAL]]","v":{"v":800,"d":"800.00 €"}}]
[]
[]
[null,"CORTEJO","ESTIMADO","REAL","VARIANZA"]
[null,"Tarjetas de invitación",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Invitaciones y confirmaciones de asistencia",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Programas",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Tarjetas de asiento y colocación",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Tarjetas de menú",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Notas de agradecimiento",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Gastos de envío",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Stationery[[#This Row],[ESTIMADO]]=\"\",TBL_Stationery[[#This Row],[REAL]]=\"\"),\"\",TBL_Stationery[[#This Row],[ESTIMADO]]-TBL_Stationery[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE CORTEJO",{"$f":"SUBTOTAL(109,TBL_Stationery[ESTIMADO])","v":{"v":500,"d":"500.00 €"}},{"$f":"SUBTOTAL(109,TBL_Stationery[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Stationery[[#Totals],[ESTIMADO]]-TBL_Stationery[[#Totals],[REAL]]","v":{"v":500,"d":"500.00 €"}}]
[]
[]
[null,"ANILLOS DE BODA","ESTIMADO","REAL","VARIANZA"]
[null,"Alianzas",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[ESTIMADO]]=\"\",TBL_WeddingRings[[#This Row],[REAL]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[ESTIMADO]]-TBL_WeddingRings[[#This Row],[REAL]])","v":""}]
[null,"Accesorios de anillos",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_WeddingRings[[#This Row],[ESTIMADO]]=\"\",TBL_WeddingRings[[#This Row],[REAL]]=\"\"),\"\",TBL_WeddingRings[[#This Row],[ESTIMADO]]-TBL_WeddingRings[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE ANILLOS DE BODA",{"$f":"SUBTOTAL(109,TBL_WeddingRings[ESTIMADO])","v":{"v":1100,"d":"1,100.00 €"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_WeddingRings[[#Totals],[ESTIMADO]]-TBL_WeddingRings[[#Totals],[REAL]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"TRANSPORTE  ","ESTIMADO","REAL","VARIANZA"]
[null,"Alquiler de coche principal",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMADO]]=\"\",TBL_Transportation[[#This Row],[REAL]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMADO]]-TBL_Transportation[[#This Row],[REAL]])","v":""}]
[null,"Alquiler de coche para invitados",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMADO]]=\"\",TBL_Transportation[[#This Row],[REAL]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMADO]]-TBL_Transportation[[#This Row],[REAL]])","v":""}]
[null,"Transporte para invitados de fuera de la ciudad",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMADO]]=\"\",TBL_Transportation[[#This Row],[REAL]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMADO]]-TBL_Transportation[[#This Row],[REAL]])","v":""}]
[null,"Servicio de estacionamiento",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMADO]]=\"\",TBL_Transportation[[#This Row],[REAL]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMADO]]-TBL_Transportation[[#This Row],[REAL]])","v":""}]
[null,"Gastos varios",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transportation[[#This Row],[ESTIMADO]]=\"\",TBL_Transportation[[#This Row],[REAL]]=\"\"),\"\",TBL_Transportation[[#This Row],[ESTIMADO]]-TBL_Transportation[[#This Row],[REAL]])","v":""}]
[null,"TOTAL DE TRANSPORTE",{"$f":"SUBTOTAL(109,TBL_Transportation[ESTIMADO])","v":{"v":450,"d":"450.00 €"}},{"$f":"SUBTOTAL(109,TBL_Transportation[REAL])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Transportation[[#Totals],[ESTIMADO]]-TBL_Transportation[[#Totals],[REAL]]","v":{"v":450,"d":"450.00 €"}}]