{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["HSQ_Kalkulačka","List2"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"HSQ_Kalkulačka","index":0,"n_rows":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,1,1,2],[12,3,12,4]]}
[]
[null,"Kalkulačka návratnosti investice - \"Na hřistě s Husqvarnou\""]
[]
[null,"Týdenní čas na sekání (až 168 hodin)",140]
[null,"Roční počet sekacích cyklů",85]
[null,"Rozloha v m2",7140]
[null,"Denní kapacita AM v m2",{"$f":"((C4/168)*10000)*C13","v":25000}]
[null,"Plánovaný počet let",6]
[null,"Cena za 1 kWh",5]
[null,"Cena za 1 l paliva",{"$f":"IF(D10=\"Benzín\",List2!B9,List2!B10)","v":34.05},"Benzín"]
[null,"Roční náklady na hnojiva",10000]
[]
[null,null,3,"Porovnávaný produkt"]
[null,null,"Akční balíček Automower 550 EPOS","Seznam produktů - vyberte","Vlastní vstupní data"]
[null,"Pořizovací cena",{"$f":"List2!B2*C13","v":743796.6},{"$f":"IF(D14=\"Seco Starjet P4\",List2!B13,IF(HSQ_Kalkulačka!D14=\"Seco Starjet P6 PRO\",List2!B14,IF(D14=\"Seco Starjet P5\",List2!B15,0)))","v":0}]
[null,"Instalace a zprovoznění",15000,0]
[null,"Volitelné příslušenství",0,0]
[null,"Roční spotřeba žacích nožů - Automower",{"$f":"(List2!F2-(8016/C8))*C13","v":6405},0,0]
[null,"Roční spotřeba elektrické energie / paliva",{"$f":"((C6/10000)*List2!C2*HSQ_Kalkulačka!C9)*C13","v":3598.56},{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,C6*C5/VLOOKUP(D14,List2!A12:D15,4,0)*VLOOKUP(D14,List2!A12:C15,3,0)*C10)","v":0}]
[null,"Roční servísní náklady",{"$f":"10000*C13","v":30000},{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,VLOOKUP(D14,List2!A12:E15,5,0))","v":0}]
[null,"Roční náklady na lidské zdroje",{"$f":"(30*353)*C13","v":31770},{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,(52.5*353)+(C6*C5/VLOOKUP(D14,List2!A12:D15,4,0)*353))","v":0}]
[null,"Roční přidané náklady na hnojiva",0,{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,C11*0.75)","v":0}]
[null,"Roční extra náklady (např. likvidace trávy)",0,{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,17650)","v":0}]
[null,"Počáteční pořizovací náklady",{"$f":"C15+C16+C17","v":758796.6},{"$f":"D15+D16+D17","v":0},{"$f":"E15+E16+E17","v":0}]
[null,"Průměrná cena za 1 rok provozu",{"$f":"C26/C8","v":198239.66},{"$f":"D26/C8","v":0},{"$f":"IF(E15>0,E26/C8,0)","v":0}]
[null,"Celková cena za celou dobu provozu",{"$f":"C24+((C18+C19+C20+C21)*C8)","v":1189437.96},{"$f":"IF(D14=\"Seznam produktů - vyberte\",0,D24+((D19+D20+D21+D22+D23)*$C$8))","v":0},{"$f":"IF(E15>0,E24+((E19+E20+E21+E22+E23)*$C$8),0)","v":0}]
[null,"Roční průměrná cena za údržbu 1 m2",{"$f":"C25/C6","v":27.7646582633053},{"$f":"D25/C6","v":0},{"$f":"E25/C6","v":0}]
[]
[]
[null,"Výrobek",{"$f":"C14","v":"Akční balíček Automower 550 EPOS"},{"$f":"IF(D14=\"Seznam produktů - vyberte\",\"\",D14)","v":""},{"$f":"IF(E15>0,\"Vlastní vstupní data\",\"\")","v":""}]
[null,"Pořizovací náklady",{"$f":"C15+C16+C17","v":758796.6},{"$f":"IF(D14=\"Seznam produktů - vyberte\",\"0\",D15+D16+D17)","v":"0"},{"$f":"E15+E16+E17","v":0}]
[null,"1. rok",{"$f":"C31+C18+C19+C20+C21","v":830570.16},{"$f":"D31+D19+D20+D21+D22+D23","v":0},{"$f":"E31+E19+E20+E21+E22+E23","v":0}]
[null,"2. rok",{"$f":"IF(C8>2,C32+C18+C19+C20+C21,0)","v":902343.72},{"$f":"IF(C8>1,D32+D19+D20+D21+D22+D23,0)","v":0},{"$f":"IF(C8>1,E32+E19+E20+E21+E22+E23,0)","v":0}]
[null,"3. rok",{"$f":"IF(C8>2,C33+C18+C19+C20+C21,0)","v":974117.28},{"$f":"IF(C8>2,D33+D19+D20+D21+D22+D23,0)","v":0},{"$f":"IF(C8>2,E33+E19+E20+E21+E22+E23,0)","v":0}]
[null,"4. rok",{"$f":"IF(C8>3,C34+C18+C19+C20+C21,0)","v":1045890.84},{"$f":"IF(C8>3,D34+D23+D19+D20+D21+D22,0)","v":0},{"$f":"IF(C8>3,E34+E19+E20+E21+E22+E23,0)","v":0}]
[null,"5. rok",{"$f":"IF(C8>4,C35+C18+C19+C20+C21,0)","v":1117664.4},{"$f":"IF(C8>4,D35+D23+D19+D20+D21+D22,0)","v":0},{"$f":"IF(C8>4,E35+E19+E20+E21+E22+E23,0)","v":0}]
[null,"6. rok",{"$f":"IF(C8>5,C36+C18+C19+C20+C21,0)","v":1189437.96},{"$f":"IF(C8>5,D36+D23+D19+D20+D21+D22,0)","v":0},{"$f":"IF(C8>5,E36+E19+E20+E21+E22+E23,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Typ výrobku",{"$f":"C14","v":"Akční balíček Automower 550 EPOS"},{"$f":"IF(D14=\"Seznam produktů - vyberte\",\"\",D14)","v":""},{"$f":"IF(E15>0,\"Vlastní vstupní data\",\"\")","v":""}]
[null,"Roční spotřeba žacích nožů - Automower",{"$f":"C18","v":6405},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D18)","v":0},{"$f":"IF($E$15>0,E18,0)","v":0}]
[null,"Roční spotřeba elektrické energie / paliva",{"$f":"C19","v":3598.56},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D19)","v":0},{"$f":"IF($E$15>0,E19,0)","v":0}]
[null,"Roční servísní náklady",{"$f":"C20","v":30000},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D20)","v":0},{"$f":"IF($E$15>0,E20,0)","v":0}]
[null,"Roční náklady na lidské zdroje",{"$f":"C21","v":31770},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D21)","v":0},{"$f":"IF($E$15>0,E21,0)","v":0}]
[null,"Roční přidané náklady na hnojiva",{"$f":"C22","v":0},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D22)","v":0},{"$f":"IF($E$15>0,E22,0)","v":0}]
[null,"Roční extra náklady (např. likvidace trávy)",{"$f":"C23","v":0},{"$f":"IF($D$14=\"Seznam produktů - vyberte\",0,D23)","v":0},{"$f":"IF($E$15>0,E23,0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Všechny uvedené ceny jsou bez DPH."]

{"sheet":"List2","index":1,"n_rows":190,"n_cols":7,"rows_kept":190,"cut":false,"hidden":true,"merged":[]}
["Výrobek","dpc bez dph","elektřina / sezona","zimní servis","spotřeba nožů / sezona","spotřeba nožů / sezona Kč","čásová náročnost"]
["Akční balíček Automower 550 EPOS",247932.2,336,10000,130,{"$f":"E2*26.7","v":3471},30]
["Ceora 544",563543.8,770,12500,195,{"$f":"E3*26.7","v":5206.5},30]
["Ceora 546",712304.2,910,12500,195,{"$f":"E4*26.7","v":5206.5},30]
[]
[]
[]
[]
["Benzín",34.05]
["Nafta",36.45]
[]
["Seznam produktů - vyberte","dpc bez dph","palivo / motohodina","posekáno / 1 hod","servis","časová náročnost"]
["Seco Starjet P4",128016,6.05,2475,10000,52.5]
["Seco Starjet P6 PRO",210661,6.51,2812,10000,52.5]
["Seco Starjet P5",140413,6.05,2475,10000,52.5]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]