Start from a workbook
Build a model on your own spreadsheet: attach it in the conversation, see how RIA read each sheet, answer what your sheets leave open, and get the model's inputs back in your own layout.
Where: Models→+ New→Upload
Attach a workbook in a model's conversation and RIA, eode's assistant, builds the model on your own rows. It reads every sheet first, writes down on the record what it took each sheet to be, and asks you in the conversation only about what your sheets leave open.
Attach your workbook
Any of these starts a model on your workbook:
| From | Do |
|---|---|
| A new model's conversation (+ New beside Models) | Click Upload beside the message box, or drop the file on the box, then send |
| Home, with no models yet | Upload spreadsheet |
| A dataset you already imported | Select datasets above the message box and pick it, or Build a model from this file on the dataset's page (Datasets) |
The upload becomes a dataset in Datasets and goes with your next message. Add a sentence on what you want to decide, or send it alone: it then reads "My datasets:" and the dataset's name. Which files the box takes, and what it refuses, is on Describe your business. Every way in is on New model.
To give a model you've already started its data, or to bring in a second workbook, see Load your data.
Let RIA read the sheets
Once your message has created the model, RIA reads the workbook in the background. While it reads, RIA works on what your words already say (the decision, the time the plan covers, its level of detail) and doesn't guess at what your sheets hold. Leave the page if you like; the reading carries on.
When it's done, the record's top card lists "RIA read your workbook and proposed what each sheet holds." under Since your last message, and the Data part in Details fills in.
See how each sheet was read
Open Details at the foot of the record, then Data.
| Part | Shows |
|---|---|
| Datasets | The workbook the model reads |
| What each data sheet holds | Each sheet by name, with one sentence of what RIA took it to be, such as orders, capacity, recipes, or results rather than input |
| Names | What each part of the model is named after, and where the name came from |
| "RIA read 14 columns with confidence; taken as read" | Folded: every column RIA was sure of. Click it to open them |
A line RIA was sure of reads Taken as read; ask to change it. Click Ask on it and the line goes into the conversation as your message, so you can tell RIA what it really is. Where RIA offers other readings, they show as buttons beside Ask.
Rename a part
Each name under Names is yours to change, and RIA won't ask about it again.
- Click Another name.
- Click one of the names offered, or type yours in "Or type your own name" and click Use my name. Keep and the current name closes the box with nothing changed.
Where RIA no longer offers the name it first read, Use and that name puts it back in one click.
Answer what your sheets leave open
RIA asks in the conversation, one question at a time, for what your workbook doesn't settle, naming the sheet and the cells by what they hold. Its offered answers are numbered. Reply with the number, or say what's true in your own words. RIA never asks for a figure a sheet already holds.
You may be asked:
- What a column means: "What is the Lead time column on your Items sheet?"
- Which business unit to model, when your workbook names more than one: "Your workbook names 3 business units. Which do you want to model?", with the one with the most demand proposed.
- A value the model needs that no sheet gives, with RIA's proposal. Agree to it, or give your own value or rule.
- How to read a figure, such as whether demand is the most each customer will buy or an order you've promised.
Each open question is also on the record. Needs you on the top card counts it, and its line in Data reads Waiting for your answer in the chat. Go to the chat puts the question back in the conversation for you to answer (Read a model's record). Once you answer, the top card lists "You answered how your workbook was read.", and RIA moves on to the next step on its own.
To change an answer later, tell RIA in the conversation, or click Ask on the line in Data.
Read how your workbook is used
Once RIA has matched your workbook to the model, Data says where each number comes from. Folded, the part reads like "From the Items, Recipe and Places sheets of harbor-point-bakery".
| Part | Shows |
|---|---|
| How your workbook is used | One line per part of the model: "The plan uses the Recipe sheet in harbor-point-bakery for …" |
| Rows set aside | By sheet, each row the model doesn't use and why. A long list ends "12 more rows were set aside." |
| Assumptions | What the model assumed where your sheets are blank, row by row (Row, Assumption). Changes you asked for are under Your changes |
When the model is built, the record's top card says it was built from your workbook (Follow a build). Two cases read differently on the record:
- "Your workbook maps, sheet by sheet, but it is too large to build as one model, so it is built one business unit at a time."
- "Your workbook could not be mapped straight into the model, so the model is built from your description with your workbook's tables in front of it." Where that was your choice, the record adds "To build from your workbook instead, tell RIA."
Download your inputs
Where: Models→your model→The record→Your model, described→Download inputs
A model built straight from your workbook offers Download inputs under Your model, described, once its data is mapped. It saves your own sheets, under your own names and headers, with the values the model holds, plus three columns after yours:
| Column | Holds |
|---|---|
| Source | Where the row came from, as the sheet and row of your workbook, or assumed where the model filled in a value you left blank |
| Class | DECISION for a row that feeds a value the plan explores (a price, a demand or supply limit, a machine's hours), EXPEDIENT for a row the model filled in, FACT for any other row the model holds; blank for a row it doesn't |
| Note | What became of the row, such as why it isn't in the model |
Limits
- A reading reads the first 64 sheets that have rows; a sheet with only a header row isn't read and doesn't count.
- Up to 240 columns of each sheet are read.
- A reading stops after 6 minutes.
- Up to 8 values your sheets don't give are asked about.
- A unit you give a column is up to 160 characters.
- Uploads are
.xlsxor.csv, up to 100 MB.
Related
- Describe your business: the message box's attach controls
- Load your data: attach, add or replace data on a model, and reload it
- Read a model's record: the record, Needs you and Go to the chat
- Import data: bring a workbook into Datasets table by table
- Edit data: change numbers in a solved model