Time for a TN sort?

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

Re: Time for a TN sort?

Post by jdaw1 » 23:49 Sat 10 Jan 2009

A very special refreshment indeed.

That piece of code needs major rewrite. Will do.

User avatar
JacobH
Taylor Quinta de Vargellas 1987
Posts: 2283
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH » 14:33 Wed 14 Jan 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 15:00 Wed 14 Jan 2009

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
Taylor Quinta de Vargellas 1987
Posts: 2283
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH » 15:21 Wed 14 Jan 2009

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: 15221
Joined: 23:51 Wed 20 Jun 2007
Location: Chesterfield, UK
Contact:

Re: Time for a TN sort?

Post by DRT » 17:54 Wed 14 Jan 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 19:09 Wed 14 Jan 2009

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
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 23:07 Wed 14 Jan 2009

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 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

User avatar
JacobH
Taylor Quinta de Vargellas 1987
Posts: 2283
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH » 21:01 Sun 08 Feb 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 17:35 Mon 23 Mar 2009

TN indexes (alphabetical, date) updated.

User avatar
JacobH
Taylor Quinta de Vargellas 1987
Posts: 2283
Joined: 16:37 Sat 03 May 2008
Location: London, UK
Contact:

Re: Time for a TN sort?

Post by JacobH » 12:18 Tue 24 Mar 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 14:29 Tue 24 Mar 2009

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
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 14:43 Sun 14 Jun 2009

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 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

User avatar
jdaw1
Cockburn 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 16:12 Sun 14 Jun 2009

Coincidentally, I wrote to ARK just before you posted asking for updated data.

User avatar
jdaw1
Cockburn 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 12:38 Tue 16 Jun 2009

Done. Will be done again in early July.

User avatar
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 14:27 Tue 16 Jun 2009

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 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

User avatar
jdaw1
Cockburn 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 14:36 Tue 16 Jun 2009

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
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 14:39 Tue 16 Jun 2009

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 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

User avatar
jdaw1
Cockburn 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 14:42 Tue 16 Jun 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 16:26 Tue 16 Jun 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 16:29 Tue 16 Jun 2009

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 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 16:30 Tue 16 Jun 2009

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.
Quinta do Vesuvio 1994
Posts: 3357
Joined: 22:27 Wed 09 Jul 2008
Location: Seattle, WA, USA

Re: Time for a TN sort?

Post by Glenn E. » 17:17 Tue 16 Jun 2009

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
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 09:46 Tue 08 Sep 2009

Is it, perhaps, time for another TN sort?
Top Ports in 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

User avatar
jdaw1
Cockburn 1900
Posts: 20496
Joined: 15:03 Thu 21 Jun 2007
Location: London
Contact:

Re: Time for a TN sort?

Post by jdaw1 » 10:01 Tue 08 Sep 2009

Yes, and I can cope now. Alex K.: pls send data.

User avatar
AHB
Quinta do Noval Nacional 1962
Posts: 11870
Joined: 13:41 Mon 25 Jun 2007
Location: Berkshire, UK

Re: Time for a TN sort?

Post by AHB » 09:45 Fri 06 Nov 2009

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 2018 (so far): Niepoort VV (1960's Bottling), Quinta do Noval Nacional 1994 and San Leonardo Very Old White (Bottled 2018)
2017 Ports of the year: Fonseca 1927 and Quinta do Noval 1927

Post Reply