Electrical.Tool

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

Buy All (47 No’s) of Unlock Electrical Software at 30% Discount (US $)   

Buy All (47 No’s) of Unlock Electrical Software at 40% Discount (Indian Rs)

(1) Cable size and Voltage Drop Calculation

  FREE DOWNLOAD          BUY UNLOCK VERSION($)         BUY UNLOCK VERSION(Rs)

  • Calculate Voltage drop of Cable.
  • Calculate  Size of Cable as per Electrical Load.
  • Calculate Current Capacity of Cable.
  • Calculate No of Run of Cable.
  • Calculate Motor Starting Voltage Drop.
  • Calculate Motor Running Voltage Drop.
  • Select appropriate Starter for Motor.

(2) Selection of  Main /Branch Circuit MCB as per NEC-210.

      FREE DOWNLOAD       BUY UNLOCK VERSION($)      BUY UNLOCK VERSION(Rs)

  • Calculate  Size and Type of Main MCCB/RCCB/ELCB for Continuous Load
  • Calculate  Size and Type of Main MCCB/RCCB/ELCB for Non Continuous Load
  • Calculate  Sensitivity of MCCB/RCCB/ELCB.
  • Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
  • Calculate Total Load .
  • Calculate Max.Length of Cable.
  • Calculate Main and Branch Circuit Current.

(3) C.B Tripping Setting & Fuse for Motor Protection

    FREE DOWNLOAD           BUY UNLOCK VERSION($) 

  • Calculate Size of Fuse for Electrical Circuit.
  • Calculate  Tripping Setting of Circuit Breaker.
  • Calculate Various Specification of Motor.
  • Calculate Motor Full Load Current.
  • Calculate Motor Locked Rotor Current.
  • Calculate Motor Protection Setting

(4) Calculate Size of air condition 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.

(5) Calculate Motor-Pump Size:

    FREE DOWNLOAD       BUY UNLOCK VERSION($)

  • Calculate Pump Hydraulic Power
  • Calculate Motor-Pump Shaft Power
  • Calculate Pump Size.
  • Calculate Motor Size.

(6) Calculate Electrical Unit Consumption & Energy Bill

   FREE DOWNLOAD       BUY UNLOCK VERSION($)       BUY UNLOCK VERSION(Rs)

  • Calculate Electrical Unit (KWH) consumption per month
  • Quick Calculate Electrical Bill as per Electrical Slab Rate
  • Calculate Total KW.

(7) Calculate Insulation Resistance Value

    FREE DOWNLOAD.   BUY UNLOCK VERSION($)     BUY UNLOCK VERSION(Rs)

  • Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
  • Calculate IR Value of Electrical Equipments.
  • Graph of  IR Value
  • Calculate Earth Resistivity.

(8) Calculate Polarization Index Value

    FREE DOWNLOAD.   BUY UNLOCK VERSION($)     BUY UNLOCK VERSION(Rs)

  • Graph of  IR Value
  • Calculate Polarization Index Value with Graph

 (9) Calculate Earth Resistance Value

    FREE DOWNLOAD.   BUY UNLOCK VERSION($)     BUY UNLOCK VERSION(Rs)

  •  Calculate Earth Resistivity.

 (10) 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.

 (11) 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.

 (12) Calculate Size of Battery Bank and Inverter.

    FREE DOWNLOAD     BUY UNLOCK VERSION($)       BUY UNLOCK VERSION(Rs)

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

 (13) Calculate Transverse Load on PCC/RCC/RSJ/Tublar Pole.

  FREE DOWNLOAD.      BUY UNLOCK VERSION($)

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

 (14) 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.

 (15) Calculate Size of Solar Panel / Battery Bank / Inverter.

   FREE DOWNLOAD      BUY UNLOCK VERSION($)   BUY UNLOCK VERSION(Rs)

  • 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

 (16) Size of Capacitor  For Power Factor Improvements

    FREE DOWNLOAD     BUY UNLOCK VERSION($)    BUY UNLOCK VERSION(Rs)

  • Calculate Active and Reactive Power of System.
  • Calculate Leading Kvar of system.
  • Calculate Kvar/Phase.
  • Calculate Size of Capacitor for Power Factor Improvements.
  • Calculate Size of Main Fuse of Capacitor Bank
  • Calculate Size of Main Circuit Breaker
  • Calculate Thermal/Magnetic Setting of Circuit Breaker.
  • Calculate Max.Demand/KVA Demand/Total Annual cost befor Power Factor Correction.
  • Calculate Max.Demand/KVA Demand/Total Annual cost After Power Factor Correction.
  • Calculate Annual Saving by improving Power Factor by Capacitor.
  • Design Capacitor bank according to it’s Step Combination.

 (17) Residence Distribution Box’s- MCB- Wire Size Calculation

   FREE DOWNLOAD     BUY UNLOCK VERSION($)       BUY UNLOCK VERSION(Rs)

  • Calculate Size of Residence Distribution Box.
  • Calculate Per Phase Load on Distribution Box.
  • Calculate Unbalance Neutral Current.
  • Calculate Total Current on Distribution Box.
  • Calculate Total KW Load on Distribution Box.
  • Calculate Size of Main MCCB/ELCB/RCB of Distribution Box
  • Calculate Size of Branch Circuit MCB.
  • Calculate Size of Wire for Branch MCB.

 (18) Electrical Panel’s MCB & Cable Size Calculation.

    FREE DOWNLOAD.     BUY UNLOCK VERSION($)      BUY UNLOCK VERSION(Rs)

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

(19) Calculate Electrical Load and Energy Consumption of Panel.

   FREE DOWNLOAD.     BUY UNLOCK VERSION($)      BUY UNLOCK VERSION(Rs)

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

(20) Calculate % Voltage Regulation of Small Distribution Line.

    FREE DOWNLOAD          BUY UNLOCK VERSION($)

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

 (21) IDMT Over current & Earth Fault Relay Setting:

     FREE DOWNLOAD           BUY UNLOCK VERSION($)

  • Calculate IDMT Over Current Relay Setting (50/51)
  • Calculate IDMT Over Current Relay Pick up setting.
  • Calculate IDMT Over Current Relay PSM.
  • Calculate IDMT Over Current Relay Time setting.
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate Low current Setting(I>).
  • Calculate High Current Setting(I>>)
  • Calculate Actual Operating Time of Relay(t>)
  • Calculate Actual Operating Time of Relay(t>>)
  • Calculate IDMT Earth Fault Relay Setting (50N/51N) 
  •  Calculate IDMT Earth Fault Relay Pick up setting.
  • Calculate IDMT Earth Fault Relay PSM
  • Calculate IDMT Earth Fault Relay Time setting
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate Low current Setting(Ie>)
  • Calculate High Current Setting(Ie>>)
  •  Calculate Actual Operating Time of Relay(te>)
  •  Calculate Actual Operating Time of Relay(te>>)

