Cord Cutting Notes
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
A
1
Last Show Tab
2
Sign up for a free account at https://showrss.info
3
Add your shows to your feed
4
Change the URL in A1 to the one they give you for your feed and add &lastpull=date to end
5
In A1 change the date on the end to force the import to update
6
As shows go on hiatus add them to the cache columns (F-H) since the feed only shows current shows.
7
Note sometimes the feed seems to get cached.
8
If you sort the cache columns by name and a show in in there twice, the second will turn red.
9
See Cord Cutter Menu for sorting options
10
TiVo.OnePass tab
11
If you have OnePasses on your TiVo put them on TiVo.OnePass tab or import them via SheetGo
12
To copy in manually:
13
Use kmttg to export OnePasses as csv file
14
Open csv file with spreadsheet software
15
Copy paste ao A1 of TiVo tab
16
Cancelled tab
17
Delete the data in column A and B below the static listings at the top (shows not in the canceled list because they are too old or otherwise not listed)
18
Static listings should have a . in column B to keep them at the top
19
Copy the data from the pages at
20
http://renewcanceltv.com/renewal-scorecard-2017-18/
21
and
22
http://renewcanceltv.com/renewal-scorecard-2018-19/
23
Paste the values into column B below static listings. In Column A put the start year of the page being copied from.
24
If the text in cells in columns matches the row above the test will be red
25
If the cell in column E is not blank the cell will also turn red.
26
Titles missing a : in column B will show A-G as white text on black background. Add the missing : if needed
27
Once you have dealt with any trascription issues I usually sort column B then A to make finding show easier and match up shows in both lists.
28
The data is split properly in columns I and J
29
Shows that seem to be labeled as still active are in green
30
Shows that seem to be labeled as still cancelled are in red
31
Shows that have a : in the status column H will be in grey
32
And shows that seem to be labeled as in limbo or are missing status are in yellow
33
If there appears to be no show data in that row, F to H will be blue
34
Premiere tab
35
Delete the data in column A
36
Copy the data for the upcoming months from
37
http://renewcanceltv.com/tv-show-premiere-dates-2017-complete-guide/10/
38
into column A
39
Copy the formula cells from B to G in the last row showing data to any rows added to bottom sheet.
40
Check the date in F2 to be day before that in A3 (helps detrimine year change in list)
41
Any shows that you have listed on your shows sheet should turn green.
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Instructions
Links
Networks
Providers
Players
shows
Old Shows
Last Show
Premiere
Cancelled
TiVo.OnePass
ToDos
OTA
CableCard
Roamio.npl
RoamioB.npl
ShowRSS.chk
SG_Roamio_Todo.csv
SG_Roamio_npl.csv
SG_RoamioB_npl.csv
SG_Roamio_sp.csv
 
 
Main menu