How can I loop row by row?

Anita Fitriani

2020 3 30

0 个回答

2 次查看（30 天）

0 个投票

validation.xlsx

So I have Model Data and Survey Data. I would to check error with iteration formula as following Excel below.

First iteration, I have to check error by subtracting data model 1 2 3 4 5 6 with data survey 1 2 3 4 5 6, and i calculate the error. And i find the error is 479

i=1 RMS = model(1)-survey(1)

Second iteration, I check error by subrtacting data model 2 3 4 5 6 7 with data survey 1 2 3 4 5 6, and i calculate the error. I find the error is 158

i=2 RMS = model(2)-survey(1)

Iteration will stop after last data model - last data survey (in fifth iteration).

i=5 RMS = model(5)-survey(1)

Thanks before