Load your data
Give a model your data in its conversation, add or replace a workbook, see where the model's numbers come from, and reload a dataset after it changes.
Where: Models→a model→message box→Select datasets
A model gets its data in its own conversation. Attach a dataset or upload a workbook with a message, and RIA, eode's assistant, reads it, matches each sheet to the part of the model it feeds, and asks about what's missing. The record beside the conversation shows where every number comes from.
Attach data to a model
On the model's page, above the message box:
- Click Select datasets and pick a dataset under Your datasets, or click Upload to bring in a new workbook. Each attach control is described on Describe your business.
- Type what the data is for, or nothing, and send. Sent alone, the message reads "My datasets:" and the dataset's name.
RIA reads the workbook and asks only about what its sheets leave open; see Start from a workbook. A dataset you attached stays attached: a later message adds to what the model has, it never takes a dataset away.
Once the model holds its data, the controls fold into one line: Data:, the dataset's name, and · Add or change. Click the line to open Select datasets and Upload again. They stay open while the model has no data, or when the reading of its data stopped before anything was read.
Add or replace a workbook
Attach a second workbook after RIA has read the first, and RIA asks what it's for:
"You attached harbor-point-q2 while the model reads harbor-point-bakery. Should harbor-point-q2 replace harbor-point-bakery, be added to it (its sheets join, and only they are read), or should the two be composed, choosing for each sheet in both whose copy is read?"
| Answer | What happens |
|---|---|
| Replace first with second | The new workbook takes the first one's place, and RIA reads it from the start |
| Add second to first | The new workbook's sheets join the first one's; only they are read |
| Compose them, sheet by sheet | For each sheet in both, RIA asks "The Orders sheet is in both … and …. Which copy should the model read?": Orders from the first or Orders from the second |
Reply with the number of an answer, or say it in your own words. If the message you attach it with already says the new workbook replaces the old one, or adds to it, RIA takes that as your answer and doesn't ask. Nothing is read until the choice is made.
See where the model's numbers come from
Open Details at the foot of the record, then Data. It names the workbook the model reads, what each sheet holds, how each part of the model uses your sheets, the rows set aside and what was assumed where your sheets are blank. Each is explained on Start from a workbook.
When the model needs figures none of your data gives, RIA asks for them in the conversation, or in a Your figures card (RIA's proposals).
Reload a dataset that changed
After you change a dataset in Datasets, the model keeps the version it read until you reload it. Once the model uses a dataset, its row under Datasets in Data offers Reload.
- Click Reload on the dataset's row. A box opens with a reason filled in, such as "reload harbor-point-bakery, version 2". Change it if you like: it's kept with the change.
- Click Reload. Cancel closes the box.
The report under the row starts with the version it read ("Version 3."), then lists each part of the model the dataset feeds, with its status: confirmed and the rows it read ("with 120 rows"), or the status and why. It ends "The record was updated.", or "The record was unchanged." when nothing moved. If the reload couldn't be sent, the row says "The reload was not sent.", or why it was refused.
Limits
- A model reads one dataset; adding a workbook to the one it reads, or composing the two, keeps it one.
- Uploads from the message box are
.xlsxor.csv, up to 100 MB.
Related
- Start from a workbook: how RIA reads your sheets and what it asks
- Describe your business: every file the message box takes
- Datasets and Import data: bring data in before you attach it
- Edit a dataset: change a dataset's rows
- Edit data: change numbers in a solved model