Time for a TN sort?
Re: Time for a TN sort?
A very special refreshment indeed.
That piece of code needs major rewrite. Will do.
That piece of code needs major rewrite. Will do.
- JacobH
- Quinta do Vesuvio 1994
- Posts: 3300
- Joined: 16:37 Sat 03 May 2008
- Location: London, UK
- Contact:
Re: Time for a TN sort?
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)?
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)?
Re: Time for a TN sort?
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.
- JacobH
- Quinta do Vesuvio 1994
- Posts: 3300
- Joined: 16:37 Sat 03 May 2008
- Location: London, UK
- Contact:
Re: Time for a TN sort?
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.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?)
Re: Time for a TN sort?
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.JacobH wrote: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.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?)
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
Ernest H. Cockburn
Re: Time for a TN sort?
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.DRT wrote:Is the current index fit for purpose? I think it is.
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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.
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.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
- JacobH
- Quinta do Vesuvio 1994
- Posts: 3300
- Joined: 16:37 Sat 03 May 2008
- Location: London, UK
- Contact:
Re: Time for a TN sort?
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.
Re: Time for a TN sort?
TN indexes (alphabetical, date) updated.
- JacobH
- Quinta do Vesuvio 1994
- Posts: 3300
- Joined: 16:37 Sat 03 May 2008
- Location: London, UK
- Contact:
Re: Time for a TN sort?
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.jdaw1 wrote:TN indexes (alphabetical, date) updated.
Re: Time for a TN sort?
Whoops. The symbolism is that Tom noticed that some Nacionals had become Novals (very unfortunate), so I fixed just that post. Will re-fix.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.
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Re: Time for a TN sort?
Coincidentally, I wrote to ARK just before you posted asking for updated data.
Re: Time for a TN sort?
Done. Will be done again in early July.
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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"?
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.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Re: Time for a TN sort?
Needs work.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
Just as AHB rather likes his Vesuvio, I like F70. What’s wrong with that?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
When I return from travels, I can tackle this. Easiest done from the spreadsheet.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"?
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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).jdaw1 wrote:Just as AHB rather likes his Vesuvio, I like F70. What’s wrong with that?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
Top Ports in 2023: Taylor 1896 Colheita, b. 2021. A perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Re: Time for a TN sort?
Port: CountAHB wrote:"most tasted port"
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
Re: Time for a TN sort?
Well, most tasted shippers are as follows.AHB wrote:"favourite shipper"?
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
Re: Time for a TN sort?
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
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
Re: Time for a TN sort?
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.
Helpful links to the TN indices, omitted in earlier post: alphabetical, and date.
Re: Time for a TN sort?
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
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.
Re: Time for a TN sort?
Yes, and I can cope now. Alex K.: pls send data.
- Alex Bridgeman
- Graham’s 1948
- Posts: 14906
- Joined: 13:41 Mon 25 Jun 2007
- Location: Berkshire, UK
Re: Time for a TN sort?
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.
2024: Niepoort 1900 Colheita, b.1971. A near perfect Port.