# Electrical Programs( Excel Base)

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 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 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 Size of Cables for Each Outgoing Feeder.

### (13) Calculate Size of Battery Bank and Inverter.

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

### (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.

Jignesh Parmar has completed M.Tech (Power System Control), B.E(Electrical) from Gujarat University. He has more than 14 years experience in Power Transmission-Power Distribution-Electrical energy theft detection-Electrical Maintenance-Electrical Projects(Planning-Designing-coordination-Execution). He is Presently associate with one of the leading business group as a Deputy Manager at Ahmedabad,India. He is Freelancer Programmer of Advance Excel and design useful Excel Sheets of Electrical Engineering as per IS,NEC,IEC,IEEE codes. He is technical Author for "Electrical Mirror" and "Electrical India" Magazines. He is Technical Blogger and Familiar with English, Hindi, Gujarati, French languages. He wants to Share his experience & knowledge and help technical enthusiasts to find suitable solutions and updating themselves on various Engineering Topics.

### 24 Responses to Electrical Programs( Excel Base)

1. Gilbert says:

Are not available:
(17) Calculate Touch Voltage and Ground Current.
(18) Calculate Size of Diesel Generator.

The file You are looking for… may be deleted by the user or by the Adminstrator !

2. Sanjay Kumar says:

3. aravindan says:

i want CONTINUOUS CURRENT RATING CALCULATION for EHV cables in xls format

4. kundan singh says:

Thanks for data available for all people, its very great think to share you your experiences

5. Kartikey says:

I can not able to downlaod the files… No POP up is Blocked

6. Shah Moshahed Ullah Quaderi says:

7. sumesh says:

tks for the most valuable software given free for us… thank you very much… good job.. tks

8. Ach Dee says:

thanks a lot.

9. Ilan says:

Dear Sir,

10. Prasert says:

Dear Sir,

Many Thanks

Best reagrds,
Prasert L.
From Thailand,

Dear Sir,

for(i=0,i<infinity,i++)
print("MANY THANKS")

many thanks sir, may god bless yoy

13. Himmat Singh says:

Dear Sir
we have manual Megger Meter for earthing checking but we don’t know how to check earthing please help !

14. sathishkumr s says:

thank u so much sir for your great job, it will be keep on going

15. sakthi says:

cable sizing for 33 kv not available

16. Lemuel Errayah says:

Greetings is there a program to calculate starting a VSD with a Generator

17. Manas Ranjan Panda says:

Dear Jignesh Sir,
you are doing a great job.

I am Assit Manager/Rolling Stock in Delhi Metro rail Corporation. During the construction of metro line, some sheer connector is being used and it has to be insulated from the civil structure therefore we have provided epoxy resign to it and further heat shrinkable sleeves also has been provided to it. after the casting of the viaduct, the insulation resistance has to be measure and the permissible limit is 2.5 k Ohm.

All the merger instrument available in market are of M Ohm type. Then how to measure the insulation resistance in K.ohm. is there any method or instrument available to measure 2.5 Kilo Ohm insulation resistance.

18. md.rahmat ullah says:

IT COMES .EXE FILE

19. Dear Sir,

I have purchased all 47 calculation sheet on 16.05.2016. and written a mail on same day and awaiting your reply till now i.e., 13/6/2016.

While going through the attached sheet for D. G. sizing found lots of discrepancies. Hence you are requested to explain and elaborate for better understanding of myself as follows:

In practical all DG sets above 10-15 KVA are available in 3ph 4 wire system, hence single phase calculation is irrelevant in my case.

Secondly you have projected cost of electricity @ Rs.135/ KWH considering Diesel cost @Rs54.00/ Ltr. which is totally impractical.

Awaiting your early reply in this regard shall help me a lot.

With Warm Regards,

Diwakar Shahi

20. ankit says:

dear sir
pl send the excel calculation of earth mat design of substation