Started setting it up. Sent a PM to ghostofmars with some questions about setting it all up.
I'm curious as to how it works to hide specific tabs/sheets. If I click on the tab there is an option to hide the sheet. But then how can I view it as the mod without unhiding it? The on-going game has a link to what is presumably the master document, with all but the main sheet hidden. How does ghostofmars view the other sheets without making all of it public? I suppose I could just save an extra copy of the table somewhere else?
I also don't see where to randomize all the cards for foraging. And are the artifacts not randomized?
I send already a PM with the questions you asked there. The new design doesn't need the hidden sheet anymore after setup. There is actually also a hidden sheet in the first game.
In the first game I have a different layout
master player<-game
So a separate master sheet, where I have stored the lookup table for the potions. Player sheets with the individual ingredients. The game imports the sum of the ingredients from the player sheets. The disadvantage is that I have to touch the master sheet to look up the potion, then the player sheet to remove the ingredients and finally the game sheet to modify e.g. the potions left for the adventurer.
The new version has an improved layout
master/game<-player
The game sheet is merged with master sheet and each player imports all public and his private information from the master. Hence, you only need to modify the master sheet and all players will immediately see the changes.
For foraging you roll the die 5 times and write down the ingredient and then copy them all to the public_information sheet.