{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"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":"Feuil1","index":0,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"عدد السنوات","عدد الشهور","المعامل","النتيجة",null,"عدد السنوات","عدد الشهور","المعامل","النتيجة"]
[null,6,null,0.02,{"$f":"B3*D3+(D3/12*C3)","v":0.12},null,6,null,0.02,{"$f":"G3*I3+(I3/12*H3)","v":0.12}]
[null,5,null,1.7999999999999999E-2,{"$f":"B4*D4+(D4/12*C4)","v":0.09},null,5,null,1.7999999999999999E-2,{"$f":"G4*I4+(I4/12*H4)","v":0.09}]
[null,10,null,1.4999999999999999E-2,0.15,null,10,null,1.4999999999999999E-2,0.15]
[null,4,1,0.04,{"$f":"B6*D6+(D6/12*C6)","v":0.16333333333333333},null,6,10,0.04,{"$f":"G6*I6+(I6/12*H6)","v":0.27333333333333332}]
[]
[null,{"$f":"SUM(B3:B7)","v":25},{"$f":"SUM(C3:C6)","v":1},null,{"$f":"SUM(E3:E6)","v":0.52333333333333332},null,{"$f":"SUM(G3:G7)","v":27},{"$f":"SUM(H3:H6)","v":10},null,{"$f":"SUM(J3:J6)","v":0.6333333333333333}]
[]
[null,null,null,null,null,null,null,"تحويل الكسور"]
[null,{"$f":" B8 & \".\" & C8","v":"25.1"},null,null,null,"المطلوب في الكود حساب الاعداد قبل الفاصلة سنوات",{"$f":" G8 & \".\" & H8","v":"27.10"},{"$f":" MID(G11,FIND(\".\",G11,1)+1,30)","v":"10"},"التحويل للشهور"]
[null,{"$f":"getIEP(B11)","v":0.52333333333333332},null,null,null,"و بعد الفاصلة شهور على حسب الامثلة",{"$f":"getIEP(G11)","v":0.6333333333333333},{"$f":"ROUND(MOD(G12*100,1)*100,0)","v":33},"التحويل للنسب المئوية"]
[null,{"$f":"calcIEP(B11)","v":0.52333333333333332},null,null,null,null,{"$f":"calcIEP(G11)","v":0.6333333333333333},{"$f":"ROUND(MOD(G13*100,1)*100,0)","v":33}]