{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["ورقة1"],"not_rendered":{"charts":0,"images":0,"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":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,8,22,11],[19,8,19,9],[20,8,20,9],[26,8,26,11],[27,8,27,11],[20,10,20,11],[21,7,21,11],[23,7,24,7],[18,7,18,11],[19,10,19,11],[1,7,1,11],[1,1,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[14,8,14,11],[2,8,2,11],[3,8,3,11],[4,8,4,11],[5,8,5,11],[6,8,6,11],[7,8,7,11],[26,2,26,4],[27,2,27,4],[6,2,6,4],[21,1,21,4],[22,2,22,4],[23,1,24,1],[7,2,7,4],[14,2,14,4],[18,1,18,4],[19,3,19,4],[20,3,20,4]]}
[]
[null,"الترقيات بالمدة",null,null,null,null,null,"الترقيات بالمدة"]
[null,"عدد الترقيات التي تم الحصول عليها",2,null,null,null,null,"عدد الترقيات التي تم الحصول عليها",2]
[null,"تاريخ التعيين","2012-03-24",null,null,null,null,"تاريخ التعيين","2012-03-24"]
[null,"تاريخ قرار الترقية الأخيرة","2021-01-12",null,null,null,null,"تاريخ قرار الترقية الأخيرة","2021-01-12"]
[null,"تاريخ المحضر","2023-12-14",null,null,null,null,"تاريخ المحضر","2023-12-14"]
[null,"تاريخ اليوم بالهجري",{"$f":"TODAY()","v":"2023-12-06"},null,null,null,null,"تاريخ اليوم بالهجري",{"$f":"TODAY()","v":"2023-12-06"}]
[null,"تاريخ اليوم بالميلادي",{"$f":"TODAY()","v":"2023-12-06"},null,null,null,null,"تاريخ اليوم بالميلادي",{"$f":"TODAY()","v":"2023-12-06"}]
[null,"المدة","يوم","شهر ","سنة",null,null,"المدة","شهور","يوم","شهر ","سنة"]
[null,"من تاريخ التعيين إلى تاريخ قرار اخر ترقية",{"$f":"ROUNDDOWN(((((C5-C4)/354.36)-E10)-D10/12)*354.36,0)","v":26},{"$f":"ROUNDDOWN((((C5-C4)/354.36)-E10)*12,0)","v":0},{"$f":"ROUNDDOWN((C5-C4)/354.36,0)","v":9},null,null,"من تاريخ التعيين إلى تاريخ قرار اخر ترقية",{"$f":"(I5-I4)/(10631/30/12)","v":108.90414824569655},{"$f":"INT(MOD(I10,1)*30)","v":27},{"$f":"INT(MOD(I10,12))","v":0},{"$f":"INT(I10/12)","v":9}]
[null,"من آخر ترقية إلى تاريخ اليوم",{"$f":"ROUNDDOWN(((((C7-C5)/354.36)-E11)-D11/12)*354.36,0)","v":24},{"$f":"ROUNDDOWN((((C7-C5)/354.36)-E11)*12,0)","v":11},{"$f":"ROUNDDOWN((C7-C5)/354.36,0)","v":2},null,null,"من آخر ترقية إلى تاريخ اليوم",{"$f":"(I7-I5)/(10631/30/12)","v":35.82729752610291},{"$f":"INT(MOD(I11,1)*30)","v":24},{"$f":"INT(MOD(I11,12))","v":11},{"$f":"INT(I11/12)","v":2}]
[null,"من تاريخ التعيين حتى تاريخ اليوم",{"$f":"ROUNDDOWN(((((C7-C4)/354.36)-E12)-D12/12)*354.36,0)","v":21},{"$f":"ROUNDDOWN((((C7-C4)/354.36)-E12)*12,0)","v":0},{"$f":"ROUNDDOWN((C7-C4)/354.36,0)","v":12},null,null,"من تاريخ التعيين حتى تاريخ اليوم",{"$f":"(I7-I4)/(10631/30/12)","v":144.73144577179946},{"$f":"INT(MOD(I12,1)*30)","v":21},{"$f":"INT(MOD(I12,12))","v":0},{"$f":"INT(I12/12)","v":12}]
[null,"من تاريخ الترقية الأخيرة إلى تاريخ المحضر",{"$f":"ROUNDDOWN(((((C6-C5)/354.36)-E13)-D13/12)*354.36,0)","v":2},{"$f":"ROUNDDOWN((((C6-C5)/354.36)-E13)*12,0)","v":0},{"$f":"ROUNDDOWN((C6-C5)/354.36,0)","v":3},null,null,"من تاريخ الترقية الأخيرة إلى تاريخ المحضر",{"$f":"(I6-I5)/(10631/30/12)","v":36.098203367510109},2,0,3]
[null,"مدة التطويف",{"$f":"C10","v":26},{"$f":"D10","v":0},{"$f":"E10-C15","v":1},null,null,"مدة التطويف",{"$f":"I10-I15*12","v":12.904148245696547},27,0,1]
[null,"مجموع سنوات الترقيات الحاصل عليها",{"$f":"C3*4","v":8},null,null,null,null,"مجموع سنوات الترقيات الحاصل عليها",{"$f":"I3*4","v":8}]
[null,"أجمالي المدة بعد آخر ترقية مع التطويف",{"$f":"MOD(SUM(C14,C11),30)","v":20},{"$f":"MOD(SUM(D14,D11),13)+QUOTIENT(SUM(C14,C11),30)","v":12},{"$f":"SUM(E14,E11)+QUOTIENT(SUM(D14,D11),12)","v":3},null,null,"أجمالي المدة بعد آخر ترقية مع التطويف",{"$f":"I11+I14","v":48.731445771799457},21,{"$f":"INT(MOD(I16,12))","v":0},{"$f":"INT(I16/12)","v":4}]
[null,"باقي على الترقية القادمة",null,null,null,null,null,"باقي على الترقية القادمة",{"$f":" (4*12)-I16","v":-0.73144577179945713},{"$f":"INT(MOD(ABS(I17),1)*30)","v":21},{"$f":"INT(MOD(ABS(I17),12))","v":0},{"$f":"INT(ABS(I17)/12)","v":0},null,"اللون الأحمر عند تجاوز الأربع سنوات"]
[]
[null,"سنوات الخبرة المطلوبة للترقية بعد الحد الأدنى من التأهيل العلمي",null,null,null,null,null,"سنوات الخبرة المطلوبة للترقية بعد الحد الأدنى من التأهيل العلمي"]
[null,"المؤهل","المرتبة","سنوات الخبرة المطلوبة",null,null,null,"المؤهل","المرتبة",null,"سنوات الخبرة المطلوبة"]
[null,"بكالوريوس علمي",8,{"$f":"INDEX(D31:M41,MATCH(B21,B31:B41,0),MATCH(C21,D30:M30,0))","v":4},null,null,null,"بكالوريوس علمي",8,null,{"$f":"INDEX(D31:M41,MATCH(B21,B31:B41,0),MATCH(C21,D30:M30,0))","v":4}]
[null,"الترقيات بالمؤهل",null,null,null,null,null,"الترقيات بالمؤهل"]
[null,"تاريخ المؤهل الحالي","2020-09-20",null,null,null,null,"تاريخ المؤهل الحالي","2020-09-20"]
[null,"المدة","يوم","شهر","سنة",null,null,"المدة","شهور","يوم","شهر","سنة"]
[null,null,{"$f":"ROUNDDOWN(((((C7-C23)/354.36)-E25)-D25/12)*354.36,0)","v":20},{"$f":"ROUNDDOWN((((C7-C23)/354.36)-E25)*12,0)","v":3},{"$f":"ROUNDDOWN((C7-C23)/354.36,0)","v":3},null,null,null,{"$f":"(I7-I23)/(10631/30/12)","v":39.687705766155581},{"$f":"INT(MOD(I25,1)*30)","v":20},{"$f":"INT(MOD(I25,12))","v":3},{"$f":"INT(I25/12)","v":3}]
[]
[null,null,"محمد بن عياف السويلمي",null,null,null,null,null,"أبو أحمد"]
[null,null,506030860]
[]
[null,"الحد الأدنى من التأهيل العلمي","المرتبة",2,3,4,5,6,null,7,8,9,10]
[null,"الابتدائية",null,4,8,12,16,20,null,24,28,32,36]
[null,"الابتدائية مع القدرة لمن عين بالمرتبة 2",null,null,4,8,12,16,null,20,24,28,32]
[null,"الكفاءة",null,null,4,8,12,16,null,20,24,28,32]
[null,"الكفاءة مع القدرة لمن عين بالمرتبة 3",null,null,null,4,8,12,null,16,20,24,28]
[null,"الثانوية العامة",null,null,null,null,4,8,null,12,16,20,24]
[null,"دبلوم سنتين بعد الثانوية",null,null,null,null,null,4,null,8,12,16,20]
[null,"دبلوم سنتين بعد الثانوية لمن عين بالمرتبة 6",null,null,null,null,null,null,null,4,8,12,16]
[null,"بكالوريوس نظري",null,null,null,null,null,null,null,4,8,12,16]
[null,"بكالوريوس علمي",null,null,null,null,null,null,null,null,4,8,12]
[null,"الماجستير",null,null,null,null,null,null,null,null,null,4,8]
[null,"الدكتوراة",null,null,null,null,null,null,null,null,null,null,4]