{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["Tiitel","Sisukord","Andmed","Valemid","Funktsioonid","Arvud","Juhus","Kolmnurk","T_Kolmnurk","Arv_Avald","Loogika_1","Loogika_2","IF_Fun","Palk_Kaup","Fun_IF","Viktoriin","Detailike","Det_Skeem_Val","Kasutajaliides","Materjalid","Värvid","Aeg","Aeg nuputamiseks","Tekst","Isikukood","Valideerimine","Lisad","Nimed","MatFun","TekstFun","LoogFun","AjaFun","VLOOKUP","Valemiredaktor"],"not_rendered":{"charts":1,"images":47,"macros":1,"external_links":0,"defined_names":75,"comments":21,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tiitel","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Andmed ja valemid Excel'is"]

{"sheet":"Sisukord","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Andmete tüübid Excelis"]
[null,"Valemid ja avaldised"]
[null,"Funktsioonid"]
[null,"Arvandmed, -avaldised ja -funktsioonid"]
[null,"Aadressite ja nimede kasutamine valemites. Harjutus \"Kolmnurk\""]
[null,"Harjutus \"Täisnurkne kolmnurk \""]
[null,"Arvavaldised - tehete prioriteedid, funktsioonid"]
[null,"Loogikaandmed, -avaldised ja funktsioonid"]
[null,"Võrdlused ja loogikatehted"]
[null,"Võrdlused ja loogikatehted. Harjutused"]
[null,"IF-funktsioon"]
[null,"Palk & Kauba hind"]
[null,"Funktsioonide tabel"]
[null,"Ajaandmed, -avaldised ja -funktsioonid"]
[null,"Tekstandmed, -avaldised ja funktsioonid"]
[null,"Lisad"]
[null,"Nimede määramine ja kasutamine"]
[null,"Valideerimine"]
[null,"Matemaatikafunktsioonid"]
[null,"Tekstifunktsioonid"]
[null,"Loogikafunktsioonid"]
[null,"Ajafunktsioonid"]
[null,"Otsimine. Funktsioon VLOOKUP"]
[null,"Valemiredaktor MS Equation 3.0"]

{"sheet":"Andmed","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,2,16,3],[16,4,16,5],[16,1,17,1]]}
[null,null,"Arvud","Tekstid","Ajaväärtused","Tõeväärtused",null,"veeb"]
[null,"Märkandmete tüübid"]
[null,"Excelis eristatakse järgmisi andmetüüpe:"]
[null," - arvud ",13,-745.625,{"$f":"C4^13","v":302875106592253},null,{"$f":"10^308","v":1E+308}]
[null," - tekstid","Peeter","Kask",{"$f":"LEFT(C5, 1) & \". \" & D5","v":"P. Kask"}]
[null," - ajaväärtused",{"$f":"NOW()","v":"2019-11-04T14:20:02.940"},{"$f":"TODAY()","v":"2019-11-04"},{"$f":"NOW()","v":43773.597256250003},null,{"$f":"TODAY()","v":"2019-11-04"},{"$f":"G6-100","v":"2019-07-27"}]
[null," - tõeväärtused",true,false,{"$f":"\"mees\" > \"naine\"","v":false}]
[]
[null,null,null,null,null,null,1254.2139999999999]
[]
[]
[]
[]
[]
[]
[null,"Eraldajad sõltuvalt keeleseadetest"]
[null,"Liik","Eesti/Vene",null,"USA/Inglise"]
[null,null,"eraldaja","näide","eraldaja","näide"]
[null,"Arvud","koma","13,05","punkt","13.05"]
[null,"Kuupäevad","punkt","13.05.2002","kaldkriips","05/13/01"]
[null,"Kellaajad","koolon","14:28:15","koolon","14:28:15"]
[null,"Loetelud","semikoolon","a; b; c","koma","a, b, c"]
[null,"NB! Keeleseadeid saab muuta  Windowsis  Control Panel'is"]

{"sheet":"Valemid","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,"Funktsioonid","Arvavaldised","Tekstavaldised"]
[null,null,"Loogikaavaldised","Ajaavaldised","veeb","Ekraanivisioon \"Valemid ja avaldised\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"25*23","v":575}]

{"sheet":"Funktsioonid","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,"Funktsioonid","Arvavaldised","Tekstavaldised"]
[null,null,"Loogikaavaldised","Ajaavaldised","veeb","Ekraanivisioon \"Funktsioonid\""]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SQRT(25)","v":5}]
[null,null,null,null,null,null,{"$f":"1/(113/355)","v":3.1415929203539821}]
[null,null,null,null,null,null,{"$f":"PI()","v":3.1415926535897931}]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-11-04"}]
[null,null,null,null,null,null,{"$f":"NOW()","v":"2019-11-04T14:20:02.940"}]

{"sheet":"Arvud","index":5,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,2,34,8],[35,2,35,8],[28,2,28,8],[29,2,29,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,2,33,8],[0,9,0,12],[27,7,27,8],[0,5,0,7],[25,1,25,8],[26,2,26,4],[3,2,3,8]]}
[null,null,null,null,null,"Matemaatikafunktsioonid",null,null,"veeb","Ekraanivisioon \"Arvandmed ja -avaldised\""]
[null,"Arvandmed, -avaldised ja -funktsioonid"]
[null,"Lahtritesse sisestatavad arvud võivad lisaks numbritele sisaldada ainult järgmisi märke"]
[null,"Märk","Tähendus ja kasutamine",null,null,null,null,null,null,"Näide","Proov"]
[null,"- ja +","Arvu märk. + ei ole vajalik ning seda ei kuvata: -678,54    +137",null,null,null,null,null,null,-13.56]
[null,",","Murdosa eraldaja:     562,75     ,75 => 0,75    75, => 75",null,null,null,null,null,null,0.75]
[null,"e või E","Eksponendi eraldaja: 2,1e6 => 2,1·106  4e-8 => 2,38·10-8        ",null,null,null,null,null,null,2100000]
[null,"( )","Negatiivse arvu alternatiivesitus: (562,75) => -562,75",null,null,null,null,null,null,-5376]
[null,"=","Valemi erijuht: =562,75 => 562,75     =-562,75  => -562,75",null,null,null,null,null,null,{"$f":"562.75","v":562.75}]
[null,"€","Rahavormingu tunnus:  562,75€ ",null,null,null,null,null,null,4940]
[null,"%","Protsenditehe:   18% => 0,18. Eelnev väärtus jagatakse 100-ga ",null,null,null,null,null,null,0.13]
[null,"tühik","Kolmikute eraldaja arvu täisosas:  3 456 562,75",null,null,null,null,null,null,3456562.72]
[null,"/","Tavaline murd: 562 3/4 => 562,75",null,null,null,null,null,null,562.75]
[]
[]
[]
[]
[]
[null,"Aritmeetikatehted ja nende prioriteedid"]
[null,"Prioriteet","Tehe","Kommentaar"]
[null,1,"%","protsent:   18% = 0,18       10%*130 = 13"]
[null,2,"^","astendamine (Alt+94): (x+2)^3      (x+2)^(1/3)"]
[null,3,"* ,  /","korrutamine,  jagamine: a*b    a/b     2*(a+b)/d"]
[null,4," + , -","liitmine, lahutamine:  a+b   a-b  "]
[]
[]
[null,"Vt. lehte","Matemaatikafunktsioonid"]
[null,"Arvude põhivormingud (esitusviisid). Täpsemalt vaata töövihikut",null,null,null,null,null," Vormindamine.xls"]
[null,"Nimetus ja \nkood","Tähendus, arvude esitusviis ",null,null,null,null,null,null,"Näided"]
[null,"General","Üldine. Kehtib, kui lahtrile pole määratud mingit teist vormingud. Väärtus kuvatakse sellisel kujul nagu ta sisestatakse või saadakse valemist.    ",null,null,null,null,null,null,3562.7249999999999]
[null,"Number\n0,00…","Püsikoma. Määrab murdosa pikkuse d. \nArv 562,725: d=2 => 562,73;  d=5 => 562,72500;  d=0 => 563     ",null,null,null,null,null,null,3562.7249999999999]
[null,"Scientific\n 0,00...E+00","Ujukomaarv ehk eksponent:    5,6275E+02 ",null,null,null,null,null,null,3562.7249999999999]
[null,"Currency\n # ##0,00 kr","Raha.  54 562,40 €. Arvu järele lisatakse €, murdosas 2 kohta, kolmikud täisosas eraldatakse tühikutega.",null,null,null,null,null,null,3562.7249999999999]
[null,"Percentage \n0,0...%","Protsent:  18%. Väärtus kuvatakse korrutatuna 100-ga, lisatakse %. \nSäilitatav väärtus ei muutu.  ",null,null,null,null,null,null,0.18]
[null,"Text \n@","Tekst. Ka arvu käsitletakse tekstina. Kui vorming on määratud enne sisestamist, säilitakse kõik märgid. ",null,null,null,null,null,null,"3562,725"]
[null,"Custom \n","Kasutajavorming. Luuakse olemasolevate vormingute alusel. Näiteks vorming 0,00” cm” kuvab arvu järel sümbolid  cm.",null,null,null,null,null,null,37.58]

{"sheet":"Juhus","index":6,"n_rows":64,"n_cols":13,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Juhuslikud arvud. Funktsioon RAND()"]
[]
[]
[]
[]
[]
[]
[]
[null,"mini",1,"maxi",64]
[null,null,null,null,null,null,null,null,null,null,null,null,"keskmine"]
[null,6,7,10,27,31,32,38,53,61,63,null,{"$f":"IF(INDEX(numbrid, 10)=\"\", \"\", AVERAGE(numbrid))","v":32.799999999999997}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"a",1,"b",100]

{"sheet":"Kolmnurk","index":7,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,9,0,10],[1,9,1,10],[2,9,2,10]]}
[null,null,null,null,"Valemid","Funktsioonid",null,"Nimed","veeb","Ekraanivisioonid"]
[null,"Kolmnurga ja selle siseringi pindalad",null,null,null,null,null,null,null,"kolmnurk, aadressid"]
[null,null,null,null,null,null,null,null,null,"kolmnurk, nimed"]
[null,"1) Kolmnurga karakteristikud: aadressid"]
[]
[null,"a",3]
[null,"b",4]
[null,"c",5]
[null,"S",{"$f":"SQRT(C11*(C11-C6)*(C11-C7)*(C11-C8))","v":6}]
[null,"Sr",{"$f":"PI()*C12^2","v":3.1415926535897931}]
[null,"p",{"$f":"(C6+C7+C8)/2","v":6}]
[null,"r",{"$f":"C9/C11","v":1}]
[]
[]
[null,"2) Kolmnurga karakteristikud: nimed",null,null,null,null,null,null,null,"Abisuurustena tuleks leida pool kolmnurga ümbermõõdust ja siseringi raadius (vt. valemeid). NB! Valemite sisestamise järjekord ei ole oluline. Valemid arvutatakse ümber iga kord, kui mingi lahtri väärtus muutub (kui Exceli seadetes on nii määratud)."]
[]
[null,"a",3,null,"   Nime määramine üksikule lahtrile"]
[null,"b",4]
[null,"c",5,null,"   Nimede määramine korraga mitmele lahtrile"]
[null,"S",{"$f":"SQRT(p*(p-a)*(p-b)*(p-c_))","v":6}]
[null,"Sr",{"$f":"PI()*r_^2","v":3.1415926535897931}]
[null,"p",{"$f":"(a+b+c_)/2","v":6}]
[null,"r",{"$f":"S/p","v":1}]

{"sheet":"T_Kolmnurk","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Valemid"]
[null,"Kolmnurga karakteristikud"]
[]
[null,"a",5,"cm"]
[null,"b",3,"cm"]
[null,"S",{"$f":"0.5*a*b","v":7.5}]
[null,"Sr",{"$f":"PI()*r_^2","v":3.6951174678240126}]
[null,"c",{"$f":"SQRT(a^2+b^2)","v":5.8309518948453007}]
[null,"p",{"$f":"(a+b+c_)","v":13.830951894845301}]
[null,"r",{"$f":"2*S/p","v":1.0845240525773499}]

{"sheet":"Arv_Avald","index":9,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,5,0,7]]}
[null,null,null,null,null,"Matemaatikafunktsioonid"]
[null,"Arvavaldised ja -funktsioonid"]
[null,null,null,"a","b","c","x","y"]
[null,null,null,6,-2,5,5,3]
[]
[null,"Nr","Exceli valem","Valem",null,null,null,"Vastus"]
[null,1,{"$f":"a*b/c_","v":-2.4},null,null,null,null,{"$f":"a*b/c_","v":-2.4}]
[null,2,{"$f":"a/(b*c_)","v":-0.6},null,null,null,null,{"$f":"a/(b*c_)","v":-0.6}]
[null,3,null,null,null,null,null,{"$f":"(a+x)/(b+y)","v":11}]
[null,4,null,null,null,null,null,{"$f":"(a+x)/(b*y)","v":-1.8333333333333333}]
[null,5,{"$f":"(PI() * (a+x)^2)/(b^2*y^3)","v":3.5197473248552313},null,null,null,null,{"$f":"PI()*(a+x)^2/(b^2*y^3)","v":3.5197473248552313}]
[null,6,null,null,null,null,null,{"$f":"SQRT(x^2+y^2)","v":5.8309518948453007}]
[null,7,null,null,null,null,null,{"$f":"SQRT(b^2+4*a*c_)/(3*b)","v":-1.8559214542766738}]
[null,8,{"$f":"(x^2 + y^2)^ (1/3)","v":3.2396118012774835},null,null,null,null,{"$f":"(x^2+y^2)^(1/3)","v":3.2396118012774835}]
[null,9,null,null,null,null,null,{"$f":"((y+c_^2)/(a+b))^(3/4)","v":4.3035170706588497}]
[null,10,null,null,null,null,null,{"$f":"LOG(ABS(a^3+(x^2+2.76)^(1/3)))","v":2.34049941564004}]
[null,11,{"$f":"(2*EXP(x)+EXP(-2*x))/(a^2+b^2)","v":7.4206590901270744},null,null,null,null,{"$f":"(2*EXP(x)+EXP(-2*x))/(a^2+b^2)","v":7.4206590901270744}]
[null,12,{"$f":"SIN(2*x)+COS(x ^2) - SIN(x)^2","v":-0.47235406356412235},null,null,null,null,{"$f":"SIN(2*x)+COS(x^2)-SIN(x)^2","v":-0.47235406356412235}]
[null,13,null,null,null,null,null,{"$f":"2*SIN((a+b)/2)^2*COS((a+b)/2)^3","v":-0.11917405383352482}]
[null,14]
[null,15]
[null,16]

{"sheet":"Loogika_1","index":10,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[10,4,10,5],[11,4,11,5],[0,4,0,7],[12,8,13,12]]}
[null,null,null,"veeb","Ekraanivisioon \"Loogikaandmed ja -avaldised\""]
[null,"Loogikaandmed (tõeväärtused), -avaldised ja funktsioonid",null,null,null,null,null,null,5,5,{"$f":"I2=J2","v":true}]
[]
[null,"Väärtused ja tehted",null,null,"Võrdlused"]
[]
[null,"Näited. Arvude võrdlemine ",null,null,null,null,null,null,"Näited. Loogiline ja (and), või (or) ja eitus"]
[null,null,null,null,{"$f":"IF(a=b,\"Võrdub!\", \"Ei võrdu\")","v":"Ei võrdu"}]
[null,"a","b","x","a = b","a > b","a <= b",null,"avaldis1","avaldis2","AND (avaldis1; avaldis2)","OR (avaldis1; avaldis2)","NOT (avaldis1)"]
[null,3,12,2,{"$f":" a = b","v":false},{"$f":" a > b","v":false},{"$f":" a <= b","v":true},null,true,true,{"$f":"AND(I9,J9)","v":true},{"$f":"OR(I9,J9)","v":true},{"$f":"NOT(I9)","v":false}]
[null,null,null,null,null,null,null,null,true,false,{"$f":"AND(I10,J10)","v":false},{"$f":"OR(I10,J10)","v":true},{"$f":"NOT(I10)","v":false}]
[null,"a <= x <= b","a <= x","(a <= x) <= b","AND( a <= x; x <= b)",null,null,null,false,true,false,true,true]
[null,{"$f":" a <= x <= b","v":false},{"$f":" a <= x","v":false},{"$f":"C12 <= b","v":false},{"$f":"AND( x>=a, x <= b)","v":false},null,null,null,false,false,false,false,true]
[null,null,null,null,{"$f":"(x>=a)*(x<=b)","v":0},null,null,null,"avaldis1, avaldis2 väärtused saadakse üldjuhul võrdlusoperatsioonide või muude loogikatehete tulemusel"]
[]
[null,"Näited. Tekstide võrdlemine"]
[]
[null,"T_1","T_2","T_1 = T_2","T_1 > T_2",null,null,"A"]
[null,"B","A",{"$f":" T_1 = T_2","v":false},{"$f":" T_1 > T_2","v":true},null,null,"B"]
["kood",{"$f":"CODE(T_1)","v":66},{"$f":"CODE(T_2)","v":65},null,null,null,null,"C"]
[null,null,null,null,null,null,null,"a"]
[null,"A","B","AND","OR","NOT A",null,"b"]
[null,true,true,true,true,false,null,"c"]
[null,true,false,false,true,false,null,"k"]
[null,false,false,false,false,true,null,"m"]
[null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"z"]
[null,null,null,null,null,null,null,"Malle"]
[null,null,null,null,null,null,null,"Juku"]
[null,null,null,null,null,null,null,"Kalle"]
[null,null,null,null,null,null,null,"Kalju"]

