All official checks filtering question.

[Mochard]

I am trying to list all official checks and then filter / sort them by runtimes but I can't seem to find a way! Is it even possible to filter by runtime? I can't seem to find a way that works.

The only thing I can think of doing is to export every list then remove duplicates and then I can sort by runtime.

If this is the only way then I'm asking if anyone happens to have already created a spreadsheet with all official checks on it that they are willing to share?

Or if anyone knows of something I am missing? It would be nice if rather than seeing all movies - you see all official movies as an option then you can sort by runtimes etc.

Exporting the lists doesn't show runtimes so that's out! Maybe an imdb list exists as that would have runtimes on if exported.

Thanks

[maxwelldeux]

What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes

If you're looking for longs, I don't have that at my fingertips.

But more generally (and I'm speaking from memory, so forgive me if I'm wrong on details), there's no way to filter only official checks, and it's not possible to export ICM search results. Also, ICM has a list limit of 5000 titles, and there are ~17000+ official checks.

But in this respect, Tim2460 is your best friend:
Films on 3+ Official lists
Films on 2 Official lists
Films on 1 Official list p1
Films on 1 Official list p2

That distills all official checks down to four lists (data are updated monthly). If you want to do more from there, that's on you.

[Tim2460]

Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ

[Mochard]

Thank you guys so much.

Yeah i was fine for shorts - oh I didn't see mjf's short features though - thats cool.

Tim - I can't download your link atm as I'm at work (I shouldn't really be on this forum either but whatever!) but thank-you again. I really appreciate it. I'll grab it on my lunch.

[Mochard]

Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ

Just downloaded it - it's perfect - just what I was looking for

Thanks

[maxwelldeux]

Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ

Just downloaded it - it's perfect - just what I was looking for

Thanks

Hot diggity damn... that's even better than I expected. Thanks for sharing!

[blueboybob]

There is also a less up to date 80 minutes list https://www.icheckmovies.com/lists/offi ... adatriste/

[Ebbywebby]

What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes

I didn't see mjf's short features though - thats cool.

It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.

I'm your best friend too.

[maxwelldeux]

What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes

I didn't see mjf's short features though - thats cool.

It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.

I'm your best friend too.

Best friends all around!

But yeah - thanks for putting that together!

[joachimt]

Indeed. EbbyWebby keeps track of 46 to 69 minutes, but I update the list.
I keep track of 45 minutes and less, but mjf314 updates the list.
It's confusing, I know, but we're all best friends indeed.

[Tim2460]

Glad the excel is usefull !

[Ebbywebby]

Indeed. EbbyWebby keeps track of 46 to 69 minutes, but I update the list.
I keep track of 45 minutes and less, but mjf314 updates the list.

So now I need to find some underappreciated newbie to mentor and host a list for.

[Coryn]

Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ

[Onderhond]

Wondering about a different filter myself:
Is there an easy way to see which animes are official? I've already finished the Paste list, but I'm sure there are some official checks on other lists. All bright ideas are welcome

[blueboybob]

Closest you'll get is "animation" https://www.icheckmovies.com/movies/?ta ... Aanimation

[Onderhond]

Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!

[Fergenaprido]

Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!

Actually, it's probably better to use the Beta version for this task, since genre tags stopped being added to films in the current version a few years ago, so any film recently imported to icm would not show up in that list. Try this: https://beta.icheckmovies.com/movies/un ... Aanimation

[Onderhond]

Good enough, only 9 pages of unchecked animation films, should be easy enough from there on. Thanks for the tip!

Actually, it's probably better to use the Beta version for this task, since genre tags stopped being added to films in the current version a few years ago, so any film recently imported to icm would not show up in that list. Try this: https://beta.icheckmovies.com/movies/un ... Aanimation

Sounds promising, but the beta.icheckmovies pages never load for me.

[Fergenaprido]

Strange. Well, I can't help you much there, then. I just checked manually, and it seems there are only 3 official animes from 2016 onwards that aren't on the Paste list, and I suspect you've already seen them or are aware of them:
https://www.icheckmovies.com/movies/kon ... i+ni-2016/
https://www.icheckmovies.com/movies/yor ... +yo+otome/
https://www.icheckmovies.com/movies/tenki+no+ko/

There's also this list I found which may help guide you: https://www.icheckmovies.com/lists/500+ ... altoplists

[Onderhond]

There's also this list I found which may help guide you: https://www.icheckmovies.com/lists/500+ ... altoplists

Based on that one, I'm missing 3 official films. One of the wrong Harmageddon though (it lists a Finnish film), the other one is a Pokémon film and the final one Urotsukidoji ... I've seen that one before I started rating films, not sure if I should revisit.

Thanks for the tip though, handy list

[Torgo]

I see some of you guys are maniacs experts. That's great! I'd like to ask for one crazy, yet obvious fact - the ultimate goal of every ICM user, the final task:

What is the actual added runtime of every official check on ICM?

Maybe that's a quick stat you just have lying around with all your Excels. Maybe not - I wouldn't want to trouble anyone.

If it's easily accessible, perhaps you can also give an overall value with and without extreme outliers. Because I assume there are more cases like The Wire or that Baseball series in our recent <400 poll; the former is quite extreme in its length of approximately 60 hours compared to our standard films or even exotic filmmakers with enormously long features. Or Empire and all that.

Come to think of it, It's actually a fun game: Give your best estimate what all movies on ICM add up to!

I'd say...

Spoiler

... literally no idea. Could be anything.

Finally, if we have calculated a value, we could assign a great task, a vision like none other. We'd have to take a hypothetical human to have watched not a single minute of film in his life before and make him watch every (official) ICM movie ever. Give him/her some time, let's be realistic, 6 hours a day, maybe 7, it's a job (the greatest there is!). I have no idea how many years it would take this person then, quite a few. When he's finished, wise and old, we ask him if Shawshank Redemption really is the greatest film of time, to which his answ

[PeacefulAnarchy]

Without looking anything up there are some 20K checks, average runtime is probably around 90 minutes, so 30 thousand hours. That's about 3.5 years non stop or a decade of 8 hours a day.

[joachimt]

I've asked Marijn in the past to include runtime in the exportfile, but somehow he never added it. Would be easy otherwise to calculate this. Or you could create an IMDb-list of all official checks and export from there. Takes a bit more time, but not hard to do.

[Tim2460]

I'll take à look when I'm back home. I do have the runtime on my excel chart.

[pitchorneirda]

There are 16230 official checks.
I don't have an estimate for the mean runtime of an official movie
But I have the median runtime of a movie (official or not): 55 min
Official checks are a bit more skewed towards feature films than average but 90 min (PA's estimate) seems too high.

16230 * 55 = 892650 minutes or 14877 hours or 620 days
16230 * 90 = 1460700 minutes or 24345 hours or 1014 days

The right answer should be between those two boundaries

[Torgo]

Mh yeah, if I had to ballpark the number, I'd have the impression there are hundreds of shorts and so many of them are only a few minutes long, and maybe not as many hundreds of films with runtimes of 180 minutes or even outlier range (500+), so I'd also say 80 minutes each, .. or something? ..
Also one of you says there are over 16k official checks, the other estimates 20k - guess we will have a clearer number later

[joachimt]

Mh yeah, if I had to ballpark the number, I'd have the impression there are hundreds of shorts and so many of them are only a few minutes long,

There are currently 1935 official shorts (excluding shorts only on IMDb Shorts list). 29 of those have an unknown runtime. The other 1906 have an average runtime of 14.9 minutes.

[pitchorneirda]

Also one of you says there are over 16k official checks, the other estimates 20k - guess we will have a clearer number later

16320 is not an estimate, that's the actual number.
If you go to iCM -> All movies -> Order by: in # official toplists
The last movie to be official is the 16320th (page 650)

[PeacefulAnarchy]

I made my post half asleep without checking anything, so yeah if someone checked something then they're probably right.

The median runtime of official checks is much higher than those 55 minutes since that includes a) a lot of things without runtimes and b) a ton of TV episodes, even before getting into other runtime biases with official checks.

