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: La donna del lago, June nominations (May 28th)

Future polls

500<400, Favourite 1001 movies, Doubling the Canon, Film World Cup and many other votes
Post Reply
Lakigigar
Posts: 2030
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#1281

Post by Lakigigar »

C:\WINDOWS\system32>java -version
java version "1.8.0_281"
Java(TM) SE Runtime Environment (build 1.8.0_281-b09)
Java HotSpot(TM) 64-Bit Server VM (build 25.281-b09, mixed mode)

C:\WINDOWS\system32>

Doesn't seem like it's the issue. And when I check for updates, it says the latest version is installed.

I have de-installed that Ashampoo Unzip program, but it seems like it doesn't respond if i click on the .jar file. And WinZip has a trial version, but after 21 days you gotta pay, so i'm not really sure how to do all of that, since it doesn't respond now when i click to the .jar file.
Last edited by Lakigigar on March 10th, 2021, 10:46 pm, edited 2 times in total.
User avatar
Fergenaprido
Donator
Posts: 5490
Joined: June 3rd, 2014, 6:00 am
Location: Canada
Contact:

#1282

Post by Fergenaprido »

Try The Unarchiver instead of WinZip. It's free and I use it to unpack files of various types.
Lakigigar
Posts: 2030
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#1283

Post by Lakigigar »

Fergenaprido wrote: March 10th, 2021, 10:45 pm Try The Unarchiver instead of WinZip. It's free and I use it to unpack files of various types.
Thank you. Great!

Also:

Now it seems like it always was doing something, but the only thing it does create an excel file filmcounts (which is empty) and an error file. But supposedly that's because there's no data to work with, so i have no idea what to do.

I did a test, and downloaded my own ICM list and the toplist of Onderhond just to test some things, i did put the .jar file and the two .csv files in the same folder (as i read somewhere, but in a very early post from 2012) and click on the filmcounter8.3 but it gaves a zero data filmcounts.csv as wel as an error file (both when i left the csv files raw and also when i did data to columns with comma delimited). So no idea, and there was no "explanation". Only way i can look up information is by the search bar in the upper right column and look for information that way.

There really should be a better guideline for what scripts you need and stuff like that (more organized). I think it's just a small thing that i'm doing wrong right now, but no idea what.
mjf314
Moderator
Posts: 11912
Joined: May 8th, 2011, 6:00 am
Contact:

#1284

Post by mjf314 »

From the first post of this thread:
The program should be in the same folder as the lists, and you should have a file called scoring.txt. The 1st line should be the half-life, and the 2nd line should be the point value of a #1 vote. Half-life=50 works well for most polls, but you may want to change it depending on the average list size. Optionally, if you want to make some films ineligible, create a file called ineligible.txt with a list of IMDb URLs (1 per line).
Did you create the scoring.txt file? The csv files for the lists should be the files that you exported from IMDb or iCM. You don't need to modify them.

Also I updated the first post of this thread about an hour ago, so I think all of the links should be correct now.
Lakigigar
Posts: 2030
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#1285

Post by Lakigigar »

mjf314 wrote: March 10th, 2021, 10:58 pm From the first post of this thread:
The program should be in the same folder as the lists, and you should have a file called scoring.txt. The 1st line should be the half-life, and the 2nd line should be the point value of a #1 vote. Half-life=50 works well for most polls, but you may want to change it depending on the average list size. Optionally, if you want to make some films ineligible, create a file called ineligible.txt with a list of IMDb URLs (1 per line).
Did you create the scoring.txt file? The csv files for the lists should be the files that you exported from IMDb or iCM. You don't need to modify them.

Also I updated the first post of this thread about an hour ago, so I think all of the links should be correct now.
Didn't saw there were instructions in the first post of the thread.

Right now I get this (it's just an example of my toplist and Onderhond's just for the sake of testing).

It just seems like things are missing and if i do data sort, the data seems quite incomplete. I don't know what the issue is.

