Is there a spreadsheet that splts cash loot between players, so that there is almost none left over?

[Whimsical]

Is there a spreadsheet, app, or other internet resource that will evenly divide and distribute coin, gem, and other currency monetary rewards between player characters?

For example, players gain treasure that is 17 100 gp gems, 90 platinum pieces, 2800 gold pieces, 8000 silver pieces, 400 copper pieces.
Where the total gold piece value equals 6204 gp.

I would like to be able to enter these values in a program and have it figure out the best way to allocate the currency items into shares as equally as possible with the least amount of remainder.

Like this:

Split [B]four[/B] ways: 
• Three bundles of [B]4[/B] 100 gp gems, [B]25[/B] PP, [B]700[/B] GP, [B]2000[/B] SP, [B]100[/B] CP
• One bundle of    [B]5[/B] 100 gp gems, [B]15[/B] PP, [B]700[/B] GP, [B]2000[/B] SP, [B]100[/B] CP
They each equal [B]1551[/B] GP

Split [B]five[/B] ways:
• Four bundles of  [B]3[/B] 100 gp gems, [B]22[/B] PP, [B]560[/B] GP, [B]1600[/B] SP, [B]80[/B] CP
• One bundle of    [B]5[/B] 100 gp gems,  [B]2[/B] PP, [B]560[/B] GP, [B]1600[/B] SP, [B]80[/B] CP
They each equal [B]1240.8[/B] GP

Split [B]six[/B] ways:
• Five bundles of  [B]2[/B] 100 gp gems, [B]18[/B] PP, [B]520[/B] GP, [B]1333[/B] SP, [B]70[/B] CP
• One bundle of    [B]7[/B] 100 gp gems,  [B]0[/B] PP, [B]200[/B] GP, [B]1335[/B] SP, [B]50[/B] CP
They each equal [B]1034[/B] GP

Bonus points if can do uneven shares. For example, if cohorts get half shares.

---

Search tags: D&D, Dungeons & Dragons, Pathfinder

 

[Lanefan]

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 coins
Have 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 | 100
Bjarnni | 100
Calliandre | 100
Deirdre | 100
Elena | 50
Falstaffe | 67

Below 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.

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