BicubicInterpolation with lot of missing data

Hi Annette,

Doing all at once is too hard. You need to look at a single cell to make the problem easier. Look at the row of 14.69833 row and the column of 8.43. How would you fill in that cell? Can you do a formula? Do you need the cells above and/or below the row to calculate it? Do you need the column heads before and after that cell. Find a formula. Does that fit for other cells in your range?

This is part or the Polya method. When you have a big problem make it easier. Break it down into a simpler problem...

Hope th is helps.

I agree with MarvinP -- this looks like a fairly challenging problem. Even for a 64x2400 matrix, my cost/benefit analysis suggests that a fully automated approach is going to "cost" more to implement than a simpler manual approach. The manual approach will probably take some time and it will be tedious, but it will still take less time than full automation. Of course, in that cost/benefit analysis, I have assumed that this is a one time or rare task. If I needed to do this daily or multiple times per day, then my analysis might change.

Even if I want to develop full automation, I'd probably start with a more manual process and do it that way until I understand exactly what I am doing. You have not explained in any detail how you want to fill in the gaps, so it is difficult for us to propose solutions (partially automated or fully automated). Starting with the value for the 14.70, 8.43 value that MarvinP mentioned? Should this value be 6.223 or 6.24824 or some other value? How did you make that determination?