Introduction

Fixtures are created in a google sheet, these can be separated by season by the use of worksheets within the document. An example can be found here

When setting up your league, team please use the sample sheet created by DryKISS to benefit the most from our system.

Managing the spreadsheet

Firstly the google sheet must be shared and viewable by all, but not editable. Giving us the Key to the sheet will then allow us to start processing the information contained. For specific worksheets we will also need the GID. We basically then construct a URL to download the CSV.

https://docs.google.com/spreadsheets/d/1uTnHOsDCHwvxmxX41sxCsZDnkPNj_7ImUGYQb3yEMjo/export?format=csv

We will help set up data validation rules for certain columns such as ground, referee and teams. This will create dropdown lists on each row for easy selection, but also to provide the consistency required by the system. It will highlight where data is entered incorrectly.

Goals scorers

Adding a list of players names for the goal scorers is possible, please make sure that the names used are the same throughout all the results so we can provide a total goals for each player. This list must be separated by a semi-colon ;

Yellow and red cards

Similar to the above the add the players who received a card to a list.

Cup

Cup / plate rules and rounds, write in the competition the name of the cup competition, this needs to be consistent within the sheet. The cup column is where you indicate the round with 1 indicating the final. So the semi-final would be 2 and so on.

Date and time

It's just a matter of keeping this consistent throughout the sheet. Google will often translate the date and time automatically.

Ground

We will help set up Data validation rules so

Season Pages

Based on each season created, the system will automatically create pages that display each seasons fixtures, including cup competitions.

Competition Kick-off Home Team Away Team
Division 1 03/06/2016 - 19:10:00
Hachioji Park | TBC
Oakwood Geckoes
Imperio FA

v

Division 2 03/06/2016 - 17:00:00
Fukuda Denshi | TBC
BFC Vagabonds
Syu Syu Aoyama

v

Cup 03/06/2016 - 15:10:00
Fukuda Denshi | TBC
Sala FC
Guts FC

v

Division 3 03/06/2016 - 15:10:00
Redsland | TBC
Saitama Jets
YCAC 1868

v

Division 2 03/06/2016 - 13:00:00
YCAC | TBC
King George FC
British Embassy FC

v

Cup 03/05/2016 - 19:10:00
Hachioji Park | TBC
Kanto Celts FC
FC International

v

Division Plate 03/05/2016 - 18:00:00
YCAC | TBC
Fussa FC
Real Celts FC

v

Cup 03/05/2016 - 15:10:00
Fukuda Denshi | TBC
Panthers FC
Swiss Kickers

v

Division 3 02/28/2016 - 19:00:00
Hachioji Park | TBC
Shane FC
Guts FC

v

Division 2 02/28/2016 - 17:10:00
Hachioji Park | TBC
Syu Syu Aoyama
Zion FC

v

Division 3 02/28/2016 - 15:00:00
YCAC | TBC
Albion Oldboys
YCAC 1868

v

Division 3 02/27/2016 - 19:00:00
Hachioji Park | TBC
Real Celts FC
Oakwood Clash

v

Division 1 02/27/2016 - 17:30:00
YCAC | TBC
Imperio FA
Hibernian FC

v

Division 2 02/27/2016 - 17:10:00
Fukuda Denshi | TBC
Lions FC
Dutch FC

v

Division 2 02/27/2016 - 17:10:00
Hachioji Park | TBC
Fussa FC
Sala FC

v

Division 3 02/27/2016 - 16:00:00
YCAC | TBC
Musketeers FC
Jetro FC

v

Division 1 02/27/2016 - 14:30:00
YCAC | TBC
Panthers FC
Swiss Kickers

v

Division 3 02/21/2016 - 17:10:00
Shimo Takaido | TBC
Nepal United FC
Oakwood Clash

v

Division 3 02/21/2016 - 15:10:00
Redsland | TBC
Saitama Jets
Guts FC

v

Division 3 02/21/2016 - 13:00:00
YCAC | TBC
YCAC 1868
Shane FC

v

Division 1 02/21/2016 - 09:10:00
Chofu Nishimachi | TBC
Barbarians FC
El Diego FC

v

Division 1 02/20/2016 - 18:30:00
YCAC | TBC
Kanto Celts FC
FC International

v

Division 2 02/20/2016 - 17:10:00
Hachioji Park | TBC
King George FC
Sala FC

v

