How the model works

You do not need the hidden sheet in the conversation. You do need a true account of where a number comes from. Funding, Care Team, Expenses, and Client Review show the same calculation. This site describes that path. It does not work out a new result.

Where a number goes

How a result moves from what you type to Client Review. The list is the diagram. The hidden rollup is not part of the conversation.

1. Funding, Care Team, and Expenses

   Three editing sheets, one Current Plan, and one Proposed Plan. A blank Proposed cell keeps Current. Zero means zero. Client Review does not take new entries.

2. Care-team rows

   Paid units and rates become wages. Care hours are counted on their own.

   Parameters

   CPP, CPP2, EI, WorkSafeBC, the vacation default, and the sick and statutory allowances.

3. One rollup

   Current and Proposed are worked out once. Every sheet reads that result. None of them runs payroll again.

4. Hours

   Planned care hours against funded hours.

   Operating balance

   Funding minus employment cost minus operating expenses.

   Reserve

   That same monthly change, carried forward from the opening balance.

5. Client Review

   A read-only Current, Proposed, and change brief. It uses the same dashboard as the editing sheets.

What it means

The monthly change is funding minus employment cost minus operating expenses. That is the operating balance. The 12-month reserve carries that change forward from the opening balance. It is not capped. The sentence beside it says whether the balance would be exhausted, below the target, at the target, or above one month of funding.

Employment cost is more than the weekly wage. It includes vacation, sick, and statutory allowances, then employer CPP, CPP2, EI, and WorkSafeBC. Parameters holds those rates, with a value, a date, a status, and a source. A number the employer types, a maintained assumption, and a calculated result are not the same kind of figure.

The three readings, in plain languageTrace the projected 12-month reserve