# Electrical.Tools

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

*Jignesh.Parmar*

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

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

**(1) Cable size and Voltage Drop Calculation**

** ****FR****EE 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 Inverter-UPS with Battery Bank .**

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

### **(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($)**** ****B****UY 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:**

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

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

**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) Calculate Size of 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**

- 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

**(47) Calculate Cable / Wire Trunking size**

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

- Calculate Size of Trunking for Different size of Cables.

- Calculate Size of Trunking for Different size of Wires.

**(48) Calculate Exhaust Fan Size**

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

- Calculate Size of Ventilation Fan

**(49) Calculate Pole Foundation Size**

- Calculate Size of Foundation for Pole

**(50) Calculate ventilation for Transformer & DG Room**

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

- Calculate Heat Loss of Electrical Equipment in Electrical / DG Room.
- Calculate Air Quantity Required for Ventilation.
- Calculate No’s of Ventilation Fan.
- Calculate Rating of Ventilation Fan.

**(51) Calculate Ceiling Fan Size**

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

- Calculate Ceiling Fan Size
- Calculate Number of Fan.
- Calculate Height of Fan above Floor .
- Calculate Total Air Deliver.

**(52) Calculate Lighting Fixture Beam Angle**

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

- Calculate Lighting Fixture Beam Angle
- Calculate Illumination at Surface from Beam Angle.
- Calculate Lighting Fixture Lumen from Beam Angle.
- Calculate Illuminated Diameter from Beam Angle.

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,

please tell me how to work thayrester

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

dear sir,

i want to talk to you is it possible.

thanks and best regards,

S. Aziz

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

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.

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.

Thank you for providing such a good information

SIR CAN U PLEASE TELL ME THE DIFFERNCE BETWEEN FREE VERSION AND PAID VERSION OF EXCEL CALCULATION SHEETS

Please tell me How to subscibe your blog..

just click on

“Follow Blog via Email”

Dear Jignesh,

I am a retired Electrical Engineer.

I regularly see your work.

You are doing a great work for humanity.

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.

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

Please let me know the electrical tools costs.

mail address

It is

FREE of cost for downloading or usesbut It you want to make any changes or need unlock version of Sheet than You have to but it at nominal cost indicate on Site.Thank you for providing such a good information

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.

Good work

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

Dear Sir,

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

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.

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

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

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

C is core

i like dis website alot….thanx alot…

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

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

thanks jignesh

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.

Dear Jignesh,

How we calculate consumption of diesel per unit?

i am asking Generator consumption.

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

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

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

Just Press “Buy Unlock” version and You can Purchase it ONLINE..

Thanks for ur reply, sorry that Paypal is not opening it’s giving message error detected. what to do???

sir

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

Thanks Mr. Jignesh,

Can You give me 22 KV HT Cable Sizing calculation based on 1000 MVA Fault Level

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

Dear jignesh..

this is really very helpful data.

shiv shankar kumar

mumbai

Dear Jignesh,

I need Power Transformer Erection Procedures.

gajen.M

superb site…thanks a lot….

its a very effective site to grab electrical knowledge

eisehi knowledge share karte raho

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

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.

pls ineed street leghting design my EMAIL ()

dear sir,

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

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

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

GREAT JOB DEAR JIGNESH………NICE SITE

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

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

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

very useful data

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

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

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

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

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

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.

really super ur datas……

dear sir,

any Lightning arrester calculation for building please update

thanks very much

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

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

very very thank you jignesh sir

Dear sir,

kindly says how to provide seeting for protection relays?

what is the basic calculation for that?

pls reply me

Refer following Post for IDMT O/C & E/F Relay Setting.

https://electricalnotes.wordpress.com/2012/10/13/calculation-of-idmt-over-current-earth-fault-relay-setting/

Excel sheet for Calculation of Setting for

(1) Transformer E/F& O/C Protection Relay setting,

(2) Relay Grading,

(3) Relay Curve

will be posted in next month

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

Great Work Dear … !!!!

Keep it up.. !!!!!

