×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Data logging in Excel?

Data logging in Excel?

Data logging in Excel?

(OP)
My functionality in Excel is limited, however Iam currently looking at options for recording data in my plant. I can get real time information to Excel, I just dont know if I can use Excel to histrically save this information into retrievable files?

RE: Data logging in Excel?

lrob:

Once the data has been imported into Excel, would you not just save the workbook in native Excel format (*.xls)? Other options are text (comma or tab delimited), etc....

RE: Data logging in Excel?

I don't understand the question.

I've used excel for numerous hydrology studies, which is data intensive.  A primary consideration is the limit in the number or rows for a worksheet (65536 rows for Excel2002), which you need to compare to the number of data points you will be dumping to the spreadsheet.

For example, if you were to collect a data reading every second you would only be able to accomodate 18.2 hours of data per worksheet.

Also, Excel is probably more of a memory hog than just dumping data to an ASCII text file.

Good luck!

RE: Data logging in Excel?

(OP)
Thanks for all the response. I do not know how to create and dump data into an ASCII file. Can I bring the data into Excel and dump it from there on an interval? Would I be better off using a different program?

RE: Data logging in Excel?

lrob:

Need more details on your application to assist.

By what means is data transferred to PC- serial port, etc?

How do you currently get the real time data into Excel?

What is the format of the data in terms of charaters, bytes, termination characters, etc?



RE: Data logging in Excel?

Check with the data logger manufacturer, many provide software support.  FOr example, there's a program called BoxCar that works with HOBO data loggers...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close