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
 Calculating formula
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Kovix

Yugoslavia
2 Posts

Posted - 12/28/2022 :  1:12:47 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 8
Operating System: Windows 10

Hello all,

I have really big struggling using OriginPro even with the tutorials. University gave us this version of OriginLab, it looks like on newer one its easier to find what u are looking for.

I have this data



Can you resolve this formula for me in OriginPro? That would mean the world to me. Or at least point me how to do it myself, can t find any tutorials to do this and I need this for my psychics' bachelor's degree project.

P.S I'm not very good at PC, had a good time to learn excel haha

snowli

USA
1454 Posts

Posted - 12/28/2022 :  2:30:43 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Yes, Origin 8 is very old and u can't use Column Short name directly.

Here is an example of how to do it in old version.

Highlight column G(Y).
Ctrl+Q or choose Column: Set Column Values.

Enter formula e.g.
ln(col(E)/col(C))/(col(J)*col(F))

In newer versions, u should be able to see an F(x) cell in the column so u can directly type
ln(E/C)/(J*F)

Thanks, Snow
Go to Top of Page

Kovix

Yugoslavia
2 Posts

Posted - 12/28/2022 :  4:18:16 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Yes, Origin 8 is very old and u can't use Column Short name directly.

Here is an example of how to do it in old version.

Highlight column G(Y).
Ctrl+Q or choose Column: Set Column Values.

Enter formula e.g.
ln(col(E)/col(C))/(col(J)*col(F))

In newer versions, u should be able to see an F(x) cell in the column so u can directly type
ln(E/C)/(J*F)

Thanks, Snow



Thank you so much! Ctrl+Q what is was what i looking for! Best wishes!

kolee
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