Massive GM Sheet (Google Sheets)


Running the Game


11 people marked this as a favorite.

As a GM, you have a lot to keep track of. You've got to manage the PCs, NPCs, Monsters, Treasure, EXP, and keep up with of all the new rules and rules updates associated with the playtest. To help, I've created a GM Sheet with numerous notes taken from the rulebook/bestiary and space meant for tracking various aspects of your players and campaign.

https://docs.google.com/spreadsheets/d/1v_C-XrHnj5jAbbLJwfFjUhKUeYtBZ1HWpWK A5qFQFPw/edit?usp=sharing

Sheet Features:

Consolidated Rules: When rules notes would tell you to refer to another part of the book, I've included those rules into the note as well to save time in referencing.

Current Errata: There is a link to the current update document on the main page and any changes are added into all of the rules notes throughout the sheet.

Party Tracking: The party tracking tab has room to record information about your PCs, including all skills used in secret checks or to establish DCs. There is room to track the languages known by the group, as well as spells known (important to know if a PC can automatically identify a casted spell). At the bottom of the tab is also room to record relevant information regarding any important NPCs in the campaign.

Skills: All uses of skills are listed with notes on the relevant rules text. Additionally, feats which improve skill uses or establish new skill uses are also included. And to make everything easier, tables such as the Skills DC table or Ordinary Skill Tasks tables are included right next to their associated skills.

Conditions: Player conditions are all listed with rules notes and space to list any PCs currently suffering from that condition. Room at the bottom of the tab allows for recording any afflictions such as poison or disease which are likely to come up in your campaign.

Environment: All of the environment rules from the Bestiary are included along with terrain conditions from the Rulebook. There is also space to track the current environmental conditions and penalties for your campaign and a space to forecast the next 2 weeks.

Modes of Play: Includes notes on all of the actions, tactics, and activities players can commonly use during each mode of play (encounter, exploration, and downtime).

Time Tracker: Includes space to track overall time since the start of the campaign, room & board, downtime activities, events over the course of a day, and includes tables for basic services and cost of living.

Treasure: Includes all of the wealth tables along with space to track how much currency and items you've given to the party thus far. Also includes room to list any items to be found in the campaign along with their associated identification DCs and value. Finally, there are many tables included for referencing different types of magical items and common DCs/pricing.

Experience: Includes a tab to track any experience points gained by the party along with tables related to experience rewards and building an encounter.

Statblocks: Include rough templates to track any custom statblocks you may need to reference for the campaign and includes handy rules notes on all monster abilities and weapon traits. Also includes many of the monster/hazard traits for easy reference, especially the few which have mechanical rules implications.

Playtest Tracking: Finally, the sheet includes a copy of the Doomsday Dawn GM Tracking Sheet so that you can have it right next to all of your other GM notes when running the Playtest Campaign.

-----

As a final note, if you liked this google sheet be sure to check out my thread for my custom character sheet.
And as a bonus, if you get your players to use a google sheets character sheet, you can then ask them to share it with you and provide a link to view. Simply attach this link to their character's name in the Party Tracking tab and you'll be able to quickly reference anyone's character sheet in game whenever you need to, even after they've just updated it with new information.


This is pretty amazing work. I'll be trying this one out next playtest i run as i believe i might not require my pdf anymore for anything other than statblocks or spell details.

Thanks!


Thanks for the work! I am going to pull it down this evening!


Wow, I expected a small sheet with table 10-2, conditions reference, and encounter building table. This is basically every mechanic of the 2E system (as opposed to its content like ancestries/classes) in a spreadsheet. Amazing job!


Fantastic job, i was just starting to work on a similar idea and came across yours before I made much progress.

Brilliant thanks


1 person marked this as a favorite.
Lyee wrote:
Wow, I expected a small sheet with table 10-2, conditions reference, and encounter building table. This is basically every mechanic of the 2E system (as opposed to its content like ancestries/classes) in a spreadsheet. Amazing job!

