TinySheet User's Manual
By StarFort Software
Last Updated: Oct 10, 1997
Description
TinySheet is spreadsheet application for the USR PalmPilot series of palmtop organizers. It is an easy to use tool for performing "What if" analysis on the go. TinySheet offers a many features, including:
Requirements
TinySheet requires a US Robotics Pilot or PalmPilot with 70k of free memory.
Installing
This archive contains the files:
TSHEET.HTM This document in HTML format TSHEET.TXT This document in text format
TSHEET.RTF This document in RichText format
TSHEET.PRC The TinySheet program file
Use the Pilot application installer to install the program file TSHEET.PRC.
Using TinySheet
TinySheet's interface is similar to other popular spreadsheets and should be largely intuitive. It consists of two main interface screens, the index window and the spreadsheet window.
In the index window, a list of all of the spreadsheets currently stored in the database is shown. To view or edit a stored spreadsheet simple click on the spreadsheets name. To create a new spreadsheet click on the New button.
The spreadsheet window provides the interface to view and edit spreadsheets. The window is divided into upper and lower sections. The upper section contains the familiar spreadsheet grid showing 2 columns and 8 rows. The lower section contains the editing field and several buttons. Clicking on a cell in the upper section will select that cell and enter it's formula or value into the editing field. Next to the editing field are the Check Mark button and the X button. Clicking the Check Mark button will store the value in the editing field into the current cell and recalculate the spreadsheet. Clicking the X button will undo any changes you have made in the editing field. Below the editing field are three buttons. The Done button will save any changes you have made to the spreadsheet and return you to the index window. The Det button will bring up the spreadsheet details dialog. You can get sizing information and change the spreadsheet's name in the details dialog. The Del button deletes the spreadsheet and returns to you the index window. The right side of the lower section contains the navigation buttons. The cell, page, and end buttons select cell, page or end navigation and the arrow buttons scroll the spreadsheet.
Selecting Cells
To select a cell or group of cells, point at the first cell you wish to select and drag and release at the last cell you want. If a single cell is selected it will be marked by a dotted line just inside the cell. If you have selected multiple cells, the dotted line will surround the entire region selected. The entire selected range of cells will be shaded except for the first cell in the region, the primary cell.
Menu Functions
Delete
Deletes the current spreadsheet and returns to the index window.
Details…
Opens the spreadsheet details dialog. You can get sizing information and change the spreadsheet's name in the details dialog.
Import…
Displays a list of memos in the memopad. Select one and it will be imported into TinySheet. The memo must be stored in the memopad as a tab delimited file. The first line of the memo, the memo’s title, will become the sheet’s title. All remaining lines will be imported into sheet cells.
Export
Export the open spreadsheet to the memopad as a tab-delimited file. The sheet’s title will be the first line of the memo and will appear as the memo’s title in the memopad.
Clear
Clear all of the selected cells. No information is saved on the clipboard.
Cut/Copy
The contents of the primary cell is cut or copied to the clipboard.
Paste
The contents of the clipboard are copied to each cell selected. If the clipboard contains a formula, the cell references in the formula will be adjusted during the
Paste function.
Select
Use the select function to select large regions of cells. With the primary cell selected, scroll the sheet so that the last cell in the desired region is visible. Choose Select from the edit menu and click on the desired cell. The entire region will now be selected.
Insert Row/Insert Column
A new row/column will be inserted into the sheet before the selected cell.
Delete Row/Delete Column
The row/column containing the selected cell with be deleted from the sheet.
Functions...
Displays the Functions dialog. This dialog presents a list of the available formula functions. Select the function you want from the list and click the OK button to insert the function into the current formula.
Series...
Displays to Series dialog. The dialog contains 4 field and 2 buttons. Use the Across and Down buttons to create a vertical or horizontal series. The Start field specifies the starting value of the series. The Inc. field specifies the series increment. The count field specifies the number of elements in the series. The Format field determines how the values are entered into the cells. The field may contain any string value. This string will be entered into each cell. The special character combination "%d" will be replaced with the current series value.
Example: The format string "Test %d" would create cell entries:
Test 1, Test 2, Test 3...
Column Width…
Displays the column width dialog. Allow you to change the displayed width of the current column in the sheet. Column widths must be between 5 and 140. Values outside this range will be clipped. If a range of cells is selected then every column in the selected region will be affected.
Formulas
TinySheet formulas must start with an equals sign "=". Numbers can be expressed in decimal or scientific notation. Cells are specified by column and row. (i.e. B11) Cell ranges can be expressed by specifying the first and last cells in the range separated by a colon.
(i.e. A1:A5).
TinySheet supports the following arithmetic operations:
Addition "+", Subtraction "-", Multiplication "*", and Division "/"
TinySheet supports the following boolean operations:
Equals "=", Not Equals "<>", Greater Than ">", Less Than "<",
Greater Than or Equal, ">=", and Less Than or Equal "<="
In addition to the previous operations, TinySheet includes the following functions:
ABS(x)
Returns the absolute value of x
ACOS(x)
Returns the arc-cosine of x
ASIN(x)
Returns the arc-sine of x
ATAN(x)
Returns the arc-tangent of x
ATAN2(y,x)
Returns the arc-tangent of y/x
AVG(x...)
Returns the average value of the cells in the range x...
CEIL(x)
Returns the smallest integer larger than x
COS(x)
Returns the cosine of x
COUNT(x...)
Returns the number of cells in the range x...
DTOR(x)
Returns the number of radians in x degrees
EXP(x)
Returns e raised to the x
EXP10(x)
Returns 10 raised to the x
FAC(x)
Returns x factorial
FLOOR(x)
Returns the largest integer smaller than x
FV(p...,i)
Returns the future value of the payments in the range p... at an interest rate of i
FVA(a,n,i)
Returns the future value of n payments of a at an interest rate of i
IF(e,t,f)
Returns t if expression e is TRUE otherwise it returns f
LN(x)
Returns the natural log of x
LOG(x)
Returns the log base 10 of x
MAX(x...)
Returns the maximum value in the range x...
MIN(x...)
Returns the minimum value in the range x...
POW(x,y)
Returns x raised to the y power
PV(p...,i)
Returns the present value of the payments in the range p... at an interest rate of i
PVA(a,n,i)
Returns the present value of n payments of a at an interest rate of i
RTOD(x)
Returns the number of degrees in x radians
SIN(x)
Returns the sine of x
SQR(x)
Returns x squared
SQRT(x)
Returns the square-root of x
SUM(x...)
Returns the sum of the values in the range x...
SUMLN(x...)
Returns the sum of the natural log of the values in the range x...
TAN(x)
Returns the tangent of x
Release Info
Version 1.20b released Oct. 10, 1997
Bug Fix: Memory Manger error on import with no memos in MemoPad
Bug Fix: Expressions evaluation in the correct left-to-right order
Cut/Copy/Paste work to the Pilot Clipboard
Intelligent adjustment of cell references when pasting of formulas
Select regions of cells. Clear/Paste/ColumnWidth work on regions
Bug Fix: Correct error when functions are nested
Entering a return in the edit field moves to the next row
Now works on PalmOS 1.x devices
Insert and Delete Rows and Columns
Version 1.10d released Sept. 28, 1997
Fixed corrupted .prc file in 1.10c release
Version 1.10c released Sept. 24, 1997
Bug fix: Tiny Sheet database now backed up during hotsync
Import and Export of spreadsheets through MemoPad
Improved error handling in formulas
More descriptive error flags
All range based functions properly ignore blank cells in their ranges
Check for correct number of parameters in functions
Addition of boolean operators: "=" "<" ">" ">=" "<=" "<>"
Addition of "if" function
Version 1.01a released Sept. 15, 1997
Bugs fixed to allow execution on PPPersonal
Improved handling of memory errors
Checks for OS version 2.x for operation
Sum bug fixed
Divide by zero caught
Version 1.00d released Sept. 10, 1997
First release of TinySheet
Contact Info
TinySheet is by StarFort Software
(c) 1997 All Rights Reserved.
StarFort Software
1085 NW 183rd Ave.
Beaverton, OR 97006
We look forward to hearing from you.
email us at support@starfort.com.
Thank you.
Disclaimer
We at StarFort Software are committed to providing quality, easy-to-use software. However, this product is provided without warranty and the user accepts full responsibility for any damages, consequential or otherwise, resulting from its use. This archive is freely redistributable, provided it is made available only in its complete, unmodified form with no additional files and for noncommercial purposes only. Any other use must have prior written authorization from StarFort Software. Unauthorized commercial use includes, but is not limited to:
1. A product for sale.
2. Accompanying a product for sale.
3. Accompanying a magazine, book or other publication for sale.
4. Distribution with "Media", "Copying" or other incidental costs.
5. Available for download with access or download fees.
This program may be used on a trial basis for 30 days. The program will continue to function afterwards. However, if after this time you wish to continue using it, please register with us for the nominal fee listed in the program. Thank you.