Vale Ron Murray aka @LeetoRainestoRoach | PUNT ROAD END | Richmond Tigers Forum
  • IMPORTANT // Please look after your loved ones, yourself and be kind to others. If you are feeling that the world is too hard to handle there is always help - I implore you not to hesitate in contacting one of these wonderful organisations Lifeline and Beyond Blue ... and I'm sure reaching out to our PRE community we will find a way to help. T.

Vale Ron Murray aka @LeetoRainestoRoach

AngryAnt

Tiger Legend
Nov 25, 2004
27,017
14,794
I miss Lee saying how cold it is in Melbourne in the Global Warming thread today.
 
  • Like
  • Haha
Reactions: 16 users

Dev Tiger

Tiger Superstar
Mar 15, 2014
1,410
1,464
RIP Lee. You were a fine example of what makes PRE great. People from all different backgrounds and beliefs united as one by our love of the Tigers.
 
  • Like
Reactions: 13 users

theglove3

Tiger Champion
Jun 3, 2003
2,508
2,251
I too like many here didn't know Lee.

I remember ages back thinking how so many here have really cool user names.
This guy had one of the coolest.
Apart from all the stats for me he invoked memories of Richmond dominating in the good old days.
Just by his name.
The General big and strong palming down to Pretty boy on the charge and a bullet low skimmer hitting Disco on the tit 20 out dead in front.
Another Goal to the Tigers!

RIP Lee.
PRE Legend.
 
  • Like
Reactions: 10 users

bigwow

Tiger Legend
Jul 24, 2003
8,453
6,049
Melbourne
Loved his stats, didn't always agree with his politics, but his absence will be felt.
 
  • Like
Reactions: 2 users

tigersnake

Tear 'em apart
Sep 10, 2003
23,484
11,636
RIP L2. We were in furious agreement on old-school naked fanatical one-eyed Richmond loyalty, as many of us are We were always in lockstep on issues of AFL incompetence and corruption, and especially the Essendon drugs scandal and also chopsticksgate. His stats work was amazing, like magic at times.
 
  • Like
Reactions: 4 users

Baloo

Delisted Free Agent
Nov 8, 2005
44,116
18,926
Can those who have bookmarked, or are able to search and find some of L2R2R's greatest Stats posts, post the links here?

Ron's sister Barb is keen to read these stats that everyone here and on BF keep talking about when we remember Ron.

Admins/Mods, not sure if you want to use this thread or a dedicated LeetoRainestoRoach Greatest Stats thread, will leave it to you.
 
Last edited:
  • Like
Reactions: 4 users

spook

Kick the f*ckin' goal
Jun 18, 2007
21,919
26,433
Melbourne
I'd love to see Ron's sisters pass on his database to a worthy successor, or take it up themselves if so inclined. Would it be possible to host his database on here, @Mr T. ? That would be a legacy.
 
  • Like
Reactions: 7 users

Midsy

I am the one who knocks.
Jan 18, 2014
3,383
1,343
51
London
  • Like
Reactions: 1 users

Midsy

I am the one who knocks.
Jan 18, 2014
3,383
1,343
51
London
@LeeToRainesToRoach - can your stats bank say how many times a team has had more free kicks for than points for?

Is it a common occurrence? Doesn’t seem like it would be.

Hahaha, that is one of the quirkiest questions ever.

Has happened surprisingly often since free kick stats were recorded in 1965 - 165 times, and 7 for Richmond. But this is only the fifth time since 2009

2020 R8 Freo 18F, 16P
2019 R21 N.M. 20F, 14P
2018 R4 Bris 26F, 17P
2016 R19 Rich 24F, 23P

Were any of the 165 by St Kilda? I need some ammo to throw back at a painful Aints supporter.

St.Kilda has 17 mentions, unfortunately none against Richmond and none since 1988.

1968 R10
1972 R14
1975 R21
1977 R12
1978 R8
1979 R4
1979 R19
1979 R20
1980 R15
1981 R15
1983 R3
1985 R2
1985 R19
1986 R9
1987 R6
1988 R6
1988 R12

If it's any consolation, they lost every game.

1979 R4 they had 40 frees, scored 29 and lost by 178 points.

1986 they had 53 frees and lost to Sydney who scored 47 points.
 
Last edited:
  • Like
Reactions: 2 users

Midsy

I am the one who knocks.
Jan 18, 2014
3,383
1,343
51
London
Another one for @LeeToRainesToRoach - do you have a win percentage for each Victorian team when the play interstate? Cheers.

Three sets of numbers

- record in (WA v WC & Freo) + (SA v PA & Adel) + (NSW & ACT v GWS & Syd) + (Qld v Bris & GC)
- record outside Victoria as the away team
- record outside Victoria

Games before 1982 (when South moved to Sydney) excluded

