STUDENTS DAT
Sl No SUBJECTS
Student Name Fathrer Name Class Roll No Mobile No
HINDI ENG
1 Amit Kumar SingAmit Kumar Singh 12th 25639652 58 68
2 Sanjay Sanjay 25639653 84 58
3 Anjay Anjay 25639654 64 65
4 Sanjay Sanjay 12th 25639655 45 48
5 Sumt Kumar SingSumt Kumar Singh 25639656 45 40
6 Binay Binay 25639657 38 36
7 Abhay Abhay 12th 25639658 58 68
8 Asit Kumar SinghAsit Kumar Singh 25639659 84 58
9 Sunil Sunil 25639660 80 79
STUDENTS DATA SHEET
SUBJECTS Mark Obtain Total Marks Percent Average Maximum
MATH SCI COMPUTER SO SCI
70 65 84 46 391 600 65.16667 65.16667 84
74 65 68 67 416 600 69.33333 69.33333 84
84 56 76 96 441 600 73.5 73.5 96
47 50 84 46 320 600 53.33333 53.33333 84
39 45 37 38 244 600 40.66667 40.66667 45
38 39 37 39 227 600 37.83333 37.83333 39
70 65 84 46 391 600 65.16667 65.16667 84
74 65 68 67 416 600 69.33333 69.33333 84
82 75 86 96 498 600 83 83 96
Lowest Rank
46 first
58
56
45
37
36
46
58
75
EMPLOYEES DATABASE FOR THE M
emoloyee employee
id name designation basic salary presence absence off day total paid day
VA10110 Salman Sr Manager ₹ 45,000.00 25 1 4 5
VA10106 Rishabh Sr Manager ₹ 62,000.00 25 1 4 5
Satyandra
VA10107 kumar Project Offecer ₹ 19,000.00 24 2 4 6
VA10108 Ankit Pal Asset Mgr ₹ 22,000.00 22 4 4 8
VA10105 Sumit Singh Accountant ₹ 19,500.00 26 0 4 4
VA10104 Sunil Khare Storekeeper ₹ 9,000.00 25 3 4 7
VA10109 Ajay Kumar Accountant ₹ 17,500.00 22 4 4 8
VA10102 Kailash Bhoi Clerk ₹ 8,000.00 20 6 4 10
VA10101 Amit Singh Storekeeper ₹ 7,000.00 25 1 4 5
VA10103 Bikash Sahu Asset Mgr ₹ 21,000.00 25 3 4 7
S DATABASE FOR THE MONTH OF APR 2021
actual basic
salary TA 20% DA 45% HRA 30% gross salary Pf 12% esi 2%
₹ 7,500.00 ₹ 9,000.00 ₹ 20,250.00 ₹ 13,500.00 ₹ 119,483.33 ₹ 5,400.00 ₹ 900.00
₹ 10,333.33 ₹ 12,400.00 ₹ 27,900.00 ₹ 18,600.00 ₹ 91,083.33 ₹ 7,440.00 ₹ 1,240.00
₹ 3,800.00 ₹ 3,800.00 ₹ 8,550.00 ₹ 5,700.00 ₹ 48,616.67 ₹ 2,280.00 ₹ 380.00
₹ 5,866.67 ₹ 4,400.00 ₹ 9,900.00 ₹ 6,600.00 ₹ 47,891.67 ₹ 2,640.00 ₹ 440.00
₹ 2,600.00 ₹ 3,900.00 ₹ 8,775.00 ₹ 5,850.00 ₹ 31,775.00 ₹ 2,340.00 ₹ 390.00
₹ 2,100.00 ₹ 1,800.00 ₹ 4,050.00 ₹ 2,700.00 ₹ 31,941.67 ₹ 1,080.00 ₹ 180.00
₹ 4,666.67 ₹ 3,500.00 ₹ 7,875.00 ₹ 5,250.00 ₹ 31,558.33 ₹ 2,100.00 ₹ 350.00
₹ 2,666.67 ₹ 1,600.00 ₹ 3,600.00 ₹ 2,400.00 ₹ 18,083.33 ₹ 960.00 ₹ 160.00
₹ 1,166.67 ₹ 1,400.00 ₹ 3,150.00 ₹ 2,100.00 ₹ 32,666.67 ₹ 840.00 ₹ 140.00
₹ 4,900.00 ₹ 4,200.00 ₹ 9,450.00 ₹ 6,300.00 ₹ 93,850.00 ₹ 2,520.00 ₹ 420.00
TOTAL AMOUNT ₹ 69,000.00 ₹ 546,950.00 ₹ 27,600.00 ₹ 4,600.00
net salary
₹ 113,183.33
₹ 82,403.33
₹ 45,956.67
₹ 44,811.67
₹ 29,045.00
₹ 30,681.67
₹ 29,108.33
₹ 16,963.33
₹ 31,686.67
₹ 90,910.00
₹ 514,750.00
EPF Passbook [Financial Year -2023-2024]
Employee
Particulars Balance
OB Int. Updated upto 01/04/2023 1,10,337
Transaction Wages Contribution
Wage Month Date Type Particulars EPF EPS Employee
Mar-23 13-04-2023 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Apr-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
May-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Jun-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Jul-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Aug-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Sep-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Oct-23 CR Cont. For Due-Month 042023 15,000 1,500 1,800
Total Contributions For the year (2023) 14,400
Total Transfer-Ins/VDRs for the year [2023] 0
Total Withdrawals for the year [2023] 0
Interest details N/A 0
Closing Balance as on 31/03/2024 124,737
Employer Pension
Balance Balance
32,949 53,750
Contribution
Employer Pension
550 1,250
550 1,250
550 1,250
550 1,250
550 1,250
550 1,250
550 1,250
550 1,250
4,400 10,000
0 0
0 0
0 0
37349 63750
