User talk:Selerik

This is the default talk page text.

Bone Market Calculator v0.16

Hi, here is where you can get a copy of the Bone Market Calculator with my additions to it. All credit for the tool itself goes to Speicus, who developed it and worked out the bugs. I just gave it some minor adjustments.

Please leave me a note below if you like the additions to the tool or wish for me to suffer a thousand deaths. Either or, I take the making waves I can get.

Version	Date	Change Log	Editor
0.16	15 Aug 2022	[New] Added support for Segmented Ribcages	Selerik
		[New] Payouts influenced by the weekly quality are now underlined
		[Change] Improved readability of weekly qualities
		[Fix] Minor formatting improvements
		[Fix] Withered Tentacles/Warm Amber's valuation reduced
0.15	26 Jul 2022	[Fix] Jet Black Stingers now correctly show in the tally of Tails	Selerik
0.14	13 Jun 2022	[Fix] Typo corrected for A Pedagogically Inclined Grandmother	Selerik
		[Fix] Payout correction for An Ingenuous Malacologist. They deal in Collated Research, not Vital Intelligence
0.13	29 Apr 2022	[New] Market Estimates Now Available for Skeletons	Selerik
		[Fix] Additional Data added to the Valuation Tab
		[New] Obsidian Chitin Tail added to the Bone Market Calculator"
0.12	27 Apr 2022	[New] Added the Valuation Table as a new tab	Selerik
0.11	22 Apr 2022	[Fix] Skeleton with Seven Necks: Shows correct number of limbs needed	Selerik
0.10	4 Apr 2022	[Fix] Minor typos corrected	Selerik
		[Change] Tables were compacted to reduce space
		[Change] Formatting was enhanced to ease readability
		[Change] Header adjusted and trimmed
		[Change] Skeleton/Limb progress visible in header
		[Change] Added tracker for 4 more joints option
0.9	19 Dec 2021	[Fix] Torso types were not taken into account when determining available skeleton types.	Speicus
0.8	18 Dec 2021	[Fix] Fixed reward calculation several sellers. ROUNDDOWN was used instead of ROUND for several primary rewards.	Speicus
0.7	12 Dec 2021	[Fix] Fixed modifier formatting.	Speicus
0.6	25 Nov 2021	[Ench] Reorganized input fields for body parts. Improved intro.	Speicus

Calculations

Been testing this out today and it looks pretty good! I especialyl like the stylistic edits you've made: it makes it much easier to read at a glance.

That said, I noticed two mathematical oddities with the Best Offer calculator:
- You (erroneously?) value Warm Amber at 1.50 echoes, versus the generally accepted price of 0.10 echoes. This makes the Zailor with Peculiar Interests seem like a much better deal than he actually is.
- The sheet doesn't seem to take into account currency arbitrage: for example, if you enter a brass lollipop, it'll tell you that the Bohemian Sculptress is your best buyer- which is true when sold to the Bazaar, however, since the Constable and the Theologian will buy it from you in scrip, they are a better deal overall. Similarly, the Author of Gothic Tales is severely undervalued, as the Stygian Ivory he pays you in can be cashed out through the Midnight Market into Crackling Devices and then into Rat-Shillings, a chain of arbitrage which ends up giving him an effective 30% bonus. Kislev (talk) 20:21, 2 August 2022 (UTC)

Thanks for the feedback Kislev! I am doing some updates today, and they will include adjusting warm amber. The price was automatically calculated based on the bone market value of withered tentacles, and the conversion of 5 amber to 3 tentacles via a repeatable storylet. The calculator doesn't take into account the action cost of conversions (yet), so it does skew the value of things occasionally. Selerik (talk) 19:45, 15 August 2022 (UTC)

Removing a tail

Hi, I hope you are the right person to approach for further changes.

Could you add the option to Remove the tail from your (Skeleton Type)? Just adding the bonus from the tail under manual modifiers is not sufficient for me - having or not having the tail influences whether your skeleton qualifies for a particular body type. I suppose you could, theoritically, manually add the bonusses you would get from the tail as a manual bonus, but that gets cumbersome to remember to do and I am not sure it would cover all use cases.

I think the easiest way is adding a new row (say, after 57) and perform the validation calculation not on tails, but on Tails-A58. Cheers! RagCall (talk) 07:51, 15 August 2023 (UTC)

Counter-Church support for Five-Pointed Ribcage and Segmented Ribcage

The current code for CC Support generated by the Holy Relic does not support the Five-Pointed Ribcage, and does not calculate the Segemented Ribcage correctly, I think. The correct code for cell G43 should be =IF(OR(A6=TRUE,A7=TRUE),2,IF(A9=TRUE,3,IF(A10=TRUE,4,IF(A11=TRUE,5,IF(A12=TRUE,6,IF(A13=TRUE,7,IF(A14=TRUE,8,IF(A15=TRUE,10,(IF(A8=TRUE,11,0)))))))))) RagCall (talk) 09:45, 16 August 2023 (UTC)