Haven Calculator

[Schro]

Yoo it is I, ingame I'm usually playing as Bryn or Ferro.

Sooo I've decided to be a menace and share the sheets I've built last year.
Basically last year autism hit hard and I found an excellent way to do something else than studying for certificates.
Might help to even the playingfield a little for our Sprucecaps, while also providing some QoL for the rest, hopefully.
Feel free to copy / fork / suggest / report errors
Schro's Haven Sheet
Originally it was 100% streamed from brodgar wiki, including pictures, so I claim no credit over pictures or displayed data. Later converted it all into sheet-sided data, so Brodgar admin won't murder me. Did that fork around December 2023, so any additions/changes since then need to be added manually.
Preview:

Features/Usage:
If you want to use it, go to file -> 'make a copy' (might need a google acc for that)
Quality

• Quality Sheet: all blue Result cells have the wiki formulas. Just enter ingredient qualities or reference results for ingredients (i.e. board Q Result -> board Q ingredient of Herbalist table)
• Keep track of overall quality
• Calculate crafting recipe quality
• Calculate building quality
• Calculate building processing quality

Wounds

• Look up data on wounds by name,incl. partial matches. (Green C1 cell)
• Wound data include icon, remedy, causes and effects

Gilds

• Select search by Name or Bonus (Green B2 dropdown)
• Enter (partial) name or bonus stat (Green C1 cell)
• Enter (partial) gild Attribute(Green H1 cell)
• Gild data include icon, gild chance, gild 1 to 4 and gild attributes

Curios
This one might still be a bit funky, being the most complex of the bunch

• Narrow down by curio types: Crafted, Foraged, Misc, All (Green A1 dropdown)
• Filter selected curio table by (partial) name, min Base LP, max study time(h), max weight, min LP/H/W (Green D1,F1,G1,H1,M1 cell)
• Additional (very subjective) filter for crafted curios depending on craft effort (advanced/high) and if they somehow involve luck/less common encounters(Green N1,P1,R1 checkboxes)

Stuff about the formulas/editing for anyone interested:

Did some things in there google support claims not to be possible, heh. My favourit bits are the mediawiki picture stream (though I removed that part from this document so I won't get in trouble) and the script to jump back to the edited green cell on Wounds/Gilds/Curios. Did that 'cause I constantly accidentally edited the header column after entering data. That part is still a bit wonky due to the delay, so if you don't like that, just remove the script from your copy.
If you're feeling lucky and/or masochistic, you can find the back-end calculation sheets under View -> hidden sheets. The frontpage formulas are in A3 in Wounds, A3 in Gilds, B3 in Curios, knock yourself out!
Also added some comments inside some of the formulas, might help to figure out whats going on

So yea, thats that. Hope some of you find use for it.
Thinking about building a similar page for gildable clothing, not quite sure how to approach it yet, as in, if it'll just be a list or a calculator+recommendations or something, suggestions welcome.

[caz]

Thx for sharing

[lamegreen]

did you acquire this data ethically?

[Robben_DuMarsch]

Very useful! Thanks for doing this!

[Robben_DuMarsch]

Quick question:
In the curio spreadsheet, typing a number above total LP filters out curios with lower numbers - But typing a number in the green box above LP/H/W doesn't seem to do anything - How do I get that to sort/filter?
Same with Attribute in the Gilds tab.

[Dawidio123]

Quick question:
In the curio spreadsheet, typing a number above total LP filters out curios with lower numbers - But typing a number in the green box above LP/H/W doesn't seem to do anything - How do I get that to sort/filter?
Same with Attribute in the Gilds tab.

https://www.youtube.com/watch?v=Vl0H-qTclOg

[Schro]

did you acquire this data ethically?

The data was handled with care and empathy. No data was hurt in the production of this sheet.
Regarding the means of acquisition, can't remember, super foggy memory there, I'm sure its fine.

Quick question:
In the curio spreadsheet, typing a number above total LP filters out curios with lower numbers - But typing a number in the green box above LP/H/W doesn't seem to do anything - How do I get that to sort/filter?
Same with Attribute in the Gilds tab.

ah, just noticed that bit formula is missing in curios, thanks, should be fixed now.
similar with gilds, the filter wasn't applied if nothing was entered as a bonus or name, fixed that, I think.

[maze]

I've never seen such a clean and amazing spreadsheet before.