Research Data gaps + big projects

Remove this Banner Ad

Mine is all about Tassie. The mission is every score of every game ever played in the state in the one place. If it's Top Tier - TFL, NT, NW or rep, it gets the full treatment - 4Q's, venue, attendance, date, winner and margin, goalkickers and full teams...the only thing missing from your average newspaper report is Best Players. If it's a Lower Tier league or Res/U, then it gets a single line score with home team first and just missing goalkickers. On top of that, BF's, coaches, captains...all organised in a variety of ways across over 300 files. All displayed on word docs and I made up an Excel program to calculate ladders (a little perk is that this generates GBP scores for every game, so my Top Tier scores have a full ladder for every round). I don't use Excel for compilation, because it's messy - I've always tried to find that perfect balance between presentation and functionality, and I think what I've settled upon does that. Once I've got a full score, I can CTRL-C/V the crap out of it and make up all sorts of things, which is why I love Word...many of my working notes have PrtSc images throughout as well.

Sources - Kingpin, Bassoon, Phil, Ozguy, and a guy called Simon who might be Todman here. There's also Ray from the Tas Past Players FB site, Matt H from the same place who has managed to score every Tas Footy Record imaginable and regularly gets pestered by me to get his phone out and start sending screenshots, and also the president of the St Pats footy club who gave me every Tas amateur score ever...champions all. Trove, Sportingpulse and PlayHQ - will have to urgently copy every damned thing I can find off SP, because it's about to go the way of the dinosaur...learned that lesson getting slack with the SFL, a comp that doesn't gaf about it's history and deletes everything periodically. Also, the last couple of times I visited Tassie I went to the library and got onto the microfiche...just a fortnight ago, I was in the Lton and Glenorchy libraries and got nearly every TFL and NTFL gap sorted. I'll post the last remaining q's here if anyone's got answers. When on microfiche, I don't bother PDF'ing, waste of time...I just maximise the image and print screen onto a waiting Word doc, much quicker...

Here's a couple of docs:
1) Excel Ladder calculator. It works by inputting the score into each round, own team on the left and opposition on the right. You'll figure it out. I've also added the NTFL working doc, which shows how far it can go.
2) 2022 Tasmanian footy season. I've done the last few years like this, and the ultimate aim is to have every season since 1879 in this common format. Still to complete, but this one is the closest.
3) 2023 Player stats. Again, not finished, but eventually it will condense into a smaller one...you can work out what it means.
 

Attachments

  • Footy Ladder Calculator Multiple Pages NTFL.xlsx
    229.2 KB · Views: 9
  • 2022 Tasmanian Football Season.docx
    327.3 KB · Views: 5
  • 2023 Tasmanian Football Season Player Stats.docx
    3.3 MB · Views: 5
  • Footy Ladder Calculator.xlsx
    22.4 KB · Views: 3
Which games are you missing?
5/5/1924 - I only have scores at 3 quarter time.

7/6/1926 - No scores in any of the major newspapers. Tried to calculate the scores from the ladders given in the Geelong Advertiser, but had very little luck.
 
1897 SANFL season.

As follows:

Season.
Round.
Teams played per round.
Total goals.
Total behinds.
Total points.
Average score of each round.

1897​
R01​
6​
39​
46​
280​
46.6666666666667​
1897​
R02​
6​
41​
55​
301​
50.1666666666667​
1897​
R03​
6​
21​
42​
168​
28​
1897​
R04​
4​
39​
58​
292​
73​
1897​
R05​
4​
18​
18​
126​
31.5​
1897​
R06​
2​
6​
15​
51​
25.5​
1897​
R07​
6​
31​
47​
233​
38.8333333333333​
1897​
R08​
4​
14​
39​
123​
30.75​
1897​
R09​
6​
25​
38​
188​
31.3333333333333​
1897​
R10​
4​
37​
38​
260​
65​
1897​
R11​
6​
22​
38​
170​
28.3333333333333​
1897​
R12​
4​
24​
31​
175​
43.75​
1897​
R13​
2​
6​
17​
53​
26.5​
1897​
R14​
6​
34​
43​
247​
41.1666666666667​
1897​
R15​
6​
36​
47​
263​
43.8333333333333​
1897​
R16​
2​
12​
24​
96​
48​
1897​
R17​
2​
19​
19​
133​
66.5​
1897​
R18​
6​
40​
46​
286​
47.6666666666667​
1897​
R19​
4​
8​
15​
63​
15.75​
1897​
R20​
2​
4​
12​
36​
18​
1897​
R21​
2​
9​
13​
67​
33.5​


