Macro "Subarray Layout Optimization" Question

Dear Bruno,

For now the subarray layout optimization macro only works with the Residential and Commercial financial model. It will not work without a financial model because it uses the net present value (NPV) for the optimization.

It also does not work with the PPA financial models (single owner, partnership, leaseback) because of an issue with the variable name that we will fix in the next software update.

In the meantime, if you want to use the macro with a PPA financial model, you can fix it by modifying the macro script:

1. On the Macro page, click View code at the top right of the window.
2. Scroll down to Line 500:

   npv[i][j] = get('npv');

3. Add the line

   npv[i][j] = get('project_return_aftertax_npv');

   after that line and use forward slashes

   //

   to comment out Line 500.
4. Click Save, and then go back to the Macro page and try running the macro again.

This workaround allows you to change the variable name, so if you run the macro for a Residential or Commercial case, you can comment out the new Line 501 and use the variable assignment on Line 500 instead.



Best regards,
Paul.