Skip to main content
B
BPP1-Visitor
1-Visitor
April 20, 2020
Solved

Data extraction

  • April 20, 2020
  • 2 replies
  • 1531 views

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.

Best answer by Werner_E

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

Werner_E_0-1587379912254.png

 

2 replies

S
StuartBruff23-Emerald V
23-Emerald V
April 20, 2020

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

W
Werner_E25-Diamond IAnswer
25-Diamond I
April 20, 2020

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

Werner_E_0-1587379912254.png

 

B
BPP1-VisitorAuthor
1-Visitor
April 20, 2020
Tank you very much Werner.
Terms & ConditionsAccessibility statement