I have two sets of data from two different weather stations. One of which has invalid records (ex: reporting a soil temperature of -6999). I was wonder if Loggernet's Split software has the ability to substitute these invalid data with valid data from the other source.
Also I was interested in using Split to convert my hourly weather data to daily recordings using the Averaging methods. I have gotten it to do this only if there is a full day's data collected for each day using Avg(x;24), where x is a given field and 24 is the interval i wish to average arrays.
this is my select line.
I couldn't quite get that range syntax to work for the methods...
As you can see each of these instructions is set so that every 24 rows it'll perform the instruction.
One problem i have is if there isn't a full 24 entries for a given day the average is thrown off and it ends up averaging entries from different days together. is there a way to impose a condition on the averaging using the Julian Day(field 3) such that, whenever the day in the current line is different from the previous line it will stop accumulating and instead average what it has and start the averaging process again.
Sorry if it's confusing to read. Any help is greatly appreciated.
* Last updated by: AnthonyAGarza on 6/27/2012 @ 3:56 PM *