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
 Origin Forum
 Importing Single ASCII (Hour Format)

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
delfindelfin Posted - 08/27/2019 : 7:22:13 PM
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
13   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 09/03/2019 : 08:45:20 AM
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?

nick_n Posted - 09/01/2019 : 2:16:50 PM
Hi,

Menu: Analysis\Signal processing\FFT.
Regards,

Nikolay
delfindelfin Posted - 08/31/2019 : 6:54:59 PM
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?
delfindelfin Posted - 08/30/2019 : 7:10:15 PM
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?
YimingChen Posted - 08/30/2019 : 2:56:15 PM
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

delfindelfin Posted - 08/29/2019 : 10:57:51 PM
is it possible to do scripts with Origin? .. I would like to integrate it with a linux shell script
YimingChen Posted - 08/28/2019 : 3:15:05 PM
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?


YimingChen Posted - 08/28/2019 : 2:24:59 PM
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
delfindelfin Posted - 08/28/2019 : 2:20:26 PM
Also, do you have any suggestions of how to process and plot the gathered data?
delfindelfin Posted - 08/28/2019 : 12:57:24 PM
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
delfindelfin Posted - 08/28/2019 : 07:12:35 AM
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
nick_n Posted - 08/28/2019 : 01:37:34 AM
Hi,
Looks like your col(B) contains Julian time format.
Slelect col(B) -> right click -> Proprties... -> Format: Time
Display: HH.mm.ss
Regards,

Nikolay
Echo_Chu Posted - 08/28/2019 : 01:34:19 AM
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

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