Average value for each 15 minutes

[ibau777]

Hi everyone,

I would like to ask for some help for a VBA code.

I have a huge sheet (CSV) with values registered every 1 minute. The CSV is in format: date (dd/mm/yyyy hh:mm:ss) , value

I would like to return the average value for each 15 minutes. The problem is that there are some gaps in the record. For example, there are some days where only few hours are recorded. For this cases, I would like to use the average of the 3 next days for some instant.

Example:

If there are a gap between 01/01/2012 01:00:00 and 01/01/2012 01:15:00 I would like to used the average from 02/01/2012 01:15:00, 03/01/2012 01:15:00 and 04/01/2012 01:15:00 averaged values.

This is quite complex.

I thought about the algoritm. Firstly I think I need to calculate the average for each 15 minutes without considering the gaps (if there are a gap the code should leave a empty cell)

Then the code should find the empty cells and use the next 3 days for estimate the values.

I hope you guys could help me.

Regards.

 

[ibau777]

I already have some code doing what I'm looking for. But for 70000 active cells it takes too much time (2 minutes). I think some things could be improved because I dont know the excel vba "shortcuts".

Can someone help me?