Division 2 02/20/2016 - 17:00:00
YCAC | TBC
Lions FC
British Embassy FC

v

Division 2 02/20/2016 - 10:00:00
YCAC | TBC
Dutch FC
BFC Vagabonds

v

Division 1 02/14/2016 - 19:00:00
Hachioji Park | TBC
Barbarians FC
Hibernian FC

v

Division 3 02/14/2016 - 18:10:00
Redsland | TBC
Saitama Jets
Real Celts FC

v

Division Plate 02/14/2016 - 17:10:00
Hachioji Park | TBC
Syu Syu Aoyama
Zion FC

v

Division 3 02/14/2016 - 13:10:00
St Marys | TBC
Albion Oldboys
Musketeers FC

v

Division 1 02/13/2016 - 19:10:00
Hachioji Park | TBC
BFC Tokyo
Swiss Kickers

v

Division 1 02/13/2016 - 14:15:00
YCAC | TBC
El Diego FC
Oakwood Geckoes

v

Division 2 02/13/2016 - 13:10:00
Setagaya Koen | TBC
Pumas FC
BFC Vagabonds

v

Division 3 02/07/2016 - 17:00:00
Fukuda Denshi | Nick Lines
Guts FC
Musketeers FC
0
v

3
Division 2 02/07/2016 - 15:10:00
Fukuda Denshi | Nick Lines
Lions FC
Sala FC
3
v

3
Division 3 02/07/2016 - 15:10:00
Redsland | Aaron Balogh
Saitama Jets
Jetro FC
0
v

1
Division 3 02/07/2016 - 15:00:00
YCAC | Jonathan Boettger
Shane FC
Albion Oldboys
1
v

2
Division 1 02/06/2016 - 19:00:00
Hachioji Park | TBC
Hibernian FC
Kanto Celts FC
1
v

0
Division 1 02/06/2016 - 17:10:00
Hachioji Park | Aaron Balogh
BFC Tokyo
FC International
3
v

0
Division 2 02/06/2016 - 15:30:00
YCAC | Stephen Etherington
British Embassy FC
Fussa FC
3
v

0
Division 1 02/06/2016 - 14:00:00
YCAC | Stephen Etherington
Swiss Kickers
Imperio FA
13
v

1
Division 1 02/06/2016 - 11:10:00
Tennozu Isle | Quentin
El Diego FC
Panthers FC
1
v

9
Division 1 02/06/2016 - 10:00:00
YCAC | Simon Lloyd
Oakwood Geckoes
Barbarians FC
3
v

4
Cup 01/31/2016 - 19:00:00
Hachioji Park | Aaron Balogh
Barbarians FC
Sala FC
2
v

4
Division Plate 01/31/2016 - 17:10:00
Hachioji Park | Aaron Balogh
King George FC
Real Celts FC
1
v

4
Division Plate 01/31/2016 - 14:30:00
YCAC | Stephen Etherington
Pumas FC
Nepal United FC
2
v

1
Division 3 01/31/2016 - 14:10:00
Redsland | Kazu Urushiyama
Saitama Jets
Oakwood Clash
2
v

1
Division 3 01/31/2016 - 13:00:00
YCAC | Stephen Etherington
YCAC 1868
Guts FC
1
v

3
Division 1 01/30/2016 - 19:10:00
Hachioji Park | Aaron Balogh
Hibernian FC
FC International
2
v

0
Division 1 01/30/2016 - 18:15:00
YCAC | Simon Lloyd
Kanto Celts FC
Swiss Kickers
4
v

4
Division 1 01/30/2016 - 17:10:00
Fukuda Denshi | Nick Lines
Panthers FC
Imperio FA
5
v

0
Division 2 01/30/2016 - 16:45:00
YCAC | Jonathan Boettger
Fussa FC
BFC Vagabonds
1
v

0
Division 2 01/30/2016 - 15:15:00
YCAC | Jonathan Boettger
Zion FC
British Embassy FC
0
v

1
Cup 01/24/2016 - 19:00:00
Hachioji Park | TBC
BFC Tokyo
Hibernian FC
0
v

4
Division 3 01/24/2016 - 18:10:00
Redsland | Quentin
Saitama Jets
Shane FC
1
v

1
Cup 01/24/2016 - 17:10:00
Fukuda Denshi | Nick Lines
FC International
Lions FC
6
v

