Department Name Employee ID NO Date of Joining

Accounts
Manigandan
80076
6/17/2008

Art
Amrish
80078
6/17/2008

Sai Prasad
80075
6/17/2008

Vignesh
80077
6/17/2008

HR
Loganathan
80081
6/17/2008

Sadhan
80080
6/17/2008

Sanjay
80079
6/17/2008

Shilpa
80082
6/17/2008

MIS
Manoj Kumar
 80074
6/17/2008

Grand Total
Date of Releaving Salary

6/17/2009 6000

6/17/2009 10000

6/17/2009 10000

6/17/2009 10000

6/17/2009 9000

6/17/2009 9000

6/17/2009 8000

6/17/2009 12000
6/17/2009 8000

82000
 Employee Details Excel
Employee ID NO Name Department Salary fixed Date of Joining
80074 Manoj Kumar MIS 8000 6/17/2008
80075 Sai Prasad Art 10000 6/17/2008
80076 Manigandan Accounts 6000 6/17/2008
80077 Vignesh Art 10000 6/17/2008
80078 Amrish Art 10000 6/17/2008
80079 Sanjay HR 8000 6/17/2008
80080 Sadhan HR 9000 6/17/2008
80081 Loganathan HR 9000 6/17/2008
80082 Shilpa HR 12000 6/17/2008

Sum IF Example
Department Total Salary
HR 38000
Art 30000
Accounts 6000
MIS 8000

Zone Salesman Month Target Achieved

East Debu July 2300000 4000000
West Das July 456666 500000
North Sunny July 300000 290000
South Singh July 700000 650000
Total 3756666 5440000

Consolidation Example
Zone Salesman Month Target
East Debu June & July 3300000
West Das June & July 1351666
North Sunny June & July 954000
South Singh June & July 730000
Total 6335666

East

Salesman Region Month Target

South- East Total 600000
 North Total 620000
West Total 580000
South Total 700000
Grand Total 2500000

Salesman Region Month Target

Dipak Malhotra South- East 4-Jun 600000
Gl Sahoo North 4-Jun 400000
Ashok Malik North 4-Jun 220000
Subhashis Dey West 4-Jun 580000
Virendra Sing South 4-Jun 700000

Sum IF Example
40000 HR; 38000
35000
Art; 30000
30000
25000
Salary Fixed

20000
15000
10000 MIS; 8000
Accounts; 6000
5000
0
HR

MIS
Accounts
Art

Department
 Dcount Example
Date of Releaving Names M1 M2
6/17/2009 Harini 56 54
6/17/2009 Senthil 67 65
6/17/2009 Archana 78 56
6/17/2009 Vidhya 89 67
6/17/2009 Amritha 98 78
6/17/2009 Varun 87 89
6/17/2009
6/17/2009 M1
6/17/2009 >80

Zone Salesman Month Target Achieved

East Debu July 1000000 500000
West Das July 895000 700000
North Sunny July 654000 800000
South Singh July 30000 50000
Total 2579000 2050000

Achieved
4500000
1200000
1090000
700000
7490000

>600000

Achieved
489000 Result
150000
 550000
580000

Achieved Result
489000 111000
150000 -89000
400000 70000
550000 180000
580000 150000

ple

Column D
MIS; 8000
ounts; 6000
MIS
Accounts
 VLOOKUIP EXAMPLE
80074 Manoj Kumar MIS 8000 6/17/2008 6/17/2009
80075 Sai Prasad Art 10000 6/17/2008 6/17/2009
80076 Manigandan Accounts 6000 6/17/2008 6/17/2009
80077 Vignesh Art 10000 6/17/2008 6/17/2009
80078 Amrish Art 10000 6/17/2008 6/17/2009
80079 Sanjay HR 8000 6/17/2008 6/17/2009
80080 Sadhan HR 8000 6/17/2008 6/17/2009
80081 Loganathan HR 9000 6/17/2008 6/17/2009
80082 Shilpa HR 12000 6/17/2008 6/17/2009

Rules Count of Errors

EFP 01 4 2%
EFP 02 8 3%
EFP 03 7 3%
EFP 04 9 4%
EFP 05 5 2%
EFP 06 3 1%
EFP 07 6 2%
EFP 08 4 2%
EFP 09 7 3%
EFP 10 8 3%
EFP 11 9 4%
IFP 01 2 1%
IFP 02 4 2%
IFP 03 5 2%
IFP 04 6 2%
IFP 05 9 4%
IFP 06 6 2%
IFP 07 6 2%
IFP 08 8 3%
IFP 09 7 3%
IFP 10 8 3%
OFP 01 9 4%
OFP 02 5 2%
OFP 03 9 4%
OFP 04 6 2%
OFP 05 5 2%
OFP 06 7 3%
OFP 07 8 3%
OFP 08 4 2%
OFP 09 5 2%
OFP 10 9 4%
OFP 11 5 2%
OFP 12 4 2%
 OFP 13 6 2%
