.TH 2020 1 "May 1985" .FM mit .SH NAME 2020 \- run the 20/20 spreadsheet system .SH SYNOPSIS .B 2020 [ .B \-w ] [ .B \-d .I machine:ttyport ] [ .I file ] .SH DESCRIPTION The .I 2020 command starts up the 20/20 spreadsheet system. 20/20 is an integrated spreadsheet modeling program licensed from Access Technology, Inc. .I 2020 works on all Athena terminals, but if you want to use its graphics, you should use an Athena graphics terminal. Your terminal type will be set automatically. Once in .I 2020, you can get help by typing: .I /h. Type .I /q (for "quit") to leave .I 2020 and return to the Unix system level. .PP The .I 2020 program assigns special functions to certain keys on the terminal keyboard. The assignments differ slightly by terminal type. The following chart shows the 20/20 symbol, the function and the key assignments: .ta 1i 2.5i 4i Symbol Function DEC Terminals IBM PC Terminals backout Ctrl-H Ctrl-H calculate spacebar spacebar continue @ @ do PF2 F2 delete delete-key delete-key rubout delete-key delete-key return RETURN-key RETURN-key page PF1 F1 goto > > .br model-bottom Ctrl-B Ctrl-B .br model-top Ctrl-T Ctrl-T .br arrow down-arrow down-arrow .br up-arrow up-arrow up-arrow .br left-arrow left-arrow left-arrow .br right-arrow right-arrow right-arrow .br help PF4 F4 .br point-to down-arrow down-arrow .PP When running .I 2020 from a VS100 terminal, there are two options. Use these options if you want to use the .I entire VS100 screen. Both of these options will be ignored if you are not on a VS100 terminal. .TP .B \-w will create a new window (pop-up window) for .I 2020 to run in. It will completely fill the VS100's oversize screen. The new window will disappear when .I 2020 is exited. Note that using this option assumes that you have an .I xwm(1) process running. .TP .B \-d if a the .B \-w option is given and you are logged in to the current machine remotely from another machine (either with .I rlogin(1) or the Athena login server), then you must specify the machine and terminal which the terminal is actually attached to and which is running the .I xwm(1) process (mit-nessus:0, for example). (Type the .I printenv command on the original machine and look for the DISPLAY variable.) The -d option followed by the display variable creates a new .I xpty(1) process under the control of the remote xwm that knows how to manage the new, oversized window. This option is completely unnecessary if you are not rlogged in from another machine. .SH "WHAT IS A SPREADSHEET?" Spreadsheets are used by managers, accountants, and financial planners to do budgeting and cost analysis, to build financial models, or prepare business plans. The spreadsheet is a valuable analytic tool for other applications that involve juggling numbers, comparing data, or developing projections. .I 2020 transforms your terminal screen into a ledger sheet. The rows and columns of this grid can represent numbers, or relationships between positions on the grid. (E.g., column 3 is the sum of columns 1 and 2.) Once the data is entered you can ask "What if?" questions to discover the effect of changing various elements of the model. Change a value on the spreadsheet and .I 2020 will automatically recalculate any other values affected in seconds. 20/20 has additional features such as: .RS graphics capabilities, including bars, lines, pies (can only be used on Athena graphics terminals) database management tools, that allow you to sort, select and arrange data a command file facility that includes conditional branching, prompting and error trapping. Complex applications can even be fully menu-driven "goal seeking", this allows you to backsolve models to learn what will be required to reach a specific outcome formatters, translators and data import/export facilities to help 2020 interface to other application packages, databases, etc. .RE .SH "SEE ALSO" .I Essential 20/20 , available free in Athena terminal clusters, provides an overview, a self-paced instructive exercise, and describes 20/20's online tutorials. The .I 20/20 User's Guide , sold at the IS Publications Office, contains reference material, complete command descriptions, functions, an appendix and index. .I xwm(1) and .I xpty(1) describe the unsupported window system. .SH BUGS The 20/20 program does not use the standard Berkeley Unix .I curses(3X)/termcap(3X) mechanisms to adapt itself to different terminal types. It uses its own mechanism. Athena has installed 20/20 so that it will automatically detect and correctly assign the terminal type for all Athena hardwired terminals (all of whom are identified by a TERM variable of either vt100, vt125, vs100 (later to be xterm), or h19pc). If your TERM variable is not set to one of the standard type terminals, 20/20 will say it is unable to set a terminal type. You will have to set the type manually with the .I 2020 /OT .I termtype command. See the file .I /usr/athena/lib/2020/tfil for the recognized terminal types. Correct performance in this case is NOT guaranteed. You can define your own terminal types. See the .I 20/20 Users Guide , Appendix A, Section IV. .SH LICENSING RESTRICTIONS This software has been licensed from Access Technology, Inc. for use on Project Athena machines. As with other licensed software 2020 is protected by copyright and other laws, together with the licenses and contractual agreements between MIT and Access Technology. This software may not be copied for use on non-Athena machines or for distribution outside MIT.