I made these spreadsheets because I noticed a lot of people struggle with various aspects of Book of Hours; if even one other person finds these spreadsheets helpful, then they've done their job. They have been updated for the House of Light content, per the wiki as of October 18th, 2024.

If you notice anything wrong with any of the spreadsheets, please let me know, and I'll try to fix it as soon as possible. You are more than welcome to make copies of these spreadsheets for yourself, if you'd like; however, please note that I will not offer support if you mess around with the data in those copies and break the formulas.

Updated for House of Light
A spreadsheet to assist with Crafting; this is just charts of all possible Crafts in the game. There are 5 tabs:

• Information, which is notes about the spreadsheet and a legend for which colours were assigned to which Principle.
  
• By Skill, which lists all Skills, in alphabetical order; what amount of which Principle is required for the craft; any additional requirements; and a recommended Workstation to craft at.
  
• By Item, which lists all Items, in alphabetical order; what Skills can be used to Craft it; the amount of which Principle is required to craft it with that Skill; any additional requirements; and a recommended Workstation to use with that Skill.
  
• Cooking, which is all the new cooking recipes added with House of Light (per the wiki as of this writing), including the new Beverage and Cooking Ingredient recipes.
  
• Other Recipes, which includes Chandelry, Wire making, and Contamination Removal.

The By Skill and By Item tabs are broken up into 3 sets of columns to minimise the amount of scrolling up and down; you can browse the lists if you want, but it's better if you already know the name of the Skill you want to use or the Item you want to craft when looking through the tabs, so you can search the correct column. CTRL+F will work, too, of course.

The Cooking tab is broken up into Beverages, Cooking Ingredients, and then the various courses; some dishes can be used for multiple courses in a Salon (such as being both First Course and Main Course), and will be listed in all applicable columns.

Please make sure you're reading notes on the Workstations in the By Skill and By Item tabs if you get stuck; they'll be helpful if you're struggling to figure out how to craft a particular item or reach the required amount of the right Principle.

https://docs.google.com/spreadsheets/d/1JrAY0hBT50SFYgxtFLXlVZjEi7-M1oCQep_M3Tjr6YA

Updated for House of Light
A spreadsheet to assist with Curing Maladies from your Elements of the Soul; select the Element of the Soul that has a Malady from the drop-down menu, and it will auto-populate with a list of Beds, healthy Elements of the Soul, Skills, Memories, and Beverages that can be used to cure the Malady.

You must use a Bed and a Beverage, all others are optional, so if you can get to the required number of the needed Aspect with just two things (Beverage, Memory, Skill, Soul), you do not need to provide any of the others.

Any Beverage can go in any Bed and cure any Malady, so you do not need to use a Beverage listed by the sheet, but the ones listed will add to the needed Aspect total, making it easier to reach.

All Beds accept anything with a Heart Aspect, which the spreadsheet does not account for; it is entirely possible to cure Maladies in any Bed using things not listed by the spreadsheet by using things with a Heart Aspect.

https://docs.google.com/spreadsheets/d/1DyC-yo4vLZ03RP0GbqnzKMOShn-ERurPWtGaUsd3320

Updated for House of Light
A spreadsheet to assist with Evolving Elements of the Soul; select the Skill you want to use to Evolve from the drop down, select the Wisdom you Committed the Skill to, and it will auto-populate with the Element of the Soul you got from it, a list of Workstations you can slot the Skill and a pair of that Element of the Soul into, state whether or not you'll need to add a Memory with the "Evolve via [Wisdom]" Aspect, and a list of Memories with the correct "Evolve via [Wisdom]".

https://docs.google.com/spreadsheets/d/1GIM_8bCXNz7lQ3da0B6Y7nFHWIUkJWT8B8qSoKTQmQw