{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["main","sales","kontg","graf","prognoza","optimalizace","rozpocet","zamestnanci","spolecnost"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":65,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"main","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,46,25]]}

{"sheet":"sales","index":1,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[22,8,22,10],[6,8,6,9],[2,8,2,10],[8,8,8,10],[14,8,14,10],[18,8,18,10]]}
[null,null,null,null,null,"Základní údaje o prodejích a provizích"]
["Datum","Jméno","Místo prodeje","Počet zboží","Tržba","Provize\n(sazba)","Provize\n(v měně)"]
[{"$f":"TODAY()-50","v":"2013-04-17"},"Jan Novák","Jihlava",12,5523,{"$f":"VLOOKUP(E3,$I$4:$K$6,3)+IF(D3>=12,$K$7,0)","v":0.15000000000000002},828,null,"Provize z tržby"]
[{"$f":"TODAY()-50","v":"2013-04-17"},"Petr Průbojný","Ostrava",4,7625,{"$f":"VLOOKUP(E4,$I$4:$K$6,3)+IF(D4>=12,$K$7,0)","v":0.15},1144,null,0,4999,0]
[{"$f":"TODAY()-50","v":"2013-04-17"},"Daniel Neprodal","Chomutov",7,7735,0.15,1160,null,5000,7499,0.1]
[{"$f":"TODAY()-49","v":"2013-04-18"},"Jan Novák","Jihlava",14,7646,0.2,1529,null,7500,"a více",0.15]
[{"$f":"TODAY()-48","v":"2013-04-19"},"Nikola Moudrá","Brno",2,3229,0,0,null,12,null,0.05]
[{"$f":"TODAY()-48","v":"2013-04-19"},"Petr Průbojný","Jihlava",11,9203,0.15,1380]
[{"$f":"TODAY()-48","v":"2013-04-19"},"Daniel Neprodal","Ostrava",14,2497,0.05,125,null,"Převod měny"]
[{"$f":"TODAY()-47","v":"2013-04-20"},"Jan Novák","Chomutov",8,4417,0,0,null,"kurz USD (k 1.6.2013)",null,19.739999999999998]
[{"$f":"TODAY()-45","v":"2013-04-22"},"Daniel Neprodal","Jihlava",9,7017,0.1,702,null,"kurz EUR (k 1.6.2013)",null,25.75]
[{"$f":"TODAY()-45","v":"2013-04-22"},"Nikola Moudrá","Chomutov",10,8844,0.15,1327]
[{"$f":"TODAY()-45","v":"2013-04-22"},"Petr Průbojný","Jihlava",5,7249,0.1,725]
[{"$f":"TODAY()-43","v":"2013-04-24"},"Jan Novák","Brno",13,3578,0.05,179]
[{"$f":"TODAY()-42","v":"2013-04-25"},"Daniel Neprodal","Jihlava",12,9499,0.2,1900,null,"Vygenerovat nové tržby"]
[{"$f":"TODAY()-41","v":"2013-04-26"},"Daniel Neprodal","Chomutov",4,1909,0,0]
[{"$f":"TODAY()-40","v":"2013-04-27"},"Radka Zasněná","Brno",14,4326,0.05,216]
[{"$f":"TODAY()-39","v":"2013-04-28"},"Jan Novák","Ostrava",15,6713,0.15000000000000002,1007]
[{"$f":"TODAY()-39","v":"2013-04-28"},"Petr Průbojný","Jihlava",11,2525,0,0,null,"Vytvořit kontingenční tabulku"]
[{"$f":"TODAY()-37","v":"2013-04-30"},"Jan Novák","Chomutov",13,2074,0.05,104]
[{"$f":"TODAY()-37","v":"2013-04-30"},"Nikola Moudrá","Brno",12,2851,0.05,143]
[{"$f":"TODAY()-36","v":"2013-05-01"},"Nikola Moudrá","Liberec",15,9382,0.2,1876]
[{"$f":"TODAY()-35","v":"2013-05-02"},"Jan Novák","Jihlava",4,6231,0.1,623,null,"Vytvořit graf"]
[{"$f":"TODAY()-33","v":"2013-05-04"},"Petr Průbojný","Ostrava",15,3733,0.05,187]
[{"$f":"TODAY()-32","v":"2013-05-05"},"Radka Zasněná","Liberec",9,5479,0.1,548]
[{"$f":"TODAY()-31","v":"2013-05-06"},"Daniel Neprodal","Liberec",6,2267,0,0]
[{"$f":"TODAY()-30","v":"2013-05-07"},"Jan Novák","Brno",3,5424,0.1,542]
[{"$f":"TODAY()-30","v":"2013-05-07"},"Petr Průbojný","Ostrava",5,8308,0.15,1246]
[{"$f":"TODAY()-30","v":"2013-05-07"},"Daniel Neprodal","Jihlava",13,5676,0.15000000000000002,851]
[{"$f":"TODAY()-29","v":"2013-05-08"},"Radka Zasněná","Chomutov",4,3766,0,0]
[{"$f":"TODAY()-28","v":"2013-05-09"},"Petr Průbojný","Brno",3,4302,0,0]
[{"$f":"TODAY()-27","v":"2013-05-10"},"Daniel Neprodal","Chomutov",8,4216,0,0]
[{"$f":"TODAY()-27","v":"2013-05-10"},"Jan Novák","Jihlava",2,7380,0.1,738]
[{"$f":"TODAY()-26","v":"2013-05-11"},"Petr Průbojný","Ostrava",15,9634,0.2,1927]
[{"$f":"TODAY()-25","v":"2013-05-12"},"Daniel Neprodal","Liberec",13,8446,0.2,1689]
[{"$f":"TODAY()-25","v":"2013-05-12"},"Nikola Moudrá","Brno",6,7691,0.15,1154]
[{"$f":"TODAY()-24","v":"2013-05-13"},"Jan Novák","Jihlava",9,8030,0.15,1205]
[{"$f":"TODAY()-24","v":"2013-05-13"},"Petr Průbojný","Ostrava",10,3367,0,0]
[{"$f":"TODAY()-24","v":"2013-05-13"},"Jan Novák","Jihlava",3,1103,0,0]
[{"$f":"TODAY()-23","v":"2013-05-14"},"Petr Průbojný","Ostrava",14,8673,0.2,1735]
[{"$f":"TODAY()-23","v":"2013-05-14"},"Daniel Neprodal","Chomutov",1,2752,0,0]
[{"$f":"TODAY()-21","v":"2013-05-16"},"Jan Novák","Chomutov",5,9481,0.15,1422]
[{"$f":"TODAY()-20","v":"2013-05-17"},"Nikola Moudrá","Brno",7,6814,0.1,681]
[{"$f":"TODAY()-19","v":"2013-05-18"},"Daniel Neprodal","Ostrava",4,5572,0.1,557]
[{"$f":"TODAY()-19","v":"2013-05-18"},"Nikola Moudrá","Jihlava",14,2122,0.05,106]
[{"$f":"TODAY()-18","v":"2013-05-19"},"Radka Zasněná","Chomutov",7,3632,0,0]
[{"$f":"TODAY()-17","v":"2013-05-20"},"Daniel Neprodal","Brno",9,9276,0.15,1391]
[{"$f":"TODAY()-15","v":"2013-05-22"},"Nikola Moudrá","Brno",2,1398,0,0]
[{"$f":"TODAY()-15","v":"2013-05-22"},"Jan Novák","Jihlava",13,7957,0.2,1591]
[{"$f":"TODAY()-14","v":"2013-05-23"},"Petr Průbojný","Ostrava",4,4945,0,0]
[{"$f":"TODAY()-12","v":"2013-05-25"},"Nikola Moudrá","Brno",13,6424,0.15000000000000002,964]
[{"$f":"TODAY()-12","v":"2013-05-25"},"Petr Průbojný","Ostrava",6,9310,0.15,1397]
[{"$f":"TODAY()-11","v":"2013-05-26"},"Daniel Neprodal","Chomutov",2,4093,0,0]
[{"$f":"TODAY()-10","v":"2013-05-27"},"Jan Novák","Jihlava",1,8220,0.15,1233]
[{"$f":"TODAY()-9","v":"2013-05-28"},"Petr Průbojný","Chomutov",12,2156,0.05,108]
[{"$f":"TODAY()-9","v":"2013-05-28"},"Nikola Moudrá","Brno",10,5965,0.1,597]
[{"$f":"TODAY()-9","v":"2013-05-28"},"Petr Průbojný","Ostrava",14,3106,0.05,155]
[{"$f":"TODAY()-8","v":"2013-05-29"},"Petr Průbojný","Jihlava",1,8070,0.15,1211]
[{"$f":"TODAY()-8","v":"2013-05-29"},"Daniel Neprodal","Chomutov",3,2070,0,0]
[{"$f":"TODAY()-7","v":"2013-05-30"},"Nikola Moudrá","Brno",5,2439,0,0]
[{"$f":"TODAY()-7","v":"2013-05-30"},"Daniel Neprodal","Chomutov",12,9022,0.2,1804]
[{"$f":"TODAY()-6","v":"2013-05-31"},"Radka Zasněná","Liberec",11,4407,0,0]
[{"$f":"TODAY()-5","v":"2013-06-01"},"Petr Průbojný","Ostrava",1,7292,0.1,729]
[{"$f":"TODAY()-5","v":"2013-06-01"},"Jan Novák","Jihlava",4,4542,0,0]
[{"$f":"TODAY()-5","v":"2013-06-01"},"Nikola Moudrá","Chomutov",15,5963,0.15000000000000002,894]
[{"$f":"TODAY()-4","v":"2013-06-02"},"Petr Průbojný","Brno",10,6065,0.1,607]
[{"$f":"TODAY()-3","v":"2013-06-03"},"Daniel Neprodal","Ostrava",8,3008,0,0]
[{"$f":"TODAY()-2","v":"2013-06-04"},"Jan Novák","Jihlava",3,3365,{"$f":"VLOOKUP(E68,$I$4:$K$6,3)+IF(D68>=12,$K$7,0)","v":0},0]
[{"$f":"TODAY()-2","v":"2013-06-04"},"Petr Průbojný","Chomutov",7,6292,0.1,629]
[{"$f":"TODAY()-1","v":"2013-06-05"},"Nikola Moudrá","Brno",7,8264,0.15,1240]
[{"$f":"TODAY()-1","v":"2013-06-05"},"Petr Průbojný","Ostrava",15,7323,0.15000000000000002,1098]
[{"$f":"TODAY()-1","v":"2013-06-05"},"Petr Průbojný","Ostrava",4,9705,0.15,1456]

