What Is This?
This is a Google Sheets template you can use much like the reporting sheets found in the back of most scenarios. Like many other custom rosters, this does more than simply track the information you need to report a completed scenario. It’s a little more than a reporting sheet.
You’re welcome to print it, but it’s probably going to look really terrible. Instead, this is intended for use online through Google Sheets.
- While viewing the template in your desktop or laptop browser, go to File > Make a Copy
- Update the name and location you want to copy the sheet to, and hit Okay
- Fill out the information for this play session
- scenario information, including level range
- GM information
- Share the document
- In File > Share, click “Get Shareable Link”
- Make sure that users with the link “can edit” (the default is “can view”)
- Once the adventure’s complete, you can also use it to track your progress reporting and providing chronicle sheets
- You can also change the sharing settings to “Can View” to prevent post-hoc changes to the file
- Don’t reuse this spreadsheet! Just make another copy from the template!
Other Tricks and Notes
- If you want to customize the sheet, you can make a copy, save it to your own drive, and then base your new roster sheets on your saved version.
- Much of the sheet is protected; only the owner can edit the metadata and the GM row, even if you allow your players to edit the sheet. In order to have full editing permissions—for example, to update their GM information—that person needs to either:
- Make their own copy of the sheet, or
- You (the owner of the sheet) need to alter or remove the sheet protection from the sheet. This is located under Tools > Protect Sheet.
- If you store all of your rosters in the same directory in Google Drive and start their names with the date (in YYYY/MM/DD format, like 2018/03/25) you get a chronological record of games you’ve GMed.
Changelog from 1.0 to 1.01
- Removed some wayward warning validation on some of the convention-specific fields.