{"text_format":"1","workbook":"xlsx","n_sheets":22,"sheets":["Tiitel","Sisukord","M_omadused","Maat_Lug_Kir","Demo","abi","ÜP_1","Andmed","Prog","Ü1_Liides","Mat_Vek","Liida","Maks_RV","Pos_Kesk","ÜP_2","Ruutmaat","Ü2_And","Ü2_Prog","Ü2_Liides","Värvid","Funktsid","Tee"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":1,"defined_names":43,"comments":3,"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":13,"n_cols":17,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Massiivid VBAs"]
[]
[null,null,null,null,null,null,null,null,"Demo"]
[null,null,null,null,null,null,"Võrrandsüsteemi lahendamine"]
[null,null,null,null,null,null,null,null,"A * x = b"]
[null,null,null,"A",null,null,null,null,null,null,null,null,null,null,"b",null,"x"]

{"sheet":"Sisukord","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Massiivide põhiomadused ja määratlemine"]
[null,"Fikseeritud ühemõõtmelised massiivid"]
[null,"Dünaamilised ühemõõtmelised massiivid"]
[null,"Kahe- ja ühemõõtmelised dünaamilised massiivid"]
[null,"Massiivide lugemine töölehelt ja kirjutamine töölehele"]
[null,"Maatriksi lugemise ja kirjutamise demo"]
[null,"Vektorite kirjutamine ja lugemine "]
[null,"Abiprotseduurid massiivide loomiseks töölehel"]
[null,"Ülesanne 1. Ülesande püstitus"]
[null,"Andmed töölehel ja peaprotseduuris"]
[null,"Protseduurid"]
[null,"Ülesanne 1. Kasutajaliides"]
[null,"Protseduur Mat_Vek() - maatriksi korrutamine vektoriga"]
[null,"Vektori liitmine maatriksi veergudele"]
[null,"Maksimaalse elemendi ja selle asukoha leidmine maatriksis"]
[null,"Positiivsete elementide aritmeetilise keskmise maatriksi reas"]
[null,"Ülesanne 2. Ülesande püstitus"]
[null,"Ruutmaatriksi põhielemendid"]
[null,"Andmed"]
[null,"Programmi põhiprotseduurid"]
[null,"Ülesanne 2. Liides"]
[null,"Protseduur Värvi"]
[null,"Funktsioonid maxi ja mini veergude leidmiseks"]
[null,"Uue maatriksi loomine"]

{"sheet":"M_omadused","index":2,"n_rows":21,"n_cols":20,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"X","ühemõõtmeline massiiv: jada, vektor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,6,7,-5,32,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,2,"...","i",null,"n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"X(0)","X(1)","X(2)","... ","X(i)","...","X(n)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","kahemõõtmeline massiiv: tabel, maatriks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,-15,-48,-54,-65,-99,-96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,-69,-6,-92,-5,-41,-32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"...",-60,-77,-95,-39,-87,-92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"i",-30,-48,-90,-30,-26,-17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"...",-56,-15,-66,-36,-41,-13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"m",-80,-19,-20,-45,-41,-31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,"...","j","...","n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,"A(1, 1)","A(1, 2)","...","A(1, j)","...","A(1, n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2,"A(2, 1)","A(2, 2)","...","A(2, j)","...","A(2, n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"..."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"i","A(i, 1)","A(i, 2)","...","A(i, j)","...","A(i, n)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"..."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"m","A(m, 1)","A(m, 2)","...","A(m, j)","...","A(m, n)"]

{"sheet":"Maat_Lug_Kir","index":3,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Massiivide lugemine töölehelt ja kirjutamine töölehele"]
[null,null,null,null,null,"Kahemõõtmelised massiivid"]
[null,"Lugemine töölehelt",null,null,null,null,null,null,null,"Kirjutamine töölehele"]
[null,"Peab olema teada ",null,null,null,null,null,null,null,"Peab olema teada "]
[null,"töölehe piirkond või selle algus",null,null,null,null,null,null,null,"töölehe piirkond või selle algus"]
[null,"rivide ja tulpade arv piirkonnas",null,null,null,null,null,null,null,"massiiv on olemas ja tema mõõtmed on teada"]
[null,"massiiv, kuhu loetakse piirkonna väärtused"]
[]
[null,null,null,null,null,null,null,"Kaks varianti"]
[null,"elementhaaval lugemine",null,null,null,null,null,null,null,"elementhaaval kirjutamine"]
[null,"piirkonna omistamine massiivile",null,null,null,null,null,null,null,"massiivi omistamine piirkonnale"]
[]
[null,"Elementhaaval lugemine",null,null,null,null,null,null,null,"Elementhaaval kirjutamine"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Piirkonna omistamine massiivile",null,null,null,null,null,null,null,"Massiivi omistamine piirkonnale"]
[null,"A = prk.Value",null,null,null,null,null,null,null,"prk.Value = A"]
[null,"NB! Umbes 15 - 20 korda kiirem",null,null,null,null,null,null,null,"NB! Umbes 70 - 80(!) korda kiirem!"]
[null," elementhaaval lugemisest"]
[]
[null,"Tüüpskeem piirkonna ja massiivi",null,null,null,null,null,null,null,null,"Tüüpskeem piirkonna määramiseks"]
[null," määramiseks ning lugemiseks",null,null,null,null,null,null,null,null,"ja massiivi kirjutamiseks"]
[null,"Eeldus - piirkonna esimesel lahtril nimi A_alg",null,null,null,null,null,null,null,null,"Eeldus - piirkonna esimesel lahtril nimi B_alg"]

{"sheet":"Demo","index":4,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Maatriksi lugemise ja kirjutamise demo"]
[]
[null,null,null,null,null,null,"Tööleht"]
[null,"elementhaaval",null,null,"omistamine",null,null,null,null,null,"VBA tööpiirkond. Maatriks (massiiv) A"]
[]
[null,41,7,16,-42,-40,null,null,null,null,41,7,16,-42,-40]
[null,55,-98,52,63,42,null,null,null,null,55,-98,52,63,42]
[null,-91,-17,73,58,-25,null,null,null,null,-91,-17,73,58,-25]
[null,93,75,-89,90,-27,null,null,null,null,93,75,-89,90,-27]
[null,5,54,-90,19,-6,null,null,null,null,5,54,-90,19,-6]
[null,-41,25,30,-47,-44,null,null,null,null,-41,25,30,-47,-44]
[null,66,65,18,98,83,null,null,null,null,66,65,18,98,83]
[]
[]
[]
[null,"elementhaaval",null,null,"omistamine"]
[]
[null,41,7,16,-42,-40]
[null,55,-98,52,63,42]
[null,-91,-17,73,58,-25]
[null,93,75,-89,90,-27]
[null,5,54,-90,19,-6]
[null,-41,25,30,-47,-44]
[null,66,65,18,98,83]

{"sheet":"abi","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Abiprotseduurid massiivide loomiseks töölehel"]
[]
[null,-79,-94,92,9,-20]
[null,82,-35,34,9,-68]
[null,50,-76,-43,79,95]
[null,-9,6,33,-25,-33]
[null,68,-74,-90,-35,-82]

{"sheet":"ÜP_1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Andmed","index":7,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Andmed töölehel"]
[]
[null,"Algandmed"]
[null,"Antud maatriks ja vektor"]
[null,"Tulemid"]
[null,"vektor - maatriksi ja vektori korrutis"]
[null,"maatriks, mille teatud veergudele on liidetud saadud vektor "]
[null,"maksimaalne element saadud maatriksis ning selle indeksid,"]
[null,"selle rea positiivsete elementide keskmine, kus asub maks"]
[]
[null,"Põhiandmed programmis"]
[null,"A(1...m, 1...n) - antud maatrks"]
[null,"B(1...n) - antud vektor"]
[null,"C(1...m) - saadud vektor"]
[null,"AU(1...m, 1...n) - saadud maatriks"]

{"sheet":"Prog","index":8,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduurid"]
[null,"Peaprotseduur Op_Mas_1()"]
[null,"määratleb muutujad ja massiivid"]
[null,"loeb töölehelt antud massiivid, kasutades protseduure Loe_Tab ja Loe_Tulp"]
[null,"käivitab alamprotseduurid, vajalike tegevuste täitmiseks"]
[null,"kirjutab tulemid töölehele"]
[null,"Protseduur Mat_Vek(A, b, c, m, n)"]
[null,"leiab maatriksi A korrutise vektoriga b, saades vektori c"]
[null,"Protseduur Liida_1(A, V, m, n)"]
[null,"liidab vektori V maatriksi A nendele veergudele, kus esimene element on negatiivne"]
[null,"Protseduur M_maks_rvn(A, m, n, maks, rn, vn)"]
[null,"leiab maksimaalse elemendi ja sellle asukoha maatriksis A"]
[null,"Funktsioon M_PosK_R(A, n, rn)"]
[null,"leiab positiivsete elementide aritmeetilise keskmise maatriksi A etteantud reas (rn)"]
[]
[null,"Protseduur Loe_Tab(A, m, n, prk)"]
[null,"loeb töölehele piirkonnast (prk) tabeli ja salvestab sellle maatrksis T"]
[]
[null,"Protseduur Kir_Tab(A, m, n, prk)"]
[null,"kirjutab töölehe piirkondat (prk) maatriksi T ja salvestab sellle maatrksis T"]
[]
[null,"Protseduur Loe_Tulp(V, n, prk)"]
[null,"loeb töölehe tulbast väärtused ja salvestab need vektoris V"]
[]
[null,"Protseduur Kir_Tulp(V, n, prk)"]
[null,"kirjutab töölehe tulpa vektori V"]

{"sheet":"Ü1_Liides","index":9,"n_rows":2,"n_cols":15,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"maks","rida","veerg","kesk"]

{"sheet":"Mat_Vek","index":10,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduur Mat_Vek(A, b, c, m, n)",null,null,null,null,null,null,"A(m * n), b(n), c(m)"]
[null,"Maatriksi korrutamine vektoriga"]
[null,"A",null,null,null,null,null,"b",null,"c"]
[1,3,-1,5,-3,2,null,3,1,-27,1]
[2,5,4,0,5,-6,null,1,"..",22,2]
["...",-4,7,2,3,5,null,-6,"j",2,"..."]
["i",5,-6,1,0,4,null,3,"...",11,"i"]
["...",-3,5,-6,5,7,null,2,"n",61,"..."]
["m",2,5,-6,7,-2,null,null,null,64,"m"]
[null,1,"...","j","..","n"]
[]
[]
[null,"i","j",null,"S",null,"Ai, j","bj","Ai, j * bj"]
[]
[]
[null,"Leida maatriksi iga rea skalaarkorrutis vektoriga"]
[null,"c1 = A1, 1 * b1 + A1, 2 * b2 + ... + A1, j * bj + ... + A1, n * bn"]
[null,"ci =  Ai, 1 *  b1 + Ai, 2 *  b2 + ... +  Ai, j * bj + ... + Ai, n * bn"]

{"sheet":"Liida","index":11,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vektori liitmine maatriksi veergudele, mille esimene element on negatiivne"]
[null,"Võimalik kaks varianti:"]
[null,"1) Muudatused tehakse antud maatriksis (A) - protseduur Liida_1"]
[null,"Vektor liidetakse maatriksi A vastavatele veergudele, teised veerud jäävad samaks"]
[null,"2) Loodakse uus maatriks (B) - protseduur Liida_2"]
[null,"Maatriksi B veerud, mis vastavad tingimusele, saadakse vektori liitmisega maatriksi A "]
[null,"vastavatele veergudele, teised veerud kopeeritakse maatriksist A maatriksisse B"]
[]
[null,"NB! Protseduuri Liida_1 saab kasutada ka siis, kui on vaja luua uus maatriks."]
[null,"Selleks kopeerida antud maatriks uude maatriksisse (vt prots Kopi_M) ja kasutada viimast argumendina "]
[null,"VBAs on lubatud omistada sama mõõtmetega massiiv otse teisele massiivile, näit B = A"]
[null,"NB! Protseduuri Liida_2 saab kasutada ka vektori liitmiseks antud maatriksi veergudele"]
[null,"Selleks peab pöördumisel parameetritele A ja B vastama sama maatriks, näit.   Liida_2  A, A, C, m, n"]

{"sheet":"Maks_RV","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Maksimaalse elemendi ja selle asukoha (indeksite) leidmine maatriksis"]
[null,"Protseduur M_maks_rvn(A, m, n, maks, rn, vn) leiab maksimaalse elemendi (maks)"]
[null," ja tema indeksid (rn, vn) maatriksis A(1...m, 1...n) "]

{"sheet":"Pos_Kesk","index":13,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsioon PosK_MR(A, n, rn)"]
[null,"Leiab positiivsete elementide aritmeetilise keskmise maatriksi A etteantud reas (rn)"]
[null,"n - veergude arv maatriksis. Ridade arv ei ole oluline"]

{"sheet":"ÜP_2","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ruutmaat","index":15,"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":"Ü2_And","index":16,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ü2_Prog","index":17,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Programmi põhiprotseduurid"]
[]
[null,"Peaprotseduur Op_Mas_2()"]
[null,"määratleb muutujad ja massiivid"]
[null,"kotrollib, kas on tegemist ruutmaatriksiga"]
[null,"loeb töölehelt antud massiivi"]
[null,"käivitab alamprotseduurid, vajalike tegevuste täitmiseks"]
[null,"kirjutab tulemid töölehele"]
[]
[null,"Protseduur Värvi_1(prk, n)"]
[null,"Värvib töölehel maatriksi vastavad alad"]
[]
[null,"Funktsioon Max_ve_KD(A(), n)"]
[null,"Leiab veeru numbri, kus asub kõrvaldiagonaali max"]
[]
[null,"Funktsioon Min_ve_YD(A(), n)"]
[null,"Leiab veeru numbri, kus asub min ülalpool peadiagonaali"]
[]
[null,"Protseduur Vaheta(A(), n, v1, v2)"]
[null,"Vahetab etteantud numbritega (v1, v2) veerud"]
[]
[null,"Protseduur Tee_Uus (A(), B(), n, k)"]
[null,"Moodustab maatriksi B() maatriksi A() nendest ridadest, "]
[null,"kus esimene element on positiivne "]

{"sheet":"Ü2_Liides","index":18,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ülesanne 2. Liides",null,null,null,null,null,null,null,null,null,"max_ve","min_ve"]
[null,null,null,null,null,null,null,null,null,null,null,7,7]
[]
[null,-1,-17,39,-65,-15,9,63,8,-15,2]
[null,-55,24,-2,36,78,-26,-40,-42,-70,6]
[null,-56,17,-27,76,-4,-62,37,50,23,57]
[null,-68,62,-60,92,-87,-88,59,-24,-7,-76]
[null,-77,-66,-91,43,7,12,-57,-6,50,51]
[null,-20,81,49,-83,27,43,-97,-14,-20,-45]
[null,98,61,39,-17,47,-45,-29,-13,89,-76]
[null,29,-31,-80,-63,-85,-14,92,8,-1,95]
[null,-57,-24,-21,-44,1,-73,3,94,12,82]
[null,32,-12,39,-88,51,40,-1,-69,-56,-35]
[]
[null,-1,-17,39,-65,-15,9,63,8,-15,2]
[null,-55,24,-2,36,78,-26,-40,-42,-70,6]
[null,-56,17,-27,76,-4,-62,37,50,23,57]
[null,-68,62,-60,92,-87,-88,59,-24,-7,-76]
[null,-77,-66,-91,43,7,12,-57,-6,50,51]
[null,-20,81,49,-83,27,43,-97,-14,-20,-45]
[null,98,61,39,-17,47,-45,-29,-13,89,-76]
[null,29,-31,-80,-63,-85,-14,92,8,-1,95]
[null,-57,-24,-21,-44,1,-73,3,94,12,82]
[null,32,-12,39,-88,51,40,-1,-69,-56,-35]
[]
[null,98,61,39,-17,47,-45,-29,-13,89,-76]
[null,29,-31,-80,-63,-85,-14,92,8,-1,95]
[null,32,-12,39,-88,51,40,-1,-69,-56,-35]

{"sheet":"Värvid","index":19,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduur Värvi"]

{"sheet":"Funktsid","index":20,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Funktsioonid maxi ja mini veergude leidmiseks"]

{"sheet":"Tee","index":21,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Protseduur Tee_Uus (A(), B(), m, n, k)"]
[null,"Loob maatriksi B, mis sisaldab maatriksi A neid ridu, kus esimene element on positiivne"]