Copy and paste between Excel and the Mini Inspector

You can copy an array of cell values from Microsoft Excel and paste them into the Mini Inspector. The cell values must be aligned vertically in Excel to copy all the values into the Mini Inspector. You can copy only numerical values from Excel into the values of variables or Real parameters in the Mini Inspector.

You can copy values from the Mini Inspector by using commands on the right-click menu and paste them into Excel. You can copy and paste the follow types of information for your selected variables and parameters:

• Only the values of the variables and parameters

• All the information that you see on the Mini Inspector, including the specification status, name, value, and UOM of the variables and parameters

Copy and paste values from Excel into the Mini Inspector

1. In Excel, select a set of vertically aligned cells of numerical values.

   These values should appear in the same column in Excel. Your selection does not need to be sequential. AVEVA Process Simulation will include the same number of rows between the values as there are in Excel when it pastes the values into the Mini Inspector. A collapsed array of variables in the Mini Inspector counts as a single row. If you want to paste a value into one of the variables in the array, you must expand it in the Mini Inspector.

2. Copy the selection by doing one of the following:

   • Press Ctrl+C.

   • Right-click the selection, and then select Copy.

3. In AVEVA Process Simulation, open the Mini Inspector that contains the values that you want to change.

4. Select the variable or Real parameter that corresponds to the first cell in the selection that you copied from Excel.

5. Paste the values from Excel into the Mini Inspector by doing one of the following:

   • Press Ctrl+V.

   • Right-click the selected variable or Real parameter, and then select Paste Values.

   AVEVA Process Simulation overwrites the values for the variables and Real parameters with the values that you copied from Excel.

Copy and paste values from the Mini Inspector into Excel

6. On the Mini Inspector, select the rows that you want to copy.

   To select consecutive rows, do one of the following:

   • Drag the selection box for the first row in your desired selection onto the last row in your desired selection.

   • Press and hold Shift, select the selection box for the first row in your desired selection, and then select the selection box for the last row in your desired selection.

   To select nonconsecutive rows, press and hold Ctrl, and then select the selection box for all the rows in your desired selection.

7. Do one of the following:

   • Right-click the selection, and then select Copy Values.

   • Press Ctrl+C.

8. In Excel, select the first cell that you want to paste the values into.

9. Do one of the following:

   • Right-click the selected cell, and then select Keep Text Only under Paste Options.

   • Press Ctrl+V.

   The copied values appear in a vertical array starting at the selected cell.

Copy and paste all information from the Mini Inspector into Excel

10. On the Mini Inspector, select the rows that you want to copy.

    To select consecutive rows, do one of the following:

    • Drag the selection box for the first row in your desired selection onto the last row in your desired selection.

    • Press and hold Shift, select the selection box for the first row in your desired selection, and then select the selection box for the last row in your desired selection.

    To select nonconsecutive rows, press and hold Ctrl, and then select the selection box for all the rows in your desired selection.

11. Right-click the selection, and then select Copy All.

12. In Excel, select the first cell that you want to paste the information into.

13. Do one of the following:

    • Right-click the selected cell, and then select Keep Text Only under Paste Options.

    • Press Ctrl+V.

    A table of the copied rows appears, which includes the specification status, name, value, and UOM for all the selected variables and parameters. The first cell in the table displays the name of the model instance that you copied the information from.