(22) IDMT Relay Setting & Curves:

     FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculation of Actual Plug (Relay Pick up) setting of Various IDMT Relay.
  • Calculate PSM of Various IDMT Relay.
  • Calculate Time setting of Various IDMT Relay.
  • Calculate Total Grading Time of Various IDMT Relay.
  • Calculate Actual Operating time according to Various IES Curve.
  • Draw Various IDMT Relay characteristic Curve.

(23) IDMT Over Current Relay Grading Calculation (50/51):

    FREE DOWNLOAD            BUY UNLOCK VERSION($)

  • Calculate IDMT Over current Relay Grading up to 5 Nos of Radial Bus bar System.
  • Calculate Relay Pick up setting of IDMT Over current Relay from Downstream to Source End.
  • Calculate PSM of Various IDMT Relay from Downstream to Source End.
  • Calculate Time setting of Various IDMT Relay from Downstream to Source End.
  • Calculate Total Grading Time of Various IDMT Relay from Downstream to Source End.
  • Calculate Actual Relay Operating time according to Various IES Curve.

(24) Transformer IDMT Over Current & Earth Fault Relay Setting:

    FREE DOWNLOAD        BUY UNLOCK VERSION($)

  • Calculate LT & HT Side IDMT Over Current Relay Setting (50/51)
  • Calculate LT & HT Side IDMT Over Current Relay Pick up setting.
  • Calculate LT & HT Side IDMT Over Current Relay PSM.
  • Calculate LT & HT Side IDMT Over Current Relay Time setting.
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate LT & HT Side Low current Setting(I>).
  • Calculate LT & HT Side High Current Setting(I>>)
  • Calculate LT & HT Side Actual Operating Time of Relay(t>)
  • Calculate LT & HT Side Actual Operating Time of Relay(t>>)
  • Calculate LT & HT Side IDMT Earth Fault Relay Setting (50N/51N) 
  •  Calculate LT & HT Side IDMT Earth Fault Relay Pick up setting.
  • Calculate LT & HT Side IDMT Earth Fault Relay PSM
  • Calculate LT & HT Side IDMT Earth Fault Relay Time setting
  • Calculate Actual Operating time according to Various IES Curve.
  • Calculate LT & HT Side Low current Setting(Ie>)
  • Calculate LT & HT Side High Current Setting(Ie>>)
  •  Calculate LT & HT Side Actual Operating Time of Relay(te>)
  •  Calculate LT & HT Side Actual Operating Time of Relay(te>>)
  • Calculate Differential Protection Relay setting:
  • Calculate Percentage Differential Current at Normal tapping
  • Calculate Percentage Differential Current at Highest tapping
  • Calculate Percentage Differential Current at Lowest tapping

(25)  Size of Transformer’s Circuit Breaker & Fuse (As per NEC 450.3)

     FREE DOWNLOAD.           BUY UNLOCK VERSION($)

  • Calculate Size of Circuit Breaker on Primary side of Transformer as per NEC 450.3
  • Calculate Size of Fuse on Primary side of Transformer as per NEC 450.3
  • Calculate Size of Circuit Breaker on Secondary side of Transformer as per NEC 450.3
  • Calculate Size of Fuse on Secondary side of Transformer as per NEC 450.3
  • Calculate Size of Transformer
  • Calculate Transformer Full Load Losses.

 (26) Size of Transformer & Voltage drop due to starting of large Motor

    FREE DOWNLOAD.     BUY UNLOCK VERSION($)

  • Calculate Lock Rotor Current.
  • Calculate Motor Starting Current.
  • Calculate Motor Full Load Current.
  • Calculate Non-time Delay/Time Delay fuse Size.
  • Calculate Circuit Breaker Size.
  • Calculate Overload Relay setting.
  • Calculate Type of Contactor.
  • Calculate Size of Main Contactor.
  • Calculate Size of Star Contactor.
  • Calculate Size of Delta Contactor.
  • Standard Arrangement of Main and Auxiliary Contactor

 (27) Calculate Number of Plate / Pipe Earthing:

      FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Permissible Current Density of Earth Electrode (Id).
  • Calculate No of Copper Plates Earthing Required .
  • Calculate No of Pipe Earthing Required.
  • Calculate Overall Earthing Resistance of Earthing Electrodes.
  • Calculate Resistance of Earthing Strip/Wire.
  • Calculate Resistance as per Arrangement of Plate/Pipe Earthing.

 (28) Calculate Size of Earthing Strip / Wire:

      FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Resistance of Earthing Strip/Wire.
  • Calculate Minimum Size of of Earth Strip/Wire.

(29) Design DOL &  Star Delta Starter Parts:

    FREE DOWNLOAD.           BUY UNLOCK VERSION($)

  • Calculate Lock Rotor Current.
  • Calculate Motor Starting Current.
  • Calculate Motor Full Load Current.
  • Calculate Non-time Delay/Time Delay fuse Size.
  • Calculate Circuit Breaker Size.
  • Calculate Overload Relay setting.
  • Calculate Type of Contactor.
  • Calculate Size of Main Contactor.
  • Calculate Size of Star Contactor.
  • Calculate Size of Delta Contactor.
  • Standard Arrangement of Main and Auxiliary Contactor.

(30) Calculate No of Fixtures & Lux  as per Sq.Ft Area:

    FREE DOWNLOAD       BUY UNLOCK VERSION($)

  • Calculate required No of Fixtures.
  • Calculate required No of Lamps.
  • Calculate Watts / Sq.foot.
  • Calculate Energy Cost / Year.
  • Calculate Actual Lux Level.

 (31) Calculate No’s of Fixtures & Lumen for Indoor Lighting.

    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.

 (32) Size and Short Circuit Capacity of D.G Synchronous Panel

    FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Size of D.G Synchronous Panel.
  • Calculate Total Fault  Current of D.G Synchronous Panel.
  • Total Equivalent Impedance of  D.G Synchronous Panel.
  • Calculate Short Circuit Current of D.G Synchronous Panel.

