A simple scoreboard spreadsheet for lockdown Zoom games

Here’s a simple spreadsheet that serves as a handy scoreboard to keep track of who is winning your Zoom games. While there’s not much to it, feel free to save a copy to your Google Docs folder. We’ve been playing some Jackbox Party Pack, which keeps score for you, but I could see how there could be other situations (competitive Zoom rock paper scissors?) where you could have your own scoreboard.

Anyways, basically the only calculations involved are the Sum() and Rank() functions. I added in a little bit of formatting (freezing at Row 9 if the game goes many rounds, and shading every other row).

Stay Safe and enjoy!

Spreadsheet is attached here: Simple Scoreboard

(Remember to go to File –> Save a Copy to download a copy to your own Google Sheets Drive that you can Edit).

Build a Secret Santa Spreadsheet

Christmas is here again, and while we at SpreadsheetSolving appreciate the festive spirit, our practical side always wonders “does every single friend need a gift from each of their other friends?”. And… “why can’t we just give cash?”

The game Secret Santa somewhat lessens this gift giving burden among a large group of people. In this game, each person is secretly assigned one other person in the group to give a gift to. Typically, when the person opens their gift, they try to guess who gave it to them. Great fun is had by all (in theory).

We can create a simple spreadsheet to set up the random assignment of people to others in a group. First we enter in a hypothetical list of names: Continue reading “Build a Secret Santa Spreadsheet”

What College Rank & Professors’ Salaries say about Tuition

Do higher-ranked schools tend to charge a larger tuition? Does a professor’s salary positively correlate with college tuition? In this post, we’ll explore the relationships between college tuition to a couple of factors, such as professor salary, school rank, freshman retention rate*, and 6-year graduation rate.
Continue reading “What College Rank & Professors’ Salaries say about Tuition”