{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["الصفحة الرئيسية","اضافة موظف جديد","صفحة البحث","تعديل بيانات موظف","قسم 1","قسم 2","قسم 3","قسم4","قسم 5","قسم 6","قسم 7","filter"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"اضافة موظف جديد","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,22,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"بعد ادخال البيانات بشكل صحيح دون ترك خانه فارغة يتم حفظ البيانات حسب اسم القسم  وترحل اليه البيانات مع عدم تكرار اسم الموظف في كل الاقسام "]

{"sheet":"صفحة البحث","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,7,20,8],[3,1,5,2],[3,3,5,4],[14,1,16,2],[14,3,16,4],[9,7,9,8]]}
[]
[]
[]
[null,"البحث بالاسم",null,"فتحي2"]
[]
[]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,{"$f":"IF($D$4=\"\",\"\",VLOOKUP($D$4,بيانات1,1,0))","v":"فتحي2"},{"$f":"IF($D$4=\"\",\"\",VLOOKUP($D$4,بيانات1,2,0))","v":702},{"$f":"IF($D$4=\"\",\"\",VLOOKUP($D$4,بيانات1,3,0))","v":"الثانية"},{"$f":"IF($D$4=\"\",\"\",VLOOKUP($D$4,بيانات1,4,0))","v":"اداري"},{"$f":"IF($D$4=\"\",\"\",VLOOKUP($D$4,بيانات1,5,0))","v":7},null,"تظهر بيانات الموظف هنا"]
[]
[]
[]
[]
[null,"البحث بالرقم",null,701]
[]
[]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,{"$f":"IF($D$15=\"\",\"\",VLOOKUP($D$15,بيانات,2,0))","v":"فتحي11"},{"$f":"IF($D$15=\"\",\"\",VLOOKUP($D$15,بيانات,3,0))","v":701},{"$f":"IF($D$15=\"\",\"\",VLOOKUP($D$15,بيانات,4,0))","v":"الاولي"},{"$f":"IF($D$15=\"\",\"\",VLOOKUP($D$15,بيانات,5,0))","v":"رئيس قسم"},{"$f":"IF($D$15=\"\",\"\",VLOOKUP($D$15,بيانات,6,0))","v":7},null,"تظهر بيانات الموظف هنا"]

{"sheet":"تعديل بيانات موظف","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,1,6,2],[4,3,6,4],[4,6,5,10],[16,2,17,9],[18,2,18,9]]}
[]
[]
[]
[]
[null,"البحث بالاسم",null,701,null,null,"من هنا يتم البحث عن الموظف بالاسم او الرقم لجب بياناته للتعديل"]
[]
[]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,{"$f":"IF($D$5=\"\",\"\",VLOOKUP($D$5,بيانات,2,0))","v":"فتحي11"},{"$f":"IF($D$5=\"\",\"\",VLOOKUP($D$5,بيانات,3,0))","v":701},{"$f":"IF($D$5=\"\",\"\",VLOOKUP($D$5,بيانات,4,0))","v":"الاولي"},{"$f":"IF($D$5=\"\",\"\",VLOOKUP($D$5,بيانات,5,0))","v":"رئيس قسم"},1]
[]
[]
[]
[]
[]
[null,null,"عند جلب بيانات الموظف يتم تعديل البيانات واختار القسم الجديد من خانة القسم على شكل قائمة منسدلة والضغط على حفظ البيانات لنقله من القسم "]
[]
[null,null,"القديم الى القسم الجديد  مع عدم التكرار"]

{"sheet":"قسم 1","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 1"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"سالم1",101,"a","اداري1",1]
[null,"سالم2",102,"b","اداري1",1]
[null,"سالم3",103,"c","اداري1",1]
[null,"سالم4",104,"a","اداري1",1]
[null,"سالم5",105,"s","اداري1",1]
[null,"سالم6",106,"r","اداري1",1]
[null,"سالم7",107,"w","اداري1",1]
[null,"سالم8",108,"w","اداري1",1]
[null,"سالم6",106,"r","اداري1",1]

{"sheet":"قسم 2","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 2"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"بشير1",201,"a","اداري2",3]
[null,"بشير2",202,"a","اداري2",2]
[null,"بشير3",203,"b","اداري2",2]
[null,"بشير4",204,"b","اداري2",2]
[null,"بشير5",205,"d","اداري2",2]
[null,"بشير6",206,"c","اداري2",2]

{"sheet":"قسم 3","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 3"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"احمد1",301,"a","اداري3",3]
[null,"احمد2",302,"b","اداري3",3]
[null,"عبدالله",303,"a","اداري4",3]

{"sheet":"قسم4","index":7,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 4"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"علي1",401,"h","رئيس وحدة",4]
[null,"علي2",402,"e","مبيعات",4]

{"sheet":"قسم 5","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 5"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"نور1",501,"d","اداري5",5]
[null,"نور2",502,"g","اداري5",5]
[null,"نور",5678,"f","اداري ",5]
[null,"نور2",502,"g","اداري5",5]
[null,null,502,"g","اداري5",5]

{"sheet":"قسم 6","index":9,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 6"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"سليم",601,"a","موظف",6]
[null,"عمر",602,"b","بستاني",6]
[null,"صصص",111111,"بب3ب","1ي2",6]

{"sheet":"قسم 7","index":10,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,2,2,4]]}
[]
[null,null,"القسم 7"]
[]
[]
[null,"الاسم","الرقم","المرتبة","الوظيفة","القسم"]
[null,"فتحي11",701,"الاولي","رئيس قسم",7]
[null,"فتحي2",702,"الثانية","اداري",7]
[null,"فتحي11",701,"الاولي","رئيس قسم",7]
[null,"فتحي11",701,"الاولي","رئيس قسم",7]

{"sheet":"filter","index":11,"n_rows":500,"n_cols":6,"rows_kept":500,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"C2","v":101},"سالم1",101,"a","اداري1",1]
[{"$f":"C3","v":102},"سالم2",102,"b","اداري1",1]
[103,"سالم3",103,"c","اداري1",1]
[104,"سالم4",104,"a","اداري1",1]
[105,"سالم5",105,"s","اداري1",1]
[106,"سالم6",106,"r","اداري1",1]
[107,"سالم7",107,"w","اداري1",1]
[108,"سالم8",108,"w","اداري1",1]
[106,"سالم6",106,"r","اداري1",1]
[201,"بشير1",201,"a","اداري2",3]
[202,"بشير2",202,"a","اداري2",2]
[203,"بشير3",203,"b","اداري2",2]
[204,"بشير4",204,"b","اداري2",2]
[205,"بشير5",205,"d","اداري2",2]
[206,"بشير6",206,"c","اداري2",2]
[303,"عبدالله",303,"a","اداري4",3]
[301,"احمد1",301,"a","اداري3",3]
[302,"احمد2",302,"b","اداري3",3]
[303,"عبدالله",303,"a","اداري4",3]
[401,"علي1",401,"h","رئيس وحدة",4]
[402,"علي2",402,"e","مبيعات",4]
[501,"نور1",501,"d","اداري5",5]
[502,"نور2",502,"g","اداري5",5]
[5678,"نور",5678,"f","اداري ",5]
[502,"نور2",502,"g","اداري5",5]
[601,"سليم",601,"a","موظف",6]
[602,"عمر",602,"b","بستاني",6]
[111111,"صصص",111111,"بب3ب","1ي2",6]
[701,"فتحي11",701,"الاولي","رئيس قسم",7]
[702,"فتحي2",702,"الثانية","اداري",7]
[701,"فتحي11",701,"الاولي","رئيس قسم",7]
[701,"فتحي11",701,"الاولي","رئيس قسم",7]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C67","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C131","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C195","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C259","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C323","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C387","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[{"$f":"C451","v":0}]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]