{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Výdaje","Příjmy","Souhrn zisků a ztrát"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Výdaje","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Rozpočet události pro [název události] ",{"$nulls":5},"VÝDAJE"]
[]
[null,"CELKOVÉ VÝDAJE",{"$nulls":4},"Odhad","Skutečnost"]
[{"$nulls":6},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"882.00 Kč"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"333.00 Kč"}}]
[]
[null,"Prostory","Odhad","Skutečnost",null,"Občerstvení","Odhad","Skutečnost"]
[null,"Poplatky za pronájem prostor",{"v":500,"d":"500.00 Kč"},null,null,"Jídlo"]
[null,"Personál v místě konání",{"$nulls":3},"Nápoje",{"v":20,"d":"20.00 Kč"}]
[null,"Vybavení",{"$nulls":3},"Ubrusy",null,{"v":20,"d":"20.00 Kč"}]
[null,"Stoly a židle",{"$nulls":3},"Zaměstnanci a spropitné"]
[null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka1[Odhad])","v":{"v":500,"d":"500.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka1[Skutečnost])","v":{"v":0,"d":"0.00 Kč"}},null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka3[Odhad])","v":{"v":20,"d":"20.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka3[Skutečnost])","v":{"v":20,"d":"20.00 Kč"}}]
[]
[null,"Výzdoba","Odhad","Skutečnost",null,"Program","Odhad","Skutečnost"]
[null,"Květiny",{"v":200,"d":"200.00 Kč"},{"v":300,"d":"300.00 Kč"},null,"Účinkující"]
[null,"Svíčky",{"$nulls":3},"Moderátoři",{"v":30,"d":"30.00 Kč"}]
[null,"Osvětlení",{"$nulls":3},"Cestování"]
[null,"Balonky",{"$nulls":3},"Hotel"]
[null,"Papírová výzdoba",{"$nulls":3},"Jiné"]
[null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka4[Odhad])","v":{"v":200,"d":"200.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka4[Skutečnost])","v":{"v":300,"d":"300.00 Kč"}},null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka5[Odhad])","v":{"v":30,"d":"30.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka5[Skutečnost])","v":{"v":0,"d":"0.00 Kč"}}]
[]
[null,"Propagace","Odhad","Skutečnost",null,"Ceny","Odhad","Skutečnost"]
[null,"Grafické práce",{"$nulls":3},"Stuhy, plakety, poháry"]
[null,"Fotokopírování a tisk",{"v":20,"d":"20.00 Kč"},null,null,"Dary",{"v":100,"d":"100.00 Kč"}]
[null,"Poštovné",{"$nulls":3},"Celkem",{"$f":"SUBTOTAL(109,Tabulka7[Odhad])","v":{"v":100,"d":"100.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka7[Skutečnost])","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka6[Odhad])","v":{"v":20,"d":"20.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka6[Skutečnost])","v":{"v":0,"d":"0.00 Kč"}}]
[]
[null,"Různé","Odhad","Skutečnost"]
[null,"Telefon",null,{"v":13,"d":"13.00 Kč"}]
[null,"Doprava",{"v":12,"d":"12.00 Kč"}]
[null,"Kancelářské potřeby"]
[null,"Faxové služby"]
[null,"Celkem",{"$f":"SUBTOTAL(109,Tabulka8[Odhad])","v":{"v":12,"d":"12.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka8[Skutečnost])","v":{"v":13,"d":"13.00 Kč"}}]

{"sheet":"Příjmy","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Rozpočet události pro [název události] ",{"$nulls":4},"PŘÍJMY"]
[]
[null,"CELKOVÉ PŘÍJMY",{"$nulls":3},"Odhad","Skutečnost"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"1,936.00 Kč"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"1,831.00 Kč"}}]
[]
[null,"VSTUPNÉ"]
[null,"Odhad","Skutečnost","Typ","Cena","Předpokládaný příjem","Skutečný příjem"]
[null,300,278,"Dospělí @",{"v":5,"d":"5.00 Kč"},{"$f":"B8*E8","v":{"v":1500,"d":"1,500.00 Kč"}},{"$f":"C8*E8","v":{"v":1390,"d":"1,390.00 Kč"}}]
[null,197,195,"Děti @",{"v":2,"d":"2.00 Kč"},{"$f":"B9*E9","v":{"v":394,"d":"394.00 Kč"}},{"$f":"C9*E9","v":{"v":390,"d":"390.00 Kč"}}]
[null,42,51,"Ostatní @",{"v":1,"d":"1.00 Kč"},{"$f":"B10*E10","v":{"v":42,"d":"42.00 Kč"}},{"$f":"C10*E10","v":{"v":51,"d":"51.00 Kč"}}]
[null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabulka9[Předpokládaný příjem])","v":{"v":1936,"d":"1,936.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka9[Skutečný příjem])","v":{"v":1831,"d":"1,831.00 Kč"}}]
[]
[null,"REKLAMY V PROGRAMU"]
[null,"Odhad","Skutečnost","Typ","Cena","Předpokládaný příjem","Skutečný příjem"]
[null,12,null,"Celá strana @",null,{"$f":"B15*E15","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C15*E15","v":{"v":0,"d":"0.00 Kč"}}]
[null,null,158,"Polovina strany @",null,{"$f":"B16*E16","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C16*E16","v":{"v":0,"d":"0.00 Kč"}}]
[null,4,null,"Čtvrtina strany @",null,{"$f":"B17*E17","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C17*E17","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabulka10[Předpokládaný příjem])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka10[Skutečný příjem])","v":{"v":0,"d":"0.00 Kč"}}]
[]
[null,"VYSTAVOVATELÉ, PRODEJCI"]
[null,"Odhad","Skutečnost","Typ","Cena","Předpokládaný příjem","Skutečný příjem"]
[null,23,null,"Velký stánek @",null,{"$f":"B22*E22","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C22*E22","v":{"v":0,"d":"0.00 Kč"}}]
[null,354,null,"Střední stánek @",null,{"$f":"B23*E23","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C23*E23","v":{"v":0,"d":"0.00 Kč"}}]
[null,56,null,"Malý stánek @",null,{"$f":"B24*E24","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C24*E24","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabulka11[Předpokládaný příjem])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka11[Skutečný příjem])","v":{"v":0,"d":"0.00 Kč"}}]
[]
[null,"PRODEJ PŘEDMĚTŮ"]
[null,"Odhad","Skutečnost","Typ","Cena","Předpokládaný příjem","Skutečný příjem"]
[{"$nulls":3},"Položky @",null,{"$f":"B29*E29","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C29*E29","v":{"v":0,"d":"0.00 Kč"}}]
[null,123,null,"Položky @",null,{"$f":"B30*E30","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C30*E30","v":{"v":0,"d":"0.00 Kč"}}]
[{"$nulls":3},"Položky @",null,{"$f":"B31*E31","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C31*E31","v":{"v":0,"d":"0.00 Kč"}}]
[null,13,null,"Položky @",null,{"$f":"B32*E32","v":{"v":0,"d":"0.00 Kč"}},{"$f":"C32*E32","v":{"v":0,"d":"0.00 Kč"}}]
[null,"Celkem",{"$nulls":3},{"$f":"SUBTOTAL(109,Tabulka12[Předpokládaný příjem])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,Tabulka12[Skutečný příjem])","v":{"v":0,"d":"0.00 Kč"}}]

{"sheet":"Souhrn zisků a ztrát","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"Rozpočet události pro [název události] ",{"$nulls":4},"SOUHRN ZISKŮ "]
[{"$nulls":6},"a ztrát"]
[]
[]
[null,null,"Odhad","Skutečnost"]
[null,"Celkové příjmy",{"$f":"Příjmy!F4","v":{"v":1936,"d":"1,936.00 Kč"}},{"$f":"Příjmy!G4","v":{"v":1831,"d":"1,831.00 Kč"}}]
[null,"Celkové výdaje",{"$f":"Výdaje!G4","v":{"v":882,"d":"882.00 Kč"}},{"$f":"Výdaje!H4","v":{"v":333,"d":"333.00 Kč"}}]
[]
[null,"Celkový zisk (nebo ztráta)",{"$f":"C6-C7","v":{"v":1054,"d":"1,054.00 Kč"}},{"$f":"D6-D7","v":{"v":1498,"d":"1,498.00 Kč"}}]