{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Start","Sisukord","Loendid","A_müügid","Töötajad","Filter_AT","Rist_T1","P_Müügid","Filter_PM1","Filter_PM2","Rist_PM","SumIF_PM","Sort","Päringud","Autofilter","Auto_AM","Aren_Filter","Filter_AM","Filter_PM_D","Kokku","Vahekokku","Risttabelid","Rist_A1","Rist_A2","SumIF","Sheet2","SumIF (2)","Sum_IF_AM","D_Fumkts","P_abi"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":127,"comments":14,"pivot_tables":10},"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"]
[]
[null,null,null,"Sorteerimine, filtreerimine, kokkuvõted ja koondid"]

{"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":[]}
[]
[]
["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,1299]
[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,1330]
[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,599]
[null,null,null,null,null,null,null,"Rohan","AMD Athlon64",3.5,512,160,589]
[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":62999}]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2013-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":1330},{"$f":"Hind * Arv","v":2660}]
[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","Eldar",3,465,1395]
[null,"2013-01-07","Valga","Frodo",1,1330,1330]
[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,589,2356]
[null,"2013-01-10","Pärnu","Elend",1,1299,1299]
[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,599,599]
[null,"2013-01-11","Valga","Aragorn",1,499,499]
[null,"2013-01-14","Tartu","Frodo",4,1330,5320]
[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,1299,6495]
[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,1299,2598]
[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":14,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"aa"]
[null,null,null,{"$f":"J7 > AVERAGE(Palk)","v":false},null,{"$f":"AVERAGE(Palk)","v":1181.3030303030303},"Sugu","Palk","Vanus",null,"Osakond","Sugu",null,"Amet"]
[null,"Töötajad",null,null,null,null,"mees","<1000",">50",null,"Ost","naine"]
[null,"sortimine","autofilter","arend. filter","vahe","risttabel",null,null,null,null,"Ladu","naine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Amet"]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk",null,null,null,"tööline"]
[null,38502110722,"Karl","Agur","mees",{"$f":"DATE(MID(B7,2,2),MID(B7,4,2),MID(B7,6,2))","v":"1985-02-11"},{"$f":"INT((TODAY()-F7)/365.25)","v":28},"Tootmine","tööline",720,null,null,null,"sekretär"]
[null,48704250911,"Helen","Aigro","naine","1987-04-25",26,"Müük","sekretär",850,null,null,null,"lukksepp"]
[null,"36405130719","Erki","Ainsaar","mees","1964-05-13",49,"Tootmine","lukksepp",1150,null,null,null,"sekretäär"]
[null,"46605150941","Maarja","Ambros","naine","1966-05-15",47,"Ost","sekretäär",850,null,null,null,"kompekteerija"]
[null,"34708140585","Erki","Arsenov","mees","1947-08-14",66,"Ladu","kompekteerija",1030,null,null,null,"raamatupidaja"]
[null,"45711080030","Kristel","Astok","naine","1957-11-08",56,"Finants","raamatupidaja",1274,null,null,null,"müügijuht"]
[null,47110070151,"Erika","Bachmann","naine","1971-10-07",42,"Müük","müügijuht",1350,null,null,null,"koristaja"]
[null,"35404050446","Reijo","Bauman","mees","1954-04-05",59,"Tootmine","tööline",1050,null,null,null,"dispetser"]
[null,"44203130136","Mirja","Bergmann","naine","1942-03-13",71,"Majandus","koristaja",650,null,null,null,"autojuht"]
[null,"47110060467","Elvi","Berk","naine","1971-10-06",42,"Transport","dispetser",960,null,null,null,"juhataja"]
[null,"34404190222","Kaivo","Berk","mees","1944-04-19",69,"Ladu","tööline",760,null,null,null,"treial"]
[null,"33904050217","Olav","Berk","mees","1939-04-05",74,"Tootmine","tööline",870,null,null,null,"meister"]
[null,38302070214,"Priit","Burmeister","mees","1983-02-07",30,"Transport","autojuht",1150,null,null,null,"jurist"]
[null,47102200902,"Ene","Burmeister","naine","1971-02-20",42,"Finants","raamatupidaja",1070,null,null,null,"diiler"]
[null,"36802240722","Ahto","Danilov","mees","1968-02-24",45,"Transport","autojuht",1370,null,null,null,"valvur"]
[null,"48305030944","Laine","Eek","naine","1983-05-03",30,"Majandus","sekretär",770,null,null,null,"referent"]
[null,"48007150516","Erna","Eek","naine","1980-07-15",33,"Tootmine","tööline",830]
[null,47302150417,"Mare","Eesmaa","naine","1973-02-15",40,"Majandus","juhataja",2540]
[null,47311270496,"Vilma","Eesmaa","naine","1973-11-27",39,"Finants","raamatupidaja",1160]
[null,"34103030178","Einar","Ehala","mees","1941-03-03",72,"Tootmine","treial",1027]
[null,"47110240441","Ene","Elmik","naine","1971-10-24",42,"Müük","müügijuht",1270]
[null,"36110090988","Aadu","Elson","mees","1961-10-09",52,"Tootmine","tööline",1120]
[null,"34110060017","Marko","Erikson","mees","1941-10-06",72,"Tootmine","meister",1378]
[null,38205190379,"Aadu","Heinlo","mees","1982-05-19",31,"Tootmine","lukksepp",860]
[null,"46809210954","Aigi","Härm","naine","1968-09-21",45,"Ost","sekretär",1080]
[null,"44311130888","Sirje","Härm","naine","1943-11-13",69,"Ost","sekretär",860]
[null,"44111240925","Leida","Jaanus","naine","1941-11-24",71,"Tootmine","tööline",960]
[null,"37002030149","Kristjan","Jürimäe","mees","1970-02-03",43,"Tootmine","lukksepp",1270]
[null,"46809170171","Jana","Kaal","naine","1968-09-17",45,"Müük","sekretär",860]
[null,"34906210936","Jaan","Kaasik","mees","1949-06-21",64,"Transport","autojuht",1090]
[null,"38301080820","Meelis","Kalju","mees","1983-01-08",30,"Ladu","tööline",770]
[null,"34107110230","Hendrik","Kanter","mees","1941-07-11",72,"Tootmine","juhataja",3270]
[null,48801180808,"Erika","Kasemets","naine",{"$f":"DATE(MID(B39,2,2),MID(B39,4,2),MID(B39,6,2))","v":"1988-01-18"},{"$f":"INT((TODAY()-F39)/365.25)","v":25},"Müük","sekretär",980]
[null,46908050804,"Malle","Kivioja","naine","1969-08-05",44,"Finants","juhataja",3650]
[null,36009040214,"Andrus","Koort","mees","1960-09-04",53,"Tootmine","treial",1150]
[null,"44406270104","Sirje","Kreen","naine","1944-06-27",69,"Tootmine","tööline",850]
[null,"48210210529","Faina","Kukk","naine","1982-10-21",31,"Müük","sekretär",870]
[null,"33907250511","Riho","Kuusk","mees","1939-07-25",74,"Tootmine","tööline",1030]
[null,"37509120658","Boris","Küünemäe","mees","1975-09-12",38,"Transport","autojuht",970]
[null,36008130050,"Einar","Laanepõld","mees","1960-08-13",53,"Ladu","tööline",750]
[null,"37803090504","Jaan","Laubre","mees","1978-03-09",35,"Finants","raamatupidaja",1270]
[null,"37005020007","Erki","Lepiksoo","mees","1970-05-02",43,"Tootmine","treial",1180]
[null,"47010010868","Faina","Lepp","naine","1970-10-01",43,"Finants","jurist",2350]
[null,"45604030496","Malle","Ligi","naine","1956-04-03",57,"Finants","jurist",2270]
[null,"47005130963","Heli","Lind","naine","1970-05-13",43,"Tootmine","tööline",750]
[null,"38201060031","Raivo","Lokk","mees","1982-01-06",31,"Tootmine","tööline",970]
[null,"35105180673","Eino","Luige","mees","1951-05-18",62,"Tootmine","tööline",760]
[null,"34309100049","Madis","Maasalu","mees","1943-09-10",70,"Tootmine","tööline",1080]
[null,"35009030894","Margus","Maasalu","mees","1950-09-03",63,"Tootmine","tööline",1070]
[null,"35809050610","Aadu","Malva","mees","1958-09-05",55,"Transport","autojuht",1180]
[null,"48208230166","Tiina","Markus","naine","1982-08-23",31,"Ladu","tööline",750]
[null,"34408020335","Aare","Marmor","mees","1944-08-02",69,"Tootmine","meister",1420]
[null,"34506190557","Reijo","Meigas","mees","1945-06-19",68,"Ladu","tööline",960]
[null,"34112180084","Anton","Meister","mees","1941-12-18",71,"Ladu","juhataja",2270]
[null,"35408240148","Arnold","Merilaid","mees","1954-08-24",59,"Transport","autojuht",940]
[null,"36203030988","Kaivo","Mets","mees","1962-03-03",51,"Tootmine","meister",1380]
[null,"37303030624","Aarne","Mikson","mees","1973-03-03",40,"Ost","juhataja",2960]
[null,"48109130038","Kersti","Miller","naine","1981-09-13",32,"Tootmine","tööline",850]
[null,"37003260243","Reijo","Muld","mees","1970-03-26",43,"Tootmine","tööline",1190]
[null,"45903030319","Valve","Mäesalu","naine","1959-03-03",54,"Ost","sekretär",1120]
[null,"37906080465","Kristjan","Mägi","mees","1979-06-08",34,"Müük","diiler",1090]
[null,"36709040675","Tarmo","Müller","mees","1967-09-04",46,"Müük","müügijuht",2080]
[null,"35104120460","Reijo","Müürsepp","mees","1951-04-12",62,"Tootmine","lukksepp",1160]
[null,"36512210549","Paul","Naaber","mees","1965-12-21",47,"Transport","autojuht",1050]
[null,"38303010526","Jaan","Noormets","mees",{"$f":"DATE(MID(B71,2,2),MID(B71,4,2),MID(B71,6,2))","v":"1983-03-01"},{"$f":"INT((TODAY()-F71)/365.25)","v":30},"Müük","diiler",1160]
[null,"38008200347","Arnold","Norak","mees","1980-08-20",33,"Tootmine","tööline",1070]
[null,"36406070555","Aarne","Norak","mees","1964-06-07",49,"Tootmine","tööline",930]
[null,"37708220891","Ando","Nõmmik","mees","1977-08-22",36,"Transport","autojuht",1160]
[null,"35001130124","Aarne","Oks","mees","1950-01-13",63,"Transport","autojuht",1050]
[null,"45809140289","Kristiina","Oks","naine","1958-09-14",55,"Transport","dispetser",940]
[null,"38206070961","Reijo","Okspuu","mees","1982-06-07",31,"Müük","diiler",980]
[null,"48105090295","Annika","Paju","naine","1981-05-09",32,"Majandus","sekretär",760]
[null,"38005180669","Hanno","Pajusaar","mees","1980-05-18",33,"Tootmine","tööline",1140]
[null,"46709190988","Selma","Parre","naine","1967-09-19",46,"Ladu","tööline",1070]
[null,"37612170754","Eevald","Parts","mees","1976-12-17",36,"Tootmine","lukksepp",1290]
[null,"37308230939","Madis","Paulus","mees","1973-08-23",40,"Tootmine","tööline",1130]
[null,"36907260696","Hanno","Pedak","mees","1969-07-26",44,"Transport","autojuht",1070]
[null,"38211130833","Meelis","Petrov","mees","1982-11-13",30,"Tootmine","tööline",860]
[null,"47508150058","Irma","Piirsalu","naine","1975-08-15",38,"Tootmine","tööline",1050]
[null,"34204170615","Aadu","Pulk","mees","1942-04-17",71,"Transport","valvur",670]
[null,"45710100356","Airi","Põld","naine","1957-10-10",56,"Ladu","kompekteerija",1160]
[null,"45902200391","Evelin","Põld","naine","1959-02-20",54,"Majandus","sekretär",960]
[null,"46307080393","Malle","Põldmaa","naine","1963-07-08",50,"Tootmine","tööline",970]
[null,"47605040659","Hilja","Raid","naine","1976-05-04",37,"Müük","sekretär",960]
[null,"47111150090","Tiina","Rajamäe","naine","1971-11-15",41,"Transport","dispetser",1070]
[null,"44012150956","Aasa","Randla","naine","1940-12-15",72,"Majandus","koristaja",720]
[null,"38104220473","Aare","Raudsepp","mees","1981-04-22",32,"Müük","diiler",1050]
[null,"37111200348","Margus","Roosimägi","mees","1971-11-20",41,"Transport","autojuht",1360]
[null,"34810190405","Karl","Salu","mees","1948-10-19",65,"Ladu","dispetser",990]
[null,"34811280456","Argo","Salu","mees","1948-11-28",64,"Tootmine","tööline",1160]
[null,"37105220288","Kustav","Salu","mees","1971-05-22",42,"Tootmine","tööline",1160]
[null,"37006180544","Erno","Salumets","mees","1970-06-18",43,"Müük","juhataja",3650]
[null,"44607080463","Evi","Sarapik","naine","1946-07-08",67,"Finants","raamatupidaja",1270]
[null,"44601210234","Tiina","Toomsalu","naine","1946-01-21",67,"Majandus","koristaja",650]
[null,"45209010485","Juulia","Tubin","naine","1952-09-01",61,"Müük","sekretär",860]
[null,"35901050084","Ahti","Tubin","mees","1959-01-05",54,"Tootmine","treial",1350]
[null,"46404170054","Katy","Veesimaa","naine","1964-04-17",{"$f":"INT((TODAY()-F103)/365.25)","v":49},"Finants","referent",970]
[null,"35312110930","Kaspar","Veesimaa","mees","1953-12-11",{"$f":"INT((TODAY()-F104)/365.25)","v":59},"Tootmine","tööline",870]
[null,"36504060863","Arvi","Väljas","mees","1965-04-06",{"$f":"INT((TODAY()-F105)/365.25)","v":48},"Tootmine","tööline",870]

{"sheet":"Filter_AT","index":5,"n_rows":92,"n_cols":10,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null," - kirjed, kus Sugu on mees, Vanus suurem kui 50 ja Palk  väiksem kui 10000"]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
[null,"34404190222","Kaivo","Berk","mees","1944-04-19",63,"Ladu","tööline",7600]
[null,"33904050217","Olav","Berk","mees","1939-04-05",68,"Tootmine","tööline",8700]
[null,"35105180673","Eino","Luige","mees","1951-05-18",56,"Tootmine","tööline",7600]
[null,"34506190557","Reijo","Meigas","mees","1945-06-19",62,"Ladu","tööline",9600]
[null,"35408240148","Arnold","Merilaid","mees","1954-08-24",53,"Transport","autojuht",9400]
[null,"34204170615","Aadu","Pulk","mees","1942-04-17",65,"Transport","valvur",6700]
[null,"34810190405","Karl","Salu","mees","1948-10-19",58,"Ladu","dispetser",9900]
[null,"35312110930","Kaspar","Veesimaa","mees","1953-12-11",53,"Tootmine","tööline",8700]
[]
[null,"kirjed, kus Osakond on ladu või Ost ja Sugu on naine"]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
[null,"46605150941","Maarja","Ambros","naine","1966-05-15",41,"Ost","sekretäär",8500]
[null,"46809210954","Aigi","Härm","naine","1968-09-21",39,"Ost","sekretär",10800]
[null,"44311130888","Sirje","Härm","naine","1943-11-13",63,"Ost","sekretär",8600]
[null,"48208230166","Tiina","Markus","naine","1982-08-23",25,"Ladu","tööline",7500]
[null,"45903030319","Valve","Mäesalu","naine","1959-03-03",48,"Ost","sekretär",11200]
[null,"46709190988","Selma","Parre","naine","1967-09-19",40,"Ladu","tööline",10700]
[null,"45710100356","Airi","Põld","naine","1957-10-10",50,"Ladu","kompekteerija",11600]
[]
[null,"Amet","kirjed, kus Amet on juhataja või sekretär"]
[null,"sekretär"]
[null,"juhataja"]
[]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
[null,47302150417,"Mare","Eesmaa","naine","1973-02-15",34,"Majandus","juhataja",25400]
[null,"34107110230","Hendrik","Kanter","mees","1941-07-11",66,"Tootmine","juhataja",32700]
[null,46908050804,"Malle","Kivioja","naine","1969-08-05",38,"Finants","juhataja",36500]
[null,"34112180084","Anton","Meister","mees","1941-12-18",65,"Ladu","juhataja",22700]
[null,"37303030624","Aarne","Mikson","mees","1973-03-03",34,"Ost","juhataja",29600]
[null,"37006180544","Erno","Salumets","mees","1970-06-18",37,"Müük","juhataja",36500]
[null,48704250911,"Helen","Aigro","naine","1987-04-25",20,"Müük","sekretär",8500]
[null,"48305030944","Laine","Eek","naine","1983-05-03",24,"Majandus","sekretär",7700]
[null,"46809210954","Aigi","Härm","naine","1968-09-21",39,"Ost","sekretär",10800]
[null,"44311130888","Sirje","Härm","naine","1943-11-13",63,"Ost","sekretär",8600]
[null,"46809170171","Jana","Kaal","naine","1968-09-17",39,"Müük","sekretär",8600]
[null,48801180808,"Erika","Kasemets","naine","1988-01-18",19,"Müük","sekretär",9800]
[null,"48210210529","Faina","Kukk","naine","1982-10-21",24,"Müük","sekretär",8700]
[null,"45903030319","Valve","Mäesalu","naine","1959-03-03",48,"Ost","sekretär",11200]
[null,"48105090295","Annika","Paju","naine","1981-05-09",26,"Majandus","sekretär",7600]
[null,"45902200391","Evelin","Põld","naine","1959-02-20",48,"Majandus","sekretär",9600]
[null,"47605040659","Hilja","Raid","naine","1976-05-04",31,"Müük","sekretär",9600]
[null,"45209010485","Juulia","Tubin","naine","1952-09-01",55,"Müük","sekretär",8600]
[]
[]
[null,"Amet","Osakond"," kirjed, kus Amet on juhataja või sekretär ja "]
[null,"sekretär","Ost","    Osakond on Müük  või Ost"]
[null,"sekretär","Müük"]
[null,"juhataja","Ost"]
[null,"juhataja","Müük"]
[]
[null,"Isikukood","Eesnimi","Perenimi","Sugu","Sünniaeg","Vanus","Osakond","Amet","Palk"]
[null,48704250911,"Helen","Aigro","naine","1987-04-25",20,"Müük","sekretär",8500]
[null,"46809210954","Aigi","Härm","naine","1968-09-21",39,"Ost","sekretär",10800]
[null,"44311130888","Sirje","Härm","naine","1943-11-13",63,"Ost","sekretär",8600]
[null,"46809170171","Jana","Kaal","naine","1968-09-17",39,"Müük","sekretär",8600]
[null,48801180808,"Erika","Kasemets","naine","1988-01-18",19,"Müük","sekretär",9800]
[null,"48210210529","Faina","Kukk","naine","1982-10-21",24,"Müük","sekretär",8700]
[null,"37303030624","Aarne","Mikson","mees","1973-03-03",34,"Ost","juhataja",29600]
[null,"45903030319","Valve","Mäesalu","naine","1959-03-03",48,"Ost","sekretär",11200]
[null,"47605040659","Hilja","Raid","naine","1976-05-04",31,"Müük","sekretär",9600]
[null,"37006180544","Erno","Salumets","mees","1970-06-18",37,"Müük","juhataja",36500]
[null,"45209010485","Juulia","Tubin","naine","1952-09-01",55,"Müük","sekretär",8600]
[]
[]
[null,"väljad Eesnimi, Perenimi, Amet, Vanus ja Palk kirjetest, kus Amet on müügijuht või jurist"]
[null,"Amet"]
[null,"müügijuht"]
[null,"jurist"]
[]
[null,"Eesnimi","Perenimi","Amet","Vanus","Palk"]
[null,"Erika","Bachmann","müügijuht",36,13500]
[null,"Ene","Elmik","müügijuht",35,12700]
[null,"Faina","Lepp","jurist",37,23500]
[null,"Malle","Ligi","jurist",51,22700]
[null,"Tarmo","Müller","müügijuht",40,20800]
[]
[]
[null,"väljad Perenimi, Osakond, Amet, Vanus ja Palk kirjetest, kus Vanus <=50 ja Palk >=15000"]
[null,"Vanus","Palk"]
[null,"<=50",">=15000"]
[]
[null,"Perenimi","Osakond","Amet","Vanus","Palk"]
[null,"Eesmaa","Majandus","juhataja",34,25400]
[null,"Kivioja","Finants","juhataja",38,36500]
[null,"Lepp","Finants","jurist",37,23500]
[null,"Mikson","Ost","juhataja",34,29600]
[null,"Müller","Müük","müügijuht",40,20800]
[null,"Salumets","Müük","juhataja",37,36500]

{"sheet":"Rist_T1","index":6,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sum of Palk"]
[null,"Osakond","Total"]
[null,"Finants",152840]
[null,"Ladu",105100]
[null,"Majandus",70500]
[null,"Müük",180100]
[null,"Ost",68700]
[null,"Tootmine",431950]
[null,"Transport",160300]
[null,"Grand Total",1169490]
[]
[]
[null,"Average of Palk","Sugu"]
[null,"Amet","mees","naine","Grand Total"]
[null,"autojuht",11263.636363636364,null,11263.636363636364]
[null,"diiler",10700,null,10700]
[null,"dispetser",9900,9900,9900]
[null,"juhataja",30375,30950,30566.666666666668]
[null,"jurist",null,23100,23100]
[null,"kompekteerija",10300,11600,10950]
[null,"koristaja",null,6733.333333333333,6733.333333333333]
[null,"lukksepp",11460,null,11460]
[null,"meister",13926.666666666666,null,13926.666666666666]
[null,"müügijuht",20800,13100,15666.666666666666]
[null,"raamatupidaja",12700,11935,12088]
[null,"referent",null,9700,9700]
[null,"sekretär",null,9108.3333333333339,9108.3333333333339]
[null,"sekretäär",null,8500,8500]
[null,"treial",11767.5,null,11767.5]
[null,"tööline",9691.3043478260861,8977.7777777777774,9490.625]
[null,"valvur",6700,null,6700]
[null,"Grand Total",12163.559322033898,11296,11813.030303030304]
[]
[]
[null,"Osakond","(All)"]
[]
[null,"Average of Palk","Sugu"]
[null,"Vanus","mees","naine","Grand Total"]
[null,"15-24",9320,8675,9033.3333333333339]
[null,"25-34",12261.538461538461,11125,11828.571428571429]
[null,"35-44",14100,13050,13555.555555555555]
[null,"45-54",10877.777777777777,12873.333333333334,11676]
[null,"55-64",10441.666666666666,8980,10011.764705882353]
[null,"65-74",15021.428571428571,7766.666666666667,12845]
[null,"Grand Total",12163.559322033898,11296,11813.030303030304]

{"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":2007},null,null,"P-abi"]
[]
[null,"sortimine","autofilter","arend. filter","vahe","risttabel","SumIF"]
[]
[null,null,null,null,null,null,"Kokku",null,{"$f":"SUM(P_kogus)","v":17099},null,{"$f":"SUM(P_maks)","v":11201965}]
[]
[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","2007-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":675},{"$f":"P_hind * P_kogus","v":18900},{"$f":"MONTH(P_kuupäev)","v":1}]
[null,"P002","2007-01-03","Haab","Pärnu","kask",1,"Karu",75,700,52500,1]
[null,"P002","2007-01-03","Haab","Pärnu","vaher",1,"Karu",10,950,9500,1]
[null,"P003","2007-01-03","Seen","Võru","lepp",2,"Karu",13,585,7605,1]
[null,"P004","2007-01-04","Karu","Lääne","küte",1,"Siil",12,470,5640,1]
[null,"P004","2007-01-04","Karu","Lääne","vaher",1,"Siil",39,950,37050,1]
[null,"P005","2007-01-06","Seen","Võru","küte",1,"Põder",44,470,20680,1]
[null,"P006","2007-01-06","Juur","Pärnu","mänd",2,"Rebane",37,675,24975,1]
[null,"P007","2007-01-07","Lind","Valga","kuusk",2,"Jänes",11,720,7920,1]
[null,"P008","2007-01-07","Vaher","Rapla","saar",3,"Hunt",23,680,15640,1]
[null,"P009","2007-01-08","Mänd","Harju","küte",1,"Jänes",45,470,21150,1]
[null,"P010","2007-01-09","Karu","Lääne","küte",2,"Hunt",6,423,2538,1]
[null,"P010","2007-01-09","Karu","Lääne","mänd",1,"Hunt",55,750,41250,1]
[null,"P010","2007-01-09","Karu","Lääne","mänd",2,"Hunt",39,675,26325,1]
[null,"P011","2007-01-11","Lepp","Viljandi","kuusk",1,"Karu",24,800,19200,1]
[null,"P011","2007-01-11","Lepp","Viljandi","vaher",3,"Jänes",16,760,12160,1]
[null,"P012","2007-01-12","Lepik","Paide","küte",1,"Jänes",71,470,33370,1]
[null,"P013","2007-01-13","Vares","Rapla","küte",2,"Jänes",25,423,10575,1]
[null,"P013","2007-01-13","Vares","Rapla","küte",1,"Jänes",22,470,10340,1]
[null,"P013","2007-01-13","Vares","Rapla","tamm",1,"Jänes",28,1100,30800,1]
[null,"P014","2007-01-14","Kask","Pärnu","mänd",1,"Siil",40,750,30000,1]
[null,"P014","2007-01-14","Kask","Pärnu","saar",1,"Siil",17,850,14450,1]
[null,"P015","2007-01-16","Varblane","Harju","haab",3,"Hunt",17,400,6800,1]
[null,"P015","2007-01-16","Varblane","Harju","saar",1,"Hunt",40,850,34000,1]
[null,"P015","2007-01-16","Varblane","Harju","vaher",1,"Hunt",27,950,25650,1]
[null,"P016","2007-01-17","Ilves","Lääne","kask",1,"Hunt",13,700,9100,1]
[null,"P016","2007-01-17","Ilves","Lääne","tamm",2,"Hunt",31,990,30690,1]
[null,"P017","2007-01-18","Paju","Võru","kask",1,"Põder",50,700,35000,1]
[null,"P018","2007-01-19","Pihel","Rapla","kuusk",3,"Siil",52,640,33280,1]
[null,"P019","2007-01-20","Seen","Võru","saar",1,"Hunt",69,850,58650,1]
[null,"P020","2007-01-23","Kaun","Pärnu","küte",1,"Põder",48,470,22560,1]
[null,"P021","2007-01-24","Seen","Võru","küte",2,"Jänes",45,423,19035,1]
[null,"P021","2007-01-24","Seen","Võru","mänd",1,"Jänes",73,750,54750,1]
[null,"P022","2007-01-25","Kuusik","Viljandi","kask",1,"Karu",23,700,16100,1]
[null,"P022","2007-01-25","Kuusik","Viljandi","kask",1,"Karu",16,700,11200,1]
[null,"P022","2007-01-25","Kuusik","Viljandi","küte",2,"Karu",20,423,8460,1]
[null,"P023","2007-01-25","Kuusik","Viljandi","kuusk",1,"Jänes",24,800,19200,1]
[null,"P024","2007-01-27","Lepp","Viljandi","tamm",2,"Karu",51,990,50490,1]
[null,"P025","2007-01-27","Lepp","Viljandi","kuusk",1,"Siil",15,800,12000,1]
[null,"P026","2007-01-28","Känd","Harju","tamm",2,"Siil",11,990,10890,1]
[null,"P027","2007-01-30","Tuvi","Harju","küte",1,"Siil",27,470,12690,1]
[null,"P028","2007-01-31","Kask","Pärnu","haab",2,"Ilves",46,450,20700,1]
[null,"P028","2007-01-31","Kask","Pärnu","kuusk",1,"Ilves",40,800,32000,1]
[null,"P029","2007-02-01","Lind","Valga","kask",3,"Karu",75,560,42000,2]
[null,"P030","2007-02-01","Lind","Valga","haab",2,"Põder",44,450,19800,2]
[null,"P031","2007-02-02","Karu","Lääne","mänd",1,"Jänes",53,750,39750,2]
[null,"P032","2007-02-03","Ilves","Lääne","vaher",2,"Karu",26,855,22230,2]
[null,"P033","2007-02-04","Vaher","Rapla","kuusk",3,"Karu",66,640,42240,2]
[null,"P034","2007-02-05","Lepik","Paide","mänd",1,"Siil",30,750,22500,2]
[null,"P034","2007-02-05","Lepik","Paide","tamm",1,"Siil",15,1100,16500,2]
[null,"P035","2007-02-12","Kask","Pärnu","lepp",1,"Karu",53,650,34450,2]
[null,"P036","2007-02-13","Luik","Viljandi","kuusk",3,"Karu",72,640,46080,2]
[null,"P036","2007-02-13","Luik","Viljandi","lepp",1,"Ilves",53,650,34450,2]
[null,"P037","2007-02-17","Kuusik","Viljandi","haab",2,"Jänes",32,450,14400,2]
[null,"P038","2007-02-18","Kask","Pärnu","mänd",1,"Ilves",36,750,27000,2]
[null,"P038","2007-02-18","Kask","Pärnu","tamm",1,"Ilves",14,1100,15400,2]
[null,"P038","2007-02-18","Kask","Pärnu","vaher",3,"Ilves",78,760,59280,2]
[null,"P039","2007-02-18","Lepik","Paide","kask",3,"Hunt",62,560,34720,2]
[null,"P040","2007-02-19","Saar","Valga","kuusk",1,"Jänes",22,800,17600,2]
[null,"P041","2007-02-20","Mänd","Harju","mänd",1,"Siil",74,750,55500,2]
[null,"P042","2007-02-21","Mänd","Harju","haab",3,"Põder",26,400,10400,2]
[null,"P042","2007-02-21","Mänd","Harju","saar",1,"Põder",49,850,41650,2]
[null,"P043","2007-02-22","Seen","Võru","saar",2,"Hunt",24,765,18360,2]
[null,"P044","2007-02-25","Juur","Pärnu","kask",1,"Hunt",37,700,25900,2]
[null,"P044","2007-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":600},{"$f":"P_hind * P_kogus","v":19800},{"$f":"MONTH(P_kuupäev)","v":2}]
[null,"P045","2007-02-26","Vaher","Rapla","kask",1,"Hunt",35,700,24500,2]
[null,"P046","2007-02-27","Varblane","Harju","kask",1,"Rebane",34,700,23800,2]
[null,"P047","2007-02-27","Kuusik","Viljandi","küte",2,"Hunt",28,423,11844,2]
[null,"P048","2007-02-28","Seen","Võru","lepp",3,"Siil",23,520,11960,2]
[null,"P049","2007-03-01","Varblane","Harju","kask",1,"Siil",73,700,51100,3]
[null,"P050","2007-03-01","Kaun","Pärnu","lepp",1,"Ilves",65,650,42250,3]
[null,"P051","2007-03-02","Lepik","Paide","saar",3,"Karu",63,680,42840,3]
[null,"P052","2007-03-02","Lepik","Paide","lepp",3,"Ilves",65,520,33800,3]
[null,"P053","2007-03-02","Lepp","Viljandi","haab",1,"Karu",27,500,13500,3]
[null,"P053","2007-03-02","Lepp","Viljandi","vaher",1,"Hunt",11,950,10450,3]
[null,"P054","2007-03-05","Lepp","Viljandi","küte",2,"Karu",177,423,74871,3]
[null,"P054","2007-03-05","Lepp","Viljandi","lepp",2,"Karu",37,585,21645,3]
[null,"P055","2007-03-06","Saar","Valga","mänd",2,"Jänes",49,675,33075,3]
[null,"P056","2007-03-08","Saar","Valga","mänd",3,"Rebane",28,600,16800,3]
[null,"P057","2007-03-08","Ilves","Lääne","haab",1,"Siil",13,500,6500,3]
[null,"P057","2007-03-08","Ilves","Lääne","mänd",2,"Siil",22,675,14850,3]
[null,"P058","2007-03-11","Vaher","Rapla","haab",1,"Hunt",59,500,29500,3]
[null,"P058","2007-03-11","Vaher","Rapla","kask",1,"Hunt",25,700,17500,3]
[null,"P058","2007-03-11","Vaher","Rapla","kask",1,"Hunt",11,700,7700,3]
[null,"P059","2007-03-12","Varblane","Harju","haab",2,"Põder",75,450,33750,3]
[null,"P060","2007-03-13","Varblane","Harju","lepp",2,"Karu",46,585,26910,3]
[null,"P061","2007-03-15","Lepp","Viljandi","kuusk",3,"Siil",23,640,14720,3]
[null,"P062","2007-03-18","Varblane","Harju","haab",2,"Jänes",49,450,22050,3]
[null,"P062","2007-03-18","Varblane","Harju","haab",1,"Jänes",36,500,18000,3]
[null,"P062","2007-03-18","Varblane","Harju","vaher",1,"Jänes",27,950,25650,3]
[null,"P063","2007-03-19","Seen","Võru","kask",1,"Siil",73,700,51100,3]
[null,"P063","2007-03-19","Seen","Võru","mänd",2,"Siil",52,675,35100,3]
[null,"P064","2007-03-20","Juur","Pärnu","tamm",1,"Rebane",35,1100,38500,3]
[null,"P064","2007-03-20","Juur","Pärnu","vaher",2,"Rebane",31,855,26505,3]
[null,"P065","2007-03-21","Lind","Valga","saar",3,"Karu",18,680,12240,3]
[null,"P066","2007-03-22","Tuvi","Harju","saar",1,"Karu",67,850,56950,3]
[null,"P066","2007-03-22","Tuvi","Harju","saar",1,"Karu",52,850,44200,3]
[null,"P067","2007-03-23","Lind","Valga","kuusk",1,"Karu",11,800,8800,3]
[null,"P068","2007-03-23","Kask","Pärnu","kask",1,"Ilves",32,700,22400,3]
[null,"P069","2007-03-24","Kass","Paide","tamm",2,"Jänes",23,990,22770,3]
[null,"P070","2007-03-25","Känd","Harju","kuusk",1,"Ilves",72,800,57600,3]
[null,"P070","2007-03-25","Känd","Harju","kuusk",2,"Ilves",58,720,41760,3]
[null,"P071","2007-03-26","Vares","Rapla","lepp",2,"Siil",52,585,30420,3]
[null,"P072","2007-03-26","Lepp","Viljandi","saar",1,"Ilves",8,850,6800,3]
[null,"P073","2007-03-31","Kaun","Pärnu","haab",1,"Hunt",27,500,13500,3]
[null,"P073","2007-03-31","Kaun","Pärnu","kuusk",1,"Hunt",21,800,16800,3]
[null,"P074","2007-04-01","Saar","Valga","saar",1,"Põder",13,850,11050,4]
[null,"P075","2007-04-02","Lepp","Viljandi","kask",2,"Ilves",22,630,13860,4]
[null,"P075","2007-04-02","Lepp","Viljandi","saar",1,"Ilves",35,850,29750,4]
[null,"P076","2007-04-02","Kask","Pärnu","kuusk",2,"Siil",14,720,10080,4]
[null,"P077","2007-04-03","Kaasik","Pärnu","kask",1,"Põder",39,700,27300,4]
[null,"P078","2007-04-04","Lind","Valga","haab",1,"Ilves",54,500,27000,4]
[null,"P078","2007-04-04","Lind","Valga","mänd",1,"Hunt",8,750,6000,4]
[null,"P079","2007-04-05","Juur","Pärnu","haab",1,"Ilves",15,500,7500,4]
[null,"P080","2007-04-06","Haab","Pärnu","mänd",3,"Ilves",34,600,20400,4]
[null,"P081","2007-04-08","Kaasik","Pärnu","tamm",2,"Hunt",50,990,49500,4]
[null,"P082","2007-04-09","Juur","Pärnu","haab",1,"Siil",35,500,17500,4]
[null,"P083","2007-04-10","Varblane","Harju","haab",1,"Rebane",30,500,15000,4]
[null,"P083","2007-04-10","Varblane","Harju","saar",1,"Rebane",36,850,30600,4]
[null,"P084","2007-04-11","Vares","Rapla","tamm",1,"Hunt",20,1100,22000,4]
[null,"P085","2007-04-14","Lepik","Paide","haab",2,"Karu",75,450,33750,4]
[null,"P085","2007-04-14","Lepik","Paide","vaher",1,"Karu",13,950,12350,4]
[null,"P086","2007-04-14","Seen","Võru","küte",2,"Ilves",68,423,28764,4]
[null,"P087","2007-04-15","Varblane","Harju","mänd",1,"Hunt",69,750,51750,4]
[null,"P088","2007-04-16","Känd","Harju","lepp",1,"Põder",40,650,26000,4]
[null,"P088","2007-04-16","Känd","Harju","mänd",2,"Põder",61,675,41175,4]
[null,"P089","2007-04-16","Mänd","Harju","lepp",2,"Põder",25,585,14625,4]
[null,"P090","2007-04-17","Kuusk","Lääne","saar",3,"Rebane",41,680,27880,4]
[null,"P091","2007-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":500},{"$f":"P_hind * P_kogus","v":36000},{"$f":"MONTH(P_kuupäev)","v":4}]
[null,"P092","2007-04-19","Kuusk","Lääne","kask",1,"Jänes",51,700,35700,4]
[null,"P092","2007-04-19","Kuusk","Lääne","lepp",2,"Jänes",52,585,30420,4]
[null,"P093","2007-04-20","Kaun","Pärnu","mänd",3,"Jänes",71,600,42600,4]
[null,"P094","2007-04-20","Tuvi","Harju","lepp",1,"Hunt",30,650,19500,4]
[null,"P094","2007-04-20","Tuvi","Harju","mänd",2,"Hunt",53,675,35775,4]
[null,"P095","2007-04-21","Haab","Pärnu","haab",1,"Karu",41,500,20500,4]
[null,"P095","2007-04-21","Haab","Pärnu","kuusk",1,"Karu",62,800,49600,4]
[null,"P095","2007-04-21","Haab","Pärnu","mänd",2,"Karu",21,675,14175,4]
[null,"P096","2007-04-23","Lind","Valga","kuusk",3,"Ilves",45,640,28800,4]
[null,"P096","2007-04-23","Lind","Valga","tamm",1,"Jänes",37,1100,40700,4]
[null,"P097","2007-04-24","Känd","Harju","kuusk",1,"Ilves",29,800,23200,4]
[null,"P097","2007-04-24","Känd","Harju","küte",3,"Ilves",63,376,23688,4]
[null,"P097","2007-04-24","Känd","Harju","tamm",1,"Ilves",43,1100,47300,4]
[null,"P098","2007-04-25","Karu","Lääne","lepp",2,"Siil",65,585,38025,4]
[null,"P099","2007-04-25","Kuusik","Viljandi","kask",1,"Hunt",31,700,21700,4]
[null,"P099","2007-04-25","Kuusik","Viljandi","lepp",1,"Hunt",36,650,23400,4]
[null,"P100","2007-04-26","Kaasik","Pärnu","mänd",2,"Ilves",70,675,47250,4]
[null,"P101","2007-04-27","Saar","Valga","kask",1,"Hunt",15,700,10500,4]
[null,"P101","2007-04-27","Saar","Valga","vaher",3,"Hunt",24,760,18240,4]
[null,"P102","2007-04-28","Varblane","Harju","saar",2,"Põder",48,765,36720,4]
[null,"P103","2007-04-29","Lind","Valga","mänd",1,"Hunt",37,750,27750,4]
[null,"P103","2007-04-29","Lind","Valga","mänd",2,"Hunt",33,675,22275,4]
[null,"P104","2007-04-30","Varblane","Harju","kuusk",2,"Ilves",54,720,38880,4]
[null,"P104","2007-04-30","Varblane","Harju","mänd",1,"Ilves",25,750,18750,4]
[null,"P105","2007-05-02","Seen","Võru","kuusk",1,"Ilves",36,800,28800,5]
[null,"P106","2007-05-03","Lepp","Viljandi","haab",3,"Ilves",45,400,18000,5]
[null,"P106","2007-05-03","Lepp","Viljandi","küte",2,"Ilves",31,423,13113,5]
[null,"P107","2007-05-03","Lepp","Viljandi","mänd",3,"Rebane",17,600,10200,5]
[null,"P108","2007-05-04","Saar","Valga","saar",2,"Ilves",37,765,28305,5]
[null,"P109","2007-05-04","Pihel","Rapla","kuusk",1,"Karu",12,800,9600,5]
[null,"P110","2007-05-06","Kuusk","Lääne","küte",1,"Rebane",12,470,5640,5]
[null,"P111","2007-05-08","Vares","Rapla","tamm",3,"Jänes",40,880,35200,5]
[null,"P112","2007-05-09","Haab","Pärnu","küte",1,"Karu",18,470,8460,5]
[null,"P112","2007-05-09","Haab","Pärnu","saar",2,"Karu",10,765,7650,5]
[null,"P113","2007-05-10","Lind","Valga","küte",1,"Jänes",49,470,23030,5]
[null,"P113","2007-05-10","Lind","Valga","mänd",1,"Jänes",54,750,40500,5]
[null,"P114","2007-05-10","Kaun","Pärnu","haab",2,"Põder",25,450,11250,5]
[null,"P114","2007-05-10","Kaun","Pärnu","saar",3,"Põder",19,680,12920,5]
[null,"P115","2007-05-11","Juur","Pärnu","küte",1,"Ilves",71,470,33370,5]
[null,"P116","2007-05-13","Kask","Pärnu","lepp",1,"Hunt",41,650,26650,5]
[null,"P116","2007-05-13","Kask","Pärnu","lepp",2,"Hunt",14,585,8190,5]
[null,"P117","2007-05-14","Kaun","Pärnu","kuusk",3,"Jänes",55,640,35200,5]
[null,"P118","2007-05-15","Lind","Valga","küte",1,"Rebane",44,470,20680,5]
[null,"P119","2007-05-15","Lepp","Viljandi","kask",2,"Karu",19,630,11970,5]
[null,"P120","2007-05-15","Luik","Viljandi","lepp",3,"Siil",33,520,17160,5]
[null,"P121","2007-05-16","Pihel","Rapla","lepp",1,"Karu",17,650,11050,5]
[null,"P122","2007-05-17","Lepik","Paide","küte",3,"Ilves",13,376,4888,5]
[null,"P122","2007-05-17","Lepik","Paide","mänd",2,"Ilves",76,675,51300,5]
[null,"P123","2007-05-17","Kask","Pärnu","mänd",1,"Hunt",47,750,35250,5]
[null,"P124","2007-05-18","Luik","Viljandi","tamm",1,"Põder",32,1100,35200,5]
[null,"P125","2007-05-19","Lepp","Viljandi","haab",3,"Põder",65,400,26000,5]
[null,"P126","2007-05-21","Kask","Pärnu","tamm",1,"Ilves",30,1100,33000,5]
[null,"P127","2007-05-22","Kaasik","Pärnu","kuusk",2,"Ilves",74,720,53280,5]
[null,"P128","2007-05-23","Saar","Valga","küte",3,"Karu",30,376,11280,5]
[null,"P129","2007-05-26","Tuvi","Harju","lepp",1,"Siil",24,650,15600,5]
[null,"P130","2007-05-27","Juur","Pärnu","haab",1,"Hunt",20,500,10000,5]
[null,"P130","2007-05-27","Juur","Pärnu","küte",2,"Hunt",11,423,4653,5]
[null,"P131","2007-05-29","Känd","Harju","mänd",3,"Hunt",79,600,47400,5]
[null,"P132","2007-05-30","Seen","Võru","küte",2,"Rebane",12,423,5076,5]
[null,"P132","2007-05-30","Seen","Võru","mänd",3,"Rebane",28,600,16800,5]
[null,"P133","2007-06-02","Saar","Valga","küte",1,"Hunt",51,470,23970,6]
[null,"P134","2007-06-04","Lepp","Viljandi","kuusk",1,"Siil",31,800,24800,6]
[null,"P135","2007-06-05","Lind","Valga","kask",2,"Rebane",23,630,14490,6]
[null,"P136","2007-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":470},{"$f":"P_hind * P_kogus","v":26320},{"$f":"MONTH(P_kuupäev)","v":6}]
[null,"P137","2007-06-09","Seen","Võru","haab",1,"Siil",52,500,26000,6]
[null,"P138","2007-06-10","Lepp","Viljandi","kuusk",1,"Hunt",54,800,43200,6]
[null,"P138","2007-06-10","Lepp","Viljandi","vaher",3,"Hunt",25,760,19000,6]
[null,"P139","2007-06-11","Karu","Lääne","kask",1,"Põder",72,700,50400,6]
[null,"P139","2007-06-11","Karu","Lääne","lepp",2,"Põder",9,585,5265,6]
[null,"P140","2007-06-12","Lind","Valga","lepp",1,"Karu",72,650,46800,6]
[null,"P140","2007-06-12","Lind","Valga","vaher",3,"Karu",12,760,9120,6]
[null,"P141","2007-06-13","Kuusk","Lääne","lepp",1,"Karu",46,650,29900,6]
[null,"P142","2007-06-14","Seen","Võru","mänd",1,"Rebane",24,750,18000,6]
[null,"P143","2007-06-15","Ilves","Lääne","lepp",2,"Ilves",12,585,7020,6]
[null,"P143","2007-06-15","Ilves","Lääne","mänd",2,"Ilves",72,675,48600,6]
[null,"P144","2007-06-17","Lind","Valga","kuusk",3,"Rebane",26,640,16640,6]
[null,"P144","2007-06-17","Lind","Valga","mänd",1,"Rebane",67,750,50250,6]
[null,"P145","2007-06-19","Mänd","Harju","mänd",3,"Karu",47,600,28200,6]
[null,"P146","2007-06-20","Seen","Võru","lepp",1,"Siil",24,650,15600,6]
[null,"P147","2007-06-21","Kaun","Pärnu","kask",2,"Karu",33,630,20790,6]
[null,"P148","2007-06-22","Kaun","Pärnu","tamm",2,"Rebane",65,990,64350,6]
[null,"P148","2007-06-22","Kaun","Pärnu","tamm",1,"Rebane",10,1100,11000,6]
[null,"P149","2007-06-24","Juur","Pärnu","lepp",1,"Põder",32,650,20800,6]
[null,"P150","2007-06-28","Pihel","Rapla","kask",2,"Jänes",36,630,22680,6]
[null,"P151","2007-07-01","Känd","Harju","saar",1,"Jänes",49,850,41650,7]
[null,"P152","2007-07-01","Ilves","Lääne","mänd",1,"Ilves",15,750,11250,7]
[null,"P153","2007-07-05","Kaun","Pärnu","kuusk",3,"Põder",56,640,35840,7]
[null,"P154","2007-07-06","Luik","Viljandi","tamm",3,"Rebane",11,880,9680,7]
[null,"P155","2007-07-07","Seen","Võru","lepp",1,"Ilves",63,650,40950,7]
[null,"P155","2007-07-07","Seen","Võru","mänd",2,"Ilves",23,675,15525,7]
[null,"P156","2007-07-08","Saar","Valga","haab",1,"Rebane",24,500,12000,7]
[null,"P157","2007-07-09","Kuusik","Viljandi","haab",2,"Hunt",11,450,4950,7]
[null,"P157","2007-07-09","Kuusik","Viljandi","kuusk",1,"Hunt",25,800,20000,7]
[null,"P158","2007-07-10","Lepik","Paide","mänd",1,"Siil",23,750,17250,7]
[null,"P159","2007-07-11","Vaher","Rapla","küte",1,"Põder",61,470,28670,7]
[null,"P160","2007-07-12","Lind","Valga","küte",2,"Põder",39,423,16497,7]
[null,"P160","2007-07-12","Lind","Valga","saar",3,"Põder",23,680,15640,7]
[null,"P161","2007-07-13","Kuusk","Lääne","mänd",1,"Jänes",11,750,8250,7]
[null,"P162","2007-07-14","Lind","Valga","mänd",1,"Karu",52,750,39000,7]
[null,"P163","2007-07-18","Tuvi","Harju","mänd",3,"Rebane",36,600,21600,7]
[null,"P163","2007-07-18","Tuvi","Harju","saar",2,"Rebane",12,765,9180,7]
[null,"P164","2007-07-18","Paju","Võru","küte",1,"Karu",34,470,15980,7]
[null,"P165","2007-07-20","Kaun","Pärnu","kuusk",3,"Karu",26,640,16640,7]
[null,"P166","2007-07-23","Tuvi","Harju","küte",1,"Põder",17,470,7990,7]
[null,"P166","2007-07-23","Tuvi","Harju","mänd",1,"Põder",74,750,55500,7]
[null,"P167","2007-07-24","Kaasik","Pärnu","lepp",2,"Põder",65,585,38025,7]
[null,"P168","2007-07-25","Lind","Valga","saar",1,"Põder",45,850,38250,7]
[null,"P169","2007-07-27","Pihel","Rapla","mänd",1,"Jänes",19,750,14250,7]
[null,"P170","2007-07-28","Karu","Lääne","kask",1,"Ilves",70,700,49000,7]
[null,"P170","2007-07-28","Karu","Lääne","kask",2,"Ilves",44,630,27720,7]
[null,"P170","2007-07-28","Karu","Lääne","tamm",1,"Ilves",19,1100,20900,7]
[null,"P171","2007-07-29","Seen","Võru","haab",2,"Põder",37,450,16650,7]
[null,"P171","2007-07-29","Seen","Võru","kuusk",3,"Põder",31,640,19840,7]
[null,"P172","2007-07-30","Varblane","Harju","mänd",2,"Hunt",73,675,49275,7]
[null,"P173","2007-07-31","Kaun","Pärnu","lepp",2,"Jänes",23,585,13455,7]
[null,"P174","2007-08-01","Luik","Viljandi","kuusk",1,"Hunt",12,800,9600,8]
[null,"P175","2007-08-02","Saar","Valga","lepp",1,"Karu",21,650,13650,8]
[null,"P175","2007-08-02","Saar","Valga","mänd",2,"Karu",14,675,9450,8]
[null,"P176","2007-08-04","Känd","Harju","kask",1,"Siil",40,700,28000,8]
[null,"P176","2007-08-04","Känd","Harju","lepp",2,"Siil",31,585,18135,8]
[null,"P177","2007-08-05","Juur","Pärnu","lepp",3,"Rebane",58,520,30160,8]
[null,"P178","2007-08-05","Kass","Paide","mänd",1,"Jänes",48,750,36000,8]
[null,"P179","2007-08-06","Vaher","Rapla","lepp",2,"Põder",63,585,36855,8]
[null,"P180","2007-08-08","Känd","Harju","lepp",3,"Hunt",31,520,16120,8]
[null,"P180","2007-08-08","Känd","Harju","saar",1,"Hunt",23,850,19550,8]
[null,"P181","2007-08-12","Kaasik","Pärnu","kask",1,"Karu",17,700,11900,8]
[null,"P181","2007-08-12","Kaasik","Pärnu","lepp",2,"Karu",72,585,42120,8]
[null,"P181","2007-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":750},{"$f":"P_hind * P_kogus","v":10500},{"$f":"MONTH(P_kuupäev)","v":8}]
[null,"P182","2007-08-13","Ilves","Lääne","lepp",1,"Karu",36,650,23400,8]
[null,"P183","2007-08-15","Pihel","Rapla","mänd",2,"Jänes",56,675,37800,8]
[null,"P184","2007-08-17","Kaun","Pärnu","küte",1,"Karu",14,470,6580,8]
[null,"P185","2007-08-18","Lind","Valga","lepp",1,"Karu",25,650,16250,8]
[null,"P185","2007-08-18","Lind","Valga","lepp",1,"Karu",18,650,11700,8]
[null,"P186","2007-08-19","Karu","Lääne","lepp",1,"Rebane",67,650,43550,8]
[null,"P187","2007-08-20","Kask","Pärnu","tamm",1,"Jänes",59,1100,64900,8]
[null,"P188","2007-08-21","Luik","Viljandi","kuusk",2,"Hunt",61,720,43920,8]
[null,"P189","2007-08-22","Kuusik","Viljandi","lepp",3,"Rebane",41,520,21320,8]
[null,"P189","2007-08-22","Kuusik","Viljandi","lepp",1,"Rebane",10,650,6500,8]
[null,"P190","2007-08-22","Kaun","Pärnu","tamm",2,"Põder",78,990,77220,8]
[null,"P191","2007-08-23","Saar","Valga","lepp",1,"Siil",31,650,20150,8]
[null,"P192","2007-08-24","Kuusik","Viljandi","tamm",2,"Põder",36,990,35640,8]
[null,"P193","2007-08-25","Kass","Paide","saar",2,"Hunt",16,765,12240,8]
[null,"P193","2007-08-25","Kass","Paide","tamm",1,"Hunt",11,1100,12100,8]
[null,"P194","2007-08-27","Seen","Võru","küte",1,"Karu",14,470,6580,8]
[null,"P194","2007-08-27","Seen","Võru","vaher",3,"Karu",69,760,52440,8]
[null,"P195","2007-08-27","Lepik","Paide","kuusk",1,"Hunt",20,800,16000,8]
[null,"P195","2007-08-27","Lepik","Paide","mänd",3,"Hunt",43,600,25800,8]
[null,"P195","2007-08-27","Lepik","Paide","mänd",1,"Hunt",12,750,9000,8]
[null,"P196","2007-08-28","Kaun","Pärnu","lepp",2,"Siil",38,585,22230,8]
[null,"P197","2007-08-29","Saar","Valga","küte",2,"Rebane",52,423,21996,8]
[null,"P198","2007-08-29","Ilves","Lääne","kuusk",3,"Karu",70,640,44800,8]
[null,"P199","2007-08-30","Känd","Harju","kask",1,"Rebane",14,700,9800,8]
[null,"P199","2007-08-30","Känd","Harju","lepp",3,"Rebane",10,520,5200,8]
[null,"P200","2007-08-31","Varblane","Harju","haab",1,"Rebane",25,500,12500,8]
[null,"P200","2007-08-31","Varblane","Harju","tamm",1,"Rebane",36,1100,39600,8]
[null,"P201","2007-09-02","Lind","Valga","kuusk",2,"Rebane",71,720,51120,9]
[null,"P201","2007-09-02","Lind","Valga","lepp",1,"Rebane",75,650,48750,9]
[null,"P202","2007-09-04","Vaher","Rapla","lepp",2,"Põder",65,585,38025,9]
[null,"P203","2007-09-04","Lepp","Viljandi","mänd",1,"Põder",13,750,9750,9]
[null,"P204","2007-09-05","Haab","Pärnu","saar",2,"Siil",19,765,14535,9]
[null,"P205","2007-09-09","Haab","Pärnu","kuusk",3,"Jänes",69,640,44160,9]
[null,"P206","2007-09-12","Kuusik","Viljandi","haab",2,"Ilves",70,450,31500,9]
[null,"P206","2007-09-12","Kuusik","Viljandi","kask",1,"Ilves",32,700,22400,9]
[null,"P207","2007-09-14","Ilves","Lääne","vaher",3,"Rebane",10,760,7600,9]
[null,"P208","2007-09-15","Kask","Pärnu","küte",1,"Ilves",71,470,33370,9]
[null,"P209","2007-09-16","Lind","Valga","küte",2,"Siil",20,423,8460,9]
[null,"P210","2007-09-17","Karu","Lääne","küte",1,"Jänes",16,470,7520,9]
[null,"P211","2007-09-18","Seen","Võru","haab",2,"Karu",21,450,9450,9]
[null,"P212","2007-09-19","Seen","Võru","haab",1,"Siil",31,500,15500,9]
[null,"P213","2007-09-21","Karu","Lääne","mänd",2,"Rebane",59,675,39825,9]
[null,"P213","2007-09-21","Karu","Lääne","mänd",2,"Rebane",24,675,16200,9]
[null,"P213","2007-09-21","Karu","Lääne","saar",3,"Rebane",59,680,40120,9]
[null,"P214","2007-09-21","Varblane","Harju","lepp",1,"Jänes",58,650,37700,9]
[null,"P215","2007-09-22","Lepp","Viljandi","kask",2,"Ilves",79,630,49770,9]
[null,"P215","2007-09-22","Lepp","Viljandi","kask",1,"Ilves",47,700,32900,9]
[null,"P216","2007-09-23","Pihel","Rapla","kask",3,"Jänes",74,560,41440,9]
[null,"P217","2007-09-23","Seen","Võru","saar",2,"Siil",26,765,19890,9]
[null,"P218","2007-09-24","Varblane","Harju","haab",2,"Rebane",58,450,26100,9]
[null,"P218","2007-09-24","Varblane","Harju","kuusk",1,"Rebane",53,800,42400,9]
[null,"P218","2007-09-24","Varblane","Harju","küte",3,"Rebane",77,376,28952,9]
[null,"P219","2007-09-25","Seen","Võru","kask",2,"Ilves",40,630,25200,9]
[null,"P220","2007-09-26","Paju","Võru","kuusk",1,"Rebane",28,800,22400,9]
[null,"P221","2007-09-27","Haab","Pärnu","haab",3,"Hunt",44,400,17600,9]
[null,"P221","2007-09-27","Haab","Pärnu","mänd",1,"Hunt",48,750,36000,9]
[null,"P222","2007-09-29","Paju","Võru","kuusk",2,"Rebane",34,720,24480,9]
[null,"P223","2007-10-02","Vaher","Rapla","haab",1,"Siil",31,500,15500,10]
[null,"P224","2007-10-03","Pihel","Rapla","mänd",1,"Ilves",60,750,45000,10]
[null,"P225","2007-10-05","Lepp","Viljandi","lepp",2,"Siil",29,585,16965,10]
[null,"P226","2007-10-06","Kask","Pärnu","lepp",2,"Jänes",20,585,11700,10]
[null,"P227","2007-10-07","Kuusk","Lääne","kask",1,"Ilves",51,700,35700,10]
[null,"P227","2007-10-07","Kuusk","Lääne","vaher",1,"Ilves",61,950,57950,10]
[null,"P228","2007-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":850},{"$f":"P_hind * P_kogus","v":10200},{"$f":"MONTH(P_kuupäev)","v":10}]
[null,"P229","2007-10-08","Kass","Paide","vaher",2,"Siil",20,855,17100,10]
[null,"P230","2007-10-09","Haab","Pärnu","haab",2,"Põder",70,450,31500,10]
[null,"P230","2007-10-09","Haab","Pärnu","küte",1,"Põder",30,470,14100,10]
[null,"P231","2007-10-10","Luik","Viljandi","haab",2,"Karu",46,450,20700,10]
[null,"P231","2007-10-10","Luik","Viljandi","küte",2,"Karu",71,423,30033,10]
[null,"P232","2007-10-11","Varblane","Harju","kask",3,"Põder",71,560,39760,10]
[null,"P233","2007-10-12","Juur","Pärnu","haab",1,"Karu",35,500,17500,10]
[null,"P234","2007-10-13","Paju","Võru","kuusk",3,"Ilves",63,640,40320,10]
[null,"P234","2007-10-13","Paju","Võru","mänd",1,"Ilves",73,750,54750,10]
[null,"P235","2007-10-14","Juur","Pärnu","mänd",1,"Karu",59,750,44250,10]
[null,"P235","2007-10-14","Juur","Pärnu","saar",3,"Karu",29,680,19720,10]
[null,"P236","2007-10-15","Lind","Valga","kuusk",1,"Jänes",77,800,61600,10]
[null,"P237","2007-10-16","Mänd","Harju","kask",3,"Karu",76,560,42560,10]
[null,"P237","2007-10-16","Mänd","Harju","kask",1,"Karu",49,700,34300,10]
[null,"P238","2007-10-17","Kaasik","Pärnu","haab",1,"Karu",41,500,20500,10]
[null,"P238","2007-10-17","Kaasik","Pärnu","lepp",3,"Karu",55,520,28600,10]
[null,"P239","2007-10-18","Karu","Lääne","lepp",2,"Ilves",37,585,21645,10]
[null,"P240","2007-10-19","Mänd","Harju","mänd",1,"Ilves",55,750,41250,10]
[null,"P241","2007-10-20","Ilves","Lääne","kuusk",2,"Siil",43,720,30960,10]
[null,"P241","2007-10-20","Ilves","Lääne","kuusk",2,"Siil",43,720,30960,10]
[null,"P242","2007-10-21","Tuvi","Harju","kuusk",1,"Karu",24,800,19200,10]
[null,"P242","2007-10-21","Tuvi","Harju","mänd",3,"Karu",60,600,36000,10]
[null,"P243","2007-10-21","Kass","Paide","mänd",1,"Ilves",62,750,46500,10]
[null,"P243","2007-10-21","Kass","Paide","mänd",3,"Ilves",62,600,37200,10]
[null,"P244","2007-10-22","Mänd","Harju","küte",3,"Siil",61,376,22936,10]
[null,"P245","2007-10-23","Ilves","Lääne","kask",1,"Karu",47,700,32900,10]
[null,"P245","2007-10-23","Ilves","Lääne","kuusk",3,"Karu",36,640,23040,10]
[null,"P245","2007-10-23","Ilves","Lääne","saar",3,"Karu",43,680,29240,10]
[null,"P246","2007-10-23","Kass","Paide","mänd",1,"Jänes",26,750,19500,10]
[null,"P247","2007-10-25","Tuvi","Harju","haab",2,"Põder",10,450,4500,10]
[null,"P247","2007-10-25","Tuvi","Harju","kuusk",1,"Põder",39,800,31200,10]
[null,"P248","2007-10-27","Saar","Valga","küte",2,"Rebane",77,423,32571,10]
[null,"P249","2007-10-27","Lepik","Paide","küte",1,"Ilves",78,470,36660,10]
[null,"P250","2007-10-28","Ilves","Lääne","haab",3,"Hunt",59,400,23600,10]
[null,"P250","2007-10-28","Ilves","Lääne","küte",1,"Hunt",56,470,26320,10]
[null,"P251","2007-10-29","Paju","Võru","mänd",2,"Karu",55,675,37125,10]
[null,"P251","2007-10-29","Paju","Võru","mänd",2,"Karu",50,675,33750,10]
[null,"P252","2007-10-30","Seen","Võru","küte",1,"Ilves",23,470,10810,10]
[null,"P253","2007-10-31","Juur","Pärnu","kuusk",2,"Ilves",28,720,20160,10]
[null,"P253","2007-10-31","Juur","Pärnu","saar",3,"Ilves",60,680,40800,10]
[null,"P254","2007-11-01","Varblane","Harju","haab",1,"Jänes",26,500,13000,11]
[null,"P254","2007-11-01","Varblane","Harju","kask",3,"Jänes",52,560,29120,11]
[null,"P255","2007-11-03","Kaun","Pärnu","küte",1,"Rebane",61,470,28670,11]
[null,"P255","2007-11-03","Kaun","Pärnu","vaher",1,"Rebane",26,950,24700,11]
[null,"P256","2007-11-04","Känd","Harju","haab",1,"Ilves",23,500,11500,11]
[null,"P257","2007-11-05","Mänd","Harju","kuusk",1,"Põder",68,800,54400,11]
[null,"P257","2007-11-05","Mänd","Harju","mänd",2,"Põder",23,675,15525,11]
[null,"P258","2007-11-08","Lind","Valga","kuusk",2,"Karu",45,720,32400,11]
[null,"P258","2007-11-08","Lind","Valga","lepp",2,"Karu",18,585,10530,11]
[null,"P259","2007-11-09","Kask","Pärnu","küte",1,"Hunt",30,470,14100,11]
[null,"P260","2007-11-12","Kaasik","Pärnu","lepp",2,"Jänes",18,585,10530,11]
[null,"P260","2007-11-12","Kaasik","Pärnu","mänd",3,"Jänes",59,600,35400,11]
[null,"P261","2007-11-13","Ilves","Lääne","kask",3,"Rebane",68,560,38080,11]
[null,"P261","2007-11-13","Ilves","Lääne","lepp",2,"Rebane",13,585,7605,11]
[null,"P262","2007-11-15","Kuusk","Lääne","kask",1,"Siil",73,700,51100,11]
[null,"P262","2007-11-15","Kuusk","Lääne","saar",1,"Siil",71,850,60350,11]
[null,"P263","2007-11-17","Saar","Valga","mänd",1,"Hunt",20,750,15000,11]
[null,"P264","2007-11-18","Kuusik","Viljandi","haab",3,"Ilves",26,400,10400,11]
[null,"P264","2007-11-18","Kuusik","Viljandi","mänd",1,"Ilves",32,750,24000,11]
[null,"P265","2007-11-19","Paju","Võru","saar",3,"Hunt",62,680,42160,11]
[null,"P265","2007-11-19","Paju","Võru","vaher",1,"Hunt",25,950,23750,11]
[null,"P266","2007-11-21","Kaun","Pärnu","kask",2,"Karu",70,630,44100,11]
[null,"P267","2007-11-22","Ilves","Lääne","küte",1,"Hunt",76,470,35720,11]
[null,"P267","2007-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":423},{"$f":"P_hind * P_kogus","v":5499},{"$f":"MONTH(P_kuupäev)","v":11}]
[null,"P267","2007-11-22","Ilves","Lääne","lepp",1,"Hunt",79,650,51350,11]
[null,"P267","2007-11-22","Ilves","Lääne","saar",1,"Hunt",34,850,28900,11]
[null,"P268","2007-11-22","Lepik","Paide","mänd",2,"Põder",41,675,27675,11]
[null,"P269","2007-11-27","Ilves","Lääne","haab",3,"Karu",23,400,9200,11]
[null,"P269","2007-11-27","Ilves","Lääne","saar",2,"Karu",32,765,24480,11]
[null,"P270","2007-11-28","Kuusik","Viljandi","lepp",3,"Rebane",27,520,14040,11]
[null,"P271","2007-11-29","Kass","Paide","kuusk",3,"Ilves",60,640,38400,11]
[null,"P271","2007-11-29","Kass","Paide","saar",1,"Ilves",52,850,44200,11]
[null,"P272","2007-11-30","Kask","Pärnu","kuusk",1,"Ilves",29,800,23200,11]
[null,"P273","2007-12-01","Tuvi","Harju","kask",2,"Karu",48,630,30240,12]
[null,"P274","2007-12-01","Varblane","Harju","lepp",1,"Siil",67,650,43550,12]
[null,"P275","2007-12-01","Karu","Lääne","kuusk",1,"Hunt",47,800,37600,12]
[null,"P275","2007-12-01","Karu","Lääne","küte",2,"Hunt",17,423,7191,12]
[null,"P275","2007-12-01","Karu","Lääne","lepp",2,"Hunt",8,585,4680,12]
[null,"P276","2007-12-02","Saar","Valga","kuusk",1,"Karu",36,800,28800,12]
[null,"P277","2007-12-03","Vaher","Rapla","lepp",2,"Jänes",21,585,12285,12]
[null,"P278","2007-12-05","Lepp","Viljandi","kuusk",3,"Jänes",55,640,35200,12]
[null,"P279","2007-12-08","Saar","Valga","haab",1,"Rebane",21,500,10500,12]
[null,"P280","2007-12-09","Karu","Lääne","kuusk",2,"Põder",33,720,23760,12]
[null,"P281","2007-12-10","Kuusk","Lääne","haab",1,"Karu",34,500,17000,12]
[null,"P281","2007-12-10","Kuusk","Lääne","küte",1,"Karu",54,470,25380,12]
[null,"P281","2007-12-10","Kuusk","Lääne","mänd",1,"Karu",78,750,58500,12]
[null,"P282","2007-12-11","Vares","Rapla","kuusk",2,"Karu",78,720,56160,12]
[null,"P282","2007-12-11","Vares","Rapla","lepp",1,"Karu",53,650,34450,12]
[null,"P282","2007-12-11","Vares","Rapla","saar",1,"Karu",26,850,22100,12]
[null,"P283","2007-12-12","Tuvi","Harju","kuusk",1,"Karu",63,800,50400,12]
[null,"P284","2007-12-13","Tuvi","Harju","kuusk",1,"Hunt",26,800,20800,12]
[null,"P284","2007-12-13","Tuvi","Harju","tamm",2,"Hunt",18,990,17820,12]
[null,"P285","2007-12-16","Seen","Võru","küte",1,"Karu",33,470,15510,12]
[null,"P285","2007-12-16","Seen","Võru","mänd",3,"Karu",60,600,36000,12]
[null,"P286","2007-12-20","Karu","Lääne","lepp",1,"Karu",26,650,16900,12]
[null,"P287","2007-12-21","Vaher","Rapla","kuusk",3,"Siil",32,640,20480,12]
[null,"P288","2007-12-22","Pihel","Rapla","küte",1,"Jänes",12,470,5640,12]
[null,"P289","2007-12-23","Vaher","Rapla","vaher",1,"Hunt",18,950,17100,12]
[null,"P290","2007-12-24","Seen","Võru","kuusk",1,"Ilves",78,800,62400,12]
[null,"P291","2007-12-27","Vaher","Rapla","saar",2,"Ilves",36,765,27540,12]
[null,"P291","2007-12-27","Vaher","Rapla","saar",3,"Ilves",26,680,17680,12]
[null,"P292","2007-12-27","Lepp","Viljandi","haab",1,"Hunt",42,500,21000,12]
[null,"P292","2007-12-27","Lepp","Viljandi","mänd",1,"Hunt",65,750,48750,12]
[null,"P293","2007-12-28","Lepik","Paide","lepp",2,"Ilves",45,585,26325,12]
[null,"P293","2007-12-28","Lepik","Paide","vaher",1,"Ilves",21,950,19950,12]
[null,"P294","2007-12-29","Seen","Võru","haab",2,"Karu",13,450,5850,12]
[null,"P295","2007-12-30","Lepp","Viljandi","saar",1,"Karu",17,850,14450,12]
[null,"P296","2007-12-30","Saar","Valga","kuusk",1,"Jänes",25,800,20000,12]

