{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,0,1,13],[27,11,27,13],[28,1,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,13],[26,1,26,2],[27,1,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[23,7,23,9],[24,1,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,9],[24,10,24,13],[10,11,10,13],[11,11,11,13],[22,1,22,2],[23,1,23,2],[23,3,23,4],[23,5,23,6],[23,10,23,13],[21,5,21,6],[21,7,21,8],[21,9,21,10],[3,11,3,13],[4,11,4,13],[5,11,5,13],[6,11,6,13],[7,11,7,13],[8,11,8,13],[9,11,9,13],[15,1,15,3],[16,9,16,10],[17,9,17,10],[12,1,12,3],[20,9,20,10],[20,7,20,8],[20,5,20,6],[19,1,19,2],[13,12,13,13],[14,1,14,2],[14,3,14,4],[14,12,14,13],[2,0,2,13],[13,5,13,6],[13,3,13,4],[13,1,13,2],[13,7,13,8],[13,10,13,11],[10,2,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[11,2,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[8,2,8,4],[8,5,8,6],[8,7,8,8],[9,2,9,4],[9,5,9,6],[7,2,7,4],[7,5,7,6],[7,7,7,8],[8,9,8,10],[3,0,3,1],[3,2,3,4],[3,5,3,6],[3,7,3,8],[4,9,4,10],[3,9,3,10],[10,0,10,1],[11,0,11,1],[4,2,4,4],[4,5,4,6],[4,7,4,8],[5,9,5,10],[6,2,6,4],[6,5,6,6],[6,7,6,8],[7,9,7,10],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[9,7,9,8],[9,9,9,10],[5,2,5,4],[5,5,5,6],[5,7,5,8],[6,9,6,10],[14,5,14,6],[14,7,14,8],[14,10,14,11]]}
[null,null,"الجهز المركزى للتنظيم والادارة",null,null,null,null,null,null,null,null,null,"مسلسل",1]
["تقرير البيانات الاساسية لموظف"]
["البيانات الاساسية"]
["الجهة",null,null,null,null,"اسم الجهة"]
["اسم الموظف",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,2,0),\"\")","v":"احمد ابراهيم السيد عطية"},null,null,"الديانة",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,3,0),\"\")","v":"مسلم "},null,"النوع",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,4,0),\"\")","v":"ذكر"}]
["الرقم القومى",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,5,0),\"\")","v":26509151300455},null,null,"الاسم الاول",null,{"$f":"LEFT(TRIM(C5),FIND(\" \",TRIM(C5),1))","v":"احمد "},null,"الاسم الثانى",null,{"$f":"SplitNames(C5,2)","v":"ابراهيم"}]
["الاسم الثالث",null,{"$f":"SplitNames(C5,3)","v":"السيد"},null,null,"الاسم الرابع",null,{"$f":"SplitNames(C5,4)","v":"عطية"},null,"عدد الاطفال",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,9,0),\"\")","v":3}]
["تاريخ الميلاد",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,6,0),\"\")","v":"1965-09-15"},null,null,"محافظة الميلاد",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,7,0),\"\")","v":"الشرقية"},null,"الحالة الاجتماعية",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,8,0),\"\")","v":"م"}]
["رقم العقار",null,null,null,null,"الشارع",null,null,null,"محافظة السكن"]
["محل السكن"]
[null,null,null,null,null,"الرقم التامينى",null,{"$f":"IFERROR(VLOOKUP($N$1,ورقة2!$A$2:$J$500,10,0),\"\")","v":2154682},null,"سن التقاعد على المعاش"]
["ترتيب الموظف داخل المجموعة الوظيقية",null,null,null,null,"ترتيب الموظف فى الجهة",null,null,null,"تاريخ ارجاع الاقدمية"]
[null,"المؤهلات"]
[null,"المرحلة",null,"المؤهل",null,"التخصص",null,"التقدير",null,"سنة التخرج","الجامعة/الكلية/المدرسة",null,"اخر بيان"]
[]
[null,"بيانات التعيين داخل الجهة"]
[null,"جهة التعيين","اسلوب شغل\nالوظيفة","نوع التعيين","رقم قرار \nالتعيين","تاريخ قرار\n التعيين","تاريخ استلام \nالعمل ","تاريخ استلام \nالعمل بالجهة الحالية","محافظة العمل","الجهة الموافقة \nعلى التعاقد",null,"مؤهل التعيين","اول تعيين بالحومة","اخر بيان"]
[]
[]
[null,"التدرج الوظيفى"]
[null,"بدئا من تاريخ","المجموعة الوظيفية","المجموعة النوعية","الدرجة المالية","تاريخ الحصول على الدرجة المالية",null,"المسمى الوظيفى",null,"التقسيم التنظيمى",null,"الكادر","نوع القرار","اخر بيان"]
[]
[null,"التدرج المالى"]
["بدئا من تاريخ","الاجر الوظيفي الاساسى",null,"الاجر المكمل/المتغير",null,"الحافز التعويضى",null,"اجمالى المرتب الشهرى",null,null,"بنك صرف المرتب"]
[]
[]
[null,"تدرج الحالة الوظيفية"]
[null,"بدءا من تاريخ",null,"الى تاريخ",null,"نوع الحالة الوظيفية",null,"الحالة الوظيفية",null,"جهة الاعارة",null,"اخر بيان"]

{"sheet":"ورقة2","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["مسلسل","اسم الموظف","الديانة","النوع","الرقم القومي","تاريخ الميلاد","محافظة الميلاد","الحالة الاجتماعية","عدد الأطفال","الرقم التأميني"]
[1,"احمد ابراهيم السيد عطية","مسلم ","ذكر",26509151300455,"1965-09-15","الشرقية","م",3,2154682]
[2,"محمد عبدالله محمود محمد","مسلم ","ذكر",26311250203571,"1963-11-25","الاسكندرية","م",4,6548752]
[3,"هاني فرج جرجس شحاته","مسيحي","ذكر",27510100123576,"1975-10-10","القاهرة","م",2,2150154]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}