A | B | C | D | E | F | G | H | I | J | K | L | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | This is a tool to assist your Harrow readings, as described in Paizo's Harrow Pathfinder Chronicle. No Harrow Deck? No problem! Grab a regular deck of cards and you're set | |||||||||||
2 | ||||||||||||
3 | Programming notes and boring stuff: | |||||||||||
4 | The drop-down boxes in the Harrow Mat will reject incorrect inputs, but cannot detect duplicates | |||||||||||
5 | The drop-down boxes in the Harrow Mat are the only input needed! Most of the other cells have formulas. | |||||||||||
6 | The "Copy of Harrow" deck sheet is both for your own reference, and for the formulas in the Harrow mat. You can hide it but don't delete it! | |||||||||||
7 | I had to brute force most of the conditional formatting. It's inelegant but it works | |||||||||||
8 | ||||||||||||
9 | How to use | |||||||||||
10 | This spreadsheet supports up to 6 players in your reading. For each, pick the Role card they chose from the dropdown menus in the ROLE CARD section | |||||||||||
11 | Once you've dealt the nine cards for your reading, fill them in to the appropriate drop down box in the HARROW MAT section. Any relevant (ie, cards you should interpret) will be highlighted as follows: | |||||||||||
12 | ||||||||||||
13 | Card names in this colour match a role card dealt to one of your players. You should interpret this card before any others! | |||||||||||
14 | Cards with Alignment of this colour are "True Matches", and are the next most important to interpret | |||||||||||
15 | Cards with Alignment of this colour are "Opposite Matches", and are almost as important as true matches, but hold an opposite meaning to what the card normally would | |||||||||||
16 | Cards with Alignment of this colour are "Partial Matches", only to be interpreted if no True or Opposite Matches exist | |||||||||||
17 | "Irrelevant" (UNLESS IT IS A ROLE CARD) cards will have an Alignment this colour/background | |||||||||||
18 | ||||||||||||
19 | In the example I've filled in: | |||||||||||
20 | The Role Cards are all from the suit of Book (INT) | |||||||||||
21 | In the first column (Past) you would interpret "The Hidden Truth" AND "The Snakebite" as both are Role Cards | |||||||||||
22 | In the Second Column (Present), you would interpret "The Theatre" as it is an Opposite Match | |||||||||||
23 | In the Third Column (Future), you would interpret "The Unicorn" as it is a true match | |||||||||||
24 |