excel dashboard templates 09

Prévia do material em texto

Model
		Sheets	Sheet Type	Description	Links
		Model	Assumptions	Description of Sheets	Model
		List	Assumptions	Lists and model assumptions	List
		Data	Input Sheet	Primary Inputs Sheet 	Data
		Calcs	Calculations sheet	Primary calculations page	Calcs
		Check	Error trapping	Checks and balances for the model	Check
		Summary	Output Sheet	Primary output page	Summary
Lists
	List1	Lookup		Payscale	Desc		Concat	PS Level	Increment	Pay		Service	Years		Dates		Checks
	R	Scotland		CI1	Engineer		CONT	CONT		$ 6,000		0	0-2		Oct-19		Model OK
	S	England		ET2	Administation		CI11	CI1	1	$ 1,803		2	2-5		Nov-19		Check Model
	P	Wales		CI2	Engineer		CI12	CI1	2	$ 1,848		5	5-7		Dec-19
	I	Scotland		CONT	Contract Mger		CI13	CI1	3	$ 1,911		7	7-10		Jan-20
				CI3	Engineer		CI14	CI1	4	$ 2,007		10	10+		Feb-20
				CI4	Engineer		CI15	CI1	5	$ 2,086					Mar-20
				AS3	Administation		CI21	CI2	1	$ 2,127					Apr-20
				ET1	Administation		CI22	CI2	2	$ 2,228					May-20
				PT3	Accountant		CI23	CI2	3	$ 2,332					Jun-20
				PT4	Accountant		CI24	CI2	4	$ 2,436
				ET3	Administation		CI31	CI3	1	$ 2,539
				AS2	Administation		CI32	CI3	2	$ 2,643
				ET5	Administation		CI33	CI3	3	$ 2,747
				AS5	Administation		CI34	CI3	4	$ 2,850
				AS6	Administation		CI35	CI3	5	$ 2,954
				AS4	Administation		CI41	CI4	1	$ 3,058
				LEG	Legal		CI42	CI4	2	$ 3,163
				ET4	Administation		CI43	CI4	3	$ 3,369
							CI51	CI5	1	$ 3,619
							CI52	CI5	2	$ 3,701
							CI53	CI5	3	$ 3,846
							CI61	CI6	1	$ 3,937
							CI62	CI6	2	$ 4,026
							CI63	CI6	3	$ 4,117
							ET11	ET1	1	$ 1,773
							ET12	ET1	2	$ 1,817
							ET13	ET1	3	$ 1,879
							ET14	ET1	4	$ 1,973
							ET15	ET1	5	$ 2,051
							ET21	ET2	1	$ 2,118
							ET22	ET2	2	$ 2,219
							LEG1	ET2	3	$ 4,549
							LEG2	ET2	4	$ 4,632
							ET31	ET3	1	$ 2,528
							ET32	ET3	2	$ 2,632
							ET33	ET3	3	$ 2,736
							ET34	ET3	4	$ 2,788
							ET41	ET4	1	$ 2,838
							ET42	ET4	2	$ 2,983
							ET43	ET4	3	$ 3,151
							ET44	ET4	4	$ 3,253
							ET51	ET5	1	$ 3,355
							ET52	ET5	2	$ 3,459
							ET53	ET5	3	$ 3,562
							ET61	ET6	1	$ 3,831
							ET62	ET6	2	$ 3,921
							ET63	ET6	3	$ 4,010
							ET64	ET6	4	$ 4,100
							AS11	AS1	1	1205
							AS12	AS1	2	1316
							AS13	AS1	3	1426
							AS21	AS2	1	1676
							AS22	AS2	2	1742
							AS23	AS2	3	1806
							AS24	AS2	4	1871
							AS25	AS2	5	1940
							AS26	AS2	6	2008
							AS27	AS2	7	2079
							AS28	AS2	8	2149
							AS21	AS2	1	2239
							AS32	AS3	2	2325
							AS33	AS3	3	2412
							AS34	AS3	4	2499
							AS31	AS3	1	2650
							AS42	AS4	2	2738
							AS43	AS4	3	2827
							AS44	AS4	4	2916
							AS41	AS4	1	3074
							AS52	AS5	2	3164
							AS53	AS5	3	3252
							AS54	AS5	4	3343
							AS51	AS5	1	3530
							AS62	AS6	2	3613
							AS63	AS6	3	3694
							AS64	AS6	4	3777
							AS71	AS7	1	3952
							AS72	AS7	2	4047
							AS73	AS7	3	4143
							AS74	AS7	4	4238
							AS81	AS8	1	4379
							AS82	AS8	2	4464
							AS83	AS8	3	4549
							AS84	AS8	4	4632
							PT11	PT1	1	1272
							PT12	PT1	2	1520
							PT13	PT1	3	1603
							PT14	PT1	4	1685
							PT15	PT1	5	1768
							PT16	PT1	6	1851
							PT17	PT1	7	1937
							PT18	PT1	8	2024
							PT21	PT2	1	2114
							PT22	PT2	2	2294
							PT23	PT2	3	2384
							PT24	PT2	4	2474
							PT25	PT2	5	2618
							PT26	PT2	6	2779
							PT27	PT2	7	2923
							PT31	PT3	1	3103
							PT32	PT3	2	3193
							PT33	PT3	3	3283
							PT41	PT4	1	3530
							PT42	PT4	2	3613
							PT43	PT4	3	3694
							PT44	PT4	4	3777
							PT51	PT5	1	3952
							PT52	PT5	2	4047
							PT53	PT5	3	4143
							PT54	PT5	4	4238
							PT61	PT6	1	4379
							PT62	PT6	2	4464
							PT63	PT6	3	4549
							PT64	PT6	4	4632
