{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Service Invoice","Накладная ","Customers","Products","формулы "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":18,"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":"Service Invoice","index":0,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[41,1,41,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[0,1,1,7],[7,6,9,7],[6,6,6,7],[3,2,5,2],[3,3,5,5],[2,1,2,5],[25,4,25,6]]}
[]
[]
[null,"              \n                                                                               \n",null,null,null,null," ARVENUMBER:  ","XXX2020-09-040",null,"Customers"]
[null,null,null,null,null,null,"ARVE KUUPÄEV:",{"$f":"TODAY()+1","v":"2020-09-26"}]
[null,null,null,null,null,null,"MAKSE KUUPÄEV:",{"$f":"H6-H4","v":14}]
[null,null,null,null,null,null,"MAKSETÄHTAEG:",{"$f":"TODAY()+15","v":"2020-10-10"}]
[null,"ARVE SAAJA:","STOCKMANN AS","REG.KOOD:",{"$f":"VLOOKUP(BillName,CustomerList[],8,FALSE)","v":10005122},null,"TELLIMUS NR.:  "]
[null,"KMKR:",{"$f":"VLOOKUP(BillName,CustomerList[],3,FALSE)","v":"EE100255690"},"TEL:",{"$f":"VLOOKUP(BillName,CustomerList[],10,FALSE)","v":123456},null,{"$f":"VLOOKUP(BillName,CustomerList[],11,FALSE)","v":"xxxxx"}]
[null,"ADDRESS:",{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)<>\"\",VLOOKUP(BillName,CustomerList[],4,FALSE),IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"Liivalaia 53"},"E-MAIL:",{"$f":"VLOOKUP(BillName,CustomerList[],9,FALSE)","v":"xxx@xxx.xx"}]
[null,null,{"$f":"IF(VLOOKUP(BillName,CustomerList[],4,FALSE)=\"\",\"\",IF(VLOOKUP(BillName,CustomerList[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(BillName,CustomerList[],5,FALSE),\", \",VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE)),CONCATENATE(VLOOKUP(BillName,CustomerList[],6,FALSE),\" \",VLOOKUP(BillName,CustomerList[],7,FALSE))))","v":"Tallinn, Estonia, Harjumaa 10145"},"KONTAKT:",{"$f":"VLOOKUP(BillName,CustomerList[],2,FALSE)","v":"Галина"}]
[null,"NR.","продукт","цена","количество","Column1","срок годности","стоимость"]
[null,1,"ТОВАР 6",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B1:E51,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B1:E51,2,0))","v":0.77},5,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D29,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D29,3,0))","v":"25/11/2020"},{"$f":"SUM(InvoiceItems[[#This Row],[цена]]*InvoiceItems[[#This Row],[количество]])","v":3.85}]
[null,2,"ТОВАР 7",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B1:E51,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B1:E51,2,0))","v":1.6},5,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D30,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D30,3,0))","v":"03.12.2020"},{"$f":"SUM(InvoiceItems[[#This Row],[цена]]*InvoiceItems[[#This Row],[количество]])","v":8}]
[null,3,"ТОВАР 8",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B2:E52,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B2:E52,2,0))","v":1.6},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D32,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D32,3,0))","v":"27.11.2020"},{"$f":"SUM(InvoiceItems[[#This Row],[цена]]*InvoiceItems[[#This Row],[количество]])","v":0}]
[null,4,"ТОВАР 10",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:E53,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:E53,2,0))","v":1.6},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D34,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D34,3,0))","v":"03.12.2020"},{"$f":"SUM(InvoiceItems[[#This Row],[цена]]*InvoiceItems[[#This Row],[количество]])","v":0}]
[null,5,"ТОВАР 10",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B4:E54,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B4:E54,2,0))","v":1.6},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D53,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B3:D53,3,0))","v":"03.12.2020"},{"$f":"SUM(InvoiceItems[[#This Row],[цена]]*InvoiceItems[[#This Row],[количество]])","v":0}]
[null,6,"ТОВАР 11",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B5:E55,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B5:E55,2,0))","v":1.6},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B4:D54,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B4:D54,3,0))","v":"12.12.2020"}]
[null,7,"ТОВАР 12",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B6:E56,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B6:E56,2,0))","v":1.6},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B9:D56,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B9:D56,3,0))","v":"12.12.2020"}]
[null,8,"4750133111192 DRAUGU Happukoor - sibul  100g",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B7:E57,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B7:E57,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B10:D57,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B10:D57,3,0))","v":""}]
[null,9,"4627129932317 MAGUSAINETE SEGU ERÜTRITOOL+PILLIROOG",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B8:E58,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B8:E58,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B11:D58,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B11:D58,3,0))","v":""}]
[null,10,"ТОВАР 29",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B9:E59,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B9:E59,2,0))","v":5},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B12:D59,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[продукт]],Products!B12:D59,3,0))","v":0}]
[]
[null,"S - soodus"]
[null,"A - asendamine"]
[null,null,null,null,null,null,"Summa käibemaksuta",{"$f":"SUM(InvoiceItems[стоимость])","v":11.85}]
[null,null,null,null,"Käibemaksu summa (20%)",null,null,{"$f":"InvoiceSubtotal*0.2","v":2.37}]
[null,null,null,null,null,null,"Summa kokku",{"$f":"InvoiceSubtotal*0.2+InvoiceSubtotal","v":14.219999999999999}]
[]
[null,null,null,null,null,null,"Tasumisele kuulib:",{"$f":"InvoiceSubtotal*0.2+InvoiceSubtotal","v":14.219999999999999}]
[null,null,null,null,null,null,"!Täname õigeaegselt tasutud arve eest!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Võttis vastu:",null,null,null,null,null,"Arve koostas:"]
[]
[null,"Perekonnanimi",null,null,null,null,null,"Juhatuseliige   "]
[null,{"$f":"H4","v":"2020-09-26"},null,null,null,null,null,{"$f":"H4","v":"2020-09-26"}]
[null,"kuupäev",null,null,null,null,null,"kuupäev"]
[]
[]
[]
[null,null,"allkiri",null,null,null,null,"allkiri"]

