{"text_format":"3","workbook":"xls","n_sheets":7,"sheets":["Popis učenika","1. ispit znanja","2. ispit znanja","3. ispit znanja","4. ispit znanja","5. ispit znanja","Upute"],"not_rendered":{"charts":5,"macros":1,"external_links":1,"defined_names":6,"comments":55},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Popis učenika","index":0,"n_rows":38,"n_cols":11,"rows_kept":38,"merged":[[0,0,0,6],[0,7,0,8],[1,0,37,0],[1,8,37,9],[2,10,2,11],[2,12,2,13],[4,10,4,11],[4,12,4,13],[6,10,6,11],[6,12,6,13],[8,10,8,11],[8,12,8,13],[10,10,10,11],[10,12,10,13],[12,10,12,11],[38,0,38,9]],"flags":["formulas_cached_only"]}
[{"$nulls":7},"Razred:",null," "]
[null,null,"Popis učenika"," "," "," "," "," "]
[null,"Redni broj","Ime i prezime","1. iz","2. iz","3. iz","4. iz","5. iz",null,null,"1. ispit znanja"]
[null,"1."," ",false,false,false,false,false]
[null,"2."," ",false,false,false,false,false,null,null,"2. ispit znanja"]
[null,"3."," ",false,false,false,false,false]
[null,"4."," ",false,false,false,false,false,null,null,"3. ispit znanja"]
[null,"5."," ",false,false,false,false,false]
[null,"6."," ",false,false,false,false,false,null,null,"4. ispit znanja"]
[null,"7."," ",false,false,false,false,false]
[null,"8."," ",false,false,false,false,false,null,null,"5. ispit znanja"]
[null,"9."," ",false,false,false,false,false]
[null,"10."," ",false,false,false,false,false,null,null,"Upute"]
[null,"11."," ",false,false,false,false,false]
[null,"12."," ",false,false,false,false,false]
[null,"13."," ",false,false,false,false,false]
[null,"14."," ",false,false,false,false,false]
[null,"15."," ",false,false,false,false,false]
[null,"16."," ",false,false,false,false,false]
[null,"17."," ",false,false,false,false,false]
[null,"18."," ",false,false,false,false,false]
[null,"19."," ",false,false,false,false,false]
[null,"20."," ",false,false,false,false,false]
[null,"21."," ",false,false,false,false,false]
[null,"22."," ",false,false,false,false,false]
[null,"23."," ",false,false,false,false,false]
[null,"24."," ",false,false,false,false,false]
[null,"25."," ",false,false,false,false,false]
[null,"26."," ",false,false,false,false,false]
[null,"27."," ",false,false,false,false,false]
[null,"28."," ",false,false,false,false,false]
[null,"29."," ",false,false,false,false,false]
[null,"30."," ",false,false,false,false,false]
[null,"31."," ",false,false,false,false,false]
[null,"32."," ",false,false,false,false,false]
[null,"33."," ",false,false,false,false,false]
[null,"34."," ",false,false,false,false,false]
[null,"35."," ",false,false,false,false,false]

{"sheet":"1. ispit znanja","index":1,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,0,0,8],[0,9,9,9],[1,0,1,8],[2,6,2,7],[4,6,5,7],[7,6,7,7],[9,6,9,7],[12,5,12,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[39,1,39,2],[39,5,39,7],[40,1,40,2],[40,5,40,6],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]],"flags":["formulas_cached_only"]}
["1. ISPIT ZNANJA",{"$nulls":8},"Popis učenika"]
[]
["R. b.","Ime i prezime","bodovi","ocjena",null,"nadnevak:"," "]
["1."," "," ",false]
["2."," "," ",false,null,"razred:"," "]
["3."," "," ",false]
["4."," "," ",false]
["5."," "," ",false,null,"n. predmet:"]
["6."," "," ",false]
["7."," "," ",false,null,"učitelj:"]
["8."," "," ",false]
["9."," "," ",false]
["10."," "," ",false,null,"broj bodova po zadacima"]
["11."," "," ",false,null,"1. zadatak",null,"/"]
["12."," "," ",false,null,"2. zadatak",null,"/"]
["13."," "," ",false,null,"3. zadatak",null,"/"]
["14."," "," ",false,null,"4. zadatak",null,"/"]
["15."," "," ",false,null,"5. zadatak",null,"/"]
["16."," "," ",false,null,"6. zadatak",null,"/"]
["17."," "," ",false,null,"7. zadatak",null,"/"]
["18."," "," ",false,null,"8. zadatak",null,"/"]
["19."," "," ",false,null,"9. zadatak",null,"/"]
["20."," "," ",false,null,"10. zadatak",null,"/"]
["21."," "," ",false,null,"11. zadatak",null,"/"]
["22."," "," ",false,null,"12. zadatak",null,"/"]
["23."," "," ",false,null,"13. zadatak",null,"/"]
["24."," "," ",false,null,"14. zadatak",null,"/"]
["25."," "," ",false,null,"15. zadatak",null,"/"]
["26."," "," ",false]
["27."," "," ",false,null,"postotak za odličan:",null,{"$error":"#DIV/0!"}]
["28."," "," ",false,null,"postotak za vrlo dobar:",null,{"$error":"#DIV/0!"}]
["29."," "," ",false,null,"postotak za dobar:",null,{"$error":"#DIV/0!"}]
["30."," "," ",false,null,"postotak za dovoljan:",null,{"$error":"#DIV/0!"}]
["31."," "," ",false]
["32."," "," ",false]
["33."," "," ",false]
["34."," "," ",false]
["35."," "," ",false]
[]
[null,"prosjek bodova po učeniku:",null,{"$error":"#DIV/0!"},null,"kriterij ocjenjivanja"]
[null,"prosječna ocjena razreda:",null,{"$error":"#DIV/0!"},null,"maksimalno bodova:",null,0]
[null,"odličnih:",null,0,null,"odličan:",null,0]
[null,"vrlo dobrih:",null,0,null,"vrlo dobar:"]
[null,"dobrih:",null,0,null,"dobar:"]
[null,"dovoljnih:",null,0,null,"dovoljan:"]
[null,"nedovoljnih:",null,0,null,"nedovoljan:",0]

