Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
jlaurent
Posted - 02/15/2008 : 04:53:04 AM Origin Version (Select Help-->About Origin): 7.5 Operating System:Windows 2000
Hello,
I would like knew how I can search all maximums in few columns in worksheet. This worksheet is compose of a time coulum (in index 1) and 100 amplitude columns.
The aim will be get and stock in another wks the results i.e all index and peck values.
For this I can use the peaks function ? Which is the good technical to use ?
Regards
Jérôme
1 L A T E S T R E P L I E S (Newest First)
couturier
Posted - 02/16/2008 : 05:30:59 AM Bonjour, vous pouvez effectuer les opérations suivantes: - créez un worksheet que vous appelerez Resultat: les indexes des max seront stockés dans la colonne A et les maxs dans la colonne B - Votre worksheet de données étant actif, executez le script suivant dans le script window:
for (i=2; i<=wks.ncols; i++) { limit col($(i)); get resultat_a -e fin; resultat_a[fin+1]=limit.imax; resultat_b[fin+1]=limit.ymax; };