{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Tiitel","Sisukord","Prog_Prots","Demos","Siss_Red","Andmed","Objektid","Rehmaatika","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":84,"macros":1,"external_links":1,"defined_names":77,"comments":9,"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"VBA programmide ja protseduuride liigid "]
[null,null,"Demod Tutvus ja Inimese pindala"]
[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":3,"n_cols":5,"rows_kept":3,"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 "]

{"sheet":"Demos","index":3,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[19,7,19,8],[20,7,20,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Käivita"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"pikkus","mass"]
[null,null,null,null,null,null,null,175,89]
[null,null,null,null,null,null,null,"pindala",{"$f":"F_pind(pikkus, mass)","v":2.1066939942125917},"m2"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Videoklipp 1",null,"üldpõhimõtted"]
[null,null,null,null,null,null,null,"Videoklipp 2",null,"struktuur, sisestamine jm"]
[null,"pińdala",1.775161430420777]

{"sheet":"Siss_Red","index":4,"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":5,"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],[8,12,8,13]]}
[null,null,null,null,null,"Skalaarandmed, omistamine",null,null,null,"veb"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Videoklipp"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"avaldised",null,"veb"]

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

{"sheet":"Rehmaatika","index":7,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,7,0,9],[8,15,8,17]]}
[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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"näita",null,"demo - visualiseerimine"]

{"sheet":"Auto_demo","index":8,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"scratch"]
[]
[null,null,"ringe",null,"ring","aeg"]
[null,null,3,null,3,8.65625]
[]
["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,"m",{"$f":"Imass(pikkus, sugu)","v":78.75}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,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":16,"n_cols":8,"rows_kept":16,"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,65,175,{"$f":"Kind(pikkus,mass)","v":21.224489795918366},{"$f":"Hind(pikkus,mass)","v":"normaal"},null,null,"naine"]
[null,null,null,{"$f":"mass/(pikkus/100)^2","v":21.224489795918366},{"$f":"IF(indeks<18, \"kondibukett\", IF(indeks<=25, \"normis\", IF(indeks<=30, \"ülekaal\", \"paks\")))","v":"normis"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"d","h","pind"]

{"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",169.57890319824219,5.9823668628268765]
[null,"Ülemine serv","Top",173.47361755371094,6.1197637303670245]
[null,"Laius","Width",78.822677612304688,2.7806889046563041]
[null,"Kõrgus","Height",66.733383178710938,2.3542054621378581]
[null,"Pöörde nurk","Rotation",301.63211059570313]
[null,"Täitevärv","Fill.ForeColor.SchemeColor",10]
[null,"Joone värvus","Line.ForeColor.SchemeColor",34]
[null,"Joone paksus","Line.Weight",2.0551180839538574]
[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":6,"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,"Makro  Rist_Ring_1"]

{"sheet":"Rist_Ring_2","index":21,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,6,2,7],[0,6,0,7],[11,6,11,7]]}
[null,null,null,null,"Muutujad",null,"Makrode täitmine",null,null,"Scratch"]
[null,"Makro Rist_Ring_2"]
[null,"Muutujate kasutamine. Makro täitmine"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Täitmise demo"]

{"sheet":"Rist_Ring_3","index":22,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
[null,null,null,null,"Objektimuutujad"]
[null,"Makro Rist_Ring_3"]
[null,"Objektide sidumine muutujatega"]

{"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,null,"n_1"]
[null,null,"ülesandeid",4]
[]
[]
[null,null,"aeg",0,"vigu",4]
[]
[]
[null,"a",null,"b",null,"vastus"]
[null,6,"*",7,"="]
[null,7,"*",5,"="]
[null,8,"*",6,"="]
[null,4,"*",8,"="]

{"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":[]}