{"text_format":"1","workbook":"xlsx","n_sheets":36,"sheets":["Alg","Sisukord","Tab_Str","Aadressid","Laed_A","Värvid","Fun_tab1_A","Fun_XY_A","Kaubad_A","Nimed","Laed_N","Table_1","Table_2_1","Hinnakiri","Table_2_2","Fun_tab1_N","Fun_tab2_NT","Fun_XY_N","Värvimine_ÜP","Ruumid","Värvimine_tab","Lisad","Valideerimine","abi","Table_obj","VLOOKUP","Addr_R1C1","Diagr_1","Diagrammileht","Kopeerimine","Lohista","Menüüd","Nupud","Ctrl_C_V","Sheet1","Sheet2"],"not_rendered":{"charts":3,"images":10,"macros":1,"external_links":1,"defined_names":61,"comments":14,"pivot_tables":0},"unopened":[{"sheet":"Diagrammileht","index":28,"reason":"not_a_worksheet"}],"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":"Alg","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tabelid I"]
[null,null,null,"Valemite kasutamine tabelites"]
[null,null,null,"Aadresside ja nimede  kasutamine tabelites"]
[null,null,null,"Table-objekti loomine ja kasutamine"]
[null,null,null,"Diagrammid ja graafikud"]
[null,null,null,"Mitme, omavahel seotud, tabeliga rakendused"]

{"sheet":"Sisukord","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Tabelite loomise ja kasutamise üldpõhimõtted"]
[null,"Aadresside kasutamine"]
[null,"Harjutus \"Lagede värvimine I\". Aadressid"]
[null,"Tabel Värvid"]
[null,"Ühemuutuja funktsiooni tabuleerimine ja graafikud. Aadressid"]
[null,"Kahemuutuja funktsioon. Aadressid"]
[null,"Kaubad"]
[null,"Nimede määramine  ja kasutamine tabelites"]
[null,"Harjutus \"Lagede värvimine II\". Nimed. Diagrammid"]
[null,"Table-objektid. Tabeli muutmine Table-objektiks"]
[null,"Tabeli loomine otse Table-objektina. Valemites nimed"]
[null,"Tabeli loomine otse Table-objektina. Valemites päisete tekstid"]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 1"]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 2. Table-objekt"]
[null,"Kahemuutuja funktsioon. Nimed"]
[null,"Harjutus \"Lagede värvimine III\". Ülesande püstitus"]
[null,"Tabel  Ruumid"]
[null,"Tabel  Värvimine"]
[null,"Lisad"]
[null,"Valideerimine tabelites"]
[null,"Tabeli-objekti tulbapäisete kasutamine valemites"]
[null,"Otsimine. Funktsioon VLOOKUP"]
[null,"R1C1- aadressid"]
[null,"Diagrammid"]
[null,"Valemite kopeerimine"]

