Editing 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 [https://docs.google.com/spreadsheets/d/1uxO_EUnSH0Us6YB7r4RDzUie9CM0GnsC_v5z3cKEiUk/ my additions to it]. All credit for the tool itself goes to [[User_talk:Speicus|Speicus]], who developed it and worked out the bugs. I just gave it some minor adjustments.<br><br>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.<br>

{| border="1" cellpadding="2" cellspacing="1"
! scope="col"|Version
! scope="col"|Date
! scope="col"|Change Log
! scope="col"|Editor
|-
|rowspan="5"|0.16
|rowspan="5"|15 Aug 2022
|[New] Added support for Segmented Ribcages
|rowspan="5"|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
|-
|rowspan="1"|0.15
|rowspan="1"|26 Jul 2022
|[Fix] Jet Black Stingers now correctly show in the tally of Tails
|rowspan="1"|Selerik
|-
|rowspan="2"|0.14
|rowspan="2"|13 Jun 2022
|[Fix] Typo corrected for A Pedagogically Inclined Grandmother
|rowspan="2"|Selerik
|-
|[Fix] Payout correction for An Ingenuous Malacologist. They deal in Collated Research, not Vital Intelligence
|-
|rowspan="3"|0.13
|rowspan="3"|29 Apr 2022
|[New] Market Estimates Now Available for Skeletons
|rowspan="3"|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
|-
|rowspan="6"|0.10
|rowspan="6"|4 Apr 2022
|[Fix] Minor typos corrected
|rowspan="6"|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:<br>
- 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.<br>
- 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. [[User:Kislev|Kislev]] ([[User talk: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. [[User:Selerik|Selerik]] ([[User talk: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! [[User:RagCall|RagCall]] ([[User talk: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 <code>=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,12,0))))))))))</code> [[User:RagCall|RagCall]] ([[User talk:RagCall|talk]]) 09:45, 16 August 2023 (UTC)
Latest revision		Your text
Line 106:		Line 106:

	== Counter-Church support for Five-Pointed Ribcage and Segmented Ribcage ==		== 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 <code>=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))))))))))</code> [[User:RagCall\|RagCall]] ([[User talk:RagCall\|talk]]) 09:45, 16 August 2023 (UTC)	+	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 <code>=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,12,0))))))))))</code> [[User:RagCall\|RagCall]] ([[User talk:RagCall\|talk]]) 09:45, 16 August 2023 (UTC)