{"sheet":"Loogika_2","index":11,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[11,1,11,4],[5,1,5,4],[7,1,7,4],[0,5,0,9],[4,1,4,4],[8,1,8,4],[6,1,6,4],[9,1,9,4],[10,1,10,4]]}
[null,null,null,"veeb",null,"Ekraanivisioon \"Loogikaandmed ja -avaldised\""]
[null,"Loogikaandmed, -avaldised ja funktsioonid. Harjutused"]
[]
[null,"Testike ehk viktoriinike"]
[null,"Küsimus",null,null,null,"Vastus","Hinnang"]
[null,"Mitu veergu on Excel 2013 töölehel?",null,null,null,null,{"$f":"F6=16384","v":false}]
[null,"Mitu rida on Excel 2013 töölehel?",null,null,null,null,{"$f":"F7=H7","v":false},1048576]
[null,"Mis aastal loodi esimene personaalarvuti?",null,null,null,null,null,1976]
[null,"Mis firmas see loodi?",null,null,null,null,null,"Apple",null,"16 384\n"]
[null,"Mis aastal loodi esimene mikroprotsessor?",null,null,null,null,null,1971]
[null,"Mis firmas see loodi?",null,null,null,null,null,"Intel"]
[]
[]
[]
[]
[null,"AND ja OR-funktsioonide kasutamine"]
[null,null,null,null,"Koostada valem, mis on tõene, kui "]
[null,"a",null,null,"kui 0 < a <= 100"]
[null,"b",null,null,"kui c <= b <= a"]
[null,"c",null,null,"kui c < b või c>= a"]
[null,"täht",null,null,"kui täht on a, b või c"]
[null,null,null,null,"kui kehtib kolmnurga külgede (a, b, c) tingimus"]

