I apologise in advance if this is a really simple thing or Google, but I have been drawing a blank now for several hours and can't get a workable answer off of Google.
The crux of the problem is I want to calculate the distance of a load of points (using Pythagoras) in a grid from the centre point, similar to that below.
So cell A1 is 1m in the x and y direction from the origin so SQRT(1^2 +1^2)=1.41... similary D2 is 2m y and 4m x direction so SQRT(2^2+4^2)=4.47 and so on.
It is easy enough to do for a small selection of cells like that above, but I need to do it for approx 100 values in both the x and y direction and on 360 degrees (or at least 90 degrees - I can hack it from there) not just 45 degrees in the example above.
So can any of you suggest a way to easily do all 10,000+ calcs without doing it manually in excel, or even direct me to a somewhere that has already done it?
If you're interested in the background of the problem, I have been asked at work to produce noise calculations for several different scenarios which involves the calculation of the combined noise in dB (e.g. 84dB + 85dB = 88dB) and then how this dissipates over a large area - and all in accordance with BS5228-1:2009. To plot a nice surface graph I need to calculate the power at all the given distances from the assumed origin. I'm going a little beyond the required answer here, but I'd rather produce an easily editable spread sheet rather than one-off hand calcs.
The crux of the problem is I want to calculate the distance of a load of points (using Pythagoras) in a grid from the centre point, similar to that below.
Code:
A B C D
1 1.41 2.24 3.16 4.12
2 2.83 3.61 4.47
3 4.24 5.00
4 5.66So cell A1 is 1m in the x and y direction from the origin so SQRT(1^2 +1^2)=1.41... similary D2 is 2m y and 4m x direction so SQRT(2^2+4^2)=4.47 and so on.
It is easy enough to do for a small selection of cells like that above, but I need to do it for approx 100 values in both the x and y direction and on 360 degrees (or at least 90 degrees - I can hack it from there) not just 45 degrees in the example above.
So can any of you suggest a way to easily do all 10,000+ calcs without doing it manually in excel, or even direct me to a somewhere that has already done it?
If you're interested in the background of the problem, I have been asked at work to produce noise calculations for several different scenarios which involves the calculation of the combined noise in dB (e.g. 84dB + 85dB = 88dB) and then how this dissipates over a large area - and all in accordance with BS5228-1:2009. To plot a nice surface graph I need to calculate the power at all the given distances from the assumed origin. I'm going a little beyond the required answer here, but I'd rather produce an easily editable spread sheet rather than one-off hand calcs.