excel - Sum Column Until Value then Copy Row -



excel - Sum Column Until Value then Copy Row -

i have set of info not have linear time increments , sum column takes delta between current , previous sample time (time delta) until reaches 15 mins or more. 1 time point reached, re-create entire row of info @ >=15 min point , paste new sheet. after have row, go on same function in loop until reaches end of data.

in essence, take info has sporadic time increments samples , turn 15 min sample info (lowering resolution). of info working below reference.

date+time time delta temp_a temp_inv dcv_in out_pwr 01/13/14 19:39 0:00:00 74.67 66.65 317.99 8845.09 01/13/14 19:40 0:01:00 74.77 66.76 317.46 8851.05 01/13/14 19:41 0:01:00 74.87 66.86 317.56 8845.09 01/13/14 19:41 0:00:00 75.01 66.97 318.51 8855.81 01/13/14 19:42 0:01:00 75.17 67.11 318.51 8846.28 01/13/14 19:43 0:01:00 75.28 67.29 318.53 8846.28 01/13/14 19:44 0:01:00 75.48 67.38 318.61 8849.86 01/13/14 19:45 0:01:00 75.58 67.51 318.77 8848.67 01/13/14 19:46 0:01:00 75.78 67.72 318.75 8845.09 01/13/14 19:47 0:01:00 75.88 67.84 318.41 8851.05 01/13/14 19:49 0:02:00 76.08 68 318.69 8853.43 01/13/14 19:50 0:01:00 76.42 68.17 318.43 8845.09 01/13/14 19:52 0:02:00 74.87 68.52 336.17 0 01/13/14 19:54 0:02:00 74.67 68.61 318.53 8852.24 01/13/14 19:56 0:02:00 75.17 68.62 318.87 8848.67 01/13/14 19:57 0:01:00 75.68 68.73 318.59 8845.09 01/13/14 19:59 0:02:00 75.99 68.84 318.53 8848.67 01/13/14 20:00 0:01:00 76.19 68.95 318.61 8848.67 01/13/14 20:02 0:02:00 76.49 69.07 318.65 8849.86 01/13/14 20:03 0:01:00 76.7 69.18 318.25 8845.09 01/13/14 20:05 0:02:00 77.01 69.3 318.93 8847.48 01/13/14 20:06 0:01:00 77.22 69.53 318.73 8847.48 01/13/14 20:08 0:02:00 77.42 69.64 317.12 8845.09 01/13/14 20:09 0:01:00 77.64 69.76 317.06 8852.24 01/13/14 20:11 0:02:00 77.94 70 317.22 8841.52 01/13/14 20:12 0:01:00 78.06 70.11 317.3 8851.05 01/13/14 20:14 0:02:00 78.28 70.35 318.79 8854.62

so script looking sum time delta column (starting @ top), reach 15 minutes or greater in sum (which happen @ 19:54 sample) , re-create 19:54 sample row new sheet. hand have 100,000 rows need have performed , quite tedious do.

any help appreciated.

i think might achieved formula such as

=if(h1+minute(b2)>=15,0,h1+minute(b2))

in columnh (h1 beingness blank) copied downwards suit filtering select 0 in column , copy/paste new sheet.

excel vba excel-vba excel-formula worksheet-function

Comments

Post a Comment

Popular posts from this blog

java Multi query from Mysql using netbeans -

java Multi query from Mysql using netbeans - i have java code retrieve info mysql appropriate code in netbeans.the code below. want multi query such illustration finding total number of products , on.could help me please. in advance import java.sql.*; public class javamysqlselectexample { public static void main(string[] args) { seek { string mydriver = "com.mysql.jdbc.driver"; string myurl = "jdbc:mysql://localhost/sample"; class.forname(mydriver); connection conn = drivermanager.getconnection(myurl, "root", "mypasscode1"); string query = "select * products"; statement st = conn.createstatement(); resultset rs = st.executequery(query); while (rs.next()==true) { int code = rs.getint("code"); string productname = rs.getstring("product_name"); string producttype = rs.getstring("product_type"); system.out.format(" %d, %s, %s\n", code, pr
Read more

c# - DotNetZip fails with "stream does not support seek operations" -

c# - DotNetZip fails with "stream does not support seek operations" - i using dotnetzip in c# unzip stream follows: public static void unzipfromstream(stream stream, string outdir) { //omit seek grab block using (zipfile zip = zipfile.read(stream)){ foreach (zipentry e in zip){ e.extract(outdir, extractexistingfileaction.overwritesilently); } } } stream obtained using webclient client = new webclient(); stream fs = client.openread(url); however, got next exception exception during extracting zip stream system.notsupportedexception: stream not back upwards seek operations. @ system.net.connectstream.get_position() @ ionic.zip.zipfile.read(stream zipstream, textwriter statusmessagewriter, encoding encoding, eventhandler`1 readprogress) on server side(asp.net mvc 4), returning filepathresult or filestreamresult both caused exception. should obtain stream differently on client side? or how create server homec
Read more

c++ - StartServiceCtrlDispatcher don't can access 1063 error -

c++ - StartServiceCtrlDispatcher don't can access 1063 error - i write on c++ service , have error, , don't can fixed it. my service main function int main (int argc, tchar *argv[]) {dword f; for(int i=0;i<113;i++) f = getlasterror(); servicepath = lptstr(argv[0]); outputdebugstring(_t("my sample service: main: entry")); //installservice(); service_table_entry servicetable[] = { {service_name, (lpservice_main_function) servicemain}, {null, null} }; // startservice(); if(!startservicectrldispatcher(servicetable)) { f = getlasterror(); //addlogmessage("error: startservicectrldispatcher"); } else if( memcmp(argv[argc-1],"install",7)) { installservice(); } else if( memcmp(argv[argc-1],"remove",6)) { removeservice(); } else if( memcmp(argv[argc-1],"start",5)) { startservice(); } else if( memcmp(argv[argc-1],"stop",4))
Read more