Previous in Forum: ASP.NET   Next in Forum: Linux Questions...From a Returning Linux User
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
4 comments
Rate Comments: Nested
amitabha0107
Power-User

Join Date: Feb 2011
Location: Shimurali, Westbengal,India
Posts: 119

VBA Code for Excel (2007) for Newton-Raphson Analysis

10/20/2013 3:36 PM

Please provide me VBA code for excel (2007) for Newton-Raphson analysis in power system Load flow study.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
lyn
Guru

Join Date: Oct 2008
Posts: 42355
Good Answers: 1693
#1

Re: VBA code for excel (2007) for Newton-Raphson analysis

10/20/2013 3:43 PM

How to Search the Internet - Hannon Library at Southern Oregon ...

How To Code the Newton-Raphson Method in Excel VBA
Register to Reply
SolarEagle
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#2

Re: VBA Code for Excel (2007) for Newton-Raphson Analysis

10/20/2013 4:55 PM

Found a couple....

http://www.reseeds.com/load%20flow%20notes.pdf

http://epublications.bond.edu.au/cgi/viewcontent.cgi?article=1132&context=ejsie

__________________
 All living things seek to control their own destiny....this is the purpose of life
Register to Reply
JohnDG
Guru
United Kingdom - Member - Not a New Member Hobbies - Musician - New Member Hobbies - Fishing - New Member

Join Date: May 2006
Location: Reading, Berkshire, UK. Going under cover.
Posts: 9684
Good Answers: 468
#3

Re: VBA Code for Excel (2007) for Newton-Raphson Analysis

10/20/2013 5:44 PM

How much you payin'?

__________________
 "Love justice, you who rule the world" - Dante Alighieri
Register to Reply
RAMConsult
Guru
Engineering Fields - Power Engineering - New Member

Join Date: May 2007
Location: NYC metropolitan area.
Posts: 3230
Good Answers: 444
#4

Re: VBA Code for Excel (2007) for Newton-Raphson Analysis

10/20/2013 9:04 PM

Those are two different things. The Newton-Raphson method is an iterative numerical analysis techniques for solving a set of equations. A load-flow study is a set of equations that requires an iterative method for its solution.

If you are looking for a free load-flow program written in VBA for use in Excel, I suggest that you Google on just that. There are some out there, but they have varying degrees of accuracy, sometimes the same system analyzed by a few different programs yields different and/or inconsistent results. You could also write your own if the network only has a few nodes.

__________________
 “Tell me and I forget. Teach me and I remember. Involve me and I learn.” Ben Franklin.
Register to Reply
Register to Reply
Have a Different Question?
4 comments
Copy to Clipboard

Users who posted comments:

JohnDG (1); lyn (1); RAMConsult (1); SolarEagle (1)

Previous in Forum: ASP.NET   Next in Forum: Linux Questions...From a Returning Linux User

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (109 right now)
Show Members
Advertisement