{"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,"       ARVE:     ","2020/08/046",null,"Customers"]
[null,null,"                     ",null,null,null,"ARVE KUUPÄEV:",{"$f":"TODAY()","v":"2020-08-29"}]
[null,null,null,null,null,null,"MAKSE KUUPÄEV:",{"$f":"H6-H4","v":29}]
[null,null,null,null,null,null,"MAKSETÄHTAEG:",{"$f":"TODAY()+29","v":"2020-09-27"}]
[null,"ARVE SAAJA:","Булочная","REG.KOOD:",{"$f":"VLOOKUP(BillName,CustomerList[],8,FALSE)","v":"ЕЕ1234566"},null,"TELLIMUS NR.:  "]
[null,"KMKR:",{"$f":"VLOOKUP(BillName,CustomerList[],3,FALSE)","v":"ИНН123456"},"TEL:",{"$f":"VLOOKUP(BillName,CustomerList[],10,FALSE)","v":123456},null,{"$f":"VLOOKUP(BillName,CustomerList[],11,FALSE)","v":"БУЛОЧНАЯ"}]
[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":"Улица"},"E-MAIL:",{"$f":"VLOOKUP(BillName,CustomerList[],9,FALSE)","v":"инфо@инфо.ру"}]
[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":"Город,  123456"},"KONTAKT:",{"$f":"VLOOKUP(BillName,CustomerList[],2,FALSE)","v":"Маша"}]
[null,"NR.","KAUBA NIMETUS","            ÜHIKU HIND","MAHT / KOGUS","Column1","PARIM ENNE","MAKSUMUS KM-TA"]
[null,1,"123456789987 Булка и маком 100 g",{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E48,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E48,2,0))","v":1.1000000000000001},15,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D28,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D28,3,0))","v":"17/06/2020"},{"$f":"SUM(InvoiceItems[[#This Row],[MAHT / KOGUS]]*InvoiceItems[[#This Row],[            ÜHIKU HIND]])","v":16.5}]
[null,2,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E49,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E49,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D29,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D29,3,0))","v":""}]
[null,3,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E50,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E50,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D31,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D31,3,0))","v":""}]
[null,4,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E51,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E51,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D32,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D32,3,0))","v":""}]
[null,5,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:E52,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:E52,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D51,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:D51,3,0))","v":""}]
[null,6,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B5:E53,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B5:E53,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:D52,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:D52,3,0))","v":""}]
[null,7,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B6:E54,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B6:E54,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B9:D54,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B9:D54,3,0))","v":""}]
[null,8,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E55,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B3:E55,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B10:D55,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B10:D55,3,0))","v":""}]
[null,9,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:E56,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B4:E56,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B11:D56,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B11:D56,3,0))","v":""}]
[null,10,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B5:E57,2,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B5:E57,2,0))","v":""},null,null,{"$f":"IF(ISNA(VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B12:D57,3,0)),\"\",VLOOKUP(InvoiceItems[[#This Row],[KAUBA NIMETUS]],Products!B12:D57,3,0))","v":""}]
[]
[null,"S - soodus"]
[null,"A - asendamine"]
[null,null,null,null,null,null,"Summa käibemaksuta",{"$f":"SUM(InvoiceItems[MAKSUMUS KM-TA])","v":16.5}]
[null,null,null,null,"Käibemaksu summa (20%)",null,null,{"$f":"InvoiceSubtotal*0.2","v":3.3000000000000003}]
[null,null,null,null,null,null,"Summa kokku",{"$f":"InvoiceSubtotal*0.2+InvoiceSubtotal","v":19.8}]
[]
[null,null,null,null,null,null,"Tasumisele kuulib:",{"$f":"InvoiceSubtotal*0.2+InvoiceSubtotal","v":19.8}]
[null,null,null,null,null,null,"!Täname õigeaegselt tasutud arve eest!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Võttis vastu:",null,null,null,null,null,"Arve koostas:"]
[null,null,null,null,null,null,null,"Андрей"]
[null,"Perekonnanimi",null,null,null,null,null,"Juhatuseliige   "]
[null,{"$f":"H4","v":"2020-08-29"},null,null,null,null,null,{"$f":"H4","v":"2020-08-29"}]
[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"]
[null,{"$f":"'Service Invoice'!H3","v":"2020/08/046"}]
[]
["Saaja:",{"$f":"VLOOKUP(BillName,CustomerList[],11,FALSE)","v":"БУЛОЧНАЯ"}]
["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":"123456789987 Булка и маком 100 g"},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":15},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":"17/06/2020"}]
[2,{"$f":"'Service Invoice'!C13","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[3,{"$f":"'Service Invoice'!C14","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[4,{"$f":"'Service Invoice'!C15","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[5,{"$f":"'Service Invoice'!C16","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[6,{"$f":"'Service Invoice'!C17","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[7,{"$f":"'Service Invoice'!C18","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[8,{"$f":"'Service Invoice'!C19","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[9,{"$f":"'Service Invoice'!C20","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[10,{"$f":"'Service Invoice'!C21","v":0},{"$f":"InvoiceItems[[#This Row],[MAHT / KOGUS]]","v":0},{"$f":"InvoiceItems[[#This Row],[Column1]]","v":0},{"$f":"InvoiceItems[[#This Row],[PARIM ENNE]]","v":""}]
[]
["S - soodus"]
["A - asendamine"]
["Võttis vastu:"]
[]
["Perekonnanimi"]
[{"$f":"'Service Invoice'!H4","v":"2020-08-29"}]
["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,"Булочная","Маша","ИНН123456","Улица","Город",null,123456,"ЕЕ1234566","инфо@инфо.ру",123456,"БУЛОЧНАЯ"]

{"sheet":"Products","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Products",null,null,"Service Invoice"]
[null,"Product Name","Price","Column1","Column2"]
[null,"                                      Kabanos"]
[null,"123456789987 Булка и маком 100 g",1.1000000000000001,"17/06/2020",0.65]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,0.98]

{"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])\""]