Is there a methodology that would work well for replacing Excel with Mathematica?
Typically I use Excel to make various lists of values with formulae that relate those values. Below is a very typical example of a spreadsheet I might make showing radar range equations. I color input cells blue and computed cells are left black. It is very easy and simple to do:
Is there an equally easy approach to generating and organizing information like this in Mathematica?
UPDATE: I would like to re-open this question with the specific solution idea of using 2D Tables/Matrices. I did not realize this ability existed to create 2D input arrays using Mathematica.
Can I use 2D input arrays to simulate spreadsheet functionality?