I received raster data from a grid of 1100 by 1000 meters with a resolution of 1 meter. It is the output of EFC-400 software showing the field strength around power lines. The data is currently in Excel format and I want to use the raster in ArcGIS 10.2. In Excel the raster looks as follows:
x\y[m] B[uT] 0 1 2 3 4 5 6 0 0.01 0.01 0.01 0.01 0.01 0.01 0.01 1 0.01 0.01 0.01 0.01 0.01 0.01 0.01 2 0.01 0.01 0.01 0.01 0.01 0.01 0.01
etc...
The second row indicates the y-direction (0-1000 meters) and the first column indicates the x-direction (0-1100 meters). I assumed that removing the first 2 rows and the first column and subsequently adding the header that ArcGIS expects would make the import in ArcGIS possible. I added the following header to the Excel sheet:
ncols 1001
nrows 1101
xllcorner 0
yllcorner 0
cellsize 1
nodata -9999
and saved the data in .txt format. In Notepad I made sure that all datavalues were separated by a space. In ArcGIS I used 'ASCII to raster'. This gave no error message, but the shape of the resulting raster does not resemble the original raster:
The raster should show two powerlines approaching each other. Anyone any suggestions?