Columns, formulas and formatting, in a real .xlsx file; Roona also works inside your Excel sheet.
14-day free trial, no credit card, then a subscription at €20 excl. VAT per month.
See the demoA tracking spreadsheet always starts the same way: you know what you want to see, you do not know where to begin, and the blank grid does not help. RoonaWorks is an AI Excel spreadsheet generator: you describe what you want to track, it builds the complete .xlsx file, named columns, formulas in place, formatting applied, and a chart if your figures deserve one. If you would rather stay in your workbook, the same tool installs as a panel on the right of Excel: you select a range, you ask, and the range fills in. A formula you do not know how to write, Roona writes it; a formula you do not understand, it explains it.
You ask: A twelve-month cash flow: money in, money out, opening and closing balance.
Roona delivers: Twelve month columns, one row per item, the closing balance becoming the opening balance of the next month, amounts in euros, and an alert row when the balance goes below zero. You open the .xlsx, you replace the figures, everything recalculates.
You ask: A price list for my services, with the price excluding VAT, the VAT and the price including VAT.
Roona delivers: One row per service, the inclusive column calculated from the exclusive price and the rate you give, the rate editable in a single cell, and the formatting ready to print or send.
You ask: A site schedule by trade: start, end, duration, company, progress.
Roona delivers: One row per trade, the duration calculated between the two dates, the dates in your local format, progress as a percentage with a colour that changes at 100 %, and the total duration at the bottom.
You ask: A log of this month’s call-outs: client, date, engineer, duration, status.
Roona delivers: One row per call-out, a drop-down for the status (scheduled, done, to redo), the hours totalled per engineer at the bottom, and columns wide enough to read without resizing anything.
You ask: Here are my sales for the year, unsorted. Turn them into a clean table by month and by product.
Roona delivers: Your rows arranged by month and by product, a total per month and per product, and a summary sheet that sums the year up in ten lines.
You ask: An attendance sheet for the workshop, over four weeks, with the hours totalled per person.
Roona delivers: One column per day, one row per person, the weekends greyed out, the hours totalled per person and per week, and a column for notes.
Date, supplier, category, net amount, VAT, total: the table is ready to fill in. The total column is calculated by formula from the net amount, amounts display in your currency to two decimal places, and a total row adds everything up with SUM.
One row per work package, with start date, end date, duration and progress. The duration is calculated by formula from the two dates, dates display in your local format, and the header row is coloured so you can find your way around.
Money in, money out, end of month balance: the balance carries over from one month to the next by formula, and a chart shows how the balance moves over the year.
Reference, description, net price, VAT rate, gross price. The gross price is a formula that follows the rate on each row, with percentages and currency in the right format.
Drop in a file of raw data, an export from your accounting software or your till: Roona sorts it, cleans it and sums it up in a clear table.
In the Excel panel, describe the calculation and Roona writes the formula, SUM, IF or VLOOKUP, in the syntax your Excel expects. Select an existing formula and it explains what it does.
You get an .xlsx you can edit in Excel, with its formulas live, and hand to your accountant or your team as it is.
Roona. You write what you want to track, for example “an expense tracker with net amount, VAT and category”, and it generates the complete Excel file, formulas and formatting included.
Yes, an .xlsx you open in Excel, with columns, live formulas and formatting already in place.
Yes. Describe the calculation, in the Excel panel or in Roona, and it writes the formula in the syntax your Excel expects: SUM, IF, VLOOKUP.
Yes. The Roona add-in opens as a panel on the right of Excel, on Windows, Mac or Excel online. You select a range, you ask, and the result is written into the sheet once you approve it.
Yes, drop in a file or select a range: Roona sorts, cleans and summarises the data.
Yes, a chart suited to your figures is added when it helps read the table, and you can ask for a different one.
Yes, hosted in Europe, under GDPR, never used to train the AI.