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