![]() By default, a sheet has 128 elements, so the expression c0 = index()/127 makes a column with equally spaced values between 0 and 1. ![]() It is useful for making "dummy" x columns. index() is a function that returns 0 for the first row, 1 for the second row, etc.If you refer to a column that doesn't yet exist ( e.g., c3 in a sheet that has only 3 columns), it will be created automatically.This is not a bug but a feature! It allows you to enter a formula once and apply it to several columns by selecting them in turn. For purposes of the calculation, this is now column 0, and the column to its immediate right is column 1. Notice that this changes the number of the column at the top, making it 0. Let's say you have selected column 1 (by clicking at the top of the column). If a complete data column is selected before the command is run, this will change the definition of column 0.Press command-F or choose Formula Entry fromthe Window menu to bring the Formula Entry window to the front.Click in the data sheet to make sure that only one data cell is selected (I'll explain why below).Let's say that you have values for x in the leftmost column (which is numbered zero, and called c0) and values for y in the column immediately to its right (column 1, or c1). For example, you might need to compute the sine of an angle, or the product of two values, row by row. Often you would like to calculate a new column of data based on one or more data columns already in a data sheet. Note that you can save a sheet from a version 5/ notebook in version 4 form for import. Version 3.5 can handle Excel98/2000 formats, but older versions need a version 3 or version 4 format. More recent versions of Kaleidagraph can handle more Excel formats. You mayspecify whether to import the first line of data as column titles, how manylines at the top of the file to skip, whether the data are delimited with tabs(Macintosh standard), spaces (popular on the PC), commas, or in some otherfashion.ĭata Import from an Excel File Use the Import Data command to access the Excel file. After you have selectedthe file, a dialog box appears with options for parsing the data. Use the Open command to access the text file. command (command E), paste the data, and click the save button. Save the data in a text file and proceed with thefollowing, instead.To save the text file, issue the Edit Text. If the data are not tab-delimited,this method does not work. If the data exist in some other program, copy to the clipboard, switch toKaleidagraph, select the upper left corner of the region of a data sheet intowhich you wish to place the data, and paste. Double click on the column name to edit column headings.Enter advances the cursor to the next cell.Return advances the cursor down the column.Type your data in columns noting the following points: You may type data directly into a data sheet or import data from the clipboard,from a text file, or from an Excel data sheet. This copies needed resources to your local drive. Be sure to launch from the Network Application Launcher (NAL), which is at Z:PUBLICNAL.EXE.This will make sure that all of KATO's drives map properly on your system. If you're running Windows98, download the Novell 32-bit client software from Novell's website.Running Kaleidagraph from a dorm PC?You need to take the following steps. Kaleidagraph offers a variety of graph styles, the most useful of which are Line (for xy plots), Double Y (for xy plots with two y axis scales), and Polar. Data can be linked to graphs so that graphs are automatically updated when the data sheet is changed. Data are entered in a tabular sheet which can easily be edited. Kaleidagraph is an easy-to-use if somewhat limited graphics program that runs on both Macintoshes and PCs under Windows. Click on a feature of the graph, or the text links beneath it, to jump to the instructions for that feature. To learn how to make a graph such as the one shown above, follow the discussion below the graph. Running from a PC? Be sure to use the Novell Application Launcher.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |