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.

Local and iCloud backup, data synchronization between watches.

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.

Return to the beginning of the spreadsheet after tapping the system clock.

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)

Factorial (from 0 to 170): (x)!

Sum: sum(a0:g99)

Arithmetic mean: ave(a0:g99)

Maximum value: max(a0:g99)

Minimum value: min(a0:g99)

Median: med(a0:g99)

Standard deviation: std(a0:g99)

Remainder from a division: mod(x/y)

Absolute value: abs(x)

Signum: sgn(x)

Random number from 0 to 1: rnd

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

Rounding up to an integer: up(x)

Rounding down to an integer: do(x)

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

Column number (a=0 ... g=6) as a number: col

Value in percent per(x)

Value in per mille pro(x)

Converting a decimal number from -65535 to 65535 to binary: bin(x)

Converting a binary number from -11111111111111111 to 11111111111111111 to decimal: dec(b)

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

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

Cell Colors:

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

Column B or the formula =re(x) red

Column C or the formula =bl(x) blue

Column D or the formula =or(x) orange

Column E or the formula =vi(x) purple

Column F or the formula =gr(x) green

Font Colors:

Without the formula: white

Formula =off(x): gray

Other formulas: yellow

Line chart color (>50 numbers, previews, widgets): same as the color of the top cell of the column without the =off(x) formula.

Bar chart color (up to 50 numbers): each bar in its own cell color.

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":

=up(rnd*6)

Variable button under the column:

- if the column is empty, the button (white arrow with a function) will fill it with numbers corresponding to the given function assigned to the row number, row 99 will contain the formula for the given function

- if the column is empty, when you enter a formula in row 99, the button (yellow arrow) fills the entire column with that formula. When filling with a formula from row 99 (yellow  arrow), the referenced cells of the column remain unchanged (those from other columns remain relevant). Example: formula in d99 =a98/d9 after filling (yellow 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