Saturday, May 19, 2018

Updated Cord Cutting Notes sheet to pull TiVo data

My watched vs available sheet Cord Cutting Notes  now pulls in the csv files created by my TiVoGet program as part of the Last Show update. I also updated the menu to the new sheet model. (Something you seem to need to do now if you edit a sheet script with the old menu model in it.)

Saturday, May 5, 2018

Cord Cutting Notes now pulling status info from epguide

My watched vs available sheet Cord Cutting Notes now has a status column at G on the shows tab that combines info copied in from with auto pulled data from's Current U.S. Shows on Hiatus or Discontinued page to try and let you know the status of shows listed on the shows tab.

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.