Emp.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Reference	Firstname	Surname	Address	Gender	Mobile	NI Number	Student loan	Tax	Pension	Deductions	Net Pay	Gross Pay
2	494736	Capt	Alan	1 God's Town	Male	12741257771	200740	£ 37.44	£ 936.00	£ 62.40	£ 1070.16	£ 2049.84	£ 3120.00
3	47723	Johnny	Dave	1 God's Town	Male	12736985743	133604	£ 47.32	£ 1182.90	£ 78.86	£ 1352.45	£ 2590.55	£ 3943.00
4	582849	Jackson	Strongman	17 Goldlane	Male	99036985743	164203	£ 33.05	£ 826.26	£ 55.08	£ 944.69	£ 1809.51	£ 2754.20
5	153177	Princess	Amanda	13 Whitehart Lane	Female	55532458655	305017	£ 64.25	£ 1606.20	£ 107.08	£ 1836.42	£ 3517.58	£ 5354.00
6	698813	Sonic	Southend	12 Greyway	Female	45986532125	219654	£ 65.08	£ 1626.90	£ 108.46	£ 1860.09	£ 3562.91	£ 5423.00
7	587830	Lilly	Russel	White	Female	12009778655	258244	£ 55.26	£ 1381.50	£ 92.10	£ 1579.51	£ 3025.49	£ 4605.00
8	462858	Loyal	Freeman	90 Normal Lane	Male	23559778655	51522	£ 42.12	£ 1053.00	£ 70.20	£ 1203.93	£ 2306.07	£ 3510.00
9	578340	Luce	Townsend	89 Grey Road	Female	12009774345	257787	£ 32.27	£ 806.70	£ 53.78	£ 922.33	£ 1766.67	£ 2689.00
10	203736	Felix	Godwin	White	Male	23009778655	78735	£ 52.98	£ 1324.50	£ 88.30	£ 1514.35	£ 2900.65	£ 4415.00
11	122290	Lilly	Russel	White	Female	12009778655	155713	£ 7.19	£ 179.70	£ 11.98	£ 205.46	£ 393.54	£ 599.00
12	583600	Tony	Montana	Black	Male	13339778655	205504	£ 55.34	£ 1383.60	£ 92.24	£ 1581.92	£ 3030.08	£ 4612.00
13	609957	Felix	Godwin	White	Male	23009778655	339035	£ 6.12	£ 153.00	£ 10.20	£ 174.93	£ 335.07	£ 510.00
14	100866	Luce	Townsend	Grey	Female	12009774345	398348	£ 50.81	£ 1270.20	£ 84.68	£ 1452.26	£ 2781.74	£ 4234.00
15	270920	John	Johnson	21 Little Venice	Male	45852158742	303486	£ 11.46	£ 286.50	£ 19.10	£ 327.56	£ 627.43	£ 955.00
16	223177	Princess	Ann	13 Whitehart Lane	Female	55554258655	305017	£ 64.25	£ 1606.20	£ 107.08	£ 1836.42	£ 3517.58	£ 5354.00
17	380936	Sally	Southend	61 Horn Lane	Female	96396538452	206062	£ 68.93	£ 1723.20	£ 114.88	£ 1970.19	£ 3773.81	£ 5744.00
18	512266	Jack	Newman	17 Little Venice	Male	77458985744	197701	£ 15.29	£ 382.20	£ 25.48	£ 436.98	£ 837.02	£ 1274.00
19	477552	Johnny	Dave	1 God's Town	Male	12736985743	216540	£ 53.30	£ 1332.60	£ 88.84	£ 1523.61	£ 2918.39	£ 4442.00
20	695643	Travic	Patternine	15 Hardway Soul	Female	76526555179	219654	£ 65.08	£ 1626.90	£ 108.46	£ 1860.09	£ 3562.91	£ 5423.00
21	695643	Travic	Patternine	15 Hardway Soul	Female	76526555179	219654	£ 65.08	£ 1626.90	£ 108.46	£ 1860.09	£ 3562.91	£ 5423.00
22	438912	Grace	Fellow	38 Beans Squal	Female	97878591234	191935	£ 52.50	£ 1312.50	£ 87.50	£ 1500.62	£ 2874.38	£ 4375.00
23	279518	Kingsley	Henrymoore	45 Kilomore Ave	Male	74752252469	36820	£ 43.32	£ 1083.00	£ 72.20	£ 1238.23	£ 2371.77	£ 3610.00
24	525406	Folake	Wales	19 Welrich Ave	Female	85426539423	185626	£ 61.03	£ 1525.80	£ 101.72	£ 1744.50	£ 3341.50	£ 5086.00
25	562261	Johnny	Dave	1 God's Town	Male	12736985743	158331	£ 56.42	£ 1410.60	£ 94.04	£ 1612.79	£ 3089.21	£ 4702.00
26	321576	Jackson	Strongman	17 Goldlane	Male	99036985743	391523	£ 27.74	£693.60	£ 46.24	£ 793.02	£ 1518.98	£ 2312.00
27	373951	Princess	Amanda	13 Whitehart Lane	Female	55532458655	219173	£65.71	£1642.80	£109.52	£1878.27	£3597.73	£5476.00
28	373951	Princess	Amanda	13 Whitehart Lane	Female	55532458655	219173	£65.71	£1642.80	£109.52	£1878.27	£3597.73	£5476.00
29	185150	John	Johnson	21 Little Venice	Male	45852158742	409487	£29.34	£733.50	£48.90	£838.63	£1606.37	£2445.00
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