{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ورقة1","ورقة2","ورقة3","ورقة4","ورقة5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"ورقة1","index":0,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["اسم المستخدم","كلمة السر"]
["احمد",123]
["محمد ",456]
["عاشور",789]
["ممدوح",0]
["عليوة",999]
["احميدة",666]

{"sheet":"ورقة2","index":1,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"COUNT(A3:A2000)","v":4},{"$f":"COUNTIF(J3:J25,J1)","v":2},null,null,"H",null,"العمليات"]
["الرقم الوظيفى","الاسم","تاريخ الميلاد","المؤهل العلمى","الحالة الاجتماعية","رقم الهاتف","فصيلة الدم","المسمى الوظيفى","تاريخ التعيين","الادارة ","القسم","تاريخ الشهادة الصحية","تاريخ انتهاء العمل ","الاجازات و العقوبات","المرتب","رقم البصمة"]
[100,"احمد عمر ","15/5/2001","متوسط","متزوج",915505557,"O-","مسؤل","2018-05-15","التسويق","الخزينة","2023-01-01","15/1/2020","لا يوجد",2000,3000]
[200,"امحمد","24/10/2000","دبلوم","اعزب",916073146,"A+","ادارى","2020-12-12","العمليات","الانتاج","2020-04-15","سارية","لا يوجد",1200,1265,"اعزب"]
[400,"على","24/10/1990","ماجستير","متزوج",99999999,"AB-","ادارى","2000-01-01","التسويق","الحركة","2025-06-16",null,"لا يوجد",1500,5555,"متزوج"]
[300,"ابراهيم","15/5/2020","دكتوراة","اعزب",916073146,"B+","مسؤل","2020-01-01","العمليات","الصيانة","2021-07-17",null,"لا يوجد",6000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"O+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB+"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB-"]
[]
[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,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,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,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,"الامن و السلامة"]
[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,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,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,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,"فنى صيانة "]
[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,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,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,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,"مدير"]

{"sheet":"ورقة3","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["بطاقة بيانات موظف"]
[null,"الرقم الوظيفى",null,null,"رقم البصمة",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,16,FALSE),\"\")","v":""}]
[]
[null,"الاسم",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,2,FALSE),\"\")","v":""},null,"المسمى الوظيفى",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,8,FALSE),\"\")","v":""}]
[]
[null,"تاريخ الميلاد",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,3,FALSE),\"\")","v":""},null,"الادارة",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,10,FALSE),\"\")","v":""}]
[]
[null,"المؤهل العلمى",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,4,FALSE),\"\")","v":""},null,"القسم",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,11,FALSE),\"\")","v":""}]
[]
[null,"الحالة الاجتماعية",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,5,FALSE),\"\")","v":""},null,"تاريخ الشهادة الصحية",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,12,FALSE),\"\")","v":""}]
[]
[null,"رقم الهاتف",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,6,FALSE),\"\")","v":""},null,"حالة الشهادة الصحية",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,13,FALSE),\"\")","v":""}]
[]
[null,"فصيلة الدم",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,7,FALSE),\"\")","v":""},null,"الاجازات و العقوبات",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,14,FALSE),\"\")","v":""}]
[]
[null,"تاريخ التعيين",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,9,FALSE),\"\")","v":""},null,"المرتب",{"$f":"IFERROR(VLOOKUP(C2,ورقة2!$A$3:$P$10000,15,FALSE),\"\")","v":""}]

{"sheet":"ورقة4","index":3,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"O-","اعزب","العمليات","شؤون الموظفين","مسؤل"]
[null,"O+","متزوج","التسويق","الحركة","ادارى"]
[null,"A+",null,"الجودة","الصيانة","مندوب"]
[null,"A-",null,"الشؤون الادارية و المالية","الانتاج","سائق فوركة"]
[null,"B+",null,null,"المخازن","سائق شاحنة"]
[null,"B-",null,null,"الخدمات","سائق كنتر"]
[null,"AB+",null,null,"الامن و السلامة","مدخل بيانات"]
[null,"AB-",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,null,null,"مسؤل شبكات"]
[null,null,null,null,null,"مدير"]
[null,null,null,null,null,"محاسب"]
[null,null,null,null,null,"ضابط جودة"]

{"sheet":"ورقة5","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"عدد الموظفين",{"$f":"COUNTA(ورقة2!A3:A100)","v":4}]
[null,"العمليات",{"$f":"COUNTIF(ورقة2!J3:J17,ورقة5!B3)","v":2}]
[null,"اعزب",{"$f":"COUNTIF(ورقة2!E3:E17,ورقة5!B4)","v":2}]
[null,"O-",{"$f":"COUNTIF(ورقة2!G3:G17,ورقة5!B5)","v":1}]
[null,"مسؤل",{"$f":"COUNTIF(ورقة2!H3:H17,ورقة5!B6)","v":2}]
[null,"شؤون الموظفين",{"$f":"COUNTIF(ورقة2!K3:K17,ورقة5!B7)","v":0}]