Hi, The latest version of A.CRE Ai1, version Beta v0.7 seems to have a bug with the construction module.
For example, the provided file has Building Shell costs of $5.5MM, which compound up to a cost of $165MM. When updating the example for my own variable inputs, I found a similar issue, with the construction interest calculating at $191MM on a $46.7MM project over an 18 month development time with leverage of 85% at 7.95% interest rate. The previous version of the model did not have this issue.
in the sum function there is a reference to E32:E32. I am not sure why this is expressed this way (instead of just E32) since the first cell reference is relative, not fixed.
Thanks for the heads up on this. While the logic written that way won’t change the answer, it’s sloppy! I’ve added this to my list to correct in our next release.