{"sheet":"2. ispit znanja","index":2,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,0,0,8],[0,9,9,9],[1,0,1,8],[2,6,2,7],[4,6,5,7],[7,6,7,7],[9,6,9,7],[12,5,12,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[39,1,39,2],[39,5,39,7],[40,1,40,2],[40,5,40,6],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]],"flags":["formulas_cached_only"]}
["2. ISPIT ZNANJA",{"$nulls":8},"Popis učenika"]
[]
["R. b.","Ime i prezime","bodovi","ocjena",null,"nadnevak:"," "]
["1."," "," ",false]
["2."," "," ",false,null,"razred:"," "]
["3."," "," ",false]
["4."," "," ",false]
["5."," "," ",false,null,"n. predmet:"]
["6."," "," ",false]
["7."," "," ",false,null,"učitelj:"]
["8."," "," ",false]
["9."," "," ",false]
["10."," "," ",false,null,"broj bodova po zadacima"]
["11."," "," ",false,null,"1. zadatak",null,"/"]
["12."," "," ",false,null,"2. zadatak",null,"/"]
["13."," "," ",false,null,"3. zadatak",null,"/"]
["14."," "," ",false,null,"4. zadatak",null,"/"]
["15."," "," ",false,null,"5. zadatak",null,"/"]
["16."," "," ",false,null,"6. zadatak",null,"/"]
["17."," "," ",false,null,"7. zadatak",null,"/"]
["18."," "," ",false,null,"8. zadatak",null,"/"]
["19."," "," ",false,null,"9. zadatak",null,"/"]
["20."," "," ",false,null,"10. zadatak",null,"/"]
["21."," "," ",false,null,"11. zadatak",null,"/"]
["22."," "," ",false,null,"12. zadatak",null,"/"]
["23."," "," ",false,null,"13. zadatak",null,"/"]
["24."," "," ",false,null,"14. zadatak",null,"/"]
["25."," "," ",false,null,"15. zadatak",null,"/"]
["26."," "," ",false]
["27."," "," ",false,null,"postotak za odličan:",null,{"$error":"#DIV/0!"}]
["28."," "," ",false,null,"postotak za vrlo dobar:",null,{"$error":"#DIV/0!"}]
["29."," "," ",false,null,"postotak za dobar:",null,{"$error":"#DIV/0!"}]
["30."," "," ",false,null,"postotak za dovoljan:",null,{"$error":"#DIV/0!"}]
["31."," "," ",false]
["32."," "," ",false]
["33."," "," ",false]
["34."," "," ",false]
["35."," "," ",false]
[]
[null,"prosjek bodova po učeniku:",null,{"$error":"#DIV/0!"},null,"kriterij ocjenjivanja"]
[null,"prosječna ocjena razreda:",null,{"$error":"#DIV/0!"},null,"maksimalno bodova:",null,0]
[null,"odličnih:",null,0,null,"odličan:",null,0]
[null,"vrlo dobrih:",null,0,null,"vrlo dobar:"]
[null,"dobrih:",null,0,null,"dobar:"]
[null,"dovoljnih:",null,0,null,"dovoljan:"]
[null,"nedovoljnih:",null,0,null,"nedovoljan:",0]

