Excel base Programs (Electrical Engineering):Designed by: Jignesh.Parmar
(1) Cable size and Voltage Drop Calculation
- Calculate Voltage drop of Cable.
- Calculate Size of Cable as per Electrical Load.
- Calculate Current Capacity of Cable.
- Calculate No of Run of Cable.
- Calculate Motor Starting Voltage Drop.
- Calculate Motor Running Voltage Drop.
- Select appropriate Starter for Motor.
(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 Active and Reactive Power of System.
- Calculate Leading Kvar of system.
- Calculate Kvar/Phase.
- Calculate Size of Capacitor for Power Factor Improvements.
- Calculate Size of Main Fuse of Capacitor Bank
- Calculate Size of Main Circuit Breaker
- Calculate Thermal/Magnetic Setting of Circuit Breaker.
- Calculate Max.Demand/KVA Demand/Total Annual cost befor Power Factor Correction.
- Calculate Max.Demand/KVA Demand/Total Annual cost After Power Factor Correction.
- Calculate Annual Saving by improving Power Factor by Capacitor.
- Design Capacitor bank according to it’s Step Combination.
(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
(27) Calculate Transformer Over current Protection (As per NEC 450.3)
- Calculate Size of Circuit Breaker on Primary side of Transformer as per NEC 450.3
- Calculate Size of Fuse on Primary side of Transformer as per NEC 450.3
- Calculate Size of Circuit Breaker on Secondary side of Transformer as per NEC 450.3
- Calculate Size of Fuse on Secondary side of Transformer as per NEC 450.3
- Calculate Size of Transformer
- Calculate Transformer Full Load Losses.
(28) Calculate Number of Plate / Pipe Earthing:
- Calculate Permissible Current Density of Earth Electrode (Id).
- Calculate No of Copper Plates Earthing Required .
- Calculate No of Pipe Earthing Required.
- Calculate Overall Earthing Resistance of Earthing Electrodes.
- Calculate Resistance of Earthing Strip/Wire.
- Calculate Resistance as per Arrangement of Plate/Pipe Earthing.
- Calculate Total Earth Resistance of Plate/Pipe Earthing & Earth Strip.
- Calculate Minimum Size of of Earth Strip.
(29) Calculate Motor-Pump Size:
- Calculate Pump Hydraulic Power
- Calculate Motor-Pump Shaft Power
- Calculate Pump Size.
- Calculate Motor Size.
(30) Design DOL/Star-Delta Starter:
- Calculate Lock Rotor Current.
- Calculate Motor Starting Current.
- Calculate Motor Full Load Current.
- Calculate Non-time Delay/Time Delay fuse Size.
- Calculate Circuit Breaker Size.
- Calculate Overload Relay setting.
- Calculate Type of Contactor.
- Calculate Size of Main Contactor.
- Calculate Size of Star Contactor.
- Calculate Size of Delta Contactor.
- Standard Arrangement of Main and Auxiliary Contactor.
(31) Size of Transformer and Voltage drop due to starting of large Motor
- Calculate Lock Rotor Current.
- Calculate Motor Starting Current.
- Calculate Motor Full Load Current.
- Calculate Non-time Delay/Time Delay fuse Size.
- Calculate Circuit Breaker Size.
- Calculate Overload Relay setting.
- Calculate Type of Contactor.
- Calculate Size of Main Contactor.
- Calculate Size of Star Contactor.
- Calculate Size of Delta Contactor.
- Standard Arrangement of Main and Auxiliary Contactor
(32) Calculate Number of Lighting Fixtures & Lux Level
- Calculate required No of Fixtures.
- Calculate required No of Lamps.
- Calculate Watts / Sq.foot.
- Calculate Energy Cost / Year.
- Calculate Actual Lux Level.