{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Laovarude loend","Kauba komplekteerimis loend","Aluse otsing"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"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":"Laovarude loend","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"LAOVARUDE LOEND"]
[null,"KAUBA KOGUVÄÄRTUS:","KAUPU:","ALUSEID:","KAUBA KOMPLEKTEERIMIS LOEND","ALUSE OTSING"]
[null,{"$f":"SUM(Kaubaloend[KAUBA VÄÄRTUS])","v":4649},{"$f":"COUNTA(Kaubaloend[KIRJELDUS])","v":11},{"$f":"SUMPRODUCT((1/COUNTIF(Kaubaloend[ALUSE NR],Kaubaloend[ALUSE NR]&\"\")))","v":6}]
[null,"SKU","KIRJELDUS","ALUSE NR","ASUKOHT","ÜHIK","KOGUS","JUURDETELLIM. KOGUS","HIND","KAUBA VÄÄRTUS","JUURDETELLIMINE"]
[null,"SP7875","Kaup 1","T345",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"2. rida, 1. vahe"},"Tükk",20,10,30,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":600},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"TR87680","Kaup 2","T345",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"2. rida, 1. vahe"},"Tükk",30,15,40,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":1200},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"MK676554","Kaup 3","T5789",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"1. rida, 1. vahe"},"Tükk",10,5,5,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":50},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"YE98767","Kaup 4","T9876",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"3. rida, 2. vahe"},"Karp (10 tk)",40,10,15,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":600},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"XR23423","Kaup 5","T098",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"3. rida, 1. vahe"},"Tükk",12,10,26,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":312},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"PW98762","Kaup 6","T345",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"2. rida, 1. vahe"},"Tükk",7,10,50,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":350},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":1}]
[null,"BM87684","Kaup 7","T349",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"1. rida, 2. vahe"},"Tükk",10,5,10,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":100},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"BH67655","Kaup 8","T5789",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"1. rida, 1. vahe"},"Tükk",19,10,3,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":57},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"WT98768","Kaup 9","T9875",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"2. rida, 2. vahe"},"Pakk (5 tk)",20,30,14,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":280},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":1}]
[null,"TS3456","Kaup 10","T349",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"1. rida, 2. vahe"},"Tükk",15,8,60,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":900},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]
[null,"WDG123","Kaup 11","T349",{"$f":"IFERROR(VLOOKUP(Kaubaloend[[#This Row],[ALUSE NR]],AluseOtsing[],3,FALSE),\"\")","v":"1. rida, 2. vahe"},"Tükk",25,15,8,{"$f":"Kaubaloend[[#This Row],[KOGUS]]*Kaubaloend[[#This Row],[HIND]]","v":200},{"$f":"IFERROR(IF(Kaubaloend[[#This Row],[KOGUS]]<=Kaubaloend[[#This Row],[JUURDETELLIM. KOGUS]],1,0),0)","v":0}]

{"sheet":"Kauba komplekteerimis loend","index":1,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"LAOVARUDE LOEND"]
[null,null,"KAUBALOEND"]
[]
[null,"TELLIMUSE NR","SKU","KOMPL. KOGUS","SAADAV KOGUS","KAUBA KIRJELDUS","ÜHIK","ALUSE NR","ASUKOHT"]
[null,"TP001-1","SP7875",3,{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],6,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],2,FALSE),\"\")","v":"Kaup 1"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],5,FALSE),\"\")","v":"Tükk"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],4,FALSE),\"\")","v":"2. rida, 1. vahe"}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],6,FALSE),\"\")","v":40},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],2,FALSE),\"\")","v":"Kaup 4"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],5,FALSE),\"\")","v":"Karp (10 tk)"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],4,FALSE),\"\")","v":"3. rida, 2. vahe"}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],2,FALSE),\"\")","v":"Kaup 7"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],5,FALSE),\"\")","v":"Tükk"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],4,FALSE),\"\")","v":"1. rida, 2. vahe"}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],2,FALSE),\"\")","v":"Kaup 10"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],5,FALSE),\"\")","v":"Tükk"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],4,FALSE),\"\")","v":"1. rida, 2. vahe"}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],2,FALSE),\"\")","v":"Kaup 3"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],5,FALSE),\"\")","v":"Tükk"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],3,FALSE),\"\")","v":"T5789"},{"$f":"IFERROR(VLOOKUP(KaubaKomplekteerimisloend[SKU],Kaubaloend[],4,FALSE),\"\")","v":"1. rida, 1. vahe"}]

{"sheet":"Aluse otsing","index":2,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"ALUSE OTSING"]
[null,"KAUBALOEND"]
[]
[null,"ALUSE NR","KIRJELDUS","ASUKOHT","LAIUS","KÕRGUS","PIKKUS"]
[null,"T345","Suur alus","2. rida, 1. vahe",50,10,10]
[null,"T5789","Väike alus","1. rida, 1. vahe",25,5,5]
[null,"T9876","Suur alus","3. rida, 2. vahe",50,10,10]
[null,"T098","Keskmine alus","3. rida, 1. vahe",30,7,10]
[null,"T349","Väike alus","1. rida, 2. vahe",25,5,5]
[null,"T5789","Suur alus","4. rida, 5. vahe",50,10,10]
[null,"T9875","Suur alus","2. rida, 2. vahe",50,10,10]