Data extraction

[BPP]

Hi to all
I am trying to extract values from an array named DATA and look them up in another called Table_1, and then do operations.
By manually entering the row and variables of the DATA array, I get what was expected, but when I want to do it automatically, and have the data array be extracted and compared row by row, I don't get the expected results.

I attach the spreadsheet with the exercise.

I hope you can help me.

[StuartBruff]

I've only got Prime so can't play with your program (or even get it to evaluate), however, you might want to try debugging by taking your program outside of your new 'i' loop and call it from within the loop (ie, automate your manual evaluation).  You could use the row operator to set the return matrix for each i.

Stuart

[Werner_E · Accepted solution]

You forgot to initialize "MPot" to zero, so the values of the previous calculation remained in that variable.

[BPP]

Tank you very much Werner.