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.
| Sheet | What it holds |
|---|---|
| Items | Sourdough Loaf and Croissant (made), Flour and Butter (bought), with units |
| Recipe | What goes into each product: 0.5 kg flour a loaf; 0.1 kg flour and 0.05 kg butter a croissant |
| Places | Two vendors, the bakery and two customers, each typed Vendor, Plant or Customer |
| Vendor Prices | Flour $1.20 a kg from Mill Supply, butter $8.00 a kg from Dairy Co-op |
| Machines | The oven at the bakery: 60 hours, $4 an hour to run, $150 fixed |
| Machine Rates | Oven hours per unit: 0.25 a loaf, 0.1 a croissant |
| Customer Demand | For 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 Lanes | Delivery 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 about | The answer |
|---|---|
| The unit of Qty Per on Recipe | kg of flour or butter for each loaf or croissant |
| The vendor Price | Dollars per kg |
| The oven's 60 hours and its $150 | Per week |
| The oven's Cost Per Hour | Dollars per hour it runs |
| Demand and the selling Price on Customer Demand | Items a week, and dollars per item |
| The lane cost | Dollars per item delivered, the same for both products |
| How many weeks the plan covers | One week, Week 1 |
| Stock at the start, and what carries over | No stock at the start; nothing is kept for the week after |
| Vendor minimums, lead times, holding costs | None |
| Oven overtime | None: 60 hours is the limit for the week |
| Delivery of flour and butter to the bakery | Included in the vendor price |
| Whether demand must be met | Demand 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.
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.
Related
- Start from a workbook: every part of this path, and the limits on a workbook
- Load your data: attach, add or replace a workbook on a model you've started
- Run a what-if
- Turn a losing week into a plan: the same workbook with a description, Verify and a workspace