{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["TÖÖVIHIKU KASUTUSJUHEND","KLASSIPÄEVIK"],"not_rendered":{"defined_names":7},"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 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 alates lahtist H8 ülesanne, õppetest või testide nimed (nt Test 1) ning iga ülesande punktide arv. "]
[null,"4. Sisestage kõigi õppurite iga ülesande või testi tulemused. Veerud „Keskmine“, „Tulemus“, „Hinde täht“ ja „Keskmine hinne“ arvutatakse automaatselt, kuid te saate neid soovi korral muuta. Lisapunktide andmiseks andke ülesandele lihtsalt suurem punktide summa kui ülesande võimaliku punktisumma juures loetletud."]
[null,"Kui soovite prinditavat lehte muuta, kasutage menüü Küljendus käsku „Prindiala“."]
[null,"Hinnete tulemused põhinevad ridades 8 ja 9 määratud punktide koguarvu protsendil. Kohandage iga ülesanne või test soovitud punktide järgi ja seejärel kohandage protsent sobiva hindega vastavaks. Käsitsi muudatuste tegemiseks kirjutage veeru „Tulemus“ lahtrid üle."]
[null,"Sisestage lahtrivahemikku H8 kuni X9 kõik ülesanded, õppetestid, testid ja nende punktisumma."]

{"sheet":"KLASSIPÄEVIK","index":1,"n_rows":24,"n_cols":24,"rows_kept":24,"merged":[[1,1,2,6],[3,1,3,6],[4,1,6,6],[7,4,7,6],[8,4,8,6],[10,4,10,6],[11,4,11,6],[19,1,19,6],[20,1,20,2],[20,3,20,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4]]}
[null,"TEIE ÕPPEASUTUSE NIMI"]
[null,"Õpetaja nimi"]
[{"$nulls":7},"Tulemus",{"$f":"I4*PunktidKokku","v":118},120,126,134,140,{"v":145.6666666666666,"d":"146"},154,160,166,174,180,186,194]
[null,"Klassi/projekti nimi",{"$nulls":5},"%",{"v":0.59,"d":"59%"},{"v":0.6,"d":"60%"},{"v":0.63,"d":"63%"},{"v":0.67,"d":"67%"},{"v":0.7,"d":"70%"},{"v":0.728333333333333,"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%"}]
[null,"Aasta/semester/kvartal",{"$nulls":5},"Hinde täht","F","D–","D","D+","C–","C","C+","B–","B","B+","A–","A","A+"]
[{"$nulls":7},"KESKMINE HINNE",0,0.67,1,1.33,1.67,2,2.33,2.67,3,3.33,3.67,4,4]
[]
[{"$nulls":4},"Ülesande või testi nimi",null,null,"KT1","KT2","1. kv"]
[{"$nulls":4},"Punktisumma kokku",null,null,50,50,100]
[]
[{"$nulls":4},"Ülesannete ja testide koguarv:",null,null,{"$f":"COUNTA(H8:X8)","v":3}]
[{"$nulls":4},"Võimalik punktisumma kokku:",null,null,{"$f":"SUM(H9:X9)","v":200}]
[]
[null,"Õppuri nimi","Õppuri ID","Keskmine","Tulemus","Hinde täht","KESKMINE HINNE","Veerg6","Veerg7","Veerg8","Veerg9","Veerg10","Veerg11","Veerg12","Veerg13","Veerg14","Veerg15","Veerg16","Veerg17","Veerg18","Veerg19","Veerg20","Veerg21","Veerg22"]
[null,"Õppuri number 1",null,{"$f":"IFERROR(IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]])/PunktidKokku),\"\")","v":{"v":0.91,"d":"91.0%"}},{"$f":"IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]))","v":182},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,3),\"\"),0)","v":"A–"},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,4),\"\"),0)","v":3.67},45,45,92]
[null,"Õppuri number 2",null,{"$f":"IFERROR(IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]])/PunktidKokku),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]))","v":200},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,3),\"\"),0)","v":"A+"},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,4),\"\"),0)","v":{"v":4,"d":"4.00"}},50,50,100]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]])/PunktidKokku),\"\")","v":""},{"$f":"IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]))","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]])/PunktidKokku),\"\")","v":""},{"$f":"IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]))","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,4),\"\"),0)","v":""}]
[{"$nulls":3},{"$f":"IFERROR(IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]])/PunktidKokku),\"\")","v":""},{"$f":"IF(COUNT(Hinded[[#This Row],[Veerg6]:[Veerg22]])=0,\"\",SUM(Hinded[[#This Row],[Veerg6]:[Veerg22]]))","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,3),\"\"),0)","v":""},{"$f":"IFERROR(IF(Hinded[[#This Row],[Keskmine]]<>\"\",HLOOKUP(Hinded[[#This Row],[Keskmine]]*PunktidKokku,Hindetabel,4),\"\"),0)","v":""}]
[]
[null,"Klassi kokkuvõte",null,"Keskmine",null,"Hinde täht","KESKMINE HINNE","","","","","","","","","","",""]
[null," Keskmine",null,{"$f":"IFERROR(AVERAGE(Hinded[[#All],[Keskmine]]),0)","v":{"v":0.9550000000000001,"d":"95.5%"}},null,{"$f":"IFERROR(HLOOKUP(D22*PunktidKokku,Hindetabel,3),\"\")","v":"A"},{"$f":"IFERROR(AVERAGE(Hinded[[#All],[KESKMINE HINNE]]),0)","v":{"v":3.835,"d":"3.84"}},"","","","","","","","","","","","","","","","",""]
[null," Kõrgeim tulemus",null,{"$f":"IFERROR(MAX(Hinded[[#All],[Keskmine]]),0)","v":{"v":1,"d":"100.0%"}},null,{"$f":"IFERROR(HLOOKUP(D23*PunktidKokku,Hindetabel,3),\"\")","v":"A+"},{"$f":"IFERROR(MAX(Hinded[[#All],[KESKMINE HINNE]]),0)","v":{"v":4,"d":"4.00"}},"","","","","","","","","","","","","","","","",""]
[null," Madalaim tulemus",null,{"$f":"IFERROR(MIN(Hinded[[#All],[Keskmine]]),0)","v":{"v":0.91,"d":"91.0%"}},null,{"$f":"IFERROR(HLOOKUP(D24*PunktidKokku,Hindetabel,3),\"\")","v":"A–"},{"$f":"IFERROR(MIN(Hinded[[#All],[KESKMINE HINNE]]),0)","v":3.67},"","","","","","","","","","","","","","","","",""]