01438 741177         thewinesociety.com

The Society's Community

The spreadsheet thread

So… as a first step I tried to specify what useful fields would be and how they might be used. Here is a google sheet:

The following have shown interest in this so getting a call out to ask for feedback.
@adbdorset
@piersb
@Leah
@strawpig
@Alchemist
@SteveSlatcher
@andrew73

Bear in mind that this is “just” to extract data on Reserves and En Primeur from the society (so not detailed description of tasting, ratings, etc). I guess it would also be possible to add a category that shows “delivered” as well…

5 Likes

Being self critical… I guess we could remove the “drink status” field as that can be computed. Same with price per bottle (price paid for group/bottles stored).

1 Like

This is a great thread. I never knew I could download a csv of my reserves.

I would be happy to join the feedback list.

Added to the list…

1 Like

Having for the first time ordered a 12 bottle mixed case from reserves, I now realise that we need a column for the initial order (say 6 bottles) vs currently remaining from the order (4 bottles). I’ll update the googlesheet. All comments welcome.

I use neither reserves nor spreadsheets, so these are mere suggestions, rather than desires. Feel free to adopt them or not as you see fit.

  1. Change “Bottle Type” to “Bottle Size” - in cl or ml. That way the size of the “Other” bottles can be coded. Let the receiver of the exported data convert it into text if they want.

  2. “Product Type” is a bit vague. “Madeira” is not a “Product Type” in the same way that “Red” is. It is arguably more of a region. How about a “Colour” column (don’t forget Orange!), and one for “Still/Sparkling/Fortified”?

  3. Is “Region” just free text? Maybe it should be restricted to a number of fixed options, but I realise that might be impractical. Personally I would prefer a column for country; and a separate one that, where applicable, only holds the PDO/PGI for EU wines, or one of the official non-EU regions (pobably also impractical)

I’m not going to argue the case for these suggections, but if anyone has any questions I’m happy to try to anwser. Probably best to reply to this post or tag me, as I might not notice otherwise. Good luck with the project, @Brighton_Ben!

@SteveSlatcher - your suggestions duplicates Cellartracker structure :slight_smile:

The limiting of entries to PDO/PGI/ etc is enforced on CT.

P’raps if people don’t want to use CT they could create one entry on CT to download it as spreadsheet then all the fields used on CT would be column headers ?

Maybe CT has changed since I last saw it - I don’t use it myself, but I did check out the database schema several years back. Any similarity was coincidental, or a case of “great minds think alike” :slight_smile:

I seem to remember they had country, region, sub-region and sub-sub-region, but it was never clear to me how the regions and sub-regions should be used, and they seemed to put PDO/PGIs into one of those fields

Thanks Steve! The Bottle size in ml would help. It will depend on whether TWS has that data in their database structure at the moment.
Likewise for product type - whatever they have would work

Since the aim is to get the WS data they have into a more useable form without having to create new data I doubt we will have the PDO/PGI etc… but I could be wrong. Maybe they have.

1 Like

I said this about my fishing diaries 20 years ago…no closer.

LOL me too.

My mountaineering diaries the same (not to mention the slides!)

You need to make it at least xlsx.

That is, if it’s for really large cellars.

A JSON schema is surely the best option, though? (Hides from ensuing flame war…)

7 Likes

Managed to add all my En Primeur wine into an Airtable sheet, quite happy with it!

I have sheet for the bottles which are linked to the offers

9 Likes

Oooh. What’s an Airtable? Do you have to manually link the descriptions or is that automated somehow?

Airtable is an online database tool, really versatile. I use it for all sorts

Sadly it’s all manually inputted but once it’s on you can link to other sheets

For example I have the EP offers linked to each bottle of wine

So didn’t have to duplicate the descriptions

So… I finally got around to emailing the nice IS/IT people in at the Wine Society with the fields and extract suggestions… They were invited to have a look at this thread as well.
No replies yet but will keep you posted. Or maybe they can post directly here.

2 Likes