×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Analysing large data sets

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

RE: Analysing large data sets

Have you tried pivot tables? They are suited for summarizing and grouping/treating large arrays of data

Best Regards

Morten

RE: Analysing large data sets

I agree that pivot tables might be your best bet, but you may also find that array functions have more flexibility.  There is a general discussion in Thread770-6411, and I addressed a similar problem to your own (as far as I can tell) in Thread770-62429.

The downside to array functions is that they are fairly memory intensive.

Regards

RE: Analysing large data sets

(OP)
Thanks guys, I'll have a closer look at the arrays & offset function, as I have not used these before. I just couldn't get the pivot tables to give me what I wanted.
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources