Equatch

Spreadsheet for Apple Watch 

1 sheet 

10 columns (A-J)

100 rows (0-99)

1000 cells

Row numbers and column names (watchOS 11+) are always visible. 

Automatic saving of each cell. 

Local and iCloud backup (5 slots), data synchronization between watches. 

Restored backups automatically save the current state to Local Save. 

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

Return to the furthest saved cell in the column after leaving the chart. 

Return to the beginning of the sheet after hitting the system clock. 

Additionally, charts and data appear on widgets and watch faces. 

When a cell is selected, a bar with buttons appears: "Cut," "Copy," "Paste," "Undo", "Cancel."

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

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 ... J=9) 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 J or the formula =si(x) gray (silver)

Columns B and I or the formula =re(x) red

Columns C and H or the formula =bl(x) blue 

Column D and G or the formula =gr(x) green 

Column E or the formula =vi(x) purple

Column F or the formula =or(x) orange 

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 function assigned to the row number. Row 99 will contain the formula for that function.

- If the column is empty, when you enter a formula in row 99, the button (yellow arrow) will fill the entire column with that formula.

- If the column is not empty, the "Select Column" button appears, which can be used to clear the column using the "Cut" button or copy it using the "Copy" button.