Ads not shown when logged in
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Recording your pub visits?

  1. #11
    Pub researcher (unpaid) rpadam's Avatar
    Join Date
    Jan 2010
    Location
    Somewhere in the Low Weald
    Posts
    5,147

    Default

    Quote Originally Posted by Delboy20 View Post
    Quick question on dates. I know exactly when I have visited new pubs for the last 15 years but what about before that?

    I want to eventually record all the pubs I have visited but have no idea of dates between 1987 - 2009. Any suggestions?
    If you only know the year, you can enter 'yyyy (with the ' being important because it makes Excel think it's text not a number), e.g. '1987 (because if you just enter 1987 Excel will convert it to 9 June 1905!).

    If you know the month and year, I would recommend uncertain dates in the form of yyyy-mm (which will be treated as text without needing the '), e.g. 2009-07 for July 2009.

    If you can only guess the decade you could enter something like 198x or 200x, or 19xx or 20xx for century.

    The important point is to start with the year and be consistent the formatting because the text 'dates' will sort automatically in any alphabetical list.

  2. #12
    I Keep Mine Hidden Delboy20's Avatar
    Join Date
    Feb 2007
    Location
    Black Country
    Posts
    1,328

    Default

    Quote Originally Posted by trainman View Post
    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!


    I am a salmon !!

  3. #13
    Humble Wordsmith ETA's Avatar
    Join Date
    Feb 2010
    Location
    Normally Somerset, sometimes on a yacht.
    Posts
    1,623

    Default

    Quote Originally Posted by trainman View Post
    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.
    'Beer is for all day, not just for breakfast'.

  4. #14
    This Space For Hire
    Join Date
    Sep 2013
    Location
    Out West
    Posts
    3,349

    Default

    Quote Originally Posted by sheffield hatter View Post
    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.

    Quote Originally Posted by Delboy20 View Post
    To me a filter was what the rich kids at college put in their roll ups!
    I thought that was a roach.

  5. #15
    Still about Mobyduck's Avatar
    Join Date
    Aug 2010
    Location
    Out saving pubs and enjoying it.
    Posts
    5,970

    Default

    Quote Originally Posted by Tris39 View Post



    I thought that was a roach.
    I thought that was a fish!
    "Everybody's got to believe in something. I believe I'll have another beer."
    -W.C.Fields

  6. #16
    I Keep Mine Hidden Delboy20's Avatar
    Join Date
    Feb 2007
    Location
    Black Country
    Posts
    1,328

    Default

    Quote Originally Posted by Tris39 View Post
    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!


    I am a salmon !!

  7. #17
    I Keep Mine Hidden Delboy20's Avatar
    Join Date
    Feb 2007
    Location
    Black Country
    Posts
    1,328

    Default

    Just a quick update for anybody interested!

    I have made a start and done the last 2 years. I have also done 2009 and moved into 2010.

    I am at just over 600 and I've only just started!


    I am a salmon !!

  8. #18
    Pub researcher (unpaid) rpadam's Avatar
    Join Date
    Jan 2010
    Location
    Somewhere in the Low Weald
    Posts
    5,147

    Default

    Quote Originally Posted by Delboy20 View Post
    I am at just over 600 and I've only just started!
    Well done - keep going!

Similar Threads

  1. New pub visits 2021
    By Delboy20 in forum Chit Chat
    Replies: 143
    Last Post: 03-01-2022, 18:37
  2. New pub visits 2019
    By Delboy20 in forum Chit Chat
    Replies: 206
    Last Post: 07-01-2020, 07:39
  3. New pub visits 2018
    By Delboy20 in forum Chit Chat
    Replies: 175
    Last Post: 02-01-2019, 10:55
  4. New pub visits 2017
    By Delboy20 in forum Chit Chat
    Replies: 166
    Last Post: 10-07-2018, 23:40
  5. New pub visits 2016
    By bcfczuluarmy in forum Chit Chat
    Replies: 239
    Last Post: 06-01-2017, 11:01

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •