How Can I Integrate Fixed Point Iterations with Excel Using VBA?

  • Thread starter Thread starter Bradracer18
  • Start date Start date
  • Tags Tags
    Fixed point Point
Click For Summary
The discussion centers on a user seeking assistance with programming to export data from their code back into an Excel sheet. They mention having implemented formulas and using Do-Loops for Fixed Point iterations and the Newton-Raphson method but are unsure about the correctness of their code. The user expresses a desire for guidance on how to properly integrate their results into specific cells in Excel. They also inquire about sharing files or macros for further help, indicating a need for ongoing support as they continue to work on their project. The conversation highlights the importance of understanding Excel functions, particularly the CELLS function, in achieving their goals.
Bradracer18
Messages
203
Reaction score
0
Hey guys...I'm not real smooth with programming, but I've got some of it done.


I need to use the formulas I have in the code, and export the data back into my excel sheet...The first Do-Loop is for the Fixed Point iterations, and the second part is for the NR method. I just need to learn how to make this get me my numbers into the spots on the sheet.


I'm not sure what I have is correct(other than the formulas).


If you guys can advise me, or show me once...I can probably do my best to carry it on.

Thank you,
Brad

***Ok, well it didn't let me attach the file...so I'm not sure what to do...

Can anyone help me out still...or maybe direct me to a website??
 
Technology news on Phys.org
You didn't give us a lot to go on, but... Look at the help for the CELLS function.
 
Actually, I mostly figured it out...I'll probably be posting more, as the year goes on...Thanks for the help tho!

Is there any way to post a macro...or the excel file?
 

Thread 'For those who ask: "What programming language should I learn?"'

Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...
View full post »

Similar threads

Equilibrium points doubt (ODE system solution)
  • · Replies 6 ·
Replies
6
Views
2K
How to calculate Tension for a series of connected points?
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad Why fixed point iteration of ##x^3 = 1-x^2## doesn't converge when ##x_0= 0##
  • · Replies 16 ·
Replies
16
Views
1K
How to write basic syntax for triangle recursion?
  • · Replies 8 ·
Replies
8
Views
3K
How to get Output from this Program into Excel?
  • · Replies 16 ·
Replies
16
Views
2K
Distance between fixed points of contracting maps
  • · Replies 12 ·
Replies
12
Views
2K
Excel Macros & VBA | Learn Programming Basics
  • · Replies 18 ·
Replies
18
Views
6K
Graduate Path between fixed points in a logistic map
  • · Replies 1 ·
Replies
1
Views
2K
Fix VBA Runtime 1004 Error in Excel Program
  • · Replies 2 ·
Replies
2
Views
4K
How to compute distance of points to a line?
  • · Replies 6 ·
Replies
6
Views
1K