Latest Version: 3.2
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 bad. Instead, this is intended for use online through Google Sheets.
Sheet Instructions
- 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 3.11 to 3.2
Added fields to store more information for online play.
- Split the “game link” field in two: we now have a game link field and a voice chat field.
Changelog from 3.01 to 3.11
Minor feature update.
- Added conditional formatting to gently validate organized play IDs and character numbers.
Changelog from 3.0 to 3.01
Minor usability update.
- Renamed “Concordance of Elements” to be “The Concordance”
- Upped font size on many fields to improve readability
- Added borders to rows to help make them easier to follow across the screen. (Splitting rows up into sub-rows made the rows harder to follow.)
Changelog from 2.01 to 3.0
Major update with new fields and layout.
- Replaced our makeshift checkboxes with official Google Sheets checkboxes, now that that feature is available (hooray!)
- Added fields for additional event metadata: time zone, start time, and end time
- Added a field for email address
- Moved field for party role
- Shrunk horizontal size of roster
- Deleted extraneous rows and columns from spreadsheet
- Other assorted work to make future changes to the player roster area easier
Changelog from 2.0 to 2.01
Minor usability update.
- Set the “Other Notes” field to wrap text by default.
Changelog from 1.0 to 2.0
Major update with new fields and layout.
- Concordance of Elements has been added as a faction
- New column for party role has been added
- Three waitlist spaces have been added
- Warning colors have been added for PCs 7-10
- Notes have been added to the party role column as well as the flags for PCs numbered 7-10
- Added attribution information