{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Sheet1","index":0,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[27,0,27,5]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sifra RM",null,"br.za listu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,null,3,{"$f":"VLOOKUP(sifra,B4:C10,2,FALSE)*Q2","v":6}]
["radna mjesta","sifra RM","broj mjesta za popunu","broj kand po RM","ima prijava","odabrano",null,"kandidat","želja 1","želja 2","želja 3","bodova","izabran na RM"]
["poz 1",101,2,{"$f":"C4*brkand","v":6},{"$f":"COUNTIF(I$4:K$23,B4)","v":4},{"$f":"COUNTIF(N$4:N$23,\"izabran na \"&B4)","v":0},null,"kandidat 1",102,102,103,300,{"$f":"OR(I4=sifra,J4=sifra,K4=sifra)","v":true},{"$f":"IF(M4=FALSE,\"\",IF(COUNTIF(M$4:M4,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I4)),MAX($O$3:O3)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J4)),MAX($O$3:P3)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K4)),MAX($O$3:Q3)+1,0)","v":1},null,{"$f":"IF(M4<>TRUE,\"\",COUNTIF(M$4:M4,TRUE))","v":1},{"$f":"IF(S4<=R$2,\"da\",\"\")","v":"da"},{"$f":"IF(M4<>TRUE,\"\",IF(COUNTIF(M$4:M4,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
["poz 2",102,1,{"$f":"C5*brkand","v":3},{"$f":"COUNTIF(I$4:K$23,B5)","v":6},{"$f":"COUNTIF(N$4:N$23,\"izabran na \"&B5)","v":0},null,"kandidat 2",102,103,104,290,true,{"$f":"IF(M5=FALSE,\"\",IF(COUNTIF(M$4:M5,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I5)),MAX($O$3:O4)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J5)),MAX($O$3:P4)+1,0)","v":1},{"$f":"IF(ISNUMBER(SEARCH(sifra,K5)),MAX($O$3:Q4)+1,0)","v":0},null,{"$f":"IF(M5<>TRUE,\"\",COUNTIF(M$4:M5,TRUE))","v":2},{"$f":"IF(S5<=R$2,\"da\",\"\")","v":"da"},{"$f":"IF(M5<>TRUE,\"\",IF(COUNTIF(M$4:M5,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
["poz 3",103,2,{"$f":"C6*brkand","v":6},7,6,null,"kandidat 3",101,104,105,280,false,{"$f":"IF(M6=FALSE,\"\",IF(COUNTIF(M$4:M6,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I6)),MAX($O$3:O5)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J6)),MAX($O$3:P5)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K6)),MAX($O$3:Q5)+1,0)","v":0},null,{"$f":"IF(M6<>TRUE,\"\",COUNTIF(M$4:M6,TRUE))","v":""},"",{"$f":"IF(M6<>TRUE,\"\",IF(COUNTIF(M$4:M6,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["poz 4",104,1,{"$f":"C7*brkand","v":3},8,0,null,"kandidat 4",104,105,106,270,false,{"$f":"IF(M7=FALSE,\"\",IF(COUNTIF(M$4:M7,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I7)),MAX($O$3:O6)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J7)),MAX($O$3:P6)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K7)),MAX($O$3:Q6)+1,0)","v":0},null,{"$f":"IF(M7<>TRUE,\"\",COUNTIF(M$4:M7,TRUE))","v":""},"",{"$f":"IF(M7<>TRUE,\"\",IF(COUNTIF(M$4:M7,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["poz 5",105,3,{"$f":"C8*brkand","v":9},11,0,null,"kandidat 5",105,106,107,260,false,{"$f":"IF(M8=FALSE,\"\",IF(COUNTIF(M$4:M8,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I8)),MAX($O$3:O7)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J8)),MAX($O$3:P7)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K8)),MAX($O$3:Q7)+1,0)","v":0},null,{"$f":"IF(M8<>TRUE,\"\",COUNTIF(M$4:M8,TRUE))","v":""},"",{"$f":"IF(M8<>TRUE,\"\",IF(COUNTIF(M$4:M8,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["poz 6",106,2,{"$f":"C9*brkand","v":6},7,0,null,"kandidat 6",106,107,null,250,false,{"$f":"IF(M9=FALSE,\"\",IF(COUNTIF(M$4:M9,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I9)),MAX($O$3:O8)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J9)),MAX($O$3:P8)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K9)),MAX($O$3:Q8)+1,0)","v":0},null,{"$f":"IF(M9<>TRUE,\"\",COUNTIF(M$4:M9,TRUE))","v":""},"",{"$f":"IF(M9<>TRUE,\"\",IF(COUNTIF(M$4:M9,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["poz 7",107,1,{"$f":"C10*brkand","v":3},7,0,null,"kandidat 7",107,105,null,240,false,{"$f":"IF(M10=FALSE,\"\",IF(COUNTIF(M$4:M10,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I10)),MAX($O$3:O9)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J10)),MAX($O$3:P9)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K10)),MAX($O$3:Q9)+1,0)","v":0},null,{"$f":"IF(M10<>TRUE,\"\",COUNTIF(M$4:M10,TRUE))","v":""},"",{"$f":"IF(M10<>TRUE,\"\",IF(COUNTIF(M$4:M10,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
[null,null,null,null,null,null,null,"kandidat 8",107,105,null,230,false,{"$f":"IF(M11=FALSE,\"\",IF(COUNTIF(M$4:M11,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I11)),MAX($O$3:O10)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J11)),MAX($O$3:P10)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K11)),MAX($O$3:Q10)+1,0)","v":0},null,{"$f":"IF(M11<>TRUE,\"\",COUNTIF(M$4:M11,TRUE))","v":""},"",{"$f":"IF(M11<>TRUE,\"\",IF(COUNTIF(M$4:M11,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
[null,null,null,null,null,null,null,"kandidat 9",102,103,104,220,true,{"$f":"IF(M12=FALSE,\"\",IF(COUNTIF(M$4:M12,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I12)),MAX($O$3:O11)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J12)),MAX($O$3:P11)+1,0)","v":2},{"$f":"IF(ISNUMBER(SEARCH(sifra,K12)),MAX($O$3:Q11)+1,0)","v":0},null,{"$f":"IF(M12<>TRUE,\"\",COUNTIF(M$4:M12,TRUE))","v":3},"da",{"$f":"IF(M12<>TRUE,\"\",IF(COUNTIF(M$4:M12,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
[null,null,null,null,null,null,null,"kandidat 10",103,104,105,210,true,{"$f":"IF(M13=FALSE,\"\",IF(COUNTIF(M$4:M13,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I13)),MAX($O$3:O12)+1,0)","v":1},{"$f":"IF(ISNUMBER(SEARCH(sifra,J13)),MAX($O$3:P12)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K13)),MAX($O$3:Q12)+1,0)","v":0},null,{"$f":"IF(M13<>TRUE,\"\",COUNTIF(M$4:M13,TRUE))","v":4},"da",{"$f":"IF(M13<>TRUE,\"\",IF(COUNTIF(M$4:M13,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
["Dopuna",null,null,null,null,null,null,"kandidat 11",104,105,106,200,false,{"$f":"IF(M14=FALSE,\"\",IF(COUNTIF(M$4:M14,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I14)),MAX($O$3:O13)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J14)),MAX($O$3:P13)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K14)),MAX($O$3:Q13)+1,0)","v":0},null,{"$f":"IF(M14<>TRUE,\"\",COUNTIF(M$4:M14,TRUE))","v":""},"",{"$f":"IF(M14<>TRUE,\"\",IF(COUNTIF(M$4:M14,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["U tabeli iznad imamo pregled pozicija i koliko se kandidata",null,null,null,null,null,null,"kandidat 12",105,106,107,190,false,{"$f":"IF(M15=FALSE,\"\",IF(COUNTIF(M$4:M15,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I15)),MAX($O$3:O14)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J15)),MAX($O$3:P14)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K15)),MAX($O$3:Q14)+1,0)","v":0},null,{"$f":"IF(M15<>TRUE,\"\",COUNTIF(M$4:M15,TRUE))","v":""},"",{"$f":"IF(M15<>TRUE,\"\",IF(COUNTIF(M$4:M15,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["prima po poziciji što je bitno za varijantu 2 tako da umesto 1",null,null,null,null,null,null,"kandidat 13",101,null,null,180,false,{"$f":"IF(M16=FALSE,\"\",IF(COUNTIF(M$4:M16,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I16)),MAX($O$3:O15)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J16)),MAX($O$3:P15)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K16)),MAX($O$3:Q15)+1,0)","v":0},null,{"$f":"IF(M16<>TRUE,\"\",COUNTIF(M$4:M16,TRUE))","v":""},"",{"$f":"IF(M16<>TRUE,\"\",IF(COUNTIF(M$4:M16,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["treba da boji po poziciji koliko se prima kandidata po poziciji",null,null,null,null,null,null,"kandidat 14",103,null,null,170,true,{"$f":"IF(M17=FALSE,\"\",IF(COUNTIF(M$4:M17,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I17)),MAX($O$3:O16)+1,0)","v":2},{"$f":"IF(ISNUMBER(SEARCH(sifra,J17)),MAX($O$3:P16)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K17)),MAX($O$3:Q16)+1,0)","v":0},null,{"$f":"IF(M17<>TRUE,\"\",COUNTIF(M$4:M17,TRUE))","v":5},"da",{"$f":"IF(M17<>TRUE,\"\",IF(COUNTIF(M$4:M17,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
[null,null,null,null,null,null,null,"kandidat 15",102,103,104,160,true,{"$f":"IF(M18=FALSE,\"\",IF(COUNTIF(M$4:M18,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":"izabran na 103"},{"$f":"IF(ISNUMBER(SEARCH(sifra,I18)),MAX($O$3:O17)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J18)),MAX($O$3:P17)+1,0)","v":3},{"$f":"IF(ISNUMBER(SEARCH(sifra,K18)),MAX($O$3:Q17)+1,0)","v":0},null,{"$f":"IF(M18<>TRUE,\"\",COUNTIF(M$4:M18,TRUE))","v":6},"da",{"$f":"IF(M18<>TRUE,\"\",IF(COUNTIF(M$4:M18,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":"izabran na 103"}]
["U sledećoj koloni imamo podatke koji se tiču varijante 1",null,null,null,null,null,null,"kandidat 16",103,104,105,150,true,{"$f":"IF(M19=FALSE,\"\",IF(COUNTIF(M$4:M19,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I19)),MAX($O$3:O18)+1,0)","v":3},{"$f":"IF(ISNUMBER(SEARCH(sifra,J19)),MAX($O$3:P18)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K19)),MAX($O$3:Q18)+1,0)","v":0},null,{"$f":"IF(M19<>TRUE,\"\",COUNTIF(M$4:M19,TRUE))","v":7},"",{"$f":"IF(M19<>TRUE,\"\",IF(COUNTIF(M$4:M19,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["Broj tri koji sam naveo može biti promenljiv i zato sam ga",null,null,null,null,null,null,"kandidat 17",101,105,106,140,false,{"$f":"IF(M20=FALSE,\"\",IF(COUNTIF(M$4:M20,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I20)),MAX($O$3:O19)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J20)),MAX($O$3:P19)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K20)),MAX($O$3:Q19)+1,0)","v":0},null,{"$f":"IF(M20<>TRUE,\"\",COUNTIF(M$4:M20,TRUE))","v":""},"",{"$f":"IF(M20<>TRUE,\"\",IF(COUNTIF(M$4:M20,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["označio u polju Q2 a manifestuje se na koloni D tako",null,null,null,null,null,null,"kandidat 18",101,106,107,130,false,{"$f":"IF(M21=FALSE,\"\",IF(COUNTIF(M$4:M21,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I21)),MAX($O$3:O20)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J21)),MAX($O$3:P20)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K21)),MAX($O$3:Q20)+1,0)","v":0},null,{"$f":"IF(M21<>TRUE,\"\",COUNTIF(M$4:M21,TRUE))","v":""},"",{"$f":"IF(M21<>TRUE,\"\",IF(COUNTIF(M$4:M21,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
["za svaku poziciju treba obojiti koliko piše u koloni D",null,null,null,null,null,null,"kandidat 19",102,107,null,120,false,{"$f":"IF(M22=FALSE,\"\",IF(COUNTIF(M$4:M22,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I22)),MAX($O$3:O21)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J22)),MAX($O$3:P21)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K22)),MAX($O$3:Q21)+1,0)","v":0},null,{"$f":"IF(M22<>TRUE,\"\",COUNTIF(M$4:M22,TRUE))","v":""},"",{"$f":"IF(M22<>TRUE,\"\",IF(COUNTIF(M$4:M22,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
[null,null,null,null,null,null,null,"kandidat 20",105,null,null,110,false,{"$f":"IF(M23=FALSE,\"\",IF(COUNTIF(M$4:M23,TRUE)<=VLOOKUP(sifra,B$4:D$10,3,FALSE),\"izabran na \"&sifra,\"\"))","v":""},{"$f":"IF(ISNUMBER(SEARCH(sifra,I23)),MAX($O$3:O22)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,J23)),MAX($O$3:P22)+1,0)","v":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K23)),MAX($O$3:Q22)+1,0)","v":0},null,{"$f":"IF(M23<>TRUE,\"\",COUNTIF(M$4:M23,TRUE))","v":""},"",{"$f":"IF(M23<>TRUE,\"\",IF(COUNTIF(M$4:M23,TRUE)<=R$2,\"izabran na \"&sifra,\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,"Imam tabelu sa kandidatima koji su konkurisali na tri pozicije "]
[null,null,null,null,null,null,null,null,"Kako da pomoću VBA ofarbam prva tri kandidata na svakoj listi kao na primeru"]
[null,null,null,null,null,null,null,null,"Ako se traže 2 lica po poziciji onda treba da ofarba prvih 6 kandidata i sl"]