ABCDEFGHIJKL
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