Load list summary calculator

Summarise entered Australian load list rows into connected load, category totals and largest rows.

  • Calculator
  • Load and demand
  • Australia
Use the schedule, board or equipment list reference.
A
Rows at or above this load are highlighted.
Name the row as it appears in the list.
Use a short category label.
qty
Enter the row quantity.
A
Enter current per item.
Name the row as it appears in the list.
Use a short category label.
qty
Enter the row quantity.
A
Enter current per item.
Name the row as it appears in the list.
Use a short category label.
qty
Enter the row quantity.
A
Enter current per item.
Name the row as it appears in the list.
Use a short category label.
qty
Enter the row quantity.
A
Enter current per item.
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.
Formula variables
VariableMeaningUnitUse
QtyRow quantityqtyEntered number of items for the row.
IunitUnit load currentAEntered current per item.
RowLoadRow connected loadAQuantity multiplied by unit load.
ConnectedLoadTotal connected loadASum of all row loads.
CategoryTotalCategory connected loadASum of row loads sharing the same category.
LargestRowsLargest row promptsAHighest 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

Load list summary use cases
Work settingReal questionUseful action from this page
Tenancy fit-outWhat connected load follows from the equipment list?Add quantity times unit current for each row.
Board scheduleWhich rows are the largest before demand factors are applied?Sort the largest row loads.
Category summaryHow much load sits in lighting, small power or mechanical categories?Read category totals from entered labels.
Scope comparisonDid a revised equipment list change the total?Update row quantities or unit loads.
Handoff to demandIs 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

Load list input sources
ValueWhere it normally comes fromStop if
Row labelEquipment list, load schedule or drawing tagThe row cannot be traced to the project list.
CategoryProject grouping labelThe category is inconsistent across similar rows.
QuantityCount of equipment, circuits or repeated itemsQuantity hides items that should remain separate.
Unit loadEquipment data, schedule value or measured recordUnit values use mixed current bases.
Highlight thresholdUser-entered row promptThe 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

Load list review path
StepRecord to checkMove to
Confirm source listEquipment list or load scheduleEnter row labels.
Enter countsQuantity per rowRead row loads.
Enter unit currentsCurrent per itemRead connected load.
Check category labelsLighting, small power, equipment or project labelRead category totals.
Choose next calculatorGrouping, demand factor or load schedule builderContinue 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.

Example load list result
ValueResult
Connected load160 A
Total quantity23
Lighting category42 A
Small power category40 A
Equipment category36 A
Mechanical category42 A

The summary can now feed a grouping worksheet, demand factor worksheet or load schedule builder depending on the next task.

Method boundary

Load list method boundary
Method elementWhat this page doesWhat remains outside
Row loadMultiplies entered quantity by entered unit load.Confirming equipment data or measured current.
Connected loadAdds row loads together.Choosing demand method or diversity basis.
Category totalAdds row loads by category label.Deciding category-specific factors.
Largest rowsSorts 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
  1. Connected load160 A
  2. Total quantity23
  3. Largest rowLighting rows
Summary statusreview-load-list

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
  1. Connected load52 A
  2. Total quantity10
  3. Largest rowSmall power
Summary statusload-list-estimate

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
  1. Connected load109 A
  2. Total quantity13
  3. Largest rowWelder allowance
Summary statusload-list-estimate

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.

Questions

Is this a maximum demand calculator?

No. It summarises connected load rows. Use the maximum demand calculator when the demand method is the task.

What is unit load?

It is the current value per item that you enter from the equipment list, schedule or project record.

Why show the largest rows?

Large rows often need clearer source records before demand factors, grouping or capacity checks reuse the list.

Can categories be custom labels?

Yes. Use labels that match the project schedule so totals remain traceable.

What should I use next?

Use circuit load grouping when phase or group labels are needed, or demand factor worksheet when factor assumptions are ready.