{"sheet":"3. ispit znanja","index":3,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,0,0,8],[0,9,9,9],[1,0,1,8],[2,6,2,7],[4,6,5,7],[7,6,7,7],[9,6,9,7],[12,5,12,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[39,1,39,2],[39,5,39,7],[40,1,40,2],[40,5,40,6],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]],"flags":["formulas_cached_only"]}
["3. ISPIT ZNANJA",{"$nulls":8},"Popis učenika"]
[]
["R. b.","Ime i prezime","bodovi","ocjena",null,"nadnevak:"," "]
["1."," "," ",false]
["2."," "," ",false,null,"razred:"," "]
["3."," "," ",false]
["4."," "," ",false]
["5."," "," ",false,null,"n. predmet:"]
["6."," "," ",false]
["7."," "," ",false,null,"učitelj:"]
["8."," "," ",false]
["9."," "," ",false]
["10."," "," ",false,null,"broj bodova po zadacima"]
["11."," "," ",false,null,"1. zadatak",null,"/"]
["12."," "," ",false,null,"2. zadatak",null,"/"]
["13."," "," ",false,null,"3. zadatak",null,"/"]
["14."," "," ",false,null,"4. zadatak",null,"/"]
["15."," "," ",false,null,"5. zadatak",null,"/"]
["16."," "," ",false,null,"6. zadatak",null,"/"]
["17."," "," ",false,null,"7. zadatak",null,"/"]
["18."," "," ",false,null,"8. zadatak",null,"/"]
["19."," "," ",false,null,"9. zadatak",null,"/"]
["20."," "," ",false,null,"10. zadatak",null,"/"]
["21."," "," ",false,null,"11. zadatak",null,"/"]
["22."," "," ",false,null,"12. zadatak",null,"/"]
["23."," "," ",false,null,"13. zadatak",null,"/"]
["24."," "," ",false,null,"14. zadatak",null,"/"]
["25."," "," ",false,null,"15. zadatak",null,"/"]
["26."," "," ",false]
["27."," "," ",false,null,"postotak za odličan:",null,{"$error":"#DIV/0!"}]
["28."," "," ",false,null,"postotak za vrlo dobar:",null,{"$error":"#DIV/0!"}]
["29."," "," ",false,null,"postotak za dobar:",null,{"$error":"#DIV/0!"}]
["30."," "," ",false,null,"postotak za dovoljan:",null,{"$error":"#DIV/0!"}]
["31."," "," ",false]
["32."," "," ",false]
["33."," "," ",false]
["34."," "," ",false]
["35."," "," ",false]
[]
[null,"prosjek bodova po učeniku:",null,{"$error":"#DIV/0!"},null,"kriterij ocjenjivanja"]
[null,"prosječna ocjena razreda:",null,{"$error":"#DIV/0!"},null,"maksimalno bodova:",null,0]
[null,"odličnih:",null,0,null,"odličan:",null,0]
[null,"vrlo dobrih:",null,0,null,"vrlo dobar:"]
[null,"dobrih:",null,0,null,"dobar:"]
[null,"dovoljnih:",null,0,null,"dovoljan:"]
[null,"nedovoljnih:",null,0,null,"nedovoljan:",0]

