With CAP 5.0, data can be imported directly from an Excel spreadsheet as a native Excel file (.xls), or as a Comma-separated value (.csv) or text (.txt) file - see Preparing large data sets, and Import from Excel for further details.
|1.||Start CAP and open your data file from the File menu. The default file type is .csv; use the drop-down menu to select either .xls or .txt if required.|
|2.||The data will now open in the Raw Data window. CAP will alert you if there are any problems - such as rows or columns that sum to zero - which might cause the calculations to malfunction. Sometimes it will require you to take some action, such as replacing a cell's contents, otherwise it will make the required changes automatically. CAP will only make these changes to the Working Data grid; the Raw Data will always contain the complete original data array. The stored data file will not be altered unless you use Save or Save As to save the Working Data over the existing data file. |
The alert screen is shown below. When you press Continue, the data will automatically be transferred to the Working Data tab.
|3.||If necessary, edit the Raw Data grid to correct any problems highlighted during the file opening.|
|4.||On the Working Data tab, undertake any transformations or relativisations you require. Note that any changes undertaken on the working data will not change the raw data. Once an adjustment has been made, remember to click on the Submit button to create adjusted data sets for analysis.|
|5.||Select a method from the menu toolbar, choose the setup options and run the analysis. Use the tabbed windows to examine the output. All aspects of the charts and plots can be altered using the buttons on the toolbar above the chart (shown below). For more instructions on editing charts, see 'Printing and saving results'.|
|6.||Use File: Print or the Printer button on the toolbar to print the charts, and Edit: Copy or the Copy button to copy it to the clipboard for pasting into another application.|
|7. ||Use the Save button on the toolbar to save the chart as an image file for use in another application, or as a TeeChart Pro (*.tee) file. See exporting charts for further details.|
For more information and a video demonstration see the Help: Guides: Data In.