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.
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.
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 ;
Similar to the above the add the players who received a card to a list.
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.
It's just a matter of keeping this consistent throughout the sheet. Google will often translate the date and time automatically.
We will help set up Data validation rules so
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 |
| Title | URL |
|---|---|
| Example fixture sheet | https://docs.google.com/spreadsheets/d/1uTnHOsDCHwvxmxX41sxCsZDnkPNj_7ImUGYQb3yEMjo |
| Fixture Example | http://support.themeboy.com/entries/21223131-fixtures-shortcode |
| Worksheet download | http://adamlofting.com/1098/new-google-sheets-publishing-a-single-worksheet-to-the-web-as-csv/ |
| 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 |