Challenge #113: Interpolating Spatial Grid Values

[Kinga]

hi,

Please find my solutions: one Spatial one non-Spatial.

Spoiler

[ahsanaali]

Spoiler

[FrederikE]

Spoiler

[rubaiyadoula]

Spoiler

In the provided solution, could anyone please explain how this Batch Macro is working?

1. This is the U input that contains all the non-zero Pixel Values:

U Input with all the values that aren't 0

2. The Z input with all the 0 Pixel Values:

Z Input with all the 0 values

3. The Control Parameter with the field "Concat_Column_Row" and none group settings:

Control Parameter

4. Output of the Macro:
 

Based on the input, how is it calculating the missing value using the average of the known measurements from the surrounding cells only based on one column value and outputting the Smoothed Pixel Value?

[kristiadiuisan]

Spoiler

[olga_strubbe]

Spoiler

This was a neat, but definitely challenging problem, thank you!  I liked the solution by @ggruccio    I followed a similar approach.  Thank you, ggruccio!

[alacoume]

My solution:

[CeliaC_Silje]

Spoiler

[bkclaw113]

I went a different route and ignored the spatial component

Spoiler

Once you transpose the columns and get row,col, value just takes a simple batch match to average the adjacent values for the missing spots.

[chandler-gjino]

attaching my solution