How to copy/export data to MS Excel or MS Access
Open Input grids by pressing on the Icon in the top toolbar or by using the menu Edit> Grids.
Select a tab on the grids (example, Input grid> Press/Temp/PipeID)
Select the square in the top most left corner
The entire gride should now be highlighted black.
Press Cntl+C (copy clip to clipboard)
Open MS Excel, blank sheet
In cell A1, press Cntl + V (paste from clipboard)
Open model in AutoPIPE
Please see the following AutoPIPE help section:
Help > Contents> Contents Tab> Command Reference> File Commands> Export> Exporting a Model
Input Database (*.mdb)
Results Database (*.mdb)
Note: Sometimes there are problems associated with copy / pasting to / from the input grids. Sometimes the following is displayed: "Selection type different"
Even if the data looks same as those copied from input grids. The following has been logged, TFS-D170633, Input Grid: Cannot copy data from MS Excel to input grid. Until this has been added, use the following workaround:
Please see the video for workaround. Keyboard shortcuts (Ctrl + C & Ctrl + V) works as well.
Is there a way to copy from Excel back into the AutoPIPE grid? I have a lot of concentrated forces (same magnitude), I would like to change the magnitude of the forces, but keep the directions the same. This would be a simple formula in Excel, but I can't copy the results back into AutoPIPE.