I am trying to recreate something using Dynamo that I had previously solved using “iterative calculations” in Excel. But at the moment I am not sure how I can solve the “Cyclic Dependency” error in Dynamo - or whether that is actually possible?

The whole graph is a bit more complicated, but on a high level it’s an accommodation schedule:

- Based on an Area (GIA) input from a massing model and a desired mix of residential units, the graph calculates how many units in total can fit into that GIArea.
- For all these units, the Area for Communal Functions (bikes, bins etc.) is calculated.
- This Communal Area is then to be subtracted from the original GIA and the process should start at Point 1 again … (in Excel the calculation repeats for a max 1000-times or until the variance is =< 0.001).

Is something like this actually possible in Dynamo? Or is there another way to overcome the “cyclic dependency” error?

As always, many thanks for your suggestions and tips.

P.