{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["ZAČÁTEK","PLÁNOVANÉ VÝDAJE","SKUTEČNÉ VÝDAJE","ROZDÍLY VÝDAJŮ","ANALÝZA VÝDAJŮ"],"not_rendered":{"charts":3,"images":3,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"ZAČÁTEK","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"INFORMACE O TÉTO ŠABLONĚ"]
[null,"Pomocí tohoto sešitu s rozpočtem firemních výdajů můžete sledovat plánované a skutečné výdaje a rozdíly."]
[null,"Vyplňte název společnosti a přidejte logo."]
[null,"Podrobnosti zadejte do tabulek na listech Plánované výdaje a Skutečné výdaje."]
[null,"Tabulky na listu Rozdíly výdajů a tabulka a grafy na listu Analýza výdajů se zaktualizují automaticky."]
[null,"Poznámka: "]
[null,"Další pokyny jsou k dispozici ve sloupci A na každém listu. Tento text je záměrně skrytý. Pokud tento text chcete odebrat, vyberte sloupec A a stiskněte klávesu ODSTRANIT. Pokud tento text chcete zobrazit, vyberte sloupec A a změňte barvu písma."]
[null,"Další informace o tabulkách můžete získat tak, že v tabulce stisknete klávesu SHIFT a potom F10, vyberete možnost TABULKA a pak vyberete ALTERNATIVNÍ TEXT."]

{"sheet":"PLÁNOVANÉ VÝDAJE","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[3,17,12,19],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["Do příslušných tabulek na tomto listu zadejte plánované náklady na zaměstnance, kancelář, marketing a školení nebo cestování. Součty se počítají automaticky. V buňkách v tomto sloupci jsou užitečné pokyny k tomu, jak tento list používat. Začněte stisknutím šipky dolů.",{"$nulls":14}," "]
["Do buňky vpravo zadejte název společnosti a do buňky N2 vložte logo. V buňce K2 je název tohoto listu.","Název společnosti",{"$nulls":8},"Podrobné odhady výdajů",null,null,"V této buňce je zástupný symbol loga."]
["V buňce K3 je tip.",{"$nulls":9},"Stínované buňky jsou výpočty."]
["V buňce vpravo je popisek Plánované výdaje. V buňkách C4 až N4 jsou měsíce a v buňce O4 je popisek Rok. V buňce R4 jsou pokyny, jak tuto šablonu používat.","PLÁNOVANÉ VÝDAJE","LED","ÚNO","BŘE","DUB","KVĚ","ČVN","ČVC","SRP","ZÁŘ","ŘÍJ","LIS","PRO","ROK",null,null,"Tip: JAK POUŽÍVAT TUTO ŠABLONU\nZadejte data do bílých buněk na listech PLÁNOVANÉ VÝDAJE a SKUTEČNÉ VÝDAJE. Listy ROZDÍLY VÝDAJŮ a ANALÝZA VÝDAJŮ se pak zaktualizují automaticky. Pokud přidáte řádek na jeden list, musíte odpovídajícím způsobem upravit i další listy."]
["Do tabulky PlanZamestnanci, která začíná v buňce napravo, zadejte náklady na zaměstnance. Další pokyn je v buňce A10.","Náklady na zaměstnance","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Mzdy",{"v":85000,"d":"85,000.00 Kč"},{"v":85000,"d":"85,000.00 Kč"},{"v":85000,"d":"85,000.00 Kč"},{"v":87500,"d":"87,500.00 Kč"},{"v":87500,"d":"87,500.00 Kč"},{"v":87500,"d":"87,500.00 Kč"},{"v":87500,"d":"87,500.00 Kč"},{"v":92400,"d":"92,400.00 Kč"},{"v":92400,"d":"92,400.00 Kč"},{"v":92400,"d":"92,400.00 Kč"},{"v":92400,"d":"92,400.00 Kč"},{"v":92400,"d":"92,400.00 Kč"},{"$f":"SUM(C6:N6)","v":{"v":1067000,"d":"1,067,000.00 Kč"}}]
[null,"Benefity",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 Kč"}},{"v":22950,"d":"22,950.00 Kč"},{"v":22950,"d":"22,950.00 Kč"},{"v":23625,"d":"23,625.00 Kč"},{"v":23625,"d":"23,625.00 Kč"},{"v":23625,"d":"23,625.00 Kč"},{"v":23625,"d":"23,625.00 Kč"},{"v":24948,"d":"24,948.00 Kč"},{"v":24948,"d":"24,948.00 Kč"},{"v":24948,"d":"24,948.00 Kč"},{"v":24948,"d":"24,948.00 Kč"},{"v":24948,"d":"24,948.00 Kč"},{"$f":"SUM(C7:N7)","v":{"v":288090,"d":"288,090.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,PlanZamestnanci[Leden])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Únor])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Březen])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Duben])","v":{"v":111125,"d":"111,125.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Květen])","v":{"v":111125,"d":"111,125.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Červen])","v":{"v":111125,"d":"111,125.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Červenec])","v":{"v":111125,"d":"111,125.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Srpen])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Září])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Říjen])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Listopad])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[Prosinec])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,PlanZamestnanci[ROK])","v":{"v":1355090,"d":"1,355,090.00 Kč"}}]
[]
["Do tabulky PlanKancelar, která začíná v buňce napravo, zadejte náklady na kancelář. Další pokyn je v buňce A21.","Náklady na kancelář","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Pronájem kanceláře",{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"$f":"SUM(C11:N11)","v":{"v":117600,"d":"117,600.00 Kč"}}]
[null,"Plyn",null,{"v":400,"d":"400.00 Kč"},{"v":400,"d":"400.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":400,"d":"400.00 Kč"},{"v":400,"d":"400.00 Kč"},{"v":2300,"d":"2,300.00 Kč"}]
[null,"Elektřina",{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":300,"d":"300.00 Kč"},{"v":3600,"d":"3,600.00 Kč"}]
[null,"Voda",{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":40,"d":"40.00 Kč"},{"v":480,"d":"480.00 Kč"}]
[null,"Telefon",{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":250,"d":"250.00 Kč"},{"v":3000,"d":"3,000.00 Kč"}]
[null,"Připojení k internetu",{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":2160,"d":"2,160.00 Kč"}]
[null,"Kancelářské potřeby",{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":2400,"d":"2,400.00 Kč"}]
[null,"Zabezpečení",{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":7200,"d":"7,200.00 Kč"}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,PlanKancelar[Leden])","v":{"v":11370,"d":"11,370.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Únor])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Březen])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Duben])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Květen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Červen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Červenec])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Srpen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Září])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Říjen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Listopad])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[Prosinec])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,PlanKancelar[ROK])","v":{"v":138740,"d":"138,740.00 Kč"}}]
[]
["Do tabulky PlanMarketing, která začíná v buňce napravo, zadejte náklady na marketing. Další pokyn je v buňce A30.","Náklady na marketing","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Hostování webu",{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"$f":"SUM(C22:N22)","v":{"v":6000,"d":"6,000.00 Kč"}}]
[null,"Aktualizace webu",{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":1000,"d":"1,000.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":1000,"d":"1,000.00 Kč"},{"v":4000,"d":"4,000.00 Kč"}]
[null,"Příprava marketingových materiálů",{"v":5000,"d":"5,000.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":20000,"d":"20,000.00 Kč"}]
[null,"Tisk marketingových materiálů",{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":2400,"d":"2,400.00 Kč"}]
[null,"Marketingové akce",{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":5000,"d":"5,000.00 Kč"},{"v":33000,"d":"33,000.00 Kč"}]
[null,"Různé výdaje",{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":2400,"d":"2,400.00 Kč"}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,PlanMarketing[Leden])","v":{"v":8100,"d":"8,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Únor])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Březen])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Duben])","v":{"v":11100,"d":"11,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Květen])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Červen])","v":{"v":3900,"d":"3,900.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Červenec])","v":{"v":8100,"d":"8,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Srpen])","v":{"v":6100,"d":"6,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Září])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Říjen])","v":{"v":8100,"d":"8,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Listopad])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[Prosinec])","v":{"v":6900,"d":"6,900.00 Kč"}},{"$f":"SUBTOTAL(109,PlanMarketing[ROK])","v":{"v":67800,"d":"67,800.00 Kč"}}]
[]
["Do tabulky PlanSkoleniACestovani, která začíná v buňce napravo, zadejte výdaje na školení a cestování. Další pokyn je v buňce A35.","Školení a cestování","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Externí školení",{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"$f":"SUM(C31:N31)","v":{"v":24000,"d":"24,000.00 Kč"}}]
[null,"Náklady na cestování na školení",{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"v":2000,"d":"2,000.00 Kč"},{"$f":"SUM(C32:N32)","v":{"v":24000,"d":"24,000.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Leden])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Únor])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Březen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Duben])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Květen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Červen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Červenec])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Srpen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Září])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Říjen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Listopad])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[Prosinec])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,PlanSkoleniACestovani[ROK])","v":{"v":48000,"d":"48,000.00 Kč"}}]
[]
["V tabulce PlanCelkem, která začíná v buňce napravo, se automaticky počítají součty.","SOUČTY","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","Rok"]
[null,"Měsíční plánované výdaje",{"$f":"PlanSkoleniACestovani[[#Totals],[Leden]]+PlanMarketing[[#Totals],[Leden]]+PlanKancelar[[#Totals],[Leden]]+PlanZamestnanci[[#Totals],[Leden]]","v":{"v":131420,"d":"131,420.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Únor]]+PlanMarketing[[#Totals],[Únor]]+PlanKancelar[[#Totals],[Únor]]+PlanZamestnanci[[#Totals],[Únor]]","v":{"v":126820,"d":"126,820.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Březen]]+PlanMarketing[[#Totals],[Březen]]+PlanKancelar[[#Totals],[Březen]]+PlanZamestnanci[[#Totals],[Březen]]","v":{"v":126820,"d":"126,820.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Duben]]+PlanMarketing[[#Totals],[Duben]]+PlanKancelar[[#Totals],[Duben]]+PlanZamestnanci[[#Totals],[Duben]]","v":{"v":137695,"d":"137,695.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Květen]]+PlanMarketing[[#Totals],[Květen]]+PlanKancelar[[#Totals],[Květen]]+PlanZamestnanci[[#Totals],[Květen]]","v":{"v":129695,"d":"129,695.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Červen]]+PlanMarketing[[#Totals],[Červen]]+PlanKancelar[[#Totals],[Červen]]+PlanZamestnanci[[#Totals],[Červen]]","v":{"v":130495,"d":"130,495.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Červenec]]+PlanMarketing[[#Totals],[Červenec]]+PlanKancelar[[#Totals],[Červenec]]+PlanZamestnanci[[#Totals],[Červenec]]","v":{"v":134695,"d":"134,695.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Srpen]]+PlanMarketing[[#Totals],[Srpen]]+PlanKancelar[[#Totals],[Srpen]]+PlanZamestnanci[[#Totals],[Srpen]]","v":{"v":138918,"d":"138,918.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Září]]+PlanMarketing[[#Totals],[Září]]+PlanKancelar[[#Totals],[Září]]+PlanZamestnanci[[#Totals],[Září]]","v":{"v":135918,"d":"135,918.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Říjen]]+PlanMarketing[[#Totals],[Říjen]]+PlanKancelar[[#Totals],[Říjen]]+PlanZamestnanci[[#Totals],[Říjen]]","v":{"v":140918,"d":"140,918.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Listopad]]+PlanMarketing[[#Totals],[Listopad]]+PlanKancelar[[#Totals],[Listopad]]+PlanZamestnanci[[#Totals],[Listopad]]","v":{"v":136218,"d":"136,218.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[Prosinec]]+PlanMarketing[[#Totals],[Prosinec]]+PlanKancelar[[#Totals],[Prosinec]]+PlanZamestnanci[[#Totals],[Prosinec]]","v":{"v":140018,"d":"140,018.00 Kč"}},{"$f":"PlanSkoleniACestovani[[#Totals],[ROK]]+PlanMarketing[[#Totals],[ROK]]+PlanKancelar[[#Totals],[ROK]]+PlanZamestnanci[[#Totals],[ROK]]","v":{"v":1609630,"d":"1,609,630.00 Kč"}}]
[null,"CELKOVÉ plánované výdaje",{"$f":"SUM($C$36:C36)","v":{"v":131420,"d":"131,420.00 Kč"}},{"$f":"SUM($C$36:D36)","v":{"v":258240,"d":"258,240.00 Kč"}},{"$f":"SUM($C$36:E36)","v":{"v":385060,"d":"385,060.00 Kč"}},{"$f":"SUM($C$36:F36)","v":{"v":522755,"d":"522,755.00 Kč"}},{"$f":"SUM($C$36:G36)","v":{"v":652450,"d":"652,450.00 Kč"}},{"$f":"SUM($C$36:H36)","v":{"v":782945,"d":"782,945.00 Kč"}},{"$f":"SUM($C$36:I36)","v":{"v":917640,"d":"917,640.00 Kč"}},{"$f":"SUM($C$36:J36)","v":{"v":1056558,"d":"1,056,558.00 Kč"}},{"$f":"SUM($C$36:K36)","v":{"v":1192476,"d":"1,192,476.00 Kč"}},{"$f":"SUM($C$36:L36)","v":{"v":1333394,"d":"1,333,394.00 Kč"}},{"$f":"SUM($C$36:M36)","v":{"v":1469612,"d":"1,469,612.00 Kč"}},{"$f":"SUM($C$36:N36)","v":{"v":1609630,"d":"1,609,630.00 Kč"}}]

{"sheet":"SKUTEČNÉ VÝDAJE","index":2,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["Do příslušných tabulek na tomto listu zadejte skutečné náklady na zaměstnance, kancelář, marketing a školení nebo cestování. Součty se počítají automaticky. V buňkách v tomto sloupci jsou užitečné pokyny k tomu, jak tento list používat. Začněte stisknutím šipky dolů.",{"$nulls":14}," "]
["V buňce vpravo se automaticky aktualizuje název společnosti. V buňce K2 je název tohoto listu. Do buňky N2 vložte logo.",{"$f":"'PLÁNOVANÉ VÝDAJE'!B2:D3","v":"Název společnosti"},{"$nulls":8},{"$f":"nazev_listu","v":"Podrobné odhady výdajů"},null,null,"V této buňce je zástupný symbol loga."]
["V buňce K3 je tip.",{"$nulls":9},"Stínované buňky jsou výpočty."]
["V buňce vpravo je popisek Skutečné výdaje. V buňkách C4 až N4 jsou měsíce a v buňce O4 je popisek Rok.","SKUTEČNÉ VÝDAJE","LED","ÚNO","BŘE","DUB","KVĚ","ČVN","ČVC","SRP","ZÁŘ","ŘÍJ","LIS","PRO","ROK"]
["Do tabulky SkutecnostZamestnanci, která začíná v buňce napravo, zadejte náklady na zaměstnance. Další pokyn je v buňce A10.","Náklady na zaměstnance","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Mzdy",{"v":85000,"d":"85,000.00 Kč"},{"v":85000,"d":"85,000.00 Kč"},{"v":85000,"d":"85,000.00 Kč"},{"v":88000,"d":"88,000.00 Kč"},{"v":88000,"d":"88,000.00 Kč"},{"v":88000,"d":"88,000.00 Kč"},{"$nulls":6},{"$f":"SUM(C6:N6)","v":{"v":519000,"d":"519,000.00 Kč"}}]
[null,"Benefity",{"$f":"C6*0.27","v":{"v":22950,"d":"22,950.00 Kč"}},{"v":22950,"d":"22,950.00 Kč"},{"v":22950,"d":"22,950.00 Kč"},{"v":23760,"d":"23,760.00 Kč"},{"v":23760,"d":"23,760.00 Kč"},{"v":23760,"d":"23,760.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$f":"SUM(C7:N7)","v":{"v":140130,"d":"140,130.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Leden])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Únor])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Březen])","v":{"v":107950,"d":"107,950.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Duben])","v":{"v":111760,"d":"111,760.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Květen])","v":{"v":111760,"d":"111,760.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Červen])","v":{"v":111760,"d":"111,760.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Červenec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Srpen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Září])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Říjen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Listopad])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[Prosinec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostZamestnanci[ROK])","v":{"v":659130,"d":"659,130.00 Kč"}}]
[]
["Do tabulky SkutecnostKancelar, která začíná v buňce napravo, zadejte náklady na kancelář. Další pokyn je v buňce A21.","Náklady na kancelář","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Pronájem kanceláře",{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"v":9800,"d":"9,800.00 Kč"},{"$nulls":6},{"$f":"SUM(C11:N11)","v":{"v":58800,"d":"58,800.00 Kč"}}]
[null,"Plyn",{"v":4,"d":"4.00 Kč"},{"v":430,"d":"430.00 Kč"},{"v":385,"d":"385.00 Kč"},{"v":230,"d":"230.00 Kč"},{"v":87,"d":"87.00 Kč"},{"v":88,"d":"88.00 Kč"},{"$nulls":6},{"v":1224,"d":"1,224.00 Kč"}]
[null,"Elektřina",{"v":288,"d":"288.00 Kč"},{"v":278,"d":"278.00 Kč"},{"v":268,"d":"268.00 Kč"},{"v":299,"d":"299.00 Kč"},{"v":306,"d":"306.00 Kč"},{"v":290,"d":"290.00 Kč"},{"$nulls":6},{"v":1729,"d":"1,729.00 Kč"}]
[null,"Voda",{"v":35,"d":"35.00 Kč"},{"v":33,"d":"33.00 Kč"},{"v":34,"d":"34.00 Kč"},{"v":36,"d":"36.00 Kč"},{"v":34,"d":"34.00 Kč"},{"v":36,"d":"36.00 Kč"},{"$nulls":6},{"v":208,"d":"208.00 Kč"}]
[null,"Telefon",{"v":224,"d":"224.00 Kč"},{"v":235,"d":"235.00 Kč"},{"v":265,"d":"265.00 Kč"},{"v":245,"d":"245.00 Kč"},{"v":245,"d":"245.00 Kč"},{"v":220,"d":"220.00 Kč"},{"$nulls":6},{"v":1434,"d":"1,434.00 Kč"}]
[null,"Připojení k internetu",{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"v":180,"d":"180.00 Kč"},{"$nulls":6},{"v":1080,"d":"1,080.00 Kč"}]
[null,"Kancelářské potřeby",{"v":256,"d":"256.00 Kč"},{"v":142,"d":"142.00 Kč"},{"v":160,"d":"160.00 Kč"},{"v":221,"d":"221.00 Kč"},{"v":256,"d":"256.00 Kč"},{"v":240,"d":"240.00 Kč"},{"$nulls":6},{"v":1275,"d":"1,275.00 Kč"}]
[null,"Zabezpečení",{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":600,"d":"600.00 Kč"},{"$nulls":6},{"v":3600,"d":"3,600.00 Kč"}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,SkutecnostKancelar[Leden])","v":{"v":11387,"d":"11,387.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Únor])","v":{"v":11698,"d":"11,698.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Březen])","v":{"v":11692,"d":"11,692.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Duben])","v":{"v":11611,"d":"11,611.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Květen])","v":{"v":11508,"d":"11,508.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Červen])","v":{"v":11454,"d":"11,454.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Červenec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Srpen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Září])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Říjen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Listopad])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[Prosinec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostKancelar[ROK])","v":{"v":69350,"d":"69,350.00 Kč"}}]
[]
["Do tabulky SkutecnostMarketing, která začíná v buňce napravo, zadejte náklady na marketing. Další pokyn je v buňce A30.","Náklady na marketing","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Hostování webu",{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":500,"d":"500.00 Kč"},{"$nulls":6},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"3,000.00 Kč"}}]
[null,"Aktualizace webu",{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":200,"d":"200.00 Kč"},{"v":1500,"d":"1,500.00 Kč"},{"$nulls":6},{"v":2500,"d":"2,500.00 Kč"}]
[null,"Příprava marketingových materiálů",{"v":4800,"d":"4,800.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":5500,"d":"5,500.00 Kč"},{"v":0,"d":"0.00 Kč"},{"v":0,"d":"0.00 Kč"},{"$nulls":6},{"v":10300,"d":"10,300.00 Kč"}]
[null,"Tisk marketingových materiálů",{"v":100,"d":"100.00 Kč"},{"v":500,"d":"500.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":100,"d":"100.00 Kč"},{"v":600,"d":"600.00 Kč"},{"v":180,"d":"180.00 Kč"},{"$nulls":6},{"v":1580,"d":"1,580.00 Kč"}]
[null,"Marketingové akce",{"v":1800,"d":"1,800.00 Kč"},{"v":2200,"d":"2,200.00 Kč"},{"v":2200,"d":"2,200.00 Kč"},{"v":4700,"d":"4,700.00 Kč"},{"v":1500,"d":"1,500.00 Kč"},{"v":2300,"d":"2,300.00 Kč"},{"$nulls":6},{"v":14700,"d":"14,700.00 Kč"}]
[null,"Různé výdaje",{"v":145,"d":"145.00 Kč"},{"v":156,"d":"156.00 Kč"},{"v":123,"d":"123.00 Kč"},{"v":223,"d":"223.00 Kč"},{"v":187,"d":"187.00 Kč"},{"v":245,"d":"245.00 Kč"},{"$nulls":6},{"v":1079,"d":"1,079.00 Kč"}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,SkutecnostMarketing[Leden])","v":{"v":7545,"d":"7,545.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Únor])","v":{"v":3556,"d":"3,556.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Březen])","v":{"v":3123,"d":"3,123.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Duben])","v":{"v":11223,"d":"11,223.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Květen])","v":{"v":2987,"d":"2,987.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Červen])","v":{"v":4725,"d":"4,725.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Červenec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Srpen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Září])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Říjen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Listopad])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[Prosinec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostMarketing[ROK])","v":{"v":33159,"d":"33,159.00 Kč"}}]
[]
["Do tabulky SkutecnostSkoleniACestovani, která začíná v buňce napravo, zadejte výdaje na školení a cestování. Další pokyn je v buňce A35.","Školení a cestování","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Externí školení",{"v":1600,"d":"1,600.00 Kč"},{"v":2400,"d":"2,400.00 Kč"},{"v":1400,"d":"1,400.00 Kč"},{"v":1600,"d":"1,600.00 Kč"},{"v":1200,"d":"1,200.00 Kč"},{"v":2800,"d":"2,800.00 Kč"},{"$nulls":6},{"$f":"SUM(C31:N31)","v":{"v":11000,"d":"11,000.00 Kč"}}]
[null,"Náklady na cestování na školení",{"v":1200,"d":"1,200.00 Kč"},{"v":2200,"d":"2,200.00 Kč"},{"v":1400,"d":"1,400.00 Kč"},{"v":1200,"d":"1,200.00 Kč"},{"v":800,"d":"800.00 Kč"},{"v":3500,"d":"3,500.00 Kč"},{"$nulls":6},{"$f":"SUM(C32:N32)","v":{"v":10300,"d":"10,300.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Leden])","v":{"v":2800,"d":"2,800.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Únor])","v":{"v":4600,"d":"4,600.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Březen])","v":{"v":2800,"d":"2,800.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Duben])","v":{"v":2800,"d":"2,800.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Květen])","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Červen])","v":{"v":6300,"d":"6,300.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Červenec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Srpen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Září])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Říjen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Listopad])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[Prosinec])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,SkutecnostSkoleniACestovani[ROK])","v":{"v":21300,"d":"21,300.00 Kč"}}]
[]
["V tabulce SkutecnostCelkem, která začíná v buňce napravo, se automaticky počítají celkové skutečné výdaje.","CELKOVÉ plánované výdaje","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","Rok"]
[null,"Měsíční skutečné výdaje",{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Leden]]+SkutecnostMarketing[[#Totals],[Leden]]+SkutecnostKancelar[[#Totals],[Leden]]+SkutecnostZamestnanci[[#Totals],[Leden]]","v":{"v":129682,"d":"129,682.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Únor]]+SkutecnostMarketing[[#Totals],[Únor]]+SkutecnostKancelar[[#Totals],[Únor]]+SkutecnostZamestnanci[[#Totals],[Únor]]","v":{"v":127804,"d":"127,804.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Březen]]+SkutecnostMarketing[[#Totals],[Březen]]+SkutecnostKancelar[[#Totals],[Březen]]+SkutecnostZamestnanci[[#Totals],[Březen]]","v":{"v":125565,"d":"125,565.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Duben]]+SkutecnostMarketing[[#Totals],[Duben]]+SkutecnostKancelar[[#Totals],[Duben]]+SkutecnostZamestnanci[[#Totals],[Duben]]","v":{"v":137394,"d":"137,394.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Květen]]+SkutecnostMarketing[[#Totals],[Květen]]+SkutecnostKancelar[[#Totals],[Květen]]+SkutecnostZamestnanci[[#Totals],[Květen]]","v":{"v":128255,"d":"128,255.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Červen]]+SkutecnostMarketing[[#Totals],[Červen]]+SkutecnostKancelar[[#Totals],[Červen]]+SkutecnostZamestnanci[[#Totals],[Červen]]","v":{"v":134239,"d":"134,239.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Červenec]]+SkutecnostMarketing[[#Totals],[Červenec]]+SkutecnostKancelar[[#Totals],[Červenec]]+SkutecnostZamestnanci[[#Totals],[Červenec]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Srpen]]+SkutecnostMarketing[[#Totals],[Srpen]]+SkutecnostKancelar[[#Totals],[Srpen]]+SkutecnostZamestnanci[[#Totals],[Srpen]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Září]]+SkutecnostMarketing[[#Totals],[Září]]+SkutecnostKancelar[[#Totals],[Září]]+SkutecnostZamestnanci[[#Totals],[Září]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Říjen]]+SkutecnostMarketing[[#Totals],[Říjen]]+SkutecnostKancelar[[#Totals],[Říjen]]+SkutecnostZamestnanci[[#Totals],[Říjen]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Listopad]]+SkutecnostMarketing[[#Totals],[Listopad]]+SkutecnostKancelar[[#Totals],[Listopad]]+SkutecnostZamestnanci[[#Totals],[Listopad]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[Prosinec]]+SkutecnostMarketing[[#Totals],[Prosinec]]+SkutecnostKancelar[[#Totals],[Prosinec]]+SkutecnostZamestnanci[[#Totals],[Prosinec]]","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[ROK]]+SkutecnostMarketing[[#Totals],[ROK]]+SkutecnostKancelar[[#Totals],[ROK]]+SkutecnostZamestnanci[[#Totals],[ROK]]","v":{"v":782939,"d":"782,939.00 Kč"}}]
[null,"CELKOVÉ skutečné výdaje",{"$f":"SUM($C$36:C36)","v":{"v":129682,"d":"129,682.00 Kč"}},{"$f":"SUM($C$36:D36)","v":{"v":257486,"d":"257,486.00 Kč"}},{"$f":"SUM($C$36:E36)","v":{"v":383051,"d":"383,051.00 Kč"}},{"$f":"SUM($C$36:F36)","v":{"v":520445,"d":"520,445.00 Kč"}},{"$f":"SUM($C$36:G36)","v":{"v":648700,"d":"648,700.00 Kč"}},{"$f":"SUM($C$36:H36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:I36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:J36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:K36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:L36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:M36)","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"SUM($C$36:N36)","v":{"v":782939,"d":"782,939.00 Kč"}}]

{"sheet":"ROZDÍLY VÝDAJŮ","index":3,"n_rows":37,"n_cols":16,"rows_kept":37,"merged":[[1,1,2,3],[1,10,1,12],[1,13,2,14],[2,10,2,12],[8,1,8,2],[19,1,19,2],[28,1,28,2],[33,1,33,2]]}
["V příslušných tabulkách na tomto listu se automaticky počítají rozdíly náklady na zaměstnance, kancelář, marketing a školení nebo cestování. V buňkách v tomto sloupci jsou užitečné pokyny k tomu, jak tento list používat. Začněte stisknutím šipky dolů.",{"$nulls":14}," "]
["V buňce vpravo se automaticky aktualizuje název společnosti. V buňce K2 je název tohoto listu. Do buňky N2 vložte logo.",{"$f":"'PLÁNOVANÉ VÝDAJE'!B2:D3","v":"Název společnosti"},{"$nulls":8},{"$f":"nazev_listu","v":"Podrobné odhady výdajů"},null,null,"V této buňce je zástupný symbol loga."]
["V buňce K3 je tip.",{"$nulls":9},"Stínované buňky jsou výpočty."]
["V buňce vpravo je popisek Rozdíly výdajů. V buňkách C4 až N4 jsou měsíce a v buňce O4 je popisek Rok.","ROZDÍLY VÝDAJŮ","LED","ÚNO","BŘE","DUB","KVĚ","ČVN","ČVC","SRP","ZÁŘ","ŘÍJ","LIS","PRO","ROK"]
["V tabulce RozdilyZamestnanci, která začíná v buňce napravo, se automaticky počítají rozdíly ve náklady na zaměstnance. Další pokyn je v buňce A10.","Náklady na zaměstnance","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Mzdy",{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Leden]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Leden]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Leden]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Leden]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Únor]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Únor]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Únor]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Únor]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Březen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Březen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Březen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Březen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Duben]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Duben]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Duben]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Duben]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-500,"d":"-500.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Květen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Květen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Květen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Květen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-500,"d":"-500.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-500,"d":"-500.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červenec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červenec]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červenec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červenec]],SkutecnostZamestnanci[#Headers],0))","v":{"v":87500,"d":"87,500.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Srpen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Srpen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Srpen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Srpen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":92400,"d":"92,400.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Září]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Září]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Září]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Září]],SkutecnostZamestnanci[#Headers],0))","v":{"v":92400,"d":"92,400.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Říjen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Říjen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Říjen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Říjen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":92400,"d":"92,400.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Listopad]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Listopad]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Listopad]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Listopad]],SkutecnostZamestnanci[#Headers],0))","v":{"v":92400,"d":"92,400.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Prosinec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Prosinec]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Prosinec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Prosinec]],SkutecnostZamestnanci[#Headers],0))","v":{"v":92400,"d":"92,400.00 Kč"}},{"$f":"SUM(RozdilyZamestnanci[[#This Row],[Leden]:[Prosinec]])","v":{"v":548000,"d":"548,000.00 Kč"}}]
[null,"Benefity",{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Leden]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Leden]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Leden]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Leden]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Únor]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Únor]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Únor]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Únor]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Březen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Březen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Březen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Březen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Duben]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Duben]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Duben]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Duben]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-135,"d":"-135.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Květen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Květen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Květen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Květen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-135,"d":"-135.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":-135,"d":"-135.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červenec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červenec]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Červenec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Červenec]],SkutecnostZamestnanci[#Headers],0))","v":{"v":23625,"d":"23,625.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Srpen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Srpen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Srpen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Srpen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":24948,"d":"24,948.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Září]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Září]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Září]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Září]],SkutecnostZamestnanci[#Headers],0))","v":{"v":24948,"d":"24,948.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Říjen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Říjen]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Říjen]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Říjen]],SkutecnostZamestnanci[#Headers],0))","v":{"v":24948,"d":"24,948.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Listopad]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Listopad]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Listopad]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Listopad]],SkutecnostZamestnanci[#Headers],0))","v":{"v":24948,"d":"24,948.00 Kč"}},{"$f":"INDEX(PlanZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Prosinec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Prosinec]],PlanZamestnanci[#Headers],0))-INDEX(SkutecnostZamestnanci[],MATCH(INDEX(RozdilyZamestnanci[],ROW()-ROW(RozdilyZamestnanci[[#Headers],[Prosinec]]),1),INDEX(PlanZamestnanci[],,1),0),MATCH(RozdilyZamestnanci[[#Headers],[Prosinec]],SkutecnostZamestnanci[#Headers],0))","v":{"v":24948,"d":"24,948.00 Kč"}},{"$f":"SUM(RozdilyZamestnanci[[#This Row],[Leden]:[Prosinec]])","v":{"v":147960,"d":"147,960.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Leden])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Únor])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Březen])","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Duben])","v":{"v":-635,"d":"-635.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Květen])","v":{"v":-635,"d":"-635.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Červen])","v":{"v":-635,"d":"-635.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Červenec])","v":{"v":111125,"d":"111,125.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Srpen])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Září])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Říjen])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Listopad])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[Prosinec])","v":{"v":117348,"d":"117,348.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyZamestnanci[ROK])","v":{"v":695960,"d":"695,960.00 Kč"}}]
[]
["V tabulce RozdilyKancelar, která začíná v buňce napravo, se automaticky počítají rozdíly ve náklady na kancelář. Další pokyn je v buňce A21.","Náklady na kancelář","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Pronájem kanceláře",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":9800,"d":"9,800.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":58800,"d":"58,800.00 Kč"}}]
[null,"Plyn",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":-4,"d":"-4.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":-30,"d":"-30.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":15,"d":"15.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":-130,"d":"-130.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":13,"d":"13.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":12,"d":"12.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":400,"d":"400.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":400,"d":"400.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":1076,"d":"1,076.00 Kč"}}]
[null,"Elektřina",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":12,"d":"12.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":22,"d":"22.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":32,"d":"32.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":1,"d":"1.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":-6,"d":"-6.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":10,"d":"10.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":1871,"d":"1,871.00 Kč"}}]
[null,"Voda",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":5,"d":"5.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":7,"d":"7.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":6,"d":"6.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":4,"d":"4.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":6,"d":"6.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":4,"d":"4.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":272,"d":"272.00 Kč"}}]
[null,"Telefon",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":26,"d":"26.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":15,"d":"15.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":-15,"d":"-15.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":5,"d":"5.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":5,"d":"5.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":30,"d":"30.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":250,"d":"250.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":1566,"d":"1,566.00 Kč"}}]
[null,"Připojení k internetu",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":180,"d":"180.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":1080,"d":"1,080.00 Kč"}}]
[null,"Kancelářské potřeby",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":-56,"d":"-56.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":58,"d":"58.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":40,"d":"40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":-21,"d":"-21.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":-56,"d":"-56.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":-40,"d":"-40.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":1125,"d":"1,125.00 Kč"}}]
[null,"Zabezpečení",{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Leden]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Leden]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Únor]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Únor]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Březen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Březen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Duben]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Duben]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Květen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Květen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červen]],SkutecnostKancelar[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Červenec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Červenec]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Srpen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Srpen]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Září]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Září]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Říjen]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Říjen]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Listopad]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Listopad]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],PlanKancelar[#Headers],0))-INDEX(SkutecnostKancelar[],MATCH(INDEX(RozdilyKancelar[],ROW()-ROW(RozdilyKancelar[[#Headers],[Prosinec]]),1),INDEX(PlanKancelar[],,1),0),MATCH(RozdilyKancelar[[#Headers],[Prosinec]],SkutecnostKancelar[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"SUM(RozdilyKancelar[[#This Row],[Leden]:[Prosinec]])","v":{"v":3600,"d":"3,600.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,RozdilyKancelar[Leden])","v":{"v":-17,"d":"-17.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Únor])","v":{"v":72,"d":"72.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Březen])","v":{"v":78,"d":"78.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Duben])","v":{"v":-141,"d":"-141.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Květen])","v":{"v":-38,"d":"-38.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Červen])","v":{"v":16,"d":"16.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Červenec])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Srpen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Září])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Říjen])","v":{"v":11470,"d":"11,470.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Listopad])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[Prosinec])","v":{"v":11770,"d":"11,770.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyKancelar[ROK])","v":{"v":69390,"d":"69,390.00 Kč"}}]
[]
["V tabulce RozdilyMarketing, která začíná v buňce napravo, se automaticky počítají rozdíly ve náklady na marketing. Další pokyn je v buňce A30.","Náklady na marketing","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Hostování webu",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":3000,"d":"3,000.00 Kč"}}]
[null,"Aktualizace webu",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":-500,"d":"-500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":1000,"d":"1,000.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":1500,"d":"1,500.00 Kč"}}]
[null,"Příprava marketingových materiálů",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":-500,"d":"-500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":5000,"d":"5,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":5000,"d":"5,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":0,"d":"0.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":9700,"d":"9,700.00 Kč"}}]
[null,"Tisk marketingových materiálů",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":-300,"d":"-300.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":100,"d":"100.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":-400,"d":"-400.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":20,"d":"20.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":820,"d":"820.00 Kč"}}]
[null,"Marketingové akce",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":-200,"d":"-200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":-200,"d":"-200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":300,"d":"300.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":500,"d":"500.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":-300,"d":"-300.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":5000,"d":"5,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":5000,"d":"5,000.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":18300,"d":"18,300.00 Kč"}}]
[null,"Různé výdaje",{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Leden]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Leden]],SkutecnostMarketing[#Headers],0))","v":{"v":55,"d":"55.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Únor]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Únor]],SkutecnostMarketing[#Headers],0))","v":{"v":44,"d":"44.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Březen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Březen]],SkutecnostMarketing[#Headers],0))","v":{"v":77,"d":"77.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Duben]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Duben]],SkutecnostMarketing[#Headers],0))","v":{"v":-23,"d":"-23.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Květen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Květen]],SkutecnostMarketing[#Headers],0))","v":{"v":13,"d":"13.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červen]],SkutecnostMarketing[#Headers],0))","v":{"v":-45,"d":"-45.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Červenec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Červenec]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Srpen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Srpen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Září]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Září]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Říjen]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Říjen]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Listopad]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Listopad]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"INDEX(PlanMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],PlanMarketing[#Headers],0))-INDEX(SkutecnostMarketing[],MATCH(INDEX(RozdilyMarketing[],ROW()-ROW(RozdilyMarketing[[#Headers],[Prosinec]]),1),INDEX(PlanMarketing[],,1),0),MATCH(RozdilyMarketing[[#Headers],[Prosinec]],SkutecnostMarketing[#Headers],0))","v":{"v":200,"d":"200.00 Kč"}},{"$f":"SUM(RozdilyMarketing[[#This Row],[Leden]:[Prosinec]])","v":{"v":1321,"d":"1,321.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,RozdilyMarketing[Leden])","v":{"v":555,"d":"555.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Únor])","v":{"v":-456,"d":"-456.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Březen])","v":{"v":-23,"d":"-23.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Duben])","v":{"v":-123,"d":"-123.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Květen])","v":{"v":113,"d":"113.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Červen])","v":{"v":-825,"d":"-825.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Červenec])","v":{"v":8100,"d":"8,100.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Srpen])","v":{"v":6100,"d":"6,100.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Září])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Říjen])","v":{"v":8100,"d":"8,100.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Listopad])","v":{"v":3100,"d":"3,100.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[Prosinec])","v":{"v":6900,"d":"6,900.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilyMarketing[ROK])","v":{"v":34641,"d":"34,641.00 Kč"}}]
[]
["V tabulce RozdilySkoleniACestovani, která začíná v buňce napravo, se automaticky počítají rozdíly ve náklady na školení a cestování. Další pokyn je v buňce A35.","Školení a cestování","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","ROK"]
[null,"Externí školení",{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Leden]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Leden]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Leden]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Leden]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":400,"d":"400.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Únor]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Únor]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Únor]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Únor]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":-400,"d":"-400.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Březen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Březen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Březen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Březen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Duben]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Duben]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Duben]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Duben]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":400,"d":"400.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Květen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Květen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Květen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Květen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":800,"d":"800.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":-800,"d":"-800.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červenec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červenec]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červenec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červenec]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Srpen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Srpen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Srpen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Srpen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Září]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Září]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Září]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Září]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Říjen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Říjen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Říjen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Říjen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Listopad]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Listopad]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Listopad]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Listopad]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Prosinec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Prosinec]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Prosinec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Prosinec]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"SUM(RozdilySkoleniACestovani[[#This Row],[Leden]:[Prosinec]])","v":{"v":13000,"d":"13,000.00 Kč"}}]
[null,"Náklady na cestování na školení",{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Leden]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Leden]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Leden]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Leden]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":800,"d":"800.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Únor]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Únor]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Únor]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Únor]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":-200,"d":"-200.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Březen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Březen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Březen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Březen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":600,"d":"600.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Duben]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Duben]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Duben]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Duben]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":800,"d":"800.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Květen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Květen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Květen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Květen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":1200,"d":"1,200.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":-1500,"d":"-1,500.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červenec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červenec]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Červenec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Červenec]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Srpen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Srpen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Srpen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Srpen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Září]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Září]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Září]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Září]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Říjen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Říjen]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Říjen]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Říjen]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Listopad]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Listopad]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Listopad]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Listopad]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"INDEX(PlanSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Prosinec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Prosinec]],PlanSkoleniACestovani[#Headers],0))-INDEX(SkutecnostSkoleniACestovani[],MATCH(INDEX(RozdilySkoleniACestovani[],ROW()-ROW(RozdilySkoleniACestovani[[#Headers],[Prosinec]]),1),INDEX(PlanSkoleniACestovani[],,1),0),MATCH(RozdilySkoleniACestovani[[#Headers],[Prosinec]],SkutecnostSkoleniACestovani[#Headers],0))","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"SUM(RozdilySkoleniACestovani[[#This Row],[Leden]:[Prosinec]])","v":{"v":13700,"d":"13,700.00 Kč"}}]
[null,"Mezisoučet",{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Leden])","v":{"v":1200,"d":"1,200.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Únor])","v":{"v":-600,"d":"-600.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Březen])","v":{"v":1200,"d":"1,200.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Duben])","v":{"v":1200,"d":"1,200.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Květen])","v":{"v":2000,"d":"2,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Červen])","v":{"v":-2300,"d":"-2,300.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Červenec])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Srpen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Září])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Říjen])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Listopad])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[Prosinec])","v":{"v":4000,"d":"4,000.00 Kč"}},{"$f":"SUBTOTAL(109,RozdilySkoleniACestovani[ROK])","v":{"v":26700,"d":"26,700.00 Kč"}}]
[]
["V tabulce RozdilyCelkem, která začíná v buňce napravo, se automaticky počítají celkové rozdíly výdajů.","SOUČTY","Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec","Rok"]
[null,"Měsíční skutečné výdaje",{"$f":"RozdilySkoleniACestovani[[#Totals],[Leden]]+RozdilyMarketing[[#Totals],[Leden]]+RozdilyKancelar[[#Totals],[Leden]]+RozdilyZamestnanci[[#Totals],[Leden]]","v":{"v":1738,"d":"1,738.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Únor]]+RozdilyMarketing[[#Totals],[Únor]]+RozdilyKancelar[[#Totals],[Únor]]+RozdilyZamestnanci[[#Totals],[Únor]]","v":{"v":-984,"d":"-984.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Březen]]+RozdilyMarketing[[#Totals],[Březen]]+RozdilyKancelar[[#Totals],[Březen]]+RozdilyZamestnanci[[#Totals],[Březen]]","v":{"v":1255,"d":"1,255.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Duben]]+RozdilyMarketing[[#Totals],[Duben]]+RozdilyKancelar[[#Totals],[Duben]]+RozdilyZamestnanci[[#Totals],[Duben]]","v":{"v":301,"d":"301.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Květen]]+RozdilyMarketing[[#Totals],[Květen]]+RozdilyKancelar[[#Totals],[Květen]]+RozdilyZamestnanci[[#Totals],[Květen]]","v":{"v":1440,"d":"1,440.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Červen]]+RozdilyMarketing[[#Totals],[Červen]]+RozdilyKancelar[[#Totals],[Červen]]+RozdilyZamestnanci[[#Totals],[Červen]]","v":{"v":-3744,"d":"-3,744.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Červenec]]+RozdilyMarketing[[#Totals],[Červenec]]+RozdilyKancelar[[#Totals],[Červenec]]+RozdilyZamestnanci[[#Totals],[Červenec]]","v":{"v":134695,"d":"134,695.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Srpen]]+RozdilyMarketing[[#Totals],[Srpen]]+RozdilyKancelar[[#Totals],[Srpen]]+RozdilyZamestnanci[[#Totals],[Srpen]]","v":{"v":138918,"d":"138,918.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Září]]+RozdilyMarketing[[#Totals],[Září]]+RozdilyKancelar[[#Totals],[Září]]+RozdilyZamestnanci[[#Totals],[Září]]","v":{"v":135918,"d":"135,918.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Říjen]]+RozdilyMarketing[[#Totals],[Říjen]]+RozdilyKancelar[[#Totals],[Říjen]]+RozdilyZamestnanci[[#Totals],[Říjen]]","v":{"v":140918,"d":"140,918.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Listopad]]+RozdilyMarketing[[#Totals],[Listopad]]+RozdilyKancelar[[#Totals],[Listopad]]+RozdilyZamestnanci[[#Totals],[Listopad]]","v":{"v":136218,"d":"136,218.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[Prosinec]]+RozdilyMarketing[[#Totals],[Prosinec]]+RozdilyKancelar[[#Totals],[Prosinec]]+RozdilyZamestnanci[[#Totals],[Prosinec]]","v":{"v":140018,"d":"140,018.00 Kč"}},{"$f":"RozdilySkoleniACestovani[[#Totals],[ROK]]+RozdilyMarketing[[#Totals],[ROK]]+RozdilyKancelar[[#Totals],[ROK]]+RozdilyZamestnanci[[#Totals],[ROK]]","v":{"v":826691,"d":"826,691.00 Kč"}}]
[null,"CELKOVÉ skutečné výdaje",{"$f":"SUM($C$36:C36)","v":{"v":1738,"d":"1,738.00 Kč"}},{"$f":"SUM($C$36:D36)","v":{"v":754,"d":"754.00 Kč"}},{"$f":"SUM($C$36:E36)","v":{"v":2009,"d":"2,009.00 Kč"}},{"$f":"SUM($C$36:F36)","v":{"v":2310,"d":"2,310.00 Kč"}},{"$f":"SUM($C$36:G36)","v":{"v":3750,"d":"3,750.00 Kč"}},{"$f":"SUM($C$36:H36)","v":{"v":6,"d":"6.00 Kč"}},{"$f":"SUM($C$36:I36)","v":{"v":134701,"d":"134,701.00 Kč"}},{"$f":"SUM($C$36:J36)","v":{"v":273619,"d":"273,619.00 Kč"}},{"$f":"SUM($C$36:K36)","v":{"v":409537,"d":"409,537.00 Kč"}},{"$f":"SUM($C$36:L36)","v":{"v":550455,"d":"550,455.00 Kč"}},{"$f":"SUM($C$36:M36)","v":{"v":686673,"d":"686,673.00 Kč"}},{"$f":"SUM($C$36:N36)","v":{"v":826691,"d":"826,691.00 Kč"}}]

{"sheet":"ANALÝZA VÝDAJŮ","index":4,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[1,1,2,3],[1,5,1,6],[2,4,2,6],[11,1,11,2],[11,3,11,5],[13,1,36,5]]}
["Na tomto listu se pro jednotlivé kategorie výdajů automaticky aktualizují roční plánované a skutečné výdaje, rozdíly výdajů a procenta rozdílů. V buňkách v tomto sloupci jsou užitečné pokyny k tomu, jak tento list používat. Začněte stisknutím šipky dolů. ",{"$nulls":5}," ",{"$nulls":8}," "]
["V buňce vpravo se automaticky aktualizuje název společnosti. Do buňky F2 vložte logo.",{"$f":"'PLÁNOVANÉ VÝDAJE'!B2:D3","v":"Název společnosti"},{"$nulls":3},"V této buňce je zástupný symbol loga."]
["V buňce E3 je název tohoto listu. Další pokyn je v buňce A5.",{"$nulls":3},{"$f":"nazev_listu","v":"Podrobné odhady výdajů"}]
[]
["V tabulce Analyza, která začíná v buňce napravo, se automaticky počítají plánované výdaje, skutečné výdaje, rozdíly výdajů a procenta rozdílů. Další pokyn je v buňce A12.","Kategorie výdajů","Plánované výdaje","Skutečné výdaje","Rozdíly výdajů","Procenta rozdílů"]
[null,"Náklady na zaměstnance",{"$f":"PlanZamestnanci[[#Totals],[ROK]]","v":{"v":1355090,"d":"1,355,090.00 Kč"}},{"$f":"SkutecnostZamestnanci[[#Totals],[ROK]]","v":{"v":659130,"d":"659,130.00 Kč"}},{"$f":"C6-D6","v":{"v":695960,"d":"695,960.00 Kč"}},{"$f":"E6/C6","v":{"v":0.5135895032802249,"d":"51%"}}]
[null,{"$f":"'PLÁNOVANÉ VÝDAJE'!B10","v":"Náklady na kancelář"},{"$f":"PlanKancelar[[#Totals],[ROK]]","v":{"v":138740,"d":"138,740.00 Kč"}},{"$f":"SkutecnostKancelar[[#Totals],[ROK]]","v":{"v":69350,"d":"69,350.00 Kč"}},{"$f":"C7-D7","v":{"v":69390,"d":"69,390.00 Kč"}},{"$f":"E7/C7","v":{"v":0.5001441545336601,"d":"50%"}}]
[null,{"$f":"'PLÁNOVANÉ VÝDAJE'!B21","v":"Náklady na marketing"},{"$f":"PlanMarketing[[#Totals],[ROK]]","v":{"v":67800,"d":"67,800.00 Kč"}},{"$f":"SkutecnostMarketing[[#Totals],[ROK]]","v":{"v":33159,"d":"33,159.00 Kč"}},{"$f":"C8-D8","v":{"v":34641,"d":"34,641.00 Kč"}},{"$f":"E8/C8","v":{"v":0.510929203539823,"d":"51%"}}]
[null,{"$f":"'PLÁNOVANÉ VÝDAJE'!B30","v":"Školení a cestování"},{"$f":"PlanSkoleniACestovani[[#Totals],[ROK]]","v":{"v":48000,"d":"48,000.00 Kč"}},{"$f":"SkutecnostSkoleniACestovani[[#Totals],[ROK]]","v":{"v":21300,"d":"21,300.00 Kč"}},{"$f":"C9-D9","v":{"v":26700,"d":"26,700.00 Kč"}},{"$f":"E9/C9","v":{"v":0.55625,"d":"56%"}}]
[null,{"$f":"'PLÁNOVANÉ VÝDAJE'!B35","v":"SOUČTY"},{"$f":"'PLÁNOVANÉ VÝDAJE'!O36","v":{"v":1609630,"d":"1,609,630.00 Kč"}},{"$f":"'SKUTEČNÉ VÝDAJE'!O36","v":{"v":782939,"d":"782,939.00 Kč"}},{"$f":"C10-D10","v":{"v":826691,"d":"826,691.00 Kč"}},{"$f":"E10/C10","v":{"v":0.5135907009685455,"d":"51%"}}]
[]
["V buňce vpravo je výsečový graf plánované výdaje a v buňce D12 je výsečový graf skutečné výdaje. Další pokyn je v buňce A14.","V této buňce je výsečový graf zobrazující plánované výdaje na různé kategorie.",null,"V této buňce je výsečový graf zobrazující skutečné výdaje na různé kategorie."]
[]
["V buňce vpravo je graf znázorňující plán a skutečnost měsíční výdaje a jejich rozdíl."]