{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Tiitel","Sisukord","Prog_Prots","Siss_Red","Andmed","Objektid","Rehmaatika","Rehmaatika_L","Auto_demo","Prots","RuutVrd","Demo_ruurvrd","Arvuk_1","Fun","Demod","Shape","Shape_Oma","Shape_Meet","Liigu_1","Range","Rist_Ring_1","Rist_Ring_2","Rist_Ring_3","Rist_Ring_4","demo_kor","Pall","Sheet1"],"not_rendered":{"charts":0,"images":88,"macros":1,"external_links":1,"defined_names":83,"comments":10,"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":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,5,18,5],[3,2,3,4],[3,6,3,8]]}
[]
[]
[null,null,null,"Tere tulemast VBA'sse!!!"]
[null,null,"Sissejuhatus VBAsse (html)",null,null,null,"Sissejuhatus VBAsse (pdf)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1]

{"sheet":"Sisukord","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"VBA programmide ja protseduuride liigid "]
[null,null,"Programmide sisestamine, redigeerimine ja käivitamine"]
[null,null,"Andmed"]
[null,null,"Objektid ja klassid."]
[null,null,"Näide \"Rehmaatika\""]
[null,null,"Demo \"Auto\""]
[null,null,"Protseduuride struktuur"]
[null,null,"Ruutvõrrandi lahendaja "]
[null,null,"Demo Ruutvõrrand"]
[null,null,"Töölehefunktsioonid"]
[null,null,"Protseduuride täitmine arvutis"]
[null,null,"Kujunditega (Shape) seotud põhiklassid"]
[null,null,"Shape-objektide põhiomadused"]
[null,null,"Shape-objekti mõned meetodid"]
[null,null,"Harjutus. Kujundi omadused ja meetodid"]
[null,null,"Klass Range - lahtrid ja lahtriplokid"]
[null,null,"Harjutus. Makro  Rist_Ring_1"]
[null,null,"Harjutus. Makro  Rist_Ring_2"]
[null,null,"Harjutus. Makro  Rist_Ring_3"]
[null,null,"Harjutus. Makro  Rist_Ring_4"]
[null,null,"Demo \"Korrutamise trenn\""]
[null,null,"Demo Pall"]

{"sheet":"Prog_Prots","index":2,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,4,0,7]]}
[null,null,null,null,"Programmide ja protseduuride liigid"]
[]
["Mis on VBA programm?     ",null,null,null,"Videoklipp "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"pikkus(cm)","mass(kg)"]
[null,null,null,null,null,null,null,null,null,null,null,null,185,67]
[null,null,null,null,null,null,null,null,null,null,null,null,"pindala",{"$f":"F_pind(pikkus, mass)","v":1.8351851802037087},"m2"]

{"sheet":"Siss_Red","index":3,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,4,0,6],[0,8,0,10],[2,9,2,10]]}
[null,null,null,null,"Programmide sisestamine",null,null,null,"Makrode käivitamine"]
[]
[null,null,null,null,null,null,null,null,null,"Videoklipp"]

{"sheet":"Andmed","index":4,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,5,0,8],[15,13,15,14],[0,10,0,12]]}
[null,null,null,null,null,"Skalaarandmed, omistamine",null,null,null,"veb"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"avaldised",null,"veb"]

{"sheet":"Objektid","index":5,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,6,0,7]]}
[null,null,null,null,"Objektid",null,"Modelleerimine"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ära puutu!!!"]
[null,13]

{"sheet":"Rehmaatika","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,7,0,9]]}
[null,null,null,null,"Makrod",null,null,"Makrode käivitamine"]
[]
[null,"Näide",null,"Sammhaval täitmine"]
[]
[null,null,"õigete"]
[null,"ülesandeid","protsent"]
[]
[null,"Andmevahetus töölehega"]

{"sheet":"Rehmaatika_L","index":7,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,7,0,9]]}
[null,null,null,null,"Makrod",null,null,"Makrode käivitamine"]
[]
[null,"Näide",null,"Sammhaval täitmine",null,null,null,null,"Lugemine lehelt"]
[null,null,null,null,null,null,null,null,"Kirjutamine lehele"]
[null,null,"õigete"]
[null,"ülesandeid","protsent"]
[null,1,100]
[null,"Andmevahetus töölehega"]

