{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["المدرسة "],"not_rendered":{"charts":0,"images":2,"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":17,"n_cols":30,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,28,0,29],[3,25,3,27],[3,22,3,24],[0,24,0,26],[2,0,2,12],[3,16,3,18],[3,13,3,15],[2,28,2,29],[1,28,1,29],[0,21,0,23]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"بحث عن إسم",null,null,"تاريخ اليوم",null,null,null,"تاريخ اليوم"]
[null,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":"TODAY()","v":"2021-01-04"}]
["بيان بأسماء العاملين بالمدرسة للعام 2021/2020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DAY(AC3)","v":4},{"$f":"MONTH(AC3)","v":1},{"$f":"YEAR(AC3)","v":2021},null,{"$f":"TODAY()","v":"2021-01-04"}]
["م","الكود","الاســــــــم","الوظيفة","مادة التخصص","تاريخ التعيين","استلام العمل","أعلى مؤهل وتاريخه","تاريخ الميلاد","الرقم القومى","الدرجة المالية الحالية","المجموعة النوعية","العنوان ","          عــــــــدد           سنوات الخدمه ",null,null,{"$f":"AC3","v":"2021-01-04"},null,null,{"$f":"\"تاريخ بلوغ سن الـ \" &V4&\"  سنة\"","v":"تاريخ بلوغ سن الـ 60  سنة"},"التاريخ الهجرى",60,"تاريخ بلوغ سن المعاش",null,null,"الأيام المتبقة للخروج على المعاش",null,null,"النوع","محافظة الميلاد"]
[{"$f":"IF(C5=\"\",\"\",SUBTOTAL(3,$C$5:C5))","v":1},6,"كريمة على محمد مصطفى","معلم خبير","مدرس فصل","1982-09-01","1982-09-07","دبلوم معلمات فى 1982/05/1",{"$f":"TEXT(LEFT(J5,7)+17000000,\"####-##-##\")+0","v":"1961-02-01"},26102011601001,"الأولى 2013","الفنية","عرب الرمل",{"$f":"IF(F5<>\"\",IF(DAY(F5)>DAY($Q$4),(DAY($Q$4)+30)-DAY(F5),DAY($Q$4)-DAY(F5)),\"\")","v":3},{"$f":"IF(F5 =\"\",\"\",DATEDIF(F5,$Q$4,\"ym\"))","v":4},{"$f":"IF(F5 =\"\",\"\",DATEDIF(F5,$Q$4,\"y\"))","v":38},{"$f":"IF(I5<>\"\",IF(DAY(I5)>DAY($Q$4),(DAY($Q$4)+30)-DAY(I5),DAY($Q$4)-DAY(I5)),\"\")","v":3},{"$f":"IF(I5 =\"\",\"\",DATEDIF(I5,$Q$4,\"ym\"))","v":11},{"$f":"IF(I5 =\"\",\"\",DATEDIF(I5,$Q$4,\"y\"))","v":59},{"$f":"DATE(YEAR(I5)+$V$4,MONTH(I5),DAY(I5))","v":"2021-02-01"},{"$f":"DATE(YEAR(I5)+$V$4,MONTH(I5),DAY(I5))","v":"2021-02-01"},{"$f":"T5","v":"2021-02-01"},{"$f":"DAY(V5)","v":1},{"$f":"MONTH(V5)","v":2},{"$f":"YEAR(V5)","v":2021},{"$f":"W5+IF(W5>=$Y$3,0,30)-$Y$3","v":27},{"$f":"IF((IF(W5>=$Y$3,0,-1)+X5)>=$Z$3,(IF(W5>=$Y$3,0,-1)+X5)-$Z$3,(IF(W5>=$Y$3,0,-1)+X5)+12-$Z$3)","v":0},{"$f":"Y5+IF(X5+IF(W5>=$Y$3,0,-1)>=$Z$3,0,-1)-$AA$3","v":0},{"$f":"IF(LEN(TRIM($J5))=0,\"\",IF(OR(NOT(ISNUMBER($J5)),LEN($J5)<>14),\"قومي خطأ\",IF(MOD(MID($J5,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($J5,3)","v":"الغربية"}]
[{"$f":"IF(C6=\"\",\"\",SUBTOTAL(3,$C$5:C6))","v":2},5,"عائشة محمد عبدالجواد اسماعيل","معلم خبير","مدرس فصل","1982-09-01","1982-09-05","د0معلمات1982","1962-07-29",26207291701002,"الأولى 2012          ","الفنية","عرب الرمل",3,4,38,5,5,58,"2022-07-29","2022-07-29","2022-07-29",29,7,2022,25,{"$f":"IF((IF(W6>=$Y$3,0,-1)+X6)>=$Z$3,(IF(W6>=$Y$3,0,-1)+X6)-$Z$3,(IF(W6>=$Y$3,0,-1)+X6)+12-$Z$3)","v":6},1,"انثى","المنوفية"]
[{"$f":"IF(C7=\"\",\"\",SUBTOTAL(3,$C$5:C7))","v":3},2,"هويدا محمد سيد احمد المصرى","معلم خبير","مدرس فصل","1984-09-01","22/9/19984","د0معلمين1984","1963-03-04",26303041400588,"الأولى 2012          ","الفنية","عرب الرمل",{"$f":"IF(F7<>\"\",IF(DAY(F7)>DAY($Q$4),(DAY($Q$4)+30)-DAY(F7),DAY($Q$4)-DAY(F7)),\"\")","v":3},{"$f":"IF(F7 =\"\",\"\",DATEDIF(F7,$Q$4,\"ym\"))","v":4},{"$f":"IF(F7 =\"\",\"\",DATEDIF(F7,$Q$4,\"y\"))","v":36},{"$f":"IF(I7<>\"\",IF(DAY(I7)>DAY($Q$4),(DAY($Q$4)+30)-DAY(I7),DAY($Q$4)-DAY(I7)),\"\")","v":0},{"$f":"IF(I7 =\"\",\"\",DATEDIF(I7,$Q$4,\"ym\"))","v":10},{"$f":"IF(I7 =\"\",\"\",DATEDIF(I7,$Q$4,\"y\"))","v":57},{"$f":"DATE(YEAR(I7)+$V$4,MONTH(I7),DAY(I7))","v":"2023-03-04"},{"$f":"DATE(YEAR(I7)+$V$4,MONTH(I7),DAY(I7))","v":"2023-03-04"},{"$f":"T7","v":"2023-03-04"},{"$f":"DAY(V7)","v":4},{"$f":"MONTH(V7)","v":3},{"$f":"YEAR(V7)","v":2023},{"$f":"W7+IF(W7>=$Y$3,0,30)-$Y$3","v":0},2,{"$f":"Y7+IF(X7+IF(W7>=$Y$3,0,-1)>=$Z$3,0,-1)-$AA$3","v":2},{"$f":"IF(LEN(TRIM($J7))=0,\"\",IF(OR(NOT(ISNUMBER($J7)),LEN($J7)<>14),\"قومي خطأ\",IF(MOD(MID($J7,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($J7,3)","v":"القليوبية"}]
[{"$f":"IF(C8=\"\",\"\",SUBTOTAL(3,$C$5:C8))","v":4},6,"محمد موسى السيد موسى","معلم خبير","مدرس فصل","1987-11-01","1988-02-06","د0معلمين1987","1963-08-07",26308071701274,"الأولى 2012          ","الفنية","عرب الرمل",3,2,33,27,4,57,"2023-08-07","2023-08-07","2023-08-07",7,8,2023,3,7,2,"ذكر","المنوفية"]
[{"$f":"IF(C9=\"\",\"\",SUBTOTAL(3,$C$5:C9))","v":5},5,"خالد ابراهيم الدسوقى النادى","معلم خبير","مدرس فصل","1988-08-19","1988-09-20","د0معلمين1988","1965-04-03",26504031701216,"الأولى 2012          ","الفنية","عرب الرمل",15,4,32,1,9,55,"2025-04-03","2025-04-03","2025-04-03",3,4,2025,29,2,4,"ذكر","المنوفية"]
[{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,$C$5:C10))","v":6},9,"فتحية فتوح عبد الله حسن","معلم خبير","مدرس فصل","1988-09-01","1988-11-23","د0معلمات1988","1968-03-14",26803140101765,"الأولى 2012          ","الفنية","عرب الرمل",3,4,32,20,9,52,"2028-03-14","2028-03-14","2028-03-14",14,3,2028,10,2,7,"انثى","القاهرة"]
[{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,$C$5:C11))","v":7},8,"عبد الله عفيفى محمد عفيفى","معلم خبير","مجال صناعى","1988-11-01","1988-12-05","د0الدراسات التكميلية الصناعية1988نظام 5سنوات","1967-09-24",26709241701279,"الأولى 2012          ","الفنية","عرب الرمل",3,2,32,10,3,53,"2027-09-24","2027-09-24","2027-09-24",24,9,2027,20,8,6,"ذكر","المنوفية"]
[{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,$C$5:C12))","v":8},7,"اشرف على عبدالعال هلال","معلم خبير","مدرس فصل","1988-12-29","1989-01-11","د0معلمين1988","1965-08-20",26508201701491,"الأولى 2012          ","الفنية","عرب الرمل",5,0,32,14,4,55,"2025-08-20","2025-08-20","2025-08-20",20,8,2025,16,7,4,"ذكر","المنوفية"]
[{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,$C$5:C13))","v":9},4,"يسرية ابو الفتوح العجمى حسن عابدين","كاتب أول","كاتب أول","1982-09-22","1982-10-07","د0تجارة1978",{"$f":"TEXT(LEFT(J13,7)+17000000,\"####-##-##\")+0","v":"1960-08-26"},26008261400749,"الأولى 2010/7/1","الكتابية","عرب الرمل",12,3,38,8,4,60,"2020-08-26","2020-08-26","2020-08-26",26,8,2020,22,7,-1,"انثى","القليوبية"]
[{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,$C$5:C14))","v":10},4,"محمود محمود محمد عابدين","كاتب أول","كاتب أول","1983-06-30","1987-06-13","د0تجارة1980","1960-02-22",26002221701217,"الأولى 2011","الكتابية","عرب الرمل",4,6,37,12,10,60,"2020-02-22","2020-02-22","2020-02-22",22,2,2020,18,1,-1,"ذكر","المنوفية"]
[{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,$C$5:C15))","v":11},1,"كامليا ابراهيم ابوالعلا حماد","كاتب أول","كاتب أول","1984-12-01","1984-12-01","د0تجارة1980","1960-11-19",26011191301285,"الأولى 2010/7/1","الكتابية","عرب الرمل",3,1,36,15,1,60,"2020-11-19","2020-11-19","2020-11-19",19,11,2020,15,10,-1,"انثى","الشرقية"]
[{"$f":"IF(C16=\"\",\"\",SUBTOTAL(3,$C$5:C16))","v":12},8,"وفاء عبدالقادر عبدالمطلب داود","كاتب أول","كاتب أول","1991-03-06","1991-03-16","د0تجارة1982","1963-08-18",26308181302162,"الأولى 2014/10/1","الكتابية","عرب الرمل",28,9,29,16,4,57,"2023-08-18","2023-08-18","2023-08-18",18,8,2023,14,7,2,"انثى","الشرقية"]
[{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,$C$5:C17))","v":13},11,"سامية ابراهيم الدسوقى محمد ابراهيم","كاتب ثان","كاتب ثان","1996-02-01","1996-02-03","د0تجارة1983","1963-11-06",26311061701048,"الثانية 2010/7/1","الكتابية","عرب الرمل",{"$f":"IF(F17<>\"\",IF(DAY(F17)>DAY($Q$4),(DAY($Q$4)+30)-DAY(F17),DAY($Q$4)-DAY(F17)),\"\")","v":3},{"$f":"IF(F17 =\"\",\"\",DATEDIF(F17,$Q$4,\"ym\"))","v":11},{"$f":"IF(F17 =\"\",\"\",DATEDIF(F17,$Q$4,\"y\"))","v":24},{"$f":"IF(I17<>\"\",IF(DAY(I17)>DAY($Q$4),(DAY($Q$4)+30)-DAY(I17),DAY($Q$4)-DAY(I17)),\"\")","v":28},{"$f":"IF(I17 =\"\",\"\",DATEDIF(I17,$Q$4,\"ym\"))","v":1},{"$f":"IF(I17 =\"\",\"\",DATEDIF(I17,$Q$4,\"y\"))","v":57},{"$f":"DATE(YEAR(I17)+$V$4,MONTH(I17),DAY(I17))","v":"2023-11-06"},{"$f":"DATE(YEAR(I17)+$V$4,MONTH(I17),DAY(I17))","v":"2023-11-06"},{"$f":"T17","v":"2023-11-06"},{"$f":"DAY(V17)","v":6},{"$f":"MONTH(V17)","v":11},{"$f":"YEAR(V17)","v":2023},{"$f":"W17+IF(W17>=$Y$3,0,30)-$Y$3","v":2},{"$f":"IF((IF(W17>=$Y$3,0,-1)+X17)>=$Z$3,(IF(W17>=$Y$3,0,-1)+X17)-$Z$3,(IF(W17>=$Y$3,0,-1)+X17)+12-$Z$3)","v":10},{"$f":"Y17+IF(X17+IF(W17>=$Y$3,0,-1)>=$Z$3,0,-1)-$AA$3","v":2},{"$f":"IF(LEN(TRIM($J17))=0,\"\",IF(OR(NOT(ISNUMBER($J17)),LEN($J17)<>14),\"قومي خطأ\",IF(MOD(MID($J17,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($J17,3)","v":"المنوفية"}]