{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Alg","Sisukord","Index_1","Index_2","abi","Index_3","Korterid","Üldpõhimõtted","LOOKUP","Sõnad","VLOOKUP","MATCH","MATCH_D","Ind_Mats_1","Värvid","Fukts","Ind_Mats_Tab","Vahemik","Komisjoon","Ind_Mats_Tab_1","Sheet2"],"not_rendered":{"charts":1,"images":13,"macros":1,"external_links":0,"defined_names":99,"comments":6,"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":"Alg","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Otsimis- ja viitamisfunktsioonid"]

{"sheet":"Sisukord","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioon INDEX - üldpõhimõtted"]
[null,"Funktsioon INDEX - näited 1"]
[null,"Funktsioon INDEX - näited 2"]
[null,"Andmed korterite kohta"]
[null,"Otsimise üldpõhimõtted"]
[null,"Funktsioon LOOKUP"]
[null,"Funktsioon VLOOKUP"]
[null,"Funktsioon MATCH"]
[null,"Funktsiooni MATCH tööpõhimõte. Demo"]
[null,"Funktsioonide INDEX ja MATCH kooskasutamine. Paralleelsed vektorid"]
[null,"Funktsioonide ekstreemumite ja nende asukohtade leidmine"]
[null,"Funktsioonide INDEX ja MATCH kooskasutamine. Tabel"]
[null,"Vahemiku otsimine"]
[null,"Harjutus \"Komisjonitasu\""]
[null,"Otsimine kahes suunas. INDEX & MATCH ja VLOOKUP. "]

{"sheet":"Index_1","index":2,"n_rows":20,"n_cols":16,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,1,4,6],[5,1,5,6],[8,1,8,8]]}
[null,null,null,null,"veeb",null,null,null,null,null,"nimed",null,1,2,3,4]
[null,"Funktsioon INDEX",null,null,null,null,null,null,{"$f":"INDEX(nimed,3)","v":"paju"},1,"kask",1,21,17]
[null,null,null,null,null,null,null,null,null,2,"saar",2,-5,63]
[null,null,null,null,null,null,null,null,"V(k) = V[k]",3,"paju",3]
[null,"INDEX (vektor; indeks)",null,null,null,null,null,"Vk = INDEX(V; k)",null,null,null,4]
[null,"INDEX (tabel; riviindeks; tulbaindeks)",null,null,null,null,null,"Ti, j = INDEX(T; i; j)",null,5,null,5]
[null,null,null,null,null,null,null,null,"T(i, j) = T[i, j]",6,null,6]
[null,null,null,null,null,{"$f":"otsi(liik, liigid)","v":{"$error":"#NAME?"}},null,null,null,7]
[null,null,null,null,null,null,null,null,null,8]
[]
[null,null,"Vektor V",null,null,null,null,null,"k","Vk"]
[null,null,13,-27,65,89,-24,null,1,{"$f":"INDEX(V, k)","v":13}]
[null,"k",1,2,3,4,5,null,null,"=INDEX(V; k)"]
[]
[null,null,"Maatriks A  (4*3)",null,null,"i"]
[null,null,13,4,5,1]
[null,null,7,21,-5,2,"i","j","Ai, j"]
[null,null,-9,33,5,3,{"$f":"4-abi+1","v":1},1,{"$f":"INDEX(A, i, j)","v":13}]
[null,null,8,17,12,4,4,null,"=INDEX(A; i; j)"]
[null,"j",1,2,3]