1
Division 2 01/24/2016 - 17:10:00
Hachioji Park | TBC
Pumas FC
Syu Syu Aoyama
11
v

0
Cup 01/24/2016 - 13:00:00
YCAC | TBC
YCAC 1868
Imperio FA
4
v

2
Cup 01/23/2016 - 19:00:00
Shigaku | Aaron Balogh
Kanto Celts FC
Dutch FC
3
v

1
Division Plate 01/23/2016 - 17:00:00
Shigaku | Aaron Balogh
Albion Oldboys
Musketeers FC
1
v

5
Division 2 01/23/2016 - 15:00:00
Shigaku | Nick Lines
British Embassy FC
Zion FC
3
v

1
Division Plate 01/23/2016 - 15:00:00
Hachioji Park | Stephen Etherington
Oakwood Geckoes
Fussa FC
0
v

1
Cup 01/23/2016 - 13:10:00
Shigaku | Nick Lines
Swiss Kickers
El Diego FC
7
v

1
Cup 01/23/2016 - 13:10:00
Hachioji Park | Stephen Etherington
Jetro FC
Panthers FC
0
v

8
Division 2 01/17/2016 - 19:10:00
Hachioji Park | Aaron Balogh
Syu Syu Aoyama
King George FC
4
v

1
Division Plate 01/17/2016 - 15:10:00
Redsland | Aaron Balogh
Saitama Jets
British Embassy FC
0
v

5
Division 2 01/17/2016 - 14:30:00
YCAC | Stephen Etherington
Dutch FC
Lions FC
4
v

1
Division 3 01/17/2016 - 13:00:00
YCAC | Stephen Etherington
YCAC 1868
Real Celts FC
2
v

4
Division 2 01/16/2016 - 18:30:00
YCAC | Quentin
Fussa FC
Sala FC
4
v

3
Division 1 01/16/2016 - 17:10:00
Fukuda Denshi | Kazu Urushiyama
BFC Tokyo
Kanto Celts FC
2
v

2
Division 3 01/16/2016 - 17:10:00
Shimo Takaido | Stephen Etherington
Jetro FC
Albion Oldboys
2
v

2
Division 2 01/16/2016 - 17:00:00
YCAC | Quentin
Pumas FC
Zion FC
3
v

1
Division 3 01/10/2016 - 19:30:00
Akabane Ground | Kazu Urushiyama
Nepal United FC
Real Celts FC
0
v

3
Division 3 01/10/2016 - 19:10:00
Hachioji Park | Aaron Balogh
Musketeers FC
Shane FC
0
v

1
Division 2 01/10/2016 - 18:05:00
Akabane Ground | TBC
King George FC
Lions FC
2
v

1
Division Plate 01/10/2016 - 14:30:00
YCAC | Jonathan Boettger
BFC Vagabonds
Oakwood Clash
1
v

2
Cup 01/10/2016 - 13:00:00
YCAC | Jonathan Boettger
CCJ
Guts FC
0
v

3
Division 2 12/19/2015 - 17:15:00
YCAC | Kazu Urushiyama
Sala FC
Dutch FC
4
v

0
Division 3 12/19/2015 - 09:00:00
Koishikawa | Simon Lloyd
Nepal United FC
Jetro FC
0
v

3
Division 2 12/13/2015 - 18:45:00
Shigaku | Nick Lines
Dutch FC
Syu Syu Aoyama
2
v

2
Division 3 12/13/2015 - 17:10:00
Horisaki Koen | Aaron Balogh
Guts FC
Jetro FC
0
v

0
Division 1 12/13/2015 - 17:00:00
Shigaku | Nick Lines
FC International
BFC Tokyo
5
v

3
Division 2 12/13/2015 - 15:10:00
Shigaku | Kazu Urushiyama
BFC Vagabonds
Sala FC
1
v

2
Division 1 12/13/2015 - 14:30:00
YCAC | Robert Peacock
Imperio FA
Panthers FC
0
v

6
Division 3 12/13/2015 - 14:00:00
Redsland | Aaron Balogh
Saitama Jets
Nepal United FC
6
v

1
Division 3 12/13/2015 - 13:00:00
YCAC | Robert Peacock
YCAC 1868
Oakwood Clash
2
v

4
Division 2 12/12/2015 - 19:10:00
Hachioji Park | Aaron Balogh
Fussa FC
British Embassy FC
3
v

