ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
AboutLink
2
This is a tool for making managing your character in stillfleet... maybe easier? I like doing things in excel or sheets as I don't need dice then and can track everything and easily take notes all in one place. Maybe other people will find any of this useful, who knows. AboutLinkhttps://docs.google.com/spreadsheets/d/1y-6M5cuZzqI119IVRjoehDkubJD9xPrGQlqu7_cZj6c/edit?gid=521937401#rangeid=722790956
3
Still to do:Status
4
WHAT DO THE DIFFERENT COLOR CELLS MEAN?WORKSHEET BREAKDOWNLoot Roller
5
Cells that have a white background are for people to modifyWorksheetDescriptionCharacter Roller
6
Cells with a light red background have equations in themBasic Character InfoName Roller
7
Cells like this are title and description cellsCharacter SheetFinish Character sheet arrangementX
8
Cells like this are selectable dropdowns for powers, classes, etc.JournalFind more typos
9
Black is usually found in hidden columns to the left of each worksheet, it denotes the columns that should be rehidden when done with whatever notes/comments/calculators exist thereDice RollerMake a clean and empty sheet for future use/dissemination
10
Powersneed to design the tech calculator
11
0METHODS USED FOR ACCOMPLISHING FORMULA THINGSLeveling2nd Character (for pets or if the user is controlling 2 characters)
12
1Rand between listsGearadd a mob selector to the dice roller page
13
1.1INDEX(A1:A10,RANDBETWEEN(1,10))Char Generatorcharacter importer and exporter
14
1.2For a list of 10 items, this precludes setting up a dice roller to get a result and simply allows for a random result from a list with any re-rollLocationsadd.... lets say 5 attack rolls and damage rolls for each weapon
15
1.3Data and Tables
16
2RAND BETWEEN ARRAYS (ROLLING N DICE OF X SIDES AND SUMMING RESULTS)TyposA list of typos I've found in the CRB. Kept because of.... reasons.
Consolidate all character information into a single sheet so that you can just copy the page and make a new character easily?
17
2.1Adapted my previous excel work for multiple dice into the new dice roller in the character sheetadd a random mob selecter to dice roller page
18
2.2SUM(ARRAYFORMULA(RANDBETWEEN(1,(ROW(INDEX($A:$A,1):INDEX($A:$A,n))<=n)*x)))
for said dice roller, add selector for mob counts, morale management, and attack and damage rolls
19
2.3use the above and simply replace n and x with the appropriate cell references
20
2.4
21
3Hyperlinking method
22
3.1Powers!$O$12
23
3.2O12
24
3.3Right click on target cell, other cell actions, get link
25
3.4use provided link and remove anything after the "=" sign
26
3.5e.g. https://docs.google.com/spreadsheets/d/1y-6M5cuZzqI119IVRjoehDkubJD9xPrGQlqu7_cZj6c/edit#gid=1829415059&range=J12 loses "J12"
27
3.6Put it all together
28
3.7Full Desc.
29
3.8add an if statement for it there isn't a power selected for that slot
30
3.9
31
4UNIQUE List from entire column
32
4.1UNIQUE('Data and Tables'!C:C,false,false)
33
4.2This version of this formila extracts a dynamic list from an entire column and spits out a distinct list of all vaues in the column
34
4.3
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