Making a spreadsheet
Models, trackers and analyses come out as real Excel files, with a grid you can read in the pane beside the chat.
Build a 12-month cash view I can show the board
Add a quarterly summary sheet
Q3-cash-view.xlsx Download
| Month | Revenue | Costs | Net |
|---|---|---|---|
| July | 412,000 | 298,000 | 114,000 |
| August | 438,000 | 301,000 | 137,000 |
| September | 470,000 | 312,000 | 158,000 |
| October | 505,000 | 325,000 | 180,000 |
Ask for another sheet and it appears
- Say what the rows and columns are
- You get a real Excel file
- Ask for another sheet and it appears
Asking for one
Say what the rows and columns are, and what should be calculated from them.
Reading it in the pane
The grid renders with its sheet tabs, so you can check the numbers without downloading anything.
Changing it
Ask for a column, another sheet, or a different calculation.
Starting from your data
Attach a spreadsheet or a CSV and ask Metir to work from it rather than inventing numbers. See attaching files.
Say what the numbers are for. "A 12-month cash view I can show the board" produces a different sheet from "a table of costs".