2
Division 2 12/12/2015 - 17:10:00
Tennozu Isle | Quentin
King George FC
Pumas FC
2
v

7
Division 2 12/12/2015 - 17:00:00
YCAC | Jonathan Boettger
Lions FC
Zion FC
1
v

5
Division 1 12/12/2015 - 11:00:00
Shibuya Sports Center | Stephen Etherington
Barbarians FC
Oakwood Geckoes
4
v

2
Division 1 12/12/2015 - 09:20:00
Shibuya Sports Center | Stephen Etherington
El Diego FC
Swiss Kickers
1
v

5
Division 3 12/06/2015 - 19:10:00
Hachioji Park | Kazu Urushiyama
Guts FC
Real Celts FC
3
v

3
Division 3 12/06/2015 - 15:10:00
Redsland | Aaron Balogh
Saitama Jets
Musketeers FC
0
v

2
Division 3 12/06/2015 - 13:00:00
YCAC | Robert Peacock
YCAC 1868
Shane FC
2
v

4
Division 3 12/06/2015 - 10:30:00
St Marys | Tomas Motyka
Albion Oldboys
Oakwood Clash
0
v

2
Division 1 12/05/2015 - 19:20:00
Shigaku | Nick Lines
Oakwood Geckoes
Swiss Kickers
0
v

2
Division 1 12/05/2015 - 18:30:00
YCAC | Simon Lloyd
El Diego FC
Hibernian FC
0
v

8
Division 1 12/05/2015 - 17:50:00
Shigaku | Nick Lines
FC International
Barbarians FC
2
v

3
Division 2 12/05/2015 - 16:10:00
Shigaku | Kazu Urushiyama
BFC Vagabonds
Fussa FC
1
v

2
Division 3 11/29/2015 - 19:10:00
Horisaki Koen | Aaron Balogh
Shane FC
Musketeers FC
1
v

4
Division 1 11/29/2015 - 19:00:00
Hachioji Park | Jonathan Boettger
Oakwood Geckoes
Hibernian FC
1
v

6
Division 2 11/29/2015 - 17:10:00
Hachioji Park | Jonathan Boettger
Syu Syu Aoyama
Fussa FC
3
v

3
Division 3 11/29/2015 - 15:10:00
Redsland | Aaron Balogh
Saitama Jets
Albion Oldboys
1
v

2
Division 1 11/29/2015 - 14:30:00
YCAC | Stephen Etherington
BFC Tokyo
Imperio FA
5
v

1
Division 3 11/29/2015 - 13:00:00
YCAC | Stephen Etherington
Guts FC
Oakwood Clash
3
v

7
Division 3 11/29/2015 - 11:30:00
YCAC | TBC
YCAC 1868
Jetro FC
2
v

4
Division 1 11/28/2015 - 19:00:00
Hachioji Park | Aaron Balogh
El Diego FC
Kanto Celts FC
0
v

1
Division 2 11/28/2015 - 17:10:00
Hachioji Park | Aaron Balogh
King George FC
Sala FC
0
v

3
Division 2 11/28/2015 - 16:00:00
YCAC | Jonathan Boettger
Dutch FC
Zion FC
1
v

2
Division 1 11/28/2015 - 15:00:00
Horisaki Koen | Kazu Urushiyama
Swiss Kickers
Panthers FC
1
v

1
Division 2 11/28/2015 - 13:10:00
Horisaki Koen | Kazu Urushiyama
Lions FC
Pumas FC
1
v

6
Division 2 11/28/2015 - 10:00:00
Horisaki Koen | Simon Lloyd
BFC Vagabonds
British Embassy FC
1
v

2
Cup 11/22/2015 - 19:10:00
Chofu Nishimachi | Stephen Etherington
Swiss Kickers
Nepal United FC
9
v

0
Division 3 11/22/2015 - 18:10:00
Redsland | Kazu Urushiyama
Saitama Jets
Real Celts FC
2
v

2
Division 3 11/22/2015 - 14:30:00
YCAC | Tomas Motyka
Guts FC
Jetro FC
3
v

2
Division 3 11/22/2015 - 13:00:00
YCAC | Tomas Motyka
YCAC 1868
Musketeers FC
2
v

4
Division 1 11/21/2015 - 19:00:00
Hachioji Park | Stephen Etherington
FC International
Panthers FC
5
v

