Forum Discussion

MSRAZA's avatar
MSRAZA
Copper Contributor
Nov 25, 2024
Solved

Iteration error

I am iterating to calculate the actual_neutral_axis of a doubly concrete beam, but I am getting errors. Could you please suggest a better way to solve this problem? Also find the Excel file from the...
  • PeterBartholomew1's avatar
    Nov 26, 2024

    It seems your circular reference iterations diverge. I got a solution using goal-seek to reduce the differences to zero.  With 365 it would be possible to write an iterative solution that would converge, even if it meant replicating an automated version of goal-seek.

     

Resources