excel - 10 millisecond data - need to group in 15 minute blocks and apply log average to each block -

-

i have set of data taken @ 10 millisecond intervals. need group data 15 minute blocks (9,000 milliseconds) , obtain log average 1 column , 10th lowest percentile other (my data in decibels).

is there way can split data every 9,000th row , form groups this, , apply formula each group - without having repeat process each group? i.e. way set can drag down results (i have 2 weeks of data.)

to calculate average of rows 1-9000 in column a can use following formula:

=average(index(a:a,(rows($1:1)-1)*9000+1):index(a:a,(rows($1:1))*9000))

if drag down, next 1 calculate rows 9001-18000 , on.


Comments

Post a Comment

Popular posts from this blog

java - Date formats difference between yyyy-MM-dd'T'HH:mm:ss and yyyy-MM-dd'T'HH:mm:ssXXX -

-
i trying parse date 2014-12-03t10:05:59.5646+08:00 using these 2 formats: yyyy-mm-dd't'hh:mm:ss yyyy-mm-dd't'hh:mm:ssxxx when parse using yyyy-mm-dd't'hh:mm:ss works fine, when parse yyyy-mm-dd't'hh:mm:ssxxx parseexception thrown. which correct format parse date , difference between these 2 formats? note : cannot use joda :( those valid formats: yyyy-mm-dd't'hh:mm:ss.sssz >>> e.g.: 2001-07-04t12:08:56.235-0700 yyyy-mm-dd't'hh:mm:ss.sssxxx >>> e.g.: 2001-07-04t12:08:56.235-07:00 edit: btw, "x" refer (iso 8601 time zone)
Read more

Fatal error: Call to undefined function menu_execute_active_handler() in drupal 7.9 -

-
i in problem, site down. fatal error: call undefined function menu_execute_active_handler() in drupal. please me. as function part of essential codebase, inside includes/menu.inc, please check integrity of source code of drupal. apart that, drupal 7.9 old, insecure release. if security updates not applied, site hacked. check page: https://www.drupal.org/drupalsa05faq if these not help, install xdebug php extension ( http://xdebug.org/ ) , check execution profile, xdebug can stacktrace-included errors, can lot.
Read more

python - RuntimeWarning: PyOS_InputHook is not available for interactive use of PyGTK -

-
i'm using pygtk python 2.7 in ubuntu 14.04, following message: runtimewarning: pyos_inputhook not available interactive use of pygtk what reason ? when trigger? trying run script or use pygtk interactively? most likely, input hook grabbed interactive loop, e.g.: >>> import tkinter >>> root = tkinter.tk() # input hook grabbed tkinter immediate result evaluation >>> import gtk # gtk tries grab hook, fails /usr/lib/python2.7/dist-packages/gtk-2.0/gtk/__init__.py:127: runtimewarning: pyos_inputhook not available interactive use of pygtk the immediate result evaluation means expression results evaluated (e.g. window displayed) before entering main loop. have in mind, warning, not error, if bothers you, can import gtk module can (or, well, reasonably early) , release input hook: import gtk gtk.set_interactive(false) import tkinter root = tkinter.tk() # no warning here
Read more