{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Eelarve kokkuvõte","Eelarve üksikasjad"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Eelarve kokkuvõte","index":0,"n_rows":28,"n_cols":7,"rows_kept":28}
[{"$nulls":6}," "]
[]
[null,"PULMA KOGUEELARVE",{"v":20000,"d":"20,000 €"}]
[]
[null,"KULUD","Plaanitud \n%","Plaanitud eelarve","Hinnanguline \nKulud","Tegelik \nKulud"]
[null,"Vastuvõtt",{"v":0.5,"d":"50%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C6","v":{"v":10000,"d":"10,000 €"}},{"$f":"Tabel_Vastuvõtt[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Vastuvõtt[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Riietus",{"v":0.1,"d":"10%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C7","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabel_Riietus[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Riietus[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Lilled ja dekoratsioonid",{"v":0.1,"d":"10%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C8","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabel_Lilledjadekoratsioonid[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Lilledjadekoratsioonid[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Muusika",{"v":0.1,"d":"10%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C9","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabel_Muusika[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Muusika[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Fotod ja video",{"v":0.1,"d":"10%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C10","v":{"v":2000,"d":"2,000 €"}},{"$f":"Tabel_Fotodjavideo[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Fotodjavideo[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Meened ja kingitused",{"v":0.03,"d":"3%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C11","v":{"v":600,"d":"600 €"}},{"$f":"Tabel_Meenedjakingitused[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Meenedjakingitused[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Tseremoonia",{"v":0.02,"d":"2%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C12","v":{"v":400,"d":"400 €"}},{"$f":"Tabel_Tseremoonia[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Tseremoonia[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Kirjatarbed",{"v":0.02,"d":"2%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C13","v":{"v":400,"d":"400 €"}},{"$f":"Tabel_Kirjatarbed[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Kirjatarbed[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Abielusõrmused",{"v":0.02,"d":"2%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C14","v":{"v":400,"d":"400 €"}},{"$f":"Tabel_Pulmasõrmused[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Pulmasõrmused[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Transport",{"v":0.01,"d":"1%"},{"$f":"Pulmade_kogueelarve*'Eelarve kokkuvõte'!$C15","v":{"v":200,"d":"200 €"}},{"$f":"Tabel_Transport[[#Totals],[Eeldatavad kulud]]","v":{"v":0,"d":"0 €"}},{"$f":"Tabel_Transport[[#Totals],[Tegelikud kulud]]","v":{"v":0,"d":"0 €"}}]
[null,"Kokku",{"$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,"TOETUSED"]
[null,"Rahaallikas","Toetus"]
[null,"Säästud",{"v":10000,"d":"10,000 €"}]
[null,"1. partneri ema ja isa",{"v":4000,"d":"4,000 €"}]
[null,"1. partneri vanavanemad",{"v":2000,"d":"2,000 €"}]
[null,"2. partneri ema ja isa",{"v":4000,"d":"4,000 €"}]
[null,"2. partneri vanavanemad",{"v":4000,"d":"4,000 €"}]
[null,"Muud toetused",{"v":2000,"d":"2,000 €"}]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Toetused[Toetus])","v":{"v":26000,"d":"26,000 €"}}]
[]
[null,{"$f":"IF(Tabel_Toetused[[#Totals],[Toetus]]<Pulmade_kogueelarve,\"Erinevuste tegemine\",\"Saadaval olevad lisavahendid\")","v":"Saadaval olevad lisavahendid"},{"$f":"IF(Tabel_Toetused[[#Totals],[Toetus]]<Pulmade_kogueelarve,Pulmade_kogueelarve-Tabel_Toetused[[#Totals],[Toetus]],Tabel_Toetused[[#Totals],[Toetus]]-Pulmade_kogueelarve)","v":{"v":6000,"d":"6,000 €"}}]

{"sheet":"Eelarve üksikasjad","index":1,"n_rows":80,"n_cols":4,"rows_kept":80}
[]
[null,"VASTUVÕTT","Eeldatavad kulud","Tegelikud kulud"]
[null,"Toimumiskoht ja laenutus"]
[null,"Söök ja teenindus"]
[null,"Joogid"]
[null,"Tort"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Vastuvõtt[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Vastuvõtt[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"RIIETUS","Eeldatavad kulud","Tegelikud kulud"]
[null,"Smokk, ülikond ja/või kleidid"]
[null,"Kohandamised"]
[null,"Peaehe ja loor"]
[null,"Aksessuaarid"]
[null,"Juuksed ja meik"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Riietus[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Riietus[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"LILLED JA DEKORATSIOONID","Eeldatavad kulud","Tegelikud kulud"]
[null,"Tseremoonia lilleseaded"]
[null,"Lilleneiu kroonlehed ja korv"]
[null,"Sõrmuste padi"]
[null,"Lillekimbud"]
[null,"Nööpaugulilled"]
[null,"Käekaunistused"]
[null,"Vastuvõtu dekoratsioonid"]
[null,"Valgustus"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Lilledjadekoratsioonid[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Lilledjadekoratsioonid[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"MUUSIKA","Eeldatavad kulud","Tegelikud kulud"]
[null,"Tseremoonia muusikud"]
[null,"Kokteiliaja muusikud"]
[null,"Vastuvõtu bänd, diskor või meelelahutus"]
[null,"Helisüsteemi või tantsupõranda rentimine"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Muusika[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Muusika[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"FOTOD JA VIDEO","Eeldatavad kulud","Tegelikud kulud"]
[null,"Fotod"]
[null,"Videod"]
[null,"Täiendavad trükised ja albumid"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Fotodjavideo[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Fotodjavideo[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"MEENED JA KINGITUSED","Eeldatavad kulud","Tegelikud kulud"]
[null,"Tervituse kingitused"]
[null,"Peo kingitused"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Meenedjakingitused[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Meenedjakingitused[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TSEREMOONIA","Eeldatavad kulud","Tegelikud kulud"]
[null,"Toimumiskoha tasu"]
[null,"Tseremooniameistri tasu või annetus kirikule"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Tseremoonia[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Tseremoonia[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"KIRJATARBED","Eeldatavad kulud","Tegelikud kulud"]
[null,"Kuupäevast teavitamise kaardid"]
[null,"Kutsed ja osalemisvastused"]
[null,"Kavalehed"]
[null,"Istekohtade ja paigutuse kaardid"]
[null,"Menüükaardid"]
[null,"Tänukaardid"]
[null,"Postikulu"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Kirjatarbed[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Kirjatarbed[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"ABIELUSÕRMUSED","Eeldatavad kulud","Tegelikud kulud"]
[null,"Abielusõrmused"]
[null,"Sõrmuste aksessuaarid"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Pulmasõrmused[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Pulmasõrmused[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"TRANSPORT","Eeldatavad kulud","Tegelikud kulud"]
[null,"Peamise auto rent"]
[null,"Külaliste autode rent"]
[null,"Kaugemalt tulnud külaliste transport"]
[null,"Parkimisteenus"]
[null,"Mitmesugused tasud"]
[null,"Kokku",{"$f":"SUBTOTAL(109,Tabel_Transport[Eeldatavad kulud])","v":{"v":0,"d":"0.00 €"}},{"$f":"SUBTOTAL(109,Tabel_Transport[Tegelikud kulud])","v":{"v":0,"d":"0.00 €"}}]