AB
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
Roamio tabs
11
See my TiVoGet project on github
12
It will dump csv files to Google Drive that the sheet will import automatically.
13
Cancelled tab
14
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)
15
Static listings should have a . in column B to keep them at the top
16
Copy the data from the pages at
17
http://renewcanceltv.com/renewal-scorecard-2017-18/
18
and
19
http://renewcanceltv.com/renewal-scorecard-2018-19/
20
Paste the values into column B below static listings. In Column A put the start year of the page being copied from.
21
If the text in cells in columns matches the row above the test will be red
22
If the cell in column E is not blank the cell will also turn red.
23
Titles missing a : in column B will show A-G as white text on black background. Add the missing : if needed
24
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.
25
The data is split properly in columns I and J
26
Shows that seem to be labeled as still active are in green
27
Shows that seem to be labeled as still cancelled are in red
28
Shows that have a : in the status column H will be in grey
29
And shows that seem to be labeled as in limbo or are missing status are in yellow
30
If there appears to be no show data in that row, F to H will be blue
31
Premiere tab
32
Delete the data in column A
33
Copy the data for the upcoming months from
34
http://renewcanceltv.com/tv-show-premiere-dates-2017-complete-guide/10/
35
into column A
36
Copy the formula cells from B to G in the last row showing data to any rows added to bottom sheet.
37
Check the date in F2 to be day before that in A3 (helps detrimine year change in list)
38
Any shows that you have listed on your shows sheet should turn green.
39
40
41
Tools
42
Tool for dumping your TiVo info to Google Drive so it can be imported by the sheet.
43
44
To-Dos
45
46
47
48
Changes
49
7/8/2018Added changes section
50
Merge shoes and old show tabs
51
Fix some out of date formulas on shows tab
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