New pubs visited 2014

[bcfczuluarmy]

I was referring more to my date visited column which if I visit only I add date and don't move to the main spread sheet from the holding area, OCD creeping in here. Once I revisit with my mate it goes on the main list so when I filter I have to remember if I visited by myself this year/last year etc (hence the add a column to distinguish via another filter) and subtract numbers off the main filter and add to the revisit total. It then gets more complicated as the pubs I do outside the main area that both of us do are on different tabs and whether I add them at all which is the case with anything in the West Midlands so need to recall from memory or have a number of new pubs that day.

I don't make it simple for myself it seems...

[Al 10000]

This all sounds very ing.

Why dont you open another spread sheet to remember the pubs awaiting to go on your main spread sheet,there are usually about three pages to each sheet,that way you would not be trying to remember pubs you want to put on your main sheet.

Hope that makes sense.

[bcfczuluarmy]

I've got 6 different sheets on it at present, it's the evolving of it that's led to it being a bit disjointed via 6 sheets and trying to keep up with the Will Larter's and Quinno's on here that's led to the issues. I used to be happy just going the local once, the internet has destroyed me and turned me into some OCD addict....

[Al 10000]

Hi again, bcfczuluarmy


This is a quick photo i took of my main pub list as at 1998 it shows a good mix of pubs with photos added to my list some not and some i have photos of but not on my hyperlink yet.

The P at the start means i have a paper photo of the pub a small x means the pub was a fizz house ie no real ales,if a pub is shaded blue this means i have it hyperlinked to my list,i can also scroll down and find any date i visited a pub.

I hope you can see this list and it helps you out.

Cheers Alan

[Mobyduck]

Now on 24, I am not affected by the malaise affecting most of the contributors to this thread, they are the stats of what occurs along the way.
I do count new pubs but dont really understand the point of the revisits count , I do that all the time whereas new visits are unique.

[bcfczuluarmy]

Revisits are a badge of honour.... Somebody referred to revisits a while back and for me it seemed an easy sum to work out as I was trying to do a large area around Bristol within 2 years so further revisits just followed on after completing that mission. There are local revisits and revisits where you actually go out of your way to do because they are there.

[Mobyduck]

Fair enough.

[Strongers]

Woohoo I'm in a pub, 11th of the day (and year).

[sheffield hatter]

Think we need a thread on spread sheets, KML files, OCD etc.

Too late, you've already turned this thread into an OCD home from home! At least your degree of affliction gives those of us nearer the normal end of the spectrum some hope of recovery...

[sheffield hatter]

Woohoo I'm in a pub, 11th of the day (and year).

Well done! Welcome back to the world of beer.