{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"5","index":0,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,8,35,11],[29,8,29,11],[25,8,25,11],[30,8,31,11],[4,0,4,2],[7,0,7,2],[22,1,22,3],[23,1,23,3],[24,1,24,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[3,0,3,2],[6,0,6,2],[9,3,14,6],[5,0,5,2],[20,1,21,3],[20,4,20,6]]}
[]
[]
[null,null,null,"يوم","شهر","سنة"]
["تاريخ الميلاد",null,null,14,4,1943]
["سن التقاعد المعمول به",null,null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"60","v":60}]
["تاريخ التعيين",null,null,7,12,1967]
["تاريخ نهاية الخدمة (سن التقاعد)",null,null,{"$f":"EDATE(D4,+E5+(D5*12))-1","v":13},{"$f":"EDATE(E4,+E5+(E5*12))","v":4},{"$f":"EDATE(F4,+E5+(D5*12))+F5","v":2003}]
["مدة اشتراك فعلى",null,null,{"$f":"INT((((((DATE(F7,E7,D7)-DATE(F6,E6,D6))/365.25)-F8)*12)-E8)*30)","v":5},{"$f":"INT((((DATE(F7,E7,D7)-DATE(F6,E6,D6))/365.25)-F8)*12)","v":4},{"$f":"ROUNDDOWN((DATE(F7,E7,D7)-DATE(F6,E6,D6))/365.25,0)","v":35},"خطأ"]
[null,null,null,6,4,35,"الناتج الصح"]
[null,null,null,"ما زال هناك خطأ فى الدالة فعند تغيير المعطيات تعطى ناتج خطأ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"سبب صرف المعاش",null,null,"الوفاة (المنهية للخدمة)",null,null,null,null,null,null,null,null,null,"السطر","التاريخ",360,"365.2425"]
[null,null,null,null,"يوم","شهر","سنة",null,null,null,null,null,null,null,{"$f":"ROW()","v":22}]
[null,"تاريخ الميلاد",null,null,1,3,1953,null,null,null,null,null,null,{"$f":"B23","v":"تاريخ الميلاد"},{"$f":"ROW()","v":23},{"$f":"DATE(G23,F23,E23)","v":"1953-03-01"}]
[null,"سن التقاعد المعمول به",null,null,{"$f":"0","v":0},{"$f":"0","v":0},{"$f":"60","v":60},null,null,null,null,null,null,{"$f":"B24","v":"سن التقاعد المعمول به"},{"$f":"ROW()","v":24}]
[null,"تاريخ التعيين",null,null,{"$f":"1","v":1},{"$f":"9","v":9},{"$f":"1975","v":1975},null,null,null,null,null,null,"تاريخ التعيين",{"$f":"ROW()","v":25},{"$f":"DATE(G25,F25,E25)","v":"1975-09-01"}]
[null,"تاريخ بلوغ سن التقاعد",null,null,{"$f":"EDATE(E23,+F24+(E24*12))-1","v":0},{"$f":"EDATE(F23,+F24+(F24*12))","v":3},{"$f":"EDATE(G23,+F24+(E24*12))+G24","v":2013},"خطآ","الصواب 28     2     2013",null,null,null,null,"تاريخ بلوغ سن التقاعد",{"$f":"ROW()","v":26},{"$f":"DATE(G23+G24,F23,E23-1)","v":"2013-02-28"},{"$f":"GetDays360(P23,P26)/360","v":60},{"$f":"GetYears(P23,P26)","v":60}]
[null,"تاريخ نهاية الخدمة (وقوع الوفاة)",null,null,{"$f":"8","v":8},{"$f":"4","v":4},{"$f":"2010","v":2010},null,null,null,null,null,null,"تاريخ نهاية الخدمة (وقوع الوفاة)",{"$f":"ROW()","v":27},{"$f":"DATE(G27,F27,E27)","v":"2010-04-08"}]
[null,"تاريخ استحقاق المعاش",null,null,{"$f":"E27","v":8},{"$f":"F27","v":4},{"$f":"G27","v":2010},null,null,null,null,null,null,"تاريخ استحقاق المعاش",{"$f":"ROW()","v":28},{"$f":"DATE(G28,F28,E28)","v":"2010-04-08"}]
[null,"تاريخ استحقاق صرف المعاش",null,null,{"$f":"DATE(YEAR(E28),MONTH(E28),1)","v":1},{"$f":"EDATE(F23,+F24+(F24*12))","v":3},{"$f":"G27","v":2010},null,null,null,null,null,null,"تاريخ استحقاق صرف المعاش",{"$f":"ROW()","v":29},{"$f":"DATE(YEAR(P28),MONTH(P28)-1,1)","v":"2010-03-01"}]
[null,"مدة اشتراك فعلى",null,null,{"$f":"INT((((((DATE(G27,F27,E27)-DATE(G25,F25,E25))/365.25)-G30)*12)-F30)*30)","v":6},{"$f":"INT((((DATE(G27,F27,E27)-DATE(G25,F25,E25))/365.25)-G30)*12)","v":7},{"$f":"ROUNDDOWN((DATE(G27,F27,E27)-DATE(G25,F25,E25))/365.25,0)","v":34},"خطآ","الصواب 7     7     34",null,null,null,null,"مدة اشتراك فعلى",{"$f":"ROW()","v":30},null,{"$f":"GetDays360(P25,P27)/360","v":34.605555555555554},{"$f":"GetYears(P25,P27)","v":34.602739726027394}]
[null,"مدة افتراضية (3 سنوات او المدة المكملة ايهما افل)",null,null,{"$f":"INT(MOD((E26-E27),30))","v":22},{"$f":"IF(INT(MOD((F26-F27),12)+((E26-E27)/30))>12,(F26-F27)-12,INT(MOD((F26-F27),12)+((E26-E27)/30)))","v":10},{"$f":"INT((G26-G27)+((F26-F27)/12))","v":2},"خطآ","يجب ان لا تتخطى المدة 3 سنوات ةاذا تخطت يجب اختيار الاقل",null,null,null,null,"مدة افتراضية (3 سنوات او المدة المكملة ايهما افل)",{"$f":"ROW()","v":31},null,{"$f":" IF(GetDays360(P27,P26)/360>3,3,GetDays360(P27,P26)/360)","v":2.8972222222222221},{"$f":" IF(GetYears(P27,P26)>3,3,GetYears(P27,P26))","v":2.8958904109589043}]
[null,"اجمالى مدد الاشتراك",null,null,{"$f":"INT(MOD((E30+E31),30))","v":28},{"$f":"IF(INT(MOD((F30+F31),12)+((E30+E31)/30))>12,(F30+F31)-12,INT(MOD((F30+F31),12)+((E30+E31)/30)))","v":5},{"$f":"INT((G30+G31)+((F30+F31)/12))","v":37},null,null,null,null,null,null,"اجمالى مدد الاشتراك",{"$f":"ROW()","v":32},null,{"$f":"Q30+Q31","v":37.50277777777778},{"$f":"R30+R31","v":37.4986301369863}]
[null,"اجمالى مدد الاشتراك (بعد جبر كسر الشهر)",null,null,{"$f":"0","v":0},{"$f":"IF(F32+ROUNDUP(E32/30,0)>11,F32+ROUNDUP(E32/30,0)-12,F32+ROUNDUP(E32/30,0))","v":6},{"$f":"INT(G32+(F32+ROUNDUP(E32/30,0))/12)","v":37},{"$f":"SUM(G33+(F33/12))","v":37.5},null,null,null,null,null,"اجمالى مدد الاشتراك (بعد جبر كسر الشهر)",{"$f":"ROW()","v":33}]
[]
[null,null,null,null,null,null,null,null,"مع مراعاة اعتبار الشهر 30 يوم"]