I have 4 columns for each partner.
Contribution
Expenses
Balance
%Balance
In the second column (Expenses) I see the expenses that are being made and that should be divided among those people who have a contribution percentage (see the last column), and each one will spend based on that percentage
The problem appears when another person wants to contribute. For example, Dante e Selene have invested 100€ each one, then spent 20€ and the expense was divided according to the percentage of the balance. If Michele wants to invest 100 and then there is a new expense, the new expense should be divided according to the NEW percentage of the balance. The old expenses should not be add to MICHELE but only the expenses post-date investment from MICHELE.
Instead, the old expenses are also divided by Michele ...
At the time of the old expense (20€) Michele had not invested yet and then he would not have to pay anything ...
It has to be this way for each person who invests successively
Past expenses should not be calculated among those people who invest now
[the well ](https://docs.google.com/file/d/1YT-...qtbaIW/edit?usp=docslist_api&filetype=msexcel)
I hope you can help me…
Thank you in advance
Sebastian A.
Contribution
Expenses
Balance
%Balance
In the second column (Expenses) I see the expenses that are being made and that should be divided among those people who have a contribution percentage (see the last column), and each one will spend based on that percentage
The problem appears when another person wants to contribute. For example, Dante e Selene have invested 100€ each one, then spent 20€ and the expense was divided according to the percentage of the balance. If Michele wants to invest 100 and then there is a new expense, the new expense should be divided according to the NEW percentage of the balance. The old expenses should not be add to MICHELE but only the expenses post-date investment from MICHELE.
Instead, the old expenses are also divided by Michele ...
At the time of the old expense (20€) Michele had not invested yet and then he would not have to pay anything ...
It has to be this way for each person who invests successively
Past expenses should not be calculated among those people who invest now
[the well ](https://docs.google.com/file/d/1YT-...qtbaIW/edit?usp=docslist_api&filetype=msexcel)
I hope you can help me…
Thank you in advance
Sebastian A.