(33) Short Circuit Current at various Point of Distribution System

    FREE DOWNLOAD     BUY UNLOCK VERSION($)    BUY UNLOCK VERSION(Rs)

  • Calculate Total impedance of upper stream.
  • Calculate Total impedance of Lower stream.
  • Calculate impedance of Transformer.
  • Calculate Fault current on Secondary of Transformer.
  • Calculate minimum size of Cable to withstand Isc.
  • Calculate Fault current at various location of Distribution System.
  • Calculate Min Size of Cable at various location of Distribution System.

  (34) Short Circuit Current Calculation (Base KVA Method)(Isc).

    FREE DOWNLOAD    BUY UNLOCK VERSION($)     BUY UNLOCK VERSION(Rs)

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

  (35) Technical Losses of Distribution Line

   FREE DOWNLOAD    BUY UNLOCK VERSION($)    BUY UNLOCK VERSION(Rs)

  • Calculate Total Connected Load of distribution Line.
  • Calculate Diversity Factor (DF) of distribution Line.
  • Calculate Load Factor (LF) of distribution Line.
  • Calculate Distribution Transformer Losses.
  • Calculate HT & LT Line Losses.

 (36) Transformer Losses Calculation(As per Test Result)

    FREE DOWNLOAD    BUY UNLOCK VERSION($)  BUY UNLOCK VERSION(Rs)

  • Calculate Total Core loss at actual voltage and freq.
  • Total Copper loss estimated at test current
  • Calculate Stray losses at test current
  • Calculate Total Copper loss at full load current.
  • Calculate Stray losses at full load current.
  • Calculate Total No Load losses at actual load.
  • Total Load Load losses at actual load
  • Total Losses at actual load.
  • Efficiency at actual load.

 (37) Transformer Losses and Payback period Calculation

   FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Comparison of Transformer No Load Losses.
  • Comparison of Transformer Load Losses.
  • Comparison of Transformer Annual Amount of Losses.
  • Comparison of Transformer Carbon Dioxide emission rate.
  • Calculate Total Owning Cost  (TOC) of Transformer.
  • Calculate Transformer Payback Period.
  • Calculate Annual Rate of Returns.

(38) Transformer Losses-Regulation-Efficiency(TC Name Plate)

    FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate No Load Losses at various Loading of Transformer.
  • Calculate Full Load Losses at various Loading of Transformer.
  • Calculate Percentage Impedance
  • Calculate Transformer regulation at various Power Factor.
  • Calculate Transformer Efficiency at Unity P.F at various Loading condition.
  •   Calculate Transformer Efficiency at various P.F at various Loading condition.

 (39) Calculate Voltage Drop and No’s of Street Light Pole

    FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Voltage drop in Street Light Pole
  • Calculate Distance between Each Street Light Pole
  • Calculate Wattage of each Street Light Luminaire
  • Calculate Required Street Light Watt as per Given Area.
  • Calculate Luminaire Payback Period

 (40)  No of Street Light Poles & Payback Period

    FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Wattage of each Street Light Luminaire
  • Calculate Required Street Light Watt as per Given Area.
  • Calculate Luminaire Payback Period

(41) Calculate Size of Neutral Earthing Transformer (NET)

   FREE DOWNLOAD     BUY UNLOCK VERSION($)

  • Calculate Total Capacitive charging current (It).
  • Calculate Neutral Earthing Transformer  Secondary Current.
  • Calculate Required Grounding Resistor value at primary side (Rp).
  • Calculate Required Resistance value at secondary side (Rsec).
  • Calculate Neutral Earthing Transformer X/R Ratio
  • Calculate Fault current through Neutral (single line to ground fault) (If)
  • Calculate Rating of Neutral Earthing Transformer (P).

(42) Calculate Bus bar Size for Panel

   FREE DOWNLOAD     BUY UNLOCK VERSION($)  BUY UNLOCK VERSION(Rs)

  • Calculate Bus Bar Cross Section Area
  • Calculate Current Rating of Bus Bar
  • Calculate Peak elector-magnetic Force between Phase Conductors
  • Calculate Force on Insulator of Bus bar Support.
  • Calculate Mechanical Strength of Bus Bar.
  • Calculate Maximum Temperature Rise of Bus Bar.

(43) Calculate Size of Cable Tray

   FREE DOWNLOAD     BUY UNLOCK VERSION($)  BUY UNLOCK VERSION(Rs)

  • Calculate Cable Tray width
  • Calculate Cable Tray area
  • Calculate Cable Tray length
  • Calculate Cable Tray Weight
  • Calculate Remaining width of Cable Tray
  • Calculate Remaining Area of Cable Tray

(44) Calculate Size of Conduit

   FREE DOWNLOAD     BUY UNLOCK VERSION($)  BUY UNLOCK VERSION(Rs)

  • Calculate Total Area of Multiple Cables.
  • Calculate Total Area of Conduit for Multiple Cables.
  • Calculate Fill up area of Conduit.
  • Calculate % Fill up area of Conduit.
  • Calculate No of Conduits for Multiple Cables.
  • Calculate Size of Conduits for Multiple Cables.

(45) Building Lighting Protection Calculation

   FREE DOWNLOAD    

  • Calculate Area of Building / Structure
  • Calculate Collection area of Structure
  • Calculate Probable No of Strike on Structure
  • Calculate Overall Risk Factor
  • Calculate whether Lighting Protection Required or Not
  • Calculate Number of Down Conductor

(46) Cable Voltage drop for different size of cable

   FREE DOWNLOAD     BUY UNLOCK VERSION($)  BUY UNLOCK VERSION(Rs)

  • Calculate Voltage of Cable having Different Size
  • Calculate Starting Current
  • Calculate Running Current
  • Calculate Starting Voltage Drop
  • Calculate Running Voltage Drop

