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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Subtracting column 1 with multiple columns
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

zango24

India
Posts

Posted - 09/20/2011 :  07:45:35 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8.1 SR3
Operating System: Win7

Hello,
I have measured an effect of a ligand over time and recorded change in fluorescence. This gave me x value of "time", and y value of "fluorescence" from multiple cells. I have also background measurement. Now I want to subtract the background values which is in column B (y axis) with the cellular values which are from column C to column L (continuous).

I can do it with the set-column value e.g. Col(C)= col(C)-col(B). Then for next one: col(D)=col(D)-col(B) and so on. But, I have many cells. Its a bit boring work to subtract each column with the said column. Therefore, I am looking for any formula or script which can do this job for me so that I can invest time in analysing the data.

Thanks in advance.
Zan

Hideo Fujii

USA
1582 Posts

Posted - 09/21/2011 :  3:17:44 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Zan,

The following one-line script can do what you wrote:

  for(ii=3;ii<=wks.ncols;ii++) wcol(ii)=wcol(ii)-col(2);

--Hideo Fujii
OriginLab
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000