Control sheet

	D	E	F	G	H	J	K
1
2	AGENTS DOSSIER - CONTROL SHEET						v1.0
3	AGENTS LIST					GAME OPTIONS
4	ID	Agent Sheet URL	Player	Name	Background	Options
5	1					Game Mode	Mirror
6	2					Nº Players	4
7	3					Cherries at	8
8	4
9	5
10	6
11	7					IMPORTANT
12	8					WRITE	DON'T WRITE
13
14	WHAT IS THIS AND HOW IT WORKS?
15	This is an attempt to create a character sheet using Google Sheets for the Night's Black Agents RPG game and specifically for the Dracula Dossier campaign. The idea is to have a Control Sheet for the Game Director from which to specify the game options and integrate the information of the different players, which is recorded in the Player Sheets (this one where you are). Initially I wanted to solve the problem of registering the Trust between the different players without having them to share it to each other manually. But it is possible that it got a bit too complicated.
16
17
18
19
20	INSTRUCTIONS
21	The first thing you need to be able to start is to have a Control Sheet and the Character Sheets linked correctly. 1. Make a copy of the Character Sheet template for each of your players. You can find the Agents Sheet template and instructions on how to fill them out in this same folder. Include at least the following information before continuing: Personal sheet: - Real Name: it will be used initially to inform the Agent field, which in turn is used as a primary key to retrieve different information and cross it between the different sheets. Later on, you can use the Alias field instead if you prefer. Data sheet - Control Sheet URL: The URL of this Control sheet you are on. It is necessary to be able to link the different pages. It has this format: https://docs.google.com/spreadsheets/d/1Vihc2TOq1_HHsNdIddbBFZcMUBc72yMvz2CDBIHpb7c 2. Copy the URL of the Character Sheet in the Agents Sheet URL box that you can find on top of this page. The Player, Agent, and Background fields should update automatically (if included). 3. Choose the game options, also at the top of this page. Choose the Game Mode and select the Nº Players to be able to define the Build Points available for your players. Choose from what value the Cherries are awarded. 4. You should now have everything ready for your players to fill out their Character Sheets
22
23
24
25
26
27
28
29
30
31
32	AN ADVICE...
33	These sheets make heavy use of Google Sheet functions that depend on the position of the cells they reference (ImportRange, Query, etc.). Including new columns or rows or modifying existing ones is an almost sure bet that everything will break. If you don't have a good knowledge of Google Sheet, I recommend you to keep your hands to yourself :) Also, I don't consider myself an expert, so it is likely that many things could have been done better in another way. In fact it is possible that there are things in the game system that are not well implemented or not implemented at all. Keep in mind that I'm just a player myself and I didn't even had access to the full manual while implementing these sheets! If you have any suggestions for improvements or have found a bug, let me know and I'll fix it if I can. Contact me at: yagoroig@gmail.com
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