0
Division 1 11/21/2015 - 18:15:00
YCAC | Kazu Urushiyama
Hibernian FC
Imperio FA
7
v

0
Division 1 11/21/2015 - 17:10:00
Hachioji Park | Stephen Etherington
Kanto Celts FC
BFC Tokyo
1
v

2
Cup 11/21/2015 - 13:40:00
YCAC | Jonathan Boettger
Barbarians FC
Zion FC
7
v

0
Division 2 11/21/2015 - 13:10:00
Fukuda Denshi | Nick Lines
Pumas FC
Syu Syu Aoyama
10
v

0
Division 3 11/15/2015 - 18:50:00
Horisaki Koen | Quentin
Jetro FC
Shane FC
1
v

1
Division 2 11/15/2015 - 17:10:00
Horisaki Koen | Quentin
King George FC
British Embassy FC
1
v

3
Division 2 11/15/2015 - 13:10:00
Fukuda Denshi | Nick Lines
Lions FC
Sala FC
0
v

4
Division 3 11/15/2015 - 10:30:00
St Marys | Stephen Etherington
Albion Oldboys
Nepal United FC
3
v

3
Division 1 11/14/2015 - 19:10:00
Hachioji Park | Aaron Balogh
FC International
Oakwood Geckoes
2
v

1
Cup 11/14/2015 - 15:30:00
YCAC | Jonathan Boettger
Panthers FC
Fussa FC
3
v

0
Division 1 11/14/2015 - 14:00:00
YCAC | Jonathan Boettger
El Diego FC
Barbarians FC
2
v

3
Division 3 11/08/2015 - 16:10:00
Redsland | Quentin
Saitama Jets
Oakwood Clash
3
v

4
Division 3 11/08/2015 - 11:30:00
YCAC | Stephen Etherington
YCAC 1868
Albion Oldboys
2
v

3
Division 1 11/07/2015 - 19:00:00
Shigaku | Nick Lines
BFC Tokyo
El Diego FC
5
v

1
Division 1 11/07/2015 - 19:00:00
Hachioji Park | Stephen Etherington
Hibernian FC
Swiss Kickers
6
v

1
Cup 11/07/2015 - 17:10:00
Shigaku | Nick Lines
BFC Vagabonds
Jetro FC
0
v

1
Division 2 11/07/2015 - 17:10:00
Hachioji Park | Stephen Etherington
King George FC
Zion FC
2
v

3
Division 1 11/07/2015 - 16:25:00
YCAC | Jonathan Boettger
Kanto Celts FC
Oakwood Geckoes
4
v

1
Division 3 11/07/2015 - 14:55:00
YCAC | Kazu Urushiyama
Musketeers FC
Real Celts FC
2
v

4
Division 2 11/07/2015 - 13:25:00
YCAC | Kazu Urushiyama
Pumas FC
Sala FC
4
v

1
Cup 11/01/2015 - 19:10:00
Shigaku | Robert Peacock
Guts FC
Real Celts FC
5
v

3
Cup 11/01/2015 - 19:10:00
Hachioji Park | Kazu Urushiyama
BFC Tokyo
Shane FC
3
v

0
Cup 11/01/2015 - 18:10:00
Redsland | Aaron Balogh
FC International
Saitama Jets
2
v

2
Cup 11/01/2015 - 17:40:00
Shigaku | Robert Peacock
Sala FC
King George FC
8
v

1
Division 2 11/01/2015 - 16:05:00
Shigaku | Quentin
BFC Vagabonds
Zion FC
1
v

2
Cup 11/01/2015 - 13:00:00
YCAC | Tomas Motyka
Albion Oldboys
YCAC 1868
2
v

3
Division 1 10/31/2015 - 19:00:00
Hachioji Park | Robert Peacock
Panthers FC
Barbarians FC
3
v

1
Cup 10/31/2015 - 18:00:00
YCAC | Jonathan Boettger
El Diego FC
Oakwood Clash
4
v

1
Cup 10/31/2015 - 17:10:00
Hachioji Park | Robert Peacock
Kanto Celts FC
Pumas FC
2
v

0
Cup 10/31/2015 - 16:30:00
YCAC | Jonathan Boettger
Imperio FA
Syu Syu Aoyama
5
v

3
Cup 10/31/2015 - 15:00:00
Komaba Sub Ground | Stephen Etherington
Oakwood Geckoes
Dutch FC
1
v

