{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Start","Sisukord","Loendid","A_müügid","Töötajad","Rist_koond","Filter_AT","P_Müügid","Sort","Päringud","Filter","Aren_Filter","Filter_PM_D","Kokku","Vahekokku","Risttabelid","SumIF","D_Fumkts","P_abi"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":118,"comments":12,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Tabelid 2"]
[]
[null,null,null,"Andmeloendid. Andmeanalüüs ja andmete korrastamine"]
[]
[null,null,null,"Sorteerimine, filtreerimine, kokkuvõtted, koondid jm"]

{"sheet":"Sisukord","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Andmeloendite  põhiomadused ja põhitegevused nendega"]
[null,"Arvutite müükide arvestus"]
[null,"Töötajate nimekiri"]
[null,"Puidu müükide tabel"]
[null,"Tabeli kirjete sorteerimine ja grupeerimine"]
[null,"Päringud ja filtreerimine"]
[null,"Autofilter"]
[null,"Arendatud filter"]
[null,"Makro kasutamine arendatud filtriga "]
[null," Kokkuvõtted, koondid jmt"]
[null,"Vahekokkuvõtted - Subtotals"]
[null,"Risttabelid - Pivot Table Report"]
[null,"Funktsioonid COUNTIF ja SUMIF "]
[null,"Andmebaaside funktsioonid"]

{"sheet":"Loendid","index":2,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb","klipp Andmeloendid"]
[]
["Andmeloendite  põhiomadused ja põhitegevused nendega"]
[null,null,null,null,null,null,null,"Arvutid"]
[]
[null,null,null,null,null,null,null,"Mark","Protsessori\ntüüp","Takt-\nsagedus","Põhimälu\nmaht","Kõvaketta\nmaht","Hind"]
[null,null,null,null,null,null,null,"Aragorn","AMD Athlon64",3,512,160,499]
[null,null,null,null,null,null,null,"Arven","Intel Core 2",2.6,256,200,369]
[null,null,null,null,null,null,null,"Balrog","Intel Celeron",2.8,256,80,419]
[null,null,null,null,null,null,null,"Eldar","Intel Xeon",3,512,160,465]
[null,null,null,null,null,null,null,"Elend","Intel Celeron",4,2048,400,920]
[null,null,null,null,null,null,null,"Faram","AMD Athlon64",3,512,210,599]
[null,null,null,null,null,null,null,"Frodo","AMD Athlon64",3,4072,500,870]
[null,"Põhitegevused",null,null,null,null,null,"Gandalf","Intel Xeon",3.2,512,160,849]
[null,null,null,null,null,null,null,"Grimbold","Intel Core 2",3.8,1024,320,1149]
[null,null,null,null,null,null,null,"Kalvar","Intel Xeon",3,512,160,699]
[null,null,null,null,null,null,null,"Marvin","Intel Celeron",3,512,160,370]
[null,null,null,null,null,null,null,"Rohan","AMD Athlon64",3.5,512,160,340]
[null,null,null,null,null,null,null,"Sauron","Intel Xeon",2.5,256,180,339]

{"sheet":"A_müügid","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Arvutite müükide arvestus",null,null,null,"arvutid"]
[]
[null,null,null,"Kokku",{"$f":"SUM(Arv)","v":90},null,{"$f":"SUM(Maksumus)","v":55522}]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2013-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind * Arv","v":1740}]
[null,"2013-01-02","Valga","Balrog",1,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":419},419]
[null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,"2013-01-07","Valga","Frodo",1,870,870]
[null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,"2013-01-11","Tallinn","Marvin",1,370,370]
[null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,"2013-01-17","Tallinn","Kalvar",7,699,4893]
[null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,"2013-01-19","Võru","Elend",5,920,4600]
[null,"2013-01-19","Tallinn","Faram",3,599,1797]
[null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,"2013-01-25","Võru","Sauron",1,339,339]
[null,"2013-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"Töötajad","index":4,"n_rows":105,"n_cols":16,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Töötajad"]
[null,"sortimine","autofilter","arend. filter","vahekokkuv.","risttabel"]
[]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk",null,"Sugu","Amet",null,"Sugu","Vanus"]
[null,"37303030624","Aarne","Mikson","mees",{"$f":"DATE(MID(B7,2,2),MID(B7,4,2),MID(B7,6,2))","v":"1973-03-03"},{"$f":"INT((TODAY()-F7)/365.25)","v":46},"Ost","juhataja",1970,null,"naine","juhataja",null,"mees",">50"]
[null,"46809210954","Aigi","Härm","naine","1968-09-21",51,"Ost","sekretär",720]
[null,"46605150941","Maarja","Ambros","naine","1966-05-15",53,"Ost","sekretär",950,null,"Osakond","Sugu",null,"Amet"]
[null,"45903030319","Valve","Mäesalu","naine","1959-03-03",60,"Ost","sekretär",750,null,"Ladu","naine",null,"juhataja"]
[null,"44311130888","Sirje","Härm","naine","1943-11-13",75,"Ost","sekretär",570,null,"Ost","naine",null,"sekretär"]
[null,"48305030944","Laine","Eek","naine","1983-05-03",36,"Majandus","sekretär",510,null,"Amet",null,null,"Nädalavahetus"]
[null,"48105090295","Annika","Paju","naine","1981-05-09",38,"Majandus","sekretär",510,null,null,null,null,{"$f":"WEEKDAY(F7,2)=6","v":true}]
[null,47302150417,"Mare","Eesmaa","naine","1973-02-15",46,"Majandus","juhataja",1690,null,null,null,null,{"$f":"WEEKDAY(F7,2)=7","v":false}]
[null,"45902200391","Evelin","Põld","naine","1959-02-20",60,"Majandus","sekretär",640]
[null,"44601210234","Tiina","Toomsalu","naine","1946-01-21",73,"Majandus","koristaja",430,null,"Amet"]
[null,"44203130136","Mirja","Bergmann","naine","1942-03-13",77,"Majandus","koristaja",1270,null,"sekretär"]
[null,"44012150956","Aasa","Randla","naine","1940-12-15",78,"Majandus","koristaja",480,null,"tööline"]
[null,"38301080820","Meelis","Kalju","mees","1983-01-08",36,"Ladu","tööline",510,null,"autojuht"]
[null,"48208230166","Tiina","Markus","naine","1982-08-23",37,"Ladu","tööline",500,null,"lukksepp"]
[null,"46709190988","Selma","Parre","naine","1967-09-19",52,"Ladu","tööline",710,null,"raamatupidaja"]
[null,36008130050,"Einar","Laanepõld","mees","1960-08-13",59,"Ladu","tööline",500,null,"juhataja"]
[null,"45710100356","Airi","Põld","naine","1957-10-10",62,"Ladu","kompekteerija",770,null,"dispetser"]
[null,"34810190405","Karl","Salu","mees","1948-10-19",71,"Ladu","dispetser",660,null,"müügijuht"]
[null,"34708140585","Erki","Arsenov","mees","1947-08-14",72,"Ladu","kompekteerija",690]
[null,"34506190557","Reijo","Meigas","mees","1945-06-19",74,"Ladu","tööline",640,null,"jurist"]
[null,"34404190222","Kaivo","Berk","mees","1944-04-19",75,"Ladu","tööline",510,null,"treial"]
[null,"34112180084","Anton","Meister","mees","1941-12-18",77,"Ladu","juhataja",1510,null,"referent"]
[null,"37803090504","Jaan","Laubre","mees","1978-03-09",41,"Finants","raamatupidaja",850,null,"kompekteerija"]
[null,47311270496,"Vilma","Eesmaa","naine","1973-11-27",45,"Finants","raamatupidaja",770,null,"koristaja"]
[null,47102200902,"Ene","Burmeister","naine","1971-02-20",48,"Finants","raamatupidaja",710,null,"valvur"]
[null,"47010010868","Faina","Lepp","naine","1970-10-01",49,"Finants","jurist",1570]
[null,46908050804,"Malle","Kivioja","naine","1969-08-05",50,"Finants","juhataja",2430]
[null,"46404170054","Katy","Veesimaa","naine","1964-04-17",55,"Finants","referent",650]
[null,"45711080030","Kristel","Astok","naine","1957-11-08",61,"Finants","raamatupidaja",850]
[null,"45604030496","Malle","Ligi","naine","1956-04-03",63,"Finants","jurist",1510]
[null,"44607080463","Evi","Sarapik","naine","1946-07-08",73,"Finants","raamatupidaja",850]
[null,38302070214,"Priit","Burmeister","mees","1983-02-07",36,"Transport","autojuht",770]
[null,"37708220891","Ando","Nõmmik","mees",{"$f":"DATE(MID(B39,2,2),MID(B39,4,2),MID(B39,6,2))","v":"1977-08-22"},{"$f":"INT((TODAY()-F39)/365.25)","v":42},"Transport","autojuht",770]
[null,"37509120658","Boris","Küünemäe","mees","1975-09-12",44,"Transport","autojuht",650]
[null,"47111150090","Tiina","Rajamäe","naine","1971-11-15",47,"Transport","dispetser",710]
[null,"37111200348","Margus","Roosimägi","mees","1971-11-20",47,"Transport","autojuht",910]
[null,"47110060467","Elvi","Berk","naine","1971-10-06",48,"Transport","dispetser",640]
[null,"36907260696","Hanno","Pedak","mees","1969-07-26",50,"Transport","autojuht",710]
[null,"36802240722","Ahto","Danilov","mees","1968-02-24",51,"Transport","autojuht",910]
[null,"36512210549","Paul","Naaber","mees","1965-12-21",53,"Transport","autojuht",700]
[null,"45809140289","Kristiina","Oks","naine","1958-09-14",61,"Transport","dispetser",630]
[null,"35809050610","Aadu","Malva","mees","1958-09-05",61,"Transport","autojuht",790]
[null,"35408240148","Arnold","Merilaid","mees","1954-08-24",65,"Transport","autojuht",630]
[null,"35001130124","Aarne","Oks","mees","1950-01-13",69,"Transport","autojuht",700]
[null,"34906210936","Jaan","Kaasik","mees","1949-06-21",70,"Transport","autojuht",730]
[null,"34204170615","Aadu","Pulk","mees","1942-04-17",77,"Transport","valvur",430]
[null,48801180808,"Erika","Kasemets","naine","1988-01-18",31,"Müük","sekretär",650]
[null,48704250911,"Helen","Aigro","naine","1987-04-25",32,"Müük","sekretär",570]
[null,"38303010526","Jaan","Noormets","mees","1983-03-01",36,"Müük","diiler",770]
[null,"48210210529","Faina","Kukk","naine","1982-10-21",37,"Müük","sekretär",580]
[null,"38206070961","Reijo","Okspuu","mees","1982-06-07",37,"Müük","diiler",650]
[null,"38104220473","Aare","Raudsepp","mees","1981-04-22",38,"Müük","diiler",700]
[null,"37906080465","Kristjan","Mägi","mees","1979-06-08",40,"Müük","diiler",730]
[null,"47605040659","Hilja","Raid","naine","1976-05-04",43,"Müük","sekretär",640]
[null,"47110240441","Ene","Elmik","naine","1971-10-24",48,"Müük","müügijuht",850]
[null,47110070151,"Erika","Bachmann","naine","1971-10-07",48,"Müük","müügijuht",900]
[null,"37006180544","Erno","Salumets","mees","1970-06-18",49,"Müük","juhataja",2430]
[null,"46809170171","Jana","Kaal","naine","1968-09-17",51,"Müük","sekretär",570]
[null,"36709040675","Tarmo","Müller","mees","1967-09-04",52,"Müük","müügijuht",1390]
[null,"45209010485","Juulia","Tubin","naine","1952-09-01",67,"Müük","sekretär",570]
[null,38502110722,"Karl","Agur","mees","1985-02-11",34,"Tootmine","tööline",870]
[null,"38211130833","Meelis","Petrov","mees","1982-11-13",36,"Tootmine","tööline",570]
[null,"38201060031","Raivo","Lokk","mees","1982-01-06",37,"Tootmine","tööline",650]
[null,38205190379,"Aadu","Heinlo","mees","1982-05-19",37,"Tootmine","lukksepp",570]
[null,"48109130038","Kersti","Miller","naine",{"$f":"DATE(MID(B71,2,2),MID(B71,4,2),MID(B71,6,2))","v":"1981-09-13"},{"$f":"INT((TODAY()-F71)/365.25)","v":38},"Tootmine","tööline",570]
[null,"48007150516","Erna","Eek","naine","1980-07-15",39,"Tootmine","tööline",550]
[null,"38008200347","Arnold","Norak","mees","1980-08-20",39,"Tootmine","tööline",710]
[null,"38005180669","Hanno","Pajusaar","mees","1980-05-18",39,"Tootmine","tööline",760]
[null,"37612170754","Eevald","Parts","mees","1976-12-17",42,"Tootmine","lukksepp",860]
[null,"47508150058","Irma","Piirsalu","naine","1975-08-15",44,"Tootmine","tööline",700]
[null,"37308230939","Madis","Paulus","mees","1973-08-23",46,"Tootmine","tööline",750]
[null,"37105220288","Kustav","Salu","mees","1971-05-22",48,"Tootmine","tööline",770]
[null,"47005130963","Heli","Lind","naine","1970-05-13",49,"Tootmine","tööline",500]
[null,"37003260243","Reijo","Muld","mees","1970-03-26",49,"Tootmine","tööline",790]
[null,"37005020007","Erki","Lepiksoo","mees","1970-05-02",49,"Tootmine","treial",790]
[null,"37002030149","Kristjan","Jürimäe","mees","1970-02-03",49,"Tootmine","lukksepp",850]
[null,"36504060863","Arvi","Väljas","mees","1965-04-06",54,"Tootmine","tööline",580]
[null,"36406070555","Aarne","Norak","mees","1964-06-07",55,"Tootmine","tööline",620]
[null,"36405130719","Erki","Ainsaar","mees","1964-05-13",55,"Tootmine","lukksepp",1200]
[null,"46307080393","Malle","Põldmaa","naine","1963-07-08",56,"Tootmine","tööline",650]
[null,"36203030988","Kaivo","Mets","mees","1962-03-03",57,"Tootmine","meister",920]
[null,"36110090988","Aadu","Elson","mees","1961-10-09",58,"Tootmine","tööline",750]
[null,36009040214,"Andrus","Koort","mees","1960-09-04",59,"Tootmine","treial",770]
[null,"35901050084","Ahti","Tubin","mees","1959-01-05",60,"Tootmine","treial",900]
[null,"35312110930","Kaspar","Veesimaa","mees","1953-12-11",65,"Tootmine","tööline",580]
[null,"35404050446","Reijo","Bauman","mees","1954-04-05",65,"Tootmine","tööline",700]
[null,"35105180673","Eino","Luige","mees","1951-05-18",68,"Tootmine","tööline",510]
[null,"35104120460","Reijo","Müürsepp","mees","1951-04-12",68,"Tootmine","lukksepp",770]
[null,"35009030894","Margus","Maasalu","mees","1950-09-03",69,"Tootmine","tööline",710]
[null,"34811280456","Argo","Salu","mees","1948-11-28",70,"Tootmine","tööline",770]
[null,"44406270104","Sirje","Kreen","naine","1944-06-27",75,"Tootmine","tööline",975]
[null,"34408020335","Aare","Marmor","mees","1944-08-02",75,"Tootmine","meister",950]
[null,"34309100049","Madis","Maasalu","mees","1943-09-10",76,"Tootmine","tööline",720]
[null,"44111240925","Leida","Jaanus","naine","1941-11-24",77,"Tootmine","tööline",640]
[null,"34103030178","Einar","Ehala","mees","1941-03-03",78,"Tootmine","treial",680]
[null,"34110060017","Marko","Erikson","mees","1941-10-06",78,"Tootmine","meister",920]
[null,"34107110230","Hendrik","Kanter","mees","1941-07-11",{"$f":"INT((TODAY()-F103)/365.25)","v":78},"Tootmine","juhataja",2180]
[null,"33904050217","Olav","Berk","mees","1939-04-05",80,"Tootmine","tööline",580]
[null,"33907250511","Riho","Kuusk","mees","1939-07-25",80,"Tootmine","tööline",690]

{"sheet":"Rist_koond","index":5,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Osakondade palkade summa"]
[]
["Row Labels","Sum of Palk"]
["Finants",10190]
["Ladu",7000]
["Majandus",5530]
["Müük",12000]
["Ost",4960]
["Tootmine",30025]
["Transport",10680]
["Grand Total",80385]
[]
[]
["Keskmine palk sugude ja vanuste vahemike lõike"]
[]
["Osakond","(All)"]
[]
["Average of Palk","Column Labels"]
["Row Labels","mees","naine","Grand Total"]
["25-34",870,610,696.66666666666663]
["35-44",701.33333333333337,570,655.6521739130435]
["45-54",1042.3076923076924,980,1010]
["55-64",806.25,806.25,806.25]
["65-74",674.16666666666663,616.66666666666663,662.66666666666663]
["75-84",917,787,873.66666666666663]
["Grand Total",824.57627118644064,793.375,811.969696969697]

{"sheet":"Filter_AT","index":6,"n_rows":77,"n_cols":11,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
["Kirjed, kus sugu on mees, vanus > 50 ja palk < 1000."]
[]
["Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
["36802240722","Ahto","Danilov","mees","1968-02-24",51,"Transport","autojuht",910]
["36512210549","Paul","Naaber","mees","1965-12-21",53,"Transport","autojuht",700]
["36504060863","Arvi","Väljas","mees","1965-04-06",54,"Tootmine","tööline",580]
["36406070555","Aarne","Norak","mees","1964-06-07",55,"Tootmine","tööline",620]
["36203030988","Kaivo","Mets","mees","1962-03-03",57,"Tootmine","meister",920]
["36110090988","Aadu","Elson","mees","1961-10-09",58,"Tootmine","tööline",750]
[36008130050,"Einar","Laanepõld","mees","1960-08-13",59,"Ladu","tööline",500]
[36009040214,"Andrus","Koort","mees","1960-09-04",59,"Tootmine","treial",770]
["35901050084","Ahti","Tubin","mees","1959-01-05",60,"Tootmine","treial",900]
["35809050610","Aadu","Malva","mees","1958-09-05",61,"Transport","autojuht",790]
["35312110930","Kaspar","Veesimaa","mees","1953-12-11",65,"Tootmine","tööline",580]
["35404050446","Reijo","Bauman","mees","1954-04-05",65,"Tootmine","tööline",700]
["35408240148","Arnold","Merilaid","mees","1954-08-24",65,"Transport","autojuht",630]
["35105180673","Eino","Luige","mees","1951-05-18",68,"Tootmine","tööline",510]
["35104120460","Reijo","Müürsepp","mees","1951-04-12",68,"Tootmine","lukksepp",770]
["35009030894","Margus","Maasalu","mees","1950-09-03",69,"Tootmine","tööline",710]
["35001130124","Aarne","Oks","mees","1950-01-13",69,"Transport","autojuht",700]
["34811280456","Argo","Salu","mees","1948-11-28",70,"Tootmine","tööline",770]
["34906210936","Jaan","Kaasik","mees","1949-06-21",70,"Transport","autojuht",730]
["34810190405","Karl","Salu","mees","1948-10-19",71,"Ladu","dispetser",660]
["34708140585","Erki","Arsenov","mees","1947-08-14",72,"Ladu","kompekteerija",690]
["34506190557","Reijo","Meigas","mees","1945-06-19",74,"Ladu","tööline",640]
["34404190222","Kaivo","Berk","mees","1944-04-19",75,"Ladu","tööline",510]
["34408020335","Aare","Marmor","mees","1944-08-02",75,"Tootmine","meister",950]
["34309100049","Madis","Maasalu","mees","1943-09-10",76,"Tootmine","tööline",720]
["34204170615","Aadu","Pulk","mees","1942-04-17",77,"Transport","valvur",430]
["34103030178","Einar","Ehala","mees","1941-03-03",78,"Tootmine","treial",680]
["34110060017","Marko","Erikson","mees","1941-10-06",78,"Tootmine","meister",920]
["33904050217","Olav","Berk","mees","1939-04-05",80,"Tootmine","tööline",580]
["33907250511","Riho","Kuusk","mees","1939-07-25",80,"Tootmine","tööline",690]
[]
[]
["Kirjed, kus osakond on ladu või ost ja sugu on naine"]
[]
["Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
["48208230166","Tiina","Markus","naine","1982-08-23",37,"Ladu","tööline",500]
["46809210954","Aigi","Härm","naine","1968-09-21",51,"Ost","sekretär",720]
["46709190988","Selma","Parre","naine","1967-09-19",52,"Ladu","tööline",710]
["46605150941","Maarja","Ambros","naine","1966-05-15",53,"Ost","sekretär",950]
["45903030319","Valve","Mäesalu","naine","1959-03-03",60,"Ost","sekretär",750]
["45710100356","Airi","Põld","naine","1957-10-10",62,"Ladu","kompekteerija",770]
["44311130888","Sirje","Härm","naine","1943-11-13",75,"Ost","sekretär",570]
[]
[]
["Kirjed, kus amet on juhataja või sekretär"]
[]
["Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk",null,"Amet"]
[48801180808,"Erika","Kasemets","naine","1988-01-18",31,"Müük","sekretär",650,null,"juhataja"]
[48704250911,"Helen","Aigro","naine","1987-04-25",32,"Müük","sekretär",570,null,"sekretär"]
["48305030944","Laine","Eek","naine","1983-05-03",36,"Majandus","sekretär",510]
["48210210529","Faina","Kukk","naine","1982-10-21",37,"Müük","sekretär",580]
["48105090295","Annika","Paju","naine","1981-05-09",38,"Majandus","sekretär",510]
["47605040659","Hilja","Raid","naine","1976-05-04",43,"Müük","sekretär",640]
[47302150417,"Mare","Eesmaa","naine","1973-02-15",46,"Majandus","juhataja",1690]
["37303030624","Aarne","Mikson","mees","1973-03-03",46,"Ost","juhataja",1970]
["37006180544","Erno","Salumets","mees","1970-06-18",49,"Müük","juhataja",2430]
[46908050804,"Malle","Kivioja","naine","1969-08-05",50,"Finants","juhataja",2430]
["46809170171","Jana","Kaal","naine","1968-09-17",51,"Müük","sekretär",570]
["46809210954","Aigi","Härm","naine","1968-09-21",51,"Ost","sekretär",720]
["46605150941","Maarja","Ambros","naine","1966-05-15",53,"Ost","sekretär",950]
["45902200391","Evelin","Põld","naine","1959-02-20",60,"Majandus","sekretär",640]
["45903030319","Valve","Mäesalu","naine","1959-03-03",60,"Ost","sekretär",750]
["45209010485","Juulia","Tubin","naine","1952-09-01",67,"Müük","sekretär",570]
["44311130888","Sirje","Härm","naine","1943-11-13",75,"Ost","sekretär",570]
["34112180084","Anton","Meister","mees","1941-12-18",77,"Ladu","juhataja",1510]
["34107110230","Hendrik","Kanter","mees","1941-07-11",78,"Tootmine","juhataja",2180]
[]
[]
["Kirjed, kus amet on müügijuht või jurist, vanus <=50 ja palk <= 1200"]
[]
["Eesnimi","Perenimi","Amet","Vanus","Palk",null,"Amet","Vanus","Palk"]
["Ene","Elmik","müügijuht",48,850,null,"müügijuht","<=50","<=1200"]
["Erika","Bachmann","müügijuht",48,900,null,"jurist","<=50","<=1200"]

{"sheet":"P_Müügid","index":7,"n_rows":437,"n_cols":12,"rows_kept":437,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Puidu müük",null,"AS Karu & Pojad",null,null,null,{"$f":"YEAR(C9)","v":2013},null,null,"P-abi"]
[]
[null,"sortimine","autofilter","arend. filter","vahekokkuv.","risttabel","SumIF"]
[]
[null,null,null,null,null,null,"Kokku",null,{"$f":"SUM(P_kogus)","v":17099},null,{"$f":"SUM(P_maks)","v":1121210}]
[]
[null,"P_arve","P_kuupäev","P_ostja","P_maa","P_liik","P_sort","P_müüja","P_kogus","P_hind","P_maks","P_kuu"]
[null,"P256","2013-11-04","Känd",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Harju"},"haab",1,"Ilves",23,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":50},{"$f":"P_hind * P_kogus","v":1150},{"$f":"MONTH(P_kuupäev)","v":11}]
[null,"P176","2013-08-04","Känd","Harju","kask",1,"Siil",40,70,2800,8]
[null,"P199","2013-08-30","Känd","Harju","kask",1,"Rebane",14,70,980,8]
[null,"P070","2013-03-25","Känd","Harju","kuusk",1,"Ilves",72,80,5760,3]
[null,"P070","2013-03-25","Känd","Harju","kuusk",2,"Ilves",58,72,4176,3]
[null,"P097","2013-04-24","Känd","Harju","kuusk",1,"Ilves",29,80,2320,4]
[null,"P097","2013-04-24","Känd","Harju","küte",3,"Ilves",63,38,2394,4]
[null,"P088","2013-04-16","Känd","Harju","lepp",1,"Põder",40,65,2600,4]
[null,"P176","2013-08-04","Känd","Harju","lepp",2,"Siil",31,59,1829,8]
[null,"P180","2013-08-08","Känd","Harju","lepp",3,"Hunt",31,52,1612,8]
[null,"P199","2013-08-30","Känd","Harju","lepp",3,"Rebane",10,52,520,8]
[null,"P088","2013-04-16","Känd","Harju","mänd",2,"Põder",61,68,4148,4]
[null,"P131","2013-05-29","Känd","Harju","mänd",3,"Hunt",79,60,4740,5]
[null,"P151","2013-07-01","Känd","Harju","saar",1,"Jänes",49,85,4165,7]
[null,"P180","2013-08-08","Känd","Harju","saar",1,"Hunt",23,85,1955,8]
[null,"P026","2013-01-28","Känd","Harju","tamm",2,"Siil",11,99,1089,1]
[null,"P097","2013-04-24","Känd","Harju","tamm",1,"Ilves",43,110,4730,4]
[null,"P042","2013-02-21","Mänd","Harju","haab",3,"Põder",26,40,1040,2]
[null,"P237","2013-10-16","Mänd","Harju","kask",3,"Karu",76,56,4256,10]
[null,"P237","2013-10-16","Mänd","Harju","kask",1,"Karu",49,70,3430,10]
[null,"P257","2013-11-05","Mänd","Harju","kuusk",1,"Põder",68,80,5440,11]
[null,"P009","2013-01-08","Mänd","Harju","küte",1,"Jänes",45,47,2115,1]
[null,"P244","2013-10-22","Mänd","Harju","küte",3,"Siil",61,38,2318,10]
[null,"P089","2013-04-16","Mänd","Harju","lepp",2,"Põder",25,59,1475,4]
[null,"P041","2013-02-20","Mänd","Harju","mänd",1,"Siil",74,75,5550,2]
[null,"P145","2013-06-19","Mänd","Harju","mänd",3,"Karu",47,60,2820,6]
[null,"P240","2013-10-19","Mänd","Harju","mänd",1,"Ilves",55,75,4125,10]
[null,"P257","2013-11-05","Mänd","Harju","mänd",2,"Põder",23,68,1564,11]
[null,"P042","2013-02-21","Mänd","Harju","saar",1,"Põder",49,85,4165,2]
[null,"P247","2013-10-25","Tuvi","Harju","haab",2,"Põder",10,45,450,10]
[null,"P273","2013-12-01","Tuvi","Harju","kask",2,"Karu",48,63,3024,12]
[null,"P242","2013-10-21","Tuvi","Harju","kuusk",1,"Karu",24,80,1920,10]
[null,"P247","2013-10-25","Tuvi","Harju","kuusk",1,"Põder",39,80,3120,10]
[null,"P283","2013-12-12","Tuvi","Harju","kuusk",1,"Karu",63,80,5040,12]
[null,"P284","2013-12-13","Tuvi","Harju","kuusk",1,"Hunt",26,80,2080,12]
[null,"P027","2013-01-30","Tuvi","Harju","küte",1,"Siil",27,47,1269,1]
[null,"P166","2013-07-23","Tuvi","Harju","küte",1,"Põder",17,47,799,7]
[null,"P094","2013-04-20","Tuvi","Harju","lepp",1,"Hunt",30,65,1950,4]
[null,"P129","2013-05-26","Tuvi","Harju","lepp",1,"Siil",24,65,1560,5]
[null,"P094","2013-04-20","Tuvi","Harju","mänd",2,"Hunt",53,68,3604,4]
[null,"P163","2013-07-18","Tuvi","Harju","mänd",3,"Rebane",36,60,2160,7]
[null,"P166","2013-07-23","Tuvi","Harju","mänd",1,"Põder",74,75,5550,7]
[null,"P242","2013-10-21","Tuvi","Harju","mänd",3,"Karu",60,60,3600,10]
[null,"P066","2013-03-22","Tuvi","Harju","saar",1,"Karu",67,85,5695,3]
[null,"P066","2013-03-22","Tuvi","Harju","saar",1,"Karu",52,85,4420,3]
[null,"P163","2013-07-18","Tuvi","Harju","saar",2,"Rebane",12,77,924,7]
[null,"P284","2013-12-13","Tuvi","Harju","tamm",2,"Hunt",18,99,1782,12]
[null,"P015","2013-01-16","Varblane","Harju","haab",3,"Hunt",17,40,680,1]
[null,"P059","2013-03-12","Varblane","Harju","haab",2,"Põder",75,45,3375,3]
[null,"P062","2013-03-18","Varblane","Harju","haab",2,"Jänes",49,45,2205,3]
[null,"P062","2013-03-18","Varblane","Harju","haab",1,"Jänes",36,50,1800,3]
[null,"P083","2013-04-10","Varblane","Harju","haab",1,"Rebane",30,50,1500,4]
[null,"P200","2013-08-31","Varblane","Harju","haab",1,"Rebane",25,50,1250,8]
[null,"P218","2013-09-24","Varblane","Harju","haab",2,"Rebane",58,45,2610,9]
[null,"P254","2013-11-01","Varblane","Harju","haab",1,"Jänes",26,50,1300,11]
[null,"P046","2013-02-27","Varblane","Harju","kask",1,"Rebane",34,70,2380,2]
[null,"P049","2013-03-01","Varblane","Harju","kask",1,"Siil",73,70,5110,3]
[null,"P232","2013-10-11","Varblane","Harju","kask",3,"Põder",71,56,3976,10]
[null,"P254","2013-11-01","Varblane","Harju","kask",3,"Jänes",52,56,2912,11]
[null,"P104","2013-04-30","Varblane","Harju","kuusk",2,"Ilves",54,72,3888,4]
[null,"P218","2013-09-24","Varblane","Harju","kuusk",1,"Rebane",53,80,4240,9]
[null,"P218","2013-09-24","Varblane","Harju","küte",3,"Rebane",77,38,2926,9]
[null,"P060","2013-03-13","Varblane","Harju","lepp",2,"Karu",46,59,2714,3]
[null,"P214","2013-09-21","Varblane","Harju","lepp",1,"Jänes",58,65,3770,9]
[null,"P274","2013-12-01","Varblane",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Harju"},"lepp",1,"Siil",67,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":65},{"$f":"P_hind * P_kogus","v":4355},{"$f":"MONTH(P_kuupäev)","v":12}]
[null,"P087","2013-04-15","Varblane","Harju","mänd",1,"Hunt",69,75,5175,4]
[null,"P104","2013-04-30","Varblane","Harju","mänd",1,"Ilves",25,75,1875,4]
[null,"P172","2013-07-30","Varblane","Harju","mänd",2,"Hunt",73,68,4964,7]
[null,"P015","2013-01-16","Varblane","Harju","saar",1,"Hunt",40,85,3400,1]
[null,"P083","2013-04-10","Varblane","Harju","saar",1,"Rebane",36,85,3060,4]
[null,"P102","2013-04-28","Varblane","Harju","saar",2,"Põder",48,77,3696,4]
[null,"P200","2013-08-31","Varblane","Harju","tamm",1,"Rebane",36,110,3960,8]
[null,"P015","2013-01-16","Varblane","Harju","vaher",1,"Hunt",27,95,2565,1]
[null,"P062","2013-03-18","Varblane","Harju","vaher",1,"Jänes",27,95,2565,3]
[null,"P057","2013-03-08","Ilves","Lääne","haab",1,"Siil",13,50,650,3]
[null,"P250","2013-10-28","Ilves","Lääne","haab",3,"Hunt",59,40,2360,10]
[null,"P269","2013-11-27","Ilves","Lääne","haab",3,"Karu",23,40,920,11]
[null,"P016","2013-01-17","Ilves","Lääne","kask",1,"Hunt",13,70,910,1]
[null,"P245","2013-10-23","Ilves","Lääne","kask",1,"Karu",47,70,3290,10]
[null,"P261","2013-11-13","Ilves","Lääne","kask",3,"Rebane",68,56,3808,11]
[null,"P198","2013-08-29","Ilves","Lääne","kuusk",3,"Karu",70,64,4480,8]
[null,"P241","2013-10-20","Ilves","Lääne","kuusk",2,"Siil",43,72,3096,10]
[null,"P241","2013-10-20","Ilves","Lääne","kuusk",2,"Siil",43,72,3096,10]
[null,"P245","2013-10-23","Ilves","Lääne","kuusk",3,"Karu",36,64,2304,10]
[null,"P250","2013-10-28","Ilves","Lääne","küte",1,"Hunt",56,47,2632,10]
[null,"P267","2013-11-22","Ilves","Lääne","küte",1,"Hunt",76,47,3572,11]
[null,"P267","2013-11-22","Ilves","Lääne","küte",2,"Hunt",13,42,546,11]
[null,"P143","2013-06-15","Ilves","Lääne","lepp",2,"Ilves",12,59,708,6]
[null,"P182","2013-08-13","Ilves","Lääne","lepp",1,"Karu",36,65,2340,8]
[null,"P261","2013-11-13","Ilves","Lääne","lepp",2,"Rebane",13,59,767,11]
[null,"P267","2013-11-22","Ilves","Lääne","lepp",1,"Hunt",79,65,5135,11]
[null,"P057","2013-03-08","Ilves","Lääne","mänd",2,"Siil",22,68,1496,3]
[null,"P143","2013-06-15","Ilves","Lääne","mänd",2,"Ilves",72,68,4896,6]
[null,"P152","2013-07-01","Ilves","Lääne","mänd",1,"Ilves",15,75,1125,7]
[null,"P245","2013-10-23","Ilves","Lääne","saar",3,"Karu",43,68,2924,10]
[null,"P267","2013-11-22","Ilves","Lääne","saar",1,"Hunt",34,85,2890,11]
[null,"P269","2013-11-27","Ilves","Lääne","saar",2,"Karu",32,77,2464,11]
[null,"P016","2013-01-17","Ilves","Lääne","tamm",2,"Hunt",31,99,3069,1]
[null,"P032","2013-02-03","Ilves","Lääne","vaher",2,"Karu",26,86,2236,2]
[null,"P207","2013-09-14","Ilves","Lääne","vaher",3,"Rebane",10,76,760,9]
[null,"P139","2013-06-11","Karu","Lääne","kask",1,"Põder",72,70,5040,6]
[null,"P170","2013-07-28","Karu","Lääne","kask",1,"Ilves",70,70,4900,7]
[null,"P170","2013-07-28","Karu","Lääne","kask",2,"Ilves",44,63,2772,7]
[null,"P275","2013-12-01","Karu","Lääne","kuusk",1,"Hunt",47,80,3760,12]
[null,"P280","2013-12-09","Karu","Lääne","kuusk",2,"Põder",33,72,2376,12]
[null,"P004","2013-01-04","Karu","Lääne","küte",1,"Siil",12,47,564,1]
[null,"P010","2013-01-09","Karu","Lääne","küte",2,"Hunt",6,42,252,1]
[null,"P210","2013-09-17","Karu","Lääne","küte",1,"Jänes",16,47,752,9]
[null,"P275","2013-12-01","Karu","Lääne","küte",2,"Hunt",17,42,714,12]
[null,"P098","2013-04-25","Karu","Lääne","lepp",2,"Siil",65,59,3835,4]
[null,"P139","2013-06-11","Karu","Lääne","lepp",2,"Põder",9,59,531,6]
[null,"P186","2013-08-19","Karu","Lääne","lepp",1,"Rebane",67,65,4355,8]
[null,"P239","2013-10-18","Karu","Lääne","lepp",2,"Ilves",37,59,2183,10]
[null,"P275","2013-12-01","Karu","Lääne","lepp",2,"Hunt",8,59,472,12]
[null,"P286","2013-12-20","Karu","Lääne","lepp",1,"Karu",26,65,1690,12]
[null,"P010","2013-01-09","Karu","Lääne","mänd",1,"Hunt",55,75,4125,1]
[null,"P010","2013-01-09","Karu","Lääne","mänd",2,"Hunt",39,68,2652,1]
[null,"P031","2013-02-02","Karu","Lääne","mänd",1,"Jänes",53,75,3975,2]
[null,"P213","2013-09-21","Karu","Lääne","mänd",2,"Rebane",59,68,4012,9]
[null,"P213","2013-09-21","Karu","Lääne","mänd",2,"Rebane",24,68,1632,9]
[null,"P213","2013-09-21","Karu","Lääne","saar",3,"Rebane",59,68,4012,9]
[null,"P228","2013-10-07","Karu","Lääne","saar",1,"Jänes",12,85,1020,10]
[null,"P170","2013-07-28","Karu","Lääne","tamm",1,"Ilves",19,110,2090,7]
[null,"P004","2013-01-04","Karu","Lääne","vaher",1,"Siil",39,95,3705,1]
[null,"P281","2013-12-10","Kuusk","Lääne","haab",1,"Karu",34,50,1700,12]
[null,"P092","2013-04-19","Kuusk","Lääne","kask",1,"Jänes",51,70,3570,4]
[null,"P227","2013-10-07","Kuusk","Lääne","kask",1,"Ilves",51,70,3570,10]
[null,"P262","2013-11-15","Kuusk","Lääne","kask",1,"Siil",73,70,5110,11]
[null,"P110","2013-05-06","Kuusk",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Lääne"},"küte",1,"Rebane",12,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":47},{"$f":"P_hind * P_kogus","v":564},{"$f":"MONTH(P_kuupäev)","v":5}]
[null,"P281","2013-12-10","Kuusk","Lääne","küte",1,"Karu",54,47,2538,12]
[null,"P092","2013-04-19","Kuusk","Lääne","lepp",2,"Jänes",52,59,3068,4]
[null,"P141","2013-06-13","Kuusk","Lääne","lepp",1,"Karu",46,65,2990,6]
[null,"P161","2013-07-13","Kuusk","Lääne","mänd",1,"Jänes",11,75,825,7]
[null,"P281","2013-12-10","Kuusk","Lääne","mänd",1,"Karu",78,75,5850,12]
[null,"P090","2013-04-17","Kuusk","Lääne","saar",3,"Rebane",41,68,2788,4]
[null,"P262","2013-11-15","Kuusk","Lääne","saar",1,"Siil",71,85,6035,11]
[null,"P227","2013-10-07","Kuusk","Lääne","vaher",1,"Ilves",61,95,5795,10]
[null,"P271","2013-11-29","Kass","Paide","kuusk",3,"Ilves",60,64,3840,11]
[null,"P178","2013-08-05","Kass","Paide","mänd",1,"Jänes",48,75,3600,8]
[null,"P243","2013-10-21","Kass","Paide","mänd",1,"Ilves",62,75,4650,10]
[null,"P243","2013-10-21","Kass","Paide","mänd",3,"Ilves",62,60,3720,10]
[null,"P246","2013-10-23","Kass","Paide","mänd",1,"Jänes",26,75,1950,10]
[null,"P193","2013-08-25","Kass","Paide","saar",2,"Hunt",16,77,1232,8]
[null,"P271","2013-11-29","Kass","Paide","saar",1,"Ilves",52,85,4420,11]
[null,"P069","2013-03-24","Kass","Paide","tamm",2,"Jänes",23,99,2277,3]
[null,"P193","2013-08-25","Kass","Paide","tamm",1,"Hunt",11,110,1210,8]
[null,"P229","2013-10-08","Kass","Paide","vaher",2,"Siil",20,86,1720,10]
[null,"P085","2013-04-14","Lepik","Paide","haab",2,"Karu",75,45,3375,4]
[null,"P039","2013-02-18","Lepik","Paide","kask",3,"Hunt",62,56,3472,2]
[null,"P195","2013-08-27","Lepik","Paide","kuusk",1,"Hunt",20,80,1600,8]
[null,"P012","2013-01-12","Lepik","Paide","küte",1,"Jänes",71,47,3337,1]
[null,"P122","2013-05-17","Lepik","Paide","küte",3,"Ilves",13,38,494,5]
[null,"P249","2013-10-27","Lepik","Paide","küte",1,"Ilves",78,47,3666,10]
[null,"P052","2013-03-02","Lepik","Paide","lepp",3,"Ilves",65,52,3380,3]
[null,"P293","2013-12-28","Lepik","Paide","lepp",2,"Ilves",45,59,2655,12]
[null,"P034","2013-02-05","Lepik","Paide","mänd",1,"Siil",30,75,2250,2]
[null,"P122","2013-05-17","Lepik","Paide","mänd",2,"Ilves",76,68,5168,5]
[null,"P158","2013-07-10","Lepik","Paide","mänd",1,"Siil",23,75,1725,7]
[null,"P195","2013-08-27","Lepik","Paide","mänd",3,"Hunt",43,60,2580,8]
[null,"P195","2013-08-27","Lepik","Paide","mänd",1,"Hunt",12,75,900,8]
[null,"P268","2013-11-22","Lepik","Paide","mänd",2,"Põder",41,68,2788,11]
[null,"P051","2013-03-02","Lepik","Paide","saar",3,"Karu",63,68,4284,3]
[null,"P034","2013-02-05","Lepik","Paide","tamm",1,"Siil",15,110,1650,2]
[null,"P085","2013-04-14","Lepik","Paide","vaher",1,"Karu",13,95,1235,4]
[null,"P293","2013-12-28","Lepik","Paide","vaher",1,"Ilves",21,95,1995,12]
[null,"P095","2013-04-21","Haab","Pärnu","haab",1,"Karu",41,50,2050,4]
[null,"P221","2013-09-27","Haab","Pärnu","haab",3,"Hunt",44,40,1760,9]
[null,"P230","2013-10-09","Haab","Pärnu","haab",2,"Põder",70,45,3150,10]
[null,"P002","2013-01-03","Haab","Pärnu","kask",1,"Karu",75,70,5250,1]
[null,"P095","2013-04-21","Haab","Pärnu","kuusk",1,"Karu",62,80,4960,4]
[null,"P205","2013-09-09","Haab","Pärnu","kuusk",3,"Jänes",69,64,4416,9]
[null,"P112","2013-05-09","Haab","Pärnu","küte",1,"Karu",18,47,846,5]
[null,"P230","2013-10-09","Haab","Pärnu","küte",1,"Põder",30,47,1410,10]
[null,"P080","2013-04-06","Haab","Pärnu","mänd",3,"Ilves",34,60,2040,4]
[null,"P095","2013-04-21","Haab","Pärnu","mänd",2,"Karu",21,68,1428,4]
[null,"P221","2013-09-27","Haab","Pärnu","mänd",1,"Hunt",48,75,3600,9]
[null,"P112","2013-05-09","Haab","Pärnu","saar",2,"Karu",10,77,770,5]
[null,"P204","2013-09-05","Haab","Pärnu","saar",2,"Siil",19,77,1463,9]
[null,"P002","2013-01-03","Haab","Pärnu","vaher",1,"Karu",10,95,950,1]
[null,"P079","2013-04-05","Juur","Pärnu","haab",1,"Ilves",15,50,750,4]
[null,"P082","2013-04-09","Juur","Pärnu","haab",1,"Siil",35,50,1750,4]
[null,"P130","2013-05-27","Juur","Pärnu","haab",1,"Hunt",20,50,1000,5]
[null,"P233","2013-10-12","Juur","Pärnu","haab",1,"Karu",35,50,1750,10]
[null,"P044","2013-02-25","Juur","Pärnu","kask",1,"Hunt",37,70,2590,2]
[null,"P253","2013-10-31","Juur","Pärnu","kuusk",2,"Ilves",28,72,2016,10]
[null,"P115","2013-05-11","Juur","Pärnu","küte",1,"Ilves",71,47,3337,5]
[null,"P130","2013-05-27","Juur","Pärnu","küte",2,"Hunt",11,42,462,5]
[null,"P149","2013-06-24","Juur","Pärnu","lepp",1,"Põder",32,65,2080,6]
[null,"P177","2013-08-05","Juur","Pärnu","lepp",3,"Rebane",58,52,3016,8]
[null,"P006","2013-01-06","Juur","Pärnu","mänd",2,"Rebane",37,68,2516,1]
[null,"P044","2013-02-25","Juur","Pärnu","mänd",3,"Hunt",33,60,1980,2]
[null,"P235","2013-10-14","Juur","Pärnu","mänd",1,"Karu",59,75,4425,10]
[null,"P235","2013-10-14","Juur",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Pärnu"},"saar",3,"Karu",29,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":68},{"$f":"P_hind * P_kogus","v":1972},{"$f":"MONTH(P_kuupäev)","v":10}]
[null,"P253","2013-10-31","Juur","Pärnu","saar",3,"Ilves",60,68,4080,10]
[null,"P064","2013-03-20","Juur","Pärnu","tamm",1,"Rebane",35,110,3850,3]
[null,"P064","2013-03-20","Juur","Pärnu","vaher",2,"Rebane",31,86,2666,3]
[null,"P238","2013-10-17","Kaasik","Pärnu","haab",1,"Karu",41,50,2050,10]
[null,"P077","2013-04-03","Kaasik","Pärnu","kask",1,"Põder",39,70,2730,4]
[null,"P181","2013-08-12","Kaasik","Pärnu","kask",1,"Karu",17,70,1190,8]
[null,"P127","2013-05-22","Kaasik","Pärnu","kuusk",2,"Ilves",74,72,5328,5]
[null,"P167","2013-07-24","Kaasik","Pärnu","lepp",2,"Põder",65,59,3835,7]
[null,"P181","2013-08-12","Kaasik","Pärnu","lepp",2,"Karu",72,59,4248,8]
[null,"P238","2013-10-17","Kaasik","Pärnu","lepp",3,"Karu",55,52,2860,10]
[null,"P260","2013-11-12","Kaasik","Pärnu","lepp",2,"Jänes",18,59,1062,11]
[null,"P100","2013-04-26","Kaasik","Pärnu","mänd",2,"Ilves",70,68,4760,4]
[null,"P181","2013-08-12","Kaasik","Pärnu","mänd",1,"Karu",14,75,1050,8]
[null,"P260","2013-11-12","Kaasik","Pärnu","mänd",3,"Jänes",59,60,3540,11]
[null,"P081","2013-04-08","Kaasik","Pärnu","tamm",2,"Hunt",50,99,4950,4]
[null,"P028","2013-01-31","Kask","Pärnu","haab",2,"Ilves",46,45,2070,1]
[null,"P068","2013-03-23","Kask","Pärnu","kask",1,"Ilves",32,70,2240,3]
[null,"P028","2013-01-31","Kask","Pärnu","kuusk",1,"Ilves",40,80,3200,1]
[null,"P076","2013-04-02","Kask","Pärnu","kuusk",2,"Siil",14,72,1008,4]
[null,"P272","2013-11-30","Kask","Pärnu","kuusk",1,"Ilves",29,80,2320,11]
[null,"P208","2013-09-15","Kask","Pärnu","küte",1,"Ilves",71,47,3337,9]
[null,"P259","2013-11-09","Kask","Pärnu","küte",1,"Hunt",30,47,1410,11]
[null,"P035","2013-02-12","Kask","Pärnu","lepp",1,"Karu",53,65,3445,2]
[null,"P116","2013-05-13","Kask","Pärnu","lepp",1,"Hunt",41,65,2665,5]
[null,"P116","2013-05-13","Kask","Pärnu","lepp",2,"Hunt",14,59,826,5]
[null,"P226","2013-10-06","Kask","Pärnu","lepp",2,"Jänes",20,59,1180,10]
[null,"P014","2013-01-14","Kask","Pärnu","mänd",1,"Siil",40,75,3000,1]
[null,"P038","2013-02-18","Kask","Pärnu","mänd",1,"Ilves",36,75,2700,2]
[null,"P123","2013-05-17","Kask","Pärnu","mänd",1,"Hunt",47,75,3525,5]
[null,"P014","2013-01-14","Kask","Pärnu","saar",1,"Siil",17,85,1445,1]
[null,"P038","2013-02-18","Kask","Pärnu","tamm",1,"Ilves",14,110,1540,2]
[null,"P126","2013-05-21","Kask","Pärnu","tamm",1,"Ilves",30,110,3300,5]
[null,"P187","2013-08-20","Kask","Pärnu","tamm",1,"Jänes",59,110,6490,8]
[null,"P038","2013-02-18","Kask","Pärnu","vaher",3,"Ilves",78,76,5928,2]
[null,"P073","2013-03-31","Kaun","Pärnu","haab",1,"Hunt",27,50,1350,3]
[null,"P091","2013-04-18","Kaun","Pärnu","haab",1,"Ilves",72,50,3600,4]
[null,"P114","2013-05-10","Kaun","Pärnu","haab",2,"Põder",25,45,1125,5]
[null,"P147","2013-06-21","Kaun","Pärnu","kask",2,"Karu",33,63,2079,6]
[null,"P266","2013-11-21","Kaun","Pärnu","kask",2,"Karu",70,63,4410,11]
[null,"P073","2013-03-31","Kaun","Pärnu","kuusk",1,"Hunt",21,80,1680,3]
[null,"P117","2013-05-14","Kaun","Pärnu","kuusk",3,"Jänes",55,64,3520,5]
[null,"P153","2013-07-05","Kaun","Pärnu","kuusk",3,"Põder",56,64,3584,7]
[null,"P165","2013-07-20","Kaun","Pärnu","kuusk",3,"Karu",26,64,1664,7]
[null,"P020","2013-01-23","Kaun","Pärnu","küte",1,"Põder",48,47,2256,1]
[null,"P184","2013-08-17","Kaun","Pärnu","küte",1,"Karu",14,47,658,8]
[null,"P255","2013-11-03","Kaun","Pärnu","küte",1,"Rebane",61,47,2867,11]
[null,"P050","2013-03-01","Kaun","Pärnu","lepp",1,"Ilves",65,65,4225,3]
[null,"P173","2013-07-31","Kaun","Pärnu","lepp",2,"Jänes",23,59,1357,7]
[null,"P196","2013-08-28","Kaun","Pärnu","lepp",2,"Siil",38,59,2242,8]
[null,"P093","2013-04-20","Kaun","Pärnu","mänd",3,"Jänes",71,60,4260,4]
[null,"P114","2013-05-10","Kaun","Pärnu","saar",3,"Põder",19,68,1292,5]
[null,"P148","2013-06-22","Kaun","Pärnu","tamm",2,"Rebane",65,99,6435,6]
[null,"P148","2013-06-22","Kaun","Pärnu","tamm",1,"Rebane",10,110,1100,6]
[null,"P190","2013-08-22","Kaun","Pärnu","tamm",2,"Põder",78,99,7722,8]
[null,"P255","2013-11-03","Kaun","Pärnu","vaher",1,"Rebane",26,95,2470,11]
[null,"P150","2013-06-28","Pihel","Rapla","kask",2,"Jänes",36,63,2268,6]
[null,"P216","2013-09-23","Pihel","Rapla","kask",3,"Jänes",74,56,4144,9]
[null,"P018","2013-01-19","Pihel","Rapla","kuusk",3,"Siil",52,64,3328,1]
[null,"P109","2013-05-04","Pihel","Rapla","kuusk",1,"Karu",12,80,960,5]
[null,"P288","2013-12-22","Pihel","Rapla","küte",1,"Jänes",12,47,564,12]
[null,"P121","2013-05-16","Pihel","Rapla","lepp",1,"Karu",17,65,1105,5]
[null,"P169","2013-07-27","Pihel","Rapla","mänd",1,"Jänes",19,75,1425,7]
[null,"P183","2013-08-15","Pihel","Rapla","mänd",2,"Jänes",56,68,3808,8]
[null,"P224","2013-10-03","Pihel",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Rapla"},"mänd",1,"Ilves",60,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":75},{"$f":"P_hind * P_kogus","v":4500},{"$f":"MONTH(P_kuupäev)","v":10}]
[null,"P058","2013-03-11","Vaher","Rapla","haab",1,"Hunt",59,50,2950,3]
[null,"P223","2013-10-02","Vaher","Rapla","haab",1,"Siil",31,50,1550,10]
[null,"P045","2013-02-26","Vaher","Rapla","kask",1,"Hunt",35,70,2450,2]
[null,"P058","2013-03-11","Vaher","Rapla","kask",1,"Hunt",25,70,1750,3]
[null,"P058","2013-03-11","Vaher","Rapla","kask",1,"Hunt",11,70,770,3]
[null,"P033","2013-02-04","Vaher","Rapla","kuusk",3,"Karu",66,64,4224,2]
[null,"P287","2013-12-21","Vaher","Rapla","kuusk",3,"Siil",32,64,2048,12]
[null,"P159","2013-07-11","Vaher","Rapla","küte",1,"Põder",61,47,2867,7]
[null,"P179","2013-08-06","Vaher","Rapla","lepp",2,"Põder",63,59,3717,8]
[null,"P202","2013-09-04","Vaher","Rapla","lepp",2,"Põder",65,59,3835,9]
[null,"P277","2013-12-03","Vaher","Rapla","lepp",2,"Jänes",21,59,1239,12]
[null,"P008","2013-01-07","Vaher","Rapla","saar",3,"Hunt",23,68,1564,1]
[null,"P291","2013-12-27","Vaher","Rapla","saar",2,"Ilves",36,77,2772,12]
[null,"P291","2013-12-27","Vaher","Rapla","saar",3,"Ilves",26,68,1768,12]
[null,"P289","2013-12-23","Vaher","Rapla","vaher",1,"Hunt",18,95,1710,12]
[null,"P282","2013-12-11","Vares","Rapla","kuusk",2,"Karu",78,72,5616,12]
[null,"P013","2013-01-13","Vares","Rapla","küte",2,"Jänes",25,42,1050,1]
[null,"P013","2013-01-13","Vares","Rapla","küte",1,"Jänes",22,47,1034,1]
[null,"P071","2013-03-26","Vares","Rapla","lepp",2,"Siil",52,59,3068,3]
[null,"P282","2013-12-11","Vares","Rapla","lepp",1,"Karu",53,65,3445,12]
[null,"P282","2013-12-11","Vares","Rapla","saar",1,"Karu",26,85,2210,12]
[null,"P013","2013-01-13","Vares","Rapla","tamm",1,"Jänes",28,110,3080,1]
[null,"P084","2013-04-11","Vares","Rapla","tamm",1,"Hunt",20,110,2200,4]
[null,"P111","2013-05-08","Vares","Rapla","tamm",3,"Jänes",40,88,3520,5]
[null,"P030","2013-02-01","Lind","Valga","haab",2,"Põder",44,45,1980,2]
[null,"P078","2013-04-04","Lind","Valga","haab",1,"Ilves",54,50,2700,4]
[null,"P029","2013-02-01","Lind","Valga","kask",3,"Karu",75,56,4200,2]
[null,"P135","2013-06-05","Lind","Valga","kask",2,"Rebane",23,63,1449,6]
[null,"P007","2013-01-07","Lind","Valga","kuusk",2,"Jänes",11,72,792,1]
[null,"P067","2013-03-23","Lind","Valga","kuusk",1,"Karu",11,80,880,3]
[null,"P096","2013-04-23","Lind","Valga","kuusk",3,"Ilves",45,64,2880,4]
[null,"P144","2013-06-17","Lind","Valga","kuusk",3,"Rebane",26,64,1664,6]
[null,"P201","2013-09-02","Lind","Valga","kuusk",2,"Rebane",71,72,5112,9]
[null,"P236","2013-10-15","Lind","Valga","kuusk",1,"Jänes",77,80,6160,10]
[null,"P258","2013-11-08","Lind","Valga","kuusk",2,"Karu",45,72,3240,11]
[null,"P113","2013-05-10","Lind","Valga","küte",1,"Jänes",49,47,2303,5]
[null,"P118","2013-05-15","Lind","Valga","küte",1,"Rebane",44,47,2068,5]
[null,"P160","2013-07-12","Lind","Valga","küte",2,"Põder",39,42,1638,7]
[null,"P209","2013-09-16","Lind","Valga","küte",2,"Siil",20,42,840,9]
[null,"P140","2013-06-12","Lind","Valga","lepp",1,"Karu",72,65,4680,6]
[null,"P185","2013-08-18","Lind","Valga","lepp",1,"Karu",25,65,1625,8]
[null,"P185","2013-08-18","Lind","Valga","lepp",1,"Karu",18,65,1170,8]
[null,"P201","2013-09-02","Lind","Valga","lepp",1,"Rebane",75,65,4875,9]
[null,"P258","2013-11-08","Lind","Valga","lepp",2,"Karu",18,59,1062,11]
[null,"P078","2013-04-04","Lind","Valga","mänd",1,"Hunt",8,75,600,4]
[null,"P103","2013-04-29","Lind","Valga","mänd",1,"Hunt",37,75,2775,4]
[null,"P103","2013-04-29","Lind","Valga","mänd",2,"Hunt",33,68,2244,4]
[null,"P113","2013-05-10","Lind","Valga","mänd",1,"Jänes",54,75,4050,5]
[null,"P144","2013-06-17","Lind","Valga","mänd",1,"Rebane",67,75,5025,6]
[null,"P162","2013-07-14","Lind","Valga","mänd",1,"Karu",52,75,3900,7]
[null,"P065","2013-03-21","Lind","Valga","saar",3,"Karu",18,68,1224,3]
[null,"P160","2013-07-12","Lind","Valga","saar",3,"Põder",23,68,1564,7]
[null,"P168","2013-07-25","Lind","Valga","saar",1,"Põder",45,85,3825,7]
[null,"P096","2013-04-23","Lind","Valga","tamm",1,"Jänes",37,110,4070,4]
[null,"P140","2013-06-12","Lind","Valga","vaher",3,"Karu",12,76,912,6]
[null,"P156","2013-07-08","Saar","Valga","haab",1,"Rebane",24,50,1200,7]
[null,"P279","2013-12-08","Saar","Valga","haab",1,"Rebane",21,50,1050,12]
[null,"P101","2013-04-27","Saar","Valga","kask",1,"Hunt",15,70,1050,4]
[null,"P040","2013-02-19","Saar","Valga","kuusk",1,"Jänes",22,80,1760,2]
[null,"P276","2013-12-02","Saar","Valga","kuusk",1,"Karu",36,80,2880,12]
[null,"P296","2013-12-30","Saar","Valga","kuusk",1,"Jänes",25,80,2000,12]
[null,"P128","2013-05-23","Saar","Valga","küte",3,"Karu",30,38,1140,5]
[null,"P133","2013-06-02","Saar","Valga","küte",1,"Hunt",51,47,2397,6]
[null,"P197","2013-08-29","Saar",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Valga"},"küte",2,"Rebane",52,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":42},{"$f":"P_hind * P_kogus","v":2184},{"$f":"MONTH(P_kuupäev)","v":8}]
[null,"P248","2013-10-27","Saar","Valga","küte",2,"Rebane",77,42,3234,10]
[null,"P175","2013-08-02","Saar","Valga","lepp",1,"Karu",21,65,1365,8]
[null,"P191","2013-08-23","Saar","Valga","lepp",1,"Siil",31,65,2015,8]
[null,"P055","2013-03-06","Saar","Valga","mänd",2,"Jänes",49,68,3332,3]
[null,"P056","2013-03-08","Saar","Valga","mänd",3,"Rebane",28,60,1680,3]
[null,"P175","2013-08-02","Saar","Valga","mänd",2,"Karu",14,68,952,8]
[null,"P263","2013-11-17","Saar","Valga","mänd",1,"Hunt",20,75,1500,11]
[null,"P074","2013-04-01","Saar","Valga","saar",1,"Põder",13,85,1105,4]
[null,"P108","2013-05-04","Saar","Valga","saar",2,"Ilves",37,77,2849,5]
[null,"P101","2013-04-27","Saar","Valga","vaher",3,"Hunt",24,76,1824,4]
[null,"P037","2013-02-17","Kuusik","Viljandi","haab",2,"Jänes",32,45,1440,2]
[null,"P157","2013-07-09","Kuusik","Viljandi","haab",2,"Hunt",11,45,495,7]
[null,"P206","2013-09-12","Kuusik","Viljandi","haab",2,"Ilves",70,45,3150,9]
[null,"P264","2013-11-18","Kuusik","Viljandi","haab",3,"Ilves",26,40,1040,11]
[null,"P022","2013-01-25","Kuusik","Viljandi","kask",1,"Karu",23,70,1610,1]
[null,"P022","2013-01-25","Kuusik","Viljandi","kask",1,"Karu",16,70,1120,1]
[null,"P099","2013-04-25","Kuusik","Viljandi","kask",1,"Hunt",31,70,2170,4]
[null,"P206","2013-09-12","Kuusik","Viljandi","kask",1,"Ilves",32,70,2240,9]
[null,"P023","2013-01-25","Kuusik","Viljandi","kuusk",1,"Jänes",24,80,1920,1]
[null,"P157","2013-07-09","Kuusik","Viljandi","kuusk",1,"Hunt",25,80,2000,7]
[null,"P022","2013-01-25","Kuusik","Viljandi","küte",2,"Karu",20,42,840,1]
[null,"P047","2013-02-27","Kuusik","Viljandi","küte",2,"Hunt",28,42,1176,2]
[null,"P099","2013-04-25","Kuusik","Viljandi","lepp",1,"Hunt",36,65,2340,4]
[null,"P189","2013-08-22","Kuusik","Viljandi","lepp",3,"Rebane",41,52,2132,8]
[null,"P189","2013-08-22","Kuusik","Viljandi","lepp",1,"Rebane",10,65,650,8]
[null,"P270","2013-11-28","Kuusik","Viljandi","lepp",3,"Rebane",27,52,1404,11]
[null,"P264","2013-11-18","Kuusik","Viljandi","mänd",1,"Ilves",32,75,2400,11]
[null,"P192","2013-08-24","Kuusik","Viljandi","tamm",2,"Põder",36,99,3564,8]
[null,"P053","2013-03-02","Lepp","Viljandi","haab",1,"Karu",27,50,1350,3]
[null,"P106","2013-05-03","Lepp","Viljandi","haab",3,"Ilves",45,40,1800,5]
[null,"P125","2013-05-19","Lepp","Viljandi","haab",3,"Põder",65,40,2600,5]
[null,"P292","2013-12-27","Lepp","Viljandi","haab",1,"Hunt",42,50,2100,12]
[null,"P075","2013-04-02","Lepp","Viljandi","kask",2,"Ilves",22,63,1386,4]
[null,"P119","2013-05-15","Lepp","Viljandi","kask",2,"Karu",19,63,1197,5]
[null,"P215","2013-09-22","Lepp","Viljandi","kask",2,"Ilves",79,63,4977,9]
[null,"P215","2013-09-22","Lepp","Viljandi","kask",1,"Ilves",47,70,3290,9]
[null,"P011","2013-01-11","Lepp","Viljandi","kuusk",1,"Karu",24,80,1920,1]
[null,"P025","2013-01-27","Lepp","Viljandi","kuusk",1,"Siil",15,80,1200,1]
[null,"P061","2013-03-15","Lepp","Viljandi","kuusk",3,"Siil",23,64,1472,3]
[null,"P134","2013-06-04","Lepp","Viljandi","kuusk",1,"Siil",31,80,2480,6]
[null,"P138","2013-06-10","Lepp","Viljandi","kuusk",1,"Hunt",54,80,4320,6]
[null,"P278","2013-12-05","Lepp","Viljandi","kuusk",3,"Jänes",55,64,3520,12]
[null,"P054","2013-03-05","Lepp","Viljandi","küte",2,"Karu",177,42,7434,3]
[null,"P106","2013-05-03","Lepp","Viljandi","küte",2,"Ilves",31,42,1302,5]
[null,"P054","2013-03-05","Lepp","Viljandi","lepp",2,"Karu",37,59,2183,3]
[null,"P225","2013-10-05","Lepp","Viljandi","lepp",2,"Siil",29,59,1711,10]
[null,"P107","2013-05-03","Lepp","Viljandi","mänd",3,"Rebane",17,60,1020,5]
[null,"P203","2013-09-04","Lepp","Viljandi","mänd",1,"Põder",13,75,975,9]
[null,"P292","2013-12-27","Lepp","Viljandi","mänd",1,"Hunt",65,75,4875,12]
[null,"P072","2013-03-26","Lepp","Viljandi","saar",1,"Ilves",8,85,680,3]
[null,"P075","2013-04-02","Lepp","Viljandi","saar",1,"Ilves",35,85,2975,4]
[null,"P295","2013-12-30","Lepp","Viljandi","saar",1,"Karu",17,85,1445,12]
[null,"P024","2013-01-27","Lepp","Viljandi","tamm",2,"Karu",51,99,5049,1]
[null,"P011","2013-01-11","Lepp","Viljandi","vaher",3,"Jänes",16,76,1216,1]
[null,"P053","2013-03-02","Lepp","Viljandi","vaher",1,"Hunt",11,95,1045,3]
[null,"P138","2013-06-10","Lepp","Viljandi","vaher",3,"Hunt",25,76,1900,6]
[null,"P231","2013-10-10","Luik","Viljandi","haab",2,"Karu",46,45,2070,10]
[null,"P036","2013-02-13","Luik","Viljandi","kuusk",3,"Karu",72,64,4608,2]
[null,"P174","2013-08-01","Luik","Viljandi","kuusk",1,"Hunt",12,80,960,8]
[null,"P188","2013-08-21","Luik","Viljandi","kuusk",2,"Hunt",61,72,4392,8]
[null,"P231","2013-10-10","Luik","Viljandi","küte",2,"Karu",71,42,2982,10]
[null,"P036","2013-02-13","Luik","Viljandi","lepp",1,"Ilves",53,65,3445,2]
[null,"P120","2013-05-15","Luik","Viljandi","lepp",3,"Siil",33,52,1716,5]
[null,"P124","2013-05-18","Luik",{"$f":"VLOOKUP(P_ostja, o_tab, 2, 0)","v":"Viljandi"},"tamm",1,"Põder",32,{"$f":"VLOOKUP(P_liik, P_hinnad, P_sort+1, 0)","v":110},{"$f":"P_hind * P_kogus","v":3520},{"$f":"MONTH(P_kuupäev)","v":5}]
[null,"P154","2013-07-06","Luik","Viljandi","tamm",3,"Rebane",11,88,968,7]
[null,"P017","2013-01-18","Paju","Võru","kask",1,"Põder",50,70,3500,1]
[null,"P220","2013-09-26","Paju","Võru","kuusk",1,"Rebane",28,80,2240,9]
[null,"P222","2013-09-29","Paju","Võru","kuusk",2,"Rebane",34,72,2448,9]
[null,"P234","2013-10-13","Paju","Võru","kuusk",3,"Ilves",63,64,4032,10]
[null,"P164","2013-07-18","Paju","Võru","küte",1,"Karu",34,47,1598,7]
[null,"P234","2013-10-13","Paju","Võru","mänd",1,"Ilves",73,75,5475,10]
[null,"P251","2013-10-29","Paju","Võru","mänd",2,"Karu",55,68,3740,10]
[null,"P251","2013-10-29","Paju","Võru","mänd",2,"Karu",50,68,3400,10]
[null,"P265","2013-11-19","Paju","Võru","saar",3,"Hunt",62,68,4216,11]
[null,"P265","2013-11-19","Paju","Võru","vaher",1,"Hunt",25,95,2375,11]
[null,"P137","2013-06-09","Seen","Võru","haab",1,"Siil",52,50,2600,6]
[null,"P171","2013-07-29","Seen","Võru","haab",2,"Põder",37,45,1665,7]
[null,"P211","2013-09-18","Seen","Võru","haab",2,"Karu",21,45,945,9]
[null,"P212","2013-09-19","Seen","Võru","haab",1,"Siil",31,50,1550,9]
[null,"P294","2013-12-29","Seen","Võru","haab",2,"Karu",13,45,585,12]
[null,"P063","2013-03-19","Seen","Võru","kask",1,"Siil",73,70,5110,3]
[null,"P219","2013-09-25","Seen","Võru","kask",2,"Ilves",40,63,2520,9]
[null,"P105","2013-05-02","Seen","Võru","kuusk",1,"Ilves",36,80,2880,5]
[null,"P171","2013-07-29","Seen","Võru","kuusk",3,"Põder",31,64,1984,7]
[null,"P290","2013-12-24","Seen","Võru","kuusk",1,"Ilves",78,80,6240,12]
[null,"P005","2013-01-06","Seen","Võru","küte",1,"Põder",44,47,2068,1]
[null,"P021","2013-01-24","Seen","Võru","küte",2,"Jänes",45,42,1890,1]
[null,"P086","2013-04-14","Seen","Võru","küte",2,"Ilves",68,42,2856,4]
[null,"P132","2013-05-30","Seen","Võru","küte",2,"Rebane",12,42,504,5]
[null,"P136","2013-06-08","Seen","Võru","küte",1,"Hunt",56,47,2632,6]
[null,"P194","2013-08-27","Seen","Võru","küte",1,"Karu",14,47,658,8]
[null,"P252","2013-10-30","Seen","Võru","küte",1,"Ilves",23,47,1081,10]
[null,"P285","2013-12-16","Seen","Võru","küte",1,"Karu",33,47,1551,12]
[null,"P003","2013-01-03","Seen","Võru","lepp",2,"Karu",13,59,767,1]
[null,"P048","2013-02-28","Seen","Võru","lepp",3,"Siil",23,52,1196,2]
[null,"P146","2013-06-20","Seen","Võru","lepp",1,"Siil",24,65,1560,6]
[null,"P155","2013-07-07","Seen","Võru","lepp",1,"Ilves",63,65,4095,7]
[null,"P001","2013-01-02","Seen","Võru","mänd",2,"Siil",28,68,1904,1]
[null,"P021","2013-01-24","Seen","Võru","mänd",1,"Jänes",73,75,5475,1]
[null,"P063","2013-03-19","Seen","Võru","mänd",2,"Siil",52,68,3536,3]
[null,"P132","2013-05-30","Seen","Võru","mänd",3,"Rebane",28,60,1680,5]
[null,"P142","2013-06-14","Seen","Võru","mänd",1,"Rebane",24,75,1800,6]
[null,"P155","2013-07-07","Seen","Võru","mänd",2,"Ilves",23,68,1564,7]
[null,"P285","2013-12-16","Seen","Võru","mänd",3,"Karu",60,60,3600,12]
[null,"P019","2013-01-20","Seen","Võru","saar",1,"Hunt",69,85,5865,1]
[null,"P043","2013-02-22","Seen","Võru","saar",2,"Hunt",24,77,1848,2]
[null,"P217","2013-09-23","Seen","Võru","saar",2,"Siil",26,77,2002,9]
[null,"P194","2013-08-27","Seen","Võru","vaher",3,"Karu",69,76,5244,8]

{"sheet":"Sort","index":8,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,9,0,10],[0,5,0,6]]}
[null,null,null,null,"veeb","klipp Sortimine",null,null,null,"Harjutustabelid"]
[null,null,null,null,null,null,null,null,null,"Töötajad","Puidu müük"]
[]
[null,null,null,null,null,null,null,null,"Arvutite müükide arvestus"]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2013-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind * Arv","v":1740}]
[null,null,null,null,null,null,null,null,"2013-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2013-01-11","Tallinn","Marvin",1,370,370]
[null,null,null,null,null,null,null,null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2013-01-17","Tallinn","Kalvar",7,699,4893]
[null,null,null,null,null,null,null,null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,null,null,null,null,null,null,null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-19","Tallinn","Faram",3,599,1797]
[null,null,null,null,null,null,null,null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2013-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2013-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2013-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"Päringud","index":9,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]

{"sheet":"Filter","index":10,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,8,0,9],[0,5,0,6]]}
[null,null,null,null,"veeb","Klipp Autofilter",null,null,"Harjutustabelid"]
[null,null,null,null,null,null,null,null,"töötajad","puidu müük"]
[null,"Filter - harilik filter ehk autofilter",null,null,null,null,null,null,null,null,null,null,null,"NB! Subtotal"]
[null,null,null,null,null,null,null,null,"Arvutite müükide arvestus",null,null,{"$f":"SUBTOTAL(9, L7:L40)","v":90},{"$f":"SUBTOTAL(1, M7:M40)","v":611.85294117647061},{"$f":"SUBTOTAL(9, N7:N40)","v":54875}]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Aragorn",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":499},{"$f":"Hind*Arv","v":998}]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2013-01-02","Tallinn","Frodo",2,870,1740]
[null,null,null,null,null,null,null,null,"2013-01-11","Tallinn","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2013-01-26","Pärnu","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2013-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2013-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-18","Pärnu","Eldar",1,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":465},{"$f":"Hind*Arv","v":465}]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2013-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2013-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2013-01-04","Tartu","Balrog",5,419,2095]

