Heres an Image of the manually done table -- also explain the terms a bit more to clarify some things.

BoE = Based on Equity (means equity is distributed based on proportional equity in the system -- IE: You own 30% of the shares you get 30% new equity)
BoP = Based on Participation (means equity is distributed just for participating -- IE: 20 people get 1/20 of new equity)
'Staking' is just money created by the company/shareholders collectively that is reinvested after it pools to a certain amount -- the staking threshold is the value that must be reached before it reinvests (not relevant here).


So a 90/10 'split stake' (90% BoE, 10% BoP) means that a $10,000 stake will be split between all shareholders 90% BoE ($9,000) and 10% BoP ($1,000).
There are 10 shareholders in this situation so they each receive 1/10 of the BoP stake ($1,000/10 or $100 each).
The remaining 90% ($9,000) is split among the shareholders based on their initial equity.

I hope I'm understanding what you're asking for.

So doing it for P1.

Initial Value, Initial Equity%, and the split are givens I assume

E7 = $E$3*E6
E8 = $H$3 * 0.9 * E6
E9 = $H$3 * 0.1*0.1
E10 = E7 + E8 + E9
E11 = E10 / ($E$3 + $H$3)

You can just drag that formula across for P2-P10

This post was edited by RzChaos on Jan 18 2016 08:28pm

Yes but the numbers in e9 are wrong.
Delete the "p" in 5:5
If you are getting errors: Delete all words
E9=$h$3*0,1*((10-e5-1)/sum($e5/$n5))

Still having trouble with the compiling but the variables/formulas don't look too alien.

Any chance I could give one of you some fg to email me a table with the input variables that creates the same outputs? Labels would help a lot.

Thanks so much for the help again

Bump

100 fg for someone to help me with this further.

Gave ~ 20+ for the help so far

Not sure what you want..I emailed you an excel file with the table made out with the equations needed. All you have to do is drag the formulas in the P1 column over for the other participants.

All you have to do if you want some other form of inputs is change the Initial Value/New Stake/Initial % equity (The givens) and it should update to reflect the new numbers.

Edit: I guess if you want something different than a 90/10 split you'll have to change the 0.1 to reflect the new split in the formula.

This post was edited by RzChaos on Jan 23 2016 06:45pm

Dis guy was a great help! TYVM!!!! (vouch netime)


May need future help on this but I have a solid foundation for now! TY!!!