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

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

## 2 comments:

I have read your blog its very attractive and impressive. I like it your blog.

Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

Java Online Training from India Java Online Training from India Core Java Training Online Core Java Training Online Java Training InstitutesJava Training Institutes

I have read your blog its very attractive and impressive. I like it your blog.

Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

Java Online Training from India Java Online Training from India Core Java Training Online Core Java Training Online Java Training InstitutesJava Training Institutes

## Post a Comment