DIR Return Create A Forum - Home
---------------------------------------------------------
RateTheRef
HTML https://ratetheref.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: I Spy Old Refs!
*****************************************************
#Post#: 3812--------------------------------------------------
match database
By: mande70 Date: January 5, 2019, 5:35 pm
---------------------------------------------------------
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.
HTML https://i.postimg.cc/dZ741vXL/db1.jpg
HTML https://postimg.cc/dZ741vXL
HTML https://i.postimg.cc/V5574B6m/db2.jpg
HTML https://postimg.cc/V5574B6m
#Post#: 3831--------------------------------------------------
Re: match database
By: Acme Thunderer Date: January 6, 2019, 5:49 am
---------------------------------------------------------
[quote author=mande70 link=topic=451.msg3812#msg3812
date=1546731300]
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.
HTML https://i.postimg.cc/dZ741vXL/db1.jpg
HTML https://postimg.cc/dZ741vXL
HTML https://i.postimg.cc/V5574B6m/db2.jpg
HTML https://postimg.cc/V5574B6m
[/quote]
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.
#Post#: 3842--------------------------------------------------
Re: match database
By: TVOS Date: January 6, 2019, 10:20 am
---------------------------------------------------------
I like both formats, although the format with match details and
notes will obviously put more meat on the bones for those of us
interested in more than just the match statistics.
If you need any help with expanding details for Rochdale's
matches, just let me know.
#Post#: 3866--------------------------------------------------
Re: match database
By: scottie Date: January 6, 2019, 4:48 pm
---------------------------------------------------------
Looking forward to seeing the Scottish section in particular
#Post#: 3869--------------------------------------------------
Re: match database
By: bmb Date: January 6, 2019, 7:23 pm
---------------------------------------------------------
I find the first format easier to read personally. Thank you
for your continued great work on this.
#Post#: 3880--------------------------------------------------
Re: match database
By: Left Field Date: January 7, 2019, 12:12 pm
---------------------------------------------------------
Excellent work mande70! Both formats have their virtues but I
particularly like the second with its focus on the key facts at
a glance - very clearly presented - which makes it a very
convenient point of reference although the first format has more
depth for those who require it.
#Post#: 4253--------------------------------------------------
Re: match database
By: mande70 Date: January 19, 2019, 12:53 pm
---------------------------------------------------------
remember the results section in shoot and match from the 70’s?
well heres something similar. i have used the first division as
an example but i have done it for all the cups and divisions in
england and scotland for a couple of seasons so far. as you can
see where possible ive included referee, attendance and
goalscorers and times. the finished article has all cups,
divisions, european and internationals [involving british
teams], and is in pdf format and printable.
HTML https://www.dropbox.com/s/q171hb90700efl0/xtime2.pdf?dl=0
#Post#: 8294--------------------------------------------------
Re: match database
By: mande70 Date: May 28, 2019, 9:31 am
---------------------------------------------------------
HTML https://drive.google.com/file/d/1PNdY83qeWF0qXosc3P3wYyDkvLhrOgYA/view?usp=sharing
here you go season 1970/71 in all its glory. 463 matches in this
file, each with referee, lineup, attendance, goalscorers, goal
times, ht/ft
[some games dont have a ref, or goal time, as they are not
available through the research channels i have used, but there
is very few missing. for example i think there is only 5 refs
missing.
you get the picture. as comprehensive as it gets. expect more of
these for the future, as i have now got the data input down to a
very easy procedure and the rest is automated, so the process
should be quick for the other seasons.
happy to hear feedback both good/bad lol, only way i can
improve. if you spot any errors feel free to notify me and ill
check.
#Post#: 17393--------------------------------------------------
Re: match database
By: mande70 Date: May 2, 2020, 11:54 am
---------------------------------------------------------
database has taken a new turn, as i have now been able to
formulate a method in which to place 15 seasons + in one sheet,
and the user selects the season, week and match lineup by simple
combo control box
gives a rather unique and touch of colour by adding the form
charts to it as well
#Post#: 17399--------------------------------------------------
Re: match database
By: TVOS Date: May 2, 2020, 2:58 pm
---------------------------------------------------------
[quote author=mande70 link=topic=451.msg8294#msg8294
date=1559053912]
HTML https://drive.google.com/file/d/1PNdY83qeWF0qXosc3P3wYyDkvLhrOgYA/view?usp=sharing
here you go season 1970/71 in all its glory. 463 matches in this
file, each with referee, lineup, attendance, goalscorers, goal
times, ht/ft
[some games dont have a ref, or goal time, as they are not
available through the research channels i have used, but there
is very few missing. for example i think there is only 5 refs
missing.
you get the picture. as comprehensive as it gets. expect more of
these for the future, as i have now got the data input down to a
very easy procedure and the rest is automated, so the process
should be quick for the other seasons.
happy to hear feedback both good/bad lol, only way i can
improve. if you spot any errors feel free to notify me and ill
check.
[/quote]
Brilliant stuff. Have you typed in all the data yourself or
downloaded it from other sources?
*****************************************************
DIR Next Page