I've spent like 2 hours updating the spreadsheet so that it can compute and store the statistic properties of several systems at once. (Ignore the auxiliary column, that's just to keep track of the position of the last '--' marker.) My god, was that stressful.
Fun challenge: try to find out what the hell this spreadsheet formula even does.
=IF(A2 = "--", SQRT(SUMPRODUCT(INDIRECT(CONCAT("B",G2)):B1, POW(MINUS(D2, INDIRECT(CONCAT("C",G2)):C1),2))), "")
I've already forgotten half of it, and I
wrote it. Maintaining this thing is going to be a mess.
In related news, I've been trying to find the best parameters for our quest loans, although the lack of any decent quests from the Ranger's Guild definitely does make it hard to make accurate risk assessments. I've analyzed the boar hunt, though.
Boar Hunt
Description: A wild boar has been stealing food from livestock and causing damage to fences. This creature is quite a handful, and may get away from you. (80% success rate)
Cost: 2 gold
Reward: 4 gold
This has an expected value of 1.2, standard deviation of 1.6, and risk-to-reward ratio of 1.33 (exactly four thirds, in fact.) The fact that this quest has no specified time length (and that the length would probably be too short for us to generate any decent income from interest, anyway) makes it impossible for me to draw up a loan program for this. Maybe we should ask the Ranger's Guild to provide estimated time lengths with their quests next time?