The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Row and Column analysis

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

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
bafaneh Posted - 09/07/2011 : 5:11:08 PM
8.5.1
Windows 7

Hi,

I use the following loop to create a column for my analysis, but the numbers that reference the row and columns are specific to one book. I need to batch process my data, so I would like to know if there is a way to reference the beginning and end column values, (i.e. colstart, colend, or something like that).

for (ii=1; ii<=25; ii++)
{
cell(ii,25) = (cell(ii+1,23) - cell(ii,23))/(cell(ii+1,33) - cell(ii,33));
};

Thanks,
Basheer
1   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 09/08/2011 : 2:38:59 PM
To process all columns individually regardless of how many columns you have, then use:

for (ii = 1 ; ii <= wks.ncols ; ii++)

If you do some analysis that accepts a range of multiple columns then you can use 'end' as in:

range raAll = !(1:end);
stats raAll;
stats.mean =;

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000