Extracting SL and UL

[dawa]

Serial # 265 266 1 1 1 1 1 1

Designation DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist DC Assist

Division Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse Warehouse

Empl # 80459 80740 80717 80911 80875 80847 80931 81098

Week Date Day Status Haridas MP Kumar Udas Mohd Rahin Tahir Khan Ayoob ali Hashmi Gul Shahbaz Prasant Panicker Faizal Thanthan Thodiyil

Week 2 8-Jan-13 WD 8 SDO 8 8 8 8 8 8

Week 2 9-Jan-13 WD 8 8 8 8 8 8 8 8

Week 2 10-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 11-Jan-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 3 12-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 13-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 12-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 15-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 16-Jan-13 WD 8 8 8 8 8 8 8 8

Week 3 17-Jan-13 WD 8 8 8 8 8 8 8 8

Week 4 18-Jan-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 4 19-Jan-13 WD 8 8 8 8 8 8 8 8

Week 4 20-Jan-13 WD 8 8 8 8 8 SL 8 8

Week 4 21-Jan-13 WD 8 8 8 8 8 SL 8 8

Week 4 22-Jan-13 WD 8 8 8 8 8 SL 8 8

Week 4 23-Jan-13 WD 8 8 8 8 8 8 8 8

Week 4 24-Jan-13 PH PH PH PH PH PH PH PH PH

Week 5 25-Jan-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 5 26-Jan-13 WD 8 8 8 8 8 8 8 8

Week 5 27-Jan-13 WD 8 8 8 8 8 8 8 8

Week 5 28-Jan-13 WD 8 8 8 SL 8 8 8 UL

Week 5 29-Jan-13 WD 8 8 8 SL 8 8 8 UL

Week 5 30-Jan-13 WD 8 8 8 8 8 8 8 UL

Week 5 31-Jan-13 WD 8 8 8 8 8 8 8 8

Week 6 1-Feb-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 6 2-Feb-13 WD 8 8 8 8 8 8 8 8

Week 6 3-Feb-13 WD 8 8 8 8 8 8 8 8

Week 6 4-Feb-13 WD 8 8 SL 8 8 8 8 8

Week 6 5-Feb-13 WD 8 8 SL 8 8 8 8 8

Week 6 6-Feb-13 WD 8 8 8 8 8 8 8 8

Week 6 7-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 8-Feb-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 7 9-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 10-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 11-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 12-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 13-Feb-13 WD 8 8 8 8 8 8 8 8

Week 7 12-Feb-13 WD 8 8 8 8 8 8 8 8

Week 8 15-Feb-13 WD 8 SDO 8 8 8 8 8 8

Week 8 16-Feb-13 WD SDO 8 SDO SDO SDO SDO SDO SDO

Week 8 17-Feb-13 WD 8 8 8 8 8 8 8 8

Week 8 18-Feb-13 WD 8 8 8 8 8 8 8 8

Week 8 19-Feb-13 WD 8 8 8 8 8 8 8 8

Week 8 20-Feb-13 WD 8 8 8 8 8 8 8 8

Week 8 21-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 22-Feb-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 9 23-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 24-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 25-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 26-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 27-Feb-13 WD 8 8 8 8 8 8 8 8

Week 9 28-Feb-13 WD 8 8 8 8 8 8 8 8

Week 10 1-Mar-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 10 2-Mar-13 WD 8 8 8 8 8 8 8 8

Week 10 3-Mar-13 WD 8 8 8 8 8 8 8 8

Week 10 4-Mar-13 WD 8 8 8 8 SL 8 8 8

Week 10 5-Mar-13 WD 8 8 8 8 SL 8 8 8

Week 10 6-Mar-13 WD 8 8 8 8 8 8 8 8

Week 10 7-Mar-13 WD 8 8 8 8 8 8 8 8

Week 11 8-Mar-13 WD SDO SDO SDO SDO SDO SDO SDO SDO

Week 11 9-Mar-13 WD AL 8 8 8 8 8 8 8

Week 11 10-Mar-13 WD AL 8 8 8 8 8 8 8

Week 11 11-Mar-13 WD AL 8 8 8 8 8 8 8

Week 11 12-Mar-13 WD AL 8 8 8 8 8 8 8

Week 11 13-Mar-13 WD AL 8 8 8 8 8 8 8

Week 11 12-Mar-13 WD AL 8 8 8 8 AL 8 8

Week 12 15-Mar-13 WD AL SDO SDO SDO SDO SDO SDO SDOr />
Week 12 16-Mar-13 WD AL 8 AL 8 8 8 8 8

Week 12 17-Mar-13 WD AL 8 AL 8 8 8 8 8

Week 12 18-Mar-13 WD AL 8 AL 8 8 8 8 8

Week 12 19-Mar-13 WD AL 8 AL 8 8 8 8 8

Week 12 20-Mar-13 WD AL 8 AL 8 AL 8 8 8

Week 12 21-Mar-13 WD AL 8 AL 8 AL 8 8 8

