Make a fair split of shared trip expenses

Replace the bracketed details or make it yours using the form.

I want to make a fair split of shared trip expenses. Calculate who paid, who participated, and proposed settlements from explicit allocation rules.

Use these inputs:
Expense table: [Add expense table]
Participants: [Add participants]
Split rules: [Add split rules]

Create: Expense split table.
Preserve source rows and units, explain transformations, and show checkable calculations. Do not invent missing data.
Make the result specific enough to use and include a short way to check or improve it.