1. Copy data from an external source, such as a Microsoft Excel spreadsheet.
OR
1. Copy data from another measure item in the view. You can copy a single cell of data or multiple cells.
Copy from Single cell – Right-click the cell and select Copy.
Copy from Multiple Cells – To select adjacent cells, click the first cell and while pressing the Shift key, drag your cursor down and/or right to select the area of desired cells. To select non-adjacent cells, click the first cell and while pressing the CTRL key, select the other cells in the grid. When you have selected the last desired cell, right-click it and select Copy.
2. Paste the selected data into planning enabled cells of the measure items that you want to change. The cell or set of cells that you select for the paste will depend on how many values you copied.
Paste a single value into a single cell – Right-click the planning enabled cell and select Paste.
Paste a single value into multiple cells – A single value can be pasted into adjacent or non-adjacent cells.
Adjacent cells - Click the first cell of the area where you want to paste. Press the Shift key while dragging your cursor down and/or right in order to select the remaining cells of the desired paste area. When you have dragged to the last desired cell, right-click in that cell and select Paste.
Non-adjacent cells – Click the first cell and while pressing the CTRL key, click each of the other cells into which you want to paste the value. When you have selected the final cell, right-click and select Paste.
Paste multiple values into multiple, adjacent cells – Multiple values can be pasted into an area that is the same size and shape of the copied area. You can select the paste area or let Stratum.Viewer calculate the area for you based on a single starting point cell that you select.
User selected area – Click the first cell of the area where you want to paste. Press the Shift key while dragging your cursor down and/or right in order to select the remaining cells of the desired paste area. When you have dragged to the last desired cell, right-click in that cell and select Paste.
Viewer calculated area – Right-click a cell that is surrounded by enough planning enabled cells to accept the number of values that was copied, and then select Paste. The single selected cell is used as the starting (top /left) cell for the calculated paste area. Viewer will expand the paste area by rows and columns (down and right) from that starting point cell.
3. See Submit Planning Changes for Processing when you are ready to process all pending changes in the view.
Note: You can also type values directly into planning views. See Enter Planning Changes into the Grid.