FREE DOWNLODE A ELECTRICAL SOFTWARE AND TOOLS

http://electricalnotes.wordpress.com/electrical-tools-excel-base/

Electrical Tools

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

(1) Cable Designing Program

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

(2) Conduit Size Selection Program

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

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

• 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

• Calculate Size of Fuse for Electrical Circuit.

(5) 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.

(6) Short Circuit Current Calculation at Various Point of Electrical Circuits(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.

(7) Circuit Breaker Tripping Settings.

• Calculate  Tripping Setting of Circuit Breaker.

(8) Motor Specifications

• Calculate Various Specification of Motor.

(9) Calculate  Home Electrical Load & Electrical Bill.

• 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

• 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.

• 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.

• 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.

• 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.

• 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.

• 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.

(16) 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.

(17) 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.

(18) 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.

(19) Calculate Size of Diesel Generator.

• Calculate Size of D.G Set for Linear,Non-Linear Load
• Calculate Size of D.G Set for Motor Load
• Calculate D.G Set Efficiency.
• Calculate UPL (Unit per Liter) of D.G Set
• Calculate Unit Power Cost of D.G Set
• Calculate Approximate Fuel Consumption.

(20) Calculate Size of air conditioning for room.

• Calculate Size of Air Conditioning for Your Room.
• Calculate AC Size in BTU/Hr.
• Calculate AC size in Tone.
• Calculate Heating and Cooling BTU.

(21) Calculate Transverse Load on PCC/RCC/RSJ/Tublar/RSJ Pole..

• Calculate Crippling load on Pole
• Calculate Wind Load on Pole.
• Calculate wind Load on all Conductors.
• Calculate Transverse Load on Pole
• Decide spacing between Two Conductor as per IS:5613.
• Calculate required Voltage level of Overhead Line according to Distance.

(22) Calculate % Voltage Regulation of Small Distribution Line.

• Calculate % Voltage Regulation of Small Distribution Line
• Calculate % Voltage drop of Individual Load.
• Calculate % Voltage drop of Various ACSR, AAAC, AAC conductor overhead Line.
• Calculate Receiving end Voltage of Distribution Line.
• Calculate Total % Voltage Regulation of Distribution Line.

(23) IDMT Over current & Earth Fault Relay Setting:

• Calculate IDMT Over Current Relay Setting (50/51)
• Calculate IDMT Over Current Relay Pick up setting.
• Calculate IDMT Over Current Relay PSM.
• Calculate IDMT Over Current Relay Time setting.
• Calculate Actual Operating time according to Various IES Curve.
• Calculate Low current Setting(I>).
• Calculate High Current Setting(I>>)
• Calculate Actual Operating Time of Relay(t>)
• Calculate Actual Operating Time of Relay(t>>)
• Calculate IDMT Earth Fault Relay Setting (50N/51N) 
•  Calculate IDMT Earth Fault Relay Pick up setting.
• Calculate IDMT Earth Fault Relay PSM
• Calculate IDMT Earth Fault Relay Time setting
• Calculate Actual Operating time according to Various IES Curve.
• Calculate Low current Setting(Ie>)
• Calculate High Current Setting(Ie>>)
•  Calculate Actual Operating Time of Relay(te>)
•  Calculate Actual Operating Time of Relay(te>>)

(24) IDMT Relay Setting & Curves:

• Calculation of Actual Plug (Relay Pick up) setting of Various IDMT Relay.
• Calculate PSM of Various IDMT Relay.
• Calculate Time setting of Various IDMT Relay.
• Calculate Total Grading Time of Various IDMT Relay.
• Calculate Actual Operating time according to Various IES Curve.
• Draw Various IDMT Relay characteristic Curve.

(25) IDMT Over Current Relay Grading Calculation (50/51):

• Calculate IDMT Over current Relay Grading up to 5 Nos of Radial Bus bar System.
• Calculate Relay Pick up setting of IDMT Over current Relay from Downstream to Source End.
• Calculate PSM of Various IDMT Relay from Downstream to Source End.
• Calculate Time setting of Various IDMT Relay from Downstream to Source End.
• Calculate Total Grading Time of Various IDMT Relay from Downstream to Source End.
• Calculate Actual Relay Operating time according to Various IES Curve.

(26) Transformer IDMT Over Current & Earth Fault Relay Setting:

• Calculate LT & HT Side IDMT Over Current Relay Setting (50/51)
• Calculate LT & HT Side IDMT Over Current Relay Pick up setting.
• Calculate LT & HT Side IDMT Over Current Relay PSM.
• Calculate LT & HT Side IDMT Over Current Relay Time setting.
• Calculate Actual Operating time according to Various IES Curve.
• Calculate LT & HT Side Low current Setting(I>).
• Calculate LT & HT Side High Current Setting(I>>)
• Calculate LT & HT Side Actual Operating Time of Relay(t>)
• Calculate LT & HT Side Actual Operating Time of Relay(t>>)
• Calculate LT & HT Side IDMT Earth Fault Relay Setting (50N/51N) 
•  Calculate LT & HT Side IDMT Earth Fault Relay Pick up setting.
• Calculate LT & HT Side IDMT Earth Fault Relay PSM
• Calculate LT & HT Side IDMT Earth Fault Relay Time setting
• Calculate Actual Operating time according to Various IES Curve.
• Calculate LT & HT Side Low current Setting(Ie>)
• Calculate LT & HT Side High Current Setting(Ie>>)
•  Calculate LT & HT Side Actual Operating Time of Relay(te>)
•  Calculate LT & HT Side Actual Operating Time of Relay(te>>)
• Calculate Differential Protection Relay setting:
• Calculate Percentage Differential Current at Normal tapping
• Calculate Percentage Differential Current at Highest tapping
• Calculate Percentage Differential Current at Lowest tapping