How to export input data and results to MS Excel from AutoPIPE?
Let us be clear as of Feb 2018 there is not a direct export feature from AutoPIPE to MS Excel. However there are some fairly easy steps to get both model Input listing and Results output from AutoPIPE into MS Excel.
There are 2 methods:
2. Database files.
One of the many cool feature in AutoPIPE would be the Input Grids and Results Grids. These MS Excel like tables store model input or results information. The user can easily perform many powerful interrogation type commands to quickly review information. Also, in a matter of seconds the information can become available in MS Excel. Let us see exactly how this would work:
Step 1: Select any tab on the Input or Results Grids.
Step 2: Select the top left most cell on the grid
Step 3: With the grid information selected, press CNTL+C to copy the information
Step 4: Open open MS Excel worksheet, making A0 the current cell, press CNTL+P to paste the copied information
Step 5: Done.
See it in action below:
Now let see how to export a database to MS Excel:
Step 1: With model open, select File> Export > Input Database.
Step 2: Now analyze the model, and export the results using File> Export > Results Database
Step 3: In MS Excel, open the Input or Results file directly.
Step 4: Done.
Import and Export - AutoPIPE