DIR Return Create A Forum - Home
---------------------------------------------------------
RateTheRef
HTML https://ratetheref.createaforum.com
---------------------------------------------------------
*****************************************************
DIR Return to: I Spy Old Refs!
*****************************************************
#Post#: 3812--------------------------------------------------
match database
DIR 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
DIR By: Acme Thunderer
Date: January 6, 2019, 5:49 am
---------------------------------------------------------
--- Quote from: mande70 link ---
>
> 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
>
--- End 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
DIR 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
DIR By: scottie
Date: January 6, 2019, 4:48 pm
---------------------------------------------------------
Looking forward to seeing the Scottish section in particular
#Post#: 3869--------------------------------------------------
Re: match database
DIR 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
DIR 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
DIR 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
DIR 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
DIR 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
DIR By: TVOS
Date: May 2, 2020, 2:58 pm
---------------------------------------------------------
--- Quote from: mande70 link ---
>
>
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.
>
--- End Quote ---
Brilliant stuff. Have you typed in all the data yourself or
downloaded it from other sources?
*****************************************************
Page 1 of 4
DIR Next Page