Re: New addition to my collection: 200 LX Message #15 Posted by Dave Britten on 24 Aug 2012, 11:49 a.m., in response to message #1 by wildpig
The 200LX is really outstanding. The built-in HP Calc is essentially a 19BII, and there's a (greatly scaled-down) 16C clone hidden on D: (hexcalc.exm, I believe).
If you get into Lotus 1-2-3 macro programming, you can do really impressive data entry and analysis applications with minimal development time. If you can find a copy of Using 1-2-3 Release 2.4 (Susan Shaw, Que), you'll be set. I got a copy via Amazon for a few dollars a couple years back. Even the 95LX manual has pretty good 1-2-3 coverage (most of which was removed for the 200LX manual, sadly), though it doesn't get into the really sophisticated macro programming.
It's remarkable how well this old version of 1-2-3 compares with even current spreadsheet programs, largely because macro programming can make sheets incredibly efficient to work with. (The fact that it's entirely keyboard driven also helps.) It makes me wish I had an iPad version of 1-2-3.
Most of my sheets end up having an Alt-A macro to 'A'dd a new row to a table, format the new cells and enter any formulas, etc. It typically looks something like this:
{goto}NEXTROW~ (Move the pointer to the next blank row.)
/wir~ (Insert a row to move the NEXTROW range name down.)
/cROWTEMPLATE~~ (Copy the ROWTEMPLATE range to the current cell.)
{EDIT}{CALC}~ (Freeze @NOW function in first column.)
{r} (Move to the right for data entry.)
Presto, instant data-logging application (assuming you've got the named ranges set up in appropriate places). Then you can do pretty respectable cross-tab summaries with the /Data Table commands combined with the database functions (@DSUM, @DCOUNT, etc).
The biggest hardware flaw is the infamous "hinge crack", but I found it pretty easy to deal with this using a piece of metal cut from a floppy disk shutter, and a few drops of Gorilla Glue. I would imagine just about everybody on this forum has at least a few 3.5" floppies still laying around.
|