Problem with interpolating data

[Elise.B]

I have a problem with interpolating. When the residuel of a data point (polyline-data point) is 2x standard deviation (allready calculated), then I want reject the data point and it appears red, "rejected" and thick. Then I want to interpolate with the previus and next datapoint.

When 2 datapoints are rejected after each other this no longer goes. When this is the case I want to replace the data point with the polyline value.

I tried to make something, but it runs stuck.

Please Login or Register  to view this content.

[Andy Pope]

Do you not just need to test the cells before loading their contents into a variable. That way last know usable values will be kept.

If you need more help it would be useful if you could post example data set.

[Elise.B]

I know that 'nextgoodtop' gets the value rejected. Thats why it won't interpolate. But I don't know how to program it the right way that if the next line is rejected that it just copies the poly value.
example.xls

[Andy Pope]

How do you think this should work? Maybe you mean if the cell in the next row is "Rejected"?

Please Login or Register  to view this content.

And you appear to be double counting. You increment the variable Counter and the CheckedRow variable by Counter.


Why not add a do loop within the test for Rejected so you just move over those cells.

Please Login or Register  to view this content.

[Elise.B]

Yes, I added the next thing, but this doesn't yet do the work. I still get a 'mismatch' when it tries to calculate Topdiff = (NextgoodTop - LastgoodTop). And I get an 'object defined' error it this line: ElseIf Cells(checkedrow + 1, AfterRejectionEColomn) = "Rejected" Then

Please Login or Register  to view this content.

[Andy Pope]

This runs without error but I have no idea whether the output is correct.

Please Login or Register  to view this content.

[Elise.B]

Yes it does indeed something.

What I would like is if there are two or more rows in a column after each other that are called "rejected" then I want to paste a value from the polycolumn to those cells. Otherwhise I interpolate with the macro, how to program that?
what is wrong about the following?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Andy Pope]

Perhaps it would make things clearer if you posted a workbook that included examples of the calculated results you are expecting.

[Elise.B]

It does now the job, but it goes on with the autofill and displays false.
How to fill only when there is data in de cells next to it?
example.xls

[Andy Pope]

Please Login or Register  to view this content.

[Elise.B]

Thanks, it working also the interpolating