HP 3PAR StoreServ 7200 2-node HP 3PAR System Reporter 3.1.0 Software User& - Page 102
Adding Custom Columns to a Data Sheet, Creating a Custom Chart, Non-failed spare, Percent spare used
View all HP 3PAR StoreServ 7200 2-node manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 102 highlights
NOTE: The Visual Basic code for the Excel client is password protected to prevent accidental modification. For customers who would like to add their own code, the password is "password". Please observe caution when considering using another password other than the default, since subsequent access would not be possible if knowledge of the altered password were to become unavailable for some reason. Adding Custom Columns to a Data Sheet The following instructions illustrate how to add custom columns to a data sheet. In this example, you will add the custom columns Non-failed spare and Percent spare used to the Dly PDSpace (1) sheet. In the following section, "Creating a Custom Chart" (page 102), you will create a custom chart using one of these new columns. NOTE: User defined columns can only be added as the last column in the data sheet. To add custom columns to the Dly PDSpace (1) sheet: 1. On the PD Space reporting tool sheet, create a chart with data that spans any time range. The Dly PDSpace (1) sheet is created to hold the data represented in the chart at the bottom of the PD Space reporting tool sheet. 2. On the Dly PDSpace (1) sheet, scroll to the first empty cell to the right of Data table. In cell N52, click and type a new header for Non-failed spare. 3. Below the new header, in cell N53, click and then add a formula to sum the columns that have values for spares that are not failed: =H53+J53+K53 Press ENTER after typing in the formula. A calculated value should appear in cell N53. 4. Click cell N53 and drag the cell selection down so that the formula is copied to all rows of the table. To drag the cell selection down, you must position your pointer over the lower right corner of the cell and then click and drag. Calculated values should appear in all cells of column N. 5. In cell O52, click and type a new header for Percent spare used. 6. Below the new header, in cell O53, add a formula to calculate the percentage of non-failed spare space that is used: =IF(N53>0,H53/N53*100,0) Press ENTER after typing in the formula. A calculated value should appear in cell O53. 7. Click cell O53 and drag the cell selection down so that the formula is copied to all rows of the table. To drag the cell selection down, you must position your pointer over the lower right corner of the cell and then click and drag. Calculated values should appear in all cells of column O. On the PDSpace Time Data sheet, the newly added columns are appropriately resized and populated with values that reflect the most recent query results. Creating a Custom Chart After adding custom columns to a data sheet, you can use those columns to create custom charts. The following instructions illustrate how to create a custom chart from one of the custom Dly PDSpace (1) sheet columns you added in "Adding Custom Columns to a Data Sheet" (page 102). NOTE: The following example uses the XY chart type, which works well for High-Res, Daily, and Hourly resolutions (see "Sample Resolution" (page 67)). Other chart types may not work as expected. For Excel 2003: 102 Accessing and Creating Reports