Taking a walk and grabbing lunch is one of the simple pleasures of the workday. Unless of course, you bring your lunch to work. Sometimes with a group of people it is hard to decide on where everyone should go to lunch together. Maybe only one person enjoys the guilty pleasure of Taco Bell, while the others want to stick with Whole Foods. Or maybe half of the group wants burgers and the other half pizza.
Here’s a relatively simple Google Mobile spreadsheet. It’s part 2 of our mobile phone spreadsheet series (See Part 1 on Tracking New Year’s Resolutions) that uses a weighted lottery to fairly determine where to go for lunch, taking into account each person’s individual preferences. Basically, each person gets 10 “points” to allocate to three restaurant choices. Each point is effectively a lottery ticket, and the spreadsheet randomly chooses the restaurant, with the probability weighted by how many points each restaurant has received. Continue reading