Welcome to the ICM Forum.
Check out our Magazine

If you notice any issues please post in the Q&A thread. Email issue should be fixed. If you encounter this issue, contact PeacefulAnarchy
Talking Images Podcast: Episode 86 released November 15th: ICMF-FF7: Talkin' Main Slate & Highlights
iCinema Magazine: WE ARE LIVE! (We just need more content)
ICMF-FF7: Main Slate, Genre Based Minor Slates, Geographical Based Minor Slates
World Cup - Season 5: Final (Dec 3rd)
Polls: 1926 (Results), Animation (Results), India (Results), Top Ten (Dec 22nd), 1995 (Dec 27th), Italy (Dec 27th), Latin America and Caribbean (Dec 31st), Highest Rated (Jan 1st)
Challenges: Documentary, War, Iran and Central Asia
About: Welcome All New Members, Terms of Use, Q&A

iCM Forum's Highest Rated Movies: A New Beginning (next update 1 January 2024)

500<400, Favourite 1001 movies, Doubling the Canon, Film World Cup and many other votes
Post Reply
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

iCM Forum's Highest Rated Movies: A New Beginning (next update 1 January 2024)

#1

Post by mightysparks »

So the idea to refresh this project has come up a few times since themagician left the forum but it hasn't really gone anywhere. I'm keen to get it going again even if I have to do a lot of manual work but the main issue is that IMDb removed the ability to download other people's ratings. This means that everyone who wants to participate will have to download their own ratings and then send them to me.

---------------------------------
This can be done in two ways:

1) Open the ratings.csv file and copy and paste all data into a new tab into this Google sheet. Rename the tab with your username. This will be public.
2) Upload the ratings.csv file to WeTransfer, or any file sharing website that you like, and pm me with the URL. These will be kept private.

---------------------------------

The lists will be updated every 3 months: 1 Jan, 1 Apr, 1 July, 1 Oct. I will bump the thread about a week before but you can update your ratings at any time. If you post or update your ratings on the Google sheet, right click your tab name -> change colour -> choose the EIGHTH colour on the second row:
Spoiler
Image
Or post here to let me know you have updated your sheet.

Links to all iCM lists:
iCM Forum's Top 1000 Highest Rated Films and on Letterboxd
iCM Forum's Top 1001-2000 Highest Rated Films
iCM Forum's Top 250 Highest Rated Documentaries
iCM Forum's Top 250 Highest Rated Shorts
iCM Forum's Bottom 100 Lowest Rated Films
iCM Forum's Top 250 Highest Rated TV Series
iCM Forum's Top 250 Highest Rated Obscure Feature Films
iCM Forum's Highest Rated Movies: 500<400 edition
iCM Forum's Top 250 Highest Rated Films Directed By Women
--------- (thanks to xianjiro)
iCM Forum's Top 250 Highest Rated Action Movies
iCM Forum's Top 250 Highest Rated Adventure Movies
iCM Forum's Top 250 Highest Rated Animated Movies
iCM Forum's Top 250 Highest Rated Biographical Movies
iCM Forum's Top 250 Highest Rated Comedy Movies
iCM Forum's Top 250 Highest Rated Crime Movies
iCM Forum's Top 250 Highest Rated Drama Movies
iCM Forum's Top 250 Highest Rated Family Movies
iCM Forum's Top 250 Highest Rated Fantasy Movies
iCM Forum's Top 250 Highest Rated Film-Noir Movies
iCM Forum's Top 250 Highest Rated History Movies
iCM Forum's Top 250 Highest Rated Horror Movies
iCM Forum's Top 250 Highest Rated LGBTQ+ Movies
iCM Forum's Top 250 Highest Rated Music Movies
iCM Forum's Top 250 Highest Rated Musical Movies
iCM Forum's Top 250 Highest Rated Mystery Movies
iCM Forum's Top 250 Highest Rated Romance Movies
iCM Forum's Top 250 Highest Rated Sci-Fi Movies
iCM Forum's Top 250 Highest Rated Sport Movies
iCM Forum's Top 250 Highest Rated Thriller Movies
iCM Forum's Top 250 Highest Rated War Movies
iCM Forum's Top 250 Highest Rated Western Movies
---------
iCM Forum's Top 100 Highest Rated African Films
iCM Forum's Top 250 Highest Rated European Films (Excluding France)
iCM Forum's Top 250 Highest Rated Asian Films (Excluding Japan)
iCM Forum's Top 250 Highest Rated French Films
iCM Forum's Top 250 Highest Rated Japanese Films
iCM Forum's Top 100 Highest Rated Oceanic Films