1
Cup 10/31/2015 - 15:00:00
YCAC | Simon Lloyd
Musketeers FC
CCJ
1
v

1
Cup 10/31/2015 - 13:10:00
Komaba Sub Ground | Stephen Etherington
Lions FC
British Embassy FC
7
v

1
Division 2 10/25/2015 - 19:30:00
Oi Futo Astro | Quentin
Syu Syu Aoyama
British Embassy FC
1
v

1
Division 3 10/25/2015 - 19:10:00
Hachioji Park | Robert Peacock
Shane FC
Real Celts FC
3
v

1
Division 2 10/25/2015 - 18:05:00
Oi Futo Astro | Quentin
Fussa FC
Lions FC
3
v

1
Division 3 10/25/2015 - 15:10:00
Redsland | Aaron Balogh
Saitama Jets
Guts FC
8
v

3
Division 3 10/25/2015 - 11:30:00
YCAC | Stephen Etherington
YCAC 1868
Nepal United FC
6
v

7
Division 3 10/24/2015 - 19:10:00
Hachioji Park | Kazu Urushiyama
Musketeers FC
Oakwood Clash
7
v

3
Division 1 10/24/2015 - 17:10:00
Komaba Sub Ground | Stephen Etherington
Imperio FA
Swiss Kickers
1
v

8
Division 2 10/24/2015 - 10:30:00
Komaba Sub Ground | Aaron Balogh
BFC Vagabonds
Dutch FC
0
v

0
Division 1 10/24/2015 - 09:05:00
Komaba Sub Ground | Aaron Balogh
El Diego FC
Oakwood Geckoes
0
v

0
Division 3 10/18/2015 - 15:10:00
Redsland | Robert Peacock
Saitama Jets
Shane FC
1
v

1
Division 1 10/17/2015 - 19:00:00
Hachioji Park | Stephen Etherington
Kanto Celts FC
Panthers FC
6
v

1
Division 2 10/17/2015 - 17:10:00
Fukuda Denshi | Nick Lines
Lions FC
British Embassy FC
0
v

2
Division 1 10/17/2015 - 17:10:00
Hachioji Park | TBC
BFC Tokyo
Swiss Kickers
1
v

7
Division 3 10/11/2015 - 18:40:00
Koishikawa | Stephen Etherington
Nepal United FC
Guts FC
0
v

1
Division 2 10/11/2015 - 17:10:00
Fukuda Denshi | Nick Lines
British Embassy FC
Sala FC
0
v

0
Division 1 10/11/2015 - 17:10:00
Chofu Nishimachi | Kazu Urushiyama
Barbarians FC
Imperio FA
4
v

0
Division 3 10/11/2015 - 13:00:00
YCAC | Aaron Balogh
YCAC 1868
Oakwood Clash
3
v

0
Division 3 10/11/2015 - 10:30:00
St Marys | Robert Peacock
Albion Oldboys
Shane FC
3
v

3
Division 1 10/10/2015 - 18:00:00
YCAC | Jonathan Boettger
FC International
Hibernian FC
3
v

2
Division 3 10/10/2015 - 17:10:00
Komaba Sub Ground | Aaron Balogh
Musketeers FC
Jetro FC
4
v

3
Division 2 10/10/2015 - 17:10:00
Hachioji Park | Robert Peacock
King George FC
Dutch FC
2
v

5
Division 1 10/10/2015 - 16:30:00
YCAC | Jonathan Boettger
Oakwood Geckoes
Panthers FC
1
v

4
Division 2 10/10/2015 - 15:00:00
YCAC | Kazu Urushiyama
Pumas FC
Fussa FC
5
v

1
Division 2 10/10/2015 - 09:15:00
Shigaku | Nick Lines
BFC Vagabonds
Syu Syu Aoyama
0
v

0
Division 3 10/04/2015 - 11:30:00
YCAC | Stephen Etherington
YCAC 1868
Guts FC
1
v

2
Division 3 10/04/2015 - 10:30:00
St Marys | Aaron Balogh
Albion Oldboys
Real Celts FC
1
v

1
Division 2 10/04/2015 - 09:15:00
Oi Futo Dai Ichi | Tomas Motyka
King George FC
Syu Syu Aoyama
3
v

