I've set up a long and complex "formula" in an excel spreed sheet that's inputs are X and Y coordinates and a row of variables. My final result needs to be an X by Y grid/matrix of the output for each location. This image hopefully explains it better if you're confused.
Excel Help 0.jpg

I manually, one by one, filled out the first row by changing the X value in the sheet and copying the output over but this is an unrealistic approach that only helps to show my intentions. Here is that.
Excel Help 1.jpg

Is there any advice you can give me in regards to getting a grid/matrix output? Preferably one that in real time adapts to changes in the row of variables.

-Joe, thank you in advance.