{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["الشاشة الرئيسية","تكويد الاصناف","إذن إضافة","المخزن الرئيسى","فاتورةمبيعات","كـارت صنـف","العاملين","بيانات الصنف","العملاء"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,1,25,12],[0,0,25,0],[0,13,25,13]]}

{"sheet":"تكويد الاصناف","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"م","كود الصنف","اسم الصنف","طبيعة الصنف","رصيد أول","المخزن المخصص","ملاحظات"]
[null,{"$f":"IF(C9<>\"\",1,\" \")","v":" "},null,null,null,null,"رئيسى"]
[null,{"$f":"IF(C10<>\"\",B9+1,\"\")","v":""},null,null,null,null,"فرعى"]
[null,{"$f":"IF(C11<>\"\",B10+1,\"\")","v":""},null,null,null,null,"رئيسى"]
[null,{"$f":"IF(C12<>\"\",B11+1,\"\")","v":""},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,"فرعى"]
[null,"",null,null,null,null,"رئيسى"]
[null,"",null,null,null,null,"فرعى"]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C24<>\"\",B23+1,\"\")","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"إذن إضافة","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"تاريخ الاذن","رقم الاذن","رقم الصنف","اسم الصنف","الوحدة","الكمية المطلوبة","الكمية المصرح بها","الكمية المنصرفة","حالة الصنف","سعر الوحدة القيمة","وارد من","مخزن الإضافة"]

