{"text_format":"1","workbook":"xlsx","n_sheets":33,"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_analüüs","Det_Skeem_Val","Kasutajaliides","Materjalid","Värvid","Aeg","Tekst","Lisad","Nimed","Valideerimine","MatFun","TekstFun","LoogFun","AjaFun","VLOOKUP","Valemiredaktor"],"not_rendered":{"charts":1,"images":47,"macros":1,"external_links":0,"defined_names":48,"comments":19,"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":29,"n_cols":2,"rows_kept":29,"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,"Minirakendus \"Detail\" - ülesande püstitus"]
[null,"\"Detail\" - kasutajaliides"]
[null,"\"Detail\" - materjalid"]
[null,"\"Detail\" - värvid"]
[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," - tekstid","Peeter","Kask",{"$f":"LEFT(C5, 1) & \". \" & D5","v":"P. Kask"}]
[null," - ajaväärtused",{"$f":"NOW()","v":"2016-09-05T18:57:37"},{"$f":"TODAY()","v":"2016-09-05"},{"$f":"NOW()","v":42618.790011574078}]
[null," - tõeväärtused",true,false,{"$f":"\"mees\" > \"naine\"","v":false}]
[]
[]
[]
[]
[]
[]
[]
[]
[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  Windows'i aknas Control Panel / Region and  Language"]

{"sheet":"Valemid","index":3,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,"Funktsioonid","Arvavaldised","Tekstavaldised"]
[null,null,"Loogikaavaldised","Ajaavaldised","veeb","Ekraanivisioon \"Valemid ja avaldised\""]

{"sheet":"Funktsioonid","index":4,"n_rows":2,"n_cols":6,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,5,1,6]]}
[null,null,"Funktsioonid","Arvavaldised","Tekstavaldised"]
[null,null,"Loogikaavaldised","Ajaavaldised","veeb","Ekraanivisioon \"Funktsioonid\""]

{"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","Ujukoma- 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, lõppu lisatakse %. Säilitatav väärtus ei muutu.  ",null,null,null,null,null,null,0.18]
[null,"Text \n@","Tekst. Kuvamisel arvu käsitletakse tekstina. Kui vorming on määratud enne sisestamist, siis säilitakse kõik märgid. ",null,null,null,null,null,null,"3562,725"]
[null,"Custom \n","Kasutaja. Luuakse olemasoleva vormingu 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,3,6,14,17,30,36,39,51,61,63,null,{"$f":"IF(INDEX(numbrid, 10)=\"\", \"\", AVERAGE(numbrid))","v":32}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"b * RAND()","v":70.313237496788318},84.601324285631094,86.023897878503277,39.071020441201178]
[null,null,null,null,null,null,null,null,64.35888013059548,27.055505959972372,93.225851359805262,84.92281207473134]
[null,null,null,null,null,null,null,null,6.882008311782295,98.812038356907792,48.333749987636601,23.596298289153594]
[null,null,null,null,null,null,null,null,21.976033397909724,59.308843366250798,14.398395466223468,28.000236678611788]
[null,null,null,null,null,null,null,null,6.7904380930859487,66.162835286409617,55.024440571402344,72.346105459342013]
[null,null,null,null,null,null,null,null,43.696519637822483,56.902694680384478,76.630227089444546,66.170027703449122]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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"]
[null,"b"]
[null,"c"]
[null,"S"]
[null,"Sr"]
[null,"p"]
[null,"r"]
[]
[]
[null,"2) Kolmnurga karakteristikud: nimed"]
[]
[null,"a",null,null,"   Nime määramine üksikule lahtrile"]
[null,"b"]
[null,"c",null,null,"   Nimede määramine korraga mitmele lahtrile"]
[null,"S",null,null,{"$f":"K_pind1(a, b, c_)","v":{"$error":"#NAME?"}}]
[null,"Sr"]
[null,"p"]
[null,"r"]