Just used some examples, so it has 900+ lines, but i only post 20 of them.

It calculates how many people that voted for the film, but when multiple users voted for a movie, it starts a separate line. It also only provides the imdb link. Completely to the left it seems to be the score, but when i do data sort by comma delimited, sometimes the score get lost.

And the formula also seems quite bad, because at a given point, adding a movie to your list actually only contributes zero points (here it already starts at position 250, with half life 50 and number 1 movie getting 100 points). I don't know which formula will be best (and i'm not good in maths).
Spoiler
90.7519155317161,1,http://www.imdb.com/title/tt0317248/,"Lakigigar (#8)"
19.210939766100157,1,http://www.imdb.com/title/tt3993732/,"Onderhond (#120)"
4.058198847238192,2,http://www.imdb.com/title/tt3061836/,"Lakigigar (#233)
Onderhond (#553)"
2.2718320583129854,1,http://www.imdb.com/title/tt2368672/,"Onderhond (#274)"
0.31728609232665433,1,http://www.imdb.com/title/tt1186371/,"Onderhond (#416)"
0.04555825153988319,1,http://www.imdb.com/title/tt0483022/,"Onderhond (#556)"
0.03266424694302031,1,http://www.imdb.com/title/tt1386932/,"Onderhond (#580)"
0.00977868502917019,1,http://www.imdb.com/title/tt1602479/,"Onderhond (#667)"
0.009915190385207948,1,http://www.imdb.com/title/tt0489270/,"Onderhond (#666)"
74.74246243174692,1,http://www.imdb.com/title/tt0193253/,"Onderhond (#22)"
0.6434304822402914,1,http://www.imdb.com/title/tt6229030/,"Onderhond (#365)"
0.01441641432409095,1,http://www.imdb.com/title/tt4851852/,"Onderhond (#639)"
3.3960464453939316,1,http://www.imdb.com/title/tt0381348/,"Onderhond (#245)"
17.681180232310503,2,http://www.imdb.com/title/tt2278388/,"Lakigigar (#217)
Onderhond (#150)"
mjf314
Moderator
Posts: 11912
Joined: May 8th, 2011, 6:00 am
Contact:

#1286

Post by mjf314 »

filmcounter only outputs 4 columns (points, votes, URL, voters). To get the titles and years, add the list to iCM and export it.

I'm not sure what you mean by "data sort by comma delimited". Maybe we're using different versions of Excel. In my version, you can just click any cell in the points column, then click the "sort descending" button, and it'll sort all 4 columns by points.

If you want a #250 vote to be worth more points, increase the half-life (e.g. 75 or 100 instead of 50).
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1287

Post by Tim2460 »

there are very often problems with csv on the Poll creation & management process.

If you open the csv on notepad, then control+H and replace "," by ";" it can help.
Lakigigar
Posts: 2030
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#1288

Post by Lakigigar »

Also, i have problems adding a ton of imdb links to a list. It just doesn't want to add them, because some films are supposedly not on ICM. How long does that take (it says it will happen automatically, but not sure about that, since I had those issues in the past as well, it mentions it will be added and you get a mention, but i've never got a mention from ones in the past)

Secondly, there is a 21st century list in where the deadline will be around end of august, where I plan to participate, but how many movies will be listed. I mean it seems a bit pointless if it's only 250 movies, because we had polls in the past from 2000's and 2010's alone that has 250 movies in them, and there will be a lot of people who haven't kept much track of the 2010's steering that list a lot of 2000's movies, to the point that 1. only well-known American movies from the 2010's will make the list and 2. that probably between 150 to 170 films will be from the 2000's. There will still a lot of foreign (mostly "deep" well-known arthouse) movies that will make the list, but i think they will be the main victim of that merge.

So i'm hoping it will be more than 250 movies ofc, although the longer the list the larger the percentage of 2000's movies will grow ironically, which is not a huge issue I suppose, because at least there will be more lots of unchecked films for me that I could watch than.

I have seen 98 movies from the 2000's top 250 and 118 movies from the 2010's top 250 (so I suppose I can participate here :) ). There's no other ICMforum list from what i've seen where i have over 25% of seen movies (except horror and sci-fi which narrowly makes it with around 65-70 / 250 and animation with 41 / 150)
mjf314
Moderator
Posts: 11912
Joined: May 8th, 2011, 6:00 am
Contact:

#1289

Post by mjf314 »

Tim2460 wrote: March 11th, 2021, 6:51 am there are very often problems with csv on the Poll creation & management process.

If you open the csv on notepad, then control+H and replace "," by ";" it can help.
I don't think that would work, because wouldn't it also replace the commas that are in the middle of a movie title?

One way to fix it is to change the separator from ";" to "," in your Windows settings. This page has instructions: https://resrequest.helpspot.com/index.p ... age&id=279

If you don't want to change your Windows settings, I think Excel's "text to columns" feature should work.

If it doesn't work, maybe try using an online tool to change the separator in the file from "," to ";". https://onlinecsvtools.com/change-csv-delimiter
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1290

Post by joachimt »

Lakigigar wrote: March 11th, 2021, 5:03 pm Also, i have problems adding a ton of imdb links to a list. It just doesn't want to add them, because some films are supposedly not on ICM. How long does that take (it says it will happen automatically, but not sure about that, since I had those issues in the past as well, it mentions it will be added and you get a mention, but i've never got a mention from ones in the past)
This bug has been fixed last year, so titles that are not yet on iCM will be added within seconds. You don't get a notification of it, but if you try to add all those IMDb-urls to the list a few seconds later, it will work.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1291

Post by joachimt »

Lakigigar wrote: March 11th, 2021, 5:03 pm Secondly, there is a 21st century list in where the deadline will be around end of august, where I plan to participate, but how many movies will be listed. I mean it seems a bit pointless if it's only 250 movies, because we had polls in the past from 2000's and 2010's alone that has 250 movies in them, and there will be a lot of people who haven't kept much track of the 2010's steering that list a lot of 2000's movies, to the point that 1. only well-known American movies from the 2010's will make the list and 2. that probably between 150 to 170 films will be from the 2000's. There will still a lot of foreign (mostly "deep" well-known arthouse) movies that will make the list, but i think they will be the main victim of that merge.

So i'm hoping it will be more than 250 movies ofc, although the longer the list the larger the percentage of 2000's movies will grow ironically, which is not a huge issue I suppose, because at least there will be more lots of unchecked films for me that I could watch than.

I have seen 98 movies from the 2000's top 250 and 118 movies from the 2010's top 250 (so I suppose I can participate here :) ). There's no other ICMforum list from what i've seen where i have over 25% of seen movies (except horror and sci-fi which narrowly makes it with around 65-70 / 250 and animation with 41 / 150)
List length isn't set in stone. You can debate about it once the nominations are open, but also the average list length and number of participants are taken into account.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
Lakigigar
Posts: 2030
Joined: October 31st, 2015, 6:00 am
Location: Belgium
Contact:

#1292

Post by Lakigigar »

mjf314 wrote: March 11th, 2021, 7:12 pm
Tim2460 wrote: March 11th, 2021, 6:51 am there are very often problems with csv on the Poll creation & management process.

If you open the csv on notepad, then control+H and replace "," by ";" it can help.
I don't think that would work, because wouldn't it also replace the commas that are in the middle of a movie title?

One way to fix it is to change the separator from ";" to "," in your Windows settings. This page has instructions: https://resrequest.helpspot.com/index.p ... age&id=279

If you don't want to change your Windows settings, I think Excel's "text to columns" feature should work.