{"sheet":"Tab_Str","index":2,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,4,0,6]]}
[null,null,null,"veeb","Klipp\nTabelite tüüpstruktuur"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arvutid"," "]
[]
[null,"Mark","Protsessor","Mälu, MB","Ketas,GB","Hind, €","..."]
[null,"Aragorn","Pent 4; 3,0 ",512,160,380]
[null,"Aura","AMD 64; 3,0",512,160,380]
[null,"Balrog","Pent 4; 3,0 ",512,160,320]
[null,"Ekstra","AMD S; 2,8",256,80,270]
[null,"Eliisa","AMD S; 3,0",512,160,320]
[null,"Elsa","Pent 4; 3,2 ",512,160,540]
[null,"Frodo","AMD 64; 3,8",1024,320,730]
[null,"Futura","AMD 64; 3,5",512,160,380]
[null,"Polaris","Intel C; 2,5",256,80,220]
[null,"Sambo","Pent 4; 3,0 ",512,160,450]
[null,"Super","AMD 64; 4,0",2048,320,830]
[null,"Tetris","AMD S; 2,6",256,40,240]
[null,"Ultra","Intel C; 3,0",512,160,300]
[]
[]
[null,"Töötajad"]
[]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","..."]
[null,34002110722,"Karl","Agur","mees","1940-02-11"]
[null,35404050446,"Reijo","Bauman","mees","1954-04-05"]
[null,48007150516,"Erna","Eek","naine","1980-07-15"]
[null,44311270496,"Vilma","Eesmaa","naine","1943-11-27"]
[null,37002030149,"Kristjan","Jürimäe","mees","1970-02-03"]
[null,34906210936,"Jaan","Kaasik","mees","1949-06-21"]
[null,48210210529,"Saima","Kukk","naine","1982-10-21"]
[null,33907250511,"Riho","Kuusk","mees","1939-07-25"]
[null,37906080465,"Kristjan","Mägi","mees","1979-06-08"]
[null,37708220891,"Leida","Nõmmik","mees","1977-08-22"]
[null,35001130124,"Aarne","Oks","mees","1950-01-13"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arvutite müük",null,"Valemites nimed",null,null,"käibe-\nmaksu %",0.18]
[]
[null,"Kuupäev","Müüja","Mark","Arv","Hind","Maksu-\nmus k-ga","käibe-\nmaks","Maksu-\nmus k-ta"]
[null,"2014-01-02","Kukk","Ekstra",2,{"$f":"VLOOKUP(Mark, Arvutid, 5, 0)","v":270},{"$f":"Hind * Arv","v":540},{"$f":"maks_kga * k_pr / (1 + k_pr)","v":82.372881355932208},{"$f":"maks_kga - k_maks","v":457.62711864406776}]
[null,"2014-01-03","Kukk","Tetris",5,240,1200,183.05084745762713,1016.9491525423729]
[null,"2014-01-04","Agur","Balrog",3,320,960,146.44067796610167,813.5593220338983]
[null,"2014-01-05","Kaasik","Aura",1,{"$f":"VLOOKUP(Mark, Arvutid, 5, 0)","v":380},380,57.966101694915253,322.03389830508473]
[null,"2014-01-06","Eek","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2014-01-07","Nõmmik","Balrog",2,320,640,97.627118644067792,542.37288135593224]
[null,"2014-01-08","Mägi","Frodo",1,730,730,111.35593220338984,618.64406779661022]
[null,"2014-01-09","Kuusk","Elsa",3,540,1620,247.11864406779659,1372.8813559322034]
[null,"2014-01-10","Kukk","Ekstra",1,270,270,41.186440677966104,228.81355932203388]
[null,"2014-01-11","Agur","Frodo",2,730,1460,222.71186440677968,1237.2881355932204]
[null,"2014-01-12","Kukk","Eliisa",5,320,1600,244.06779661016949,1355.9322033898304]
[null,"2014-01-13","Mägi","Ultra",2,300,600,91.525423728813564,508.47457627118644]
[null,"2014-01-14","Nõmmik","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2014-01-15","Kuusk","Eliisa",4,320,1280,195.25423728813558,1084.7457627118645]
[null,"2014-01-16","Kukk","Aura",2,380,760,115.93220338983051,644.06779661016947]
[]
[null,null,null,"Kokku:",{"$f":"SUM(Arv)","v":37},null,{"$f":"SUM(maks_kga)","v":13560},{"$f":"SUM(k_maks)","v":2068.4745762711864},{"$f":"SUM(maks_kta)","v":11491.525423728814}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Arvutite müük",null,"Valemites aadressid",null,null,"käibe-\nmaksu %",0.18]
[]
[null,"Kuupäev","Müüja","Mark","Arv","Hind","Maksu-\nmus k-ga","käibe-\nmaks","Maksu-\nmus k-ta"]
[null,"2014-01-02","Kukk","Ekstra",2,{"$f":"VLOOKUP(D96,$B$17:$F$29, 5, 0)","v":270},{"$f":"F96 * E96","v":540},{"$f":"G96 * $H$93 / (1 + $H$93)","v":82.372881355932208},{"$f":"G96 - H96","v":457.62711864406776}]
[null,"2014-01-03","Kukk","Tetris",5,240,1200,183.05084745762713,1016.9491525423729]
[null,"2014-01-04","Agur","Balrog",3,320,960,146.44067796610167,813.5593220338983]
[null,"2014-01-05","Kaasik","Aura",1,380,380,57.966101694915253,322.03389830508473]
[null,"2014-01-06","Eek","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2014-01-07","Nõmmik","Balrog",2,320,640,97.627118644067792,542.37288135593224]
[null,"2014-01-08","Mägi","Frodo",1,730,730,111.35593220338984,618.64406779661022]
[null,"2014-01-09","Kuusk","Elsa",3,540,1620,247.11864406779659,1372.8813559322034]
[null,"2014-01-10","Kukk","Ekstra",1,270,270,41.186440677966104,228.81355932203388]
[null,"2014-01-11","Agur","Frodo",2,730,1460,222.71186440677968,1237.2881355932204]
[null,"2014-01-12","Kukk","Eliisa",5,320,1600,244.06779661016949,1355.9322033898304]
[null,"2014-01-13","Mägi","Ultra",2,300,600,91.525423728813564,508.47457627118644]
[null,"2014-01-14","Nõmmik","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2014-01-15","Kuusk","Eliisa",4,320,1280,195.25423728813558,1084.7457627118645]
[null,"2014-01-16","Kukk","Aura",2,380,760,115.93220338983051,644.06779661016947]
[]
[null,null,null,"Kokku:",{"$f":"SUM(E96:E111)","v":37},null,{"$f":"SUM(G96:G111)","v":13560},{"$f":"SUM(H96:H111)","v":2068.4745762711864},{"$f":"SUM(I96:I111)","v":11491.525423728814}]

{"sheet":"Aadressid","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"R1C1 - aadressid"]
[]
[]
[null,null,null,null,null,null,null,13]
[]
[]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,"Kopeerige valem paremale, alla ja diagonaalis. Vaadake aadresse"]
[]
[null,null,null,null,null,null,null,null,{"$f":"H13 + 100","v":113}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"$H$13+100","v":113}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"H$13 + $H13","v":26}]

{"sheet":"Laed_A","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,null,"veeb","Klipp \"Aadressid \nja nimed tabelites\"",null,"otsimine","valemite\nkopeerimine"]
[]
[null,"Lagede värvimine I. Aadressid"]
[null,"Viitamine teise lehe lahtritele"]
[null,{"$f":"Aadressid!H13 + 100","v":113}]
[]
[null,"värv","hind, €/ltr","kulu, ltr/m2",null,"tariif, €/m2"]
[null,null,null,null,null,0.25]
[]
[null,"ruum","pikkus","laius","pindala","värvi\nkogus","värvi\nmaksumus","tõõtasu","kulud kokku"]
[null,"R_01",5,4]
[null,"R_02",7.2,4.8]
[null,"R_03",6.27,5.23]
[null,"R_03_1",5.2,4.12]
[null,"R_04",4.2,3.9]
[null,"R_05",4.5999999999999996,4.3]
[null,"R_06",7.85,6.41]
[null,"R_07",8.4,5.82]
[null,"R_08",7.77,5.55]
[]
[null,null,null,"Kokku:"]

{"sheet":"Värvid","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Värvid"]
[]
[null,"V_mark","kulu","hind","valmistaja","..."]
[null,"VL_01",0.52,3.05,"JukuColor"]
[null,"VL_02",0.48,3.37,"JukuColor"]
[null,"VL_05",0.65,4.0599999999999996,"Sadolin"]
[null,"VL_06",0.45,3.17,"JukuColor"]
[null,"VL_09",0.55000000000000004,4.0199999999999996,"JukuColor"]
[null,"VL_11",0.48,3.17,"Sadolin"]
[null,"VL_13",0.52,2.76,"JukuColor"]
[null,"VL_21",0.39,3.96,"VivaColor"]
[null,"VL_25",0.42,3.13,"JukuColor"]
[null,"VL_30",0.47,3,"VivaColor"]
[null,"VL_32",0.55000000000000004,6.31,"JukuColor"]

{"sheet":"Fun_tab1_A","index":6,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 1"]
[]
[null,"algus","lõpp","jaotisi","samm","p",null,"ymin","ymax","zkesk"]
[null,-10,10,20,null,2]
[]
[null,"x","y","z"]

{"sheet":"Fun_XY_A","index":7,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kahemuutuja funktsiooni tabel ja graafik. Aadressid. "]
[]
[null,"ax","bx","nx","hx","a","ay","by","ny","hy"]
[null,2,7,10,{"$f":"(C5-B5)/D5","v":0.5},5,4,14,10,{"$f":"(H5-G5)/I5","v":1}]

{"sheet":"Kaubad_A","index":8,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,3,3,5],[17,3,17,5],[32,3,32,5]]}
[null,null,null,"veeb"]
[null,"Kaupade allahindlus. Suht-, absoluut- ja sega-aadressid"]
[]
[null,null,null,"Allahinnatud",null,null,7.0000000000000007E-2]
[null,"Kaup","Alghind","Mai","Juuni","Juuli"]
[null,"Kaup1",1225]
[null,"Kaup2",500]
[null,"Kaup3",869]
[null,"Kaup4",4589]
[null,"Kaup5",12548]
[null,"Kaup6",369]
[null,"Kaup7",147]
[null,"Kaup8",125]
[null,"Kaup9",3695]
[null,"Kaup10",5896]
[]
[]
[null,null,null,"Allahinnatud"]
[null,null,null,0.05,0.1,0.15]
[null,"Kaup","Alghind","Mai","Juuni","Juuli"]
[null,"Kaup1",1225]
[null,"Kaup2",500]
[null,"Kaup3",869]
[null,"Kaup4",4589]
[null,"Kaup5",12548]
[null,"Kaup6",369]
[null,"Kaup7",147]
[null,"Kaup8",125]
[null,"Kaup9",3695]
[null,"Kaup10",5896]
[]
[]
[null,null,null,"Allahinnatud"]
[null,null,null,0.05,0.1,0.15]
[null,"Kaup","Alghind","Mai","Juuni","Juuli"]
[null,"Kaup1",1225]
[null,"Kaup2",500]
[null,"Kaup3",869]
[null,"Kaup4",4589]
[null,"Kaup5",12548]
[null,"Kaup6",369]
[null,"Kaup7",147]
[null,"Kaup8",125]
[null,"Kaup9",3695]
[null,"Kaup10",5896]

{"sheet":"Nimed","index":9,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,7,0,8]]}
[null,null,null,"veeb","Klipp \"Aadressid\nja nimed tabelites\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"a","b","h","S","P"]
[null,null,null,null,null,null,null,null,null,6,4,3]
[null,null,null,null,null,null,null,null,null,8.4,6.32,2.8]
[null,null,null,null,null,null,null,null,null,7.23,4.7,3.2]
[null,null,null,null,null,null,null,null,null,7,5,3.14]
[null,null,null,null,null,null,null,null,null,8,6,3]
[null,null,null,null,null,null,null,null,null,6.25,4.33,3]
[null,null,null,null,null,null,null,null,null,4.7,4.3,3]

{"sheet":"Laed_N","index":10,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,4,0,5],[2,4,2,5]]}
[null,null,null,"veeb","Klipp \"Aadressid \nja nimed tabelites\"",null,"Diagramm","validee-\nrimine","otsimine"]
[]
[null,"Lagede värvimine II. Nimed",null,null,"Diagrammid"]
[]
[null,"värv","hind, €/ltr","kulu, ltr/m2",null,"tariif, €/m2"]
[null,null,null,null,null,0.6]
[]
[]
[null,"ruum","pikkus","laius","pindala","v_kogus","v_maks","töötasu","Kokku"]
[null,"R_01",5,4]
[null,"R_02",7.2,4.8]
[null,"R_03",6.27,5.23]
[null,"R_04",7.4,6.33]
[null,"R_05",4.5999999999999996,4.3]
[null,"R_06",7.85,6.41]
[null,"R_07",8,7]
[]
[null,null,null,"Kokku:"]

