Database - spreadsheets
Posted: 15 Jul 2022, 20:53
I have created a database of our matches going back to 1980. I am sharing a few of the spreadsheets if anyone wants to have a look.
They are all live documents and so will update when I put on new match information. This does mean they can be a little slow at loading so are probably best viewed on a computer but can be viewed on a mobile it just takes a while to load.
**EDIT**
Hi
Just a bit of an update on the spreadsheets.
Thanks to the incredibly generous DJ I think I have now got all his match reports onto the Match Summary spreadsheet. This means that I now a report of some kind for approx 60% of the matches going back to 1980.
Whilst doing this I have also updated, where I could, the captains and Man-of-the-matches, though this is no where near complete.
I also decided to record all the penalties scored and missed (including penalty shoot-outs), these can be found on the match summaries, and on the player summaries. I have also done a top ten penalty scorer list on the records spreadsheet.
I thought it may be quite inconvenient to have to keep going back to find all the links so I have made a launch page that will then take you to the sheet you want (hopefully)
Launcher
_____________________________________________________________________________________________________________________________
Records
This is a summary of some of the records split between various different tabs.
Season Summary
This has a tab for each decade and if you click on the green year cell you can select a different year and the spreadsheet should update to show a summary of that season.
Opposition
Similar click on on the green cell to change the team and it should update the sheet.
Managers
Gives a summary of the managers
Matches
This has two sheets one so that you can search by season and the other so that you can search by opposition. Select the season, then the match and the sheet should update to show the match details, team line ups and I have have found it a match report. They should all be shared but google sometimes does some strange things so if you have any problems just let me know.
Thanks everyone.
Here are a couple other sheets which I forgot to post links to.
Team Line Ups
Team Line ups, similar to the centre pages of the programme.
Players
Player summaries - similar to the other sheets where you can change the player by clicking on the green cell on each page. There is also a page with the current team pictures on.
There are probably some mistakes and not all the data is complete (such as bookings, captains, MOTM etc). Also if there are a number of people on the spreadsheet then others may change the options and so the sheet will update when you dont want it to.
They are all live documents and so will update when I put on new match information. This does mean they can be a little slow at loading so are probably best viewed on a computer but can be viewed on a mobile it just takes a while to load.
**EDIT**
Hi
Just a bit of an update on the spreadsheets.
Thanks to the incredibly generous DJ I think I have now got all his match reports onto the Match Summary spreadsheet. This means that I now a report of some kind for approx 60% of the matches going back to 1980.
Whilst doing this I have also updated, where I could, the captains and Man-of-the-matches, though this is no where near complete.
I also decided to record all the penalties scored and missed (including penalty shoot-outs), these can be found on the match summaries, and on the player summaries. I have also done a top ten penalty scorer list on the records spreadsheet.
I thought it may be quite inconvenient to have to keep going back to find all the links so I have made a launch page that will then take you to the sheet you want (hopefully)
Launcher
_____________________________________________________________________________________________________________________________
Records
This is a summary of some of the records split between various different tabs.
Season Summary
This has a tab for each decade and if you click on the green year cell you can select a different year and the spreadsheet should update to show a summary of that season.
Opposition
Similar click on on the green cell to change the team and it should update the sheet.
Managers
Gives a summary of the managers
Matches
This has two sheets one so that you can search by season and the other so that you can search by opposition. Select the season, then the match and the sheet should update to show the match details, team line ups and I have have found it a match report. They should all be shared but google sometimes does some strange things so if you have any problems just let me know.
Thanks everyone.
Here are a couple other sheets which I forgot to post links to.
Team Line Ups
Team Line ups, similar to the centre pages of the programme.
Players
Player summaries - similar to the other sheets where you can change the player by clicking on the green cell on each page. There is also a page with the current team pictures on.
There are probably some mistakes and not all the data is complete (such as bookings, captains, MOTM etc). Also if there are a number of people on the spreadsheet then others may change the options and so the sheet will update when you dont want it to.