Turn a Google Forms survey into fair, weight-adjusted odds — one line per movie, ready to paste straight into PickWheel's Batch tab. Missing a friend this week? Their favorites get quietly protected until they're back.
1Cast your data
Paste cells copied directly from your Sheet, or upload the exported .csv. First row should be your column headers.
Select your response range in Sheets, copy (⌘/Ctrl+C), and paste here — tab-separated pastes and comma CSV both work.
In Sheets: File → Download → Comma Separated Values (.csv)
2Roll call
Tell Weigh-In which columns are movies to score (everything else is ignored), then mark who's actually here tonight.
Column
Sample (first 3)
Type
Who's present tonight? Uncheck anyone who's missing — their favorites will be protected below.
Roster is built from your identity column above (or row order, if you didn't pick one).
3Tally settings
Weight = average score from who's here, minus a penalty for what anyone absent really wanted.
Sharpness decides which of their preferences get punished hardest, relative to each other. Strength is a volume knob on the penalty as a whole — it doesn't change that balance, just how hard it bites overall.
Reshapes the penalty relative to itself across movies. Higher = their favorite (a "5") gets punished way out of proportion to something they just liked (a "3"). At "1", the penalty is simply proportional to their rating.
Scales every penalty uniformly — same balance between movies, just bigger or smaller overall. 0 turns the whole rule off; higher makes absence matter more across the board.
A heavily-penalized movie never goes below this — rare, not impossible.
Stretch to a wheel-friendly range1–5 ratings barely move the odds on a wheel — this rescales the current spread out to real, decisive weights.
to
Your least-preferred movie lands near the low end; your most-wanted lands near the high end.
"1" spaces everything evenly across the range. Higher pulls the middle of the pack down toward the low end, so only real favorites stand apart.
Invert resultsThe gag mode — flips the ranking so the group's favorites become the least likely, and vice versa.