Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
Polls: 2007 (Results), 2017 awards (Dec 21st), 1955 (Dec 27th), Directors (Dec 31st), Underrated (Jan 3rd), Knockout competition (Round 5)
Challenges: Documentary, Travel the World, Italy
Film of the Week: Le septième juré, December nominations (Dec 27th)
World Cup S4: Round 1 schedule, 1A: Canada vs England vs Estonia vs Iran (Dec 29th)

Future polls

500<400, Favourite 1001 movies, Doubling the Canon, Film World Cup and many other votes
Post Reply
User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

Re: Future polls

#1041

Post by Tim2460 » July 21st, 2019, 8:38 am

Thx lone : I'll take a look. I should start the nomination in mid September then?

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1042

Post by joachimt » July 21st, 2019, 11:47 am

Tim2460 wrote:
July 21st, 2019, 8:38 am
Thx lone : I'll take a look. I should start the nomination in mid September then?
Somewhere around then is fine. Deadline depending on the deadine of 500<400. Best have the deadline after the 500<400 countdown is over.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1043

Post by Lonewolf2003 » July 22nd, 2019, 8:20 pm

I would say end of September at earliest.

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1044

Post by PeacefulAnarchy » July 26th, 2019, 3:14 pm

I'll have 500<400 up sometime next week. Deadline will be mid September, results will be done I dunno, but should be completed by the first week of October.

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1045

Post by joachimt » July 29th, 2019, 10:07 am

Lonewolf, time to start Benelux?
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
beavis
Posts: 2010
Joined: Jun 20, 2011
Location: Amsterdam, Netherlands
Contact:

#1046

Post by beavis » August 11th, 2019, 1:01 pm

PeacefulAnarchy wrote:
July 26th, 2019, 3:14 pm
I'll have 500<400 up sometime next week. Deadline will be mid September, results will be done I dunno, but should be completed by the first week of October.
:shrug:

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1047

Post by PeacefulAnarchy » August 11th, 2019, 4:19 pm

beavis wrote:
August 11th, 2019, 1:01 pm
PeacefulAnarchy wrote:
July 26th, 2019, 3:14 pm
I'll have 500<400 up sometime next week. Deadline will be mid September, results will be done I dunno, but should be completed by the first week of October.
:shrug:
That was two weeks ago? I thought it was like 4-5 days ago. My time management this summer has been absolutely horrid, not completely my fault but largely my fault. I'll do this today. Right now because otherwise I'm going to fuck it up. Give me a bit to fix up the imdb lists.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1048

Post by Tim2460 » September 10th, 2019, 6:27 pm

Starting to think about the launch of the 1940's pool.

Got links to the old thread and working on the opening post.

I grabbed an excel result file but haven't understand yet the formula that create the result post themself.

@PA : will you make available the last excel file of screenshots urls ? I have lost the old one i'm afraid... can't find it anymore :(

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1049

Post by Lonewolf2003 » September 10th, 2019, 6:30 pm

The screenshot Excel will most probably get a lot of addition with the <400 poll. So you might want to wait for that one to finish. You don’t need it anyhow till you start the results thread.

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1050

Post by joachimt » September 24th, 2019, 4:48 pm

Tim2460 wrote:
September 10th, 2019, 6:27 pm
Starting to think about the launch of the 1940's pool.

Got links to the old thread and working on the opening post.

I grabbed an excel result file but haven't understand yet the formula that create the result post themself.

@PA : will you make available the last excel file of screenshots urls ? I have lost the old one i'm afraid... can't find it anymore :(
Here is the latest spreadsheet:
https://we.tl/t-wvt0Gqho7q

When will you start the nominations thread?
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1051

Post by Tim2460 » September 24th, 2019, 5:26 pm

Was thinking about this saturday!

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1052

Post by Lonewolf2003 » October 14th, 2019, 8:13 am

For November Shorts is on the program, do you want to do that one, joachim? You're more into shorts than I am.

For December Underrated movies is, I can do that one. I will set up a preparation-topic to discuss the criteria for that in November. Directors is also up for December; PA, are you doing that one again?

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1053

Post by joachimt » October 14th, 2019, 8:25 am

Sure, I'll do shorts. I'll start the topic later today.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1054

Post by Lonewolf2003 » October 14th, 2019, 2:18 pm

joachimt wrote:
October 14th, 2019, 8:25 am
Sure, I'll do shorts. I'll start the topic later today.
I didn't mean you would have to start it right away.

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1055

Post by joachimt » October 14th, 2019, 2:59 pm

Lonewolf2003 wrote:
October 14th, 2019, 2:18 pm
joachimt wrote:
October 14th, 2019, 8:25 am
Sure, I'll do shorts. I'll start the topic later today.
I didn't mean you would have to start it right away.
Why not? Couple of weeks nominations seems fine to me.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1056

Post by Lonewolf2003 » October 14th, 2019, 4:05 pm

Cause the 40s noms are also still open. But mostly I meant you didn't have to feel pressured to open it right away ;)

mjf314
Moderator
Posts: 10863
Joined: May 08, 2011
Contact:

#1057

Post by mjf314 » October 25th, 2019, 3:11 pm

Should we have a new TV poll sometime in 2020? The last TV poll was in 2015.

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1058

Post by joachimt » October 25th, 2019, 3:14 pm

I'm expecting Lonewolf to run a poll about next year's polls. He might wait till the challenge-schedule is decided though.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1059

Post by Lonewolf2003 » October 26th, 2019, 11:16 am

Yes, I will start a topic for that today

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1060

Post by Tim2460 » October 26th, 2019, 6:14 pm

Can someone point me to the latest screenshots and result excels ?
The one that creates the results post with the up and down arrows seems nice to comare to first 40'4 pool !

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1061

Post by joachimt » October 27th, 2019, 6:59 am

Tim2460 wrote:
October 26th, 2019, 6:14 pm
Can someone point me to the latest screenshots and result excels ?
The one that creates the results post with the up and down arrows seems nice to comare to first 40'4 pool !
Here is the spreadsheet that I recently used for the animation poll. It contains the latest list of of screenshots that I had. PA should have a more recent list after 500<400, but that wouldn't give you a lot more probably.
https://we.tl/t-wvaozPZi8x

Put the result of the filmcounter script in the first tab. You're probably clever enough to figure out the rest, but feel free to ask of course. :)
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1062

Post by PeacefulAnarchy » October 27th, 2019, 2:35 pm

I added 70-80 films, most of them relatively recent so I don't know that it'll make much difference for the 1940s poll. I'll still try to get it updated today or tomorrow though.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1063

Post by Tim2460 » October 27th, 2019, 9:15 pm

Thx Joachim ! I'll try to be clever enought ,)

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1064

Post by PeacefulAnarchy » October 27th, 2019, 9:44 pm

Tim2460 wrote:
October 27th, 2019, 9:15 pm
Thx Joachim ! I'll try to be clever enought ,)
This is my layout formula for the yearly 1001, I import the list to both ICM and imdb to get the relevant data:

Code: Select all

=CONCATENATE("[size=125][size=125][size=125][size=125][b]#",W2,"[/b][/size](",,IF(V2="NEW",V2,IF(V2=0,CONCATENATE(" – , #",X2),IF(V2<0,CONCATENATE("[b][color=#ee4a2d]⇩",ABS(V2),"[/color][/b], #",X2),CONCATENATE("[b][color=#090]⇧",V2,"[/color][/b], #",X2)))),,") [size=125][url=",I2,"]",C2," (",G2,")[/url][/size][/size]",IF(U2="",U2,CONCATENATE(CHAR(10),"[",U2,"]")),"[/size][/size]",CHAR(10),AE2,CHAR(10),"[size=125][size=125]Directed by: [size=125]",E2,"[/size][/size][/size]",CHAR(10),"[size=125][size=125]([b]",ROUND(J2,2),"[/b] Pts, [b]",K2,"[/b] Votes)[/size] , Top 1–10–50: ",M2,"–",N2,"–",P2,"[/size]",CHAR(10),"[hr] [/hr][size=125][url=",Q2,"]ICheckMovies[/url]: [b]",R2,"[/b] Checks , [b]",S2,"[/b] Favourites , [b]",T2,"[/b] Official lists[/size][spoiler=List of Voters:]",AG2,"[/Spoiler]")
C: Title, E: Director G:Year, I:Imdb url, J:Pts, K:#ofvoters, M:#1 votes, N:Top10 votes, P:Top50 votes, Q:ICM url, R:# of checks, S: Favourites, T: Official lists, U:AKAtitle
W is current rank, X is previous rank,
V: Difference:

Code: Select all

=IF(X2="","NEW",IF(X2<1002,X2-W2,"NEW"))
AE: imgurl

Code: Select all

=CONCATENATE("[img]http://i.icmforum.com/",B2,".jpg[/img]")
B2 is the ttID
AG is the voter list.

If you're missing screenshots I can find them and upload them for you, otherwise you'll have to manually change the links for the new ones.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1065

Post by Tim2460 » October 31st, 2019, 10:27 pm

Had an hard time fighting against my excel ant the filmcountresult.txt/csv grrrr
Had setup half life (first line) to 50 and second line (#1 vote) to 350 .... has there are 1060 films total in my pool and longest list seems to be PDA 300 films list.
should be ok ? I have results but are they useful i wonder...

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1066

Post by PeacefulAnarchy » October 31st, 2019, 11:35 pm

If you just want to check film count you can dump all the ballots in excel and a quick pivot table will tell you how many films there are and how many votes they got. If that matches everything you can assume the point part of the program went well, maybe pick a random movie with 3 or 4 votes to do manually as a check if you're not sure.

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1067

Post by joachimt » November 1st, 2019, 5:38 am

Tim2460 wrote:
October 31st, 2019, 10:27 pm
Had an hard time fighting against my excel ant the filmcountresult.txt/csv grrrr
Had setup half life (first line) to 50 and second line (#1 vote) to 350 .... has there are 1060 films total in my pool and longest list seems to be PDA 300 films list.
should be ok ? I have results but are they useful i wonder...
Why 350?
Not that it matters much.

I you want me to double check, send me all the csv's from all the participants and I calculate as well, to see if we come up with the same.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1068

Post by Tim2460 » November 1st, 2019, 12:35 pm

I don't really know what the half life and the second line means on the .txt.

Do you have a clue ?

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1069

Post by joachimt » November 1st, 2019, 12:57 pm

With a half life of X and a maximum points of Y the points for a movie on rank N is calculated by p=Y*0,5^((N-1)/X).
In simple words:
Let's say the half life is 50 and the max points is 100.
#1 gets 100 points
#51 gets 50 points
#101 gets 25 points
#151 gets 12.5 points
etc......

With shorter lists submitted by participants, you should choose a lower halflife. I normally aim for a halflife that's one third of the average list length. A lower halflife means movies high on a few lists get advantage over movies low on lots of lists.

The second line is the points of #1, so Y in the formula above. We normally use 100. There's no reason for 350, no harm either.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1070

Post by Tim2460 » November 1st, 2019, 4:55 pm

Ok i'm back on my main rig : i'm building the file for the tamplate.

I'm back @100 for seconf line and half life @30 as most of the lists are 50-100 films long.

PA i'll need your help for the M:#1 votes, N:Top10 votes, P:Top50 votes etc etc I'm not a huge fan of the pivot table ,)

User avatar
joachimt
Donator
Posts: 30209
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#1071

Post by joachimt » November 1st, 2019, 6:04 pm

Tim2460 wrote:
November 1st, 2019, 4:55 pm
Ok i'm back on my main rig : i'm building the file for the tamplate.

I'm back @100 for seconf line and half life @30 as most of the lists are 50-100 films long.

PA i'll need your help for the M:#1 votes, N:Top10 votes, P:Top50 votes etc etc I'm not a huge fan of the pivot table ,)
PA uses a different way of calculating results than Lonewolf and I do. We use the filmcounter which gives us points for each url and we build the spreadsheet from that. PA pastes all the separate lists into one Excel and works from there. The spreadsheet Lonewolf and I use don't contain the formulas to calculate the amount of top 10 votes etc, because we don't have the separate ballots in the spreadsheet.

You're currently mixing the two workflows. It's possible to do so of course, but it might be not the most practical way.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Fergenaprido
Donator
Posts: 3434
Joined: Jun 03, 2014
Location: Malaysia
Contact:

#1072

Post by Fergenaprido » November 1st, 2019, 6:23 pm

Don't we have a "standard" half-life for all of the decade polls? What was used for the previous 1940s poll?

User avatar
Lonewolf2003
Donator
Posts: 8078
Joined: Dec 29, 2012
Contact:

#1073

Post by Lonewolf2003 » November 1st, 2019, 6:53 pm

I always use 50 for the decade polls. And I’m pretty sure Apathy used that also for the previous 40s poll. I recommend keeping the list length also the same at 250. Unless there are a lot of movies with very few votes in the list that way.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1074

Post by Tim2460 » November 1st, 2019, 7:05 pm

I haven't saw the Half Life on ApathyX result thread from last time ...

50 as HL and 100 sounds good to me
Last edited by Tim2460 on November 2nd, 2019, 12:23 pm, edited 1 time in total.

User avatar
PeacefulAnarchy
Moderator
Posts: 23494
Joined: May 08, 2011
Contact:

#1075

Post by PeacefulAnarchy » November 1st, 2019, 7:30 pm

Lonewolf2003 wrote:
November 1st, 2019, 6:53 pm
I always use 50 for the decade polls. And I’m pretty sure Apathy used that also for the previous 40s poll. I recommend keeping the list length also the same at 250. Unless there are a lot of movies with very few votes in the list that way.
It might be better this time, but 250 was too long last time. Pretty sure there were 1 vote films, definitely multiple 2 vote films.

@Tim if the output doesn't give topX then best just delete that line from my formula. I don't know what output the program gives.
I merge the csv files fill down the points formula using rank and manually fix the unranked and partially ranked lists, so I have it all there to get the data in a simple pivot table. If you don't have it from the program it's not worth it.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1076

Post by Tim2460 » November 2nd, 2019, 12:43 pm

For the top X vote i concatenate the lists as one huge csv, adjust the imdb url and rank only to create an huge csv or every vote ... then count the number of votes by film ... with number one vote, less than 10 and less than 50.
But i didn't thaught about removing the full of unranked lists before the process ... there are only 2 unranked lists of 62... not sure it can really harm the statistic ... I'll keep only the number one and top 10 i think.
For the Half-Life, i'm gonna try @ 50 and see if it makes a difference.

@PA : the i.forum.com links for the pictures don't seems to work anymore ? the imgur links provided by joachimt do work but i miss some screens ... maybe 20 : got to see if i have thoses movies or if i can find screenshots for them online. Result excel file do work know with the PA formula above ... adapted to my french excel ,)

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1077

Post by Tim2460 » November 2nd, 2019, 12:56 pm

"#510(⇩136, #374) Christmas in July (1940)
Image
Directed by: Preston Sturges
(52.03 Pts, 3 Votes) , Top 1–10–50: ––
ICheckMovies: 704 Checks , 55 Favourites , 1 Official lists
List of Voters:Show
burneyfan(unranked)
Leopardi (#147)
Opio (#65)
"

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1078

Post by Tim2460 » November 2nd, 2019, 12:58 pm

Looks good ??... exept the " at start & end .. weird.

User avatar
Tim2460
Posts: 1078
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#1079

Post by Tim2460 » November 2nd, 2019, 1:11 pm

For the HL 30 vs 50 ... it's hard to say : there are huge differences above the 150 ranks ... but the top "looks" the same : here's the first 50 wihout spoilers :
I'm not qualified enought to tell the best :

HL : 50 Rank 50 HL : 30 Rank 30 Diff Rank
3765,01 1 3404,23 1 0
3697,26 2 3282,43 2 0
3690,50 3 3210,36 3 0
3407,77 4 2906,09 4 0
3313,25 5 2897,98 5 0
3101,70 7 2669,02 6 1
3064,24 8 2607,82 7 1
3134,84 6 2581,54 8 -2
3050,19 10 2548,96 9 1
3054,79 9 2524,11 10 -1
2844,66 11 2374,74 11 0
2721,32 12 2315,30 12 0
2706,14 13 2313,20 13 0
2595,12 14 2148,47 14 0
2519,38 17 2120,78 15 2
2532,52 16 2090,33 16 0
2463,97 18 2089,46 17 1
2586,15 15 2011,40 18 -3
2385,21 19 1931,90 19 0
2345,02 20 1897,59 20 0
2330,30 21 1884,86 21 0
2165,35 27 1874,48 22 5
2308,01 22 1825,69 23 -1
2205,55 25 1802,02 24 1
2215,81 24 1782,82 25 -1
2135,66 28 1765,71 26 2
2245,24 23 1716,42 27 -4
2103,26 30 1706,74 28 2
2180,47 26 1704,57 29 -3
2115,25 29 1655,36 30 -1
1974,13 33 1650,05 31 2
1940,20 35 1615,63 32 3
2000,71 32 1590,87 33 -1
2047,20 31 1534,41 34 -3
1951,64 34 1520,35 35 -1
1931,43 36 1498,28 36 0
1906,49 37 1489,48 37 0
1890,25 38 1478,09 38 0
1806,92 39 1422,58 39 0
1671,85 41 1274,01 40 1
1673,69 40 1263,50 41 -1
1592,92 44 1253,96 42 2
1631,66 42 1242,83 43 -1
1503,17 48 1238,08 44 4
1609,48 43 1209,98 45 -2
1510,22 47 1205,45 46 1
1484,65 49 1175,64 47 2
1582,50 45 1173,72 48 -3
1564,59 46 1162,08 49 -3
1447,94 51 1109,97 50 1
Last edited by Tim2460 on November 2nd, 2019, 1:14 pm, edited 1 time in total.

User avatar
albajos
Posts: 6425
Joined: May 24, 2016
Location: Norway
Contact:

#1080

Post by albajos » November 2nd, 2019, 1:14 pm

missing a space between #510 and (down 136
But that can't always be fixed

and if we go with HL of 50 always, then we go with 50 always
Last edited by albajos on November 2nd, 2019, 1:35 pm, edited 1 time in total.

Post Reply