{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["الفاتورة","ورقة1","ورقة2","ورقة3","ورقة4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"الفاتورة","index":0,"n_rows":33,"n_cols":26,"rows_kept":33,"cut":false,"hidden":false,"merged":[[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[0,6,0,7],[1,9,4,9],[36,0,36,7],[2,5,2,6],[7,5,7,6],[8,5,8,6],[7,0,7,2],[29,0,29,4],[35,0,35,7],[3,5,3,6],[30,0,30,4],[4,0,4,1],[6,0,6,1],[5,4,5,7],[6,4,6,7]]}
["المقر",null,null,null,null,null,"خاص",null,null,null,null,null,"العربى",null,null,null,"يونفرسال"]
["العنوان",null,null,null,null,null,null,null,null,"اسناذ حسين ممكن إيجاد قيم كل شركة من رقم فاتورة وتاريخها ومبلغها في الشيت كررت الفاتورة اربع مرات لكل شركة مرتان من التعامل  والجدول ",null,"رقم الفاتورة","تاريخ الفاتوره","مبلغ الفاتورة",null,"رقم الفاتورة","تاريخ الفاتوره","مبلغ الفاتورة",null,null,null,null,null,null,{"$f":"IFERROR(MATCH(B9,Customer_Name,0)+2,\"\")","v":3},"Cust.row"]
["البريد الاكترونى",null,null,null,null,"الفاتورة #",null,"التاريخ",null,null,null,100,"2020-12-18",273.60000000000002,null,101,"18/12/202",22.8,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(G4,Inv_Num,0)+2,\"\")","v":""},"Inv.row"]
["تليفــــــــــون  :",null,null,null,null,1,null,"2020-12-19",null,null,null,103,"2020-12-19",307.8,null,102,"2020-12-19",273.60000000000002,null,null,null,null,null,null,false,"New.inv."]
["سجل تجاري :  ",null,null,null,null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Inv.load"]
["ملف ضــريبي :",null,null,null,"mobile: ",null,null,null,null,"وهذا نماذج للعمل متنمنين لكم دوام الصحة والعافية",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MAX(Inv_Num)+1,1)","v":1},"Next Inv#"]
["القيمة المضافة :",null,null,null,"Date:……10…/12/2018………………….."]
["فاتورة إلى",null,null,null,null,"معرّف العميل",null,"الشروط"]
["اسم العميل /","العربى"]
["اسم الشركة /","العربي"]
["عنوانة /","الامارات"]
["تليفون /",55555]
["البريد الاكترونى","moon@hotmail.com"]
["البيان","الوصف",null,null,null,"الكمية","سعر الوحدة","المبلغ"]
["ثلاجة 14 قدم","14 قدم",null,null,null,2,120,{"$f":"IF(F15=\"\",ROUND(1*G15,2),ROUND(F15*G15,2))","v":240},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A15,Item_Name,0)+2,\"\")","v":3},3]
["فريزر","كبير",null,null,null,5,6,{"$f":"IF(F16=\"\",ROUND(1*G16,2),ROUND(F16*G16,2))","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A16,Item_Name,0)+2,\"\")","v":4},4]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A17,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A18,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A19,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A20,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A21,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A22,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A23,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F24=\"\",ROUND(1*G24,2),ROUND(F24*G24,2))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A24,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A25,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A26,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A27,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A28,Item_Name,0)+2,\"\")","v":""}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MATCH(A29,Item_Name,0)+2,\"\")","v":""}]
["شكراً لتعاملك معنا!",null,null,null,null,null,"الإجمالي الفرعي",{"$f":"SUM(H15:H29)","v":270}]
[{"$f":"NoToTxt(H33,\"جنيه\",\" قرش\")","v":" ثلاثمائة وسبعة جنيه وثمانون  قرش فقط لا غير"},null,null,null,null,null,"معدل الضريبة",0.14000000000000001]
[null,null,null,null,null,null,"الخصم",{"$f":"H30*H31","v":37.800000000000004}]
[null,null,null,null,null,null,"الإجمالي",{"$f":"H30+H32","v":307.8}]

{"sheet":"ورقة1","index":1,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["جميع الفواتير"]
["رقم الفاتورة","التاريخ","اسم العميل","المجموع"]

{"sheet":"ورقة2","index":2,"n_rows":2,"n_cols":17,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,10,0,16]]}
["فواتير القطعة",null,null,null,null,null,null,null,null,null,"البحث عن فاتورة"]
["رقم الفاتورة","اسم القطعة","وصف القطعة","الكمية","السعر","Inv.Row","Row",null,"رقم الفاتورة",null,"رقم الفاتورة","اسم القطعة","وصف القطعة","الكمية","السعر","Inv.Row","Row"]

{"sheet":"ورقة3","index":3,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["أسماء العملاء"]
["اسم العميل","اسم الشركة","العنوان","رقم الهاتف","البريد الالكتروني"]
["العربى","العربي","الامارات",55555,"moon@hotmail.com"]

{"sheet":"ورقة4","index":4,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["أسماء القطع ووصفها"]
["اسم القطعة","وصف القطعة"]
["ثلاجة 14 قدم","14 قدم"]
["فريزر","كبير"]