-
Well, one way to do it semi-manually with Excel is to use this website to load an image into excel (I haven't tested the website though, btw). This is very non-elegant compared to using a proper language like Python, but has the advantage that you can work with what you know.
Once you have the image in one sheet you should be able to use Excel formulas in another sheet to calculate any kind of average or root mean square value of whatever grid you want.
none. unless we are counting excel.
i would like to do it on a 100x100 grid