{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hárok1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Hárok1","index":0,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,4,9,4],[4,5,9,5],[4,11,9,11],[4,12,9,12],[10,4,13,4],[10,5,13,5],[10,11,13,11],[10,12,13,12]]}
[]
[]
[]
[null,null,"Kalendárny týždeň","úloha","Plánovaný čas\nza týždeň","Skutočný čas\nza týždeň","plán hodín strávených na úlohe","skutočný čas hodín strávených na úlohe",null,null,null,"produktivita plán","skutočná produktivita"]
[null,null,"KW37","názov úlohy",37.5,43.23,28,31,0.81600000000000006,{"$f":"IF(G5=\"\",\"\",G5*I5)","v":22.848000000000003},{"$f":"IF(G5=\"\",\"\",H5*I5)","v":25.296000000000003},{"$f":"SUM(J5:J10)/E5","v":0.7792105787420075},{"$f":"SUM(K5:K10)/F5","v":0.75107050145218102}]
[null,null,"KW37","názov úlohy",null,null,2.5,3.5,0.77622222222222226,1.9405555555555556,2.7167777777777777]
[null,null,"KW37","názov úlohy",null,null,1,0,0.77584114726971876,0.77584114726971876,0]
[null,null,"KW37","názov úlohy",null,null,0,0.5,0.8,0,0.4]
[null,null,"KW37","názov úlohy",null,null,1,1.5,0.8,0.8,1.2000000000000002]
[null,null,"KW37","názov úlohy",null,null,3.5,3.5,0.81600000000000006,2.8560000000000003,2.8560000000000003]
[null,null,"KW38","názov úlohy",37.5,38.25,26,26,0.81600000000000006,21.216000000000001,21.216000000000001,{"$f":"SUM(J11:J14)/E11","v":0.76270983800126657},{"$f":"SUM(K11:K14)/F11","v":0.73760804742317343}]
[null,null,"KW38","názov úlohy",null,null,8,7.5,0.77622222222222226,6.2097777777777781,5.8216666666666672]
[null,null,"KW38","názov úlohy",null,null,1,1,0.77584114726971876,0.77584114726971876,0.77584114726971876]
[null,null,"KW38","názov úlohy",null,null,0.5,0.5,0.8,0.4,0.4]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hodnoty v sivých riadkoch sa prepisujú makrom z úlohových kartičiek do tejto tabuľky, ktorá vyhodnocuje produktivitu a ich počet závisí od toho, koľko úloh mal v danom týždni zamestnanec"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tieto dve hodnoty chcem vypočítať vzorcom, ktorý zostane zlúčený v riadkoch k prislúchajúcemu KW\nKaždý týždeň môže ale pribudnúť rôzny počet riadkov\nAktuálne to musí robiť každý ručne"]