{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":28,"n_cols":22,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[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,105,null,3,{"$f":"VLOOKUP(sifra,B4:C10,2,FALSE)*Q2","v":9},{"$f":"Q2+1","v":4}]
["radna mjesta","sifra RM","broj mjesta za popunu",null,"ima prijava","odabrano",null,"kandidat","želja 1","želja 2","želja 3","bodova","izabran na RM"]
["poz 1",101,2,null,{"$f":"COUNTIF(I$4:K$23,B4)","v":4},{"$f":"COUNTIF(N$4:N$23,\"izabran na \"&B4)","v":0},null,"kandidat 1",101,102,103,300,{"$f":"OR(I4=sifra,J4=sifra,K4=sifra)","v":false},{"$f":"IF(V4=\"da\",\"izabran na \"&sifra,\"\")","v":""},{"$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":0},null,{"$f":"IF(AND(OR(O4,P4,Q4>0),OR(O4,P4,Q4<Q$2)),\"da\",\"\")","v":""},{"$f":"IF(OR(O4,P4,Q4>0),\"da\",\"\")","v":""},{"$f":"IF(T4<>\"da\",\"\",COUNTIF(S$4:S4,\"da\"))","v":""},{"$f":"IF(U4<=R$2,\"da\",\"ne\")","v":"ne"}]
["poz 2",102,1,null,{"$f":"COUNTIF(I$4:K$23,B5)","v":5},{"$f":"COUNTIF(N$4:N$23,\"izabran na \"&B5)","v":0},null,"kandidat 2",102,103,104,290,false,"",{"$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":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K5)),MAX($O$3:Q4)+1,0)","v":0},null,{"$f":"IF(AND(OR(O5,P5,Q5>0),OR(O5,P5,Q5<Q$2)),\"da\",\"\")","v":""},{"$f":"IF(OR(O5,P5,Q5>0),\"da\",\"\")","v":""},{"$f":"IF(T5<>\"da\",\"\",COUNTIF(S$4:S5,\"da\"))","v":""},{"$f":"IF(U5<=R$2,\"da\",\"ne\")","v":"ne"}]
["poz 3",103,2,null,8,0,null,"kandidat 3",103,104,105,280,true,"izabran na 105",{"$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":1},null,"da","da",{"$f":"IF(T6<>\"da\",\"\",COUNTIF(T$4:T6,\"da\"))","v":1},"da"]
["poz 4",104,1,null,8,0,null,"kandidat 4",104,105,106,270,true,"izabran na 105",{"$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":1},{"$f":"IF(ISNUMBER(SEARCH(sifra,K7)),MAX($O$3:Q6)+1,0)","v":0},null,"da","da",{"$f":"IF(T7<>\"da\",\"\",COUNTIF(T$4:T7,\"da\"))","v":2},"da"]
["poz 5",105,3,null,11,9,null,"kandidat 5",105,106,107,260,true,"izabran na 105",{"$f":"IF(ISNUMBER(SEARCH(sifra,I8)),MAX($O$3:O7)+1,0)","v":1},{"$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,"da","da",{"$f":"IF(T8<>\"da\",\"\",COUNTIF(T$4:T8,\"da\"))","v":3},"da"]
["poz 6",106,2,null,7,0,null,"kandidat 6",106,107,null,250,false,"",{"$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(T9<>\"da\",\"\",COUNTIF(T$4:T9,\"da\"))","v":""},"ne"]
["poz 7",107,1,null,7,0,null,"kandidat 7",107,105,null,240,true,"izabran na 105",{"$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":2},{"$f":"IF(ISNUMBER(SEARCH(sifra,K10)),MAX($O$3:Q9)+1,0)","v":0},null,"da","da",{"$f":"IF(T10<>\"da\",\"\",COUNTIF(T$4:T10,\"da\"))","v":4},"da"]
[null,null,null,null,null,null,null,"kandidat 8",107,105,null,230,true,"izabran na 105",{"$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":3},{"$f":"IF(ISNUMBER(SEARCH(sifra,K11)),MAX($O$3:Q10)+1,0)","v":0},null,"da","da",{"$f":"IF(T11<>\"da\",\"\",COUNTIF(T$4:T11,\"da\"))","v":5},"da"]
[null,null,null,null,null,null,null,"kandidat 9",102,103,104,220,false,"",{"$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":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K12)),MAX($O$3:Q11)+1,0)","v":0},null,"","",{"$f":"IF(T12<>\"da\",\"\",COUNTIF(T$4:T12,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 10",103,104,105,210,true,"izabran na 105",{"$f":"IF(ISNUMBER(SEARCH(sifra,I13)),MAX($O$3:O12)+1,0)","v":0},{"$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":4},null,"","da",{"$f":"IF(T13<>\"da\",\"\",COUNTIF(T$4:T13,\"da\"))","v":6},"da"]
[null,null,null,null,null,null,null,"kandidat 11",104,105,106,200,true,"izabran na 105",{"$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":4},{"$f":"IF(ISNUMBER(SEARCH(sifra,K14)),MAX($O$3:Q13)+1,0)","v":0},null,"da","da",{"$f":"IF(T14<>\"da\",\"\",COUNTIF(T$4:T14,\"da\"))","v":7},"da"]
[null,null,null,null,null,null,null,"kandidat 12",105,106,107,190,true,"izabran na 105",{"$f":"IF(ISNUMBER(SEARCH(sifra,I15)),MAX($O$3:O14)+1,0)","v":2},{"$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,"da","da",{"$f":"IF(T15<>\"da\",\"\",COUNTIF(T$4:T15,\"da\"))","v":8},"da"]
[null,null,null,null,null,null,null,"kandidat 13",101,null,null,180,false,"",{"$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(T16<>\"da\",\"\",COUNTIF(T$4:T16,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 14",103,null,null,170,false,"",{"$f":"IF(ISNUMBER(SEARCH(sifra,I17)),MAX($O$3:O16)+1,0)","v":0},{"$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(T17<>\"da\",\"\",COUNTIF(T$4:T17,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 15",102,103,104,160,false,"",{"$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":0},{"$f":"IF(ISNUMBER(SEARCH(sifra,K18)),MAX($O$3:Q17)+1,0)","v":0},null,"","",{"$f":"IF(T18<>\"da\",\"\",COUNTIF(T$4:T18,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 16",103,104,105,150,true,"izabran na 105",{"$f":"IF(ISNUMBER(SEARCH(sifra,I19)),MAX($O$3:O18)+1,0)","v":0},{"$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":5},null,"","da",{"$f":"IF(T19<>\"da\",\"\",COUNTIF(T$4:T19,\"da\"))","v":9},"da"]
[null,null,null,null,null,null,null,"kandidat 17",101,105,106,140,true,"",{"$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":5},{"$f":"IF(ISNUMBER(SEARCH(sifra,K20)),MAX($O$3:Q19)+1,0)","v":0},null,"da","da",{"$f":"IF(T20<>\"da\",\"\",COUNTIF(T$4:T20,\"da\"))","v":10},"ne"]
[null,null,null,null,null,null,null,"kandidat 18",101,106,107,130,false,"",{"$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(T21<>\"da\",\"\",COUNTIF(T$4:T21,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 19",102,107,null,120,false,"",{"$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(T22<>\"da\",\"\",COUNTIF(T$4:T22,\"da\"))","v":""},"ne"]
[null,null,null,null,null,null,null,"kandidat 20",105,null,null,110,true,"",{"$f":"IF(ISNUMBER(SEARCH(sifra,I23)),MAX($O$3:O22)+1,0)","v":3},{"$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,"da","da",{"$f":"IF(T23<>\"da\",\"\",COUNTIF(T$4:T23,\"da\"))","v":11},"ne"]
[]
[]
[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"]