TLDR/Warning: this might be a tedious read. But I'm curious if I could have gone about rating my albums better.

I tend to simply either favourite an album or not. The idea of giving albums and tracks marks out of five stars seems tedious, difficult to match to how I feel and just doesn't match how my head works. But my collection has grown over the decades and I've been bed bound a lot lately, so I'm trying to organise/categorise based on my feelings towards the albums rather than genre. I'm also hoping to rejuvenate my old interest in music (playing in a band and recording for a living took the shine off of casual listening for me). I thought it would be an interesting experiment to try out, so I rated songs from over 50 albums.

I came up with a rigid and hopefully balanced definition for each rating:

• 1 star - Dislike. I hope I never hear this song again (but I'll keep it purely because it's part of the album)
• 2 stars - Neutral. It doesn't annoy me, but it's too generic to be interesting
• 3 stars - Sometimes this song hits the spot.
• 4 stars - This song usually hits the spot.
• 5 stars - This song always hits the spot.

Then I rate the album out of five stars based on the average of the song ratings. The result is that no albums got 5 stars, a seven got 4 stars, the vast majority of albums are rated at 3 or 2 stars. Even among the 3-star albums, some I like much more than others depending on whether they contain mostly consistent 3-star songs or half 4-star songs and half 2-star songs.

I wonder if the lack of 5-star albums is because of the definitions I gave each of the 1-5-star possibilities. For example, I don't know if any song "always hits the spot". Or maybe it's just that I'm not as into my music as I used to be.

Anyway, I thought maybe people interested in music and data might have thoughts on going about this differently. It's worth asking before I do the next 1,000 albums :) Maybe you'd define each of the 5 stars differently. Any takers?

Edit: thanks to everyone for reading all this and commenting their thoughts. I have a system I'm happy with now, but always happy to continue to chat with fellow (and reluctant) pedants about this.

Link to Google doc: https://docs.google.com/spreadsheets/d/1Hc-Ti6Pff_qUZLAfzzL7WjhFNh2m_XPvMkdYBL6mLzI/edit?usp=sharing

I created this document a while back and update it every couple months. There's an Introduction tab with guidance on how to browse the spreadsheets, which I've copied below for reference:

(1) This document outlines various TV shows and is broken up into 3 tabs: Watched, Watching, and Want to Watch.

Watched: Shows I've completed through series finale or given up on. Some of these were canceled early.

Watching: Shows I'm actively watching day-to-day or shows in between seasons that will air new episodes in the future.

Want to Watch: Shows I haven't started and want to watch. Many of them are recommendations I jotted down to avoid forgetting, so this list will sometimes be unalphabetized.

(2) Certain columns of information were exported directly from IMDB, and the page for each show is linked in the rating from the IMDB column.

(3) On the Watched and Watching tabs, there are columns for Recommend? and Notes to provide background that will help decide what to watch. Don't let any of my negative comments stop you from watching a show you're interested in.

(4) The Recommended? column is divided into the following categories: Must Watch, Yes, Maybe, No. These are all based on personal opinion with extra discussion/information in the Notes column.

(5) I've shared this with most people using View Only permissions, so download the Excel file (or copy to your Drive account) to filter columns by genre, rating, and personal recommendation.

Disclaimer: not everyone will have the same tastes as me - that's okay. I welcome any disagreement about how I've rated shows and hope to get some discussion going.

• What shows have I missed that I need to watch?

• What shows did I strongly recommend that you didn't like?

• What shows did I give up on too early?

I expect to take some heat for quitting Brooklyn 99 around season 3.

• What shows haven't come out that I should keep an eye out for?

Like Jack Ryan which debuts this month.

• How can I improve the document?

I considered including a column with the show's network or where it can be legally streamed, but this is pretty tedious given the nature of broadcast rights.