# Electrical Programs( Excel Base)

May 28, 2011 24 Comments

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

**(1) Cable Designing Program**

**FREE DOWNLOAD** ** BUY UNLOCK VERSION**

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

**(2) Conduit Size Selection Program**

**FREE DOWNLOAD **** BUY UNLOCK VERSION**

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

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

**FREE DOWNLOAD.**** ****BUY UNLOCK VERSION**

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

**FREE DOWNLOAD **** BUY UNLOCK VERSION**

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

**FREE DOWNLOAD** **BUY UNLOCK VERSION**

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

**FREE DOWNLOAD**. ** BUY UNLOCK VERSION**

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

** FREE DOWNLOAD.**** BUY UNLOCK VERSION**

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

**FREE DOWNLOAD.**** **** BUY UNLOCK VERSION**

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

**FREE DOWNLOAD.**** ****BUY UNLOCK VERSION**

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

**FREE DOWNLOAD**** ****BUY UNLOCK VERSION**

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

**FREE DOWNLOAD **** **** **

**BUY UNLOCK VERSION**- 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.**

**FREE DOWNLOAD **** **

**BUY UNLOCK VERSION**- 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. **

**FREE DOWNLOAD **** ****BUY UNLOCK VERSION**

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

**FREE DOWNLOAD **** **

**BUY UNLOCK VERSION**- 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.**

**FREE DOWNLOAD BUY UNLOCK VERSION**

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

**FREE DOWNLOAD**** **

**BUY UNLOCK VERSION**- 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.**

** FREE DOWNLOAD.**** BUY UNLOCK VERSION**

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

Are not available:

(17) Calculate Touch Voltage and Ground Current.

(18) Calculate Size of Diesel Generator.

File not found

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

i was able to download file when i tried second time

Its very easy to download.

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

thanks a lot

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

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

I am appreciated all of you for free download documents.It is almost valuable for me and lead my professional escalation.

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

thanks a lot.

Dear Sir,

Thanks for your continues support

Dear Sir,

Many Thanks

Best reagrds,

Prasert L.

From Thailand,

Dear Sir,

for(i=0,i<infinity,i++)

print("MANY THANKS")

Dear Mohammad,

A1=Vlookup(“Complement of Mohammad Ashraf”,2,TRUE)

A2=If (A1=”MANY THANKS”,”Thanks for Complement”,””)

A3=Print(A3)

many thanks sir, may god bless yoy

Dear Sir

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

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

cable sizing for 33 kv not available

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

Dear Jignesh Sir,

you are doing a great job.

thank you for your service.

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.

IT COMES .EXE FILE

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

This is only sample calculation , You can edit/ Modify the data as per your requirement.

dear sir

pl send the excel calculation of earth mat design of substation