![[Pathfinder Society] GM Shared Prep](/e107_images/logo.png){kind=logo}
Research Autosheets
doughahn, Mon Aug 23 2021, 03:23am
Some basic automation using two spreadsheets: a hidden one for GM stuff, and a player one showing what they have available.
The secret sheet feeds to the players' sheet and reveals info to them based on simple logic to show/hide stuff. To use, make a copy of both and re-link your own GM sheet in A1 of the Player sheet.
Feela a tad over-engineered but I am hoping it helps players visualize what they have available to research, and what sort of progress they are making.
doughahn, Mon Aug 23 2021, 03:23am
Some basic automation using two spreadsheets: a hidden one for GM stuff, and a player one showing what they have available.
The secret sheet feeds to the players' sheet and reveals info to them based on simple logic to show/hide stuff. To use, make a copy of both and re-link your own GM sheet in A1 of the Player sheet.
- On the first page of the GM sheet, tick off areas and topics as they become available. They will be revealed to the players on their side of things. Until you check them off, they stay hidden.
- When a research topic and location are both revealed to players, the associated skill checks and DCs will appear for the players on their sheet.
- Check off successful research attempts on the "FeedSheet" as they go. This will automatically tally successes and reveal knowledge as they progress.
Feela a tad over-engineered but I am hoping it helps players visualize what they have available to research, and what sort of progress they are making.
- GM Sheet: https://docs.google.com/spreadsheets/d/1UlFi--FbhlqyzWmQoCJ_0qrqTPWKWpTEB1a4xhT4hcI/edit?usp=sharing