Time for a TN sort?

Make suggestions and report problems.
Post Reply
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

A very special refreshment indeed.

That piece of code needs major rewrite. Will do.
User avatar
JacobH
Quinta do Vesuvio 1994
Posts: 3300
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH »

Two thoughts if you are contemplating a rewrite:

i) Would it be possible to annotate threads with more than, say, 3 replies with "(possibly & ors.)" or something to that effect? Particularly after an offline a lot of TNs from different people get posted in the same thread but, at the moment, only the initial poster's initials are repeated.

ii) Could the data from the corked/spoilt bottles be somehow incorporated? Perhaps a symbol to the effect of: :!: might be appropriate (or we could design a few for the different problems)?
Image
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

Very good ideas.
    • Admin: can the data I am sent include the number of replies or posts in that thread?
    • All: would it be more informative to have a boundary at three posts, or just to state the likes of ‟7 posts”? What presentation would be most useful? (Currently I can manually override the shown name, as has been done for a very small number of TNs maybe Admin could provide a list of all posters in that thread?)
    • Admin: can data from Corked/Spoilt Ports - Name and Shame come as a table of TNs? I reckon that this is true only for those who have linked to the TN, but even then having the SQL parse the p= and t= link formats might be too tricky.
User avatar
JacobH
Quinta do Vesuvio 1994
Posts: 3300
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH »

jdaw1 wrote: [*]All: would it be more informative to have a boundary at three posts, or just to state the likes of ‟7 posts”? What presentation would be most useful? (Currently I can manually override the shown name, as has been done for a very small number of TNs maybe Admin could provide a list of all posters in that thread?)
Having the number of replies might be a better idea. The problem is, of course, differentiating replies which are notes from ones which are just general chat.
Image
User avatar
DRT
Fonseca 1966
Posts: 15779
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Re: Time for a TN sort?

Post by DRT »

JacobH wrote:
jdaw1 wrote: [*]All: would it be more informative to have a boundary at three posts, or just to state the likes of ‟7 posts”? What presentation would be most useful? (Currently I can manually override the shown name, as has been done for a very small number of TNs maybe Admin could provide a list of all posters in that thread?)
Having the number of replies might be a better idea. The problem is, of course, differentiating replies which are notes from ones which are just general chat.
This might be slightly misleading as many TN's are comprised of multiple posts from the taster to record the evolution of the wine in the decanter.

Are we in danger of trying to be too clever here?

Is the current index fit for purpose? I think it is.
"The first duty of Port is to be red"
Ernest H. Cockburn
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

DRT wrote:Is the current index fit for purpose? I think it is.
I also think that it is fit for purpose. But it is worth exploring whether it can be fit for other purposes, without losing the current fitness-for-purpose. And adding the number of replies or posts is easy SQL, and easy for me. Can we do more? I don’t know.
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

I would also vote for not changing the initials of the person who made the first post. I don't tend to use the information on who the poster was, just read the note if I want to know what someone thought of the port.

I vote to leave things alone on the initials of the poster.

But linking to a name and shame list would be interesting.
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
User avatar
JacobH
Quinta do Vesuvio 1994
Posts: 3300
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH »

I’m not sure if this is known (based on the posts, ante, concerning Adam’s) but I note that 1963 Adams is missing from the list.
Image
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

TN indexes (alphabetical, date) updated.
User avatar
JacobH
Quinta do Vesuvio 1994
Posts: 3300
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH »

jdaw1 wrote:TN indexes (alphabetical, date) updated.
There is probably a symbolism that I am missing, but I note the colour of the date changes from blue to green in the third post of the alphabetical list.
Image
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

JacobH wrote:There is probably a symbolism that I am missing, but I note the colour of the date changes from blue to green in the third post of the alphabetical list.
Whoops. The symbolism is that Tom noticed that some Nacionals had become Novals (very unfortunate), so I fixed just that post. Will re-fix.
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

Might I suggest that early July would be a good time for an update to the tasting note indices - other priorities permitting?
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

Coincidentally, I wrote to ARK just before you posted asking for updated data.
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

Done. Will be done again in early July.
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

A handful of points following a quick review of the updated index.

We seem to have multiple entries for the Dalva White colheita 1952 port:
Dalva (aka Presidential, aka C da Silva) Golden White colheita
1952: JDAW on 04 Jan 2008
Dalva (aka Presidential, aka C da Silva) Golden White Reserve
1952: RMW on 22 Jun 2007
Dalva (aka Presidential, aka C da Silva) white colheita
1952: JGH on 24 May 2009

JDAW seems to have been very busy recently:
F70 JDAW+DRT on 01 Sep 2007
F70 JDAW on 19 Oct 2008
F70 JDAW on 27 Nov 2008
F70 JDAW on 26 Dec 2008
F70 JDAW on 04 Jan 2009
F70 JDAW on 26 Jan 2009
F70 JDAW on 17 Apr 2009
F70 JDAW on 13 Jun 2009

And, finally, does anyone fancy volunteering to pull together some useless stats from the list? Things like "most tasted port" and "favourite shipper"?
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

