xref: /csrg-svn/contrib/sc/tutorial.sc (revision 45334) 
1*45334Sbostic# This data file was generated by the Spreadsheet Calculator.
2*45334Sbostic# You almost certainly shouldn't edit it.
3*45334Sbostic
4*45334Sbosticdefine "page4" A70
5*45334Sbosticdefine "page3" A49
6*45334Sbosticdefine "page2" A29
7*45334Sbosticdefine "page1" A9
8*45334Sbosticdefine "page5" A89
9*45334Sbosticleftstring A1 = "This is a brief sc tutorial."
10*45334Sbosticleftstring A3 = "Cells are named by their column and row number.  For example,"
11*45334Sbosticleftstring A4 = "Cell A4"
12*45334Sbosticleftstring B4 = "Cell B4"
13*45334Sbosticleftstring C4 = "Cell C4"
14*45334Sbosticleftstring A5 = "Cell A5"
15*45334Sbosticleftstring A6 = "Cell A6"
16*45334Sbosticleftstring C6 = "Cell C6"
17*45334Sbosticleftstring A7 = "Cells range from A0 to AN199."
18*45334Sbosticleftstring A8 = "Cells can also be named by the user.  See 'range names' in the manual."
19*45334Sbosticleftstring page1 = "You can move the cursor a couple of different ways:"
20*45334Sbosticleftstring A11 = "^n, j and the <DOWN> arrow key go down"
21*45334Sbosticleftstring A12 = "^p, k and the <UP> arrow key go up"
22*45334Sbosticleftstring A13 = "^b, h and the <LEFT> arrow key go left"
23*45334Sbosticleftstring A14 = "^f, l and the <RIGHT> arrow key go right"
24*45334Sbosticleftstring A15 = "You can go directly to a cell by typing 'g' and the cell name. "
25*45334Sbosticleftstring A16 = "'g c6' will take you to cell c6."
26*45334Sbosticleftstring A18 = "Cells can contain numbers, formulas, or text."
27*45334Sbosticleftstring A19 = "Most of the cells on this page contain text."
28*45334Sbosticleftstring C20 = "<Type 'g page2' to continue>"
29*45334Sbosticleftstring A22 = "Cell d22 contains text"
30*45334Sbosticleftstring D22 = "Text "
31*45334Sbosticleftstring A23 = "Cell d23 contains a number"
32*45334Sbosticlet D23 = 123.34
33*45334Sbosticleftstring A24 = "Cell d24 contains a formula"
34*45334Sbosticlet D24 = D23+88
35*45334Sbosticleftstring A26 = "To see what the cell contains, just move the cursor"
36*45334Sbosticleftstring A27 = "onto the cell.  The contents will show up on line 1 in the brackets."
37*45334Sbosticleftstring page2 = "You can enter data into cells like this:"
38*45334Sbosticleftstring B30 = "'<text' enters left justified text."
39*45334Sbosticleftstring B31 = "'>text' enters right justified text."
40*45334Sbosticleftstring B32 = "'=number' enters a number"
41*45334Sbosticleftstring B33 = "'=formula' enters a formula."
42*45334Sbosticleftstring A35 = "Try duplicating d22 through d24 in e22 though e24."
43*45334Sbosticleftstring A37 = "You erase a cell by typing 'x' with the cursor on the cell."
44*45334Sbosticleftstring C40 = "<Type 'g page3' to continue>"
45*45334Sbosticleftstring A42 = "Here is a typical use for numbers and formulas:"
46*45334Sbosticlet A44 = 10.3
47*45334Sbosticlet B44 = 1877.5
48*45334Sbosticlet C44 = 234.7
49*45334Sbosticlet E44 = @sum(A44:C44)
50*45334Sbosticlet A45 = 44.56
51*45334Sbosticlet B45 = 44.3
52*45334Sbosticlet C45 = -3
53*45334Sbosticlet E45 = @sum(A45:C45)
54*45334Sbosticlet A46 = 88.74
55*45334Sbosticlet B46 = 8000
56*45334Sbosticlet C46 = -9
57*45334Sbosticlet E46 = @sum(A46:C46)
58*45334Sbosticlet A47 = 99.2
59*45334Sbosticlet B47 = -88
60*45334Sbosticlet C47 = -44.6
61*45334Sbosticlet E47 = @sum(A47:C47)
62*45334Sbosticlet page3 = @sum(A44:A47)
63*45334Sbosticlet B49 = @sum(B44:B47)
64*45334Sbosticlet C49 = @sum(C44:C47)
65*45334Sbosticlet E49 = @sum(A44:C47)
66*45334Sbosticleftstring A51 = "The data is entered in a44 through c47."
67*45334Sbosticleftstring A52 = "Cells a49, b49 and c49 sum their respective columns."
68*45334Sbosticleftstring A53 = "Cells e44, e45, e46, and e47 sum their respective rows."
69*45334Sbosticleftstring A54 = "Cell E49 is a grand total."
70*45334Sbosticleftstring A55 = "Try changing some of the data cells and watch the sums change."
71*45334Sbosticleftstring A57 = "You can also edit cells by putting the cursor on the cell and typing:"
72*45334Sbosticleftstring B58 = "'e' to edit the numeric portion."
73*45334Sbosticleftstring B59 = "'E' to edit the string portion."
74*45334Sbosticleftstring C60 = "<Type 'g page4' to continue>"
75*45334Sbosticleftstring A62 = "Since you are reading this, you know that you can load "
76*45334Sbosticleftstring A63 = "a data base from a file by typing the file name as an"
77*45334Sbosticleftstring A64 = "argument to the program.  You can also load or save a "
78*45334Sbosticleftstring A65 = "data base using the file commands:"
79*45334Sbosticleftstring B67 = "'G file'"
80*45334Sbosticleftstring C67 = "Gets the data from an sc file."
81*45334Sbosticleftstring B68 = "'P file'"
82*45334Sbosticleftstring C68 = "Puts the data from the spreadsheet into a file."
83*45334Sbosticleftstring page4 = "Try 'P foo.sc' to write this to the file foo.sc"
84*45334Sbosticleftstring A71 = "The Get command erases the current spreadsheet.  "
85*45334Sbosticleftstring A72 = "To merge a spreadsheet with the one currently in"
86*45334Sbosticleftstring A73 = "the machine, use:"
87*45334Sbosticleftstring B75 = "'M file'"
88*45334Sbosticleftstring C75 = "Merge the data from a saved sc file."
89*45334Sbosticleftstring A77 = "You can also get human readable versions of the data"
90*45334Sbosticleftstring A78 = "by using the Write command:"
91*45334Sbosticleftstring C80 = "<Type 'g page5' to continue>"
92*45334Sbosticleftstring A82 = "Try 'W tut.txt' for a clear text version of the tutorial."
93*45334Sbosticleftstring A85 = "This is the end of the tutorial.  We have explored"
94*45334Sbosticleftstring A86 = "The basic commands.  Much more detail is available"
95*45334Sbosticleftstring A87 = "in the man page."
96*45334Sbosticleftstring D91 = "GOOD LUCK!"
97