2020年4月27日 · To use the spreadsheet. Delete the sample data in the Form Responses 1 sheet. Send the players a link to the form. (tell them to use the exact same team name throughout, and they will benefit from having two devices. One to watch the stream of you reading questions, and a phone to submit the form in. Or a laptop that can have both things open ...

2020年8月3日 · I've done online trivia a few times with a particular company and they send each team their own Google Sheet to fill in their answers. Somehow, when the answers are put into a specific column, the Scorekeeper is able to see what was submitted, but only that cell.

2019年10月28日 · Have a data sheet Column A: Team Names Column B: Points Keep a running tally on sheet 1. Then on sheet 2 do a sum of values and the teams. Then it will automatically sum points and add new teams if they join in the middle (i.e bar trivia).

2023年8月21日 · Hi! Saw your comment while replying elsewhere here. I build a trivia software platform that does almost everything you talked about. It does all automatic scorekeeping, drives a powerpoint-like display that's displays questions/answers and automatically built scoreboards, and it can do raw data exports so you can crunch th

2020年5月1日 · In another Google sheet, I use a =sumif function to pull their score from the connected Google sheet and display their score for that round. For example: Team A has their Round 1 scores populated into "Google Sheet 1". Column A in "Google Sheet 1" is the team name, columns B through L are their answers, and column M is their total score for the ...

2016年10月4日 · Then when announcing score, select all, go to Data > Sort… > Sort by Total Score > A-Z. Then you can just read out the first two columns in order. Edit: Here's a basic sheet on Google Docs with this format and 5 rounds. If you change the number of rounds just make sure to edit the formula for Total Score.

2020年5月1日 · That feeds into a google sheet. I take that raw data and I create a query to bring it into my grading sheet. The grading sheet has some formulas and conditional formatting that makes it obvious which question it is. Then I just run down the answers and grade them with a 1 for a correct answer and leave blank for incorrect.

2020年6月3日 · 703K subscribers in the excel community. A vibrant community of Excel enthusiasts. Get expert tips, ask questions, and share your love for all things…

2022年1月8日 · I've recently made a leaderboard that automatically sorts teams according to their scores for my trivia night. It's in Excel and it took waaaaay too long to make, so I'm passing it on to you so you don't have to waste your time entering all those functions.

2024年1月21日 · I need a formula that will calculate the total score based on whether they got the answer correct OR if they are receiving partial credit. Here is my current set up: Columns b3:b23 and so on are teams answers, indicated with “Y” for …