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.
Post a Comment