{"sheet":"4. ispit znanja","index":4,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,0,0,8],[0,9,9,9],[1,0,1,8],[2,6,2,7],[4,6,5,7],[7,6,7,7],[9,6,9,7],[12,5,12,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[39,1,39,2],[39,5,39,7],[40,1,40,2],[40,5,40,6],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]],"flags":["formulas_cached_only"]}
["4. ISPIT ZNANJA",{"$nulls":8},"Popis učenika"]
[]
["R. b.","Ime i prezime","bodovi","ocjena",null,"nadnevak:"," "]
["1."," "," ",false]
["2."," "," ",false,null,"razred:"," "]
["3."," "," ",false]
["4."," "," ",false]
["5."," "," ",false,null,"n. predmet:"]
["6."," "," ",false]
["7."," "," ",false,null,"učitelj:"]
["8."," "," ",false]
["9."," "," ",false]
["10."," "," ",false,null,"broj bodova po zadacima"]
["11."," "," ",false,null,"1. zadatak",null,"/"]
["12."," "," ",false,null,"2. zadatak",null,"/"]
["13."," "," ",false,null,"3. zadatak",null,"/"]
["14."," "," ",false,null,"4. zadatak",null,"/"]
["15."," "," ",false,null,"5. zadatak",null,"/"]
["16."," "," ",false,null,"6. zadatak",null,"/"]
["17."," "," ",false,null,"7. zadatak",null,"/"]
["18."," "," ",false,null,"8. zadatak",null,"/"]
["19."," "," ",false,null,"9. zadatak",null,"/"]
["20."," "," ",false,null,"10. zadatak",null,"/"]
["21."," "," ",false,null,"11. zadatak",null,"/"]
["22."," "," ",false,null,"12. zadatak",null,"/"]
["23."," "," ",false,null,"13. zadatak",null,"/"]
["24."," "," ",false,null,"14. zadatak",null,"/"]
["25."," "," ",false,null,"15. zadatak",null,10]
["26."," "," ",false]
["27."," "," ",false,null,"postotak za odličan:",null,{"v":0.9,"d":"90%"}]
["28."," "," ",false,null,"postotak za vrlo dobar:",null,{"v":0.7,"d":"70%"}]
["29."," "," ",false,null,"postotak za dobar:",null,{"v":0.5,"d":"50%"}]
["30."," "," ",false,null,"postotak za dovoljan:",null,{"v":0.3,"d":"30%"}]
["31."," "," ",false]
["32."," "," ",false]
["33."," "," ",false]
["34."," "," ",false]
["35."," "," ",false]
[]
[null,"prosjek bodova po učeniku:",null,{"$error":"#DIV/0!"},null,"kriterij ocjenjivanja"]
[null,"prosječna ocjena razreda:",null,{"$error":"#DIV/0!"},null,"maksimalno bodova:",null,10]
[null,"odličnih:",null,0,null,"odličan:",9,10]
[null,"vrlo dobrih:",null,0,null,"vrlo dobar:",7,8]
[null,"dobrih:",null,0,null,"dobar:",5,6]
[null,"dovoljnih:",null,0,null,"dovoljan:",3,4]
[null,"nedovoljnih:",null,0,null,"nedovoljan:",0,2]

{"sheet":"5. ispit znanja","index":5,"n_rows":46,"n_cols":10,"rows_kept":46,"merged":[[0,0,0,8],[0,9,9,9],[1,0,1,8],[2,6,2,7],[4,6,5,7],[7,6,7,7],[9,6,9,7],[12,5,12,7],[13,5,13,6],[14,5,14,6],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[27,5,27,6],[29,5,29,6],[30,5,30,6],[31,5,31,6],[32,5,32,6],[39,1,39,2],[39,5,39,7],[40,1,40,2],[40,5,40,6],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2]],"flags":["formulas_cached_only"]}
["5. ISPIT ZNANJA",{"$nulls":8},"Popis učenika"]
[]
["R. b.","Ime i prezime","bodovi","ocjena",null,"nadnevak:"," "]
["1."," "," ",false]
["2."," "," ",false,null,"razred:"," "]
["3."," "," ",false]
["4."," "," ",false]
["5."," "," ",false,null,"n. predmet:"]
["6."," "," ",false]
["7."," "," ",false,null,"učitelj:"]
["8."," "," ",false]
["9."," "," ",false]
["10."," "," ",false,null,"broj bodova po zadacima"]
["11."," "," ",false,null,"1. zadatak",null,"/"]
["12."," "," ",false,null,"2. zadatak",null,"/"]
["13."," "," ",false,null,"3. zadatak",null,"/"]
["14."," "," ",false,null,"4. zadatak",null,"/"]
["15."," "," ",false,null,"5. zadatak",null,"/"]
["16."," "," ",false,null,"6. zadatak",null,"/"]
["17."," "," ",false,null,"7. zadatak",null,"/"]
["18."," "," ",false,null,"8. zadatak",null,"/"]
["19."," "," ",false,null,"9. zadatak",null,"/"]
["20."," "," ",false,null,"10. zadatak",null,"/"]
["21."," "," ",false,null,"11. zadatak",null,"/"]
["22."," "," ",false,null,"12. zadatak",null,"/"]
["23."," "," ",false,null,"13. zadatak",null,"/"]
["24."," "," ",false,null,"14. zadatak",null,"/"]
["25."," "," ",false,null,"15. zadatak",null,"/"]
["26."," "," ",false]
["27."," "," ",false,null,"postotak za odličan:",null,{"$error":"#DIV/0!"}]
["28."," "," ",false,null,"postotak za vrlo dobar:",null,{"$error":"#DIV/0!"}]
["29."," "," ",false,null,"postotak za dobar:",null,{"$error":"#DIV/0!"}]
["30."," "," ",false,null,"postotak za dovoljan:",null,{"$error":"#VALUE!"}]
["31."," "," ",false]
["32."," "," ",false]
["33."," "," ",false]
["34."," "," ",false]
["35."," "," ",false]
[]
[null,"prosjek bodova po učeniku:",null,{"$error":"#DIV/0!"},null,"kriterij ocjenjivanja"]
[null,"prosječna ocjena razreda:",null,{"$error":"#DIV/0!"},null,"maksimalno bodova:",null,0]
[null,"odličnih:",null,0,null,"odličan:",null,0]
[null,"vrlo dobrih:",null,0,null,"vrlo dobar:"]
[null,"dobrih:",null,0,null,"dobar:"]
[null,"dovoljnih:",null,0,null,"dovoljan:"," "]
[null,"nedovoljnih:",null,0,null,"nedovoljan:",0," "]

{"sheet":"Upute","index":6,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,0,0,1],[0,8,10,9],[2,0,2,7],[3,0,3,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[9,0,9,7],[10,0,10,7],[11,0,11,7],[12,0,12,7],[14,0,14,7],[15,0,15,7],[17,0,17,7],[18,0,18,7],[20,0,20,7],[22,0,22,7],[24,0,24,4],[24,5,24,7]],"flags":["formulas_cached_only"]}
["Upute:",{"$nulls":7},"Popis učenika"]
[]
["1. Na listu \"Popis učenika\" upišite samo imena i prezimena učenika te razred."]
["    (time su ti podaci upisani na sve ostale listove)"]
[]
["2. Na listovima \"#. ispit znanja\" popunite ćelije za \"nadnevak\", \"predmet\" i \"učitelj\"; te tablice "]
["    \"broj bodova po zadacima\" i \"kriterij ocjenjivanja\" (gornja granica manje ocjene i donja "]
["    granica veće ocjene moraju biti različite)."]
[]
["2. a) Unesite broj bodova za svakog učenika (taj se broj mora nalaziti u jednom od intervala"]
["        u kriteriju ocjenjivanja)."]
["VAŽNO! Ukoliko učenik nije pisao i.z. kao broj bodova unesite prazan znak (tipka \"space\") "]
["             jer će u suprotnom njegova ocjena automatski biti 1."]
[]
["3. Pri upisivanju datuma i kriterija ocjenjivanja pročitajte komentar koji vam se pojavi"]
["    dolaskom na ćeliju."]
[]
["3. a) U tablici \"kriterij ocjenjivanja\" donju granicu za nedovoljan i gornju granicu"]
["        za odličan nije potrebno unositi"]
[]
["4. Radi lakšeg pregledavanja koristite linkove sa strane (linkovi su izvan područja ispisa)"]
[]
["5. Ćelijama koje su zaštićene nije moguće mijenjati ni oblik ni vrijednost."]
[]
["Dodatne upute:",{"$nulls":4},"zlatko.lobor2@zg.t-com.hr "]