3 Replies Latest reply on Jul 3, 2018 12:33 AM by Zhouyi Zhang

# Time series data clac

Hi all,

I hope this is an easy question.

I am working on a time series data-set that shows the levels in a water tank. (i.e. 5.0 ML) in 15 minute time intervals. i.e. column A & B

I need to calculate the tank outflow i.e. column C every hour like the below example.

 Date and Time PC Volume Tank outflow (ML/d) 1/06/2017 0:00 75% 0.06 =((B2-B6)/100)*24*5.0 1/06/2017 0:15 74% 0.06 1/06/2017 0:30 72% 0.048 1/06/2017 0:45 71% 0.048 1/06/2017 1:00 70% 0.048 1/06/2017 1:15 69% 0.048 1/06/2017 1:30 68% 0.06 1/06/2017 1:45 67% 0.072 1/06/2017 2:00 66% 0.072 1/06/2017 2:15 65% 0.084 1/06/2017 2:30 63% 0.096 1/06/2017 2:45 61% 0.132
• ###### 1. Re: Time series data clac

Hi, Amir

Please find my solution below.

One thing I am not sure is for those data can't find B6, what should be the calculation.

ZZ

• ###### 2. Re: Time series data clac

Thanks for that. I am going to adopt this for 5 years of data and the null values will be excluded at the end.

• ###### 3. Re: Time series data clac

Cool

ZZ