Employee Production Tracker

[sn152]

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.

 

[Faseeh]

Hi sn152,

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

=WEEKNUM(E3)

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

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

or see this file.

 

[sn152]

Thank you so much Faseeh.... This was really helpful..... I will complete my report with this.

 

[sn152]

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

 

[Faseeh]

You are welcome, for week wise production see the sheet1..

 

[sn152]

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

 

[Faseeh]

Hi sn152,

please see attached sheet

 

[Bomino]

PFA

 

[rumshar]

Thank you so much Faseeh.... This was really helpful..... I will complete my report with this.

=IF(COUNTIF($A$3:A3,A3)=1,SUMIF($B$3:$B$11,B3,$H$3:$H$11),"--")
this is non array formula
thanks..

 

[rumshar]

PFA

Hi,
Why not use pivot table?

 

[sn152]

Hi,

Thank you rumshar and bomino for helping