{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Õpetaja loend"," Loendiandmed"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Õpetaja loend","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[0,1,0,2],[0,4,0,8],[2,9,6,9]]}
[null,"Õpetaja loend",null,"Loendiandmed","Selles lahtris on oleku värvilegend: „Pole alustatud“ on normaallaadiga, „Pooleli“ on R=91 G=133 B=49, „Tähtaeg on täna“ on R=118 G=88 B=0, „Ootel“ on R=109 G=66 B=111, „Lõpule viidud“ on läbikriipsutatud, „Tühistatud“ on R=191 G=191 B=191 ja „Tähtaja ületanud“ on R=191 G=33 B=28."]
[null,"NIMETUS","KATEGOORIA","ALGUSKUUPÄEV","TÄHTAEG","PÄEVI JÄÄNUD","OLEK","MÄRKMED"]
[null,"Puhtad sahtlid","Kontor",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,6)","v":"2018-04-06"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,16)","v":"2018-04-16"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":""},"Lõpule viidud",null,null,"Olekutükeldi asub selles lahtris. Loendi filtreerimiseks oleku alusel valige tükeldist olek. Mitme variandi valimiseks vajutage ja hoidke alla juhtklahvi (CTRL)."]
[null,"Telli kleepsud","Tarbed",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,11)","v":"2018-04-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":""},"Lõpule viidud"]
[null,"Põrandad pestud ja poleeritud","Muu",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()-1),DAY(TODAY())-25)","v":"2018-04-15"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":""},"Lõpule viidud"]
[null,"Nimesildid loodud","Tarbed",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,21)","v":"2018-04-21"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2018-04-01"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":""},"Ootel"]
[null,"Hinda semestri kirjalikud tööd","Hindamised",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,26)","v":"2018-04-26"},{"$f":"TODAY()-5","v":"2018-05-05"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":-5},"Tähtaja ületanud"]
[null,"Meeldetuletusmeil loasedelite kohta","Telefonikõned",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),1)","v":"2018-05-01"},{"$f":"TODAY()","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":""},"Tühistatud"]
[null,"Hinda suulised ettekanded","Kontor",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),7)","v":"2018-05-07"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),17)","v":"2018-05-17"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":7},"Pooleli"]
[null,"Terita pliiatsid","Tarbed",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),11)","v":"2018-05-11"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),10)","v":"2018-05-10"},{"$f":"IFERROR(IF(COUNT(Loend[[#This Row],[ALGUSKUUPÄEV]]:Loend[[#This Row],[TÄHTAEG]])<>2,\"\",IF(OR(Loend[[#This Row],[OLEK]]=\"Lõpule viidud\",Loend[[#This Row],[OLEK]]=\"Tühistatud\",Loend[[#This Row],[OLEK]]=\"Ootel\"),\"\",Loend[[#This Row],[TÄHTAEG]]-TODAY())),\"\")","v":0},"Pooleli"]

{"sheet":" Loendiandmed","index":1,"n_rows":13,"n_cols":3,"rows_kept":13}
[null,"Loendiandmed","Õpetaja loend"]
[null,"Kategooria"]
[null,"Kontor"]
[null,"Tarbed"]
[null,"Asjad, mis tuleb osta"]
[null,"Telefonikõned"]
[null,"Uued ideed"]
[null,"Hindamised"]
[null,"Meeskond"]
[null,"Sekkumised"]
[null,"Arvuti"]
[null,"Isiklik"]
[null,"Muu"]