XCELL - XLS on HP 50g

Download XCELL for 50g.  Unzip it and put XCELL.HP file in an SD Card.

Next, install XCELL Software on your 50g with [LeftShift] [FILES] User Interface.  Copy and paste the XCELL.HP from SD to Flash Port.  Restart the 50g by pressing [ON] [F3] at the same time.

To start XCELL by typing XCELL and press Enter.

WORKING WITH XCELL

The sheet has a graphical interface similar to anyother spreadsheet program. It has 3 parts:

To move around the XCELL Sheet, use  the cursor keys.  To exit, press [ON] key, you are asked for a name. The data will be stored in the current directory. If you want to open the sheet, use [Left Shift] [FILES], navigate to the Home directory, use the arrow key to point to the file name you want to open.  Press {EVAL} soft key.

Entering a formula into a cell.  Say we on A3, you want to add A1 and A2:

XCELL can export data to text format ordered by tabulators.  It can then be imported in Microsoft Excel. To export data press [Left Shit][UPDIR] and transfer the file .txt created with the name of the sheet to the PC in ASCII mode.

To import data, save the sheet on the PC as Text with tabulators and EDIT it to add string delimiters (’’). Transfer

it to the HP in ASCII mode. Put it in the stack and open a new sheet ([XCELL]) or an existing sheet where you want to insert data. Now, import data with [<-] (back arrow) Key.

XCELL can handle very large sheets of up to 50x50 with no or little lost of performance except if it has to recalculate big amounts of data.

Press [NXT] key to display key help.  To exit help screen, press [NXT] 3 times.

No shifted

[A] Shows about message.

[B] Extracts data to stack from cell THROUGH cell. If a cell contains a formulae, the formulae itself is extracted.

[C] Relative copy of cell from actual cell THROUGH cell

- [D] Makes total SUM (relative) of data contained in SigmaDat (not the standard

SigmaDAT but XCELL48’s SigmaDat) and puts the result in the current cell

- [E] Makes the MEAN (relative) of SigmaDat

- [F] Makes the STDEV (relative) of SigmaDat

- [CST] Shows STATUS PAGE with info on flags and properties of the sheet

- [NXT] Shows a two page HELP

- [’] Enter formula (Ex. ’A1*B1+C2’)

- [STO] Saves the sheet without leaving using the current name

- [ENTER] Copies current cell to stack (formulaes and / or values)

- [+ / -] Changes cursor’s movement after entering data from left->right

to up->down. A small arrow in the upper left side of the screen shows the

current direction

- [DEL] Deletes from cell THROUGH cell

- [<-] Imports data from stack (level 1) to current cell. Data can be:

- a real, complex, character string or formulae

- a real, complex or symbolic row or column delimited by {{}}

- a real, complex or symbolic matrix delimited by {{}}

- a character string containing data ordered by tabulators

This is useful for importing data from another spreadsheet program

that supports data ordered by tabulators (like EXCEL)

- [.] … [9] Enter number to current cell (it can have more than one figure)

- [ALPHA] Enter character string to current cell. String will be parsed to

a real, complex or formula if it’s possible, so this is a ’general’

way of entering data

- [ / ] Changes between ’show formulas’ and ’don’t show formulas’ mode. When in

’show formulas’ mode the Inputline shows the formula (if any) of the

value in the current cell. When in ’don’t show formulas’ mode the Inputline

shows the value itself. This is useful when formulas are very long, because

they must be converted to strings and this slows scrolling a lot. It can be

useful too for viewing values longer than the cell dimensions

- [*] Toggles the position mark

- [-] Inserts row at cursor position

- [+] Inserts column at cursor position

- [ON] Exits the sheet (you are asked to save or not the sheet)

- CURSORS

Left Shifted

- [MTH] Saves data (character string) to ’name_of_the_sheet.txt’.

Data will be ordered by tabulators and formulas will be changed from

’A1+5’ to =A1+5. This way you can open the file from EXCEL and use

the sheet with its formulas. Before opening it from EXCEL remember to

transfer it in ASCII mode and to delete the string delimiters (’')

once in the PC (with EDIT, NOTEPAD or another ASCII editor).

If you want to print the sheet you can print it from EXCEL or directly

print the file from HP48 as any other file (be sure to have cells smaller

than 7 chars to maintain table aspect)

- [EVAL] toggles UNDO ON / OFF

- [TAN] Purges SigmaDat

- [+ / -] Edits current cell

- [ / ] Enter complex to current cell

- [-] Deletes row at cursor position

- [+] Deletes column at cursor position

- [8] Change between BARS and POINTS plot mode

- [0] Sets STD mode

- [2] Sets FIX2 mode

- [3] Sets FIX3 mode

Right Shifted

- [EVAL] makes UNDO / REDO of the last operation made

- [TAN] Adds current cell to SigmaDat.

This way you can select a number of cells and then SUM, MEAN or SDEV

them with [D], [E] or [F]. If you keep the key pressed it will add

next cells continuously in the direction of the arrow in the upper left

side of the screen.

- [8] PLOTS X (BARS mode) or X, Y (POINTS mode). Data is selected with the

EXTRACT function ([B]) and you must extract first X and then extract Y.

Once in the PLOT menu you have the standard keys of the graphic menu.

When plotting POINTS, you can adjust them to a line by pressing [FCN] or

[STATL] (if S or G calculator), and then you can [FCN] and ROOT, ISECT,

SLOPE, AREA, EXTR, EXIT, F(X), F’ and NXEQ. If you press NXEQ you will

see the equation of the adjusted line, so this is a good way to make a

linear regression

- [*] Jump to position mark

- [ON] Turns off the machine without leaving

- [-] decreases the number of columns displayed (but increases width of cells)

- [+] increases the number of columns displayed (but decreases width of cells)

You can see a maximun of 10 columns and a minimum of 1. Maximum number of

columns displayed is limited by the existing number of columns but minimum

number of columns is not limited in any way