Preparing the scenario builder sheet
The scenario builder sheet is the Excel workbook (.xlsx) in which you describe the scenarios you want. Menta reads your answers exactly as you wrote them and writes the scenarios from them, so the more precise the answers, the closer the first version will be to what you have in mind.
Use the template your Menta contact gave you. The questions in it can change over time; what matters for the upload is that the layout below stays intact.
The layout Menta expects
The first tab of the workbook that has a header row is the one that's read. Any other tabs - instructions, lists of options - are left alone. The header row has to have these columns, in this order:
| Column | What goes in it |
|---|---|
| Section | The part of the scenario the question belongs to. It can span several rows. |
| # | The question number. Optional, but keep it - the numbers help Menta. |
| Question | The question itself. |
| Scenario … | One column per scenario, with a header that starts with "Scenario". Add as many as you need. |
Every row that has a question is read. Rows without a question, such as spacers or banners, are ignored.
One column per scenario
Each Scenario column becomes one scenario. When you upload the sheet:
- A column that is completely empty is skipped - nothing is generated for it, and nothing goes wrong.
- A column that is partly filled in is left out, and the upload tells you which questions are still missing an answer.
- A column that is fully filled in is generated.
So you can keep spare columns in the template, but finish every scenario you've started before uploading.
Answers
Write your answers as normal text - long answers are fine, nothing is cut off. Where a cell offers a dropdown, pick one of its options rather than typing your own: Menta reads the choice together with the list it came from, so it knows exactly what you meant.
Before you upload
- Save the workbook as
.xlsx. - Keep it under 10 MB.
- Check that every scenario column you want generated is complete.
When the sheet is ready, continue with Creating scenarios.