If there are forfeitures, I won't count that towards the round's score.

Game cancellations like the AFL's Adelaide vs Geelong R14 game from 2015 likewise.


Same deal.

1898​
R01​
6​
34​
71​
275​
45.8333333333333​
1898​
R02​
6​
28​
44​
212​
35.3333333333333​
1898​
R03​
6​
30​
37​
217​
36.1666666666667​
1898​
R04​
6​
34​
46​
250​
41.6666666666667​
1898​
R05​
4​
33​
36​
234​
58.5​
1898​
R06​
4​
20​
30​
150​
37.5​
1898​
R07​
4​
15​
27​
117​
29.25​
1898​
R08​
4​
26​
30​
186​
46.5​
1898​
R09​
4​
21​
34​
160​
40​
1898​
R10​
6​
15​
38​
128​
21.3333333333333​
1898​
R11​
6​
22​
39​
171​
28.5​
1898​
R12​
6​
35​
65​
275​
45.8333333333333​
1898​
R13​
4​
11​
37​
103​
25.75​
1898​
R14​
6​
35​
47​
257​
42.8333333333333​
1898​
R15​
6​
32​
46​
238​
39.6666666666667​
1898​
R16​
2​
16​
22​
118​
59​
1898​
SF​
2​
6​
22​
58​
29​
1898​
GF​
2​
12​
16​
88​
44​
 

Log in to remove this ad.

I understand what you are saying about the lack of home grounds for the seconds and thirds games. Here are scores for NSW and the TAC Cup.
 

Attachments

  • NSW AFL.xlsx
    571 KB · Views: 2
  • TAC Cup.xlsx
    1.8 MB · Views: 3
All my stuff is VERY Hawthorn focused, so probably not much value to the collective here. But I guess some of it might plug a gap or two so I'll pop some stuff in this thread if it looks like it might relate to other projects mentioned here.

Starting with Hawthorn Subs
 

Attachments

  • HFC_ResSub.xlsx
    95.5 KB · Views: 10
Mine is all about Tassie. The mission is every score of every game ever played in the state in the one place. If it's Top Tier - TFL, NT, NW or rep, it gets the full treatment - 4Q's, venue, attendance, date, winner and margin, goalkickers and full teams...the only thing missing from your average newspaper report is Best Players. If it's a Lower Tier league or Res/U, then it gets a single line score with home team first and just missing goalkickers. On top of that, BF's, coaches, captains...all organised in a variety of ways across over 300 files. All displayed on word docs and I made up an Excel program to calculate ladders (a little perk is that this generates GBP scores for every game, so my Top Tier scores have a full ladder for every round). I don't use Excel for compilation, because it's messy - I've always tried to find that perfect balance between presentation and functionality, and I think what I've settled upon does that. Once I've got a full score, I can CTRL-C/V the crap out of it and make up all sorts of things, which is why I love Word...many of my working notes have PrtSc images throughout as well.

Sources - Kingpin, Bassoon, Phil, Ozguy, and a guy called Simon who might be Todman here. There's also Ray from the Tas Past Players FB site, Matt H from the same place who has managed to score every Tas Footy Record imaginable and regularly gets pestered by me to get his phone out and start sending screenshots, and also the president of the St Pats footy club who gave me every Tas amateur score ever...champions all.

the croucher is also a Tasmanian resident who might be worth conversing with.
 
  • Thread starter
  • Moderator
  • #38
All my stuff is VERY Hawthorn focused, so probably not much value to the collective here. But I guess some of it might plug a gap or two so I'll pop some stuff in this thread if it looks like it might relate to other projects mentioned here.

Starting with Hawthorn Subs
This is a thing of beauty! We need something like this for every club. Love the descriptive terminology of some of the early reports –"solar plexus" in 1933 – ha.
 

(Log in to remove this ad.)

This is a thing of beauty! We need something like this for every club. Love the descriptive terminology of some of the early reports –"solar plexus" in 1933 – ha.
Ha yes... and while compiling this was where I discovered the story of Wally Bristowe - Hawthorn sub 1942 Round 14. Originally named as an emergency, a couple of late withdrawals meant he was named as sub on the morning of the game. However on the day he couldn't get leave from the army and so wasn't even at the ground. Yet credited with his 11th (and last) game of VFL/AFL football.
 
