Recent content by atulrajratna

WoW!!! Thanks sir.. It is working. Thanks a lot..

I have a long list of a text containing "mmm dd yyyy hh:mm:ss". e.g. May 21st 2013 21:42:04 Mar 22nd 2013 21:38:18 Dec 23rd 2013 21:37:15 Oct 1st 2013 21:35:48 Jan 1st 2013 21:32:37 Mar 3rd 2013 21:32:02 Apr 2nd 2013 21:29:51 Jun 20th 2013 21:28:19 Feb 21st 2013 21:25:30 I want to...

Hi all, I am working on a project and srucked on this- If I have a list of dates as mentioned bellow. And there are some dates which are entered two-three times. But we dont know which they are, How to check those dates in given list? e.g- 27-Jan-12 12-Feb-12 01-Mar-12 03-Apr-12...

Hi Faseeh.. Congrats dude.. Thats really great to see you with Ninja's black garb and belt. and thanks for sharing your Precious knowladge. Thanks a lot. Enjoy.. Atul Rajratna.

Hi Sean & Narayan, Actually I was looking for the same resolution.. Our all agents use individual worksheets to fill up the completed work. By end of the day we open all the 10-12 files and copy all the data to the master sheet, I think, Sean & my problem is same so once I will get the idea...

me too.. Thanks "TEAM", thanks a lot!

Hi all, nice work done by everyone here.. Actually we were facing the same problem while working. We use diff-diff action by dates, depends on customer request and by mistake agents used to add wrong action by date due to so many request in a day. so I created a worksheet where you just need...

Hi Annen, I'm agree with Faseeh Suppose the table is- _| A | B | C | 1| 0 | 1 | 2| 0 |45%| 3| So the data source will be like this- Values in X-Series: =Sheet1!$A$1:$B$1 (i.e- 0,1) Values in Y-Series: =Sheet1!$A$2:$B$2 (i.e- 0,45%) so the line will start from 0, you can also add...

Faseeh, you are right.. We must have to think about agents capacity. We can try it by another way as well, thank you so much for the new ideas and new file, I will check and will work on it. THANK YOU AGAIN for your "SHIFT MANAGEMENT" worksheet. :) Atul

Here is the sample file- https://skydrive.live.com/redir.aspx?cid=92bd629a339d0180&resid=92BD629A339D0180!116&parid=92BD629A339D0180!112&authkey=!AHmtUhtGqfHv0s8 Thanks, Atul

Hi Faseeh, That's correct! Ans. 02- In 1st hour we had 50 faxes, in second hour it becomes 60, but between that 1 hour we have processed 40 faxes, It means PENDING WORK in that hr: 50-40= 10 Faxes NEW WORK: 60-10= 50 Faxes so pending 10 faxes means, variation is low, but if the PENDING or...

Hi team, This might be quite different (or stupid) question I'm asking on this forum but I need some help to make more improvements in my project. I am working on a Six Sigma project, subject is 'SHIFT & OVERTIME MANAGEMENT'. off-course its completely EXCEL based. I am done with the 'shift...

Hi team, I have a chart based on a run rate table. the table shows percentage of current over. so there are some numbers as well as zero's. Suppose the game is in 9th over & run rate is 15.71 but the series goes down as 10th & next all overs have number 0 in the table. The series should be...

Hi Faseeh, Thank you so much! Its working, Rocking actually.. Regards, Atul

Faseeh, Its showing the number of faxes completed by agents in that shift. not received numbers. Result(K17) should be- 778 faxes as per your sheet(range C3:L3 - 1.30 AM to 10.30 AM). How to do that? Atul