Hojas de Calculo en Excel para diseños electricos

'Wayne · mayo 11, 2011

las encontre por ahi, tal vez les sean utiles

Electrical Excel Tools

Posted: March 22, 2011 by Jignesh.Parmar in Uncategorized

Excel base Programs (Electrical Engineering): Designed by: Jignesh.Parmar
Cable Designing Program

FREE DOWNLOAD

Calculate Voltage drop of Cable.
Calculate Size of Cable.
Calculate Current Capacity of Cable.

Conduit Size Selection Program

FREE DOWNLOAD

Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.

Selection of MCCB,ELCB For Main /Branch Circuit.

FREE DOWNLOAD

Calculate Size and Type of Main MCCB/RCCB/ELCB for Continious and Non Continious Load
Calculate Sensitivity of MCCB/RCCB/ELCB.
Calculate Size of Cable.
Calculate Size and Type of Sub Circuit MCCB/MCB for Continious and Non Continious Load
Calculate Total Load .
Calculate Main and Branch Circuit Current.

Selection of Fuses

FREE DOWNLOAD

Calculate Size of Fuse for Electrical Circuit.

Size of Capacitor For Power Factor Improvements

FREE DOWNLOAD

Calculate Size of Capacitor for Power Factor Improvements.
Calculate Annual Saving by selection of Capacitor.
Calculate Active and Reactive Power.

Short Circuit Current Calculation at Various Point of Electrical Curcuits(Isc).

FREE DOWNLOAD

Calculate Short Circuit Current at Substation.
Calculate Short Circuit Current at Distribution point.
Calculate Short Circuit Current at Transformer.
Calculate Short Circuit Current at Main Panel.
Calculate Short Circuit Current at Sub Distribution Board.

Circuit Breaker Tripping Settings.

FREE DOWNLOAD

Calculate Tripping Setting of Circuit Breaker.

Motor Specifications

FREE DOWNLOAD

Calculate Various Specification of Motor.

Calculate Home Electrical Load & Electrical Bill.

FREE DOWNLOAD

Calculate Electrical Bill of Home
Calculate Size of MCCB/MCB for Domestic Load
Calculate Electrical Load of Home.

Calculate Insulation Resistance Value and PI value

FREE DOWNLOAD

Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
Calculate IR Value of Electrical Equipments.
Graph of IR Value
Calculate Polarization Index Value with Graph
Calculate Earth Resistivity.

Calculate Electrical Load and Energy Consumption of Panel.

FREE DOWNLOAD

Calculate Continuous and non Continuous Electrical Load of Panel.
Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
Calculate Size of MCB of each branch circuit of Panel.
Calculate Voltage / Voltage Difference of Each Phase
Calculate Unbalanced Load in Neutral Wire.
Calculate Expected Temperature rise in Each Phase.
Calculate Load in Each Phase.
Calculate Starting/Full Load/Continuous/Non Continuous Load
Calculate Size/Type/Tripping setting of Main MCCB.

Calculate Electrical Load of Panel.

FREE DOWNLOAD

Calculate Voltage / Voltage Difference of Each Phase
Calculate Unbalanced Load in Neutral Wire.
Calculate Expected Temperature rise in Each Phase.
Calculate Load in Each Phase and Outgoing Feeders.
Calculate Starting/Full Load/Continuous/Non Continuous Load
Calculate Size of Cables for Each Outgoing Feeder.

Calculate Size of Battery Bank and Inverter.

FREE DOWNLOAD

Calculate Total Demand Load
Calculate Size of Battery Bank in Amp.Hr.
Select Type of Connection of Batteries in Battery Bank
Select Rating of Each Battery in Battery Bank
Calculate Size of Inverter.
Calculate Size/Type/Tripping setting of Main MCCB.

Calculate Size of Solar Panel / Battery Bank / Inverter.

FREE DOWNLOAD

Calculate Total Demand Load
Calculate Size of Solar Panel.
Select Type of Connection of Solar Panel.
Select Rating of Each Solar Panel.
Calculate Energy from Solar Panel as per Daily Sun lights.
Calculate Size Battery Bank.
Select Type of connection of Batteries in Battery Bank
Calculate size of Inverter

Calculate No of Lighting Fittings and Lumen Output.

FREE DOWNLOAD

Calculate Total Lumen Output for particular Area.
Calculate Total No of Lighting Lamps.
Calculate Total No of Lighting Fixtures.
Calculate No of Fittings along with the Length and Width of Room.

Calculate Bus Bar Size and Voltage Drop.

FREE DOWNLOAD

Calculate Voltage Drop for Bus Bar.
Select Size of Bus Bar for particular Load.
Enter Your Sub Panel Details like Load,Line Length.

Design of Earthing Mat for Sub-Station:

FREE DOWNLOAD

Program is design as per ANSI/IEEE 80-1986 Code.
Calculate Step Potential of Switch yard.
Calculate Touch Potential of Switch yard.
Calculate Total Length of Earthing Mat Conductor.
Calculate Size of Earthing Mat Conductor.
Calculate Total No of Earthing Rods.

Calculate Touch Voltage and Ground Current.

FREE DOWNLOAD

