{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Start","Tabelid","Märgid","Vektor","Otsi_Max","Tab_Maat","Kortab","Värvid","Keeletest","Massiivid","Vektorid","Maatriksid","Mat_Kir","Max_reas","Ruutmaat","Viktoriin","Eri_Demo","Otsi","Kysimused","abi"],"not_rendered":{"charts":0,"images":28,"macros":1,"external_links":0,"defined_names":37,"comments":5,"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":"Start","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Tabelid ja massiivid VBAs"]

{"sheet":"Tabelid","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Ruumide karakteristikud"]
[]
[null,null,null,null,null,null,null,null,null,"ruum","pikkus","laius","pind","ümber"]
[null,null,null,null,null,null,null,null,1,"R_01",8,5,40,26]
[null,null,null,null,null,null,null,null,2,"R_02",6.7,3.3,22.11,20]
[null,null,null,null,null,null,null,null,3,"R_03",3.6,2.75,9.9,12.7]
[null,null,null,null,null,null,null,null,4,"R_04",4.45,4.2,18.690000000000001,17.3]
[null,null,null,null,null,null,null,null,5,"R_05",9.1999999999999993,6.8,62.559999999999995,32]
[null,null,null,null,null,null,null,null,6,"R_06",6,3,18,18]
[null,null,null,null,null,null,null,null,null,"Kokku",null,null,{"$f":"SUBTOTAL(109,[pind])","v":171.26},{"$f":"SUBTOTAL(109,[ümber])","v":126}]
[null,null,null,null,null,null,null,null,null,1,2,3,4,5]

{"sheet":"Märgid","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Märkide kuvamine"]
[]
[null,"Excel - funktsioon INDEX()"]
[null,"n",{"$f":"ROWS(Margid[])","v":7},"lahtreid vektoris",null,"Märgid"]
[null,"k",{"$f":"INT(RAND()*n+1)","v":5},"juhuarv 1...n",1,"aTe1/d"]
[null,"V(k)",{"$f":"INDEX(Margid[], k)","v":"Ilus ilm"},{"$f":"\"märgid lahtrist \" & C6","v":"märgid lahtrist 5"},2,"Vk3&3r"]
[null,null,null,null,3,"KrP7yS"]
[null,null,null,null,4,"H3LoW7"]
[null,null,4,null,5,"Ilus ilm"]
[null,null,null,null,6,"Tere Juku!"]
[null,null,null,null,7,"Nägemist"]

{"sheet":"Vektor","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Arvude vektor: aritmeetiline keskmine"]
[]
[]
[null,"Vektor"]
[null,-21]
[null,21,null,"kesk makro",22.333333333333332]
[null,55,null,"kesk funkts",{"$f":"F_kesk_V(Vektor[])","v":22.333333333333332}]
[null,66,null,"kesk Excel",{"$f":"AVERAGE(Vektor[])","v":22.333333333333332}]
[null,-32]
[null,33]
[null,34]
[null,32]
[null,13]

{"sheet":"Otsi_Max","index":4,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"k","V",null,"maks"]
[null,1,28,null,95,null,null,null,{"$f":"F_Max_V(V, COUNT(V))","v":86}]
[null,2,74]
[null,3,-4]
[null,4,86]
[null,5,-64]
[null,6,-34]
[null,7,-84]
[null,8,-20]
[null,9,-64]

{"sheet":"Tab_Maat","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Maatriksi elementide keskmine. Demo"]
[]
[null,"keskmine1",null,"keskmine2"]
[null,-16.066666666666666,null,{"$f":"f_kesk_T(maatriks[])","v":-16.066666666666666}]
[]
[null,-90,53,80]
[null,-94,-30,-33]
[null,-36,26,-13]
[null,-2,-34,62]
[null,14,-68,-76]

{"sheet":"Kortab","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,1,2,3,4,5,6,7,8,9,10]
[null,2,4,6,8,10,12,14,16,18,20]
[null,3,6,9,12,15,18,21,24,27,30]
[null,4,8,12,16,20,24,28,32,36,40]
[null,5,10,15,20,25,30,35,40,45,50]
[null,6,12,18,24,30,36,42,48,54,60]
[null,7,14,21,28,35,42,49,56,63,70]
[null,8,16,24,32,40,48,56,64,72,80]
[null,9,18,27,36,45,54,63,72,81,90]
[null,10,20,30,40,50,60,70,80,90,100]

{"sheet":"Värvid","index":7,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,1,null,null,42]
[null,2,null,null,23]
[null,3,null,null,51]
[null,4,null,null,54]
[null,5,null,null,41]
[null,6,null,null,36]
[null,7,null,null,22]
[null,8,null,null,33]
[null,9,null,null,40]
[null,10,null,null,45]
[null,11,null,null,46]
[null,12,null,null,8]
[null,13,null,null,7]
[null,14,null,null,38]
[null,15,null,null,16]
[null,16,null,null,52]
[null,17,null,null,43]
[null,18,null,null,55]
[null,19,null,null,38]
[null,20,null,null,48]
[null,21,null,null,46]
[null,22,null,null,33]
[null,23,null,null,1]
[null,24,null,null,56]
[null,25,null,null,34]
[null,26,null,null,49]
[null,27,null,null,3]
[null,28,null,null,31]
[null,29,null,null,22]
[null,30,null,null,19]
[null,31,null,null,56]
[null,32,null,null,48]
[null,33,null,null,9]
[null,34,null,null,30]
[null,35,null,null,23]
[null,36,null,null,10]
[null,37,null,null,4]
[null,38,null,null,20]
[null,39,null,null,15]
[null,40,null,null,24]
[null,41,null,null,10]
[null,42,null,null,52]
[null,43,null,null,38]
[null,44,null,null,49]
[null,45,null,null,28]
[null,46,null,null,51]
[null,47,null,null,42]
[null,48,null,null,42]
[null,49,null,null,13]
[null,50,null,null,11]
[null,51,null,null,2]
[null,52,null,null,33]
[null,53,null,null,40]
[null,54,null,null,25]
[null,55,null,null,28]
[null,56,null,null,5]

{"sheet":"Keeletest","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,"eesti",null,"inglise"]
[null,null,null,null,null,null,"kass",null,"cat"]
[null,null,null,null,null,null,"koer",null,"dog"]
[null,null,null,null,null,null,"hiir",null,"mouse"]
[null,null,null,null,null,null,"lehm",null,"cow"]
[null,null,null,null,null,null,"hobune",null,"horse"]
[null,null,null,null,null,null,"karu",null,"bear"]
[null,null,null,null,null,null,"rebane",null,"fox"]

{"sheet":"Massiivid","index":9,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Massiivid"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Dim X(1 To 8), ReDim est(1 To n)"]
[]
[]
[null,null,null,null,null,null,null,"X",13,-7,33,0,-21,17,23,51]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8]
[null,null,null,null,null,null,null,"est","kass","koer","hiir","lehm","hobune","karu","rebane"]
[]
[null,null,null,null,null,null,null,null,"ReDim Puud(1 To n), Hinnad(1 To n)"]
[]
[null,null,null,null,null,null,null,"Puud","kask","kuusk","mänd","lepp","saar","tamm","...","..."]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,"…","n"]
[null,null,null,null,null,null,null,"Hinnad",120,175,168,110,210,230,"..","..."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Dim A(1 To 6, 1 To 4)",null,null,null,null,"ReDim XY(1 To m, 1 To 2)"]
[null,null,null,null,null,null,null,null,1,2,3,4,null,null,1,2]
[null,null,null,null,null,null,null,1,21,-5,0,13,null,1,0,0]
[null,null,null,null,null,null,null,2,3,13,8,3,null,2,25,13]
[null,null,null,null,null,null,null,3,7,17,-4,15,null,3,30,23]
[null,null,null,null,null,null,null,4,23,0,13,0,null,4,36,17]
[null,null,null,null,null,null,null,5,0,18,9,2,null,5,42,21]
[null,null,null,null,null,null,null,6,12,33,-7,6,null,6,27,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"…",10,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"m",0,0]
[]
[]
[]
[null,null,null,null,null,null,null,"V",13,17.21,-43.2,35,123,0,-51,21]
[null,null,null,null,null,null,null,null,0,1,2,3,4,5,6,7]
[null,null,null,null,null,null,null,"est","kass","koer","hiir","lehm","hobune","karu","rebane"]

{"sheet":"Vektorid","index":10,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Operatsioonid vektoritega"]
[]
[]
[]
[]
[null,17,-98,-49,6,-66]

{"sheet":"Maatriksid","index":11,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Operatsioonid massiividega",null,null,null,null,null,"F_kesk_M",null,"Max_M_rv"]
[]
[null,"max","rida","veerg",null,"kesk"]
[null,69,1,2,null,-1.04]
[]
[]
[null,68,69,-27,6,55]
[null,-38,38,-42,51,-80]
[null,20,-80,-36,-60,11]
[null,-54,34,-29,13,35]
[null,20,66,-70,-13,17]

{"sheet":"Mat_Kir","index":12,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,-93,-79,-68,100,-4]
[null,55,26,-35,96,-96]
[null,-17,94,-90,-36,4]
[null,85,-64,88,35,-61]
[null,25,21,-72,58,-76]
[null,70,86,-15,87,-70]

{"sheet":"Max_reas","index":13,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"rida","veerg","max"]
[null,5,5,9]
[]
[null,-8,3,0,-4,7]
[null,2,10,10,7,7]
[null,-9,-2,9,-4,8]
[null,-9,11,9,13,4]
[null,-5,7,6,-4,9]
[null,-5,13,6,21,-4]

{"sheet":"Ruutmaat","index":14,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ruutmaatriks"]
[null,1,2,"...","j","...","n"]
[1,21,17,13,2,2,2]
[2,-6,24,-7,12,-6,12]
["..",12,0,7,-8,12,-8]
["i",3,-6,3,5,-5,6]
["...",3,-11,3,9,5,9]
["n",3,0,13,6,17,6,null,"ReDim A(1 To n, 1 To n)"]
[]
[]
[]
[]
[]
[null,1,2,"...","j","...","n"]
[1,21,17,13,2,2,2]
[2,-6,24,-7,12,-6,12]
["..",12,0,7,-8,12,-8]
["i",3,-6,3,5,-5,6]
["...",3,-11,3,9,5,9]
["n",3,0,13,6,17,6]

{"sheet":"Viktoriin","index":15,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Viktoriin"]
[]
[null,"küsimusi",null,"punkte"]
[null,5,null,10]

{"sheet":"Eri_Demo","index":16,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Erinevate arvude genereerimine. Demo"]
[null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,"mitu","maxi",null,"erinevad arvud"]
[null,"n","max",null,null,null,null,null,20,64,null,5]
[null,6,8,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,64]

{"sheet":"Otsi","index":17,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Demo"]
[]
[null,"k","Liigid",null,null,null,null,null,null,null,{"$f":"COUNTA(Liigid)","v":9}]
[null,1,"saar"]
[null,2,"kask"]
[null,3,"paju",null,null,"liik","nr",null,null,"VBA 1","VBA 2","Excel"]
[null,4,"kuusk",null,null,"tamm",null,null,null,{"$f":"Otsi_0(liik, Liigid, COUNTA(Liigid))","v":7},{"$f":"otsi_1(liik, Liigid)","v":7},{"$f":"MATCH(liik, Liigid, 0)","v":7}]
[null,5,"jalakas"]
[null,6,"vaher"]
[null,7,"tamm"]
[null,8,"mänd"]
[null,9,"haab"]

{"sheet":"Kysimused","index":18,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Küsimus","Vastus","Lubatud viga"]
[null,"Mis aastal loodi esimene personaalarvuti(±2 aastat)?",1976,2]
[null,"Mis on Prantsusmaa pealinn?","Pariis"]
[null,"Mis aastal algas 2. maailmasõda?",1939,1]
[null,"Mis on Eesti pealinn?","Tallinn"]
[null,"Maailma suurim arvutifirma?","IBM"]
[null,"Mis on Soome pealinn?","Helsinki"]
[null,"Mis aastal loodi esimene mikroprotsessor (±3 aastat)?",1971,3]
[null,"Eesti maadleja - kahekordne olümpiavõitja (perekonnanimi)","Palusalu"]
[null,"Sidney olümpiavõitja kümnevõistluses (ees- ja perenimi)","Erki Nool"]
[null,"Eesti president (ees- ja perenimi)","Toomas Ilves"]
[null,"Soome firma, mida otsiti Eestis?","Nokia"]
[null,"Mis on kõikide leiutiste ja pahede alus?","laiskus"]
[null,"Maailma sügavaim järv?","Baikal"]
[null,"Sodiaagimärk, millesse kuulub vahemik 23.07 kuni 22.08?","lõvi"]
[null,"Milline planeet on kõige lähemal päikesele?","Merkuur"]
[null,"Mis aastal toimus inimese esimene kosmoselend?",1961,5]
[null,"Esimese kosmonaudi perenimi?","Gagarin"]
[null,"Mis aastal oli esimene inimene Kuul (±2 aastat)?",1969,2]
[null,"Esimese kuule astunud inimese perenimi?","Armstrong"]
[null,"Maailma pikim jõgi?","Niilus"]
[null,"Mitu sentimeetrit on tollis?",2.54]
[null,"Maailma kõrgeim juga?","Angel"]
[null,"Mis aastal vallutati Mount Everest (±5 aastat)?",1950,5]
[null,"Kes kirjutas romaani \"Kevade\" (ees- ja perenimi)","Oskar Luts"]

{"sheet":"abi","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}