I am Proud to be your Colleague…!!!!!!

Thank you Sir

do u have any document for fan calculation for capacitor bank

This site is very useful

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

Dear jignesh sir your blogs are very useful to us.

thank you very much.

very useful link

Dear Sir,

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

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.

Dear Jignesh great job very useful to Construction works.

Hi Jignesh

Thanks for sharing. Good job!

Words are not enough to express great thanks to you

very nice sir, it is very useful to me

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

Хүндэтгэсэн

Orgil

Information are very useful

Thank you very much

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

Dear Sir,

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

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.

Dear jignesh,

You are god of electrical engineer from india………………..

Thanks

Narendra wagh

Inspector electrical (MNC -consultant)

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

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.

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.

Dear SIr,

your application & article are very useful to us,

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

Thanks / Regards,

Gajendiran M

dear sir

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

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

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

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

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

Hi

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

sir,

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

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

its very useful data thanks

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.

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.

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

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

usefull information

sir,the tools is not responding to calculation

thanks sir ji.

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.

great thanks about your all notes and Excel tools

Great blog keeping doing your job thank you so much

very good .. But where is subscription

Just Press “Follow Blog via Email”

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

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

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

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

smruti

Parmar G,

Its very useful electrical engineers

Thanks

vijai

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

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.

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

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

thanks.

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

Dear sir ,

your site have very useful information, thank you

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

thank you…….

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

I have already mailed you on 8/9/13. Lease check your mail.

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.

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.

thanks you

THANK U SO MUCH SIR

Dear sir,

plz provide me NGR related doc.

My self jayanta working In Gen set company.

really amazing sir.

khudafiz good day for me.

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

Dear Sir

Many thanks for your valuable blog for many people

I am unable to download the spreadsheets

Kind Regards

Vigneswar

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.

Float Posting Calculation sheet of S.C Level and size of D.G synchronous Panel Today..

Refer Today’s Post

Dear Jignesh

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

Regards

Thanks for sooooooooooooo good support for electrical.

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.

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

Sir:

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

Best Regards,

Suthagar Santhanam

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

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

Hi,

This is Jignesh,

BUsbar calculation sheet on excel is already ready and will be floated within one month..

It’s really very useful for electrical engineer..

Very good work…

Keep it up…..

Thank you so much

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.

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.

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.

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 .

Very………………very

thanks sir provide a use full information

Thanks for so much information in one site.

Dear sir

How to Selection CT and, how to calculate CT rang

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?

Mr. Jignesh Parmar ,

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

Dear sir,

There are no words to thank you.

Really Excellent.

Khude Sanjay

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

Hello Sir,

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

Hello sir

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

Yogesh

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

I can only say ” EXCELLENT”.

Wonderful work.

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

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

Thanks very much for your good work

Dear Sir,

Very useful information .Thanks,

Rajesh Tayade

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.

Hallo Sir, In Busbar current capacity is considered is in single busbar ?

or it is distributed in 3 ?

Tks For all this

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.

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

sir .

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

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

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

its very useful to cross verify my calculation

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

comparative analysis of digital energy meter and analog energy meter

90 is dollar or pound or what

What is meaning of $…Is it dollar sign or Pound !!!

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.

Sirji,

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

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

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.

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

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

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

Hi jignesh

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

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.

Dear Sir,

Very useful information .Thanks,

Vijay Sharma

Dear Sir ,

please send me notes how to calculate HT cable current .

Dear Sir,

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

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.

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

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.

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

Nice Nice Nice

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?

Download links broken 😦

Dear Sir, I’ve tried to download the cable tray calculator (excel sheet), but I’ve failed, please can you advice me how to down load it ?

Kind regards,

dear sir,

i am unable to download excel calculators as you provided. please tell me how to download..

Hi jignesh

Great fan of yours..!!! i always look forward to buy your apps… last time i bought your electrical notes book instamojo website..THANKS..!!! My humble request to you to develop an app or shed some light on desgin of MOTOR FOR DIFFRENT TYPES OF LOADS. COMPRESSOR ,conveyor & other industrial LOADS .!!! THANKS

