All Forums  Origin Forum  Origin Forum  Detecting first jump in signal multiple sheets

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by LordM00[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2020b (64-bit) 9.7.5.184 (Academic) Operating System: Windows 10 Hi, I am trying to detect large signal jumps, similar to what is shown here: http://blog.originlab.com/detecting-jumps-in-signal-data The issue is that I have a large number of sheets that I need to do this to, and I only care about the first jump. I am trying to define a function, and then use it in a sheet that has all of the other sheets that I want to apply this function to listed in a single column. This is similar to this method https://my.originlab.com/forum/topic.asp?TOPIC_ID=47009 to find maximum or minimum values in specific columns of many sheets. To do this I have defined the following function Aset(): function double Aset(int nSheet) { range ra = [A1S]$(nSheet+3)!col(A); return idx(diff(ra)>1E-4)[0]; The way I think this should work is that it will look for any points in column A of the sheet numbered "nSheet + 3", where nSheet is the input, which have a difference between them and the next point of more than 1E-4, and then return the row index of the last point that it finds. Unfortunately this does not seem to be working. Additionally, I want the first point to make this jump, not the last point. Is anybody able to determine the issues with my formula? If not, is there another method that would make this easier? Thanks, Michael [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.