1 / 7

Exporting Data from the Analog Discovery to Excel

Exporting Data from the Analog Discovery to Excel. By David Fritz and Ellen Robertson.

pravat
Download Presentation

Exporting Data from the Analog Discovery to Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exporting Data from the Analog Discovery to Excel By David Fritz and Ellen Robertson Financial support to develop this tutorial was provided by the Bradley Department of Electrical and Computer Engineering. Virginia Tech and the National Science Foundation [Award # 0817102, Lab-in-a-Box: Development of Materials to Support Independent Experimentation on Concepts from Circuits and Electronics]

  2. Save DSO Data After you have made measurements using the Digilent Analog Discovery, you can save the data as a .txt file using the option File/Export. A pop-up window will open to allow you to name the text file and save it in a folder that you specify. Make sure that the Type is “Tab delineated Values”. The default folder is Desktop. D. Fritz and E. Robertson

  3. Saving Measured Values You can export the values of the measurements that you collected on your signals by selecting Main Measurements at the Source. A list of the channel number (C1 or C2), the signal parameters (Name) and each value will be displayed in the Data spreadsheet on the right-side of the pop-up window. Select any one of the types of files to be written. Tab Delimited Values is a reliable file format to read into Excel. D. Fritz and E. Robertson

  4. Open the .txt file in Excel • Launch Excel. • Open the .txt file using File/Open. • Since the file is not in the expected Excel format, you have to specify how the data will be read into Excel. Make sure All Files is chosen for the File Type or the text file will not be visible. D. Fritz and E. Robertson

  5. Formatting .txt File Select Delimited, which should be the default when the first pop-up window opens. Then click Next. D. Fritz and E. Robertson

  6. The Delimiters selected must include Tab, but can also include Space if you want to have the TIME STEP data in separate columns. Comma must be used when opening a .csv file. Click Finish as there is nothing in the third pop-up window that must be changed. D. Fritz and E. Robertson

  7. You will have the voltage measurements as a function of time for Channel 1 and 2. You can use this data to complete your lab reports rather than read data using the cursors with the scope program. D. Fritz and E. Robertson

More Related