thank you dear… I have been using 5years very useful… GOD BLESS YOU…

Dear Mr.Jignesh

In power factor correction , please let me know how the single phase sensing is effective compare to three phase sensing or which is the correct procedure to follow.

Thanks

Dear Sir,

I have a question that, In EHV Network if the star point of source transformer is operating with solid/ resistance/ impedance grounding then is it necessary that any of the other receiving end transformers also required star point grounding in case of that receiving end transformer’s primary is star connected winding (The winding which is connected in the network).

In our case we are at receiving end with Star, Star & Tertiary winding transformer, we are experiencing disturbance tripping of HV Side stand-by earth fault during any upstream side faults.

Hence, we hope to leave the HV Star Point un-grounded to avoid disturbance tripping.

Please suggest me in this regard.

Thank you very much in advance.

Thanks You for your electrical reference for my bright & excellent your contribution for excell soft ware.

(16) Size of Capacitor for Power Factor Improvement (1.1.17)

Capacitor Selection Chart is very good, Kindly add the Reactor Selection.

Hello Jignesh,

If I buy the Unlocked version of Excel Electrical tools, I believe it means I can modify them as I wish

Dear Sir,

Very useful information .Thanks,

M.Meçabih.

Dear Sir, I’m new parson in Electrical filed please explain Electrical load schedule.

Dear Mr. Jigneshji,

By using an APFC Panel, the PF is corrected resulting in saving the losses on the Transmission Network, since the Reactive power is compensated. Can you please elaborate by quoting any example with Calculations as to how the Consumer saves upon his Energy Bills ?

Dear Mr.Jignesh, I would like to buy the 48nos of unlock electrical software. how can i order? how i can receive the software once the payment completed? please explain

Dear Mr.Jignesh one more information required that after i purchased the 48nos of unlock electrical software. In case if any problems comes like if the software not working properly how can rectify?

Dear Mr.Jignesh, I would like to buy a Electrical excel tools software unlock version. Could you please tell me that after payment how i will receive the software from you? and after purchase if any problem comes in the software like not working properly how the problem will be rectified? Awaiting your feedback. Thanks

Dear Mr.Jignesh, Do you have power and distribution transformer design tools software? if you have I want to buy.

Please send me Electrical notes which help of for defind of electrical load with calculation of wire size and mcb

dear sir i mr k.deekshitulu is basically electrical engineer i am executing the projects executing work erection,testing and commissioning works at site i want to know the types of protections for ,transformer,generator,transmission line,bus bar systems and its relay setting calculations information plz help us to get required information

thanking you sir

deekshitulu

Hi Jignesh,

On your D-G set sizing spreadsheet, I did find 2 major anomalies.

1) For a motor rated current calculation on input , you have not accounted for the motor efficiency.

2) For a soft start calculation, there is an error in the formula on cells L11 & AO11. Use of word ‘Soft’ & ‘Soft.’ and so it is miscalculated. Kindly check & re-release. Thanks

-Raghavan

Siemens

error in downloading

The file you are trying to download is no longer available.

The account that created this link has been terminated due to multiple violations of our Terms of Service.

THANKS

thank you very much for all information….

please what do you mean with this symbol T/C in this article: Insulation Resistance (IR) Values

dear sir

yesterday, I purchased electrical tool software 4900inr. this is helping me , but I need a sot ware to draw a SLD in xl sheet . earlier I was seen for fiteen motors or so. could you send me the same for at least 50 feeders.

thanx

How can i select the body earthing cable size of a transformer?

Hi Sir,

I am really appreciate to you . I am intresting to buy your Electrical Notes and Excel tools after I had used the lock version. Because the Excel sheets are very good but some factor are not comply with our local code . so I need to make little changes . I can’t buy your unlock Excel Tool because it ” this Item is unabbalible for your country ” . I would like to know how can I buy your Excel Tool.

With respect,

KO KO AUNG

from Myanmar

Hi Sir,