{"sheet":"kontg","index":2,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Výsledky jednotlivých prodejců"]
[]
[null,"Součet z Tržba","Popisky sloupců"]
[null,"Popisky řádků","Radka Zasněná","Petr Průbojný","Nikola Moudrá","Jan Novák","Daniel Neprodal","Celkový součet"]
[null,"Brno",4326,10367,45075,9002,9276,78046]
[null,14,4326,null,null,null,null,4326]
[null,13,null,null,6424,3578,null,10002]
[null,12,null,null,2851,null,null,2851]
[null,10,null,6065,5965,null,null,12030]
[null,9,null,null,null,null,9276,9276]
[null,7,null,null,15078,null,null,15078]
[null,6,null,null,7691,null,null,7691]
[null,5,null,null,2439,null,null,2439]
[null,3,null,4302,null,5424,null,9726]
[null,2,null,null,4627,null,null,4627]
[null,"Chomutov",7398,8448,14807,15972,31797,78422]
[null,15,null,null,5963,null,null,5963]
[null,13,null,null,null,2074,null,2074]
[null,12,null,2156,null,null,9022,11178]
[null,10,null,null,8844,null,null,8844]
[null,8,null,null,null,4417,4216,8633]
[null,7,3632,6292,null,null,7735,17659]
[null,5,null,null,null,9481,null,9481]
[null,4,3766,null,null,null,1909,5675]
[null,3,null,null,null,null,2070,2070]
[null,2,null,null,null,null,4093,4093]
[null,1,null,null,null,null,2752,2752]
[null,"Jihlava",null,27047,2122,59997,22192,111358]
[null,14,null,null,2122,7646,null,9768]
[null,13,null,null,null,7957,5676,13633]
[null,12,null,null,null,5523,9499,15022]
[null,11,null,11728,null,null,null,11728]
[null,9,null,null,null,8030,7017,15047]
[null,5,null,7249,null,null,null,7249]
[null,4,null,null,null,10773,null,10773]
[null,3,null,null,null,4468,null,4468]
[null,2,null,null,null,7380,null,7380]
[null,1,null,8070,null,8220,null,16290]
[null,"Liberec",9886,null,9382,null,10713,29981]
[null,15,null,null,9382,null,null,9382]
[null,13,null,null,null,null,8446,8446]
[null,11,4407,null,null,null,null,4407]
[null,9,5479,null,null,null,null,5479]
[null,6,null,null,null,null,2267,2267]
[null,"Ostrava",null,83021,null,6713,11077,100811]
[null,15,null,20690,null,6713,null,27403]
[null,14,null,11779,null,null,2497,14276]
[null,10,null,3367,null,null,null,3367]
[null,8,null,null,null,null,3008,3008]
[null,6,null,9310,null,null,null,9310]
[null,5,null,8308,null,null,null,8308]
[null,4,null,22275,null,null,5572,27847]
[null,1,null,7292,null,null,null,7292]
[null,"Celkový součet",21610,128883,71386,91684,85055,398618]

{"sheet":"graf","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"prognoza","index":4,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,4,1,9],[39,1,39,12],[40,7,40,12],[40,2,40,6],[28,1,28,2],[28,3,28,4],[17,5,17,6],[28,5,28,6],[3,1,3,13],[17,1,17,2],[17,3,17,4],[16,12,16,13],[23,12,23,13],[27,1,27,6],[16,1,16,6],[17,8,17,9],[18,8,18,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[16,8,16,10]]}
[null,null,null,null,"Vývoj prodejů a budoucích investic"]
[]
[]
[null,"Předpoklad prodeje"]
[null,"Měsíc",1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Oslovených lidí",620,482,320,382,640,682,480,420,645,421,420,654]
[null,"Počet prodejů",45,39,28,32,46,54,38,33,55,38,48,61]
[null,"Úspěšnost",{"$f":"C7/C6","v":7.2580645161290328E-2},{"$f":"D7/D6","v":8.0912863070539423E-2},8.7499999999999994E-2,8.3769633507853408E-2,7.1874999999999994E-2,7.9178885630498533E-2,7.9166666666666663E-2,7.857142857142857E-2,8.5271317829457363E-2,9.0261282660332537E-2,0.11428571428571428,9.3272171253822631E-2]
[]
[]
[null,"Počet oslovených lidí",null,250,500,750,1000]
[null,"Počet uskutečněných prodejů",null,{"$f":"FLOOR(FORECAST(D11,$C$7:$N$7,$C$6:$N$6),1)","v":24},{"$f":"FLOOR(FORECAST(E11,$C$7:$N$7,$C$6:$N$6),1)","v":42},59,76]
[null,"Úspěšnost oslovení",null,{"$f":"D12/D11","v":9.6000000000000002E-2},{"$f":"E12/E11","v":8.4000000000000005E-2},7.8666666666666663E-2,7.5999999999999998E-2]
[]
[]
[]
[null,"Rozhodování o půjčce",null,null,null,null,null,null,"Váš součásný produkt",null,null,null,"Chci toto změnit"]
[null,"Var. A - nižší úrok",null,"Var. B - vyšší úrok",null,"Var. C - omez. platba",null,null,"Půjčka",null,200000,{"$f":"I21","v":"Měsíční platba"}]
[null,"Celková půjčka",1200000,"Celková půjčka",1200000,"Celková půjčka",1200000,null,"Úrok u banky",null,0.06,{"$f":"I20","v":"Počet měsíčních splátek"}]
[null,"Úrok v bance",6.8000000000000005E-2,"Úrok v bance",8.2000000000000003E-2,"Úrok v bance",8.2000000000000003E-2,null,"Počet měsíčních splátek",null,60,{"$f":"I23","v":"Budoucí hodnota (spořící)"},null,null,1]
[null,"Počet splátek",60,"Počet splátek",48,"Platba omezená",28000,null,"Měsíční platba",null,1500,{"$f":"I18","v":"Půjčka"}]
[null,"Platba měsíčně",{"$f":"PMT(C20/12,C21,C19)","v":-23648.369065072395},"Platba měsíčně",{"$f":"PMT(E20/12,E21,E19)","v":-29408.293942850312},"Splátek celkem",{"$f":"NPER(G20/12,-G21,G19)","v":50.883684994328839},null,"Úrok spoření (spořící)",null,0.03]
[null,"Vrátíme bance",{"$f":"C22*C21","v":-1418902.1439043437},"Vrátíme bance",{"$f":"E22*E21","v":-1411598.1092568149},"Vrátíme bance",{"$f":"G22*G21","v":1424743.1798412076},null,"Budoucí hodnota (spořící)",null,2000000,null,"Zadejte novou hodnotu"]
[null,"Přeplatíme o ",{"$f":"-C19-C23","v":218902.14390434371},"Přeplatíme o ",{"$f":"-E19-E23","v":211598.10925681493},"Přeplatíme o ",{"$f":"G23-G19","v":224743.17984120757},null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,"Platba","Celkem",null,null,"Jaké bude toto po změně"]
[null,null,null,null,null,null,null,null,{"$f":"PMT(K19/12,K20,K18)","v":-3866.5603058855831},{"$f":"I27*K20","v":-231993.61835313498}]
[null,"Rozhodování o úschově volných finančních prostředků",null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Var. A - jednorázově",null,"Var. B - stálá ú.s.",null,"Var. C - proměnlivá ú.s.",null,null,"Budhodnota","Bez úročení"]
[null,"Jednorázově",300000,"Jednorázově",300000,"Měsíčně",1500,null,{"$f":"FV(K22/12,K20,-K21)","v":96970.068933162547},{"$f":"K21*K20","v":90000}]
[null,"Měsíčně",1500,"Měsíčně",1500,"Úrok fix",3.2000000000000001E-2]
[null,"Úrok spořící",0.03,"Úrok spořící",0.03,"Úrok poté",2.7E-2,null,"Počet.období","Celkem"]
[null,"Počet let",5,"Počet let",5,"Počet let",5,null,{"$f":"NPER(K19/12,-K21,K18)","v":220.27130726361713},{"$f":"I33*K21","v":330406.9608954257}]
[null,"Budhodnota",{"$f":"FV(C32/12,C33*12,,-C30)","v":348485.0344665813},"Budhodnota",{"$f":"FV(E32/12,E33*12,-E31)","v":96970.068933162547},"Budhodnota",{"$f":"FV(G32/12,2*12,-G30,-FV(G31/12,3*12,-G30))","v":96681.603910612233}]
[null,"Bez úročení",{"$f":"C30","v":300000},"Bez úročení",{"$f":"E31*E33*12","v":90000},"Bez úročení",{"$f":"G30*G33*12","v":90000},null,"Budhodnota","Bez úročení"]
[null,"Rozdíl",{"$f":"C34-C35","v":48485.034466581303},"Rozdíl",{"$f":"E34-E35","v":6970.0689331625472},"Rozdíl",{"$f":"G34-G35","v":6681.6039106122334},null,{"$f":"FV(K19/12,K20,-K21)","v":104655.04576479112},{"$f":"K27*K26","v":0}]
[]
[]
[]
[null,"Rozhodování o využítí úvěru k investici (nákup budovy - školící centrum)"]
[null,"Výše půjčky","Úrok u různých bank",null,null,null,null,"Úrok u ostatních finančních institucích"]
[null,{"$f":"-PMT(K19/12,K20,K18)","v":3866.5603058855831},2.9899999999999999E-2,3.2500000000000001E-2,3.39E-2,3.49E-2,3.6400000000000002E-2,4.0599999999999997E-2,4.19E-2,4.5900000000000003E-2,4.7800000000000002E-2,4.8500000000000001E-2,4.99E-2]
[null,1000000,17964.247167591515,18080.002310599364,18142.525119079441,18187.266992328881,18254.50900926171,18443.610951223804,18502.388509910212,18683.971190419608,18770.607939159301,18802.589195502296,18866.652546895992]
[null,1100000,19760.671884350664,19888.002541659302,19956.777630987384,20005.993691561769,20079.959910187881,20287.972046346182,20352.627360901235,20552.368309461566,20647.668733075236,20682.848115052526,20753.317801585592]
[null,1200000,21557.096601109813,21696.002772719239,21771.030142895328,21824.720390794657,21905.410811114052,22132.333141468564,22202.866211892255,22420.765428503528,22524.729526991163,22563.107034602755,22639.983056275196]
[null,1300000,23353.52131786897,23504.003003779173,23585.282654803272,23643.447090027545,23730.861712040227,23976.694236590945,24053.105062883278,24289.162547545489,24401.790320907094,24443.365954152985,24526.648310964792]
[null,1400000,25149.946034628119,25312.003234839111,25399.535166711219,25462.173789260432,25556.312612966394,25821.055331713327,25903.343913874298,26157.559666587447,26278.851114823028,26323.624873703215,26413.313565654393]
[null,1500000,26946.370751387272,27120.003465899052,27213.787678619159,27280.900488493324,27381.763513892569,27665.416426835705,27753.582764865318,28025.956785629409,28155.911908738955,28203.883793253444,28299.978820343989]
[null,1600000,28742.795468146422,28928.003696958986,29028.040190527106,29099.627187726204,29207.214414818736,29509.777521958087,29603.821615856341,29894.353904671367,30032.972702654886,30084.142712803674,30186.64407503359]
[null,1700000,30539.220184905575,30736.003928018923,30842.292702435047,30918.353886959096,31032.665315744907,31354.138617080469,31454.060466847361,31762.751023713328,31910.033496570817,31964.401632353904,32073.30932972319]
[null,1800000,32335.644901664728,32544.004159078857,32656.545214342994,32737.080586191983,32858.116216671078,33198.499712202844,33304.299317838384,33631.148142755294,33787.094290486748,33844.660551904133,33959.97458441279]
[null,1900000,34132.069618423877,34352.004390138798,34470.797726250938,34555.807285424875,34683.567117597253,35042.860807325225,35154.538168829407,35499.545261797255,35664.155084402679,35724.919471454363,35846.639839102383]
[null,2000000,35928.49433518303,36160.004621198728,36285.050238158881,36374.533984657763,36509.01801852342,36887.221902447607,37004.777019820423,37367.942380839217,37541.215878318602,37605.178391004592,37733.305093791983]

{"sheet":"optimalizace","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,6],[3,7,4,7],[3,9,4,9]]}
[null,null,null,null,null,null,"Optimalizace plánu výroby reklamních předmětů u dceřinné společnosti"]
[]
[]
[null,null,"Předmět",null,null,null,null,"Maximální množství",null,"Podmínky výroby"]
[null,null,"Tričko s krátkým rukávem","Polokošile s potiskem","Dárkové ručníky","Taška\ns logem firmy","Reklamní stan"]
[null,"Bavlna",1.254,1.125,0.78500000000000003,5.8000000000000003E-2,1.2E-2,1500,null,{"$f":"SUMPRODUCT(C6:G6,$C$11:$G$11)","v":325.45299999999997}]
[null,"Polyester",0.125,0.438,2.8000000000000001E-2,0.65200000000000002,5.8710000000000004,2500,null,{"$f":"SUMPRODUCT(C7:G7,$C$11:$G$11)","v":1703.5350000000003}]
[null,"Niť",0.28699999999999998,0.58699999999999997,0.158,0.57099999999999995,1.587,15000,null,591.47199999999998]
[null,"Elastan",0.158,0.58899999999999997,0,0,0,300,null,99.942999999999998]
[null,"Potisk",0.156,0.27500000000000002,5.1999999999999998E-2,0.20100000000000001,0.65800000000000003,500,null,246.35700000000003]
[null,"Počet předmětů",10,167,150,70,269,"ks",null,"Náklady celkem"]
[null,"Výrobní cena",12,85,97,30,15,"Kč/kus",null,{"$f":"SUMPRODUCT(C11:G11,C12:G12)","v":35000}]

{"sheet":"rozpocet","index":6,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[17,1,17,7],[2,1,2,13],[18,3,18,4]]}
[null,null,null,null,null,null,null,"Rozpočet a pohledávky"]
[]
[null,"Roční rozpočet firmy za rok 2012"]
[null,null,"Leden","Únor","Březen","Duben","Květen","Červen","Červenec","Srpen","Září","Říjen","Listopad","Prosinec"]
[null,"- Provozní výnosy",595195,592514,592568,572552,564779,522627,584628,596245,542890,532874,580685,603895]
[null,"- Finanční výnosy",1873,1747,1223,1483,1675,1851,1089,1905,1050,1010,1236,1504]
[null,"Výnosy celkem",{"$f":"SUM(C5:C6)","v":597068},{"$f":"SUM(D5:D6)","v":594261},593791,574035,566454,524478,585717,598150,543940,533884,581921,605399]
[null,"- Pronájem budov",35900,39500,31200,29500,32100,39200,26300,41707,33682,45674,37686,34294]
[null,"- Investice do budov",0,0,0,30000,30000,30000,50000,50000,50000,50000,50000,50000]
[null,"- Externí školení",26000,24000,28000,26000,22000,21000,27000,31000,23000,26000,25000,26000]
[null,"- Mzdové náklady",516698,478706,486859,504709,502564,485365,504383,458340,448951,425863,456832,544807]
[null,"- Ostatná náklady",678,1555,1300,240,520,1306,734,1857,575,179,2782,163]
[null,"Náklady celkem",{"$f":"SUM(C8:C12)","v":579276},{"$f":"SUM(D8:D12)","v":543761},547359,590449,587184,576871,608417,582904,556208,547716,572300,655264]
[null,"Výsledek hosp.",{"$f":"C7-C13","v":17792},{"$f":"D7-D13","v":50500},46432,-16414,-20730,-52393,-22700,15246,-12268,-13832,9621,-49865]
[]
[]
[]
[null,"Pohledávky včetně faktur nezaplacených"]
[null,"Den vystavení","Číslo faktury","Společnost",null,"Doba \nsplatnosti","Splatné dne","Částka"]
[null,{"$f":"TODAY()-39","v":"2013-04-28"},131,"Jakub s.r.o.",null,60,{"$f":"B20+F20","v":"2013-06-27"},22244,null,"Dnes je",{"$f":"TODAY()","v":"2013-06-06"},"Den: ",{"$f":"IF(WEEKDAY(K20,2)=1,\"pondělí\",IF(WEEKDAY(K20,2)=2,\"úterý\",IF(WEEKDAY(K20,2)=3,\"středa\",IF(WEEKDAY(K20,2)=4,\"čtvrtek\",IF(WEEKDAY(K20,2)=5,\"pátek\",IF(WEEKDAY(K20,2)=6,\"sobota\",IF(WEEKDAY(K20,2)=7,\"neděle\",\"neznámý den\")))))))","v":"čtvrtek"}]
[null,"2013-04-28",144,"David s.r.o.",null,30,"2013-05-28",29823,null,"Počet nezaplacených faktur",null,null,{"$f":"COUNTIF($G$20:$G$35,\"<\"&$K$20)","v":7}]
[null,"2013-04-28",119,"Marek a.s.",null,30,"2013-05-28",28801,null,"Počet faktur s dnešní končící splatností",null,null,{"$f":"COUNTIF($G$20:$G$35,\"=\"&$K$20)","v":1}]
[null,"2013-04-28",105,"Filip s.r.o.",null,60,"2013-06-27",21460,null,"Počet zbylých faktur",null,null,{"$f":"COUNTIF($G$20:$G$35,\">\"&$K$20)","v":8}]
[null,"2013-04-28",116,"David s.r.o.",null,60,"2013-06-27",16178,null,"Celková nezaplacená částka",null,null,{"$f":"SUM($H$20:$H$35)","v":339118}]
[null,"2013-04-28",140,"Tomáš s.r.o.",null,30,"2013-05-28",15100,null,"z toho faktury před splatností",null,null,{"$f":"SUMIF($G$20:$G$35,\">\"&$K$20,$H$20:$H$35)","v":174085}]
[null,"2013-04-28",125,"Honza s.r.o.",null,30,"2013-05-28",22763,null,"z toho faktury s dnešní splatností",null,null,{"$f":"SUMIF($G$20:$G$35,\"=\"&$K$20,$H$20:$H$35)","v":15636}]
[null,"2013-04-28",133,"Vladimír s.r.o.",null,30,"2013-05-28",22664,null,"z toho faktury po splatnosti",null,null,{"$f":"SUMIF($G$20:$G$35,\"<\"&$K$20,$H$20:$H$35)","v":149397}]
[null,"2013-04-28",109,"David s.r.o.",null,30,"2013-05-28",11384]
[null,{"$f":"TODAY()-35","v":"2013-05-02"},105,"Filip s.r.o.",null,30,"2013-06-01",18862]
[null,{"$f":"TODAY()-30","v":"2013-05-07"},125,"Filip s.r.o.",null,30,"2013-06-06",15636]
[null,{"$f":"TODAY()-28","v":"2013-05-09"},100,"Honza s.r.o.",null,90,"2013-08-07",11904]
[null,{"$f":"TODAY()-25","v":"2013-05-12"},123,"Tomáš s.r.o.",null,30,"2013-06-11",25685]
[null,{"$f":"TODAY()-25","v":"2013-05-12"},125,"Honza s.r.o.",null,90,"2013-08-10",25267]
[null,{"$f":"TODAY()-24","v":"2013-05-13"},121,"Marek a.s.",null,60,"2013-07-12",26902]
[null,{"$f":"TODAY()-21","v":"2013-05-16"},106,"Jakub s.r.o.",null,60,"2013-07-15",24445]

{"sheet":"zamestnanci","index":7,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,1,11,6],[23,8,24,9],[2,1,2,2]]}
[null,null,null,null,null,null,"Evidenční listy - zaměstnanci"]
[]
[null,"Zaměstnanci společnosti",null,null,"Jméno","Příjmení","Datum\n narození","Věk","Bydliště"]
[null,"Daniel Neprodal","2011-01-01",null,{"$f":"LEFT(B4,FIND(\" \",B4)-1)","v":"Daniel"},{"$f":"RIGHT(B4,LEN(B4)-FIND(\" \",B4))","v":"Neprodal"},"1984-08-12",{"$f":"IF(MONTH($G4)>=MONTH(TODAY()),IF(DAY($G4)>DAY(TODAY()),YEAR(TODAY())-YEAR($G4)-1,YEAR(TODAY())-YEAR($G4)),YEAR(TODAY())-YEAR($G4))","v":28},"České Budejovice"]
[null,"Jan Novák","2012-07-01",null,{"$f":"LEFT(B5,FIND(\" \",B5)-1)","v":"Jan"},{"$f":"RIGHT(B5,LEN(B5)-FIND(\" \",B5))","v":"Novák"},"1987-08-12",{"$f":"IF(MONTH($G5)>=MONTH(TODAY()),IF(DAY($G5)>DAY(TODAY()),YEAR(TODAY())-YEAR($G5)-1,YEAR(TODAY())-YEAR($G5)),YEAR(TODAY())-YEAR($G5))","v":25},"Protivín"]
[null,"Nikola Moudrá","2010-06-01",null,"Nikola","Moudrá","1989-06-04",24,"Olomouc"]
[null,"Petr Průbojný","2005-02-01",null,"Petr","Průbojný","1989-06-05",24,"Brno"]
[null,"Radka Zasněná","2007-08-01",null,"Radka","Zasněná","1991-08-29",21,"Praha"]
[]
[]
[]
[null,"Docházka za měsíc květen"]
[null,"Datum","Den","Kancelář","Příchod","Odchod","Odpracoval"]
[null,"2013-05-01",{"$f":"IF(WEEKDAY(B14,2)=1,\"pondělí\",IF(WEEKDAY(B14,2)=2,\"úterý\",IF(WEEKDAY(B14,2)=3,\"středa\",IF(WEEKDAY(B14,2)=4,\"čtvrtek\",IF(WEEKDAY(B14,2)=5,\"pátek\",IF(WEEKDAY(B14,2)=6,\"sobota\",IF(WEEKDAY(B14,2)=7,\"neděle\",\"neznámý den\")))))))","v":"středa"},"Neprodal","08:10:00","16:00:00",{"$f":"IF(F14<E14,F14-E14+\"24:00\",F14-E14)","v":"07:50:00"}]
[null,"2013-05-02",{"$f":"IF(WEEKDAY(B15,2)=1,\"pondělí\",IF(WEEKDAY(B15,2)=2,\"úterý\",IF(WEEKDAY(B15,2)=3,\"středa\",IF(WEEKDAY(B15,2)=4,\"čtvrtek\",IF(WEEKDAY(B15,2)=5,\"pátek\",IF(WEEKDAY(B15,2)=6,\"sobota\",IF(WEEKDAY(B15,2)=7,\"neděle\",\"neznámý den\")))))))","v":"čtvrtek"},"Novák","08:37:00","01:00:00",{"$f":"IF(F15<E15,F15-E15+\"24:00\",F15-E15)","v":"16:23:00"}]
[null,"2013-05-03","pátek","Moudrá","09:28:00","17:30:00",{"$f":"IF(F16<E16,F16-E16+\"24:00\",F16-E16)","v":"08:02:00"}]
[null,"2013-05-04","sobota","Průbojný","10:53:00","15:30:00","04:37:00"]
[null,"2013-05-05","neděle"]
[null,"2013-05-06","pondělí","Neprodal","08:45:00","14:30:00","05:45:00"]
[null,"2013-05-07","úterý","Novák","09:54:00","02:00:00","16:06:00"]
[null,"2013-05-08","středa","Moudrá","07:23:00","14:20:00","06:57:00"]
[null,"2013-05-09","čtvrtek","Průbojný","08:20:00","15:30:00","07:10:00"]
[null,"2013-05-10","pátek","Neprodal","07:10:00","16:00:00","08:50:00"]
[null,"2013-05-11","sobota","Novák","08:15:00","14:00:00","05:45:00",null,"Vyhledávání směny"]
[null,"2013-05-12","neděle"]
[null,"2013-05-13","pondělí","Novák","07:25:00","15:30:00","08:05:00",null,"Zadejte datum:","2013-07-07"]
[null,"2013-05-14","úterý","Moudrá","08:54:00","16:00:00","07:06:00",null,"Bude to:",{"$f":"VLOOKUP($J$26,$I$31:$K$44,2,FALSE)","v":"neděle"}]
[null,"2013-05-15","středa","Průbojný","07:25:00","14:20:00","06:55:00",null,"Směnu má:",{"$f":"IF($J$27=\"neděle\",\"Nikdo - nepracuje se\",VLOOKUP($J$26,$I$31:$K$44,3,FALSE))","v":"Nikdo - nepracuje se"}]
[null,"2013-05-16","čtvrtek","Neprodal","06:13:00","15:30:00","09:17:00"]
[null,"2013-05-17","pátek","Novák","08:25:00","16:00:00","07:35:00",null,"Datum","Den","Kancelář"]
[null,"2013-05-18","sobota","Moudrá","08:48:00","15:30:00","06:42:00",null,"2013-07-01",{"$f":"IF(WEEKDAY(I31,2)=1,\"pondělí\",IF(WEEKDAY(I31,2)=2,\"úterý\",IF(WEEKDAY(I31,2)=3,\"středa\",IF(WEEKDAY(I31,2)=4,\"čtvrtek\",IF(WEEKDAY(I31,2)=5,\"pátek\",IF(WEEKDAY(I31,2)=6,\"sobota\",IF(WEEKDAY(I31,2)=7,\"neděle\",\"neznámý den\")))))))","v":"pondělí"},"Neprodal"]
[null,"2013-05-19","neděle",null,null,null,null,null,"2013-07-02",{"$f":"IF(WEEKDAY(I32,2)=1,\"pondělí\",IF(WEEKDAY(I32,2)=2,\"úterý\",IF(WEEKDAY(I32,2)=3,\"středa\",IF(WEEKDAY(I32,2)=4,\"čtvrtek\",IF(WEEKDAY(I32,2)=5,\"pátek\",IF(WEEKDAY(I32,2)=6,\"sobota\",IF(WEEKDAY(I32,2)=7,\"neděle\",\"neznámý den\")))))))","v":"úterý"},"Novák"]
[null,"2013-05-20","pondělí","Zasněná","08:35:00","15:30:00","06:55:00",null,"2013-07-03","středa","Moudrá"]
[null,"2013-05-21","úterý","Neprodal","07:35:00","16:00:00","08:25:00",null,"2013-07-04","čtvrtek","Průbojný"]
[null,"2013-05-22","středa","Průbojný","07:58:00","15:00:00","07:02:00",null,"2013-07-05","pátek","Zasněná"]
[null,"2013-05-23","čtvrtek","Zasněná","08:24:00","15:00:00","06:36:00",null,"2013-07-06","sobota","Neprodal"]
[null,"2013-05-24","pátek","Neprodal","08:54:00","14:20:00","05:26:00",null,"2013-07-07","neděle"]
[null,"2013-05-25","sobota","Moudrá","07:46:00","15:30:00","07:44:00",null,"2013-07-08","pondělí","Moudrá"]
[null,"2013-05-26","neděle",null,null,null,null,null,"2013-07-09","úterý","Průbojný"]
[null,"2013-05-27","pondělí","Zasněná","08:14:00","14:00:00","05:46:00",null,"2013-07-10","středa","Neprodal"]
[null,"2013-05-28","úterý","Neprodal","08:35:00","14:20:00","05:45:00",null,"2013-07-11","čtvrtek","Novák"]
[null,"2013-05-29","středa","Novák","08:14:00","15:30:00","07:16:00",null,"2013-07-12","pátek","Neprodal"]
[null,"2013-05-30","čtvrtek","Průbojný","08:56:00","16:00:00","07:04:00",null,"2013-07-13","sobota","Novák"]
[null,"2013-05-31","pátek","Zasněná","07:23:00","15:00:00","07:37:00",null,"2013-07-14","neděle"]
[null,null,null,null,null,"Celkem",{"$f":"SUM(G14:G44)","v":8.6951388888888896}]

{"sheet":"spolecnost","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}