Test Page - not for public view

This example page demonstrates two ways of embedding tabular data into the FWSSC site.

1.  A table created in a spreadsheet and uploaded to the site.

This table was created in Excel, saved as a .csv file and uploaded into TablePress, the currently installed plugin for creating tables on this site.

Workflow:

• Enter data and create the table in a spreadsheet program such as MS Excel.  Tables can also be created from scratch from within WordPress but most users find web interfaces more confusing than those of desktop programs.
• Save the table as a .csv file.
• From the FWSSC site dashboard, import the table into TablePress.  Some minor editing might be necessary in TablePress depending on the details of the table.
• Embed the table into the desired site page using the table’s shortcode.
• Edits to tables should me made from within the site dashboard.  If tables are edited in a spreadsheet then the changed table must be uploaded and embedded as if it were a new table.

Advantages:

• The table maintains the appearance and styling of current tables like the existing tournament schedules.
• The table is responsive, adapting to different screen sizes.
• Tables can be edited from the WordPress dashboard.

Disadvantages

• Tables are independent of each other.  Changes made to data in one table will not automatically show up in related tables.  Data must be updated separately in every location where it occurs.

There are other ways of embedding excel tables in a site but generally they have all of the above disadvantages and more, particularly with respect to styling.  Workflows are generally of a similar complexity.

The table below is a table of SMA Flames player stats used here merely as an example.  The table was created in Excel and imported into the site.  Some minor editing of table settings was required from within the site dashboard.

 

Flames Prep Player Stats 2015 2016

#	Player	Position	GP	G	A	PTS	Penalty Mins	GP	GA	Shots Against	Shut Out	Mins	GAA
1	Logan Angers	G						21	26		5.5	925.52	1.432
30	Tory Micklash	G						22	29		3.5	959.37	1.539
2	Lexi Cheveldayoff	D	20	1	3	4	6
4	Kyra "KK" Thiessen	D	35	4	9	13	0
5	Hailey Cloutier	D	31	1	10	11	24
6	Ashleigh Jeannotte	D/F	37	0	8	8	16
7	Shea Studler	F	25	3	5	8	10
8	Sarah Dennehy	F	37	9	8	17	16
9	Karlee Mazor	D/F	37	0	5	5	20
10	Holly Reuther	F	37	10	14	24	12
11	Cecilia Lopez	F	35	15	11	26	32
12	Morgan Burr	F	33	7	20	27	8
13	Ashley McFadden	F	29	15	13	28	14
14	Emma Smith-Andrushko	F	31	11	16	27	14
15	Hailey Karbonik	D	35	2	13	15	44
16	Drew Raymond	D/F	18	1	2	3	8
17	Kaitlyn Chatyrbok	F/D	37	5	6	11	4
18	Kayla Friesen	F	31	21	29	50	28
19	Madison Arpin	F	20	1	5	6	28
20	Kennedy Frank	F	1	0	0	0	0
21	Seren Jocelyn	F	5	1	1	2	0
*20	Sydney Cancilla	F	6	0	0	0	0
22	Jenny Kim	F	1	0	0	0	0

 

2.  A table created using the SportsPress plugin for WordPress sites.

SportsPress is a WordPress plugin that is widely used around the world by professional and amateur sporting organizations to manage teams, conferences, tournaments, etc.

Workflow:

• Data is entered directly from within the site dash board.  Team data, player data, events, are all entered separately and can be modified at any time.
• An event schedule is created once other data has been entered.  The schedule can then be embedded in any desired page of the site using the table’s shortcode.
• Other tables can be easily created and used as desired from the data, e.g. player lists, League Tables.

Advantages:

• Tables are interconnected.  E.g. clicking on an event on the event list below will bring up a page with more details about that event.  Clicking on a player’s name in a list will bring up a detailed page about that player.
• Changes made in one place, e.g. player stats, will automatically show up on any table which refers to that data.
• There are lots of options – game stats, player stats, player and manager info pages, game review articles, player lists and more.  It is easy to chose what data is shown and what is hidden from atable or page.

