This final project consists of one spreadsheet that needs to calculate some numbers and be formatted. Please submit the spreadsheet as a .xlsx and .pdf file, using the file naming convention COMP9301_firstname_lastname_final project.xlsx and COMP9301_firstname_lastname_final project.pdf.

Version 2:

This final project consists of one spreadsheet that needs to calculate some numbers and be formatted. Please submit the spreadsheet as a .xlsx and .pdf file, using the file naming convention COMP9301_firstname_lastname_final project.xlsx and COMP9301_firstname_lastname_final project.pdf.

Scenario: You are the assistant to the general manager of the Calgary Flames. Your boss gives you all the statistics of the players from the past year and asks you to do some calculations and present your findings in a readable fashion.

Data File:

#	PLAYERS	POS	GP	G	A	PTS	PIM	PPG	PPA	SHG	SHA	GWG	LB	TO	CTO	S	SPCT	SOG
17	Dickson, Curtis	F	18	54		107	18	11	24	3	2	3	79	81	6	300	0.18	211
44	Dobbie, Dane	F	18	39		89	6	16	15	2	1	2	51	45	4	199	0.20	138
14	Berg, Wesley	F	18	35		79	7	13	16	1	2	0	75	30	7	199	0.18	141
77	Shattler, Jeff	F	18	20		71	11	4	13	1	3	0	95	56	14	162	0.12	115
23	Digby, Tyler	F	18	26		58	6	5	3	2	0	2	61	36	3	103	0.25	78
89	Loewen, Riley	F	18	15		35	6	0	1	0	0	1	26	18	1	87	0.17	56
19	Cattoni, Holden	F	15	7		26	5	0	2	1	1	0	26	26	3	75	0.09	52
18	Reid, Creighton	D	4	0		3	2	0	1	0	0	0	18	5	4	2	0.00	2
94	Bell, Tyson	D	18	8		14	34	1	0	1	0	0	108	13	16	27	0.30	24
3	MacRae, Dan	D	18	2		12	8	0	0	0	1	0	98	16	15	18	0.11	13
92	Scigliano, Frank	G	16	0		8	10	0	1	0	1	0	31	0	0	1	0.00	1
10	Manning, Curtis	D	18	1		7	12	0	0	0	2	0	79	8	17	11	0.09	7
55	Wilde, Mitch	D	9	0		3	2	0	0	0	0	0	43	14	6	13	0.00	7
25	Cummings, Chad	D	18	0		7	12	0	0	0	1	0	61	12	13	6	0.00	5
7	Burton, Tyler	D	15	0		5	13	0	0	0	0	0	76	15	18	9	0.00	5
6	McIntosh, Garrett	D	15	2		3	26	0	0	0	0	0	28	8	5	9	0.22	7
16	Carnegie, Mike	D	18	0		3	23	0	0	0	0	0	61	14	21	6	0.00	5
24	Carnegie, Scott	D	18	0		3	43	0	0	0	1	0	63	17	26	3	0.00	3
41	Snider, Bob	D	8	2		2	2	0	0	0	0	0	39	17	5	8	0.25	4
11	Harnett, Greg	D	8	1		2	50	0	0	1	0	0	25	3	10	4	0.25	2
35	Del Bianco, Christian	G	11	0		2	0	0	0	0	0	0	15	0	0	0	0.00	0
28	Harris, Vaughn	F	2	0		0	2	0	0	0	0	0	2	0	1	4	0.00	1
21	Leung, Karsen	D	0	0		0	0	0	0	0	0	0	0	0	0	0	0.00	0

NLL-Roster.xlsx

Steps:

1. Download the data file NLL-Roster.xlsx from the Final Project folder.
2. Save it to your desktop as COMP9301_firstname_lastname_final project.xlsx.
3. Format the spreadsheet to appear as shown:

Transcribed Image Text:

