I created a workflow that does some interpolation & extrapolation calculations to get expected Present Value of Ending Surplus (PVES) based on a certain interest/treasury rate. See InterestRateSensitivity_v6.yxmd.
What I want to do now is vary the input: treasury rate (variable ExpIR_nonVA) multiple times and get the expected PVES for each iteration. I tried to use a batch macro for the same but I'm getting some errors. Honestly, I'm not even sure whether the steps I included in the macro would get the desired results. See Graphs.xlsx for the desired graphs (cell C40 onwards are the treasury rates and following columns will be the expected PVES output for each company & scenario). Graphs is not an issue, just getting those columns for expected PVES for each treasury rate. See InterestRateSensitivity_v6.yxmc (modification is highlighted in a tool container under 'Calculations' text box) and Expected PVES Calcs.yxmc (batch macro).
Any help would be appreciated!!
