Electrical Tools
Excel base Programs (Electrical Engineering):Designed by: Jignesh.Parmar
(1) Cable Designing Program
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Voltage drop of Cable.
- Calculate Size of Cable.
- Calculate Current Capacity of Cable.
(2) Conduit Size Selection Program
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.
(3) Selection of MCCB, ELCB For Main /Branch Circuit.
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate Size and Type of Main MCCB/RCCB/ELCB for Continuous and Non Continuous Load
- Calculate Sensitivity of MCCB/RCCB/ELCB.
- Calculate Size of Cable.
- Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
- Calculate Total Load .
- Calculate Main and Branch Circuit Current.
(4) Selection of Fuse
- Calculate Size of Fuse for Electrical Circuit.
(5) Size of Capacitor For Power Factor Improvements
FREE DOWNLOA BUY UNLOCK VERSION
- Calculate Size of Capacitor for Power Factor Improvements.
- Calculate Annual Saving by selection of Capacitor.
- Calculate Active and Reactive Power.
(6) Short Circuit Current Calculation at Various Point of Electrical Circuits(Isc).
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Short Circuit Current at Substation.
- Calculate Short Circuit Current at Distribution point.
- Calculate Short Circuit Current at Transformer.
- Calculate Short Circuit Current at Main Panel.
- Calculate Short Circuit Current at Sub Distribution Board.
(7) Circuit Breaker Tripping Settings.
- Calculate Tripping Setting of Circuit Breaker.
(8) Motor Specifications
- Calculate Various Specification of Motor.
(9) Calculate Home Electrical Load & Electrical Bill.
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate Electrical Bill of Home
- Calculate Size of MCCB/MCB for Domestic Load
- Calculate Electrical Load of Home.
(10) Calculate Insulation Resistance Value and PI value
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
- Calculate IR Value of Electrical Equipments.
- Graph of IR Value
- Calculate Polarization Index Value with Graph
- Calculate Earth Resistivity.
(11) Calculate Electrical Load and Energy Consumption of Panel.
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate Continuous and non Continuous Electrical Load of Panel.
- Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
- Calculate Size of MCB of each branch circuit of Panel.
- Calculate Voltage / Voltage Difference of Each Phase
- Calculate Unbalanced Load in Neutral Wire.
- Calculate Expected Temperature rise in Each Phase.
- Calculate Load in Each Phase.
- Calculate Starting/Full Load/Continuous/Non Continuous Load
- Calculate Size/Type/Tripping setting of Main MCCB.
(12) Calculate Electrical Load of Panel.
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate Voltage / Voltage Difference of Each Phase
- Calculate Unbalanced Load in Neutral Wire.
- Calculate Expected Temperature rise in Each Phase.
- Calculate Load in Each Phase and Outgoing Feeders.
- Calculate Starting/Full Load/Continuous/Non Continuous Load
- Calculate Size of Cables for Each Outgoing Feeder.
(13) Calculate Size of Battery Bank and Inverter.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Total Demand Load
- Calculate Size of Battery Bank in Amp.Hr.
- Select Type of Connection of Batteries in Battery Bank
- Select Rating of Each Battery in Battery Bank
- Calculate Size of Inverter.
- Calculate Size/Type/Tripping setting of Main MCCB.
(14) Calculate Size of Solar Panel / Battery Bank / Inverter.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Total Demand Load
- Calculate Size of Solar Panel.
- Select Type of Connection of Solar Panel.
- Select Rating of Each Solar Panel.
- Calculate Energy from Solar Panel as per Daily Sun lights.
- Calculate Size Battery Bank.
- Select Type of connection of Batteries in Battery Bank
- Calculate size of Inverter
(15) Calculate No of Lighting Fittings and Lumen Output.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Total Lumen Output for particular Area.
- Calculate Total No of Lighting Lamps.
- Calculate Total No of Lighting Fixtures.
- Calculate No of Fittings along with the Length and Width of Room.
(16) Calculate Bus Bar Size and Voltage Drop.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Voltage Drop for Bus Bar.
- Select Size of Bus Bar for particular Load.
- Enter Your Sub Panel Details like Load,Line Length.
(17) Design of Earthing Mat for Sub-Station:
FREE DOWNLOAD BUY UNLOCK VERSION
- Program is design as per ANSI/IEEE 80-1986 Code.
- Calculate Step Potential of Switch yard.
- Calculate Touch Potential of Switch yard.
- Calculate Total Length of Earthing Mat Conductor.
- Calculate Size of Earthing Mat Conductor.
- Calculate Total No of Earthing Rods.
(18) Calculate Touch Voltage and Ground Current.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Resistance of Each Phase.
- Calculate Resistance of neutral/Ground.
- Calculate Neutral Current and Load.
- Calculate Touch Voltage for Metal part to Earth.
- Calculate Body Resistance and Body Current.
(19) Calculate Size of Diesel Generator.
FREE DOWNLOAD BUY UNLOCK VERSION
- Calculate Size of D.G Set for Linear,Non-Linear Load
- Calculate Size of D.G Set for Motor Load
- Calculate D.G Set Efficiency.
- Calculate UPL (Unit per Liter) of D.G Set
- Calculate Unit Power Cost of D.G Set
- Calculate Approximate Fuel Consumption.
(20) Calculate Size of air conditioning for room.
FREE DOWNLOAD. BUY UNLOCK VERSION
- Calculate Size of Air Conditioning for Your Room.
- Calculate AC Size in BTU/Hr.
- Calculate AC size in Tone.
- Calculate Heating and Cooling BTU.
(21) Calculate Transverse Load on PCC/RCC/RSJ/Tublar/RSJ Pole..
- Calculate Crippling load on Pole
- Calculate Wind Load on Pole.
- Calculate wind Load on all Conductors.
- Calculate Transverse Load on Pole
- Decide spacing between Two Conductor as per IS:5613.
- Calculate required Voltage level of Overhead Line according to Distance.
(22) Calculate % Voltage Regulation of Small Distribution Line.
- Calculate % Voltage Regulation of Small Distribution Line
- Calculate % Voltage drop of Individual Load.
- Calculate % Voltage drop of Various ACSR, AAAC, AAC conductor overhead Line.
- Calculate Receiving end Voltage of Distribution Line.
- Calculate Total % Voltage Regulation of Distribution Line.
Jignesh.Parmar
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 subscibe your blog..
just click on
“Follow Blog via Email”
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.
Please let me know the electrical tools costs.
mail address
It is FREE of cost for downloading or uses but 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
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