Skip to content
dhanu docs
Browse pages

Tasks

Spreadsheets

Ask for a budget, tracker or model and you get a live grid with real formulas — one the assistant can also sort, format, chart and read back from.

Anything numeric — a budget, a roster, a tracker, a model, a comparison table — comes back as a sheet: a live grid with working formulas, not a table pasted into a message. Change an input and the totals recalculate, the same as any spreadsheet.

Where it runs: in a task.

What the assistant can do

It canWhat that looks like
Create a sheetA new grid beside the task, headers in the first row, totals as real formulas
Write a block of cellsAppend rows, fill a column, replace a table
Write scattered cellsFix one number, add a total, clear a cell
Read a rangePull the actual computed numbers before summarising or comparing them
Format a rangeBold headers, alignment, currency, percentages, decimals, text and fill colour
Change the shapeInsert or delete rows and columns, sort, freeze headers, merge cells, add or rename tabs
Add a chartA live chart beside the grid, drawn from a range
Add a ruleConditional formatting — red below a threshold, green when a status is “Done”
Rename itTitle only, data untouched

A spreadsheet open beside a task, showing the formatting toolbar, the A1 formula bar, and a grid of items, quantities and prices

The grid, its toolbar and the formula bar — the same sheet the assistant is writing into.

Formulas are real

The assistant is told to write =SUM(B2:B13) rather than a pre-computed number, so the sheet stays useful after you edit it. Values you see are calculated on the fly — they are not stored — which is why the numbers are always consistent with the formulas, whoever typed them.

When it moves rows or columns, formulas that pointed at them are rewritten automatically. If a formula’s target genuinely disappears you get #REF!, the same as anywhere else.

Dates in a sheet

Dates follow your own settings — Bikram Sambat or Gregorian, your zone, your week start. Two people looking at the same sheet see the same day rendered in their own calendar, so a Kathmandu colleague and one abroad are never arguing about which day a row refers to.

Getting it out

A sheet exports to XLSX or CSV. Formulas, formatting and charts survive the XLSX round trip; CSV is values only, one tab at a time.

Working with it well

Give it the shape you want. “Columns: month, budget, actual, variance” beats “make me a budget”.

Ask it to read before it reasons. For a large sheet, say “check the actual numbers first” — it will read the range rather than working from the preview.

Ask for the chart. Charts are not automatic. “Plot actual against budget by month” adds one.

A sheet is a single artifact with tabs inside it, not one artifact per tab. Ask for a second tab, not a second sheet, when the data belongs together.