Results 1 to 6 of 6

Maximum cumulative value for the consecutive 3 days of data in 1 year period

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    Jakarta
    MS-Off Ver
    Excel 2003
    Posts
    23

    Maximum cumulative value for the consecutive 3 days of data in 1 year period

    Hi,
    I have daily rainfall data from satellite for 1 year period (See attached). I would like to calculate the maximum cumulative value for the consecutive 3 days for whole period (1 Jan to 31 Dec).

    As I am not mastering in Excel, so I just try it manually (one by one).
    1. I calculated the cumulative value for the consecutive 3 days i.e. 123 Jan, 234 Jan, 345 Jan ... 293031 Dec.
    2. After that I will look the max value from the result number 1.
    3. For example OBJECTID number 1 (in the excel file), the max value is 104.134

    Is it possible to do that using direct formula, without to do it one by one? If possible it would be helpful.
    Because I have daily rainfall data from 1981-2016 and need to calculate the max for all data. I will use this data to see the relationship between daily rainfall with flood hazard return periods.

    Thank you.
    Benny
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-13-2016, 10:33 AM
  2. Cumulative hours over a year extracting data from a rota
    By surva101 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-17-2014, 07:04 AM
  3. Counting Maximum Consecutive Days
    By Delleeb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-26-2013, 03:51 PM
  4. Maximum data availability time period considering data gaps...
    By hellojasmin12 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-09-2013, 05:34 AM
  5. Convert a multiple year list of 365 days/year into an equivalent of 360 days/year
    By lobotomy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2012, 05:39 PM
  6. Replies: 2
    Last Post: 08-06-2011, 11:15 AM
  7. [SOLVED] Days in month for 10 year period
    By Geoff in forum Excel General
    Replies: 4
    Last Post: 05-06-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1