Voters included (52):
Spoiler
1SO
AB537
beasterne
blueboybob
cayado-coro
ChrisReynolds
cinephage
Coryn
DudeLanez
ekremcan
Fergenaprido
filmbantha
Gordon_Gekko
Gorro
Hunziker
jeff_v
joachimt
jvv
klaus78
Kublai Khan
Lakigigar
Lammetje
Leopardi
lineuphere
magnusbernhardsen
MartinTeller
matthewscott8
maxwelldeux
melvelet
Mifune
mightysparks
monclivie
Mulholland
OldAle1
Onderhond
Opio
peeptoad
Perception de Ambiguity
pitchorneirda
PopperTheKungFu-Dragon
RogerTheMovieManiac88
sol
St. Gloede
Tasselfoot
Teproc
tommy_leazaq
Torgo
toro913
Wonderful Rainbow
xianjiro
zomgmouse
zzzorf
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
zomgmouse
Posts: 229
Joined: February 26th, 2014, 7:00 am
Contact:

#2

Post by zomgmouse »

I'd be up for this - the only thing is when would be the cutoff to submit? I'm sure I and many others would be watching a fair bit before this is calculated.
User avatar
Torgo
Posts: 8136
Joined: June 30th, 2011, 6:00 am
Location: Germany
Contact:

#3

Post by Torgo »

Regarding zomg's argument, I imagine this project makes the most sense if votes are re-sent / imported / edited every beginning of the month or with a sweet quarterly update? But most important is to get a solid core for this at first.
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#4

Post by mightysparks »

No cut-off for now. The sooner lists are submitted means I can start getting formulas and info organised so updating will be a little easier for me. Will also be a useful guide to see how many lists we'll need to get a fair representation of votes. When we have a good number of lists and things seem to be ready I'll give everyone a heads up so they can send a new file if they want.

And ye re: Torgo we can work out a schedule that works a bit later. Some people might not want to update their list super regularly so monthly may be too soon for some people. Quarterly I think would be nice but we can sort that out once we've got things rolling.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
mjf314
Moderator
Posts: 12595
Joined: May 8th, 2011, 6:00 am
Contact:

#5

Post by mjf314 »

Instead of asking people to copy/paste their ratings into a new tab, I wonder if it would be easier to have a Google Drive folder that anyone can upload files to (although I haven't done this before, so I'm not sure what options are available).
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#6

Post by mightysparks »

I was considering that as an option too but there wasn't a way to 'lock' any of the files (I don't think forum members will do anything to mess it up but if the link is public it's possible some weirdos can get in and delete stuff) and I think you have to download Dropbox and Google drive to use them and people might not want to download and learn new software.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
yllow
Posts: 1048
Joined: December 10th, 2018, 2:22 am
Contact:

#7

Post by yllow »

Interesting idea, but you’d need minimum votes I guess for ratings to apply
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#8

Post by mightysparks »

Yea the last versions had a minimum of 5 votes for most of the lists. Would like to aim for the same.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
Onderhond
Posts: 9904
Joined: December 23rd, 2012, 7:00 am
Contact:

#9

Post by Onderhond »

Just tell me where to submit and I'm in.
User avatar
cinephage
Donator
Posts: 4762
Joined: November 11th, 2011, 7:00 am
Contact:

#10

Post by cinephage »

I love the idea, and hope this will be a success. Thanks for bringing it up.
I've just pasted my export of imdb rankings in a tab named "cinephage". I'm not too familiar with googledocs, but it looks like this is working.
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#11

Post by mightysparks »

