{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TÖÖVIHIKU KASUTUSJUHEND","KLASSIPÄEVIK"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"TÖÖVIHIKU KASUTUSJUHEND","index":0,"n_rows":10,"n_cols":2,"rows_kept":10}
[null,"JUHISED"]
[null,"Kasutage töölehte KLASSIPÄEVIK, et arvutada hindeid, kus iga ülesanne on väärt kindel arv punkte. "]
[null,"Juhised. Salvestage kindlasti hinnetest varukoopiad."]
[null,"1. Sisestage teie õppeasutuse 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 alates lahtrist G7 ülesande või testi nimed ning iga kohta käiv protsent (nt „Lõpueksam“ ja „50%“). "]
[null,"4. Sisestage kõigi õppurite iga ülesande või testi tulemused. Veerud „Tulemus“, „Hinde täht“ ja „Keskmine hinne“ arvutatakse automaatselt, kuid te saate neid soovi korral muuta. Hinnete arvutamise viis, keskmine ja lõplik hinne jäetakse enne kõigi tulemuste saabumist täitmata."]
[null,"Kui soovite prinditavat ala muuta, kasutage menüü Küljendus käsku „Prindiala“."]
[null,"Lahtrid Tulemus, Hinde täht ja Keskmine hinne ei ole õiged seni, kuni 100% testide ja ülesannete tulemused pole lõpule viidud. "]
[null,"Sisestage lahtrivahemikku G7–W8 ülesanded ja testid ning iga ülesande või testi protsent koguhindest."]

{"sheet":"KLASSIPÄEVIK","index":1,"n_rows":20,"n_cols":23,"rows_kept":20,"merged":[[5,1,5,5],[6,1,6,3],[6,4,6,5],[7,1,8,3],[7,4,7,5],[8,4,8,5],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null,"TEIE ÕPPEASUTUSE NIMI"]
[]
[{"$nulls":6},"Tulemus",{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.73,"d":"73%"},{"v":0.77,"d":"77%"},{"v":0.8,"d":"80%"},{"v":0.83,"d":"83%"},{"v":0.87,"d":"87%"},{"v":0.9,"d":"90%"},{"v":0.93,"d":"93%"},{"v":0.97,"d":"97%"}]
[{"$nulls":6},"Hinde täht","F","D–","D","D+","C–","C","C+","B–","B","B+","A–","A","A+"]
[{"$nulls":6},"KESKMINE HINNE",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[null,"Õpetaja nimi"]
[null,"Klassi/projekti nimi",null,null,"Ülesande või testi nimi"]
[null,"Aasta/semester/kvartal",null,null,"Protsent (peaks olema kokku 100%)"]
[{"$nulls":4},{"$f":"\"Protsent kokku: \"&SUM(G8:W8)*100&\"%\"","v":"Protsent kokku: 0%"}]
[null,"Õppuri nimi","Õppuri ID","Tulemus","Hinde täht","KESKMINE HINNE","Veerg6","Veerg7","Veerg8","Veerg9","Veerg10","Veerg11","Veerg12","Veerg13","Veerg14","Veerg15","Veerg16","Veerg17","Veerg18","Veerg19","Veerg20","Veerg21","Veerg22"]
[{"$nulls":3},{"$f":"(IF(SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]),ROUND(SUMPRODUCT($G$8:$W$8,Hinded[[#This Row],[Veerg6]:[Veerg22]]),2),\"\"))","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,2),\"\")","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]),ROUND(SUMPRODUCT($G$8:$W$8,Hinded[[#This Row],[Veerg6]:[Veerg22]]),2),\"\"))","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,2),\"\")","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]),ROUND(SUMPRODUCT($G$8:$W$8,Hinded[[#This Row],[Veerg6]:[Veerg22]]),2),\"\"))","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,2),\"\")","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]),ROUND(SUMPRODUCT($G$8:$W$8,Hinded[[#This Row],[Veerg6]:[Veerg22]]),2),\"\"))","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,2),\"\")","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,3),\"\")","v":""}]
[{"$nulls":3},{"$f":"(IF(SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]),ROUND(SUMPRODUCT($G$8:$W$8,Hinded[[#This Row],[Veerg6]:[Veerg22]]),2),\"\"))","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,2),\"\")","v":""},{"$f":"IF(Hinded[[#This Row],[Tulemus]]<>\"\",HLOOKUP(Hinded[[#This Row],[Tulemus]],Hindetabel,3),\"\")","v":""}]
[]
[null,"Klassi kokkuvõte",null,"Tulemus","Hinde täht","KESKMINE HINNE","","","","","","","","","","",""]
[null," Keskmine",null,{"$f":"IFERROR(AVERAGE(Hinded[[#All],[Tulemus]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D18,Hindetabel,2),\"\")","v":"F"},{"$f":"IFERROR(AVERAGE(Hinded[[#All],[KESKMINE HINNE]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Kõrgeim tulemus",null,{"$f":"IFERROR(MAX(Hinded[[#All],[Tulemus]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D19,Hindetabel,2),\"\")","v":"F"},{"$f":"IFERROR(MAX(Hinded[[#All],[KESKMINE HINNE]]),0)","v":0},"","","","","","","","","","","","","","","","",""]
[null," Madalaim tulemus",null,{"$f":"IFERROR(MIN(Hinded[[#All],[Tulemus]]),0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(HLOOKUP(D20,Hindetabel,2),\"\")","v":"F"},{"$f":"IFERROR(MIN(Hinded[[#All],[KESKMINE HINNE]]),0)","v":0},"","","","","","","","","","","","","","","","",""]