If it doesn't work, maybe try using an online tool to change the separator in the file from "," to ";". https://onlinecsvtools.com/change-csv-delimiter
Perhaps it is because i'm using Excel 2007 (because i don't have access to a more recent version of Excel).
mjf314
Moderator
Posts: 11912
Joined: May 8th, 2011, 6:00 am
Contact:

#1293

Post by mjf314 »

I'm actually using Excel 2003. I'm pretty sure every version of Excel has "text to columns", but it might be in a different place.
User avatar
Lonewolf2003
Donator
Posts: 11371
Joined: December 29th, 2012, 7:00 am
Contact:

#1294

Post by Lonewolf2003 »

mjf314 wrote: March 11th, 2021, 7:12 pm
Tim2460 wrote: March 11th, 2021, 6:51 am there are very often problems with csv on the Poll creation & management process.

If you open the csv on notepad, then control+H and replace "," by ";" it can help.
I don't think that would work, because wouldn't it also replace the commas that are in the middle of a movie title?

One way to fix it is to change the separator from ";" to "," in your Windows settings. This page has instructions: https://resrequest.helpspot.com/index.p ... age&id=279

If you don't want to change your Windows settings, I think Excel's "text to columns" feature should work.

If it doesn't work, maybe try using an online tool to change the separator in the file from "," to ";". https://onlinecsvtools.com/change-csv-delimiter
Changing your windows setting indeed works. Problem is that Lakigar, like me, has it on European settings, while the csv uses American (I think) separators
User avatar
Lonewolf2003
Donator
Posts: 11371
Joined: December 29th, 2012, 7:00 am
Contact:

#1295

Post by Lonewolf2003 »

Lakigigar wrote: March 11th, 2021, 5:03 pm Secondly, there is a 21st century list in where the deadline will be around end of august, where I plan to participate, but how many movies will be listed. I mean it seems a bit pointless if it's only 250 movies, because we had polls in the past from 2000's and 2010's alone that has 250 movies in them, and there will be a lot of people who haven't kept much track of the 2010's steering that list a lot of 2000's movies, to the point that 1. only well-known American movies from the 2010's will make the list and 2. that probably between 150 to 170 films will be from the 2000's. There will still a lot of foreign (mostly "deep" well-known arthouse) movies that will make the list, but i think they will be the main victim of that merge.

So i'm hoping it will be more than 250 movies ofc, although the longer the list the larger the percentage of 2000's movies will grow ironically, which is not a huge issue I suppose, because at least there will be more lots of unchecked films for me that I could watch than.

I have seen 98 movies from the 2000's top 250 and 118 movies from the 2010's top 250 (so I suppose I can participate here :) ). There's no other ICMforum list from what i've seen where i have over 25% of seen movies (except horror and sci-fi which narrowly makes it with around 65-70 / 250 and animation with 41 / 150)
We will see. But 250 indeed seems low. Let's hope we can make it larger indeed.
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1296

Post by Tim2460 »

mjf314 wrote: March 11th, 2021, 7:12 pm
Tim2460 wrote: March 11th, 2021, 6:51 am there are very often problems with csv on the Poll creation & management process.

If you open the csv on notepad, then control+H and replace "," by ";" it can help.
I don't think that would work, because wouldn't it also replace the commas that are in the middle of a movie title?

One way to fix it is to change the separator from ";" to "," in your Windows settings. This page has instructions: https://resrequest.helpspot.com/index.p ... age&id=279

If you don't want to change your Windows settings, I think Excel's "text to columns" feature should work.