{"sheet":"Auto_demo","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"ringe",null,"ring","aeg"]
[null,null,5,null,5,13.42578125]
[]
["Makro struktuur, laused, andmed ja objektid, omadused ja meetodid ",null,null,null,null,null,null,null,null,null,"Alamprotseduurid: parameetrid ja argumendid"]

{"sheet":"Prots","index":9,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,12,1,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mitmeprotseduurilised programmid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"pikkus","sugu","id_mass"]
[null,185,"n",{"$f":"Imass(pikkus, sugu)","v":70.875}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Andmete skoop"]
[]
[null,null,null,null,null,null,null,"Sündmusprotseduurid"]

{"sheet":"RuutVrd","index":10,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Ruutvõrrandite lahendaja"]
[]
[null,"a","b","c","x1","x2"]
[null,2,3,-9,-3,1.5]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"function RuutVrd () { "]
[null,null,null,null,null,null,null,null,null,null,null," var vihik, leht, a, b, c, D, x1, x2"]
[null,null,null,null,null,null,null,null,null,null,null," leht = SpreadsheetApp.getActiveSheet()  "]
[null,null,null,null,null,null,null,null,null,null,null," a = leht.getRange(\"a\").getValue()"]
[null,null,null,null,null,null,null,null,null,null,null," b = leht.getRange(\"b\").getValue()"]
[null,null,null,null,null,null,null,null,null,null,null," c = leht.getRange(\"c_\").getValue()           "]
[null,null,null,null,null,null,null,null,null,null,null," D = b * b - 4 * a * c"]
[null,null,null,null,null,null,null,null,null,null,null," if (D < 0) {"]
[null,null,null,null,null,null,null,null,null,null,null,"     Browser.msgBox(\"Lahend puudub!\")"]
[null,null,null,null,null,null,null,null,null,null,null,"     x1 = \"ei ole\"; x2 = \"ei ole\"  "]
[null,null,null,null,null,null,null,null,null,null,null,"} else {"]
[null,null,null,null,null,null,null,null,null,null,null,"     D = Math.sqrt(D); var t = 2 * a"]
[null,null,null,null,null,null,null,null,null,null,null,"     x1 = (-b - D) / t;   x2 = (-b + D)  /t   } "]
[null,null,null,null,null,null,null,null,null,null,null," leht.getRange(\"x_1\").setValue(x1)"]
[null,null,null,null,null,null,null,null,null,null,null," leht.getRange(\"x_2\").setValue(x2) "]
[null,null,null,null,null,null,null,null,null,null,null,"}  "]

{"sheet":"Demo_ruurvrd","index":11,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"VBA tööpõhimõte. Ruutvõrrandi lahendamine"]
[]
[null,"a",3]
[null,"b",4]
[null,"c",-9]
[null,"x_1",1.1892547876100072]
[null,"x_2",-2.5225881209433405]

{"sheet":"Arvuk_1","index":12,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[[20,9,24,9],[2,1,2,3],[4,9,5,9],[11,9,15,9],[7,9,9,9]]}
[]
[null,"Protseduuri tööpiirkond",null,null,null,null,null,null,null,"Interpretaator"]
[null,"Andmeplokk ",null,null,null,"Programmiplokk",null,null,null,"Juhtplokk"]
[]
[null,1,null,"a",1,"  Sub Ruut_Vrd()"]
[null,2,null,"b",2,"  Dim a, b, c, x1, x2, D"]
[null,3,null,"c",3,"  a = Range(\"a\")",null,null,null,"Töötlusplokk"]
[null,4,null,"D",4,"  b = Range(\"b\")"]
[null,5,null,"x1",5,"  c = Range(\"c_\")"]
[null,6,null,"x2",6,"  D = b ^ 2 - 4 * a * c"]
[null,7,null,null,7,"  If D < 0 Then",null,null,null,"Selgitus"]
[null,8,null,null,8,"    MsgBox \"Lahendid puuduvad!\""]
[null,9,null,null,9,"    x1 = \"Puudub!\""]
[null,10,null,null,10,"    x2 = x1"]
[null,11,null,null,11,"  Else"]
[null,12,null,null,12,"    x1 = (-b + Sqr(D)) / (2 * a)"]
[null,13,null,null,13,"    x2 = (-b - Sqr(D)) / (2 * a)",null,null,null,"paus (sek)"]
[null,14,null,null,14,"  End If",null,null,null,60]
[null,15,null,null,15,"  Range(\"x_1\") = x1"]
[null,16,null,null,16,"  Range(\"x_2\") = x2"]
[null,17,null,null,17,"End Sub",null,null,null,"Valige sobiv paus lausete vahel (0 kuni 30 sek). \nNupp Edasi võimaldab suvalisel momendil minna järgmise lause juurde.\nNupp Aitab võimaldab lõpetada töö"]
[null,18,null,null,18]
[null,19,null,null,19]
[null,20,null,null,20]
[null,21,null,null,21]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,"  Eraldasin protseduurile tööpiirkonna. Kontrollisin protseduuri süntaksi. Alustan täitmist"]
[null,null,2,"  Eraldasin pesad muutujatele ja puhastasin need"]
[null,null,3,"  Lugesin  töölehe lahtrist a väärtuse ja omistasin selle muutujale a"]
[null,null,4,"  Lugesin  töölehe lahtrist b väärtuse ja omistasin selle muutujale b"]
[null,null,5,"  Lugesin  töölehe lahtrist c_ väärtuse ja omistasin selle muutujale c"]
[null,null,6,"  Arvutasin avaldise b ^ 2 - 4 * a * c  väärtuse ja omistasin muutujale D"]
[null,null,7,"  Kas D on väiksem kui 0?"]
[null,null,8,"  Väljastan teate, et lahendid puuduvad"]
[null,null,9,"  Omistasin muutujale x1 teksti \"Puudub!\""]
[null,null,10,"  Omistasin muutujale x2 muutuja x1 väärtuse (teksti \"Puudub!\")"]
[null,null,11,"  D ei olnud väiksem nullist. Leian juured"]
[null,null,12,"  Arvutasin avaldise (-b + Sqr(D)) / (2 * a)  väärtuse ja omistasin muutujale x1"]
[null,null,13,"  Arvutasin avaldise (-b - Sqr(D)) / (2 * a)  väärtuse ja omistasin muutujale x2"]
[null,null,14,"  Valiku lõpp"]
[null,null,15,"  Kirjutasin töölehe lahtrisse x_1 muutuja x1 väärtuse"]
[null,null,16,"  Kirjutasin töölehe lahtrisse x_2 muutuja x2 väärtuse"]
[null,null,17,"  Lõpetan töö. Eemaldan tööpiirkonna"]

{"sheet":"Fun","index":13,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
[null,null,null,null,"Töölehefunktsioonid"]
[]
[null,"Töölehefunktsioonid"]
[null,"Keha indeks - kind"]
[]
[null,"mass","pikkus","indeks","hinnang","pindala","id_mass","sugu"]
[null,78,174,{"$f":"Kind(pikkus, mass)","v":25.762980578676178},{"$f":"Hind(pikkus, mass)","v":"ülekaal"},{"$f":"F_pind(pikkus,mass)","v":1.9575861658222677},{"$f":"Imass(pikkus,sugu)","v":70.5},"mees"]
[null,null,null,{"$f":"mass/(pikkus/100)^2","v":25.762980578676178},{"$f":"IF(indeks<18, \"kondibukett\", IF(indeks<=25, \"normis\", IF(indeks<=30, \"ülekaal\", \"paks\")))","v":"ülekaal"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"d","h","pind"]
[null,null,null,null,35,168,{"$f":"Sil_Pi(d, h)/10000","v":2.0396790303431733}]

{"sheet":"Demod","index":14,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,1,7,6],[10,1,10,5],[13,1,13,5]]}
[]
[]
[]
[null,"Protseduuride: makrode ja töölehefunmtsioonide täitmine arvutis"]
[]
[null,"Näied"]
[]
[null,"Ristküliku pindala ja ümbermõõdu suhe"]
[]
[]
[null,"Prisma sisesilindri omadused"]
[]
[]
[null,"Maks kolmest"]

{"sheet":"Shape","index":15,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Objektid"]

{"sheet":"Shape_Oma","index":16,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["(0, 0)"]
[null,"Shape-objektide põhiomadused"]
[]
[null,"Omadus","Nimi/Viitamine","Väärtused"]
[null,"Nimi","Name","ufo","cm"]
[null,"Vasak serv","Left",94.325431823730469,3.3275916226704916]
[null,"Ülemine serv","Top",109.43448638916016,3.8606054920620387]
[null,"Laius","Width",66.113700866699219,2.3323444472418888]
[null,"Kõrgus","Height",53.448108673095703,1.8855305004119871]
[null,"Pöörde nurk","Rotation",125.28627014160156]
[null,"Täitevärv","Fill.ForeColor.SchemeColor",24]
[null,"Joone värvus","Line.ForeColor.SchemeColor",5]
[null,"Joone paksus","Line.Weight",3.7916536331176758]
[null,"Nähtavus","Visible",-1]

{"sheet":"Shape_Meet","index":17,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Shape-objekti mõned meetodid"]
[]
[null,"Meetod","Selgitus"]
[null,"IncrementLeft dx","Vasaku serva juurdekasv","kuju.Left = kuju.left + dx"]
[null,"IncrementTop dy","Ülemise serva juurdekasv","kuju.Top = kuju.Top + dy"]
[null,"IncrementRotation dn","Pöördenurga juurdekasv","kuju.Rotation = kuju.Rotation + dn"]
[null,"ScaleHeight k, False","Kõrguse skaleerimine"]
[null,"ScaleWidth k, False","Laiuse skaleerimine"]
[null,"Select","Valimine (aktiveerimine)"]
[null,"Copy","Kopeerimine"]
[null,"Duplicate","Dubleerimine"]
[null,"Cut","Lõikamine"]
[null,"Delete","Eemaldamine"]

{"sheet":"Liigu_1","index":18,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Harjutus. Kujundi omadused ja meetodid"]

{"sheet":"Range","index":19,"n_rows":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"Objektid"]
[]
[]
[]
[]
[]
[]
["Range-objekti mõned omadused",null,null,"x","y",null,null,null,null,null,null,null,"Nimi","Tariif","Tunde","Palk","Maks","Saada"]
[null,null,null,1.3,{"$f":"3*SIN(x)","v":2.8906745562515788},null,null,null,null,null,null,null,"Kask  P.",9,195,1755,338.31,1416.69]
[null,"Omadus","Selgitus","x","y",null,null,null,null,null,null,null,"Kuusk V.",6,78,468,68.039999999999992,399.96000000000004]
[null,"Address","aadress","$D$9","$E$9",null,null,null,null,null,null,null,"Lepp M.",12,97,1164,214.2,949.8]
[null,"Name","nimi","x","y",null,null,null,null,null,null,null,"Mänd K.",8,94,752,127.67999999999999,624.32000000000005]
[null,"Value","väärtus",1.3,2.8906745562515788,null,null,null,null,null,null,null,"Paju L.",10,125,1250,232.26,1017.74]
[null,"Formula","Valem",1.3," =3*SIN(x)",null,null,null,null,null,null,null,"Saar K.",15,31,465,67.41,397.59000000000003]
[null,"Left","vasak serv",243,303,null,null,null,null,null,null,null,"Tamm H.",23,130,2990,597.66,2392.34]
[null,"Top","ülemine serv",138.75,138.75,null,null,null,null,null,null,null,"Vaher O.",15,78,1170,215.45999999999998,954.54]
[null,"Width","laius",60,60]
[null,"Height","kõrgus",20.25,20.25,null,null,null,null,null,null,null,"Kokku:",null,828,10014,1861.02,8152.9800000000005]
[null,"Font.ColorIndex","kirja värvus",1,5]
[null,"Interior.ColorIndex","põhja värvus",36,34]
[]
[]
[]
[]
[null,2.2676377296447754]

{"sheet":"Rist_Ring_1","index":20,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Makrod"]
[null,"Makro  Rist_Ring_1"]
[null,"Range- ja Shape-objektid ja nende omadused"]
[]
[]
[null,"a","b","d","suhe","pind","ümber"]
[null,6,4,5.5279087261542363,1.1516476512821323,24,20]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Makro  Rist_Ring_1"]

{"sheet":"Rist_Ring_2","index":21,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,7],[2,6,2,7],[5,8,5,9]]}
[null,null,null,null,"Muutujad",null,"Makrode täitmine"]
[null,"Makro Rist_Ring_2"]
[null,"Muutujate kasutamine. Makro täitmine"]
[]
[null,"a","b","d","suhe"]
[null,8,2,4.5104256707187345,1.4095080220996046,null,null,null,"Täitmise demo"]

{"sheet":"Rist_Ring_3","index":22,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
[null,null,null,null,"Objektimuutujad"]
[null,"Makro Rist_Ring_3"]
[null,"Objektide sidumine muutujatega"]
[]
[null,"a","b","d","suhe"]
[null,6,4,5.5241207080057384,1.1508584808345288]

{"sheet":"Rist_Ring_4","index":23,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,4,0,7],[5,8,5,10]]}
[null,null,null,null,"Mitmeprotseduurilised programmid"]
[null,"Demo. Makro Rist_Ring_4"]
[null,"Alamprotseduurid. Parameetrid ja argumendid. Mõõtkava kasutamine"]
[null,"Spinnerid. Sündmused ja sündmusprotseduurid. Märkeruudud"]
[]
[null,"a","b","d","suhe",null,null,null,"Näide: prisma sisesilinder"]
[null,16,9,13.540555723756425,1.175395462131634]
[null,null,null,"mõõtkava 1:",2]

{"sheet":"demo_kor","index":24,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Korrutamise trenn",null,null,null,null,"Demo"]
[]
[null,null,"ülesandeid",4]
[]
[]
[null,null,"aeg",0,"vigu",0]
[]
[]
[null,"a",null,"b",null,"vastus"]
[null,3,"*",4,"="]
[null,6,"*",9,"="]
[null,9,"*",3,"="]
[null,9,"*",6,"="]

{"sheet":"Pall","index":25,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"DEMO"]

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