Load list summary calculator
Summarise entered Australian load list rows into connected load, category totals and largest rows.
RowLoad = Qty x Iunit; ConnectedLoad = sum(RowLoad); CategoryTotal = sum(RowLoad by category); LargestRows = top rows sorted by RowLoad- Quantity and unit load are user-entered.
- Category labels are project labels.
- The highlight threshold is a worksheet prompt.
- Demand factors and diversity remain separate.
| Variable | Meaning | Unit | Use |
|---|---|---|---|
| Qty | Row quantity | qty | Entered number of items for the row. |
| Iunit | Unit load current | A | Entered current per item. |
| RowLoad | Row connected load | A | Quantity multiplied by unit load. |
| ConnectedLoad | Total connected load | A | Sum of all row loads. |
| CategoryTotal | Category connected load | A | Sum of row loads sharing the same category. |
| LargestRows | Largest row prompts | A | Highest row loads shown for review. |
More
Load list summary calculator technical guide
Summarise entered Australian load list rows into connected load, category totals and largest-row prompts.
Use this calculator when a load list needs a quick connected-load summary before it becomes a demand worksheet, grouped schedule or switchboard capacity record. The page keeps row quantity, unit load and category labels separate so later checks have a clean source trail.
Field Use Cases
| Work setting | Real question | Useful action from this page |
|---|---|---|
| Tenancy fit-out | What connected load follows from the equipment list? | Add quantity times unit current for each row. |
| Board schedule | Which rows are the largest before demand factors are applied? | Sort the largest row loads. |
| Category summary | How much load sits in lighting, small power or mechanical categories? | Read category totals from entered labels. |
| Scope comparison | Did a revised equipment list change the total? | Update row quantities or unit loads. |
| Handoff to demand | Is the list ready for factor assumptions? | Carry connected load into the demand worksheet. |
The result is a preparation record. It deliberately stops before demand factors, diversity factors or board suitability.
Data checklist
| Value | Where it normally comes from | Stop if |
|---|---|---|
| Row label | Equipment list, load schedule or drawing tag | The row cannot be traced to the project list. |
| Category | Project grouping label | The category is inconsistent across similar rows. |
| Quantity | Count of equipment, circuits or repeated items | Quantity hides items that should remain separate. |
| Unit load | Equipment data, schedule value or measured record | Unit values use mixed current bases. |
| Highlight threshold | User-entered row prompt | The threshold is being treated as a rule. |
The worksheet is most useful when row labels are boringly precise. A vague row name makes later demand or grouping checks harder to verify.
Review Workflow
| Step | Record to check | Move to |
|---|---|---|
| Confirm source list | Equipment list or load schedule | Enter row labels. |
| Enter counts | Quantity per row | Read row loads. |
| Enter unit currents | Current per item | Read connected load. |
| Check category labels | Lighting, small power, equipment or project label | Read category totals. |
| Choose next calculator | Grouping, demand factor or load schedule builder | Continue with the owner of the next question. |
This path keeps the summary clear enough for downstream calculators. It is not meant to decide final demand or switchboard margins.
Worked summary record
A tenancy list enters 12 lighting rows at 3.5 A, eight socket outlet rows at 5 A, two kitchen equipment rows at 18 A and one mechanical plant row at 42 A. The highlight threshold is 40 A.
The connected load is 160 A across 23 total items. Lighting and mechanical each total 42 A, small power totals 40 A and equipment totals 36 A. The largest rows are visible before any demand method is applied.
| Value | Result |
|---|---|
| Connected load | 160 A |
| Total quantity | 23 |
| Lighting category | 42 A |
| Small power category | 40 A |
| Equipment category | 36 A |
| Mechanical category | 42 A |
The summary can now feed a grouping worksheet, demand factor worksheet or load schedule builder depending on the next task.
Method boundary
| Method element | What this page does | What remains outside |
|---|---|---|
| Row load | Multiplies entered quantity by entered unit load. | Confirming equipment data or measured current. |
| Connected load | Adds row loads together. | Choosing demand method or diversity basis. |
| Category total | Adds row loads by category label. | Deciding category-specific factors. |
| Largest rows | Sorts rows by connected load. | Deciding whether a row is acceptable for the project. |
Keeping connected load separate from demand load avoids a common worksheet mistake: hiding assumptions inside one total before the source record is ready.
Stop points
- The equipment list is incomplete or out of date.
- Row quantities and unit loads use different bases.
- Category labels do not match the project schedule.
- A row threshold is being treated as a rule.
- The result is being used as maximum demand without a demand method.
- Phase labels or circuit groups are now needed.
When a stop point appears, keep the row summary as a preparation record and move the next question to the calculator that owns it.
Tenancy load list
A tenancy fit-out list needs connected load, category totals and largest rows before demand factors are applied.
- List reference
- LLS-1
- Rows
- 4
- Highlight threshold
- 40 A
- Connected load160 A
- Total quantity23
- Largest rowLighting rows
Use the status to decide whether any row needs closer schedule review.
The lighting and mechanical rows are the largest entries, so they should stay visible when the list moves into demand review.
- Unit loads are user-entered current values.
- Category labels are project labels.
- No demand factor is embedded.
Small load list
A small board list has low row totals and a higher highlight threshold.
- List reference
- LLS-SMALL
- Rows
- 3
- Highlight threshold
- 50 A
- Connected load52 A
- Total quantity10
- Largest rowSmall power
Use the status to decide whether any row needs closer schedule review.
The summary stays in estimate status because no single row reaches the entered highlight threshold.
- Quantities are entered as schedule counts.
- The threshold is a user-entered prompt.
- Demand calculation is handled separately.
Workshop load list
A workshop list separates machine rows from support loads before grouping is checked.
- List reference
- LLS-WORKSHOP
- Rows
- 3
- Highlight threshold
- 60 A
- Connected load109 A
- Total quantity13
- Largest rowWelder allowance
Use the status to decide whether any row needs closer schedule review.
The equipment row is the largest entry, while the category totals show how much load sits outside the machinery line.
- Rows use current values.
- Equipment ratings are entered by the user.
- Circuit grouping remains the next worksheet when phase labels are needed.