If it doesn't work, maybe try using an online tool to change the separator in the file from "," to ";". https://onlinecsvtools.com/change-csv-delimiter
Theses , & ; problems are commun and i have to deal with them for years...
Setting windows Locale to UK or US can help ... but you have to get used to it.
I have used UK Locale for years because it better handled the weird unicode caracters we encountered collecting old video Games.
And god know there are a LOT of those ... I deal with around 25 000 movies on my collection... The Tosec collection (https://www.tosecdev.org/) deals with over 1 MILLION Roms :sweat: .

Exporting from ICM or IMDB, the Movie names are usualy between "" on the csvs, so exchanging ,& ; usually don't breaks the collums.
You can also set ICM to export with, instead of ; ... but it made things worse for me.
Last, you can also rename your file from .csv to .txt, open excel THEN open the file from within excel and choose the comma or ; as a separator.

Don't worry Lakigigar, we'll be here to help.
Have you ever seen one of the main excel files that creates the result thread ?
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1297

Post by Tim2460 »

Still haven't heard from PA about the Favorite way of managing things.

Starting Plan B... trying to download the old lists from 2012... but i can't with my current Plan.

Anyone can help ? With Both 1-1001 & 1001-2000 lists ?
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1298

Post by joachimt »

Tim2460 wrote: March 13th, 2021, 1:31 pm Still haven't heard from PA about the Favorite way of managing things.

Starting Plan B... trying to download the old lists from 2012... but i can't with my current Plan.

Anyone can help ? With Both 1-1001 & 1001-2000 lists ?
I'll ask PA for his spreadsheet.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1299

Post by joachimt »

joachimt wrote: March 13th, 2021, 1:47 pm
Tim2460 wrote: March 13th, 2021, 1:31 pm Still haven't heard from PA about the Favorite way of managing things.

Starting Plan B... trying to download the old lists from 2012... but i can't with my current Plan.

Anyone can help ? With Both 1-1001 & 1001-2000 lists ?
I'll ask PA for his spreadsheet.
Here is the spreadsheet:
https://wetransfer.com/downloads/e8fd97 ... 237/5727d2
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1300

Post by Tim2460 »

Thx joachimt i'm gonna take a look.

BTW do you have a way to check if the 2 weird entries on the fav thread are legit ? emailing the so called poster for ex ?
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1301

Post by joachimt »

Tim2460 wrote: March 16th, 2021, 7:09 am Thx joachimt i'm gonna take a look.

BTW do you have a way to check if the 2 weird entries on the fav thread are legit ? emailing the so called poster for ex ?
I'll PM you.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1302

Post by Tim2460 »

joachimt wrote: March 15th, 2021, 5:04 pm
joachimt wrote: March 13th, 2021, 1:47 pm
Tim2460 wrote: March 13th, 2021, 1:31 pm Still haven't heard from PA about the Favorite way of managing things.

Starting Plan B... trying to download the old lists from 2012... but i can't with my current Plan.

Anyone can help ? With Both 1-1001 & 1001-2000 lists ?
I'll ask PA for his spreadsheet.
Here is the spreadsheet:
https://wetransfer.com/downloads/e8fd97 ... 237/5727d2
Took a look : don't know if that's because of the ods format ... but i can't guess how the scores per film are calculated...
Max is 100 and samller are the PdA over 6000 rank ... but that's not a surprise ,)

Big deal for me is to understand the way the scores are calculated... especialy on the groups of course....

Do you have any info on that ?
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1303

Post by joachimt »

Tim2460 wrote: March 16th, 2021, 7:47 pm
joachimt wrote: March 15th, 2021, 5:04 pm
joachimt wrote: March 13th, 2021, 1:47 pm
I'll ask PA for his spreadsheet.
Here is the spreadsheet:
https://wetransfer.com/downloads/e8fd97 ... 237/5727d2
Took a look : don't know if that's because of the ods format ... but i can't guess how the scores per film are calculated...
Max is 100 and samller are the PdA over 6000 rank ... but that's not a surprise ,)

Big deal for me is to understand the way the scores are calculated... especialy on the groups of course....

Do you have any info on that ?
You mean the math or the way it is done in the spreadsheet?

Math:
A movie on a ranked list gets points = 100 * 0,5^((N-1)/50)
Halflife is 50 for Fav Movies Poll if I remember correctly.

If a list is unranked, let's say 250 titles long, you add up all the points for numbers 1 to 250: sum of 100 * 0,5^((N-1)/50) for N = 1 to N = 250. Then you divide it by 250, so each movie gets the average amount of points. So movies on an unranked list of 10 get a lot more points than movies on an unranked list of 250.

If a list is partially ranked, let's say for example 1-50 is ranked and 51 to 250 is unranked, numbers 1 to 50 get the same amount of points as on a ranked list. Then for number 51 to 250 you do the same as on an unranked list, but then for 51 to 250: sum of 100 * 0,5^((N-1)/50) for N = 51 to N = 250. Then you divide it by 200, so each movie gets the average amount of points of the unranked part.

Then group-ranked is basically the same as how you calculate the unranked part of a partially ranked list. So let's say for example someone submits this:
Group 1: 1-50
Group 2: 51-150
Group 3: 151-250
Then number 1-50 should get sum of 100 * 0,5^((N-1)/50) for N = 1 to N = 50 divided by 50.
Number 51-150 should get sum of 100 * 0,5^((N-1)/50) for N = 51 to N = 150 divided by 100.
Number 151-250 should get sum of 100 * 0,5^((N-1)/50) for N = 151 to N = 250 divided by 100.

The filmcounter program is written to deal with ranked, unranked and partially ranked, but not for group ranked. That means you have to do everything in a spreadsheet instead of the filmcounter. If you need help with the formulas, let me know.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1304

Post by Tim2460 »

Thx for the kick response : i'll try to code that tomorow...
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1305

Post by Tim2460 »

As i see it only one or two person is gonna use group ranking.
If the algorytm is the same do you think i can filmcounter 8.3 the 99% of the list then add the one or two Rank-Grouped lists results calculated by hand/excel?
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1306

Post by joachimt »

Tim2460 wrote: March 18th, 2021, 1:53 pm As i see it only one or two person is gonna use group ranking.
If the algorytm is the same do you think i can filmcounter 8.3 the 99% of the list then add the one or two Rank-Grouped lists results calculated by hand/excel?
Might be possible, but if I would do this, I would use one system for everything. But I haven't looked at PA's spreadsheet yet, so I'm not sure how much work it is.

If you do most lists with filmcounter and calculate the others aside from that, you can put those points next to the others with VLOOKUP and add them. Adding those usernames to the voters-list is more annoying to do, probably.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1307

Post by Tim2460 »

joachimt wrote: March 18th, 2021, 2:36 pm Adding those usernames to the voters-list is more annoying to do, probably.
Hmmm Didn't thaught about that :facepalm:
Might be not so hard ... i'll think about it
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1308

Post by Tim2460 »

joachimt wrote: March 16th, 2021, 8:23 pm Math:
A movie on a ranked list gets points = 100 * 0,5^((N-1)/50)
Halflife is 50 for Fav Movies Poll if I remember correctly.
Ok ... I don't get the N-1 part ...

II can't div by 0 for the Movie ranked #1 ... ? Or i missed something ?

Image
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1309

Post by Tim2460 »

#1( – , #1) 2001: A Space Odyssey (1968)
Image
Directed by: Stanley Kubrick
(3699,61 Pts, 53 Votes) , Top 1–10–50: 2–15–22
History: 1?1?1?1?2?1?1?1?8
ICheckMovies: 66626 Checks , 7730 Favourites , 42 Official lists
List of Voters:
explorer95 (1) klaus78 (1) kingink (2) russa03 (2) Dolwphin (4) Good_Will_Harding (4) mightysparks (4) brokenface (5) Pretentious Hipster (5) rokp (5) Gorro (6) sol (6) toromash (6) Traveller (9) wasabi (9) nimimerkillinen (13) beasterne (14) OldAle1 (15) Carmel1379 (21) jeff_v (21) Smoover (28) Panunzio (36) AB537 (55) tommy_leazaq (55) St. Gloede (62) Opio (65) Teproc (72) Lonewolf2003 (76) Caracortada (81) Chilton (NA) sushantv10 (100) filmbantha (105) clemmetarey (120) joachimt (123) Gordon_Gekko (145) beavis (149) perceval (156) PGonzalez (NA) erde (NA) connordenney (174) funkybusiness (174) GruesomeTwosome (NA) Wonderful Rainbow (NA) Tim2460 (NA) Leopardi (233) Gershwin (NA) mathiasa (255) Ebbywebby (NA) hurluberlu (NA) zomgmouse (NA) insomnius (NA) Obgeoff (682) Jimi Antiloop (906)
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1310

Post by Tim2460 »

I kinda like the list of voters format... bold if top 1 ... Italic if top 10 ... nice work
User avatar
pitchorneirda
Posts: 851
Joined: February 11th, 2019, 12:07 pm
Location: France
Contact:

#1311

Post by pitchorneirda »

Tim2460 wrote: March 18th, 2021, 3:38 pm
joachimt wrote: March 16th, 2021, 8:23 pm Math:
A movie on a ranked list gets points = 100 * 0,5^((N-1)/50)
Halflife is 50 for Fav Movies Poll if I remember correctly.
Ok ... I don't get the N-1 part ...

II can't div by 0 for the Movie ranked #1 ... ? Or i missed something ?

Image
You used "/" twice instead of using "^". 0.5^0 = 1

Edit : maybe you need to use the "POW" formula, i'm not sure "^" works
"Art is like a fire, it is born from the very thing it burns" - Jean-Luc Godard
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1312

Post by Tim2460 »

Taught it was a division

In fact it's a power of something then
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1313

Post by joachimt »

What pitch said and you can use ^ for power. So it should be:

=100*0,5^((B3-1)/50)
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1314

Post by Tim2460 »

Ok :
Got the way to score
Got the way to create the Voters List

So far so good
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1315

Post by Tim2460 »

After 110 painfull minutes i finaly understood half life on the favorite pool is not 50 as you said Joachimt ... but 175.

It's not like i actually COPY & PASTE the exact formula with /175 in my own OP of the nomination thread :facepalm:

I manage to compute ranked list ... trying to make partial ranked and group and we should be good

Edit : i feel better actually understanding what's going on under the hood than using filmcounter totaly in the fog of war :whistling:
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1316

Post by joachimt »

Oh, sorry. Didn't realize what the halflife was here.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1317

Post by Tim2460 »

I'm trying to get to the next level on my collecting method of organization.

Main excel File is roughly 26 000 films long.

I'd like to create an SQL image of that, and import (automatiquely ?) info from ICM, IMDB, OMDB & TMDB.

Starting from extracting from tmdb : we'll be able to get an country info quite easily from that.
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1318

Post by Tim2460 »

#2010(⇧904, #2914) Proverka na dorogakh (1986)
[Trial on the Road]

[Проверка на дорогах]
Image
Directed by: Aleksey German
Country:Soviet Union
(188,51 Pts, 6 Votes) , Top 1–10–50: 0–0–0
History: 201029143105211322292574384428826691←NA
ICheckMovies: 414 Checks , 69 Favourites , 4 Official lists
Plot:The Russian POW joins the partisan guerrillas and proves his loyalty fighting the Nazis.
List of Voters:
St. Gloede (228)
filmbantha (337)
Gorro (530)
sebby (994)
Fergenaprido (NA)
Ritesh (NA)
Last edited by Tim2460 on March 30th, 2021, 7:59 pm, edited 2 times in total.
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1319

Post by joachimt »

Looks great!

Is it possible to list the voters vertically? A CHAR(10) should do that, right?
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1320

Post by Tim2460 »

It was difficult repairing the formula... don't really know what mistake i made ;)

it's weird... i have the voters set up apparently the exact same way as PA ... but they're not stacked verticaly.
Post Reply