Staged load addition calculator
Track how proposed staged loads change demand margin against an entered capacity limit for Australian project review.
StageDemand_i = AddedLoad_i x Factor_i / 100; Icum_i = Ibase + sum(StageDemand_1..i); margin_i = Icapacity - Icum_i; trigger = first stage where margin_i < review_margin- Base demand is entered by the user.
- Stage demand factors are entered by the user.
- The review margin is a worksheet comparison value.
- The trigger stage is a prompt, not a project sequencing decision.
| Variable | Meaning | Unit | Use |
|---|---|---|---|
| Ibase | Base demand | A | Entered demand before proposed stages. |
| AddedLoad_i | Stage added load | A | Entered load for one proposed stage. |
| Factor_i | Stage demand factor | % | User-entered factor for the stage. |
| StageDemand_i | Stage demand | A | Added load multiplied by the entered factor. |
| Icum_i | Cumulative demand | A | Base demand plus stage demands up to that stage. |
| Icapacity | Capacity limit | A | Entered comparison value. |
| review_margin | Review margin | A | Entered remaining-margin trigger value. |
More
Staged load addition calculator technical guide
Track how proposed staged loads change demand margin against an entered capacity limit for Australian project review.
Use this calculator when future loads are being added in named stages and the question is how each stage affects an entered capacity margin. It is useful for alterations, tenancy expansions, EV charger rollouts, workshop upgrades and staged plant additions where the sequence needs a traceable arithmetic record.
Field Use Cases
| Work setting | Real question | Useful action from this page |
|---|---|---|
| Workshop alteration | Which proposed stage first tightens the margin? | Add stage demand one row at a time. |
| Tenancy expansion | How does each future allowance affect capacity? | Keep cumulative demand visible after each stage. |
| EV rollout | What demand value is carried for each charger stage? | Apply entered factors to stage loads. |
| Board capacity review | What is the final margin against the entered limit? | Compare cumulative demand with capacity limit. |
| Source review | Which factor or stage needs checking? | Export labels, factors and stage results. |
The page respects the stage order entered by the user. It does not decide the commercial or technical order of the work.
Data checklist
| Value | Where it normally comes from | Stop if |
|---|---|---|
| Base demand | Maximum-demand worksheet, measured record or design note | The base value is stale or not tied to the project. |
| Capacity limit | Board, supply or project comparison value | The limit has no recorded basis. |
| Stage added load | Equipment list, tenancy allowance or design schedule | Stage scope is unclear. |
| Stage demand factor | Project, engineering or documented source value | The factor has no source basis. |
| Review margin | Project worksheet value | The margin is copied without context. |
Stages should be labelled as real scopes, not generic future loads. A later reviewer needs to know what each row represented.
Review Workflow
| Step | Record to check | Move to |
|---|---|---|
| Define base demand | Existing demand source | Enter the capacity limit. |
| List proposed stages | Stage label, added load and factor | Read stage demand. |
| Track cumulative demand | Demand after each stage | Read remaining margin. |
| Identify trigger | First stage below the margin | Return to source values. |
| Choose follow-up | Supply planning, spare capacity or demand-factor review | Use the linked calculator that owns that task. |
If a trigger stage appears, treat it as a review prompt. It does not mean that stage cannot proceed or that a different stage must proceed first.
Worked staged-load record
A workshop plan starts with 145 A base demand and a 250 A capacity limit. The review margin is 20 A. The proposed stages are a 36 A workshop extension at 80%, 48 A of EV chargers at 75%, and a 60 A future tenancy allowance at 60%.
The first stage adds 28.8 A, bringing cumulative demand to 173.8 A. The second stage adds 36 A, bringing cumulative demand to 209.8 A. The future tenancy stage adds 36 A, bringing cumulative demand to 245.8 A. The final margin is 4.2 A, so the future tenancy is the first stage below the entered review margin.
| Value | Result |
|---|---|
| Base demand | 145 A |
| Capacity limit | 250 A |
| Stage 1 cumulative demand | 173.8 A |
| Stage 2 cumulative demand | 209.8 A |
| Stage 3 cumulative demand | 245.8 A |
| Final margin | 4.2 A |
| Trigger stage | Future tenancy |
The record is useful because it shows where the margin changed. A reviewer can return to the future tenancy load, the EV charger factor or the capacity limit source without guessing which row caused the review prompt.
Method boundary
| Method element | What this page does | What remains outside |
|---|---|---|
| Base demand | Uses an entered starting demand value. | Calculating or validating that demand. |
| Stage demand | Applies an entered factor to each stage load. | Selecting the factor source. |
| Cumulative margin | Subtracts cumulative demand from the capacity limit. | Confirming board or supply capacity. |
| Trigger stage | Identifies first stage below the entered margin. | Project sequencing and technical feasibility. |
This narrow method makes the stage trail easy to check without turning the page into a project decision tool.
Stop points
- The base demand does not have a source record.
- The capacity limit is not tied to a board, supply or project comparison value.
- Stage loads are broad allowances without labels.
- Demand factors are entered without source context.
- The trigger stage is being treated as a project sequencing instruction.
- The result should first be checked with maximum demand, spare capacity or supply capacity planning.
When a stop point appears, keep the export as a staged-load question and resolve the source value before carrying the plan downstream.
Workshop staged addition
A workshop alteration records three proposed stages against an entered capacity limit.
- Plan reference
- STAGE-1
- Capacity limit
- 250 A
- Stage count
- 3
- Final demand245.8 A
- Final margin4.2 A
- Trigger stageFuture tenancy
Use the stage record as a planning prompt before demand and capacity review.
The future tenancy stage is the first stage that leaves less than the entered review margin.
- Stage demand factors are user-entered.
- The capacity limit is an entered comparison value.
- The result does not sequence project works.
Higher capacity comparison
The same staged load plan is compared with a larger entered capacity limit.
- Plan reference
- STAGE-HIGH-CAPACITY
- Capacity limit
- 300 A
- Stage count
- 3
- Final demand245.8 A
- Final margin54.2 A
- Trigger stageNone
Use the stage record as a planning prompt before demand and capacity review.
The final margin remains above the entered review margin on this comparison basis.
- Only the entered three stages are included.
- Future load values need their own source record.
- Supply capacity planning remains separate.
Small board staged allowance
A small board worksheet uses lower staged loads and a smaller review margin.
- Plan reference
- STAGE-SMALL
- Capacity limit
- 120 A
- Stage count
- 3
- Final demand92 A
- Final margin28 A
- Trigger stageNone
Use the stage record as a planning prompt before demand and capacity review.
The stage list stays inside the entered capacity and margin record for this example.
- Base demand is already calculated elsewhere.
- Factors are user-entered.
- The worksheet should be updated when stage scope changes.