I'm not opposed to this approach, but to me this two-stage process appears to be more complicated because the second stage ranking would require uniformity in formatting and spelling.
There's gonna be a bit of this no matter what unless we want a single film to appear on the list multiple times. At some point human eyes will have to evaluate if a film is the same or different from others.
That's sort of what I had in mind was a "human eyes" approach.This demo spreadsheet
shows the basic mechanics of the idea.
Rather then establishing the list before the chat began, it would be generated in real time. For each slot in the top 100 you would sort B, and see the result, and announce it in chat. And the random numbers get re-generated automatically after each sorting, so subsequent sorts will yield different results.
The process of sorting takes just a few clicks, and wouldn't not cause any foreseeable delays in the chat. A few clicks between each announcement, then copy/paste the results from the result cell.
As you see, the spelling and formatting of the film in Column A is not uniform, but it won't really matter because you know what it means. You can just reformat the results on the fly.
As for how to handle duplicates in the moment, that's a significant difficulty. Because now you are bumping films and it's hard for people in chat to keep track of placement, and it's probably too chaotic. So either you just do a straight lottery and duplicate draws are ignored, or you predetermine the list ahead of time and sort out all the duplication stuff.
I like the duplication advancement variable, but I also like the idea of real-time list creation on the night. I don't know why... I'm being silly about that I guess. There's no practical difference if the list is predetermined, but somehow it feels different. It would be more exciting for you, the drawer, if you were basically finding out the results right along side us.
Obviously though this would eliminate the ability to make a postable list ahead of time that could be published in the forum in realtime along with pictures and quotes. So maybe a predetermined list is the best way to go.
Anyways the demo spreadsheet sort of shows the drawing process midway through completion, with duplicate advancement in effect.
Though knowing my luck, I'd manage to place none of my 100 on the list.
You can't win either way. If any of your top 100 makes the list will say it's rigged! Especially if it's #1.
Oh and I tend to agree that first duplicate gets the worm, so to speak.