Wednesday, August 30, 2017

Created a TiVo info downloader

The Git project is at

The idea is you have this run each night (Task Scheduler or cron) to update csv files in your Google Drive and the use the SheetGo Plugin to read in the info from the csv files to your copy of my Cord Cutting Notes sheet Then I should be able add automation to look at shows watched (watchedTime > 0) in the Now Playing list to auto update the sheet. In theory I could use this to get latest available episode info as well for any shows not listed in ShowRSS.

Saturday, June 24, 2017

Made Last Show tab update fully automated via a menu option

Updated the show tracking sheet 

On "Last Show" tab I added a column. 

Instead of updating the offset key manually and then copying columns now you just click the update menu item to do all the steps. 

This required adding a column to sort the feed data which still comes into column A. The macro updates the offset key with a current timestamp to trigger reimport of feed data. It then copies the data to column B so that is can be sorted (to get around the issue of older episodes sometimes coming higher in the feed than newer ones). Then finally it copies the diffed data in columns O and P to the cached data area.

Monday, April 24, 2017

New Netflix rating system is a major fail.

I'm a bit behind on this one as I've been mainly on Hulu and Amazon lately but when I went to Netflix this weekend I found they had changed out the rating system. For why look here. To me the "logic" described is dubious at best. If you Google "New Netflix rating system" you will see it is NOT going over well with anyone. My main gripe is when I'm browsing titles I used to be able to see my rating if I've rated it. That would tell me if I'd already seen it and what I thought of it. Having rated over 2000 titles in the old Netflix system that came in REAL handy. (I have friends that have rated WAY more.) It is really depressing to pick something that looks good only to realize after watching awhile that you have seen it and hated it. The new system does show you the ones you given a thumbs up or down but not the ones you have given stars. Fortunately the info has not been completely lost and your ratings old and new can still be seen from your My Activity page. (I suggest you down load this page while you can.) But that begs the question why they are not displaying that you have already rated it in the browser? Either as the star rating still there in the DB or by converting it to the thumbs up/down system for display.

Another new bit is now for unrated (via new system) titles you see a percent match instead of the average rating of other subscribers. I have not got a feel for how accurate this is yet but again that would infer they are trying get the model even more accurate. Generally the way to do that is to get finer detail of the watcher's like and dislikes not less.

The other issue with a binary system of course is what about the stuff that is just OK? As in stuff that was worth watching once but not again. How do I rate that with love or hate as my only options? Marking it either way will skew their suggestion model and not marking leaves me no way to see I've already watched it. To look at this I downloaded my "My Activities" page with over 12 years of ratings and converted it to a sheet so I'd have the data. And to see how is much this might truly effect things. I found:

  • The single list of ratings on "My Activity" has entries formatted 3 ways which made converting it to a sheet a bit of a pain. (This might also mean a previous change in December of 2015 is affecting this.)
  • Of the 2160 titles I've rated 1897 (~88%) were in the 2-4 star range.
  • 947 (44%) of my ratings are 3s that the new binary system can not handle.
  • 138 of the movies and 23 series I have rated are no longer on Netflix.
  • My average rating under the old system is 3.2
  • Converting thumbs down to 1 and up to 5 my average rating drops to 2.5 with the new system
  • So on average titles lose about 0.7 stars under the new system

Facebook removed their rating system for movies and TV shows awhile back too. While you can still add them to watched / want to watch sections and even write a review as a comment, all those star ratings you did are now toast. Funny thing is when you try to find out when did this there appears to be no stories about. Probably why Netflix thought it was a good idea to follow suit. Unfotunately for Netflix people are noticing.

Wednesday, April 19, 2017

Added some more validation to the Last Shows tab of sheet.

Updated the show tracking sheet 

I noticed some of the show names had changed in my feed so were not updating the cache columns. So I added a column between the feed columns and the cache columns that checks that each show in the feed is in the cache and turns green if it is #N/A then you either need to change the name in the cache list or add it.

Friday, February 24, 2017

Signal issues and deafening commercials giving me second thoughts

Last night's adventure 

Was getting ready for bed last night an went to turn on Colbert on the Tivo and found dead air. Flipped to ABC and it was dead too. This was to be my third debug mission just since I started for bed some 2 hours ago at this point so I was not happy! Having cable flashbacks I tried all the usual quick fixes including pulling stuff from the Goodwill pile to swap out but no help. Using my TiVo into signal strength mode and found the signal strengths were the same with either amp. Plus they were about what I recorded over a month ago. So finally I gave up and went to bed thinking the antenna must have slipped or something and it would just need to wait. However ABC and CBS look fine today so thinking they must be testing dropping to a lower power at night or something. I noticed ABC seemed weak the other early morning too. I messaged both to confirm. But no reply as yet. Does not bode well. Especially combined with the CW having slipped below the watchable at least 50% of the time level.

So now what?

You might recall I started streaming stuff I can't get over the air since last November when I got fed up with Time Warner knocking my cable box (tuner) and sometimes even my TiVo off line. I've been mainly streaming from Hulu or the network's sites since TWC's streaming is usually days behind everywhere else. I can not stream the morning news though. And I have to admit I'm getting pretty fed up with the cranked up commercials most of the networks are streaming. I have to sit with one hand on the mute button they are so much worse than when the feds stepped in back in 2011 to make them stop it when broadcasting. So I'm thinking of just switching my remaining TiVo back to cable for any broadcasts not on Hulu. Especially since now that Comedy Central is pulling their stuff off Hulu and using those windows rattling commercials on their streaming site. Plus it would be nice to see The Daily Show and @midnight on the same day they broadcast again. In a related story I found my missing extra cable card last weekend. No less than 3 times Time Warner has told me they have taken it off my bill since it was never activated because they sent it without a tuner about 2 years ago. Just checked and they are still monthly charging me for it. Granted not enough to warrant a special 50 mile round trip to town just to turn it in. So it all this seems to be telling me I should give a more hybrid approach (cable card but no tuner) a try to see if TWC can keep from knocking it off line. And even if they do it is starting to look like I probably will not be worse off. It is either that or try and cobble together an even stronger antenna / amp combo which would seem to probably require a radio tower to get more signal over the ridge. That does not seem like that good of an investment if the stations might be turning down the power.

Wednesday, February 15, 2017

Comedy Central pulling out of Hulu?

Yep seems not enough people braved getting forced to watch ads just to see uncensored versions of their shows so they are pulling them home. Read more here. This move is even stranger given Turner announced not that long ago they would be putting shows on Hulu.

Thursday, February 9, 2017

Did you know you could watch Amazon subscriptions on Roku?

I picked up a Fire Stick for $30 last Black Friday and have been bouncing between it and the Roku since. I even added Acorn TV through Amazon. Tonight though the WiFi demons are in rare form. After resuming the same 1 hour episode of Doc Martin 6 times, I switched back to Hulu on the Roku while I research how to get my login info for Acorn TV (since there is no login to watch it via Fire TV). Turns out all you need to is bring up the Amazon app on the Roku and just start playing the show! Interface is not near as nice but at least I can watch TV while I sort out what keeps knocking my Access Points off line.