Spreadsheets

AM-Notebook 5.0 - Homepage - Help-Start - Topics - Previous - Next

Spreadsheets

AM-Notebook supports spreadsheets with simple formulas. A spreadsheet is a grid that organizes data into columns and rows. Each spreadsheet has a header where you can enter a description and the cells where you can enter strings, numbers and formulas.

Strings are automatically left aligned, numbers are automatically right aligned.

Each cell can have a simple formula which must start with the equal character "=".

Functions and Formulas:

=colsum
Summarizes all numbers in a column from row 1 to that function. If you enter a second colsum function in a column, then the second colsum summarizes all numbers starting from the first colsum function to the second colsum function, and so on. This function can only be used exclusively and not within expressions. See screenshot below for an example.
=rowsum
Summarizes all numbers of a row from column number 1 to that function. If you enter a second rowsum function in a row, then the second rowsum summarizes all numbers starting from the first rowsum function to the second rowsum function, and so on. This function can only be used exclusively and not within expressions.
Formulas (PRO-Edition only)
With formulas you can calculate values by using other cells, constants and built-in functions. For example =A1+A2+B5 or =(A3+A4+ROUND(B5))/3. Formulas can contain cell references, constants and functions.

Operators in formulas:

+	Addition
-	Subtraction
*	Multiplication
/	Division
^	Exponential (only positive numbers)
(	Open parenthesis
)	Close parenthesis
MOD	MOD operator

Functions in formulas:

SUM(StartCell:EndCell)	sum of all cell values in range, for example SUM(A5:B10)
AVG(StartCell:EndCell)	average of all cell values in range, for example SUM(B3:B10)
ABS(parameter)	absolute value
EXP(parameter)	exponential of value
ROUND(parameter)	rounds value
SQRT(parameter)	square root of value
SQR(parameter)	square of value
TRUNC(parameter)	truncates value

The cells in formulas are updated when you insert/delete rows and columns (for example, =B5+C5 will become =B6+C6 when you enter a line before row number 5).

Please note that cells in formulas are not updated when you move columns or rows via Drag&Drop!

Cell Ranges:

Cell ranges are identified by the top-left cell and the bottom-right cell, splitted by a':' and can be used in several functions (see table above), for example the SUM function.

Example:
=SUM(A5:B7)
A5:B7 specifies the range of cells from cell A5 to cell B7, exactly the cells A5+A6+A7+B5+B6+B7.

Examples and Screenshots: