| Anchor | ||||
|---|---|---|---|---|
|
| Info |
|---|
Welcome to the highly requested |
...
Relationship guide! |
...
you will find all the events and their corresponding choices that |
...
results in a change to a characters relationship value with the |
...
| Note |
|---|
IMPORTANT |
| Note |
|---|
If you jump back into the spreadsheet and certain events are “missing”. It means you have an active filter somewhere. Check the headings and clear any active filters. See Clearing Filters for help |
Filtering
...
main character |
| Note |
|---|
WARNING. See Filtering |
...
Filtering
In order to filter, you first have to create a filter view.
Click on the (1) Cell A5 → (2) Data tab → (3) Filter Views → (4) Create new filter view
...
For tips on how to filter effectively check out these examples: Use Case 1, Use Case 2 and , Use Case 3
...
| Anchor |
|---|
...
|
...
|
...
Use Case
I would like to see all relationship events in Episode 1 only
Click the filter icon next to “Episode”
...
2. Ensure you have the “Filter by values” dropdown enabled (Red box). Deselect “4”, then select “1” from the list all apart from “1” and click “OK”.
Alternatively you can also filter by condition
...
Back to top
...
| Anchor | ||||
|---|---|---|---|---|
|
Use Case 2
I would like to see all events that contribute relationship points to Elise
Click the Filter Icon next to “Elise”. Deselect “Blanks” and click OK.
...
Back to top
...
| Anchor | ||||
|---|---|---|---|---|
|
Use Case 3
I would like to see all events in Episode 1 and 2 that contribute to Alannah points
Here, we will be applying the logic from Use Case 1 and Use Case 2
In no particular order, click the filter Icon next to Episode. Deselect everything apart from “1” and “2” and click “OK”
...
2. Then click the filter icon next to “Alannah”. Deselect “Blank” and click “OK”
...
Back to top
...
| Anchor | ||||
|---|---|---|---|---|
|
Clearing Filters
To clear any filters, you should see an active filter icon on one of the headings. Click the icon and click “Select All” then “OK”
...