{"sheet":"Index_2","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsiooni INDEX kasutamine"]
[]
[null,"Leida kuu numbrile vastav kuu nimi"]
[null,"lehel abi on vektor kuude nimedega"]
[]
[null,"nr","kuu nimi"]
[null,12,{"$f":"INDEX(kuud, nr)","v":"detsember"}]
[]
[]
[null,"Leida kuupäevale vastav kuu nimi ja nädalapäeva nimi"]
[]
[null,"kuupäev","kuu nimi","päeva nimi"]
[null,{"$f":"TODAY()","v":"2013-11-11"},{"$f":"INDEX(kuud, MONTH(kuupäev))","v":"november"},{"$f":"INDEX(päevad, WEEKDAY(kuupäev, 2))","v":"esmaspäev"}]
[]
[]
[]
[null,"Palgaarvestus",null,"Tariif leida lehel abi olevast vektorist"]
[]
[null,"Nimi","kat","tunde","tariif","Palk"]
[null,"U. Saar",3,132,{"$f":"INDEX(tariifid, kat)","v":9.6},{"$f":"tariif * tunde","v":1267.2}]
[null,"H. Kask",2,143,{"$f":"INDEX(tariifid, kat)","v":6.8},{"$f":"tariif * tunde","v":972.4}]
[null,"E. Tamm",6,137,{"$f":"INDEX(tariifid, kat)","v":14.2},{"$f":"tariif * tunde","v":1945.3999999999999}]
[null,"U. Paju",10,135,{"$f":"INDEX(tariifid, kat)","v":25.6},{"$f":"tariif * tunde","v":3456}]
[null,"K. Lepp",5,68,{"$f":"INDEX(tariifid, kat)","v":12.6},{"$f":"tariif * tunde","v":856.8}]

