@DATABASE Tutorial.guide @INDEX INDEXNODE @WORDWRAP @NODE MAIN "TurboCalc by Michael Friedrich" TurboCalc - copyright Michael Friedrich. @{"Main Table of Contents" link TurboCalc.guide/MAIN} of all files @{"Full Index" link Index.guide/MAIN} of all files @{b}Tutorial@{ub} This chapter will list up a few practical examples of the possibilities and features of TurboCalc and makes you familiar with them. Step by step an example sheet will be created and you will learn about input, formatting, formula creation and further work steps. It will be useful to sit in front of your Amiga while reading this chapter, so that you can carry out every step directly - by using this method you will have the best possible success with your introductory work. @{b}Annotation:@{ub} In this Tutorial most of the functions are only @{b}"touched on"@{ub} and only a few capabilities are really used. You will find a complete description of each menu item in the menu survey or in the corresponding chapters (input, formula, diagrams...). Additionally, you will find every work step as a TurboCalc-file in the "@{b}tutorial"@{ub} directory@{b} @{ub}on the diskette. So it is possible to leave out different steps and to try a few functions directly, although it is not recommended. (In this case, loading is done just like the below mentioned saving.) Our example sheet, which shall be created as follows, deals with a surplus calculation. By using this example, we have a good possibility to explain some of the most frequently appearing procedures. To give you a rough survey, which solution is expected and what you can do with a minimum effort, please have a look at the sheet shown below: Now, it is your turn: Please sit down in front of your computer and start TurboCalc. @{b}Annotation:@{ub} Here, it should not be described again how to start TurboCalc. These details you will surely find in your Amiga manual. After a short loading time, the TurboCalc screen should appear with an empty sheet (named "Sheet 1"). @{"TurboCalc-Sheets" link TurboCalcSheets} @{"Selecting a Cell" link SelectingaCell} @{"Entering a Formula" link EnteringaFormula} @{"Selecting Ranges" link SelectingRanges} @{"Filling a Range" link FillingaRange} @{"Generating a Series" link GeneratingaSeries} @{"Saving your Work" link SavingyourWork} @{"Editing" link Editing} @{"Absolute Cell References" link AbsoluteCellReferences} @{"Copying a block" link Copyingablock} @{"Functions" link Functions} @{"Formatting" link Formatting} @{"Title Freezing" link TitleFreezing} @{"Creating Charts" link CreatingCharts} @{"Settings" link Settings} @ENDNODE @NODE TurboCalcSheets "TurboCalc-Sheets" @{b}TurboCalc-Sheets@{ub} Before you definitely start working, a short introduction to the menus of TurboCalc and a brief explanation of some expressions is given. This might be a little "exhausting", but will be useful later on for the explanation of sheets and the practical work with them. The respective examples will follow in the next paragraph. On top of the screen you see the menu bar. Here you can "@{b}choose@{ub}" a menu item with a click on the right mouse button (to perform this, press down the mouse button and (while pressing down the button) move your mousepointer to the desired menu item and release the button there.) This way you can start all operations of TurboCalc. A little bit below you will find the "@{b}Toolbar"@{ub}, which represents an other possibility to start operations. To start them, simply move the mouse pointer to the desired symbol, press down the left mouse button and release it again (We will need this operation many times from now on and so we will call it "clicking" shortly). Most of the symbols should be self-explanatory. If not, you will find a short explanation of every symbol in the chapter "@{b}Toolbar"@{ub}. The window-title is placed between screenbar and toolbar. Here you can also find the sheetname, the window gadgets (the closing symbol on the left side to close the sheet, as well as the two gadgets on the right side, which you need to place windows "in front" or into the "background") and the following two ranges: @{b}Annotation:@{ub} "Gadget" is an expression of the Amiga world and represents, in most cases, a small square area, which activates a certain operation if you click within this area. @{b}Cell Status:@{ub} This short text field on the left shows the current cursor position, as well as the size of a selected range. @{b}Input Field@{ub}: In the range right of it the cell contents will be entered, shown and edited. @{b}Row- and column title@{ub}: Here you can see the structure of sheets in rows and columns. The rows are numbered beginning with one, the rows receive a letter, e.g. A, B, ... Z, AA, AB, ... . A cell can be located precisely by listing up its row- and column position. TurboCalc expresses this as follows: The first position has got the column letter, which is followed by the row number, e.g. A1 or F7. Such a definition is called "@{b}Cell Reference"@{ub}. @{b}Cell cursor@{ub}: This is the position, on which the next input or formatting should take place. It is displayed within the field @{b}"Cell Status"@{ub} and you will find a colored frame around the respective cell. In a new sheet, the cursor (which is the jargon name of the frame) is located in cell A1 (on the top left). After these explanatory words, let's go back to the example sheet. @ENDNODE @NODE SelectingaCell "Selecting a Cell" @{b}Selecting a Cell@{ub} The first thing to do is to enter the headline. The first text shall be written in cell B4. Therefore the cell cursor, which rests on cell A1, must be moved. To do this, please use the <@{b}Cursor Block@{ub}> and press it <@{b}Down@{ub}> three times and one time to the @{b}@{ub}. With every keystroke the cursor should jump into the appropriate direction and the contents of the field @{b}@{ub} should change accordingly.After this procedure @{b}"B4"@{ub} should be displayed.. @{b}Mouse: @{ub}If you prefer to work with the mouse, move the mouse pointer to cell B4 and click here. Now enter the expression @{b}@{ub}. You can read the text in the @{b}"input field"@{ub} on the top, as well as directly in the cell. If you made a slip you can delete the last letter with @{b}@{ub} (the key above @{b})@{ub} and enter again. If you have entered the word correctly, press@{b} @{ub}. The cursor jumps one row down to cell B5. Move the cursor with the mouse or keyboard to cell C4 (one up and right) and enter @{b}"Expenditures"@{ub}. Do not press @{b} @{ub}now! Try @{b} @{ub}or @{b} @{ub}(that is the key on the left side of @{b})@{ub}. The input will be ended and the cursor moves promptly to cell D4, where the next text should be entered. Please enter now, side by side "@{b}Surplus@{ub}", "@{B}VAT@{UB}" (i.e. Value added tax) and "@{b}Profit@{ub}". You should receive the following sheet: We go on with the input of the date in column A. To increase the effect of learning, only the first two months are entered. The remaining months will be calculated by TurboCalc automatically. At first just move the cell cursor to cell A5 or place the cursor by mouse. Then enter @{b}"Jan 94"@{ub} and press @{b}@{ub}. Now, please move the cell cursor again up and have a look at your just entered text: The cell contents is nearly unchanged (if you have entered "@{b}jan@{ub}" in lower case, it will automatically be changed in @{b}"Jan"@{ub}), but in the "i@{b}nput field@{ub}" you will see "@{b}01.01.1994@{ub}": The entered text was not a "@{b}normal@{ub}" text as before but a date. This will be saved as day, month and year but can be displayed in different ways. Because it had not been entered with a particular day, it is assumed as 1 and not displayed. To enter a date in TurboCalc is as simple as the input of text and it is possible to use (nearly) all forms of dates (e.g. 30.09.93, 30 Sep 94 or 30/9, 30 Sep...). A survey can be found in chapter "@{b}The Input"@{ub}. Please enter "@{b}Feb 94@{ub}"in cell A6 and fill up the cells B5, C5, B6 and C6 with any number (entered like texts): @ENDNODE @NODE EnteringaFormula "Entering a Formula" @{b}Entering a Formula@{ub} Let's leave the input of text for a while and concentrate on TurboCalc's calculation capabilities. The first formula: We would like to calculate the difference between income and expenditures. We have already entered these numbers, so the computer can work for us. Formulas generally start with an equals sign to differentiate them from normal text. After that, it follows the arithmetical expression, namely B5-C5. That results in the formula: "@{b}=B5-C5@{ub}" (without quotation marks). Please enter it in cell D5 (do not forget to locate the cursor!) and press <@{b}Return>@{ub}. If everything is entered correctly, the formula disappears from the cell and the correct result will appear at once. If you locate the cursor again on this cell, you will read the formula in the @{b}"input field"@{ub}! Now enter the second formula in E5. This shall be the value added tax of the sum of D5: "@{b}=D5*15%@{ub}". This should partly be entered with the help of the @{b}"mouse"@{ub}. Therefore press the equals sign key and then click the mouse in cell D5 - in the input field "@{b}=D5@{ub}" is displayed now. If you enter a formula (recognizable by the leading "=") followed by a mouseclick on a certain cell, TurboCalc will display the cell reference at the current input position. It is not necessary to remember the cell reference - a simple mouse click upon it is enough. @{b}Annotation:@{ub} In this example it is assumed that tax rates at 15%. If it differs in your country (or in your special application), simply change it (or just ignore the wrong tax-rate in this example, as this should not be too important). Now, please enter the rest "@{b}*15%@{ub}" and then press @{b}@{ub}. Enter the formula "@{B}D5-E5@{UB}" (with or without mouse) in cell F5. The first data line is now completed and the following picture should appear (here together with displayed formulas). Now there are 11 lines left to be created - but this is the work of TurboCalc. @ENDNODE @NODE SelectingRanges "Selecting Ranges" @{b}Selecting Ranges@{ub} To do this, a range must be marked first. A range (also called a block) is a rectangular area of cells. Most of the time this area is specified by the top left and the cell down on the right (separated by a colon), here it is: D5:F16. @{b}Using the keyboard@{ub}: Move cursor to cell D5, press the @{b}@{ub} key and hold it. Then move the cursor to cell F16 (with @{b}-key@{ub} still pressed). While moving, a colored area develops, which represents the range. If it is chosen completely, the @{b}-key@{ub} can be released. (Attention: If you move the cursor without @{b}-key@{ub}, the block marking is canceled). @{b}Selecting a Range with mouse:@{ub} Press the left mouse key on cell D5 and move the mousepointer, while holding the mouse key, to cell F16. While moving a colored range develops. The range is completely chosen when the mouse key is released. The third alternative is a mixture of the above mentioned methods: Move cursor to cell @{B}D5@{UB} (e.g. with mouse click), then move mouse pointer to cell @{B}F16@{UB}, press @{b}-key@{ub} and then make a mouse click on this cell while pressing the @{b}-key@{ub}. Now release the -key@{ub} and the mouse key (no matter in which order). However, a colored range should be seen and "@{B}F16 (3*12)@{UB}" be displayed at the "cell status". @ENDNODE @NODE FillingaRange "Filling a Range" @{b}Filling a Range@{ub} Now choose the menu item <@{b}Edit-Fill-Down@{ub}> or @{b}+@{ub}. This causes TurboCalc to fill every column of the marked range with the contents of each uppermost column. In our case the formulas are copied downwards. If you move the cursor e.g. to cell D6 you will find the formula "B6-C6" and not, as you might expected, "B5-C5" - TurboCalc has changed the cell references automatically during copying. The reason is that these references are treated as "@{b}relative cell references@{ub}", but more about this later. (To receive the image shown above, please choose from the menu @{b}Options@{ub} the item@{b} Display@{ub} and there >@{b}show Formulas instead of Values<@{ub} to display the formulas and not their results@{b};@{ub} otherwise only zero-values will appear in the respective columns). @{b}Hint:@{ub} If you have changed the options as mentioned above, do not forget to unselect this flag again. (You can use @{b}-<*>@{ub} for this purpose as well!) @ENDNODE @NODE GeneratingaSeries "Generating a Series" @{b}Generating a Series@{ub} Besides the lacking values of the income and expenditures the date column is still missing. Select it as you did before (therefore, range A5:A16). A simple filling is not possible now, as the whole range would be filled with "@{b}Jan 94@{ub}", for it is no formula. But there is a function for "@{b}filling in with calculating@{ub}" in TurboCalc as well: <@{b}Data-Create Series@{ub}>. Please select this menu item or click on the appropriate symbol of the toolbar (7th of the right, with a small@{b} @{ub}"@{b}+@{ub}"). The following requester appears: Please change, by a click on the circle in front of the appropriate text or by @{b}+@{ub}, the @{b}@{ub} to "@{b}Month@{ub}", then click on @{b}>Ok<@{ub} or press @{b}@{ub}. The increment (the number, by which the month is increased each time) was "@{b}1@{ub}" by default and therefore need not to be changed. The window disappears and the data row should now be displayed completely. Finally fill up the cells B7:C16 with numeric input at will (perhaps with <@{b}Data-CreateSeries@{ub}> or "@{b}Fill@{ub}" as an exercise) and the result should look as follows: @ENDNODE @NODE SavingyourWork "Saving your Work" @{b}Saving your Work@{ub} After a few work steps you should save your sheet, for your data will not be lost in case of a power failure or a serious mistake. For this sheet is included in the delivery range of TurboCalc, saving it to the @{b}Ram Disk@{ub} will be sufficient: Please select menu item point @{"" link Menu.guide/Save} or <@{b}Project-Save as...>@{ub} (for a new sheet both menu items do have the same effect) or click the third symbol on the left of the toolbar. After that a filerequester is opened for a file-name selection or input. From OS2.0 on, it is the standard-ASL-requester which is part of the operating system and is explained there. Here, click on @{b}"Drive@{ub}" and in the displayed list of devices on "@{b}Ram Disk@{ub}". The text cursor should be located behind "@{b}File@{ub}". Please enter a file name just as "@{b}Example.TCD@{ub}". The file tag TCD is a synonym for "@{b}TCData@{ub}" and is useful to find TurboCalc-files easier. Naturally this tag is not obligatory, take it as a suggestion for giving your files expressive names (in the loading requesters of TurboCalc normally files that end with .TCD are displayed unless you change this option) - it prevents that you lose the track too quickly). If you use OS1.3 or lower, a different requester will appear. Click on "@{B}RAM:@{UB}", and then enter your file name as explained above. A click on @{b}>Ok<@{ub} saves the sheet. After saving, the window title should change from "@{b}Sheet1@{ub}" to "@{b}Ram Disk:Example.TCD@{ub}". From now on the selection of <@{b}Save@{ub}> or the appropriate symbol of the toolbar is enough to save the sheet with the current name. If a new name is desired you should use <@{b}Save as...>@{ub}. @{b}Attention: @{ub}Files, which are stored on the Ram Disk will be lost when the computer is switched off. For our example this is intended - for your own (important) files saving on a permanent storage medium is advisable. @ENDNODE @NODE Editing "Editing" @{b}Editing@{ub} Up to now the tax rate is set to 15%, but what happens when this percentage changes ? In that case all formulas using the tax have to be changed as well. The example sheet does not cause much effort to do so, but with bigger projects you might have some problems. Therefore the formula for the calculation of the value added tax has to be modified in a way that the percentage can be changed without much effort. Enter "@{b}Percentage of V.A.T.@{ub}" in cell A19 (only as a comment) and "@{b}15%@{ub}" in C19; if the percentage changes, only cell C19 has to be adapted. Therefore the "@{b}15%@{ub}" of the formula in cell @{b}E5 is @{ub}replaced by "@{b}$C$19@{ub}" (why the dollar signs are added now, you will get to know after the change has been executed). Editing: Move the cursor to cell E5 - in the @{b}"input field"@{ub} the previously entered formula is displayed. Now press @{b}@{ub}. This is one of the most important function keys of TurboCalc, as it activates the editing mode: Now the cursor should be located at the end of the @{b}"input field"@{ub}. It can be moved with @{b}@{ub} and @{b}@{ub}, (if you press the @{b}@{ub} simultaneously, the cursor will be moved right to the beginning or ending of the line). Now, delete the 15% with @{b}@{ub} and replace it by "@{b}$C$19@{ub}" and finish the input as usual with @{b} @{ub}or @{b}@{ub}. @{b}@{ub} or @{b}@{ub} does not work now as it did before, as it only moves the text cursor within the input field. @{b}Mouse: @{ub}It is also possible to perform all steps with the mouse. Instead of @{b}@{ub} just click on the @{b}"input field"@{ub}. The cursor is located automatically on the clicked position. @{b}Summary:@{ub} TurboCalc offers two different input modes. While using the normal mode the cell cursor can be moved with the cursor keys and short texts can be entered or corrected with @{b}@{ub}. A change of existing input is not possible. If you press @{b}@{ub} or click on the @{b}"input field"@{ub} with the mouse, the old contents can be edited with @{b}, , ,@{ub} or@{b} @{ub}. To quit this mode use @{b}, @{ub}or @{b}@{ub} . After that TurboCalc switches to the normal mode again. @ENDNODE @NODE AbsoluteCellReferences "Absolute Cell References" @{b}Absolute Cell References@{ub} Now, back to the question why we entered "@{b}$C$19@{ub}" instead of "@{B}C19@{UB}". Remember the filling example; there the formula "@{b}=B5-C5@{ub}" was changed automatically into "@{b}=B6-C6@{ub}" in the next line. The new formula "=@{B}D5*$C$19@{UB}" shall also be copied down in this case, but we will need the formula "@{b}=D6*$C$19@{ub}" in the next line (and not "@{b}=D6*C20@{ub}") - "@{b}$C$19@{ub}" should not be changed through copying. This is the special task of the dollar sign. The component row or column which has a leading dollar sign is not changed during copying or filling; it is an absolute reference. In contrast to that, the instructions without dollar sign are changed with every cell shift. The contents "@{b}=B2@{ub}" in cell @{B}A1@{UB} therefore means, "take contents of the cell one left and one below A1". Copying the formula to F7 will results in "@{b}=G8@{ub}", as the cell reference is relative. @{b}Hint:@{ub} The dollar sign can also be put in front of only one component, e.g. @{b}$C5@{ub} or @{B}C$5@{UB}. In this case the component with the dollar sign is absolute, the other relative, e.g. @{b}$C5@{ub} corresponds to: "Cell in the third column, 5 lines below the current one". In most cases (e.g. the calculating within rows and columns) the normal reference (without dollar sign) should be correct - if a distinct, fixed cell (as in our example) is meant, which should be accessed from different cells the absolute reference is needed. Because you entered the absolute reference the formula can be copied down without problems. @ENDNODE @NODE Copyingablock "Copying a block" @{b}Copying a block@{ub} Select cell E5 and call the menu item @{"" link Menu.guide/Copy} or simply click on the "@{b}copy symbol@{ub}" at the tool bar (the camera). The selected range (in our case only one cell) will be buffered and can now be copied to a different place with the help of <@{b}Edit-Paste>@{ub}. Now select block @{B}E6:E16@{UB} and then call <@{b}Edit-Paste>@{ub} or click the symbol on the right of the camera. The previously copied range will now be inserted at the current place (or block) and - as it is a block - filled. @{b}Hint 1:@{ub} This is naturally not the main purpose of block copying and inserting. The main purpose is to copy cells from one place to another (also to different sheets). If no block is marked before you call @{b}@{ub}, the copied block will be inserted starting at the current cell as the top left corner. @{b}Hint 2:@{ub} Besides @{"" link Menu.guide/Copy} you will also find the menu item <@{b}Edit-Cut@{ub}>. That corresponds to @{"" link Menu.guide/Copy} with an ensuing <@{b}Edit-Clear Contents-all>@{ub} - it is very suitable to shift cell contents. @ENDNODE @NODE Functions "Functions" @{b}Functions@{ub} Now only a completion line is missing (besides the correct formatting) in which the columns are summed up. TurboCalc has got a simple function for it: Enter the formula "=sum(B5:B16)" in cell B17. This instructs TurboCalc to add up block B5:B16. @{b}Input by mouse:@{ub} This formula should be entered by mouse: Move the cell cursor to cell B17 with the help of the mouse. Then call menu item @{"" link Menu.guide/PasteFormula} or click on @{b}"f()"@{ub} in the toolbar. The following window appears: Now, take the proportional gadget at the right margin (blue rectangle), click upon it and move it down while holding the mousebutton. The text on the left promptly moves in the appropriate direction. If you are in the lowest third, the formulas should start with "@{B}S@{UB}" and the formula "@{b}sum(range;...)@{ub}" should appear. Then release the left mouse button and select the "sum"-formula with a mouse click. Now, close the window with @{b}>Ok<@{ub}. @{b}Hint:@{ub} Instead of @{b}>Ok<@{ub} you can execute a double click on the desired formula. The desired formula is taken over to the input field ("@{b}=sum()@{ub}") and the text cursor is located within the parentheses, because parameters are still missing. The parameter (in this case "@{B}B5:B16@{UB}") can be entered with the mouse as well. Simply select the appropriate block with the mouse. A look at the input field shows that the formula is correct. Now, simply press @{b}@{ub} to take over the formula. With @{b}@{ub} you might abort the input if you made a mistake. As soon as the formula is entered the sum should be displayed. The formula must then be copied to @{B}C17:F17@{UB} either with @{"" link Menu.guide/Fill} or by copying: The result should be the following screen: @ENDNODE @NODE Formatting "Formatting" @{b}Formatting@{ub} Basically the sheet is finished now, at least concerning the contents. But it does not look very professionally and clearly laid out at the moment. Use the formatting possibilities of TurboCalc to improve the appearance of your sheet: @{b}Alignment@{ub} While inspecting the headlines of the columns it is obvious that they are not placed correctly above the numbers; they are a little bit displaced. The reason for this is that texts normally begin at the left margin of the cell (left aligned) and numbers are orientated to the right (right aligned). Presumably the simplest possibility to solve this problem, is to place the texts at the right margins as well: Therefore select all texts (here block @{B}B4:F4@{UB}) first and then @{"" link Menu.guide/Alignment} ; choose @{b}>Right<@{ub} (with a click on the circle in front of it) and then @{b}>Ok<@{ub}. @{b}Or even simpler@{ub}: Click on the symbol "@{b}right aligned@{ub}" (the last one before the color values) of the toolbar. @{b}Column Width@{ub} Secondly it is obvious that the distance from "@{b}Jan 94@{ub}" to the next number is too large (and the column "@{b}Expenditures@{ub}" too small). Therefore reduce the width of column A. For this step it is possible to open a window with @{"" link Menu.guide/ColumnWidth} in which the width, as amount of characters, can be entered. @{b}But it can be done faster by mouse@{ub}: Just click with the left mouse button on the line between column @{B}A @{UB}and @{B}B @{UB}and move the mouse while keeping the mouse button pressed. A vertical line is displayed instantly, which corresponds to the column width. Move the cursor a little bit to the left until column @{B}A@{UB} has reached the optimal width. Now simply release the mouse button. @{b}Hint:@{ub} If you have set the column too small, "@{b}Jan 94@{ub}" will be printed as "@{b}###@{ub}". This indicates that the date does not fit into the column. In this case enlarge the column as mentioned above. @{b}Frame@{ub} With the frame function every cell border can receive its own frame. Select @{B}A4:F4@{UB} and then call @{"" link Menu.guide/Frame} . In the appearing window, please click in the field "@{b}bottom"@{ub} (right on the left side) on @{b}>middle<@{ub} (on the circle in front of it). Leave the rest unchanged, because your only aim is to draw a line below the row. Click on @{b}>Ok< to finish@{ub}. Do the same procedure for @{B}A17:F17@{UB} but now set the top margin on @{b}>middle<@{ub}. The sheet should appear like this: @{b}Numeric Format@{ub} In this example all values were integer by chance. If a value has got decimals, like for example 380.5, the formatting will be invalid. This can be avoided with so called numeric formats, which specify how the numbers should be displayed independent from how many digits after the decimal point really exist. Therefore select all numbers @{B}B5:F17@{UB} and @{b}@{ub}. In the appearing window you can see on the right a list of all available numeric formats. On the left you find a variety of gadgets by which the list can be moved to the beginning of the appropriate numeric type (normal numeric notation, scientific notation, percentage numbers, currencies, date- and time formats). This allows an easy finding of a special numeric format. Here are a few numeric formats which may be used in our example: 0 Only numbers in front of decimal point are displayed, the sum is rounded up. 0.00 Numbers are only shown with 2 places behind the decimal point , if necessary with (".00"). 0.000 Like "0", but 3 decimal places are separated by a specific sign, that makes sense in case of high amounts. 0.000.00 dito, but now with 2 decimal places behind the decimal point. $0 In analogy to the first 4 formats, but here the currency symbol (e.g. $) is $0,00 added. This makes big number fields (like in our example) illegible $0,000 because to many "$" only confuse. For individual values or columns $0.000,00 ,however, it is often very effective. @{b}Remark@{ub}: The separation sign for thousands, the decimal point and the currency symbol can be defined freely in TurboCalc by using @{b}@{ub}. Details about this can be found in the description of this menu item. Now confirm the desired format with a click on the entry (e.g. "@{b}0,000@{ub}") and @{b}>Ok<@{ub} (or double click). @{b}Keyboard:@{ub} This can also be executed by using the keyboard: Select the desired entry with the cursor keys and then press @{b}@{ub}. @{b}Font@{ub} To finish the layout a bigger headline is still missing. Therefore enter the title @{b}"Surplus Calculation"@{ub} in cell @{B}B1@{UB} and then call @{b}"Format-Font..."@{ub} or click upon "@{B}A@{UB}" in the toolbar. During the first call your hard disk or your diskette drive should shortly start working, because TurboCalc is searching for the available character sets. If necessary you will be asked to insert the FONTS-diskette. After that a window with two registers appears, for the character sets and to the right of it for the available sizes. Fields for @{b}"Underline"@{ub}, @{b}"Bold"@{ub} and @{b}"Italic"@{ub} will appear as well. Now select the character set, with a click on the character-set name, and afterwards select its size with a click on the desired size. The font in the example is "@{b}Courier@{ub}" and the size is @{b}18@{ub}. If you do not have OS2.0 at your disposal, you naturally can use another character set, for example "@{b}Diamond/20@{ub}". @{b}Hint:@{ub} From OS2.0 on, the font's size is freely adjustable due to the new vector fonts. If the appropriate character-set is not available it will be calculated automatically. In most cases the result looses some quality then. To do so simply enter the desired value in the text field below the size list. Now you can also select @{b}>Underline<@{ub} and @{b}>Bold<@{ub} to enforce the title effect. Afterwards click on@{b} >Ok<@{ub}. The character-set will be changed accordingly; for it is bigger now it might not be visible completely. To change that enlarge the row height and the column width accordingly. Now enter the text @{b}"for the year 1994"@{ub} in cell B2 and change the font to "Courier/13". @ENDNODE @NODE TitleFreezing "Title Freezing" @{b}Title Freezing@{ub} Another quite interesting feature of TurboCalc is the cell freezing which forms a vertical and horizontal title. This is not essential for our sheet for it only covers one screen page. But nevertheless a title is to be created in order to explain the feature. For this purpose it has to be assumed that our sheet is a bit larger (e.g. Jan 93 to Dec 95, as well as some additional columns with data). This will probably cause problems when editing the part down on the right of the sheet because neither the column title (e.g. "Profit") nor the corresponding month ("Sep 94") can be seen; so identifying the cell is made much more difficult. Here it will be an obvious choice to freeze the column with the names of the months as well as the row with the column titles; freezing them means determining them as the title. Select cell B5. This is the cell on the right of the fixed column and below the fixed rows, so the "first" cell outside the title. Now select @{b}@{ub} and a title is defined. Check this by scrolling the sheet a little. Column A as well as row 1 to 4 should always be visible so that you can always see at a glance which data a particular cell contains. If you want to undo the freezing (which is not really necessary in our case), you will have to do the following: select cell A1 and call @{b}@{ub}. @ENDNODE @NODE CreatingCharts "Creating Charts" @{b}Creating Charts@{ub} The sheet looks more professional now, but often a chart tells more than thousand words. Select the desired chart data (in our example the profits F5:F16) and @{b}@{ub} or click on the "chart"-symbol at the toolbar. In the chart window simply click . This step activates another window where you can define some parameters for the current chart type. Bypass this requester by clicking and the chart will be opened. It is now scaleable and moveable to any size and position on the screen. The appearance of the chart can also be changed with the menu items listed under "chart". The chart can be inserted as an object into the current sheet by @{b}@{ub}. You will find further information about objects in the chapter "Objects". Try this and some of the other TurboCalc functions as well - for example the database module which has not been explored up to now. For this you will find a few important notes in the chapter "Database". Feel free to "play" with the enclosed example sheets. You will probably discover some tricks and knacks. @ENDNODE @NODE Settings "Settings" @{b}Settings@{ub} As you become more familiar with TurboCalc, you will notice the diversity of available settings. Because TurboCalc will be used for a variety of purposes and completely different configurations, TurboCalc can be adjusted as necessary. The standard settings were chosen for ease of use under normal conditions, but they can be optimized by making your own special adjustments. In the following you will find some ideas for that, details can be found in the corresponding menu descriptions. @{b}Screen@{ub} Normally, TurboCalc opens its own screen which is similar in format and appearance to your workbench-screen. In case you prefer the workbench, you can move the TurboCalc window on the workbench with . But the disadvantage of this is that you cannot open a status row (see below) and that you are restricted as far as the number of colors is concerned. It is also possible to select another screen (e.g. on your graphic card) with a high resolution and an appropriate number of colors. Simply select . @{b}Font@{ub} If you are using a screen mode with a high resolution, small fonts sets can be troublesome. To avoid this simply select . This will determine the font for the menus and all (requester and message) texts. As for the contents of the sheet itself, you can select a different font by . This will be used where unless another font is explicitly chosen. It is advisable to use a non-proportional font because then cell characters have the same width and the numbers will be found directly below each other. @{b}Colors@{ub} You can also configure the colors with (or with back to the original setting). @{b}Note:@{ub} You can give each sheet its own color which will automatically be set correctly when activating the corresponding sheet window. @{b}Status Row@{ub} If you have a big screen then the ability to show a status line with current information at the base of the TurboCalc screen will be especially useful. If this option is activated in , you will be informed about the corresponding command as you move the mouse pointer on the toolbar without the need to select it. The disadvantage of this is that the room for the sheet window will be reduced. @{b}Presentation@{ub} That should be enough as far as the general appearance of TurboCalc is concerned. The appearance of every sheet window can be determined using . With this, you can show or hide the toolbar, row titles and column titles as well as a raster. Furthermore, you can determine whether formulae or values are to be displayed, as well as the presentation of objects. @{b}Sheets@{ub} The basic settings concerning sheets are defined by @{"" link Menu.guide/Sheet} . Using this option, sheetsize, undo-depth (for ) and calculation mode can be set. @{b}Note:@{ub} For larger sheets - recalculating after input or changing a row takes a relatively long time - it is advisable to activate the manual recalculating. Then the sheet will only be recalculated as required (simply press ) and the annoying wait after every input can be avoided. @{b}Note:@{ub} If you make many inputs in a block (e.g. one under each other), yuou can save yourself a lot of work by defining with "Return: Move Cursor to" the direction which the cursor should move when you press . Further settings concerning sheets (for example country-specific options) can be determined with @{"" link Menu.guide/Locale} , where you can set whether you prefer a decimal point or a decimal comma. @{b}Saving@{ub} You will encounter the "Project Save as" requester quite often and will probably already be annoyed by the fact that you have to always first set the desired path. If you mostly save in the same path, then you will have to set this path by loading or saving before you save the configuration (see below). The path which was last used for saving the configuration is maintained and will always appear as the default when using @{b}@{ub}. Further settings concerning saving can be found in . There you can determine whether an icon is created during saving, whether the last version of the sheet is maintained or whether the current sheet is to be buffered at regular intervals. The last two points in particular can contribute to the safety of your data.. @{b}Charts@{ub} For charts, a few parameters also can be determined as default (for example the preferential form, by which charts can be generated quite easily and quickly). You will find further details in the description of charts. @{b}Config-Save@{ub} If you took the trouble to set optimally all or even a part of the options, you'd like this to be maintained for the next start of TurboCalc. Simply call . All settings will now be saved as "S:TurboCalc.CFG" and are to your disposal at the next session of TurboCalc. @{b}Menu map and keymap@{ub} TurboCalc allows you to adapt the menu structure and keymap to your own needs. But because the necessary windows to do this do not yet exist (they will probably be part of the next TurboCalc version), this will be left to the experts: You can write instructions in the file "TurboCalc.STD" (e.g. KEY or ADDMENUITEM) by which you can - among others - modify the appearance of menus and of the keymap. You will find details in the chapter "Macro-/ARexx-programming" and in the macro instruction "START". @ENDNODE @NODE INDEXNODE "Index" @{"Absolute Cell References" link "AbsoluteCellReferences"} @{"Copying a block" link "Copyingablock"} @{"Creating Charts" link "CreatingCharts"} @{"Editing" link "Editing"} @{"Entering a Formula" link "EnteringaFormula"} @{"Filling a Range" link "FillingaRange"} @{"Formatting" link "Formatting"} @{"Functions" link "Functions"} @{"Generating a Series" link "GeneratingaSeries"} @{"Saving your Work" link "SavingyourWork"} @{"Selecting a Cell" link "SelectingaCell"} @{"Selecting Ranges" link "SelectingRanges"} @{"Settings" link "Settings"} @{"Title Freezing" link "TitleFreezing"} @{"TurboCalc by Michael Friedrich" link "MAIN"} @{"TurboCalc-Sheets" link "TurboCalcSheets"} @endnode