Happy Sunday! Well, I’m back to talking books this week. As I was entering some of my new purchases into my Excel spreadsheet, I thought I’d share with you how I catalog by books.
I started cataloging my books about 5 or 6 years ago after I started hitting numerous book sales and my personal library started growing exponentially. I felt I needed to keep track of what I had on the shelf and which I’ve read (and when). I started off using Microsoft Access, but this past year when I got a new computer and an upgrade to the new Windows, I imported everything in Excel. I LOVE Excel and what it an do in terms of tables.
Below is a screenshot of my Excel document. Click to picture to enlarge, otherwise it’s hard to see the categories. I have all my books numbered and have a column for Title, Author, Binding, Date Published, Date of my edition, Category, and Date Read. I love how I can sort and search using the pull-down menus. I also have a separate spreadsheet for the books I’ve read each year (starting with last year) that includes my rating and the url to the review. It’s boring, so I didn’t include it. The only pitfall to this catalog is it only shows what is IN my library. So if I’ve read a book and given it away or borrowed a book to read, it doesn’t go in the spreadsheet.
Do you catalog your books? What different categories do you use? Do you use online websites to help you catalog? I used to use GoodReads but it was too difficult to go through and input 650 books, so I stopped using it. What benefit do you find in cataloging your books?
In other Trish News:
I had another cake decorating class this week. Actually the cake making process was kind of a disaster–I had to toss one cake after it spilled over in the oven causing my house to smell like burnt cake all week. Then the frosting did not want to cooperate with me and my cake kept tearing. I finally piled on the frosting and took some paper towel to pat it down and to make it smooth. You can see in the second picture below where my frosting has cracked a little. My frosting turned a little spotty on top, and when I asked the instructor about this she shrugged and said “Dunno!” Thanks lady. All in all the class has been a lot of fun, but let’s face it, I don’t think I’ll be quitting my day job anytime soon.
I think this week will unfortunately be my last decorating class because next week Scott and I are taking a roadtrip!! In all fashions of spontaneity, we’ll be heading out on the road to the 2009 Sturgis Rally in South Dakota. While there we’re going to go down to Mount Rushmore and hopefully The Badlands. After that we’ll head west to Yellowstone National Park and Grand Teton National Park in Wyoming. See the picture below for our roadmap. Yup, that’s a lot of driving for one week, but Scott and I are King and Queen of the roadtrip. In case you’re wondering, we’re doing this all with one week’s worth of planning. Pretty crazy, but it’ll definitely be fun.
How’s everyone’s Sunday going? Lots of reading and relaxing?