Repetitive Cycle Data Analysis

%3CLINGO-SUB%20id%3D%22lingo-sub-2431207%22%20slang%3D%22en-US%22%3ERepetitive%20Cycle%20Data%20Analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2431207%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20data%20stream%20that%20has%20a%20repetitive%20cycle.%20I%20need%20an%20Excel%20method%20to%20identify%20the%20cycle%2C%20then%20add%20up%20the%20data%20within%20that%20cycle.%20In%20the%20example%20attached%20the%20cycles%20are%20shown%20going%20from%20the%20yellow%20cell%20to%20light%20green%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2431207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2431392%22%20slang%3D%22en-US%22%3ERe%3A%20Repetitive%20Cycle%20Data%20Analysis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2431392%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1074806%22%20target%3D%22_blank%22%3E%40TK-77%3C%2FA%3E%26nbsp%3BNot%20entirely%20sure%20what%20you%20want%20to%20achieve%20or%20how%20dynamic%20the%20solution%20should%20be.%20But%20it%20seems%20one%20cycle%20contains%2059%20readings.%20Correct%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached.%20Perhaps%20it%20helps%20you%20getting%20the%20answer%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a large data stream that has a repetitive cycle. I need an Excel method to identify the cycle, then add up the data within that cycle. In the example attached the cycles are shown going from the yellow cell to light green 

2 Replies

@TK-77 Not entirely sure what you want to achieve or how dynamic the solution should be. But it seems one cycle contains 59 readings. Correct?

 

See attached. Perhaps it helps you getting the answer you want.

@Riny_van_Eekelen 

 

Thanks for the input.  It may well do the trick.  We are measuring the energy use of a machine as it cycles through its process.  Readings are taken every second so the data columns get long.  I need to calculate the energy use per cycle. In the example I posted the cycle is 59 seconds.  I start the cycle where the numbers are lowest, usually for over 20 seconds. (the string of 5.9s in the spreadsheet)  Need to spot the string of 5.9s (manually works for the first one) and then end the cycle on the second before the next string begins.  What you provided seems to do that.