Electrical Excel Tools
March 22, 2011 50 Comments
Excel base Programs (Electrical Engineering): Designed by: Jignesh.Parmar
- Calculate Voltage drop of Cable.
- Calculate Size of Cable.
- Calculate Current Capacity of Cable.
Conduit Size Selection Program
- Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.
Selection of MCCB,ELCB For Main /Branch Circuit.
- 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
- Calculate Size of Fuse for Electrical Circuit.
Size of Capacitor For Power Factor Improvements
- 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).
- 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.
- Calculate Tripping Setting of Circuit Breaker.
Motor Specifications
- Calculate Various Specification of Motor.
Calculate Home Electrical Load & Electrical Bill.
- 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
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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:
- 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.
- 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.
JIGNESH PARMAR
Electrical Notes & Articles 
Recent Comments