Data
	0001 Organizational Key	0002 Last Name	0002 First Name	0002 Date of Birth	0002 Age	0000 Leaving date	0000 Entry Date	Service	0000 Reason for Action		0000 Begda	0008 Payscale Group	0008 Payscale Level		0000 Action Change Date	Leaving year	Leaving Mth	Action Mth	Data	Level	Desc	MthlySalary
	NKRIRDTROP	LastName1	FirstName1	9/17/66	47	10/1/19	12/24/17	0-2	Resigned	9/14/24	3/25/19	CI1	2		10/1/19	2019	10	10	Scotland	CI12	Engineer	$ 4,004
	NKRIRDTROP	LastName2	FirstName2	5/6/77	36	10/1/19	11/4/17	0-2	Resigned	9/14/24	3/25/19	CI1	2		10/1/19	2019	10	10	Scotland	CI12	Engineer	$ 4,004
	NKRIRDTROP	LastName3	FirstName3	1/29/85	28	10/1/19	11/26/17	0-2	Redundancy	9/14/24	3/25/19	CI1	2		10/1/19	2019	10	10	Scotland	CI12	Engineer	$ 4,004
	NKRICWNCTSYT	LastName4	FirstName4	8/31/83	30	10/4/19	7/4/15	2-5	Resigned	9/17/24	3/28/19	ET2	1		10/3/19	2019	10	10	Scotland	ET21	Administation	$ 4,589
	NKRIRWCCAMCH	LastName5	FirstName5	7/31/66	47	10/4/19	6/30/10	7-10	Resigned	9/17/24	3/28/19	CI2	4		10/4/19	2019	10	10	Scotland	CI24	Engineer	$ 5,278
	NKSQSISMSOMY	LastName6	FirstName6	7/30/87	26	10/4/19	7/23/11	7-10	Resigned	9/17/24	3/28/19	LEG	4		10/9/19	2019	10	10	Wales	LEG1	Legal	$ 9,856
	NKSQRCRC	LastName7	FirstName7	6/29/51	62	10/4/19	6/30/10	7-10	Redundancy	9/17/24	3/28/19	CONT			10/9/19	2019	10	10	Wales	CONT	Contract Mger	$ 13,000
	NKSQRCUU	LastName8	FirstName8	5/3/44	69	10/4/19	8/2/75	10+	Redundancy	9/17/24	3/28/19	CI3	2		10/9/19	2019	10	10	Wales	CI32	Engineer	$ 5,727
	NKSQRCPO	LastName9	FirstName9	12/25/74	38	10/6/19	1/15/13	5-7	Resigned	9/19/24	3/30/19	CI2	3		10/16/19	2019	10	10	Wales	CI23	Engineer	$ 5,053
	NKRIRWAMTRCH	LastName10	FirstName10	12/19/61	51	10/8/19	11/1/87	10+	Resigned	9/21/24	4/1/19	CI2	1		10/10/19	2019	10	10	Scotland	CI21	Engineer	$ 4,609
	NKSQFAAMST	LastName11	FirstName11	3/27/80	33	10/10/19	4/4/15	2-5	Redundancy	9/23/24	4/3/19	ET2	1		10/10/19	2019	10	10	Wales	ET21	Administation	$ 4,589
	NKSQFAAMST	LastName12	FirstName12	12/16/91	21	10/10/19	4/4/15	2-5	Dismissed	9/23/24	4/3/19	ET2	1		10/10/19	2019	10	10	Wales	ET21	Administation	$ 4,589
	NKSQFAAMST	LastName13	FirstName13	3/7/89	24	10/10/19	4/4/15	2-5	Dismissed	9/23/24	4/3/19	ET2	1		10/10/19	2019	10	10	Wales	ET21	Administation	$ 4,589
	NKSQFAAMFS	LastName14	FirstName14	4/23/82	31	10/10/19	4/4/15	2-5	Dismissed	9/23/24	4/3/19	ET2	1		10/11/19	2019	10	10	England	ET21	Administation	$ 4,589
	NKRIRWAMTOWT	LastName15	FirstName15	9/27/47	66	10/10/19	9/6/76	10+	Dismissed	9/23/24	4/3/19	CI4	2		10/14/19	2019	10	10	Scotland	CI42	Engineer	$ 6,853
	NKSQFAAMST	LastName16	FirstName16	7/20/86	27	10/10/19	4/5/15	2-5	Resigned	9/23/24	4/3/19	ET2	1		10/16/19	2019	10	10	England	ET21	Administation	$ 4,589
	NKRIRWCCAMTT	LastName17	FirstName17	11/15/71	42	10/11/19	1/19/19	0-2	Dismissed	9/24/24	4/4/19	CI1	1		10/16/19	2019	10	10	Scotland	CI11	Engineer	$ 3,907
	NKSQSISMSO	LastName18	FirstName18	7/16/87	26	10/11/19	10/24/11	7-10	Resigned	9/24/24	4/4/19	AS3	4		10/16/19	2019	10	10	England	AS34	Administation	$ 5,415
	NKSQFAAMSO	LastName19	FirstName19	9/26/83	30	10/16/19	4/9/16	2-5	Redundancy	9/29/24	4/9/19	ET1	1		10/18/19	2019	10	10	England	ET11	Administation	$ 3,842
	NKSQRCPO	LastName20	FirstName20	4/30/71	42	10/17/19	9/3/14	5-7	Dismissed	9/30/24	4/10/19	CI2	3		10/18/19	2019	10	10	England	CI23	Engineer	$ 5,053
	NKPGTE	LastName21	FirstName21	12/26/58	54	10/25/19	6/30/10	7-10	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CONT	Contract Mger	$ 13,000
	NKPGAPAS	LastName22	FirstName22	9/15/64	49	10/25/19	6/30/10	7-10	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CONT	Contract Mger	$ 13,000
	NKPGTSCS	LastName23	FirstName23	9/8/65	48	10/25/19	9/1/90	10+	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CONT	Contract Mger	$ 13,000
	NKRIERPE	LastName24	FirstName24	11/17/86	27	11/1/19	3/3/14	5-7	Resigned	10/15/24	4/25/19	PT3	2		11/5/19	2019	11	11	Scotland	PT32	Accountant	$ 6,918
	NKRINOFN	LastName25	FirstName25	5/20/57	56	11/1/19	6/30/10	7-10	Redundancy	10/15/24	4/25/19	CONT			11/5/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKRINOER	LastName26	FirstName26	10/5/55	58	11/1/19	6/30/10	7-10	Redundancy	10/15/24	4/25/19	CONT			11/5/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKRIERET	LastName27	FirstName27	2/16/58	55	11/1/19	6/30/10	7-10Redundancy	10/15/24	4/25/19	CONT			11/5/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKSQTCTOCH	LastName28	FirstName28	10/5/85	28	11/4/19	2/26/16	2-5	Resigned	10/18/24	4/28/19	CI1	3		11/6/19	2019	11	11	England	CI13	Engineer	$ 4,141
	NKPGTSSE	LastName29	FirstName29	12/3/51	62	11/6/19	8/30/86	10+	Redundancy	10/20/24	4/30/19	PT4	4		11/12/19	2019	11	11	Wales	PT44	Accountant	$ 8,184
	NKSQSISMSOPR	LastName30	FirstName30	12/3/64	49	11/8/19	6/30/10	7-10	Resigned	10/22/24	5/2/19	ET3	2		11/11/19	2019	11	11	England	ET32	Administation	$ 5,703
	NKRIERTC	LastName31	FirstName31	1/11/57	56	11/8/19	6/30/10	7-10	Redundancy	10/22/24	5/2/19	PT4	4		11/11/19	2019	11	11	Scotland	PT44	Accountant	$ 8,184
	NKRIERTC	LastName32	FirstName32	1/1/49	64	11/8/19	6/30/10	7-10	Redundancy	10/22/24	5/2/19	PT3	3		11/11/19	2019	11	11	Scotland	PT33	Accountant	$ 7,113
	NKPGTE	LastName33	FirstName33	12/26/58	54	10/25/19	4/18/87	10+	Redundancy	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI23	Engineer	$ 5,053
	NKPGAPAS	LastName34	FirstName34	9/15/64	49	10/25/19	11/15/14	2-5	Redundancy	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGTSCS	LastName35	FirstName35	9/8/65	48	10/25/19	9/1/90	10+	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGTE	LastName36	FirstName36	12/26/58	54	10/25/19	4/18/87	10+	Resigned	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGAPAS	LastName37	FirstName37	9/15/64	49	10/25/19	11/15/14	2-5	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGTSCS	LastName38	FirstName38	9/8/65	48	10/25/19	9/1/90	10+	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGTE	LastName39	FirstName39	12/26/58	54	10/25/19	4/18/87	10+	Resigned	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGAPAS	LastName40	FirstName40	9/15/64	49	10/25/19	9/1/17	2-5	Redundancy	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI24	Engineer	$ 5,278
	NKPGTSCS	LastName41	FirstName41	9/8/65	48	10/25/19	9/1/90	10+	Resigned	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI31	Engineer	$ 5,501
	NKPGTE	LastName42	FirstName42	12/26/58	54	10/25/19	9/1/17	2-5	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI32	Engineer	$ 5,727
	NKPGAPAS	LastName43	FirstName43	9/15/64	49	10/25/19	9/1/17	2-5	Redundancy	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI33	Engineer	$ 5,952
	NKPGTSCS	LastName44	FirstName44	9/8/65	48	10/25/19	9/1/17	2-5	Dismissed	10/8/24	4/18/19	CONT			10/31/19	2019	10	10	Wales	CI34	Engineer	$ 6,175
	NKPGAPSY	LastName45	FirstName45	12/3/86	27	11/8/19	8/1/13	5-7	Redundancy	10/22/24	5/2/19	AS2	5		11/12/19	2019	11	11	Wales	AS25	Administation	$ 4,203
	NKRIRWPE	LastName46	FirstName46	4/18/63	50	11/8/19	4/17/93	10+	Redundancy	10/22/24	5/2/19	CONT			11/14/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKRIERTC	LastName47	FirstName47	1/17/51	62	11/8/19	6/30/10	7-10	Redundancy	10/22/24	5/2/19	CONT			11/14/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKRIERPE	LastName48	FirstName48	7/23/55	58	11/14/19	6/30/10	7-10	Redundancy	10/28/24	5/8/19	ET5	3		11/15/19	2019	11	11	Scotland	ET53	Administation	$ 7,718
	NKRINOFNAMCT	LastName49	FirstName49	6/17/71	42	11/15/19	9/1/16	2-5	Resigned	10/29/24	5/9/19	CI1	3		11/19/19	2019	11	11	Scotland	CI13	Engineer	$ 4,141
	NKSQRCEM	LastName50	FirstName50	7/18/71	42	11/15/19	5/13/04	10+	Redundancy	10/29/24	5/9/19	ET3	2		11/19/19	2019	11	11	England	ET32	Administation	$ 5,703
	NKSQRCEM	LastName51	FirstName51	10/3/58	55	11/15/19	7/10/95	10+	Redundancy	10/29/24	5/9/19	LEG	4		11/19/19	2019	11	11	England	LEG1	Legal	$ 9,856
	NKISSEPC	LastName52	FirstName52	11/24/54	59	11/15/19	11/4/87	10+	Redundancy	10/29/24	5/9/19	AS5	4		11/19/19	2019	11	11	Scotland	AS54	Administation	$ 7,243
	NKPGTSCS	LastName53	FirstName53	5/23/55	58	11/15/19	8/9/86	10+	Redundancy	10/29/24	5/9/19	PT4	4		11/19/19	2019	11	11	Wales	PT44	Accountant	$ 8,184
	NKSQREPI	LastName54	FirstName54	11/13/71	42	11/15/19	2/26/17	2-5	Redundancy	10/29/24	5/9/19	CONT			11/21/19	2019	11	11	England	CONT	Contract Mger	$ 13,000
	NKSQOHTMTO	LastName55	FirstName55	6/16/65	48	11/19/19	1/26/19	0-2	Resigned	11/2/24	5/13/19	ET2	1		11/19/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKSQFACMCW	LastName56	FirstName56	7/22/85	28	11/22/19	4/18/11	7-10	Redundancy	11/5/24	5/16/19	ET1	4		11/22/19	2019	11	11	England	ET14	Administation	$ 4,275
	NKSQFACMIS	LastName57	FirstName57	5/12/56	57	11/22/19	8/26/90	10+	Redundancy	11/5/24	5/16/19	ET1	5		11/22/19	2019	11	11	England	ET15	Administation	$ 4,444
	NKSQFARMRP	LastName58	FirstName58	6/7/55	58	11/22/19	6/30/10	7-10	Redundancy	11/5/24	5/16/19	AS6	4		11/22/19	2019	11	11	England	AS64	Administation	$ 8,184
	NKSQFACMCW	LastName59	FirstName59	6/8/62	51	11/22/19	6/5/16	2-5	Redundancy	11/5/24	5/16/19	ET2	1		11/22/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKSQFACMIS	LastName60	FirstName60	5/7/85	28	11/22/19	5/22/13	5-7	Redundancy	11/5/24	5/16/19	ET2	1		11/22/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKSQFACM	LastName61	FirstName61	12/15/80	32	11/22/19	5/22/13	5-7	Redundancy	11/5/24	5/16/19	AS4	4		11/22/19	2019	11	11	England	AS44	Administation	$ 6,318
	NKSQFACMPM	LastName62	FirstName62	4/4/59	54	11/22/19	5/22/13	5-7	Redundancy	11/5/24	5/16/19	ET2	1		11/22/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKSQFARMSM	LastName63	FirstName63	2/9/75	38	11/22/19	5/22/13	5-7	Dismissed	11/5/24	5/16/19	AS6	4		11/25/19	2019	11	11	England	AS64	Administation	$ 8,184
	NKSQFACMPM	LastName64	FirstName64	3/30/57	56	11/22/19	6/30/10	7-10	Dismissed	11/5/24	5/16/19	ET2	1		11/25/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKSQFACMIS	LastName65	FirstName65	9/20/75	38	11/22/19	9/16/14	5-7	Dismissed	11/5/24	5/16/19	ET1	4		11/25/19	2019	11	11	England	ET14	Administation	$ 4,275
	NKSQFAAMFS	LastName66	FirstName66	8/13/59	54	11/22/19	6/30/10	7-10	Dismissed	11/5/24	5/16/19	ET3	3		11/25/19	2019	11	11	England	ET33	Administation	$ 5,928
	NKSQFAAMSO	LastName67	FirstName67	1/28/56	57	11/22/19	10/14/18	0-2	Dismissed	11/5/24	5/16/19	ET3	2		11/25/19	2019	11	11	England	ET32	Administation	$ 5,703
	NKSQFAAMSO	LastName68	FirstName68	1/9/51	62	11/22/19	10/14/18	0-2	Dismissed	11/5/24	5/16/19	ET4	3		11/25/19	2019	11	11	England	ET43	Administation	$ 6,827
	NKSQFACMPM	LastName69	FirstName69	11/13/62	51	11/22/19	1/30/93	10+	Redundancy	11/5/24	5/16/19	LEG	4		11/26/19	2019	11	11	England	LEG1	Legal	$ 9,856
	NKSQFACMGP	LastName70	FirstName70	9/14/66	47	11/22/19	2/9/15	2-5	Dismissed	11/5/24	5/16/19	ET2	1		11/27/19	2019	11	11	England	ET21	Administation	$ 4,589
	NKRIRDTROP	LastName71	FirstName71	11/17/62	51	11/25/19	11/14/13	5-7	Resigned	11/8/24	5/19/19	CI1	3		11/27/19	2019	11	11	Scotland	CI13	Engineer	$ 4,141
	NKSQTCTOTB	LastName72	FirstName72	12/1/71	42	11/26/19	10/7/15	2-5	Resigned	11/9/24	5/20/19	CI1	5		11/27/19	2019	11	11	England	CI15	Engineer	$ 4,520
	NKRICWNCTSYT	LastName73	FirstName73	1/20/53	60	11/29/19	9/15/84	10+	Resigned	11/12/24	5/23/19	CONT			11/29/19	2019	11	11	Scotland	CONT	Contract Mger	$ 13,000
	NKSQFAAMFS	LastName74	FirstName74	9/19/59	54	11/29/19	10/8/94	10+	Dismissed	11/12/24	5/23/19	ET2	1		12/3/19	2019	11	12	England	ET21	Administation	$ 4,589
	NKRIRDTROP	LastName75	FirstName75	7/24/51	62	11/29/19	10/14/18	0-2	Redundancy	11/12/24	5/23/19	CI1	5		12/3/19	2019	11	12	Scotland	CI15	Engineer	$ 4,520
	NKSQRESR	LastName76	FirstName76	1/15/72	41	11/29/19	7/15/98	10+	Redundancy	11/12/24	5/23/19	PT3	3		12/3/19	2019	11	12	England	PT33	Accountant	$ 7,113
	NKSQREEE	LastName77	FirstName77	5/2/56	57	11/29/19	10/14/18	0-2	Dismissed	11/12/24	5/23/19	AS4	3		12/3/19	2019	11	12	England	AS43	Administation	$ 6,125
	NKRIRDTROP	LastName78	FirstName78	3/8/51	62	11/29/19	2/13/80	10+	Redundancy	11/12/24	5/23/19	CI2	2		12/3/19	2019	11	12	Scotland	CI22	Engineer	$ 4,827
	NKSQFAAMST	LastName79	FirstName79	1/20/58	55	11/29/19	9/20/04	10+	Redundancy	11/12/24	5/23/19	LEG	3		12/3/19	2019	11	12	EnglandLEG1	Legal	$ 9,856
	NKSQFAAMST	LastName80	FirstName80	10/8/54	59	11/29/19	5/3/81	10+	Redundancy	11/12/24	5/23/19	LEG	3		12/3/19	2019	11	12	England	LEG1	Legal	$ 9,856
	NKSQFACMIS	LastName81	FirstName81	11/8/69	44	11/29/19	2/12/02	10+	Dismissed	11/12/24	5/23/19	ET2	1		12/3/19	2019	11	12	England	ET21	Administation	$ 4,589
	NKSQFARMRP	LastName82	FirstName82	9/18/76	37	11/29/19	7/28/01	10+	Redundancy	11/12/24	5/23/19	ET5	3		12/3/19	2019	11	12	England	ET53	Administation	$ 7,718
	NKSQRCRC	LastName83	FirstName83	12/14/52	60	11/29/19	4/3/80	10+	Redundancy	11/12/24	5/23/19	CI4	3		12/3/19	2019	11	12	England	CI43	Engineer	$ 7,300
	NKSQRESC	LastName84	FirstName84	12/20/55	57	11/29/19	8/15/04	10+	Redundancy	11/12/24	5/23/19	AS4	4		12/3/19	2019	11	12	England	AS44	Administation	$ 6,318
	NKSQREEE	LastName85	FirstName85	5/15/55	58	11/29/19	2/6/84	10+	Redundancy	11/12/24	5/23/19	PT3	3		12/3/19	2019	11	12	England	PT33	Accountant	$ 7,113
	NKSQFAAMSO	LastName86	FirstName86	18637	62	11/22/19	10/13/84	10+	Redundancy	11/5/24	43601	ET4	3		41603	2013	11	11	Ireland	ET43	Administation	$ 6,827
	NKSQFACMPM	LastName87	FirstName87	22963	51	11/22/19	1/30/93	10+	Redundancy	11/5/24	43601	LEG	4		41604	2013	11	11	Ireland	LEG2	Legal	$ 5,256
	NKSQFACMGP	LastName88	FirstName88	24364	47	11/22/19	2/9/15	2-5	Redundancy	11/5/24	43601	ET2	1		41605	2013	11	11	Ireland	ET21	Administation	$ 4,589
	NKRIRDTROP	LastName89	FirstName89	22967	51	11/25/19	11/14/13	5-7	Resigned	11/8/24	43604	CI1	3		41605	2013	11	11	Ireland	CI13	Engineer	$ 4,141
	NKSQTCTOTB	LastName90	FirstName90	26268	42	11/26/19	10/7/15	2-5	Resigned	11/9/24	43605	CI1	5		41605	2013	11	11	Ireland	CI15	Engineer	$ 4,520
	NKRICWNCTSYT	LastName91	FirstName91	19379	60	11/29/19	9/15/84	10+	Redundancy	11/12/24	43608	CONT			41607	2013	11	11	Ireland	CONT	Contract Mger	$ 13,000
	NKSQFAAMFS	LastName92	FirstName92	21812	54	11/29/19	10/8/94	10+	Redundancy	11/12/24	43608	ET2	1		41611	2013	11	12	Ireland	ET21	Administation	$ 4,589
	NKRIRDTROP	LastName93	FirstName93	18833	62	11/29/19	5/21/86	10+	Redundancy	11/12/24	43608	CI1	5		41611	2013	11	12	Ireland	CI15	Engineer	$ 4,520
	NKSQRESR	LastName94	FirstName94	26313	41	11/29/19	7/15/98	10+	Redundancy	11/12/24	43608	PT3	3		41611	2013	11	12	Ireland	PT33	Accountant	$ 7,113
	NKSQREEE	LastName95	FirstName95	20577	57	11/29/19	1/31/90	10+	Resigned	11/12/24	43608	AS4	3		41611	2013	11	12	Ireland	AS43	Administation	$ 6,125
	NKRIRDTROP	LastName96	FirstName96	18695	62	11/29/19	7/26/10	7-10	Redundancy	11/12/24	43608	CI2	2		41611	2013	11	12	Ireland	CI22	Engineer	$ 4,827
	NKSQFAAMST	LastName97	FirstName97	21205	55	11/29/19	7/27/10	7-10	Redundancy	11/12/24	43608	LEG	3		41611	2013	11	12	Ireland	LEG2	Legal	$ 5,033
	NKSQFAAMST	LastName98	FirstName98	20005	59	11/29/19	7/28/10	7-10	Redundancy	11/12/24	43608	LEG	3		41611	2013	11	12	Ireland	LEG2	Legal	$ 5,033
	NKSQFACMIS	LastName99	FirstName99	25515	44	11/29/19	7/29/10	7-10	Resigned	11/12/24	43608	ET2	1		41611	2013	11	12	Ireland	ET21	Administation	$ 4,589
	NKSQFARMRP	LastName100	FirstName100	28021	37	11/29/19	7/28/01	10+	Resigned	11/12/24	43608	ET5	3		41611	2013	11	12	Ireland	ET53	Administation	$ 7,718
	NKSQRCRC	LastName101	FirstName101	19342	60	11/29/19	4/3/80	10+	Redundancy	11/12/24	43608	CI4	3		41611	2013	11	12	Ireland	CI43	Engineer	$ 7,300
	NKSQRESC	LastName102	FirstName102	20443	57	11/29/19	8/15/04	10+	Redundancy	11/12/24	43608	AS4	4		41611	2013	11	12	Ireland	AS44	Administation	$ 6,318
	NKRICWNCTSYT	LastName103	FirstName103	8/31/83	30	10/4/19	7/28/17	2-5	Resigned	9/17/24	3/28/19	ET2	1		10/3/19	2019	10	10	Ireland	ET21	Administation	$ 4,589
	NKRIRWCCAMCH	LastName104	FirstName104	7/31/66	47	10/4/19	7/29/17	2-5	Resigned	9/17/24	3/28/19	CI2	4		10/4/19	2019	10	10	Ireland	CI24	Engineer	$ 5,278
	NKSQSISMSOMY	LastName105	FirstName105	7/30/87	26	10/4/19	7/30/17	2-5	Resigned	9/17/24	3/28/19	LEG	4		10/9/19	2019	10	10	Ireland	LEG2	Legal	$ 10,036
	NKSQRCRC	LastName106	FirstName106	6/29/51	62	10/4/19	7/31/17	2-5	Redundancy	9/17/24	3/28/19	CONT			10/9/19	2019	10	10	Ireland	CONT	Contract Mger	$ 13,000
	NKSQRCUU	LastName107	FirstName107	5/3/44	69	10/4/19	8/1/17	2-5	Redundancy	9/17/24	3/28/19	CI3	2		10/9/19	2019	10	10	Ireland	CI32	Engineer	$ 5,727
	NKSQRCPO	LastName108	FirstName108	12/25/74	38	10/6/19	1/15/13	5-7	Resigned	9/19/24	3/30/19	CI2	3		10/16/19	2019	10	10	Ireland	CI23	Engineer	$ 5,053
