Demand factor worksheet calculator
Apply Australian demand-factor worksheet values entered by the user to connected load groups.
Demand_i = Connected_i x F_i / 100; Demand_total = sum(Demand_i); effective_F_% = Demand_total / Connected_total x 100- Connected loads are entered by the user.
- Demand factors are entered by the user.
- A factor above 100% is allowed only as a source-recorded review value.
- The calculator does not publish fixed demand-factor tables.
| Variable | Meaning | Unit | Use |
|---|---|---|---|
| Connected_i | Connected load group | A | Entered connected load for one group. |
| F_i | Demand factor | % | User-entered demand factor for the group. |
| Demand_i | Adjusted demand | A | Connected load multiplied by demand factor. |
| Demand_total | Adjusted demand total | A | Sum of adjusted demand rows. |
| effective_F_% | Effective demand factor | % | Adjusted demand total divided by connected load total. |
More
Demand factor worksheet calculator technical guide
Apply Australian demand-factor worksheet values entered by the user to connected load groups.
Use this calculator when demand factors have already been selected from a source record and need to be applied to connected load groups. The page keeps the factor and source note beside each row so the adjusted demand value can be reviewed later.
Field Use Cases
| Work setting | Real question | Useful action from this page |
|---|---|---|
| Load group review | What adjusted demand follows from the entered factor? | Multiply each connected load group by its entered factor. |
| Maximum-demand handoff | Which adjusted values should move to the next worksheet? | Sum adjusted demand rows and keep the effective factor. |
| Source traceability | Which factors need checking later? | Keep a source note beside each factor. |
| Growth allowance | What happens when a factor is above 100%? | Flag the source record for review. |
| Capacity discussion | What demand value should be compared with board capacity? | Carry adjusted demand to the spare capacity worksheet. |
This page is not a factor lookup table. It assumes the reviewer already has a basis for each factor.
Data checklist
| Value | Where it normally comes from | Stop if |
|---|---|---|
| Connected load | Load schedule, equipment data or measured record | The current basis is unclear. |
| Demand factor | Project, standard, engineering or documented source | The factor has no source note. |
| Group label | Board schedule or load group name | The row combines unrelated groups. |
| Source note | Project record, table reference or reviewer note | The source cannot be found later. |
| Worksheet reference | Board, tenancy or load schedule reference | The worksheet boundary is unclear. |
The source note does not need to be long. It just needs to point the reviewer back to the record that justified the factor.
Review Workflow
| Step | Record to check | Move to |
|---|---|---|
| Define load groups | Row labels and connected loads | Enter source-backed factors. |
| Apply factors | Adjusted demand per group | Review large or unusual factors. |
| Read total | Adjusted demand total and effective factor | Carry to maximum-demand review. |
| Compare capacity | Adjusted demand source | Use spare capacity if board rating is known. |
| Resolve exceptions | Factors above 100% or missing notes | Return to source record. |
The effective factor is only a summary of the entered rows. It does not become a new rule for other projects.
Worked factor record
A worksheet includes 30 A of lighting at 90%, 80 A of socket outlets at 60%, and 45 A of mechanical load at 75%. The connected total is 155 A.
Adjusted demand is 27 A for lighting, 48 A for socket outlets and 33.75 A for mechanical load. The adjusted total is 108.75 A. The effective demand factor for the entered rows is 70.16%, and the largest adjusted row is socket outlets.
| Value | Result |
|---|---|
| Connected load total | 155 A |
| Adjusted demand total | 108.75 A |
| Demand reduction | 46.25 A |
| Effective demand factor | 70.16% |
| Largest adjusted row | Socket outlets |
The result is useful because the row values remain visible. A later reviewer can see which group drove the adjusted demand and which factor source needs checking.
Method boundary
| Method element | What this page does | What remains outside |
|---|---|---|
| Row adjustment | Multiplies connected load by entered factor. | Selecting the factor from a standard or project rule. |
| Total demand | Sums adjusted rows. | Full maximum-demand assessment. |
| Effective factor | Divides adjusted total by connected total. | Reuse as a general factor. |
| Review flag | Notes factors above 100%. | Deciding whether the factor is correct. |
This narrow method keeps the page useful without pretending to own the whole demand calculation.
Stop points
- A connected load group has no clear basis.
- A demand factor has no source note.
- A factor above 100% is not intentional.
- The adjusted total is being treated as a complete maximum-demand assessment.
- The result is being used for switchboard capacity before the board capacity source is checked.
When a stop point appears, keep the export as a source question and resolve the factor record before carrying the value downstream.
Mixed load groups
A board worksheet applies user-entered demand factors to lighting, socket outlet and mechanical groups.
- Worksheet reference
- DF-1
- Rows
- 3
- Connected total
- 155 A
- Adjusted demand108.75 A
- Effective demand factor70.16%
- Statusfactor-worksheet
Keep factor source notes with the worksheet.
Socket outlets remain the largest adjusted-demand row in this entered worksheet.
- Demand factors are entered by the user.
- No fixed demand table is embedded.
- Rows are current values on the same basis.
Growth allowance
A future allowance is intentionally entered above 100% so the source note is visible.
- Worksheet reference
- DF-GROWTH
- Rows
- 1
- Connected total
- 40 A
- Adjusted demand50 A
- Effective demand factor125%
- Statusreview-factor-source
Keep factor source notes with the worksheet.
The factor source should stay in review because the entered value is above 100%.
- The high factor is deliberate.
- The source note must travel with the record.
- Capacity review remains separate.
Small board groups
A small board worksheet keeps two group factors visible before maximum-demand review.
- Worksheet reference
- DF-SMALL
- Rows
- 2
- Connected total
- 60 A
- Adjusted demand52.8 A
- Effective demand factor88%
- Statusfactor-worksheet
Keep factor source notes with the worksheet.
The effective demand factor is a source-recorded worksheet value only.
- Group labels are user-entered.
- The worksheet does not select factors.
- Maximum demand remains a downstream task.