River Logiceode docs

Start from your workbook

Hand RIA a planning workbook in a new model's conversation, see how each sheet was read, solve the week it describes, test a change to one of its values, and download your inputs.

Where: Models→+ New→Upload

This walk starts from a spreadsheet instead of a description. RIA, eode's assistant, reads every sheet, asks about what it couldn't settle, maps your rows into a model and solves it. Then you test a change to one of your own values in a what-if, and download the model's inputs in your own sheet layout.

Use the sample, harbor-point-week.xlsx: one week at Harbor Point Bakery. Each sheet is one table with its column names in the first row.

SheetWhat it holds
ItemsSourdough Loaf and Croissant (made), Flour and Butter (bought), with units
RecipeWhat goes into each product: 0.5 kg flour a loaf; 0.1 kg flour and 0.05 kg butter a croissant
PlacesTwo vendors, the bakery and two customers, each typed Vendor, Plant or Customer
Vendor PricesFlour $1.20 a kg from Mill Supply, butter $8.00 a kg from Dairy Co-op
MachinesThe oven at the bakery: 60 hours, $4 an hour to run, $150 fixed
Machine RatesOven hours per unit: 0.25 a loaf, 0.1 a croissant
Customer DemandFor Week 1, what each customer will buy and pays: walk-in 80 loaves at $8 and 200 croissants at $4; Pier Cafe 40 at $7 and 150 at $3.50
Customer LanesDelivery cost from the bakery: walk-in $0, Pier Cafe $0.30 a unit

The Week column on Customer Demand is what makes this a one-week plan. For what RIA reads in your own workbook, see Start from a workbook.

Attach the workbook

In the rail, click + New beside Models. In the new conversation, click Upload beside the message box and choose harbor-point-week.xlsx, or drop it on the box. Its name shows above the box with Uploading, then Added: the workbook is a dataset in Datasets now, and goes with your next message.

Type one sentence on what you want to decide, and press Enter:

Harbor Point Bakery: plan one week of baking from this workbook, to make the most profit.

Sending creates the model, named from your first words: Harbor Point Bakery plan (with a number after it, such as Harbor Point Bakery plan #3, if you already have a model by that name). Its page opens with the conversation on the left and The record on the right.

With no models yet, you can start on Home instead: Upload spreadsheet opens the new conversation with the workbook attached.

See how each sheet was read

RIA reads the whole workbook, then says in the conversation what it found and what it needs from you. On the record's top card, Since your last message lists each part of the model it added from your sheets.

Open Details at the foot of the record, then Data. Under Datasets is your workbook, with Reload. What each data sheet holds gives one sentence for each of the eight sheets; Names gives the name RIA proposed for each part of the model, with Another name to change it.

If a sheet was read wrong, tell RIA in the conversation what it really holds. To rename a part, click Another name under Names. See See how each sheet was read.

Answer what the workbook leaves open

RIA asks in the conversation about what the sheets don't settle, naming the sheet and the cells by what they hold, with each question's answers numbered and the one it proposes marked. It can ask several at once: reply with one number for each, in order (for example 1, 1, 1), or say what's true in your own words. Its questions differ from run to run; on one walk they were the oven's overtime, the units and currency, and delivery of flour and butter to the bakery. Answer from this table:

If RIA asks aboutThe answer
The unit of Qty Per on Recipekg of flour or butter for each loaf or croissant
The vendor PriceDollars per kg
The oven's 60 hours and its $150Per week
The oven's Cost Per HourDollars per hour it runs
Demand and the selling Price on Customer DemandItems a week, and dollars per item
The lane costDollars per item delivered, the same for both products
How many weeks the plan coversOne week, Week 1
Stock at the start, and what carries overNo stock at the start; nothing is kept for the week after
Vendor minimums, lead times, holding costsNone
Oven overtimeNone: 60 hours is the limit for the week
Delivery of flour and butter to the bakeryIncluded in the vendor price
Whether demand must be metDemand is a ceiling: each customer buys up to that many

Each open question also counts under Needs you on the record's top card ("3 answers needed in the chat before the build goes on."), each with Go to the chat. See Answer what your sheets leave open.

Accept the objective and let RIA build

At Objective, RIA proposes the objective in a Your objective card: Maximize profit, the week's sales less flour, butter, the oven's running and fixed costs and delivery to Pier Cafe. Click Accept this objective.

At Check, What this model will do gives the Objective, what It decides, Over (the one week) and Your workbook. If Over says more than one week, tell RIA The plan covers one week: Week 1. With your answers in, nothing waits on you: RIA starts the build itself, and the record's top card reads Your plan: RIA is building the model. Had RIA changed, assumed or left out something, that row would wait on you with Keep it as it is. See Review the design.

Check how each sheet landed

Once RIA has matched the workbook to the model, the Data part says where each number comes from:

  • How your workbook is used: a line for each sheet the plan uses, naming it in your workbook.
  • Rows set aside, when there are any: by sheet, each row the model doesn't use, and why.
  • Assumptions, when there are any: what the model assumed where your sheets and answers are silent.

See Read how your workbook is used.

Read the Base

When the build lands, Where it stands on the record's top card shows your objective over the Base figure: $1,422. That's the week's best plan: it sells all 350 croissants, and the oven's 60 hours leave room for 100 of the 120 loaves ordered, all 80 walk-in loaves and 20 of Pier Cafe's 40.

Test a change to one of your values

In the rail, under your model, click + New beside SCENARIOS. In the New scenario. conversation, type What if Pier Cafe pays $4.00 for croissants instead of $3.50? and press Enter.

Your message makes the what-if, named from your words, and RIA says what it will change: the price Pier Cafe pays for a croissant, from $3.50 to $4.00. The change is the what-if's only; your workbook and the Base stay as they are. If it reads right, type Looks right and send it.

When the run ends, RIA gives the result in the conversation, and the what-if's record reads Solved: $1,497, $75 above the base., with the what-if and the Base side by side under The ladder. Pier Cafe's 150 croissants were already in the plan, so the gain is the extra 50 cents on each, and the record says Same plan as the base.; the oven still runs all 60 of its hours.

To compare several what-ifs at once, tick them on the Scenarios list and click Compare; see Turn a losing week into a plan.

Download your inputs

Open the model's page again: click Harbor Point Bakery plan under Models in the rail. On the record, under Your model, described, click Download inputs. It saves your own eight sheets, under your own names and headers, with the values the model holds, and three columns after yours: Source, Class and Note, which say where each row came from and what became of it. See Download your inputs.

On this page