{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sammanfattning av budget","Budgetinformation"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Sammanfattning av budget","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"TOTAL BRÖLLOPSBUDGET",{"v":20000,"d":"20,000 kr"}]
[]
[null,"UTGIFTER","Tilldelning \n%","Tilldelad budget","Uppskattade \nkostnader","Faktiska \nkostnader"]
[null,"Mottagning",{"v":0.5,"d":"50%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C6","v":{"v":10000,"d":"10,000 kr"}},{"$f":"Tabell_Mottagning[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Mottagning[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Klädsel",{"v":0.1,"d":"10%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C7","v":{"v":2000,"d":"2,000 kr"}},{"$f":"Tabell_Klädsel[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Klädsel[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Blommor och utsmyckningar",{"v":0.1,"d":"10%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C8","v":{"v":2000,"d":"2,000 kr"}},{"$f":"Tabell_BlommorOchDekorationer[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_BlommorOchDekorationer[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Musik",{"v":0.1,"d":"10%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C9","v":{"v":2000,"d":"2,000 kr"}},{"$f":"Tabell_Musik[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Musik[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Foton och video",{"v":0.1,"d":"10%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C10","v":{"v":2000,"d":"2,000 kr"}},{"$f":"Tabell_FotografiOchVideo[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_FotografiOchVideo[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Tjänster och gåvor",{"v":0.03,"d":"3%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C11","v":{"v":600,"d":"600 kr"}},{"$f":"Tabell_TjänsterOchGåvor[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_TjänsterOchGåvor[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Ceremoni",{"v":0.02,"d":"2%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C12","v":{"v":400,"d":"400 kr"}},{"$f":"Tabell_Ceremoni[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Ceremoni[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Brevpapper",{"v":0.02,"d":"2%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C13","v":{"v":400,"d":"400 kr"}},{"$f":"Tabell_Brevpapper[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Brevpapper[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Vigselringar",{"v":0.02,"d":"2%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C14","v":{"v":400,"d":"400 kr"}},{"$f":"Tabell_Bröllopsringar[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Bröllopsringar[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Transport",{"v":0.01,"d":"1%"},{"$f":"Total_bröllops_budget*'Sammanfattning av budget'!$C15","v":{"v":200,"d":"200 kr"}},{"$f":"Tabell_Transport[[#Totals],[Beräknade kostnader]]","v":{"v":0,"d":"0 kr"}},{"$f":"Tabell_Transport[[#Totals],[Verkliga kostnader]]","v":{"v":0,"d":"0 kr"}}]
[null,"Summa",{"$f":"SUM(C6:C15)","v":{"v":1,"d":"100%"}},{"$f":"SUM(D6:D15)","v":{"v":20000,"d":"20,000 kr"}},{"v":0,"d":"0 kr"},{"v":0,"d":"0 kr"}]
[]
[null,"BIDRAG"]
[null,"Finansieringskälla","Bidrag"]
[null,"Besparingar",{"v":10000,"d":"10,000 kr"}]
[null,"Mamma och pappa till partner 1",{"v":4000,"d":"4,000 kr"}]
[null,"Mor- och farföräldrar till partner 1",{"v":2000,"d":"2,000 kr"}]
[null,"Mamma och pappa till partner 2",{"v":4000,"d":"4,000 kr"}]
[null,"Mor- och farföräldrar till partner 2",{"v":4000,"d":"4,000 kr"}]
[null,"Övriga bidrag",{"v":2000,"d":"2,000 kr"}]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Bidrag[Bidrag])","v":{"v":26000,"d":"26,000 kr"}}]
[]
[null,{"$f":"IF(Tabell_Bidrag[[#Totals],[Bidrag]]<Total_bröllops_budget,\"Differens som ska kompenseras\",\"Tillgängliga extra medel\")","v":"Tillgängliga extra medel"},{"$f":"IF(Tabell_Bidrag[[#Totals],[Bidrag]]<Total_bröllops_budget,Total_bröllops_budget-Tabell_Bidrag[[#Totals],[Bidrag]],Tabell_Bidrag[[#Totals],[Bidrag]]-Total_bröllops_budget)","v":{"v":6000,"d":"6,000 kr"}}]

{"sheet":"Budgetinformation","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"MOTTAGNING","Beräknade kostnader","Verkliga kostnader"]
[null,"Lokaler och hyror"]
[null,"Livsmedel och tjänster"]
[null,"Drycker"]
[null,"Tårta"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Mottagning[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Mottagning[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"KLÄDSEL","Beräknade kostnader","Verkliga kostnader"]
[null,"Frack, smoking och/eller klänningar"]
[null,"Ändringar"]
[null,"Krona och slöja"]
[null,"Accessoarer"]
[null,"Hår och makeup"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Klädsel[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Klädsel[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"BLOMMOR OCH UTSMYCKNINGAR","Beräknade kostnader","Verkliga kostnader"]
[null,"Blomsterarrangemang för ceremoni"]
[null,"Tärnornas buketter och/eller korgar"]
[null,"Ringkudde"]
[null,"Buketter"]
[null,"Knapphålsblommor"]
[null,"Bröstbuketter"]
[null,"Dekorationer för mottagning"]
[null,"Belysning"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_BlommorOchDekorationer[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_BlommorOchDekorationer[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"MUSIK","Beräknade kostnader","Verkliga kostnader"]
[null,"Musiker för ceremoni"]
[null,"Musiker för mottagning"]
[null,"Mottagningsband, DJ eller underhållning"]
[null,"Ljudsystem eller hyra av dansgolv"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Musik[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Musik[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"FOTON OCH VIDEO","Beräknade kostnader","Verkliga kostnader"]
[null,"Fotografering"]
[null,"Videofilmning"]
[null,"Ytterligare utskrifter och album"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_FotografiOchVideo[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_FotografiOchVideo[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"GENTJÄNSTER OCH GÅVOR","Beräknade kostnader","Verkliga kostnader"]
[null,"Välkomstgåvor"]
[null,"Partypresenter"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_TjänsterOchGåvor[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_TjänsterOchGåvor[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"CEREMONI","Beräknade kostnader","Verkliga kostnader"]
[null,"Lokalkostnad"]
[null,"Betalning eller donation till officiant eller kyrka"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Ceremoni[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Ceremoni[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"BREVPAPPER","Beräknade kostnader","Verkliga kostnader"]
[null,"Inbjudningskort"]
[null,"Inbjudningar och RSVP"]
[null,"Program"]
[null,"Platskort"]
[null,"Menykort"]
[null,"Tackkort"]
[null,"Porto"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Brevpapper[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Brevpapper[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"VIGSELRINGAR","Beräknade kostnader","Verkliga kostnader"]
[null,"Vigselringar"]
[null,"Ringtillbehör"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Bröllopsringar[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Bröllopsringar[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"TRANSPORT","Beräknade kostnader","Verkliga kostnader"]
[null,"Hyrbil för bröllopspar"]
[null,"Hyrbil för gäster"]
[null,"Transport för långväga gäster"]
[null,"Parkeringsvakt"]
[null,"Diverse utgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell_Transport[Beräknade kostnader])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell_Transport[Verkliga kostnader])","v":{"v":0,"d":"0.00 kr"}}]