Edit: 1935 shorts
618 non shorts under70 min

Looking at Tim's lists Median runtime is probably between 90 and 100 minutes (Estimate since I'm not counting 2000 entries to see where exactly the middle is, and the lists don't have the same distributions anyway)

[Tim2460]

Excel List is still on the official lists from 01/10/2020

So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)

1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month

[pitchorneirda]

I made my post half asleep without checking anything, so yeah if someone checked something then they're probably right.

The median runtime of official checks is much higher than those 55 minutes since that includes a) a lot of things without runtimes and b) a ton of TV episodes, even before getting into other runtime biases with official checks.

Edit: 1935 shorts
618 non shorts under70 min

Looking at Tim's lists Median runtime is probably between 90 and 100 minutes (Estimate since I'm not counting 2000 entries to see where exactly the middle is, and the lists don't have the same distributions anyway)

I did the calculation of the median runtime excluding those with unknown runtimes so the calculation is correct.
If that's a good proxy for the actual average runtime is another question of course.

[pitchorneirda]

Excel List is still on the official lists from 01/10/2020

So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)

1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month

Well, that wasn't a good proxy then.
Thank you Tim

[xianjiro]

Excel List is still on the official lists from 01/10/2020

So, for 16208 Official List on the Excel List
16120 got a time (from IMDB) for a total of 1517418 minutes so an average of 95.53 (Prety much between 90 & 100 : well done PA ,)

1517418 minutes is :
25 290 Hours
1054 Days
a little above 35 month

1517418 minutes is an iCM official lifetime

[Onderhond]

Still not going to be 100%, some films miss lengths and some of the miniseries show episode length instead of full length.