7
Division 1 10/03/2015 - 19:00:00
YCAC | Quentin
Panthers FC
Hibernian FC
1
v

1
Division 3 10/03/2015 - 19:00:00
Hachioji Park | Aaron Balogh
Oakwood Clash
Jetro FC
2
v

4
Division 2 10/03/2015 - 17:30:00
YCAC | Quentin
Pumas FC
Dutch FC
7
v

1
Division 1 10/03/2015 - 17:10:00
Hachioji Park | Aaron Balogh
Kanto Celts FC
FC International
1
v

2
Division 2 10/03/2015 - 16:00:00
YCAC | Jonathan Boettger
Lions FC
BFC Vagabonds
4
v

3
Division 1 10/03/2015 - 14:30:00
YCAC | Stephen Etherington
Barbarians FC
BFC Tokyo
1
v

0
Division 2 10/03/2015 - 13:00:00
YCAC | Stephen Etherington
Sala FC
Zion FC
2
v

1
Division 1 09/26/2015 - 19:30:00
Shigaku | Kazu Urushiyama
Kanto Celts FC
Hibernian FC
2
v

1
Division 3 09/26/2015 - 19:10:00
Horisaki Koen | Robert Peacock
Saitama Jets
Musketeers FC
3
v

3
Division 2 09/26/2015 - 18:05:00
Shigaku | Kazu Urushiyama
BFC Vagabonds
King George FC
6
v

2
Division 1 09/26/2015 - 15:00:00
Horisaki Koen | Tomas Motyka
Oakwood Geckoes
BFC Tokyo
2
v

3
Division 2 09/26/2015 - 15:00:00
Hachioji Park | Stephen Etherington
Dutch FC
Sala FC
1
v

1
Division 1 09/26/2015 - 13:10:00
Horisaki Koen | Tomas Motyka
Swiss Kickers
Barbarians FC
13
v

0
Division 1 09/26/2015 - 13:10:00
Hachioji Park | Stephen Etherington
El Diego FC
Imperio FA
3
v

1
Division 2 09/26/2015 - 09:10:00
YCAC | Jonathan Boettger
Zion FC
Pumas FC
1
v

1
Division 3 09/22/2015 - 14:30:00
Koishikawa | Quentin
Nepal United FC
Shane FC
2
v

0
Division 3 09/20/2015 - 14:30:00
YCAC | Stephen Etherington
Guts FC
Albion Oldboys
2
v

1
Division 3 09/20/2015 - 13:00:00
YCAC | Stephen Etherington
YCAC 1868
Real Celts FC
6
v

2
Division 2 09/20/2015 - 11:30:00
YCAC | Jonathan Boettger
King George FC
Fussa FC
1
v

4
Division 2 09/19/2015 - 19:10:00
Horisaki Koen | Kazu Urushiyama
Syu Syu Aoyama
Sala FC
8
v

5
Division 1 09/19/2015 - 19:10:00
Hachioji Park | Simon Lloyd
Kanto Celts FC
Imperio FA
6
v

0
Division 3 09/19/2015 - 09:00:00
Koishikawa | Quentin
Nepal United FC
Musketeers FC
1
v

5
Division 2 09/13/2015 - 15:15:00
YCAC | Stephen Etherington
Zion FC
Fussa FC
2
v

1
Division 3 09/13/2015 - 15:10:00
Fukuda Denshi | Nick Lines
Shane FC
Oakwood Clash
3
v

2
Division 1 09/12/2015 - 19:00:00
Shigaku | Kazu Urushiyama
BFC Tokyo
Panthers FC
1
v

7
Division 1 09/12/2015 - 18:50:00
Hachioji Park | Aaron Balogh
FC International
Imperio FA
13
v

0
Division 2 09/12/2015 - 17:10:00
Shigaku | Kazu Urushiyama
BFC Vagabonds
Pumas FC
2
v

3
Division 1 09/12/2015 - 17:00:00
Hachioji Park | Aaron Balogh
Hibernian FC
Barbarians FC
2
v

7
Division 1 09/12/2015 - 15:00:00
Fukuda Denshi | Nick Lines
Oakwood Geckoes
Swiss Kickers
0
v

5
Division 3 09/12/2015 - 15:00:00
Hachioji Park | Tomas Motyka
Jetro FC
Albion Oldboys
4
v

0
Division 2 09/12/2015 - 13:10:00
Fukuda Denshi | Nick Lines
Lions FC
Syu Syu Aoyama
3
v