{"sheet":"Table_1","index":11,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,3,0,5]]}
[null,null,null,"Klipp \"Tabeli muutmine \nList-objektiks\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Proovige muuta toodud tabel Table-objektiks"]
[]
[null,null,null,null,null,null,null,null,null,"ruum","a","b","pind","hind","maksumus"]
[null,null,null,null,null,null,null,null,null,"R01",5,4,{"$f":"a * b","v":20},150,{"$f":"hind * pind","v":3000}]
[null,null,null,null,null,null,null,null,null,"R02",6,5,{"$f":"a * b","v":30},200,{"$f":"hind * pind","v":6000}]
[null,null,null,null,null,null,null,null,null,"R03",7.5,6.2,{"$f":"a * b","v":46.5},120,{"$f":"hind * pind","v":5580}]
[null,null,null,null,null,null,null,null,null,"R04",5.4,4.5,{"$f":"a * b","v":24.3},150,{"$f":"hind * pind","v":3645}]
[null,null,null,null,null,null,null,null,null,"R05",4,3,{"$f":"a * b","v":12},120,{"$f":"hind * pind","v":1440}]

{"sheet":"Table_2_1","index":12,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,"Valideerimine","Otsimine","Klipp \"Tabeli loomine List-objektina\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Puidu müük"]
[]
[null,"kuupäev","liik","kogus","hind","maksumus"]