Week 13 22-Mar-13 WD SDO SDO AL SDO AL SDO SDO SDO

Week 13 23-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 13 24-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 13 25-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 13 26-Mar-13 WD 8 8 AL 8 AL 8 8 10

Week 13 27-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 13 28-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 12 29-Mar-13 WD SDO SDO AL SDO AL SDO SDO SDO

Week 12 30-Mar-13 WD 8 8 AL 8 AL 8 8 SL

Week 12 31-Mar-13 WD 8 8 AL 8 AL 8 8 8

Week 12 1-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 12 2-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 12 3-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 12 4-Apr-13 WD 8 8 AL RG 8 8 SL 8

Week 15 5-Apr-13 WD SDO SDO AL RG SDO SDO SDO SDO

Week 15 6-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 15 7-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 15 8-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 15 9-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 15 10-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 15 11-Apr-13 WD 8 8 AL RG 8 8 8 8

Week 16 12-Apr-13 WD SDO SDO AL RG SDO SDO SDO SDO

Week 16 13-Apr-13 WD 8 SL AL RG 8 8 8 8

Week 16 12-Apr-13 WD 8 SL AL RG 8 8 8 8

Week 16 15-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 16 16-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 16 17-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 16 18-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 17 19-Apr-13 WD SDO SDO SDO RG SDO SDO SDO SDO

Week 17 20-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 17 21-Apr-13 WD 8 8 8 RG SL 8 8 8

Week 17 22-Apr-13 WD 8 8 SL RG 8 8 8 8

Week 17 23-Apr-13 WD 8 8 SL RG 8 8 8 8

Week 17 24-Apr-13 WD 8 8 8 RG UL SL 8 8

Week 17 25-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 18 26-Apr-13 WD SDO SDO SDO RG SDO SDO SDO SDO

Week 18 27-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 18 28-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 18 29-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 18 30-Apr-13 WD 8 8 8 RG 8 8 8 8

Week 18 1-May-13 WD 8 8 8 RG 8 AL 8 8

Week 18 2-May-13 WD 8 8 8 RG 8 8 UL 8

Week 19 3-May-13 WD SDO SDO SDO RG SDO SDO SDO SDO

Week 19 4-May-13 WD 8 8 8 RG 8 8 8 8

Week 19 5-May-13 WD 8 8 8 RG 8 8 8 8

Week 19 6-May-13 WD 8 8 8 RG 8 8 8 8

Week 19 7-May-13 WD 8 8 8 RG 8 8 8 8

Week 19 8-May-13 WD 8 8 8 RG 8 8 8 8

Week 19 9-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 10-May-13 WD SDO SDO SDO RG SDO SDO SDO SDO

Week 20 11-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 12-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 13-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 12-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 15-May-13 WD 8 8 8 RG 8 8 8 8

Week 20 16-May-13 WD 8 8 8 RG 8 8 8 8

Week 21 17-May-13 WD SDO SDO SDO RG SDO SDO SDO SDO

Week 21 18-May-13 WD 8 8 8 RG 8 8 AL 8

Week 21 19-May-13 WD 8 8 8 RG 8 8 AL 8

Week 21 20-May-13 WD 8 8 8 RG 8 8 AL 8

Week 21 21-May-13 WD 8 8 8 RG 8 SL AL 8

Week 21 22-May-13 WD 8 8 8 RG 8 SL AL 8

Week 21 23-May-13 WD 8 8 8 RG 8 8 AL 8

Week 22 24-May-13 WD SDO SDO SDO RG SDO SDO AL SDO

Week 22 25-May-13 WD 8 8 8 RG 8 8 AL 8

Week 22 26-May-13 WD 8 8 8 RG 8 8 AL 8

Week 22 27-May-13 WD 8 8 SL RG 8 8 AL 8

Week 22 28-May-13 WD 8 8 8 RG 8 8 AL 8

Week 22 29-May-13 WD 8 8 8 RG 8 8 AL 8

Week 22 30-May-13 WD 8 8 8 RG 8 8 AL 12

Week 23 31-May-13 WD 8 SDO SDO RG SDO SDO AL SDO

Week 23 1-Jun-13 WD 8 8 8 RG 8 8 AL 8

Week 23 2-Jun-13 WD 8 8 8 RG 8 8 AL 8

Week 23 3-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 23 4-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 23 5-Jun-13 WD 8 8 8 RG 8 8 AL 8

Week 23 6-Jun-13 PH PH PH PH RG PH PH AL PH

Week 24 7-Jun-13 WD SDO SDO SDO RG SDO SDO AL SDO

Week 24 8-Jun-13 WD 8 8 8 RG 8 8 AL 8

Week 24 9-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 24 10-Jun-13 WD 12 8 8 RG 8 8 AL UL

Week 24 11-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 24 12-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 24 13-Jun-13 WD 12 8 8 RG 8 8 AL 8

Week 25 14-Jun-13 WD 8 SDO SDO RG SDO SDO AL SDO

