{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["חשבונית מסחרית","לקוחות"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"חשבונית מסחרית","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,"רחוב השושנה 123","טלפון: 09-1234567","tailspin@interestingsite.com",null,null,"לקוחות"]
[{"$nulls":4},"נהריה, 12345","פקס: 09-1234568","www.tailspintoys.com"]
[]
[null,"כתובת לחיוב:","Lilli Allik","טלפון:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],8,FALSE),\"\")","v":"04-1234556"},null,"מס' חשבונית:",34567]
[null,"כתובת:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],3,FALSE),\"\")","v":"רחוב הדובדבן 345"},"פקס:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],10,FALSE),\"\")","v":"04-7654312"},null,"תאריך חשבונית:",{"$f":"TODAY()","v":"2022-12-14"}]
[null,null,{"$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":"דירה 123"},"דואר אלקטרוני:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"פרטי קשר:",{"$f":"IFERROR(VLOOKUP(BillName,CustomerList[],2,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":"עכו, ישראל 12345"}]
[null,"תאריך","מס' פריט","תיאור","כמות","מחיר ליחידה","הנחה","סה\"כ"]
[null,{"$f":"TODAY()","v":"2022-12-14"},789807,"קוביות עץ",4,{"v":10,"d":"₪ 10.00"},{"v":2,"d":"₪ 2.00"},{"$f":"IF(AND(InvoiceItems[[#This Row],[כמות]]<>\"\",InvoiceItems[[#This Row],[מחיר ליחידה]]<>\"\"),(InvoiceItems[[#This Row],[כמות]]*InvoiceItems[[#This Row],[מחיר ליחידה]])-InvoiceItems[[#This Row],[הנחה]],\"\")","v":{"v":38,"d":"₪ 38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[כמות]]<>\"\",InvoiceItems[[#This Row],[מחיר ליחידה]]<>\"\"),(InvoiceItems[[#This Row],[כמות]]*InvoiceItems[[#This Row],[מחיר ליחידה]])-InvoiceItems[[#This Row],[הנחה]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[כמות]]<>\"\",InvoiceItems[[#This Row],[מחיר ליחידה]]<>\"\"),(InvoiceItems[[#This Row],[כמות]]*InvoiceItems[[#This Row],[מחיר ליחידה]])-InvoiceItems[[#This Row],[הנחה]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[כמות]]<>\"\",InvoiceItems[[#This Row],[מחיר ליחידה]]<>\"\"),(InvoiceItems[[#This Row],[כמות]]*InvoiceItems[[#This Row],[מחיר ליחידה]])-InvoiceItems[[#This Row],[הנחה]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(InvoiceItems[[#This Row],[כמות]]<>\"\",InvoiceItems[[#This Row],[מחיר ליחידה]]<>\"\"),(InvoiceItems[[#This Row],[כמות]]*InvoiceItems[[#This Row],[מחיר ליחידה]])-InvoiceItems[[#This Row],[הנחה]],\"\")","v":""}]
[{"$nulls":6},"סכום ביניים של החשבונית",{"$f":"SUM(InvoiceItems[סה\"כ])","v":{"v":38,"d":"₪ 38.00"}}]
[{"$nulls":6},"שיעור מס",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"מס מכירות",{"$f":"InvoiceSubtotal*SalesTaxRate","v":{"v":3.3819999999999997,"d":"₪ 3.38"}}]
[{"$nulls":6},"משלוח",{"v":5,"d":"₪ 5.00"}]
[null,{"$f":"\"יש לרשום את כל השיקים לפקודת \"&UPPER(CompanyName)&\".\"","v":"יש לרשום את כל השיקים לפקודת TAILSPIN TOYS."},{"$nulls":4},"מקדמה שהתקבלה",{"v":0,"d":"₪ 0.00"}]
[null,"לרשותכם 10 ימים לתשלום הסכום הכולל. חשבונות שלא עמדו בתאריך היעד כפופים לחיוב ריבית של 2% בכל חודש.",{"$nulls":4},"סה\"כ",{"$f":"InvoiceSubtotal+SalesTax+משלוח-מקדמה","v":{"v":46.382,"d":"₪ 46.38"}}]

{"sheet":"לקוחות","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"לקוחות",{"$nulls":10},"חשבונית מסחרית"]
[null,"שם החברה","פרטי קשר","כתובת","כתובת 2","עיר","מדינה","מיקוד","טלפון","דואר אלקטרוני","פקס"]
[null,"Lilli Allik","מיקי גלובר","רחוב הדובדבן 345","דירה 123","עכו","ישראל",12345,"04-1234556","mike@excellentwebsite.com","04-7654312"]
[null,"Contoso, Ltd","נויה שטיינברג","סמטת אגוז 567",null,"טבריה","ישראל","09876","04-2345678","contoso@websitegoeshere.com","04-2345679"]