All Forums  Origin Forum  Origin Forum  Extract data from worksheet with rounding

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 Talku[/i] [br]Hello, I do not have experience in Origin, so I hope I can explain my problem: I want to extract data from a worksheet. Column A is the time, column B a measurement value, and column C the status of the measurement equipment. The task is: If the value in column C changes to 50, look at the time in column B (lets say for instance its 321.3). Search in column B for the closest value to "two seconds later" (321.3 + 2 = 323.3) and extract the row (columns A and B) into a second worksheet. Up to now, two measurements, i.e. one row, were apart exactly 0.1 seconds. So when the value in C became 50, I just extracted the row 20 rows below (because 20 rows later equals 2 seconds). I did this with the "extract data from worksheet" dialog. Now the measurement frequency is not constant anymore, i.e. sometimes it takes 0.1 seconds, sometimes 0.3 seconds between to measurements, so I cant use the number of rows to search for the value 2 seconds later. Moreover, this means that sometimes I do not have a datapoint exactly two seconds later, but 1.8 seconds or 2.1 seconds. So I have to find the [u]closest[/u] value to 2 seconds. Thank you for your Help! [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.