{"sheet":"Aren_Filter","index":11,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,5,0,6],[1,3,1,4],[1,5,1,6]]}
[null,null,null,null,"veeb","klipp Arendatud filter 1",null,null,null,"Harjutustabelid:"]
[null,null,null,"klipp Arendatud filter 2",null,"klipp Arendatud filter 3",null,null,null,"Töötajad","Puidu müük"]
[]
[]
[null,"Arvutite müükide arvestus"]
[]
[null,"Linn",null,"Linn","Arvuti",null,"Maksumus"]
[null,"Pärnu",null,"Tallinn","Frodo",null,">2000"]
[]
[null,"Linn",null,"Linn","Arvuti","Arv"]
[null,"Tallinn",null,"Tallinn","Balrog",">1"]
[null,"Tartu",null,"Tartu","Balrog",">1"]
[null,"Võru"]
[null,null,null,"Arvuti","Kuupäev","Kuupäev"]
[null,"AM_AF",null,"Aragorn",">=10.01.13","<=20.01.13"]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2013-01-02","Tallinn","Frodo",3,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind*Arv","v":2610}]
[null,"2013-01-02","Valga","Balrog",1,419,419]
[null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,"2013-01-07","Pärnu","Balrog",3,419,1257]
[null,"2013-01-07","Valga","Frodo",1,870,870]
[null,"2013-01-07","Tallinn","Frodo",1,870,870]
[null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,"2013-01-11","Tallinn","Marvin",1,370,370]
[null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,"2013-01-16","Tallinn","Frodo",5,870,4350]
[null,"2013-01-17","Tallinn","Kalvar",7,699,4893]
[null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,"2013-01-19","Võru","Elend",5,920,4600]
[null,"2013-01-19","Tallinn","Faram",3,599,1797]
[null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,"2013-01-25","Võru","Sauron",1,339,339]
[null,"2013-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"Filter_PM_D","index":12,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Demo. Demo. Demo "]
[null,"Puidu müük. Väljavõtete tegemine maakondade ja puidu liikide lõikes"]
[]
[null,"Maakond","puidu liik",null,null,null,null,null,null,{"$f":"DSUM(PM, \"P_kogus\", Kriteerium)","v":1991},{"$f":"DSUM(PM, \"P_maks\",Kriteerium)","v":123774}]
[null,"P_maa","P_liik"]
[null,"Viljandi"]
[]
[null,null,null,null,"Kokku:",{"$f":"SUM(F13:F203)","v":1991},{"$f":"SUM(G13:G203)","v":123774}]
[]
[null,"Kuupäev","Arve","Müüja","Ostja","Kogus","Maksumus"]
[null,"P_kuupäev","P_arve","P_müüja","P_ostja","P_kogus","P_maks"]
[null,"2013-01-11","P011","Karu","Lepp",24,1920]
[null,"2013-01-11","P011","Jänes","Lepp",16,1216]
[null,"2013-01-25","P022","Karu","Kuusik",23,1610]
[null,"2013-01-25","P022","Karu","Kuusik",16,1120]
[null,"2013-01-25","P022","Karu","Kuusik",20,840]
[null,"2013-01-25","P023","Jänes","Kuusik",24,1920]
[null,"2013-01-27","P024","Karu","Lepp",51,5049]
[null,"2013-01-27","P025","Siil","Lepp",15,1200]
[null,"2013-02-13","P036","Karu","Luik",72,4608]
[null,"2013-02-13","P036","Ilves","Luik",53,3445]
[null,"2013-02-17","P037","Jänes","Kuusik",32,1440]
[null,"2013-02-27","P047","Hunt","Kuusik",28,1176]
[null,"2013-03-02","P053","Karu","Lepp",27,1350]
[null,"2013-03-02","P053","Hunt","Lepp",11,1045]
[null,"2013-03-05","P054","Karu","Lepp",177,7434]
[null,"2013-03-05","P054","Karu","Lepp",37,2183]
[null,"2013-03-15","P061","Siil","Lepp",23,1472]
[null,"2013-03-26","P072","Ilves","Lepp",8,680]
[null,"2013-04-02","P075","Ilves","Lepp",22,1386]
[null,"2013-04-02","P075","Ilves","Lepp",35,2975]
[null,"2013-04-25","P099","Hunt","Kuusik",31,2170]
[null,"2013-04-25","P099","Hunt","Kuusik",36,2340]
[null,"2013-05-03","P106","Ilves","Lepp",45,1800]
[null,"2013-05-03","P106","Ilves","Lepp",31,1302]
[null,"2013-05-03","P107","Rebane","Lepp",17,1020]
[null,"2013-05-15","P119","Karu","Lepp",19,1197]
[null,"2013-05-15","P120","Siil","Luik",33,1716]
[null,"2013-05-18","P124","Põder","Luik",32,3520]
[null,"2013-05-19","P125","Põder","Lepp",65,2600]
[null,"2013-06-04","P134","Siil","Lepp",31,2480]
[null,"2013-06-10","P138","Hunt","Lepp",54,4320]
[null,"2013-06-10","P138","Hunt","Lepp",25,1900]
[null,"2013-07-06","P154","Rebane","Luik",11,968]
[null,"2013-07-09","P157","Hunt","Kuusik",11,495]
[null,"2013-07-09","P157","Hunt","Kuusik",25,2000]
[null,"2013-08-01","P174","Hunt","Luik",12,960]
[null,"2013-08-21","P188","Hunt","Luik",61,4392]
[null,"2013-08-22","P189","Rebane","Kuusik",41,2132]
[null,"2013-08-22","P189","Rebane","Kuusik",10,650]
[null,"2013-08-24","P192","Põder","Kuusik",36,3564]
[null,"2013-09-04","P203","Põder","Lepp",13,975]
[null,"2013-09-12","P206","Ilves","Kuusik",70,3150]
[null,"2013-09-12","P206","Ilves","Kuusik",32,2240]
[null,"2013-09-22","P215","Ilves","Lepp",79,4977]
[null,"2013-09-22","P215","Ilves","Lepp",47,3290]
[null,"2013-10-05","P225","Siil","Lepp",29,1711]
[null,"2013-10-10","P231","Karu","Luik",46,2070]
[null,"2013-10-10","P231","Karu","Luik",71,2982]
[null,"2013-11-18","P264","Ilves","Kuusik",26,1040]
[null,"2013-11-18","P264","Ilves","Kuusik",32,2400]
[null,"2013-11-28","P270","Rebane","Kuusik",27,1404]
[null,"2013-12-05","P278","Jänes","Lepp",55,3520]
[null,"2013-12-27","P292","Hunt","Lepp",42,2100]
[null,"2013-12-27","P292","Hunt","Lepp",65,4875]
[null,"2013-12-30","P295","Karu","Lepp",17,1445]