Calculate Resistance of Each Phase.
Calculate Resistance of neutral/Ground.
Calculate Neutral Current and Load.
Calculate Touch Voltage for Metal part to Earth.
Calculate Body Resistance and Body Current.

'Wayne · mayo 31, 2011

esto tambien puede complementar el post
http://es.scribd.com/doc/17007067/Ug...eferences-2005

'Wayne · mayo 31, 2011

(1) Cable Designing Program

FREE DOWNLOAD

Calculate Voltage drop of Cable.
Calculate Size of Cable.
Calculate Current Capacity of Cable.

(2) Conduit Size Selection Program

FREE DOWNLOAD

Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.

(3) Selection of MCCB, ELCB For Main /Branch Circuit.

FREE DOWNLOAD

Calculate Size and Type of Main MCCB/RCCB/ELCB for Continuous and Non Continuous Load
Calculate Sensitivity of MCCB/RCCB/ELCB.
Calculate Size of Cable.
Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
Calculate Total Load .
Calculate Main and Branch Circuit Current.

(4) Selection of Fuse

FREE DOWNLOAD

Calculate Size of Fuse for Electrical Circuit.

(5) Size of Capacitor For Power Factor Improvements

FREE DOWNLOAD

Calculate Size of Capacitor for Power Factor Improvements.
Calculate Annual Saving by selection of Capacitor.
Calculate Active and Reactive Power.

(6) Short Circuit Current Calculation at Various Point of Electrical Circuits(Isc).

FREE DOWNLOAD

Calculate Short Circuit Current at Substation.
Calculate Short Circuit Current at Distribution point.
Calculate Short Circuit Current at Transformer.
Calculate Short Circuit Current at Main Panel.
Calculate Short Circuit Current at Sub Distribution Board.

(7) Circuit Breaker Tripping Settings.

FREE DOWNLOAD

- Calculate Tripping Setting of Circuit Breaker.

(8) Motor Specifications

FREE DOWNLOAD

- Calculate Various Specification of Motor.

(9) Calculate Home Electrical Load & Electrical Bill.

FREE DOWNLOAD

Calculate Electrical Bill of Home
Calculate Size of MCCB/MCB for Domestic Load
Calculate Electrical Load of Home.

(10) Calculate Insulation Resistance Value and PI value

FREE DOWNLOAD

Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
Calculate IR Value of Electrical Equipments.
Graph of IR Value
Calculate Polarization Index Value with Graph
Calculate Earth Resistivity.

(11) Calculate Electrical Load and Energy Consumption of Panel.

FREE DOWNLOAD

- Calculate Continuous and non Continuous Electrical Load of Panel.
- Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
- Calculate Size of MCB of each branch circuit of Panel.
- Calculate Voltage / Voltage Difference of Each Phase
- Calculate Unbalanced Load in Neutral Wire.
- Calculate Expected Temperature rise in Each Phase.
- Calculate Load in Each Phase.
- Calculate Starting/Full Load/Continuous/Non Continuous Load
- Calculate Size/Type/Tripping setting of Main MCCB.

(12) Calculate Electrical Load of Panel.

FREE DOWNLOAD

Calculate Voltage / Voltage Difference of Each Phase
Calculate Unbalanced Load in Neutral Wire.
Calculate Expected Temperature rise in Each Phase.
Calculate Load in Each Phase and Outgoing Feeders.
Calculate Starting/Full Load/Continuous/Non Continuous Load
Calculate Size of Cables for Each Outgoing Feeder.

(13) Calculate Size of Battery Bank and Inverter.

FREE DOWNLOAD

Calculate Total Demand Load
Calculate Size of Battery Bank in Amp.Hr.
Select Type of Connection of Batteries in Battery Bank
Select Rating of Each Battery in Battery Bank
Calculate Size of Inverter.
Calculate Size/Type/Tripping setting of Main MCCB.

(14) Calculate Size of Solar Panel / Battery Bank / Inverter.

FREE DOWNLOAD

Calculate Total Demand Load
Calculate Size of Solar Panel.
Select Type of Connection of Solar Panel.
Select Rating of Each Solar Panel.
Calculate Energy from Solar Panel as per Daily Sun lights.
Calculate Size Battery Bank.
Select Type of connection of Batteries in Battery Bank
Calculate size of Inverter

(15) Calculate No of Lighting Fittings and Lumen Output.

FREE DOWNLOAD

Calculate Total Lumen Output for particular Area.
Calculate Total No of Lighting Lamps.
Calculate Total No of Lighting Fixtures.
Calculate No of Fittings along with the Length and Width of Room.

Calculate Bus Bar Size and Voltage Drop.

FREE DOWNLOAD

- Calculate Voltage Drop for Bus Bar.
- Select Size of Bus Bar for particular Load.
- Enter Your Sub Panel Details like Load,Line Length.

(16) Design of Earthing Mat for Sub-Station:

FREE DOWNLOAD

- Program is design as per ANSI/IEEE 80-1986 Code.
- Calculate Step Potential of Switch yard.
- Calculate Touch Potential of Switch yard.
- Calculate Total Length of Earthing Mat Conductor.
- Calculate Size of Earthing Mat Conductor.
- Calculate Total No of Earthing Rods.

(17) Calculate Touch Voltage and Ground Current.

FREE DOWNLOAD