Calculator #53

AGL Circuit Load Schedule Generator

List your circuits once and get the transformer quantities, connected load, cable loss, kVA and CCR size for each, as a schedule you can export.

About this calculator

A circuit load schedule is the table a design or tender package hangs from. For each series circuit it carries the fixture count, the isolating transformers behind them, the load including transformer and cable losses, and the CCR that serves it. Enter the circuits and the schedule, the transformer count by size and the cable by conductor build themselves.

Quick start

Design Basis

Rule note

Applied to every circuit.

Rule note

Power factor of the transformer and lamp load. Cable loss is treated as resistive.

Rule note

Planning assumption. See Calculator #18.

Rule note

A transformer is sized so the fixture watts stay within this share of its rating.

Rule note

Conductor resistance is corrected from 20 °C.

Circuits

One row per series circuit. Cable length is the total primary cable laid for the loop, out and back. The example circuits are placeholders to overwrite.

CircuitDescriptionFixturesW eachTransf. per fixtureCable loop (m)Conductor
FAQ

AGL Circuit Load Schedule Generator: Frequently Asked Questions

Quick answers on how the circuit load schedule, transformer quantities and CCR sizes are worked out.

What does the AGL Circuit Load Schedule Generator do?

You list each series circuit once and the tool builds the schedule. For each circuit it gives the fixture count, the isolating transformer quantity and size, the connected load including transformer and cable losses, the kVA, the output voltage and the CCR that serves it. It also totals the transformers by size and the cable by conductor, and exports the schedule as a PDF or CSV.

How are the isolating transformers sized and counted?

The quantity is fixtures × transformers per fixture. The size is the smallest standard size whose rating, at your loading limit, covers one fixture's watts, so Size ≥ Wfixture ÷ loading limit. In the worked example, 120 × 45 W fixtures at a 90 % transformer loading limit need 120 × 45 W transformers.

How is the circuit load calculated?

P = n × W ÷ η + I² × Rcable, where Rcable = r20 × (1 + 0.00393 × (T − 20)) × length ÷ 1000. Fixture watts are divided by the transformer efficiency and the cable loss at the circuit current is added. For example, 6,000 m of 6 mm² at 20 °C is 18.48 Ω, which gives a cable loss of 0.805 kW at 6.6 A and a load of 6.805 kW.

How are the kVA and output voltage found?

S = √(P² + Q²), with Q = (n × W ÷ η) × tan(cos⁻¹ PF), and V = S ÷ I. The cable loss is resistive, so only the transformer and lamp load carries a reactive part. In the worked example, at a power factor of 0.95 the vector sum is 7.085 kVA and the output voltage is 1,073 V.

How is the CCR size selected?

Required = S × (1 + growth) ÷ maximum loading, and the CCR is the smallest standard size at or above that figure. In the worked example, 7.085 kVA × 1.10 ÷ 0.90 is 8.659 kVA, so a 10 kVA CCR is chosen at 70.8 % loaded. Standard CCR sizes are treated as kVA capacity, and above 30 kVA the circuit is shown as a split.

Are the design basis values standard figures?

No. The series current, power factor, transformer efficiency, loading limit, CCR expansion allowance, maximum CCR loading and cable temperature are inputs you set, and the example circuits are placeholders to overwrite. Each circuit is treated as one CCR, and the cable length is the total primary cable laid for the loop, out and back.

What does the schedule generator not do?

It does not check voltage drop on the secondary cables, split a circuit across CCRs for you, or account for different conductor sizes within one circuit. The schedule shall be checked against the approved layout, cable schedule and manufacturers' data before issue.

Talk to Precision AGL Academy

Follow the Academy

Total load—