{"sheet":"abi","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"päevad",null,"kuud",null,"kateg","tariifid"]
[null,"esmaspäev",null,"jaanuar",null,1,3.8]
[null,"teisipäev",null,"veebruar",null,2,6.8]
[null,"kolmapäev",null,"märts",null,3,9.6]
[null,"neljapäev",null,"aprill",null,4,10.8]
[null,"reede",null,"mai",null,5,12.6]
[null,"laupäev",null,"juuni",null,6,14.2]
[null,"pühapäev",null,"juuli",null,7,17]
[null,null,null,"august",null,8,18.8]
[null,null,null,"september",null,9,21.8]
[null,null,null,"oktoober",null,10,25.6]
[null,null,null,"november"]
[null,null,null,"detsember"]

{"sheet":"Index_3","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsiooni INDEX kasutamine"]
[]
[null,"Leida korteri numbri järgi tabelist Korterid",null,"Korterid"]
[null,"omaniku nimi, inimeste arv ja korteri pindala"]
[]
[null,"Kaks varianti:"]
[null,"1) eraldi nimi igal tulbal,"]
[null,"2) üks nimi tervel tabelil"]
[]
[null,"krt",1]
[null,"omanik",{"$f":"INDEX(Omanik, krt)","v":"A. Kask"},{"$f":"INDEX(korterid, krt +1, 2)","v":"A. Kask"}]
[null,"inimesi",{"$f":"INDEX(Inimesi, krt)","v":3},{"$f":"INDEX(korterid, krt +1, 4)","v":3}]
[null,"pind",{"$f":"INDEX(Pindala, krt)","v":65.3},{"$f":"INDEX(korterid, krt +1, 3)","v":65.3}]
[null,null,"Variant 1","Variant 2"]

{"sheet":"Korterid","index":6,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Korterid"]
[null,1,2,3,4]
[1,"Number","Omanik","Pindala","Inimesi"]
[2,1,"A. Kask",65.3,3]
[3,2,"P. Lepp",74.5,2]
[4,3,"K. Mänd",65.3,5]
[5,4,"L. Tamm",42.6,2]
[6,5,"H. Kuusk",74.5,1]
[7,6,"O. Palm",63.7,2]
[8,7,"V. Tamm",45.6,3]
[9,8,"S. Mets",82.4,5]
[10]

{"sheet":"Üldpõhimõtted","index":7,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,1,35,1],[34,2,34,4],[19,10,19,12]]}
[null,null,null,null,null,"veeb"]
[]
[null,null,null,null,null,null,null,null,null,null,"VLOOKUP(otsitav; tabel; v_nr [; tunnus])"]
[null,null,null,null,null,null,null,null,null,"Hinnakiri"]
[null,null,null,null,null,null,null,null,null,"liigid","hinnad",null,"liik","hind"]
[null,null,null,null,null,null,null,null,null,"tamm",230,null,"mänd",{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":150}," =VLOOKUP(liik; Hinnakiri; 2; 0)"]
[null,null,null,null,null,null,null,null,null,"vaher",220,null,null,{"$f":"VLOOKUP(liik, Hinnakiri[], 2)","v":150}," =VLOOKUP(liik; Hinnakiri; 2)"]
[null,null,null,null,null,null,null,null,null,"saar",210]
[null,null,null,null,null,null,null,null,null,"kuusk",160]
[null,null,null,null,null,null,null,null,null,"mänd",150]
[null,null,null,null,null,null,null,null,null,"kask",120]
[null,null,null,null,null,null,null,null,null,"lepp",110]
[null,null,null,null,null,null,null,null,null,"haab",76]
[null,null,null,null,null,null,null,null,null,"paju",76]
[]
[null,null,null,null,null,null,null,null,null,"Otsimistabelite näiteid"]
[null,null,null,null,null,null,null,null,null,"Koodi järgi võib otsida nimetust, hinda ja ühikute arvu pakendis"]
[null,null,null,null,null,null,null,null,null,"Nimetuse järgi võib otsida koodi, hinda ja ühikute arvu pakendis"]
[null,null,null,null,null,null,null,null,null,"kood","kaup",null,null,"hind"]
[null,"Hinnakiri. Puidu hind sõltub läbimõõdust",null,null,null,null,null,null,null,214073,{"$f":"VLOOKUP(J20, Kaubad_1, 2, 0)","v":"FETAKI juust 500 g"},null,null,{"$f":"VLOOKUP(kood1, Kaubad_1, 6, 0)","v":1.82}]
[null,"Vahemiku otsimine"]
[null,null,null,null,null,null,null,null,null,"kood","kaup",null,null,"pakendis","hind"]
[null,"vahemik",null,"piirid","hinnad",null,"läbimõõt","hind",null,214003,"ARLA Juust Kvibille Grädd.140g",null,null,10,1.24]
[null,"< 10",null,0,44,null,19,{"$f":"VLOOKUP(d, P_hind[], 2)","v":52},null,214004,"ARLA Juust Kvibille Grädd.3kg",null,null,1,22.91]
[null,"10 – 14",null,10,48,null,null,null,null,214002,"Dor Blue juust 50% 100 g",null,null,5,0.92]
[null,"15 - 19",null,15,52,null,null,null,null,214073,"FETAKI juust 500 g",null,null,24,1.82]
[null,"20 – 24",null,20,55,null,null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",null,null,1,5.85]
[null,"25 – 29",null,25,58,null,null,null,null,214071,"Juust Camembert 125 g",null,null,24,2.0699999999999998]
[null,">= 30",null,30,56,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",null,null,1,5.85]
[]
[]
[]
[null,"Hinnakiri. Puidu hind sõltub liigist ja läbimõõdust",null,null,null,null,null,null,null,"Hinnakiri. Puidu hind sõltub liigist ja läbimõõdust"]
[]
[null,"Liik","Sort",null,null,null,null,null,null,"<10","10-14","15-19","20-24","25-29",">=30"]
[null,null,1,2,3]
[null,"haab",50,{"$f":"0.9*C37","v":45},{"$f":"0.8*C37","v":40},null,null,null,"Liigid",0,10,15,20,25,30]
[null,"kask",70,{"$f":"0.9*C38","v":63},{"$f":"0.8*C38","v":56},null,null,null,"haab",12,17,19,24,25,25]
[null,"kuusk",80,72,64,null,null,null,"kask",15,23,27,32,33,33]
[null,"küte",47,42.300000000000004,37.6,null,null,null,"kuusk",29,32,35,37,39,38]
[null,"lepp",65,58.5,52,null,null,null,"mänd",32,35,38,41,43,42]
[null,"mänd",75,67.5,60,null,null,null,"saar",34,36,41,44,45,45]
[null,"saar",85,76.5,68,null,null,null,"tamm",40,45,50,57,60,73]
[null,"tamm",110,99,88,null,null,null,"vaher",36,40,43,45,47,53]
[null,"vaher",95,85.5,76]
[]
[null,null,null,null,null,null,null,null,null,"liik","läbimõõt","hind"]
[null,"Liik","sort","hind",null,null,null,null,null,"tamm",23,{"$f":"VLOOKUP(liik_1, P_hind1, MATCH(läbimõõt, mõõdud)+1, 0)","v":57}]
[null,"lepp",2,{"$f":"VLOOKUP(liik_2, P_hind2, sort+1, 0)","v":58.5}]

{"sheet":"LOOKUP","index":8,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsioon LOOKUP"]
[]
[null,"LOOKUP(otsitav; vek_1; vek_2)"]
[null,"Otsib otsitavale vastavat väärtust vektorist vek_1 ning "]
[null,"tagasrtab sama numbriga väärtuse vektorist vek_2"]
[null,"kui otsitavaga võrdset väärtust ei ole, loetakse vastavaks otsitavale lähim väikseim väärtus"]
[null,"Väärtused vektoris vek_1 peavad olema kasvamise järjekorras!"]
[null,"NB! Ei võimalda määrata otsimisviisi. Sobib peamiselt vahemiku otsimiseks!"]
[]
[null,"\"Sõnaraamat\""]
[null,"Leida eestikeelsele sõnale ingliskeelne vaste"]
[null,"Sõnad om lehel \"Sõnad\" tulpades \"eesti\" ja \"inglise\""]
[]
[null,"eesti","inglise"]
[null,"elevant",{"$f":"LOOKUP(est, eesti, inglise)","v":"elephant"}]

{"sheet":"Sõnad","index":9,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"eesti","inglise"]
[null,"ahv","monkey"]
[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":"VLOOKUP","index":10,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsioon VLOOKUP"]
[]
[null,"VLOOKUP (otsitav; tabel; t_tulp; otsimisviis)",null,null,null,"Koodid","Nimetus","Pakendis","Hind"]
[null,"Otsimine vertikaalses tabelis",null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,"Otsib väärtust tabeli esimesest tulbast ",null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.48]
[null,"t_tulp - tabeli tulba number, kust võetakse tagastatav väärtus",null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,"otsimisviis - ei ole kohustuslik, vaikimisi - 1 või True",null,null,null,214073,"FETAKI juust 500 g",24,2.19]
[null,"0 või False - kindla väärtuse otsimine",null,null,null,214071,"Juust Camembert 125 g",24,2.48]
[null,"1 või True  - vahemiku otsimine",null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7.02]
[null,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7.02]
[null,"Leida koodi järgi kauba hind ja nimetus tabelist Kaubad",null,null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.49]
[null,"kood","hind","Nimetus"]
[null,214003,{"$f":"VLOOKUP(kood, Kaubad, 4, 0)","v":1.48},{"$f":"VLOOKUP(kood, Kaubad, 2, 0)","v":"ARLA juust Kvibille Grädd.140g"}]
[]
[null,"Funktsioon HLOOKUP"]
[null,"HLOOKUP (otsitav; tabel; t_rivi; otsimisviis)"]
[null,"Otsimine horisontaalses tabelis"]
[null,"Otsib väärtust tabeli esimesest rivist"]
[null,"t_rivi - tabeli rivi number, kust võetakse tagastatav väärtus"]
[null,"otsimisviis - sama nagu VLOOKUP'is"]

{"sheet":"MATCH","index":11,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"Funktsioon MATCH",null,null,"Iseseisvalt harva. Sageli koos funktsiooniga INDEX."]
[]
[null,"MATCH (otsitav; vektor; otsimisviis)"]
[null,"Leiab otsitava väärtuse järjenumbri antud vektoris"]
[null,"otsimisviis - ei ole kohustuslik. Võib olla 0 või 1. Kui puudub võetakse 1."]
[null,"0 - kindla väärtuse otsimine - järjestus vektoris suvaline"]
[null,"kui otsitavaga võrdset väärtust ei ole, tagastab veateate #N/A"]
[null,"1 - vahemiku otsimine - väärtused vektoris peavad olema kasvamise järjekorras"]
[null,"kui otsitavaga võrdset väärtust ei ole, tagastab lähima väikseima otsitavala"]
[]
[null,null,null,null,null,null,"koht","nimi","punkte"]
[null,"Leida võistleja koht ja punktide arv",null,null,null,null,1,"Kask",360]
[null,"kõrvalolevast tabelist",null,null,null,null,2,"Saar",322]
[null,"võistleja","koht","punkte",null,null,3,"Paju",301]
[null,"Kuusk",{"$f":"MATCH(võistleja, nimi, 0)","v":5},{"$f":"INDEX(punkte, koht)","v":270},null,null,4,"Tamm",280]
[null,null,null,null,null,null,5,"Kuusk",270]
[null,null,null,null,null,null,6,"Mänd",265]
[]
[null,"Leida kuu nimetuse järgi selle järjenumber"]
[null,"kuu nimetus","kuu number"]
[null,"märts",{"$f":"MATCH(B22, kuud)","v":8},"???"]
[]
[]
[null,"Leida korteri omaniku järgi korteri number,"]
[null,"korteri pindala ja inimeste arv (tabel lehel Korterid)"]
[]
[null,"Omanik","Korter","Pindala","Inimesi"]
[null,"H. Kuusk",{"$f":"MATCH(B29, Omanik, 0)","v":5},{"$f":"INDEX(Pindala, Korter)","v":74.5},{"$f":"INDEX(Inimesi, Korter)","v":1}]

{"sheet":"MATCH_D","index":12,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsiooni MATCH tööpõhimõte"]
[null,"Kindla väärtuse otsimine"]
[null,"Leiab otsitava järjenumbri antud vektoris"]
[]
[]
[]
[null,"k","Liigid"]
[null,1,"saar"]
[null,2,"kask"]
[null,3,"paju",null,null,"liik","nr"]
[null,4,"kuusk",null,null,"tamm",7]
[null,5,"jalakas"]
[null,6,"vaher"]
[null,7,"tamm"]
[null,8,"mänd"]
[null,9,"haab"]

{"sheet":"Ind_Mats_1","index":13,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]
[null,"INDEX & MATCH"]
[null,"Otsimine paralleelsetes vektorites"]
[]
[null,"INDEX(vek_2; MATCH(otsitav; vek_1; OV))"]
[null,"OV - otsimisviis - 0  või 1"]
[null,"MATCH leiab otsitava väärtusele vastava järjenumbri vek_1-s"]
[null,"INDEX tagastab leitud numbriga väärtuse vek_2-st"]
[null,"vrdl."]
[null,"LOOKUP(otsitav; vek_1; vek_2)"]
[null,"NB! Ei võimalda määrata otsimisviisi"]
[null,"vektor_1 peab olema sorditud väärtuste kasvamise järjekorras"]
[]
[null,"Leida korteri omaniku järgi pindala ja inimeste arv"]
[null,"korterid",null,null,null,null,null,"Koodid","Nimetused","Pakendis","Hinnad"]
[null,"Omanik","pind","inimesi",null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,"K. Mänd",{"$f":"INDEX(Pindala, MATCH(omanik_K, Omanik,0))","v":65.3},{"$f":"INDEX(Inimesi, MATCH(omanik_K, Omanik,0))","v":5},null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.48]
[null,null,null,null,null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,null,null,null,null,null,null,214073,"FETAKI juust 500 g",24,2.19]
[null,null,null,null,null,null,null,214071,"Juust Camembert 125 g",24,2.48]
[null,"Leida värvi kogus ja maksumus korterite lagede värvimiseks",null,null,null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7.02]
[null,"korter","värv","kogus","maksumus",null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7.02]
[null,1,"VL_09",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":35.914999999999999},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":188.19460000000001},null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.49]
[null,2,"VL_06",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":33.524999999999999},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":138.45824999999999}]
[null,3,"VL_13",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":33.956000000000003},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":122.24160000000002}]
[null,4,"VL_02",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":20.448},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":89.97120000000001},null,null,"Leida nimetuse alusel kauba kood ja hind"]
[null,5,"VL_11",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":35.76},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":148.04639999999998}]
[null,6,"VL_11",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":30.576000000000001},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":126.58463999999999},null,null,null,"Nimetus","Kood","Hind"]
[null,7,"VL_02",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":21.887999999999998},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":96.307199999999995},null,null,null,"Juust Atleet viil vaakumis (ca 150 g)",{"$f":"INDEX(Koodid, MATCH(Nimetus, Nimetused,0))","v":214157},{"$f":"INDEX(Hinnad, MATCH(Nimetus, Nimetused,0))","v":7.02}]
[null,8,"VL_11",{"$f":"INDEX(Pindala, korter) * INDEX(v_kulu, MATCH(värv, v_mark, 0))","v":39.552},{"$f":"INDEX(v_hind, MATCH(värv, v_mark, 0))*kogus","v":163.74527999999998}]

