Examples¶
Every example is a folder with a README.md and (usually) a run.py.
They all work the same way:
Each README shows the exact output you should get. The scripts need only
an installed abax (pipx install "abax[all]" — see the
getting-started guide); none of them need
optional packages, a network connection, or a display.
Running from a source checkout without installing? Put the repo root on the import path first:
pip install -e .once, or prefix runs withPYTHONPATH=/path/to/abax.
Getting started¶
| I want to… | Go to | Runs? |
|---|---|---|
| Build and save my first workbook from Python | first-workbook | run.py |
| Learn the GUI in a minute (keys, palette, themes) | sixty-second-tour | walkthrough |
| Install abax / pick extras / binary downloads | getting-started guide | guide |
Formulas¶
| I want to… | Go to | Runs? |
|---|---|---|
| Summarize data — mean, spread, percentiles, correlation | descriptive-statistics | run.py |
| Use spilling formulas — SORT, UNIQUE, FILTER, SEQUENCE | dynamic-arrays | run.py |
| Schedule work in business days, skipping holidays | business-days | run.py |
| Look up any of the 642 functions | formula reference | guide |
Data: import, clean, export¶
| I want to… | Go to | Runs? |
|---|---|---|
| Clean a messy CSV and export the fixed values | csv-clean-and-export | run.py |
Query a region by column name — =SUM(Sales[Amount]) |
structured-tables | run.py |
| See every format abax reads and writes | file formats | guide |
| Import Excel / Parquet / SQLite / Stata / R | file formats | guide |
Analysis¶
| I want to… | Go to | Runs? |
|---|---|---|
| Solve backwards — "what input gives this output?" | goal-seek | run.py |
| Colour cells by value, regex, rank, or CSS | conditional-formatting | run.py |
| Run regression, t-tests, ANOVA, pivot, group-by | data & analysis tools | guide |
| Hand a selection to pandas / run SQL across sheets | Python console | guide |
| Compare scenarios (what-if) | data & analysis tools | guide |
Charts¶
| I want to… | Go to | Runs? |
|---|---|---|
| Embed charts that live in the workbook and refresh on recalc | embedded-charts | run.py |
| Save histogram / bar / scatter charts as SVG files | statistical-charts | run.py |
| All ten embeddable kinds, options, both backends | charts guide | guide |
| Plot interactively, sparklines in cells | data & analysis tools | guide |
Scripting & CLI¶
| I want to… | Go to | Runs? |
|---|---|---|
| Use abax headlessly — view, get, convert, profile | headless-cli | run.py |
| Write macros and custom formula functions (UDFs) | macros & scripting | guide |
| Script the live workbook from the built-in REPL | Python console | guide |
| Run shell commands on the current selection | terminal | guide |
| Drive abax from other programs | automation API | guide |
| Round-trip notebooks / run abax as a Jupyter kernel | Jupyter | guide |
Project management¶
| I want to… | Go to | Runs? |
|---|---|---|
| Schedule a project (CPM) and export a report, headlessly | task-tracking | run.py |
| Track tasks with Kanban, Gantt, Calendar, and 7 more views | task-tracking | walkthrough |
| Import tasks from CSV / MS Project XML | task-tracking | walkthrough |
| Run what-if scenarios with undo | task-tracking | walkthrough |
| Generate a status report (HTML or Markdown) | project management guide | guide |
Radio & RF¶
| I want to… | Go to | Runs? |
|---|---|---|
| Score a contest log — dupes, points, totals | contest-log-scoring | run.py |
| Link budgets, VSWR, Smith chart, antenna modeling | RF toolkit | guide |
Everything else¶
| I want to… | Go to |
|---|---|
| The dual-pane file manager | file manager |
| The budget wizard | budgeting |
| RPN / graphing / algebraic calculators | calculators |
| Themes, fonts, settings, environment variables | configuration |
| The vim-style terminal UI | getting-started guide |
| Accessibility (high contrast, spoken cells) | GUI guide |
| How abax is put together | architecture |