ThomasNet News Logo
Sign Up | Log In | ThomasNet Home | Promote Your Business

How to View dataTaker Data Files in Excel

Print | 
Email |  Comment   Share  

(Archive News Story - Products mentioned in this Archive News Story may or may not be available from the manufacturer.)

CAS DataLoggers
12628 Chillicothe Rd., Unit J
Chesterland, OH, 44026
USA



Press release date: April 5, 2012

Using the Bestselling Data Logging Solutions from dataTaker

CHESTERLAND OH - To download data from dataTaker dataloggers for viewing in Excel, first connect to the dEX web server in the dataTaker by typing the IP address (as given on the data logger's display) into your browser. Click on the 'Monitor the Logger' button on the homepage, which brings up the main monitor window. Now click on the 'Retrieve Data' button on the left-hand side.

Now you'll see 3 buttons giving you the option to retrieve all the data, data in a certain range, or new data acquired since the last download. Click on the option you want, specifying any start/end range. You have two ways to retrieve the data: either in .DBD or .CSV format. .DBD format is not human-readable, so many users prefer .CSV, which arranges the data in convenient text format. After choosing your format, click the 'Retrieve Now' button. You'll be prompted to choose your save destination, with the default given as the logger's serial number_CONFIG_year/month/day/time.csv (or .dbd).

Now the data logger will download the data onto your desktop or preferred save location. First open Excel and then open the data file. The timestamp column will be given in its own format because Excel doesn't have a native format, and many users will want to reformat it to make it readable. To do this, click on the timestamp column to select it, then right-click and select 'Format', then pick 'Custom Format'. Now select "mo/day/year hh:mm" and add ":ss_0" for seconds or fractions. The final custom format should appear as "m/d/yyyy hh:mm:ss_0". Click 'Ok' and timestamp will now appear as the right format. Column B gives the time zone, while Column C is where the data begins, arranged across in columns.

If your data logger is setup with multiple schedules, all the data will go into Column A first, i.e. it will present all the data for Schedule A first, then all data for Schedule B directly after it, etc. Often, users will want to view this data in chronological order, and this is easily performed by clicking the 'Select all' arrow box just to the left of Column A, then clicking on the 'Data' tab, then the 'Sort' button. Now in the 'Sort by' dropdown, choose 'Column A'. The data will now be listed in time order.

For more information on intelligent datalogging solutions from bestselling manufacturer dataTaker, which monitor a wide range of parameters including temperature, voltage/current and more, or to find the ideal solution for your application-specific needs, contact a CAS Data Logger Applications Specialist at (800) 956-4437 or visit the website at www.DataLoggerInc.com.

Contact Information:
CAS DataLoggers, Inc.
12628 Chillicothe Road
Chesterland, Ohio 44026
(440) 729-2570
(800) 956-4437
sales@dataloggerinc.com
http://www.dataloggerinc.com

Print | 
Email |  Comment   Share  
Contacts: View detailed contact information.


 

Post a comment about this story

Name:
E-mail:
(your e-mail address will not be posted)
Comment title:
Comment:
To submit comment, enter the security code shown below and press 'Post Comment'.
 



 See related product stories
More .....
 See more product news in:
Test and Measuring Instruments
 More New Product News from this company:
Portable UHF RFID Readers track product temperature.
Output Module for Automotive Applications.
UHF RFID Temp Tags help maintain cold chain.
Telemetry Receiver System fosters wireless data logging.
DAQ Processor Board offers real-time computing.
More ....
| Featured Manufacturing Jobs
 Other News from this company:
Monitoring and Alarming for Medical Refrigerators and Incubators
Peace of Mind for Less Than a Dollar a Day!
Pharma Cold Chain Transparency Achieved with UHF RFID Temp Tags
Automatically Send Data to an Access Database Using a dataTaker
CAS DataLoggers Introduces RFID Cold Chain Solutions
More ....
 Tools for you
Watch Company 
View Company Profile
Company web site
More news from this company
E-mail this story to a friend
Save Story
Search for suppliers of
Data Loggers & Data Logging Equipment
Join the forum discussion at:
Wired In


Home  |  My ThomasNet News®  |  Industry Market Trends®  |  Submit Release  |  Advertise  |  Contact News  |  About Us
Brought to you by Thomasnet.com        Browse ThomasNet Directory

Copyright © 2014 Thomas Publishing Company. All Rights Reserved.
Terms of Use - Privacy Policy



Error close

Please enter a valid email address