{"sheet":"Värvid","index":14,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Värvide hinnakiri"]
[]
[null,"v_mark","v_kulu","v_hind","v_tootja"]
[null,"VL_13",0.52,3.6,"Sadolin"]
[null,"VL_30",0.47,3.92,"Kessu"]
[null,"VL_01",0.52,3.98,"JukuColor"]
[null,"VL_25",0.42,4.08,"Kessu"]
[null,"VL_06",0.45,4.13,"JukuColor"]
[null,"VL_11",0.48,4.1399999999999997,"JukuColor"]
[null,"VL_02",0.48,4.4000000000000004,"Sadolin"]
[null,"VL_21",0.39,5.17,"Sadolin"]
[null,"VL_09",0.55000000000000004,5.24,"JukuColor"]
[null,"VL_05",0.65,5.29,"JukuColor"]
[null,"VL_32",0.55000000000000004,8.23,"Kessu"]

{"sheet":"Fukts","index":15,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsioonide ekstreemumite ja nende asukohtade leidmine"]
[null,"Koostada valemid, mis leivad fumktsiooni Y maksimumi"]
[null,"ja funktsioni Z miinimumi ja nende asukohad"]
[null,"algus","samm","lõpp",null,"Ymax","koht","Zmin","koht","integ Y","baas","lisa","pind Z"]
[null,{"$f":"baas + lisa","v":-15},1,{"$f":"algus + (COUNT(x) -1)*samm","v":0},null,{"$f":"MAX(y)","v":2.9297341846998819},{"$f":"INDEX(x, MATCH(Ymax, y, 0))","v":-13},{"$f":"MIN(z)","v":-4.4081223204531774},{"$f":"INDEX(x, MATCH(Zmin, z, 0))","v":-14},null,-50,35]
[]
[]
[null,"x","Y","Z"]
[null,{"$f":"algus","v":-15},{"$f":"3 * SIN(x + 2) * COS(x / 2)","v":-0.43693420306261099},{"$f":"IF(x < 0, 5 * COS(2 * x - 3)*SIN(3*x+3),   3 * SIN(x + 1)*COS(x/2))","v":-6.0842124580815331E-2}]
[null,{"$f":"B10+samm","v":-14},1.2135705975002791,-4.4081223204531774]
[null,-13,2.9297341846998819,-3.7095381955222315]
[null,-12,1.5670587179594901,1.4605652982528563]
[null,-11,-0.87616774175259482,4.8966986200543952]
[null,-10,-0.84193056732976213,2.5479433725296423]
[null,-9,0.41547004587670799,-2.4800588314849641]
[null,-8,-0.54791447390446779,-4.1360264682625765]
[null,-7,-2.6939731488413168,-1.0332207882793638]
[null,-6,-2.2476863752900278,2.4700790602321545]
[null,-5,0.33917218044928332,2.4345568372641733]
[null,-4,1.1352037429618924,-9.1195597548648973E-3]
[null,-3,-0.1785699082496302,-1.2729195802431239]
[null,-2,0,-0.53195346104639607]
[null,-1,2.2153807878123861,0]
[null,0,2.7278922804770449,2.5244129544236893]

{"sheet":"Ind_Mats_Tab","index":16,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"veeb"]
[null,"INDEX & MATCH"]
[null,"Otsimine vertikaalses tabelis "]
[]
[]
[null,"INDEX(tabel; MATCH(otsitav; v_tulp; OV); t_tulp)"]
[null,"MATCH leiab otsitava väärtusele vastava järjenumbri (jnr) tulbas v_tulp"]
[null,"v_tulp - võtmete tulp tabelis (tavaliselt 1. tulp)"]
[null,"INDEX tagastab väärtuse lahtrist tabel(jnr, t_tulp) "]
[null,"t_tulp - tulba number, kust võetakse tagastatav väärtus"]
[]
[null,"Võrdluseks funktsioon VLOOKUP"]
[]
[null,"VLOOKUP(otsitav; tabel; t_tulp; OV)"]
[]
[null,"Leida tabelist Värvid värvi hind ja kulu, kasutades "]
[null,"funktsioone INDEX ja MATCH otsimiseks tabelis"]
[]
[null,"Värv","Hind","Kulu",null,null,null,"Koodid","Nimetused","Pakendis","Hinnad"]
[null,"VL_13",{"$f":"INDEX(Värvid, MATCH(Värv, v_mark, 0) + 1, 3)","v":3.6},{"$f":"INDEX(Värvid, MATCH(Värv, v_mark, 0) + 1, 2)","v":0.52},null,null,null,214002,"Dor Blue juust 50% 100 g",5,1.1000000000000001]
[null,null,null,null,null,null,null,214003,"ARLA juust Kvibille Grädd.140g",10,1.5]
[null,"Näide",null,null,null,null,null,214006,"Juust ROSENBORG sinihallitus 125g",8,2]
[null,"Leida tabelist Juustud nimetuse järgi kauba kood ja hind",null,null,null,null,null,214073,"FETAKI juust 500 g",24,2.2000000000000002]
[null,"Nimetus","kood","hind",null,null,null,214071,"Juust Camembert 125 g",24,2.5]
[null,"FETAKI juust 500 g",{"$f":"INDEX(Juustud, MATCH(Nimetus, Nimetused, 0)+1, 1)","v":214073},{"$f":"INDEX(Juustud, MATCH(Nimetus, Nimetused, 0)+1, 4)","v":2.2000000000000002},null,null,null,214157,"Juust Atleet viil vaakumis (ca 150 g)",1,7]
[null,null,null,null,null,null,null,214158,"Juust Eesti viil vaakumis (ca 150 g)",1,7]
[null,null,null,null,null,null,null,214004,"ARLA juust Kvibille Grädd.3kg",1,27.5]

{"sheet":"Vahemik","index":17,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,5,11,6]]}
[]
[null,"Vahemiku otsimine"]
[null,"Funktsioonide LOOKUP ning INDEX ja MATCH kasutamine vahemiku otsimiseks"]
[null,"Kauba hind sõltub ostetavast kogusest"]
[null,"kogus - K","hind"]
[null,"1 <= K < 5",60]
[null,"5 <= K < 15",58]
[null,"15 <= K < 25",56]
[null,"25 <= K < 35",54]
[null,"35 <= K < 45",52]
[null,"45 <= K  < 50",50]
[null,"K  >= 50",48,null,null,"Otsimistabel"]
[]
[null,"kogus - K","hind","piirid",null,"piirid","hinnad"]
[null,"1 <= K < 5",60,1,null,1,60]
[null,"5 <= K < 15",58,5,null,5,58]
[null,"15 <= K < 25",56,15,null,15,56]
[null,"25 <= K < 35",54,25,null,25,54]
[null,"35 <= K < 45",52,35,null,35,52]
[null,"45 <= K  < 50",50,45,null,45,50]
[null,"K  >= 50",48,50,null,50,48]
[]
[null,null,null,"LOOKUP","INDEX/MATCH","IF"]
[null,null,"kogus","hind","hind","hind"]
[null,null,25,{"$f":"LOOKUP(kogus, piirid, hinnad)","v":54},{"$f":"INDEX(hinnad, MATCH(kogus, piirid))","v":54},{"$f":"IF(kogus<$F$16, $G$15, IF(kogus<$F$17, $G$16, IF(kogus<$F$18, $G$17, IF(kogus<$F$19, $G$18, IF(kogus<$F$20, $G$19, IF(kogus<$F$21, $G$20, $G$21))))))","v":54}]
[null,null,3,60,60,60]
[null,null,13,58,58,58]
[null,null,37,52,52,52]
[null,null,60,48,48,48]
[null,null,26,54,54,54]
[]
[" =IF(kogus<$F$16; $G$15; IF(kogus<$F$17; $G$16; IF(kogus<$F$18; $G$17; IF(kogus<$F$19; $G$18; IF(kogus<$F$20; $G$19; IF(kogus<$F$21; $G$20; $G$21))))))"]