Calcs
	Job Type	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Savings
	Scotland	12,012	83,165	170,051	170,051	170,051	170,051	170,051	170,051	170,051	1,285,533
	England	- 0	23,487	228,512	228,512	228,512	228,512	228,512	228,512	228,512	1,623,069
	Wales	- 0	151,756	172,326	172,326	172,326	172,326	172,326	172,326	172,326	1,358,036
	Ireland	- 0	43,682	145,180	145,180	145,180	145,180	145,180	145,180	145,180	1,059,940
											- 0
	Total	12,012	302,090	716,068	716,068	716,068	716,068	716,068	716,068	716,068	5,326,579
	Count of Dept	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Total
	Scotland	3	12	23	23	23	23	23	23	23	176
	England	- 0	5	37	37	37	37	37	37	37	264
	Wales	- 0	22	25	25	25	25	25	25	25	197
	Ireland	- 0	6	23	23	23	23	23	23	23	167
											- 0
	Total	3	45	108	108	108	108	108	108	108	804
											- 0
	Rec	3	45	108	108	108	108	108	108	108	804
	Var	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Saving by Position	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Total
	Contract Mger	- 0	104,000	169,000	169,000	169,000	169,000	169,000	169,000	169,000	1,287,000
	Engineer	12,012	129,900	188,795	188,795	188,795	188,795	188,795	188,795	188,795	1,463,475
	Accountant	- 0	6,918	59,921	59,921	59,921	59,921	59,921	59,921	59,921	426,367
	Legal	- 0	19,892	74,640	74,640	74,640	74,640	74,640	74,640	74,640	542,369
	Administation	- 0	41,379	223,713	223,713	223,713	223,713	223,713	223,713	223,713	1,607,368
	Total	12,012	302,090	716,068	716,068	716,068	716,068	716,068	716,068	716,068	5,326,579
	Rec	12,012	302,090	716,068	716,068	716,068	716,068	716,068	716,068	716,068
	Var	0	0	0	0	0	0	0	0	0
	Count by Positon	Oct-19	Nov-19	Dec-19	Jan-20	Feb-20	Mar-20	Apr-20	May-20	Jun-20	Total
	Contract Mger	- 0	8	13	13	13	13	13	13	13	99
	Engineer	3	25	37	37	37	37	37	37	37	287
	Accountant	- 0	1	8	8	8	8	8	8	8	57
	Legal	- 0	2	9	9	9	9	9	9	9	65
	Administation	- 0	9	41	41	41	41	41	41	41	296
	Total	3	45	108	108	108	108	108	108	108
	Potential Salary Graph	Total Sal
	England	1,285,533
	Scotland	1,623,069
	Wales	1,358,036
	Ireland	1,059,940
	Potential Savings Graph	Nov	Annual
	Contract Mger	104,000	1,287,000
	Engineer	129,900	1,463,475
	Accountant	6,918	426,367
	Legal	19,892	542,369
	Administation	41,379	1,607,368
		0-2	2-5	5-7	7-10	10+	Total
	England	4	8	6	6	13	37
	Scotland	5	2	2	8	6	23
	Wales	0	9	2	4	10	25
	Ireland	0	7	2	4	10	23
	Service Length Graph	0-2	2-5	5-7	7-10	10+	Total
	England	11%	22%	16%	16%	35%	100%
	Scotland	22%	9%	9%	35%	26%	100%
	Wales	0%	36%	8%	16%	40%	100%
	Ireland	0%	30%	9%	17%	43%	100%
	Dismissal Type Graph	Resigned	Redundancy	Dismissed
	Contract Mger	1	9	3
	Engineer	16	13	8
	Accountant	1	7	0
	Legal	2	7	0
	Administation	9	19	13
		Resigned	Redundancy	Dismissed
	Contract Mger	10	9	4
	Engineer	13	4	6
	Accountant	6	7	8
	Legal	7	10	9
	Administation	9	2	5
