I have some pump runtimes that I’m wanting to condense into readable and presentable data.  I have a snippet of a sample table that shows the data I’m working with on a larger scale.  I have some previous programming experience but cannot connect the dots right now to get to where I want to be.  Any help at all would be much appreciated.  0 signifies not running 1 signifies running.  The larger tables are minute by minute.  Like I said this is a snippet.  Ideally my end goal is an output that says both pumps off for x minutes then pump 1 or 2 on for y minutes then both off again for x then on for y repeated until the entire table has been gone thru.  The reports that have the raw data are generated in excel and I’d like to be able to apply some formulas to them to get my desired results.  Any help is appreciated.  Thank you.

Bennett’s LSBennett’s LSPUMP #1PUMP #2ValueValue000000001010000000000001010100

​I have some pump runtimes that I’m wanting to condense into readable and presentable data.  I have a snippet of a sample table that shows the data I’m working with on a larger scale.  I have some previous programming experience but cannot connect the dots right now to get to where I want to be.  Any help at all would be much appreciated.  0 signifies not running 1 signifies running.  The larger tables are minute by minute.  Like I said this is a snippet.  Ideally my end goal is an output that says both pumps off for x minutes then pump 1 or 2 on for y minutes then both off again for x then on for y repeated until the entire table has been gone thru.  The reports that have the raw data are generated in excel and I’d like to be able to apply some formulas to them to get my desired results.  Any help is appreciated.  Thank you.Bennett’s LSBennett’s LSPUMP #1PUMP #2ValueValue000000001010000000000001010100  Read More

​