River Logiceode docs

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.

An Excel workbook (.xlsx) or a CSV file

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:

FromDo
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 yetUpload spreadsheet
A dataset you already importedSelect 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.

PartShows
DatasetsThe workbook the model reads
What each data sheet holdsEach sheet by name, with one sentence of what RIA took it to be, such as orders, capacity, recipes, or results rather than input
NamesWhat 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.

  1. Click Another name.
  2. 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".

PartShows
How your workbook is usedOne line per part of the model: "The plan uses the Recipe sheet in harbor-point-bakery for …"
Rows set asideBy sheet, each row the model doesn't use and why. A long list ends "12 more rows were set aside."
AssumptionsWhat 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

Needs a model open

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:

ColumnHolds
SourceWhere the row came from, as the sheet and row of your workbook, or assumed where the model filled in a value you left blank
ClassDECISION 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
NoteWhat 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 .xlsx or .csv, up to 100 MB.

On this page