TSF Results pages

[Bovidae]

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

One other useful feature on the Rugby Museum (stats.allblacks.com) database is filtering by test venue.

I can add a 'City' filter relatively easy

The data I have for stadium names isn't that great. Incomplete for some Tests and inconsistent where the stadium has changed names etc

Yeah the city would be a simplified way of doing this. Otherwise for Auckland you need to include Alexandra Park, Potter's Park and soon to be Mt Smart.

I think this would be useful if, for example, you wanted to know the AB record in Jo'burg. The added feature of your results page is it includes wins, loses, average result, etc.

[booboo]

@Duluth

Am about to send you a spreadsheet that I nerded up a few years ago (when I was in total denial about how we didn't win World Cups, and didn't peak between them etc*).

(I know real stats nerds would use a database, not a spreadsheet, but I'm only a pretend nerd.)

So cobbled together a spreadsheet of results (no scorers info, just scores, venues etc) from various sources (AllBlacks.com, rugby museum, lassen.co.nz, and some other random results website I can't remember).

I expect you've got most of this information but am pretty sure I've got most of the venues included if you want to include an extra field.

I've generally named something like:

• Stadium Australia
• Stadium Australia- Telstra
• Stadium Australia- ANZ

Or for:

• Wellington Stadium
• Wellington Stadium - WestpacTrust
• Wellington Stadium - Westpac
• Wellington Stadium - Sky

Hope that helps

I could have got clevererer with the presentation, but it was only for my personal shits and giggles.

May be of use?

Emailing now.

'* re peaking between World Cups: completely inconclusive.

[Duluth]

@booboo

Thanks, just got a chance to look at it now. First of all, holy shit that is a great spreadsheet.

---

Wellington Stadium
Wellington Stadium - WestpacTrust
Wellington Stadium - Westpac
Wellington Stadium - Sky

I think what I'll do is just use 'Wellington Stadium' and ignore the sponsorship

I'll do that sort of rationalisation for the NZ stadiums and a few of the main overseas ones. So eventually there will be a 'Stadium' filter but it won't include every single random stadium over the last 120 years

I have the 'City' filter working but it's not live on the website yet.. I'll update the website after I get the 'Stadium' filter working too

[booboo]

@duluth said in TSF AB Results page:

@booboo

Thanks, just got a chance to look at it now. First of all, holy shit that is a great spreadsheet.

---

Wellington Stadium
Wellington Stadium - WestpacTrust
Wellington Stadium - Westpac
Wellington Stadium - Sky

I think what I'll do is just use 'Wellington Stadium' and ignore the sponsorship

I'll do that sort of rationalisation for the NZ stadiums and a few of the main overseas ones. So eventually there will be a 'Stadium' filter but it won't include every single random stadium over the last 120 years

I have the 'City' filter working but it's not live on the website yet.. I'll update the website after I get the 'Stadium' filter working too

Thanks for the compliment.

Was developed over many years, with incremental improvements when I wanted to work out some new information.

Ran out of columns (if you can believe that) for all the opponents. So found a better way - eventually.

Being an Engineer a lot of what I do is plagiarising other guys spreadsheets, so always learning stuff.

People with more artistic flair would make it look better.

[Duluth]

@bovidae said in TSF AB Results page:

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

One other useful feature on the Rugby Museum (stats.allblacks.com) database is filtering by test venue.

I can add a 'City' filter relatively easy

The data I have for stadium names isn't that great. Incomplete for some Tests and inconsistent where the stadium has changed names etc

Yeah the city would be a simplified way of doing this. Otherwise for Auckland you need to include Alexandra Park, Potter's Park and soon to be Mt Smart.

I think this would be useful if, for example, you wanted to know the AB record in Jo'burg. The added feature of your results page is it includes wins, loses, average result, etc.

City and Stadium filters are working now

[Rapido]

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

One other useful feature on the Rugby Museum (stats.allblacks.com) database is filtering by test venue.

I can add a 'City' filter relatively easy

The data I have for stadium names isn't that great. Incomplete for some Tests and inconsistent where the stadium has changed names etc

Yeah the city would be a simplified way of doing this. Otherwise for Auckland you need to include Alexandra Park, Potter's Park and soon to be Mt Smart.

I think this would be useful if, for example, you wanted to know the AB record in Jo'burg. The added feature of your results page is it includes wins, loses, average result, etc.

City and Stadium filters are working now

You've got one error in there with Rugby League Park as well as a Rugby League Pk .

[Rapido]

and Olympic Stadium - needs to be seperated between Rome, London, Tokyo.

[Rapido]

Interesting, we have a poor record at Boet Erasmus, even though at sea level. Thinking to myself "the Saffas shouldn't have knocked that down", look at Nelson Mandela Bay - and .... we still have a 0% record there.

[Rapido]

Flippen heck,, we have a 0% record at Crusader Ground as well. Never won a test in Port Elizabeth.

[Duluth]

@rapido said in TSF AB Results page:

You've got one error in there with Rugby League Park as well as a Rugby League Pk .

@rapido said in TSF AB Results page:

and Olympic Stadium - needs to be seperated between Rome, London, Tokyo.

Well spotted, thanks

I've updated the data

[Snowy]

@duluth said in TSF AB Results page:

Post in here if you have any suggestions to make it better.

I don't want to know about the losses, so just the wins would be a huge improvement.

Seriously though, that is pretty cool. The fern as a "stats guru" Nice.

Likely means that more people are going to see the crap that I have posted over the last couple of decades but what the hell.

[booboo]

@rapido said in TSF AB Results page:

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

@duluth said in TSF AB Results page:

@bovidae said in TSF AB Results page:

One other useful feature on the Rugby Museum (stats.allblacks.com) database is filtering by test venue.

I can add a 'City' filter relatively easy

The data I have for stadium names isn't that great. Incomplete for some Tests and inconsistent where the stadium has changed names etc

Yeah the city would be a simplified way of doing this. Otherwise for Auckland you need to include Alexandra Park, Potter's Park and soon to be Mt Smart.

I think this would be useful if, for example, you wanted to know the AB record in Jo'burg. The added feature of your results page is it includes wins, loses, average result, etc.

City and Stadium filters are working now

You've got one error in there with Rugby League Park as well as a Rugby League Pk .

Sorry ... my fault?

[booboo]

@rapido said in TSF AB Results page:

and Olympic Stadium - needs to be seperated between Rome, London, Tokyo.

I'll let @Duluth update tsf, but will update my records too

[Duluth]

Someone suggested adding percentages to the results summary. This has been added to all the results pages now (AB, SR, NPC)

---

[Kirwan]

@duluth need to be able like posts more than once.

[gt12]

@duluth said in TSF AB Results page:

Someone suggested adding percentages to the results summary. This has been added to all the results pages now (AB, SR, NPC)

---

That was me. You legend!

[Duluth]

I just realised the SR Results page only has "Home" or "Away" options. I'll need to add "Neutral"

Should all the Queenstown/Dunedin bubble games be considered neutral? Even when the Highlanders are playing?

[gt12]

@duluth said in TSF Results pages:

I just realised the SR Results page only has "Home" or "Away" options. I'll need to add "Neutral"

Should all the Queenstown/Dunedin bubble games be considered neutral? Even when the Highlanders are playing?

Doesn't feel like much of a home game, when they are separated from their families for a month.

[Machpants]

@gt12 said in TSF Results pages:

@duluth said in TSF Results pages:

I just realised the SR Results page only has "Home" or "Away" options. I'll need to add "Neutral"

Should all the Queenstown/Dunedin bubble games be considered neutral? Even when the Highlanders are playing?

Doesn't feel like much of a home game, when they are separated from their families for a month.

No crowds either. They’ll be bused in like everyone else. Very small home advantage, I wonder if they’ll be made to go in the away rooms - that sort of thing has hapened before

[Duluth]

@gt12

I'll put them all down as neutral for now

I wouldn't be surprised to see restrictions loosen at some stage though. So you could have the Highlanders playing at Forsyth Bar with maybe a 1000 in the crowd.. then it gets harder to call neutral