IF the use of indirect is purely to make entry of the formulas easier then maybe create a direct formula using less direct methods.
Try entering this formula into No Anchorages C12, then copy it to C12:I29, K12:Q29,S12:Y29 and AA12:AG29.Next copy, and paste special > values on the same range.
Finally, use Ctrl h to do a find and replace of = with = (replace all).
The above steps allow you to create a whole formula as a text string, then convert it to a valid formula (with volatile functions removed).
Bookmarks