{"sheet":"IF_Fun","index":12,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,4,34,8],[9,1,9,4],[10,1,10,4],[11,1,11,4],[0,4,0,8],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[null,null,null,"veeb","Ekraanivisioon \"Loogikaandmed ja -avaldised\""]
[]
[null,"IF-funktsioon"]
[]
[null,"Jälle viktoriinike"]
[null,"Küsimus",null,null,null,"Vastus","Hinnang"]
[null,"Mitu veergu on Excel 2013 töölehel?",null,null,null,16584,{"$f":"IF(F7=16384, \"Õige!\", \"Vale!\")","v":"Vale!"}]
[null,"Mis aastal loodi esimene personaalarvuti?",null,null,null,1976,{"$f":"IF(F8 = H8, \"Õige!\", \"Vale!\")","v":"Õige!"},1976]
[null,"Mis firmas see loodi?",null,null,null,"Apple",{"$f":"IF(F9=H9,1,0)","v":1},"Apple"]
[null,"Mis aastal loodi esimene mikroprotsessor?",null,null,null,null,{"$f":"IF(F10=H10,2,IF(ABS(F10-H10)<=2,1,0))","v":0},1971]
[null,"Mis firmas see loodi?",null,null,null,"Intel",{"$f":"IF(F11 = \"\", \"\", IF(F11 = H11, 2, 0))","v":2},"Intel"]
[null,"Mis on kõikide leiutiste ja pahede alus?",null,null,null,null,{"$f":"IF(F12 = \"\", \"\", IF(F12 = H12, 2, 0))","v":""}]
[]
[]
[null,"Keele test"]
[null,null,"Punkte:",{"$f":"SUM(D18:D25)","v":6}]
[null,"eesti","inglise","hinnang"]
[null,"koer","dog",{"$f":"IF(C18 = \"\", \"\", IF(C18 = E18, 1, 0))","v":1},"dog"]
[null,"kass","cat",{"$f":"IF(C19 = \"\", \"\", IF(C19 = E19, 1, 0))","v":1},"cat"]
[null,"laud","table",1,"table"]
[null,"lahter","cell",1,"cell"]
[null,"arv","number",1,"number"]
[null,"kui","if",1,"if"]
[null,null,null,""]
[null,null,null,""]
[]
[null,"Andmete kontroll"]
[null,"Tähis","Väärtus","Kontroll"]
[null,"a",null,{"$f":"IF(OR(a=\"\",AND(a>0,a<=100)),\"\", \"Viga!\")","v":""},"0 < a <= 100"]
[null,"b",null,null,"c <= b <= a"]
[null,"c",null,null,"c < b või c>= a"]
[null,"täht",null,null,"Täht on k, p või t"]
[null,null,null,{"$f":"IF(OR(a=\"\", b=\"\", c_=\"\"), \"\", IF(AND(a+b>c_, a+c_>b, b+c_>a),\"\", \"Kolnurka ei ole!\"))","v":""},"Veateade kuvatakse, kui lahtrid a, b  ja c ei ole tühjad, pole neg. arvud ja kolmnurga tingimus ei kehti (ei saa moodustada kolmnurka küljepikkustega a, b jac)."]

