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
SUMMARY

This discussion focuses on integrating Fixed Point Iterations and the Newton-Raphson (NR) method into Excel using VBA. The user, Brad, seeks assistance in exporting calculated data back into specific cells on an Excel sheet after performing iterations. Key functions mentioned include the Do-Loop for Fixed Point iterations and the CELLS function for data placement. The conversation highlights the need for clear guidance on VBA coding to achieve these tasks effectively.

PREREQUISITES
  • Basic understanding of VBA programming in Excel
  • Familiarity with Fixed Point Iteration and Newton-Raphson methods
  • Knowledge of Excel functions, particularly the CELLS function
  • Experience with Excel's macro recording and execution
NEXT STEPS
  • Learn how to implement Fixed Point Iterations in VBA
  • Study the Newton-Raphson method for root-finding in Excel
  • Explore the use of the CELLS function for dynamic data placement in Excel
  • Investigate best practices for debugging VBA code in Excel
USEFUL FOR

Excel users, VBA programmers, and anyone interested in numerical methods for solving equations within Excel.

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?
 

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
3K
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
Fix VBA Runtime 1004 Error in Excel Program
  • · Replies 2 ·
Replies
2
Views
5K
Graduate Path between fixed points in a logistic map
  • · Replies 1 ·
Replies
1
Views
2K
How to compute distance of points to a line?
  • · Replies 6 ·
Replies
6
Views
1K
Undergrad A few more questions about fixed point iteration ....?
  • · Replies 10 ·
Replies
10
Views
4K