{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Hochzeitsbudget","Budgetdetails"],"not_rendered":{"charts":1,"images":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Hochzeitsbudget","index":0,"n_rows":16,"n_cols":16,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"KAYLA + JACOB\nHEIRATEN"]
[]
[]
[null,"KATEGORIE","GESCHÄTZTE KOSTEN","TATSÄCHLICHE KOSTEN","ABWEICHUNG","BUDGET %",{"$nulls":3},"Unsortiert","Geschätzte Kosten","Ist-Kosten","Geschätzte Kosten – Rang","Rang","Nr.","Sortiert"]
[null,{"$f":"P6","v":"Empfang"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":14500,"d":"14,500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":{"v":12800,"d":"12,800 €"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":{"v":1700,"d":"1,700 €"}},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.48739495798319327,"d":"48.7%"}},{"$nulls":3},"Empfang",{"$f":"TBL_Empfang[[#Totals],[GESCHÄTZT]]","v":14500},{"$f":"TBL_Empfang[[#Totals],[TATSÄCHLICH]]","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":"Empfang"}]
[null,{"$f":"P7","v":"Bekleidung"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":4000,"d":"4,000 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":{"v":2900,"d":"2,900 €"}},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":{"v":1100,"d":"1,100 €"}},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.13445378151260504,"d":"13.4%"}},{"$nulls":3},"Bekleidung",{"$f":"TBL_Bekleidung[[#Totals],[GESCHÄTZT]]","v":4000},{"$f":"TBL_Bekleidung[[#Totals],[TATSÄCHLICH]]","v":2900},{"$f":"K7-O7/100","v":3999.98},2,2,"Bekleidung"]
[null,"Blumen und Dekorationen",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":3000,"d":"3,000 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.10084033613445378,"d":"10.1%"}},{"$nulls":3},"Blumen und Dekorationen",{"$f":"TBL_BlumenUndDekorationen[[#Totals],[GESCHÄTZT]]","v":3000},{"$f":"TBL_BlumenUndDekorationen[[#Totals],[TATSÄCHLICH]]","v":0},2999.97,3,3,"Blumen und Dekorationen"]
[null,"Fotos und Video",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":2500,"d":"2,500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.08403361344537816,"d":"8.4%"}},{"$nulls":3},"Musik",{"$f":"TBL_Musik[[#Totals],[GESCHÄTZT]]","v":1800},{"$f":"TBL_Musik[[#Totals],[TATSÄCHLICH]]","v":0},1799.96,5,4,"Fotos und Video"]
[null,"Musik",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1800,"d":"1,800 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.06050420168067227,"d":"6.1%"}},{"$nulls":3},"Fotos und Video",{"$f":"TBL_FotosUndVideo[[#Totals],[GESCHÄTZT]]","v":2500},{"$f":"TBL_FotosUndVideo[[#Totals],[TATSÄCHLICH]]","v":0},2499.95,4,5,"Musik"]
[null,"Gastgeschenke und Geschenke",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Gastgeschenke und Geschenke",{"$f":"TBL_GastgeschenkeUndGeschenke[[#Totals],[GESCHÄTZT]]","v":1100},{"$f":"TBL_GastgeschenkeUndGeschenke[[#Totals],[TATSÄCHLICH]]","v":0},1099.94,6,6,"Gastgeschenke und Geschenke"]
[null,{"$f":"P12","v":"Eheringe"},{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":1100,"d":"1,100 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.03697478991596639,"d":"3.7%"}},{"$nulls":3},"Zeremonie",{"$f":"TBL_Zeremonie[[#Totals],[GESCHÄTZT]]","v":800},{"$f":"TBL_Zeremonie[[#Totals],[TATSÄCHLICH]]","v":0},799.93,8,7,"Eheringe"]
[null,"Zeremonie",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":800,"d":"800 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.02689075630252101,"d":"2.7%"}},{"$nulls":3},"Papierwaren",{"$f":"TBL_Papierwaren[[#Totals],[GESCHÄTZT]]","v":500},{"$f":"TBL_Papierwaren[[#Totals],[TATSÄCHLICH]]","v":0},499.92,9,8,"Zeremonie"]
[null,"Papierwaren",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":500,"d":"500 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.01680672268907563,"d":"1.7%"}},{"$nulls":3},"Eheringe",{"$f":"TBL_Eheringe[[#Totals],[GESCHÄTZT]]","v":1100},{"$f":"TBL_Eheringe[[#Totals],[TATSÄCHLICH]]","v":0},1099.91,7,9,"Papierwaren"]
[null,"Transport",{"$f":"VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,2,FALSE)","v":{"v":450,"d":"450 €"}},{"$f":"IF(VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE)=0,\"\",VLOOKUP(TBL_Summary[[#This Row],[KATEGORIE]],TBL_RankingData,3,FALSE))","v":""},{"$f":"IF(OR(TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]=\"\",TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]]=\"\"),\"\",TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#This Row],[TATSÄCHLICHE KOSTEN]])","v":""},{"$f":"TBL_Summary[[#This Row],[GESCHÄTZTE KOSTEN]]/SUM(TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":0.015126050420168067,"d":"1.5%"}},{"$nulls":3},"Transport",{"$f":"TBL_Transport[[#Totals],[GESCHÄTZT]]","v":450},{"$f":"TBL_Transport[[#Totals],[TATSÄCHLICH]]","v":0},449.9,10,10,"Transport"]
[null,"Ergebnis",{"$f":"SUBTOTAL(109,TBL_Summary[GESCHÄTZTE KOSTEN])","v":{"v":29750,"d":"29,750 €"}},{"$f":"SUBTOTAL(109,TBL_Summary[TATSÄCHLICHE KOSTEN])","v":{"v":15700,"d":"15,700 €"}},{"$f":"TBL_Summary[[#Totals],[GESCHÄTZTE KOSTEN]]-TBL_Summary[[#Totals],[TATSÄCHLICHE KOSTEN]]","v":{"v":14050,"d":"14,050 €"}},{"$f":"SUBTOTAL(109,TBL_Summary[BUDGET %])","v":{"v":1,"d":"100%"}}]

