Last night I was making an NPC that did Harrow readings. I wanted to see how likely it was to provide a benefit vs. a penalty. So I made a spreadsheet. Find it here.
Let me know what you think, and any suggestions.
/cevah
Bump.
I like that it gives a FAST summary, and I've worked out most of how it works ... but what function do B5 and B7 have on Sheet1?
The only other suggestion I have, is: Give a brief walk-through on how things work, what active things should be changes, and what active things should NOT be changed.
One thing I've started doing with my own widgets, is color code Inputs as one color, and Outputs as another. This may be something you want to consider.
As a physical deck is amongst my collection, I am unlikely to use this often (The deck is a thing of Beauty), but I can see serious use for anyone who does NOT own a deck, as the speed is excellent.
B5 & B7: bug. Fixed it. They give the long text of the alignment listed.
I color coded the input.
Hit [recalc] to generate a new reading.
. Cells A3, A5, and A7 -- Inputs
. Cells E2:E10 -- What cards do you draw
. Cells A13 and A15 -- Summary of results
. Others -- Descriptions of the summary
Sheet 2
. Cells A2:B7 -- Lookup for random card suit
. Cells D2:E7 -- Lookup for suit's meaning
. Cells H2:J11 -- Lookup for random card value
. Cells L2:N10 -- Lookup for alignment text and opposed alignment
. Cells A14:B22 -- Random numbers to determine the drawn card
. Cells C14:C22 -- Card's alignment
. Cells D14:D22 -- Card's suit
. Cells E11:E22 -- Card's effect
. Cells F11:F22 -- Card's benefit/penalty due to alignment
. Cells G11:L22 -- Split out benefit/penalty into suit
. Cells M11:R22 -- Split out penalties
. Cells S11:X22 -- Split out benefits
. Cells M23:R23 -- Sum of penalties by suit
. Cells S23:X23 -- Sum of benefits by suit
. Cells M24:R24 -- Description of penalties by suit
. Cells S24:X24 -- Description of benefits by suit
. Cell M25 -- Aggregate description of penalties
. Cell S25 -- Aggregate description of penalties
. Cell M26 -- Cleaned up description of penalties
. Cell S26 -- Cleaned up description of penalties
/cevah
Thank you! I appreciate the update / information.
A Suggestion, for anyone who wants to use this to handle some of the prestige class abilities too,
Is to do the
On sheet 1. Add a column of the 6 suits. I used Cell A19 as my initial location for the first entry, and worked down.
Hammer
Key
Shield
Book
Star
Crown
In the column NEXT to each, add the following formula
=COUNTIF(Sheet2!$D$14:$D$22,A19)
Where, A19, is the cell you entered Hammer, and A20 is the cell you entered Key, etc.
This will result in the following example output.
Hammer 1
Key 2
Shield 4
Book 2
Star 0
Crown 0
Based on the example spread of:
Draw your cards:
3 of Shields, gives 1 on Fortitude saving throws
3 of Keys, gives 1 on Reflex saving throws
1 of Books, gives 2 on Skill checks
4 of Keys, gives 1 on Reflex saving throws
3 of Shields, gives 1 on Fortitude saving throws
4 of Books, gives 1 on Skill checks
9 of Shields, gives -1 on Fortitude saving throws
7 of Hammers, gives 1 on Attack rolls (ranged and melee)
8 of Shields, gives 1 on Fortitude saving throws
You can then add further customization by adding in notes next to the output, to reference what each Tower Result would be or Blessing of the Harrow in the columns next to your output, likely Column C based on the above example.
I recommend for HARROW CASTING (which is a 3 card spread), just adding a set of 6 references, like:
=Sheet2!D14 Next to =Sheet2!C14
=Sheet2!D15 Next to =Sheet2!C15
=Sheet2!D16 Next to =Sheet2!C16
There is also the following option if you REALLY wanted, but it's messier.
=COUNTIF(Sheet2!$D$14:$D$16,A19)+IF(AND(Sheet2!$D$14=A19,Sheet2!C14=A3),1,0 )+IF(AND(Sheet2!$D$15=A19,Sheet2!C14=A3),1,0)+IF(AND(Sheet2!$D$16=A19,Sheet 2!C14=A3),1,0)
It counts up the number of items of each suit, and then adds 1 if the Alignment matches. It's just not as elegant as the basic Countif.
| 1 person marked this as a favorite. |
It takes more work than you think. I have updated the spreadsheet with all the Harrower stuff.
I moved some stuff down on the first page.
Added the Blessing of the Harrow result.
Added the assorted Tower abilities for a Harrow Casting
Added the Spirit Deck
Added the capstone Read the Signs and calculated the changes it makes
Sheet2
I extended the draw to 11 cards
G23:L23 -- Suit count for Blessing of the Harrow
G24:L24 -- Blessing of the Harrow effect if high count
G25 -- Number of ties for top count
H25 -- All strings from G24:L24 in one cell, separated by commas
G26 -- Random number from 1 to number of ties
H26 -- Selected random entry of H25
C27:C29 -- Harrow Casting value of first three draws
G27:L29 -- Harrow Casting value by suit
G30:L30 -- Total for Harrow Casting value by suit
G31:L31 -- Text for Harrow Casting by suit
C32 -- Read the Signs for Harrow Casting
G32:L32 -- Read the Signs for Harrow Casting value by suit
G33:L33 -- Read the Signs for Total for Harrow Casting value by suit
G34:L34 -- Read the Signs for Text for Harrow Casting by suit
Y14:Y24 -- Spirit Deck damage by card
Z13:Z23 -- Spirit Deck cumulative damage
AA13:AA23 -- Lowest damage card for Spirit Deck so far
AA24 -- Lowest damage card for Spirit Deck
Z24 -- Damage change by Read the Signs for Spirit Deck
/cevah
| 1 person marked this as a favorite. |
Late last night I was pondering on my harrow spreadsheet and I realized that the suggested simulation of a d6 & d10 can generate duplicates, where an actual deck will not. So I decided to add a shuffle mechanism to do a real draw.
Ack! I only selected from 4 suits, not six! Good thing I am replacing this.
Sheet 1
. Renamed "Summary"
. No Changes
Sheet 2
. Renamed "Calculations"
. Cells A14:B22 -- Read draw from Sheet 3
Sheet 3
. Named "Shuffle"
. Cell B1 -- Suits in the deck
. Cell B2 -- Ranks in each Suit
. Cell B3 -- Total cards in the deck
. Cells D6:D17 -- Number of cards left in the deck for this draw
. Cells E6:E17 & F5:Q5 -- Which draw this row/column represents
. Cells F6:F17 -- Random draw from the remaining deck
. Cells G6:Q17 -- Adjusting the draw from the deck[1]
. Cells A6:A17 -- Adjusted draw from the deck
. Cells B6:B17 -- Rank of the draw
. Cells C6:C17 -- Suit of the draw
[1]Formula is complicated, so here are it's parts:
1 Determine if the current cell should be compared to a previous draw, if not then show 0
2 Determine if this draw would have been after the card previously drawn and if so add 1
3 By using 0 for an invalid compare, I can use a MAX() function to determine the final adjusted number for column A.
/cevah