1.Salesman_Report.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	Salesman Report
2	Sno.	Salesman ID	Name	Quaterly Sale				Total Sale	Comission %age	Base Salary	Comission Amt	Net Salary
3	Sno.	Salesman ID	Name	Quater I	Quater II	Quater III	Quater IV	Total Sale	Comission %age	Base Salary	Comission Amt	Net Salary
4	1	SMID001	Stephen	4,590	5,480	4,965	4,785	19,820	5	250,000	12,500	262,500
5	2	SMID002	Abdul	6,580	5,980	4,550	7,890	25,000	10	270,000	27,000	297,000
6	3	SMID003	Jaya	9,845	6,595	8,750	9,845	35,035	10	264,000	26,400	290,400
7	4	SMID004	Neha	15,240	9,850	13,540	15,420	54,050	15	255,000	38,250	293,250
8	5	SMID005	Sarita	14,260	5,480	9,850	7,450	37,040	10	245,600	24,560	270,160
9	6	SMID006	Satish	16,950	9,845	4,755	10,000	41,550	10	281,000	28,100	309,100
10	7	SMID007	Mehta	4,520	6,240	7,980	5,420	24,160	5	254,000	12,700	266,700
11	8	SMID008	Sakshi	4,855	9,820	12,450	13,440	40,565	10	258,100	25,810	283,910
12	9	SMID009	Shyam	15,420	17,880	11,250	19,450	64,000	15	245,600	36,840	282,440
13	10	SMID010	Suresh	15,460	12,780	11,100	9,845	49,185	10	275,100	27,510	302,610
14	Total			107,720	89,950	89,190	103,545	390,405	NA
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100