Equatch

Spreadsheet for Apple Watch 

Numbers and charts on your wrist

100 rows (0-99), 7 columns (A-G)

Row numbers always visible, each column a different color (default)

Automatic saving of each cell

Chart data for each column with a single press (button above the column)

Return to the furthest saved cell in a column when leaving the chart

Additionally, charts and data 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

Rounding to an integer: rou(x), to decimal places 1-9: ro1(x) … ro9(x)

Row number as a number (0 ... 99): row

Column number (a=0 ... g=6) 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()

Cell Colors:

Columns A and G or the formula =si() gray (silver)

Column B or the formula =re() red

Column C or the formula =bl() blue

Column D or the formula =or() orange

Column E or the formula =vi() purple

Column F or the formula =gr() green

Font Colors:

Without the formula white

Formula =off() gray

Other formulas yellow

Chart Color: Same as the color of the top cell of the column without the =off formula

Sample formulas:

=(-27)^(1/3)

=log(pi)^sin(eu)

=gr(ro2(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.