Spreadsheets with Ava: formulas, totals and charts, in Excel or the open format
How Ava Supernova makes real spreadsheets: numbers that add up, formulas, totals rows, money, percentage and date formats, charts, and both .xlsx and the open .ods format, viewed and changed without leaving Ava.
Ask Ava for a budget, a tracker or a price list and you get a spreadsheet you can actually use: numbers you can add up, formulas that work, and charts, in Excel’s format or the open one.
1. Ask for what you need
- "Make a monthly budget for rent, food, energy and travel, with a total."
- "A spreadsheet of these invoices with the amount, the date and whether it is paid."
- "Add a pie chart of where the money goes."
She saves it in your project’s documents folder, where the Library shows it.
2. Real numbers, formulas and totals
- Numbers are stored as numbers and dates as dates, so they sort, filter and add up.
- Formulas stay formulas, such as =B2*12 or =SUM(B2:B9), so the sheet keeps working when you change it.
- Ask for a totals row and you get real SUM formulas at the bottom.
- Each column can have its format: money (£, $, €), percentages, dates or whole numbers.
- The header row stays in place as you scroll, has filters on longer sheets, and uses your house colour.
Ava works out the everyday formulas herself (sums, averages, minimums and maximums, counts, rounding and ordinary arithmetic), so the results are there when she reads the sheet back or you view it in Ava. Anything beyond those, such as a lookup or a formula that reaches into another sheet, is calculated by Excel or LibreOffice when the file opens. She never fills in a number she has guessed.
3. Charts
Ava can add column, bar, line and pie charts, drawn from the cells in your sheet. They are real Excel and LibreOffice charts, so they open ready and you can restyle them in your own app.
4. Excel or the open format
Ask for .xlsx for Excel, or .ods, the OpenDocument format for LibreOffice. Both carry everything: formulas, formats, totals and charts. Ava can turn one into the other without losing any of it, and turn a CSV file into a proper spreadsheet in either format.
5. Changing it later
- "Rent went up to £950" changes that cell, and every total that depends on it updates.
- "Add insurance at £40 a month" adds a row above the total, and the total and any chart grow to include it.
- Ava can read any spreadsheet in your project, formulas included, to explain it, check it or build on it.
6. Seeing it
Press View on Ava’s message, or on the spreadsheet in the Library. It opens in its own tab with a tab for each sheet, the charts above the grid, and a formula bar: click a cell to see its formula next to its value. Open in your app takes it to Excel or LibreOffice.