×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Are you an
Engineering professional?
Join Eng-Tips Forums!
• Talk With Other Members
• Be Notified Of Responses
• Keyword Search
Favorite Forums
• Automated Signatures
• Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

#### Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

# Electrical Engineering & MS Excel2

## Electrical Engineering & MS Excel

(OP)
As an electrical engineer, I have used numerous excel sheets for various purposes. The most common ones are:
a. Cable sizing-Ampacity
b. Cable sizing-Voltage drop & Short circuit
e. Lightning protection risk calculation
f. Cable Tray sizing
g. Cable Pull Calculation
h. pu calculation for short circuit
i. Motor starting time
k. DC Battery sizing (IEEE485)
l. Battery Charger sizing

If you have used excel sheets for any of the above or other purposes, please share your thoughts.

### RE: Electrical Engineering & MS Excel

I've done quasi-static motor starting time calcs using excel.
T = J * dw/dt
t = integral {J / T((w))} dw

where w is radian speed and
where T((w)) would be motor torque speed curve minute pump torque speed curve.

If you tried to integrate until T(w) is 0, you face an interesting dilemma... the motor never gets there because acceleration approaches zero as w approaches the point where T((w)) = 0. You could create smaller and smaller step sizes and in theory I think accelerating time if you had perfect precision calculations would be infinite. So we can see the calculated time is very sensitive to the endpoint of the calculation.

Luckily, it is usually sufficient to cut off when the motor reaches full load speed rather than integrating until T(w) = 0

Comments - excel is a good tool for many calculations.

=====================================
(2B)+(2B)' ?

### RE: Electrical Engineering & MS Excel

I've done some calculations involved with induced voltages involving a transmission line and a distribution line based on capacitive coupling. It was a three-phase calculation with matrices.

I've done something similar with induced voltages on a light rail system from a nearby distribution line.

I've also set up worksheets to do fault calculations based on symmetrical components.

Pete's motor starting calcs sound interesting.

### RE: Electrical Engineering & MS Excel

(OP)
Yes Electricprete..this is exactly the way I did the calcs...the laborious part is noting down the torque values for each speed value from 0 to near synchronous speed for both the motor and the load. The method has been lucidly explained in the attached link. Also, attention is required for the units (lb-ft to Nm). Also, the load torque may not be at the same speeds on the graph as the motor torques. Thus, interpolation is required to bring the torques to the same speed values.

### RE: Electrical Engineering & MS Excel

(OP)
Some more calculations that I remember having done is:

a. the calculation of magnetic field at a certain coordinate, based on sections of DC Bus bars carrying 96kA of current in an Aluminum Smelter
b. Regression analysis to derive a two layer soil resistivity model using formula in Appendices of IEEE 80. This comes useful since ETAP grounding module can only use a two layer soil resistivity model.

One useful task that can be done using excel is to generate Data Sheets using a master table, and a macro, which serves to replace the certain characters. Important thing to remember is 95% of a Data sheet remains the same. The rest needs to be changed for a particular equipment.

Macros with suitably filled excel sheet can also be used to generate Microstation schematics! There is a bit labor in preparing the template schematics. But once it is done, schematic generation is a breeze.

### RE: Electrical Engineering & MS Excel

(OP)
One good source for Electrical engineering spreadsheets is Professor C.S Indulkar's site as given below. One can always improvise on these sheets.

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Close Box

# Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!