PLAYERS 17 Dickson. Curtis F 18 54 44 Dobble. Dane F 18 39 14 Berg. Wesley F 18 35 77 Shaftler, Jeff F 18 20 23 Digby, Tyler F 18 26 89 Loewen, Riley F 18 15 Calgary Roughnecks Roster POS GP Goals Assists Points PIM PPG PPA SHG SHA GWGS 32 21 7 13 16 1 4 13 35 6 0 SPCT SOG 53 107 18 11 24 3 300 18% 211 50 89 6 16 15 44 79 51 71 11 32 58 6 20 19 Cattoni, Holden F 15 7 19 26 $ 18 Reid. Creighton D 4 3 3 2 94 Bell, Tyson D 18 8 6 14 34 1 3 MacRae. Dan D 18 2 10 92 Scigliano, Frank G 16 8 10 Manning. Curtis D 18 1 6 712 12 8 8 10 55 Wilde. Mitch D 9 3 3 2 25 Cummings. Chad D 18 0 7 7 12 7 Burton, Tyler D 15 5 6 McIntosh, Garrett D 15 2 16 Camegle, Mike D 18 3 24 Camegle, Scott D 18 3 41 Snider, Bob D 8 2 11 Hamett, Greg D 8 1 1 35 Del Blanco, Christiar G 11 0 28 Harris. Vaughn F 2 21 Leung. Karsen D 0 200 3322200 5 13 3 26 3 23 3 43 2 2 50 0 2 0 -2300-00--20-000-ooooo 2--20-o-oooooooooo-ooo 633-2-oo-oooooooooooo scoo-oooooooooooooo 2 199 20% 138 0199 18% 141 0162 12% 115 2 103 25% 78 187 17% 56 1 075 9% 52 2 0% 2 1 027 30% 24 1 0 18 11% 13 1 1 0% 1 0 11 9% 7 013 0% 7 6 0% 5 1 1 ooooooooo 9 0% 5 9 22% 7 80400wa 6 0% 5 3 0% 3 8 25% 4 25% 2 0% 0% 1 0% 0 212 Most Penalties 50 Average Goals 9.2 PLAYERS 17 Dickson. Curtis F 18 54 44 Dobble. Dane F 18 39 14 Berg. Wesley F 18 35 77 Shaftler, Jeff F 18 20 23 Digby, Tyler F 18 26 89 Loewen, Riley F 18 15 Calgary Roughnecks Roster POS GP Goals Assists Points PIM PPG PPA SHG SHA GWGS 32 21 7 13 16 1 4 13 35 6 0 SPCT SOG 53 107 18 11 24 3 300 18% 211 50 89 6 16 15 44 79 51 71 11 32 58 6 20 19 Cattoni, Holden F 15 7 19 26 $ 18 Reid. Creighton D 4 3 3 2 94 Bell, Tyson D 18 8 6 14 34 1 3 MacRae. Dan D 18 2 10 92 Scigliano, Frank G 16 8 10 Manning. Curtis D 18 1 6 712 12 8 8 10 55 Wilde. Mitch D 9 3 3 2 25 Cummings. Chad D 18 0 7 7 12 7 Burton, Tyler D 15 5 6 McIntosh, Garrett D 15 2 16 Camegle, Mike D 18 3 24 Camegle, Scott D 18 3 41 Snider, Bob D 8 2 11 Hamett, Greg D 8 1 1 35 Del Blanco, Christiar G 11 0 28 Harris. Vaughn F 2 21 Leung. Karsen D 0 200 3322200 5 13 3 26 3 23 3 43 2 2 50 0 2 0 -2300-00--20-000-ooooo 2--20-o-oooooooooo-ooo 633-2-oo-oooooooooooo scoo-oooooooooooooo 2 199 20% 138 0199 18% 141 0162 12% 115 2 103 25% 78 187 17% 56 1 075 9% 52 2 0% 2 1 027 30% 24 1 0 18 11% 13 1 1 0% 1 0 11 9% 7 013 0% 7 6 0% 5 1 1 ooooooooo 9 0% 5 9 22% 7 80400wa 6 0% 5 3 0% 3 8 25% 4 25% 2 0% 0% 1 0% 0 212 Most Penalties 50 Average Goals 9.2