{"sheet":"Filter_PM1","index":8,"n_rows":43,"n_cols":17,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[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,"P_maa","P_ostja","P_liik","P_müüja"]
[]
[null," Etteantud kuu kirjed. Kriteeriumis  kasutatakse valideerimist"]
[null,"P_kuu",null,null,null,null,null,null,null,null,null,null,null,"P_maa","P_ostja","P_liik","P_müüja"]
[null,12,null,null,null,null,null,null,null,null,null,null,null,"Võru","Seen","mänd","Siil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pärnu","Haab","kask","Karu"]
[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,"Lääne","Karu","vaher","Põder"]
[null,"P273","2007-12-01","Tuvi","Harju","kask",2,"Karu",48,630,30240,12,null,"Valga","Juur","lepp","Rebane"]
[null,"P274","2007-12-01","Varblane","Harju","lepp",1,"Siil",67,650,43550,12,null,"Rapla","Lind","küte","Jänes"]
[null,"P275","2007-12-01","Karu","Lääne","kuusk",1,"Hunt",47,800,37600,12,null,"Harju","Vaher","kuusk","Hunt"]
[null,"P275","2007-12-01","Karu","Lääne","küte",2,"Hunt",17,423,7191,12,null,"Viljandi","Mänd","saar","Ilves"]
[null,"P275","2007-12-01","Karu","Lääne","lepp",2,"Hunt",8,585,4680,12,null,"Paide","Lepp","tamm"]
[null,"P276","2007-12-02","Saar","Valga","kuusk",1,"Karu",36,800,28800,12,null,null,"Lepik","haab"]
[null,"P277","2007-12-03","Vaher","Rapla","lepp",2,"Jänes",21,585,12285,12,null,null,"Vares"]
[null,"P278","2007-12-05","Lepp","Viljandi","kuusk",3,"Jänes",55,640,35200,12,null,null,"Kask"]
[null,"P279","2007-12-08","Saar","Valga","haab",1,"Rebane",21,500,10500,12,null,null,"Varblane"]
[null,"P280","2007-12-09","Karu","Lääne","kuusk",2,"Põder",33,720,23760,12,null,null,"Ilves"]
[null,"P281","2007-12-10","Kuusk","Lääne","haab",1,"Karu",34,500,17000,12,null,null,"Paju"]
[null,"P281","2007-12-10","Kuusk","Lääne","küte",1,"Karu",54,470,25380,12,null,null,"Pihel"]
[null,"P281","2007-12-10","Kuusk","Lääne","mänd",1,"Karu",78,750,58500,12,null,null,"Kaun"]
[null,"P282","2007-12-11","Vares","Rapla","kuusk",2,"Karu",78,720,56160,12,null,null,"Kuusik"]
[null,"P282","2007-12-11","Vares","Rapla","lepp",1,"Karu",53,650,34450,12,null,null,"Känd"]
[null,"P282","2007-12-11","Vares","Rapla","saar",1,"Karu",26,850,22100,12,null,null,"Tuvi"]
[null,"P283","2007-12-12","Tuvi","Harju","kuusk",1,"Karu",63,800,50400,12,null,null,"Luik"]
[null,"P284","2007-12-13","Tuvi","Harju","kuusk",1,"Hunt",26,800,20800,12,null,null,"Saar"]
[null,"P284","2007-12-13","Tuvi","Harju","tamm",2,"Hunt",18,990,17820,12,null,null,"Kass"]
[null,"P285","2007-12-16","Seen","Võru","küte",1,"Karu",33,470,15510,12,null,null,"Kaasik"]
[null,"P285","2007-12-16","Seen","Võru","mänd",3,"Karu",60,600,36000,12,null,null,"Kuusk"]
[null,"P286","2007-12-20","Karu","Lääne","lepp",1,"Karu",26,650,16900,12]
[null,"P287","2007-12-21","Vaher","Rapla","kuusk",3,"Siil",32,640,20480,12]
[null,"P288","2007-12-22","Pihel","Rapla","küte",1,"Jänes",12,470,5640,12]
[null,"P289","2007-12-23","Vaher","Rapla","vaher",1,"Hunt",18,950,17100,12]
[null,"P290","2007-12-24","Seen","Võru","kuusk",1,"Ilves",78,800,62400,12]
[null,"P291","2007-12-27","Vaher","Rapla","saar",2,"Ilves",36,765,27540,12]
[null,"P291","2007-12-27","Vaher","Rapla","saar",3,"Ilves",26,680,17680,12]
[null,"P292","2007-12-27","Lepp","Viljandi","haab",1,"Hunt",42,500,21000,12]
[null,"P292","2007-12-27","Lepp","Viljandi","mänd",1,"Hunt",65,750,48750,12]
[null,"P293","2007-12-28","Lepik","Paide","lepp",2,"Ilves",45,585,26325,12]
[null,"P293","2007-12-28","Lepik","Paide","vaher",1,"Ilves",21,950,19950,12]
[null,"P294","2007-12-29","Seen","Võru","haab",2,"Karu",13,450,5850,12]
[null,"P295","2007-12-30","Lepp","Viljandi","saar",1,"Karu",17,850,14450,12]
[null,"P296","2007-12-30","Saar","Valga","kuusk",1,"Jänes",25,800,20000,12]

{"sheet":"Filter_PM2","index":9,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[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,"Väljad kuupäev, arve, müüja, ostja, kogus ja maksumus etteantud maakonna ja puu liigi jaoks "]
[null,"P_maa","P_liik",null,null,null,null,null,null,"P_liik","P_kuupäev","P_kuupäev"]
[null,"Pärnu","küte",null,null,null,null,null,null,"mänd",">=1.01.2007","<=31.03.2007"]
[]
[null,"P_kuupäev","P_arve","P_müüja","P_ostja","P_kogus","P_maks",null,null,null,"Kokku",{"$f":"SUM(L12:L112)","v":649},{"$f":"SUM(M12:M112)","v":460575}]
[null,"2007-01-23","P020","Põder","Kaun",48,22560]
[null,"2007-05-09","P112","Karu","Haab",18,8460,null,null,"P_müüja","P_kuupäev","P_kogus","P_maks"]
[null,"2007-05-11","P115","Ilves","Juur",71,33370,null,null,"Siil","2007-01-02",28,18900]
[null,"2007-05-27","P130","Hunt","Juur",11,4653,null,null,"Rebane","2007-01-06",37,24975]
[null,"2007-08-17","P184","Karu","Kaun",14,6580,null,null,"Hunt","2007-01-09",55,41250]
[null,"2007-09-15","P208","Ilves","Kask",71,33370,null,null,"Hunt","2007-01-09",39,26325]
[null,"2007-10-09","P230","Põder","Haab",30,14100,null,null,"Siil","2007-01-14",40,30000]
[null,"2007-11-03","P255","Rebane","Kaun",61,28670,null,null,"Jänes","2007-01-24",73,54750]
[null,"2007-11-09","P259","Hunt","Kask",30,14100,null,null,"Jänes","2007-02-02",53,39750]
[null,null,null,null,null,null,null,null,null,"Siil","2007-02-05",30,22500]
[null,"P_kuupäev","P_arve","P_müüja","P_ostja","P_kogus","P_maks",null,null,"Ilves","2007-02-18",36,27000]
[null,"2007-01-23","P020","Põder","Kaun",48,22560,null,null,"Siil","2007-02-20",74,55500]
[null,"2007-05-09","P112","Karu","Haab",18,8460,null,null,"Hunt","2007-02-25",33,19800]
[null,"2007-05-11","P115","Ilves","Juur",71,33370,null,null,"Jänes","2007-03-06",49,33075]
[null,"2007-05-27","P130","Hunt","Juur",11,4653,null,null,"Rebane","2007-03-08",28,16800]
[null,"2007-08-17","P184","Karu","Kaun",14,6580,null,null,"Siil","2007-03-08",22,14850]
[null,"2007-09-15","P208","Ilves","Kask",71,33370,null,null,"Siil","2007-03-19",52,35100]
[null,"2007-10-09","P230","Põder","Haab",30,14100]
[null,"2007-11-03","P255","Rebane","Kaun",61,28670]
[null,"2007-11-09","P259","Hunt","Kask",30,14100]

{"sheet":"Rist_PM","index":10,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null," Puidu maksumus maakondade (read) ja liikide (veerud) lõikes"]
[null,"Sum of P_maks","P_liik"]
[null,"P_maa","haab","kask","kuusk","küte","lepp","mänd","saar","tamm","vaher","Grand Total"]
[null,"Harju",173600,288680,379840,117406,223340,497700,314500,115610,51300,2161976]
[null,"Lääne",56300,329700,191120,121448,279760,304800,221170,51590,124830,1680718]
[null,"Paide",33750,34720,54400,74918,60125,292725,99280,51370,49400,750688]
[null,"Pärnu",224050,204890,336960,165863,329160,387600,110075,353870,119985,2232453]
[null,"Rapla",45000,113820,161760,55225,163085,97050,82960,88000,17100,824000]
[null,"Valga",69300,66990,273680,158484,167830,260100,105485,40700,27360,1169929]
[null,"Viljandi",160450,179900,287920,138321,155480,92700,51000,131010,41610,1238391]
[null,"Võru",73450,111300,198240,148755,76115,320700,139060,null,76190,1143810]
[null,"Grand Total",835900,1330000,1883920,980420,1454895,2253375,1123530,832150,507775,11201965]
[]
[]
[null,"Müükide kogused kvartalite (read), müüjate (veerud) ja maakondade (lehekülg) lõikes"]
[null,"P_maa","(All)"]
[]
[null,"Sum of P_kogus",null,"P_müüja"]
[null,"Quarters","P_kuupäev","Hunt","Ilves","Jänes","Karu","Põder","Rebane","Siil","Grand Total"]
[null,"Qtr1","jaan",320,86,360,232,142,37,241,1418]
[null,null,"veebr",219,181,107,292,119,34,142,1094]
[null,null,"märts",154,300,184,498,75,94,308,1613]
[null,"Qtr2","apr",406,629,211,212,226,107,114,1905]
[null,null,"mai",212,413,198,106,141,113,57,1240]
[null,null,"juuni",186,84,36,210,113,215,107,951]
[null,"Qtr3","juuli",109,234,102,112,448,83,23,1111]
[null,null,"aug",229,null,163,384,177,313,140,1406]
[null,null,"sept",92,339,217,21,78,548,96,1391]
[null,"Qtr4","okt",115,713,135,776,220,77,227,2263]
[null,null,"nov",339,222,155,188,132,195,144,1375]
[null,null,"dets",241,206,113,619,33,21,99,1332]
[null,"Grand Total",null,2622,3407,1981,3650,1904,1837,1698,17099]

{"sheet":"SumIF_PM","index":11,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Maakond","Kogus","Maksumus"]
[null,"Harju",{"$f":"SUMIF(P_maa, Maakond, P_kogus)","v":3237},{"$f":"SUMIF(P_maa, Maakond, P_maks)","v":2161976}]
[null,"Lääne",2508,1680718]
[null,"Paide",1146,750688]
[null,"Pärnu",3365,2232453]
[null,"Rapla",1254,824000]
[null,"Valga",1818,1169929]
[null,"Viljandi",1991,1238391]
[null,"Võru",1780,1143810]
[]
[null,"Kokku",{"$f":"SUM(C4:C12)","v":17099},{"$f":"SUM(D4:D12)","v":11201965}]
[]
[]
[null,"Müüja","Kogus","Maksumus","Müükide arv"]
[null,"Karu",{"$f":"SUMIF(P_müüja, Müüja, P_kogus)","v":3650},{"$f":"SUMIF(P_müüja, Müüja, P_maks)","v":2321514},{"$f":"COUNTIF(P_müüja, Müüja)","v":89}]
[null,"Hunt",2622,1767735,76]
[null,"Jänes",1981,1329925,50]
[null,"Rebane",1837,1184385,50]
[null,"Siil",1698,1123966,47]
[null,"Põder",1904,1215357,44]
[null,"Ilves",3407,2259083,73]
[]
[null,"Kokku",{"$f":"SUM(C17:C24)","v":17099},{"$f":"SUM(D17:D24)","v":11201965},{"$f":"SUM(E17:E24)","v":429}]

{"sheet":"Sort","index":12,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,9,0,10]]}
[null,null,null,null,null,null,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,"2007-01-02","Tallinn","Frodo",2,{"$f":"VLOOKUP(Arvuti, Arvutid, 6, 0)","v":1330},{"$f":"Hind * Arv","v":2660}]
[null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,419,419]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,499,998]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,419,1257]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,849,1698]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,419,2095]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,465,1395]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,599,599]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,419,2514]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,1330,1330]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,1149,6894]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,1299,1299]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,589,2356]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,339,678]
[null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Marvin",1,599,599]
[null,null,null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,419,838]
[null,null,null,null,null,null,null,null,"2007-01-11","Valga","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,849,2547]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,1330,5320]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,699,1398]
[null,null,null,null,null,null,null,null,"2007-01-16","Tallinn","Arven",5,369,1845]
[null,null,null,null,null,null,null,null,"2007-01-17","Tallinn","Kalvar",7,699,4893]
[null,null,null,null,null,null,null,null,"2007-01-17","Tartu","Aragorn",3,499,1497]
[null,null,null,null,null,null,null,null,"2007-01-18","Pärnu","Eldar",1,465,465]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,499,499]
[null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Faram",3,599,1797]
[null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,699,699]
[null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,1299,6495]
[null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,1299,2598]
[null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,339,1017]
[null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,369,369]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,339,339]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,849,1698]