{"sheet":"Palk_Kaup","index":13,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"IF-funktsioon",null,"veeb"]
[]
[null,"Tunnitasuliste kuupalk ja tulumaks"]
[]
[null,"maksuvaba",144,"protsent",0.21]
[]
[null,"tariif","tunde","palk","maks","saada"]
[null,7,130]
[]
[]
[]
[null,"Kauba hind sõltuvalt kogusest"]

{"sheet":"Fun_IF","index":14,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,null,null,"IF-funktsioon",null,null,"veeb"]
[]
[null,"Funktsioonide väärtused"]
[]
[null,"algus",-5,"samm",1]
[]
[null,"x","y","z"]
[null,{"$f":"algus","v":-5}]
[null,{"$f":"B8+samm","v":-4}]
[null,-3]
[null,-2]
[null,-1]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"Viktoriin","index":15,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Viktoriinike"]
[null,null,"Punkte"]
[]
[null,"Küsimus","Vastus","Hinnang","O_vastus","Lubatud viga"]
[null,"Pekingi olümpiavõitja kettaheites (ees ja perenimi)?",null,null,"Gerd Kanter"]
[null,"Mitu sentimeetrit on ühes tollis?",null,null,2.54,0.05]
[null,"Mis aastal oli esimene inimene Kuul? Täpne vastus 2p, ±2 aastat - 1 p   ",null,null,1969,2]
[null,"Kas piaal on: A - kala, B - jooginõu, C - lind, D - ehiusdetail?","D",null,"B"]
[null,"Mis aastal toimus Waterloo lahing: A-1915, B-1795, C-1815, D-1940?","B",null,"C"]

{"sheet":"Detailike","index":16,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,6,0,7],[0,4,0,5]]}
[null,null,null,null,"Materjalid",null,"Värvid"]
[]
[null,"Minirakendus \"Detailike\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analüüs"]
[null,"Algandmed:",null,"b, h, d, L - mõõtmed (cm), materjali mark, värvi mark"]
[null,"Tulemid:",null,"m_kogus - materjali kogus (m3), v_kogus - värvi kogus (liiter)"]
[null,null,null,"m_maks - materjali maksumus, v_maks - värvi maksumus"]
[null,null,null,"maks_kokku - maksumus kokku"]
[null,"Vaheandmed:",null,"V - ruumala (m3) , S -  täispindala (m2)"]
[null,null,null,"A - ristlõike pindala (cm2), P - ristlõike ümbermõõt (cm)"]
[null,null,null,"m_hind - materjali hind, v_hind - värvi hind, v_kulu - värvi kulu m2 tabelitest"]

{"sheet":"Det_Skeem_Val","index":17,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,6,0,7]]}
[null,null,null,null,"Joonestamine",null,"Valemiredaktor"]
[]
[null,"Minirakendus \"Detailike\". Skeem ja valemid"]

