MotM thread for the 2014-15 season

[ZBBM]

Hey everybody --

Just a heads-up that my work schedule in the next few months will not allow me to keep on top of the Man of the Match thread as well as I have done the past 2 or 3 seasons.  If no one else wants to do it, I will do the best I can (assuming people still want to do it, and please chime in on that), but if there's someone out there who wants to take over, I'm very happy to hand it off and let them do it the way they want to.  If you're interested, PM me.  Thanks.

 

[ZBBM]

OK, looks like I'll be doing it again this season, which is fine, I just won't always be as timely as in the past.

Can anyone advise on the best way to post a table from Excel so that columns line up?  Can it be done?  I'd like to be able to do that this year rather than posting an image of a formatted table, as I did the last couple of years.  But when I copy and paste an Excel table using the Insert Table button, it comes out looking as it does below.  Any ideas?

The "Mr. T" Man of the Match Awards, 2013?14 No. of times voted MoTM (in win) No. of times voted MoTM (in loss) No. of times voted HM Total Points Total no. of accolades No. of games receiving votes Forwards   56 Spencer Abbott 0 0 0 0 0 0 37 Carter Ashton 0 0 0 0 0 2 40 Troy Bodie 2 0 1 7 3 10 63 Dave Bolland 0 1 2 4 3 8 42 Tyler Bozak 3 2 7 20 12 21 46 David Broll 0 0 0 0 0 0 71 David Clarkson 0 0 2 2 2 9 24 Peter Holland 1 1 2 7 4 8 29 Jerry D'Amigo 0 0 0 0 0 4 59 Jamie Devane 0 0 0 0 0 0 43 Nazem Kadri 2 1 5 13 8 20 81 Phil Kessel 5 5 9 34 19 32 41 Nikolai Kulemin 0 2 7 11 9 22 32 Josh Leivo 0 0 1 1 1 1 19 Joffrey Lupul 3 6 5 26 14 23 38 Frazer MacLaren 0 0 0 0 0 0 11 Jay McClement 1 0 3 6 4 14 39 Greg McKegg 0 0 0 0 0 0 28 Colton Orr 0 0 0 0 0 2 12 Mason Raymond 1 3 6 15 10 20 23 Trevor Smith 0 1 0 2 1 4 22 Jerred Smithson 0 0 0 0 0 0 21 James van Riemsdyk 2 3 6 18 11 27 Defensemen 4 Cody Franson 0 0 1 2 1 9 2 Mark Fraser 0 0 0 0 0 0 51 Jake Gardiner 0 6 4 26 10 22 8 Tim Gleason 0 1 2 7 0 10 Petter Granberg 0 0 0 0 0 1 36 Carl Gunnarsson 0 0 2 4 2 14 26 John-Michael Liles 0 0 0 0 0 1 3 Dion Phaneuf 0 2 3 12 5 21 15 Paul Ranger 0 0 0 0 0 8 44 Morgan Rielly 1 3 4 21 8 19 Goalkeepers 45 Jonathan Bernier 10 5 3 34.0 18 30 34 James Reimer 8 5 2 28.5 15 20 35 Drew McIntyre 0 0 1 0.5 1 1

 

[CarltonTheBear]

I'm pretty sure you would have to put in all of the table tags into the excel file as well. I started the first few rows, so something like this in excel...

... would spit out this when copied here...

The "Mr. T" Man of the Match Awards, 2013?14​

	No. of times voted MoTM (in win)	No. of times voted MoTM (in loss)	No. of times voted HM	Total Points	Total no. of accolades	No. of games receiving votes
Forwards
56 Spencer Abbott	0	0	0	0	0	0
37 Carter Ashton	0	0	0	0	0	2

 

Not sure if that's what you'd prefer to what you've used in the past, but that's of course up to you. If that's the way you want to go though let me know if you run into any problems finishing the rest of the table. Or if it's something you're really not sure of I can do the rest for you, can't do it right now but I could probably find some time before Wednesday.

 

[L K]

Forwards