I am unable to download or purchase the link of (42) Calculate Bus bar Size for Panel so please check and reply sir.

Regards,

Ramu.B.R

Dear Mr, JIgnesh, Thank you… I have been using your software. It’s really excellent.

Hi sir,

your website is very useful for electrical engineers.I want zigzag winding calculations could you please attach.

Dear Sir,

I want your mobile no and email.for further discussion

Dear Sir,

Please provide IGBT/SCR cold Test procedure & How to check Fonctional.

Dear sir

i hope you are doing well, iam very happy to joint with you thanks alot from your good information, Dear sir i need to ACSR cable calculation if you have time please send me in these (khoshhal.naizy@gmail.com).

Electric Engineer

AMIP/MAIL

Hii,thank you sir for providing a good Information and ur data’s are excellent.thanxs for nic details.

Dear Sir

how to do DC bus sizing, the system voltage is 208V

Dear Jignesh, I have seen your EXCEL Sheets for Calculations. On each sheet there is a Free Download and one Paid Download. What is the difference between the two ?

very nice info as well as excell tools.

nice post thanks for sharing this information, keep sharing

Dear sir……

First thanks lot….very useful…..I love toooo

Dear sir,

Very nice, Great job

Dear Sir,

I am not able to get free download of No.29, 30, 37 & 47 as the Total Quick Heal Security is blocking them. Please guide.

its very useful. thanks sir

equest you post the calculation of CT knee point voltage for a 10MVA 66/11KV transformer

Dear sir I am a working in a solar installation company as a design engineer and I uses your various electrical calculation sheets and now I need different sheet in solar I want to calculate per string voltage drop of DC cable which is from pv module to inverter distance

Dear Jignesh,

May i know if the paid version for item (42) “Calculate Bus bar Size for Panel”, will allow me to size up to 10 nos of busbar per phase? As of now, the free version only allows upto 3 nos of busbars per phase.

Dear Mr.Jignesh ji

can you please share the excel calculations of lightning protection based on IEC 62305..

Dear Sir,

I am a regular folower of your posts , I have the following doubt please clarify : We have installed 2 numbers of 25 MVA Transformers each with 18% impedance, each transformer is fed from same source of 110 kV with individual breakers. We have taken the secondary output of 11 kV of each transformer to 11 kV panel with 2 input breakers and 1 Buscoupler in between. we would like to know if we want to parallel these both transformers whether we need them to be synchronised. The polarities are same.

Regards

Prashant K

Jigneshbhai,

thank you for sharing such a valuable information. I need Type 2 coordination chart along with cable size selection chart

hello Boss

i’m ready to buy this, but could you tell us what is the reference from code?

thank you a lot

It’s very useful

Dear Jignesh Parmar,

I think you have to mention, what is the difference between free version and unlock version on site. Why I should spend money for unlock version?

Hi Jignesh,

Would like to know about the KA to be selected for the MCCB. Say for example 50kW X4 & 60KW X1 inverter is connected in an panel. for 50Kw 100A 40 Pole Mccb, & for 60Kw 125 A 4p Mccb is selected. But how to select the KA level for MCCB. Also how to select the KA value for the outgoing MCCB.

Dear Sir,

Kindly share how to calculate Knee point voltage

Dear Sir,

Kindly share how to calculate Knee point voltage

Hi,

I am asking before i buy, if the Excel base Programs (Electrical Engineering) sporting Australian standards if NOT can i use it by make changes and what the deferent between FREE DOWNLOAD and UNLOCK VERSION.

Regards,

hello sir,

good morning. i need 100mm width- 50mm depth cable tray sizing calculation. can you please tell us

I have Purchased Excel sheet (42) Calculate Bus bar Size for Panel

But in Calculation Sheet:”Bus bar Size Detail:’ and its explanation with pictorial representation is wrong and confusing…

Busbar width, thickness, length, number of runs, support is represented wrong way and bit confusing..

Could you please help me out or send me the correct one

plz tell me the difference between payable tools & free downloaded tools.

I am waiting for your valuable reply