There's a question after this, I promise.
BANKROLL A (poker)
Should always reflect 40% of OVERALL BR
BANKROLL B (sports)
Should always reflect 30% of OVERALL BR
BANKROLL C (misc,BJ,horses)
Should always reflect 20% of OVERALL BR
BANKROLL D - Supplemented by daily surpluses
From BANKROLLS A,B,C. BANKROLL D
NEVER supplements BANKEOLLS A,B,C
Basically, anything that goes into BR D STAYS in BR D
So, any surpluses from any particular BR are used to supplement the other bankrolls proportionately. If I win $10 in BANKROLL A- $4 stays in BĀNKROLL A, $3 goes to BANKROLL B, $2 goes to BANLROLL C & $1 goes to BANKROLL D.
If I lose $10 in BANKROLL A - $3 is supplemented from BANKROLL B to BANKROLL A & $2 is supplemented from BANKROLL C to BANKROLL A.
The question is, with limited knowledge of spreadsheets or excel & virtually no knowledge of VB or compilers, what is the best way to calculate the daily amomts that need to be transferred to each Bankroll?