{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Tiitel","Sisukord","Prog_Prots","Siss_Red","Makro","korrutamine","Auto_demo","Objektid","Shape","Shape_Oma","Shape_Meet","Liigu_1","Range","Rist_Ring_1","Muutujad","Rist_Ring_2","Rist_Ring_3","Rist_Ring_4"],"not_rendered":{"charts":0,"images":56,"macros":1,"external_links":0,"defined_names":32,"comments":7,"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":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[17,5,19,5],[4,2,4,4],[4,6,4,8]]}
[]
[]
[]
[null,null,null,"Tere tulemast VBA'sse!!!"]
[null,null,"Sissejuhatus VBAsse (html)",null,null,null,"Sissejuhatus VBAsse (pdf)"]

{"sheet":"Sisukord","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"VBA programmide ja protseduuride liigid "]
[null,null,"Makro näide"]
[null,null,"Programmide sisestamine, redideerimine ja käivitamine"]
[null,null,"Töölehefunktsioonid"]
[null,null,"Objektid ja klassid. Omadused ja meetodid"]
[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,"Skalaarandmed: konstandid ja muutujad. Omistamislause"]
[null,null,"Harjutus. Makro  Rist_Ring_2"]
[null,null,"Harjutus. Makro  Rist_Ring_3"]
[null,null,"Harjutus. Makro  Rist_Ring_4"]

{"sheet":"Prog_Prots","index":2,"n_rows":6,"n_cols":17,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,4,0,7],[0,8,0,10]]}
[null,null,null,null,"Programmide ja protseduuride liigid",null,null,null,"Sissejuhatus VBAsse (pdf)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"pikkus (cm)","mass (kg)","indeks","saledus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,187,71,{"$f":"kind(pikkus, mass)","v":20.303697560696612},{"$f":"saledus(pikkus, mass)","v":"normis"}]

{"sheet":"Siss_Red","index":3,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,4,0,6],[0,8,0,10],[6,7,6,10]]}
[null,null,null,null,"Programmide sisestamine",null,null,null,"Makrode käivitamine"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Sissejuhatus VBAsse (pdf)"]

{"sheet":"Makro","index":4,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Makrod"]
[]
[null,"Makro näide"]

{"sheet":"korrutamine","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korrutamise trenn"]
[]
[null,null,"ülesandeid",5]
[]
[null,null,"aeg",36.2109375,"vigu",1]
[]
[null,"a",null,"b",null,"vastus"]
[null,7,"*",6,"="]
[null,6,"*",4,"="]
[null,4,"*",8,"="]
[null,2,"*",8,"="]
[null,8,"*",7,"="]

{"sheet":"Auto_demo","index":6,"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,2.376953125]
[]
["Makro struktuur, laused, andmed ja objektid, omadused ja meetodid ",null,null,null,null,null,null,null,null,null,"Alamprotseduurid: parameetrid ja argumendid"]

{"sheet":"Objektid","index":7,"n_rows":45,"n_cols":10,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,6,0,8]]}
[null,null,null,null,"Objektid",null,"Sissejuhatus VBAsse (pdf)"]
[]
[null,null,null,null,null,null,null,null,null,"UML"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ära puutu!!!"]
[null,13]

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

{"sheet":"Shape_Oma","index":9,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["(0, 0)"]
[null,"Shape-objektide põhiomadused",null,null,null,"Töölehe koordinaadisüsteem"]
[]
[null,"Omadus","Nimi/Viitamine","Väärtused"]
[null,"Nimi","Name","ufo","cm"]
[null,"Vasak serv","Left",126.98638153076172,4.4797973484463158]
[null,"Ülemine serv","Top",106.69731903076172,3.7640443102518715]
[null,"Laius","Width",55.701812744140625,1.9650361718071832]
[null,"Kõrgus","Height",96.074806213378906,3.3893056636386447]
[null,"Pöörde nurk","Rotation",0]
[null,"Täitevärv","Fill.ForeColor.SchemeColor",11]
[null,"Joone värvus","Line.ForeColor.SchemeColor",45]
[null,"Joone paksus","Line.Weight",2.7881889343261719]
[null,"Nähtavus","Visible",-1]

{"sheet":"Shape_Meet","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"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,"Flip 0 | 1","Peegeldus: 0-hor, 1-vert"]
[null,"Select","Valimine (aktiveerimine)"]
[null,"Copy","Kopeerimine"]
[null,"Duplicate","Dubleerimine"]
[null,"Cut","Lõikamine"]
[null,"Delete","Eemaldamine"]

{"sheet":"Liigu_1","index":11,"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":12,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,6,0,8]]}
[null,null,"Objektid",null,null,null,"Sissejuhatus VBAsse (pdf)"]
[]
[]
[]
[]
[]
[]
["Range-objekti mõned omadused",null,null,"x","y",null,null,"UML"]
[null,null,null,1.3,{"$f":"3*SIN(x)","v":2.8906745562515788}]
[null,"Omadus","Selgitus","x","y"]
[null,"Address","Aadress","$D$9","$E$9"]
[null,"Name","Nimi","x","y"]
[null,"Value","Väärtus",1.3,2.8906745562515788]
[null,"Formula","Valem",1.3," =3*SIN(x)"]
[null,"Left","Vasak serv",243,303]
[null,"Top","Ülemine serv",138.75,138.75]
[null,"Width","Laius",60,60]
[null,"Height","Kõrgus",20.25,20.25]
[null,"Font.ColorIndex","Kirja värvus",1,5]
[null,"Interior.ColorIndex","Põhja värvus",36,34]
[]
[]
[]
[]
[null,22.710391998291016]

{"sheet":"Rist_Ring_1","index":13,"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":"Muutujad","index":14,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,5,0,8],[15,13,15,14]]}
[null,null,null,null,null,"Skalaarandmed, omistamine"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"avaldised"]

{"sheet":"Rist_Ring_2","index":15,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,6,2,7],[0,6,0,7],[5,8,5,9]]}
[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,null,null,"Täitmise demo"]

{"sheet":"Rist_Ring_3","index":16,"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":17,"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,"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,20,9,15.138801525721615,1.2195145673497969]
[null,null,null,"mõõtkava 1:",2]