{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Alg","Sisukord","Tab_Str","Tab_Str_1","Tab_Str_2","Aadressid","Laed_A","Värvid","Fun_XA","Fun_XY_A1","Kaubad_A","Nimed","Laed_N","Gra1","Table_1","Laed_N (2)","Laed_N (3)","Table_2_1","Table_2_2","Hinnakiri","Fun_tab1_N","Fun_tab2_NT","Värvimine_ÜP","Ruumid","Värvimine_tab","Fun_XY_N","Lisad","Valideerimine","abi","Table_obj","VLOOKUP","Diagr_1","Diagrammileht","Addr_R1C1","Kopeerimine","Lohista","Menüüd","Nupud","Ctrl_C_V","Sheet1","Sheet2"],"not_rendered":{"charts":11,"images":10,"macros":1,"external_links":0,"defined_names":182,"comments":15,"pivot_tables":0},"unopened":[{"sheet":"Gra1","index":13,"reason":"not_a_worksheet"},{"sheet":"Diagrammileht","index":32,"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,"Table-objekt. Tulbapäisete kasutamine valemites"]
[null,"Otsimine. Funktsioon VLOOKUP"]
[null,"Valideerimine tabelites"]
[null,"Diagrammid"]
[null,"Valemite kopeerimine"]
[null,"R1C1- aadressid"]

{"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,"2013-01-02","Kukk","Sambo",2,{"$f":"VLOOKUP(Mark, Arvutid, 5, 0)","v":450},{"$f":"Hind * Arv","v":900},{"$f":"maks_kga * k_pr / (1 + k_pr)","v":137.28813559322035},{"$f":"maks_kga - k_maks","v":762.71186440677968}]
[null,"2013-01-02","Kukk","Tetris",5,240,1200,183.05084745762713,1016.9491525423729]
[null,"2013-01-04","Agur","Balrog",3,320,960,146.44067796610167,813.5593220338983]
[null,"2013-01-04","Kaasik","Aura",1,380,380,57.966101694915253,322.03389830508473]
[null,"2013-01-04","Eek","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2013-01-05","Nõmmik","Balrog",2,320,640,97.627118644067792,542.37288135593224]
[null,"2013-01-06","Mägi","Frodo",1,730,730,111.35593220338984,618.64406779661022]
[null,"2013-01-07","Kuusk","Elsa",3,540,1620,247.11864406779659,1372.8813559322034]
[null,"2013-01-09","Kukk","Ekstra",1,270,270,41.186440677966104,228.81355932203388]
[null,"2013-01-09","Agur","Frodo",2,730,1460,222.71186440677968,1237.2881355932204]
[null,"2013-01-09","Kukk","Eliisa",5,320,1600,244.06779661016949,1355.9322033898304]
[null,"2013-01-10","Mägi","Ultra",2,300,600,91.525423728813564,508.47457627118644]
[null,"2013-01-10","Nõmmik","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2013-01-11","Kuusk","Eliisa",4,320,1280,195.25423728813558,1084.7457627118645]
[null,"2013-01-11","Kukk","Aura",2,380,760,115.93220338983051,644.06779661016947]
[]
[null,null,null,"Kokku:",{"$f":"SUM(Arv)","v":37},null,{"$f":"SUM(maks_kga)","v":13920},{"$f":"SUM(k_maks)","v":2123.3898305084745},{"$f":"SUM(maks_kta)","v":11796.610169491527}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"2009-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,"2009-01-02","Kukk","Tetris",5,240,1200,183.05084745762713,1016.9491525423729]
[null,"2009-01-04","Agur","Balrog",3,320,960,146.44067796610167,813.5593220338983]
[null,"2009-01-04","Kaasik","Aura",1,380,380,57.966101694915253,322.03389830508473]
[null,"2009-01-04","Eek","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2009-01-05","Nõmmik","Balrog",2,320,640,97.627118644067792,542.37288135593224]
[null,"2009-01-06","Mägi","Frodo",1,730,730,111.35593220338984,618.64406779661022]
[null,"2009-01-07","Kuusk","Elsa",3,540,1620,247.11864406779659,1372.8813559322034]
[null,"2009-01-09","Kukk","Ekstra",1,270,270,41.186440677966104,228.81355932203388]
[null,"2009-01-09","Agur","Frodo",2,730,1460,222.71186440677968,1237.2881355932204]
[null,"2009-01-09","Kukk","Eliisa",5,320,1600,244.06779661016949,1355.9322033898304]
[null,"2009-01-10","Mägi","Ultra",2,300,600,91.525423728813564,508.47457627118644]
[null,"2009-01-10","Nõmmik","Aragorn",2,380,760,115.93220338983051,644.06779661016947]
[null,"2009-01-11","Kuusk","Eliisa",4,320,1280,195.25423728813558,1084.7457627118645]
[null,"2009-01-11","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":"Tab_Str_1","index":3,"n_rows":71,"n_cols":9,"rows_kept":71,"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,"2013-01-02","Kukk","Ekstra",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 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,"2013-01-02","Kukk","Tetris",5,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":240},1200,183.05084745762713,1016.9491525423729]
[null,"2013-01-04","Agur","Balrog",3,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":320},960,146.44067796610167,813.5593220338983]
[null,"2013-01-04","Kaasik","Aura",1,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":380},380,57.966101694915253,322.03389830508473]
[null,"2013-01-04","Eek","Aragorn",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":380},760,115.93220338983051,644.06779661016947]
[null,"2013-01-05","Nõmmik","Balrog",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":320},640,97.627118644067792,542.37288135593224]
[null,"2013-01-06","Mägi","Frodo",1,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":730},730,111.35593220338984,618.64406779661022]
[null,"2013-01-07","Kukk","Elsa",3,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":540},1620,247.11864406779659,1372.8813559322034]
[null,"2013-01-09","Kukk","Ekstra",1,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":270},270,41.186440677966104,228.81355932203388]
[null,"2013-01-09","Agur","Frodo",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":730},1460,222.71186440677968,1237.2881355932204]
[null,"2013-01-09","Kukk","Eliisa",5,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":320},1600,244.06779661016949,1355.9322033898304]
[null,"2013-01-10","Mägi","Ultra",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":300},600,91.525423728813564,508.47457627118644]
[null,"2013-01-10","Nõmmik","Aragorn",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":380},760,115.93220338983051,644.06779661016947]
[null,"2013-01-11","Kuusk","Eliisa",4,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":320},1280,195.25423728813558,1084.7457627118645]
[null,"2013-01-11","Kukk","Aura",2,{"$f":"VLOOKUP(Mark, Arvutid_N[], 5, 0)","v":380},760,115.93220338983051,644.06779661016947]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,[Arv])","v":37},null,{"$f":"SUBTOTAL(109,[Maksu-\nmus k-ga])","v":13560},{"$f":"SUBTOTAL(109,[käibe-\nmaks])","v":2068.4745762711864},{"$f":"SUBTOTAL(109,[Maksu-\nmus k-ta])","v":11491.525423728814}]

{"sheet":"Tab_Str_2","index":4,"n_rows":71,"n_cols":9,"rows_kept":71,"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 tulpade päised",null,null,"käibe-\nmaksu %",0.18]
[]
[null,"Kuupäev","Müüja","Mark","Arv","Hind","Maks_kga","käibemaks","Maksu-\nmus k-ta"]
[null,"2013-01-02","Kukk","Ekstra",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":270},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":540},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":82.372881355932208},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":457.62711864406776}]
[null,"2013-01-02","Kukk","Tetris",5,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":240},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":1200},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":183.05084745762713},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":1016.9491525423729}]
[null,"2013-01-04","Agur","Balrog",3,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":320},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":960},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":146.44067796610167},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":813.5593220338983}]
[null,"2013-01-04","Kaasik","Aura",1,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":380},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":380},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":57.966101694915253},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":322.03389830508473}]
[null,"2013-01-04","Eek","Aragorn",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":380},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":760},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":115.93220338983051},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":644.06779661016947}]
[null,"2013-01-05","Nõmmik","Balrog",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":320},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":640},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":97.627118644067792},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":542.37288135593224}]
[null,"2013-01-06","Mägi","Frodo",1,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":730},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":730},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":111.35593220338984},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":618.64406779661022}]
[null,"2013-01-07","Kuusk","Elsa",3,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":540},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":1620},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":247.11864406779659},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":1372.8813559322034}]
[null,"2013-01-09","Kukk","Ekstra",1,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":270},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":270},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":41.186440677966104},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":228.81355932203388}]
[null,"2013-01-09","Agur","Frodo",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":730},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":1460},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":222.71186440677968},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":1237.2881355932204}]
[null,"2013-01-09","Kukk","Eliisa",5,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":320},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":1600},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":244.06779661016949},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":1355.9322033898304}]
[null,"2013-01-10","Mägi","Ultra",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":300},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":600},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":91.525423728813564},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":508.47457627118644}]
[null,"2013-01-10","Nõmmik","Aragorn",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":380},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":760},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":115.93220338983051},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":644.06779661016947}]
[null,"2013-01-11","Kuusk","Eliisa",4,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":320},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":1280},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":195.25423728813558},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":1084.7457627118645}]
[null,"2013-01-11","Kukk","Aura",2,{"$f":"VLOOKUP(A_müük_P[[#This Row],[Mark]], Arvutid_P[], 5, 0)","v":380},{"$f":"A_müük_P[[#This Row],[Hind]]*A_müük_P[[#This Row],[Arv]]","v":760},{"$f":"A_müük_P[[#This Row],[Maks_kga]] * k_pr / (1 + k_pr)","v":115.93220338983051},{"$f":"A_müük_P[[#This Row],[Maks_kga]] - A_müük_P[[#This Row],[käibemaks]]","v":644.06779661016947}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,[Arv])","v":37},null,{"$f":"SUBTOTAL(109,[Maks_kga])","v":13560},{"$f":"SUBTOTAL(109,[käibemaks])","v":2068.4745762711864},{"$f":"SUBTOTAL(109,[Maksu-\nmus k-ta])","v":11491.525423728814}]

