Add sum of columns and max as new row

Shell Programming and Scripting
1

Hi,

I am a new bie i need some help with respect to shell onliner;

I have data in following format
Name FromDate UntilDate Active Changed Touched

Test          28-03-2013     28-03-2013    1             0.6667       100
 Test2      28-03-2013     03-04-2013     10           1.6667       100

I need new row to be added at the end with following data

  1. I need Minimum date from second Column
  2. Maximum date from Third column
  3. Maximum value from Fourth Column
  4. Sum of 5th, 6th and 7th Column

How do achieve this; can someone help?

2

What have you tried?
How do you think you would approach this problem?

There is reluctance by many to simply provide an answer, especially when the request is written and looks like a homework or classwork assignment.