{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TÖÖVIHIKU KASUTUSJUHISED","HINNETELEHT"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"TÖÖVIHIKU KASUTUSJUHISED","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[]
[null,"Kasutage hinnete arvutamiseks seda õppepäevikut kui lõpphinde arvutamisel arvestatakse võrdselt kõiki ülesandeid."]
[null,"Juhised. Salvestage kindlasti igaks juhuks hinnetest varukoopiad."]
[null,"1. Sisestage oma kooli nimi, klassi teave, õppurite nimed ja õpilaste ID-d (valikuline).   "]
[null,"2. Kohandage tabelit „Hinne ja keskmine hinne“, et see vastaks teie tavapärasele hindamissüsteemile."]
[null,"3. Sisestage ülesannete nimed (nt „Õppetest 1“) ja hinded, mis algavad töölehel HINNETELEHT lahtris H7, liikuge nii palju paremale, kui soovite. Veerud „Keskmine“ „Hinde täht“, „Keskmine hinne“ ja „Puudu“ arvutatakse automaatselt, kuid te saate neid soovi korral muuta. Veerg „Puudu“ näitab ülesannete arvu, milles õppuril veel hinne puudub."]
[null,"Märkus. Prindiala on dünaamiline ja hinnete tabel ega ülesannete ala ei ole kuvatud. Kui soovite prindiala ala muuta, kasutage menüü KÜLJENDUS käsku „Prindiala“. "]

{"sheet":"HINNETELEHT","index":1,"n_rows":9,"n_cols":21,"rows_kept":9,"merged":[[1,1,3,3],[1,4,1,6],[2,4,2,6],[3,4,3,6]]}
[]
[null,"Õppeasutuse nimi",null,null,"Aasta/semester/kvartal",null,null,"Keskmine",{"v":0,"d":"0.00"},{"v":0.6,"d":"0.60"},0.63,0.67,{"v":0.7,"d":"0.70"},0.73,0.77,{"v":0.8,"d":"0.80"},0.83,0.87,{"v":0.9,"d":"0.90"},0.93,0.97]
[{"$nulls":4},"Klassi/projekti nimi",null,null,"Hinde täht","F","D–","D","D+","C–","C","C+","B–","B","B+","A–","A","A+"]
[{"$nulls":4},"Õpetaja nimi",null,null,"KESKMINE HINNE",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[null,"Õppuri nimi","Õppuri ID","Keskmine","Hinne","KESKMINE HINNE","Puudu","Ülesanne 1","Ülesanne 2","1. õppetest","2. õppetest","1. kontrolltöö","Ülesanne 3","Ülesanne 4","3. õppetest","2. kontrolltöö","Veerg10","Veerg11","Veerg12","Veerg13","Veerg14"]
[null,"Nimi 1",1234,{"$f":"IFERROR(AVERAGE(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))),\"\")","v":{"v":0.9166666666666666,"d":"0.92"}},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hindetähis)","v":"A–"},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hinde_keskmine)","v":3.67},{"$f":"IF(COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers])))=0,\"\",COUNTA(Andmed[[#Headers],[Ülesanne 1]]:INDEX(Andmed[#Headers],1,COUNTA(Andmed[#Headers])))-COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))))","v":11},0.88,0.95,0.92]
[null,"Nimi 2",5678,{"$f":"IFERROR(AVERAGE(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))),\"\")","v":{"v":0.7133333333333334,"d":"0.71"}},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hindetähis)","v":"C–"},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hinde_keskmine)","v":1.67},{"$f":"IF(COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers])))=0,\"\",COUNTA(Andmed[[#Headers],[Ülesanne 1]]:INDEX(Andmed[#Headers],1,COUNTA(Andmed[#Headers])))-COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))))","v":11},0.75,0.71,0.68]
[null,"Nimi 3",9876,{"$f":"IFERROR(AVERAGE(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))),\"\")","v":{"v":0.7933333333333333,"d":"0.79"}},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hindetähis)","v":"C+"},{"$f":"LOOKUP(Andmed[[#This Row],[Keskmine]],Keskmine_hinne,Hinde_keskmine)","v":2.33},{"$f":"IF(COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers])))=0,\"\",COUNTA(Andmed[[#Headers],[Ülesanne 1]]:INDEX(Andmed[#Headers],1,COUNTA(Andmed[#Headers])))-COUNTA(Andmed[[#This Row],[Ülesanne 1]]:INDEX(Andmed[],ROW(Andmed[[#This Row],[Ülesanne 1]])-ROW(Andmed[[#Headers],[Keskmine]]),COUNTA(Andmed[#Headers]))))","v":11},0.72,0.81,0.85]