{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Orçamento do Casamento","Detalhes do Orçamento"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Orçamento do Casamento","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"KAYLA + JACOB\nCASAMENTO"]
[]
[]
[null,"CATEGORIA","CUSTO ESTIMADO","CUSTO REAL","VARIAÇÃO","% DO ORÇAMENTO",{"$nulls":3},"Não classificado","Custos Estimados","Custos Reais","Valor Estimado - Posição na Classificação","Classificação","#","Selecionados"]
[null,{"$f":"P6","v":"Recepção"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"R$ 14,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"R$ 12,800"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":{"v":1700,"d":"R$ 1,700"}},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Recepção",{"$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":"Recepção"}]
[null,{"$f":"P7","v":"Vestimenta"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"R$ 4,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"R$ 2,900"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":{"v":1100,"d":"R$ 1,100"}},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Vestimenta",{"$f":"TBL_Attire[[#Totals],[ESTIMADO]]","v":4000},{"$f":"TBL_Attire[[#Totals],[REAL]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Vestimenta"]
[null,"Flores e decorações",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"R$ 3,000"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Flores e decorações",{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMADO]]","v":3000},{"$f":"TBL_FlowersAndDecor[[#Totals],[REAL]]","v":0},2999.97,3,3,"Flores e decorações"]
[null,"Fotografias e vídeo",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"R$ 2,500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO 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,"Fotografias e vídeo"]
[null,"Música",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"R$ 1,800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Fotografias e vídeo",{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMADO]]","v":2500},{"$f":"TBL_PhotographsAndVideo[[#Totals],[REAL]]","v":0},2499.95,4,5,"Música"]
[null,"Favores e presentes",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"R$ 1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Favores e presentes",{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMADO]]","v":1100},{"$f":"TBL_FavorsAndGifts[[#Totals],[REAL]]","v":0},1099.94,6,6,"Favores e presentes"]
[null,{"$f":"P12","v":"Alianças de casamento"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"R$ 1,100"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Cerimônia",{"$f":"TBL_Ceremony[[#Totals],[ESTIMADO]]","v":800},{"$f":"TBL_Ceremony[[#Totals],[REAL]]","v":0},799.93,8,7,"Alianças de casamento"]
[null,"Cerimônia",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"R$ 800"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Papelaria",{"$f":"TBL_Stationery[[#Totals],[ESTIMADO]]","v":500},{"$f":"TBL_Stationery[[#Totals],[REAL]]","v":0},499.92,9,8,"Cerimônia"]
[null,"Papelaria",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"R$ 500"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO ESTIMADO])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Alianças de casamento",{"$f":"TBL_WeddingRings[[#Totals],[ESTIMADO]]","v":1100},{"$f":"TBL_WeddingRings[[#Totals],[REAL]]","v":0},1099.91,7,9,"Papelaria"]
[null,"Transporte",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"R$ 450"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[CATEGORIA]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[CUSTO ESTIMADO]]=\"\",TBL_Summary[[#This Row],[CUSTO REAL]]=\"\"),\"\",TBL_Summary[[#This Row],[CUSTO ESTIMADO]]-TBL_Summary[[#This Row],[CUSTO REAL]])","v":""},{"$f":"TBL_Summary[[#This Row],[CUSTO ESTIMADO]]/SUM(TBL_Summary[CUSTO 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[CUSTO ESTIMADO])","v":{"v":29750,"d":"R$ 29,750"}},{"$f":"SUBTOTAL(109,TBL_Summary[CUSTO REAL])","v":{"v":15700,"d":"R$ 15,700"}},{"$f":"TBL_Summary[[#Totals],[CUSTO ESTIMADO]]-TBL_Summary[[#Totals],[CUSTO REAL]]","v":{"v":14050,"d":"R$ 14,050"}},{"$f":"SUBTOTAL(109,TBL_Summary[% DO ORÇAMENTO])","v":{"v":1,"d":"100%"}}]

{"sheet":"Detalhes do Orçamento","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"DETALHES DO ORÇAMENTO"]
[]
[null,"RECEPÇÃO","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Local e locações",{"v":8000,"d":"R$ 8,000.00"},{"v":7800,"d":"R$ 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":"R$ 200.00"}}]
[null,"Comida e serviço",{"v":4000,"d":"R$ 4,000.00"},{"v":4200,"d":"R$ 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":"-R$ 200.00"}}]
[null,"Bebidas",{"v":1000,"d":"R$ 1,000.00"},{"v":800,"d":"R$ 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":"R$ 200.00"}}]
[null,"Bolo",{"v":1000,"d":"R$ 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,"Taxas diversas",{"v":500,"d":"R$ 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 DA FESTA",{"$f":"SUBTOTAL(109,TBL_Reception[ESTIMADO])","v":{"v":14500,"d":"R$ 14,500.00"}},{"$f":"SUBTOTAL(109,TBL_Reception[REAL])","v":{"v":12800,"d":"R$ 12,800.00"}},{"$f":"TBL_Reception[[#Totals],[ESTIMADO]]-TBL_Reception[[#Totals],[REAL]]","v":{"v":1700,"d":"R$ 1,700.00"}}]
[]
[]
[null,"VESTIMENTA","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Smoking, terno e/ou vestidos",{"v":3000,"d":"R$ 3,000.00"},{"v":2900,"d":"R$ 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":"R$ 100.00"}}]
[null,"Alterações",{"v":100,"d":"R$ 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,"Véu e grinalda",{"v":200,"d":"R$ 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,"Acessórios",{"v":100,"d":"R$ 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,"Cabelo e maquiagem",{"v":500,"d":"R$ 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,"Taxas diversas",{"v":100,"d":"R$ 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 COM VESTIMENTA",{"$f":"SUBTOTAL(109,TBL_Attire[ESTIMADO])","v":{"v":4000,"d":"R$ 4,000.00"}},{"$f":"SUBTOTAL(109,TBL_Attire[REAL])","v":{"v":2900,"d":"R$ 2,900.00"}},{"$f":"TBL_Attire[[#Totals],[ESTIMADO]]-TBL_Attire[[#Totals],[REAL]]","v":{"v":1100,"d":"R$ 1,100.00"}}]
[]
[]
[null,"FLORES E DECORAÇÕES","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Arranjos florais para cerimônia",{"v":1000,"d":"R$ 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,"Botões e Cesta da dama de honra",{"v":500,"d":"R$ 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,"Almofada dos anéis",{"v":100,"d":"R$ 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,"Buquês",{"v":500,"d":"R$ 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 de lapela",{"v":100,"d":"R$ 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,"Corpetes",{"v":200,"d":"R$ 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,"Decoração da recepção",{"v":300,"d":"R$ 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,"Iluminação",{"v":200,"d":"R$ 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,"Taxas diversas",{"v":100,"d":"R$ 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 E DECORAÇÕES",{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[ESTIMADO])","v":{"v":3000,"d":"R$ 3,000.00"}},{"$f":"SUBTOTAL(109,TBL_FlowersAndDecor[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_FlowersAndDecor[[#Totals],[ESTIMADO]]-TBL_FlowersAndDecor[[#Totals],[REAL]]","v":{"v":3000,"d":"R$ 3,000.00"}}]
[]
[]
[null,"MÚSICA","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Músicos da cerimônia",{"v":700,"d":"R$ 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 da hora do coquetel",{"v":300,"d":"R$ 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 da recepção, DJ ou entretenimento",{"v":200,"d":"R$ 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,"Aluguel de sistema de som ou de pista de dança",{"v":400,"d":"R$ 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,"Taxas diversas",{"v":200,"d":"R$ 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ÚSICAS",{"$f":"SUBTOTAL(109,TBL_Music[ESTIMADO])","v":{"v":1800,"d":"R$ 1,800.00"}},{"$f":"SUBTOTAL(109,TBL_Music[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_Music[[#Totals],[ESTIMADO]]-TBL_Music[[#Totals],[REAL]]","v":{"v":1800,"d":"R$ 1,800.00"}}]
[]
[]
[null,"FOTOGRAFIA E VÍDEO","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Fotografia",{"v":1000,"d":"R$ 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,"Videografia",{"v":800,"d":"R$ 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,"Impressões e álbuns adicionais",{"v":500,"d":"R$ 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,"Taxas diversas",{"v":200,"d":"R$ 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 FOTOGRAFIA E VÍDEO",{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[ESTIMADO])","v":{"v":2500,"d":"R$ 2,500.00"}},{"$f":"SUBTOTAL(109,TBL_PhotographsAndVideo[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_PhotographsAndVideo[[#Totals],[ESTIMADO]]-TBL_PhotographsAndVideo[[#Totals],[REAL]]","v":{"v":2500,"d":"R$ 2,500.00"}}]
[]
[]
[null,"FAVORES E PRESENTES","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Presentes de boas-vindas",{"v":700,"d":"R$ 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,"Presentes de festa",{"v":200,"d":"R$ 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,"Taxas diversas",{"v":200,"d":"R$ 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 FAVORES E PRESENTES",{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[ESTIMADO])","v":{"v":1100,"d":"R$ 1,100.00"}},{"$f":"SUBTOTAL(109,TBL_FavorsAndGifts[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_FavorsAndGifts[[#Totals],[ESTIMADO]]-TBL_FavorsAndGifts[[#Totals],[REAL]]","v":{"v":1100,"d":"R$ 1,100.00"}}]
[]
[]
[null,"CERIMÔNIA","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Pagamento do local",{"v":500,"d":"R$ 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,"Pagamento do sacerdote ou doação à igreja",{"v":200,"d":"R$ 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,"Taxas diversas",{"v":100,"d":"R$ 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 DA CERIMÔNIA",{"$f":"SUBTOTAL(109,TBL_Ceremony[ESTIMADO])","v":{"v":800,"d":"R$ 800.00"}},{"$f":"SUBTOTAL(109,TBL_Ceremony[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_Ceremony[[#Totals],[ESTIMADO]]-TBL_Ceremony[[#Totals],[REAL]]","v":{"v":800,"d":"R$ 800.00"}}]
[]
[]
[null,"ARTIGOS DE PAPELARIA","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Cartões de lembrete",{"v":50,"d":"R$ 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,"Convites e RSVPs",{"v":100,"d":"R$ 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":"R$ 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,"Assentos e cartões de lugar",{"v":50,"d":"R$ 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,"Cartões de menu",{"v":50,"d":"R$ 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 agradecimento",{"v":50,"d":"R$ 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,"Postagem",{"v":50,"d":"R$ 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,"Taxas diversas",{"v":100,"d":"R$ 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 ITENS DE PAPELARIA",{"$f":"SUBTOTAL(109,TBL_Stationery[ESTIMADO])","v":{"v":500,"d":"R$ 500.00"}},{"$f":"SUBTOTAL(109,TBL_Stationery[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_Stationery[[#Totals],[ESTIMADO]]-TBL_Stationery[[#Totals],[REAL]]","v":{"v":500,"d":"R$ 500.00"}}]
[]
[]
[null,"ALIANÇAS DE CASAMENTO","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Alianças de casamento",{"v":1000,"d":"R$ 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,"Acessórios do anel",{"v":100,"d":"R$ 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 ALIANÇAS DE CASAMENTO",{"$f":"SUBTOTAL(109,TBL_WeddingRings[ESTIMADO])","v":{"v":1100,"d":"R$ 1,100.00"}},{"$f":"SUBTOTAL(109,TBL_WeddingRings[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_WeddingRings[[#Totals],[ESTIMADO]]-TBL_WeddingRings[[#Totals],[REAL]]","v":{"v":1100,"d":"R$ 1,100.00"}}]
[]
[]
[null,"TRANSPORTE  ","ESTIMADO","REAL","VARIAÇÃO"]
[null,"Aluguel de Carro principal",{"v":100,"d":"R$ 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,"Aluguel de Carro dos convidados",{"v":100,"d":"R$ 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,"Transportes para convidados de fora da cidade",{"v":100,"d":"R$ 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,"Estacionamento com manobrista",{"v":50,"d":"R$ 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,"Taxas diversas",{"v":100,"d":"R$ 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":"R$ 450.00"}},{"$f":"SUBTOTAL(109,TBL_Transportation[REAL])","v":{"v":0,"d":"R$ 0.00"}},{"$f":"TBL_Transportation[[#Totals],[ESTIMADO]]-TBL_Transportation[[#Totals],[REAL]]","v":{"v":450,"d":"R$ 450.00"}}]