{"sheet":"المخزن الرئيسى","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,1,4,7]]}
[]
[]
[]
[null,"المخزن الرئيسى"]
[]
[]
[null,"م","كود الصنف","اسم الصنف","رصيد أول","وارد","صادر","رصيد آخر"]

{"sheet":"فاتورةمبيعات","index":4,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[45,6,45,7],[12,2,12,3],[39,5,39,6],[40,5,40,6],[41,5,41,6],[41,3,41,4],[41,1,41,2],[0,1,0,3],[1,1,1,3],[11,2,11,3],[37,5,37,6],[38,5,38,6],[3,1,3,3]]}
[null,"شــركة الإتـحاد للإســتيراد والتـجارة والتـوزيع"]
[null,"25 شارع               - جمهورية مصر العربية"]
[null,null,"سجل تجارى رقم","بطاقة ضربية رقم"]
[]
[null,null,null,null,null,null,null,"فاتورة رقم"]
[null,null,null,"فاتورة مبيعات INVOICE",null,null,null,100]
[null,"اسم العميل","محمد أحمد "]
[null,"عنوان العميل",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],2,0),\" \")","v":"القاهرة"}]
[null,"كود العميل",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],3,0),\" \")","v":324}]
[null,"المنطقة",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],5,0),\" \")","v":0},null,null,null,"اليوم","التاريخ"]
[null,"الرمز البريدي ",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],6,0),\" \")","v":12345},null,null,null,{"$f":"TEXT(H11,\"dddd\")","v":"الأحد"},{"$f":"NOW()","v":"2019-04-14T20:03:53.930"}]
[null,"Tel",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],4,0),\" \")","v":100010000}]
[null,"E-mail",{"$f":"IFERROR(VLOOKUP($C$7,العملاء[],7,0),\" \")","v":"Ventolin2115@outlook.com"},null,null,null,"المستخدم","محمود طاهر"]
[]
[null,"م","كود الصنف","بيـــــان الأصـــناف","الكمية"," الوحدة","سعر الوحدة","المبلغ"]
[null,{"$f":"IF(D16<>\"\",1,\"\")","v":1},{"$f":"IFERROR(VLOOKUP(D16,كودالصنف[],2,0),\" \")","v":"A-100"},"المنتج 1",1,null,{"$f":"IFERROR(VLOOKUP(E16,#REF!,2,1),\" \")","v":" "},{"$f":"IFERROR(G16*E16,\" \")","v":" "}]
[null,{"$f":"IF(D17<>\"\",2,\"\")","v":2},{"$f":"IFERROR(VLOOKUP(D17,كودالصنف[],2,0),\" \")","v":"A-101"},"المنتج 2",5,null,{"$f":"IFERROR(VLOOKUP(E17,#REF!,2,1),\" \")","v":" "},{"$f":"IFERROR(G17*E17,\" \")","v":" "}]
[null,{"$f":"IF(D18<>\"\",3,\"\")","v":3},{"$f":"IFERROR(VLOOKUP(D18,كودالصنف[],2,0),\" \")","v":"A-102"},"المنتج 3",10,null,{"$f":"IFERROR(VLOOKUP(E18,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D19<>\"\",4,\"\")","v":4},{"$f":"IFERROR(VLOOKUP(D19,كودالصنف[],2,0),\" \")","v":"A-103"},"المنتج 4",15,null,{"$f":"IFERROR(VLOOKUP(E19,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D20<>\"\",5,\"\")","v":5},{"$f":"IFERROR(VLOOKUP(D20,كودالصنف[],2,0),\" \")","v":"A-104"},"المنتج 5",20,null,{"$f":"IFERROR(VLOOKUP(E20,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D21<>\"\",6,\"\")","v":6},{"$f":"IFERROR(VLOOKUP(D21,كودالصنف[],2,0),\" \")","v":"A-105"},"المنتج 6",25,null,{"$f":"IFERROR(VLOOKUP(E21,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D22<>\"\",7,\"\")","v":7},{"$f":"IFERROR(VLOOKUP(D22,كودالصنف[],2,0),\" \")","v":"A-106"},"المنتج 7",30,null,{"$f":"IFERROR(VLOOKUP(E22,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D23<>\"\",8,\"\")","v":8},{"$f":"IFERROR(VLOOKUP(D23,كودالصنف[],2,0),\" \")","v":"A-107"},"المنتج 8",3,null,{"$f":"IFERROR(VLOOKUP(E23,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D24<>\"\",9,\"\")","v":9},{"$f":"IFERROR(VLOOKUP(D24,كودالصنف[],2,0),\" \")","v":"A-108"},"المنتج 9",40,null,{"$f":"IFERROR(VLOOKUP(E24,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D25<>\"\",10,\"\")","v":10},{"$f":"IFERROR(VLOOKUP(D25,كودالصنف[],2,0),\" \")","v":"A-109"},"المنتج 10",45,null,{"$f":"IFERROR(VLOOKUP(E25,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D26<>\"\",11,\"\")","v":11},{"$f":"IFERROR(VLOOKUP(D26,كودالصنف[],2,0),\" \")","v":"A-110"},"المنتج 11",50,null,{"$f":"IFERROR(VLOOKUP(E26,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D27<>\"\",12,\"\")","v":12},{"$f":"IFERROR(VLOOKUP(D27,كودالصنف[],2,0),\" \")","v":"A-111"},"المنتج 12",55,null,{"$f":"IFERROR(VLOOKUP(E27,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D28<>\"\",13,\"\")","v":13},{"$f":"IFERROR(VLOOKUP(D28,كودالصنف[],2,0),\" \")","v":"A-112"},"المنتج 13",6,null,{"$f":"IFERROR(VLOOKUP(E28,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D29<>\"\",14,\"\")","v":14},{"$f":"IFERROR(VLOOKUP(D29,كودالصنف[],2,0),\" \")","v":"A-113"},"المنتج 14",60,null,{"$f":"IFERROR(VLOOKUP(E29,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D30<>\"\",15,\"\")","v":15},{"$f":"IFERROR(VLOOKUP(D30,كودالصنف[],2,0),\" \")","v":"A-114"},"المنتج 15",22,null,{"$f":"IFERROR(VLOOKUP(E30,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D31<>\"\",16,\"\")","v":16},{"$f":"IFERROR(VLOOKUP(D31,كودالصنف[],2,0),\" \")","v":"A-115"},"المنتج 16",4,null,{"$f":"IFERROR(VLOOKUP(E31,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D32<>\"\",17,\"\")","v":17},{"$f":"IFERROR(VLOOKUP(D32,كودالصنف[],2,0),\" \")","v":"A-116"},"المنتج 17",5,null,{"$f":"IFERROR(VLOOKUP(E32,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D33<>\"\",18,\"\")","v":18},{"$f":"IFERROR(VLOOKUP(D33,كودالصنف[],2,0),\" \")","v":"A-117"},"المنتج 18",25,null,{"$f":"IFERROR(VLOOKUP(E33,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D34<>\"\",19,\"\")","v":19},{"$f":"IFERROR(VLOOKUP(D34,كودالصنف[],2,0),\" \")","v":"A-118"},"المنتج 19",22,null,{"$f":"IFERROR(VLOOKUP(E34,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D35<>\"\",20,\"\")","v":20},{"$f":"IFERROR(VLOOKUP(D35,كودالصنف[],2,0),\" \")","v":"A-119"},"المنتج 20",200,null,{"$f":"IFERROR(VLOOKUP(E35,#REF!,2,1),\" \")","v":" "}," "]
[null,{"$f":"IF(D36<>\"\",21,\"\")","v":21},{"$f":"IFERROR(VLOOKUP(D36,كودالصنف[],2,0),\" \")","v":"A-119"},"المنتج 20",1000,null,{"$f":"IFERROR(VLOOKUP(E36,#REF!,2,1),\" \")","v":" "},{"$f":"IFERROR(G36*E36,\" \")","v":" "}]
[null,{"$f":"IF(D37<>\"\",22,\"\")","v":22},{"$f":"IFERROR(VLOOKUP(D37,كودالصنف[],2,0),\" \")","v":"A-121"},"المنتج 22",78,null,{"$f":"IFERROR(VLOOKUP(E37,#REF!,2,1),\" \")","v":" "}," "]
[null,"عدد الاصناف ",{"$f":"SUBTOTAL(109,E16:E37)","v":1721},null,null,"قيمة الفاتورة",null,{"$f":"SUM(H16:H37)","v":0}]
[null,null,null,null,null,"ضريبة القيمة المضافة",null,{"$f":"H38*0.14","v":0}]
[null,null,null,null,null,"اجمالى قيمة الفاتورة",null,{"$f":"H39+H38","v":0}]
[null,null,null,null,null,"رصيد سابق للعميل",null,120]
[null,"إجمــالى الفاتورة/",null,{"$f":"NoToTxt(H42,\"جنيـــهاً\",\"قرشاً\")","v":"فقط مائة وعشرون جنيـــهاً"},null,"جملة",null,{"$f":"H41+H40","v":120}]
[null,"ادارة المبيعات",null,"توقيع وختم المستلم",null,null,null,"اسم المندوب"]
[null,"...............................",null,"...............................",null,null,null,"..............................."]
[]
[null,"إذا كانت لديك أي إستفسار بشأن الفاتورة، فالرجاء الاتصال بـنا على رقم   WhatsaApp",null,null,null,null,"شكراً لتعاملك معنا"]
[null,null,null,"[ email@address.com]"]

