Skip to content. | Skip to navigation

You are here: Home → Analyzing Data → Custom Spreadsheets → Viewing a Custom Spreadsheet
 

Viewing a Custom Spreadsheet

To view a Custom Spreadsheet you have previously designed:

  1. Select a spreadsheet node from the Custom Spreadsheet tree.

spreadsheetnode.gif

 

  1. Click the View Spreadsheet button. viewspreadsheetbutton.gif The Set Filters window will open.

set_filters.jpg

 

 

  1. Click the filter button to make changes to the filter parameters from the Select Filter … window.

NOTE: The meter is referred to here as a “logical device.”

  1. Click OK to close the Set Filters… window. The spreadsheet will display in the view panel. To perform an alphanumeric sort by any custom spreadsheet column heading, click on the desired column heading. Click the column heading again to reverse the sort.

Copying to Excel®

To copy custom spreadsheet rows to Excel or another application, select a range of rows and then choose copy from the right-click menu or click the Copy to Clipboard button.

copytoclipboardbutton.gif

Or use the right-click the spreadsheet and click the Copy All option to copy all custom spreadsheet information to the Windows® Clipboard.

Then paste the data into Excel (Ctrl-V keyboard combination or Edit/Paste from the Excel application).

Document Actions

Individual Accounts

Avatar Posted by Denise Martin at Jan 12, 2012 03:00 PM
When I create a custom spreadsheet, it will give me nothing if I filter by site name. When I filter by all, I get data. How do I know which spreadsheet will give me individual site information?

Individual accounts

Avatar Posted by Barry Kroeker at Jan 12, 2012 03:24 PM
Denise,
Part of the difficulty may be with your user permissions. If you as a user do not have access to certain sites (nodes of the Facilities or Accounts tree), then data from those sites will not be available to you for reporting/custom spreadsheets.
If you use multiple report filters in combination, you may be unintentionally excluding all data for the particular site you are interested in. Just some ideas...

Add comment
(Required)
Tell us your name.
(Required)
(Required)
(Required)
Enter the word