How to solve for Va=Ea-(Ra+jXs)Ia
How to solve for Va=Ea-(Ra+jXs)Ia
(OP)
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
How to solve for Va=Ea-(Ra+jXs)Ia
|
How to solve for Va=Ea-(Ra+jXs)IaHow to solve for Va=Ea-(Ra+jXs)Ia(OP)
Red Flag SubmittedThank you for helping keep Eng-Tips Forums free from inappropriate posts. Reply To This ThreadPosting in the Eng-Tips forums is a member-only feature.Click Here to join Eng-Tips and talk with other members! |
ResourcesThe world has changed considerably since the 1980s, when CAD first started displacing drafting tables. Download Now
Prototyping has always been a critical part of product development. Download Now
As the cloud is increasingly adopted for product development, questions remain as to just how cloud software tools compare to on-premise solutions. Download Now
Engineering-centric businesses face a number of challenges today, but unmanageable design and change processes don’t need to be counted among them. Download Now
|
RE: How to solve for Va=Ea-(Ra+jXs)Ia
Have you tried solving it?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
Type COMPLEX in the help, and it should detail all the functions available.
But for equations as simple as your example, it is probably easier to do it by hand !
RE: How to solve for Va=Ea-(Ra+jXs)Ia
One is just use use the standard excel tools to do it, which I assume you could do based on your knowledge of complex arithmetic.
Another is excel analysis took-pak. A downside of that is that your spreadsheets aren't very portable (if you give them to someone without the took-pak installed, they won't be able to see it).
Yet another way is to build the tools for complex arithmetic from vba. Doug (ids) has done something similar to this, perhaps interfacing with Alglib. This treats complex numbers as two adjacent cells: left one with real value and right one with complex number. To enter a formula you need to select two adjacent cells, type the formula, and press ctn
Attached spreadsheet has all those routines in vba (see examples tab for their use) and your problem solved in the tab labeled Clyde.
I assumed Ea and I have the same angle (0), probably not the correct assumption, but good enough for illustration.
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
magoo2 - I have not solved this. I'm am trying to incorporate some design work for an associate, but the help provided for complex numbers seems confusing to me. Maybe I'm the problem.
DiscoP - I do have the analysis ToolPak loaded. This is just the first of many equations that I will try to incorporate in the spreadsheet.
Would either of you mind posting an example spreadsheet for just this equation? I see functions for using text etc. in the group of complex functions and I'm not quite sure how this relates to task at hand.
RE: How to solve for Va=Ea-(Ra+jXs)Ia
magoo2 & DiscoP please ignore my request for a sample spreadsheet.
I did not see pete's post at the time I asked.
Thanks to all!
RE: How to solve for Va=Ea-(Ra+jXs)Ia
I assumed you were going to do more complicated equations with it.
Attached is how you can do this using the Complex functions of excel.
I've included the answer with the magitude and angle too (which is what most electrical people really care about !)
The rectangular version of the answer uses 'i' for the imaginary part - you can get the answer displayed with a 'j' too if you want - see help for details.
RE: How to solve for Va=Ea-(Ra+jXs)Ia
More details at the link below:
http://new
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: How to solve for Va=Ea-(Ra+jXs)Ia
The spreadsheet I made up uses a different method to electricpete - it may be of some use ??
RE: How to solve for Va=Ea-(Ra+jXs)Ia
This is of course standard syntax for entering array formulas.
There's more info at Doug's link.
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
For (R + j X) * I
what is the real part, and what is the imaginary part?
All you're doing is added another real term to this result (Ea).
You should be able to check your result since this is a new member post and i suspect a student post.
RE: How to solve for Va=Ea-(Ra+jXs)Ia
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
electricpete - Thanks again!
RE: How to solve for Va=Ea-(Ra+jXs)Ia
h
Maybe it will help someone else. . .
RE: How to solve for Va=Ea-(Ra+jXs)Ia
Before these complex functions were developed in Excel, I used to make worksheets with
products based on (a + j b) * (c + j d)
results would be in cells e and f
division based on (a + j b) / (c + j d)
again, results would be in cells e and f
Obviously, you have to multiply the equations to get the results, but once you've done so you can use the worksheet for many varieties of complex math problems.
It's just another way to skin a cat.
RE: How to solve for Va=Ea-(Ra+jXs)Ia
Real Va = Ea-Ra*Ia
complex Va = Xs*Ia
Don't need to use analysis tool pak...
RE: How to solve for Va=Ea-(Ra+jXs)Ia
=====================================
(2B)+(2B)' ?
RE: How to solve for Va=Ea-(Ra+jXs)Ia
=====================================
(2B)+(2B)' ?