Adding a lookup question to a model

Asks for the path and name of a Microsoft® Excel file. You can use lookup questions, in combination with question formulas, to link existing Excel spreadsheets to your model.

Perhaps you have another software package that generates information into an Excel spreadsheet, and you would like to use that information during takeoff. You can ask for the file location and later use a formula to extract the particular information you need. Two functions available in Model Estimating return values from a spreadsheet: Get Cell Number and Get Cell Text. Examples

Before you begin

If you have not already opened the Model window and selected the model you want to work with, do so now. How?

To add a Lookup question to a model:

1. Select a blank line in your model where you want to insert the question.
2. Click to enter a blank lookup question in the model.
3. Place your cursor in the text area of the line, type the actual question, and then press [Enter].

4. (optional) Enter the default value to prefill for the question during takeoff.

   To enter a default answer to the question, you can:

   • Enter the full path of the default. If necessary, click to navigate through the folders on your computer.
   • Use a question or a question formula to calculate the default value during takeoff.
   How?

   Entering default  values using ad hoc formula

   Entering default values using questions formula

   Entering default values using questions

5. (optional) Click to open the Properties window where you can name the question, or enter a helpful note about the question that appears during takeoff.
6. Set up additional lookup questions in the same manner. When you finish, click OK.