Sam's movie night: announcements
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
slumdog millionaireUSED
DONT DELETE
.=IF(ISBLANK(A1),,(HYPERLINK("http://www.omdbapi.com/?t="&A1&"&plot=short&r=xml&tomatoes=true")))
2
• Sat Jan 23
#VALUE!
.=IF(ISBLANK(A98),, "Year: " & (importxml((W7),"root/movie/@year")) & char(10) & "Genre: " & (importxml((W7),"root/movie/@genre")) & char(10) & "Director: " & (importxml(W7,"root/movie/@director")) & char(10) & (importxml(W7,"root/movie/@awards")) & char(10) & (importxml((W7),"root/movie/@imdbRating")) & " <= IMDB rating" & char(10) & (importxml((W7),"root/movie/@tomatoMeter")) & " <= Rotten tomatoes critics rating" & char(10) & importxml((W7),"root/movie/@tomatoUserMeter") & " <= Rotten tomatoes audience rating" & char(10) & (importxml((W7),"root/movie/@metascore")) & " <=Metascore" & char(10) & char(10) & "Short synopsis: " & (IMPORTXML(W7,"root/movie/@plot")))
USED
DONT DELETE
#N/A
3
is the Mansion Party.
across all meetup groups as of 12/11/18 04:06AMUSED dnt delete#N/A
4
#N/A34 people RSVP'd.
REFRENCE dnt delete.=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//span[@class='time'])[1]"))
5
is the superbowl party.
across all meetup groups as of 12/11/18 04:06AMREFRENCE DONT DELETE.=(iferror(ImportXML(N108,"//span[@class='rsvp-count-number rsvp-count-waiting']"),0))
6
#N/A34 people RSVP'd. REFRENCE DONT DELETE.=iferror((ImportXML("http://www.meetup.com/Redditors-Unite/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')"))-11,0)
7
is the next movie night.
as of 12/11/18 04:06AM across all meetup groups.
time diff format
8
9
This week's we're watching:This week's movie will be:
10
SlumDog Millionaire.=A1 & " (" & (importxml((Z1),"root/movie/@year")) &")"
11
Genre: Drama, MysteryDirector: Asghar Farhadi.="Genre: " & (importxml((Z1),"root/movie/@genre")).="Director: " & (importxml(Z1,"root/movie/@director"))
12
Won 1 Oscar. Another 76 wins & 41 nominations..=(importxml(Z1,"root/movie/@awards"))
13
IMDBRT CRITICSRT AUDIENCEMETASCOREIMDBRT CRITICSRT AUDIENCEMETASCORE
14
8.499%92%95%.=(importxml((Z1),"root/movie/@imdbRating")).=(importxml((Z1),"root/movie/@tomatoMeter")) & "%".=importxml((Z1),"root/movie/@tomatoUserMeter") & "%".=(importxml((Z1),"root/movie/@metascore"))
15
16
A married couple are faced with a difficult decision - to improve the life
of their child by moving to another country or to stay in Iran and look
after a deteriorating parent who has Alzheimer's disease.
.=(IMPORTXML(Z1,"root/movie/@plot"))
17
18
19
20
21
22
23
24
25
26
27
28
29
30
socialize<===keyword regulars precalculation ====>auto calcpull from urltotal
31
Redditors in LA
http://www.meetup.com/Redditors-Unite/events/228271364/
.=iferror(ImportXML(D31,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)#VALUE!
32
High Value Hangoutshttp://www.meetup.com/culturecircle-99/events/228223607/.=(ImportXML("http://www.meetup.com/culturecircle-99/","substring-before((//div[@class='docSection']//div[@class='gutter-left lastUnit' and ..//h3[contains(.,'Mansion')]])[1], ' ')"))-11.=iferror(ImportXML(D32,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)
33
Los Angeles 20s & 30s- Adventures, Drinks, Friends and More!http://www.meetup.com/High-Value-Hangouts/events/228223608/.=iferror(ImportXML(D33,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)
34
I'm A Cool Nerd!http://www.meetup.com/LosAngeles/events/228223581/.=iferror(ImportXML(D34,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)
35
20's-30's YOUNG IN LA!!http://www.meetup.com/LosAngelesCalifornia/events/228223566/.=iferror(ImportXML(D35,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)
36
20 & 30 Somethings LA - Hikes, Drinks, Parties, Fun Stuff!~http://www.meetup.com/santamonicaTOhollywood/events/228223483/.=iferror(ImportXML(D36,"//span[@class='rsvp-count-number rsvp-count-going']")-21,0)
37
38
39
afterparty<===keyword regulars precalculation ====>11auto calcpull from urltoal
40
Redditors in LA
http://www.meetup.com/Redditors-Unite/events/231706853/
-11.=iferror(ImportXML(D39,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)-11#N/A
41
High Value Hangoutshttp://www.meetup.com/High-Value-Hangouts/events/228146790/.=iferror((ImportXML("http://www.meetup.com/High-Value-Hangouts","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., '" & A39 & "')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')"))-G39).=iferror(ImportXML(D41,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)
42
Los Angeles 20s & 30s- Adventures, Drinks, Friends and More!http://www.meetup.com/LosAngelesCalifornia/events/228128170/.=iferror((ImportXML("http://www.meetup.com/LosAngeles/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., '" & A39 & "')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')"))-G39).=iferror(ImportXML(D42,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)
43
I'm A Cool Nerd!http://www.meetup.com/culturecircle-99/events/228128191/-11
44
20's-30's YOUNG IN LA!!http://www.meetup.com/LosAngeles/events/228128217/.=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., '" & A39 & "')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-G39).=iferror(ImportXML(D44,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)
45
20 & 30 Somethings LA - Hikes, Drinks, Parties, Fun Stuff!~http://www.meetup.com/santamonicaTOhollywood/events/228128107.=(ImportXML("http://www.meetup.com/santamonicaTOhollywood/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., '" & A39 & "')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-G39).=iferror(ImportXML(D45,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)
46
47
#NAME?
48
socialize<==keyword regulars precalculation ==>11auto calcpull from sheettotal17
49
Redditors in LA2 34
.=(ImportXML("http://www.meetup.com/Redditors-Unite/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li/a/@href)[1]"))
50
High Value Hangoutshttp://www.meetup.com/High-Value-Hangouts/events/231178566/0
.=(ImportXML("http://www.meetup.com/High-Value-Hangouts/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li/a/@href)[1]"))
51
20's & 30's Somethings LA - Friends, Parties, Hikes, & Food!6 #ERROR!
.=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li/a/@href)[1]"))
52
I'm A Cool Nerd!0
.=(ImportXML("http://www.meetup.com/culturecircle-99/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li/a/@href)[1]"))
53
20's-30's YOUNG IN LA!!6 #VALUE!
.=(ImportXML("http://www.meetup.com/LosAngeles/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li/a/@href)[1]"))
54
20 & 30 Somethings LA - Hikes, Drinks, Parties, Fun Stuff!~
http://www.meetup.com/santamonicaTOhollywood/events/227707574/
9 #VALUE!
.=(ImportXML("http://www.meetup.com/santamonicaTOhollywood/","(//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., '" & A48 & "')]]//ul//li/a/@href)[1]"))
55
https://api.meetup.com/2/events?group_urlname=santamonicaTOhollywood&key=676e107a471059286663564c4321452runtimes:687
56
.=iferror(getAttendeess("Redditors-Unite")," ")
57

.=iferror(getAttendeess("High-Value-Hangouts")," ")
58
.=iferror(getAttendeess("LosAngeles")," ")
59
.=iferror(getAttendeess("culturecircle-99")," ")
60
.=iferror(getAttendeess("LosAngelesCalifornia")," ")
61
.=iferror(getAttendeess("santamonicaTOhollywood")," ")
62
63
64
65
66
67
68
OLD BACKUP UNUSED SHIT BELOW THIS
69
.=IF(ISBLANK(A1),, "Year: " & (importxml((Z1),"root/movie/@year")) & char(10) & "Genre: " & (importxml((Z1),"root/movie/@genre")) & char(10) & "Director: " & (importxml(Z1,"root/movie/@director")) & char(10) & (importxml(Z1,"root/movie/@awards")) & "<= Awards" & char(10) & (importxml((Z1),"root/movie/@imdbRating")) & " <= IMDB rating" & char(10) & (importxml((Z1),"root/movie/@tomatoMeter")) & " <= Rotten tomatoes critics rating" & char(10) & importxml((Z1),"root/movie/@tomatoUserMeter") & " <= Rotten tomatoes audience rating" & char(10) & (importxml((Z1),"root/movie/@metascore")) & " <=Metascore" & char(10) & char(10) & "Short synopsis: " & (IMPORTXML(Z1,"root/movie/@plot")))
70
71
72
Paste from one to another ====>#N/A
73
#N/Afor
Sun Mar 13
74
Across all meetup groups.The movie will be:
75
slumdog millionaire
76
IMDBRT CRITICRT AUDMETACRIT
77
8.4999295
78
79
80
81
old code for counting rsvp backup
82
all20 & 30 Somethings LA - Hikes, Drinks, Parties, Fun Stuff!~20's-30's YOUNG IN LA!!I'm A Cool Nerd!Los Angeles 20s & 30s- Adventures, Drinks, Friends and More!CouchsurfingHigh Value Meetups
83
#VALUE!.=(ImportXML("http://www.meetup.com/santamonicaTOhollywood/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11)'.=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11).=(ImportXML("http://www.meetup.com/culturecircle-99/","substring-before((//div[@class='docSection']//div[@class='gutter-left lastUnit' and ..//h3[contains(.,'socialize')]])[1], ' ')")-11).=iferror(ImportXML(B85,"//span[@class='rsvp-count-number rsvp-count-going']")-11,0)#VALUE!.=(ImportXML("http://www.meetup.com/High-Value-Hangouts/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'socialize')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11)
84
.=IF(ISBLANK(A81),,(HYPERLINK("http://www.omdbapi.com/?t="&A81&"&plot=short&r=xml&tomatoes=true"))).=ImportXML(G85,"//h1[@class='cs-box-title']")
85
http://www.meetup.com/LosAngeles/events/227547429/https://www.couchsurfing.com/events/let-s-watch-a-movie-play-games-and-socialize
86
backups links for carnival event
87
#VALUE!.=(ImportXML("http://www.mmmmeetup.com/santamonicaTOhollywood/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'karaoke')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-16).=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'Carnival')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11).=(ImportXML("http://www.meetup.com/culturecircle-99/","substring-before((//div[@class='docSection']//div[@class='gutter-left lastUnit' and ..//h3[contains(.,'Carnival')]])[1], ' ')")-10).=(ImportXML(B89,"//span[@class='rsvp-count-number rsvp-count-going']")-10).=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'Carnival')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11)
88
89
90
backups links for carnival event
91
#VALUE!.=(ImportXML("http://www.mmmmeetup.com/santamonicaTOhollywood/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'karaoke')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-16).=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'Carnival')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11).=(ImportXML("http://www.meetup.com/culturecircle-99/","substring-before((//div[@class='docSection']//div[@class='gutter-left lastUnit' and ..//h3[contains(.,'Carnival')]])[1], ' ')")-10).=(ImportXML(T106,"//span[@class='rsvp-count-number rsvp-count-going']")-10).=(ImportXML("http://www.meetup.com/LosAngelesCalifornia/","substring-before((//li[@itemtype='http://data-vocabulary.org/Event']//div[@class='event-meta' and ..//h3//span[contains(., 'Carnival')]]//ul//li[@class='rsvpCount event-count rsvp-meta-subtle-link small'])[1], ' ')")-11)
92
93
#ERROR!
94
95
96
97
98
99
100
Let's watch a movie, play games, and socialize.
Loading...
Main menu