Electrical Programs( Excel Base)

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

FREE DOWNLOAD         

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

FREE DOWNLOAD

  • Calculate  Tripping Setting of Circuit Breaker.

(8) Motor Specifications

FREE DOWNLOAD

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

  FREE DOWNLOAD.      

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

  FREE DOWNLOAD 

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

 

About Jignesh.Parmar
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.

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

  2. Sanjay Kumar says:

    Its very easy to download.

  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:

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

  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,

    Thanks for your continues support

  10. Prasert says:

    Dear Sir,

    Many Thanks

    Best reagrds,
    Prasert L.
    From Thailand,

  11. Mohammad Ashraf says:

    Dear Sir,

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

  12. Amjad Shah says:

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

  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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: