Transformer Design Calculation Excel

Posted By admin  On 17.08.21

  • 10, equals 8760 unless for a special application/seasonal use transformer (irrigation, pumping) 11. 12, Capacity Factor. 13, = KWH sold per year through the. Design Parameters. For designing a transformer, we need: Power rating. Voltage levels (primary and secondary) Currents on both sides. Primary and secondary coils wire diameter/size.
  • This transformer calculator helps you to quickly and easily calculate the primary and secondary full-load currents of the transformer. It also determines the turns ratio and type of transformer. User Instructions: Select the number of phases from the drop-down menu; Enter the transformer.
  1. Transformer Design Calculator
  2. Transformer Design Calculation Excel Format
Transformer Design Calculation Excel

Download: Distribution Transformer Excel Spread Sheet Calculator. Description: Distribution Transformer Calculations – MS nput parameters: Primary rated voltage (kV.) Secondary rated voltage (kV.) Max. Demand load (kW) Power factor after correction; Transformer type; Permissible loading percentage (%).

Downloads

Supported products & hardware

Boost controllers (external switch)
LM3017—High Efficiency Low-Side Controller with True ShutdownLM3478—2.97~40V Wide Input Range Boost/SEPIC/Flyback DC-DC ControllerLM3478Q-Q1—40-V wide VIN low-side N-channel controller for switching regulators with 10-µA shutdown currentLM3481—2.97V to 48V High-Efficiency Controller for Boost, SEPIC and FlybackLM3481-Q1—2.97-V to 48-V high-efficiency controller for boost, SEPIC and flyback, AEC-Q100 qualifiedLM3488—2.97V to 40V Wide Vin Low-Side N-Channel Controller for Switching RegulatorsLM3488Q-Q1—40-V wide VIN low-side N-channel controller for switching regulators with 5-µA shutdown currentLM5020—13-100V Wide Vin, Current Mode PWM Boost, Flyback, Sepic ControllerLM5022—6-60V Wide Vin, current mode boost, SEPIC and Flyback controllerTPS40210-Q1—4.5-V to 52-V wide input range current mode boost controller with 700-mV reference voltageTPS40211-Q1—4.5-V to 52-V wide input range current mode boost controller with 260-mV reference voltage
Boost converters (integrated switch)
LM2577—3.5-V to 40-V, 3-A low component count step-up regulatorLM2585—4-V to 40-V, 3-A step-up wide VIN flyback regulatorLM2586—4-V to 40-V, 3-A step-up wide VIN flyback regulator with frequency synchronizationLM2587—4V to 40V, 5A Step-Up Wide Vin Flyback RegulatorLM2588—4-V to 40-V, 5-A step-up wide VIN flyback regulator with frequency synchronizationLM2621—1.2V to 14V input voltage, 1A load current, step-up DC-DCLM2623—0.8V to 14V input voltage, 2A load current, step-up DC-DCLM2623-Q1—0.8-V to 14-V input voltage, 2-A load current, step-up DC/DC, AEC-Q100 qualifiedLM2735—520kHz/1.6MHz space efficient boost and SEPIC DC-DC regulatorLM2735-Q1—520-kHz, 1.6-MHz space efficient boost and SEPIC DC/DC regulator, AEC-Q100 qualifiedLM3578A—2-V to 40-VIN switching regulators in buck, boost, terminal, depending upon the applicationLM5000—3.1-40V Wide Vin, 2A Current Mode Non-Synchronous Boost RegulatorLM5001—3.1-75V Wide Vin, 1A Current Mode Non-Synchronous Switch Mode RegulatorLM5001-Q1—3.1-V to 75-V wide VIN, 1-A current mode non-synchronous switch mode regulatorLM5002—3.1-75V Wide Vin, 0.5A Current Mode Boost, Flyback, Sepic ConverterTL1451—Dual Pulse-Width-Modulation Control CircuitTL1451A—3.6V to 50V dual channel controller with Wide input voltage rangeTL1451A-EP—Enhanced Product Dual Pulse-Width-Modulation Control CircuitsTL1451A-Q1—3.6-V to 50-V dual-channel PWM controller, AEC-Q100 qualifiedTL5001—PWM Controller with wide input range, with ±5% tolerance on reference, operation –20°C to 85°CTL5001A—PWM Controller with wide input range, with ±3% tolerance on reference, operation –20°C to 85°CTL5001A-Q1—PWM Controller with wide input range, with ±3% tolerance on reference, operation –20°C to 85°CTL5001M—PWM Controller with wide input range, with ±5% tolerance on reference, operation –55°C to 125°CTPS43000—Multi-Topology (buck, boost, sepic) High Frequency DC/DC ControllerTPS55340—5-A, 40-V, wide VIN boost, flyback, & SEPIC converterTPS55340-EP—Enhanced integrated, 5-A, 40-V wide input range boost/SEPIC/flyback DC/DC regulatorTPS55340-Q1—Integrated, 5-A 40-V wide input range boost/SEPIC/flyback DC/DC regulator, AEC-Q100 qualifiedTPS61175—3-A ,40V High Voltage Boost Converter with Soft-start and Programmable Switching FrequencyTPS61175-Q1—3-A, 40-V high voltage boost converter with soft-start and programmable switching frequencyUC2572—Negative output Flyback pulse width modulator
Buck converters (integrated switch)
LM5015—4.25-75V, Monolithic Two-Switch Forward DC-DC Regulator
Flybuck converters
LM25017—7.5-48V Wide Vin, 650mA Constant On-Time Synchronous Buck RegulatorLM25018—7.5-48V Wide Vin, 300mA Constant On-Time Synchronous Buck RegulatorLM25019—7.5-48V Wide Vin, 100mA Constant On-Time Synchronous Buck RegulatorLM34925—7.5-100V Wide Vin, 100mA Integrated Secondary Bias Regulator for Isolated DC/DC ConvertersLM34926—7.5-100V Wide Vin, 300mA Integrated Secondary Bias Regulator for Isolated DC/DC ConvertersLM34927—7.5-100V Wide Vin, 600mA Integrated Secondary Bias Regulator for Isolated DC/DC ConvertersLM5017—7.5-100V Wide Vin, 600mA Constant On-Time Synchronous Buck RegulatorLM5018—7.5-100V Wide Vin, 300mA Constant On-Time Synchronous Buck RegulatorLM5019—7.5-100V Wide Vin, 100mA Constant On-Time Synchronous Buck RegulatorLM5160—LM5160 wide input 65V, 2A synchronous buck/Fly-Buck™ converterLM5160-Q1—Wide Input 65V, 2A Synchronous Buck / Fly-Buck™ ConverterLM5160A—LM5160A Wide Input 65V, 2A Synchronous Buck / Fly-Buck™ ConverterLM5161—Wide Input 4.5-V to 100-V, 1-A Synchronous Buck / Fly-Buck ConverterTPS55010—2.95V To 6V Input, 2W, Isolated DC/DC Converter with Integrated FETS
PWM controllers & resonant controllers
LM2524D—40V, 0.2A 550KHz PWM controllerLM3524D—40V, 0.2A 350KHz PWM controller

The CivilWeb Foundation Design Spreadsheet Suite includes all 12 of our foundation design spreadsheets covering all major spread foundation types. Using these spreadsheets the designer can easily complete any type of foundation design in accordance with either BS EN 1997 or BS 8004. Each spreadsheet also includes unique design and analysis tools which allow the designer to optimise the designs in minutes, saving many hours of detailed design work on every foundation design.

The CivilWeb Foundation Design Spreadsheet Suite is our best value foundation design bundle and can be purchased at the bottom of this page for only £50 (80% discount). The CivilWeb Foundation Design Spreadsheet Suite includes the following spreadsheets;

Pad Footing Design Spreadsheet

This spreadsheet completes the design of single pad foundations including a central column. The column can include axial, horizontal and moment forces. The spreadsheet includes a simplified version for fast calculation of straightforward pad foundations.

Eccentric Footing Design Excel Sheet

This spreadsheet completes the design of single pad footings subject to eccentric loading. The spreadsheet allows the designer to position the column anywhere on the footing. The spreadsheet also allows the designer to analyse a footing of any polygonal shape including re-entrant corners and asymmetrical footings.

Combined Footing Design Excel Sheet

This spreadsheet completes the design of rectangular combined footings. The designer can analyse combined footings of any size with two columns placed anywhere on the footing. The columns can include axial, horizontal and moment forces.

