Here's a
spreadsheet detailing the accounting for refunds of what cash HIV sent back to me.
Key: across the top are the investors and the markup they paid, along w/ 2+2 names and poker site names where I'll send the refund. (I think this was all public from this thread already, but if you have a problem with it, just ask and I'll hide the info.)
Down the left are the tournaments HIV was supposed to play. The "Return" column is x if he didn't play, 0 if he played but busted, and whatever he cashed for if he cashed.
The formulas then work out what each investor is due back - if HIV didn't play a tournament, it's markup*percentage*buyin, if he played it's percentage*result.
So at the bottom we have five rows for each investor. Return (what they should get back), Purchased (how much they bought), Paid (how much they actually paid HIV, for most people this is the same as Purchased, but some hadn't paid in full yet), Owed (what this investor is owed), and Owed Online (which which takes into account that HIV is handling his RL friends separately.)
The "Will get" row is a division of the cash HIV sent me, proportionally to all the "Owed Online" amounts.
If each of you would PM me or post here that your poker site screenname is correct, I'll send out the "Will get" amounts.