{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Utgifter","Intäkter","Sammanfattning"],"not_rendered":{"charts":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Utgifter","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[0,6,0,8],[1,6,1,7],[2,1,2,8],[3,7,3,8]]}
[]
[]
[null,"Evenemangsbudget för \n[Evenemangets namn]"]
[{"$nulls":7}," Utgifter"]
[]
[{"$nulls":7},"Beräknad","Faktisk"]
[null,null,"Summa utgifter",{"$nulls":4},{"$f":"SUM(D14,D22,D28,D35,H14,H22,H27)","v":{"v":1145,"d":"1,145.00 kr"}},{"$f":"SUM(E14,E22,E28,E35,I14,I22,I27)","v":{"v":395,"d":"395.00 kr"}}]
[]
[null,null,"Lokal","Beräknad","Faktisk",null,"Förfriskningar","Beräknad","Faktisk"]
[null,null,"Avgifter för rum och sal",{"v":500,"d":"500.00 kr"},{"v":250,"d":"250.00 kr"},null,"Mat"]
[null,null,"Personal på plats",{"v":400,"d":"400.00 kr"},{"v":50,"d":"50.00 kr"},null,"Dryck"]
[null,null,"Utrustning",{"$nulls":3},"Linne"]
[null,null,"Bord och stolar",{"$nulls":3},"Personal och serviceavgifter"]
[null,null,"Summa",{"$f":"SUBTOTAL(109,Tabell1[Beräknad])","v":{"v":900,"d":"900.00 kr"}},{"$f":"SUBTOTAL(109,Tabell1[Faktisk])","v":{"v":300,"d":"300.00 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Tabell5[Beräknad])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell5[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,null,"Dekorationer","Beräknad","Faktisk",null,"Program","Beräknad","Faktisk"]
[null,null,"Blommor",{"v":200,"d":"200.00 kr"},{"v":50,"d":"50.00 kr"},null,"Artister"]
[null,null,"Ljus",{"$nulls":3},"Talare"]
[null,null,"Belysning",{"$nulls":3},"Resor"]
[null,null,"Ballonger",{"$nulls":3},"Hotell"]
[null,null,"Pappersmaterial",{"$nulls":3},"Övrigt"]
[null,null,"Summa",{"$f":"SUBTOTAL(109,Tabell2[Beräknad])","v":{"v":200,"d":"200.00 kr"}},{"$f":"SUBTOTAL(109,Tabell2[Faktisk])","v":{"v":50,"d":"50.00 kr"}},null,"Summa",{"$f":"SUBTOTAL(109,Tabell6[Beräknad])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell6[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,null,"Reklam","Beräknad","Faktisk",null,"Priser","Beräknad","Faktisk"]
[null,null,"Grafik",{"v":45,"d":"45.00 kr"},{"v":45,"d":"45.00 kr"},null,"Band/plaketter/troféer"]
[null,null,"Fotokopiering/utskrifter",{"$nulls":3},"Gåvor"]
[null,null,"Porto",{"$nulls":3},"Summa",{"$f":"SUBTOTAL(109,Tabell7[Beräknad])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell7[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]
[null,null,"Summa",{"$f":"SUBTOTAL(109,Tabell3[Beräknad])","v":{"v":45,"d":"45.00 kr"}},{"$f":"SUBTOTAL(109,Tabell3[Faktisk])","v":{"v":45,"d":"45.00 kr"}}]
[]
[null,null,"Övrigt","Beräknad","Faktisk"]
[null,null,"Telefon"]
[null,null,"Transport"]
[null,null,"Kontorsmaterial"]
[null,null,"Faxtjänster"]
[null,null,"Summa",{"$f":"SUBTOTAL(109,Tabell4[Beräknad])","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUBTOTAL(109,Tabell4[Faktisk])","v":{"v":0,"d":"0.00 kr"}}]

{"sheet":"Intäkter","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[2,1,2,6],[3,5,3,6],[14,1,14,6],[21,1,21,6],[28,1,28,6]]}
[]
[]
[null,"Evenemangsbudget för \n[Evenemangets namn]"]
[{"$nulls":5}," Inkomst"]
[]
[{"$nulls":5},"Beräknad","Faktisk"]
[null,"Summa intäkter",{"$nulls":3},{"$f":"SUM(F14,F21,F28,F36)","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"SUM(G14,G21,G28,G36)","v":{"v":1831,"d":"1,831.00 kr"}}]
[]
[null,"Inträde"]
[null,"Beräknad","Faktisk",null,null,"Beräknad","Faktisk"]
[null,300,278,"Vuxna à",{"v":5,"d":"5.00 kr"},{"$f":"B11*E11","v":{"v":1500,"d":"1,500.00 kr"}},{"$f":"C11*E11","v":{"v":1390,"d":"1,390.00 kr"}}]
[null,197,195,"Barn à",{"v":2,"d":"2.00 kr"},{"$f":"B12*E12","v":{"v":394,"d":"394.00 kr"}},{"$f":"C12*E12","v":{"v":390,"d":"390.00 kr"}}]
[null,42,51,"Övriga à",{"v":1,"d":"1.00 kr"},{"$f":"B13*E13","v":{"v":42,"d":"42.00 kr"}},{"$f":"C13*E13","v":{"v":51,"d":"51.00 kr"}}]
[{"$nulls":5},{"$f":"SUM(F11:F13)","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"SUM(G11:G13)","v":{"v":1831,"d":"1,831.00 kr"}}]
[]
[null,"Reklam i programmet"]
[null,"Beräknad","Faktisk",null,null,"Beräknad","Faktisk"]
[{"$nulls":3},"Omslag à",null,{"$f":"B18*E18","v":{"v":0,"d":"0.00 kr"}},{"$f":"C18*E18","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"A5 à",null,{"$f":"B19*E19","v":{"v":0,"d":"0.00 kr"}},{"$f":"C19*E19","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"A6 à",null,{"$f":"B20*E20","v":{"v":0,"d":"0.00 kr"}},{"$f":"C20*E20","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":5},{"$f":"SUM(F18:F20)","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUM(G18:G20)","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"Utställare/försäljare"]
[null,"Beräknad","Faktisk",null,null,"Beräknad","Faktisk"]
[{"$nulls":3},"Stora montrar à",null,{"$f":"B25*E25","v":{"v":0,"d":"0.00 kr"}},{"$f":"C25*E25","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Mellanstora montrar à",null,{"$f":"B26*E26","v":{"v":0,"d":"0.00 kr"}},{"$f":"C26*E26","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Små montrar à",null,{"$f":"B27*E27","v":{"v":0,"d":"0.00 kr"}},{"$f":"C27*E27","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":5},{"$f":"SUM(F25:F27)","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUM(G25:G27)","v":{"v":0,"d":"0.00 kr"}}]
[]
[null,"Sålda produkter"]
[null,"Beräknad","Faktisk",null,null,"Beräknad","Faktisk"]
[{"$nulls":3},"Produkter à",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 kr"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Produkter à",null,{"$f":"B33*E33","v":{"v":0,"d":"0.00 kr"}},{"$f":"C33*E33","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Produkter à",null,{"$f":"B34*E34","v":{"v":0,"d":"0.00 kr"}},{"$f":"C34*E34","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":3},"Produkter à",null,{"$f":"B35*E35","v":{"v":0,"d":"0.00 kr"}},{"$f":"C35*E35","v":{"v":0,"d":"0.00 kr"}}]
[{"$nulls":5},{"$f":"SUM(F32:F35)","v":{"v":0,"d":"0.00 kr"}},{"$f":"SUM(G32:G35)","v":{"v":0,"d":"0.00 kr"}}]

{"sheet":"Sammanfattning","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[2,1,2,6],[3,5,3,6]]}
[]
[]
[null,"Evenemangsbudget för \n[Evenemangets namn]"]
[{"$nulls":5},"Sammanfattning av vinst – förlust"]
[]
[{"$nulls":5},"Beräknad","Faktisk"]
[null,"Total inkomst",{"$nulls":3},{"$f":"Intäkter!F7","v":{"v":1936,"d":"1,936.00 kr"}},{"$f":"Intäkter!G7","v":{"v":1831,"d":"1,831.00 kr"}}]
[null,"Summa utgifter",{"$nulls":3},{"$f":"Utgifter!H7","v":{"v":1145,"d":"1,145.00 kr"}},{"$f":"Utgifter!I7","v":{"v":395,"d":"395.00 kr"}}]
[null,"Summa vinst (eller förlust)",{"$nulls":3},{"$f":"F7-F8","v":{"v":791,"d":"791.00 kr"}},{"$f":"G7-G8","v":{"v":1436,"d":"1,436.00 kr"}}]