xD I actually debated whether or not to include "massive" in the thread's title, since I normally hate that kind of of selling language and how its prone to exaggeration.


Used the sheet in my session on Saturday (runs for 9 hours this one so can get a little fatiguing with bookkeeping) and it is a great help.

I love the party language boxes which allow the GM to have a quick glance to see languages spoken by the party, nice. I did notice however that Acrobatics and Performance were missing from the skill list on the party sheet.


Talsharien wrote:

Used the sheet in my session on Saturday (runs for 9 hours this one so can get a little fatiguing with bookkeeping) and it is a great help.

I love the party language boxes which allow the GM to have a quick glance to see languages spoken by the party, nice. I did notice however that Acrobatics and Performance were missing from the skill list on the party sheet.

Thanks for the feedback!

Originally, skills were just meant to be those needed for secret rolls the GM may need to know without informing the player (my PF1 sheet just had Perception/Sense Motive). However in the PF2 Playtest, the increase of secret rolls and the inclusion of skill DCs has made it so that many, but not all, skills were included in this - which is what I had tried to include.

However, considering that you brought up the missing skills, I assume it would have been helpful in your game to have a reference to them as well? With the current format of the section, it wouldn't be too difficult to just include every skill in the next update of the sheet if people would find it beneficial. (Which would probably be later this week, once I have time to go through the 1.3 errata that should release later today.)


This is amazing! Please keep it up and release one along with the full release of the game!


It is handy sometimes to be able to see which character has the highest bonus in a skill at a glance. If I prompt a check, I generally ask the character with the highest (or sometimes lowest) bonus to roll first to avoid roll blockage :)

Great stuff though, really useful tool, it is getting run out again for my 2nd campaign tomorrow.


Updated for 1.3 Playtest Rules

In addition to the rules update, I also added a bunch of small features/fixes to the sheet (like including all skills on the party tab). My favorites are the Item Quality table on the Treasure tab (which combines the item tables from page 190 and page 370), and the new "Short-Term Skills" under Exploration Mode. The idea behind short-term skills is to collect many of the 10min skill activities that players are likely to want to do while in-between combat or while someone else is treating wounds.

Nathan Atkinson wrote:
This is amazing! Please keep it up and release one along with the full release of the game!

Thanks~ My current plan is to try to keep the sheets updated throughout the playtest within a week of new rules updates being posted. As for the full release, that'll probably take a bit longer, but I'll certainly be looking to make an updated copy for my own use and share it when I can.

---
Finally, if you like my GM Sheet, be sure to check out the Character Sheet I made for the Playtest: http://paizo.com/threads/rzs429qz?Online-Character-Sheet


1 person marked this as a favorite.

Updated for 1.4 Playtest Rules


1 person marked this as a favorite.

Thanks for all your work on this. Fantastic tool.

Scarab Sages

Really helpfull.
Nice job !


Pathfinder Adventure Path, Campaign Setting, Card Game, Companion, Modules, Pawns, Roleplaying Game, Starfinder Accessories, Starfinder Adventure Path, Starfinder Roleplaying Game, Starfinder Society Roleplaying Guild, Tales Subscriber; Pathfinder Deluxe Comics Subscriber

Very nice! Well done!


Gonna give this a shot Sunday for Heroes of Undarin. Currently I use two monitors and an iPad to keep track of everything. One monitor has roll20 full screen and the other is split between my pdf viewer and browser. And the iPad is my scratchpad for HP/conditions etc

My biggest pain is switching between PDFs for rules, monster stats, and adventure text and then on my browser switching between character sheets and tracking sheets. Hopefully this will help consolidate things and reduce the switching required!

Thanks!

Community / Forums / Pathfinder / Pathfinder Playtest / Game Master Rules / Running the Game / Massive GM Sheet (Google Sheets) All Messageboards

Want to post a reply? Sign in.
Recent threads in Running the Game