Looks good cinephage. Ondie, you can either copy the stuff from your ratings.csv into the Google sheet listed in the OP or upload the file to WeTransfer and pm it to me.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
joachimt
Donator
Posts: 36255
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#12

Post by joachimt »

I like the idea, but I think it would be a burden to you to update the ratings every month after receiving tons of file.

I think it should work better with separate files in one folder, for each member a file. Then you can give that member editing rights to his own file. In the calculation file you can import data from other files.
https://support.google.com/docs/answer/3093340?hl=nl
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Chilton
Posts: 607
Joined: January 5th, 2013, 7:00 am
Contact:

#13

Post by Chilton »

I quit IMDB a long time ago, but maybe somebody knows of an easy way of doing this via Letterboxd? I can download my ratings there but then there's no tt-code or link to IMDB obviously, which I assume is necessary to tabulate the results.
User avatar
Lakigigar
Posts: 3881
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#14

Post by Lakigigar »

I contributed, but I don't rate tv series, maybe I should do that, but it will add to even less synchronity with other movie databases.

Mightysparks, can you confirm if everything went all-right?
User avatar
Lakigigar
Posts: 3881
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#15

Post by Lakigigar »

mightysparks wrote: September 20th, 2021, 1:17 am No cut-off for now. The sooner lists are submitted means I can start getting formulas and info organised so updating will be a little easier for me. Will also be a useful guide to see how many lists we'll need to get a fair representation of votes. When we have a good number of lists and things seem to be ready I'll give everyone a heads up so they can send a new file if they want.

And ye re: Torgo we can work out a schedule that works a bit later. Some people might not want to update their list super regularly so monthly may be too soon for some people. Quarterly I think would be nice but we can sort that out once we've got things rolling.
Could you already test it out. I'm curious to what movies would be the highest rated as of now (esp. with Onderhond and my votes in :woot: ). I think the current list would be very weird.

The Green Mile has an average rating currently of 4.5/10. :P Still too high though. I didn't like it. Onderhond didn't like it. Cinewest didn't like it either.
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#16

Post by mightysparks »

Chilton wrote: September 20th, 2021, 5:13 pm I quit IMDB a long time ago, but maybe somebody knows of an easy way of doing this via Letterboxd? I can download my ratings there but then there's no tt-code or link to IMDB obviously, which I assume is necessary to tabulate the results.
I think the only way of doing this is to make an IMDb list and then copy the ratings into the file but that would take a while. Not sure of any way to convert the tmdb code to IMDb but yea I need the IMDb URL.
joachimt wrote: September 20th, 2021, 2:10 pm like the idea, but I think it would be a burden to you to update the ratings every month after receiving tons of file.

I think it should work better with separate files in one folder, for each member a file. Then you can give that member editing rights to his own file. In the calculation file you can import data from other files.
https://support.google.com/docs/answer/3093340?hl=nl
If we do it less often than monthly it won't be so bad. If most people have a tab on the Google sheet they can edit that directly and I can just get it from there.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#17

Post by mightysparks »

Lakigigar wrote: September 20th, 2021, 5:53 pm
mightysparks wrote: September 20th, 2021, 1:17 am No cut-off for now. The sooner lists are submitted means I can start getting formulas and info organised so updating will be a little easier for me. Will also be a useful guide to see how many lists we'll need to get a fair representation of votes. When we have a good number of lists and things seem to be ready I'll give everyone a heads up so they can send a new file if they want.

And ye re: Torgo we can work out a schedule that works a bit later. Some people might not want to update their list super regularly so monthly may be too soon for some people. Quarterly I think would be nice but we can sort that out once we've got things rolling.
Could you already test it out. I'm curious to what movies would be the highest rated as of now (esp. with Onderhond and my votes in :woot: ). I think the current list would be very weird.

The Green Mile has an average rating currently of 4.5/10. :P Still too high though. I didn't like it. Onderhond didn't like it. Cinewest didn't like it either.
All good Laki. I also have Torgo's ratings and I did a sample for just feature films/TV movies/video (we can decide exactly what we wanna include later) with 4/5 votes and the results can be seen in the first tab of the Google sheet.