{"sheet":"Kokku","index":13,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"veeb"]

{"sheet":"Vahekokku","index":14,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,9,0,10],[0,5,0,7]]}
[null,null,null,null,"veeb","Klipp Vahekokkuvõtted",null,null,null,"Harjutustabelid"]
[null,null,null,null,null,null,null,null,null,"töötajad","puidu müük"]
[]
[null,"Arvutite müükide arvestus"]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2013-01-07","Pärnu","Eldar",3,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":465},{"$f":"Hind*Arv","v":1395}]
[null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,"2013-01-21","Pärnu","Arven",2,369,738]
[null,"2013-01-26","Pärnu","Gandalf",2,849,1698]
[null,"2013-01-02","Tallinn","Frodo",2,870,1740]
[null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,"2013-01-11","Tallinn","Frodo",1,870,870]
[null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,"2013-01-17","Tallinn","Balrog",7,419,2933]
[null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,"2013-01-19","Tallinn","Frodo",3,870,2610]
[null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,"2013-01-02","Valga","Balrog",1,419,419]
[null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,"2013-01-07","Valga","Frodo",1,870,870]
[null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,"2013-01-19","Võru","Elend",5,920,4600]
[null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,"2013-01-25","Võru","Sauron",1,339,339]

{"sheet":"Risttabelid","index":15,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,null,"veeb","Klipp Risttabelid",null,null,null,"Harjutustabelid:"]
[null,null,null,null,null,null,null,null,null,"Töötajad","Puidu müük"]
[]
[null,null,null,null,null,null,null,null,"Arvutite müükide arvestus"]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2013-01-02","Valga","Balrog",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":419},{"$f":"Hind*Arv","v":838}]
[null,null,null,null,null,null,null,null,"2013-01-03","Võru","Gandalf",3,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":849},2547]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2013-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2013-01-26","Pärnu","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2013-01-02","Tallinn","Frodo",2,870,1740]
[null,null,null,null,null,null,null,null,"2013-01-11","Tallinn","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2013-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2013-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2013-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2013-01-04","Tartu","Balrog",5,419,2095]

