I've just sent in my initial ballot with a nice round 500 ratings.
Here is the breakdown:
6 = 77
5 = 69
4 = 65
3 = 69
2 = 102
1 = 93
0 = 25
Giving me a mean rating of 3.14
I will be sending in a write in ballot later in the month. I think in previous years I have sent my whole ballot again with the additional ratings included, I presume this is still the case?
Mifune wrote: ↑May 8th, 2023, 9:35 am
Ok, I will build something.
I built a neat little helper tool - it's not pretty, but one can import imdb ratings, decide how to transform the votes to the 0-6 rating range and let the formulas do all the matching to the DtC nominees. Also there are statistics and a step by step guide.
I hope it works, I used German formulas and Excel 2010.
You saved my life, somehow I couldn't get joachim's/Tassel's formulas to work, probably because of some weird inner-Excelish language conflict or who the hell knows.
Worked within a single click with your template!
Votes: 417
Average: 3.78
0: 3
1: 7
2: 23
3: 138
4: 144
5: 79
6: 23
Again, I was way too generous in the low ratings. Maybe I should rate more shorts
The players (27):
beasterne
beavis
Carmel1379
ChrisReynolds
cinephage
DudeLanez
filmbantha
flavo5000
gunnar
HO9OGOHO
hurluberlu
joachimt
klaus78
Lakigigar
lee-109
LeSchpountz
Mifune
mightysparks
Mulholland
Onderhond
pitchorneirda
russa03
sol
St. Gloede
Tasselfoot
Torgo
zzzorf
Average number of voted films per voter and average rating overall:
463-3,36 (last 5 years average: 3,34)
Top voters:
St. Gloede-831
beavis-809
LeSchpountz-776
flavo5000-750
sol-727
cinephage-651
joachimt-651
Highest average rating:
cinephage-4,05
beasterne-3,92
Tasselfoot-3,78
Mulholland-3,78
Torgo-3,78
gunnar-3,76
Lowest average rating:
ChrisReynolds-2,52
klaus78-2,84
DudeLanez-2,92
Onderhond-2,98
pitchorneirda-2,99
mightysparks-3,06
Nominator of the 10 highest rated films:
revote (x6)
TSPDT (x4)
klaus78
Onderhond
LeSchpountz
Mulholland
gunnar
Mifune
DudeLanez
St. Gloede
Nominator of the 10 lowest rated films:
TSPDT (x6)
Minkin
Bill Spiby
Artintelligen (x2)
Dolwphin
Alena_03
Fergenaprido
MrCarmady
Minkin
revote
Films without a single vote (not counting its nominator):Spoiler
Ada Apa dengan Cinta?
Adam & Paul
Al Hob Fawk Hadabat Al Haram
Al-yazerli
Ausma
Ba shan ye yu
Beatrice Cenci
Belly
Boodan yaa naboodan
Bu su
Canary
Cheob-sok
Cheongchun gyoshil
Coming Out
Delitto d'amore
Den, kogda ispolnyaetsya 30 let
Der Herr auf Bestellung
Desnudo con naranjas
Desperate Remedies
Dubravka
Eldfjall
En el balcón vacío
Finding Interest
Gelin
Glória
Go Get Some Rosemary
Gondola
Han ye
Hedd Wyn
Hndzan
Hun Hunshi Hunshilal
I.D.
Joaquim
Jungle Girl
Kapitan Volkonogov bezhal
La Baule-les-Pins
La course du lièvre à travers les champs
La donna scimmia
La lectrice
La piel quemada
La polizia brancola nel buio
La sangre y la semilla
L'affaire des poisons
Last Resort
Le pélican
Les savates du bon Dieu
Les scélérats
L'homme sur les quais
Living in the World
Lof mér að falla
Los peces rojos
Lyubov
Ma vie en rose
Maya Darpan
Men with Guns
Mondomanila: Kung paano ko inayos ang buhok ko matapos ang mahaba-haba ring paglalakbay
Monsutâzu kurabu
Nidhanaya
Nie wieder schlafen
O Céu de Suely
O lipotaktis
Osoi hito
Pag-asa
Pagine chiuse
Palo y hueso
Peggy and Fred in Hell: The Complete Cycle
Pelnia
Povestea dragostei
Princess
Puika
Stop!
Tainstvennaya stena
The Book of Birdie
The Exigency
The Gamekeeper
Wonderful World End
Xiang jiao tian tang
Ya rodom iz detstva
Yeast
Zena s krajolikom
Zheng hun qi shi
Zugvögel - ... einmal nach Inari
Remember that you can vote even if you have not participated in the nomination phase.
I am working on a new tag (this film was originally nominated by xxx) and I can't find info about 3 films nominated in 2016: Sepio, Love Must Love and Nuestra Señora de Paris.
Angel Glez wrote: ↑May 22nd, 2023, 11:16 am
Help wanted!
I am working on a new tag (this film was originally nominated by xxx) and I can't find info about 3 films nominated in 2016: Sepio, Love Must Love and Nuestra Señora de Paris.
Do you remember the nominators of those films?
My guess is Sy9 for all three, but I'm not 100% sure.
Angel Glez wrote: ↑May 22nd, 2023, 11:16 am
Help wanted!
I am working on a new tag (this film was originally nominated by xxx) and I can't find info about 3 films nominated in 2016: Sepio, Love Must Love and Nuestra Señora de Paris.
I feel the need to apologize because I won't have time to complete the voting ballot for this project (and it was my first time participating). I feel really bad about it and kind of want to retract the films I nominated because I can't reciprocate by voting or watching as many of the other nominated films that I had hoped.
I just have almost no spare time right now due to work and other obligations. So, I am sorry for my lack of effort on this; it seems like a lot of excellent films were nominated too. I feel the same about the challenge thread. I wish I had more time right now, but alas.
peeptoad wrote: ↑May 25th, 2023, 12:31 pm
I feel the need to apologize because I won't have time to complete the voting ballot for this project (and it was my first time participating). I feel really bad about it and kind of want to retract the films I nominated because I can't reciprocate by voting or watching as many of the other nominated films that I had hoped.
I just have almost no spare time right now due to work and other obligations. So, I am sorry for my lack of effort on this; it seems like a lot of excellent films were nominated too. I feel the same about the challenge thread. I wish I had more time right now, but alas.
Would the auto-fill template by Mifune help you? It could just translate your IMDb ratings to a DtC score. (In case you use IMDb. Otherwise .. no one can help you! Anymore!)
peeptoad wrote: ↑May 25th, 2023, 12:31 pm
I feel the need to apologize because I won't have time to complete the voting ballot for this project (and it was my first time participating). I feel really bad about it and kind of want to retract the films I nominated because I can't reciprocate by voting or watching as many of the other nominated films that I had hoped.
I just have almost no spare time right now due to work and other obligations. So, I am sorry for my lack of effort on this; it seems like a lot of excellent films were nominated too. I feel the same about the challenge thread. I wish I had more time right now, but alas.
One time-saver could be to speed through and just vote for your 6/6 films. Good luck with all your work, peeps.
It's really just a minute with the Excel template in case there's a IMDb rating history to work with
Then one can take another quick look for only their 10/10s or DtC 6 ratings or whatever they feel like. I adjusted about 30% of my ballot because of my mindless spamming of 7/10s on IMDb which can transform into ANYTHING
Yeah the problem is for those of us who don't use IMDB.
I have spent a little while each night the past week or so going through the DTC list with the ICM list and my Letterboxd ratings side by side by side. About halfway through, but will finish it in time for the deadline.
I'll try the template before the deadline. Worse case I can try Roger's suggestion. I think I've only seen ~250 of them anyway, so not sure how much impact my votes will have anyhow!
Yea I don't even have everything checked in ICM, so it's me searching the film's title onto my RYM account, seeing what the rating is, and going from there. Copy and pasting like 1500 times is the most tiresome project.
Personally, I really enjoy filling out the ballot by hand, making decisions (how to rate, what to watch) one by one. It is time-consuming, though.
peeptoad wrote: ↑May 25th, 2023, 6:26 pm
I'll try the template before the deadline. Worse case I can try Roger's suggestion. I think I've only seen ~250 of them anyway, so not sure how much impact my votes will have anyhow!
You never knows. Even a 0 can help a film to make the list!
zuma wrote: ↑May 25th, 2023, 6:17 pm
Yeah the problem is for those of us who don't use IMDB.
Like me. It was so annoying that I couldn't use the helpful IMDB links that are often added to the starting posts of the polls.
But I recently discovered a python script that automatically exports all the data from Letterboxd to IMDB. Works wonderfully, took about 20 minutes for my 6.000 ratings.
If anyone has the same problem and needs help with the script, feel free to contact me.
Current state of play for me, 304 watched, 3.1 average. Feel I might have been harsher than in previous years, generally feel like my averages are usually higher than others, but not this year. Haven't sent ballot in yet. Will look to get some more watches in on the weekend.
The 40 players (last 5 years average = 81):
beasterne
beavis
Carmel1379
cayh
ChrisReynolds
cinephage
Dolwphin
DudeLanez
filmbantha
flavo5000
George Eastman
Gordon_Gekko
greennui
gunnar
Hawk
HO9OGOHO
hurluberlu
joachimt
klaus78
Lakigigar
lee-109
LeSchpountz
Lonewolf2003
Mifune
mightysparks
Mulholland
Onderhond
peeptoad
pitchorneirda
russa03
sacmersault
Smoover
sol
St. Gloede
Tasselfoot
tobias
Torgo
Y U M E
zhangalan
zzzorf
Average number of voted films per voter and average rating overall:
444-3,35 (last 5 years average: 3,34)
Top voters:
Y U M E-832
St. Gloede-831
beavis-809
LeSchpountz-776
flavo5000-750
sol-747
George Eastman-661
Highest average rating:
peeptoad-4,10
cinephage-4,05
beasterne-3,92
greennui-3,86
Tasselfoot-3,78
Mulholland-3,78
Torgo-3,78
Lowest average rating:
sacmersault-2,49
ChrisReynolds-2,52
Hawk-2,78
klaus78-2,84
DudeLanez-2,92
Onderhond-2,98
pitchorneirda-2,99
Nominator of the 10 highest rated films:
TSPDT (x6)
revote (x6)
flavo5000
Onderhond
Smoover (x2)
LeSchpountz
Panunzio
filmbantha
russa03
Y U M E
Nominator of the 10 lowest rated films:
TSPDT (x11)
Minkin (x2)
Bill Spiby
Alena_03
artintelligen (x2)
Anyway
MrCarmady
Dolwphin
Mario Gaborović
monoglot
Films without a single vote (not counting its nominator):
Spoiler
Ada Apa dengan Cinta?
Al Hob Fawk Hadabat Al Haram
Ausma
Ba shan ye yu
Belly
Boodan yaa naboodan
Bu su
Cheob-sok
Cheongchun gyoshil
Den, kogda ispolnyaetsya 30 let
Der Herr auf Bestellung
Desnudo con naranjas
Dubravka
Eldfjall
En el balcón vacío
Finding Interest
Glória
Go Get Some Rosemary
Gondola
Hndzan
Hun Hunshi Hunshilal
Jungle Girl
Kapitan Volkonogov bezhal
La donna scimmia
La lectrice
La piel quemada
La sangre y la semilla
L'affaire des poisons
Les scélérats
L'homme sur les quais
Living in the World
Lof mér að falla
Los peces rojos
Lyubov
Mondomanila: Kung paano ko inayos ang buhok ko matapos ang mahaba-haba ring paglalakbay
Nidhanaya
Nie wieder schlafen
O Céu de Suely
Pag-asa
Pagine chiuse
Palo y hueso
Peggy and Fred in Hell: The Complete Cycle
Pelnia
Povestea dragostei
Puika
Stop!
Tainstvennaya stena
The Book of Birdie
The Exigency
The Gamekeeper
Xiang jiao tian tang
Ya rodom iz detstva
Yeast
Zena s krajolikom
Remember that you can vote even if you have not participated in the nomination phase.
I'm finishing up my 554 votes right now, but I'll hold off on submitting because I might still fit it watching another film or two before the deadline.