Week 25 15-Jun-13 WD 12 8 8 RG 8 UL AL 8

Week 25 16-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 25 17-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 25 18-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 25 19-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 25 20-Jun-13 WD 12 8 8 RG UL 8 AL AL

Week 26 21-Jun-13 WD SDO SDO SDO RG SDO SDO AL AL

Week 26 22-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 26 23-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 26 24-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 26 25-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 26 26-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 26 27-Jun-13 WD 12 8 8 RG 8 8 AL AL

Week 27 28-Jun-13 WD SDO SDO SDO RG SDO SDO AL AL

Week 27 29-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 27 30-Jun-13 WD 8 8 8 RG 8 8 AL AL

Week 27 1-Jul-13 WD 8 8 8 RG 8 8 AL AL

Week 27 2-Jul-13 WD 12 8 8 RG 8 8 8 AL

Week 27 3-Jul-13 WD 12 8 UL RG 8 8 8 AL

Week 27 4-Jul-13 WD 12 8 8 RG 8 8 8 AL

Week 28 5-Jul-13 WD SDO SDO SDO RG SDO SDO SDO AL

Week 28 6-Jul-13 WD 8 8 8 RG 8 8 8 AL

Week 28 7-Jul-13 WD 12 8 8 RG 8 8 8 AL

Week 28 8-Jul-13 WD 12 8 8 RG 8 8 8 AL

Week 28 9-Jul-13 WD 12 8 8 RG 8 8 8 AL

Week 28 10-Jul-13 WD 10 8 6 RG 6 6 10 AL

Week 28 11-Jul-13 WD 10 8 8 RG 8 8 8 8

Week 29 12-Jul-13 WD SDO SDO SDO RG SDO SDO 8 SDO

Week 29 13-Jul-13 WD 8 6 6 RG 6 6 8 UL

Week 29 14-Jul-13 WD 6 6 6 RG 6 6 8 UL

Week 29 15-Jul-13 WD 10 6 6 RG 6 6 10 UL

Week 29 16-Jul-13 WD 6 6 6 RG 6 6 8 OAL

Week 29 17-Jul-13 WD 6 6 6 RG 6 6 6 OAL

Week 29 18-Jul-13 WD 6 6 6 RG 6 6 6 OAL

Week 30 19-Jul-13 WD SDO SDO SDO RG SDO SDO SDO OAL

Week 30 20-Jul-13 WD 6 6 6 RG 6 6 6 OAL

Week 30 21-Jul-13 WD 6 6 6 RG 6 6 6 OAL

Week 30 22-Jul-13 WD 10 6 6 RG 6 6 8 OAL

Week 30 23-Jul-13 WD 10 6 6 RG 6 6 8 OAL

Week 30 24-Jul-13 WD 6 6 6 RG 6 6 6 OAL

Week 30 25-Jul-13 WD RG OAL

Week 31 26-Jul-13 WD RG OAL

Week 31 27-Jul-13 WD RG OAL

Week 31 28-Jul-13 WD RG OAL

Week 31 29-Jul-13 WD RG OAL

Week 31 30-Jul-13 WD RG OAL

Week 31 31-Jul-13 WD RG

Week 31 1-Aug-13 WD RG

Week 32 2-Aug-13 WD RG

Week 32 3-Aug-13 WD RG

Week 32 4-Aug-13 WD RG

Sick Leave 0 2 5 2 3 6 1 1

Unauthorised Leave 0 0 1 0 2 1 1 7

Annual Leave 13 0 30 0 12 2 45 25

Other Authorised Leave 0 0 0 0 0 0 0 15

Date of Resignation - - - - - - - -

Date of Termination - - - - - - - -

Date of Transfer - - - - - - - -

so what i want is when i put the employment no it will extract all the SL and UL with its corresponding week and date. I need this to find out the Sick leave and Unauthorized leave of a staffs within the six month rolling period.

 

[SirJB7]

This topic is the same as last question of this, just 15 hours of difference:

http://chandoo.org/forums/topic/vacation


What you're doing "is called cross-posting and is generally frowned upon in the Blogosphere as it causes people to potentially waste our time when a question is already answered. You should also check and respond to posts and let posters know if they are heading in the write direction or not." Hui's dixit, SIC. And I agree 101%.


If you'd have read the main green sticky post at this forums main page...

http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting

...you should have noticed this points:


"Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight."


"If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days."


"Never title your posts as "Urgent", "Priority" "Immediate". It may be Important to you, but not for rest of the members here. These words will be moderated out."


"Cross Posting, generally it is considered poor practice to cross post, that is to post the same question on several forums in the hope of getting a response quicker.

If you do cross post, please put that in your post.

Also if you have cross posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting there time on your answered question."


"Say "Thanks", whenever you can. Recognize when someone has bothered to go to the trouble and time to assist you with your question for free. Often readers will spend several hours working on a solution to a problem, a line of recognition will go a long way."