Posts

Showing posts from December, 2020

Thirsty Thursday Eve - North Carolina Monthly Liquor Sales

As I mentioned last month, North Carolina has some super weird liquor laws and pricing policies. However, the monthly scheduling means that I have incentive to try something new each month. Specifically, true to the form of the economic alcoholic, I can pick up one of the cheapest sale items and see how bad it is. So finding the monthly sale items in North Carolina liquor stores is pretty easy. You go to this site , select the current month in the “Month” drop down list, and select Microsoft Excel in the “File Type” drop down list. Then hit “Create Report.” You could also select PDF, but spreadsheets are the superior file type. Fight me. This is where it gets a little funky. For whatever reason, the spreadsheet is in this really weird format, where the headers are vertically merged and there are two empty columns between each populated column. I have no idea why the formatting is so wonky, Google Sheets won’t sort the price columns in the original state. You have to do a little data ma

Google Play Music to Plex

Image
The recent death of Google Play Music forced me to adopt a new music streaming platform. I decided on Plex. That migration has not been easy. Disclaimer: A word to the wise, fix your music folder before you ever bother with the Plex side of things. There are several tools and utilities I have discussed below, but everything is going to work much better if you get the music file structure right first. Everything should be divided into artist, and further divided into album. A free utility called foobar2000 can do that for you, if you take some time to tinker with it. AFTER the file structure of your music is right, THEN download and install the Plex server. If you need to set up a static IP and port forwarding, you can configure that all later. Be wary of my mistake, though, you want the music file structure to be pristine before you try to import it into Plex. Now, onto the ordeal I faced. I’ve been a power user of Google Play Music since almost the beginning. At least as far back as J