{"sheet":"Aadressid","index":5,"n_rows":33,"n_cols":12,"rows_kept":33,"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},{"$f":"I13 + 100","v":100},100,100]
[null,null,null,null,null,null,null,null,{"$f":"H14 + 100","v":100}]
[null,null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,100,null,null,{"$f":"K16 + 100","v":121}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"$H$13+100","v":113},{"$f":"$H$13+100","v":113},113,113]
[null,null,null,null,null,null,null,null,{"$f":"$H$13+100","v":113}]
[null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,113,null,null,{"$f":"$H$13+100","v":113}]
[]
[null,null,null,null,null,null,null,null,{"$f":"H$13 + $H13","v":26},{"$f":"I$13 + $H13","v":13},13,13]
[null,null,null,null,null,null,null,null,{"$f":"H$13 + $H14","v":13}]
[null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,13,null,null,{"$f":"K$13 + $H16","v":0}]

{"sheet":"Laed_A","index":6,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,"otsimine","valemite\nkopeerimine","Klipp \"Aadressid \nja nimed\"",null,"veeb"]
[]
[null,"Lagede värvimine I. Aadressid"]
[null,"Viitamine teise lehe lahtritele"]
[null,{"$f":"Aadressid!H13 + 100","v":113}]
[null,"värvi margi valimiseks dünaamiline kopeerimine"]
[null,"värv","hind, €/ltr","kulu, ltr/m2",null,"tariif, €/m2"]
[null,{"$f":"Värvid!B15","v":"VL_30"},{"$f":"VLOOKUP(B8, Värvid!B6:E16, 3, 0)","v":3},{"$f":"VLOOKUP(B8, Värvid!B6:E16, 2, 0)","v":0.47},null,1.2]
[]
[null,"ruum","pikkus","laius","pindala","värvi\nkogus","värvi\nmaksumus","tõõtasu","kulud kokku"]
[null,"R_01",5,4,{"$f":"C11 * D11","v":20},{"$f":"$D$8 * E11","v":9.3999999999999986},{"$f":"$C$8 * F11","v":28.199999999999996},{"$f":"$F$8 * E11","v":24},{"$f":"G11+ H11","v":52.199999999999996}]
[null,"R_02",7.2,4.8,{"$f":"C12 * D12","v":34.56},{"$f":"$D$8 * E12","v":16.243200000000002},{"$f":"$C$8 * F12","v":48.729600000000005},{"$f":"$F$8 * E12","v":41.472000000000001},{"$f":"G12+ H12","v":90.201600000000013}]
[null,"R_03",6.27,5.23,32.792099999999998,15.412286999999997,46.23686099999999,39.350519999999996,85.587380999999993]
[null,"R_03_1",5.2,4.12,{"$f":"C14 * D14","v":21.424000000000003},{"$f":"$D$8 * E14","v":10.069280000000001},30.207840000000004,25.708800000000004,55.916640000000008]
[null,"R_04",4.2,3.9,16.38,7.698599999999999,23.095799999999997,19.655999999999999,42.751799999999996]
[null,"R_05",4.5999999999999996,4.3,19.779999999999998,9.296599999999998,27.889799999999994,23.735999999999997,51.625799999999991]
[null,"R_06",7.85,6.41,50.3185,23.649694999999998,70.949084999999997,60.382199999999997,131.33128499999998]
[null,"R_07",8.4,5.82,48.888000000000005,22.977360000000001,68.932079999999999,58.665600000000005,127.59768]
[null,"R_08",7.77,5.55,43.123499999999993,20.268044999999997,60.804134999999988,51.74819999999999,112.55233499999997]
[]
[null,null,null,"Kokku:",{"$f":"SUM(E11:E20)","v":287.26609999999999},{"$f":"SUM(F11:F20)","v":135.01506699999999},{"$f":"SUM(G11:G20)","v":405.04520099999996},{"$f":"SUM(H11:H20)","v":344.71931999999998},{"$f":"SUM(I11:I20)","v":749.76452099999995}]