Check
		Region	Total	Full Year		Check
		Scotland	170,051	170,051
		England	228,512	228,512
		Wales	172,326	172,326
		Ireland	145,180	145,180
		Total	716,068	716,068		- 0
		Check		- 0
		Region	Total	Full Year		Check
		Scotland	23	23
		England	37	37
		Wales	25	25
		Ireland	23	23
		Total	108	108		- 0
		Region	Total	Full Year		Check
		Contract Mger	169,000	169000
		Engineer	188,795	188794.666666667
		Accountant	59,921	59921.3333333333
		Legal	74,640	74639.5
		Administation	223,713	223712.666666667
		Total	716,068	716,068		- 0
		Region	Total	Full Year		Check
		Contract Mger	13	13
		Engineer	37	37
		Accountant	8	8
		Legal	9	9
		Administation	41	41
		Total	108	108		- 0
		Master Check		Model OK		- 0
Summary
		Savings by Area	Oct 19	Nov 19	Dec 19	Jan 20	Feb 20	Mar 20	Apr 20	May 20	Jun 20	Total		Savings by Area	Oct 19	Nov19	Dec 19	Jan 20	Feb 20	Mar 20	Apr 20	May 20	Jun 20
		England	12,012	83,165	170,051	170,051	170,051	170,051	170,051	170,051	170,051	1,285,533		England	3	12	23	23	23	23	23	23	23
		Scotland	0	23,487	228,512	228,512	228,512	228,512	228,512	228,512	228,512	1,623,070		Scotland	0	5	37	37	37	37	37	37	37
		Wales	0	151,756	172,326	172,326	172,326	172,326	172,326	172,326	172,326	1,358,036		Wales	0	22	25	25	25	25	25	25	25
		Ireland	0	43,682	145,180	145,180	145,180	145,180	145,180	145,180	145,180	1,059,940		Ireland	0	6	23	23	23	23	23	23	23
		Total	12,012	302,090	716,068	716,068	716,068	716,068	716,068	716,068	716,068	5,326,579		Total	3	45	108	108	108	108	108	108	108
		Savings by Position	Oct 19	Nov 19	Dec 19	Jan 20	Feb 20	Mar 20	Apr 20	May 20	Jun 20	Total		Savings by Position	Oct 19	Nov 19	Dec 19	Jan 20	Feb 20	Mar 20	Apr 20	May 20	Jun 20
		Contract Mger	- 0	104,000	169,000	169,000	169,000	169,000	169,000	169,000	169,000	1,287,000		Contract Mger	- 0	8	13	13	13	13	13	13	13
		Engineer	12,012	129,900	188,795	188,795	188,795	188,795	188,795	188,795	188,795	1,463,475		Engineer	3	25	37	37	37	37	37	37	37
		Accountant	- 0	6,918	59,921	59,921	59,921	59,921	59,921	59,921	59,921	426,368		Accountant	- 0	1	8	8	8	8	8	8	8
		Legal	- 0	19,892	74,640	74,640	74,640	74,640	74,640	74,640	74,640	542,369		Legal	- 0	2	9	9	9	9	9	9	9
		Administration	- 0	41,379	223,713	223,713	223,713	223,713	223,713	223,713	223,713	1,607,368		Administration	- 0	9	41	41	41	41	41	41	41
		Total	12,012	302,090	716,068	716,068	716,068	716,068	716,068	716,068	716,068	5,326,579		Total	3	45	108	108	108	108	108	108	108
		Chek Model		Model OK
Savings by Role Type Nov and Annual
Monthly Savings	
Contract Mger	Engineer	Accountant	Legal	Administation	104000	129900.33333333333	6918.166666666667	19892.166666666664	41379	Annual Savings	
Contract Mger	Engineer	Accountant	Legal	Administation	1287000	1463475	426367.49999999994	542368.66666666663	1607367.666666666	Annual Salary Savings
England	Scotland	Wales	Ireland	1285533.1666666663	1623069.4999999993	1358036.3333333335	1059939.8333333333	1	1	1	1	Annual FTE Savings by Region
Scotland	England	Wales	Ireland	23	37	25	23	
Annual FTE Savings by Positoin
Contract Mger	Engineer	Accountant	Legal	Administation	13	37	8	9	41	Length of Service
0-2	England	Scotland	Wales	Ireland	0.10810810810810811	0.21739130434782608	0	0	2-5	England	Scotland	Wales	Ireland	0.21621621621621623	8.6956521739130432E-2	0.36	0.30434782608695654	5-7	England	Scotland	Wales	Ireland	0.16216216216216217	8.6956521739130432E-2	0.08	8.6956521739130432E-2	7-10	England	Scotland	Wales	Ireland	0.16216216216216217	0.34782608695652173	0.16	0.17391304347826086	10+	England	Scotland	Wales	Ireland	0.35135135135135137	0.2608695652173913	0.4	0.43478260869565216	Departures by Type
Resigned	Contract Mger	Engineer	Accountant	Legal	Administation	1	16	1	2	9	Redundancy	Contract Mger	Engineer	Accountant	Legal	Administation	9	13	7	7	19	Dismissed	Contract Mger	Engineer	Accountant	Legal	Administation	3	8	0	0	13	Organisational Restructure Analysis