Reply to thread

Message: <blockquote data-quote="Lanefan" data-source="post: 7359704" data-attributes="member: 29398">Trivially easy to program into Excel for yourself.  It must be easy, as I've done it and my knowledge of Excel would fit on a pinhead.The steps required (see below for rationale):Have a field to enter each magic item found, and each non-magic item found, along with a field in the next column for the cash value in g.p. for each.Have a single field (A) at the bottom that is the sum of all these item-value fields.Have a field to enter the total amount of each type of coin (c.p., s.p., etc.) found, with another field in the column next to it that has the formula to convert each into its g.p. equivalent.Have a field for total party expenses expressed as a negative number of g.p.Have a field (B) at the bottom that is the sum of the expenses field and all the g.p. equivalent fields from the coinsHave a field (C) which is the sum of (A) and (B)Now here's the tricky bit that makes this work.Have a field for the name of each character who would be getting a share.  Next to this have another field for the relative value of their share expressed as a % of a full share (thus someone getting a full share would show 100 here, someone getting a half-share would show 50, and so on).  An example of what this would look like, using '|' to represent a field divider:Aloysius | 100Bjarnni | 100Calliandre | 100Deirdre | 100Elena | 50Falstaffe | 67Below all this have a field (D) that sums up all the share amounts listed (in this example it would show 517) - this is how many "share units" in total there are.Use another field (E) for the formula (C) divided by (D) to give the worth of a single share unit.In a third column next to each character put the formula where (E) is multiplied by that character's number of share units and you'll get each character's share down to as many decimal points as you want. <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile    :)"  data-smilie="1"data-shortname=":)" />Now, why do I list each item individually?  Simple.  Once this is all done up and printed out you can use the printout as a 'claiming list', where characters put their names next to items they want to claim for their own from the treasury; a process made much easier by having the item values and the character shares all listed in one place.Separating the cash out gives an idea of how much liquidity the party has, if required.Lanefan</blockquote>

Verification