Analysing large data sets
Analysing large data sets
(OP)
Hi all,
I have a 62 year rainfall record on which a number of calculations are performed. The data set is used to model the performance of a set of ponds to determine spill occurrence, make-up volumes etc.
Is there a way to perform a sort of conditional sumif based on the dates? For example to pull out rainfall events summary by month / year.
One other useful function would be to return a table or listing of the dates where spills / run dry occurred. Sorting the data based on values can be done, but requires a cut'n'paste each time as all the internal dependancies get ruined. Can anyone provide me with some pointers for better result reporting?
Thanks
GAllen
I have a 62 year rainfall record on which a number of calculations are performed. The data set is used to model the performance of a set of ponds to determine spill occurrence, make-up volumes etc.
Is there a way to perform a sort of conditional sumif based on the dates? For example to pull out rainfall events summary by month / year.
One other useful function would be to return a table or listing of the dates where spills / run dry occurred. Sorting the data based on values can be done, but requires a cut'n'paste each time as all the internal dependancies get ruined. Can anyone provide me with some pointers for better result reporting?
Thanks
GAllen





RE: Analysing large data sets
Best Regards
Morten
RE: Analysing large data sets
The downside to array functions is that they are fairly memory intensive.
Regards
RE: Analysing large data sets
It's not all bad tho', a friend made a little C++ proggy which did the trick, although the workings are doubly incomprehensible. <sigh>...more book learnin' req'd.
GAllen