+-

+-User

Welcome, Guest.
Please login or register.
 
 
 

Login with your social network

Forgot your password?

+-Stats ezBlock

Members
Total Members: 953
Latest: Yorksref
New This Month: 21
New This Week: 3
New Today: 1
Stats
Total Posts: 75097
Total Topics: 5526
Most Online Today: 148
Most Online Ever: 17046
(Mon 29 Mar 2021 19:08)
Users Online
Members: 11
Guests: 125
Total: 136

Author Topic: match database  (Read 2722 times)

0 Members and 2 Guests are viewing this topic.

Acme Thunderer

  • RTR Veterans
  • Hero Member
  • *
  • Posts: 2,397
    • View Profile
Re: match database
« on: Sun 06 Jan 2019 11:49 »
i posted this on the other forum, but dont see it moved over, [maybe missed it], anyways, im sure most of you are aware of the pulling together of referees lists from previous seasons in the i spy old refs forum, so i decided to put the info all together in a worthwhile project. [no point dredging old books and papers and not utilising all the info learnt. not sure which database style i prefer, ill let you have a say on what you think.

one of them you select a match and it brings up all the details for that match, attendance, managers, ref, lineups, ht, ft score, goalscorers, goal times [if known], disciplinary [if known] and a few notes on the particular match. it contains matches for all 42 weeks of the season [in this case 1970/71], and is done through excel, which make it easy to view, but is not really a web based project as it uses macros and formulas.

the other has come about from me reading old shoot magazines, and my fascination at gleaning info from the match reports. so i pulled together my version of it, that has all the matches for scotland and england in a weekly printable booklet style. it has lineups, refs, att, ht, ft, goalscorers and where known goal times. it details all matches from all the 4 english leagues, fa cup, league cup, european matches, internationals, scottish league, scot cup, scot league cup and the diddy cups [watney cup, anglo italian cup and texaco cup.





Many thanks mande70 for all the hard work you have obviously put into this project. I would be quite happy with either format providing the stats are easy to access and view. Looking forward to seeing developments.