{"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,1768,{"$f":"IFERROR(MAX(IF($A$9:$A$1700=$B3,IF($D$9:$D$1700=$D3,$B$9:$B$1700))),\"-\")","v":"2018-05-01"},{"$f":"MAX(IF(($A$9:$A$1700=$B3),$D$9:$D$1700,\"\"))","v":6875},{"$f":"IFERROR(MAX(IF($A$9:$A$1700=$B3,IF($D$9:$D$1700=$D3,$E$9:$E$1700))),\"-\")","v":1667},{"$f":"IFERROR(MAX(IF($A$9:$A$1700=$B3,IF($D$9:$D$1700=$D3,$F$9:$F$1700))),\"-\")","v":700},{"$f":"IFERROR(MAX(IF($A$9:$A$1700=$B3,IF($D$9:$D$1700=$D3,$G$9:$G$1700))),\"-\")","v":0},{"$f":"MAX(IF(($A$9:$A$1700=$B3),$D$9:$D$1700,\"\"))-MIN(IF(($A$9:$A$1700=$B3),$D$9:$D$1700,\"\"))","v":1375}]
[]
[]
[]
[]
["EMP ID","Effective Date","Vacation","راتب أساسي","بدل سكن","بدل نقل","بدلات إضافية","الإجمالي"]
[1004,"2017-03-19",null,2250,563,700,null,{"$f":"SUM(D9:G9)","v":3513}]
[1004,"2016-05-01",null,2250,563,700,null,{"$f":"SUM(D10:G10)","v":3513}]
[1004,"2015-07-01",null,2250,563,700,null,3513]
[1004,"2015-03-19",null,2250,0,0,null,2250]
[1004,"1994-11-17",null,3375,0,700,null,4075]
[1007,"2017-02-01",30,45000,15000,1000,75000,136000]
[1007,"2015-02-01",25,45000,15000,1000,75000,136000]
[1007,"2014-06-01",25,45000,15000,1000,40000,101000]
[1007,"1995-04-01",25,45000,15000,1000,40000,101000]
[1015,"2020-02-18",null,5954,1488,700,null,8142]
[1015,"2019-07-25",null,5954,1488,700,null,8142]
[1015,"2015-12-01",null,5954,1488,700,null,8142]
[1015,"2014-07-01",null,5000,1250,700,null,6950]
[1015,"1994-12-01",null,3836,959,700,null,5495]
[1027,"2014-04-16",null,4382,1096,0,null,5478]
[1027,"2014-04-15",null,4382,0,0,null,4382]
[1078,"2011-09-20",null,3000,0,0,null,3000]
[1117,"2013-12-12",null,12000,2500,800,null,15300]
[1117,"1995-12-12",null,9600,2400,800,null,12800]
[1124,"2019-02-01",null,27575,3750,1000,null,32325]
[1124,"2014-06-01",null,24800,3750,1000,null,29550]
[1124,"1995-12-01",null,23950,3750,1000,null,28700]
[1150,"2018-09-01",null,21105,3750,1000,null,25855]
[1150,"2014-02-23",null,21105,3750,1000,null,25855]
[1150,"1995-12-21",null,18500,3750,1000,null,23250]
[1160,"2019-02-01",null,13650,3000,800,null,17450]
[1160,"2015-05-04",null,12400,3000,800,null,16200]
[1160,"2013-05-04",null,12400,3000,800,null,16200]
[1160,"1996-05-04",null,11000,3000,800,null,14800]
[1161,"2014-07-06",null,5250,1313,700,null,7263]
[1161,"2014-06-01",null,5209,1302,700,null,7211]
[1161,"1996-07-01",null,5209,1302,700,null,7211]
[1176,"2020-03-25",null,4125,1031,700,null,5856]
[1176,"2014-06-01",null,4125,1031,700,null,5856]
[1176,"1996-10-27",null,4125,1031,700,null,5856]
[1191,"2017-07-01",null,12920,3000,800,null,16720]
[1199,"2015-10-26",null,5350,1338,700,null,7388]
[1199,"2015-03-01",null,5250,1313,700,null,7263]
[1199,"2014-06-01",null,5250,1313,700,null,7263]
[1199,"2013-10-26",null,5250,1313,700,null,7263]
[1199,"1997-09-02",null,4287,1072,700,null,6059]
[1207,"2019-02-01",null,2689,597,700,null,3986]
[1207,"2014-11-23",null,2389,597,700,null,3686]
[1207,"1996-11-23",null,1931,483,600,null,3014]
[1208,"2015-11-01",null,3581,895,700,null,5176]
[1208,"2015-10-01",null,3581,895,700,null,5176]
[1208,"2015-08-05",null,3581,725,700,null,5006]
[1208,"2014-06-01",null,2900,725,700,null,4325]
[1208,"1997-07-05",null,2900,725,700,null,4325]
[1216,"2018-05-01",null,8625,0,800,null,9425]
[1216,"2016-09-01",null,8250,0,800,null,9050]
[1216,"2014-11-20",null,8250,2475,800,null,11525]
[1216,"1997-10-20",null,7210,2163,800,null,10173]
[1245,"2020-12-01",null,5250,1313,700,null,7263]
[1245,"2015-12-17",null,5250,1313,700,null,7263]
[1245,"2014-06-01",null,5250,1313,700,null,7263]
[1245,"2013-12-17",null,5250,1313,700,null,7263]
[1245,"1997-11-17",null,4804,1201,700,null,6705]
[1273,"2014-06-20",null,8115,2435,800,null,11350]
[1273,"2014-06-01",null,5680,1420,700,null,7800]
[1273,"1998-06-20",null,5680,1420,700,null,7800]
[1275,"2019-02-01",null,9115,2935,800,null,12850]
[1276,"2014-06-01",null,6750,1666,700,null,9116]
[1276,"2014-02-01",null,6750,1500,700,null,8950]
[1276,"2014-01-01",null,6750,1666,700,null,9116]
[1276,"1998-08-01",null,6500,1666,700,null,{"$f":"SUM(D74:G74)","v":8866}]
[1290,"1998-10-19",null,22450,3750,1000,null,27200]
[1291,"2019-02-01",null,4305,1121,700,null,6126]
[1291,"2015-11-01",null,4125,1031,700,null,5856]
[1291,"2014-10-22",null,4125,1031,700,null,5856]
[1291,"2014-06-01",null,3825,956,700,null,5481]
[1291,"1998-10-22",null,3825,956,700,null,5481]
[1295,"2015-12-21",null,7500,1667,700,null,9867]
[1295,"2014-11-03",null,7500,1667,700,null,9867]
[1295,"1998-10-17",null,6640,1660,700,null,9000]
[1375,"2015-03-28",null,5392,1348,700,null,7440]
[1375,"2014-08-21",null,4480,1000,700,null,6180]
[1375,"2014-06-01",null,4480,0,700,null,5180]
[1375,"1999-03-13",null,4480,0,700,null,5180]
[1382,"2015-04-05",null,1015,300,600,null,1915]
[1382,"2015-03-01",null,1015,300,600,null,1915]
[1382,"2014-06-01",null,1015,300,600,null,1915]
[1382,"1999-04-05",null,1015,300,600,null,1915]
[1391,"2014-09-13",null,30450,3750,1000,null,35200]
[1399,"2020-12-01",null,5000,1250,700,null,6950]
[1399,"2016-04-01",null,4125,1031,700,null,5856]
[1399,"2015-10-01",null,3733,933,700,null,5366]
[1399,"2014-06-01",null,3733,933,700,null,5366]
[1399,"2014-05-31",null,3733,933,700,null,5366]
[1399,"2014-04-01",null,3733,933,700,null,5366]
[1399,"1999-04-18",null,2889,722,700,null,4311]
[1409,"2017-05-01",null,1015,300,600,null,1915]
[1409,"2014-06-01",null,1015,300,600,null,1915]
[1409,"1999-06-05",null,1015,300,600,null,1915]
[1416,"2014-08-01",null,1537,787,350,null,2674]
[1416,"1999-05-01",null,900,150,350,null,1400]
[1417,"2019-03-01",null,5956,1666,700,null,8322]
[1417,"2019-02-01",null,5956,1666,700,null,8322]
[1417,"2015-05-14",null,5250,1313,700,null,7263]
[1417,"2014-06-01",null,4726,1181,700,null,6607]
[1417,"1999-05-04",null,4726,1181,700,null,6607]
[1435,"2020-12-01",null,3248,0,0,null,3248]
[1435,"2015-06-03",null,3248,0,0,null,3248]
[1435,"2014-06-01",null,2575,0,0,null,2575]
[1435,"1999-06-03",null,2575,0,0,null,2575]
[1449,"2019-02-01",null,26750,3750,1000,null,31500]
[1449,"2015-10-09",null,25750,3750,1000,null,30500]
[1449,"2013-10-09",null,25750,3750,1000,null,30500]
[1449,"1999-10-09",null,25750,0,1000,null,26750]
[1462,"2017-07-01",null,14500,2500,800,null,17800]
[1462,"2014-03-06",null,14500,2500,800,null,17800]
[1462,"1999-11-06",null,10850,2500,800,null,14150]
[1483,"2015-02-01",null,45000,15000,1000,null,61000]
[1483,"2014-06-01",null,45000,15000,1000,null,61000]
[1483,"2000-01-01",null,45000,15000,1000,null,61000]
[1543,"2014-09-17",null,4278,1070,700,null,6048]
[1543,"2000-09-03",null,3609,902,700,null,5211]
[1547,"2014-09-17",null,4036,1009,700,null,5745]
[1567,"2014-06-01",null,6294,1574,700,null,8568]
[1567,"2001-01-02",null,6294,1574,700,null,8568]
[1579,"2017-03-01",null,1885,377,600,null,2862]
[1579,"2015-09-01",null,1885,377,600,null,2862]
[1579,"2000-11-12",null,1885,377,600,null,2862]
[1598,"2018-05-01",null,2365,591,700,null,3656]
[1598,"2016-02-28",null,2365,591,700,null,3656]
[1598,"2015-09-01",null,2365,591,700,null,3656]
[1598,"2001-02-25",null,2365,591,700,null,3656]
[1614,"2019-12-01",null,45000,7000,1000,null,53000]
[1614,"2019-02-01",null,40500,7000,1000,null,48500]
[1614,"2018-01-01",null,38000,7000,1000,null,{"$f":"SUM(D138:G138)","v":46000}]
[1614,"2015-02-01",null,35000,6000,1000,null,42000]
[1614,"2001-03-15",null,35000,6000,1000,null,42000]
[1615,"2015-03-26",null,9770,2500,800,null,13070]
[1615,"2014-06-01",null,8000,1667,700,null,10367]
[1615,"2013-03-26",null,8000,1667,700,null,10367]
[1615,"2001-03-26",null,7000,1667,700,null,9367]
[1637,"2015-05-16",null,6290,1573,700,null,8563]
[1637,"2001-04-16",null,5440,1360,700,null,7500]
[1674,"2015-07-28",null,3375,844,700,null,4919]
[1674,"2014-06-01",null,3093,773,700,null,4566]
[1674,"2001-07-01",null,3093,773,700,null,4566]
[1681,"2014-05-22",null,3277,819,700,null,4796]
[1681,"2001-08-05",null,2538,635,700,null,3873]
[1686,"2019-02-01",null,18738,2500,800,null,22038]
[1686,"2016-01-01",null,18200,2500,800,null,21500]
[1686,"2015-11-01",null,14396,2500,800,null,17696]
[1697,"2014-10-22",null,6375,1594,700,null,8669]
[1697,"2013-10-22",null,6375,1594,700,null,8669]
[1697,"2001-09-08",null,5400,1350,700,null,7450]
[1702,"2019-02-01",null,6170,1585,700,null,8455]
[1702,"2015-11-17",null,6000,1500,700,null,8200]
[1702,"2013-11-17",null,4655,1164,700,null,6519]
[1702,"2001-11-06",null,4000,1000,700,null,5700]
[1712,"2019-02-01",null,5447,1512,700,null,7659]
[1712,"2014-06-01",null,4850,1213,700,null,6763]
[1712,"2013-11-12",null,4850,1213,700,null,6763]
[1712,"2001-11-12",null,4080,1020,700,null,5800]
[1729,"2019-02-01",null,9519,2500,800,null,12819]
[1729,"2014-11-07",null,9019,2500,800,null,12319]
[1729,"2001-11-07",null,8199,2100,800,null,11099]
[1740,"2019-02-01",null,3300,900,700,null,4900]
[1740,"2015-12-31",null,3000,750,700,null,4450]
[1740,"2015-08-12",null,3000,750,700,null,4450]
[1740,"2014-06-01",null,3000,750,700,null,4450]
[1740,"2013-12-30",null,3000,750,700,null,4450]
[1740,"2001-12-30",null,2736,563,700,null,3999]
[1753,"2016-07-26",null,2538,508,600,null,3646]
[1753,"2016-01-19",null,2538,508,600,null,3646]
[1753,"2015-11-01",null,2538,508,600,null,3646]
[1753,"2014-04-19",null,2538,508,600,null,3646]
[1753,"2002-01-19",null,2174,435,600,null,3209]
[1755,"2016-08-25",null,3375,844,700,null,4919]
[1755,"2015-09-01",null,3375,0,700,null,4075]
[1755,"2015-06-01",null,3375,0,700,null,4075]
[1755,"2002-01-13",null,3375,844,700,null,4919]
[1762,"2015-04-01",null,20050,3000,0,null,23050]
[1762,"2002-02-02",null,20050,3000,0,null,23050]
[1768,"2018-05-01",null,6875,1667,700,null,9242]
[1768,"2016-03-08",null,6750,1667,700,null,9117]
[1768,"2014-03-11",null,6408,1602,700,null,8710]
[1768,"2002-03-08",null,5500,1375,700,null,7575]
[1770,"2014-04-16",null,2900,725,700,null,4325]
[1770,"2013-06-30",null,2900,0,0,null,2900]
[1823,"2014-06-01",null,15500,3000,800,null,19300]
[1823,"2002-06-22",null,15500,3000,800,null,19300]
[1847,"2018-05-01",null,2216,296,700,null,3212]
[1847,"2015-04-30",null,2166,271,700,null,3137]
[1847,"2014-07-02",null,2166,0,0,null,2166]
[1847,"2014-05-01",null,1848,0,0,null,1848]
[1847,"2002-07-03",null,1848,0,0,null,1848]
[1863,"2016-04-26",null,4250,0,0,null,4250]
[1918,"2018-05-01",null,7067,1667,700,null,9434]
[1918,"2015-10-30",null,6923,1667,700,null,9290]
[1918,"2014-10-30",null,6410,1603,700,null,{"$f":"SUM(D202:G202)","v":8713}]
[1918,"2013-10-30",null,5936,1484,700,null,8120]
[1918,"2002-10-30",null,5600,1400,700,null,7700]
[8555,"2015-07-01",null,1300,300,600,null,2200]
[8555,"2015-04-01",null,1300,0,0,null,1300]
[8555,"1994-11-17",null,1339,0,600,null,1939]
[15663,"2020-11-01",null,7738,1667,700,null,10105]
[15663,"2019-12-10",null,7738,1667,700,null,10105]
[15663,"2018-05-01",null,7738,1667,700,null,10105]
[15663,"2015-02-11",null,7363,1667,700,null,9730]
[15663,"2015-02-01",null,7363,1667,700,null,9730]
[15663,"2014-10-04",null,7363,1667,700,null,9730]
[15663,"2014-06-01",null,5000,1250,700,null,6950]
[15663,"2014-05-30",null,5000,1250,700,null,6950]
[15663,"2000-09-10",null,5000,1250,700,null,6950]
[18799,"2018-05-01",null,6868,1667,700,null,9235]
[18799,"2014-10-18",null,6730,1667,700,null,9097]
[18799,"2002-08-27",null,5500,1375,700,null,7575]
[]
[]
[]
[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,"أرغب في أن يتم تفقد التواريخ للموظف وإظهار آخر تاريخ زاد فيه الإجمالي ويظهر آخر راتب اساسي وبدل سكن وبدل نقل وإضافي وقيمة الزيادة"]