Turn scattered information into a structured workbook.
Organise the data, define the calculations and create a structure that makes the next decision easier.
Available today Create an Excel (.xlsx) workbook with structured sheets and formulas (SUM, COUNTIF, simple ratios).
Open to guests within the guest allowance and to every signed-in account. Guest chats are not saved.
Review the result before you rely on it.
Contents
What you can do
An Excel (.xlsx) workbook built from your description, ready to download from the chat.
Structured sheets, such as a task list and a summary, with the columns you name.
Formulas for totals, counts and simple ratios, such as SUM and COUNTIF.
How it works
From your brief to a result you can review, in three stages.
Organise the inputs
Name the sheets and the columns you need, and paste in the data you already have or ask for example rows.
Define the logic
Say which totals, counts and ratios the workbook needs. RafayGen writes them as formulas, such as SUM and COUNTIF.
Check the result
Open the workbook in your spreadsheet app, let it recalculate and check each figure before you rely on it.
Example brief
Brief
Create an Excel workbook (.xlsx): a monthly project tracker with a Tasks sheet (Task, Owner, Due date, Status, Hours) for six tasks (2 Done, 3 In progress, 1 Blocked) and a Summary sheet that uses formulas for total hours (SUM), the number of tasks in each status (COUNTIF) and the percent done.
We ran this brief when we checked this tool on .
Change the sheets, the columns and the calculations to fit your project, or paste in your own data.
Formats
You provide
- A description of the sheets, columns and calculations
- Data pasted into the chat
You get
- An Excel (.xlsx) workbook to download from the chat
- Formulas such as SUM and COUNTIF in the cells you describe
File formats
- Excel (.xlsx)
Questions
Which calculations can I ask for?
Name the totals, counts and ratios you need, such as total hours with SUM or tasks per status with COUNTIF. Check each result in your spreadsheet app.
Why are some formula cells empty in a preview?
Only some results are stored in the file. A viewer that does not recalculate shows the other formula cells empty; open the workbook in a spreadsheet app that recalculates it.
Can I add a chart?
Not reliably. A workbook arrives without a chart, and a follow-up request for one may not add it, even if the reply says it did. Open the file to check.
Are dates and percentages formatted?
Dates come back as text and shares such as percent done as plain decimals. Format those columns in your spreadsheet app if you need to sort by date or show percentages.
Limits to know before you start
- Only some formula results are stored in the file, so a viewer that does not recalculate can show empty cells. Open the workbook in a spreadsheet app and check each result.
- Dates are stored as text, and a share such as percent done comes back as a plain decimal. Format those cells yourself.
- A workbook arrives without a chart, and a follow-up request may not add one. Open the file to check.
- A follow-up request makes a new workbook: names, figures and sheet names you did not mention can change.
- Example rows can include made-up names and values. Replace them with your own data.
- Check the file in your spreadsheet software before you share it.
Spreadsheets in RafayGen
Open to guests within the guest allowance and to every signed-in account. Guest chats are not saved.
Review the result before you rely on it.