{"sheet":"كـارت صنـف","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,1],[3,0,4,0],[3,1,4,1],[3,2,3,3],[3,4,3,5],[3,6,4,6],[3,7,4,7]]}
["كـارت صنـف"]
["مسلسل :"]
["اسم الصنف :",null,null,"رقم الصنف :",null,null,"الوحدة :"]
["التاريخ","البيــان","الـــوارد",null,"المنصــرف",null,"الرصيـد","ملاحظات"]
[null,null,"إذن رقم","الكميـة","إذن رقم","الكميـة"]

{"sheet":"العاملين","index":6,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"شــركة الإتحاد للإســتيراد والتـجارة والتـوزيع"]
[null,null,"قسم شئون العاملين "]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":43569}]
[null,null,"الإســـــــــــــم","كود الموظف","الرقم القومى","محافظة الميلاد","تاريخ الميلاد","الحالة الاجتماعية","الوصول الى سن الستين","متبقى لسن الستين","موبايل","العنوان بالتفصيل","الرقم التامينى","المسمى الوظيفى بالشركة","تاريخ التعيين بالشركة"]
[null,null,"عبد العريز احمد رضوان",1,null,{"$f":"A_ID(E7,1)","v":""},{"$f":"A_ID(E7,2)","v":""},"متزوج",{"$f":"G7+21915","v":{"$error":"#VALUE!"}},{"$f":"DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"y\")&\"سنه و \"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"ym\")&\"شهر و\"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"md\")&\"يوم\"","v":{"$error":"#VALUE!"}},null,null,null,null,"2018-01-01"]
[null,null,"مصطفى صابر عبده شريف",2,null,"",{"$f":"A_ID(E8,2)","v":""},"أعزب",{"$f":"G8+21915","v":{"$error":"#VALUE!"}},{"$f":"DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"y\")&\"سنه و \"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"ym\")&\"شهر و\"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"md\")&\"يوم\"","v":{"$error":"#VALUE!"}},null,null,null,null,"2018-01-02"]
[null,null,"محمود طاهر",3,null,"","","متزوج",{"$f":"G9+21915","v":{"$error":"#VALUE!"}},{"$f":"DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"y\")&\"سنه و \"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"ym\")&\"شهر و\"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"md\")&\"يوم\"","v":{"$error":"#VALUE!"}},null,null,null,null,"2018-01-03"]
[null,null,"عماد الدين عبد القادر",4,null,"","","أعزب",{"$error":"#VALUE!"},{"$f":"DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"y\")&\"سنه و \"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"ym\")&\"شهر و\"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"md\")&\"يوم\"","v":{"$error":"#VALUE!"}},null,null,null,null,"2018-01-04"]
[null,null,"ماهر المغازى",5,null,"",{"$f":"A_ID(E11,2)","v":""},"متزوج",{"$error":"#VALUE!"},{"$f":"DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"y\")&\"سنه و \"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"ym\")&\"شهر و\"&DATEDIF($I$5,العاملين[[#This Row],[الوصول الى سن الستين]],\"md\")&\"يوم\"","v":{"$error":"#VALUE!"}},null,null,null,null,"2018-01-05"]

{"sheet":"بيانات الصنف","index":7,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["اسم الصنف بالعربية2","CODE الكود الخاص بنا"]
["المنتج 1","A-100"]
["المنتج 2","A-101"]
["المنتج 3","A-102"]
["المنتج 4","A-103"]
["المنتج 5","A-104"]
["المنتج 6","A-105"]
["المنتج 7","A-106"]
["المنتج 8","A-107"]
["المنتج 9","A-108"]
["المنتج 10","A-109"]
["المنتج 11","A-110"]
["المنتج 12","A-111"]
["المنتج 13","A-112"]
["المنتج 14","A-113"]
["المنتج 15","A-114"]
["المنتج 16","A-115"]
["المنتج 17","A-116"]
["المنتج 18","A-117"]
["المنتج 19","A-118"]
["المنتج 20","A-119"]
["المنتج 21","A-120"]
["المنتج 22","A-121"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"P.A.101.4002.600.0.HB","WHITE 101 4 mm DEKORATIF GLAZING BEAD 6 mt SOFT PVC BLACK"]
[null,null,null,null,null,"الكمية","السعر"]
[null,null,null,null,null,1,50]
[null,null,null,null,null,5,48]
[null,null,null,null,null,10,45]
[null,null,null,null,null,25,40]
[null,null,null,null,null,50,38]

{"sheet":"العملاء","index":8,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"اسماء العملاء","عنوان العميل","الكود","موبايل العميل","المنطقة","الرمز البريدي "," البريد الإلكتروني"]
[null,"البيع لغير العملاء","***","***","***",null,"***","***"]
[null,"احم"]
[null,"محمد أحمد ","القاهرة",324,100010000,null,12345,"Ventolin2115@outlook.com"]
[null,"اشسش"]
[null,"يبيب"]
[null,"لبلب"]
[null,"ااا"]
[null,"ففقفق"]
[null,"ثثقثق"]
[null,"ثثقثقفغف"]
[null,"لبلبلب"]