Recording your pub visits?

[Delboy20]

How do you all record your pub visits?
I am a bit old school and I have a pile of old diaries covering the last 15 years or so where I have noted all my new pub visits. It is a real pain when I am trying to remember which pubs I went in when I last visited a town years before!
My real problem is that I know nothing about spreadsheets but there must be an easy way to record my visits.
I'd like to transfer all my diaries onto something which I can easily look through to find the pub name, town, date etc but I am clueless!
Hope this makes some sort of sense.
Help me ......

[sheffield hatter]

I know nothing about spreadsheets but there must be an easy way to record my visits.

Spreadsheets are quite easy to get into if you're prepared to give it a go. But if you're looking for a physical way of maintaining a list that's easier to search than 15 years of diaries, how about a card index?

[Walty]

When I started ticking venues off at the start of 2018 (rather than just going to pubs and not noting where I had been) I used (and still do) the Notepad on my iPhone. One note for each month in each year and by date I record where, generally what I had to drink and any interesting features about the venue and the street name. Generally then I can search the notes to check if I have been somewhere previously (although I generally remember that) but it can be pretty tricky to find when if it is say the Red Lion on High St as the search feature isn’t very good and just finds the first instance one of the words in the note for that month! Also some months a v long in terms of notes and for some reason there must be a maximum size of text for the Notes search feature to work (so can miss visits recorded in the last couple of days of active months)!! Better than nothing I suppose.

However, when I discovered PG last year, I used there feature there on where you can record the date of last visit to a venue and so it took me a while late last year and early this year to go through area by area adding the date of last visit to each pub there in. Would have missed a few in infrequently visited areas but I have recorded all visits in Central and Greater London and commonly visited places I think.

Would love to have the feature where you can select to show date of last visit by region of an area though. For camper am in Cardiff this weekend and have some time to kill this evening whilst my wife has an appointment so wanted to tick off remaining unvisited pubs in the Roath area. I can only select to see date of last visit / not visited at the Cardiff area (about 230 venues) but when I click into Roath (about 10 pubs) I can’t similarly click to see date of last visit if each of those pubs and have to check by finding them in the full listing for the Cardiff area. Not a hard task I know, and I remember generally which I have been to and which I haven’t but I did go and have to look a couple of them up in the big list.

[rpadam]

How do you all record your pub visits?
Help me ......

I was halfway through responding on a different device when I suddenly realised what the time was and had to leg it down to the station to get the train for an essential pub research trip!

I will finish it off (noting what others might have advised in the meantime) and send when I get back

[trainman]

I was halfway through responding on a different device when I suddenly realised what the time was and had to leg it down to the station to get the train for an essential pub research trip!

Brilliant! Excellent prioritisation of life's essentials. Loved this comment.

Delboy, if you were to mention here the columns you may want in a spreadsheet, suggestions above but you may want to add first date visited, most recent visit, number of beers etc, then I'm sure one of us could knock up the template to send you and you can just rename it and add/overtype your own data...

Does your laptop have excel? Mine, painfully, does not, but I can still use it via office, albeit a bit of a workaround.

[Delboy20]

Brilliant! Excellent prioritisation of life's essentials. Loved this comment.

Delboy, if you were to mention here the columns you may want in a spreadsheet, suggestions above but you may want to add first date visited, most recent visit, number of beers etc, then I'm sure one of us could knock up the template to send you and you can just rename it and add/overtype your own data...

Does your laptop have excel? Mine, painfully, does not, but I can still use it via office, albeit a bit of a workaround.

Laptop? You must be joking!!
Luckily my old fashioned PC does have excel and I think I'm off and running - just figuring out "filters"!

To me a filter was what the rich kids at college put in their roll ups!

[ETA]

Brilliant! Excellent prioritisation of life's essentials. Loved this comment.



Does your laptop have excel? Mine, painfully, does not, but I can still use it via office, albeit a bit of a workaround.

I use Apache LibraOffice which does (almost) everything MS Office does, is fully compatible with MS Office and Apple, and it's free.

[Tris39]

Spreadsheets are quite easy to get into if you're prepared to give it a go. But if you're looking for a physical way of maintaining a list that's easier to search than 15 years of diaries, how about a card index?

I wish I'd started out using a spreadsheet, but I just have the Year --> Month --> Name --> PuG code, but no score.

To me a filter was what the rich kids at college put in their roll ups!

I thought that was a roach.

[Mobyduck]

I thought that was a roach.

I thought that was a fish!

[Delboy20]

I wish I'd started out using a spreadsheet, but I just have the Year --> Month --> Name --> PuG code, but no score.



I thought that was a roach.

No mate, we used a roach (the corner of your fag paper packet) - the rich kids had proper filters!