Post_6_Attendance Sheet 2022.xlsx

	C	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AL	AM	AN	AP	AQ	AR	AS	AT	AU	AV	AW	AX
1
2
3	ATTENDANCE SHEET																																SALARY SHEET
4	Attendance For SEP Month		#VALUE!			#VALUE!								To	#VALUE!
6	Sr No.	Name	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	PRESENT & OVERTIME	ABSENCE	HALF DAY	Basic Salary	Total Salary		Advance	Loan	Loan Deduction	Loan due Amount	Payable Salary	Way OF Transfer
7			#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	#VALUE!	PRESENT & OVERTIME	ABSENCE	HALF DAY	Basic Salary	Total Salary		Advance	Loan	Loan Deduction	Loan due Amount	Payable Salary	Way OF Transfer
8	1	Person 1	P	P	P	P		A	P	P	P	P	P		P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	P	27	1	0	570	15390	18383	1500	10500	1500	9000	₹ 15,383	NEFT
9	1	Overtime							1	1					3	1	1	1	2	4	4	4		4		4	4	4	4				42	1	0	570	2993	18383	1500	10500	1500	9000	₹ 15,383	NEFT
10	2	Person 2	P	P	P	P		P	P	A	P	P	P		P	P	P	P	P	P		P	P	P	P	P	P		P	P	P	P	25	1	0	585	14625	16088	2000	1000	1000	0	₹ 13,088	CASH
11	2	Overtime	1		1	1		1	1				1		1	1	1	1	2	1		1			1	1	1			1	1	1	20	1	0	585	1463	16088	2000	1000	1000	0	₹ 13,088	CASH
12	3	Person 3	P	P	P	P		P	P	P	P	P	P		P	P	P	P	P	P		P	P	P	P	P	P		P	P	P	P	26	0	0	585	15210	16673	4000	4000	1000	3000	₹ 11,673	CASH
13	3	Overtime	1		1	1		1	1	1			1			1	1	1	2	1		1				1	1		1	1	1	1	20	0	0	585	1463	16673	4000	4000	1000	3000	₹ 11,673	CASH
14	4	Person 4	H	A	P	P		P	P	A	A	A	A		A	A	P	P	P	P		P	P	P	P	P	P		P	P	H	A	16	8	2	485	8245	9033	3000	9000	1000	8000	₹ 5,033	CASH
15	4	Overtime			1			1	1									1	2					4		1	1		1				13	8	2	485	788	9033	3000	9000	1000	8000	₹ 5,033	CASH
16	5	Person 5	P	P	P	H		P	P	P	P	P	P		P	A	P	P	P	P		P	P	P	P	P	P	P	P	P	P	P	25	1	1	475	12113	14309	3000	3000	1000	2000	₹ 10,309	CASH
17	5	Overtime	1		1			1	1	1			1		1		1	1	2			1	1	4	1	4	4	4	4	1	1	1	37	1	1	475	2197	14309	3000	3000	1000	2000	₹ 10,309	CASH
18	6	Person 6	P	P	P	A		P	P	P	P	P	H		P	A	P	P	P	P		P	P	P	H	P	P		P	P	P	P	22	2	2	565	12995	14196	4000	5000	1000	4000	₹ 9,196	CASH
19	6	Overtime			1			1	1	1							1	1	2					4			1		1	1	1	1	17	2	2	565	1201	14196	4000	5000	1000	4000	₹ 9,196	CASH
20	7	Person 7	P	P	A	P		P	P	P	P	P	P		P	P	P	P	P	P		P	P	P	P	P	P		P	P	P	P	25	1	0	440	11000	12155	2000	5500	1500	4000	₹ 8,655	CASH
21	7	Overtime				1		1	1	1						1	1	1	2	1		1	1	2	1	1	1		1	1	1	1	21	1	0	440	1155	12155	2000	5500	1500	4000	₹ 8,655	CASH
22	8	Person 8	P	P	P	P		P	P	P	P	P	P	P	P	P	P	P	P	P		P	P	P	P	P	P		P	A	P	P	26	1	0	455	11830	12626	3200	0		0	₹ 9,426	CASH
23	8	Overtime						1	1	1						1	1	1	2					2	1	1					1	1	14	1	0	455	796	12626	3200	0		0	₹ 9,426	CASH
24	9	Person 9	P	P	A	P		A	A	A	H	A	P		P	P	A	P	P	P		P	A	P	P	P	P		P	A	P	P	17	8	1	370	6475	6799	3000	6000	1000	5000	₹ 2,799	CASH
25	9	Overtime																1	2					4									7	8	1	370	324	6799	3000	6000	1000	5000	₹ 2,799	CASH
26	10	Person 10	P	P	A	P		H	A	P	P	P	H		P	P	A	P	P	H		A	P	P	P	P	P		P	P	P	P	19	4	3	370	7585	7631	3000	5000	1000	4000	₹ 3,631	CASH
27	10	Overtime																1															1	4	3	370	46	7631	3000	5000	1000	4000	₹ 3,631	CASH
28	Total Presents		9	9	7	8	0	7	8	7	8	8	7	1	9	7	8	10	10	9	1	9	9	10	9	10	10	2	10	8	9	9				TOTAL SALARY		127892	28700		10000		89192
29	Total Overtime		3	0	5	3	0	7	8	6	0	0	3	0	3	5	7	10	9	4	1	5	2	7	4	7	7	2	6	5	6	6
30																																						TOTAL CASH					₹ 73,809
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
101