{"sheet":"Kasutajaliides","index":18,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Materjalid","Värvid","Valideerimine","Otsimine"]
[null,"Detail. Disain & realisatsioon"]
[]
[null,"Detaili geomeetria"]
[]
[null,"L",700,"cm"]
[null,"h",90,"cm"]
[null,"b",70,"cm"]
[null,"d",30,"cm"]
[null,"ruum",null,"m3"]
[null,"pind",null,"m2"]
[null,"A",null,"cm2"]
[null,"P",null,"cm"]
[]
[null,"Materjali ja värvi koguse ning detaili  maksumuse kalkulatsioon"]
[]
[null,null,"mark","hind","kogus","maksumus","Muud kulud"]
[null,"Materjal",null,null,null,null,0.5]
[null,"Värv"]
[null,null,null,null,"Materjal ja värv kokku"]
[null,null,null,null,"Maksumus kokku"]

{"sheet":"Materjalid","index":19,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Rakendus Detail.",null," Materjalid"]
[]
[null,"Materjali margid ja hinnad"]
[]
[null,"Mark","Hind €/m3"]
[null,"Ma_11",36]
[null,"Ma_12",35]
[null,"Ma_05",35]
[null,"Ma_06",33]
[null,"Ma_08",32]
[null,"Ma_07",30]
[null,"Ma_09",29]
[null,"Ma_10",29]
[null,"Ma_03",23]
[null,"Ma_13",23]
[null,"Ma_04",21]
[null,"Ma_18",21]
[null,"Ma_02",17]

{"sheet":"Värvid","index":20,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Rakendus Detail.",null,"Värvid"]
[]
[null,"Värvide margid, kulu ja hinnad"]
[]
[null,"Mark","Kulu L/m2","Hind  €/L"]
[null,"Sv_01",0.43,4.2]
[null,"Sv_02",0.3,3.16]
[null,"Sv_03",0.35,3.2]
[null,"Sv_04",0.35,1.9]
[null,"Sv_05",0.4,3.5]
[null,"Sv_06",0.35,2.9]
[null,"Sv_07",0.45,3.5]
[null,"Sv_08",0.3,4.12]
[null,"Sv_09",0.35,3.3]
[null,"Sv_10",0.4,2.6]
[null,"Sv_11",0.3,4.0999999999999996]
[null,"Sv_12",0.42,2.1800000000000002]
[null,"Sv_13",0.5,2.2000000000000002]

{"sheet":"Aeg","index":21,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,3,0,4],[6,1,6,3],[6,4,6,6],[8,1,8,3],[8,4,8,6],[0,6,0,7]]}
[null,null,null,"Ajafunktsioonid",null,"veeb","ekraanivisioon"]
[]
[null,"Ajaandmed, -avaldised ja -funktsioonid"]
[]
[null,"Ajaväärtuste esitusviisid"]
[]
[null,{"$f":"NOW()","v":"2019-11-04T14:20:02.940"},null,null,{"$f":"NOW()","v":43773.597256250003}]
[]
[null,{"$f":"TODAY()","v":"2019-11-04"},null,null,{"$f":"TODAY()","v":43773}]
[]
[null,"Operatsioonid kuupäevadega ja kellaaegadega",null,null,null,null,null,null,"Mõnede ajafunktsioonide kasutamine"]
[]
[null,"Palju on jäänud aega etteantud kuupäevani? ",null,null,null,null,null,null,"täna",{"$f":"TODAY()","v":"2019-11-04"},"=TODAY()"]
[null,null,null,null,null,null,null,null,"praegu",{"$f":"NOW()","v":"2019-11-04T14:20:02.940"},"=NOW()"]
[null,"ek",{"$f":"DATE(YEAR(TODAY())+1,1,1)","v":"2020-01-01"},"etteantud kuupäev",null,null,null,null,"aasta",{"$f":"YEAR(täna)","v":2019},"=YEAR(täna)"]
[null,"v",{"$f":"ek-NOW()","v":57.402743749997171},"etteantud kuupäeva ja praeguse hetke vahe",null,null,null,null,"kuu",{"$f":"MONTH(täna)","v":11},"=MONTH(täna)"]
[null,"p",{"$f":"INT(v)","v":57},"päeva",null,null,null,null,"päev",{"$f":"DAY(täna)","v":4},"=DAY(täna)"]
[null,"t",{"$f":"HOUR(v)","v":9},"tundi",null,null,null,null,"nädalapäeva nr",{"$f":"WEEKDAY(täna,2)","v":1}," =WEEKDAY(täna; 2)"]
[null,"m",{"$f":"MINUTE(v)","v":39},"minutit",null,null,null,null,"nädala nr",{"$f":"WEEKNUM(täna,2)","v":45}," =WEEKNUM(täna; 2)"]
[null,"s",{"$f":"SECOND(v)","v":57},"sekundit",null,null,null,null,"tunnid",{"$f":"HOUR(praegu)","v":14},"=HOUR(praegu)"]
[null,"as",{"$f":"86400*v","v":4959597.0599997556},"aeg sekundites",null,null,null,null,"minutid",{"$f":"MINUTE(praegu)","v":20},"=MINUTE(praegu)"]
[null,null,null,null,null,null,null,null,"sekundid",{"$f":"SECOND(praegu)","v":3},"=SECOND(praegu)"]
[null,null,null,null,null,null,null,null,"kuupäev",{"$f":"DATE(J15,J16,J17)","v":"2019-11-04"},"=DATE(J15;J16;J17)"]
[null,"Millal on põhjust täiendavaks juubelipeoks?",null,null,null,null,null,null,"kellaaeg",{"$f":"TIME(J20,J21,J22)","v":"14:20:03"},"=TIME(J18;J19;J20)"]
[]
[null,"sk","1991-10-26","Sünnikuupäev"]
[null,"evp",10000,"Etteantud vanus päevades (kena ümmargune arv)"]
[null,"vp",null,"Vanus päevades praegu"]
[null,"va",null,"Vanus aastates praegu"]
[null,"jk",null,"Juubeli kuupäev (suur ümmargune elatud päevade arv)"]
[null,"vaj",null,"Vanus aastates selle juubeli ajal"]

{"sheet":"Aeg nuputamiseks","index":22,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Aasta","Jõulud","1995-03-05","1. advent","Andresepäev","A nädalapäev","Pühapäev enne andresepäeva"]
[null,1980]
[null,1985]
[null,1990]
[null,1995]
[null,2000]
[null,2005]
[null,2010]
[null,2015]
[null,2020]
[]
[null,null,null,null,null,"n"]
[null,null,null,null,null,8]
[null,"Kuupäevad","Selle kuu \n5. päev","Kuupäev kahe nädala pärast","järgmise kuu \n16. päev","järgmise kuu \nn päev"]
[null,"2010-09-02"]
[null,"1987-09-06"]
[null,"2000-09-25"]
[null,"2013-07-02"]
[null,"1965-01-07"]
[]
[]
[]
[]
[null,null,"1. kodutöö","2. kodutöö","3. kodutöö"]
[null,"Tähtajad","2015-09-30","2015-10-30","2015-11-13"]
[]
[]
[null,null,"Esitatud 1","Esitatud 2","Esitamisprognoos"]
[null,"Aivar",{"$f":"C$29-7+INT(RAND()*14)","v":"2015-09-25"},{"$f":"D$29-7+INT(RAND()*14)","v":"2015-10-25"}]
[null,"Kaspar",{"$f":"C$29-7+INT(RAND()*14)","v":"2015-09-29"},{"$f":"D$29-7+INT(RAND()*14)","v":"2015-10-28"}]
[null,"Britta",{"$f":"C$29-7+INT(RAND()*14)","v":"2015-09-23"},"2015-10-27"]
[null,"Vahur","2015-10-01","2015-10-30"]
[null,"Teet","2015-09-24","2015-10-23"]
[null,"Joosep","2015-09-24","2015-11-04"]
[null,"Kusti","2015-10-06","2015-11-03"]
[null,"Teele","2015-09-26","2015-11-03"]

{"sheet":"Tekst","index":23,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,2,0,3],[3,1,3,6],[4,1,4,6],[0,5,0,6]]}
[null,null,"Tekstifunktsioonid",null,"veeb","ekraanivisioon"]
[]
[null,"Tekstandmed, -avaldised ja funktsioonid"]
[null,"Tekst võib kujutada endast suvalist märkide jada. Kui sisend ei ole tõlgendav valemina, arvuna või ajaväärtusena (kuupäevana ja/või kellaajana), siis käsitleb Excel seda tekstiks."]
[null,"Tekst joondatakse vaikimisi lahtri vasakusse serva. Teksti pikkus ei ole praktiliselt piiratud (kuni 32 000 märki!). Tekst lahtris võib paikneda mitmel real. Seda saab määrata korraldusega:   Format/Cells/Alignment/Wrap text\nÜlemineku uuele reale kindlas kohas lahtri sees saab määrata klahvikorraldusega Alt+Enter. "]
[]
[null,"Tekstivalemid ja -avaldised"]
[]
[null,"Mõned valemid, mis on seotud tekstide ühendamise ja eraldamisega"]
[null,"Vt. kommentaare tabeli päises. Esimeses reas on tulemuste näited."]
[]
[null,"Perenimi","Eesnimi","Eesnimi ja \nperenimi","Eesnime esitäht ja perenimi","Nime pikkus","Perenimi suurtähtedega"]
[null,"Kask","Kalle","Kalle Kask","K. Kask",10,"KASK"," Tulemite soovitav kuju"]
[null,"Saar","Tiina"]
[null,"Kasemets","Marge"]
[null,"Männik","Rein"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Nimi","Eesnimi","Perenimi","Tühiku asukoht","Ees- ja Perenime saab eraldada ka korraldusega Andmed / Tekst veergudesse"]
[null,null,null,"Kalle kask","Kalle","Kask",6]
[null,null,null,"Tiina Saar"]
[null,null,null,"Marge Kasemets"]
[null,null,null,"Rein Männik"]

{"sheet":"Isikukood","index":24,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Isikukoodi dekodeerimine",null,null,"ekraanivisioon"]
[]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus"]
[null,37807240251,"Karl","Kask","mees","1978-07-24",20]
[null,48011250013,"Karin","Kask"]
[null,37503120543,"Lembit","Laisk"]
[null,41012240021,"Tiina","Usin"]
[null,51009060302,"Kevin","Raud"]
[null,60204050936,"Mia","Õunapuu"]

{"sheet":"Valideerimine","index":25,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valideerimine - sisendandmete kontroll"]
[]
[null,"Määrata lahtritele näidatud valideerimise tingimused"]
[null,"Töötajate arv",13,"täisarv 1 kuni 100"]
[null,"pikkus",45.6,"reaalarv vahemikus 20 kuni 200"]
[null,"laius",72.400000000000006,"reaalarv vahemikus 20 kuni 200"]
[]
[]
[null,"Valideerimine - väärtuse valimine loendist",null,null,null,null,"Liigid",null,"Päevad"]
[null,null,null,null,null,null,"haab",null,"esmaspäev"]
[null,"sugu","naine","naine või mees",null,null,"kask",null,"teisipäev"]
[null,"puu liik",null,"kasutada kõrvalolevat loendit",null,null,"kuusk",null,"kolmapäev"]
[null,"nädalapäev",null,"loendist nimega päevad",null,null,"lepp",null,"neljapäev"]
[null,null,null,null,null,null,"mänd",null,"reede"]
[null,null,null,null,null,null,"paju",null,"laupäev"]
[null,null,null,null,null,null,"saar",null,"pühapäev"]
[null,null,null,null,null,null,"tamm"]
[null,null,null,null,null,null,"vaher"]

{"sheet":"Lisad","index":26,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Lisad"]

{"sheet":"Nimed","index":27,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Nimede määramine ja kasutamine"]
[]
[null,"Nimede esitusreeglid"]
[]
[null,"Globaalsed ja lokaalsed nimed",null,null,"Nimede paigutamine valemitesse"]
[]
[null,"Nime määramine lahtrile või lahtriplokile"]
[]
[null,"Nimekasti abil",null,null,null,"Hinnakiri"]
[null,"Pikkus","Laius","Pindala",null,"Liik","Hind"]
[null,5,4,null,null,"haab",675]
[null,null,null,null,null,"kask",790]
[null,null,null,null,null,"kuusk",935]
[null,null,null,null,null,"lepp",640]
[null,null,null,null,null,"mänd",850]
[null,null,null,null,null,"tamm",1200]
[]
[null,"Korraldustega  Define Name"]
[null,null,null,"vanus"]
[]
[]
[null,"Korralduse Name Manager kasutamine"]
[null,"Proovige"]
[]
[]
[]
[]
[]
[]
[null,"Nimede loomine korraldusega Create from Selection"]
[]
[null,"Silindri ruumala ja täispindala",null,null,"Kauba maksumus"]
[null,"r",3,null,"Liik","Hind","Kogus","Maksumus"]
[null,"h",10,null,{"$f":"F14","v":"kask"},{"$f":"G14","v":790},36]
[null,"V"]
[null,"S"]

{"sheet":"MatFun","index":28,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Matemaatikafunktsioonid"]
[null,"Argumendid: a - arvavaldis(erijuhul konstant või lahtriviit), p - lahtriplokk, ap - arvavaldis või lahtriplokk"]
[null,"Nurksulgudes näidatud argumendid ei ole kohustuslikud"]
[null,"ABS(a)","Absoluutväärus"]
[null,"ACOS(a)","Arkuskoosinus radiaanides. -1<= a <=1 "]
[null,"ASIN(a)","Arkussiinus radiaanides. -1<= a <=1 "]
[null,"ATAN(a)","Arkustangens radiaanides. "]
[null,"COS(a)","Koosinus. Argument radiaanides"]
[null,"DEGREES(a)","Teisendab radiaanid kraadideks"]
[null,"EXP(a)","Eksponent: e^a, kus e=2,718… on naturaallogaritmi alus"]
[null,"FACT(a)","Faktorial: a!.  0<= a <= 170"]
[null,"INT(a)","Ümardab arvu lähima täisarvuni, mis on väiksem kui a"]
[null,"LN(a)","Naturaallogaritm (alus e=2,718…). a>0"]
[null,"LOG(a [; alus ])","Logaritm antud alusega, kui puudub, siis 10. a>0, alus>0"]
[null,"LOG10(a)","Logaritm alusega 10. a>0"]
[null,"MDETERM(p)","Lahtriplokis asuva maatriksi deteminant"]
[null,"MINVERSE(p)","Lahtriplokis asuva maatriksi pöördmaatriks."]
[null,"MMULT(p1;lp2)","Lahhtriplokkides lp1 ja lp2 asuvate maatriksite korrutis"]
[null,"MOD(a;b)","Jagatise a/b jääk"]
[null,"MROUND(a;täpsus)","Ümardab arvu etteantud täpsusega"]
[null,"PI()","Pii = 3,141592654"]
[null,"RADIANS(a)","Teisendab graadid radiaanideks"]
[null,"RAND()","Juhuslik arv vahemikus 0 kuni 1"]
[null,"ROUND(a;n)","Ümardab a väärtuse n koma- või kümnendkohani"]
[null,"SIGN(a)","Arvu märk: 1 - + (positiivne), -1(negatiivne); 0 - null"]
[null,"SIN(a)","Siinus. Argument radiaanides"]
[null,"SQRT(a)","Ruutjuur. a>=0"]
[null,"SUM(ap1 [ ; ap2 ] …)","Argumentide väärtuste summa"]
[null,"TAN(a)","Tangens. Argument radiaanides"]
[null,"TRUNC(a)","Arvu täisosa"]

{"sheet":"TekstFun","index":29,"n_rows":74,"n_cols":13,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,3,0,6],[0,7,0,9],[0,10,0,12],[2,1,3,3],[6,4,6,10],[2,4,3,10],[4,1,5,3],[4,4,5,10],[12,1,12,3],[7,4,7,10],[8,4,8,10],[10,4,10,10],[11,4,11,10],[12,4,12,10],[9,1,9,3],[10,1,10,3],[11,1,11,3],[7,1,7,3],[8,1,8,3],[9,4,9,10]]}
[null,null,null,"Matemaatikafunktsioonid",null,null,null,"Ajafunktsioonid",null,null,"Loogikafunktsioonid"]
[null,"Tekstifunktsioonid"]
[null,"CHAR(arv)",null,null,"Tagastab avaldise väärtusele vastava ASCII märgi. \n1<=arvav<=255. CHAR(65) = A",null,null,null,null,null,null,"kood","märk"]
[null,null,null,null,null,null,null,null,null,null,null,65,{"$f":"CHAR(L4)","v":"A"}]
[null,"CODE(tekst)",null,null,"Tagastab tekstavaldise esimesele märgile\n vastava ASCII koodi. CODE(\"A\") = 65",null,null,null,null,null,null,"märk","kood"]
[null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"CODE(L6)","v":65}]
[null,null,null,null,"Seda teksti   kasutatakse     järgmistes näidetes  "]
[null,"FIND(tekst1;tekst2 [ ; m] )",null,null,"Leiab positsiooni numbri, millest alatest tekst1 sisaldub \ntekst2-s. Otsimimist alustatakse positsioonist m",null,null,null,null,null,null,{"$f":"FIND(\"tekst\",E7)","v":6},{"$f":"FIND(\" \",E7)","v":5}]
[null,"LEFT(tekst [ ; n ] )",null,null,"Eraldab tekstist n vasakpoolset märki, vaikimisi 1.",null,null,null,null,null,null,{"$f":"LEFT(E7,4)","v":"Seda"},{"$f":"LEFT(E7,M8-1)","v":"Seda"}]
[null,"LEN(tekst)",null,null,"Leiab teksti pikkuse (märkide arvu tekstis)",null,null,null,null,null,null,{"$f":"LEN(E7)","v":51},{"$f":"LEN(TRIM(E7))","v":43}]
[null,"MID(tekst;m;n)",null,null,"Eraldab tekstist n märki alates märgist numbriga m",null,null,null,null,null,null,{"$f":"MID(E7,6,5)","v":"tekst"},{"$f":"MID(E7,L8,5)","v":"tekst"}]
[null,"RIGHT(tekst;[ n ])",null,null,"Eraldab tekstist n parempoolset märki, vaikimisi 1",null,null,null,null,null,null,{"$f":"RIGHT(E7,8)","v":"idetes  "},{"$f":"RIGHT(TRIM(E7),8)","v":"näidetes"}]
[null,"TRIM(tekst)",null,null,"Eemaldab tekstist tühikud, jättes sõnade vahele ühe tühiku",null,null,null,null,null,null,{"$f":"TRIM(E7)","v":"Seda teksti kasutatakse järgmistes näidetes"}]
[]
[null,"Tekstid salvestatakse ASCII koodis, kus igale märgile vastab kindel arv (8-bittine kood)"]
[null,"Tabelis on funktsiooni CHAR abil toodud igale koodile (0…255) vastav kood"]
[null,"Kood","Märk","Kood","Märk","Kood","Märk","Kood","Märk","Kood","Märk"]
[null,0,null,51,{"$f":"CHAR(D18)","v":"3"},101,{"$f":"CHAR(F18)","v":"e"},151,{"$f":"CHAR(H18)","v":"—"},201,{"$f":"CHAR(J18)","v":"É"}]
[null,1,{"$f":"CHAR(B19)","v":"\u0001"},52,{"$f":"CHAR(D19)","v":"4"},102,{"$f":"CHAR(F19)","v":"f"},152,{"$f":"CHAR(H19)","v":"\u0098"},202,{"$f":"CHAR(J19)","v":"Ź"}]
[null,2,"\u0002",53,"5",103,"g",153,"™",203,"Ė"]
[null,3,"\u0003",54,"6",104,"h",154,"\u009a",204,"Ģ"]
[null,4,"\u0004",55,"7",105,"i",155,"›",205,"Ķ"]
[null,5,"\u0005",56,"8",106,"j",156,"\u009c",206,"Ī"]
[null,6,"\u0006",57,"9",107,"k",157,"¯",207,"Ļ"]
[null,7,"\u0007",58,":",108,"l",158,"˛",208,"Š"]
[null,8,"\b",59,";",109,"m",159,"\u009f",209,"Ń"]
[null,9,"\t",60,"<",110,"n",160," ",210,"Ņ"]
[null,10,"\n",61,"=",111,"o",161,"",211,"Ó"]
[null,11,"\u000b",62,">",112,"p",162,"¢",212,"Ō"]
[null,12,"\f",63,"?",113,"q",163,"£",213,"Õ"]
[null,13,"\r",64,"@",114,"r",164,"¤",214,"Ö"]
[null,14,"\u000e",65,"A",115,"s",165,"",215,"×"]
[null,15,"\u000f",66,"B",116,"t",166,"¦",216,"Ų"]
[null,16,"\u0010",67,"C",117,"u",167,"§",217,"Ł"]
[null,17,"\u0011",68,"D",118,"v",168,"Ø",218,"Ś"]
[null,18,"\u0012",69,"E",119,"w",169,"©",219,"Ū"]
[null,19,"\u0013",70,"F",120,"x",170,"Ŗ",220,"Ü"]
[null,20,"\u0014",71,"G",121,"y",171,"«",221,"Ż"]
[null,21,"\u0015",72,"H",122,"z",172,"¬",222,"Ž"]
[null,22,"\u0016",73,"I",123,"{",173,"­",223,"ß"]
[null,23,"\u0017",74,"J",124,"|",174,"®",224,"ą"]
[null,24,"\u0018",75,"K",125,"}",175,"Æ",225,"į"]
[null,25,"\u0019",76,"L",126,"~",176,"°",226,"ā"]
[null,26,"\u001a",77,"M",127,"\u007f",177,"±",227,"ć"]
[null,27,"\u001b",78,"N",128,"€",178,"²",228,"ä"]
[null,28,"\u001c",79,"O",129,"\u0081",179,"³",229,"å"]
[null,29,"\u001d",80,"P",130,"‚",180,"´",230,"ę"]
[null,30,"\u001e",81,"Q",131,"\u0083",181,"µ",231,"ē"]
[null,31,"\u001f",82,"R",132,"„",182,"¶",232,"č"]
[null,32," ",83,"S",133,"…",183,"·",233,"é"]
[null,33,"!",84,"T",134,"†",184,"ø",234,"ź"]
[null,34,"\"",85,"U",135,"‡",185,"¹",235,"ė"]
[null,35,"#",86,"V",136,"\u0088",186,"ŗ",236,"ģ"]
[null,36,"$",87,"W",137,"‰",187,"»",237,"ķ"]
[null,37,"%",88,"X",138,"\u008a",188,"¼",238,"ī"]
[null,38,"&",89,"Y",139,"‹",189,"½",239,"ļ"]
[null,39,"'",90,"Z",140,"\u008c",190,"¾",240,"š"]
[null,40,"(",91,"[",141,"¨",191,"æ",241,"ń"]
[null,41,")",92,"\\",142,"ˇ",192,"Ą",242,"ņ"]
[null,42,"*",93,"]",143,"¸",193,"Į",243,"ó"]
[null,43,"+",94,"^",144,"\u0090",194,"Ā",244,"ō"]
[null,44,",",95,"_",145,"‘",195,"Ć",245,"õ"]
[null,45,"-",96,"`",146,"’",196,"Ä",246,"ö"]
[null,46,".",97,"a",147,"“",197,"Å",247,"÷"]
[null,47,"/",98,"b",148,"”",198,"Ę",248,"ų"]
[null,48,"0",99,"c",149,"•",199,"Ē",249,"ł"]
[null,49,"1",100,"d",150,"–",200,"Č",250,"ś"]
[null,50,"2",101,"e",151,"—",201,"É",251,"ū"]
[null,"Kood","Märk"]
[null,251,{"$f":"CHAR(B70)","v":"ū"}]
[null,252,{"$f":"CHAR(B71)","v":"ü"}]
[null,253,{"$f":"CHAR(B72)","v":"ż"}]
[null,254,{"$f":"CHAR(B73)","v":"ž"}]
[null,255,{"$f":"CHAR(B74)","v":"˙"}]

{"sheet":"LoogFun","index":30,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[null,"Loogikafunktsioonid"]
[]
[null,"AND (logav1; logav2; …)","Tagastab vääruse TRUE (tõene), kui kõikide loogikaavaldiste väärtused on tõesed"]
[null,"IF (tingimus; avaldis1; avaldis2)","Kui tingimus on tõene, siis kasutatakse avaldis1, vastupididsel juhul avaldis2"]
[null,"NOT (logav)","Muudab loogikaväärtuse vastupidiseks.\nTRUE ==> FALSE;    FALSE ==> TRUE"]
[null,"OR (logav1; logav2; …)","Tagastab vääruse TRUE (tõene), kui vähemalt ühe loogikaavaldise väärtus on tõene"]

{"sheet":"AjaFun","index":31,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[null,"Ajafunktsioonid"]
[null,"ajaav - ajaavaldis, erijuhul konstant või viit lahtrile"]
[]
[null,"TODAY ()","tänane kuupäev"]
[null,"NOW ()","momendi kellaeg"]
[]
[null,"YEAR (ajaav)","Eraldab ajaväärtusest aasta"]
[null,"MONTH (ajaav)","Eraldab ajaväärtusest kuu numbri"]
[null,"DAY (ajaav)","Eraldab ajaväärtusest kuu päeva numbri"]
[null,"HOUR (ajaav)","Eraldab ajaväärtusest tunnid"]
[null,"MINUTE (ajaav)","Eraldab ajaväärtusest minutid"]
[null,"SECOND (ajaav)","Eraldab ajaväärtusest minutid"]
[null,"WEEKDAY(ajaav [; tüüp ] )","Tagastab kuupäevale vastava nädalapäeva numbri"]
[]
[null,"DATE (aasta; kuu; päev)","Moodustab argumentide väärtuste alusel kuupäeva"]
[null,"TIME (tund; minutd; sekd)","Moodustab argumentide väärtuste alusel kellaaja"]
[]
[]
[]
[null,{"$f":"NOW()","v":"2019-11-04T14:20:02.940"},{"$f":"YEAR(B21)","v":2019},"aasta"]
[null,"2019-11-04T14:20:02.940",{"$f":"MONTH(B22)","v":11},"kuu"]
[null,"2019-11-04T14:20:02.940",{"$f":"DAY(B23)","v":4},"päev"]
[null,"2019-11-04T14:20:02.940",{"$f":"HOUR(B24)","v":14},"tunnid"]
[null,"2019-11-04T14:20:02.940",{"$f":"MINUTE(B25)","v":20},"minutid"]
[null,"2019-11-04T14:20:02.940",{"$f":"SECOND(B26)","v":3},"sekundid"]
[null,"2019-11-04T14:20:02.940",{"$f":"WEEKDAY(B27,2)","v":1},"nädalapäeva number"]
[null,{"$f":"TODAY()","v":"2019-11-04"},{"$f":"B28+100","v":"2020-02-12"},"100 päeva edasi"]

{"sheet":"VLOOKUP","index":32,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"veeb"]
[null,"Otsimisfunktsioon VLOOKUP"]
[null,"Otsimine vertikaalsest tabelist"]
[]
[null,"VLOOKUP(otsitav;  tabel;  tulemi_tulp;  tunnus)"]
[null,"Otsib otsitavale vastavat väärtust tabeli esimesest tulbast ja"]
[null," tagastab tulemuse tulbast  tulemi_tulp. "]
[]
[null,"otsitav - otsitav väärtus: konstant või viit lahtrile (aadress, nimi) "]
[null,"tabel - tabel, mille esimeses tulbas toimub otsimine: piirkonna aadess või nimi"]
[null,"tulemi_tulp - tabeli tulba number, kust võetakse tagastatav väärtus: arv või arvavaldis"]
[null,"tunnus - määrab väärtuste järjestamise tingimuse tabeli esimeses tulbas ja ka otsimisviisi: 0 või 1"]
[null,"0 - väärtused tabeli esimeses tulbas võivad olla suvalises järjekorras - kindla väärtuse otsimine"]
[null,"kui otsitavaga võrdset väärtust esimeses tulbas ei ole - veateade - #N/A"]
[null,"1 - väärtused tabeli esimeses tulbas peavad olema kasvamise järjekorras - vahemiku otsimine"]
[null,"kui otsitavaga võrdset väärtust esimeses tulbas ei ole, tagastatakse lähim väiksem väärtus"]
[]
[]
[]
[null,"Mark","Hind","Protsessor","Kõvaketas","Põhimälu"]
[null,"Frodo",{"$f":"VLOOKUP(Mark, Arvutid, 6, 0)","v":887},{"$f":"VLOOKUP(Mark, Arvutid, 2, 0) & \"; \" & VLOOKUP(Mark, Arvutid, 3, 0)","v":"AMD Athlon64; 3"},{"$f":"VLOOKUP(Mark, Arvutid, 5, 0)","v":500},{"$f":"VLOOKUP(Mark, Arvutid, 4, 0)","v":4072}]
[null,null,null,null,"Teha siia vastavad valemid"]
[]
[]
[null,"Arvutid"]
[null,1,2,3,4,5,6]
[null,"Mark","Prots_tüüp","Taktsagedus","Mälu, MB","Ketas,GB","Hind, Kr"]
[null,"Aragorn","AMD Athlon64",3,512,160,333]
[null,"Arven","Intel Core 2",2.6,256,200,500]
[null,"Balrog","Intel Celeron",2.8,256,80,279]
[null,"Eldar","Intel Xeon",3,512,160,420]
[null,"Elend","Intel Celeron",4,2048,400,866]
[null,"Faram","AMD Athlon64",3,512,210,399]
[null,"Frodo","AMD Athlon64",3,4072,500,887]
[null,"Gandalf","Intel Xeon",3.2,512,160,560]
[null,"Grimbold","Intel Core 2",3.8,1024,320,766]
[null,"Kalvar","Intel Xeon",3,512,160,466]
[null,"Marvin","Intel Celeron",3,512,160,399]
[null,"Rohan","AMD Athlon64",3.5,512,160,393]
[null,"Sauron","Intel Xeon",2.5,256,180,380]

{"sheet":"Valemiredaktor","index":33,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[null,"Valemiredaktor MS Equation 3.0"]