Diversity factor worksheet calculator
Apply Australian diversity-factor worksheet values entered by the user to connected load groups.
Diversified_i = Connected_i x D_i; Diversified_total = sum(Diversified_i); effective_D = Diversified_total / Connected_total- Connected loads are entered by the user.
- Diversity factors are entered by the user.
- A factor below 0.40 is allowed only as a source-recorded review value.
- The calculator does not publish fixed diversity tables.
| Variable | Meaning | Unit | Use |
|---|---|---|---|
| Connected_i | Connected load group | A | Entered connected load for one group. |
| D_i | Diversity factor | factor | User-entered diversity factor for the group. |
| Diversified_i | Diversified load | A | Connected load multiplied by diversity factor. |
| Diversified_total | Diversified load total | A | Sum of diversified load rows. |
| effective_D | Effective diversity factor | factor | Diversified load total divided by connected load total. |
More
Diversity factor worksheet calculator technical guide
Apply Australian diversity-factor worksheet values entered by the user to connected load groups.
Use this calculator when diversity 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 diversified load value can be reviewed later.
Field Use Cases
| Work setting | Real question | Useful action from this page |
|---|---|---|
| Load group review | What diversified load follows from the entered factor? | Multiply each connected load group by its entered factor. |
| Maximum-demand handoff | Which diversified values should move to the next worksheet? | Sum diversified load rows and keep the effective factor. |
| Source traceability | Which factors need checking later? | Keep a source note beside each factor. |
| Low factor review | What happens when a factor is very small? | Flag the source record for review. |
| Capacity discussion | What demand value should be compared with board capacity? | Carry diversified load 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. |
| Diversity 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 | Diversified load per group | Review low or unusual factors. |
| Read total | Diversified load total and effective factor | Carry to maximum-demand review. |
| Compare capacity | Diversified load source | Use spare capacity if board rating is known. |
| Resolve exceptions | Factors below 0.40 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 diversity record
A worksheet includes 120 A of base plant at 0.75, 32 A of EV allowance at 1.0 and 40 A of future spare at 0.5. The connected total is 192 A.
Diversified load is 90 A for the base plant, 32 A for the EV allowance and 20 A for the future spare. The diversified total is 142 A. The effective diversity factor for the entered rows is 0.74, and the lowest factor row is future spare at 0.5.
| Value | Result |
|---|---|
| Connected load total | 192 A |
| Diversified load total | 142 A |
| Diversity reduction | 50 A |
| Effective diversity factor | 0.74 |
| Lowest factor row | Future spare |
The result is useful because the row values remain visible. A later reviewer can see which group drove the diversified load 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 diversified rows. | Full maximum-demand assessment. |
| Effective factor | Divides diversified total by connected total. | Reuse as a general factor. |
| Review flag | Notes factors below 0.40. | 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 diversity factor has no source note.
- A factor below 0.40 is not intentional.
- The diversified 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 diversity
A planning worksheet applies entered diversity factors to base plant, EV allowance and future spare load groups.
- Worksheet reference
- DIV-1
- Rows
- 3
- Connected total
- 192 A
- Diversified load142 A
- Effective diversity factor0.74
- Statusdiversity-worksheet
Keep factor source notes with the worksheet.
The diversified total is a source-recorded worksheet value, not a general rule.
- Diversity factors are entered by the user.
- No hidden table values are embedded.
- Rows are connected current values on the same basis.
Aggressive diversity review
A low factor is entered deliberately so its source basis stays visible.
- Worksheet reference
- DIV-LOW
- Rows
- 1
- Connected total
- 100 A
- Diversified load25 A
- Effective diversity factor0.25
- Statusreview-diversity-source
Keep factor source notes with the worksheet.
The factor is below the review threshold and should carry its source note forward.
- The low factor is entered by the reviewer.
- The source basis must be checked.
- Capacity review remains separate.
Small board diversity
A small board worksheet applies moderate entered factors to two load groups.
- Worksheet reference
- DIV-SMALL
- Rows
- 2
- Connected total
- 60 A
- Diversified load52.8 A
- Effective diversity factor0.88
- Statusdiversity-worksheet
Keep factor source notes with the worksheet.
The diversified total can be reviewed before moving into a demand or capacity worksheet.
- The factors are not selected by the calculator.
- The rows use the same current basis.
- Maximum demand remains a downstream task.