CHEM%20140L%20Session%2010

CHEM%20140L%20Session%2010 - Session 10 Exchanging Data...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
10-1 Session 10 Exchanging Data Topics In this session the following spreadsheet concepts will be explored: 1. Sharing Data Between Mathcad and Excel Copying and Pasting. Mathcad Data Table 2. Importing Data from Other Applications Importing into a Mathcad Data Table. Mathcad File Input Component. Mathcad Data Import Wizard. READPRN() Function 3. Exporting Data to Other Applications Mathcad File Output Component. WRITEPRN() Function. Exporting Data from Excel. The ability to export and import data from a variety of software applications is a powerful feature. This allows the scientist to use the best features of the program. For example, an instrument may use a specific type of software to collect the data, but we may wish to use Mathcad’s advanced mathematical capabilities to analyse the data. Therefore, we require a method for importing experimental data into Mathcad or Excel. In this session, we will explore how data can be exported and imported with Mathcad and Excel.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CHEM 140L Session 10 - Exchanging Data 10-2 Sharing Data Between Mathcad and Excel = Copying and Pasting The simplest way to exchange information between Excel and Mathcad is copying the values from one program to the Windows clipboard, then pasting the values from the clipboard into the other program. The technique of data exchange by copying and pasting is a one-time operation. The data is not automatically updated if there is a change in the data. = Copying Excel Cell Values into a Mathcad Array The procedure for copying Excel cell values and pasting them into Mathcad as an array is as follows: 1. In Excel, select the cells containing the values to be copied. 2. In Excel, copy the selection using the Copy option from the Edit menu or by using the keyboard shortcut [Ctrl C] . The cell values will be copied to the Windows clipboard. 3. In Mathcad, begin by defining a new array by entering the array name and typing a colon [:] to enter the assignment operator ( := ). A placeholder will be displayed to the right of the assignment operator.
Background image of page 2
CHEM 140L Session 10 - Exchanging Data 10-3 4. Click on the placeholder and paste the values from the clipboard. To paste the values, use the Paste option from the Edit menu in Mathcad or use the keyboard shortcut [Ctrl V] . The data is entered into a single column array. = Copying Mathcad Array Values into Excel Cell Values The procedure for copying Mathcad array values and pasting them into Excel cell values is as follows: 1. In Mathcad, select the array of values to be copied. Note: Mathcad can display arrays either as a matrix or as a table. If you want to select only part of an array, the array must be displayed as a table. To change the display, double-click on the array and select the desired matrix display style on the Display Options tab from the Result Format dialog box.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CHEM 140L Session 10 - Exchanging Data 10-4 2. Use the Copy option from Mathcad’s Edit menu or the keyboard shortcut [Ctrl C] to copy the selected array values to the Windows clipboard.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/11/2010 for the course CHEM 1101 taught by Professor Leroy during the Spring '10 term at University of Toronto- Toronto.

Page1 / 28

CHEM%20140L%20Session%2010 - Session 10 Exchanging Data...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online