Make the interface work for you. With the creation of a Fast Data Interface (FDI), a model can easily be used by anyone. One innovative company turned a model over to a group of their salesmen. Remember, while salesmen have one of the most stressful and difficult jobs in any company, they tend not to be very technically skilled. Despite that, these salesmen were able to use the model to predict the results of various product configuration changes. It worked because the only thing the salesmen saw was a custom interface with simple entries and a button that said “Run.” The whole process took only minutes, but allowed them to make dramatic changes to their system configurations with confidence.
Create a Simple Interface to a Complex Model or Import thousands of lines of data into your model with Fast Data Import (FDI)
FDI allows you to read production schedules or import data directly from company databases. Thousands of lines of data are imported in seconds and can be done as often as the data changes. A group from the US Social Security Administration uses FDI to import the last six months of receipts so that their model can be tested for accuracy. Projected data is then used to drive the model into future months to test possible changes.
General procedure to create and run a FDI interface
Build and validate a model – lock the model to avoid subsequent structure changes.
Export the model structure to a spreadsheet — Use the Tools/Export Data menu option to export all the model data to a spreadsheet.
Create a method of controlling the transfer of information — Create a second spreadsheet that will be used to enter data and control the transfer of data to the ProcessModel Export Spreadsheet. The controlling spreadsheet should do the following.
- Open the ProcessModel Export spreadsheet
- Copy the cells from the Controlling spreadsheet or database to the ProcessModel Export spreadsheet
- Close the ProcessModel Export spreadsheet
- Make ProcessModel the active program
Import into ProcessModel and run – The Excel interface imports the data into ProcessModel and starts the simulation. The user only has to interact with the spreadsheet. Out of a thousand possible things that could change you might decide that only ten parameters are allowed to change.
How Long Does it Take to Create a FDI?
A simple interface can be created in less than 2 minutes. How is that even possible? All the common elements have been designed in to the controlling spreadsheet. You just have to tell the controller what you want to change and design your interface.
We can help you speed the process of developing FDI for your models.