AnnexCalc – Getting started (Tutorial)
A hands-on walkthrough ("your first hour with AnnexCalc"). Whitepaper format, PDF-ready. Screenshots are captured according to the shot list at the end.
Goal of this tutorial
By the end you will have created a small budget sheet as a .axsheet document: with values, a SUM formula, currency formatting and a title – saved and exported as XLSX.
Step 1: Launch the app and open a sheet
Start AnnexCalc from AnnexHub. An empty sheet opens in the three-column layout: sheet info and assets on the left, the cell grid in the middle, the inspector on the right. Open an existing .axsheet via File ▸ Open… (⌘O).
Step 2: Enter values
Click a cell and enter a value, for example monthly costs stacked in one column. Confirm the entry with Enter. This fills a small cost list quickly.
Step 3: Write a SUM formula
In the cell below your values write a formula, for example =SUM(B1:B5). AnnexCalc calculates ranges, cell references and the functions SUM, AVG, MIN, MAX – with the German decimal comma. After Enter the cell shows the result.
Step 4: Set the title and extend the sheet
Enter the sheet title in the inspector on the right, for example "Budget 2026". Need more room? Extend rows and columns via the toolbar. There is one sheet per document.
Step 5: Assign a currency format
Select a result cell and choose the Currency format in the Format menu or via the format picker in the inspector. The format is display-only: the stored value and the calculation stay unchanged, while print and export carry the formatting.
Step 6: Read the evaluations
In the inspector you read the raw value/formula and result of the selected cell as well as the column sum and grand total. The sidebar lists all formula cells – a click jumps to the cell in grid and inspector.
Step 7: Save as .axsheet
Save the sheet with File ▸ Save (⌘S). The first time you choose the location ("Save As…", ⌘⇧S); afterwards ⌘S saves directly. If autosave is enabled in the settings, it additionally saves silently on an interval.
Step 8: Export as XLSX (or print)
Via File ▸ Export… or the toolbar button "Export" you choose the format. For handing on to Office take XLSX; for a fixed view take PDF. XLSX/ODS/PDF carry the number formats. Alternatively print directly with File ▸ Print… (⌘P).
Result & next steps
You created a budget sheet with values, a formula, currency formatting and a title, saved it as .axsheet and exported it as XLSX. More on all features, formats and MCP automation is in the manual (docs/manuals/en/AnnexCalc.md) and in the authoritative feature list .
Shot list (for screenshot capture)
| File | Content | Window state | Sample data |
|---|---|---|---|
| calc-01.png | Launch window, empty cell grid, three columns visible | Light theme, window ≥1280×800 pt, sidebar + inspector shown | empty sheet |
| calc-02.png | Cell grid with numeric values entered | Grid centered, one cell in edit mode | 5 cost values in column B |
| calc-03.png | Cell with a formula and its calculated result | Result cell selected | =SUM(B1:B5) |
| calc-04.png | Inspector with the sheet title, toolbar visible | Inspector on the right, title field active | title "Budget 2026" |
| calc-05.png | Format menu open, currency with a checkmark | Format menu expanded | currency format on the result cell |
| calc-06.png | Inspector (column/grand total) and sidebar (formula cells) | both columns shown | formula cell list with one entry |
| calc-07.png | NSSavePanel when saving as .axsheet | Save dialog open | file name "Budget 2026.axsheet" |
| calc-08.png | Export dialog (confirmation dialog) with CSV/XLSX/ODS/PDF | Export dialog open | XLSX selected |