{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Tiitel","Sisukord","Tabelid","LP_Omadused_1","LP_Meetodid","LP_Omadused_2","Cur_Reg","LPd","Otsi_Max","Keeletest","Keeletest2","Teg_Vek","Palk","Tõlge_1","Otsi","Viktoriin","Kyssad","Lisad","Cells","Offset","Resize","Teg_mat","Sheet2"],"not_rendered":{"charts":0,"images":45,"macros":1,"external_links":1,"defined_names":102,"comments":2,"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":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null," "]
[null,null,"Tabelid "]

{"sheet":"Sisukord","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Tabeli tüüpstrukuur"]
[null,"Range-objekti üldised omadused"]
[null,"Range-objekti mõned meetodid"]
[null,"Piirkonna (lahtriploki) omadused tööks tabelitega"]
[null,"Omadus CurrentRegion"]
[null,"Viitamine lahtriplokkidele"]
[null,"Keletest"]
[null,"Keeletest 2"]
[null,"Tegevused vektoritega"]
[null,"Palga arvestamise tabel"]
[null,"Tõlge 1"]
[null,"Funktsioon Otsi"]
[null,"Viktoriin"]
[null,"Lisad"]
[null,"Lahtriploki omadused Cells(rn, tn) ja Cells(nr) "]
[null,"Offset-omadus"]
[null,"Resize-omadus"]
[null,"Tegevused tabelitega"]

{"sheet":"Tabelid","index":2,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Demo","Müükide arvestus"]
[null,"Tabeli tüüpstrukuur",null,null,null,null,null,null,null,null,null,"Kokku:",411,null,19226]
[]
[null,null,null,null,null,null,null,null,null,"kuupäev","müüja","liik","kogus","hind","maks"]
[null,null,null,null,null,null,null,null,null,"2013-01-01","Kuusik","kuusk",32,42,1344]
[null,null,null,null,null,null,null,null,null,"2013-01-01","Lepik","lepp",45,34,1530]
[null,null,null,null,null,null,null,null,null,"2013-01-02","Tammik","kask",16,36,576]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Kuusik","tamm",52,70,3640]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Männik","mänd",24,40,960]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Kaasik","kask",13,36,468]
[null,null,null,null,null,null,null,null,null,"2013-01-04","Mets","lepp",63,34,2142]
[null,null,null,null,null,null,null,null,null,"2013-01-04","Kuusik","tamm",21,70,1470]
[null,null,null,null,null,null,null,null,null,"2013-01-05","Lepik","lepp",30,34,1020]
[null,null,null,null,null,null,null,null,null,"2013-01-05","Kaasik","kuusk",28,42,1176]
[null,null,null,null,null,null,null,null,null,"2013-01-05","Võsa","tamm",52,70,3640]
[null,"Hinnakiri",null,null,null,"Töötajad",null,null,null,"2013-01-06","Mets","kask",35,36,1260]
[]
[null,"Liigid","Hinnad",null,null,"Nimi","Sünniaeg","Vald"]
[null,"haab",27,null,null,"Kaasik","1950-01-01","Harju"]
[null,"kask",36,null,null,"Kuusik","1960-02-02","Abja"]
[null,"kuusk",42,null,null,"Lepik","1970-05-05","Abja"]
[null,"lepp",34,null,null,"Mets","1950-07-07","Tali"]
[null,"mänd",40,null,null,"Männik","1970-03-03","Tali"]
[null,"saar",60,null,null,"Tammik","1980-04-04","Tali"]
[null,"tamm",70,null,null,"Võsa","1960-06-06","Harju"]
[null,null,null,null,null,"Känd","1966-08-08","Abja"]
[null,null,null,null,null,null,null,null,null,null,"Päringud"]
[null,"Koondid",null,null,null,null,null,null,null,"liik"]
[null,"Koond puude liikide lõikes",null,null,null,"Koond müüjate lõikes",null,null,null,"lepp","Kokku",138,4692]
[]
[null,"Liik","Kogus","Maks",null,"Nimi","Kogus","Maks",null,null,"müüja","kogus","maks"]
[null,"haab",0,0,null,"Kaasik",41,1644,null,null,"Lepik",45,1530]
[null,"kask",64,2304,null,"Kuusik",105,6454,null,null,"Mets",63,2142]
[null,"kuusk",60,2520,null,"Lepik",75,2550,null,null,"Lepik",30,1020]
[null,"lepp",138,4692,null,"Mets",98,3402]
[null,"mänd",24,960,null,"Männik",24,960]
[null,"saar",0,0,null,"Tammik",16,576]
[null,"tamm",125,8750,null,"Võsa",52,3640]
[null,null,null,null,null,"Känd",0,0]
[null,"Kokku:",411,19226]
[null,null,null,null,null,"Kokku:",411,19226]

{"sheet":"LP_Omadused_1","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"algus"]
[null,"Range-objekti üldised omadused",null,null,null,null,null,-5]
[]
[null,"Omadus","Selgitus","tab_alg","Fun_Tab","Aktiivne",null,"x","y"]
[null,"Address","Aadress",null,null,"$F$2",null,{"$f":"a","v":-5},{"$f":"SIN(x/2+3)","v":0.47942553860420301}]
[null,"Name","Nimi",null,null,null,null,{"$f":"H6+1","v":-4},0.8414709848078965]
[null,"Value","Väärtus",null,null,null,null,-3,0.99749498660405445]
[null,"Formula","Valem",null,null,"",null,-2,0.90929742682568171]
[null,"Left","Vasak serv",null,null,437.25,null,-1,0.59847214410395655]
[null,"Top","Ülemine serv",null,null,23.25,null,0,0.14112000805986721]
[null,"Width","Laius",null,null,64.5,null,1,-0.35078322768961984]
[null,"Height","Kõrgus",null,null,20.25,null,2,-0.7568024953079282]
[null,"Font.Size","Kirja suurus",null,null,16,null,3,-0.97753011766509701]
[null,"Font.Colorindex","Kirja värvus",null,null,-4105,null,4,-0.95892427466313845]
[null,"Interior.Colorindex","Interjööri värvus",null,null,-4142,null,5,-0.70554032557039192]
[]
[null,13,13,13,13,13]

{"sheet":"LP_Meetodid","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Range-objekti mõned meetodid"]
[]
[null,"Meetod","Selgitus"]
[null,"Select","Valida","Range(\"tab_1\").Select"]
[null,"ClearContents","Kustuta sisu","Range(\"tab_1\").ClearContents"]
[null,"Clear","Kustuta kõik","Range(\"tab_1\").Clear"]
[null,"Delete nihe","Eemaldada","Range(\"tab_1\").Columns(2).Delete xlShiftToLeft"]
[null,"Insert nihe","Lisa vahele","Range(\"tab_2\").Rows(2).Insert xlShiftDown"]
[null,"Copy [sihtkoht]","Kopeeri","Range(\"tab_2\").Copy Range(\"tab_1\")"]
[null,"Cut  [sihtkoht]","Lõika","Range(\"tab_2\").Cells(1, 1).Cut"]
[null,"Speak","Ütle","Range(\"tervitus\").Speak"]

{"sheet":"LP_Omadused_2","index":5,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Piirkonna (lahtriploki) omadused tööks tabelitega"]
[null,null,null,null,null,null,"Piirkond RT (Ruumide Tabel)"]
[null,null,null,null,null,null,1,2,3,4,5]
[null,"Omadus","Selgitus"]
[null,"Row / Column","Piirkonna alguse rea/veeru number töölehel",null,1,null,"ruum","a","b","pind","ümber"]
[null,"Rows / Columns","Piirkonna kõik rivid / tulbad",null,2,null,"R_01",6,4,24,20]
[null,"Rows(rn) / Columns(tn)","Rivi numbriga rn / tulp numbriga tn",null,3,null,"R_02",4,3.8,15.2,15.6]
[null,"Cells","Piirkonna kõik lahtrid",null,4,null,"R_03",5,4.5999999999999996,23,19.2]
[null,"Cells(rn, tn)","Lahter. rn, tn - rivi ja tulba nr. piirkonna algusest",null,5,null,"R_04",3.5,2.7,9.4499999999999993,12.4]
[null,"Cells(nr)","Lahter. nr - järjenumber piirkonna algusest",null,6,null,"R_05",6.2,5.5,34.1,23.4]
[null,"CurrentRegion","Mittetühi piirkond, milles sisaldub antud piirkond",null,7,null,"R_06",4.0999999999999996,3.8,15.58,15.8]
[null,"Offset(rnihe, tnihe)","Piirkond, mis on nihutadud antud piirkonna suhtes "]
[null,"Resize(m, n)","Piirkonna mõõtmete muutmine  "]

{"sheet":"Cur_Reg","index":6,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Omadus CurrentRegion"]
[]
[]
[null,"Kõvakettad"]
[]
[null,"Mark","Hind",null,9,2,3,null,4]
[null,"200GB Maxtor Fireball ",155,null,3,5,4,null,7]
[null,"300GB Seagate ST3204",175,null,4,6,5,null,8]
[null,"400GB Seagate ST-3204",188]
[null,"40üGB WD Caviar WD200BB ",188,null,6,2,3,null,4,null,null,6]
[null,"600GB Maxtor DM60",219,null,3,5,4,13,7,null,null,12]
[null,"300GB Seagate ST33062",189,null,4,6,5,null,8,null,null,5]
[null,null,null,null,null,null,null,null,21,33,17,66]
[null,"Protsessorid"]
[null,"Mark","Hind"]
[null,"AMD Athlon Thunderbird 1,2GHz",219,null,"x=",13,null,"x","y"]
[null,"AMD Athlon Thunderbird 1,4Ghz",259,null,null,null,null,-5,-3.745911786114116]
[null,"AMD Athlon Thunderbird 1GHz",189,null,"Kask",null,null,-4,-2.0719597453574461]
[null,"AMD Duron 750MHz",93,null,"Paju",null,null,-3,-3.4355432163083663]
[null,"AMD Duron 800MHz",107,null,"Saar",null,null,-2,-0.89493912255884511]
[null,"Pentium 4, 3,2 GHz",222,null,"Tamm",null,null,-1,-1.9715765869889021]
[null,null,null,null,null,null,null,0,1]
[null,null,null,null,null,null,null,1,-8.4084062119887948E-3]
[null,null,null,null,null,null,null,2,2.8152796958595769]

{"sheet":"LPd","index":7,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"rivi",null,null,null,null,null,null,"rmaks"]
[null,null,null,null,null,null,null,null,null,3,"tulp",null,3,7,9,-6,13,7,null,13]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,"tabel"]
[null,null,null,null,null,null,null,null,null,-6,null,null,null,null,null,null,29,31,-32,85,-3]
[null,null,null,null,null,null,null,null,null,12,"Proovige ka sammhaaval täitmist:",null,null,null,null,null,-5,68,13,-55,8]
[null,null,null,null,null,null,null,null,null,7,"katkestuspunkt ja F8",null,null,null,null,null,33,-8,63,-35,7]
[null,null,null,null,null,null,null,null,null,-9,null,null,null,null,null,null,-53,71,45,-45,20,"psum",473]
[null,null,null,null,null,null,null,null,null,17]
[]
[null,null,null,null,null,null,null,null,null,"tkesk",5.25]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tulba keskmine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LP_kesk(tulp)","v":5.25}," =LP_kesk(tulp)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rivi keskmine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LP_kesk1(rivi)","v":5.5}," =LP_kesk(rivi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tabeli keskmine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LP_kesk(tabel)","v":11.85}," =LP_kesk(tabel)"]

{"sheet":"Otsi_Max","index":8,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"k","V",null,"maks"]
[null,1,13]
[null,2,21]
[null,3,17]
[null,4,-6]
[null,5,34]
[null,6,21]
[null,7,66]
[null,8,-13]
[null,9,7]

{"sheet":"Keeletest","index":9,"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,"hourse"]
[null,null,null,null,null,null,"karu",null,"bear"]
[null,null,null,null,null,null,"rebane",null,"fox"]

{"sheet":"Keeletest2","index":10,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"suund","mitu"]
[null,"eesti","inglise",null,null,null,null,null,null,null,1,3]
[null,"ahv","monkey",null,null,null,null,null,null,null,"1 - est=>eng, 2 - eng=>est"]
[null,"elevant","elephant"]
[null,"gepard","cheetah"]
[null,"hiir","mouse"]
[null,"hirv","deer"]
[null,"hobune","horse"]
[null,"hunt","wolf"]
[null,"jänes","hare"]
[null,"kalkun","turkey"]
[null,"kana","hen"]
[null,"karu","bear"]
[null,"kass","cat"]
[null,"kobras","beaver"]
[null,"koer","dog"]
[null,"kukk","cock"]
[null,"küülik","rabbit"]
[null,"lammas","sheep"]
[null,"lehm","cow"]
[null,"lõvi","lion"]
[null,"mäger","badger"]
[null,"põder","elk"]
[null,"põrsas","piglet"]
[null,"rebane","fox"]
[null,"rott","rat"]
[null,"siga","pig"]
[null,"siil","hedgehong"]
[null,"tall","lamb"]
[null,"tiiger","tiger"]
[null,"varss","foal"]
[null,"vasikas","calf"]

{"sheet":"Teg_Vek","index":11,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Operatsioonid vektoritega"]
[]
[]
[null,"mini","maxi","mitu"]
[null,-100,100,5]
[]
[null,-79,null,"pos_kesk",null,"maximum","nr"]
[null,100,null,50,null,100,2]
[null,35]
[null,-97]
[null,15]

{"sheet":"Palk","index":12,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["Demo",null,"Palgaarvestus",null,null,"november"]
[]
[null,"maksuvaba",144,"prots",21]
[]
[]
[null,"Nimi","Tariif","Tunde","Palk","Maks","Saada"]
[null,"Kask  P.",19,156,2964,592.19999999999993,2371.8000000000002]
[null,"Kuusk V.",12,104,1248,231.84,1016.16]
[null,"Lepp M.",14,150,2100,410.76,1689.24]
[null,"Mänd K.",9,88,792,136.07999999999998,655.92000000000007]
[null,"Paju L.",11,174,1914,371.7,1542.3]
[null,"Saar K.",12,33,396,52.919999999999995,343.08]
[null,"Tamm H.",7,51,357,44.73,312.27]
[null,"Vaher O.",19,70,1330,249.06,1080.94]
[]
[null,"Kokku:",null,826,11101,2089.29,9011.7100000000009]
[]
[null," "]

{"sheet":"Tõlge_1","index":13,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"DEMO"]
[null,null,null,null,null,"suund"]
[null,"eesti","inglise",null,null,1]
[null,"ahv","monkey",null,null,"1 - est > eng, 2 - eng > est"]
[null,"elevant","elephant"]
[null,"gepard","cheetah"]
[null,"hiir","mouse"]
[null,"hirv","deer"]
[null,"hobune","horse"]
[null,"hunt","wolf"]
[null,"jänes","hare"]
[null,"kalkun","turkey"]
[null,"kana","hen"]
[null,"karu","bear"]
[null,"kass","cat"]
[null,"kobras","beaver"]
[null,"koer","dog"]
[null,"kukk","cock"]
[null,"küülik","rabbit"]
[null,"lammas","sheep"]
[null,"lehm","cow"]
[null,"lõvi","lion"]
[null,"mäger","badger"]
[null,"põder","elk"]
[null,"põrsas","piglet"]
[null,"rebane","fox"]
[null,"rott","rat"]
[null,"siga","pig"]
[null,"siil","hedgehong"]
[null,"tall","lamb"]
[null,"tiiger","tiger"]
[null,"varss","foal"]
[null,"vasikas","calf"]

{"sheet":"Otsi","index":14,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Demo"]
[]
[null,"k","Liigid"]
[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,"saar",1,null,null,{"$f":"Otsi(liik, Liigid, 9)","v":1},{"$f":"otsi_1(liik, Liigid)","v":1},{"$f":"MATCH(liik, Liigid, 0)","v":1}]
[null,5,"jalakas"]
[null,6,"vaher"]
[null,7,"tamm"]
[null,8,"mänd"]
[null,9,"haab"]

{"sheet":"Viktoriin","index":15,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Viktoriin (test)",null,"Demo"]
[]
[null,"küsimusi",3]

{"sheet":"Kyssad","index":16,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Küsimus","õige vastus","lubatud viga"]
[null,"Mis aatal loodi esimene personaalarvuti?",1976,2]
[null,"Mis aastal algas 2. maailmasõda?",1939,3]
[null,"Mis on Eesti pealinn?","Tallinn"]
[null,"Mis on Prantsusmaa pealinn?","Pariis"]
[null,"Maailma suurim arvutifirma?","IBM"]
[null,"Maailma suurim tarkvara firma?","Microsoft"]
[null,"Mis on Soome pealinn?","Helsinki"]
[null,"Mis aatal loodi esimene mikroprotsessor?",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,"Pekingi olümpiavõitja kettahites (ees- ja perenimi)","Gerd Kanter"]
[null,"Eesti president (ees- ja perenimi)","Toomas Ilves"]
[null,"Soome firma, mida otsitakse Eestis?","Nokia"]
[null,"Kes kirjutas romaani \"Kevade\" (ees- ja perenimi)","Oskar Luts"]
[null,"Mis on kõikide leiutiste ja pahede alus?","laiskus"]
[null,"Maailma parim tarkvara firma?","Jukusoft"]
[null,"Maailma sügavaim järv?","Baikal"]
[null,"Sodiaki märk, millesse kuulub vahemik 22.06 kuni 22.07?","vähk"]
[null,"Sodiaki märk, millesse kuulub vahemik 23.07 kuni 22.08?","lõvi"]
[null,"Milline planeet on kõige lähemal päikesele?","Merkuur"]
[null,"Milline planeet on kõige kaugemal päikesest?","Pluuto"]
[null,"Planeet, millele on saadetud kõige rohkem kosmoseaparaate?","Marss"]
[null,"Mis aastal toimus inimese esimene kosmoselend?",1961,1]
[null,"Esimese kosmonaudi perenimi?","Gagarin"]
[null,"Mis aastal oli esimene inimene Kuul?",1969,2]
[null,"Esimese kuule astunud inimese perenimi?","Armstrong"]
[null,"Suurim maailmajagu?","Aasia"]
[null,"Maailma suurim saar?","Gröönimaa"]
[null,"Maailma suurim poolsaar?","Araabia"]
[null,"Maailma suurim järv?","Kaspia meri"]
[null,"Maailma pikim jõgi?","Niilus"]
[null,"Mitu sentimeetrit on tollis?",2.54,0.05]
[null,"Maailma kõrgeim juga?","Angel"]
[null,"Mis aastal vallutati maailma kõrgeim mäetipp (Mount Everest)?",1950,5]
[null,"Maailma kõrgeima mäetipu esmavallutaja perenimi?","Hillary"]
[null,"Euroopa kõrgeim mäetipp?","Mont Blanc"]
[null,"Euroopa kõrgeim mäestik?","Alpid"]

{"sheet":"Lisad","index":17,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Lisad"]

{"sheet":"Cells","index":18,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[19,5,20,6]]}
[]
[null,null,"Lahtriploki omadused Cells(rn, tn) ja Cells(nr)  või  (rn, tn) ja (nr)"]
[null,null,"Võimaldavad viidata piirkonna  latritele "]
[null,null,"prk.Cells(rn, tn)  ja prk.Cells(nr)",null,null,null,null,"või","prk(rn, tn)  ja prk(nr)"]
[null,null,"prk - töölehe ristkülikuline ala, tulp, rivi või üksik lahter",null,null,null,null,null,null,"vrdl. Excel INDEX(prk; rn; tn)"]
[null,null,"rn, tn - rivi ja tulba number piirkonna algusest, nr - lahtri järjenumber piirkonna algusest"]
[]
[null,null,null,null,null,null,null,null,-2]
[null,null,null,null,null,null,null,null,-1]
[null,null,null,null,null,null,null,null,0]
[null,null,null,"A","B","C","D",null,1,"Range(\"Tab_A\").Cells(rn, tn)  või  Range(\"Tab_A\")(rn, tn) "]
[null,null,null,4,90,1,44,null,2,"Tab_A - piirkonna nimi"]
[null,null,null,10,56,64,77,null,3,"või"]
[null,null,null,94,82,94,89,null,4,"Range(\"A_alg\").Cells(rn, tn)  või  Range(\"A_alg\")(rn, tn)"]
[null,null,null,97,13,2,85,null,5,"A_alg - piirkonna esimese lahtri nimi (baaslahter)"]
[null,null,null,42,77,24,28,null,6]
[]
[-2,-1,0,1,2,3,4,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T.Cells(rn, tn) ="]
[null,null,"rivi",{"$f":"r_1-2","v":3},5,"T(3, 3) = 64",null,null,null,"Tabeli sidumine muutujaga"]
[null,null,"tulp",{"$f":"t_1-2","v":3},5,null,null,null,null,"Set T = Range(\"Tab_A\")"]
[null,null,"sisu",64,"VBA",null,null,null,null,"Set T = Range(\"A_alg\").CurrentRegion"]
[null,null,"sisu",{"$f":"INDEX(Tab_A, rivi, tulp)","v":64},"Excel",null,null,null,null,"Set T = Range(\"A_alg\") - baaslahter"]
[null,null,null,"=INDEX(Tab_A; rivi; tulp)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,2,3,4,5,6,null,"nr"]
[null,"V",13,-21,7,75,35,13,null,4]
[]
[null,null,1,"Kask",null,null,null,null,null,"V(4)"]
[null,null,2,"Saar"]
[null,null,3,"Paju"]
[null,null,4,"Haab",null,"k"]
[null,null,5,"Mänd",null,1,"NV(1)"]
[null,null,6,"Kuusk"]

{"sheet":"Offset","index":19,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Offset-omadus"]
[null,"määratleb sama mõõtmetega lahtriploki, mis on nihutatud antud lahtriploki alguse suhtes"]
[null,"piirkond.Offset (rivinihe, tulbnihe)"]
[null,"rivinihe, tulbanihe - rivi ja tulba nihe lahtriploki alguse suhtes"]
[null,"algus - 0, 0"]
[null,"NB! Võib ka nii"]
[null,"lahtriplokk.Offset(rivinihe)  = lahtriplokk.Offset(rivinihe, 0)"]
[null,"lahtriplokk.Offset( , tulbanihe) = lahtriplokk.Offset(0, tulbanihe)"]
[null,null,null,null,"Demo"]
[null,null,null,null,null,null,"ActiveCell.Offset(0, 0)"]
[null,null,3]
["reanihe",null,{"$f":"R_n-3","v":0},null,"Nimi","Tariif","Tunde","Palk","Maks","Saada"]
["tulbanihe",null,{"$f":"t_n-3","v":0},null,"Kask  P.",47,192,9024,1757.76,7266.24]
[null,null,3,null,"Kuusk V.",97,11,1067,0,1067]
[null,null,null,null,"Lepp M.",104,72,7488,1389.12,6098.88]
[null,"T.Offset(0, 0)",null,null,"Paju L.",62,153,9486,1868.64,7617.36]
[null,null,null,null,"Saar K.",15,118,1770,16.8,1753.2]
[null,null,null,null,"Tamm H.",56,59,3304,384.96,2919.04]
[null,null,null,null,"Vaher O.",72,129,9288,1821.12,7466.88]

{"sheet":"Resize","index":20,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Resize-omadus"]
[null,"võimaldab määratleda antud mõõtmetega (m * n) piirkonna"]
[null,"piirkonna esialgsed mõõtmed ei ole olulised, kui muudetakse mõlemaid"]
[null,"piirkond.Resize(m, n)"]
[null,"Võib ka nii:"]
[null,"piirkond.Resize(m)",null,null,null,null,"piirkond.Resize(, n)"]
[null,"tulpade arv jääb samaks",null,null,null,null,"rivide arv jääb samaks"]
[]
[null,"ridu",4]
[null,"veerge",3,null,null,"Demo"]
[]
[null,null,null,null,2,88,22,35,40,84]
[null,null,null,null,15,84,84,88,55,58]
[null,null,null,null,0,35,21,3,92,41]
[null,null,null,null,2,25,6,60,52,61]
[null,null,null,null,26,29,11,47,69,86]
[null,null,null,null,83,27,50,86,18,91]
[null,null,null,null,97,19,17,96,15,8]
[null,null,null,null,54,40,92,17,71,12]

{"sheet":"Teg_mat","index":21,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"DEMO"]
[null,"Tegevused tabelitega (maatriksitega)"]
[null,null,null,null,null,null,null,"aeg_1","aeg_2"]
[null,null,null,null,null,null,null,0.80859375,1.23046875]
[null,null,null,null,"lahter tabelisse"]
[null,"rivid","tulbad",null,"mini","maxi",null,"kesk"]
[null,10000,100,null,-100,100,null,50.485930475272959]

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