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
 Importing Single ASCII (Hour Format)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

delfindelfin

7 Posts

Posted - 08/27/2019 :  7:22:13 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello, I am new in Origin .. I am making a datalogging to monitor barometric pressure, humidity and temperature .. I have a Real Time Clock in my electronic data acquisition system ..

So, the way I am saving my data is:
Date Time Pressure Temperature_1 Humidity Temperature_2
27/8/2019 17:28:37 792.51 27.59 87.80 27.20

So, when I import the ASCII file, I obtain the next:


I don't understand how Origin makes the conversion for the time.. Something like this: 17:28:37 is transformed into 0.72821

I think what it is doing is rule of three, considering that 86400 is 1 and 62917 is 0.728206 .. And then is rounding 06 to 1 .. But just to be sure, do my first post and hear suggestions, still I am going to ask it .. Thanks

Edited by - delfindelfin on 08/27/2019 7:26:01 PM

Echo_Chu

China
Posts

Posted - 08/28/2019 :  01:34:19 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I tried to copy your data to a txt file and then import it to Origin 2019b. There won't be any problem.


Could you let me know what version of Origin your are running?

However, you should be able to manually to update the column format to display hour format by steps below
1. Double click column B to open the Column Property dialog
2. Change "Format" = "Time" and "Display" = "HH:mm"

Thanks, Echo
OriginLab Technical Service
Go to Top of Page

nick_n

Finland
125 Posts

Posted - 08/28/2019 :  01:37:34 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,
Looks like your col(B) contains Julian time format.
Slelect col(B) -> right click -> Proprties... -> Format: Time
Display: HH.mm.ss
Regards,

Nikolay
Go to Top of Page

delfindelfin

7 Posts

Posted - 08/28/2019 :  07:12:35 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by Echo_Chu


Could you let me know what version of Origin your are running?



I am using OriginPro 8, also, I am importing 17:28:37, not 17:28

Edited by - delfindelfin on 08/28/2019 09:18:47 AM
Go to Top of Page

delfindelfin

7 Posts

Posted - 08/28/2019 :  12:57:24 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by nick_n

Hi,
Looks like your col(B) contains Julian time format.
Slelect col(B) -> right click -> Proprties... -> Format: Time
Display: HH.mm.ss
Regards,

Nikolay


But, then, how do I go back to Julian Time Format?


How do I also include the date? I mean, 27/8/2019 17:28:37 as a whole Julian Time Format

Edited by - delfindelfin on 08/28/2019 1:17:02 PM
Go to Top of Page

delfindelfin

7 Posts

Posted - 08/28/2019 :  2:20:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Also, do you have any suggestions of how to process and plot the gathered data?

Edited by - delfindelfin on 08/28/2019 2:21:11 PM
Go to Top of Page

YimingChen

1691 Posts

Posted - 08/28/2019 :  2:24:59 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
In the worksheet below:
col(A) -> Format: Date, Display: Custom Display - dd'/'MM'/'yyyy
col(B) -> Format: Time, Display: HH:mm:ss
col(C) -> Format: Date, Display: 8/29/2019 HH:mm:ss
Simply adding col(A) and col(B) will get the full date and time. If you want to check the Julian Date numeric value, you can change the format of col(C) to numeric.



James

Edited by - YimingChen on 08/28/2019 2:26:02 PM
Go to Top of Page

YimingChen

1691 Posts

Posted - 08/28/2019 :  3:15:05 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You want to plot three curves into one graph? If so, please refer to this page regading 3Ys graph.
https://www.originlab.com/doc/Tutorials/3Y-Y-YY-Graph



quote:
Originally posted by delfindelfin

Also, do you have any suggestions of how to process and plot the gathered data?



Edited by - YimingChen on 08/28/2019 3:15:48 PM
Go to Top of Page

delfindelfin

7 Posts

Posted - 08/29/2019 :  10:57:51 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
is it possible to do scripts with Origin? .. I would like to integrate it with a linux shell script
Go to Top of Page

YimingChen

1691 Posts

Posted - 08/30/2019 :  2:56:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You can run script in Origin. But Origin is windows based software that can't be run under Linux.

James

quote:
Originally posted by delfindelfin

is it possible to do scripts with Origin? .. I would like to integrate it with a linux shell script

Go to Top of Page

delfindelfin

7 Posts

Posted - 08/30/2019 :  7:10:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by YimingChen

You can run script in Origin. But Origin is windows based software that can't be run under Linux.

James



Oh, yes you are right .. I got confused since I was using Origin in Windows in a Virtual Machine that was running in Ubuntu .. So, how do I learn to do scripts with Origin?

Edited by - delfindelfin on 08/30/2019 7:11:42 PM
Go to Top of Page

delfindelfin

7 Posts

Posted - 08/31/2019 :  6:54:59 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Also .. I noticed that atomesphere variables are periodic .. For example, the next graph shows the the variation of barometric pressure ..


Is there an option in Origin that allows you to see the frequency domain of these oscillations? Is it recommended? How do I apply FFT to the data?
Go to Top of Page

nick_n

Finland
125 Posts

Posted - 09/01/2019 :  2:16:50 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Menu: Analysis\Signal processing\FFT.
Regards,

Nikolay
Go to Top of Page

YimingChen

1691 Posts

Posted - 09/03/2019 :  08:45:20 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
For Labtalk programming, please refer to this page
https://www.originlab.com/doc/LabTalk

We also have Origin C, please refer to this page:
https://www.originlab.com/doc/OriginC

Thanks,
Yiming

quote:
Originally posted by delfindelfin

quote:
Originally posted by YimingChen

You can run script in Origin. But Origin is windows based software that can't be run under Linux.

James



Oh, yes you are right .. I got confused since I was using Origin in Windows in a Virtual Machine that was running in Ubuntu .. So, how do I learn to do scripts with Origin?

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