{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Utgifter","Intäkter","Sammanfattning vinst – förlust"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Utgifter","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Evenemangsbudget för [evenemangets namn] ",{"$nulls":5},"UTGIFTER"]
[]
[null,"SUMMA UTGIFTER",{"$nulls":4},"Beräknad","Faktisk"]
[{"$nulls":6},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"882.00 kr"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"333.00 kr"}}]
[]
[null,"Lokal","Beräknad","Faktisk",null,"Förfriskningar","Beräknad","Faktisk"]
[null,"Avgifter för rum och sal",{"v":500,"d":"500.00 kr"},null,null,"Mat"]
[null,"Personal på plats",{"$nulls":3},"Dryck",{"v":20,"d":"20.00 kr"}]
[null,"Utrustning",{"$nulls":3},"Linne",null,{"v":20,"d":"20.00 kr"}]
[null,"Bord och stolar",{"$nulls":3},"Personal och serviceavgifter"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell1[Beräknad])","v":{"v":500,"d":"500.00 kr"}},{"$f":"SUBTOTAL(109,Tabell1[Faktisk])","v":{"v":0,"d":"0.00 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Tabell3[Beräknad])","v":{"v":20,"d":"20.00 kr"}},{"$f":"SUBTOTAL(109,Tabell3[Faktisk])","v":{"v":20,"d":"20.00 kr"}}]
[]
[null,"Dekorationer","Beräknad","Faktisk",null,"Program","Beräknad","Faktisk"]
[null,"Blommor",{"v":200,"d":"200.00 kr"},{"v":300,"d":"300.00 kr"},null,"Artister"]
[null,"Ljus",{"$nulls":3},"Talare",{"v":30,"d":"30.00 kr"}]
[null,"Belysning",{"$nulls":3},"Resor"]
[null,"Ballonger",{"$nulls":3},"Hotell"]
[null,"Pappersmaterial",{"$nulls":3},"Övrigt"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell4[Beräknad])","v":{"v":200,"d":"200.00 kr"}},{"$f":"SUBTOTAL(109,Tabell4[Faktisk])","v":{"v":300,"d":"300.00 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Tabell5[Beräknad])","v":{"v":30,"d":"30.00 kr"}},{"$f":"SUBTOTAL(109,Tabell5[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"Reklam","Beräknad","Faktisk",null,"Priser","Beräknad","Faktisk"]
[null,"Grafik",{"$nulls":3},"Band/plaketter/troféer"]
[null,"Fotokopiering/utskrifter",{"v":20,"d":"20.00 kr"},null,null,"Gåvor",{"v":100,"d":"100.00 kr"}]
[null,"Porto",{"$nulls":3},"Summa",{"$f":"SUBTOTAL(109,Tabell7[Beräknad])","v":{"v":100,"d":"100.00 kr"}},{"$f":"SUBTOTAL(109,Tabell7[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell6[Beräknad])","v":{"v":20,"d":"20.00 kr"}},{"$f":"SUBTOTAL(109,Tabell6[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"Övrigt","Beräknad","Faktisk"]
[null,"Telefon",null,{"v":13,"d":"13.00 kr"}]
[null,"Transport",{"v":12,"d":"12.00 kr"}]
[null,"Kontorsmaterial"]
[null,"Faxtjänster"]
[null,"Summa",{"$f":"SUBTOTAL(109,Tabell8[Beräknad])","v":{"v":12,"d":"12.00 kr"}},{"$f":"SUBTOTAL(109,Tabell8[Faktisk])","v":{"v":13,"d":"13.00 kr"}}]

{"sheet":"Intäkter","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Evenemangsbudget för [evenemangets namn] ",{"$nulls":4},"INTÄKTER"]
[]
[null,"SUMMA INTÄKTER",{"$nulls":3},"Beräknad","Faktisk"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"1,831.00 kr"}}]
[]
[null,"INTRÄDE"]
[null,"Beräknat antal","Faktiskt antal","Typ","Pris","Beräknade intäkter","Faktiska intäkter"]
[null,300,278,"Vuxna à",{"v":5,"d":"5.00 kr"},{"$f":"B8*E8","v":{"v":1500,"d":"1,500.00 kr"}},{"$f":"C8*E8","v":{"v":1390,"d":"1,390.00 kr"}}]
[null,197,195,"Barn à",{"v":2,"d":"2.00 kr"},{"$f":"B9*E9","v":{"v":394,"d":"394.00 kr"}},{"$f":"C9*E9","v":{"v":390,"d":"390.00 kr"}}]
[null,42,51,"Övriga à",{"v":1,"d":"1.00 kr"},{"$f":"B10*E10","v":{"v":42,"d":"42.00 kr"}},{"$f":"C10*E10","v":{"v":51,"d":"51.00 kr"}}]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell9[Beräknade intäkter])","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"SUBTOTAL(109,Tabell9[Faktiska intäkter])","v":{"v":1831,"d":"1,831.00 kr"}}]
[]
[null,"REKLAM I PROGRAMMET"]
[null,"Beräknat antal","Faktiskt antal","Typ","Pris","Beräknade intäkter","Faktiska intäkter"]
[null,12,null,"Omslag à",null,{"$f":"B15*E15","v":{"v":0,"d":"0.00 kr"}},{"$f":"C15*E15","v":{"v":0,"d":"0.00 kr"}}]
[null,null,158,"A5 à",null,{"$f":"B16*E16","v":{"v":0,"d":"0.00 kr"}},{"$f":"C16*E16","v":{"v":0,"d":"0.00 kr"}}]
[null,4,null,"A6 à",null,{"$f":"B17*E17","v":{"v":0,"d":"0.00 kr"}},{"$f":"C17*E17","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell10[Beräknade intäkter])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell10[Faktiska intäkter])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"UTSTÄLLARE/FÖRSÄLJARE"]
[null,"Beräknat antal","Faktiskt antal","Typ","Pris","Beräknade intäkter","Faktiska intäkter"]
[null,23,null,"Stora montrar à",null,{"$f":"B22*E22","v":{"v":0,"d":"0.00 kr"}},{"$f":"C22*E22","v":{"v":0,"d":"0.00 kr"}}]
[null,354,null,"Mellanstora montrar à",null,{"$f":"B23*E23","v":{"v":0,"d":"0.00 kr"}},{"$f":"C23*E23","v":{"v":0,"d":"0.00 kr"}}]
[null,56,null,"Små montrar à",null,{"$f":"B24*E24","v":{"v":0,"d":"0.00 kr"}},{"$f":"C24*E24","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell11[Beräknade intäkter])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell11[Faktiska intäkter])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"SÅLDA PRODUKTER"]
[null,"Beräknat antal","Faktiskt antal","Typ","Pris","Beräknade intäkter","Faktiska intäkter"]
[{"$nulls":3},"Produkter à",null,{"$f":"B29*E29","v":{"v":0,"d":"0.00 kr"}},{"$f":"C29*E29","v":{"v":0,"d":"0.00 kr"}}]
[null,123,null,"Produkter à",null,{"$f":"B30*E30","v":{"v":0,"d":"0.00 kr"}},{"$f":"C30*E30","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Produkter à",null,{"$f":"B31*E31","v":{"v":0,"d":"0.00 kr"}},{"$f":"C31*E31","v":{"v":0,"d":"0.00 kr"}}]
[null,13,null,"Produkter à",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 kr"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 kr"}}]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabell12[Beräknade intäkter])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell12[Faktiska intäkter])","v":{"v":0,"d":"0.00 kr"}}]

{"sheet":"Sammanfattning vinst – förlust","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"Evenemangsbudget för [evenemangets namn] ",{"$nulls":4},"VINST "]
[{"$nulls":6},"och förlust – sammanfattning"]
[]
[]
[null,null,"Beräknad","Faktisk"]
[null,"Total inkomst",{"$f":"Intäkter!F4","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"Intäkter!G4","v":{"v":1831,"d":"1,831.00 kr"}}]
[null,"Summa utgifter",{"$f":"Utgifter!G4","v":{"v":882,"d":"882.00 kr"}},{"$f":"Utgifter!H4","v":{"v":333,"d":"333.00 kr"}}]
[]
[null,"Summa vinst\n(eller förlust)",{"$f":"C6-C7","v":{"v":1054,"d":"1,054.00 kr"}},{"$f":"D6-D7","v":{"v":1498,"d":"1,498.00 kr"}}]