{"sheet":"T_Kolmnurk","index":8,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Valemid"]
[null,"Kolmnurga karakteristikud"]
[]
[null,"a",5,"cm"]
[null,"b",7,"cm"]

{"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,null,null,null,null,null,{"$f":"a*b/c_","v":-2.4}]
[null,2,null,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,null,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,null,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,null,null,null,null,null,{"$f":"(2*EXP(x)+EXP(-2*x))/(a^2+b^2)","v":7.4206590901270744}]
[null,12,null,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":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[10,4,10,5],[11,4,11,5],[0,4,0,7]]}
[null,null,null,"veeb","Ekraanivisioon \"Loogikaandmed ja -avaldised\""]
[null,"Loogikaandmed (tõeväärtused), -avaldised ja funktsioonid"]
[]
[null,"Väärtused ja tehted",null,null,"Võrdlused"]
[]
[null,"Näited. Arvude võrdlemine "]
[]
[null,"a","b","x","a = b","a > b","a <= b"]
[null,3,13,7,{"$f":" a = b","v":false},{"$f":" a > b","v":false},{"$f":" a <= b","v":true},null,null,"tekstid"]
[null,null,null,null,null,null,null,null,null,"A"]
[null,"a <= x <= b","a <= x","(a <= x) <= b","AND( a <= x; x <= b)",null,null,null,null,"B"]
[null,{"$f":" a <= x <= b","v":false},{"$f":" a <= x","v":true},{"$f":"C12 <= b","v":false},{"$f":"AND( a <= x, x <= b)","v":true},null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,null,"a"]
[null,"Näited. Tekstide võrdlemine",null,null,null,null,null,null,null,"b"]
[null,null,null,null,null,null,null,null,null,"c"]
[null,"T_1","T_2","T_1 = T_2","T_1 > T_2",null,null,null,null,"k"]
[null,"b","A",{"$f":" T_1 = T_2","v":false},{"$f":" T_1 > T_2","v":true},null,null,null,null,"m"]
["kood",{"$f":"CODE(T_1)","v":98},{"$f":"CODE(T_2)","v":65},null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,"z"]
[null,null,null,null,null,null,null,null,null,"Malle"]
[null,null,null,null,null,null,null,null,null,"Juku"]
[null,null,null,null,null,null,null,null,null,"Kalle"]
[null,null,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 tähte on taevas",null,null,null,null,{"$f":"F6=6","v":false}]
[null,"Mitu veergu on Excel 2013/2016 töölehel?",null,null,null,null,{"$f":"F7=H7","v":false},16384]
[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":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[13,1,13,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,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,null,{"$f":"IF(F7=16384, \"Õige!\", \"Vale!\")","v":"Vale!"}]
[null,"Mis aastal loodi esimene personaalarvuti?",null,null,null,null,{"$f":"IF(F8 = H8, \"Õige!\", \"Vale!\")","v":"Vale!"},1976]
[null,"Mis firmas see loodi?",null,null,null,null,null,"Apple"]
[null,"Mis aastal loodi esimene mikroprotsessor?",null,null,null,null,null,1971]
[null,"Mis firmas see loodi?",null,null,null,null,{"$f":"IF(F11 = \"\", \"\", IF(F11 = H11, 2, 0))","v":""},"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:"]
[null,"eesti","inglise","hinnang"]
[null,"koer",null,null,"dog"]
[null,"kass",null,null,"cat"]
[null,"laud",null,null,"table"]
[null,"lahter",null,null,"cell"]
[null,"arv",null,null,"number"]
[null,"kui",null,null,"if"]
[]
[]
[]
[null,"Andmete kontroll"]
[null,"Nimi","Väärtus","Kontroll"]
[null,"a",null,null,"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 a, b võic"]
[null,null,null,{"$f":"IF(OR(a=\"\", b=\"\", c_=\"\"), \"\", IF(AND(a+b>c_, a+c_>b, b+c_>a),\"\", \"Kolnurka ei ole!\"))","v":""},"Teade kuvatakse kui lahtrid a, b  ja c ei ole tühjad ja kolmnurga tingimus ei kehti"]

{"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",154,"protsent",0.2]
[]
[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?",null,null,"B"]
[null,"Mis aastal toimus Waterloo lahing: A-1915, B-1795, C-1815, D-1940?",null,null,"C"]

{"sheet":"Detailike","index":16,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,4,0,5]]}
[null,null,null,null,"Materjalid",null,"Värvid"]
[]
[null,"Minirakendus \"Detailike\""]

{"sheet":"Det_analüüs","index":17,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,7]]}
[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":18,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"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":19,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"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":20,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"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":21,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"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":22,"n_rows":31,"n_cols":7,"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":"2016-09-05T18:57:37"},null,null,{"$f":"NOW()","v":42618.790011574078}]
[]
[null,{"$f":"TODAY()","v":"2016-09-05"},null,null,{"$f":"TODAY()","v":42618}]
[]
[null,"Operatsioonid kuupäevadega ja kellaaegadega"]
[]
[null,"Palju on jäänud aega etteantud kuupäevani? "]
[]
[null,"ek","2016-01-01","etteantud kuupäev"]
[null,"v",{"$f":"ek-NOW()","v":-248.79001157407765},"etteantud kuupäeva ja antud hetke vahe"]
[null,"p",{"$f":"INT(v)","v":-249},"päeva"]
[null,"t",{"$f":"HOUR(v)","v":{"$error":"#NUM!"}},"tundi"]
[null,"m",{"$f":"MINUTE(v)","v":{"$error":"#NUM!"}},"minutid"]
[null,"s",{"$f":"SECOND(v)","v":{"$error":"#NUM!"}},"sekundit"]
[null,"as",{"$f":"86400*v","v":-21495457.000000309},"aeg sekundites"]
[]
[]
[null,"Millal on põhjust täiendavaks juubelipeoks?"]
[]
[null,"sk","1991-10-26","Sünnikuupäev"]
[null,"evp",10000,"Etteantud vanus päevades"]
[null,"vp",null,"Vanus päevades praegu"]
[null,"va",null,"Vanus aastates praegu"]
[null,"jk",null,"Juubeli kuupäev"]
[null,"vaj",null,"Vanus aastates sell ajal"]

{"sheet":"Tekst","index":23,"n_rows":27,"n_cols":8,"rows_kept":27,"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 salvestatakse 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","Eesnimi","Perenimi"]
[null,"Kask","Kalle","Kalle Kask","K. Kask","Kalle","Kask"," Tulemite soovitav kuju"]
[null,"Saar","Tiina"]
[null,"Kasemets","Marge"]
[null,"Männik","Rein"]
[]
[]
[]
[]
[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"]

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

{"sheet":"Nimed","index":25,"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":"Valideerimine","index":26,"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 loendid",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":"MatFun","index":27,"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":28,"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":"˜"},202,{"$f":"CHAR(J19)","v":"Ê"}]
[null,2,"\u0002",53,"5",103,"g",153,"™",203,"Ë"]
[null,3,"\u0003",54,"6",104,"h",154,"š",204,"Ì"]
[null,4,"\u0004",55,"7",105,"i",155,"›",205,"Í"]
[null,5,"\u0005",56,"8",106,"j",156,"œ",206,"Î"]
[null,6,"\u0006",57,"9",107,"k",157,"\u009d",207,"Ï"]
[null,7,"\u0007",58,":",108,"l",158,"ž",208,"Ð"]
[null,8,"\b",59,";",109,"m",159,"Ÿ",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,"ƒ",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,"ˆ",186,"º",236,"ì"]
[null,36,"$",87,"W",137,"‰",187,"»",237,"í"]
[null,37,"%",88,"X",138,"Š",188,"¼",238,"î"]
[null,38,"&",89,"Y",139,"‹",189,"½",239,"ï"]
[null,39,"'",90,"Z",140,"Œ",190,"¾",240,"ð"]
[null,40,"(",91,"[",141,"\u008d",191,"¿",241,"ñ"]
[null,41,")",92,"\\",142,"Ž",192,"À",242,"ò"]
[null,42,"*",93,"]",143,"\u008f",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":29,"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":30,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[null,"Ajafunktsioonid"]
[null,"ajaav - ajaavaldis, erijuhul konstant või viit lahtrile"]
[]
[null,"DATE (aasta; kuu; päev)","Moodustab argumentide väärtuste alusel kuupäeva"]
[null,"DAY (ajaav)","Eraldab aja väärtusest päeva numbri"]
[null,"HOUR (ajaav)","Eraldab aja väärtusest tunnid"]
[null,"MINUTE (ajaav)","Eraldab aja väärtusest minutid"]
[null,"MONTH (ajaav)","Eraldab aja väärtusest kuu numbri"]
[null,"NOW ()","Tagastab antud hetke kuupäeva ja kellaaja"]
[null,"SECOND (ajaav)","Eraldab aja väärtusest minutid"]
[null,"TIME (tund; minutd; sekd)","Moodustab argumentide väärtuste alusel kellaaja"]
[null,"TODAY ()","Tagastab antud hetke kuupäeva "]
[null,"WEEKDAY(ajaav [; tüüp ] )","Tagastab kuupäevale vastava nädalapäeva numbri"]
[null,"YEAR (ajaav)","Eraldab aja väärtusest aasta"]
[]
[]
[]
[null,{"$f":"NOW()","v":"2016-09-05T18:57:37"},{"$f":"YEAR(B19)","v":2016},"aasta"]
[null,"2016-09-05T18:57:37",{"$f":"MONTH(B20)","v":9},"kuu"]
[null,"2016-09-05T18:57:37",{"$f":"DAY(B21)","v":5},"päev"]
[null,"2016-09-05T18:57:37",{"$f":"HOUR(B22)","v":18},"tunnid"]
[null,"2016-09-05T18:57:37",{"$f":"MINUTE(B23)","v":57},"minutid"]
[null,"2016-09-05T18:57:37",{"$f":"SECOND(B24)","v":37},"sekundid"]
[null,"2016-09-05T18:57:37",{"$f":"WEEKDAY(B25,2)","v":1},"nädalapäeva number"]
[null,{"$f":"TODAY()","v":"2016-09-05"},{"$f":"B26+100","v":"2016-12-14"},"100 päeva edasi"]

{"sheet":"VLOOKUP","index":31,"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":32,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[null,"Valemiredaktor MS Equation 3.0"]