Top 10:

1. Irréversible
2. Eraserhead
3. Fight Club
4. Sen to Chihiro no kamikakushi
5. The Thing
6. Kaguya-hime no monogatari
7. Lost Highway
8. Pulp Fiction
9. Reservoir Dogs
10. Terminator 2: Judgment Day


Definitely a genre film bias as you go down the list :turned:
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
Torgo
Posts: 8136
Joined: June 30th, 2011, 6:00 am
Location: Germany
Contact:

#18

Post by Torgo »

mightysparks wrote: September 20th, 2021, 10:59 pm Top 10:

1. Irréversible
2. Eraserhead
3. Fight Club
4. Sen to Chihiro no kamikakushi
5. The Thing
6. Kaguya-hime no monogatari
7. Lost Highway
8. Pulp Fiction
9. Reservoir Dogs
10. Terminator 2: Judgment Day
STOP THE COUNT!
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#19

Post by mightysparks »

Also made an iCM list for testing purposes. A top 500 is looking like this (all 7+ average): https://www.icheckmovies.com/lists/high ... htysparks/
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
zomgmouse
Posts: 229
Joined: February 26th, 2014, 7:00 am
Contact:

#20

Post by zomgmouse »

Just put mine in!
User avatar
RogerTheMovieManiac88
Posts: 2954
Joined: February 4th, 2017, 7:00 am
Location: Westmeath, Ireland
Contact:

#21

Post by RogerTheMovieManiac88 »

Hi there, mighty.

I'd like to do this as well, but I'm not too sure what to do.

When I click on one of the sheet options at the bottom that gives me a blank document, where on it should I enter my ratings file? Or is it done another way?
That's all, folks!
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#22

Post by mightysparks »

RogerTheMovieManiac88 wrote: September 21st, 2021, 1:01 am Hi there, mighty.

I'd like to do this as well, but I'm not too sure what to do.

When I click on one of the sheet options at the bottom that gives me a blank document, where on it should I enter my ratings file? Or is it done another way?
Select and copy everything in the ratings file and then click on the very first cell (A1) and press paste.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
maxwelldeux
Donator
Posts: 10338
Joined: June 7th, 2016, 6:00 am
Location: Spokane, WA, USA
Contact:

#23

Post by maxwelldeux »

Ratings are in here.
User avatar
RogerTheMovieManiac88
Posts: 2954
Joined: February 4th, 2017, 7:00 am
Location: Westmeath, Ireland
Contact:

#24

Post by RogerTheMovieManiac88 »

mightysparks wrote: September 21st, 2021, 2:56 am
RogerTheMovieManiac88 wrote: September 21st, 2021, 1:01 am Hi there, mighty.

I'd like to do this as well, but I'm not too sure what to do.

When I click on one of the sheet options at the bottom that gives me a blank document, where on it should I enter my ratings file? Or is it done another way?
Select and copy everything in the ratings file and then click on the very first cell (A1) and press paste.
Thanks for that. There must be some setting that isn't activated on Excel on my laptop because I get a message that copy-and-paste isn't enabled, and when I press ctrl+V it doesn't seem to work either. I'm probably copying at the wrong place. I think I'll just leave it for now. It's a bit annoying blundering around and not really knowing what I'm doing. I might take another shot at it after asking someone about it.
That's all, folks!
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#25

Post by mightysparks »

RogerTheMovieManiac88 wrote: September 21st, 2021, 6:01 am
mightysparks wrote: September 21st, 2021, 2:56 am
RogerTheMovieManiac88 wrote: September 21st, 2021, 1:01 am Hi there, mighty.

I'd like to do this as well, but I'm not too sure what to do.

