{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":2,"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":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,1,4],[3,1,5,1],[9,3,9,4],[7,1,8,1],[11,1,11,4]]}
[null,"الرقم القومى وكيفية استخراج تاريخ الميلاد والسن والنوع ومحافظة الميلاد",null,null,null,null,null,"الكود","المحافظة"]
[null,null,null,null,null,"أدخل الرقم القومى",null,1,"القاهرة"]
[null,null,null,null,null,null,null,2,"الإسكندرية"]
[null,"تاريخ الميلاد","لمعرفة المتبقى","عدد أرقام الرقم القومى","الرقم القومى",null,null,3,"بورسعيد"]
[null,null,null,{"$f":"LEN(E5)","v":14},"27809161405435",null,null,4,"السويس"]
[null,null,{"$f":"IFERROR(IF(E5=\"\",\"\",DATE(IF(LEFT(E5,1)*1=3,20,19)&MID(E5,2,2),MID(E5,4,2),MID(E5,6,2))),\"\")","v":"1978-09-16"},"سن المعاش",{"$f":"IFERROR(IF(E5=\"\",\"\",IF(LEFT(E5)=\"2\",(YEAR(DATEVALUE(\"19\"&MID(E5,2,2)&\"/\"&MID(E5,4,2)&\"/\"&MID(E5,6,2)))+60)&\"/\"&MID(E5,4,2)&\"/\"&MID(E5,6,2),(YEAR(DATEVALUE(\"20\"&MID(E5,2,2)&\"/\"&MID(E5,4,2)&\"/\"&MID(E5,6,2)))+60)&\"/\"&MID(E5,4,2)&\"/\"&MID(E5,6,2))),\"\")","v":"2038/09/16"},null,null,11,"دمياط"]
[null,"الموافق",{"$f":"C6","v":"1978-09-16"},"الموافق هجريا",{"$f":"C6","v":"1978-09-16"},null,null,12,"الدقهلية"]
[null,"الســـن","يوم","شهر","سنة",null,null,13,"الشرقية"]
[null,null,{"$f":"IFERROR(DATEDIF(C6,TODAY(),\"md\"),\"\")","v":2},{"$f":"IFERROR(DATEDIF(C6,TODAY(),\"ym\"),\"\")","v":8},{"$f":"IFERROR(DATEDIF(C6,TODAY(),\"y\"),\"\")","v":40},null,null,14,"القليوبية"]
[null,"محل الميلاد",{"$f":"IFERROR(VLOOKUP(MID(E5,8,2)*1,$H$2:$I$29,2,0),\"\")","v":"القليوبية"},"حفظـــــــــــــــــــــــكم الله ورعاكــــــــــــــم ",null,null,null,15,"كفر الشيخ"]
[null,"النوع",{"$f":"IFERROR(IF(ISODD(MID(E5,13,1)),\"ذكر\",\"انثى\"),\"\")","v":"ذكر"},null,null,null,null,16,"الغربية"]
[null,"المتبقى له للخروج على سن المعاش ",null,null,null,null,null,17,"المنوفية"]
[null,"تاريخ اليوم","يوم","شهر","سنة",null,null,18,"البحيرة"]
[null,{"$f":"TODAY()","v":"2019-05-18"},{"$f":"DATEDIF(TODAY(),$E$6,\"md\")","v":29},{"$f":"DATEDIF(TODAY(),$E$6,\"ym\")","v":3},{"$f":"DATEDIF(TODAY(),$E$6,\"y\")","v":19},null,null,19,"الإسماعيلية"]
[null,null,null,null,null,null,null,21,"الجيزة"]
[null,null,null,null,null,null,null,22,"بني سويف"]
[null,null,null,null,null,null,null,23,"الفيوم"]
[null,null,null,null,null,null,null,24,"المنيا"]
[null,null,null,null,null,null,null,25,"أسيوط"]
[null,null,null,null,null,null,null,26,"سوهاج"]
[null,null,null,null,null,null,null,27,"قنا"]
[null,null,null,null,null,null,null,28,"أسوان"]
[null,null,null,null,null,null,null,29,"الأقصر"]
[null,null,null,null,null,null,null,31,"البحر الأحمر"]
[null,null,null,null,null,null,null,32,"الوادى الجديد"]
[null,null,null,null,null,null,null,33,"مطروح"]
[null,null,null,null,null,null,null,34,"شمال سيناء"]
[null,null,null,null,null,null,null,35,"جنوب سيناء"]
[null,null,null,null,null,null,null,88,"خارج الجمهورية"]