jAHB wrote:I think it looks great is destined to become one of the historic charts in the folklore of port, ranking alongside Baron Forrester's maps.
Ahh, but can you click on one of the dots on the Barrn's map and be taken directly to a Tasting Note?
Yes indeed: high praise from “jAHB†. The bounding rectangle can be clickable, but to which TN should it go? Or it could be split into n thin rectangles, each of which goes to a different TN. But for the user that starts to be small and fiddly. Thoughts?
What goes in the box? Don’t worry about wingdings: anything can go in. Possibilities include:
A filled star for proper declarations; an empty star for unofficial Taylor-Special-Quinta type things, which would also apply to Shipper’s Own Blend stuff.
A number, being pipes shipped. (Hello data man.)
A combined TPF and other sources rating, compiled by the obvious suspects (Uncle Tom isn’t here, so we should delegate that task to him).
jAHB wrote:I think it looks great is destined to become one of the historic charts in the folklore of port, ranking alongside Baron Forrester's maps.
Ahh, but can you click on one of the dots on the Barrn's map and be taken directly to a Tasting Note?
Yes indeed: high praise from “jAHB†. The bounding rectangle can be clickable, but to which TN should it go? Or it could be split into n thin rectangles, each of which goes to a different TN. But for the user that starts to be small and fiddly. Thoughts?
Could the click cause a list of available TN's to drop down from the box allowing the user to select one to view?
jdaw1 wrote:What goes in the box? Don’t worry about wingdings: anything can go in. Possibilities include:
A filled star for proper declarations; an empty star for unofficial Taylor-Special-Quinta type things, which would also apply to Shipper’s Own Blend stuff.
A number, being pipes shipped. (Hello data man.)
A combined TPF and other sources rating, compiled by the obvious suspects (Uncle Tom isn’t here, so we should delegate that task to him).
Other.
What goes in the star should be useful. I'm not sure the number of pipes shipped would qualify. Perhaps Uncle Tom's auction prices could be mangled in here?
Derek
PS: On table orientation: Does anyone know an easy way to take a spreadsheet by the top left and bottom right corners and flip it over through 180 degrees through a diagonal axis so that Column A becomes Row 1 and vice-versa and everything in the middle ends up in its rightful place?
"The first duty of Port is to be red" Ernest H. Cockburn
Derek T. wrote:What goes in the star should be useful. I'm not sure the number of pipes shipped would qualify. Perhaps Uncle Tom's auction prices could be mangled in here?
Great idea.
Derek T. wrote:PS: On table orientation: Does anyone know an easy way to take a spreadsheet by the top left and bottom right corners and flip it over through 180 degrees through a diagonal axis so that Column A becomes Row 1 and vice-versa and everything in the middle ends up in its rightful place?
On a new sheet something like “=Index(OriginalSheet!$A$1:$IV$256, Column(ThisCell), Row(ThisCell) )†?
Derek T. wrote:PS: On table orientation: Does anyone know an easy way to take a spreadsheet by the top left and bottom right corners and flip it over through 180 degrees through a diagonal axis so that Column A becomes Row 1 and vice-versa and everything in the middle ends up in its rightful place?
In Excel, if you select a range and copy it, then go to a new spot (or worksheet) and "Paste Special" -- check the box "Transpose" and it will swap em.