{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["تنبيه","مخطط1","ورقة1"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"مخطط1","index":1,"reason":"not_a_worksheet"}],"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":"تنبيه","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,1048575,16383]]}

{"sheet":"ورقة1","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,2,2,4]]}
["الراتب الحالي"]
["قبل ترفيعة 2020",{"$f":"B1/1.09","v":0}]
["قبل زيادة 2019",{"$f":"B2-31500","v":-31500},"مقدار الترفيعات",null,null,"اراتب بعد الترفيع"]
["قبل ترفيعة 2018",{"$f":"B3/1.09","v":-28899.082568807338},null,{"$f":"ROUNDUP(F5*9%/720*C4,0.2)","v":0},2020,{"$f":"ROUNDUP(F5+D4,0.2)","v":0}]
["قبل ترفيعة 2016",{"$f":"B4/1.09","v":-26512.919787896637},null,{"$f":"ROUNDUP(F6*9%/720*C5,0.2)","v":0},2018,{"$f":"ROUNDUP(F6+D5,0.2)","v":0}]
["قبل زيادة 2015",{"$f":"B5-2500","v":-29012.919787896637},null,{"$f":"ROUNDUP(F7*9%/720*C6,0.2)","v":0},2016,{"$f":"ROUNDUP(F7+D6,0.2)","v":0}]
["قبل ترفيعة 2014",{"$f":"B6/1.09","v":-26617.357603574896},null,{"$f":"IF(A9=\"\",\"\",ROUNDUP(F11*9%/720*C7,0.2))","v":0},2014,{"$f":"ROUNDUP(F11+D7,0.2)","v":0}]
["الراتب الاساسي","مافوق 37000","الشريحة 1","بين26001ال37000","الشريحة 2","بين 14001الى 26000"]
[{"$f":"B7","v":-26617.357603574896},{"$f":"IF(A9>37000,A9-37000,0)","v":0},{"$f":"IF(A9>37000,B9/1.05,0)","v":0},{"$f":"IF(A9>26000,A9-B9-26000,0)","v":0},{"$f":"IF(A9>26000,D9/1.1,0)","v":0},{"$f":"IF(A9>14000,(A9-D9-B9-14000),0)","v":0}]
["الشريحة 3","اقل او يساوي 14000","الشريحة 4","اقل او يساوي 12000","الشريحة5","قبل الزيادة"]
[{"$f":"IF(A9>14000,F9/1.2,0)","v":0},{"$f":"IF(A9>14000,(A9-D9-B9-F9),0)","v":0},{"$f":"IF(A9>14000,B11/1.4,0)","v":0},{"$f":"IF(A9>12000,(A9-D9-B9-F9-B11),0)","v":0},{"$f":"IF(D11>12000,D11/1.4,0)","v":0},{"$f":"IF(A9=\"\",\"\",ROUNDUP(E11+C11+A11+E9+C9,0.2))","v":0}]
[]
[null,null,null,null,"اذن السفر",{"$f":"IF(F4=\"\",\"\",ROUNDUP(F4/30+536,0.2))","v":536}]
[null,null,"عدد ايام اذن السفر",null,"مجموع الاذونات",{"$f":"IF(D14=\"\",\"\",ROUNDUP(F13*D14,0.2))","v":""}]
[]
[null,null,null,null,"الجولة",{"$f":"IF(F4=\"\",\"\",ROUNDUP(F4*1.5%,0.2))","v":0}]
[null,null,"عدد الجولات",null,"مجموع الجولات",{"$f":"IF(D17=\"\",\"\",ROUNDUP(D17*F16,0.2))","v":""}]