cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

Data extraction

BPP
7-Bedrock
7-Bedrock

Data extraction

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Werner_E
24-Ruby V
(To:BPP)

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

Werner_E_0-1587379912254.png

 

View solution in original post

3 REPLIES 3
StuartBruff
23-Emerald II
(To:BPP)

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
24-Ruby V
(To:BPP)

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

Werner_E_0-1587379912254.png

 

BPP
7-Bedrock
7-Bedrock
(To:Werner_E)

Top Tags