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.
Smpl(1;24),Smpl(2;24),Smpl(3;24),Smpl(4;24),Max(5;24),Min(6;24),Avg(7;24),Min(8;24),Avg(9;24),Avg(10;24),WAvg(11;24),Avg(12;24),Avg(13;24),Avg(14;24),Avg(15;24),Total(16;24)
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.
-A.G.
* Last updated by: AnthonyAGarza on 6/27/2012 @ 3:56 PM *
To substitute the valid data from the invalid data, take a look at the Help menu, Cue Cards, Combining Arrays topic. Basically you are opening two Input Files and selecting the elements out of each one that you want. Start condition parameters are used to sync the times of the two files. If you want a few elements from file 1, followed by data from file 2, and then continuing with data from file 1, you'll need to have an Input File for file 1, Input File for file 2, and Input File for file 1 again (hope that makes sense).
Regarding your second questions about keeping the days together, I believe the time synchronization of combining the two files will keep things in-line. If I remember correctly (haven't tested this in a while...), blanks will just be used for any data that doesn't exist.
Dana W.