Disadvantages

• The generic look of the SportsPress elements doesn’t match the current styling of the site.  This can be addressed but involves changes to code which is time consuming and not a realistic option in time for the upcoming tournament.
• I need to check more closely but I don’t think data can be imported or exported.  All data should be entered manually directly into the site.  This is mostly a one time effort prior to the tournament apart from updates during the tournament.

I have entered a small amount of of sample data and created some sample tables below to illustrate the functionality. Everything is an option. What data and tables are used, what data appears on tables is completely optional.

SportsPress example 1: An events list

The example below is an event schedule.  It could replace the current tournament schedule on the site. It currently just shows the first four games of the upcoming tournament for illustration purposes.  Not all the data shown here needs to be shown, e.g. competition, season and article should probably be hidden.  Only the SMA Flames and Vancouver teams have sample player data entered.

Clicking on an event brings up a separate page with more event details.

 

SportsPress example 2: A league standings table

The example below is a league standing table.  This might not be relevant to a simple tournament like the FWSSC as game results can show on the event list.

 

SportsPress example 3: A player list

The example below is a league standing table.  This might not be relevant to a simple tournament like the FWSSC as game results can show on the event list.

 

BELOW IS THE ORIGINAL SCHEDULE FROM THE “TOURNAMENT SCHEDULE” PAGE FOR REFERENCE>

#	Time	Round	Group	Home	Away	Arena	Score
Thursday, March 10, 2016
1	8:15 AM		A	St. Francis Xavier	Notre Dame	ACU	2-1 STFX
2	8:15 AM		B	Shattuck St. Mary's	Shaftesbury Hockey Academy	CT	7-1 Shattuck
3	8:30 AM		A	Vancouver Hockey Academy	St. Mary's Academy	RMX	7-0 St. Mary's
4	8:30 AM		B	Banff Hockey Academy	Pursuit of Excellence	RRC	2-0 POE
5	2:15 PM		A	Balmoral Hall	St. Francis Xavier	ACU
6	2:15 PM		B	Rothesay Netherwood	Shattuck St. Mary's	CT
7	5:15 PM		B	Shaftesbury Hockey Academy	Pursuit of Excellence	CT
8	5:30 PM		A	Notre Dame	St. Mary's Academy	RMX
9	8:15 PM		B	Banff Hockey Academy	Rothesay Netherwood	CT
10	8:30 PM		A	Vancouver Hockey Academy	Balmoral Hall	RMX
Friday, March 11, 2016
11	8:15 AM		A	Balmoral Hall	Notre Dame	CT
12	8:15 AM		B	Rothesay Netherwood	Shaftesbury Hockey Academy	ACU
13	8:30 AM		B	Pursuit of Excellence	Shattuck St. Mary's	RMX
14	8:30 AM		A	St. Mary's Academy	St. Francis Xavier	RRC
15	2:15 PM		A	Notre Dame	Vancouver Hockey Academy	CT
16	2:15 PM		B	Shaftesbury Hockey Academy	Banff Hockey Academy	ACU
17	7:45 PM		A	St. Mary's Academy	Balmoral Hall	CT
18	7:45 PM		B	Pursuit of Excellence	Rothesay Netherwood	ACU
19	8:15 PM		B	Shattuck St. Mary's	Banff Hockey Academy	RMX
20	8:15 PM		A	St. Francis Xavier	Vancouver Hockey Academy	RRC
Saturday, March 12, 2016
21	9:30 AM		9th Place	5A	5B	CT
22	9:30 AM		7th Place	4A	4B	ACU
23	9:45 AM		5th Place	3A	3B	RMX
24	12:30 PM		semi-final	1A	2B	CT
25	12:30 PM		semi-final	1B	2A	ACU
Sunday, March 13, 2016
26	10:15 AM		Bronze	L24	L25	CT
27	1:30 PM		Gold	W24	W25	CT
#	Time	Round	Group	Home	Away	Arena	Score