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
 Completely buggy "Calculate values" in worksheets		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

a_h

Austria
8 Posts
Posted - 07/26/2022 :  04:50:30 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 9.4.2.380
Operating System: Win10

Hi,

we are using Origin for more than 10 years now and since many, many years and several different Origin versions we have consistent issues with the "calculate values" function that we use often to calculate values for columns using data from other columns. For us that's a very important function and I'm regularly suprised that it sometimes works and then the same equation transfered to a different work sheet suddenly results in really strange and obviously wrong results.

Nothing that I do fixes or persuades Origin to calculate correct results.

When that happens more strange things appear like A(1) gives different results than using A1.

I attach a few figures with obviously wrong examples:

dFe and dAl columns shall contain the difference between the values of increasing lines of columns Fe and Al. As one can see Fe and Al change, but not a single value of dFe and dAl is correct.

The 2nd image (errors_2) is even worse: in column B (mileage) the first line should give +1, instead its the fractional value -0.01429.

That's a sort of not obviously wrong results which might go unnoticed.

Today I lost my nerves about this and I had that too many times today and I kindly ask to fix this - or let me know what I'm doing wrong as I cannot find it out myself.

Thank you!
Edited by - a_h on 07/26/2022 04:56:42 AM

a_h

Austria
8 Posts
Posted - 07/26/2022 :  04:55:32 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
While I uploaded the images, they won't show up in my post.



So here are the links:

https://sde.v2c2.at/public/4079b0

https://sde.v2c2.at/public/68830a
Go to Top of Page

a_h

Austria
8 Posts
Posted - 07/26/2022 :  05:02:26 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Also I need to clearly mention that this does not always happen.

For the posted cases, I use the same simple equations in other work books of the same project file and there it works.

Then I copy the equation to another workbook and there it stops working and calulates garbage. When that happens, some of the other equations in the previously working workbooks keep working, but others start to calculate wrong values also, e.g. A(i)-A(1) results suddenly in -1 for line 1 etc.
Go to Top of Page

minimax

355 Posts
Posted - 07/26/2022 :  05:08:32 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You should use square brackets [] for cell access, i.e.

A-A[1]+1

i==1?0:G[i]-G[i-1]


Go to Top of Page

a_h

Austria
8 Posts
Posted - 07/26/2022 :  08:26:57 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Excellent!!! Thank you!!!

So I was doing it wrong then for years!

Why is it at all possible to use wrong notation?

This is strongly misleading as it works many times (until Origin suddenly decides to no longer calculate correctly).

No warning? No error?
Edited by - a_h on 07/26/2022 08:29:38 AM
Go to Top of Page

snowli

USA
1412 Posts
Posted - 07/26/2022 :  09:28:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Suppose B is Y column and A is X.
B(1) is used to do interpolation to get B value where x=1.
B1 & B[1] means first cell in column B.

E.g.



https://www.originlab.com/doc/LabTalk/guide/Interpolation
Thanks, Snow
Go to Top of Page

a_h

Austria
8 Posts
Posted - 07/26/2022 :  10:24:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
And learned something new again - awesome!!

Many thanks!!

I should have asked much, much earlier!
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