{"sheet":"Komisjoon","index":18,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Komisjoni tasu leidmine"]
[]
[null,"Nimi","Läbimüük","Protsent","Tasu",null,"kogused","protsendid"]
[null,"Kaasik",3240,{"$f":"LOOKUP(Läbimüük, kogused, protsendid)","v":0.1},{"$f":"Protsent *Läbimüük","v":324},null,0,0.03]
[null,"Kuusik",690,{"$f":"LOOKUP(Läbimüük, kogused, protsendid)","v":0.03},{"$f":"Protsent *Läbimüük","v":20.7},null,1000,7.0000000000000007E-2]
[null,"Tammik",6320,{"$f":"LOOKUP(Läbimüük, kogused, protsendid)","v":0.13},{"$f":"Protsent *Läbimüük","v":821.6},null,2500,0.1]
[null,"Lepik",2700,{"$f":"LOOKUP(Läbimüük, kogused, protsendid)","v":0.1},{"$f":"Protsent *Läbimüük","v":270},null,4000,0.13]
[null,"Männik",1830,{"$f":"LOOKUP(Läbimüük, kogused, protsendid)","v":7.0000000000000007E-2},{"$f":"Protsent *Läbimüük","v":128.10000000000002}]

{"sheet":"Ind_Mats_Tab_1","index":19,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Otsimine kahes suunas. INDEX & MATCH ja VLOOKUP. "]
[]
[null,"INDEX(tabel; MATCH(otsitav1; v_tulp; OV1); MATCH(otsitav2; v_rivi; OV2);)"]
[null,"Esimene MATCH leiab otsitava1 väärtusele vastava rivinumbri - m"]
[null,"Teinene MATCH leiab otsitava2 väärtusele vastava tulbanumbri - n"]
[null,"v_tulp - võtmete tulp tabelis, v_rivi - võtmete rivi tabelis "]
[null,"INDEX tagastab väärtuse lahtrist tabel(m, n) "]
[]
[null,"Sama funktsiooniga VLOOKUP"]
[null,"VLOOKUP(otsitav1; tabel; MATCH(otsitav2; v_rivi; OV2); OV1)"]
[]
[null,"Näide. Leida puidu hind sõltuvalt liigist ja läbimõõdust"]
[]
[null,"liik","d","hind I & M","hind VL"]
[null,"lepp",13,{"$f":"INDEX(P_hinnad, MATCH(liik, P_liigid, 0)+1, MATCH(d, P_diam, 1)+1)","v":49},{"$f":"VLOOKUP(liik, P_hinnad, MATCH(d, P_diam, 1)+1, 0)","v":49}]
[]
[]
[null,null," 5 - 10","10-14","15-19","20-24","25-29",">=30"]
[]
[null,"Liigid",5,10,15,20,25,30]
[null,"haab",34,38,42,46,50,53]
[null,"kask",47,53,58,64,71,74]
[null,"kuusk",54,60,67,73,81,85]
[null,"lepp",44,49,54,60,66,69]
[null,"mänd",51,56,63,69,76,79]
[null,"saar",57,64,71,78,86,90]
[null,"tamm",74,83,92,101,111,117]
[null,"vaher",64,71,79,87,96,101]

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