{"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":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,9,3],[7,4,7,6],[2,2,2,3],[10,1,10,3],[10,4,10,6],[1,9,1,11],[7,9,7,11],[7,13,7,15],[10,9,10,11],[10,13,10,15],[2,13,2,15],[2,9,2,11]]}
[]
[null,null,null,null,null,null,null,null,null,{"$f":"365.2425/354.366666666667","v":1.0306909039601155}]
[null,"الاسم","محمد بن عياف عايد العنزي",null,"يوم","شهر","سنة","أجمالي الأيام",null,"تقريبي",null,null,null,"أكواد أم القرى مع تصرف"]
[null,"المعلومات","التواريخ","مدة الخدمة إلى تاريخ قرار الترقية الاخيرة",{"$f":"ROUNDDOWN(((((C6-C5)/354.36)-G4)-F4/12)*354.36,0)","v":23},{"$f":"ROUNDDOWN((((C6-C5)/354.36)-G4)*12,0)","v":3},{"$f":"ROUNDDOWN((C6-C5)/354.36,0)","v":9},null,null,{"$f":"DATEDIF(C5*$J$2,C6*$J$2,\"md\")","v":23},{"$f":"DATEDIF(C5*$J$2,C6*$J$2,\"ym\")","v":3},{"$f":"DATEDIF(C5*$J$2,C6*$J$2,\"y\")","v":9},null,{"$f":"UmDateDiff(\"md\",C5,C6)","v":24},{"$f":"UmDateDiff(\"ym\",C5,C6)","v":3},{"$f":"UmDateDiff(\"yy\",C5,C6)","v":9}]
[null,"تاريخ التعيين","2012-03-24","المدة بعد آخر ترقية إلى تاريخ اليوم",{"$f":"ROUNDDOWN(((((C8-C6)/354.36)-G5)-F5/12)*354.36,0)","v":20},{"$f":"ROUNDDOWN((((C8-C6)/354.36)-G5)*12,0)","v":5},{"$f":"ROUNDDOWN((C8-C6)/354.36,0)","v":1},null,null,{"$f":"DATEDIF(C6*$J$2,C8*$J$2,\"md\")","v":23},{"$f":"DATEDIF(C6*$J$2,C8*$J$2,\"ym\")","v":5},{"$f":"DATEDIF(C6*$J$2,C8*$J$2,\"y\")","v":1},null,{"$f":"UmDateDiff(\"md\",C6,C8)","v":21},{"$f":"UmDateDiff(\"ym\",C6,C8)","v":5},{"$f":"UmDateDiff(\"yy\",C6,C8)","v":1}]
[null,"تاريخ قر ار الترقية الأخيرة","2021-04-07","مدة الخدمة كاملة",{"$f":"ROUNDDOWN(((((C8-C5)/354.36)-G6)-F6/12)*354.36,0)","v":14},{"$f":"ROUNDDOWN((((C8-C5)/354.36)-G6)*12,0)","v":9},{"$f":"ROUNDDOWN((C8-C5)/354.36,0)","v":10},null,null,{"$f":"DATEDIF(C5*$J$2,C8*$J$2,\"md\")","v":15},{"$f":"DATEDIF(C5*$J$2,C8*$J$2,\"ym\")","v":9},{"$f":"DATEDIF(C5*$J$2,C8*$J$2,\"y\")","v":10},null,{"$f":"UmDateDiff(\"md\",C5,C8)","v":15},{"$f":"UmDateDiff(\"ym\",C5,C8)","v":9},{"$f":"UmDateDiff(\"yy\",C5,C8)","v":10}]
[null,"تاريخ المحضر","2023-07-19","مدة التطويف",{"$f":"E4","v":23},{"$f":"F4","v":3},{"$f":"G4-E8","v":1},null,null,{"$f":"J4","v":23},{"$f":"K4","v":3},{"$f":"L4-J8","v":1},null,{"$f":"N4","v":24},{"$f":"O4","v":3},{"$f":"P4-N8","v":1}]
[null,"تاريخ اليوم","2022-09-12","مجموع سنوات الترقيات الحاصل عليها",{"$f":"C9*4","v":8},null,null,null,null,{"$f":"C9*4","v":8},null,null,null,{"$f":"C9*4","v":8}]
[null,"عدد الترقيات الحاصل عليها",2,"أجمالي المدة بعد آخر ترقية مع التطويف",{"$f":"MOD(SUM(E7,E5),30)","v":13},{"$f":"MOD(SUM(F7,F5),13)+QUOTIENT(SUM(E7,E5),30)","v":9},{"$f":"SUM(G7,G5)+QUOTIENT(SUM(F7,F5),12)","v":2},null,null,{"$f":"MOD(SUM(J7,J5),30)","v":16},{"$f":"MOD(SUM(K7,K5),13)+QUOTIENT(SUM(J7,J5),30)","v":9},{"$f":"SUM(L7,L5)+QUOTIENT(SUM(K7,K5),12)","v":2},null,{"$f":"MOD(SUM(N7,N5),30)","v":15},{"$f":"MOD(SUM(O7,O5),13)+QUOTIENT(SUM(N7,N5),30)","v":9},{"$f":"SUM(P7,P5)+QUOTIENT(SUM(O7,O5),12)","v":2}]
[null,"باقي على الترقية القادمة",null,null,{"$f":"30-E9","v":17},{"$f":"12-F9","v":3},{"$f":"4-G9","v":2},{"$f":"G10*354.36+F10*12+E10*30","v":1254.72},null,{"$f":"30-J9","v":14},{"$f":"12-K9","v":3},{"$f":"4-L9","v":2},null,{"$f":"30-N9","v":15},{"$f":"12-O9","v":3},{"$f":"4-P9","v":2}]
[null,"تاريخ الاستحقاق",null,null,{"$f":" UmDateAdd(\"d\",E10, UmDateAdd(\"m\",F9, UmDateAdd(\"yyyy\",G9,C8)), FALSE)","v":"2025-05-31"},null,null,null,null,{"$f":" UmDateAdd(\"d\",J10, UmDateAdd(\"m\",K9, UmDateAdd(\"yyyy\",L9,C8)), FALSE)","v":"2025-05-28"},null,null,null,{"$f":" UmDateAdd(\"d\",N10, UmDateAdd(\"m\",O9, UmDateAdd(\"yyyy\",P9,C8)), FALSE)","v":"2025-05-29"}]
[]
[null,null,null,"محمد عياف السويلمي"]
[null,null,null,506030860]