{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["civilian"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3,"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":"civilian","index":0,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,5,11,10],[12,5,12,10],[13,5,13,10]]}
["م","درجة","اساسي","طبيعة العمل ","مواصلات","نثرية"]
[1,"مدير D",3330,0.15,1500,0,null,null,null,"الراتب الاساسي",{"$f":"C14","v":4410}]
[2,"مدير C ",4410,0.2,1500,0,null,null,null,"تاريخ التعيين",{"$f":"E11","v":"2010-09-01"}]
[3,"مدير B",4590,0.25,1500,0,null,null,null,"تاريخ استحقاق اخر العلاوة ",{"$f":"IF(DATE(YEAR(TODAY()),MONTH(K3),DAY(K3))>TODAY(),DATE(YEAR(TODAY())-1,MONTH(K3),DAY(K3)),DATE(YEAR(TODAY()),MONTH(K3),DAY(K3)))","v":"2019-09-01"}]
[4,"مدير A",5570,0.3,1500,0,null,null,null,"نسبة العلاوة",1.2500000000000001E-2]
[5,"مدير عام",6720,0.35,2000,0,null,10,null,"العلاوة الدورية ",{"$f":"(((1+K5)^YEARFRAC(K3,K4))-1)*K2","v":521.66850253765301}]
[6,"وكيل مساعد",7830,0.4,0,2000,null,2]
[7,"وكيل",8960,0.45,0,2000]
[]
[]
[null,null,null,"تاريخ التعيين","2010-09-01","                            السلام عليكم اذا ممكن مساعدتي في تحويل الشيت (الجزء الملون بالازرق) الى فورم                       "]
[]
[null,null,null,null,null,"عمل المثال يقوم على اختيار الدرجة من (الجزء الملون بالازرق ) ومن ثم ادخال تاريخ التعيين "]
[null,"الراتب الاساسي",{"$f":"LOOKUP(H7,A2:A8,C2:C8)","v":4410},null,null,"يظهر تلقائي الراتب الاساسي ومن ثم العلاوة السنوية "]
[null,"العلاوة السنوية",{"$f":"K6","v":521.66850253765301}]