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

{"sheet":"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,"2015-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind * Arv","v":1740}]
[null,"2015-01-02","Valga","Balrog",1,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":419},419]
[null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,"2015-01-07","Valga","Frodo",1,870,870]
[null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,"2015-01-11","Tallinn","Marvin",1,370,370]
[null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,"2015-01-17","Tallinn","Kalvar",7,699,4893]
[null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,"2015-01-19","Võru","Elend",5,920,4600]
[null,"2015-01-19","Tallinn","Faram",3,599,1797]
[null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,"2015-01-25","Võru","Sauron",1,339,339]
[null,"2015-01-26","Pärnu","Gandalf",2,849,1698]

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

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

{"sheet":"Sort","index":6,"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,"2015-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,"2015-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2015-01-11","Tallinn","Marvin",1,370,370]
[null,null,null,null,null,null,null,null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2015-01-17","Tallinn","Kalvar",7,699,4893]
[null,null,null,null,null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,null,null,null,null,null,null,null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-19","Tallinn","Faram",3,599,1797]
[null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2015-01-26","Pärnu","Gandalf",2,849,1698]

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

{"sheet":"Filter","index":8,"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,"2015-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,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2015-01-02","Tallinn","Frodo",2,870,1740]
[null,null,null,null,null,null,null,null,"2015-01-11","Tallinn","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2015-01-26","Pärnu","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2015-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2015-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-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,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]

{"sheet":"Aren_Filter","index":9,"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.15","<=20.01.15"]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2015-01-02","Tallinn","Frodo",3,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":870},{"$f":"Hind*Arv","v":2610}]
[null,"2015-01-02","Valga","Balrog",1,419,419]
[null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,"2015-01-07","Pärnu","Balrog",3,419,1257]
[null,"2015-01-07","Valga","Frodo",1,870,870]
[null,"2015-01-07","Tallinn","Frodo",1,870,870]
[null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,"2015-01-11","Tallinn","Marvin",1,370,370]
[null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,"2015-01-16","Tallinn","Frodo",5,870,4350]
[null,"2015-01-17","Tallinn","Kalvar",7,699,4893]
[null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,"2015-01-19","Võru","Elend",5,920,4600]
[null,"2015-01-19","Tallinn","Faram",3,599,1797]
[null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,"2015-01-25","Võru","Sauron",1,339,339]
[null,"2015-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"Filter_PM_D","index":10,"n_rows":45,"n_cols":11,"rows_kept":45,"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":1254},{"$f":"DSUM(PM, \"P_maks\",Kriteerium)","v":82539}]
[null,"P_maa","P_liik"]
[null,"Rapla"]
[]
[null,null,null,null,"Kokku:",{"$f":"SUM(F13:F203)","v":1254},{"$f":"SUM(G13:G203)","v":82539}]
[]
[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,"2015-01-07","P008","Hunt","Vaher",23,1564]
[null,"2015-01-13","P013","Jänes","Vares",25,1050]
[null,"2015-01-13","P013","Jänes","Vares",22,1034]
[null,"2015-01-13","P013","Jänes","Vares",28,3080]
[null,"2015-01-19","P018","Siil","Pihel",52,3328]
[null,"2015-02-04","P033","Karu","Vaher",66,4224]
[null,"2015-02-26","P045","Hunt","Vaher",35,2450]
[null,"2015-03-11","P058","Hunt","Vaher",59,2950]
[null,"2015-03-11","P058","Hunt","Vaher",25,1750]
[null,"2015-03-11","P058","Hunt","Vaher",11,770]
[null,"2015-03-26","P071","Siil","Vares",52,3068]
[null,"2015-04-11","P084","Hunt","Vares",20,2200]
[null,"2015-05-04","P109","Karu","Pihel",12,960]
[null,"2015-05-08","P111","Jänes","Vares",40,3520]
[null,"2015-05-16","P121","Karu","Pihel",17,1105]
[null,"2015-06-28","P150","Jänes","Pihel",36,2268]
[null,"2015-07-11","P159","Põder","Vaher",61,2867]
[null,"2015-07-27","P169","Jänes","Pihel",19,1425]
[null,"2015-08-06","P179","Põder","Vaher",63,3717]
[null,"2015-08-15","P183","Jänes","Pihel",56,3808]
[null,"2015-09-04","P202","Põder","Vaher",65,3835]
[null,"2015-09-23","P216","Jänes","Pihel",74,4144]
[null,"2015-10-02","P223","Siil","Vaher",31,1550]
[null,"2015-10-03","P224","Ilves","Pihel",60,4500]
[null,"2015-12-03","P277","Jänes","Vaher",21,1239]
[null,"2015-12-11","P282","Karu","Vares",78,5616]
[null,"2015-12-11","P282","Karu","Vares",53,3445]
[null,"2015-12-11","P282","Karu","Vares",26,2210]
[null,"2015-12-21","P287","Siil","Vaher",32,2048]
[null,"2015-12-22","P288","Jänes","Pihel",12,564]
[null,"2015-12-23","P289","Hunt","Vaher",18,1710]
[null,"2015-12-27","P291","Ilves","Vaher",36,2772]
[null,"2015-12-27","P291","Ilves","Vaher",26,1768]

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

{"sheet":"Risttabelid","index":12,"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,"2015-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,"2015-01-03","Võru","Gandalf",3,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":849},2547]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2015-01-26","Pärnu","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2015-01-02","Tallinn","Frodo",2,870,1740]
[null,null,null,null,null,null,null,null,"2015-01-11","Tallinn","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2015-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2015-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]

{"sheet":"SumIF","index":13,"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,"2015-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,"2015-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,null,"2015-01-11","Tallinn","Frodo",1,870,870]
[null,"Arvud","arv",null,null,null,null,null,null,"2015-01-11","Tartu","Balrog",2,419,838]
[null,23,21,null,"Mitu korda esineb loetelus arv 13",null,null,null,null,"2015-01-11","Valga","Aragorn",1,499,499]
[null,-45,null,null,"Mitu korda esineb loetelus lahtris arv olev arv",null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,13,null,null,"Positiivsete arvude summa",null,null,null,null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,18,null,null,"Positiivsete arvude arv",null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,21,null,null,"Positiivsete arvude aritmeetiline keskmine",null,null,null,null,"2015-01-16","Tallinn","Arven",5,369,1845]
[null,13,null,null,"Mitu korda esineb loetelus arv 21",null,null,null,null,"2015-01-17","Tallinn","Balrog",7,419,2933]
[null,-16,null,null,"Negatiivsete arvude summa",null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,21,null,null,"Negatiivsete arvude arv",null,null,null,null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,13,null,null,"Negatiivsete arvude aritmeetiline keskmine",null,null,null,null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,null,"2015-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":14,"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,"2015-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,"2015-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,"2015-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2015-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2015-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,"2015-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2015-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2015-01-07","Valga","Frodo",1,870,870]
[null,null,null,null,null,null,null,null,"2015-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Elend",1,920,920]
[null,null,null,null,null,null,null,null,"2015-01-10","Pärnu","Rohan",4,340,1360]
[null,null,null,null,null,null,null,null,"2015-01-10","Tartu","Sauron",2,339,678]
[null,"Antud linnades müüdud arvutite arv ja maksumus",null,null,null,null,null,null,"2015-01-11","Tallinn","Frodo",1,870,870]
[null,"Linn",null,null,null,"Arv","Maksumus",null,"2015-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,"2015-01-11","Valga","Aragorn",1,499,499]
[null,"Tartu",null,null,null,null,null,null,"2015-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2015-01-14","Tartu","Frodo",4,870,3480]
[null,null,null,null,null,null,null,null,"2015-01-14","Valga","Kalvar",2,699,1398]
[null,"Linn","Arvuti",null,null,"Arv","Maksumus",null,"2015-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,"2015-01-17","Tallinn","Balrog",7,419,2933]
[null,null,null,null,null,null,null,null,"2015-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2015-01-18","Pärnu","Eldar",1,465,465]
[null,"Arvuti","Kuupäev","Kuupäev",null,"Arv","Maksumus",null,"2015-01-18","Tallinn","Aragorn",1,499,499]
[null,"Aragorn",">=01.01.13","<=15.01.13",null,{"$f":"DSUM(AM_1, \"Arv\", B33:D34)","v":0},{"$f":"DSUM(AM_1, \"Maksumus\", B33:D34)","v":0},null,"2015-01-19","Tallinn","Frodo",3,870,2610]
[null,null,null,null,null,null,null,null,"2015-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2015-01-19","Võru","Elend",5,920,4600]
[null,null,null,null,null,null,null,null,"2015-01-20","Tallinn","Elend",2,920,1840]
[null,null,null,null,null,null,null,null,"2015-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2015-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2015-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2015-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"P_abi","index":15,"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"]

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