{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["customer.chart","Chart","NewInvoice","Summary.Invoice","invoice","Invoice.Form","Data","Invoice.Print"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":29,"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":"customer.chart","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["اسم العميل","التيلفون","العنوان","المحافظة"]
["يوسف إبراهيم","09005647888","مصر1","الفيوم"]
["خالد الشريف","09006974552","مصر2","الإسكندرية"]
["احمد عوض","09008745536","مصر3","الإسكندرية"]
["سامي يوسف","09563478929","مصر4","القاهرة"]
["محمد متولي","09264788882","مصر5","الشرقية"]

{"sheet":"Chart","index":1,"n_rows":16,"n_cols":20,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["حسابات القوائم",null,"القسم",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5:R39","v":{"$error":"#VALUE!"}}]
["المجموعة","المجموعة","القطعة","القسم","الاصناف","الوحدة","سعر البيع","سعر الشراء","صافي الربح","سعر البيع المقترح",null,"أسماء الحسابات",null,"الشركات المساهمة",null,"اسماء شركات التسويق",null,"المحافظات",null,"شركة الشحن"]
["احدية","احدية رياضية",1,"ملابس1","احدية ",1,200,185,15,210,null,null,null,"المنارة 5",null,"أديداس",null,"القاهرة",null,"Stylish"]
["ملابس","جينز",1,"ملابس2","جينز ",1,90,186,2,93,null,null,null,"العرفان ",null,"أرماني",null,"الجيزة",null,"Active"]
["جاكيت رسمي","جاكيت",1,"ملابس3","جاكيت  ",1,112,187,2,100,null,null,null,"الصفا",null,"سيليكت",null,"القاهرة",null,"kappa"]
["ملابس1","معطف شتوي",1,"ملابس4","معطف",1,169,188,10,157,null,null,null,"سكيتشرز",null,"أنتا سبورتس"]
["احدية1","احدية رياضية",1,"ملابس5","احدية 01",1,202,189,15,210,null,null,null,"جيوكس",null,"إيرييا"]
["ملابس1","جينز",1,"ملابس6","جينز 01",1,68,190,2,93]
["جاكيت رسمي1","جاكيت",1,"ملابس7","جاكيت  01",1,120,191,2,100]
["ملابس2","معطف شتوي",1,"ملابس8","معطف01",1,113,192,10,157]
["احدية2","احدية رياضية",1,"ملابس9","احدية 02",1,218,193,15,210]
["ملابس2","جينز",1,"ملابس10","جينز 02",1,96,194,2,93]
["جاكيت رسمي2","جاكيت",1,"ملابس11","جاكيت  02",1,300,195,2,100]
["ملابس","معطف شتوي",1,"ملابس12","معطف02",1,120,196,10,157]

{"sheet":"NewInvoice","index":2,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
["رقم الفاتورة الجديدة",1]
["اسم العميل",null,"التاريخ",null,"شركة التسويق",null,"عدد اصناف الشحنة"]
["التيلفون",null,"الشركة",null,"اسم المسوق"]
["العنوان",null,"رقم الفاتورة",null,"شركة الشحن",null,"الإجمالي"]
["المحافظة",null,"كود الفاتورة",null,"خدمة التوصيل"]
[]
["مسلسل","القسم","اسم الصنف","السعر","الوحدة","الكمية","الإجمالي"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," المطبقايات","مطبقيه معدن مقاس ٦٥ سم ",510,"قطعة",1,510]
[null," المطبقايات"," مطبقيه مستورده 2 دور",530,"قطعة",1,530]
[null,"ادوات اخري"," مطبقيه مستورده ٣ دور",190,"قطعة",1,190]
[null," المطبقايات","مطبقيه معدن مقاس ٦٥ سم ",510,"قطعة",1,510]
[null," المطبقايات"," مطبقيه مستورده 2 دور",530,"قطعة",1,530]

{"sheet":"Summary.Invoice","index":3,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(A6:A1048576)","v":8}]
[]
[]
[]
[]
["الشهر","التاريخ","الشركة","رقم الفاتورة","كود الفاتورة","القسم","اسم الصنف","السعر","الوحدة","الكمية","الاجمالي","اسم العميل","التيلفون","العنوان","المحافظة","شركة التسويق","اسم المسوق","شركة الشحن","خدمة التوصيل","خدمة التوصيل الفعليه","الملاحظات"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2023","ملابس","ممتاز1",140,"قطعة",1,140,"يوسف إبراهيم ","090065478","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق",50,22]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2024","ملابس","ممتاز2",380,"قطعة",1,380,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2025","ملابس","ممتاز3",150,"قطعة",1,150,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2026","ملابس","ممتاز4",150,"قطعة",1,150,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2027","ملابس","ممتاز5",370,"قطعة",1,370,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2028","ملابس","ممتاز6",70,"قطعة",1,70,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
["nov","2023-01-09","أديداس",1,"01-أديداس_10-01-2029","ملابس","ممتاز7",380,"قطعة",1,380,"يوسف إبراهيم ","010028820","طنطا حافظ وهبه","طنطا","سيليكت","خالد","الشرق"]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2030","ملابس رياضية","ممتاز8",1200,"قطعة",1,236,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا ",36,42]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2031","ملابس رياضية","ممتاز9",746,"قطعة",1,237,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2032","ملابس رياضية","ممتاز10",747,"قطعة",2,238,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2033","ملابس رياضية","ممتاز11",900,"قطعة",1,239,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2034","ملابس رياضية","ممتاز12",749,"قطعة",1,240,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2035","ملابس رياضية","ممتاز13",300,"قطعة",1,241,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2036","ملابس رياضية","ممتاز14",123,"قطعة",1,242,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]
[null,"2023-01-10","إيرييا",2,"02-إيرييا_11-01-2037","ملابس رياضية","ممتاز15",208,"قطعة",1,243,"سفيان السيد","010036974","الفيوم10","بور سعيد","المنارة2","محمد","اريزونا "]

{"sheet":"invoice","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[30,0,30,1],[29,0,29,1],[30,2,30,3]]}
["كود الاوردر"]
["إسم العميل"]
["رقم الهاتف"]
["عنوان العميل"]
["المحافظة"]
["تفاصيل الاوردر","عدد","الاصنـــــــــــــــــــــــــــــاف","السعر","القيمة"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
["خدمة التوصيل"]
["الإجمالي",null,{"$f":"ArbNum2Text($E31,2,4,\"جنيه\",\"جنيهات\",0,\"قرش\",\"قروش\",0)","v":"صفر جنيه"},null,{"$f":"SUM(E7:E29)+C30","v":0}]
[1,null,1,null,1]

{"sheet":"Invoice.Form","index":5,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[30,0,30,1],[29,0,29,1],[30,2,30,3]]}
["كود الاوردر"]
["إسم العميل"]
["رقم الهاتف"]
["عنوان العميل"]
["المحافظة"]
["تفاصيل الاوردر","عدد","الاصنـــــــــــــــــــــــــــــاف","السعر","القيمة"]
[1,{"$f":"NewInvoice!F9","v":0},{"$f":"NewInvoice!C9","v":0},{"$f":"NewInvoice!D9","v":0},{"$f":"NewInvoice!G9","v":0}]
[2,{"$f":"NewInvoice!F10","v":0},{"$f":"NewInvoice!C10","v":0},{"$f":"NewInvoice!D10","v":0},{"$f":"NewInvoice!G10","v":0}]
[3,{"$f":"NewInvoice!F11","v":0},{"$f":"NewInvoice!C11","v":0},{"$f":"NewInvoice!D11","v":0},{"$f":"NewInvoice!G11","v":0}]
[4,{"$f":"NewInvoice!F12","v":0},{"$f":"NewInvoice!C12","v":0},{"$f":"NewInvoice!D12","v":0},{"$f":"NewInvoice!G12","v":0}]
[5,{"$f":"NewInvoice!F13","v":0},{"$f":"NewInvoice!C13","v":0},{"$f":"NewInvoice!D13","v":0},{"$f":"NewInvoice!G13","v":0}]
[6,{"$f":"NewInvoice!F14","v":0},{"$f":"NewInvoice!C14","v":0},{"$f":"NewInvoice!D14","v":0},{"$f":"NewInvoice!G14","v":0}]
[7,{"$f":"NewInvoice!F15","v":0},{"$f":"NewInvoice!C15","v":0},{"$f":"NewInvoice!D15","v":0},{"$f":"NewInvoice!G15","v":0}]
[8,{"$f":"NewInvoice!F16","v":0},{"$f":"NewInvoice!C16","v":0},{"$f":"NewInvoice!D16","v":0},{"$f":"NewInvoice!G16","v":0}]
[9,{"$f":"NewInvoice!F17","v":0},{"$f":"NewInvoice!C17","v":0},{"$f":"NewInvoice!D17","v":0},{"$f":"NewInvoice!G17","v":0}]
[10,{"$f":"NewInvoice!F18","v":0},{"$f":"NewInvoice!C18","v":0},{"$f":"NewInvoice!D18","v":0},{"$f":"NewInvoice!G18","v":0}]
[11,{"$f":"NewInvoice!F19","v":0},{"$f":"NewInvoice!C19","v":0},{"$f":"NewInvoice!D19","v":0},{"$f":"NewInvoice!G19","v":0}]
[12,{"$f":"NewInvoice!F20","v":0},{"$f":"NewInvoice!C20","v":0},{"$f":"NewInvoice!D20","v":0},{"$f":"NewInvoice!G20","v":0}]
[13,{"$f":"NewInvoice!F21","v":0},{"$f":"NewInvoice!C21","v":0},{"$f":"NewInvoice!D21","v":0},{"$f":"NewInvoice!G21","v":0}]
[14,{"$f":"NewInvoice!F22","v":0},{"$f":"NewInvoice!C22","v":0},{"$f":"NewInvoice!D22","v":0},{"$f":"NewInvoice!G22","v":0}]
[15,{"$f":"NewInvoice!F23","v":0},{"$f":"NewInvoice!C23","v":0},{"$f":"NewInvoice!D23","v":0},{"$f":"NewInvoice!G23","v":0}]
[16,{"$f":"NewInvoice!F24","v":0},{"$f":"NewInvoice!C24","v":0},{"$f":"NewInvoice!D24","v":0},{"$f":"NewInvoice!G24","v":0}]
[17,{"$f":"NewInvoice!F25","v":0},{"$f":"NewInvoice!C25","v":0},{"$f":"NewInvoice!D25","v":0},{"$f":"NewInvoice!G25","v":0}]
[18,{"$f":"NewInvoice!F26","v":0},{"$f":"NewInvoice!C26","v":0},{"$f":"NewInvoice!D26","v":0},{"$f":"NewInvoice!G26","v":0}]
[19,{"$f":"NewInvoice!F27","v":0},{"$f":"NewInvoice!C27","v":0},{"$f":"NewInvoice!D27","v":0},{"$f":"NewInvoice!G27","v":0}]
[20,{"$f":"NewInvoice!F28","v":0},{"$f":"NewInvoice!C28","v":0},{"$f":"NewInvoice!D28","v":0},{"$f":"NewInvoice!G28","v":0}]
[21,{"$f":"NewInvoice!F29","v":0},{"$f":"NewInvoice!C29","v":0},{"$f":"NewInvoice!D29","v":0},{"$f":"NewInvoice!G29","v":0}]
[22,{"$f":"NewInvoice!F30","v":0},{"$f":"NewInvoice!C30","v":0},{"$f":"NewInvoice!D30","v":0},{"$f":"NewInvoice!G30","v":0}]
[23,{"$f":"NewInvoice!F31","v":0},{"$f":"NewInvoice!C31","v":0},{"$f":"NewInvoice!D31","v":0},{"$f":"NewInvoice!G31","v":0}]
["خدمة التوصيل",null,{"$f":"NewInvoice!F6","v":0}]
["الإجمالي",null,{"$f":"ArbNum2Text($E31,2,4,\"جنيه\",\"جنيهات\",0,\"قرش\",\"قروش\",0)","v":"صفر جنيه"},null,{"$f":"SUM(E7:E29)+C30","v":0}]
[1,null,1,null,1]

{"sheet":"Data","index":6,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["القسم","عدد","الاصنـــــــــــــــــــــــــــــاف","السعر","القيمة","الوحدة",{"$f":"ArbNum2Text($H1,2,4,\"جنيه\",\"جنيهات\",0,\"قرش\",\"قروش\",0)","v":"صفر جنيه"},null,null,null,{"$f":"ArbNum2Text($J1,2,4,\"جنيه\",\"جنيهات\",0,\"قرش\",\"قروش\",0)","v":"صفر جنيه"},null,1295,{"$f":"ArbNum2Text($M1,2,4,\"جنيه\",\"جنيهات\",0,\"قرش\",\"قروش\",0)","v":"ألف ومائتان وخمسة وتسعون جنيها"}]

{"sheet":"Invoice.Print","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}