OFP 14 2 1%
OFP 15 3 1%
OFP 16 4 2%
OFP 17 5 2%
OFP 18 6 2%
OFP 19 8 3%
OFP 20 9 4%
250

Sum of Count of Errors

Rules Total
EFP 01 4
EFP 02 8
EFP 03 7
EFP 04 9
EFP 05 5
EFP 06 3
EFP 07 6
EFP 08 4
EFP 09 7
EFP 10 8
EFP 11 9
IFP 01 2
IFP 02 4
IFP 03 5
IFP 04 6
IFP 05 9
IFP 06 6
IFP 07 6
IFP 08 8
IFP 09 7
IFP 10 8
OFP 01 9
OFP 02 5
OFP 03 9
OFP 04 6
OFP 05 5
OFP 06 7
OFP 07 8
OFP 08 4
OFP 09 5
OFP 10 9
OFP 11 5
OFP 12 4
OFP 13 6
OFP 14 2
OFP 15 3
OFP 16 4
OFP 17 5
OFP 18 6
OFP 19 8
OFP 20 9
Grand Total 250

10
9
9
8
8
7
7
6
6
5
5
4
4
3
3

2
18% 20%
14% 16%
1 11%
8%
5%
0
EFP 01 EFP 02 EFP 03 EFP 04 EFP 05 EFP 06 EFP 07 E
 14%

Cum of errors
5%
8%
11%
14%
16%
18%
20%
22%
24%
28%
31%
32%
34%
36%
38%
42%
44%
46%
50%
52%
56%
59%
61%
65%
67%
69%
72%
75%
77%
79%
82%
84%
86%
 88%
89%
90%
92%
94%
96%
100%
103%

EFP 01 4
EFP 02 8
EFP 03 7
EFP 04 9
EFP 05 5
EFP 06 3
EFP 07 6
EFP 08 4
EFP 09 7
EFP 10 8
EFP 11 9
IFP 01 2
IFP 02 4
IFP 03 5
IFP 04 6
IFP 05 9
IFP 06 6
IFP 07 6
IFP 08 8
IFP 09 7
IFP 10 8
OFP 01 9
OFP 02 5
OFP 03 9
OFP 04 6
OFP 05 5
OFP 06 7
 OFP 07 8
OFP 08 4
OFP 09 5
OFP 10 9
OFP 11 5
OFP 12 4
OFP 13 6
OFP 14 2
OFP 15 3
OFP 16 4
OFP 17 5
OFP 18 6
OFP 19 8
OFP 20 9

9 9

6 6 6 6

5 5

4 4
44% 46%
3 42%
36% 38%
31% 32% 34%
28% 2
24%
20% 22%
16% 18%
14%

04 EFP 05 EFP 06 EFP 07 EFP 08 EFP 09 EFP 10 EFP 11 IFP 01 IFP 02 IFP 03 IFP 04 IFP 05 IFP 06 IFP 07
 9 9 9

8 8 8

7 7

6 6 6 75% 77
72%
67% 69%
5 65% 5
59% 61%
56%
52% 4
50%
44% 46%
42%
38%

04 IFP 05 IFP 06 IFP 07 IFP 08 IFP 09 IFP 10 OFP 01 OFP 02 OFP 03 OFP 04 OFP 05 OFP 06 OFP 07 OFP 08
 9 9

8 8 100%
94% 96%
90% 92%
7 88% 89%
84% 86%
82%
77% 79% 6 6
75%
72%
5 5 5

4 4 4

OFP 06 OFP 07 OFP 08 OFP 09 OFP 10 OFP 11 OFP 12 OFP 13 OFP 14 OFP 15 OFP 16 OFP 17 OFP 18 OFP 19 OFP
 120%
9
103%
8 100% 100%
% 96%

80%
6

60% Count of Errors

Cum of errors

40%

20%

0%
OFP 18 OFP 19 OFP 20
Date of Joining 6/17/2008

Sum of Salary fixed Name Employee ID NO

Amrish Loganathan Manigandan Manoj Kumar

Department Date of Releaving
Accounts 6/17/2009 6000
Art 6/17/2009 10000
HR 6/17/2009 9000
MIS 6/17/2009 8000
Grand Total 10000 9000 6000 8000
 Sanjay Shilpa
Sadhan Sai Prasad Vignesh Grand Total
80079 80082
6000
10000 10000 30000
9000 8000 12000 38000
8000
9000 10000 8000 12000 10000 82000