Essentially I want help formatting my tables so they calculate with formulas with any numbers i plug in instead of me doing the manual math and typing it in one number at a time.

Nothing super complicated

offer some fg; lmk what you think is fair; have excel table to send you if interested.

Post what your math formula is and what rows/columns have the data

this

Essentially I want pooled investment dividends to be reinvested and split up amongst shareholders 90% based on equity and 10% based on participation.

Start value of all shareholders: $100,000
New Value Staking (pooled dividends): $10,000
I want the New Staking Value to be distributed to all shareholders 90% proportional to equity and 10% based on participation (based on # in the system).
I would like the outputs after 'staking' to be both in dollar value and by % equity

I want to do it in such a way that I can perhaps expand the table to include a large amount of shareholders (Have 10 atm would want 100+?)

Not sure if theres a better program to do this but I imagine not.

FG for solid help ofc

Finance terms mean nothing to me. Can you show a worked out example? Use of variables with explanations is fine

Pm me, if you email me document and I can help you update the document.

1 100€ =0,9*B1/(Countif(a:a, >0)) =(Countif(a:a, >0) +1- a1 )/sum(a:a)*0,1*b1
2 100€
3 100€
...

Then you should have:
Number | money that is shared | equal share amount| amount shared/ activity

Will plug in and see how it looks; may still need assistance if I can't expand table.

Talk over here

What is your problem with that?

When I posted it it didn't seem to compile. Gona need some additional help/direct communication. May post a Screenshot of what the table looks like in a bit.