GridCraft tutorial: build a budget-versus-spending table
A documented, six-step guide to build a budget-versus-spending table, with source screenshots, editable files and output checks.
Last updated
Menus and supported features can change. Compare the source-check date below with your current app version.

Let’s work towards one clear result: build a budget-versus-spending table. The aim is to keep something you can revise and something you can actually share, rather than learn every feature at once.
This walkthrough follows the developer’s public screens and menu descriptions. I have not run it myself, so the outputs below are expected results to verify, not a tested finished example. Keep the English menu names visible while following along; they also help when your installed version differs.
Before opening the project
Prepare: Three budget rows: Food 300/340, Transport 120/100 and Subscriptions 50/50, where each pair is budget/spending.
Check the official app page and release downloads for a build matching your operating system and CPU. If there is no suitable installer or the app does not start, read Get started/Quick start and known issues in the official README. Record the app version and OS when you try the task.
Use copies for the exercise and keep originals, working documents and exports in distinguishable folders. The documented stage is alpha / in development. Check the article’s source date against your installed version if a menu or supported format has changed.
Find the relevant controls
| Where to look | What it does |
|---|---|
| Worksheet and formula entry | Keep numeric inputs separate from calculated results. |
| Home | Apply consistent number formatting. |
| Insert and chart controls | Check the chart’s source range before styling it. |
Example settings
| Setting | Example |
|---|---|
| Headers A1:D1 | Item / Budget / Spending / Difference |
| First formula | D2 =B2-C2 |
| Expected totals | 470 / 490 / -20 |
| Save | XLSX |
Data to enter in A2:C4
| Item | Budget | Spending |
|---|---|---|
| Food | 300 | 340 |
| Transport | 120 | 100 |
| Subscriptions | 50 | 50 |
Follow the task
1. Create the workbook
Use File → New. Put Item, Budget, Spending and Difference in A1:D1. Decide which cells are inputs before adding formulas.
2. Enter the sample rows
Put Food 300/340, Transport 120/100 and Subscriptions 50/50 in A2:C4. Enter amounts as numbers and use consistent number formatting under Home.
3. Calculate the first difference
Enter =B2-C2 in D2. Food should produce -40. If it does not, inspect B2/C2 and whether either amount was entered as text.
4. Fill and total
Fill the difference formula through D4. Put =SUM(B2:B4) in B5, =SUM(C2:C4) in C5 and =B5-C5 in D5. Expected totals are 470, 490 and -20.
5. Add a chart
Select A1:C4 and use the chart controls under Insert for side-by-side budget/spending bars. Decide deliberately whether the totals row belongs in the source range.
6. Save and recalculate
Use File → Save As for XLSX, then reopen it. Change Food spending from 340 to 350. Its difference should become -50 and the total difference -30; check the chart too.
Expected output and the next small revision
Keep an XLSX containing the formulas, not only a picture or cached totals. After reopening, change an input and inspect both its formula result and the aggregate. Check that conditional formatting and the chart still refer to the intended cells. A separate CSV can hold tabular values but should not be mistaken for the full styled, editable workbook.
Three rows with independently known answers make a useful first calculation check. They do not establish accuracy of a large workbook, advanced formulas, macros or external-data connections. Opening XLSB/ODS with plausible values is also not proof that its original formula logic survived.
If you get stuck
If a formula appears as text, inspect cell format and any leading apostrophe. Locale settings can change decimal and argument separators; consult the formula-input documentation. For unchanged totals, inspect references and text-number inputs. For a misleading chart, check its range before its appearance, including whether the total row was included accidentally.
Keep the last working copy separate from the problem file. Record the exact error and the step where it appeared. Changing several settings at once makes the cause harder to find. If you replace an input file, note that it is a different test rather than declaring the original successful.
Check before scaling up
- Compare results and error cells for identical values and formulas.
- Inspect formulas, conditional formatting, charts and pivots in the same XLSX.
- Measure opening, recalculation and saving for the same large workbook.
Record the cell inputs, expected formulas and the second calculation after changing spending. For larger comparisons, use identical workbooks and measure opening, recalculation and saving separately. Inspect charts and styles after a round trip, and count errors rather than deciding from the table’s visual neatness.
Introduction · Task tutorial · Comparison: documented differences
Sources & further reading
- https://getartcraft.com/apps/gridcraft
- https://github.com/storytold/gridcraft/blob/main/README.md
- https://www.microsoft.com/en-us/microsoft-365/excel
- https://github.com/storytold/gridcraft/blob/84acf6293b1dc1fc09837524e035d674eb4d6741/README.md
- https://github.com/storytold/gridcraft/blob/84acf6293b1dc1fc09837524e035d674eb4d6741/crates/ui-egui/src/ribbon.rs
- https://github.com/storytold/gridcraft/blob/84acf6293b1dc1fc09837524e035d674eb4d6741/docs/formula-input.md