{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Register","CUSTOMERS","Link"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":"Register","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,3,1,3]]}
[null,null,null,"اللوحة الرئيسية"]
[]
[]
[null,"Invoice #","Date","Customers","Invoice Total","INDEX"]
[null,null,null,null,null,"CUSTOMERS"]
[null,null,null,null,null,"Link"]

{"sheet":"CUSTOMERS","index":1,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,2,1,2]]}
[null,null,"Customer Information"]
[]
[]
["customer","Governorate","Address","Address 2","State","Phone","Email"]

{"sheet":"Link","index":2,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,1,50,14],[51,1,51,14],[42,10,42,14],[7,5,7,14],[40,10,40,14],[41,10,41,14],[33,2,33,7],[31,2,31,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[41,1,41,2],[43,1,43,2],[42,4,44,7],[41,4,41,7],[49,1,49,14],[5,2,5,4],[7,2,7,4],[8,2,8,4],[20,2,20,7],[18,8,18,14],[12,3,12,6],[12,7,12,8],[12,9,12,14],[12,1,12,2],[14,3,14,6],[19,2,19,7],[18,2,18,7],[8,5,8,14],[2,7,6,9],[2,11,3,13],[16,1,16,2],[6,2,6,4],[16,3,16,6],[36,8,36,9],[37,8,37,9],[22,2,22,7],[24,2,24,7],[21,2,21,7],[23,2,23,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[14,9,14,14],[14,7,14,8],[14,1,14,2],[32,2,32,7]]}
[]
[null,"رقم الفاتورة :",0]
[]
[null,"تاريخ الفاتورة :"]
[]
[null,"العنوان :"]
[]
[null,"البريد الالكتروني :"]
[null,"تليفون :","07900000000",null,null,"Sales Order"]
[]
[]
[]
[null,"customer",null,"0",null,null,null,"Governorate",null,{"$f":"VLOOKUP(BILLNAME,CustomerList[],2,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,"البريد الالكتروني :",null,{"$f":"VLOOKUP(BILLNAME,CustomerList[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,"تليفون :",null,{"$f":"VLOOKUP(BILLNAME,CustomerList[],6,)","v":{"$error":"#N/A"}}]
[]
[null,"Address",null,{"$f":"VLOOKUP(BILLNAME,CustomerList[],3,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"DESCRIPTION",null,null,null,null,null,"PAYMENT DETAILS"]
[null,"NO","التفاصيل",null,null,null,null,null,"Qty","Unit price","Amount","بونص","مرتجع","Discount","المجموع"]
[null,1,null,null,null,null,null,null,null,{"$f":"IF(C21=AC$23,AB$23,0+IF(C21=AC$24,AB$24, 0+IF(C21=AC$25,AB$25, 0+IF(C21=AC$26,AB$26, 0+IF(C21=AC$27,AB$27, 0+IF(C21=AC$28,AB$28, 0))))))","v":0},{"$f":"I21*J21","v":0},null,null,null,{"$f":"(K21*(100-(N21*100))/100)-(M21*J21*(100-(N21*100))/100)","v":0}]
[null,2,null,null,null,null,null,null,null,{"$f":"IF(C22=AC$23,AB$23,0+IF(C22=AC$24,AB$24, 0+IF(C22=AC$25,AB$25, 0+IF(C22=AC$26,AB$26, 0+IF(C22=AC$27,AB$27, 0+IF(C22=AC$28,AB$28, 0))))))","v":0},{"$f":"I22*J22","v":0},null,null,null,{"$f":"(K22*(100-(N22*100))/100)-(M22*J22*(100-(N22*100))/100)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"price","product"]
[null,3,null,null,null,null,null,null,null,{"$f":"IF(C23=AC$23,AB$23,0+IF(C23=AC$24,AB$24, 0+IF(C23=AC$25,AB$25, 0+IF(C23=AC$26,AB$26, 0+IF(C23=AC$27,AB$27, 0+IF(C23=AC$28,AB$28, 0))))))","v":0},0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,1,"a"]
[null,4,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,2,"b"]
[null,5,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,3,"c"]
[null,6,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,4,"d"]
[null,7,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,5,"f"]
[null,8,null,null,null,null,null,null,null,0,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,6,"k"]
[null,9,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,10,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,9,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,10,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,9,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,10,null,null,null,null,null,null,null,0,0,null,null,null,0]
[null,null,null,null,null,null,null,"مجموع العدد",{"$f":"SUM(I21:I34)","v":0},"المبلغ الكلي",null,null,null,null,{"$f":"SUM(O21:O27)","v":0}]
[]
[null,null,null,null,null,null,null,null,"العربون",null,null,null,null,null,"0"]
[null,null,null,null,null,null,null,null,"المبلغ الأجمالي",null,null,null,null,null,{"$f":"O35-O37","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"OTHER COMMENTS"]
[null,"الاعتماد",null,null,"الختم",null,null,null,null,null,"1. Total payment due in 30 days"]
[null,null,null,null,null,null,null,null,null,null,"2. Please include the invoice number on your check"]
[null,"........................................"]
[null,null,null,null,null,null,null,null,null,null,null,"توقيع البائع"]
[null,null,null,null,null,null,null,null,null,null,null,"........................."]
[]
[]
[]
[null,"If you have any questions about this invoice, please contact"]
[null,"[ Mob: 01062615954 , E.Mail: Dampharm1@gmail.com ]"]
[null,"Thank You"]