{"sheet":"Hinnakiri","index":13,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Puidu hinnakiri"]
[]
[null,"liigid","hinnad"]
[null,"haab",76]
[null,"kask",120]
[null,"kuusk",160]
[null,"lepp",110]
[null,"mänd",150]
[null,"paju",76]
[null,"saar",210]
[null,"tamm",230]
[null,"vaher",220]

{"sheet":"Table_2_2","index":14,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,"Valideerimine","Otsimine","Klipp \"Tabeli loomine List-objektina\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Puidu müük"]
[]
[null,"kuupäev","liik","kogus","hind","maksumus"]

{"sheet":"Fun_tab1_N","index":15,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 1"]
[]
[null,"algus","lõpp","jaotisi","samm","p",null,"ymin","ymax","zkesk"]
[null,-10,10,20,null,2]
[]
[null,"x","y","z"]

{"sheet":"Fun_tab2_NT","index":16,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 2 - Table-objekt"]
[]
[null,"algus","samm","p",null,"zmin","zmax","ykesk"]
[null,-5,0.5,2]
[]
[null,"x","y","z"]

{"sheet":"Fun_XY_N","index":17,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kahemuutuja funktsiooni tabel ja graafik. Nimed"]
[]
[null,"ax","bx","nx","hx","a","ay","by","ny","hy"]
[null,2,7,10,null,5,4,14,10]

{"sheet":"Värvimine_ÜP","index":18,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Lagede värvimine III"]

{"sheet":"Ruumid","index":19,"n_rows":43,"n_cols":10,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Ruumid"]
[]
[null,"R_kood","pikkus","laius","kõrgus","pindala","S_pind","U_pind","A_pind","..."]
[null,"R_101",5,4,2.8,20,44.4,2.5,3.5]
[null,"R_102",6,5,3.2,30,62,3.5,4.9000000000000004]
[null,"R_103",6,3,2.8,18,44.4,2.5,3.5]
[null,"R_104",4,3,2.8,12,34.5,2,2.7]
[null,"R_105",4.8,3.2,2.8,15.4,39.5,2.2000000000000002,3.1]
[null,"R_106",4.2,3.8,2.8,16,39.5,2.2000000000000002,3.1]
[null,"R_107",5.25,4.2,2.8,22.1,47.3,2.6,3]
[null,"R_108",6.3,4.75,2.8,29.9,54.5,3.1,4.3]
[null,"R_109",6,5,2.5,30,48.3,2.8,3.9]
[null,"R_110",7.2,6.1,2.8,43.9,65.599999999999994,3.7,5.2]
[null,"R_111",6,4.5999999999999996,3.2,{"$f":"C15*D15","v":27.599999999999998},{"$f":"2*(C15+D15) * E15","v":67.84},{"$f":"0.04*G15","v":2.7136},{"$f":"0.05*G15","v":3.3920000000000003}]
[null,"R_112",7.35,5.2,3.2,{"$f":"C16*D16","v":38.22},{"$f":"2*(C16+D16) * E16","v":80.320000000000007},{"$f":"0.04*G16","v":3.2128000000000005},{"$f":"0.05*G16","v":4.0160000000000009}]
[null,"R_113",4.28,3.3,3.2,{"$f":"C17*D17","v":14.124000000000001},{"$f":"2*(C17+D17) * E17","v":48.512},{"$f":"0.04*G17","v":1.94048},{"$f":"0.05*G17","v":2.4256000000000002}]
[null,"R_201",5,4,2.8,20,44.4,2.5,3.5]
[null,"R_202",6,5,3.2,30,62,3.5,4.9000000000000004]
[null,"R_203",4,2.8,2.8,11.2,33.5,1.9,2.7]
[null,"R_204",4,3,2.8,12,34.5,2,2.7]
[null,"R_205",4.8,4,2.8,19.2,43.4,2.5,3.4]
[null,"R_206",4.2,3.8,2.8,16,39.5,2.2000000000000002,3.1]
[null,"R_207",5.25,4.2,2.8,22.1,46.6,2.6,3.7]
[null,"R_208",6.3,4.75,2.8,29.9,54.5,3.1,4.3]
[null,"R_209",6,5,2.5,30,48.3,2.8,3.9]
[null,"R_210",7.2,6.1,2.8,43.9,65.599999999999994,3.7,5.2]
[null,"R_211",7,4.7,2.8,32.9,57.6,3.3,4.5999999999999996]
[null,"R_212",6.4,4.7,2.8,30.1,54.7,3.1,4.4000000000000004]
[null,"R_213",7.35,5.2,3.2,{"$f":"C30*D30","v":38.22},{"$f":"2*(C30+D30) * E30","v":80.320000000000007},{"$f":"0.04*G30","v":3.2128000000000005},{"$f":"0.05*G30","v":4.0160000000000009}]
[null,"R_301",7.35,6,3.2,44.099999999999994,85.44,3.4176000000000002,4.2720000000000002]
[null,"R_302",3.2,2.8,3.2,8.9599999999999991,38.400000000000006,1.5360000000000003,1.9200000000000004]
[null,"R_303",6.2,4.75,3.2,29.45,70.08,2.8031999999999999,3.504]
[null,"R_304",5.75,3.8,3.2,21.849999999999998,61.120000000000005,2.4448000000000003,3.0560000000000005]
[null,"R_305",4.3,4.2,3.2,18.059999999999999,54.400000000000006,2.1760000000000002,2.7200000000000006]
[null,"R_306",8.3000000000000007,5.2,3.2,43.160000000000004,86.4,3.4560000000000004,4.32]
[null,"R_307",7.35,4,3.2,29.4,72.64,2.9056000000000002,3.6320000000000001]
[null,"R_308",6.4,5.2,3.2,33.28,74.240000000000009,2.9696000000000002,3.7120000000000006]
[null,"R_309",5,4,3.2,20,57.6,2.3040000000000003,2.8800000000000003]
[null,"R_310",7.1,5.2,3.2,36.92,78.720000000000013,3.1488000000000005,3.9360000000000008]
[null,"R_311",5.55,3.7,3.2,20.535,59.2,2.3680000000000003,2.9600000000000004]
[null,"R_312",4.4000000000000004,4,3.2,17.600000000000001,53.760000000000005,2.1504000000000003,2.6880000000000006]
[null,"R_313",6,5.2,3.2,31.200000000000003,71.679999999999993,2.8672,3.5839999999999996]

{"sheet":"Värvimine_tab","index":20,"n_rows":4,"n_cols":10,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Lagede värvimine III",null,null,"Siia teha tabel Värvimine"]
[]
[null,"J Ehitus","objekt","Kullaladu",null,"tariif",1.3,null,"muud",0.1]

{"sheet":"Lisad","index":21,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Lisad"]
[]
[]
[null,null,null,null,"Tulbapäisete kasutamine Table-objektis"]
[null,null,null,null,"Otsimine. Funktsioon VLOOKUP"]
[null,null,null,null,"Diagrammid"]
[null,null,null,null,"Valideerimine tabelites"]
[null,null,null,null,"Valemite kopeerimine"]
[null,null,null,null,"R1C1- aadressid"]

{"sheet":"Valideerimine","index":22,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valideerimine loendiga"]
[]
[null,"Määrake valideerimine allpoololevatele lahtritele"]
[null,"sugu",null,"naine või mees, määrata Data Validation boksis"]
[null,"nädalapäev",null,"määrata Data Validation boksis esitähtede abil"]
[null,"nädalapäev",null,"loendist nimega päevad",null,"Päevad"]
[null,"kuu",null,"loend Kuud  lehel abi",null,"Kuud"]
[null,"töötaja",null,"loend T_nimi lehel abi",null,"T_nimi"]
[null,"puu liik",null,"loend P_liigid lehel abi",null,"P_liigid"]
[]
[]
[null,"Valideerimine tabeli tulpades"]
[null,"Määrake valideerimine allpoololevale tabeli tulpadele (vt kommentaari) ja koostage valemid"]
[]
[null,"Kuupäev","Müüja","Puu liik","Sort","Kogus","Hind","Maksumus"]

{"sheet":"abi","index":23,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Puidu hinnakiri",null,null,"M_töötajad"]
[]
[null,"Kuud",null,"Päevad",null,"P_liigid","Hinnad",null,"T_nimi","Amet","Palk"]
[null,"jaanuar",null,"esmaspäev",null,"haab",76,null,"Karu","metsülem",5000]
[null,"veebruar",null,"teisipäev",null,"kask",120,null,"Hunt","turvamees",4500]
[null,"märts",null,"kolmapäev",null,"kuusk",160,null,"Rebane","ärimees",5600]
[null,"aprill",null,"neljapäev",null,"lepp",110,null,"Jänes","käskjalg",450]
[null,"mai",null,"reede",null,"mänd",150,null,"Siil","raamatupidaja",5467]
[null,"juuni",null,"laupäev",null,"paju",76,null,"Kits","diiler",4000]
[null,"juuli",null,"pühapäev",null,"saar",210,null,"Sokk","kirvemees",300]
[null,"august",null,null,null,"tamm",230]
[null,"september",null,null,null,"vaher",220]
[null,"oktoober"]
[null,"november"]
[null,"detsember"]

{"sheet":"Table_obj","index":24,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,1,27,10]]}
[]
[null,"Tabeli-objekti tulbapäisete ja tabelite nimede kasutamine valemites (struktuursed viited - structured referenced)"]
[null,"vt. kommentaari"]
[null,"A_müügid",null,null,null,"km_prots",0.18,null,null,"Arvukid"]
[]
[null,"kuupäev","arvuti","arv","hind","maks_kga","käibemaks","maks_kta",null,"mark","protsessor","määlu, MB","ketas,GB","hind","hind_kta"]
[null,"2013-11-01","Frodo",3,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":730},{"$f":"A_müügid[hind] *A_müügid[arv]","v":2190},{"$f":"km_prots * A_müügid[maks_kga]","v":394.2},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":1795.8},null,"Aragorn","Pent 4; 3,0 ",512,160,350,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":287}]
[null,"2013-11-01","Balrog",1,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":320},{"$f":"A_müügid[hind] *A_müügid[arv]","v":320},{"$f":"km_prots * A_müügid[maks_kga]","v":57.599999999999994},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":262.39999999999998},null,"Aura","AMD 64; 3,0",512,160,380,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":311.60000000000002}]
[null,"2013-11-02","Frodo",6,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":730},{"$f":"A_müügid[hind] *A_müügid[arv]","v":4380},{"$f":"km_prots * A_müügid[maks_kga]","v":788.4},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":3591.6},null,"Balrog","Pent 4; 3,0 ",512,160,320,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":262.39999999999998}]
[null,"2013-11-02","Polaris",4,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":220},{"$f":"A_müügid[hind] *A_müügid[arv]","v":880},{"$f":"km_prots * A_müügid[maks_kga]","v":158.4},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":721.6},null,"Eliisa","AMD S; 3,0",512,160,320,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":262.39999999999998}]
[null,"2013-11-02","Balrog",2,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":320},{"$f":"A_müügid[hind] *A_müügid[arv]","v":640},{"$f":"km_prots * A_müügid[maks_kga]","v":115.19999999999999},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":524.79999999999995},null,"Frodo","AMD 64; 3,8",1024,320,730,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":598.6}]
[null,"2013-11-03","Futura",3,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":380},{"$f":"A_müügid[hind] *A_müügid[arv]","v":1140},{"$f":"km_prots * A_müügid[maks_kga]","v":205.2},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":934.8},null,"Futura","AMD 64; 3,5",512,160,380,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":311.60000000000002}]
[null,"2013-11-04","Eliisa",1,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":320},{"$f":"A_müügid[hind] *A_müügid[arv]","v":320},{"$f":"km_prots * A_müügid[maks_kga]","v":57.599999999999994},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":262.39999999999998},null,"Polaris","Intel C; 2,5",256,80,220,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":180.4}]
[null,"2013-11-04","Frodo",7,{"$f":"VLOOKUP(A_müügid[arvuti], Arvukid[], 5, 0)","v":730},{"$f":"A_müügid[hind] *A_müügid[arv]","v":5110},{"$f":"km_prots * A_müügid[maks_kga]","v":919.8},{"$f":"A_müügid[maks_kga] - A_müügid[käibemaks]","v":4190.2},null,"Sambo","Pent 4; 3,0 ",512,160,450,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":369}]
[null,"Total",null,{"$f":"SUBTOTAL(109,A_müügid[arv])","v":27},null,{"$f":"SUBTOTAL(109,A_müügid[maks_kga])","v":14980},{"$f":"SUBTOTAL(109,A_müügid[käibemaks])","v":2696.3999999999996},{"$f":"SUBTOTAL(109,A_müügid[maks_kta])","v":12283.599999999999},null,"Tetris","AMD S; 2,6",256,40,240,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":196.8}]
[null,null,null," =SUBTOTAL(109;[arv])",null,null," =SUBTOTAL(109;[käibemaks])",null,null,"Ultra","Intel C; 3,0",512,160,300,{"$f":"Arvukid[[#This Row],[hind]] - km_prots * Arvukid[[#This Row],[hind]]","v":246}]
[]
[null,null,null,null," =VLOOKUP([arvuti]; Arvukid; 5; 0)",null,null,null,null,null,null,null,null,null," =[@hind]- km_prots*[@hind]"]
[null,null,null,null,null," =[hind] * [arv]"]
[null,null,null,null,null,null," =km_prots * [maks_kga]"]
[null,null,null,null,null,null,null," =[maks_kga] - [käibemaks]"]
[null,"arvutite arv",null,null,"maks. hind tabelis A_müügid",null,"maks. hind tabelis Arvukid"]
[null,{"$f":"SUM(A_müügid[arv])","v":27},null,null,{"$f":"MAX(A_müügid[hind])","v":730},null,{"$f":"MAX(Arvukid[hind])","v":730}]
[]
[null,{"$f":"A_müügid[[#Totals], [maks_kga]] * 15.6466","v":234386.068}]
[]
[null,{"$f":"SUM(A_müügid[[#Totals],[maks_kta]],A_müügid[[#Data],[käibemaks]])","v":14980},"Struktuurse viite näide"]
[null," =SUM(A_müügid[[#Totals];[maks_kta]];A_müügid[[#Data];[käibemaks]])"]

{"sheet":"VLOOKUP","index":25,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Otsimisfunktsioon VLOOKUP"]
[null,"Otsimine vertikaalsest tabelist"]
[null,"VLOOKUP(otsitav;  tabel;  tulemi_tulba_nr;  tunnus)"]
[null,"Otsib otsitavale vastavat väärtust tabeli esimesest tulbast ja"]
[null," tagastab tulemuse tulbast numbriga  tulemi_tulba_nr. "]
[]
[null,"otsitav - otsitav väärtus: konstant või viit lahtrile (aadress, nimi) "]
[null,"tabel - tabel, mille esimeses tulbas toimub otsimine: piirkonna aadess või nimi"]
[null,"tulemi_tulba_nr - tabeli tulba number, kust võetakse tagastatav väärtus: arv või arvavaldis"]
[null,"tunnus - määrab väärtuste järjestamise tingimuse tabeli esimeses tulbas ja ka otsimisviisi: 0 või 1"]
[null,"0 - väärtused tabeli esimeses tulbas võivad olla suvalises järjekorras - kindla väärtuse otsimine"]
[null,"kui otsitavaga võrdset väärtust esimeses tulbas ei ole - veateade - #N/A"]
[null,"1 - väärtused tabeli esimeses tulbas peavad olema kasvamise järjekorras - vahemiku otsimine"]
[null,"kui otsitavaga võrdset väärtust esimeses tulbas ei ole, tagastatakse lähim väiksem väärtus"]
[]
[null,"Mark","Hind","Protsessor","Kõvaketas","Põhimälu"]
[null,"Gandalf",{"$f":"VLOOKUP(Mark, Arvutid, 6, 0)","v":8490},{"$f":"VLOOKUP(Mark, Arvutid, 2, 0) & \"; \" & VLOOKUP(Mark, Arvutid, 3, 0)","v":"Intel Xeon; 3,2"}]
[null,null,null,null,"Teha siia vastavad valemid"]
[]
[null,"Arvutid"]
[null,1,2,3,4,5,6]
[]
[null,"mark","prots_tüüp","taktsagedus","mälu, MB","ketas,GB","hind, Kr"]
[null,"Aragorn","AMD Athlon64",3,512,160,4990]
[null,"Arven","Intel Core 2",2.6,256,200,3690]
[null,"Balrog","Intel Celeron",2.8,256,80,4190]
[null,"Eldar","Intel Xeon",3,512,160,4650]
[null,"Elend","Intel Celeron",4,2048,400,12990]
[null,"Faram","AMD Athlon64",3,512,210,5990]
[null,"Frodo","AMD Athlon64",3,4072,500,13300]
[null,"Gandalf","Intel Xeon",3.2,512,160,8490]
[null,"Grimbold","Intel Core 2",3.8,1024,320,11490]
[null,"Kalvar","Intel Xeon",3,512,160,6990]
[null,"Marvin","Intel Celeron",3,512,160,5990]
[null,"Rohan","AMD Athlon64",3.5,512,160,5890]
[null,"Sauron","Intel Xeon",2.5,256,180,3390]

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

{"sheet":"Diagr_1","index":27,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Diagramm töölehel"]
[]
[null,"Müükide maht "]
[]
[null,"Kv","Liha","Piim","Suhkur","Kokku"]
[null,1,150,140,150,{"$f":"SUM(C7:E7)","v":440}]
[null,2,175,172,180,{"$f":"SUM(C8:E8)","v":527}]
[null,3,149,210,156,{"$f":"SUM(C9:E9)","v":515}]
[null,4,177,146,227,{"$f":"SUM(C10:E10)","v":550}]
[null,"Kokku",{"$f":"SUM(C7:C10)","v":651},{"$f":"SUM(D7:D10)","v":668},{"$f":"SUM(E7:E10)","v":713},{"$f":"SUM(F7:F10)","v":2032}]

{"sheet":"Kopeerimine","index":29,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valemite kopeerimise (paljundamise)  võimalused"]
[null," - lohistamine (vedamine) hiire vasakpoolse nupuga"]
[null," - topeltklõps hiire vasakpoolse nupuga"]
[null," - objektimenüü korraldused Copy ja Paste (või klahv Enter)"]
[null," - Edit-menüü korraldused Copy ja Paste (või klahv Enter)"]
[null," - riistariba nupud Copy ja Paste (või klahv Enter)"]
[null," - klahvid Ctrl+C ja Ctrl+V (või klahv Enter)"]
[]
[null,"NB! Menüüde, nupude ja klahvide kasutamisel võib ühe osa tegevusest"]
[null,"täita ühe vahendiga, teise osa - teisega, näiteks"]
[",","kopeerimine teha objektimenüü korraldusega Copy, "]
[null,"kleepimine - klahvidega Ctrl+V jmt."]

{"sheet":"Lohista","index":30,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Valemite kopeerimine (paljundamine) lohistamisega ja topeltklõpsuga"]
[]
[null,"hind",2000]
[]
[null,"a","b","pind","maks",null,"a",5,6,4,8,7,5]
[null,5,4,{"$f":"B7 * C7","v":20},{"$f":"$C$4 * D7","v":40000},null,"b",4,3,3,5,3,5]
[null,6,3,null,null,null,"pind",{"$f":"H6 * H7","v":20}]
[null,4,3,null,null,null,"maks",{"$f":"$C$4 * H8","v":40000}]
[null,8,5]
[null,7,3]
[null,5,5]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"hind",2000]
[]
[null,"a","b","pind","maks"]
[null,5,4,{"$f":"a * b","v":20},{"$f":"hind * pind","v":40000}]
[null,6,3]
[null,4,3]
[null,8,5]
[null,7,3]
[null,5,5]

{"sheet":"Menüüd","index":31,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"hind",2000]
[]
[null,"a","b","pind","maks",null,"a",5,6,4,8,7,5]
[null,5,4,{"$f":"a * b","v":20},{"$f":"hind * pind","v":40000},null,"b",4,3,3,5,3,5]
[null,6,3,null,null,null,"pind",{"$f":"H19 * H20","v":20}]
[null,4,3,null,null,null,"maks",{"$f":"$C$17 * H21","v":40000}]
[null,8,5]
[null,7,3]
[null,5,5]

{"sheet":"Nupud","index":32,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"hind",2000]
[]
[null,"a","b","pind","maks",null,"a",5,6,4,8,7,5]
[null,5,4,{"$f":"a * b","v":20},{"$f":"hind * pind","v":40000},null,"b",4,3,3,5,3,5]
[null,6,3,null,null,null,"pind",{"$f":"H16 * H17","v":20}]
[null,4,3,null,null,null,"maks",{"$f":"$C$14 * H18","v":40000}]
[null,8,5]
[null,7,3]
[null,5,5]

{"sheet":"Ctrl_C_V","index":33,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"hind",2000]
[]
[null,"a","b","pind","maks",null,"a",5,6,4,8,7,5]
[null,5,4,{"$f":"a * b","v":20},{"$f":"hind * pind","v":40000},null,"b",4,3,3,5,3,5]
[null,6,3,null,null,null,"pind",{"$f":"H16 * H17","v":20}]
[null,4,3,null,null,null,"maks",{"$f":"$C$14 * H18","v":40000}]
[null,8,5]
[null,7,3]
[null,5,5]

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

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