{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Kaubaarve","Kliendid"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Kaubaarve","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"Jõhvika 123","T: 123 555 0123","tailspin@interestingsite.com",null,null,"Kliendid"]
[{"$nulls":4},"12345 Kernu","F: 54320124","www.tailspintoys.com"]
[]
[null,"Arve saaja:","Lilli Allik","Telefoninumber:",{"$f":"IFERROR(VLOOKUP(ArvesaajaNimi,KliendiLoend[],8,FALSE),\"\")","v":"+372 111 1111"},null,"Arve nr:",34567]
[null,"Aadress:",{"$f":"IFERROR(VLOOKUP(ArvesaajaNimi,KliendiLoend[],3,FALSE),\"\")","v":"Kaldaserva 6"},"Faks:",{"$f":"IFERROR(VLOOKUP(ArvesaajaNimi,KliendiLoend[],10,FALSE),\"\")","v":"372 333 3333"},null,"Arve kuupäev:",{"$f":"TODAY()","v":"2022-12-13"}]
[null,null,{"$f":"IF(VLOOKUP(ArvesaajaNimi,KliendiLoend[],4,FALSE)<>\"\",VLOOKUP(ArvesaajaNimi,KliendiLoend[],4,FALSE),IF(VLOOKUP(ArvesaajaNimi,KliendiLoend[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(ArvesaajaNimi,KliendiLoend[],5,FALSE),\", \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],6,FALSE),\" \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],7,FALSE)),CONCATENATE(VLOOKUP(ArvesaajaNimi,KliendiLoend[],6,FALSE),\" \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],7,FALSE))))","v":"Tuba 123"},"Meiliaadress:",{"$f":"IFERROR(VLOOKUP(ArvesaajaNimi,KliendiLoend[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"Kontaktteave:",{"$f":"IFERROR(VLOOKUP(ArvesaajaNimi,KliendiLoend[],2,FALSE),\"\")","v":"Peep Vaher"}]
[null,null,{"$f":"IF(VLOOKUP(ArvesaajaNimi,KliendiLoend[],4,FALSE)=\"\",\"\",IF(VLOOKUP(ArvesaajaNimi,KliendiLoend[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(ArvesaajaNimi,KliendiLoend[],5,FALSE),\", \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],6,FALSE),\" \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],7,FALSE)),CONCATENATE(VLOOKUP(ArvesaajaNimi,KliendiLoend[],6,FALSE),\" \",VLOOKUP(ArvesaajaNimi,KliendiLoend[],7,FALSE))))","v":"Viljandi, Viljandimaa 12345"}]
[null,"KUUPÄEV","ÜKSUSE NR","KIRJELDUS","KOGUS","ÜHIKU HIND","ALLAHINDLUS","KOKKU"]
[null,{"$f":"TODAY()","v":"2022-12-13"},789807,"Puitklotsid",4,{"v":10,"d":"10.00 €"},{"v":2,"d":"2.00 €"},{"$f":"IF(AND(Arveüksused[[#This Row],[KOGUS]]<>\"\",Arveüksused[[#This Row],[ÜHIKU HIND]]<>\"\"),(Arveüksused[[#This Row],[KOGUS]]*Arveüksused[[#This Row],[ÜHIKU HIND]])-Arveüksused[[#This Row],[ALLAHINDLUS]],\"\")","v":{"v":38,"d":"38.00 €"}}]
[{"$nulls":7},{"$f":"IF(AND(Arveüksused[[#This Row],[KOGUS]]<>\"\",Arveüksused[[#This Row],[ÜHIKU HIND]]<>\"\"),(Arveüksused[[#This Row],[KOGUS]]*Arveüksused[[#This Row],[ÜHIKU HIND]])-Arveüksused[[#This Row],[ALLAHINDLUS]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Arveüksused[[#This Row],[KOGUS]]<>\"\",Arveüksused[[#This Row],[ÜHIKU HIND]]<>\"\"),(Arveüksused[[#This Row],[KOGUS]]*Arveüksused[[#This Row],[ÜHIKU HIND]])-Arveüksused[[#This Row],[ALLAHINDLUS]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Arveüksused[[#This Row],[KOGUS]]<>\"\",Arveüksused[[#This Row],[ÜHIKU HIND]]<>\"\"),(Arveüksused[[#This Row],[KOGUS]]*Arveüksused[[#This Row],[ÜHIKU HIND]])-Arveüksused[[#This Row],[ALLAHINDLUS]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Arveüksused[[#This Row],[KOGUS]]<>\"\",Arveüksused[[#This Row],[ÜHIKU HIND]]<>\"\"),(Arveüksused[[#This Row],[KOGUS]]*Arveüksused[[#This Row],[ÜHIKU HIND]])-Arveüksused[[#This Row],[ALLAHINDLUS]],\"\")","v":""}]
[{"$nulls":6},"Arve vahesumma",{"$f":"SUM(Arveüksused[KOKKU])","v":{"v":38,"d":"38.00 €"}}]
[{"$nulls":6},"Maksumäär",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"Käibemaks",{"$f":"ArveVahesumma*Käibemaksumäär","v":{"v":3.3819999999999997,"d":"3.38 €"}}]
[{"$nulls":6},"Saatekulud",{"v":5,"d":"5.00 €"}]
[null,{"$f":"\"Tšeki alusel makstakse raha ettevõttele \"&UPPER(EttevõtteNimi)&\".\"","v":"Tšeki alusel makstakse raha ettevõttele TAILSPIN TOYS."},{"$nulls":4},"Saadud ettemaks",{"v":0,"d":"0.00 €"}]
[null,"Maksetähtaeg on 10 päeva. Tasumata maksetelt võetakse viiviseintressi 2% kuus.",{"$nulls":4},"Kokku",{"$f":"ArveVahesumma+Käibemaks+Saatekulud-Ettemaks","v":{"v":46.382,"d":"46.38 €"}}]

{"sheet":"Kliendid","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"KLIENDID",{"$nulls":10},"Kaubaarve"]
[null,"ETTEVÕTTE NIMI","KONTAKTTEAVE","AADRESS","AADRESS2","LINN","MAAKOND","SIHTNUMBER","TELEFON","MEILIAADRESS","FAKS"]
[null,"Lilli Allik","Peep Vaher","Kaldaserva 6","Tuba 123","Viljandi","Viljandimaa",12345,"+372 111 1111","mike@excellentwebsite.com","372 333 3333"]
[null,"AS Vetevalla","Aino Rebane","Kiigepuu tee 1",null,"Pärnu","Pärnumaa","12345","+372 222 2222","contoso@websitegoeshere.com","372 444 4444"]