{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["سنين الرتب","بيانات المنتسب","ورقة3"],"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":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["الرتب","عدد سنين الخدمة المستخدمة"]
["مفوض1",33]
["مفوض2",30]
["مفوض3",27]
["مفوض4",24]
["مفوض5",21]
["مفوض6",18]
["مفوض7",15]
["مفوض8",12]
["ر.ع",9]
["عريف",6]
["ن.ع",3]
["شرطي أول",1]
["شرطي",0]

{"sheet":"بيانات المنتسب","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["الطباعة","الرتبة","الاسم الرباعي واللقب","عدد سنين الخدمة المستخدمة","امر التعيين","تاريخ امر التعيين","سنة التعيين","الخدمة الكلية","المتبقي من الخدمة سنين","تاريخ اخر ترقية","لغاية"]
[null,"مفوض1","Ali",{"$f":"VLOOKUP(B2,'سنين الرتب'!A2:B14,2,FALSE)","v":33},257,"2004-02-07","1984-03-07",{"$f":"IFERROR(IF(B2<>\"\",DATEDIF(G2,K2,\"y\")&\" سنة \"&DATEDIF(G2,K2,\"ym\")&\" شهرا \"&DATEDIF(G2,K2,\"md\")&\" يوما \",\"\"),\"\")","v":"34 سنة 10 شهرا 2 يوما "},{"$f":"IFERROR(IF(B2<>\"\",IF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\"))>DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATEDIF(DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),\"y\"),DATEDIF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),\"y\")*-1)&\" سنة \"&IF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\"))>DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATEDIF(DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),\"ym\"),DATEDIF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),\"ym\")*-1)&\" شهرا \"&IF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\"))>DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATEDIF(DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),\"md\"),DATEDIF(DATE(YEAR(G2) + DATEDIF(G2,K2,\"y\"), MONTH(G2)+DATEDIF(G2,K2,\"ym\"), DAY(G2)+DATEDIF(G2,K2,\"md\")),DATE(YEAR(G2) + D2, MONTH(G2), DAY(G2)),\"md\")*-1)&\" يوما \",\"\"),\"\")","v":"1 سنة 10 شهرا 2 يوما "},"2017-01-09","2019-01-09"]
[null,"مفوض5","Saad",{"$f":"VLOOKUP(B3,'سنين الرتب'!A3:B15,2,FALSE)","v":21},1594,"2006-06-12","1995-06-20",{"$f":"IFERROR(IF(B3<>\"\",DATEDIF(G3,K3,\"y\")&\" سنة \"&DATEDIF(G3,K3,\"ym\")&\" شهرا \"&DATEDIF(G3,K3,\"md\")&\" يوما \",\"\"),\"\")","v":"23 سنة 6 شهرا 20 يوما "},{"$f":"IFERROR(IF(B3<>\"\",IF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\"))>DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATEDIF(DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),\"y\"),DATEDIF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),\"y\")*-1)&\" سنة \"&IF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\"))>DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATEDIF(DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),\"ym\"),DATEDIF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),\"ym\")*-1)&\" شهرا \"&IF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\"))>DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATEDIF(DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),\"md\"),DATEDIF(DATE(YEAR(G3) + DATEDIF(G3,K3,\"y\"), MONTH(G3)+DATEDIF(G3,K3,\"ym\"), DAY(G3)+DATEDIF(G3,K3,\"md\")),DATE(YEAR(G3) + D3, MONTH(G3), DAY(G3)),\"md\")*-1)&\" يوما \",\"\"),\"\")","v":"2 سنة 6 شهرا 20 يوما "},"2016-10-26","2019-01-09"]
[null,"مفوض5","Laith",{"$f":"VLOOKUP(B4,'سنين الرتب'!A4:B16,2,FALSE)","v":21},1669,"2004-05-24","1997-01-09",{"$f":"IFERROR(IF(B4<>\"\",DATEDIF(G4,K4,\"y\")&\" سنة \"&DATEDIF(G4,K4,\"ym\")&\" شهرا \"&DATEDIF(G4,K4,\"md\")&\" يوما \",\"\"),\"\")","v":"22 سنة 6 شهرا 5 يوما "},{"$f":"IFERROR(IF(B4<>\"\",IF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\"))>DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATEDIF(DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),\"y\"),DATEDIF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),\"y\")*-1)&\" سنة \"&IF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\"))>DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATEDIF(DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),\"ym\"),DATEDIF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),\"ym\")*-1)&\" شهرا \"&IF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\"))>DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATEDIF(DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),\"md\"),DATEDIF(DATE(YEAR(G4) + DATEDIF(G4,K4,\"y\"), MONTH(G4)+DATEDIF(G4,K4,\"ym\"), DAY(G4)+DATEDIF(G4,K4,\"md\")),DATE(YEAR(G4) + D4, MONTH(G4), DAY(G4)),\"md\")*-1)&\" يوما \",\"\"),\"\")","v":"1 سنة 6 شهرا 5 يوما "},"2018-01-14","2019-07-14"]
[null,"مفوض6","Yasser",{"$f":"VLOOKUP(B5,'سنين الرتب'!A5:B17,2,FALSE)","v":18},2136,"2009-01-25","1997-06-09",{"$f":"IFERROR(IF(B5<>\"\",DATEDIF(G5,K5,\"y\")&\" سنة \"&DATEDIF(G5,K5,\"ym\")&\" شهرا \"&DATEDIF(G5,K5,\"md\")&\" يوما \",\"\"),\"\")","v":"21 سنة 7 شهرا 0 يوما "},{"$f":"IFERROR(IF(B5<>\"\",IF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\"))>DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATEDIF(DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),\"y\"),DATEDIF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),\"y\")*-1)&\" سنة \"&IF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\"))>DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATEDIF(DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),\"ym\"),DATEDIF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),\"ym\")*-1)&\" شهرا \"&IF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\"))>DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATEDIF(DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),\"md\"),DATEDIF(DATE(YEAR(G5) + DATEDIF(G5,K5,\"y\"), MONTH(G5)+DATEDIF(G5,K5,\"ym\"), DAY(G5)+DATEDIF(G5,K5,\"md\")),DATE(YEAR(G5) + D5, MONTH(G5), DAY(G5)),\"md\")*-1)&\" يوما \",\"\"),\"\")","v":"3 سنة 7 شهرا 0 يوما "},"2017-01-09","2019-01-09"]
[null,"مفوض8","Amjad",{"$f":"VLOOKUP(B6,'سنين الرتب'!A6:B18,2,FALSE)","v":12},257,"2004-02-07","2004-03-07",{"$f":"IFERROR(IF(B6<>\"\",DATEDIF(G6,K6,\"y\")&\" سنة \"&DATEDIF(G6,K6,\"ym\")&\" شهرا \"&DATEDIF(G6,K6,\"md\")&\" يوما \",\"\"),\"\")","v":"14 سنة 10 شهرا 2 يوما "},{"$f":"IFERROR(IF(B6<>\"\",IF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\"))>DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATEDIF(DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),\"y\"),DATEDIF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),\"y\")*-1)&\" سنة \"&IF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\"))>DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATEDIF(DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),\"ym\"),DATEDIF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),\"ym\")*-1)&\" شهرا \"&IF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\"))>DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATEDIF(DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),\"md\"),DATEDIF(DATE(YEAR(G6) + DATEDIF(G6,K6,\"y\"), MONTH(G6)+DATEDIF(G6,K6,\"ym\"), DAY(G6)+DATEDIF(G6,K6,\"md\")),DATE(YEAR(G6) + D6, MONTH(G6), DAY(G6)),\"md\")*-1)&\" يوما \",\"\"),\"\")","v":"2 سنة 10 شهرا 2 يوما "},"2016-04-17","2019-01-09"]

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