Allocate funds to various "accounts" based on maximums

Attached is my sample.

I'd like to add a new "transaction" to rows 12+ that would then allocate the funds "deposited" into the various accounts listed.

I would like it to use the Allocation % (C) to determine the % of the deposit to allocate into the accounts. If the account balance (E) has reached the maximum (D), I'd like the allocation % to change so the total allocation = 100% but the allocation for a "full" account is 0%

I hope this makes sense!!!