FreeExcel

Transformer Sizing Calculator

Transformer Capacity Sizing

Transformer capacity sizing calculator — considers connected load, diversity factor, future expansion to suggest transformer kVA rating. Includes oil type and dry type comparison.

BNBC 2020 Part VIIIIEC 60076ANSI C57

1,054 downloads

Excel

Completely Free — No Registration Required

How to Use

Follow these simple steps to get started

Step 1

Enter connected load (kW)

Step 2

Enter diversity factor and power factor

Step 3

Select future expansion %

Step 4

View recommended transformer kVA

Step 5

View oil type vs dry type comparison

transformer-capacity-sizing.xlsx

Tool Preview

Screenshot will be shown here

Who Needs This

✓Electrical Design Engineer
✓Building Services Engineer
✓Factory Electrical Manager
✓Power Distribution Planner

Frequently Asked Questions

Not all loads run at the same time — so actual demand is less than connected load. Typical diversity factor = 0.6-0.8.

Yes, oversized transformer gives low efficiency under no-load condition. Right size is best.

Indoor = Dry type (fire safe), Outdoor = Oil type (cheaper, efficient). Dry type is recommended for RMG factories.

Generally 20-25% future expansion factor is kept.

100, 150, 200, 315, 500, 750, 1000, 1500, 2000 kVA — the nearest standard size is selected.

Related Tools