{"sheet":"Budgetdetails","index":1,"n_rows":91,"n_cols":5,"rows_kept":91}
[]
[null,"BUDGETDETAILS"]
[]
[null,"EMPFANG","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Veranstaltungsort und Vermietung",{"v":8000,"d":"8,000.00 €"},{"v":7800,"d":"7,800.00 €"},{"$f":"IF(OR(TBL_Empfang[[#This Row],[GESCHÄTZT]]=\"\",TBL_Empfang[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Empfang[[#This Row],[GESCHÄTZT]]-TBL_Empfang[[#This Row],[TATSÄCHLICH]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Verpflegung und Service",{"v":4000,"d":"4,000.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"IF(OR(TBL_Empfang[[#This Row],[GESCHÄTZT]]=\"\",TBL_Empfang[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Empfang[[#This Row],[GESCHÄTZT]]-TBL_Empfang[[#This Row],[TATSÄCHLICH]])","v":{"v":-200,"d":"-200.00 €"}}]
[null,"Getränke",{"v":1000,"d":"1,000.00 €"},{"v":800,"d":"800.00 €"},{"$f":"IF(OR(TBL_Empfang[[#This Row],[GESCHÄTZT]]=\"\",TBL_Empfang[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Empfang[[#This Row],[GESCHÄTZT]]-TBL_Empfang[[#This Row],[TATSÄCHLICH]])","v":{"v":200,"d":"200.00 €"}}]
[null,"Torte",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_Empfang[[#This Row],[GESCHÄTZT]]=\"\",TBL_Empfang[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Empfang[[#This Row],[GESCHÄTZT]]-TBL_Empfang[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Empfang[[#This Row],[GESCHÄTZT]]=\"\",TBL_Empfang[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Empfang[[#This Row],[GESCHÄTZT]]-TBL_Empfang[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"EMPFANG GESAMT",{"$f":"SUBTOTAL(109,TBL_Empfang[GESCHÄTZT])","v":{"v":14500,"d":"14,500.00 €"}},{"$f":"SUBTOTAL(109,TBL_Empfang[TATSÄCHLICH])","v":{"v":12800,"d":"12,800.00 €"}},{"$f":"TBL_Empfang[[#Totals],[GESCHÄTZT]]-TBL_Empfang[[#Totals],[TATSÄCHLICH]]","v":{"v":1700,"d":"1,700.00 €"}}]
[]
[]
[null,"BEKLEIDUNG","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Smoking, Anzug und/oder Kleider",{"v":3000,"d":"3,000.00 €"},{"v":2900,"d":"2,900.00 €"},{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":{"v":100,"d":"100.00 €"}}]
[null,"Änderungen",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Kopfbedeckung und Schleier",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Accessoires",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Frisur und Make-up",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Bekleidung[[#This Row],[GESCHÄTZT]]=\"\",TBL_Bekleidung[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Bekleidung[[#This Row],[GESCHÄTZT]]-TBL_Bekleidung[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"BEKLEIDUNG GESAMT",{"$f":"SUBTOTAL(109,TBL_Bekleidung[GESCHÄTZT])","v":{"v":4000,"d":"4,000.00 €"}},{"$f":"SUBTOTAL(109,TBL_Bekleidung[TATSÄCHLICH])","v":{"v":2900,"d":"2,900.00 €"}},{"$f":"TBL_Bekleidung[[#Totals],[GESCHÄTZT]]-TBL_Bekleidung[[#Totals],[TATSÄCHLICH]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"BLUMEN UND DEKORATIONEN","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Blumendekoration für die Zeremonie",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Blumenmädchen Blüten und Korb",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Ringkissen",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Sträuße",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Boutonnieres",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Anstecksträuße",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Dekorationen für den Empfang",{"v":300,"d":"300.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Beleuchtung",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]=\"\",TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_BlumenUndDekorationen[[#This Row],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"BLUMEN UND DEKORATIONEN GESAMT",{"$f":"SUBTOTAL(109,TBL_BlumenUndDekorationen[GESCHÄTZT])","v":{"v":3000,"d":"3,000.00 €"}},{"$f":"SUBTOTAL(109,TBL_BlumenUndDekorationen[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_BlumenUndDekorationen[[#Totals],[GESCHÄTZT]]-TBL_BlumenUndDekorationen[[#Totals],[TATSÄCHLICH]]","v":{"v":3000,"d":"3,000.00 €"}}]
[]
[]
[null,"MUSIK","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Zeremonie Musiker",{"v":700,"d":"700.00 €"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[GESCHÄTZT]]=\"\",TBL_Musik[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Musik[[#This Row],[GESCHÄTZT]]-TBL_Musik[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Cocktailempfang Musiker",{"v":300,"d":"300.00 €"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[GESCHÄTZT]]=\"\",TBL_Musik[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Musik[[#This Row],[GESCHÄTZT]]-TBL_Musik[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Empfangsband, DJ oder Unterhaltung",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[GESCHÄTZT]]=\"\",TBL_Musik[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Musik[[#This Row],[GESCHÄTZT]]-TBL_Musik[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Sound-System oder Tanzflächenverleih",{"v":400,"d":"400.00 €"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[GESCHÄTZT]]=\"\",TBL_Musik[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Musik[[#This Row],[GESCHÄTZT]]-TBL_Musik[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Musik[[#This Row],[GESCHÄTZT]]=\"\",TBL_Musik[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Musik[[#This Row],[GESCHÄTZT]]-TBL_Musik[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"MUSIK GESAMT",{"$f":"SUBTOTAL(109,TBL_Musik[GESCHÄTZT])","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"SUBTOTAL(109,TBL_Musik[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Musik[[#Totals],[GESCHÄTZT]]-TBL_Musik[[#Totals],[TATSÄCHLICH]]","v":{"v":1800,"d":"1,800.00 €"}}]
[]
[]
[null,"FOTOS UND VIDEO","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Fotos",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]=\"\",TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]-TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Videografie",{"v":800,"d":"800.00 €"},null,{"$f":"IF(OR(TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]=\"\",TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]-TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Zusätzliche Fotoabzüge und Alben",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]=\"\",TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]-TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]=\"\",TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_FotosUndVideo[[#This Row],[GESCHÄTZT]]-TBL_FotosUndVideo[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"FOTOS UND VIDEO GESAMT",{"$f":"SUBTOTAL(109,TBL_FotosUndVideo[GESCHÄTZT])","v":{"v":2500,"d":"2,500.00 €"}},{"$f":"SUBTOTAL(109,TBL_FotosUndVideo[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_FotosUndVideo[[#Totals],[GESCHÄTZT]]-TBL_FotosUndVideo[[#Totals],[TATSÄCHLICH]]","v":{"v":2500,"d":"2,500.00 €"}}]
[]
[]
[null,"GASTGESCHENKE UND GESCHENKE","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Willkommensgeschenke",{"v":700,"d":"700.00 €"},null,{"$f":"IF(OR(TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]=\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]-TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Party Geschenke",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]=\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]-TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]=\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_GastgeschenkeUndGeschenke[[#This Row],[GESCHÄTZT]]-TBL_GastgeschenkeUndGeschenke[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"GASTGESCHENKE UND GESCHENKE GESAMT",{"$f":"SUBTOTAL(109,TBL_GastgeschenkeUndGeschenke[GESCHÄTZT])","v":{"v":1100,"d":"1,100.00 €"}},{"$f":"SUBTOTAL(109,TBL_GastgeschenkeUndGeschenke[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_GastgeschenkeUndGeschenke[[#Totals],[GESCHÄTZT]]-TBL_GastgeschenkeUndGeschenke[[#Totals],[TATSÄCHLICH]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"ZEREMONIE","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Platzgebühr",{"v":500,"d":"500.00 €"},null,{"$f":"IF(OR(TBL_Zeremonie[[#This Row],[GESCHÄTZT]]=\"\",TBL_Zeremonie[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Zeremonie[[#This Row],[GESCHÄTZT]]-TBL_Zeremonie[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Pfarrer Gebühr oder Kirchenspende",{"v":200,"d":"200.00 €"},null,{"$f":"IF(OR(TBL_Zeremonie[[#This Row],[GESCHÄTZT]]=\"\",TBL_Zeremonie[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Zeremonie[[#This Row],[GESCHÄTZT]]-TBL_Zeremonie[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Zeremonie[[#This Row],[GESCHÄTZT]]=\"\",TBL_Zeremonie[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Zeremonie[[#This Row],[GESCHÄTZT]]-TBL_Zeremonie[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"ZEREMONIE GESAMT",{"$f":"SUBTOTAL(109,TBL_Zeremonie[GESCHÄTZT])","v":{"v":800,"d":"800.00 €"}},{"$f":"SUBTOTAL(109,TBL_Zeremonie[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Zeremonie[[#Totals],[GESCHÄTZT]]-TBL_Zeremonie[[#Totals],[TATSÄCHLICH]]","v":{"v":800,"d":"800.00 €"}}]
[]
[]
[null,"PAPIERWAREN","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Erinnerungskarten für den Hochzeitstermin",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Einladungen und RSVPs",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Programme",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Sitzplatz-und Platzkarten",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Menükarten",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Dankschreiben",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Porto",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Papierwaren[[#This Row],[GESCHÄTZT]]=\"\",TBL_Papierwaren[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Papierwaren[[#This Row],[GESCHÄTZT]]-TBL_Papierwaren[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"PAPIERWAREN GESAMT",{"$f":"SUBTOTAL(109,TBL_Papierwaren[GESCHÄTZT])","v":{"v":500,"d":"500.00 €"}},{"$f":"SUBTOTAL(109,TBL_Papierwaren[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Papierwaren[[#Totals],[GESCHÄTZT]]-TBL_Papierwaren[[#Totals],[TATSÄCHLICH]]","v":{"v":500,"d":"500.00 €"}}]
[]
[]
[null,"EHERINGE","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Eheringe",{"v":1000,"d":"1,000.00 €"},null,{"$f":"IF(OR(TBL_Eheringe[[#This Row],[GESCHÄTZT]]=\"\",TBL_Eheringe[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Eheringe[[#This Row],[GESCHÄTZT]]-TBL_Eheringe[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Eheringe Accessoires",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Eheringe[[#This Row],[GESCHÄTZT]]=\"\",TBL_Eheringe[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Eheringe[[#This Row],[GESCHÄTZT]]-TBL_Eheringe[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"EHERINGE GESAMT",{"$f":"SUBTOTAL(109,TBL_Eheringe[GESCHÄTZT])","v":{"v":1100,"d":"1,100.00 €"}},{"$f":"SUBTOTAL(109,TBL_Eheringe[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Eheringe[[#Totals],[GESCHÄTZT]]-TBL_Eheringe[[#Totals],[TATSÄCHLICH]]","v":{"v":1100,"d":"1,100.00 €"}}]
[]
[]
[null,"TRANSPORT  ","GESCHÄTZT","TATSÄCHLICH","ABWEICHUNG"]
[null,"Hauptmietwagen",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transport[[#This Row],[GESCHÄTZT]]=\"\",TBL_Transport[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Transport[[#This Row],[GESCHÄTZT]]-TBL_Transport[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Autovermietung für Gäste",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transport[[#This Row],[GESCHÄTZT]]=\"\",TBL_Transport[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Transport[[#This Row],[GESCHÄTZT]]-TBL_Transport[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Transport für auswärtige Gäste",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transport[[#This Row],[GESCHÄTZT]]=\"\",TBL_Transport[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Transport[[#This Row],[GESCHÄTZT]]-TBL_Transport[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Parkservice",{"v":50,"d":"50.00 €"},null,{"$f":"IF(OR(TBL_Transport[[#This Row],[GESCHÄTZT]]=\"\",TBL_Transport[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Transport[[#This Row],[GESCHÄTZT]]-TBL_Transport[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"Verschiedene Gebühren",{"v":100,"d":"100.00 €"},null,{"$f":"IF(OR(TBL_Transport[[#This Row],[GESCHÄTZT]]=\"\",TBL_Transport[[#This Row],[TATSÄCHLICH]]=\"\"),\"\",TBL_Transport[[#This Row],[GESCHÄTZT]]-TBL_Transport[[#This Row],[TATSÄCHLICH]])","v":""}]
[null,"TRANSPORT GESAMT",{"$f":"SUBTOTAL(109,TBL_Transport[GESCHÄTZT])","v":{"v":450,"d":"450.00 €"}},{"$f":"SUBTOTAL(109,TBL_Transport[TATSÄCHLICH])","v":{"v":0,"d":"0.00 €"}},{"$f":"TBL_Transport[[#Totals],[GESCHÄTZT]]-TBL_Transport[[#Totals],[TATSÄCHLICH]]","v":{"v":450,"d":"450.00 €"}}]