WorldStateDemoSpreadsheet

	A	C	D	E
1	Welcome to the WorldState Spreadsheet by thrownerror! NEW VERSION v2 Changes: Fixed legacy bug with odd behavior towards end of tables Added the requested "Unknown" element to faction relationships. This value will not change and will remain static in it's one-way direction until manually changed to a different value. This lets factions have one-direcitonal relationships, and can help keep track of edge-case groups, like mercenaries the players don't know about, etc. Please read this before continuing: This project is dedicated to helping run tabletop games where the game runner needs to manage a number of groups of NPCs. This design came about from attempting to find ways of offloading work between sessions to a tool, rather than the Game Master. It still relies on the game master adding context to the results, but this is intended to offload some of the maintenance. It's also intended to allow opportunities that aren't necessarily planned, and help factions feel like they're interacting even when players aren't around. To that end, it helps keep track of how factions feel about one another, generating quests, and keeping track of how groups are connected. This project is intended for Game Masters who are used to improving, providing things closer to prompts than as-is situations. As with every tool, your mileage may vary. To the right is a list of what's included in this sheet. This list is subject to change as I add components, but this is a rundown as is. The sheet does rely on a mix of GoogleAppScript code and in-sheet cell logic. It will require your permission the first time you press a button to execute code. If you are worried about what is happening, you can check the manual, which includes a list of every function and a full copy of the code. It also may take a moment to create the pop-up Google sign-in to run the code, so it might not appear immediatley. If you would like to use this, I make a local copy of it to ensure it runs properly. Just add it to your personal Google Drive. I do not guarantee behavior outside of Google Drive. Mobile also does not fully work, it is recommended to use on a computer.	Sheet guide:
2		Sheet Name	Intention	Depends on:
3		Welcome!	Provide an introduction and resources	None
4		Faction Information	Where the number of factions and their names are inputed for later information.	None
5		Faction Relationships	Where the relationship between factions is displayed and can be interpretated.	Faction Information
6		Faction Connections Input	Stores fields for how generation of faction connections. These connections can be seen as trade routes, borders, etc. Default values are displayed here.	None
7		Faction Connections	Displayes generated faction connections.	Faction Information, Faction Connections Input
8		Random Events	Random number generator. Allows modifiers, input, and gaussian distribution (bell curves)	None
9		Quest Generator Input	Input for editing the generation of quests.	Faction Information
10		Quest Generator	Displays generated quests.	Faction Information, Quest Generator Input
11
12		Input cells are shown in this color.	Standard cells are shown in this color.
13		Pure output cells are shown in this color.	Button background cells are shown in this color
14		Buttons are shown in this color.
15
16		Manual and documentation:	https://docs.google.com/document/d/1wHWfhkBdcPmoqFSfPvsP6aTNZB2yu0WlGZw-I6_qfGo/edit?usp=sharing
17		Actual sheet:	https://docs.google.com/spreadsheets/d/1NhfZxgdow5snB1d3vd3fGmCE61mnQk3l1BgKASRaL_0/edit?usp=sharing
18
19		Feedback or suggestions?
20		Feel free to message me on twitter or reddit, I'm thrownerror on both. If you want to reach out to me by email, please reach out and DM me on either of those platforms so I can give you my email.	If you have errors, please attach a copy of your instance of the spreadsheet so I can see the issue, or at least a description of the issue. I can't guaranteed the speed of a response, but I will be working on this continuosly
21			Provided under the MIT license. Full details available within the documentation. If you would like to share edits or modifications. ensure that you maintain proper credit and sourcing.
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100