{"sheet":"Värvid","index":7,"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_XA","index":8,"n_rows":29,"n_cols":10,"rows_kept":29,"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,{"$f":"(C6-B6)/D6","v":1},2,null,{"$f":"MIN(C9:C29)","v":-2.9383717218207628},{"$f":"MAX(C9:C29)","v":2.7278922804770449},{"$f":"AVERAGE(D9:D29)","v":-0.21100102233361015}]
[]
[null,"x","y","z"]
[null,{"$f":"B6","v":-10},{"$f":"3*SIN(B9+2)*COS(B9/2)","v":-0.84193056732976213},{"$f":"IF(B9<=$F$6, 5*COS(2*B9-3), 3*SIN(B9+1))","v":-2.6641651016669874}]
[null,{"$f":"B9+$E$6","v":-9},{"$f":"3*SIN(B10+2)*COS(B10/2)","v":0.41547004587670799},{"$f":"IF(B10<=$F$6, 5*COS(2*B10-3), 3*SIN(B10+1))","v":-2.7386463011213418}]
[null,{"$f":"B10+$E$6","v":-8},-0.54791447390446779,4.9435230909333461]
[null,-7,-2.6939731488413168,-1.3758166902579847]
[null,-6,-2.2476863752900278,-3.7984395642941067]
[null,-5,0.33917218044928332,4.5372339072509806]
[null,-4,1.1352037429618924,2.2128489940253928E-2]
[null,-3,-0.1785699082496302,-4.5556513094233848]
[null,-2,0,3.7695112717165231]
[null,-1,2.2153807878123861,1.4183109273161312]
[null,0,2.7278922804770449,-4.9499624830022269]
[null,1,0.37153337462150493,2.7015115293406988]
[null,2,-1.2267063999049068,2.7015115293406988]
[null,3,-0.20349485940270645,-2.2704074859237844]
[null,4,0.34883362697318027,-2.8767728239894153]
[null,5,-1.5790218571903594,-0.83824649459677758]
[null,6,-2.9383717218207628,1.9709597961563672]
[null,7,-1.157793334382389,2.9680747398701453]
[null,8,1.0667877862439166,1.2363554557252698]
[null,9,0.6323812050384181,-1.6320633326681093]
[null,10,-0.45661633974115162,-2.9999706196521103]

{"sheet":"Fun_XY_A1","index":9,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kahemuutuja funktsiooni tabel ja graafik. Aadressid. "]
[]
[null,"ax","bx","nx","hx","a","ay","by","ny","hy"]
[null,0,7,10,{"$f":"(C5-B5)/D5","v":0.7},5,0,14,10,{"$f":"(H5-G5)/I5","v":1.4}]
[]
[]
[null,null,{"$f":"B5","v":0},{"$f":"C8+$E$5","v":0.7},{"$f":"D8+$E$5","v":1.4},2.0999999999999996,2.8,3.5,4.2,4.9000000000000004,5.6000000000000005,6.3000000000000007,7.0000000000000009]
[null,{"$f":"G5","v":0},{"$f":"$F$5*SIN(C$8)*COS($B9)","v":0},{"$f":"$F$5*SIN(D$8)*COS($B9)","v":3.2210884361884551},4.9272486499423005,4.3160468332443696,1.6749407507795255,-1.7539161384480992,-4.357878862067941,-4.9122630631216619,-3.1563331893616042,8.4069502421753012E-2,3.2849329935939489]
[null,{"$f":"B9+$J$5","v":1.4},{"$f":"$F$5*SIN(C$8)*COS($B10)","v":0},0.54747919852795712,0.83747037538976266,0.73358614887017859,0.28468489393718061,-0.29810811493864703,-0.74069621929104157,-0.83492331801317532,-0.53647293423699738,1.4289053131670254E-2,0.55833067553989923]
[null,{"$f":"B10+$J$5","v":2.8},0,-3.0349814858462336,-4.6425637560051198,-4.066675749655059,-1.5781665946808041,1.6525789693051023,4.1060908217681238,4.6284440013146844,2.9739676456104616,-7.9212163350673534E-2,-3.0951372541637925]
[null,4.1999999999999993,0,-1.5791734623367837,-2.4156369700705684,-2.1159886654113129,-0.82115782817417926,0.85987636659827438,2.1364972702207048,2.40829012396761,1.547426501841332,-4.1215983306992617E-2,-1.6104739474885343]
[null,5.6,0,2.498166282771705,3.8214059278309418,3.3473786539165502,1.2990268948309398,-1.3602775107488048,-3.3798221481009696,-3.8097836180234013,-2.4479443228782904,6.5201437501646434E-2,2.5476819430239952]
[null,7,0,2.428385833481626,3.7146638649015045,3.2538774374342112,1.2627416079041514,-1.3222813307051255,-3.2854146982680557,-3.7033661972147676,-2.3795667069183057,6.3380187397279505E-2,2.476518389237178]
[null,8.4,0,-1.6726746788191222,-2.5586643199267933,-2.2412741511400514,-0.86977772819749066,0.91078875096824785,2.2629970490868141,2.550882474715555,1.6390480138474131,-4.365633876485156E-2,-1.7058284331068967]
[null,9.8000000000000007,0,-2.9969853058025535,-4.584441593098993,-4.0157633652850846,-1.5584088787441306,1.6318896542806294,4.0546849839179782,4.5704986094181645,2.9367353228982238,-7.8220473735973184E-2,-3.056387959343525]
[null,11.200000000000001,0,0.6538966193365946,1.000255441182667,0.87617849961812966,0.34002111901647603,-0.35605350683516801,-0.88467060493272087,-0.99721329417089921,-0.64075098927296004,1.7066517890438223E-2,0.66685737501826536]
[null,12.600000000000001,0,3.219267186084088,4.924462712115468,4.3136064777865109,1.6739937149940767,-1.7529244488333988,-4.3554148541744624,-4.9094855983628944,-3.1545485528126793,8.4021968306160433E-2,3.2830756448511429]
[null,14.000000000000002,0,0.44044267236582457,0.67373827381140516,0.59016423763255688,0.22902673892452965,-0.23982561374121553,-0.59588423288588188,-0.67168918635633912,-0.43158822005035946,1.1495429897267088E-2,{"$f":"$F$5*SIN(M$8)*COS($B19)","v":0.44917259954316202}]

{"sheet":"Kaubad_A","index":10,"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,{"$f":"C6-C6*$G$4","v":1139.25},{"$f":"D6-D6*$G$4","v":1059.5025000000001},985.33732500000008]
[null,"Kaup2",500,{"$f":"C7-C7*$G$4","v":465},432.45,402.17849999999999]
[null,"Kaup3",869,808.17,751.59809999999993,698.98623299999997]
[null,"Kaup4",4589,4267.7700000000004,3969.0261000000005,3691.1942730000005]
[null,"Kaup5",12548,11669.64,10852.7652,10093.071636000001]
[null,"Kaup6",369,343.17,319.1481,296.80773299999998]
[null,"Kaup7",147,136.71,127.14030000000001,118.24047900000001]
[null,"Kaup8",125,116.25,108.1125,100.544625]
[null,"Kaup9",3695,3436.35,3195.8054999999999,2972.099115]
[null,"Kaup10",5896,5483.28,5099.4503999999997,4742.4888719999999]
[]
[]
[null,null,null,"Allahinnatud"]
[null,null,null,0.05,0.1,0.15]
[null,"Kaup","Alghind","Mai","Juuni","Juuli"]
[null,"Kaup1",1225,{"$f":"C21-D$19*C21","v":1163.75},{"$f":"D21-E$19*D21","v":1047.375},890.26874999999995]
[null,"Kaup2",500,{"$f":"C22-D$19*C22","v":475},427.5,363.375]
[null,"Kaup3",869,825.55,742.99499999999989,631.54574999999988]
[null,"Kaup4",4589,4359.55,3923.5950000000003,3335.0557500000004]
[null,"Kaup5",12548,11920.6,10728.54,9119.259]
[null,"Kaup6",369,350.55,315.495,268.17075]
[null,"Kaup7",147,139.65,125.685,106.83225]
[null,"Kaup8",125,118.75,106.875,90.84375]
[null,"Kaup9",3695,3510.25,3159.2249999999999,2685.3412499999999]
[null,"Kaup10",5896,5601.2,5041.08,4284.9179999999997]
[]
[]
[null,null,null,"Allahinnatud"]
[null,null,null,0.05,0.1,0.15]
[null,"Kaup","Alghind","Mai","Juuni","Juuli"]
[null,"Kaup1",1225,{"$f":"$C36-D$34*$C36","v":1163.75},{"$f":"$C36-E$34*$C36","v":1102.5},1041.25]
[null,"Kaup2",500,{"$f":"$C37-D$34*$C37","v":475},450,425]
[null,"Kaup3",869,825.55,782.1,738.65]
[null,"Kaup4",4589,4359.55,4130.1000000000004,3900.65]
[null,"Kaup5",12548,11920.6,11293.2,10665.8]
[null,"Kaup6",369,350.55,332.1,313.64999999999998]
[null,"Kaup7",147,139.65,132.30000000000001,124.95]
[null,"Kaup8",125,118.75,112.5,106.25]
[null,"Kaup9",3695,3510.25,3325.5,3140.75]
[null,"Kaup10",5896,5601.2,5306.4,5011.6000000000004]

{"sheet":"Nimed","index":11,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,7,0,8]]}
[null,null,null,"veeb","Klipp \"Aadressid \nja nimed\"",null,"Klipp \" Nimede loomine\"","Klipp \"Nimede loomise ja kasutamise üldpõhimõtted\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,{"$f":"a*b","v":24},{"$f":"2*(a + b)","v":20}]
[null,null,null,null,null,null,null,null,null,8.4,6.32,2.8,53.088000000000008,29.44]
[null,null,null,null,null,null,null,null,null,7.23,4.7,3.2,33.981000000000002,23.86]
[null,null,null,null,null,null,null,null,null,7,5,3.14,35,24]
[null,null,null,null,null,null,null,null,null,8,6,3,48,28]
[null,null,null,null,null,null,null,null,null,6.25,4.33,3,27.0625,21.16]
[null,null,null,null,null,null,null,null,null,4.7,4.3,3,20.21,18]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S)","v":241.34150000000002},{"$f":"SUM(P)","v":164.46}]

{"sheet":"Laed_N","index":12,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,4,2,5]]}
[null,null,null,"validee-\nrimine","otsimine","valemite\nkopeerimine","Klipp \"Aadressid \nja nimed\"",null,"Diagramm","veeb"]
[]
[null,"Lagede värvimine II. Nimed",null,null,"Diagrammid"]
[]
[null,"värv","hind, eu/ltr","kulu, ltr/m2",null,"tariif, eu/m2"]
[null,"VL_13",{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":2.76},{"$f":"VLOOKUP(värv, Värvid[], 2, 0)","v":0.52},null,1.4]
[null,"värv","hind","kulu",null,"tariif"]
[]
[null,"ruum","pikkus","laius","pindala","v_kogus","v_maks","töötasu","Kokku"]
[null,"R_01",5,4,{"$f":"pikkus * laius","v":20},{"$f":"kulu * pindala","v":10.4},{"$f":"hind * v_kogus","v":28.703999999999997},{"$f":"tariif * pindala","v":28},{"$f":"v_maks + töötasu","v":56.703999999999994}]
[null,"R_02",7.2,4.8,34.56,17.971200000000003,49.600512000000002,48.384,97.984511999999995]
[null,"R_03",6.27,5.23,32.792099999999998,17.051891999999999,47.063221919999989,45.908939999999994,92.972161919999991]
[null,"R_03_1",7.4,6.33,46.842000000000006,24.357840000000003,67.227638400000004,65.578800000000001,132.80643839999999]
[null,"R_05",4.5999999999999996,4.3,19.779999999999998,10.285599999999999,28.388255999999995,27.691999999999997,56.080255999999991]
[null,"R_06",7.85,6.41,50.3185,26.165620000000001,72.217111199999991,70.445899999999995,142.66301119999997]
[null,"R_07",8,7,56,29.12,80.371200000000002,78.399999999999991,158.77119999999999]
[]
[null,null,null,"Kokku:",{"$f":"SUM(E10:E16)","v":260.29259999999999},{"$f":"SUM(F10:F16)","v":135.35215200000002},{"$f":"SUM(G10:G16)","v":373.57193951999994},{"$f":"SUM(H10:H16)","v":364.40963999999997},{"$f":"SUM(I10:I16)","v":737.98157951999985}]

{"sheet":"Table_1","index":14,"n_rows":52,"n_cols":15,"rows_kept":52,"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,30,200,6000]
[null,null,null,null,null,null,null,null,null,"R03",7.5,6.2,46.5,120,5580]
[null,null,null,null,null,null,null,null,null,"R04",5.4,4.5,24.3,150,3645]
[null,null,null,null,null,null,null,null,null,"R05",4,3,12,120,1440]
[null,null,null,null,null,null,null,null,null,"R06",7,5,35,150,5250]
[null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUBTOTAL(109,[pind])","v":167.8},null,{"$f":"SUBTOTAL(109,[maksumus])","v":24915}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Table23[[#This Row],[hind]] * Table23[[#This Row],[pind]]","v":3000}]
[null,null,null,null,null,null,null,null,null,"R02",6,5,{"$f":"[a]*[b]","v":30},200,{"$f":"Table23[[#This Row],[hind]] * Table23[[#This Row],[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":"Table23[[#This Row],[hind]] * Table23[[#This Row],[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":"Table23[[#This Row],[hind]] * Table23[[#This Row],[pind]]","v":3645}]
[null,null,null,null,null,null,null,null,null,"R05",4,3,{"$f":"[a]*[b]","v":12},120,{"$f":"Table23[[#This Row],[hind]] * Table23[[#This Row],[pind]]","v":1440}]
[null,null,null,null,null,null,null,null,null,"R06",7,5,{"$f":"[a]*[b]","v":35},150,{"$f":"Table23[[#This Row],[hind]] * Table23[[#This Row],[pind]]","v":5250}]
[null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUBTOTAL(109,[pind])","v":167.8},null,{"$f":"SUBTOTAL(109,[maksumus])","v":24915}]

{"sheet":"Laed_N (2)","index":15,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,4,2,5]]}
[null,null,null,"validee-\nrimine","otsimine","valemite\nkopeerimine","Klipp \"Aadressid \nja nimed\"",null,"Diagramm","veeb"]
[]
[null,"Lagede värvimine II. Nimed",null,null,"Diagrammid"]
[]
[null,"värv","hind, €/ltr","kulu, ltr/m2",null,"tariif, €/m2"]
[null,"VL_11",{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.17},{"$f":"VLOOKUP(värv, Värvid[], 2, 0)","v":0.48},null,0.6]
[null,"värv","hind","kulu"]
[]
[null,"ruum","pikkus","laius","pindala","v_kogus","v_maks","töötasu","Kokku"]
[null,"R_01",5,4,{"$f":"pikkus*laius","v":20},{"$f":"kulu*pindala","v":9.6},{"$f":"hind*v_kogus","v":30.431999999999999},{"$f":"tariif*pindala","v":12},{"$f":"v_maks+töötasu","v":42.432000000000002}]
[null,"R_02",7.2,4.8,34.56,16.588799999999999,52.586495999999997,20.736000000000001,73.322496000000001]
[null,"R_03",6.27,5.23,32.792099999999998,15.740207999999999,49.896459359999994,19.675259999999998,69.571719359999989]
[null,"R_04",7.4,6.33,46.842000000000006,22.484160000000003,71.274787200000006,28.105200000000004,99.379987200000016]
[null,"R_05",4.5999999999999996,4.3,19.779999999999998,9.4943999999999988,30.097247999999997,11.867999999999999,41.965247999999995]
[null,"R_06",7.85,6.41,50.3185,24.15288,76.564629600000004,30.191099999999999,106.7557296]
[null,"R_07",8,7,56,26.88,85.209599999999995,33.6,118.80959999999999]
[null,"R_08",6,4,24,11.52,36.5184,14.399999999999999,50.918399999999998]
[null,"R_09",5.3,4.0999999999999996,{"$f":"pikkus*laius","v":21.729999999999997},{"$f":"kulu*pindala","v":10.430399999999999},{"$f":"hind*v_kogus","v":33.064367999999995},{"$f":"tariif*pindala","v":13.037999999999998},{"$f":"v_maks+töötasu","v":46.102367999999991}]
[null,"R_10",7.2,4.5999999999999996,{"$f":"pikkus*laius","v":33.119999999999997},{"$f":"kulu*pindala","v":15.897599999999999},{"$f":"hind*v_kogus","v":50.395391999999994},{"$f":"tariif*pindala","v":19.871999999999996},{"$f":"v_maks+töötasu","v":70.267391999999987}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,[pindala])","v":339.14260000000002},{"$f":"SUBTOTAL(109,[v_kogus])","v":162.78844799999999},{"$f":"SUBTOTAL(109,[v_maks])","v":516.03938016000006},{"$f":"SUBTOTAL(109,[töötasu])","v":203.48555999999999},{"$f":"SUBTOTAL(109,[Kokku])","v":719.52494015999991}]

{"sheet":"Laed_N (3)","index":16,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,4,2,5]]}
[null,null,null,"validee-\nrimine","otsimine","valemite\nkopeerimine","Klipp \"Aadressid \nja nimed\"",null,"Diagramm","veeb"]
[]
[null,"Lagede värvimine II. Nimed",null,null,"Diagrammid"]
[]
[null,"värv","hind, €/ltr","kulu, ltr/m2",null,"tariif, €/m2"]
[null,"VL_05",{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":4.0599999999999996},{"$f":"VLOOKUP(värv, Värvid[], 2, 0)","v":0.65},null,0.6]
[null,"värv","hind","kulu"]
[]
[null,"ruum","pikkus","laius","pindala","v_kogus","v_maks","töötasu","Kokku"]
[null,"R_01",5,4,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":20},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":13},{"$f":"hind*[v_kogus]","v":52.779999999999994},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":12},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":64.78}]
[null,"R_02",7.2,4.8,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":34.56},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":22.464000000000002},{"$f":"hind*[v_kogus]","v":91.20384},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":20.736000000000001},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":111.93984}]
[null,"R_03",6.27,5.23,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":32.792099999999998},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":21.314865000000001},{"$f":"hind*[v_kogus]","v":86.538351899999995},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":19.675259999999998},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":106.21361189999999}]
[null,"R_04",7.4,6.33,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":46.842000000000006},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":30.447300000000006},{"$f":"hind*[v_kogus]","v":123.61603800000002},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":28.105200000000004},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":151.72123800000003}]
[null,"R_05",4.5999999999999996,4.3,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":19.779999999999998},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":12.856999999999999},{"$f":"hind*[v_kogus]","v":52.199419999999989},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":11.867999999999999},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":64.067419999999984}]
[null,"R_06",7.85,6.41,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":50.3185},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":32.707025000000002},{"$f":"hind*[v_kogus]","v":132.79052149999998},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":30.191099999999999},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":162.98162149999999}]
[null,"R_07",8,7,{"$f":"Table8[[#This Row],[pikkus]]*Table8[[#This Row],[laius]]","v":56},{"$f":"kulu*Table8[[#This Row],[pindala]]","v":36.4},{"$f":"hind*[v_kogus]","v":147.78399999999999},{"$f":"tariif*Table8[[#This Row],[pindala]]","v":33.6},{"$f":"[v_maks]+Table8[[#This Row],[töötasu]]","v":181.38399999999999}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,[pindala])","v":260.29259999999999},{"$f":"SUBTOTAL(109,[v_kogus])","v":169.19019},{"$f":"SUBTOTAL(109,[v_maks])","v":686.91217139999992},{"$f":"SUBTOTAL(109,[töötasu])","v":156.17555999999999},{"$f":"SUBTOTAL(109,[Kokku])","v":843.08773140000005}]

