{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Tiitel","Sisukord","Palgid_ÜP","P_Variandid","Töötajad","P_hinnad"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tiitel","index":0,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,"Ülesanne 3"]
[]
[null,null,null,null,null,"Tabelid"]
[]
[null,null,null,null,null,"Lisada lahendustega praktikumi töövihik Tabelid_2_Andmeloendid.xlsm"]

{"sheet":"Sisukord","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sisukord"]
[]
[null,"Rakendus \"Puidu müük\". Ülesande püstitus"]
[null,"Puidu müük. Variandid"]
[null,"Töötajad. Üldine nimekiri"]
[null,"Rakendus \"Puidu müük\". Puidu hinnad"]

{"sheet":"Palgid_ÜP","index":2,"n_rows":1,"n_cols":6,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Variandid","Hinnad","Tööötajad"]

{"sheet":"P_Variandid","index":3,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,4,19,7],[20,4,20,7],[21,4,21,7],[23,4,23,7],[22,4,22,7]]}
[]
[null,null,"Puidu müük. Variandid"]
[null,null,null,"a -õppemärkmiku viimane number, b -eelviimane, c - a+b viimane number"]
[null,"Valdade valik",null,null,null,null,null,"Koondid"]
[]
[null,"c","Vald 1","Vald 2","Vald 3",null,"a","risttabel 1\nkogus ja maksumus ","SUMIF, \nkogus ja maksumus ","c","risttabel 2"]
[null,0,"Tori","Massiaru","Surju",null,0,"müüjate lõikes","kuupäevade lõikes",0,"maksumus liikide - müüjate lõikes"]
[null,1,"Abja","Asuja","Võiste",null,1,"kuupäevade lõikes","valdade lõikes",1,"maksumus kuupäevade - müüjate lõikes"]
[null,2,"Võiste","Kabli","Uulu",null,2,"sortide lõikes","sortide lõikes",2,"kogus küüpäevade -sortide lõikes"]
[null,3,"Uulu","Laiksaare","Abja",null,3,"valdade lõikes","liikide lõikes",3,"maksumus kuupäevade - valdade lõikes"]
[null,4,"Tali","Abja","Tori",null,4,"liikide lõikes","müüjate lõikes",4,"kogus sortide - valdade lõikes"]
[null,5,"Surju","Tori","Asuja",null,5,"liikide lõikes","kuupäevade lõikes",5,"maksumus sortide - müüjate lõikes"]
[null,6,"Massiaru","Surju","Tali",null,6,"sortide lõikes","valdade lõikes",6,"kogus liikide - müüjate lõikes"]
[null,7,"Laiksaare","Tali","Kabli",null,7,"valdade lõikes","sortide lõikes",7,"kogus kuupäede - liikide lõikes"]
[null,8,"Kabli","Uulu","Laiksaare",null,8,"müüjate lõikes","liikide lõikes",8,"kogus liikide - sortide lõikes"]
[null,9,"Asuja","Võiste","Massiaru",null,9,"kuupäevade lõikes","müüjate lõikes",9,"maksumus liikide - sortide lõikes"]
[]
[null,null,"ÕM nr.: "]
[]
[null,null,null,"Variant","Ülesanne"]
[null,null,"Vallad",{"$f":"IF(ISBLANK(matr_nr),\"\",RIGHT(RIGHT(matr_nr)+MID(matr_nr,LEN(matr_nr)-1,1)))","v":""},{"$f":"IF(ISBLANK(matr_nr),\"\",INDEX(C7:C16,D21+1)&\", \"&INDEX(D7:D16,D21+1)&\", \"&INDEX(E7:E16,D21+1))","v":""}]
[null,null,"Risttabel1",{"$f":"IF(ISBLANK(matr_nr),\"\",RIGHT(matr_nr))","v":""},{"$f":"IF(ISBLANK(matr_nr),\"\",\"Kogus ja maksumus \"&INDEX(H7:H16,D22+1))","v":""}]
[null,null,"Risttabel2",{"$f":"IF(ISBLANK(matr_nr),\"\",RIGHT(RIGHT(matr_nr)+MID(matr_nr,LEN(matr_nr)-1,1)))","v":""},{"$f":"IF(ISBLANK(matr_nr),\"\",INDEX(K7:K16,D23+1))","v":""}]
[null,null,"SumIf",{"$f":"IF(ISBLANK(matr_nr),\"\",RIGHT(matr_nr))","v":""},{"$f":"IF(ISBLANK(matr_nr),\"\",\"Kogus ja maksumus \"&INDEX(I7:I16,D24+1))","v":""}]