{"sheet":"Накладная ","index":1,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,0,1,4],[27,0,27,1],[26,0,26,1],[24,0,24,1]]}
[]
["ARVE SAATELEHT"]
["ЧЧЧ",{"$f":"'Service Invoice'!H3","v":"XXX2020-09-040"}]
[]
["Saaja:",{"$f":"VLOOKUP(BillName,CustomerList[],11,FALSE)","v":"xxxxx"}]
["Tel:",{"$f":"VLOOKUP(BillName,CustomerList[],10,FALSE)","v":123456}]
["Kontakt: ",{"$f":"VLOOKUP(BillName,CustomerList[],2,FALSE)","v":"Галина"}]
[]
[]
[]
["NR.","KAUBA NIMETUS","TK","S / A","PARIM ENNE"]
[{"$f":"InvoiceItems[[#This Row],[NR.]]","v":1},{"$f":"'Service Invoice'!C12","v":"ТОВАР 6"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":5},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"25/11/2020"}]
[2,{"$f":"'Service Invoice'!C13","v":"ТОВАР 7"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":5},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"03.12.2020"}]
[3,{"$f":"'Service Invoice'!C14","v":"ТОВАР 8"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"27.11.2020"}]
[4,{"$f":"'Service Invoice'!C15","v":"ТОВАР 10"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"03.12.2020"}]
[5,{"$f":"'Service Invoice'!C16","v":"ТОВАР 10"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"03.12.2020"}]
[6,{"$f":"'Service Invoice'!C17","v":"ТОВАР 11"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"12.12.2020"}]
[7,{"$f":"'Service Invoice'!C18","v":"ТОВАР 12"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":"12.12.2020"}]
[8,{"$f":"'Service Invoice'!C19","v":"4750133111192 DRAUGU Happukoor - sibul  100g"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":""}]
[9,{"$f":"'Service Invoice'!C20","v":"4627129932317 MAGUSAINETE SEGU ERÜTRITOOL+PILLIROOG"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":""}]
[10,{"$f":"'Service Invoice'!C21","v":"ТОВАР 29"},{"$f":"InvoiceItems[[#This Row],[количество]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[срок годности]]","v":0}]
[]
["S - soodus"]
["A - asendamine"]
["Võttis vastu:"]
[]
["Perekonnanimi"]
[{"$f":"'Service Invoice'!H4","v":"2020-09-26"}]
["kuupäev"]
[]
[]
[]
["allkiri"]

{"sheet":"Customers","index":2,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Customers",null,null,null,null,null,null,null,null,null,null,"Service Invoice"]
[null,"Company Name","Contact Name","KMKR","Address 2","City","State","ZIP Code","REG:","Email","Tel:","BILL"]
[null,"STOCKMANN AS","Галина","EE100255690","Liivalaia 53","Tallinn, Estonia","Harjumaa",10145,10005122,"xxx@xxx.xx",123456,"xxxxx"]

{"sheet":"Products","index":3,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Products",null,null,"Service Invoice"]
[null,"Product Name","Price","Column1","Column2"]
[null,"                                      Kabanos"]
[null,"ТОВАР 1",1.1000000000000001,"05/12/2020"]
[null,"ТОВАР 2",1.1000000000000001,"26/11/2020"]
[null,"ТОВАР 3",1.1000000000000001,"15/11/2020"]
[null,"ТОВАР 4",1.1000000000000001,"26/11/2020"]
[null,"ТОВАР 5",1.1000000000000001,"21/11/2020"]
[null,"ТОВАР 6",0.77,"25/11/2020"]
[null,"                                       Krippu"]
[null,"ТОВАР 7",1.6,"03.12.2020"]
[null,"ТОВАР 8",1.6,"27.11.2020"]
[null,"ТОВАР 9",1.6,"29.11.2020"]
[null,"ТОВАР 10",1.6,"03.12.2020"]
[null,"ТОВАР 11",1.6,"12.12.2020"]
[null,"ТОВАР 12",1.6,"12.12.2020"]
[null,"                                       Draugu"]
[null,"ТОВАР 13",0.85,"13.03.2020"]
[null,"ТОВАР 14",0.85,"15.03.2020"]
[null,"ТОВАР 15",0.85,"28.04.2020"]
[null,"ТОВАР 16",0.85,"15.05.2020"]
[null,"ТОВАР 17",0.85,"25.06.2020"]
[null,"ТОВАР 18",0.7,"30.07.2020"]
[null,"ТОВАР 19"]
[null,"ТОВАР 20",1.1100000000000001,"15.04.2020"]
[null,"ТОВАР 21",1.1200000000000001,"16.04.2020"]
[null,"ТОВАР 22",0.7,"01.11.2020"]
[null,"ТОВАР 23",0.84,"02.11.2020"]
[null,"ТОВАР 24",0.7,"30.04.2020"]
[null,"ТОВАР 25",0.77,"05.11.2020"]
[null,"ТОВАР 26",0.77,"06.11.2020"]
[null,"ТОВАР 27",0.98,"21.09.2020",0.98]
[null,"ТОВАР 28",5]
[null,"ТОВАР 29",5]
[null,"ТОВАР 30",5]

{"sheet":"формулы ","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["срок годности","\"=IF(ISNA(VLOOKUP([@[KAUBA NIMETUS]],Products!B2:D13,3,0)),\"\",VLOOKUP([@[KAUBA NIMETUS]],Products!B2:D13,3,0))\""]
["сумма","\"=SUM([@[            ÜHIKU HIND]]*[@[MAHT / KOGUS]])\""]
["название магазина","\"=VLOOKUP(BillName,CustomerList,11,FALSE)\""]
["цена","\"=IF(ISNA(VLOOKUP([@[KAUBA NIMETUS]],Products!B4:E15,4,0)),\"\",VLOOKUP([@[KAUBA NIMETUS]],Products!B4:E15,4,0))\""]
[null,"\"=IF(ISNA(InvoiceItems[@Column1]),\",InvoiceItems[@Column1])\""]