Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: Coming of Age (Results), DtC - Ratings (Results), 1933 (May 12th), 1970s (May 29th)
Challenges: Japan, Mystery/Thriller, Western
Film of the Week: Akage, June nominations (May 28th)

iCM Forum's Favourite Movies of the 1970s: Results

500<400, Favourite 1001 movies, Doubling the Canon, Film World Cup and many other votes
Post Reply
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

iCM Forum's Favourite Movies of the 1970s: Results

#1

Post by Lonewolf2003 »

iCM Forum's Favourite Movies of the 1970s
Image
The 1970s were a decade in the last century. A lot of stuff happened then. There were wars, elections, uprisings, crises and scandals. People were born and died. Sport matches were won and lost. Things were invented. Trends came and went. This is a lists of our favorites movies made during that decade.
Thanks to the following 60 voters
Nomination thread
Half-life was 50.

Can you dig it?
Last edited by Lonewolf2003 on October 31st, 2015, 11:00 am, edited 1 time in total.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#2

Post by Lonewolf2003 »

Last edited by Lonewolf2003 on November 6th, 2015, 12:02 am, edited 1 time in total.
Local Hero -- aka MestnyiGeroi
Posts: 11744
Joined: May 29th, 2011, 6:00 am
Contact:

#3

Post by Local Hero -- aka MestnyiGeroi »

I like your description of the 70s. Really captured the zeitgeist.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#4

Post by Lonewolf2003 »

I will post some runners up now first. Tomorrow the real list will start.
User avatar
Pretentious Hipster
Donator
Posts: 21255
Joined: October 24th, 2011, 6:00 am
Contact:

#5

Post by Pretentious Hipster »

Decided to only put my favourites in my list, as opposed to that and my 7/10s. I'm curious to see what will happen.
My father didn’t have the skill of a professional cameraman. The result? Avant-garde cinema.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#6

Post by Lonewolf2003 »

First off I'm going to disappoint a few people.

#1's that didn't made the list:


#559 Stridulum () (Michael J. Paradise, 1979), 100 points, 1 votes, 138 checks (IMDb)
1 voters
TraverseTown (#1)
#414 Sholay (Embers) (Ramesh Sippy, 1975), 156,44 points, 3 votes, 1408 checks (IMDb)
3 voters
gremlo (#115)
Smoover (#75)
sushantv10 (#1)
#336 La région centrale () (Michael Snow, 1971), 202,16 points, 3 votes, 166 checks (IMDb)
3 voters
Brokenface (#242)
Dolwphin (#1)
perceval (#2)
#322 The Poseidon Adventure () (Ronald Neame, 1972), 215,92 points, 4 votes, 4605 checks (IMDb)
4 voters
Brokenface (#226)
MNA (#1)
paul281f (#31)
VincentPrice (unranked)
#292 Tôkyô sensô sengo hiwa (The Man Who Left His Will on Film) (Nagisa Ôshima, 1970), 248,65 points, 4 votes, 93 checks (IMDb)
4 voters
Ebbywebby (#131)
Melvelet (#27)
Perception de Ambiguity (#1)
perceval (#35)
Kasparius
Posts: 24613
Joined: September 14th, 2011, 6:00 am
Contact:

#7

Post by Kasparius »

Ettinauer226XL on Oct 29 2015, 06:15:16 PM wrote:Decided to only put my favourites in my list, as opposed to that and my 7/10s. I'm curious to see what will happen.
You will change your avatar to 70's Alain Delon?

*crossing my fingers*
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#8

Post by Lonewolf2003 »

#260 Ziemia obiecana (Land of Promise) (Andrzej Wajda, 1975), 282,82 points, 6 votes, 173 checks (IMDb)
6 voters
bobbybrown (#26)
Brokenface (#194)
gremlo (#26)
jeff_v (#64)
joachimt (unranked)
kingink (#93)
#259 Avanti! () (Billy Wilder, 1972), 285,23 points, 9 votes, 857 checks (IMDb)
9 voters
afirm (#41)
bal3x (#103)
jeff_v (#142)
Kasparius (#145)
metaller (#65)
Perception de Ambiguity (#135)
sushantv10 (#44)
toro91 (#120)
zomgmouse (unranked)
#258 Vamos a matar, compañeros (Companeros) (Sergio Corbucci, 1970), 285,49 points, 7 votes, 483 checks (IMDb)
7 voters
afirm (#21)
Brokenface (#127)
Kasparius (#59)
Perception de Ambiguity (#275)
sushantv10 (#149)
timmy_501 (#21)
Veterini (#42)
#257 Die große Ekstase des Bildschnitzers Steiner (The Great Ecstasy of Woodcarver Steiner) (Werner Herzog, 1974), 286,17 points, 11 votes, 497 checks (IMDb)
11 voters
bal3x (#176)
Brokenface (#205)
Carmel98 (#126)
Kasparius (#173)
Leopardi (#137)
mathiasa (#34)
PeacefulAnarchy (#87)
perceval (#93)
Rad82 (#43)
sebby (#65)
sushantv10 (#162)
#256 Jui kuen (Drunken Master) (Woo-Ping Yuen, 1978), 287,36 points, 6 votes, 1700 checks (IMDb)
6 voters
gremlo (#88)
jvv (#4)
Lonewolf2003 (#54)
mjf314 (#74)
MNA (#82)
zomgmouse (unranked)
User avatar
Pretentious Hipster
Donator
Posts: 21255
Joined: October 24th, 2011, 6:00 am
Contact:

#9

Post by Pretentious Hipster »

Kasparius on Oct 29 2015, 06:26:04 PM wrote:
Ettinauer226XL on Oct 29 2015, 06:15:16 PM wrote:Decided to only put my favourites in my list, as opposed to that and my 7/10s. I'm curious to see what will happen.
You will change your avatar to 70's Alain Delon?

*crossing my fingers*
Wow someone hates my avatar set. To make you feel better it'll probably stay like this for at least the next few months :)
My father didn’t have the skill of a professional cameraman. The result? Avant-garde cinema.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#10

Post by Lonewolf2003 »

#255 The Andromeda Strain () (Robert Wise, 1971), 287,88 points, 7 votes, 3160 checks (IMDb)
7 voters
bal3x (#137)
metaller (#32)
mightysparks (#52)
Perception de Ambiguity (#66)
sushantv10 (#108)
timmy_501 (#25)
toro91 (#106)
#254 Farewell, My Lovely () (Dick Richards, 1975), 289,72 points, 6 votes, 322 checks (IMDb)
6 voters
Brokenface (#250)
Leopardi (#52)
mathiasa (#55)
Perception de Ambiguity (#24)
Rad82 (#61)
timmy_501 (#23)
#253 Warum läuft Herr R. Amok (Why Does Herr R. Run Amok?) (Michael Fengler, Rainer Werner Fassbinder, 1970), 290,84 points, 7 votes, 250 checks (IMDb)
7 voters
bobbybrown (#28)
jeff_v (#194)
Melvelet (#46)
MNA (#57)
Perception de Ambiguity (#168)
TraverseTown (#47)
zuma (#47)
#252 Zorns Lemma () (Hollis Frampton, 1970), 292,22 points, 4 votes, 419 checks (IMDb)
4 voters
Dolwphin (#6)
Ettinauer226XL (#10)
Jay Mars (#133)
perceval (#5)
#251 Domicile conjugal (Bed & Board) (François Truffaut, 1970), 293,04 points, 8 votes, 1039 checks (IMDb)
8 voters
allisoncm (#79)
Brokenface (#156)
kingink (#160)
Leopardi (#128)
sushantv10 (#65)
toro91 (#37)
Veterini (#24)
zomgmouse (unranked)
Last edited by Lonewolf2003 on October 30th, 2015, 12:35 am, edited 1 time in total.
User avatar
Pretentious Hipster
Donator
Posts: 21255
Joined: October 24th, 2011, 6:00 am
Contact:

#11

Post by Pretentious Hipster »

Lonewolf2003 on Oct 29 2015, 06:33:18 PM wrote:#252 Zorns Lemma () (Hollis Frampton, 1970), 292,22 points, 4 votes, 419 checks (IMDb)
4 voters
Dolwphin (#6)
Ettinauer226XL (#10)
Jay Mars (#133)
perceval (#5)
Is this karma because I won't change my avatar set? :'(
My father didn’t have the skill of a professional cameraman. The result? Avant-garde cinema.
User avatar
zuma
Donator
Posts: 2227
Joined: June 14th, 2011, 6:00 am
Location: Ottawa, Canada
Contact:

#12

Post by zuma »

Lonewolf2003 on Oct 29 2015, 06:33:18 PM wrote: #253 Warum läuft Herr R. Amok (Why Does Herr R. Run Amok?) (Michael Fengler, Rainer Werner Fassbinder, 1970), 290,84 points, 7 votes, 250 checks (IMDb)
7 voters
bobbybrown (#28)
jeff_v (#194)
Melvelet (#46)
MNA (#57)
Perception de Ambiguity (#168)
TraverseTown (#47)
zuma (#47)
I blame Kas.
mjf314
Moderator
Posts: 11900
Joined: May 8th, 2011, 6:00 am
Contact:

#13

Post by mjf314 »

Lonewolf2003 on Oct 29 2015, 06:23:45 PM wrote:#559 Stridulum () (Michael J. Paradise, 1979), 100 points, 1 votes, 138 checks (IMDb)
You might want to edit your Excel formula to hide the () when there's no aka title.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#14

Post by Lonewolf2003 »

mjf314 on Oct 29 2015, 07:10:23 PM wrote:
Lonewolf2003 on Oct 29 2015, 06:23:45 PM wrote:#559 Stridulum () (Michael J. Paradise, 1979), 100 points, 1 votes, 138 checks (IMDb)
You might want to edit your Excel formula to hide the () when there's no aka title.
How do I do that? I'm not that good woth Excel. ;)
Kasparius
Posts: 24613
Joined: September 14th, 2011, 6:00 am
Contact:

#15

Post by Kasparius »

zuma on Oct 29 2015, 06:43:41 PM wrote:
Lonewolf2003 on Oct 29 2015, 06:33:18 PM wrote: #253 Warum läuft Herr R. Amok (Why Does Herr R. Run Amok?) (Michael Fengler, Rainer Werner Fassbinder, 1970), 290,84 points, 7 votes, 250 checks (IMDb)
7 voters
bobbybrown (#28)
jeff_v (#194)
Melvelet (#46)
MNA (#57)
Perception de Ambiguity (#168)
TraverseTown (#47)
zuma (#47)
I blame Kas.
Blame the proletariat who didn't pick it to be one of the 5 I watched before the deadline.
Kasparius
Posts: 24613
Joined: September 14th, 2011, 6:00 am
Contact:

#16

Post by Kasparius »

Is this a top 250, 200, 100? What?
mjf314
Moderator
Posts: 11900
Joined: May 8th, 2011, 6:00 am
Contact:

#17

Post by mjf314 »

Lonewolf2003 on Oct 29 2015, 07:18:27 PM wrote:
mjf314 on Oct 29 2015, 07:10:23 PM wrote:
Lonewolf2003 on Oct 29 2015, 06:23:45 PM wrote:#559 Stridulum () (Michael J. Paradise, 1979), 100 points, 1 votes, 138 checks (IMDb)
You might want to edit your Excel formula to hide the () when there's no aka title.
How do I do that? I'm not that good woth Excel. ;)
Use the IF function to display one of two possible strings (depending on whether the condition is true or false). To test if a cell is empty, compare it to "", for example if the aka title is in cell G1, then somewhere in the middle of your formula it would say something like

IF(G1="","","("&G1&") ")
User avatar
Cocoa
Donator
Posts: 2000
Joined: July 17th, 2013, 6:00 am
Location: Chicago, USA
Contact:

#18

Post by Cocoa »

My list isn't included.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#19

Post by Lonewolf2003 »

Cocoa on Oct 30 2015, 12:31:01 AM wrote:My list isn't included.
Sorry, I missed it. But you could have also controlled it yourself sooner. This means I will have to recalculate the results. Which I can't do till tonight, cause I'm at work now.

Please everybody check the OP in nominations threads to be sure there are no mistakes.
Last edited by Lonewolf2003 on October 30th, 2015, 10:19 am, edited 1 time in total.
Rad82
Posts: 643
Joined: February 11th, 2014, 7:00 am
Location: Dark City
Contact:

#20

Post by Rad82 »

I liked the decade description as well, though you could also mention it as the main hippy era in your initial post I suppose, since it's literally the hippies/"drugs became more popular than ever" decade. Man seemed to want more than ever to live freely without constraints and this definitely showed in most parts of the world. At least that's my take on it. xD

PS : Hurray for the Herzog documentary that already appeared on the list, I loved it. xD
Last edited by Rad82 on October 30th, 2015, 11:13 am, edited 1 time in total.
User avatar
joachimt
Donator
Posts: 33886
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#21

Post by joachimt »

Rad82 on Oct 30 2015, 05:11:30 AM wrote:PS : Hurray for the Herzog documentary that already appeared on the list, I loved it. xD
It didn't appear on the list. It just missed out. THE list will be top 250.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#22

Post by Lonewolf2003 »

mjf314 on Oct 29 2015, 07:33:01 PM wrote:
Lonewolf2003 on Oct 29 2015, 07:18:27 PM wrote:
mjf314 on Oct 29 2015, 07:10:23 PM wrote:You might want to edit your Excel formula to hide the () when there's no aka title.
How do I do that? I'm not that good woth Excel. ;)
Use the IF function to display one of two possible strings (depending on whether the condition is true or false). To test if a cell is empty, compare it to "", for example if the aka title is in cell G1, then somewhere in the middle of your formula it would say something like

IF(G1="","","("&G1&") ")
After a lot of experimenting I did it. :banana:
#251 Domicile conjugal (Bed & Board) (François Truffaut, 1970), 293,04 points, 8 votes, 1039 checks (IMDb)
#252 Zorns Lemma (Hollis Frampton, 1970), 292,22 points, 4 votes, 419 checks (IMDb)
Rad82
Posts: 643
Joined: February 11th, 2014, 7:00 am
Location: Dark City
Contact:

#23

Post by Rad82 »

joachimt on Oct 30 2015, 05:15:53 AM wrote:
Rad82 on Oct 30 2015, 05:11:30 AM wrote:PS : Hurray for the Herzog documentary that already appeared on the list, I loved it. xD
It didn't appear on the list. It just missed out. THE list will be top 250.
Daaaaaaaamn. :(
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#24

Post by Lonewolf2003 »

Lonewolf2003 on Oct 30 2015, 04:16:47 AM wrote:
Cocoa on Oct 30 2015, 12:31:01 AM wrote:My list isn't included.
Sorry, I missed it. But you could have also controlled it yourself sooner. This means I will have to recalculate the results. Which I can't do till tonight, cause I'm at work now.

Please everybody check the OP in nominations threads to be sure there are no mistakes.
Since I will be recalculating the result anyhow, maybe Jay Mars wants to replace the 1922 Nosferatu in his list with the Herzog version? ;)
Rad82
Posts: 643
Joined: February 11th, 2014, 7:00 am
Location: Dark City
Contact:

#25

Post by Rad82 »

Lonewolf2003 on Oct 30 2015, 05:37:12 AM wrote:
Lonewolf2003 on Oct 30 2015, 04:16:47 AM wrote:
Cocoa on Oct 30 2015, 12:31:01 AM wrote:My list isn't included.
Sorry, I missed it. But you could have also controlled it yourself sooner. This means I will have to recalculate the results. Which I can't do till tonight, cause I'm at work now.

Please everybody check the OP in nominations threads to be sure there are no mistakes.
Since I will be recalculating the result anyhow, maybe Jay Mars wants to replace the 1922 Nosferatu in his list with the Herzog version? ;)
Why replace? :O Both films are amazing .
I always include both in my lists, but I still value the silent one a bit higher, since it's much harder to attain that atmosphere without speech. A great leap in cinema for it's time that God knows how many filmmakers were inspired by it.
Last edited by Rad82 on October 30th, 2015, 11:40 am, edited 1 time in total.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#26

Post by Lonewolf2003 »

Rad82 on Oct 30 2015, 05:39:11 AM wrote:
Lonewolf2003 on Oct 30 2015, 05:37:12 AM wrote:
Lonewolf2003 on Oct 30 2015, 04:16:47 AM wrote:Sorry, I missed it. But you could have also controlled it yourself sooner. This means I will have to recalculate the results. Which I can't do till tonight, cause I'm at work now.

Please everybody check the OP in nominations threads to be sure there are no mistakes.
Since I will be recalculating the result anyhow, maybe Jay Mars wants to replace the 1922 Nosferatu in his list with the Herzog version? ;)
Why replace? :O Both films are amazing .
I always include both in my lists, but I still value the silent one a bit higher, since it's much harder to attain that atmosphere without speech. A great leap in cinema for it's time that God knows how many filmmakers were inspired by it.
Maybe because this is a list of our favorite movies of the 70s and not our all time?

So I assume Jay added the wrong version to his list by mistake and not making a statement about how a rerelease of the Murnau version should be included in the 1970s list (if there was a rerelease in the 1970s)
Last edited by Lonewolf2003 on October 30th, 2015, 11:55 am, edited 1 time in total.
Rad82
Posts: 643
Joined: February 11th, 2014, 7:00 am
Location: Dark City
Contact:

#27

Post by Rad82 »

Damn it you are right ofc.. :P
It's like I'm on a constant "Altered States" state... Saw it yesterday amazing psychedelic film btw.
Last edited by Rad82 on October 30th, 2015, 12:57 pm, edited 1 time in total.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#28

Post by Lonewolf2003 »

Lonewolf2003 on Oct 30 2015, 05:51:27 AM wrote:
Rad82 on Oct 30 2015, 05:39:11 AM wrote:
Lonewolf2003 on Oct 30 2015, 05:37:12 AM wrote:Since I will be recalculating the result anyhow, maybe Jay Mars wants to replace the 1922 Nosferatu in his list with the Herzog version? ;)
Why replace? :O Both films are amazing .
I always include both in my lists, but I still value the silent one a bit higher, since it's much harder to attain that atmosphere without speech. A great leap in cinema for it's time that God knows how many filmmakers were inspired by it.
Maybe because this is a list of our favorite movies of the 70s and not our all time?

So I assume Jay added the wrong version to his list by mistake and not making a statement about how a rerelease of the Murnau version should be included in the 1970s list (if there was a rerelease in the 1970s)
Do you guys feel I should replace Jay Mars Nosferatu on his list, when he doesn't respond before tonight, since it's highly probably a mistake? On the other hand I don't feel like I should be messing with people's lists.
Last edited by Lonewolf2003 on October 30th, 2015, 3:25 pm, edited 1 time in total.
User avatar
joachimt
Donator
Posts: 33886
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#29

Post by joachimt »

Do it
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Caracortada
Posts: 744
Joined: November 21st, 2014, 7:00 am
Contact:

#30

Post by Caracortada »

Local Hero -- aka MestnyiGeroi on Oct 29 2015, 06:12:55 PM wrote:I like your description of the 70s. Really captured the zeitgeist.
The handy thing is that he can reuse it for the 60s, 80s and any decade of the 20th century.
Three ingredients of all good stories are humor, suspense and psychology.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#31

Post by Lonewolf2003 »

Caracortada on Oct 30 2015, 09:30:45 AM wrote:
Local Hero -- aka MestnyiGeroi on Oct 29 2015, 06:12:55 PM wrote:I like your description of the 70s. Really captured the zeitgeist.
The handy thing is that he can reuse it for the 60s, 80s and any decade of the 20th century.
You're on to me :whistling:
Local Hero -- aka MestnyiGeroi
Posts: 11744
Joined: May 29th, 2011, 6:00 am
Contact:

#32

Post by Local Hero -- aka MestnyiGeroi »

Rad82 on Oct 30 2015, 05:11:30 AM wrote:I liked the decade description as well, though you could also mention it as the main hippy era in your initial post I suppose, since it's literally the hippies/"drugs became more popular than ever" decade. Man seemed to want more than ever to live freely without constraints and this definitely showed in most parts of the world. At least that's my take on it. xD
If that's your suggestion, I don't think you quite got the humor of the description.
Kasparius
Posts: 24613
Joined: September 14th, 2011, 6:00 am
Contact:

#33

Post by Kasparius »

Local Hero -- aka MestnyiGeroi on Oct 30 2015, 10:08:34 AM wrote:
Rad82 on Oct 30 2015, 05:11:30 AM wrote:I liked the decade description as well, though you could also mention it as the main hippy era in your initial post I suppose, since it's literally the hippies/"drugs became more popular than ever" decade. Man seemed to want more than ever to live freely without constraints and this definitely showed in most parts of the world. At least that's my take on it. xD
If that's your suggestion, I don't think you quite got the humor of the description.
On top of that, the hippies were actually way more of a sixties thing. The seventies was the decade of disillusion with the hippie dream.
Rad82
Posts: 643
Joined: February 11th, 2014, 7:00 am
Location: Dark City
Contact:

#34

Post by Rad82 »

Yes it's filled with irony but still. :)
Indeed they did start on the mid-sixties or something, but 70s were filled with them right from the beginning. I agree about the disillusionment part of course.
Last edited by Rad82 on October 31st, 2015, 1:43 pm, edited 1 time in total.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#35

Post by Lonewolf2003 »

After recalculating the results and getting a new filmcount.csv what is the best way to add the columns with points, voters, imdb url and voters from that file into my existing results Excelsheet, but so that the columns correspond to the right title, year, director and so on? So I don't have to import export everything again to imdb and icheckmovies to get the titles and so on again in the correct order.
mjf314
Moderator
Posts: 11900
Joined: May 8th, 2011, 6:00 am
Contact:

#36

Post by mjf314 »

Lonewolf2003 on Oct 30 2015, 12:06:31 PM wrote:After recalculating the results and getting a new filmcount.csv what is the best way to add the columns with points, voters, imdb url and voters from that file into my existing results Excelsheet, but so that the columns correspond to the right title, year, director and so on? So I don't have to import export everything again to imdb and icheckmovies to get the titles and so on again in the correct order.
You could use VLOOKUPs, but adding the lists to iCM and IMDb again might be easier, especially since you'll have to do that anyway.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#37

Post by Lonewolf2003 »

mjf314 on Oct 30 2015, 01:16:40 PM wrote:
Lonewolf2003 on Oct 30 2015, 12:06:31 PM wrote:After recalculating the results and getting a new filmcount.csv what is the best way to add the columns with points, voters, imdb url and voters from that file into my existing results Excelsheet, but so that the columns correspond to the right title, year, director and so on? So I don't have to import export everything again to imdb and icheckmovies to get the titles and so on again in the correct order.
You could use VLOOKUPs, but adding the lists to iCM and IMDb again might be easier, especially since you'll have to do that anyway.
Lol. You are right about that.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#38

Post by Lonewolf2003 »

But al lot of image urls are in the wrong cells now. There should be an easy way to automatically correct that instead of going through them all manually.

(I have two excelsheets now one with the previous results and one with the new results)
Last edited by Lonewolf2003 on October 30th, 2015, 10:21 pm, edited 1 time in total.
User avatar
Pretentious Hipster
Donator
Posts: 21255
Joined: October 24th, 2011, 6:00 am
Contact:

#39

Post by Pretentious Hipster »

How are your images uploaded? I have them like "ttsomenumbers".jpg. If it's like that then there's a very easy to fix them with excel.
My father didn’t have the skill of a professional cameraman. The result? Avant-garde cinema.
User avatar
Lonewolf2003
Donator
Posts: 11365
Joined: December 29th, 2012, 7:00 am
Contact:

#40

Post by Lonewolf2003 »

Ettinauer226XL on Oct 30 2015, 04:23:07 PM wrote:How are your images uploaded? I have them like "ttsomenumbers".jpg. If it's like that then there's a very easy to fix them with excel.
The images are uploaded with i.imgur.com/letternumbercombo
Post Reply