BeePad for iPhone & iPod touch - Version 1.0

FREE PROMOTIONAL CODE AVAILABLE FOR REVIEW!!!

BeePad 1.0 is a basic spreadsheet application. It is similar to notepad with basic calculation functionality.

NEW
Tap [+] button to create new document.
New document has 2 columns and 10 rows.
Additional rows and columns can be added by tapping "+" in the column\row header.
26 columns and 99 rows can be added in this version.

MAIL
Tap mail icon to mail the document. The document is embedded as HTML table in the mail.

DELETE
Tap trash icon to delete the document.

SCROLL
Touch and drag to scroll.

SELECT
Tap once on any cell to select. Tap over the selected cell and drag to select a range of cells.
Tap over column/row header to select the entire column/row. The toolbar icons change when a cell is selected. Tap [Done] to end selection.

EDIT
Textfield appears on top when a cell is selected. Tap the textfield to enter text. Tap [Return] in keyboard to move to next cell in the column. Tap [Done] to end editing.

CUT
Select a cell and tap cut button to delete the cell contents. If all cells in a row/column is selected then cut will remove the entire row/column. The contents will reside in memory and could be paste in the same document or other documents.

COPY
The contents will be saved to memory.

PASTE
The contents saved to memory will be paste from the selected cell.

INSERT
Row/Column selection dialog comes up when insert button is tapped. If [Row] is tapped then new row is inserted above the selected cell. If [Column] is tapped then new column is inserted to the left of the selected cell.

SUM
Select a range of cells and tap sum button to sum up all the values selected.

GRIPPER
Tap over the gripper circle and drag down or right to copy the cell values.

FORMULA
After selection, enter into textfield. [F(x)] button appears before the textfield. Tap [F(x)] to bring up formula entry field and keyboard. The formula field is different from iphone textfield. In this version the formula field doesn't support cursor move, text selection and copy/paste.
The formula keyboard has functions that can be selected by tapping.
Only relative cell referencing is supported now. Tap a cell to add cell reference to the formula.
Tap and drag a selected cell to select range of cells.

FUNCTIONS
sum( list ) Calculates the sum of the values in the list.

min( list ) Calculates the minimum value in the list.

max( list ) Calculates the maximum value in the list.

count( list ) Results in the number of non-blank entries in the list.

avg( list ) Calculates the average of the non-blank values in the list.

npv( dr, range ) Calculates the net present value of the cash flows in range, discounted at the rate specified by expression dr.

na Results in a "Not Available" value that makes all expressions using the value displayed as #NA.

err Results in an "Error" value that makes all expressions
using the value displayed as #ERROR.

pi Results in 3.1415926536 .

abs( v ) Results in absolute value of v.

int( v ) Results in the integer portion of v.

exp(v) sqrt(v) Calculates the appropriate function.
ln(v) log10(v) The trigonometric calculations are
sin(v) asin(v) done in radians.
cos(v) acos(v)
tan(v) atan(v)

More functionalities to come in future versions! Mail to smartbee.in@gmail.com for support.