When I click on one of the sheet options at the bottom that gives me a blank document, where on it should I enter my ratings file? Or is it done another way?
Select and copy everything in the ratings file and then click on the very first cell (A1) and press paste.
Thanks for that. There must be some setting that isn't activated on Excel on my laptop because I get a message that copy-and-paste isn't enabled, and when I press ctrl+V it doesn't seem to work either. I'm probably copying at the wrong place. I think I'll just leave it for now. It's a bit annoying blundering around and not really knowing what I'm doing. I might take another shot at it after asking someone about it.
Yeah copy-and-paste through the mouse doesn't work on Google sheets for some reason but idk why ctrl+v wouldn't work. Not sure if you're able to access the import option on Google sheets, but if so you click File -> import -> upload -> select file -> accept the default settings and click ok.

You could also try uploading to WeTransfer: https://wetransfer.com/. If you click the ... and change to 'get transfer' link you don't have to fill out any of the details or sign in, then just select the file, upload and pm me the link.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
filmbantha
Posts: 1062
Joined: July 10th, 2013, 6:00 am
Contact:

#26

Post by filmbantha »

Thanks for organising mighty! I've added my ratings to the tab.
User avatar
Teproc
Posts: 1547
Joined: September 23rd, 2015, 6:00 am
Contact:

#27

Post by Teproc »

Seems fun. I've added my ratings as well.
User avatar
RogerTheMovieManiac88
Posts: 2954
Joined: February 4th, 2017, 7:00 am
Location: Westmeath, Ireland
Contact:

#28

Post by RogerTheMovieManiac88 »

mightysparks wrote: September 21st, 2021, 6:33 am
RogerTheMovieManiac88 wrote: September 21st, 2021, 6:01 am
mightysparks wrote: September 21st, 2021, 2:56 am

Select and copy everything in the ratings file and then click on the very first cell (A1) and press paste.
Thanks for that. There must be some setting that isn't activated on Excel on my laptop because I get a message that copy-and-paste isn't enabled, and when I press ctrl+V it doesn't seem to work either. I'm probably copying at the wrong place. I think I'll just leave it for now. It's a bit annoying blundering around and not really knowing what I'm doing. I might take another shot at it after asking someone about it.
Yeah copy-and-paste through the mouse doesn't work on Google sheets for some reason but idk why ctrl+v wouldn't work. Not sure if you're able to access the import option on Google sheets, but if so you click File -> import -> upload -> select file -> accept the default settings and click ok.

You could also try uploading to WeTransfer: https://wetransfer.com/. If you click the ... and change to 'get transfer' link you don't have to fill out any of the details or sign in, then just select the file, upload and pm me the link.
I've sent you a PM with the WeTransfer link. I hope that that'll work.

Cheers for the help. I'm looking forward to seeing how this fun project shapes up.
That's all, folks!
tommy_leazaq
Donator
Posts: 3776
Joined: May 18th, 2011, 6:00 am
Location: Chennai, India
Contact:

#29

Post by tommy_leazaq »

Always a fan of this project from the beginning. But right now, I had stopped rating and checking temporarily. Need to restart that to get my rating up to date. Good to know that theres no deadline of sorts. So. will share my rating after I get them up to date.
User avatar
joachimt
Donator
Posts: 36255
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#30

Post by joachimt »

Torgo wrote: September 20th, 2021, 11:10 pm
mightysparks wrote: September 20th, 2021, 10:59 pm Top 10:

1. Irréversible
2. Eraserhead
3. Fight Club
4. Sen to Chihiro no kamikakushi
5. The Thing
6. Kaguya-hime no monogatari
7. Lost Highway
8. Pulp Fiction
9. Reservoir Dogs
10. Terminator 2: Judgment Day
STOP THE COUNT!
Irréversible at #1. I really need to get my ratings in quickly!! :verymad:
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
joachimt
Donator
Posts: 36255
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#31

Post by joachimt »

I've sent my ratings by PM. Google Sheets keeps freezing when I try to paste.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
beasterne
Posts: 1680
Joined: May 22nd, 2013, 6:00 am
Contact:

#32

Post by beasterne »

Woohoo, glad this is getting off the ground! thank you mighty for pushing it forward.

I added my ratings to a new tab. Everything looks okay to me, but please let me know if I messed something up.
User avatar
Onderhond
Posts: 9904
Joined: December 23rd, 2012, 7:00 am
Contact:

#33

Post by Onderhond »

Poor Lammetje.
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#34