ClubPWLDW%PWLDW%PWLDW%
Carl1455292136.21515397135.41525398135.2
Coll139687148.9140697149.3141697248.9
Ess1525893138.51535993138.91535993138.9
Geel1537477249.01577481247.81577481247.8
Haw144657945.1142657745.820911593155.3
Melb1474510230.6142449831.01695211730.8
N.M.156688843.6153648941.820810210649.0
Rich148608840.5149599039.6154609439.0
St.K1494410529.51614811329.81745312130.5
W.B.1575898137.31475096134.417267104139.2
 
  • Like
  • Wow
Reactions: 3 users

tigertime2

Our cup runneth over!
Mar 22, 2008
4,513
1,637
Very sad news. Was incredible the width and breadth of his knowledge of Stats. The incredible thing was he always answered peoples questions about anything related to Stats. Will miss his input very much.
Life is very very short. Live it with passion - Ron's Passion was Stats and he lived it with great enthusiasm.
R.I.P. Ron
 
  • Like
Reactions: 2 users

Baloo

Delisted Free Agent
Nov 8, 2005
44,116
18,926
I'd love to see Ron's sisters pass on his database to a worthy successor, or take it up themselves if so inclined. Would it be possible to host his database on here, @Mr T. ? That would be a legacy.

I'm not sure there is a worthy successor. Ron created that database by himself, it was a part of who he was.

But from a purely technical perspective, the last time I chatted to him about the tech behind it, it wasn't cloud based and he was running it off his equipment at home. While it wouldn't be technically difficult to migrate a database to the cloud (assuming you had root access), the user frontend would need a fair bit of work. If I remember correctly Ron would just write with SQL statements from a console window.
 
  • Like
Reactions: 1 user

Barbieup

Tiger Cub
Nov 13, 2021
25
46
53
I'd love to see Ron's sisters pass on his database to a worthy successor, or take it up themselves if so inclined. Would it be possible to host his database on here, @Mr T. ? That would be a legacy.
They're only as good as the data feed into it, aren't they? It would need to be constantly updated, ya? Is it a program on a computer? None of us are really computer ppl.
 
  • Like
Reactions: 5 users

spook

Kick the f*ckin' goal
Jun 18, 2007
21,919
26,433
Melbourne
I'm not sure there is a worthy successor. Ron created that database by himself, it was a part of who he was.

But from a purely technical perspective, the last time I chatted to him about the tech behind it, it wasn't cloud based and he was running it off his equipment at home. While it wouldn't be technically difficult to migrate a database to the cloud (assuming you had root access), the user frontend would need a fair bit of work. If I remember correctly Ron would just write with SQL statements from a console window.
focus-homer-simpson.gif
 
  • Haha
  • Like
Reactions: 6 users

spook

Kick the f*ckin' goal
Jun 18, 2007
21,919
26,433
Melbourne
They're only as good as the data feed into it, aren't they? It would need to be constantly updated, ya? Is it a program on a computer? None of us are really computer ppl.
Quite right about keeping it updated. And sorry for your loss. @Baloo and others are across the technicals of it all. I sure am not.
 

23.21.159

A Tiger in Denmark
Aug 9, 2003
6,116
2,283
Denmark
www.dafl.dk
A few years ago I exchanged some emails with him about how he maintained the data.
It's an SQL Server database which he updated every week with a program reading data from finalsiren.com after each round and populating his own database.
Not much more technical detail than that but I do still have the mails if anyone is interested.
 
  • Love
  • Like
Reactions: 1 users

AngryAnt

Tiger Legend
Nov 25, 2004
27,017
14,794
As someone else said, he was a wizard of the SQL query. It's not just the database, it's how he was able to turn people's questions and requests into a meaningful SQL query.

That's not transferable.
 
  • Like
Reactions: 7 users

Mr T.

Administrator
Staff member
Aug 11, 2007
2,575
1
2,758
Melbourne
I'd love to see Ron's sisters pass on his database to a worthy successor, or take it up themselves if so inclined. Would it be possible to host his database on here, @Mr T. ? That would be a legacy.
Hosting wouldn’t be an issue. It’s moving it and his sisters agreeing to it. It would need someone close to Ron to make contact.
 
  • Like
Reactions: 1 user

FitenFitenWin

Listen to the thunder RFC
Jul 30, 2009
3,228
1,439
Brisbane
It seems that I, like some others, have come across this thread a little late. But I would still like to convey my feelings of sadness and loss at the passing of LTRTR - or as I now know him - Ron.
Ron was a key contributor to this forum. He was one of the reasons I have been part of PRE for 17 years. Whether I agreed with some of his views is irrelevant - he always made a strong case for whatever view he expressed - often with humour and wit. I only wish I had 5% of his skill with stats and the energy to share his knowledge with us.
Without a shadow of a doubt - Ron is irreplaceable on PRE.
His family and friends must be shattered at the suddenness of his deterioration. My most deepest condolences to them. And to all other PREnders.
 
  • Like
Reactions: 15 users