{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Demo_ruurvrd","Arvuk_1","Sheet3"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":1,"defined_names":27,"comments":0,"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":"Demo_ruurvrd","index":0,"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":1,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":true,"merged":[[2,1,2,3],[4,9,5,9],[7,9,9,9],[11,9,15,9],[20,9,24,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":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}