202 Responses to Electrical.Tool

  1. KUMAR S says:

    Dear Jignesh,
    your technical datas very useful for me.kindly send your further updates.
    Regards
    Kumar

    • just subscribe This Blog and you will get all new up dation of this Blog through mail.

      • Excellent blog. Very nice detail.
        We have started AASHA CANCER FOUNDATION, Vadodara ” Fight Against Cancer”- To extend help to the Cancer patients and their family.

        Pl. visit aashacancerfoundation.spot.blog

        Thank you,

      • atul kusvaha says:

        please tell me how to work thayrester

      • srikanth says:

        Hi Sir, i want learn how to make load load schedule ,can you help me out

      • syed aziz ur rahman (karachi) says:

        dear sir,
        i want to talk to you is it possible.
        thanks and best regards,
        S. Aziz

      • raja sen says:

        Dear Jignesh i keen to procure few of your calculators, plz confirm the procedure to get it by on line payment.

      • raja sen says:

        Dear Jignesh i have downloaded most of your excel tolls except short circuit current calculation (base kva method) because download option is disable on your web site, Also i want to know whether payable tools are different or advance then free downloaded tools if yes requested to explain.I eagerly need your excel tool for short circuit current calculation.

      • ANTHONY says:

        hello your doing a good job.
        may you help me, i a have difficulties in downloading (free down load).
        my computer does not open the excel sheet with required content instead it brings out sort of complex code and i am unable to interpret them.

      • hara says:

        Thank you for providing such a good information

    • M.Vasudevan says:

      Please tell me How to subscibe your blog..

    • Dear Jignesh,

      I am a retired Electrical Engineer.
      I regularly see your work.
      You are doing a great work for humanity.

  2. ahmad says:

    Mr. Engr. Jignesh, i like Ur website very much bec this is the best platform i had ever see for the upcoming and present professional. I would like to ask u about the mcc (motor control circuit) and pcc (power control circuit). if u have any excel tool or some information about it then plz. e-mail me. or if u want some fee i am ready to pay for ur excel sheet tool.
    waiting for ur reply.

    • Rakesh says:

      Dear sir

      Thank u for such excellent technical notes
      i want to know that what is the maximum length for laying of 6.6 KV HT cable without using of HT isolator .

      pls reply

  3. asho kumar says:

    Please let me know the electrical tools costs.
    mail address

  4. muhammad musthaq says:

    Thank you for providing such a good information

  5. shaik says:

    dear sir
    i am shaik working as Electrical engineer.the data you have provided through excel sheets are very much useful to me.Now i fell proud to be working as engineer.my humble request for is that when iam facing interviews i could not answer the formula for calculations by this iam missing good opportunities so if pls send me some design formula used in construction design it will be very help full for me sir.

  6. krishna parekh says:

    Good work

  7. Ashish Choudhary says:

    I have only one word to say.” Thank You Soooo Much”.

  8. Dhilip says:

    Dear Sir,

    This is the best web site i have never seen till date.

  9. Saahib Ghouse says:

    Dear Jignesh,
    Namaskaar,
    Your website is not only informative, its one of the best service to whole nation.
    Thanks for your work.
    Please show a way or sample example/document to perform hand calculations for relay coordination studies and setting decisions.
    It will be very much useful.
    Thanks again.

  10. decky says:

    you are a electrical professor electrical, iam so very thank you so much with your electrical formula can to help me calculate my project to fast,,. Mr. jignesh parmar,,are you have excel calculation for relay protective for power plant,,if you want please inform me in email: deckystill@yahoo.co.id cause i like manual calculation than we use thr electrical program like ETAP, ecodial etc, thanks for share your knowledge in electrical

  11. paulson says:

    do you have any calculation available for MCC/PCC design as per Indian standards.

  12. Raz says:

    Hello,
    The site is interesting and very helpful.
    The software is very easy to use and efficient.
    Not everything I understand, but over time …..
    At the Software to calculate voltage drop, cable types are:
    2c * 50
    3c * 240
    3.5 * 300
    4c * 300
    What does it mean? I do not know it like that.

    Thank you,
    Raz

  13. nalini says:

    i like dis website alot….thanx alot…

  14. M.PRATHAP says:

    I DONT HAVE VISA/MATERACRD DEBIT CARD. i HAVE ONLY MASTRO DEBITCARD . HOW TO OPEN PAYPAL ACCOUNT.

  15. ramesh says:

    really i m very proud of you brother,it’s very useful for all category of electrical personnel.

  16. sandio says:

    thanks jignesh

  17. Gnana Reuben says:

    Dear Jigneshji

    How do we calculate the size of Earthing Cables. One of my Customer requires such cable to be designed for a Panel of rating 120KA

    Can you help me on this.

    Thanks & Regards

    Reuben

    • PANEL
      (1) Lighting & Control Panel =25X6 mm GI Strip.
      (2) Control & Relay Panel =25X6 mm GI Strip
      (3) D.G & Exciter Panel= 50X6 mm GI Strip.
      (4) D.G & T/C Panel= 50X6 mm GI Strip.

      (1) HT Switchgear,Structure,Cable Tray,Fence= 50X6 mm GI Strip.

      MOTOR:
      (1) 55KW =50X6 mm GI Strip.

  18. Kumar S says:

    Dear Jignesh,

    How we calculate consumption of diesel per unit?
    i am asking Generator consumption.

  19. Anbu says:

    Hi,

    Can you please explain me, difference between the line shunt reactor & Bus reactor.. also why the neutral grounding reactor shall be used in line reactor only..

    regards,
    Anbu

  20. kuldip singh says:

    how to size ht breaker & cable with illustrated examples for 11kv,33kv,66kv,132 kv ,220kv,etc

  21. suresh says:

    Hi Jignesh, I want to pay for ur unlock tools. May I have ur mobile no pls

  22. sunil says:

    sir
    i want to become an estimation engineer,where the courses available,please advise me

  23. Chirag says:

    Thanks Mr. Jignesh,
    Can You give me 22 KV HT Cable Sizing calculation based on 1000 MVA Fault Level

  24. Salek Raihan says:

    Hi Jignesh, It’s an excellent job and help professionals a lot. Hopefully you will keep update your site. Thanks once again.

  25. shiv shankar kumar says:

    Dear jignesh..
    this is really very helpful data.

    shiv shankar kumar
    mumbai

  26. gajen says:

    Dear Jignesh,

    I need Power Transformer Erection Procedures.

    gajen.M

  27. manan bhatt says:

    superb site…thanks a lot….

  28. aniruddha says:

    its a very effective site to grab electrical knowledge

  29. vinay says:

    its is very helpful site for electrical engineers & other to related person.
    can you send to me all electric distribution panel designing formula.
    thank you very much.

    Vinay kumar

  30. Abdul says:

    The best …BEST electrical site I have found till now. v.much useful. keep it up🙂 I am searching for some software which I can use it for cable/wire length estimation by just inserting my auto CAD drawing in it with in minutes or seconds. It consumes by time in estimation of all wires, since my project (i.e. building construction) is very big. I want to save my time.
    Waiting for your quick & positive response.

  31. adnan says:

    pls ineed street leghting design my EMAIL ()

  32. hari says:

    dear sir,
    a want to know about ups calculation and how select a good ups plz guide me

  33. Ezatullah wahdat says:

    Thank you Engineer jignesh farmar i am your new user when i see your lectures.i liked it

  34. jithin says:

    awsm collection,,,,,,,, thnku so much

  35. GREAT JOB DEAR JIGNESH………NICE SITE

  36. Sunil Kumar says:

    Jignesh SIr ek din aisa aeyga jab apko 100 crore people like kregi… kyonki ap ap m wo baat h….

  37. ARUN says:

    i am poor knowledge in electrical….now ….i have usefull notes at this site thankyouvery much brother….god bless you….

  38. Nikhil Suthar says:

    Dear Sir,

    Thank you very much for providing such useful personnel and professional information.Any person can become elect engineer by using your resources.

    Thanks,

    Nikhil Suthar

    Email : n.r.suthar@gmail.com

  39. kailas says:

    very useful data

  40. sanjay Patidar says:

    Dear Sir,

    Please accept my heartiest thanks for your extra ordinary effort put on this blog. This is my first Visit to your site but its a blog of ample knowledge regarding, electrical Engineering.
    Keep it up.
    With reagrds
    Sanjay Patidar

  41. vino says:

    hi, sir pls explain abt the numerical relays and working(directional relay and distence relay)

  42. Surely,I am one of the electrical personels that will benefit from your wealth of knowledge.thank you for your good work.Sulaiman.

  43. ketan chaudhari says:

    I really liked it and it is useful for persons like me. thank you..

  44. hemanth KN says:

    it is more intersting but i need basic book can u arrenge it ?

  45. Hello Sir,
    I must say very useful n informative articles and tools for the ones working in this field.
    I am working in a Power Domain Consultancy, We are developing the Software (Energy Network Management System) for various studies focusing Distribution Utilities under the Guidelines of R-APDRP. For this I need to prepare the Libraries for various Equipments in the Network. Recently I am facing Problem in Cable Library. I have used your Excel for the same which help me upto an extent. But the way we have modeled the Cables n Conductors, I require the Following Physical/ Technical parameters of the cables n conductor. Can u suggest me some reference/ source for the same.
    Thanks

    Various Parameters are;

    Phase Conductor Diameter,
    Nominal Diameter over the Concentric Neutrals of Cable,
    Diameter of a Concentric Neutrals Strand,
    GMR of Phase Conductor,
    GMR of Neutrals Strand,
    Resistance of Phase Conductor,
    Resistance of Neutrals Strand,
    No of Concentric Neutrals Strand, etc.

  46. suresh kumar.P says:

    really super ur datas……

  47. Sandeep says:

    dear sir,
    any Lightning arrester calculation for building please update

  48. minh tan says:

    thanks very much

  49. Ramesh.S says:

    Thankyou very much in providing a ready reckoner in the design process.

  50. CCM says:

    Dear Sir,
    Thank you for sharing this superb electrical engineering tool. It is very helpful for us as a young practitioner. Keep sharing and GOD BLESS. Your expertise is highly recommended. SALUTE!!!

  51. sandip patil says:

    very very thank you jignesh sir

  52. Balaji.R says:

    Dear sir,
    kindly says how to provide seeting for protection relays?
    what is the basic calculation for that?
    pls reply me

  53. Balaji R says:

    thank u very much sir.and also please refer me the good electrical books.

  54. Hitesh Dave says:

    Great Work Dear … !!!!
    Keep it up.. !!!!!
    I am Proud to be your Colleague…!!!!!!

  55. muthu says:

    do u have any document for fan calculation for capacitor bank

  56. Srinivasan says:

    This site is very useful

  57. Dear Jignesh, do u have any tutorial/guideline regarding BoM/Cost estimation of MCC/LT/PCC Control Panels for range of 100A-400A? regards,

  58. prakash parmar says:

    Dear jignesh sir your blogs are very useful to us.

    thank you very much.

  59. g.eswaran says:

    very useful link

  60. Dev Tiwari says:

    Dear Sir,
    i very thankfull to you for the ur web,..,,.,.i have got lots of answer for my query,.,.,,.,.

  61. melkamu says:

    Dear jignesh sir your sit is very useful thank you for it
    and can you tell me the software to calculate the location of a substation by calculating its load center.
    thank you very much.

  62. ASR REDDY says:

    Dear Jignesh great job very useful to Construction works.

  63. Issac says:

    Hi Jignesh

    Thanks for sharing. Good job!

  64. noor says:

    Words are not enough to express great thanks to you

  65. chinna says:

    very nice sir, it is very useful to me

  66. orgil says:

    Hi, Dear Jignesh . I liked it. Thank you very much.

    Хүндэтгэсэн
    Orgil

  67. Sudarshan says:

    Information are very useful

  68. sokol says:

    Thank you very much

  69. Sreekanth says:

    Dear Jignesh, I am curious to know the about the LV CB selection requirements for bus tie-in applications between Motor Control Centers, particularly the following scenario.

    Two Dyn11 Transformers 2500 kVA, 11/0.415 kV feeding two different MCCs need to be fitted with a bus tie-in between them. I’ve came across a scheme where there are 4pole ACBs as LV incomers to those boards whilst only 3pole ACBs (no breaking for the neutral) as bus tie-in CBs.There is a trip logic controlling these CBs, as the permanent paralleling will be blocked by this logic and one out of the two Incomer CBs will be tripped in case of a permanent paralleling situation. However, whilst closing the bus-tie, Transfomer Neutrals will make a closed loop since there are no breaking of the neutrals on the CBs. Anybody could tell me is there any international standards for selecting CBs for such applications? Is this scheme technically good? Is there any danger in connecting the neutrals together? please consider that the subject distribution network is prone to have harmonic distortion. Please advise…thanks in advance

  70. daniel says:

    Dear Sir,

    How to calculate ground fault current of the equipment,transformer and generator in order to sizing the earth cable for them?

  71. Dear Jignesh,

    You have done a great job and which is very useful for day to day Electrical transactions. We give great appreciation to you.

    Thank you so much and wish u all the very Best.

    D Venkatapathi Raju.
    Asst Engineer (Electrical),
    M/s NCC Limited.

  72. Narendra says:

    Dear jignesh,
    You are god of electrical engineer from india………………..
    Thanks
    Narendra wagh
    Inspector electrical (MNC -consultant)

  73. Mukul Tyagi says:

    Dear Sir ,
    I have a question ,suppose we are going to design a LT Panel Main switch board and acdb 3 phase for a control room of substation , so there will be lighting loads , ac , fan , and the Ac supply to the motors in isolator , and the OLTC of the transformer ..etc similarly there will be many other loads too , I am not able to find study material that guide me through the calculations needed to design the panel , which includes load estimation first , then the various mcb and mccbs to be used and also the bus bar size .
    Please help me with this
    any help will be much appreciated .

    Mukul

  74. umer says:

    Hello .. Can you provide the voltage drop calculator for Road Lighting Voltage Drop… i havent find a single voltage drop calculator for specifically street lighting on the web.

  75. Rajini says:

    Hi Sir,

    Your calculation sheets are very much useful,but i guess it would me more useful for freshers,if u give a demo video on how to use etc.

    Regards,
    Rajini.

  76. Gajendiran M says:

    Dear SIr,

    your application & article are very useful to us,

    I need Earth mat Design criteria, standards & Calculation sheet.

    Thanks / Regards,

    Gajendiran M

  77. boy sandra says:

    dear sir

    i m a newbie n i found your blog is very interesting and usefull. thanx for your generousity sharing various information

  78. bheem reddy bhanu teja reddy says:

    dear sir its very helpful and i am getting a little bit hand on ur notes i am trying in practical by following ur notes sir

  79. hello sir greeting of day, can u tell me what is selection criteria of secondary current of ct whether 1 amp or 5 amp

  80. ramesh says:

    I am ramesh from your previous organisation. Your blog is readly good

  81. Dorababu says:

    Sir Please update calculate the run capacitor and starting capacitor formulas of motor

  82. krahim says:

    Hi
    My q is it possible to use ordinary electric tools in hazard classified area

  83. narayana says:

    sir,
    plz tell me the caliculation for caliculating the spacings between each pahse to phase bus bars in LT and HT panels.

  84. Ravikumar says:

    Dear Mr.Jignesh,
    Thanks a lot..Iam reading ur blogs its really very interesting and useful for us.pls continue ur service..
    I want to do a cable sizing for the DC supply of a SwGr considering all factors like CB closing ckt,tripping ckt,trip relays etc pls advice

  85. hasan says:

    its very useful data thanks

  86. sreenu says:

    dear sir please give the exact formulaes for power frequency tests of transformer why
    33kv classes – 70kv/1min,22kv class – 50kv/1min and 11kv class – 28kv/1min.
    give me where i will get information with formula and if u have plz provide to me.

  87. Manikandan says:

    Sir
    I need the details about the EMF radiation in a HT Transmission line.what should be the clearance from the Bottom conductor to the Ground.

  88. Ashok Bhat says:

    Can u please provide excel tool for Maximum Demand calulation for a new project set up
    This will help is making proper decision on State electricity board contract demnad selection.

    Pl reply
    Ashok

  89. bhavesh says:

    Sir, let me know which protections are used for the dg set?

  90. hari says:

    usefull information

  91. jomon says:

    sir,the tools is not responding to calculation

  92. manoj kumar says:

    thanks sir ji.

  93. sumit says:

    Mr. Jignesh please contact me as early as possible wants your article to publish in SPE-society of power engineers newsletter for publish in bimonthly newsletter.

  94. Deva says:

    great thanks about your all notes and Excel tools

  95. Oswaldo says:

    Great blog keeping doing your job thank you so much

  96. kullay121 says:

    very good .. But where is subscription

  97. sandeep says:

    when to use TPNn y is it neccasary..IM FED UP WITH THIS tripple pole network…sir please

  98. rana says:

    thanks dear
    that all are very use full
    please guide me about motor design and rewind formulas
    i am very thank full to you for that

  99. Syed Arif Mahdi. says:

    Many thanks this is the most comprehensive electrical engineering technical notes I have seen so far keep up the good work. Arif Mahdi.

  100. smruti says:

    such a grte site sir, rely very help full datas are available here ,

    smruti

  101. Vijai says:

    Parmar G,

    Its very useful electrical engineers

    Thanks
    vijai

  102. ASHOK KUMAR says:

    I DONT HAVE VISA/MATERACRD DEBIT CARD. i HAVE ONLSBI ATM CUM DEBITCARD . PL. GUIDE HOW TO PURCHASE .

  103. Ashish says:

    Hi Jignesh, one MCCB tripping on motor start in bypass mode (i.e.DOL)only and absolutely no problem with soft starter mode . wondering what may be reason? I reckon it may be high inrush current of vacuum pump high efficiency VSD motor.

    The MCCB is ,Terasaki S250-GJ Can you please look in to it advise me reason & suggest alternate MCCB which would respond fine.

  104. anwesh kumar says:

    Mr.Jignesh i think iam late in seeing your blog, it is full informative superb.

  105. mohsen says:

    hi, please stay help file or tutorial video clip for these excel files.
    thanks.

  106. Prasanthi says:

    Than u sir such a excellent Electrical information is uploaded for us.thank u so much once again.

  107. LOKESH says:

    Dear sir ,
    your site have very useful information, thank you

  108. amjad shakikh says:

    Please help me to calculate the thumb rule for tendering with respect to area of residential, commercial & Industrial areas,

    thank you…….

  109. ASHOK says:

    I DON’T HAVE VISA/MATERACRD DEBIT CARD.I HAVE ONLY SBI ATM CUM DEBIT CARD . PL. GUIDE HOW TO PURCHASE .Earlier I had a communication with U, Pl. REPLY

  110. Jose I. Torres says:

    Jignesh,
    what is the difference between the documents of free downloading and the docs we have to pay USD 3.00/
    Thanks
    Jose Torres

    • Free Downloading means You can use the program at free of cost but you can not modify or delete it’s designer Name while by buying it You can modify the program or may delete it’s Designer name.

      • satyam says:

        sir,i want to buy the software for relay coordination & for relay related softwares. can you suggest me how to buy.do reply soon sir.

  111. quang thuc says:

    thanks you

  112. binny says:

    THANK U SO MUCH SIR

  113. jayanta says:

    Dear sir,
    plz provide me NGR related doc.
    My self jayanta working In Gen set company.

  114. eswar varma says:

    really amazing sir.

    khudafiz good day for me.

  115. Biramananthan says:

    Dear sir,
    i didnot get any download sheets… pls tell me hw to download this calculation sheets… if i click free download, i see a new page and there given 2 options… i clicked first option and download process also going on… bt i didnot get download file… pls tell me sir

  116. vigneswar says:

    Dear Sir

    Many thanks for your valuable blog for many people

    I am unable to download the spreadsheets

    Kind Regards
    Vigneswar

  117. gopal says:

    Dear Jignesh Bhai,
    How can we calculate generator fault current at parrallel operation?

    I am in trouble, I havent got proper answer, kindly suggest the same.

    Thank you.

  118. Junaid says:

    Dear Jignesh

    Can you tell me dry type transformer control temperature both alarm and tripping setting .

    Regards

  119. Ajay Singh says:

    Thanks for sooooooooooooo good support for electrical.

  120. Gopal says:

    Dear Jignesh Bhai,

    I am planning For Electrical space planning. So i have little bit confusion in distances mentioned below.
    1. What is distance between two tranformer(dry and oil) wall space etc.
    2 same as D,G
    3.Panel, UPS, APFCR

    Kindly suggest the same.

    Regards,
    Gopal.

  121. Davinder says:

    u have done a great job and u r idol for many electrical engineers

  122. Sir:

    You are the great guider, thanks a lot for your technical support.

    Best Regards,
    Suthagar Santhanam

  123. Nilesh says:

    Hello,
    Thanks for this wonderful article @ the Sizing the cables !

    I am confused about the formulas used for DOL starter motors and Star-Delta starter motors i.e., it is @ length.
    can we use same formulas DOL starter and Star-Delta starter?
    as an example: there is a 30 kW,415 V, 3-ph, 50 Hz motor at a distance of 150 mtr from MCC panel; I want to know the what length used for DOL starter and Star-Delta starter for the calculation of the Voltage Drop – starting+running.

    If possible please provide separate formula and help.

    Regards,
    NILESH

  124. dheena dhayalan says:

    Dear Team,

    its indeed surprise to note that,all the detailed calculation is in one site is really surprising!

    since i am from the background of the buduct, can i get the same kind of calculation for the busbarwill be good enough to suggest our client…

    awaiting your valuable reply.

    Regards,
    Dheena.V
    08939923363

  125. Kailash Salve says:

    It’s really very useful for electrical engineer..
    Very good work…
    Keep it up…..
    Thank you so much

  126. rajkumarjothi says:

    Dear Mr. jignesh
    i am from Wind mill background and working in 200 MVA SS. i need to know why Transformer KVARH Import is very high compared to WTG.

    While Low generation for example 1650 kW WTG generates 700 KW the WTG KVARH is high compared to Power transformer. but when WTG generates 1650 KW at full load. the Transformer KVARH is more than WTG.

    Can you Please explain How it is possible.

  127. AYAZ AHMAD says:

    HI dear Jignesh Parmar,
    I am an electrical engineer from Pakistan and i really found for what i was searching from a long time. Dear Jignesh Parmar, Your knowledge and sharing it is of high praise.
    Thank You very much.

  128. AYAZ AHMAD says:

    Dear Jignesh Parmar,
    Please tell me whether NEC equivalence to IEC is acceptable or not?. Actually i work in a switchgear company as electrical switchgear design engineer and here only IEC standards are accepted.
    Please tell me about this.

  129. satyam says:

    dear sir, i want to know how relay coordination is done & setting for upstream relay according to lower ones.please upload application for relay coordination.thanks for ur such helpful posts .

  130. rajeev singh says:

    Very………………very
    thanks sir provide a use full information

  131. Qaizar says:

    Thanks for so much information in one site.

  132. rajendra says:

    Dear sir
    How to Selection CT and, how to calculate CT rang

  133. roofi881 says:

    Dear Jignesh Parmar.

    first of all i am very thankful to you for sharing such a technical knowledge with us its really appreciate-able.

    I am also an Electrical Design engineer but I am new in this field. now a days I am looking for sizing of Diesel gen-set, sizing Circuit Breaker and sizing the conductor for HVAC and refrigeration systems. I have read the articles of NEC but I am unable to understand that.

    i want you to help me in that by providing some solved examples and some reading material and also I want you to answer some of my questions/confusions which I have. I`ll be very thankful you.

    and please tell me also that for 288000 BTU/hr or lump sum 25 tons we need how much rating of Diesel generator to fulfill our need?

  134. Anjum says:

    Mr. Jignesh Parmar ,

    wow nice and helpful information and a job well done. May i have cable size chart

  135. Sanjay Khude says:

    Dear sir,
    There are no words to thank you.

    Really Excellent.

    Khude Sanjay

  136. SAI RAM says:

    your pay roll package in excell format very easy for working thanking you sir,

  137. Abhijit Mandal says:

    Hello Sir,

    Could you please publish a complete substation sizing calculation with a typical example e.g 33/6.6 kV, 16 MVA.

  138. yogesh says:

    Hello sir

    can u guide for selection of H.T.Cable from two pole structure to transformer

    Yogesh

  139. FAKHAR-UL-ZAMAN KHAN says:

    HOW I FIND THE IMBALANCE % OF 3 PHASE VOLTAGE AND CURRENT

  140. Malik Imtiaz Ahmad says:

    I can only say ” EXCELLENT”.

    Wonderful work.

  141. Harish Doshi says:

    i had purchase 3 hp 1 phase Monoblock Pumpset from Kilsokar and the distance between Meter and Pump is around 900 feet now the problem is that we are unable to run the pump due to voltage/current drop down pl. suggest the solution for the same

    Harish Doshi

  142. Abhijit Mandal says:

    This voltage drop is due to resistance & reactance of the cable used. To mitigate this voltage drop it is recommended to use higher size cable.
    To find the desired cable size pump motor name plate details required i.e rated current & rated voltage.

    Abhijit

  143. Nsorbilla john says:

    Thanks very much for your good work

  144. Rajesh Tayade says:

    Dear Sir,
    Very useful information .Thanks,
    Rajesh Tayade

  145. bhanu prakash says:

    Thank you very much sir,
    I love to be an electrical engineer, your work keeps me in heights .
    thank you very much sir.
    i want to be part of your team sir.

  146. Pramila Deshmukh says:

    Hallo Sir, In Busbar current capacity is considered is in single busbar ?
    or it is distributed in 3 ?

  147. Mahdi says:

    Tks For all this

  148. Nice job. We are a fan of Excel too. Just re-pressed (shared your post) this on our own wordpress blog at https://industrialtraining.wordpress.com/2015/07/05/electrical-tools/ Hope you are ok with that.

  149. Baskaran.P says:

    I have seen all electrical equipment selection & Fault calculation, Really very useful

  150. Amar says:

    sir .
    am working as a electrical engineer in power plant .how to calculate all parameters of relay setting of generator

  151. Anoush says:

    Hi
    Free download for item ” (12) Calculate Size of Battery Bank and Inverter ” is not available !!!
    Could you please active that. then I can see what it looks like , then decide to buy.
    Thanks

  152. Pingback: Calculate Size of Cable Tray (Excel Sheet) | Electrical Notes & Articles

  153. Harikrishnan says:

    its very useful to cross verify my calculation

  154. joseph wilberforce ansah says:

    The content has a very useful information and would help any serious engineer way to solve quick without struggle.

  155. Pandi says:

    comparative analysis of digital energy meter and analog energy meter

  156. shah says:

    90 is dollar or pound or what

  157. Mr. Jignesh,

    Will you please suggest a suitable bonding system for 29 Kms 11KV, AB Cable for the laying from a Generating station to sub station.

  158. Sirji,
    Please tell me steps included in lightning arrester design (including reference charts and mathematical calculations).

  159. John nsorbilla says:

    I am highly impress with the work done and wish to get copies of that. Thanks

  160. M.khalid says:

    Hi
    Mr.Jignesh,
    I am interested in few calculations software and I want to buy that would you like to give me some information for the full version that what can i get in full version mean formulas details what will be in full version,
    your early reply will be appreciated.

  161. fazal says:

    how to download free download i am clicking on it but download doesnot start ,why?plz

  162. Happy Harry says:

    Dear Mr. Jignesh Parmar,
    Very nice your Excel programming,
    In my opinion there is a small mistake in your programming.(C.B Tripping Setting & Motor Data(22.8.12).xls) Tab motor data.
    Also in the new version the error is still there.

    I try to explain: (C.B Tripping Setting & Motor Data(22.8.12).xls)
    Your calculation in cell AJ12 will generate a mistake if you choose for the locked rotor code (Cel D14) the letter V.
    In your calculation the result is 12 in stead of minimum 24.
    The values of the range locked rotor code A till V is increasing and at the last selection (V) decreasing.
    I have changed the mistake and made some cosmetic changes.
    Where can I send the excel file?
    Regards,
    Happy Harry

  163. Mufutau Ibrahim Engn. Techn says:

    Well done Engr. how much and how can i make payment.

  164. nitin says:

    Hi jignesh

    I am unable to purchase some of the tools, because it needs credit card and I have debit card only.. please help.

  165. nitin says:

    Hi jignesh
    Thank you for the support in sharing knowledge..If you can or have any tools/information for the following it will be helpful..
    1) Calculation tool or notes for motor contribution during short circuit.
    2) Calculation tools or notes for transformer differential (high impedance /percentage bias) (87T)
    3)Calculation tools or notes for transformer restricted earth fault (high impedance /percentage bias) (64R) with stabilising resistor calculation.
    4) capacitance & tan delta (dissipation factor) calculation tool
    5) setting of directional overcurrent & earth fault relays
    6) setting of line differential protection (high impedance /percentage bias) with stabilising resistor calculation.
    7) setting of busbar differential protection (high impedance /percentage bias) with stabilising resistor calculation.
    8) neutral displacement relay resistor calculation
    9) Calculation tool or notes for generator protections such as
    i) 100% stator earth fault.
    ii) 95% stator earth fault.
    iii) underimpedance (21G)
    iv) poles slipping/ out of step protection
    v) negative phase sequence
    vi) generator overload protection
    vii) rotor earth faults
    viii) generator differential protections (high impedance /percentage bias) (87G) with stabilising resistor calculation.
    ix) generator transformer (GT) differential protections (high impedance /percentage bias) (87GT) with stabilising resistor calculation.
    x) generator restricted earth fault protections (high impedance /percentage bias) (64R)with stabilising resistor calculation.
    xi) voltage restraint overcurrent protection..
    xii) details on powerswing phenomenon.
    xiii) overfluxing protection..

    If you have any information regarding ANY of these things please feel free to share or contact

    please feel free to contact me over my email…

    Thank you very much.

  166. vijay sharma says:

    Dear Sir,
    Very useful information .Thanks,
    Vijay Sharma

  167. vijay sharma says:

    Dear Sir ,
    please send me notes how to calculate HT cable current .

  168. Manu says:

    Dear Sir,
    Do you have a “Arc flash calculator” as per IEC TR 61641 / Equi: in excel format?

  169. Aditya says:

    Hello Sir, which is the best way to transmit 3MW power to a 66KVA substation. Transmission line length is 11km. I want too know about wire size, losses, number/set of transmission line etc.

  170. Shabir uz aman says:

    Respected Sir,
    Plz help me about some points. I am working on micro hydro power plant, which is from 15KW to 500 KW in Pakistan,
    I have some issues If you solve these for me I will be great thankful to you.
    1. How Can I survey for transmission Lines/Distribution lines in the hilly areas as well as in the plane area?
    2. In which rout will be suitable for it?
    3. Which poles be used here I mean LT/HT poles?
    4. In how many distances a transformer can be used and in which Generator can be used a transformer I mean above 75 KW or may be below.?
    5. and How the transformer rate calculated for it? KVA?

    I will wait for your good response.
    Thanking You Sir
    Shabir Uz Zaman

  171. raja sen says:

    Hi Jignesh

    i have buy you fault level calculation Xl tool and calculated fault level of our existing set up plz see attachment but i have few query related which has already mentioned on each sheet but summery of the queries are following below.

    I have 3 transformers each of following below specification.
    1600 kVA, 33 kV, Z% 6.24%
    900 kVA , 33 kV, Z% 5.08%
    900 kVA, 33 kV, Z% 5.08%

    Queries:

    1. Is selected value of base kVA & bae kV is correct in each cases.
    2. I have consider cable max.DC resistance at 20 degree celcious is correct or i have to take max AC resistance at 90 degree celcious.
    3. I have assumed Fault level at HT incoming supply as 750 MVA is correct.
    4. In old 900 kVA calculation i have to right value of cable from DO fuse to transformer 2 times in HT side otherwise your calculator is not accepting the data.Similarly i have to put data of cables from secondary side of transformer to DM PCC.
    5.In new 900 kVA calculation sheet we have bus duct in secondary side of the transformer then how and what value of resistance and reactance to put.
    6. From DM PCC to MCC-10 we have laid two different size of cables i.e 3C x 300 sq mm & 3 1/2 C x 185 sq mm cable then how to put the value of resistance and reactance in respected column or the way i mentioned in two places is correct.
    7. This calculator is useful if only one transformer but if we have two transformer in parallel or one transformer and one DG set in parallel then how to calculate.
    8 Is it possible to send me the all the formula used in your calculator.

    hope you will understand our concern and revert back as soon as possible.

    waiting for your reply.

  172. V.Sasikanth says:

    I Can’t Able To Buy Your Notes Through Online So,Please make Case On delivery Option or Flipkart Publish.

  173. hani says:

    Nice Nice Nice

  174. deepak says:

    dear jignesh,
    your concept are really good. I am having one query. Many time in tender we come across term called solid earthing.Pl let me know how it is different from normal earthing?

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: