shyamal.singha

Hi All, I'm writing this hoping i'm would find something i have not explored already to solve what i explain below. I'm in a position where i supervise a team of 10 people. the work nature is such that there is no regular flow of work throughout the day and whatever comes is available to every user to be picked on first click first take basis. i have to ensure that i keep a track of their productivity in terms how long they are busy and on what task. since the software we use does not provide us rich facility to accomplish above i have developed an Excel sheet to capture it. the problem is even though the time sheet(see attached file "sample sheet.xls") is protected; still the time punches section is editable by users and can be easily manipulated unless manually superviised which is not easy. have tried the macro idea but they dont work if the file is shared and protected! the above is important to ensure users keep an eye on their station to see if new volume of work is available or not without having to reminded by others. Have attached a sample file of the time sheet. Any suggestion is appreciated. Thanks for reading through.

Thankyou Suresh for the reply.

Hi All, I am in a kind of process where accuracy i critical. In short i, on a routine basis need to check if particular cases are being correctly handled by team members. each member on an average does 30 cases a day with an average of 21 working days month . its not possible to check all of them for accuracy. with 4.75 current sigma level what can be a good sample size? I have seen the sample size calculator and would like know more about expected proportion and power of test.