{"sheet":"Table_2_1","index":17,"n_rows":28,"n_cols":6,"rows_kept":28,"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"]
[null,"2013-11-01","kask",10,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":120},{"$f":"hind*kogus","v":1200}]
[null,"2013-11-02","saar",20,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":210},4200]
[null,"2013-11-02","mänd",13,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":150},1950]
[null,"2013-11-03","lepp",12,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":110},1320]
[null,"2013-11-03","paju",21,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":76},1596]
[null,"2013-11-03","kask",30,{"$f":"VLOOKUP(liik, Hinnakiri[], 2, 0)","v":120},3600]
[null,"Total",null,{"$f":"SUBTOTAL(109,[kogus])","v":106},null,{"$f":"SUBTOTAL(109,[maksumus])","v":13866}]

{"sheet":"Table_2_2","index":18,"n_rows":19,"n_cols":6,"rows_kept":19,"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"]
[null,"2013-11-01","kask",10,{"$f":"VLOOKUP([liik], Hinnakiri[], 2, 0)","v":120},{"$f":"[hind]*[kogus]","v":1200}]
[null,"2013-11-01","lepp",13,{"$f":"VLOOKUP([liik], Hinnakiri[], 2, 0)","v":110},{"$f":"[hind]*[kogus]","v":1430}]
[null,"2013-11-02","lepp",21,{"$f":"VLOOKUP([liik], Hinnakiri[], 2, 0)","v":110},{"$f":"[hind]*[kogus]","v":2310}]
[null,"2013-11-02","mänd",10,{"$f":"VLOOKUP([liik], Hinnakiri[], 2, 0)","v":150},{"$f":"[hind]*[kogus]","v":1500}]

{"sheet":"Hinnakiri","index":19,"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":"Fun_tab1_N","index":20,"n_rows":29,"n_cols":10,"rows_kept":29,"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,{"$f":"(lõpp-algus)/jaotisi","v":1},2,null,{"$f":"MIN(y)","v":-2.9383717218207628},{"$f":"MAX(y)","v":2.7278922804770449},{"$f":"AVERAGE(z)","v":-0.21100102233361015}]
[]
[null,"x","y","z"]
[null,{"$f":"algus","v":-10},{"$f":"3*SIN(x+2)*COS(x/2)","v":-0.84193056732976213},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":-2.6641651016669874}]
[null,{"$f":"B9+samm","v":-9},0.41547004587670799,-2.7386463011213418]
[null,-8,-0.54791447390446779,4.9435230909333461]
[null,-7,-2.6939731488413168,-1.3758166902579847]
[null,-6,-2.2476863752900278,-3.7984395642941067]
[null,-5,0.33917218044928332,4.5372339072509806]
[null,-4,1.1352037429618924,2.2128489940253928E-2]
[null,-3,-0.1785699082496302,-4.5556513094233848]
[null,-2,0,3.7695112717165231]
[null,-1,2.2153807878123861,1.4183109273161312]
[null,0,2.7278922804770449,-4.9499624830022269]
[null,1,0.37153337462150493,2.7015115293406988]
[null,2,-1.2267063999049068,2.7015115293406988]
[null,3,-0.20349485940270645,-2.2704074859237844]
[null,4,0.34883362697318027,-2.8767728239894153]
[null,5,-1.5790218571903594,-0.83824649459677758]
[null,6,-2.9383717218207628,1.9709597961563672]
[null,7,-1.157793334382389,2.9680747398701453]
[null,8,1.0667877862439166,1.2363554557252698]
[null,9,0.6323812050384181,-1.6320633326681093]
[null,10,-0.45661633974115162,-2.9999706196521103]

{"sheet":"Fun_tab2_NT","index":21,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Funktsioonide tabuleerimine ja graafikud. Variant 2 - Table-objekt"]
[]
[null,"algus","samm","p",null,"zmin","zmax","ykesk"]
[null,-5,1,2,null,{"$f":"MIN(z)","v":-4.9499624830022269},{"$f":"MAX(z)","v":4.5372339072509806},{"$f":"AVERAGE(y)","v":6.8538160242857485E-2}]
[]
[null,"x","y","z"]
[null,{"$f":"algus","v":-5},{"$f":"3*SIN(x+2)*COS(x/2)","v":0.33917218044928332},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":4.5372339072509806}]
[null,{"$f":"B9+samm","v":-4},1.1352037429618924,2.2128489940253928E-2]
[null,-3,-0.1785699082496302,-4.5556513094233848]
[null,-2,0,3.7695112717165231]
[null,-1,2.2153807878123861,1.4183109273161312]
[null,0,2.7278922804770449,-4.9499624830022269]
[null,1,0.37153337462150493,2.7015115293406988]
[null,2,-1.2267063999049068,2.7015115293406988]
[null,3,-0.20349485940270645,-2.2704074859237844]
[null,4,0.34883362697318027,-2.8767728239894153]
[null,5,-1.5790218571903594,-0.83824649459677758]
[null,6,{"$f":"3*SIN(x+2)*COS(x/2)","v":-2.9383717218207628},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":1.9709597961563672}]
[null,7,{"$f":"3*SIN(x+2)*COS(x/2)","v":-1.157793334382389},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":2.9680747398701453}]
[null,8,{"$f":"3*SIN(x+2)*COS(x/2)","v":1.0667877862439166},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":1.2363554557252698}]
[null,9,{"$f":"3*SIN(x+2)*COS(x/2)","v":0.6323812050384181},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":-1.6320633326681093}]
[null,10,{"$f":"3*SIN(x+2)*COS(x/2)","v":-0.45661633974115162},{"$f":"IF(x<=p, 5*COS(2*x-3), 3*SIN(x+1))","v":-2.9999706196521103}]

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

{"sheet":"Ruumid","index":23,"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":24,"n_rows":17,"n_cols":10,"rows_kept":17,"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.2,null,"muud",0.1]
[]
[null,"ruum","värv","pind","hind_v","kogus_v","maks_v","töötasu","muud_kulud","kulud_kokku"]
[null,"R_103","VL_05",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":18},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":4.0599999999999996},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":11.700000000000001},{"$f":"hind_v * kogus_v","v":47.502000000000002},{"$f":"tariif * pind","v":21.599999999999998},{"$f":"muud * (maks_v+töötasu)","v":6.9102000000000006},{"$f":"maks_v+töötasu+muud_kulud","v":76.012200000000007}]
[null,"R_105","VL_01",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":15.4},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.05},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":8.0080000000000009},24.424400000000002,18.48,4.2904400000000003,47.194839999999999]
[null,"R_106","VL_05",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":16},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":4.0599999999999996},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":10.4},42.223999999999997,19.2,6.1423999999999994,67.566399999999987]
[null,"R_113","VL_05",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":14.124000000000001},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":4.0599999999999996},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":9.1806000000000001},37.273235999999997,16.948799999999999,5.4222035999999996,59.644239599999992]
[null,"R_201","VL_02",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":20},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.37},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":9.6},32.351999999999997,24,5.6352000000000002,61.987199999999994]
[null,"R_202","VL_01",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":30},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.05},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":15.600000000000001},47.58,36,8.3580000000000005,91.938000000000002]
[null,"R_203","VL_01",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":11.2},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.05},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":5.8239999999999998},17.763199999999998,13.44,3.1203199999999995,34.323519999999995]
[null,"R_204","VL_05",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":12},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":4.0599999999999996},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":7.8000000000000007},31.667999999999999,14.399999999999999,4.6067999999999998,50.674799999999998]
[null,"R_107","VL_11",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":22.1},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.17},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":10.608000000000001},{"$f":"hind_v * kogus_v","v":33.627360000000003},{"$f":"tariif * pind","v":26.52},{"$f":"muud * (maks_v+töötasu)","v":6.014736000000001},{"$f":"maks_v+töötasu+muud_kulud","v":66.162096000000005}]
[null,"R_109","VL_06",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":30},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.17},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":13.5},{"$f":"hind_v * kogus_v","v":42.795000000000002},{"$f":"tariif * pind","v":36},{"$f":"muud * (maks_v+töötasu)","v":7.8795000000000002},{"$f":"maks_v+töötasu+muud_kulud","v":86.674499999999995}]
[null,"R_312","VL_06",{"$f":"VLOOKUP(ruum, Ruumid[], 5, 0)","v":17.600000000000001},{"$f":"VLOOKUP(värv, Värvid[], 3, 0)","v":3.17},{"$f":"VLOOKUP(värv, Värvid[], 2, 0) * pind","v":7.9200000000000008},{"$f":"hind_v * kogus_v","v":25.106400000000001},{"$f":"tariif * pind","v":21.12},{"$f":"muud * (maks_v+töötasu)","v":4.6226399999999996},{"$f":"maks_v+töötasu+muud_kulud","v":50.849039999999995}]

{"sheet":"Fun_XY_N","index":25,"n_rows":19,"n_cols":13,"rows_kept":19,"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,{"$f":"(bx-ax)/nx","v":0.5},5,4,14,10,{"$f":"(by-ay)/ny","v":1}]
[]
[]
[null,null,{"$f":"ax","v":2},{"$f":"C8+hx","v":2.5},3,3.5,4,4.5,5,5.5,6,6.5,7]
[null,{"$f":"ay","v":4},{"$f":"a*SIN(x)*COS(y)","v":-2.971782312561519},-1.9559374962905975,-0.46121096522276855,1.1464360954263397,2.4733956165584545,3.1947816280692334,3.1339736751241327,2.3058596653556132,0.91319078984077973,-0.70305903966928407,-2.1471754962270904]
[null,{"$f":"B9+hy","v":5},1.2896664766473047,0.84881958167695593,0.20015204949425019,-0.4975196849514103,-1.0733812489153498,-1.3864416476650305,-1.3600527772234245,-1.0006755534186678,-0.39629805435701732,0.30510702978906479,0.93181127206311676]
[null,6,4.3654018548282751,2.8731758507827752,0.6774961929547233,-1.6840581614144143,-3.6332963442876287,-4.6929768664393112,-4.6036529783965001,-3.3871942832315787,-1.3414322950010873,1.0327591031325059,3.1540950540863433]
[null,7,3.4276068997622375,2.2559474930082195,0.53195346104639607,-1.3222813307051255,-2.8527755365264267,-3.6848107969809623,-3.6146758620652917,-2.6595422098881376,-1.0532598699531388,0.81089721986854479,2.4765183892371754]
[null,8,-0.6615140317261099,-0.43538858600319552,-0.10266482971891247,0.25519485744167136,0.55057394326873321,0.71115332584604796,0.6976175719169343,0.5132807061191611,0.20327482217297155,-0.15649982769842852,-0.47795786162694914]
[null,9,-4.1424420131737314,-2.7264304069406102,-0.64289354950377275,1.598046070547978,3.4477282787244481,4.4532863605417949,4.3685246275069964,3.2141957080357573,1.2729195802431239,-0.98001165541539981,-2.993001858726867]
[null,10,-3.8148279115595423,-2.5108046853148491,-0.59204890473037042,1.4716610961595136,3.1750571347344905,4.1010884527376872,4.0230302870506387,2.9599939990072341,1.1722479466071574,-0.90250528669875807,-2.75629374984856]
[null,11,2.0121378962210879E-2,1.3243284820326601E-2,3.122772678721325E-3,-7.7623031251395557E-3,-1.6746896404180561E-2,-2.1631265375047337E-2,-2.1219546165348553E-2,-1.5612541996827899E-2,-6.1830430410459705E-3,4.7602804923487707E-3,1.4538121340630367E-2]
[null,12,3.8365711664606006,2.525115439966231,0.59542338728840072,-1.4800490767142342,-3.193153908221118,-4.1244632978596547,-4.0459602264958647,-2.976864983889933,-1.1789293714318756,0.90764926775194843,2.7720037108152269]
[null,13,4.1256951167695508,2.7154081047736667,0.6402944855607613,-1.5915855547682844,-3.4337899428032834,-4.4352827952291189,-4.3508637334876443,-3.2012014881108786,-1.2677734726395917,0.97604970407946379,2.9809018723163838]
[null,14,0.62167400333842426,0.40916708079826369,9.6481786677866499E-2,-0.23982561374121864,-0.51741533970576581,-0.6683237450195082,-0.65560318894701064,-0.48236810725972323,-0.1910324897393853,0.147074543760151,0.44917259954316735]

{"sheet":"Lisad","index":26,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Lisad"]
[]
[null,null,null,null,"Table-objekt, tulbapäisete kasutamine valemites"]
[null,null,null,null,"Otsimine. Funktsioon VLOOKUP"]
[null,null,null,null,"Valideerimine tabelites"]
[null,null,null,null,"Diagrammid"]
[null,null,null,null,"Valemite kopeerimine"]
[null,null,null,null,"R1C1- aadressid"]

{"sheet":"Valideerimine","index":27,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Valideerimine loendiga"]
[]
[null,"Määrake valideerimine allpoololevatele lahtritele"]
[null,"sugu","mees","naine või mees, määrata Data Validation boksis"]
[null,"nädalapäev","L","määrata Data Validation boksis esitähtede abil"]
[null,"nädalapäev","laupäev","loendist nimega päevad",null,"Päevad"]
[null,"kuu","oktoober","loend Kuud  lehel abi",null,"Kuud"]
[null,"töötaja","Hunt","loend T_nimi lehel abi",null,"T_nimi"]
[null,"puu liik","mänd","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"]
[null,"2014-10-13","Rebane","kuusk",2,10,{"$f":"IF(Puu_liik=\"\", \"\",VLOOKUP(Puu_liik, Hinnad, 2, 0))","v":160},{"$f":"IF(Kogus=\"\", \"\", Hind * Kogus)","v":1600}]
[null,"2014-10-13","Hunt","paju",4,34,76,2584]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]

{"sheet":"abi","index":28,"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":29,"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,"Arvutite müügid",null,null,null,"km_prots",0.18,null,null,"Arvutid"," "]
[]
[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([arvuti], Arvukid[], 5, 0)","v":730},{"$f":"[hind] *[arv]","v":2190},{"$f":"km_prots * [maks_kga]","v":394.2},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":320},{"$f":"[hind] *[arv]","v":320},{"$f":"km_prots * [maks_kga]","v":57.599999999999994},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":730},{"$f":"[hind] *[arv]","v":4380},{"$f":"km_prots * [maks_kga]","v":788.4},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":220},{"$f":"[hind] *[arv]","v":880},{"$f":"km_prots * [maks_kga]","v":158.4},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":320},{"$f":"[hind] *[arv]","v":640},{"$f":"km_prots * [maks_kga]","v":115.19999999999999},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":380},{"$f":"[hind] *[arv]","v":1140},{"$f":"km_prots * [maks_kga]","v":205.2},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":320},{"$f":"[hind] *[arv]","v":320},{"$f":"km_prots * [maks_kga]","v":57.599999999999994},{"$f":"[maks_kga] - [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([arvuti], Arvukid[], 5, 0)","v":730},{"$f":"[hind] *[arv]","v":5110},{"$f":"km_prots * [maks_kga]","v":919.8},{"$f":"[maks_kga] - [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,[arv])","v":27},null,{"$f":"SUBTOTAL(109,[maks_kga])","v":14980},{"$f":"SUBTOTAL(109,[käibemaks])","v":2696.3999999999996},{"$f":"SUBTOTAL(109,[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,{"$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":30,"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,"Frodo",{"$f":"VLOOKUP(Mark, Arvutid_1[], 6, 0)","v":1330},{"$f":"VLOOKUP(Mark, Arvutid_1[], 2, 0) & \"; \" & VLOOKUP(Mark, Arvutid_1[], 3, 0)","v":"AMD Athlon64; 3"},{"$f":"VLOOKUP(Mark, Arvutid_1[], 5, 0)","v":500},{"$f":"VLOOKUP(Mark, Arvutid_1[], 4, 0)","v":6}]
[]
[]
[null,"Arvutid"]
[null,1,2,3,4,5,6]
[]
[null,"mark","prots_tüüp","taktsagedus","mälu, GB","ketas,GB","hind, €"]
[null,"Aragorn","AMD Athlon64",3,4,160,499]
[null,"Arven","Intel Core 2",2.6,4,200,369]
[null,"Balrog","Intel Celeron",2.8,4,80,419]
[null,"Eldar","Intel Xeon",3,8,160,465]
[null,"Elend","Intel Celeron",4,12,400,1299]
[null,"Faram","AMD Athlon64",3,4,210,599]
[null,"Frodo","AMD Athlon64",3,6,500,1330]
[null,"Gandalf","Intel Xeon",3.2,4,160,849]
[null,"Grimbold","Intel Core 2",3.8,8,320,1149]
[null,"Kalvar","Intel Xeon",3,4,160,699]
[null,"Marvin","Intel Celeron",3,4,160,599]
[null,"Rohan","AMD Athlon64",3.5,4,160,589]
[null,"Sauron","Intel Xeon",2.5,2,180,339]

{"sheet":"Diagr_1","index":31,"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":"Addr_R1C1","index":33,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Kopeerimine","index":34,"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":35,"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":36,"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":37,"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":38,"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":39,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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