{"sheet":"Päringud","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Autofilter","index":14,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
[null,null,null,null,null,null,null,null,"Harjutustabelid"]
[null,null,null,null,null,null,null,null,"töötajad","puidu müük"]
[null,"AutoFilter - Data/Filter/AutoFilter"]
[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":7285},{"$f":"SUBTOTAL(9, N7:N40)","v":659230}]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,null,null,null,null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,null,null,null,null,null,null,null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,null,null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,null,null,null,null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,null,null,null,null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]

{"sheet":"Auto_AM","index":15,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null," arvuti on Balrog ",null,null,null,null,null,null,"müügid, kuus kuupäev on vahemikus 10.01.07 kuni 20.01.07"]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus",null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2007-01-02","Valga","Balrog",1,4190,4190,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,"2007-01-03","Tallinn","Balrog",3,4190,12570,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,"2007-01-11","Tartu","Balrog",2,4190,8380,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,"2007-01-17","Tallinn","Balrog",7,6990,48930,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,"2007-01-07","Valga","Balrog",6,4190,25140,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,"2007-01-04","Tartu","Balrog",5,4190,20950,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null," linn on Tallinn ja arvuti on Frodo",null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus",null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,"2007-01-02","Tallinn","Frodo",2,13300,26600,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,"2007-01-11","Tallinn","Frodo",1,13300,13300,null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,"2007-01-19","Tallinn","Frodo",3,13300,39900,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,"linn on Tallinn või Tartu",null,null,"Custom",null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus",null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,"2007-01-03","Tallinn","Aragorn",2,4990,9980,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,"2007-01-03","Tallinn","Balrog",3,4190,12570,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,"2007-01-04","Tallinn","Eldar",3,4650,13950,null,"Linn algab tähega T või tähega P ning arvuti on Eldar või Frodo"]
[null,"2007-01-07","Tallinn","Faram",1,5990,5990,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,"2007-01-02","Tallinn","Frodo",2,13300,26600,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,"2007-01-11","Tallinn","Frodo",1,13300,13300,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,"2007-01-16","Tallinn","Arven",5,3690,18450,null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,"2007-01-17","Tallinn","Balrog",7,6990,48930,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,"2007-01-18","Tallinn","Aragorn",1,4990,4990,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,"2007-01-19","Tallinn","Frodo",3,13300,39900,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,"2007-01-20","Tallinn","Elend",2,12990,25980,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,"2007-01-04","Tartu","Balrog",5,4190,20950]

{"sheet":"Aren_Filter","index":16,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,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,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Marvin",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,null,null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,null,null,null,null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,"Linn",null,"Linn","Arvuti",null,"Maksumus",null,"2007-01-17","Tallinn","Kalvar",7,6990,48930]
[null,"Pärnu",null,"Tallinn","Frodo",null,">20000",null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,"Linn",null,"Linn","Arvuti","Arv",null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,"Tallinn",null,"Tallinn","Balrog",">1",null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,"Tartu",null,"Tartu","Balrog",">1",null,null,"2007-01-19","Tallinn","Faram",3,5990,17970]
[null,"Võru",null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,"Arvuti","Kuupäev","Kuupäev",null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,"Aragorn",">=10.01.07","<=20.01.07",null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]

{"sheet":"Filter_AM","index":17,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,null,"Väljad Kuupäev, Linn, Arv kirjetest, kus Arvuti on Frodo ja "]
[null," kirjed, kus linn on Tallinn või Tartu",null,null,null,null,null,null,null,"      Kuupäev on vahemikus 01.01.07 kuni 15.01.07"]
[null,"Linn",null,null,null,null,null,null,null,"Arvuti","Kuupäev","Kuupäev"]
[null,"Tallinn",null,null,null,null,null,null,null,"Frodo",">=01.01.07","<=15.01.07"]
[null,"Tartu"]
[null,null,null,"Kokku",{"$f":"SUM(E12:E29)","v":53},null,{"$f":"SUM(G12:G29)","v":400850},null,null,"Kuupäev","Linn","Arv"]
[null,null,null,null,null,null,null,null,null,"2007-01-02","Tallinn",2]
[null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus",null,null,"2007-01-07","Valga",1]
[null,"2007-01-10","Tartu","Sauron",2,3390,6780,null,null,"2007-01-14","Tartu",4]
[null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,"2007-01-04","Tartu","Balrog",5,4190,20950]
[null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,"2007-01-17","Tallinn","Kalvar",7,6990,48930]
[null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[]
[null,"väljad Kuupäev, Arvuti ja Maksumus kirjetest, kus Linn on  Tallinn ja Arvuti on Balrog "]
[null,"Linn","Arvuti",null,null,null,null,"      "]
[null,"Tallinn","Aragorn"]
[]
[null,"Kuupäev","Arvuti","Maksumus"]
[null,"2007-01-03","Aragorn",9980]
[null,"2007-01-18","Aragorn",4990]

{"sheet":"Filter_PM_D","index":18,"n_rows":23,"n_cols":11,"rows_kept":23,"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":474},{"$f":"DSUM(PM, \"P_maks\",Kriteerium)","v":336960}]
[null,"P_maa","P_liik"]
[null,"Pärnu","kuusk"]
[]
[null,null,null,null,"Kokku:",{"$f":"SUM(F13:F203)","v":474},{"$f":"SUM(G13:G203)","v":336960}]
[]
[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,"2007-01-31","P028","Ilves","Kask",40,32000]
[null,"2007-03-31","P073","Hunt","Kaun",21,16800]
[null,"2007-04-02","P076","Siil","Kask",14,10080]
[null,"2007-04-21","P095","Karu","Haab",62,49600]
[null,"2007-05-14","P117","Jänes","Kaun",55,35200]
[null,"2007-05-22","P127","Ilves","Kaasik",74,53280]
[null,"2007-07-05","P153","Põder","Kaun",56,35840]
[null,"2007-07-20","P165","Karu","Kaun",26,16640]
[null,"2007-09-09","P205","Jänes","Haab",69,44160]
[null,"2007-10-31","P253","Ilves","Juur",28,20160]
[null,"2007-11-30","P272","Ilves","Kask",29,23200]

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

{"sheet":"Vahekokku","index":20,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,9,0,10]]}
[null,null,null,null,null,null,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,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]
[null,null,null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,null,null,null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]

{"sheet":"Risttabelid","index":21,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,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,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,null,null,null,null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,null,null,null,null,null,null,null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,null,null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,null,null,null,null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,null,null,null,null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]

{"sheet":"Rist_A1","index":22,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Sum of Maksumus"]
[null,"Linn","Total"]
[null,"Pärnu",101290]
[null,"Tallinn",289580]
[null,"Tartu",111270]
[null,"Valga",61600]
[null,"Võru",95490]
[null,"Grand Total",659230]
[]
[]
[null,"Sum of Maksumus"]
[null,"Arvuti","Total"]
[null,"Aragorn",34930]
[null,"Arven",22140]
[null,"Balrog",120160]
[null,"Eldar",32550]
[null,"Elend",103920]
[null,"Faram",5990]
[null,"Frodo",146300]
[null,"Gandalf",59430]
[null,"Grimbold",68940]
[null,"Kalvar",20970]
[null,"Rohan",23560]
[null,"Sauron",20340]
[null,"Grand Total",659230]
[]
[]
[null,"Sum of Arv"]
[null,"Kuupäev","Total"]
[null,"2007-01-02",3]
[null,"2007-01-03",7]
[null,"2007-01-04",8]
[null,"2007-01-07",11]
[null,"2007-01-09",6]
[null,"2007-01-10",7]
[null,"2007-01-11",4]
[null,"2007-01-14",9]
[null,"2007-01-16",5]
[null,"2007-01-17",10]
[null,"2007-01-18",2]
[null,"2007-01-19",9]
[null,"2007-01-20",5]
[null,"2007-01-21",1]
[null,"2007-01-25",1]
[null,"2007-01-26",2]
[null,"Grand Total",90]

{"sheet":"Rist_A2","index":23,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Data"]
[null,"Arvuti","Sum of Arv","Sum of Maksumus"]
[null,"Aragorn",7,34930]
[null,"Arven",6,22140]
[null,"Balrog",24,120160]
[null,"Eldar",7,32550]
[null,"Elend",8,103920]
[null,"Faram",1,5990]
[null,"Frodo",11,146300]
[null,"Gandalf",7,59430]
[null,"Grimbold",6,68940]
[null,"Kalvar",3,20970]
[null,"Rohan",4,23560]
[null,"Sauron",6,20340]
[null,"Grand Total",90,659230]
[]
[]
[]
[null,"Sum of Maksumus","Linn"]
[null,"Arvuti","Pärnu","Tallinn","Tartu","Valga","Võru","Grand Total"]
[null,"Aragorn",null,14970,14970,4990,null,34930]
[null,"Arven",3690,18450,null,null,null,22140]
[null,"Balrog",null,61500,29330,29330,null,120160]
[null,"Eldar",18600,13950,null,null,null,32550]
[null,"Elend",12990,25980,null,null,64950,103920]
[null,"Faram",null,5990,null,null,null,5990]
[null,"Frodo",null,79800,53200,13300,null,146300]
[null,"Gandalf",42450,null,null,null,16980,59430]
[null,"Grimbold",null,68940,null,null,null,68940]
[null,"Kalvar",null,null,6990,13980,null,20970]
[null,"Rohan",23560,null,null,null,null,23560]
[null,"Sauron",null,null,6780,null,13560,20340]
[null,"Grand Total",101290,289580,111270,61600,95490,659230]

{"sheet":"SumIF","index":24,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,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,null,null,null,null,null,null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus","Prots"]
[null,null,null,null,null,null,null,null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600,{"$f":"VLOOKUP(L6, Arvutid,2,0)","v":"AMD Athlon64"}]
[null,null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940,"Intel Core 2"]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300,"AMD Athlon64"]
[null,"Arvud","arv",null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380,"Intel Celeron"]
[null,23,21,{"$f":"COUNTIF(Arvud, 13)","v":3},"Mitu korda esineb loetelus arv 13",null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990,"AMD Athlon64"]
[null,-45,null,{"$f":"COUNTIF(Arvud, arv)","v":2},"Mitu korda esineb loetelus lahtris arv olev arv",null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470,"Intel Xeon"]
[null,13,null,{"$f":"SUMIF(Arvud, \">0\")","v":122},"Positiivsete arvude summa",null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200,"AMD Athlon64"]
[null,18,null,{"$f":"COUNTIF(Arvud, \">0\")","v":7},"Positiivsete arvude arv",null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980,"Intel Xeon"]
[null,21,null,{"$f":"SUMIF(Arvud, \">0\") / COUNTIF(Arvud, \">0\")","v":17.428571428571427},"Positiivsete arvude aritmeetiline keskmine",null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450,"Intel Core 2"]
[null,13,null,{"$f":"COUNTIF(Arvud, 21)","v":2},"Mitu korda esineb loetelus arv 21",null,null,null,null,"2007-01-17","Tallinn","Balrog",7,6990,48930,"Intel Celeron"]
[null,-16,null,{"$f":"SUMIF(Arvud, \"<0\")","v":-61},"Negatiivsete arvude summa",null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970,"AMD Athlon64"]
[null,21,null,{"$f":"COUNTIF(Arvud, \"<0\")","v":2},"Negatiivsete arvude arv",null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650,"Intel Xeon"]
[null,13,null,{"$f":"SUMIF(Arvud, \"<0\") / COUNTIF(Arvud, \"<0\")","v":-30.5},"Negatiivsete arvude aritmeetiline keskmine",null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900,"AMD Athlon64"]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980,"Intel Celeron"]
[null,null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690,"Intel Core 2"]
[null,null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390,"Intel Xeon"]
[null,null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980,"Intel Xeon"]

{"sheet":"Sheet2","index":25,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"suurem","kesk",null,"tt",null,"Prots"]
[null,null,{"$f":"SumIF!N6>kesk","v":true},{"$f":"AVERAGE(A_Hind)","v":7285},null,{"$f":"VLOOKUP(SumIF!L6, Arvutid, 2,0) = prots","v":false},null,"Intel Xeon"]
[]
[]
[]
[]
[null,null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus",null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus","Prots"]
[null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600,null,"2007-01-03","Võru","Gandalf",2,8490,16980,"Intel Xeon"]
[null,null,"2007-01-03","Võru","Gandalf",2,8490,16980,null,"2007-01-04","Tallinn","Eldar",3,4650,13950,"Intel Xeon"]
[null,null,"2007-01-07","Valga","Frodo",1,13300,13300,null,"2007-01-07","Pärnu","Eldar",3,4650,13950,"Intel Xeon"]
[null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940,null,"2007-01-10","Tartu","Sauron",2,3390,6780,"Intel Xeon"]
[null,null,"2007-01-10","Pärnu","Elend",1,12990,12990,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470,"Intel Xeon"]
[null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300,null,"2007-01-14","Valga","Kalvar",2,6990,13980,"Intel Xeon"]
[null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470,null,"2007-01-18","Pärnu","Eldar",1,4650,4650,"Intel Xeon"]
[null,null,"2007-01-14","Tartu","Frodo",4,13300,53200,null,"2007-01-19","Tartu","Kalvar",1,6990,6990,"Intel Xeon"]
[null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900,null,"2007-01-20","Võru","Sauron",3,3390,10170,"Intel Xeon"]
[null,null,"2007-01-19","Võru","Elend",5,12990,64950,null,"2007-01-25","Võru","Sauron",1,3390,3390,"Intel Xeon"]
[null,null,"2007-01-20","Tallinn","Elend",2,12990,25980,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980,"Intel Xeon"]
[null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]
[]
[]
[]
[null,null,"A_Kuupäev","A_Linn","A_Arvuti","A_Arv","A_Hind","A_Maksumus"]
[null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]

{"sheet":"SumIF (2)","index":26,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Harjutustabel",null,"Puidu müük"]
[null,null,null,null,null,null,null,null,null,"üle",null,null,null,null,"kesk"]
[null,null,null,null,null,null,null,null,null,{"$f":"N10>$O$3","v":true},null,null,null,null,{"$f":"AVERAGE(A_Hind)","v":7285}]
[]
[]
[]
[null,"Funktsioonid COUNTIF ja SUMIF ",null,null,null,null,null,null,null,"Arvutite müükide arvestus"]
[]
[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,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,null,null,null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,"Arvud","arv",null,null,null,null,null,null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,23,21,{"$f":"COUNTIF(Arvud, 13)","v":3},"Mitu korda esineb loetelus arv 13",null,null,null,null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,-45,null,{"$f":"COUNTIF(Arvud, arv)","v":2},"Mitu korda esineb loetelus lahtris arv olev arv",null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,13,null,{"$f":"SUMIF(Arvud, \">0\")","v":122},"Positiivsete arvude summa",null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,18,null,{"$f":"COUNTIF(Arvud, \">0\")","v":7},"Positiivsete arvude arv",null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,21,null,{"$f":"SUMIF(Arvud, \">0\") / COUNTIF(Arvud, \">0\")","v":17.428571428571427},"Positiivsete arvude aritmeetiline keskmine",null,null,null,null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,13,null,{"$f":"COUNTIF(Arvud, 21)","v":2},"Mitu korda esineb loetelus arv 21",null,null,null,null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,-16,null,{"$f":"SUMIF(Arvud, \"<0\")","v":-61},"Negatiivsete arvude summa",null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,21,null,{"$f":"COUNTIF(Arvud, \"<0\")","v":2},"Negatiivsete arvude arv",null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,13,null,{"$f":"SUMIF(Arvud, \"<0\") / COUNTIF(Arvud, \"<0\")","v":-30.5},"Negatiivsete arvude aritmeetiline keskmine",null,null,null,null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]

{"sheet":"Sum_IF_AM","index":27,"n_rows":66,"n_cols":4,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Koond linnade lõikes"]
[]
[null,"Linn","Arv","Maksumus"]
[null,"Tallinn",{"$f":"SUMIF(A_Linn, Linn, A_Arv)","v":36},{"$f":"SUMIF(A_Linn, Linn, A_Maksumus)","v":289580}]
[null,"Tartu",{"$f":"SUMIF(A_Linn, Linn, A_Arv)","v":17},{"$f":"SUMIF(A_Linn, Linn, A_Maksumus)","v":111270}]
[null,"Pärnu",{"$f":"SUMIF(A_Linn, Linn, A_Arv)","v":15},{"$f":"SUMIF(A_Linn, Linn, A_Maksumus)","v":101290}]
[null,"Valga",{"$f":"SUMIF(A_Linn, Linn, A_Arv)","v":11},{"$f":"SUMIF(A_Linn, Linn, A_Maksumus)","v":61600}]
[null,"Võru",{"$f":"SUMIF(A_Linn, Linn, A_Arv)","v":11},{"$f":"SUMIF(A_Linn, Linn, A_Maksumus)","v":95490}]
[]
[null,"Kokku",{"$f":"SUM(C6:C11)","v":90},{"$f":"SUM(D6:D11)","v":659230}]
[]
[]
[null,"Arvuti","Arv","Maksumus"]
[null,"Aragorn",{"$f":"SUMIF(A_Arvuti,Arvuti, A_Arv)","v":7},{"$f":"SUMIF(A_Arvuti,Arvuti, A_Maksumus)","v":34930}]
[null,"Arven",6,22140]
[null,"Balrog",24,120160]
[null,"Eldar",7,32550]
[null,"Elend",8,103920]
[null,"Faram",1,5990]
[null,"Frodo",11,146300]
[null,"Gandalf",7,59430]
[null,"Grimbold",6,68940]
[null,"Kalvar",3,20970]
[null,"Marvin",0,0]
[null,"Rohan",4,23560]
[null,"Sauron",6,20340]
[]
[null,"Kokku",{"$f":"SUM(C16:C29)","v":90},{"$f":"SUM(D16:D29)","v":659230}]
[]
[]
[null,"Kuupäev","Arv","Maksumus"]
[null,"2007-01-01",{"$f":"SUMIF(A_Kuupäev,Kuupäev, A_Arv)","v":0},{"$f":"SUMIF(A_Kuupäev, Kuupäev, A_Maksumus)","v":0}]
[null,"2007-01-02",3,30790]
[null,"2007-01-03",7,39530]
[null,"2007-01-04",8,34900]
[null,"2007-01-05",0,0]
[null,"2007-01-06",0,0]
[null,"2007-01-07",11,58380]
[null,"2007-01-08",0,0]
[null,"2007-01-09",6,68940]
[null,"2007-01-10",7,43330]
[null,"2007-01-11",4,26670]
[null,"2007-01-12",0,0]
[null,"2007-01-13",0,0]
[null,"2007-01-14",9,92650]
[null,"2007-01-15",0,0]
[null,"2007-01-16",5,18450]
[null,"2007-01-17",10,63900]
[null,"2007-01-18",2,9640]
[null,"2007-01-19",9,111840]
[null,"2007-01-20",5,36150]
[null,"2007-01-21",1,3690]
[null,"2007-01-22",0,0]
[null,"2007-01-23",0,0]
[null,"2007-01-24",0,0]
[null,"2007-01-25",1,3390]
[null,"2007-01-26",2,16980]
[null,"2007-01-27",0,0]
[null,"2007-01-28",0,0]
[null,"2007-01-29",0,0]
[null,"2007-01-30",0,0]
[null,"2007-01-31",0,0]
[]
[null,"Kokku",{"$f":"SUM(C34:C65)","v":90},{"$f":"SUM(D34:D65)","v":659230}]

{"sheet":"D_Fumkts","index":28,"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":659230}]
[]
[null,null,null,null,null,null,null,null,"Kuupäev","Linn","Arvuti","Arv","Hind","Maksumus"]
[null,null,null,null,null,null,null,null,"2007-01-02","Tallinn","Frodo",2,13300,26600]
[null,null,null,null,null,null,null,null,"2007-01-02","Valga","Balrog",1,4190,4190]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Aragorn",2,4990,9980]
[null,null,null,null,null,null,null,null,"2007-01-03","Tallinn","Balrog",3,4190,12570]
[null,null,null,null,null,null,null,null,"2007-01-03","Võru","Gandalf",2,8490,16980]
[null,null,null,null,null,null,null,null,"2007-01-04","Tallinn","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-04","Tartu","Balrog",5,4190,20950]
[null,null,null,null,null,null,null,null,"2007-01-07","Pärnu","Eldar",3,4650,13950]
[null,null,null,null,null,null,null,null,"2007-01-07","Tallinn","Faram",1,5990,5990]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Balrog",6,4190,25140]
[null,null,null,null,null,null,null,null,"2007-01-07","Valga","Frodo",1,13300,13300]
[null,null,null,null,null,null,null,null,"2007-01-09","Tallinn","Grimbold",6,11490,68940]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Elend",1,12990,12990]
[null,null,null,null,null,null,null,null,"2007-01-10","Pärnu","Rohan",4,5890,23560]
[null,null,null,null,null,null,null,null,"2007-01-10","Tartu","Sauron",2,3390,6780]
[null,"Antud linnades müüdud arvutite arv ja maksumus",null,null,null,null,null,null,"2007-01-11","Tallinn","Frodo",1,13300,13300]
[null,"Linn",null,null,null,"Arv","Maksumus",null,"2007-01-11","Tartu","Balrog",2,4190,8380]
[null,"Tallinn",null,null,null,{"$f":"DSUM(AM_1, \"Arv\", B24:B26)","v":53},{"$f":"DSUM(AM_1, \"Maksumus\", B24:B26)","v":400850},null,"2007-01-11","Valga","Aragorn",1,4990,4990]
[null,"Tartu",null,null,null,null,null,null,"2007-01-14","Pärnu","Gandalf",3,8490,25470]
[null,null,null,null,null,null,null,null,"2007-01-14","Tartu","Frodo",4,13300,53200]
[null,null,null,null,null,null,null,null,"2007-01-14","Valga","Kalvar",2,6990,13980]
[null,"Linn","Arvuti",null,null,"Arv","Maksumus",null,"2007-01-16","Tallinn","Arven",5,3690,18450]
[null,"Tallinn","Aragorn",null,null,{"$f":"DSUM(AM_1, \"Arv\", B29:C30)","v":3},{"$f":"DSUM(AM_1, \"Maksumus\", B29:C30)","v":14970},null,"2007-01-17","Tallinn","Balrog",7,6990,48930]
[null,null,null,null,null,null,null,null,"2007-01-17","Tartu","Aragorn",3,4990,14970]
[null,null,null,null,null,null,null,null,"2007-01-18","Pärnu","Eldar",1,4650,4650]
[null,"Arvuti","Kuupäev","Kuupäev",null,"Arv","Maksumus",null,"2007-01-18","Tallinn","Aragorn",1,4990,4990]
[null,"Aragorn",">=01.01.07","<=15.01.07",null,{"$f":"DSUM(AM_1, \"Arv\", B33:D34)","v":3},{"$f":"DSUM(AM_1, \"Maksumus\", B33:D34)","v":14970},null,"2007-01-19","Tallinn","Frodo",3,13300,39900]
[null,null,null,null,null,null,null,null,"2007-01-19","Tartu","Kalvar",1,6990,6990]
[null,null,null,null,null,null,null,null,"2007-01-19","Võru","Elend",5,12990,64950]
[null,null,null,null,null,null,null,null,"2007-01-20","Tallinn","Elend",2,12990,25980]
[null,null,null,null,null,null,null,null,"2007-01-20","Võru","Sauron",3,3390,10170]
[null,null,null,null,null,null,null,null,"2007-01-21","Pärnu","Arven",1,3690,3690]
[null,null,null,null,null,null,null,null,"2007-01-25","Võru","Sauron",1,3390,3390]
[null,null,null,null,null,null,null,null,"2007-01-26","Pärnu","Gandalf",2,8490,16980]

{"sheet":"P_abi","index":29,"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",500,{"$f":"0.9*C6","v":450},{"$f":"0.8*C6","v":400}]
[null,"kask",700,630,560]
[null,"kuusk",800,720,640]
[null,"küte",470,423,376]
[null,"lepp",650,585,520]
[null,"mänd",750,675,600]
[null,"saar",850,765,680]
[null,"tamm",1100,990,880]
[null,"vaher",950,855,760]
[]
[]
[]
[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"]