Ha yes... and while compiling this was where I discovered the story of Wally Bristowe - Hawthorn sub 1942 Round 14. Originally named as an emergency, a couple of late withdrawals meant he was named as sub on the morning of the game. However on the day he couldn't get leave from the army and so wasn't even at the ground. Yet credited with his 11th (and last) game of VFL/AFL football.
The war created havoc with lower leagues. Burnie were leading the ladder undefeated after R3 in 1940, but didn't have a team at all the next week because they all joined the army! Comp was disbanded immediately. Wynyard were on top of their league by a street, 1941 I think, but the army called up all the soldiers who'd played that season for them on the weekend before finals, and they were obliterated. Several comps started with a full roster and lost half their comp by season's end...
 
5/5/1924 - I only have scores at 3 quarter time.

7/6/1926 - No scores in any of the major newspapers. Tried to calculate the scores from the ladders given in the Geelong Advertiser, but had very little luck.
This is what is in Collingwood's records for the 1926 game:
1714544723721.png
Apparently, what we have matches the scores Steve Williamson (Carlton historian) has/had in a file. Where anyone got those scores from, who knows?!

No clue with the other game, unfortunately.
 
1899 SANFL season.

R01​
6​
42​
54​
306​
51​
R02​
6​
32​
44​
236​
39.3333333333333​
R03​
4​
20​
52​
172​
43​
R04​
4​
23​
35​
173​
43.25​
R05​
4​
23​
29​
167​
41.75​
R06​
6​
35​
44​
254​
42.3333333333333​
R07​
6​
32​
51​
243​
40.5​
R08​
6​
26​
20​
176​
29.3333333333333​
R09​
4​
21​
22​
148​
37​
R10​
6​
40​
40​
280​
46.6666666666667​
R11​
6​
38​
59​
287​
47.8333333333333​
R12​
6​
21​
46​
172​
28.6666666666667​
R13​
4​
18​
31​
139​
34.75​
R14​
4​
10​
23​
83​
20.75​
R15​
4​
30​
48​
228​
57​
R16​
4​
29​
35​
209​
52.25​
R17​
4​
24​
33​
177​
44.25​
PF​
2​
12​
13​
85​
42.5​
GF​
2​
7​
14​
56​
28​
 
This is what is in Collingwood's records for the 1926 game:
View attachment 1976063
Apparently, what we have matches the scores Steve Williamson (Carlton historian) has/had in a file. Where anyone got those scores from, who knows?!

No clue with the other game, unfortunately.
Thanks for this. The game in May had 3 quarter time scores from the Herald. Maybe the SLV has a final edition of the paper for that day. Failing that, I wonder if a final ladder for that Season was recorded somewhere.
 
Thanks for this. The game in May had 3 quarter time scores from the Herald. Maybe the SLV has a final edition of the paper for that day. Failing that, I wonder if a final ladder for that Season was recorded somewhere.
I live in SA and can't just drop into the SLV, sadly! Hopefully that missing final score will turn up one day. Though a "full" final ladder for 1924 would certainly be handy. My "Collingwood Archives colleague/fellow researcher" just has this in his spreadsheet:
1714619786562.png
 
Later in the Month, I’ll be at the SLV for a couple of days, mainly capturing football results from the Sun from 1955 to hopefully about 1970. I’ll also have a look for the herald for that date.
 
Non Senior Players for Hawthorn (Listed, Unlisted, Training etc)
Lists like this (and Reserves/U19s etc...) are really helpful for me too, because often it will give information about somebody who also appeared in some capacity at MFC.
 
Now done SANFL seasons 1897-1915.

I was wondering if the 1916-18 seasons were to be shortened but, because of WW1, it stopped altogether.

Suppose a lot of footy historians have this kept in mind. (Plus perhaps, the Vietnam War and the Boer War too.)
 
Now done SANFL seasons 1897-1915.

I was wondering if the 1916-18 seasons were to be shortened but, because of WW1, it stopped altogether.

Suppose a lot of footy historians have this kept in mind. (Plus perhaps, the Vietnam War and the Boer War too.)
The influenza epidemic and the great depression also had their effects. I'd never thought to factor in Vietnam War, and was probably forgetful about the Boer War era too. Interesting thoughts!
 

Remove this Banner Ad

Research Data gaps + big projects

Remove this Banner Ad

Back
Top