I am having a problem using the arcmap point to raster tool. I have x/y coordinates for a set of data, and 1464 (2 months worth of hourly data) separate files to convert from an excel with X/Y/value to a matrix for use in another program. I already have a small python-script in order to automate the point to raster and then a raster to ascii, but in my first round of testing, the values i get out of this are really weird.
I have 6 separate excel files with x/y/value1/value2/value3... etc., which i have loaded into arcmap using the Add Data -> Add xy Data tool. However, when i convert this point data based on a value-field, it gives me a range of 0:401, whereas the actual maximum value in excel is 5.05. How can these values be so different?