No	Player		MoM/Win	MoM/Loss	HM	Points	Accolades	Times Voted
56	Spencer	Abbott	0	0	0	0	0	0
37	Carter	Ashton	0	0	0	0	0	2
40	Troy	Bodie	2	0	1	7	3	10
63	Dave	Bolland	0	1	2	4	3	8
42	Tyler	Bozak	3	2	7	20	12	21
46	David	Broll	0	0	0	0	0	0
71	David	Clarkson	0	0	2	2	2	9
24	Peter	Holland	1	1	2	7	4	8
29	Jerry	D'Amigo	0	0	0	0	0	4
59	Jamie	Devane	0	0	0	0	0	0
43	Nazem	Kadri	2	1	5	13	8	20
81	Phil	Kessel	5	5	9	34	19	32
41	Nikolai	Kulemin	0	2	7	11	9	22
32	Josh	Leivo	0	0	1	1	1	1
19	Joffrey	Lupul	3	6	5	26	14	23
38	Frazer	MacLaren	0	0	0	0	0	0
11	Jay	McClement	1	0	3	6	4	14
39	Greg	McKegg	0	0	0	0	0	0
28	Colton	Orr	0	0	0	0	0	2
12	Mason	Raymond	1	3	6	15	10	20
23	Trevor	Smith	0	1	0	2	1	4
22	Jerred	Smithson	0	0	0	0	0	0
21	James	van Riemsdyk	2	3	6	18	11	27

Defensemen

No	Player		MoM/Win	MoM/Loss	HM	Points	Accolades	Times Voted
4	Cody	Franson	0	0	1	2	1	9
2	Mark	Fraser	0	0	0	0	0	0
51	Jake	Gardiner	0	6	4	26	10	22
8	Tim	Gleason	0	1	2	7	0	10
8	Petter	Granberg	0	0	0	0	0	1
36	Carl	Gunnarsson	0	0	2	4	2	14
26	John-Michael	Liles	0	0	0	0	0	1
3	Dion	Phaneuf	0	2	3	12	5	21
15	Paul	Ranger	0	0	0	0	0	8
44	Morgan	Rielly	1	3	4	21	8	19

Goaltenders

No	Player		MoM/Win	MoM/Loss	HM	Points	Accolades	Times Voted
45	Jonathan	Bernier	10	5	3	34	18	30
34	James	Reimer	8	5	2	28.5	15	20
35	Drew	McIntyre	0	0	1	0.5	1	1

 

[ZBBM]

CTB, LK, many thanks for the tips.  I'll see if I can't continue on and format the base Excel table I use.  Will try to post a sample here when I get it.

 

[ZBBM]

Forwards MotM/Win MotM/Loss HonMen Points Accolades Times Voted

37 Carter Ashton 0 0 0 0 0 0

20 David Booth 0 0 0 0 0 0

42 Tyler Bozak 0 0 0 0 0 0

71 David Clarkson 0 0 0 0 0 0

39 Matt Frattin 0 0 0 0 0 0

24 Peter Holland 0 0 0 0 0 0

43 Nazem Kadri 0 0 0 0 0 0

67 Brandon Kozun 0 0 0 0 0 0

81 Phil Kessel 0 0 0 0 0 0

47 Leo Komarov 0 0 0 0 0 0

32 Josh Leivo 0 0 0 0 0 0

19 Joffrey Lupul 0 0 0 0 0 0

25 Mike Santorelli 0 0 0 0 0 0

26 Daniel Winnik 0 0 0 0 0 0

21 James van Riemsdyk 0 0 0 0 0 0

Defensemen

4 Cody Franson 0 0 0 0 0 0

51 Jake Gardiner 0 0 0 0 0 0

50 Stuart Percy 0 0 0 0 0 0

3 Dion Phaneuf 0 0 0 0 0 0

46 Roman Polak 0 0 0 0 0 0

44 Morgan Rielly 0 0 0 0 0 0

12 Stephane Robidas 0 0 0 0 0 0

Goalkeepers

45 Jonathan Bernier 0 0 0 0.0 0 0

34 James Reimer 0 0 0 0.0 0 0

testing 1 2 3

CTB & LK: For now I'm just using the tr & /tr syntax to get the players' names on separate rows.  If I apply the td & /td syntax to individual cells in Excel it doesn't let me use my formulas for auto-calcing the points & number of accolades.

Not the prettiest but hopefully legible.  And much faster for me.