How do I enter data into a numeric metric?

You can enter data into a metric for any period that is unlocked. This article describes how to enter data into a numeric metric.

Note: Metric is a replaceable term in PowerSteering. Your organization may use a different label to represent metrics on your site.

1. Enter Data

Data can be entered into any yellow cell on a metric. To enter data into a numeric metric, you simply click on a yellow cell and manually add a value. Data can also be copied from Microsoft Excel and pasted into a PowerSterring metric. When you enter a new value into a metric cell, the cell’s color will change to green. Then, after 4 seconds, the cell’s color will change to bright yellow. The cell will remain bright yellow until you click either the Save Changes button to save your changes or the Reset button to cancel them.

Note: You can enter negative values in a metric by prefixing the value with a minus sign (e.g. -125.00).

1.1. Enter Repeat Values

You have the ability to repeat a value entered in one cell across the row by entering a formula in the cell. The formula uses the character R to repeat the value the specified number of times or up to a specified date.

For example (shown in the screen shot above):

If 500R6 was entered into the a cell; the value 500 is entered in that cell and in the next 5, for a total of 6 cells.

As a second example:

If 100R2015-12 was entered into a cell, the value 100 is entered in that cell and all other cells in that row up through and including the cell in the December 2015 column. If columns indicate just years, not months, you still need to enter a year, the dash, and then any month after the dash to propagate the value into the column for that year.

Note: The repeat function is limited to 60 cells for a monthly view, 20 for quarterly, and 5 for yearly.

1.2. Enter Values Over a Spread

You have the ability to spread a value entered in one cell across the row by entering a formula in the cell. The formula uses the character S to spread the value out over the specified number cells.

For example (shown in the screen shot above):

If 2000S8 was entered into the a cell; the value 2000 is divide by 8 (250) and the resulting value is entered in that cell and in the next 7, for a total of 8 cells.

Note: The spread function is limited to 60 cells for a monthly view, 20 for quarterly, and 5 for yearly.

0 Comments

Add your comment

E-Mail me when someone replies to this comment