Bantam Calc Manual

Bantam Calc is a powerful spreadsheet tailored to run on mobile devices. Built upon the Bantam Parsing and Computation Engine, Bantam Calc lets you design worksheets to make your mobile life easier. Don’t have time to design your own? Then use the Network Download feature to gain access to our library of pre-built convenience worksheets. Don’t want people to see your data? Then password-protect your important files.

Navigation

The currently selected cell is highlighted with a box. Use the navigation keys(arrows) to change the currently selected cell. The sheet will automatically scroll as needed to display the current cell. Cell operations accessed via Menu->Cell... are performed on the currently selected cell. Similarly, row and column operations are performed on the entire row and/or column of the currently selected cell.

Page Mode

Pressing the # key changes the navigation mode to Page Mode. The word “Page” appears in the upper right corner of the screen as a reminder that Page Mode has been activated. Pressing the arrow keys while in Page Mode scrolls through the cells in the sheet one at a time to help you quickly move through larger spreadsheets.

Cell Editing

The cell edit screen is used to edit the contents of the current cell and is displayed by Menu->Cell...->Edit.... Alternatively this screen can be accessed by pressing the Select Key (sometimes known as Fire Key). This key is often located in the center of the navigation arrow keys on the keypad.

Enter the cell formula or value, as well as the desired decimal precision for numeric values. Precision is ignored for string values. Formulas must start with = equals. Numeric values are right aligned and string values are left aligned within the cell.

If the current cell is empty, the text input field will be populated with an = equals sign to save you the trouble of entering one yourself. Simply delete the equals if you are entering a string value and do not wish to enter a formula (a formula must begin with an = equals sign; string values do not.)

Formulas

A formula is an equation that calculates a new value from existing values. Formulas begin with an equal sign (=). Other cells are referenced by their column and row address.

Example Formulas

=1+2*3+4 equals 11

=(1+2)*(3+4) equals 21

=A1 * 2 equals the contents of cell A1 multiplied by 2

=sin(B3) equals the sine of the contents of cell B3

=sum(A1:B3) equals the sum of cells A1,A2,A3,B1,B2, and B3

=IF(A2>4,’is greater than, ’is less than) equals the string “is greater than” if the value of cell A2 is greater than 4

=IF(AND(A1,A2),3,9) equals the value 3 if cells A1 and A2 both evaluate to true, otherwise it equals 9

Operators

The following operators are supported in formulas: + - / * ^ < > = (power operator) & (string concatenation) ‘(single quote - denotes string). In addition, parentheses () may be used to override operator precedence in formulas.

Menus

The main menu is invoked by pressing the Menu softkey. It contains the following options:

Cell… - contains operations that affect the currently selected cell.

Row… - contains operations that affect an entire row.

Column… - contains operations that affect an entire column.

Sheet… - contains operations that affect the entire sheet.

Network… - performs network operations.

About - displays version information.

Cell…

Edit... - brings up the edit cell screen where cell text is entered using the phone’s current text entry mode (e.g. numeric, simple text etc.). The precision of numerical cell values may be set on this screen as well. Precision is ignored for strings.

Clear - clears the contents of this cell.

Copy - copies the contents of this cell into a buffer.

Paste - pastes the contents of the copy buffer into the current cell.

Color… - sets the background/text color scheme for this cell.

Row...

Insert - inserts a new (blank) row directly above the current cell.

Delete - removes the current row from the sheet.

Copy - copies the contents of the current row into a buffer.

Paste - pastes the contents of the copy buffer into the current row.

Clear - clears the contents of the entire current row.

Height... - brings up a screen for setting the width and height of the current column and row in pixels. Current values are displayed in the text box.

Column...

Insert - inserts a new (blank) column directly to the left of the current cell.

Delete - removes the current column from the sheet.

Copy - copies the contents of the current column into a buffer.

Paste - pastes the contents of the copy buffer into the current column.

Clear - clears the contents of the entire current column.

Width... - brings up a screen for setting the width and height of the current column and row in pixels. Current values are displayed in the text box.

Sheet...

New... - brings up the new spreadsheet screen, where you must specify the number of rows and the number of columns to create a new worksheet.

Load... - brings up a list of previously saved worksheets. Highlight the title of the sheet you want to load and select it. If the sheet is password protected, it will prompt you for a password; otherwise the sheet will load.

Save... - brings up a screen to save the current worksheet. The screen will prompt you for a filename and an optional password. Leave the password field blank if you don’t want to require a password to load the sheet. Otherwise, fill in the password, and you will be required to enter it each time you load in this sheet. Please remember your password! If you forget it, there is no way to load in the sheet! (Although you may still delete it.)

Delete... - brings up a list of previously save worksheets. Highlight the filename that you want to delete and select it. The sheet will be deleted.

Resize... - brings up a screen where you can enter the new number of rows and columns for the currently loaded sheet.

Network...

Brings up a screen for downloading worksheets over the network. The screen prompts for a Worksheet ID, which is found in the worksheet description at www.nickelbuddy.com. Use a web browser to find the worksheet that you would like to download, and enter the Worksheet ID on your phone. A network data connection will be attempted.

Please note that this may result in charges per your carrier phone plan. You must have data services enable for this to work.

Remember to save your worksheet after you download it, or it will be lost when you exit the application.

About

Displays version information.

Function List

Statistical Functions

SUM(RangeReference0,RangeReference1,…)

The SUM function gives the total of all values in RangeReferences. RangeReferences can be numbers, cell references, range references, or formulas.

Example

If A1:A3 contains the numbers 1,2, and 3, and B1:B3 contains the numbers 4,5,6, then:

=SUM(A1:A3) equals 6

=SUM(A1:A3,5) equals 11

