Turn a cable schedule into a single line diagram
Every row of a cable schedule is a feeder: from one piece of equipment to another. Put those rows together and you have the network. PowerTopology does that for you and draws it.
The minimum you need
A cable schedule with two columns, From and To, is enough to get a first drawing. The tags in those columns become the equipment, and each row becomes a feeder. From there you add ratings, voltages, supply and cable data as you have them.
From,To,Supply,Protection,Breaker,Cable INC-A,RMU-A,1st source,VCB,250 A,3c x 185 mm2 XLPE RMU-A,TX-A,1st source,VCB,250 A,3c x 95 mm2 XLPE TX-A,MSB-A,1st source,ACB,4000 A,Busduct 4000 A MSB-A,CH-A,1st source,MCCB,800 A,2 x 4c x 300 mm2 XLPE
What the studio does with it
- Works out each item's level from the feed tree, so sources sit at the top and loads at the bottom.
- Routes the feeders and prints the cable labels on the sheet.
- Marks supply colours for a first source, a second source and standby.
- Flags feeders with no cable size, items with no live supply, and duplicate tags.
Keep the schedule and the drawing in step
When the schedule is revised, import the new version and merge it into the same drawing. You can also export the cable schedule back out as a CSV from the drawing.
Open the studioDownload a sample schedule
What it is not
It draws and checks connectivity. It does not size cables or check them against a standard, and a competent engineer remains responsible for every issued drawing.
Questions
What columns does it understand?
From, To, supply, protection, breaker and cable are used when present. Your own column names are matched, and the studio asks when it cannot tell.
Can it handle bus ties and standby supplies?
Yes. Ties, normally-open links and standby supplies are part of the model.
Is my schedule sent anywhere?
No. It is read in your browser.