From - Sat Apr 10 09:32:19 1999
Received: from motgate2.mot.com (motgate2.mot.com [129.188.136.102])
          by mw5.texas.net (2.4/2.4) with ESMTP
	  id NAA00504 for <exal@texas.net>; Wed, 7 Apr 1999 13:34:30 -0500 (CDT)
Received: [from mothost.mot.com (mothost.mot.com [129.188.137.101]) by motgate2.mot.com (MOT-motgate2 1.0) with ESMTP id NAA11205 for <exal@texas.net>; Wed, 7 Apr 1999 13:35:51 -0500 (CDT)]
Received: [from emailsps.sps.mot.com (emailsps.sps.mot.com [216.8.10.1]) by mothost.mot.com (MOT-mothost 2.0) with ESMTP id NAA20797 for <exal@texas.net>; Wed, 7 Apr 1999 13:34:24 -0500 (CDT)]
Received: by tula.sps.mot.com (4.1/SMI-4.1)
	id AA20260; Wed, 7 Apr 99 13:32:53 CDT
Date: Wed, 7 Apr 99 13:32:53 CDT
From: exal@tula.sps.mot.com (Al Arduengo )
Message-Id: <9904071832.AA20260@tula.sps.mot.com>
To: exal@texas.net
Subject: exal.txt
Content-Type: text
X-UIDL: 09909bab1a346389637ca3afeaf9a642
X-Mozilla-Status: 8001

  The following is documentation on the use of exAL v6.3. exAL is a spreadsheet 
  program for the HP48 series calculator. It is intended to be compatible with   
  both the S and G series but, since I have not had much of an
  opportunity to test it on a S(X) I cannot say for sure. I *can* say
  that I tried to use only compatible addresses. As usual, I make the
  following disclaimer (not necessarily in the usual format):
  
  This program is provided as is and without warranty. By installing and
  using this program, the user agrees that I (Al Arduengo) am not liable
  for any incidence of data lost, corrupted or otherwise mangled nor am
  I responsible for any damage that most probably will not be done to
  your calculator. Since the program is written entirely in sysrpl and
  assembly language, there is always the possibility that something
  could go wrong and the user should be aware that, although I know of
  no specific instance of such a thing, low level code like assembly
  when improperly implemented *could* cause actual hardware damage.
  
  With that said, on to the good stuff.
  
  History:
  I started this project in 1993 because at the time I was taking a
  Physics course which required the use of a spreadsheet to analyze data
  gathered in labs. I wrote a version in userrpl which had some
  functionality and served me well. As I became more comfortable with
  programming the HP48, I added more and more capabilities to it until
  it became impossible to manage due to size. Upon the discovery of
  Jazz, I undertook the task of rewriting it in sysrpl which greatly
  reduced the size and increased the overall speed. Since that version I
  added more and more to it (usually on the suggestions of users) and
  eventually did two total rewrites. The current version is about 90%
  sysrpl and 10% assembly. It includes an input line routine written by
  Arnold Moy. 
  
  Requirements:
  exAL requires the presence of UFL (Universal Font Library) to
  work. This is available in many places but one sure bet is at
  http://www.hpcalc.org which is now the primary source for HP48/28
  goodies. The calculator must have at least 23k bytes of ram available
  to run it from port 0 and ports > 1. I believe it will run fine from
  covered ports, btw. There are two versions of exAL - one for the
  standard HP48 and one for those using MetaKernel. The standard version
  will work with MK but does not make use of MK's excellent speed and
  capabilities. The MK version will ONLY work with MK.
  
  Installation instructions:
  Download the library to your calculator. Recall the lib to the
  stack. Enter the number of the port you wish to install it in (not
  port 1 if you use MK) and press STO. Power cycle your calc and it will
  be installed. I will not tell you how to purge it since I am lazy and
  you need this anyway. :-)
  
  Data types allowed:
  Note: a maximum of 26 columns are allowed and as many rows as your
  memory will allow.
  
  1: Real numbers
  2: Complex numbers
  3: Lists (if you enter a list, the elements if valid are placed in cells
  based on how you have the Auto-move setting assigned. If you have more
  elements in the list than rows or cols, the last row/col will receive
  the last list element.
  4: Arrays (this has not been thoroughly tested but should work)
  5: Programs (*MUST* return a valid object and MUST not alter the
  display)
  6: Strings
  
  Cell referencing:
  You may reference a cell as you would in most pc programs. eg A1, B10
  etc. If you do so in a formula, implementing the copy function will
  make the references relative. In other words, as the formula is copied
  to progressive cells, cell references are updated. If you wish to make
  a cell reference fixed (eg use it as a constant) simply place a $ sign
  in front of the name (eg $A5)
  
  Go to your library menu and then into the exAL submenu. Press NEWsheet
  (if you wish to create a new spreadsheet) and exAL will start. From
  here, the following is possible:
  
  Key sequence		Action performed
  ------------		------------------------------------------------
  Pressing any of the 10 numbers or the decimal key will immediately
  begin numeric entry. Lists, strings, programs and arrays are entered by
  using the normal key strokes.
  
  [A]			Displays information about the program at top

  [C]			Initiates the COPY operation. First, you will
			see the status line change to say "Copy $$" 
			where SS is the cell name currently hilited.
			Move to the cell origin you wish to copy and
			press ENTER. Now the status line will say
			"Copy $$ from $1" where $1 is the start cell
			of the destination. From here you can move to
			the cell you want the copy block to start and
			press ENTER. Now the status line will read 
			"Copy $$ from $1 to $2" where (you guessed it)
			$2 is the cell which marks the finish location
			of the copy block. Press ENTER here and the
			program will begin copying the appropriate data
			to its corresponding location(s). You may abort
			the copy process anytime BEFORE the last ENTER
			press by pressing ON. (Please refer to the 
			section on cell referencing)

  [Arrow keys]		Move the cursor around.

  [rightshift arrow	Move to the top, bottom, extreme left or right.
   keys]

  [NXT]			Opens up the configuration screen. From this
			screen you may set certain parameters to your
			taste. Choices are Auto-move, Display, BZ,
			Auto-save and Sound. To the right of each
			choice is the current setting. [+/-] toggles
			the settings (which are self-explanatory).
			[ON] exits the configuration screen saving the
			settings. If you wish BZ to be active, you must
			have the command BZ either in HOME or in a
			library attached to HOME. If it is active, when
			you exit the program, the sheet will be
			compressed with BZ to save space. Auto-save
			means to save the sheet after any data entry. 

  [']			Signals the input routine to begin allowing the
			entry of a formula. When done press ENTER and
			if you wish to abort, press [ON].

  [EVAL]		Evaluate the current cell.

  [->NUM]		Reevaluate the entire sheet.

  [ENTER]		Push the current cell's contents to the stack.

  [EDIT]		Edit the current cell with either the eqwriter
			or the standard editor.

  [EEX]			Toggle on/off gridlines.

  [DEL]			Delete the current cell contents

  [<-]			(backspace) Pop the stack one object and place
			in current cell.

  [/]			Starts the menu of math, row and column
			operations. This is different for the MK and
			standard versions. With MK version you get a
			choose box menu. With the standard version you
			see the selections in the status line. Note:
			Added rows/cols are appended to the bottom of the
			sheet. Inserted rows/cols are inserted where the
			cursor is. Also note that the sheet MUST have at
			least 7 rows and 4 columns. If you try to delete
			the 4th column or 7th row it will just beep.

  [SPC]			Redraws the display.

  [->]			(rightshift 0) Exports the current sheet to a
			space delimited string of the rows and columns.
			You may upload the string to your pc and with
			only minor edits, import it into a PC
			spreadsheet program. The string will be stored
			in the current directory.

  [rightshift TAN]	Copy's the current cell (if a real or formula
			which resolves to a real) to SIGMADAT. You can
			copy any number of cells to sigmadat and use
			the Math menu ops to place mean, stdev or total
			to a cell.

  [leftshift TAN]	Delete sigmadat.

  [leftshift downarrow] Printscreen to IR printer

  [ON]			Will prompt you for a name for the sheet. Enter
			the name and press ENTER or press ON again to
  exit without saving. If BZ is active, the actual sheet will be
  compressed and all flag settings and custom parameters will be saved 
  with the sheet into a program that you need only execute from the
  variable menu. It will start up right where you left off before.
  
  Tips and tricks:
  
  * If you wish to copy or move a single cell to another location, go to
  the origin cell, press ENTER (then [DEL] if you want to delete) then
  move to the destination and press [<-] (backspace) to place the
  contents there.
  
  * If you want to plot data, make sure you place the X data in column 1
  and the Y data(s) in columns 2 on. All plot data must be adjacent with
  X data as first column.
  
  * If you have do a lot of editing and addition/deletion of data and
  have formulas in the sheet, remember to reevaluate the sheet
  occasionally to ensure it is correct.
  
  * Give your sheets unique and safe names that do not interfere with
  system commands or possibly other variables in your structure.
  
  * If you make the sheet too large, expect a speed penalty when
  redrawing, recalculating etc. This cannot be helped.
  
  * Only copy in a down/right direction. In other words, don't copy
  cells D5 to D1 from A1 to A5. Always do something like copy A1 from A2 to
  A5, or A1 from B5 to B10 etc.
  
  * A good bank account tracker is done like the following:
  
        A       B       C       D       E      F
     -----------------------------------------
  1 | "Date"  "Type"  "Ck #"  "Amt"    "Bal"
  2 |                                  500.50
  3 | 1.041999 "Wdrl" "569""  -20.83   'E2+D3'   
  4 | 1.051999 "Dep"  "ATM"    200     'E3+D4'
  5 |
  6 |
  7 |
  8 |
  9 |
  
  
  and so on. Note, all you have to do for the formula is make the first
  one (in this case 'E2+D3'). Then copy it from E3 to the last row of
  the sheet. It will make the correct cell references for you. Then
  simply enter the transaction information (neg for withdrawal ands pos
  for deposit) then press [EVAL] on the balance cell for the day the
  transaction took place. Of course the format above is just a
  suggestion. I personally use strings for the date so I can make it
  look anyway I wish.
  
  * You can use programs to do almost anything. an example is setting a
  flag. << "Flag3" -3 SF >> will set flag -3 and place an identifier in
  the cell. Remember, programs MUST return at least one object to the
  stack. You can use programs to do array math, string manipulation,
  make sounds, etc. Just be cautious when you experiment.
  
  
  I could go on and on about the possibilities but I won't. Really there
  is a LOT of flexibility in this program so just be creative. I will
  always try to answer any questions given to me (for instance "How do
  I...?" or "Why doesn't it...?") and I will try my best to correct bugs
  as they are discovered. I assure you there will be the occasional bug
  as this is a big program and very hard to make idiot proof. I also
  welcome suggestions and code from users. I may not always implement
  them but I will certainly consider it. If you have questions about how
  this program works I will be happy to explain. You may of course
  disassemble the library to look at it or I can send you directory
  source I have.
  
  There are several other things exAL can do that I will leave as Easter
  eggs. Hint: Having Jazz and/or EQStack installed helps.
  
  This is freeware. I don't expect anything from you. However if you are
  overwhelmed with the urge to compensate me, go ahead. If you live
  outside the USA, a coin or small bill from your country would be a
  neat addition to my collection. And if that is too much, perhaps a
  postcard. I have over a dozen from all over the world. If you live in
  the USA, you may send me $150 or more if you wish. Or you can just
  shoot me an email and let me know you use it , what you do and if you
  like it. If you don't want to do anything... cool. Pretty fair, huh?
  
  Thanks to a bunch of folks.
  Mika (for Jazz)
  Arnold (for lots of tutoring and EDLIN)
  Ray Good (for early testing and pushing me to learn ml)
  And many others whose names I do not have with me right now for
  countless suggestions, attaboys, and critiques.
  
  I can be reached at
  
  ra8311@email.sps.mot.com (work)
  or
  exal@texas.net (home)
  
  Al Arduengo
  8102 B Willet Trail
  Austin, TX 78745
  
  or go to my humble page:
  http://lonestar.texas.net/~exal
  
  
  Kind regards,
  Al

