{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["finance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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":"finance","index":0,"n_rows":18,"n_cols":19,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["počet klientů",2,3,4,5,6,7,8,10,11,12,13,14,15,16,17,null,"kurz euro ke CZK",{"$f":"26*1.1","v":28.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kurz USD k CZK",{"$f":"22*1.1","v":24.200000000000003}]
["suma výdajů",{"$f":"SUM(B7:B12)","v":67800},{"$f":"SUM(C7:C12)","v":76270},90680,104870,119280,127750.00000000001,142160,180550,189020,203430,211900,232030,240500.00000000003,254910.00000000003,263380,null,"kurz TRZ k EURU",13]
["suma se ziskem",{"$f":"B3+B13","v":81360},{"$f":"C3+C13","v":91524},108816,125844,143136,153300.00000000003,170592,216660,226824,244116,254280,278436,288600.00000000006,305892.00000000006,316056]
["cena zájezdu",{"$f":"B4/B1","v":40680},{"$f":"C4/C1","v":30508},27204,25168.799999999999,23856,21900.000000000004,21324,21666,20620.363636363636,20343,19560,19888.285714285714,19240.000000000004,19118.250000000004,18591.529411764706,null,"cena auta 5 míst v EUR na den",30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cena auta 9 míst v EUR na den",50]
["letenky (CZK)",{"$f":"(B$1+1)*$S$12*$S$2","v":25410.000000000004},{"$f":"(C$1+1)*$S$12*$S$2","v":33880.000000000007},{"$f":"(D$1+1)*$S$12*$S$2","v":42350.000000000007},50820.000000000007,59290.000000000007,67760.000000000015,76230.000000000015,93170.000000000015,101640.00000000001,110110.00000000001,118580.00000000001,127050.00000000001,135520.00000000003,143990.00000000003,152460.00000000003]
["půjčení auta",{"$f":"IF(B$1<5,$S$5*$S$18*$S$1,IF(B$1<9,$S$6*$S$18*$S$1,IF(B$1<14,($S$5+$S$6)*$S$18*$S$1,2*$S$6*$S$18*$S$1)))","v":8580},{"$f":"IF(C$1<5,$S$5*$S$18*$S$1,IF(C$1<9,$S$6*$S$18*$S$1,IF(C$1<14,($S$5+$S$6)*$S$18*$S$1,2*$S$6*$S$18*$S$1)))","v":8580},{"$f":"IF(D$1<5,$S$5*$S$18*$S$1,IF(D$1<9,$S$6*$S$18*$S$1,IF(D$1<14,($S$5+$S$6)*$S$18*$S$1,2*$S$6*$S$18*$S$1)))","v":8580},14300,14300,14300,14300,22880,22880,22880,22880,28600,28600,28600,28600,null,"cena benzínu v TRZ za litr",15]
["benzín",{"$f":"$S$9*$S$10*$S$8*$S$1/(100*$S$3)","v":6930},{"$f":"$S$9*$S$10*$S$8*$S$1/(100*$S$3)","v":6930},6930,6930,6930,6930,6930,{"$f":"2*$S$9*$S$10*$S$8*$S$1/(100*$S$3)","v":13860},{"$f":"2*$S$9*$S$10*$S$8*$S$1/(100*$S$3)","v":13860},13860,13860,13860,13860,13860,13860,null,"počet kilometrů",3000]
["ubytování",{"$f":"_xlfn.CEILING.PRECISE((B$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":11880},{"$f":"_xlfn.CEILING.PRECISE((C$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":11880},{"$f":"_xlfn.CEILING.PRECISE((D$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":17820},{"$f":"_xlfn.CEILING.PRECISE((E$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":17820},{"$f":"_xlfn.CEILING.PRECISE((F$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":23760},{"$f":"_xlfn.CEILING.PRECISE((G$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":23760},{"$f":"_xlfn.CEILING.PRECISE((H$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":29700},{"$f":"_xlfn.CEILING.PRECISE((I$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":35640},{"$f":"_xlfn.CEILING.PRECISE((J$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":35640},{"$f":"_xlfn.CEILING.PRECISE((K$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":41580},{"$f":"_xlfn.CEILING.PRECISE((L$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":41580},{"$f":"_xlfn.CEILING.PRECISE((M$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":47520},{"$f":"_xlfn.CEILING.PRECISE((N$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":47520},{"$f":"_xlfn.CEILING.PRECISE((O$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":53460},{"$f":"_xlfn.CEILING.PRECISE((P$1+1)/2)*($S$18-1)*$S$13*$S$1/$S$3","v":53460},null,"spotřeba v litrech na 100km",7]
[]
["plat průvodce",{"$f":"$S$15*$S$18","v":15000},{"$f":"$S$15*$S$18","v":15000},15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,15000,null,"cena letenky v USD na osobu",350]
["zisk CK",{"$f":"B3*($S$16/100)","v":13560},{"$f":"C3*($S$16/100)","v":15254},18136,20974,23856,25550.000000000004,28432,36110,37804,40686,42380,46406,48100.000000000007,50982.000000000007,52676,null,"cena ubytování v TRZ za dvoulůžák na noc",{"$f":"300","v":300}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"plat průvodce na den ",1500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zisk CK v % z nákladů",20]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"počet dní",10]