{"sheet":"SumIF","index":16,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
[null,null,null,null,"veeb","Klipp SumIF",null,null,null,"Harjutustabel",null,"Puidu müük"]
[]
[null,"Funktsioonid COUNTIF ja SUMIF ",null,null,null,null,null,null,null,"Arvutite müükide arvestus",null,null,null,"AM_SIF"]
[]
[null,null,null,null,null,null,null,null,null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus"]
[null,null,null,null,null,null,null,null,null,"2013-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(A_Arvuti, Arvutid, 6, 0)","v":870},{"$f":"A_Hind*A_Arv","v":1740}]
[null,null,null,null,null,null,null,null,null,"2013-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,null,"2013-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,null,"2013-01-11","Tallinn","Frodo",1,870,870]
[null,"Arvud","arv",null,null,null,null,null,null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,23,21,null,"Mitu korda esineb loetelus arv 13",null,null,null,null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,-45,null,null,"Mitu korda esineb loetelus lahtris arv olev arv",null,null,null,null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,13,null,null,"Positiivsete arvude summa",null,null,null,null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,18,null,null,"Positiivsete arvude arv",null,null,null,null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,21,null,null,"Positiivsete arvude aritmeetiline keskmine",null,null,null,null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,13,null,null,"Mitu korda esineb loetelus arv 21",null,null,null,null,"2013-01-17","Tallinn","Balrog",7,419,2933]
[null,-16,null,null,"Negatiivsete arvude summa",null,null,null,null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,21,null,null,"Negatiivsete arvude arv",null,null,null,null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,13,null,null,"Negatiivsete arvude aritmeetiline keskmine",null,null,null,null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,null,"2013-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,null,"2013-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,null,"2013-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,null,"2013-01-26","Pärnu","Gandalf",2,849,1698]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M6:M40)","v":90},null,54875]