=SUM(A1:B3) equals 21

COUNT(RangeReference0,RangeReference1,…)

The COUNT function gives the number of cells contained in each RangeReference. COUNT adds 1 for every cell that contains a number, formula, text, or ERR. RangeReference can be a number, cell reference, range reference, or formula. In range references, blank cells are ignored. In cell references, blank cells add 1 to the count.

AVG(RangeReference0,RangeReference1,…)

The AVG function gives the average of RangeReference values. RangeReference can be a number, cell reference, range reference, or formula. In cell references, blank cells are treated as 0(zero). In range references, blank cells are ignored.

Example

=AVG(A1:B3,C1:C3)

=AVG(A1,B2)

MIN(RangeReference0,RangeReference1,…)

The MIN function gives the smallest number in RangeReferences. RangeReference can be a number, cell reference, range reference, or formula. In cell references, blank cells are treated as 0(zero). In range references, blank cells are ignored. In all references, text is treated as 0(zero).

MAX(RangeReference0,RangeReference1,…)

The MAX function gives the largest number in RangeReferences. RangeReference can be a number, cell reference, range reference, or formula. In cell references, blank cells are treated as 0(zero). In range references, blank cells are ignored. In all references, text is treated as 0(zero).

Logical Functions

IF(Cond,ValueIfTrue,ValueIfFalse)

The IF function gives ValueIfTrue if Cond is non-zero(true), and ValueIfFalse if Cond is 0(false).

Example

=IF(A1>2,B1,B3)

=IF(B2<0,color(B2,2),color(B2,0)

=IF(B3=deduction,B2*.7,B2*.9)

AND(Value1,Value2)

The AND function gives the value 1(true) if all values in the list of arguments are true. If any value in the list is false, AND gives the value 0(false).

Example

=AND(1+1=2,2+2=4) equals 1

=AND(1+1=2,2+2=5) equals 0

OR(Value1,Value2)

The OR function gives the value 1(true) if any value in the list of arguments is nonzero(true). If all values in the list are 0(false), the OR function gives the value 0(false).

Example

=OR(1+1=2,2+2=5) equals 1

=OR(1+1=3,2+2=5) equals 0

MATH and Trigonometric Functions

PI()

The PI function gives the number 3.14159, an approximation of the mathematical constant pi. Parentheses are required, but there are no function arguments.

E()

The E function gives the number 2.71828. Parentheses are required, but there are no function arguments.

SIN(x)

The SIN function gives the sine of x when x is an angle in radians.

COS(x)

The COS function gives the cosine of x when x is an angle in radians.

TAN(x)

The TAN function gives the tangent of x when x is an angle in radians. A tangent is the ratio of the x-coordinate to the y-coordinate on a circle.

ASIN(x)

The ASIN function gives the arcsine of x. The arcsine is the angle whose sine is x. ASIN gives the size of the angle in radians. X must be in the range -1 to 1.

ACOS(x)

The ACOS function gives the arccosine of x. The arccosine is the angle whose cosine is x. ACOS gives the size of the angle in radians. X must be in the range -1 to 1.

ATAN(x)

The ATAN function gives the arctangent of x. The arctangent is the angle whose tangent is x. ATAN gives the size of the angle in radians.

LN(x)

The LN function gives the natural logarithm of x. The variable x must be a positive number. Natural logarithms use the mathematical constant e (2.71828) as a base. The logarithm is the power to which the base is raised to provide the number.

LOG(x)

The LOG function gives the base 10 logarithm of x. x must be a positive number.

SQRT(x)

The SQRT function gives the square root of x. The variable x must be a positive number.

ABS(x)

The ABS function gives the absolute value of x. x may be a number or a cell name. An absolute value is the number without its positive or negative sign.

CEIL(x)

The CEIL function gives the next highest integer value of x. x may be a number or a cell name.

Example

=CEIL(6.135) equals 7

=CEIL(-1.2) equals -1

FLOOR(x)

The FLOOR function gives the next lowest integer value of x. x may be a number or a cell name.

Example

=FLOOR(6.135) equals 6

=FLOOR(-1.2) equals -2

INT(x)

The INT function gives the integer part of x. INT truncates the digits to the right of the decimal point without rounding to the nearest integer.

Example

=INT (6.135) equals 6

=INT(6.9) equals 6

=INT(-1.2) equals -1

FRAC(x)

The FRAC function gives the fractional part of x. FRAC removes everything to the left of the decimal point. The sign of x is retained.

Example

=FRAC(2.435) equals .435

=FRAC(-1.2) equals -.2

EXP(x)

The EXP function gives e raised to the power of x, where e is the base number of natural logarithms.

RAND(x)

The RAND function returns a positive integer value from zero to x-1. RAND generates a new random number every time the spreadsheet is recalculated.

Example

The following formula gives a random number from 1 to 6, inclusive:

=RAND(6)+1

General functions

COLOR(cell,colorIndex)

The COLOR function sets the given cell to the color scheme specified by colorIndex. The value for colorIndex corresponds to the index of the cell->colors menu:

Background	Text	colorIndex
White	Black	0
White	Blue	1
White	Red	2
White	Green	3
Black	White	4
Black	Blue	5
Black	Red	6
Black	Green	7
Blue	White	8
Green	White	9
Red	White	10

Example

The following formula sets the color scheme of cell A1 to White background with Blue text:

=COLOR(A1,1)

COLOROF(cell) – (NEW in version 1.0.2)

The COLOROF function returns the colorIndex of the given cell. The value for colorIndex corresponds to the index of the cell->colors menu, and as described in the COLOR() function above.

Example

=COLOROF(A1) equals 1, if the colorIndex of cell A1 is Blue text with a White background.