Movies

[ movies , analysis-recipe ]

Track the movies I watch and associated metadata.

IFTTT recipe: IMDB page, Pocket w/ tag video-checkin -> google sheet

Other pocket tags:

the year of the movie is in the title of each html doc.
where D2 is the html title, extract the date: =value(REGEXEXTRACT(D2,"[0-9]{4}"))
where H2 is the year, extract the decade: =concatenate(floor(H2/10),"0")
where C2 is the list of pocket tags, extract spend: =if(K2<datevalue("2016-08-28"),"unknown",if(iferror(find("$$",C2),-1)>=0,"buy", if(iferror(find("$",C2), -1)>=0,"rent", "free")))
where C2 is the list of pocket tags, extract venue: =if(iferror(search("amazon",C2),-1)>=0,"amazon", if(iferror(search("netflix",C2),-1)>=0,"netflix", if(iferror(search("hbo",C2),-1)>=0,"hbo", if(iferror(search("itunes",C2),-1)>=0,"itunes", if(iferror(search("theatre",C2),-1)>=0,"theatre", if(iferror(search("dvd",C2),-1)>=0,"dvd", if(iferror(search("airplane",C2),-1)>=0,"airplane",if(iferror(search("hotel",C2),-1)>=0,"hotel","other"))))))))