1816
|
1
|
|
2 You can:
|
|
3
|
|
4 -Enter data
|
|
5 -Move the marker
|
|
6 -Select a function
|
|
7 -Select a block
|
|
8 -Quit.\
|
|
9 `Entering data`
|
|
10
|
|
11 Label- A name starting
|
|
12 with A-Z.
|
|
13
|
|
14 Number- Contains digits,
|
|
15 a decimal and an optional
|
|
16 leading sign(+ or -).\
|
|
17 `Selecting a block`
|
|
18
|
|
19 Move marker to first cell.
|
|
20 Choose SELECT function or
|
|
21 click and hold the mouse.
|
|
22 Increase size by pressing
|
|
23 the arrow keys or dragging
|
|
24 the mouse.~
|
|
25 `OPEN` ledger file.
|
|
26
|
|
27 `CLOSE` ledger file & exit.
|
|
28
|
|
29 `SAVE` file or selected
|
|
30 block.
|
|
31
|
|
32 `MERGE` a file at marker.\
|
|
33 `PRINT` file or
|
|
34 selected block.
|
|
35
|
|
36 A block SAVE allows a TEXT
|
|
37 or LEDGER save.~
|
|
38 `FORMAT` cell for
|
|
39 justification or decimal
|
|
40 places.
|
|
41
|
|
42 `COPY` cell or selected
|
|
43 block onto COPY BUFFER
|
|
44
|
|
45 `INSERT` COPY BUFFER at
|
|
46 marker.
|
|
47 \
|
|
48 `DELETE` cell or selected
|
|
49 block
|
|
50
|
|
51 `SELECT` a block of cells.
|
|
52
|
|
53 `FORMULA` defines a cell
|
|
54 formula.\
|
|
55 `Entering a formula`
|
|
56
|
|
57 Define formulas using
|
|
58 the following:
|
|
59 + - * / ! ()
|
|
60 and cell references or
|
|
61 numbers. You can also use
|
|
62 these functions:
|
|
63 SUM, MIN, MAX, AVG, ABS,
|
|
64 INT, SIN, COS, TAN.\
|
|
65 A ?label formula indicates
|
|
66 the cell receives a value
|
|
67 prior to calculation.
|
|
68
|
|
69 Examples:
|
|
70
|
|
71 R1C1+R2C2
|
|
72 SUM(R1)
|
|
73 INT(R1*(R2+R3)-20)
|
|
74 R86/R90+5
|
|
75 ?RATE~
|
|
76 `FIND` a cell, label or
|
|
77 formula.
|
|
78
|
|
79 `CALCULATE` all formulas.~
|
|
80 `FORMAT` column width.
|
|
81
|
|
82 `DELETE` current row/column.
|
|
83
|
|
84 `INSERT` row/column at
|
|
85 marker.^ |