Calculation with range variables

[Sergey]

Hello.

I am having troubles with the outputs when the range variable "n" is used (file attached).

The range variable is defined from 2 to 6 with the step of 1. So there are 5 elements in 5x1 matrix.

But at some point during the calculation I get more than 5 outputs (parameters L_e, A_e, X_e, I_e and Pg.

What did I do wrong in my spreadsheet? I will appreciate any feedback.

Best regards, Sergey

[terryhendicott · Accepted solution]

Hi Sergey,

Never confuse a range index with a vector of scalar values.  A range is not a variable it is an index.

Have substituted ni as the range index for addressing or indexing the values in the n scalar column vector variable

Cheers

Terry

[Sergey]

Thank you, Terry.

I get what I did wrong. Will make sure to remember it.

Best regards, Sergey

[ttokoro]

[Sergey]

Thank you, sir.