Employee 06/01/2017 06/02/2017 06/05/2017 06/06/2017 06/07/2017 06/08/2017 06/09/2017 06/12/2017 06/13/2017 06/14/2017 06/15/2017 06/16/2017 06/19/2017 06/20/2017 06/21/2017 06/22/2017 06/23/2017 06/26/2017 06/27/2017 06/28/2017 06/29/2017 06/30/2017 Average
BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime BaseTime
Emp 1 51.85% 53.15% 80.56% 80.93% 87.22% 89.81% 82.41% 78.52% 86.30% 92.59% 91.85% 103.70% 95.74% 95.74% 92.87% 93.15% 102.04%
Emp 2 100.93% 100% 106.11% 100.65% 99.28% 85.94% 87.67% 120.19% 106.57% 103.98% 107.78% 103.33% 101.02% 94.44% 93.80% 82.22% 112.04% 109.44% 102.69%
Emp 3 72.69% 67.59% 107.41% 88.89% 64.07% 70.37% 55.74% 110.19% 81.48% 86.48% 32.22% 80.65% 83.06% 59.26% 63.89% 52.78% 93.52% 154.26% 69.44% 61.11% 66.67%
Emp 4 40% 47.78% 64.89% 66.52% 99.44% 111.59% 87.04% 97.67% 51.39% 69.70% 106.85% 59.44% 73.28% 86.06% 60.59% 58.70% 82.80% 67.96% 71.50% 86.11% 96.30%
Emp 5 92.26% 86.07% 87.07% 95.50% 111.19% 113.65% 106.57% 86.48% 89.50% 109.89% 101.59% 101.07% 82.26% 75.80% 129.89% 108.98% 116.76% 110.19%
Emp 6 66.78% 80.07% 88.07% 104.17% 54.65% 66.48% 71.85% 107.70% 91.81% 71.46% 70.98% 80.24% 93.28% 114.11% 98.02% 72.26% 71.06% 109.26% 81.22%
Emp 7 78.98% 132.78% 75% 46.11% 98.33% 99.44% 107.04% 89.26% 99.63% 63.89% 95.09% 111.67% 73.33% 94.63% 63.52% 73.70% 110.19% 157.31% 82.13% 80.37% 140.19%
Emp 8 73.33% 67.96% 67.69% 50% 58.61% 69.81% 81.85% 62.96% 70.09% 80.56% 82.22% 54.91% 79.07% 48.43% 74.17% 72.50% 62.69%
Emp 9 72.22% 83.80% 115.19% 78.89% 112.96% 80.56% 70% 96.85% 90.09% 87.96% 110.65% 131.30% 99.83% 105.19% 91.52%
Emp 10 101.50% 91.44% 115.15% 113.96% 101.81% 108.57% 72.20% 103.65% 114.26% 72.37% 95.67% 98.93% 99.59% 101.44% 87.83% 67.15% 119.43% 103.46% 112.70% 116.78%
Emp 11 54.06% 90.09% 66.78% 85.28% 88.78% 64.39% 50.41% 77.85% 58.44% 67.89% 99.91% 75.89% 101.80% 106.67% 78.83% 74.72% 112.09% 114.70% 73.09%
Emp 12 61.11% 64.81% 125.65% 97.41% 84.63% 64.07% 82.28% 101.13% 105.56% 99.78% 98.81% 103.65% 103.76% 115.33% 106.48% 88.63% 88.59% 75.22% 103.33% 108.98% 100% 96.67%
"How do I calculate average of %. I know I can just apply Avg formula which will give me the Avg % but that is arithmetically incorrect. Because we should not calculate Avg of %.
And denominate (no of days worked will change from one person to another. As you can see few would have worked for entire month and few would have taken leaves in between"
Bookmarks