Demand factor worksheet calculator

Apply Australian demand-factor worksheet values entered by the user to connected load groups.

  • Calculator
  • Load and demand
  • Australia
Use the board, load schedule or source record reference.
Name the load group.
A
Enter connected load for the group.
%
Enter the user source demand factor.
Record where the factor came from.
Name the load group.
A
Enter connected load for the group.
%
Enter the user source demand factor.
Record where the factor came from.
Name the load group.
A
Enter connected load for the group.
%
Enter the user source demand factor.
Record where the factor came from.
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.
Formula variables
VariableMeaningUnitUse
Connected_iConnected load groupAEntered connected load for one group.
F_iDemand factor%User-entered demand factor for the group.
Demand_iAdjusted demandAConnected load multiplied by demand factor.
Demand_totalAdjusted demand totalASum 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

Demand factor worksheet use cases
Work settingReal questionUseful action from this page
Load group reviewWhat adjusted demand follows from the entered factor?Multiply each connected load group by its entered factor.
Maximum-demand handoffWhich adjusted values should move to the next worksheet?Sum adjusted demand rows and keep the effective factor.
Source traceabilityWhich factors need checking later?Keep a source note beside each factor.
Growth allowanceWhat happens when a factor is above 100%?Flag the source record for review.
Capacity discussionWhat 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

Demand factor input sources
ValueWhere it normally comes fromStop if
Connected loadLoad schedule, equipment data or measured recordThe current basis is unclear.
Demand factorProject, standard, engineering or documented sourceThe factor has no source note.
Group labelBoard schedule or load group nameThe row combines unrelated groups.
Source noteProject record, table reference or reviewer noteThe source cannot be found later.
Worksheet referenceBoard, tenancy or load schedule referenceThe 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

Demand factor review path
StepRecord to checkMove to
Define load groupsRow labels and connected loadsEnter source-backed factors.
Apply factorsAdjusted demand per groupReview large or unusual factors.
Read totalAdjusted demand total and effective factorCarry to maximum-demand review.
Compare capacityAdjusted demand sourceUse spare capacity if board rating is known.
Resolve exceptionsFactors above 100% or missing notesReturn 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.

Example demand factor result
ValueResult
Connected load total155 A
Adjusted demand total108.75 A
Demand reduction46.25 A
Effective demand factor70.16%
Largest adjusted rowSocket 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

Demand factor boundary
Method elementWhat this page doesWhat remains outside
Row adjustmentMultiplies connected load by entered factor.Selecting the factor from a standard or project rule.
Total demandSums adjusted rows.Full maximum-demand assessment.
Effective factorDivides adjusted total by connected total.Reuse as a general factor.
Review flagNotes 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
  1. Adjusted demand108.75 A
  2. Effective demand factor70.16%
  3. Statusfactor-worksheet
Adjusted demand total108.75 A

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
  1. Adjusted demand50 A
  2. Effective demand factor125%
  3. Statusreview-factor-source
Adjusted demand total50 A

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
  1. Adjusted demand52.8 A
  2. Effective demand factor88%
  3. Statusfactor-worksheet
Adjusted demand total52.8 A

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.

Questions

Does this provide demand factors?

No. The factor values are entered by the user from project, standards, engineering or documented source records.

Can a factor be above 100%?

The calculator accepts it as a review value because some records include growth or allowance factors, but the source basis must be kept with the row.

Does this replace maximum demand?

No. It prepares adjusted group values that can be carried into the maximum demand worksheet.

Why include a source note?

Demand-factor selection is the sensitive part, so the factor source needs to stay visible with the calculation.

Can this be used for switchboard capacity?

Use this page to calculate adjusted load groups, then use the spare capacity worksheet when board capacity is the comparison point.