AHB wrote:We seem to have multiple entries for the Dalva White colheita 1952 port:
Dalva (aka Presidential, aka C da Silva) Golden White colheita
1952: JDAW on 04 Jan 2008
Dalva (aka Presidential, aka C da Silva) Golden White Reserve
1952: RMW on 22 Jun 2007
Dalva (aka Presidential, aka C da Silva) white colheita
1952: JGH on 24 May 2009
Needs work.
AHB wrote:JDAW seems to have been very busy recently:
F70 JDAW+DRT on 01 Sep 2007
F70 JDAW on 19 Oct 2008
F70 JDAW on 27 Nov 2008
F70 JDAW on 26 Dec 2008
F70 JDAW on 04 Jan 2009
F70 JDAW on 26 Jan 2009
F70 JDAW on 17 Apr 2009
F70 JDAW on 13 Jun 2009
Just as AHB rather likes his Vesuvio, I like F70. What’s wrong with that?
AHB wrote:And, finally, does anyone fancy volunteering to pull together some useless stats from the list? Things like "most tasted port" and "favourite shipper"?
When I return from travels, I can tackle this. Easiest done from the spreadsheet.
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

jdaw1 wrote:
AHB wrote:JDAW seems to have been very busy recently:
F70 JDAW+DRT on 01 Sep 2007
F70 JDAW on 19 Oct 2008
F70 JDAW on 27 Nov 2008
F70 JDAW on 26 Dec 2008
F70 JDAW on 04 Jan 2009
F70 JDAW on 26 Jan 2009
F70 JDAW on 17 Apr 2009
F70 JDAW on 13 Jun 2009
Just as AHB rather likes his Vesuvio, I like F70. What’s wrong with that?
Absolutely nothing. I think there is a certain stylish decadence to opening a bottle of Fonseca 1970 once a month for the last 6 months. I doff my hat in admiration (and a little envy).
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

AHB wrote:"most tasted port"
Port: Count
F85: 14
Mg91: 12
D83: 11
G77: 11
W85: 11
F70: 10
G75: 10
G85: 10
Cr77: 9
D77: 9
F80: 9
G70: 9
Mz85: 9
F66: 8
F77: 8
G83: 8
V96: 8
W77: 8
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

AHB wrote:"favourite shipper"?
Well, most tasted shippers are as follows.
Graham: 82
Fonseca: 73
Quinta do Vesuvio: 73
Warre: 60
Taylor: 54
Cockburn: 52
Dow: 52
Croft: 48
Quinta do Noval: 38
Taylor Quinta de Vargellas: 38
Ferreira: 31
Niepoort: 28
Quinta do Noval Nacional: 28
Morgan: 25
Martinez (Harvey): 24
Gould Campbell: 22
Offley Boa Vista: 21
Sandeman: 21
Graham Malvedos: 20
Smith Woodhouse: 20
Fonseca Guimaraens: 18
Kopke: 18
Ramos-Pinto: 16
Warre LBV: 16
Delaforce: 14
Quarles Harris: 14
Kopke colheita: 12
Quinta do Crasto: 12
Berry Brothers & Rudd Selection: 11
Quinta do Noval colheita: 11
Quinta de Roriz: 10
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

All the ‘years’ (being things in the ‘year’ column), with frequencies, are as follows.
1985: 111
1970: 107
1977: 85
2000: 78
1994: 76
1963: 70
1983: 64
1995: 48
1991: 47
2003: 47
1997: 46
NV: 43
1966: 41
1980: 37
1996: 36
2001: 31
1987: 30
2007: 28
1975: 27
1988: 22
20Y: 21
1999: 20
1992: 19
2005: 19
1960: 18
10Y: 18
1998: 17
1955: 16
1967: 15
1978: 15
1989: 14
2004: 14
1927: 11
1982: 11
1990: 8
1947: 7
1958: 7
1986: 7
1945: 6
1948: 6
1952: 6
1984: 6
2002: 6
2006: 6
1912: 5
1935: 5
1950: 5
1968: 5
1974: 5
1976: 5
1908: 4
1920: 4
1931: 4
1937: 4
1964: 4
1965: 4
1979: 4
1863: 3
1890: 3
1944: 3
1962: 3
1815: 2
1896: 2
1900: 2
1917: 2
1924: 2
1933: 2
1938: 2
1957: 2
1972: 2
30Y: 2
1830: 1
1853: 1
1873: 1
1875: 1
1904: 1
1906: 1
1932: 1
1934: 1
1940: 1
1941: 1
1942: 1
1953: 1
1961: 1
1971: 1
‘believed vintage’: 1
40Y: 1
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

So most frequent shippers are Graham and Fonseca, and most frequent years are 1985 and 1970, and all of G85, G70, F85, F70 appear in the top few shipper-vintage combinations. Which makes sense.

Helpful links to the TN indices, omitted in earlier post: alphabetical, and date.
Glenn E.
Graham’s 1977
Posts: 4174
Joined: 22:27 Wed 09 Jul 2008
Location: Seattle, WA, USA

Re: Time for a TN sort?

Post by Glenn E. »

And yet, oddly, V96 is the only Vesuvio on the list (in a tie for 14th) despite Vesuvio being tied for the 2nd most tasted shipper with Fonseca.
Glenn Elliott
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

Is it, perhaps, time for another TN sort?
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
User avatar
jdaw1
Cockburn 1851
Posts: 23613
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 »

Yes, and I can cope now. Alex K.: pls send data.
User avatar
Alex Bridgeman
Graham’s 1948
Posts: 14880
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by Alex Bridgeman »

Could I request that Chief Admin 1 and TN List Admin Snr co-ordinate between them the required processes to update the TN indices please?
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.

2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Post Reply