The following data entry tools are be available in Citywide Budgeting Views and Worksheets.
Data entry tools are accessed by right clicking with the mouse on a selected cell or block of cells.
|
Tool |
Required selection |
Functionality |
| Cut | A cell or block of cells, with a numeric value in the top-left corner | Removes selected data and places it on the clipboard so it can be pasted elsewhere. |
| Copy | A cell or block of cells, with a numeric value in the top-left corner | Copies selected data to the clipboard without removing the original content. |
|
Paste |
One or more cells | Inserts clipboard content into the selected location. |
| History | A single cell | A record of changes made to a data cell, including the previous value, updated value, User, and date/time of the change. | |
|
Replicate |
A block of cells, with a numeric value in the top-left corner |
Replicates the value in the top-left cell of the selection to all other editable cells in the selection. |
|
Clear cells |
One or more editable cells |
Cells in the selection are cleared of any kind of data (text, numeric, date etc.) |
|
Increase / Decrease |
One or more numeric editable cells |
Increases the existing values in the cells by either a percentage or an absolute amount |
|
Compound |
A block of cells, covering more than one column |
For each row, using the value in the cell in the left of the selection as the staring point, each subsequent cell in the row is increased by the specified percentage over the cell immediately to its left. |
|
Spread Rows Evenly |
One or more cells, regardless of column – all rows falling within selection will be evaluated. You must select a column that has "Include Year-To-Date" set. |
This modeling operation only impacts columns which are designated as “Include Year-To-Date” columns in the class. For each row, existing data in the cells is summed and then spread evenly across these columns. |
|
Spread cells evenly |
A block of cells, covering more than one column |
For each row in the block, sums the cells in all the columns and spreads the value evenly to all cells in within the selected block and row. |
|
Spread comparative |
A block of cells, covering more than one column |
Spreads the selected cells within each row by referencing data in the specified comparative version / year for the same cells and spreads the cells to match the distribution in the comparative cells. |
|
Push / pull |
One or more cells |
Moves the values in the selected cells forwards or backwards in the grid (through columns) by the selected value. Will merge values into cells outside the selection area into which a selected value is moved. |