Post by mightysparks »

joachimt wrote: September 21st, 2021, 11:24 am I've sent my ratings by PM. Google Sheets keeps freezing when I try to paste.
Did you send it through the forum? I don’t have any pms from you :shrug:
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
User avatar
Gorro
Donator
Posts: 730
Joined: August 28th, 2011, 6:00 am
Contact:

#35

Post by Gorro »

Added my ratings as well.
jeff_v
Posts: 1226
Joined: May 9th, 2011, 6:00 am
Location: Another Place
Contact:

#36

Post by jeff_v »

Added my ratings as well... thanks!
User avatar
joachimt
Donator
Posts: 36255
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#37

Post by joachimt »

mightysparks wrote: September 21st, 2021, 1:57 pm
joachimt wrote: September 21st, 2021, 11:24 am I've sent my ratings by PM. Google Sheets keeps freezing when I try to paste.
Did you send it through the forum? I don’t have any pms from you :shrug:
I just tried again.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
xianjiro
Donator
Posts: 11857
Joined: June 17th, 2015, 6:00 am
Location: Kakistani Left Coast
Contact:

#38

Post by xianjiro »

mightysparks wrote: September 20th, 2021, 10:46 pm
Chilton wrote: September 20th, 2021, 5:13 pm I quit IMDB a long time ago, but maybe somebody knows of an easy way of doing this via Letterboxd? I can download my ratings there but then there's no tt-code or link to IMDB obviously, which I assume is necessary to tabulate the results.
I think the only way of doing this is to make an IMDb list and then copy the ratings into the file but that would take a while. Not sure of any way to convert the tmdb code to IMDb but yea I need the IMDb URL.
joachimt wrote: September 20th, 2021, 2:10 pm like the idea, but I think it would be a burden to you to update the ratings every month after receiving tons of file.

I think it should work better with separate files in one folder, for each member a file. Then you can give that member editing rights to his own file. In the calculation file you can import data from other files.
https://support.google.com/docs/answer/3093340?hl=nl
If we do it less often than monthly it won't be so bad. If most people have a tab on the Google sheet they can edit that directly and I can just get it from there.
does anyone know the upper limit on a Google Sheet or workbook?
User avatar
Hunziker
Donator
Posts: 1531
Joined: November 3rd, 2014, 7:00 am
Location: France
Contact:

#39

Post by Hunziker »

Just added mine. Thanks, mighty.
iCM #pure stroboscope experimentalism
User avatar
mightysparks
Site Admin
Posts: 32870
Joined: May 5th, 2011, 6:00 am
Location: Perth, WA, Australia
Contact:

#40

Post by mightysparks »

xianjiro wrote: September 21st, 2021, 8:43 pm
mightysparks wrote: September 20th, 2021, 10:46 pm
Chilton wrote: September 20th, 2021, 5:13 pm I quit IMDB a long time ago, but maybe somebody knows of an easy way of doing this via Letterboxd? I can download my ratings there but then there's no tt-code or link to IMDB obviously, which I assume is necessary to tabulate the results.
I think the only way of doing this is to make an IMDb list and then copy the ratings into the file but that would take a while. Not sure of any way to convert the tmdb code to IMDb but yea I need the IMDb URL.
joachimt wrote: September 20th, 2021, 2:10 pm like the idea, but I think it would be a burden to you to update the ratings every month after receiving tons of file.

I think it should work better with separate files in one folder, for each member a file. Then you can give that member editing rights to his own file. In the calculation file you can import data from other files.
https://support.google.com/docs/answer/3093340?hl=nl
If we do it less often than monthly it won't be so bad. If most people have a tab on the Google sheet they can edit that directly and I can just get it from there.
does anyone know the upper limit on a Google Sheet or workbook?
Had a quick Google and doesn’t seem like there’ll be a problem. I’m keeping the main calculations in an already very big and laggy spreadsheet to keep the Google sheet as small and smooth as possible.
"I do not always know what I want, but I do know what I don't want." - Stanley Kubrick

iCM | Letterboxd | Linktree | TSZDT

Image
Post Reply