{"sheet":"Töötajad","index":4,"n_rows":75,"n_cols":6,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Töötajad"]
[]
[null,"Isikukood","Nimi","Vald","Palga aste","Telefon"]
[null,"44002110722","Hunt Aili","Kabli",12,"5413354"]
[null,"37110240441","Hunt Heino","Kabli",13,"5120371"]
[null,"47704250911","Ilves Annika","Laiksaare",6,"5057838"]
[null,"37302150417","Ilves Tom","Surju",3,"5491681"]
[null,36405130719,"Jänes Ahto","Uulu",7,"5538140"]
[null,"36605150941","Kaasik Reijo","Abja",4,"-"]
[null,"35404050446","Kadak Priit","Tali",12,"5774191"]
[null,"34103030178","Kana Kalju","Tori",9,"5167468"]
[null,"34708140585","Karu Karl","Uulu",4,"5265690"]
[null,48305030944,"Karu Salme","Tali",7,"5436197"]
[null,"46404170054","Kesa Katy","Tali",9,"5378397"]
[null,"44311270496","Kukk Krista","Laiksaare",4,"5349248"]
[null,"36110070151","Kuusik Kaivo","Võiste",8,"5213901"]
[null,"45711080030","Kuusk Maria","Tori",10,"5777718"]
[null,"38104220473","Känd Aare","Kabli",13,"5742433"]
[null,"34408020335","Marmor Aare","Tori",13,"-"]
[null,"34506190557","Meigas Reijo","Abja",7,"5172207"]
[null,"34112180084","Meister Anton","Surju",3,"5744042"]
[null,"35408240148","Merilaid Arnold","Asuja",9,"5056572"]
[null,"36203030988","Mets Kaivo","Asuja",5,"5410935"]
[null,"37303030624","Mikson Aarne","Abja",3,"5197749"]
[null,"48109130038","Miller Kersti","Laiksaare",9,"5086108"]
[null,"37003260243","Muld Reijo","Abja",11,"5319856"]
[null,"45903030319","Mäesalu Valve","Laiksaare",10,"5219908"]
[null,"34203130136","Mäger Karl","Surju",9,"5095125"]
[null,"48208230166","Mäger Tiina","Kabli",8,"5356094"]
[null,"37906080465","Mägi Kristjan","Võiste",5,"5344649"]
[null,"33904050217","Mänd Olav","Tori",7,"5555866"]
[null,"47110060467","Männik Elvi","Massiaru",11,"-"]
[null,"34404190222","Männik Erki","Võiste",6,"5015458"]
[null,"36709040675","Müller Tarmo","Tori",9,"5685829"]
[null,45104120460,"Müürsepp Raili","Asuja",13,"5010964"]
[null,"36512210549","Naaber Paul","Abja",15,"5168395"]
[null,"38303010526","Noormets Jaan","Kabli",9,"5041124"]
[null,"36406070555","Norak Aarne","Kabli",10,"5187660"]
[null,"38008200347","Norak Arnold","Võiste",13,"5755394"]
[null,"37708220891","Nõmmik Ando","Võiste",12,"5264197"]
[null,"35001130124","Oks Aarne","Surju",11,"5111918"]
[null,"45809140289","Oks Kristiina","Surju",8,"5064516"]
[null,"38206070961","Okspuu Reijo","Surju",4,"-"]
[null,"35302070214","Paju Ants","Massiaru",3,"5127657"]
[null,"38005180669","Pajusaar Hanno","Tali",9,"5472626"]
[null,"46709190988","Parre Selma","Asuja",2,"5096644"]
[null,"37612170754","Parts Eevald","Uulu",7,"5224148"]
[null,"37308230939","Paulus Madis","Tori",11,"5431825"]
[null,"38211130833","Petrov Meelis","Asuja",9,"5192173"]
[null,"47508150058","Piirsalu Irma","Võiste",13,"5185485"]
[null,"34204170615","Pulk Aadu","Asuja",7,"5194784"]
[null,"44801180808","Põder Mirja","Laiksaare",12,"5176495"]
[null,"45710100356","Põld Airi","Uulu",4,"5252053"]
[null,"45902200391","Põld Evelin","Kabli",9,"5045920"]
[null,"46307080393","Põldmaa Malle","Uulu",15,"5442057"]
[null,"47605040659","Raid Hilja","Laiksaare",14,"5428585"]
[null,"47111150090","Raja Tiina","Tali",9,"5176319"]
[null,"44012150956","Randla Aasa","Asuja",11,"5654344"]
[null,"46809210954","Rebane Helen","Uulu",3,"-"]
[null,"36110090988","Rebane Rein","Tali",7,"5514547"]
[null,"37111200348","Roos Margus","Massiaru",8,"5023543"]
[null,"38105090295","Saar Erki","Kabli",4,"5282149"]
[null,"34811280456","Salu Argo","Abja",8,"5465910"]
[null,"34810190405","Salu Karl","Uulu",5,"5552595"]
[null,"37105220288","Salu Kustav","Laiksaare",9,"5159337"]
[null,"37006180544","Salumets Erno","Võiste",11,"5493863"]
[null,"44607080463","Sarapik Evi","Tori",13,"5618468"]
[null,"46802240722","Siil Aigi","Tali",3,"5539093"]
[null,"48007150516","Sirel Kristel","Massiaru",7,"5775169"]
[null,"44601210234","Toomsalu Tiina","Massiaru",14,"5784941"]
[null,"35901050084","Tubin Ahti","Tali",12,"5113772"]
[null,"45209010485","Tubin Juulia","Massiaru",7,"5534903"]
[null,"35312110930","Vesi Kaspar","Abja",5,"5669191"]
[null,"36504060863","Väljas Arvi","Abja",10,"5396117"]

{"sheet":"P_hinnad","index":5,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,2,3,6]]}
[]
[]
[null,"Puidu hinnad"]
[null,null,"Sort"]
[]
[null,"Liik","1","2","3","4","5"]
[null,"kask",83,79,75,71,67]
[null,"lepp",78,74,70,66,62]
[null,"mänd",89,85,80,76,72]
[null,"saar",101,97,91,87,81]
[null,"kuusk",95,91,86,81,76]
[null,"tamm",131,124,118,112,105]
[null,"haab",59,57,53,51,48]
[null,"vaher",113,108,102,97,91]