{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":233,"n_cols":9,"rows_kept":233,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Enter ID","تاريخ آخر زيادة","راتب أساسي","بدل سكن","بدل نقل","بدلات إضافية","قيمة الزيادة"]
[null,1007,"2015-01-02","C",2500,800,"J",40]
[]
[]
[]
[]
["EMP ID","Effective Date","Vacation","راتب أساسي","بدل سكن","بدل نقل","بدلات إضافية","الإجمالي"]
[1004,"1994-11-17",25,3375,0,700,"Ok1",{"$f":"SUM(D9:G9)","v":4075}]
[1004,"2015-03-19",25,2250,0,0,"Ok2",{"$f":"SUM(D10:G10)","v":2250}]
[1004,"2015-07-01",25,2250,563,700,"Ok3",{"$f":"SUM(D11:G11)","v":3513}]
[1004,"2016-05-01",25,2250,563,700,"Ok3",{"$f":"SUM(D12:G12)","v":3513}]
[1004,"2017-03-19",25,2250,563,700,"Ok4",{"$f":"SUM(D13:G13)","v":3513}]
[1007,"1995-04-01",25,45000,15000,1000,40000,{"$f":"SUM(D14:G14)","v":101000}]
[1007,"2014-06-01",25,45000,15000,1000,40000,{"$f":"SUM(D15:G15)","v":101000}]
[1007,"2015-02-01",25,"A",15000,1000,75000,{"$f":"SUM(D16:G16)","v":91000}]
[1007,"2015-02-01",25,"B",15000,1000,75000,{"$f":"SUM(D17:G17)","v":91000}]
[1015,"1994-12-01",null,3836,959,700,"A",{"$f":"SUM(D18:G18)","v":5495}]
[1015,"2014-07-01",null,5000,1250,700,"B",{"$f":"SUM(D19:G19)","v":6950}]
[1015,"2015-12-01",null,5954,1488,700,"C",{"$f":"SUM(D20:G20)","v":8142}]
[1015,"2019-07-25",null,5954,1488,700,"D",{"$f":"SUM(D21:G21)","v":8142}]
[1015,"2020-02-18",null,5954,1488,700,"E",{"$f":"SUM(D22:G22)","v":8142}]
[1027,"2014-04-15",null,4382,0,0,"F",{"$f":"SUM(D23:G23)","v":4382}]
[1027,"2014-04-16",null,4382,1096,0,"G",{"$f":"SUM(D24:G24)","v":5478}]
[1078,"2011-09-20",null,3000,0,0,"H",{"$f":"SUM(D25:G25)","v":3000}]
[1117,"1995-12-12",null,9600,2400,800,"I",{"$f":"SUM(D26:G26)","v":12800}]
[1007,"2015-02-01",40,"C",2500,800,"J",{"$f":"SUM(D27:G27)","v":3300}]
[1124,"1995-12-01",null,23950,3750,1000,"K",{"$f":"SUM(D28:G28)","v":28700}]
[1124,"2014-06-01",null,24800,3750,1000,"L",{"$f":"SUM(D29:G29)","v":29550}]
[1124,"2019-02-01",null,27575,3750,1000,"M",{"$f":"SUM(D30:G30)","v":32325}]
[1150,"1995-12-21",null,18500,3750,1000,"N",{"$f":"SUM(D31:G31)","v":23250}]
[1150,"2014-02-23",null,21105,3750,1000,"O",{"$f":"SUM(D32:G32)","v":25855}]
[1150,"2018-09-01",null,21105,3750,1000,"P",{"$f":"SUM(D33:G33)","v":25855}]
[1160,"1996-05-04",null,11000,3000,800,"Q",{"$f":"SUM(D34:G34)","v":14800}]
[1160,"2013-05-04",null,12400,3000,800,"R",{"$f":"SUM(D35:G35)","v":16200}]
[1160,"2015-05-04",null,12400,3000,800,"S",{"$f":"SUM(D36:G36)","v":16200}]
[1160,"2019-02-01",null,13650,3000,800,"T",{"$f":"SUM(D37:G37)","v":17450}]
[1161,"1996-07-01",null,5209,1302,700,"U",{"$f":"SUM(D38:G38)","v":7211}]
[1161,"2014-06-01",null,5209,1302,700,"V",{"$f":"SUM(D39:G39)","v":7211}]
[1161,"2014-07-06",null,5250,1313,700,"W",{"$f":"SUM(D40:G40)","v":7263}]
[1176,"1996-10-27",null,4125,1031,700,"X",{"$f":"SUM(D41:G41)","v":5856}]
[1176,"2014-06-01",null,4125,1031,700,"Y",{"$f":"SUM(D42:G42)","v":5856}]
[1176,"2020-03-25",null,4125,1031,700,"Z",{"$f":"SUM(D43:G43)","v":5856}]
[1191,"2017-07-01",null,12920,3000,800,"A",{"$f":"SUM(D44:G44)","v":16720}]
[1199,"1997-09-02",null,4287,1072,700,"B",{"$f":"SUM(D45:G45)","v":6059}]
[1199,"2013-10-26",null,5250,1313,700,"C",{"$f":"SUM(D46:G46)","v":7263}]
[1199,"2014-06-01",null,5250,1313,700,"D",{"$f":"SUM(D47:G47)","v":7263}]
[1199,"2015-03-01",null,5250,1313,700,"E",{"$f":"SUM(D48:G48)","v":7263}]
[1199,"2015-10-26",null,5350,1338,700,"F",{"$f":"SUM(D49:G49)","v":7388}]
[1207,"1996-11-23",null,1931,483,600,"G",{"$f":"SUM(D50:G50)","v":3014}]
[1207,"2014-11-23",null,2389,597,700,"H",{"$f":"SUM(D51:G51)","v":3686}]
[1207,"2019-02-01",null,2689,597,700,"I",{"$f":"SUM(D52:G52)","v":3986}]
[1208,"1997-07-05",null,2900,725,700,"J",{"$f":"SUM(D53:G53)","v":4325}]
[1208,"2014-06-01",null,2900,725,700,"K",{"$f":"SUM(D54:G54)","v":4325}]
[1208,"2015-08-05",null,3581,725,700,"L",{"$f":"SUM(D55:G55)","v":5006}]
[1208,"2015-10-01",null,3581,895,700,"M",{"$f":"SUM(D56:G56)","v":5176}]
[1208,"2015-11-01",null,3581,895,700,"N",{"$f":"SUM(D57:G57)","v":5176}]
[1216,"1997-10-20",null,7210,2163,800,"O",{"$f":"SUM(D58:G58)","v":10173}]
[1216,"2014-11-20",null,8250,2475,800,"P",{"$f":"SUM(D59:G59)","v":11525}]
[1216,"2016-09-01",null,8250,0,800,"Q",{"$f":"SUM(D60:G60)","v":9050}]
[1216,"2018-05-01",null,8625,0,800,"R",{"$f":"SUM(D61:G61)","v":9425}]
[1245,"1997-11-17",null,4804,1201,700,"S",{"$f":"SUM(D62:G62)","v":6705}]
[1245,"2013-12-17",null,5250,1313,700,"T",{"$f":"SUM(D63:G63)","v":7263}]
[1245,"2014-06-01",null,5250,1313,700,"U",{"$f":"SUM(D64:G64)","v":7263}]
[1245,"2015-12-17",null,5250,1313,700,"V",{"$f":"SUM(D65:G65)","v":7263}]
[1245,"2020-12-01",null,5250,1313,700,"W",{"$f":"SUM(D66:G66)","v":7263}]
[1273,"1998-06-20",null,5680,1420,700,"X",{"$f":"SUM(D67:G67)","v":7800}]
[1273,"2014-06-01",null,5680,1420,700,"Y",{"$f":"SUM(D68:G68)","v":7800}]
[1273,"2014-06-20",null,8115,2435,800,"Z",{"$f":"SUM(D69:G69)","v":11350}]
[1275,"2019-02-01",null,9115,2935,800,"A",{"$f":"SUM(D70:G70)","v":12850}]
[1276,"1998-08-01",null,6500,1666,700,"B",{"$f":"SUM(D71:G71)","v":8866}]
[1276,"2014-01-01",null,6750,1666,700,"C",{"$f":"SUM(D72:G72)","v":9116}]
[1276,"2014-02-01",null,6750,1500,700,"D",{"$f":"SUM(D73:G73)","v":8950}]
[1276,"2014-06-01",null,6750,1666,700,"E",{"$f":"SUM(D74:G74)","v":9116}]
[1290,"1998-10-19",null,22450,3750,1000,"F",{"$f":"SUM(D75:G75)","v":27200}]
[1291,"1998-10-22",null,3825,956,700,"G",{"$f":"SUM(D76:G76)","v":5481}]
[1291,"2014-06-01",null,3825,956,700,"H",{"$f":"SUM(D77:G77)","v":5481}]
[1291,"2014-10-22",null,4125,1031,700,"I",{"$f":"SUM(D78:G78)","v":5856}]
[1291,"2015-11-01",null,4125,1031,700,"J",{"$f":"SUM(D79:G79)","v":5856}]
[1291,"2019-02-01",null,4305,1121,700,"K",{"$f":"SUM(D80:G80)","v":6126}]
[1295,"1998-10-17",null,6640,1660,700,"L",{"$f":"SUM(D81:G81)","v":9000}]
[1295,"2014-11-03",null,7500,1667,700,"M",{"$f":"SUM(D82:G82)","v":9867}]
[1295,"2015-12-21",null,7500,1667,700,"N",{"$f":"SUM(D83:G83)","v":9867}]
[1375,"1999-03-13",null,4480,0,700,"O",{"$f":"SUM(D84:G84)","v":5180}]
[1375,"2014-06-01",null,4480,0,700,"P",{"$f":"SUM(D85:G85)","v":5180}]
[1375,"2014-08-21",null,4480,1000,700,"Q",{"$f":"SUM(D86:G86)","v":6180}]
[1375,"2015-03-28",null,5392,1348,700,"R",{"$f":"SUM(D87:G87)","v":7440}]
[1382,"1999-04-05",null,1015,300,600,"S",{"$f":"SUM(D88:G88)","v":1915}]
[1382,"2014-06-01",null,1015,300,600,"T",{"$f":"SUM(D89:G89)","v":1915}]
[1382,"2015-03-01",null,1015,300,600,"U",{"$f":"SUM(D90:G90)","v":1915}]
[1382,"2015-04-05",null,1015,300,600,"V",{"$f":"SUM(D91:G91)","v":1915}]
[1391,"2014-09-13",null,30450,3750,1000,"W",{"$f":"SUM(D92:G92)","v":35200}]
[1399,"1999-04-18",null,2889,722,700,"X",{"$f":"SUM(D93:G93)","v":4311}]
[1399,"2014-04-01",null,3733,933,700,"Y",{"$f":"SUM(D94:G94)","v":5366}]
[1399,"2014-05-31",null,3733,933,700,"Z",{"$f":"SUM(D95:G95)","v":5366}]
[1399,"2014-06-01",null,3733,933,700,"B1",{"$f":"SUM(D96:G96)","v":5366}]
[1399,"2015-10-01",null,3733,933,700,"B2",{"$f":"SUM(D97:G97)","v":5366}]
[1399,"2016-04-01",null,4125,1031,700,"B3",{"$f":"SUM(D98:G98)","v":5856}]
[1399,"2020-12-01",null,5000,1250,700,"B4",{"$f":"SUM(D99:G99)","v":6950}]
[1409,"1999-06-05",null,1015,300,600,"B5",{"$f":"SUM(D100:G100)","v":1915}]
[1409,"2014-06-01",null,1015,300,600,"B6",{"$f":"SUM(D101:G101)","v":1915}]
[1409,"2017-05-01",null,1015,300,600,"B7",{"$f":"SUM(D102:G102)","v":1915}]
[1416,"1999-05-01",null,900,150,350,"B8",{"$f":"SUM(D103:G103)","v":1400}]
[1416,"2014-08-01",null,1537,787,350,"B9",{"$f":"SUM(D104:G104)","v":2674}]
[1417,"1999-05-04",null,4726,1181,700,"B10",{"$f":"SUM(D105:G105)","v":6607}]
[1417,"2014-06-01",null,4726,1181,700,"B11",{"$f":"SUM(D106:G106)","v":6607}]
[1417,"2015-05-14",null,5250,1313,700,"B12",{"$f":"SUM(D107:G107)","v":7263}]
[1417,"2019-02-01",null,5956,1666,700,"B13",{"$f":"SUM(D108:G108)","v":8322}]
[1417,"2019-03-01",null,5956,1666,700,"B14",{"$f":"SUM(D109:G109)","v":8322}]
[1435,"1999-06-03",null,2575,0,0,"B15",{"$f":"SUM(D110:G110)","v":2575}]
[1435,"2014-06-01",null,2575,0,0,"B16",{"$f":"SUM(D111:G111)","v":2575}]
[1435,"2015-06-03",null,3248,0,0,"B17",{"$f":"SUM(D112:G112)","v":3248}]
[1435,"2020-12-01",null,3248,0,0,"B18",{"$f":"SUM(D113:G113)","v":3248}]
[1449,"1999-10-09",null,25750,0,1000,"B19",{"$f":"SUM(D114:G114)","v":26750}]
[1449,"2013-10-09",null,25750,3750,1000,"B20",{"$f":"SUM(D115:G115)","v":30500}]
[1449,"2015-10-09",null,25750,3750,1000,"B21",{"$f":"SUM(D116:G116)","v":30500}]
[1449,"2019-02-01",null,26750,3750,1000,"B22",{"$f":"SUM(D117:G117)","v":31500}]
[1462,"1999-11-06",null,10850,2500,800,"B23",{"$f":"SUM(D118:G118)","v":14150}]
[1462,"2014-03-06",null,14500,2500,800,"B24",{"$f":"SUM(D119:G119)","v":17800}]
[1462,"2017-07-01",null,14500,2500,800,"B25",{"$f":"SUM(D120:G120)","v":17800}]
[1483,"2000-01-01",null,45000,15000,1000,"B26",{"$f":"SUM(D121:G121)","v":61000}]
[1483,"2014-06-01",null,45000,15000,1000,"B27",{"$f":"SUM(D122:G122)","v":61000}]
[1483,"2015-02-01",null,45000,15000,1000,"B28",{"$f":"SUM(D123:G123)","v":61000}]
[1543,"2000-09-03",null,3609,902,700,"B29",{"$f":"SUM(D124:G124)","v":5211}]
[1543,"2014-09-17",null,4278,1070,700,"B30",{"$f":"SUM(D125:G125)","v":6048}]
[1547,"2014-09-17",null,4036,1009,700,"B31",{"$f":"SUM(D126:G126)","v":5745}]
[1567,"2001-01-02",null,6294,1574,700,"B32",{"$f":"SUM(D127:G127)","v":8568}]
[1567,"2014-06-01",null,6294,1574,700,"B33",{"$f":"SUM(D128:G128)","v":8568}]
[1579,"2000-11-12",null,1885,377,600,"B34",{"$f":"SUM(D129:G129)","v":2862}]
[1579,"2015-09-01",null,1885,377,600,"B35",{"$f":"SUM(D130:G130)","v":2862}]
[1579,"2017-03-01",null,1885,377,600,"B36",{"$f":"SUM(D131:G131)","v":2862}]
[1598,"2001-02-25",null,2365,591,700,"B37",{"$f":"SUM(D132:G132)","v":3656}]
[1598,"2015-09-01",null,2365,591,700,"B38",{"$f":"SUM(D133:G133)","v":3656}]
[1598,"2016-02-28",null,2365,591,700,"B39",{"$f":"SUM(D134:G134)","v":3656}]
[1598,"2018-05-01",null,2365,591,700,"B40",{"$f":"SUM(D135:G135)","v":3656}]
[1614,"2001-03-15",null,35000,6000,1000,"B41",{"$f":"SUM(D136:G136)","v":42000}]
[1614,"2015-02-01",null,35000,6000,1000,"B42",{"$f":"SUM(D137:G137)","v":42000}]
[1614,"2018-01-01",null,38000,7000,1000,"B43",{"$f":"SUM(D138:G138)","v":46000}]
[1614,"2019-02-01",null,40500,7000,1000,"B44",{"$f":"SUM(D139:G139)","v":48500}]
[1614,"2019-12-01",null,45000,7000,1000,"B45",{"$f":"SUM(D140:G140)","v":53000}]
[1615,"2001-03-26",null,7000,1667,700,"B46",{"$f":"SUM(D141:G141)","v":9367}]
[1615,"2013-03-26",null,8000,1667,700,"B47",{"$f":"SUM(D142:G142)","v":10367}]
[1615,"2014-06-01",null,8000,1667,700,"B48",{"$f":"SUM(D143:G143)","v":10367}]
[1615,"2015-03-26",null,9770,2500,800,"B49",{"$f":"SUM(D144:G144)","v":13070}]
[1637,"2001-04-16",null,5440,1360,700,"B50",{"$f":"SUM(D145:G145)","v":7500}]
[1637,"2015-05-16",null,6290,1573,700,"B51",{"$f":"SUM(D146:G146)","v":8563}]
[1674,"2001-07-01",null,3093,773,700,"B52",{"$f":"SUM(D147:G147)","v":4566}]
[1674,"2014-06-01",null,3093,773,700,"B53",{"$f":"SUM(D148:G148)","v":4566}]
[1674,"2015-07-28",null,3375,844,700,"B54",{"$f":"SUM(D149:G149)","v":4919}]
[1681,"2001-08-05",null,2538,635,700,"B55",{"$f":"SUM(D150:G150)","v":3873}]
[1681,"2014-05-22",null,3277,819,700,"B56",{"$f":"SUM(D151:G151)","v":4796}]
[1686,"2015-11-01",null,14396,2500,800,"B57",{"$f":"SUM(D152:G152)","v":17696}]
[1686,"2016-01-01",null,18200,2500,800,"B58",{"$f":"SUM(D153:G153)","v":21500}]
[1686,"2019-02-01",null,18738,2500,800,"B59",{"$f":"SUM(D154:G154)","v":22038}]
[1697,"2001-09-08",null,5400,1350,700,"B60",{"$f":"SUM(D155:G155)","v":7450}]
[1697,"2013-10-22",null,6375,1594,700,"B61",{"$f":"SUM(D156:G156)","v":8669}]
[1697,"2014-10-22",null,6375,1594,700,"B62",{"$f":"SUM(D157:G157)","v":8669}]
[1702,"2001-11-06",null,4000,1000,700,"B63",{"$f":"SUM(D158:G158)","v":5700}]
[1702,"2013-11-17",null,4655,1164,700,"B64",{"$f":"SUM(D159:G159)","v":6519}]
[1702,"2015-11-17",null,6000,1500,700,"B65",{"$f":"SUM(D160:G160)","v":8200}]
[1702,"2019-02-01",null,6170,1585,700,"B66",{"$f":"SUM(D161:G161)","v":8455}]
[1712,"2001-11-12",null,4080,1020,700,"B67",{"$f":"SUM(D162:G162)","v":5800}]
[1712,"2013-11-12",null,4850,1213,700,"B68",{"$f":"SUM(D163:G163)","v":6763}]
[1712,"2014-06-01",null,4850,1213,700,"B69",{"$f":"SUM(D164:G164)","v":6763}]
[1712,"2019-02-01",null,5447,1512,700,"B70",{"$f":"SUM(D165:G165)","v":7659}]
[1729,"2001-11-07",null,8199,2100,800,"B71",{"$f":"SUM(D166:G166)","v":11099}]
[1729,"2014-11-07",null,9019,2500,800,"B72",{"$f":"SUM(D167:G167)","v":12319}]
[1729,"2019-02-01",null,9519,2500,800,"B73",{"$f":"SUM(D168:G168)","v":12819}]
[1740,"2001-12-30",null,2736,563,700,"B74",{"$f":"SUM(D169:G169)","v":3999}]
[1740,"2013-12-30",null,3000,750,700,"B75",{"$f":"SUM(D170:G170)","v":4450}]
[1740,"2014-06-01",null,3000,750,700,"B76",{"$f":"SUM(D171:G171)","v":4450}]
[1740,"2015-08-12",null,3000,750,700,"B77",{"$f":"SUM(D172:G172)","v":4450}]
[1740,"2015-12-31",null,3000,750,700,"B78",{"$f":"SUM(D173:G173)","v":4450}]
[1740,"2019-02-01",null,3300,900,700,"B79",{"$f":"SUM(D174:G174)","v":4900}]
[1753,"2002-01-19",null,2174,435,600,"B80",{"$f":"SUM(D175:G175)","v":3209}]
[1753,"2014-04-19",null,2538,508,600,"B81",{"$f":"SUM(D176:G176)","v":3646}]
[1753,"2015-11-01",null,2538,508,600,"B82",{"$f":"SUM(D177:G177)","v":3646}]
[1753,"2016-01-19",null,2538,508,600,"B83",{"$f":"SUM(D178:G178)","v":3646}]
[1753,"2016-07-26",null,2538,508,600,"B84",{"$f":"SUM(D179:G179)","v":3646}]
[1755,"2002-01-13",null,3375,844,700,"B85",{"$f":"SUM(D180:G180)","v":4919}]
[1755,"2015-06-01",null,3375,0,700,"B86",{"$f":"SUM(D181:G181)","v":4075}]
[1755,"2015-09-01",null,3375,0,700,"B87",{"$f":"SUM(D182:G182)","v":4075}]
[1755,"2016-08-25",null,3375,844,700,"B88",{"$f":"SUM(D183:G183)","v":4919}]
[1762,"2002-02-02",null,20050,3000,0,"B89",{"$f":"SUM(D184:G184)","v":23050}]
[1762,"2015-04-01",null,20050,3000,0,"B90",{"$f":"SUM(D185:G185)","v":23050}]
[1768,"2002-03-08",null,5500,1375,700,"B91",{"$f":"SUM(D186:G186)","v":7575}]
[1768,"2014-03-11",null,6408,1602,700,"B92",{"$f":"SUM(D187:G187)","v":8710}]
[1768,"2016-03-08",null,6750,1667,700,"B93",{"$f":"SUM(D188:G188)","v":9117}]
[1768,"2018-05-01",null,6875,1667,700,"B94",{"$f":"SUM(D189:G189)","v":9242}]
[1770,"2013-06-30",null,2900,0,0,"B95",{"$f":"SUM(D190:G190)","v":2900}]
[1770,"2014-04-16",null,2900,725,700,"B96",{"$f":"SUM(D191:G191)","v":4325}]
[1823,"2002-06-22",null,15500,3000,800,"B97",{"$f":"SUM(D192:G192)","v":19300}]
[1823,"2014-06-01",null,15500,3000,800,"B98",{"$f":"SUM(D193:G193)","v":19300}]
[1847,"2002-07-03",null,1848,0,0,"B99",{"$f":"SUM(D194:G194)","v":1848}]
[1847,"2014-05-01",null,1848,0,0,"B100",{"$f":"SUM(D195:G195)","v":1848}]
[1847,"2014-07-02",null,2166,0,0,"B101",{"$f":"SUM(D196:G196)","v":2166}]
[1847,"2015-04-30",null,2166,271,700,"B102",{"$f":"SUM(D197:G197)","v":3137}]
[1847,"2018-05-01",null,2216,296,700,"B103",{"$f":"SUM(D198:G198)","v":3212}]
[1863,"2016-04-26",null,4250,0,0,"B104",{"$f":"SUM(D199:G199)","v":4250}]
[1918,"2002-10-30",null,5600,1400,700,"B105",{"$f":"SUM(D200:G200)","v":7700}]
[1918,"2013-10-30",null,5936,1484,700,"B106",{"$f":"SUM(D201:G201)","v":8120}]
[1918,"2014-10-30",null,6410,1603,700,"B107",{"$f":"SUM(D202:G202)","v":8713}]
[1918,"2015-10-30",null,6923,1667,700,"B108",{"$f":"SUM(D203:G203)","v":9290}]
[1918,"2018-05-01",null,7067,1667,700,"B109",{"$f":"SUM(D204:G204)","v":9434}]
[8555,"1994-11-17",null,1339,0,600,"B110",{"$f":"SUM(D205:G205)","v":1939}]
[8555,"2015-04-01",null,1300,0,0,"B111",{"$f":"SUM(D206:G206)","v":1300}]
[8555,"2015-07-01",null,1300,300,600,"B112",{"$f":"SUM(D207:G207)","v":2200}]
[15663,"2000-09-10",null,5000,1250,700,"B113",{"$f":"SUM(D208:G208)","v":6950}]
[15663,"2014-05-30",null,5000,1250,700,"B114",{"$f":"SUM(D209:G209)","v":6950}]
[15663,"2014-06-01",null,5000,1250,700,"B115",{"$f":"SUM(D210:G210)","v":6950}]
[15663,"2014-10-04",null,7363,1667,700,"B116",{"$f":"SUM(D211:G211)","v":9730}]
[15663,"2015-02-01",null,7363,1667,700,"B117",{"$f":"SUM(D212:G212)","v":9730}]
[15663,"2015-02-11",null,7363,1667,700,"B118",{"$f":"SUM(D213:G213)","v":9730}]
[15663,"2018-05-01",null,7738,1667,700,"B119",{"$f":"SUM(D214:G214)","v":10105}]
[15663,"2019-12-10",null,7738,1667,700,"B120",{"$f":"SUM(D215:G215)","v":10105}]
[15663,"2020-11-01",null,7738,1667,700,"B121",{"$f":"SUM(D216:G216)","v":10105}]
[18799,"2002-08-27",null,5500,1375,700,"B122",{"$f":"SUM(D217:G217)","v":7575}]
[18799,"2014-10-18",null,6730,1667,700,"G",{"$f":"SUM(D218:G218)","v":9097}]
[18799,"2018-05-01",null,6868,1667,700,"M",{"$f":"SUM(D219:G219)","v":9235}]
[]
[]
[]
[null,null,null,null,null,null,null,"خبراء الإكسل المحترمين .. السلام عليكم"]
[]
[null,null,null,null,null,null,null,null,"أرجو منكم الإطلاع على الملف المرفق وتمكيني من عمل الآتي  .. جزاكم الله خيرا"]
[]
[null,null,null,null,null,null,null,null,"الملف عبارة عن تغيرات الرواتب ورصيد الأجازت للموظفين ، بحيث أن أي تغيير يطرأ على الرواتب أو رصيد الاجازات يتم تسجيله كل حسب تاريخه"]
[]
[null,null,null,null,null,null,null,null,"المطلوب .. هو إيجاد آخر زيادة في الراتب حصل عليها الموظف .. وكما هو موضح في الفلتر .. فإن هذا الموظف حصل على بدل إضافي تم إضافته وقدره 35000 في تاريخ 1فبراير 2015 "]
[]
[null,null,null,null,null,null,null,null,"وبعدها في 2017 زاد رصيد اجازته ليكون 30 بدلا من 25 ... أنا لا أهتم برصيد الأجازت "]
[]
[null,null,null,null,null,null,null,null,"أرغب في أن يتم تفقد التواريخ للموظف وإظهار آخر تاريخ زاد فيه الإجمالي ويظهر آخر راتب اساسي وبدل سكن وبدل نقل وإضافي وقيمة الزيادة"]