{"sheet":"D_Fumkts","index":17,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Müükide arvestus",null,null,{"$f":"SUBTOTAL(9, L8:L42)","v":90},null,{"$f":"SUBTOTAL(9, N8:N42)","v":54875}]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2013-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind*Arv","v":1740}]
[null,null,null,null,null,null,null,null,"2013-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,"2013-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2013-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2013-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,"2013-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2013-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2013-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2013-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2013-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2013-01-10","Tartu","Sauron",2,339,678]
[null,"Antud linnades müüdud arvutite arv ja maksumus",null,null,null,null,null,null,"2013-01-11","Tallinn","Frodo",1,870,870]
[null,"Linn",null,null,null,"Arv","Maksumus",null,"2013-01-11","Tartu","Balrog",2,419,838]
[null,"Tallinn",null,null,null,{"$f":"DSUM(AM_1, \"Arv\", B24:B26)","v":53},{"$f":"DSUM(AM_1, \"Maksumus\", B24:B26)","v":32767},null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,"Tartu",null,null,null,null,null,null,"2013-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2013-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2013-01-14","Valga","Kalvar",2,699,1398]
[null,"Linn","Arvuti",null,null,"Arv","Maksumus",null,"2013-01-16","Tallinn","Arven",5,369,1845]
[null,"Tallinn","Aragorn",null,null,{"$f":"DSUM(AM_1, \"Arv\", B29:C30)","v":3},{"$f":"DSUM(AM_1, \"Maksumus\", B29:C30)","v":1497},null,"2013-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2013-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2013-01-18","Pärnu","Eldar",1,465,465]
[null,"Arvuti","Kuupäev","Kuupäev",null,"Arv","Maksumus",null,"2013-01-18","Tallinn","Aragorn",1,499,499]
[null,"Aragorn",">=01.01.13","<=15.01.13",null,{"$f":"DSUM(AM_1, \"Arv\", B33:D34)","v":3},{"$f":"DSUM(AM_1, \"Maksumus\", B33:D34)","v":1497},null,"2013-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2013-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2013-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2013-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2013-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2013-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2013-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2013-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"P_abi","index":18,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,4]]}
[]
[null,"Puidu hinnkiri"]
[]
[null,"Liik","Sort"]
[null,null,1,2,3]
[null,"haab",50,45,40]
[null,"kask",70,63,56]
[null,"kuusk",80,72,64]
[null,"küte",47,42,38]
[null,"lepp",65,59,52]
[null,"mänd",75,68,60]
[null,"saar",85,77,68]
[null,"tamm",110,99,88]
[null,"vaher",95,86,76]
[]
[]
[]
[null,"P_müüjad",null,"Maakonnad"]
[null,"Karu",null,"Harju"]
[null,"Hunt",null,"Lääne"]
[null,"Jänes",null,"Paide"]
[null,"Rebane",null,"Pärnu"]
[null,"Siil",null,"Rapla"]
[null,"Põder",null,"Valga"]
[null,"Ilves",null,"Viljandi"]
[null,null,null,"Võru"]
[]
[]
[null,"P_ostjad","Maakond"]
[null,"Haab","Pärnu"]
[null,"Ilves","Lääne"]
[null,"Juur","Pärnu"]
[null,"Kaasik","Pärnu"]
[null,"Karu","Lääne"]
[null,"Kask","Pärnu"]
[null,"Kass","Paide"]
[null,"Kaun","Pärnu"]
[null,"Kuusik","Viljandi"]
[null,"Kuusk","Lääne"]
[null,"Känd","Harju"]
[null,"Lepik","Paide"]
[null,"Lepp","Viljandi"]
[null,"Lind","Valga"]
[null,"Luik","Viljandi"]
[null,"Mänd","Harju"]
[null,"Paju","Võru"]
[null,"Pihel","Rapla"]
[null,"Saar","Valga"]
[null,"Seen","Võru"]
[null,"Tuvi","Harju"]
[null,"Vaher","Rapla"]
[null,"Varblane","Harju"]
[null,"Vares","Rapla"]