Hi Spencer,
First of all many thanks for sharing the models!
I’ve been playing with All in One v0.5.2 model and filled in some development costs. Besides, I also translated some cells in Development tabs.
More precise; I translated the ‘B’ column and row 10 in Budget tab; and all wordings in ‘Sources and Uses’.
The blue construction interest input (C15) works fine and when i change, interest rate (H15) also change.
However, when the macro is pressed, the cells C6 & C10 show strange values. Moreover, C15 & C16 also dont work now anymore..
That is very strange. I downloaded your file and I’m not able to replicate your issue. When I press the ‘Set Construction Loan Amount’ button on the ‘Sources and Uses tab’ in your file on my end, the Macro runs correctly and the Construction Loan amount (C7) adjusts accordingly. Perhaps it’s a Excel version issue? Can I ask, what operating system and version of Excel are you running?
Quick tip: If the actual LTC (‘Sources and Uses’ cell E8) and the target LTC (‘Sources and Uses’ cell E7) are too close (e.g. 70.0% and 69.9%), when the Macro runs Excel deems the values close enough and nothing happens. To correct this, set the target LTC to some value much less than the target (e.g. 50%) and hit the ‘Set Construction Loan Amount’ button. Then, change the target LTC back to your desired target LTC (e.g. 70%) and hit the ‘Set Construction Loan Amount’ button again and you will get the value you desire. This tip isn’t likely to fix your issue, but is related and for the benefit of others.
