Equatch

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 Example function graph (x^3): 1. In cell G99, enter the formula =(row-50)^3 2. Under column G, press the button (blue arrow) 3. Above column G, press the button (chart)