Equatch

Spreadsheet for Apple Watch 

Numbers and charts on your wrist

99 rows, 5 columns.

Automatic saving of each cell.

Graph the data of each column with one click (button above the column).

Charts on widgets and watch faces.

Basic cell operations: + - * / ^

Constants: π (=pi) e (=eu)

Functions: sin(x) cos(x) tan(x) log(x) ln(x)

Sum: sum(x:y)

Arithmetic mean: ave(x:y)

Maximum value: max(x:y)

Minimum value: min(x:y)

Random number from 0 to 1: rnd

Round to integer: rou(x)

Row number as a number: row

Column number (a=1) as a number: col

Value in percent per()

Value in per mille pro()

Counts the number of cells in an area (ignores itself): cou()

Disables the number value (in parentheses) for charts and other formulas: =off()

Sample formulas:

=(-27)^(1/3)

=log(pi)^sin(eu)

=ave(b1:b12)

=per(a99/a98-1)

=off(cou(a1:a99))

"Roll the dice":

=rou(rnd*5.999+0.5)

Variable button under the column:

- If the column is empty, the button (white arrow) fills it with numbers corresponding to the row numbers (1,2,3 ... 99)

- If the column is empty, when you enter a formula in row 99, the button (blue arrow) fills the entire column with that formula. When filling with a formula from row 99 (blue arrow), the referenced cells of the column remain unchanged (those from other columns remain relevant). Example: formula in d99 =a98/d9 after filling (blue arrow) in d98 will be =a97/d9 … in d2 will be =a1/d9 (then enter the value in d9 instead of ERR or select cell d9 before filling to bypass filling).

- The "trash" deletes data in the entire column (except for previously selected cells).

! The first tap selects the cell, the second tap activates edit mode.

! Undeleted (selected) cells must be deselected (by activating edit mode and exiting), otherwise they will be deleted after restarting the app.