Skip to main content
rafaygenAI

Spreadsheets

Available

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.

Example project

Concept preview
Concept preview of the example brief: an Excel (.xlsx) project tracker. The Tasks sheet lists six sample tasks with an owner, a due date, a status and hours (2 Done, 3 In progress, 1 Blocked). The Summary sheet totals the hours with =SUM(Tasks!E2:E7), counts each status with COUNTIF and divides the done count by the number of tasks, shown as a plain decimal; the formula bar shows the total. An illustration, not a recording of a real run.
Contents

What you can do

  1. An Excel (.xlsx) workbook built from your description, ready to download from the chat.

  2. Structured sheets, such as a task list and a summary, with the columns you name.

  3. 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.

  1. Organise the inputs

    Name the sheets and the columns you need, and paste in the data you already have or ask for example rows.

  2. Define the logic

    Say which totals, counts and ratios the workbook needs. RafayGen writes them as formulas, such as SUM and COUNTIF.

  3. 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.