Strap Footing Design Excel Sheet

This spreadsheet completes the design of strap footings consisting of two pad footings joined by a connecting structural concrete beam. The spreadsheet calculates the required sizes of both the pad foundations and for the connecting concrete beam. The spreadsheet calculates the bending moments and shear forces in the pads and the beam in order to design the required reinforcement.

CalculationCalculationTransformer design calculation excel format

Mat Foundation Design Spreadsheet

This spreadsheet can be used to complete the design of mat foundations. The designer can analyse a mat foundation of any size including up to 32 columns placed anywhere on the foundation. The columns can be subjected to axial, horizontal and moment forces. The mat foundation can be analysed as either rigid or flexible depending on the size and thickness of the mat and the strength of the subgrade.

Design of Raft Foundation Spreadsheet

This spreadsheet can be used to design raft foundation subjected to a universally distributed loading. This is suitable for houses and small buildings with a raft foundation. The raft can be designed with a universally distributed loading and linear loads at the edges and corners of the raft.

Strip Footing Design Excel Spreadsheet

This spreadsheet completes the design of strip foundations including up to 16 columns placed anywhere along the strip footing. The columns can include axial, horizontal and moment forces making this spreadsheet suitable for warehouses and other buildings with column loads on long foundations.

Wall Footing Design Spreadsheet

This spreadsheet completes the design of long footings subjected to linear loads from walls. The spreadsheet allows the design to analyse a foundation of any length and width. The wall loads are a universal linear load per metre length of wall. This spreadsheet is suitable for house and small building foundations with wall loads.

Octagonal Vertical Vessel Foundation Design Spreadsheet

This spreadsheet can be used to design octagonal foundations such as those used for vertical vessels or pipelines. The spreadsheet can be used to design octagonal foundations of any size subjected to a single column load.

Beam On Elastic Foundation Spreadsheet

This spreadsheet can be used to model a large or long foundations which behave in a flexible rather than a rigid fashion. The spreadsheet models the system as a flexible beam supported by a Winkler foundation.

Transformer Design Calculator

Soil Bearing Capacity Calculation

This suite of spreadsheets includes 9 different methods of analysing the bearing capacity of soils. The spreadsheet includes 6 different analytical methods including the Terzaghi, Meyerhof and Hansen methods. The suite also includes 3 different methods of estimating the bearing capacity of soils from site investigation results.

Foundation Settlement Calculation Spreadsheet

This suite of spreadsheets includes all the tools required to complete a settlement analysis of any shallow foundation in any soil. The suite includes 6 different methods of settlement analysis including immediate, elastic, consolidation, differential, Schmertmann settlement and settlement from SI info.

CivilWeb Foundation Design Spreadsheet Suite

The CivilWeb Foundation Design Spreadsheet Suite includes all 12 of our powerful foundation design spreadsheets. The CivilWeb Foundation Design Spreadsheet Suite includes all the tools required to design any common type of shallow foundation in accordance with BS EN 1997 or BS 8004.

Transformer Design Calculation Excel Format

Buy our best value suite of foundation design spreadsheets now for only £50 (80% discount).