9
Division 2 09/12/2015 - 13:10:00
Hachioji Park | Tomas Motyka
Dutch FC
British Embassy FC
0
v

1
Division 3 09/06/2015 - 19:10:00
Chofu Nishimachi | Tomas Motyka
Nepal United FC
Real Celts FC
4
v

4
Division 3 09/06/2015 - 16:10:00
Redsland | Aaron Balogh
Saitama Jets
Jetro FC
2
v

0
Division 1 09/05/2015 - 19:20:00
YCAC | Stephen Etherington
BFC Tokyo
Hibernian FC
2
v

3
Division 2 09/05/2015 - 17:50:00
YCAC | Jonathan Boettger
Fussa FC
Zion FC
3
v

0
Division 1 09/05/2015 - 17:10:00
Hachioji Park | Aaron Balogh
El Diego FC
FC International
2
v

6
Division 3 09/05/2015 - 16:20:00
YCAC | Jonathan Boettger
Albion Oldboys
Musketeers FC
0
v

2
Division 2 09/05/2015 - 13:50:00
Shibuya Sports Center | TBC
Pumas FC
British Embassy FC
0
v

1
Division 3 08/30/2015 - 17:10:00
Fukuda Denshi | Nick Lines
Shane FC
Guts FC
6
v

2
Division 1 08/30/2015 - 15:10:00
YCAC | Jonathan Boettger
Imperio FA
Oakwood Geckoes
2
v

0
Division 3 08/29/2015 - 19:10:00
Chofu Nishimachi | Tomas Motyka
Nepal United FC
Oakwood Clash
3
v

2
Division 1 08/29/2015 - 19:10:00
Hachioji Park | TBC
Swiss Kickers
FC International
4
v

1
Division 2 08/29/2015 - 17:10:00
Horisaki Koen | Simon Lloyd
King George FC
Lions FC
2
v

4
Division 2 08/29/2015 - 16:15:00
YCAC | Jonathan Boettger
Zion FC
Syu Syu Aoyama
8
v

2
Division 1 08/29/2015 - 10:30:00
Komaba Sub Ground | Aaron Balogh
Barbarians FC
Kanto Celts FC
3
v

0
Division 1 08/29/2015 - 10:30:00
Horisaki Koen | Kazu Urushiyama
El Diego FC
Panthers FC
2
v

6
Division 3 08/29/2015 - 09:05:00
Komaba Sub Ground | Aaron Balogh
Jetro FC
Real Celts FC
4
v

0
Division 2 08/29/2015 - 09:05:00
Horisaki Koen | Kazu Urushiyama
Dutch FC
Fussa FC
2
v

1

Resources Useful websites and tutorials

Tasks

Task Date
FE: Design the fixture table better - utilise angular grid for in-line search and filtering
FE: Translate any text strings
FE: Document the widget and the automatically created pages.
FE: Document how a user manages the spreadsheet for fixtures
FE: Create a weekly round up of results based on the week number of the year.
API: Currently this does not use the API, get this functioning like the Table script
API: Date / Time normalisation, Kick off time should be : Aug 18th @ 17:50 Produce a separate method to process this, from the fixtures date - 2014-09-04 and time 19:10
API: Allow grouping fixtures for season, division, competition and team and secondly combination of these
API: For Team - get all the fixtures for a given season with option on competition
API: Competition is cup, league or plate
API: Need to work out current season from the fixtures i.e. max( season )
API: Rule - unplayed games - these will be ones where scores are not updated
API: Scorers - need to create separation rule i.e. semi-colon and then collate scorers array for season and competition, up to admin to make sure names are entered the same
API: Make sure we can handle multi-byte characters in the process
API: Would like to stick each season in a sheet Tab and then merge, can we get this from Google
API: Its a requirement that a team may need to have a point deduction, using another sheet perhaps we can have - only valid for league season, team, deduction i.e. 11, bfc, -2
API: Scan previous seasons and return in an array the last 5 meetings between the same teams, include cup or league. Can use this array to display on the team pages showing a nice statistic
API: History methods to get all games played by X team, total goals scored by X player. This will all come from Fixtures CSV
API: Method to get that weekends results - this may include some mid-week matches - so use the Week number i.e. Week 42.
Idea: League highest win and defeat
Idea: League top scorer, appearances of all time