• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Employee Production Tracker

sn152

sn152

Member
Good Day everybody....

Iam in the process of creating an employee production tracker. i have attached a sample file with this thread. This file has columns for Emp. ID, Name, Team, Supervisor, Transaction date, Target and Production. Now I have added another column for Week. What I am trying to do here is, I would like the Week numbers(Week 1, Week 2.... etc.) to be automatically updated when I enter the date in Transaction Date column. I would like a Associate Name wise sum of the production.

It would be really great if any of you could help me to complete this.

Thanks in advance.
 

Attachments

Hi sn152,

For Week Num, enter this in F3 and drag down:

Code: 
=WEEKNUM(E3)

For Associate Name Wise Updated Production enter this in L3 with CSE and drag down:

Code: 
=IF(COUNTIF($A$3:A3,A3)=1,SUM(($B$3:$B$11=B3)*($H$3:$H$11)*1),"--")

or see this file.
 

Attachments

And sorry to ask you more. Is there any way where I can get Week wise total production and quality in a seperate sheet.
 
Hi Faseeh,

Thank u so much. But can i pls. ask you one more thing? How can we get the Week wise production of each team seperately in sheet 1? And also associate name wise production for each week seperately. I have attached the template with this post. Please review the sheet 1. Kindly help me with this.

Thanks in advance :)
 

Attachments

You must log in or register to reply here.
Back
Top