{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Sheet2","index":0,"n_rows":19,"n_cols":145,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,119,2,119],[1,141,2,141],[1,142,1,144],[1,120,1,122],[1,123,2,123],[1,130,2,130],[1,131,1,133],[1,134,2,134],[1,31,2,31],[1,101,2,101],[1,108,2,108],[1,109,1,111],[1,112,2,112],[1,32,1,34],[1,35,2,35],[1,86,2,86],[1,87,1,89],[1,90,2,90],[1,97,2,97],[1,98,1,100],[1,0,2,0],[1,20,2,20],[1,3,2,3],[1,2,2,2],[1,1,2,1],[1,5,2,5],[1,9,2,9],[1,4,2,4],[1,10,1,12],[1,8,2,8],[1,21,1,23],[1,6,2,6],[1,13,2,13],[1,24,2,24],[1,79,2,79],[1,53,2,53],[1,54,1,56],[1,57,2,57],[1,65,1,67],[1,76,1,78],[1,42,2,42],[1,43,1,45],[1,46,2,46],[1,68,2,68],[1,75,2,75],[1,64,2,64]]}
["PÄDEVUSTABEL"]
["Perekonnanimi","Nimi","Kood","Kulukoht","Ametikoht","Töö keerukuse tase","Plaanitud pädevus \n2017 aastal",null,"Hetkelolev palk \n2016 aastal","Tööoskused","Aasta keskmine väärtus",null,null,"Detsember","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Jaanuar","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Veebruar","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Märts","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Aprill","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Mai","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Juuni","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Juuli","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"August","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"September","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"Oktoober","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused",null,null,"November","0 - 4","0 - 4","0 - 4","0 - 4","0 - 2","0 - 3","Kommentaar","Arvutuslikud väärtused"]
[null,null,null,null,null,null,null,"Plaantitud palk \n2017 aastal",null,null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostöö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö",null,"Töö kvaliteet","Suhtumine töösse","Töö tulemuslikkus","Materjalide otstarbekas kasutamine","Hoolsus ja koostöö","Tööohutusnõuete täitmine ",null,"Kvaliteet","Tulemuslikkus","Hoolsus ja koostööö"]
[]
["xxxxx","xxxxx","xxxxx","JT80","Spetsialist",{"$f":"IFERROR(VLOOKUP(E5,Keerukuse_tasemed,2,0),\"--\")","v":"--"},{"$f":"IFERROR(IF(SUM(J5:M5)<5,0,IF(SUM(J5:M5)<9,1,IF(SUM(J5:M5)<12,2,IF(SUM(J5:M5)<15,3,IF(SUM(J5:M5)<19,4,IF(SUM(J5:M5)<22,5)))))),\"--\")","v":2},{"$f":"IFERROR(INDEX(#REF!,MATCH(F5,#REF!),G5+1),\"--\")","v":"--"},7.09,{"$f":"IFERROR(VLOOKUP(C5, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},{"$f":"IFERROR(AVERAGE(V5,AG5,AR5,BC5,BN5,BY5,CJ5,CU5,DF5,DQ5,EB5,EM5),\"--\")","v":4},{"$f":"IFERROR(AVERAGE(W5,AH5,AS5,BD5,BO5,BZ5,CK5,CV5,DG5,DR5,EC5,EN5),\"--\")","v":3.25},{"$f":"IFERROR(AVERAGE(X5,AI5,AT5,BE5,BP5,CA5,CL5,CW5,DH5,DS5,ED5,EO5),\"--\")","v":4.125},{"$f":"IF(O5=\"\",\"n/a\",IF(P5=\"\",\"n/a\",IF(Q5=\"\",\"n/a\",IF(R5=\"\",\"n/a\",IF(S5=\"\",\"n/a\",IF(T5=\"\",\"n/a\",SUM(O5:T5)))))))","v":18},4,3,4,3,2,2,null,{"$f":"IFERROR(IF(O5+P5<1,\" \",IF(O5+P5<2,0,IF(O5+P5<4,2,IF(O5+P5<7,3,IF(O5+P5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(Q5+R5<1,\" \",IF(Q5+R5<2,0,IF(Q5+R5<4,2,IF(Q5+R5<7,3,IF(Q5+R5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(S5+T5<1,\" \",IF(S5+T5<2,1,IF(S5+T5<3,2,IF(S5+T5<4,3,IF(S5+T5<5,4,IF(S5+T5<6,5)))))),\"-\")","v":4},{"$f":"IF(Z5=\"\",\"n/a\",IF(AA5=\"\",\"n/a\",IF(AB5=\"\",\"n/a\",IF(AC5=\"\",\"n/a\",IF(AD5=\"\",\"n/a\",IF(AE5=\"\",\"n/a\",SUM(Z5:AE5)))))))","v":18},4,3,4,3,2,2,null,{"$f":"IFERROR(IF(Z5+AA5<1,\" \",IF(Z5+AA5<2,0,IF(Z5+AA5<4,2,IF(Z5+AA5<7,3,IF(Z5+AA5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(AB5+AC5<1,\" \",IF(AB5+AC5<2,0,IF(AB5+AC5<4,2,IF(AB5+AC5<7,3,IF(AB5+AC5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(AD5+AE5<1,\" \",IF(AD5+AE5<2,1,IF(AD5+AE5<3,2,IF(AD5+AE5<4,3,IF(AD5+AE5<5,4,IF(AD5+AE5<6,5)))))),\"-\")","v":4},{"$f":"IF(AK5=\"\",\"n/a\",IF(AL5=\"\",\"n/a\",IF(AM5=\"\",\"n/a\",IF(AN5=\"\",\"n/a\",IF(AO5=\"\",\"n/a\",IF(AP5=\"\",\"n/a\",SUM(AK5:AP5)))))))","v":18},4,3,3,3,2,3,null,{"$f":"IFERROR(IF(AK5+AL5<1,\" \",IF(AK5+AL5<2,0,IF(AK5+AL5<4,2,IF(AK5+AL5<7,3,IF(AK5+AL5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(AM5+AN5<1,\" \",IF(AM5+AN5<2,0,IF(AM5+AN5<4,2,IF(AM5+AN5<7,3,IF(AM5+AN5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(AO5+AP5<1,\" \",IF(AO5+AP5<2,1,IF(AO5+AP5<3,2,IF(AO5+AP5<4,3,IF(AO5+AP5<5,4,IF(AO5+AP5<6,5)))))),\"-\")","v":5},{"$f":"IF(AV5=\"\",\"n/a\",IF(AW5=\"\",\"n/a\",IF(AX5=\"\",\"n/a\",IF(AY5=\"\",\"n/a\",IF(AZ5=\"\",\"n/a\",IF(AZ5=\"\",\"n/a\",IF(BA5=\"\",\"n/a\",SUM(AV5:BA5))))))))","v":18},4,4,3,3,2,2,null,{"$f":"IFERROR(IF(AV5+AW5<1,\" \",IF(AV5+AW5<2,0,IF(AV5+AW5<4,2,IF(AV5+AW5<7,3,IF(AV5+AW5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(AX5+AY5<1,\" \",IF(AX5+AY5<2,0,IF(AX5+AY5<4,2,IF(AX5+AY5<7,3,IF(AX5+AY5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(AZ5+BA5<1,\" \",IF(AZ5+BA5<2,1,IF(AZ5+BA5<3,2,IF(AZ5+BA5<4,3,IF(AZ5+BA5<5,4,IF(AZ5+BA5<6,5)))))),\"-\")","v":4},{"$f":"IF(BG5=\"\",\"n/a\",IF(BH5=\"\",\"n/a\",IF(BI5=\"\",\"n/a\",IF(BJ5=\"\",\"n/a\",IF(BK5=\"\",\"n/a\",IF(BL5=\"\",\"n/a\",SUM(BG5:BL5)))))))","v":18},4,4,3,3,2,2,null,{"$f":"IFERROR(IF(BG5+BH5<1,\" \",IF(BG5+BH5<2,0,IF(BG5+BH5<4,2,IF(BG5+BH5<7,3,IF(BG5+BH5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(BI5+BJ5<1,\" \",IF(BI5+BJ5<2,0,IF(BI5+BJ5<4,2,IF(BI5+BJ5<7,3,IF(BI5+BJ5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(BK5+BL5<1,\" \",IF(BK5+BL5<2,1,IF(BK5+BL5<3,2,IF(BK5+BL5<4,3,IF(BK5+BL5<5,4,IF(BK5+BL5<6,5)))))),\"-\")","v":4},{"$f":"IF(BR5=\"\",\"n/a\",IF(BS5=\"\",\"n/a\",IF(BT5=\"\",\"n/a\",IF(BU5=\"\",\"n/a\",IF(BV5=\"\",\"n/a\",IF(BW5=\"\",\"n/a\",SUM(BR5:BW5)))))))","v":18},4,4,3,3,2,2,null,{"$f":"IFERROR(IF(BR5+BS5<1,\" \",IF(BR5+BS5<2,0,IF(BR5+BS5<4,2,IF(BR5+BS5<7,3,IF(BR5+BS5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(BT5+BU5<1,\" \",IF(BT5+BU5<2,0,IF(BT5+BU5<4,2,IF(BT5+BU5<7,3,IF(BT5+BU5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(BV5+BW5<1,\" \",IF(BV5+BW5<2,1,IF(BV5+BW5<3,2,IF(BV5+BW5<4,3,IF(BV5+BW5<5,4,IF(BV5+BW5<6,5)))))),\"-\")","v":4},{"$f":"IF(CC5=\"\",\"n/a\",IF(CD5=\"\",\"n/a\",IF(CE5=\"\",\"n/a\",IF(CF5=\"\",\"n/a\",IF(CG5=\"\",\"n/a\",IF(CH5=\"\",\"n/a\",SUM(CC5:CH5)))))))","v":18},4,4,3,3,2,2,null,{"$f":"IFERROR(IF(CC5+CD5<1,\" \",IF(CC5+CD5<2,0,IF(CC5+CD5<4,2,IF(CC5+CD5<7,3,IF(CC5+CD5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(CE5+CF5<1,\" \",IF(CE5+CF5<2,0,IF(CE5+CF5<4,2,IF(CE5+CF5<7,3,IF(CE5+CF5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(CG5+CH5<1,\" \",IF(CG5+CH5<2,1,IF(CG5+CH5<3,2,IF(CG5+CH5<4,3,IF(CG5+CH5<5,4,IF(CG5+CH5<6,5)))))),\"-\")","v":4},{"$f":"IF(CN5=\"\",\"n/a\",IF(CO5=\"\",\"n/a\",IF(CP5=\"\",\"n/a\",IF(CQ5=\"\",\"n/a\",IF(CR5=\"\",\"n/a\",IF(CS5=\"\",\"n/a\",SUM(CN5:CS5)))))))","v":18},4,4,3,3,2,2,null,{"$f":"IFERROR(IF(CN5+CO5<1,\" \",IF(CN5+CO5<2,0,IF(CN5+CO5<4,2,IF(CN5+CO5<7,3,IF(CN5+CO5<9,4))))),\"-\")","v":4},{"$f":"IFERROR(IF(CP5+CQ5<1,\" \",IF(CP5+CQ5<2,0,IF(CP5+CQ5<4,2,IF(CP5+CQ5<7,3,IF(CP5+CQ5<9,4))))),\"-\")","v":3},{"$f":"IFERROR(IF(CR5+CS5<1,\" \",IF(CR5+CS5<2,1,IF(CR5+CS5<3,2,IF(CR5+CS5<4,3,IF(CR5+CS5<5,4,IF(CR5+CS5<6,5)))))),\"-\")","v":4},{"$f":"IF(CY5=\"\",\"n/a\",IF(CZ5=\"\",\"n/a\",IF(DA5=\"\",\"n/a\",IF(DB5=\"\",\"n/a\",IF(DC5=\"\",\"n/a\",IF(DD5=\"\",\"n/a\",SUM(CY5:DD5)))))))","v":"n/a"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(CY5+CZ5<1,\" \",IF(CY5+CZ5<2,0,IF(CY5+CZ5<4,2,IF(CY5+CZ5<7,3,IF(CY5+CZ5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DA5+DB5<1,\" \",IF(DA5+DB5<2,0,IF(DA5+DB5<4,2,IF(DA5+DB5<7,3,IF(DA5+DB5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DC5+DD5<1,\" \",IF(DC5+DD5<2,1,IF(DC5+DD5<3,2,IF(DC5+DD5<4,3,IF(DC5+DD5<5,4,IF(DC5+DD5<6,5)))))),\"-\")","v":" "},{"$f":"IF(DJ5=\"\",\"n/a\",IF(DK5=\"\",\"n/a\",IF(DL5=\"\",\"n/a\",IF(DM5=\"\",\"n/a\",IF(DN5=\"\",\"n/a\",IF(DO5=\"\",\"n/a\",SUM(DJ5:DO5)))))))","v":"n/a"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(DJ5+DK5<1,\" \",IF(DJ5+DK5<2,0,IF(DJ5+DK5<4,2,IF(DJ5+DK5<7,3,IF(DJ5+DK5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DL5+DM5<1,\" \",IF(DL5+DM5<2,0,IF(DL5+DM5<4,2,IF(DL5+DM5<7,3,IF(DL5+DM5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DN5+DO5<1,\" \",IF(DN5+DO5<2,1,IF(DN5+DO5<3,2,IF(DN5+DO5<4,3,IF(DN5+DO5<5,4,IF(DN5+DO5<6,5)))))),\"-\")","v":" "},{"$f":"IF(DU5=\"\",\"n/a\",IF(DV5=\"\",\"n/a\",IF(DW5=\"\",\"n/a\",IF(DX5=\"\",\"n/a\",IF(DY5=\"\",\"n/a\",IF(DZ5=\"\",\"n/a\",SUM(DU5:DZ5)))))))","v":"n/a"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(DU5+DV5<1,\" \",IF(DU5+DV5<2,0,IF(DU5+DV5<4,2,IF(DU5+DV5<7,3,IF(DU5+DV5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DW5+DX5<1,\" \",IF(DW5+DX5<2,0,IF(DW5+DX5<4,2,IF(DW5+DX5<7,3,IF(DW5+DX5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(DY5+DZ5<1,\" \",IF(DY5+DZ5<2,1,IF(DY5+DZ5<3,2,IF(DY5+DZ5<4,3,IF(DY5+DZ5<5,4,IF(DY5+DZ5<6,5)))))),\"-\")","v":" "},{"$f":"IF(EF5=\"\",\"n/a\",IF(EG5=\"\",\"n/a\",IF(EH5=\"\",\"n/a\",IF(EI5=\"\",\"n/a\",IF(EJ5=\"\",\"n/a\",IF(EK5=\"\",\"n/a\",SUM(EF5:EK5)))))))","v":"n/a"},null,null,null,null,null,null,null,{"$f":"IFERROR(IF(EF5+EG5<1,\" \",IF(EF5+EG5<2,0,IF(EF5+EG5<4,2,IF(EF5+EG5<7,3,IF(EF5+EG5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(EH5+EI5<1,\" \",IF(EH5+EI5<2,0,IF(EH5+EI5<4,2,IF(EH5+EI5<7,3,IF(EH5+EI5<9,4))))),\"-\")","v":" "},{"$f":"IFERROR(IF(EJ5+EK5<1,\" \",IF(EJ5+EK5<2,1,IF(EJ5+EK5<3,2,IF(EJ5+EK5<4,3,IF(EJ5+EK5<5,4,IF(EJ5+EK5<6,5)))))),\"-\")","v":" "}]
["xxxxx","xxxxx","xxxxx","JT81","WPG koostaja","--",{"$f":"IFERROR(IF(SUM(J6:M6)<5,0,IF(SUM(J6:M6)<9,1,IF(SUM(J6:M6)<12,2,IF(SUM(J6:M6)<15,3,IF(SUM(J6:M6)<19,4,IF(SUM(J6:M6)<22,5)))))),\"--\")","v":2},{"$f":"IFERROR(INDEX(#REF!,MATCH(F6,#REF!),G6+1),\"--\")","v":"--"},6.01,{"$f":"IFERROR(VLOOKUP(C6, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},{"$f":"IFERROR(AVERAGE(V6,AG6,AR6,BC6,BN6,BY6,CJ6,CU6,DF6,DQ6,EB6,EM6),\"--\")","v":3.2857142857142856},{"$f":"IFERROR(AVERAGE(W6,AH6,AS6,BD6,BO6,BZ6,CK6,CV6,DG6,DR6,EC6,EN6),\"--\")","v":3},{"$f":"IFERROR(AVERAGE(X6,AI6,AT6,BE6,BP6,CA6,CL6,CW6,DH6,DS6,ED6,EO6),\"--\")","v":4.1428571428571432},{"$f":"IF(O6=\"\",\"n/a\",IF(P6=\"\",\"n/a\",IF(Q6=\"\",\"n/a\",IF(R6=\"\",\"n/a\",IF(S6=\"\",\"n/a\",IF(T6=\"\",\"n/a\",SUM(O6:T6)))))))","v":0},"P","P","P","P","P","P",null,"-","-","-",{"$f":"IF(Z6=\"\",\"n/a\",IF(AA6=\"\",\"n/a\",IF(AB6=\"\",\"n/a\",IF(AC6=\"\",\"n/a\",IF(AD6=\"\",\"n/a\",IF(AE6=\"\",\"n/a\",SUM(Z6:AE6)))))))","v":17},4,3,3,3,2,2,null,4,3,4,{"$f":"IF(AK6=\"\",\"n/a\",IF(AL6=\"\",\"n/a\",IF(AM6=\"\",\"n/a\",IF(AN6=\"\",\"n/a\",IF(AO6=\"\",\"n/a\",IF(AP6=\"\",\"n/a\",SUM(AK6:AP6)))))))","v":18},4,3,3,3,2,3,null,4,3,5,{"$f":"IF(AV6=\"\",\"n/a\",IF(AW6=\"\",\"n/a\",IF(AX6=\"\",\"n/a\",IF(AY6=\"\",\"n/a\",IF(AZ6=\"\",\"n/a\",IF(AZ6=\"\",\"n/a\",IF(BA6=\"\",\"n/a\",SUM(AV6:BA6))))))))","v":16},3,3,3,3,2,2,null,3,3,4,{"$f":"IF(BG6=\"\",\"n/a\",IF(BH6=\"\",\"n/a\",IF(BI6=\"\",\"n/a\",IF(BJ6=\"\",\"n/a\",IF(BK6=\"\",\"n/a\",IF(BL6=\"\",\"n/a\",SUM(BG6:BL6)))))))","v":16},3,3,3,3,2,2,null,3,3,4,{"$f":"IF(BR6=\"\",\"n/a\",IF(BS6=\"\",\"n/a\",IF(BT6=\"\",\"n/a\",IF(BU6=\"\",\"n/a\",IF(BV6=\"\",\"n/a\",IF(BW6=\"\",\"n/a\",SUM(BR6:BW6)))))))","v":16},3,3,3,3,2,2,null,3,3,4,{"$f":"IF(CC6=\"\",\"n/a\",IF(CD6=\"\",\"n/a\",IF(CE6=\"\",\"n/a\",IF(CF6=\"\",\"n/a\",IF(CG6=\"\",\"n/a\",IF(CH6=\"\",\"n/a\",SUM(CC6:CH6)))))))","v":16},3,3,3,3,2,2,null,3,3,4,{"$f":"IF(CN6=\"\",\"n/a\",IF(CO6=\"\",\"n/a\",IF(CP6=\"\",\"n/a\",IF(CQ6=\"\",\"n/a\",IF(CR6=\"\",\"n/a\",IF(CS6=\"\",\"n/a\",SUM(CN6:CS6)))))))","v":16},3,3,3,3,2,2,null,3,3,4,{"$f":"IF(CY6=\"\",\"n/a\",IF(CZ6=\"\",\"n/a\",IF(DA6=\"\",\"n/a\",IF(DB6=\"\",\"n/a\",IF(DC6=\"\",\"n/a\",IF(DD6=\"\",\"n/a\",SUM(CY6:DD6)))))))","v":"n/a"},null,null,null,null,null,null,null," "," "," ",{"$f":"IF(DJ6=\"\",\"n/a\",IF(DK6=\"\",\"n/a\",IF(DL6=\"\",\"n/a\",IF(DM6=\"\",\"n/a\",IF(DN6=\"\",\"n/a\",IF(DO6=\"\",\"n/a\",SUM(DJ6:DO6)))))))","v":"n/a"},null,null,null,null,null,null,null," "," "," ",{"$f":"IF(DU6=\"\",\"n/a\",IF(DV6=\"\",\"n/a\",IF(DW6=\"\",\"n/a\",IF(DX6=\"\",\"n/a\",IF(DY6=\"\",\"n/a\",IF(DZ6=\"\",\"n/a\",SUM(DU6:DZ6)))))))","v":"n/a"},null,null,null,null,null,null,null," "," "," ",{"$f":"IF(EF6=\"\",\"n/a\",IF(EG6=\"\",\"n/a\",IF(EH6=\"\",\"n/a\",IF(EI6=\"\",\"n/a\",IF(EJ6=\"\",\"n/a\",IF(EK6=\"\",\"n/a\",SUM(EF6:EK6)))))))","v":"n/a"},null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT62","Spetsialist","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F7,#REF!),G7+1),\"--\")","v":"--"},7.09,{"$f":"IFERROR(VLOOKUP(C7, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3.7142857142857144,4,20,4,4,4,4,2,2,"JT62 kuuparim. Alati arvestab ettevõtte vajadustega. Tihti jagab mähkijatele näpunäiteid ja juhib tähelepanu toote spitsiifilistele asjaoludele.",4,4,4,18,4,4,3,3,1,3,null,4,3,4,19,4,4,4,3,2,2,null,4,4,4,18,4,4,3,3,2,2,null,4,3,4,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT44","Mähise isoleerija","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F8,#REF!),G8+1),\"--\")","v":"--"},6.36,{"$f":"IFERROR(VLOOKUP(C8, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3.8571428571428572,3.7142857142857144,17,4,3,3,3,2,2,null,4,3,4,18,4,4,3,4,2,1,null,4,4,3,0,"H","H","H","H","H","H",null,"-","-","-",19,4,4,3,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,4,3,4,2,1,null,4,4,3,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JTMAN","Poolautomaatpingioperaator","--",3,{"$f":"IFERROR(INDEX(#REF!,MATCH(F9,#REF!),G9+1),\"--\")","v":"--"},5.79,{"$f":"IFERROR(VLOOKUP(C9, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3.4285714285714284,5,19,4,3,4,3,2,3,null,4,4,5,18,4,3,3,3,2,3,null,4,3,5,19,4,4,3,3,2,3,null,4,3,5,19,4,4,3,3,2,3,null,4,3,5,19,4,3,4,3,2,3,null,4,4,5,19,4,3,4,3,2,3,null,4,4,5,18,4,3,3,3,2,3,null,4,3,5,0,"P","P","P","P","P","P",null,"-","-","-","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT81","Spetsialist","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F10,#REF!),G10+1),\"--\")","v":"--"},7.09,{"$f":"IFERROR(VLOOKUP(C10, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3.25,4.125,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,3,3,2,3,null,4,3,5,18,4,4,3,3,2,2,null,4,3,4,18,4,4,3,3,2,2,null,4,3,4,18,4,4,3,3,2,2,null,4,3,4,18,4,4,3,3,2,2,null,4,3,4,18,4,4,3,3,2,2,null,4,3,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT44","Mähise isoleerija","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F11,#REF!),G11+1),\"--\")","v":"--"},6.36,{"$f":"IFERROR(VLOOKUP(C11, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3.3333333333333335,3.6666666666666665,18,4,4,3,3,2,2,null,4,3,4,17,4,4,3,3,2,1,null,4,3,3,17,4,3,3,3,2,2,null,4,3,4,0,"P","P","P","P","P","P",null,"-","-","-",0,"P","P","P","P","P","P",null,"-","-","-",17,4,3,3,3,2,2,null,4,3,4,18,3,4,3,4,2,2,null,4,4,4,18,4,4,3,4,2,1,null,4,4,3,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT63","Spetsialist","--",3,{"$f":"IFERROR(INDEX(#REF!,MATCH(F12,#REF!),G12+1),\"--\")","v":"--"},7.55,{"$f":"IFERROR(VLOOKUP(C12, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,4,4.375,21,4,4,4,4,2,3,null,4,4,5,21,4,4,4,4,2,3,null,4,4,5,21,4,4,4,4,2,3,null,4,4,5,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,20,4,4,4,4,2,2,null,4,4,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT43","Mähise isoleerija","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F13,#REF!),G13+1),\"--\")","v":"--"},6.36,{"$f":"IFERROR(VLOOKUP(C13, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},3.5,3.5,4.333333333333333,17,3,3,4,3,2,2,null,3,4,4,17,3,3,3,3,2,3,null,3,3,5,17,3,3,3,3,2,3,null,3,3,5,0,"H","H","H","H","H","H",null,"-","-","-",18,4,4,3,3,2,2,null,4,3,4,0,"P","P","P","P","P","P",null,"-","-","-",18,3,4,4,3,2,2,null,4,4,4,18,3,4,4,3,2,2,null,4,4,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT43","Mähise isoleerija","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F14,#REF!),G14+1),\"--\")","v":"--"},6.36,{"$f":"IFERROR(VLOOKUP(C14, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},3.3333333333333335,3.3333333333333335,4.333333333333333,16,3,3,3,3,2,2,null,3,3,4,17,3,3,3,3,2,3,null,3,3,5,0,"H","H","H","H","H","H",null,"-","-","-",0,"H","H","H","H","H","H",null,"-","-","-",0,"H","H","H","H","H","H",null,"-","-","-",0,"H","H","H","H","H","H",null,"-","-","-",0,"H","H","H","H","H","H",null,"-","-","-",18,3,4,4,3,2,2,null,4,4,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT44","Spetsialist","--",3,{"$f":"IFERROR(INDEX(#REF!,MATCH(F15,#REF!),G15+1),\"--\")","v":"--"},7.09,{"$f":"IFERROR(VLOOKUP(C15, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,4,4.5999999999999996,0,"P","P","P","P","P","P",null,"-","-","-",20,4,4,4,4,2,2,null,4,4,4,21,4,4,4,4,2,3,null,4,4,5,0,"P","P","P","P","P","P",null,"-","-","-",21,4,4,4,4,2,3,null,4,4,5,18,4,3,4,3,2,2,null,4,4,4,0,"P","P","P","P","P","P",null,"-","-","-",21,4,4,4,4,2,3,null,4,4,5,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT69","Tasakaalustaja","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F16,#REF!),G16+1),\"--\")","v":"--"},6.81,{"$f":"IFERROR(VLOOKUP(C16, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},3.875,3.875,4,16,4,3,2,3,2,2,null,4,3,4,17,3,3,3,4,2,2,null,3,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,18,4,3,4,3,2,2,null,4,4,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JTSN","Automaatpresside operaator","--",3,{"$f":"IFERROR(INDEX(#REF!,MATCH(F17,#REF!),G17+1),\"--\")","v":"--"},7.14,{"$f":"IFERROR(VLOOKUP(C17, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},3.8571428571428572,3.5714285714285716,5,17,2,3,4,3,2,3,null,3,4,5,18,4,3,3,3,2,3,null,4,3,5,19,4,4,3,3,2,3,null,4,3,5,19,4,4,3,3,2,3,null,4,3,5,19,4,3,4,3,2,3,null,4,4,5,19,4,3,4,3,2,3,null,4,4,5,0,"h","h","h","h","h","h",null,"-","-","-",20,4,4,4,3,2,3,null,4,4,5,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JT62","Staatori mähkija","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F18,#REF!),G18+1),\"--\")","v":"--"},6.01,{"$f":"IFERROR(VLOOKUP(C18, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},2.6666666666666665,3,4,12,0,3,2,3,2,2,"2 punast",2,3,4,0,"H","H","H","H","H","H",null,"-","-","-",12,0,3,2,3,2,2,"1 PUNANE, 2 KOLLAST",2,3,4,14,2,2,3,3,1,3,"2 punast",3,3,4,14,3,2,2,3,2,2,null,3,3,4,15,2,3,3,3,2,2,"1 KOLLANE",3,3,4,15,2,3,3,3,2,2,"1 KOLLANE",3,3,4,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]
["xxxxx","xxxxx","xxxxx","JTVPI","Vaakumimmutaja","--",2,{"$f":"IFERROR(INDEX(#REF!,MATCH(F19,#REF!),G19+1),\"--\")","v":"--"},7.14,{"$f":"IFERROR(VLOOKUP(C19, Sheet1!$C$8:$F$22,4,0),\"--\")","v":0},4,3,4.4285714285714288,17,4,4,2,3,2,2,null,4,3,4,17,4,4,2,3,2,2,null,4,3,4,17,4,4,2,3,2,2,null,4,3,4,17,4,4,2,3,2,2,null,4,3,4,17,4,3,2,3,2,3,"Vaigutamise osakonna Aprillikuu parim tööline vastutulelik arvestab ettevõtte vajaduste ning huvidega  on töödanud väljaspoo ettenähtud tööaega, et vältida kliendihilinemisi.",4,3,5,17,4,3,2,3,2,3,null,4,3,5,17,4,3,2,3,2,3,null,4,3,5,"n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," ","n/a",null,null,null,null,null,null,null," "," "," "]

{"sheet":"Sheet1","index":1,"n_rows":22,"n_cols":39,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,22,5,22],[1,21,5,21],[1,28,5,28],[1,23,5,23],[1,38,5,38],[1,29,5,29],[1,16,5,16],[1,17,5,17],[1,1,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,3],[1,15,5,15],[1,6,5,6],[1,7,5,7],[1,4,1,5],[2,4,2,5],[3,4,3,5],[4,4,4,5]]}
["OSKUSTE TABEL"]
[1,"Abistamisoskused",null,null,"Vajalik inimeste ressurss",null,"JT43 - Mähisevalmistus","Punkte tööoskuste eest",3,3,3,15,6,9,15,"Hindamise kuupäev","JT67 - Ergutus rootorid","Punkte tööoskuste eest",1,3,3,"Hindamise kuupäev","JT44 - Mähisevalmistus","Punkte tööoskuste eest",3,3,11,8,"Hindamise kuupäev","Punkte tööoskuste eest",1,1,1,1,4,1,2,2,"Hindamise kuupäev"]
[2,"Rahuldavad oskused",null,null,"Vajalik varu",null,null,null,2,2,2,5,2,3,5,null,null,null,2,2,2,null,null,null,2,2,4,4,null,null,1,1,1,1,1,1,1,1]
[3,"Head oskused",null,null,"Inimesi oma osakonnas oskusega 3 ja 4",null,null,null,{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(I$8:I$22,ROW(I$8:I$22)-MIN(ROW(I$8:I$22)),,1)),IF($G$8:$G$22=\"o\",I$8:I$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(J$8:J$22,ROW(J$8:J$22)-MIN(ROW(J$8:J$22)),,1)),IF($G$8:$G$22=\"o\",J$8:J$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(K$8:K$22,ROW(K$8:K$22)-MIN(ROW(K$8:K$22)),,1)),IF($G$8:$G$22=\"o\",K$8:K$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(L$8:L$22,ROW(L$8:L$22)-MIN(ROW(L$8:L$22)),,1)),IF($G$8:$G$22=\"o\",L$8:L$22>=3))))","v":2},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(M$8:M$22,ROW(M$8:M$22)-MIN(ROW(M$8:M$22)),,1)),IF($G$8:$G$22=\"o\",M$8:M$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(N$8:N$22,ROW(N$8:N$22)-MIN(ROW(N$8:N$22)),,1)),IF($G$8:$G$22=\"o\",N$8:N$22>=3))))","v":2},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(O$8:O$22,ROW(O$8:O$22)-MIN(ROW(O$8:O$22)),,1)),IF($G$8:$G$22=\"o\",O$8:O$22>=3))))","v":2},null,null,null,{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(S$8:S$22,ROW(S$8:S$22)-MIN(ROW(S$8:S$22)),,1)),IF($Q$8:$Q$22=\"o\",S$8:S$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(T$8:T$22,ROW(T$8:T$22)-MIN(ROW(T$8:T$22)),,1)),IF($Q$8:$Q$22=\"o\",T$8:T$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(U$8:U$22,ROW(U$8:U$22)-MIN(ROW(U$8:U$22)),,1)),IF($Q$8:$Q$22=\"o\",U$8:U$22>=3))))","v":0},null,null,null,{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(Y$8:Y$22,ROW(Y$8:Y$22)-MIN(ROW(Y$8:Y$22)),,1)),IF($W$8:$W$22=\"o\",Y$8:Y$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(Z$8:Z$22,ROW(Z$8:Z$22)-MIN(ROW(Z$8:Z$22)),,1)),IF($W$8:$W$22=\"o\",Z$8:Z$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AA$8:AA$22,ROW(AA$8:AA$22)-MIN(ROW(AA$8:AA$22)),,1)),IF($W$8:$W$22=\"o\",AA$8:AA$22>=3))))","v":3},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AB$8:AB$22,ROW(AB$8:AB$22)-MIN(ROW(AB$8:AB$22)),,1)),IF($W$8:$W$22=\"o\",AB$8:AB$22>=3))))","v":3},null,null,{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AE$8:AE$22,ROW(AE$8:AE$22)-MIN(ROW(AE$8:AE$22)),,1)),IF(#REF!=\"o\",AE$8:AE$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AF$8:AF$22,ROW(AF$8:AF$22)-MIN(ROW(AF$8:AF$22)),,1)),IF(#REF!=\"o\",AF$8:AF$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AG$8:AG$22,ROW(AG$8:AG$22)-MIN(ROW(AG$8:AG$22)),,1)),IF(#REF!=\"o\",AG$8:AG$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AH$8:AH$22,ROW(AH$8:AH$22)-MIN(ROW(AH$8:AH$22)),,1)),IF(#REF!=\"o\",AH$8:AH$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AI$8:AI$22,ROW(AI$8:AI$22)-MIN(ROW(AI$8:AI$22)),,1)),IF(#REF!=\"o\",AI$8:AI$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AJ$8:AJ$22,ROW(AJ$8:AJ$22)-MIN(ROW(AJ$8:AJ$22)),,1)),IF(#REF!=\"o\",AJ$8:AJ$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AK$8:AK$22,ROW(AK$8:AK$22)-MIN(ROW(AK$8:AK$22)),,1)),IF(#REF!=\"o\",AK$8:AK$22>=3))))","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(AL$8:AL$22,ROW(AL$8:AL$22)-MIN(ROW(AL$8:AL$22)),,1)),IF(#REF!=\"o\",AL$8:AL$22>=3))))","v":0}]
[4,"Suurepärased oskused",null,null,"Kokku inimesi oskusega 3 ja 4",null,null,null,{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(I$8:I$22,ROW(I$8:I$22)-MIN(ROW(I$8:I$22)),,1)),IF($G$8:$G$22=\"x\",I$8:I$22>=3))))+I4","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(J$8:J$22,ROW(J$8:J$22)-MIN(ROW(J$8:J$22)),,1)),IF($G$8:$G$22=\"x\",J$8:J$22>=3))))+J4","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(K$8:K$22,ROW(K$8:K$22)-MIN(ROW(K$8:K$22)),,1)),IF($G$8:$G$22=\"x\",K$8:K$22>=3))))+K4","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(L$8:L$22,ROW(L$8:L$22)-MIN(ROW(L$8:L$22)),,1)),IF($G$8:$G$22=\"x\",L$8:L$22>=3))))+L4","v":2},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(M$8:M$22,ROW(M$8:M$22)-MIN(ROW(M$8:M$22)),,1)),IF($G$8:$G$22=\"x\",M$8:M$22>=3))))+M4","v":0},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(N$8:N$22,ROW(N$8:N$22)-MIN(ROW(N$8:N$22)),,1)),IF($G$8:$G$22=\"x\",N$8:N$22>=3))))+N4","v":2},{"$f":"SUM(N(IF(SUBTOTAL(3,OFFSET(O$8:O$22,ROW(O$8:O$22)-MIN(ROW(O$8:O$22)),,1)),IF($G$8:$G$22=\"x\",O$8:O$22>=3))))+O4","v":2},null,null,null,{"$f":"COUNTIF(S$8:S$22,\">=3\")","v":0},{"$f":"COUNTIF(T$8:T$22,\">=3\")","v":0},{"$f":"COUNTIF(U$8:U$22,\">=3\")","v":0},null,null,null,{"$f":"COUNTIF(Y$8:Y$22,\">=3\")","v":0},{"$f":"COUNTIF(Z$8:Z$22,\">=3\")","v":0},{"$f":"COUNTIF(AA$8:AA$22,\">=3\")","v":3},{"$f":"COUNTIF(AB$8:AB$22,\">=3\")","v":3},null,null,{"$f":"COUNTIF(AE$8:AE22,\">=3\")","v":0},{"$f":"COUNTIF(AF$8:AF22,\">=3\")","v":0},{"$f":"COUNTIF(AG$8:AG22,\">=3\")","v":0},{"$f":"COUNTIF(AH$8:AH22,\">=3\")","v":0},{"$f":"COUNTIF(AI$8:AI22,\">=3\")","v":0},{"$f":"COUNTIF(AJ$8:AJ22,\">=3\")","v":0},{"$f":"COUNTIF(AK$8:AK22,\">=3\")","v":0},{"$f":"COUNTIF(AL$8:AL22,\">=3\")","v":0}]
["Perekonnanimi","Nimi","Kood","Kulukoht","Ametikoht","S",null,null,"JT43 - Kerimispink","JT43 - Vormimispink","JT43 - Elektritest","JT43 - Käsi isoleerimine","JT43 - TH tools ","JT43 - Vana Micamation","JT43 - Uus Micamation",null,null,null,"JT67 - Ergutus rootori paketi valmistus","JT67 - Ergutus rootori mähiste valmistus","JT67 - Ergutus rootori mähkimine",null,null,null,"JT44 - Kerimispink","JT44 - Vormimispink","JT44 - Käsi isoleerimine","JT44 - Isoleerimismasin",null,null,"Materjali vastuvõtt","Kauba välja saatmine","Kulumaterjali ost","Materjali sisestamine SAP süsteemi","Riiuldamine ja komplekteerimine","Materjali väljastamine tootmisse (SAP) ","Tõstukijuhi töö","Pakkimine"]
[]
["xxxxx","xxxxx","xxxxx","JT80","Spetsialist",null,null,{"$f":"IF(D8=\"JT43\",IF(COUNTIF(I8:O8,3)+COUNTIF(I8:O8,4)<1,0,IF(COUNTIF(I8:O8,3)+COUNTIF(I8:O8,4)=1,2,IF(COUNTIF(I8:O8,3)+COUNTIF(I8:O8,4)>1,4,0))),IF(COUNTIF(I8:O8,2)+COUNTIF(I8:O8,3)+COUNTIF(I8:O8,4)>0,2,0))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(D8=\"JT67\",IF(COUNTIF(S8:U8,3)+COUNTIF(S8:U8,4)<1,0,IF(COUNTIF(S8:U8,3)+COUNTIF(S8:U8,4)=1,2,IF(COUNTIF(S8:U8,3)+COUNTIF(S8:U8,4)>1,4,0))),IF(COUNTIF(S8:U8,2)+COUNTIF(S8:U8,3)+COUNTIF(S8:U8,4)>0,2,0))","v":0},null,null,null,null,null,{"$f":"IF(D8=\"JT44\",IF(COUNTIF(Y8:AB8,3)+COUNTIF(Y8:AB8,4)<1,0,IF(COUNTIF(Y8:AB8,3)+COUNTIF(Y8:AB8,4)=1,2,IF(COUNTIF(Y8:AB8,3)+COUNTIF(Y8:AB8,4)>1,4,0))),IF(COUNTIF(Y8:AB8,2)+COUNTIF(Y8:AB8,3)+COUNTIF(Y8:AB8,4)>0,2,0))","v":0},null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)<1,0,IF(COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)=1,2,IF(COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)=2,4,IF(COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)=3,6,IF(COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)>3,8,0))))),IF(COUNTIF(AE8:AL8,2)+COUNTIF(AE8:AL8,3)+COUNTIF(AE8:AL8,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT81","WPG koostaja",null,null,{"$f":"IF(D9=\"JT43\",IF(COUNTIF(I9:O9,3)+COUNTIF(I9:O9,4)<1,0,IF(COUNTIF(I9:O9,3)+COUNTIF(I9:O9,4)=1,2,IF(COUNTIF(I9:O9,3)+COUNTIF(I9:O9,4)>1,4,0))),IF(COUNTIF(I9:O9,2)+COUNTIF(I9:O9,3)+COUNTIF(I9:O9,4)>0,2,0))","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(D9=\"JT44\",IF(COUNTIF(Y9:AB9,3)+COUNTIF(Y9:AB9,4)<1,0,IF(COUNTIF(Y9:AB9,3)+COUNTIF(Y9:AB9,4)=1,2,IF(COUNTIF(Y9:AB9,3)+COUNTIF(Y9:AB9,4)>1,4,0))),IF(COUNTIF(Y9:AB9,2)+COUNTIF(Y9:AB9,3)+COUNTIF(Y9:AB9,4)>0,2,0))","v":0},null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)<1,0,IF(COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)=1,2,IF(COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)=2,4,IF(COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)=3,6,IF(COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)>3,8,0))))),IF(COUNTIF(AE9:AL9,2)+COUNTIF(AE9:AL9,3)+COUNTIF(AE9:AL9,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT62","Spetsialist",null,null,0,null,null,null,null,null,null,null,"2014-02-13",null,0,null,null,null,null,null,0,null,null,null,null,"2014-02-13",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)<1,0,IF(COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)=1,2,IF(COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)=2,4,IF(COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)=3,6,IF(COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)>3,8,0))))),IF(COUNTIF(AE10:AL10,2)+COUNTIF(AE10:AL10,3)+COUNTIF(AE10:AL10,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT44","Mähise isoleerija",null,"x",2,null,null,null,2,null,null,null,"2016-04-01",null,0,null,null,null,null,"o",4,null,null,4,4,"2014-02-11",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)<1,0,IF(COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)=1,2,IF(COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)=2,4,IF(COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)=3,6,IF(COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)>3,8,0))))),IF(COUNTIF(AE11:AL11,2)+COUNTIF(AE11:AL11,3)+COUNTIF(AE11:AL11,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JTMAN","Poolautomaatpingioperaator",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)<1,0,IF(COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)=1,2,IF(COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)=2,4,IF(COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)=3,6,IF(COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)>3,8,0))))),IF(COUNTIF(AE12:AL12,2)+COUNTIF(AE12:AL12,3)+COUNTIF(AE12:AL12,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT81","Spetsialist",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)<1,0,IF(COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)=1,2,IF(COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)=2,4,IF(COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)=3,6,IF(COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)>3,8,0))))),IF(COUNTIF(AE13:AL13,2)+COUNTIF(AE13:AL13,3)+COUNTIF(AE13:AL13,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT44","Mähise isoleerija",null,"x",2,null,null,null,2,null,null,null,"2016-04-01",null,0,null,null,null,null,"o",4,null,null,4,4,"2014-02-11",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)<1,0,IF(COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)=1,2,IF(COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)=2,4,IF(COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)=3,6,IF(COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)>3,8,0))))),IF(COUNTIF(AE14:AL14,2)+COUNTIF(AE14:AL14,3)+COUNTIF(AE14:AL14,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT63","Spetsialist",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)<1,0,IF(COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)=1,2,IF(COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)=2,4,IF(COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)=3,6,IF(COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)>3,8,0))))),IF(COUNTIF(AE15:AL15,2)+COUNTIF(AE15:AL15,3)+COUNTIF(AE15:AL15,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT43","Mähise isoleerija",null,"o",4,null,null,null,4,null,4,4,"2016-08-01",null,0,null,null,null,null,"x",2,null,null,2,null,"2016-08-01",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)<1,0,IF(COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)=1,2,IF(COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)=2,4,IF(COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)=3,6,IF(COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)>3,8,0))))),IF(COUNTIF(AE16:AL16,2)+COUNTIF(AE16:AL16,3)+COUNTIF(AE16:AL16,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT43","Mähise isoleerija",null,"o",4,null,null,null,4,null,4,3,"2016-08-01",null,0,null,null,null,null,"x",2,null,null,2,null,"2016-08-01",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)<1,0,IF(COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)=1,2,IF(COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)=2,4,IF(COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)=3,6,IF(COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)>3,8,0))))),IF(COUNTIF(AE17:AL17,2)+COUNTIF(AE17:AL17,3)+COUNTIF(AE17:AL17,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT44","Spetsialist",null,"x",2,null,null,null,2,null,null,null,"2016-04-01",null,0,null,null,null,null,"o",4,null,null,4,4,"Spetsialist",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)<1,0,IF(COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)=1,2,IF(COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)=2,4,IF(COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)=3,6,IF(COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)>3,8,0))))),IF(COUNTIF(AE18:AL18,2)+COUNTIF(AE18:AL18,3)+COUNTIF(AE18:AL18,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT69","Tasakaalustaja",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)<1,0,IF(COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)=1,2,IF(COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)=2,4,IF(COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)=3,6,IF(COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)>3,8,0))))),IF(COUNTIF(AE19:AL19,2)+COUNTIF(AE19:AL19,3)+COUNTIF(AE19:AL19,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JTSN","Automaatpresside operaator",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)<1,0,IF(COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)=1,2,IF(COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)=2,4,IF(COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)=3,6,IF(COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)>3,8,0))))),IF(COUNTIF(AE20:AL20,2)+COUNTIF(AE20:AL20,3)+COUNTIF(AE20:AL20,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JT62","Staatori mähkija",null,null,0,null,null,null,null,null,null,null,"2014-02-13",null,0,null,null,null,null,null,0,null,null,null,null,"2014-02-13",{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)<1,0,IF(COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)=1,2,IF(COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)=2,4,IF(COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)=3,6,IF(COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)>3,8,0))))),IF(COUNTIF(AE21:AL21,2)+COUNTIF(AE21:AL21,3)+COUNTIF(AE21:AL21,4)>0,2,0))","v":{"$error":"#REF!"}}]
["xxxxx","xxxxx","xxxxx","JTVPI","Vaakumimmutaja",null,null,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(#REF!=\"o\",IF(COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)<1,0,IF(COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)=1,2,IF(COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)=2,4,IF(COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)=3,6,IF(COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)>3,8,0))))),IF(COUNTIF(AE22:AL22,2)+COUNTIF(AE22:AL22,3)+COUNTIF(AE22:AL22,4)>0,2,0))","v":{"$error":"#REF!"}}]