{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1"],"not_rendered":{"charts":0,"images":1,"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":"1","index":0,"n_rows":17,"n_cols":27,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,25,0,26],[3,22,3,24],[3,19,3,21],[0,21,0,23],[2,1,2,9],[3,13,3,15],[3,10,3,12],[2,25,2,26],[1,25,1,26],[0,18,0,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"بحث عن إسم",null,null,"تاريخ اليوم",null,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":"2024-07-24"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DAY(Z3)","v":24},{"$f":"MONTH(Z3)","v":7},{"$f":"YEAR(Z3)","v":2024},null,{"$f":"TODAY()","v":"2024-07-24"}]
[null,"م","الاســــــــم","الوظيفة","تاريخ التعيين","تاريخ الميلاد","رقم الهوية ","الوظيفة ","الإدارة ","الجنسية ","          عــــــــدد           سنوات الخدمه ",null,null,{"$f":"Z3","v":"2024-07-24"},null,null,{"$f":"\"تاريخ بلوغ سن الـ \" &S4&\"  سنة\"","v":"تاريخ بلوغ سن الـ 60  سنة"},"التاريخ الهجرى",60,"تاريخ بلوغ سن المعاش",null,null,"الأيام المتبقة للخروج على المعاش",null,null,"النوع","محافظة الميلاد"]
[null,{"$f":"IF(C5=\"\",\"\",SUBTOTAL(3,$C$5:C5))","v":1},"كريمة على محمد مصطفى",null,"1982-09-01",{"$f":"TEXT(LEFT(G5,7)+17000000,\"####-##-##\")+0","v":"1961-02-01"},26102011601001,null,null,null,{"$f":"IF(E5<>\"\",IF(DAY(E5)>DAY($N$4),(DAY($N$4)+30)-DAY(E5),DAY($N$4)-DAY(E5)),\"\")","v":23},{"$f":"IF(E5 =\"\",\"\",DATEDIF(E5,$N$4,\"ym\"))","v":10},{"$f":"IF(E5 =\"\",\"\",DATEDIF(E5,$N$4,\"y\"))","v":41},{"$f":"IF(F5<>\"\",IF(DAY(F5)>DAY($N$4),(DAY($N$4)+30)-DAY(F5),DAY($N$4)-DAY(F5)),\"\")","v":23},{"$f":"IF(F5 =\"\",\"\",DATEDIF(F5,$N$4,\"ym\"))","v":5},{"$f":"IF(F5 =\"\",\"\",DATEDIF(F5,$N$4,\"y\"))","v":63},{"$f":"DATE(YEAR(F5)+$S$4,MONTH(F5),DAY(F5))","v":"2021-02-01"},{"$f":"DATE(YEAR(F5)+$S$4,MONTH(F5),DAY(F5))","v":"2021-02-01"},{"$f":"Q5","v":"2021-02-01"},{"$f":"DAY(S5)","v":1},{"$f":"MONTH(S5)","v":2},{"$f":"YEAR(S5)","v":2021},{"$f":"T5+IF(T5>=$V$3,0,30)-$V$3","v":7},{"$f":"IF((IF(T5>=$V$3,0,-1)+U5)>=$W$3,(IF(T5>=$V$3,0,-1)+U5)-$W$3,(IF(T5>=$V$3,0,-1)+U5)+12-$W$3)","v":6},{"$f":"V5+IF(U5+IF(T5>=$V$3,0,-1)>=$W$3,0,-1)-$X$3","v":-4},{"$f":"IF(LEN(TRIM($G5))=0,\"\",IF(OR(NOT(ISNUMBER($G5)),LEN($G5)<>14),\"قومي خطأ\",IF(MOD(MID($G5,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($G5,3)","v":"ÇáÛÑÈíÉ"}]
[null,{"$f":"IF(C6=\"\",\"\",SUBTOTAL(3,$C$5:C6))","v":2},"عائشة محمد عبدالجواد اسماعيل",null,"1982-09-01","1962-07-29",26207291701002,null,null,null,23,10,41,25,11,61,"2022-07-29","2022-07-29","2022-07-29",29,7,2022,5,{"$f":"IF((IF(T6>=$V$3,0,-1)+U6)>=$W$3,(IF(T6>=$V$3,0,-1)+U6)-$W$3,(IF(T6>=$V$3,0,-1)+U6)+12-$W$3)","v":0},-2,"انثى","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C7=\"\",\"\",SUBTOTAL(3,$C$5:C7))","v":3},"هويدا محمد سيد احمد المصرى",null,"1984-09-01","1963-03-04",26303041400588,null,null,null,23,10,39,{"$f":"IF(F7<>\"\",IF(DAY(F7)>DAY($N$4),(DAY($N$4)+30)-DAY(F7),DAY($N$4)-DAY(F7)),\"\")","v":20},{"$f":"IF(F7 =\"\",\"\",DATEDIF(F7,$N$4,\"ym\"))","v":4},{"$f":"IF(F7 =\"\",\"\",DATEDIF(F7,$N$4,\"y\"))","v":61},{"$f":"DATE(YEAR(F7)+$S$4,MONTH(F7),DAY(F7))","v":"2023-03-04"},{"$f":"DATE(YEAR(F7)+$S$4,MONTH(F7),DAY(F7))","v":"2023-03-04"},{"$f":"Q7","v":"2023-03-04"},{"$f":"DAY(S7)","v":4},{"$f":"MONTH(S7)","v":3},{"$f":"YEAR(S7)","v":2023},{"$f":"T7+IF(T7>=$V$3,0,30)-$V$3","v":10},7,{"$f":"V7+IF(U7+IF(T7>=$V$3,0,-1)>=$W$3,0,-1)-$X$3","v":-2},{"$f":"IF(LEN(TRIM($G7))=0,\"\",IF(OR(NOT(ISNUMBER($G7)),LEN($G7)<>14),\"قومي خطأ\",IF(MOD(MID($G7,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($G7,3)","v":"ÇáÞáíæÈíÉ"}]
[null,{"$f":"IF(C8=\"\",\"\",SUBTOTAL(3,$C$5:C8))","v":4},"محمد موسى السيد موسى",null,"1987-11-01","1963-08-07",26308071701274,null,null,null,23,8,36,17,11,60,"2023-08-07","2023-08-07","2023-08-07",7,8,2023,13,0,-1,"ذكر","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C9=\"\",\"\",SUBTOTAL(3,$C$5:C9))","v":5},"خالد ابراهيم الدسوقى النادى",null,"1988-08-19","1965-04-03",26504031701216,null,null,null,5,11,35,21,3,59,"2025-04-03","2025-04-03","2025-04-03",3,4,2025,9,8,0,"ذكر","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C10=\"\",\"\",SUBTOTAL(3,$C$5:C10))","v":6},"فتحية فتوح عبد الله حسن",null,"1988-09-01","1968-03-14",26803140101765,null,null,null,23,10,35,10,4,56,"2028-03-14","2028-03-14","2028-03-14",14,3,2028,20,7,3,"انثى","ÇáÞÇåÑÉ"]
[null,{"$f":"IF(C11=\"\",\"\",SUBTOTAL(3,$C$5:C11))","v":7},"عبد الله عفيفى محمد عفيفى",null,"1988-11-01","1967-09-24",26709241701279,null,null,null,23,8,35,0,10,56,"2027-09-24","2027-09-24","2027-09-24",24,9,2027,0,2,3,"ذكر","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C12=\"\",\"\",SUBTOTAL(3,$C$5:C12))","v":8},"اشرف على عبدالعال هلال",null,"1988-12-29","1965-08-20",26508201701491,null,null,null,25,6,35,4,11,58,"2025-08-20","2025-08-20","2025-08-20",20,8,2025,26,0,1,"ذكر","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C13=\"\",\"\",SUBTOTAL(3,$C$5:C13))","v":9},"يسرية ابو الفتوح العجمى حسن عابدين",null,"1982-09-22",{"$f":"TEXT(LEFT(G13,7)+17000000,\"####-##-##\")+0","v":"1960-08-26"},26008261400749,null,null,null,2,10,41,28,10,63,"2020-08-26","2020-08-26","2020-08-26",26,8,2020,2,1,-4,"انثى","ÇáÞáíæÈíÉ"]
[null,{"$f":"IF(C14=\"\",\"\",SUBTOTAL(3,$C$5:C14))","v":10},"محمود محمود محمد عابدين",null,"1983-06-30","1960-02-22",26002221701217,null,null,null,24,0,41,2,5,64,"2020-02-22","2020-02-22","2020-02-22",22,2,2020,28,6,-5,"ذكر","ÇáãäæÝíÉ"]
[null,{"$f":"IF(C15=\"\",\"\",SUBTOTAL(3,$C$5:C15))","v":11},"كامليا ابراهيم ابوالعلا حماد",null,"1984-12-01","1960-11-19",26011191301285,null,null,null,23,7,39,5,8,63,"2020-11-19","2020-11-19","2020-11-19",19,11,2020,25,3,-4,"انثى","ÇáÔÑÞíÉ"]
[null,{"$f":"IF(C16=\"\",\"\",SUBTOTAL(3,$C$5:C16))","v":12},"وفاء عبدالقادر عبدالمطلب داود",null,"1991-03-06","1963-08-18",26308181302162,null,null,null,18,4,33,6,11,60,"2023-08-18","2023-08-18","2023-08-18",18,8,2023,24,0,-1,"انثى","ÇáÔÑÞíÉ"]
[null,{"$f":"IF(C17=\"\",\"\",SUBTOTAL(3,$C$5:C17))","v":13},"سامية ابراهيم الدسوقى محمد ابراهيم",null,"1996-02-01","1963-11-06",26311061701048,null,null,null,23,5,28,{"$f":"IF(F17<>\"\",IF(DAY(F17)>DAY($N$4),(DAY($N$4)+30)-DAY(F17),DAY($N$4)-DAY(F17)),\"\")","v":18},{"$f":"IF(F17 =\"\",\"\",DATEDIF(F17,$N$4,\"ym\"))","v":8},{"$f":"IF(F17 =\"\",\"\",DATEDIF(F17,$N$4,\"y\"))","v":60},{"$f":"DATE(YEAR(F17)+$S$4,MONTH(F17),DAY(F17))","v":"2023-11-06"},{"$f":"DATE(YEAR(F17)+$S$4,MONTH(F17),DAY(F17))","v":"2023-11-06"},{"$f":"Q17","v":"2023-11-06"},{"$f":"DAY(S17)","v":6},{"$f":"MONTH(S17)","v":11},{"$f":"YEAR(S17)","v":2023},{"$f":"T17+IF(T17>=$V$3,0,30)-$V$3","v":12},{"$f":"IF((IF(T17>=$V$3,0,-1)+U17)>=$W$3,(IF(T17>=$V$3,0,-1)+U17)-$W$3,(IF(T17>=$V$3,0,-1)+U17)+12-$W$3)","v":3},{"$f":"V17+IF(U17+IF(T17>=$V$3,0,-1)>=$W$3,0,-1)-$X$3","v":-1},{"$f":"IF(LEN(TRIM($G17))=0,\"\",IF(OR(NOT(ISNUMBER($G17)),LEN($G17)<>14),\"قومي خطأ\",IF(MOD(MID($G17,13,1),2)=1,\"ذكر\",\"انثى\")))","v":"انثى"},{"$f":"Kh_Date_Sex_Province($G17,3)","v":"ÇáãäæÝíÉ"}]